Course · 12 modules · 87 lessons
Data Analytics II: Python for Data Analytics
A 12-week hands-on course that takes you from your first line of Python to a reproducible pandas analysis you can hand to a stakeholder. Module 2 of the Orglobal Data Analytics track. You learn Python the way an analyst uses it: types and validation, lists and dictionaries of records, loops and comprehensions, functions with tests, dates, regular expressions, files and JSON, Git and virtual environments, classes, NumPy arrays, and pandas for loading, cleaning, grouping, merging and charting data. You also collect data from an authorised web page and serve it through a small Flask API. The centrepiece is the City Bus Operations Quest in Week 5: validate route records, compute revenue and risk, rank routes and simulate a delay reduction without corrupting the original data. You finish with an end-to-end pandas analysis project. Entry requirement: Data Analytics I (Excel, Power BI & SQL) or equivalent comfort with tables, filters and basic aggregation. No prior programming experience is needed. Expect 10–15 hours a week for lessons, labs and a weekly project.
You can preview 3 lessons free.
Enroll for full access to every lesson, practical and instructor review.
01Week 1 — Environment & Language Basics
- Using AI in this course: the rulesFree preview15m
- Why analysts learn Python & setting upFree preview50m
- Notebooks, scripts & execution order40m
- Variables, types & conversion45m
- Formatted output, input & reading errors45m
- Lab: setup check & a reproducible first notebookPractical60m
- Lab: practice orders by hand in PythonPractical50m
- Weekly project: a validated order calculatorProjectFree preview150m
02Week 2 — Strings & Collections
- Strings: indexing, slicing & cleaning labels45m
- Lists & tuples: many values, fixed records40m
- Dictionaries & sets: rows and unique values45m
- A table in Python: a list of dictionaries45m
- Lab: clean messy category labelsPractical60m
- Lab: summarise route dictionariesPractical60m
- Weekly project: practice orders summariserProject150m
03Week 3 — Conditions, Loops & Comprehensions
- Conditions: turning business rules into code45m
- Loops: for, range, while, break & continue45m
- Comprehensions: build lists in one line45m
- Trace a loop by hand & find the boundaries40m
- Lab: classify routes by delayPractical60m
- Lab: loop vs comprehensionPractical50m
- Weekly project: route delay reportProject150m
04Week 4 — Functions, Exceptions & Dates
- Functions: name a calculation, return a result45m
- Scope & not changing your input by accident40m
- Exceptions & assertions: fail usefully45m
- Dates: parse, format, subtract & time zones45m
- Lab: a route validator that returns every errorPractical70m
- Lab: parse messy text into numbers & datesPractical60m
- Weekly project: order analysis toolkit (functions + tests)Project150m
- AI and code that looks right: invented functions & packages15m
05Week 5 — The City Bus Operations Quest
- The quest: rules, records & a plan of attack45m
- Copies, mutation & what-if scenarios40m
- Classifying, ranking, ties & rounding money45m
- Report as data, then self-checks40m
- Lab: quest part 1 — records, validation & metricsPractical90m
- Lab: quest part 2 — risk, rankings, report & simulationPractical90m
- Quest submission: City Bus Operations (25%)Project240m
06Week 6 — Modules, Higher-Order Functions & Classes
- Modules: move tested code out of the notebook45m
- Functions as values: lambda, map, sorted & closures45m
- Decorators & type hints35m
- Classes & objects: data with behaviour attached45m
- Lab: move route calculations into a modulePractical70m
- Lab: a Person class and a Route classPractical60m
- Weekly project: a reusable orders toolkit moduleProject180m
07Week 7 — Files, JSON, Regex, Git & Environments
- Files: read, write & handle what is missing45m
- JSON: saving structured records40m
- Regular expressions: patterns in messy text45m
- Git & virtual environments: reproducible projects50m
- Lab: JSON round trip & failure handlingPractical60m
- Lab: parse a control-room log with regexPractical70m
- Weekly project: your analysis portfolio on GitHubProject180m
- AI, secrets & data in your repository15m
08Week 8 — NumPy Arrays
- NumPy arrays: dimensions, shape & dtype40m
- Indexing, slicing, axes & boolean masks45m
- Views vs copies: when changing one changes the other40m
- Vectorised maths, broadcasting & shape checks45m
- Lab: a route × day delay matrixPractical60m
- Lab: vectorise the bus quest & reconcilePractical70m
- Weekly project: a week of route performance with NumPyProject180m
09Week 9 — pandas: Load, Inspect & Clean
- DataFrames: load a CSV & inspect it45m
- Selecting, filtering & sorting40m
- Missing values, duplicates & type problems50m
- Derived fields, copies & the cleaning log45m
- Lab: load & reconcile the practice orders in pandasPractical60m
- Lab: clean the messy orders with a full logPractical75m
- Weekly project: a reusable cleaning pipelineProject180m
10Week 10 — pandas: Group, Merge & Visualise
- groupby & pivot tables: summarise at the right grain45m
- Merging tables on verified keys50m
- Charts that answer a question40m
- Distributions, outliers & correlation vs causation45m
- Lab: revenue breakdowns & safe mergesPractical70m
- Lab: four honest chartsPractical60m
- Weekly project: a sales analysis notebookProject180m
- Checking AI-written pandas: line by line, total by total20m
11Week 11 — Data Collection, HTTP & Flask APIs
- HTTP: requests, responses, status codes & JSON45m
- Collecting a table from an authorised web page50m
- Build a small Flask API: GET, POST & validation50m
- Testing an API: valid, invalid & malformed requests40m
- Lab: collect an authorised table & save it as CSVPractical75m
- Lab: a student or inventory APIPractical75m
- Weekly project: from collection to reportProject180m
12Week 12 — pandas Analysis Project
- Scoping an analysis that answers a real question40m
- Structure, reproducibility & the stakeholder summary45m
- Lab: one-page plan & data dictionaryPractical90m
- Lab: reproducibility & peer review clinicPractical75m
- Final project: reproducible pandas analysis (30%)Project300m
- Lead stage: delegating to AI & defending your analysis15m
Already enrolled? Sign in with your enrollment email to unlock all lessons.