Remove or Show NA Values in Table in R (2 Examples)


In this R tutorial you’ll learn how to remove or show NA values in a frequency table.

The tutorial will contain the following:

Let’s just jump right in…


Example Data

As the first step, let’s create some example data in R:

x <- c("a", "b", "a", NA, "a", "c", "b", NA)    # Create example vector
x                                               # Print example vector
# [1] "a" "b" "a" NA  "a" "c" "b" NA

Have a look at the previous output of the RStudio console. It shows that our example data is a character vector containing letters and some NA values (i.e. missing data).


Example 1: Remove NA from Table

In this example, I’ll demonstrate how to create a frequency table without NA values using the table() function in R.

Have a look at the R code below:

table(x)                                        # Table without NA values
# x
# a b c 
# 3 2 1

As you can see, the NA values have automatically been deleted in the previous output.


Example 2: Show NA in Table

The following R syntax illustrates how to display NA values in a frequency table.

For this task, we can apply the useNA argument of the table function as shown below:

table(x, useNA = "always")                      # Table with NA values
# x
#    a    b    c  
#    3    2    1    2

The previous output illustrates the count of each character as well as the number of NA values in our vector.


Video & Further Resources

I have recently published a video instruction on my YouTube channel, which illustrates the topics of this article. You can find the video below:


Please accept YouTube cookies to play this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.

YouTube Content Consent Button Thumbnail

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.


Besides that, you may read the related articles which I have published on my website. I have published several articles about related topics such as missing data, graphics in R, vectors, and ggplot2.


In this R tutorial you have learned how to remove or explicitly display NA values in a frequency table. Please let me know in the comments below, if you have any further comments and/or questions.


Subscribe to the Statistics Globe Newsletter

Get regular updates on the latest tutorials, offers & news at Statistics Globe.
I hate spam & you may opt out anytime: Privacy Policy.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.