data.table: 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, a fast friendly file reader and parallel file writer. Offers a natural and flexible syntax, for faster development.

Install the latest version of this package by entering the following in R:
install.packages("data.table")
AuthorMatt Dowle [aut, cre], Arun Srinivasan [aut], Jan Gorecki [ctb], Tom Short [ctb], Steve Lianoglou [ctb], Eduard Antonyan [ctb]
Date of publication2017-02-01 15:52:19
MaintainerMatt Dowle <mattjdowle@gmail.com>
LicenseGPL-3 | file LICENSE
Version1.10.4
http://r-datatable.com

View on CRAN

Man pages

address: Address in RAM of a variable

all.equal.data.table: Equality Test Between Two Data Tables

as.data.table: Coerce to data.table

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

assign: Assignment by reference

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

between: Convenience functions for range subsets.

chmatch: Faster match of character vectors

copy: Copy an entire object

data.table: Enhanced data.frame

data.table-class: S4 Definition for data.table

datatable-optimize: Optimisations in data.table

dcast.data.table: Fast dcast for data.table

duplicated: Determine Duplicate Rows

first: First item of an object

foverlaps: Fast overlap joins

frank: Fast rank

fread: Fast and friendly file finagler

fsort: Fast parallel sort

fwrite: Fast CSV writer

IDateTime: Integer based date class

J: Creates a Join data table

last: Last item of an object

like: Convenience function for calling regexpr.

melt.data.table: Fast melt for data.table

merge: Merge two data.tables

na.omit.data.table: Remove rows with missing values on columns specified

openmp-utils: Set or get number of threads that data.table should use

patterns: Obtain matching indices corresponding to patterns

print.data.table: data.table Printing Options

rbindlist: Makes one data.table from a list of many

rleid: Generate run-length type group id

rowid: Generate unique row ids within each group

setattr: Set attributes of objects by reference

setcolorder: Fast column reordering of a data.table by reference

setDF: Coerce a data.table to data.frame by reference

setDT: Coerce lists and data.frames to data.table by reference

setkey: Create key on a data table

setNumericRounding: Change or turn off numeric rounding

setops: Set operations for data tables

setorder: Fast row reordering of a data.table by reference

shift: Fast lead/lag for vectors and lists

shouldPrint: For use by packages that mimic/divert auto printing e.g....

special-symbols: Special symbols

split: Split data.table into chunks in a list

subset.data.table: Subsetting data.tables

tables: Display all objects of class 'data.table'

test.data.table: Runs a set of tests.

timetaken: Pretty print of time taken

transform.data.table: Data table utilities

transpose: Efficient transpose of list

truelength: Over-allocation access

tstrsplit: strsplit and transpose the resulting list efficiently

Functions

:= Man page
address Man page
all.equal Man page
all.equal.data.table Man page
alloc.col Man page
anyDuplicated Man page
anyDuplicated.data.table Man page
as.character.ITime Man page
as.chron.IDate Man page
as.chron.ITime Man page
as.data.table Man page
as.data.table.character Man page
as.data.table.data.frame Man page
as.data.table.data.table Man page
as.data.table.Date Man page
as.data.table.factor Man page
as.data.table.integer Man page
as.data.table.list Man page
as.data.table.logical Man page
as.data.table.matrix Man page
as.data.table.numeric Man page
as.data.table.ordered Man page
as.data.table.xts Man page
as.Date.IDate Man page
as.IDate Man page
as.IDate.Date Man page
as.IDate.default Man page
as.ITime Man page
as.ITime.character Man page
as.ITime.default Man page
as.ITime.POSIXlt Man page
as.ITime.times Man page
as.list.IDate Man page
as.POSIXct.IDate Man page
as.POSIXct.ITime Man page
as.POSIXlt.ITime Man page
as.xts.data.table Man page
autoindex Man page
auto-index Man page
autoindexing Man page
auto-indexing Man page
between Man page
\%between\% Man page
.BY Man page
chgroup Man page
\%chin\% Man page
chmatch Man page
chorder Man page
c.IDate Man page
CJ Man page
class:data.table Man page
copy Man page
cut.IDate Man page
[.data.table Man page
data.table Man page
data.table-class Man page
data.table-optimize Man page
data.table.optimize Man page
datatable-optimize Man page
datatable.optimize Man page
data.table-package Man page
datatable-symbols Man page
dcast Man page
dcast.data.table Man page
duplicated Man page
duplicated.data.table Man page
except Man page
fastorder Man page
fexcept Man page
fintersect Man page
first Man page
forder Man page
format.ITime Man page
foverlaps Man page
frank Man page
frankv Man page
fread Man page
fsetdiff Man page
fsetequal Man page
fsort Man page
funion Man page
fwrite Man page
getDTthreads Man page
getNumericRounding Man page
gforce Man page
GForce Man page
.GRP Man page
haskey Man page
hour Man page
.I Man page
IDate Man page
IDate-class Man page
IDateTime Man page
IDateTime.default Man page
indices Man page
inrange Man page
\%inrange\% Man page
intersect Man page
is.data.table Man page
is.na.data.table Man page
isoweek Man page
ITime Man page
ITime-class Man page
J Man page
key Man page
key<- Man page
key2 Man page
lag Man page
last Man page
lead Man page
like Man page
\%like\% Man page
mday Man page
mean.IDate Man page
melt Man page
melt.data.table Man page
merge Man page
merge.data.table Man page
minute Man page
month Man page
.N Man page
na.omit Man page
na.omit.data.table Man page
Ops.data.table Man page
order Man page
patterns Man page
print.data.table Man page
print.ITime Man page
quarter Man page
rank Man page
rbind Man page
rbind.data.table Man page
rbindlist Man page
rep.IDate Man page
rep.ITime Man page
rleid Man page
rleidv Man page
round.IDate Man page
rounding Man page
rowid Man page
rowidv Man page
.SD Man page
second Man page
seq.IDate Man page
set Man page
set2key Man page
set2keyv Man page
setattr Man page
setcolorder Man page
setDF Man page
setdiff Man page
setDT Man page
setDTthreads Man page
setequal Man page
setindex Man page
setindexv Man page
setkey Man page
setkeyv Man page
setnames Man page
setNumericRounding Man page
setops Man page
setorder Man page
setorderv Man page
shift Man page
shouldPrint Man page
SJ Man page
special-symbols Man page
split Man page
split.data.table Man page
split.IDate Man page
strsplit Man page
subset Man page
subset.data.table Man page
tables Man page
test.data.table Man page
timetaken Man page
transform Man page
transform.data.table Man page
transpose Man page
truelength Man page
tstrsplit Man page
union Man page
unique Man page
unique.data.table Man page
uniqueN Man page
wday Man page
week Man page
within Man page
within.data.table Man page
yday Man page
year Man page

Files

inst
inst/tests
inst/tests/fread_line_error.csv
inst/tests/tests.Rraw
inst/tests/russellCRLF.csv
inst/tests/536_fread_fill_4.txt
inst/tests/2008head.csv
inst/tests/issue_1113_fread.txt
inst/tests/1680-fread-header-encoding.csv
inst/tests/fread_blank3.txt
inst/tests/issue_1116_fread_few_lines_2.txt
inst/tests/1206FUT.txt
inst/tests/fread_blank.txt
inst/tests/issue_563_fread.txt
inst/tests/issue_1116_fread_few_lines.txt
inst/tests/530_fread.txt
inst/tests/russellCRCRLF.csv
inst/tests/issue_773_fread.txt
inst/tests/issue_785_fread.txt
inst/tests/issue_1462_fread_quotes.txt
inst/tests/issue_1573_fill.txt
inst/tests/quoted_multiline.csv
inst/tests/doublequote_newline.csv
inst/tests/536_fread_fill_1.txt
inst/tests/ch11b.dat
inst/tests/melt-warning-1752.tsv
inst/tests/issue_1330_fread.txt
inst/tests/536_fread_fill_2.txt
inst/tests/fread_blank2.txt
inst/tests/issue_1087_utf8_bom.csv
inst/tests/issue_1095_fread.txt
inst/tests/536_fread_fill_3_extreme.txt
inst/tests/issue_1164_json.txt
inst/doc
inst/doc/datatable-secondary-indices-and-auto-indexing.R
inst/doc/datatable-reshape.Rmd
inst/doc/datatable-faq.html
inst/doc/datatable-faq.Rmd
inst/doc/datatable-secondary-indices-and-auto-indexing.html
inst/doc/datatable-reshape.R
inst/doc/datatable-reference-semantics.Rmd
inst/doc/datatable-intro.html
inst/doc/datatable-intro.Rmd
inst/doc/datatable-reference-semantics.R inst/doc/datatable-faq.R
inst/doc/datatable-keys-fast-subset.Rmd
inst/doc/datatable-reshape.html
inst/doc/datatable-reference-semantics.html
inst/doc/datatable-keys-fast-subset.html
inst/doc/datatable-intro.R
inst/doc/datatable-secondary-indices-and-auto-indexing.Rmd
inst/doc/datatable-keys-fast-subset.R
tests
tests/autoprint.R
tests/autoprint.Rout.save
tests/knitr.R
tests/knitr.Rout.mock
tests/knitr.Rout.save
tests/knitr.Rmd
tests/testthat.R
tests/testthat
tests/testthat/test-data.frame-like.R tests/testthat/test-S4.R tests/main.R
src
src/Makevars
src/ijoin.c
src/fastmean.c
src/fmelt.c
src/fsort.c
src/fwriteLookups.h
src/dogroups.c
src/chmatch.c
src/forder.c
src/fwrite.c
src/data.table.h
src/shift.c
src/gsumm.c
src/wrappers.c
src/reorder.c
src/fread.c
src/subset.c
src/transpose.c
src/between.c
src/vecseq.c
src/inrange.c
src/bmerge.c
src/frank.c
src/init.c
src/uniqlist.c
src/assign.c
src/rbindlist.c
src/fcast.c
src/quickselect.c
src/openmp-utils.c
NAMESPACE
NEWS.md
R
R/shift.R R/utils.R R/test.data.table.R R/data.table.R R/duplicated.R R/bmerge.R R/setkey.R R/AllS4.R R/getdots.R R/onLoad.R R/as.data.table.R R/fmelt.R R/onAttach.R R/IDateTime.R R/cedta.R R/frank.R R/last.R R/uniqlist.R R/openmp-utils.R R/like.R R/foverlaps.R R/setops.R R/c.factor.R R/fcast.R R/xts.R R/timetaken.R R/between.R R/merge.R R/fread.R R/transpose.R R/fwrite.R R/tables.R
vignettes
vignettes/Makefile
vignettes/datatable-reshape.Rmd
vignettes/datatable-faq.Rmd
vignettes/datatable-reference-semantics.Rmd
vignettes/css
vignettes/css/bootstrap.css
vignettes/datatable-intro.Rmd
vignettes/datatable-keys-fast-subset.Rmd
vignettes/melt_enhanced.csv
vignettes/flights14.csv
vignettes/datatable-secondary-indices-and-auto-indexing.Rmd
vignettes/melt_default.csv
README.md
MD5
build
build/vignette.rds
DESCRIPTION
man
man/IDateTime.Rd man/chmatch.Rd man/as.xts.data.table.Rd man/setcolorder.Rd man/duplicated.Rd man/rleid.Rd man/setNumericRounding.Rd man/shift.Rd man/setattr.Rd man/J.Rd man/datatable-optimize.Rd man/last.Rd man/tables.Rd man/special-symbols.Rd man/all.equal.data.table.Rd man/as.data.table.xts.Rd man/truelength.Rd man/rowid.Rd man/melt.data.table.Rd man/rbindlist.Rd man/first.Rd man/setops.Rd man/setDT.Rd man/copy.Rd man/transpose.Rd man/assign.Rd man/setorder.Rd man/merge.Rd man/transform.data.table.Rd man/split.Rd man/between.Rd man/address.Rd man/setkey.Rd man/tstrsplit.Rd man/like.Rd man/shouldPrint.Rd man/fread.Rd man/setDF.Rd man/foverlaps.Rd man/data.table-class.Rd man/fwrite.Rd man/na.omit.data.table.Rd man/print.data.table.Rd man/openmp-utils.Rd man/as.data.table.Rd man/frank.Rd man/subset.data.table.Rd man/patterns.Rd man/fsort.Rd man/data.table.Rd man/timetaken.Rd man/test.data.table.Rd man/dcast.data.table.Rd
LICENSE

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.