Thanks it works very nicely Assa On Thu, Jul 8, 2010 at 11:15, Petr PIKAL <petr.pi...@precheza.cz> 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 I would like to sum up according to a > > specific column. > > > > This is an example of my matrix: > > ID gen > > 0042787 gen2 > > 0016070 gen2 > > 0016070 gen3 > > 0007409 Gen1 > > 0007409 gen3 > > 0006511 gen2 > > 0006417 gen3 > > 0016070 gen4 > > 0006511 gen4 > > > > I want to rearrange the matrix according to column GO, so that it will > look > > likes that: > > > > GO:0042787 gen2 > > GO:0016070 gen2 : gen3 : gen4 > > GO:0007409 gen1 : gen3 > > GO:0006511 gen2 : gen4 > > GO:0006417 gen3 > > > > I've tried it with the package doBy (lapplyBy and paste) but it just > doesn't > > work out. > > Perhaps > > aggregate(test$gen, list(test$ID), function(x) paste(x, collapse=":")) > > Regards > Petr > > > > > I will be very happy for any suggestions you might have to help me. > > > > Thanks > > > > Assa > > > > [[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. > > [[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.