SQLAlchemy将Tushare数据写入数据库

注册tushare，获取token 链接   注册入口

引入SQLAlchemy，Pandas

import tushare as ts
import pandas as ps
from sqlalchemy import create_engine
ts.set_token('your token')
pro = ts.pro_api()
data = pro.stock_basic(exchange='', list_status='L', fields='ts_code,symbol,name,area,industry,list_date')
print(data)
engine = create_engine('mssql+pymssql://root:password@127.0.0.1:1433/test',echo=True) 
engine.connect()
# data.to_sql('gpdata',con=engine,index=False)
f=pro.daily(ts_code='300177.SZ',start_date='20110101',end_date='20210501')
print(f)
f.to_sql('zss',con=engine,index=False) #zss为表名
# （“数据库类型+数据库驱动名称：//用户名：密码@数据库服务器的名称或IP地址：端口号/数据库名称”）
# zhishu=pro.index_basic()
# print(zhishu)

补充完整版

import tushare as ts
import pandas as pd
import time
from sqlalchemy import create_engine
engine = create_engine('mssql+pymssql://sa:123456@127.0.0.1:1433/fenben',echo=True) 
engine.connect()
ts.set_token('**********')
pro = ts.pro_api()
summary = pro.stock_basic(exchange='', list_status='L', fields='ts_code,symbol,name,area,industry,list_date')
# f=summary.to_excel('D:/Users/Desktop/test.xlsx')
# print(summary)
sdata=pd.DataFrame(summary)
for i in range(len(sdata['ts_code'])):
    a=sdata['ts_code'][i]
    etime=time.strftime("%Y%m%d", time.localtime())
    f=pro.daily(ts_code=a,start_date='20110101',end_date=etime)
    data=pd.DataFrame(f)
    data['trade_date'] = data['trade_date'].apply(pd.to_datetime)
    data['close'] = data['close'].apply(pd.to_numeric)
    data.to_sql(a,con=engine,index=False)