Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?

by

The problem here is that you are loading dplyr first and then plyr, so plyr’s function summarise is masking dplyr’s function summarise. When that happens you get this warning:

library(plyr)
    Loading required package: plyr
------------------------------------------------------------------------------------------
You have loaded plyr after dplyr - this is likely to cause problems.
If you need functions from both plyr and dplyr, please load plyr first, then dplyr:
library(plyr); library(dplyr)
------------------------------------------------------------------------------------------

Attaching package: ‘plyr’

The following objects are masked from ‘package:dplyr’:

    arrange, desc, failwith, id, mutate, summarise, summarize

So in order for your code to work, either detach plyr detach(package:plyr) or restart R and load plyr first and then dplyr (or load only dplyr):

library(dplyr)
dfx %>% group_by(group, sex) %>% 
  summarise(mean = round(mean(age), 2), sd = round(sd(age), 2))
Source: local data frame [6 x 4]
Groups: group

  group sex  mean    sd
1     A   F 41.51  8.24
2     A   M 32.23 11.85
3     B   F 38.79 11.93
4     B   M 31.00  7.92
5     C   F 24.97  7.46
6     C   M 36.17  9.11

Or you can explicitly call dplyr’s summarise in your code, so the right function will be called no matter how you load the packages:

dfx %>% group_by(group, sex) %>% 
  dplyr::summarise(mean = round(mean(age), 2), sd = round(sd(age), 2))

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. How to select the rows with maximum values in each group with dplyr? [duplicate]
  3. How to create a lag variable within each group?
  4. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  5. Group by multiple columns in dplyr, using string vector input
  6. Calculate group mean, sum, or other summary stats. and assign column to original data
  7. Unique rows, considering two columns, in R, without order
  8. Applying a function to every row of a table using dplyr?
  9. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  10. dplyr: “Error in n(): function should not be called directly”
  11. What does %>% function mean in R?
  12. Use variable names in functions of dplyr
  13. Count number of rows by group using dplyr
  14. How to strsplit different number of strings in certain column by do function
  15. Change value of variable with dplyr
  16. Quickly reading very large tables as dataframes
  17. What are the differences between “=” and “
  18. Apply several summary functions on several variables by group in one call
  19. How to debug “contrasts can be applied only to factors with 2 or more levels” error?
  20. How can I trim leading and trailing white space?
  21. How to generate permutations or combinations of object in R?
  22. Subset rows in a data frame based on a vector of values
  23. How to plot a function curve in R
  24. filter function in dplyr errors: object ‘name’ not found
  25. Create a ranking variable with dplyr?
  26. Is there anything wrong with using T & F instead of TRUE & FALSE?
  27. Join two data frames in R based on closest timestamp
  28. Update/Replace Values in Dataframe with Tidyverse Join
  29. dplyr: put count occurrences into new variable [duplicate]
  30. How to replace certain values in a specific rows and columns with NA in R?

Leave a Comment