湖南财务大数据比赛代码2018-12-20

18题找珠江啤酒的数据并且画折线图

import tushare as ts
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib.dates as mdate
import numpy as np
plt.rcParams['font.sans-serif']=['SimHei'] #用来正常显示中文标签
plt.rcParams['axes.unicode_minus']=False #用来正常显示负号

data=ts.get_k_data('002461',start='2016-03-01',end='2017-12-31',ktype='M',autype=None)
print(data)


#print(data['date'])
#print(data['close'])

result=pd.concat([data['date'], data['close']], axis=1)

print(result)
result.to_csv(r'D:\bigdata\珠江啤酒无复权收盘价已清洗.csv')

x_ticks=data['date']
print(x_ticks)

fg1=plt.figure(figsize=(8,7))
#tushare,import,savefig,figure,get_k_data,figsize,plot,index
plt.title('收盘价折线图')

data['close'].plot(label='收盘价')



plt.xticks(np.arange(2,24),x_ticks,rotation = 60)
plt.legend()
fg1.show()
fg1.savefig(r'D:\bigdata\收盘价折线图.png',format='png')

19题同样是珠江啤酒的需要排个序

import tushare as ts

data=ts.get_k_data('002461',start='2016-03-01',end='2017-12-31',ktype='M',autype=None)
data1=data.sort_values(axis = 0,ascending = False,by=['date'])
print(data1)
data1.to_csv('19.csv')

29题找三家公司的年末收盘价

import tushare as ts

data0=ts.get_k_data('000021',start='2017-12-28',end='2017-12-31',autype=None)
print(data0)

data1=ts.get_k_data('603703',start='2017-12-28',end='2017-12-31',autype=None)
print(data1)

data2=ts.get_k_data('603855',start='2017-12-28',end='2017-12-31',autype=None)
print(data2)