data.table vs Miller
data.table
rdatatable.gitlab.ioMiller
miller.readthedocs.ioSide by side
| Figure | data.table | Miller |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Transformation Tools | 8.5 (#11) | 7.6 (#25) |
| Data operations | It supports filtering, grouping, aggregation, joins, reshaping, and adding, updating, or deleting columns. | It can add and remove fields, sort, aggregate statistics, pretty-print data, and convert between formats. |
| Integrations | data.table is an R package and can use R functions from other packages in queries. | The documentation describes Miller as complementary to R, pandas, SQL databases, and the Unix toolkit. |
| License | The project repository identifies its license as MPL-2.0. | The project repository identifies Miller's license as two-clause BSD. |
| Support | The project directs users who need help to the data.table community on Stack Overflow. | The project directs users to GitHub Discussions for general questions, Stack Overflow for tagged questions, and GitHub Issues for bug reports and feature requests. |
Plans
In their own words
data.table
data.table is a free R package providing a high-performance version of base R’s data.frame. Its code interface supports filtering, grouping, aggregation, ordered and rolling joins, overlapping and non-equi joins, reshaping with dcast and melt, and adding, updating, or deleting columns. fread() reads delimited text, including CSV, TSV, compressed .gz and .bz2 files, and can source web URLs or shell commands. fwrite() writes delimited files with an emphasis on speed for large files. Many operations use multiple CPU threads internally. Columns can be changed by reference without copies, and the project reports no external Imports, LinkingTo, or Depends dependencies. Queries can call R functions from other packages. data.table runs on Linux, macOS, and Windows and requires base R. It is self-hosted and licensed under MPL-2.0. The project’s stated scope excludes binary formats such as Parquet and data stored on disk or in remote SQL databases.
Miller
Miller has no write-up on Specifiction yet; its figures are above.