/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 vote223 views1 answer
Copyfile pyhon
Python
0 vote255 views1 answer
Quando è stata inventata la lavastoviglie
Python
4 votes181 views2 answers
How to drop a column in pandas
Python
0 vote187 views1 answer
MEMORY MANAGEMENT SYSTEM IN PYTHON
Python
7 votes205 views3 answers
Opencv2 python show
Python
0 vote199 views1 answer
Kivy button on press call function with arguments
Python
0 vote261 views1 answer
Django serializer exclude fields
Python Django
0 vote199 views1 answer
How to add a key and a value to a dictionary in python\
Python
0 vote197 views1 answer
Gpt2 simple continue training from checkpoint
Python
-2 votes224 views4 answers
Django datepicker
Python Django