Intersection of dataframes using Dplyr in R
In this article, we will discuss how to find the Intersection of two dataframes using the Dplyr package in R programming language.
Dplyr provides intersect() method to get the common data in two dataframes.
Syntax:
intersect(dataframe1,dataframe2,dataframe3,……..,dataframe n)
We can perform this operation on the two dataframes.
Example 1: R program to intersect these two dataframes
R
library (dplyr) # create dataframe1 with college 1 data data1= data.frame (id= c (1,2,3,4,5), name= c ( 'sravan' , 'ojaswi' , 'bobby' , 'gnanesh' , 'rohith' )) # create dataframe1 with college 2 data data2= data.frame (id= c (1,2,3,4,5,6,7), name= c ( 'sravan' , 'ojaswi' , 'bobby' , 'gnanesh' , 'rohith' , 'pinkey' , 'dhanush' )) # intersect both dataframes print ( intersect (data1,data2)) |
Output:
Example 2: Intersection on multiple dataframes
R
library (dplyr) # create dataframe1 with college 1 data data1= data.frame (id= c (1,2,3,4,5), name= c ( 'sravan' , 'ojaswi' , 'bobby' , 'gnanesh' , 'rohith' )) # create dataframe1 with college 2 data data2= data.frame (id= c (1,2,3,4,5,6,7), name= c ( 'sravan' , 'ojaswi' , 'bobby' , 'gnanesh' , 'rohith' , 'pinkey' , 'dhanush' )) # create dataframe1 with college 2 data data3= data.frame (id= c (4,5,6,7), name= c ( 'gnanesh' , 'rohith' , 'pinkey' , 'dhanush' )) # intersect on multiple dataframes print ( intersect (data1,data2,data3)) |
Output: