Mathew K Analytics

Mastering Pandas

A free 44-lesson course. Every lesson has a video walkthrough and a Jupyter notebook you can download or open in Google Colab. Tools covered: NumPy, pandas, Matplotlib, seaborn, Plotly, subprocess.

Introduction to Pandas: Essential Tools for Data Analysis in Python24 min
Lesson 1

Introduction to Pandas: Essential Tools for Data Analysis in Python

📓 Notebook · NumPy · pandas · Matplotlib

Installing Pandas and Setting Up Your Python Environment for Data Science Success24 min
Lesson 2

Installing Pandas and Setting Up Your Python Environment for Data Science Success

📓 Notebook · pandas · NumPy · subprocess

Understanding Pandas Series and DataFrames: Essential Python Data Structures for Analysis12 min
Lesson 3

Understanding Pandas Series and DataFrames: Essential Python Data Structures for Analysis

📓 Notebook · NumPy · pandas · datetime

Mastering DataFrames in Python Pandas: Creating & Inspecting for Data Science13 min
Lesson 4

Mastering DataFrames in Python Pandas: Creating & Inspecting for Data Science

📓 Notebook · pandas · NumPy

Introduction to Pandas DataFrame: Essential Operations and Attributes Explained28 min
Lesson 6

Introduction to Pandas DataFrame: Essential Operations and Attributes Explained

📓 Notebook · NumPy · pandas · Matplotlib

How to Import and Export Data in Pandas: CSV, Excel, JSON, and SQL Explained17 min
Lesson 7

How to Import and Export Data in Pandas: CSV, Excel, JSON, and SQL Explained

📓 Notebook · pandas · NumPy · SQLite

Exploring and Cleaning Real-World Datasets with Python Pandas: A Practical Guide19 min
Lesson 8

Exploring and Cleaning Real-World Datasets with Python Pandas: A Practical Guide

📓 Notebook · NumPy · pandas · seaborn

Hands-On With Pandas: Creating and Exploring DataFrames22 min
Lesson 9

Hands-On With Pandas: Creating and Exploring DataFrames

📓 Notebook · pandas · NumPy · seaborn

Introduction to Data Analysis with the Titanic Dataset Using Pandas13 min
Lesson 10

Introduction to Data Analysis with the Titanic Dataset Using Pandas

📓 Notebook · NumPy · pandas · Matplotlib

How to Identify and Handle Missing Data in Python Pandas for Accurate Data Analysis24 min
Lesson 11

How to Identify and Handle Missing Data in Python Pandas for Accurate Data Analysis

📓 Notebook · NumPy · pandas · seaborn

How to Rename Columns and Indexes in pandas DataFrames for Clear Data Analysis17 min
Lesson 13

How to Rename Columns and Indexes in pandas DataFrames for Clear Data Analysis

📓 Notebook · pandas · NumPy

How to Change Data Types and Convert Units in Pandas for Accurate Data Analysis21 min
Lesson 14

How to Change Data Types and Convert Units in Pandas for Accurate Data Analysis

📓 Notebook · pandas · NumPy

Comprehensive Guide to String Operations and Text Cleaning with Pandas in Python14 min
Lesson 15

Comprehensive Guide to String Operations and Text Cleaning with Pandas in Python

📓 Notebook · pandas · NumPy · regex (re)

Effective Techniques for Handling Outliers and Validating Data in Pandas19 min
Lesson 17

Effective Techniques for Handling Outliers and Validating Data in Pandas

📓 Notebook · pandas · NumPy · Matplotlib

Mastering Conditional Selection & Boolean Indexing in Pandas for Data Analysis17 min
Lesson 19

Mastering Conditional Selection & Boolean Indexing in Pandas for Data Analysis

📓 Notebook · pandas · NumPy

Master Filtering Rows and Columns in Pandas Using Query and isin for Data Analysis17 min
Lesson 20

Master Filtering Rows and Columns in Pandas Using Query and isin for Data Analysis

📓 Notebook · seaborn · NumPy

Mastering Data Sorting and Ranking Techniques with Pandas in Python18 min
Lesson 21

Mastering Data Sorting and Ranking Techniques with Pandas in Python

📓 Notebook · pandas · NumPy

Mastering Pandas DataFrames: Applying Functions Across Rows & Columns for Data Analysis12 min
Lesson 23

Mastering Pandas DataFrames: Applying Functions Across Rows & Columns for Data Analysis

📓 Notebook · pandas · NumPy · Matplotlib

Master Lambda Functions & Vectorized Operations in Pandas for Faster Data Analysis20 min
Lesson 24

Master Lambda Functions & Vectorized Operations in Pandas for Faster Data Analysis

📓 Notebook · NumPy · seaborn

How to Concatenate DataFrames Vertically and Horizontally Using Pandas in Python15 min
Lesson 26

How to Concatenate DataFrames Vertically and Horizontally Using Pandas in Python

📓 Notebook · NumPy · pandas

Mastering DataFrame Merges in Pandas: Inner, Outer, Left & Right Joins Explained36 min
Lesson 27

Mastering DataFrame Merges in Pandas: Inner, Outer, Left & Right Joins Explained

📓 Notebook · pandas · NumPy

Master Grouping and Aggregation in Python for Effective Data Analysis14 min
Lesson 29

Master Grouping and Aggregation in Python for Effective Data Analysis

📓 Notebook · NumPy · pandas · Matplotlib

Understanding Multi-Level Grouping and Custom Aggregations in Pandas for Data Analysis21 min
Lesson 30

Understanding Multi-Level Grouping and Custom Aggregations in Pandas for Data Analysis

📓 Notebook · NumPy · pandas · Matplotlib

Master Pivot Tables & Cross-Tabulations in Python Pandas for Powerful Data Analysis15 min
Lesson 31

Master Pivot Tables & Cross-Tabulations in Python Pandas for Powerful Data Analysis

📓 Notebook · NumPy · pandas · Matplotlib

Mastering Data Reshaping in Pandas with Melt, Stack, and Unstack Functions17 min
Lesson 32

Mastering Data Reshaping in Pandas with Melt, Stack, and Unstack Functions

📓 Notebook · NumPy · pandas · seaborn

Mastering Dates and Times in Pandas for Effective Data Analysis12 min
Lesson 34

Mastering Dates and Times in Pandas for Effective Data Analysis

📓 Notebook · seaborn · NumPy · Matplotlib

Converting Strings to Datetime and Extracting Date Components Using Pandas in Python16 min
Lesson 35

Converting Strings to Datetime and Extracting Date Components Using Pandas in Python

📓 Notebook · seaborn · NumPy · pandas

Mastering Time Series Analysis in Python: Resampling, Shifting, and Rolling Windows with Pandas15 min
Lesson 36

Mastering Time Series Analysis in Python: Resampling, Shifting, and Rolling Windows with Pandas

📓 Notebook · NumPy · pandas · seaborn

Mastering Time-Based Grouping and Aggregations in Pandas for Effective Data Analysis20 min
Lesson 38

Mastering Time-Based Grouping and Aggregations in Pandas for Effective Data Analysis

📓 Notebook · seaborn · NumPy · pandas

Master Pandas Series: Advanced Slicing & Cross-Section Techniques for Data Analysis20 min
Lesson 41

Master Pandas Series: Advanced Slicing & Cross-Section Techniques for Data Analysis

📓 Notebook · NumPy · Plotly · Matplotlib

Efficient Data Analysis with Pandas: Master Method Chaining & Pipelines in Python21 min
Lesson 44

Efficient Data Analysis with Pandas: Master Method Chaining & Pipelines in Python

📓 Notebook · NumPy · pandas

Optimizing Large Datasets in Pandas: Efficient Techniques for Data Processing18 min
Lesson 45

Optimizing Large Datasets in Pandas: Efficient Techniques for Data Processing

📓 Notebook · NumPy · pandas

Quick and Effective Data Visualization with Pandas plot() in Python17 min
Lesson 46

Quick and Effective Data Visualization with Pandas plot() in Python

📓 Notebook · NumPy · seaborn · Matplotlib

How to Use Pandas with Matplotlib and Seaborn for Effective Data Visualization25 min
Lesson 47

How to Use Pandas with Matplotlib and Seaborn for Effective Data Visualization

📓 Notebook · seaborn · Matplotlib · NumPy

How to Create Line, Bar, Histogram, and Box Plots Using Python and Pandas17 min
Lesson 48

How to Create Line, Bar, Histogram, and Box Plots Using Python and Pandas

📓 Notebook · seaborn · NumPy · Matplotlib

Understanding Data Correlation and Heatmap Visualization Using Python and Pandas15 min
Lesson 49

Understanding Data Correlation and Heatmap Visualization Using Python and Pandas

📓 Notebook · NumPy · pandas · seaborn

Turn Raw Data into Interactive Charts (Plotly + Pandas)17 min
Lesson 50

Turn Raw Data into Interactive Charts (Plotly + Pandas)

📓 Notebook · Plotly · NumPy

Step-by-Step Guide to Exploratory Data Analysis (EDA) Using Python and Pandas27 min
Lesson 51

Step-by-Step Guide to Exploratory Data Analysis (EDA) Using Python and Pandas

📓 Notebook · pandas · NumPy · Matplotlib

Master Feature Engineering with Pandas for Powerful Data Preprocessing21 min
Lesson 52

Master Feature Engineering with Pandas for Powerful Data Preprocessing

📓 Notebook · pandas · NumPy · Matplotlib

Essential Data Preparation Techniques for Effective scikit-learn Machine Learning Models19 min
Lesson 53

Essential Data Preparation Techniques for Effective scikit-learn Machine Learning Models

📓 Notebook · scikit-learn · NumPy · pandas

How to Encode Categorical Variables in Pandas for Effective Data Preparation16 min
Lesson 54

How to Encode Categorical Variables in Pandas for Effective Data Preparation

📓 Notebook · NumPy · pandas

How to Create an Interactive KPI Dashboard Using Python and Pandas21 min
Lesson 58

How to Create an Interactive KPI Dashboard Using Python and Pandas

📓 Notebook · NumPy · pandas · Matplotlib

Volatility and Risk Analysis Training for Finance and Stock Market21 min
Lesson 59

Volatility and Risk Analysis Training for Finance and Stock Market

📓 Notebook · pandas · yfinance · Matplotlib

Comprehensive Pandas Tutorial in Python: Data Analysis from Beginner to Advanced36 min
Lesson 69

Comprehensive Pandas Tutorial in Python: Data Analysis from Beginner to Advanced

📓 Notebook · seaborn · pandas · NumPy