/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 vote268 views1 answer
Copy along additional dimension numpy
Python
1 vote253 views2 answers
Java Array objects
Python
2 votes254 views1 answer
Self.app = Tk()
Python
0 vote277 views2 answers
Create column with values mapped from another column python
Python
1 vote264 views1 answer
Represent NaN with pandas in python
Python
0 vote267 views1 answer
Python argparse option groups
Python
0 vote343 views1 answer
Keras callbacks
Python
-3 votes266 views5 answers
Multiplication table in python
Python
1 vote275 views1 answer
Sqlalchemy lock row
Python
3 votes281 views2 answers
TypeError: 'numpy.ndarray' object is not callable
Python