IBM Notebook 2.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is the second notebook for this course. The question for this second asks which Borough in the city of New York the housing department should focus in, given the complaint type identified in the previous section. Therefore, the the dataset will be condensed to just the heating and hot water issues, and then the Borough will be identified."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# @hidden_cell\n",
    "# The project token is an authorization token that is used to access project resources like data sources, connections, and used by platform APIs.\n",
    "#from project_lib import Project\n",
    "#project = Project(project_id='58548218-d78e-4251-95d2-67ed44feff5d', project_access_token='p-17588375ba270ce7d8e2f7d2651fde17fb64de66')\n",
    "#pc = project.project_context"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/envs/Python36/lib/python3.6/site-packages/IPython/core/interactiveshell.py:3020: DtypeWarning: Columns (11,12,13,14,17,20) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unique Key</th>\n",
       "      <th>Created Date</th>\n",
       "      <th>Closed Date</th>\n",
       "      <th>Agency</th>\n",
       "      <th>Agency Name</th>\n",
       "      <th>Complaint Type</th>\n",
       "      <th>Descriptor</th>\n",
       "      <th>Location Type</th>\n",
       "      <th>Incident Zip</th>\n",
       "      <th>Incident Address</th>\n",
       "      <th>...</th>\n",
       "      <th>Vehicle Type</th>\n",
       "      <th>Taxi Company Borough</th>\n",
       "      <th>Taxi Pick Up Location</th>\n",
       "      <th>Bridge Highway Name</th>\n",
       "      <th>Bridge Highway Direction</th>\n",
       "      <th>Road Ramp</th>\n",
       "      <th>Bridge Highway Segment</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>44087643</td>\n",
       "      <td>10/18/2019 11:13:58 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HPD</td>\n",
       "      <td>Department of Housing Preservation and Develop...</td>\n",
       "      <td>HEAT/HOT WATER</td>\n",
       "      <td>ENTIRE BUILDING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>11232.0</td>\n",
       "      <td>4116 8 AVENUE</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.646018</td>\n",
       "      <td>-73.998627</td>\n",
       "      <td>(40.646017602662596, -73.99862705348652)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>44092484</td>\n",
       "      <td>10/18/2019 11:13:54 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HPD</td>\n",
       "      <td>Department of Housing Preservation and Develop...</td>\n",
       "      <td>HEAT/HOT WATER</td>\n",
       "      <td>ENTIRE BUILDING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>10011.0</td>\n",
       "      <td>195 10 AVENUE</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.746770</td>\n",
       "      <td>-74.004850</td>\n",
       "      <td>(40.746769679818215, -74.0048504742897)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>44089759</td>\n",
       "      <td>10/18/2019 11:13:49 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HPD</td>\n",
       "      <td>Department of Housing Preservation and Develop...</td>\n",
       "      <td>HEAT/HOT WATER</td>\n",
       "      <td>APARTMENT ONLY</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>10458.0</td>\n",
       "      <td>2420 WEBSTER AVENUE</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.859312</td>\n",
       "      <td>-73.893579</td>\n",
       "      <td>(40.8593120723137, -73.8935789282356)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>44084158</td>\n",
       "      <td>10/18/2019 11:13:36 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HPD</td>\n",
       "      <td>Department of Housing Preservation and Develop...</td>\n",
       "      <td>HEAT/HOT WATER</td>\n",
       "      <td>ENTIRE BUILDING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>10467.0</td>\n",
       "      <td>3150 ROCHAMBEAU AVENUE</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.874538</td>\n",
       "      <td>-73.880364</td>\n",
       "      <td>(40.87453769186875, -73.88036367689082)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>44086430</td>\n",
       "      <td>10/18/2019 11:12:55 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HPD</td>\n",
       "      <td>Department of Housing Preservation and Develop...</td>\n",
       "      <td>HEAT/HOT WATER</td>\n",
       "      <td>ENTIRE BUILDING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>10457.0</td>\n",
       "      <td>4215 PARK AVENUE</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.847863</td>\n",
       "      <td>-73.899225</td>\n",
       "      <td>(40.847863491304004, -73.89922497624548)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unique Key            Created Date Closed Date Agency  \\\n",
       "0    44087643  10/18/2019 11:13:58 PM         NaN    HPD   \n",
       "1    44092484  10/18/2019 11:13:54 PM         NaN    HPD   \n",
       "2    44089759  10/18/2019 11:13:49 PM         NaN    HPD   \n",
       "3    44084158  10/18/2019 11:13:36 PM         NaN    HPD   \n",
       "4    44086430  10/18/2019 11:12:55 PM         NaN    HPD   \n",
       "\n",
       "                                         Agency Name  Complaint Type  \\\n",
       "0  Department of Housing Preservation and Develop...  HEAT/HOT WATER   \n",
       "1  Department of Housing Preservation and Develop...  HEAT/HOT WATER   \n",
       "2  Department of Housing Preservation and Develop...  HEAT/HOT WATER   \n",
       "3  Department of Housing Preservation and Develop...  HEAT/HOT WATER   \n",
       "4  Department of Housing Preservation and Develop...  HEAT/HOT WATER   \n",
       "\n",
       "        Descriptor         Location Type  Incident Zip  \\\n",
       "0  ENTIRE BUILDING  RESIDENTIAL BUILDING       11232.0   \n",
       "1  ENTIRE BUILDING  RESIDENTIAL BUILDING       10011.0   \n",
       "2   APARTMENT ONLY  RESIDENTIAL BUILDING       10458.0   \n",
       "3  ENTIRE BUILDING  RESIDENTIAL BUILDING       10467.0   \n",
       "4  ENTIRE BUILDING  RESIDENTIAL BUILDING       10457.0   \n",
       "\n",
       "         Incident Address  ... Vehicle Type Taxi Company Borough  \\\n",
       "0           4116 8 AVENUE  ...          NaN                  NaN   \n",
       "1           195 10 AVENUE  ...          NaN                  NaN   \n",
       "2     2420 WEBSTER AVENUE  ...          NaN                  NaN   \n",
       "3  3150 ROCHAMBEAU AVENUE  ...          NaN                  NaN   \n",
       "4        4215 PARK AVENUE  ...          NaN                  NaN   \n",
       "\n",
       "  Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction  \\\n",
       "0                   NaN                 NaN                      NaN   \n",
       "1                   NaN                 NaN                      NaN   \n",
       "2                   NaN                 NaN                      NaN   \n",
       "3                   NaN                 NaN                      NaN   \n",
       "4                   NaN                 NaN                      NaN   \n",
       "\n",
       "  Road Ramp Bridge Highway Segment   Latitude  Longitude  \\\n",
       "0       NaN                    NaN  40.646018 -73.998627   \n",
       "1       NaN                    NaN  40.746770 -74.004850   \n",
       "2       NaN                    NaN  40.859312 -73.893579   \n",
       "3       NaN                    NaN  40.874538 -73.880364   \n",
       "4       NaN                    NaN  40.847863 -73.899225   \n",
       "\n",
       "                                   Location  \n",
       "0  (40.646017602662596, -73.99862705348652)  \n",
       "1   (40.746769679818215, -74.0048504742897)  \n",
       "2     (40.8593120723137, -73.8935789282356)  \n",
       "3   (40.87453769186875, -73.88036367689082)  \n",
       "4  (40.847863491304004, -73.89922497624548)  \n",
       "\n",
       "[5 rows x 41 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import warnings\n",
    "warnings.filterwarnings('ignore', category=FutureWarning)\n",
    "import types\n",
    "import pandas as pd\n",
    "#from botocore.client import Config\n",
    "#import ibm_boto3\n",
    "\n",
    "#def __iter__(self): return 0\n",
    "\n",
    "# @hidden_cell\n",
    "# The following code accesses a file in your IBM Cloud Object Storage. It includes your credentials.\n",
    "# You might want to remove those credentials before you share the notebook.\n",
    "#client_2e2f0b3c376d4e9586d0fa475f0d4cf6 = ibm_boto3.client(service_name='s3',\n",
    "    #ibm_api_key_id='ODq1RiDzqvK_ZHr2wJ_StMrShRahDkxYnRtHr-0ER_Th',\n",
    "    #ibm_auth_endpoint=\"https://iam.ng.bluemix.net/oidc/token\",\n",
    "    #config=Config(signature_version='oauth'),\n",
    "    #endpoint_url='https://s3-api.us-geo.objectstorage.service.networklayer.com')\n",
    "\n",
    "#body = client_2e2f0b3c376d4e9586d0fa475f0d4cf6.get_object(Bucket='edx1-donotdelete-pr-88qux6w8ehqfye',Key='311_Service_Requests_from_2010_to_Present.csv')['Body']\n",
    "# add missing __iter__ method, so pandas accepts body as file-like object\n",
    "#if not hasattr(body, \"__iter__\"): body.__iter__ = types.MethodType( __iter__, body )\n",
    "\n",
    "#df_data_1 = pd.read_csv(body, low_memory=True)\n",
    "df_data_1 = pd.read_csv('desktop/edx IBM/311_Service_Requests_from_2010_to_Present-2.csv', parse_dates=True)\n",
    "df_data_1.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Dropped as they are unnecessary for the current analysis\n",
    "df_data_1.drop(['Agency', 'Agency Name','Descriptor','Cross Street 1', 'Cross Street 2','Intersection Street 1', 'Intersection Street 2', 'Address Type',\n",
    "               'Landmark', 'Facility Type','Due Date','Resolution Action Updated Date', 'Community Board', 'BBL','X Coordinate (State Plane)',\n",
    "       'Y Coordinate (State Plane)', 'Open Data Channel Type',\n",
    "       'Park Facility Name', 'Park Borough', 'Vehicle Type',\n",
    "       'Taxi Company Borough', 'Taxi Pick Up Location', 'Bridge Highway Name',\n",
    "       'Bridge Highway Direction', 'Road Ramp', 'Bridge Highway Segment'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 5878742 entries, 0 to 5878741\n",
      "Data columns (total 15 columns):\n",
      "Unique Key                int64\n",
      "Created Date              object\n",
      "Closed Date               object\n",
      "Complaint Type            object\n",
      "Location Type             object\n",
      "Incident Zip              float64\n",
      "Incident Address          object\n",
      "Street Name               object\n",
      "City                      object\n",
      "Status                    object\n",
      "Resolution Description    object\n",
      "Borough                   object\n",
      "Latitude                  float64\n",
      "Longitude                 float64\n",
      "Location                  object\n",
      "dtypes: float64(3), int64(1), object(11)\n",
      "memory usage: 672.8+ MB\n"
     ]
    }
   ],
   "source": [
    "df_data_1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df_data_1['Unique Key'] = df_data_1['Unique Key'].astype(str)\n",
    "#df_data_1['Incident Zip'] = df_data_1['Incident Zip'].astype(str)\n",
    "#df_data_1['Closed Date'] = pd.to_datetime(df_data_1['Closed Date'], errors='ignore')\n",
    "#df_data_1['Created Date'] = pd.to_datetime(df_data_1['Created Date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unique Key</th>\n",
       "      <th>Created Date</th>\n",
       "      <th>Closed Date</th>\n",
       "      <th>Complaint Type</th>\n",
       "      <th>Location Type</th>\n",
       "      <th>Incident Zip</th>\n",
       "      <th>Incident Address</th>\n",
       "      <th>Street Name</th>\n",
       "      <th>City</th>\n",
       "      <th>Status</th>\n",
       "      <th>Resolution Description</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3203066</th>\n",
       "      <td>27612012</td>\n",
       "      <td>03/10/2014 12:00:00 AM</td>\n",
       "      <td>03/12/2014 12:00:00 AM</td>\n",
       "      <td>HEATING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>11204.0</td>\n",
       "      <td>1941 BAY RIDGE AVENUE</td>\n",
       "      <td>BAY RIDGE AVENUE</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>Closed</td>\n",
       "      <td>The complaint you filed is a duplicate of a co...</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>40.614998</td>\n",
       "      <td>-73.989468</td>\n",
       "      <td>(40.6149982706852, -73.9894681623791)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3203068</th>\n",
       "      <td>27612009</td>\n",
       "      <td>03/10/2014 12:00:00 AM</td>\n",
       "      <td>03/10/2014 12:00:00 AM</td>\n",
       "      <td>HEATING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>10462.0</td>\n",
       "      <td>850 MORRIS PARK AVENUE</td>\n",
       "      <td>MORRIS PARK AVENUE</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>Closed</td>\n",
       "      <td>The Department of Housing Preservation and Dev...</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>40.846336</td>\n",
       "      <td>-73.860730</td>\n",
       "      <td>(40.84633580720356, -73.86073043230446)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3203069</th>\n",
       "      <td>27612003</td>\n",
       "      <td>03/10/2014 12:00:00 AM</td>\n",
       "      <td>03/12/2014 12:00:00 AM</td>\n",
       "      <td>HEATING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>10451.0</td>\n",
       "      <td>940 GRAND CONCOURSE</td>\n",
       "      <td>GRAND CONCOURSE</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>Closed</td>\n",
       "      <td>The complaint you filed is a duplicate of a co...</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>40.828789</td>\n",
       "      <td>-73.921632</td>\n",
       "      <td>(40.82878868206092, -73.92163186542135)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3203073</th>\n",
       "      <td>27611997</td>\n",
       "      <td>03/10/2014 12:00:00 AM</td>\n",
       "      <td>03/12/2014 12:00:00 AM</td>\n",
       "      <td>HEATING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>11225.0</td>\n",
       "      <td>1171 PRESIDENT STREET</td>\n",
       "      <td>PRESIDENT STREET</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>Closed</td>\n",
       "      <td>The complaint you filed is a duplicate of a co...</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>40.668136</td>\n",
       "      <td>-73.951693</td>\n",
       "      <td>(40.66813589027507, -73.95169302261705)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3203074</th>\n",
       "      <td>27611996</td>\n",
       "      <td>03/10/2014 12:00:00 AM</td>\n",
       "      <td>03/12/2014 12:00:00 AM</td>\n",
       "      <td>HEATING</td>\n",
       "      <td>RESIDENTIAL BUILDING</td>\n",
       "      <td>10031.0</td>\n",
       "      <td>469 WEST 147 STREET</td>\n",
       "      <td>WEST 147 STREET</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>Closed</td>\n",
       "      <td>The Department of Housing Preservation and Dev...</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>40.826214</td>\n",
       "      <td>-73.945891</td>\n",
       "      <td>(40.826214349536365, -73.94589093829818)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Unique Key            Created Date             Closed Date  \\\n",
       "3203066    27612012  03/10/2014 12:00:00 AM  03/12/2014 12:00:00 AM   \n",
       "3203068    27612009  03/10/2014 12:00:00 AM  03/10/2014 12:00:00 AM   \n",
       "3203069    27612003  03/10/2014 12:00:00 AM  03/12/2014 12:00:00 AM   \n",
       "3203073    27611997  03/10/2014 12:00:00 AM  03/12/2014 12:00:00 AM   \n",
       "3203074    27611996  03/10/2014 12:00:00 AM  03/12/2014 12:00:00 AM   \n",
       "\n",
       "        Complaint Type         Location Type  Incident Zip  \\\n",
       "3203066        HEATING  RESIDENTIAL BUILDING       11204.0   \n",
       "3203068        HEATING  RESIDENTIAL BUILDING       10462.0   \n",
       "3203069        HEATING  RESIDENTIAL BUILDING       10451.0   \n",
       "3203073        HEATING  RESIDENTIAL BUILDING       11225.0   \n",
       "3203074        HEATING  RESIDENTIAL BUILDING       10031.0   \n",
       "\n",
       "               Incident Address         Street Name      City  Status  \\\n",
       "3203066   1941 BAY RIDGE AVENUE    BAY RIDGE AVENUE  BROOKLYN  Closed   \n",
       "3203068  850 MORRIS PARK AVENUE  MORRIS PARK AVENUE     BRONX  Closed   \n",
       "3203069     940 GRAND CONCOURSE     GRAND CONCOURSE     BRONX  Closed   \n",
       "3203073   1171 PRESIDENT STREET    PRESIDENT STREET  BROOKLYN  Closed   \n",
       "3203074     469 WEST 147 STREET     WEST 147 STREET  NEW YORK  Closed   \n",
       "\n",
       "                                    Resolution Description    Borough  \\\n",
       "3203066  The complaint you filed is a duplicate of a co...   BROOKLYN   \n",
       "3203068  The Department of Housing Preservation and Dev...      BRONX   \n",
       "3203069  The complaint you filed is a duplicate of a co...      BRONX   \n",
       "3203073  The complaint you filed is a duplicate of a co...   BROOKLYN   \n",
       "3203074  The Department of Housing Preservation and Dev...  MANHATTAN   \n",
       "\n",
       "          Latitude  Longitude                                  Location  \n",
       "3203066  40.614998 -73.989468     (40.6149982706852, -73.9894681623791)  \n",
       "3203068  40.846336 -73.860730   (40.84633580720356, -73.86073043230446)  \n",
       "3203069  40.828789 -73.921632   (40.82878868206092, -73.92163186542135)  \n",
       "3203073  40.668136 -73.951693   (40.66813589027507, -73.95169302261705)  \n",
       "3203074  40.826214 -73.945891  (40.826214349536365, -73.94589093829818)  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The two heating and hot water categories are separated out and recombined into a singke dataframe\n",
    "heat_df = df_data_1.loc[df_data_1['Complaint Type'] == 'HEATING']\n",
    "heat_df2 = df_data_1.loc[df_data_1['Complaint Type'] == 'HEAT/HOT WATER']\n",
    "heating_df = heat_df.append(heat_df2)\n",
    "heating_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "BRONX            572225\n",
       "BROOKLYN         545831\n",
       "MANHATTAN        400686\n",
       "Unspecified      282917\n",
       "QUEENS           229608\n",
       "STATEN ISLAND     17524\n",
       "Name: Borough, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The Bronx appears to have the most, by a small margin. But the large number of \"Unspecified\" Boroughs requries more breakdown\n",
    "heating_df['Borough'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAaAAAAE8CAYAAACGkmVhAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzt3Xe4HGXZx/HvLwkdQg0IAQwlKkgnFKWDQgCp0iwQEQR5AVGagChNFARREEGRLiIiFlDg5UW60kF6jYASaYHQO+F+/7ifJZPDKZuT7Jk9J7/Pde11dp5pz+zumXvmaaOIwMzMrK8NqjsDZmY2fXIAMjOzWjgAmZlZLRyAzMysFg5AZmZWCwcgMzOrhQPQACdpLUkP152Pnkj6iqS/150Pa46kJyR9psllX5O0eB/kKSQt2er9tJP+/n/jANTHOvvHnZY/oo7/hBFxQ0R8fFpsuy6SRpTjGtIh/WxJ329yG92eMCU9LGm7yvQaZZ8d017rmI/e7K+3JH1R0u0lH09LulzSmtN6P9NSRMweEY81s2w7BJHy/zixfMavSXpM0h515mmgcgAyS9cD61Sm1wYe6iTtxoh4r5UZUfrQ/6akfYGfAj8AFgAWBU4BtmhlfqZTN5XAOTuwDfAjSStO6UaauViZnjkAtSFJC0n6g6Txkh6X9I3KvFUl3STppXIFfLKkGcu868tid5crt+0lrStpXGX9JyTtL+keSS9L+p2kmSvzDyzbfUrSrt1dkUraWdKDkl4tV4m7V+atK2mcpP0kPVe2uXNl/rySLpH0iqRbgSWmwee2uaT7y2dzraSlSvqvyZP1X8rncmAnq19PBpiGtYBjO0m7vmxzCUlXS3pB0vOSfiNpru72J2l1STeW/N0tad1K3q+VdLSkfwBvAJMVWUmaEzgS2DMi/hgRr0fEuxHxl4g4oCwzk6Sflu/uqfJ+pjKv8X0cWPk+tpS0iaRHJE2QdEhlf4dLuqj8Pl6VdKek5bv43Lv8TZb5H/yGlHetP5d0adnuLZKWKPM6+/3OJ+mvZdsTJN3QWXCu2KT8Fp+XdJykQeVzmSBp2Uqe5pf0pqRh3WwLgIi4E3gQWKqyfqe/tTLvCUnflnQP8LqkIZKWKsu9VNbbvLL8tZJ2rUxPViIiaUPlHfrLkk6RdF11+bLM8ZJeVJ4vNu7pmNpGRPjVhy/gCeAzHdK+Avy9vB8E3AF8D5iRPBE9BmxU5q8MrA4MAUaQ/xjfrGwrgCUr0+sC4zrs/1ZgIWCesv7Xy7zRwDPAJ4FZgV933F6HfG9KBg6RdwpvACtV9vseedKcAdikzJ+7zL8AuBCYDVgG+G/jM+hkPyNKPoZ0SD8b+H55/zHgdeCzZX8HAmOBGbv63Dtsa1Hg/fKZDAKeA2YBnqykvQSsXZZfsuxrJmAYGZh+2tX3DAwHXiifw6Cy7gvAsDL/WuA/5bMfAszQIX+jy+c5pJtjOBK4GZi/5OlG4KgO38f3yufzNWA8cD4wR9nvW8DiZfnDgXfJq/8ZgP2Bxxv5qh4fU/CbLN/ZBGDVsvxvgAu6+f3+EPhFycMM5EWAujj+AK4p39eiwCPArmXeKcCxlWX3Af7SxXa+QuW3CKxSvvuPTcFv7S5gEfI3NEOZfwj5P70+8Crw8cp3v2sX54P5gFeArcvntU/5XnatLPtu+T4HA3sAT3X1GbXbq/YMTG+v8uN8rfygG683Kj+41YD/dFjnYOCsLrb3TeBPlelmAtCXK9M/An5R3p8J/LAyb8mO2+vh2P4M7FPZ75tUTpjkSX318o/yLvCJyrwf0HMAeqnD6x0mBaDvAhdW1hlEBrV1K8fdZQCqLLMFsCLwj5J2QSXtLWCmLtbdEvhnh21VA9C3gV93WOcKYEx5fy1wZDd5+xLwTA/5/xewSWV6I+CJDt/H4DI9R/lMV6ssfwewZXl/OHBzh8/zaWCtnj7P7n6TZAA6vTJvE+Chbn6/RwIXN/MbLOuOrkz/D3BV5f/qSWBQmb4d2K6L7XyFDNYvkf+rAfyMclJv8rf21cr8tcgLu0GVtN8Ch1e++64C0E5kcWBjnspxVAPQ2Mr8WUt+P9LM/2zdLxfB1WPLiJir8SL/URo+CixUbtVfkvQSeeW0AICkj5UiiWckvUKeuOebwv0/U3n/BjB7eb8Q+eNuqL7/EEkbS7q5FG+8RJ5Mqnl5ISavL2nsaxh5NVfd/r+byPd8HT638yvzFqpuIyLeL9sf3sR2GxrFcGsDN5S0v1fSbomIt+GDIpwLJP23fA/n0f338FFg2w7f65rAgpVluvu8XwDmU/d1CpN9BuX9QtVtRMTE8v7N8vfZyvw3mfRbmCw/5fMc12F7QK9+k139/jpzHHn38H+laO2gbpadLM9Ujj8ibiHvWtaR9Any4uqSbrZzc/mdzQ58hLxD/EGZ18xvrZqPhYAny3LVvDXz25zsfzIyyozrsMwzlflvlLfdfaZtwwGo/TwJPF490UbEHBGxSZl/Klk5PjIihpLBSdNo308DC1emF+lqwVK38AfgeGCBEhAuazIv48krzOr2F53i3E7uKfIk38ifyvb/W5KaGfa9EYDWYlIAuqGSdn1l2R+WbS5XvocvM/mxd9zfk+QdUPV7nS0ijulmnaqbyDuwLbtZZrLPgPxMn+pm+Z588P2UepeFu9hey36TEfFqROwXEYsDmwH7StqgmTzz4eM/h/yedgQuioi3mszDs+RvfbOS1NNvDSb/Lp8CFulQd7VoZfnXyTuXho9U3k/2P1n2Vf0f7dccgNrPrcArpRJzFkmDJS0jaZUyfw6yTPi1ciXXsXnos3SowJ4CFwI7lwrTWcn6gq7MSNZ/jAfeKxWfGzazk3IV/kfgcEmzSloaGNPLPDdcCGwqaQNJMwD7AW+T9SDQ3OdyPVnUtg7wj5J2L7AYsB6TB6A5KEWpkoYDB3TYVsf9nQdsJmmj8p3OrGwY0NTJJCJeJr+PnysbD8wqaYZyF/qjsthvgUMlDZM0X1n+vGa234WVJW1d7rq+SX6eN3eyXE+/ySkx2ecm6XOSliwn3leAieXVlQMkzS1pEbK+5HeVeb8GtiKD0LnNZkjSvGW9+0tST7+1jhp3XweW72xdMphdUObfBWxdvtMlgV0q614KLFu+8yHAnkweoPo1B6A2U07OmwErkJW+zwOnA3OWRfYHvkhWYv6Kyf/BIMvuzynFPNsxBSLicuAksiJ3LHnVDfnP1XHZV4FvkP+ML5Y8dVek0dFeZDHBM2S9wFlTktdO8vMweWL5GfmZbQZsFhHvlEV+SJ6cX5K0fxfbeISsp3o6Il4qae+TFwVDmfwEcwSwEvAyeZL4Y4fNTba/iHiSrEs6hAzaT5JBq+n/wYg4AdgXOLSyjb3IujeA75N1G/eQgfPOktZbFwPbk9/vjsDWEfFuJ8v19JucEocz+e93JPA3MtjfBJwSEdf2kOc7yJP6pcAZjRkRMY78TIJJd7hd+ZRKPyCyUcV4YO+ynZ5+a5Mp6ZsDG5flTwF2ioiHyiI/IesznyXv0n5TWfd5YFuyrvYFYGnyO/7Q/2R/1KhUM/uQ0rT0PrLivaV9X6y9SDqcrPj/ct15mZYknQk8FRGH1p2X3ijFeOOAL0XENXXnZ2r5DsgmI2krSTNKmpvsB/MXBx8bCCSNIJszn9H9ku2lFNvOVepdG/VrnRWF9jsOQNbR7mRxw7/IsnYPQWL9nqSjyLv54yLi8brzM4U+Rf4/Nor7toyIN7tfpX9oaRGcsmf46WRHwwC+CjxMlhGPINvLbxcRL5ZKxhOZ1GHxK5E9kJE0hiz3huz3cU5JX5msP5iFbIG1T0SEpHk620fLDtTMzKZYq++ATgT+NyI+ASxPVuYdRHYOGwlcVaYhK+hGltduZNNOSjA5jOxItipwWCkeoiyzW2W90SW9q32YmVmbaNkdkKShwN3k0B5RSX+Y7DH8tKQFgWsj4uOSflne/7a6XOMVEbuX9F+SPYevBa4pwQ1JX2gs19U+usvvfPPNFyNGjJhmx29mNj244447no+IHsfU60wrR2pdnKxLOEs5iOEdZLv8BSLiaYASIOYvyw9n8t7D40pad+njOkmnm31MRtJu5B0Uiy66KLfffnsvD9XMbPokqZlRTDrVyiK4IWQ/iVMjYkWyI1Z3RWGd9ZyOXqQ3LSJOi4hRETFq2LBeBXAzM+ulVgagceQgmLeU6YvIgPRsKRaj/H2usnx1GI3GsB/dpS/cSTrd7MPMzNpEywJQRDwDPCmpUfeyAfAA2Vu+MezKGLLnMiV9J6XVgZdLMdoVwIZleI25yeFerijzXlU+Y0XkqLHVbXW2DzMzaxOtflrf3sBvlA+negzYmQx6F0rahXz+ybZl2cvIJthjyWbYOwNExITShv+2styRETGhvN+DSc2wLy8vgGO62IeZmbUJD8VTjBo1KtwIwcxsyki6IyJG9WZdj4RgZma1cAAyM7NaOACZmVktHIDMzKwWrW4FN+CNOOjSPt3fE8ds2qf7MzNrFd8BmZlZLRyAzMysFg5AZmZWCwcgMzOrhQOQmZnVwgHIzMxq4QBkZma1cAAyM7NauCOqdasvO9q6k63Z9MV3QGZmVgsHIDMzq4UDkJmZ1cIByMzMauEAZGZmtXAAMjOzWjgAmZlZLRyAzMysFg5AZmZWCwcgMzOrhQOQmZnVwgHIzMxq4QBkZma1aGkAkvSEpHsl3SXp9pI2j6QrJT1a/s5d0iXpJEljJd0jaaXKdsaU5R+VNKaSvnLZ/tiyrrrbh5mZtY++uANaLyJWiIhRZfog4KqIGAlcVaYBNgZGltduwKmQwQQ4DFgNWBU4rBJQTi3LNtYb3cM+zMysTdRRBLcFcE55fw6wZSX93Eg3A3NJWhDYCLgyIiZExIvAlcDoMm9oRNwUEQGc22Fbne3DzMzaRKsDUAD/J+kOSbuVtAUi4mmA8nf+kj4ceLKy7riS1l36uE7Su9vHZCTtJul2SbePHz++l4doZma90eonoq4REU9Jmh+4UtJD3SyrTtKiF+lNi4jTgNMARo0aNUXrmpnZ1GnpHVBEPFX+Pgf8iazDebYUn1H+PlcWHwcsUll9YeCpHtIX7iSdbvZhZmZtomUBSNJskuZovAc2BO4DLgEaLdnGABeX95cAO5XWcKsDL5fisyuADSXNXRofbAhcUea9Kmn10vptpw7b6mwfZmbWJlpZBLcA8KfSMnoIcH5E/K+k24ALJe0C/AfYtix/GbAJMBZ4A9gZICImSDoKuK0sd2RETCjv9wDOBmYBLi8vgGO62IeZmbWJlgWgiHgMWL6T9BeADTpJD2DPLrZ1JnBmJ+m3A8s0uw8zM2sfHgnBzMxq4QBkZma1cAAyM7NaOACZmVktHIDMzKwWDkBmZlYLByAzM6uFA5CZmdXCAcjMzGrhAGRmZrVwADIzs1o4AJmZWS0cgMzMrBYOQGZmVgsHIDMzq4UDkJmZ1cIByMzMauEAZGZmtXAAMjOzWvQYgCRtK2mO8v5QSX+UtFLrs2ZmZgNZM3dA342IVyWtCWwEnAOc2tpsmZnZQNdMAJpY/m4KnBoRFwMzti5LZmY2PWgmAP1X0i+B7YDLJM3U5HpmZmZdaiaQbAdcAYyOiJeAeYADWporMzMb8JoJQL+MiD9GxKMAEfE0sGNrs2VmZgNdMwHok9UJSYOBlVuTHTMzm150GYAkHSzpVWA5Sa+U16vAc8DFfZZDMzMbkLoMQBHxw4iYAzguIoaW1xwRMW9EHNzsDiQNlvRPSX8t04tJukXSo5J+J2nGkj5TmR5b5o+obOPgkv6wpI0q6aNL2lhJB1XSO92HmZm1jx6L4CLiYEnDJX1a0tqN1xTsYx/gwcr0scBPImIk8CKwS0nfBXgxIpYEflKWQ9LSwA5kUeBo4JQS1AYDPwc2BpYGvlCW7W4fZmbWJpoZCeEY4B/AoWTrtwOA/ZvZuKSFyf5Dp5dpAesDF5VFzgG2LO+3KNOU+RuU5bcALoiItyPicWAssGp5jY2IxyLiHeACYIse9mFmZm1iSBPLbAV8PCLe7sX2fwocCMxRpucFXoqI98r0OGB4eT8ceBIgIt6T9HJZfjhwc2Wb1XWe7JC+Wg/7mIyk3YDdABZddNFeHJ71ZyMOurRP9/fEMZv26f7M2l0zreAeA2aY0g1L+hzwXETcUU3uZNHoYd60Sv9wYsRpETEqIkYNGzass0XMzKxFmrkDegO4S9JVwAd3QRHxjR7WWwPYXNImwMzAUPKOaC5JQ8odysLAU2X5ccAiwDhJQ4A5gQmV9IbqOp2lP9/NPszMrE00cwd0CXAUcCNwR+XVrYg4OCIWjogRZCOCqyPiS8A1wDZlsTFMatJ9SZmmzL86IqKk71BayS0GjARuBW4DRpYWbzOWfVxS1ulqH2Zm1iZ6vAOKiHN6WmYKfRu4QNL3gX8CZ5T0M4BfSxpL3vnsUPZ/v6QLgQeA94A9I2IigKS9yGGCBgNnRsT9PezDzMzaRJcBSNKFEbGdpHvppA4lIpZrdicRcS1wbXn/GNmCreMybwHbdrH+0cDRnaRfBlzWSXqn+zAzs/bR3R3QPuXv5/oiI2ZmNn3pMgCVQUeJiH/3XXbMzGx60UxH1NUl3SbpNUnvSJoo6ZW+yJyZmQ1czbSCOxn4AvAoMAuwK/CzVmbKzMwGvmb6ARERYyUNLq3PzpJ0Y4vzZWZmA1xTHVFLP5u7JP0IeBqYrbXZMjOzga6ZIrgdyX42ewGvk6MPfL6VmTIzs4GvmY6ojVZwbwJHtDY7ZmY2veiuI2qnHVAbpqQjqpmZWUfd3QG5A6qZmbVMdx1RP+iAKukj5NA2AdwWEc/0Qd7MzGwAa6Yj6q7k6NNbkyNM3yzpq63OmJmZDWzNNMM+AFgxIl4AkDQv+WiGM1uZMTMzG9iaaYY9Dni1Mv0qkz8K28zMbIo1cwf0X+AWSReTdUBbALdK2hcgIk5oYf7MzGyAaiYA/au8GhpPF51j2mfHzMymF810RHXnUzMzm+Z6DECSRgHfAT5aXd4dUc3MbGo0UwT3G7Il3L3A+63NjpmZTS+aCUDjI+KSlufEzMymK80EoMMknQ5cBbzdSIyIP7YsV2ZmNuA1E4B2Bj4BzMCkIrgAHIDMzKzXmglAy0fEsi3PiZmZTVeaGQnhZklLtzwnZmY2XWnmDmhNYIykx8k6IAHhZthmZjY1mglAo1ueCzMzm+70WARXngs0F7BZec1VfVaQmZlZbzTzPKB9yM6o85fXeZL2bmK9mSXdKuluSfdLOqKkLybpFkmPSvqdpBlL+kxlemyZP6KyrYNL+sOSNqqkjy5pYyUdVEnvdB9mZtY+mmmEsAuwWkR8LyK+B6wOfK2J9d4G1o+I5YEVgNGSVgeOBX4SESOBF8v2G/t5MSKWBH5SlqM0gNgB+CRZHHiKpMGSBgM/BzYGlga+UGks0dU+zMysTTQTgARMrExPLGndivRamZyhvAJYH7iopJ8DbFneb1GmKfM3kKSSfkFEvB0RjwNjyceDrwqMjYjHIuId4AJgi7JOV/swM7M20UwjhLPI5wH9qUxvCZzRzMbLXcodwJLk3cq/gJci4r2yyDhgeHk/nPKgu4h4T9LLwLwl/ebKZqvrPNkhfbWyTlf76Ji/3YDdABZddNFmDsnMzKaRZhohnECOhjCBLM7aOSJ+2szGI2JiRKwALEzesSzV2WLlb2d3VTEN0zvL32kRMSoiRg0bNqyzRczMrEW6vAOStAowX0RcHhF3AneW9M0lDYqIO5rdSUS8JOlasv5oLklDyh3KwsBTZbFxwCLAOElDgDnJoNdIb6iu01n6893sw8zM2kR3d0DHAQ92kv5AmdctScMkzVXezwJ8pmzvGmCbstgYJj1h9ZIyTZl/dURESd+htJJbDBgJ3ArcBowsLd5mJBsqXFLW6WofZmbWJrqrA5o3Ip7omBgRYyXN28S2FwTOKfVAg4ALI+Kvkh4ALpD0feCfTKpPOgP4taSx5J3PDmV/90u6kAx87wF7RsREAEl7AVcAg4EzI+L+sq1vd7EPMzNrE90FoFm6mTdbTxuOiHuAFTtJf4ysD+qY/hawbRfbOho4upP0y4DLmt2HmZm1j+4C0N8kHQ0cWoq1ACgdSq9uec7MbKqMOOjSPt3fE8ds2qf7s/6vuwC0H3A6MFbSXSVteeB2YNdWZ8zMzAa2LgNQRLxOji6wODkKAcD9pXjLzMxsqvTYEbUEHAcdMzObppoZisfMzGyacwAyM7NadBuAJA2SdF9fZcbMzKYf3QagiHgfuFuSR+o0M7NpqpnRsBcE7pd0K/B6IzEiNm9ZrszMbMBrJgAd0fJcmJnZdKeZZtjXSfooMDIi/iZpVnLsNTMzs17rsRWcpK+RTxf9ZUkaDvy5lZkyM7OBr5lm2HsCawCvAETEo8D8rcyUmZkNfM0EoLcj4p3GRHlYXKdPGDUzM2tWMwHoOkmHALNI+izwe+Avrc2WmZkNdM0EoIOA8cC9wO7k83cObWWmzMxs4GumFdz7ks4BbiGL3h6uPh/IzMysN3oMQJI2BX4B/AsQsJik3SPi8lZnzszMBq5mOqL+GFgvIsYCSFoCuBRwADIzs15rpg7ouUbwKR4DnmtRfszMbDrR5R2QpK3L2/slXQZcSNYBbQvc1gd5MzPr0oiDLu3T/T1xzKZ9ur/pQXdFcJtV3j8LrFPejwfmblmOzMxsutBlAIqInfsyI2ZmNn1pphXcYsDewIjq8n4cg5mZTY1mWsH9GTiDHP3g/dZmx8zMphfNBKC3IuKklufEzMymK80EoBMlHQb8H/B2IzEi7mxZrszMbMBrph/QssDXgGPITqk/Bo7vaSVJi0i6RtKDku6XtE9Jn0fSlZIeLX/nLumSdJKksZLukbRSZVtjyvKPShpTSV9Z0r1lnZMkqbt9mJlZ+2gmAG0FLB4R60TEeuW1fhPrvQfsFxFLAasDe0pamhzc9KqIGAlcVaYBNgZGltduwKmQwQQ4DFgNWBU4rBJQTi3LNtYbXdK72oeZmbWJZgLQ3cBcU7rhiHi6UUwXEa8CD5JPU90COKcsdg6wZXm/BXBupJuBuSQtCGwEXBkREyLiReBKYHSZNzQibiqDo57bYVud7cPMzNpEM3VACwAPSbqNyeuAmm6GLWkEsCI5ovYCEfF02cbTkhpPVx0OPFlZbVxJ6y59XCfpdLOPjvnajbyDYtFFF232cMzMbBpoJgAdNjU7kDQ78AfgmxHxSqmm6XTRTtKiF+lNi4jTgNMARo0a5UdMmJn1oWaeB3RdbzcuaQYy+PwmIv5Ykp+VtGC5M1mQSQObjgMWqay+MPBUSV+3Q/q1JX3hTpbvbh9mZtYmeqwDkvSqpFfK6y1JEyW90sR6IjuwPhgRJ1RmXQI0WrKNAS6upO9UWsOtDrxcitGuADaUNHdpfLAhcEWZ96qk1cu+duqwrc72YWZmbaKZO6A5qtOStiRbo/VkDWBH4F5Jd5W0Q8jm3BdK2gX4Dzm6NuSjvjcBxgJvADuX/U+QdBSTRuA+MiImlPd7AGcDs5DPJ2o8o6irfZiZWZtopg5oMhHxZ0k9NmuOiL/TeT0NwAadLB/Anl1s60zgzE7SbweW6ST9hc72YWZm7aOZwUi3rkwOAkYxhZX9ZmZmHTVzB1R9LtB7wBNkPxszM7Nea6YOyM8FMjOzaa67R3J/r5v1IiKOakF+zMxsOtHdHdDrnaTNBuwCzAs4AJmZWa9190juHzfeS5oD2IdsGn0BOSK2mZlZr3VbB1RGot4X+BI5qOdKZUBQMzOzqdJdHdBxwNbkWGnLRsRrfZYrMzMb8Lobimc/YCHgUOCpynA8rzYzFI+ZmVl3uqsDauZZQWZmZr3iIGNmZrVwADIzs1o4AJmZWS0cgMzMrBYOQGZmVgsHIDMzq4UDkJmZ1cIByMzMauEAZGZmtXAAMjOzWjgAmZlZLRyAzMysFg5AZmZWCwcgMzOrhQOQmZnVwgHIzMxq4QBkZma1aFkAknSmpOck3VdJm0fSlZIeLX/nLumSdJKksZLukbRSZZ0xZflHJY2ppK8s6d6yzkmS1N0+zMysvbTyDuhsYHSHtIOAqyJiJHBVmQbYGBhZXrsBp0IGE+AwYDVgVeCwSkA5tSzbWG90D/swM7M20rIAFBHXAxM6JG8BnFPenwNsWUk/N9LNwFySFgQ2Aq6MiAkR8SJwJTC6zBsaETdFRADndthWZ/swM7M20td1QAtExNMA5e/8JX048GRluXElrbv0cZ2kd7cPMzNrI+3SCEGdpEUv0qdsp9Jukm6XdPv48eOndHUzM5sKfR2Ani3FZ5S/z5X0ccAileUWBp7qIX3hTtK728eHRMRpETEqIkYNGzas1wdlZmZTrq8D0CVAoyXbGODiSvpOpTXc6sDLpfjsCmBDSXOXxgcbAleUea9KWr20ftupw7Y624eZmbWRIa3asKTfAusC80kaR7ZmOwa4UNIuwH+AbcvilwGbAGOBN4CdASJigqSjgNvKckdGRKNhwx5kS7tZgMvLi272YWZmbaRlASgivtDFrA06WTaAPbvYzpnAmZ2k3w4s00n6C53tw8zM2ku7NEIwM7PpjAOQmZnVwgHIzMxq4QBkZma1cAAyM7NaOACZmVktHIDMzKwWDkBmZlYLByAzM6uFA5CZmdXCAcjMzGrhAGRmZrVwADIzs1o4AJmZWS0cgMzMrBYOQGZmVgsHIDMzq4UDkJmZ1cIByMzMauEAZGZmtXAAMjOzWjgAmZlZLRyAzMysFg5AZmZWiyF1Z8DMzD5sxEGX9un+njhm0z7dH/gOyMzMauIAZGZmtXAAMjOzWgzYACRptKSHJY2VdFDd+TEzs8kNyAAkaTDwc2BjYGngC5KWrjdXZmZWNSADELAqMDYiHouId4ALgC1qzpOZmVUoIurOwzQnaRtgdETsWqZ3BFaLiL06LLcbsFuZ/DjwcB9mcz7g+T7cX18byMc3kI8NfHz9XV8f30cjYlhvVhyo/YDUSdqHIm1EnAac1vrsfJik2yNiVB377gsD+fgG8rGBj6+/60/HN1CL4MYBi1SmFwaeqikvZmbWiYEagG4DRkpaTNKMwA7AJTXnyczMKgZkEVxEvCdpL+AKYDBwZkQ3AXB6AAAb0UlEQVTcX3O2Oqql6K8PDeTjG8jHBj6+/q7fHN+AbIRgZmbtb6AWwZmZWZtzADIzs6kiqbOWxz1yALK2J2m+uvPQVyRtJGl03fmwyUmaWdJCdeejXUWlLmdKgpEDUD8g6TBJ69Sdj76kNEjS9sCv685PXygtNpcEDqg7L9OSpFklXShphbrz0huS9gRuB9aRNFvd+WknkraXdKqk/SVtBJMHo544APUPi5N9maYLkmaN9D5wJ/C6pC/Una9WkPQRSd8EqAwb9aykb9Sbs2lD0uCIeIMcZeSQuvMzJSTNJuk84LPAjhHxW+DtmrPVFiStKOlCYE/gKmAx4HhJ+0zJdhyA2ky58v+EpGMlDS3JHwEeacyvL3etJ2kz4CFJe0oaGhGPAn8CdpI0a83Za4UjgRMk/ULSVhHxAnAesJWkBWvO21SLiInl7W3AMpI+W2d+miFpzvJ2AWChiNgyIv5ZLozeqyw3oP8XuyJpBuAW4KmIWDsiLoqIPclgdLCkRZvdlgNQG5E0X7l9fY286zmvXAm/CswBU3Z7259I+nTpu/U0MBuwOXn8SwFXkgF4vxqzOM2UoraGn5En5/8AR0j6MvBf8pj73WNEOp6UJa0l6UFgTeAZ4OBaMtYkScOBGyV9HPg3MFTSHpL2BQ6TdL6k70maPSJiegpCknaRtH1EvAscAaxc0geXO93rgb+TF1VI6jG+OADVrMMP+CZJ+0TEOGB78ov8OLAVMKJaGT8Af/jDgSUj4nbgIuAm4Fbgu8DewO+BtSQtXl8We6/UZ80v6XIqgSUi7iWP9X2yiGpx4BSyyGpFScvUkd/ekDSokwukVYCTIuJAYHfgNUltdyHRuCiIiP8CNwJ7lbu3g4GvAhsBz5FBaSng2LL8gLwg7MJE8jE3RMTRwHBJXy2f0wxlmUOBVSXNWYrQu+UAVL9qMcu3KBXQEfF+ORl/F7gHWB/4X0mfKvP79Q9f0kyS1pY0S0laFni3vD8FWAf4CxmElwO+Qt4ZfbWPszrVJM1Q/hnHA4sC35J0QKVV1U/IE9xbEXEk8L/AlsCnafM7hqqIeF/SfOXYPl6SVyAvLgAeA84ln881dy2Z7KA0kPgbcJWkzUvywcDaktaPiCuBDSJiI+DkiDiYbBSjUhQ1YEkaLunkcuE0KCLOBh6R9IOyyLeAowEi4q2StixwH/BWMxfJDkA1KPU8M0n6KfmF7ljKl/8KPFDSG94DZgT2AH5Fnrz+PADqB7YF9gd+I2kt8m5nAkBE3A3cDOwZEQ+Rwec68m7wS5I+WkuOe0H5NN79Sn3ePMDvyIuMpYBDJI2MiH8DfwV2LUU7R5GfzZXA3TVlvUeSNqjeoUn6KvA3YCiwh6TDgWOA7STNUa6U3wLmBQ6rIcsfKCfXbUsDiZuAuYGTJO1c8ngCcKCkmSPilXICfrt8j3sAj5aiqAGlQ9DYDPgfskSi0TJzF2AvSfNGxMXAw5J+VNadCdgA+EdEvN3URXJE+NWHL8rwR+X97mRl3l3A2WRLt2Fknc/CZZn5yg9g9jI9M/C5uo+jl8c+fydpY8iT7wvA4ZX0ocDVwOaVtNWAJeo+jiaPdQvgDuBMYEQl/VJgq/L+IOCfZGW3gD8DXwdmLvNnqPs4ujm2PYAvkuNJDinp3wVmAj5FNls+vqSfVY5td+CPwDZk5X5d+T+k/M8dXqZXL2m/Ar5BFsEtRl4UbVu+m08CpwL3A9+p+zto4WczR+X9YuTd+Y/JC8Lvk3ezJwAXlWU+BrwIfJsM5L8CZmt2fx4Lrg9JOpg8sd5Djs49E3llMZ5sZPAp4HhgO2DuiNi2FFXcCKwbEc/WkvGpVIoqPk2eoD4XEW+VYql3y/wFybucFYD/iWwJhqSvkyOZbxsR42vJ/BQqdwSHAyOBhYDhEfFOuZJ+q1xhjyIbH5xAHvMl5fU68AXgmzGpSKOtlEYS3wLWBd4BdgUei4jLJd1JNlN+haz3ubRURAvYGhgNXBgRV5RtDYom6gmmYd5XIk+Qj5G/s/ElfTDwZWAN8qLgq8CcwE7AWPI7EbAjcH5EPFXWUwyQE6ikechBTAXsUPnf3JW8QHqMrOfZDfhlea0eEfdI+hWwErBzRNwzJft1EVwfkLSspDvIViN3A18CLiTrNK4j73yuICvwdijpn5e0JmU0b7IvTL9peNDIq6QjyOMdBzzOpCfQftCcNSKeJo/xGfIquZH+C+DE/hB8JM0u6QTgN8BVEbE8+U96Slmk0X9kHFm/dXl5LUbeAf4cuDkivt5uwUfSLOW3CPkdzgB8jbxz+CSwZmkgcy5517ZRCT5DyRP6QhHx+4jYpRJ81FfBR9InJS0GzEK2sjwwIsZLWkXS+cAIsvXWS2R/n+PJq/47gPWAL0bEsxFxfEQ81WjdNVCCT/Ei2Ql6DeCbkjYp6ZeR56OPRsS55F3Qx8mSmN8DRMTXImLlKQ0+lJX9av1t7V7APpXpIWQrmivK9PeB7wGzkv/c3yBbRV1Ud96n4pgHl79/AVYo7zcmT7YjyvQgYFDl/frAtY3l+8uL7P/wUPkO56ykL052pF2jkrZMWXbmDtuYse7j6Ob4Pg2MKe+3IVtD3VqmP05Wyn++HO81wHFkkdZ95bc9uLKtQX2Y77nJC4CbgbVK2vHAD4DzS/pXK8tvSRazrV2m5+lvv8Vefk6N/9VvAD8lLxjvBpYt6RuWz3F0mZ6RvFj+7tR+p74DagFJHZ+z9BnKY8JL0dN7EfFt4GOS1iXreOYDNo2IdyPiJGDpiNimL/M9tUrjigUlHQ3MU4oPFwaeLIvcDtxLBmTI+rD3IVtQMakurC+fZ99rktaTdB1ZbzMxIo6MiJclzVCu8B8DziEDEwARcR/wBlnB+8GdYuQoCG2jfJeNK/0bgasl7QT8H3m8g0vDmYfJeqw1ycr7MeTJayFgm4g4NCZ1Rm18z32R/73Ii5kJwDoRcUOZ9Uuy2HMIWax9ZqVk4VbyLmjzktcJEXFX2V6/KX3oSaMRT+W31/h+hgL/iojfkCUSv5S0WUT8H/AE8FlJS5Tf6g8iG8tM1XfqADSNlR/+5ZIOqjRFfQh4WdKQiHi3lDlDXm2tRv7DTgBWkTQMILL1V78S6WlgbfJuZzvgvoh4oZyQx5OV0R+TtGpETFQ+tfZESUuWf/izI/tBtbVSZr418KOIWJYcvWHfMvv9KJeGwBnAEEk7lvXmIv+574f2LMYpdTMR2ax6wdK6aV7yzmHhiPgV+Zs9oaxyDtl4ZnvghYg4LyL2ioiHlP2f+uzk3fj/IfsfPVoC4NuStpS0b+TIGn8jOzYvCPkdSPoc8Cb53fyw43bb8XvqDUlrk/0NZ20cU+X7eRTYVNISZN9DAd9WjoV3M9lZ+mWYhhcSdd/+DZQX2az2IbLFz2jyruYHZJDfB/gFsHhMfst7HvD18n4ksEDdx9HLY/822SLqU2V6NFn0di6wd4dl5yQrsRvlyU8AP637GJo8ziFkEdR8nczbgDwpz12mB1XmbUF2YGzLVm3dHOvRZIfYVUraYWQjAsjWT3dU5m0HbNRhG31W3Fb2txXZynBWYH7yhLoDOb7ejUwqWluQvNPenKw8P4+8M/9kZVvqy7y3+HOZj2wO/7EyfQnwvY7HCcxOllY8CexS0lYi66cXbEne6v5wBsqLLNt/nkn1G5uQLWYgy5IvBA6s/AgWKP8sa9SR32l0zBsCDwC/Bb5T/on3K0H3KLLi/Rbg4hJslqp8Vv8gK+GH130cU3C8B5F1c2cyeXPVRmvSX5KdFTv+Y4ustJ+5HU9snQUK8qLiPCav0xpWvs9Ny/QPyQYXbZH38rv7K6Veh6zTeBX4WifrfZksEn4Y2KPu76CFn8++5IXRL4DFStrSZKu2xSrLiWxi/XtgmUZa9W9L8lf3B9RfX2TrtO+SV35LlrTDgD+X93OWADOiTI8iK2fvKz+GByiVeP3xRTaWOB3YpJK2DtnMdS+yyObvJRB/niyKup5s9bc9ME/dx9Dkcc5Veb8UeTV4GXl3u2FJbzSkGEnWhyxfpofUnf8mjq96Ah9W+W7/xKS7m1kqy4wB/tlIp1xQ1ZT3pclK80UqaVuQI0ksWqbv4sN3ZmuWv1tR6bNCH9+x9cHnsxpZZzesk3knA+eV90Mq6Q8yqcFJyy+WXAfUC6Vt/NXkEDHLkyddgJOA+SWdQl4pLgRcJGmviLg9Ig4giwRuIIsDjur73Pdeh7L8Wchmm09V0v5BdjT8DNlS6gqyaOriiNilvD8iIn4XERP6Jte9p3ww3HGaNDryHGSrtkPJq8oflfLyAIisX7iI0vQ6KiMnt6vIep7hks4CzpJ0AFkZ/TT5WyUi3gQozaovAO6V9DFy6KBH+rqCXtIypS5tNrLv1AeNdSJ75z8L7FySfkDejSNpXUlXA7tLmi0i/hQRr1caW/RZn6RWKA1H5pF0ekmagayzeV7SApLWkLSOpJnJkTZWkfSpiHhP0qqSziFLMR6EPqr3qjtK97cXWbb8PpNuU4eTdzSzlOkxZGXmSmV6W7Ko6U/AvHXnfyqO+2CyyGV7snnrfOQdzbxlfuN2fXEyII8sy/2TbN7ats2MuznmdYATmVSkM5Ss52vU8zxONjvetbLO3GSHvA8+k3Z6Man+sfF9zUA2Sf5i+e7+Qdb9jCArndcmLza+Dxxdc94/Shax3UkG+l+TTeBPBFauLLccWefTGE3kGrKu8Vpgi7q/gz74nF4gixg/QjZ0uocccf03ZDXBWeTF407khfJp5fPZr8/zWveH1R9fZNHT9uX9leRVw7GUYiWyku/rleXnokMxQH95kYML3lH+4XcoJ4BLySK23wI/LstVb+MfIXtJQz7M60ND8LTbiywD/wxwQGO6/N2WynA6ZD+Sv5eT4O/JiuwH6dDYot1eZP1ItV5q1vJ3cbKuZ+1ygj6j8X2RRannlpPX2VQqoun7BgZzkMVJ36nk+7QSaPYDjqrmi7wTb6R9jBzderLvu+7vpAXfb2NIpM+Sz+qBHG1lT2BVsshyJNnJ9htl/jVk3WXTw+dM03zX/cH1xxd56/9uubL4NnmlcQ7whzJ/HbII40Nlr/3tReedaH9EuaMjh6hfhXKHQ/axuJBK3Um7vyrBZWXy7namMr1cCTa3AfuXtL3Jq8ZPV9ZfExhV93E0eaxLkxcQ55fgORPZ/+VByl19We5TlfeLV97XcuIuAfK3HdJmJJ/GeSJZv7pNZd4PyVGsO25nwNTzkI15Dq0eF5MunK6gNIjpZL0zyBEfoEOH6L5+dewwaU2ILDfeDdgsIo6FD+qFXigdta6TdCjwbun/0vqy1Gmk9FWq1l18hrwybnSifZccJfjfZJHI/mQQHizpGfJEcXJEvNS3OZ8yje9F+TiIf0laPSJuUz6C+Q+S7iGP/RTyYuLzyofjPQm8GRE3NvpzRcTf6zqO7igfEjax8Z7sELskeUc3J9k4ZCmynmTviLhPOaTOceTQTw9FxIuRHWr7fOy2Dt4DlmhMlN/pO6Xu6jvkhdLpyqfmfpG8kDix40ZqzH8rvEmOjv+niLi/0r9wItnq8j5Jx0XEvyXNSz4K5ACy2uDHMNljFGrhRgi9dw754KUly/RK5NVYo6PWGRHxUj8LPlPSifYU4DOR40P9D1m+/C+y6O3UPs/8lGs8YfZN8gTcOFntRg49MyIiVo18Bso9ZH3IF8v7GSV9NCImRqWXf7vo2MO99HwPsiXmyIj4A1nsdjI5AO4dwL+V46JdTVbifysiXqxut+aT9zjyUSWf65D+V7KP1a3k73B+snXXJhHxTB/nsaWUTx49pDQAISL+RY4heFyZnhjZuXtwRPyHvND4WVl9PbI+6M6IWCciHqjhED6s7tvI/vwi/3nvJB+adjuVcaX604ved6Ldre689+JY5yF7wj8AbF1JfwLYqbw/ELilw/FuWD6fzwJD6z6OJo91CzJgHkl2G1iOfNx3oz/ICLIobnGyaHUolcck0EbFVSX/3yGbXc9dSV+PLhpHtFP+p8Hxz1R+e++TRcCN+q1Zyjno85XPqVrX935ZT5R6v3Z61Z6B/v4iK/FOotQb9McX01En2vKPfBRZef1oOanNTg6E+kxluUeZfKDK2SmtqtrxRWXAzzK9Evl8lk91SP8hcHV5vyzZ6u0jHZaZrMFCu7zIIqRTyEY+y5ENRP7NpLrYGcpybZf3qTjmNcvxbld+u78o3+HN5EXiWiUI31NZR0xqkLA5pQN4O778PKCpVC1n7y9KMdohZC/wOyNirKTDgBUjYsvS7+V88omkT0gaRTa/3pislG9UCLd9PyZJM5LFar+JUqSkfKz5RmRZ+btkM/Evkk8rvTgivi9ps/K+3xRTl/4ds0WOvbcp+T09Qz5vallyHL7Hyabxt5D1KtdExM9ryvIUK+PS/ZhsgLAoWYw4GHguIm6qM2/TkvIZWUeRF4cnR8R5JX1L8llMN5DFqj8gLw6PJh9dcnp/Oic5AE1nSmOJHcnWa4+QrbnWU45cfSnZc3x9soJzInB2RJxc1l2G7Hh7RUT0lxGrv05eNZ8MnBJlkNcycOi85BXluuQJel2yovtj5ST+jTL/3WizfxRJa5C9/X9bpr9Itk68gbzzOYUcc2+pMr0hOeDtYWTjij3J776tjqtZkmaMNhtBfFopDUHOIodBWrukiaxfvUn53KnxZN3PemSd5f7kxdRiEfFyPTnvhbpvwfzquxfTSSdaJh8+ZwRZ3/MLst/INiX9E2R9wtfJIovZyKLU9ylNW9v5RV71ngRsSvZBO7kcU+N5Q6t2WH4TcoDYGcvrBiY1Le93RVZMungeSPU825IXhduSgaUx5NH25F1ro8n1KmQd7EaVdb9bfuNz9Kfv03dA05kyTMeVEfE7SVeSfZguA46NiAmSLgEui3waaePxAatFeZJluypXiDOSRYczk5WybymfhLkHOSDq7GSxxj6RV5LbkGXof46IayTNTg6O+nA9R9G1UiQzV0Q8WKaXIIebeZlsTn0f2fn5PUnfInv8r6t8DPUB5J3dERFxaVn/02TfrWv7/misStKK5N3rJ8mGMTeX9EYH4buA42LSM42QdDD5v3taZBPsOpvI91q/Kd+2aWYf4LzSz+VvZAuZjzBpPLsfA4dp0nOJXmr34AMfPIvobbLRxEjgq2XWK2QH04fLccwNnChp/4i4iPwfGCVppoh4rR2DT7EdOfQM8EET3EfIoHsrGVwXKrNPBGaTtDPZb+kvkU3KL62sf6ODT33KuG2DlONGnkbWx/6ByqPqyREeJpJN4m/osIkzyO/+Tai9iXyvOQBNZyLidbJSfmxEHBvZV2JXJj3t8DpysM13+3qQyd6Q9DlJy5b3s5J9sc4HNpb0iYh4gfznvk7SXWR9yNeAfSTtQvbn+nkJXu3sdLKj886VtEvJk9AjZBPqrSTNUk5GxwBLRMT4iDgfPmh8Yu2h8TTgKyJilYjYi2wgsmPpHE1EPEsOd3X8BytJ+0r6K/B2ROwRpZNwf+UANH0aEJ1oJS1ANlH9maSFIuINsvhtZrJYsfHo7+vI58LsHRE7RcTdZLn6DZGjlL9RQ/anSLlwOBnYq7QEowTXO8l6rp+SLfmWKfP+EBGHdthGv2gZNVCVu55VJV1KtiglcvTuhlvIc/LnGwkRcQiwpKTjJf2N7Ey8d/SnhgbdcACaDpUrr22BCyUdSfam/kv0k5ZtDeUK8Udk/cZmkr5MFiWOIAeIXVjSKmQfp+ci4gZJM5Ty8hsj4pG68t5LfyUbVBzWSCgnsI3I/jx/IYtsPqDyqAGrV2kaHWSH39XJx3xs0mGxO8nHfKwpaeFK+jFko4RjI+KLEfF4n2S6D7gRwnRM0jXkifqAflAE1alSXPEsOQDsEeQJ+h3gBLJV3/JkE9XbgHUj4smasjpNlGFYriJHJr+dfOrnqsCXYoA2S+7PSrHwEWTn38slrU22SHwA+BJZjHpKlPEXS1eHLwHPR8SPa8p2n/HV0fTtMxHxjf4afOCDsdwOJIufdiGbIm9FPg78MvK5RUsDy/X34ANQ7tqOA3YnixY/SVZSvwMfemig1aj0QbuZbOb/j5J8P/kAvSvIi4iVmHzQ1PvJ4LScpEX6Lrf18B2Q9XulmOlJsiPpWPJu6MYye2h/K1pshqQh5NBJY8t0v2yGOxBJWp/sl7Mw8EREfLakzxg5gvePyYA0nnwWz1Cyfu/qiLi1NLl/dyD+bjvyHZD1e+XEuw1wbmmOfW1EvFNeA/KfOCLec/BpL5Lml/RJsnPzCcAa5CjjXymLvFcuHF4nOw+fRPbR+jTZEfpggIh4eqD+bjvy84BsQCgdS0PSchFxT9356UsOPvUqzduPIIvUvgaMiYg3yziEfwO+KOniyLEI35f0GPlMqRUr2zh8emyl6DsgG0jWmt6Cj9WrdNj+I1nXuF5EXAO8Ve5K3wGuJ0fs3rOy2hXAm5JGNBKmx+ADDkA2gEyv/8RWq6HA7BHx9Yh4UtLQ0ty6Ubn+LBmgVpW0dElbhByZ/JW+z257cSMEM7NeKp2hTyWbxM9B1uV8kix6+3VEjCujW+9NjrL+hdoy24YcgMzMeqm0wFyT7BD9L+BaYEGySG5iRHyrLLcC8ImIuECS2n2Ukb7iAGRmNpUqTawHR8RESbsD80c/eGhjnVwHZGY2lUrwGVSCzxLAF8iHPlo3fAdkZjaVSv+e5cmn0DYeo316vblqfw5AZmbTgKTh5KPPz+/Pw1v1JQcgMzOrheuAzMysFg5AZmZWCwcgMzOrhQOQmZnVwgHIzMxq4QBkNo1JmijpLkl3S7pT0qdrzMtXJJ1c1/7NuuPnAZlNe29GxAoAkjYCfkg+pbVHjaFcWpk5s3bhOyCz1hoKvAigdJyk+yTdK2n7kr6upGsknQ/cW9L2LcvdJ+mbJW2EpPsaG5a0v6TDy/tVJN0j6abGPip5WEjS/0p6VNKP+uawzXrmOyCzaW8WSXcBM5MjI69f0rcGViCHbJkPuE3S9WXeqsAyEfG4pJWBnYHVAAG3SLqOEsi6cBawW0TcKOmYDvNWAFYE3gYelvSziHhyqo/SbCr5Dshs2nszIlaIiE8Ao4FzJYkctv+3ETExIp4FrgNWKevcGhGPl/drAn+KiNcj4jXygWZrdbUzSXMBc0TEjSXp/A6LXBURL0fEW8ADwEenxUGaTS0HILMWioibyLudYeTdTFder7zvarn3mPx/duYelm+ojks2EZd8WJtwADJrIUmfAAYDLwDXA9tLGixpGLA2cGsnq10PbClpVkmzAVsBN5CPd55f0rySZgI+BxARLwKvSlq9rL9DSw/KbBrxlZDZtNeoA4K8OxlTnhPzJ+BTwN1AAAdGxDMlSH0gIu6UdDaTgtPpEfFPAElHArcAjwMPVVbbBfiVpNfJp3K+3JIjM5uGPBq22QAgafZSX4Skg4AFI2KfmrNl1i3fAZkNDJtKOpj8n/438JV6s2PWM98BmZlZLdwIwczMauEAZGZmtXAAMjOzWjgAmZlZLRyAzMysFv8PWN/3O+M7TuYAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "heating_df['Borough'].value_counts().plot(kind='bar', rot=30)\n",
    "plt.xlabel('Borough')\n",
    "plt.ylabel('Number Complaints')\n",
    "plt.title('Heating and Hot Water Complaints by Borough')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GRAND CONCOURSE             36047\n",
       "BROADWAY                    23626\n",
       "OCEAN AVENUE                17946\n",
       "ARDEN STREET                15848\n",
       "MORRIS AVENUE               15826\n",
       "ST NICHOLAS AVENUE          14994\n",
       "AMSTERDAM AVENUE            11880\n",
       "ELMHURST AVENUE             11002\n",
       "BOYNTON AVENUE              10821\n",
       "DR M L KING JR BOULEVARD    10055\n",
       "OCEAN PARKWAY               10016\n",
       "WALTON AVENUE                9604\n",
       "BAILEY AVENUE                9571\n",
       "RIVERSIDE DRIVE              9241\n",
       "LINDEN BOULEVARD             9190\n",
       "SEDGWICK AVENUE              9130\n",
       "DECATUR AVENUE               9121\n",
       "NOSTRAND AVENUE              8868\n",
       "CRESTON AVENUE               8708\n",
       "SHERMAN AVENUE               7904\n",
       "BEDFORD AVENUE               7581\n",
       "SHERIDAN AVENUE              7507\n",
       "EASTERN PARKWAY              7474\n",
       "3 AVENUE                     7394\n",
       "WALLACE AVENUE               7314\n",
       "2 AVENUE                     7208\n",
       "DAVIDSON AVENUE              6855\n",
       "FT WASHINGTON AVENUE         6720\n",
       "NEW YORK AVENUE              6677\n",
       "VALENTINE AVENUE             6581\n",
       "                            ...  \n",
       "FORBEL STREET                   1\n",
       "BAY 16 ST                       1\n",
       "269 STREET                      1\n",
       "BRIGHTON    2 PLACE             1\n",
       "MIAMI COURT                     1\n",
       "EATON COURT                     1\n",
       "FARRELL COURT                   1\n",
       "CURRIE AVENUE                   1\n",
       "MANHATTAN AVE                   1\n",
       "SUFFOLK DRIVE                   1\n",
       "KATAN LOOP                      1\n",
       "BENEDICT ROAD                   1\n",
       "COLUMBUS AVE                    1\n",
       "FIELDSTONE TERRACE              1\n",
       "BARCLAY STREET                  1\n",
       "183 ST                          1\n",
       "43 ROAD                         1\n",
       "BARUCH PLACE                    1\n",
       "CONSTITUTION PLACE              1\n",
       "SIXTH AVENUE                    1\n",
       "LORRAINE LOOP                   1\n",
       "HUTCH RIVER PARKWAY SR          1\n",
       "BACHE STREET                    1\n",
       "WILLETT STREET                  1\n",
       "LAMPORT BOULEVARD               1\n",
       "NORTHPORT LANE                  1\n",
       "PAXTON STREET                   1\n",
       "WIMAN PLACE                     1\n",
       "DOVER STREET                    1\n",
       "GRIDLEY AVENUE                  1\n",
       "Name: Street Name, Length: 5982, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Identifying unspecified Boroughs by street name is probably not efficient\n",
    "heating_df['Street Name'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11226.0    65766\n",
       "10467.0    63000\n",
       "10458.0    62422\n",
       "10468.0    55202\n",
       "10453.0    55035\n",
       "10452.0    47628\n",
       "10457.0    43498\n",
       "10040.0    43400\n",
       "10031.0    42835\n",
       "10456.0    42206\n",
       "11225.0    40908\n",
       "11213.0    38768\n",
       "10462.0    37796\n",
       "10463.0    36247\n",
       "10032.0    34785\n",
       "11212.0    33174\n",
       "10472.0    32367\n",
       "10460.0    31487\n",
       "10033.0    30724\n",
       "11233.0    29488\n",
       "11203.0    27998\n",
       "11221.0    27410\n",
       "11216.0    25440\n",
       "11207.0    25341\n",
       "10451.0    25222\n",
       "10034.0    24708\n",
       "10025.0    23721\n",
       "10466.0    22860\n",
       "10027.0    22621\n",
       "11208.0    22614\n",
       "           ...  \n",
       "10044.0      326\n",
       "10309.0      309\n",
       "11362.0      305\n",
       "11426.0      297\n",
       "11004.0      245\n",
       "10007.0      223\n",
       "10006.0      193\n",
       "10308.0      189\n",
       "10005.0      179\n",
       "10307.0      163\n",
       "10282.0      155\n",
       "10004.0      151\n",
       "11001.0      120\n",
       "10280.0       72\n",
       "11697.0       65\n",
       "11040.0       51\n",
       "11109.0       23\n",
       "10069.0       20\n",
       "11005.0        8\n",
       "10162.0        5\n",
       "10803.0        4\n",
       "10041.0        3\n",
       "10020.0        2\n",
       "10169.0        2\n",
       "11430.0        2\n",
       "10045.0        1\n",
       "10103.0        1\n",
       "10121.0        1\n",
       "10129.0        1\n",
       "12345.0        1\n",
       "Name: Incident Zip, Length: 192, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Zipcode also not efficient\n",
    "heating_df['Incident Zip'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "BRONX                  654862\n",
       "BROOKLYN               633691\n",
       "NEW YORK               455170\n",
       "STATEN ISLAND           20824\n",
       "Jamaica                 20604\n",
       "Elmhurst                18286\n",
       "Flushing                18222\n",
       "Astoria                 18005\n",
       "Far Rockaway            11177\n",
       "Ridgewood               10470\n",
       "Woodside                10087\n",
       "Corona                   9551\n",
       "Jackson Heights          8976\n",
       "JAMAICA                  8559\n",
       "Forest Hills             6757\n",
       "ASTORIA                  6331\n",
       "Rego Park                5763\n",
       "FLUSHING                 5694\n",
       "Sunnyside                5404\n",
       "Kew Gardens              4393\n",
       "RIDGEWOOD                4132\n",
       "FAR ROCKAWAY             3944\n",
       "Queens Village           3574\n",
       "ELMHURST                 3531\n",
       "Rockaway Park            3478\n",
       "South Richmond Hill      3169\n",
       "WOODSIDE                 3045\n",
       "Long Island City         3028\n",
       "Ozone Park               2951\n",
       "Richmond Hill            2830\n",
       "                        ...  \n",
       "Middle Village           1014\n",
       "LONG ISLAND CITY          943\n",
       "Howard Beach              822\n",
       "ROCKAWAY PARK             800\n",
       "ROSEDALE                  758\n",
       "MASPETH                   743\n",
       "College Point             719\n",
       "OAKLAND GARDENS           616\n",
       "Whitestone                605\n",
       "Cambria Heights           533\n",
       "BAYSIDE                   452\n",
       "FRESH MEADOWS             451\n",
       "Little Neck               429\n",
       "COLLEGE POINT             413\n",
       "MIDDLE VILLAGE            396\n",
       "HOWARD BEACH              287\n",
       "WHITESTONE                249\n",
       "LITTLE NECK               233\n",
       "Bellerose                 224\n",
       "CAMBRIA HEIGHTS           208\n",
       "Glen Oaks                 166\n",
       "QUEENS                    141\n",
       "Floral Park                88\n",
       "GLEN OAKS                  79\n",
       "BELLEROSE                  73\n",
       "Breezy Point               57\n",
       "New Hyde Park              46\n",
       "FLORAL PARK                40\n",
       "BREEZY POINT                8\n",
       "NEW HYDE PARK               5\n",
       "Name: City, Length: 89, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#For four of the five Boroughs, the city is listed as the same as the borough. Queens appears to be the exception.\n",
    "heating_df['City'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unique Key</th>\n",
       "      <th>Created Date</th>\n",
       "      <th>Closed Date</th>\n",
       "      <th>Complaint Type</th>\n",
       "      <th>Location Type</th>\n",
       "      <th>Incident Zip</th>\n",
       "      <th>Incident Address</th>\n",
       "      <th>Street Name</th>\n",
       "      <th>City</th>\n",
       "      <th>Status</th>\n",
       "      <th>Resolution Description</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Location</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ARVERNE</th>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>568</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "      <td>589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASTORIA</th>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3287</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "      <td>3381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BAYSIDE</th>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>231</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "      <td>236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BELLEROSE</th>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>39</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BREEZY POINT</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BRONX</th>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>87303</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88577</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "      <td>88585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BROOKLYN</th>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>92200</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93387</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "      <td>93388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAMBRIA HEIGHTS</th>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>121</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COLLEGE POINT</th>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>219</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CORONA</th>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1386</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "      <td>1398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EAST ELMHURST</th>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>739</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "      <td>752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ELMHURST</th>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1639</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "      <td>1696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FAR ROCKAWAY</th>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2006</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>2040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FLORAL PARK</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FLUSHING</th>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3093</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "      <td>3154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FOREST HILLS</th>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1302</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "      <td>1340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FRESH MEADOWS</th>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>216</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "      <td>225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GLEN OAKS</th>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOLLIS</th>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>753</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "      <td>776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOWARD BEACH</th>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>126</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JACKSON HEIGHTS</th>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1436</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "      <td>1479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAMAICA</th>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>4942</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "      <td>5020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KEW GARDENS</th>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>594</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "      <td>599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LITTLE NECK</th>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>158</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LONG ISLAND CITY</th>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>439</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MASPETH</th>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>356</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIDDLE VILLAGE</th>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>213</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NEW HYDE PARK</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NEW YORK</th>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>58091</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59094</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "      <td>59095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OAKLAND GARDENS</th>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>389</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "      <td>397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OZONE PARK</th>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>824</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "      <td>835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QUEENS</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QUEENS VILLAGE</th>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>906</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "      <td>928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REGO PARK</th>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1104</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "      <td>1134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RICHMOND HILL</th>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>751</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "      <td>778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RIDGEWOOD</th>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2231</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "      <td>2273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROCKAWAY PARK</th>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>359</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "      <td>361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROSEDALE</th>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>397</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "      <td>416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAINT ALBANS</th>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>647</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "      <td>660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SOUTH OZONE PARK</th>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>592</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "      <td>606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SOUTH RICHMOND HILL</th>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>981</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "      <td>1005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPRINGFIELD GARDENS</th>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>669</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "      <td>675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STATEN ISLAND</th>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3390</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "      <td>3462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SUNNYSIDE</th>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>862</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "      <td>877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WHITESTONE</th>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>138</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WOODHAVEN</th>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>764</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "      <td>770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WOODSIDE</th>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1700</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "      <td>1773</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Unique Key  Created Date  Closed Date  Complaint Type  \\\n",
       "City                                                                         \n",
       "ARVERNE                     589           589          568             589   \n",
       "ASTORIA                    3381          3381         3287            3381   \n",
       "BAYSIDE                     236           236          231             236   \n",
       "BELLEROSE                    45            45           39              45   \n",
       "BREEZY POINT                  6             6            6               6   \n",
       "BRONX                     88585         88585        87303           88585   \n",
       "BROOKLYN                  93388         93388        92200           93388   \n",
       "CAMBRIA HEIGHTS             127           127          121             127   \n",
       "COLLEGE POINT               225           225          219             225   \n",
       "CORONA                     1398          1398         1386            1398   \n",
       "EAST ELMHURST               752           752          739             752   \n",
       "ELMHURST                   1696          1696         1639            1696   \n",
       "FAR ROCKAWAY               2040          2040         2006            2040   \n",
       "FLORAL PARK                  18            18           18              18   \n",
       "FLUSHING                   3154          3154         3093            3154   \n",
       "FOREST HILLS               1340          1340         1302            1340   \n",
       "FRESH MEADOWS               225           225          216             225   \n",
       "GLEN OAKS                    56            56           56              56   \n",
       "HOLLIS                      776           776          753             776   \n",
       "HOWARD BEACH                127           127          126             127   \n",
       "JACKSON HEIGHTS            1479          1479         1436            1479   \n",
       "JAMAICA                    5020          5020         4942            5020   \n",
       "KEW GARDENS                 599           599          594             599   \n",
       "LITTLE NECK                 159           159          158             159   \n",
       "LONG ISLAND CITY            454           454          439             454   \n",
       "MASPETH                     363           363          356             363   \n",
       "MIDDLE VILLAGE              221           221          213             221   \n",
       "NEW HYDE PARK                 2             2            2               2   \n",
       "NEW YORK                  59095         59095        58091           59095   \n",
       "OAKLAND GARDENS             397           397          389             397   \n",
       "OZONE PARK                  835           835          824             835   \n",
       "QUEENS                        3             3            3               3   \n",
       "QUEENS VILLAGE              928           928          906             928   \n",
       "REGO PARK                  1134          1134         1104            1134   \n",
       "RICHMOND HILL               778           778          751             778   \n",
       "RIDGEWOOD                  2273          2273         2231            2273   \n",
       "ROCKAWAY PARK               361           361          359             361   \n",
       "ROSEDALE                    416           416          397             416   \n",
       "SAINT ALBANS                660           660          647             660   \n",
       "SOUTH OZONE PARK            606           606          592             606   \n",
       "SOUTH RICHMOND HILL        1005          1005          981            1005   \n",
       "SPRINGFIELD GARDENS         675           675          669             675   \n",
       "STATEN ISLAND              3462          3462         3390            3462   \n",
       "SUNNYSIDE                   877           877          862             877   \n",
       "WHITESTONE                  139           139          138             139   \n",
       "WOODHAVEN                   770           770          764             770   \n",
       "WOODSIDE                   1773          1773         1700            1773   \n",
       "\n",
       "                     Location Type  Incident Zip  Incident Address  \\\n",
       "City                                                                 \n",
       "ARVERNE                        589           589               589   \n",
       "ASTORIA                       3381          3381              3381   \n",
       "BAYSIDE                        236           236               236   \n",
       "BELLEROSE                       45            45                45   \n",
       "BREEZY POINT                     6             6                 6   \n",
       "BRONX                        88585         88585             88585   \n",
       "BROOKLYN                     93388         93388             93388   \n",
       "CAMBRIA HEIGHTS                127           127               127   \n",
       "COLLEGE POINT                  225           225               225   \n",
       "CORONA                        1398          1398              1398   \n",
       "EAST ELMHURST                  752           752               752   \n",
       "ELMHURST                      1696          1696              1696   \n",
       "FAR ROCKAWAY                  2040          2040              2040   \n",
       "FLORAL PARK                     18            18                18   \n",
       "FLUSHING                      3154          3154              3154   \n",
       "FOREST HILLS                  1340          1340              1340   \n",
       "FRESH MEADOWS                  225           225               225   \n",
       "GLEN OAKS                       56            56                56   \n",
       "HOLLIS                         776           776               776   \n",
       "HOWARD BEACH                   127           127               127   \n",
       "JACKSON HEIGHTS               1479          1479              1479   \n",
       "JAMAICA                       5020          5020              5020   \n",
       "KEW GARDENS                    599           599               599   \n",
       "LITTLE NECK                    159           159               159   \n",
       "LONG ISLAND CITY               454           454               454   \n",
       "MASPETH                        363           363               363   \n",
       "MIDDLE VILLAGE                 221           221               221   \n",
       "NEW HYDE PARK                    2             2                 2   \n",
       "NEW YORK                     59095         59095             59095   \n",
       "OAKLAND GARDENS                397           397               397   \n",
       "OZONE PARK                     835           835               835   \n",
       "QUEENS                           3             0                 3   \n",
       "QUEENS VILLAGE                 928           928               928   \n",
       "REGO PARK                     1134          1134              1134   \n",
       "RICHMOND HILL                  778           778               778   \n",
       "RIDGEWOOD                     2273          2273              2273   \n",
       "ROCKAWAY PARK                  361           361               361   \n",
       "ROSEDALE                       416           416               416   \n",
       "SAINT ALBANS                   660           660               660   \n",
       "SOUTH OZONE PARK               606           606               606   \n",
       "SOUTH RICHMOND HILL           1005          1005              1005   \n",
       "SPRINGFIELD GARDENS            675           675               675   \n",
       "STATEN ISLAND                 3462          3462              3462   \n",
       "SUNNYSIDE                      877           877               877   \n",
       "WHITESTONE                     139           139               139   \n",
       "WOODHAVEN                      770           770               770   \n",
       "WOODSIDE                      1773          1773              1773   \n",
       "\n",
       "                     Street Name   City  Status  Resolution Description  \\\n",
       "City                                                                      \n",
       "ARVERNE                      589    589     589                     589   \n",
       "ASTORIA                     3381   3381    3381                    3381   \n",
       "BAYSIDE                      236    236     236                     236   \n",
       "BELLEROSE                     45     45      45                      45   \n",
       "BREEZY POINT                   6      6       6                       6   \n",
       "BRONX                      88585  88585   88585                   88577   \n",
       "BROOKLYN                   93388  93388   93388                   93387   \n",
       "CAMBRIA HEIGHTS              127    127     127                     127   \n",
       "COLLEGE POINT                225    225     225                     225   \n",
       "CORONA                      1398   1398    1398                    1398   \n",
       "EAST ELMHURST                752    752     752                     752   \n",
       "ELMHURST                    1696   1696    1696                    1696   \n",
       "FAR ROCKAWAY                2040   2040    2040                    2040   \n",
       "FLORAL PARK                   18     18      18                      18   \n",
       "FLUSHING                    3154   3154    3154                    3154   \n",
       "FOREST HILLS                1340   1340    1340                    1340   \n",
       "FRESH MEADOWS                225    225     225                     225   \n",
       "GLEN OAKS                     56     56      56                      56   \n",
       "HOLLIS                       776    776     776                     776   \n",
       "HOWARD BEACH                 127    127     127                     127   \n",
       "JACKSON HEIGHTS             1479   1479    1479                    1479   \n",
       "JAMAICA                     5020   5020    5020                    5020   \n",
       "KEW GARDENS                  599    599     599                     599   \n",
       "LITTLE NECK                  159    159     159                     159   \n",
       "LONG ISLAND CITY             454    454     454                     454   \n",
       "MASPETH                      363    363     363                     363   \n",
       "MIDDLE VILLAGE               221    221     221                     221   \n",
       "NEW HYDE PARK                  2      2       2                       2   \n",
       "NEW YORK                   59095  59095   59095                   59094   \n",
       "OAKLAND GARDENS              397    397     397                     397   \n",
       "OZONE PARK                   835    835     835                     835   \n",
       "QUEENS                         3      3       3                       3   \n",
       "QUEENS VILLAGE               928    928     928                     928   \n",
       "REGO PARK                   1134   1134    1134                    1134   \n",
       "RICHMOND HILL                778    778     778                     778   \n",
       "RIDGEWOOD                   2273   2273    2273                    2273   \n",
       "ROCKAWAY PARK                361    361     361                     361   \n",
       "ROSEDALE                     416    416     416                     416   \n",
       "SAINT ALBANS                 660    660     660                     660   \n",
       "SOUTH OZONE PARK             606    606     606                     606   \n",
       "SOUTH RICHMOND HILL         1005   1005    1005                    1005   \n",
       "SPRINGFIELD GARDENS          675    675     675                     675   \n",
       "STATEN ISLAND               3462   3462    3462                    3462   \n",
       "SUNNYSIDE                    877    877     877                     877   \n",
       "WHITESTONE                   139    139     139                     139   \n",
       "WOODHAVEN                    770    770     770                     770   \n",
       "WOODSIDE                    1773   1773    1773                    1773   \n",
       "\n",
       "                     Borough  Latitude  Longitude  Location  \n",
       "City                                                         \n",
       "ARVERNE                  589       589        589       589  \n",
       "ASTORIA                 3381      3381       3381      3381  \n",
       "BAYSIDE                  236       236        236       236  \n",
       "BELLEROSE                 45        45         45        45  \n",
       "BREEZY POINT               6         6          6         6  \n",
       "BRONX                  88585     88585      88585     88585  \n",
       "BROOKLYN               93388     93388      93388     93388  \n",
       "CAMBRIA HEIGHTS          127       127        127       127  \n",
       "COLLEGE POINT            225       225        225       225  \n",
       "CORONA                  1398      1398       1398      1398  \n",
       "EAST ELMHURST            752       752        752       752  \n",
       "ELMHURST                1696      1696       1696      1696  \n",
       "FAR ROCKAWAY            2040      2040       2040      2040  \n",
       "FLORAL PARK               18        18         18        18  \n",
       "FLUSHING                3154      3154       3154      3154  \n",
       "FOREST HILLS            1340      1340       1340      1340  \n",
       "FRESH MEADOWS            225       225        225       225  \n",
       "GLEN OAKS                 56        56         56        56  \n",
       "HOLLIS                   776       776        776       776  \n",
       "HOWARD BEACH             127       127        127       127  \n",
       "JACKSON HEIGHTS         1479      1479       1479      1479  \n",
       "JAMAICA                 5020      5020       5020      5020  \n",
       "KEW GARDENS              599       599        599       599  \n",
       "LITTLE NECK              159       159        159       159  \n",
       "LONG ISLAND CITY         454       454        454       454  \n",
       "MASPETH                  363       363        363       363  \n",
       "MIDDLE VILLAGE           221       221        221       221  \n",
       "NEW HYDE PARK              2         2          2         2  \n",
       "NEW YORK               59095     59095      59095     59095  \n",
       "OAKLAND GARDENS          397       397        397       397  \n",
       "OZONE PARK               835       835        835       835  \n",
       "QUEENS                     3         3          3         3  \n",
       "QUEENS VILLAGE           928       928        928       928  \n",
       "REGO PARK               1134      1134       1134      1134  \n",
       "RICHMOND HILL            778       778        778       778  \n",
       "RIDGEWOOD               2273      2273       2273      2273  \n",
       "ROCKAWAY PARK            361       361        361       361  \n",
       "ROSEDALE                 416       416        416       416  \n",
       "SAINT ALBANS             660       660        660       660  \n",
       "SOUTH OZONE PARK         606       606        606       606  \n",
       "SOUTH RICHMOND HILL     1005      1005       1005      1005  \n",
       "SPRINGFIELD GARDENS      675       675        675       675  \n",
       "STATEN ISLAND           3462      3462       3462      3462  \n",
       "SUNNYSIDE                877       877        877       877  \n",
       "WHITESTONE               139       139        139       139  \n",
       "WOODHAVEN                770       770        770       770  \n",
       "WOODSIDE                1773      1773       1773      1773  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#This take just those columsn with Borough Unspecified and gives a count by city. This is to ensure there are no overlaps in count where the borough is specified. \n",
    "heating_df.loc[heating_df['Borough'] == 'Unspecified'].groupby(heating_df['City']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Break outs of each Borough where Borough is specified\n",
    "heating_Queens = heating_df[heating_df.Borough=='QUEENS']\n",
    "heating_Manhattan = heating_df[heating_df.Borough=='MANHATTAN']\n",
    "heating_Bronx = heating_df[heating_df.Borough=='BRONX']\n",
    "heating_StatenIsl = heating_df[heating_df.Borough=='STATEN ISLAND']\n",
    "heating_Brooklyn = heating_df[heating_df.Borough=='BROOKLYN']\n",
    "heating_Unspecified = heating_df[heating_df.Borough=='Unspecified']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "BROOKLYN               93388\n",
       "BRONX                  88585\n",
       "NEW YORK               59095\n",
       "JAMAICA                 5020\n",
       "STATEN ISLAND           3462\n",
       "ASTORIA                 3381\n",
       "FLUSHING                3154\n",
       "RIDGEWOOD               2273\n",
       "FAR ROCKAWAY            2040\n",
       "WOODSIDE                1773\n",
       "ELMHURST                1696\n",
       "JACKSON HEIGHTS         1479\n",
       "CORONA                  1398\n",
       "FOREST HILLS            1340\n",
       "REGO PARK               1134\n",
       "SOUTH RICHMOND HILL     1005\n",
       "QUEENS VILLAGE           928\n",
       "SUNNYSIDE                877\n",
       "OZONE PARK               835\n",
       "RICHMOND HILL            778\n",
       "HOLLIS                   776\n",
       "WOODHAVEN                770\n",
       "EAST ELMHURST            752\n",
       "SPRINGFIELD GARDENS      675\n",
       "SAINT ALBANS             660\n",
       "SOUTH OZONE PARK         606\n",
       "KEW GARDENS              599\n",
       "ARVERNE                  589\n",
       "LONG ISLAND CITY         454\n",
       "ROSEDALE                 416\n",
       "OAKLAND GARDENS          397\n",
       "MASPETH                  363\n",
       "ROCKAWAY PARK            361\n",
       "BAYSIDE                  236\n",
       "COLLEGE POINT            225\n",
       "FRESH MEADOWS            225\n",
       "MIDDLE VILLAGE           221\n",
       "LITTLE NECK              159\n",
       "WHITESTONE               139\n",
       "HOWARD BEACH             127\n",
       "CAMBRIA HEIGHTS          127\n",
       "GLEN OAKS                 56\n",
       "BELLEROSE                 45\n",
       "FLORAL PARK               18\n",
       "BREEZY POINT               6\n",
       "QUEENS                     3\n",
       "NEW HYDE PARK              2\n",
       "Name: City, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Another look at value counts by city where borough is unspecified\n",
    "heating_Unspecified['City'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "269"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Remaining samples where both borough and city are unspecified.\n",
    "heating_Unspecified['City'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "572225\n",
      "660810\n"
     ]
    }
   ],
   "source": [
    "#Total count where both Borough and City are specified for the top three boroughs\n",
    "print(len(heating_Bronx))\n",
    "heating_Bronx = heating_Bronx.append(heating_Unspecified.loc[heating_Unspecified['City'] == 'BRONX'])\n",
    "print(len(heating_Bronx))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "545831\n",
      "639219\n"
     ]
    }
   ],
   "source": [
    "print(len(heating_Brooklyn))\n",
    "heating_Brooklyn = heating_Brooklyn.append(heating_Unspecified.loc[heating_Unspecified['City'] == 'BROOKLYN'])\n",
    "print(len(heating_Brooklyn))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "400686\n",
      "459781\n"
     ]
    }
   ],
   "source": [
    "print(len(heating_Manhattan))\n",
    "heating_Manhattan = heating_Manhattan.append(heating_Unspecified.loc[heating_Unspecified['City'] == 'NEW YORK'])\n",
    "print(len(heating_Manhattan))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'file_name': 'heating_Bronx.csv',\n",
       " 'message': 'File saved to project storage.',\n",
       " 'bucket_name': 'edx1-donotdelete-pr-88qux6w8ehqfye',\n",
       " 'asset_id': 'ce2d008a-fd3a-4ffa-ae3b-34e24e0fbab4'}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#@hidden_cell\n",
    "# The project token is an authorization token that is used to access project resources like data sources, connections, and used by platform APIs.\n",
    "#from project_lib import Project\n",
    "#project = Project(project_id='58548218-d78e-4251-95d2-67ed44feff5d', project_access_token='p-17588375ba270ce7d8e2f7d2651fde17fb64de66')\n",
    "#pc = project.project_context\n",
    "#project.save_data(file_name='heating_Bronx.csv', data=heating_Bronx.to_csv())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "CONCLUDING REMARKS: The question asks which Borough the agency should focus on based on the complaint type identified in the previous section (Heating anad Hot water). An initial look at value counts by Borough suggests that the Bronx has the greatest number of heating and hot water complaints. However, the significant number of complaints in an \"Unspecified\" Borough warrants greater investigation. Since the city is still listed for most unspecified borough rows, those rows can be appended to the separated Borough dataframes to get a number for the top three Boroughs. The remaining rows with city also missing (269) is not enough to affect the choice of Borough, which remains the Bronx."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}