Good morning, I have two datasets with the exact same columns. I would like to select rows that have a matching ID between the two datasets (Please, see tables below).I tried to merge datasets with the r bind function but all rows were included. Do you have some advice to keep only rows with a matching ID?
Input
df1
ID VAR 1 VAR 2
a ... ...
b ... ...
c ... ...
d ... ...
df2
ID VAR 1 VAR 2
a ... ...
b ... ...
e ... ...
f ... ...
Output
df
ID VAR 1 VAR 2
a ... ...
b ... ...
To merge datasets in R by row including only matching records, you can use the merge() function with the by parameter set to the column(s) that you want to merge on . Here is an example:
# Create two sample data frames
df1
Thanks for your answer. I tried merge but similar to rbind function the merged dataset included both all rows from the first and the second datasets.
I found a solution to this problem.
df2[df2$ID %in% df1$ID,]
df1 includes all identifiers that you want to select matching rows and df2 your dataset including all variables
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column