adding values in a row if duplicate value in another row in r

Question

I have a data frame of two columns having word and frequency.

i want a new data frame when duplicate word comes the frequency should ad up as happened with word great

These seems to be pretty straight forward but i am not able to do it. Any suggestion

share reproducible data not pictures. – s_baldur Feb 05 '20 at 11:21 — s_baldur, Feb 05 '20 at 11:21
@ Allan Indeed it helped. Thanks – joy_1379 Feb 05 '20 at 11:29 — joy_1379, Feb 05 '20 at 11:29

score 0 · Answer 1 · answered Feb 05 '20 at 11:27

0

You can use dplyr for this one:

library(dplyr)

word <- c("great", "good", "nice", "great")
freq <- c(2,4,5,6)
df <- data.frame(word = word, freq = as.numeric(freq)) 

df %>% group_by(word) %>%
  summarise(freq = sum(freq))

answered Feb 05 '20 at 11:27

Thomas L.

524
1
5
17

score 0 · Answer 2 · answered Feb 05 '20 at 11:29

0

aggregate(dat$freq, by=list(dat$word), FUN=sum)

answered Feb 05 '20 at 11:29

Carbo

906
5
23

adding values in a row if duplicate value in another row in r

2 Answers2