data.table v1.12.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.

Functions in data.table

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

Vignettes of data.table

No Results!

Last month downloads


Include our badge in your README