stata 表转mysql

* 加载一个Stata数据集
sysuse auto

* 在Stata中执行Python代码
python:
import pandas as pd
import pymysql
import stata_setup

stata_setup.config("c:\python37\python.exe", "d:\stata17\")

# 将Stata数据集转换为Pandas DataFrame
df = pd.read_stata(stata_setup.stata_path('_dta', 'auto.dta'))

# 连接到MySQL数据库
conn = pymysql.connect(host='localhost', user='your_username', password='your_password', db='your_database')

# 将DataFrame保存到MySQL数据库中
df.to_sql(name='auto', con=conn, if_exists='replace', index=False)

# 关闭数据库连接
conn.close()
end