Looks as if you copied my code without modifying to suit your data frame. My data frame (aDF) had column names V1, V2, V3, V4 > str(aDF) 'data.frame': 12 obs. of 4 variables: $ V1: chr "2006-02-22 16:28:18" "2006-02-22 16:28:26" "2006-02-22 16:28:28" "2006-02-22 16:28:31" ... $ V2: Factor w/ 4 levels "3","4","useractivity_act",..: 3 2 1 2 1 4 3 2 1 2 ... $ V3: num 8 2 3 4 159 0 8 2 3 4 ... $ V4: num 0 0 0 1 0 0 0 0 0 0 ...
..so I referred to V1, V2, V3, V4 in the aggregate. We don't know the column names in your data frame, which I guess is called act_data12. (By the way, you told us almost nothing about your data frame. Consider reading and following the posting guide.) What does > str(act_data12) produce? hth Keith J ========================== "Tammy Ma" <metal_lical...@live.com> wrote in message news:bay0-dp1-6d9323fb68f77e4cfa77186...@phx.gbl... Thanks. Actually, I have been trying many time using method from KJ, There is always the following information coming up or Rgui exit without reason.. I have no idea about this? gh<-with(act_data12, aggregate(V4, by=list(V1,V2,V3), sum)) Error in unlist(y, recursive = FALSE) : promise already under evaluation: recursive default argument reference or earlier problems? Tammy > Date: Tue, 17 Mar 2009 15:23:44 +0200 > From: annette.heissw...@utu.fi > Subject: Re: [R] Merging > To: metal_lical...@live.com; r-help@r-project.org > > Tammy, > > You won't get more help if you post this again every half an hour... I > don't quite understand what you exactly want to do, but it seemed at > least to me that Keith's suggestion (see again below) pretty much does > what you want. If not, could you please specify *EXACTLY* what you > want to do. Thanks! > > Annette > > > From: Keith Jewell <k.jewell_at_campden.co.uk> > > Date: Tue, 17 Mar 2009 12:23:34 +0000 > > > > Is this what you want it to do? (aDF is the original data frame) > > > >> aDF > > > > V1 V2 V3 V4 > > 1 2006-02-22 16:28:18 useractivity_act 8 0 > > 2 2006-02-22 16:28:26 4 2 0 > > 3 2006-02-22 16:28:28 3 3 0 > > 4 2006-02-22 16:28:31 4 4 1 > > 5 2006-02-22 16:28:35 3 159 0 > > 6 2006-02-22 16:31:14 useractivity_idle 0 0 > > 7 2006-02-22 16:28:18 useractivity_act 8 0 > > 8 2006-02-22 16:28:26 4 2 0 > > 9 2006-02-22 16:28:28 3 3 0 > > 10 2006-02-22 16:28:31 4 4 0 > > 11 2006-02-22 16:28:35 3 159 25 > > > > 12 2006-02-22 16:31:14 useractivity_idle 0 0 > >> with(aDF, aggregate(V4, by=list(V1, V2, V3), sum)) > > > > Group.1 Group.2 Group.3 x > > 1 2006-02-22 16:31:14 useractivity_idle 0 0 > > 2 2006-02-22 16:28:26 4 2 0 > > 3 2006-02-22 16:28:28 3 3 0 > > 4 2006-02-22 16:28:31 4 4 1 > > 5 2006-02-22 16:28:18 useractivity_act 8 0 > > 6 2006-02-22 16:28:35 3 159 25 > > > > > > hth > > > > Keith J > > > > > Tammy Ma schrieb: > > I still couldn't solve it........any help would be preciated! > > > > > > > > Tammy > > > > > > > > > > > >> From: metal_lical...@live.com > >> To: r-help@r-project.org > >> Date: Tue, 17 Mar 2009 11:49:10 +0200 > >> Subject: [R] Merging > >> > >> > >> Hi, All. > >> > >> > >> I have a data frame with the part as : > >> > >> ..... > >> 142 2006-02-22 16:28:18 useractivity_act 8 0 > >> 143 2006-02-22 16:28:26 4 2 0 > >> 144 2006-02-22 16:28:28 3 3 0 > >> 145 2006-02-22 16:28:31 4 4 1 > >> 146 2006-02-22 16:28:35 3 159 0 > >> 147 2006-02-22 16:31:14 useractivity_idle 0 0 > >> 1421 2006-02-22 16:28:18 useractivity_act 8 0 > >> 1431 2006-02-22 16:28:26 4 2 0 > >> 1441 2006-02-22 16:28:28 3 3 0 > >> 1451 2006-02-22 16:28:31 4 4 0 > >> 1461 2006-02-22 16:28:35 3 159 25 > >> 1471 2006-02-22 16:31:14 useractivity_idle 0 0 > >> .... > >> > >> I want to merge the above as > >> 142 2006-02-22 16:28:18 useractivity_act 8 0 > >> > >> 143 2006-02-22 16:28:26 4 2 0 > >> > >> 144 2006-02-22 16:28:28 3 3 0 > >> > >> 145 2006-02-22 16:28:31 4 4 1 > >> > >> 146 2006-02-22 16:28:35 3 159 25 > >> > >> 147 2006-02-22 16:31:14 useractivity_idle 0 0 > >> > >> How should I do`?? > >> Thanks. > >> > >> Tammy > > -- > Annette Heisswolf > Section of Ecology > Department of Biology > University of Turku > 20014 Turku, Finland _________________________________________________________________ Drag n' drop-Get easy photo sharing with Windows LiveT Photos. http://www.microsoft.com/windows/windowslive/products/photos.aspx [[alternative HTML version deleted]] -------------------------------------------------------------------------------- > ______________________________________________ > 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. > ______________________________________________ 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.
