Order data frame rows according to vector with specific order

by

Try match:

df <- data.frame(name=letters[1:4], value=c(rep(TRUE, 2), rep(FALSE, 2)))
target <- c("b", "c", "a", "d")
df[match(target, df$name),]

  name value
2    b  TRUE
3    c FALSE
1    a  TRUE
4    d FALSE

It will work as long as your target contains exactly the same elements as df$name, and neither contain duplicate values.

From ?match:

match returns a vector of the positions of (first) matches of its first argument 
in its second.

Therefore match finds the row numbers that matches target‘s elements, and then we return df in that order.

More Related Contents:

  1. Sort (order) data frame rows by multiple columns
  2. How does one reorder columns in a data frame?
  3. How to quickly form groups (quartiles, deciles, etc) by ordering column(s) in a data frame
  4. Merge two data frames while keeping the original row order
  5. How to sort a data frame in R
  6. How to sort a data frame by date
  7. How to sort all dataframes in a list of dataframes on the same column?
  8. Move NAs to the end of each column in a data frame
  9. How to sum a variable by group
  10. How do I make a list of data frames?
  11. Split data frame string column into multiple columns
  12. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  13. Filtering a data frame on a vector [duplicate]
  14. How to replace NA values in a table for selected columns
  15. Sample n random rows per group in a dataframe
  16. Select every nth row from dataframe
  17. Remove Rows From Data Frame where a Row matches a String
  18. duplicates in multiple columns
  19. Sorting each row of a data frame [duplicate]
  20. R – add column that counts sequentially within groups but repeats for duplicates
  21. Extend contigency table with proportions (percentages)
  22. R self reference
  23. Sort year-month column by year AND month
  24. Merge or combine by rownames
  25. How to add new column to an dataframe (to the front not end)?
  26. Find columns with all missing values
  27. How to transpose a dataframe in tidyverse?
  28. Deleting every n-th row in a dataframe
  29. Replace specific values based on another dataframe
  30. How to convert certain columns only to numeric?

Leave a Comment