pandas fillna column code example

Example 1: fillna with mean pandas

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

Example 2: dataframe fillna with 0

df['column'] = df['column'].fillna(0)

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

df.fillna(0)

Example 4: python pandas fillna

# importing pandas module
import pandas as pd  
# making data frame from csv file
nba = pd.read_csv("nba.csv")
  
# replacing na values in college with No college
nba["College"].fillna("No College", inplace = True)
# OR
nba.College.fillna("No College", inplace = True)
  
print(nba)

Example 5: DataFrame.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