Data Project: Prepare a Fictional Activity Log

Unit ID: M09-U10 Estimated active time: 65-90 minutes

Use the supplied activity_log.csv and module_lookup.csv. Preserve both source files.

Required work

1. Load raw fields as text and inspect shape, columns, blanks, and duplicate learner-module keys.
2. Clean IDs, status, minutes, score, and region with explicit rules.
3. Reject invalid IDs, status, minutes, non-empty invalid score text, and later duplicate keys.
4. Allow a blank score and preserve it as missing.
5. Create hours, passed-score, and completed-and-passed fields.
6. Left-join module names with relationship validation and report unmatched module IDs.
7. Produce a grouped module summary and labelled bar chart with text equivalent.
8. Export clean, rejected, summary, and transformation-log files separately.
9. Restart and run all from clean state.

Expected: six clean rows, two rejected rows, one unmatched module ID (M03), and MODULE 9 PROJECT: PASS.