[Solved] Matching information from different dataframes and filtering out redundant columns


One solution is as follows:

df2[, (df2['Row', ] %in% df1$Row) & (df2['Column', ] %in% df1$Column)]

Head of the output is as follows:

       V1 V2 V3
Row     1  2  3
Column  5  4  3
3      49 29 34
4      45 42 18
5       9 15 45
6      34 35 19

2

solved Matching information from different dataframes and filtering out redundant columns