replace 0 with nan python code example

Example 1: how to replace nan with 0 in pandas

df['product']=df['product'].fillna(0)
df['context']=df['context'].fillna(0)
df

Example 2: python dataframe replace nan with 0

In [7]: df
Out[7]: 
          0         1
0       NaN       NaN
1 -0.494375  0.570994
2       NaN       NaN
3  1.876360 -0.229738
4       NaN       NaN

In [8]: df.fillna(0)
Out[8]: 
          0         1
0  0.000000  0.000000
1 -0.494375  0.570994
2  0.000000  0.000000
3  1.876360 -0.229738
4  0.000000  0.000000

Example 3: how to replace nan values with 0 in pandas

df.fillna(0)

Example 4: how to replace zero with null in python

df2[["Weight","Height","BootSize","SuitSize"]].astype(str).replace('0',np.nan)

Example 5: how to replace zero with null in python

df2.loc[df2['Weight'] == 0,'Weight'] = np.nan
df2.loc[df2['Height'] == 0,'Height'] = np.nan
df2.loc[df2['BootSize'] == '0','BootSize'] = np.nan
df2.loc[df2['SuitSize'] == '0','SuitSize'] = np.nan