Unique on a dataframe with only selected columns

by

Ok, if it doesn’t matter which value in the non-duplicated column you select, this should be pretty easy:

dat <- data.frame(id=c(1,1,3),id2=c(1,1,4),somevalue=c("x","y","z"))
> dat[!duplicated(dat[,c('id','id2')]),]
  id id2 somevalue
1  1   1         x
3  3   4         z

Inside the duplicated call, I’m simply passing only those columns from dat that I don’t want duplicates of. This code will automatically always select the first of any ambiguous values. (In this case, x.)

More Related Contents:

  1. Add count of unique / distinct values by group to the original data
  2. How can I remove all duplicates so that NONE are left in a data frame?
  3. Select groups based on number of unique / distinct values
  4. Count number of occurences for each unique value
  5. Add ID column by group [duplicate]
  6. How to assign a unique ID number to each group of identical values in a column [duplicate]
  7. Unique rows, considering two columns, in R, without order
  8. Plot multiple lines (data series) each with unique color in R
  9. Subset with unique cases, based on multiple columns
  10. data.table with two string columns of set elements, extract unique rows with each row unsorted
  11. unique() for more than one variable
  12. Merging rows with the same ID variable [duplicate]
  13. Count unique values for every column
  14. How to plot intersecting ranges in Excel/R/Matlab [closed]
  15. object I am trying to take the mean of is not found
  16. How to create a consecutive group number
  17. Consistent width for geom_bar in the event of missing data
  18. Remove columns from dataframe where ALL values are NA
  19. as.Date returning NA while converting from ‘ddmmmyyyy’
  20. Fast pairwise simple linear regression between variables in a data frame
  21. Find common substrings between two character variables
  22. How to generate distributions given, mean, SD, skew and kurtosis in R?
  23. How can I make a discontinuous axis in R with ggplot2?
  24. Use a variable within a plotmath expression
  25. Subset xts object by time of day
  26. R split string by symbol
  27. Select rows of a matrix that meet a condition
  28. How to use empty space produced by facet_wrap?
  29. pie chart with ggplot2 with specific order and percentage annotations
  30. Is there a way to output text to the R console in color

Leave a Comment