Reference manual

install.packages("data.table")

1.14.8 by Matt Dowle, 4 months ago

https://r-datatable.com, https://Rdatatable.gitlab.io/data.table, https://github.com/Rdatatable/data.table

Report a bug at https://github.com/Rdatatable/data.table/issues

Browse source code at https://github.com/cran/data.table

Authors: Matt Dowle [aut, cre] , Arun Srinivasan [aut] , Jan Gorecki [ctb] , Michael Chirico [ctb] , 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] , Toby Hocking [ctb] , Leonardo Silvestri [ctb] , Tyson Barrett [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] , Ben Schwen [ctb]

Documentation: PDF Manual

MPL-2.0 | file LICENSE license

Imports methods

Suggests bit64, bit, curl, R.utils, xts, nanotime, zoo, yaml, knitr, rmarkdown

System requirements: zlib

Imported by AFM, AICcPermanova, AOV1R, APCI, APackOfTheClones, ARPALData, ASRgenomics, Achilles, ActivePathways, ActivityIndex, AdhereR, AdhereRViz, AeRobiology, AggregateR, Anaconda, AnxietySleep, AtmChile, BBmisc, BIGL, BIOMASS, BMisc, BREADR, BRINDA, BTSPAS, BTYDplus, BatchExperiments, BatchJobs, BayesLN, BeeGUTS, BiasCorrector, BootstrapQTL, Boov, BuyseTest, CALF, CAST, CLVTools, CNVScope, COVID19, CRE, CSMES, CSTools, CamelUp, CatEncoders, CausalGPS, Census2016, Certara.NLME8, Certara.R, ChannelAttributionApp, ChemoSpecUtils, ChineseNames, ClickHouseHTTP, CluMP, Clustering, CoDiNA, CoNI, CoOL, CompareCausalNetworks, ConsReg, CooRTweet, CornerstoneR, CovRegRF, CropScapeR, D3partitionR, DATAstudio, DGM, DIZtools, DIZutils, DQAgui, DQAstats, DTAT, DTSg, DTwrappers, DYNATE, DataCombine, DataExplorer, DataSpaceR, DemoKin, DescTools, Diderot, DisImpact, DoubleML, DramaAnalysis, DysPIA, E4tools, EHR, EIAapi, EIX, Eagle, EdSurvey, EmiR, EmissV, Epi, EpiForsk, EpiNow2, EthSEQ, EventStudy, FACT, FAOSTAT, FCO, FIESTA, FIESTAutils, FORTLS, FairMclus, FedData, Fgmutils, FourWayHMM, FuncDiv, FuzzyDBScan, GALLO, GARCOM, GFE, GGIR, GHap, GMMAT, GREENeR, GRShiny, GSODR, GWASinspector, GWPR.light, GapAnalysis, GeoModels, GeoMongo, HACSim, HCR, HRM, HS, HYPEtools, HaDeX, Hmisc, HodgesTools, ICAMS, IDConverter, IDEATools, IDmining, IOHanalyzer, IceSat2R, IncDTW, Inflect, InflectSSP, Information, IrregLong, JSmediation, JWileymisc, KnockoffScreen, LCMSQA, LDLcalc, LOMAR, LOPART, LPDynR, LWFBrook90R, LabourMarketAreas, LearningStats, LexisNexisTools, LilRhino, Luminescence, MAGEE, MANOVA.RM, MOCHA, MODIStsp, MantaID, MeshesTools, MetaComp, MetaIntegrator, MinkowskiSum, ModelMetrics, MplusAutomation, MultiFit, NACHO, NADIA, NEONiso, NFLSimulatoR, NMcalc, NMdata, NNS, OBIC, OmicNavigator, OnboardClient, OpenML, PAMpal, PCMBase, PCMBaseCpp, PCRA, PGRdup, PKPDsim, POMS, POSSA, POUMM, PPtreeregViz, PROSPER, PReMiuM, PSF, PTXQC, PakPMICS2014Ch, PakPMICS2014HH, PakPMICS2014HL, PakPMICS2014Wm, PanelMatch, ParBayesianOptimization, PeakSegDisk, PhenotypeSimulator, PlanetNICFI, PolygonSoup, PressPurt, ProFound, PsychWordVec, Publish, PupillometryR, QCAcluster, QTL.gCIMapping, QTL.gCIMapping.GUI, R2DT, R62S3, R6causal, RABR, RALSA, RARfreq, RAthena, RBaseX, RDML, REDCapExporter, REndo, RFpredInterval, RITCH, RIbench, RLumShiny, RNewsflow, ROCket, RTTWebClient, RVA, RWDataPlyr, RZooRoH, RaMS, Ravages, RawHummus, Rborist, Rcan, RcextTools, RcmdrPlugin.RiskDemo, RcppGreedySetCover, Rcrawler, Rdiagnosislist, Rdice, RecordLinkage, Rediscover, RefBasedMI, ReinforcementLearning, Require, Rilostat, Rnvd3, RtD3, RxnSim, SC2API, SDLfilter, SEA, SELF, SGP, SGPdata, SHAPforxgboost, SIPmg, SNPannotator, SPARSEMODr, SQMtools, SSHAARP, SUMMER, SUNGEO, SVN, SWMPr, SafeVote, ScoreEB, SenTinMixt, SetRank, ShinyQuickStarter, Signac, SimEngine, SimSurvey, SmartEDA, SoilHyP, SoilTaxonomy, SpATS, SpaDES.tools, Statsomat, SunsVoc, TCA, TSstudio, TTAinterfaceTrendAnalysis, TangledFeatures, TeXCheckR, TheOpenAIR, TideCurves, TideTables, TidyDensity, Trading, TrafficBDE, TrustVDJ, Tushare, UKB.COVID19, UKgrid, VIM, VMDecomp, VOSONDash, VoxR, WhatsR, aLFQ, accessibility, actel, actuaRE, africamonitor, agriutilities, ahw, akc, akiFlagger, alpaca, amapGeocode, amt, animint2, antaresEditObject, antaresProcessing, antaresRead, antaresViz, aopdata, aorsf, aqp, arf, asciiSetupReader, ascotraceR, aslib, assertable, atime, attrib, aum, autoCovariateSelection, autonewsmd, autostats, autostsm, aweSOM, bRacatus, babsim.hospital, bagged.outliertrees, bakR, baseballr, batchtools, bayesLife, bayesPop, bayesTFR, bbotk, bcputility, bdchecks, bdclean, bedr, benford.analysis, bfw, biblionetwork, bife, bigreadr, bigsnpr, binancer, binomialRF, binsegRcpp, bioRad, biomartr, bioregion, bkmrhat, blorr, bold, brainGraph, brandwatchR, bread, bridger2, brmsmargins, bruceR, bupaR, c3, camtrapR, card, caretEnsemble, cartogramR, casebase, categoryEncodings, causalCmprsk, cbl, ccostr, cfbfastR, cffdrs, cgalMeshes, cglm, changepoint.influence, chronicle, citationchaser, citecorp, clickstream, clinDataReview, clinUtils, clinspacy, clustra, cmsaf, coder, cohorts, coinmarketcapr, coloc, colorednoise, comorbidity, compareDF, conleyreg, consortr, constellation, container, cooltools, corporaexplorer, corpustools, corrcoverage, corregp, correspondenceTables, counterfactuals, covid19br, covid19india, covidnor, cppRouting, creditmodel, crfsuite, crosshap, csdata, csmaps, cstidy, cstime, csutil, csv, csvy, ctbi, ctmm, ctsem, curtailment, cusum, cusumcharter, cvAUC, cvms, cwbtools, cxhull, cylcop, dQTG.seq, daiquiri, dartR, dat, data360r, dataMojo, dataPreparation, datadictionary, dataframeexplorer, datagovsgR, datamods, dataprep, datazoom.amazonia, datelife, dateutils, dblr, dbnR, dedupewider, deepdive, delayed, deltaccd, demcon, detectRUNS, diathor, did2s, difconet, discSurv, disk.frame, distantia, distillML, do, doremi, drgee, droptest, dsos, dtplyr, dtts, dtwSat, dumbbell, dvmisc, dynamite, dynsurv, eSIR, easyr, eatGADS, eatTools, eclust, ecocomDP, edeaR, eeptools, efdm, eixport, electionsBR, eltr, endoSwitch, endogeneity, ensr, enviGCMS, eoR, epidm, epiomics, eplusr, epwshiftr, estadistica, etm, etwfe, eurodata, europeanaR, eventstudyr, evoper, exiftoolr, exploratory, expowo, expss, expstudy, exvatools, eyeRead, ezr, faersquarterlydata, familiar, farrell, fastDummies, fastLink, fastRhockey, fastText, fastverse, fbRads, fcfdr, fdq, febr, fedmatch, fedstatAPIr, felp, ffsimulator, fgdr, fhircrackr, finch, fishmethods, fitbitViz, flextable, flightsbr, flippant, forecastML, forestError, formatdown, formulaic, fossilbrush, fruclimadapt, fsbrain, funchir, futureheatwaves, fy, gasfluxes, gcite, gde, gems, genomic.autocorr, geobr, germinationmetrics, getDTeval, gfer, gfoRmula, ggDoE, ggPMX, ggTimeSeries, ggbrain, ggdmc, ggetho, ggmotif, ggperiodic, ggpval, ggsom, githubinstall, gittargets, gnrprod, gofastr, gompertztrunc, googleCloudVisionR, gorpiper, gpboost, greatR, greport, growthcleanr, gtfs2emis, gtfs2gps, gtfsio, gtfsrouter, gtfstools, gunsales, gwaRs, gwasforest, hBayesDM, hR, hagis, hal9001, haldensify, hdpGLM, heatwaveR, hereR, hesim, heuristicsmineR, highfrequency, hilldiv, himach, hisse, hoardeR, hoopR, hot.deck, hsrecombi, httk, hudr, hurricaneexposure, hutils, hutilscpp, hwig, hydroPSO, hyfo, hypervolume, i2extras, iCAMP, iCellR, iSTATS, ie2misc, iemisc, ifCNVR, imabc, iml, immuneSIM, importinegi, imputeMulti, inTrees, inbreedR, incidence2, inferr, influential, insurancerating, irg, iscoCrosswalks, isdparser, isobxr, isotracer, itol.toolkit, itscalledsoccer, ivdoctr, ivtools, joinXL, journalabbr, joyn, jsTree, jsmodule, jstable, jubilee, kangar00, kdry, kerastuneR, kesernetwork, kgen, kibior, kim, koRpus, labourR, lar, latrend, ldaPrototype, ldamatch, ldsr, leafR, lexicon, lgrExtra, libr, lidR, lightgbm, limorhyde2, live, livechatR, llama, lmtp, loadeR, logiBin, lwqs, m5, maditr, magclass, maicChecks, mapi, marginaleffects, margins, marked, matman, mau, mbRes, mbr, mcboost, medrxivr, memisc, metR, metaGE, metabolomicsR, miceFast, miceRanger, microeco, miesmuschel, mimi, minSNPs, mipplot, miscset, missCompare, mixIndependR, mixgb, mknapsack, mlbplotR, mldr.resampling, mlr, mlr3, mlr3batchmark, mlr3benchmark, mlr3cluster, mlr3db, mlr3fairness, mlr3filters, mlr3fselect, mlr3hyperband, mlr3learners, mlr3mbo, mlr3misc, mlr3oml, mlr3pipelines, mlr3shiny, mlr3spatial, mlr3spatiotempcv, mlr3tuning, mlr3tuningspaces, mlr3verse, mlr3viz, mlrMBO, mlrintermbo, mltools, mmaqshiny, mmpf, modACDC, modelsummary, mpwR, mrMLM, mrMLM.GUI, mregions, mrregression, mschart, msmtools, mstate, mstclustering, mstrio, mtb, multifamm, multilateral, multilevelTools, multilevelcoda, mutualinf, mvQuad, mxnorm, naaccr, naptanr, nc, ndjson, neatR, neatRanges, neatStats, neo4r, neonOS, neonUtilities, nestedcv, net4pg, netgsa, networkR, nflfastR, nflplotR, nflreadr, nflseedR, nlmixr2extra, nngeo, noaastormevents, noctua, node2vec, noncompliance, nonmem2rx, norgeo, npcurePK, numbat, o2geosocial, obliqueRSF, occupationMeasurement, oddsapiR, odns, ogrdbstats, okxAPI, olsrr, omicwas, ompr, ondisc, openEBGM, opentripplanner, optiSel, origami, overviewR, owdbr, pRecipe, pTITAN2, packDAMipd, packageRank, panelWranglR, panstarrs, parSim, paradox, parseRPDR, pathviewr, pathwayTMB, patternator, pcadapt, pda, pdynmc, pedquant, penaltyLearning, pepr, pheble, phenofit, phers, phm, phonics, pingers, pinyin, pivottabler, pkgnet, pksensi, places, plinkQC, plnr, plotly, pmd, pmparser, pmxpartab, pointdensityP, poisFErobust, politeness, polle, polmineR, polypharmacy, pomp, poolfstat, pooling, popEpi, portvine, posologyr, potools, powerbiR, ppmlasso, precrec, predhy.GUI, prediction, preputils, previsionio, processmapR, processpredictR, prodlim, prolific.api, protti, prrd, prt, psborrow, psidR, psmineR, ptable, pureseqtmr, pvLRT, qPCRtools, qad, qdapTools, qgg, qte, qtl2, quickPlot, quickcheck, r2dii.match, r2glmm, r5r, rAmCharts, rBayesianOptimization, rBiasCorrection, rCNV, rENA, rIsing, rODE, rPackedBar, rabhit, radlibs, randnet, randomForestExplainer, randomNames, rangeMapper, rassta, ratios, raveio, rbacon, rbi, rbi.helpers, rbin, rbtt, rchemo, rdbnomics, rdfp, readNSx, readtext, reappraised, recorder, regport, regtools, remiod, replacer, repmis, reproducible, rerddap, rescue, resemble, respR, restatapi, rfars, rfisheries, rgbif, ricu, rintcal, rio, riskRegression, ritis, rlas, rlist, rmcfs, rnoaa, rnpn, roads, robis, rollinglda, rorcid, rprev, rqPen, rqdatatable, rsnps, rsparse, rsqliteadmin, rsurveycto, rsyntax, rtmpt, rtry, rtsdata, runcharter, rxode2, rxode2parse, ryandexdirect, rzentra, s3fs, saeHB.twofold, salesforcer, samadb, sanityTracker, sansa, sarp.snowprofile, sarp.snowprofile.alignment, sarp.snowprofile.pyface, scCustomize, scDiffCom, scoper, scopr, scorecard, scoringutils, scraEP, sdcHierarchies, sdcLog, sdcMicro, sdcTable, seedr, seeker, segregation, semgram, semtree, sen2r, sendigR, sense, sensobol, sentiment.ai, sentimentr, sentometrics, sentopics, servosphereR, sgat, shapr, shinyHugePlot, shinylogs, siconvr, sigminer, siie, simPH, simPop, simcausal, simfinapi, simphony, simplePHENOTYPES, simstudy, sitepickR, siteymlgen, sitree, sitreeE, sjtable2df, skynet, sleepr, smallstuff, smartsnp, snpsettest, socialh, socialmixr, soilDB, soiltestcorr, solitude, spDates, spNetwork, spacyr, sparseFLMM, spatialrisk, spatsoc, speaq, spectr, spectralAnalysis, spellcheckr, splitstackshape, splutil, spocc, sport, squid, staRdom, standartox, statar, statcanR, statgenGWAS, statgenIBD, statgenMPP, statgenQTLxT, stdReg, stenR, stm, stochvolTMB, stopdetection, stplanr, stppSim, strvalidator, subscreen, suncalc, superml, survMisc, surveyplanning, surveysd, sweater, symphony, synr, synthACS, tRophicPosition, table.express, tableMatrix, tabledown, tabulator, takos, targeted, targets, taskscheduleR, tatoo, taxize, taxonomizr, tbma, tcgaViz, tcpl, tcsinvest, tdsc, teachingApps, telemac, text2vec, textTinyR, textclean, textplot, textrank, textshape, tidyfast, tidyfst, tidyft, tidygapminder, tidytable, tidyterra, tidytransit, tidyvpc, timeseriesdb, toolStability, topdowntimeratio, tosca, totalcensus, tracee, trackdf, trackter, tradestatistics, traits, transport, traveltimeR, treedata.table, treediff, treemap, triact, trimmer, tsbox, tstools, twang, twopartm, txshift, uavRmp, udpipe, ugatsdb, ukbnmr, ukbtools, uptasticsearch, utilsIPEA, utr.annotation, validata, vardpoor, vein, vimp, visualpred, vivainsights, vosonSML, vote, votesys, wTO, wally, webtrackR, wehoop, whSample, wiad, wikitaxa, wilson, worrms, wpa, wpp2017, wpp2019, wyz.code.metaTesting, wyz.code.offensiveProgramming, wyz.code.rdoc, wyz.code.testthat, xQTLbiolinks, xROI, xVA, xefun, xesreadR, xgb2sql, xgboost, youngSwimmers, zebu, zeitgebr, zoomGroupStats.