Need a alternative or more complex version of venn diagram in python for matching dna sequences

Question

I am in google colab and I have combined and set up a data frame list of sequences that goes like this

Location ID Sequence

1.1 ........ A ........ AAGAGATA

1.2 ........ A........... CGGATGAT

1.3 ........ B................ ACGTGATC

1.1 ........ B ........ AAGAGATA

1.2 ........ B........... CGGATGAT

1.3 ........ C................ ACGTGATC

So I need to make a alternative to Venn diagram because there are about 20+ ID types within a couple hundred rows of list just like this. And some of the sequences repeat or are unique to its id so I need something to be like

CGGATGAT Shows up 4 times in B,C,A, and D ACGTGATC shows up 1 time in B AGTGTCTC shows up 5 times in E,A,B,C, and D.

And then have some kind of graphical visualation to show all of these common sequences and where they are located and which are unique. Using python. This might be asking for too much but I'm not sure. I would use something like vennr to make a bigger complex version of this but I don't really know R.

Answer 1

To get around limitations in using Venn diagrams for set overlaps, when there are more than three sets, back around 2013 or so I created something I called an Eulergrid plot (example at the bottom of the page), which an UpsetR plot appears to recapitulate, today.

The Eulergrid code I wrote was in a mix of Perl and R; the UpsetR plot code uses R. There appears to be a Python port of UpsetR that might work, as well.