Pandas, Histogram Plotting With Subplots Based on Column Values

Question

I have a panda data table that looks something like this:

Panda Table

And it goes on through over a ton of rows. There's something like 30 or 40 different properties that I want to look at individually.

I'm looking to create a histogram for each individual property based on duration. So a histogram for property A, property B, property C, and so on....

I know how to do it for all properties, as seen in my below code:

df['duration'].plot(kind='hist', sharex=False, use_index=False, bins=100)
plt.show()

This is the histogram of all properties

Any ideas on how I might go about this?

So I've done that, how do I get it to work if there is more than two columns. I did it just now and it is pulling a histogram for each column with numerical values. (so it's producing multiple histograms for each property). How can I create just one histogram for each property based on duration — Josh Dautel
– Josh Dautel, Commented Jan 12, 2017 at 20:58

piRSquared · Accepted Answer · 2017-01-12 19:18:25Z

2

consider the following dataframe df

df = pd.DataFrame(dict(duration=np.random.rand(1000),
                       property_name=np.random.choice(list('abc'), 1000)))

Then you can do

df.groupby('property_name').hist(figsize=(10,2))

answered Jan 12, 2017 at 19:18

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

1 Comment

Josh Dautel Over a year ago

So I've done that, how do I get it to work if there is more than two columns. I did it just now and it is pulling a histogram for each column with numerical values. (so it's producing multiple histograms for each property). How can I create just one histogram for each property based on duration – Josh Dautel just now edit

Josh Dautel · Accepted Answer · 2017-01-12 21:09:44Z

2

Nevermind, got it!

http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.hist.html

df.groupby('property_name').hist(column='duration')

answered Jan 12, 2017 at 21:09

Josh Dautel

1434 silver badges16 bronze badges

Collectives™ on Stack Overflow

Pandas, Histogram Plotting With Subplots Based on Column Values

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related