/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 vote137 views1 answer
"must be called with either an object pk or a slug in the URLconf"
Python
4 votes116 views2 answers
Python print time difference
Python
0 vote104 views1 answer
How to sum 2 no.s in python
Python
0 vote69 views1 answer
Run a python script with python and catch command line output
Python
1 vote143 views4 answers
Django query or condition for query parameters
Python Django
4 votes112 views2 answers
Python sort dictionary alphabetically by key
Python
0 vote141 views1 answer
Remove grid from 3d plots
Python
0 vote106 views1 answer
Customise django admin edit model button in field
Python
0 vote128 views1 answer
Add image pptx python
Python
0 vote118 views1 answer
Resize cmd using python
Python