Data Cleaning & EDA
Master the pandas toolkit for cleaning messy real-world data and conducting exploratory data analysis. Handle missing values, fix data types, remove duplicates, and find patterns in any dataset.
What you'll learn
Data Cleaning & EDA is organized into 2 focused modules. By the end you'll be comfortable with:
- Data Cleaning with pandas
- Exploratory Data Analysis
Course curriculum
10 lessons across 2 modules. Lessons marked Free preview are readable without an account.
Module 1. Data Cleaning with pandas
Fix missing values, duplicates, type errors, and messy strings in real datasets
- 10mMissing ValuesFree preview
Detect, count, and handle null values — the first thing you check in any new dataset.
- 10mDuplicate DetectionFree preview
Find and remove duplicate rows — a critical step before any aggregation or count analysis.
- 10mFixing Data Types
Convert columns to the right dtype — the invisible fix that makes sorting, filtering, and math work correctly.
- 12mString Cleaning
Strip whitespace, fix case, split compound fields, and use regex for pattern-based cleaning.
- 12mOutlier Handling
Detect outliers with the IQR rule and decide whether to remove, cap, or keep them.
Module 2. Exploratory Data Analysis
Find patterns, summarise datasets, and ask the right questions before you build anything
- 10mThe EDA Mindset
Learn the questions to ask before writing any code — and why EDA is a conversation, not a checklist.
- 10mFirst Look at Any Dataset
The standard opening moves: .info(), .describe(), .value_counts() — understanding a dataset in under 5 minutes.
- 12mFinding Patterns with groupby
Slice data by categories to find where metrics differ — the core operation of exploratory analysis.
- 12mCorrelations and Relationships
Use df.corr() and heatmaps to find which variables move together — and which are independent.
- 15mEDA in Practice
A realistic end-to-end EDA walkthrough on a messy e-commerce dataset — asking and answering analytical questions.
Frequently asked questions
- Is the Data Cleaning & EDA course free?
- You can preview lessons for free with no account. Full access to this Pro course is included with a Kodion Pro subscription.
- Do I need prior programming experience?
- This is a intermediate course, so you'll get the most from it if you're already comfortable with the basics of programming.
- How long does Data Cleaning & EDA take to complete?
- It's 10 lessons across 2 modules, roughly 2 hours of hands-on learning. You can go entirely at your own pace.
- What will I learn?
- You'll work through Data Cleaning with pandas, Exploratory Data Analysis, building real, applied skills through interactive lessons and coding challenges.
- Can I get help if I'm stuck?
- Yes. Kodion's built-in AI tutor gives instant, context-aware hints and explanations right inside each lesson as you code.
Ready to start Data Cleaning & EDA?
Create a free account to track progress, earn XP, and get instant help from the AI tutor as you code.
Create your free account