Hello everyone,
I'm trying to plot a data frame, which includes zero values, but I don't want them to be shown in the figure plot. When I try to remove them, it will give an error that says the dimensions must be the same size (x and y must be the same size). Can you please help me to remove the zero values without changing the data frame?
P.S. I've drawn a circle around the zero values
Mohammad Bawaneh
Replace zero values with NaN.
Try:
df['Dataframe colmn'] = df['Dataframe colmn'].replace({0:np.nan})
1 votes
0 thanks
Adib Amini
Dear Mohammad Bawaneh ,
Thank you so much, it actually worked, but I used this code to replace zeros with NaNs:
df.replace(0, np.nan, inplace=True)
1 votes
0 thanks
Hossam Elzayady
Methods to replace NaN values with zeros in Pandas DataFrame:
- fillna() The fillna() function is used to fill NA/NaN values using the specified method.
- replace() The dataframe.replace() function in Pandas can be defined as a simple method used to replace a string, regex, list, dictionary etc. in a DataFrame.
1 votes
0 thanks
- Badges
- Science topic
More Adib Amini's questions See All
Similar questions and discussions