HealthCare Analysis

This data analysis project delves into Emergency Room visits, offering valuable insights into patient

demographics, referral patterns, temporal trends, and satisfaction scores.

Consisting of 50.04% administrative and 49.96% non-administrative patients, with a gender distribution of

51% males and 49% females, the data also highlights that 41% are referred patients, while 59% are walk-in

patients,The research reveals crucial aspects of Emergency Room utilization.

The General Practice Department receiving the most referrals and the Renal department receiving the fewest.

Weekdays exhibit three times more patient visits than weekends. The year 2020 witnessed a surge in patient

numbers, possibly linked to the COVID-19 pandemic, particularly during the lockdown period from March to

October.

Adults constitute the majority of patients, while infancy records the lowest.

The associated heatmap visually depicts average wait times and satisfaction scores, showcasing darker shades

to emphasize areas with shorter wait times and higher satisfaction, with an average wait time of 35 minutes.

This analysis serves as a foundation for informed decision-making in healthcare management and resource

allocation.