Remove duplicate column pairs, sort rows based on 2 columns [duplicate]

by

In case people are interested in solving this using dplyr:

library(dplyr)
testdata %>% 
   rowwise() %>%
   mutate(key = paste(sort(c(Var1, Var2)), collapse="")) %>%
   distinct(key, .keep_all=T) %>%
   select(-key)

# Source: local data frame [3 x 4]
# Groups: <by row>
# 
# # A tibble: 3 × 4
#    Var1  Var2       f       g
#   <dbl> <dbl>  <fctr>  <fctr>
# 1     1     4    blue    blue
# 2     2     3   green   green
# 3     5     5 orange2 orange1

More Related Contents:

  1. Group by multiple columns and sum other multiple columns
  2. Find indices of duplicated rows [duplicate]
  3. Reshape multiple values at once
  4. Concatenate strings by group with dplyr [duplicate]
  5. Conditionally change panel background with facet_grid?
  6. How to order data by value within ggplot facets
  7. How to assign values to dynamic names variables
  8. R – Error : .onLoad failed in loadNamespace() for ‘rJava’
  9. How to use R with Google Colaboratory?
  10. cumsum by group [duplicate]
  11. R convert zipcode or lat/long to county
  12. Knit error. Object not found
  13. How to define fixed aspect-ratio for (base R) scatter-plot
  14. databricks configure using cmd and R
  15. How to sort a data frame by date
  16. Error in model.frame.default: variable lengths differ
  17. double integral in R
  18. Add a horizontal line to plot and legend in ggplot2
  19. R’s read.csv prepending 1st column name with junk text [duplicate]
  20. How to use subscripts in ggplot2 legends [R]
  21. ggplot2 – The unit of size
  22. Variable name restrictions in R
  23. Can dcast be used without an aggregate function? [duplicate]
  24. add image in title page of rmarkdown pdf
  25. How to embed an image in a cell a table using DT, R and Shiny
  26. Gantt style time line plot (in base R)
  27. Replace missing values (NA) in one data set with values from another where columns match
  28. How to adjust facet size manually
  29. R: why kable doesn’t print inside a for loop?
  30. Create a time interval of 15 minutes from minutely data in R?

Leave a Comment