NJSP SRIs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "140b5ae3",
   "metadata": {},
   "outputs": [],
   "source": [
    "from utz import *"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "27f1d4f5",
   "metadata": {},
   "source": [
    "## NJSP SRIs/MPs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c98b29b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CCODE</th>\n",
       "      <th>CNAME</th>\n",
       "      <th>MCODE</th>\n",
       "      <th>MNAME</th>\n",
       "      <th>HIGHWAY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>FATALITIES</th>\n",
       "      <th>INJURIES</th>\n",
       "      <th>STREET</th>\n",
       "      <th>FATAL_D</th>\n",
       "      <th>FATAL_P</th>\n",
       "      <th>FATAL_T</th>\n",
       "      <th>FATAL_B</th>\n",
       "      <th>dt</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACCID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1703</th>\n",
       "      <td>01</td>\n",
       "      <td>Atlantic</td>\n",
       "      <td>0102</td>\n",
       "      <td>Atlantic City</td>\n",
       "      <td>446</td>\n",
       "      <td>State/Interstate Authority 446 S MP 1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-01-01 00:35:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1681</th>\n",
       "      <td>09</td>\n",
       "      <td>Hudson</td>\n",
       "      <td>0910</td>\n",
       "      <td>Union City</td>\n",
       "      <td>None</td>\n",
       "      <td>Bergenline Ave S MP 0 at 6th St</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bergenline Ave</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-01-01 04:11:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>04</td>\n",
       "      <td>Camden</td>\n",
       "      <td>0415</td>\n",
       "      <td>Gloucester Twsp</td>\n",
       "      <td>42</td>\n",
       "      <td>State Highway 42 N MP 8.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-01-01 06:46:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>20</td>\n",
       "      <td>Union</td>\n",
       "      <td>2004</td>\n",
       "      <td>Elizabeth City</td>\n",
       "      <td>624</td>\n",
       "      <td>County 624 W MP 2.2 at Ikea Dr</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-01-01 12:29:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1811</th>\n",
       "      <td>07</td>\n",
       "      <td>Essex</td>\n",
       "      <td>0716</td>\n",
       "      <td>Nutley Town</td>\n",
       "      <td>648</td>\n",
       "      <td>County 648 E MP .87 at Franklin Ave</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-01-01 18:53:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12421</th>\n",
       "      <td>02</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>0246</td>\n",
       "      <td>Paramus Boro</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023-04-15 02:58:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12418</th>\n",
       "      <td>04</td>\n",
       "      <td>Camden</td>\n",
       "      <td>0421</td>\n",
       "      <td>Lawnside Boro</td>\n",
       "      <td>295</td>\n",
       "      <td>Interstate 295 MP 30.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023-04-17 14:07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12420</th>\n",
       "      <td>12</td>\n",
       "      <td>Middlesex</td>\n",
       "      <td>1219</td>\n",
       "      <td>Sayreville Boro</td>\n",
       "      <td>9</td>\n",
       "      <td>State Highway 9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023-04-18 03:21:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12423</th>\n",
       "      <td>12</td>\n",
       "      <td>Middlesex</td>\n",
       "      <td>1219</td>\n",
       "      <td>Sayreville Boro</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023-04-19 20:08:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12424</th>\n",
       "      <td>03</td>\n",
       "      <td>Burlington</td>\n",
       "      <td>0329</td>\n",
       "      <td>Pemberton Boro</td>\n",
       "      <td>687</td>\n",
       "      <td>County 687 MP .25</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023-04-20 17:16:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8550 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      CCODE       CNAME MCODE            MNAME HIGHWAY   \n",
       "ACCID                                                    \n",
       "1703     01    Atlantic  0102    Atlantic City     446  \\\n",
       "1681     09      Hudson  0910       Union City    None   \n",
       "1659     04      Camden  0415  Gloucester Twsp      42   \n",
       "1661     20       Union  2004   Elizabeth City     624   \n",
       "1811     07       Essex  0716      Nutley Town     648   \n",
       "...     ...         ...   ...              ...     ...   \n",
       "12421    02      Bergen  0246     Paramus Boro    None   \n",
       "12418    04      Camden  0421    Lawnside Boro     295   \n",
       "12420    12   Middlesex  1219  Sayreville Boro       9   \n",
       "12423    12   Middlesex  1219  Sayreville Boro      35   \n",
       "12424    03  Burlington  0329   Pemberton Boro     687   \n",
       "\n",
       "                                    LOCATION  FATALITIES  INJURIES   \n",
       "ACCID                                                                \n",
       "1703   State/Interstate Authority 446 S MP 1         1.0       1.0  \\\n",
       "1681         Bergenline Ave S MP 0 at 6th St         1.0       NaN   \n",
       "1659               State Highway 42 N MP 8.2         1.0       1.0   \n",
       "1661          County 624 W MP 2.2 at Ikea Dr         1.0       1.0   \n",
       "1811     County 648 E MP .87 at Franklin Ave         1.0       NaN   \n",
       "...                                      ...         ...       ...   \n",
       "12421                                   None         1.0       0.0   \n",
       "12418                 Interstate 295 MP 30.5         1.0       NaN   \n",
       "12420                        State Highway 9         1.0       NaN   \n",
       "12423                                     35         1.0       NaN   \n",
       "12424                      County 687 MP .25         1.0       NaN   \n",
       "\n",
       "               STREET  FATAL_D  FATAL_P  FATAL_T  FATAL_B                  dt  \n",
       "ACCID                                                                          \n",
       "1703             None      NaN      NaN      NaN      NaN 2008-01-01 00:35:00  \n",
       "1681   Bergenline Ave      NaN      NaN      NaN      NaN 2008-01-01 04:11:00  \n",
       "1659             None      NaN      NaN      NaN      NaN 2008-01-01 06:46:00  \n",
       "1661             None      NaN      NaN      NaN      NaN 2008-01-01 12:29:00  \n",
       "1811             None      NaN      NaN      NaN      NaN 2008-01-01 18:53:00  \n",
       "...               ...      ...      ...      ...      ...                 ...  \n",
       "12421            None      1.0      0.0      0.0      0.0 2023-04-15 02:58:00  \n",
       "12418            None      1.0      0.0      0.0      0.0 2023-04-17 14:07:00  \n",
       "12420            None      0.0      0.0      1.0      0.0 2023-04-18 03:21:00  \n",
       "12423            None      0.0      0.0      1.0      0.0 2023-04-19 20:08:00  \n",
       "12424            None      1.0      0.0      0.0      0.0 2023-04-20 17:16:00  \n",
       "\n",
       "[8550 rows x 14 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "njsp = read_parquet('data/crashes.pqt')\n",
    "njsp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "98845036",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['446', None, '42', '624', '648', '95', '544', '620', '28', '670']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "njsp.HIGHWAY.iloc[:10].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "339b775c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Highway</th>\n",
       "      <th>Location</th>\n",
       "      <th>Road</th>\n",
       "      <th>MP</th>\n",
       "      <th>At</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACCID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1703</th>\n",
       "      <td>446</td>\n",
       "      <td>State/Interstate Authority 446 S MP 1</td>\n",
       "      <td>State/Interstate Authority 446 S</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1681</th>\n",
       "      <td>None</td>\n",
       "      <td>Bergenline Ave S MP 0 at 6th St</td>\n",
       "      <td>Bergenline Ave S</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6th St</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>42</td>\n",
       "      <td>State Highway 42 N MP 8.2</td>\n",
       "      <td>State Highway 42 N</td>\n",
       "      <td>8.20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>624</td>\n",
       "      <td>County 624 W MP 2.2 at Ikea Dr</td>\n",
       "      <td>County 624 W</td>\n",
       "      <td>2.20</td>\n",
       "      <td>Ikea Dr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1811</th>\n",
       "      <td>648</td>\n",
       "      <td>County 648 E MP .87 at Franklin Ave</td>\n",
       "      <td>County 648 E</td>\n",
       "      <td>0.87</td>\n",
       "      <td>Franklin Ave</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12421</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12418</th>\n",
       "      <td>295</td>\n",
       "      <td>Interstate 295 MP 30.5</td>\n",
       "      <td>Interstate 295</td>\n",
       "      <td>30.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12420</th>\n",
       "      <td>9</td>\n",
       "      <td>State Highway 9</td>\n",
       "      <td>State Highway 9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12423</th>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12424</th>\n",
       "      <td>687</td>\n",
       "      <td>County 687 MP .25</td>\n",
       "      <td>County 687</td>\n",
       "      <td>0.25</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8550 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Highway                               Location   \n",
       "ACCID                                                  \n",
       "1703      446  State/Interstate Authority 446 S MP 1  \\\n",
       "1681     None        Bergenline Ave S MP 0 at 6th St   \n",
       "1659       42              State Highway 42 N MP 8.2   \n",
       "1661      624         County 624 W MP 2.2 at Ikea Dr   \n",
       "1811      648    County 648 E MP .87 at Franklin Ave   \n",
       "...       ...                                    ...   \n",
       "12421    None                                   None   \n",
       "12418     295                 Interstate 295 MP 30.5   \n",
       "12420       9                        State Highway 9   \n",
       "12423      35                                     35   \n",
       "12424     687                      County 687 MP .25   \n",
       "\n",
       "                                   Road     MP            At  \n",
       "ACCID                                                         \n",
       "1703   State/Interstate Authority 446 S   1.00           NaN  \n",
       "1681                   Bergenline Ave S   0.00        6th St  \n",
       "1659                 State Highway 42 N   8.20           NaN  \n",
       "1661                       County 624 W   2.20       Ikea Dr  \n",
       "1811                       County 648 E   0.87  Franklin Ave  \n",
       "...                                 ...    ...           ...  \n",
       "12421                               NaN    NaN           NaN  \n",
       "12418                    Interstate 295  30.50           NaN  \n",
       "12420                   State Highway 9    NaN           NaN  \n",
       "12423                                35    NaN           NaN  \n",
       "12424                        County 687   0.25           NaN  \n",
       "\n",
       "[8550 rows x 5 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "locs = sxs(\n",
    "    njsp.HIGHWAY.rename('Highway'),\n",
    "    njsp.LOCATION.rename('Location'),\n",
    "    njsp.LOCATION.str.extract(r'^(?P<Road>.*?)(?: MP (?P<MP>\\d*(?:\\.\\d+)?))?(?: at (?P<At>.*))?$').astype({'MP': float})\n",
    ")\n",
    "locs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "79a964c4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CCODE</th>\n",
       "      <th>CNAME</th>\n",
       "      <th>MCODE</th>\n",
       "      <th>MNAME</th>\n",
       "      <th>HIGHWAY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>FATALITIES</th>\n",
       "      <th>INJURIES</th>\n",
       "      <th>STREET</th>\n",
       "      <th>FATAL_D</th>\n",
       "      <th>FATAL_P</th>\n",
       "      <th>FATAL_T</th>\n",
       "      <th>FATAL_B</th>\n",
       "      <th>dt</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACCID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11914</th>\n",
       "      <td>02</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>0215</td>\n",
       "      <td>Englewood City</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2022-06-18 07:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12421</th>\n",
       "      <td>02</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>0246</td>\n",
       "      <td>Paramus Boro</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023-04-15 02:58:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      CCODE   CNAME MCODE           MNAME HIGHWAY LOCATION  FATALITIES   \n",
       "ACCID                                                                    \n",
       "11914    02  Bergen  0215  Englewood City    None     None         1.0  \\\n",
       "12421    02  Bergen  0246    Paramus Boro    None     None         1.0   \n",
       "\n",
       "       INJURIES STREET  FATAL_D  FATAL_P  FATAL_T  FATAL_B                  dt  \n",
       "ACCID                                                                           \n",
       "11914       NaN   None      0.0      0.0      1.0      0.0 2022-06-18 07:00:00  \n",
       "12421       0.0   None      1.0      0.0      0.0      0.0 2023-04-15 02:58:00  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "njsp[locs.Road.isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "40be7d59",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Highway     6934\n",
       "Location    8548\n",
       "Road        8548\n",
       "MP          7951\n",
       "At          1386\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(~locs.isna()).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "d9af852b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Highway</th>\n",
       "      <th>Location</th>\n",
       "      <th>Road</th>\n",
       "      <th>MP</th>\n",
       "      <th>At</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACCID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8410</th>\n",
       "      <td>None</td>\n",
       "      <td>Mola Blvd S at Washington Ave</td>\n",
       "      <td>Mola Blvd S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Washington Ave</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8527</th>\n",
       "      <td>None</td>\n",
       "      <td>North Mill Rd S</td>\n",
       "      <td>North Mill Rd S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8581</th>\n",
       "      <td>None</td>\n",
       "      <td>Christopher Columbus Dr W</td>\n",
       "      <td>Christopher Columbus Dr W</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8761</th>\n",
       "      <td>None</td>\n",
       "      <td>East Maple Ave SW</td>\n",
       "      <td>East Maple Ave SW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8801</th>\n",
       "      <td>None</td>\n",
       "      <td>Broadlane Rd N</td>\n",
       "      <td>Broadlane Rd N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12412</th>\n",
       "      <td>None</td>\n",
       "      <td>Hartford Dr</td>\n",
       "      <td>Hartford Dr</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12415</th>\n",
       "      <td>None</td>\n",
       "      <td>Bergenline Ave</td>\n",
       "      <td>Bergenline Ave</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12421</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12420</th>\n",
       "      <td>9</td>\n",
       "      <td>State Highway 9</td>\n",
       "      <td>State Highway 9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12423</th>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>599 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Highway                       Location                       Road  MP   \n",
       "ACCID                                                                         \n",
       "8410     None  Mola Blvd S at Washington Ave                Mola Blvd S NaN  \\\n",
       "8527     None                North Mill Rd S            North Mill Rd S NaN   \n",
       "8581     None      Christopher Columbus Dr W  Christopher Columbus Dr W NaN   \n",
       "8761     None              East Maple Ave SW          East Maple Ave SW NaN   \n",
       "8801     None                 Broadlane Rd N             Broadlane Rd N NaN   \n",
       "...       ...                            ...                        ...  ..   \n",
       "12412    None                    Hartford Dr                Hartford Dr NaN   \n",
       "12415    None                 Bergenline Ave             Bergenline Ave NaN   \n",
       "12421    None                           None                        NaN NaN   \n",
       "12420       9                State Highway 9            State Highway 9 NaN   \n",
       "12423      35                             35                         35 NaN   \n",
       "\n",
       "                   At  \n",
       "ACCID                  \n",
       "8410   Washington Ave  \n",
       "8527              NaN  \n",
       "8581              NaN  \n",
       "8761              NaN  \n",
       "8801              NaN  \n",
       "...               ...  \n",
       "12412             NaN  \n",
       "12415             NaN  \n",
       "12421             NaN  \n",
       "12420             NaN  \n",
       "12423             NaN  \n",
       "\n",
       "[599 rows x 5 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "locs[locs.MP.isna()]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "conda-geopandas",
   "language": "python",
   "name": "conda-geopandas"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}