mlr

Convert CSV to JSON

$ mlr --csv --ojson cat [data.csv]

$ mlr --csv filter '$status == "active"' [data.csv]

$ mlr --csv cut -f [name,email] [data.csv]

$ mlr --csv sort -f [age] [data.csv]

$ mlr --csv stats1 -a mean -f [price] [data.csv]

$ mlr --csv put '$total = $price * $quantity' [data.csv]

mlr [options] verbs file

mlr (Miller) processes structured text data. It handles CSV, JSON, and other formats.
The tool provides awk-like processing for structured data. Powerful for data transformation.
mlr processes structured data.

VERBS

Operations to perform.

CSV format.

JSON format.

Output as JSON.

Filter records.

Select fields.

Sort records.

Display help information.

Many verbs to learn. Format-aware. Go-based rewrite.

Miller was created by John Kerl as "like awk/sed/cut for name-indexed data."

jq(1), awk(1), csvtool(1)