Count Occurrences of Character "?" in r

Question

Newbie r question..

I'm looking to generate a frequency count of the number of occurrences of "?" within my data set.

Should look something like this:

encounter_id 0
patient_nbr 0
race 2273
gender 0
weight 98569

I used the following to get a count for the column "weight" but would like a more stream-lined approach to counting all "?" for all columns.. I don't want to have to retype the below function for EACH column..

table(dataset$weight[dataset$weight=="?"])

Any help is appreciated.

Just do a sum `sum(dataset$weight == "?")` – akrun Jul 15 '18 at 02:11 — akrun, Jul 15 '18 at 02:11

score 0 · Answer 1 · answered Jul 15 '18 at 02:09

0

Try this code.

dataset$weight_questmark <- ifelse(dataset$weight == "?", 1, 0)
sum(dataset$weight_questmark)

answered Jul 15 '18 at 02:09

Wooheon

339
1
9

Thanks that works. But what if I want to apply this function to all columns? – gvo369 Jul 15 '18 at 18:15
`find_quest <- function(x) sum(x == "?") ` and `sapply(dataset, find_quest)` – Wooheon Jul 16 '18 at 00:16

Count Occurrences of Character "?" in r

1 Answers1