pivottabler

1.5.6

Create Pivot Tables

3packages depend

22Kdownloads / year

45.7%test coverage

12/13checks pass

Overview

About

Maintained by Christopher BailissFirst published 2017-03-2720 releasesCRAN page ↗GitHub ↗

Create regular pivot tables with just a few lines of R. More complex pivot tables can also be created, e.g. pivot tables with irregular layouts, multiple calculations and/or derived calculations based on multiple data frames. Pivot tables are constructed using R only and can be written to a range of output formats (plain text, 'HTML', 'Latex' and 'Excel'), including with styling/formatting.

Install

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

install.packages("pivottabler", 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("cbailiss/pivottabler")

Development version from cbailiss/pivottabler. 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-pivottabler

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-pivottabler

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-pivottabler

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

Health

CRAN checks

1NOTE12OK

Failing flavors

NOTE r-devel-linux-x86_64-debian-gcc

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

Code health

Yes

Tests · ratio 0.60

45.7%

Coverage · measured lines

100%

Documentation · exports

Dependencies · direct

Check history

NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
WARNING2026-06-08
12 OK · 0 NOTE · 1 WARNING · 0 ERROR · 0 FAILURE
OK2026-04-25
12 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-03-10
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMENoVignettesYes · staticpkgdown siteNoNEWSYes · 33% structuredCode of conductNoContributing guideNo

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

Downloads

22K

CRAN downloads in the past year

Rank #3,279 · ~60/day · ~1.8K/mo

Releases R versions

Daily download trend is not available in this view yet.

1K30 days

3.6K90 days

22K1 year

Compare downloads with other packages →

Also on178 r2u4 autocran

Repository

GitHub ↗ cbailiss/pivottabler

124Stars

20Forks

13Open issues

3Open PRs

22Releases

486Commits

2Contributors

rpivot-tablescalculationsvisualizationhtmlwidgethtmllatex

486 commits · Last activity 2025-08-14 · 0% stars, 30d

Stars over time

2025-06-05 · 1222026-07-07 · 124

Repository practices

Upstream repositoryBeta

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

Checks run against github.com/cbailiss/pivottabler on 2026-07-31.

Continuous integration (1)

GitHub Actions

CRAN release process (1)

cran-comments.md

Docs source (1)

README.Rmd

Lint, format, editor (1)

RStudio project

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

Dependencies

Declared dependencies

15 external dependencies (excludes base and recommended)

Depends (1)

R >= 3.3.0

Imports (5)

R6 dplyr data.table htmltools htmlwidgets

LinkingTo (0)

none

Suggests (10)

ggplot2 jsonlite lubridate listviewer openxlsx basictabler (>= 1.0.2)shiny knitr rmarkdown testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

3direct

0indirect

shinypivottabler rolap vaersvax

Code & Tests

Datasets

People & History

People (1)

Maintainer (1)

Christopher Bailiss

Author, Maintainer

Authors (1)

Christopher Bailiss

Author, Maintainer

Package Timeline

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

R
R 4.6.0 released · 2026-04-24
1.5.6Latest
2025-04-22 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
1.5.5
2023-10-01 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.5.4
2022-10-04 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.5.3
2021-06-27 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.5.2
2021-05-12 · diff ↗
1.5.1
2021-03-11 · diff ↗
1.5.0
2020-06-16 · diff ↗
1.4.0
2020-05-11 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.3.1
2020-04-01 · diff ↗

Show 15 earlier events

1.3.0
2020-02-03 · diff ↗
1.2.3
2019-11-01 · diff ↗
1.2.2
2019-09-20 · diff ↗
1.2.1
2019-08-06 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.2.0
2019-03-21 · diff ↗
1.1.0
2019-02-17 · diff ↗
1.0.0
2018-10-18 · diff ↗
R
R 3.5.0 released · 2018-04-23
0.4.0
2017-10-02 · diff ↗
0.3.0
2017-06-02 · diff ↗
0.2.0
2017-04-29 · diff ↗
R
R 3.4.0 released · 2017-04-21
0.1.0
2017-03-27
R
R 3.3.0 released · 2016-05-03

Package metadata

First published: 2017-03-27
Total releases: 20 / 9 yrs
License: GPL-3 OSI
Minimum R: ≥ 3.3.0
Bundled data: 1.0 MB / 5 files
Download size: 2.5 MB
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →