Data Analytics

Python

Clean and explore the datasets that are too big for a spreadsheet

Phone: +237 672 149 730

ImageImageImageImageImage

Course Description

Every analyst eventually meets the file that Excel will not open, or the cleaning job that takes four hours of clicking and has to be repeated next month on new data.
Python is where that work becomes a few lines you can run again. You will learn just enough of the language to be useful, load and inspect data with pandas, clean and reshape frames that are too large for a spreadsheet, explore and visualise what you find, and leave with scripts that rerun themselves.

Course Outline

Avatar
Week 1

Python Basics For Analysts

Just enough language to be useful: variables, lists, dictionaries, loops and functions, written in a notebook so you see the result of every line as you type it.
Avatar
Week 2

Loading And Inspecting Data With pandas

Read CSV, Excel and database tables into a DataFrame, then inspect what you actually have: shape, column types, missing values and the summary statistics of every field.
Avatar
Week 3

Cleaning And Reshaping

Handle the work a spreadsheet struggles with: fix types and missing values, drop duplicates, split and combine columns, then group, pivot and merge frames into the table you need.
Avatar
Week 4

Exploring And Visualising

Explore a dataset properly: distributions, trends over time, comparisons between groups, and the quick charts that tell you where to look next.
Avatar
Week 5

Analysis You Can Run Again

Turn a one-off notebook into a script that runs next month on new data: functions, clear structure and output written to file, so the job stops being manual.
Message Us