/Python/Calculate percentile pandas dataframe

Calculate percentile pandas dataframe

import pandas as pd
import random

A = [ random.randint(0,100) for i in range(10) ]
B = [ random.randint(0,100) for i in range(10) ]

df = pd.DataFrame({ 'field_A': A, 'field_B': B })
df
#    field_A  field_B
# 0       90       72
# 1       63       84
# 2       11       74
# 3       61       66
# 4       78       80
# 5       67       75
# 6       89       47
# 7       12       22
# 8       43        5
# 9       30       64

df.field_A.mean()   # Same as df['field_A'].mean()
# 54.399999999999999

df.field_A.median() 
# 62.0

# You can call `quantile(i)` to get the i'th quantile,
# where `i` should be a fractional number.

df.field_A.quantile(0.1) # 10th percentile
# 11.9

df.field_A.quantile(0.5) # same as median
# 62.0

df.field_A.quantile(0.9) # 90th percentile
# 89.10000000000001

Source: stackoverflow.com

Similar codes

0 vote129 views2 answers
Load specific columns dataframe
Python
2 votes121 views3 answers
How printe word in python
Python
0 vote142 views1 answer
Scikit learn library in python
Python
1 vote142 views1 answer
Seconds add zero python
Python
0 vote133 views1 answer
How to make an app like word in python
Python
28 votes123 views3 answers
Replace nan from another column
Python
65 votes136 views5 answers
Python version check in cmd
Python
0 vote119 views1 answer
Python add commas to list
Python
0 vote135 views1 answer
Kivy display PIL image
Python
-1 vote131 views2 answers
How to sort a string list in python
Python