What you'll learn
- Python foundations for analysts
- pandas data manipulation (selection, grouping, joining, reshaping)
- Data cleaning & preparation
- Statistics for analysts
- Data visualisation
- Exploratory Data Analysis (EDA)
- Storytelling & stakeholder reporting
- Capstone end-to-end analysis
Curriculum
Python foundations for analysts5 topics
- Values, types and f-strings
- The two collections that matter: list and dict
- Control flow and comprehensions
- Functions and the analyst's vectorised mindset
- Quiz: Python foundations for analysts
pandas I — Series, DataFrames, selection5 topics
- Series and DataFrames: the two core objects
- Reading data and inspecting it
- Selecting with .loc and .iloc
- Boolean filtering: "show me X where Y."
- Quiz: pandas I — Series, DataFrames, selection
pandas II — grouping, joining, reshaping5 topics
- groupby and the split-apply-combine model
- Joining tables with merge
- Reshaping with pivot_table
- melt and long-vs-wide fluency
- Quiz: pandas II — grouping, joining, reshaping
About this course
A hands-on 45-hour programme that teaches learners to transform raw data into decision-ready insight using Python, pandas, statistics and visual storytelling, culminating in a portfolio-quality capstone analysis.