codeseed
Sign in
Explore Projects
PythonbeginneraiAI generated

CSV Sales Data Summarizer

Write a script that loads a CSV of sales records with pandas and produces summary statistics, top products, and a monthly trend chart. Learners practice pandas basics, groupby aggregation, and simple matplotlib visualization.

Estimate
~6h
Steps
4
Completed by
0
Proposed by
codeseed.app

pandas · matplotlib

Sign in to claim this project

Project roadmap

  1. 01

    Load and clean the CSV data

    ~1.5h

    Read a sample sales CSV with pandas, parse dates, and handle missing or malformed rows.

  2. 02

    Compute summary statistics

    ~2h

    Calculate total revenue, average order value, and top-selling products using groupby and aggregation functions.

  3. 03

    Build a monthly trend chart

    ~1.5h

    Resample the data by month and plot revenue over time with matplotlib, saving the chart as a PNG.

  4. 04

    Generate a text summary report

    ~1h

    Produce a plain-text or markdown report combining the key statistics and save it alongside the chart.

Resources

Ready to build this?

Get a GitHub repo and start building. Your AI reviewer checks each step as you go.

~6h · 4 steps

Tech stack

pandasmatplotlib