single
Challenge: Build a Visual Metrics Dashboard
Glissez pour afficher le menu
Glissez pour commencer à coder
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.
Solution
Merci pour vos commentaires !
single
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion