A monthly sales report

The problem

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.

Requirements

Technologies

Step by step

  1. Inspect the three files and write down the questions and definitions.
  2. Load and clean each file, logging what changed.
  3. Merge with checks and compute the monthly and category tables.
  4. Add sanity checks and write the report tables and summary.

Expected result

A script that rebuilds the whole report from the raw files in one run.

How it is evaluated

Ways to improve it