{
  "_id": "6a200ddab401979e73447f82",
  "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": "2025-02-01 21:37:49 UTC",
  "RemoteUrl": "https://github.com/nacnudus/unpivotr",
  "RemoteRef": "HEAD",
  "RemoteSha": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-03 11:16:31 UTC",
    "User": "root"
  },
  "Author": "Duncan Garmonsway [aut, cre]",
  "Maintainer": "Duncan Garmonsway <nacnudus@gmail.com>",
  "MD5sum": "46bc05092a1ef26b1f3c4a1c8808c9ce",
  "_user": "nacnudus",
  "_type": "src",
  "_file": "unpivotr_0.6.4.tar.gz",
  "_fileid": "52f0aeb82d9078444377d6d128ec0b5724de554dcbe605152ae880d9d722ef24",
  "_filesize": 4074085,
  "_sha256": "52f0aeb82d9078444377d6d128ec0b5724de554dcbe605152ae880d9d722ef24",
  "_created": "2026-06-03T11:16:31.000Z",
  "_published": "2026-06-03T11:19:54.845Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79281490483,
      "time": 165,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7383101155"
    },
    {
      "job": 79281490516,
      "time": 143,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383093658"
    },
    {
      "job": 79281490578,
      "time": 121,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7383085855"
    },
    {
      "job": 79281490544,
      "time": 125,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383085898"
    },
    {
      "job": 79281017524,
      "time": 172,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383045233"
    },
    {
      "job": 79281490990,
      "time": 119,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383085982"
    },
    {
      "job": 79281490545,
      "time": 103,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7383080359"
    },
    {
      "job": 79281490515,
      "time": 78,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7383074911"
    },
    {
      "job": 79281490551,
      "time": 101,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383080343"
    }
  ],
  "_buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/nacnudus/unpivotr",
  "_commit": {
    "id": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
    "author": "Duncan Garmonsway <nacnudus@gmail.com>",
    "committer": "Duncan Garmonsway <nacnudus@gmail.com>",
    "message": "Try to fix pkgdown on GitHub pages\n",
    "time": 1738445869
  },
  "_maintainer": {
    "name": "Duncan Garmonsway",
    "email": "nacnudus@gmail.com",
    "login": "nacnudus",
    "description": "",
    "uuid": 3522552
  },
  "_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",
      "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": 2,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "excel",
    "pivot-tables",
    "spreadsheet"
  ],
  "_stars": 188,
  "_contributors": [
    {
      "user": "nacnudus",
      "count": 635,
      "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": "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"
  },
  "_downloads": {
    "count": 450,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/unpivotr"
  },
  "_devurl": "https://github.com/nacnudus/unpivotr",
  "_pkgdown": "https://nacnudus.github.io/unpivotr/",
  "_searchresults": 350,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/unpivotr.html",
    "manual.pdf"
  ],
  "_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": "2018-12-29 21:27:43",
      "commits": 5
    },
    {
      "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.675558390045225,
  "_indexed": true,
  "_nocasepkg": "unpivotr",
  "_universes": [
    "nacnudus"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.6.4",
      "date": "2026-06-03T11:19:13.000Z",
      "distro": "noble",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "b144dba17ed560d2393424c989e54fab0dd47212b22668286b48c3e4c7ed8965",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.6.4",
      "date": "2026-06-03T11:18:52.000Z",
      "distro": "noble",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "dddeeca84876e85860402b17856c04b0c9e74962f06f6ed920a42dc5c90c5a55",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.6.4",
      "date": "2026-06-03T11:18:27.000Z",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "b15e612f2a181ff7d7ee9e28efdb767dc5d608fee1744b38d941928b6c86d19e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.6.4",
      "date": "2026-06-03T11:18:27.000Z",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "48cd9bfadfa825bb3ee9495d3fbe5b1f21f330b35fe7503c44a2d59e9eaa521a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.6.4",
      "date": "2026-06-03T11:18:51.000Z",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "ca82eb411a37518ec3b336dd0a35b2946df27dfb5399ba44952e97a0f27e9bae",
      "status": "success",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.6.4",
      "date": "2026-06-03T11:18:05.000Z",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "3ae8ba5a7af5154493d0f4b2f0dfad4aca5648b918f885e738f28bff2f2f138d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.6.4",
      "date": "2026-06-03T11:17:51.000Z",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "34e91c1f42e1433741f7d684e25c098936459fab661ebb9faa34413cb8af0470",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.6.4",
      "date": "2026-06-03T11:18:06.000Z",
      "commit": "8c9dd722a3f18b3331c17e2f44a2b69a5fac8b87",
      "fileid": "944d2643f864c44735c70e474437509bcf21e8b322ff4a6a8b00ba69fc0cc8f0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26881069361"
    }
  ]
}