PYTHON

replace nan in pandas

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

replace "-" for nan in dataframe

df.replace(np.nan,0)

replace all nan values in dataframe

# Replacing all nan values with 0 in Dataframe
df = df.fillna(0)

how to replace nan values in pandas with mean of column

#fill nan values with mean
df = df.fillna(df.mean())

pandas replace nan with value above

>>> df = pd.DataFrame([[1, 2, 3], [4, None, None], [None, None, 9]])
>>> df.fillna(method='ffill')
   0  1  2
0  1  2  3
1  4  2  3
2  4  2  9

how to replace nan values in pandas with mean of column

#fill nan values with mean
df = df.fillna(df.mean())

replace all occurrences of a value to nan in pandas

import pandas as pd
import numpy as np

df = pd.DataFrame({'col1':['one', 'two', 'three', 'four']})

df['col1'] = df['col1'].map(lambda x: np.nan if x in ['two', 'four'] else x)