fill null values pandas code example

Example 1: fill missing values in column pandas with mean

df.fillna(df.mean(), inplace=True)

Example 2: how to fill missing values dataframe with mean

sub2['income'].fillna((sub2['income'].mean()), inplace=True)

Example 3: pandas replace nan

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

Example 4: how to replace nan values with 0 in pandas

df.fillna(0)

Example 5: replace nan using fillna

>>> df.fillna(0)
    A   B   C   D
0   0.0 2.0 0.0 0
1   3.0 4.0 0.0 1
2   0.0 0.0 0.0 5
3   0.0 3.0 0.0 4

Example 6: replace nan using fillna

>>> df.fillna(method='ffill')
    A   B   C   D
0   NaN 2.0 NaN 0
1   3.0 4.0 NaN 1
2   3.0 4.0 NaN 5
3   3.0 3.0 NaN 4