import matplotlib.pyplot as plt
import pandas as pd
data = pd.read_excel('trd.xlsx')
data
datanew = data[(data.股票代码==600000)&(data.交易日期>='2017-01-03')&(data.交易日期<='2017-01-20')]
datanew
`
```python
fig = plt.figure(figsize=(20,10))
plt.plot(datanew.交易日期,datanew.收盘价)
plt.xlabel('交易日期',fontproperties='simhei')
plt.ylabel('收盘价',fontproperties='simhei')
plt.xticks(datanew.交易日期)
plt.show()
fig = plt.figure(figsize=(20,10))
plt.bar(datanew.交易日期,datanew.交易量)
plt.xlabel('交易日期',fontproperties='simhei')
plt.ylabel('收盘价',fontproperties='simhei')
plt.xticks(datanew.交易日期)
plt.show()
data.交易日期 =pd.to_datetime(data.交易日期)
data1 = data.resample('M',on='交易日期').sum()
data1
data1 = data1.reset_index(drop=False)
data1
fig = plt.figure(figsize=(18,10))
plt.pie(data1.交易量,labels=data1.index,autopct='%1.2f%%')
plt.legend()
plt.show()
plt.figure(figsize=(30,10))
ax1 = plt.subplot(131)
ax2 = plt.subplot(132)
ax3 = plt.subplot(133)
ax1.plot(datanew.交易日期,datanew.收盘价)
ax2.bar(datanew.交易日期,datanew.交易量)
ax3.pie(data1.交易量,labels=data1.index,autopct='%1.2f%%')
plt.legend()
plt.show()