/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 vote260 views1 answer
Airindia
Python
3 votes312 views1 answer
How to change the window colour in pygame
Python
-1 vote362 views2 answers
Python dict remove duplicates where items are not the same
Python
0 vote312 views1 answer
Conda enviroment python version
Python
0 vote320 views1 answer
Conv2 python
Python
-1 vote298 views5 answers
Sudo apt install python3-pip
Python
2 votes288 views1 answer
Make tkinter window look less blury
Python
0 vote317 views1 answer
Create django model field based on another field
Python Django
0 vote328 views1 answer
Numpy sort row by
Python
0 vote313 views2 answers
Generate gif py
Python