datamash

Get max, min, mean, median of a column

$ seq 3 | datamash max 1 min 1 mean 1 median 1

$ echo -e '1.0\n2.5\n3.1' | tr '.' ',' | datamash mean 1

$ echo -e '1\n2\n3' | datamash -R [decimals] mean 1

$ echo -e '1\n2\nNa\n3\nNaN' | datamash --narm mean 1

datamash [options] operation column [operation column...]

datamash performs basic numeric, textual, and statistical operations on input data from the command line. It's designed for quick data analysis tasks that would otherwise require scripting or statistical software, supporting operations like sum, mean, median, standard deviation, variance, and more.
Input is read from stdin or files, with columns separated by whitespace or a specified delimiter. The tool can group data by fields and compute aggregate statistics for each group, similar to SQL's GROUP BY functionality.
datamash is part of the GNU project and excels at one-liners for data exploration. It's commonly used in pipelines to analyze CSV files, log data, or any tabular text data. The tool can handle both numeric and textual operations, including counting unique values, string operations, and random sampling.

-R, --round digits

Round numeric output to specified decimals

Ignore NA and NaN values

Use specified field separator

Group by specified fields

First line is header

sum, min, max, mean, median

Basic statistics

Population/sample standard deviation

Counting and grouping

Selection operations

Float numbers must use comma as decimal separator in some locales (use tr to convert). Part of GNU datamash. Column numbering starts at 1.

awk(1), cut(1), sort(1)