Breaking News: Grepper is joining You.com. Read the official announcement!

group by sum, mean, min, max etc. in r

Oguzalp B. answered on November 14, 2022 Popularity 9/10 Helpfulness 6/10

answer group by sum, mean, min, max etc. in r

group by sum, mean, min, max etc. in r

Comment

# several summary columns with arbitrary names
library(dplyr)
mtcars %>% 
  group_by(cyl, gear) %>%                            # multiple group columns
  summarise(sum_hp = sum(hp), mean_mpg = mean(mpg))  # multiple summary columns

# summarise all columns except grouping columns using "sum" 
mtcars %>% 
  group_by(cyl) %>% 
  summarise(across(everything(), sum))

# summarise all columns except grouping columns using "sum" and "mean"
mtcars %>% 
  group_by(cyl) %>% 
  summarise(across(everything(), list(mean = mean, sum = sum)))

Popularity 9/10 Helpfulness 6/10 Language whatever

Source: stackoverflow.com

Tags: group-by max mean r sum whatever

Link to this answer
Share Copy Link