Learn R Programming

⚠️There's a newer version (1.5.6) of this package.Take me there.

pivottabler (version 1.5.0)

Create Pivot Tables

Description

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.

Copy Link

Version

Install

install.packages('pivottabler')

Monthly Downloads

2,230

Version

1.5.0

License

GPL-3

Issues

Pull Requests

Stars

Forks

Maintainer

Christopher Bailiss

Last Published

June 16th, 2020

Functions in pivottabler (1.5.0)

PivotCell

R6 class that represents a cell in a pivot table.
PivotBatchStatistics

R6 class that provides summary statistics for batch calculations.
PivotCalculationGroup

R6 class that defines a group of calculations.
PivotCalculator

R6 class that computes the value of a cell or cells.
PivotCalculation

R6 class that defines a calculation.
PivotCalculationGroups

R6 class that contains multiple calculation groups.
PivotData

R6 class that contains named data frames and associated totals.
PivotCells

R6 class that contains the cells in a pivot table.
PivotBatch

R6 class the represents a Calculation Batch
PivotBatchCalculator

R6 class that calculates the values for multiple cells in batches.
PivotHtmlRenderer

R6 class that renders a pivot table in HTML.
PivotStyle

R6 class that specifies styling.
PivotOpenXlsxStyles

R6 class that defines a collection of Excel styles as used by the openxlsx package.
PivotDataGroup

R6 class that defines a row or column data group.
PivotFilter

R6 class that defines a filter condition.
PivotLatexRenderer

R6 class that renders a pivot table in Latex.
PivotFilters

R6 class that defines a set of filter conditions.
PivotFilterOverrides

R6 class that defines a set of filter overrides.
PivotOpenXlsxRenderer

R6 class that renders a pivot table into an Excel worksheet.
PivotOpenXlsxStyle

R6 class that specifies Excel styling as used by the openxlsx package.
cleanCssValue

Cleans up a CSS attribute value.
checkArgument

Perform basic checks on a function argument.
cleanOutlineArg

Clean the arguments specified for an outline group
bhmtraindisruption

Birmingham Train Disruptions, Dec 2016-Feb 2017.
getTheme

Get a built-in theme for styling a pivot table.
getStandardTableTheme

Get the a theme for styling to a pivot table that looks more like a standard table (i.e. no row column headings).
getNextPosition

Find the first value in an array that is larger than the specified value.
getLargePlainTheme

Get the large plain theme for styling a pivot table.
bhmtrains

Birmingham Trains, Dec 2016-Feb 2017.
containsText

Check whether a text value is present in another text value.
parseCssBorder

Parse a CSS border value.
parseCssSizeToPx

Convert a CSS size value into pixels
parseCssString

Split a CSS attribute value into a vector/array.
getPvtStyleDeclarations

Get pivot table style declarations from a pivot table style.
PivotTable

R6 class that represents a pivot table.
parseXlBorder

Parse an xl-border value.
pvtperfsummary

Performance Comparison Summary
pivottabler

Render a pivot table as a HTML widget.
vreIsMatch

Test whether a value matches a value range expression.
vreConvertSimpleNumericRange

Convert a simple range expression to a standard R logical expression.
PivotStyles

R6 class that defines a collection of styles.
parseCssSizeToPt

Convert a CSS size value into points.
vreIsSimpleNumericRange

Determine if a value range expression is a simple range expression.
convertPvtStyleToBasicStyle

Convert a pivot table style to a basictabler style.
convertPvtTblToBasicTbl

Convert a pivot table to a basic table.
vreHexToClr

Convert a colour in hex format (#RRGGBB) into a list.
qhpvt

Quickly render a basic pivot table in HTML.
vreIsEqual

Test if two numeric values are equal within tolerance.
getDefaultTheme

Get the default theme for styling a pivot table.
getCompactTheme

Get the compact theme for styling a pivot table.
getXlBorderFromCssBorder

Convert CSS border values to those used by the openxlsx package.
vreGetSingleValue

Read the value from a single-valued value range expression.
exportValueAs

Replace the current value with a placeholder during export.
oneToNULL

Convert a value of 1 to a NULL value.
getSimpleColoredTheme

Get a simple coloured theme.
parseColor

Convert a CSS colour into a hex based colour code.
getBlankTheme

Get an empty theme for applying no styling to a table.
isNumericValue

Check whether a numeric value is present.
getXlBorderStyleFromCssBorder

Convert CSS border values to those used by the openxlsx package.
isTextValue

Check whether a text value is present.
processIdentifiers

Handle identifiers that may be illegal (e.g. containing spaces).
pvtperfresults

Performance Comparison Results
qlpvt

Quickly get a Latex representation of a basic pivot table.
processIdentifier

Handle an identifier that may be illegal (e.g. containing spaces).
renderPivottabler

Standard function for Shiny scaffolding.
renderBasicTable

Output a table into a package vignette.
pivottablerOutput

Standard function for Shiny scaffolding.
skipExportingValue

Should the current value be skipped during export?
qpvt

Quickly build a basic pivot table.
trainstations

Train Stations
vreIsSingleValue

Determine if a value range expression is a single value.
vreScale2Colours

Scale a number from a range into a colour gradient.
vreScaleNumber

Rescale a number from one range into another range.