import MySQLdb# 创建数据库连接conn = MySQLdb.connect(host='localhost', user='root', passwd='1234512435', db='lianxi', port=3306,charset='utf8')# 创建数据库游标对象cursorcur = conn.cursor()# 在向表test插入数据之前先清空表cur.execu

import pandas as pd# 导入pandas模块# 解决数据输出时列名不对齐的问题pd.set_option('display.unicode.east_asian_width',True)df = pd.read_excel('data.xlsx')# 读取excel文件print(df.head())