Breaking News: Grepper is joining You.com. Read the official announcement!

python dataframe add rank column

Fierce Falcon answered on December 12, 2021 Popularity 6/10 Helpfulness 4/10

answer python dataframe add rank column

python dataframe add rank column

Comment

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

Popularity 6/10 Helpfulness 4/10 Language python

Source: pandas.pydata.org

Tags: add dataframe python rank

Link to this answer
Share Copy Link