/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

12 votes150 views1 answer
How to create an env to use in vs code using anaconda
Python
0 vote139 views1 answer
Update numpy in python
Python
0 vote130 views1 answer
Pandas describe kurtosis skewness
Python
0 vote149 views1 answer
Python count empty lines in text file
Python
0 vote134 views1 answer
Example of django template for forms
Python
7 votes135 views2 answers
Python divmod
Python
0 vote132 views1 answer
ModuleNotFoundError: No module named 'App_Order'
Python
1 vote146 views1 answer
Python program to give shop name
Python
-1 vote156 views1 answer
Django model UUID field
Python
10 votes140 views5 answers
Discord.py reply to message
Python