Miller is also a great tool to do computation, transformations on CSV/TSV/JSON/SQLite files... Here is the way to pretty-print the same result with mlr: mlr -

Miller is also a great tool to do computation, transformations on CSV/TSV/JSON/SQLite files... Here is the way to pretty-print the same result with mlr: mlr --icsv --opprint --barred stats1 -a count,mean -f total_amount -g passenger_count then sort -f passenger_count taxi.csv