CODEWITHSUNDEEP
pythonpandasnumpy
Mamed
Mamed

Reputation: 772

Rename column values based on unique values of other column

Given a data frame:

df = 

  id_easy   ordinal   weekday
0       0         1   Tuesday
1       0         2   Monday
2       0         3   Monday
3       1         1   Saturday
4       1         2   Tuesday

I want to check:

Desired output: 

df = 

  id_easy   ordinal   weekday
0       0         1   Tuesday       # as this is Tuesday
1       0         2   Tuesday       # so this became Tuesday as well
2       0         3   Tuesday       # so this became Tuesday as well
3       1         1   Saturday      # as this is Saturday
4       1         2   Saturday      # so this became Saturday as well

Upvotes: 0

Views: 128

Answers (1)

fsl
fsl

Reputation: 3280

You can use groupby:

df.weekday = df.groupby('id_easy')['weekday'].transform('first')

Output:

   id_easy  ordinal   weekday
0        0        1   Tuesday
1        0        2   Tuesday
2        0        3   Tuesday
3        1        1  Saturday
4        1        2  Saturday

Upvotes: 1

Related Questions