Count multiple Data in a string cell

Question

I would count with the func table() in R how many time a value occures in a cell. But, some cell contains more value divided by colon. I report an example below:

example <- data.frame(c("A","B","A:::B"))
table(example)

the result is:

A A:::B     B 
1     1     1

but i want something like this

A     B 
2     2

I try to duplicate the rows with this characteristics, but the dataset is already too large and duplicate rows makes dataset impossible to use. How can i do? thanks

akrun · Accepted Answer · 2020-09-11 15:40:52Z

3

We can split the column values by ::: and get the table

table(unlist(strsplit(example[[1]], "\\:+")))
#  A B 
#  2 2

answered Sep 11, 2020 at 15:40

akrun

891k38 gold badges590 silver badges700 bronze badges

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

Collectives™ on Stack Overflow

Count multiple Data in a string cell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related