← Back to courses
Data Science and AI
Data Analysis with Python and pandas
Load, clean, reshape and summarise real datasets
A classroom course in analysing data with code instead of a spreadsheet. The modules follow sections of the pandas user guide: data structures, reading and writing files, indexing and selecting, missing data, merging and joining, reshaping and pivot tables, group by, time series and chart visualisation. This course prepares for no exam.
10Modules
BeginnerLevel
2 monthsDuration
COURSE THUMBNAIL
What you will be able to do
Load data from files into pandas and inspect it
Clean a messy dataset, including missing values
Combine several tables into one
Summarise data with group by and pivot tables
Analyse data over time and chart the result
Course outline
01
Python essentials for data work
02
pandas data structures: Series and DataFrame
03
Reading and writing data: CSV, Excel and more
04
Indexing and selecting data
05
Working with missing and text data
06
Merge, join and concatenate
07
Reshaping and pivot tables
08
Group by: split, apply, combine
09
Time series and date functionality
10
Chart visualisation and a project on your own dataset
Tools you will use
PythonpandasNumPyMatplotlibJupyter
What you need
General computer skills
No programming experience needed; the first module covers the Python the course uses
