我认为这将是一项相对容易完成的任务,但我在这里找不到不专注于基于列条件总结行的示例.我想要实现的是总结列复制,但保持行的唯一性.
我的意思是:
MKC100.1 MKC100.2 MKC100.3 MKC103.1 MKC103.2 MKC103.3 MKC104.2 MKC104.3
299fc0ac11fb4afd0da849a2c45583b3 0 0 0 0 0 0 0 1
9bc2bacdfadf4c1352ffbc991803287c 1183 1666 1318 0 0 0 10 20
38b782d9f01c69c3570fe0edd5864dc0 493 626 543 10 0 0 5 5
6d078397349f7d39c34d237a6ef4cb75 43735 51511 46876 0 0 0 1 0
c22e752b441ee4190f27a3690c5d1206 0 0 0 2795 1128 1956 1 1
f6513affb198fb9845741b61ece8db4b 59 58 82 0 0 0 0 0
structure(list(MKC100.1 = c(0L, 1183L, 493L, 43735L, 0L, 59L),
MKC100.2 = c(0L, 1666L, 626L, 51511L, 0L, 58L), MKC100.3 = c(0L,
1318L, 543L, 46876L, 0L, 82L), MKC103.1 = c(0L, 0L, 10L,
0L, 2795L, 0L), MKC103.2 = c(0L, 0L, 0L, 0L, 1128L, 0L),
MKC103.3 = c(0L, 0L, 0L, 0L, 1956L, 0L), MKC104.2 = c(0L,
10L, 5L, 1L, 1L, 0L), MKC104.3 = c(1L, 20L, 5L, 0L, 1L, 0L
)), class = "data.frame", row.names = c("299fc0ac11fb4afd0da849a2c45583b3",
"9bc2bacdfadf4c1352ffbc991803287c", "38b782d9f01c69c3570fe0edd5864dc0",
"6d078397349f7d39c34d237a6ef4cb75", "c22e752b441ee4190f27a3690c5d1206",
"f6513affb198fb9845741b61ece8db4b"))
副本通常有三个,但在它的末尾会附加一个".1"或".2"或".3".我需要基本上将所有这些合并在一起,以便最终得到如下所示的数据帧:
MKC100 MKC103 MKC104
299fc0ac11fb4afd0da849a2c45583b3 0 0 1
9bc2bacdfadf4c1352ffbc991803287c 4167 0 30
38b782d9f01c69c3570fe0edd5864dc0 1662 10 10
6d078397349f7d39c34d237a6ef4cb75 142122 0 1
c22e752b441ee4190f27a3690c5d1206 0 5879 2
f6513affb198fb9845741b61ece8db4b 199 0 0
有时会删除EDIT个副本,我不会在数据帧中 for each 样本提供所有三个副本.任何副本仍应合并在一起.我已经更新了样本数据以反映此场景.