dplyr group by multiple variables summarise by multiple variables

Question

New to R. Using dplyr, trying to group_by multiple variables, summarize by multiple variables, multiple functions.

This works as expected

mtcars %>% 
+     group_by(cyl,hp) %>% 
+     summarise(min_mpg = min(mpg) , min_disp = min(disp), max_mpg = max(mpg) , max_disp = max(disp))

But when I try to replicate with my df

vmp %>% 
    +     group_by(Priority,LOS) %>% 
    +     summarise(inv_total = sum(Inv_Total), sr_count = count(SR_Nmbr))

I receive this error:

Error in summarise_impl(.data, dots) : Evaluation error: no applicable method for 'groups' applied to an object of class "factor".

What am I doing wrong? Thx

Prasanna Nandakumar · Accepted Answer · 2017-08-11 06:04:05Z

1

library(dplyr)
vmp %>%
     mutate(Inv_Total=as.numeric(as.character(Inv_Total))) %>% 
     group_by(Priority,LOS) %>%
     summarise(sr_count=n(), 
               inv_total=sum(Inv_Total))

edited Aug 11, 2017 at 6:04

answered Aug 11, 2017 at 5:47

Prasanna Nandakumar

4,33539 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

akrun · Accepted Answer · 2017-08-11 06:18:45Z

0

We can use type.convert to convert the column types automatically

vmp %>%
    mutate_all(funs(type.convert(as.character(.), as.is = TRUE))) %>%
    group_by(Priority, LOS) %>%
    summarise(inv_total = sum(Inv_Total), sr_count =n())

answered Aug 11, 2017 at 6:18

akrun

891k38 gold badges590 silver badges700 bronze badges

Collectives™ on Stack Overflow

dplyr group by multiple variables summarise by multiple variables

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related