Exchange each 100 in a dataframe for another value

Question

I have a csv file without headers and several values. I only want to exchange each 100 in the file for a 20.
I don't know if it would work with an if condition. I know i can select each 100 with the following code
df[df,iloc[:,:== 100] but i don't know how to only exchange each 100 for another value

Williams Rizzi · Answer

Assuming df is your dataframe, and 100 is the value you want to replace with 20. I would do:
df = df.replace(to_replace=100, value=20)
As shown in the guide

Exchange each 100 in a dataframe for another value

One Answer

Add your own answers!

Ask a Question