Unique rows, considering two columns, in R, without order

by

If it’s just two columns, you can also use pmin and pmax, like this:

library(data.table)
unique(as.data.table(df)[, c("V1", "V2") := list(pmin(V1, V2),
                         pmax(V1, V2))], by = c("V1", "V2"))
#    V1 V2
# 1:  a  b
# 2:  b  d
# 3:  c  e

A similar approach using “dplyr” might be:

library(dplyr)
data.frame(df, stringsAsFactors = FALSE) %>% 
  mutate(key = paste0(pmin(X1, X2), pmax(X1, X2), sep = "")) %>% 
  distinct(key)
#   X1 X2 key
# 1  a  b  ab
# 2  b  d  bd
# 3  c  e  ce

More Related Contents:

  1. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  2. How to select the rows with maximum values in each group with dplyr? [duplicate]
  3. How to create a lag variable within each group?
  4. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  5. Applying a function to every row of a table using dplyr?
  6. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  7. dplyr: “Error in n(): function should not be called directly”
  8. Count number of rows by group using dplyr
  9. How to strsplit different number of strings in certain column by do function
  10. Change value of variable with dplyr
  11. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  12. Summarizing multiple columns with dplyr? [duplicate]
  13. Add ID column by group [duplicate]
  14. Filter data frame by character column name (in dplyr)
  15. How to number/label data-table by group-number from group_by?
  16. Remove duplicated rows using dplyr
  17. dplyr: inner_join with a partial string match
  18. Can dplyr summarise over several variables without listing each one? [duplicate]
  19. sample rows of subgroups from dataframe with dplyr
  20. Assigning Dates to Fiscal Year
  21. filter function in dplyr errors: object ‘name’ not found
  22. How to pass dynamic column names in dplyr into custom function?
  23. Merging rows with the same ID variable [duplicate]
  24. R – Group by variable and then assign a unique ID [duplicate]
  25. R sum a variable by two groups [duplicate]
  26. data.table row-wise sum, mean, min, max like dplyr?
  27. Update/Replace Values in Dataframe with Tidyverse Join
  28. dplyr: put count occurrences into new variable [duplicate]
  29. Add row in each group using dplyr and add_row()
  30. How to replace certain values in a specific rows and columns with NA in R?

Leave a Comment