ID Mapping code

Question

[aisha.ghani]

Hi, this is Aisha, i have problem in my research. i want to write a code in R language , which will take two interactions files of protein ids and will give me a third file of interaction data. the first file will contain two column of interaction data. the second file will have all the data of first file in one column and second column with gene or protein numbers. by combining these two files using R code, a third file must be generated . which map gene or protein numbers instead of protein ids. i need R code for it, can anybody help me out of this?

[Sam]

There are two options for you, the first one is to use merge, the second is to use %in% I suggest you to first try writing the code yourself

[aisha.ghani]

Thank you Andrew....

Answer 1

[andrew.j.skelton73]

Check out the left_join function in dplyr

Example