Subsetting a data frame based on contents of another data frame

by

Both %in% and match() can be used for this. Here is the former:

> which( df1$x %in% df2$y )
 [1]   1   2   3   4  27  28  29  30  53  54  55  56  79  80  81  82 105
[18] 106 107 108 131 132 133 134 157 158 159 160 183 184 185 186 209 210
[35] 211 212 235 236 237 238 261 262 263 264 287 288 289 290 313 314 315
[52] 316 339 340 341 342 365 366 367 368 391 392 393 394
> 
>
> table(df1[ which( df1$x %in% df2$y ), "x"])

 a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y 
16 16 16 16  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0 
 z 
 0 
>

More Related Contents:

  1. Reshaping data.frame from wide to long format
  2. Quickly reading very large tables as dataframes
  3. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  4. Combine two data frames by rows (rbind) when they have different sets of columns
  5. Convert a list to a data frame
  6. How to combine multiple conditions to subset a data-frame using “OR”?
  7. Split a large dataframe into a list of data frames based on common value in column
  8. Splitting a dataframe string column into multiple different columns [duplicate]
  9. Conditional replacement of values in a data.frame
  10. How do I combine two data-frames based on two columns? [duplicate]
  11. R Apply() function on specific dataframe columns
  12. Count NAs per row in dataframe [duplicate]
  13. Add (insert) a column between two columns in a data.frame
  14. Create categories by comparing a numeric column with a fixed value
  15. Add a prefix to column names
  16. Add empty columns to a dataframe with specified names from a vector
  17. Create a Data Frame of Unequal Lengths
  18. How to save a data.frame in R?
  19. How to append rows to an R data frame
  20. apply a function over groups of columns
  21. R: Assign variable labels of data frame columns
  22. Read and rbind multiple csv files
  23. Count number of zeros per row, and remove rows with more than n zeros
  24. How I can select rows from a dataframe that do not match?
  25. Select last non-NA value in a row, by row
  26. Join two data frames in R based on closest timestamp
  27. Undefined columns selected when subsetting data frame
  28. How to create a new variable in a data.frame based on a condition?
  29. Data.frame Merge and Selection of values which are common in 2 Data.frames
  30. Interpolating timeseries

Leave a Comment