Can't replace 0 to nan in Python using Pandas [duplicate]

Question

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?

Answer 1

You can set inplace to True (default is False):

area.replace(0, np.nan, inplace=True)

See examples in docs.

Answer 2

You need to do:

area = area.replace(0, np.nan)