How to sum across rows rows for specific columns in data table in R

Question

I have a data table, see eg below:

A B C D 
1 a 2 4
2 b 3 5
3 c 4 6

with A,B,C,D as columns, I want to add a new column with sums across rows for column A,C and D. thus, new column should be

A B C D  SUM
1 a 2 4  7
2 b 3 5  9
3 c 4 6  13

Can someone please suggest.

thanks i was earlier using rowsum instead of rowSums hence was getting a error — jalaj pathak, Feb 11 '20 at 05:38

UseR10085 · Answer 1 · 2020-02-11T05:10:09.657

0

You can use the following code

library(tidyverse)

df <- read.table(header = TRUE, text ="A B C D

    1 a 2 4

    2 b 3 5

    3 c 4 6")

df %>% mutate(SUM = rowSums(select(df, c(A, C, D))))

edited Feb 11 '20 at 05:10

answered Feb 11 '20 at 05:03

UseR10085

7,120
3
24
54

How to sum across rows rows for specific columns in data table in R

1 Answers1