“The automobile has become the carapace, the protective and aggressive shell, of urban and suburban man.”

Our project

This project shows the relationships between time of day, gender, vehicle type and the number of collisions in New York City. It also highlights which boroughs experience the most number of collisions and analyzes contributing factors such as environmental and human-related factors. Our project is catered to make the public conscious about the dangers of car, bicycle, and motorcycle crashes, the danger that exist, and which ways we can prevent injuries and be safe while being on the road.

Topic

We focused on motor vehicle collisions across the five boroughs of New York City to show trends and patterns within the data. Our goal was to understand how various factors correlate with collision frequency and distribution. All our datasets were collected from New York City Open Data.

Data Journey & Process

We used the requests library to retrieve the data and access JSON files from the NYC Open Data API. We worked with three datasets and had a total of 1000 rows with 22 columns. Using the json module, we parsed the raw data into dictionaries for better structure and access. This was then converted into DataFrames, which allowed us to filter, analyze, and visualize the data. We also assigned most of our DataFrames to a different variable for better control to prevent crashes.

Exploration Questions

- Do holidays impact the frequency of motor vehicle collisions?
- Does daytime/nighttime affect the frequency of crashes?
- Do people get killed or injured the most?
- Is it safer to be a pedestrian or cyclist in NYC?
- Do old/young people get into crashes the most?
- What is the typical emotional status of people after a crash?
- Is there any position in a vehicle safer than others?
- Does safety equipment actually prevent death in crashes?
- Are intersections a frequent place of collisions?
- In which NYC boroughs are there more crashes?
- What is the biggest contributing factor for collisions?
- Do people in crashes carry their driver's license?
- What is the most common property affected in crashes?
- Is there a correlation between the states where a car is registered and their frequency of collisions?

Exploration Visual

VIDEOS

TEAM

On the left there is Pomaa and on the right Lindsay. They are Computer Science majors in the Engineering department. Both say that the key to finishing this project was listening to afrobeats while they did it.
About Us

Our mission is to make traffic data more accessible and understandable to the public.

Contact Us
Lindsay Abad
Pomaa Anim-Amofa