medium Data Visualisation

Bar Chart: Revenue by Product

The Brief

Management wants a bar chart of total revenue per product for the briefing pack. Use pandas to aggregate the data and matplotlib to plot a labelled bar chart, then save it to a PNG file. The VM is headless so use the Agg backend and savefig instead of show.

Acceptance Criteria

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

3 Group by Product and sum Revenue to get totals per product

2 Load the data into a pandas DataFrame

1 Set the matplotlib backend to Agg BEFORE importing pyplot using matplotlib.use

4 Create a bar chart with product names on the x-axis and revenue on the y-axis

5 Add a chart title

6 Add x-axis and y-axis labels

7 Save the figure to revenue_chart.png using plt.savefig

8 Print a confirmation message that the chart was saved

💡 Hints 0 / 3

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

solution.py

Python 3

import matplotlib
matplotlib.use("Agg")
import matplotlib.pyplot as plt
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))

# Aggregate revenue by product
# Create bar chart
# Add title and axis labels
# Save to revenue_chart.png

Console