import pandas as pd
from sqlalchemy import create_engine
#需要安装pandas,sqlalchemy,pymysql,并mysql数据库创建test库
df = pd.read_excel('data/123.xlsx')
engine = create_engine('mysql+pymysql://root:123456@localhost:3306/test?charset=utf8')
df.to_sql(name='df'
python将DateFrame对象数据存储到mysql
最新推荐文章于 2023-05-12 16:00:55 发布