Data Science

Handling Missing Data in Pandas

Senior Data Analyst
April 19, 2026
5 min read

Detecting Nulls

df.isnull().sum() # Count nulls per column

df[df['price'].isnull()] # Show rows with null price

Filling Nulls (COALESCE)

df['price'].fillna(0) # Fill with 0

df['price'].fillna(df['price'].mean()) # Fill with average

Dropping Nulls

df.dropna() # Drop any row with a null

df.dropna(subset=['price']) # Drop only if 'price' is null

*Day 110: Creating and Transforming Columns.*

Ready to put your knowledge into practice?

Join SQL Mastery and learn through interactive exercises.