Remove duplicated rows

by

For people who have come here to look for a general answer for duplicate row removal, use !duplicated():

a <- c(rep("A", 3), rep("B", 3), rep("C",2))
b <- c(1,1,2,4,1,1,2,2)
df <-data.frame(a,b)

duplicated(df)
[1] FALSE  TRUE FALSE FALSE FALSE  TRUE FALSE  TRUE

> df[duplicated(df), ]
  a b
2 A 1
6 B 1
8 C 2

> df[!duplicated(df), ]
  a b
1 A 1
3 A 2
4 B 4
5 B 1
7 C 2

Answer from: Removing duplicated rows from R data frame

More Related Contents:

  1. Finding ALL duplicate rows, including “elements with smaller subscripts”
  2. How can I remove all duplicates so that NONE are left in a data frame?
  3. Grouping functions (tapply, by, aggregate) and the *apply family
  4. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  5. Select the row with the maximum value in each group
  6. How to create a consecutive group number
  7. Error in if/while (condition) {: missing Value where TRUE/FALSE needed
  8. Using ggplot2, can I insert a break in the axis?
  9. Convert date-time string to class Date
  10. Installing older version of R package
  11. How to subset matrix to one column, maintain matrix data type, maintain row/column names?
  12. Why can’t R’s ifelse statements return vectors?
  13. Extracting specific columns from a data frame
  14. Find indices of duplicated rows [duplicate]
  15. Why do R objects not print in a function or a “for” loop?
  16. Rename multiple columns by names
  17. Error in : target of assignment expands to non-language object
  18. Convert integer to class Date
  19. How to unload a package without restarting R
  20. as.Date returning NA while converting from ‘ddmmmyyyy’
  21. How to search for “R” materials? [closed]
  22. What is the difference between = and ==?
  23. Set default CRAN mirror permanent in R
  24. Read SAS sas7bdat data into R
  25. Delete duplicate rows in two columns simultaneously [duplicate]
  26. What is the difference between = and == in R?
  27. Should I use a data.frame or a matrix?
  28. Variable name restrictions in R
  29. Different legend-keys inside same legend in ggplot2
  30. Plot two graphs in a same plot

Leave a Comment