applying it to both weeks kept the logic consistent and the code DRY (Don't Repeat Yourself). 2. **Left merge** — keeping all transactions even if the customer master had a gap, and then explicitly checking for unmatched rows. 3. **Named aggregations in `.agg()`** — self-documenting column names tha