Arranging rows in custom order using dplyr

by

We can use factor to change the order in a custom way

df %>%
    arrange(factor(Reg, levels = LETTERS[c(3, 1, 2)]), desc(Res), desc(Pop))
#  Reg   Res    Pop
#1   C Urban 501638
#2   C Rural 499274
#3   A Urban 500414
#4   A Rural 500501
#5   B Urban 499922
#6   B Rural 500016

Or with match to get the index and arrange on it

df %>%
    arrange(match(Reg, c("C", "A", "B")), desc(Res), desc(Pop))

If we have multiple columns to arrange in descending order

df %>%
     arrange_at(2:3, desc) %>%
     arrange(match(Reg, c("C", "A", "B")))

More Related Contents:

  1. R: x ‘probs’ outside [0,1]
  2. Get first and last values per group – dplyr group_by with last() and first()
  3. Shifting non-NA cells to the left
  4. What does the dplyr period character “.” reference?
  5. Count non-NA values by group [duplicate]
  6. case_when in mutate pipe
  7. Summarize all group values and a conditional subset in the same call
  8. dplyr mutate with conditional values
  9. How to add a cumulative column to an R dataframe using dplyr?
  10. Concatenate unique strings after groupby in R
  11. Get last row of each group in R [duplicate]
  12. dplyr on data.table, am I really using data.table?
  13. Set certain values to NA with dplyr
  14. Use filter in dplyr conditional on an if statement in R
  15. combine two data frames with all posible combinations
  16. dplyr / R cumulative sum with reset
  17. finding close match from data frame 1 in data fame 2
  18. How does one stop using rowwise in dplyr?
  19. dplyr – groupby on multiple columns using variable names
  20. Subsetting a matrix by row.names
  21. grouped operations that result in length not equal to 1 or length of group in dplyr
  22. Create sequential counter that restarts on a condition within panel data groups [duplicate]
  23. Replacement for “rename” in dplyr
  24. mutate with case_when and contains
  25. r cumsum per group in dplyr
  26. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  27. dplyr::do() requires named function?
  28. loess regression on each group with dplyr::group_by()
  29. Adding column if it does not exist
  30. How to use Dplyr’s Summarize and which() to lookup min/max values

Leave a Comment