I have this data frame:

```
X1 X2 X3
1 a 1 3
2 b 5 3
3 a 3 4
4 c 6 5
5 c 2 2
and want to convert it to this one:
X1 X2 X3
1 a 4 7
2 b 5 3
3 c 8 7
How can this be done ?
```

I have this data frame:

```
X1 X2 X3
1 a 1 3
2 b 5 3
3 a 3 4
4 c 6 5
5 c 2 2
and want to convert it to this one:
X1 X2 X3
1 a 4 7
2 b 5 3
3 c 8 7
How can this be done ?
```

This is one way to do it

```
library(dplyr)
# This is your sample data on a copy/paste friendly format
sample_df <- data.frame(
stringsAsFactors = FALSE,
X1 = c("a", "b", "a", "c", "c"),
X2 = c(1, 5, 3, 6, 2),
X3 = c(3, 3, 4, 5, 2)
)
sample_df %>%
group_by(X1) %>%
summarise_all(sum)
#> # A tibble: 3 x 3
#> X1 X2 X3
#> <chr> <dbl> <dbl>
#> 1 a 4 7
#> 2 b 5 3
#> 3 c 8 7
```

^{Created on 2020-04-09 by the reprex package (v0.3.0.9001)}

Next time, please provide a proper **REPR**oducible **EX**ample (reprex) illustrating your issue.

2 Likes

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.