I want to be able to collapse and sum values dependent on the gene name

Question

I want to be able to collapse and sum values dependent on the gene name

Mark Hickling

2022年2月8日 02:05

I have a table that looks like this:

I want add together all the values for each gene for each column. For example, for LINC01128, it should read: ConN1 ConN2 ConN3 StN1 StN2 StN3 LINC01128 : 22 14 37 34 54 67

My table is very long and this would need to be done for all the genes.

Topic aggregation r

Category Data Science

BlackCurrant · Accepted Answer · 2020年5月8日 11:23

1

BlackCurrant answered at 2020年5月8日 11:23

data = aggregate(data,
                by = list(gene),
                FUN = sum)

MrGumble · Accepted Answer · 2018年10月3日 12:21

You can use dplyr, where df is your data.frame:

df %>% group_by(gene) %>% summarise_if(is.numeric, sum)

This will sum each column separately (assuming it is numeric), grouped by each gene. Any column that is not included in the group_by or is not numeric will be dropped at this stage.

I want to be able to collapse and sum values dependent on the gene name

About