Remove duplicates keeping entry with largest absolute value

by

First. Sort in the order putting the less desired items last within id groups

 aa <- a[order(a$id, -abs(a$value) ), ] #sort by id and reverse of abs(value)

Then: Remove items after the first within id groups

 aa[ !duplicated(aa$id), ]              # take the first row within each id
  id value
2  1     2
4  2    -4
5  3    -5
6  4     6

More Related Contents:

  1. Finding ALL duplicate rows, including “elements with smaller subscripts”
  2. How can I remove all duplicates so that NONE are left in a data frame?
  3. Find indices of duplicated rows [duplicate]
  4. Remove duplicated rows
  5. pair-wise duplicate removal from dataframe [duplicate]
  6. Delete rows that exist in another data frame? [duplicate]
  7. Filtering out duplicated/non-unique rows in data.table
  8. data.table with two string columns of set elements, extract unique rows with each row unsorted
  9. Find duplicated rows (based on 2 columns) in Data Frame in R
  10. duplicates in multiple columns
  11. How do keep only unique words within each string in a vector
  12. Techniques for finding near duplicate records
  13. Delete duplicate rows in two columns simultaneously [duplicate]
  14. Merging rows with the same ID variable [duplicate]
  15. Remove all duplicate rows including the “reference” row [duplicate]
  16. Combining duplicated rows in R and adding new column containing IDs of duplicates
  17. list of masked functions in R
  18. Remove all duplicates except last instance
  19. How to sort a character vector where elements contain letters and numbers in R?
  20. Gantt charts with R
  21. How to calculate cumulative sum? [duplicate]
  22. Create integer sequences defined by ‘from’ and ‘to’ vectors
  23. How to set multiple legends / scales for the same aesthetic in ggplot2?
  24. How to round up to the nearest 10 (or 100 or X)?
  25. Splitting a data.frame by a variable [duplicate]
  26. Using row-wise column indices in a vector to extract values from data frame [duplicate]
  27. How to add table of contents in Rmarkdown?
  28. How to hold figure position with figure caption in pdf output of knitr?
  29. How can I label points in this scatterplot?
  30. Error when using predict() on a randomForest object trained with caret’s train() using formula

Leave a Comment