Pass a vector of variable names to arrange() in dplyr

by

Hadley hasn’t made this obvious in the help file–only in his NSE vignette. The versions of the functions followed by underscores use standard evaluation, so you pass them vectors of strings and the like.

If I understand your problem correctly, you can just replace arrange() with arrange_() and it will work.

Specifically, pass the vector of strings as the .dots argument when you do it.

> df %>% arrange_(.dots=c("var1","var3"))
   var1 var2 var3 var4
1     1    i    5    i
2     1    x    7    w
3     1    h    8    e
4     2    b    5    f
5     2    t    5    b
6     2    w    7    h
7     3    s    6    d
8     3    f    8    e
9     4    c    5    y
10    4    o    8    c

========== Update March 2018 ==============

Using the standard evaluation versions in dplyr as I have shown here is now considered deprecated. You can read Hadley’s programming vignette for the new way. Basically you will use !! to unquote one variable or !!! to unquote a vector of variables inside of arrange().

When you pass those columns, if they are bare, quote them using quo() for one variable or quos() for a vector. Don’t use quotation marks. See the answer by Akrun.

If your columns are already strings, then make them names using rlang::sym() for a single column or rlang::syms() for a vector. See the answer by Christos. You can also use as.name() for a single column. Unfortunately as of this writing, the information on how to use rlang::sym() has not yet made it into the vignette I link to above (eventually it will be in the section on “variadic quasiquotation” according to his draft).

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. data.table vs dplyr: can one do something well the other can’t or does poorly?
  3. Extract a dplyr tbl column as a vector
  4. Pass arguments to dplyr functions
  5. dplyr::select function clashes with MASS::select
  6. Sum across multiple columns with dplyr
  7. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  8. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  9. dplyr mutate/replace several columns on a subset of rows
  10. dplyr: How to use group_by inside a function?
  11. How to sort a character vector where elements contain letters and numbers?
  12. dplyr mutate with conditional values
  13. Sort columns of a dataframe by column name
  14. dplyr – using column names as function arguments
  15. Get last row of each group in R [duplicate]
  16. dplyr on data.table, am I really using data.table?
  17. Set certain values to NA with dplyr
  18. dplyr::group_by_ with character string input of several variable names
  19. Use filter in dplyr conditional on an if statement in R
  20. combine two data frames with all posible combinations
  21. Find K nearest neighbors, starting from a distance matrix
  22. dplyr / R cumulative sum with reset
  23. finding close match from data frame 1 in data fame 2
  24. Add a column with count of NAs and Mean
  25. How does one stop using rowwise in dplyr?
  26. select columns based on multiple strings with dplyr contains()
  27. Error with select function from dplyr
  28. dplyr: put count occurrences into new variable [duplicate]
  29. Add row in each group using dplyr and add_row()
  30. How to replace certain values in a specific rows and columns with NA in R?

Leave a Comment