Track 8 · Lesson 11 of 11

Mini project: consolidating branch sales

Combine messy CSV exports from several shop branches into a validated summary CSV and a JSON report, one milestone at a time.

About 75 minAdvanced5 exercises

You will be able to

Find and load several CSV exports from a folder, using a JSON catalogue to normalise product names
Record every rejected row and duplicate with a clear, located problem message
Handle missing folders, empty files and header-only files without crashing
Write a summary CSV with a total row and a nested JSON report from the same clean records

Included with a Formula Quest membership

It has 5 graded exercises with feedback, hints and solutions. Python Quest is included in Formula Quest memberships that cover Python; membership and billing are managed on Formula Quest.

View Formula Quest memberships

Tracks 1 and 2, the first lesson of every track, the playground and the dataset library are free.