We're assisting the Department of Health and Mental Hygiene within NYC to explore which areas need medicine most. We investigated the data to gain further insight of boroughs in NYC and their frequency of influenza/pneumonia visits.
- Took a random sample of 50,000 encounters in the hospital between the years of 2020-2022.
- Crossed referenced our sample with larger data set to check for similar ratios of zip codes. (zip code 10000 is least represented)
- Removed time from "date" column for more utility.
- Changed "date" column to DateTime for our visualizations.
- Renamed "mod_zcta" to "zip_code" for legibility.
- Created new column for "borough" by filtering and using a for loop through "zip_code" column.
- Brooklyn has the HIGHEST number of pneumonia/infleunza visits.
- Brooklyn has the HIGHEST number of pneumonia/infleunza admissions.
- Brooklyn's pneumonia/influenza visits has had the HIGHEST RATE of increase between all boroughs from the years 2020-2022.
As shown in our analysis, we recommend sending more influenza/pneumonia medicine to Brooklyn due to:
The severity of infleunza/pneumonia visits, as Brooklyn had the most admissions as shown in analysis 1.
The frequency of visits due to influenza/pneumonia as shown in analysis 2.
Over time, Brooklyn has consistently had the highest trajectory over the past two years as shown on analysis 3.
If you'd like to know more about the sample we used, check out our Dashboard:
Tablaeu Dashboard: https://public.tableau.com/app/profile/thomas.segal/viz/Book1_17526901770690/Dashboard?publish=yes
- We focused mainly on visits as frequency highlights the demand for medication in a borough.
- Our most important insight is the understanding of why boroughs have the numbers they do. We then were able to specify which borough needs the most medicine.
Thomas: https://www.linkedin.com/in/thomas-segal-093370369
Vincent: https://www.linkedin.com/in/thevinceperez/
Used dataset for educational purposes.