Histogram on Pandas groupby with matplotlib

Question

I have datafrme on which I perform groupby on two columns:

ax = df_all.groupby(['Component', 'SubComponent' ])['SubComponent'].count()

And this give me this:

--------------------------------------------------
| Component | SubComponent|                      |
--------------------------------------------------
|A          |First        |                     1|
--------------------------------------------------
|           |Second       |                    10|
--------------------------------------------------
|           |Third        |                     6|
--------------------------------------------------
|B          |First        |                     8|
--------------------------------------------------
|           |Second       |                     5|
--------------------------------------------------
|           |Third        |                    17|
--------------------------------------------------

Now I would like to make a histogram out of it. Each bar would be Component and each component would divided on SubComponents showing number of occurrence of each SubComponent with different color.

Is there easy way to accomplish it with matplotlib.pyploy ?

Thanks, Submi

score 3 · Accepted Answer · edited Sep 27 '17 at 16:46

3

You can use unstack with DataFrame.plot.bar:

print (ax.unstack())
SubComponent  First  Second  Third
Component                         
A                 1       4     15
B                 6       2      1

ax.unstack().plot.bar(stacked=True)

print (ax.unstack(0))
Component      A  B
SubComponent       
First          1  6
Second         4  2
Third         15  1

ax.unstack(0).plot.bar(stacked=True)

Notice:

What is the difference between size and count in pandas?

edited Sep 27 '17 at 16:46

Graham

7,431
18
59
84

answered Apr 21 '17 at 09:43

jezrael

822,522
95
1,334
1,252

Do you possible know why I'm not able to change size of this plot using: plt.figure(figsize=(10, 8)) on it? – Submi Apr 21 '17 at 11:50
1

Try `ax.unstack().plot.bar(stacked=True, figsize=(10, 8))` – jezrael Apr 21 '17 at 11:53

Histogram on Pandas groupby with matplotlib

1 Answers1