Learn R Programming

unheadr (version 0.4.0)

Handle Data with Messy Header Rows and Broken Values

Description

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.

Copy Link

Version

Install

install.packages('unheadr')

Monthly Downloads

202

Version

0.4.0

License

MIT + file LICENSE

Issues

1

Pull Requests

0

Stars

60

Forks

2

Maintainer

Luis D. Verde Arregoitia

Last Published

May 13th, 2024

Functions in unheadr (0.4.0)

regex_valign

Vertical character string alignment through regular expressions
primates2017_wrapped

Comparative data for two species of primates
unwrap_cols

Unwrap values and clean up NAs used as padding
annotate_mf

Annotate meaningful formatting
annotate_mf_all

Annotate meaningful formatting for all cells
dog_test.xlsx

dog_test.xlsx spreadsheet
untangle2

Rectangling embedded subheaders
unbreak_rows

Merge rows up
primates2017_broken

Comparative data for 16 species of primates with some broken values
mash_colnames

Make many header rows into column names
boutiques.xlsx

boutiques.xlsx spreadsheet
squish_newlines

Deduplicate and remove trailing line breaks
unbreak_vals

Unbreak values using regex to match the lagging half of the broken value
%>%

re-export magrittr pipe operator
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
unheadr-package

unheadr: Handle Data with Messy Header Rows and Broken Values