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)