The datamash commands you already know, with quoted CSV, weighted means and complete-record selection. Inspect table health. Compare datasets. Get the same numbers on every supported machine.
$ fastmash --help
Operations:sum Sum the selected field
mean Arithmetic mean of the selected field
wmean Weighted mean of a VALUE:WEIGHT field pair
… help excerpt …$ fastmash --csv -H -s -g region \
--result-name=1:total sum revenue < sales.csv
GroupBy(region),total
east,4
"west,coast",8
$
Readable help in color. Clean data for the next step in your pipeline.
From raw exports to useful answers
More of your workflow, in one command
Keep familiar field selectors and grouping. Add the tools that make daily table work easier.
01 / REPORT
CSV in. Named results out.
Read quoted fields with commas and line breaks. Write CSV reports with stable column names, grouping and weighted means.
Speed relative to GNU datamash 1.9 on selected core jobs. Two native Linux machines, the same data and output, exact release binaries.
* Six named host/job comparisons are slower: disk-spilling sorts, Intel many keys and Intel distinct-value geometric mean. Three further comparisons are inconclusive. All results and the method
And better in other ways
Portable arithmetic, built-in locale data and clear handling of inputs that GNU datamash 1.9 cannot safely process.
GNU datamash 1.9Fastmash
ResultsDepend on the CPU and the C math libraryIdentical on every machine: all arithmetic in software
LocalesNeed locale data installed; silently fall back to C without itBuilt in: numbers in 318 locales, sorting in 194
perc:100Can read past the end of the valuesReturns the largest value
rmdup on several keysCrashes on an assertionA clear refusal
Malformed parameters such as strbin:2.0Misleading errors or undefined behaviorAn accurate error message
crosstab labels over 511 bytesTruncatedKept in full
GNU datamash's operations, options, field selectors, grouping and headers. Most scripts can switch by changing the program name; the migration guide covers the documented differences.