/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

11 votes312 views2 answers
How to import a module in python
Python
2 votes308 views1 answer
Custom signal godot
Python
1 vote334 views1 answer
Python filter None dictionary
Python
0 vote336 views2 answers
Get last file in directory python
Python
0 vote315 views1 answer
Matplotlib text relative to axis
Python
0 vote317 views1 answer
List of words from a string and filter them based on a secondary list
Python
17 votes313 views5 answers
ModuleNotFoundError: No module named 'tkinter'
Python
3 votes352 views1 answer
For e in p.event.get(): pygame.error: video system not initialized
Python
2 votes292 views1 answer
Importying listviewin django
Python
2 votes322 views6 answers
K
Python