The datasets were arranged by merging three different Land use tables, Population per zip code, Vision Zero Priority Intersections, and Collision data. For land-use, the main focus was to review the demographic data based on the crashes' location. The analytical tool to organize and simplify the data will be Python (package: Pandas), to understand the need for vision zero to include street geometry/ location as a collision factor. Using Python Data cleaning with Pandas and NumPy using the following functions:
Python-Pandas was used to identify the locations with the highest number of collisions.