[R] Subsetting subsets of data.frames

jim holtman jholtman at gmail.com
Mon Jun 7 14:35:43 CEST 2010


subset(x, !duplicated(paste(x$id, x$date))

On Mon, Jun 7, 2010 at 3:01 AM, Jeff08 <jefferyding at gmail.com> wrote:
>
> Hey Everyone,
>
> I have been stumped by this all day.
>
> Basically, I have a data.frame of multiple columns. Of concern are "id" &
> "date"
>
> For some reason, oftentimes there are duplicates of data with the same date.
>
> I would like to remove the duplicates per different id (removing duplicate
> dates for the entire data.frame would leave nothing since different id's all
> have the same dates)
>
> subset(x,!duplicated(x$date_)) works for just one ID, but i am having
> trouble figuring out how to apply this to each subset of IDs (and retaining
> the original data.frame structure)
> --
> View this message in context: http://r.789695.n4.nabble.com/Subsetting-subsets-of-data-frames-tp2245556p2245556.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at 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.
>



-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem that you are trying to solve?



More information about the R-help mailing list