/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

21 votes141 views5 answers
No module named cv2
Python
0 vote165 views1 answer
Python array sorting
Python
1 vote138 views1 answer
Python append several values
Python
0 vote143 views1 answer
Compute difference of all the combinations of 2 arrays
Python
3 votes160 views1 answer
How to move columns in a dataframen in python
Python
9 votes157 views1 answer
Flask tutorials
Python
73 votes137 views1 answer
Pip install error
Python
2 votes141 views1 answer
How to save a model and reuse fast ai
Python
4 votes189 views2 answers
Flask get variable from url
Python Flask
0 vote150 views1 answer
Django admin no such table user
Python