Smooth histogram from data in column in Pandas DataFrame?

Question

This is a follow-up to this question: Pandas limit Series/DataFrame to range of values of one column

I'd next like to histogram the numbers in the "Age" column and then smooth the result (to reduce scatter). What's an elegant way to do this?

Why don't you try it yourself? It's easy. Look up Matplotlib's hist function, or pandas's hist function. — Kartik
– Kartik, Commented Feb 24, 2016 at 5:03
Density plot, Plotting probability, or maybe you just want df['Age'].plot(kind='density') or df['Age'].hist(). I'm personally unclear on what you mean by "then smooth the result". — Jarad
– Jarad, Commented Feb 24, 2016 at 5:53
It's easy to make a histogram, but I'm having some formatting issues when trying to smooth over it. It seems like the only way is to produce a new function function from the histogram and smooth/interpolate over it using scipy's interpolate, but I thought there may be a more pythonic way to do it, e.g., with a pandas-native function? — Alpha
– Alpha, Commented Feb 24, 2016 at 21:21

Romain · Accepted Answer · 2016-02-25 14:46:56Z

4

You can use Seaborn and its function distplot which plot by default a kernel density estimate and histogram with bin size determined automatically.

import seaborn as sns
import numpy as np
import pandas as pd

# Some test data
np.random.seed(33454)
df = pd.DataFrame({'nb': np.random.randint(0, 1000, 100)})
df.sort_values('nb', inplace=True)

ax = sns.distplot(df['nb'])

edited Feb 25, 2016 at 14:46

answered Feb 25, 2016 at 7:55

Romain

22.2k6 gold badges63 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

Smooth histogram from data in column in Pandas DataFrame?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related