Using your final table calculate:
- Total number of unique patients
- Total number of unique diagnosis
- Calculate average and standard deviation of Age.
- Calculate frequencies of the diagnosis and find the most frequent diagnosis.
- Total number of alive and total number of dead patients.
- Total number of alive and total number of dead per ICD9 code (DX)
- Calculate total number of diabetic patients.
- Calculate the average, median and standard deviation of age and the frequencies of the diagnosis.Find the most frequent diagnosis.List the top 20 most frequent diagnoses that co-occur.Calculate number of patients who DON’T have Diabetes Mellitus (DM).
Provide the number of patients who have Diabetes Mellitus (DM)
Submit your code and screen shot of results in a word file.