d <- read.table("foo.txt",header=T))
> > > ID gen
> > > 1 42787 gen2
> > > 2 16070 gen2
> > > 3 16070 gen3
> > > 4 7409 Gen1
> > > 5 7409 gen3
> > > 6 6511 gen2
> > > 7 6417 gen3
> > > 8 16070 gen4
> > > 9 651
n2
> > > 7 6417 gen3
> > > 8 16070 gen4
> > > 9 6511 gen4
> > > > aa<-lapplyBy(~ID, data=ddd,
> > > + FUN=function(uu){
> > > + list(uu$ID[1], paste(uu$gen, collapse=":"))
> > > + })
> > > >
> > > &
ddd,
> > + FUN=function(uu){
> > + list(uu$ID[1], paste(uu$gen, collapse=":"))
> > + })
> > >
> > > do.call(rbind,aa)
> > [,1] [,2]
> > 42787 42787 "gen2"
> > 16070 16070 "gen2:gen3:gen4"
> > 7409 7409 "Gen1:
Thanks it works very nicely
Assa
On Thu, Jul 8, 2010 at 11:15, Petr PIKAL wrote:
> Hi
>
> r-help-boun...@r-project.org napsal dne 08.07.2010 10:45:04:
>
> > Hello all R users,
> >
> > I have a problems transforming (or maybe better regrouping) a
> data.frame.
> > I have a big data.frame, which
gt; 7409 7409 "Gen1:gen3"
> 6511 6511 "gen2:gen4"
> 6417 6417 "gen3"
>
> Regards
> Søren
>
>
>
>
>
> -Oprindelig meddelelse-
> Fra: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] PÃ¥
> vegne af
-Oprindelig meddelelse-
Fra: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] På
vegne af Assa Yeroslaviz
Sendt: 8. juli 2010 10:45
Til: r-h...@stat.math.ethz.ch
Emne: [R] transformation of data.frame
Hello all R users,
I have a problems transforming (or ma
Hello all R users,
I have a problems transforming (or maybe better regrouping) a data.frame.
I have a big data.frame, which I would like to sum up according to a
specific column.
This is an example of my matrix:
IDgen
0042787gen2
0016070gen2
0016070gen3
0007409Gen1
0007409
7 matches
Mail list logo
