在讀取數(shù)據(jù)時候，需要輸入你自己的token

import pandas as pd import pymysql from sqlalchemy import create_engine engine = create_engine("mysql+pymysql://root:root@127.0.0.1:3306/stock1?charset=utf8") import tushare as ts cons = ts.get_apis() #輸入你自己的token!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ts.set_token('46fcca1e059c38cde5f56fe7748f53c274036cb8cf0c061c2056alg690') pro = ts.pro_api() pp=pro.daily_basic(ts_code='', trade_date='20190418') code=list(pp['ts_code'])def savek(k):df = pro.daily(ts_code=k,adj='qfq', start_date='20100101', end_date='20190418')df.to_sql(name = 'dailykt',con = engine,if_exists = 'append',index = False,index_label = False)for h in code:print(h)savek(h)

總結(jié)

以上是生活随笔為你收集整理的dailykt爬取tushare 数据存入本地mysql的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。