DataCareerHub
Explore learning
← Practice challengesFree companion · 15 minute suggested activity

Group sales by month in Python

Python practice · Python 3.10+ standard library · Run locally in a folder containing the supplied files.

Learn → Try → ExplainReviewed 2026-10-15
01

Your task

Build a dictionary of completed sales per period without a third-party package. Explain the expected output before running the code.

02

Hint

Read with csv.DictReader so column names are explicit. CSV values are strings until converted. Keep parsing failures visible.

Worked solution

April 30000 and May 40000 cents. Sorting YYYY-MM strings works for this validated format, not arbitrary date labels.

import csv
with open('retail-orders.csv',newline='',encoding='utf-8') as f:
    rows=list(csv.DictReader(f))
from collections import defaultdict
monthly=defaultdict(int)
for r in rows:
    if r['status']=='completed': monthly[r['period']]+=int(r['net_cents'])
assert dict(monthly)=={'2026-04':30000,'2026-05':40000}
print(sorted(monthly.items()))
04

Extend the test

Change one input in a disposable copy and predict which check should fail. Restore the original before comparing results.

Make the reasoning yours.

Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.

Resume guidance and examples are for learning and preparation only. They do not guarantee interviews, a job offer or employment.

Public registration, payments and new paid enrolment remain disabled. These free resources do not grant access to protected course modules.

Learner dashboard ↗ · Ask a question ↗