pandas replace nan with string in a column code example
Example 1: python convert nan to empty string
df1 = df.replace(np.nan, '', regex=True)
df[['column1','column2']] = df[['column1','column2']].fillna('')
Example 2: how to replace nan with 0 in pandas
df['product']=df['product'].fillna(0)
df['context']=df['context'].fillna(0)
df
Example 3: python pandas replace nan with null
df.fillna('', inplace=True)
Example 4: 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