desc_groups.RdCalculate the means (or other function) per group to analyze how each segment behave. It scales each variable mean inti the 0 to 1 range to easily profile the groups according to its mean. It also calculate the mean regardless the grouping. This function is also useful when you want to profile cluster results in terms of its means. It automatically adds a row representing the sumarization of the column regardless the group_var categories, this is useful to compare each segement with the whole population. It will exclude all factor/character variables.
desc_groups(data, group_var, group_func = mean, add_all_data_row = T)
| data | input data source |
|---|---|
| group_var | variable to make the group by |
| group_func | the data type of this parameter is a function, not an string, this is the function to be used in the group by, the default value is: mean |
| add_all_data_row | flag indicating if final data contains the row: 'All_Data', which is the function applied regardless the grouping. Useful to compare with the rest of the values. |
grouped data frame
# default grouping function: mean desc_groups(data=mtcars, group_var="cyl")#> cyl mpg disp hp drat wt qsec vs am #> 1 4 26.66000 105.1400 82.6400 4.070000 2.29000 19.14000 0.9100 0.73000 #> 2 6 19.74000 183.3100 122.2900 3.590000 3.12000 17.98000 0.5700 0.43000 #> 3 8 15.10000 353.1000 209.2100 3.230000 4.00000 16.77000 0.0000 0.14000 #> 4 All_Data 20.09062 230.7219 146.6875 3.596563 3.21725 17.84875 0.4375 0.40625 #> gear carb #> 1 4.0900 1.5500 #> 2 3.8600 3.4300 #> 3 3.2900 3.5000 #> 4 3.6875 2.8125# using the median as the grouping function desc_groups(data=mtcars, group_var="cyl", group_func=median)#> cyl mpg disp hp drat wt qsec vs am gear carb #> 1 4 26.0 108.0 91.0 4.080 2.200 18.90 1 1 4 2.0 #> 2 6 19.7 167.6 110.0 3.900 3.210 18.30 1 0 4 4.0 #> 3 8 15.2 350.5 192.5 3.120 3.750 17.18 0 0 3 3.5 #> 4 All_Data 19.2 196.3 123.0 3.695 3.325 17.71 0 0 4 2.0# using the max as the grouping function desc_groups(data=mtcars, group_var="gear", group_func=max)#> gear mpg cyl disp hp drat wt qsec vs am carb #> 1 3 21.5 8 472.0 245 3.73 5.420 20.22 1 0 4 #> 2 4 33.9 6 167.6 123 4.93 3.440 22.90 1 1 4 #> 3 5 30.4 8 351.0 335 4.43 3.570 16.90 1 1 8 #> 4 All_Data 33.9 8 472.0 335 4.93 5.424 22.90 1 1 8