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.

Version: 1.13.0
Depends: R (≥ 3.1.0)
Imports: methods
Suggests: bit64, curl, R.utils, xts, nanotime, zoo, yaml, knitr, rmarkdown
Published: 2020-07-24
Author: 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]
Maintainer: Matt Dowle <mattjdowle at gmail.com>
BugReports: https://github.com/Rdatatable/data.table/issues
License: MPL-2.0 | file LICENSE
URL: http://r-datatable.com, https://Rdatatable.gitlab.io/data.table, https://github.com/Rdatatable/data.table
NeedsCompilation: yes
SystemRequirements: zlib
Materials: NEWS
In views: Finance, HighPerformanceComputing, TimeSeries
CRAN checks: data.table results

Downloads:

Reference manual: data.table.pdf
Vignettes: Benchmarking data.table
Frequently asked questions
Importing data.table
Introduction to data.table
Keys and fast binary search based subset
Reference semantics
Efficient reshaping using data.tables
Using .SD for Data Analysis
Secondary indices and auto indexing
Package source: data.table_1.13.0.tar.gz
Windows binaries: r-devel: data.table_1.13.0.zip, r-release: data.table_1.13.0.zip, r-oldrel: data.table_1.13.0.zip
macOS binaries: r-release: data.table_1.13.0.tgz, r-oldrel: data.table_1.12.8.tgz
Old sources: data.table archive

Reverse dependencies:

Reverse depends: Ac3net, AF, amplican, bea.R, behavr, birankr, cdparcoord, Chicago, chicane, chimeraviz, classifierplots, CoSMoS, cvAUC, damr, dfmeta, easycsv, edgeRun, EurosarcBayes, eyeTrackR, FeatureImpCluster, FOCI, fplot, fplyr, FRASER, gbp, gdxdt, GenoGAM, GenomicTools, GenomicTools.fileHandler, GenoScan, GGtools, GladiaTOX, glmaag, GOTHiC, haploReconstruct, hdd, heims, HMMcopy, HPLB, immunarch, intervalaverage, lookupTable, lori, LSPFP, metaforest, metavizr, methrix, microseq, miLineage, multicastR, musica, nlpred, nosoi, openSTARS, orgR, OUTRIDER, panelaggregation, partools, PGA, phenocamapi, pkggraph, precautionary, QuantTools, QuartPAC, rasterDT, rBiopaxParser, Rbitcoin, rblt, RCAS, RegParallel, reinsureR, rfPred, robCompositions, RSauceLabs, rTANDEM, RWildbook, shinyML, simPop, sitreeE, skm, slim, SNPhood, tidyvpc, TIN, ttwa, Tushare, twl, validateRS, WGScan, word.alignment
Reverse imports: ABAEnrichment, actel, ActivePathways, ADAMgui, adductomicsR, AdhereR, AdhereRViz, AeRobiology, AFM, AGread, akc, ALA4R, aLFQ, alpaca, AlphaBeta, ALPS, antaresEditObject, antaresProcessing, antaresRead, antaresViz, APSIM, artMS, ARTP2, asciiSetupReader, assertable, atSNP, AUCell, BaMORC, BANDITS, BARIS, basecallQC, BatchExperiments, BatchJobs, batchtools, bayesLife, BayesLN, bayesPop, bbotk, bdchecks, bdclean, BEARscc, BEclear, bedr, benford.analysis, BgeeDB, bife, bigreadr, bigsnpr, binomialRF, biomartr, BIOMASS, bioRad, BIRDS, biscuiteer, blorr, bnbc, bold, bomrang, BootstrapQTL, BPRMeth, brainGraph, branchpointer, brandwatchR, bridger2, bsseq, BTSPAS, BTYDplus, bupaR, BuyseTest, c14bazAAR, c3, CAGEr, CALF, CamelUp, camtrapR, caretEnsemble, casebase, CATALYST, categoryEncodings, CatEncoders, ccafs, ccmap, ccostr, cde, celda, cellbaseR, CEMiTool, Census2016, cffdrs, cglm, ChannelAttributionApp, ChIPexoQual, chromer, cicero, citecorp, cleanerR, clickstream, CluMP, clustcurv, Clustering, CLVTools, cmapR, CNVRanger, CNVScope, COCOA, CoDiNA, coinmarketcapr, coloc, colorednoise, comorbidity, CompareCausalNetworks, COMPASS, CONFESS, consensusDE, ConsReg, constellation, contact, contextual, contiBAIT, CopywriteR, coRdon, CornerstoneR, CorporaCoCo, corporaexplorer, corpustools, corrcoverage, corregp, coveffectsplot, cppRouting, creditmodel, crfsuite, CRISPRseek, CropScapeR, CrossICC, crossmeta, csa, CSMES, CSTools, csv, csvy, ctmm, cTRAP, ctsem, cusum, cvms, cwbtools, CytoML, D3partitionR, dartR, dat, data360r, DataCombine, DataExplorer, dataframeexplorer, datagovsgR, dataPreparation, DataSpaceR, dblr, dbnR, DCD, decompTumor2Sig, DeepBlueR, deepdive, DEFormats, delayed, DEScan2, detectRUNS, DEWSeq, dfConn, DGM, Diderot, difconet, diffloop, diffman, DiffNet, DiscoRhythm, discSurv, disk.frame, distantia, distr6, DIZutils, DMCFB, do, DominoEffect, doremi, drgee, DriveML, droptest, DTAT, dtplyr, DTSg, dtwSat, durmod, dvmisc, DysPIA, E4tools, Eagle, easyr, ebirdst, eclust, edeaR, EdSurvey, eeptools, EIX, electionsBR, EmissV, ENCODExplorer, ENCODExplorerData, endoSwitch, ensr, enviGCMS, eoR, Epi, epihet, eplusr, epuR, epwshiftr, EthSEQ, etm, EventStudy, evoper, expss, FAOSTAT, farrell, fastDummies, fastLink, fbRads, fcoex, fdq, FedData, Fgmutils, fgsea, fhidata, finch, fishmethods, FitHiC, flextable, florestal, flowWorkspace, forecastML, forestError, formulaic, fsbrain, fulltext, funchir, futureheatwaves, fxtract, fy, GAPGOM, gasfluxes, gcite, GCSscore, gems, genBart, GeneGeneInteR, geneplast, GENESIS, GeneStructureTools, geneXtendeR, genomation, genomic.autocorr, GenomicInteractions, GenomicTuples, GenVisR, GeoMongo, GeoTcgaData, germinationmetrics, getCRUCLdata, getlandsat, getProxy, getTBinR, GFE, gfer, gfoRmula, ggcyto, ggdmc, ggetho, GGIR, ggperiodic, ggPMX, ggpval, ggsom, ggTimeSeries, GISPA, githubinstall, GmicR, gofastr, googleCloudVisionR, gpart, grattan, greport, GSALightning, GSODR, gtfs2gps, gtfsrouter, GUIDEseq, gunsales, GWASinspector, gwsem, HaDeX, hagis, haldensify, happybiRthday, hBayesDM, HCD, HCR, healthcareai, heatwaveR, hereR, hesim, heuristicsmineR, HiCBricks, HiCcompare, highfrequency, hilldiv, hisse, Hmisc, HMP2Data, hoardeR, hR, HRM, HS, hsrecombi, httk, hurricaneexposure, hutils, hutilscpp, hydroPSO, hyfo, hypervolume, ICAMS, iCellR, iCNV, IDmining, ie2misc, iemisc, iGC, iml, immuneSIM, ImmuneSpaceR, importinegi, inbreedR, IncDTW, Information, InformationValue, inlmisc, insurancerating, IntClust, inTrees, IOHanalyzer, iRF, irg, IrregLong, isdparser, iSTATS, ITGM, ivdoctr, ivtools, joinXL, JSmediation, jsmodule, jstable, jsTree, jubilee, JWileymisc, kangar00, kerastuneR, KinSwingR, koRpus, LabourMarketAreas, labourR, lar, lcsm, ldamatch, ldaPrototype, ldsr, leafR, lexicon, LexisNexisTools, lidR, LilRhino, LinkHD, lipidr, live, livechatR, lllcrc, loci2path, logiBin, LogisticDx, LOLA, LOPART, LowMACA, Luminescence, LymphoSeq, Maaslin2, maditr, maftools, MAGeCKFlute, MANOVA.RM, mapi, mapr, margins, marked, MarketMatching, maser, MAST, matman, mau, Melissa, memisc, MetaComp, metagene, metagene2, MetaIntegrator, metaMix, MetaVolcanoR, methimpute, methylKit, MethylMix, methylPipe, metR, miceFast, miceRanger, microdemic, MIGSA, mimi, MIMOSA, mindicador, minfi, MinimumDistance, MIRA, miscset, mknapsack, mlr, mlr3, mlr3db, mlr3filters, mlr3learners, mlr3misc, mlr3pipelines, mlr3proba, mlr3shiny, mlr3tuning, mlr3viz, mlrMBO, mltools, MMAPPR2, mmaqshiny, mmpf, mnem, ModelMetrics, MODIStsp, MplusAutomation, mregions, mrMLM, mrMLM.GUI, mschart, msmtools, MSnID, MSstats, MSstatsTMT, mstrio, mtconnectR, multdyn, MultiFit, multiHiCcompare, multilevelTools, muscat, mvQuad, naaccr, nc, ndjson, neatRanges, neo4r, neonUtilities, netboxr, NetLogoR, netSmooth, networkR, NNS, noaastormevents, noctua, nodbi, noncompliance, obliqueRSF, olsrr, OmicsMarkeR, OMICsPCA, omicwas, ompr, Onassis, OncoSimulR, openCyto, openEBGM, OpenML, optiRum, optiSel, ORFik, origami, originr, otvPlots, owdbr, packageRank, PakPMICS2014Ch, PakPMICS2014HH, PakPMICS2014HL, PakPMICS2014Wm, PanelMatch, panelWranglR, paradox, ParBayesianOptimization, partialAR, partialCI, pathVar, patternator, pcadapt, PCMBase, PCMBaseCpp, pdynmc, PeakSegDisk, pedquant, penaltyLearning, pepr, pepStat, petro.One, PGRdup, phenofit, PhenotypeSimulator, phm, phonics, PhyloProfile, phyloseq, pingers, pinnacle.API, pinyin, pivottabler, pkgnet, pksensi, plethem, plinkQC, plotly, pmpp, pointdensityP, poisFErobust, politeness, polmineR, pooling, popEpi, PopGenReport, POUMM, PowerExplorer, pram, PrecisionTrialDrawer, precrec, prediction, PReMiuM, preputils, prioritizr, prisonbrief, proBatch, processmapR, ProFound, promotionImpact, PROSPER, Prostar, prrd, PSF, psichomics, psidR, psychmeta, PTXQC, pubchunks, Publish, PupillometryR, PureCN, Pviz, pwOmics, qad, qckitfastq, qdapTools, qgg, QTL.gCIMapping, QTL.gCIMapping.GUI, qtl2, quanteda, quickPlot, R2DT, r2glmm, R3CPET, r3Cseq, R62S3, rabhit, radlibs, RAM, rAmCharts, randomForestExplainer, randomNames, rangeMapper, RAPIDR, rasterly, RAthena, ratios, RBaseX, rBayesianOptimization, rbi, rbi.helpers, rBiasCorrection, rbin, rbison, RBMRB, Rborist, rbraries, rbtt, Rcan, RcextTools, RcisTarget, RcisTarget.hg19.motifDBs.cisbpOnly.500bp, RcppGreedySetCover, Rcrawler, rdbnomics, rdfp, Rdice, RDML, readtext, recorder, RecordLinkage, REDCapExporter, regexTestR, ReinforcementLearning, rENA, REndo, repmis, reproducible, rerddap, rescue, restatapi, rfaRm, rFIA, rfisheries, rgbif, rGEDI, RGMQL, rGoodData, RiboProfiling, rif, Rilostat, RImmPort, rio, rIsing, riskRegression, ritis, rlas, rlist, RLumShiny, rmcfs, RNewsflow, rnoaa, rnpn, Robocoap, rODE, rolypoly, rorcid, rPackedBar, rprev, rpubchem, rqdatatable, rsnps, rSPARCS, rsparse, rsyntax, RTCGA, RTCGAToolbox, rtmpt, RTN, RTNsurvival, rTorch, rtsdata, RWDataPlyr, rWikiPathways, RxnSim, ryandexdirect, RZooRoH, sanityTracker, sarp.snowprofile, sbpiper, scDblFinder, scidb, SCnorm, scoper, scopr, scorecard, scoringutils, scraEP, scrubr, scruff, sdcHierarchies, sdcMicro, sdcTable, SDLfilter, SEA, segregation, selac, SELF, sen2r, sensobol, sentimentr, sentometrics, seqsetvis, servosphereR, SEtools, SetRank, sevenbridges, sevenC, SGP, SGPdata, SHAPforxgboost, ShinyItemAnalysis, shinylogs, sigminer, Signac, signatureSearch, simPH, simplePHENOTYPES, simstudy, SingleCellSignalR, singleCellTK, SISPA, siteymlgen, sitree, skynet, sleepr, SmartEDA, snapcount, socialmixr, SoilHyP, solitude, spacyr, SpaDES.core, SpaDES.tools, sparseFLMM, SparseSignatures, SpatialCPie, SpATS, spatsoc, speaq, spectralAnalysis, spellcheckr, splitstackshape, spocc, SPONGE, sport, spread, squid, SSHAARP, sstModel, staRdom, starvars, statar, statcanR, statgenGWAS, StatMeasures, stdReg, steemr, stm, strataG, strvalidator, stUPscales, subscreen, subSeq, SUMMER, suncalc, SunsVoc, superml, surveyplanning, surveysd, survMisc, SVN, SWATH2stats, SWMPr, synthACS, table.express, tableMatrix, takos, taskscheduleR, tatoo, taxize, taxonomizr, tbma, TCA, TCGAbiolinks, TCGAbiolinksGUI, tcpl, tcR, tdsc, teachingApps, TeXCheckR, text2vec, textclean, textplot, textrank, textreadr, textshape, textTinyR, TideCurves, TideTables, tidyfast, tidyfst, tidyft, tidygapminder, tidytable, tidytransit, timeseriesdb, TitanCNA, TnT, tosca, totalcensus, TPP, trackdf, tradestatistics, TrafficBDE, traitdataform, traits, transcriptogramer, transport, treemap, trimmer, tRophicPosition, tsbox, TSstudio, tstools, TSTr, TwoRegression, uavRmp, udpipe, ukbtools, UKgrid, Ularcirc, uptasticsearch, utilsIPEA, VanillaICE, vardpoor, vein, viewshed3d, VIM, viromeBrowser, ViSEAGO, vortexR, VOSONDash, vosonSML, votesys, wally, waveformlidar, wikitaxa, wilson, winRatioAnalysis, worrms, wpp2017, wpp2019, wTO, wyz.code.metaTesting, wyz.code.offensiveProgramming, wyz.code.rdoc, wyz.code.testthat, XCIR, xesreadR, xgb2sql, xgboost, xROI, yamss, zeitgebr, zFactor
Reverse suggests: analyzer, arcos, assertive.types, auk, BayesSUR, bayesTFR, bcTSNE, BEDMatrix, bfw, BGData, bigPint, bigQueryR, bigstatsr, bikeshare14, biobroom, BiocParallel, BTM, bysykkel, catcont, CellNOptR, checkmate, collapse, colorDF, covidregionaldata, dang, dataCompareR, datapackage.r, datapasta, datarobot, DeclareDesign, denvax, DGVM3D, drake, dstack, ecospace, ecotox, ELMER, envalysis, epanetReader, extdplyr, fabricatr, fixest, fst, GenomicScores, ggswissmaps, googleVis, gustave, h2o, hal9001, handlr, iemiscdata, implicitMeasures, inplace, installr, itsadug, ivmte, Lahman, LambertW, lava, lavaSearch2, leiden, lfe, lgr, LocalControl, memochange, metamer, microsamplingDesign, milr, mrgsolve, multinets, namedCapture, nanotime, nlmixr, padr, pander, parallelMap, PeakSegOptimal, phantasus, pins, pmml, PP, ProjectTemplate, propr, pspline.inference, pxweb, R.SamBada, Rblpapi, rbokeh, RcmdrPlugin.WorldFlora, rdhs, rdwd, rehh, rpivotTable, rreg, rstanarm, rtop, RTransferEntropy, ruimtehol, RxODE, S4Vectors, SACOBRA, seleniumPipes, SemNeT, SightabilityModel, Sojourn, stabm, sticky, stplanr, taRifx, TENxBrainData, TFutils, tidytext, tsdb, TSrepr, unifed, vaersNDvax, vaersvax, vtreat, wmm, WorldFlora, Xmisc, xpectr
Reverse enhances: dendextend, repr

Linking:

Please use the canonical form https://CRAN.R-project.org/package=data.table to link to this page.