/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

20 votes271 views1 answer
How to iterate through images in a folder python
Python
1 vote250 views1 answer
Import numpy financial python
Python
0 vote249 views1 answer
Are logN and (lognN) same
Python
0 vote256 views1 answer
Java sript
Python
4 votes213 views1 answer
Django listview
Python Django
2 votes287 views3 answers
Python pywin32 get current cursor row
Python
8 votes284 views3 answers
Django order by
Python
1 vote267 views1 answer
Camera lags when using with opencv
Python
0 vote302 views1 answer
A int and float python
Python
1 vote261 views1 answer
Print a to z in python
Python