Track 17 · Lesson 11 of 12

Project: monthly report automation

Automate a month-end chore: sort branch exports into folders, combine and validate them, and produce a Markdown sales report with a log of every step.

You will be able to

• Recognise and organise files by name with regular expressions, pathlib and shutil
• Combine several CSV exports into one set of rows while collecting every data problem with its file and line
• Summarise rows into ranked totals and turn them into a Markdown report written to disk
• Log what an automated job did with the logging module, without duplicate or time-dependent lines
• Tie the steps into one run_pipeline() function that can be re-run safely