您好,我正在研究如何通过前缀匹配来合并数据帧的行(和列之和):
数据框示例:
set.seed(42) ## for sake of reproducibility
df <- data.frame(col1=c(sprintf("gene%s", 1:3), sprintf("protein%s", 1:5), sprintf("lipid%s", 1:3)),
counts=runif(11, min=10, max=70))
df
# col1 counts
# 1 gene1 64.88836
# 2 gene2 66.22452
# 3 gene3 27.16837
# 4 protein1 59.82686
# 5 protein2 48.50473
# 6 protein3 41.14576
# 7 protein4 54.19530
# 8 protein5 18.08000
# 9 lipid1 49.41954
# 10 lipid2 52.30389
# 11 lipid3 37.46451
所以我想把所有以"基因"开头的行合并成一行,蛋白质和脂质行也是这样.
所需输出:
col1 counts
gene 158.2813
lipid 139.1879
protein 221.7526