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):
size category 50 agedcare 50 agedcare 50 agedcare 50 agedcare 50 agedcare 50 agedcare 50 agedcare
and the bottom looks like (the prisons and meat packing facilities have huge outbreaks)
931 prisons 981 prisons 1028 prisons 1031 meat 1051 prisons 1065 prisons 1098 meat 1107 prisons 1283 prisons 1362 prisons 1374 prisons 1791 prisons 2439 prisons
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)