Checkpoint: Analysis: Group, Join, Reshape

Question 1 of 5

• Returns that have no matching order line
• Order lines that were returned twice
• Rows the merge failed to process
• The 3,793 order lines that were never returned

Question 2 of 5

• The default aggfunc is "mean", so each cell is the average line revenue, not the sum.
• pivot_table drops cancelled orders automatically.
• The values are in thousands of dollars.
• Rows with missing years were dropped.

Question 3 of 5

• Use "M" instead of "ME".
• Sort the orders by date first.
• Put the dates in the index with set_index("order_date"), or pass on="order_date" to resample.
• Convert revenue to integers.

Question 4 of 5

• pd.cut(products["unit_price"], 5)
• pd.qcut(products["unit_price"], 5)
• products["unit_price"].rank(5)
• products.groupby("unit_price").ngroups

Question 5 of 5

• sales.groupby("country")["revenue"].sum()
• sales.groupby("country").sum("revenue")
• sales.pivot(index="country", values="revenue")
• sales.groupby("country", as_index=False)["revenue"].sum()