daily_basic爬取tushare 数据存入本地mysql

import pandas as pd
import pymysql
from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://root:root@127.0.0.1:3306/stock?charset=utf8") 
import tushare as ts 

ts.set_token('46fcca1e059c38cde5f56fe7748f53c274036cb8cf0c061c2056alg690')
pro = ts.pro_api()

jyrl=pro.trade_cal(exchange='', start_date='20100101', end_date='20190418')
jyrl1=jyrl[jyrl.is_open==1]

jyrl2=list(jyrl1.cal_date)

for jy in jyrl2:
    df = pro.daily_basic(ts_code='', trade_date=jy, 
        fields='ts_code,trade_date,turnover_rate,turnover_rate_f,volume_ratio,pe,pe_ttm,pb,ps,ps_ttm,total_share,float_share,free_share,total_mv,circ_mv')
    llk=['ts_code','trade_date','turnover_rate','turnover_rate_f',
         'volume_ratio','pe','pe_ttm','pb','ps','ps_ttm','total_share','float_share','free_share','total_mv','circ_mv']
    
    df1=df[llk]
    print(jy)
    df.to_sql(name = 'daily_basic',con = engine,if_exists = 'append',index = False,index_label = False)