aggregateData: Performs a temporal aggregation of a data frame
In matman: Material Management

Description Usage Arguments Value Author(s) See Also Examples

Aggregates a data frame based on a timestamp column to days, weeks, months, quarters, years or total.

aggregateData(
  data,
  value = NULL,
  item,
  timestamp,
  temporalAggregation = c("day", "week", "month", "quarter", "year", "total"),
  fiscal = 1,
  aggregationFun = sum
)

`data`	Data frame or matrix on which the ABC analysis is performed.
`value`	Name(s) of the column variable(s) that contains the values for the ABC and XYZ analysis.
`item`	Names of the columns including the item names or identifiers (e.g., product name, EAN).
`timestamp`	Name of the column including the timestamp. This column should be in POSIX or Date-format.
`temporalAggregation`	Temporal aggregation mode for the XYZ-analysis. Possible modes are 'day', 'week', 'month', 'quarter', 'year', and 'total'. Total only aggregates by item whereas the other modes aggregate by item an temporal unit.
`fiscal`	consider the start of the business year. Default is set to 1 (January)
`aggregationFun`	Function for aggregating the value column. Default is `sum`.

Returns a data frame with the aggregated data with the columns of item, timestamp and sum, which is the sum of the value column.

Leon Binder leon.binder@th-deg.de

Bernhard Bauer bernhard.bauer@th-deg.de

Michael Scholz michael.scholz@th-deg.de

expandData

data('Amount')
aggregatedData = aggregateData(data = Amount,
    value = "value",
    item = "item",
    timestamp = "date",
    temporalAggregation = "quarter")