废话不多说,直接上代码:
#!/usr/bin/env python3
#-*- coding:UTF-8 -*-
import pandas as pd
df = pd.read_excel("/Users/jujuz/Desktop/job_info.xlsx")
df.index.name = "ID"
#print(df.head())
from sqlalchemy import create_engine
engine = create_engine("mysql+mysqlconnector://root:12345678@127.0.0.1:3306/test", echo=False)
df.to_sql(name='job_info', con=engine, if_exists="replace")
原excel文档数据:
最终效果: