Healthcare analytics case study

Why do patients miss medical appointments?

Python code, visualizations, findings, and recommendations from 110,527 public medical appointment records.

Download Python code View original notebook Read the full Python analysis walkthrough

Bar chart of missed appointments by weekday — **Weekday pattern**Tuesday and Wednesday had the highest missed-appointment counts in this descriptive view.

110,527appointment records

20.19%missed appointments

79.81%attended appointments

6visual views

Problem

Which patient and scheduling factors are associated with missed visits?

The analysis explores appointment attendance patterns across age, gender, SMS reminder status, scholarship status, and weekday. It is presented as descriptive analytics and project evidence, not as a clinical diagnostic tool.

The dataset is not bundled with the website. Local chart exports and code are provided so employers can quickly understand the workflow.

Visual evidence

Six views of appointment behavior.

Appointment attendance comparison — **Attendance balance**Most appointments were attended.

Average age by attendance outcome — **Average age**Age patterns were compared across outcomes.

Attendance by gender — **Gender**Attendance patterns were reviewed by gender.

SMS reminder attendance comparison — **SMS reminders**Reminder behavior was examined descriptively.

Scholarship status attendance comparison — **Support status**Scholarship status did not show a large attendance difference in this view.

Missed appointments by weekday — **Weekday**Early-week outreach may be worth testing.

Code and recommendation

Transparent, reproducible analysis.

Python analysis fileExports the local analysis workflow used for this case study.Download code

Project reflection

Lessons Learned

This project strengthened my ability to transform public healthcare data into clear visual evidence, reproducible Python analysis, and operational recommendations while respecting model and data limitations.

Continue reviewing healthcare analytics evidence.

This case study connects to the broader project gallery, research profile, dashboard work, and CV downloads.

Explore all projects View dashboards View research profile View CV