Python for Data Analysts
A free 12-lesson course. Every lesson has a video walkthrough and a Jupyter notebook you can download or open in Google Colab; 4 lessons include real datasets. Tools covered: pandas, NumPy, openpyxl, Requests, datetime, JSON.
- Lessons12
- Videoabout 7 hours
- LevelBeginner
- PriceFree
- Datasets4
About this course
Python for Data Analysts is a free beginner course with 12 video lessons (about 7 hours of video in total). It starts with “Pandas Zero to Hero: The Complete Beginner-to-Advanced Course” and finishes with “Building a Streamlit Data App”. Every lesson comes with the exact Jupyter notebook used in the video, and 4 of them include the dataset, so you can follow along with the same data.
Along the way you'll use pandas, NumPy, openpyxl, Requests, datetime and JSON.
It suits complete beginners: no prior coding is assumed, and each video explains every line.
Course outline
- Pandas Zero to Hero: The Complete Beginner-to-Advanced Course – One notebook, start to finish: from your first DataFrame to groupby, merging, pivot tables, and rolling windows. No prior pandas…
- Python Zero to Hero: The Complete Beginner-to-Advanced Course – One notebook, start to finish: from your very first print() to decorators, generators, and object-oriented programming. No prior…
- NumPy Zero to Hero: The Complete Beginner-to-Advanced Course – One notebook, start to finish: from your first array to broadcasting, vectorized math, and basic linear algebra. No prior NumPy experience…
- Python for Beginners: From Variables to Real Mini Projects – By the end, you'll have built three real mini projects: a deadline countdown tool, a spreadsheet automation script, and a program that…
- Time Series Analysis with Pandas – Everything you need to work with dates and time-indexed data: DatetimeIndex, resampling, rolling windows, seasonality, and simple…
- End-to-End Data Analyst Capstone – One messy, realistic dataset, taken all the way from raw and broken to cleaned, analyzed, visualized, and reported. This capstone assumes…
- Web APIs & Requests In Depth – Everything you need to talk to real web APIs from Python: GET, POST, JSON, auth, pagination, retries, and error handling. No prior…
- Automate Excel with Python openpyxl: Formulas, Charts, Formatting – openpyxl tutorial: create workbooks, write cells and formulas, add formatting, conditional formatting, charts and data validation, then…
All 12 lessons
57 minPandas Zero to Hero: The Complete Beginner-to-Advanced Course
1 h 3 minPython Zero to Hero: The Complete Beginner-to-Advanced Course
33 minNumPy Zero to Hero: The Complete Beginner-to-Advanced Course
1 h 1 minPython for Beginners: From Variables to Real Mini Projects
34 minTime Series Analysis with Pandas
32 minEnd-to-End Data Analyst Capstone
27 minWeb APIs & Requests In Depth
36 minAutomate Excel with Python openpyxl: Formulas, Charts, Formatting
33 minWeb Scraping with BeautifulSoup
23 minIntro to Machine Learning with scikit-learn
26 minSQL for Python Users with sqlite3
20 minBuilding a Streamlit Data App
Frequently asked questions
Is the Python for Data Analysts course free?
Yes. All 12 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 Python for Data Analysts course take?
The videos add up to about 7 hours. Most learners take one to two lessons a day, so plan on 2 to 3 weeks if you code along.
What level is it?
Beginner. It suits complete beginners: no prior coding is assumed, and each video explains every line.