how to convert nan to string in pandas code example
Example 1: 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
Example 2: python pandas replace nan with null
df.fillna('', inplace=True)