Delete duplicate rows in two columns simultaneously [duplicate]

by

If you want to use subset, you could try:

  subset(df, !duplicated(subset(df, select=c(allrl, RAW.PVAL))))
 # RAW.PVAL GR allrl  Bak
 #1     0.05 fr   EN1  B12
 #3     0.45 fr   EN2  B10
 #4     0.35 fg   EN2 B066

But, I think @thelatemail’s approach would be better

  df[!duplicated(df[c("RAW.PVAL","allrl")]),]

More Related Contents:

  1. Extract rows based on only one column using R [closed]
  2. R subset based on range of dates [closed]
  3. Select rows from a data frame based on values in a vector
  4. How can I remove all duplicates so that NONE are left in a data frame?
  5. Opposite of %in%: exclude rows with values specified in a vector
  6. How to replace NA with mean by group / subset?
  7. How do I extract a single column from a data.frame as a data.frame?
  8. Subset dataframe by multiple logical conditions of rows to remove
  9. Subset data frame based on multiple conditions [duplicate]
  10. Filtering out duplicated/non-unique rows in data.table
  11. data.table with two string columns of set elements, extract unique rows with each row unsorted
  12. Reading multiple files and calculating mean based on user input
  13. Remove duplicates keeping entry with largest absolute value
  14. Collapse rows with overlapping ranges
  15. dplyr – filter by group size
  16. How to subset data in R without losing NA rows?
  17. Using grep to help subset a data frame
  18. Subset based on variable column name
  19. from data table, randomly select one row per group
  20. Return data subset time frames within another timeframes?
  21. Subsetting a dataframe for a specified month and year
  22. Looping through t.tests for data frame subsets in r
  23. Merging rows with the same ID variable [duplicate]
  24. R: How to filter/subset a sequence of dates
  25. How to remove rows of a matrix by row name, rather than numerical index?
  26. Subset data.table by logical column
  27. list of masked functions in R
  28. Read FASTA into a dataframe and extract subsequences of FASTA file
  29. How to pass “nothing” as an argument to `[` for subsetting?
  30. Set global object in Shiny

Leave a Comment