I was reading a news item related to accidents and wanted to explore more. With a bit of search, I landed in Govt of India Data website. The website had so much data and visualization in different industries/areas. With another double down, I managed to download the data for Urban accidents in all Indian states.
With a couple of hours of staring at the data and coding, managed to pull out the following charts. The data had absolute numbers for each state and I had come up with a ranking on the following KPIs (had to download population data from Wikipedia according to 2011 census report)
- Number of urban accidents
- Percentage of accidents with a weighted urban population
Feedback loop: Data -> Information -> Insights -> Business Transformation
Tools Used:
- Python (no Numpy or anything else)
- Matplotlib for visualization
- Jupyter to cook Python code quickly
Source code and visualization can be found in my github repo
Questions:
- Why GA has more accidents than TN? (why??)
- Why HP has more accidents than PY? (terrain?)
- What can be done to minimize accidents?
Visit www.geekshub.in to know more and learn more on Python/Go/Cloud/Cloud Native/Javascript
