I have 2 data frames:
at1 = data.frame(ID = c("A", "B", "C", "D", "E"), Sample1 = rnorm(5, 50000, 2500),
Sample2 = rnorm(5, 50000, 2500), Sample3 = rnorm(5, 50000, 2500),
row.names = "ID")
Sample1 Sample2 Sample3
A 52626.55 51924.51 50919.90
B 51430.51 49100.38 51005.92
C 50038.27 52254.73 50014.78
D 48644.46 53926.53 51590.05
E 46462.01 45097.48 50963.39
bt1 = data.frame(ID = c("A", "B", "C", "D", "E"), Sample1 = c(0,1,1,1,1),
Sample2 = c(0,0,0,1,0), Sample3 = c(1,0,1,1,0),
row.names = "ID")
Sample1 Sample2 Sample3
A 0 0 1
B 1 0 0
C 1 0 1
D 1 1 1
E 1 0 0
我希望根据bt1中相应单元格的值(0或1)过滤at1中的每个单元格,并将结果存储在新的数据框ct1中。例如,如果bt1 [1,“Sample1”] = 1,则ct1 [1,“Sample1”] = at1 [1,“Sample1”]。如果bt1 [1,“Sample1”] = 0,则ct1 [1,“Sample1”] = 0。我的原始数据框具有100多列和30,000多行。
我想知道是否有比编写if循环更简单的方法(例如使用“apply”)?