Package: unheadr 0.4.0

unheadr: Handle Data with Messy Header Rows and Broken Values

Verb-like functions to work with messy data, often derived from spreadsheets or parsed PDF tables. Includes functions for unwrapping values broken up across rows, relocating embedded grouping values, and to annotate meaningful formatting in spreadsheet files.

Authors:Luis D. Verde Arregoitia [aut, cre]

unheadr_0.4.0.tar.gz
unheadr_0.4.0.zip(r-4.5)unheadr_0.4.0.zip(r-4.4)unheadr_0.4.0.zip(r-4.3)
unheadr_0.4.0.tgz(r-4.4-any)unheadr_0.4.0.tgz(r-4.3-any)
unheadr_0.4.0.tar.gz(r-4.5-noble)unheadr_0.4.0.tar.gz(r-4.4-noble)
unheadr_0.4.0.tgz(r-4.4-emscripten)unheadr_0.4.0.tgz(r-4.3-emscripten)
unheadr.pdf |unheadr.html✨
unheadr/json (API)
NEWS

# Install 'unheadr' in R:

install.packages('unheadr', repos = c('https://luisdva.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/luisdva/unheadr/issues

Pkgdown site:https://unheadr.liomys.mx

Datasets:

AOEunits - Statistics for game units in Age of Empires II: Definitive Edition
AOEunits_raw - Statistics for game units in Age of Empires II: Definitive Edition in a messy presentation
primates2017 - Comparative data for 54 species of primates
primates2017_broken - Comparative data for 16 species of primates with some broken values
primates2017_wrapped - Comparative data for two species of primates

On CRAN:

6.42 score 59 stars 45 scripts 197 downloads 10 exports 32 dependencies

Last updated 8 months agofrom:5cf220b3c9. Checks:7 OK. Indexed: yes.

Target	Result	Latest binary
Doc / Vignettes	OK	Jan 08 2025
R-4.5-win	OK	Jan 08 2025
R-4.5-linux	OK	Jan 08 2025
R-4.4-win	OK	Jan 08 2025
R-4.4-mac	OK	Jan 08 2025
R-4.3-win	OK	Jan 08 2025
R-4.3-mac	OK	Jan 08 2025

Exports:%>%annotate_mf annotate_mf_all mash_colnames regex_valign squish_newlines unbreak_rows unbreak_vals untangle2 unwrap_cols

Dependencies:cellranger cli cpp11 crayon dplyr fansi 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

Introduction to unheadr

Rendered fromunheadr-vignette.Rmdusingknitr::rmarkdownon Jan 08 2025.

Last update: 2024-05-09
Started: 2018-07-04

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Annotate meaningful formatting	annotate_mf
Annotate meaningful formatting for all cells	annotate_mf_all
Statistics for game units in Age of Empires II: Definitive Edition	AOEunits
Statistics for game units in Age of Empires II: Definitive Edition in a messy presentation	AOEunits_raw
boutiques.xlsx spreadsheet	boutiques.xlsx
dog_test.xlsx spreadsheet	dog_test.xlsx
Make many header rows into column names	mash_colnames
Comparative data for 54 species of primates	primates2017
Comparative data for 16 species of primates with some broken values	primates2017_broken
Comparative data for two species of primates	primates2017_wrapped
Vertical character string alignment through regular expressions	regex_valign
Deduplicate and remove trailing line breaks	squish_newlines
Merge rows up	unbreak_rows
Unbreak values using regex to match the lagging half of the broken value	unbreak_vals
Rectangling embedded subheaders	untangle2
Unwrap values and clean up NAs used as padding	unwrap_cols