0
votes

I have two tables both 4x4 dimension. I wold like to know how I can replace a cell in the first table with a 0 if there is a 0 in the corresponding cell of the bottom table (using an R command, I'm guessing an If statement or sub-setting). E.g the first row and column of the first table (-0.2) should be converted to zero based on the 0 value of the first row and column of the second table (-0.2)? Thanks

first table

-0.2, 0.5, 0.8, 0.01, 1, -0.4, 0.8, 0.5, 0.5, 0.3, -0.1, 0.8, -0.8, 0.5, 0.5, -0.02, (4x4)

second table
0, 0, 1.8, 0, 0, 2.7, 0, 0, 0, 0, 3.2, 0, 0, 0, 0, 0, (4x4)

1
Please provide a reproducible example.Sven Hohenstein

1 Answers

0
votes

If your tables (matrices or data frames) are called tab1 and tab2, you can use the following command:

tab1[!tab2] <- 0