How to find common rows and columns between two dataframe in R?

Two data frames can have similar rows, and they can be determined. In this article, we will find the common rows and common columns between two data frames, in the R programming language.

Approach

• Create a first data frame
• Create a second data frame
• Compare using required functions
• Copy same rows to another data frame
• Display data frame so generated.

Data frames in use:

data1:

data 2:

Method 1: Using Intersect() Function:

Syntax: intersect(data , data2)

Parameters:

• data/data2 : It is the data frames on which we have to apply the function.

Example:

R

data1 <- data.frame(x1 = 1:7,
                    x2 = letters[1:7],
                    x3 = "y")
data1
data2 <- data.frame(x1 = 2:7,
                   x2 = letters[2:7],
                   x3 = c("x", "x", "y", "y" , "x", "y"))
data2

common_rows <- generics::intersect(data1, data2)
common_rows

Output:

Method 2: Using inner_join() function.

To find the common data using this method first install the “dplyr” package in the R environment.

install.packages(“dplyr”)                         

This module has an inner_join() which finds inner join between two data sets.

Syntax: inner_join(data1,data2)

Parameter:

• data1/data2: two datasets to be compared

Example:

R

library("dplyr")

data1 <- data.frame(x1 = 1:7,
                    x2 = letters[1:7],
                    x3 = "y")
data1
data2 <- data.frame(x1 = 2:7,
                   x2 = letters[2:7],
                   x3 = c("x", "x", "y", "y" , "x", "y"))
data2
common_rows2 <- inner_join(data1, data2)
common_rows2

Output: