pivot_table: pivot_table() and pivot_chart()

In BAAQMD/tbltools: Read/Write and Manipulate Tabular Data

pivot_table() and pivot_chart()

Description

Create an interactive pivot table (or chart). Tailored for emission-inventory data.

Usage

pivot_table(
  input_data,
  rows,
  columns,
  values,
  aggregator = "Sum",
  renderer = "Heatmap",
  skip_years,
  inclusions = list(),
  menuLimit = 6000,
  file = NULL,
  sorters = list(pol_abbr = c("PM", "PM2.5", "PM10", "TOG", "ROG", "NOx", "SO2", "CO",
    "CO2", "CH4", "N2O", "HFC+PFC", "NH3")),
  ...,
  verbose = getOption("verbose")
)

pivot_chart(..., renderer = "Area Chart", verbose = getOption("verbose"))

Arguments

rows	(character) required (can be a single value or a vector)
columns	(character) looks for year
values	(character) looks for ems_qty or tput_qty
aggregator	(character) passed to rpivotTable()
renderer	(character) passed to rpivotTable()
skip_years	(optional) drop some years
inclusions	(list) passed to rpivotTable::rpivotTable()
menuLimit	(integer) passed to rpivotTable::rpivotTable()
sorters	(list) expert use only
...	further arguments to rpivotTable::rpivotTable()
verbose	(logical)

See Also

• inventory conventions for tabular data

• the rpivotTable R package

• the Javascript PivotTable.js library

BAAQMD/tbltools documentation built on Feb. 29, 2024, 5:45 a.m.