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:

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