Can't replace 0 to nan in Python using Pandas

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?

You have to assign it back to the variable after calling `replace()`. — pault, Mar 30 '18 at 14:09

score 68 · Accepted Answer · edited Sep 25 '18 at 22:35

68

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

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

See examples in docs.

edited Sep 25 '18 at 22:35

Asclepius

answered Mar 30 '18 at 14:16

zipa

score 11 · Answer 2 · answered Mar 30 '18 at 14:10

11

You need to do:

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

answered Mar 30 '18 at 14:10

drec4s

2 Answers2