How do I replace strings with certain values in them inside a Pandas DataFrame?

Question

I have a pandas DataFrame with missread string characters in them (like Ã³ for example) and for categorization porpuses I need to clean them up by replacing those characters with the actual letter.

I've tried to use the following code:

df_aux1= df3[df3.MY_COL.str.contains('Ã³')]

to isolate it and try to convert it.

Is the replacement on a Dataframe even possible or I'm missing something?

Your code selects rows which contain the particular character, what code are you using to replace that character? Also you can directly use replace without selecting those rows first. Try this — Vaishali
– Vaishali, Commented Jan 31, 2019 at 17:41
You need to use .loc (python 3+) in order to selects parts of your column. And you are assigning a new dataframe which isn't what you want to do. Posted my answer below! — Edeki Okoh
– Edeki Okoh, Commented Jan 31, 2019 at 17:53

Edeki Okoh · Accepted Answer · 2019-01-31 17:51:30Z

3

Something like this should help you (Python 3+):

df.loc[df['Column Name'] == 'Value you Want to Change', 'Column Name'] = 'New Value'

Essentially what this does it it selects the value you want to change in a specific column in a DataFrameusing .loc and then replaces it in the DataFrame.

answered Jan 31, 2019 at 17:51

Edeki Okoh

1,85917 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

How do I replace strings with certain values in them inside a Pandas DataFrame?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related