Package: unpivotr 0.6.4

unpivotr: Unpivot Complex and Irregular Data Layouts

Tools for converting data from complex or irregular layouts to a columnar structure. For example, tables with multilevel column or row headers, or spreadsheets. Header and data cells are selected by their contents and position, as well as formatting and comments where available, and are associated with one other by their proximity in given directions. Functions for data frames and HTML tables are provided.

Authors:Duncan Garmonsway [aut, cre]

unpivotr_0.6.4.tar.gz
unpivotr_0.6.4.zip(r-4.7)unpivotr_0.6.4.zip(r-4.6)unpivotr_0.6.4.zip(r-4.5)
unpivotr_0.6.4.tgz(r-4.6-any)unpivotr_0.6.4.tgz(r-4.5-any)
unpivotr_0.6.4.tar.gz(r-4.7-any)unpivotr_0.6.4.tar.gz(r-4.6-any)
unpivotr_0.6.4.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
unpivotr/json (API)

# Install 'unpivotr' in R:
install.packages('unpivotr', repos = c('https://nacnudus.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/nacnudus/unpivotr/issues

Pkgdown/docs site:https://nacnudus.github.io

Datasets:
  • purpose - Sense-of-purpose in the 2014 New Zealand General Social Survey

On CRAN:

Conda:

excelpivot-tablesspreadsheet

9.65 score 188 stars 2 packages 330 scripts 538 downloads 16 exports 24 dependencies

Last updated from:8c9dd722a3. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK153
source / vignettesOK211
linux-release-x86_64OK142
macos-release-arm64OK114
macos-oldrel-arm64OK115
windows-develOK90
windows-releaseOK81
windows-oldrelOK86
wasm-releaseOK163

Exports:%>%as_cellsbeheadbehead_ifenheadisolate_sentinelsjustifymerge_colsmerge_rowspackpartitionpartition_dimrectifyspattertidy_tableunpack

Dependencies:cellrangerclicpp11dplyrforcatsgenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rematchrlangstringistringrtibbletidyrtidyselectutf8vctrswithrxml2

Introduction to unpivotr
Preface | 1. Reading easy spreadsheets with | 2. Trying to read a hard spreadsheet with | 3. Demonstration of | 4. Explanation of tidyxl::xlsx_cells() | 5. Explanation of unpivotr::behead() | 6. Continuing unpivotr::behead() | 7. Handling meaningful formatting with unpivotr::behead_if() | 8. Finishing and cleaning up | Review
Rendered fromintroduction.Rmdusingknitr::rmarkdown

Last update: 2022-05-12
Started: 2019-08-30

Small Multiples
Introduction | Preparation | Main | Importing the data | Importing one of the multiples | 34-line code listing
Rendered fromsmall-multiples.Rmdusingknitr::rmarkdown

Last update: 2021-07-18
Started: 2016-10-14

HTML Tables
Rowspan and colspan examples | Rowspan | Colspan | Both rowspan and colspan: non-square | Nested example | URL example
Rendered fromhtml.Rmdusingknitr::rmarkdown

Last update: 2018-12-29
Started: 2017-06-18