Sum of Two or Multiple DataFrame Columns in R

In this article, we will discuss how to perform some of two and multiple dataframes columns in R programming language.

Database in use:

Sum of two columns

The columns whose sum has to be calculated can be called through the $ operator and then we can perform the sum of two dataframe columns by using “+” operator.

Syntax:

dataframe$column1 + dataframe$column2

where

• dataframe is the input dataframe
• column1 is one column in the dataframe
• column2 is another column in the dataframe

Example: R program to add two columns in dataframe

R

# create a dataframe with subjects marks
data=data.frame(sub1=c(90,89,78,89),
                sub2=c(100,90,86,84),
                sub3=c(89,90,98,99),
                sub4=c(86,78,87,99))

# add column1 and column2
print(data$sub1 + data$sub2)

# add column1 and column3
print(data$sub1 + data$sub3)

# add column1 and column4
print(data$sub1 + data$sub4)

# add column2 and column4
print(data$sub2 + data$sub4)

Output:

[1] 190 179 164 173
[1] 179 179 176 188
[1] 176 167 165 188
[1] 186 168 173 183

Sum of multiple columns

We can calculate the sum of multiple columns by using rowSums() and c() Function. we simply have to pass the name of the columns.

Syntax:

rowSums(dataframe[ , c(“column1”, “column2”, “column n”)])

where

• dataframe is the input dataframe
• c() represents the number of columns to be specified to add

Example: R program to add multiple columns

Python3

# create a dataframe with subjects marks
data = data.frame(sub1=c(90, 89, 78, 89),
                  sub2=c(100, 90, 86, 84),
                  sub3=c(89, 90, 98, 99),
                  sub4=c(86, 78, 87, 99))

# add column1, column2 and column 4
print(rowSums(data[, c("sub1", "sub2", "sub4")]))

# add column1, column2 and column 3
print(rowSums(data[, c("sub1", "sub2", "sub3")]))

# add column4, column2 and column 3
print(rowSums(data[, c("sub4", "sub2", "sub3")]))

Output:

[1] 276 257 251 272
[1] 279 269 262 272
[1] 275 258 271 282