Finding ALL duplicate rows, including “elements with smaller subscripts”

by

duplicated has a fromLast argument. The “Example” section of ?duplicated shows you how to use it. Just call duplicated twice, once with fromLast=FALSE and once with fromLast=TRUE and take the rows where either are TRUE.

Some late Edit:
You didn’t provide a reproducible example, so here’s an illustration kindly contributed by @jbaums

vec <- c("a", "b", "c","c","c") 
vec[duplicated(vec) | duplicated(vec, fromLast=TRUE)]
## [1] "c" "c" "c"

Edit: And an example for the case of a data frame:

df <- data.frame(rbind(c("a","a"),c("b","b"),c("c","c"),c("c","c")))
df[duplicated(df) | duplicated(df, fromLast=TRUE), ]
##   X1 X2
## 3  c  c
## 4  c  c

More Related Contents:

  1. How can I remove all duplicates so that NONE are left in a data frame?
  2. Remove duplicated rows
  3. Dynamically select data frame columns using $ and a character value
  4. Error: could not find function … in R
  5. Simultaneously merge multiple data.frames in a list
  6. Count number of rows within each group
  7. Drop unused factor levels in a subsetted data frame
  8. Use dynamic name for new column/variable in `dplyr`
  9. Select rows from a data frame based on values in a vector
  10. Unique combination of all elements from two (or more) vectors
  11. How to read data when some numbers contain commas as thousand separator?
  12. How to split a data frame?
  13. Test if a vector contains a given element
  14. How to call an object with the character variable of the same name
  15. Only read selected columns
  16. ggplot’s qplot does not execute on sourcing
  17. Error: unexpected symbol/input/string constant/numeric constant/SPECIAL in my code
  18. How can two strings be concatenated?
  19. How do you use “
  20. Elegant way to check for missing packages and install them?
  21. How to plot all the columns of a data frame in R
  22. Vectorized IF statement in R?
  23. Understanding the order() function
  24. How to remove all whitespace from a string?
  25. Filtering out duplicated/non-unique rows in data.table
  26. How to subtract/add days from/to a date?
  27. data.table with two string columns of set elements, extract unique rows with each row unsorted
  28. How can I remove an element from a list?
  29. Remove backslashes from character string
  30. What does “S3 methods” mean in R?

Leave a Comment