Subset with unique cases, based on multiple columns

by

You can use the duplicated() function to find the unique combinations:

> df[!duplicated(df[1:3]),]
  v1 v2 v3  v4 v5
1  7  1  A 100 98
2  7  2  A  98 97
3  8  1  C  NA 80
6  9  3  C  75 75

To get only the duplicates, you can check it in both directions:

> df[duplicated(df[1:3]) | duplicated(df[1:3], fromLast=TRUE),]
  v1 v2 v3 v4 v5
3  8  1  C NA 80
4  8  1  C 78 75
5  8  1  C 50 62

More Related Contents:

  1. Extract rows based on only one column using R [closed]
  2. Filter data.frame rows by a logical condition
  3. Subset data frame based on number of rows per group
  4. Why is `[` better than `subset`?
  5. Selecting data frame rows based on partial string match in a column
  6. Select groups based on number of unique / distinct values
  7. Count number of occurences for each unique value
  8. Add ID column by group [duplicate]
  9. Unique rows, considering two columns, in R, without order
  10. Filtering a data frame on a vector [duplicate]
  11. Subset rows in a data frame based on a vector of values
  12. Unique on a dataframe with only selected columns
  13. Subsetting R data frame results in mysterious NA rows
  14. Subset of rows containing NA (missing) values in a chosen column of a data frame
  15. Subset and ggplot2
  16. subset a column in data frame based on another data frame/list
  17. Using multiple criteria in subset function and logical operators
  18. Update subset of data.table based on join
  19. unique() for more than one variable
  20. R gotcha: logical-and operator for combining conditions is & not &&
  21. R keep rows with at least one column greater than value
  22. Merging rows with the same ID variable [duplicate]
  23. Subsetting data.table using variables with same name as column
  24. Subsetting data.table set by date range in R
  25. Subset data.frame by date
  26. Return df with a columns values that occur more than once [duplicate]
  27. How to subset a matrix with different column positions for each row? [duplicate]
  28. Undefined columns selected when subsetting data frame
  29. How to get all possible subsets of a character vector in R?
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment