Skip to content
This repository has been archived by the owner on Feb 25, 2023. It is now read-only.

Apoorb/Safety_Data_Analysis

Repository files navigation

List of Files:

Task 1: Pivot data: Get County in Rows and Crash type in sheet

  • Reshape_Data_County.py:

Task1.1:

  • Plot_Crashes_SpatioTemporalHeatMaps.py: Use python to plot spatio-temporal plots
  • OutDataForJS_Plots.py: Output the data for Lake/Michael to use JS for leaflet plots
  • dataAggregator.py: Lake's code for cleaning up json for leaflet plots
  • dataAggregator-AxB-SHSP_Cats-County.py: Modified Lake's code for plotting data for SHSP categories

Task 2: Mapping exercise; Map HSIP project ID to segmentation database. Understand trends

  • Find_Missing_Project_list.py: Find the list of missing projects based on 2 tables
  • MappingData.py: Map project ID on GIS
  • MappingData_V1.py: Map data which has HSIP project ID to GIS
  • MappingData_V1 - UpdateProjectInfo.py: Add info for additional projects added by Jesus
  • CheckManualDataCopy.py: Check if I copy pasted the data correctly.

Task 3: Aggregate and Pivot data: Get District in Rows and Crash type in sheet

  • Reshape_Data_District.py: Reshape data by District

Task 4: Concat data

SingleTableDataMapping.py: Get one big table with raw data

Task5: Crash Data Analysis

CrashData_SingleTableHSIP.py: Get single table with Crash data by HSIP projects.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published