The request

From Laura Bennett, Head of Finance
Your goal
Take order lines with quantity > 0 from orders with status 'completed' placed in 2025, and compute each order's value (the sum of quantity * unit_price * (1 - discount_pct / 100)). Draw a histogram with bins every $100 from 0 to 2,000. Set result to a DataFrame with the same counts: columns bin_start (0, 100, …, 1900) and n_orders (orders whose value is in [bin_start, bin_start + 100); the last bin also includes exactly 2,000), 20 rows in bin order, index 0 to 19. Orders above $2,000 are left out.
- Use the
ordersDataFramenot done yet - Use the
order_itemsDataFramenot done yet - Show exactly
bin_startn_ordersnot done yet
Your code
Loading the editor…
Reference solution
| order_id | customer_id | order_date | status | channel |
|---|---|---|---|---|
| 1001 | 125 | 2023-01-01 20:51:19 | completed | web |
| 1002 | 156 | 2023-01-02 07:58:46 | completed | web |
| 1003 | 22 | 2023-01-02 10:25:27 | completed | marketplace |
| 1004 | 48 | 2023-01-02 11:21:51 | completed | marketplace |
Mote checks your result
Press Run. Each row that matches the goal becomes a firefly in your lantern.
What Laura gets, and why
DataFrames
Loaded for you as pandas DataFrames, plus pd and np.
orders12,000 rows · 7 columns
order_idintegercustomer_idintegerorder_datetimestampstatusvarcharchannelvarcharshipping_feedecimalcoupon_codevarchar
| order_id | customer_id | order_date | status | channel | shipping_fee | coupon_code |
|---|---|---|---|---|---|---|
| 1001 | 125 | 2023-01-01 20:51:19 | completed | web | 0.00 | NaN |
| 1002 | 156 | 2023-01-02 07:58:46 | completed | web | 0.00 | NaN |
| 1003 | 22 | 2023-01-02 10:25:27 | completed | marketplace | 4.99 | WELCOME10 |
| 1004 | 48 | 2023-01-02 11:21:51 | completed | marketplace | 4.99 | WELCOME10 |
| 1005 | 82 | 2023-01-02 11:43:36 | completed | web | 0.00 | WELCOME10 |
order_items30,338 rows · 6 columns
order_item_idintegerorder_idintegerproduct_idintegerquantityintegerunit_pricedecimaldiscount_pctdecimal
| order_item_id | order_id | product_id | quantity | unit_price | discount_pct |
|---|---|---|---|---|---|
| 1 | 1001 | 121 | 9 | 31.99 | 0.00 |
| 2 | 1001 | 154 | 3 | 11.99 | 0.00 |
| 3 | 1002 | 154 | 4 | 11.99 | 0.00 |
| 4 | 1002 | 194 | 1 | 149.00 | 0.00 |
| 5 | 1002 | 193 | 2 | 19.99 | 0.00 |
customers2,018 rows · 9 columns
customer_idintegerfirst_namevarcharlast_namevarcharemailvarcharcityvarcharstatevarcharsignup_datedatesegmentvarcharreferral_sourcevarchar
| customer_id | first_name | last_name | city | state | signup_date | segment | referral_source | |
|---|---|---|---|---|---|---|---|---|
| 1 | Owen | Hudson | owen.hudson@icloud.com | San Francisco | CA | 2022-06-02 | consumer | search |
| 2 | Douglas | Mendoza | dmendoza69@gmail.com | Atlanta | GA | 2022-06-02 | consumer | NaN |
| 3 | Henry | Brooks | hbrooks@lakesidecafe.com | Los Angeles | CA | 2022-06-04 | business | NaN |
| 4 | Brian | Graham | bgraham@bluecedarhomes.com | Seattle | WA | 2022-06-06 | business | |
| 5 | Kyle | Jimenez | kjimenez27@yahoo.com | Indianapolis | IN | 2022-06-07 | consumer | NaN |
products120 rows · 8 columns
product_idintegernamevarcharcategoryvarcharsubcategoryvarcharunit_pricedecimalunit_costdecimallaunched_ondateis_activeboolean
| product_id | name | category | subcategory | unit_price | unit_cost | launched_on | is_active |
|---|---|---|---|---|---|---|---|
| 101 | Vale Velvet Loveseat | Furniture | Sofas | 1659.00 | NaN | 2023-09-11 | true |
| 102 | Alder Oak Coffee Table | Furniture | Tables | 919.00 | 503.50 | 2024-05-16 | true |
| 103 | Orchard Rattan Dining Chair | Furniture | Chairs | 789.00 | 429.87 | 2023-05-27 | true |
| 104 | Upland Oak Bookcase | Furniture | Storage | 429.00 | 214.70 | 2022-12-20 | true |
| 105 | Avery Leather Bed Frame | Furniture | Beds | 449.00 | 232.70 | 2021-08-31 | true |
returns1,673 rows · 5 columns
return_idintegerorder_item_idintegerreturned_ondatereasonvarcharrefund_amountdecimal
| return_id | order_item_id | returned_on | reason | refund_amount |
|---|---|---|---|---|
| 1 | 14 | 2023-01-10 | damaged | 83.69 |
| 2 | 42 | 2023-01-10 | wrong_item | 19.99 |
| 3 | 105 | 2023-01-14 | wrong_item | 10.99 |
| 4 | 24 | 2023-01-16 | changed_mind | 26.99 |
| 5 | 126 | 2023-01-16 | late | 20.99 |
employees60 rows · 8 columns
employee_idintegerfirst_namevarcharlast_namevarchardepartmentvarchartitlevarcharmanager_idintegerhire_datedatesalaryinteger
| employee_id | first_name | last_name | department | title | manager_id | hire_date | salary |
|---|---|---|---|---|---|---|---|
| 1 | Catherine | Hale | Executive | Chief Executive Officer | NaN | 2016-03-01 | 285000 |
| 2 | Robert | Kim | Executive | Chief Operating Officer | 1 | 2017-01-09 | 235000 |
| 3 | Megan | Collins | Sales | Head of Sales | 1 | 2018-04-16 | 172000 |
| 4 | Chloe | Gutierrez | Sales | Account Executive | 3 | 2020-01-21 | 72000 |
| 5 | Frank | Bell | Sales | Account Executive | 3 | 2023-05-21 | 73000 |
web_sessions40,000 rows · 7 columns
session_idintegercustomer_idintegerstarted_attimestampdevicevarcharsourcevarcharpages_viewedintegerconvertedboolean
| session_id | customer_id | started_at | device | source | pages_viewed | converted |
|---|---|---|---|---|---|---|
| 1 | NaN | 2023-01-01 23:02:24 | mobile | paid | 1 | false |
| 2 | 18 | 2023-01-01 15:07:49 | desktop | paid | 1 | false |
| 3 | NaN | 2023-01-01 16:55:46 | desktop | direct | 7 | false |
| 4 | NaN | 2023-01-01 12:43:28 | mobile | organic | 3 | false |
| 5 | NaN | 2023-01-01 13:06:21 | mobile | social | 2 | false |
marketing_spend3,276 rows · 3 columns
spend_datedatechannelvarcharamountdecimal
| spend_date | channel | amount |
|---|---|---|
| 2023-01-01 | paid | 492.99 |
| 2023-01-01 | 37.38 | |
| 2023-01-01 | social | 200.53 |
| 2023-01-02 | paid | 709.13 |
| 2023-01-02 | 64.13 |
The lesson
Bars compare, histograms spread
A bar chart compares categories. A histogram shows the distribution of one number: it cuts the range of values into intervals, called bins, and draws a bar for how many values fall into each. Neighboring bars touch, because the bins are next to each other on a number line.
Laura’s question, “is a typical order really $500?”, is about a distribution, so it gets a histogram of order values.
Drawing it
First one value per order (the starter does this), then ax.hist:
fig, ax = plt.subplots()
ax.hist(order_value, bins=range(0, 2100, 100), edgecolor="white")
ax.set_xlabel("Order value (USD)")
ax.set_ylabel("Orders")
bins takes either a number (bins=30 makes 30 equal bins from the smallest to the largest value)
or the list of edges. With edges you control the range and the width. Here 21 edges make 20 bins of
$100, from 0 to 2,000. Orders above $2,000, 207 of the 4,295 completed 2025 orders, fall outside the
range and are not drawn. Between 20 and 50 bins usually works; with too few you lose the shape, with
too many every bar is noise.
The numbers behind the bars
np.histogram takes the same arguments and returns what ax.hist draws:
counts, bin_edges = np.histogram(order_value, bins=range(0, 2100, 100))
counts[:3] # [1180, 683, 451]
bin_edges[:3] # [0, 100, 200]
There’s always one more edge than counts. Each bin includes its left edge and excludes its right edge, so an order of exactly $100 counts in the second bin. The last bin is the exception: it includes both ends.
Mean against median
This distribution is skewed to the right: lots of small orders and a long tail of big business baskets. In a skewed distribution the mean is pulled toward the tail, while the median stays where most orders are. Mark both with vertical lines and the gap is visible at once:
ax.axvline(order_value.mean(), color="red", label="Mean") # $535.90
ax.axvline(order_value.median(), linestyle="--", label="Median") # $257.96
ax.legend()
Half of 2025’s completed orders were under $258, yet the mean is more than double that. For “what does a typical customer spend”, the median is the honest answer; the mean is still the right number for revenue planning, because revenue is a total.
Common mistakes
- Plotting
order_itemslines instead of whole orders. Group to one value per order first. - Leaving
binsat the default of 10, which turns this shape into a few blocks. - Using a bar chart with gaps between bars for a histogram, which suggests separate categories.
- Quoting only the mean of a skewed distribution. Give the median next to it.
Lantern lit!
Practised: histogrambinsdistributionmean vs mediannp histogram
- Solved
- No hints
- First run
