I am currently working on an ambulance dataset and one of my tasks is to find when a patient was misdiagnosed by the call dispatcher.
I have two codes; a dispatch code(what the dispatcher believes is wrong with the patient) and a hospital code(what a doctor decides the actual diagnosis is in hospital)
I'm looking for a way of visualizing the relationship between the two codes i.e. given ambulance code x what is the probability of each ambulance code being the outcome.
This can be computed using SQL pretty easily but I'm looking for a way to visualize/cluster it would be great. Any help would be appreciated.
EDIT: Some good feedback in the comments
firstly the dimensionality: Dispatch code can take 1 of 1722 unique values
hospital codes can take 1 of 1058 unique values
The two codes are entirely different an example would be as follows
Dispatcher 17D03:Unconscious Hospital R41:Other symptoms and signs involving cognitive functions and awareness
My interest is in visualizing the relationship. So for example given a dispatcher code of unconscious what are the most common hospital codes?
Again this is fairly easy to calculate numerically but a visualization would make it easier to explain to my stake holders.