Learn R Programming
⚠️There's a newer version (0.4.0) of this package.Take me there.

unheadr (version 0.3.2)

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

290

Version

0.3.2

License

MIT + file LICENSE

Issues

1

Pull Requests

0

Stars

63

Forks

2

Maintainer

Luis D. Verde Arregoitia

Last Published

April 9th, 2021

Functions in unheadr (0.3.2)

unwrap_cols

Unwrap values and clean up NAs used as padding
unheadr-package

unheadr: Handle Data with Messy Header Rows and Broken Values
untangle2

Rectangling embedded subheaders
primates2017_broken

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

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

Merge rows up
primates2017_wrapped

Comparative data for two species of primates
regex_valign

Vertical character string alignment through regular expressions
dog_test.xlsx

dog_test.xlsx spreadsheet
mash_colnames

Make many header rows into column names
AOEunits_raw

Statistics for game units in Age of Empires II: Definitive Edition in a messy presentation
annotate_mf

Annotate meaningful formatting
%>%

re-export magrittr pipe operator
boutiques.xlsx

boutiques.xlsx spreadsheet
primates2017

Comparative data for 54 species of primates
AOEunits

Statistics for game units in Age of Empires II: Definitive Edition
annotate_mf_all

Annotate meaningful formatting for all cells