Package: pivottabler 1.5.6

pivottabler: Create Pivot Tables

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.

Authors:Christopher Bailiss [aut, cre]

pivottabler_1.5.6.tar.gz
pivottabler_1.5.6.zip(r-4.7-any)pivottabler_1.5.6.zip(r-4.6-any)pivottabler_1.5.6.zip(r-4.5-any)
pivottabler_1.5.6.tgz(r-4.6-any)pivottabler_1.5.6.tgz(r-4.5-any)
pivottabler_1.5.6.tar.gz(r-4.7-any)pivottabler_1.5.6.tar.gz(r-4.6-any)
pivottabler_1.5.6.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
pivottabler/json (API)

# Install 'pivottabler' in R:

install.packages('pivottabler', repos = c('https://cbailiss.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/cbailiss/pivottabler/issues

Datasets:

bhmtraindisruption - Birmingham Train Disruptions, Dec 2016-Feb 2017.
bhmtrains - Birmingham Trains, Dec 2016-Feb 2017.
pvtperfresults - Performance Comparison Results
pvtperfsummary - Performance Comparison Summary
trainstations - Train Stations

On CRAN:

calculations html htmlwidget latex pivot-tables visualization

8.19 score 123 stars 2 packages 334 scripts 1.3k downloads 21 exports 38 dependencies

Last updated from:518d092564. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel	OK	171
source / vignettes	OK	213
linux-release	OK	152
macos-release	OK	229
macos-oldrel	OK	207
windows-devel	OK	135
windows-release	OK	147
windows-oldrel	OK	134
wasm-release	OK	119

Exports:getCompactTheme getDefaultTheme getLargePlainTheme getSimpleColoredTheme getStandardTableTheme getTheme PivotFilter PivotFilterOverrides PivotFilters PivotOpenXlsxStyle PivotOpenXlsxStyles PivotStyle PivotStyles PivotTable pivottabler pivottablerOutput qhpvt qlpvt qpvt renderBasicTable renderPivottabler

Dependencies:base64enc bslib cachem cli data.table digest dplyr evaluate fastmap fontawesome fs generics glue highr htmltools htmlwidgets jquerylib jsonlite knitr lifecycle magrittr memoise mime pillar pkgconfig R6 rappdirs rlang rmarkdown sass tibble tidyselect tinytex utf8 vctrs withr xfun yaml

Create Pivot Tables in R

Rendered fromv00-vignettes.Rmdusingknitr::rmarkdown

Last update: 2020-05-09
Started: 2020-02-03

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Birmingham Train Disruptions, Dec 2016-Feb 2017.	bhmtraindisruption
Birmingham Trains, Dec 2016-Feb 2017.	bhmtrains
Perform basic checks on a function argument.	checkArgument
Cleans up a CSS attribute value.	cleanCssValue
Clean the arguments specified for an outline group	cleanOutlineArg
Check whether a text value is present in another text value.	containsText
Convert a pivot table style to a basictabler style.	convertPvtStyleToBasicStyle
Convert a pivot table to a basic table.	convertPvtTblToBasicTbl
Expand hex.	expandHex
Replace the current value with a placeholder during export.	exportValueAs
Get an empty theme for applying no styling to a table.	getBlankTheme
Get the compact theme for styling a pivot table.	getCompactTheme
Get the default theme for styling a pivot table.	getDefaultTheme
Get the large plain theme for styling a pivot table.	getLargePlainTheme
Find the first value in an array that is larger than the specified value.	getNextPosition
Get pivot table style declarations from a pivot table style.	getPvtStyleDeclarations
Get a simple coloured theme.	getSimpleColoredTheme
Get the a theme for styling to a pivot table that looks more like a standard table (i.e. no row column headings).	getStandardTableTheme
Get a built-in theme for styling a pivot table.	getTheme
Convert CSS border values to those used by the openxlsx package.	getXlBorderFromCssBorder
Convert CSS border values to those used by the openxlsx package.	getXlBorderStyleFromCssBorder
Check whether a numeric value is present.	isNumericValue
Check whether a text value is present.	isTextValue
Convert a value of 1 to a NULL value.	oneToNULL
Convert a CSS colour into a hex based colour code.	parseColor
Parse a CSS border value.	parseCssBorder
Convert a CSS size value into points.	parseCssSizeToPt
Convert a CSS size value into pixels	parseCssSizeToPx
Split a CSS attribute value into a vector/array.	parseCssString
Parse an xl-border value.	parseXlBorder
R6 class the represents a Calculation Batch	PivotBatch
R6 class that calculates the values for multiple cells in batches.	PivotBatchCalculator
R6 class that provides summary statistics for batch calculations.	PivotBatchStatistics
R6 class that defines a calculation.	PivotCalculation
R6 class that defines a group of calculations.	PivotCalculationGroup
R6 class that contains multiple calculation groups.	PivotCalculationGroups
R6 class that computes the value of a cell or cells.	PivotCalculator
R6 class that represents a cell in a pivot table.	PivotCell
R6 class that contains the cells in a pivot table.	PivotCells
R6 class that contains named data frames and associated totals.	PivotData
R6 class that defines a row or column data group.	PivotDataGroup
R6 class that defines a filter condition.	PivotFilter
R6 class that defines a set of filter overrides.	PivotFilterOverrides
R6 class that defines a set of filter conditions.	PivotFilters
R6 class that renders a pivot table in HTML.	PivotHtmlRenderer
R6 class that renders a pivot table in Latex.	PivotLatexRenderer
R6 class that renders a pivot table into an Excel worksheet.	PivotOpenXlsxRenderer
R6 class that specifies Excel styling as used by the openxlsx package.	PivotOpenXlsxStyle
R6 class that defines a collection of Excel styles as used by the openxlsx package.	PivotOpenXlsxStyles
R6 class that specifies styling.	PivotStyle
R6 class that defines a collection of styles.	PivotStyles
R6 class that represents a pivot table.	PivotTable
Render a pivot table as a HTML widget.	pivottabler
Standard function for Shiny scaffolding.	pivottablerOutput
Handle an identifier that may be illegal (e.g. containing spaces).	processIdentifier
Handle identifiers that may be illegal (e.g. containing spaces).	processIdentifiers
Performance Comparison Results	pvtperfresults
Performance Comparison Summary	pvtperfsummary
Quickly render a basic pivot table in HTML.	qhpvt
Quickly get a Latex representation of a basic pivot table.	qlpvt
Quickly build a basic pivot table.	qpvt
Output a table into a package vignette.	renderBasicTable
Standard function for Shiny scaffolding.	renderPivottabler
Should the current value be skipped during export?	skipExportingValue
Train Stations	trainstations
Intersect two vectors without changing their data types.	typeSafeIntersect
Union two vectors without changing their data types.	typeSafeUnion
Unlist a list into a vector in a type-safe way where possible.	typeSafeUnlist
Convert a simple range expression to a standard R logical expression.	vreConvertSimpleNumericRange
Read the value from a single-valued value range expression.	vreGetSingleValue
Convert a colour in hex format (#RRGGBB) into a list.	vreHexToClr
Test if two numeric values are equal within tolerance.	vreIsEqual
Test whether a value matches a value range expression.	vreIsMatch
Determine if a value range expression is a simple range expression.	vreIsSimpleNumericRange
Determine if a value range expression is a single value.	vreIsSingleValue
Scale a number from a range into a colour gradient.	vreScale2Colours
Rescale a number from one range into another range.	vreScaleNumber