[R] Help with script

[Rui Barradas]

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!.
>