python 与 mysql
时间：2021-07-01 10:21:17
帮助过：2人阅读
tushare
import pandas
import sqlalchemy
DF = tushare.get_hist_data(
‘sh‘)
DF.drop([‘price_change‘,
‘p_change‘,
‘ma5‘,
‘ma10‘,
‘ma20‘,
‘v_ma5‘,
‘v_ma10‘,
‘v_ma20‘], axis=1, inplace=
True)
DF[‘date‘] =
pandas.DataFrame(DF.index, DF.index)
DF[‘index‘] = pandas.DataFrame([i
for i
in range(0, len(DF))], DF.index)
Engine = sqlalchemy.create_engine(
‘mysql+pyodbc://test:123456@odbcdsn‘)
DF.to_sql(‘sh‘, Engine, if_exists=
‘replace‘, index=False)
python 与 mysql
标签：
