data.table v1.12.6


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

Vignettes of data.table

No Results!

Last month downloads


Include our badge in your README