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-any)unpivotr_0.6.4.zip(r-4.6-any)unpivotr_0.6.4.zip(r-4.5-any)
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.89 score 190 stars 3 packages 336 scripts 458 downloads 16 exports 24 dependencies

Last updated from:e53af1cc09. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-develOK199
source / vignettesOK242
linux-releaseOK194
macos-releaseOK113
macos-oldrelOK102
windows-develOK101
windows-releaseOK89
windows-oldrelOK77
wasm-releaseOK111

Exports:%>%as_cellsbeheadbehead_ifenheadisolate_sentinelsjustifymerge_colsmerge_rowspackpartitionpartition_dimrectifyspattertidy_tableunpack

Dependencies:cellrangerclicpp11dplyrforcatsgenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rematchrlangstringistringrtibbletidyrtidyselectutf8vctrswithrxml2

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

Last update: 2026-10-11
Started: 2017-06-18

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