Mathew K Analytics

Real-World Data Analytics

A free 39-lesson course. Every lesson has a video walkthrough and a Jupyter notebook you can download or open in Google Colab; 39 lessons include real datasets. Tools covered: pandas, Matplotlib, NumPy, collections, itertools, SciPy.

About this course

Real-World Data Analytics is a free beginner to intermediate course with 39 video lessons (about 6 hours of video in total). It starts with “Data Cleaning in Python Pandas: Audit a Real Retail Dataset | Data Analytics #1” and finishes with “Python Data Analytics #39: Global Health Spending vs Life Outcomes in Python”. Every lesson comes with the exact Jupyter notebook used in the video, and 39 of them include the dataset, so you can follow along with the same data.

Along the way you'll use pandas, Matplotlib, NumPy, collections, itertools and SciPy.

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

Course outline

All 39 lessons

Data Cleaning in Python Pandas: Audit a Real Retail Dataset | Data Analytics #118 min
Lesson 1

Data Cleaning in Python Pandas: Audit a Real Retail Dataset | Data Analytics #1

📊 Dataset · 📓 Notebook · pandas · Matplotlib

RFM Analysis in Python: Customer Segmentation with Pandas | Data Analytics #2
Lesson 2

RFM Analysis in Python: Customer Segmentation with Pandas | Data Analytics #2

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Market Basket Analysis in Python: Support, Confidence & Lift | Data Analytics #3
Lesson 3

Market Basket Analysis in Python: Support, Confidence & Lift | Data Analytics #3

📊 Dataset · 📓 Notebook · pandas · itertools · collections

Cohort Analysis in Python: Customer Retention Heatmap | Data Analytics #4
Lesson 4

Cohort Analysis in Python: Customer Retention Heatmap | Data Analytics #4

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Sales Forecasting in Python: Holt-Winters vs Baselines | Data Analytics #5
Lesson 5

Sales Forecasting in Python: Holt-Winters vs Baselines | Data Analytics #5

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Price Elasticity in Python: Do Discounts Really Pay? | Data Analytics #6
Lesson 6

Price Elasticity in Python: Do Discounts Really Pay? | Data Analytics #6

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Customer Lifetime Value (CLV) in Python, Tested on Real Data | Data Analytics #7
Lesson 7

Customer Lifetime Value (CLV) in Python, Tested on Real Data | Data Analytics #7

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

ABC Analysis & Pareto 80/20 in Python: Product Performance | Data Analytics #8
Lesson 8

ABC Analysis & Pareto 80/20 in Python: Product Performance | Data Analytics #8

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Web Scraping in Python with Requests & BeautifulSoup: Price Tracker | Data Analytics #9
Lesson 9

Web Scraping in Python with Requests & BeautifulSoup: Price Tracker | Data Analytics #9

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

End-to-End Retail Analytics Project in Python (Portfolio Capstone) | Data Analytics #10
Lesson 10

End-to-End Retail Analytics Project in Python (Portfolio Capstone) | Data Analytics #10

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Clean Stock Price Data in Python: Apple vs Tesla with Pandas | Data Analytics #11
Lesson 11

Clean Stock Price Data in Python: Apple vs Tesla with Pandas | Data Analytics #11

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Efficient Frontier in Python: Portfolio Risk, Return & Sharpe Ratio | Data Analytics #12
Lesson 12

Efficient Frontier in Python: Portfolio Risk, Return & Sharpe Ratio | Data Analytics #12

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

RSI, MACD, Bollinger Bands & Moving Averages in Python (Pandas) | Data Analytics #13
Lesson 13

RSI, MACD, Bollinger Bands & Moving Averages in Python (Pandas) | Data Analytics #13

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Rolling Volatility, Sharpe Ratio & Drawdown in Python | Data Analytics #14
Lesson 14

Rolling Volatility, Sharpe Ratio & Drawdown in Python | Data Analytics #14

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Correlation Matrix & Diversification in Python: Stocks vs Market | Data Analytics #15
Lesson 15

Correlation Matrix & Diversification in Python: Stocks vs Market | Data Analytics #15

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Backtesting a Trading Strategy in Python (Without Fooling Yourself) | Data Analytics #16
Lesson 16

Backtesting a Trading Strategy in Python (Without Fooling Yourself) | Data Analytics #16

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Ethereum Data Analysis in Python: Price, Volatility & On-Chain Data | Data Analytics #17
Lesson 17

Ethereum Data Analysis in Python: Price, Volatility & On-Chain Data | Data Analytics #17

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Stock Screener in Python: P/E, Dividends & Value Stocks (S&P 500) | Data Analytics #1817 min
Lesson 18

Stock Screener in Python: P/E, Dividends & Value Stocks (S&P 500) | Data Analytics #18

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Value at Risk (VaR) in Python: Historical, Parametric & Monte Carlo | Data Analytics #1917 min
Lesson 19

Value at Risk (VaR) in Python: Historical, Parametric & Monte Carlo | Data Analytics #19

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Finance Analytics Portfolio Project in Python: Multi-Asset Report | Data Analytics #2017 min
Lesson 20

Finance Analytics Portfolio Project in Python: Multi-Asset Report | Data Analytics #20

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Scrape a Paginated API in Python: Social Media Posts to Pandas | Data Analytics #2118 min
Lesson 21

Scrape a Paginated API in Python: Social Media Posts to Pandas | Data Analytics #21

📊 Dataset · 📓 Notebook · pandas · JSON · Requests

Sentiment Analysis in Python with VADER: Social Media Posts | Data Analytics #2217 min
Lesson 22

Sentiment Analysis in Python with VADER: Social Media Posts | Data Analytics #22

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Customer Churn Analysis in Python: Telco Dataset | Data Analytics #2316 min
Lesson 23

Customer Churn Analysis in Python: Telco Dataset | Data Analytics #23

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

A/B Testing in Python: Real Mobile Game Experiment (Cookie Cats) | Data Analytics #2416 min
Lesson 24

A/B Testing in Python: Real Mobile Game Experiment (Cookie Cats) | Data Analytics #24

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Customer Funnel & Repeat Purchase Analysis in Python (Pandas) | Data Analytics #2516 min
Lesson 25

Customer Funnel & Repeat Purchase Analysis in Python (Pandas) | Data Analytics #25

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Hashtag Analysis in Python: Trends, Co-occurrence & Topic Clusters | Data Analytics #2618 min
Lesson 26

Hashtag Analysis in Python: Trends, Co-occurrence & Topic Clusters | Data Analytics #26

📊 Dataset · 📓 Notebook · pandas · regex (re) · collections

Web Traffic Analytics in Python: Sources, Bounce Rate & Campaigns | Data Analytics #2718 min
Lesson 27

Web Traffic Analytics in Python: Sources, Bounce Rate & Campaigns | Data Analytics #27

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Email Marketing Benchmarks in Python: Open & Click Rates | Data Analytics #2817 min
Lesson 28

Email Marketing Benchmarks in Python: Open & Click Rates | Data Analytics #28

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Airline Tweet Analysis in Python: What Makes Customers Complain? | Python Data Analytics #2917 min
Lesson 29

Airline Tweet Analysis in Python: What Makes Customers Complain? | Python Data Analytics #29

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Marketing Analytics Report in Python: Social Media Capstone | Python Data Analytics #3017 min
Lesson 30

Marketing Analytics Report in Python: Social Media Capstone | Python Data Analytics #30

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Diabetes Data Analysis in Python: Hidden Zeros & Correlation | Python Data Analytics #3117 min
Lesson 31

Diabetes Data Analysis in Python: Hidden Zeros & Correlation | Python Data Analytics #31

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Heart Disease Data Analysis in Python: Risk Factors with Pandas | Python Data Analytics #3217 min
Lesson 32

Heart Disease Data Analysis in Python: Risk Factors with Pandas | Python Data Analytics #32

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Medical Insurance Cost Analysis in Python: What Drives the Bill? | Python Data Analytics #3316 min
Lesson 33

Medical Insurance Cost Analysis in Python: What Drives the Bill? | Python Data Analytics #33

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Panel Data in Pandas: Life Expectancy Trends 1952–2007 | Python Data Analytics #3416 min
Lesson 34

Panel Data in Pandas: Life Expectancy Trends 1952–2007 | Python Data Analytics #34

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Handle '?' and Impossible Values in Pandas: Kidney Disease Data | Python Data Analytics #3516 min
Lesson 35

Handle '?' and Impossible Values in Pandas: Kidney Disease Data | Python Data Analytics #35

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Pandas explode for Comma-Separated Lists: COVID Vaccine Data | Python Data Analytics #3617 min
Lesson 36

Pandas explode for Comma-Separated Lists: COVID Vaccine Data | Python Data Analytics #36

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Counts vs Rates per 100k in Pandas: Tuberculosis Data | Python Data Analytics #3717 min
Lesson 37

Counts vs Rates per 100k in Pandas: Tuberculosis Data | Python Data Analytics #37

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Python Data Analytics #38: Global Food Consumption & Diet Footprint in Python
Lesson 38

Python Data Analytics #38: Global Food Consumption & Diet Footprint in Python

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Python Data Analytics #39: Global Health Spending vs Life Outcomes in Python
Lesson 39

Python Data Analytics #39: Global Health Spending vs Life Outcomes in Python

📊 Dataset · 📓 Notebook · pandas · NumPy · Matplotlib

Frequently asked questions

Is the Real-World Data Analytics course free?

Yes. All 39 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 Real-World Data Analytics course take?

The videos add up to about 6 hours. Most learners take one to two lessons a day, so plan on 6 to 10 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.