Hi all, I have two dataframes: First data frame has three columns: ID, sire.ID, and Dam.ID
The second dataframe has the same three columns plus genotyping calls for 17 markers in 17 columns.
Here is what I need to be done in R: If sire.ID in the first dataframe exists in the ID column in the second dataframe, then return the sire.ID and its calls from the second dataframe in first dataframe for the relevant offspring, and same for Dam.ID. Simply, for each ID in the first dataframe I want to get the calls for its sire and dam in front of the ID and in two rows. Thanks in advance for your help