Package: pivottabler 1.5.5

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.5.tar.gz
pivottabler_1.5.5.zip(r-4.5)pivottabler_1.5.5.zip(r-4.4)pivottabler_1.5.5.zip(r-4.3)
pivottabler_1.5.5.tgz(r-4.4-any)pivottabler_1.5.5.tgz(r-4.3-any)
pivottabler_1.5.5.tar.gz(r-4.5-noble)pivottabler_1.5.5.tar.gz(r-4.4-noble)
pivottabler_1.5.5.tgz(r-4.4-emscripten)pivottabler_1.5.5.tgz(r-4.3-emscripten)
pivottabler.pdf |pivottabler.html✨
pivottabler/json (API)
NEWS

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

Peer review:

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

Datasets:

On CRAN:

calculationshtmlhtmlwidgetlatexpivot-tablesvisualization

21 exports 122 stars 4.52 score 39 dependencies 1 dependents 328 scripts 1.9k downloads

Last updated 12 months agofrom:337cba5d0c. Checks:OK: 3 NOTE: 4. Indexed: yes.

TargetResultDate
Doc / VignettesOKSep 04 2024
R-4.5-winNOTESep 04 2024
R-4.5-linuxNOTESep 04 2024
R-4.4-winNOTESep 04 2024
R-4.4-macNOTESep 04 2024
R-4.3-winOKSep 04 2024
R-4.3-macOKSep 04 2024

Exports:getCompactThemegetDefaultThemegetLargePlainThemegetSimpleColoredThemegetStandardTableThemegetThemePivotFilterPivotFilterOverridesPivotFiltersPivotOpenXlsxStylePivotOpenXlsxStylesPivotStylePivotStylesPivotTablepivottablerpivottablerOutputqhpvtqlpvtqpvtrenderBasicTablerenderPivottabler

Dependencies:base64encbslibcachemclidata.tabledigestdplyrevaluatefansifastmapfontawesomefsgenericsgluehighrhtmltoolshtmlwidgetsjquerylibjsonliteknitrlifecyclemagrittrmemoisemimepillarpkgconfigR6rappdirsrlangrmarkdownsasstibbletidyselecttinytexutf8vctrswithrxfunyaml

Create Pivot Tables in R

Chris Bailiss

Rendered fromv00-vignettes.Rmdusingknitr::rmarkdownon Sep 04 2024.

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

Readme and manuals

Help Manual

Help pageTopics
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 groupcleanOutlineArg
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
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 pixelsparseCssSizeToPx
Split a CSS attribute value into a vector/array.parseCssString
Parse an xl-border value.parseXlBorder
R6 class the represents a Calculation BatchPivotBatch
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 Resultspvtperfresults
Performance Comparison Summarypvtperfsummary
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 Stationstrainstations
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