Delete rows that exist in another data frame? [duplicate]

by

You need the %in% operator. So, 

df1[!(df1$name %in% df2$name),]

should give you what you want.

  • df1$name %in% df2$name tests whether the values in df1$name are in df2$name
  • The ! operator reverses the result.

More Related Contents:

  1. duplicates in multiple columns
  2. Dynamically select data frame columns using $ and a character value
  3. Simultaneously merge multiple data.frames in a list
  4. Drop unused factor levels in a subsetted data frame
  5. Create an empty data.frame
  6. Merging a lot of data.frames [duplicate]
  7. Create a group number for each consecutive sequence
  8. Repeat rows of a data.frame N times
  9. For each row in an R dataframe
  10. Replace all occurrences of a string in a data frame
  11. Convert Named Character Vector to data.frame
  12. How to add a cumulative column to an R dataframe using dplyr?
  13. Get last row of each group in R [duplicate]
  14. Techniques for finding near duplicate records
  15. Same function over multiple data frames in R
  16. Create empty data frame with column names by assigning a string vector? [duplicate]
  17. Add extra level to factors in dataframe
  18. What is about the first column in R’s dataset mtcars?
  19. Last Observation Carried Forward In a data frame? [duplicate]
  20. Determine the data types of a data frame’s columns
  21. finding close match from data frame 1 in data fame 2
  22. Combine several data frames in the global environment by row (rbind)
  23. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  24. Extract text after “/” in a data frame column
  25. What is difference between dataframe and list in R?
  26. Define dimensions of an empty dataframe
  27. use multiple columns as variables with sapply
  28. Merge overlapping ranges into unique groups, in dataframe
  29. Deleting specific rows from a data frame
  30. Count number of non-NA values for every column in a dataframe [duplicate]

Leave a Comment