Package: data.table 1.18.2.1

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], Ivan Krylov [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 Halperin [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], Angel Feliz [ctb], Michael Young [ctb], Mark Seeto [ctb], Philippe Grosjean [ctb], Vincent Runge [ctb], Christian Wia [ctb], Elise Maigné [ctb], Vincent Rocher [ctb], Vijay Lulla [ctb], Aljaž Sluga [ctb], Bill Evans [ctb], Reino Bruner [ctb], @badasahog [ctb], Vinit Thakur [ctb], Mukul Kumar [ctb], Ildikó Czeller [ctb], Manmita Das [ctb]

data.table_1.18.2.1.tar.gz
data.table_1.18.2.1.zip(r-4.6)data.table_1.18.2.1.zip(r-4.5)data.table_1.18.2.1.zip(r-4.4)
data.table_1.18.2.1.tgz(r-4.6-x86_64)data.table_1.18.2.1.tgz(r-4.6-arm64)data.table_1.18.2.1.tgz(r-4.5-x86_64)data.table_1.18.2.1.tgz(r-4.5-arm64)
data.table_1.18.2.1.tar.gz(r-4.6-arm64)data.table_1.18.2.1.tar.gz(r-4.6-x86_64)data.table_1.18.2.1.tar.gz(r-4.5-arm64)data.table_1.18.2.1.tar.gz(r-4.5-x86_64)
data.table_1.18.2.1.tgz(r-4.5-emscripten)
data.table.pdf |data.table.html✨
data.table/json (API)
NEWS

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

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

On CRAN:

Conda:

16.84 score 3 stars 4.9k packages 296k scripts 1.2M downloads 136 exports 0 dependencies

Last updated from:5245659e9c. Checks:11 NOTE, 2 OK. Indexed: no.

TargetResultTotal timeArtifact
linux-devel-arm64NOTE182
linux-devel-x86_64NOTE194
source / vignettesOK196
linux-release-arm64NOTE212
linux-release-x86_64NOTE193
macos-devel-arm64NOTE182
macos-devel-x86_64NOTE338
macos-release-arm64NOTE175
macos-release-x86_64NOTE237
windows-develNOTE218
windows-releaseNOTE212
windows-oldrelNOTE207
wasm-releaseOK104

Exports::=.BY.EACHI.GRP.I.Last.updated.N.NGRP.SD.selfref.ok%between%%chin%%flike%%ilike%%inrange%%like%%notin%%plike%addressalloc.colas.data.tableas.IDateas.ITimeas.xts.data.tablebetweencbindlistchgroupchmatchchorderCJcopycubedata.tabledcastdcast.data.tablefcasefcoalescefctrfdroplevelsfifelsefintersectfirstformat_colformat_list_itemfoverlapsfrankfrankvfreadfrevfrolladaptfrollapplyfrollmaxfrollmeanfrollmedianfrollminfrollprodfrollsdfrollsumfrollvarfsetdifffsetequalfsortfunionfwritegetDTthreadsgetNumericRoundinggroupingsetshaskeyhourIDateTimeindicesinrangeis.data.tableisoweekisoyearkeylastletlikemdaymeasuremeasurevmeltmelt.data.tablemerge.data.tablemergelistminutemonthnafillpatternsquarterrbindlistrleidrleidvrolluprowidrowidvrowwiseDTsecondsetsetalloccolsetattrsetcbindlistsetcolordersetDFsetdroplevelssetDTsetDTthreadssetindexsetindexvsetkeysetkeyvsetmergelistsetnafillsetnamessetNumericRoundingsetordersetordervshiftshouldPrintSJsubstitute2tablestest.data.tabletimetakentransposetruelengthtstrsplituniqueNupdate_dev_pkgwdayweekydayyearyearmonyearqtr

Dependencies:

Benchmarking data.table

Rendered fromdatatable-benchmarking.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2018-05-01

Efficient reshaping using data.tables

Rendered fromdatatable-reshape.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2015-09-19

Fast Read and Fast Write

Rendered fromdatatable-fread-and-fwrite.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2025-12-24

Frequently Asked Questions about data.table

Rendered fromdatatable-faq.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2016-11-25

Importing data.table

Rendered fromdatatable-importing.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2018-05-01

Introduction to data.table

Rendered fromdatatable-intro.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2016-11-25

Joins in data.table

Rendered fromdatatable-joins.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2025-02-22

Keys and fast binary search based subset

Rendered fromdatatable-keys-fast-subset.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2015-09-19

Programming on data.table

Rendered fromdatatable-programming.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2024-01-30

Reference semantics

Rendered fromdatatable-reference-semantics.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2015-09-19

Secondary indices and auto indexing

Rendered fromdatatable-secondary-indices-and-auto-indexing.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
Started: 2016-11-25

Using .SD for Data Analysis

Rendered fromdatatable-sd-usage.Rmdusingknitr::knitron Jan 27 2026.

Last update: 2025-12-24
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
Tests self reference of a data.table.selfref.ok
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
Column bind multiple data.tablescbind cbind.data.table cbindlist setcbindlist
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
Condition Handling with Classed Conditionsdata.table-condition-classes
Global Options for the data.table Packagedata.table-options data.table.options datatable-options datatable.options
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
Create a factor retaining original orderingfactor fctr
Fast droplevelsdroplevels droplevels.data.table fdroplevels setdroplevels
Fast ifelsefifelse ifelse
Fast overlap joinsfoverlaps
Fast rankfrank frankv rank
Fast and friendly file finaglerfread
Fast reversefrev rev
Rolling functionsfroll frollmax frollmean frollmedian frollmin frollprod frollsd frollsum frollvar moving roll rolling rollmax rollmean rollmedian rollmin rollprod rollsd rollsum rollvar running sliding
Adapt rolling window to irregularly spaced time seriesfrolladapt
Rolling user-defined functionfrollapply rollapply
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 isoyear 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
Merge multiple data.tablesmergelist setmergelist
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
Generate unique row ids within each grouprowid rowidv
Create a data.table row-wiserowwiseDT
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 sort_by
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 teststest.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