And another approach: ================================================================= library(reshape2) mydata <- data.frame(aa = sample(Cs(a,b,c,d,e),10,replace=TRUE), bb = sample(1:10, 10, replace=TRUE)) (m1 <- melt(mydata)) =================================================================
--- On Fri, 5/13/11, wong, honkit (Stephen) <hon...@stanford.edu> wrote: > From: wong, honkit (Stephen) <hon...@stanford.edu> > Subject: [R] Adding same items together in data.frame > To: r-help@r-project.org > Received: Friday, May 13, 2011, 7:06 PM > Dear All, > I am new to R. I have a 2 column data frame with more than > ten thousand > rows. Something like below. I want to add up all duplicated > items, e.g. the > three "aa" add up together to get a single value gene=a, > value=74. How can I > do that?? Thanks for help ! > gene value > aa 20 > bb 10 > cc 9 > aa 30 > aa 24 > dd 100 > ee 55 > .... ... > Millions thanks. > Best Regards, > hon > > WONG, Hon-Kit (Stephen) > Cleary Lab, Dept of Pathology > Stanford University > ______________________________________________ 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.