How to count multiple column in R

Question

I'm trying to count the number of 0:2 in multiple columns of my data. Here is a sample. Thank for everyone.

df <- data_frame(
  a = sample(0:2, 10, replace=T), 
  b = sample(0:2, 10, replace=T), 
  c = sample(0:2, 10, replace=T), 
  d = sample(0:2, 10, replace=T), 
)

I want to got like this output

score	a	b	c	d
0	2	4	3	4
1	2	5	2	1
2	6	1	5	5

Answer 1

Code

library(tidyr)
library(dplyr)

df %>% 
  pivot_longer(cols = everything(),values_to = "score") %>% 
  count(name,score) %>% 
  pivot_wider(names_from = name,values_from = n,values_fill = 0)