Create incremental number column in pandas dataframe

Question

I have a dataframe with incremental float values

i need to add a new column assigning number between 1 -5 based on existing column on the basis of their values in ascending order.

Vaishali · Accepted Answer · 2019-02-28 07:09:19Z

2

You can use Series.rank with method 'dense' which assigns rank from minimum to maximum incrementing by 1 between groups

df['rank'] = df['Number'].rank(method = 'dense').astype(int)


    Number      rank
0   0.679484    5
1   0.079027    3
2   0.003132    1
3   0.092761    4
4   0.055500    2
5   0.055500    2
6   0.055500    2
7   0.003132    1

edited Feb 28, 2019 at 7:09

answered Feb 28, 2019 at 7:01

Vaishali

38.5k5 gold badges62 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Learner Over a year ago

thanks... one thing how does dense stop at 5 .. my entire dataframe has more than 1000 rows but i need to limit the ranking till only 50.

Vaishali Over a year ago

Rank does not have a limit parameter so you cannot control the number. What you can do is filter the data after assigning rank. df[df['Rank'] <= 50] will only show rows where rank is less than or equal to 50

Vaishali Over a year ago

Second option is to sort the data first and apply rank to first 50 rows

Learner Over a year ago

thanks Vaishali... I have come across "pd.qcut" which seems to work fine... with my issue..

Collectives™ on Stack Overflow

Create incremental number column in pandas dataframe

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related