Edit Question - KnowledgeHub

Title Body

I have several rows of data (tab separated). I want to find the row which matches elements from two columns (3rd & 4th) in each row with two other columns (10th & 11th) . For example, in row 1 , 95428891 & 95443771 in column 3 & 4 matches elements in columns 10 & 11 in row 19 . Similarly the reciprocal is also true. Elements in columns 3 & 4 in the 19th row also match elements in columns 10 & 11 in row 1 . I need to be able to go through each row and output row indices for corresponding matches. It is possible that sometimes only one of the columns match instead of both (because sometimes there are duplicate numbers), but I need to pick only rows where both columns match and also where there is reciprocal match. So it would be a good idea to output row indices where there is reciprocal match, for eg., 1 & 19 as tab separated values (maybe in a different data.frame object). And the rows that do not have reciprocal matches can be output separately. I am trying to implement this in R to run through several rows of data. 1313 chr2 95428891 95443771 14880 chr2:96036782 205673 + chr2 96036782 96052481 1313 chr2 95428896 95443771 14875 chr2:97111880 205214 - chr2 97111880 97127588 1313 chr2 95443771 95526464 82693 chr2:95609272 1748861 - chr2 95609272 95691902 1313 chr2 95477143 95486318 9175 chr2:97616847 177391 + chr2 97616847 97626039 1313 chr2 95486323 95521267 34944 chr2:97035158 268351 + chr2 97035158 97070183 1313 chr2 95515418 95525958 10540 chr2:95563236 132439 + chr2 95563236 95572666 1314 chr2 95563236 95572666 9430 chr2:95515418 132439 + chr2 95515418 9552595

Tags (comma-separated) Cancel