tidyr: Tidy Messy Data

Tools to help to create tidy data, where each column is a variable, each row is an observation, and each cell contains a single value. 'tidyr' contains tools for changing the shape (pivoting) and hierarchy (nesting and 'unnesting') of a dataset, turning deeply nested lists into rectangular data frames ('rectangling'), and extracting values out of string columns. It also includes tools for working with missing values (both implicit and explicit).

Version: 1.1.4
Depends: R (≥ 3.1)
Imports: dplyr (≥ 0.8.2), ellipsis (≥ 0.1.0), glue, lifecycle, magrittr, purrr, rlang, tibble (≥ 2.1.1), tidyselect (≥ 1.1.0), utils, vctrs (≥ 0.3.6)
LinkingTo: cpp11 (≥ 0.2.6)
Suggests: covr, data.table, jsonlite, knitr, readr, repurrrsive (≥ 1.0.0), rmarkdown, testthat (≥ 3.0.0)
Published: 2021-09-27
Author: Hadley Wickham [aut, cre], RStudio [cph]
Maintainer: Hadley Wickham <hadley at rstudio.com>
BugReports: https://github.com/tidyverse/tidyr/issues
License: MIT + file LICENSE
URL: https://tidyr.tidyverse.org, https://github.com/tidyverse/tidyr
NeedsCompilation: yes
SystemRequirements: C++11
Materials: README NEWS
CRAN checks: tidyr results

Downloads:

Reference manual: tidyr.pdf
Vignettes: Usage and migration
nest
Pivoting
Programming with tidyr
rectangling
Tidy data
Package source: tidyr_1.1.4.tar.gz
Windows binaries: r-devel: tidyr_1.1.3.zip, r-devel-UCRT: tidyr_1.1.3.zip, r-release: tidyr_1.1.3.zip, r-oldrel: tidyr_1.1.3.zip
macOS binaries: r-release (arm64): tidyr_1.1.3.tgz, r-release (x86_64): tidyr_1.1.3.tgz, r-oldrel: tidyr_1.1.3.tgz
Old sources: tidyr archive

Reverse dependencies:

Reverse depends: BgeeDB, biclustermd, bunching, diathor, geotoolsR, ggmcmc, HPAStainR, inti, mnreadR, nmarank, plantecowrap, radiant.data, Riex, Rtpca, sfc, shinySIR, SummarizedBenchmark, TPP, ushr
Reverse imports: abjutils, abstr, academictwitteR, ActFrag, activPAL, actogrammr, adepro, adheRenceRX, adobeanalyticsr, adventr, AeRobiology, afdx, AHM, ahpsurvey, aire.zmvm, AirSensor, airt, alakazam, alfred, allestimates, alookr, alphavantager, ALPS, AlpsNMR, amanida, AMPLE, amt, andurinha, animaltracker, anipaths, anomalize, AnVIL, aoristic, APAlyzer, applicable, archiveRetriever, arcos, arcpullr, arena2r, ARPALData, artMS, arulesViz, ASpli, auctestr, auk, autoharp, autoMrP, autonomics, autoTS, AvInertia, baguette, banter, barcodetrackR, basecallQC, BasketballAnalyzeR, BatchGetSymbols, BAwiR, bayesammi, bayesbr, BayesianLaterality, BayesianReasoning, BayesMallows, bayesmove, bayesnec, BayesPostEst, baystability, bdl, beadplexr, BENMMI, bestSDP, bibliometrix, biclust, BifactorIndicesCalculator, bigPint, bigtime, biobroom, BiocPkgTools, BiocSet, biogrowth, biokNN, biomod2, bioOED, bioRad, bioset, bipartiteD3, BIS, biscale, bkmr, BMisc, BMTME, bnmonitor, BNPdensity, BOJ, bootnet, bp, bpcs, BrazilMet, breathtestcore, breathteststan, brendaDb, brickr, bridger, brokenstick, brolgar, broom, broom.helpers, broom.mixed, bumbl, bupaR, burnr, BUSpaRse, BVARverse, bwsTools, caffsim, capm, card, carpenter, casen, casino, cassandRa, cat2cat, catlearn, causact, CausalGPS, CB2, cBioPortalData, cdom, CellaRepertorium, cellbaseR, CellBench, CellMixS, censcyt, ceRNAnetsim, ceRtainty, CGPfunctions, ChangePointTaylor, cheese, childsds, choroplethr, ChromSCape, chromswitch, chronochrt, cicero, CIMICE, cimir, CIMTx, circumplex, cjbart, CKMRpop, climaemet, clinDR, clockify, clustermole, clusterPower, clusterProfiler, clustifyr, ClustImpute, CNVScope, coalitions, cocktailApp, COCOA, codebook, codified, cogena, cogmapr, CohortPlat, cohorts, COINr, colorist, combiroc, compareDF, COMPASS, comperes, composits, ComPrAn, compstatr, concordance, concurve, confoundr, ConfusionTableR, contribution, convdistr, convergEU, corporaexplorer, correlationfunnel, countsimQC, countyfloods, coveffectsplot, COVID19, covid19br, covid19france, covid19india, covid19us, covidcast, covidregionaldata, coxed, cpr, cpss, crimeutils, cropDemand, cropZoning, crosstable, crypto2, cuperdec, curatedMetagenomicData, cutpointr, cvms, CytoGLMM, cytominer, czechrates, d3r, dabestr, DAMisc, DAPAR, daqapo, dartR, dasper, data.validator, datadogr, dataframeexplorer, dataspice, datazoom.amazonia, datos, daymetr, dbglm, DCLEAR, DCPO, deaR, decisionSupport, decoupleR, DEGreport, DEP, depigner, describedata, descriptr, descstat, devtoolbox, dexter, dextergui, dexterMST, dfoliatR, DGEobj.utils, DiagrammeR, DIAlignR, diceR, did2s, diffcyt, diseq, DisImpact, disto, distrr, div, dlookr, dm, dmai, DMCfun, dmtools, DNABarcodeCompatibility, do, docxtools, dowser, dplyrAssist, dragon, drawProteins, dreamer, drifter, dscore, DSSAT, dumbbell, Dune, DuoClustering2018, dycdtools, dynfeature, dyngen, dynparam, dynplot, dynwrap, easyalluvial, eatRep, ebirdst, ec50estimator, ech, echor, ecocomDP, edeaR, eechidna, EFAtools, EFDR, egor, eiCompare, EIX, elaborator, ELMER, emayili, emba, embed, emuR, engsoccerdata, ENMeval, eph, epidata, epifitter, epikit, EpiReport, epocakir, epubr, ERSA, esaps, escalation, ESTER, esvis, eudract, eurlex, europepmc, eurostat, evaluator, EventStudy, ExcelFunctionsR, excelstrippr, ExPanDaR, explor, explore, ExploreModelMatrix, extdplyr, extRatum, exuber, eye, eyeRead, eyetrackingR, ezEDA, ezmmek, ezpickr, fable, fabletools, factoextra, famat, fasstr, fastqcr, fbar, fdapaceShiny, feasts, fedregs, ferrn, ffp, ffscrapr, fgeo.analyze, file2meco, finalfit, finetune, fipe, fishflux, fishualize, fitbitr, fitzRoy, fixerapi, flametree, flashlight, flattabler, flexsurv, flipbookr, FlowSOM, fmpcloudr, fmriqa, fobitools, foieGras, FoldGO, foodingraph, forecastML, forestecology, forestinventory, forestmangr, forestr, FORTLS, fpp3, frenchdata, frostr, FSinR, FSK2R, ftExtra, funcharts, functiondepends, funneljoin, fusen, futureheatwaves, fuzzyjoin, GA4GHshiny, galigor, galvanizer, gapclosing, garchmodels, geckor, gen5helper, genekitr, geneticae, GeneTonic, genius, genogeographer, geodimension, geomander, GEOquery, geoviz, GerminaR, gesttools, GetDFPData2, GetTDData, gfer, ggalluvial, GGally, ggasym, ggbump, ggcleveland, ggedit, ggfortify, ggheatmap, ggHoriPlot, ggip, ggiraphExtra, gglogo, ggmap, ggmosaic, ggmulti, ggpacman, ggPMX, ggpubr, ggQC, ggquickeda, ggRandomForests, ggseg, ggseg3d, ggsolvencyii, ggsom, ggspatial, ggspectra, ggstatsplot, ggstream, ggtree, GillespieSSA2, gitdown, gitear, GladiaTOX, glancedata, gluvarpro, glycanr, gmgm, gMOIP, googleAnalyticsR, googlesheets, gprofiler2, granulator, graph4lg, graphTweets, gratia, gravitas, gravity, gregRy, grizbayr, groupdata2, groupr, gsDesign, gtsummary, gwaRs, gwdegree, GWENA, HaDeX, hansard, happybiRthday, harmony, harrietr, hca, hddtools, hdpGLM, healthcareai, healthyR, healthyR.ai, healthyR.ts, heuristicsmineR, HiCDCPlus, highcharter, HiLDA, himach, hlaR, hockeyR, hockeystick, hot.deck, HS, htmldf, HTSSIP, HuraultMisc, hurricaneexposure, i2extras, iadf, IBCF.MTME, IBMPopSim, ICD10gm, iCNV, ICSKAT, IDE, ideamdb, idiogramFISH, idmodelr, iglu, ihpdr, IMD, immunotation, IMP, implicitMeasures, imputeTestbench, incidence2, industRial, infer, infercnv, Inflect, influxdbr, InjurySeverityScore, insane, inspectdf, insurancerating, intensegRid, InterCellar, inventorize, iNZightTools, iNZightTS, IONiseR, iotables, ipfr, ipmisc, IPWpn, irtplay, ISAnalytics, isomiRs, isoreader, isotracer, ISRaD, itraxR, jackstrap, janitor, jrt, karel, kayadata, keyATM, kibior, KMunicate, kntnr, konfound, labelled, LAGOSNE, lans2r, lares, LBSPR, lcsm, LDAShiny, ledger, LexisPlotR, LifeInsuranceContracts, lifelogr, lillies, lineartestr, linkspotter, lipidomeR, lipidr, lisaClust, litteR, loewesadditivity, longitudinalcascade, lookout, malariaAtlas, mapbayr, mapboxapi, MarketMatching, marketr, mason, matman, MatrixQCvis, matsindf, matuR, mboxr, mcStats, mde, meerva, meltt, mem, memapp, memes, memoria, MesKit, metabCombiner, metabolic, MetabolicSurv, MetaCyto, metagam, metajam, metamicrobiomeR, metan, MetaNeighbor, metaplot, metapower, MetaUtility, MetaVolcanoR, MethReg, MetNet, metools, mia, miaViz, mice, miceFast, microbial, microbiome, microbiomeExplorer, MicrobiotaProcess, microhaplot, MicroSEC, migest, migraph, migrate, miloR, MIMOSA, mipplot, miRetrieve, missCompare, mistyR, mitre, miWQS, mixOmics, mixtur, mlbstatsR, MMAPPR2, MMUPHin, mobr, modelr, modeltime, modeltime.ensemble, modeltime.gluonts, modeltime.h2o, modeltime.resample, MOFA2, mojson, molnet, MOMA, monoClust, morse, MortalityLaws, mosaic, mosaicCore, mosaicModel, MOSim, mousetrap, mplot, mpoly, MPTmultiverse, MQmetrics, mrf2d, mrgsim.sa, mshap, MSiP, MSPrep, msSPChelpR, mtconnectR, mudata2, MultiAssayExperiment, multicolor, multicrispr, multimorbidity, multinma, multiverse, musicatk, MutationalPatterns, NACHO, naniar, NanoMethViz, NBAloveR, nbTransmission, ncappc, ncmeta, ndexr, neo4r, neonUtilities, nettskjemar, NetworkChange, NetworkExtinction, NeuralNetTools, neuromplex, nevada, newsanchor, nfl4th, nflfastR, nflseedR, NFP, ngramr, ngsReports, nhdplusTools, NIMAA, nlrx, nls.multstart, nmm, NMproject, noaastormevents, nonmemica, NoRCE, NPARC, nullabor, obliqueRSF, occCite, oddstream, odeGUTS, ojsr, OMICsPCA, omicwas, OmnipathR, omu, OncoBayes2, oncrawlR, onemapsgapi, onlineFDR, OOS, openair, opencage, OpenLand, OpenRepGrid.ic, opitools, optimLanduse, OutliersO3, outreg, owmr, oxcgrt, oysteR, packagefinder, packDAMipd, palaeoSig, pammtools, PAMpal, PandemicLP, parcats, parsermd, parsnip, partition, partR2, passt, PathoStat, paths, pathviewr, pcaExplorer, pdi, peacesciencer, penppml, performanceEstimation, perturbatr, pestr, PFP, pguIMP, ph2rand, PHEindicatormethods, phenofit, phenopath, Phenotype, PheVis, philr, PhosR, photobiology, photobiologyInOut, phyr, Pi, PKNCA, places, PLNmodels, plot3logit, plotdap, plotGrouper, plotly, plsmod, pmc, pmdplyr, pmetar, pointblank, poissonreg, polished, pollster, POMA, pomcheckr, portalr, postGGIR, povcalnetR, powdR, ppcseq, ppcSpatial, PPforest, ppitables, ppseq, prcr, precisely, predict3d, preference, prettyglm, prider, primer, primirTSS, PrInCE, prisonbrief, proBatch, processanimateR, processmapR, processR, profileplyr, progeny, prophet, protti, proustr, psborrow, psfmi, psr, psychmeta, psychonetrics, psycModel, psyntur, puls, PupillometryR, PupilPre, PVplr, PWFSLSmoke, pwr2ppl, qdap, qPLEXanalyzer, qpNCA, qsub, qtl2ggplot, qtl2pattern, qualtRics, quantable, quantiseqr, queuecomputer, quokar, r2dii.analysis, r2dii.match, R6P, rabhit, rADA, RadialVisGadgets, radiant.basics, radiant.model, rainette, ralger, rappsflyer, rapsimng, rATTAINS, rattle, ravelRy, RavenR, rawKS, rbedrock, rbenvo, RClimacell, RCT, Rcurvep, rdflib, readabs, readrba, receptLoss, recipes, recodeflow, redcapAPI, REDCapR, regexTestR, regions, registr, regrrr, reliabilitydiag, reproducer, retroharmonize, reveneraR, RevGadgets, ReviewR, revulyticsR, rfacebookstat, rFIA, rfieldclimate, RFishBC, rfm, rfPermute, rFSA, rgho, rgoogleads, ribor, RIdeogram, Rilostat, riskCommunicator, rKolada, RKorAPClient, rmapzen, RmarineHeatWaves, rmdcev, rmytarget, RNeXML, rnoaa, Rnumerai, roadoi, robCompositions, robomit, robvis, roclang, roistats, romic, ropercenter, rPACI, rprev, rRofex, rsample, rsbp, rscopus, rscorecard, rsppfp, RSSL, rstanemax, rstatix, rticulate, RTL, rtrek, rtrends, rtsVis, RtutoR, rtypeform, rubias, ruler, rules, rusk, RVA, rvkstat, rwa, rwalkr, RWDataPlyr, rWikiPathways, ryandexdirect, sabre, sampler, sapfluxnetr, saqgetr, sbo, scatterpie, schrute, scipub, scoper, SCORPIUS, sdStaf, SEAA, secrettext, secuTrialR, seeds, SEERaBomb, sejmRP, semtree, sendgridr, seplyr, seqCAT, sfcr, sGMRFmix, sgstar, shazam, SHELF, ShellChron, shinyepico, ShinyItemAnalysis, shinyML, shinyobjects, shinyrecipes, ShinyTester, ShortForm, shorts, SIBER, siconfir, sift, sigminer, Signac, SimBIID, simhelpers, simmer.plot, simplevis, SimplyAgree, simrel, simTool, simts, SingleCaseES, singscore, sismonr, sitar, sjPlot, sjstats, skimr, sknifedatar, slinky, SMAD, smog, SNPassoc, sobir, soc.ca, sociome, sovereign, SpaCCr, sparklyr, SPARTAAS, SpatialCPie, spatialRF, spatialTIME, spatPomp, specr, speech, SpiceFP, spicyR, splithalf, spotifyr, squashinformr, srvyr, ssimparser, ssrn, stabiliser, stability, stacks, staggered, staRdom, starschemar, starvz, stationaRy, statnipokladna, statsExpressions, statsr, strand, strm, STRMPS, studentlife, subSeq, suddengains, sugarbag, summarytools, Superpower, supersigs, supraHex, surveydata, survivalAnalysis, survivoR, survminer, survParamSim, survtmle, sweep, swfscAirDAS, swfscDAS, swfscMisc, swimplot, swissdd, swissparl, swmmr, SWMPr, SWMPrExtension, SWTools, syllabifyr, symphony, synergyfinder, synoptReg, SynthCast, syuzhet, tablet, tabr, tabshiftr, tabulator, tabxplor, TADCompare, TAPseq, taxa, tbrf, TCGAbiolinks, TCIU, teamcolors, telemac, Temporal, TestDimorph, TestGardener, tetraclasse, text, texter, TextForecast, TextMiningGUI, textrecipes, textreuse, tfestimators, thinkr, threesixtygiving, thurstonianIRT, tidybayes, tidyboot, tidybulk, tidycat, tidycensus, tidycomm, tidygapminder, tidygate, tidygenomics, tidygraph, tidyHeatmap, tidyhydat, tidyjson, tidylda, tidylog, tidyMicro, tidymodels, tidymv, tidync, tidyndr, tidypaleo, tidyposterior, tidypredict, tidyquant, tidyqwi, tidyREDCap, tidyseurat, tidySingleCellExperiment, tidystats, tidySummarizedExperiment, tidysynth, tidytidbits, tidytransit, tidytreatment, tidytree, tidyverse, tidywikidatar, tigger, timeOmics, TimeSeriesExperiment, timetk, TimiRGeN, TissueEnrich, tongfen, tosr, toxEval, ToxicoGx, Tplyr, TPP2D, track2KBA, tradepolicy, trainR, transcriptogramer, treeheatr, treekoR, trelliscopejs, trendeval, TriDimRegression, truthiness, TSstudio, tune, twoxtwo, UCSCXenaShiny, ukbtools, understandBPMN, unheadr, unpivotr, unstruwwel, unusualprofile, usdampr, usemodels, utr.annotation, uwo4419, valhallr, varitas, varsExplore, viafr, vici, vidger, virtualPollen, visae, visdat, visR, visvow, vivid, vizdraws, vlad, voson.tcn, votesmart, vpc, vprr, VWPre, WASP, waves, wbstats, wcde, wcep, webr, weed, weibulltools, whoa, widyr, wikilake, wildviz, WoodSimulatR, wordbankr, workflowsets, worldmet, wpa, wppi, wrangle, wrappedtools, WRTDStidal, wyz.code.metaTesting, wyz.code.offensiveProgramming, wyz.code.rdoc, wyz.code.testthat, xesreadR, xml2relational, xmrr, XPolaris, xpose, xpose.nlmixr, xspliner, yamlet, zdeskR, zFPKM, zipcodeR
Reverse suggests: admixr, adoptr, afex, altair, AMR, analyzer, APAtree, ARTool, avocado, AzureKusto, baseballDBR, bayestestR, beezdemand, bench, benthos, bggum, bib2df, BiplotML, bisect, BloodCancerMultiOmics2017, BMRSr, bpbounds, bruceR, BSDA, bsem, cancensus, cansim, canvasXpress, canvasXpress.data, causaldrf, CellNOptR, climate, clustifyrdatahub, cmstatr, colorDF, condiments, CONSTANd, contrast, correlation, covid19swiss, cowplot, crawl, cSEM, curatedAdipoChIP, curatedAdipoRNA, cvequality, cxr, cyanoFilter, DAISIE, datafsm, datawizard, dbplot, dbplyr, dcurves, ddiv, decoder, DeepBlueR, depmap, derivmkts, detrendr, dimRed, dirichletprocess, dispositionEffect, dlstats, DOPE, dorothea, doseminer, dplyr, dragracer, DriveML, DSjobtracker, DTAT, dtplyr, eatGADS, echarts4r, ecoCopula, ecotox, edgarWebR, eemR, eesim, effectsize, eia, enrichplot, EpiNow2, epiphy, era, ethnobotanyR, europop, eyelinker, ezplot, fastR2, faux, fauxnaif, fedup, fgeo.tool, finbif, fishdata, fivethirtyeight, flagr, forestplot, forwards, fourierin, FunnelPlotR, GADMTools, ganalytics, geodiv, geofi, GeoTcgaData, ggcharts, ggdist, ggfan, ggformula, ggparliament, ggprism, ggside, ggthemes, ggVennDiagram, ggwordcloud, GLMcat, googleLanguageR, greed, GSODR, gt, gutenbergr, hacksaw, hal9001, hdme, heatwaveR, heddlr, hilbertSimilarity, hkdatasets, HMP16SData, htmltab, htmlTable, hutils, idbr, IHWpaper, iNZightPlots, JacobiEigen, journalabbr, junctions, Lahman, linguisticsdown, lmeInfo, localIV, lognorm, loon.ggplot, madness, MANOVA.RM, MARSS, matsbyname, meshed, metabolighteR, metaboliteIDmapping, methylCC, midasHLA, mifa, mikropml, minidown, mixdir, mixpoissonreg, mlr, modcmfitr, MODIStsp, mortAAR, mosaicData, MSEtool, multifear, namedCapture, nandb, nc, nCov2019, NHSRdatasets, nlmixr, nntrf, nomisr, nzelect, ohenery, openEBGM, openintro, oppr, outcomerate, padr, palmerpenguins, panelr, parSim, passport, patentsview, pbixr, perccalc, permutes, phonfieldwork, photosynthesis, physiology, pixarfilms, planet, PolicyPortfolios, pollen, pomp, posterior, prevtoinc, ProbReco, proDA, projmgr, purgeR, qicharts2, qualvar, quantities, questionr, r2rtf, radarchart, Radviz, raw, RBesT, readsdr, rearrr, REddyProc, reporter, reval, rlc, rmonad, robber, robservable, rODE, rpmodel, rsetse, rsinaica, rsprite2, rtables, RTCGA, rtdists, RxODE, salem, SCtools, sdmApp, see, seer, segmentr, selectKSigs, sesame, sf, sfo, SimDesign, SimEngine, simglm, simITS, simstandard, sjmisc, spanish, sparseMVN, spatialsample, SplicingFactory, ssdtools, stars, stats19, sugrrants, sunburstR, supernova, switchde, systemPipeShiny, table.glue, tabnet, tauturri, teachingApps, tealeaves, texmex, textmineR, TFEA.ChIP, tibble, tibbletime, tictactoe, tidyfast, tidyfst, TidyMultiqc, tidytext, tidyxl, tilegramsR, tinyarray, tmap, topconfects, tourr, traipse, treasuryTR, treeio, trialr, troopdata, truelies, tsfeatures, tsibble, tvgeom, UMI4Cats, unjoin, unnest, unvotes, usdarnass, usedist, USgrid, vacuum, valr, VancouvR, vcfR, vinereg, volleystat, vosonSML, vroom, WDI, windsoraiR, workloopR, wrswoR, xgxr, yardstick, yowie, ypr, ztpln

Linking:

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