dataframe replace 0 with nan code example

Example 1: replace nan in pandas

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

Example 2: pandas replace nan

data["Gender"].fillna("No Gender", inplace = True)

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: python pandas replace nan with null

df.fillna('', inplace=True)

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