熊猫-绘制堆积的条形图

问题描述：

我试图创建一个堆叠的条形图来复制图片，我的所有数据都与该Excel电子表格分开.

I am trying to create a stacked bar graph that replicates the picture, all my data is separate from that excel spreadsheet.

我无法弄清楚如何为其制作一个数据框，如图所示，也无法弄清楚如何制作堆叠的条形图.我找到的所有示例都以与尝试创建的方式不同的方式工作.

I cant figure out how to make a dataframe for it like pictured, nor can I figure out how to make the stacked bar chart. All examples I locate work in different ways to what I'm trying to create.

我的数据框是使用pandas数据框缩小到以下所有值的csv.

My dataframe is a csv of all values narrowed down to the following with a pandas dataframe.

      Site Name    Abuse/NFF
0    NORTH ACTON       ABUSE
1    WASHINGTON         -
2    WASHINGTON        NFF
3    BELFAST            -
4    CROYDON            -

我设法对数据进行总计，并获得每个站点的单独计数，我似乎无法以图形方式将其组合起来.

I have managed to count the data with totals and get individual counts for each site, I just cant seem to combine it in a way to graph.

非常感谢您提供一些有力的指导.

Would really appreciate some strong guidance.

代码已完成，非常感谢您的协助.

Completed code, many thanks for the assistance completing.

test5 = faultdf.groupby(['Site Name', 'Abuse/NFF'])['Site Name'].count().unstack('Abuse/NFF').fillna(0)

test5.plot(kind='bar', stacked=True)

答

您遇到错误，还是不确定从哪里开始?

Are you getting errors, or just not sure where to start?

%pylab inline
import pandas as pd
import matplotlib.pyplot as plt

df2 = df.groupby(['Name', 'Abuse/NFF'])['Name'].count().unstack('Abuse/NFF').fillna(0)
df2[['abuse','nff']].plot(kind='bar', stacked=True)

相关推荐