Eliminating NAs from a ggplot

Question

Very basic question here as I m just starting to use R  but I m trying to create a bar plot of factor counts in ggplot2 and when plotting  get 14 little colored blips representing my actual levels and then a massive grey bar at the end representing the 5000-ish NAs in the sample  it s survey data from a question that only applies to about 5  of the sample    I ve tried the following code to no avail    ggplot data   MyData aes x  the variable  fill the variable  na rm   TRUE         geom bar stat  bin      The addition of the na rm argument here has no apparent effect   meanwhile   ggplot data   na omit MyData  aes x  the variable  fill the variable  na rm   TRUE         geom bar stat  bin      gives me       Error  Aesthetics must either be length one  or the same length as the data    as does affixing the na omit   to the variable  or both MyData and the variable    All I want to do is eliminate the giant NA bar from my graph  can someone please help me do this

User · Answer

You can use the function subset inside ggplot2  Try this  library ggplot2   data  iris   iris Sepal Length 5 10   lt - NA   create some NAs for this example  ggplot data subset iris   is na Sepal Length    aes x Sepal Length      geom bar stat  bin

User · Answer

Additionally  adding na rm  TRUE to your geom bar   will work    ggplot data   MyData aes x  the variable  fill the variable  na rm   TRUE         geom bar stat  bin   na rm   TRUE    I ran into this issue with a loop in a time series and this fixed it  The missing data is removed and the results are otherwise uneffected

User · Answer

From my point of view this error  Error  Aesthetics must either be length one  or the same length as the data  refers to the argument aes x y  I tried the na omit   and worked just fine to  me

User · Answer

Try remove missing instead with vars   the variable  It is very important that you set the vars argument  otherwise remove missing will remove all rows that contain an NA in any column   Setting na rm   TRUE will suppress the warning message   ggplot data   remove missing MyData  na rm   TRUE  vars   the variable  aes x  the variable  fill the variable  na rm   TRUE             geom bar stat  bin

User · Answer

Not sure if you have solved the problem  For this issue  you can use the  filter  function in the dplyr package  The idea is to filter the observations rows whose values of the variable of your interest is not NA  Next  you make the graph with these filtered observations  You can find my codes below  and note that all the name of the data frame and variable is copied from the prompt of your question  Also  I assume you know the pipe operators   library tidyverse    MyDate   gt      filter  is na the variable     gt        ggplot aes x  the variable  fill the variable              geom bar stat  bin      You should be able to remove the annoying NAs on your plot  Hope this works

User · Answer

Just an update to the answer of  rafa pereira  Since ggplot2 is part of tidyverse  it makes sense to use the convenient tidyverse functions to get rid of NAs   library tidyverse  airquality   gt            drop na Ozone    gt           ggplot aes x   Ozone            geom bar stat  bin     Note that you can also use drop na   without columns specification  then all the rows with NAs in any column will be removed

[r] Eliminating NAs from a ggplot

Examples related to r

Examples related to ggplot2