single
Challenge: Build a Visual Metrics Dashboard
Scorri per mostrare il menu
Scorri per iniziare a programmare
Create a function create_dashboard(df) that accepts a DataFrame with Date, Product, and Sales columns and generates a dashboard figure with two side-by-side charts and a summary statistics box.
Compute summary statistics from the Sales column:
- Total sales (sum), average sales (mean), maximum sales, and minimum sales
Create a figure with two subplots side by side using plt.subplots(1, 2), with the overall figure title "Sales Dashboard"
Left subplot — Line chart:
- Group the data by
Dateand sum the sales, then plot as a line chart with markers - Set the title to
"Sales Trend Over Time", x-label to"Date", y-label to"Sales"
Right subplot — Bar chart:
- Group the data by
Productand sum the sales, then plot as a bar chart - Set the title to
"Sales by Product", x-label to"Product", y-label to"Sales"
Add a summary statistics text box at the bottom center of the figure using fig.text(). The text must follow this exact format:
Total Sales: {value:.2f}
Average Sales: {value:.2f}
Max Sales: {value:.2f}
Min Sales: {value:.2f}
Adjust the layout using plt.tight_layout() so the stats box doesn't overlap the charts.
Soluzione
Grazie per i tuoi commenti!
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione