pandas fill nan with mean 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: how to fill nan values with mean in pandas

df.fillna(df.mean())

Example 4: pandas fill nan with mean of the groupby

>>> df
  name  value
0    A      1
1    A    NaN
2    B    NaN
3    B      2
4    B      3
5    B      1
6    C      3
7    C    NaN
8    C      3
>>> df["value"] = df.groupby("name").transform(lambda x: x.fillna(x.mean()))
>>> df
  name  value
0    A      1
1    A      1
2    B      2
3    B      2
4    B      3
5    B      1
6    C      3
7    C      3
8    C      3