R for Fun Club (RFC)
Do you want to learn R Programming with other lazy coders? This is your group. We also didn’t... View more
How do I drop all NA’s in this code?
-
How do I drop all NA’s in this code?
Good evening
I’m struggling to remove missing values from my dataset. I want to draw a bar graph without NA.
Ebola <- rio::import(“linelist_raw.xlsx”)
glimpse(Ebola)
Ebola$age <- as.integer(Ebola$age)
Ebola%>%
select(age,outcome)%>%
drop_na(age,outcome)
Ebola$age_group <- cut(Ebola$age, c(0,9,19,29,39,49,59,69,79,80,Inf),
c(“0-9″,”10-19″,”20-29″,”30-39″,”40-49″,”50-59″,”60-69”,
“70-79″,”80-89″,”90+”),include.lowest = TRUE)
Ebola%>%
ggplot(aes(age_group,fill = outcome))+
geom_bar(position = “dodge”) -
6 Replies
-
Hi Koketso,
You need to drop the NA after grouping. You only removed before, so if any data did not fit in your grouping, may cause further NAs. See the code below.
After that, in order to do the ggplot, remember to count by the group to determine the frequency of your intended variables so you can further plot and visualise how they look.
Ebola%>%
count(age_group,outcome)%>%
drop_na(age_group, outcome)%>%
...-
Excellent
-
-
Ebola%>%
select(age,outcome)%>%
drop_na(age,outcome)There was no assignment on this line so the
drop_nanever took effect.As a bonus, if you want to remove
NAsfrom all columns, you don’t need to specify the columns. In your case,drop_na()will achieve the same effect. -
Thanks guys, I will try it out.
-
Thanks, it worked
-
Glad it worked out.
Try adding these snippets to the code.
yor plot code+ labs(x = “Age Group”, y = “Frequency”, fill = “Outcome”) + theme(legend.position = “bottom”)-
This reply was modified 1 year, 1 month ago by
Ibrahim.
-
This reply was modified 1 year, 1 month ago by
-
Log in to reply.