csv — Tabular arithmetic — openbash

Columns, counts, frequencies, sums, averages, filters and joins over CSV.

csv

csv is a command on the openbash shell, reachable over HTTP, SSH and MCP with one key. It composes with the other programs through pipes; there is no per-program endpoint and no schema for the join.

csv freq /tmp/shipments.csv supplier

supplier,count
TAIYO NIPPON SANSO,184
AIR LIQUIDE,97
LINDE GAS,63

help

csv: arithmetic over a table, without writing a script.

USAGE
  csv cols   FILE
  csv count  FILE
  csv freq   FILE COL
  csv sum    FILE COL --group G
  csv avg    FILE COL --group G
  csv filter FILE --where COL=VAL
  csv join   A B --on ACOL=BCOL

  Most take --where COL=VAL and --limit N.

RETURNS
  CSV on stdout, so one call composes into the next.

DOES NOT COVER
  Anything with a shape of its own. This is the common ninety percent; the rest
  is `awk`, which is also here.