Does Medication Tell Us Anything About Patients?

Using the class healthcare dataset (2,608 patient records), I created these three charts compare the five medications by patient count, by medical condition, and by age. The question I wanted to answer: do different medications serve different kinds of patients?

The data

Summary of the full dataset, grouped by medication in Google Sheets (using pivot charts).

MedicationPatientsYoungestAverage ageOldest
Aspirin4981854.285
Ibuprofen5601850.785
Lipitor5091853.485
Paracetamol4811850.685
Penicillin5601849.785
Total2,608
MedicationArthritisAsthmaCancerDiabetesHypertensionObesity
Aspirin8875709174100
Ibuprofen621021009495107
Lipitor8563968610178
Paracetamol986183708485
Penicillin9483971109086
Total427384446451444456

Source: healthcare_dataset

1. Patients per medication

Column chart of patient count per medication

Each medication was given to between 481 and 560 patients, so every drug accounts for roughly a fifth of the dataset (18–21%). Ibuprofen and Penicillin tie for the most patients at 560 each.

2. Medication by condition

Stacked column chart of medication by medical condition

If medications were prescribed for real reasons, each bar would be dominated by the conditions that drug treats. Instead, every medication is spread across all six conditions in similar amounts. Penicillin, an antibiotic, is most often linked to diabetes (110). Lipitor, a cholesterol drug, is given to nearly as many cancer patients (96) as hypertension patients (101).

3. Age spread by medication

Clustered column chart of youngest, average and oldest age per medication

Every medication has exactly the same age range, from 18 to 85, and the averages fall within 4.5 years of each other (49.7 to 54.2). No medication skews toward younger or older patients.

Conclusion

Across all three views, the five medications are close to interchangeable. They have similar patient counts, the same mix of conditions, and the same age range. Here, I have to conclude that medication tells us nothing about who the patient is.