Turning Pandas DataFrame into Histogram Using Matplotlib

Question

I have a Pandas DataFrame which has a two columns, pageviews and type:

    pageviews   type
0   48.0        original
1   1.0         licensed
2   181.0       licensed
...

I'm trying to create a histogram each for original and licensed. Each histogram would (ideally) chart the number of occurrences in a given range for that particular type. So the x-axis would be a range of pageviews and the y-axis would be the number of pageviews that fall within that range.

Any recs on how to do this? I feel like it should be straightforward...

Thanks!

there are a few straight-forward ways of doing this. what have you tried and which documentation have you read? — Paul H
– Paul H, Commented Jun 19, 2017 at 15:17

jack6e · Accepted Answer · 2017-06-19 15:56:09Z

4

Using your current dataframe: df.hist(by='type')

For example:

# Me recreating your dataframe
pageviews = np.random.randint(200, size=100)
types = np.random.choice(['original','licensed'], size=100)

df = pd.DataFrame({'pageviews': pageviews,'type':types})

# Code you need to create faceted histogram by type
df.hist(by='type')

pandas.DataFrame.hist documentation

edited Jun 19, 2017 at 15:56

answered Jun 19, 2017 at 15:34

jack6e

1,51211 silver badges12 bronze badges

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

2 Comments

ImportanceOfBeingErnest Over a year ago

If you can create the dataframe like

pageviews = np.random.randint(200, size=100); types = np.random.choice(['original','licensed'], size=100); df = pd.DataFrame({'pageviews': pageviews,'type':types})

it would be more understandable.

jack6e Over a year ago

Oh, good point. I'll make that edit. I assume the OP does not need my setup code, but that's still a good fix.

Collectives™ on Stack Overflow

Turning Pandas DataFrame into Histogram Using Matplotlib

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related