Re: [R] Calculate of data frame

From: Peter Dalgaard <p.dalgaard_at_biostat.ku.dk>
Date: Fri 15 Jul 2005 - 03:28:51 EST

"Zhang, Fan" <fzhang@doubleclick.net> writes:

> Now I want to get the total count and value for each model/date pair,
> like
> model count value date
> A 6 31.8 7/1/2005
> A 3 10.2 7/2/2005
> B 7 14.2 7/1/2005
> B 10 67.4 7/2/2005
>
> Anyone can tell me how to do this?

> aggregate(df[,c("count","value")],df[,c("date","model")],sum)

      date model count value
1 7/1/2005     A     6  31.8
2 7/2/2005     A     3  10.2
3 7/1/2005     B     7  14.2
4 7/2/2005     B    10  71.4


-- 
   O__  ---- Peter Dalgaard             ุster Farimagsgade 5, Entr.B
  c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
 (*) \(*) -- University of Copenhagen   Denmark          Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard@biostat.ku.dk)                  FAX: (+45) 35327907

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Jul 15 03:40:49 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:40 EST