{
  "_id": "6a4cb13407c3fd5c3260f5ea",
  "Package": "unheadr",
  "Type": "Package",
  "Title": "Handle Data with Messy Header Rows and Broken Values",
  "Version": "0.4.0",
  "Authors@R": "person(\"Luis D.\", \"Verde Arregoitia\", email = \"luis@liomys.mx\",\nrole=c(\"aut\",\"cre\"),comment = c(ORCID = \"0000-0001-9520-6543\"))",
  "Description": "Verb-like functions to work with messy data, often derived\nfrom spreadsheets or parsed PDF tables. Includes functions for\nunwrapping values broken up across rows, relocating embedded\ngrouping values, and to annotate meaningful formatting in\nspreadsheet files.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "RoxygenNote": "7.3.1",
  "Roxygen": "list(markdown = TRUE)",
  "VignetteBuilder": "knitr",
  "URL": "https://github.com/luisDVA/unheadr, https://unheadr.liomys.mx/",
  "BugReports": "https://github.com/luisDVA/unheadr/issues",
  "Config/pak/sysreqs": "libicu-dev",
  "Repository": "https://luisdva.r-universe.dev",
  "Date/Publication": "2026-03-09 07:21:24 UTC",
  "RemoteUrl": "https://github.com/luisdva/unheadr",
  "RemoteRef": "HEAD",
  "RemoteSha": "d890056b14fe24141db4b25efca3bc429169da9c",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-07-07 07:53:35 UTC",
    "User": "root"
  },
  "Author": "Luis D. Verde Arregoitia [aut, cre] (ORCID:\n<https://orcid.org/0000-0001-9520-6543>)",
  "Maintainer": "Luis D. Verde Arregoitia <luis@liomys.mx>",
  "_user": "luisdva",
  "_type": "src",
  "_file": "unheadr_0.4.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/2060b9490a9fee3532dba96fb3abc863e9824c2223e9750d6c5fdb5a05f0cc82",
  "_filesize": 548038,
  "_sha256": "2060b9490a9fee3532dba96fb3abc863e9824c2223e9750d6c5fdb5a05f0cc82",
  "_expires": "2026-10-15T07:56:34.000Z",
  "_created": "2026-07-07T07:53:35.000Z",
  "_published": "2026-07-07T07:56:36.244Z",
  "_jobs": [
    {
      "job": 85564642928,
      "time": 145,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8131419904"
    },
    {
      "job": 85564642960,
      "time": 137,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8131416162"
    },
    {
      "job": 85564642943,
      "time": 76,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8131394337"
    },
    {
      "job": 85564642929,
      "time": 91,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8131399816"
    },
    {
      "job": 85564085791,
      "time": 193,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8131366392"
    },
    {
      "job": 85564642918,
      "time": 141,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8131418591"
    },
    {
      "job": 85564642945,
      "time": 99,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8131403223"
    },
    {
      "job": 85564642946,
      "time": 66,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8131391120"
    },
    {
      "job": 85564642936,
      "time": 75,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8131394380"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413",
  "_status": "success",
  "_upstream": "https://github.com/luisdva/unheadr",
  "_commit": {
    "id": "d890056b14fe24141db4b25efca3bc429169da9c",
    "author": "LuisDVA <luisd@ciencias.unam.mx>",
    "committer": "LuisDVA <luisd@ciencias.unam.mx>",
    "message": "sort out logos\n",
    "time": 1773040884
  },
  "_maintainer": {
    "name": "Luis D. Verde Arregoitia",
    "email": "luis@liomys.mx",
    "login": "luisdva",
    "bluesky": "@liomys.mx",
    "linkedin": "in/luis-d-verde-arregoitia-a20339209",
    "orcid": "0000-0001-9520-6543",
    "description": "mammalogist",
    "uuid": 5580938
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "dplyr",
      "version": ">= 0.8.4",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 0.2.1",
      "role": "Imports"
    },
    {
      "package": "forcats",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "tidyxl",
      "role": "Imports"
    },
    {
      "package": "readxl",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 2.1.0",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    }
  ],
  "_owner": "luisdva",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-38",
      "n": 1
    },
    {
      "week": "2026-11",
      "n": 1
    }
  ],
  "_tags": [],
  "_stars": 64,
  "_contributors": [
    {
      "user": "luisdva",
      "count": 197,
      "uuid": 5580938
    }
  ],
  "_userbio": {
    "uuid": 5580938,
    "type": "user",
    "name": "Luis Verde Arregoitia",
    "followers": 163,
    "description": "mammalogist"
  },
  "_downloads": {
    "count": 315,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/unheadr"
  },
  "_devurl": "https://github.com/luisdva/unheadr",
  "_pkgdown": "https://unheadr.liomys.mx/",
  "_searchresults": 73,
  "_rbuild": "4.6.1",
  "_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/unheadr.html",
    "LICENSE",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/luisdva/unheadr",
  "_realowner": "luisdva",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.2.0",
      "date": "2020-02-09"
    },
    {
      "version": "0.2.1",
      "date": "2020-03-04"
    },
    {
      "version": "0.3.0",
      "date": "2020-10-25"
    },
    {
      "version": "0.3.1",
      "date": "2021-02-07"
    },
    {
      "version": "0.3.2",
      "date": "2021-04-10"
    },
    {
      "version": "0.3.3",
      "date": "2022-08-15"
    },
    {
      "version": "0.4.0",
      "date": "2024-05-13"
    }
  ],
  "_exports": [
    "%>%",
    "annotate_mf",
    "annotate_mf_all",
    "mash_colnames",
    "regex_valign",
    "squish_newlines",
    "unbreak_rows",
    "unbreak_vals",
    "untangle2",
    "unwrap_cols"
  ],
  "_datasets": [
    {
      "name": "AOEunits",
      "title": "Statistics for game units in Age of Empires II: Definitive Edition",
      "object": "AOEunits",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "unit",
        "building",
        "type",
        "age",
        "cost_wood",
        "cost_food",
        "cost_gold",
        "build_time",
        "rate_of_fire",
        "attack_delay",
        "movement_speed",
        "line_of_sight",
        "hit_points",
        "min_range",
        "range",
        "damage",
        "accuracy",
        "melee_armor",
        "pierce_armor"
      ],
      "rows": 128,
      "table": true,
      "tojson": true
    },
    {
      "name": "AOEunits_raw",
      "title": "Statistics for game units in Age of Empires II: Definitive Edition in a messy presentation",
      "object": "AOEunits_raw",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "Name",
        "Type",
        "Age",
        "Cost",
        "Build time",
        "Rate_of_Fire",
        "Attack_Delay",
        "Movement_Speed",
        "Line_of_Sight",
        "Hit Points",
        "Min Range",
        "Range",
        "Damage",
        "Accuracy",
        "Armor_(Melee/Pierce)"
      ],
      "rows": 139,
      "table": true,
      "tojson": true
    },
    {
      "name": "primates2017",
      "title": "Comparative data for 54 species of primates",
      "object": "primates2017",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "scientific_name",
        "common_name",
        "red_list_status",
        "mass_kg"
      ],
      "rows": 69,
      "table": true,
      "tojson": true
    },
    {
      "name": "primates2017_broken",
      "title": "Comparative data for 16 species of primates with some broken values",
      "object": "primates2017_broken",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "scientific_name",
        "common_name",
        "red_list_status",
        "mass_kg"
      ],
      "rows": 19,
      "table": true,
      "tojson": true
    },
    {
      "name": "primates2017_wrapped",
      "title": "Comparative data for two species of primates",
      "object": "primates2017_wrapped",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "scientific_name",
        "common_name",
        "habitat",
        "red_list_status",
        "mass_kg",
        "country"
      ],
      "rows": 9,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "annotate_mf",
      "title": "Annotate meaningful formatting",
      "topics": [
        "annotate_mf"
      ]
    },
    {
      "page": "annotate_mf_all",
      "title": "Annotate meaningful formatting for all cells",
      "topics": [
        "annotate_mf_all"
      ]
    },
    {
      "page": "AOEunits",
      "title": "Statistics for game units in Age of Empires II: Definitive Edition",
      "topics": [
        "AOEunits"
      ]
    },
    {
      "page": "AOEunits_raw",
      "title": "Statistics for game units in Age of Empires II: Definitive Edition in a messy presentation",
      "topics": [
        "AOEunits_raw"
      ]
    },
    {
      "page": "boutiques.xlsx",
      "title": "boutiques.xlsx spreadsheet",
      "topics": [
        "boutiques.xlsx"
      ]
    },
    {
      "page": "dog_test.xlsx",
      "title": "dog_test.xlsx spreadsheet",
      "topics": [
        "dog_test.xlsx"
      ]
    },
    {
      "page": "mash_colnames",
      "title": "Make many header rows into column names",
      "topics": [
        "mash_colnames"
      ]
    },
    {
      "page": "primates2017",
      "title": "Comparative data for 54 species of primates",
      "topics": [
        "primates2017"
      ]
    },
    {
      "page": "primates2017_broken",
      "title": "Comparative data for 16 species of primates with some broken values",
      "topics": [
        "primates2017_broken"
      ]
    },
    {
      "page": "primates2017_wrapped",
      "title": "Comparative data for two species of primates",
      "topics": [
        "primates2017_wrapped"
      ]
    },
    {
      "page": "regex_valign",
      "title": "Vertical character string alignment through regular expressions",
      "topics": [
        "regex_valign"
      ]
    },
    {
      "page": "squish_newlines",
      "title": "Deduplicate and remove trailing line breaks",
      "topics": [
        "squish_newlines"
      ]
    },
    {
      "page": "unbreak_rows",
      "title": "Merge rows up",
      "topics": [
        "unbreak_rows"
      ]
    },
    {
      "page": "unbreak_vals",
      "title": "Unbreak values using regex to match the lagging half of the broken value",
      "topics": [
        "unbreak_vals"
      ]
    },
    {
      "page": "untangle2",
      "title": "Rectangling embedded subheaders",
      "topics": [
        "untangle2"
      ]
    },
    {
      "page": "unwrap_cols",
      "title": "Unwrap values and clean up NAs used as padding",
      "topics": [
        "unwrap_cols"
      ]
    }
  ],
  "_pkglogo": "https://github.com/luisdva/unheadr/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/luisdva/unheadr/raw/HEAD/README.md",
  "_rundeps": [
    "cellranger",
    "cli",
    "cpp11",
    "crayon",
    "dplyr",
    "forcats",
    "generics",
    "glue",
    "hms",
    "lifecycle",
    "magrittr",
    "pillar",
    "piton",
    "pkgconfig",
    "prettyunits",
    "progress",
    "purrr",
    "R6",
    "Rcpp",
    "readxl",
    "rematch",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "tidyxl",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "unheadr-vignette.Rmd",
      "filename": "unheadr-vignette.html",
      "title": "Introduction to unheadr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Package functions",
        "Data frames and tibbles",
        "Spreadsheets",
        "Supported formatting:",
        "Character vectors",
        "Further reading"
      ],
      "created": "2018-07-04 13:23:44",
      "modified": "2024-05-09 18:48:39",
      "commits": 13
    }
  ],
  "_score": 6.6695028341043425,
  "_indexed": true,
  "_nocasepkg": "unheadr",
  "_universes": [
    "luisdva"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.0",
      "date": "2026-07-07T07:55:55.000Z",
      "distro": "resolute",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/84d3afec66da6ee329fd27dbe924fc39544dd31a1783e4c67d433c79856d1255",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.0",
      "date": "2026-07-07T07:55:49.000Z",
      "distro": "resolute",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/932ddbcfb705852944ce507de277551dc17b5fbc77aec31ed36a27ed9193732f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.0",
      "date": "2026-07-07T07:54:54.000Z",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/60386e03d95541fec6e88b90884d7d41d05e7333daf97bfe4adfd0c96f5fec32",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.0",
      "date": "2026-07-07T07:55:06.000Z",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/385bdafcf37f913e52620bf5e54c85adc50ef9a146a98cc0b37998d254dad576",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.0",
      "date": "2026-07-07T07:56:11.000Z",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/7f22ca520c612d628a5aa628a92864f2584cb72f84a54565ccbcd6db16213c56",
      "status": "success",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-07-07T07:55:07.000Z",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/5aa62772f00df0b958c60913e167b18fe6ebddcbdbc3679a95cedc8143f80013",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-07-07T07:54:35.000Z",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/abef3dd62f1cc69c0596d6781cc68aa5a1a448c0abbd785ebc14f65362f62d4e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-07-07T07:54:43.000Z",
      "commit": "d890056b14fe24141db4b25efca3bc429169da9c",
      "fileid": "https://r2.ropensci.org/1a82c3c620634d99b041d8c2583110e4551106754d5540f35378fa09c2b5b6be",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28850403413"
    }
  ]
}