/Python/Pandas groupby aggregate quantile

Pandas groupby aggregate quantile

# 50th Percentile
def q50(x):
    return x.quantile(0.5)

# 90th Percentile
def q90(x):
    return x.quantile(0.9)

my_DataFrame.groupby(['AGGREGATE']).agg({'MY_COLUMN': [q50, q90, 'max']})

Source: stackoverflow.com

Pandas groupby percentile

df.groupby('C').quantile(.95)

Similar codes

1 vote304 views1 answer
Geometrical mean python
Python
0 vote315 views1 answer
For loop in django template css
Python
51 votes315 views6 answers
Python remove repeated elements from list
Python
0 vote324 views1 answer
Oversampling using smote
Python
0 vote315 views1 answer
Opencv export image
Python
1 vote308 views1 answer
How to write a dict in pytohn
Python
0 vote322 views1 answer
Python argsort a list
Python
34 votes337 views6 answers
Pip install from jupyter notebook
Python
0 vote298 views1 answer
Give columns while reading csv
Python
0 vote292 views1 answer
Df groupby loop
Python