R - combine rows of data

Question

I have a dataframe as below:

|id|Test1|Test2|Test3| 

|01|  1  |  0  |  0  |

|01|  0  |  1  |  0  | 

|01|  0  |  0  |  1  |

|02|  0  |  0  |  0  |

|02|  0  |  1  |  0  |

|02|  0  |  0  |  1  |

and have the output dataframe look like:

 |01|  1  |  1  |  1  |

 |02|  0  |  1  |  1  |

Is group by on average for each test the best way to approach this?

Suggested duplicate: [Group by multiple columns and sum other multiple columns](https://stackoverflow.com/q/8212699/903061) — Gregor Thomas, Aug 20 '18 at 20:12
Possible duplicate of [Group by multiple columns and sum other multiple columns](https://stackoverflow.com/questions/8212699/group-by-multiple-columns-and-sum-other-multiple-columns) — Rui Barradas, Aug 21 '18 at 10:55

score 2 · Accepted Answer · answered Aug 20 '18 at 20:08

2

With summarize_all from dplyr:

library(dplyr)

df %>% 
  group_by(id) %>% 
  summarize_all(max)

answered Aug 20 '18 at 20:08

acylam

18,231
5
36
45

score 0 · Answer 2 · answered Aug 20 '18 at 20:05

0

Yes, you can group by on id to get the desired result. You can use the dplyr package for this:

library(dplyr)
df_agg <- df %>% 
group_by(id) %>% 
summarise(Test1 = sum(Test1), Test2 = sum(Test2), Test3 = sum(Test3)

answered Aug 20 '18 at 20:05

SmitM

1,366
1
8
14

R - combine rows of data

2 Answers2