Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

sum cells of certain columns for each row

Tags:

I would like to calculate sums for certain columns and then apply this summation for every row. Unfortunately, I can only get to the first step. How do I now make it happen for each row? I know that R doesn't need loops; what are good approaches?

My matrix (zscore) looks like this:

   a    b    c    t   y 1  3    4    7    7   4  2  4    56   6    6   4  3  3    3    2    1   7  4  3    88   9    9   9 

Now I would want to calculate the row sum for each row, based on some of the columns. For one row it could look like this:

f1 <- sum(zscore[1,1:2], zscore[1,3], zscore[1,5]) 

How do I do that now for each row?

like image 650
user1807857 Avatar asked Nov 20 '12 21:11

user1807857


People also ask

How do I sum only certain columns in Excel?

Choose a cell in a different column than the one you want to sum, select it and type "=SUM(" into the formula bar. Select the column you want to sum by clicking on the letter name of the column or using the arrow keys to navigate to the column you want. Then use "Ctrl + Space" to select the whole column.

How do I sum specific rows and columns in Excel?

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done.

How do I sum multiple rows and columns in Excel based on criteria?

For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function.

Can you use Sumifs across rows and columns?

SUMIFS & other complex Excel functions made easy….It enables you to SUMIF multiple columns without any hassle. It is the easiest way to add rows of data based on a given condition.


2 Answers

You could do something like this:

summed <- rowSums(zscore[, c(1, 2, 3, 5)]) 
like image 74
alestanis Avatar answered Oct 18 '22 15:10

alestanis


The summation of all individual rows can also be done using the row-wise operations of dplyr (with col1, col2, col3 defining three selected columns for which the row-wise sum is calculated):

library(tidyverse)  df <- df %>%      rowwise() %>%      mutate(rowsum = sum(c(col1, col2,col3))) 
like image 23
mgrund Avatar answered Oct 18 '22 15:10

mgrund