Package: data.table 1.15.99

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]

data.table_1.15.99.tar.gz
data.table_1.15.99.zip(r-4.5)data.table_1.15.99.zip(r-4.4)data.table_1.15.99.zip(r-4.3)
data.table_1.15.99.tgz(r-4.4-arm64)data.table_1.15.99.tgz(r-4.4-x86_64)data.table_1.15.99.tgz(r-4.3-arm64)data.table_1.15.99.tgz(r-4.3-x86_64)
data.table_1.15.99.tar.gz(r-4.5-noble)data.table_1.15.99.tar.gz(r-4.4-noble)
data.table_1.15.99.tgz(r-4.4-emscripten)data.table_1.15.99.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://fastverse.r-universe.dev', 'https://cloud.r-project.org'))

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

On CRAN:

120 exports 3.5k stars 17.92 score 0 dependencies 4318 dependents 666.1k downloads

Last updated 7 hours agofrom:822631e985

Exports::=.BY .EACHI .GRP .I .Last.updated .N .NGRP .SD [.data.table %between%%chin%%flike%%ilike%%inrange%%like%%notin%%plike%address alloc.col as.data.table as.IDate as.ITime as.xts.data.table between chgroup chmatch chorder CJ copy cube data.table dcast dcast.data.table fcase fcoalesce fdroplevels fifelse fintersect first format_col format_list_item foverlaps frank frankv fread frollapply frollmean frollsum fsetdiff fsetequal fsort funion fwrite getDTthreads getNumericRounding groupingsets haskey hour IDateTime indices inrange is.data.table isoweek key key<-last let like mday measure melt melt.data.table merge.data.table minute month nafill patterns quarter rbindlist rleid rleidv rollup rowid rowidv second set setalloccol setattr setcolorder setDF setDT setDTthreads setindex setindexv setkey setkeyv setnafill setnames setNumericRounding setorder setorderv shift shouldPrint SJ substitute2 tables test.data.table timetaken transpose truelength tstrsplit uniqueN update_dev_pkg wday week yday year yearmon yearqtr

Dependencies:

Benchmarking data.table

Rendered fromdatatable-benchmarking.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-02-18
Started: 2018-03-20

Efficient reshaping using data.tables

Rendered fromdatatable-reshape.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-05-10
Started: 2015-06-23

Frequently Asked Questions about data.table

Rendered fromdatatable-faq.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-04-23
Started: 2016-03-02

Importing data.table

Rendered fromdatatable-importing.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-06-23
Started: 2017-11-27

Introduction to data.table

Rendered fromdatatable-intro.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-06-17
Started: 2016-03-06

Keys and fast binary search based subset

Rendered fromdatatable-keys-fast-subset.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-04-23
Started: 2015-01-23

Programming on data.table

Rendered fromdatatable-programming.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-07-08
Started: 2021-05-10

Reference semantics

Rendered fromdatatable-reference-semantics.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-06-16
Started: 2015-01-22

Secondary indices and auto indexing

Rendered fromdatatable-secondary-indices-and-auto-indexing.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-02-18
Started: 2016-03-26

Using .SD for Data Analysis

Rendered fromdatatable-sd-usage.Rmdusingknitr::knitron Jul 27 2024.

Last update: 2024-04-23
Started: 2019-05-22

Help page	Topics
Enhanced data.frame	data.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 variable	address
Equality Test Between Two Data Tables	all.equal all.equal.data.table
Coerce to data.table	as.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 conversion	as.data.table.xts
Convert a data.table to a matrix	as.matrix as.matrix.data.table
Efficient data.table to xts conversion	as.xts.data.table
Convenience functions for range subsets.	%between% %inrange% between inrange
data.table exported C routines	cdatatable
Faster match of character vectors	%chin% chgroup chmatch chorder
Copy an entire object	copy
S4 Definition for data.table	class:data.table data.table-class
Optimisations in data.table	auto-index auto-indexing autoindex autoindexing data.table-optimize data.table.optimize datatable-optimize datatable.optimize GForce gforce rounding
Fast dcast for data.table	dcast dcast.data.table
Determine Duplicate Rows	anyDuplicated anyDuplicated.data.table duplicated duplicated.data.table unique unique.data.table uniqueN
fcase	fcase
Coalescing missing values	fcoalesce setcoalesce
Fast droplevels	droplevels droplevels.data.table fdroplevels
Fast ifelse	fifelse ifelse
Fast overlap joins	foverlaps
Fast rank	frank frankv rank
Fast and friendly file finagler	fread
Fast parallel sort	fsort
Fast CSV writer	fwrite
Grouping Set aggregation for data tables	cube cube.data.table groupingsets groupingsets.data.table rollup rollup.data.table
Integer based date class	as.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 object	first last
Convenience function for calling grep.	%flike% %ilike% %like% %plike% like
Specify measure.vars via regex or separator	measure measurev
Fast melt for data.table	melt melt.data.table
Merge two data.tables	merge merge.data.table
Remove rows with missing values on columns specified	na.omit na.omit.data.table
Fill missing values	fill 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 patterns	patterns
data.table Printing Options	format_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 many	rbind rbind.data.table rbindlist
Generate run-length type group id	rleid rleidv
Rolling functions	froll frollapply frollmean frollsum moving roll rollapply rolling rollmean rollsum sliding
Generate unique row ids within each group	rowid rowidv
Set attributes of objects by reference	setattr setnames
Fast column reordering of a data.table by reference	setcolorder
Coerce a data.table to data.frame by reference	setDF
Coerce lists and data.frames to data.table by reference	setDT
Set or get number of threads that data.table should use	getDTthreads openMP openmp setDTthreads
Create key on a data.table	haskey indices key setindex setindexv setkey setkeyv
Change or turn off numeric rounding	getNumericRounding setNumericRounding
Set operations for data tables	except fexcept fintersect fsetdiff fsetequal funion intersect setdiff setequal setops union
Fast row reordering of a data.table by reference	fastorder forder forderv order setorder setorderv
Fast lead/lag for vectors and lists	lag lead shift
For use by packages that mimic/divert auto printing e.g. IRkernel and knitr	shouldPrint
Special symbols	.BY .EACHI .GRP .I .N .NATURAL .NGRP .SD datatable-symbols special-symbols
Split data.table into chunks in a list	split split.data.table
Subsetting data.tables	subset subset.data.table
Substitute expression	I substitute substitute2
Display 'data.table' metadata	tables
Test assertions for equality, exceptions and console output	test
Runs a set of tests.	test.data.table
Pretty print of time taken	timetaken
Efficient transpose of list	transpose
Over-allocation access	alloc.col setalloccol truelength
strsplit and transpose the resulting list efficiently	strsplit tstrsplit
Perform update of development version of a package	update_dev_pkg