import pymysql
import pandas as pd
import numpy as np
import datetime

def tp_data():
    #获取数据
    db=pymysql.connect(host=,port=3306,user=,password=)
    cursor=db.cursor()
    cursor.execute()
    data=cursor.fetchall()
    data_dict=[]
    for field in cursor.description:
        data_dict.append(field[0])
    return data,data_dict
DF=tp_data()[0] # 表数据
columns=tp_data()[1] # 表头 

更多推荐

python获取mysql表头名称