Add rank column in dataframe in Python

Asked Feb 09 '20 at 12:30

Active Feb 09 '20 at 12:33

Viewed 141 times

In the code below I am trying to get top 250 records based on imdb_score and then populate rank to it based on its score. Note I need to populate rank from 1 to 250. All the records will have different rank values. I am getting NaN as value for all rows. Please help.

IMDb_Top_250['rank'] = IMDb_Top_250.nlargest(250,'imdb_score').apply(lambda x: range(1,250))

edited Feb 09 '20 at 12:33

Celius Stingher

17,835
6
23
53

asked Feb 09 '20 at 12:30

Sourabh Somvanshi

show sample of you data and working example – Zaraki Kenpachi Feb 09 '20 at 12:38
Please check this link https://stackoverflow.com/questions/17775935/sql-like-window-functions-in-pandas-row-numbering-in-python-pandas-dataframe – Srini Feb 09 '20 at 12:38
IIUC try only `IMDb_Top_250.nlargest(250,'imdb_score')` or `IMDb_Top_250.nlargest(250,'imdb_score')['imdb_score']` i didn't see any need of apply here – Dishin H Goyani Feb 09 '20 at 12:46

Add rank column in dataframe in Python

0 Answers0