Data_Assembly.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: geopandas in /opt/anaconda3/lib/python3.9/site-packages (0.12.2)\n",
      "Requirement already satisfied: shapely>=1.7 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (2.0.0)\n",
      "Requirement already satisfied: pyproj>=2.6.1.post1 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (3.4.1)\n",
      "Requirement already satisfied: fiona>=1.8 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (1.8.22)\n",
      "Requirement already satisfied: packaging in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (21.3)\n",
      "Requirement already satisfied: pandas>=1.0.0 in /opt/anaconda3/lib/python3.9/site-packages (from geopandas) (1.4.4)\n",
      "Requirement already satisfied: click>=4.0 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (8.0.4)\n",
      "Requirement already satisfied: cligj>=0.5 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (0.7.2)\n",
      "Requirement already satisfied: certifi in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (2022.9.24)\n",
      "Requirement already satisfied: attrs>=17 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (22.1.0)\n",
      "Requirement already satisfied: setuptools in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (65.5.0)\n",
      "Requirement already satisfied: munch in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (2.5.0)\n",
      "Requirement already satisfied: click-plugins>=1.0 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (1.1.1)\n",
      "Requirement already satisfied: six>=1.7 in /opt/anaconda3/lib/python3.9/site-packages (from fiona>=1.8->geopandas) (1.16.0)\n",
      "Requirement already satisfied: python-dateutil>=2.8.1 in /opt/anaconda3/lib/python3.9/site-packages (from pandas>=1.0.0->geopandas) (2.8.2)\n",
      "Requirement already satisfied: pytz>=2020.1 in /opt/anaconda3/lib/python3.9/site-packages (from pandas>=1.0.0->geopandas) (2022.1)\n",
      "Requirement already satisfied: numpy>=1.18.5 in /opt/anaconda3/lib/python3.9/site-packages (from pandas>=1.0.0->geopandas) (1.21.5)\n",
      "Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in /opt/anaconda3/lib/python3.9/site-packages (from packaging->geopandas) (3.0.9)\n",
      "Requirement already satisfied: folium in /opt/anaconda3/lib/python3.9/site-packages (0.14.0)\n",
      "Requirement already satisfied: numpy in /opt/anaconda3/lib/python3.9/site-packages (from folium) (1.21.5)\n",
      "Requirement already satisfied: branca>=0.6.0 in /opt/anaconda3/lib/python3.9/site-packages (from folium) (0.6.0)\n",
      "Requirement already satisfied: jinja2>=2.9 in /opt/anaconda3/lib/python3.9/site-packages (from folium) (2.11.3)\n",
      "Requirement already satisfied: requests in /opt/anaconda3/lib/python3.9/site-packages (from folium) (2.28.1)\n",
      "Requirement already satisfied: MarkupSafe>=0.23 in /opt/anaconda3/lib/python3.9/site-packages (from jinja2>=2.9->folium) (2.0.1)\n",
      "Requirement already satisfied: charset-normalizer<3,>=2 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (2.0.4)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (2022.9.24)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (1.26.13)\n",
      "Requirement already satisfied: idna<4,>=2.5 in /opt/anaconda3/lib/python3.9/site-packages (from requests->folium) (3.4)\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "import plotly.express as px\n",
    "import plotly.graph_objects as go\n",
    "from plotly.subplots import make_subplots\n",
    "import datetime as datetime\n",
    "from datetime import datetime\n",
    "\n",
    "!pip install geopandas   # If geopandas is not installed, this code should be activated.\n",
    "import geopandas as gpd # For working with geospatial data\n",
    "!pip install folium\n",
    "import folium as fm     # folium has more dynamic maps - but requires internet connection\n",
    "import matplotlib.pyplot as plt\n",
    "from shapely.geometry import Point, Polygon\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "fire_incident_data = pd.read_csv(\"/Users/akhil/Documents/Fire Vulnerability Project/Input Data/FireIncidentData2010Boundaries.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>OBJECTID_1</th>\n",
       "      <th>Join_Count_2020</th>\n",
       "      <th>Join_Count_2019</th>\n",
       "      <th>Join_Count_2018</th>\n",
       "      <th>Join_Count_2017</th>\n",
       "      <th>Join_Count_2016</th>\n",
       "      <th>CTID</th>\n",
       "      <th>CTTEXT</th>\n",
       "      <th>Frequency</th>\n",
       "      <th>Intensity</th>\n",
       "      <th>...</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLON</th>\n",
       "      <th>CT_Area</th>\n",
       "      <th>intersect_area</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>5</td>\n",
       "      <td>48453000101</td>\n",
       "      <td>TX: Travis County: Census Tract 1.01</td>\n",
       "      <td>221</td>\n",
       "      <td>49.293125</td>\n",
       "      <td>...</td>\n",
       "      <td>48453000101</td>\n",
       "      <td>1.01</td>\n",
       "      <td>Census Tract 1.01</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3124999</td>\n",
       "      <td>0</td>\n",
       "      <td>30.323169</td>\n",
       "      <td>-97.753267</td>\n",
       "      <td>3124998</td>\n",
       "      <td>3124998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>48453000102</td>\n",
       "      <td>TX: Travis County: Census Tract 1.02</td>\n",
       "      <td>221</td>\n",
       "      <td>49.293125</td>\n",
       "      <td>...</td>\n",
       "      <td>48453000102</td>\n",
       "      <td>1.02</td>\n",
       "      <td>Census Tract 1.02</td>\n",
       "      <td>G5020</td>\n",
       "      <td>5506027</td>\n",
       "      <td>138159</td>\n",
       "      <td>30.326272</td>\n",
       "      <td>-97.766801</td>\n",
       "      <td>5644191</td>\n",
       "      <td>5644191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>48453000203</td>\n",
       "      <td>TX: Travis County: Census Tract 2.03</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>48453000203</td>\n",
       "      <td>2.03</td>\n",
       "      <td>Census Tract 2.03</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1208518</td>\n",
       "      <td>0</td>\n",
       "      <td>30.312620</td>\n",
       "      <td>-97.736666</td>\n",
       "      <td>1208517</td>\n",
       "      <td>1208517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>48453000204</td>\n",
       "      <td>TX: Travis County: Census Tract 2.04</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>48453000204</td>\n",
       "      <td>2.04</td>\n",
       "      <td>Census Tract 2.04</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1822932</td>\n",
       "      <td>0</td>\n",
       "      <td>30.307164</td>\n",
       "      <td>-97.744465</td>\n",
       "      <td>1822933</td>\n",
       "      <td>1822933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>26</td>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>48453000205</td>\n",
       "      <td>TX: Travis County: Census Tract 2.05</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>48453000205</td>\n",
       "      <td>2.05</td>\n",
       "      <td>Census Tract 2.05</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1512160</td>\n",
       "      <td>0</td>\n",
       "      <td>30.326165</td>\n",
       "      <td>-97.734327</td>\n",
       "      <td>1512160</td>\n",
       "      <td>1512160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>196</td>\n",
       "      <td>18</td>\n",
       "      <td>22</td>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>48453002433</td>\n",
       "      <td>TX: Travis County: Census Tract 24.33</td>\n",
       "      <td>223</td>\n",
       "      <td>50.508388</td>\n",
       "      <td>...</td>\n",
       "      <td>48453002433</td>\n",
       "      <td>24.33</td>\n",
       "      <td>Census Tract 24.33</td>\n",
       "      <td>G5020</td>\n",
       "      <td>71144923</td>\n",
       "      <td>1086905</td>\n",
       "      <td>30.180550</td>\n",
       "      <td>-97.566491</td>\n",
       "      <td>72231898</td>\n",
       "      <td>12358271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>197</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>48453002434</td>\n",
       "      <td>TX: Travis County: Census Tract 24.34</td>\n",
       "      <td>219</td>\n",
       "      <td>42.993655</td>\n",
       "      <td>...</td>\n",
       "      <td>48453002434</td>\n",
       "      <td>24.34</td>\n",
       "      <td>Census Tract 24.34</td>\n",
       "      <td>G5020</td>\n",
       "      <td>55160631</td>\n",
       "      <td>6</td>\n",
       "      <td>30.071628</td>\n",
       "      <td>-97.747048</td>\n",
       "      <td>55160713</td>\n",
       "      <td>146858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>198</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>48453002435</td>\n",
       "      <td>TX: Travis County: Census Tract 24.35</td>\n",
       "      <td>222</td>\n",
       "      <td>48.364437</td>\n",
       "      <td>...</td>\n",
       "      <td>48453002435</td>\n",
       "      <td>24.35</td>\n",
       "      <td>Census Tract 24.35</td>\n",
       "      <td>G5020</td>\n",
       "      <td>48882070</td>\n",
       "      <td>8310</td>\n",
       "      <td>30.145712</td>\n",
       "      <td>-97.627919</td>\n",
       "      <td>48890388</td>\n",
       "      <td>4371472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>199</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>48453002500</td>\n",
       "      <td>TX: Travis County: Census Tract 25</td>\n",
       "      <td>217</td>\n",
       "      <td>46.797897</td>\n",
       "      <td>...</td>\n",
       "      <td>48453002500</td>\n",
       "      <td>25.00</td>\n",
       "      <td>Census Tract 25</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3344217</td>\n",
       "      <td>0</td>\n",
       "      <td>30.416638</td>\n",
       "      <td>-97.755312</td>\n",
       "      <td>3344217</td>\n",
       "      <td>3344217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>200</td>\n",
       "      <td>25</td>\n",
       "      <td>63</td>\n",
       "      <td>39</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>48453980000</td>\n",
       "      <td>TX: Travis County: -999</td>\n",
       "      <td>222</td>\n",
       "      <td>49.666093</td>\n",
       "      <td>...</td>\n",
       "      <td>48453980000</td>\n",
       "      <td>9800.00</td>\n",
       "      <td>Census Tract 9800</td>\n",
       "      <td>G5020</td>\n",
       "      <td>17490347</td>\n",
       "      <td>0</td>\n",
       "      <td>30.194693</td>\n",
       "      <td>-97.666507</td>\n",
       "      <td>17490349</td>\n",
       "      <td>17332541</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID_1  Join_Count_2020  Join_Count_2019  Join_Count_2018  \\\n",
       "0             1               22               18               13   \n",
       "1             2                6               11               12   \n",
       "2             3                6               11               14   \n",
       "3             4               26               30               27   \n",
       "4             5               24               26               22   \n",
       "..          ...              ...              ...              ...   \n",
       "195         196               18               22               28   \n",
       "196         197                7                3                1   \n",
       "197         198               13                3                6   \n",
       "198         199               16               20               18   \n",
       "199         200               25               63               39   \n",
       "\n",
       "     Join_Count_2017  Join_Count_2016         CTID  \\\n",
       "0                 16                5  48453000101   \n",
       "1                  3                0  48453000102   \n",
       "2                  9                3  48453000203   \n",
       "3                 18                1  48453000204   \n",
       "4                 14                7  48453000205   \n",
       "..               ...              ...          ...   \n",
       "195               12                5  48453002433   \n",
       "196                0                1  48453002434   \n",
       "197                5                0  48453002435   \n",
       "198               10                1  48453002500   \n",
       "199               32                3  48453980000   \n",
       "\n",
       "                                    CTTEXT  Frequency  Intensity  ...  \\\n",
       "0     TX: Travis County: Census Tract 1.01        221  49.293125  ...   \n",
       "1     TX: Travis County: Census Tract 1.02        221  49.293125  ...   \n",
       "2     TX: Travis County: Census Tract 2.03        220  49.013959  ...   \n",
       "3     TX: Travis County: Census Tract 2.04        220  49.013959  ...   \n",
       "4     TX: Travis County: Census Tract 2.05        220  49.013959  ...   \n",
       "..                                     ...        ...        ...  ...   \n",
       "195  TX: Travis County: Census Tract 24.33        223  50.508388  ...   \n",
       "196  TX: Travis County: Census Tract 24.34        219  42.993655  ...   \n",
       "197  TX: Travis County: Census Tract 24.35        222  48.364437  ...   \n",
       "198     TX: Travis County: Census Tract 25        217  46.797897  ...   \n",
       "199                TX: Travis County: -999        222  49.666093  ...   \n",
       "\n",
       "           GEOID     NAME            NAMELSAD  MTFCC     ALAND   AWATER  \\\n",
       "0    48453000101     1.01   Census Tract 1.01  G5020   3124999        0   \n",
       "1    48453000102     1.02   Census Tract 1.02  G5020   5506027   138159   \n",
       "2    48453000203     2.03   Census Tract 2.03  G5020   1208518        0   \n",
       "3    48453000204     2.04   Census Tract 2.04  G5020   1822932        0   \n",
       "4    48453000205     2.05   Census Tract 2.05  G5020   1512160        0   \n",
       "..           ...      ...                 ...    ...       ...      ...   \n",
       "195  48453002433    24.33  Census Tract 24.33  G5020  71144923  1086905   \n",
       "196  48453002434    24.34  Census Tract 24.34  G5020  55160631        6   \n",
       "197  48453002435    24.35  Census Tract 24.35  G5020  48882070     8310   \n",
       "198  48453002500    25.00     Census Tract 25  G5020   3344217        0   \n",
       "199  48453980000  9800.00   Census Tract 9800  G5020  17490347        0   \n",
       "\n",
       "      INTPTLAT   INTPTLON   CT_Area  intersect_area  \n",
       "0    30.323169 -97.753267   3124998         3124998  \n",
       "1    30.326272 -97.766801   5644191         5644191  \n",
       "2    30.312620 -97.736666   1208517         1208517  \n",
       "3    30.307164 -97.744465   1822933         1822933  \n",
       "4    30.326165 -97.734327   1512160         1512160  \n",
       "..         ...        ...       ...             ...  \n",
       "195  30.180550 -97.566491  72231898        12358271  \n",
       "196  30.071628 -97.747048  55160713          146858  \n",
       "197  30.145712 -97.627919  48890388         4371472  \n",
       "198  30.416638 -97.755312   3344217         3344217  \n",
       "199  30.194693 -97.666507  17490349        17332541  \n",
       "\n",
       "[200 rows x 28 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fire_incident_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>OBJECTID_1</th>\n",
       "      <th>Join_Count_2020</th>\n",
       "      <th>Join_Count_2019</th>\n",
       "      <th>Join_Count_2018</th>\n",
       "      <th>Join_Count_2017</th>\n",
       "      <th>Join_Count_2016</th>\n",
       "      <th>CTID</th>\n",
       "      <th>CTTEXT</th>\n",
       "      <th>Frequency</th>\n",
       "      <th>Intensity</th>\n",
       "      <th>...</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLON</th>\n",
       "      <th>CT_Area</th>\n",
       "      <th>intersect_area</th>\n",
       "      <th>Area_Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>5</td>\n",
       "      <td>48453000101</td>\n",
       "      <td>TX: Travis County: Census Tract 1.01</td>\n",
       "      <td>221</td>\n",
       "      <td>49.293125</td>\n",
       "      <td>...</td>\n",
       "      <td>1.01</td>\n",
       "      <td>Census Tract 1.01</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3124999</td>\n",
       "      <td>0</td>\n",
       "      <td>30.323169</td>\n",
       "      <td>-97.753267</td>\n",
       "      <td>3124998</td>\n",
       "      <td>3124998</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>48453000102</td>\n",
       "      <td>TX: Travis County: Census Tract 1.02</td>\n",
       "      <td>221</td>\n",
       "      <td>49.293125</td>\n",
       "      <td>...</td>\n",
       "      <td>1.02</td>\n",
       "      <td>Census Tract 1.02</td>\n",
       "      <td>G5020</td>\n",
       "      <td>5506027</td>\n",
       "      <td>138159</td>\n",
       "      <td>30.326272</td>\n",
       "      <td>-97.766801</td>\n",
       "      <td>5644191</td>\n",
       "      <td>5644191</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>48453000203</td>\n",
       "      <td>TX: Travis County: Census Tract 2.03</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>2.03</td>\n",
       "      <td>Census Tract 2.03</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1208518</td>\n",
       "      <td>0</td>\n",
       "      <td>30.312620</td>\n",
       "      <td>-97.736666</td>\n",
       "      <td>1208517</td>\n",
       "      <td>1208517</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>48453000204</td>\n",
       "      <td>TX: Travis County: Census Tract 2.04</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>2.04</td>\n",
       "      <td>Census Tract 2.04</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1822932</td>\n",
       "      <td>0</td>\n",
       "      <td>30.307164</td>\n",
       "      <td>-97.744465</td>\n",
       "      <td>1822933</td>\n",
       "      <td>1822933</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>26</td>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>48453000205</td>\n",
       "      <td>TX: Travis County: Census Tract 2.05</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>2.05</td>\n",
       "      <td>Census Tract 2.05</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1512160</td>\n",
       "      <td>0</td>\n",
       "      <td>30.326165</td>\n",
       "      <td>-97.734327</td>\n",
       "      <td>1512160</td>\n",
       "      <td>1512160</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>196</td>\n",
       "      <td>18</td>\n",
       "      <td>22</td>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>48453002433</td>\n",
       "      <td>TX: Travis County: Census Tract 24.33</td>\n",
       "      <td>223</td>\n",
       "      <td>50.508388</td>\n",
       "      <td>...</td>\n",
       "      <td>24.33</td>\n",
       "      <td>Census Tract 24.33</td>\n",
       "      <td>G5020</td>\n",
       "      <td>71144923</td>\n",
       "      <td>1086905</td>\n",
       "      <td>30.180550</td>\n",
       "      <td>-97.566491</td>\n",
       "      <td>72231898</td>\n",
       "      <td>12358271</td>\n",
       "      <td>0.171092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>197</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>48453002434</td>\n",
       "      <td>TX: Travis County: Census Tract 24.34</td>\n",
       "      <td>219</td>\n",
       "      <td>42.993655</td>\n",
       "      <td>...</td>\n",
       "      <td>24.34</td>\n",
       "      <td>Census Tract 24.34</td>\n",
       "      <td>G5020</td>\n",
       "      <td>55160631</td>\n",
       "      <td>6</td>\n",
       "      <td>30.071628</td>\n",
       "      <td>-97.747048</td>\n",
       "      <td>55160713</td>\n",
       "      <td>146858</td>\n",
       "      <td>0.002662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>198</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>48453002435</td>\n",
       "      <td>TX: Travis County: Census Tract 24.35</td>\n",
       "      <td>222</td>\n",
       "      <td>48.364437</td>\n",
       "      <td>...</td>\n",
       "      <td>24.35</td>\n",
       "      <td>Census Tract 24.35</td>\n",
       "      <td>G5020</td>\n",
       "      <td>48882070</td>\n",
       "      <td>8310</td>\n",
       "      <td>30.145712</td>\n",
       "      <td>-97.627919</td>\n",
       "      <td>48890388</td>\n",
       "      <td>4371472</td>\n",
       "      <td>0.089414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>199</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>48453002500</td>\n",
       "      <td>TX: Travis County: Census Tract 25</td>\n",
       "      <td>217</td>\n",
       "      <td>46.797897</td>\n",
       "      <td>...</td>\n",
       "      <td>25.00</td>\n",
       "      <td>Census Tract 25</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3344217</td>\n",
       "      <td>0</td>\n",
       "      <td>30.416638</td>\n",
       "      <td>-97.755312</td>\n",
       "      <td>3344217</td>\n",
       "      <td>3344217</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>200</td>\n",
       "      <td>25</td>\n",
       "      <td>63</td>\n",
       "      <td>39</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>48453980000</td>\n",
       "      <td>TX: Travis County: -999</td>\n",
       "      <td>222</td>\n",
       "      <td>49.666093</td>\n",
       "      <td>...</td>\n",
       "      <td>9800.00</td>\n",
       "      <td>Census Tract 9800</td>\n",
       "      <td>G5020</td>\n",
       "      <td>17490347</td>\n",
       "      <td>0</td>\n",
       "      <td>30.194693</td>\n",
       "      <td>-97.666507</td>\n",
       "      <td>17490349</td>\n",
       "      <td>17332541</td>\n",
       "      <td>0.990977</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID_1  Join_Count_2020  Join_Count_2019  Join_Count_2018  \\\n",
       "0             1               22               18               13   \n",
       "1             2                6               11               12   \n",
       "2             3                6               11               14   \n",
       "3             4               26               30               27   \n",
       "4             5               24               26               22   \n",
       "..          ...              ...              ...              ...   \n",
       "195         196               18               22               28   \n",
       "196         197                7                3                1   \n",
       "197         198               13                3                6   \n",
       "198         199               16               20               18   \n",
       "199         200               25               63               39   \n",
       "\n",
       "     Join_Count_2017  Join_Count_2016         CTID  \\\n",
       "0                 16                5  48453000101   \n",
       "1                  3                0  48453000102   \n",
       "2                  9                3  48453000203   \n",
       "3                 18                1  48453000204   \n",
       "4                 14                7  48453000205   \n",
       "..               ...              ...          ...   \n",
       "195               12                5  48453002433   \n",
       "196                0                1  48453002434   \n",
       "197                5                0  48453002435   \n",
       "198               10                1  48453002500   \n",
       "199               32                3  48453980000   \n",
       "\n",
       "                                    CTTEXT  Frequency  Intensity  ...  \\\n",
       "0     TX: Travis County: Census Tract 1.01        221  49.293125  ...   \n",
       "1     TX: Travis County: Census Tract 1.02        221  49.293125  ...   \n",
       "2     TX: Travis County: Census Tract 2.03        220  49.013959  ...   \n",
       "3     TX: Travis County: Census Tract 2.04        220  49.013959  ...   \n",
       "4     TX: Travis County: Census Tract 2.05        220  49.013959  ...   \n",
       "..                                     ...        ...        ...  ...   \n",
       "195  TX: Travis County: Census Tract 24.33        223  50.508388  ...   \n",
       "196  TX: Travis County: Census Tract 24.34        219  42.993655  ...   \n",
       "197  TX: Travis County: Census Tract 24.35        222  48.364437  ...   \n",
       "198     TX: Travis County: Census Tract 25        217  46.797897  ...   \n",
       "199                TX: Travis County: -999        222  49.666093  ...   \n",
       "\n",
       "        NAME            NAMELSAD  MTFCC     ALAND   AWATER   INTPTLAT  \\\n",
       "0       1.01   Census Tract 1.01  G5020   3124999        0  30.323169   \n",
       "1       1.02   Census Tract 1.02  G5020   5506027   138159  30.326272   \n",
       "2       2.03   Census Tract 2.03  G5020   1208518        0  30.312620   \n",
       "3       2.04   Census Tract 2.04  G5020   1822932        0  30.307164   \n",
       "4       2.05   Census Tract 2.05  G5020   1512160        0  30.326165   \n",
       "..       ...                 ...    ...       ...      ...        ...   \n",
       "195    24.33  Census Tract 24.33  G5020  71144923  1086905  30.180550   \n",
       "196    24.34  Census Tract 24.34  G5020  55160631        6  30.071628   \n",
       "197    24.35  Census Tract 24.35  G5020  48882070     8310  30.145712   \n",
       "198    25.00     Census Tract 25  G5020   3344217        0  30.416638   \n",
       "199  9800.00   Census Tract 9800  G5020  17490347        0  30.194693   \n",
       "\n",
       "      INTPTLON   CT_Area  intersect_area  Area_Ratio  \n",
       "0   -97.753267   3124998         3124998    1.000000  \n",
       "1   -97.766801   5644191         5644191    1.000000  \n",
       "2   -97.736666   1208517         1208517    1.000000  \n",
       "3   -97.744465   1822933         1822933    1.000000  \n",
       "4   -97.734327   1512160         1512160    1.000000  \n",
       "..         ...       ...             ...         ...  \n",
       "195 -97.566491  72231898        12358271    0.171092  \n",
       "196 -97.747048  55160713          146858    0.002662  \n",
       "197 -97.627919  48890388         4371472    0.089414  \n",
       "198 -97.755312   3344217         3344217    1.000000  \n",
       "199 -97.666507  17490349        17332541    0.990977  \n",
       "\n",
       "[200 rows x 29 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fire_incident_data[\"Area_Ratio\"] = fire_incident_data[\"intersect_area\"]/fire_incident_data[\"CT_Area\"]\n",
    "fire_incident_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OBJECTID_1</th>\n",
       "      <th>Join_Count_2020</th>\n",
       "      <th>Join_Count_2019</th>\n",
       "      <th>Join_Count_2018</th>\n",
       "      <th>Join_Count_2017</th>\n",
       "      <th>Join_Count_2016</th>\n",
       "      <th>CTID</th>\n",
       "      <th>CTTEXT</th>\n",
       "      <th>Frequency</th>\n",
       "      <th>Intensity</th>\n",
       "      <th>...</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLON</th>\n",
       "      <th>CT_Area</th>\n",
       "      <th>intersect_area</th>\n",
       "      <th>Area_Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>5</td>\n",
       "      <td>48453000101</td>\n",
       "      <td>TX: Travis County: Census Tract 1.01</td>\n",
       "      <td>221</td>\n",
       "      <td>49.293125</td>\n",
       "      <td>...</td>\n",
       "      <td>1.01</td>\n",
       "      <td>Census Tract 1.01</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3124999</td>\n",
       "      <td>0</td>\n",
       "      <td>30.323169</td>\n",
       "      <td>-97.753267</td>\n",
       "      <td>3124998</td>\n",
       "      <td>3124998</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>48453000102</td>\n",
       "      <td>TX: Travis County: Census Tract 1.02</td>\n",
       "      <td>221</td>\n",
       "      <td>49.293125</td>\n",
       "      <td>...</td>\n",
       "      <td>1.02</td>\n",
       "      <td>Census Tract 1.02</td>\n",
       "      <td>G5020</td>\n",
       "      <td>5506027</td>\n",
       "      <td>138159</td>\n",
       "      <td>30.326272</td>\n",
       "      <td>-97.766801</td>\n",
       "      <td>5644191</td>\n",
       "      <td>5644191</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>48453000203</td>\n",
       "      <td>TX: Travis County: Census Tract 2.03</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>2.03</td>\n",
       "      <td>Census Tract 2.03</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1208518</td>\n",
       "      <td>0</td>\n",
       "      <td>30.312620</td>\n",
       "      <td>-97.736666</td>\n",
       "      <td>1208517</td>\n",
       "      <td>1208517</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>48453000204</td>\n",
       "      <td>TX: Travis County: Census Tract 2.04</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>2.04</td>\n",
       "      <td>Census Tract 2.04</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1822932</td>\n",
       "      <td>0</td>\n",
       "      <td>30.307164</td>\n",
       "      <td>-97.744465</td>\n",
       "      <td>1822933</td>\n",
       "      <td>1822933</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>26</td>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>48453000205</td>\n",
       "      <td>TX: Travis County: Census Tract 2.05</td>\n",
       "      <td>220</td>\n",
       "      <td>49.013959</td>\n",
       "      <td>...</td>\n",
       "      <td>2.05</td>\n",
       "      <td>Census Tract 2.05</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1512160</td>\n",
       "      <td>0</td>\n",
       "      <td>30.326165</td>\n",
       "      <td>-97.734327</td>\n",
       "      <td>1512160</td>\n",
       "      <td>1512160</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>187</td>\n",
       "      <td>18</td>\n",
       "      <td>25</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>48453002424</td>\n",
       "      <td>TX: Travis County: Census Tract 24.24</td>\n",
       "      <td>218</td>\n",
       "      <td>43.980917</td>\n",
       "      <td>...</td>\n",
       "      <td>24.24</td>\n",
       "      <td>Census Tract 24.24</td>\n",
       "      <td>G5020</td>\n",
       "      <td>2764930</td>\n",
       "      <td>0</td>\n",
       "      <td>30.192189</td>\n",
       "      <td>-97.799249</td>\n",
       "      <td>2764934</td>\n",
       "      <td>2764934</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>193</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>48453002430</td>\n",
       "      <td>TX: Travis County: Census Tract 24.30</td>\n",
       "      <td>220</td>\n",
       "      <td>45.792461</td>\n",
       "      <td>...</td>\n",
       "      <td>24.30</td>\n",
       "      <td>Census Tract 24.30</td>\n",
       "      <td>G5020</td>\n",
       "      <td>2193916</td>\n",
       "      <td>0</td>\n",
       "      <td>30.171716</td>\n",
       "      <td>-97.755010</td>\n",
       "      <td>2193911</td>\n",
       "      <td>2142119</td>\n",
       "      <td>0.976393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>194</td>\n",
       "      <td>69</td>\n",
       "      <td>59</td>\n",
       "      <td>64</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>48453002431</td>\n",
       "      <td>TX: Travis County: Census Tract 24.31</td>\n",
       "      <td>220</td>\n",
       "      <td>47.349035</td>\n",
       "      <td>...</td>\n",
       "      <td>24.31</td>\n",
       "      <td>Census Tract 24.31</td>\n",
       "      <td>G5020</td>\n",
       "      <td>20132846</td>\n",
       "      <td>0</td>\n",
       "      <td>30.194538</td>\n",
       "      <td>-97.717824</td>\n",
       "      <td>20132838</td>\n",
       "      <td>19716320</td>\n",
       "      <td>0.979312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>199</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>48453002500</td>\n",
       "      <td>TX: Travis County: Census Tract 25</td>\n",
       "      <td>217</td>\n",
       "      <td>46.797897</td>\n",
       "      <td>...</td>\n",
       "      <td>25.00</td>\n",
       "      <td>Census Tract 25</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3344217</td>\n",
       "      <td>0</td>\n",
       "      <td>30.416638</td>\n",
       "      <td>-97.755312</td>\n",
       "      <td>3344217</td>\n",
       "      <td>3344217</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>200</td>\n",
       "      <td>25</td>\n",
       "      <td>63</td>\n",
       "      <td>39</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>48453980000</td>\n",
       "      <td>TX: Travis County: -999</td>\n",
       "      <td>222</td>\n",
       "      <td>49.666093</td>\n",
       "      <td>...</td>\n",
       "      <td>9800.00</td>\n",
       "      <td>Census Tract 9800</td>\n",
       "      <td>G5020</td>\n",
       "      <td>17490347</td>\n",
       "      <td>0</td>\n",
       "      <td>30.194693</td>\n",
       "      <td>-97.666507</td>\n",
       "      <td>17490349</td>\n",
       "      <td>17332541</td>\n",
       "      <td>0.990977</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>141 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID_1  Join_Count_2020  Join_Count_2019  Join_Count_2018  \\\n",
       "0             1               22               18               13   \n",
       "1             2                6               11               12   \n",
       "2             3                6               11               14   \n",
       "3             4               26               30               27   \n",
       "4             5               24               26               22   \n",
       "..          ...              ...              ...              ...   \n",
       "186         187               18               25               13   \n",
       "192         193               13                7                6   \n",
       "193         194               69               59               64   \n",
       "198         199               16               20               18   \n",
       "199         200               25               63               39   \n",
       "\n",
       "     Join_Count_2017  Join_Count_2016         CTID  \\\n",
       "0                 16                5  48453000101   \n",
       "1                  3                0  48453000102   \n",
       "2                  9                3  48453000203   \n",
       "3                 18                1  48453000204   \n",
       "4                 14                7  48453000205   \n",
       "..               ...              ...          ...   \n",
       "186               10                3  48453002424   \n",
       "192                4                1  48453002430   \n",
       "193               37                5  48453002431   \n",
       "198               10                1  48453002500   \n",
       "199               32                3  48453980000   \n",
       "\n",
       "                                    CTTEXT  Frequency  Intensity  ...  \\\n",
       "0     TX: Travis County: Census Tract 1.01        221  49.293125  ...   \n",
       "1     TX: Travis County: Census Tract 1.02        221  49.293125  ...   \n",
       "2     TX: Travis County: Census Tract 2.03        220  49.013959  ...   \n",
       "3     TX: Travis County: Census Tract 2.04        220  49.013959  ...   \n",
       "4     TX: Travis County: Census Tract 2.05        220  49.013959  ...   \n",
       "..                                     ...        ...        ...  ...   \n",
       "186  TX: Travis County: Census Tract 24.24        218  43.980917  ...   \n",
       "192  TX: Travis County: Census Tract 24.30        220  45.792461  ...   \n",
       "193  TX: Travis County: Census Tract 24.31        220  47.349035  ...   \n",
       "198     TX: Travis County: Census Tract 25        217  46.797897  ...   \n",
       "199                TX: Travis County: -999        222  49.666093  ...   \n",
       "\n",
       "        NAME            NAMELSAD  MTFCC     ALAND  AWATER   INTPTLAT  \\\n",
       "0       1.01   Census Tract 1.01  G5020   3124999       0  30.323169   \n",
       "1       1.02   Census Tract 1.02  G5020   5506027  138159  30.326272   \n",
       "2       2.03   Census Tract 2.03  G5020   1208518       0  30.312620   \n",
       "3       2.04   Census Tract 2.04  G5020   1822932       0  30.307164   \n",
       "4       2.05   Census Tract 2.05  G5020   1512160       0  30.326165   \n",
       "..       ...                 ...    ...       ...     ...        ...   \n",
       "186    24.24  Census Tract 24.24  G5020   2764930       0  30.192189   \n",
       "192    24.30  Census Tract 24.30  G5020   2193916       0  30.171716   \n",
       "193    24.31  Census Tract 24.31  G5020  20132846       0  30.194538   \n",
       "198    25.00     Census Tract 25  G5020   3344217       0  30.416638   \n",
       "199  9800.00   Census Tract 9800  G5020  17490347       0  30.194693   \n",
       "\n",
       "      INTPTLON   CT_Area  intersect_area  Area_Ratio  \n",
       "0   -97.753267   3124998         3124998    1.000000  \n",
       "1   -97.766801   5644191         5644191    1.000000  \n",
       "2   -97.736666   1208517         1208517    1.000000  \n",
       "3   -97.744465   1822933         1822933    1.000000  \n",
       "4   -97.734327   1512160         1512160    1.000000  \n",
       "..         ...       ...             ...         ...  \n",
       "186 -97.799249   2764934         2764934    1.000000  \n",
       "192 -97.755010   2193911         2142119    0.976393  \n",
       "193 -97.717824  20132838        19716320    0.979312  \n",
       "198 -97.755312   3344217         3344217    1.000000  \n",
       "199 -97.666507  17490349        17332541    0.990977  \n",
       "\n",
       "[141 rows x 29 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_census_tracts = fire_incident_data.loc[fire_incident_data[\"Area_Ratio\"] > 0.95]\n",
    "\n",
    "filtered_census_tracts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "health_data = pd.read_csv(\"/Users/akhil/Documents/Fire Vulnerability Project/Input Data/Health_Data.csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "health_data_atx = health_data.loc[(health_data[\"StateAbbr\"] == \"TX\") & (health_data[\"CountyName\"] == \"Travis\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/z3/kchg1fx10r126g5rwh_ntl5w0000gp/T/ipykernel_2570/856161666.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  health_data_atx.rename({'TractFIPS': 'CTGEOID'}, axis=1, inplace=True)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>StateAbbr</th>\n",
       "      <th>StateDesc</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>CountyFIPS</th>\n",
       "      <th>CTGEOID</th>\n",
       "      <th>TotalPopulation</th>\n",
       "      <th>ACCESS2_CrudePrev</th>\n",
       "      <th>ACCESS2_Crude95CI</th>\n",
       "      <th>ARTHRITIS_CrudePrev</th>\n",
       "      <th>ARTHRITIS_Crude95CI</th>\n",
       "      <th>...</th>\n",
       "      <th>OBESITY_Crude95CI</th>\n",
       "      <th>PHLTH_CrudePrev</th>\n",
       "      <th>PHLTH_Crude95CI</th>\n",
       "      <th>SLEEP_CrudePrev</th>\n",
       "      <th>SLEEP_Crude95CI</th>\n",
       "      <th>STROKE_CrudePrev</th>\n",
       "      <th>STROKE_Crude95CI</th>\n",
       "      <th>TEETHLOST_CrudePrev</th>\n",
       "      <th>TEETHLOST_Crude95CI</th>\n",
       "      <th>Geolocation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>65683</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453000101</td>\n",
       "      <td>3611</td>\n",
       "      <td>10.9</td>\n",
       "      <td>( 9.2, 13.4)</td>\n",
       "      <td>18.7</td>\n",
       "      <td>(17.7, 20.0)</td>\n",
       "      <td>...</td>\n",
       "      <td>(20.8, 22.7)</td>\n",
       "      <td>7.1</td>\n",
       "      <td>( 6.3,  8.4)</td>\n",
       "      <td>26.7</td>\n",
       "      <td>(25.7, 28.1)</td>\n",
       "      <td>2.2</td>\n",
       "      <td>( 1.9,  2.6)</td>\n",
       "      <td>5.4</td>\n",
       "      <td>( 3.4, 11.7)</td>\n",
       "      <td>POINT (-97.75325949 30.32315102)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65684</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453000102</td>\n",
       "      <td>2552</td>\n",
       "      <td>8.9</td>\n",
       "      <td>( 7.4, 11.4)</td>\n",
       "      <td>22.8</td>\n",
       "      <td>(21.3, 24.3)</td>\n",
       "      <td>...</td>\n",
       "      <td>(22.0, 24.5)</td>\n",
       "      <td>8.2</td>\n",
       "      <td>( 7.2,  9.2)</td>\n",
       "      <td>26.2</td>\n",
       "      <td>(24.8, 27.9)</td>\n",
       "      <td>2.5</td>\n",
       "      <td>( 2.2,  2.8)</td>\n",
       "      <td>4.5</td>\n",
       "      <td>( 2.8,  8.2)</td>\n",
       "      <td>POINT (-97.76709614 30.32586682)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65685</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453000203</td>\n",
       "      <td>1546</td>\n",
       "      <td>17.2</td>\n",
       "      <td>(14.5, 22.0)</td>\n",
       "      <td>8.4</td>\n",
       "      <td>( 7.9,  8.9)</td>\n",
       "      <td>...</td>\n",
       "      <td>(20.6, 22.5)</td>\n",
       "      <td>6.8</td>\n",
       "      <td>( 6.1,  8.2)</td>\n",
       "      <td>30.4</td>\n",
       "      <td>(29.0, 32.0)</td>\n",
       "      <td>1.1</td>\n",
       "      <td>( 1.0,  1.2)</td>\n",
       "      <td>10.1</td>\n",
       "      <td>( 6.1, 15.8)</td>\n",
       "      <td>POINT (-97.73667752 30.31261233)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65686</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453000204</td>\n",
       "      <td>3009</td>\n",
       "      <td>13.6</td>\n",
       "      <td>(11.8, 16.2)</td>\n",
       "      <td>13.4</td>\n",
       "      <td>(12.8, 14.2)</td>\n",
       "      <td>...</td>\n",
       "      <td>(22.4, 24.6)</td>\n",
       "      <td>7.5</td>\n",
       "      <td>( 6.6,  8.4)</td>\n",
       "      <td>29.8</td>\n",
       "      <td>(28.0, 31.4)</td>\n",
       "      <td>1.6</td>\n",
       "      <td>( 1.4,  1.7)</td>\n",
       "      <td>7.2</td>\n",
       "      <td>( 4.7, 11.0)</td>\n",
       "      <td>POINT (-97.74445438 30.30715848)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65687</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453000205</td>\n",
       "      <td>3394</td>\n",
       "      <td>14.6</td>\n",
       "      <td>(12.9, 16.9)</td>\n",
       "      <td>11.9</td>\n",
       "      <td>(11.3, 12.4)</td>\n",
       "      <td>...</td>\n",
       "      <td>(22.5, 24.6)</td>\n",
       "      <td>6.6</td>\n",
       "      <td>( 6.0,  7.3)</td>\n",
       "      <td>30.1</td>\n",
       "      <td>(28.9, 31.5)</td>\n",
       "      <td>1.3</td>\n",
       "      <td>( 1.3,  1.5)</td>\n",
       "      <td>5.8</td>\n",
       "      <td>( 3.8,  8.9)</td>\n",
       "      <td>POINT (-97.73433313 30.32614399)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65895</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453002433</td>\n",
       "      <td>5981</td>\n",
       "      <td>34.1</td>\n",
       "      <td>(31.1, 37.3)</td>\n",
       "      <td>17.1</td>\n",
       "      <td>(16.7, 17.6)</td>\n",
       "      <td>...</td>\n",
       "      <td>(32.0, 33.3)</td>\n",
       "      <td>12.4</td>\n",
       "      <td>(11.5, 12.9)</td>\n",
       "      <td>35.6</td>\n",
       "      <td>(34.7, 36.4)</td>\n",
       "      <td>2.6</td>\n",
       "      <td>( 2.5,  2.8)</td>\n",
       "      <td>15.6</td>\n",
       "      <td>(13.0, 18.4)</td>\n",
       "      <td>POINT (-97.57654668 30.18797306)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65896</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453002434</td>\n",
       "      <td>1718</td>\n",
       "      <td>36.3</td>\n",
       "      <td>(33.5, 39.0)</td>\n",
       "      <td>22.0</td>\n",
       "      <td>(21.3, 22.6)</td>\n",
       "      <td>...</td>\n",
       "      <td>(34.7, 36.1)</td>\n",
       "      <td>16.5</td>\n",
       "      <td>(15.5, 17.5)</td>\n",
       "      <td>36.5</td>\n",
       "      <td>(35.4, 37.2)</td>\n",
       "      <td>3.7</td>\n",
       "      <td>( 3.4,  4.0)</td>\n",
       "      <td>21.2</td>\n",
       "      <td>(17.0, 26.0)</td>\n",
       "      <td>POINT (-97.74187409 30.07372545)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65897</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453002435</td>\n",
       "      <td>7560</td>\n",
       "      <td>40.3</td>\n",
       "      <td>(37.0, 43.7)</td>\n",
       "      <td>16.4</td>\n",
       "      <td>(15.9, 16.9)</td>\n",
       "      <td>...</td>\n",
       "      <td>(33.8, 35.2)</td>\n",
       "      <td>13.9</td>\n",
       "      <td>(13.2, 14.5)</td>\n",
       "      <td>37.1</td>\n",
       "      <td>(36.4, 37.9)</td>\n",
       "      <td>2.7</td>\n",
       "      <td>( 2.5,  2.9)</td>\n",
       "      <td>17.7</td>\n",
       "      <td>(14.8, 20.9)</td>\n",
       "      <td>POINT (-97.62875648 30.14543349)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65898</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453002436</td>\n",
       "      <td>2672</td>\n",
       "      <td>40.8</td>\n",
       "      <td>(37.4, 43.6)</td>\n",
       "      <td>19.8</td>\n",
       "      <td>(19.1, 20.2)</td>\n",
       "      <td>...</td>\n",
       "      <td>(31.6, 32.8)</td>\n",
       "      <td>14.5</td>\n",
       "      <td>(13.3, 15.3)</td>\n",
       "      <td>34.5</td>\n",
       "      <td>(33.7, 35.0)</td>\n",
       "      <td>3.3</td>\n",
       "      <td>( 3.1,  3.4)</td>\n",
       "      <td>17.8</td>\n",
       "      <td>(15.3, 20.3)</td>\n",
       "      <td>POINT (-97.66645455 30.10380339)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65899</th>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Travis</td>\n",
       "      <td>48453</td>\n",
       "      <td>48453002500</td>\n",
       "      <td>5163</td>\n",
       "      <td>13.5</td>\n",
       "      <td>(11.9, 15.5)</td>\n",
       "      <td>16.9</td>\n",
       "      <td>(16.3, 17.7)</td>\n",
       "      <td>...</td>\n",
       "      <td>(22.9, 25.0)</td>\n",
       "      <td>8.0</td>\n",
       "      <td>( 7.1,  8.7)</td>\n",
       "      <td>29.8</td>\n",
       "      <td>(28.3, 31.3)</td>\n",
       "      <td>2.0</td>\n",
       "      <td>( 1.8,  2.2)</td>\n",
       "      <td>6.6</td>\n",
       "      <td>( 4.2, 11.0)</td>\n",
       "      <td>POINT (-97.75528725 30.41665935)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>217 rows × 63 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      StateAbbr StateDesc CountyName  CountyFIPS      CTGEOID  \\\n",
       "65683        TX     Texas     Travis       48453  48453000101   \n",
       "65684        TX     Texas     Travis       48453  48453000102   \n",
       "65685        TX     Texas     Travis       48453  48453000203   \n",
       "65686        TX     Texas     Travis       48453  48453000204   \n",
       "65687        TX     Texas     Travis       48453  48453000205   \n",
       "...         ...       ...        ...         ...          ...   \n",
       "65895        TX     Texas     Travis       48453  48453002433   \n",
       "65896        TX     Texas     Travis       48453  48453002434   \n",
       "65897        TX     Texas     Travis       48453  48453002435   \n",
       "65898        TX     Texas     Travis       48453  48453002436   \n",
       "65899        TX     Texas     Travis       48453  48453002500   \n",
       "\n",
       "       TotalPopulation  ACCESS2_CrudePrev ACCESS2_Crude95CI  \\\n",
       "65683             3611               10.9      ( 9.2, 13.4)   \n",
       "65684             2552                8.9      ( 7.4, 11.4)   \n",
       "65685             1546               17.2      (14.5, 22.0)   \n",
       "65686             3009               13.6      (11.8, 16.2)   \n",
       "65687             3394               14.6      (12.9, 16.9)   \n",
       "...                ...                ...               ...   \n",
       "65895             5981               34.1      (31.1, 37.3)   \n",
       "65896             1718               36.3      (33.5, 39.0)   \n",
       "65897             7560               40.3      (37.0, 43.7)   \n",
       "65898             2672               40.8      (37.4, 43.6)   \n",
       "65899             5163               13.5      (11.9, 15.5)   \n",
       "\n",
       "       ARTHRITIS_CrudePrev ARTHRITIS_Crude95CI  ...  OBESITY_Crude95CI  \\\n",
       "65683                 18.7        (17.7, 20.0)  ...       (20.8, 22.7)   \n",
       "65684                 22.8        (21.3, 24.3)  ...       (22.0, 24.5)   \n",
       "65685                  8.4        ( 7.9,  8.9)  ...       (20.6, 22.5)   \n",
       "65686                 13.4        (12.8, 14.2)  ...       (22.4, 24.6)   \n",
       "65687                 11.9        (11.3, 12.4)  ...       (22.5, 24.6)   \n",
       "...                    ...                 ...  ...                ...   \n",
       "65895                 17.1        (16.7, 17.6)  ...       (32.0, 33.3)   \n",
       "65896                 22.0        (21.3, 22.6)  ...       (34.7, 36.1)   \n",
       "65897                 16.4        (15.9, 16.9)  ...       (33.8, 35.2)   \n",
       "65898                 19.8        (19.1, 20.2)  ...       (31.6, 32.8)   \n",
       "65899                 16.9        (16.3, 17.7)  ...       (22.9, 25.0)   \n",
       "\n",
       "      PHLTH_CrudePrev  PHLTH_Crude95CI SLEEP_CrudePrev  SLEEP_Crude95CI  \\\n",
       "65683             7.1     ( 6.3,  8.4)            26.7     (25.7, 28.1)   \n",
       "65684             8.2     ( 7.2,  9.2)            26.2     (24.8, 27.9)   \n",
       "65685             6.8     ( 6.1,  8.2)            30.4     (29.0, 32.0)   \n",
       "65686             7.5     ( 6.6,  8.4)            29.8     (28.0, 31.4)   \n",
       "65687             6.6     ( 6.0,  7.3)            30.1     (28.9, 31.5)   \n",
       "...               ...              ...             ...              ...   \n",
       "65895            12.4     (11.5, 12.9)            35.6     (34.7, 36.4)   \n",
       "65896            16.5     (15.5, 17.5)            36.5     (35.4, 37.2)   \n",
       "65897            13.9     (13.2, 14.5)            37.1     (36.4, 37.9)   \n",
       "65898            14.5     (13.3, 15.3)            34.5     (33.7, 35.0)   \n",
       "65899             8.0     ( 7.1,  8.7)            29.8     (28.3, 31.3)   \n",
       "\n",
       "      STROKE_CrudePrev  STROKE_Crude95CI TEETHLOST_CrudePrev  \\\n",
       "65683              2.2      ( 1.9,  2.6)                 5.4   \n",
       "65684              2.5      ( 2.2,  2.8)                 4.5   \n",
       "65685              1.1      ( 1.0,  1.2)                10.1   \n",
       "65686              1.6      ( 1.4,  1.7)                 7.2   \n",
       "65687              1.3      ( 1.3,  1.5)                 5.8   \n",
       "...                ...               ...                 ...   \n",
       "65895              2.6      ( 2.5,  2.8)                15.6   \n",
       "65896              3.7      ( 3.4,  4.0)                21.2   \n",
       "65897              2.7      ( 2.5,  2.9)                17.7   \n",
       "65898              3.3      ( 3.1,  3.4)                17.8   \n",
       "65899              2.0      ( 1.8,  2.2)                 6.6   \n",
       "\n",
       "       TEETHLOST_Crude95CI                       Geolocation  \n",
       "65683         ( 3.4, 11.7)  POINT (-97.75325949 30.32315102)  \n",
       "65684         ( 2.8,  8.2)  POINT (-97.76709614 30.32586682)  \n",
       "65685         ( 6.1, 15.8)  POINT (-97.73667752 30.31261233)  \n",
       "65686         ( 4.7, 11.0)  POINT (-97.74445438 30.30715848)  \n",
       "65687         ( 3.8,  8.9)  POINT (-97.73433313 30.32614399)  \n",
       "...                    ...                               ...  \n",
       "65895         (13.0, 18.4)  POINT (-97.57654668 30.18797306)  \n",
       "65896         (17.0, 26.0)  POINT (-97.74187409 30.07372545)  \n",
       "65897         (14.8, 20.9)  POINT (-97.62875648 30.14543349)  \n",
       "65898         (15.3, 20.3)  POINT (-97.66645455 30.10380339)  \n",
       "65899         ( 4.2, 11.0)  POINT (-97.75528725 30.41665935)  \n",
       "\n",
       "[217 rows x 63 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "health_data_atx.rename({'TractFIPS': 'CTGEOID'}, axis=1, inplace=True)\n",
    "health_data_atx"
   ]
  },
  {
   "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>STATEFP</th>\n",
       "      <th>COUNTYFP</th>\n",
       "      <th>TRACTCE</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>FUNCSTAT</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>...</th>\n",
       "      <th>B01001_001E</th>\n",
       "      <th>pelderlybg</th>\n",
       "      <th>pchildbg</th>\n",
       "      <th>palonebg</th>\n",
       "      <th>pnocombg</th>\n",
       "      <th>medincome</th>\n",
       "      <th>hunit</th>\n",
       "      <th>pnophonebg</th>\n",
       "      <th>poldhubg</th>\n",
       "      <th>pnohvacbg</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2110</td>\n",
       "      <td>48453002110</td>\n",
       "      <td>21.10</td>\n",
       "      <td>Census Tract 21.10</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>3542307</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4221.0</td>\n",
       "      <td>11.276949</td>\n",
       "      <td>51.836058</td>\n",
       "      <td>22.401171</td>\n",
       "      <td>17.000241</td>\n",
       "      <td>46265.0</td>\n",
       "      <td>1635.0</td>\n",
       "      <td>1.244510</td>\n",
       "      <td>61.834862</td>\n",
       "      <td>1.171303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2111</td>\n",
       "      <td>48453002111</td>\n",
       "      <td>21.11</td>\n",
       "      <td>Census Tract 21.11</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>6502293</td>\n",
       "      <td>210192</td>\n",
       "      <td>...</td>\n",
       "      <td>5642.0</td>\n",
       "      <td>10.563630</td>\n",
       "      <td>55.157745</td>\n",
       "      <td>22.332016</td>\n",
       "      <td>18.415456</td>\n",
       "      <td>54392.0</td>\n",
       "      <td>2191.0</td>\n",
       "      <td>1.037549</td>\n",
       "      <td>39.114560</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2105</td>\n",
       "      <td>48453002105</td>\n",
       "      <td>21.05</td>\n",
       "      <td>Census Tract 21.05</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1937085</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5090.0</td>\n",
       "      <td>7.799607</td>\n",
       "      <td>50.550098</td>\n",
       "      <td>34.635541</td>\n",
       "      <td>26.629791</td>\n",
       "      <td>43480.0</td>\n",
       "      <td>2474.0</td>\n",
       "      <td>4.764173</td>\n",
       "      <td>53.516572</td>\n",
       "      <td>0.476417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2106</td>\n",
       "      <td>48453002106</td>\n",
       "      <td>21.06</td>\n",
       "      <td>Census Tract 21.06</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1629279</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3087.0</td>\n",
       "      <td>10.171688</td>\n",
       "      <td>51.182378</td>\n",
       "      <td>19.878997</td>\n",
       "      <td>15.289525</td>\n",
       "      <td>92260.0</td>\n",
       "      <td>1276.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>91.614420</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2107</td>\n",
       "      <td>48453002107</td>\n",
       "      <td>21.07</td>\n",
       "      <td>Census Tract 21.07</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>3057210</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4988.0</td>\n",
       "      <td>10.184443</td>\n",
       "      <td>50.781877</td>\n",
       "      <td>25.721455</td>\n",
       "      <td>25.457537</td>\n",
       "      <td>58542.0</td>\n",
       "      <td>1693.0</td>\n",
       "      <td>0.188206</td>\n",
       "      <td>76.609569</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>1912</td>\n",
       "      <td>48453001912</td>\n",
       "      <td>19.12</td>\n",
       "      <td>Census Tract 19.12</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>13460746</td>\n",
       "      <td>1291827</td>\n",
       "      <td>...</td>\n",
       "      <td>4129.0</td>\n",
       "      <td>16.541535</td>\n",
       "      <td>53.523856</td>\n",
       "      <td>23.441558</td>\n",
       "      <td>1.012915</td>\n",
       "      <td>155781.0</td>\n",
       "      <td>1769.0</td>\n",
       "      <td>0.584416</td>\n",
       "      <td>12.379876</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>1856</td>\n",
       "      <td>48453001856</td>\n",
       "      <td>18.56</td>\n",
       "      <td>Census Tract 18.56</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>61760279</td>\n",
       "      <td>25850</td>\n",
       "      <td>...</td>\n",
       "      <td>9214.0</td>\n",
       "      <td>7.152160</td>\n",
       "      <td>53.744302</td>\n",
       "      <td>15.495495</td>\n",
       "      <td>5.554348</td>\n",
       "      <td>94125.0</td>\n",
       "      <td>3014.0</td>\n",
       "      <td>1.441441</td>\n",
       "      <td>1.924353</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2112</td>\n",
       "      <td>48453002112</td>\n",
       "      <td>21.12</td>\n",
       "      <td>Census Tract 21.12</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1703455</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5426.0</td>\n",
       "      <td>8.145964</td>\n",
       "      <td>59.767785</td>\n",
       "      <td>32.363829</td>\n",
       "      <td>27.944745</td>\n",
       "      <td>40665.0</td>\n",
       "      <td>2259.0</td>\n",
       "      <td>0.951877</td>\n",
       "      <td>69.632581</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2113</td>\n",
       "      <td>48453002113</td>\n",
       "      <td>21.13</td>\n",
       "      <td>Census Tract 21.13</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>2055522</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3703.0</td>\n",
       "      <td>13.151499</td>\n",
       "      <td>52.930057</td>\n",
       "      <td>19.744318</td>\n",
       "      <td>21.539298</td>\n",
       "      <td>76019.0</td>\n",
       "      <td>1535.0</td>\n",
       "      <td>0.710227</td>\n",
       "      <td>75.439739</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2201</td>\n",
       "      <td>48453002201</td>\n",
       "      <td>22.01</td>\n",
       "      <td>Census Tract 22.01</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>5171432</td>\n",
       "      <td>1348</td>\n",
       "      <td>...</td>\n",
       "      <td>2223.0</td>\n",
       "      <td>9.176788</td>\n",
       "      <td>61.358525</td>\n",
       "      <td>17.168675</td>\n",
       "      <td>11.201080</td>\n",
       "      <td>53617.0</td>\n",
       "      <td>694.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>52.881844</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>218 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     STATEFP  COUNTYFP  TRACTCE        GEOID   NAME            NAMELSAD  \\\n",
       "0         48       453     2110  48453002110  21.10  Census Tract 21.10   \n",
       "1         48       453     2111  48453002111  21.11  Census Tract 21.11   \n",
       "2         48       453     2105  48453002105  21.05  Census Tract 21.05   \n",
       "3         48       453     2106  48453002106  21.06  Census Tract 21.06   \n",
       "4         48       453     2107  48453002107  21.07  Census Tract 21.07   \n",
       "..       ...       ...      ...          ...    ...                 ...   \n",
       "213       48       453     1912  48453001912  19.12  Census Tract 19.12   \n",
       "214       48       453     1856  48453001856  18.56  Census Tract 18.56   \n",
       "215       48       453     2112  48453002112  21.12  Census Tract 21.12   \n",
       "216       48       453     2113  48453002113  21.13  Census Tract 21.13   \n",
       "217       48       453     2201  48453002201  22.01  Census Tract 22.01   \n",
       "\n",
       "     MTFCC FUNCSTAT     ALAND   AWATER  ...  B01001_001E  pelderlybg  \\\n",
       "0    G5020        S   3542307        0  ...       4221.0   11.276949   \n",
       "1    G5020        S   6502293   210192  ...       5642.0   10.563630   \n",
       "2    G5020        S   1937085        0  ...       5090.0    7.799607   \n",
       "3    G5020        S   1629279        0  ...       3087.0   10.171688   \n",
       "4    G5020        S   3057210        0  ...       4988.0   10.184443   \n",
       "..     ...      ...       ...      ...  ...          ...         ...   \n",
       "213  G5020        S  13460746  1291827  ...       4129.0   16.541535   \n",
       "214  G5020        S  61760279    25850  ...       9214.0    7.152160   \n",
       "215  G5020        S   1703455        0  ...       5426.0    8.145964   \n",
       "216  G5020        S   2055522        0  ...       3703.0   13.151499   \n",
       "217  G5020        S   5171432     1348  ...       2223.0    9.176788   \n",
       "\n",
       "      pchildbg   palonebg   pnocombg  medincome   hunit  pnophonebg  \\\n",
       "0    51.836058  22.401171  17.000241    46265.0  1635.0    1.244510   \n",
       "1    55.157745  22.332016  18.415456    54392.0  2191.0    1.037549   \n",
       "2    50.550098  34.635541  26.629791    43480.0  2474.0    4.764173   \n",
       "3    51.182378  19.878997  15.289525    92260.0  1276.0    0.000000   \n",
       "4    50.781877  25.721455  25.457537    58542.0  1693.0    0.188206   \n",
       "..         ...        ...        ...        ...     ...         ...   \n",
       "213  53.523856  23.441558   1.012915   155781.0  1769.0    0.584416   \n",
       "214  53.744302  15.495495   5.554348    94125.0  3014.0    1.441441   \n",
       "215  59.767785  32.363829  27.944745    40665.0  2259.0    0.951877   \n",
       "216  52.930057  19.744318  21.539298    76019.0  1535.0    0.710227   \n",
       "217  61.358525  17.168675  11.201080    53617.0   694.0    0.000000   \n",
       "\n",
       "      poldhubg  pnohvacbg  \n",
       "0    61.834862   1.171303  \n",
       "1    39.114560   0.000000  \n",
       "2    53.516572   0.476417  \n",
       "3    91.614420   0.000000  \n",
       "4    76.609569   0.000000  \n",
       "..         ...        ...  \n",
       "213  12.379876   0.000000  \n",
       "214   1.924353   0.000000  \n",
       "215  69.632581   0.000000  \n",
       "216  75.439739   0.000000  \n",
       "217  52.881844   0.000000  \n",
       "\n",
       "[218 rows x 29 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "social_data_2010 = pd.read_csv(\"/Users/akhil/Documents/Fire Vulnerability Project/Input Data/ACS2019.csv\")\n",
    "social_data_2010"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>STATEFP</th>\n",
       "      <th>COUNTYFP</th>\n",
       "      <th>TRACTCE</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>FUNCSTAT</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>...</th>\n",
       "      <th>OBESITY_Crude95CI</th>\n",
       "      <th>PHLTH_CrudePrev</th>\n",
       "      <th>PHLTH_Crude95CI</th>\n",
       "      <th>SLEEP_CrudePrev</th>\n",
       "      <th>SLEEP_Crude95CI</th>\n",
       "      <th>STROKE_CrudePrev</th>\n",
       "      <th>STROKE_Crude95CI</th>\n",
       "      <th>TEETHLOST_CrudePrev</th>\n",
       "      <th>TEETHLOST_Crude95CI</th>\n",
       "      <th>Geolocation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2110</td>\n",
       "      <td>48453002110</td>\n",
       "      <td>21.10</td>\n",
       "      <td>Census Tract 21.10</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>3542307</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>(33.7, 35.3)</td>\n",
       "      <td>13.2</td>\n",
       "      <td>(12.5, 14.3)</td>\n",
       "      <td>36.7</td>\n",
       "      <td>(35.9, 37.8)</td>\n",
       "      <td>3.5</td>\n",
       "      <td>( 3.2,  3.8)</td>\n",
       "      <td>19.7</td>\n",
       "      <td>(15.0, 25.2)</td>\n",
       "      <td>POINT (-97.67746687 30.27405076)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2111</td>\n",
       "      <td>48453002111</td>\n",
       "      <td>21.11</td>\n",
       "      <td>Census Tract 21.11</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>6502293</td>\n",
       "      <td>210192</td>\n",
       "      <td>...</td>\n",
       "      <td>(35.4, 37.5)</td>\n",
       "      <td>15.2</td>\n",
       "      <td>(14.2, 16.6)</td>\n",
       "      <td>36.7</td>\n",
       "      <td>(35.5, 37.8)</td>\n",
       "      <td>3.6</td>\n",
       "      <td>( 3.3,  3.8)</td>\n",
       "      <td>20.4</td>\n",
       "      <td>(15.4, 25.4)</td>\n",
       "      <td>POINT (-97.68613435 30.25718252)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2105</td>\n",
       "      <td>48453002105</td>\n",
       "      <td>21.05</td>\n",
       "      <td>Census Tract 21.05</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1937085</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>(31.6, 33.3)</td>\n",
       "      <td>12.3</td>\n",
       "      <td>(10.7, 13.1)</td>\n",
       "      <td>35.6</td>\n",
       "      <td>(34.1, 36.4)</td>\n",
       "      <td>2.7</td>\n",
       "      <td>( 2.5,  2.8)</td>\n",
       "      <td>18.3</td>\n",
       "      <td>(14.0, 22.8)</td>\n",
       "      <td>POINT (-97.70558971 30.314915)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2106</td>\n",
       "      <td>48453002106</td>\n",
       "      <td>21.06</td>\n",
       "      <td>Census Tract 21.06</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1629279</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>(26.7, 28.8)</td>\n",
       "      <td>9.2</td>\n",
       "      <td>( 8.3,  9.9)</td>\n",
       "      <td>31.2</td>\n",
       "      <td>(29.8, 32.1)</td>\n",
       "      <td>2.6</td>\n",
       "      <td>( 2.3,  2.9)</td>\n",
       "      <td>8.7</td>\n",
       "      <td>( 5.7, 12.9)</td>\n",
       "      <td>POINT (-97.69032801 30.30673846)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2107</td>\n",
       "      <td>48453002107</td>\n",
       "      <td>21.07</td>\n",
       "      <td>Census Tract 21.07</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>3057210</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>(32.7, 34.8)</td>\n",
       "      <td>13.0</td>\n",
       "      <td>(11.6, 14.5)</td>\n",
       "      <td>36.5</td>\n",
       "      <td>(34.9, 37.6)</td>\n",
       "      <td>3.8</td>\n",
       "      <td>( 3.4,  4.2)</td>\n",
       "      <td>17.5</td>\n",
       "      <td>(11.7, 23.4)</td>\n",
       "      <td>POINT (-97.68287391 30.29566485)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>1912</td>\n",
       "      <td>48453001912</td>\n",
       "      <td>19.12</td>\n",
       "      <td>Census Tract 19.12</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>13460746</td>\n",
       "      <td>1291827</td>\n",
       "      <td>...</td>\n",
       "      <td>(23.4, 24.7)</td>\n",
       "      <td>8.3</td>\n",
       "      <td>( 7.5,  9.1)</td>\n",
       "      <td>28.1</td>\n",
       "      <td>(27.2, 29.2)</td>\n",
       "      <td>2.2</td>\n",
       "      <td>( 2.0,  2.4)</td>\n",
       "      <td>4.8</td>\n",
       "      <td>( 3.6,  6.7)</td>\n",
       "      <td>POINT (-97.82060841 30.32615246)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>1856</td>\n",
       "      <td>48453001856</td>\n",
       "      <td>18.56</td>\n",
       "      <td>Census Tract 18.56</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>61760279</td>\n",
       "      <td>25850</td>\n",
       "      <td>...</td>\n",
       "      <td>(29.0, 30.1)</td>\n",
       "      <td>10.3</td>\n",
       "      <td>( 9.4, 11.0)</td>\n",
       "      <td>34.6</td>\n",
       "      <td>(33.8, 35.2)</td>\n",
       "      <td>2.4</td>\n",
       "      <td>( 2.3,  2.6)</td>\n",
       "      <td>10.7</td>\n",
       "      <td>( 8.8, 12.9)</td>\n",
       "      <td>POINT (-97.57883799 30.36997484)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2112</td>\n",
       "      <td>48453002112</td>\n",
       "      <td>21.12</td>\n",
       "      <td>Census Tract 21.12</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1703455</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>(35.3, 36.9)</td>\n",
       "      <td>15.5</td>\n",
       "      <td>(14.3, 16.9)</td>\n",
       "      <td>37.8</td>\n",
       "      <td>(36.9, 38.8)</td>\n",
       "      <td>3.5</td>\n",
       "      <td>( 3.2,  3.7)</td>\n",
       "      <td>23.5</td>\n",
       "      <td>(17.7, 29.7)</td>\n",
       "      <td>POINT (-97.68259671 30.31391498)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2113</td>\n",
       "      <td>48453002113</td>\n",
       "      <td>21.13</td>\n",
       "      <td>Census Tract 21.13</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>2055522</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>(29.9, 32.1)</td>\n",
       "      <td>11.0</td>\n",
       "      <td>(10.2, 12.2)</td>\n",
       "      <td>33.8</td>\n",
       "      <td>(32.9, 35.1)</td>\n",
       "      <td>3.1</td>\n",
       "      <td>( 2.8,  3.5)</td>\n",
       "      <td>12.6</td>\n",
       "      <td>( 8.5, 17.7)</td>\n",
       "      <td>POINT (-97.67257894 30.31700683)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2201</td>\n",
       "      <td>48453002201</td>\n",
       "      <td>22.01</td>\n",
       "      <td>Census Tract 22.01</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>5171432</td>\n",
       "      <td>1348</td>\n",
       "      <td>...</td>\n",
       "      <td>(38.2, 40.0)</td>\n",
       "      <td>16.2</td>\n",
       "      <td>(14.8, 17.3)</td>\n",
       "      <td>40.5</td>\n",
       "      <td>(39.6, 41.2)</td>\n",
       "      <td>4.7</td>\n",
       "      <td>( 4.3,  5.1)</td>\n",
       "      <td>23.6</td>\n",
       "      <td>(18.6, 28.7)</td>\n",
       "      <td>POINT (-97.65575241 30.31811291)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>217 rows × 92 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     STATEFP  COUNTYFP  TRACTCE        GEOID   NAME            NAMELSAD  \\\n",
       "0         48       453     2110  48453002110  21.10  Census Tract 21.10   \n",
       "1         48       453     2111  48453002111  21.11  Census Tract 21.11   \n",
       "2         48       453     2105  48453002105  21.05  Census Tract 21.05   \n",
       "3         48       453     2106  48453002106  21.06  Census Tract 21.06   \n",
       "4         48       453     2107  48453002107  21.07  Census Tract 21.07   \n",
       "..       ...       ...      ...          ...    ...                 ...   \n",
       "212       48       453     1912  48453001912  19.12  Census Tract 19.12   \n",
       "213       48       453     1856  48453001856  18.56  Census Tract 18.56   \n",
       "214       48       453     2112  48453002112  21.12  Census Tract 21.12   \n",
       "215       48       453     2113  48453002113  21.13  Census Tract 21.13   \n",
       "216       48       453     2201  48453002201  22.01  Census Tract 22.01   \n",
       "\n",
       "     MTFCC FUNCSTAT     ALAND   AWATER  ...  OBESITY_Crude95CI  \\\n",
       "0    G5020        S   3542307        0  ...       (33.7, 35.3)   \n",
       "1    G5020        S   6502293   210192  ...       (35.4, 37.5)   \n",
       "2    G5020        S   1937085        0  ...       (31.6, 33.3)   \n",
       "3    G5020        S   1629279        0  ...       (26.7, 28.8)   \n",
       "4    G5020        S   3057210        0  ...       (32.7, 34.8)   \n",
       "..     ...      ...       ...      ...  ...                ...   \n",
       "212  G5020        S  13460746  1291827  ...       (23.4, 24.7)   \n",
       "213  G5020        S  61760279    25850  ...       (29.0, 30.1)   \n",
       "214  G5020        S   1703455        0  ...       (35.3, 36.9)   \n",
       "215  G5020        S   2055522        0  ...       (29.9, 32.1)   \n",
       "216  G5020        S   5171432     1348  ...       (38.2, 40.0)   \n",
       "\n",
       "     PHLTH_CrudePrev PHLTH_Crude95CI  SLEEP_CrudePrev  SLEEP_Crude95CI  \\\n",
       "0               13.2    (12.5, 14.3)             36.7     (35.9, 37.8)   \n",
       "1               15.2    (14.2, 16.6)             36.7     (35.5, 37.8)   \n",
       "2               12.3    (10.7, 13.1)             35.6     (34.1, 36.4)   \n",
       "3                9.2    ( 8.3,  9.9)             31.2     (29.8, 32.1)   \n",
       "4               13.0    (11.6, 14.5)             36.5     (34.9, 37.6)   \n",
       "..               ...             ...              ...              ...   \n",
       "212              8.3    ( 7.5,  9.1)             28.1     (27.2, 29.2)   \n",
       "213             10.3    ( 9.4, 11.0)             34.6     (33.8, 35.2)   \n",
       "214             15.5    (14.3, 16.9)             37.8     (36.9, 38.8)   \n",
       "215             11.0    (10.2, 12.2)             33.8     (32.9, 35.1)   \n",
       "216             16.2    (14.8, 17.3)             40.5     (39.6, 41.2)   \n",
       "\n",
       "     STROKE_CrudePrev  STROKE_Crude95CI  TEETHLOST_CrudePrev  \\\n",
       "0                 3.5      ( 3.2,  3.8)                 19.7   \n",
       "1                 3.6      ( 3.3,  3.8)                 20.4   \n",
       "2                 2.7      ( 2.5,  2.8)                 18.3   \n",
       "3                 2.6      ( 2.3,  2.9)                  8.7   \n",
       "4                 3.8      ( 3.4,  4.2)                 17.5   \n",
       "..                ...               ...                  ...   \n",
       "212               2.2      ( 2.0,  2.4)                  4.8   \n",
       "213               2.4      ( 2.3,  2.6)                 10.7   \n",
       "214               3.5      ( 3.2,  3.7)                 23.5   \n",
       "215               3.1      ( 2.8,  3.5)                 12.6   \n",
       "216               4.7      ( 4.3,  5.1)                 23.6   \n",
       "\n",
       "     TEETHLOST_Crude95CI                       Geolocation  \n",
       "0           (15.0, 25.2)  POINT (-97.67746687 30.27405076)  \n",
       "1           (15.4, 25.4)  POINT (-97.68613435 30.25718252)  \n",
       "2           (14.0, 22.8)    POINT (-97.70558971 30.314915)  \n",
       "3           ( 5.7, 12.9)  POINT (-97.69032801 30.30673846)  \n",
       "4           (11.7, 23.4)  POINT (-97.68287391 30.29566485)  \n",
       "..                   ...                               ...  \n",
       "212         ( 3.6,  6.7)  POINT (-97.82060841 30.32615246)  \n",
       "213         ( 8.8, 12.9)  POINT (-97.57883799 30.36997484)  \n",
       "214         (17.7, 29.7)  POINT (-97.68259671 30.31391498)  \n",
       "215         ( 8.5, 17.7)  POINT (-97.67257894 30.31700683)  \n",
       "216         (18.6, 28.7)  POINT (-97.65575241 30.31811291)  \n",
       "\n",
       "[217 rows x 92 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "social_health = pd.merge(left = social_data_2010, right = health_data_atx, how=\"inner\", left_on = \"GEOID\",right_on = \"CTGEOID\")\n",
    "social_health"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATEFP_x</th>\n",
       "      <th>COUNTYFP_x</th>\n",
       "      <th>TRACTCE_x</th>\n",
       "      <th>GEOID_x</th>\n",
       "      <th>NAME_x</th>\n",
       "      <th>NAMELSAD_x</th>\n",
       "      <th>MTFCC_x</th>\n",
       "      <th>FUNCSTAT</th>\n",
       "      <th>ALAND_x</th>\n",
       "      <th>AWATER_x</th>\n",
       "      <th>...</th>\n",
       "      <th>NAME_y</th>\n",
       "      <th>NAMELSAD_y</th>\n",
       "      <th>MTFCC_y</th>\n",
       "      <th>ALAND_y</th>\n",
       "      <th>AWATER_y</th>\n",
       "      <th>INTPTLAT_y</th>\n",
       "      <th>INTPTLON_y</th>\n",
       "      <th>CT_Area</th>\n",
       "      <th>intersect_area</th>\n",
       "      <th>Area_Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2110</td>\n",
       "      <td>48453002110</td>\n",
       "      <td>21.10</td>\n",
       "      <td>Census Tract 21.10</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>3542307</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.10</td>\n",
       "      <td>Census Tract 21.10</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3542307</td>\n",
       "      <td>0</td>\n",
       "      <td>30.274143</td>\n",
       "      <td>-97.677464</td>\n",
       "      <td>3542310</td>\n",
       "      <td>3542310</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2111</td>\n",
       "      <td>48453002111</td>\n",
       "      <td>21.11</td>\n",
       "      <td>Census Tract 21.11</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>6502293</td>\n",
       "      <td>210192</td>\n",
       "      <td>...</td>\n",
       "      <td>21.11</td>\n",
       "      <td>Census Tract 21.11</td>\n",
       "      <td>G5020</td>\n",
       "      <td>6502293</td>\n",
       "      <td>210192</td>\n",
       "      <td>30.259023</td>\n",
       "      <td>-97.687485</td>\n",
       "      <td>6712485</td>\n",
       "      <td>6709588</td>\n",
       "      <td>0.999568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2105</td>\n",
       "      <td>48453002105</td>\n",
       "      <td>21.05</td>\n",
       "      <td>Census Tract 21.05</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1937085</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.05</td>\n",
       "      <td>Census Tract 21.05</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1937085</td>\n",
       "      <td>0</td>\n",
       "      <td>30.314917</td>\n",
       "      <td>-97.705591</td>\n",
       "      <td>1937085</td>\n",
       "      <td>1937085</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2106</td>\n",
       "      <td>48453002106</td>\n",
       "      <td>21.06</td>\n",
       "      <td>Census Tract 21.06</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1629279</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.06</td>\n",
       "      <td>Census Tract 21.06</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1629279</td>\n",
       "      <td>0</td>\n",
       "      <td>30.306720</td>\n",
       "      <td>-97.690323</td>\n",
       "      <td>1629282</td>\n",
       "      <td>1629282</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2107</td>\n",
       "      <td>48453002107</td>\n",
       "      <td>21.07</td>\n",
       "      <td>Census Tract 21.07</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>3057210</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.07</td>\n",
       "      <td>Census Tract 21.07</td>\n",
       "      <td>G5020</td>\n",
       "      <td>3057210</td>\n",
       "      <td>0</td>\n",
       "      <td>30.295666</td>\n",
       "      <td>-97.682861</td>\n",
       "      <td>3057213</td>\n",
       "      <td>3057213</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>1757</td>\n",
       "      <td>48453001757</td>\n",
       "      <td>17.57</td>\n",
       "      <td>Census Tract 17.57</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>2196386</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>17.57</td>\n",
       "      <td>Census Tract 17.57</td>\n",
       "      <td>G5020</td>\n",
       "      <td>2196386</td>\n",
       "      <td>0</td>\n",
       "      <td>30.397827</td>\n",
       "      <td>-97.763940</td>\n",
       "      <td>2196385</td>\n",
       "      <td>2196385</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>1781</td>\n",
       "      <td>48453001781</td>\n",
       "      <td>17.81</td>\n",
       "      <td>Census Tract 17.81</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>2453147</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>17.81</td>\n",
       "      <td>Census Tract 17.81</td>\n",
       "      <td>G5020</td>\n",
       "      <td>2453147</td>\n",
       "      <td>0</td>\n",
       "      <td>30.439790</td>\n",
       "      <td>-97.796459</td>\n",
       "      <td>2453145</td>\n",
       "      <td>2453145</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>1777</td>\n",
       "      <td>48453001777</td>\n",
       "      <td>17.77</td>\n",
       "      <td>Census Tract 17.77</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>2674587</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>17.77</td>\n",
       "      <td>Census Tract 17.77</td>\n",
       "      <td>G5020</td>\n",
       "      <td>2674587</td>\n",
       "      <td>0</td>\n",
       "      <td>30.204710</td>\n",
       "      <td>-97.849773</td>\n",
       "      <td>2674588</td>\n",
       "      <td>2674588</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2112</td>\n",
       "      <td>48453002112</td>\n",
       "      <td>21.12</td>\n",
       "      <td>Census Tract 21.12</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>1703455</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.12</td>\n",
       "      <td>Census Tract 21.12</td>\n",
       "      <td>G5020</td>\n",
       "      <td>1703455</td>\n",
       "      <td>0</td>\n",
       "      <td>30.313924</td>\n",
       "      <td>-97.682598</td>\n",
       "      <td>1703454</td>\n",
       "      <td>1703454</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>48</td>\n",
       "      <td>453</td>\n",
       "      <td>2113</td>\n",
       "      <td>48453002113</td>\n",
       "      <td>21.13</td>\n",
       "      <td>Census Tract 21.13</td>\n",
       "      <td>G5020</td>\n",
       "      <td>S</td>\n",
       "      <td>2055522</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.13</td>\n",
       "      <td>Census Tract 21.13</td>\n",
       "      <td>G5020</td>\n",
       "      <td>2055522</td>\n",
       "      <td>0</td>\n",
       "      <td>30.317062</td>\n",
       "      <td>-97.672522</td>\n",
       "      <td>2055521</td>\n",
       "      <td>2055521</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140 rows × 121 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     STATEFP_x  COUNTYFP_x  TRACTCE_x      GEOID_x  NAME_x  \\\n",
       "0           48         453       2110  48453002110   21.10   \n",
       "1           48         453       2111  48453002111   21.11   \n",
       "2           48         453       2105  48453002105   21.05   \n",
       "3           48         453       2106  48453002106   21.06   \n",
       "4           48         453       2107  48453002107   21.07   \n",
       "..         ...         ...        ...          ...     ...   \n",
       "135         48         453       1757  48453001757   17.57   \n",
       "136         48         453       1781  48453001781   17.81   \n",
       "137         48         453       1777  48453001777   17.77   \n",
       "138         48         453       2112  48453002112   21.12   \n",
       "139         48         453       2113  48453002113   21.13   \n",
       "\n",
       "             NAMELSAD_x MTFCC_x FUNCSTAT  ALAND_x  AWATER_x  ...  NAME_y  \\\n",
       "0    Census Tract 21.10   G5020        S  3542307         0  ...   21.10   \n",
       "1    Census Tract 21.11   G5020        S  6502293    210192  ...   21.11   \n",
       "2    Census Tract 21.05   G5020        S  1937085         0  ...   21.05   \n",
       "3    Census Tract 21.06   G5020        S  1629279         0  ...   21.06   \n",
       "4    Census Tract 21.07   G5020        S  3057210         0  ...   21.07   \n",
       "..                  ...     ...      ...      ...       ...  ...     ...   \n",
       "135  Census Tract 17.57   G5020        S  2196386         0  ...   17.57   \n",
       "136  Census Tract 17.81   G5020        S  2453147         0  ...   17.81   \n",
       "137  Census Tract 17.77   G5020        S  2674587         0  ...   17.77   \n",
       "138  Census Tract 21.12   G5020        S  1703455         0  ...   21.12   \n",
       "139  Census Tract 21.13   G5020        S  2055522         0  ...   21.13   \n",
       "\n",
       "             NAMELSAD_y MTFCC_y  ALAND_y  AWATER_y  INTPTLAT_y  INTPTLON_y  \\\n",
       "0    Census Tract 21.10   G5020  3542307         0   30.274143  -97.677464   \n",
       "1    Census Tract 21.11   G5020  6502293    210192   30.259023  -97.687485   \n",
       "2    Census Tract 21.05   G5020  1937085         0   30.314917  -97.705591   \n",
       "3    Census Tract 21.06   G5020  1629279         0   30.306720  -97.690323   \n",
       "4    Census Tract 21.07   G5020  3057210         0   30.295666  -97.682861   \n",
       "..                  ...     ...      ...       ...         ...         ...   \n",
       "135  Census Tract 17.57   G5020  2196386         0   30.397827  -97.763940   \n",
       "136  Census Tract 17.81   G5020  2453147         0   30.439790  -97.796459   \n",
       "137  Census Tract 17.77   G5020  2674587         0   30.204710  -97.849773   \n",
       "138  Census Tract 21.12   G5020  1703455         0   30.313924  -97.682598   \n",
       "139  Census Tract 21.13   G5020  2055522         0   30.317062  -97.672522   \n",
       "\n",
       "     CT_Area  intersect_area  Area_Ratio  \n",
       "0    3542310         3542310    1.000000  \n",
       "1    6712485         6709588    0.999568  \n",
       "2    1937085         1937085    1.000000  \n",
       "3    1629282         1629282    1.000000  \n",
       "4    3057213         3057213    1.000000  \n",
       "..       ...             ...         ...  \n",
       "135  2196385         2196385    1.000000  \n",
       "136  2453145         2453145    1.000000  \n",
       "137  2674588         2674588    1.000000  \n",
       "138  1703454         1703454    1.000000  \n",
       "139  2055521         2055521    1.000000  \n",
       "\n",
       "[140 rows x 121 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "social_health_fire = pd.merge(left = social_health, right = filtered_census_tracts, how=\"inner\", left_on = \"GEOID\",right_on = \"CTID\")\n",
    "social_health_fire"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['STATEFP_x',\n",
       " 'COUNTYFP_x',\n",
       " 'TRACTCE_x',\n",
       " 'GEOID_x',\n",
       " 'NAME_x',\n",
       " 'NAMELSAD_x',\n",
       " 'MTFCC_x',\n",
       " 'FUNCSTAT',\n",
       " 'ALAND_x',\n",
       " 'AWATER_x',\n",
       " 'INTPTLAT_x',\n",
       " 'INTPTLON_x',\n",
       " 'geometry',\n",
       " 'GEOID10',\n",
       " 'B03002_001E',\n",
       " 'pnhwhitebg',\n",
       " 'pblackbg',\n",
       " 'phispbg',\n",
       " 'ploweconbg',\n",
       " 'B01001_001E',\n",
       " 'pelderlybg',\n",
       " 'pchildbg',\n",
       " 'palonebg',\n",
       " 'pnocombg',\n",
       " 'medincome',\n",
       " 'hunit',\n",
       " 'pnophonebg',\n",
       " 'poldhubg',\n",
       " 'pnohvacbg',\n",
       " 'StateAbbr',\n",
       " 'StateDesc',\n",
       " 'CountyName',\n",
       " 'CountyFIPS',\n",
       " 'CTGEOID',\n",
       " 'TotalPopulation',\n",
       " 'ACCESS2_CrudePrev',\n",
       " 'ACCESS2_Crude95CI',\n",
       " 'ARTHRITIS_CrudePrev',\n",
       " 'ARTHRITIS_Crude95CI',\n",
       " 'BINGE_CrudePrev',\n",
       " 'BINGE_Crude95CI',\n",
       " 'BPHIGH_CrudePrev',\n",
       " 'BPHIGH_Crude95CI',\n",
       " 'BPMED_CrudePrev',\n",
       " 'BPMED_Crude95CI',\n",
       " 'CANCER_CrudePrev',\n",
       " 'CANCER_Crude95CI',\n",
       " 'CASTHMA_CrudePrev',\n",
       " 'CASTHMA_Crude95CI',\n",
       " 'CERVICAL_CrudePrev',\n",
       " 'CERVICAL_Crude95CI',\n",
       " 'CHD_CrudePrev',\n",
       " 'CHD_Crude95CI',\n",
       " 'CHECKUP_CrudePrev',\n",
       " 'CHECKUP_Crude95CI',\n",
       " 'CHOLSCREEN_CrudePrev',\n",
       " 'CHOLSCREEN_Crude95CI',\n",
       " 'COLON_SCREEN_CrudePrev',\n",
       " 'COLON_SCREEN_Crude95CI',\n",
       " 'COPD_CrudePrev',\n",
       " 'COPD_Crude95CI',\n",
       " 'COREM_CrudePrev',\n",
       " 'COREM_Crude95CI',\n",
       " 'COREW_CrudePrev',\n",
       " 'COREW_Crude95CI',\n",
       " 'CSMOKING_CrudePrev',\n",
       " 'CSMOKING_Crude95CI',\n",
       " 'DENTAL_CrudePrev',\n",
       " 'DENTAL_Crude95CI',\n",
       " 'DIABETES_CrudePrev',\n",
       " 'DIABETES_Crude95CI',\n",
       " 'HIGHCHOL_CrudePrev',\n",
       " 'HIGHCHOL_Crude95CI',\n",
       " 'KIDNEY_CrudePrev',\n",
       " 'KIDNEY_Crude95CI',\n",
       " 'LPA_CrudePrev',\n",
       " 'LPA_Crude95CI',\n",
       " 'MAMMOUSE_CrudePrev',\n",
       " 'MAMMOUSE_Crude95CI',\n",
       " 'MHLTH_CrudePrev',\n",
       " 'MHLTH_Crude95CI',\n",
       " 'OBESITY_CrudePrev',\n",
       " 'OBESITY_Crude95CI',\n",
       " 'PHLTH_CrudePrev',\n",
       " 'PHLTH_Crude95CI',\n",
       " 'SLEEP_CrudePrev',\n",
       " 'SLEEP_Crude95CI',\n",
       " 'STROKE_CrudePrev',\n",
       " 'STROKE_Crude95CI',\n",
       " 'TEETHLOST_CrudePrev',\n",
       " 'TEETHLOST_Crude95CI',\n",
       " 'Geolocation',\n",
       " 'OBJECTID_1',\n",
       " 'Join_Count_2020',\n",
       " 'Join_Count_2019',\n",
       " 'Join_Count_2018',\n",
       " 'Join_Count_2017',\n",
       " 'Join_Count_2016',\n",
       " 'CTID',\n",
       " 'CTTEXT',\n",
       " 'Frequency',\n",
       " 'Intensity',\n",
       " 'Duration',\n",
       " 'HEMSC',\n",
       " 'z_freq',\n",
       " 'z_iten',\n",
       " 'z_dura',\n",
       " 'STATEFP_y',\n",
       " 'COUNTYFP_y',\n",
       " 'TRACTCE_y',\n",
       " 'GEOID_y',\n",
       " 'NAME_y',\n",
       " 'NAMELSAD_y',\n",
       " 'MTFCC_y',\n",
       " 'ALAND_y',\n",
       " 'AWATER_y',\n",
       " 'INTPTLAT_y',\n",
       " 'INTPTLON_y',\n",
       " 'CT_Area',\n",
       " 'intersect_area',\n",
       " 'Area_Ratio']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(social_health_fire.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "columns = ['TEETHLOST_CrudePrev','TEETHLOST_Crude95CI','Geolocation','OBJECTID_1','ARTHRITIS_CrudePrev','ARTHRITIS_Crude95CI','BINGE_CrudePrev','BINGE_Crude95CI','CERVICAL_CrudePrev','CERVICAL_Crude95CI','CHOLSCREEN_CrudePrev','CHOLSCREEN_Crude95CI','COLON_SCREEN_CrudePrev','COLON_SCREEN_Crude95CI','COREM_CrudePrev','COREM_Crude95CI','COREW_CrudePrev','COREW_Crude95CI','DENTAL_CrudePrev','DENTAL_Crude95CI','KIDNEY_CrudePrev','KIDNEY_Crude95CI','MAMMOUSE_CrudePrev','MAMMOUSE_Crude95CI','MHLTH_CrudePrev','MHLTH_Crude95CI','SLEEP_CrudePrev','SLEEP_Crude95CI','TEETHLOST_CrudePrev','TEETHLOST_Crude95CI']\n",
    "\n",
    "social_health_fire.drop(columns, axis=1, inplace=True)\n",
    "\n",
    "columns_2 = ['B01001_001E', 'B03002_001E', 'NAMELSAD_x','MTFCC_x','FUNCSTAT','ALAND_x','AWATER_x','INTPTLAT_x','INTPTLON_x','StateAbbr','StateDesc','CountyName','CountyFIPS','ACCESS2_Crude95CI','BPHIGH_Crude95CI','BPMED_Crude95CI','CANCER_Crude95CI','CASTHMA_Crude95CI','CHD_Crude95CI','CHECKUP_Crude95CI','COPD_Crude95CI','CSMOKING_Crude95CI','DIABETES_Crude95CI','HIGHCHOL_Crude95CI','LPA_Crude95CI','OBESITY_Crude95CI', 'PHLTH_Crude95CI', 'STROKE_Crude95CI']\n",
    "\n",
    "social_health_fire.drop(columns_2, axis=1, inplace=True)\n",
    "\n",
    "columns_3 = ['CTTEXT','Frequency','Intensity','Duration','HEMSC','z_freq','z_iten','z_dura','STATEFP_y','COUNTYFP_y','TRACTCE_y','GEOID_y','NAME_y','NAMELSAD_y','MTFCC_y','ALAND_y','AWATER_y','INTPTLAT_y','INTPTLON_y','CT_Area','intersect_area','Area_Ratio']\n",
    "\n",
    "social_health_fire.drop(columns_3, axis=1, inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "social_health_fire.rename(columns={'pnhwhitebg': 'pnhwhitect', 'pblackbg': 'pblackct', 'phispbg': 'phispct', 'ploweconbg':'ploweconct', 'pelderlybg':'pelderlyct', 'pchildbg':'pchildct', 'palonebg':'palonect',  'pnocombg': 'pnocomct'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "social_health_fire[\"total_count\"] = social_health_fire[\"Join_Count_2016\"] + social_health_fire[\"Join_Count_2017\"] + social_health_fire[\"Join_Count_2018\"] + social_health_fire[\"Join_Count_2019\"] + social_health_fire[\"Join_Count_2020\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['STATEFP_x',\n",
       " 'COUNTYFP_x',\n",
       " 'TRACTCE_x',\n",
       " 'GEOID_x',\n",
       " 'NAME_x',\n",
       " 'geometry',\n",
       " 'GEOID10',\n",
       " 'pnhwhitect',\n",
       " 'pblackct',\n",
       " 'phispct',\n",
       " 'ploweconct',\n",
       " 'pelderlyct',\n",
       " 'pchildct',\n",
       " 'palonect',\n",
       " 'pnocomct',\n",
       " 'medincome',\n",
       " 'hunit',\n",
       " 'pnophonebg',\n",
       " 'poldhubg',\n",
       " 'pnohvacbg',\n",
       " 'CTGEOID',\n",
       " 'TotalPopulation',\n",
       " 'ACCESS2_CrudePrev',\n",
       " 'BPHIGH_CrudePrev',\n",
       " 'BPMED_CrudePrev',\n",
       " 'CANCER_CrudePrev',\n",
       " 'CASTHMA_CrudePrev',\n",
       " 'CHD_CrudePrev',\n",
       " 'CHECKUP_CrudePrev',\n",
       " 'COPD_CrudePrev',\n",
       " 'CSMOKING_CrudePrev',\n",
       " 'DIABETES_CrudePrev',\n",
       " 'HIGHCHOL_CrudePrev',\n",
       " 'LPA_CrudePrev',\n",
       " 'OBESITY_CrudePrev',\n",
       " 'PHLTH_CrudePrev',\n",
       " 'STROKE_CrudePrev',\n",
       " 'Join_Count_2020',\n",
       " 'Join_Count_2019',\n",
       " 'Join_Count_2018',\n",
       " 'Join_Count_2017',\n",
       " 'Join_Count_2016',\n",
       " 'CTID',\n",
       " 'total_count']"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(social_health_fire.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "#social_health_fire.to_csv(\"complete_dataset.csv\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.9.15"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "1c252c5a11d930bf2d0ad3b6bcf94bd734a5cb7518a495e5089bdd9b6a1ef799"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}