/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

0 vote147 views1 answer
Numpy init array
Python
1 vote107 views1 answer
Dataframe sort values descending
Python
0 vote124 views1 answer
Python str and repr
Python
0 vote103 views1 answer
Python empty array length n grepper
Python
4 votes104 views1 answer
Python return -1
Python
0 vote108 views1 answer
Prettify json in pycharm
Python
110 votes99 views10 answers
Python virtual environment
Python
0 vote110 views1 answer
How long is the pyautogui script
Python
0 vote102 views1 answer
VectorIndexer pyspark
Python
2 votes126 views2 answers
How to convert csv into list
Python