1. Lighthouse

Level 1 · Black Friday in one line

The request

From Megan Collins, Head of Sales

“For Monday's review I want one picture of the holiday season: orders per day from November 1 to December 31, 2025. How big was the Black Friday weekend compared with a normal day?”

Your goal

Count orders (all statuses) per day from 2025-11-01 to 2025-12-31. Set result to a Series indexed by order_date (one row per day, 61 days, in date order) with values named n_orders, and draw it as a line chart.

  • Use the orders DataFramenot done yet
  • Show exactly order_date n_ordersnot done yet
  • 61 rows, sorted as askednot done yet

Your code

Python

Loading the editor…

    ResultPreview of orders · press Run to see yours
    Preview of orders
    order_idcustomer_idorder_datestatuschannel
    10011252023-01-01 20:51:19completedweb
    10021562023-01-02 07:58:46completedweb
    1003222023-01-02 10:25:27completedmarketplace
    1004482023-01-02 11:21:51completedmarketplace

    Mote checks your result

    Press Run. Each row that matches the goal becomes a firefly in your lantern.

    DataFrames

    Loaded for you as pandas DataFrames, plus pd and np.

    orders12,000 rows · 7 columns
    • order_idinteger
    • customer_idinteger
    • order_datetimestamp
    • statusvarchar
    • channelvarchar
    • shipping_feedecimal
    • coupon_codevarchar
    First 5 rows of orders
    order_idcustomer_idorder_datestatuschannelshipping_feecoupon_code
    10011252023-01-01 20:51:19completedweb0.00NaN
    10021562023-01-02 07:58:46completedweb0.00NaN
    1003222023-01-02 10:25:27completedmarketplace4.99WELCOME10
    1004482023-01-02 11:21:51completedmarketplace4.99WELCOME10
    1005822023-01-02 11:43:36completedweb0.00WELCOME10
    customers2,018 rows · 9 columns
    • customer_idinteger
    • first_namevarchar
    • last_namevarchar
    • emailvarchar
    • cityvarchar
    • statevarchar
    • signup_datedate
    • segmentvarchar
    • referral_sourcevarchar
    First 5 rows of customers
    customer_idfirst_namelast_nameemailcitystatesignup_datesegmentreferral_source
    1OwenHudsonowen.hudson@icloud.comSan FranciscoCA2022-06-02consumersearch
    2DouglasMendozadmendoza69@gmail.comAtlantaGA2022-06-02consumerNaN
    3HenryBrookshbrooks@lakesidecafe.comLos AngelesCA2022-06-04businessNaN
    4BrianGrahambgraham@bluecedarhomes.comSeattleWA2022-06-06businesspinterest
    5KyleJimenezkjimenez27@yahoo.comIndianapolisIN2022-06-07consumerNaN
    products120 rows · 8 columns
    • product_idinteger
    • namevarchar
    • categoryvarchar
    • subcategoryvarchar
    • unit_pricedecimal
    • unit_costdecimal
    • launched_ondate
    • is_activeboolean
    First 5 rows of products
    product_idnamecategorysubcategoryunit_priceunit_costlaunched_onis_active
    101Vale Velvet LoveseatFurnitureSofas1659.00NaN2023-09-11true
    102Alder Oak Coffee TableFurnitureTables919.00503.502024-05-16true
    103Orchard Rattan Dining ChairFurnitureChairs789.00429.872023-05-27true
    104Upland Oak BookcaseFurnitureStorage429.00214.702022-12-20true
    105Avery Leather Bed FrameFurnitureBeds449.00232.702021-08-31true
    order_items30,338 rows · 6 columns
    • order_item_idinteger
    • order_idinteger
    • product_idinteger
    • quantityinteger
    • unit_pricedecimal
    • discount_pctdecimal
    First 5 rows of order_items
    order_item_idorder_idproduct_idquantityunit_pricediscount_pct
    11001121931.990.00
    21001154311.990.00
    31002154411.990.00
    410021941149.000.00
    51002193219.990.00
    returns1,673 rows · 5 columns
    • return_idinteger
    • order_item_idinteger
    • returned_ondate
    • reasonvarchar
    • refund_amountdecimal
    First 5 rows of returns
    return_idorder_item_idreturned_onreasonrefund_amount
    1142023-01-10damaged83.69
    2422023-01-10wrong_item19.99
    31052023-01-14wrong_item10.99
    4242023-01-16changed_mind26.99
    51262023-01-16late20.99
    employees60 rows · 8 columns
    • employee_idinteger
    • first_namevarchar
    • last_namevarchar
    • departmentvarchar
    • titlevarchar
    • manager_idinteger
    • hire_datedate
    • salaryinteger
    First 5 rows of employees
    employee_idfirst_namelast_namedepartmenttitlemanager_idhire_datesalary
    1CatherineHaleExecutiveChief Executive OfficerNaN2016-03-01285000
    2RobertKimExecutiveChief Operating Officer12017-01-09235000
    3MeganCollinsSalesHead of Sales12018-04-16172000
    4ChloeGutierrezSalesAccount Executive32020-01-2172000
    5FrankBellSalesAccount Executive32023-05-2173000
    web_sessions40,000 rows · 7 columns
    • session_idinteger
    • customer_idinteger
    • started_attimestamp
    • devicevarchar
    • sourcevarchar
    • pages_viewedinteger
    • convertedboolean
    First 5 rows of web_sessions
    session_idcustomer_idstarted_atdevicesourcepages_viewedconverted
    1NaN2023-01-01 23:02:24mobilepaid1false
    2182023-01-01 15:07:49desktoppaid1false
    3NaN2023-01-01 16:55:46desktopdirect7false
    4NaN2023-01-01 12:43:28mobileorganic3false
    5NaN2023-01-01 13:06:21mobilesocial2false
    marketing_spend3,276 rows · 3 columns
    • spend_datedate
    • channelvarchar
    • amountdecimal
    First 5 rows of marketing_spend
    spend_datechannelamount
    2023-01-01paid492.99
    2023-01-01email37.38
    2023-01-01social200.53
    2023-01-02paid709.13
    2023-01-02email64.13

    The lesson

    Start from the question, then the data

    A chart answers one question. Megan’s is “how did orders move day by day through the holidays, and how big was the peak?” Time on the x-axis, a count on the y-axis, points that belong in order: that is a line chart.

    Before drawing anything, build the numbers. One row per day:

    season = orders[(orders["order_date"] >= "2025-11-01") & (orders["order_date"] < "2026-01-01")]
    daily = season.set_index("order_date").resample("D").size().rename("n_orders")
    len(daily)       # 61 days
    daily.max()      # 67, on 2025-12-01 (Cyber Monday)
    daily.median()   # 22

    The chart is only as good as this Series, which is why the check looks at it.

    Figure and Axes

    matplotlib draws on two objects. The Figure is the whole image, the frame. The Axes is the plotting area inside it, with its x and y axis and the data. plt.subplots() makes one of each:

    import matplotlib.pyplot as plt
    
    fig, ax = plt.subplots(figsize=(9, 4))   # width, height in inches
    ax.plot(daily.index, daily.values)       # x first, then y
    ax.set_title("Orders per day, Nov to Dec 2025")
    ax.set_xlabel("Day")
    ax.set_ylabel("Orders")

    x and y must have the same length; here both come from the same Series, so they always do.

    You’ll also see a shorter style that talks to “the current chart”: plt.plot(...), plt.title(...), plt.xlabel(...). It’s fine for a quick look. The fig, ax style is the one to learn, because it’s clearer and you need it as soon as a figure holds more than one chart. The names map one to one: plt.title becomes ax.set_title, plt.xlabel becomes ax.set_xlabel, plt.ylim becomes ax.set_ylim.

    pandas has a shortcut too: daily.plot() draws the same line and returns the ax, so you can keep going with ax.set_title(...).

    Reference lines and markers

    A line alone shows the shape. A reference line gives it a scale:

    ax.plot(daily.index, daily.values, marker="o", markersize=3)
    ax.axhline(daily.mean(), color="gray", linestyle="--", label="Average")
    ax.legend()

    axhline draws a horizontal line across the chart (axvline a vertical one, handy for marking a launch date). marker="o" puts a dot on each day; linestyle takes "-", "--" or ":". ax.legend() lists every line that was given a label=. Dates along the x-axis often run into each other; fig.autofmt_xdate() tilts them so they fit.

    Here the average is about 24 orders a day. The Black Friday weekend (November 28 to 30) brought 56, 51 and 58, and Cyber Monday, December 1, brought 67: almost three times a normal day. The quietest days were Christmas Eve and Christmas Day, with 11 and 9.

    A title that says the finding

    “Orders per day” describes the chart. “Cyber Monday was the busiest day of the season” tells the reader what to see. A good chart can be understood without you standing next to it, and the title is where that starts.

    Common mistakes

    • Calling ax.title("...") instead of ax.set_title("..."). On an Axes the setters start with set_; ax.title is a text object, and calling it raises TypeError: 'Text' object is not callable.
    • Calling ax.legend() when no line has a label=. The legend comes out empty with a warning.
    • Removing the import matplotlib.pyplot as plt line. Here that line is what loads the chart library, and pandas’ .plot() needs it too.

    Pick what may run on this site. You can change this any time from "Cookie settings" at the bottom of every page.