Select rows from one data.frame that are not present in a second data.frame

by

sqldf provides a nice solution

a1 <- data.frame(a = 1:5, b=letters[1:5])
a2 <- data.frame(a = 1:3, b=letters[1:3])

require(sqldf)

a1NotIna2 <- sqldf('SELECT * FROM a1 EXCEPT SELECT * FROM a2')

And the rows which are in both data frames:

a1Ina2 <- sqldf('SELECT * FROM a1 INTERSECT SELECT * FROM a2')

The new version of dplyr has a function, anti_join, for exactly these kinds of comparisons

require(dplyr) 
anti_join(a1,a2)

And semi_join to filter rows in a1 that are also in a2

semi_join(a1,a2)

More Related Contents:

  1. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  2. Simultaneously merge multiple data.frames in a list
  3. Merging a lot of data.frames [duplicate]
  4. Merge two data frames while keeping the original row order
  5. How do I combine two data-frames based on two columns? [duplicate]
  6. Merge unequal dataframes and replace missing rows with 0
  7. How to append rows to an R data frame
  8. Read and rbind multiple csv files
  9. Merge data frames based on rownames in R
  10. Merge or combine by rownames
  11. Identify records in data frame A not contained in data frame B [closed]
  12. How can I merge more than 2 dataframes in R by rownames?
  13. Data.frame Merge and Selection of values which are common in 2 Data.frames
  14. Sample random rows in dataframe
  15. Left join using data.table
  16. Subset / filter rows in a data frame based on a condition in a column
  17. Replacing character values with NA in a data frame
  18. Coerce multiple columns to factors at once
  19. Remove columns from dataframe where ALL values are NA
  20. Detect at least one match between each data frame row and values in vector
  21. Converting nested list to dataframe
  22. Cartesian product data frame
  23. Merge Two Lists in R
  24. Comparing two vectors in an if statement
  25. Splitting a large data frame into smaller segments
  26. Replace empty values with value from other column in a dataframe
  27. Replace values in data frame based on other data frame in R
  28. Add an image to a table-like output in R
  29. R how can I calculate difference between rows in a data frame
  30. Color one point and add an annotation in ggplot2?

Leave a Comment