What is Miller?

Miller is like awk, sed, cut, join, and sort for data formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed.

What can Miller do for me?

With Miller, you get to use named fields without needing to count positional indices, using familiar formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. Then, on the fly, you can add new fields which are functions of existing fields, drop fields, sort, aggregate statistically, pretty-print, and more.

• Miller operates on key-value-pair data while the familiar Unix tools operate on integer-indexed fields: if the natural data structure for the latter is the array, then Miller's natural data structure is the insertion-ordered hash map.

• Miller handles a variety of data formats, including but not limited to the familiar CSV, TSV, and JSON/JSON Lines. (Miller can handle positionally-indexed data too!)

In the above image you can see how Miller embraces the common themes of key-value-pair data in a variety of data formats.

Getting started

• Miller in 10 minutes
• A Guide To Command-Line Data Manipulation
• A quick tutorial on Miller
• Miller Exercises
• Tools to manipulate CSV files from the Command Line
• www.togaware.com/linux/survivor/CSV_Files.html
• MLR for CSV manipulation
• Linux Magazine: Process structured text files with Miller
• Miller: Command Line CSV File Processing
• Miller - A Swiss Army Chainsaw for CSV Data, Data Science and Data Munging
• Pandas Killer: mlr, the Scientist

More documentation links

• Full documentation
• Miller's license is two-clause BSD
• Notes about issue-labeling in the Github repo
• Active issues

Installing

There's a good chance you can get Miller pre-built for your system:

|OS|Installation command| |---|---| |Linux|yum install miller<br/> apt-get install miller<br/> snap install miller| |Mac|brew install miller<br/>port install miller| |Windows|choco install miller<br/>winget install Miller.Miller<br/>scoop install main/miller|

See also README-versions.md for a full list of package versions. Note that long-term-support (LtS) releases will likely be on older versions.

See also building from source.

Community

<!-- ALL-CONTRIBUTORS-BADGE:START - Do not remove or modify this section -->

<!-- ALL-CONTRIBUTORS-BADGE:END -->

• Discussion forum: https://github.com/johnkerl/miller/discussions
• Feature requests / bug reports: https://github.com/johnkerl/miller/issues
• How to contribute: https://miller.readthedocs.io/en/latest/contributing/

Build status

<!-- [](https://github.com/johnkerl/miller/actions/workflows/release.yml) -->

Building from source

• First:
  • cd /where/you/want/to/put/the/source
  • git clone https://github.com/johnkerl/miller
  • cd miller
• With make:
  • To build: make. This takes just a few seconds and produces the Miller executable, which is ./mlr (or .\mlr.exe on Windows).
  • To run tests: make check.
  • To install: make install. This installs the executable /usr/local/bin/mlr and manual page /usr/local/share/man/man1/mlr.1 (so you can do man mlr).
  • You can do ./configure --prefix=/some/install/path before make install if you want to install somewhere other than /usr/local.
• Without make:
  • To build: go build github.com/johnkerl/miller/v6/cmd/mlr.
  • To run tests: go test github.com/johnkerl/miller/v6/pkg/... and mlr regtest.
  • To install: go install github.com/johnkerl/miller/v6/cmd/mlr@latest will install to GOPATH/bin/mlr.
• See also the doc page on building from source.
• For more developer information please see README-dev.md.

For developers

• README-dev.md
• How to contribute

License

License: BSD2

Features

• Miller is multi-purpose: it's useful for data cleaning, data reduction, statistical reporting, devops, system administration, log-file processing, format conversion, and database-query post-processing.

• You can use Miller to snarf and munge log-file data, including selecting out relevant substreams, then produce CSV format and load that into all-in-memory/data-frame utilities for further statistical and/or graphical processing.

• Miller complements data-analysis tools such as R, pandas, etc.: you can use Miller to clean and prepare your data. While you can do basic statistics entirely in Miller, its streaming-data feature and single-pass algorithms enable you to reduce very large data sets.

• Miller complements SQL databases: you can slice, dice, and reformat data on the client side on its way into or out of a database. You can also reap some of the benefits of databases for quick, setup-free one-off tasks when you just need to query some data in disk files in a hurry.

• Miller also goes beyond the classic Unix tools by stepping fully into our modern, no-SQL world: its essential record-heterogeneity property allows Miller to operate on data where records with different schema (field names) are interleaved.

• Miller is streaming: most operations need only a single record in memory at a time, rather than ingesting all input before producing any output. For those operations which require deeper retention (sort, tac, `st