AreaCoding.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "84ed56de",
   "metadata": {},
   "source": [
    "# Function that uses geocoding to extract latitude-longitude using address or zip-code:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1683403a",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('apikey.txt') as f:\n",
    "    api_key = f.readline()\n",
    "    f.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a8609b26",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "GMAPS_API_KEY = api_key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "efffa800",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_lat_long(address_or_zipcode):\n",
    "    \"\"\"\n",
    "    This function can be used to extract the latitudinal and longitudinal\n",
    "    coordinated of an entered address {as a string} or an entered zipcode \n",
    "    {as a number} and return (Latitude, Longitude)\n",
    "    \"\"\"\n",
    "\n",
    "    lat, lng = None, None\n",
    "    api_key = GMAPS_API_KEY\n",
    "    \n",
    "    # Setting up a base URL and an f-string to capture the position\n",
    "    # Using the address and the API key\n",
    "    base_url = \"https://maps.googleapis.com/maps/api/geocode/json\"\n",
    "    position = f\"{base_url}?address={address_or_zipcode}&key={api_key}\"\n",
    "    \n",
    "    # Requesting that position from GoogleMaps\n",
    "    r = requests.get(position)\n",
    "    \n",
    "    # If status code is not in valid range (ex. 404 - Not Found)\n",
    "    # Return without extracting latitude-longitude information\n",
    "    if r.status_code not in range(200, 299):\n",
    "        return None, None\n",
    "    \n",
    "    # Otherwise extract the latitude-longitude information from the request response\n",
    "    try:\n",
    "        results = r.json()['results'][0]\n",
    "        lat = results['geometry']['location']['lat']\n",
    "        lng = results['geometry']['location']['lng']\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    return lat, lng"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f69d385d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(43.070549, -89.399936)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "address = 'Ogg Residence Hall, Madison, Wisconsin'\n",
    "get_lat_long(address)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "af3e35e6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(51.4933675, 0.0098214)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "address = \"Greenwich, London\"\n",
    "get_lat_long(address)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "5fd1813a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(52.52000659999999, 13.404954)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "address = \"Berlin, Germany\"\n",
    "get_lat_long(address)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "d69eff8b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(43.057573, -89.5048796)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "address = \"Cheesecake Factory, West Towne Mall, Madison, Wisconsin, USA\"\n",
    "get_lat_long(address)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7d75948a",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14131</th>\n",
       "      <td>28608</td>\n",
       "      <td>Robbery</td>\n",
       "      <td>2021-410423</td>\n",
       "      <td>Male described as 6 feet tall, slender, with a...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3700 Frosted Leaf Dr, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police officers were dispatched to the...</td>\n",
       "      <td>Lt. Michael Richardson</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14132</th>\n",
       "      <td>28609</td>\n",
       "      <td>Attempted Homicide</td>\n",
       "      <td>2021-407981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tokiee D. Sole</td>\n",
       "      <td>5800 block Balsam Rd, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On 10/10/2021 at approximately 3:50 a.m., Madi...</td>\n",
       "      <td>P.O. Hunter Lisko</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14133</th>\n",
       "      <td>28610</td>\n",
       "      <td>Information</td>\n",
       "      <td>2021-411747</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Esker Trl/Lilyview Ln, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On October 12th, 2021 at approximately 6:43 PM...</td>\n",
       "      <td>PIO Julie Laundrie</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14134</th>\n",
       "      <td>28611</td>\n",
       "      <td>Fight (In Progress)</td>\n",
       "      <td>2021-412832</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aaron Mixon, 24-year-old\\r\\n\\r\\nNathan Dougher...</td>\n",
       "      <td>200 N First St, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police Officers responded to 200 N Fir...</td>\n",
       "      <td>P.O. Ryan Kimberley</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14135</th>\n",
       "      <td>28612</td>\n",
       "      <td>Information</td>\n",
       "      <td>0000-000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1710 Mckenna Blvd, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Madison Police Department’s West District ...</td>\n",
       "      <td>P.O. Ryan Kimberley</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14136 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       IncidentID                                     IncidentType  \\\n",
       "0            7400  Assist Outside Agency                             \n",
       "1            7401  Arrested Person                                   \n",
       "2            7402  Arrested Person                                   \n",
       "3            7403  Arrested Person                                   \n",
       "4            7404  Information                                       \n",
       "...           ...                                              ...   \n",
       "14131       28608                                          Robbery   \n",
       "14132       28609                               Attempted Homicide   \n",
       "14133       28610                                      Information   \n",
       "14134       28611                              Fight (In Progress)   \n",
       "14135       28612                                      Information   \n",
       "\n",
       "                                              CaseNumber  \\\n",
       "0      2005-13680                                    ...   \n",
       "1      2005-22647                                    ...   \n",
       "2      2005-22345                                    ...   \n",
       "3      2005-22688                                    ...   \n",
       "4      2005-999999                                   ...   \n",
       "...                                                  ...   \n",
       "14131                                        2021-410423   \n",
       "14132                                        2021-407981   \n",
       "14133                                        2021-411747   \n",
       "14134                                        2021-412832   \n",
       "14135                                        0000-000000   \n",
       "\n",
       "                                                 Suspect  \\\n",
       "0                                                    NaN   \n",
       "1                                                    NaN   \n",
       "2                                                    NaN   \n",
       "3                                                    NaN   \n",
       "4                                                    NaN   \n",
       "...                                                  ...   \n",
       "14131  Male described as 6 feet tall, slender, with a...   \n",
       "14132                                                NaN   \n",
       "14133                                                NaN   \n",
       "14134                                                NaN   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                Arrested  \\\n",
       "0                                                    ...   \n",
       "1      Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2      Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3      Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "14131                                                NaN   \n",
       "14132                                     Tokiee D. Sole   \n",
       "14133                                                NaN   \n",
       "14134  Aaron Mixon, 24-year-old\\r\\n\\r\\nNathan Dougher...   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                 Address  \\\n",
       "0      700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1        First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                   8 New Berm Court, Madison, Wisconsin   \n",
       "3                     4300 Lumley Rd, Madison, Wisconsin   \n",
       "4              211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                  ...   \n",
       "14131           3700 Frosted Leaf Dr, Madison, Wisconsin   \n",
       "14132           5800 block Balsam Rd, Madison, Wisconsin   \n",
       "14133          Esker Trl/Lilyview Ln, Madison, Wisconsin   \n",
       "14134                 200 N First St, Madison, Wisconsin   \n",
       "14135              1710 Mckenna Blvd, Madison, Wisconsin   \n",
       "\n",
       "                                                  Victim  \\\n",
       "0                                                    ...   \n",
       "1      n/a                                           ...   \n",
       "2      Home Depot                                    ...   \n",
       "3      Adult male resident of Madison                ...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "14131                                                NaN   \n",
       "14132                                                NaN   \n",
       "14133                                                NaN   \n",
       "14134                                                NaN   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                 Details  \\\n",
       "0      On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1      At approximately 11:42 pm, an officer noted a ...   \n",
       "2      On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3      At approximately 7:30 am this date, Officers r...   \n",
       "4      DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                  ...   \n",
       "14131  Madison Police officers were dispatched to the...   \n",
       "14132  On 10/10/2021 at approximately 3:50 a.m., Madi...   \n",
       "14133  On October 12th, 2021 at approximately 6:43 PM...   \n",
       "14134  Madison Police Officers responded to 200 N Fir...   \n",
       "14135  The Madison Police Department’s West District ...   \n",
       "\n",
       "                                     ReleasedBy  Day  Month  Year  Hour  \n",
       "0      Mike Hanson                                 7     10  2005     4  \n",
       "1      Lt Pat Malloy                               3      3  2005     6  \n",
       "2      Lt. T. Peterson                             2      3  2005    15  \n",
       "3      Lt. Pat Malloy                              3      3  2005    14  \n",
       "4      Lieutenant Joe Balles                       4      3  2005    20  \n",
       "...                                         ...  ...    ...   ...   ...  \n",
       "14131                    Lt. Michael Richardson   12     10  2021     7  \n",
       "14132                         P.O. Hunter Lisko   10     10  2021     9  \n",
       "14133                        PIO Julie Laundrie   12     10  2021    24  \n",
       "14134                       P.O. Ryan Kimberley   13     10  2021    22  \n",
       "14135                       P.O. Ryan Kimberley   14     10  2021     5  \n",
       "\n",
       "[14136 rows x 13 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data = pd.read_csv('cleaned_df.csv')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ef9eef1c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "data['Lat'] = pd.Series(np.zeros(data.shape[0]))\n",
    "data['Long'] = pd.Series(np.zeros(data.shape[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "c8fc954b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "61572ef9",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(0,1000):\n",
    "    \n",
    "    address = data['Address'][i]\n",
    "    \n",
    "    data['Lat'][i] = get_lat_long(address)[0]\n",
    "    data['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "0415d589",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(1000,2000):\n",
    "    \n",
    "    address = data['Address'][i]\n",
    "    \n",
    "    data['Lat'][i] = get_lat_long(address)[0]\n",
    "    data['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "e86576b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(2000,3000):\n",
    "    \n",
    "    address = data['Address'][i]\n",
    "    \n",
    "    data['Lat'][i] = get_lat_long(address)[0]\n",
    "    data['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "04db8038",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>43.079849</td>\n",
       "      <td>-89.377004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "      <td>33.745647</td>\n",
       "      <td>-117.849324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "      <td>43.039938</td>\n",
       "      <td>-89.503098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "      <td>43.033631</td>\n",
       "      <td>-89.446744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</td>\n",
       "      <td>43.072397</td>\n",
       "      <td>-89.382550</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2994</th>\n",
       "      <td>10444</td>\n",
       "      <td>Residential Burglary</td>\n",
       "      <td>2009-299238</td>\n",
       "      <td>Male, black, late teens, medium complexion, 5'...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1800 block Heath Avenue, Madison, Wisconsin</td>\n",
       "      <td>Female</td>\n",
       "      <td>Around 8:00 a.m. this morning, a woman returne...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>2009</td>\n",
       "      <td>13</td>\n",
       "      <td>43.119607</td>\n",
       "      <td>-89.361638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2995</th>\n",
       "      <td>10445</td>\n",
       "      <td>Residential Burglary</td>\n",
       "      <td>2009-297676</td>\n",
       "      <td>Male, black, 5'10\" to 5'11\", 40's, thin build,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>500 block W. Doty Street, Madison, Wisconsin</td>\n",
       "      <td>Male, age 20, Madison</td>\n",
       "      <td>On Sunday afternoon, a 20-year old Madison man...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>2009</td>\n",
       "      <td>22</td>\n",
       "      <td>43.068713</td>\n",
       "      <td>-89.388982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2996</th>\n",
       "      <td>10446</td>\n",
       "      <td>Robbery</td>\n",
       "      <td>2009-299895</td>\n",
       "      <td>Male, white, 6 feet, thin build, dark hair, bl...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1305 Regent St (Greenbush Bakery), Madison, Wi...</td>\n",
       "      <td>Greenbush Bakery</td>\n",
       "      <td>On Tuesday evening at approximately 7:15pm Mad...</td>\n",
       "      <td>Sgt. Jason Ostrenga</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>43.067961</td>\n",
       "      <td>-89.410261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2997</th>\n",
       "      <td>10447</td>\n",
       "      <td>Battery</td>\n",
       "      <td>2009-299109</td>\n",
       "      <td>Male, white, 40's, 5'9\", medium build, blonde ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1200 block Williamson Street, Madison, Wisconsin</td>\n",
       "      <td>Male, age 27, Madison</td>\n",
       "      <td>Early Tuesday morning, a 27-year old Madison m...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>2009</td>\n",
       "      <td>6</td>\n",
       "      <td>43.083251</td>\n",
       "      <td>-89.364327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2998</th>\n",
       "      <td>10448</td>\n",
       "      <td>Intoxicated Driver</td>\n",
       "      <td>2009-298056</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Christopher B. Bivens, age 22, Monona\\r\\nMr. B...</td>\n",
       "      <td>200 block W. Beltline Highway, Madison, Wisconsin</td>\n",
       "      <td>Female, age 25, Madison</td>\n",
       "      <td>Early Monday morning, a 25-year old Madison wo...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>2009</td>\n",
       "      <td>8</td>\n",
       "      <td>43.041268</td>\n",
       "      <td>-89.380102</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2999 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      IncidentID                                     IncidentType  \\\n",
       "0           7400  Assist Outside Agency                             \n",
       "1           7401  Arrested Person                                   \n",
       "2           7402  Arrested Person                                   \n",
       "3           7403  Arrested Person                                   \n",
       "4           7404  Information                                       \n",
       "...          ...                                              ...   \n",
       "2994       10444                             Residential Burglary   \n",
       "2995       10445                             Residential Burglary   \n",
       "2996       10446                                          Robbery   \n",
       "2997       10447                                          Battery   \n",
       "2998       10448                               Intoxicated Driver   \n",
       "\n",
       "                                             CaseNumber  \\\n",
       "0     2005-13680                                    ...   \n",
       "1     2005-22647                                    ...   \n",
       "2     2005-22345                                    ...   \n",
       "3     2005-22688                                    ...   \n",
       "4     2005-999999                                   ...   \n",
       "...                                                 ...   \n",
       "2994                                        2009-299238   \n",
       "2995                                        2009-297676   \n",
       "2996                                        2009-299895   \n",
       "2997                                        2009-299109   \n",
       "2998                                        2009-298056   \n",
       "\n",
       "                                                Suspect  \\\n",
       "0                                                   NaN   \n",
       "1                                                   NaN   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "...                                                 ...   \n",
       "2994  Male, black, late teens, medium complexion, 5'...   \n",
       "2995  Male, black, 5'10\" to 5'11\", 40's, thin build,...   \n",
       "2996  Male, white, 6 feet, thin build, dark hair, bl...   \n",
       "2997  Male, white, 40's, 5'9\", medium build, blonde ...   \n",
       "2998                                                NaN   \n",
       "\n",
       "                                               Arrested  \\\n",
       "0                                                   ...   \n",
       "1     Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2     Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3     Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "2994                                                NaN   \n",
       "2995                                                NaN   \n",
       "2996                                                NaN   \n",
       "2997                                                NaN   \n",
       "2998  Christopher B. Bivens, age 22, Monona\\r\\nMr. B...   \n",
       "\n",
       "                                                Address  \\\n",
       "0     700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1       First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                  8 New Berm Court, Madison, Wisconsin   \n",
       "3                    4300 Lumley Rd, Madison, Wisconsin   \n",
       "4             211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                 ...   \n",
       "2994        1800 block Heath Avenue, Madison, Wisconsin   \n",
       "2995       500 block W. Doty Street, Madison, Wisconsin   \n",
       "2996  1305 Regent St (Greenbush Bakery), Madison, Wi...   \n",
       "2997   1200 block Williamson Street, Madison, Wisconsin   \n",
       "2998  200 block W. Beltline Highway, Madison, Wisconsin   \n",
       "\n",
       "                                                 Victim  \\\n",
       "0                                                   ...   \n",
       "1     n/a                                           ...   \n",
       "2     Home Depot                                    ...   \n",
       "3     Adult male resident of Madison                ...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "2994                                             Female   \n",
       "2995                              Male, age 20, Madison   \n",
       "2996                                   Greenbush Bakery   \n",
       "2997                              Male, age 27, Madison   \n",
       "2998                            Female, age 25, Madison   \n",
       "\n",
       "                                                Details  \\\n",
       "0     On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1     At approximately 11:42 pm, an officer noted a ...   \n",
       "2     On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3     At approximately 7:30 am this date, Officers r...   \n",
       "4     DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                 ...   \n",
       "2994  Around 8:00 a.m. this morning, a woman returne...   \n",
       "2995  On Sunday afternoon, a 20-year old Madison man...   \n",
       "2996  On Tuesday evening at approximately 7:15pm Mad...   \n",
       "2997  Early Tuesday morning, a 27-year old Madison m...   \n",
       "2998  Early Monday morning, a 25-year old Madison wo...   \n",
       "\n",
       "                                    ReleasedBy  Day  Month  Year  Hour  \\\n",
       "0     Mike Hanson                                 7     10  2005     4   \n",
       "1     Lt Pat Malloy                               3      3  2005     6   \n",
       "2     Lt. T. Peterson                             2      3  2005    15   \n",
       "3     Lt. Pat Malloy                              3      3  2005    14   \n",
       "4     Lieutenant Joe Balles                       4      3  2005    20   \n",
       "...                                        ...  ...    ...   ...   ...   \n",
       "2994                          PIO Joel DeSpain    6     10  2009    13   \n",
       "2995                          PIO Joel DeSpain    4     10  2009    22   \n",
       "2996                       Sgt. Jason Ostrenga    7     10  2009     0   \n",
       "2997                          PIO Joel DeSpain    6     10  2009     6   \n",
       "2998                          PIO Joel DeSpain    5     10  2009     8   \n",
       "\n",
       "            Lat        Long  \n",
       "0     43.079849  -89.377004  \n",
       "1     33.745647 -117.849324  \n",
       "2     43.039938  -89.503098  \n",
       "3     43.033631  -89.446744  \n",
       "4     43.072397  -89.382550  \n",
       "...         ...         ...  \n",
       "2994  43.119607  -89.361638  \n",
       "2995  43.068713  -89.388982  \n",
       "2996  43.067961  -89.410261  \n",
       "2997  43.083251  -89.364327  \n",
       "2998  43.041268  -89.380102  \n",
       "\n",
       "[2999 rows x 15 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[:2999]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "96b6c75e",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv('geo_df.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "d8b80f7e",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>43.079849</td>\n",
       "      <td>-89.377004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "      <td>33.745647</td>\n",
       "      <td>-117.849324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "      <td>43.039938</td>\n",
       "      <td>-89.503098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "      <td>43.033631</td>\n",
       "      <td>-89.446744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</td>\n",
       "      <td>43.072397</td>\n",
       "      <td>-89.382550</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14131</th>\n",
       "      <td>28608</td>\n",
       "      <td>Robbery</td>\n",
       "      <td>2021-410423</td>\n",
       "      <td>Male described as 6 feet tall, slender, with a...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3700 Frosted Leaf Dr, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police officers were dispatched to the...</td>\n",
       "      <td>Lt. Michael Richardson</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>7</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14132</th>\n",
       "      <td>28609</td>\n",
       "      <td>Attempted Homicide</td>\n",
       "      <td>2021-407981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tokiee D. Sole</td>\n",
       "      <td>5800 block Balsam Rd, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On 10/10/2021 at approximately 3:50 a.m., Madi...</td>\n",
       "      <td>P.O. Hunter Lisko</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14133</th>\n",
       "      <td>28610</td>\n",
       "      <td>Information</td>\n",
       "      <td>2021-411747</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Esker Trl/Lilyview Ln, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On October 12th, 2021 at approximately 6:43 PM...</td>\n",
       "      <td>PIO Julie Laundrie</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>24</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14134</th>\n",
       "      <td>28611</td>\n",
       "      <td>Fight (In Progress)</td>\n",
       "      <td>2021-412832</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aaron Mixon, 24-year-old\\r\\n\\r\\nNathan Dougher...</td>\n",
       "      <td>200 N First St, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police Officers responded to 200 N Fir...</td>\n",
       "      <td>P.O. Ryan Kimberley</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>22</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14135</th>\n",
       "      <td>28612</td>\n",
       "      <td>Information</td>\n",
       "      <td>0000-000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1710 Mckenna Blvd, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Madison Police Department’s West District ...</td>\n",
       "      <td>P.O. Ryan Kimberley</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14136 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       IncidentID                                     IncidentType  \\\n",
       "0            7400  Assist Outside Agency                             \n",
       "1            7401  Arrested Person                                   \n",
       "2            7402  Arrested Person                                   \n",
       "3            7403  Arrested Person                                   \n",
       "4            7404  Information                                       \n",
       "...           ...                                              ...   \n",
       "14131       28608                                          Robbery   \n",
       "14132       28609                               Attempted Homicide   \n",
       "14133       28610                                      Information   \n",
       "14134       28611                              Fight (In Progress)   \n",
       "14135       28612                                      Information   \n",
       "\n",
       "                                              CaseNumber  \\\n",
       "0      2005-13680                                    ...   \n",
       "1      2005-22647                                    ...   \n",
       "2      2005-22345                                    ...   \n",
       "3      2005-22688                                    ...   \n",
       "4      2005-999999                                   ...   \n",
       "...                                                  ...   \n",
       "14131                                        2021-410423   \n",
       "14132                                        2021-407981   \n",
       "14133                                        2021-411747   \n",
       "14134                                        2021-412832   \n",
       "14135                                        0000-000000   \n",
       "\n",
       "                                                 Suspect  \\\n",
       "0                                                    NaN   \n",
       "1                                                    NaN   \n",
       "2                                                    NaN   \n",
       "3                                                    NaN   \n",
       "4                                                    NaN   \n",
       "...                                                  ...   \n",
       "14131  Male described as 6 feet tall, slender, with a...   \n",
       "14132                                                NaN   \n",
       "14133                                                NaN   \n",
       "14134                                                NaN   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                Arrested  \\\n",
       "0                                                    ...   \n",
       "1      Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2      Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3      Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "14131                                                NaN   \n",
       "14132                                     Tokiee D. Sole   \n",
       "14133                                                NaN   \n",
       "14134  Aaron Mixon, 24-year-old\\r\\n\\r\\nNathan Dougher...   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                 Address  \\\n",
       "0      700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1        First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                   8 New Berm Court, Madison, Wisconsin   \n",
       "3                     4300 Lumley Rd, Madison, Wisconsin   \n",
       "4              211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                  ...   \n",
       "14131           3700 Frosted Leaf Dr, Madison, Wisconsin   \n",
       "14132           5800 block Balsam Rd, Madison, Wisconsin   \n",
       "14133          Esker Trl/Lilyview Ln, Madison, Wisconsin   \n",
       "14134                 200 N First St, Madison, Wisconsin   \n",
       "14135              1710 Mckenna Blvd, Madison, Wisconsin   \n",
       "\n",
       "                                                  Victim  \\\n",
       "0                                                    ...   \n",
       "1      n/a                                           ...   \n",
       "2      Home Depot                                    ...   \n",
       "3      Adult male resident of Madison                ...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "14131                                                NaN   \n",
       "14132                                                NaN   \n",
       "14133                                                NaN   \n",
       "14134                                                NaN   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                 Details  \\\n",
       "0      On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1      At approximately 11:42 pm, an officer noted a ...   \n",
       "2      On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3      At approximately 7:30 am this date, Officers r...   \n",
       "4      DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                  ...   \n",
       "14131  Madison Police officers were dispatched to the...   \n",
       "14132  On 10/10/2021 at approximately 3:50 a.m., Madi...   \n",
       "14133  On October 12th, 2021 at approximately 6:43 PM...   \n",
       "14134  Madison Police Officers responded to 200 N Fir...   \n",
       "14135  The Madison Police Department’s West District ...   \n",
       "\n",
       "                                     ReleasedBy  Day  Month  Year  Hour  \\\n",
       "0      Mike Hanson                                 7     10  2005     4   \n",
       "1      Lt Pat Malloy                               3      3  2005     6   \n",
       "2      Lt. T. Peterson                             2      3  2005    15   \n",
       "3      Lt. Pat Malloy                              3      3  2005    14   \n",
       "4      Lieutenant Joe Balles                       4      3  2005    20   \n",
       "...                                         ...  ...    ...   ...   ...   \n",
       "14131                    Lt. Michael Richardson   12     10  2021     7   \n",
       "14132                         P.O. Hunter Lisko   10     10  2021     9   \n",
       "14133                        PIO Julie Laundrie   12     10  2021    24   \n",
       "14134                       P.O. Ryan Kimberley   13     10  2021    22   \n",
       "14135                       P.O. Ryan Kimberley   14     10  2021     5   \n",
       "\n",
       "             Lat        Long  \n",
       "0      43.079849  -89.377004  \n",
       "1      33.745647 -117.849324  \n",
       "2      43.039938  -89.503098  \n",
       "3      43.033631  -89.446744  \n",
       "4      43.072397  -89.382550  \n",
       "...          ...         ...  \n",
       "14131   0.000000    0.000000  \n",
       "14132   0.000000    0.000000  \n",
       "14133   0.000000    0.000000  \n",
       "14134   0.000000    0.000000  \n",
       "14135   0.000000    0.000000  \n",
       "\n",
       "[14136 rows x 15 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new = pd.read_csv('geo_df.csv')\n",
    "data_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "63bee83b",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(3000,5000):\n",
    "    \n",
    "    address = data_new['Address'][i]\n",
    "    \n",
    "    data_new['Lat'][i] = get_lat_long(address)[0]\n",
    "    data_new['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "ce0e484c",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_new.to_csv('geo_df.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "15ce152d",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>43.079849</td>\n",
       "      <td>-89.377004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "      <td>33.745647</td>\n",
       "      <td>-117.849324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "      <td>43.039938</td>\n",
       "      <td>-89.503098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "      <td>43.033631</td>\n",
       "      <td>-89.446744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</td>\n",
       "      <td>43.072397</td>\n",
       "      <td>-89.382550</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4995</th>\n",
       "      <td>12459</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2011-240349</td>\n",
       "      <td>see below:</td>\n",
       "      <td>Miles E. Kristan, 25-year-old male of Madison,...</td>\n",
       "      <td>700 State Street, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police went to the 700 block of State ...</td>\n",
       "      <td>P.O. Howard Payne</td>\n",
       "      <td>25</td>\n",
       "      <td>8</td>\n",
       "      <td>2011</td>\n",
       "      <td>21</td>\n",
       "      <td>43.075564</td>\n",
       "      <td>-89.397376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4996</th>\n",
       "      <td>12460</td>\n",
       "      <td>Fight (In Progress)</td>\n",
       "      <td>2011-236554</td>\n",
       "      <td>See below:</td>\n",
       "      <td>Brendan Emon Kim, 21-year-old male of Cottage ...</td>\n",
       "      <td>300 West Johnson Street, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police responded to the 300 block of W...</td>\n",
       "      <td>P.O. Howard Payne</td>\n",
       "      <td>22</td>\n",
       "      <td>8</td>\n",
       "      <td>2011</td>\n",
       "      <td>7</td>\n",
       "      <td>43.074558</td>\n",
       "      <td>-89.390674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4997</th>\n",
       "      <td>12461</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2011-236218</td>\n",
       "      <td>See below:</td>\n",
       "      <td>Quentin Romel Scott, 23-year-old male of Madis...</td>\n",
       "      <td>1800 Beld Street, Madison, Wisconsin</td>\n",
       "      <td>19-year-old female</td>\n",
       "      <td>Madison Police responded to the 1800 block of ...</td>\n",
       "      <td>P.O. Howard Payne</td>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>2011</td>\n",
       "      <td>23</td>\n",
       "      <td>43.047977</td>\n",
       "      <td>-89.393348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4998</th>\n",
       "      <td>12462</td>\n",
       "      <td>Fight (In Progress)</td>\n",
       "      <td>2011-235627</td>\n",
       "      <td>See Below:</td>\n",
       "      <td>Nicholas Alexander McQueen, 21-year-old male o...</td>\n",
       "      <td>500 State Street, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On 8/21/2011, at approximately 2:25 am, Madiso...</td>\n",
       "      <td>P.O. Howard Payne</td>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>2011</td>\n",
       "      <td>7</td>\n",
       "      <td>43.075055</td>\n",
       "      <td>-89.393463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4999</th>\n",
       "      <td>12463</td>\n",
       "      <td>Intoxicated Driver</td>\n",
       "      <td>2011-238733</td>\n",
       "      <td>See Below:</td>\n",
       "      <td>Mark W. Fields, 24-year-old male of Madison, W...</td>\n",
       "      <td>5800 Raymond Road, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On 8/24/2011, at approximately 3:01am, a Madis...</td>\n",
       "      <td>P.O. Howard Payne</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>2011</td>\n",
       "      <td>8</td>\n",
       "      <td>43.032214</td>\n",
       "      <td>-89.479869</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5000 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      IncidentID                                     IncidentType  \\\n",
       "0           7400  Assist Outside Agency                             \n",
       "1           7401  Arrested Person                                   \n",
       "2           7402  Arrested Person                                   \n",
       "3           7403  Arrested Person                                   \n",
       "4           7404  Information                                       \n",
       "...          ...                                              ...   \n",
       "4995       12459                                  Arrested Person   \n",
       "4996       12460                              Fight (In Progress)   \n",
       "4997       12461                                  Arrested Person   \n",
       "4998       12462                              Fight (In Progress)   \n",
       "4999       12463                               Intoxicated Driver   \n",
       "\n",
       "                                             CaseNumber     Suspect  \\\n",
       "0     2005-13680                                    ...         NaN   \n",
       "1     2005-22647                                    ...         NaN   \n",
       "2     2005-22345                                    ...         NaN   \n",
       "3     2005-22688                                    ...         NaN   \n",
       "4     2005-999999                                   ...         NaN   \n",
       "...                                                 ...         ...   \n",
       "4995                                        2011-240349  see below:   \n",
       "4996                                        2011-236554  See below:   \n",
       "4997                                        2011-236218  See below:   \n",
       "4998                                        2011-235627  See Below:   \n",
       "4999                                        2011-238733  See Below:   \n",
       "\n",
       "                                               Arrested  \\\n",
       "0                                                   ...   \n",
       "1     Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2     Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3     Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "4995  Miles E. Kristan, 25-year-old male of Madison,...   \n",
       "4996  Brendan Emon Kim, 21-year-old male of Cottage ...   \n",
       "4997  Quentin Romel Scott, 23-year-old male of Madis...   \n",
       "4998  Nicholas Alexander McQueen, 21-year-old male o...   \n",
       "4999  Mark W. Fields, 24-year-old male of Madison, W...   \n",
       "\n",
       "                                                Address  \\\n",
       "0     700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1       First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                  8 New Berm Court, Madison, Wisconsin   \n",
       "3                    4300 Lumley Rd, Madison, Wisconsin   \n",
       "4             211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                 ...   \n",
       "4995               700 State Street, Madison, Wisconsin   \n",
       "4996        300 West Johnson Street, Madison, Wisconsin   \n",
       "4997               1800 Beld Street, Madison, Wisconsin   \n",
       "4998               500 State Street, Madison, Wisconsin   \n",
       "4999              5800 Raymond Road, Madison, Wisconsin   \n",
       "\n",
       "                                                 Victim  \\\n",
       "0                                                   ...   \n",
       "1     n/a                                           ...   \n",
       "2     Home Depot                                    ...   \n",
       "3     Adult male resident of Madison                ...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "4995                                                NaN   \n",
       "4996                                                NaN   \n",
       "4997                                 19-year-old female   \n",
       "4998                                                NaN   \n",
       "4999                                                NaN   \n",
       "\n",
       "                                                Details  \\\n",
       "0     On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1     At approximately 11:42 pm, an officer noted a ...   \n",
       "2     On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3     At approximately 7:30 am this date, Officers r...   \n",
       "4     DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                 ...   \n",
       "4995  Madison Police went to the 700 block of State ...   \n",
       "4996  Madison Police responded to the 300 block of W...   \n",
       "4997  Madison Police responded to the 1800 block of ...   \n",
       "4998  On 8/21/2011, at approximately 2:25 am, Madiso...   \n",
       "4999  On 8/24/2011, at approximately 3:01am, a Madis...   \n",
       "\n",
       "                                    ReleasedBy  Day  Month  Year  Hour  \\\n",
       "0     Mike Hanson                                 7     10  2005     4   \n",
       "1     Lt Pat Malloy                               3      3  2005     6   \n",
       "2     Lt. T. Peterson                             2      3  2005    15   \n",
       "3     Lt. Pat Malloy                              3      3  2005    14   \n",
       "4     Lieutenant Joe Balles                       4      3  2005    20   \n",
       "...                                        ...  ...    ...   ...   ...   \n",
       "4995                         P.O. Howard Payne   25      8  2011    21   \n",
       "4996                         P.O. Howard Payne   22      8  2011     7   \n",
       "4997                         P.O. Howard Payne   21      8  2011    23   \n",
       "4998                         P.O. Howard Payne   21      8  2011     7   \n",
       "4999                         P.O. Howard Payne   24      8  2011     8   \n",
       "\n",
       "            Lat        Long  \n",
       "0     43.079849  -89.377004  \n",
       "1     33.745647 -117.849324  \n",
       "2     43.039938  -89.503098  \n",
       "3     43.033631  -89.446744  \n",
       "4     43.072397  -89.382550  \n",
       "...         ...         ...  \n",
       "4995  43.075564  -89.397376  \n",
       "4996  43.074558  -89.390674  \n",
       "4997  43.047977  -89.393348  \n",
       "4998  43.075055  -89.393463  \n",
       "4999  43.032214  -89.479869  \n",
       "\n",
       "[5000 rows x 15 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new = pd.read_csv('geo_df.csv')\n",
    "data_new[:5000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "7fa64d1e",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(5000,7000):\n",
    "    \n",
    "    address = data_new['Address'][i]\n",
    "    \n",
    "    data_new['Lat'][i] = get_lat_long(address)[0]\n",
    "    data_new['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "01455adc",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_new.to_csv('geo_df.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "52a6d3c0",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>43.079849</td>\n",
       "      <td>-89.377004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "      <td>33.745647</td>\n",
       "      <td>-117.849324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "      <td>43.039938</td>\n",
       "      <td>-89.503098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "      <td>43.033631</td>\n",
       "      <td>-89.446744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</td>\n",
       "      <td>43.072397</td>\n",
       "      <td>-89.382550</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6995</th>\n",
       "      <td>14466</td>\n",
       "      <td>Fraud</td>\n",
       "      <td>2013-183171</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dangelo D. Chester, age 24, Chicago\\r\\nMr. Che...</td>\n",
       "      <td>22 E. Mifflin St., Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The suspects weren't quite on the same page wh...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>20</td>\n",
       "      <td>6</td>\n",
       "      <td>2013</td>\n",
       "      <td>21</td>\n",
       "      <td>43.076193</td>\n",
       "      <td>-89.384549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6996</th>\n",
       "      <td>14467</td>\n",
       "      <td>Battery</td>\n",
       "      <td>2013-167555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jakiv McReynolds, age 18, Madison\\r\\nMr. McRey...</td>\n",
       "      <td>102 West Corporate Dr., Madison, Wisconsin</td>\n",
       "      <td>Male age 18, Madison</td>\n",
       "      <td>The MPD arrested two more teens yesterday in c...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>2013</td>\n",
       "      <td>4</td>\n",
       "      <td>43.098630</td>\n",
       "      <td>-89.322269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6997</th>\n",
       "      <td>14468</td>\n",
       "      <td>Traffic Incident</td>\n",
       "      <td>2013-185256</td>\n",
       "      <td>Possibly a black Volkswagen.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W. Johnson/ N. Frances, Madison, Wisconsin</td>\n",
       "      <td>Male, 29, Madison</td>\n",
       "      <td>On 6/22/13 the victim and friends were walking...</td>\n",
       "      <td>Sgt. Michael Hanson</td>\n",
       "      <td>22</td>\n",
       "      <td>6</td>\n",
       "      <td>2013</td>\n",
       "      <td>7</td>\n",
       "      <td>43.072012</td>\n",
       "      <td>-89.395871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6998</th>\n",
       "      <td>14469</td>\n",
       "      <td>Weapons Violation</td>\n",
       "      <td>2013-188127</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6300 block of Bettys Lane, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On 6/24/13 at 2:03 p.m. several Madison Police...</td>\n",
       "      <td>Sgt. Michael Hanson</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>2013</td>\n",
       "      <td>19</td>\n",
       "      <td>43.038141</td>\n",
       "      <td>-89.489797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6999</th>\n",
       "      <td>14470</td>\n",
       "      <td>Information</td>\n",
       "      <td>2013-000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>City-Wide, Madison, Wisconsin</td>\n",
       "      <td>Motorists, bicyclist, pedestrians, farmers, jo...</td>\n",
       "      <td>The Madison Police Department has been extreme...</td>\n",
       "      <td>Sgt. Michael Hanson</td>\n",
       "      <td>26</td>\n",
       "      <td>6</td>\n",
       "      <td>2013</td>\n",
       "      <td>13</td>\n",
       "      <td>43.054045</td>\n",
       "      <td>-89.326017</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7000 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      IncidentID                                     IncidentType  \\\n",
       "0           7400  Assist Outside Agency                             \n",
       "1           7401  Arrested Person                                   \n",
       "2           7402  Arrested Person                                   \n",
       "3           7403  Arrested Person                                   \n",
       "4           7404  Information                                       \n",
       "...          ...                                              ...   \n",
       "6995       14466                                            Fraud   \n",
       "6996       14467                                          Battery   \n",
       "6997       14468                                 Traffic Incident   \n",
       "6998       14469                                Weapons Violation   \n",
       "6999       14470                                      Information   \n",
       "\n",
       "                                             CaseNumber  \\\n",
       "0     2005-13680                                    ...   \n",
       "1     2005-22647                                    ...   \n",
       "2     2005-22345                                    ...   \n",
       "3     2005-22688                                    ...   \n",
       "4     2005-999999                                   ...   \n",
       "...                                                 ...   \n",
       "6995                                        2013-183171   \n",
       "6996                                        2013-167555   \n",
       "6997                                        2013-185256   \n",
       "6998                                        2013-188127   \n",
       "6999                                        2013-000000   \n",
       "\n",
       "                           Suspect  \\\n",
       "0                              NaN   \n",
       "1                              NaN   \n",
       "2                              NaN   \n",
       "3                              NaN   \n",
       "4                              NaN   \n",
       "...                            ...   \n",
       "6995                           NaN   \n",
       "6996                           NaN   \n",
       "6997  Possibly a black Volkswagen.   \n",
       "6998                           NaN   \n",
       "6999                           NaN   \n",
       "\n",
       "                                               Arrested  \\\n",
       "0                                                   ...   \n",
       "1     Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2     Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3     Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "6995  Dangelo D. Chester, age 24, Chicago\\r\\nMr. Che...   \n",
       "6996  Jakiv McReynolds, age 18, Madison\\r\\nMr. McRey...   \n",
       "6997                                                NaN   \n",
       "6998                                                NaN   \n",
       "6999                                                NaN   \n",
       "\n",
       "                                                Address  \\\n",
       "0     700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1       First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                  8 New Berm Court, Madison, Wisconsin   \n",
       "3                    4300 Lumley Rd, Madison, Wisconsin   \n",
       "4             211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                 ...   \n",
       "6995              22 E. Mifflin St., Madison, Wisconsin   \n",
       "6996         102 West Corporate Dr., Madison, Wisconsin   \n",
       "6997         W. Johnson/ N. Frances, Madison, Wisconsin   \n",
       "6998      6300 block of Bettys Lane, Madison, Wisconsin   \n",
       "6999                      City-Wide, Madison, Wisconsin   \n",
       "\n",
       "                                                 Victim  \\\n",
       "0                                                   ...   \n",
       "1     n/a                                           ...   \n",
       "2     Home Depot                                    ...   \n",
       "3     Adult male resident of Madison                ...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "6995                                                NaN   \n",
       "6996                               Male age 18, Madison   \n",
       "6997                                  Male, 29, Madison   \n",
       "6998                                                NaN   \n",
       "6999  Motorists, bicyclist, pedestrians, farmers, jo...   \n",
       "\n",
       "                                                Details  \\\n",
       "0     On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1     At approximately 11:42 pm, an officer noted a ...   \n",
       "2     On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3     At approximately 7:30 am this date, Officers r...   \n",
       "4     DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                 ...   \n",
       "6995  The suspects weren't quite on the same page wh...   \n",
       "6996  The MPD arrested two more teens yesterday in c...   \n",
       "6997  On 6/22/13 the victim and friends were walking...   \n",
       "6998  On 6/24/13 at 2:03 p.m. several Madison Police...   \n",
       "6999  The Madison Police Department has been extreme...   \n",
       "\n",
       "                                    ReleasedBy  Day  Month  Year  Hour  \\\n",
       "0     Mike Hanson                                 7     10  2005     4   \n",
       "1     Lt Pat Malloy                               3      3  2005     6   \n",
       "2     Lt. T. Peterson                             2      3  2005    15   \n",
       "3     Lt. Pat Malloy                              3      3  2005    14   \n",
       "4     Lieutenant Joe Balles                       4      3  2005    20   \n",
       "...                                        ...  ...    ...   ...   ...   \n",
       "6995                          PIO Joel DeSpain   20      6  2013    21   \n",
       "6996                          PIO Joel DeSpain    8      6  2013     4   \n",
       "6997                       Sgt. Michael Hanson   22      6  2013     7   \n",
       "6998                       Sgt. Michael Hanson   24      6  2013    19   \n",
       "6999                       Sgt. Michael Hanson   26      6  2013    13   \n",
       "\n",
       "            Lat        Long  \n",
       "0     43.079849  -89.377004  \n",
       "1     33.745647 -117.849324  \n",
       "2     43.039938  -89.503098  \n",
       "3     43.033631  -89.446744  \n",
       "4     43.072397  -89.382550  \n",
       "...         ...         ...  \n",
       "6995  43.076193  -89.384549  \n",
       "6996  43.098630  -89.322269  \n",
       "6997  43.072012  -89.395871  \n",
       "6998  43.038141  -89.489797  \n",
       "6999  43.054045  -89.326017  \n",
       "\n",
       "[7000 rows x 15 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new = pd.read_csv('geo_df.csv')\n",
    "data_new[:7000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "689bbba0",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(7000,10000):\n",
    "    \n",
    "    address = data_new['Address'][i]\n",
    "    \n",
    "    data_new['Lat'][i] = get_lat_long(address)[0]\n",
    "    data_new['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "5474fa39",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_new.to_csv('geo_df.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "6cc9b37d",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>43.079849</td>\n",
       "      <td>-89.377004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "      <td>33.745647</td>\n",
       "      <td>-117.849324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "      <td>43.039938</td>\n",
       "      <td>-89.503098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "      <td>43.033631</td>\n",
       "      <td>-89.446744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</td>\n",
       "      <td>43.072397</td>\n",
       "      <td>-89.382550</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>18478</td>\n",
       "      <td>Attempted Homicide</td>\n",
       "      <td>2016-414818</td>\n",
       "      <td>Hasson J. Williams, age 29, Madison\\r\\nSuspect...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wright St, Madison, Wisconsin</td>\n",
       "      <td>Male, age 30, Madison</td>\n",
       "      <td>On 11/20/16 at approximately 8:57 PM, the Madi...</td>\n",
       "      <td>Sgt. Shannon Blackamore</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>2016</td>\n",
       "      <td>3</td>\n",
       "      <td>43.122347</td>\n",
       "      <td>-89.330385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>18479</td>\n",
       "      <td>Robbery</td>\n",
       "      <td>2016-414870</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1700 block Fordem Ave., Madison, Wisconsin</td>\n",
       "      <td>Female, age 22, Madison</td>\n",
       "      <td>&amp;nbsp;A Sunday night dog walk turned into a mu...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>2016</td>\n",
       "      <td>3</td>\n",
       "      <td>43.094318</td>\n",
       "      <td>-89.364199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>18480</td>\n",
       "      <td>Weapons Violation</td>\n",
       "      <td>2016-413177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Terrell R. Cargile, age 33, Madison\\r\\nSuspect...</td>\n",
       "      <td>3019 E. Washington Ave., Madison, Wisconsin</td>\n",
       "      <td>Female, age 31, Madison</td>\n",
       "      <td>&amp;nbsp;The MPD recovered a handgun a suspect hi...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>19</td>\n",
       "      <td>11</td>\n",
       "      <td>2016</td>\n",
       "      <td>15</td>\n",
       "      <td>43.103635</td>\n",
       "      <td>-89.341810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>18481</td>\n",
       "      <td>Weapons Violation</td>\n",
       "      <td>2016-413844</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jerrod J. Ragland, age 25, Madison\\r\\nSuspect ...</td>\n",
       "      <td>W. Johnson St., Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&amp;nbsp;A driver, who ran a red light downtown S...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>20</td>\n",
       "      <td>11</td>\n",
       "      <td>2016</td>\n",
       "      <td>4</td>\n",
       "      <td>43.072040</td>\n",
       "      <td>-89.397469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>18482</td>\n",
       "      <td>Robbery</td>\n",
       "      <td>2016-414936</td>\n",
       "      <td>Male, white, 5'6\" to 5'7\", wearing dark clothi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2604 E. Washington Ave., Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&amp;nbsp;A man wielding a knife held up Papa John...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>2016</td>\n",
       "      <td>6</td>\n",
       "      <td>43.100831</td>\n",
       "      <td>-89.348909</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      IncidentID                                     IncidentType  \\\n",
       "0           7400  Assist Outside Agency                             \n",
       "1           7401  Arrested Person                                   \n",
       "2           7402  Arrested Person                                   \n",
       "3           7403  Arrested Person                                   \n",
       "4           7404  Information                                       \n",
       "...          ...                                              ...   \n",
       "9995       18478                               Attempted Homicide   \n",
       "9996       18479                                          Robbery   \n",
       "9997       18480                                Weapons Violation   \n",
       "9998       18481                                Weapons Violation   \n",
       "9999       18482                                          Robbery   \n",
       "\n",
       "                                             CaseNumber  \\\n",
       "0     2005-13680                                    ...   \n",
       "1     2005-22647                                    ...   \n",
       "2     2005-22345                                    ...   \n",
       "3     2005-22688                                    ...   \n",
       "4     2005-999999                                   ...   \n",
       "...                                                 ...   \n",
       "9995                                        2016-414818   \n",
       "9996                                        2016-414870   \n",
       "9997                                        2016-413177   \n",
       "9998                                        2016-413844   \n",
       "9999                                        2016-414936   \n",
       "\n",
       "                                                Suspect  \\\n",
       "0                                                   NaN   \n",
       "1                                                   NaN   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "...                                                 ...   \n",
       "9995  Hasson J. Williams, age 29, Madison\\r\\nSuspect...   \n",
       "9996                                                NaN   \n",
       "9997                                                NaN   \n",
       "9998                                                NaN   \n",
       "9999  Male, white, 5'6\" to 5'7\", wearing dark clothi...   \n",
       "\n",
       "                                               Arrested  \\\n",
       "0                                                   ...   \n",
       "1     Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2     Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3     Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "9995                                                NaN   \n",
       "9996                                                NaN   \n",
       "9997  Terrell R. Cargile, age 33, Madison\\r\\nSuspect...   \n",
       "9998  Jerrod J. Ragland, age 25, Madison\\r\\nSuspect ...   \n",
       "9999                                                NaN   \n",
       "\n",
       "                                                Address  \\\n",
       "0     700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1       First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                  8 New Berm Court, Madison, Wisconsin   \n",
       "3                    4300 Lumley Rd, Madison, Wisconsin   \n",
       "4             211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                 ...   \n",
       "9995                      Wright St, Madison, Wisconsin   \n",
       "9996         1700 block Fordem Ave., Madison, Wisconsin   \n",
       "9997        3019 E. Washington Ave., Madison, Wisconsin   \n",
       "9998                 W. Johnson St., Madison, Wisconsin   \n",
       "9999        2604 E. Washington Ave., Madison, Wisconsin   \n",
       "\n",
       "                                                 Victim  \\\n",
       "0                                                   ...   \n",
       "1     n/a                                           ...   \n",
       "2     Home Depot                                    ...   \n",
       "3     Adult male resident of Madison                ...   \n",
       "4                                                   ...   \n",
       "...                                                 ...   \n",
       "9995                              Male, age 30, Madison   \n",
       "9996                            Female, age 22, Madison   \n",
       "9997                            Female, age 31, Madison   \n",
       "9998                                                NaN   \n",
       "9999                                                NaN   \n",
       "\n",
       "                                                Details  \\\n",
       "0     On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1     At approximately 11:42 pm, an officer noted a ...   \n",
       "2     On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3     At approximately 7:30 am this date, Officers r...   \n",
       "4     DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                 ...   \n",
       "9995  On 11/20/16 at approximately 8:57 PM, the Madi...   \n",
       "9996  &nbsp;A Sunday night dog walk turned into a mu...   \n",
       "9997  &nbsp;The MPD recovered a handgun a suspect hi...   \n",
       "9998  &nbsp;A driver, who ran a red light downtown S...   \n",
       "9999  &nbsp;A man wielding a knife held up Papa John...   \n",
       "\n",
       "                                    ReleasedBy  Day  Month  Year  Hour  \\\n",
       "0     Mike Hanson                                 7     10  2005     4   \n",
       "1     Lt Pat Malloy                               3      3  2005     6   \n",
       "2     Lt. T. Peterson                             2      3  2005    15   \n",
       "3     Lt. Pat Malloy                              3      3  2005    14   \n",
       "4     Lieutenant Joe Balles                       4      3  2005    20   \n",
       "...                                        ...  ...    ...   ...   ...   \n",
       "9995                   Sgt. Shannon Blackamore   21     11  2016     3   \n",
       "9996                          PIO Joel DeSpain   21     11  2016     3   \n",
       "9997                          PIO Joel DeSpain   19     11  2016    15   \n",
       "9998                          PIO Joel DeSpain   20     11  2016     4   \n",
       "9999                          PIO Joel DeSpain   21     11  2016     6   \n",
       "\n",
       "            Lat        Long  \n",
       "0     43.079849  -89.377004  \n",
       "1     33.745647 -117.849324  \n",
       "2     43.039938  -89.503098  \n",
       "3     43.033631  -89.446744  \n",
       "4     43.072397  -89.382550  \n",
       "...         ...         ...  \n",
       "9995  43.122347  -89.330385  \n",
       "9996  43.094318  -89.364199  \n",
       "9997  43.103635  -89.341810  \n",
       "9998  43.072040  -89.397469  \n",
       "9999  43.100831  -89.348909  \n",
       "\n",
       "[10000 rows x 15 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new = pd.read_csv('geo_df.csv')\n",
    "data_new[:10000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "92a46254",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(10000,13000):\n",
    "    \n",
    "    address = data_new['Address'][i]\n",
    "    \n",
    "    data_new['Lat'][i] = get_lat_long(address)[0]\n",
    "    data_new['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "70af0cf1",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_new.to_csv('geo_df.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "f4d8fd4e",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>43.079849</td>\n",
       "      <td>-89.377004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "      <td>33.745647</td>\n",
       "      <td>-117.849324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "      <td>43.039938</td>\n",
       "      <td>-89.503098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "      <td>43.033631</td>\n",
       "      <td>-89.446744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</td>\n",
       "      <td>43.072397</td>\n",
       "      <td>-89.382550</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12995</th>\n",
       "      <td>25473</td>\n",
       "      <td>Theft</td>\n",
       "      <td>2020-146504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wintergreen Drive, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A Wintergreen Dr. resident used a smart key to...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>22</td>\n",
       "      <td>4</td>\n",
       "      <td>2020</td>\n",
       "      <td>11</td>\n",
       "      <td>43.107221</td>\n",
       "      <td>-89.294424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12996</th>\n",
       "      <td>25474</td>\n",
       "      <td>Traffic Incident</td>\n",
       "      <td>2020-146582</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E. Gorham St., Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A MPD officer was using a laser to monitor inb...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>22</td>\n",
       "      <td>4</td>\n",
       "      <td>2020</td>\n",
       "      <td>13</td>\n",
       "      <td>43.083863</td>\n",
       "      <td>-89.378840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12997</th>\n",
       "      <td>25475</td>\n",
       "      <td>Theft</td>\n",
       "      <td>2020-901623</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1117 N. Sherman Ave., Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MPD crime analysts have detected similarities ...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>22</td>\n",
       "      <td>4</td>\n",
       "      <td>2020</td>\n",
       "      <td>16</td>\n",
       "      <td>43.112317</td>\n",
       "      <td>-89.363072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12998</th>\n",
       "      <td>25476</td>\n",
       "      <td>Weapons Violation</td>\n",
       "      <td>2020-147888</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1000 block North Sherman Ave., Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&amp;nbsp;MPD’s Violent Crime Unit, along with Nor...</td>\n",
       "      <td>PIO Joel DeSpain</td>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>2020</td>\n",
       "      <td>17</td>\n",
       "      <td>43.110792</td>\n",
       "      <td>-89.364212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12999</th>\n",
       "      <td>25477</td>\n",
       "      <td>Weapons Violation</td>\n",
       "      <td>2020-148543</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S. Ingersoll St at Jenifer St, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Multiple callers called 911 to report shots fi...</td>\n",
       "      <td>Sgt. Joseph Engler</td>\n",
       "      <td>24</td>\n",
       "      <td>4</td>\n",
       "      <td>2020</td>\n",
       "      <td>4</td>\n",
       "      <td>43.081358</td>\n",
       "      <td>-89.365250</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13000 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       IncidentID                                     IncidentType  \\\n",
       "0            7400  Assist Outside Agency                             \n",
       "1            7401  Arrested Person                                   \n",
       "2            7402  Arrested Person                                   \n",
       "3            7403  Arrested Person                                   \n",
       "4            7404  Information                                       \n",
       "...           ...                                              ...   \n",
       "12995       25473                                            Theft   \n",
       "12996       25474                                 Traffic Incident   \n",
       "12997       25475                                            Theft   \n",
       "12998       25476                                Weapons Violation   \n",
       "12999       25477                                Weapons Violation   \n",
       "\n",
       "                                              CaseNumber Suspect  \\\n",
       "0      2005-13680                                    ...     NaN   \n",
       "1      2005-22647                                    ...     NaN   \n",
       "2      2005-22345                                    ...     NaN   \n",
       "3      2005-22688                                    ...     NaN   \n",
       "4      2005-999999                                   ...     NaN   \n",
       "...                                                  ...     ...   \n",
       "12995                                        2020-146504     NaN   \n",
       "12996                                        2020-146582     NaN   \n",
       "12997                                        2020-901623     NaN   \n",
       "12998                                        2020-147888     NaN   \n",
       "12999                                        2020-148543     NaN   \n",
       "\n",
       "                                                Arrested  \\\n",
       "0                                                    ...   \n",
       "1      Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2      Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3      Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "12995                                                NaN   \n",
       "12996                                                NaN   \n",
       "12997                                                NaN   \n",
       "12998                                                NaN   \n",
       "12999                                                NaN   \n",
       "\n",
       "                                                 Address  \\\n",
       "0      700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1        First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                   8 New Berm Court, Madison, Wisconsin   \n",
       "3                     4300 Lumley Rd, Madison, Wisconsin   \n",
       "4              211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                  ...   \n",
       "12995              Wintergreen Drive, Madison, Wisconsin   \n",
       "12996                  E. Gorham St., Madison, Wisconsin   \n",
       "12997           1117 N. Sherman Ave., Madison, Wisconsin   \n",
       "12998  1000 block North Sherman Ave., Madison, Wisconsin   \n",
       "12999  S. Ingersoll St at Jenifer St, Madison, Wisconsin   \n",
       "\n",
       "                                                  Victim  \\\n",
       "0                                                    ...   \n",
       "1      n/a                                           ...   \n",
       "2      Home Depot                                    ...   \n",
       "3      Adult male resident of Madison                ...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "12995                                                NaN   \n",
       "12996                                                NaN   \n",
       "12997                                                NaN   \n",
       "12998                                                NaN   \n",
       "12999                                                NaN   \n",
       "\n",
       "                                                 Details  \\\n",
       "0      On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1      At approximately 11:42 pm, an officer noted a ...   \n",
       "2      On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3      At approximately 7:30 am this date, Officers r...   \n",
       "4      DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                  ...   \n",
       "12995  A Wintergreen Dr. resident used a smart key to...   \n",
       "12996  A MPD officer was using a laser to monitor inb...   \n",
       "12997  MPD crime analysts have detected similarities ...   \n",
       "12998  &nbsp;MPD’s Violent Crime Unit, along with Nor...   \n",
       "12999  Multiple callers called 911 to report shots fi...   \n",
       "\n",
       "                                     ReleasedBy  Day  Month  Year  Hour  \\\n",
       "0      Mike Hanson                                 7     10  2005     4   \n",
       "1      Lt Pat Malloy                               3      3  2005     6   \n",
       "2      Lt. T. Peterson                             2      3  2005    15   \n",
       "3      Lt. Pat Malloy                              3      3  2005    14   \n",
       "4      Lieutenant Joe Balles                       4      3  2005    20   \n",
       "...                                         ...  ...    ...   ...   ...   \n",
       "12995                          PIO Joel DeSpain   22      4  2020    11   \n",
       "12996                          PIO Joel DeSpain   22      4  2020    13   \n",
       "12997                          PIO Joel DeSpain   22      4  2020    16   \n",
       "12998                          PIO Joel DeSpain   23      4  2020    17   \n",
       "12999                        Sgt. Joseph Engler   24      4  2020     4   \n",
       "\n",
       "             Lat        Long  \n",
       "0      43.079849  -89.377004  \n",
       "1      33.745647 -117.849324  \n",
       "2      43.039938  -89.503098  \n",
       "3      43.033631  -89.446744  \n",
       "4      43.072397  -89.382550  \n",
       "...          ...         ...  \n",
       "12995  43.107221  -89.294424  \n",
       "12996  43.083863  -89.378840  \n",
       "12997  43.112317  -89.363072  \n",
       "12998  43.110792  -89.364212  \n",
       "12999  43.081358  -89.365250  \n",
       "\n",
       "[13000 rows x 15 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new = pd.read_csv('geo_df.csv')\n",
    "data_new[:13000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "f3c50754",
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "14136",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/indexes/range.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m    350\u001b[0m                 \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 351\u001b[0;31m                     \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_range\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnew_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    352\u001b[0m                 \u001b[0;32mexcept\u001b[0m \u001b[0mValueError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: 14136 is not in range",
      "\nThe above exception was the direct cause of the following exception:\n",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-60-aae268b3bd88>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m13000\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mdata_new\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mshape\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m     \u001b[0maddress\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdata_new\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Address'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      4\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m     \u001b[0mdata_new\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Lat'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mget_lat_long\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0maddress\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/series.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m    851\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    852\u001b[0m         \u001b[0;32melif\u001b[0m \u001b[0mkey_is_scalar\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 853\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_value\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    854\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    855\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mis_hashable\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/series.py\u001b[0m in \u001b[0;36m_get_value\u001b[0;34m(self, label, takeable)\u001b[0m\n\u001b[1;32m    959\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    960\u001b[0m         \u001b[0;31m# Similar to Index.get_value, but we do not fall back to positional\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 961\u001b[0;31m         \u001b[0mloc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlabel\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    962\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_values_for_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mloc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlabel\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    963\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/indexes/range.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m    351\u001b[0m                     \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_range\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnew_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    352\u001b[0m                 \u001b[0;32mexcept\u001b[0m \u001b[0mValueError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 353\u001b[0;31m                     \u001b[0;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    354\u001b[0m             \u001b[0;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    355\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0msuper\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtolerance\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mtolerance\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 14136"
     ]
    }
   ],
   "source": [
    "for i in range(13000,data_new.shape[0]+1):\n",
    "    \n",
    "    address = data_new['Address'][i]\n",
    "    \n",
    "    data_new['Lat'][i] = get_lat_long(address)[0]\n",
    "    data_new['Long'][i] = get_lat_long(address)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "9397c25b",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_new.to_csv('geo_df.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "2cfc9b4a",
   "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>IncidentID</th>\n",
       "      <th>IncidentType</th>\n",
       "      <th>CaseNumber</th>\n",
       "      <th>Suspect</th>\n",
       "      <th>Arrested</th>\n",
       "      <th>Address</th>\n",
       "      <th>Victim</th>\n",
       "      <th>Details</th>\n",
       "      <th>ReleasedBy</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7400</td>\n",
       "      <td>Assist Outside Agency</td>\n",
       "      <td>2005-13680                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>700 Block of E. Washington Ave., Madison, Wisc...</td>\n",
       "      <td>...</td>\n",
       "      <td>On 2/6/05 at approximately 10:33 p.m. Officer ...</td>\n",
       "      <td>Mike Hanson</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>43.079849</td>\n",
       "      <td>-89.377004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7401</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22647                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tony R Markovitch, 20 years old, 301 Knutson D...</td>\n",
       "      <td>First St &amp; E Washington Ave, Madison, Wisconsin</td>\n",
       "      <td>n/a                                           ...</td>\n",
       "      <td>At approximately 11:42 pm, an officer noted a ...</td>\n",
       "      <td>Lt Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>6</td>\n",
       "      <td>33.745647</td>\n",
       "      <td>-117.849324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7402</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22345                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...</td>\n",
       "      <td>8 New Berm Court, Madison, Wisconsin</td>\n",
       "      <td>Home Depot                                    ...</td>\n",
       "      <td>On 03/02/2005 at approximately 8:15 am, the Ma...</td>\n",
       "      <td>Lt. T. Peterson</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>15</td>\n",
       "      <td>43.039938</td>\n",
       "      <td>-89.503098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7403</td>\n",
       "      <td>Arrested Person</td>\n",
       "      <td>2005-22688                                    ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...</td>\n",
       "      <td>4300 Lumley Rd, Madison, Wisconsin</td>\n",
       "      <td>Adult male resident of Madison                ...</td>\n",
       "      <td>At approximately 7:30 am this date, Officers r...</td>\n",
       "      <td>Lt. Pat Malloy</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>14</td>\n",
       "      <td>43.033631</td>\n",
       "      <td>-89.446744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7404</td>\n",
       "      <td>Information</td>\n",
       "      <td>2005-999999                                   ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>211 S. Carroll Street, Madison, Wisconsin</td>\n",
       "      <td>...</td>\n",
       "      <td>DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...</td>\n",
       "      <td>Lieutenant Joe Balles</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2005</td>\n",
       "      <td>20</td>\n",
       "      <td>43.072397</td>\n",
       "      <td>-89.382550</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14131</th>\n",
       "      <td>28608</td>\n",
       "      <td>Robbery</td>\n",
       "      <td>2021-410423</td>\n",
       "      <td>Male described as 6 feet tall, slender, with a...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3700 Frosted Leaf Dr, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police officers were dispatched to the...</td>\n",
       "      <td>Lt. Michael Richardson</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>7</td>\n",
       "      <td>43.004556</td>\n",
       "      <td>-89.507324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14132</th>\n",
       "      <td>28609</td>\n",
       "      <td>Attempted Homicide</td>\n",
       "      <td>2021-407981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tokiee D. Sole</td>\n",
       "      <td>5800 block Balsam Rd, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On 10/10/2021 at approximately 3:50 a.m., Madi...</td>\n",
       "      <td>P.O. Hunter Lisko</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "      <td>43.031092</td>\n",
       "      <td>-89.480088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14133</th>\n",
       "      <td>28610</td>\n",
       "      <td>Information</td>\n",
       "      <td>2021-411747</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Esker Trl/Lilyview Ln, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On October 12th, 2021 at approximately 6:43 PM...</td>\n",
       "      <td>PIO Julie Laundrie</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>24</td>\n",
       "      <td>43.023937</td>\n",
       "      <td>-89.518707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14134</th>\n",
       "      <td>28611</td>\n",
       "      <td>Fight (In Progress)</td>\n",
       "      <td>2021-412832</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aaron Mixon, 24-year-old\\r\\n\\r\\nNathan Dougher...</td>\n",
       "      <td>200 N First St, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Madison Police Officers responded to 200 N Fir...</td>\n",
       "      <td>P.O. Ryan Kimberley</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>22</td>\n",
       "      <td>43.093419</td>\n",
       "      <td>-89.361963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14135</th>\n",
       "      <td>28612</td>\n",
       "      <td>Information</td>\n",
       "      <td>0000-000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1710 Mckenna Blvd, Madison, Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Madison Police Department’s West District ...</td>\n",
       "      <td>P.O. Ryan Kimberley</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>43.033647</td>\n",
       "      <td>-89.497620</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14136 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       IncidentID                                     IncidentType  \\\n",
       "0            7400  Assist Outside Agency                             \n",
       "1            7401  Arrested Person                                   \n",
       "2            7402  Arrested Person                                   \n",
       "3            7403  Arrested Person                                   \n",
       "4            7404  Information                                       \n",
       "...           ...                                              ...   \n",
       "14131       28608                                          Robbery   \n",
       "14132       28609                               Attempted Homicide   \n",
       "14133       28610                                      Information   \n",
       "14134       28611                              Fight (In Progress)   \n",
       "14135       28612                                      Information   \n",
       "\n",
       "                                              CaseNumber  \\\n",
       "0      2005-13680                                    ...   \n",
       "1      2005-22647                                    ...   \n",
       "2      2005-22345                                    ...   \n",
       "3      2005-22688                                    ...   \n",
       "4      2005-999999                                   ...   \n",
       "...                                                  ...   \n",
       "14131                                        2021-410423   \n",
       "14132                                        2021-407981   \n",
       "14133                                        2021-411747   \n",
       "14134                                        2021-412832   \n",
       "14135                                        0000-000000   \n",
       "\n",
       "                                                 Suspect  \\\n",
       "0                                                    NaN   \n",
       "1                                                    NaN   \n",
       "2                                                    NaN   \n",
       "3                                                    NaN   \n",
       "4                                                    NaN   \n",
       "...                                                  ...   \n",
       "14131  Male described as 6 feet tall, slender, with a...   \n",
       "14132                                                NaN   \n",
       "14133                                                NaN   \n",
       "14134                                                NaN   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                Arrested  \\\n",
       "0                                                    ...   \n",
       "1      Tony R Markovitch, 20 years old, 301 Knutson D...   \n",
       "2      Martell D. Britton m/b 05-03-85\\r\\r\\nCharge:  ...   \n",
       "3      Twainesse L Peavy, 26 yrs old, 2317 Fish Hatch...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "14131                                                NaN   \n",
       "14132                                     Tokiee D. Sole   \n",
       "14133                                                NaN   \n",
       "14134  Aaron Mixon, 24-year-old\\r\\n\\r\\nNathan Dougher...   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                 Address  \\\n",
       "0      700 Block of E. Washington Ave., Madison, Wisc...   \n",
       "1        First St & E Washington Ave, Madison, Wisconsin   \n",
       "2                   8 New Berm Court, Madison, Wisconsin   \n",
       "3                     4300 Lumley Rd, Madison, Wisconsin   \n",
       "4              211 S. Carroll Street, Madison, Wisconsin   \n",
       "...                                                  ...   \n",
       "14131           3700 Frosted Leaf Dr, Madison, Wisconsin   \n",
       "14132           5800 block Balsam Rd, Madison, Wisconsin   \n",
       "14133          Esker Trl/Lilyview Ln, Madison, Wisconsin   \n",
       "14134                 200 N First St, Madison, Wisconsin   \n",
       "14135              1710 Mckenna Blvd, Madison, Wisconsin   \n",
       "\n",
       "                                                  Victim  \\\n",
       "0                                                    ...   \n",
       "1      n/a                                           ...   \n",
       "2      Home Depot                                    ...   \n",
       "3      Adult male resident of Madison                ...   \n",
       "4                                                    ...   \n",
       "...                                                  ...   \n",
       "14131                                                NaN   \n",
       "14132                                                NaN   \n",
       "14133                                                NaN   \n",
       "14134                                                NaN   \n",
       "14135                                                NaN   \n",
       "\n",
       "                                                 Details  \\\n",
       "0      On 2/6/05 at approximately 10:33 p.m. Officer ...   \n",
       "1      At approximately 11:42 pm, an officer noted a ...   \n",
       "2      On 03/02/2005 at approximately 8:15 am, the Ma...   \n",
       "3      At approximately 7:30 am this date, Officers r...   \n",
       "4      DELIVERY NOTICES FOR UNPAID PARKING TICKETS\\r\\...   \n",
       "...                                                  ...   \n",
       "14131  Madison Police officers were dispatched to the...   \n",
       "14132  On 10/10/2021 at approximately 3:50 a.m., Madi...   \n",
       "14133  On October 12th, 2021 at approximately 6:43 PM...   \n",
       "14134  Madison Police Officers responded to 200 N Fir...   \n",
       "14135  The Madison Police Department’s West District ...   \n",
       "\n",
       "                                     ReleasedBy  Day  Month  Year  Hour  \\\n",
       "0      Mike Hanson                                 7     10  2005     4   \n",
       "1      Lt Pat Malloy                               3      3  2005     6   \n",
       "2      Lt. T. Peterson                             2      3  2005    15   \n",
       "3      Lt. Pat Malloy                              3      3  2005    14   \n",
       "4      Lieutenant Joe Balles                       4      3  2005    20   \n",
       "...                                         ...  ...    ...   ...   ...   \n",
       "14131                    Lt. Michael Richardson   12     10  2021     7   \n",
       "14132                         P.O. Hunter Lisko   10     10  2021     9   \n",
       "14133                        PIO Julie Laundrie   12     10  2021    24   \n",
       "14134                       P.O. Ryan Kimberley   13     10  2021    22   \n",
       "14135                       P.O. Ryan Kimberley   14     10  2021     5   \n",
       "\n",
       "             Lat        Long  \n",
       "0      43.079849  -89.377004  \n",
       "1      33.745647 -117.849324  \n",
       "2      43.039938  -89.503098  \n",
       "3      43.033631  -89.446744  \n",
       "4      43.072397  -89.382550  \n",
       "...          ...         ...  \n",
       "14131  43.004556  -89.507324  \n",
       "14132  43.031092  -89.480088  \n",
       "14133  43.023937  -89.518707  \n",
       "14134  43.093419  -89.361963  \n",
       "14135  43.033647  -89.497620  \n",
       "\n",
       "[14136 rows x 15 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new = pd.read_csv('geo_df.csv')\n",
    "data_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b043c74a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}