我有以下格式的数据,我想做的是:
1)遍历Region中的每个值
2)对于每个区域,绘制汇总(跨类别)销售数字的时间序列.
Date |Region |Category | Sales
01/01/2016| USA| Furniture|1
01/01/2016| USA| Clothes |0
01/01/2016| Europe| Furniture|2
01/01/2016| Europe| Clothes |0
01/02/2016| USA| Furniture|3
01/02/2016| USA|Clothes|0
01/02/2016| Europe| Furniture|4
01/02/2016| Europe| Clothes|0 …
该图应看起来像附件(在Excel中完成).
但是,如果我尝试使用以下代码在Python中执行此操作,则当我真的希望所有线条都显示在一个图中时,会得到多个图表.
Python代码:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df = pd.read_csv(r'C:\Users\wusm\Desktop\Book7.csv')
plt.legend()
for index, group in df.groupby(["Region"]):
group.plot(x='Date',y='Sales',title=str(index))
plt.show()