Can't Replace 0 to Nan in Python Using Pandas [Duplicate]
I Have Dataframe with Only 1 Column. I Want to Replace All '0' to Np. Nan but I Can't Achieve That. Dataframe Is Called Area. I Tried: Area. Replace(0, Np...
![Can't Replace 0 to Nan in Python Using Pandas [Duplicate]](https://www.alledaags.nl/uploads/can-t-replace-0-to-nan-in_1200.jpg)
I have dataframe with only 1 column. I want to replace all '0' to np.nan but I can't achieve that.
dataframe is called area. I tried:
area.replace(0,np.nan)
area.replace(to_replace=0,np.nan)
area.replace(to_replace=0,value=np.nan)
area.replace('0',np.nan)
What should I do?
2 Answers
You can set inplace to True (default is False):
area.replace(0, np.nan, inplace=True)
See examples in docs.
You need to do:
area = area.replace(0, np.nan)
Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.
