heat-risk-mapping.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "be5cd7a2-3e29-434e-b616-51def02ae097",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "3b6b803b-1da5-4f28-ba28-ded9642e24d3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/Users/asaldanha'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e762563d-e932-4ae2-b683-41f8da2a4a2e",
   "metadata": {},
   "outputs": [],
   "source": [
    "os.chdir('/Users/asaldanha/Work/python')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "0071a4bb-7654-4a95-bb52-5219ede58356",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/Users/asaldanha/Work/python'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "4694c487-92f2-495b-8bee-b8f04786ddb1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "93b181eb-3b9c-43f8-aea5-c45559080628",
   "metadata": {},
   "outputs": [],
   "source": [
    "hdf = pd.read_csv(\"/Users/asaldanha/Downloads/hhi_tx.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "a7fb46de-7a73-4c3c-a775-2aab3b65b13a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data type of each column of Dataframe :\n",
      "STATEFP10          int64\n",
      "STATE             object\n",
      "STATE_ABV         object\n",
      "ZCTA               int64\n",
      "GEOID10            int64\n",
      "                  ...   \n",
      "PR_PM25          float64\n",
      "NBE_SCORE        float64\n",
      "NBE_RANK         float64\n",
      "OVERALL_SCORE    float64\n",
      "OVERALL_RANK     float64\n",
      "Length: 75, dtype: object\n"
     ]
    }
   ],
   "source": [
    "dataTypeSeries = hdf.dtypes\n",
    "print('Data type of each column of Dataframe :')\n",
    "print(dataTypeSeries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7d5ea5a1-7268-4d2a-a84e-e5551441a924",
   "metadata": {},
   "outputs": [],
   "source": [
    "hdf['GEOID10'] = hdf['GEOID10'].astype(str).apply(lambda x: x.replace('.0',''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "02faae99-e048-4e79-985d-20b6043ebf06",
   "metadata": {},
   "outputs": [],
   "source": [
    "hdf['ZCTA'] = hdf['ZCTA'].astype(str).apply(lambda x: x.replace('.0',''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "0076c4c5-f74e-442d-b3bf-35e885b4f4a6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data type of each column of Dataframe :\n",
      "STATEFP10          int64\n",
      "STATE             object\n",
      "STATE_ABV         object\n",
      "ZCTA              object\n",
      "GEOID10           object\n",
      "                  ...   \n",
      "PR_PM25          float64\n",
      "NBE_SCORE        float64\n",
      "NBE_RANK         float64\n",
      "OVERALL_SCORE    float64\n",
      "OVERALL_RANK     float64\n",
      "Length: 75, dtype: object\n"
     ]
    }
   ],
   "source": [
    "dataTypeSeries = hdf.dtypes\n",
    "print('Data type of each column of Dataframe :')\n",
    "print(dataTypeSeries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "cd072a08-573c-4deb-9f82-d3a36dd30eed",
   "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>STATEFP10</th>\n",
       "      <th>STATE</th>\n",
       "      <th>STATE_ABV</th>\n",
       "      <th>ZCTA</th>\n",
       "      <th>GEOID10</th>\n",
       "      <th>MULTI_STATE</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>...</th>\n",
       "      <th>P_RENT</th>\n",
       "      <th>PR_RENT</th>\n",
       "      <th>P_OZONE</th>\n",
       "      <th>PR_OZONE</th>\n",
       "      <th>P_PM25</th>\n",
       "      <th>PR_PM25</th>\n",
       "      <th>NBE_SCORE</th>\n",
       "      <th>NBE_RANK</th>\n",
       "      <th>OVERALL_SCORE</th>\n",
       "      <th>OVERALL_RANK</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>73949</td>\n",
       "      <td>4873949</td>\n",
       "      <td>1</td>\n",
       "      <td>1688</td>\n",
       "      <td>68</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>34.928230</td>\n",
       "      <td>0.7684</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.6180</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.5074</td>\n",
       "      <td>0.6670</td>\n",
       "      <td>0.6712</td>\n",
       "      <td>0.8462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>0</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>82.888424</td>\n",
       "      <td>0.9852</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>0.9472</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7031</td>\n",
       "      <td>0.9440</td>\n",
       "      <td>0.5510</td>\n",
       "      <td>0.6627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75002</td>\n",
       "      <td>4875002</td>\n",
       "      <td>0</td>\n",
       "      <td>63140</td>\n",
       "      <td>54</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.299188</td>\n",
       "      <td>0.4391</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>0.9349</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6228</td>\n",
       "      <td>0.8673</td>\n",
       "      <td>0.4398</td>\n",
       "      <td>0.4427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>0</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>49.364908</td>\n",
       "      <td>0.9031</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7188</td>\n",
       "      <td>0.9538</td>\n",
       "      <td>0.5986</td>\n",
       "      <td>0.7432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>0</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>27.721552</td>\n",
       "      <td>0.6238</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6759</td>\n",
       "      <td>0.9238</td>\n",
       "      <td>0.4737</td>\n",
       "      <td>0.5112</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 75 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATEFP10 STATE STATE_ABV   ZCTA  GEOID10  MULTI_STATE    POP  PR_HRI  \\\n",
       "0         48    TX     Texas  73949  4873949            1   1688      68   \n",
       "1         48    TX     Texas  75001  4875001            0  12414      78   \n",
       "2         48    TX     Texas  75002  4875002            0  63140      54   \n",
       "3         48    TX     Texas  75006  4875006            0  46364      70   \n",
       "4         48    TX     Texas  75007  4875007            0  51624      65   \n",
       "\n",
       "   F_HRI  LOW_EMS  ...     P_RENT  PR_RENT   P_OZONE  PR_OZONE    P_PM25  \\\n",
       "0   0.75        0  ...  34.928230   0.7684  0.666667    0.6180  0.000000   \n",
       "1   1.00        0  ...  82.888424   0.9852  5.333333    0.9472  1.333333   \n",
       "2   0.75        0  ...  21.299188   0.4391  4.666667    0.9349  1.333333   \n",
       "3   0.75        0  ...  49.364908   0.9031  6.000000    0.9573  1.333333   \n",
       "4   0.75        0  ...  27.721552   0.6238  6.000000    0.9573  1.333333   \n",
       "\n",
       "   PR_PM25  NBE_SCORE  NBE_RANK  OVERALL_SCORE  OVERALL_RANK  \n",
       "0   0.0000     0.5074    0.6670         0.6712        0.8462  \n",
       "1   0.8668     0.7031    0.9440         0.5510        0.6627  \n",
       "2   0.8668     0.6228    0.8673         0.4398        0.4427  \n",
       "3   0.8668     0.7188    0.9538         0.5986        0.7432  \n",
       "4   0.8668     0.6759    0.9238         0.4737        0.5112  \n",
       "\n",
       "[5 rows x 75 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "6d31f169-9e17-47f1-b9c2-9f21fa7959ce",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['STATEFP10', 'MULTI_STATE', 'POP', 'PR_HRI', 'F_HRI', 'LOW_EMS',\n",
      "       'P_NEHD', 'PR_NEHD', 'HHB_SCORE', 'HHB_RANK', 'P_CHD', 'PR_CHD',\n",
      "       'F_CHD', 'P_OBS', 'PR_OBS', 'F_OBS', 'P_DIABETES', 'PR_DIABETES',\n",
      "       'F_DIABETES', 'P_COPD', 'PR_COPD', 'F_COPD', 'P_ASTHMA', 'PR_ASTHMA',\n",
      "       'F_ASTHMA', 'P_MNTHL', 'PR_MNTHL', 'F_MNTHL', 'F_SEN_COUNT',\n",
      "       'SEN_SCORE', 'SEN_RANK', 'P_UNINSUR', 'PR_UNINSUR', 'P_POV', 'PR_POV',\n",
      "       'P_UNEMP', 'PR_UNEMP', 'P_NOHSDP', 'PR_NOHSDP', 'P_ISO', 'PR_ISO',\n",
      "       'P_ELP', 'PR_ELP', 'P_DISABL', 'PR_DISABL', 'P_ODW', 'PR_ODW',\n",
      "       'P_AGE65', 'PR_AGE65', 'P_AGE5', 'PR_AGE5', 'SOCIODEM_SCORE',\n",
      "       'SOCIODEM_RANK', 'P_IMPERV', 'PR_IMPERV', 'P_TREEC', 'PR_TREEC',\n",
      "       'P_NOVEH', 'PR_NOVEH', 'P_MOBILE', 'PR_MOBILE', 'P_RENT', 'PR_RENT',\n",
      "       'P_OZONE', 'PR_OZONE', 'P_PM25', 'PR_PM25', 'NBE_SCORE', 'NBE_RANK',\n",
      "       'OVERALL_SCORE', 'OVERALL_RANK'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "num_vars = hdf.columns[hdf.dtypes != 'object']\n",
    "print(num_vars)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "e47efbc3-4604-4b22-8b53-e345666e0fab",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['STATE', 'STATE_ABV', 'ZCTA', 'GEOID10'], dtype='object')\n"
     ]
    }
   ],
   "source": [
    "char_vars = hdf.columns[hdf.dtypes == 'object']\n",
    "print(char_vars)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "0a00b847-12d7-4a25-b20e-65d32174dd79",
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopandas as gpd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "4ac452eb-eadb-4366-9e66-1b092a24301b",
   "metadata": {},
   "outputs": [],
   "source": [
    "zipshp = gpd.read_file('/Users/asaldanha/Downloads/tl_2020_us_zcta520/tl_2020_us_zcta520.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "df6348a0-d360-4acf-ae70-a3f13b9439ab",
   "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>ZCTA5CE20</th>\n",
       "      <th>GEOID20</th>\n",
       "      <th>CLASSFP20</th>\n",
       "      <th>MTFCC20</th>\n",
       "      <th>FUNCSTAT20</th>\n",
       "      <th>ALAND20</th>\n",
       "      <th>AWATER20</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>INTPTLON20</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35592</td>\n",
       "      <td>35592</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>298552385</td>\n",
       "      <td>235989</td>\n",
       "      <td>+33.7427261</td>\n",
       "      <td>-088.0973903</td>\n",
       "      <td>POLYGON ((-88.24735 33.6539, -88.24713 33.6541...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35616</td>\n",
       "      <td>35616</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>559506992</td>\n",
       "      <td>41870756</td>\n",
       "      <td>+34.7395036</td>\n",
       "      <td>-088.0193814</td>\n",
       "      <td>POLYGON ((-88.13997 34.58184, -88.13995 34.582...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>35621</td>\n",
       "      <td>35621</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>117838488</td>\n",
       "      <td>409438</td>\n",
       "      <td>+34.3350314</td>\n",
       "      <td>-086.7270557</td>\n",
       "      <td>POLYGON ((-86.81659 34.3496, -86.81648 34.3496...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>35651</td>\n",
       "      <td>35651</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>104521045</td>\n",
       "      <td>574316</td>\n",
       "      <td>+34.4609087</td>\n",
       "      <td>-087.4801507</td>\n",
       "      <td>POLYGON ((-87.53087 34.42492, -87.53082 34.429...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36010</td>\n",
       "      <td>36010</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>335675180</td>\n",
       "      <td>236811</td>\n",
       "      <td>+31.6598950</td>\n",
       "      <td>-085.8128958</td>\n",
       "      <td>POLYGON ((-85.95712 31.67744, -85.95676 31.677...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ZCTA5CE20 GEOID20 CLASSFP20 MTFCC20 FUNCSTAT20    ALAND20  AWATER20  \\\n",
       "0     35592   35592        B5   G6350          S  298552385    235989   \n",
       "1     35616   35616        B5   G6350          S  559506992  41870756   \n",
       "2     35621   35621        B5   G6350          S  117838488    409438   \n",
       "3     35651   35651        B5   G6350          S  104521045    574316   \n",
       "4     36010   36010        B5   G6350          S  335675180    236811   \n",
       "\n",
       "    INTPTLAT20    INTPTLON20  \\\n",
       "0  +33.7427261  -088.0973903   \n",
       "1  +34.7395036  -088.0193814   \n",
       "2  +34.3350314  -086.7270557   \n",
       "3  +34.4609087  -087.4801507   \n",
       "4  +31.6598950  -085.8128958   \n",
       "\n",
       "                                            geometry  \n",
       "0  POLYGON ((-88.24735 33.6539, -88.24713 33.6541...  \n",
       "1  POLYGON ((-88.13997 34.58184, -88.13995 34.582...  \n",
       "2  POLYGON ((-86.81659 34.3496, -86.81648 34.3496...  \n",
       "3  POLYGON ((-87.53087 34.42492, -87.53082 34.429...  \n",
       "4  POLYGON ((-85.95712 31.67744, -85.95676 31.677...  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zipshp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "abef94aa-95d8-478e-b346-d2784ffebed6",
   "metadata": {},
   "outputs": [],
   "source": [
    "counties = gpd.read_file('/Users/asaldanha/Downloads/tl_2019_us_county/tl_2019_us_county.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "7e985fd6-2f73-453f-84e9-1f22aff42c4c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['STATEFP', 'COUNTYFP', 'COUNTYNS', 'GEOID', 'NAME', 'NAMELSAD', 'LSAD', 'CLASSFP', 'MTFCC', 'CSAFP', 'CBSAFP', 'METDIVFP', 'FUNCSTAT', 'ALAND', 'AWATER', 'INTPTLAT', 'INTPTLON', 'geometry']\n"
     ]
    }
   ],
   "source": [
    "print(counties.columns.tolist())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "b54f0512-6740-429f-aaae-25fd31b1464c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0       039\n",
      "1       069\n",
      "2       011\n",
      "3       109\n",
      "4       129\n",
      "       ... \n",
      "3228    123\n",
      "3229    135\n",
      "3230    089\n",
      "3231    227\n",
      "3232    099\n",
      "Name: COUNTYFP, Length: 3233, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(counties['COUNTYFP'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "388e7d1b-1bab-441e-b1ef-f02a1afe3b20",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas = counties[counties['COUNTYFP']=='113']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "8e620daf-6d83-4d1c-8580-991ea1d28ed2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     STATEFP COUNTYFP  COUNTYNS  GEOID        NAME           NAMELSAD LSAD  \\\n",
      "125       05      113  00069175  05113        Polk        Polk County   06   \n",
      "148       17      113  01784833  17113      McLean      McLean County   06   \n",
      "404       20      113  00485021  20113   McPherson   McPherson County   06   \n",
      "637       08      113  00198172  08113  San Miguel  San Miguel County   06   \n",
      "759       13      113  01687740  13113     Fayette     Fayette County   06   \n",
      "780       22      113  00559538  22113   Vermilion   Vermilion Parish   15   \n",
      "864       36      113  00974154  36113      Warren      Warren County   06   \n",
      "865       51      113  01494590  51113     Madison     Madison County   06   \n",
      "953       19      113  00465245  19113        Linn        Linn County   06   \n",
      "1165      42      113  01213687  42113    Sullivan    Sullivan County   06   \n",
      "1205      72      113  01804537  72113       Ponce    Ponce Municipio   13   \n",
      "1235      21      113  00516903  21113   Jessamine   Jessamine County   06   \n",
      "1345      55      113  01581116  55113      Sawyer      Sawyer County   06   \n",
      "1409      06      113  00277321  06113        Yolo        Yolo County   06   \n",
      "1582      31      113  00835878  31113       Logan       Logan County   06   \n",
      "1666      28      113  00711758  28113        Pike        Pike County   06   \n",
      "1736      27      113  00659502  27113  Pennington  Pennington County   06   \n",
      "1844      40      113  01101844  40113       Osage       Osage County   06   \n",
      "1866      37      113  01025833  37113       Macon       Macon County   06   \n",
      "2228      39      113  01074069  39113  Montgomery  Montgomery County   06   \n",
      "2344      29      113  00758511  29113     Lincoln     Lincoln County   06   \n",
      "2397      18      113  00450377  18113       Noble       Noble County   06   \n",
      "2471      01      113  00161583  01113     Russell     Russell County   06   \n",
      "2498      48      113  01383842  48113      Dallas      Dallas County   06   \n",
      "2626      26      113  01622999  26113   Missaukee   Missaukee County   06   \n",
      "2705      12      113  00306914  12113  Santa Rosa  Santa Rosa County   06   \n",
      "2988      47      113  01639769  47113     Madison     Madison County   06   \n",
      "\n",
      "     CLASSFP  MTFCC CSAFP CBSAFP METDIVFP FUNCSTAT       ALAND     AWATER  \\\n",
      "125       H1  G4020  None   None     None        A  2220863254   12372575   \n",
      "148       H1  G4020   145  14010     None        A  3064600918    7801224   \n",
      "404       H1  G4020  None  32700     None        A  2326547432    6003328   \n",
      "637       H1  G4020  None   None     None        A  3332606082    5204095   \n",
      "759       H1  G4020   122  12060     None        A   503436770   12808490   \n",
      "780       H1  G4020   318  29180     None        A  3038604870  955337105   \n",
      "864       H1  G4020   104  24020     None        A  2246082355  166754989   \n",
      "865       H1  G4020   548  47900    47894        A   830447699    3207612   \n",
      "953       H1  G4020   168  16300     None        A  1857223982   19659622   \n",
      "1165      H1  G4020  None   None     None        A  1165338429    6617028   \n",
      "1205      H1  G4020   434  38660     None        A   297688621  203748553   \n",
      "1235      H1  G4020   336  30460     None        A   445905563    6131853   \n",
      "1345      H1  G4020  None   None     None        A  3257235817  239864619   \n",
      "1409      H1  G4020   472  40900     None        A  2628144759   22878428   \n",
      "1582      H1  G4020  None  35820     None        A  1478003936    1203586   \n",
      "1666      H1  G4020  None  32620     None        A  1059350505    4341105   \n",
      "1736      H1  G4020  None   None     None        A  1596928772    4332047   \n",
      "1844      H1  G4020   538  46140     None        A  5818679077  148729736   \n",
      "1866      H1  G4020  None   None     None        A  1335344512   10604264   \n",
      "2228      H1  G4020   212  19430     None        A  1195326276    7511399   \n",
      "2344      H1  G4020   476  41180     None        A  1622809699   35981661   \n",
      "2397      H1  G4020   258  28340     None        A  1064081178   17064798   \n",
      "2471      H1  G4020   194  17980     None        A  1660622936   15596319   \n",
      "2498      H1  G4020   206  19100    19124        A  2259439988   93869577   \n",
      "2626      H1  G4020  None  15620     None        A  1462793646   23588781   \n",
      "2705      H1  G4020   426  37860     None        A  2622050628  418020790   \n",
      "2988      H1  G4020   297  27180     None        A  1443073936    3757608   \n",
      "\n",
      "         INTPTLAT      INTPTLON  \\\n",
      "125   +34.4909149  -094.2308841   \n",
      "148   +40.4945594  -088.8445391   \n",
      "404   +38.3958120  -097.6474893   \n",
      "637   +38.0093190  -108.4272635   \n",
      "759   +33.4127172  -084.4939407   \n",
      "780   +29.7897222  -092.2915678   \n",
      "864   +43.5551053  -073.8381388   \n",
      "865   +38.4120586  -078.2769614   \n",
      "953   +42.0779506  -091.5976735   \n",
      "1165  +41.4392848  -076.5117166   \n",
      "1205  +18.0017167  -066.6066625   \n",
      "1235  +37.8732908  -084.5839603   \n",
      "1345  +45.8649127  -091.1471302   \n",
      "1409  +38.6795955  -121.9024413   \n",
      "1582  +41.5421555  -100.4436647   \n",
      "1666  +31.1775159  -090.3977254   \n",
      "1736  +48.0692470  -096.0377254   \n",
      "1844  +36.6242995  -096.4081120   \n",
      "1866  +35.1529593  -083.4219010   \n",
      "2228  +39.7537357  -084.2905915   \n",
      "2344  +39.0622547  -090.9629165   \n",
      "2397  +41.4046794  -085.4172708   \n",
      "2471  +32.2898113  -085.1869798   \n",
      "2498  +32.7669866  -096.7784238   \n",
      "2626  +44.3254240  -085.0854708   \n",
      "2705  +30.7012689  -087.0128900   \n",
      "2988  +35.6060563  -088.8334238   \n",
      "\n",
      "                                               geometry  \n",
      "125   POLYGON ((-94.45614 34.67981, -94.45608 34.681...  \n",
      "148   POLYGON ((-89.2665 40.48555, -89.26653 40.4864...  \n",
      "404   POLYGON ((-97.92443 38.34789, -97.92445 38.351...  \n",
      "637   POLYGON ((-108.33659 37.89384, -108.33884 37.8...  \n",
      "759   POLYGON ((-84.55686 33.5284, -84.55136 33.5295...  \n",
      "780   POLYGON ((-92.31319 30.12534, -92.31308 30.125...  \n",
      "864   POLYGON ((-74.18256 43.52088, -74.18548 43.540...  \n",
      "865   POLYGON ((-78.43894 38.51679, -78.43893 38.516...  \n",
      "953   POLYGON ((-91.83526 42.03695, -91.83524 42.039...  \n",
      "1165  POLYGON ((-76.7724 41.47169, -76.77242 41.4717...  \n",
      "1205  POLYGON ((-66.63106 18.15039, -66.63101 18.150...  \n",
      "1235  POLYGON ((-84.69461 37.90504, -84.69322 37.909...  \n",
      "1345  POLYGON ((-91.54181 45.98259, -91.54531 45.982...  \n",
      "1409  POLYGON ((-122.16494 38.64246, -122.16398 38.6...  \n",
      "1582  POLYGON ((-100.40518 41.39345, -100.40562 41.3...  \n",
      "1666  POLYGON ((-90.54839 31.22338, -90.54839 31.223...  \n",
      "1736  POLYGON ((-96.50103 48.10869, -96.50102 48.110...  \n",
      "1844  POLYGON ((-96.90928 36.59631, -96.90938 36.596...  \n",
      "1866  POLYGON ((-83.58048 35.29146, -83.57848 35.291...  \n",
      "2228  POLYGON ((-84.48359 39.8304, -84.4836 39.83051...  \n",
      "2344  POLYGON ((-91.18546 39.13905, -91.18543 39.139...  \n",
      "2397  POLYGON ((-85.65351 41.43686, -85.6535 41.4370...  \n",
      "2471  POLYGON ((-85.36196 32.41042, -85.3574 32.4104...  \n",
      "2498  POLYGON ((-96.52999 32.54528, -96.5333 32.5453...  \n",
      "2626  POLYGON ((-85.3384 44.42538, -85.33832 44.4269...  \n",
      "2705  POLYGON ((-87.29836 30.82735, -87.2986 30.8274...  \n",
      "2988  POLYGON ((-89.01909 35.67279, -89.01905 35.672...  \n"
     ]
    }
   ],
   "source": [
    "print(dallas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "a6af5e30-0c0a-4e65-be25-ffa2ef4740eb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data type of each column of Dataframe :\n",
      "STATEFP       object\n",
      "COUNTYFP      object\n",
      "COUNTYNS      object\n",
      "GEOID         object\n",
      "NAME          object\n",
      "NAMELSAD      object\n",
      "LSAD          object\n",
      "CLASSFP       object\n",
      "MTFCC         object\n",
      "CSAFP         object\n",
      "CBSAFP        object\n",
      "METDIVFP      object\n",
      "FUNCSTAT      object\n",
      "ALAND          int64\n",
      "AWATER         int64\n",
      "INTPTLAT      object\n",
      "INTPTLON      object\n",
      "geometry    geometry\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "dataTypeSeries = counties.dtypes\n",
    "print('Data type of each column of Dataframe :')\n",
    "print(dataTypeSeries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "bf98256d-ff83-4e86-be16-e35b5cc0350f",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas.to_file('/Users/asaldanha/Work/python/data_created/dallas.geojson', driver='GeoJSON')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6092e7b1-7bbf-4a96-b4de-4ca79a673713",
   "metadata": {},
   "outputs": [],
   "source": [
    "# https://geopandas.org/en/stable/docs/reference/api/geopandas.sjoin.html\n",
    "# https://stackoverflow.com/questions/68504942/how-do-geopandas-sjoin-predicate-within-and-intersects-differ"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "52a22a0b-2e89-45a3-8654-45da162b6fae",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas_zipcodes = gpd.sjoin(zipcodes, dallas, how='inner', predicate='intersects')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "49fbc00a-f557-4f00-9571-c601da81e74f",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas_zipcodes.to_file('/Users/asaldanha/Work/python/data_created/dallas_zipcodes.geojson', driver='GeoJSON')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "b6514738-3277-4abb-a95b-b956f4198c1f",
   "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>ZCTA5CE20</th>\n",
       "      <th>GEOID20</th>\n",
       "      <th>CLASSFP20</th>\n",
       "      <th>MTFCC20</th>\n",
       "      <th>FUNCSTAT20</th>\n",
       "      <th>ALAND20</th>\n",
       "      <th>AWATER20</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>INTPTLON20</th>\n",
       "      <th>geometry</th>\n",
       "      <th>...</th>\n",
       "      <th>CLASSFP</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>CSAFP</th>\n",
       "      <th>CBSAFP</th>\n",
       "      <th>METDIVFP</th>\n",
       "      <th>FUNCSTAT</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>32514</td>\n",
       "      <td>32514</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>51328342</td>\n",
       "      <td>1128346</td>\n",
       "      <td>+30.5321804</td>\n",
       "      <td>-087.2225390</td>\n",
       "      <td>POLYGON ((-87.26444 30.53708, -87.26395 30.537...</td>\n",
       "      <td>...</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>426</td>\n",
       "      <td>37860</td>\n",
       "      <td>None</td>\n",
       "      <td>A</td>\n",
       "      <td>2622050628</td>\n",
       "      <td>418020790</td>\n",
       "      <td>+30.7012689</td>\n",
       "      <td>-087.0128900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>32564</td>\n",
       "      <td>32564</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>266662769</td>\n",
       "      <td>2894289</td>\n",
       "      <td>+30.7288078</td>\n",
       "      <td>-086.7819153</td>\n",
       "      <td>POLYGON ((-86.9071 30.69625, -86.90697 30.6962...</td>\n",
       "      <td>...</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>426</td>\n",
       "      <td>37860</td>\n",
       "      <td>None</td>\n",
       "      <td>A</td>\n",
       "      <td>2622050628</td>\n",
       "      <td>418020790</td>\n",
       "      <td>+30.7012689</td>\n",
       "      <td>-087.0128900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>32565</td>\n",
       "      <td>32565</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>596655238</td>\n",
       "      <td>6159122</td>\n",
       "      <td>+30.8943800</td>\n",
       "      <td>-087.1454537</td>\n",
       "      <td>POLYGON ((-87.31391 30.84871, -87.31358 30.849...</td>\n",
       "      <td>...</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>426</td>\n",
       "      <td>37860</td>\n",
       "      <td>None</td>\n",
       "      <td>A</td>\n",
       "      <td>2622050628</td>\n",
       "      <td>418020790</td>\n",
       "      <td>+30.7012689</td>\n",
       "      <td>-087.0128900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>32566</td>\n",
       "      <td>32566</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>101447890</td>\n",
       "      <td>33312858</td>\n",
       "      <td>+30.4253015</td>\n",
       "      <td>-086.8923457</td>\n",
       "      <td>POLYGON ((-86.95173 30.39356, -86.95172 30.394...</td>\n",
       "      <td>...</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>426</td>\n",
       "      <td>37860</td>\n",
       "      <td>None</td>\n",
       "      <td>A</td>\n",
       "      <td>2622050628</td>\n",
       "      <td>418020790</td>\n",
       "      <td>+30.7012689</td>\n",
       "      <td>-087.0128900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>32563</td>\n",
       "      <td>32563</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>43086275</td>\n",
       "      <td>25929046</td>\n",
       "      <td>+30.3908515</td>\n",
       "      <td>-087.0247850</td>\n",
       "      <td>POLYGON ((-87.13619 30.37919, -87.13581 30.379...</td>\n",
       "      <td>...</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>426</td>\n",
       "      <td>37860</td>\n",
       "      <td>None</td>\n",
       "      <td>A</td>\n",
       "      <td>2622050628</td>\n",
       "      <td>418020790</td>\n",
       "      <td>+30.7012689</td>\n",
       "      <td>-087.0128900</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    ZCTA5CE20 GEOID20 CLASSFP20 MTFCC20 FUNCSTAT20    ALAND20  AWATER20  \\\n",
       "107     32514   32514        B5   G6350          S   51328342   1128346   \n",
       "108     32564   32564        B5   G6350          S  266662769   2894289   \n",
       "175     32565   32565        B5   G6350          S  596655238   6159122   \n",
       "196     32566   32566        B5   G6350          S  101447890  33312858   \n",
       "235     32563   32563        B5   G6350          S   43086275  25929046   \n",
       "\n",
       "      INTPTLAT20    INTPTLON20  \\\n",
       "107  +30.5321804  -087.2225390   \n",
       "108  +30.7288078  -086.7819153   \n",
       "175  +30.8943800  -087.1454537   \n",
       "196  +30.4253015  -086.8923457   \n",
       "235  +30.3908515  -087.0247850   \n",
       "\n",
       "                                              geometry  ...  CLASSFP  MTFCC  \\\n",
       "107  POLYGON ((-87.26444 30.53708, -87.26395 30.537...  ...       H1  G4020   \n",
       "108  POLYGON ((-86.9071 30.69625, -86.90697 30.6962...  ...       H1  G4020   \n",
       "175  POLYGON ((-87.31391 30.84871, -87.31358 30.849...  ...       H1  G4020   \n",
       "196  POLYGON ((-86.95173 30.39356, -86.95172 30.394...  ...       H1  G4020   \n",
       "235  POLYGON ((-87.13619 30.37919, -87.13581 30.379...  ...       H1  G4020   \n",
       "\n",
       "    CSAFP CBSAFP METDIVFP FUNCSTAT       ALAND     AWATER     INTPTLAT  \\\n",
       "107   426  37860     None        A  2622050628  418020790  +30.7012689   \n",
       "108   426  37860     None        A  2622050628  418020790  +30.7012689   \n",
       "175   426  37860     None        A  2622050628  418020790  +30.7012689   \n",
       "196   426  37860     None        A  2622050628  418020790  +30.7012689   \n",
       "235   426  37860     None        A  2622050628  418020790  +30.7012689   \n",
       "\n",
       "         INTPTLON  \n",
       "107  -087.0128900  \n",
       "108  -087.0128900  \n",
       "175  -087.0128900  \n",
       "196  -087.0128900  \n",
       "235  -087.0128900  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dallas_zipcodes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "95ae213c-99d2-4882-8156-0bdcb798111b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "      ZCTA5CE20 GEOID20 CLASSFP20 MTFCC20 FUNCSTAT20    ALAND20  AWATER20  \\\n",
      "107       32514   32514        B5   G6350          S   51328342   1128346   \n",
      "108       32564   32564        B5   G6350          S  266662769   2894289   \n",
      "175       32565   32565        B5   G6350          S  596655238   6159122   \n",
      "196       32566   32566        B5   G6350          S  101447890  33312858   \n",
      "235       32563   32563        B5   G6350          S   43086275  25929046   \n",
      "...         ...     ...       ...     ...        ...        ...       ...   \n",
      "33224     67476   67476        B5   G6350          S    7845986      4790   \n",
      "33301     46796   46796        B5   G6350          S      71234         0   \n",
      "33722     22725   22725        B5   G6350          S    1876696      4634   \n",
      "33740     75261   75261        B5   G6350          S   36083571    178186   \n",
      "33779     12820   12820        B5   G6350          S     331799         0   \n",
      "\n",
      "        INTPTLAT20    INTPTLON20  \\\n",
      "107    +30.5321804  -087.2225390   \n",
      "108    +30.7288078  -086.7819153   \n",
      "175    +30.8943800  -087.1454537   \n",
      "196    +30.4253015  -086.8923457   \n",
      "235    +30.3908515  -087.0247850   \n",
      "...            ...           ...   \n",
      "33224  +38.5442777  -097.4362174   \n",
      "33301  +41.3366562  -085.4957952   \n",
      "33722  +38.4405102  -078.1560750   \n",
      "33740  +32.9031945  -097.0531253   \n",
      "33779  +43.4600737  -073.6407132   \n",
      "\n",
      "                                                geometry  ...  CLASSFP  MTFCC  \\\n",
      "107    POLYGON ((-87.26444 30.53708, -87.26395 30.537...  ...       H1  G4020   \n",
      "108    POLYGON ((-86.9071 30.69625, -86.90697 30.6962...  ...       H1  G4020   \n",
      "175    POLYGON ((-87.31391 30.84871, -87.31358 30.849...  ...       H1  G4020   \n",
      "196    POLYGON ((-86.95173 30.39356, -86.95172 30.394...  ...       H1  G4020   \n",
      "235    POLYGON ((-87.13619 30.37919, -87.13581 30.379...  ...       H1  G4020   \n",
      "...                                                  ...  ...      ...    ...   \n",
      "33224  POLYGON ((-97.44616 38.56557, -97.44508 38.565...  ...       H1  G4020   \n",
      "33301  POLYGON ((-85.49843 41.33678, -85.49759 41.337...  ...       H1  G4020   \n",
      "33722  POLYGON ((-78.16216 38.4342, -78.16213 38.4343...  ...       H1  G4020   \n",
      "33740  POLYGON ((-97.09233 32.913, -97.09129 32.91428...  ...       H1  G4020   \n",
      "33779  POLYGON ((-73.64529 43.46119, -73.64527 43.461...  ...       H1  G4020   \n",
      "\n",
      "      CSAFP CBSAFP METDIVFP FUNCSTAT       ALAND     AWATER     INTPTLAT  \\\n",
      "107     426  37860     None        A  2622050628  418020790  +30.7012689   \n",
      "108     426  37860     None        A  2622050628  418020790  +30.7012689   \n",
      "175     426  37860     None        A  2622050628  418020790  +30.7012689   \n",
      "196     426  37860     None        A  2622050628  418020790  +30.7012689   \n",
      "235     426  37860     None        A  2622050628  418020790  +30.7012689   \n",
      "...     ...    ...      ...      ...         ...        ...          ...   \n",
      "33224  None  32700     None        A  2326547432    6003328  +38.3958120   \n",
      "33301   258  28340     None        A  1064081178   17064798  +41.4046794   \n",
      "33722   548  47900    47894        A   830447699    3207612  +38.4120586   \n",
      "33740   206  19100    19124        A  2259439988   93869577  +32.7669866   \n",
      "33779   104  24020     None        A  2246082355  166754989  +43.5551053   \n",
      "\n",
      "           INTPTLON  \n",
      "107    -087.0128900  \n",
      "108    -087.0128900  \n",
      "175    -087.0128900  \n",
      "196    -087.0128900  \n",
      "235    -087.0128900  \n",
      "...             ...  \n",
      "33224  -097.6474893  \n",
      "33301  -085.4172708  \n",
      "33722  -078.2769614  \n",
      "33740  -096.7784238  \n",
      "33779  -073.8381388  \n",
      "\n",
      "[673 rows x 28 columns]\n"
     ]
    }
   ],
   "source": [
    "print(dallas_zipcodes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "b7982479-9867-41e0-8129-4620080669db",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "      STATEFP10 STATE STATE_ABV   ZCTA  GEOID10  MULTI_STATE     POP  PR_HRI  \\\n",
      "0            48    TX     Texas  73949  4873949            1    1688      68   \n",
      "1            48    TX     Texas  75001  4875001            0   12414      78   \n",
      "2            48    TX     Texas  75002  4875002            0   63140      54   \n",
      "3            48    TX     Texas  75006  4875006            0   46364      70   \n",
      "4            48    TX     Texas  75007  4875007            0   51624      65   \n",
      "...         ...   ...       ...    ...      ...          ...     ...     ...   \n",
      "1895         48    TX     Texas  79936  4879936            0  111086      45   \n",
      "1896         48    TX     Texas  79938  4879938            0   53520      42   \n",
      "1897         48    TX     Texas  88063  4888063            1   12799      78   \n",
      "1898         48    TX     Texas  88220  4888220            1   33725    -999   \n",
      "1899         48    TX     Texas  88430  4888430            1     162      20   \n",
      "\n",
      "       F_HRI  LOW_EMS  ...     P_RENT  PR_RENT   P_OZONE  PR_OZONE    P_PM25  \\\n",
      "0       0.75        0  ...  34.928230   0.7684  0.666667    0.6180  0.000000   \n",
      "1       1.00        0  ...  82.888424   0.9852  5.333333    0.9472  1.333333   \n",
      "2       0.75        0  ...  21.299188   0.4391  4.666667    0.9349  1.333333   \n",
      "3       0.75        0  ...  49.364908   0.9031  6.000000    0.9573  1.333333   \n",
      "4       0.75        0  ...  27.721552   0.6238  6.000000    0.9573  1.333333   \n",
      "...      ...      ...  ...        ...      ...       ...       ...       ...   \n",
      "1895    0.50        0  ...  33.589186   0.7477  3.333333    0.8955  0.000000   \n",
      "1896    0.50        0  ...  23.031046   0.4927  3.333333    0.8955  0.000000   \n",
      "1897    1.00        0  ...  31.106567   0.7008  8.000000    0.9740  0.000000   \n",
      "1898 -999.00        0  ...  28.082544   0.6326  8.666667    0.9773  0.000000   \n",
      "1899    0.50        1  ...  28.571429   0.6439  0.333333    0.4580  0.000000   \n",
      "\n",
      "      PR_PM25  NBE_SCORE  NBE_RANK  OVERALL_SCORE  OVERALL_RANK  \n",
      "0      0.0000     0.5074    0.6670         0.6712        0.8462  \n",
      "1      0.8668     0.7031    0.9440         0.5510        0.6627  \n",
      "2      0.8668     0.6228    0.8673         0.4398        0.4427  \n",
      "3      0.8668     0.7188    0.9538         0.5986        0.7432  \n",
      "4      0.8668     0.6759    0.9238         0.4737        0.5112  \n",
      "...       ...        ...       ...            ...           ...  \n",
      "1895   0.0000     0.6076    0.8483         0.5091        0.5818  \n",
      "1896   0.0000     0.5150    0.6831         0.5788        0.7115  \n",
      "1897   0.0000     0.7203    0.9544         0.8954        0.9956  \n",
      "1898   0.0000     0.5495    0.7545         0.6066        0.7563  \n",
      "1899   0.0000     0.3546    0.2694         0.4028        0.3672  \n",
      "\n",
      "[1900 rows x 75 columns]\n"
     ]
    }
   ],
   "source": [
    "print(hdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "835bb7a0-488d-4c4b-afd0-b8ada7cb06ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "pepefile = gpd.read_file('/Users/asaldanha/Downloads/Northtexas-zipcodes (2).geojson')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "7f48b528-07b7-4bd2-8b94-133b014e557b",
   "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>COUNTYNS</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>GEOIDFQ</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>LSAD</th>\n",
       "      <th>CLASSFP</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>...</th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>GEOID10</th>\n",
       "      <th>CLASSFP10</th>\n",
       "      <th>MTFCC10</th>\n",
       "      <th>FUNCSTAT10</th>\n",
       "      <th>ALAND10</th>\n",
       "      <th>AWATER10</th>\n",
       "      <th>INTPTLAT10</th>\n",
       "      <th>INTPTLON10</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>147</td>\n",
       "      <td>1383859</td>\n",
       "      <td>48147</td>\n",
       "      <td>0500000US48147</td>\n",
       "      <td>Fannin</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>...</td>\n",
       "      <td>75098</td>\n",
       "      <td>75098</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>85334402</td>\n",
       "      <td>20374008</td>\n",
       "      <td>33.012135</td>\n",
       "      <td>-96.534936</td>\n",
       "      <td>MULTIPOLYGON (((-96.60061 33.01124, -96.6 33.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>147</td>\n",
       "      <td>1383859</td>\n",
       "      <td>48147</td>\n",
       "      <td>0500000US48147</td>\n",
       "      <td>Fannin</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>...</td>\n",
       "      <td>75101</td>\n",
       "      <td>75101</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>2130983</td>\n",
       "      <td>0</td>\n",
       "      <td>32.270032</td>\n",
       "      <td>-96.702494</td>\n",
       "      <td>MULTIPOLYGON (((-96.71297 32.28014, -96.71169 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>147</td>\n",
       "      <td>1383859</td>\n",
       "      <td>48147</td>\n",
       "      <td>0500000US48147</td>\n",
       "      <td>Fannin</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>...</td>\n",
       "      <td>75103</td>\n",
       "      <td>75103</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>516576997</td>\n",
       "      <td>8411316</td>\n",
       "      <td>32.516879</td>\n",
       "      <td>-95.883624</td>\n",
       "      <td>MULTIPOLYGON (((-96.07576 32.55478, -96.07573 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>147</td>\n",
       "      <td>1383859</td>\n",
       "      <td>48147</td>\n",
       "      <td>0500000US48147</td>\n",
       "      <td>Fannin</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>...</td>\n",
       "      <td>75104</td>\n",
       "      <td>75104</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>101201011</td>\n",
       "      <td>653200</td>\n",
       "      <td>32.580181</td>\n",
       "      <td>-96.964675</td>\n",
       "      <td>MULTIPOLYGON (((-97.06427 32.54906, -97.06417 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>147</td>\n",
       "      <td>1383859</td>\n",
       "      <td>48147</td>\n",
       "      <td>0500000US48147</td>\n",
       "      <td>Fannin</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>...</td>\n",
       "      <td>75105</td>\n",
       "      <td>75105</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>133025915</td>\n",
       "      <td>1938590</td>\n",
       "      <td>32.263010</td>\n",
       "      <td>-96.387663</td>\n",
       "      <td>MULTIPOLYGON (((-96.38391 32.3284, -96.38537 3...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATEFP  COUNTYFP  COUNTYNS  GEOID         GEOIDFQ    NAME       NAMELSAD  \\\n",
       "0       48       147   1383859  48147  0500000US48147  Fannin  Fannin County   \n",
       "1       48       147   1383859  48147  0500000US48147  Fannin  Fannin County   \n",
       "2       48       147   1383859  48147  0500000US48147  Fannin  Fannin County   \n",
       "3       48       147   1383859  48147  0500000US48147  Fannin  Fannin County   \n",
       "4       48       147   1383859  48147  0500000US48147  Fannin  Fannin County   \n",
       "\n",
       "   LSAD CLASSFP  MTFCC  ...  ZCTA5CE10  GEOID10 CLASSFP10 MTFCC10  FUNCSTAT10  \\\n",
       "0     6      H1  G4020  ...      75098    75098        B5   G6350           S   \n",
       "1     6      H1  G4020  ...      75101    75101        B5   G6350           S   \n",
       "2     6      H1  G4020  ...      75103    75103        B5   G6350           S   \n",
       "3     6      H1  G4020  ...      75104    75104        B5   G6350           S   \n",
       "4     6      H1  G4020  ...      75105    75105        B5   G6350           S   \n",
       "\n",
       "     ALAND10  AWATER10  INTPTLAT10  INTPTLON10  \\\n",
       "0   85334402  20374008   33.012135  -96.534936   \n",
       "1    2130983         0   32.270032  -96.702494   \n",
       "2  516576997   8411316   32.516879  -95.883624   \n",
       "3  101201011    653200   32.580181  -96.964675   \n",
       "4  133025915   1938590   32.263010  -96.387663   \n",
       "\n",
       "                                            geometry  \n",
       "0  MULTIPOLYGON (((-96.60061 33.01124, -96.6 33.0...  \n",
       "1  MULTIPOLYGON (((-96.71297 32.28014, -96.71169 ...  \n",
       "2  MULTIPOLYGON (((-96.07576 32.55478, -96.07573 ...  \n",
       "3  MULTIPOLYGON (((-97.06427 32.54906, -97.06417 ...  \n",
       "4  MULTIPOLYGON (((-96.38391 32.3284, -96.38537 3...  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pepefile.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "03f61ac2-36fd-4c4f-9a8d-ff4de106569f",
   "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>STATEFP10</th>\n",
       "      <th>STATE</th>\n",
       "      <th>STATE_ABV</th>\n",
       "      <th>ZCTA</th>\n",
       "      <th>GEOID10</th>\n",
       "      <th>MULTI_STATE</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>...</th>\n",
       "      <th>P_RENT</th>\n",
       "      <th>PR_RENT</th>\n",
       "      <th>P_OZONE</th>\n",
       "      <th>PR_OZONE</th>\n",
       "      <th>P_PM25</th>\n",
       "      <th>PR_PM25</th>\n",
       "      <th>NBE_SCORE</th>\n",
       "      <th>NBE_RANK</th>\n",
       "      <th>OVERALL_SCORE</th>\n",
       "      <th>OVERALL_RANK</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>73949</td>\n",
       "      <td>4873949</td>\n",
       "      <td>1</td>\n",
       "      <td>1688</td>\n",
       "      <td>68</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>34.928230</td>\n",
       "      <td>0.7684</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.6180</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.5074</td>\n",
       "      <td>0.6670</td>\n",
       "      <td>0.6712</td>\n",
       "      <td>0.8462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>0</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>82.888424</td>\n",
       "      <td>0.9852</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>0.9472</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7031</td>\n",
       "      <td>0.9440</td>\n",
       "      <td>0.5510</td>\n",
       "      <td>0.6627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75002</td>\n",
       "      <td>4875002</td>\n",
       "      <td>0</td>\n",
       "      <td>63140</td>\n",
       "      <td>54</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.299188</td>\n",
       "      <td>0.4391</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>0.9349</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6228</td>\n",
       "      <td>0.8673</td>\n",
       "      <td>0.4398</td>\n",
       "      <td>0.4427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>0</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>49.364908</td>\n",
       "      <td>0.9031</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7188</td>\n",
       "      <td>0.9538</td>\n",
       "      <td>0.5986</td>\n",
       "      <td>0.7432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>0</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>27.721552</td>\n",
       "      <td>0.6238</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6759</td>\n",
       "      <td>0.9238</td>\n",
       "      <td>0.4737</td>\n",
       "      <td>0.5112</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 75 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATEFP10 STATE STATE_ABV   ZCTA  GEOID10  MULTI_STATE    POP  PR_HRI  \\\n",
       "0         48    TX     Texas  73949  4873949            1   1688      68   \n",
       "1         48    TX     Texas  75001  4875001            0  12414      78   \n",
       "2         48    TX     Texas  75002  4875002            0  63140      54   \n",
       "3         48    TX     Texas  75006  4875006            0  46364      70   \n",
       "4         48    TX     Texas  75007  4875007            0  51624      65   \n",
       "\n",
       "   F_HRI  LOW_EMS  ...     P_RENT  PR_RENT   P_OZONE  PR_OZONE    P_PM25  \\\n",
       "0   0.75        0  ...  34.928230   0.7684  0.666667    0.6180  0.000000   \n",
       "1   1.00        0  ...  82.888424   0.9852  5.333333    0.9472  1.333333   \n",
       "2   0.75        0  ...  21.299188   0.4391  4.666667    0.9349  1.333333   \n",
       "3   0.75        0  ...  49.364908   0.9031  6.000000    0.9573  1.333333   \n",
       "4   0.75        0  ...  27.721552   0.6238  6.000000    0.9573  1.333333   \n",
       "\n",
       "   PR_PM25  NBE_SCORE  NBE_RANK  OVERALL_SCORE  OVERALL_RANK  \n",
       "0   0.0000     0.5074    0.6670         0.6712        0.8462  \n",
       "1   0.8668     0.7031    0.9440         0.5510        0.6627  \n",
       "2   0.8668     0.6228    0.8673         0.4398        0.4427  \n",
       "3   0.8668     0.7188    0.9538         0.5986        0.7432  \n",
       "4   0.8668     0.6759    0.9238         0.4737        0.5112  \n",
       "\n",
       "[5 rows x 75 columns]"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "1cace43c-29dc-49c3-a1d8-84dc64323c44",
   "metadata": {},
   "outputs": [],
   "source": [
    "hdf.rename(columns={'ZCTA':'ZCTA5CE10'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "634c801d-e420-4d46-9d82-1b3273e9e935",
   "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>STATEFP10</th>\n",
       "      <th>STATE</th>\n",
       "      <th>STATE_ABV</th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>GEOID10</th>\n",
       "      <th>MULTI_STATE</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>...</th>\n",
       "      <th>P_RENT</th>\n",
       "      <th>PR_RENT</th>\n",
       "      <th>P_OZONE</th>\n",
       "      <th>PR_OZONE</th>\n",
       "      <th>P_PM25</th>\n",
       "      <th>PR_PM25</th>\n",
       "      <th>NBE_SCORE</th>\n",
       "      <th>NBE_RANK</th>\n",
       "      <th>OVERALL_SCORE</th>\n",
       "      <th>OVERALL_RANK</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>73949</td>\n",
       "      <td>4873949</td>\n",
       "      <td>1</td>\n",
       "      <td>1688</td>\n",
       "      <td>68</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>34.928230</td>\n",
       "      <td>0.7684</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.6180</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.5074</td>\n",
       "      <td>0.6670</td>\n",
       "      <td>0.6712</td>\n",
       "      <td>0.8462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>0</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>82.888424</td>\n",
       "      <td>0.9852</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>0.9472</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7031</td>\n",
       "      <td>0.9440</td>\n",
       "      <td>0.5510</td>\n",
       "      <td>0.6627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75002</td>\n",
       "      <td>4875002</td>\n",
       "      <td>0</td>\n",
       "      <td>63140</td>\n",
       "      <td>54</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.299188</td>\n",
       "      <td>0.4391</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>0.9349</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6228</td>\n",
       "      <td>0.8673</td>\n",
       "      <td>0.4398</td>\n",
       "      <td>0.4427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>0</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>49.364908</td>\n",
       "      <td>0.9031</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7188</td>\n",
       "      <td>0.9538</td>\n",
       "      <td>0.5986</td>\n",
       "      <td>0.7432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>0</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>27.721552</td>\n",
       "      <td>0.6238</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6759</td>\n",
       "      <td>0.9238</td>\n",
       "      <td>0.4737</td>\n",
       "      <td>0.5112</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 75 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATEFP10 STATE STATE_ABV ZCTA5CE10  GEOID10  MULTI_STATE    POP  PR_HRI  \\\n",
       "0         48    TX     Texas     73949  4873949            1   1688      68   \n",
       "1         48    TX     Texas     75001  4875001            0  12414      78   \n",
       "2         48    TX     Texas     75002  4875002            0  63140      54   \n",
       "3         48    TX     Texas     75006  4875006            0  46364      70   \n",
       "4         48    TX     Texas     75007  4875007            0  51624      65   \n",
       "\n",
       "   F_HRI  LOW_EMS  ...     P_RENT  PR_RENT   P_OZONE  PR_OZONE    P_PM25  \\\n",
       "0   0.75        0  ...  34.928230   0.7684  0.666667    0.6180  0.000000   \n",
       "1   1.00        0  ...  82.888424   0.9852  5.333333    0.9472  1.333333   \n",
       "2   0.75        0  ...  21.299188   0.4391  4.666667    0.9349  1.333333   \n",
       "3   0.75        0  ...  49.364908   0.9031  6.000000    0.9573  1.333333   \n",
       "4   0.75        0  ...  27.721552   0.6238  6.000000    0.9573  1.333333   \n",
       "\n",
       "   PR_PM25  NBE_SCORE  NBE_RANK  OVERALL_SCORE  OVERALL_RANK  \n",
       "0   0.0000     0.5074    0.6670         0.6712        0.8462  \n",
       "1   0.8668     0.7031    0.9440         0.5510        0.6627  \n",
       "2   0.8668     0.6228    0.8673         0.4398        0.4427  \n",
       "3   0.8668     0.7188    0.9538         0.5986        0.7432  \n",
       "4   0.8668     0.6759    0.9238         0.4737        0.5112  \n",
       "\n",
       "[5 rows x 75 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "id": "403a6a4c-21af-4f0f-b8dd-76bfee5033d0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data type of each column of Dataframe :\n",
      "STATEFP10          int64\n",
      "STATE             object\n",
      "STATE_ABV         object\n",
      "ZCTA5CE10         object\n",
      "GEOID10           object\n",
      "                  ...   \n",
      "PR_PM25          float64\n",
      "NBE_SCORE        float64\n",
      "NBE_RANK         float64\n",
      "OVERALL_SCORE    float64\n",
      "OVERALL_RANK     float64\n",
      "Length: 75, dtype: object\n"
     ]
    }
   ],
   "source": [
    "dataTypeSeries = hdf.dtypes\n",
    "print('Data type of each column of Dataframe :')\n",
    "print(dataTypeSeries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "id": "40cb8e31-7363-4d51-ba36-ef4075cec796",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data type of each column of Dataframe :\n",
      "STATEFP          int32\n",
      "COUNTYFP         int32\n",
      "COUNTYNS         int32\n",
      "GEOID            int32\n",
      "GEOIDFQ         object\n",
      "NAME            object\n",
      "NAMELSAD        object\n",
      "LSAD             int32\n",
      "CLASSFP         object\n",
      "MTFCC           object\n",
      "CSAFP            int32\n",
      "CBSAFP           int32\n",
      "METDIVFP        object\n",
      "FUNCSTAT        object\n",
      "ALAND            int64\n",
      "AWATER           int32\n",
      "INTPTLAT       float64\n",
      "INTPTLON       float64\n",
      "ZCTA5CE10        int32\n",
      "GEOID10          int32\n",
      "CLASSFP10       object\n",
      "MTFCC10         object\n",
      "FUNCSTAT10      object\n",
      "ALAND10          int32\n",
      "AWATER10         int32\n",
      "INTPTLAT10     float64\n",
      "INTPTLON10     float64\n",
      "geometry      geometry\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "dataTypeSeries = pepefile.dtypes\n",
    "print('Data type of each column of Dataframe :')\n",
    "print(dataTypeSeries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "7662a963-c1da-4204-8afb-ef8f8682b031",
   "metadata": {},
   "outputs": [],
   "source": [
    "pepefile['ZCTA5CE10'] = pepefile['ZCTA5CE10'].astype(str).apply(lambda x: x.replace('.0',''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "4f565d41-dc4f-49a2-ac41-fb66ad6858bb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data type of each column of Dataframe :\n",
      "STATEFP          int32\n",
      "COUNTYFP         int32\n",
      "COUNTYNS         int32\n",
      "GEOID            int32\n",
      "GEOIDFQ         object\n",
      "NAME            object\n",
      "NAMELSAD        object\n",
      "LSAD             int32\n",
      "CLASSFP         object\n",
      "MTFCC           object\n",
      "CSAFP            int32\n",
      "CBSAFP           int32\n",
      "METDIVFP        object\n",
      "FUNCSTAT        object\n",
      "ALAND            int64\n",
      "AWATER           int32\n",
      "INTPTLAT       float64\n",
      "INTPTLON       float64\n",
      "ZCTA5CE10       object\n",
      "GEOID10          int32\n",
      "CLASSFP10       object\n",
      "MTFCC10         object\n",
      "FUNCSTAT10      object\n",
      "ALAND10          int32\n",
      "AWATER10         int32\n",
      "INTPTLAT10     float64\n",
      "INTPTLON10     float64\n",
      "geometry      geometry\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "dataTypeSeries = pepefile.dtypes\n",
    "print('Data type of each column of Dataframe :')\n",
    "print(dataTypeSeries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d1d8223b-15e3-46b9-9e57-ad915cc0b972",
   "metadata": {},
   "outputs": [],
   "source": [
    "#merge data with geojson file to get north texas data and mapping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "937b9bdc-aec8-4fc4-8332-bfc424dcd653",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas_heatzips = gpd.GeoDataFrame(hdf.merge(pepefile, on=\"ZCTA5CE10\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "id": "cdb276c4-52c4-4c2d-9c45-f1829b4a879c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     STATEFP10 STATE STATE_ABV ZCTA5CE10 GEOID10_x  MULTI_STATE    POP  \\\n",
      "0           48    TX     Texas     75001   4875001            0  12414   \n",
      "1           48    TX     Texas     75002   4875002            0  63140   \n",
      "2           48    TX     Texas     75006   4875006            0  46364   \n",
      "3           48    TX     Texas     75007   4875007            0  51624   \n",
      "4           48    TX     Texas     75009   4875009            0   8785   \n",
      "..         ...   ...       ...       ...       ...          ...    ...   \n",
      "322         48    TX     Texas     76623   4876623            0    242   \n",
      "323         48    TX     Texas     76651   4876651            0   3300   \n",
      "324         48    TX     Texas     76652   4876652            0   1087   \n",
      "325         48    TX     Texas     76666   4876666            0    244   \n",
      "326         48    TX     Texas     76670   4876670            0   1377   \n",
      "\n",
      "     PR_HRI  F_HRI  LOW_EMS  ...   INTPTLON  GEOID10_y  CLASSFP10  MTFCC10  \\\n",
      "0        78   1.00        0  ... -96.104988      75001         B5    G6350   \n",
      "1        54   0.75        0  ... -96.104988      75002         B5    G6350   \n",
      "2        70   0.75        0  ... -96.104988      75006         B5    G6350   \n",
      "3        65   0.75        0  ... -96.104988      75007         B5    G6350   \n",
      "4        87   1.00        0  ... -96.104988      75009         B5    G6350   \n",
      "..      ...    ...      ...  ...        ...        ...        ...      ...   \n",
      "322      20   0.50        1  ... -96.104988      76623         B5    G6350   \n",
      "323      93   1.00        0  ... -96.104988      76651         B5    G6350   \n",
      "324      20   0.50        0  ... -96.104988      76652         B5    G6350   \n",
      "325      20   0.50        0  ... -96.104988      76666         B5    G6350   \n",
      "326      92   1.00        0  ... -96.104988      76670         B5    G6350   \n",
      "\n",
      "     FUNCSTAT10    ALAND10  AWATER10  INTPTLAT10  INTPTLON10  \\\n",
      "0             S    9929852      8702   32.960047  -96.838522   \n",
      "1             S   96282304   5325129   33.089854  -96.608600   \n",
      "2             S   43706559    657534   32.962141  -96.898585   \n",
      "3             S   30192473    555592   33.005262  -96.896742   \n",
      "4             S  247273155   4043433   33.338899  -96.752977   \n",
      "..          ...        ...       ...         ...         ...   \n",
      "322           S   13132338     69989   32.211123  -96.752827   \n",
      "323           S  267517312   2756123   32.177710  -96.851184   \n",
      "324           S  225632516   5935756   32.117538  -97.575601   \n",
      "325           S   42418420    472634   32.043976  -96.914580   \n",
      "326           S  181140295   1844113   32.136018  -96.988963   \n",
      "\n",
      "                                              geometry  \n",
      "0    MULTIPOLYGON (((-96.85888 32.95438, -96.85884 ...  \n",
      "1    MULTIPOLYGON (((-96.68456 33.07552, -96.68367 ...  \n",
      "2    MULTIPOLYGON (((-96.94437 32.96639, -96.94432 ...  \n",
      "3    MULTIPOLYGON (((-96.94845 32.994, -96.94833 32...  \n",
      "4    MULTIPOLYGON (((-96.89253 33.28368, -96.89247 ...  \n",
      "..                                                 ...  \n",
      "322  MULTIPOLYGON (((-96.79322 32.20842, -96.79298 ...  \n",
      "323  MULTIPOLYGON (((-96.71493 32.16333, -96.71821 ...  \n",
      "324  MULTIPOLYGON (((-97.49037 32.16858, -97.49151 ...  \n",
      "325  MULTIPOLYGON (((-96.94066 32.05209, -96.94185 ...  \n",
      "326  MULTIPOLYGON (((-96.87528 32.08429, -96.87917 ...  \n",
      "\n",
      "[327 rows x 102 columns]\n"
     ]
    }
   ],
   "source": [
    "print(dallas_heatzips)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "id": "d3ef06e2-9bca-4884-8a88-e4afb07a4db3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     STATEFP  COUNTYFP  COUNTYNS  GEOID         GEOIDFQ    NAME  \\\n",
      "0         48       147   1383859  48147  0500000US48147  Fannin   \n",
      "1         48       147   1383859  48147  0500000US48147  Fannin   \n",
      "2         48       147   1383859  48147  0500000US48147  Fannin   \n",
      "3         48       147   1383859  48147  0500000US48147  Fannin   \n",
      "4         48       147   1383859  48147  0500000US48147  Fannin   \n",
      "..       ...       ...       ...    ...             ...     ...   \n",
      "337       48       147   1383859  48147  0500000US48147  Fannin   \n",
      "338       48       147   1383859  48147  0500000US48147  Fannin   \n",
      "339       48       147   1383859  48147  0500000US48147  Fannin   \n",
      "340       48       147   1383859  48147  0500000US48147  Fannin   \n",
      "341       48       147   1383859  48147  0500000US48147  Fannin   \n",
      "\n",
      "          NAMELSAD  LSAD CLASSFP  MTFCC  ...  ZCTA5CE10  GEOID10 CLASSFP10  \\\n",
      "0    Fannin County     6      H1  G4020  ...      75098    75098        B5   \n",
      "1    Fannin County     6      H1  G4020  ...      75101    75101        B5   \n",
      "2    Fannin County     6      H1  G4020  ...      75103    75103        B5   \n",
      "3    Fannin County     6      H1  G4020  ...      75104    75104        B5   \n",
      "4    Fannin County     6      H1  G4020  ...      75105    75105        B5   \n",
      "..             ...   ...     ...    ...  ...        ...      ...       ...   \n",
      "337  Fannin County     6      H1  G4020  ...      75472    75472        B5   \n",
      "338  Fannin County     6      H1  G4020  ...      75474    75474        B5   \n",
      "339  Fannin County     6      H1  G4020  ...      75475    75475        B5   \n",
      "340  Fannin County     6      H1  G4020  ...      75476    75476        B5   \n",
      "341  Fannin County     6      H1  G4020  ...      75479    75479        B5   \n",
      "\n",
      "    MTFCC10  FUNCSTAT10    ALAND10  AWATER10  INTPTLAT10 INTPTLON10  \\\n",
      "0     G6350           S   85334402  20374008   33.012135 -96.534936   \n",
      "1     G6350           S    2130983         0   32.270032 -96.702494   \n",
      "2     G6350           S  516576997   8411316   32.516879 -95.883624   \n",
      "3     G6350           S  101201011    653200   32.580181 -96.964675   \n",
      "4     G6350           S  133025915   1938590   32.263010 -96.387663   \n",
      "..      ...         ...        ...       ...         ...        ...   \n",
      "337   G6350           S  164863647  46949323   32.884423 -95.869602   \n",
      "338   G6350           S  277948698  61928573   32.924205 -96.109797   \n",
      "339   G6350           S    5333332         0   33.474893 -96.238246   \n",
      "340   G6350           S  133974445    620500   33.708311 -96.240653   \n",
      "341   G6350           S  131536227   3823918   33.618238 -96.333077   \n",
      "\n",
      "                                              geometry  \n",
      "0    MULTIPOLYGON (((-96.60061 33.01124, -96.6 33.0...  \n",
      "1    MULTIPOLYGON (((-96.71297 32.28014, -96.71169 ...  \n",
      "2    MULTIPOLYGON (((-96.07576 32.55478, -96.07573 ...  \n",
      "3    MULTIPOLYGON (((-97.06427 32.54906, -97.06417 ...  \n",
      "4    MULTIPOLYGON (((-96.38391 32.3284, -96.38537 3...  \n",
      "..                                                 ...  \n",
      "337  MULTIPOLYGON (((-95.89665 32.9796, -95.89665 3...  \n",
      "338  MULTIPOLYGON (((-95.97154 32.90485, -95.97195 ...  \n",
      "339  MULTIPOLYGON (((-96.25864 33.48578, -96.2586 3...  \n",
      "340  MULTIPOLYGON (((-96.30832 33.71576, -96.30834 ...  \n",
      "341  MULTIPOLYGON (((-96.37915 33.72526, -96.37885 ...  \n",
      "\n",
      "[342 rows x 28 columns]\n"
     ]
    }
   ],
   "source": [
    "print(pepefile)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "id": "869592b3-192f-462b-b439-f25101d34fb9",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas_heatzips.to_file('/Users/asaldanha/Work/python/data_created/dallas_heatzips.geojson', driver='GeoJSON')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f3228f2b-3002-4006-a4ae-7f7c71675d14",
   "metadata": {},
   "outputs": [],
   "source": [
    "#narrow down to dallas region with help from NCTOG open map files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "f67adbb6-9220-4f62-861d-5b3cc1629825",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas_city = gpd.read_file('/Users/asaldanha/Downloads/Cities_Region_(2024).geojson')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "367191bc-8960-4cba-be3f-d24920ec00a5",
   "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</th>\n",
       "      <th>CITY</th>\n",
       "      <th>TYPE</th>\n",
       "      <th>FIPSCODE</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NOTES</th>\n",
       "      <th>UPDATE_YEAR</th>\n",
       "      <th>SOURCE</th>\n",
       "      <th>AREA_SQ_MI</th>\n",
       "      <th>FIPSCODE_OLD</th>\n",
       "      <th>ShapeSTLength</th>\n",
       "      <th>ShapeSTArea</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Aledo</td>\n",
       "      <td>City</td>\n",
       "      <td>01744</td>\n",
       "      <td>4801744</td>\n",
       "      <td>PDF</td>\n",
       "      <td>2021</td>\n",
       "      <td>City</td>\n",
       "      <td>2.656081</td>\n",
       "      <td>01744</td>\n",
       "      <td>63456.619093</td>\n",
       "      <td>7.404729e+07</td>\n",
       "      <td>POLYGON ((-97.62335 32.71358, -97.62352 32.713...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Alvord</td>\n",
       "      <td>Town</td>\n",
       "      <td>02284</td>\n",
       "      <td>4802284</td>\n",
       "      <td>Geodatabase</td>\n",
       "      <td>2024</td>\n",
       "      <td>NCT9-1-1 Wise</td>\n",
       "      <td>1.536303</td>\n",
       "      <td>02284</td>\n",
       "      <td>51643.470741</td>\n",
       "      <td>4.282966e+07</td>\n",
       "      <td>POLYGON ((-97.70397 33.35405, -97.70379 33.353...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Angus</td>\n",
       "      <td>City</td>\n",
       "      <td>03288</td>\n",
       "      <td>4803288</td>\n",
       "      <td>Geodatabase</td>\n",
       "      <td>2024</td>\n",
       "      <td>NCT9-1-1 Navarro</td>\n",
       "      <td>3.132794</td>\n",
       "      <td>03288</td>\n",
       "      <td>131282.566357</td>\n",
       "      <td>8.733728e+07</td>\n",
       "      <td>POLYGON ((-96.44083 32.00706, -96.44234 32.008...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Annetta North</td>\n",
       "      <td>Town</td>\n",
       "      <td>03340</td>\n",
       "      <td>4803340</td>\n",
       "      <td>PDF</td>\n",
       "      <td>2019</td>\n",
       "      <td>City</td>\n",
       "      <td>4.623113</td>\n",
       "      <td>03340</td>\n",
       "      <td>112418.007043</td>\n",
       "      <td>1.288850e+08</td>\n",
       "      <td>POLYGON ((-97.63397 32.70914, -97.63409 32.709...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Annetta South</td>\n",
       "      <td>Town</td>\n",
       "      <td>03342</td>\n",
       "      <td>4803342</td>\n",
       "      <td>JPG</td>\n",
       "      <td>2018</td>\n",
       "      <td>City</td>\n",
       "      <td>1.775799</td>\n",
       "      <td>03342</td>\n",
       "      <td>84788.349771</td>\n",
       "      <td>4.950644e+07</td>\n",
       "      <td>POLYGON ((-97.66081 32.67417, -97.6614 32.6742...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   OBJECTID           CITY  TYPE FIPSCODE    GEOID        NOTES UPDATE_YEAR  \\\n",
       "0         1          Aledo  City    01744  4801744          PDF        2021   \n",
       "1         2         Alvord  Town    02284  4802284  Geodatabase        2024   \n",
       "2         3          Angus  City    03288  4803288  Geodatabase        2024   \n",
       "3         4  Annetta North  Town    03340  4803340          PDF        2019   \n",
       "4         5  Annetta South  Town    03342  4803342          JPG        2018   \n",
       "\n",
       "             SOURCE  AREA_SQ_MI FIPSCODE_OLD  ShapeSTLength   ShapeSTArea  \\\n",
       "0              City    2.656081        01744   63456.619093  7.404729e+07   \n",
       "1     NCT9-1-1 Wise    1.536303        02284   51643.470741  4.282966e+07   \n",
       "2  NCT9-1-1 Navarro    3.132794        03288  131282.566357  8.733728e+07   \n",
       "3              City    4.623113        03340  112418.007043  1.288850e+08   \n",
       "4              City    1.775799        03342   84788.349771  4.950644e+07   \n",
       "\n",
       "                                            geometry  \n",
       "0  POLYGON ((-97.62335 32.71358, -97.62352 32.713...  \n",
       "1  POLYGON ((-97.70397 33.35405, -97.70379 33.353...  \n",
       "2  POLYGON ((-96.44083 32.00706, -96.44234 32.008...  \n",
       "3  POLYGON ((-97.63397 32.70914, -97.63409 32.709...  \n",
       "4  POLYGON ((-97.66081 32.67417, -97.6614 32.6742...  "
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dallas_city.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "id": "1051ba9e-0fb8-4be5-b594-39b51e399636",
   "metadata": {},
   "outputs": [],
   "source": [
    "layer_dallas =  dallas_city[(dallas_city.CITY == \"Dallas\")]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "id": "11b4f9ec-81cb-4b14-a164-79d6d8a209d7",
   "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</th>\n",
       "      <th>CITY</th>\n",
       "      <th>TYPE</th>\n",
       "      <th>FIPSCODE</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NOTES</th>\n",
       "      <th>UPDATE_YEAR</th>\n",
       "      <th>SOURCE</th>\n",
       "      <th>AREA_SQ_MI</th>\n",
       "      <th>FIPSCODE_OLD</th>\n",
       "      <th>ShapeSTLength</th>\n",
       "      <th>ShapeSTArea</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>166</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>Shapefile</td>\n",
       "      <td>2024</td>\n",
       "      <td>City</td>\n",
       "      <td>383.93871</td>\n",
       "      <td>19000</td>\n",
       "      <td>1.718854e+06</td>\n",
       "      <td>1.070360e+10</td>\n",
       "      <td>POLYGON ((-96.47076 33.02013, -96.47168 33.020...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     OBJECTID    CITY  TYPE FIPSCODE    GEOID      NOTES UPDATE_YEAR SOURCE  \\\n",
       "165       166  Dallas  City    19000  4819000  Shapefile        2024   City   \n",
       "\n",
       "     AREA_SQ_MI FIPSCODE_OLD  ShapeSTLength   ShapeSTArea  \\\n",
       "165   383.93871        19000   1.718854e+06  1.070360e+10   \n",
       "\n",
       "                                              geometry  \n",
       "165  POLYGON ((-96.47076 33.02013, -96.47168 33.020...  "
      ]
     },
     "execution_count": 163,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "layer_dallas.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "id": "cfc61a3a-51c2-4479-aa0c-e6fd86c685a3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Empty GeoDataFrame\n",
      "Columns: [OBJECTID, CITY, TYPE, FIPSCODE, GEOID, NOTES, UPDATE_YEAR, SOURCE, AREA_SQ_MI, FIPSCODE_OLD, ShapeSTLength, ShapeSTArea, geometry]\n",
      "Index: []\n"
     ]
    }
   ],
   "source": [
    "print(layer_dallas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "285a094c-af4f-4402-b440-8e2256bf9468",
   "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>STATEFP10</th>\n",
       "      <th>STATE</th>\n",
       "      <th>STATE_ABV</th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>GEOID10_x</th>\n",
       "      <th>MULTI_STATE</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>...</th>\n",
       "      <th>INTPTLON</th>\n",
       "      <th>GEOID10_y</th>\n",
       "      <th>CLASSFP10</th>\n",
       "      <th>MTFCC10</th>\n",
       "      <th>FUNCSTAT10</th>\n",
       "      <th>ALAND10</th>\n",
       "      <th>AWATER10</th>\n",
       "      <th>INTPTLAT10</th>\n",
       "      <th>INTPTLON10</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>0</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-96.104988</td>\n",
       "      <td>75001</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>9929852</td>\n",
       "      <td>8702</td>\n",
       "      <td>32.960047</td>\n",
       "      <td>-96.838522</td>\n",
       "      <td>MULTIPOLYGON (((-96.85888 32.95438, -96.85884 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75002</td>\n",
       "      <td>4875002</td>\n",
       "      <td>0</td>\n",
       "      <td>63140</td>\n",
       "      <td>54</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-96.104988</td>\n",
       "      <td>75002</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>96282304</td>\n",
       "      <td>5325129</td>\n",
       "      <td>33.089854</td>\n",
       "      <td>-96.608600</td>\n",
       "      <td>MULTIPOLYGON (((-96.68456 33.07552, -96.68367 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>0</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-96.104988</td>\n",
       "      <td>75006</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>43706559</td>\n",
       "      <td>657534</td>\n",
       "      <td>32.962141</td>\n",
       "      <td>-96.898585</td>\n",
       "      <td>MULTIPOLYGON (((-96.94437 32.96639, -96.94432 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>0</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-96.104988</td>\n",
       "      <td>75007</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>30192473</td>\n",
       "      <td>555592</td>\n",
       "      <td>33.005262</td>\n",
       "      <td>-96.896742</td>\n",
       "      <td>MULTIPOLYGON (((-96.94845 32.994, -96.94833 32...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75009</td>\n",
       "      <td>4875009</td>\n",
       "      <td>0</td>\n",
       "      <td>8785</td>\n",
       "      <td>87</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-96.104988</td>\n",
       "      <td>75009</td>\n",
       "      <td>B5</td>\n",
       "      <td>G6350</td>\n",
       "      <td>S</td>\n",
       "      <td>247273155</td>\n",
       "      <td>4043433</td>\n",
       "      <td>33.338899</td>\n",
       "      <td>-96.752977</td>\n",
       "      <td>MULTIPOLYGON (((-96.89253 33.28368, -96.89247 ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 102 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATEFP10 STATE STATE_ABV ZCTA5CE10 GEOID10_x  MULTI_STATE    POP  PR_HRI  \\\n",
       "0         48    TX     Texas     75001   4875001            0  12414      78   \n",
       "1         48    TX     Texas     75002   4875002            0  63140      54   \n",
       "2         48    TX     Texas     75006   4875006            0  46364      70   \n",
       "3         48    TX     Texas     75007   4875007            0  51624      65   \n",
       "4         48    TX     Texas     75009   4875009            0   8785      87   \n",
       "\n",
       "   F_HRI  LOW_EMS  ...   INTPTLON  GEOID10_y  CLASSFP10  MTFCC10  FUNCSTAT10  \\\n",
       "0   1.00        0  ... -96.104988      75001         B5    G6350           S   \n",
       "1   0.75        0  ... -96.104988      75002         B5    G6350           S   \n",
       "2   0.75        0  ... -96.104988      75006         B5    G6350           S   \n",
       "3   0.75        0  ... -96.104988      75007         B5    G6350           S   \n",
       "4   1.00        0  ... -96.104988      75009         B5    G6350           S   \n",
       "\n",
       "     ALAND10  AWATER10  INTPTLAT10  INTPTLON10  \\\n",
       "0    9929852      8702   32.960047  -96.838522   \n",
       "1   96282304   5325129   33.089854  -96.608600   \n",
       "2   43706559    657534   32.962141  -96.898585   \n",
       "3   30192473    555592   33.005262  -96.896742   \n",
       "4  247273155   4043433   33.338899  -96.752977   \n",
       "\n",
       "                                            geometry  \n",
       "0  MULTIPOLYGON (((-96.85888 32.95438, -96.85884 ...  \n",
       "1  MULTIPOLYGON (((-96.68456 33.07552, -96.68367 ...  \n",
       "2  MULTIPOLYGON (((-96.94437 32.96639, -96.94432 ...  \n",
       "3  MULTIPOLYGON (((-96.94845 32.994, -96.94833 32...  \n",
       "4  MULTIPOLYGON (((-96.89253 33.28368, -96.89247 ...  \n",
       "\n",
       "[5 rows x 102 columns]"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dallas_heatzips.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "id": "f77c97f7-a96b-46d5-b5a5-31d10a0095df",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas_city_hdf = gpd.sjoin(dallas_heatzips, layer_dallas, how='inner', predicate='intersects')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "id": "f0fa91a1-8725-45fe-bdac-62f24a163f2e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     STATEFP10 STATE STATE_ABV ZCTA5CE10 GEOID10_x  MULTI_STATE    POP  \\\n",
      "0           48    TX     Texas     75001   4875001            0  12414   \n",
      "2           48    TX     Texas     75006   4875006            0  46364   \n",
      "3           48    TX     Texas     75007   4875007            0  51624   \n",
      "7           48    TX     Texas     75019   4875019            0  38666   \n",
      "15          48    TX     Texas     75032   4875032            0  27986   \n",
      "..         ...   ...       ...       ...       ...          ...    ...   \n",
      "144         48    TX     Texas     75251   4875251            0   2331   \n",
      "145         48    TX     Texas     75252   4875252            0  24112   \n",
      "146         48    TX     Texas     75253   4875253            0  18450   \n",
      "147         48    TX     Texas     75254   4875254            0  23253   \n",
      "148         48    TX     Texas     75287   4875287            0  49004   \n",
      "\n",
      "     PR_HRI  F_HRI  LOW_EMS  ...  TYPE  FIPSCODE  GEOID_right      NOTES  \\\n",
      "0        78   1.00        0  ...  City     19000      4819000  Shapefile   \n",
      "2        70   0.75        0  ...  City     19000      4819000  Shapefile   \n",
      "3        65   0.75        0  ...  City     19000      4819000  Shapefile   \n",
      "7        79   1.00        0  ...  City     19000      4819000  Shapefile   \n",
      "15       75   1.00        0  ...  City     19000      4819000  Shapefile   \n",
      "..      ...    ...      ...  ...   ...       ...          ...        ...   \n",
      "144      92   1.00        0  ...  City     19000      4819000  Shapefile   \n",
      "145      48   0.50        0  ...  City     19000      4819000  Shapefile   \n",
      "146      56   0.75        0  ...  City     19000      4819000  Shapefile   \n",
      "147      56   0.75        0  ...  City     19000      4819000  Shapefile   \n",
      "148      55   0.75        0  ...  City     19000      4819000  Shapefile   \n",
      "\n",
      "     UPDATE_YEAR  SOURCE  AREA_SQ_MI  FIPSCODE_OLD  ShapeSTLength  \\\n",
      "0           2024    City   383.93871         19000   1.718854e+06   \n",
      "2           2024    City   383.93871         19000   1.718854e+06   \n",
      "3           2024    City   383.93871         19000   1.718854e+06   \n",
      "7           2024    City   383.93871         19000   1.718854e+06   \n",
      "15          2024    City   383.93871         19000   1.718854e+06   \n",
      "..           ...     ...         ...           ...            ...   \n",
      "144         2024    City   383.93871         19000   1.718854e+06   \n",
      "145         2024    City   383.93871         19000   1.718854e+06   \n",
      "146         2024    City   383.93871         19000   1.718854e+06   \n",
      "147         2024    City   383.93871         19000   1.718854e+06   \n",
      "148         2024    City   383.93871         19000   1.718854e+06   \n",
      "\n",
      "      ShapeSTArea  \n",
      "0    1.070360e+10  \n",
      "2    1.070360e+10  \n",
      "3    1.070360e+10  \n",
      "7    1.070360e+10  \n",
      "15   1.070360e+10  \n",
      "..            ...  \n",
      "144  1.070360e+10  \n",
      "145  1.070360e+10  \n",
      "146  1.070360e+10  \n",
      "147  1.070360e+10  \n",
      "148  1.070360e+10  \n",
      "\n",
      "[87 rows x 115 columns]\n"
     ]
    }
   ],
   "source": [
    "print(dallas_city_hdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "id": "e4d7555c-47c6-4dce-90f9-7d39dcef81b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "dallas_city_hdf.to_file('/Users/asaldanha/Work/python/data_created/dallas_cityheat.geojson', driver='GeoJSON')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 171,
   "id": "191c056c-7555-47fd-8023-50ed12fe3909",
   "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>STATEFP10</th>\n",
       "      <th>STATE</th>\n",
       "      <th>STATE_ABV</th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>GEOID10_x</th>\n",
       "      <th>MULTI_STATE</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>...</th>\n",
       "      <th>TYPE</th>\n",
       "      <th>FIPSCODE</th>\n",
       "      <th>GEOID_right</th>\n",
       "      <th>NOTES</th>\n",
       "      <th>UPDATE_YEAR</th>\n",
       "      <th>SOURCE</th>\n",
       "      <th>AREA_SQ_MI</th>\n",
       "      <th>FIPSCODE_OLD</th>\n",
       "      <th>ShapeSTLength</th>\n",
       "      <th>ShapeSTArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>0</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>Shapefile</td>\n",
       "      <td>2024</td>\n",
       "      <td>City</td>\n",
       "      <td>383.93871</td>\n",
       "      <td>19000</td>\n",
       "      <td>1.718854e+06</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>0</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>Shapefile</td>\n",
       "      <td>2024</td>\n",
       "      <td>City</td>\n",
       "      <td>383.93871</td>\n",
       "      <td>19000</td>\n",
       "      <td>1.718854e+06</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>0</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>Shapefile</td>\n",
       "      <td>2024</td>\n",
       "      <td>City</td>\n",
       "      <td>383.93871</td>\n",
       "      <td>19000</td>\n",
       "      <td>1.718854e+06</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75019</td>\n",
       "      <td>4875019</td>\n",
       "      <td>0</td>\n",
       "      <td>38666</td>\n",
       "      <td>79</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>Shapefile</td>\n",
       "      <td>2024</td>\n",
       "      <td>City</td>\n",
       "      <td>383.93871</td>\n",
       "      <td>19000</td>\n",
       "      <td>1.718854e+06</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>75032</td>\n",
       "      <td>4875032</td>\n",
       "      <td>0</td>\n",
       "      <td>27986</td>\n",
       "      <td>75</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>Shapefile</td>\n",
       "      <td>2024</td>\n",
       "      <td>City</td>\n",
       "      <td>383.93871</td>\n",
       "      <td>19000</td>\n",
       "      <td>1.718854e+06</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 115 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    STATEFP10 STATE STATE_ABV ZCTA5CE10 GEOID10_x  MULTI_STATE    POP  PR_HRI  \\\n",
       "0          48    TX     Texas     75001   4875001            0  12414      78   \n",
       "2          48    TX     Texas     75006   4875006            0  46364      70   \n",
       "3          48    TX     Texas     75007   4875007            0  51624      65   \n",
       "7          48    TX     Texas     75019   4875019            0  38666      79   \n",
       "15         48    TX     Texas     75032   4875032            0  27986      75   \n",
       "\n",
       "    F_HRI  LOW_EMS  ...  TYPE  FIPSCODE  GEOID_right      NOTES  UPDATE_YEAR  \\\n",
       "0    1.00        0  ...  City     19000      4819000  Shapefile         2024   \n",
       "2    0.75        0  ...  City     19000      4819000  Shapefile         2024   \n",
       "3    0.75        0  ...  City     19000      4819000  Shapefile         2024   \n",
       "7    1.00        0  ...  City     19000      4819000  Shapefile         2024   \n",
       "15   1.00        0  ...  City     19000      4819000  Shapefile         2024   \n",
       "\n",
       "    SOURCE  AREA_SQ_MI  FIPSCODE_OLD  ShapeSTLength   ShapeSTArea  \n",
       "0     City   383.93871         19000   1.718854e+06  1.070360e+10  \n",
       "2     City   383.93871         19000   1.718854e+06  1.070360e+10  \n",
       "3     City   383.93871         19000   1.718854e+06  1.070360e+10  \n",
       "7     City   383.93871         19000   1.718854e+06  1.070360e+10  \n",
       "15    City   383.93871         19000   1.718854e+06  1.070360e+10  \n",
       "\n",
       "[5 rows x 115 columns]"
      ]
     },
     "execution_count": 171,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dallas_city_hdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "id": "0fec309e-23f6-4d78-8219-b186531a4d1f",
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf = dallas_city_hdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "id": "849b781a-e33b-47c3-a696-03c22ed0aceb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    STATE_ABV ZCTA5CE10 GEOID10_x    POP  PR_HRI  F_HRI  LOW_EMS      P_NEHD  \\\n",
      "0       Texas     75001   4875001  12414      78   1.00        0   14.200000   \n",
      "2       Texas     75006   4875006  46364      70   0.75        0   14.266667   \n",
      "3       Texas     75007   4875007  51624      65   0.75        0   14.255556   \n",
      "7       Texas     75019   4875019  38666      79   1.00        0   14.400000   \n",
      "15      Texas     75032   4875032  27986      75   1.00        0   15.800000   \n",
      "..        ...       ...       ...    ...     ...    ...      ...         ...   \n",
      "144     Texas     75251   4875251   2331      92   1.00        0 -999.000000   \n",
      "145     Texas     75252   4875252  24112      48   0.50        0   14.220000   \n",
      "146     Texas     75253   4875253  18450      56   0.75        0   14.933333   \n",
      "147     Texas     75254   4875254  23253      56   0.75        0   14.200000   \n",
      "148     Texas     75287   4875287  49004      55   0.75        0   14.200000   \n",
      "\n",
      "      PR_NEHD  HHB_SCORE  ...  INTPTLAT10  INTPTLON10  \\\n",
      "0      0.5885     0.7942  ...   32.960047  -96.838522   \n",
      "2      0.5989     0.6744  ...   32.962141  -96.898585   \n",
      "3      0.5987     0.6744  ...   33.005262  -96.896742   \n",
      "7      0.6046     0.8023  ...   32.963417  -96.984664   \n",
      "15     0.7305     0.8653  ...   32.857112  -96.431210   \n",
      "..        ...        ...  ...         ...         ...   \n",
      "144 -999.0000     1.0000  ...   32.919789  -96.770948   \n",
      "145    0.5976     0.5488  ...   32.997373  -96.788213   \n",
      "146    0.6532     0.7016  ...   32.674426  -96.609228   \n",
      "147    0.5885     0.6692  ...   32.944116  -96.800090   \n",
      "148    0.5885     0.6692  ...   32.999309  -96.841688   \n",
      "\n",
      "                                              geometry  index_right  OBJECTID  \\\n",
      "0    MULTIPOLYGON (((-96.85888 32.95438, -96.85884 ...          165       166   \n",
      "2    MULTIPOLYGON (((-96.94437 32.96639, -96.94432 ...          165       166   \n",
      "3    MULTIPOLYGON (((-96.94845 32.994, -96.94833 32...          165       166   \n",
      "7    MULTIPOLYGON (((-97.03258 32.95893, -97.03251 ...          165       166   \n",
      "15   MULTIPOLYGON (((-96.51896 32.81372, -96.51887 ...          165       166   \n",
      "..                                                 ...          ...       ...   \n",
      "144  MULTIPOLYGON (((-96.7805 32.92406, -96.7804 32...          165       166   \n",
      "145  MULTIPOLYGON (((-96.81712 33.00952, -96.81689 ...          165       166   \n",
      "146  MULTIPOLYGON (((-96.66971 32.66103, -96.66957 ...          165       166   \n",
      "147  MULTIPOLYGON (((-96.83017 32.95316, -96.83013 ...          165       166   \n",
      "148  MULTIPOLYGON (((-96.87437 32.99128, -96.87423 ...          165       166   \n",
      "\n",
      "       CITY  TYPE  FIPSCODE  GEOID_right   ShapeSTArea  \n",
      "0    Dallas  City     19000      4819000  1.070360e+10  \n",
      "2    Dallas  City     19000      4819000  1.070360e+10  \n",
      "3    Dallas  City     19000      4819000  1.070360e+10  \n",
      "7    Dallas  City     19000      4819000  1.070360e+10  \n",
      "15   Dallas  City     19000      4819000  1.070360e+10  \n",
      "..      ...   ...       ...          ...           ...  \n",
      "144  Dallas  City     19000      4819000  1.070360e+10  \n",
      "145  Dallas  City     19000      4819000  1.070360e+10  \n",
      "146  Dallas  City     19000      4819000  1.070360e+10  \n",
      "147  Dallas  City     19000      4819000  1.070360e+10  \n",
      "148  Dallas  City     19000      4819000  1.070360e+10  \n",
      "\n",
      "[87 rows x 106 columns]\n"
     ]
    }
   ],
   "source": [
    "print(gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "id": "180dbd97-3bf3-43a3-9911-dfc7ae697762",
   "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>STATE_ABV</th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>GEOID10_x</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>P_NEHD</th>\n",
       "      <th>PR_NEHD</th>\n",
       "      <th>HHB_SCORE</th>\n",
       "      <th>...</th>\n",
       "      <th>INTPTLAT10</th>\n",
       "      <th>INTPTLON10</th>\n",
       "      <th>geometry</th>\n",
       "      <th>index_right</th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>CITY</th>\n",
       "      <th>TYPE</th>\n",
       "      <th>FIPSCODE</th>\n",
       "      <th>GEOID_right</th>\n",
       "      <th>ShapeSTArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>14.200000</td>\n",
       "      <td>0.5885</td>\n",
       "      <td>0.7942</td>\n",
       "      <td>...</td>\n",
       "      <td>32.960047</td>\n",
       "      <td>-96.838522</td>\n",
       "      <td>MULTIPOLYGON (((-96.85888 32.95438, -96.85884 ...</td>\n",
       "      <td>165</td>\n",
       "      <td>166</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>14.266667</td>\n",
       "      <td>0.5989</td>\n",
       "      <td>0.6744</td>\n",
       "      <td>...</td>\n",
       "      <td>32.962141</td>\n",
       "      <td>-96.898585</td>\n",
       "      <td>MULTIPOLYGON (((-96.94437 32.96639, -96.94432 ...</td>\n",
       "      <td>165</td>\n",
       "      <td>166</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>14.255556</td>\n",
       "      <td>0.5987</td>\n",
       "      <td>0.6744</td>\n",
       "      <td>...</td>\n",
       "      <td>33.005262</td>\n",
       "      <td>-96.896742</td>\n",
       "      <td>MULTIPOLYGON (((-96.94845 32.994, -96.94833 32...</td>\n",
       "      <td>165</td>\n",
       "      <td>166</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75019</td>\n",
       "      <td>4875019</td>\n",
       "      <td>38666</td>\n",
       "      <td>79</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>14.400000</td>\n",
       "      <td>0.6046</td>\n",
       "      <td>0.8023</td>\n",
       "      <td>...</td>\n",
       "      <td>32.963417</td>\n",
       "      <td>-96.984664</td>\n",
       "      <td>MULTIPOLYGON (((-97.03258 32.95893, -97.03251 ...</td>\n",
       "      <td>165</td>\n",
       "      <td>166</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75032</td>\n",
       "      <td>4875032</td>\n",
       "      <td>27986</td>\n",
       "      <td>75</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>15.800000</td>\n",
       "      <td>0.7305</td>\n",
       "      <td>0.8653</td>\n",
       "      <td>...</td>\n",
       "      <td>32.857112</td>\n",
       "      <td>-96.431210</td>\n",
       "      <td>MULTIPOLYGON (((-96.51896 32.81372, -96.51887 ...</td>\n",
       "      <td>165</td>\n",
       "      <td>166</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>City</td>\n",
       "      <td>19000</td>\n",
       "      <td>4819000</td>\n",
       "      <td>1.070360e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 106 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATE_ABV ZCTA5CE10 GEOID10_x    POP  PR_HRI  F_HRI  LOW_EMS     P_NEHD  \\\n",
       "0      Texas     75001   4875001  12414      78   1.00        0  14.200000   \n",
       "2      Texas     75006   4875006  46364      70   0.75        0  14.266667   \n",
       "3      Texas     75007   4875007  51624      65   0.75        0  14.255556   \n",
       "7      Texas     75019   4875019  38666      79   1.00        0  14.400000   \n",
       "15     Texas     75032   4875032  27986      75   1.00        0  15.800000   \n",
       "\n",
       "    PR_NEHD  HHB_SCORE  ...  INTPTLAT10  INTPTLON10  \\\n",
       "0    0.5885     0.7942  ...   32.960047  -96.838522   \n",
       "2    0.5989     0.6744  ...   32.962141  -96.898585   \n",
       "3    0.5987     0.6744  ...   33.005262  -96.896742   \n",
       "7    0.6046     0.8023  ...   32.963417  -96.984664   \n",
       "15   0.7305     0.8653  ...   32.857112  -96.431210   \n",
       "\n",
       "                                             geometry  index_right  OBJECTID  \\\n",
       "0   MULTIPOLYGON (((-96.85888 32.95438, -96.85884 ...          165       166   \n",
       "2   MULTIPOLYGON (((-96.94437 32.96639, -96.94432 ...          165       166   \n",
       "3   MULTIPOLYGON (((-96.94845 32.994, -96.94833 32...          165       166   \n",
       "7   MULTIPOLYGON (((-97.03258 32.95893, -97.03251 ...          165       166   \n",
       "15  MULTIPOLYGON (((-96.51896 32.81372, -96.51887 ...          165       166   \n",
       "\n",
       "      CITY  TYPE  FIPSCODE  GEOID_right   ShapeSTArea  \n",
       "0   Dallas  City     19000      4819000  1.070360e+10  \n",
       "2   Dallas  City     19000      4819000  1.070360e+10  \n",
       "3   Dallas  City     19000      4819000  1.070360e+10  \n",
       "7   Dallas  City     19000      4819000  1.070360e+10  \n",
       "15  Dallas  City     19000      4819000  1.070360e+10  \n",
       "\n",
       "[5 rows x 106 columns]"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "id": "6126ef3b-356e-447e-94ce-cdb57d7b576d",
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf.drop(['INTPTLAT10', 'INTPTLON10', \n",
    "                'geometry', 'index_right', 'OBJECTID', 'CITY', 'TYPE', 'ShapeSTArea'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 259,
   "id": "2158aca1-67f7-499d-93a7-d7c931424f4b",
   "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>STATE_ABV</th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>GEOID10_x</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>P_NEHD</th>\n",
       "      <th>PR_NEHD</th>\n",
       "      <th>HHB_SCORE</th>\n",
       "      <th>...</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>LSAD</th>\n",
       "      <th>CLASSFP</th>\n",
       "      <th>MTFCC</th>\n",
       "      <th>CSAFP</th>\n",
       "      <th>CBSAFP</th>\n",
       "      <th>METDIVFP</th>\n",
       "      <th>FUNCSTAT</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>14.200000</td>\n",
       "      <td>0.5885</td>\n",
       "      <td>0.7942</td>\n",
       "      <td>...</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>206</td>\n",
       "      <td>14300</td>\n",
       "      <td>null</td>\n",
       "      <td>A</td>\n",
       "      <td>2307251053</td>\n",
       "      <td>20847065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>14.266667</td>\n",
       "      <td>0.5989</td>\n",
       "      <td>0.6744</td>\n",
       "      <td>...</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>206</td>\n",
       "      <td>14300</td>\n",
       "      <td>null</td>\n",
       "      <td>A</td>\n",
       "      <td>2307251053</td>\n",
       "      <td>20847065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>14.255556</td>\n",
       "      <td>0.5987</td>\n",
       "      <td>0.6744</td>\n",
       "      <td>...</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>206</td>\n",
       "      <td>14300</td>\n",
       "      <td>null</td>\n",
       "      <td>A</td>\n",
       "      <td>2307251053</td>\n",
       "      <td>20847065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75019</td>\n",
       "      <td>4875019</td>\n",
       "      <td>38666</td>\n",
       "      <td>79</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>14.400000</td>\n",
       "      <td>0.6046</td>\n",
       "      <td>0.8023</td>\n",
       "      <td>...</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>206</td>\n",
       "      <td>14300</td>\n",
       "      <td>null</td>\n",
       "      <td>A</td>\n",
       "      <td>2307251053</td>\n",
       "      <td>20847065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75032</td>\n",
       "      <td>4875032</td>\n",
       "      <td>27986</td>\n",
       "      <td>75</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>15.800000</td>\n",
       "      <td>0.7305</td>\n",
       "      <td>0.8653</td>\n",
       "      <td>...</td>\n",
       "      <td>Fannin County</td>\n",
       "      <td>6</td>\n",
       "      <td>H1</td>\n",
       "      <td>G4020</td>\n",
       "      <td>206</td>\n",
       "      <td>14300</td>\n",
       "      <td>null</td>\n",
       "      <td>A</td>\n",
       "      <td>2307251053</td>\n",
       "      <td>20847065</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 88 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATE_ABV ZCTA5CE10 GEOID10_x    POP  PR_HRI  F_HRI  LOW_EMS     P_NEHD  \\\n",
       "0      Texas     75001   4875001  12414      78   1.00        0  14.200000   \n",
       "2      Texas     75006   4875006  46364      70   0.75        0  14.266667   \n",
       "3      Texas     75007   4875007  51624      65   0.75        0  14.255556   \n",
       "7      Texas     75019   4875019  38666      79   1.00        0  14.400000   \n",
       "15     Texas     75032   4875032  27986      75   1.00        0  15.800000   \n",
       "\n",
       "    PR_NEHD  HHB_SCORE  ...       NAMELSAD  LSAD  CLASSFP  MTFCC  CSAFP  \\\n",
       "0    0.5885     0.7942  ...  Fannin County     6       H1  G4020    206   \n",
       "2    0.5989     0.6744  ...  Fannin County     6       H1  G4020    206   \n",
       "3    0.5987     0.6744  ...  Fannin County     6       H1  G4020    206   \n",
       "7    0.6046     0.8023  ...  Fannin County     6       H1  G4020    206   \n",
       "15   0.7305     0.8653  ...  Fannin County     6       H1  G4020    206   \n",
       "\n",
       "    CBSAFP  METDIVFP  FUNCSTAT       ALAND    AWATER  \n",
       "0    14300      null         A  2307251053  20847065  \n",
       "2    14300      null         A  2307251053  20847065  \n",
       "3    14300      null         A  2307251053  20847065  \n",
       "7    14300      null         A  2307251053  20847065  \n",
       "15   14300      null         A  2307251053  20847065  \n",
       "\n",
       "[5 rows x 88 columns]"
      ]
     },
     "execution_count": 259,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "id": "284ef093-73d0-4c48-a1ea-9047468fc322",
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf.drop(['NAMELSAD', 'MTFCC', 'CLASSFP', 'LSAD', 'CSAFP', 'METDIVFP', 'FUNCSTAT', 'CBSAFP',\n",
    "                'ALAND', 'AWATER'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 269,
   "id": "bd2535b8-cd3f-47ba-8a4b-5e380f941338",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    STATE_ABV ZCTA5CE10 GEOID10_x    POP  PR_HRI  F_HRI  LOW_EMS      P_NEHD  \\\n",
      "0       Texas     75001   4875001  12414      78   1.00        0   14.200000   \n",
      "2       Texas     75006   4875006  46364      70   0.75        0   14.266667   \n",
      "3       Texas     75007   4875007  51624      65   0.75        0   14.255556   \n",
      "7       Texas     75019   4875019  38666      79   1.00        0   14.400000   \n",
      "15      Texas     75032   4875032  27986      75   1.00        0   15.800000   \n",
      "..        ...       ...       ...    ...     ...    ...      ...         ...   \n",
      "144     Texas     75251   4875251   2331      92   1.00        0 -999.000000   \n",
      "145     Texas     75252   4875252  24112      48   0.50        0   14.220000   \n",
      "146     Texas     75253   4875253  18450      56   0.75        0   14.933333   \n",
      "147     Texas     75254   4875254  23253      56   0.75        0   14.200000   \n",
      "148     Texas     75287   4875287  49004      55   0.75        0   14.200000   \n",
      "\n",
      "      PR_NEHD  HHB_SCORE  ...  NBE_SCORE  NBE_RANK  OVERALL_SCORE  \\\n",
      "0      0.5885     0.7942  ...     0.7031    0.9440         0.5510   \n",
      "2      0.5989     0.6744  ...     0.7188    0.9538         0.5986   \n",
      "3      0.5987     0.6744  ...     0.6759    0.9238         0.4737   \n",
      "7      0.6046     0.8023  ...     0.6613    0.9100         0.4568   \n",
      "15     0.7305     0.8653  ...     0.6126    0.8551         0.4849   \n",
      "..        ...        ...  ...        ...       ...            ...   \n",
      "144 -999.0000     1.0000  ...     0.7996    0.9892         0.6009   \n",
      "145    0.5976     0.5488  ...     0.7619    0.9758         0.5070   \n",
      "146    0.6532     0.7016  ...     0.7670    0.9782         0.8215   \n",
      "147    0.5885     0.6692  ...     0.7431    0.9667         0.7028   \n",
      "148    0.5885     0.6692  ...     0.7192    0.9539         0.5339   \n",
      "\n",
      "     OVERALL_RANK  STATEFP  COUNTYFP  COUNTYNS  GEOID_left         GEOIDFQ  \\\n",
      "0          0.6627       48       147   1383859       48147  0500000US48147   \n",
      "2          0.7432       48       147   1383859       48147  0500000US48147   \n",
      "3          0.5112       48       147   1383859       48147  0500000US48147   \n",
      "7          0.4775       48       147   1383859       48147  0500000US48147   \n",
      "15         0.5335       48       147   1383859       48147  0500000US48147   \n",
      "..            ...      ...       ...       ...         ...             ...   \n",
      "144        0.7465       48       147   1383859       48147  0500000US48147   \n",
      "145        0.5781       48       147   1383859       48147  0500000US48147   \n",
      "146        0.9724       48       147   1383859       48147  0500000US48147   \n",
      "147        0.8816       48       147   1383859       48147  0500000US48147   \n",
      "148        0.6301       48       147   1383859       48147  0500000US48147   \n",
      "\n",
      "       NAME  \n",
      "0    Fannin  \n",
      "2    Fannin  \n",
      "3    Fannin  \n",
      "7    Fannin  \n",
      "15   Fannin  \n",
      "..      ...  \n",
      "144  Fannin  \n",
      "145  Fannin  \n",
      "146  Fannin  \n",
      "147  Fannin  \n",
      "148  Fannin  \n",
      "\n",
      "[87 rows x 78 columns]\n"
     ]
    }
   ],
   "source": [
    "print(gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 271,
   "id": "dbd08a47-1daf-4482-b6d2-2f31639dd9df",
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf.drop(['STATEFP', 'COUNTYFP', 'COUNTYNS', 'GEOID_left', 'GEOIDFQ', 'NAME'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "id": "5e529be4-de6d-40f0-96fd-6cba600feb06",
   "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>STATE_ABV</th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>GEOID10_x</th>\n",
       "      <th>POP</th>\n",
       "      <th>PR_HRI</th>\n",
       "      <th>F_HRI</th>\n",
       "      <th>LOW_EMS</th>\n",
       "      <th>P_NEHD</th>\n",
       "      <th>PR_NEHD</th>\n",
       "      <th>HHB_SCORE</th>\n",
       "      <th>...</th>\n",
       "      <th>P_RENT</th>\n",
       "      <th>PR_RENT</th>\n",
       "      <th>P_OZONE</th>\n",
       "      <th>PR_OZONE</th>\n",
       "      <th>P_PM25</th>\n",
       "      <th>PR_PM25</th>\n",
       "      <th>NBE_SCORE</th>\n",
       "      <th>NBE_RANK</th>\n",
       "      <th>OVERALL_SCORE</th>\n",
       "      <th>OVERALL_RANK</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75001</td>\n",
       "      <td>4875001</td>\n",
       "      <td>12414</td>\n",
       "      <td>78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>14.200000</td>\n",
       "      <td>0.5885</td>\n",
       "      <td>0.7942</td>\n",
       "      <td>...</td>\n",
       "      <td>82.888424</td>\n",
       "      <td>0.9852</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>0.9472</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7031</td>\n",
       "      <td>0.9440</td>\n",
       "      <td>0.5510</td>\n",
       "      <td>0.6627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75006</td>\n",
       "      <td>4875006</td>\n",
       "      <td>46364</td>\n",
       "      <td>70</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>14.266667</td>\n",
       "      <td>0.5989</td>\n",
       "      <td>0.6744</td>\n",
       "      <td>...</td>\n",
       "      <td>49.364908</td>\n",
       "      <td>0.9031</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.7188</td>\n",
       "      <td>0.9538</td>\n",
       "      <td>0.5986</td>\n",
       "      <td>0.7432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75007</td>\n",
       "      <td>4875007</td>\n",
       "      <td>51624</td>\n",
       "      <td>65</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0</td>\n",
       "      <td>14.255556</td>\n",
       "      <td>0.5987</td>\n",
       "      <td>0.6744</td>\n",
       "      <td>...</td>\n",
       "      <td>27.721552</td>\n",
       "      <td>0.6238</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6759</td>\n",
       "      <td>0.9238</td>\n",
       "      <td>0.4737</td>\n",
       "      <td>0.5112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75019</td>\n",
       "      <td>4875019</td>\n",
       "      <td>38666</td>\n",
       "      <td>79</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>14.400000</td>\n",
       "      <td>0.6046</td>\n",
       "      <td>0.8023</td>\n",
       "      <td>...</td>\n",
       "      <td>30.921540</td>\n",
       "      <td>0.6973</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.9573</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6613</td>\n",
       "      <td>0.9100</td>\n",
       "      <td>0.4568</td>\n",
       "      <td>0.4775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Texas</td>\n",
       "      <td>75032</td>\n",
       "      <td>4875032</td>\n",
       "      <td>27986</td>\n",
       "      <td>75</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>15.800000</td>\n",
       "      <td>0.7305</td>\n",
       "      <td>0.8653</td>\n",
       "      <td>...</td>\n",
       "      <td>17.692646</td>\n",
       "      <td>0.3248</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>0.9067</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.8668</td>\n",
       "      <td>0.6126</td>\n",
       "      <td>0.8551</td>\n",
       "      <td>0.4849</td>\n",
       "      <td>0.5335</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 72 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATE_ABV ZCTA5CE10 GEOID10_x    POP  PR_HRI  F_HRI  LOW_EMS     P_NEHD  \\\n",
       "0      Texas     75001   4875001  12414      78   1.00        0  14.200000   \n",
       "2      Texas     75006   4875006  46364      70   0.75        0  14.266667   \n",
       "3      Texas     75007   4875007  51624      65   0.75        0  14.255556   \n",
       "7      Texas     75019   4875019  38666      79   1.00        0  14.400000   \n",
       "15     Texas     75032   4875032  27986      75   1.00        0  15.800000   \n",
       "\n",
       "    PR_NEHD  HHB_SCORE  ...     P_RENT  PR_RENT   P_OZONE  PR_OZONE    P_PM25  \\\n",
       "0    0.5885     0.7942  ...  82.888424   0.9852  5.333333    0.9472  1.333333   \n",
       "2    0.5989     0.6744  ...  49.364908   0.9031  6.000000    0.9573  1.333333   \n",
       "3    0.5987     0.6744  ...  27.721552   0.6238  6.000000    0.9573  1.333333   \n",
       "7    0.6046     0.8023  ...  30.921540   0.6973  6.000000    0.9573  1.333333   \n",
       "15   0.7305     0.8653  ...  17.692646   0.3248  3.666667    0.9067  1.333333   \n",
       "\n",
       "    PR_PM25  NBE_SCORE  NBE_RANK  OVERALL_SCORE  OVERALL_RANK  \n",
       "0    0.8668     0.7031    0.9440         0.5510        0.6627  \n",
       "2    0.8668     0.7188    0.9538         0.5986        0.7432  \n",
       "3    0.8668     0.6759    0.9238         0.4737        0.5112  \n",
       "7    0.8668     0.6613    0.9100         0.4568        0.4775  \n",
       "15   0.8668     0.6126    0.8551         0.4849        0.5335  \n",
       "\n",
       "[5 rows x 72 columns]"
      ]
     },
     "execution_count": 273,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 275,
   "id": "797662ec-b6a1-413a-89a3-3777800f59bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf.to_csv('dallas_analysis.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}