Hi Pablo, Rui's suggestion is probably the best and easiest. In addition to Eric's, i think the apply functions will work well here too.
Best of luck, EK On Thu, Dec 28, 2017 at 7:03 PM, PABLO ORTIZ PINEDA <pablo.or...@yale.edu> wrote: > Hello there. Happy new year for everyone! > > I need help with a table. This table contains 300 rows and 192 columns. > Being the first column the ID of my samples that can have several > observations. > > I need to generate e NEW table that contains a single ID with the sum of > the observations by columns: > For example: > > Example > ID A B C D E F G.... 191 columns > a1 0 0 0 1 1 2 0... > a2 0 1 0 1 2 2 1... > a2 0 1 1 2 0 2 1... > a3 0 1 1 1 1 1 1.... > ...300rows > In this case I want to make a new table in which there is only 1 ID and > the values of each columns A...G are added. I > n the example the new table would have only 3 IDs. a1, a2 and 3 and a2 > has the values added by column: > a2 0 2 1 3 2 4 2.. > > Thank you so much and have a wonderful year!. > > -- > Pablo A. Ortiz-Pineda (Ph.D.) > Molecular Biology & Bioinformatics > Yale University. School of Medicine. > Pediatrics Department. > New Haven, CT 06510 > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
