data.table with two string columns of set elements, extract unique rows with each row unsorted

by

For just two columns you can use the following trick:

dt = data.table(a = letters[1:5], b = letters[5:1])
#   a b
#1: a e
#2: b d
#3: c c
#4: d b
#5: e a

dt[dt[, .I[1], by = list(pmin(a, b), pmax(a, b))]$V1]
#   a b
#1: a e
#2: b d
#3: c c

More Related Contents:

  1. How can I remove all duplicates so that NONE are left in a data frame?
  2. Filtering out duplicated/non-unique rows in data.table
  3. Merging rows with the same ID variable [duplicate]
  4. data.table objects assigned with := from within function not printed
  5. Add ID column by group [duplicate]
  6. Unique rows, considering two columns, in R, without order
  7. .EACHI in data.table?
  8. Use a value from the previous row in an R data.table calculation
  9. How to efficiently calculate distance between pair of coordinates using data.table :=
  10. Unique on a dataframe with only selected columns
  11. Sample random rows within each group in a data.table
  12. Melt using patterns when variable names contain string information – avoid coercion to numeric
  13. Error: package or namespace load failed for ggplot2 and for data.table
  14. Split text string in a data.table columns
  15. Find duplicated rows (based on 2 columns) in Data Frame in R
  16. Why is allow.cartesian required at times when when joining data.tables with duplicate keys?
  17. Update subset of data.table based on join
  18. knitr gets tricked by data.table `:=` assignment
  19. Add multiple columns to R data.table in one function call?
  20. data.table equivalent of tidyr::complete()
  21. data.table merge based on date ranges
  22. Reason behind speed of fread in data.table package in R
  23. data.table row-wise sum, mean, min, max like dplyr?
  24. Combining duplicated rows in R and adding new column containing IDs of duplicates
  25. How to select R data.table rows based on substring match (a la SQL like)
  26. Subset data.table by logical column
  27. Any way to force fread() of data.table not to stop on empty lines?
  28. R data table: update join
  29. Split a string column into several dummy variables
  30. R fast single item lookup from list vs data.table vs hash

Leave a Comment