How do I get a bar chart by pandas dataframe axis python

Question

Consider the following dataframe, this is what it looks like on jupyter notebook:

in(1): df

out(1):

months          0   1   3   6   12

        name                    
------------------------------------
     janedoe    1.0 3.0 3.0 2.0 1.0
     johndoe    3.0 2.0 3.0 1.0 1.0
     tfbundy    1.0 3.0 3.0 3.0 3.0
     someone    1.0 2.0 3.0 4.0 4.0
     another    1.0 2.0 2.0 3.0 2.0
         ...    ... ... ... ... ...

etc 700 rows. I wish to create a bar chart with stdev error bars where on the y-axis is the mean score (1.0, 3.0 etc) of each month column and on the x-axis are the months (0,1,3,6,12). How do I do this?

Thank you.

Ami Tavory · Accepted Answer · 2018-04-21 18:13:17Z

2

The easiest way would be through seaborn.barplot, as it creates error bars and other nice stuff.

First, melt the DataFrame:

m = pd.melt(df).rename(columns={'variable': 'month'})

This will create a DataFrame with two columns: month and value. Now plot it:

import seaborn as sns

sns.barplot(x='month', y='value', data=m)

For the data in your sample, it will look like this:

answered Apr 21, 2018 at 18:13

Ami Tavory

76.7k13 gold badges152 silver badges196 bronze badges

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

1 Comment

eepee123 Over a year ago

Thank you very much. This solved my problem. Didn't occur to me to melt the dataframe.

Collectives™ on Stack Overflow

How do I get a bar chart by pandas dataframe axis python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related