Assignment 2: Carla Caban

When looking through the New York State open data site, the dataset on Hospital Acquired Infections stood out to me. I thought it would be interesting to see how the number of acquired infections varies from hospital to hospital. All acute care hospitals are required to report certain hospital-acquired infections to the New York State Department of Health (NYSDOH). These include: central line-associated blood stream infections in intensive care units; surgical site infections following colon, hip replacement/revision, and coronary artery bypass graft; and Clostridium difficile infections.

For this assignment, I decided to focus on the main hospitals in Syracuse area: Crouse Hospital, St. Joseph’s Hospital Health Center, University Hospital and Upstate Medical University.

I started by filtering the dataset to only show those particular hospitals. Then I put each hospital data in a separate sheet to analyze them. I sorted each one by year and then summed the number of infections acquired by year. Ultimately this let me compare each hospital visually in order to see the variances in number of cases of infection. Below is a visualization of the data.