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.
Please provide example input, and expected output.
Looks like we need to split rows into new rows, so that every row has only 1 gene, then plot Venn as per manuals.