pair-wise duplicate removal from dataframe [duplicate]

by

Extending Ari’s answer, to specify columns to check if other columns are also there:

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

df$c = sample(1:10,8)
df$d = sample(LETTERS,8)
df
  a b  c d
1 A A 10 B
2 A B  8 S
3 A B  7 J
4 B C  3 Q
5 B A  2 I
6 B A  6 U
7 C B  4 L
8 C B  5 V

cols = c(1,2)
newdf = df[,cols]
for (i in 1:nrow(df)){
    newdf[i, ] = sort(df[i,cols])
}

df[!duplicated(newdf),]
  a b c d
1 A A 8 X
2 A B 7 L
4 B C 2 P

More Related Contents:

  1. Find indices of duplicated rows [duplicate]
  2. Find duplicated rows (based on 2 columns) in Data Frame in R
  3. Finding ALL duplicate rows, including “elements with smaller subscripts”
  4. Replace values in a dataframe based on lookup table
  5. Sample random rows in dataframe
  6. How to drop columns by name in a data frame
  7. Subset / filter rows in a data frame based on a condition in a column
  8. Replacing character values with NA in a data frame
  9. How do I extract a single column from a data.frame as a data.frame?
  10. How to assign a unique ID number to each group of identical values in a column [duplicate]
  11. Subset dataframe by multiple logical conditions of rows to remove
  12. Named List To/From Data.Frame
  13. Merge two data frames while keeping the original row order
  14. How to add a row to a data frame in R?
  15. Replace all particular values in a data frame
  16. Subtract a column in a dataframe from many columns in R
  17. Why am I getting X. in my column names when reading a data frame?
  18. Converting a data frame to xts
  19. Creating a summary statistical table from a data frame
  20. Interpolate NA values in a data frame with na.approx
  21. How to delete columns that contain ONLY NAs?
  22. Merge rows in a dataframe where the rows are disjoint and contain NAs
  23. Randomly insert NAs into dataframe proportionaly
  24. How to delete rows where all the columns are zero
  25. Convert a dataframe to a vector (by rows)
  26. Transposing a dataframe maintaining the first column as heading
  27. Filter data frame rows based on values in vector
  28. Replace empty values with value from other column in a dataframe
  29. Replace values in data frame based on other data frame in R
  30. Add an image to a table-like output in R

Leave a Comment