create groups and count them with dplyr

Question

Hello I have the following database

depa2<-c("La Paz","La Paz","La Paz"      
         ,"La Paz"      , "La Paz"  ,     "La Paz"      
         , "La Paz"   ,    "La Paz"   ,    "La Paz"      
         ,"La Paz"   ,    "La Paz","Cabañas"     
         ,"Cabañas" ,     "Usulután"    , "Usulután"    
         ,"Usulután"     ,"Usulután"    , "Usulután")


condition<-c( "Aprobado",
       "Reprobado", "Reprobado", "Reprobado", "Reprobado"
      ,"Reprobado", "Aprobado" ,"Aprobado", "Reprobado"
       ,"Aprobado" , "Reprobado", "Reprobado", "Reprobado"
      ,"Reprobado" , "Aprobado", "Reprobado"
     , "Aprobado", "Reprobado")


data<-data.frame(depa2,condition)

What I want is to get the following

| -------- | Aprobados |   Reprobados |

| La Paz   | 1         | 6            |

| Cabañas   | 1          | 8          |

| Usulután  | 0          | 4          |

is there any way to do it with dplyr?

Mohamed Desouky · Accepted Answer · 2022-06-11T18:41:54.127

1

Try this

library(dplyr)
data %>% group_by(depa2 , condition) %>% tally() %>%
 tidyr::pivot_wider(names_from = condition , values_from = n , values_fill = 0)

edited Jun 11 '22 at 18:41

answered Jun 11 '22 at 17:59

Mohamed Desouky

4,340
2
4
19

score 0 · Answer 2 · answered Jun 11 '22 at 18:55

0

Base R option:

with(data,table(depa2, condition))

Output:

          condition
depa2      Aprobado Reprobado
  Cabañas         0         2
  La Paz          4         7
  Usulután        2         3

answered Jun 11 '22 at 18:55

Quinten

35,235
5
20
53

He wants to do it with dplyr. – Mohamed Desouky Jun 11 '22 at 19:14

create groups and count them with dplyr

2 Answers2