Programming with dplyr using string as input

by

dplyr >= 1.0

Use combination of double braces and the across function:

my_summarise2 <- function(df, group_var) {
  df %>% group_by(across({{ group_var }})) %>% 
    summarise(mpg = mean(mpg))
}

my_summarise2(mtcars, "cyl")

# A tibble: 3 x 2
#    cyl   mpg
#  <dbl> <dbl>
# 1     4  26.7
# 2     6  19.7
# 3     8  15.1

# same result as above, passing cyl without quotes
my_summarise(mtcars, cyl)

dplyr < 1.0

As far as I know, you could use as.name or sym (from the rlang package – I don’t know if dplyr will import it eventually):

library(dplyr)
my_summarise <- function(df, var) {
  var <- rlang::sym(var)
  df %>%
    group_by(!!var) %>%
    summarise(mpg = mean(mpg))
}

or

my_summarise <- function(df, var) {
  var <- as.name(var)
  df %>%
    group_by(!!var) %>%
    summarise(mpg = mean(mpg))
}

my_summarise(mtcars, "cyl")
# # A tibble: 3 × 2
#     cyl      mpg
#   <dbl>    <dbl>
# 1     4 26.66364
# 2     6 19.74286
# 3     8 15.10000

More Related Contents:

  1. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  2. How to create a lag variable within each group?
  3. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  4. Filter data frame by character column name (in dplyr)
  5. How to number/label data-table by group-number from group_by?
  6. Remove duplicated rows using dplyr
  7. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  8. dplyr: “Error in n(): function should not be called directly”
  9. dplyr: inner_join with a partial string match
  10. Count number of rows by group using dplyr
  11. Pass a vector of variable names to arrange() in dplyr
  12. Efficient way to filter one data frame by ranges in another
  13. R – add column that counts sequentially within groups but repeats for duplicates
  14. Categorize numeric variable with mutate
  15. Means multiple columns by multiple groups [duplicate]
  16. How to use map from purrr with dplyr::mutate to create multiple new columns based on column pairs
  17. Conditional cumsum with reset
  18. How to speed up subset by groups
  19. Use rle to group by runs when using dplyr
  20. Number of significant digits in dplyr summarise
  21. Calculate group mean while excluding current observation using dplyr
  22. Emulate split() with dplyr group_by: return a list of data frames
  23. Sparklyr: how to center a Spark table based on column?
  24. R: x ‘probs’ outside [0,1]
  25. dplyr::mutate to add multiple values
  26. Tilde Dot in R (~.)
  27. Changing factor levels with dplyr mutate
  28. Conditionally Count in dplyr
  29. How to filter data without losing NA rows using dplyr
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment