Revision history [back]
 | 1 | initial version |
Assuming you have two dataframes (df1 and df2) with the same column structure and you want to add up the values of columns 2 and 3 for each row in both dataframes and then combine the result in a new dataframe (df3) using rbind(), you can use the following code:
# create example dataframes
df1 <- data.frame(col1 = c("A", "B", "C"), col2 = c(1, 2, 3), col3 = c(4, 5, 6))
df2 <- data.frame(col1 = c("D", "E", "F"), col2 = c(7, 8, 9), col3 = c(10, 11, 12))
# sum columns 2 and 3 for each dataframe
df1_sums <- apply(df1[,2:3], 1, sum)
df2_sums <- apply(df2[,2:3], 1, sum)
# combine the sums in a new dataframe using rbind()
df3 <- rbind(df1_sums, df2_sums)
# add column names to the new dataframe
colnames(df3) <- c("col2_sum", "col3_sum")
In the above code, the apply() function is used to sum up the values of columns 2 and 3 for each row in both dataframes. The resulting sums are then combined in a new dataframe (df3) using rbind(). Finally, column names are added to the new dataframe using colnames().