dplyr: aggregating with group_by

Asked Jun 04 '15 at 16:52

Active Jun 04 '15 at 16:52

Viewed 81 times

I'm getting unexpected results when trying to sum by group using dplyr. Instead of getting the sum of sales for each person, I keep getting the sum of sales for everyone. Here's an example:

library(dplyr)

df <- data.frame(name = rep(c("John","Mary", "Lee"),3), 
                 year = rep(c(2014,2013,2012), each=3), 
                 sales = rep(c(10,20,30),3)
                )

df %>% 
  group_by(name) %>%
  summarise(totals = sum(sales))

This should be so simple but I can't seem to get it to work. What am I doing wrong?

asked Jun 04 '15 at 16:52

Phoebe

8

detach the `plyr` package. – David Arenburg Jun 04 '15 at 16:55
David, thank you so much. That did it! – Phoebe Jun 04 '15 at 17:01
3

In the future, you 1. can do `library(plyr)` *before* the first occurence of `library(dplyr)` 2. can get around this by specifying `dplyr::summarise` – David Robinson Jun 04 '15 at 17:02
Did you notice the warning if you loaded `plyr` after `dplyr`? See also [here](http://stackoverflow.com/questions/26106146/using-dplyr-to-summarise-by-group). – Henrik Jun 04 '15 at 17:52

dplyr: aggregating with group_by

0 Answers0