how to merge rows in a dataframe

Question

I have a df

df1 <- data.frame(col1=c("x","y","y","z","z","z"), col2=c(0,1,0,0,0,1), col3=c(0,0,1,0,0,0), col4=c(1,0,0,0,1,0), col5=c(0,1,0,0,0,0))

I want to have a df like this

df2 <- data.frame(col1=c("x","y","z"), col2=c(0,1,1), col3=c(0,1,0),col4=c(1,0,1), col5=c(0,1,0))

Could anyone help me, please? Thank you

`aggregate(.~col1, df1, sum)` or even `max` instead of `sum` would do. — Ronak Shah, Jul 24 '20 at 03:13

score 1 · Accepted Answer · answered Jul 24 '20 at 03:17

A solution using dplyr. The idea is group_by col1 and calculate sum for all the other columns.

library(dplyr)

df <- df1 %>%
  group_by(col1) %>%
  summarize_all(~sum(.)) %>%
  ungroup()
df
# # A tibble: 3 x 5
#   col1   col2  col3  col4  col5
#   <chr> <dbl> <dbl> <dbl> <dbl>
# 1 x         0     0     1     0
# 2 y         1     1     0     1
# 3 z         1     0     1     0

how to merge rows in a dataframe

1 Answers1