| | Specify the columns (1-based) for the grouping.
The columns must be comma separated.
- Default: 1,2,3
|
| | Specify the column (1-based) that should be summarized.
|
| | Specify the operation that should be applied to opCol.
Valid operations:
sum, count, count_distinct, min, max,
mean, median, mode, antimode,
stdev, sstdev (sample standard dev.),
collapse (i.e., print a comma separated list (duplicates allowed)),
distinct (i.e., print a comma separated list (NO duplicates allowed)),
distinct_sort_num (as distinct, but sorted numerically, ascending),
distinct_sort_num_desc (as distinct, but sorted numerically, descending),
concat (i.e., merge values into a single, non-delimited string),
freqdesc (i.e., print desc. list of values:freq)
freqasc (i.e., print asc. list of values:freq)
first (i.e., print first value)
last (i.e., print last value)
Default value: sum
If there is only column, but multiple operations, all operations will be
applied on that column. Likewise, if there is only one operation, but
multiple columns, that operation will be applied to all columns.
Otherwise, the number of columns must match the the number of operations,
and will be applied in respective order.
E.g., "-c 5,4,6 -o sum,mean,count" will give the sum of column 5,
the mean of column 4, and the count of column 6.
The order of output columns will match the ordering given in the command.
|
| | Print all columns from input file. The first line in the group is used.
Default: print only grouped columns.
|
| | Input file has a header line - the first line will be ignored.
|
| | Print header line in the output, detailing the column names.
If the input file has headers (-inheader), the output file
will use the input's column names.
If the input file has no headers, the output file
will use "col_1", "col_2", etc. as the column names.
|
| | same as '-inheader -outheader'. |
| | Group values regardless of upper/lower case.
|
| | Sets the decimal precision for output.
|
| | Specify a custom delimiter for the collapse operations.
|