Calculating Quantiles based on a column value?

Question

I am trying to figure out a way in which I can calculate quantiles in pandas or python based on a column value? Also can I calculate multiple different quantiles in one output?

For example I want to calculate the 0.25, 0.50 and 0.9 quantiles for

Column Minutes in df where it is <= 5 and where it is > 5 and <=10

df[df['Minutes'] <=5]

df[(df['Minutes'] >5) & (df['Minutes']<=10)]

where column Minutes is just a column containing value of numerical minutes

Thanks!

Vaishali · Accepted Answer · 2019-06-17 05:06:07Z

3

DataFrame.quantile accepts values in array,

Try

df['minute'].quantile([0.25, 0.50 , 0.9])

Or filter the data first,

df.loc[df['minute'] <= 5, 'minute'].quantile([0.25, 0.50 , 0.9])

answered Jun 17, 2019 at 5:06

Vaishali

38.5k5 gold badges62 silver badges88 bronze badges

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

Collectives™ on Stack Overflow

Calculating Quantiles based on a column value?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related