FireRiskScoreAutomation_working.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook is used for to generate a fire risk score used as a decision support tool by the Chattanooga Fire Department to help prioritize inspections. For more information on the model please visit https://www.chattadata.org/stories/s/jxzy-f5id"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Training data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.ensemble import RandomForestRegressor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Fire Indicator</th>\n",
       "      <th>Code743Count</th>\n",
       "      <th>Code745Count</th>\n",
       "      <th>Code651Count</th>\n",
       "      <th>Code522Count</th>\n",
       "      <th>Code531Count</th>\n",
       "      <th>Code412Count</th>\n",
       "      <th>LANDVALUE</th>\n",
       "      <th>CALCACRES</th>\n",
       "      <th>Building Age</th>\n",
       "      <th>Storys</th>\n",
       "      <th>Exterior Wall Desc</th>\n",
       "      <th>Year Built</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1084400</td>\n",
       "      <td>12.43</td>\n",
       "      <td>35.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>BRICK VENEER</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>171700</td>\n",
       "      <td>1.00</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>BRICK VENEER</td>\n",
       "      <td>1964.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>69400</td>\n",
       "      <td>1.00</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>CORRUGATED M</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>604400</td>\n",
       "      <td>1.50</td>\n",
       "      <td>65.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1955.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>151500</td>\n",
       "      <td>3.03</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.71</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1945.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>720400</td>\n",
       "      <td>1.80</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>PLATE GLASS</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>623800</td>\n",
       "      <td>1.00</td>\n",
       "      <td>55.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>CONC BLK PLA</td>\n",
       "      <td>1965.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>224000</td>\n",
       "      <td>1.00</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>769000</td>\n",
       "      <td>1.07</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>BRICK VENEER</td>\n",
       "      <td>2007.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>252800</td>\n",
       "      <td>1.00</td>\n",
       "      <td>38.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>BRICK VENEER</td>\n",
       "      <td>1982.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Fire Indicator  Code743Count  Code745Count  Code651Count  Code522Count  \\\n",
       "0               0             6            11             0             1   \n",
       "1               0             0             0             0             0   \n",
       "2               0             0             1             0             0   \n",
       "3               0             0             3             0             0   \n",
       "4               0             0             0             0             0   \n",
       "5               0             0             0             0             0   \n",
       "6               0             0             0             0             0   \n",
       "7               0             0             1             0             0   \n",
       "8               0             1             0             0             0   \n",
       "9               0             0             0             0             0   \n",
       "\n",
       "   Code531Count  Code412Count  LANDVALUE  CALCACRES  Building Age  Storys  \\\n",
       "0             1             1    1084400      12.43          35.0    2.00   \n",
       "1             0             1     171700       1.00          56.0    1.00   \n",
       "2             1             1      69400       1.00          30.0    1.00   \n",
       "3             0             1     604400       1.50          65.0    4.00   \n",
       "4             0             1     151500       3.03          75.0    1.71   \n",
       "5             0             1     720400       1.80          30.0    1.00   \n",
       "6             0             1     623800       1.00          55.0    1.00   \n",
       "7             0             1     224000       1.00          13.0    1.00   \n",
       "8             0             1     769000       1.07          13.0    1.00   \n",
       "9             0             1     252800       1.00          38.0    1.00   \n",
       "\n",
       "  Exterior Wall Desc  Year Built  \n",
       "0       BRICK VENEER      1985.0  \n",
       "1       BRICK VENEER      1964.0  \n",
       "2       CORRUGATED M      1990.0  \n",
       "3              BRICK      1955.0  \n",
       "4              BRICK      1945.0  \n",
       "5        PLATE GLASS      1990.0  \n",
       "6       CONC BLK PLA      1965.0  \n",
       "7                NaN      2007.0  \n",
       "8       BRICK VENEER      2007.0  \n",
       "9       BRICK VENEER      1982.0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# read data in and and view\n",
    "df_training = pd.read_csv(r'...\\training.csv')\n",
    "df_training.iloc[:,3:].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# replace NaN values with column mean\n",
    "df_training['Storys'].fillna(df_training['Storys'].mean(), inplace=True)\n",
    "df_training['Building Age'].fillna(df_training['Building Age'].mean(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# split into X and y\n",
    "X = df_training.iloc[:,4:14].values\n",
    "y = df_training.iloc[:,3:4].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[6.0000e+00, 1.1000e+01, 0.0000e+00, 1.0000e+00, 1.0000e+00,\n",
       "        1.0000e+00, 1.0844e+06, 1.2430e+01, 3.5000e+01, 2.0000e+00],\n",
       "       [0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        1.0000e+00, 1.7170e+05, 1.0000e+00, 5.6000e+01, 1.0000e+00],\n",
       "       [0.0000e+00, 1.0000e+00, 0.0000e+00, 0.0000e+00, 1.0000e+00,\n",
       "        1.0000e+00, 6.9400e+04, 1.0000e+00, 3.0000e+01, 1.0000e+00],\n",
       "       [0.0000e+00, 3.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        1.0000e+00, 6.0440e+05, 1.5000e+00, 6.5000e+01, 4.0000e+00],\n",
       "       [0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        1.0000e+00, 1.5150e+05, 3.0300e+00, 7.5000e+01, 1.7100e+00]])"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# view np array\n",
    "X[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RandomForestRegressor()"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create RandomForestRegressor and fit to data\n",
    "regressor = RandomForestRegressor(n_estimators = 100)\n",
    "regressor.fit(X, y.ravel())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Testing data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# read past two years fire data create X\n",
    "df_testing = pd.read_csv(r'...\\past_two_years.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# replace NaN values with column mean\n",
    "df_testing['Storys'].fillna(df_testing['Storys'].mean(), inplace=True)\n",
    "df_testing['Building Age'].fillna(df_testing['Building Age'].mean(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>ADDRESS</th>\n",
       "      <th>Code743Count</th>\n",
       "      <th>Code745Count</th>\n",
       "      <th>Code651Count</th>\n",
       "      <th>Code522Count</th>\n",
       "      <th>Code531Count</th>\n",
       "      <th>Code412Count</th>\n",
       "      <th>LANDVALUE</th>\n",
       "      <th>CALCACRES</th>\n",
       "      <th>Building Age</th>\n",
       "      <th>Storys</th>\n",
       "      <th>Exterior Wall Desc</th>\n",
       "      <th>Year Built</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2216 JENKINS RD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1215300</td>\n",
       "      <td>56.50</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>STONE</td>\n",
       "      <td>1987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1808 CITICO AVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4300</td>\n",
       "      <td>1.00</td>\n",
       "      <td>80.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>COMPOSITION</td>\n",
       "      <td>1940.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1001 BROAD ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1426000</td>\n",
       "      <td>1.06</td>\n",
       "      <td>43.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>CONC/TILT-UP</td>\n",
       "      <td>1977.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4007 13TH AVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14600</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>WOOD FR W SH</td>\n",
       "      <td>1900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1611 S WATKINS ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5400</td>\n",
       "      <td>1.00</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>VINYL</td>\n",
       "      <td>2004.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5326 SLAYTON AVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4500</td>\n",
       "      <td>1.00</td>\n",
       "      <td>57.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1963.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3601 ROGERS RD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11400</td>\n",
       "      <td>1.00</td>\n",
       "      <td>61.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1959.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4118 FAGAN ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3500</td>\n",
       "      <td>1.00</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1958.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1700 STANFIEL ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3800</td>\n",
       "      <td>1.00</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>VINYL</td>\n",
       "      <td>2003.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1439 IVY ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3900</td>\n",
       "      <td>1.00</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1958.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             ADDRESS  Code743Count  Code745Count  Code651Count  Code522Count  \\\n",
       "0    2216 JENKINS RD             0             0             0             0   \n",
       "1    1808 CITICO AVE             0             0             0             0   \n",
       "2      1001 BROAD ST             0             0             0             0   \n",
       "3      4007 13TH AVE             0             0             0             0   \n",
       "4  1611 S WATKINS ST             0             0             0             0   \n",
       "5   5326 SLAYTON AVE             0             0             0             0   \n",
       "6     3601 ROGERS RD             0             0             0             0   \n",
       "7      4118 FAGAN ST             0             0             0             0   \n",
       "8   1700 STANFIEL ST             0             0             0             0   \n",
       "9        1439 IVY ST             0             0             0             0   \n",
       "\n",
       "   Code531Count  Code412Count  LANDVALUE  CALCACRES  Building Age  Storys  \\\n",
       "0             0             0    1215300      56.50          33.0     1.0   \n",
       "1             0             0       4300       1.00          80.0     1.0   \n",
       "2             0             0    1426000       1.06          43.0     4.0   \n",
       "3             0             0      14600       1.00         100.0     1.0   \n",
       "4             0             0       5400       1.00          16.0     1.0   \n",
       "5             0             0       4500       1.00          57.0     1.0   \n",
       "6             0             0      11400       1.00          61.0     1.0   \n",
       "7             0             0       3500       1.00          62.0     1.0   \n",
       "8             0             0       3800       1.00          17.0     1.0   \n",
       "9             0             0       3900       1.00          62.0     1.0   \n",
       "\n",
       "  Exterior Wall Desc  Year Built  \n",
       "0              STONE      1987.0  \n",
       "1        COMPOSITION      1940.0  \n",
       "2       CONC/TILT-UP      1977.0  \n",
       "3       WOOD FR W SH      1900.0  \n",
       "4              VINYL      2004.0  \n",
       "5              BRICK      1963.0  \n",
       "6              BRICK      1959.0  \n",
       "7              BRICK      1958.0  \n",
       "8              VINYL      2003.0  \n",
       "9              BRICK      1958.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# view data\n",
    "df_testing.iloc[:,:].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create testing array\n",
    "X_testing = df_testing.iloc[:,1:11].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        0.0000e+00, 1.2153e+06, 5.6500e+01, 3.3000e+01, 1.0000e+00],\n",
       "       [0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        0.0000e+00, 4.3000e+03, 1.0000e+00, 8.0000e+01, 1.0000e+00],\n",
       "       [0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        0.0000e+00, 1.4260e+06, 1.0600e+00, 4.3000e+01, 4.0000e+00],\n",
       "       [0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        0.0000e+00, 1.4600e+04, 1.0000e+00, 1.0000e+02, 1.0000e+00],\n",
       "       [0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00, 0.0000e+00,\n",
       "        0.0000e+00, 5.4000e+03, 1.0000e+00, 1.6000e+01, 1.0000e+00]])"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# view X_testing \n",
    "X_testing[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# predict fire_risk_score_pred\n",
    "fire_risk_score_pred = regressor.predict(X_testing)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# fire_risk_score_pred and rename column\n",
    "final_fr_score = df_testing.merge(pd.Series(fire_risk_score_pred).to_frame(), left_index=True, right_index=True)\n",
    "final_fr_score.rename(columns={0: \"Fire Risk Index\"}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>ADDRESS</th>\n",
       "      <th>Code743Count</th>\n",
       "      <th>Code745Count</th>\n",
       "      <th>Code651Count</th>\n",
       "      <th>Code522Count</th>\n",
       "      <th>Code531Count</th>\n",
       "      <th>Code412Count</th>\n",
       "      <th>LANDVALUE</th>\n",
       "      <th>CALCACRES</th>\n",
       "      <th>Building Age</th>\n",
       "      <th>Storys</th>\n",
       "      <th>Exterior Wall Desc</th>\n",
       "      <th>Year Built</th>\n",
       "      <th>Fire Risk Index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2216 JENKINS RD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1215300</td>\n",
       "      <td>56.50</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>STONE</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>0.680000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1808 CITICO AVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4300</td>\n",
       "      <td>1.00</td>\n",
       "      <td>80.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>COMPOSITION</td>\n",
       "      <td>1940.0</td>\n",
       "      <td>0.424333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1001 BROAD ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1426000</td>\n",
       "      <td>1.06</td>\n",
       "      <td>43.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>CONC/TILT-UP</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>0.860000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4007 13TH AVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14600</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>WOOD FR W SH</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>0.424254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1611 S WATKINS ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5400</td>\n",
       "      <td>1.00</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>VINYL</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>0.830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5326 SLAYTON AVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4500</td>\n",
       "      <td>1.00</td>\n",
       "      <td>57.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1963.0</td>\n",
       "      <td>0.284738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3601 ROGERS RD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11400</td>\n",
       "      <td>1.00</td>\n",
       "      <td>61.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1959.0</td>\n",
       "      <td>0.630000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4118 FAGAN ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3500</td>\n",
       "      <td>1.00</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1958.0</td>\n",
       "      <td>0.130874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1700 STANFIEL ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3800</td>\n",
       "      <td>1.00</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>VINYL</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>0.376024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1439 IVY ST</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3900</td>\n",
       "      <td>1.00</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BRICK</td>\n",
       "      <td>1958.0</td>\n",
       "      <td>0.328663</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             ADDRESS  Code743Count  Code745Count  Code651Count  Code522Count  \\\n",
       "0    2216 JENKINS RD             0             0             0             0   \n",
       "1    1808 CITICO AVE             0             0             0             0   \n",
       "2      1001 BROAD ST             0             0             0             0   \n",
       "3      4007 13TH AVE             0             0             0             0   \n",
       "4  1611 S WATKINS ST             0             0             0             0   \n",
       "5   5326 SLAYTON AVE             0             0             0             0   \n",
       "6     3601 ROGERS RD             0             0             0             0   \n",
       "7      4118 FAGAN ST             0             0             0             0   \n",
       "8   1700 STANFIEL ST             0             0             0             0   \n",
       "9        1439 IVY ST             0             0             0             0   \n",
       "\n",
       "   Code531Count  Code412Count  LANDVALUE  CALCACRES  Building Age  Storys  \\\n",
       "0             0             0    1215300      56.50          33.0     1.0   \n",
       "1             0             0       4300       1.00          80.0     1.0   \n",
       "2             0             0    1426000       1.06          43.0     4.0   \n",
       "3             0             0      14600       1.00         100.0     1.0   \n",
       "4             0             0       5400       1.00          16.0     1.0   \n",
       "5             0             0       4500       1.00          57.0     1.0   \n",
       "6             0             0      11400       1.00          61.0     1.0   \n",
       "7             0             0       3500       1.00          62.0     1.0   \n",
       "8             0             0       3800       1.00          17.0     1.0   \n",
       "9             0             0       3900       1.00          62.0     1.0   \n",
       "\n",
       "  Exterior Wall Desc  Year Built  Fire Risk Index  \n",
       "0              STONE      1987.0         0.680000  \n",
       "1        COMPOSITION      1940.0         0.424333  \n",
       "2       CONC/TILT-UP      1977.0         0.860000  \n",
       "3       WOOD FR W SH      1900.0         0.424254  \n",
       "4              VINYL      2004.0         0.830000  \n",
       "5              BRICK      1963.0         0.284738  \n",
       "6              BRICK      1959.0         0.630000  \n",
       "7              BRICK      1958.0         0.130874  \n",
       "8              VINYL      2003.0         0.376024  \n",
       "9              BRICK      1958.0         0.328663  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# view final df before exporting\n",
    "final_fr_score.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# download final_df\n",
    "final_fr_score.to_csv(r'Z:\\Workflows\\Fire\\Fire Risk Scores\\data\\final_fr_score.csv',index=False)"
   ]
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}