/Python/Unique id on duplicate ids values pandas

Unique id on duplicate ids values pandas

import pandas as pd
import numpy as np
data = {'Name':['Tom', 'Tom', 'Jack', 'Terry'], 'Age':[20, 21, 19, 18]} 
df = pd.DataFrame(data)

nth = ['First', 'Second', 'Third', 'Fourth']

def prefix(d):
    n = len(d)
    if n > 1:
        return d.radd([nth[i] for i in range(n)])
    else:
        return d

df.assign(Name=df.groupby('Name').Name.transform(prefix))

          Name  Age
0     FirstTom   20
1    SecondTom   21
2         Jack   19
3        Terry   18

Similar codes

3 votes202 views1 answer
Nlargest
Python
109 votes183 views6 answers
Python string contains substring
Python
-2 votes181 views1 answer
Numpy find index of matching values
Python
0 vote142 views1 answer
Which day is today
Python
5 votes174 views1 answer
How to rezize image in python tkinter
Python
0 vote182 views1 answer
Python datetime into 12-hour format
Python
0 vote212 views1 answer
Mail.send_message flask not working, SSL ==> 465
Python Flask
0 vote267 views1 answer
2pac
Python
0 vote182 views1 answer
Pyplot new figure
Python
7 votes188 views3 answers
How to delete migrations in django
Python