California-Traffic-Collision-Data-Anaysis

Data Source - https://www.kaggle.com/alexgude/california-traffic-collision-data-from-switrs

Tech Stacks - Python (Pandas, Numpy, Sklarn, Matplotlib), SQLite Studio, Google Data Studio

(1) Export CSV files from SQLite Studio (collisions, parties, csv)

(2) In order to answer the quesion "Who is usually at fault?", only fatal collisions are considerd due to the memory issue.

(3) For data studio dashboard, 5000 records of fatal collisions due to party fault are uploaded due to the memory issue.

Dashboard Link - https://datastudio.google.com/s/ox9WkRDNba4

REFERENCES:

https://www.kaggle.com/anmoltripathi/vehicle-collision-data-analysis-sdot

https://www.kaggle.com/sstewart0/statistical-analysis

https://www.kaggle.com/abrahamoh/california-s-fatal-car-accidents-who-s-fault-sql