pass the column name as variable to dplyr summarise

Asked Feb 07 '22 at 16:32

Active Feb 07 '22 at 16:32

Viewed 40 times

I want to get the mean and sd for several columns in a tibble.

I tried to pass the column as variable to summarise as the following:

t<-tibble(col1=1:10,col2=3)
s="col1"
t %>%
  dplyr::summarise(Mean=mean(noquote(s),na.rm=T),
                   sd=sd(noquote(s),na.rm=T))

This didn't work, it is giving

 Mean SD
1   NA NA

How to pass the column name as variable to dplyr summarise?

asked Feb 07 '22 at 16:32

Mariya

2

Use `!! sym(s)` instead of `noquote`. – TimTeaFan Feb 07 '22 at 16:34
1

`.data[[s]]` works as well. See https://dplyr.tidyverse.org/articles/programming.html. – r2evans Feb 07 '22 at 16:36
Or alternately this: [Filter data frame by character column name (in dplyr)](https://stackoverflow.com/q/27197617/8366499) – divibisan Feb 07 '22 at 16:39
@TimTeaFan sym(s) is returning NA too same as noquoute! – Mariya Feb 07 '22 at 17:35
1

@Mariya: This `dplyr::summarise(Mean=mean(!! sym(s),na.rm=T)` is returning `5.5`. – TimTeaFan Feb 07 '22 at 20:42
@TimTeaFan thank you it is working! what is the meaning of the !! ? – Mariya Feb 08 '22 at 12:50

0 Answers0