The setdiff R Function (3 Example Codes)

 

Basic R Syntax:

setdiff(x, y)

 

The R function setdiff indicates which elements of a vector or data frame X are not existent in a vector or data frame Y. The previous code illustrates how to use setdiff in R.

In the following article, I’ll show you 3 examples for the usage of the setdiff command in R. Let’s start right away…

 

Example 1: Apply setdiff to Numeric Vectors in R

Let’s first create two example vectors in R:

x <- c(1, 5, 3, 1, 2, 9)              # Example vector 1
y <- c(7, 6, 8, 9, 5, 5, 5, 3)        # Example vector 2

Now, let’s apply the setdiff function to these two vectors:

setdiff(x, y)                         # Apply setdiff function in R
# 1 2

The output in the RStudio console is 1 and 2 – These two values do appear in X, but they do not appear in Y.

 

Note: If you use setdiff the opposite way, i.e. Y and X exchanged, then you receive a different result. Let’s check what we get:

setdiff(y, x)                         # Opposite ordering of X and Y
# 7 6 8

If we use the setdiff R function the other way around, we receive all values that appear in Y, but not in X. Be careful with the ordering!

By the way: I have recently published a video, in which I’m explaing the previous R code in some more detail. You can have a look at 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.

 

Example 2: Use the setdiff Command for Character Vectors

Again, let’s create some example vectors in R – This time character (or string) vectors.

x_char <- c("A", "D", "Hello", "RRR") # Character vector 1
y_char <- c("A", "B", "RRR")          # Character vector 2

If we apply the setdiff R command, we get the character values back, that are existent in the X vector, but not in the Y vector:

setdiff(x_char, y_char)               # Apply setdiff function in R
# "D"     "Hello"

In case of our two example vectors, we get the strings D and Hello.

 

Example 3: setdiff Between R Data Frames

So far, the application of setdiff was quite straightforward. However, the setdiff function can also be used to examine the difference between two data.frames, i.e. multiple columns at once. Consider the following example data:

data1 <- data.frame(x1 = c(1, 4, 8, 1),    # Data Frame 1
                    x2 = c(5, 5, 1, 4),
                    x3 = c(1, 2, 3, 4))
data2 <- data.frame(y1 = c(2, 8, 8, 5),    # Data Frame 2
                    y2 = c(5, 3, 4, 4),
                    y3 = c(1, 2, 3, 4))

 

X Table - First Example Data Frame

Table 1: First Example Data Frame.

 

Y Table - Second Example Data Frame

Table 2: Second Example Data Frame.

 

Let’s apply setdiff to these two data tables:

setdiff(data1, data2)                      # Apply setdiff to data frames
# x1 x2
#  1  5
#  4  5
#  8  1
#  1  4

The setdiff R function returns only the first two columns of our first data matrix data1. What happened to the third column?

Check carefully: X3 and Y3 are identical! For that reason, setdiff returns only the first two columns – The columns that are different.

However, the function returns all rows of these two columns, even though some values of X1 and X2 do also exist in Y1 and Y2.

 

Video Application of setdiff: How to Find a Mismatch in R

The video below of the YouTube channel Xperimental Learning provides you with further examples for the application on setdiff in R:

 

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.

 

Further Reading

 



 

2 Comments. Leave new

  • I used your example employing the setdiff() function on the dataframes. However, in my case, it was not executed and it gave the following error:

    Error: not compatible:
    – Cols in y but not x: `y3`, `y1`, `y2`.
    – Cols in x but not y: `x3`, `x1`, `x2`.

    Can you please resolve it?

    Reply
    • Hi Kashish,

      Could you send the exact R code you are using? Without the code, it’s difficult to spot the issue.

      Regards,

      Joachim

      Reply

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