csvgroupby¶
Description¶
Do SQL-like GROUP BY
aggregations
Similar to csvpivot, except csvgroupby
allows for multiple aggregation value columns. Call -a/--agg
multiple times for multiple aggregations.
Example:
$ csvgroupby -c 'gender,race' -a count -a mean:age -a 'TOTAL age|sum:age' examples/peeps.csv | csvlook
| gender | race | Count | Mean_of_age | TOTAL age |
| ------ | ------ | ----- | ----------- | --------- |
| female | white | 1 | 20.0 | 20 |
| female | black | 2 | 22.5 | 45 |
| female | asian | 1 | 25.0 | 25 |
| male | asian | 1 | 20.0 | 20 |
| male | latino | 1 | 25.0 | 25 |