import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
plt.rcParams['font.sans-serif']=['SimHei']
plt.rcParams['axes.unicode_minus']=False
df = pd.read_csv('data.csv',encoding='cp936')
df = df.dropna()
df1 = df[:]
df1['月'] = df1['日期'].map(lambda x:x[5:7])
df1 = df1.groupby('月',as_index=False).agg(np.sum)
print(df1)
plt.figure(figsize=(8,4))
plt.plot(df1['月'],df1['销量'],'b--',linewidth=1.0,label='营业额')
plt.xlabel('月份')
plt.ylabel('营业额(元)'
plt.title('按月份汇总营业额折线图')
plt.grid(True)
plt.savefig('first.jpg')
plt.show()
plt.figure(figsize=(8,4))
plt.bar(df1['月'],df1['销量'])
plt.savefig('second.jpg')
plt.show()