Package: data.table 1.16.99
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:
data.table_1.16.99.tar.gz
data.table_1.16.99.zip(r-4.5)data.table_1.16.99.zip(r-4.4)data.table_1.16.99.zip(r-4.3)
data.table_1.16.99.tgz(r-4.4-x86_64)data.table_1.16.99.tgz(r-4.4-arm64)data.table_1.16.99.tgz(r-4.3-x86_64)data.table_1.16.99.tgz(r-4.3-arm64)
data.table_1.16.99.tar.gz(r-4.5-noble)data.table_1.16.99.tar.gz(r-4.4-noble)
data.table_1.16.99.tgz(r-4.4-emscripten)data.table_1.16.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
Last updated 1 hours agofrom:e9087ce986. Checks:OK: 8 NOTE: 1. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Sep 08 2024 |
R-4.5-win-x86_64 | NOTE | Sep 08 2024 |
R-4.5-linux-x86_64 | OK | Sep 08 2024 |
R-4.4-win-x86_64 | OK | Sep 08 2024 |
R-4.4-mac-x86_64 | OK | Sep 08 2024 |
R-4.4-mac-aarch64 | OK | Sep 08 2024 |
R-4.3-win-x86_64 | OK | Sep 08 2024 |
R-4.3-mac-x86_64 | OK | Sep 08 2024 |
R-4.3-mac-aarch64 | OK | Sep 08 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.tableminutemonthnafillpatternsquarterrbindlistrleidrleidvrolluprowidrowidvrowwiseDTsecondsetsetalloccolsetattrsetcolordersetDFsetdroplevelssetDTsetDTthreadssetindexsetindexvsetkeysetkeyvsetnafillsetnamessetNumericRoundingsetordersetordervshiftshouldPrintSJsubstitute2tablestest.data.tabletimetakentransposetruelengthtstrsplituniqueNupdate_dev_pkgwdayweekydayyearyearmonyearqtr
Dependencies:
Benchmarking data.table
Rendered fromdatatable-benchmarking.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-02-18
Started: 2018-03-20
Efficient reshaping using data.tables
Rendered fromdatatable-reshape.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-05-10
Started: 2015-06-23
Frequently Asked Questions about data.table
Rendered fromdatatable-faq.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-09-04
Started: 2016-03-02
Importing data.table
Rendered fromdatatable-importing.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-06-23
Started: 2017-11-27
Introduction to data.table
Rendered fromdatatable-intro.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-06-17
Started: 2016-03-06
Keys and fast binary search based subset
Rendered fromdatatable-keys-fast-subset.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-04-23
Started: 2015-01-23
Programming on data.table
Rendered fromdatatable-programming.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-07-28
Started: 2021-05-10
Reference semantics
Rendered fromdatatable-reference-semantics.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-08-27
Started: 2015-01-22
Secondary indices and auto indexing
Rendered fromdatatable-secondary-indices-and-auto-indexing.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-02-18
Started: 2016-03-26
Using .SD for Data Analysis
Rendered fromdatatable-sd-usage.Rmd
usingknitr::knitr
on Sep 08 2024.Last update: 2024-08-27
Started: 2019-05-22
Readme and manuals
Help Manual
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 setdroplevels |
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 |
Create a data.table row-wise | rowwiseDT |
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 |