Filtering a data frame on a vector [duplicate]

by

You can use the %in% operator:

> df <- data.frame(id=c(LETTERS, LETTERS), x=1:52)
> L <- c("A","B","E")
> subset(df, id %in% L)
   id  x
1   A  1
2   B  2
5   E  5
27  A 27
28  B 28
31  E 31

If your IDs are unique, you can use match():

> df <- data.frame(id=c(LETTERS), x=1:26)
> df[match(L, df$id), ]
  id x
1  A 1
2  B 2
5  E 5

or make them the rownames of your dataframe and extract by row:

> rownames(df) <- df$id
> df[L, ]
  id x
A  A 1
B  B 2
E  E 5

Finally, for more advanced users, and if speed is a concern, I’d recommend looking into the data.table package.

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Subset data frame based on number of rows per group
  3. Opposite of %in%: exclude rows with values specified in a vector
  4. How to drop columns by name in a data frame
  5. Subset / filter rows in a data frame based on a condition in a column
  6. How do I extract a single column from a data.frame as a data.frame?
  7. Subset dataframe by multiple logical conditions of rows to remove
  8. Subset data frame based on multiple conditions [duplicate]
  9. Subset of rows containing NA (missing) values in a chosen column of a data frame
  10. dplyr – filter by group size
  11. How to subset data in R without losing NA rows?
  12. Using grep to help subset a data frame
  13. Filter data frame rows based on values in vector
  14. Selecting columns in R data frame based on those *not* in a vector
  15. Return df with a columns values that occur more than once [duplicate]
  16. Undefined columns selected when subsetting data frame
  17. Sample random rows in dataframe
  18. Replacing character values with NA in a data frame
  19. Coerce multiple columns to factors at once
  20. Convert a dataframe to a vector (by rows)
  21. Looping through t.tests for data frame subsets in r
  22. Replace empty values with value from other column in a dataframe
  23. How to remove rows of a matrix by row name, rather than numerical index?
  24. Count unique values for every column
  25. Numbers as column names of data frames
  26. How to pass “nothing” as an argument to `[` for subsetting?
  27. Divide each value by the sum of values by group
  28. Convert all data frame character columns to factors
  29. What you can do with a data.frame that you can’t with a data.table?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment