Learn Challenge: Analyze Weekly Sales Data | Data Analysis for Operations Decisions

As an operations manager, you have learned how to use pandas to organize and analyze your operational data, and matplotlib to visualize key metrics for better decision making. In this challenge, you will apply these skills to a typical scenario: analyzing a week's worth of sales data to extract actionable insights. By leveraging pandas for data aggregation and matplotlib for visualization, you can quickly summarize performance, identify top-selling products, and communicate findings clearly to your team.


              12345678910111213141516171819
            
import pandas as pd

# Example DataFrame for a week's sales
data = {
    'day': ['Mon', 'Mon', 'Tue', 'Tue', 'Wed', 'Wed', 'Thu', 'Thu', 'Fri', 'Fri', 'Sat', 'Sat', 'Sun', 'Sun'],
    'item': ['Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget'],
    'units_sold': [10, 5, 12, 8, 7, 6, 15, 9, 14, 7, 13, 8, 11, 6],
    'revenue': [100, 75, 120, 120, 70, 90, 150, 135, 140, 105, 130, 120, 110, 90]
}
df = pd.DataFrame(data)

# Example summary calculations
total_revenue = df['revenue'].sum()
best_selling_item = df.groupby('item')['units_sold'].sum().idxmax()

print(f"Weekly Sales Summary")
print(f"---------------------")
print(f"Total Revenue: ${total_revenue}")
print(f"Best-Selling Item: {best_selling_item}")

When working with sales data for operational decisions, it is important to aggregate key metrics such as total revenue and units sold by item. Using pandas, you can easily group and sum data to pinpoint top performers. Visualizations like bar charts created with matplotlib make it easier to spot trends and communicate results to stakeholders. Always ensure your summary reports are clear, concise, and tailored to the needs of your audience.

Task

Swipe to start coding

Write a Python script to analyze and visualize weekly sales data for operations management decisions.

Calculate the total revenue for the week using the revenue column of the DataFrame.
Identify the best-selling item based on total units_sold for each item.
Plot a bar chart showing total units sold per item using matplotlib.
Print a summary report displaying the total revenue and the best-selling item.

Solution

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 5

single

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Swipe to show menu


              12345678910111213141516171819
            
import pandas as pd

# Example DataFrame for a week's sales
data = {
    'day': ['Mon', 'Mon', 'Tue', 'Tue', 'Wed', 'Wed', 'Thu', 'Thu', 'Fri', 'Fri', 'Sat', 'Sat', 'Sun', 'Sun'],
    'item': ['Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget', 'Widget', 'Gadget'],
    'units_sold': [10, 5, 12, 8, 7, 6, 15, 9, 14, 7, 13, 8, 11, 6],
    'revenue': [100, 75, 120, 120, 70, 90, 150, 135, 140, 105, 130, 120, 110, 90]
}
df = pd.DataFrame(data)

# Example summary calculations
total_revenue = df['revenue'].sum()
best_selling_item = df.groupby('item')['units_sold'].sum().idxmax()

print(f"Weekly Sales Summary")
print(f"---------------------")
print(f"Total Revenue: ${total_revenue}")
print(f"Best-Selling Item: {best_selling_item}")