← All courses

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.

Enroll for full access

01Week 1 — Environment & Language Basics

  1. Using AI in this course: the rules
    Free preview15m
  2. Why analysts learn Python & setting up
    Free preview50m
  3. Notebooks, scripts & execution order
    40m
  4. Variables, types & conversion
    45m
  5. Formatted output, input & reading errors
    45m
  6. Lab: setup check & a reproducible first notebook
    Practical60m
  7. Lab: practice orders by hand in Python
    Practical50m
  8. Weekly project: a validated order calculator
    ProjectFree preview150m

02Week 2 — Strings & Collections

  1. Strings: indexing, slicing & cleaning labels
    45m
  2. Lists & tuples: many values, fixed records
    40m
  3. Dictionaries & sets: rows and unique values
    45m
  4. A table in Python: a list of dictionaries
    45m
  5. Lab: clean messy category labels
    Practical60m
  6. Lab: summarise route dictionaries
    Practical60m
  7. Weekly project: practice orders summariser
    Project150m

03Week 3 — Conditions, Loops & Comprehensions

  1. Conditions: turning business rules into code
    45m
  2. Loops: for, range, while, break & continue
    45m
  3. Comprehensions: build lists in one line
    45m
  4. Trace a loop by hand & find the boundaries
    40m
  5. Lab: classify routes by delay
    Practical60m
  6. Lab: loop vs comprehension
    Practical50m
  7. Weekly project: route delay report
    Project150m

04Week 4 — Functions, Exceptions & Dates

  1. Functions: name a calculation, return a result
    45m
  2. Scope & not changing your input by accident
    40m
  3. Exceptions & assertions: fail usefully
    45m
  4. Dates: parse, format, subtract & time zones
    45m
  5. Lab: a route validator that returns every error
    Practical70m
  6. Lab: parse messy text into numbers & dates
    Practical60m
  7. Weekly project: order analysis toolkit (functions + tests)
    Project150m
  8. AI and code that looks right: invented functions & packages
    15m

05Week 5 — The City Bus Operations Quest

  1. The quest: rules, records & a plan of attack
    45m
  2. Copies, mutation & what-if scenarios
    40m
  3. Classifying, ranking, ties & rounding money
    45m
  4. Report as data, then self-checks
    40m
  5. Lab: quest part 1 — records, validation & metrics
    Practical90m
  6. Lab: quest part 2 — risk, rankings, report & simulation
    Practical90m
  7. Quest submission: City Bus Operations (25%)
    Project240m

06Week 6 — Modules, Higher-Order Functions & Classes

  1. Modules: move tested code out of the notebook
    45m
  2. Functions as values: lambda, map, sorted & closures
    45m
  3. Decorators & type hints
    35m
  4. Classes & objects: data with behaviour attached
    45m
  5. Lab: move route calculations into a module
    Practical70m
  6. Lab: a Person class and a Route class
    Practical60m
  7. Weekly project: a reusable orders toolkit module
    Project180m

07Week 7 — Files, JSON, Regex, Git & Environments

  1. Files: read, write & handle what is missing
    45m
  2. JSON: saving structured records
    40m
  3. Regular expressions: patterns in messy text
    45m
  4. Git & virtual environments: reproducible projects
    50m
  5. Lab: JSON round trip & failure handling
    Practical60m
  6. Lab: parse a control-room log with regex
    Practical70m
  7. Weekly project: your analysis portfolio on GitHub
    Project180m
  8. AI, secrets & data in your repository
    15m

08Week 8 — NumPy Arrays

  1. NumPy arrays: dimensions, shape & dtype
    40m
  2. Indexing, slicing, axes & boolean masks
    45m
  3. Views vs copies: when changing one changes the other
    40m
  4. Vectorised maths, broadcasting & shape checks
    45m
  5. Lab: a route × day delay matrix
    Practical60m
  6. Lab: vectorise the bus quest & reconcile
    Practical70m
  7. Weekly project: a week of route performance with NumPy
    Project180m

09Week 9 — pandas: Load, Inspect & Clean

  1. DataFrames: load a CSV & inspect it
    45m
  2. Selecting, filtering & sorting
    40m
  3. Missing values, duplicates & type problems
    50m
  4. Derived fields, copies & the cleaning log
    45m
  5. Lab: load & reconcile the practice orders in pandas
    Practical60m
  6. Lab: clean the messy orders with a full log
    Practical75m
  7. Weekly project: a reusable cleaning pipeline
    Project180m

10Week 10 — pandas: Group, Merge & Visualise

  1. groupby & pivot tables: summarise at the right grain
    45m
  2. Merging tables on verified keys
    50m
  3. Charts that answer a question
    40m
  4. Distributions, outliers & correlation vs causation
    45m
  5. Lab: revenue breakdowns & safe merges
    Practical70m
  6. Lab: four honest charts
    Practical60m
  7. Weekly project: a sales analysis notebook
    Project180m
  8. Checking AI-written pandas: line by line, total by total
    20m

11Week 11 — Data Collection, HTTP & Flask APIs

  1. HTTP: requests, responses, status codes & JSON
    45m
  2. Collecting a table from an authorised web page
    50m
  3. Build a small Flask API: GET, POST & validation
    50m
  4. Testing an API: valid, invalid & malformed requests
    40m
  5. Lab: collect an authorised table & save it as CSV
    Practical75m
  6. Lab: a student or inventory API
    Practical75m
  7. Weekly project: from collection to report
    Project180m

12Week 12 — pandas Analysis Project

  1. Scoping an analysis that answers a real question
    40m
  2. Structure, reproducibility & the stakeholder summary
    45m
  3. Lab: one-page plan & data dictionary
    Practical90m
  4. Lab: reproducibility & peer review clinic
    Practical75m
  5. Final project: reproducible pandas analysis (30%)
    Project300m
  6. Lead stage: delegating to AI & defending your analysis
    15m

Already enrolled? Sign in with your enrollment email to unlock all lessons.