How to plot histogram with data prepared in Pandas DataFrame?

Question

I have a Pandas DataFrame in the form of:

hour   activity
1      23
2      334
3      345
...
23     24
24     12

I just want to plot a histogram with 1-24 as bins and corresponding activity as value (height). Is there any simple way doing this in Pandas?

Alex Riley · Accepted Answer · 2014-11-09 16:13:51Z

2

I think you could use df.plot for this:

df.plot('hour', 'activity', kind='bar')

This uses 'hour' values as the x-axis and 'activity' as the y-axis, specifying that a bar chart should be drawn.

Example:

>>> hour = range(1, 25)
>>> activity = np.random.randint(1, 10, 24)
>>> df = pd.DataFrame({'hour': hour, 'activity': activity})
>>> df.plot('hour', 'activity', kind='bar');

Which produces:

enter image description here

edited Nov 9, 2014 at 16:13

answered Nov 9, 2014 at 16:07

Alex Riley

178k46 gold badges274 silver badges247 bronze badges

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

Comments

user308827 · Accepted Answer · 2014-11-09 16:08:57Z

1

You can use:

df.plot('hour','activity',kind='bar',rot=0)

where df is your dataframe, rot is added to rotate the labels

edited Nov 9, 2014 at 16:08

answered Nov 9, 2014 at 16:01

user308827

22.4k98 gold badges284 silver badges443 bronze badges

1 Comment

Hello lad Over a year ago

that doesn't work, when hour is index? because when I used df.hist(), it takes my activity as bins and hour as y value

Collectives™ on Stack Overflow

How to plot histogram with data prepared in Pandas DataFrame?

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