Function reference • unheadr

Data rectangling functions

mash_colnames(): Make many header rows into column names

unbreak_rows(): Merge rows up

unbreak_vals(): Unbreak values using regex to match the lagging half of the broken value

untangle2(): Rectangling embedded subheaders

unwrap_cols(): Unwrap values and clean up NAs used as padding

squish_newlines(): Deduplicate and remove trailing line breaks

General data cleaning

regex_valign(): Vertical character string alignment through regular expressions

Spreadsheet annotation

annotate_mf(): Annotate meaningful formatting

annotate_mf_all(): Annotate meaningful formatting for all cells

Example data

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

boutiques.xlsx: boutiques.xlsx spreadsheet

dog_test.xlsx: dog_test.xlsx spreadsheet

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