Skip to content

maadhavan23/4610Fa24Group5---Group-Project-2

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 

Repository files navigation

4610Fa24Group5---Group-Project-2

Team 5 Mist 4610 Group Project 2

Team Name:

4610Fa24Group5

Team Members:

Data Set Description:

The dataset contains detailed records of traffic crashes within the city limits of Chicago under the jurisdiction of the Chicago Police Department(CPD). This dataset covers crash data from select police districts starting in 2015, expanded citywide through 2017 and on. This is a large dataset, including both minor and major crashes recorded by CPD. There are numerous columns within the dataset, but we selected a few key columns to focus on. This includes crash type (categorical), primary contributory cause (categorical), injuries total (numerical), report type (categorical), weather (categorical), crash hour (numerical).

Our 2 Questions:

1. Which specific type of crashes provokes the most injuries, both in total and on a per crash basis?

This question is important in identifying what kinds of crashes have a high possibility of injury and more specifically which crashes have the most injuries, aka crashes that are the most dangerous. Knowing these crash types can help policy makers and authorities to make informed decisions on traffic safety and focus on mitigating these specific crashes. Additionally, identifying these collisions can enable educational campaigns and technological innovations aimed at reducing the particular risks associated with these crashes. Overall, this question highlights areas where action is needed, and encourages the city of Chicago to take the preventative measures against crashes.

2. What external factors contribute to a higher injury rating for pedestrian injuries?

This question is helpful in explaining why pedestrian crashes are more injury-prone, shedding light on contributing factors such as lack of driver wellness or pedestrian visibility. Analyzing external factors (e.g. weather conditions, lighting, vehicle speed, or road design) can help us understand what preventative measures to take, like improving the safety of crosswalks, more speed regulation, and even better monitoring the state of drivers. This understanding can lead to awareness campaigns targeting both drivers and pedestrians, promoting behaviors that reduce injury risks and improve the safety of driving. All in all, visualizing this question can contribute to safer roads, informed policymaking, and ultimately save lives by reducing the severity of traffic incidents.

Manipulations Applied:

Instead of analyzing the overall number of injuries, which is biased due to more frequent crash types such as Rear Endings versus Pedestrian Crashes, we calculated the average number of injuries per crash for each crash type. This was achieved by dividing the total number of injuries (SUM [Injuries Total]) by the total number of crashes ([Crash Count]) for each category. This manipulation allowed us to normalize the data, ensuring that crash types with higher frequencies did not disproportionately affect our analysis. As a result, we can accurately see which crash types have the highest impact on injuries, regardless of how often they occur.

Question #1

Screenshot 2024-11-20 at 12 35 49 PM

Question #2

All Crashes

Screenshot 2024-11-20 at 12 35 59 PM

Pedestrian Crashes

Screenshot 2024-11-20 at 12 33 46 PM

Analysis & Results:

The analysis of crash data in the City of Chicago reveals distinct patterns in total injuries and injuries per crash across various crash types, providing important insights into traffic safety. While certain crash types, such as rear-end collisions, contribute to a significant portion of total injuries due to their high frequency, other crash types, including pedestrian-involved crashes, exhibit disproportionately higher injuries per crash. This disparity highlights the severity and danger associated with specific types of accidents. By normalizing the data to account for crash frequency, it becomes evident that crashes involving pedestrians or head-on collisions result in more severe outcomes, even if they occur less frequently. These findings underscore the importance of implementing targeted safety measures, such as improving pedestrian crosswalk designs, enforcing stricter speed regulations, and enhancing driver education. The results call for a deeper understanding of contributing factors to develop more effective interventions and prevent future harm.

Citations:

City of Chicago. (n.d.). Traffic Crashes - Crashes [Dataset]. Retrieved from https://data.cityofchicago.org/Transportation/Traffic-Crashes-Crashes/85ca-t3if/about_data

Slide Deck

https://docs.google.com/presentation/d/1WW3Qif2VfTisRbleRlYyGdTqupbQf-OkGhLHKTzDKjw/edit?usp=sharing

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors