On this page you find all important commands for the CLI tool mlr. If the
command you are looking for is missing please ask our AI.
mlr
MLR is a powerful command-line tool for data manipulation and analysis.
- MLR stands for "Miller", which is named after John Miller, its creator.
- It is written in C, making it fast, efficient, and memory-friendly.
- MLR supports various data formats, including CSV, JSON, XTAB, and fixed-width.
- It provides a wide range of functionalities for data processing, such as filtering, sorting, joining, aggregating, transforming, and statistics.
- MLR supports numerous data manipulation operators, conditional data transformations, and calculations.
- It includes advanced features like pivot tables, cross-tabulations, and statistical sampling.
- The tool offers command-line autocompletion, interactive exploration, and scripting capabilities, making it user-friendly and flexible.
- MLR supports piping and integrates well with other command-line tools and shell scripts.
- It has built-in support for univariate and multivariate graphical representations of data.
- MLR has comprehensive documentation, numerous examples, and an active community, making it easy to learn and use.
List of commands for mlr:
-
mlr:tldr:2f08d mlr: Convert CSV to JSON, performing calculations and display those calculations.$ mlr --icsv --ojson put '$${newField1} = $${oldFieldA}/$${oldFieldB}' ${example-csv}try on your machineexplain this command
-
mlr:tldr:70dec mlr: Sort in descending numerical order on a field.$ mlr --icsv --opprint sort -nr ${field} ${example-csv}try on your machineexplain this command
-
mlr:tldr:b34c3 mlr: Sort alphabetically on a field.$ mlr --icsv --opprint sort -f ${field} ${example-csv}try on your machineexplain this command
-
mlr:tldr:ead79 mlr: Filter lines of a compressed CSV file treating numbers as strings.$ mlr --prepipe 'gunzip' --csv filter -S '$${fieldName} =~ "${regular_expression}"' ${example-csv-gz}try on your machineexplain this command
-
mlr:tldr:f9569 mlr: Pretty-print a CSV file in a tabular format.$ mlr --icsv --opprint cat ${example-csv}try on your machineexplain this command