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]]
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 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. >
Sorry, I didn't sent it twice, but there is some problem on my email....Sorry for this. Tammy> From: metal_licaling@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 > _________________________________________________________________ > 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._________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx [[alternative HTML version deleted]]
Does anyone know the solution`? Thanks, Tammy> From: metal_licaling@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 > _________________________________________________________________ > 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._________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/ [[alternative HTML version deleted]]
I still couldn't solve it........any help would be preciated! Tammy> From: metal_licaling@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 > _________________________________________________________________ > 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._________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx [[alternative HTML version deleted]]