data.table v1.11.2


Monthly downloads



Extension of `data.frame`

Fast aggregation of large data (e.g. 100GB in RAM), fast ordered joins, fast add/modify/delete of columns by group using no copies at all, list columns, friendly and fast character-separated-value read/write. Offers a natural and flexible syntax, for faster development.


Overview is on the project's homepage.

Functions in data.table

Name Description
merge Merge two data.tables Data table utilities
split Split data.table into chunks in a list Fast melt for data.table
setattr Set attributes of objects by reference
fwrite Fast CSV writer
last Last item of an object
rowid Generate unique row ids within each group
setDF Coerce a data.table to data.frame by reference
timetaken Pretty print of time taken
setcolorder Fast column reordering of a data.table by reference Subsetting data.tables
data.table-package Enhanced data.frame
shouldPrint For use by packages that mimic/divert auto printing e.g. IRkernel and knitr Remove rows with missing values on columns specified
fsort Fast parallel sort
tstrsplit strsplit and transpose the resulting list efficiently Perform update of development version of a package
fread Fast and friendly file finagler
special-symbols Special symbols
groupingsets Grouping Set aggregation for data tables data.table Printing Options
setorder Fast row reordering of a data.table by reference
patterns Obtain matching indices corresponding to patterns
setNumericRounding Change or turn off numeric rounding
like Convenience function for calling regexpr.
setDT Coerce lists and data.frames to data.table by reference
setops Set operations for data tables
transpose Efficient transpose of list
setDTthreads Set or get number of threads that data.table should use
rbindlist Makes one data.table from a list of many
setkey Create key on a data table
truelength Over-allocation access Runs a set of tests.
shift Fast lead/lag for vectors and lists
rleid Generate run-length type group id
tables Display 'data.table' metadata Efficient xts to conversion Efficient data.table to xts conversion
all.equal Equality Test Between Two Data Tables
as.matrix Convert a data.table to a matrix
between Convenience functions for range subsets.
J Creates a Join data table Coerce to data.table
address Address in RAM of a variable
:= Assignment by reference
IDateTime Integer based date class
chmatch Faster match of character vectors
frank Fast rank
duplicated Determine Duplicate Rows
copy Copy an entire object
first First item of an object Fast dcast for data.table
datatable.optimize Optimisations in data.table
data.table-class S4 Definition for data.table
foverlaps Fast overlap joins
No Results!

Vignettes of data.table

No Results!

Last month downloads


License MPL-2.0 | file LICENSE
VignetteBuilder knitr
ByteCompile TRUE
NeedsCompilation yes
Packaged 2018-05-07 23:30:32.573 UTC; mdowle
Repository CRAN
Date/Publication 2018-05-08 16:16:33 UTC

Include our badge in your README