I'm essentially wanting to create this terrible hand drawn graph (see below) for a dataset I have of where I want to illustrate the spread of comorbid diagnoses people with specific pain conditions have.
Larger image of below drawing here:
So, I have four diagnostic groups (FM, CR, CM, HC) and I have 94 reported conditions that are split into 11 categories (Neurological, Psychiatric, Pelvic, Cardiovascular, Autoimmune, Skin, Bone-Muscle-Joint, Digestive, Hormonal, Genetic, Vascular). I then have a column for frequency.
I specifically want to have the 11 categories separated into clusters, and then the first inner ring be the FM group, followed by CR, CM, and HC.
Absolutely any help is appreciated
I have failed at coding with ggplot , but I imagine this is still correct - just a sign of my ignorance.
Edit: Have added sample data and a link to larger image of example.
Category Condition Group Frequency
Neurological Epilepsy FM 0
Neurological Epilepsy CR 1
Neurological Epilepsy CM 0
Neurological Epilepsy HC 1
Neurological Chronic migraine FM 2
Neurological Chronic migraine CR 3
Neurological Chronic migraine CM 7
Neurological Chronic migraine HC 0
Neurological Autism FM 1
Neurological Autism CR 1
Neurological Autism CM 1
Neurological Autism HC 0
Neurological Postherpetic neuralgia FM 0
Neurological Postherpetic neuralgia CR 0
Neurological Postherpetic neuralgia CM 1
Neurological Postherpetic neuralgia HC 0
Neurological Chiari Malformation FM 0
Neurological Chiari Malformation CR 0
Neurological Chiari Malformation CM 1
Neurological Chiari Malformation HC 0
Neurological Syringomyelia FM 0
Neurological Syringomyelia CR 0
Neurological Syringomyelia CM 1
Neurological Syringomyelia HC 0
Neurological Secondary Fibromyalgia FM 0
Neurological Secondary Fibromyalgia CR 7
Neurological Secondary Fibromyalgia CM 0
Neurological Secondary Fibromyalgia HC 0
Neurological Trigeminal neuralgia FM 0
Neurological Trigeminal neuralgia CR 1
Neurological Trigeminal neuralgia CM 0
Neurological Trigeminal neuralgia HC 0
Neurological Diabetes FM 3
Neurological Diabetes CR 3
Neurological Diabetes CM 2
Neurological Diabetes HC 0
Neurological Neurofibromatosis 1 FM 0
Neurological Neurofibromatosis 1 CR 0
Neurological Neurofibromatosis 1 CM 1
Neurological Neurofibromatosis 1 HC 0
Neurological Narcolepsy FM 2
Neurological Narcolepsy CR 0
Neurological Narcolepsy CM 1
Neurological Narcolepsy HC 0
Neurological Neuropathy FM 0
Neurological Neuropathy CR 0
Neurological Neuropathy CM 1
Neurological Neuropathy HC 0
Neurological CNS demyelinating disease FM 0
Neurological CNS demyelinating disease CR 0
Neurological CNS demyelinating disease CM 1
Neurological CNS demyelinating disease HC 0
Neurological Chronic fatigue syndrome FM 12
Neurological Chronic fatigue syndrome CR 1
Neurological Chronic fatigue syndrome CM 0
Neurological Chronic fatigue syndrome HC 0
Neurological Occipital neuralgia FM 0
Neurological Occipital neuralgia CR 1
Neurological Occipital neuralgia CM 0
Neurological Occipital neuralgia HC 0
Neurological Ulnar neuritis FM 0
Neurological Ulnar neuritis CR 1
Neurological Ulnar neuritis CM 0
Neurological Ulnar neuritis HC 0
Psychiatric Anxiety FM 33
Psychiatric Anxiety CR 18
Psychiatric Anxiety CM 22
Psychiatric Anxiety HC 1
Psychiatric Depression FM 38
Psychiatric Depression CR 23
Psychiatric Depression CM 16
Psychiatric Depression HC 2
Psychiatric PTSD FM 11

It's quite a tall order to achieve this type of plot within ggplot, but it can be done with a bit of effort using data manipulation and some manual tweaks:
Data used - fabricated for example