subset a column in data frame based on another data frame/list

by

We can use %in% to get a logical vector and subset the rows of the ‘table1’ based on that.

subset(table1, gene_ID %in% accessions40$V1)

A better option would be data.table

library(data.table)
setDT(table1)[gene_ID %chin% accessions40$V1]

Or use filter from dplyr

library(dplyr)
table1 %>%
      filter(gene_ID %in% accessions40$V1)

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Subset data frame based on number of rows per group
  3. Is the “*apply” family really not vectorized?
  4. How to drop columns by name in a data frame
  5. Select groups with more than one distinct value
  6. Filtering a data frame on a vector [duplicate]
  7. Remove group from data.frame if at least one group member meets condition
  8. Subset a dataframe between 2 dates
  9. Subset with unique cases, based on multiple columns
  10. Extract matrix column values by matrix column name
  11. Remove/collapse consecutive duplicate values in sequence
  12. Using multiple criteria in subset function and logical operators
  13. Pasting elements of two vectors alphabetically
  14. Why is `vapply` safer than `sapply`?
  15. Sum every nth points
  16. How to subset data in R without losing NA rows?
  17. Using grep to help subset a data frame
  18. from data table, randomly select one row per group
  19. Split/subset a data frame by factors in one column [duplicate]
  20. Delete duplicate rows in two columns simultaneously [duplicate]
  21. Selecting columns in R data frame based on those *not* in a vector
  22. Subsetting data.table set by date range in R
  23. Applying a function to two lists?
  24. Return df with a columns values that occur more than once [duplicate]
  25. Apply function to each column in a data frame observing each columns existing data type
  26. How to remove rows of a matrix by row name, rather than numerical index?
  27. how to access global/outer scope variable from R apply function?
  28. How to pass “nothing” as an argument to `[` for subsetting?
  29. How to get all possible subsets of a character vector in R?
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment