task1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##Get started with Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data= pd.read_csv(\"/data/dssg/stumptown/data/Building_Violations_sample_50000.csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>ID</th>\n",
       "      <th>VIOLATION LAST MODIFIED DATE</th>\n",
       "      <th>VIOLATION DATE</th>\n",
       "      <th>VIOLATION CODE</th>\n",
       "      <th>VIOLATION STATUS</th>\n",
       "      <th>VIOLATION STATUS DATE</th>\n",
       "      <th>VIOLATION DESCRIPTION</th>\n",
       "      <th>VIOLATION LOCATION</th>\n",
       "      <th>VIOLATION INSPECTOR COMMENTS</th>\n",
       "      <th>...</th>\n",
       "      <th>INSPECTION STATUS</th>\n",
       "      <th>INSPECTION WAIVED</th>\n",
       "      <th>INSPECTION CATEGORY</th>\n",
       "      <th>DEPARTMENT BUREAU</th>\n",
       "      <th>ADDRESS</th>\n",
       "      <th>PROPERTY GROUP</th>\n",
       "      <th>SSA</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>LOCATION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>5063843</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN065014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR LINTELS</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>LINTELS; RUSTED.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>722 E 89TH ST</td>\n",
       "      <td>461523</td>\n",
       "      <td>51</td>\n",
       "      <td>41.733089</td>\n",
       "      <td>-87.606184</td>\n",
       "      <td>(41.73308939713441,-87.60618433527188)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>5063990</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN044013</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PIPE OPENING W/NONCOMBUST MATL</td>\n",
       "      <td>OTHER   :    :MULTIPLE FLOORS</td>\n",
       "      <td>OPENINGS AROUND PIPES, SEAL WITH APPROVED MATE...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>6444 S DR MARTIN L KING JR DR</td>\n",
       "      <td>19575</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.777088</td>\n",
       "      <td>-87.615694</td>\n",
       "      <td>(41.77708792596553,-87.61569442972947)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>5064022</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN104035</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MAINTAIN WINDOW</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>ALL ELEVATIONS , WOOD WINDOW FRAMES  AND NORTH...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>3115 N SAWYER AVE</td>\n",
       "      <td>117375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.937995</td>\n",
       "      <td>-87.708657</td>\n",
       "      <td>(41.93799454179893,-87.70865671096144)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0       ID VIOLATION LAST MODIFIED DATE VIOLATION DATE  \\\n",
       "0           0  5063843                   05/21/2015     05/21/2015   \n",
       "1           1  5063990                   05/21/2015     05/21/2015   \n",
       "2           2  5064022                   05/21/2015     05/21/2015   \n",
       "\n",
       "  VIOLATION CODE VIOLATION STATUS VIOLATION STATUS DATE  \\\n",
       "0       CN065014             OPEN                   NaN   \n",
       "1       CN044013             OPEN                   NaN   \n",
       "2       CN104035             OPEN                   NaN   \n",
       "\n",
       "            VIOLATION DESCRIPTION             VIOLATION LOCATION  \\\n",
       "0                  REPAIR LINTELS                 OTHER   :    :   \n",
       "1  PIPE OPENING W/NONCOMBUST MATL  OTHER   :    :MULTIPLE FLOORS   \n",
       "2                 MAINTAIN WINDOW                 OTHER   :    :   \n",
       "\n",
       "                        VIOLATION INSPECTOR COMMENTS  \\\n",
       "0                                   LINTELS; RUSTED.   \n",
       "1  OPENINGS AROUND PIPES, SEAL WITH APPROVED MATE...   \n",
       "2  ALL ELEVATIONS , WOOD WINDOW FRAMES  AND NORTH...   \n",
       "\n",
       "                    ...                   INSPECTION STATUS INSPECTION WAIVED  \\\n",
       "0                   ...                              FAILED                 N   \n",
       "1                   ...                              FAILED                 N   \n",
       "2                   ...                              FAILED                 N   \n",
       "\n",
       "   INSPECTION CATEGORY DEPARTMENT BUREAU                        ADDRESS  \\\n",
       "0            COMPLAINT      CONSERVATION                  722 E 89TH ST   \n",
       "1             PERIODIC      CONSERVATION  6444 S DR MARTIN L KING JR DR   \n",
       "2            COMPLAINT      CONSERVATION              3115 N SAWYER AVE   \n",
       "\n",
       "  PROPERTY GROUP  SSA   LATITUDE  LONGITUDE  \\\n",
       "0         461523   51  41.733089 -87.606184   \n",
       "1          19575  NaN  41.777088 -87.615694   \n",
       "2         117375  NaN  41.937995 -87.708657   \n",
       "\n",
       "                                 LOCATION  \n",
       "0  (41.73308939713441,-87.60618433527188)  \n",
       "1  (41.77708792596553,-87.61569442972947)  \n",
       "2  (41.93799454179893,-87.70865671096144)  \n",
       "\n",
       "[3 rows x 23 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>ID</th>\n",
       "      <th>VIOLATION LAST MODIFIED DATE</th>\n",
       "      <th>VIOLATION DATE</th>\n",
       "      <th>VIOLATION CODE</th>\n",
       "      <th>VIOLATION STATUS</th>\n",
       "      <th>VIOLATION STATUS DATE</th>\n",
       "      <th>VIOLATION DESCRIPTION</th>\n",
       "      <th>VIOLATION LOCATION</th>\n",
       "      <th>VIOLATION INSPECTOR COMMENTS</th>\n",
       "      <th>...</th>\n",
       "      <th>INSPECTION STATUS</th>\n",
       "      <th>INSPECTION WAIVED</th>\n",
       "      <th>INSPECTION CATEGORY</th>\n",
       "      <th>DEPARTMENT BUREAU</th>\n",
       "      <th>ADDRESS</th>\n",
       "      <th>PROPERTY GROUP</th>\n",
       "      <th>SSA</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>LOCATION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>49997</th>\n",
       "      <td>49997</td>\n",
       "      <td>1430847</td>\n",
       "      <td>10/14/2008</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN031013</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>07/10/2008</td>\n",
       "      <td>FIRE EXTNGSHR REQ, RESDNTL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALL ELEVATION MISSING FIRE EXTINGUISHER</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>6501 S LOWE AVE</td>\n",
       "      <td>19693</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.776074</td>\n",
       "      <td>-87.640625</td>\n",
       "      <td>(41.7760739361563,-87.64062455203374)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49998</th>\n",
       "      <td>49998</td>\n",
       "      <td>1734149</td>\n",
       "      <td>09/16/2008</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN135016</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>09/05/2008</td>\n",
       "      <td>MICE/RODENTS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MICE ON PREMISES</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>4836 S INDIANA AVE</td>\n",
       "      <td>18261</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.806381</td>\n",
       "      <td>-87.621283</td>\n",
       "      <td>(41.80638088214982,-87.62128295874425)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49999</th>\n",
       "      <td>49999</td>\n",
       "      <td>1834762</td>\n",
       "      <td>01/12/2007</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN190019</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>01/11/2007</td>\n",
       "      <td>ARRANGE PREMISE INSPECTION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NO ENTRY TO INTERIOR TO VERIFY OCCUPANCY AND D...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>200 N KOSTNER AVE</td>\n",
       "      <td>1531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.883310</td>\n",
       "      <td>-87.735709</td>\n",
       "      <td>(41.88330951242491,-87.73570901056128)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0       ID VIOLATION LAST MODIFIED DATE VIOLATION DATE  \\\n",
       "49997       49997  1430847                   10/14/2008     01/01/2006   \n",
       "49998       49998  1734149                   09/16/2008     01/01/2006   \n",
       "49999       49999  1834762                   01/12/2007     01/01/2006   \n",
       "\n",
       "      VIOLATION CODE VIOLATION STATUS VIOLATION STATUS DATE  \\\n",
       "49997       CN031013         COMPLIED            07/10/2008   \n",
       "49998       CN135016         COMPLIED            09/05/2008   \n",
       "49999       CN190019         COMPLIED            01/11/2007   \n",
       "\n",
       "            VIOLATION DESCRIPTION VIOLATION LOCATION  \\\n",
       "49997  FIRE EXTNGSHR REQ, RESDNTL                NaN   \n",
       "49998                MICE/RODENTS                NaN   \n",
       "49999  ARRANGE PREMISE INSPECTION                NaN   \n",
       "\n",
       "                            VIOLATION INSPECTOR COMMENTS  \\\n",
       "49997            ALL ELEVATION MISSING FIRE EXTINGUISHER   \n",
       "49998                                   MICE ON PREMISES   \n",
       "49999  NO ENTRY TO INTERIOR TO VERIFY OCCUPANCY AND D...   \n",
       "\n",
       "                        ...                   INSPECTION STATUS  \\\n",
       "49997                   ...                              FAILED   \n",
       "49998                   ...                              FAILED   \n",
       "49999                   ...                              FAILED   \n",
       "\n",
       "      INSPECTION WAIVED  INSPECTION CATEGORY DEPARTMENT BUREAU  \\\n",
       "49997                 N             PERIODIC      CONSERVATION   \n",
       "49998                 N             PERIODIC      CONSERVATION   \n",
       "49999                 N             PERIODIC      CONSERVATION   \n",
       "\n",
       "                  ADDRESS PROPERTY GROUP  SSA   LATITUDE  LONGITUDE  \\\n",
       "49997     6501 S LOWE AVE          19693  NaN  41.776074 -87.640625   \n",
       "49998  4836 S INDIANA AVE          18261  NaN  41.806381 -87.621283   \n",
       "49999   200 N KOSTNER AVE           1531  NaN  41.883310 -87.735709   \n",
       "\n",
       "                                     LOCATION  \n",
       "49997   (41.7760739361563,-87.64062455203374)  \n",
       "49998  (41.80638088214982,-87.62128295874425)  \n",
       "49999  (41.88330951242491,-87.73570901056128)  \n",
       "\n",
       "[3 rows x 23 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail(3)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Unnamed: 0                        int64\n",
       "ID                                int64\n",
       "VIOLATION LAST MODIFIED DATE     object\n",
       "VIOLATION DATE                   object\n",
       "VIOLATION CODE                   object\n",
       "VIOLATION STATUS                 object\n",
       "VIOLATION STATUS DATE            object\n",
       "VIOLATION DESCRIPTION            object\n",
       "VIOLATION LOCATION               object\n",
       "VIOLATION INSPECTOR COMMENTS     object\n",
       "VIOLATION ORDINANCE              object\n",
       "INSPECTOR ID                     object\n",
       "INSPECTION NUMBER                 int64\n",
       "INSPECTION STATUS                object\n",
       "INSPECTION WAIVED                object\n",
       "INSPECTION CATEGORY              object\n",
       "DEPARTMENT BUREAU                object\n",
       "ADDRESS                          object\n",
       "PROPERTY GROUP                    int64\n",
       "SSA                              object\n",
       "LATITUDE                        float64\n",
       "LONGITUDE                       float64\n",
       "LOCATION                         object\n",
       "dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import re\n",
    "\n",
    "def space_to_snake(column_name):\n",
    "    \"\"\"Replace space with underscore \"\"\"\n",
    "    tmp = re.sub(r\"\\s+\",'_',column_name)\n",
    "    return tmp.lower()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'Unnamed: 0', u'ID', u'VIOLATION LAST MODIFIED DATE', u'VIOLATION DATE', u'VIOLATION CODE', u'VIOLATION STATUS', u'VIOLATION STATUS DATE', u'VIOLATION DESCRIPTION', u'VIOLATION LOCATION', u'VIOLATION INSPECTOR COMMENTS', u'VIOLATION ORDINANCE', u'INSPECTOR ID', u'INSPECTION NUMBER', u'INSPECTION STATUS', u'INSPECTION WAIVED', u'INSPECTION CATEGORY', u'DEPARTMENT BUREAU', u'ADDRESS', u'PROPERTY GROUP', u'SSA', u'LATITUDE', u'LONGITUDE', u'LOCATION'], dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "tmp = []\n",
    "for col in data.columns:\n",
    "    tmp.append(space_to_snake(col))\n",
    "data.columns=tmp\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'unnamed:_0', u'id', u'violation_last_modified_date', u'violation_date', u'violation_code', u'violation_status', u'violation_status_date', u'violation_description', u'violation_location', u'violation_inspector_comments', u'violation_ordinance', u'inspector_id', u'inspection_number', u'inspection_status', u'inspection_waived', u'inspection_category', u'department_bureau', u'address', u'property_group', u'ssa', u'latitude', u'longitude', u'location'], dtype='object')"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    44705\n",
       "True      5295\n",
       "dtype: int64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.value_counts(data.violation_inspector_comments.isnull())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "unnamed:_0\n",
      "False    50000\n",
      "dtype: int64\n",
      "id\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_last_modified_date\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_date\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_code\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_status\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_status_date\n",
      "True     36488\n",
      "False    13512\n",
      "dtype: int64\n",
      "violation_description\n",
      "False    49624\n",
      "True       376\n",
      "dtype: int64\n",
      "violation_location\n",
      "True     32484\n",
      "False    17516\n",
      "dtype: int64\n",
      "violation_inspector_comments\n",
      "False    44705\n",
      "True      5295\n",
      "dtype: int64\n",
      "violation_ordinance\n",
      "False    48462\n",
      "True      1538\n",
      "dtype: int64\n",
      "inspector_id\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_number\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_status\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_waived\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_category\n",
      "False    50000\n",
      "dtype: int64\n",
      "department_bureau\n",
      "False    50000\n",
      "dtype: int64\n",
      "address\n",
      "False    50000\n",
      "dtype: int64\n",
      "property_group\n",
      "False    50000\n",
      "dtype: int64\n",
      "ssa\n",
      "True     40639\n",
      "False     9361\n",
      "dtype: int64\n",
      "latitude\n",
      "False    49952\n",
      "True        48\n",
      "dtype: int64\n",
      "longitude\n",
      "False    49952\n",
      "True        48\n",
      "dtype: int64\n",
      "location\n",
      "False    49952\n",
      "True        48\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "for col in data.columns:\n",
    "    print col\n",
    "    print pd.value_counts(data[col].isnull())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "data.violation_inspector_comments = data.violation_inspector_comments.fillna(\"No comment\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    50000\n",
       "dtype: int64"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.value_counts(data.violation_inspector_comments.isnull())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "unnamed:_0                        int64\n",
       "id                                int64\n",
       "violation_last_modified_date     object\n",
       "violation_date                   object\n",
       "violation_code                   object\n",
       "violation_status                 object\n",
       "violation_status_date            object\n",
       "violation_description            object\n",
       "violation_location               object\n",
       "violation_inspector_comments     object\n",
       "violation_ordinance              object\n",
       "inspector_id                     object\n",
       "inspection_number                 int64\n",
       "inspection_status                object\n",
       "inspection_waived                object\n",
       "inspection_category              object\n",
       "department_bureau                object\n",
       "address                          object\n",
       "property_group                    int64\n",
       "ssa                              object\n",
       "latitude                        float64\n",
       "longitude                       float64\n",
       "location                         object\n",
       "dtype: object"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unnamed:_0</th>\n",
       "      <th>id</th>\n",
       "      <th>violation_last_modified_date</th>\n",
       "      <th>violation_date</th>\n",
       "      <th>violation_code</th>\n",
       "      <th>violation_status</th>\n",
       "      <th>violation_status_date</th>\n",
       "      <th>violation_description</th>\n",
       "      <th>violation_location</th>\n",
       "      <th>violation_inspector_comments</th>\n",
       "      <th>...</th>\n",
       "      <th>inspection_status</th>\n",
       "      <th>inspection_waived</th>\n",
       "      <th>inspection_category</th>\n",
       "      <th>department_bureau</th>\n",
       "      <th>address</th>\n",
       "      <th>property_group</th>\n",
       "      <th>ssa</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>5063843</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN065014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR LINTELS</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>LINTELS; RUSTED.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>722 E 89TH ST</td>\n",
       "      <td>461523</td>\n",
       "      <td>51</td>\n",
       "      <td>41.733089</td>\n",
       "      <td>-87.606184</td>\n",
       "      <td>(41.73308939713441,-87.60618433527188)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>5063990</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN044013</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PIPE OPENING W/NONCOMBUST MATL</td>\n",
       "      <td>OTHER   :    :MULTIPLE FLOORS</td>\n",
       "      <td>OPENINGS AROUND PIPES, SEAL WITH APPROVED MATE...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>6444 S DR MARTIN L KING JR DR</td>\n",
       "      <td>19575</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.777088</td>\n",
       "      <td>-87.615694</td>\n",
       "      <td>(41.77708792596553,-87.61569442972947)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>5064022</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN104035</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MAINTAIN WINDOW</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>ALL ELEVATIONS , WOOD WINDOW FRAMES  AND NORTH...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>3115 N SAWYER AVE</td>\n",
       "      <td>117375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.937995</td>\n",
       "      <td>-87.708657</td>\n",
       "      <td>(41.93799454179893,-87.70865671096144)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>5064019</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN196029</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POST OWNER/MANAGERS NAME/#</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>BUILDING - NO OWNER'S I.D. SIGN POSTED .</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>3115 N SAWYER AVE</td>\n",
       "      <td>117375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.937995</td>\n",
       "      <td>-87.708657</td>\n",
       "      <td>(41.93799454179893,-87.70865671096144)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5064139</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN104015</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPLCE WINDOW PANES, PLEXGLAS</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>NORTH ELEVATION / 1ST FLOOR - BROKEN WINDOW PANE.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>5649 S INDIANA AVE</td>\n",
       "      <td>344254</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.791470</td>\n",
       "      <td>-87.620616</td>\n",
       "      <td>(41.791469839262206,-87.62061589476306)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>5064153</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN190019</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARRANGE PREMISE INSPECTION</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>INTERIOR OF BUILDING, NO RESPONSE. UNABLE TO V...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>4445 S ST LOUIS AVE</td>\n",
       "      <td>26288</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.812187</td>\n",
       "      <td>-87.711151</td>\n",
       "      <td>(41.81218733369289,-87.71115060894742)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>5064141</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN015062</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OBSTRUCTIONS IN EXIT WAY</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>EAST ELEVATION / 5649 S. 2ND FLOOR SECONDARY E...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>5649 S INDIANA AVE</td>\n",
       "      <td>344254</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.791470</td>\n",
       "      <td>-87.620616</td>\n",
       "      <td>(41.791469839262206,-87.62061589476306)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>5064257</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN065034</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR WINDOW SILLS</td>\n",
       "      <td>EXTERIOR:W   :</td>\n",
       "      <td>WEST ELEVATION STONE SILLS HAVE WASHED OUT MOR...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>7049 S CARPENTER ST</td>\n",
       "      <td>396449</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.765487</td>\n",
       "      <td>-87.650339</td>\n",
       "      <td>(41.76548669063829,-87.65033946181353)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>5064728</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN196029</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POST OWNER/MANAGERS NAME/#</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>BUILDING - NO OWNER'S ID SIGN POSTED.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>4525 N KARLOV AVE</td>\n",
       "      <td>179641</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.963291</td>\n",
       "      <td>-87.730173</td>\n",
       "      <td>(41.96329131960269,-87.73017257884024)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>5064742</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN190019</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARRANGE PREMISE INSPECTION</td>\n",
       "      <td>OTHER   :    :BUILDING</td>\n",
       "      <td>UNABLE TO INSPECT INTERIOR, STAIRWELLS, BASEME...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>5852 N SHERIDAN RD</td>\n",
       "      <td>209269</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.988844</td>\n",
       "      <td>-87.655496</td>\n",
       "      <td>(41.98884444339461,-87.65549560741945)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>5064812</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN104065</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR WINDOW HARDWARE</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>WINDOWS DOESN'T LOCK, DAMAGE LOCK.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>4126 N KILBOURN AVE</td>\n",
       "      <td>168842</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.956154</td>\n",
       "      <td>-87.740752</td>\n",
       "      <td>(41.95615356844395,-87.74075173259708)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>5064815</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>CN063014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CHIMNEY</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>CHIMNEY WASHED OUT MORTAR.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>4126 N KILBOURN AVE</td>\n",
       "      <td>168842</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.956154</td>\n",
       "      <td>-87.740752</td>\n",
       "      <td>(41.95615356844395,-87.74075173259708)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>5063772</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN070024</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR PORCH SYSTEM</td>\n",
       "      <td>EXTERIOR:S   :</td>\n",
       "      <td>SOUTH ELEVATION VIEWED FROM BEHIND FENCE FRONT...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>2050 W JAMES ST</td>\n",
       "      <td>333262</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.799958</td>\n",
       "      <td>-87.676554</td>\n",
       "      <td>(41.799957885368265,-87.67655353910952)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>5063459</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN193019</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR/WRECK DANGER RESID PREM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No comment</td>\n",
       "      <td>...</td>\n",
       "      <td>CLOSED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>DEMOLITION</td>\n",
       "      <td>3051 S BROAD ST</td>\n",
       "      <td>285348</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.838454</td>\n",
       "      <td>-87.660979</td>\n",
       "      <td>(41.83845438362799,-87.6609787384341)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>5063763</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN041063</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CUT OR REMOVE HIGH WEEDS</td>\n",
       "      <td>EXTERIOR:W   :</td>\n",
       "      <td>WEST ELEVATION OVERGROWN GRASS/WEEDS.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>5435 S HERMITAGE AVE</td>\n",
       "      <td>332092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.794758</td>\n",
       "      <td>-87.668103</td>\n",
       "      <td>(41.79475771640361,-87.66810282975975)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>5063885</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>BR1001</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OWNER OR LICENSED CONTRACTOR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No comment</td>\n",
       "      <td>...</td>\n",
       "      <td>CLOSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>BOILER</td>\n",
       "      <td>6448 S TRIPP AVE</td>\n",
       "      <td>387870</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.775328</td>\n",
       "      <td>-87.728922</td>\n",
       "      <td>(41.775328312329904,-87.72892174006991)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>5063912</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>PL151137</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No comment</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERMIT</td>\n",
       "      <td>PLUMBING</td>\n",
       "      <td>3835 W CERMAK RD</td>\n",
       "      <td>280823</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.851485</td>\n",
       "      <td>-87.721159</td>\n",
       "      <td>(41.85148492680666,-87.72115941535648)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>5063146</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN074014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERVICE WALK, PASSAGE, AREAWAY</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>SERVICE WALK; BROKEN CONCRETE.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>7932 S DREXEL AVE</td>\n",
       "      <td>430670</td>\n",
       "      <td>51</td>\n",
       "      <td>41.750313</td>\n",
       "      <td>-87.602878</td>\n",
       "      <td>(41.750312646858305,-87.60287756666781)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>5063320</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN193019</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR/WRECK DANGER RESID PREM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No comment</td>\n",
       "      <td>...</td>\n",
       "      <td>CLOSED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>DEMOLITION</td>\n",
       "      <td>11025 S ESMOND ST</td>\n",
       "      <td>516079</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.693018</td>\n",
       "      <td>-87.667286</td>\n",
       "      <td>(41.69301757344688,-87.66728567428113)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>5064353</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN070014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR EXTERIOR STAIR</td>\n",
       "      <td>EXTERIOR:N   :</td>\n",
       "      <td>NORTH, SOUTH ELEVATIONS - HANDRAILS MISSING FR...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1437 W DEVON AVE</td>\n",
       "      <td>218603</td>\n",
       "      <td>26</td>\n",
       "      <td>41.998011</td>\n",
       "      <td>-87.666881</td>\n",
       "      <td>(41.99801090422057,-87.6668814940047)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>5064410</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN193039</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POST OWNER NAME OF VACNT BLDG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No comment</td>\n",
       "      <td>...</td>\n",
       "      <td>CLOSED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>DEMOLITION</td>\n",
       "      <td>6928 S KIMBARK AVE</td>\n",
       "      <td>393870</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.769012</td>\n",
       "      <td>-87.594164</td>\n",
       "      <td>(41.76901189738516,-87.59416364991507)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>5064489</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>05/20/2015</td>\n",
       "      <td>CN193039</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POST OWNER NAME OF VACNT BLDG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No comment</td>\n",
       "      <td>...</td>\n",
       "      <td>CLOSED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>DEMOLITION</td>\n",
       "      <td>6643 S RACINE AVE</td>\n",
       "      <td>380041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.772878</td>\n",
       "      <td>-87.654175</td>\n",
       "      <td>(41.77287780825002,-87.65417450839244)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>5063646</td>\n",
       "      <td>05/21/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>BR2080</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>INTERNAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>#1 KEWANEE BOILER.</td>\n",
       "      <td>...</td>\n",
       "      <td>CLOSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>BOILER</td>\n",
       "      <td>945 W 38TH ST</td>\n",
       "      <td>17749</td>\n",
       "      <td>13</td>\n",
       "      <td>41.825409</td>\n",
       "      <td>-87.649299</td>\n",
       "      <td>(41.82540859508953,-87.64929947480178)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>5062486</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>CN193039</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POST OWNER NAME OF VACNT BLDG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No comment</td>\n",
       "      <td>...</td>\n",
       "      <td>CLOSED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>DEMOLITION</td>\n",
       "      <td>12825 S HALSTED ST</td>\n",
       "      <td>543423</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.660625</td>\n",
       "      <td>-87.641187</td>\n",
       "      <td>(41.660624688616466,-87.64118684260401)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>5062605</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>CN111025</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EGRESS -BASEMENT</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>BASEMENT DWELLING UNIT - ONLY 1 EGRESS EXISTS ...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>2334 S SACRAMENTO AVE</td>\n",
       "      <td>278665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.848999</td>\n",
       "      <td>-87.700419</td>\n",
       "      <td>(41.848999312527,-87.7004187481119)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>5062606</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>CN110025</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EGRESS</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>ATTIC DWELLING UNIT - ONLY ONE EGRESS EXISTS (...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>2334 S SACRAMENTO AVE</td>\n",
       "      <td>278665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.848999</td>\n",
       "      <td>-87.700419</td>\n",
       "      <td>(41.848999312527,-87.7004187481119)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>5062634</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>CN104015</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPLCE WINDOW PANES, PLEXGLAS</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>FRONT 1ST AND 2ND FLOOR APTS/REAR BASEMENT, 1S...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>2848 N AVERS AVE</td>\n",
       "      <td>8632</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.933287</td>\n",
       "      <td>-87.723472</td>\n",
       "      <td>(41.93328738702544,-87.72347229888197)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>5062679</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>CN061014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR EXTERIOR WALL</td>\n",
       "      <td>OTHER   :    :EXTERIOR WALL</td>\n",
       "      <td>EXTERIOR WALL WASHED OUT MORTAR JOINTS.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>6042 S MICHIGAN AVE</td>\n",
       "      <td>19272</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.784308</td>\n",
       "      <td>-87.622343</td>\n",
       "      <td>(41.78430781539396,-87.62234288111321)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>5061236</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>CN105085</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PROVIDE DEADLOCK FOR ENTRANCE</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>FRONT EXTERIOR DOOR; NO LOCK.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>10955 S VERNON AVE</td>\n",
       "      <td>510739</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.694920</td>\n",
       "      <td>-87.612071</td>\n",
       "      <td>(41.69491981145228,-87.6120713247033)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>5062894</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>05/19/2015</td>\n",
       "      <td>CN076014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PROVIDE GUTTER &amp; DOWNSPOUT</td>\n",
       "      <td>OTHER   :    :</td>\n",
       "      <td>MISSING GUTTER AND DOWNSPOUT.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>COMPLAINT</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1732 N KEDVALE AVE</td>\n",
       "      <td>78139</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.912628</td>\n",
       "      <td>-87.730227</td>\n",
       "      <td>(41.91262815790136,-87.73022720869842)</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49970</th>\n",
       "      <td>49970</td>\n",
       "      <td>1298007</td>\n",
       "      <td>03/07/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>RF301041</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARRANGE FOR INSPECTION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CALL 312-746-8437 &amp; ASK FOR INSP#650.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>5025 N CLARK ST</td>\n",
       "      <td>185292</td>\n",
       "      <td>22</td>\n",
       "      <td>41.973325</td>\n",
       "      <td>-87.667922</td>\n",
       "      <td>(41.97332527471334,-87.66792167114302)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49971</th>\n",
       "      <td>49971</td>\n",
       "      <td>1341538</td>\n",
       "      <td>04/07/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN140016</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DWELLING CLEAN AND SANITARY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUNK AND GARBAGE REAR YARD UNSANITARY.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>2901 N MILWAUKEE AVE</td>\n",
       "      <td>8593</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.933982</td>\n",
       "      <td>-87.715226</td>\n",
       "      <td>(41.933981597337265,-87.71522641499614)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49972</th>\n",
       "      <td>49972</td>\n",
       "      <td>1424819</td>\n",
       "      <td>06/08/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN196029</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>02/17/2006</td>\n",
       "      <td>POST OWNER/MANAGERS NAME/#</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FRONT ELEVATION  OWNERS ID SIGN NOT POSTED</td>\n",
       "      <td>...</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1523 N CAMPBELL AVE</td>\n",
       "      <td>4945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.909184</td>\n",
       "      <td>-87.689502</td>\n",
       "      <td>(41.90918426175231,-87.68950208397905)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49973</th>\n",
       "      <td>49973</td>\n",
       "      <td>1275765</td>\n",
       "      <td>04/11/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN194039</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>01/11/2006</td>\n",
       "      <td>REMOVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FOR ONE 40-TON CARRIER LOCATED IN BASEMENT MEC...</td>\n",
       "      <td>...</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>6420 N CALIFORNIA AVE</td>\n",
       "      <td>13534</td>\n",
       "      <td>43</td>\n",
       "      <td>41.998216</td>\n",
       "      <td>-87.699814</td>\n",
       "      <td>(41.998216306323414,-87.69981364221285)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49974</th>\n",
       "      <td>49974</td>\n",
       "      <td>1377390</td>\n",
       "      <td>08/11/2008</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>NC5062</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>06/17/2008</td>\n",
       "      <td>HOLDOPEN DEVICE, STAIR 3+ FLRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALL STAIRWELL  DOORS BEING HELD OPEN WITH DOOR...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>810 E HYDE PARK BLVD</td>\n",
       "      <td>18419</td>\n",
       "      <td>47</td>\n",
       "      <td>41.802373</td>\n",
       "      <td>-87.605888</td>\n",
       "      <td>(41.80237347110972,-87.60588760843979)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49975</th>\n",
       "      <td>49975</td>\n",
       "      <td>1453130</td>\n",
       "      <td>06/26/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN077014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR FENCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REAR YARD AT NORTH-MISSING SECTIONS OF FENCING.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1236 S SAWYER AVE</td>\n",
       "      <td>15735</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.865237</td>\n",
       "      <td>-87.706999</td>\n",
       "      <td>(41.865237246904975,-87.70699853404217)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49976</th>\n",
       "      <td>49976</td>\n",
       "      <td>1285116</td>\n",
       "      <td>03/02/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>RF301031</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ACCESS TO ROOF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A/C UNIT LOCATED ON THE ROOF.            (SEC....</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>2401 W DEVON AVE</td>\n",
       "      <td>220380</td>\n",
       "      <td>43</td>\n",
       "      <td>41.997619</td>\n",
       "      <td>-87.689939</td>\n",
       "      <td>(41.997618688841094,-87.6899394819467)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49977</th>\n",
       "      <td>49977</td>\n",
       "      <td>4175176</td>\n",
       "      <td>05/15/2012</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>RF302041</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>05/16/2012</td>\n",
       "      <td>PRV HIGH SIDE</td>\n",
       "      <td>INSPECTION</td>\n",
       "      <td>(SEC. 18-28-1102.3, 18-28-1006.5, 18-28-1006.3...</td>\n",
       "      <td>...</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>6400 N ARTESIAN AVE</td>\n",
       "      <td>13500</td>\n",
       "      <td>43</td>\n",
       "      <td>41.997798</td>\n",
       "      <td>-87.691254</td>\n",
       "      <td>(41.99779781875053,-87.69125427479676)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49978</th>\n",
       "      <td>49978</td>\n",
       "      <td>1275519</td>\n",
       "      <td>02/23/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>RF302021</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRV RECEIVER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(SEC. 18-28-1006.3, 18-28-1107.7.1, 18-28-1102...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>2742 W DEVON AVE</td>\n",
       "      <td>230484</td>\n",
       "      <td>43</td>\n",
       "      <td>41.997682</td>\n",
       "      <td>-87.698913</td>\n",
       "      <td>(41.997682115657,-87.69891315910674)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49979</th>\n",
       "      <td>49979</td>\n",
       "      <td>1569712</td>\n",
       "      <td>08/13/2008</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>EL0029</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>05/21/2008</td>\n",
       "      <td>EXPOSED WIRING</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MISSING OUTLET COVER UNDER FRONT STAIRWAY.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>4844 W HENDERSON ST</td>\n",
       "      <td>9542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.941650</td>\n",
       "      <td>-87.748758</td>\n",
       "      <td>(41.941649698719495,-87.74875812489256)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49980</th>\n",
       "      <td>49980</td>\n",
       "      <td>1446021</td>\n",
       "      <td>05/03/2007</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN069014</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>04/11/2007</td>\n",
       "      <td>REPAIR DEFECTIVE FOUNDATION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FRACTURED FOUNDATION REAR PORCH AT GRADE 1439</td>\n",
       "      <td>...</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1433 W LUNT AVE</td>\n",
       "      <td>13658</td>\n",
       "      <td>24</td>\n",
       "      <td>42.008989</td>\n",
       "      <td>-87.667257</td>\n",
       "      <td>(42.00898884004581,-87.66725723420997)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49981</th>\n",
       "      <td>49981</td>\n",
       "      <td>1566701</td>\n",
       "      <td>03/31/2008</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN190019</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>01/14/2008</td>\n",
       "      <td>ARRANGE PREMISE INSPECTION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NO ENTRY TO INTERIOR.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1455 W FARGO AVE</td>\n",
       "      <td>239959</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.017019</td>\n",
       "      <td>-87.667582</td>\n",
       "      <td>(42.01701924785849,-87.66758179030381)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49982</th>\n",
       "      <td>49982</td>\n",
       "      <td>4263492</td>\n",
       "      <td>08/23/2012</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>RF301041</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARRANGE FOR INSPECTION</td>\n",
       "      <td>INSPECTION</td>\n",
       "      <td>CONTACT INSPECTORTRAVIS #655 312-746-8437.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>1217 W MORSE AVE</td>\n",
       "      <td>13683</td>\n",
       "      <td>24</td>\n",
       "      <td>42.007858</td>\n",
       "      <td>-87.662429</td>\n",
       "      <td>(42.00785750969186,-87.66242881817381)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49983</th>\n",
       "      <td>49983</td>\n",
       "      <td>1453137</td>\n",
       "      <td>06/26/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN074024</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PROVIDE GUARD RAIL 42 IN HIGH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WEST STAIRS TO BASEMENT-BROKEN GUARD RAILS/WEA...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1236 S SAWYER AVE</td>\n",
       "      <td>15735</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.865237</td>\n",
       "      <td>-87.706999</td>\n",
       "      <td>(41.865237246904975,-87.70699853404217)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49984</th>\n",
       "      <td>49984</td>\n",
       "      <td>1463880</td>\n",
       "      <td>02/06/2008</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN065014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR LINTELS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOOSE SHIFTING MASONRY AT LINTELS ALL ELEVATIO...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>7201 S WESTERN AVE</td>\n",
       "      <td>20486</td>\n",
       "      <td>14</td>\n",
       "      <td>41.762787</td>\n",
       "      <td>-87.683044</td>\n",
       "      <td>(41.76278714835731,-87.68304371614897)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49985</th>\n",
       "      <td>49985</td>\n",
       "      <td>1445250</td>\n",
       "      <td>01/12/2007</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN105035</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>01/04/2007</td>\n",
       "      <td>REPAIR DOOR HARDWARE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DEFECTIVE DOOR LOCK 2ND FLOOR LOBBY DOOR TO CO...</td>\n",
       "      <td>...</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>6403 N WAYNE AVE</td>\n",
       "      <td>13319</td>\n",
       "      <td>26</td>\n",
       "      <td>41.998311</td>\n",
       "      <td>-87.664149</td>\n",
       "      <td>(41.998311432756,-87.66414899127476)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49986</th>\n",
       "      <td>49986</td>\n",
       "      <td>1326440</td>\n",
       "      <td>03/29/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>RF302041</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRV HIGH SIDE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>450 P.S.I.G. RE: ONE YORK 20TON WITH ONE COMPR...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>4740 N WESTERN AVE</td>\n",
       "      <td>11132</td>\n",
       "      <td>21</td>\n",
       "      <td>41.967962</td>\n",
       "      <td>-87.689032</td>\n",
       "      <td>(41.967961971899875,-87.68903213148234)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49987</th>\n",
       "      <td>49987</td>\n",
       "      <td>1476454</td>\n",
       "      <td>07/11/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>NC2021</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PERMIT REQUIRED - CONTRACTOR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PERMIT REQUIRED FOR 6FL FENCES SEE WOOD AND CO...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>904 W ROSCOE ST</td>\n",
       "      <td>9099</td>\n",
       "      <td>18</td>\n",
       "      <td>41.943685</td>\n",
       "      <td>-87.652167</td>\n",
       "      <td>(41.94368500653552,-87.65216734520399)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49988</th>\n",
       "      <td>49988</td>\n",
       "      <td>1579527</td>\n",
       "      <td>08/18/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN198019</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FILE BLDG REGISTRATION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUILDING - NOT REGISTERED 2003-2005</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1435 N WELLS ST</td>\n",
       "      <td>4335</td>\n",
       "      <td>48</td>\n",
       "      <td>41.908694</td>\n",
       "      <td>-87.634487</td>\n",
       "      <td>(41.9086941456714,-87.63448689691725)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49989</th>\n",
       "      <td>49989</td>\n",
       "      <td>1386550</td>\n",
       "      <td>05/10/2006</td>\n",
       "      <td>01/02/2006</td>\n",
       "      <td>CN073014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR EXTERIOR DOOR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FRONT DOOR  TO STAIRWAY  ROTTED AT BOTTOM</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1831 S THROOP ST</td>\n",
       "      <td>16300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.856963</td>\n",
       "      <td>-87.658699</td>\n",
       "      <td>(41.856962510283,-87.65869940789038)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49990</th>\n",
       "      <td>49990</td>\n",
       "      <td>1439036</td>\n",
       "      <td>04/16/2009</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN190019</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>03/12/2009</td>\n",
       "      <td>ARRANGE PREMISE INSPECTION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NO ENTRY TO INTERIOR.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>608 E 62ND ST</td>\n",
       "      <td>19387</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.782263</td>\n",
       "      <td>-87.610447</td>\n",
       "      <td>(41.782263477530066,-87.61044671992697)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49991</th>\n",
       "      <td>49991</td>\n",
       "      <td>1474102</td>\n",
       "      <td>11/12/2009</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN104055</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>11/10/2009</td>\n",
       "      <td>REPUTTY WINDOW PANES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALL SASH LOOSE &amp; MISSING PUTTY</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>5039 S CHAMPLAIN AVE</td>\n",
       "      <td>18333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.802877</td>\n",
       "      <td>-87.609908</td>\n",
       "      <td>(41.80287663210569,-87.60990755107315)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49992</th>\n",
       "      <td>49992</td>\n",
       "      <td>1473213</td>\n",
       "      <td>10/25/2007</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN131026</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>06/13/2007</td>\n",
       "      <td>REPAIR SCREENS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WINDOW SCREENS TORN</td>\n",
       "      <td>...</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>6358 S DR MARTIN L KING JR DR</td>\n",
       "      <td>19571</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.778666</td>\n",
       "      <td>-87.615737</td>\n",
       "      <td>(41.77866641615929,-87.61573658958363)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49993</th>\n",
       "      <td>49993</td>\n",
       "      <td>1474071</td>\n",
       "      <td>11/12/2009</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN074014</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>11/10/2009</td>\n",
       "      <td>SERVICE WALK, PASSAGE, AREAWAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REAR SERVICE WALK BROKEN &amp; BUCKLED CONCRETE</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>5039 S CHAMPLAIN AVE</td>\n",
       "      <td>18333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.802877</td>\n",
       "      <td>-87.609908</td>\n",
       "      <td>(41.80287663210569,-87.60990755107315)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49994</th>\n",
       "      <td>49994</td>\n",
       "      <td>4011641</td>\n",
       "      <td>10/28/2011</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN194039</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>10/28/2011</td>\n",
       "      <td>REMOVE</td>\n",
       "      <td>INSPECTION</td>\n",
       "      <td>ONE 175 TON COOLING TOWER AND RELATED PIPING F...</td>\n",
       "      <td>...</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>REFRIGERATION</td>\n",
       "      <td>2203 W DEVON AVE</td>\n",
       "      <td>565750</td>\n",
       "      <td>43</td>\n",
       "      <td>41.997701</td>\n",
       "      <td>-87.685147</td>\n",
       "      <td>(41.99770079922752,-87.6851465642111)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49995</th>\n",
       "      <td>49995</td>\n",
       "      <td>1438713</td>\n",
       "      <td>06/16/2006</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN063014</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CHIMNEY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CHIMNEY WASHED OUT MORTAR LOOSE BRICKS.</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>1854 E 79TH ST</td>\n",
       "      <td>20597</td>\n",
       "      <td>50</td>\n",
       "      <td>41.751683</td>\n",
       "      <td>-87.578659</td>\n",
       "      <td>(41.75168267214598,-87.57865870399478)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49996</th>\n",
       "      <td>49996</td>\n",
       "      <td>1357061</td>\n",
       "      <td>07/17/2006</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN070024</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REPAIR PORCH SYSTEM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35 REAR PORCH GRADE TO 3RD RAILS TOO SHORT, MI...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>31 N LOREL AVE</td>\n",
       "      <td>1612</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.881299</td>\n",
       "      <td>-87.758621</td>\n",
       "      <td>(41.881299199557894,-87.75862053499047)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49997</th>\n",
       "      <td>49997</td>\n",
       "      <td>1430847</td>\n",
       "      <td>10/14/2008</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN031013</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>07/10/2008</td>\n",
       "      <td>FIRE EXTNGSHR REQ, RESDNTL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALL ELEVATION MISSING FIRE EXTINGUISHER</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>6501 S LOWE AVE</td>\n",
       "      <td>19693</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.776074</td>\n",
       "      <td>-87.640625</td>\n",
       "      <td>(41.7760739361563,-87.64062455203374)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49998</th>\n",
       "      <td>49998</td>\n",
       "      <td>1734149</td>\n",
       "      <td>09/16/2008</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN135016</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>09/05/2008</td>\n",
       "      <td>MICE/RODENTS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MICE ON PREMISES</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>4836 S INDIANA AVE</td>\n",
       "      <td>18261</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.806381</td>\n",
       "      <td>-87.621283</td>\n",
       "      <td>(41.80638088214982,-87.62128295874425)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49999</th>\n",
       "      <td>49999</td>\n",
       "      <td>1834762</td>\n",
       "      <td>01/12/2007</td>\n",
       "      <td>01/01/2006</td>\n",
       "      <td>CN190019</td>\n",
       "      <td>COMPLIED</td>\n",
       "      <td>01/11/2007</td>\n",
       "      <td>ARRANGE PREMISE INSPECTION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NO ENTRY TO INTERIOR TO VERIFY OCCUPANCY AND D...</td>\n",
       "      <td>...</td>\n",
       "      <td>FAILED</td>\n",
       "      <td>N</td>\n",
       "      <td>PERIODIC</td>\n",
       "      <td>CONSERVATION</td>\n",
       "      <td>200 N KOSTNER AVE</td>\n",
       "      <td>1531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.883310</td>\n",
       "      <td>-87.735709</td>\n",
       "      <td>(41.88330951242491,-87.73570901056128)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50000 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       unnamed:_0       id violation_last_modified_date violation_date  \\\n",
       "0               0  5063843                   05/21/2015     05/21/2015   \n",
       "1               1  5063990                   05/21/2015     05/21/2015   \n",
       "2               2  5064022                   05/21/2015     05/21/2015   \n",
       "3               3  5064019                   05/21/2015     05/21/2015   \n",
       "4               4  5064139                   05/21/2015     05/21/2015   \n",
       "5               5  5064153                   05/21/2015     05/21/2015   \n",
       "6               6  5064141                   05/21/2015     05/21/2015   \n",
       "7               7  5064257                   05/21/2015     05/21/2015   \n",
       "8               8  5064728                   05/21/2015     05/21/2015   \n",
       "9               9  5064742                   05/21/2015     05/21/2015   \n",
       "10             10  5064812                   05/21/2015     05/21/2015   \n",
       "11             11  5064815                   05/21/2015     05/21/2015   \n",
       "12             12  5063772                   05/20/2015     05/20/2015   \n",
       "13             13  5063459                   05/20/2015     05/20/2015   \n",
       "14             14  5063763                   05/20/2015     05/20/2015   \n",
       "15             15  5063885                   05/21/2015     05/20/2015   \n",
       "16             16  5063912                   05/21/2015     05/20/2015   \n",
       "17             17  5063146                   05/20/2015     05/20/2015   \n",
       "18             18  5063320                   05/20/2015     05/20/2015   \n",
       "19             19  5064353                   05/20/2015     05/20/2015   \n",
       "20             20  5064410                   05/20/2015     05/20/2015   \n",
       "21             21  5064489                   05/20/2015     05/20/2015   \n",
       "22             22  5063646                   05/21/2015     05/19/2015   \n",
       "23             23  5062486                   05/19/2015     05/19/2015   \n",
       "24             24  5062605                   05/19/2015     05/19/2015   \n",
       "25             25  5062606                   05/19/2015     05/19/2015   \n",
       "26             26  5062634                   05/19/2015     05/19/2015   \n",
       "27             27  5062679                   05/19/2015     05/19/2015   \n",
       "28             28  5061236                   05/19/2015     05/19/2015   \n",
       "29             29  5062894                   05/19/2015     05/19/2015   \n",
       "...           ...      ...                          ...            ...   \n",
       "49970       49970  1298007                   03/07/2006     01/02/2006   \n",
       "49971       49971  1341538                   04/07/2006     01/02/2006   \n",
       "49972       49972  1424819                   06/08/2006     01/02/2006   \n",
       "49973       49973  1275765                   04/11/2006     01/02/2006   \n",
       "49974       49974  1377390                   08/11/2008     01/02/2006   \n",
       "49975       49975  1453130                   06/26/2006     01/02/2006   \n",
       "49976       49976  1285116                   03/02/2006     01/02/2006   \n",
       "49977       49977  4175176                   05/15/2012     01/02/2006   \n",
       "49978       49978  1275519                   02/23/2006     01/02/2006   \n",
       "49979       49979  1569712                   08/13/2008     01/02/2006   \n",
       "49980       49980  1446021                   05/03/2007     01/02/2006   \n",
       "49981       49981  1566701                   03/31/2008     01/02/2006   \n",
       "49982       49982  4263492                   08/23/2012     01/02/2006   \n",
       "49983       49983  1453137                   06/26/2006     01/02/2006   \n",
       "49984       49984  1463880                   02/06/2008     01/02/2006   \n",
       "49985       49985  1445250                   01/12/2007     01/02/2006   \n",
       "49986       49986  1326440                   03/29/2006     01/02/2006   \n",
       "49987       49987  1476454                   07/11/2006     01/02/2006   \n",
       "49988       49988  1579527                   08/18/2006     01/02/2006   \n",
       "49989       49989  1386550                   05/10/2006     01/02/2006   \n",
       "49990       49990  1439036                   04/16/2009     01/01/2006   \n",
       "49991       49991  1474102                   11/12/2009     01/01/2006   \n",
       "49992       49992  1473213                   10/25/2007     01/01/2006   \n",
       "49993       49993  1474071                   11/12/2009     01/01/2006   \n",
       "49994       49994  4011641                   10/28/2011     01/01/2006   \n",
       "49995       49995  1438713                   06/16/2006     01/01/2006   \n",
       "49996       49996  1357061                   07/17/2006     01/01/2006   \n",
       "49997       49997  1430847                   10/14/2008     01/01/2006   \n",
       "49998       49998  1734149                   09/16/2008     01/01/2006   \n",
       "49999       49999  1834762                   01/12/2007     01/01/2006   \n",
       "\n",
       "      violation_code violation_status violation_status_date  \\\n",
       "0           CN065014             OPEN                   NaN   \n",
       "1           CN044013             OPEN                   NaN   \n",
       "2           CN104035             OPEN                   NaN   \n",
       "3           CN196029             OPEN                   NaN   \n",
       "4           CN104015             OPEN                   NaN   \n",
       "5           CN190019             OPEN                   NaN   \n",
       "6           CN015062             OPEN                   NaN   \n",
       "7           CN065034             OPEN                   NaN   \n",
       "8           CN196029             OPEN                   NaN   \n",
       "9           CN190019             OPEN                   NaN   \n",
       "10          CN104065             OPEN                   NaN   \n",
       "11          CN063014             OPEN                   NaN   \n",
       "12          CN070024             OPEN                   NaN   \n",
       "13          CN193019             OPEN                   NaN   \n",
       "14          CN041063             OPEN                   NaN   \n",
       "15            BR1001             OPEN                   NaN   \n",
       "16          PL151137             OPEN                   NaN   \n",
       "17          CN074014             OPEN                   NaN   \n",
       "18          CN193019             OPEN                   NaN   \n",
       "19          CN070014             OPEN                   NaN   \n",
       "20          CN193039             OPEN                   NaN   \n",
       "21          CN193039             OPEN                   NaN   \n",
       "22            BR2080             OPEN                   NaN   \n",
       "23          CN193039             OPEN                   NaN   \n",
       "24          CN111025             OPEN                   NaN   \n",
       "25          CN110025             OPEN                   NaN   \n",
       "26          CN104015             OPEN                   NaN   \n",
       "27          CN061014             OPEN                   NaN   \n",
       "28          CN105085             OPEN                   NaN   \n",
       "29          CN076014             OPEN                   NaN   \n",
       "...              ...              ...                   ...   \n",
       "49970       RF301041             OPEN                   NaN   \n",
       "49971       CN140016             OPEN                   NaN   \n",
       "49972       CN196029         COMPLIED            02/17/2006   \n",
       "49973       CN194039         COMPLIED            01/11/2006   \n",
       "49974         NC5062         COMPLIED            06/17/2008   \n",
       "49975       CN077014             OPEN                   NaN   \n",
       "49976       RF301031             OPEN                   NaN   \n",
       "49977       RF302041         COMPLIED            05/16/2012   \n",
       "49978       RF302021             OPEN                   NaN   \n",
       "49979         EL0029         COMPLIED            05/21/2008   \n",
       "49980       CN069014         COMPLIED            04/11/2007   \n",
       "49981       CN190019         COMPLIED            01/14/2008   \n",
       "49982       RF301041             OPEN                   NaN   \n",
       "49983       CN074024             OPEN                   NaN   \n",
       "49984       CN065014             OPEN                   NaN   \n",
       "49985       CN105035         COMPLIED            01/04/2007   \n",
       "49986       RF302041             OPEN                   NaN   \n",
       "49987         NC2021             OPEN                   NaN   \n",
       "49988       CN198019             OPEN                   NaN   \n",
       "49989       CN073014             OPEN                   NaN   \n",
       "49990       CN190019         COMPLIED            03/12/2009   \n",
       "49991       CN104055         COMPLIED            11/10/2009   \n",
       "49992       CN131026         COMPLIED            06/13/2007   \n",
       "49993       CN074014         COMPLIED            11/10/2009   \n",
       "49994       CN194039         COMPLIED            10/28/2011   \n",
       "49995       CN063014             OPEN                   NaN   \n",
       "49996       CN070024             OPEN                   NaN   \n",
       "49997       CN031013         COMPLIED            07/10/2008   \n",
       "49998       CN135016         COMPLIED            09/05/2008   \n",
       "49999       CN190019         COMPLIED            01/11/2007   \n",
       "\n",
       "                violation_description             violation_location  \\\n",
       "0                      REPAIR LINTELS                 OTHER   :    :   \n",
       "1      PIPE OPENING W/NONCOMBUST MATL  OTHER   :    :MULTIPLE FLOORS   \n",
       "2                     MAINTAIN WINDOW                 OTHER   :    :   \n",
       "3          POST OWNER/MANAGERS NAME/#                 OTHER   :    :   \n",
       "4       REPLCE WINDOW PANES, PLEXGLAS                 OTHER   :    :   \n",
       "5          ARRANGE PREMISE INSPECTION                 OTHER   :    :   \n",
       "6            OBSTRUCTIONS IN EXIT WAY                 OTHER   :    :   \n",
       "7                 REPAIR WINDOW SILLS                 EXTERIOR:W   :   \n",
       "8          POST OWNER/MANAGERS NAME/#                 OTHER   :    :   \n",
       "9          ARRANGE PREMISE INSPECTION         OTHER   :    :BUILDING   \n",
       "10             REPAIR WINDOW HARDWARE                 OTHER   :    :   \n",
       "11                            CHIMNEY                 OTHER   :    :   \n",
       "12                REPAIR PORCH SYSTEM                 EXTERIOR:S   :   \n",
       "13     REPAIR/WRECK DANGER RESID PREM                            NaN   \n",
       "14           CUT OR REMOVE HIGH WEEDS                 EXTERIOR:W   :   \n",
       "15       OWNER OR LICENSED CONTRACTOR                            NaN   \n",
       "16                               OPEN                            NaN   \n",
       "17     SERVICE WALK, PASSAGE, AREAWAY                 OTHER   :    :   \n",
       "18     REPAIR/WRECK DANGER RESID PREM                            NaN   \n",
       "19              REPAIR EXTERIOR STAIR                 EXTERIOR:N   :   \n",
       "20      POST OWNER NAME OF VACNT BLDG                            NaN   \n",
       "21      POST OWNER NAME OF VACNT BLDG                            NaN   \n",
       "22                           INTERNAL                            NaN   \n",
       "23      POST OWNER NAME OF VACNT BLDG                            NaN   \n",
       "24                   EGRESS -BASEMENT                 OTHER   :    :   \n",
       "25                             EGRESS                 OTHER   :    :   \n",
       "26      REPLCE WINDOW PANES, PLEXGLAS                 OTHER   :    :   \n",
       "27               REPAIR EXTERIOR WALL    OTHER   :    :EXTERIOR WALL   \n",
       "28      PROVIDE DEADLOCK FOR ENTRANCE                 OTHER   :    :   \n",
       "29         PROVIDE GUTTER & DOWNSPOUT                 OTHER   :    :   \n",
       "...                               ...                            ...   \n",
       "49970          ARRANGE FOR INSPECTION                            NaN   \n",
       "49971     DWELLING CLEAN AND SANITARY                            NaN   \n",
       "49972      POST OWNER/MANAGERS NAME/#                            NaN   \n",
       "49973                          REMOVE                            NaN   \n",
       "49974  HOLDOPEN DEVICE, STAIR 3+ FLRS                            NaN   \n",
       "49975                    REPAIR FENCE                            NaN   \n",
       "49976                  ACCESS TO ROOF                            NaN   \n",
       "49977                   PRV HIGH SIDE                     INSPECTION   \n",
       "49978                    PRV RECEIVER                            NaN   \n",
       "49979                  EXPOSED WIRING                            NaN   \n",
       "49980     REPAIR DEFECTIVE FOUNDATION                            NaN   \n",
       "49981      ARRANGE PREMISE INSPECTION                            NaN   \n",
       "49982          ARRANGE FOR INSPECTION                     INSPECTION   \n",
       "49983   PROVIDE GUARD RAIL 42 IN HIGH                            NaN   \n",
       "49984                  REPAIR LINTELS                            NaN   \n",
       "49985            REPAIR DOOR HARDWARE                            NaN   \n",
       "49986                   PRV HIGH SIDE                            NaN   \n",
       "49987    PERMIT REQUIRED - CONTRACTOR                            NaN   \n",
       "49988          FILE BLDG REGISTRATION                            NaN   \n",
       "49989            REPAIR EXTERIOR DOOR                            NaN   \n",
       "49990      ARRANGE PREMISE INSPECTION                            NaN   \n",
       "49991            REPUTTY WINDOW PANES                            NaN   \n",
       "49992                  REPAIR SCREENS                            NaN   \n",
       "49993  SERVICE WALK, PASSAGE, AREAWAY                            NaN   \n",
       "49994                          REMOVE                     INSPECTION   \n",
       "49995                         CHIMNEY                            NaN   \n",
       "49996             REPAIR PORCH SYSTEM                            NaN   \n",
       "49997      FIRE EXTNGSHR REQ, RESDNTL                            NaN   \n",
       "49998                    MICE/RODENTS                            NaN   \n",
       "49999      ARRANGE PREMISE INSPECTION                            NaN   \n",
       "\n",
       "                            violation_inspector_comments  \\\n",
       "0                                       LINTELS; RUSTED.   \n",
       "1      OPENINGS AROUND PIPES, SEAL WITH APPROVED MATE...   \n",
       "2      ALL ELEVATIONS , WOOD WINDOW FRAMES  AND NORTH...   \n",
       "3               BUILDING - NO OWNER'S I.D. SIGN POSTED .   \n",
       "4      NORTH ELEVATION / 1ST FLOOR - BROKEN WINDOW PANE.   \n",
       "5      INTERIOR OF BUILDING, NO RESPONSE. UNABLE TO V...   \n",
       "6      EAST ELEVATION / 5649 S. 2ND FLOOR SECONDARY E...   \n",
       "7      WEST ELEVATION STONE SILLS HAVE WASHED OUT MOR...   \n",
       "8                  BUILDING - NO OWNER'S ID SIGN POSTED.   \n",
       "9      UNABLE TO INSPECT INTERIOR, STAIRWELLS, BASEME...   \n",
       "10                    WINDOWS DOESN'T LOCK, DAMAGE LOCK.   \n",
       "11                            CHIMNEY WASHED OUT MORTAR.   \n",
       "12     SOUTH ELEVATION VIEWED FROM BEHIND FENCE FRONT...   \n",
       "13                                            No comment   \n",
       "14                 WEST ELEVATION OVERGROWN GRASS/WEEDS.   \n",
       "15                                            No comment   \n",
       "16                                            No comment   \n",
       "17                        SERVICE WALK; BROKEN CONCRETE.   \n",
       "18                                            No comment   \n",
       "19     NORTH, SOUTH ELEVATIONS - HANDRAILS MISSING FR...   \n",
       "20                                            No comment   \n",
       "21                                            No comment   \n",
       "22                                    #1 KEWANEE BOILER.   \n",
       "23                                            No comment   \n",
       "24     BASEMENT DWELLING UNIT - ONLY 1 EGRESS EXISTS ...   \n",
       "25     ATTIC DWELLING UNIT - ONLY ONE EGRESS EXISTS (...   \n",
       "26     FRONT 1ST AND 2ND FLOOR APTS/REAR BASEMENT, 1S...   \n",
       "27               EXTERIOR WALL WASHED OUT MORTAR JOINTS.   \n",
       "28                         FRONT EXTERIOR DOOR; NO LOCK.   \n",
       "29                         MISSING GUTTER AND DOWNSPOUT.   \n",
       "...                                                  ...   \n",
       "49970              CALL 312-746-8437 & ASK FOR INSP#650.   \n",
       "49971             JUNK AND GARBAGE REAR YARD UNSANITARY.   \n",
       "49972         FRONT ELEVATION  OWNERS ID SIGN NOT POSTED   \n",
       "49973  FOR ONE 40-TON CARRIER LOCATED IN BASEMENT MEC...   \n",
       "49974  ALL STAIRWELL  DOORS BEING HELD OPEN WITH DOOR...   \n",
       "49975    REAR YARD AT NORTH-MISSING SECTIONS OF FENCING.   \n",
       "49976  A/C UNIT LOCATED ON THE ROOF.            (SEC....   \n",
       "49977  (SEC. 18-28-1102.3, 18-28-1006.5, 18-28-1006.3...   \n",
       "49978  (SEC. 18-28-1006.3, 18-28-1107.7.1, 18-28-1102...   \n",
       "49979         MISSING OUTLET COVER UNDER FRONT STAIRWAY.   \n",
       "49980      FRACTURED FOUNDATION REAR PORCH AT GRADE 1439   \n",
       "49981                              NO ENTRY TO INTERIOR.   \n",
       "49982         CONTACT INSPECTORTRAVIS #655 312-746-8437.   \n",
       "49983  WEST STAIRS TO BASEMENT-BROKEN GUARD RAILS/WEA...   \n",
       "49984  LOOSE SHIFTING MASONRY AT LINTELS ALL ELEVATIO...   \n",
       "49985  DEFECTIVE DOOR LOCK 2ND FLOOR LOBBY DOOR TO CO...   \n",
       "49986  450 P.S.I.G. RE: ONE YORK 20TON WITH ONE COMPR...   \n",
       "49987  PERMIT REQUIRED FOR 6FL FENCES SEE WOOD AND CO...   \n",
       "49988                BUILDING - NOT REGISTERED 2003-2005   \n",
       "49989          FRONT DOOR  TO STAIRWAY  ROTTED AT BOTTOM   \n",
       "49990                              NO ENTRY TO INTERIOR.   \n",
       "49991                     ALL SASH LOOSE & MISSING PUTTY   \n",
       "49992                                WINDOW SCREENS TORN   \n",
       "49993        REAR SERVICE WALK BROKEN & BUCKLED CONCRETE   \n",
       "49994  ONE 175 TON COOLING TOWER AND RELATED PIPING F...   \n",
       "49995            CHIMNEY WASHED OUT MORTAR LOOSE BRICKS.   \n",
       "49996  35 REAR PORCH GRADE TO 3RD RAILS TOO SHORT, MI...   \n",
       "49997            ALL ELEVATION MISSING FIRE EXTINGUISHER   \n",
       "49998                                   MICE ON PREMISES   \n",
       "49999  NO ENTRY TO INTERIOR TO VERIFY OCCUPANCY AND D...   \n",
       "\n",
       "                        ...                    inspection_status  \\\n",
       "0                       ...                               FAILED   \n",
       "1                       ...                               FAILED   \n",
       "2                       ...                               FAILED   \n",
       "3                       ...                               FAILED   \n",
       "4                       ...                               FAILED   \n",
       "5                       ...                               FAILED   \n",
       "6                       ...                               FAILED   \n",
       "7                       ...                               FAILED   \n",
       "8                       ...                               FAILED   \n",
       "9                       ...                               FAILED   \n",
       "10                      ...                               FAILED   \n",
       "11                      ...                               FAILED   \n",
       "12                      ...                               FAILED   \n",
       "13                      ...                               CLOSED   \n",
       "14                      ...                               FAILED   \n",
       "15                      ...                               CLOSED   \n",
       "16                      ...                               FAILED   \n",
       "17                      ...                               FAILED   \n",
       "18                      ...                               CLOSED   \n",
       "19                      ...                               FAILED   \n",
       "20                      ...                               CLOSED   \n",
       "21                      ...                               CLOSED   \n",
       "22                      ...                               CLOSED   \n",
       "23                      ...                               CLOSED   \n",
       "24                      ...                               FAILED   \n",
       "25                      ...                               FAILED   \n",
       "26                      ...                               FAILED   \n",
       "27                      ...                               FAILED   \n",
       "28                      ...                               FAILED   \n",
       "29                      ...                               FAILED   \n",
       "...                     ...                                  ...   \n",
       "49970                   ...                               FAILED   \n",
       "49971                   ...                               FAILED   \n",
       "49972                   ...                               PASSED   \n",
       "49973                   ...                               PASSED   \n",
       "49974                   ...                               FAILED   \n",
       "49975                   ...                               FAILED   \n",
       "49976                   ...                               FAILED   \n",
       "49977                   ...                               PASSED   \n",
       "49978                   ...                               FAILED   \n",
       "49979                   ...                               FAILED   \n",
       "49980                   ...                               PASSED   \n",
       "49981                   ...                               FAILED   \n",
       "49982                   ...                               FAILED   \n",
       "49983                   ...                               FAILED   \n",
       "49984                   ...                               FAILED   \n",
       "49985                   ...                               PASSED   \n",
       "49986                   ...                               FAILED   \n",
       "49987                   ...                               FAILED   \n",
       "49988                   ...                               FAILED   \n",
       "49989                   ...                               FAILED   \n",
       "49990                   ...                               FAILED   \n",
       "49991                   ...                               FAILED   \n",
       "49992                   ...                               PASSED   \n",
       "49993                   ...                               FAILED   \n",
       "49994                   ...                               PASSED   \n",
       "49995                   ...                               FAILED   \n",
       "49996                   ...                               FAILED   \n",
       "49997                   ...                               FAILED   \n",
       "49998                   ...                               FAILED   \n",
       "49999                   ...                               FAILED   \n",
       "\n",
       "      inspection_waived  inspection_category department_bureau  \\\n",
       "0                     N            COMPLAINT      CONSERVATION   \n",
       "1                     N             PERIODIC      CONSERVATION   \n",
       "2                     N            COMPLAINT      CONSERVATION   \n",
       "3                     N            COMPLAINT      CONSERVATION   \n",
       "4                     N            COMPLAINT      CONSERVATION   \n",
       "5                     N            COMPLAINT      CONSERVATION   \n",
       "6                     N            COMPLAINT      CONSERVATION   \n",
       "7                     N            COMPLAINT      CONSERVATION   \n",
       "8                     N            COMPLAINT      CONSERVATION   \n",
       "9                     N            COMPLAINT      CONSERVATION   \n",
       "10                    N            COMPLAINT      CONSERVATION   \n",
       "11                    N            COMPLAINT      CONSERVATION   \n",
       "12                    N            COMPLAINT      CONSERVATION   \n",
       "13                    N            COMPLAINT        DEMOLITION   \n",
       "14                    N            COMPLAINT      CONSERVATION   \n",
       "15                    N             PERIODIC            BOILER   \n",
       "16                    N               PERMIT          PLUMBING   \n",
       "17                    N            COMPLAINT      CONSERVATION   \n",
       "18                    N            COMPLAINT        DEMOLITION   \n",
       "19                    N            COMPLAINT      CONSERVATION   \n",
       "20                    N            COMPLAINT        DEMOLITION   \n",
       "21                    N            COMPLAINT        DEMOLITION   \n",
       "22                    N             PERIODIC            BOILER   \n",
       "23                    N            COMPLAINT        DEMOLITION   \n",
       "24                    N            COMPLAINT      CONSERVATION   \n",
       "25                    N            COMPLAINT      CONSERVATION   \n",
       "26                    N            COMPLAINT      CONSERVATION   \n",
       "27                    N             PERIODIC      CONSERVATION   \n",
       "28                    N            COMPLAINT      CONSERVATION   \n",
       "29                    N            COMPLAINT      CONSERVATION   \n",
       "...                 ...                  ...               ...   \n",
       "49970                 N             PERIODIC     REFRIGERATION   \n",
       "49971                 N             PERIODIC      CONSERVATION   \n",
       "49972                 N             PERIODIC      CONSERVATION   \n",
       "49973                 N             PERIODIC     REFRIGERATION   \n",
       "49974                 N             PERIODIC      CONSERVATION   \n",
       "49975                 N             PERIODIC      CONSERVATION   \n",
       "49976                 N             PERIODIC     REFRIGERATION   \n",
       "49977                 N             PERIODIC     REFRIGERATION   \n",
       "49978                 N             PERIODIC     REFRIGERATION   \n",
       "49979                 N             PERIODIC      CONSERVATION   \n",
       "49980                 N             PERIODIC      CONSERVATION   \n",
       "49981                 N             PERIODIC      CONSERVATION   \n",
       "49982                 N             PERIODIC     REFRIGERATION   \n",
       "49983                 N             PERIODIC      CONSERVATION   \n",
       "49984                 N             PERIODIC      CONSERVATION   \n",
       "49985                 N             PERIODIC      CONSERVATION   \n",
       "49986                 N             PERIODIC     REFRIGERATION   \n",
       "49987                 N             PERIODIC      CONSERVATION   \n",
       "49988                 N             PERIODIC      CONSERVATION   \n",
       "49989                 N             PERIODIC      CONSERVATION   \n",
       "49990                 N             PERIODIC      CONSERVATION   \n",
       "49991                 N             PERIODIC      CONSERVATION   \n",
       "49992                 N             PERIODIC      CONSERVATION   \n",
       "49993                 N             PERIODIC      CONSERVATION   \n",
       "49994                 N             PERIODIC     REFRIGERATION   \n",
       "49995                 N             PERIODIC      CONSERVATION   \n",
       "49996                 N             PERIODIC      CONSERVATION   \n",
       "49997                 N             PERIODIC      CONSERVATION   \n",
       "49998                 N             PERIODIC      CONSERVATION   \n",
       "49999                 N             PERIODIC      CONSERVATION   \n",
       "\n",
       "                             address property_group  ssa   latitude  \\\n",
       "0                      722 E 89TH ST         461523   51  41.733089   \n",
       "1      6444 S DR MARTIN L KING JR DR          19575  NaN  41.777088   \n",
       "2                  3115 N SAWYER AVE         117375  NaN  41.937995   \n",
       "3                  3115 N SAWYER AVE         117375  NaN  41.937995   \n",
       "4                 5649 S INDIANA AVE         344254  NaN  41.791470   \n",
       "5                4445 S ST LOUIS AVE          26288  NaN  41.812187   \n",
       "6                 5649 S INDIANA AVE         344254  NaN  41.791470   \n",
       "7                7049 S CARPENTER ST         396449  NaN  41.765487   \n",
       "8                  4525 N KARLOV AVE         179641  NaN  41.963291   \n",
       "9                 5852 N SHERIDAN RD         209269  NaN  41.988844   \n",
       "10               4126 N KILBOURN AVE         168842  NaN  41.956154   \n",
       "11               4126 N KILBOURN AVE         168842  NaN  41.956154   \n",
       "12                   2050 W JAMES ST         333262  NaN  41.799958   \n",
       "13                   3051 S BROAD ST         285348  NaN  41.838454   \n",
       "14              5435 S HERMITAGE AVE         332092  NaN  41.794758   \n",
       "15                  6448 S TRIPP AVE         387870  NaN  41.775328   \n",
       "16                  3835 W CERMAK RD         280823  NaN  41.851485   \n",
       "17                 7932 S DREXEL AVE         430670   51  41.750313   \n",
       "18                 11025 S ESMOND ST         516079  NaN  41.693018   \n",
       "19                  1437 W DEVON AVE         218603   26  41.998011   \n",
       "20                6928 S KIMBARK AVE         393870  NaN  41.769012   \n",
       "21                 6643 S RACINE AVE         380041  NaN  41.772878   \n",
       "22                     945 W 38TH ST          17749   13  41.825409   \n",
       "23                12825 S HALSTED ST         543423  NaN  41.660625   \n",
       "24             2334 S SACRAMENTO AVE         278665  NaN  41.848999   \n",
       "25             2334 S SACRAMENTO AVE         278665  NaN  41.848999   \n",
       "26                  2848 N AVERS AVE           8632  NaN  41.933287   \n",
       "27               6042 S MICHIGAN AVE          19272  NaN  41.784308   \n",
       "28                10955 S VERNON AVE         510739  NaN  41.694920   \n",
       "29                1732 N KEDVALE AVE          78139  NaN  41.912628   \n",
       "...                              ...            ...  ...        ...   \n",
       "49970                5025 N CLARK ST         185292   22  41.973325   \n",
       "49971           2901 N MILWAUKEE AVE           8593  NaN  41.933982   \n",
       "49972            1523 N CAMPBELL AVE           4945  NaN  41.909184   \n",
       "49973          6420 N CALIFORNIA AVE          13534   43  41.998216   \n",
       "49974           810 E HYDE PARK BLVD          18419   47  41.802373   \n",
       "49975              1236 S SAWYER AVE          15735  NaN  41.865237   \n",
       "49976               2401 W DEVON AVE         220380   43  41.997619   \n",
       "49977            6400 N ARTESIAN AVE          13500   43  41.997798   \n",
       "49978               2742 W DEVON AVE         230484   43  41.997682   \n",
       "49979            4844 W HENDERSON ST           9542  NaN  41.941650   \n",
       "49980                1433 W LUNT AVE          13658   24  42.008989   \n",
       "49981               1455 W FARGO AVE         239959  NaN  42.017019   \n",
       "49982               1217 W MORSE AVE          13683   24  42.007858   \n",
       "49983              1236 S SAWYER AVE          15735  NaN  41.865237   \n",
       "49984             7201 S WESTERN AVE          20486   14  41.762787   \n",
       "49985               6403 N WAYNE AVE          13319   26  41.998311   \n",
       "49986             4740 N WESTERN AVE          11132   21  41.967962   \n",
       "49987                904 W ROSCOE ST           9099   18  41.943685   \n",
       "49988                1435 N WELLS ST           4335   48  41.908694   \n",
       "49989               1831 S THROOP ST          16300  NaN  41.856963   \n",
       "49990                  608 E 62ND ST          19387  NaN  41.782263   \n",
       "49991           5039 S CHAMPLAIN AVE          18333  NaN  41.802877   \n",
       "49992  6358 S DR MARTIN L KING JR DR          19571  NaN  41.778666   \n",
       "49993           5039 S CHAMPLAIN AVE          18333  NaN  41.802877   \n",
       "49994               2203 W DEVON AVE         565750   43  41.997701   \n",
       "49995                 1854 E 79TH ST          20597   50  41.751683   \n",
       "49996                 31 N LOREL AVE           1612  NaN  41.881299   \n",
       "49997                6501 S LOWE AVE          19693  NaN  41.776074   \n",
       "49998             4836 S INDIANA AVE          18261  NaN  41.806381   \n",
       "49999              200 N KOSTNER AVE           1531  NaN  41.883310   \n",
       "\n",
       "       longitude                                 location  \n",
       "0     -87.606184   (41.73308939713441,-87.60618433527188)  \n",
       "1     -87.615694   (41.77708792596553,-87.61569442972947)  \n",
       "2     -87.708657   (41.93799454179893,-87.70865671096144)  \n",
       "3     -87.708657   (41.93799454179893,-87.70865671096144)  \n",
       "4     -87.620616  (41.791469839262206,-87.62061589476306)  \n",
       "5     -87.711151   (41.81218733369289,-87.71115060894742)  \n",
       "6     -87.620616  (41.791469839262206,-87.62061589476306)  \n",
       "7     -87.650339   (41.76548669063829,-87.65033946181353)  \n",
       "8     -87.730173   (41.96329131960269,-87.73017257884024)  \n",
       "9     -87.655496   (41.98884444339461,-87.65549560741945)  \n",
       "10    -87.740752   (41.95615356844395,-87.74075173259708)  \n",
       "11    -87.740752   (41.95615356844395,-87.74075173259708)  \n",
       "12    -87.676554  (41.799957885368265,-87.67655353910952)  \n",
       "13    -87.660979    (41.83845438362799,-87.6609787384341)  \n",
       "14    -87.668103   (41.79475771640361,-87.66810282975975)  \n",
       "15    -87.728922  (41.775328312329904,-87.72892174006991)  \n",
       "16    -87.721159   (41.85148492680666,-87.72115941535648)  \n",
       "17    -87.602878  (41.750312646858305,-87.60287756666781)  \n",
       "18    -87.667286   (41.69301757344688,-87.66728567428113)  \n",
       "19    -87.666881    (41.99801090422057,-87.6668814940047)  \n",
       "20    -87.594164   (41.76901189738516,-87.59416364991507)  \n",
       "21    -87.654175   (41.77287780825002,-87.65417450839244)  \n",
       "22    -87.649299   (41.82540859508953,-87.64929947480178)  \n",
       "23    -87.641187  (41.660624688616466,-87.64118684260401)  \n",
       "24    -87.700419      (41.848999312527,-87.7004187481119)  \n",
       "25    -87.700419      (41.848999312527,-87.7004187481119)  \n",
       "26    -87.723472   (41.93328738702544,-87.72347229888197)  \n",
       "27    -87.622343   (41.78430781539396,-87.62234288111321)  \n",
       "28    -87.612071    (41.69491981145228,-87.6120713247033)  \n",
       "29    -87.730227   (41.91262815790136,-87.73022720869842)  \n",
       "...          ...                                      ...  \n",
       "49970 -87.667922   (41.97332527471334,-87.66792167114302)  \n",
       "49971 -87.715226  (41.933981597337265,-87.71522641499614)  \n",
       "49972 -87.689502   (41.90918426175231,-87.68950208397905)  \n",
       "49973 -87.699814  (41.998216306323414,-87.69981364221285)  \n",
       "49974 -87.605888   (41.80237347110972,-87.60588760843979)  \n",
       "49975 -87.706999  (41.865237246904975,-87.70699853404217)  \n",
       "49976 -87.689939   (41.997618688841094,-87.6899394819467)  \n",
       "49977 -87.691254   (41.99779781875053,-87.69125427479676)  \n",
       "49978 -87.698913     (41.997682115657,-87.69891315910674)  \n",
       "49979 -87.748758  (41.941649698719495,-87.74875812489256)  \n",
       "49980 -87.667257   (42.00898884004581,-87.66725723420997)  \n",
       "49981 -87.667582   (42.01701924785849,-87.66758179030381)  \n",
       "49982 -87.662429   (42.00785750969186,-87.66242881817381)  \n",
       "49983 -87.706999  (41.865237246904975,-87.70699853404217)  \n",
       "49984 -87.683044   (41.76278714835731,-87.68304371614897)  \n",
       "49985 -87.664149     (41.998311432756,-87.66414899127476)  \n",
       "49986 -87.689032  (41.967961971899875,-87.68903213148234)  \n",
       "49987 -87.652167   (41.94368500653552,-87.65216734520399)  \n",
       "49988 -87.634487    (41.9086941456714,-87.63448689691725)  \n",
       "49989 -87.658699     (41.856962510283,-87.65869940789038)  \n",
       "49990 -87.610447  (41.782263477530066,-87.61044671992697)  \n",
       "49991 -87.609908   (41.80287663210569,-87.60990755107315)  \n",
       "49992 -87.615737   (41.77866641615929,-87.61573658958363)  \n",
       "49993 -87.609908   (41.80287663210569,-87.60990755107315)  \n",
       "49994 -87.685147    (41.99770079922752,-87.6851465642111)  \n",
       "49995 -87.578659   (41.75168267214598,-87.57865870399478)  \n",
       "49996 -87.758621  (41.881299199557894,-87.75862053499047)  \n",
       "49997 -87.640625    (41.7760739361563,-87.64062455203374)  \n",
       "49998 -87.621283   (41.80638088214982,-87.62128295874425)  \n",
       "49999 -87.735709   (41.88330951242491,-87.73570901056128)  \n",
       "\n",
       "[50000 rows x 23 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.apply(pd.Series.interpolate)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "unnamed:_0\n",
      "False    50000\n",
      "dtype: int64\n",
      "id\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_last_modified_date\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_date\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_code\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_status\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_status_date\n",
      "True     36488\n",
      "False    13512\n",
      "dtype: int64\n",
      "violation_description\n",
      "False    49624\n",
      "True       376\n",
      "dtype: int64\n",
      "violation_location\n",
      "True     32484\n",
      "False    17516\n",
      "dtype: int64\n",
      "violation_inspector_comments\n",
      "False    50000\n",
      "dtype: int64\n",
      "violation_ordinance\n",
      "False    48462\n",
      "True      1538\n",
      "dtype: int64\n",
      "inspector_id\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_number\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_status\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_waived\n",
      "False    50000\n",
      "dtype: int64\n",
      "inspection_category\n",
      "False    50000\n",
      "dtype: int64\n",
      "department_bureau\n",
      "False    50000\n",
      "dtype: int64\n",
      "address\n",
      "False    50000\n",
      "dtype: int64\n",
      "property_group\n",
      "False    50000\n",
      "dtype: int64\n",
      "ssa\n",
      "True     40639\n",
      "False     9361\n",
      "dtype: int64\n",
      "latitude\n",
      "False    50000\n",
      "dtype: int64\n",
      "longitude\n",
      "False    50000\n",
      "dtype: int64\n",
      "location\n",
      "False    49952\n",
      "True        48\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "for col in data.columns:\n",
    "    print col\n",
    "    print pd.value_counts(data[col].isnull())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}