I'm trying to take the data on large coronavirus clusters in the US and visualize them to show the sizes and the different settings (prisons, healthcare facilities, etc). I want to show the difference between the different settings.
If the sizes were more similar, I'd try to show a stacked bar chart (with size as horizontal axis and count as vertical axis). Unfortunately, that's not working well because some clusters are much bigger than others.
The first few lines of my data look like (there are lots of aged care facilities with 50 cases):
and the bottom looks like (the prisons and meat packing facilities have huge outbreaks)
I can do some binning and I get this:
But it's still hard to immediately see that some of these setting types have small outbreaks while others have much larger ones.
Any suggestions on how to visualize would help (I use python primarily if that matters)