Pandas Replace NaN with blank/empty string
Solution 1:
df = df.fillna('')
or just
df.fillna('', inplace=True)
This will fill na's (e.g. NaN's) with ''.
If you want to fill a single column, you can use:
df.column1 = df.column1.fillna('')
One can use df['column1'] instead of df.column1.
Solution 2:
import numpy as np
df1 = df.replace(np.nan, '', regex=True)
This might help. It will replace all NaNs with an empty string.