/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 vote289 views1 answer
My_list = ['a','b'] my_list.append('c') print(my_list)
Python
1 vote276 views1 answer
How to locate image using pyautogui
Python
0 vote301 views1 answer
How to show installed tkinter fonts
Python
0 vote322 views1 answer
Django model registration
Python Django
0 vote293 views1 answer
Django import excel file from same directory
Python
0 vote286 views1 answer
How to group multiple test in pytest
Python
82 votes305 views6 answers
How to run requirements.txt in python
Python
3 votes302 views1 answer
Import py to exe
Python
8 votes351 views3 answers
Add new column based on condition on some other column in pandas.
Python
0 vote274 views1 answer
Add zero in front of numbers lower than 10 python
Python