Learn R Programming

⚠️There's a newer version (1.16.2) of this package.Take me there.

data.table (version 1.13.0)

Extension of `data.frame`

Description

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.

Copy Link

Version

Install

install.packages('data.table')

Monthly Downloads

891,324

Version

1.13.0

License

MPL-2.0 | file LICENSE

Issues

Pull Requests

Stars

Forks

Maintainer

Last Published

July 24th, 2020

Functions in data.table (1.13.0)

between

Convenience functions for range subsets.
key<-

Deprecated.
data.table-package

Enhanced data.frame
chmatch

Faster match of character vectors
cdt

data.table exported C routines
data.table-class

S4 Definition for data.table
datatable.optimize

Optimisations in data.table
duplicated

Determine Duplicate Rows
dcast.data.table

Fast dcast for data.table
fsort

Fast parallel sort
fcoalesce

Coalescing missing values
copy

Copy an entire object
fwrite

Fast CSV writer
fread

Fast and friendly file finagler
print.data.table

data.table Printing Options
frank

Fast rank
fifelse

Fast ifelse
rbindlist

Makes one data.table from a list of many
fcase

fcase
roll

Rolling functions
patterns

Obtain matching indices corresponding to patterns
foverlaps

Fast overlap joins
groupingsets

Grouping Set aggregation for data tables
setDTthreads

Set or get number of threads that data.table should use
melt.data.table

Fast melt for data.table
setcolorder

Fast column reordering of a data.table by reference
setkey

Create key on a data.table
.Last.updated

Number of rows affected by last update
like

Convenience function for calling grep.
merge

Merge two data.tables
setDF

Coerce a data.table to data.frame by reference
timetaken

Pretty print of time taken
transform.data.table

Data table utilities
setops

Set operations for data tables
setNumericRounding

Change or turn off numeric rounding
subset.data.table

Subsetting data.tables
setattr

Set attributes of objects by reference
transpose

Efficient transpose of list
truelength

Over-allocation access
test

Test assertions for equality, exceptions and console output
rowid

Generate unique row ids within each group
setDT

Coerce lists and data.frames to data.table by reference
shouldPrint

For use by packages that mimic/divert auto printing e.g. IRkernel and knitr
na.omit.data.table

Remove rows with missing values on columns specified
nafill

Fill missing values
last

First/last item of an object
setorder

Fast row reordering of a data.table by reference
split

Split data.table into chunks in a list
tables

Display 'data.table' metadata
rleid

Generate run-length type group id
test.data.table

Runs a set of tests.
shift

Fast lead/lag for vectors and lists
special-symbols

Special symbols
tstrsplit

strsplit and transpose the resulting list efficiently
update.dev.pkg

Perform update of development version of a package
:=

Assignment by reference
as.matrix

Convert a data.table to a matrix
address

Address in RAM of a variable
J

Creates a join data.table
IDateTime

Integer based date class
as.xts.data.table

Efficient data.table to xts conversion
as.data.table.xts

Efficient xts to as.data.table conversion
as.data.table

Coerce to data.table
all.equal

Equality Test Between Two Data Tables