Try this:
# input data ID <- scan() 1 1 1 1 2 2 2 2 2 V2 <- scan() 23.9 NA 22.0 23.9 0.4 NA NA 3.0 2.4 # setup data frame DF <- cbind(ID, V2); DF # find unique pairs unique(DF) ############### # Chi Yau # http://r-tutor.com ############### Barbara-43 wrote: > > Hello R-helpers, > > I am having a difficult time figuring out the following: I have a data > frame with 24 variables. I need to remove redundant observations where, > within the same values of ID, V2 is equal to another observation in V2. > > >ID V2 > >1 23.9 > >1 NA > >1 22.0 > >1 23.9 > >2 0.4 > >2 NA > >2 NA > >2 3.0 > >2 0.4 > > Thus, the new data frame would look like this (plus the other 22 > variables): > > >ID V2 > >1 23.9 > >1 NA > >1 22.0 > >2 0.4 > >2 NA > >2 3.0 > > Thank you in advance, > Barb > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- View this message in context: http://www.nabble.com/Removing-redundant-observations-tp25286208p25286405.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.