pandas replace value with nan code example

Example 1: replace nan in pandas

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

Example 2: how to replace nan with 0 in pandas

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

Example 3: pandas replace empty string with nan

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

Example 4: replacing values in pandas dataframe

df['coloum'] = df['coloum'].replace(['value_1','valu_2'],'new_value')

Example 5: pandas where retuning NaN

# Try using a loc instead of a where:
df_sub = df.loc[df.yourcolumn == 'yourvalue']

Example 6: replace error with nan pandas

df['workclass'].replace('?', np.NaN)