THE RESULT
What the data shows
The largest computed metric is 1.239e+04 for 2 / grocery; the smallest is 385.5 for 1 / detergents_paper. Metric: median_spend (Source monetary units).
Medians describe a typical customer per category; summing category medians is not a median customer total.
| channel | category | median spend | channel category |
|---|---|---|---|
| 1 | fresh | 9,581.50 | 1 / fresh |
| 2 | fresh | 5,993.50 | 2 / fresh |
| 1 | milk | 2,157 | 1 / milk |
| 2 | milk | 7,812 | 2 / milk |
| 1 | grocery | 2,684 | 1 / grocery |
| 2 | grocery | 12,390 | 2 / grocery |
| 1 | frozen | 2,057.50 | 1 / frozen |
| 2 | frozen | 1,081 | 2 / frozen |
| 1 | detergents_paper | 385.5 | 1 / detergents_paper |
| 2 | detergents_paper | 5,614.50 | 2 / detergents_paper |
| 1 | delicassen | 821 | 1 / delicassen |
| 2 | delicassen | 1,350 | 2 / delicassen |
THE METHOD
From source to answer
Channel-level medians across six spending categories.
The Python source exposes this study’s transformations. The complete project download includes shared preparation and evaluation routines.
THE NEXT DECISION
What follows from the finding
Use channel profiles to frame an assortment discussion, then validate with transaction and margin data.
Where the conclusion stops
Annual customer spending uses source monetary units, not an assumed currency. There are no margins, transactions or dates. Customer segments are descriptive and do not establish promotion response.
Related studies may reuse observations or holdouts. These are historical analyses; associations and backtests do not demonstrate commercial impact. Further model tuning needs new, untouched evaluation data.