pandas fill nan with string 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)

Example 3: how to fill nan values with mean in pandas

df.fillna(df.mean())

Example 4: dataframe fill nan with mode

df['Column_Name'].fillna(df['Column_Name'].mode()[0], inplace=True)