rollup (version 0.1.0)

grouping_sets: grouping_sets

Description

Compute total amounts at different group levels, producing multiple subtotals. With the 'grouping_sets' clause following 'group_by', you can aggregate multiple grouping variables in one operation. This reflects the 'GROUPING SETS' operations in 'SQL'.

Usage

grouping_sets(df, ...)

Value

A list of 'grouped_df' class. each 'grouped_df' object has a different grouping level.

Arguments

df

dataframe or grouped df

...

grouping variables

Examples

mtcars %>% group_by(vs, am) %>% grouping_sets("vs","am",c("vs","am")) 
mtcars %>% group_by(vs, am) %>% with_rollup() 
mtcars %>% group_by(vs, am) %>% with_cube()