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?
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.
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.
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.
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.
You could do something like this:
summed <- rowSums(zscore[, c(1, 2, 3, 5)])
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)))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With