Python pandas Workbook: Data Analysis Exercises with Answers and Practice Data

Learn pandas the way data analysts use it every day. This printable workbook follows one café's data through loading, filtering, cleaning, grouping, merging, pivot tables, dates and reports, with 60 exercises, 3 mini projects and full answers. A code pack with all the practice data is included.

WHAT YOU GET
- A4 PDF and US Letter PDF (59 pages)
- Code pack (.zip) with practice files, exercises and model answers
- Hyperlinked tabs and contents page for tablets

WHAT'S INSIDE
- 10 chapters: DataFrames and Series, selecting and filtering, new columns and sorting, cleaning messy data, grouping and summarising, combining tables, reshaping tables, dates and time series, pitfalls and good habits (including copy-on-write), and saving and sharing results
- 60 exercises in three styles: Predict the output, Fix the bug and Write the code
- 3 mini projects: a café weekly report, cleaning a messy customer list and takings trends
- Full answers with the real output for every exercise and project
- Code pack: five practice CSV files plus exercises.py and solutions.py

WHO IT IS FOR
People who know basic Python and want to analyse real data, students, career changers and anyone who learns best by doing.

IMPORTANT TO KNOW
- This is a digital download. Nothing is posted to you.
- You get an A4 PDF, a US Letter PDF and a code pack (.zip). Print at Actual size or 100 percent.
- Works in GoodNotes, Notability and other PDF apps. The tabs and contents page are hyperlinked.
- You need Python 3 and pandas (both free). Every answer was tested with pandas 3 and Python 3.13.
- For personal use only. Please do not share, resell or redistribute the files.

Questions before you buy? Send me a message and I will be happy to help.