CODEWITHSUNDEEP
rdataframemultiplicationcbind
ulrich
ulrich

Reputation: 3587

Multiplying and combine two data frames in R

I have two data frames

data frame 1

A B C

1 1 0
0 0 0
1 1 0

data frame 2

  1 2   

  0 4  
100 0  
100 4

I need to multiply and combine the columns to obtain

A1  A2  B1  B2  C1  C2

0   4   0   4   0   0
0   0   0   0   0   0
100 4   100 4   0   0

Upvotes: 2

Views: 1127

Answers (1)

Sven Hohenstein
Sven Hohenstein

Reputation: 81693

Here's one approach:

do.call(cbind, lapply(df1, "*", as.matrix(df2)))

       1 2   1 2 1 2
[1,]   0 4   0 4 0 0
[2,]   0 0   0 0 0 0
[3,] 100 4 100 4 0 0

This returns a matrix. You can use as.data.frame to turn it into a data frame if it's necessary.

This is based on the following data:

df1 <- data.frame(A = c(1,0,1), B = c(1,0,1), C = 0)

df2 <- data.frame("1" = c(0,100,100), "2" = c(4,0,4),
                  check.names = FALSE)

Upvotes: 2

Related Questions