fire_safety_complaint_features.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "# Generating Fire Safety Complaint Features\n",
    "## Introduction\n",
    "This notebook documents the process of generating feature data from the file `matched_Fire_Safety_Complaints.csv`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Loading the File"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "import pandas\n",
    "\n",
    "PATH_TO_CSV = \"./data/matched_Fire_Safety_Complaints.csv\"\n",
    "complaints = pandas.read_csv(PATH_TO_CSV)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Examining and Grouping the Complaint Item Types\n",
    "Using Python's `Counter`, accumulate all the types of complaints, and the number of each type, in this dadaset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Counter({nan: 2,\n",
       "         'fire escape': 122,\n",
       "         'blocked exits': 3593,\n",
       "         'crisp complaint inspection': 32,\n",
       "         'unlicensed auto repair': 116,\n",
       "         'refused hood + duct service': 49,\n",
       "         'sprinkler/standpipe systems': 995,\n",
       "         'roof access': 194,\n",
       "         'ul cert verification': 445,\n",
       "         'unapproved place of assembly': 12,\n",
       "         'uncategorized complaint': 9838,\n",
       "         'elevators not working': 217,\n",
       "         'multiple fire code violations': 620,\n",
       "         'overcrowded place of assembly': 243,\n",
       "         'street numbering': 141,\n",
       "         'exit maintenance': 147,\n",
       "         'extinguishers': 1611,\n",
       "         'electrical systems': 128,\n",
       "         'weeds and grass': 634,\n",
       "         'operating without a permit': 577,\n",
       "         'hoarding': 108,\n",
       "         'alarm systems': 9683,\n",
       "         'leaking underground tanks': 4,\n",
       "         'illegal occupancy': 37,\n",
       "         'open vacant building': 112,\n",
       "         'general hazardous materials': 343,\n",
       "         'combustible materials': 1456})"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from collections import Counter\n",
    "\n",
    "complaint_types = Counter(complaints[\"Complaint Item Type Description\"])\n",
    "complaint_types"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "By looking at the total types, it seems that there are two complaints that have a type \"nan\", which appear to be complaints that weren't specified any type. We can drop these two.\n",
    "Several other complaint types seem to be more related to the safety of evacuation in case of fire (e.g. \"blocked exits\"), which are not related to the risk of fire happening. (We may drop these?)\n",
    "Furthermore, we may consider grouping similar complaint types.\n",
    "First, we may group many of the complaints into three categories: \"potential fire cause\", \"potential fire control\", and \"fire emergency safety\".\n",
    "* Potential Fire Cause: \n",
    "    * general hazardous materials\n",
    "    * leaking underground tanks\n",
    "    * hoarding\n",
    "    * combustible materials\n",
    "    * weeds and grass\n",
    "    * open vacant building\n",
    "    * refused hood + duct service\n",
    "    * electrical systems\n",
    "    * unlicensed auto repair\n",
    "* Potential Fire Control:\n",
    "    * alarm systems\n",
    "    * sprinkler/standpipe systems\n",
    "    * extinguishers\n",
    "* Fire Emergency Safety\n",
    "    * roof access\n",
    "    * unapproved place of assembly\n",
    "    * fire escape\n",
    "    * blocked exits\n",
    "    * exit maintenance\n",
    "    * street numbering\n",
    "    * overcrowded place of assembly\n",
    "    \n",
    "In addition, I'm not exactly sure how to categorize the following complaint types:\n",
    "* ul cert verification\n",
    "* crisp complaint inspection\n",
    "* uncategorized complaint\n",
    "* multiple fire code violations\n",
    "* illegal occupancy\n",
    "* operating without a permit"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## The Disposition Column\n",
    "\n",
    "The possible values in this column can be acquired with the following step:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Counter({nan: 2355,\n",
       "         'referred to another agency': 360,\n",
       "         'no jurisdiction': 199,\n",
       "         'violation issued': 5627,\n",
       "         'referred to pm inspection task force': 19,\n",
       "         'no access to building': 51,\n",
       "         'condition corrected': 17001,\n",
       "         'referred to dph': 12,\n",
       "         'duplicate complaint': 84,\n",
       "         'referred to dbi': 225,\n",
       "         'no merit': 5526})"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "disposition_types = Counter(complaints[\"Disposition\"])\n",
    "disposition_types"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "There are 11 types of disposition values. The type 'no merit' and the type 'duplicate complaint' may indicate that the complaint is not valid, therefore we may ignore such complaints in the final output. \n",
    "There are also 2355 complaints where the disposition value is NaN. These complaints are preserved and counted towards the final output at this moment."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Generating Output\n",
    "\n",
    "First, define a few functions to check the values of each complaint:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "from datetime import date\n",
    "\n",
    "def is_valid_complaint(row):\n",
    "    disposition = row[\"Disposition\"]\n",
    "    return not (disposition == \"no merit\" or disposition == \"duplicate complaint\")\n",
    "\n",
    "def is_corrected(row):\n",
    "    disposition = row[\"Disposition\"]\n",
    "    return disposition == \"condition corrected\"\n",
    "\n",
    "def parse_date(date_str):\n",
    "    \"\"\"For a string in the format of YYYY-MM-DD, \n",
    "    return (YYYY, MM, DD)\"\"\"\n",
    "    return tuple(map(int, date_str.split('-')))\n",
    "\n",
    "def is_within_date_range(row, min_date_str, max_date_str):\n",
    "    \"\"\"checks if beg <= row[\"Received Date\"] <= end\n",
    "    row: a row in the dataset, representing one complaint\n",
    "    min_date_str: a str representing the beginning of the date range\n",
    "    max_date_str: a str representing the end of the date range\n",
    "    \"\"\"\n",
    "    complaint_date = date(*parse_date(row[\"Received Date\"]))\n",
    "    min_date = date(*parse_date(min_date_str))\n",
    "    max_date = date(*parse_date(max_date_str))\n",
    "    \n",
    "    return min_date <= complaint_date and max_date >= complaint_date"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Next, define a mapping from a complaint description to a more general complaint category, following the previous observation. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{nan: 'unk',\n",
       " 'fire escape': '22',\n",
       " 'blocked exits': '02',\n",
       " 'crisp complaint inspection': '16',\n",
       " 'unlicensed auto repair': '04',\n",
       " 'unapproved place of assembly': '24',\n",
       " 'sprinkler/standpipe systems': '19',\n",
       " 'roof access': '03',\n",
       " 'ul cert verification': '17',\n",
       " 'refused hood + duct service': '12',\n",
       " 'uncategorized complaint': '99',\n",
       " 'elevators not working': '09',\n",
       " 'multiple fire code violations': '98',\n",
       " 'overcrowded place of assembly': '11',\n",
       " 'street numbering': '21',\n",
       " 'alarm systems': '05',\n",
       " 'extinguishers': '06',\n",
       " 'electrical systems': '20',\n",
       " 'weeds and grass': '01',\n",
       " 'operating without a permit': '08',\n",
       " 'hoarding': '18',\n",
       " 'exit maintenance': '23',\n",
       " 'leaking underground tanks': '13',\n",
       " 'illegal occupancy': '25',\n",
       " 'open vacant building': '07',\n",
       " 'general hazardous materials': '15',\n",
       " 'combustible materials': '10'}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get the mappting from Complaint Item Type Description to Complaint Item Type\n",
    "complaint_id_mapping = {}\n",
    "\n",
    "for i, r in complaints.iterrows():\n",
    "    dsc = r[\"Complaint Item Type Description\"]\n",
    "    complaint_id = r[\"Complaint Item Type\"]\n",
    "    if dsc in complaint_id_mapping:\n",
    "        if complaint_id_mapping[dsc] != complaint_id:\n",
    "            raise Exception(\"Complaint Type has different IDs\")\n",
    "    else:\n",
    "        complaint_id_mapping[dsc] = complaint_id\n",
    "\n",
    "complaint_id_mapping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# define mapping from complaint item type to category\n",
    "potential_fire_cause = \"potential fire cause\"\n",
    "potential_fire_control = \"potential fire control\"\n",
    "fire_emergency_safety = \"fire emergency safety\"\n",
    "multiple_violations = \"multiple violations\"\n",
    "\n",
    "complaint_category_mapping = {\"potential fire cause\":['15', '13', '18', '10', '01', '07', '12', '20', '04'],\n",
    "                              \"potential fire control\":['05', '19', '06'], \n",
    "                              \"fire emergency safety\": ['03', '24', '22', '02', '23', '21', '11']}\n",
    "# reverse the mapping to get id -> category mappings\n",
    "complaint_category_mapping = {d:c for c, d_list in complaint_category_mapping.items()\n",
    "                                  for d in d_list}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Now, we're able to generate the output dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "from collections import defaultdict\n",
    "from math import isnan\n",
    "\n",
    "eas_to_features = defaultdict(lambda :defaultdict(float))\n",
    "\n",
    "for d, r in complaints.iterrows():\n",
    "    eas = r[\"EAS\"]\n",
    "    complaint_type = r[\"Complaint Item Type\"]\n",
    "    if not isnan(eas) and is_within_date_range(r, \"2005-01-01\", \"2016-12-31\"):\n",
    "        features = eas_to_features[int(eas)]\n",
    "        # increment count features for generalized complaint types\n",
    "        if complaint_type in complaint_category_mapping and is_valid_complaint(r):\n",
    "            feature_name = \"count {}\".format(complaint_category_mapping[complaint_type])\n",
    "            features[feature_name] += 1\n",
    "            features[\"count all complaints\"] += 1\n",
    "        \n",
    "            # increment count features for generalized complaint types not corrected:\n",
    "            if not is_corrected(r):\n",
    "                feature_name = \"count {} not corrected\".format(complaint_category_mapping[complaint_type])\n",
    "                features[feature_name] += 1\n",
    "                features[\"count all complaints not corrected\"] += 1\n",
    "        \n",
    "        # count for each complaint type, maybe remove this?\n",
    "        #complaint_type_dsc = r[\"Complaint Item Type Description\"]\n",
    "        #if is_valid_complaint(r):\n",
    "        #    feature_name = \"count {}\".format(complaint_type_dsc)\n",
    "        #    features[feature_name] += 1\n",
    "        #    \n",
    "        #    if not is_corrected(r):\n",
    "        #        feature_name = \"count {} not corrected\".format(complaint_type_dsc)\n",
    "        #        features[feature_name] += 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count all complaints</th>\n",
       "      <th>count potential fire control</th>\n",
       "      <th>count all complaints not corrected</th>\n",
       "      <th>count potential fire control not corrected</th>\n",
       "      <th>count fire emergency safety</th>\n",
       "      <th>count potential fire cause</th>\n",
       "      <th>count fire emergency safety not corrected</th>\n",
       "      <th>count potential fire cause not corrected</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>274495</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274499</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274504</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274512</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274546</th>\n",
       "      <td>9.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274549</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274552</th>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274555</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274557</th>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274562</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274564</th>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274568</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274571</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274572</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274582</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274601</th>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274602</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274603</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274621</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274622</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274626</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274645</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274650</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274653</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274665</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274677</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274691</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274693</th>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274699</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274708</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489965</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489976</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490034</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490141</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490201</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490231</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490234</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490256</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490263</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490300</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490324</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490326</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490327</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490369</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490509</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490510</th>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490536</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490552</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490559</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490584</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490595</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490606</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490610</th>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490711</th>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490904</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490976</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491070</th>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491100</th>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491139</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491201</th>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7092 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        count all complaints  count potential fire control  \\\n",
       "274495                   1.0                           1.0   \n",
       "274499                   1.0                           1.0   \n",
       "274504                   1.0                           1.0   \n",
       "274512                   1.0                           1.0   \n",
       "274546                   9.0                           8.0   \n",
       "274549                   3.0                           1.0   \n",
       "274552                   3.0                           2.0   \n",
       "274555                   2.0                           2.0   \n",
       "274557                   5.0                           2.0   \n",
       "274562                   2.0                           2.0   \n",
       "274564                   5.0                           1.0   \n",
       "274568                   1.0                           0.0   \n",
       "274571                   1.0                           0.0   \n",
       "274572                   3.0                           1.0   \n",
       "274582                   1.0                           1.0   \n",
       "274601                   4.0                           3.0   \n",
       "274602                   1.0                           1.0   \n",
       "274603                   1.0                           0.0   \n",
       "274621                   1.0                           1.0   \n",
       "274622                   2.0                           1.0   \n",
       "274626                   1.0                           1.0   \n",
       "274645                   2.0                           2.0   \n",
       "274650                   1.0                           1.0   \n",
       "274653                   1.0                           0.0   \n",
       "274665                   1.0                           1.0   \n",
       "274677                   1.0                           1.0   \n",
       "274691                   1.0                           1.0   \n",
       "274693                   4.0                           4.0   \n",
       "274699                   1.0                           1.0   \n",
       "274708                   2.0                           2.0   \n",
       "...                      ...                           ...   \n",
       "489965                   1.0                           0.0   \n",
       "489976                   1.0                           0.0   \n",
       "490034                   2.0                           2.0   \n",
       "490141                   1.0                           1.0   \n",
       "490201                   1.0                           1.0   \n",
       "490231                   1.0                           0.0   \n",
       "490234                   1.0                           0.0   \n",
       "490256                   1.0                           1.0   \n",
       "490263                   1.0                           0.0   \n",
       "490300                   1.0                           1.0   \n",
       "490324                   1.0                           0.0   \n",
       "490326                   1.0                           1.0   \n",
       "490327                   2.0                           1.0   \n",
       "490369                   2.0                           1.0   \n",
       "490509                   1.0                           0.0   \n",
       "490510                   7.0                           3.0   \n",
       "490536                   1.0                           0.0   \n",
       "490552                   1.0                           0.0   \n",
       "490559                   1.0                           0.0   \n",
       "490584                   1.0                           0.0   \n",
       "490595                   1.0                           0.0   \n",
       "490606                   1.0                           1.0   \n",
       "490610                   4.0                           4.0   \n",
       "490711                   3.0                           3.0   \n",
       "490904                   2.0                           2.0   \n",
       "490976                   1.0                           1.0   \n",
       "491070                   3.0                           3.0   \n",
       "491100                   4.0                           4.0   \n",
       "491139                   1.0                           0.0   \n",
       "491201                   2.0                           0.0   \n",
       "\n",
       "        count all complaints not corrected  \\\n",
       "274495                                 0.0   \n",
       "274499                                 0.0   \n",
       "274504                                 0.0   \n",
       "274512                                 0.0   \n",
       "274546                                 2.0   \n",
       "274549                                 0.0   \n",
       "274552                                 0.0   \n",
       "274555                                 1.0   \n",
       "274557                                 0.0   \n",
       "274562                                 0.0   \n",
       "274564                                 2.0   \n",
       "274568                                 0.0   \n",
       "274571                                 0.0   \n",
       "274572                                 0.0   \n",
       "274582                                 0.0   \n",
       "274601                                 1.0   \n",
       "274602                                 1.0   \n",
       "274603                                 0.0   \n",
       "274621                                 0.0   \n",
       "274622                                 0.0   \n",
       "274626                                 0.0   \n",
       "274645                                 0.0   \n",
       "274650                                 0.0   \n",
       "274653                                 0.0   \n",
       "274665                                 0.0   \n",
       "274677                                 0.0   \n",
       "274691                                 0.0   \n",
       "274693                                 0.0   \n",
       "274699                                 0.0   \n",
       "274708                                 0.0   \n",
       "...                                    ...   \n",
       "489965                                 0.0   \n",
       "489976                                 0.0   \n",
       "490034                                 1.0   \n",
       "490141                                 0.0   \n",
       "490201                                 0.0   \n",
       "490231                                 1.0   \n",
       "490234                                 0.0   \n",
       "490256                                 0.0   \n",
       "490263                                 0.0   \n",
       "490300                                 0.0   \n",
       "490324                                 0.0   \n",
       "490326                                 0.0   \n",
       "490327                                 0.0   \n",
       "490369                                 0.0   \n",
       "490509                                 1.0   \n",
       "490510                                 0.0   \n",
       "490536                                 0.0   \n",
       "490552                                 0.0   \n",
       "490559                                 0.0   \n",
       "490584                                 0.0   \n",
       "490595                                 0.0   \n",
       "490606                                 1.0   \n",
       "490610                                 0.0   \n",
       "490711                                 1.0   \n",
       "490904                                 0.0   \n",
       "490976                                 0.0   \n",
       "491070                                 0.0   \n",
       "491100                                 0.0   \n",
       "491139                                 0.0   \n",
       "491201                                 0.0   \n",
       "\n",
       "        count potential fire control not corrected  \\\n",
       "274495                                         0.0   \n",
       "274499                                         0.0   \n",
       "274504                                         0.0   \n",
       "274512                                         0.0   \n",
       "274546                                         1.0   \n",
       "274549                                         0.0   \n",
       "274552                                         0.0   \n",
       "274555                                         1.0   \n",
       "274557                                         0.0   \n",
       "274562                                         0.0   \n",
       "274564                                         0.0   \n",
       "274568                                         0.0   \n",
       "274571                                         0.0   \n",
       "274572                                         0.0   \n",
       "274582                                         0.0   \n",
       "274601                                         0.0   \n",
       "274602                                         1.0   \n",
       "274603                                         0.0   \n",
       "274621                                         0.0   \n",
       "274622                                         0.0   \n",
       "274626                                         0.0   \n",
       "274645                                         0.0   \n",
       "274650                                         0.0   \n",
       "274653                                         0.0   \n",
       "274665                                         0.0   \n",
       "274677                                         0.0   \n",
       "274691                                         0.0   \n",
       "274693                                         0.0   \n",
       "274699                                         0.0   \n",
       "274708                                         0.0   \n",
       "...                                            ...   \n",
       "489965                                         0.0   \n",
       "489976                                         0.0   \n",
       "490034                                         1.0   \n",
       "490141                                         0.0   \n",
       "490201                                         0.0   \n",
       "490231                                         0.0   \n",
       "490234                                         0.0   \n",
       "490256                                         0.0   \n",
       "490263                                         0.0   \n",
       "490300                                         0.0   \n",
       "490324                                         0.0   \n",
       "490326                                         0.0   \n",
       "490327                                         0.0   \n",
       "490369                                         0.0   \n",
       "490509                                         0.0   \n",
       "490510                                         0.0   \n",
       "490536                                         0.0   \n",
       "490552                                         0.0   \n",
       "490559                                         0.0   \n",
       "490584                                         0.0   \n",
       "490595                                         0.0   \n",
       "490606                                         1.0   \n",
       "490610                                         0.0   \n",
       "490711                                         1.0   \n",
       "490904                                         0.0   \n",
       "490976                                         0.0   \n",
       "491070                                         0.0   \n",
       "491100                                         0.0   \n",
       "491139                                         0.0   \n",
       "491201                                         0.0   \n",
       "\n",
       "        count fire emergency safety  count potential fire cause  \\\n",
       "274495                          0.0                         0.0   \n",
       "274499                          0.0                         0.0   \n",
       "274504                          0.0                         0.0   \n",
       "274512                          0.0                         0.0   \n",
       "274546                          1.0                         0.0   \n",
       "274549                          1.0                         1.0   \n",
       "274552                          0.0                         1.0   \n",
       "274555                          0.0                         0.0   \n",
       "274557                          3.0                         0.0   \n",
       "274562                          0.0                         0.0   \n",
       "274564                          4.0                         0.0   \n",
       "274568                          1.0                         0.0   \n",
       "274571                          1.0                         0.0   \n",
       "274572                          2.0                         0.0   \n",
       "274582                          0.0                         0.0   \n",
       "274601                          1.0                         0.0   \n",
       "274602                          0.0                         0.0   \n",
       "274603                          1.0                         0.0   \n",
       "274621                          0.0                         0.0   \n",
       "274622                          0.0                         1.0   \n",
       "274626                          0.0                         0.0   \n",
       "274645                          0.0                         0.0   \n",
       "274650                          0.0                         0.0   \n",
       "274653                          0.0                         1.0   \n",
       "274665                          0.0                         0.0   \n",
       "274677                          0.0                         0.0   \n",
       "274691                          0.0                         0.0   \n",
       "274693                          0.0                         0.0   \n",
       "274699                          0.0                         0.0   \n",
       "274708                          0.0                         0.0   \n",
       "...                             ...                         ...   \n",
       "489965                          1.0                         0.0   \n",
       "489976                          1.0                         0.0   \n",
       "490034                          0.0                         0.0   \n",
       "490141                          0.0                         0.0   \n",
       "490201                          0.0                         0.0   \n",
       "490231                          1.0                         0.0   \n",
       "490234                          0.0                         1.0   \n",
       "490256                          0.0                         0.0   \n",
       "490263                          1.0                         0.0   \n",
       "490300                          0.0                         0.0   \n",
       "490324                          0.0                         1.0   \n",
       "490326                          0.0                         0.0   \n",
       "490327                          0.0                         1.0   \n",
       "490369                          1.0                         0.0   \n",
       "490509                          0.0                         1.0   \n",
       "490510                          4.0                         0.0   \n",
       "490536                          1.0                         0.0   \n",
       "490552                          0.0                         1.0   \n",
       "490559                          1.0                         0.0   \n",
       "490584                          0.0                         1.0   \n",
       "490595                          0.0                         1.0   \n",
       "490606                          0.0                         0.0   \n",
       "490610                          0.0                         0.0   \n",
       "490711                          0.0                         0.0   \n",
       "490904                          0.0                         0.0   \n",
       "490976                          0.0                         0.0   \n",
       "491070                          0.0                         0.0   \n",
       "491100                          0.0                         0.0   \n",
       "491139                          0.0                         1.0   \n",
       "491201                          2.0                         0.0   \n",
       "\n",
       "        count fire emergency safety not corrected  \\\n",
       "274495                                        0.0   \n",
       "274499                                        0.0   \n",
       "274504                                        0.0   \n",
       "274512                                        0.0   \n",
       "274546                                        1.0   \n",
       "274549                                        0.0   \n",
       "274552                                        0.0   \n",
       "274555                                        0.0   \n",
       "274557                                        0.0   \n",
       "274562                                        0.0   \n",
       "274564                                        2.0   \n",
       "274568                                        0.0   \n",
       "274571                                        0.0   \n",
       "274572                                        0.0   \n",
       "274582                                        0.0   \n",
       "274601                                        1.0   \n",
       "274602                                        0.0   \n",
       "274603                                        0.0   \n",
       "274621                                        0.0   \n",
       "274622                                        0.0   \n",
       "274626                                        0.0   \n",
       "274645                                        0.0   \n",
       "274650                                        0.0   \n",
       "274653                                        0.0   \n",
       "274665                                        0.0   \n",
       "274677                                        0.0   \n",
       "274691                                        0.0   \n",
       "274693                                        0.0   \n",
       "274699                                        0.0   \n",
       "274708                                        0.0   \n",
       "...                                           ...   \n",
       "489965                                        0.0   \n",
       "489976                                        0.0   \n",
       "490034                                        0.0   \n",
       "490141                                        0.0   \n",
       "490201                                        0.0   \n",
       "490231                                        1.0   \n",
       "490234                                        0.0   \n",
       "490256                                        0.0   \n",
       "490263                                        0.0   \n",
       "490300                                        0.0   \n",
       "490324                                        0.0   \n",
       "490326                                        0.0   \n",
       "490327                                        0.0   \n",
       "490369                                        0.0   \n",
       "490509                                        0.0   \n",
       "490510                                        0.0   \n",
       "490536                                        0.0   \n",
       "490552                                        0.0   \n",
       "490559                                        0.0   \n",
       "490584                                        0.0   \n",
       "490595                                        0.0   \n",
       "490606                                        0.0   \n",
       "490610                                        0.0   \n",
       "490711                                        0.0   \n",
       "490904                                        0.0   \n",
       "490976                                        0.0   \n",
       "491070                                        0.0   \n",
       "491100                                        0.0   \n",
       "491139                                        0.0   \n",
       "491201                                        0.0   \n",
       "\n",
       "        count potential fire cause not corrected  \n",
       "274495                                       0.0  \n",
       "274499                                       0.0  \n",
       "274504                                       0.0  \n",
       "274512                                       0.0  \n",
       "274546                                       0.0  \n",
       "274549                                       0.0  \n",
       "274552                                       0.0  \n",
       "274555                                       0.0  \n",
       "274557                                       0.0  \n",
       "274562                                       0.0  \n",
       "274564                                       0.0  \n",
       "274568                                       0.0  \n",
       "274571                                       0.0  \n",
       "274572                                       0.0  \n",
       "274582                                       0.0  \n",
       "274601                                       0.0  \n",
       "274602                                       0.0  \n",
       "274603                                       0.0  \n",
       "274621                                       0.0  \n",
       "274622                                       0.0  \n",
       "274626                                       0.0  \n",
       "274645                                       0.0  \n",
       "274650                                       0.0  \n",
       "274653                                       0.0  \n",
       "274665                                       0.0  \n",
       "274677                                       0.0  \n",
       "274691                                       0.0  \n",
       "274693                                       0.0  \n",
       "274699                                       0.0  \n",
       "274708                                       0.0  \n",
       "...                                          ...  \n",
       "489965                                       0.0  \n",
       "489976                                       0.0  \n",
       "490034                                       0.0  \n",
       "490141                                       0.0  \n",
       "490201                                       0.0  \n",
       "490231                                       0.0  \n",
       "490234                                       0.0  \n",
       "490256                                       0.0  \n",
       "490263                                       0.0  \n",
       "490300                                       0.0  \n",
       "490324                                       0.0  \n",
       "490326                                       0.0  \n",
       "490327                                       0.0  \n",
       "490369                                       0.0  \n",
       "490509                                       1.0  \n",
       "490510                                       0.0  \n",
       "490536                                       0.0  \n",
       "490552                                       0.0  \n",
       "490559                                       0.0  \n",
       "490584                                       0.0  \n",
       "490595                                       0.0  \n",
       "490606                                       0.0  \n",
       "490610                                       0.0  \n",
       "490711                                       0.0  \n",
       "490904                                       0.0  \n",
       "490976                                       0.0  \n",
       "491070                                       0.0  \n",
       "491100                                       0.0  \n",
       "491139                                       0.0  \n",
       "491201                                       0.0  \n",
       "\n",
       "[7092 rows x 8 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pandas.DataFrame.from_dict(eas_to_features, orient='index', dtype=float)\n",
    "df.fillna(0, inplace=True)\n",
    "df"
   ]
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}