/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

9 votes158 views1 answer
Load csv file using pandas
Python
22 votes163 views10 answers
Cat
Python
31 votes159 views2 answers
How to divide string in python
Python
0 vote163 views1 answer
Reset Python Dictionary to 0 Zero. Empty existing Python Dictionary
Python
0 vote157 views1 answer
Ftplib tqdm
Python
6 votes166 views2 answers
How to append two numpy arrays
Python
15 votes155 views3 answers
Remove word from string python
Python
125 votes178 views6 answers
Dataframe rename column
Python
0 vote181 views1 answer
Make value of two tables unique django
Python Django
0 vote159 views1 answer
Array destructuring python
Python