/Python/Python dataframe add rank column

Python dataframe add rank column

df['default_rank'] = df['Number_legs'].rank()
>>> df['max_rank'] = df['Number_legs'].rank(method='max')
>>> df['NA_bottom'] = df['Number_legs'].rank(na_option='bottom')
>>> df['pct_rank'] = df['Number_legs'].rank(pct=True)
>>> df
    Animal  Number_legs  default_rank  max_rank  NA_bottom  pct_rank
0      cat          4.0           2.5       3.0        2.5     0.625
1  penguin          2.0           1.0       1.0        1.0     0.250
2      dog          4.0           2.5       3.0        2.5     0.625
3   spider          8.0           4.0       4.0        4.0     1.000
4    snake          NaN           NaN       NaN        5.0       NaN

Source: pandas.pydata.org

Similar codes

1 vote322 views1 answer
Lecture de fichier python
Python
1 vote280 views1 answer
Django filter by date range
Python
0 vote284 views1 answer
Scaling pkl file?
Python
15 votes284 views6 answers
Flask install
Python
2 votes338 views3 answers
Check if value exists in list python
Python
22 votes293 views8 answers
Math
Python
0 vote327 views1 answer
Suppress pandas future warnings
Python
0 vote242 views1 answer
Sentinel policy for tag
Python
10 votes279 views5 answers
Create pickle file python
Python
1 vote309 views1 answer
A0 = dict(zip(('a','b','c','d','e'),(1,2,3,4,5)))
Python