1. Lighthouse

Level 1 · Orders per channel with seaborn

The request

From Robert Kim, Chief Operating Officer

“Quick one for the ops meeting: how many orders did each channel bring in 2025, biggest first? And can I see the cancellations in the same chart?”

Your goal

Using orders placed in 2025 (all statuses), set result to a DataFrame with columns channel and n_orders (number of orders), sorted by n_orders from highest to lowest, index reset. Draw the counts with sns.countplot, bars in the same order.

  • Use the orders DataFramenot done yet
  • Show exactly channel n_ordersnot done yet
  • 3 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

    The seaborn pattern

    seaborn is imported as sns, by a convention as universal as pd and np. Every function has the same shape: you give it the whole table and the names of the columns to use.

    import seaborn as sns
    sns.set_theme(style="whitegrid")       # once, at the top: a clean default look
    
    ax = sns.countplot(data=o25, x="channel")
    ax.set_title("Orders per channel, 2025")

    It returns an ordinary matplotlib Axes, so everything from chapter 11 still applies: set_title, set_xlabel, set_ylim, bar_label. seaborn draws the chart; matplotlib finishes it.

    countplot counts for you

    countplot takes raw rows and counts how many fall in each category, like value_counts() drawn as bars. Its bars come out in the order the categories first appear, so sort them with order=:

    counts = o25["channel"].value_counts()      # app 2135, web 1946, marketplace 702
    ax = sns.countplot(data=o25, x="channel", order=counts.index)
    ax.bar_label(ax.containers[0], padding=3)   # write the count on each bar

    ax.containers[0] is the group of bars seaborn drew; bar_label writes each bar’s height above it. For categories with long names, use y="channel" instead of x= to get horizontal bars.

    The table behind the chart is the same value_counts, turned into two named columns:

    counts.rename_axis("channel").reset_index(name="n_orders")

    hue adds a second category

    hue= splits every bar by a second column and adds a legend automatically, which is seaborn’s biggest convenience over plain matplotlib:

    ax = sns.countplot(data=o25, x="channel", hue="status", order=counts.index,
                       hue_order=["completed", "cancelled", "refunded", "pending"])

    In 2025 the app had 133 cancelled orders out of 2,135 (6.2%), the website 102 out of 1,946 (5.2%) and the marketplace 40 out of 702 (5.7%). With the completed bars so tall, small groups are hard to read; when the small groups are the point, chart their rates instead.

    Common mistakes

    • Giving countplot a table of counts: it would count the rows of that table (one per channel). For precomputed numbers use sns.barplot(data=table, x="channel", y="n_orders").
    • Forgetting order=, so the bars come out in data order instead of ranked.
    • Writing x=o25["channel"] and data=o25 together. Pass column names as strings with data=.
    • Calling sns.set_theme() before every chart. Once at the top is enough.
    • Expecting countplot to return the counts. It returns the Axes; the numbers come from value_counts(), which is also what you quote in the text next to the chart, so build the table first and draw from the same data.

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