#pandas + sqlalchemy
from sqlalchemy import create_engine
import pandas as pd
data = pd.read_csv('./tianchi_***.csv')
print(data.shape)#(12256906,6)
engine = create_engine('mysql+pymysql://root:wws666@localhost:3306/user**')
data = pd.read_csv('./tianchi_***.csv')
data.to_sql('user_table',engine,chunksize=100000,index=None)
#print('存入成功!')
sqlalchemy 数据写入 MySQL
于 2022-11-15 12:14:56 首次发布