na_if R Function of dplyr Package (2 Examples) | Convert Value to NA

 

In this article you’ll learn how to replace NA values with the na_if function of the dplyr add-on package in the R programming language.

The article will contain this:

Let’s jump right to the examples.

 

Example 1: Apply na_if Function to Vector

As first step, we need to install and load the dplyr package to R:

install.packages("dplyr")         # Install dplyr add-on package
library("dplyr")                  # Load dplyr add-on package

Furthermore, we have to create an example vector, to which we can apply the na_if function later on:

x <- 1:10                         # Create example vector
x                                 # Print example vector
# 1  2  3  4  5  6  7  8  9 10

Now, we can use the na_if function to replace a certain value of our example vector with NA:

na_if(x, 5)                       # Apply na_if to vector
# 1  2  3  4 NA  6  7  8  9 10

As you can see based on the previous R code and the output of the RStudio console, we replaced the value 5 of our vector with NA.

 

Example 2: Apply na_if Function to Data Frame or Tibble

We can also use the na_if command to replace certain values of a data frame or tibble with NA. Let’s create an example data frame first:

data <- data.frame(x1 = 1:5,      # Create example data
                   x2 = 5:9)
data                              # Print example data
#   x1 x2
# 1  1  5
# 2  2  6
# 3  3  7
# 4  4  8
# 5  5  9

Our data frame contains five rows and two numeric variables. Now, we can apply the na_if function to this data frame as shown below:

na_if(data, 5)                    # Apply na_if to data frame
#   x1 x2
# 1  1 NA
# 2  2  6
# 3  3  7
# 4  4  8
# 5 NA  9

The previous R syntax replaced each 5 in our data set with NA.

 

Video, Further Resources & Summary

Have a look at the following video that I have published on my YouTube channel. I’m explaining further functions of the dplyr package in the video:

 

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.

 

Furthermore, I can recommend to have a look at some of the other articles of my website. You can find some tutorials here:

 

In summary: In this tutorial you learned how to convert values to NA with the dplyr package in the R programming language. If you have further questions or comments, please let me know in the comments below.

 



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.

Menu
Top