I have a programming question and I want this to be done in R. I have two data frames. The df1 has first three columns as header line and the file is in xlsx format. The second data frame has first line as a header. I want to search the genes from the first line of df1 along with their corresponding mutation to match the genes and mutation in df2 and extract the corresponding values. I want the corresponding values to be inserted in the sample line(I have indicated those columns with *). Also I am not concerned anything with the columns indicated by X. I am a beginner in programming and would really appreciate if you guys could help me get this done. Thank you.
I want this Output: