/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 vote277 views1 answer
Global /tmp/pip-req-build-civioau0/opencv/modules/videoio/src/cap_v4l.cpp (587) autosetup_capture_mode_v4l2 VIDEOIO(V4L2:/dev/video0): device is busy
Python
34 votes314 views6 answers
Python if in list
Python
2 votes325 views2 answers
Print( n ) in python
Python
20 votes309 views3 answers
Python sort list in reverse
Python
30 votes306 views3 answers
Python max key dictionary key getter
Python
0 vote280 views1 answer
Production mode flask
Python
3 votes289 views1 answer
For each digit in number python
Python
0 vote313 views1 answer
Opencv houghlines only horizontal
Python
11 votes282 views3 answers
Get yesterday date python
Python
0 vote275 views1 answer
Python read and delete line from file
Python