replace zero with nan pandas 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: pandas replace zero with blank
df['column_B'].replace(['0', '0.0'], '', inplace=True)
Example 5: python zeros to nan
a[a==0] = np.nan
Example 6: how to replace zero value in python dataframe
nonzero_mean = df[ df.col != 0 ].mean()