Sum By Row Dataframe R (Fastest Way!)

Question

currently, I am using for loops for sum of rows like below

dat <- c(1,2,3,4)
dat1 <- c(1,2,3,4)
dat2 <-c(1,2,3,4)

df <- data.frame(dat,dat1,dat2)


sum <- NULL
for (i in 1:nrow(df)){
  i <- sum(df[i,],na.rm=T)
  sum <- rbind(sum,i)

what would be the fastest way to do this, keeping the structure same as my example sum

akrun · Answer 1 · 2018-12-14T02:01:28.380

2

We can use rowSums which would be much faster than the looping through the rows as rowSums is vectorized optimized for these kind of operations

matrix(rowSums(df, na.rm = TRUE))

edited Dec 14 '18 at 02:01

answered Dec 14 '18 at 01:50

akrun

874,273
37
540
662

@AlgoQuant Just wrap with `matrix` if you want a one column `matrix` – akrun Dec 14 '18 at 02:01

Sum By Row Dataframe R (Fastest Way!)

1 Answers1