'How to sum up similar rows in a dataframe? [duplicate]
Name <- c("Jon", "Bill", "Bill", "Ben", "Tina");value <- c(5, 20, 236, 665,325)
Age <- c(23, 32, 32, 58, 26)
df <- data.frame(Name, Age,value)
df
Name Age value
1 Jon 23 5
2 Bill 32 20
3 Bill 32 236
4 Ben 58 665
5 Tina 26 325
if there are similar rows in Age and name retune one row and sum up all corresponding columns
Name Age value
1 Jon 23 5
2 Bill 32 256
4 Ben 58 665
5 Tina 26 325
Solution 1:[1]
library(tidyverse)
df %>%
group_by(Name, Age) %>%
summarize(value = sum(value))
# A tibble: 4 x 3
# Groups: Name [4]
Name Age value
<chr> <dbl> <dbl>
1 Ben 58 665
2 Bill 32 256
3 Jon 23 5
4 Tina 26 325
Solution 2:[2]
df %>%
dplyr::group_by(Name,Age) %>%
dplyr::summarise(value = sum(value))
Name Age value
<chr> <dbl> <dbl>
1 Ben 58 665
2 Bill 32 256
3 Jon 23 5
4 Tina 26 325
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Tom Hoel |
| Solution 2 | Anurag N. Sharma |
