Answers for "convert empty string to nan pandas"

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

pandas replace empty string with nan

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