unpivotr

0.6.4

Unpivot Complex and Irregular Data Layouts

0packages depend

10.9Kdownloads / year

99.5%test coverage

13/13checks pass

Overview

About

Maintained by Duncan GarmonswayFirst published 2017-01-3113 releasesCRAN page ↗GitHub ↗

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.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("unpivotr", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("nacnudus/unpivotr")

Development version from nacnudus/unpivotr. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-unpivotr

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-unpivotr

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-unpivotr

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 2.1 min · r-devel-linux-x86_64-fedora-clang

Code health

Yes

Tests · ratio 0.88

99.5%

Coverage · measured lines

94%

Documentation · exports

Dependencies · direct

Check history

OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 723 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 100%
Return-value docs: 45%
References docs: 0%

Downloads

10.9K

CRAN downloads in the past year

Rank #6,861 · ~30/day · ~910/mo

Releases R versions

Daily download trend is not available in this view yet.

45630 days

1.5K90 days

10.9K1 year

Compare downloads with other packages →

Also on134 r2u33 autocran

Repository

GitHub ↗ nacnudus/unpivotr

188Stars

19Forks

3Open issues

1Open PRs

5Releases

649Commits

9Contributors

rexcelspreadsheetpivot-tables

649 commits · Last activity 2025-02-01 · 0% stars, 30d

Stars over time

2025-04-01 · 1852026-07-07 · 188

Repository practices

Upstream repositoryBeta

5 development-tooling and community-health practices detected across 5 families in the upstream repository

Checks run against github.com/nacnudus/unpivotr on 2026-07-19.

Continuous integration (1)

GitHub Actions

Reproducibility and dev environment (1)

data-raw/

CRAN release process (1)

cran-comments.md

Docs source (1)

README.Rmd

Show all practices

Coverage (1)

Codecov

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

24 external dependencies (excludes base and recommended)

Depends (1)

R >= 3.2.0

Imports (12)

methodsrlang magrittr dplyr forcats purrr tidyr pillar tibble cellranger xml2 tidyselect

LinkingTo (0)

none

Suggests (13)

knitr rmarkdown readr tidyxl readxl stringr htmltools rvest selectr DT testthat covr here

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

Code Composition

R 3,924 (65%)Rd 1,311 (22%)Vignettes 816 (13%)

Code characteristics

Object systems

S314

Cyclomatic complexity: 1.0 median / 9 max
Test cases: 74 / 0.88 per code line

Test coverage

Line coverage

100%

Expression

99.1%

Tests / Examples

99.5% / 83% ex

Functions

54 15 exported

Complexity

2 avg / 9 max

Call network

54 nodes / 38 edges

Call graph

Open call graph →

Loading call graph…

Lowest coverage

54 functions

Function	Cyclo	Coverage
direction_filter	1	67%
concatenate	9	97%
as_cells exp	1	100%
behead exp	1	100%
behead_if exp	1	100%
enhead exp	1	100%

People & History

People (1)

Maintainer (1)

Duncan Garmonsway

Author, Maintainer

Authors (1)

Duncan Garmonsway

Author, Maintainer

Package Timeline

13 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
0.6.4Latest
2024-11-30 · current release · diff ↗
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
0.6.3
2023-01-22 · diff ↗
R
R 4.2.0 released · 2022-04-22
0.6.2
2021-08-22 · diff ↗
R
R 4.1.0 released · 2021-05-18
0.6.1
2020-08-04 · diff ↗
0.6.0
2020-05-08 · diff ↗
R
R 4.0.0 released · 2020-04-24
R
R 3.6.0 released · 2019-04-26
0.5.1
2019-03-30 · diff ↗
0.5.0
2019-01-02 · diff ↗
0.4.0
2018-06-26 · diff ↗

Show 8 earlier events

R
R 3.5.0 released · 2018-04-23
0.3.1
2018-01-20 · diff ↗
0.3.0
2017-12-04 · diff ↗
0.2.1
2017-07-03 · diff ↗
0.1.1
2017-04-23 · diff ↗
R
R 3.4.0 released · 2017-04-21
0.1.0
2017-01-31
R
R 3.3.0 released · 2016-05-03

Package metadata

First published: 2017-01-31
Total releases: 13 / 9 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 3.2.0
Bundled data: 1.8 KB / 1 file
Download size: 3.7 MB
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →