第一步:导入两个模块
pip install sqlalchemy
pip install mysql-connector-python
第二步:编写代码
import pandas as pd
from sqlalchemy import create_engine
datas = pd.DataFrame(....);
engine = create_engine("mysql+mysqlconnector://root:123456@localhost:3306/test?charset=utf8");
con = engine.connect()
datas.to_sql(name="mytab", con=con, if_exists="append")
con.close()