/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

31 votes133 views4 answers
Python find the key with max value
Python
41 votes115 views2 answers
Print backwards python
Python
0 vote135 views1 answer
Where to import messages in django
Python Django
0 vote114 views2 answers
Python numpy + opencv + overlay image
Python
146 votes115 views6 answers
Os file exists
Python
26 votes205 views5 answers
Python class name
Python
4 votes121 views1 answer
Get current url python
Python
0 vote116 views1 answer
Delete nans in df python
Python
12 votes122 views5 answers
Python get the intersection of two lists
Python
0 vote103 views1 answer
Aws lambda environment variables python
Python