dataframe - R split string and then sum by character

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65679868/r-split-string-and-then-sum-by-character

Answer 1

Does this work:

library(dplyr)
library(tidyr)

df %>% separate_rows(category, sep = ',') %>% count(category, name = 'frequency')
# A tibble: 3 x 2
  category frequency
  <chr>        <int>
1 A                3
2 B                3
3 C                2