Reorder rows using custom order

by

First, create a vector with the letters in the desired order. Then match* the vector with the variable to be sorted. match returns indices of (first) matches, which can be plugged into slice:

library(dplyr)

# create a vector with letters in the desired order
x <- c("C", "A", "B")

DT %>%
  slice(match(x, category))
#   category b
# 1        C 3
# 2        A 1
# 3        B 2

Another way would be to convert “category” to a factor, set levels to the desired order, and use arrange:

DT %>%
  mutate(category =  factor(category, levels = x)) %>%
  arrange(category)    
#   category b
# 1        C 3
# 2        A 1
# 3        B 2

*The match method is inspired by this answer.

More Related Contents:

  1. Summarizing multiple columns with dplyr? [duplicate]
  2. Relative frequencies / proportions with dplyr
  3. Unique rows, considering two columns, in R, without order
  4. standard evaluation in dplyr: summarise a variable given as a character string
  5. How to number/label data-table by group-number from group_by?
  6. Use variable names in functions of dplyr
  7. Create new variables with mutate_at while keeping the original ones
  8. How to interpret dplyr message `summarise()` regrouping output by ‘x’ (override with `.groups` argument)?
  9. Finding percentage in a sub-group using group_by and summarise
  10. Make a group_indices based on several columns
  11. Using spread with duplicate identifiers for rows
  12. filter for complete cases in data.frame using dplyr (case-wise deletion)
  13. dplyr filter with condition on multiple columns
  14. dplyr – using column names as function arguments
  15. Fill missing dates by group
  16. Change value of variable with dplyr
  17. dplyr – filter by group size
  18. dplyr::group_by_ with character string input of several variable names
  19. How to parametrize function calls in dplyr 0.7?
  20. How to filter rows based on difference in dates between rows in R?
  21. How to do range grouping on a column using dplyr?
  22. R – Group by variable and then assign a unique ID [duplicate]
  23. Performing dplyr mutate on subset of columns
  24. R sum a variable by two groups [duplicate]
  25. Join two data frames in R based on closest timestamp
  26. data.table row-wise sum, mean, min, max like dplyr?
  27. Update/Replace Values in Dataframe with Tidyverse Join
  28. Run a custom function on a data frame in R, by group
  29. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment