{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# HW 4" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "from sklearn.model_selection import train_test_split \n", "from sklearn.model_selection import cross_val_score\n", "from sklearn.linear_model import LogisticRegression\n", "from sklearn.model_selection import GridSearchCV \n", "from sklearn.pipeline import Pipeline\n", "from sklearn.pipeline import make_pipeline\n", "from sklearn.feature_extraction.text import CountVectorizer\n", "from sklearn.feature_extraction.text import TfidfVectorizer\n", "from sklearn.linear_model import LogisticRegression\n", "from sklearn.decomposition import NMF\n", "from sklearn.cluster import KMeans\n", "import nltk\n", "import os" ] }, { "cell_type": "code", "execution_count": 241, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import matplotlib.pyplot as plt\n", "plt.rcParams[\"figure.dpi\"] = 100\n", "pd.set_option('precision', 3)\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 397, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "8544" ] }, "execution_count": 397, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = pd.read_csv(\"Vision_Zero_Entry(2).csv\",\n", " parse_dates=['REQUESTDATE'],\n", " dtype={'REQUESTTYPE': 'str', 'COMMENTS': 'str'})\n", "len(df)" ] }, { "cell_type": "code", "execution_count": 398, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "6656" ] }, "execution_count": 398, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = df.dropna(subset=['COMMENTS'])\n", "len(df)" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "of something that is not listed here 1424\n", "bike facilities don't exist or need improvement 782\n", "people speed 745\n", "people run red lights / stop signs 663\n", "people don't yield while turning 461\n", "people double park their vehicles 430\n", "it’s hard to see / low visibility 390\n", "sidewalks/ramps don't exist or need improvement 301\n", "people don't yield while going straight 264\n", "people cross away from the crosswalks 255\n", "the roadway surface needs improvement 221\n", "the wait for the \"Walk\" signal is too long 206\n", "there are no bike facilities or they need maintenance 128\n", "there's not enough time to cross the street 121\n", "it's too far / too many lanes to cross 84\n", "there are no sidewalks or they need maintenance 40\n", "the roadway surface needs maintenance 34\n", "people have to wait too long for the \"Walk\" signal 30\n", "it’s hard for people to see each other 28\n", "people have to cross too many lanes / too far 27\n", "people are not given enough time to cross the street 9\n", "\" src=\"images/02 - Wait is too long.png\"> the wait for the \"Walk\" signal is too long 3\n", "\" src=\"images/14 - Other issue.png\"> of something that is not listed here 3\n", "\" src=\"images/11 - Sidewalk issue.png\"> sidewalks/ramps don't exist or need improvement 2\n", "\" src=\"images/10 - Hard to see.png\"> it’s hard to see / low visibility 2\n", "\" src=\"images/01 - Not enough time to cross.png\"> there's not enough time to cross the street 1\n", "\" src=\"images/06 - Speeding.png\"> people speed 1\n", "\" src=\"images/12 - Bike facility issue.png\"> the roadway surface needs improvement 1\n", "Name: REQUESTTYPE, dtype: int64" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.REQUESTTYPE.value_counts()" ] }, { "cell_type": "code", "execution_count": 399, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "of something that is not listed here 1427\n", "bike facilities don't exist or need improvement 782\n", "people speed 746\n", "people run red lights / stop signs 663\n", "people don't yield while turning 461\n", "people double park their vehicles 430\n", "it’s hard to see / low visibility 392\n", "sidewalks/ramps don't exist or need improvement 303\n", "people don't yield while going straight 264\n", "people cross away from the crosswalks 255\n", "the roadway surface needs improvement 222\n", "the wait for the \"Walk\" signal is too long 209\n", "there are no bike facilities or they need maintenance 128\n", "there's not enough time to cross the street 122\n", "it's too far / too many lanes to cross 84\n", "there are no sidewalks or they need maintenance 40\n", "the roadway surface needs maintenance 34\n", "people have to wait too long for the \"Walk\" signal 30\n", "it’s hard for people to see each other 28\n", "people have to cross too many lanes / too far 27\n", "people are not given enough time to cross the street 9\n", "Name: REQUESTTYPE, dtype: int64" ] }, "execution_count": 399, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df['REQUESTTYPE'] = df.REQUESTTYPE.str.replace(\".* \",\"\")\n", "df.REQUESTTYPE.value_counts()" ] }, { "cell_type": "code", "execution_count": 401, "metadata": { "collapsed": false }, "outputs": [], "source": [ "df.REQUESTTYPE.replace(\"there are no bike facilities or they need maintenance\",\n", " \"bike facilities don't exist or need improvement\", inplace=True)\n", "df.REQUESTTYPE.replace('people have to wait too long for the \"Walk\" signal',\n", " 'the wait for the \"Walk\" signal is too long', inplace=True)\n", "df.REQUESTTYPE.replace(\"sidewalks/ramps don't exist or need improvement\",\n", " \"there are no sidewalks or they need maintenance\", inplace=True)\n", "df.REQUESTTYPE.replace(\"the roadway surface needs maintenance\",\n", " \"the roadway surface needs improvement\", inplace=True)\n", "df.REQUESTTYPE.replace(\"people have to cross too many lanes / too far\",\n", " \"it's too far / too many lanes to cross\", inplace=True)\n", "df.REQUESTTYPE.replace(\"people are not given enough time to cross the street\",\n", " \"there's not enough time to cross the street\", inplace=True)\n", "df.REQUESTTYPE.replace(\"it’s hard for people to see each other\",\n", " \"it’s hard to see / low visibility\", inplace=True)" ] }, { "cell_type": "code", "execution_count": 402, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "of something that is not listed here 1427\n", "bike facilities don't exist or need improvement 910\n", "people speed 746\n", "people run red lights / stop signs 663\n", "people don't yield while turning 461\n", "people double park their vehicles 430\n", "it’s hard to see / low visibility 420\n", "there are no sidewalks or they need maintenance 343\n", "people don't yield while going straight 264\n", "the roadway surface needs improvement 256\n", "people cross away from the crosswalks 255\n", "the wait for the \"Walk\" signal is too long 239\n", "there's not enough time to cross the street 131\n", "it's too far / too many lanes to cross 111\n", "Name: REQUESTTYPE, dtype: int64" ] }, "execution_count": 402, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.REQUESTTYPE.value_counts()" ] }, { "cell_type": "code", "execution_count": 403, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "14" ] }, "execution_count": 403, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(df.REQUESTTYPE.value_counts())" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# drop all but relevant columns\n", "df = df[['REQUESTTYPE', 'COMMENTS']]\n", "# Drop simple duplicates\n", "df = df.drop_duplicates()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "202 G\n", "7947 test\n", "1156 Test\n", "5920 Test\n", "407 Test\n", "2342 i agree\n", "6558 Non stop\n", "6572 Constant\n", "1778 Too fast\n", "4248 CONSTANTLY.\n", "1124 Liquor store\n", "7125 No bike lane\n", "2531 no sidewalks\n", "1634 No sidewalks\n", "3616 Huge potholes\n", "1145 no bike racks\n", "2636 no bike lanes\n", "7575 Cars speeding\n", "1286 No bike lanes\n", "524 Poor lightung\n", "Name: COMMENTS, dtype: object" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Drop some noise from the comments\n", "df.COMMENTS.iloc[np.argsort(df.COMMENTS.str.len())].head(20)" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false }, "outputs": [], "source": [ "df = df[df.COMMENTS.str.len() >= 5]" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "9" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.COMMENTS.duplicated().sum()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "People used the same text with different labels!" ] }, { "cell_type": "code", "execution_count": 404, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | X | \n", "Y | \n", "OBJECTID | \n", "GLOBALID | \n", "REQUESTID | \n", "REQUESTTYPE | \n", "REQUESTDATE | \n", "STATUS | \n", "STREETSEGID | \n", "COMMENTS | \n", "USERTYPE | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
68 | \n", "-71.116 | \n", "42.319 | \n", "18828 | \n", "NaN | \n", "18828.0 | \n", "people don't yield while turning | \n", "2016-01-23 13:58:31 | \n", "Unassigned | \n", "0 | \n", "Drivers routinely make illegal lefts off JWay ... | \n", "drives | \n", "
89 | \n", "-71.061 | \n", "42.330 | \n", "18849 | \n", "NaN | \n", "18849.0 | \n", "there are no sidewalks or they need maintenance | \n", "2016-01-23 16:02:18 | \n", "Unassigned | \n", "0 | \n", "The sidewalks are neglected in the Winter, for... | \n", "walks | \n", "
173 | \n", "-71.074 | \n", "42.353 | \n", "18933 | \n", "NaN | \n", "18933.0 | \n", "of something that is not listed here | \n", "2016-01-23 23:09:34 | \n", "Unassigned | \n", "0 | \n", "no controlled crosswalk | \n", "walks | \n", "
202 | \n", "-71.063 | \n", "42.364 | \n", "18962 | \n", "NaN | \n", "NaN | \n", "it's too far / too many lanes to cross | \n", "2016-01-24 03:17:06 | \n", "Unassigned | \n", "0 | \n", "G | \n", "bikes | \n", "
207 | \n", "-71.142 | \n", "42.358 | \n", "19209 | \n", "NaN | \n", "19209.0 | \n", "it’s hard to see / low visibility | \n", "2016-01-23 06:11:05 | \n", "Unassigned | \n", "0 | \n", "cars parked on lincoln block sight of on comin... | \n", "drives | \n", "
208 | \n", "-71.141 | \n", "42.358 | \n", "19210 | \n", "NaN | \n", "19210.0 | \n", "it’s hard to see / low visibility | \n", "2016-01-23 06:11:27 | \n", "Unassigned | \n", "0 | \n", "cars parked on lincoln block sight of on comin... | \n", "drives | \n", "
233 | \n", "-71.061 | \n", "42.344 | \n", "17625 | \n", "NaN | \n", "17625.0 | \n", "of something that is not listed here | \n", "2016-01-22 15:25:38 | \n", "Unassigned | \n", "0 | \n", "Inadequate pedestrian/bicycle separation from ... | \n", "walks | \n", "
234 | \n", "-71.061 | \n", "42.343 | \n", "17626 | \n", "NaN | \n", "17626.0 | \n", "of something that is not listed here | \n", "2016-01-22 15:26:04 | \n", "Unassigned | \n", "0 | \n", "Inadequate pedestrian/bicycle separation from ... | \n", "walks | \n", "
331 | \n", "-71.103 | \n", "42.307 | \n", "17723 | \n", "NaN | \n", "17723.0 | \n", "there are no sidewalks or they need maintenance | \n", "2016-01-22 17:58:50 | \n", "Unassigned | \n", "0 | \n", "People park too close to the intersection and ... | \n", "drives | \n", "
333 | \n", "-71.103 | \n", "42.307 | \n", "17725 | \n", "NaN | \n", "17725.0 | \n", "it’s hard to see / low visibility | \n", "2016-01-22 17:59:30 | \n", "Unassigned | \n", "0 | \n", "People park too close to the intersection and ... | \n", "drives | \n", "
358 | \n", "-71.047 | \n", "42.311 | \n", "17750 | \n", "NaN | \n", "17750.0 | \n", "people run red lights / stop signs | \n", "2016-01-22 18:29:52 | \n", "Unassigned | \n", "0 | \n", "Drivers routinely run the stop signs at this i... | \n", "drives | \n", "
407 | \n", "-71.063 | \n", "42.361 | \n", "17799 | \n", "NaN | \n", "17799.0 | \n", "the wait for the \"Walk\" signal is too long | \n", "2016-01-22 19:24:42 | \n", "Unassigned | \n", "0 | \n", "Test | \n", "walks | \n", "
459 | \n", "-71.064 | \n", "42.352 | \n", "17851 | \n", "NaN | \n", "17851.0 | \n", "of something that is not listed here | \n", "2016-01-22 21:20:15 | \n", "Unassigned | \n", "0 | \n", "Too many drivers are using the bus lane. | \n", "bikes | \n", "
486 | \n", "-71.058 | \n", "42.355 | \n", "17878 | \n", "NaN | \n", "17878.0 | \n", "bike facilities don't exist or need improvement | \n", "2016-01-22 21:36:16 | \n", "Unassigned | \n", "0 | \n", "Need bike lane on Arch St | \n", "bikes | \n", "
488 | \n", "-71.058 | \n", "42.356 | \n", "17880 | \n", "NaN | \n", "17880.0 | \n", "bike facilities don't exist or need improvement | \n", "2016-01-22 21:36:34 | \n", "Unassigned | \n", "0 | \n", "Need bike lane on Arch St | \n", "bikes | \n", "
490 | \n", "-71.062 | \n", "42.354 | \n", "17882 | \n", "NaN | \n", "17882.0 | \n", "the wait for the \"Walk\" signal is too long | \n", "2016-01-22 21:38:36 | \n", "Unassigned | \n", "0 | \n", "Do we even need a traffic signal here? | \n", "walks | \n", "
505 | \n", "-71.104 | \n", "42.345 | \n", "17897 | \n", "NaN | \n", "17897.0 | \n", "bike facilities don't exist or need improvement | \n", "2016-01-22 21:48:16 | \n", "Unassigned | \n", "0 | \n", "Unclear whether the final result after constru... | \n", "bikes | \n", "
535 | \n", "-71.074 | \n", "42.353 | \n", "17927 | \n", "NaN | \n", "17927.0 | \n", "people don't yield while turning | \n", "2016-01-22 23:11:56 | \n", "Unassigned | \n", "0 | \n", "Left hook risk here, at least dash the bike la... | \n", "bikes | \n", "
536 | \n", "-71.078 | \n", "42.352 | \n", "17928 | \n", "NaN | \n", "17928.0 | \n", "people don't yield while turning | \n", "2016-01-22 23:12:26 | \n", "Unassigned | \n", "0 | \n", "Left hook risk here, at least dash the bike la... | \n", "bikes | \n", "
537 | \n", "-71.080 | \n", "42.351 | \n", "17929 | \n", "NaN | \n", "17929.0 | \n", "people don't yield while turning | \n", "2016-01-22 23:12:45 | \n", "Unassigned | \n", "0 | \n", "Left hook risk here, at least dash the bike la... | \n", "bikes | \n", "
546 | \n", "-71.031 | \n", "42.337 | \n", "17938 | \n", "NaN | \n", "17938.0 | \n", "there are no sidewalks or they need maintenance | \n", "2016-01-22 23:33:37 | \n", "Unassigned | \n", "0 | \n", "No ramp to get from 3rd st into the park | \n", "uses an assistive device | \n", "
660 | \n", "-71.036 | \n", "42.345 | \n", "18052 | \n", "NaN | \n", "18052.0 | \n", "people double park their vehicles | \n", "2016-01-23 03:43:09 | \n", "Unassigned | \n", "0 | \n", "people park in the bike lanes | \n", "bikes | \n", "
722 | \n", "-71.153 | \n", "42.287 | \n", "18454 | \n", "NaN | \n", "18454.0 | \n", "bike facilities don't exist or need improvement | \n", "2016-01-23 03:57:41 | \n", "Unassigned | \n", "0 | \n", "no bike facilities | \n", "bikes | \n", "
741 | \n", "-71.117 | \n", "42.320 | \n", "19617 | \n", "NaN | \n", "19617.0 | \n", "people don't yield while turning | \n", "2016-01-23 13:54:03 | \n", "Unassigned | \n", "0 | \n", "Drivers routinely make illegal lefts off JWay ... | \n", "drives | \n", "
742 | \n", "-71.116 | \n", "42.323 | \n", "19618 | \n", "NaN | \n", "19618.0 | \n", "people don't yield while turning | \n", "2016-01-23 13:54:24 | \n", "Unassigned | \n", "0 | \n", "Drivers routinely make illegal lefts off JWay ... | \n", "drives | \n", "
766 | \n", "-71.067 | \n", "42.331 | \n", "19642 | \n", "NaN | \n", "19642.0 | \n", "there are no sidewalks or they need maintenance | \n", "2016-01-23 16:00:41 | \n", "Unassigned | \n", "0 | \n", "The sidewalks are neglected in the Winter, for... | \n", "walks | \n", "
833 | \n", "-71.055 | \n", "42.312 | \n", "19709 | \n", "NaN | \n", "19709.0 | \n", "it’s hard to see / low visibility | \n", "2016-01-23 21:36:22 | \n", "Unassigned | \n", "0 | \n", "People have been assaulted walking to and from... | \n", "walks | \n", "
834 | \n", "-71.055 | \n", "42.311 | \n", "19710 | \n", "NaN | \n", "19710.0 | \n", "it’s hard to see / low visibility | \n", "2016-01-23 21:36:52 | \n", "Unassigned | \n", "0 | \n", "People have been assaulted walking to and from... | \n", "walks | \n", "
855 | \n", "-71.076 | \n", "42.352 | \n", "19731 | \n", "NaN | \n", "19731.0 | \n", "of something that is not listed here | \n", "2016-01-23 23:10:16 | \n", "Unassigned | \n", "0 | \n", "no controlled crosswalk | \n", "walks | \n", "
856 | \n", "-71.078 | \n", "42.352 | \n", "19732 | \n", "NaN | \n", "19732.0 | \n", "of something that is not listed here | \n", "2016-01-23 23:10:34 | \n", "Unassigned | \n", "0 | \n", "no controlled crosswalk | \n", "walks | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
7832 | \n", "-71.065 | \n", "42.346 | \n", "400896 | \n", "NaN | \n", "NaN | \n", "of something that is not listed here | \n", "2016-07-04 22:17:26 | \n", "Unassigned | \n", "0 | \n", "Roadway around Ink Block need work. The center... | \n", "drives | \n", "
7833 | \n", "-71.065 | \n", "42.346 | \n", "400897 | \n", "NaN | \n", "NaN | \n", "of something that is not listed here | \n", "2016-07-04 22:18:38 | \n", "Unassigned | \n", "0 | \n", "Roadway around Ink Block need work. The center... | \n", "drives | \n", "
7912 | \n", "-71.058 | \n", "42.325 | \n", "419697 | \n", "NaN | \n", "419697.0 | \n", "people speed | \n", "2016-07-14 15:20:58 | \n", "Unassigned | \n", "0 | \n", "This street is used as a cut through to Dorche... | \n", "walks | \n", "
7919 | \n", "-71.058 | \n", "42.326 | \n", "419297 | \n", "NaN | \n", "419297.0 | \n", "people speed | \n", "2016-07-14 15:20:39 | \n", "Unassigned | \n", "0 | \n", "This street is used as a cut through to Dorche... | \n", "walks | \n", "
7920 | \n", "-71.059 | \n", "42.326 | \n", "419298 | \n", "NaN | \n", "419298.0 | \n", "of something that is not listed here | \n", "2016-07-14 15:22:24 | \n", "Unassigned | \n", "0 | \n", "When traffic gets backed up, people drive on t... | \n", "drives | \n", "
8013 | \n", "-71.090 | \n", "42.353 | \n", "442905 | \n", "NaN | \n", "442905.0 | \n", "the roadway surface needs improvement | \n", "2016-08-11 22:45:44 | \n", "Unassigned | \n", "0 | \n", "bike lane is full of bumps. shameful | \n", "bikes | \n", "
8020 | \n", "-71.091 | \n", "42.354 | \n", "443303 | \n", "NaN | \n", "443303.0 | \n", "the roadway surface needs improvement | \n", "2016-08-11 22:45:07 | \n", "Unassigned | \n", "0 | \n", "bike lane is full of bumps. shameful | \n", "bikes | \n", "
8028 | \n", "-71.091 | \n", "42.354 | \n", "444100 | \n", "NaN | \n", "444100.0 | \n", "the roadway surface needs improvement | \n", "2016-08-11 22:45:20 | \n", "Unassigned | \n", "0 | \n", "bike lane is full of bumps. shameful | \n", "bikes | \n", "
8029 | \n", "-71.091 | \n", "42.353 | \n", "444101 | \n", "NaN | \n", "444101.0 | \n", "the roadway surface needs improvement | \n", "2016-08-11 22:45:32 | \n", "Unassigned | \n", "0 | \n", "bike lane is full of bumps. shameful | \n", "bikes | \n", "
8036 | \n", "-71.066 | \n", "42.328 | \n", "446897 | \n", "NaN | \n", "446897.0 | \n", "of something that is not listed here | \n", "2016-08-17 17:47:48 | \n", "Unassigned | \n", "0 | \n", "Large Trucks block street in early morning cau... | \n", "drives | \n", "
8039 | \n", "-71.068 | \n", "42.330 | \n", "447297 | \n", "NaN | \n", "447297.0 | \n", "of something that is not listed here | \n", "2016-08-17 17:48:10 | \n", "Unassigned | \n", "0 | \n", "Large Trucks block street in early morning cau... | \n", "drives | \n", "
8042 | \n", "-71.141 | \n", "42.354 | \n", "450897 | \n", "NaN | \n", "450897.0 | \n", "bike facilities don't exist or need improvement | \n", "2016-08-25 21:08:19 | \n", "Unassigned | \n", "0 | \n", "need shared bike lane sharrows | \n", "bikes | \n", "
8043 | \n", "-71.141 | \n", "42.354 | \n", "451297 | \n", "NaN | \n", "451297.0 | \n", "the roadway surface needs improvement | \n", "2016-08-25 21:08:44 | \n", "Unassigned | \n", "0 | \n", "need shared bike lane sharrows | \n", "bikes | \n", "
8055 | \n", "-71.104 | \n", "42.350 | \n", "452097 | \n", "NaN | \n", "452097.0 | \n", "people double park their vehicles | \n", "2016-08-26 13:31:19 | \n", "Unassigned | \n", "0 | \n", "Very frequently in the morning, delivery truck... | \n", "bikes | \n", "
8056 | \n", "-71.104 | \n", "42.350 | \n", "452497 | \n", "NaN | \n", "452497.0 | \n", "it’s hard to see / low visibility | \n", "2016-08-26 13:31:58 | \n", "Unassigned | \n", "0 | \n", "Very frequently in the morning, delivery truck... | \n", "bikes | \n", "
8240 | \n", "-71.034 | \n", "42.372 | \n", "495300 | \n", "NaN | \n", "495300.0 | \n", "people run red lights / stop signs | \n", "2016-11-11 17:39:52 | \n", "Unassigned | \n", "0 | \n", "This is a four way stop and drivers don't foll... | \n", "drives | \n", "
8241 | \n", "-71.035 | \n", "42.372 | \n", "495700 | \n", "NaN | \n", "495700.0 | \n", "people run red lights / stop signs | \n", "2016-11-11 17:42:16 | \n", "Unassigned | \n", "0 | \n", "This is a four way stop and drivers don't foll... | \n", "drives | \n", "
8252 | \n", "-71.084 | \n", "42.332 | \n", "499700 | \n", "NaN | \n", "499700.0 | \n", "people speed | \n", "2016-11-18 16:19:09 | \n", "Unassigned | \n", "0 | \n", "There needs to be stop signs on Ruggles Street... | \n", "walks | \n", "
8253 | \n", "-71.085 | \n", "42.333 | \n", "499701 | \n", "NaN | \n", "499701.0 | \n", "people speed | \n", "2016-11-18 16:19:53 | \n", "Unassigned | \n", "0 | \n", "There needs to be stop signs on Ruggles Street... | \n", "walks | \n", "
8254 | \n", "-71.087 | \n", "42.334 | \n", "500100 | \n", "NaN | \n", "500100.0 | \n", "people speed | \n", "2016-11-18 16:20:18 | \n", "Unassigned | \n", "0 | \n", "There needs to be stop signs on Ruggles Street... | \n", "walks | \n", "
8290 | \n", "-71.107 | \n", "42.310 | \n", "15210 | \n", "NaN | \n", "15210.0 | \n", "people don't yield while going straight | \n", "2016-01-19 21:29:07 | \n", "Unassigned | \n", "0 | \n", "They roll into the crosswalk and block bike's ... | \n", "bikes | \n", "
8291 | \n", "-71.107 | \n", "42.311 | \n", "15211 | \n", "NaN | \n", "15211.0 | \n", "people don't yield while turning | \n", "2016-01-19 21:29:40 | \n", "Unassigned | \n", "0 | \n", "They roll into the crosswalk and block bike's ... | \n", "bikes | \n", "
8443 | \n", "-71.071 | \n", "42.344 | \n", "541706 | \n", "NaN | \n", "541706.0 | \n", "people double park their vehicles | \n", "2017-01-26 20:34:57 | \n", "Unassigned | \n", "0 | \n", "Cars are always double parked for valet causin... | \n", "bikes | \n", "
8449 | \n", "-71.071 | \n", "42.344 | \n", "542105 | \n", "NaN | \n", "542105.0 | \n", "people double park their vehicles | \n", "2017-01-26 20:35:39 | \n", "Unassigned | \n", "0 | \n", "Cars are always double parked for valet causin... | \n", "drives | \n", "
8461 | \n", "-71.058 | \n", "42.379 | \n", "543704 | \n", "NaN | \n", "543704.0 | \n", "people speed | \n", "2017-01-27 17:38:17 | \n", "Unassigned | \n", "0 | \n", "Many youth and adults cross Medford street her... | \n", "walks | \n", "
8463 | \n", "-71.057 | \n", "42.379 | \n", "544503 | \n", "NaN | \n", "544503.0 | \n", "people run red lights / stop signs | \n", "2017-01-27 17:38:48 | \n", "Unassigned | \n", "0 | \n", "Many youth and adults cross Medford street her... | \n", "walks | \n", "
8534 | \n", "-71.118 | \n", "42.278 | \n", "565306 | \n", "NaN | \n", "565306.0 | \n", "people speed | \n", "2017-04-05 13:45:05 | \n", "Unassigned | \n", "0 | \n", "I work for the District 5 City Councilor Tim M... | \n", "drives | \n", "
8535 | \n", "-71.119 | \n", "42.273 | \n", "565307 | \n", "NaN | \n", "565307.0 | \n", "people speed | \n", "2017-04-05 13:46:30 | \n", "Unassigned | \n", "0 | \n", "I work for the District 5 City Councilor Tim M... | \n", "drives | \n", "
8541 | \n", "-71.058 | \n", "42.357 | \n", "566906 | \n", "NaN | \n", "566906.0 | \n", "people double park their vehicles | \n", "2017-04-13 19:03:32 | \n", "Unassigned | \n", "0 | \n", "Delivery trucks and personal vehicles routinel... | \n", "bikes | \n", "
8542 | \n", "-71.058 | \n", "42.357 | \n", "567306 | \n", "NaN | \n", "567306.0 | \n", "people double park their vehicles | \n", "2017-04-13 19:03:46 | \n", "Unassigned | \n", "0 | \n", "Delivery trucks and personal vehicles routinel... | \n", "bikes | \n", "
296 rows × 11 columns
\n", "\n", " | \n", " | \n", " | \n", " | mean_test_score | \n", "mean_train_score | \n", "
---|---|---|---|---|---|
param_vectorizer__ngram_range | \n", "param_vectorizer | \n", "param_clf__C | \n", "param_clf__class_weight | \n", "\n", " | \n", " |
(1, 1) | \n", "CountVectorizer | \n", "0.001 | \n", "balanced | \n", "0.429406 | \n", "0.486768 | \n", "
none | \n", "0.124760 | \n", "0.132103 | \n", "|||
0.010 | \n", "balanced | \n", "0.489085 | \n", "0.578765 | \n", "||
none | \n", "0.358444 | \n", "0.411709 | \n", "|||
0.100 | \n", "balanced | \n", "0.520639 | \n", "0.739080 | \n", "||
none | \n", "0.501734 | \n", "0.684631 | \n", "|||
1.000 | \n", "balanced | \n", "0.512687 | \n", "0.918059 | \n", "||
none | \n", "0.514109 | \n", "0.931443 | \n", "|||
10.000 | \n", "balanced | \n", "0.481120 | \n", "0.984709 | \n", "||
none | \n", "0.476602 | \n", "0.990629 | \n", "|||
100.000 | \n", "balanced | \n", "0.450545 | \n", "0.996723 | \n", "||
none | \n", "0.448602 | \n", "0.997742 | \n", "|||
TfidfVectorizer | \n", "0.001 | \n", "balanced | \n", "0.025485 | \n", "0.025485 | \n", "|
none | \n", "0.025485 | \n", "0.025485 | \n", "|||
0.010 | \n", "balanced | \n", "0.177189 | \n", "0.197536 | \n", "||
none | \n", "0.026888 | \n", "0.026367 | \n", "|||
0.100 | \n", "balanced | \n", "0.532815 | \n", "0.644764 | \n", "||
none | \n", "0.179273 | \n", "0.197170 | \n", "|||
1.000 | \n", "balanced | \n", "0.544482 | \n", "0.756279 | \n", "||
none | \n", "0.475108 | \n", "0.624822 | \n", "|||
10.000 | \n", "balanced | \n", "0.526346 | \n", "0.934471 | \n", "||
none | \n", "0.520041 | \n", "0.948110 | \n", "|||
100.000 | \n", "balanced | \n", "0.477779 | \n", "0.992010 | \n", "||
none | \n", "0.477510 | \n", "0.995620 | \n", "|||
(1, 2) | \n", "CountVectorizer | \n", "0.001 | \n", "balanced | \n", "0.453207 | \n", "0.540239 | \n", "
none | \n", "0.154903 | \n", "0.167615 | \n", "|||
0.010 | \n", "balanced | \n", "0.508632 | \n", "0.654926 | \n", "||
none | \n", "0.388943 | \n", "0.489996 | \n", "|||
0.100 | \n", "balanced | \n", "0.539067 | \n", "0.872904 | \n", "||
none | \n", "0.509893 | \n", "0.855108 | \n", "|||
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
(1, 3) | \n", "TfidfVectorizer | \n", "1.000 | \n", "balanced | \n", "0.549661 | \n", "0.857478 | \n", "
none | \n", "0.438132 | \n", "0.647163 | \n", "|||
10.000 | \n", "balanced | \n", "0.559326 | \n", "0.990348 | \n", "||
none | \n", "0.534820 | \n", "0.996061 | \n", "|||
100.000 | \n", "balanced | \n", "0.545074 | \n", "0.998513 | \n", "||
none | \n", "0.533824 | \n", "0.998455 | \n", "|||
(2, 3) | \n", "CountVectorizer | \n", "0.001 | \n", "balanced | \n", "0.277355 | \n", "0.405967 | \n", "
none | \n", "0.049379 | \n", "0.062972 | \n", "|||
0.010 | \n", "balanced | \n", "0.441342 | \n", "0.702427 | \n", "||
none | \n", "0.229474 | \n", "0.320212 | \n", "|||
0.100 | \n", "balanced | \n", "0.480547 | \n", "0.894375 | \n", "||
none | \n", "0.418379 | \n", "0.810769 | \n", "|||
1.000 | \n", "balanced | \n", "0.478714 | \n", "0.989943 | \n", "||
none | \n", "0.458329 | \n", "0.988296 | \n", "|||
10.000 | \n", "balanced | \n", "0.461504 | \n", "0.993757 | \n", "||
none | \n", "0.456434 | \n", "0.994898 | \n", "|||
100.000 | \n", "balanced | \n", "0.447192 | \n", "0.993842 | \n", "||
none | \n", "0.444983 | \n", "0.993992 | \n", "|||
TfidfVectorizer | \n", "0.001 | \n", "balanced | \n", "0.025485 | \n", "0.025485 | \n", "|
none | \n", "0.025485 | \n", "0.025485 | \n", "|||
0.010 | \n", "balanced | \n", "0.027110 | \n", "0.026895 | \n", "||
none | \n", "0.025485 | \n", "0.025485 | \n", "|||
0.100 | \n", "balanced | \n", "0.437116 | \n", "0.719578 | \n", "||
none | \n", "0.049663 | \n", "0.050781 | \n", "|||
1.000 | \n", "balanced | \n", "0.490522 | \n", "0.887576 | \n", "||
none | \n", "0.349982 | \n", "0.578188 | \n", "|||
10.000 | \n", "balanced | \n", "0.497387 | \n", "0.990589 | \n", "||
none | \n", "0.474348 | \n", "0.993008 | \n", "|||
100.000 | \n", "balanced | \n", "0.486861 | \n", "0.994087 | \n", "||
none | \n", "0.481871 | \n", "0.995006 | \n", "
96 rows × 2 columns
\n", "\n", " \n", " \n", " \n", " \n", " | \n", " param_clf__class_weight\n", " \n", " \n", " \n", " | \n", " balanced\n", " \n", " \n", " \n", " | \n", " none\n", " \n", " \n", " \n", " | \n", " balanced\n", " \n", " \n", " \n", " | \n", " none\n", " \n", " \n", " \n", " | \n", " balanced\n", " \n", " \n", " \n", " | \n", " none\n", " \n", " \n", " \n", " | \n", " balanced\n", " \n", " \n", " \n", " | \n", " none\n", " \n", " \n", " \n", " | \n", " balanced\n", " \n", " \n", " \n", " | \n", " none\n", " \n", " \n", " \n", " | \n", " balanced\n", " \n", " \n", " \n", " | \n", " none\n", " \n", " \n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
\n", " \n", " \n", " \n", " \n", " | \n", " param_clf__C\n", " \n", " \n", " \n", " | \n", " 0.001\n", " \n", " \n", " \n", " | \n", " 0.001\n", " \n", " \n", " \n", " | \n", " 0.01\n", " \n", " \n", " \n", " | \n", " 0.01\n", " \n", " \n", " \n", " | \n", " 0.1\n", " \n", " \n", " \n", " | \n", " 0.1\n", " \n", " \n", " \n", " | \n", " 1.0\n", " \n", " \n", " \n", " | \n", " 1.0\n", " \n", " \n", " \n", " | \n", " 10.0\n", " \n", " \n", " \n", " | \n", " 10.0\n", " \n", " \n", " \n", " | \n", " 100.0\n", " \n", " \n", " \n", " | \n", " 100.0\n", " \n", " \n", " |
\n", " param_vectorizer__ngram_range\n", " \n", " \n", " \n", " | \n", " param_vectorizer\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", " \n", " \n", " \n", " | \n", " \n", " \n", " \n", " \n", " | \n", " \n", " \n", " \n", " |
\n", " (1, 1)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.429406\n", " \n", " \n", " \n", " | \n", " 0.12476\n", " \n", " \n", " \n", " | \n", " 0.489085\n", " \n", " \n", " \n", " | \n", " 0.358444\n", " \n", " \n", " \n", " | \n", " 0.520639\n", " \n", " \n", " \n", " | \n", " 0.501734\n", " \n", " \n", " \n", " | \n", " 0.512687\n", " \n", " \n", " \n", " | \n", " 0.514109\n", " \n", " \n", " \n", " | \n", " 0.48112\n", " \n", " \n", " \n", " | \n", " 0.476602\n", " \n", " \n", " \n", " | \n", " 0.450545\n", " \n", " \n", " \n", " | \n", " 0.448602\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.177189\n", " \n", " \n", " \n", " | \n", " 0.0268879\n", " \n", " \n", " \n", " | \n", " 0.532815\n", " \n", " \n", " \n", " | \n", " 0.179273\n", " \n", " \n", " \n", " | \n", " 0.544482\n", " \n", " \n", " \n", " | \n", " 0.475108\n", " \n", " \n", " \n", " | \n", " 0.526346\n", " \n", " \n", " \n", " | \n", " 0.520041\n", " \n", " \n", " \n", " | \n", " 0.477779\n", " \n", " \n", " \n", " | \n", " 0.47751\n", " \n", " \n", " | |
\n", " (1, 2)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.453207\n", " \n", " \n", " \n", " | \n", " 0.154903\n", " \n", " \n", " \n", " | \n", " 0.508632\n", " \n", " \n", " \n", " | \n", " 0.388943\n", " \n", " \n", " \n", " | \n", " 0.539067\n", " \n", " \n", " \n", " | \n", " 0.509893\n", " \n", " \n", " \n", " | \n", " 0.538237\n", " \n", " \n", " \n", " | \n", " 0.520153\n", " \n", " \n", " \n", " | \n", " 0.52242\n", " \n", " \n", " \n", " | \n", " 0.515539\n", " \n", " \n", " \n", " | \n", " 0.512395\n", " \n", " \n", " \n", " | \n", " 0.509521\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.054548\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.535109\n", " \n", " \n", " \n", " | \n", " 0.112623\n", " \n", " \n", " \n", " | \n", " 0.558589\n", " \n", " \n", " \n", " | \n", " 0.44903\n", " \n", " \n", " \n", " | \n", " 0.560442\n", " \n", " \n", " \n", " | \n", " 0.530849\n", " \n", " \n", " \n", " | \n", " 0.538919\n", " \n", " \n", " \n", " | \n", " 0.525634\n", " \n", " \n", " | |
\n", " (1, 3)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.458052\n", " \n", " \n", " \n", " | \n", " 0.161282\n", " \n", " \n", " \n", " | \n", " 0.512318\n", " \n", " \n", " \n", " | \n", " 0.398438\n", " \n", " \n", " \n", " | \n", " 0.544697\n", " \n", " \n", " \n", " | \n", " 0.508844\n", " \n", " \n", " \n", " | \n", " 0.538995\n", " \n", " \n", " \n", " | \n", " 0.529246\n", " \n", " \n", " \n", " | \n", " 0.523072\n", " \n", " \n", " \n", " | \n", " 0.518763\n", " \n", " \n", " \n", " | \n", " 0.514133\n", " \n", " \n", " \n", " | \n", " 0.506196\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0343488\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.531304\n", " \n", " \n", " \n", " | \n", " 0.0887954\n", " \n", " \n", " \n", " | \n", " 0.549661\n", " \n", " \n", " \n", " | \n", " 0.438132\n", " \n", " \n", " \n", " | \n", " 0.559326\n", " \n", " \n", " \n", " | \n", " 0.53482\n", " \n", " \n", " \n", " | \n", " 0.545074\n", " \n", " \n", " \n", " | \n", " 0.533824\n", " \n", " \n", " | |
\n", " (2, 3)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.277355\n", " \n", " \n", " \n", " | \n", " 0.0493788\n", " \n", " \n", " \n", " | \n", " 0.441342\n", " \n", " \n", " \n", " | \n", " 0.229474\n", " \n", " \n", " \n", " | \n", " 0.480547\n", " \n", " \n", " \n", " | \n", " 0.418379\n", " \n", " \n", " \n", " | \n", " 0.478714\n", " \n", " \n", " \n", " | \n", " 0.458329\n", " \n", " \n", " \n", " | \n", " 0.461504\n", " \n", " \n", " \n", " | \n", " 0.456434\n", " \n", " \n", " \n", " | \n", " 0.447192\n", " \n", " \n", " \n", " | \n", " 0.444983\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0271105\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.437116\n", " \n", " \n", " \n", " | \n", " 0.0496631\n", " \n", " \n", " \n", " | \n", " 0.490522\n", " \n", " \n", " \n", " | \n", " 0.349982\n", " \n", " \n", " \n", " | \n", " 0.497387\n", " \n", " \n", " \n", " | \n", " 0.474348\n", " \n", " \n", " \n", " | \n", " 0.486861\n", " \n", " \n", " \n", " | \n", " 0.481871\n", " \n", " \n", " |
\n", " \n", " \n", " \n", " \n", " | \n", " param_clf__C\n", " \n", " \n", " \n", " | \n", " 0.001\n", " \n", " \n", " \n", " | \n", " 0.01\n", " \n", " \n", " \n", " | \n", " 0.1\n", " \n", " \n", " \n", " | \n", " 1.0\n", " \n", " \n", " \n", " | \n", " 10.0\n", " \n", " \n", " \n", " | \n", " 100.0\n", " \n", " \n", " |
---|---|---|---|---|---|---|---|
\n", " param_vectorizer__ngram_range\n", " \n", " \n", " \n", " | \n", " param_vectorizer\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", " (1, 1)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.429406\n", " \n", " \n", " \n", " | \n", " 0.489085\n", " \n", " \n", " \n", " | \n", " 0.520639\n", " \n", " \n", " \n", " | \n", " 0.512687\n", " \n", " \n", " \n", " | \n", " 0.48112\n", " \n", " \n", " \n", " | \n", " 0.450545\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.177189\n", " \n", " \n", " \n", " | \n", " 0.532815\n", " \n", " \n", " \n", " | \n", " 0.544482\n", " \n", " \n", " \n", " | \n", " 0.526346\n", " \n", " \n", " \n", " | \n", " 0.477779\n", " \n", " \n", " | |
\n", " (1, 2)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.453207\n", " \n", " \n", " \n", " | \n", " 0.508632\n", " \n", " \n", " \n", " | \n", " 0.539067\n", " \n", " \n", " \n", " | \n", " 0.538237\n", " \n", " \n", " \n", " | \n", " 0.52242\n", " \n", " \n", " \n", " | \n", " 0.512395\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.054548\n", " \n", " \n", " \n", " | \n", " 0.535109\n", " \n", " \n", " \n", " | \n", " 0.558589\n", " \n", " \n", " \n", " | \n", " 0.560442\n", " \n", " \n", " \n", " | \n", " 0.538919\n", " \n", " \n", " | |
\n", " (1, 3)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.458052\n", " \n", " \n", " \n", " | \n", " 0.512318\n", " \n", " \n", " \n", " | \n", " 0.544697\n", " \n", " \n", " \n", " | \n", " 0.538995\n", " \n", " \n", " \n", " | \n", " 0.523072\n", " \n", " \n", " \n", " | \n", " 0.514133\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0343488\n", " \n", " \n", " \n", " | \n", " 0.531304\n", " \n", " \n", " \n", " | \n", " 0.549661\n", " \n", " \n", " \n", " | \n", " 0.559326\n", " \n", " \n", " \n", " | \n", " 0.545074\n", " \n", " \n", " | |
\n", " (2, 3)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.277355\n", " \n", " \n", " \n", " | \n", " 0.441342\n", " \n", " \n", " \n", " | \n", " 0.480547\n", " \n", " \n", " \n", " | \n", " 0.478714\n", " \n", " \n", " \n", " | \n", " 0.461504\n", " \n", " \n", " \n", " | \n", " 0.447192\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0254851\n", " \n", " \n", " \n", " | \n", " 0.0271105\n", " \n", " \n", " \n", " | \n", " 0.437116\n", " \n", " \n", " \n", " | \n", " 0.490522\n", " \n", " \n", " \n", " | \n", " 0.497387\n", " \n", " \n", " \n", " | \n", " 0.486861\n", " \n", " \n", " |
\n", " \n", " \n", " \n", " \n", " | \n", " param_clf__C\n", " \n", " \n", " \n", " | \n", " 0.001\n", " \n", " \n", " \n", " | \n", " 0.01\n", " \n", " \n", " \n", " | \n", " 0.1\n", " \n", " \n", " \n", " | \n", " 1.0\n", " \n", " \n", " \n", " | \n", " 10.0\n", " \n", " \n", " \n", " | \n", " 100.0\n", " \n", " \n", " |
---|---|---|---|---|---|---|---|
\n", " param_vectorizer__ngram_range\n", " \n", " \n", " \n", " | \n", " param_vectorizer\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", " (1, 1)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.429\n", " \n", " \n", " \n", " | \n", " 0.489\n", " \n", " \n", " \n", " | \n", " 0.521\n", " \n", " \n", " \n", " | \n", " 0.513\n", " \n", " \n", " \n", " | \n", " 0.481\n", " \n", " \n", " \n", " | \n", " 0.451\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0255\n", " \n", " \n", " \n", " | \n", " 0.177\n", " \n", " \n", " \n", " | \n", " 0.533\n", " \n", " \n", " \n", " | \n", " 0.544\n", " \n", " \n", " \n", " | \n", " 0.526\n", " \n", " \n", " \n", " | \n", " 0.478\n", " \n", " \n", " | |
\n", " (1, 2)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.453\n", " \n", " \n", " \n", " | \n", " 0.509\n", " \n", " \n", " \n", " | \n", " 0.539\n", " \n", " \n", " \n", " | \n", " 0.538\n", " \n", " \n", " \n", " | \n", " 0.522\n", " \n", " \n", " \n", " | \n", " 0.512\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0255\n", " \n", " \n", " \n", " | \n", " 0.0545\n", " \n", " \n", " \n", " | \n", " 0.535\n", " \n", " \n", " \n", " | \n", " 0.559\n", " \n", " \n", " \n", " | \n", " 0.56\n", " \n", " \n", " \n", " | \n", " 0.539\n", " \n", " \n", " | |
\n", " (1, 3)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.458\n", " \n", " \n", " \n", " | \n", " 0.512\n", " \n", " \n", " \n", " | \n", " 0.545\n", " \n", " \n", " \n", " | \n", " 0.539\n", " \n", " \n", " \n", " | \n", " 0.523\n", " \n", " \n", " \n", " | \n", " 0.514\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0255\n", " \n", " \n", " \n", " | \n", " 0.0343\n", " \n", " \n", " \n", " | \n", " 0.531\n", " \n", " \n", " \n", " | \n", " 0.55\n", " \n", " \n", " \n", " | \n", " 0.559\n", " \n", " \n", " \n", " | \n", " 0.545\n", " \n", " \n", " | |
\n", " (2, 3)\n", " \n", " \n", " \n", " | \n", " CountVectorizer\n", " \n", " \n", " \n", " | \n", " 0.277\n", " \n", " \n", " \n", " | \n", " 0.441\n", " \n", " \n", " \n", " | \n", " 0.481\n", " \n", " \n", " \n", " | \n", " 0.479\n", " \n", " \n", " \n", " | \n", " 0.462\n", " \n", " \n", " \n", " | \n", " 0.447\n", " \n", " \n", " |
\n", " TfidfVectorizer\n", " \n", " \n", " \n", " | \n", " 0.0255\n", " \n", " \n", " \n", " | \n", " 0.0271\n", " \n", " \n", " \n", " | \n", " 0.437\n", " \n", " \n", " \n", " | \n", " 0.491\n", " \n", " \n", " \n", " | \n", " 0.497\n", " \n", " \n", " \n", " | \n", " 0.487\n", " \n", " \n", " |
\n", " | drive way street fast | \n", "run red light | \n", "stopwords streets people | \n", "predestrian cross-walk | \n", "cars turning | \n", "people speed | \n", "stop sign park? | \n", "bike lane | \n", "cross-walk danger | \n", "street sidewalk people | \n", "parking, double parking | \n", "lanes, turning | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
REQUESTTYPE | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
bike facilities don't exist or need improvement | \n", "0.064 | \n", "0.061 | \n", "0.075 | \n", "0.102 | \n", "0.095 | \n", "0.065 | \n", "0.080 | \n", "0.125 | \n", "0.078 | \n", "0.083 | \n", "0.109 | \n", "0.063 | \n", "
it's too far / too many lanes to cross | \n", "0.086 | \n", "0.075 | \n", "0.081 | \n", "0.103 | \n", "0.166 | \n", "0.075 | \n", "0.058 | \n", "0.084 | \n", "0.045 | \n", "0.104 | \n", "0.071 | \n", "0.053 | \n", "
it’s hard to see / low visibility | \n", "0.071 | \n", "0.071 | \n", "0.076 | \n", "0.110 | \n", "0.097 | \n", "0.065 | \n", "0.080 | \n", "0.134 | \n", "0.083 | \n", "0.061 | \n", "0.091 | \n", "0.060 | \n", "
of something that is not listed here | \n", "0.071 | \n", "0.073 | \n", "0.062 | \n", "0.121 | \n", "0.103 | \n", "0.061 | \n", "0.076 | \n", "0.123 | \n", "0.082 | \n", "0.086 | \n", "0.085 | \n", "0.057 | \n", "
people cross away from the crosswalks | \n", "0.069 | \n", "0.057 | \n", "0.079 | \n", "0.070 | \n", "0.113 | \n", "0.064 | \n", "0.086 | \n", "0.129 | \n", "0.104 | \n", "0.093 | \n", "0.089 | \n", "0.047 | \n", "
people don't yield while going straight | \n", "0.058 | \n", "0.082 | \n", "0.047 | \n", "0.087 | \n", "0.113 | \n", "0.060 | \n", "0.072 | \n", "0.157 | \n", "0.075 | \n", "0.101 | \n", "0.083 | \n", "0.064 | \n", "
people don't yield while turning | \n", "0.055 | \n", "0.070 | \n", "0.067 | \n", "0.129 | \n", "0.114 | \n", "0.063 | \n", "0.083 | \n", "0.092 | \n", "0.095 | \n", "0.070 | \n", "0.088 | \n", "0.074 | \n", "
people double park their vehicles | \n", "0.070 | \n", "0.084 | \n", "0.066 | \n", "0.118 | \n", "0.118 | \n", "0.050 | \n", "0.084 | \n", "0.105 | \n", "0.091 | \n", "0.082 | \n", "0.073 | \n", "0.059 | \n", "
people run red lights / stop signs | \n", "0.067 | \n", "0.079 | \n", "0.051 | \n", "0.106 | \n", "0.122 | \n", "0.064 | \n", "0.078 | \n", "0.134 | \n", "0.077 | \n", "0.079 | \n", "0.090 | \n", "0.052 | \n", "
people speed | \n", "0.066 | \n", "0.067 | \n", "0.064 | \n", "0.118 | \n", "0.104 | \n", "0.058 | \n", "0.088 | \n", "0.123 | \n", "0.092 | \n", "0.092 | \n", "0.082 | \n", "0.046 | \n", "
the roadway surface needs improvement | \n", "0.075 | \n", "0.046 | \n", "0.061 | \n", "0.093 | \n", "0.119 | \n", "0.071 | \n", "0.073 | \n", "0.152 | \n", "0.085 | \n", "0.092 | \n", "0.082 | \n", "0.051 | \n", "
the wait for the \"Walk\" signal is too long | \n", "0.078 | \n", "0.072 | \n", "0.064 | \n", "0.141 | \n", "0.117 | \n", "0.065 | \n", "0.061 | \n", "0.124 | \n", "0.073 | \n", "0.058 | \n", "0.090 | \n", "0.056 | \n", "
there are no sidewalks or they need maintenance | \n", "0.053 | \n", "0.048 | \n", "0.066 | \n", "0.113 | \n", "0.129 | \n", "0.053 | \n", "0.076 | \n", "0.125 | \n", "0.084 | \n", "0.093 | \n", "0.080 | \n", "0.078 | \n", "
there's not enough time to cross the street | \n", "0.067 | \n", "0.085 | \n", "0.060 | \n", "0.071 | \n", "0.152 | \n", "0.077 | \n", "0.076 | \n", "0.117 | \n", "0.096 | \n", "0.072 | \n", "0.078 | \n", "0.049 | \n", "
\n", " \n", " \n", " \n", " \n", " | \n", " drive way street fast\n", " \n", " \n", " \n", " | \n", " run red light\n", " \n", " \n", " \n", " | \n", " stopwords streets people\n", " \n", " \n", " \n", " | \n", " predestrian cross-walk\n", " \n", " \n", " \n", " | \n", " cars turning\n", " \n", " \n", " \n", " | \n", " people speed\n", " \n", " \n", " \n", " | \n", " stop sign park?\n", " \n", " \n", " \n", " | \n", " bike lane\n", " \n", " \n", " \n", " | \n", " cross-walk danger\n", " \n", " \n", " \n", " | \n", " street sidewalk people\n", " \n", " \n", " \n", " | \n", " parking, double parking\n", " \n", " \n", " \n", " | \n", " lanes, turning\n", " \n", " \n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|
\n", " REQUESTTYPE\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", " \n", " \n", " \n", " | \n", " \n", " \n", " \n", " \n", " | \n", " \n", " \n", " \n", " |
\n", " bike facilities don't exist or need improvement\n", " \n", " \n", " \n", " | \n", " 0.064\n", " \n", " \n", " \n", " | \n", " 0.061\n", " \n", " \n", " \n", " | \n", " 0.0747\n", " \n", " \n", " \n", " | \n", " 0.102\n", " \n", " \n", " \n", " | \n", " 0.0947\n", " \n", " \n", " \n", " | \n", " 0.0652\n", " \n", " \n", " \n", " | \n", " 0.0799\n", " \n", " \n", " \n", " | \n", " 0.125\n", " \n", " \n", " \n", " | \n", " 0.0784\n", " \n", " \n", " \n", " | \n", " 0.0826\n", " \n", " \n", " \n", " | \n", " 0.109\n", " \n", " \n", " \n", " | \n", " 0.063\n", " \n", " \n", " |
\n", " it's too far / too many lanes to cross\n", " \n", " \n", " \n", " | \n", " 0.086\n", " \n", " \n", " \n", " | \n", " 0.0749\n", " \n", " \n", " \n", " | \n", " 0.081\n", " \n", " \n", " \n", " | \n", " 0.103\n", " \n", " \n", " \n", " | \n", " 0.166\n", " \n", " \n", " \n", " | \n", " 0.075\n", " \n", " \n", " \n", " | \n", " 0.0579\n", " \n", " \n", " \n", " | \n", " 0.0842\n", " \n", " \n", " \n", " | \n", " 0.0448\n", " \n", " \n", " \n", " | \n", " 0.104\n", " \n", " \n", " \n", " | \n", " 0.071\n", " \n", " \n", " \n", " | \n", " 0.0527\n", " \n", " \n", " |
\n", " it’s hard to see / low visibility\n", " \n", " \n", " \n", " | \n", " 0.0705\n", " \n", " \n", " \n", " | \n", " 0.0707\n", " \n", " \n", " \n", " | \n", " 0.0762\n", " \n", " \n", " \n", " | \n", " 0.11\n", " \n", " \n", " \n", " | \n", " 0.0969\n", " \n", " \n", " \n", " | \n", " 0.0653\n", " \n", " \n", " \n", " | \n", " 0.0798\n", " \n", " \n", " \n", " | \n", " 0.134\n", " \n", " \n", " \n", " | \n", " 0.0829\n", " \n", " \n", " \n", " | \n", " 0.0614\n", " \n", " \n", " \n", " | \n", " 0.0914\n", " \n", " \n", " \n", " | \n", " 0.0602\n", " \n", " \n", " |
\n", " of something that is not listed here\n", " \n", " \n", " \n", " | \n", " 0.0712\n", " \n", " \n", " \n", " | \n", " 0.0729\n", " \n", " \n", " \n", " | \n", " 0.0617\n", " \n", " \n", " \n", " | \n", " 0.121\n", " \n", " \n", " \n", " | \n", " 0.103\n", " \n", " \n", " \n", " | \n", " 0.0611\n", " \n", " \n", " \n", " | \n", " 0.0756\n", " \n", " \n", " \n", " | \n", " 0.123\n", " \n", " \n", " \n", " | \n", " 0.0825\n", " \n", " \n", " \n", " | \n", " 0.0863\n", " \n", " \n", " \n", " | \n", " 0.0846\n", " \n", " \n", " \n", " | \n", " 0.0569\n", " \n", " \n", " |
\n", " people cross away from the crosswalks\n", " \n", " \n", " \n", " | \n", " 0.0685\n", " \n", " \n", " \n", " | \n", " 0.0571\n", " \n", " \n", " \n", " | \n", " 0.0787\n", " \n", " \n", " \n", " | \n", " 0.0695\n", " \n", " \n", " \n", " | \n", " 0.113\n", " \n", " \n", " \n", " | \n", " 0.0638\n", " \n", " \n", " \n", " | \n", " 0.0864\n", " \n", " \n", " \n", " | \n", " 0.129\n", " \n", " \n", " \n", " | \n", " 0.104\n", " \n", " \n", " \n", " | \n", " 0.0932\n", " \n", " \n", " \n", " | \n", " 0.0887\n", " \n", " \n", " \n", " | \n", " 0.0472\n", " \n", " \n", " |
\n", " people don't yield while going straight\n", " \n", " \n", " \n", " | \n", " 0.0577\n", " \n", " \n", " \n", " | \n", " 0.0816\n", " \n", " \n", " \n", " | \n", " 0.0466\n", " \n", " \n", " \n", " | \n", " 0.0873\n", " \n", " \n", " \n", " | \n", " 0.113\n", " \n", " \n", " \n", " | \n", " 0.0603\n", " \n", " \n", " \n", " | \n", " 0.0722\n", " \n", " \n", " \n", " | \n", " 0.157\n", " \n", " \n", " \n", " | \n", " 0.0753\n", " \n", " \n", " \n", " | \n", " 0.101\n", " \n", " \n", " \n", " | \n", " 0.0832\n", " \n", " \n", " \n", " | \n", " 0.0643\n", " \n", " \n", " |
\n", " people don't yield while turning\n", " \n", " \n", " \n", " | \n", " 0.0547\n", " \n", " \n", " \n", " | \n", " 0.0696\n", " \n", " \n", " \n", " | \n", " 0.067\n", " \n", " \n", " \n", " | \n", " 0.129\n", " \n", " \n", " \n", " | \n", " 0.114\n", " \n", " \n", " \n", " | \n", " 0.0631\n", " \n", " \n", " \n", " | \n", " 0.0827\n", " \n", " \n", " \n", " | \n", " 0.0922\n", " \n", " \n", " \n", " | \n", " 0.0953\n", " \n", " \n", " \n", " | \n", " 0.0702\n", " \n", " \n", " \n", " | \n", " 0.0884\n", " \n", " \n", " \n", " | \n", " 0.074\n", " \n", " \n", " |
\n", " people double park their vehicles\n", " \n", " \n", " \n", " | \n", " 0.0696\n", " \n", " \n", " \n", " | \n", " 0.0837\n", " \n", " \n", " \n", " | \n", " 0.0664\n", " \n", " \n", " \n", " | \n", " 0.118\n", " \n", " \n", " \n", " | \n", " 0.118\n", " \n", " \n", " \n", " | \n", " 0.0504\n", " \n", " \n", " \n", " | \n", " 0.0839\n", " \n", " \n", " \n", " | \n", " 0.105\n", " \n", " \n", " \n", " | \n", " 0.0915\n", " \n", " \n", " \n", " | \n", " 0.0824\n", " \n", " \n", " \n", " | \n", " 0.0727\n", " \n", " \n", " \n", " | \n", " 0.0592\n", " \n", " \n", " |
\n", " people run red lights / stop signs\n", " \n", " \n", " \n", " | \n", " 0.067\n", " \n", " \n", " \n", " | \n", " 0.0787\n", " \n", " \n", " \n", " | \n", " 0.0511\n", " \n", " \n", " \n", " | \n", " 0.106\n", " \n", " \n", " \n", " | \n", " 0.122\n", " \n", " \n", " \n", " | \n", " 0.0641\n", " \n", " \n", " \n", " | \n", " 0.0781\n", " \n", " \n", " \n", " | \n", " 0.134\n", " \n", " \n", " \n", " | \n", " 0.0772\n", " \n", " \n", " \n", " | \n", " 0.079\n", " \n", " \n", " \n", " | \n", " 0.0902\n", " \n", " \n", " \n", " | \n", " 0.0522\n", " \n", " \n", " |
\n", " people speed\n", " \n", " \n", " \n", " | \n", " 0.0661\n", " \n", " \n", " \n", " | \n", " 0.0666\n", " \n", " \n", " \n", " | \n", " 0.0636\n", " \n", " \n", " \n", " | \n", " 0.118\n", " \n", " \n", " \n", " | \n", " 0.104\n", " \n", " \n", " \n", " | \n", " 0.0581\n", " \n", " \n", " \n", " | \n", " 0.0882\n", " \n", " \n", " \n", " | \n", " 0.123\n", " \n", " \n", " \n", " | \n", " 0.092\n", " \n", " \n", " \n", " | \n", " 0.0924\n", " \n", " \n", " \n", " | \n", " 0.0822\n", " \n", " \n", " \n", " | \n", " 0.0462\n", " \n", " \n", " |
\n", " the roadway surface needs improvement\n", " \n", " \n", " \n", " | \n", " 0.0747\n", " \n", " \n", " \n", " | \n", " 0.0457\n", " \n", " \n", " \n", " | \n", " 0.0612\n", " \n", " \n", " \n", " | \n", " 0.0931\n", " \n", " \n", " \n", " | \n", " 0.119\n", " \n", " \n", " \n", " | \n", " 0.0712\n", " \n", " \n", " \n", " | \n", " 0.073\n", " \n", " \n", " \n", " | \n", " 0.152\n", " \n", " \n", " \n", " | \n", " 0.0845\n", " \n", " \n", " \n", " | \n", " 0.0923\n", " \n", " \n", " \n", " | \n", " 0.0816\n", " \n", " \n", " \n", " | \n", " 0.0511\n", " \n", " \n", " |
\n", " the wait for the \"Walk\" signal is too long\n", " \n", " \n", " \n", " | \n", " 0.0775\n", " \n", " \n", " \n", " | \n", " 0.0724\n", " \n", " \n", " \n", " | \n", " 0.0644\n", " \n", " \n", " \n", " | \n", " 0.141\n", " \n", " \n", " \n", " | \n", " 0.117\n", " \n", " \n", " \n", " | \n", " 0.0651\n", " \n", " \n", " \n", " | \n", " 0.0612\n", " \n", " \n", " \n", " | \n", " 0.124\n", " \n", " \n", " \n", " | \n", " 0.0734\n", " \n", " \n", " \n", " | \n", " 0.058\n", " \n", " \n", " \n", " | \n", " 0.0896\n", " \n", " \n", " \n", " | \n", " 0.0561\n", " \n", " \n", " |
\n", " there are no sidewalks or they need maintenance\n", " \n", " \n", " \n", " | \n", " 0.053\n", " \n", " \n", " \n", " | \n", " 0.0484\n", " \n", " \n", " \n", " | \n", " 0.0658\n", " \n", " \n", " \n", " | \n", " 0.113\n", " \n", " \n", " \n", " | \n", " 0.129\n", " \n", " \n", " \n", " | \n", " 0.0534\n", " \n", " \n", " \n", " | \n", " 0.0762\n", " \n", " \n", " \n", " | \n", " 0.125\n", " \n", " \n", " \n", " | \n", " 0.0844\n", " \n", " \n", " \n", " | \n", " 0.0928\n", " \n", " \n", " \n", " | \n", " 0.0804\n", " \n", " \n", " \n", " | \n", " 0.0779\n", " \n", " \n", " |
\n", " there's not enough time to cross the street\n", " \n", " \n", " \n", " | \n", " 0.0669\n", " \n", " \n", " \n", " | \n", " 0.0851\n", " \n", " \n", " \n", " | \n", " 0.0604\n", " \n", " \n", " \n", " | \n", " 0.0707\n", " \n", " \n", " \n", " | \n", " 0.152\n", " \n", " \n", " \n", " | \n", " 0.0774\n", " \n", " \n", " \n", " | \n", " 0.0764\n", " \n", " \n", " \n", " | \n", " 0.117\n", " \n", " \n", " \n", " | \n", " 0.0959\n", " \n", " \n", " \n", " | \n", " 0.0717\n", " \n", " \n", " \n", " | \n", " 0.0784\n", " \n", " \n", " \n", " | \n", " 0.0488\n", " \n", " \n", " |
\n", " \n", " \n", " \n", " \n", " | \n", " drive way street fast\n", " \n", " \n", " \n", " | \n", " run red light\n", " \n", " \n", " \n", " | \n", " stopwords streets people\n", " \n", " \n", " \n", " | \n", " predestrian cross-walk\n", " \n", " \n", " \n", " | \n", " cars turning\n", " \n", " \n", " \n", " | \n", " people speed\n", " \n", " \n", " \n", " | \n", " stop sign park?\n", " \n", " \n", " \n", " | \n", " bike lane\n", " \n", " \n", " \n", " | \n", " cross-walk danger\n", " \n", " \n", " \n", " | \n", " street sidewalk people\n", " \n", " \n", " \n", " | \n", " parking, double parking\n", " \n", " \n", " \n", " | \n", " lanes, turning\n", " \n", " \n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|
\n", " bike facilities don't exist or need improvement\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 13\n", " \n", " \n", " \n", " | \n", " 24\n", " \n", " \n", " \n", " | \n", " 12\n", " \n", " \n", " \n", " | \n", " 33\n", " \n", " \n", " \n", " | \n", " 37\n", " \n", " \n", " \n", " | \n", " 20\n", " \n", " \n", " \n", " | \n", " 379\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " \n", " | \n", " 31\n", " \n", " \n", " \n", " | \n", " 23\n", " \n", " \n", " \n", " | \n", " 25\n", " \n", " \n", " |
\n", " it's too far / too many lanes to cross\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 0\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 16\n", " \n", " \n", " \n", " | \n", " 11\n", " \n", " \n", " \n", " | \n", " 4\n", " \n", " \n", " \n", " | \n", " 2\n", " \n", " \n", " \n", " | \n", " 13\n", " \n", " \n", " \n", " | \n", " 11\n", " \n", " \n", " \n", " | \n", " 3\n", " \n", " \n", " \n", " | \n", " 3\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " |
\n", " it’s hard to see / low visibility\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 16\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 106\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 33\n", " \n", " \n", " \n", " | \n", " 13\n", " \n", " \n", " \n", " | \n", " 31\n", " \n", " \n", " \n", " | \n", " 20\n", " \n", " \n", " \n", " | \n", " 51\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " |
\n", " of something that is not listed here\n", " \n", " \n", " \n", " | \n", " 100\n", " \n", " \n", " \n", " | \n", " 53\n", " \n", " \n", " \n", " | \n", " 83\n", " \n", " \n", " \n", " | \n", " 121\n", " \n", " \n", " \n", " | \n", " 141\n", " \n", " \n", " \n", " | \n", " 38\n", " \n", " \n", " \n", " | \n", " 90\n", " \n", " \n", " \n", " | \n", " 95\n", " \n", " \n", " \n", " | \n", " 65\n", " \n", " \n", " \n", " | \n", " 68\n", " \n", " \n", " \n", " | \n", " 103\n", " \n", " \n", " \n", " | \n", " 95\n", " \n", " \n", " |
\n", " people cross away from the crosswalks\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 44\n", " \n", " \n", " \n", " | \n", " 61\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 3\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " \n", " | \n", " 2\n", " \n", " \n", " \n", " | \n", " 31\n", " \n", " \n", " \n", " | \n", " 14\n", " \n", " \n", " \n", " | \n", " 12\n", " \n", " \n", " \n", " | \n", " 0\n", " \n", " \n", " |
\n", " people don't yield while going straight\n", " \n", " \n", " \n", " | \n", " 4\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 33\n", " \n", " \n", " \n", " | \n", " 23\n", " \n", " \n", " \n", " | \n", " 4\n", " \n", " \n", " \n", " | \n", " 11\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " \n", " | \n", " 75\n", " \n", " \n", " \n", " | \n", " 4\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 10\n", " \n", " \n", " |
\n", " people don't yield while turning\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " \n", " | \n", " 10\n", " \n", " \n", " \n", " | \n", " 12\n", " \n", " \n", " \n", " | \n", " 65\n", " \n", " \n", " \n", " | \n", " 134\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 18\n", " \n", " \n", " \n", " | \n", " 40\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 20\n", " \n", " \n", " |
\n", " people double park their vehicles\n", " \n", " \n", " \n", " | \n", " 6\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 2\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 24\n", " \n", " \n", " \n", " | \n", " 39\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 8\n", " \n", " \n", " \n", " | \n", " 200\n", " \n", " \n", " \n", " | \n", " 10\n", " \n", " \n", " |
\n", " people run red lights / stop signs\n", " \n", " \n", " \n", " | \n", " 40\n", " \n", " \n", " \n", " | \n", " 152\n", " \n", " \n", " \n", " | \n", " 18\n", " \n", " \n", " \n", " | \n", " 41\n", " \n", " \n", " \n", " | \n", " 68\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 89\n", " \n", " \n", " \n", " | \n", " 12\n", " \n", " \n", " \n", " | \n", " 42\n", " \n", " \n", " \n", " | \n", " 4\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " \n", " | \n", " 12\n", " \n", " \n", " |
\n", " people speed\n", " \n", " \n", " \n", " | \n", " 93\n", " \n", " \n", " \n", " | \n", " 22\n", " \n", " \n", " \n", " | \n", " 18\n", " \n", " \n", " \n", " | \n", " 16\n", " \n", " \n", " \n", " | \n", " 41\n", " \n", " \n", " \n", " | \n", " 107\n", " \n", " \n", " \n", " | \n", " 22\n", " \n", " \n", " \n", " | \n", " 42\n", " \n", " \n", " \n", " | \n", " 55\n", " \n", " \n", " \n", " | \n", " 94\n", " \n", " \n", " \n", " | \n", " 25\n", " \n", " \n", " \n", " | \n", " 21\n", " \n", " \n", " |
\n", " the roadway surface needs improvement\n", " \n", " \n", " \n", " | \n", " 4\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 12\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 10\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 3\n", " \n", " \n", " \n", " | \n", " 49\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 62\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " \n", " | \n", " 20\n", " \n", " \n", " |
\n", " the wait for the \"Walk\" signal is too long\n", " \n", " \n", " \n", " | \n", " 2\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 137\n", " \n", " \n", " \n", " | \n", " 6\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 2\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 5\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 0\n", " \n", " \n", " |
\n", " there are no sidewalks or they need maintenance\n", " \n", " \n", " \n", " | \n", " 2\n", " \n", " \n", " \n", " | \n", " 6\n", " \n", " \n", " \n", " | \n", " 15\n", " \n", " \n", " \n", " | \n", " 27\n", " \n", " \n", " \n", " | \n", " 6\n", " \n", " \n", " \n", " | \n", " 22\n", " \n", " \n", " \n", " | \n", " 32\n", " \n", " \n", " \n", " | \n", " 17\n", " \n", " \n", " \n", " | \n", " 21\n", " \n", " \n", " \n", " | \n", " 71\n", " \n", " \n", " \n", " | \n", " 26\n", " \n", " \n", " \n", " | \n", " 9\n", " \n", " \n", " |
\n", " there's not enough time to cross the street\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 16\n", " \n", " \n", " \n", " | \n", " 54\n", " \n", " \n", " \n", " | \n", " 7\n", " \n", " \n", " \n", " | \n", " 3\n", " \n", " \n", " \n", " | \n", " 0\n", " \n", " \n", " \n", " | \n", " 1\n", " \n", " \n", " \n", " | \n", " 10\n", " \n", " \n", " \n", " | \n", " 3\n", " \n", " \n", " \n", " | \n", " 0\n", " \n", " \n", " \n", " | \n", " 2\n", " \n", " \n", " |
\n", " | 0 | \n", "1 | \n", "
---|---|---|
bike facilities don't exist or need improvement | \n", "604 | \n", "9 | \n", "
it's too far / too many lanes to cross | \n", "68 | \n", "11 | \n", "
it’s hard to see / low visibility | \n", "278 | \n", "31 | \n", "
of something that is not listed here | \n", "987 | \n", "65 | \n", "
people cross away from the crosswalks | \n", "160 | \n", "31 | \n", "
people don't yield while going straight | \n", "117 | \n", "75 | \n", "
people don't yield while turning | \n", "299 | \n", "40 | \n", "
people double park their vehicles | \n", "310 | \n", "7 | \n", "
people run red lights / stop signs | \n", "446 | \n", "42 | \n", "
people speed | \n", "501 | \n", "55 | \n", "
the roadway surface needs improvement | \n", "180 | \n", "7 | \n", "
the wait for the \"Walk\" signal is too long | \n", "169 | \n", "1 | \n", "
there are no sidewalks or they need maintenance | \n", "233 | \n", "21 | \n", "
there's not enough time to cross the street | \n", "88 | \n", "10 | \n", "
\n", " | REQUESTTYPE | \n", "COMMENTS | \n", "
---|---|---|
35 | \n", "it's too far / too many lanes to cross | \n", "An old woman tried to cross a parking lane, 2 ... | \n", "
1039 | \n", "of something that is not listed here | \n", "There should be a stopsign so drivers stop for... | \n", "
1115 | \n", "of something that is not listed here | \n", "This intersection is a clusterfark for drivers... | \n", "
1216 | \n", "people don't yield while turning | \n", "People are always turning left and coming stra... | \n", "
1619 | \n", "it’s hard to see / low visibility | \n", "The driveway for Mission Park is signalized, b... | \n", "
3547 | \n", "of something that is not listed here | \n", "The MBTA trolleys consistently run the red lig... | \n", "
4804 | \n", "of something that is not listed here | \n", "Tour buses/trolleys frequently pull out into t... | \n", "
5516 | \n", "of something that is not listed here | \n", "There are drivers who do not yield to stopped ... | \n", "
7152 | \n", "people cross away from the crosswalks | \n", "People jaywalk across Comm Ave after exiting t... | \n", "