replace nan with empty string 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: replace nan in pandas

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

Example 3: how to replace nan with 0 in pandas

df['product']=df['product'].fillna(0)
df['context']=df['context'].fillna(0)
df

Example 4: pandas replace nan

data["Gender"].fillna("No Gender", inplace = True)

Example 5: replace "-" for nan in dataframe

df.replace(np.nan,0)

Example 6: pandas replace empty string with nan

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