Learn A SkillLearn a skill. Change your future.
Courses › Data Analysis

Data Analysis with Python: From Raw Data to Report

Load, clean, explore, chart and test real data with pandas — and write up what you find.

Beginner English Joseph M. Lamin Updated Nov 2026

What you will be able to do

By the end of this course you will be able to:

  • Load CSV and Excel files into pandas
  • Inspect and clean data: missing values, data types, duplicates and recoding
  • Summarise data with groupby and pivot tables
  • Create clear bar charts, histograms and line charts
  • Run and interpret t-tests and chi-square tests
  • Write up results in a short, professional report

Course content

4 sections · 12 lessons · 4 h 2 min total · lessons open when you enrol

Getting started with pandas3 lessons · 24 min
Welcome and the course dataset 6 min
Notebooks and loading data 12 min
Quiz: pandas basics 6 min
Cleaning data3 lessons · 36 min
Inspecting data quality 12 min
Fixing missing values, types and categories 16 min
Quiz: cleaning data 8 min
Exploring and visualising3 lessons · 36 min
Summaries with groupby and pivot tables 14 min
Making clear charts 14 min
Quiz: exploring and charts 8 min
Testing and reporting3 lessons · 2 h 26 min
t-tests and chi-square tests 16 min
Writing up your results 10 min
Final project: analyse a dataset 120 min

About this course

Most real data is messy: missing values, inconsistent spellings, numbers stored as text. This course teaches the full workflow analysts use every day — from loading a raw spreadsheet to a clean dataset, clear charts and a short written report.

We use Python with pandas, matplotlib and SciPy in Google Colab, so you can work from any computer. The examples use a health-facility dataset, but the skills apply to surveys, sales and any tabular data. If you have never programmed, take our free Python Programming Fundamentals first.

Requirements

  • Basic Python (variables, lists, loops) — our free Python course covers it
  • A Google account for Google Colab

Who this course is for

  • Students analysing data for a project or thesis
  • M&E and data officers in NGOs and ministries
  • Excel users who want to move to Python

Your instructor

JL
Joseph M. Lamin

Software developer and health-informatics researcher based in Bo, Sierra Leone. Teaches and supervises research at Njala University School of Public Health and builds health, school and business information systems.

Learner reviews

No reviews yet. Learners can review a course once they have started it.