假设我有这个熔化的 data.frame
molten <- data.frame(
gene = c("a1", "b1", "a1", "b1", "a1", "b1"),
count = c(3, 4, 5, 2, 6, 7),
condition = c("A", "A", "B", "B", "C", "C")
)
# gene count condition
# 1 a1 3 A
# 2 b1 4 A
# 3 a1 5 B
# 4 b1 2 B
# 5 a1 6 C
# 6 b1 7 C
看起来像未融化的
molten %>%
dcast(gene ~ condition, value.var = "count")
# gene A B C
# 1 a1 3 5 6
# 2 b1 4 2 7
如何从所有其他数字列(本例中为 B 和 C)中减去 A 列。我希望最终的输出是熔化的,但我不知道这是否可以直接完成,或者我是否必须解熔,减去,然后熔化。最终输出应如下所示:
# gene A B C
# 1 a1 0 2 3
# 2 b1 0 -2 3
Update:
我还对更复杂的场景感兴趣:
molten <- data.frame(
gene = c("a1", "b1", "a1", "b1", "a1", "b1"),
count = c(3, 4, 5, 2, 6, 7),
condition = c("A", "A", "B", "B", "C", "C"),
day = c(0, 0, 1, 1, 2, 2)
)
@eipi10提出的解决方案给出了错误:
molten %>%
group_by(gene, condition) %>%
mutate(count = count - count[day == 0])
Error: incompatible size (0), expecting 1 (the group size) or 1
这是我的解决方法:
x <- list(a1 = 3, b1 = 4)
molten %>%
group_by(gene, condition) %>%
mutate(count = count - x[[gene]])