Group by and count with R

Question

I have a table in R that kinda looks like this:

doctors_region <- doctors %>%
 group_by(Region, DoctorID)%>%
 summarise(number = n())

doctors_region

I tried to edit your table but I couldn't make it into a valid table. Can you please post a [reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) of your data with `dput(head(doctors_region))`? The code looks OK if the data is in the correct format so I suspect it isn't... — SamR, Jul 21 '22 at 17:46

score 0 · Accepted Answer · answered Jul 21 '22 at 17:46

0

Try using count() instead, e.g.

doctors_region <- doctors %>%
 group_by(Region, DoctorID)%>%
 count()

I don't have your data, so here is an example using mtcars

library(dplyr)

mtcars %>% 
  group_by(am, gear) %>% 
  count()
#> # A tibble: 4 x 3
#> # Groups:   am, gear [4]
#>      am  gear     n
#>   <dbl> <dbl> <int>
#> 1     0     3    15
#> 2     0     4     4
#> 3     1     4     8
#> 4     1     5     5

^{Created on 2022-07-21 by the reprex package (v2.0.1)}

Here is the documentation, which also has more examples.

answered Jul 21 '22 at 17:46

mhovd

3,724
2
21
47

2

Or even `mtcars %>% count(am, gear)`. Though the output is not a tibble. – Chamkrai Jul 21 '22 at 18:00
True, and a good remark! I wanted to showcase the `group_by`, as the original question used it. – mhovd Jul 21 '22 at 18:01

Group by and count with R

1 Answers1