xxxxxxxxxx
#fill nan values with mean
df = df.fillna(df.mean())
xxxxxxxxxx
--fillna
product_mean = df['product'].mean()
df['product'] = df['product'].fillna(product_mean)
--replace method
col_mean = np.mean(df['col'])
df['col'] = df['col'].replace(np.nan, col_mean)
xxxxxxxxxx
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