将dataframe写入MySQL数据库
from sqlalchemy import create_engine
engine = create_engine(
'mysql+pymysql://root:root@127.0.0.1:3306/database?charset=utf8')
df.to_sql('tablename',con = engine,schema = 'database',index=False,
if_exists='replace', chunksize=10000)
if_exists = [‘replace’,‘append’,‘fail’]