r - how to count the total without NA

Question

I want to do a summary count by group. And I don't want the final results include the calculation of 'NA'. I used the codes like following:

Outcome <- df %>% group_by(Subject) %>% summarise(Outcome_Count = n(),na.rm=TRUE)

But it did not exclude NA, instead it add a var na.rm. It looks like this:

What should I do now in order to get Outcome without last row? I still want the one for UNKNOWn. It means differently compared to the case with NA.

Answer 1

Maybe this filtering out NA from your key variable:

#Code
Outcome <- df %>% group_by(Subject) %>%
  filter(!is.na(AEOUT)) %>%
  summarise(Outcome_Count = n())