mlr --csv filter '$age > 30' data.csv

Category: Data Science & Analysis

mlr --csv filter '$age > 30' data.csv

Keep CSV rows where the age field exceeds 30

The filter verb keeps only records whose expression evaluates true, using awk-like syntax where $age refers to the age field. Comparison operators, boolean logic with and and or, and function calls are all supported in the expression. The result is Miller's version of a SQL WHERE clause. Compare a text field the same way, with the value quoted inside the expression.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.