pandas读取mysql、xlsx、txt数据

    科技2024-01-09  70

    """ 读取txt文件 fpath = "datas/crazyant/access_pvuv.txt" pvuv = pd.read_csv( fpath, sep="\t", header=None, names=['pdate','pv','uv'] ) print(pvuv) """ """ 读取mysql import pymysql conn = pymysql.connect( host='127.0.0.1', user='root', password='root', database='gplhellodjango', charset='utf8' ) mysql_page = pd.read_sql("select * from test",con=conn) print(mysql_page) """ """ 读取execel文件 fpath = "datas/crazyant/access_pvuv.xlsx" pvuv = pd.read_excel(fpath) print(pvuv) """
    Processed: 0.010, SQL: 9