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.7)unheadr_0.4.0.zip(r-4.6)unheadr_0.4.0.zip(r-4.5)
unheadr_0.4.0.tgz(r-4.6-any)unheadr_0.4.0.tgz(r-4.5-any)
unheadr_0.4.0.tar.gz(r-4.7-any)unheadr_0.4.0.tar.gz(r-4.6-any)
unheadr_0.4.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
unheadr/json (API)

# 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/docs 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.67 score 64 stars 73 scripts 315 downloads 10 exports 31 dependencies

Last updated from:d890056b14. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	145
source / vignettes	OK	193
linux-release-x86_64	OK	137
macos-release-arm64	OK	91
macos-oldrel-arm64	OK	76
windows-devel	OK	99
windows-release	OK	75
windows-oldrel	OK	66
wasm-release	OK	141

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 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::rmarkdown

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