Example 1: Using merge() Function

Let’s start with our first example. We have two data frames, df1 and df2. We want to check if the rows in df1 are also present in df2.

# Sample data frames
df1 <- data.frame(ID = c(1, 2, 3), Value = c("A", "B", "C"))
df2 <- data.frame(ID = c(2, 3, 4), Value = c("B", "C", "D"))

# Use merge() to find common rows
common_rows <- merge(df1, df2)

# Display the result
print(common_rows)

  ID Value
1  2     B
2  3     C

Step-by-Step Explanation:

1. We create two data frames, df1 and df2, each with an ‘ID’ column and a ‘Value’ column.
2. We use the merge() function to find the common rows between df1 and df2.
3. The result, common_rows, will display rows that exist in both data frames.

Example 2: Using %in% Operator

For our second example, we’ll use the %in% operator to check for the existence of specific values from one data frame in another.

# Check if 'ID' from df1 exists in df2
df1$ExistsInDF2 <- df1$ID %in% df2$ID

# Display the updated df1 with the existence check
print(df1)

  ID Value ExistsInDF2
1  1     A       FALSE
2  2     B        TRUE
3  3     C        TRUE

Step-by-Step Explanation:

1. We add a new column to df1 named ‘ExistsInDF2’.
2. The %in% operator checks each ‘ID’ in df1 against the ’ID’s in df2.
3. The new column in df1 will show TRUE if the ‘ID’ exists in df2 and FALSE otherwise.