小试牛刀可视化

import pandas as pd

import numpy as np

import matplotlib.pyplot as plt

data=pd.read_excel('/data/trd.xlsx',engine="openpyxl")

print(data.columns)

print(data.iloc[:5])

dt=data.loc[data['股票代码']==600000,['交易日期','收盘价','交易量']]

I1=dt['交易日期'].values>='2017-01-03'

I2=dt['交易日期'].values<='2017-01-20'

dta=dt.iloc[I1&I2,:]

y1=dta['收盘价']

x1=range(len(y1))

plt.figure(1)

plt.plot(x1,y1)

plt.xlabel(u' date ',fontproperties='SimHei')

plt.ylabel(u' Closing_Price ',fontproperties='SimHei')

plt.title(u' Closing_Price_State ',fontproperties='SimHei')

plt.savefig('1.png')

I3=dt['交易日期'].values>='2017-01-03'

I4=dt['交易日期'].values<='2017-01-24'

dta=dt.iloc[I3&I4,:]

y2=dta['交易量']

x2=range(len(y2))

plt.figure(2)

plt.bar(x2,y2)

plt.xlabel(u' date ',fontproperties='SimHei')

plt.ylabel(u' Volume ',fontproperties='SimHei')

plt.title(u' Volume_State ',fontproperties='SimHei')

plt.savefig('2.png')

D=np.zeros((11))

list1=list()

for m in range(11):

    m=m+1

    if m<10:

        m1='2017-0'+str(m)+'-01'

        m2='2017-0'+str(m)+'-31'

        mon='0'+str(m)

    else:

        m1='2017-'+str(m)+'-01'

plt.figure(4)

plt.figure(figsize=(14,6))

plt.subplot(1,3,1)

plt.plot(x1,y1)

plt.xlabel(u' date ',fontproperties='SimHei')

plt.ylabel(u' Closing_Price ',fontproperties='SimHei')

plt.title(u' Closing_Price_State ',fontproperties='SimHei')

plt.subplot(1,3,2)

plt.bar(x2,y2)

plt.xlabel(u' date ',fontproperties='SimHei')

plt.ylabel(u' Volume ',fontproperties='SimHei')

plt.title(u' Volume_State ',fontproperties='SimHei')

plt.subplot(1,3,3)

plt.pie(D,labels=list1,autopct='%1.2f%%') # 保留小数点后两位

plt.title(u' Month_Volume_State ',fontproperties='SimHei')

plt.savefig('4.png')