pandas replace 0 with nan code example

Example 1: replace nan in pandas

df['DataFrame Column'] = df['DataFrame Column'].fillna(0)

Example 2: pandas replace na with 0

df.fillna(0)

Example 3: how to replace zero with null in python

data['amount']=data['amount'].replace(0, np.nan)
data['duration']=data['duration'].replace(0, np.nan)

Example 4: how to replace zero with null in python

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

Example 5: pandas replace nan with value above

>>> df = pd.DataFrame([[1, 2, 3], [4, None, None], [None, None, 9]])
>>> df.fillna(method='ffill')
   0  1  2
0  1  2  3
1  4  2  3
2  4  2  9