Forrest logo
tool overview
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.

  1. MLR stands for "Miller", which is named after John Miller, its creator.
  2. It is written in C, making it fast, efficient, and memory-friendly.
  3. MLR supports various data formats, including CSV, JSON, XTAB, and fixed-width.
  4. It provides a wide range of functionalities for data processing, such as filtering, sorting, joining, aggregating, transforming, and statistics.
  5. MLR supports numerous data manipulation operators, conditional data transformations, and calculations.
  6. It includes advanced features like pivot tables, cross-tabulations, and statistical sampling.
  7. The tool offers command-line autocompletion, interactive exploration, and scripting capabilities, making it user-friendly and flexible.
  8. MLR supports piping and integrates well with other command-line tools and shell scripts.
  9. It has built-in support for univariate and multivariate graphical representations of data.
  10. 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 machine
    explain 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 machine
    explain this command
  • mlr:tldr:b34c3 mlr: Sort alphabetically on a field.
    $ mlr --icsv --opprint sort -f ${field} ${example-csv}
    try on your machine
    explain 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 machine
    explain this command
  • mlr:tldr:f9569 mlr: Pretty-print a CSV file in a tabular format.
    $ mlr --icsv --opprint cat ${example-csv}
    try on your machine
    explain this command
tool overview