[R] aggregate

Omar Lakkis uofiowa at gmail.com
Tue Aug 30 16:36:50 CEST 2005


How can I aggregate this data.frame to list the min and max date for
each unique id?

>From this :
> r = data.frame(id=rep(seq(1:3), 3), date= as.Date(c(rep("2005-08-25",3), rep("2005-08-26",3), rep("2005-08-29", 3)), "%Y-%m-%d"))
> r
id     date
 1     2005-08-25
 2     2005-08-25
 3     2005-08-25
 1     2005-08-26
 2     2005-08-26
 3     2005-08-26
 1     2005-08-29
 2     2005-08-29
 3     2005-08-29

I want to get to this:
> 
id    start              end
 1    2005-08-25    2005-08-29
 2    2005-08-25    2005-08-29
 3    2005-08-25    2005-08-29

I tried aggregate and aggregate.data.frame but the date column keeps
getting converted into a number.




More information about the R-help mailing list