r - Use paste command with dplyr

Question

I am trying to use paste command in order to paste some part of string into command group_by from dyplyr. This how is look like code normally without paste.

library(dplyr)
   DATA1<-DATA%>%
dplyr::group_by(id_n,gross_income)%>%
dplyr::summarize(gross_i=sum(gross_i)

So now I want to use paste command, and I try with this line of code.

  query_type1<-"id_n,gross_income"

Next step is to implement this line of code in code above.

   DATA1<-DATA%>%
dplyr::group_by(query_type1)%>%
dplyr::summarize(gross_i=sum(gross_i)

But unfortunately this don't give me good result. So can anybody help me how to fix this line of code?

Answer 1

As others have already suggested have column names as vector instead of one comma-separated string.

query_type1<- c("id_n","gross_income")

You can then use across in group_by :

library(dplyr)

DATA%>%
  group_by(across(query_type1)) %>%
  summarize(gross_i=sum(gross_i)