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

柔光的暖阳◎ 2022-04-03 14:50 174阅读 0赞

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)