Order the duplicates in my pandas Data frame by adding another column [duplicate]

Question

I need to order duplicates in my data frame with a counter value of 1, 2 , 3 etc. The input data frame is like below:

         Key    Amount
         xyz     1000
         xyz1    870
         xyz2    1000
         xyz3    1000
         xyz4    650

and expected output as

         Key    Amount  Duplicate_order
         xyz     1000    1
         xyz1    870     1
         xyz2    1000    2
         xyz3    1000    3
         xyz4    650     1

user3483203 · Accepted Answer · 2018-06-07 19:11:57Z

1

Using cumcount

df['duplicate_order'] = df.groupby('Amount').cumcount()+1

    Key  Amount  duplicate_order
0   xyz    1000                1
1  xyz1     870                1
2  xyz2    1000                2
3  xyz3    1000                3
4  xyz4     650                1

answered Jun 7, 2018 at 19:11

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

Order the duplicates in my pandas Data frame by adding another column [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related