Pandas csv 存数据库

import sqlalchemy
import  pandas as pd

db=sqlalchemy.create_engine('mysql+pymysql://root:cyb123@localhost:3306/test?charset=utf8')
df =pd.read_csv('2.csv',encoding='utf-8')
df.to_sql('ccc',db,index=False)

无需建表（库要先建）

'cccc'为表名