/DataViz-Project1

Analysis and Visualization of Drug Mortality data from Connecticut.

Primary LanguageJupyter Notebook

DataViz-Project1: Drug Mortality and Socio-Economic Conditions in Connecticut

Extension

This is an extension to the project submitted as part of coursework submitted towards April 2018 UT Data Science and Visualization Bootcamp [https://github.com/krashilili/DataViz-Project1] (Project 1). The following extensions have been made.

  1. Use line plot to visualize the number of deaths for each drug by year. This shows a previously unobserved treand that Heroin overdose deaths have come down in the last year. Impact of almost half the drugs is holding the same over years. png

  2. City-by-city visualization of the number of deaths. png

  3. Comparison between Rural and Urban area deaths. The classification of cities is from Census data. Connecticut is very urban (88%), but rural areas are very disproportionately affected.

Classification Number of Deaths Population Ratio Expected Deaths
Rural 2217 12 489.48
Urban 1862 88 3589.52

Original Project Presentation

[https://github.com/sandhya-sago/DataViz-Project1/blob/master/Drug%20Mortality%20and%20Socio-Economic%20conditions%20in%20Connecticut.pptx] (Original Powerpoint presentation)

Project Proposal

We are looking to analyze trends in drug overdose death rates in Connecticut and suggest improvements in data collection. And the research of the project aims to answer the following questions:

Is there a relationship between

  • drug-induced mortality rates and income?
  • drug-induced mortality rates and age?
  • drug-induced mortality rates and education?
  • drug-induced mortality rates and gender?
  • drug-induced mortality rates and geo-location (counties)?
  • drug-induced mortality rates and unemployment rates?
  • drug-induced mortality rates and barriers to medical treatment?

Data Sources