useR! 2024

Group-wise aggregation is one of the most common operations in data analyses.. There are use cases where the grouping is determined dynamically by collapsing smaller subsets into larger ones, to ensure sufficient support for the target aggregate. Examples include cases where some of the target groups suffer from missing data, or cases where the quality of target group data is judged to be too low. Often, hierarchical classifications serve as a basis for forming larger groups, but custom 'collapsing schemes' are in use as well. In this presentation we demonstrate the R package 'accumulate' [1] that offers interfaces for defining grouped aggregation, where the grouping may be dynamically determined, based on user-defined aggregations, user-defined decision rules, and user-defined collapsing schemes. The package offers several ways to define collapsing schemes, including tabular definitions that can be maintained separately from the aggregation code. It also includes facilities to use hierarchical classifications and for testing the (possibly complex) decision rules that user can create. [1] https://cran.r-project.org/package=accumulate