Learn R Programming

pivot

License Disclaimer

This pacakge was developed through funding and resources by the United States Veterans Health Administration and the VA Informatic and Computing Infrastructure (VINCI) by govornment employees. As such according to 17 U.S. Code §105 is not covered by copyright and is released to the public domain with no license restrictions. This code is released without any guarantee of suitability for any purpose.

Overview

The pivot R pacakge extends the capabilities of dbplyr to have pivot and unpivot capabilities. It currently works only for Microsoft SQL Server. For convenience it also provides extentions to the tidyr functions spread and gather to act on remote Microsoft SQL Tables without needing to collect the data first.

Copy Link

Version

Install

install.packages('pivot')

Monthly Downloads

2

Version

18.4.17

License

Unlimited

Maintainer

Andrew Redd

Last Published

May 1st, 2018

Functions in pivot (18.4.17)

unpivot

Un-pivot a table
pivot

Pivot a table
pivot_query

Create a pivot query representation
sql_pivot

Create a Pivot Query
sql_unpivot

Create an unpivot query
unpivot_query

Create a pivot query representation