What is this programme?
The Python for Data Analysis Certificate is a self-paced online training programme that teaches how to load, clean, join, aggregate and visualise tabular data with Python instead of doing it by hand in a spreadsheet. It is aimed at spreadsheet users, students and junior developers, assumes no prior coding experience, and takes roughly 30 hours of study. The document issued at the end is a completion certificate: it records that the learner finished the course material and is not an accredited, regulated or licensed qualification, and it confers no professional title or right to practise. It also carries no employment or salary promise, and there is currently no public lookup service for certificate numbers, so it is best treated as supporting evidence of self-directed study alongside portfolio work.
Who it is for
Designed for people who already work with spreadsheets — analysts, marketing, finance and operations staff — and want to move repetitive reporting into code that can be rerun on next month's data. Also suitable for students, junior developers and career changers who can follow written technical instructions and install software on their own computer.
What you will be able to do
- Load data from delimited text files, JSON documents, spreadsheet workbooks and columnar files, then inspect row counts, column types and memory use before doing anything else.
- Clean messy source data by coercing types, parsing dates and time zones, standardising text case and whitespace, resolving missing values and removing duplicate records.
- Reshape datasets using boolean filtering, sorting, split-apply-combine grouping, multi-key aggregation, pivoting and wide-to-long conversion.
- Join multiple tables with inner, outer, left and right merges, and diagnose why row counts change when keys are duplicated or unmatched.
- Produce descriptive statistics, percentile summaries, correlation matrices, rolling windows and time-based resampling to describe what a dataset actually shows.
- Build labelled charts and a reproducible notebook or script that regenerates the same output from the same input file.
Modules
-
1
Analysis Environment and Python Foundations Installing a Python 3 interpreter, isolating dependencies in a virtual environment, and working in a notebook interface alongside a plain script. Covers only the language features analysis actually uses: variables and types, lists and dictionaries, loops, conditionals, functions, list comprehensions, file paths, and how to read a traceback instead of guessing at errors.
-
2
Loading and Inspecting Datasets Reading delimited files with awkward separators, quoting and character encodings; flattening nested JSON; pulling specific sheets from spreadsheet workbooks; and reading large files in chunks. Establishes a first-look routine — dimensions, column data types, sample rows, null counts and summary statistics — so problems are found before analysis, not after.
-
3
Cleaning and Preparing Data Type coercion and numeric parsing of columns stored as text, date and timestamp parsing with time zone handling, string normalisation and pattern-based extraction, categorical encoding, and duplicate detection on single and composite keys. Compares strategies for missing data — dropping, filling with a constant or group statistic, forward-filling and interpolation — and when each one distorts the result.
-
4
Transforming, Grouping and Joining Row and column selection, boolean masks, sorting and ranking, then the split-apply-combine pattern for grouped counts, sums, means and custom aggregation functions. Adds rolling and cumulative calculations, pivot and unpivot operations, and the four join types with practical checks on key uniqueness and unmatched rows after every merge.
-
5
Descriptive Statistics and Exploratory Analysis Distributions, central tendency and spread, quantiles and outlier flagging, cross-tabulation of categories, and correlation with an explicit warning that correlation is not causation. Applies these to time series through date indexing, resampling to daily, weekly or monthly grain, period-over-period change and simple trend description.
-
6
Visualisation and Reproducible Reporting Choosing between line, bar, histogram, scatter and box plots for a given question; axis scales, labels, units and annotation; and exporting figures to image files. Closes with structuring a notebook so it runs top to bottom without hidden state, parameterising a script for reuse, writing results back to file, and documenting assumptions and data caveats.
How it works
Learning format
Self-paced written material, downloaded from your dashboard. No fixed schedule and no live sessions — you work through it when it suits you.
Material delivery
Everything appears in your dashboard as soon as your payment is confirmed. Files are served only to your signed-in session.
Prerequisites
No prior programming experience is required — the first module builds the Python foundations from scratch. You should be comfortable with basic spreadsheet work (formulas, filtering, sorting), able to install software on a computer running any of the major desktop operating systems, and able to read technical material in English. All tools used are free and open source, and every practice dataset is supplied with the course.
Completion
You work through the modules and hands-on exercises at your own pace inside your panel, then finish with a short practical task: cleaning and summarising a supplied dataset and explaining the result. Once the course is marked complete, your certificate is generated and uploaded to your panel within 24-48 hours, and you are notified by email.
Your certificate
Once your completion is confirmed, we prepare your certificate and upload it to your dashboard, normally within 24–48 hours. You receive an e-mail as soon as it is there — you never have to chase it.
Refunds
Because the material is delivered digitally and immediately, purchases are non-refundable once the files have been made available to your account. The full terms are in our Refund Policy.
