/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

48 votes185 views5 answers
How to change int to string in python
Python
0 vote208 views1 answer
Pandas columns starting with
Python
0 vote200 views1 answer
Python slice a list a specific amount of times
Python
0 vote163 views1 answer
Pandas summary
Python
2 votes194 views1 answer
Unsigned int python
Python
1 vote224 views1 answer
Snowflake python connector error handling
Python
2 votes216 views1 answer
Python sort multiple lists based on sorting of single list
Python
12 votes202 views2 answers
Memory Usage in python
Python
0 vote217 views1 answer
In dataframe particular column to string
Python
0 vote189 views1 answer
Pyqt button hover color
Python