R Observatory: Metrics for pivot version 18.4.17

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

This package was removed from CRAN on 2019-05-08. Its history is shown below.

Reason: check problems were not corrected in time

Details below reflect version 18.4.17, its last release before removal.

pivot

18.4.17Package record

'SQL' PIVOT and UNPIVOT

0packages depend

–downloads / year

–test coverage

–flavors OK

Overview

About

Maintained by Andrew ReddCRAN page ↗

Extends the 'tidyverse' packages 'dbplyr' and 'tidyr' functionality with pivot(), i.e. spread(), and unpivot(), i.e. gather(), for reshaping remote tables. Currently only 'Microsoft SQL Server' is supported.

Changes in 18.4.17

Initial Release

From NEWS.md in the release

Install

R (source archive)

url <- "https://cran.r-project.org/src/contrib/Archive/pivot/pivot_18.4.17.tar.gz"
pkgFile <- "pivot_18.4.17.tar.gz"
download.file(url, pkgFile)
install.packages(pkgFile, type = "source", repos = NULL)

This package is no longer on CRAN, so install.packages() cannot fetch it by name. This downloads the last archived source (18.4.17) and builds it locally. Install its dependencies first, and note that building from source needs the usual compiler toolchain.

Health

CRAN checks

CRAN check results are not tracked yet.

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 18.4.17

READMEYes · 120 wordsVignettesNoNEWSYes · 67% structured · mentions 18.4.17Citation fileNoWebsitenot declared in DESCRIPTION

Help pages: 6
Examples that run: 100%4 run in a plain check
Exported functions with examples: 67%
Documented parameters: 100%
Return-value docs: 0%
Help pages citing references: 0%

How these are measured

Downloads

pivot Releases R versions

Daily download trend is not available in this view yet.

Compare downloads with other packages →

Also on97 c2d4u

How downloads are counted

Dependencies

Declared dependencies

13 external dependencies (excludes base and recommended)

Depends (1)

R >= 3.4.0

Imports (11)

assertthat dplyr dbplyr DBI magrittr purrr rlang tidyselect tidyr lubridate colorspace

LinkingTo (0)

none

Suggests (2)

testthat covr

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

–indirect (not tracked)

Nothing depends on this yet.

How these are counted

Code & Tests

People & History

People (1)

Andrew Redd

Author, Maintainer since 18.4.17 (2018)

Releases (1)

R
R 4.0.0 released · 2020-04-24
archivedRemoved from CRAN
2019-05-08
check problems were not corrected in time
R
R 3.6.0 released · 2019-04-26
18.4.17
record
2018-05-01
R
R 3.5.0 released · 2018-04-23

Package metadata

First published: 2018-05-01
Total releases: 1 / 8 yrs
License: Unlimited
Minimum R: ≥ 3.4.0

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("pivot")

Format

Redd, A. (n.d.). pivot: 'SQL' PIVOT and UNPIVOT (Version 18.4.17) [Computer software]. Retrieved October 26, 2026, from https://CRAN.R-project.org/package=pivot

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for pivot version 18.4.17 [Data set]. HJJB, LLC. Data release v2026-10-26. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-26, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →