python 与 mysql
标签：
python 与 mysql
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)