熊猫从条形图变为堆积条形图

我试图在当月之前在上方绘制这些数据。但我想将它们堆叠在色相部分上

这是数据:

    activity Month  hue     activity Hours
0   Apr-19          110     212.00
1   Apr-19          120     1060.00
2   Apr-19          Other   35381.25
3   May-19          110     2494.00
4   May-19          120     824.00
5   May-19          Other   31722.50
6   Jun-19          110     1792.00
7   Jun-19          120     1521.00
8   Jun-19          Other   27708.50
9   Jul-19          110     688.00
10  Jul-19          120     476.00
11  Jul-19          Other   34283.50
12  Aug-19          110     270.00
13  Aug-19          120     352.00
14  Aug-19          Other   21359.90

这是我现在绘制它们的代码。

import pandas as pd

data = [['Apr-19','110',212],['Apr-19','120',1060.00],'Others',35381.25],['May-19',2494.00],824.00],31722.50],['Jun-19',1792.00],1521.00],27708.50],['Jul-19',688.00],476.00],34283.50]]
df1 = pd.DataFrame(data,columns = ['activity Month','hue','activity Hours'])

df2 = df1.groupby(['activity Month'])['activity Hours'].sum()

plt.ylabel('activity Hours')
plt.xlabel('Month')
sns.barplot(x='activity Month',y='activity Hours',hue='hue',data=df1)

熊猫从条形图变为堆积条形图

我想像下面的插图一样堆叠它们:

熊猫从条形图变为堆积条形图

a191387072 回答:熊猫从条形图变为堆积条形图

df1 = pd.DataFrame(data,columns = ['Activity Month','hue','Activity Hours'])
df2 = df1.groupby(['Activity Month',"hue"])['Activity Hours'].sum().unstack("hue")

ax = df2.plot(kind='bar',stacked=True)
plt.show()

结果:

enter image description here

本文链接:https://www.f2er.com/3147692.html

大家都在问