Answers for "df replace nan with string"

python convert nan to empty string

# Option 1
df1 = df.replace(np.nan, '', regex=True) # All data frame

# Option 2
df[['column1','column2']] = df[['column1','column2']].fillna('') # Specific columns

replace nan in pandas

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

pandas replace empty string with nan

df = df.replace(r'^\s*$', np.NaN, regex=True)

python pandas replace nan with null

df.fillna('', inplace=True)

pandas replace nan with value above

>>> df = pd.DataFrame([[1, 2, 3], [4, None, None], [None, None, 9]])
>>> df.fillna(method='ffill')
   0  1  2
0  1  2  3
1  4  2  3
2  4  2  9