akshaypakhle10 / nyc-motor-vehicle-collisions Goto Github PK

This is a the repository for my EDAV(Exploratory data analysis and Visualization Statistics W5702 #STATW5702) final project. It is based on the template created with File, New Project..., New Directory, Book Project using bookdown in RStudio.

The latest census data (Public Use Microdata Sample : https://www.census.gov/programs-surveys/acs/data/pums.html) shows that about 45 percent of the 3.1 million households own a car. So, it comes as no surprise that annual average(2012-2019) of motor vehicle collision(MVC) is north of 10,000. With about 1000 losing their lives and several thousands being hospitalized every year owing to such incidents. The city administration has taken several steps to curb MVCs after it reached an all time high of 149,218 crashes in 2015.

Our analysis focuses on the impact of the Vision Zero program introduced by Mayor of New York, Bill de Blasio , in 2014. We analyse the overall trends in vehicular collision in the state of New York. By measuring the effect of policies made by the city’s administration, we aim to provide insights to substantiate future policy updates. We leverage the Motor Vehicle Collisions dataset provided by NYC Open Data for our analysis(https://data.cityofnewyork.us/Public-Safety/Motor-Vehicle-Collisions-Crashes/h9gi-nx95).

This analysis investigates:

• Most frequent causes of accidents
• Vehicle type involved in most crashes
• Intersections that are most vulnerable to crashes
• Increase in severity of crashes

The report of our analysis can be found here: http://www.columbia.edu/~avp2131/EDAV/