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

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