Cannot use replace method on python

Question

I wanted to change my variables on spesific column with dictionary values but it does not change. I tried several ways and but it does not work. My dataset has 47k rows and my dictionary has 30 different words so I will show some.

My dataset:

My dataset

Dictionary:

rolechange = {"\\Adv":"Adversary",
          "\\Sci":"Scientist",
          "\\Inn":"Innocent",
          "\\Und":"Undetermined"}

I'm trying

movies_df["Role Type"].replace(rolechange, inplace=True)

It does not gives error but result is same. I couldn't find similar question on here, sorry for if its duplicate.

Is possible get list from problematic column values? Like print (movies_df["Role Type"].head(10).tolist()) — jezrael
– jezrael, Commented Mar 14, 2022 at 12:29
It prints: ['\\\\Sci', '\\\\Inn', '\\\\Und', '\\\\Und', '\\\\Und', '\\\\Und', '\\\\Und', '\\\\Und', '\\\\Und', '\\\\Und'] — Berk Ak
– Berk Ak, Commented Mar 14, 2022 at 12:32

Corralien · Accepted Answer · 2022-03-14 12:32:04Z

1

You just have to create raw strings (prefix 'r')

rolechange = {r"\\Adv":"Adversary",
              r"\\Sci":"Scientist",
              r"\\Inn":"Innocent",
              r"\\Und":"Undetermined"}

>>> df['Role Type'].replace(rolechange)

0       Scientist
1        Innocent
2    Undetermined
Name: Role Type, dtype: object

answered Mar 14, 2022 at 12:32

Corralien

121k8 gold badges43 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot use replace method on python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related