python - comparing 2 text files for total number and number of matches using a query from third file

Question

I am new to python and looking for a way to compare two text files using the third as a query. File 1 has a list of tab limited pairs. File 2 has genes for items in column1 of file 1 (as in the figure). File 3 has genes for items in column 2 of file 1. I have to compare file 2 and file 3 for genes for every pair of file1. count the number of total genes for each pair and count the number of common genes for each pair. Absolutely no clue how to do this. Your support is much anticipated.. Thank yourna-gene query pairs

rna-genegene-gene

question from:https://stackoverflow.com/questions/65624099/comparing-2-text-files-for-total-number-and-number-of-matches-using-a-query-from

Answer 1

Waitting for answers