适合练习pandas的Tushare

Tushare大数据开放社区,免费提供各类金融数据和区块链数据,助力智能投资与创新型投资。

博主推荐专属链接(成功推荐注册一个有效用户，获得50分), 积分越高, 数据接口权限越大, 注册后完善基础信息就可以使用股票历史日行情线, 包括开盘收盘价涨跌额等信息, 大家不用担心,博主想获得上市公司管理层信息需要积分, 望大家助力

同时数据非常适合练习pandas

获取日行情线方法

#!/usr/bin/python3
# -*-coding:UTF-8-*-

import pandas as pd
import tushare as ts
import time

# 注册后个人主页获取 token
ts.set_token('*******')
pro = ts.pro_api()

# 查询当前所有正常上市交易的股票列表
# data = pro.stock_basic(exchange='', list_status='L', fields='ts_code')

# all ts_code 2 csv, 把所有的股票代码存下方便后续获取数据
# data.to_csv('stock_basic/all_ts_code.csv', index=False, header=False)

# 股票基本信息
# data = pro.query('stock_basic', exchange='', list_status='L', fields='ts_code,name,fullname,industry,market,curr_type')
# data.sort_values('ts_code', inplace=True, ascending=True)
# data.to_csv('txt/6.csv', header=True,index=False)

all_ts_code = pd.read_csv('stock_basic/all_ts_code.csv', header=None)
print(all_ts_code.head())

# 日线行情按 ts_code写入 csv
for i in all_ts_code.index:
    ts_code = all_ts_code.loc[i, 0]
    data = pro.daily(ts_code=ts_code, start_date='20200101')
    data.sort_values('trade_date', inplace=True, ascending=True)
    data.to_csv('data/{}.csv'.format(ts_code), index=False, header=False,mode='a')
    time.sleep(0.13)

名称	描述
ts_code	股票代码
trade_date	交易日期
open	开盘价
high	最高价
low	最低价
close	收盘价
pre_close	昨收价
change	涨跌额

ts_code,trade_date,open,high,low,close,pre_close,change
000001.SZ,20200102,16.65,16.95,16.55,16.87,16.45,0.42,2.5532,1530231.87,2571196.482
000001.SZ,20200103,16.94,17.31,16.92,17.18,16.87,0.31,1.8376,1116194.81,1914495.474
000001.SZ,20200106,17.01,17.34,16.91,17.07,17.18,-0.11,-0.6403,862083.5,1477930.193
000001.SZ,20200107,17.13,17.28,16.95,17.15,17.07,0.08,0.4687,728607.56,1247047.135
000001.SZ,20200108,17.0,17.05,16.63,16.66,17.15,-0.49,-2.8571,847824.12,1423608.811
000001.SZ,20200109,16.81,16.93,16.53,16.79,16.66,0.13,0.7803,1031636.65,1725326.806

使用 股票基本信息接口 做的 A股行业分布

#!/usr/bin/python3
# -*-coding:UTF-8-*-

import pandas as pd
import matplotlib as mpl
import matplotlib.pyplot as plt

mpl.rcParams['font.sans-serif'] = ['KaiTi']
mpl.rcParams['font.serif'] = ['KaiTi']
mpl.rcParams['axes.unicode_minus'] = False

def autolabel(rects):
    for rect in rects:
        height = rect.get_height()
        plt.text(rect.get_x() + rect.get_width() / 2, height, height,size=8)

df = pd.read_csv('txt/7.csv')
print(df.head())

df = df[['industry','ts_code']].groupby('industry').count()
df.sort_values('ts_code', inplace=True, ascending=False)
rect = plt.bar(df.index, df['ts_code'],alpha=0.3,color=['b','g','r','c','m','y','k'])
plt.xticks(rotation=90)
autolabel(rect)
plt.title('A股行业分布')
plt.xlabel('所属行业',rotation='horizontal')
plt.ylabel('上市数量',rotation='vertical')
plt.show()