Mathew K Analytics

Pandas Full Course

A free 15-lesson course. Every lesson has a video walkthrough and a Jupyter notebook you can download or open in Google Colab; 15 lessons include real datasets. Tools covered: pandas, Matplotlib, pathlib, CSV, seaborn, JSON.

About this course

Pandas Full Course is a free beginner to intermediate course with 15 video lessons (about 2 hours of video in total). It starts with “Learn Pandas Fast: Answer a Real Data Question in 20 Minutes | Pandas Course #1” and finishes with “Pandas Mini Project: Analyse the Titanic Dataset From Scratch | Pandas Course #15”. Every lesson comes with the exact Jupyter notebook used in the video, and 15 of them include the dataset, so you can follow along with the same data.

Along the way you'll use pandas, Matplotlib, pathlib, CSV, seaborn and JSON.

It suits learners who already know basic Python (variables, lists, loops and functions) and want to apply it to real problems.

Course outline

All 15 lessons

Learn Pandas Fast: Answer a Real Data Question in 20 Minutes | Pandas Course #123 min
Lesson 1

Learn Pandas Fast: Answer a Real Data Question in 20 Minutes | Pandas Course #1

📊 Dataset · 📓 Notebook · CSV · pandas · Matplotlib

Install Pandas the Right Way and Fix Setup Errors for Good | Pandas Course #223 min
Lesson 2

Install Pandas the Right Way and Fix Setup Errors for Good | Pandas Course #2

📊 Dataset · 📓 Notebook · pandas · seaborn · pathlib

Pandas Series vs DataFrame Explained: The 2 Objects Behind Every Table | Pandas Course #325 min
Lesson 3

Pandas Series vs DataFrame Explained: The 2 Objects Behind Every Table | Pandas Course #3

📊 Dataset · 📓 Notebook · pathlib · pandas · Matplotlib

Create and Inspect a Pandas DataFrame Like a Pro: info, describe, dtypes | Pandas Course #424 min
Lesson 4

Create and Inspect a Pandas DataFrame Like a Pro: info, describe, dtypes | Pandas Course #4

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Pandas DataFrame Basics: Add, Drop, Rename and Summarise Columns | Pandas Course #524 min
Lesson 5

Pandas DataFrame Basics: Add, Drop, Rename and Summarise Columns | Pandas Course #5

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Explore a New Dataset in Pandas Step by Step (Hands-on Project) | Pandas Course #623 min
Lesson 6

Explore a New Dataset in Pandas Step by Step (Hands-on Project) | Pandas Course #6

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Read and Write CSV, Excel, JSON and SQL in Pandas (No More File Errors) | Pandas Course #7
Lesson 7

Read and Write CSV, Excel, JSON and SQL in Pandas (No More File Errors) | Pandas Course #7

📊 Dataset · 📓 Notebook · pandas · JSON · SQLite

Pandas loc vs iloc: Select Exactly the Rows and Columns You Need | Pandas Course #8
Lesson 8

Pandas loc vs iloc: Select Exactly the Rows and Columns You Need | Pandas Course #8

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Filter Pandas DataFrames with Conditions: Boolean Indexing Made Easy | Pandas Course #9
Lesson 9

Filter Pandas DataFrames with Conditions: Boolean Indexing Made Easy | Pandas Course #9

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Pandas query() and isin(): Write Filters That Read Like English | Pandas Course #10
Lesson 10

Pandas query() and isin(): Write Filters That Read Like English | Pandas Course #10

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Master the Pandas Index: set_index, reset_index and sort_index | Pandas Course #11
Lesson 11

Master the Pandas Index: set_index, reset_index and sort_index | Pandas Course #11

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Rename Columns in Pandas the Clean Way (One Line for Every Column) | Pandas Course #12
Lesson 12

Rename Columns in Pandas the Clean Way (One Line for Every Column) | Pandas Course #12

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Sort and Rank Data in Pandas: sort_values, nlargest and rank | Pandas Course #13
Lesson 13

Sort and Rank Data in Pandas: sort_values, nlargest and rank | Pandas Course #13

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Advanced Slicing in Pandas: MultiIndex, xs and IndexSlice Explained | Pandas Course #14
Lesson 14

Advanced Slicing in Pandas: MultiIndex, xs and IndexSlice Explained | Pandas Course #14

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Pandas Mini Project: Analyse the Titanic Dataset From Scratch | Pandas Course #15
Lesson 15

Pandas Mini Project: Analyse the Titanic Dataset From Scratch | Pandas Course #15

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Frequently asked questions

Is the Pandas Full Course course free?

Yes. All 15 videos, notebooks and datasets are free, with no sign-up.

Do I need to install anything?

No. You can open each notebook in Google Colab in your browser, or download it and run it in Jupyter or VS Code with Anaconda installed.

How long does the Pandas Full Course course take?

The videos add up to about 2 hours. Most learners take one to two lessons a day, so plan on 2 to 4 weeks if you code along.

What level is it?

Beginner to intermediate. It suits learners who already know basic Python (variables, lists, loops and functions) and want to apply it to real problems.