/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

9 votes320 views5 answers
Pandas drop unnamed columns
Python
20 votes364 views5 answers
Remove first character from string python
Python
10 votes325 views4 answers
Count values pandas
Python
0 vote353 views1 answer
Insert single value in dataframe using index
Python
1 vote382 views1 answer
Python loop until condition met
Python
3 votes307 views3 answers
Drop variable pandas
Python
0 vote304 views1 answer
Uppy tus
Python
7 votes334 views2 answers
Cmd check if python is installed
Python
0 vote346 views1 answer
Difference between changing values of variable and list inside function in python
Python
-1 vote334 views2 answers
Grab the first letter of each string in an array python
Python