medium File Handling & Data

CSV Sales Analyser

The Brief

RetailPulse, a mid-size chain, emails their analysts a CSV of daily sales every morning. The analysts have been copy-pasting totals into calculators by hand. Automate the analysis — read the CSV, compute key stats, and print a clean summary.

Acceptance Criteria

Tap a criterion to mark it off as you work. Tap a category header to expand or collapse.

2 Compute total revenue, mean sale value, and the single highest sale

3 Print a formatted summary with currency to 2 decimal places

4 Handle the case where the file is empty — print a clear message instead of crashing

1 Use the csv module to parse the provided CSV data (see starter)

💡 Hints 0 / 3

Guest Mode Attempt this challenge freely, or log in to earn EXP & CodeCoins.

solution.py

Python 3

import csv
import io

# In the real system this would be a file; for this trial the CSV is inline.
CSV_DATA = """date,product,amount
2026-04-01,Widget,29.99
2026-04-01,Gadget,149.50
2026-04-02,Widget,29.99
2026-04-02,Sprocket,8.75
2026-04-03,Gadget,149.50
2026-04-03,Sprocket,8.75
2026-04-03,Widget,29.99
"""

reader = csv.DictReader(io.StringIO(CSV_DATA))
# TODO: collect amounts, then compute and print summary

Console