{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "
\n", " | Age | \n", "Citation | \n", "Count | \n", "Date | \n", "Driver_search | \n", "Gender | \n", "GridLocation | \n", "Grid | \n", "Race | \n", "Reason | \n", "Vehicle_search | \n", "Year | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-05-11T20:47:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
1 | \n", "NaN | \n", "No | \n", "1 | \n", "2019-03-03T00:15:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "Black | \n", "Equipment Violation | \n", "No | \n", "2019 | \n", "
2 | \n", "28.0 | \n", "Yes | \n", "1 | \n", "2019-02-13T13:21:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2019 | \n", "
3 | \n", "NaN | \n", "No | \n", "1 | \n", "2019-07-27T21:23:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2019 | \n", "
4 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-01-20T21:19:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
5 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-12-27T14:02:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
6 | \n", "24.0 | \n", "Yes | \n", "1 | \n", "2018-03-13T13:51:00.000 | \n", "No | \n", "Female | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
7 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2019-03-02T22:12:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2019 | \n", "
8 | \n", "25.0 | \n", "Yes | \n", "1 | \n", "2019-06-07T22:08:00.000 | \n", "No | \n", "Female | \n", "NaN | \n", "991.0 | \n", "Other | \n", "Moving Violation | \n", "No | \n", "2019 | \n", "
9 | \n", "NaN | \n", "No | \n", "1 | \n", "2019-01-19T22:08:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2019 | \n", "
10 | \n", "NaN | \n", "No | \n", "1 | \n", "2019-06-07T20:18:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2019 | \n", "
11 | \n", "22.0 | \n", "Yes | \n", "1 | \n", "2018-05-01T14:11:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
12 | \n", "21.0 | \n", "Yes | \n", "1 | \n", "2019-09-27T19:13:00.000 | \n", "No | \n", "Female | \n", "NaN | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2019 | \n", "
13 | \n", "NaN | \n", "No | \n", "1 | \n", "2019-07-20T21:10:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2019 | \n", "
14 | \n", "NaN | \n", "No | \n", "1 | \n", "2019-05-09T16:56:00.000 | \n", "No | \n", "Female | \n", "NaN | \n", "999.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2019 | \n", "
15 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-11-21T18:56:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "Asian | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
16 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-08-01T14:14:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "993.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
17 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-10-27T20:43:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2018 | \n", "
18 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-02-18T00:36:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "996.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
19 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-06-23T00:46:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "993.0 | \n", "Other | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
20 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-11-21T20:06:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
21 | \n", "54.0 | \n", "Yes | \n", "1 | \n", "2018-04-09T14:20:00.000 | \n", "No | \n", "Female | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
22 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-10-05T20:49:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
23 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-10-05T20:35:00.000 | \n", "No | \n", "Female | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
24 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-10-27T21:29:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "Latino | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
25 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2018-06-30T22:35:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "994.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
26 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-01-13T00:51:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2018 | \n", "
27 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-05-11T21:56:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
28 | \n", "NaN | \n", "No | \n", "1 | \n", "2018-02-17T21:37:00.000 | \n", "No | \n", "Female | \n", "NaN | \n", "991.0 | \n", "Black | \n", "Equipment Violation | \n", "No | \n", "2018 | \n", "
29 | \n", "23.0 | \n", "Yes | \n", "1 | \n", "2018-04-12T11:34:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2018 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
784687 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-08-30T17:45:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.959171113', 'longitude': '-93... | \n", "94.0 | \n", "Other | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784688 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-11-02T22:46:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.959369203', 'longitude': '-93... | \n", "87.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784689 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-10-25T03:00:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.96658643', 'longitude': '-93.... | \n", "68.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784690 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-12-07T15:30:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.988221181', 'longitude': '-93... | \n", "11.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784691 | \n", "34.0 | \n", "Yes | \n", "1 | \n", "2017-09-07T08:30:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.928875372', 'longitude': '-93... | \n", "267.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784692 | \n", "30.0 | \n", "Yes | \n", "1 | \n", "2017-09-29T18:33:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.959515062', 'longitude': '-93... | \n", "91.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784693 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2017-09-13T10:42:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.973827765', 'longitude': '-93... | \n", "51.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784694 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2017-07-27T08:06:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.973124945', 'longitude': '-93... | \n", "47.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784695 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-09-20T22:34:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.988314242', 'longitude': '-93... | \n", "14.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784696 | \n", "37.0 | \n", "Yes | \n", "1 | \n", "2017-09-28T09:39:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.980704001', 'longitude': '-93... | \n", "32.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784697 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-07-25T13:50:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.954914788', 'longitude': '-93... | \n", "112.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784698 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2017-12-06T10:20:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.980999933', 'longitude': '-93... | \n", "31.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784699 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2017-10-05T10:03:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.973124945', 'longitude': '-93... | \n", "47.0 | \n", "Latino | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784700 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2017-12-01T11:21:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.928875372', 'longitude': '-93... | \n", "267.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784701 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-10-11T15:12:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.966688357', 'longitude': '-93... | \n", "75.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784702 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-10-03T17:40:00.000 | \n", "Yes | \n", "Male | \n", "{'latitude': '44.959923808', 'longitude': '-93... | \n", "99.0 | \n", "White | \n", "Moving Violation | \n", "Yes | \n", "2017 | \n", "
784703 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-09-29T17:45:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.95086001', 'longitude': '-93.... | \n", "132.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784704 | \n", "27.0 | \n", "Yes | \n", "1 | \n", "2017-08-17T21:35:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.953679624', 'longitude': '-93... | \n", "111.0 | \n", "Other | \n", "Equipment Violation | \n", "No | \n", "2017 | \n", "
784705 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-07-29T01:17:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.980704001', 'longitude': '-93... | \n", "32.0 | \n", "Black | \n", "Equipment Violation | \n", "No | \n", "2017 | \n", "
784706 | \n", "28.0 | \n", "Yes | \n", "1 | \n", "2017-09-25T08:37:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.965443164', 'longitude': '-93... | \n", "269.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784707 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-11-09T10:51:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.952068692', 'longitude': '-93... | \n", "105.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784708 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-12-04T00:15:00.000 | \n", "Yes | \n", "Male | \n", "{'latitude': '44.966741984', 'longitude': '-93... | \n", "73.0 | \n", "Black | \n", "Moving Violation | \n", "Yes | \n", "2017 | \n", "
784709 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-08-31T23:28:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.973798199', 'longitude': '-93... | \n", "50.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2017 | \n", "
784710 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2017-09-07T10:09:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.988189836', 'longitude': '-93... | \n", "9.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784711 | \n", "25.0 | \n", "Yes | \n", "1 | \n", "2017-10-24T08:45:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.952726847', 'longitude': '-93... | \n", "119.0 | \n", "Black | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784712 | \n", "26.0 | \n", "Yes | \n", "1 | \n", "2017-08-22T07:39:00.000 | \n", "No | \n", "Male | \n", "{'latitude': '44.952131905', 'longitude': '-93... | \n", "107.0 | \n", "Other | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784713 | \n", "82.0 | \n", "Yes | \n", "1 | \n", "2017-11-02T12:01:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.916259517', 'longitude': '-93... | \n", "206.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784714 | \n", "NaN | \n", "Yes | \n", "1 | \n", "2017-10-31T09:05:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.908307731', 'longitude': '-93... | \n", "223.0 | \n", "Latino | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
784715 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-09-14T22:42:00.000 | \n", "No | \n", "Male | \n", "NaN | \n", "24.0 | \n", "White | \n", "Equipment Violation | \n", "No | \n", "2017 | \n", "
784716 | \n", "NaN | \n", "No | \n", "1 | \n", "2017-11-22T11:10:00.000 | \n", "No | \n", "Female | \n", "{'latitude': '44.948648967', 'longitude': '-93... | \n", "131.0 | \n", "White | \n", "Moving Violation | \n", "No | \n", "2017 | \n", "
106978 rows × 12 columns
\n", "\n", " | Age | \n", "Citation | \n", "Count | \n", "Date | \n", "Driver_search | \n", "Gender | \n", "GridLocation | \n", "Grid | \n", "Race | \n", "Reason | \n", "... | \n", "Hour | \n", "LateNight | \n", "Equipment Violation | \n", "Moving Violation | \n", "Asian | \n", "Black | \n", "Latino | \n", "Other | \n", "White | \n", "Latitude | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-05-11 20:47:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "20 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
1 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-03-03 00:15:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Equipment Violation | \n", "... | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
2 | \n", "28.0 | \n", "1 | \n", "1 | \n", "2019-02-13 13:21:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "13 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
3 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-07-27 21:23:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "21 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
4 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-01-20 21:19:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "21 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
5 rows × 29 columns
\n", "\n", " | Age | \n", "Citation | \n", "Count | \n", "Date | \n", "Driver_search | \n", "Gender | \n", "GridLocation | \n", "Grid | \n", "Race | \n", "Reason | \n", "... | \n", "Hour | \n", "LateNight | \n", "Equipment Violation | \n", "Moving Violation | \n", "Asian | \n", "Black | \n", "Latino | \n", "Other | \n", "White | \n", "Latitude | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-05-11 20:47:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "20 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
1 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-03-03 00:15:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Equipment Violation | \n", "... | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
2 | \n", "28.0 | \n", "1 | \n", "1 | \n", "2019-02-13 13:21:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "13 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
3 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-07-27 21:23:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "21 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
4 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-01-20 21:19:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "21 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
5 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-12-27 14:02:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "14 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
6 | \n", "24.0 | \n", "1 | \n", "1 | \n", "2018-03-13 13:51:00 | \n", "0 | \n", "1 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "13 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
7 | \n", "NaN | \n", "1 | \n", "1 | \n", "2019-03-02 22:12:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "22 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
8 | \n", "25.0 | \n", "1 | \n", "1 | \n", "2019-06-07 22:08:00 | \n", "0 | \n", "1 | \n", "nan | \n", "991.0 | \n", "Other | \n", "Moving Violation | \n", "... | \n", "22 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "NaN | \n", "
9 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-01-19 22:08:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "22 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
10 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-06-07 20:18:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "20 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
11 | \n", "22.0 | \n", "1 | \n", "1 | \n", "2018-05-01 14:11:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "14 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
12 | \n", "21.0 | \n", "1 | \n", "1 | \n", "2019-09-27 19:13:00 | \n", "0 | \n", "1 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "19 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
13 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-07-20 21:10:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "21 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
14 | \n", "NaN | \n", "0 | \n", "1 | \n", "2019-05-09 16:56:00 | \n", "0 | \n", "1 | \n", "nan | \n", "999.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "16 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
15 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-11-21 18:56:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Asian | \n", "Moving Violation | \n", "... | \n", "18 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
16 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-08-01 14:14:00 | \n", "0 | \n", "0 | \n", "nan | \n", "993.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "14 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
17 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-10-27 20:43:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "20 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
18 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-02-18 00:36:00 | \n", "0 | \n", "0 | \n", "nan | \n", "996.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
19 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-06-23 00:46:00 | \n", "0 | \n", "0 | \n", "nan | \n", "993.0 | \n", "Other | \n", "Moving Violation | \n", "... | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "NaN | \n", "
20 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-11-21 20:06:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "20 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
21 | \n", "54.0 | \n", "1 | \n", "1 | \n", "2018-04-09 14:20:00 | \n", "0 | \n", "1 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "14 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
22 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-10-05 20:49:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "20 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
23 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-10-05 20:35:00 | \n", "0 | \n", "1 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "20 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
24 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-10-27 21:29:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "Latino | \n", "Moving Violation | \n", "... | \n", "21 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "NaN | \n", "
25 | \n", "NaN | \n", "1 | \n", "1 | \n", "2018-06-30 22:35:00 | \n", "0 | \n", "0 | \n", "nan | \n", "994.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "22 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
26 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-01-13 00:51:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
27 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-05-11 21:56:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "21 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
28 | \n", "NaN | \n", "0 | \n", "1 | \n", "2018-02-17 21:37:00 | \n", "0 | \n", "1 | \n", "nan | \n", "991.0 | \n", "Black | \n", "Equipment Violation | \n", "... | \n", "21 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
29 | \n", "23.0 | \n", "1 | \n", "1 | \n", "2018-04-12 11:34:00 | \n", "0 | \n", "0 | \n", "nan | \n", "991.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "11 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
784687 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-08-30 17:45:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.959171113', 'longitude': '-93... | \n", "94.0 | \n", "Other | \n", "Moving Violation | \n", "... | \n", "17 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "44.959171 | \n", "
784688 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-11-02 22:46:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.959369203', 'longitude': '-93... | \n", "87.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "22 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.959369 | \n", "
784689 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-10-25 03:00:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.96658643', 'longitude': '-93.... | \n", "68.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "3 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.966586 | \n", "
784690 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-12-07 15:30:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.988221181', 'longitude': '-93... | \n", "11.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "15 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.988221 | \n", "
784691 | \n", "34.0 | \n", "1 | \n", "1 | \n", "2017-09-07 08:30:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.928875372', 'longitude': '-93... | \n", "267.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "8 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.928875 | \n", "
784692 | \n", "30.0 | \n", "1 | \n", "1 | \n", "2017-09-29 18:33:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.959515062', 'longitude': '-93... | \n", "91.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "18 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.959515 | \n", "
784693 | \n", "NaN | \n", "1 | \n", "1 | \n", "2017-09-13 10:42:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.973827765', 'longitude': '-93... | \n", "51.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "10 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.973828 | \n", "
784694 | \n", "NaN | \n", "1 | \n", "1 | \n", "2017-07-27 08:06:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.973124945', 'longitude': '-93... | \n", "47.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "8 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.973125 | \n", "
784695 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-09-20 22:34:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.988314242', 'longitude': '-93... | \n", "14.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "22 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.988314 | \n", "
784696 | \n", "37.0 | \n", "1 | \n", "1 | \n", "2017-09-28 09:39:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.980704001', 'longitude': '-93... | \n", "32.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "9 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.980704 | \n", "
784697 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-07-25 13:50:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.954914788', 'longitude': '-93... | \n", "112.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "13 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.954915 | \n", "
784698 | \n", "NaN | \n", "1 | \n", "1 | \n", "2017-12-06 10:20:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.980999933', 'longitude': '-93... | \n", "31.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "10 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.981000 | \n", "
784699 | \n", "NaN | \n", "1 | \n", "1 | \n", "2017-10-05 10:03:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.973124945', 'longitude': '-93... | \n", "47.0 | \n", "Latino | \n", "Moving Violation | \n", "... | \n", "10 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "44.973125 | \n", "
784700 | \n", "NaN | \n", "1 | \n", "1 | \n", "2017-12-01 11:21:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.928875372', 'longitude': '-93... | \n", "267.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "11 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.928875 | \n", "
784701 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-10-11 15:12:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.966688357', 'longitude': '-93... | \n", "75.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "15 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.966688 | \n", "
784702 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-10-03 17:40:00 | \n", "1 | \n", "0 | \n", "{'latitude': '44.959923808', 'longitude': '-93... | \n", "99.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "17 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.959924 | \n", "
784703 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-09-29 17:45:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.95086001', 'longitude': '-93.... | \n", "132.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "17 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.950860 | \n", "
784704 | \n", "27.0 | \n", "1 | \n", "1 | \n", "2017-08-17 21:35:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.953679624', 'longitude': '-93... | \n", "111.0 | \n", "Other | \n", "Equipment Violation | \n", "... | \n", "21 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "44.953680 | \n", "
784705 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-07-29 01:17:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.980704001', 'longitude': '-93... | \n", "32.0 | \n", "Black | \n", "Equipment Violation | \n", "... | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.980704 | \n", "
784706 | \n", "28.0 | \n", "1 | \n", "1 | \n", "2017-09-25 08:37:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.965443164', 'longitude': '-93... | \n", "269.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "8 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.965443 | \n", "
784707 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-11-09 10:51:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.952068692', 'longitude': '-93... | \n", "105.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "10 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.952069 | \n", "
784708 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-12-04 00:15:00 | \n", "1 | \n", "0 | \n", "{'latitude': '44.966741984', 'longitude': '-93... | \n", "73.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.966742 | \n", "
784709 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-08-31 23:28:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.973798199', 'longitude': '-93... | \n", "50.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "23 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.973798 | \n", "
784710 | \n", "NaN | \n", "1 | \n", "1 | \n", "2017-09-07 10:09:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.988189836', 'longitude': '-93... | \n", "9.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "10 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.988190 | \n", "
784711 | \n", "25.0 | \n", "1 | \n", "1 | \n", "2017-10-24 08:45:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.952726847', 'longitude': '-93... | \n", "119.0 | \n", "Black | \n", "Moving Violation | \n", "... | \n", "8 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "44.952727 | \n", "
784712 | \n", "26.0 | \n", "1 | \n", "1 | \n", "2017-08-22 07:39:00 | \n", "0 | \n", "0 | \n", "{'latitude': '44.952131905', 'longitude': '-93... | \n", "107.0 | \n", "Other | \n", "Moving Violation | \n", "... | \n", "7 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "44.952132 | \n", "
784713 | \n", "82.0 | \n", "1 | \n", "1 | \n", "2017-11-02 12:01:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.916259517', 'longitude': '-93... | \n", "206.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "12 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.916260 | \n", "
784714 | \n", "NaN | \n", "1 | \n", "1 | \n", "2017-10-31 09:05:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.908307731', 'longitude': '-93... | \n", "223.0 | \n", "Latino | \n", "Moving Violation | \n", "... | \n", "9 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "44.908308 | \n", "
784715 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-09-14 22:42:00 | \n", "0 | \n", "0 | \n", "nan | \n", "24.0 | \n", "White | \n", "Equipment Violation | \n", "... | \n", "22 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "NaN | \n", "
784716 | \n", "NaN | \n", "0 | \n", "1 | \n", "2017-11-22 11:10:00 | \n", "0 | \n", "1 | \n", "{'latitude': '44.948648967', 'longitude': '-93... | \n", "131.0 | \n", "White | \n", "Moving Violation | \n", "... | \n", "11 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "44.948649 | \n", "
101982 rows × 29 columns
\n", "\n", " | Tot_Count | \n", "Eq_Count | \n", "Mov_Count | \n", "Eq_Margin | \n", "Mov_Margin | \n", "Citation_Count | \n", "Eq_Citation | \n", "Mov_Citation | \n", "Driversearch_Count | \n", "Eq_DriverSearch | \n", "Mov_DriverSearch | \n", "Eq_Gender_F | \n", "Mov_Gender_F | \n", "LateNight_Count | \n", "Eq_LateNight | \n", "Mov_LateNight | \n", "Morn_Citation | \n", "Late_Citation | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Race | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Asian | \n", "1592 | \n", "458 | \n", "1134 | \n", "0.287700 | \n", "0.712300 | \n", "594 | \n", "0.168100 | \n", "0.455900 | \n", "138 | \n", "0.122300 | \n", "0.072300 | \n", "0.229300 | \n", "0.2681 | \n", "429 | \n", "0.397400 | \n", "0.2178 | \n", "0.458300 | \n", "0.142200 | \n", "
Black | \n", "7780 | \n", "2610 | \n", "5170 | \n", "0.335500 | \n", "0.664500 | \n", "2902 | \n", "0.206100 | \n", "0.457300 | \n", "781 | \n", "0.131000 | \n", "0.084900 | \n", "0.296200 | \n", "0.3124 | \n", "2286 | \n", "0.394600 | \n", "0.2429 | \n", "0.460900 | \n", "0.161900 | \n", "
Latino | \n", "1112 | \n", "350 | \n", "762 | \n", "0.314700 | \n", "0.685300 | \n", "486 | \n", "0.251400 | \n", "0.522300 | \n", "69 | \n", "0.088600 | \n", "0.049900 | \n", "0.265700 | \n", "0.2822 | \n", "262 | \n", "0.360000 | \n", "0.1785 | \n", "0.521200 | \n", "0.164100 | \n", "
Other | \n", "330 | \n", "85 | \n", "245 | \n", "0.257600 | \n", "0.742400 | \n", "153 | \n", "0.305900 | \n", "0.518400 | \n", "13 | \n", "0.070600 | \n", "0.028600 | \n", "0.305900 | \n", "0.2857 | \n", "74 | \n", "0.352900 | \n", "0.1796 | \n", "0.558600 | \n", "0.135100 | \n", "
White | \n", "7350 | \n", "1925 | \n", "5425 | \n", "0.261900 | \n", "0.738100 | \n", "3478 | \n", "0.328300 | \n", "0.524600 | \n", "300 | \n", "0.058700 | \n", "0.034500 | \n", "0.366200 | \n", "0.3808 | \n", "1320 | \n", "0.264900 | \n", "0.1493 | \n", "0.543000 | \n", "0.154500 | \n", "
Total/Average | \n", "18164 | \n", "5428 | \n", "12736 | \n", "0.298833 | \n", "0.701167 | \n", "7613 | \n", "0.250737 | \n", "0.490892 | \n", "1301 | \n", "0.100958 | \n", "0.059124 | \n", "0.313559 | \n", "0.5000 | \n", "4371 | \n", "0.345984 | \n", "0.0000 | \n", "0.502066 | \n", "0.157401 | \n", "
\n", " | Tot_Count | \n", "Eq_Count | \n", "Mov_Count | \n", "Eq_Margin | \n", "Mov_Margin | \n", "Eq_Gender_F | \n", "Mov_Gender_F | \n", "
---|---|---|---|---|---|---|---|
Race | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Asian | \n", "1592 | \n", "458 | \n", "1134 | \n", "0.287700 | \n", "0.712300 | \n", "0.229300 | \n", "0.2681 | \n", "
Black | \n", "7780 | \n", "2610 | \n", "5170 | \n", "0.335500 | \n", "0.664500 | \n", "0.296200 | \n", "0.3124 | \n", "
Latino | \n", "1112 | \n", "350 | \n", "762 | \n", "0.314700 | \n", "0.685300 | \n", "0.265700 | \n", "0.2822 | \n", "
Other | \n", "330 | \n", "85 | \n", "245 | \n", "0.257600 | \n", "0.742400 | \n", "0.305900 | \n", "0.2857 | \n", "
White | \n", "7350 | \n", "1925 | \n", "5425 | \n", "0.261900 | \n", "0.738100 | \n", "0.366200 | \n", "0.3808 | \n", "
Total/Average | \n", "18164 | \n", "5428 | \n", "12736 | \n", "0.298833 | \n", "0.701167 | \n", "0.313559 | \n", "0.5000 | \n", "
\n", " | Citation_Count | \n", "Eq_Citation | \n", "Mov_Citation | \n", "Driversearch_Count | \n", "Eq_DriverSearch | \n", "Mov_DriverSearch | \n", "
---|---|---|---|---|---|---|
Race | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Asian | \n", "594 | \n", "0.168100 | \n", "0.455900 | \n", "138 | \n", "0.122300 | \n", "0.072300 | \n", "
Black | \n", "2902 | \n", "0.206100 | \n", "0.457300 | \n", "781 | \n", "0.131000 | \n", "0.084900 | \n", "
Latino | \n", "486 | \n", "0.251400 | \n", "0.522300 | \n", "69 | \n", "0.088600 | \n", "0.049900 | \n", "
Other | \n", "153 | \n", "0.305900 | \n", "0.518400 | \n", "13 | \n", "0.070600 | \n", "0.028600 | \n", "
White | \n", "3478 | \n", "0.328300 | \n", "0.524600 | \n", "300 | \n", "0.058700 | \n", "0.034500 | \n", "
Total/Average | \n", "7613 | \n", "0.250737 | \n", "0.490892 | \n", "1301 | \n", "0.100958 | \n", "0.059124 | \n", "
\n", " | LateNight_Count | \n", "Eq_LateNight | \n", "Mov_LateNight | \n", "Morn_Citation | \n", "Late_Citation | \n", "
---|---|---|---|---|---|
Race | \n", "\n", " | \n", " | \n", " | \n", " | \n", " |
Asian | \n", "429 | \n", "0.397400 | \n", "0.2178 | \n", "0.458300 | \n", "0.142200 | \n", "
Black | \n", "2286 | \n", "0.394600 | \n", "0.2429 | \n", "0.460900 | \n", "0.161900 | \n", "
Latino | \n", "262 | \n", "0.360000 | \n", "0.1785 | \n", "0.521200 | \n", "0.164100 | \n", "
Other | \n", "74 | \n", "0.352900 | \n", "0.1796 | \n", "0.558600 | \n", "0.135100 | \n", "
White | \n", "1320 | \n", "0.264900 | \n", "0.1493 | \n", "0.543000 | \n", "0.154500 | \n", "
Total/Average | \n", "4371 | \n", "0.345984 | \n", "0.0000 | \n", "0.502066 | \n", "0.157401 | \n", "
\n", " | Neighborhood | \n", "Neighborhood Latitude | \n", "Neighborhood Longitude | \n", "Venue | \n", "Venue_Latitude | \n", "Venue_Longitude | \n", "Venue_Category | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "67.0 | \n", "44.966603 | \n", "-93.141545 | \n", "Half Time Rec | \n", "44.970362 | \n", "-93.143015 | \n", "Dive Bar | \n", "
1 | \n", "67.0 | \n", "44.966603 | \n", "-93.141545 | \n", "Tobasi Stop | \n", "44.963243 | \n", "-93.139395 | \n", "Convenience Store | \n", "
2 | \n", "67.0 | \n", "44.966603 | \n", "-93.141545 | \n", "Pro-Image Beauty School | \n", "44.963986 | \n", "-93.140867 | \n", "Cosmetics Shop | \n", "
3 | \n", "67.0 | \n", "44.966603 | \n", "-93.141545 | \n", "Minnehaha Liquors | \n", "44.963355 | \n", "-93.140359 | \n", "Liquor Store | \n", "
4 | \n", "67.0 | \n", "44.966603 | \n", "-93.141545 | \n", "Sunrise Creative Gourmet | \n", "44.964883 | \n", "-93.137208 | \n", "Market | \n", "
\n", " | index | \n", "Community | \n", "Count | \n", "Citation | \n", "Equipment Violation | \n", "Moving Violation | \n", "Driver_search | \n", "Vehicle_search | \n", "LateNight | \n", "Asian | \n", "... | \n", "Weekend | \n", "Citation_count | \n", "Equipment Violation_count | \n", "Moving Violation_count | \n", "LateNight_count | \n", "White_Demo | \n", "Black_Demo | \n", "Asian_Demo | \n", "Grid | \n", "Blah | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "98 | \n", "268 | \n", "
1 | \n", "1 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "99 | \n", "599 | \n", "
2 | \n", "2 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "100 | \n", "32 | \n", "
3 | \n", "3 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "118 | \n", "144 | \n", "
4 | \n", "4 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "119 | \n", "682 | \n", "
5 | \n", "5 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "120 | \n", "152 | \n", "
6 | \n", "6 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "137 | \n", "39 | \n", "
7 | \n", "7 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "138 | \n", "87 | \n", "
8 | \n", "8 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "139 | \n", "65 | \n", "
9 | \n", "9 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "140 | \n", "42 | \n", "
10 | \n", "10 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "160 | \n", "70 | \n", "
11 | \n", "11 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "180 | \n", "48 | \n", "
12 | \n", "12 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "197 | \n", "1 | \n", "
13 | \n", "13 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "200 | \n", "3 | \n", "
14 | \n", "14 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "240 | \n", "15 | \n", "
15 | \n", "15 | \n", "Battle_Creek | \n", "2290 | \n", "0.722271 | \n", "0.117467 | \n", "0.882533 | \n", "0.032751 | \n", "0.030568 | \n", "0.154148 | \n", "0.143668 | \n", "... | \n", "0.110480 | \n", "1654 | \n", "269.0 | \n", "2021.0 | \n", "353 | \n", "0.398383 | \n", "0.203079 | \n", "0.231585 | \n", "280 | \n", "43 | \n", "
16 | \n", "16 | \n", "Capital_River | \n", "4911 | \n", "0.697007 | \n", "0.108735 | \n", "0.891265 | \n", "0.029933 | \n", "0.025657 | \n", "0.145795 | \n", "0.083690 | \n", "... | \n", "0.159845 | \n", "3423 | \n", "534.0 | \n", "4377.0 | \n", "716 | \n", "0.675663 | \n", "0.132114 | \n", "0.089509 | \n", "111 | \n", "148 | \n", "
17 | \n", "17 | \n", "Capital_River | \n", "4911 | \n", "0.697007 | \n", "0.108735 | \n", "0.891265 | \n", "0.029933 | \n", "0.025657 | \n", "0.145795 | \n", "0.083690 | \n", "... | \n", "0.159845 | \n", "3423 | \n", "534.0 | \n", "4377.0 | \n", "716 | \n", "0.675663 | \n", "0.132114 | \n", "0.089509 | \n", "112 | \n", "1007 | \n", "
18 | \n", "18 | \n", "Capital_River | \n", "4911 | \n", "0.697007 | \n", "0.108735 | \n", "0.891265 | \n", "0.029933 | \n", "0.025657 | \n", "0.145795 | \n", "0.083690 | \n", "... | \n", "0.159845 | \n", "3423 | \n", "534.0 | \n", "4377.0 | \n", "716 | \n", "0.675663 | \n", "0.132114 | \n", "0.089509 | \n", "131 | \n", "452 | \n", "
19 | \n", "19 | \n", "Capital_River | \n", "4911 | \n", "0.697007 | \n", "0.108735 | \n", "0.891265 | \n", "0.029933 | \n", "0.025657 | \n", "0.145795 | \n", "0.083690 | \n", "... | \n", "0.159845 | \n", "3423 | \n", "534.0 | \n", "4377.0 | \n", "716 | \n", "0.675663 | \n", "0.132114 | \n", "0.089509 | \n", "132 | \n", "230 | \n", "
20 | \n", "20 | \n", "Capital_River | \n", "4911 | \n", "0.697007 | \n", "0.108735 | \n", "0.891265 | \n", "0.029933 | \n", "0.025657 | \n", "0.145795 | \n", "0.083690 | \n", "... | \n", "0.159845 | \n", "3423 | \n", "534.0 | \n", "4377.0 | \n", "716 | \n", "0.675663 | \n", "0.132114 | \n", "0.089509 | \n", "133 | \n", "2307 | \n", "
21 | \n", "21 | \n", "Capital_River | \n", "4911 | \n", "0.697007 | \n", "0.108735 | \n", "0.891265 | \n", "0.029933 | \n", "0.025657 | \n", "0.145795 | \n", "0.083690 | \n", "... | \n", "0.159845 | \n", "3423 | \n", "534.0 | \n", "4377.0 | \n", "716 | \n", "0.675663 | \n", "0.132114 | \n", "0.089509 | \n", "152 | \n", "302 | \n", "
22 | \n", "22 | \n", "Capital_River | \n", "4911 | \n", "0.697007 | \n", "0.108735 | \n", "0.891265 | \n", "0.029933 | \n", "0.025657 | \n", "0.145795 | \n", "0.083690 | \n", "... | \n", "0.159845 | \n", "3423 | \n", "534.0 | \n", "4377.0 | \n", "716 | \n", "0.675663 | \n", "0.132114 | \n", "0.089509 | \n", "153 | \n", "465 | \n", "
23 | \n", "23 | \n", "Como | \n", "1328 | \n", "0.640813 | \n", "0.140813 | \n", "0.859187 | \n", "0.031627 | \n", "0.026355 | \n", "0.192018 | \n", "0.100151 | \n", "... | \n", "0.146084 | \n", "851 | \n", "187.0 | \n", "1141.0 | \n", "255 | \n", "0.762898 | \n", "0.089230 | \n", "0.054048 | \n", "5 | \n", "33 | \n", "
24 | \n", "24 | \n", "Como | \n", "1328 | \n", "0.640813 | \n", "0.140813 | \n", "0.859187 | \n", "0.031627 | \n", "0.026355 | \n", "0.192018 | \n", "0.100151 | \n", "... | \n", "0.146084 | \n", "851 | \n", "187.0 | \n", "1141.0 | \n", "255 | \n", "0.762898 | \n", "0.089230 | \n", "0.054048 | \n", "6 | \n", "29 | \n", "
25 | \n", "25 | \n", "Como | \n", "1328 | \n", "0.640813 | \n", "0.140813 | \n", "0.859187 | \n", "0.031627 | \n", "0.026355 | \n", "0.192018 | \n", "0.100151 | \n", "... | \n", "0.146084 | \n", "851 | \n", "187.0 | \n", "1141.0 | \n", "255 | \n", "0.762898 | \n", "0.089230 | \n", "0.054048 | \n", "7 | \n", "13 | \n", "
26 | \n", "26 | \n", "Como | \n", "1328 | \n", "0.640813 | \n", "0.140813 | \n", "0.859187 | \n", "0.031627 | \n", "0.026355 | \n", "0.192018 | \n", "0.100151 | \n", "... | \n", "0.146084 | \n", "851 | \n", "187.0 | \n", "1141.0 | \n", "255 | \n", "0.762898 | \n", "0.089230 | \n", "0.054048 | \n", "8 | \n", "54 | \n", "
27 | \n", "27 | \n", "Como | \n", "1328 | \n", "0.640813 | \n", "0.140813 | \n", "0.859187 | \n", "0.031627 | \n", "0.026355 | \n", "0.192018 | \n", "0.100151 | \n", "... | \n", "0.146084 | \n", "851 | \n", "187.0 | \n", "1141.0 | \n", "255 | \n", "0.762898 | \n", "0.089230 | \n", "0.054048 | \n", "25 | \n", "100 | \n", "
28 | \n", "28 | \n", "Como | \n", "1328 | \n", "0.640813 | \n", "0.140813 | \n", "0.859187 | \n", "0.031627 | \n", "0.026355 | \n", "0.192018 | \n", "0.100151 | \n", "... | \n", "0.146084 | \n", "851 | \n", "187.0 | \n", "1141.0 | \n", "255 | \n", "0.762898 | \n", "0.089230 | \n", "0.054048 | \n", "26 | \n", "29 | \n", "
29 | \n", "29 | \n", "Como | \n", "1328 | \n", "0.640813 | \n", "0.140813 | \n", "0.859187 | \n", "0.031627 | \n", "0.026355 | \n", "0.192018 | \n", "0.100151 | \n", "... | \n", "0.146084 | \n", "851 | \n", "187.0 | \n", "1141.0 | \n", "255 | \n", "0.762898 | \n", "0.089230 | \n", "0.054048 | \n", "27 | \n", "61 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
171 | \n", "171 | \n", "Union_Park | \n", "3137 | \n", "0.659229 | \n", "0.141536 | \n", "0.858464 | \n", "0.031559 | \n", "0.026777 | \n", "0.184252 | \n", "0.039528 | \n", "... | \n", "0.174370 | \n", "2068 | \n", "444.0 | \n", "2693.0 | \n", "578 | \n", "0.772243 | \n", "0.098012 | \n", "0.037718 | \n", "126 | \n", "189 | \n", "
172 | \n", "172 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "150 | \n", "274 | \n", "
173 | \n", "173 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "151 | \n", "42 | \n", "
174 | \n", "174 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "169 | \n", "463 | \n", "
175 | \n", "175 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "170 | \n", "266 | \n", "
176 | \n", "176 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "171 | \n", "73 | \n", "
177 | \n", "177 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "187 | \n", "59 | \n", "
178 | \n", "178 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "188 | \n", "215 | \n", "
179 | \n", "179 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "189 | \n", "9 | \n", "
180 | \n", "180 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "207 | \n", "433 | \n", "
181 | \n", "181 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "226 | \n", "46 | \n", "
182 | \n", "182 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "230 | \n", "216 | \n", "
183 | \n", "183 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "249 | \n", "80 | \n", "
184 | \n", "184 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "267 | \n", "393 | \n", "
185 | \n", "185 | \n", "West_7th | \n", "3038 | \n", "0.727452 | \n", "0.095787 | \n", "0.904213 | \n", "0.017117 | \n", "0.011521 | \n", "0.108624 | \n", "0.035879 | \n", "... | \n", "0.143186 | \n", "2210 | \n", "291.0 | \n", "2747.0 | \n", "330 | \n", "0.721428 | \n", "0.108826 | \n", "0.029926 | \n", "268 | \n", "469 | \n", "
186 | \n", "186 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "172 | \n", "61 | \n", "
187 | \n", "187 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "173 | \n", "193 | \n", "
188 | \n", "188 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "174 | \n", "245 | \n", "
189 | \n", "189 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "175 | \n", "1 | \n", "
190 | \n", "190 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "192 | \n", "97 | \n", "
191 | \n", "191 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "193 | \n", "154 | \n", "
192 | \n", "192 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "194 | \n", "202 | \n", "
193 | \n", "193 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "195 | \n", "35 | \n", "
194 | \n", "194 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "209 | \n", "6 | \n", "
195 | \n", "195 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "210 | \n", "5 | \n", "
196 | \n", "196 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "211 | \n", "22 | \n", "
197 | \n", "197 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "212 | \n", "34 | \n", "
198 | \n", "198 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "213 | \n", "42 | \n", "
199 | \n", "199 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "214 | \n", "77 | \n", "
200 | \n", "200 | \n", "West_Side | \n", "1192 | \n", "0.433725 | \n", "0.279362 | \n", "0.720638 | \n", "0.083893 | \n", "0.078020 | \n", "0.353188 | \n", "0.041946 | \n", "... | \n", "0.283557 | \n", "517 | \n", "333.0 | \n", "859.0 | \n", "421 | \n", "0.453392 | \n", "0.135823 | \n", "0.064984 | \n", "215 | \n", "18 | \n", "
201 rows × 25 columns
\n", "" ], "text/plain": [ " index Community Count Citation Equipment Violation \\\n", "0 0 Battle_Creek 2290 0.722271 0.117467 \n", "1 1 Battle_Creek 2290 0.722271 0.117467 \n", "2 2 Battle_Creek 2290 0.722271 0.117467 \n", "3 3 Battle_Creek 2290 0.722271 0.117467 \n", "4 4 Battle_Creek 2290 0.722271 0.117467 \n", "5 5 Battle_Creek 2290 0.722271 0.117467 \n", "6 6 Battle_Creek 2290 0.722271 0.117467 \n", "7 7 Battle_Creek 2290 0.722271 0.117467 \n", "8 8 Battle_Creek 2290 0.722271 0.117467 \n", "9 9 Battle_Creek 2290 0.722271 0.117467 \n", "10 10 Battle_Creek 2290 0.722271 0.117467 \n", "11 11 Battle_Creek 2290 0.722271 0.117467 \n", "12 12 Battle_Creek 2290 0.722271 0.117467 \n", "13 13 Battle_Creek 2290 0.722271 0.117467 \n", "14 14 Battle_Creek 2290 0.722271 0.117467 \n", "15 15 Battle_Creek 2290 0.722271 0.117467 \n", "16 16 Capital_River 4911 0.697007 0.108735 \n", "17 17 Capital_River 4911 0.697007 0.108735 \n", "18 18 Capital_River 4911 0.697007 0.108735 \n", "19 19 Capital_River 4911 0.697007 0.108735 \n", "20 20 Capital_River 4911 0.697007 0.108735 \n", "21 21 Capital_River 4911 0.697007 0.108735 \n", "22 22 Capital_River 4911 0.697007 0.108735 \n", "23 23 Como 1328 0.640813 0.140813 \n", "24 24 Como 1328 0.640813 0.140813 \n", "25 25 Como 1328 0.640813 0.140813 \n", "26 26 Como 1328 0.640813 0.140813 \n", "27 27 Como 1328 0.640813 0.140813 \n", "28 28 Como 1328 0.640813 0.140813 \n", "29 29 Como 1328 0.640813 0.140813 \n", ".. ... ... ... ... ... \n", "171 171 Union_Park 3137 0.659229 0.141536 \n", "172 172 West_7th 3038 0.727452 0.095787 \n", "173 173 West_7th 3038 0.727452 0.095787 \n", "174 174 West_7th 3038 0.727452 0.095787 \n", "175 175 West_7th 3038 0.727452 0.095787 \n", "176 176 West_7th 3038 0.727452 0.095787 \n", "177 177 West_7th 3038 0.727452 0.095787 \n", "178 178 West_7th 3038 0.727452 0.095787 \n", "179 179 West_7th 3038 0.727452 0.095787 \n", "180 180 West_7th 3038 0.727452 0.095787 \n", "181 181 West_7th 3038 0.727452 0.095787 \n", "182 182 West_7th 3038 0.727452 0.095787 \n", "183 183 West_7th 3038 0.727452 0.095787 \n", "184 184 West_7th 3038 0.727452 0.095787 \n", "185 185 West_7th 3038 0.727452 0.095787 \n", "186 186 West_Side 1192 0.433725 0.279362 \n", "187 187 West_Side 1192 0.433725 0.279362 \n", "188 188 West_Side 1192 0.433725 0.279362 \n", "189 189 West_Side 1192 0.433725 0.279362 \n", "190 190 West_Side 1192 0.433725 0.279362 \n", "191 191 West_Side 1192 0.433725 0.279362 \n", "192 192 West_Side 1192 0.433725 0.279362 \n", "193 193 West_Side 1192 0.433725 0.279362 \n", "194 194 West_Side 1192 0.433725 0.279362 \n", "195 195 West_Side 1192 0.433725 0.279362 \n", "196 196 West_Side 1192 0.433725 0.279362 \n", "197 197 West_Side 1192 0.433725 0.279362 \n", "198 198 West_Side 1192 0.433725 0.279362 \n", "199 199 West_Side 1192 0.433725 0.279362 \n", "200 200 West_Side 1192 0.433725 0.279362 \n", "\n", " Moving Violation Driver_search Vehicle_search LateNight Asian \\\n", "0 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "1 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "2 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "3 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "4 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "5 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "6 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "7 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "8 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "9 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "10 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "11 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "12 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "13 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "14 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "15 0.882533 0.032751 0.030568 0.154148 0.143668 \n", "16 0.891265 0.029933 0.025657 0.145795 0.083690 \n", "17 0.891265 0.029933 0.025657 0.145795 0.083690 \n", "18 0.891265 0.029933 0.025657 0.145795 0.083690 \n", "19 0.891265 0.029933 0.025657 0.145795 0.083690 \n", "20 0.891265 0.029933 0.025657 0.145795 0.083690 \n", "21 0.891265 0.029933 0.025657 0.145795 0.083690 \n", "22 0.891265 0.029933 0.025657 0.145795 0.083690 \n", "23 0.859187 0.031627 0.026355 0.192018 0.100151 \n", "24 0.859187 0.031627 0.026355 0.192018 0.100151 \n", "25 0.859187 0.031627 0.026355 0.192018 0.100151 \n", "26 0.859187 0.031627 0.026355 0.192018 0.100151 \n", "27 0.859187 0.031627 0.026355 0.192018 0.100151 \n", "28 0.859187 0.031627 0.026355 0.192018 0.100151 \n", "29 0.859187 0.031627 0.026355 0.192018 0.100151 \n", ".. ... ... ... ... ... \n", "171 0.858464 0.031559 0.026777 0.184252 0.039528 \n", "172 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "173 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "174 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "175 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "176 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "177 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "178 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "179 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "180 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "181 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "182 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "183 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "184 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "185 0.904213 0.017117 0.011521 0.108624 0.035879 \n", "186 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "187 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "188 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "189 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "190 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "191 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "192 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "193 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "194 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "195 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "196 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "197 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "198 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "199 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "200 0.720638 0.083893 0.078020 0.353188 0.041946 \n", "\n", " ... Weekend Citation_count Equipment Violation_count \\\n", "0 ... 0.110480 1654 269.0 \n", "1 ... 0.110480 1654 269.0 \n", "2 ... 0.110480 1654 269.0 \n", "3 ... 0.110480 1654 269.0 \n", "4 ... 0.110480 1654 269.0 \n", "5 ... 0.110480 1654 269.0 \n", "6 ... 0.110480 1654 269.0 \n", "7 ... 0.110480 1654 269.0 \n", "8 ... 0.110480 1654 269.0 \n", "9 ... 0.110480 1654 269.0 \n", "10 ... 0.110480 1654 269.0 \n", "11 ... 0.110480 1654 269.0 \n", "12 ... 0.110480 1654 269.0 \n", "13 ... 0.110480 1654 269.0 \n", "14 ... 0.110480 1654 269.0 \n", "15 ... 0.110480 1654 269.0 \n", "16 ... 0.159845 3423 534.0 \n", "17 ... 0.159845 3423 534.0 \n", "18 ... 0.159845 3423 534.0 \n", "19 ... 0.159845 3423 534.0 \n", "20 ... 0.159845 3423 534.0 \n", "21 ... 0.159845 3423 534.0 \n", "22 ... 0.159845 3423 534.0 \n", "23 ... 0.146084 851 187.0 \n", "24 ... 0.146084 851 187.0 \n", "25 ... 0.146084 851 187.0 \n", "26 ... 0.146084 851 187.0 \n", "27 ... 0.146084 851 187.0 \n", "28 ... 0.146084 851 187.0 \n", "29 ... 0.146084 851 187.0 \n", ".. ... ... ... ... \n", "171 ... 0.174370 2068 444.0 \n", "172 ... 0.143186 2210 291.0 \n", "173 ... 0.143186 2210 291.0 \n", "174 ... 0.143186 2210 291.0 \n", "175 ... 0.143186 2210 291.0 \n", "176 ... 0.143186 2210 291.0 \n", "177 ... 0.143186 2210 291.0 \n", "178 ... 0.143186 2210 291.0 \n", "179 ... 0.143186 2210 291.0 \n", "180 ... 0.143186 2210 291.0 \n", "181 ... 0.143186 2210 291.0 \n", "182 ... 0.143186 2210 291.0 \n", "183 ... 0.143186 2210 291.0 \n", "184 ... 0.143186 2210 291.0 \n", "185 ... 0.143186 2210 291.0 \n", "186 ... 0.283557 517 333.0 \n", "187 ... 0.283557 517 333.0 \n", "188 ... 0.283557 517 333.0 \n", "189 ... 0.283557 517 333.0 \n", "190 ... 0.283557 517 333.0 \n", "191 ... 0.283557 517 333.0 \n", "192 ... 0.283557 517 333.0 \n", "193 ... 0.283557 517 333.0 \n", "194 ... 0.283557 517 333.0 \n", "195 ... 0.283557 517 333.0 \n", "196 ... 0.283557 517 333.0 \n", "197 ... 0.283557 517 333.0 \n", "198 ... 0.283557 517 333.0 \n", "199 ... 0.283557 517 333.0 \n", "200 ... 0.283557 517 333.0 \n", "\n", " Moving Violation_count LateNight_count White_Demo Black_Demo \\\n", "0 2021.0 353 0.398383 0.203079 \n", "1 2021.0 353 0.398383 0.203079 \n", "2 2021.0 353 0.398383 0.203079 \n", "3 2021.0 353 0.398383 0.203079 \n", "4 2021.0 353 0.398383 0.203079 \n", "5 2021.0 353 0.398383 0.203079 \n", "6 2021.0 353 0.398383 0.203079 \n", "7 2021.0 353 0.398383 0.203079 \n", "8 2021.0 353 0.398383 0.203079 \n", "9 2021.0 353 0.398383 0.203079 \n", "10 2021.0 353 0.398383 0.203079 \n", "11 2021.0 353 0.398383 0.203079 \n", "12 2021.0 353 0.398383 0.203079 \n", "13 2021.0 353 0.398383 0.203079 \n", "14 2021.0 353 0.398383 0.203079 \n", "15 2021.0 353 0.398383 0.203079 \n", "16 4377.0 716 0.675663 0.132114 \n", "17 4377.0 716 0.675663 0.132114 \n", "18 4377.0 716 0.675663 0.132114 \n", "19 4377.0 716 0.675663 0.132114 \n", "20 4377.0 716 0.675663 0.132114 \n", "21 4377.0 716 0.675663 0.132114 \n", "22 4377.0 716 0.675663 0.132114 \n", "23 1141.0 255 0.762898 0.089230 \n", "24 1141.0 255 0.762898 0.089230 \n", "25 1141.0 255 0.762898 0.089230 \n", "26 1141.0 255 0.762898 0.089230 \n", "27 1141.0 255 0.762898 0.089230 \n", "28 1141.0 255 0.762898 0.089230 \n", "29 1141.0 255 0.762898 0.089230 \n", ".. ... ... ... ... \n", "171 2693.0 578 0.772243 0.098012 \n", "172 2747.0 330 0.721428 0.108826 \n", "173 2747.0 330 0.721428 0.108826 \n", "174 2747.0 330 0.721428 0.108826 \n", "175 2747.0 330 0.721428 0.108826 \n", "176 2747.0 330 0.721428 0.108826 \n", "177 2747.0 330 0.721428 0.108826 \n", "178 2747.0 330 0.721428 0.108826 \n", "179 2747.0 330 0.721428 0.108826 \n", "180 2747.0 330 0.721428 0.108826 \n", "181 2747.0 330 0.721428 0.108826 \n", "182 2747.0 330 0.721428 0.108826 \n", "183 2747.0 330 0.721428 0.108826 \n", "184 2747.0 330 0.721428 0.108826 \n", "185 2747.0 330 0.721428 0.108826 \n", "186 859.0 421 0.453392 0.135823 \n", "187 859.0 421 0.453392 0.135823 \n", "188 859.0 421 0.453392 0.135823 \n", "189 859.0 421 0.453392 0.135823 \n", "190 859.0 421 0.453392 0.135823 \n", "191 859.0 421 0.453392 0.135823 \n", "192 859.0 421 0.453392 0.135823 \n", "193 859.0 421 0.453392 0.135823 \n", "194 859.0 421 0.453392 0.135823 \n", "195 859.0 421 0.453392 0.135823 \n", "196 859.0 421 0.453392 0.135823 \n", "197 859.0 421 0.453392 0.135823 \n", "198 859.0 421 0.453392 0.135823 \n", "199 859.0 421 0.453392 0.135823 \n", "200 859.0 421 0.453392 0.135823 \n", "\n", " Asian_Demo Grid Blah \n", "0 0.231585 98 268 \n", "1 0.231585 99 599 \n", "2 0.231585 100 32 \n", "3 0.231585 118 144 \n", "4 0.231585 119 682 \n", "5 0.231585 120 152 \n", "6 0.231585 137 39 \n", "7 0.231585 138 87 \n", "8 0.231585 139 65 \n", "9 0.231585 140 42 \n", "10 0.231585 160 70 \n", "11 0.231585 180 48 \n", "12 0.231585 197 1 \n", "13 0.231585 200 3 \n", "14 0.231585 240 15 \n", "15 0.231585 280 43 \n", "16 0.089509 111 148 \n", "17 0.089509 112 1007 \n", "18 0.089509 131 452 \n", "19 0.089509 132 230 \n", "20 0.089509 133 2307 \n", "21 0.089509 152 302 \n", "22 0.089509 153 465 \n", "23 0.054048 5 33 \n", "24 0.054048 6 29 \n", "25 0.054048 7 13 \n", "26 0.054048 8 54 \n", "27 0.054048 25 100 \n", "28 0.054048 26 29 \n", "29 0.054048 27 61 \n", ".. ... ... ... \n", "171 0.037718 126 189 \n", "172 0.029926 150 274 \n", "173 0.029926 151 42 \n", "174 0.029926 169 463 \n", "175 0.029926 170 266 \n", "176 0.029926 171 73 \n", "177 0.029926 187 59 \n", "178 0.029926 188 215 \n", "179 0.029926 189 9 \n", "180 0.029926 207 433 \n", "181 0.029926 226 46 \n", "182 0.029926 230 216 \n", "183 0.029926 249 80 \n", "184 0.029926 267 393 \n", "185 0.029926 268 469 \n", "186 0.064984 172 61 \n", "187 0.064984 173 193 \n", "188 0.064984 174 245 \n", "189 0.064984 175 1 \n", "190 0.064984 192 97 \n", "191 0.064984 193 154 \n", "192 0.064984 194 202 \n", "193 0.064984 195 35 \n", "194 0.064984 209 6 \n", "195 0.064984 210 5 \n", "196 0.064984 211 22 \n", "197 0.064984 212 34 \n", "198 0.064984 213 42 \n", "199 0.064984 214 77 \n", "200 0.064984 215 18 \n", "\n", "[201 rows x 25 columns]" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#All of SaintPaul Neighborhood\n", "\n", "# The graph is determined by Grid so we will group along that\n", "Features= ['Community','Count','Citation','Equipment Violation','Moving Violation','Driver_search','Vehicle_search','LateNight',\\\n", " 'Asian','Black','Latino','White','Other','Gender','Weekend']\n", "\n", "# Create a sum and divide by Count; and \n", "N= df[Features].groupby(['Community']).sum()\n", "\n", "#Save Sum Values\n", "C= N[['Count','Citation','Equipment Violation','Moving Violation','LateNight']]\n", "\n", "#Divide by Count and then add new columns in tranformed table\n", "N=N.div(N['Count'].values,axis=0)\n", "N['Count']=C.iloc[:,0] \n", "N['Citation_count'] = C.iloc[:,1]\n", "N['Equipment Violation_count'] = C.iloc[:,2]\n", "N['Moving Violation_count'] = C.iloc[:,3]\n", "N['LateNight_count'] = C.iloc[:,4]\n", "\n", "# Add the demographic info!\n", "N['White_Demo']= SPDem.iloc[:,0].values #.values was used\n", "N['Black_Demo']= SPDem.iloc[:,1].values \n", "N['Asian_Demo']= SPDem.iloc[:,2].values \n", "N=N.reset_index()\n", "\n", "#Merging two dataframes; where you create a distinct dataframe of just grid and community, then merge to neighbrhood file\n", "A= df.groupby(['Grid','Community']).size().reset_index(name='Blah')\n", "#A= df[['Grid','Community',]].groupby('Community').reset_index()\n", "C=A\n", "N=pd.merge(N, C, on='Community')\n", "\n", "# The GRID needs to follow exactly like the json file\n", "N=N.reset_index()\n", "N.Grid = N.Grid.astype(int)\n", "N.Grid = N.Grid.astype(str)\n", "N" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Frogtown Geo-Spatial Data " ] }, { "cell_type": "markdown", "metadata": { "hide_input": true }, "source": [ "### Total Traffic Incidents in Frogtown by Grid" ] }, { "cell_type": "code", "execution_count": 37, "metadata": { "hide_input": false, "scrolled": false }, "outputs": [ { "ename": "NameError", "evalue": "name 'Frogtown_venues' is not defined", "output_type": "error", "traceback": [ "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[1;31mNameError\u001b[0m Traceback (most recent call last)", "\u001b[1;32m\n", " | Count | \n", "Citation_count | \n", "Citation | \n", "Equipment Violation_count | \n", "Equipment Violation | \n", "Moving Violation_count | \n", "Moving Violation | \n", "
---|---|---|---|---|---|---|---|
Community | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Battle_Creek | \n", "2290 | \n", "1654 | \n", "0.7223% | \n", "269.0000% | \n", "0.1175% | \n", "2021.0000% | \n", "0.8825% | \n", "
Capital_River | \n", "4911 | \n", "3423 | \n", "0.6970% | \n", "534.0000% | \n", "0.1087% | \n", "4377.0000% | \n", "0.8913% | \n", "
Como | \n", "1328 | \n", "851 | \n", "0.6408% | \n", "187.0000% | \n", "0.1408% | \n", "1141.0000% | \n", "0.8592% | \n", "
Dayton_Bluff | \n", "2568 | \n", "934 | \n", "0.3637% | \n", "753.0000% | \n", "0.2932% | \n", "1815.0000% | \n", "0.7068% | \n", "
Greater_East_Side | \n", "3968 | \n", "2073 | \n", "0.5224% | \n", "810.0000% | \n", "0.2041% | \n", "3158.0000% | \n", "0.7959% | \n", "
Highland_Park | \n", "3372 | \n", "2960 | \n", "0.8778% | \n", "76.0000% | \n", "0.0225% | \n", "3296.0000% | \n", "0.9775% | \n", "
Macalester_Groveland | \n", "1851 | \n", "1437 | \n", "0.7763% | \n", "130.0000% | \n", "0.0702% | \n", "1721.0000% | \n", "0.9298% | \n", "
Midway | \n", "2476 | \n", "1288 | \n", "0.5202% | \n", "491.0000% | \n", "0.1983% | \n", "1985.0000% | \n", "0.8017% | \n", "
North_End | \n", "8561 | \n", "4883 | \n", "0.5704% | \n", "1854.0000% | \n", "0.2166% | \n", "6707.0000% | \n", "0.7834% | \n", "
Payne_Phalen | \n", "12136 | \n", "4185 | \n", "0.3448% | \n", "3573.0000% | \n", "0.2944% | \n", "8563.0000% | \n", "0.7056% | \n", "
St_Anthony | \n", "347 | \n", "223 | \n", "0.6427% | \n", "94.0000% | \n", "0.2709% | \n", "253.0000% | \n", "0.7291% | \n", "
Summit_Hill | \n", "851 | \n", "585 | \n", "0.6874% | \n", "74.0000% | \n", "0.0870% | \n", "777.0000% | \n", "0.9130% | \n", "
Summit_University | \n", "2477 | \n", "1133 | \n", "0.4574% | \n", "573.0000% | \n", "0.2313% | \n", "1904.0000% | \n", "0.7687% | \n", "
Thomas_Frogtown | \n", "5458 | \n", "2219 | \n", "0.4066% | \n", "1654.0000% | \n", "0.3030% | \n", "3804.0000% | \n", "0.6970% | \n", "
Union_Park | \n", "3137 | \n", "2068 | \n", "0.6592% | \n", "444.0000% | \n", "0.1415% | \n", "2693.0000% | \n", "0.8585% | \n", "
West_7th | \n", "3038 | \n", "2210 | \n", "0.7275% | \n", "291.0000% | \n", "0.0958% | \n", "2747.0000% | \n", "0.9042% | \n", "
West_Side | \n", "1192 | \n", "517 | \n", "0.4337% | \n", "333.0000% | \n", "0.2794% | \n", "859.0000% | \n", "0.7206% | \n", "
\n", " | Driver_search | \n", "Vehicle_search | \n", "Citation_count | \n", "LateNight | \n", "Gender | \n", "Weekend | \n", "
---|---|---|---|---|---|---|
Community | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Battle_Creek | \n", "0.03% | \n", "0.03% | \n", "1654 | \n", "0.15% | \n", "0.42% | \n", "0.11% | \n", "
Capital_River | \n", "0.03% | \n", "0.03% | \n", "3423 | \n", "0.15% | \n", "0.41% | \n", "0.16% | \n", "
Como | \n", "0.03% | \n", "0.03% | \n", "851 | \n", "0.19% | \n", "0.43% | \n", "0.15% | \n", "
Dayton_Bluff | \n", "0.09% | \n", "0.09% | \n", "934 | \n", "0.35% | \n", "0.33% | \n", "0.23% | \n", "
Greater_East_Side | \n", "0.07% | \n", "0.06% | \n", "2073 | \n", "0.27% | \n", "0.38% | \n", "0.17% | \n", "
Highland_Park | \n", "0.00% | \n", "0.00% | \n", "2960 | \n", "0.02% | \n", "0.44% | \n", "0.03% | \n", "
Macalester_Groveland | \n", "0.01% | \n", "0.01% | \n", "1437 | \n", "0.09% | \n", "0.42% | \n", "0.09% | \n", "
Midway | \n", "0.06% | \n", "0.05% | \n", "1288 | \n", "0.25% | \n", "0.40% | \n", "0.18% | \n", "
North_End | \n", "0.06% | \n", "0.05% | \n", "4883 | \n", "0.24% | \n", "0.37% | \n", "0.18% | \n", "
Payne_Phalen | \n", "0.11% | \n", "0.10% | \n", "4185 | \n", "0.38% | \n", "0.31% | \n", "0.24% | \n", "
St_Anthony | \n", "0.03% | \n", "0.02% | \n", "223 | \n", "0.39% | \n", "0.28% | \n", "0.39% | \n", "
Summit_Hill | \n", "0.03% | \n", "0.03% | \n", "585 | \n", "0.13% | \n", "0.42% | \n", "0.14% | \n", "
Summit_University | \n", "0.08% | \n", "0.07% | \n", "1133 | \n", "0.32% | \n", "0.35% | \n", "0.25% | \n", "
Thomas_Frogtown | \n", "0.10% | \n", "0.09% | \n", "2219 | \n", "0.40% | \n", "0.34% | \n", "0.22% | \n", "
Union_Park | \n", "0.03% | \n", "0.03% | \n", "2068 | \n", "0.18% | \n", "0.38% | \n", "0.17% | \n", "
West_7th | \n", "0.02% | \n", "0.01% | \n", "2210 | \n", "0.11% | \n", "0.39% | \n", "0.14% | \n", "
West_Side | \n", "0.08% | \n", "0.08% | \n", "517 | \n", "0.35% | \n", "0.32% | \n", "0.28% | \n", "
\n", " | Asian | \n", "Asian_Demo | \n", "Black | \n", "Black_Demo | \n", "White | \n", "White_Demo | \n", "
---|---|---|---|---|---|---|
Community | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Battle_Creek | \n", "0.143668 | \n", "0.231585 | \n", "0.292140 | \n", "0.203079 | \n", "0.430131 | \n", "0.398383 | \n", "
Capital_River | \n", "0.083690 | \n", "0.089509 | \n", "0.302993 | \n", "0.132114 | \n", "0.515985 | \n", "0.675663 | \n", "
Como | \n", "0.100151 | \n", "0.054048 | \n", "0.306476 | \n", "0.089230 | \n", "0.491717 | \n", "0.762898 | \n", "
Dayton_Bluff | \n", "0.146417 | \n", "0.323817 | \n", "0.419393 | \n", "0.140553 | \n", "0.306075 | \n", "0.348776 | \n", "
Greater_East_Side | \n", "0.184476 | \n", "0.297678 | \n", "0.336946 | \n", "0.155262 | \n", "0.336694 | \n", "0.358690 | \n", "
Highland_Park | \n", "0.029359 | \n", "0.071076 | \n", "0.147687 | \n", "0.140959 | \n", "0.726572 | \n", "0.652471 | \n", "
Macalester_Groveland | \n", "0.026472 | \n", "0.037623 | \n", "0.127499 | \n", "0.126550 | \n", "0.740681 | \n", "0.768102 | \n", "
Midway | \n", "0.050889 | \n", "0.039393 | \n", "0.341276 | \n", "0.020893 | \n", "0.498384 | \n", "0.871761 | \n", "
North_End | \n", "0.160963 | \n", "0.355203 | \n", "0.397851 | \n", "0.231465 | \n", "0.338512 | \n", "0.259136 | \n", "
Payne_Phalen | \n", "0.211519 | \n", "0.358401 | \n", "0.400132 | \n", "0.128624 | \n", "0.276038 | \n", "0.307874 | \n", "
St_Anthony | \n", "0.083573 | \n", "0.112020 | \n", "0.221902 | \n", "0.094220 | \n", "0.550432 | \n", "0.711481 | \n", "
Summit_Hill | \n", "0.039953 | \n", "0.027451 | \n", "0.132785 | \n", "0.050839 | \n", "0.740306 | \n", "0.839548 | \n", "
Summit_University | \n", "0.061365 | \n", "0.082662 | \n", "0.480420 | \n", "0.324349 | \n", "0.346790 | \n", "0.491559 | \n", "
Thomas_Frogtown | \n", "0.125870 | \n", "0.327318 | \n", "0.492305 | \n", "0.329769 | \n", "0.272261 | \n", "0.223661 | \n", "
Union_Park | \n", "0.039528 | \n", "0.037718 | \n", "0.259165 | \n", "0.098012 | \n", "0.599936 | \n", "0.772243 | \n", "
West_7th | \n", "0.035879 | \n", "0.029926 | \n", "0.180053 | \n", "0.108826 | \n", "0.689928 | \n", "0.721428 | \n", "
West_Side | \n", "0.041946 | \n", "0.064984 | \n", "0.281040 | \n", "0.135823 | \n", "0.453020 | \n", "0.453392 | \n", "