The summarise function in R returns one row for each combination of grouping variables. Note that summarise() and summarize() are synonyms. Summarise is part of dplyr.
library(tidyverse) data <- mtcars data %>% summarize(avg_mpg = mean(mpg)) data %>% summarize(avg_mpg = mean(mpg), median_mpg = median(mpg), avg_weight = mean(wt)) # get the number of distinct cylinder configurations data %>% summarize(unique_cyl = n_distinct(cyl))
Here is the output on the console of RStudio.
> library(tidyverse) > data <- mtcars > data %>% summarize(avg_mpg = mean(mpg)) avg_mpg 1 20.09062 > data %>% summarize(avg_mpg = mean(mpg), + median_mpg = median(mpg), + avg_weight = mean(wt)) avg_mpg median_mpg avg_weight 1 20.09062 19.2 3.21725 > # get the number of distinct cylinder configurations > data %>% summarize(unique_cyl = n_distinct(cyl)) unique_cyl 1 3
Here is summarize_all.
> data %>% summarize_all(list(mean), na.rm = TRUE) mpg cyl disp hp drat wt qsec vs am gear carb 1 20.09062 6.1875 230.7219 146.6875 3.596563 3.21725 17.84875 0.4375 0.40625 3.6875 2.8125