[R] Merging

Simon Pickett simon.pickett at bto.org
Tue Mar 17 11:02:51 CET 2009


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.
>




More information about the R-help mailing list