Hello, Just use ?aggregate.
Example <- read.table(text = " ID A B C D E F G 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 ", header = TRUE) aggregate(. ~ ID, Example , sum) Happy holidays, Rui Barradas On 12/29/2017 12:03 AM, PABLO ORTIZ PINEDA 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!.
______________________________________________ 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.
