Intersect Function in R using Dplyr (intersection of data frames)

Intersection of two data frames can be easily achieved by using intersect Function in R Dplyr package . Dplyr package in R is provided with intersect() function

intersect function in R:

intersect function in R takes the rows that appear in both the tables

R intersect Function  example: First lets create two data frames

#Create two data frames

df1 = data.frame(CustomerId = c(1:6), Product = c(rep("Oven", 3), rep("Television", 3)))
df2 = data.frame(CustomerId = c(4:7), Product = c(rep("Television", 2), rep("Air conditioner", 2)))

df1 will be

    CustomerId  Product
1        1                 Oven
2        2                 Oven
3        3                 Oven
4        4                 Television
5        5                 Television
6        6                 Television

df2 will be 

CustomerId         Product

1          4           Television
2          5           Television
3          6          Air conditioner
4          7          Air conditioner

Intersect function takes the rows that appear in both the tables and create the dataframe.

library(dplyr)

#  intersect two dataframes  
intersect(df1,df2)

The resultant dataframe will be

 

 Intersect Function in R using Dplyr (intersection of data frames)                                                                                                            Intersect Function in R using Dplyr (intersection of data frames)

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.

    View all posts