miller

Process CSV, JSON, and tabular data like awk with named columns.

brewmacoslinux

Try with needOr install directly

About

Like sed, awk, cut, join & sort for name-indexed data such as CSV

mlr

filter rows where a column matches a value$ mlr filter '$status == "active"' data.csv

select specific columns from a CSV file$ mlr cut -f name,email,phone data.csv

convert CSV to JSON format$ mlr --csv --ojson cat data.csv

sort data by column and show top results$ mlr --csv sort -f score -nr data.csv | head -10

group by column and calculate sum or average$ mlr --csv stats2 -a sum,mean -f salary -g department data.csv