在pandas数据框中有两列的数据.一列是可以重复的月份，另一列是购买量.每月需要总额

Question

我如何从这个数据框架中提取数据，以便我可以看到每月的总支出，并显示每月支出的条形图。

Month Column      Expenditures Column        Type Column
Jan               3.19                       Food
Jan               7.18                       Travel
Feb               15.55                      Food
Mar               11.87                      Entertainment
Mar               12.88                      Food
etc.....

还想按月显示总数

Answer 1

按月显示总支出:

df2 = df.groupby('Month Column')['Expenditure Column'].sum().reset_index()
print(df2)

打印:

Month Column  Expenditure Column
0          Feb               15.55
1          Jan               10.37
2          Mar               24.75

用条形图表示:

import matplotlib.pyplot as plt
plt.bar(df2['Month Column'], df2['Expenditure Column'])
plt.show()

按类型显示每月支出:

df3 = df.groupby(['Month Column', 'Type Column'])['Expenditure Column'].sum().reset_index()
print(df3)

打印:

Month Column    Type Column  Expenditure Column
0          Feb           Food               15.55
1          Jan           Food                3.19
2          Jan         Travel                7.18
3          Mar  Entertainment               11.87
4          Mar           Food               12.88