Handle Data with Messy Header Rows and Broken Values
Rectangling embedded subheaders
Unwrap values and clean up NAs used as padding
Annotate meaningful formatting
Annotate meaningful formatting for all cells
boutiques.xlsx spreadsheet
dog_test.xlsx spreadsheet
Make many header rows into column names
re-export magrittr pipe operator
Vertical character string alignment through regular expressions
Deduplicate and remove trailing line breaks
Merge rows up
Unbreak values using regex to match the lagging half of the broken val...
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.
Useful links