Data AnalyticsIntermediate
Python Data Analysis with pandas
For those who know the pandas basics and want to use it like a practitioner. This day covers advanced indexing, data reshaping, time series manipulation, and performance — the techniques that matter when working with large, complex, real-world datasets.
Tools & Technologies
PythonpandasNumPyJupyter
Course Curriculum
1
Advanced Indexing
- MultiIndex DataFrames
- loc vs iloc — and when each matters
- Boolean masks and chained indexing pitfalls
2
Data Transformation
- apply, map, and vectorised operations
- merge, join, and concat — choosing the right one
- Pivot, melt, and reshaping between wide and long
3
Time Series Analysis
- DatetimeIndex and period indexing
- Resampling and frequency conversion
- Rolling windows, expanding windows, date arithmetic
4
Performance & Scale
- Vectorisation vs iteration — the performance gap
- Efficient data loading with chunking and dtypes
- Memory optimisation for large datasets
What's Included
Live instructor-led session
Small cohort
Course materials pack (slides, code, datasets)
Certificate of completion
14-day email support
£740Early bird
£495Save £245
per person
7 hours (1 day)
Next: Thu, 26 Mar 2026
7 seats remaining
Intermediate level
5/12 seats filled
Completion certificate included