我正在嘗試對四列進行分組和排序，計算值并將它們繪制在同一個條形圖中，以查看計數(shù)如何變化的趨勢。Year Month Bl_year Month2018 Jan 2019 Jan 2018 Feb 2018 Mar2018 Dec 2020 Dec 2019 Apr 2019 Sep 2020 Nov 2020 Dec 2019 Sep 2018 Jan我嘗試先對值進行分組和排序，然后按年計算值，然后按月計算值。df_Activity_count = df.sort_values(['year','month'],ascending = True).groupby('month')df_Activity_count_BL = df.sort_values(['BL year','BL month'],ascending = True).groupby('BL month')現(xiàn)在我試圖在同一個欄中比較這兩個。有人可以幫忙嗎。
2 回答
心有法竹
TA貢獻1866條經(jīng)驗 獲得超5個贊
嘗試傳遞ax給您的繪圖命令：
df_Activity_count = df.sort_values(['year','month'],ascending = True).groupby('month')
df_Activity_count_BL = df.sort_values(['BL year','BL month'],ascending = True).groupby('BL month')
ax = df_Activity_count.years.value_counts().unstack(0).plot.bar()
df_Activity_count_BL['BL year'].value_counts().unstack(0).plot.bar(ax=ax)
喵喵時光機
TA貢獻1846條經(jīng)驗 獲得超7個贊
既然你標記matplotlib了，我將使用一個解決方案pyplot
import matplotlib.pyplot as plt
# Create an axis object
fig, ax = plt.subplots()
# Define dataframes
df_Activity_count = df.sort_values(['year','month'],ascending = True).groupby('month')
df_Activity_count_BL = df.sort_values(['BL year','BL month'],ascending = True).groupby('BL month')
# Plot using the axis object ax defined above
df_Activity_count['year'].value_counts().unstack(0).plot.bar(ax=ax)
df_Activity_count_BL['BL year'].value_counts().unstack(0).plot.bar(ax=ax)
添加回答
舉報
0/150
提交
取消