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.
