如果行中的每个值都大于不同数据框中的相应行,我想对数据进行子集化。我还需要跳过一些顶行。前面的这些问题对我没有帮助,但它是相关的:
根据另一个数据帧的内容对数据帧进行子集化
使用来自不同数据帧的信息的数据子集 [r]
> A
name1 name2
cond trt ctrl
hour 0 3
A 1 1
B 10 1
C 1 1
D 1 1
E 10 10
> B
name1 name2
cond trt ctrl
hour 0 3
A 1 1
B 1 10
C 1 1
D 1 1
E 1 1
我要这个。仅 A 中所有值都大于 B 的行:
name1 name2
cond trt ctrl
hour 0 3
E 10 10
我已经尝试过这3行:
subset(A, TRUE, select=(A[3:7,] > B[3:7,]))
subset(A, A > B)
A[A[3:7,] > B[3:7,]]
非常感谢。这是生成数据的代码:
A <- structure(list(name1 = c("trt", "0", "1", "10", "1", "1", "10"
), name2 = c("ctrl", "3", "1", "1", "1", "1", "10")), .Names = c("name1",
"name2"), row.names = c("cond", "hour", "A", "B", "C", "D", "E"
), class = "data.frame")
B <- structure(list(name1 = c("trt", "0", "1", "1", "1", "1", "1"),
name2 = c("ctrl", "3", "1", "10", "1", "1", "1")), .Names = c("name1",
"name2"), row.names = c("cond", "hour", "A", "B", "C", "D", "E"
), class = "data.frame")
############# Follow-up question asked 2/28/13
根据R中不同数据帧的调整值进行子集化时出错