medium Data Analysis

Sales Dashboard CLI

The Brief

A regional manager wants a quick command-line dashboard for browsing sales data without opening a spreadsheet. Build a menu-driven program that loops until the user chooses to quit, with options for showing all data, total revenue, the top-selling product, and average units sold.

Acceptance Criteria

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

5 Option 2 prints the total revenue formatted as currency

7 Option 4 prints the average units sold rounded to 2 decimal places

8 The quit option breaks the loop with a goodbye message

2 Display a numbered menu with at least 4 options plus a quit option

3 Use a while True loop with input() to repeatedly accept choices

9 Invalid input prints an error and re-shows the menu without crashing

1 Load the sales data into a pandas DataFrame

4 Option 1 prints the full DataFrame

6 Option 3 prints the product with the highest total revenue using groupby

💡 Hints 0 / 3

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

solution.py

Python 3

import pandas as pd
import io

data = """Date,Product,Units,Revenue
2024-01-01,Widget A,12,240.00
2024-01-02,Widget B,8,200.00
2024-01-03,Widget A,15,300.00
2024-01-04,Widget C,5,75.00
2024-01-05,Widget B,11,275.00
2024-01-06,Widget A,9,180.00
2024-01-07,Widget C,7,105.00"""

df = pd.read_csv(io.StringIO(data))

# Build your menu loop here

Console