Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)

by

I believe you’ve loaded plyr after dplyr, which is why you are getting an overall summary instead of a grouped summary.

This is what happens with plyr loaded last.

library(dplyr)
library(plyr)
df %>%
      group_by(DRUG,FED) %>%
      summarize(mean=mean(AUC0t, na.rm=TRUE), 
                low = CI90lo(AUC0t), 
                 high= CI90hi(AUC0t),
                 min=min(AUC0t, na.rm=TRUE),
                 max=max(AUC0t,na.rm=TRUE), 
                 sd= sd(AUC0t, na.rm=TRUE))

  mean low high min max sd
1  150 105  195 100 200 50

Now remove plyr and try again and you get the grouped summary.

detach(package:plyr)
df %>%
      group_by(DRUG,FED) %>%
      summarize(mean=mean(AUC0t, na.rm=TRUE), 
                low = CI90lo(AUC0t), 
                 high= CI90hi(AUC0t),
                 min=min(AUC0t, na.rm=TRUE),
                 max=max(AUC0t,na.rm=TRUE), 
                 sd= sd(AUC0t, na.rm=TRUE))

Source: local data frame [4 x 8]
Groups: DRUG

  DRUG FED mean low high min max  sd
1    0   0  150 150  150 150 150 NaN
2    0   1  NaN  NA   NA  NA  NA NaN
3    1   0  100 100  100 100 100 NaN
4    1   1  200 200  200 200 200 NaN

More Related Contents:

  1. Why does summarize or mutate not work with group_by when I load `plyr` after `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. Unique rows, considering two columns, in R, without order
  5. Applying a function to every row of a table using dplyr?
  6. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  7. dplyr: “Error in n(): function should not be called directly”
  8. Count number of rows by group using dplyr
  9. How to strsplit different number of strings in certain column by do function
  10. Change value of variable with dplyr
  11. Gather multiple sets of columns
  12. How to get summary statistics by group
  13. Getting the top values by group
  14. R spreading multiple columns with tidyr [duplicate]
  15. Remove group from data.frame if at least one group member meets condition
  16. Display / print all rows of a tibble (tbl_df)
  17. Finding Overlaps between interval sets / Efficient Overlap Joins
  18. R dplyr rolling sum
  19. How to remove rows with any zero value
  20. Select columns based on string match – dplyr::select
  21. How to aggregate a dataframe by week?
  22. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  23. meaning of ddply error: ‘names’ attribute [9] must be the same length as the vector [1]
  24. dplyr mutate rowwise max of range of columns
  25. Spreading a two column data frame with tidyr
  26. R dplyr rowwise mean or min and other methods?
  27. ddply for sum by group in R
  28. Run a custom function on a data frame in R, by group
  29. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment