pandas: final assessment
This covers the whole course. Take it after the last module.
Final quiz
Practical assessment: An order analysis
Without using hints, analyse a set of order, product and customer files with pandas and produce a short checked report.
- Correct reading with types and dates, and logged cleaning of text keys and duplicates
- Validated merges with unmatched rows reported
- Revenue by category and month with shares, and the top five customers with first and last order dates
- Sanity checks in code that confirm the totals
Final project
A monthly sales report: A shop exports raw sales, products and customers as CSV files. Build a pandas script that cleans them, merges them with checks and produces a monthly report by category, region and customer.
How it is evaluated
- Correctness: totals match the raw data and hand checks
- Safety: merges are validated and exclusions are reported
- Clarity: the code reads as named steps or chains
- Communication: each table answers a stated question
To complete this course
- Score at least 70% on the final quiz
- Solve the beginner and intermediate exercises in every lesson
- Finish the final project and check it against the evaluation criteria