tsb — Pricing Buckets

1 · Bucket products into price tiers

Use fixed bin edges with cut and named labels.

TypeScript

Click ▶ Run to execute

Ctrl+Enter to run · Tab to indent

2 · Avg margin by tier

Strategy question: do premium products carry meaningfully higher margins?

TypeScript

import { DataFrame } from "tsb";

const enriched = DataFrame.fromColumns({
  sku:    ["A1","A2","A3","B1","B2","B3","C1","C2","C3","D1","D2","D3","E1","E2","E3"],
  price:  [9.99, 14.50, 19.00, 22.00, 29.50, 39.00, 49.00, 65.00, 79.99, 99.00, 129.00, 149.00, 199.00, 249.00, 349.00],
  margin: [0.30, 0.32, 0.28, 0.34, 0.36, 0.40, 0.42, 0.45, 0.46, 0.48, 0.50, 0.52, 0.55, 0.58, 0.60],
  tier:   ["Budget","Budget","Budget","Budget","Mid","Mid","Mid","Mid","Premium","Premium","Premium","Premium","Luxury","Luxury","Luxury"],
});

const byTier = enriched.groupby("tier").agg({
  price:  "mean",
  margin: "mean",
  sku:    "count",
}, false);
const out = byTier.rename({
  price:  "avg_price",
  margin: "avg_margin",
  sku:    "products",
});
console.log(out.toString());

function bar(label: string, value: number, max: number, width = 28): string {
  const len = max > 0 ? Math.round((value / max) * width) : 0;
  return label.padEnd(14) + " | " + "\u2588".repeat(len) + " " + value.toFixed(2);
}
function chart(title: string, rows: Array<[string, number]>): void {
  const maxV = Math.max(...rows.map(r => r[1]));
  console.log(title);
  for (const [label, value] of rows) console.log(bar(label, value, maxV));
}

const tiers   = [...out.col("tier").values].map(String);
const margins = [...out.col("avg_margin").values].map(v => Number(v) * 100);
const order   = ["Budget","Mid","Premium","Luxury"];
const rows: Array<[string, number]> = [];
for (const t of order) {
  const i = tiers.indexOf(t);
  if (i >= 0) rows.push([t, margins[i] as number]);
}
console.log("");
chart("Avg margin % per tier", rows);

Click ▶ Run to execute

Ctrl+Enter to run · Tab to indent

🏷️ Product Pricing Tiers

1 · Bucket products into price tiers

2 · Avg margin by tier