← All projects

PROJECT 079 / 102 · Commerce

Wholesale customer segmentation.

Do customers form interpretable groups based on annual spending patterns?

Focused analytical studyWholesale customersExecuted notebook

THE RESULT

What the data shows

The largest computed metric is 213 for 2.0; the smallest is 80 for 0.0. Metric: customers (Customers).

Exploratory silhouette=0.259. Three clusters were prespecified; no claim of natural or stable business segments.

Wholesale customer segmentation — chart from the computed study output
Computed study output. Full values and units are available in the results download.
Computed results · 3 of 3 rows. Values rounded for display; source units and raw column names are retained in the download.
clusterfreshmilkgroceryfrozendetergents paperdelicassencustomers
01,492.506,300.5010,502.503764,217.50434.580
112,1267,1849,9652,0053,3782,005147
29,6121,6012,1552,121274686213
Download the complete result table ↓

THE METHOD

From source to answer

Three-cluster K-means on standardized log spending, with silhouette and median profiles.

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

Review cluster profiles with a commercial owner before assigning business labels or actions.

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.