pivottabler v1.5.0
0
Monthly downloads
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.
Functions in pivottabler
| Name | Description | |
| 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. | |
| No Results! | ||
Vignettes of pivottabler
Last month downloads
Details
| Type | Package |
| License | GPL-3 |
| Encoding | UTF-8 |
| LazyData | true |
| URL | http://www.pivottabler.org.uk/, https://github.com/cbailiss/pivottabler |
| BugReports | https://github.com/cbailiss/pivottabler/issues |
| VignetteBuilder | knitr |
| RoxygenNote | 7.1.0 |
| NeedsCompilation | no |
| Packaged | 2020-06-16 10:08:18 UTC; Chris |
| Repository | CRAN |
| Date/Publication | 2020-06-16 16:20:03 UTC |
| suggests | basictabler (>= 0.2.0) , ggplot2 (>= 2.2.0) , jsonlite (>= 1.1) , knitr , listviewer (>= 1.4.0) , lubridate (>= 1.5.0) , openxlsx (>= 4.0.17) , rmarkdown , shiny , testthat |
| imports | data.table (>= 1.10.0) , dplyr (>= 0.5.0) , htmltools (>= 0.3.5) , htmlwidgets (>= 0.8) , R6 (>= 2.2.0) |
| depends | R (>= 3.3.0) |
| Contributors |
Include our badge in your README
[](http://www.rdocumentation.org/packages/pivottabler)