ai-data-analysis-guided-tour
Create a small example of monthly shop sales for one year. Show the sales in a simple line chart and explain three important changes in plain language.
Thinking
Generating chart data
I want to provide a chart with a small example of data generation. It appears I need just one piece of code, but I can't see the output directly. I should define the chart values in my explanation. For clarity, I need to make sure the y-axis is labeled as "Sales (USD)," and I’m pondering if I should use dollar symbols in the code. Technically, I might treat currency amounts as strings in the code itself. Ultimately, I need to create that single code snippet!
Here is a simple one-year sales example. The line chart highlights seasonal changes across the year.
</>Plot monthly sales
import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
sales = pd.DataFrame({
"Month": pd.date_range("2024-01-01", periods=12, freq="MS"),
"Sales_USD": [12000, 13500, 12800, 14500, 16200, 17800, 17100, 16500, 18200, 19500, 23000, 28500]
})
plt.figure(figsize=(10, 5))
sns.lineplot(data=sales, x="Month", y="Sales_USD", marker="o", linewidth=2.5, color="#2a6fbb")
plt.title("Monthly Shop Sales")
plt.xlabel("Month")
plt.ylabel("Sales (USD)")
plt.xticks(sales["Month"], sales["Month"].dt.strftime("%b"), rotation=0)
plt.grid(axis="y", alpha=0.3)
plt.tight_layout()
plt.show()
Three important changes:
-
Sales increased steadily from January to June, rising from 12,000 USD to 17,800 USD. This suggests the shop gained momentum during the first half of the year.
-
Sales dipped slightly from July through August, falling from 17,100 USD to 16,500 USD. This may reflect a quieter summer period.
-
Sales grew strongly in the final quarter, especially from October to December. December reached 28,500 USD, the year’s highest month, which could indicate holiday demand.
Thinking
Clarifying data display
I need to make sure I'm clear on what's going on. The policy says that if the output is a chart only, it doesn't show the underlying numeric or text values. So, I think I should choose option B to display those. I wonder if I need to show those values in a compact way or perhaps include them in a table format? I’ll figure out the best way to present these details.
The chart shows sales rising overall across the year, with a brief mid-year slowdown and a strong year-end peak.
</>Format and display sales data
display(sales.assign(Month=sales["Month"].dt.strftime("%b"), Sales_USD=sales["Sales_USD"].map(lambda x: f"{x:,.0f} USD")))| Month | Sales_USD | |
|---|---|---|
| 0 | Jan | 12,000 USD |
| 1 | Feb | 13,500 USD |
| 2 | Mar | 12,800 USD |
| 3 | Apr | 14,500 USD |
| 4 | May | 16,200 USD |
| 5 | Jun | 17,800 USD |
| 6 | Jul | 17,100 USD |
| 7 | Aug | 16,500 USD |
| 8 | Sep | 18,200 USD |
| 9 | Oct | 19,500 USD |
| 10 | Nov | 23,000 USD |
| 11 | Dec | 28,500 USD |
The monthly line chart shows an overall upward sales trend, ending with the strongest period of the year.
-
Sales rose during the first half of the year. They increased from 12,000 USD in January to 17,800 USD in June, despite a small drop in March.
-
There was a modest summer decline. Sales fell from 17,800 USD in June to 16,500 USD in August, indicating a quieter period before demand recovered.
-
Year-end sales accelerated sharply. Sales climbed from 19,500 USD in October to 28,500 USD in December. December was the highest month, likely reflecting stronger holiday-season shopping.
Make a time plot of the data.
The existing line chart is a time plot of the monthly sales data, with months on the x-axis and sales on the y-axis.
Make a histogram of the Sales_USD
Thinking
Creating a response chart
I need to produce a single response chart, and it looks like I'll be using sns histplot for this. I want to make sure to include appropriate labels so that the information is clear and easy to understand. Charts can be great for visualizing data, but I’ll need to keep an eye on the details to ensure everything is presented properly. Let’s get started!
</>Plot sales distribution
plt.figure(figsize=(8, 5))
sns.histplot(data=sales, x="Sales_USD", bins=6, color="#2a6fbb", edgecolor="white")
plt.title("Distribution of Monthly Shop Sales")
plt.xlabel("Monthly Sales (USD)")
plt.ylabel("Number of Months")
plt.tight_layout()
plt.show()
The histogram shows sales concentrated in the mid-range—roughly 12,000 USD to 19,500 USD—with a smaller group of higher values in November and December. December’s 28,500 USD is the highest observation and creates a right-skewed distribution.