My data frame is: > str(act_data12) 'data.frame': 1687 obs. of 5 variables: $ Date : chr "2006-02-22" "2006-02-22" "2006-02-22" "2006-02-22" ... $ Dtime : chr "14:36:10" "14:36:11" "14:36:12" "14:37:38" ... $ FocusApp_seq: chr "useractivity_act" "4" "3" "0" ... $ App_duration: int 1 1 86 58 1 1 9 3 1 41 ... $ Frequency : int 0 0 22 0 1 0 0 0 0 0 ...
I used: gh<-with(act_data12, aggregate(Frequency, by=list(Date, Dtime, FocusApp_seq, App_duration), sum)) Error info: Error in unlist(y, recursive = FALSE) : promise already under evaluation: recursive default argument reference or earlier problems? or R exited when running.. Thanks for your concentration. Tammy > To: r-h...@stat.math.ethz.ch > From: k.jew...@campden.co.uk > Date: Tue, 17 Mar 2009 12:23:34 +0000 > Subject: Re: [R] Merging > > 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" <metal_lical...@live.com> wrote in message > news:bay0-dp3-858363e64f6ed84f9f6f486...@phx.gbl... > > > > My aim is not only relect unduplicated column, I also want merge the last > > column beside selection > > Thanks. > > > > Tammy > > > > > > > > > >> Date: Tue, 17 Mar 2009 06:59:20 -0400 > >> From: pcho...@ncsu.edu > >> To: metal_lical...@live.com > >> CC: r-help@r-project.org > >> Subject: Re: [R] Merging > >> > >> Is this what you want it to do ('n' is the original data frame)? > >> > >> > n > >> v V1 V2 V3 V4 > >> 1 k a 2 1 2 > >> 2 l b 1 2 1 > >> 3 m c 2 1 2 > >> 4 n d 1 2 1 > >> 5 o e 2 1 2 > >> > n1 <- n[,3:5] > >> > n2 <- duplicated(n1) > >> > n3 <- n[!n2,] > >> > n3 > >> v V1 V2 V3 V4 > >> 1 k a 2 1 2 > >> 2 l b 1 2 1 > >> > >> > >> Pankaj > >> > >> > >> Tammy Ma wrote: > >> > Thanks for your reply, > >> > > >> > I couldn't use the method what the example gives. Because Data frame is > >> > quite big, and it has so many rows which are repeated. I am not pretty > >> > sure about the range of 1000. It turns out I should merge those row > >> > which repeated. > >> > Tammy > >> > > >> > > >> >> From: simon.pick...@bto.org > >> >> To: metal_lical...@live.com; r-help@r-project.org > >> >> Subject: Re: [R] Merging > >> >> Date: Tue, 17 Mar 2009 10:02:51 +0000 > >> >> > >> >> Hi, > >> >> > >> >> I'm pretty sure you dont mean "merge" since merge() creates a new big > >> >> data > >> >> frame from two small ones. It appears that you want to omit some rows. > >> >> > >> >> As I said before, get used to selecting rows like this > >> >> > >> >> data.frame<-data.frame[data.frame$conditional.rows>1000,] > >> >> > >> >> (for example) > >> >> > >> >> Although I dont have a clue what criteria you are using to select the > >> >> rows > >> >> you want... > >> >> > >> >> Simon. > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >>> 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 > >> >>> _________________________________________________________________ > >> >>> Invite your mail contacts to join your friends list with Windows Live > >> >>> Spaces. It's easy! > >> >>> http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us > >> >>> [[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. > >> >>> > >> >>> > >> > > >> > _________________________________________________________________ > >> > Invite your mail contacts to join your friends list with Windows Live > >> > Spaces. It's easy! > >> > http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us > >> > [[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. > >> > > > > > _________________________________________________________________ > > Invite your mail contacts to join your friends list with Windows Live > > Spaces. It's easy! > > http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us > > [[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. _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us [[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.