/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

1 vote226 views1 answer
Auto-created primary key used when not defining a primary key type, by default 'django.db.models.AutoField'.
Python Django
17 votes180 views4 answers
Get ip address python
Python
8 votes164 views1 answer
Find time of run for python code
Python
7 votes158 views3 answers
Rmse in python
Python
0 vote186 views1 answer
Write a python program to find table of a number using while loop
Python
3 votes176 views2 answers
Pathlib current directory
Python
1 vote183 views1 answer
Gluten
Python
2 votes194 views1 answer
Google calendar Request had insufficient authentication scopes.
Python
0 vote184 views1 answer
Python - extract min and max values per each column name
Python
0 vote177 views1 answer
How to import files from desktop to python
Python