Package: data.table 1.16.4

Tyson Barrett

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, friendly and fast character-separated-value read/write. Offers a natural and flexible syntax, for faster development.

Authors:Tyson Barrett [aut, cre], Matt Dowle [aut], Arun Srinivasan [aut], Jan Gorecki [aut], Michael Chirico [aut], Toby Hocking [aut], Benjamin Schwendinger [aut], Pasha Stetsenko [ctb], Tom Short [ctb], Steve Lianoglou [ctb], Eduard Antonyan [ctb], Markus Bonsch [ctb], Hugh Parsonage [ctb], Scott Ritchie [ctb], Kun Ren [ctb], Xianying Tan [ctb], Rick Saporta [ctb], Otto Seiskari [ctb], Xianghui Dong [ctb], Michel Lang [ctb], Watal Iwasaki [ctb], Seth Wenchel [ctb], Karl Broman [ctb], Tobias Schmidt [ctb], David Arenburg [ctb], Ethan Smith [ctb], Francois Cocquemas [ctb], Matthieu Gomez [ctb], Philippe Chataignon [ctb], Nello Blaser [ctb], Dmitry Selivanov [ctb], Andrey Riabushenko [ctb], Cheng Lee [ctb], Declan Groves [ctb], Daniel Possenriede [ctb], Felipe Parages [ctb], Denes Toth [ctb], Mus Yaramaz-David [ctb], Ayappan Perumal [ctb], James Sams [ctb], Martin Morgan [ctb], Michael Quinn [ctb], @javrucebo [ctb], @marc-outins [ctb], Roy Storey [ctb], Manish Saraswat [ctb], Morgan Jacob [ctb], Michael Schubmehl [ctb], Davis Vaughan [ctb], Leonardo Silvestri [ctb], Jim Hester [ctb], Anthony Damico [ctb], Sebastian Freundt [ctb], David Simons [ctb], Elliott Sales de Andrade [ctb], Cole Miller [ctb], Jens Peder Meldgaard [ctb], Vaclav Tlapak [ctb], Kevin Ushey [ctb], Dirk Eddelbuettel [ctb], Tony Fischetti [ctb], Ofek Shilon [ctb], Vadim Khotilovich [ctb], Hadley Wickham [ctb], Bennet Becker [ctb], Kyle Haynes [ctb], Boniface Christian Kamgang [ctb], Olivier Delmarcell [ctb], Josh O'Brien [ctb], Dereck de Mezquita [ctb], Michael Czekanski [ctb], Dmitry Shemetov [ctb], Nitish Jha [ctb], Joshua Wu [ctb], Iago Giné-Vázquez [ctb], Anirban Chetia [ctb], Doris Amoakohene [ctb], Ivan Krylov [ctb]

data.table_1.16.4.tar.gz
data.table_1.16.4.tar.gz(r-4.5-noble)data.table_1.16.4.tar.gz(r-4.4-noble)
data.table_1.16.4.tgz(r-4.4-emscripten)data.table_1.16.4.tgz(r-4.3-emscripten)
data.table.pdf |data.table.html✨
data.table/json (API)
NEWS

# Install 'data.table' in R:
install.packages('data.table', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/rdatatable/data.table/issues

16.50 score 3 stars 4.5k packages 222k scripts 1.0M downloads 120 exports 0 dependencies

Last updated 20 days agofrom:dada9eabb4. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKDec 06 2024
R-4.5-linux-x86_64OKDec 06 2024

Exports::=.BY.EACHI.GRP.I.Last.updated.N.NGRP.SD%between%%chin%%flike%%ilike%%inrange%%like%%notin%%plike%addressalloc.colas.data.tableas.IDateas.ITimeas.xts.data.tablebetweenchgroupchmatchchorderCJcopycubedata.tabledcastdcast.data.tablefcasefcoalescefdroplevelsfifelsefintersectfirstformat_colformat_list_itemfoverlapsfrankfrankvfreadfrollapplyfrollmeanfrollsumfsetdifffsetequalfsortfunionfwritegetDTthreadsgetNumericRoundinggroupingsetshaskeyhourIDateTimeindicesinrangeis.data.tableisoweekkeykey<-lastletlikemdaymeasuremeltmelt.data.tablemerge.data.tableminutemonthnafillpatternsquarterrbindlistrleidrleidvrolluprowidrowidvsecondsetsetalloccolsetattrsetcolordersetDFsetdroplevelssetDTsetDTthreadssetindexsetindexvsetkeysetkeyvsetnafillsetnamessetNumericRoundingsetordersetordervshiftshouldPrintSJsubstitute2tablestest.data.tabletimetakentransposetruelengthtstrsplituniqueNupdate_dev_pkgwdayweekydayyearyearmonyearqtr

Dependencies:

Benchmarking data.table

Rendered fromdatatable-benchmarking.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2018-05-01

Efficient reshaping using data.tables

Rendered fromdatatable-reshape.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2015-09-19

Frequently Asked Questions about data.table

Rendered fromdatatable-faq.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2016-11-25

Importing data.table

Rendered fromdatatable-importing.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2018-05-01

Introduction to data.table

Rendered fromdatatable-intro.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2016-11-25

Keys and fast binary search based subset

Rendered fromdatatable-keys-fast-subset.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2015-09-19

Programming on data.table

Rendered fromdatatable-programming.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2024-01-30

Reference semantics

Rendered fromdatatable-reference-semantics.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2015-09-19

Secondary indices and auto indexing

Rendered fromdatatable-secondary-indices-and-auto-indexing.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2016-11-25

Using .SD for Data Analysis

Rendered fromdatatable-sd-usage.Rmdusingknitr::knitron Dec 06 2024.

Last update: 2024-08-27
Started: 2019-10-03

Readme and manuals

Help Manual

Help pageTopics
Enhanced data.framedata.table-package . .( .() .. data.table is.na.data.table Ops.data.table [.data.table
Assignment by reference:= let set
Number of rows affected by last update.Last.updated Last.updated
Address in RAM of a variableaddress
Equality Test Between Two Data Tablesall.equal all.equal.data.table
Coerce to data.tableas.data.table as.data.table.array as.data.table.character as.data.table.data.frame as.data.table.data.table as.data.table.Date as.data.table.factor as.data.table.integer as.data.table.list as.data.table.logical as.data.table.matrix as.data.table.numeric as.data.table.ordered is.data.table
Efficient xts to as.data.table conversionas.data.table.xts
Convert a data.table to a matrixas.matrix as.matrix.data.table
Efficient data.table to xts conversionas.xts.data.table
Convenience functions for range subsets.%between% %inrange% between inrange
data.table exported C routinescdatatable
Faster match of character vectors%chin% chgroup chmatch chorder
Copy an entire objectcopy
S4 Definition for data.tableclass:data.table data.table-class
Optimisations in data.tableauto-index auto-indexing autoindex autoindexing data.table-optimize data.table.optimize datatable-optimize datatable.optimize GForce gforce rounding
Fast dcast for data.tabledcast dcast.data.table
Determine Duplicate RowsanyDuplicated anyDuplicated.data.table duplicated duplicated.data.table unique unique.data.table uniqueN
fcasefcase
Coalescing missing valuesfcoalesce setcoalesce
Fast droplevelsdroplevels droplevels.data.table fdroplevels setdroplevels
Fast ifelsefifelse ifelse
Fast overlap joinsfoverlaps
Fast rankfrank frankv rank
Fast and friendly file finaglerfread
Fast parallel sortfsort
Fast CSV writerfwrite
Grouping Set aggregation for data tablescube cube.data.table groupingsets groupingsets.data.table rollup rollup.data.table
Integer based date classas.character.ITime as.Date.IDate as.IDate as.IDate.Date as.IDate.default as.ITime as.ITime.character as.ITime.default as.ITime.POSIXlt as.ITime.times as.list.IDate as.POSIXct.IDate as.POSIXct.ITime as.POSIXlt.ITime c.IDate c.ITime format.ITime hour IDate IDate-class IDateTime IDateTime.default isoweek ITime ITime-class mday mean.IDate mean.ITime minute month print.ITime quarter rep.IDate rep.ITime round.IDate round.ITime second seq.IDate seq.ITime trunc.ITime wday week yday year yearmon yearqtr
Creates a join 'data.table'CJ J SJ
First/last item of an objectfirst last
Convenience function for calling grep.%flike% %ilike% %like% %plike% like
Specify measure.vars via regex or separatormeasure measurev
Fast melt for data.tablemelt melt.data.table
Merge two data.tablesmerge merge.data.table
Remove rows with missing values on columns specifiedna.omit na.omit.data.table
Fill missing valuesfill locf na.fill nafill nocb setnafill
Convenience operator for checking if an example is not in a set of elements%notin%
Obtain matching indices corresponding to patternspatterns
data.table Printing Optionsformat_col format_col.default format_col.expression format_col.POSIXct format_list_item format_list_item.default print.data.table
Makes one data.table from a list of manyrbind rbind.data.table rbindlist
Generate run-length type group idrleid rleidv
Rolling functionsfroll frollapply frollmean frollsum moving roll rollapply rolling rollmean rollsum sliding
Generate unique row ids within each grouprowid rowidv
Set attributes of objects by referencesetattr setnames
Fast column reordering of a data.table by referencesetcolorder
Coerce a data.table to data.frame by referencesetDF
Coerce lists and data.frames to data.table by referencesetDT
Set or get number of threads that data.table should usegetDTthreads openMP openmp setDTthreads
Create key on a data.tablehaskey indices key setindex setindexv setkey setkeyv
Change or turn off numeric roundinggetNumericRounding setNumericRounding
Set operations for data tablesexcept fexcept fintersect fsetdiff fsetequal funion intersect setdiff setequal setops union
Fast row reordering of a data.table by referencefastorder forder forderv order setorder setorderv
Fast lead/lag for vectors and listslag lead shift
For use by packages that mimic/divert auto printing e.g. IRkernel and knitrshouldPrint
Special symbols.BY .EACHI .GRP .I .N .NATURAL .NGRP .SD datatable-symbols special-symbols
Split data.table into chunks in a listsplit split.data.table
Subsetting data.tablessubset subset.data.table
Substitute expressionI substitute substitute2
Display 'data.table' metadatatables
Test assertions for equality, exceptions and console outputtest
Runs a set of tests.test.data.table
Pretty print of time takentimetaken
Efficient transpose of listtranspose
Over-allocation accessalloc.col setalloccol truelength
strsplit and transpose the resulting list efficientlystrsplit tstrsplit
Perform update of development version of a packageupdate_dev_pkg