How to count entries in column that are separated by commas

Question

I have a column reasons with rows of survey respondents. Responses in reasons are separated by comma, so one cell in the column reasons would read reason1, reason2, reason3. I want to count entries that include reason1 (whether its the only reason listed or not). So far, I have done this

hair1 = read_excel('hair1.xlsx')
reason1 = data.frame(subset(hair1, reasons=='reason1'))

This only returns survey respondents that listed reason1 and not those who may have listed reason1 with other reasons as well.

dput(head(hair1)) structure(list(reasons = c("reason1, reason2, reason3","reason1, reason2")

Have you try `hair1 = read.excel("hair1.xlsx", sep = ",") ` ? Can you provide the output of `str(hair1)` ? — dc37, Jan 19 '20 at 03:28
just do `reason1 <- subset(hair1, grepl("reason1",reasons))` — Onyambu, Jan 19 '20 at 03:29
```hair1 = read_excel('hair1.xlsx', sep=",")```` returns an error that says **unused argument (sep = ",")** — Jannice Newson, Jan 19 '20 at 03:47
How about `table(hair1$reasons)`? More specifically `table(hair1$reasons)[1]` — markhogue, Jan 19 '20 at 03:48
```reason1 <- subset(hair1, grepl("reason1",reasons))``` returns an error that says **subet must be logical** — Jannice Newson, Jan 19 '20 at 03:49
```str(hair1)``` gives this Classes 'tbl'and 'data.frame': 221 obs of 1 variable: $ reasons: chr "reason1" , "reason1, reason2, reason3" "reason1" "reason1"... — Jannice Newson, Jan 19 '20 at 03:49

score 1 · Answer 1 · answered Jan 19 '20 at 04:04

1

Subset with one equal sign instead of two worked

reason1 = data.frame(subset(hair1, reasons="reason1"))

answered Jan 19 '20 at 04:04

Jannice Newson

15
4

How to count entries in column that are separated by commas

1 Answers1