{ "cells": [ { "cell_type": "markdown", "metadata": { "papermill": { "duration": 0.046585, "end_time": "2021-03-14T03:52:35.098103", "exception": false, "start_time": "2021-03-14T03:52:35.051518", "status": "completed" }, "tags": [] }, "source": [ "# Accidents and Traffic in Atlanta\n", "\n", "### What is my goal for this project?\n", "As someone studying machine learning and data science, I didn't really have a good portfolio of projects to show. I had some experience working on this type of stuff in graduate school, and I have completed several online machine learning and data science courses, but I didn't have many projects to show for that. \n", "\n", "My initial idea for this project was to browse the data sets on Kaggle and pick one that seemed interesting. I would then look at the data, train a classifier or regressor to do some predictions, and put together some written thoughts on it. I didn't really have a plan when I picked the dataset, I just wanted to mess around with it and see what came to me.\n", "\n", "### What dataset did I choose?\n", "After spending some time browsing through various data sets, I ended up choosing [US Accidents (4.2 million records)\n", "A Countrywide Traffic Accident Dataset (2016 - 2020)](https://www.kaggle.com/sobhanmoosavi/us-accidents). There is an accopanying paper for this data set located at [arxiv.org](https://arxiv.org/abs/1906.05409). Using this data set, I narrowed the scope of the data down to the Atlanta, Georgia area where I recently moved.\n", "\n", "### About the Data:\n", "\n", "According to the author, the data was collected in real time using multiple traffic APIs. The majority of the data, approximately 63% and 36%, came from Mapquest and Bing repsectively. The data was collected from February 2016 until December 2020. The author of the data set made some comments on the validity of the data [here](https://www.kaggle.com/sobhanmoosavi/us-accidents/discussion/159189). Overall, the author believes that this data set is a subset of the entire accidents in the United States. The author also discussed a change in collection techniques for MapQuest after August 2017 [here](https://www.kaggle.com/sobhanmoosavi/us-accidents/discussion/126883). \n", "\n", "Given the above information, while the data may not be complete, it should be enough to give an interesting view into the traffic around the Atlanta area.\n", "\n", "The following table is a description of the column values as per the author's [website](https://smoosavi.org/datasets/us_accidents).\n", "\n", "
Attribute | \n", "Description | \n", "
---|---|
ID | \n", "This is a unique identifier of the accident record. | \n", "
Source | \n", "Indicates source of the accident report (i.e. the API which reported the accident.). | \n", "
TMC | \n", "A traffic accident may have a Traffic Message Channel (TMC) code which provides more detailed description of the event. | \n", "
Severity | \n", "Shows the severity of the accident, a number between 1 and 4, where 1 indicates the least impact on traffic (i.e., short delay as a result of the accident) and 4 indicates a significant impact on traffic (i.e., long delay). | \n", "
Start_Time | \n", "Shows start time of the accident in local time zone. | \n", "
End_Time | \n", "Shows end time of the accident in local time zone. End time here refers to when the impact of accident on traffic flow was dismissed. | \n", "
Start_Lat | \n", "Shows latitude in GPS coordinate of the start point. | \n", "
Start_Lng | \n", "Shows longitude in GPS coordinate of the start point. | \n", "
End_Lat | \n", "Shows latitude in GPS coordinate of the end point. | \n", "
End_Lng | \n", "Shows longitude in GPS coordinate of the end point. | \n", "
Distance(mi) | \n", "The length of the road extent affected by the accident. | \n", "
Description | \n", "Shows natural language description of the accident. | \n", "
Number | \n", "Shows the street number in address field. | \n", "
Street | \n", "Shows the street name in address field. | \n", "
Side | \n", "Shows the relative side of the street (Right/Left) in address field. | \n", "
City | \n", "Shows the city in address field. | \n", "
County | \n", "Shows the county in address field. | \n", "
State | \n", "Shows the state in address field. | \n", "
Zipcode | \n", "Shows the zipcode in address field. | \n", "
Country | \n", "Shows the country in address field. | \n", "
Timezone | \n", "Shows timezone based on the location of the accident (eastern, central, etc.). | \n", "
Airport_Code | \n", "Denotes an airport-based weather station which is the closest one to location of the accident. | \n", "
Weather_Timestamp | \n", "Shows the time-stamp of weather observation record (in local time). | \n", "
Temperature(F) | \n", "Shows the temperature (in Fahrenheit). | \n", "
Wind_Chill(F) | \n", "Shows the wind chill (in Fahrenheit). | \n", "
Humidity(%) | \n", "Shows the humidity (in percentage). | \n", "
Pressure(in) | \n", "Shows the air pressure (in inches). | \n", "
Visibility(mi) | \n", "Shows visibility (in miles). | \n", "
Wind_Direction | \n", "Shows wind direction. | \n", "
Wind_Speed(mph) | \n", "Shows wind speed (in miles per hour). | \n", "
Precipitation(in) | \n", "Shows precipitation amount in inches, if there is any. | \n", "
Weather_Condition | \n", "Shows the weather condition (rain, snow, thunderstorm, fog, etc.) | \n", "
Amenity | \n", "A amenity in a nearby location. | \n", "
Bump | \n", "A POI annotation which indicates presence of speed bump or hump in a nearby location. | \n", "
Crossing | \n", "A POI annotation which indicates presence of crossing in a nearby location. | \n", "
Give_Way | \n", "A POI annotation which indicates presence of give_way in a nearby location. | \n", "
Junction | \n", "A POI annotation which indicates presence of junction in a nearby location. | \n", "
No_Exit | \n", "A POI annotation which indicates presence of no_exit in a nearby location. | \n", "
Railway | \n", "A POI annotation which indicates presence of railway in a nearby location. | \n", "
Roundabout | \n", "A POI annotation which indicates presence of roundabout in a nearby location. | \n", "
Station | \n", "A POI annotation which indicates presence of station in a nearby location. | \n", "
Stop | \n", "A POI annotation which indicates presence of stop in a nearby location. | \n", "
Traffic_Calming | \n", "A POI annotation which indicates presence of traffic_calming in a nearby location. | \n", "
Traffic_Signal | \n", "A POI annotation which indicates presence of traffic_signal in a nearby location. | \n", "
Turning_Loop | \n", "A POI annotation which indicates presence of turning_loop in a nearby location. | \n", "
Sunrise_Sunset | \n", "Shows the period of day (i.e. day or night) based on sunrise/sunset. | \n", "
Civil_Twilight | \n", "Shows the period of day (i.e. day or night) based on civil twilight. | \n", "
Nautical_Twilight | \n", "Shows the period of day (i.e. day or night) based on nautical twilight. | \n", "
Astronomical_Twilight | \n", "Shows the period of day (i.e. day or night) based on astronomical twilight. | \n", "
\n", " | ID | \n", "Source | \n", "TMC | \n", "Severity | \n", "Start_Time | \n", "End_Time | \n", "Start_Lat | \n", "Start_Lng | \n", "End_Lat | \n", "End_Lng | \n", "Distance(mi) | \n", "Description | \n", "Number | \n", "Street | \n", "Side | \n", "City | \n", "County | \n", "State | \n", "Zipcode | \n", "Country | \n", "Timezone | \n", "Airport_Code | \n", "Weather_Timestamp | \n", "Temperature(F) | \n", "Wind_Chill(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Precipitation(in) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "A-1 | \n", "MapQuest | \n", "201.0 | \n", "3 | \n", "2016-02-08 05:46:00 | \n", "2016-02-08 11:00:00 | \n", "39.865147 | \n", "-84.058723 | \n", "NaN | \n", "NaN | \n", "0.010 | \n", "Right lane blocked due to accident on I-70 Eas... | \n", "NaN | \n", "I-70 E | \n", "R | \n", "Dayton | \n", "Montgomery | \n", "OH | \n", "45424 | \n", "US | \n", "US/Eastern | \n", "KFFO | \n", "2016-02-08 05:58:00 | \n", "36.9 | \n", "NaN | \n", "91.0 | \n", "29.68 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "0.02 | \n", "Light Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
1 | \n", "A-2 | \n", "MapQuest | \n", "201.0 | \n", "2 | \n", "2016-02-08 06:07:59 | \n", "2016-02-08 06:37:59 | \n", "39.928059 | \n", "-82.831184 | \n", "NaN | \n", "NaN | \n", "0.010 | \n", "Accident on Brice Rd at Tussing Rd. Expect del... | \n", "2584.0 | \n", "Brice Rd | \n", "L | \n", "Reynoldsburg | \n", "Franklin | \n", "OH | \n", "43068-3402 | \n", "US | \n", "US/Eastern | \n", "KCMH | \n", "2016-02-08 05:51:00 | \n", "37.9 | \n", "NaN | \n", "100.0 | \n", "29.65 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "0.00 | \n", "Light Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Day | \n", "
2 | \n", "A-3 | \n", "MapQuest | \n", "201.0 | \n", "2 | \n", "2016-02-08 06:49:27 | \n", "2016-02-08 07:19:27 | \n", "39.063148 | \n", "-84.032608 | \n", "NaN | \n", "NaN | \n", "0.010 | \n", "Accident on OH-32 State Route 32 Westbound at ... | \n", "NaN | \n", "State Route 32 | \n", "R | \n", "Williamsburg | \n", "Clermont | \n", "OH | \n", "45176 | \n", "US | \n", "US/Eastern | \n", "KI69 | \n", "2016-02-08 06:56:00 | \n", "36.0 | \n", "33.3 | \n", "100.0 | \n", "29.67 | \n", "10.0 | \n", "SW | \n", "3.5 | \n", "NaN | \n", "Overcast | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "Night | \n", "Night | \n", "Day | \n", "Day | \n", "
3 | \n", "A-4 | \n", "MapQuest | \n", "201.0 | \n", "3 | \n", "2016-02-08 07:23:34 | \n", "2016-02-08 07:53:34 | \n", "39.747753 | \n", "-84.205582 | \n", "NaN | \n", "NaN | \n", "0.010 | \n", "Accident on I-75 Southbound at Exits 52 52B US... | \n", "NaN | \n", "I-75 S | \n", "R | \n", "Dayton | \n", "Montgomery | \n", "OH | \n", "45417 | \n", "US | \n", "US/Eastern | \n", "KDAY | \n", "2016-02-08 07:38:00 | \n", "35.1 | \n", "31.0 | \n", "96.0 | \n", "29.64 | \n", "9.0 | \n", "SW | \n", "4.6 | \n", "NaN | \n", "Mostly Cloudy | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Day | \n", "Day | \n", "Day | \n", "
4 | \n", "A-5 | \n", "MapQuest | \n", "201.0 | \n", "2 | \n", "2016-02-08 07:39:07 | \n", "2016-02-08 08:09:07 | \n", "39.627781 | \n", "-84.188354 | \n", "NaN | \n", "NaN | \n", "0.010 | \n", "Accident on McEwen Rd at OH-725 Miamisburg Cen... | \n", "NaN | \n", "Miamisburg Centerville Rd | \n", "R | \n", "Dayton | \n", "Montgomery | \n", "OH | \n", "45459 | \n", "US | \n", "US/Eastern | \n", "KMGY | \n", "2016-02-08 07:53:00 | \n", "36.0 | \n", "33.3 | \n", "89.0 | \n", "29.65 | \n", "6.0 | \n", "SW | \n", "3.5 | \n", "NaN | \n", "Mostly Cloudy | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
4232536 | \n", "A-4239402 | \n", "Bing | \n", "NaN | \n", "2 | \n", "2019-08-23 18:03:25 | \n", "2019-08-23 18:32:01 | \n", "34.002480 | \n", "-117.379360 | \n", "33.99888 | \n", "-117.37094 | \n", "0.543 | \n", "At Market St - Accident. | \n", "NaN | \n", "Pomona Fwy E | \n", "R | \n", "Riverside | \n", "Riverside | \n", "CA | \n", "92501 | \n", "US | \n", "US/Pacific | \n", "KRAL | \n", "2019-08-23 17:53:00 | \n", "86.0 | \n", "86.0 | \n", "40.0 | \n", "28.92 | \n", "10.0 | \n", "W | \n", "13.0 | \n", "0.00 | \n", "Fair | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
4232537 | \n", "A-4239403 | \n", "Bing | \n", "NaN | \n", "2 | \n", "2019-08-23 19:11:30 | \n", "2019-08-23 19:38:23 | \n", "32.766960 | \n", "-117.148060 | \n", "32.76555 | \n", "-117.15363 | \n", "0.338 | \n", "At Camino Del Rio/Mission Center Rd - Accident. | \n", "NaN | \n", "I-8 W | \n", "R | \n", "San Diego | \n", "San Diego | \n", "CA | \n", "92108 | \n", "US | \n", "US/Pacific | \n", "KMYF | \n", "2019-08-23 18:53:00 | \n", "70.0 | \n", "70.0 | \n", "73.0 | \n", "29.39 | \n", "10.0 | \n", "SW | \n", "6.0 | \n", "0.00 | \n", "Fair | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
4232538 | \n", "A-4239404 | \n", "Bing | \n", "NaN | \n", "2 | \n", "2019-08-23 19:00:21 | \n", "2019-08-23 19:28:49 | \n", "33.775450 | \n", "-117.847790 | \n", "33.77740 | \n", "-117.85727 | \n", "0.561 | \n", "At Glassell St/Grand Ave - Accident. in the ri... | \n", "NaN | \n", "Garden Grove Fwy | \n", "R | \n", "Orange | \n", "Orange | \n", "CA | \n", "92866 | \n", "US | \n", "US/Pacific | \n", "KSNA | \n", "2019-08-23 18:53:00 | \n", "73.0 | \n", "73.0 | \n", "64.0 | \n", "29.74 | \n", "10.0 | \n", "SSW | \n", "10.0 | \n", "0.00 | \n", "Partly Cloudy | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
4232539 | \n", "A-4239405 | \n", "Bing | \n", "NaN | \n", "2 | \n", "2019-08-23 19:00:21 | \n", "2019-08-23 19:29:42 | \n", "33.992460 | \n", "-118.403020 | \n", "33.98311 | \n", "-118.39565 | \n", "0.772 | \n", "At CA-90/Marina Fwy/Jefferson Blvd - Accident. | \n", "NaN | \n", "San Diego Fwy S | \n", "R | \n", "Culver City | \n", "Los Angeles | \n", "CA | \n", "90230 | \n", "US | \n", "US/Pacific | \n", "KSMO | \n", "2019-08-23 18:51:00 | \n", "71.0 | \n", "71.0 | \n", "81.0 | \n", "29.62 | \n", "10.0 | \n", "SW | \n", "8.0 | \n", "0.00 | \n", "Fair | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
4232540 | \n", "A-4239406 | \n", "Bing | \n", "NaN | \n", "2 | \n", "2019-08-23 18:52:06 | \n", "2019-08-23 19:21:31 | \n", "34.133930 | \n", "-117.230920 | \n", "34.13736 | \n", "-117.23934 | \n", "0.537 | \n", "At Highland Ave/Arden Ave - Accident. | \n", "NaN | \n", "CA-210 W | \n", "R | \n", "Highland | \n", "San Bernardino | \n", "CA | \n", "92346 | \n", "US | \n", "US/Pacific | \n", "KSBD | \n", "2019-08-23 20:50:00 | \n", "79.0 | \n", "79.0 | \n", "47.0 | \n", "28.63 | \n", "7.0 | \n", "SW | \n", "7.0 | \n", "0.00 | \n", "Fair | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
4232541 rows × 49 columns
\n", "\n", " | ID | \n", "Source | \n", "TMC | \n", "Severity | \n", "Start_Time | \n", "End_Time | \n", "Start_Lat | \n", "Start_Lng | \n", "End_Lat | \n", "End_Lng | \n", "Distance(mi) | \n", "Description | \n", "Number | \n", "Street | \n", "Side | \n", "City | \n", "County | \n", "State | \n", "Zipcode | \n", "Country | \n", "Timezone | \n", "Airport_Code | \n", "Weather_Timestamp | \n", "Temperature(F) | \n", "Wind_Chill(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Precipitation(in) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146255 | \n", "A-146262 | \n", "MapQuest | \n", "245.0 | \n", "3 | \n", "2016-11-30 15:13:44 | \n", "2016-11-30 17:26:28 | \n", "33.546177 | \n", "-84.577347 | \n", "NaN | \n", "NaN | \n", "0.01 | \n", "Two lanes blocked due to accident on I-85 Nort... | \n", "NaN | \n", "Senoia Rd | \n", "R | \n", "Fairburn | \n", "Fulton | \n", "GA | \n", "30213 | \n", "US | \n", "US/Eastern | \n", "KATL | \n", "2016-11-30 15:09:00 | \n", "63.0 | \n", "NaN | \n", "97.0 | \n", "29.75 | \n", "3.0 | \n", "WSW | \n", "9.2 | \n", "0.05 | \n", "Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146256 | \n", "A-146263 | \n", "MapQuest | \n", "201.0 | \n", "3 | \n", "2016-11-30 15:25:27 | \n", "2016-11-30 16:54:36 | \n", "33.766376 | \n", "-84.527321 | \n", "NaN | \n", "NaN | \n", "0.01 | \n", "Restrictions on exit ramp due to accident on I... | \n", "NaN | \n", "GA-402 E | \n", "R | \n", "Atlanta | \n", "Fulton | \n", "GA | \n", "30336 | \n", "US | \n", "US/Eastern | \n", "KFTY | \n", "2016-11-30 15:09:00 | \n", "63.0 | \n", "NaN | \n", "90.0 | \n", "29.73 | \n", "3.0 | \n", "SSW | \n", "5.8 | \n", "0.04 | \n", "Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146257 | \n", "A-146264 | \n", "MapQuest | \n", "229.0 | \n", "3 | \n", "2016-11-30 14:42:27 | \n", "2016-11-30 16:57:07 | \n", "33.786896 | \n", "-84.493134 | \n", "NaN | \n", "NaN | \n", "0.01 | \n", "Slow traffic due to accident on I-285 Southbou... | \n", "NaN | \n", "Donald Lee Hollowell Pkwy NW | \n", "R | \n", "Atlanta | \n", "Fulton | \n", "GA | \n", "30331 | \n", "US | \n", "US/Eastern | \n", "KFTY | \n", "2016-11-30 14:40:00 | \n", "63.0 | \n", "NaN | \n", "90.0 | \n", "29.73 | \n", "2.5 | \n", "SSW | \n", "8.1 | \n", "0.62 | \n", "Heavy Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146258 | \n", "A-146265 | \n", "MapQuest | \n", "201.0 | \n", "2 | \n", "2016-11-30 16:27:58 | \n", "2016-11-30 16:57:41 | \n", "33.697849 | \n", "-84.418266 | \n", "NaN | \n", "NaN | \n", "0.01 | \n", "Accident on GA-166 Arthur Langford Pkwy at Syl... | \n", "NaN | \n", "Sylvan Rd | \n", "R | \n", "Atlanta | \n", "Fulton | \n", "GA | \n", "30344 | \n", "US | \n", "US/Eastern | \n", "KATL | \n", "2016-11-30 16:52:00 | \n", "63.0 | \n", "NaN | \n", "97.0 | \n", "29.77 | \n", "9.0 | \n", "WSW | \n", "10.4 | \n", "0.01 | \n", "Overcast | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146259 | \n", "A-146266 | \n", "MapQuest | \n", "201.0 | \n", "3 | \n", "2016-11-30 16:14:20 | \n", "2016-11-30 16:58:59 | \n", "33.696915 | \n", "-84.404984 | \n", "NaN | \n", "NaN | \n", "0.01 | \n", "Accident on I-75 Southbound at Exits 242 243 I... | \n", "NaN | \n", "Arthur Langford Pkwy E | \n", "R | \n", "Atlanta | \n", "Fulton | \n", "GA | \n", "30315 | \n", "US | \n", "US/Eastern | \n", "KATL | \n", "2016-11-30 15:52:00 | \n", "63.0 | \n", "NaN | \n", "97.0 | \n", "29.70 | \n", "10.0 | \n", "SW | \n", "8.1 | \n", "0.13 | \n", "Light Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Wind_Chill(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Precipitation(in) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146255 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "15 | \n", "2 | \n", "33.546177 | \n", "-84.577347 | \n", "63.0 | \n", "NaN | \n", "97.0 | \n", "29.75 | \n", "3.0 | \n", "WSW | \n", "9.2 | \n", "0.05 | \n", "Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146256 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "15 | \n", "2 | \n", "33.766376 | \n", "-84.527321 | \n", "63.0 | \n", "NaN | \n", "90.0 | \n", "29.73 | \n", "3.0 | \n", "SSW | \n", "5.8 | \n", "0.04 | \n", "Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146257 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "15 | \n", "2 | \n", "33.786896 | \n", "-84.493134 | \n", "63.0 | \n", "NaN | \n", "90.0 | \n", "29.73 | \n", "2.5 | \n", "SSW | \n", "8.1 | \n", "0.62 | \n", "Heavy Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146258 | \n", "2 | \n", "2016 | \n", "11 | \n", "30 | \n", "16 | \n", "2 | \n", "33.697849 | \n", "-84.418266 | \n", "63.0 | \n", "NaN | \n", "97.0 | \n", "29.77 | \n", "9.0 | \n", "WSW | \n", "10.4 | \n", "0.01 | \n", "Overcast | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
146259 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "16 | \n", "2 | \n", "33.696915 | \n", "-84.404984 | \n", "63.0 | \n", "NaN | \n", "97.0 | \n", "29.70 | \n", "10.0 | \n", "SW | \n", "8.1 | \n", "0.13 | \n", "Light Rain | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
\n", " | null counts | \n", "percentage | \n", "
---|---|---|
Wind_Chill(F) | \n", "39253 | \n", "56.60 | \n", "
Precipitation(in) | \n", "38395 | \n", "55.36 | \n", "
Wind_Speed(mph) | \n", "8059 | \n", "11.62 | \n", "
Humidity(%) | \n", "338 | \n", "0.49 | \n", "
Temperature(F) | \n", "317 | \n", "0.46 | \n", "
Wind_Direction | \n", "281 | \n", "0.41 | \n", "
Visibility(mi) | \n", "265 | \n", "0.38 | \n", "
Pressure(in) | \n", "239 | \n", "0.34 | \n", "
Weather_Condition | \n", "237 | \n", "0.34 | \n", "
\n", " | null counts | \n", "percentage | \n", "
---|---|---|
Wind_Speed(mph) | \n", "144 | \n", "0.21 | \n", "
Temperature(F) | \n", "136 | \n", "0.20 | \n", "
Humidity(%) | \n", "136 | \n", "0.20 | \n", "
Pressure(in) | \n", "136 | \n", "0.20 | \n", "
Visibility(mi) | \n", "136 | \n", "0.20 | \n", "
Wind_Direction | \n", "136 | \n", "0.20 | \n", "
Weather_Condition | \n", "136 | \n", "0.20 | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2809500 | \n", "4 | \n", "2016 | \n", "7 | \n", "17 | \n", "0 | \n", "6 | \n", "33.868 | \n", "-84.28513 | \n", "72.0 | \n", "91.0 | \n", "30.11 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
150475 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "19 | \n", "5 | \n", "33.917973 | \n", "-84.338135 | \n", "73.0 | \n", "46.0 | \n", "30.14 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Day | \n", "Day | \n", "
150476 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "19 | \n", "5 | \n", "33.937080 | \n", "-84.158661 | \n", "68.0 | \n", "56.0 | \n", "30.18 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Day | \n", "Day | \n", "
150477 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "20 | \n", "5 | \n", "33.912239 | \n", "-84.207817 | \n", "66.9 | \n", "59.0 | \n", "30.17 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150478 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "22 | \n", "5 | \n", "33.699013 | \n", "-84.266167 | \n", "70.0 | \n", "57.0 | \n", "30.18 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150479 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "22 | \n", "5 | \n", "33.827091 | \n", "-84.252602 | \n", "61.0 | \n", "75.0 | \n", "30.18 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150480 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "22 | \n", "5 | \n", "33.821548 | \n", "-84.359383 | \n", "60.1 | \n", "78.0 | \n", "30.19 | \n", "9.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150481 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "23 | \n", "5 | \n", "33.864868 | \n", "-84.439674 | \n", "62.8 | \n", "72.0 | \n", "30.20 | \n", "10.0 | \n", "Calm | \n", "NaN | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2094112 | \n", "2 | \n", "2018 | \n", "6 | \n", "29 | \n", "4 | \n", "4 | \n", "33.849075 | \n", "-84.430061 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
2094116 | \n", "3 | \n", "2018 | \n", "6 | \n", "29 | \n", "4 | \n", "4 | \n", "33.711597 | \n", "-84.217415 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
2094124 | \n", "3 | \n", "2018 | \n", "6 | \n", "29 | \n", "6 | \n", "4 | \n", "33.746490 | \n", "-84.430565 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Day | \n", "Day | \n", "Day | \n", "
2094125 | \n", "3 | \n", "2018 | \n", "6 | \n", "29 | \n", "6 | \n", "4 | \n", "33.742832 | \n", "-84.403595 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Day | \n", "Day | \n", "Day | \n", "
2094136 | \n", "2 | \n", "2018 | \n", "6 | \n", "29 | \n", "7 | \n", "4 | \n", "33.823612 | \n", "-84.367332 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1983936 | \n", "3 | \n", "2018 | \n", "6 | \n", "30 | \n", "11 | \n", "5 | \n", "34.037842 | \n", "-84.562691 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
1983948 | \n", "3 | \n", "2018 | \n", "6 | \n", "30 | \n", "13 | \n", "5 | \n", "33.703480 | \n", "-84.170181 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
1983949 | \n", "3 | \n", "2018 | \n", "6 | \n", "30 | \n", "13 | \n", "5 | \n", "33.928226 | \n", "-84.176018 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
1983950 | \n", "3 | \n", "2018 | \n", "6 | \n", "30 | \n", "14 | \n", "5 | \n", "33.793625 | \n", "-84.392815 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
1983955 | \n", "3 | \n", "2018 | \n", "6 | \n", "30 | \n", "15 | \n", "5 | \n", "33.793625 | \n", "-84.392815 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
580121 | \n", "2 | \n", "2020 | \n", "11 | \n", "8 | \n", "12 | \n", "6 | \n", "33.852207 | \n", "-84.369438 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
580123 | \n", "3 | \n", "2020 | \n", "11 | \n", "8 | \n", "15 | \n", "6 | \n", "33.745125 | \n", "-84.390442 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
580125 | \n", "3 | \n", "2020 | \n", "11 | \n", "8 | \n", "15 | \n", "6 | \n", "33.760025 | \n", "-84.493500 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
580128 | \n", "4 | \n", "2020 | \n", "11 | \n", "8 | \n", "17 | \n", "6 | \n", "33.834286 | \n", "-84.250153 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
580130 | \n", "3 | \n", "2020 | \n", "11 | \n", "8 | \n", "18 | \n", "6 | \n", "33.797981 | \n", "-84.395782 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Day | \n", "Day | \n", "Day | \n", "Day | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2809500 | \n", "4 | \n", "2016 | \n", "7 | \n", "17 | \n", "0 | \n", "6 | \n", "33.868 | \n", "-84.28513 | \n", "72.0 | \n", "91.0 | \n", "30.11 | \n", "10.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Bump | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Roundabout | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Turning_Loop | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
150475 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "19 | \n", "5 | \n", "33.917973 | \n", "-84.338135 | \n", "73.0 | \n", "46.0 | \n", "30.14 | \n", "10.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Day | \n", "Day | \n", "
150476 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "19 | \n", "5 | \n", "33.937080 | \n", "-84.158661 | \n", "68.0 | \n", "56.0 | \n", "30.18 | \n", "10.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Day | \n", "Day | \n", "
150477 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "20 | \n", "5 | \n", "33.912239 | \n", "-84.207817 | \n", "66.9 | \n", "59.0 | \n", "30.17 | \n", "10.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150478 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "22 | \n", "5 | \n", "33.699013 | \n", "-84.266167 | \n", "70.0 | \n", "57.0 | \n", "30.18 | \n", "10.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150479 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "22 | \n", "5 | \n", "33.827091 | \n", "-84.252602 | \n", "61.0 | \n", "75.0 | \n", "30.18 | \n", "10.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150480 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "22 | \n", "5 | \n", "33.821548 | \n", "-84.359383 | \n", "60.1 | \n", "78.0 | \n", "30.19 | \n", "9.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
150481 | \n", "3 | \n", "2016 | \n", "10 | \n", "29 | \n", "23 | \n", "5 | \n", "33.864868 | \n", "-84.439674 | \n", "62.8 | \n", "72.0 | \n", "30.20 | \n", "10.0 | \n", "Calm | \n", "3.1 | \n", "Clear | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "Night | \n", "Night | \n", "Night | \n", "Night | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "15 | \n", "2 | \n", "33.546177 | \n", "-84.577347 | \n", "63.0 | \n", "97.0 | \n", "29.75 | \n", "3.0 | \n", "17 | \n", "9.2 | \n", "Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
1 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "15 | \n", "2 | \n", "33.766376 | \n", "-84.527321 | \n", "63.0 | \n", "90.0 | \n", "29.73 | \n", "3.0 | \n", "12 | \n", "5.8 | \n", "Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
2 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "15 | \n", "2 | \n", "33.786896 | \n", "-84.493134 | \n", "63.0 | \n", "90.0 | \n", "29.73 | \n", "2.5 | \n", "12 | \n", "8.1 | \n", "Heavy Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
3 | \n", "2 | \n", "2016 | \n", "11 | \n", "30 | \n", "16 | \n", "2 | \n", "33.697849 | \n", "-84.418266 | \n", "63.0 | \n", "97.0 | \n", "29.77 | \n", "9.0 | \n", "17 | \n", "10.4 | \n", "Overcast | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
4 | \n", "3 | \n", "2016 | \n", "11 | \n", "30 | \n", "16 | \n", "2 | \n", "33.696915 | \n", "-84.404984 | \n", "63.0 | \n", "97.0 | \n", "29.70 | \n", "10.0 | \n", "13 | \n", "8.1 | \n", "Light Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
69202 | \n", "2 | \n", "2019 | \n", "8 | \n", "23 | \n", "18 | \n", "4 | \n", "33.665910 | \n", "-84.344760 | \n", "83.0 | \n", "67.0 | \n", "28.91 | \n", "10.0 | \n", "7 | \n", "7.0 | \n", "Mostly Cloudy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
69203 | \n", "2 | \n", "2019 | \n", "8 | \n", "23 | \n", "21 | \n", "4 | \n", "33.920200 | \n", "-84.320150 | \n", "80.0 | \n", "74.0 | \n", "28.94 | \n", "10.0 | \n", "4 | \n", "5.0 | \n", "Fair | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
69204 | \n", "2 | \n", "2019 | \n", "8 | \n", "23 | \n", "19 | \n", "4 | \n", "33.803530 | \n", "-84.249600 | \n", "85.0 | \n", "63.0 | \n", "28.92 | \n", "10.0 | \n", "7 | \n", "5.0 | \n", "Partly Cloudy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
69205 | \n", "2 | \n", "2019 | \n", "8 | \n", "23 | \n", "19 | \n", "4 | \n", "33.803350 | \n", "-84.249240 | \n", "85.0 | \n", "63.0 | \n", "28.92 | \n", "10.0 | \n", "7 | \n", "5.0 | \n", "Partly Cloudy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
69206 | \n", "2 | \n", "2019 | \n", "8 | \n", "23 | \n", "20 | \n", "4 | \n", "33.895722 | \n", "-84.252706 | \n", "80.0 | \n", "74.0 | \n", "28.94 | \n", "10.0 | \n", "4 | \n", "5.0 | \n", "Fair | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "
69207 rows × 29 columns
\n", "\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "3 | \n", "2017 | \n", "1 | \n", "2 | \n", "14 | \n", "0 | \n", "33.652431 | \n", "-84.396278 | \n", "55.9 | \n", "100.0 | \n", "30.11 | \n", "0.2 | \n", "6 | \n", "8.1 | \n", "Light Rain | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
1 | \n", "3 | \n", "2017 | \n", "1 | \n", "2 | \n", "14 | \n", "0 | \n", "33.744976 | \n", "-84.390343 | \n", "55.9 | \n", "100.0 | \n", "30.11 | \n", "0.2 | \n", "6 | \n", "8.1 | \n", "Light Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
2 | \n", "3 | \n", "2017 | \n", "1 | \n", "2 | \n", "14 | \n", "0 | \n", "33.928226 | \n", "-84.176018 | \n", "53.1 | \n", "96.0 | \n", "30.13 | \n", "0.5 | \n", "5 | \n", "6.9 | \n", "Light Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
3 | \n", "2 | \n", "2017 | \n", "1 | \n", "2 | \n", "15 | \n", "0 | \n", "33.821548 | \n", "-84.359383 | \n", "53.1 | \n", "96.0 | \n", "30.12 | \n", "1.0 | \n", "14 | \n", "4.6 | \n", "Light Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
4 | \n", "3 | \n", "2017 | \n", "1 | \n", "2 | \n", "15 | \n", "0 | \n", "33.843380 | \n", "-84.487671 | \n", "53.6 | \n", "100.0 | \n", "30.13 | \n", "1.5 | \n", "3 | \n", "6.9 | \n", "Rain | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
\n", " | Severity | \n", "Year | \n", "Month | \n", "Day | \n", "Hour | \n", "DayOfWeek | \n", "Start_Lat | \n", "Start_Lng | \n", "Temperature(F) | \n", "Humidity(%) | \n", "Pressure(in) | \n", "Visibility(mi) | \n", "Wind_Direction | \n", "Wind_Speed(mph) | \n", "Weather_Condition | \n", "Amenity | \n", "Crossing | \n", "Give_Way | \n", "Junction | \n", "No_Exit | \n", "Railway | \n", "Station | \n", "Stop | \n", "Traffic_Calming | \n", "Traffic_Signal | \n", "Sunrise_Sunset | \n", "Civil_Twilight | \n", "Nautical_Twilight | \n", "Astronomical_Twilight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "2020 | \n", "12 | \n", "31 | \n", "6 | \n", "3 | \n", "33.744804 | \n", "-84.350777 | \n", "45.0 | \n", "97.0 | \n", "29.00 | \n", "0.25 | \n", "3 | \n", "5.0 | \n", "Fog | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1 | \n", "3 | \n", "2020 | \n", "12 | \n", "31 | \n", "13 | \n", "3 | \n", "33.758720 | \n", "-84.379395 | \n", "55.0 | \n", "83.0 | \n", "29.20 | \n", "7.00 | \n", "1 | \n", "6.0 | \n", "Cloudy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
2 | \n", "3 | \n", "2020 | \n", "12 | \n", "31 | \n", "14 | \n", "3 | \n", "33.711750 | \n", "-84.217361 | \n", "52.0 | \n", "97.0 | \n", "29.02 | \n", "3.00 | \n", "0 | \n", "0.0 | \n", "Cloudy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
3 | \n", "3 | \n", "2020 | \n", "12 | \n", "31 | \n", "15 | \n", "3 | \n", "33.912098 | \n", "-84.208755 | \n", "54.0 | \n", "93.0 | \n", "29.01 | \n", "3.00 | \n", "1 | \n", "3.0 | \n", "Cloudy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
4 | \n", "3 | \n", "2020 | \n", "12 | \n", "31 | \n", "16 | \n", "3 | \n", "33.797970 | \n", "-84.392929 | \n", "57.0 | \n", "89.0 | \n", "29.18 | \n", "6.00 | \n", "6 | \n", "3.0 | \n", "Cloudy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
Feature | \n", "Why | \n", "
---|---|
Latitude | \n", "Location of an accident is important. | \n", "
Longitude | \n", "Location of an accident is important. | \n", "
Traffic Signal | \n", "Many accidents happen at stop lights. Blocking of intersections can cause extreme delays. | \n", "
Crossing | \n", "Accidents at road crossings without stop lights can backup the roads causing delays. | \n", "
Stop | \n", "Accidents at stop signs could cause traffic to backyp causing extra delays. | \n", "
Hour | \n", "Time of day can affect delays. Example: Delays can be more or less depending on if they happen in rush hour or not. | \n", "
Day Of The Week | \n", "Previous graphs showed less accidents happened on the weekend, so this could help predict delays. | \n", "
Weather Condition | \n", "Weather could be important in predicting delays. Example: Rain slows down traffic. Having an accident could increase the slowdown. | \n", "