jeudi 30 juillet 2020

How match two columns of different data table?

I have two data frames that I would like to match similar columns in both data frames and extract the value of another column in one of the data tables.

I have tried the below code but it doesn`t work:

Code:

output <- if (Data_1$Var1 %in% Data_2$Coor) {
      Data_2$binID
      } else if (Data_1$Var2 %in% Data_2$Coor) {
        Data_2$ID
      } else {NA}

Data_1:

                  Var1                    Var2       value
 chr22:17400000-17410000 chr22:16080000-16090000  139.939677
 chr22:17400000-17410000 chr22:26080000-26090000  256.945265
 chr22:33470000-33480000 chr22:16080000-16090000  134.432441

Data_2:

                    coor  ID
 chr22:17400000-17410000  1
 chr22:33470000-33480000  2
 chr22:16080000-16090000  3
 chr22:26080000-26090000  4

Output:

                     ID1                    ID2       value
                       1                      3   139.939677
                       1                      4   256.945265
                       2                      3   134.432441

Aucun commentaire:

Enregistrer un commentaire