使用Tushare把股票数据存入csv文件(用截至发文时最新版的接口):
直接上代码:
import pandas as pd
import tushare as ts
pro = ts.pro_api()
#tushare pro官网上注册自己的账号,成功之后就有了token
pro = ts.pro_api('your token here') #把这里的your token here 替换为你自己的token哈,我的token就不展示了
df = pro.daily(ts_code='000001.SZ', start_date='20180701', end_date='20180718')
print('df:\n', df)
df.to_csv('000001.SZ.csv')
# 直接读出csv文件
df1 = pd.read_csv('000001.SZ.csv')
# 用date作索引,并把它由字符串转为date对象
df2 = pd.read_csv('000001.SZ.csv', index_col='trade_date',
parse_dates=['trade_date'])
# 只读取指定的列
df3 = pd.read_csv('000001.SZ.csv', index_col='trade_date',
parse_dates=['trade_date'])[['open', 'close', 'high', 'low']]
# 看一看读的效果
print('df1:\n', df1)
print('df2:\n', df2)
print('df3:\n', df3)
运行结果:
df:
ts_code trade_date open high ... change pct_chg vol amount
0 000001.SZ 20180718 8.75 8.85 ... -0.02 -0.23 525152.77 460697.377
1 000001.SZ 20180717 8.74 8.75 ... -0.01 -0.11 37535