Non-standard evaluation (NSE) in dplyr’s filter_ & pulling data from MySQL

by

It’s not really related to SQL. This example in R does not work either:

df <- data.frame(
     v1 = sample(5, 10, replace = TRUE),
     v2 = sample(5,10, replace = TRUE)
)
df %>% filter_(~ "v1" == 1)

It does not work because you need to pass to filter_ the expression ~ v1 == 1 — not the expression ~ "v1" == 1.

To solve the problem, simply use the quoting operator quo and the dequoting operator !!

library(dplyr)
which_column = quot(v1)
df %>% filter(!!which_column == 1)

More Related Contents:

  1. Extract a dplyr tbl column as a vector
  2. Pass arguments to dplyr functions
  3. Summarizing multiple columns with dplyr? [duplicate]
  4. Relative frequencies / proportions with dplyr
  5. Unique rows, considering two columns, in R, without order
  6. standard evaluation in dplyr: summarise a variable given as a character string
  7. dplyr: “Error in n(): function should not be called directly”
  8. Use variable names in functions of dplyr
  9. Create new variables with mutate_at while keeping the original ones
  10. How to interpret dplyr message `summarise()` regrouping output by ‘x’ (override with `.groups` argument)?
  11. Finding percentage in a sub-group using group_by and summarise
  12. Make a group_indices based on several columns
  13. Using spread with duplicate identifiers for rows
  14. filter for complete cases in data.frame using dplyr (case-wise deletion)
  15. dplyr filter with condition on multiple columns
  16. Change value of variable with dplyr
  17. Categorize numeric variable with mutate
  18. sample rows of subgroups from dataframe with dplyr
  19. Assigning Dates to Fiscal Year
  20. filter function in dplyr errors: object ‘name’ not found
  21. Conditional cumsum with reset
  22. Create a ranking variable with dplyr?
  23. How to pass dynamic column names in dplyr into custom function?
  24. R – Group by variable and then assign a unique ID [duplicate]
  25. R sum a variable by two groups [duplicate]
  26. Join two data frames in R based on closest timestamp
  27. data.table row-wise sum, mean, min, max like dplyr?
  28. Update/Replace Values in Dataframe with Tidyverse Join
  29. dplyr summarize with subtotals
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment