/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

0 vote431 views1 answer
Circular import python
Python
0 vote344 views1 answer
Python how to get imaginary pat
Python
-1 vote340 views1 answer
Armstrong number function
Python
0 vote333 views2 answers
Install python macos catalina
Python
2 votes328 views1 answer
AlphaTauri
Python
1 vote324 views1 answer
Selenium text returns empty string python
Python
1 vote325 views2 answers
Pathlib without extension
Python
1 vote331 views1 answer
Min max and avg function of python
Python
0 vote339 views1 answer
Shuffle the data before GridSearchCV
Python
-1 vote346 views2 answers
Dd-mm-yy to yyyy-mm-dd in python
Python