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