{
  "_id": "6acc3466a14063b82c3a6249",
  "Package": "unpivotr",
  "Title": "Unpivot Complex and Irregular Data Layouts",
  "Version": "0.6.4",
  "Authors@R": "c(\nperson(\"Duncan\", \"Garmonsway\", email = \"nacnudus@gmail.com\", role = c(\"aut\", \"cre\"))\n)",
  "Description": "Tools for converting data from complex or irregular\nlayouts to a columnar structure.  For example, tables with\nmultilevel column or row headers, or spreadsheets.  Header and\ndata cells are selected by their contents and position, as well\nas formatting and comments where available, and are associated\nwith one other by their proximity in given directions.\nFunctions for data frames and HTML tables are provided.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "URL": "https://github.com/nacnudus/unpivotr,\nhttps://nacnudus.github.io/unpivotr/",
  "BugReports": "https://github.com/nacnudus/unpivotr/issues",
  "RoxygenNote": "7.3.2",
  "VignetteBuilder": "knitr",
  "Roxygen": "list(markdown = TRUE)",
  "Config/pak/sysreqs": "libicu-dev libxml2-dev",
  "Repository": "https://nacnudus.r-universe.dev",
  "Date/Publication": "2026-10-11 21:52:44 UTC",
  "RemoteUrl": "https://github.com/nacnudus/unpivotr",
  "RemoteRef": "HEAD",
  "RemoteSha": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-12 01:10:07 UTC",
    "User": "root"
  },
  "Author": "Duncan Garmonsway [aut, cre]",
  "Maintainer": "Duncan Garmonsway <nacnudus@gmail.com>",
  "_user": "nacnudus",
  "_type": "src",
  "_file": "unpivotr_0.6.4.tar.gz",
  "_fileid": "https://r2.ropensci.org/eda320d00ec46e2668e140219b65bb24b5df1711608855b441594b52f777ce8e",
  "_filesize": 4072376,
  "_sha256": "eda320d00ec46e2668e140219b65bb24b5df1711608855b441594b52f777ce8e",
  "_expires": "2027-01-20T01:14:11.000Z",
  "_created": "2026-10-12T01:10:07.000Z",
  "_published": "2026-10-12T01:14:14.068Z",
  "_buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 114623123759,
      "time": 199,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11720982912"
    },
    {
      "job": 114623123726,
      "time": 194,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11720854724"
    },
    {
      "job": 114623123747,
      "time": 102,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11721697511"
    },
    {
      "job": 114623123701,
      "time": 113,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11721017711"
    },
    {
      "job": 114622324882,
      "time": 242,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11721657524"
    },
    {
      "job": 114623123717,
      "time": 111,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11720763271"
    },
    {
      "job": 114623123755,
      "time": 101,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11721403353"
    },
    {
      "job": 114623123751,
      "time": 77,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11721112585"
    },
    {
      "job": 114623123712,
      "time": 89,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11720733282"
    }
  ],
  "_upstream": "https://github.com/nacnudus/unpivotr",
  "_commit": {
    "id": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
    "author": "Duncan Garmonsway <nacnudus@gmail.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #63 from hadley/rvest-html-table-fill\n\nRemove deprecated `fill = TRUE` from `html_table()` calls",
    "time": 1791755564
  },
  "_maintainer": {
    "name": "Duncan Garmonsway",
    "email": "nacnudus@gmail.com",
    "login": "nacnudus",
    "description": "",
    "uuid": 3522552
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.2.0",
      "role": "Depends"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "forcats",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "pillar",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "version": ">= 2.1.1",
      "role": "Imports"
    },
    {
      "package": "cellranger",
      "role": "Imports"
    },
    {
      "package": "xml2",
      "role": "Imports"
    },
    {
      "package": "tidyselect",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "readr",
      "role": "Suggests"
    },
    {
      "package": "tidyxl",
      "role": "Suggests"
    },
    {
      "package": "readxl",
      "role": "Suggests"
    },
    {
      "package": "stringr",
      "role": "Suggests"
    },
    {
      "package": "htmltools",
      "role": "Suggests"
    },
    {
      "package": "rvest",
      "version": ">= 1.0.0",
      "role": "Suggests"
    },
    {
      "package": "selectr",
      "role": "Suggests"
    },
    {
      "package": "DT",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "here",
      "role": "Suggests"
    }
  ],
  "_owner": "nacnudus",
  "_selfowned": true,
  "_usedby": 3,
  "_updates": [
    {
      "week": "2026-41",
      "n": 1
    }
  ],
  "_tags": [],
  "_topics": [
    "excel",
    "pivot-tables",
    "spreadsheet"
  ],
  "_stars": 190,
  "_contributors": [
    {
      "user": "nacnudus",
      "count": 636,
      "uuid": 3522552
    },
    {
      "user": "billdenney",
      "count": 4,
      "uuid": 10359931
    },
    {
      "user": "davisvaughan",
      "count": 2,
      "uuid": 19150088
    },
    {
      "user": "ianmoran11",
      "count": 2,
      "uuid": 11229116
    },
    {
      "user": "lionel-",
      "count": 2,
      "uuid": 4465050
    },
    {
      "user": "gregrs-uk",
      "count": 1,
      "uuid": 7353938
    },
    {
      "user": "hadley",
      "count": 1,
      "uuid": 4196
    },
    {
      "user": "krlmlr",
      "count": 1,
      "uuid": 1741643
    },
    {
      "user": "mtkerber",
      "count": 1,
      "uuid": 45527952
    },
    {
      "user": "wdkrnls",
      "count": 1,
      "uuid": 598210
    }
  ],
  "_userbio": {
    "uuid": 3522552,
    "type": "user",
    "name": "Duncan Garmonsway",
    "followers": 121
  },
  "_downloads": {
    "count": 458,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/unpivotr"
  },
  "_devurl": "https://github.com/nacnudus/unpivotr",
  "_pkgdown": "https://nacnudus.github.io/unpivotr/",
  "_searchresults": 336,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/unpivotr.html",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/nacnudus/unpivotr",
  "_realowner": "nacnudus",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2017-01-31"
    },
    {
      "version": "0.1.1",
      "date": "2017-04-23"
    },
    {
      "version": "0.2.1",
      "date": "2017-07-02"
    },
    {
      "version": "0.3.0",
      "date": "2017-12-03"
    },
    {
      "version": "0.3.1",
      "date": "2018-01-20"
    },
    {
      "version": "0.4.0",
      "date": "2018-06-26"
    },
    {
      "version": "0.5.0",
      "date": "2019-01-02"
    },
    {
      "version": "0.5.1",
      "date": "2019-04-08"
    },
    {
      "version": "0.6.0",
      "date": "2020-05-08"
    },
    {
      "version": "0.6.1",
      "date": "2020-08-04"
    },
    {
      "version": "0.6.2",
      "date": "2021-08-22"
    },
    {
      "version": "0.6.3",
      "date": "2023-01-22"
    },
    {
      "version": "0.6.4",
      "date": "2024-11-30"
    }
  ],
  "_exports": [
    "%>%",
    "as_cells",
    "behead",
    "behead_if",
    "enhead",
    "isolate_sentinels",
    "justify",
    "merge_cols",
    "merge_rows",
    "pack",
    "partition",
    "partition_dim",
    "rectify",
    "spatter",
    "tidy_table",
    "unpack"
  ],
  "_datasets": [
    {
      "name": "purpose",
      "title": "Sense-of-purpose in the 2014 New Zealand General Social Survey",
      "object": "purpose",
      "class": [
        "list"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "unpivotr-package",
      "title": "Un-pivot complex and irregular data layouts.",
      "topics": [
        "unpivotr-package",
        "unpivotr"
      ]
    },
    {
      "page": "as_cells",
      "title": "Tokenize data frames into a tidy 'melted' structure",
      "topics": [
        "as_cells"
      ]
    },
    {
      "page": "behead",
      "title": "Strip a level of headers from a pivot table",
      "topics": [
        "behead",
        "behead_if"
      ]
    },
    {
      "page": "direction",
      "title": "Directions from data cells to headers",
      "topics": [
        "direction"
      ]
    },
    {
      "page": "enhead",
      "title": "Join data cells to headers",
      "topics": [
        "enhead"
      ]
    },
    {
      "page": "isolate_sentinels",
      "title": "Move sentinel values into a separate column leaving NA behind",
      "topics": [
        "isolate_sentinels"
      ]
    },
    {
      "page": "justify",
      "title": "Align one set of cells with another set",
      "topics": [
        "justify"
      ]
    },
    {
      "page": "merge_cells",
      "title": "Merge cell values into a single cell by rows or columns",
      "topics": [
        "merge_cells",
        "merge_cols",
        "merge_rows"
      ]
    },
    {
      "page": "pack",
      "title": "Pack cell values from separate columns per data type into one list-column",
      "topics": [
        "pack",
        "unpack"
      ]
    },
    {
      "page": "partition",
      "title": "Divide a grid of cells into partitions containing individual tables",
      "topics": [
        "partition",
        "partition_dim"
      ]
    },
    {
      "page": "purpose",
      "title": "Sense-of-purpose in the 2014 New Zealand General Social Survey",
      "topics": [
        "purpose"
      ]
    },
    {
      "page": "rectify",
      "title": "Display cells as though in a spreadsheet",
      "topics": [
        "print.cell_grid",
        "rectify"
      ]
    },
    {
      "page": "spatter",
      "title": "Spread key-value pairs of mixed types across multiple columns",
      "topics": [
        "spatter"
      ]
    },
    {
      "page": "tidy_table",
      "title": "Tokenize data frames into a tidy 'melted' structure",
      "topics": [
        "tidy_table"
      ]
    }
  ],
  "_readme": "https://github.com/nacnudus/unpivotr/raw/HEAD/README.md",
  "_rundeps": [
    "cellranger",
    "cli",
    "cpp11",
    "dplyr",
    "forcats",
    "generics",
    "glue",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "rematch",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr",
    "xml2"
  ],
  "_vignettes": [
    {
      "source": "html.Rmd",
      "filename": "html.html",
      "title": "HTML Tables",
      "author": "Duncan Garmonsway",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Rowspan and colspan examples",
        "Rowspan",
        "Colspan",
        "Both rowspan and colspan: non-square",
        "Nested example",
        "URL example"
      ],
      "created": "2017-06-18 16:29:40",
      "modified": "2026-10-11 21:52:44",
      "commits": 6
    },
    {
      "source": "introduction.Rmd",
      "filename": "introduction.html",
      "title": "Introduction to unpivotr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Preface",
        "1. Reading easy spreadsheets with",
        "2. Trying to read a hard spreadsheet with",
        "3. Demonstration of",
        "4. Explanation of tidyxl::xlsx_cells()",
        "5. Explanation of unpivotr::behead()",
        "6. Continuing unpivotr::behead()",
        "7. Handling meaningful formatting with unpivotr::behead_if()",
        "8. Finishing and cleaning up",
        "Review"
      ],
      "created": "2019-08-30 22:55:53",
      "modified": "2022-05-12 18:13:45",
      "commits": 4
    },
    {
      "source": "small-multiples.Rmd",
      "filename": "small-multiples.html",
      "title": "Small Multiples",
      "author": "Duncan Garmonsway",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Preparation",
        "Main",
        "Importing the data",
        "Importing one of the multiples",
        "34-line code listing"
      ],
      "created": "2016-10-14 19:52:55",
      "modified": "2021-07-18 21:49:19",
      "commits": 18
    }
  ],
  "_score": 9.889669156277005,
  "_indexed": true,
  "_nocasepkg": "unpivotr",
  "_universes": [
    "nacnudus"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.6.4",
      "date": "2026-10-12T01:13:20.000Z",
      "distro": "resolute",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/e4be43c4b65ebb0403bfe96bfa38b5357fbe9c67f47e6fe05cf7de35bce8a3a3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.6.4",
      "date": "2026-10-12T01:13:18.000Z",
      "distro": "resolute",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/45372b31683f61e2d4fdbf933685a7407b1f6c71ff259d3974aceaf474d25038",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.6.4",
      "date": "2026-10-12T01:11:54.000Z",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/c5423fc31b3019ca314591ce46cfec3f8c7f423517b2b95777dc51d2b47c06d9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.6.4",
      "date": "2026-10-12T01:12:03.000Z",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/ab9dbf0c7ee2be9a5a405b3c1f5fa31114bf785f68f1536ee8338b07389015c3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.6.4",
      "date": "2026-10-12T01:12:20.000Z",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/1a5be5d9a42a57fa00d0a88365c19819f71ddfb4d0fcc4e007b9568e0704b0ef",
      "status": "success",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.6.4",
      "date": "2026-10-12T01:11:39.000Z",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/b98750e766854b84a3bda334793c2b48005f7c81d215858089517be22d0ced13",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.6.4",
      "date": "2026-10-12T01:11:22.000Z",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/4113cf9041d1a690dd0b89e296403fc671c8e22893102716dd52e798fd0c727f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.6.4",
      "date": "2026-10-12T01:11:30.000Z",
      "commit": "e53af1cc09ca03e8d9418508a0ae4fc11a5d329f",
      "fileid": "https://r2.ropensci.org/d4fce26887ca84e8c8f6495fa0758ddb72855a6b98759668479680a61b303047",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38190576288"
    }
  ]
}