tsb — Sales Dashboard

1 · Load the sales CSV

A typical first step: parse a CSV string into a DataFrame and inspect the schema.

TypeScript

Click ▶ Run to execute

Ctrl+Enter to run · Tab to indent

2 · Compute revenue & rank regions

Add a derived revenue column, then group by region.

TypeScript

import { readCsv } from "tsb";

const csv = `order_id,region,product,units,unit_price
1001,North,Widget,4,19.99
1002,South,Gadget,2,49.50
1003,East,Widget,7,19.99
1004,West,Gizmo,1,129.00
1005,North,Gadget,3,49.50
1006,South,Widget,5,19.99
1007,East,Gizmo,2,129.00
1008,North,Widget,6,19.99
1009,West,Gadget,4,49.50
1010,South,Gizmo,1,129.00
1011,East,Widget,8,19.99
1012,North,Gizmo,2,129.00
1013,West,Widget,3,19.99
1014,South,Gadget,6,49.50
1015,East,Gadget,2,49.50`;

const sales = readCsv(csv);

// Add revenue = units * unit_price (element-wise)
const revenue = sales.col("units").mul(sales.col("unit_price"));
const enriched = sales.assign({ revenue });

// asIndex=false → keep "region" as a column
const byRegion = enriched.groupby("region").agg({ revenue: "sum" }, false);
console.log("Revenue by region:");
console.log(byRegion.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 rows: Array<[string, number]> = [];
for (let i = 0; i < byRegion.shape[0]; i++) {
  const region = String(byRegion.col("region").iloc(i));
  const rev = Number(byRegion.col("revenue").iloc(i));
  rows.push([region, rev]);
}
rows.sort((a, b) => b[1] - a[1]);
console.log("");
chart("Revenue by region ($)", rows);

Click ▶ Run to execute

Ctrl+Enter to run · Tab to indent

3 · Top products & best single order

Use groupby + nlargestDataFrame to surface the headline numbers.

TypeScript

Click ▶ Run to execute

Ctrl+Enter to run · Tab to indent

💰 Sales Dashboard

1 · Load the sales CSV

2 · Compute revenue & rank regions

3 · Top products & best single order