Hi there, I have two list of genes in two columns of a database, my goal is finding what is in common between the two lists, basically an intersection between the two lists. However sometimes rows have multiple entry genes. For example: List 1: (gene a OR gene b, gene c) List 2: (gene a).
The corresponding Venn diagram should give me for not intersected lists genes of list 1: gene c for not intersected lists genes of list 2: empty for intersected genes of list 1 and 2 gene a
Basically it is important that condition "OR" which for that entry can evaluate either gene a OR gene b from list 1 to any entry of list 2. Obviously my situation is more complex because I have thousand of entries for the two lists (my columns) and any list can have multiple choices (my rows with condition "OR"). R or Python would be very much appreciated.
Thank you very much.