Creating bar plot using dataframe with multi-indexing

Question

I have the following dataFrame:

         Score
one  A     8
     B    19
     D    29
two  C    18
     A    10
     B     4
     D     2
six  C     4
     A     4
     B     4

And I wish to create one bar plot where X axis values are "one", "two" and "six", and each value has 4 bars (A,B,C,D) when the bar height determined by the score column.

Thank you. Nastya

Can you show the code you have tried?

IanS
– IanS

2016-12-19 14:03:28 +00:00
Commented Dec 19, 2016 at 14:03 — IanS
– IanS, Commented Dec 19, 2016 at 14:03

jezrael · Accepted Answer · 2016-12-19 14:30:20Z

2

You need unstack for reshaping with DataFrame.plot.bar:

import matplotlib.pyplot as plt

df.unstack()['Score'].plot.bar()

plt.show()

answered Dec 19, 2016 at 14:30

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MMF · Accepted Answer · 2016-12-19 14:09:20Z

0

Try the following :

df.unstack(level=1).plot(kind='bar')

answered Dec 19, 2016 at 14:09

MMF

5,9703 gold badges18 silver badges20 bronze badges

1 Comment

Nastya Over a year ago

Thanks! The graph worked, however why in the legend I have values like - (0,A), (0,B),(0,C) and(0,D), instead A,B,C,and D? Is it possible to print above each bar A/B/C/D ?

Collectives™ on Stack Overflow

Creating bar plot using dataframe with multi-indexing

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related