distance_calculator.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "18ae36ee-7fbc-479d-aef2-b5ce45b56a5a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import plotly as pl\n",
    "import seaborn as sns\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "95b17e9c-cc88-45de-aae3-a6c2bd4f0d8d",
   "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</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>32.7794</td>\n",
       "      <td>-86.8287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>64.0685</td>\n",
       "      <td>-152.2782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>34.2744</td>\n",
       "      <td>-111.6602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>34.8938</td>\n",
       "      <td>-92.4426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>California</td>\n",
       "      <td>37.1841</td>\n",
       "      <td>-119.4696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>38.9972</td>\n",
       "      <td>-105.5478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>41.6219</td>\n",
       "      <td>-72.7273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>38.9896</td>\n",
       "      <td>-75.5050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>38.9101</td>\n",
       "      <td>-77.0147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Florida</td>\n",
       "      <td>28.6305</td>\n",
       "      <td>-82.4497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>32.6415</td>\n",
       "      <td>-83.4426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>20.2927</td>\n",
       "      <td>-156.3737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>44.3509</td>\n",
       "      <td>-114.6130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>40.0417</td>\n",
       "      <td>-89.1965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>39.8942</td>\n",
       "      <td>-86.2816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>42.0751</td>\n",
       "      <td>-93.4960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>38.4937</td>\n",
       "      <td>-98.3804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>37.5347</td>\n",
       "      <td>-85.3021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>31.0689</td>\n",
       "      <td>-91.9968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maine</td>\n",
       "      <td>45.3695</td>\n",
       "      <td>-69.2428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>39.0550</td>\n",
       "      <td>-76.7909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>42.2596</td>\n",
       "      <td>-71.8083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>44.3467</td>\n",
       "      <td>-85.4102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>46.2807</td>\n",
       "      <td>-94.3053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>32.7364</td>\n",
       "      <td>-89.6678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>38.3566</td>\n",
       "      <td>-92.4580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Montana</td>\n",
       "      <td>47.0527</td>\n",
       "      <td>-109.6333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>41.5378</td>\n",
       "      <td>-99.7951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>39.3289</td>\n",
       "      <td>-116.6312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>43.6805</td>\n",
       "      <td>-71.5811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>40.1907</td>\n",
       "      <td>-74.6728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>34.4071</td>\n",
       "      <td>-106.1126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>New York</td>\n",
       "      <td>42.9538</td>\n",
       "      <td>-75.5268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>35.5557</td>\n",
       "      <td>-79.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>47.4501</td>\n",
       "      <td>-100.4659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>40.2862</td>\n",
       "      <td>-82.7937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>35.5889</td>\n",
       "      <td>-97.4943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>43.9336</td>\n",
       "      <td>-120.5583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>40.8781</td>\n",
       "      <td>-77.7996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>41.6762</td>\n",
       "      <td>-71.5562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>33.9169</td>\n",
       "      <td>-80.8964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>44.4443</td>\n",
       "      <td>-100.2263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>35.8580</td>\n",
       "      <td>-86.3505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Texas</td>\n",
       "      <td>31.4757</td>\n",
       "      <td>-99.3312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Utah</td>\n",
       "      <td>39.3055</td>\n",
       "      <td>-111.6703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>44.0687</td>\n",
       "      <td>-72.6658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>37.5215</td>\n",
       "      <td>-78.8537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Washington</td>\n",
       "      <td>47.3826</td>\n",
       "      <td>-120.4472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>38.6409</td>\n",
       "      <td>-80.6227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>44.6243</td>\n",
       "      <td>-89.9941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>42.9957</td>\n",
       "      <td>-107.5512</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   state latitude  longitude\n",
       "0                Alabama  32.7794   -86.8287\n",
       "1                 Alaska  64.0685  -152.2782\n",
       "2                Arizona  34.2744  -111.6602\n",
       "3               Arkansas  34.8938   -92.4426\n",
       "4             California  37.1841  -119.4696\n",
       "5               Colorado  38.9972  -105.5478\n",
       "6            Connecticut  41.6219   -72.7273\n",
       "7               Delaware  38.9896   -75.5050\n",
       "8   District of Columbia  38.9101   -77.0147\n",
       "9                Florida  28.6305   -82.4497\n",
       "10               Georgia  32.6415   -83.4426\n",
       "11                Hawaii  20.2927  -156.3737\n",
       "12                 Idaho  44.3509  -114.6130\n",
       "13              Illinois  40.0417   -89.1965\n",
       "14               Indiana  39.8942   -86.2816\n",
       "15                  Iowa  42.0751   -93.4960\n",
       "16                Kansas  38.4937   -98.3804\n",
       "17              Kentucky  37.5347   -85.3021\n",
       "18             Louisiana  31.0689   -91.9968\n",
       "19                 Maine  45.3695   -69.2428\n",
       "20              Maryland  39.0550   -76.7909\n",
       "21         Massachusetts  42.2596   -71.8083\n",
       "22              Michigan  44.3467   -85.4102\n",
       "23             Minnesota  46.2807   -94.3053\n",
       "24           Mississippi  32.7364   -89.6678\n",
       "25              Missouri  38.3566   -92.4580\n",
       "26               Montana  47.0527  -109.6333\n",
       "27              Nebraska  41.5378   -99.7951\n",
       "28                Nevada  39.3289  -116.6312\n",
       "29         New Hampshire  43.6805   -71.5811\n",
       "30            New Jersey  40.1907   -74.6728\n",
       "31            New Mexico  34.4071  -106.1126\n",
       "32              New York  42.9538   -75.5268\n",
       "33        North Carolina  35.5557   -79.3877\n",
       "34          North Dakota  47.4501  -100.4659\n",
       "35                  Ohio  40.2862   -82.7937\n",
       "36              Oklahoma  35.5889   -97.4943\n",
       "37                Oregon  43.9336  -120.5583\n",
       "38          Pennsylvania  40.8781   -77.7996\n",
       "39          Rhode Island  41.6762   -71.5562\n",
       "40        South Carolina  33.9169   -80.8964\n",
       "41          South Dakota  44.4443  -100.2263\n",
       "42             Tennessee  35.8580   -86.3505\n",
       "43                 Texas  31.4757   -99.3312\n",
       "44                  Utah  39.3055  -111.6703\n",
       "45               Vermont  44.0687   -72.6658\n",
       "46              Virginia  37.5215   -78.8537\n",
       "47            Washington  47.3826  -120.4472\n",
       "48         West Virginia  38.6409   -80.6227\n",
       "49             Wisconsin  44.6243   -89.9941\n",
       "50               Wyoming  42.9957  -107.5512"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "location_df = pd.read_excel(\"US_state_location.xlsx\")\n",
    "location_df = location_df.iloc[:,0].str.split(\",\", expand=True)\n",
    "location_df.columns = ['state','latitude','longitude']\n",
    "location_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "f41b5b8e-e85e-458d-b645-83064d6ab7c7",
   "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</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>32.7794</td>\n",
       "      <td>-86.8287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AK</td>\n",
       "      <td>64.0685</td>\n",
       "      <td>-152.2782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZ</td>\n",
       "      <td>34.2744</td>\n",
       "      <td>-111.6602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AR</td>\n",
       "      <td>34.8938</td>\n",
       "      <td>-92.4426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA</td>\n",
       "      <td>37.1841</td>\n",
       "      <td>-119.4696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO</td>\n",
       "      <td>38.9972</td>\n",
       "      <td>-105.5478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CT</td>\n",
       "      <td>41.6219</td>\n",
       "      <td>-72.7273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DE</td>\n",
       "      <td>38.9896</td>\n",
       "      <td>-75.5050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DC</td>\n",
       "      <td>38.9101</td>\n",
       "      <td>-77.0147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FL</td>\n",
       "      <td>28.6305</td>\n",
       "      <td>-82.4497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GA</td>\n",
       "      <td>32.6415</td>\n",
       "      <td>-83.4426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>HI</td>\n",
       "      <td>20.2927</td>\n",
       "      <td>-156.3737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ID</td>\n",
       "      <td>44.3509</td>\n",
       "      <td>-114.6130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IL</td>\n",
       "      <td>40.0417</td>\n",
       "      <td>-89.1965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>IN</td>\n",
       "      <td>39.8942</td>\n",
       "      <td>-86.2816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IA</td>\n",
       "      <td>42.0751</td>\n",
       "      <td>-93.4960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>KS</td>\n",
       "      <td>38.4937</td>\n",
       "      <td>-98.3804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>KY</td>\n",
       "      <td>37.5347</td>\n",
       "      <td>-85.3021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>LA</td>\n",
       "      <td>31.0689</td>\n",
       "      <td>-91.9968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ME</td>\n",
       "      <td>45.3695</td>\n",
       "      <td>-69.2428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>MD</td>\n",
       "      <td>39.0550</td>\n",
       "      <td>-76.7909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MA</td>\n",
       "      <td>42.2596</td>\n",
       "      <td>-71.8083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>MI</td>\n",
       "      <td>44.3467</td>\n",
       "      <td>-85.4102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>MN</td>\n",
       "      <td>46.2807</td>\n",
       "      <td>-94.3053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MS</td>\n",
       "      <td>32.7364</td>\n",
       "      <td>-89.6678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MO</td>\n",
       "      <td>38.3566</td>\n",
       "      <td>-92.4580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MT</td>\n",
       "      <td>47.0527</td>\n",
       "      <td>-109.6333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NE</td>\n",
       "      <td>41.5378</td>\n",
       "      <td>-99.7951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NV</td>\n",
       "      <td>39.3289</td>\n",
       "      <td>-116.6312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>NH</td>\n",
       "      <td>43.6805</td>\n",
       "      <td>-71.5811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>NJ</td>\n",
       "      <td>40.1907</td>\n",
       "      <td>-74.6728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>NM</td>\n",
       "      <td>34.4071</td>\n",
       "      <td>-106.1126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NY</td>\n",
       "      <td>42.9538</td>\n",
       "      <td>-75.5268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>NC</td>\n",
       "      <td>35.5557</td>\n",
       "      <td>-79.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>ND</td>\n",
       "      <td>47.4501</td>\n",
       "      <td>-100.4659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>OH</td>\n",
       "      <td>40.2862</td>\n",
       "      <td>-82.7937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>OK</td>\n",
       "      <td>35.5889</td>\n",
       "      <td>-97.4943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>OR</td>\n",
       "      <td>43.9336</td>\n",
       "      <td>-120.5583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>PA</td>\n",
       "      <td>40.8781</td>\n",
       "      <td>-77.7996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>RI</td>\n",
       "      <td>41.6762</td>\n",
       "      <td>-71.5562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>SC</td>\n",
       "      <td>33.9169</td>\n",
       "      <td>-80.8964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>SD</td>\n",
       "      <td>44.4443</td>\n",
       "      <td>-100.2263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>TN</td>\n",
       "      <td>35.8580</td>\n",
       "      <td>-86.3505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>TX</td>\n",
       "      <td>31.4757</td>\n",
       "      <td>-99.3312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>UT</td>\n",
       "      <td>39.3055</td>\n",
       "      <td>-111.6703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>VT</td>\n",
       "      <td>44.0687</td>\n",
       "      <td>-72.6658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>VA</td>\n",
       "      <td>37.5215</td>\n",
       "      <td>-78.8537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>WA</td>\n",
       "      <td>47.3826</td>\n",
       "      <td>-120.4472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>WV</td>\n",
       "      <td>38.6409</td>\n",
       "      <td>-80.6227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>WI</td>\n",
       "      <td>44.6243</td>\n",
       "      <td>-89.9941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>WY</td>\n",
       "      <td>42.9957</td>\n",
       "      <td>-107.5512</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   state latitude  longitude\n",
       "0     AL  32.7794   -86.8287\n",
       "1     AK  64.0685  -152.2782\n",
       "2     AZ  34.2744  -111.6602\n",
       "3     AR  34.8938   -92.4426\n",
       "4     CA  37.1841  -119.4696\n",
       "5     CO  38.9972  -105.5478\n",
       "6     CT  41.6219   -72.7273\n",
       "7     DE  38.9896   -75.5050\n",
       "8     DC  38.9101   -77.0147\n",
       "9     FL  28.6305   -82.4497\n",
       "10    GA  32.6415   -83.4426\n",
       "11    HI  20.2927  -156.3737\n",
       "12    ID  44.3509  -114.6130\n",
       "13    IL  40.0417   -89.1965\n",
       "14    IN  39.8942   -86.2816\n",
       "15    IA  42.0751   -93.4960\n",
       "16    KS  38.4937   -98.3804\n",
       "17    KY  37.5347   -85.3021\n",
       "18    LA  31.0689   -91.9968\n",
       "19    ME  45.3695   -69.2428\n",
       "20    MD  39.0550   -76.7909\n",
       "21    MA  42.2596   -71.8083\n",
       "22    MI  44.3467   -85.4102\n",
       "23    MN  46.2807   -94.3053\n",
       "24    MS  32.7364   -89.6678\n",
       "25    MO  38.3566   -92.4580\n",
       "26    MT  47.0527  -109.6333\n",
       "27    NE  41.5378   -99.7951\n",
       "28    NV  39.3289  -116.6312\n",
       "29    NH  43.6805   -71.5811\n",
       "30    NJ  40.1907   -74.6728\n",
       "31    NM  34.4071  -106.1126\n",
       "32    NY  42.9538   -75.5268\n",
       "33    NC  35.5557   -79.3877\n",
       "34    ND  47.4501  -100.4659\n",
       "35    OH  40.2862   -82.7937\n",
       "36    OK  35.5889   -97.4943\n",
       "37    OR  43.9336  -120.5583\n",
       "38    PA  40.8781   -77.7996\n",
       "39    RI  41.6762   -71.5562\n",
       "40    SC  33.9169   -80.8964\n",
       "41    SD  44.4443  -100.2263\n",
       "42    TN  35.8580   -86.3505\n",
       "43    TX  31.4757   -99.3312\n",
       "44    UT  39.3055  -111.6703\n",
       "45    VT  44.0687   -72.6658\n",
       "46    VA  37.5215   -78.8537\n",
       "47    WA  47.3826  -120.4472\n",
       "48    WV  38.6409   -80.6227\n",
       "49    WI  44.6243   -89.9941\n",
       "50    WY  42.9957  -107.5512"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "us_state_to_abbrev = {\"state\" : {\n",
    "    \"Alabama\": \"AL\",\n",
    "    \"Alaska\": \"AK\",\n",
    "    \"Arizona\": \"AZ\",\n",
    "    \"Arkansas\": \"AR\",\n",
    "    \"California\": \"CA\",\n",
    "    \"Colorado\": \"CO\",\n",
    "    \"Connecticut\": \"CT\",\n",
    "    \"Delaware\": \"DE\",\n",
    "    \"Florida\": \"FL\",\n",
    "    \"Georgia\": \"GA\",\n",
    "    \"Hawaii\": \"HI\",\n",
    "    \"Idaho\": \"ID\",\n",
    "    \"Illinois\": \"IL\",\n",
    "    \"Indiana\": \"IN\",\n",
    "    \"Iowa\": \"IA\",\n",
    "    \"Kansas\": \"KS\",\n",
    "    \"Kentucky\": \"KY\",\n",
    "    \"Louisiana\": \"LA\",\n",
    "    \"Maine\": \"ME\",\n",
    "    \"Maryland\": \"MD\",\n",
    "    \"Massachusetts\": \"MA\",\n",
    "    \"Michigan\": \"MI\",\n",
    "    \"Minnesota\": \"MN\",\n",
    "    \"Mississippi\": \"MS\",\n",
    "    \"Missouri\": \"MO\",\n",
    "    \"Montana\": \"MT\",\n",
    "    \"Nebraska\": \"NE\",\n",
    "    \"Nevada\": \"NV\",\n",
    "    \"New Hampshire\": \"NH\",\n",
    "    \"New Jersey\": \"NJ\",\n",
    "    \"New Mexico\": \"NM\",\n",
    "    \"New York\": \"NY\",\n",
    "    \"North Carolina\": \"NC\",\n",
    "    \"North Dakota\": \"ND\",\n",
    "    \"Ohio\": \"OH\",\n",
    "    \"Oklahoma\": \"OK\",\n",
    "    \"Oregon\": \"OR\",\n",
    "    \"Pennsylvania\": \"PA\",\n",
    "    \"Rhode Island\": \"RI\",\n",
    "    \"South Carolina\": \"SC\",\n",
    "    \"South Dakota\": \"SD\",\n",
    "    \"Tennessee\": \"TN\",\n",
    "    \"Texas\": \"TX\",\n",
    "    \"Utah\": \"UT\",\n",
    "    \"Vermont\": \"VT\",\n",
    "    \"Virginia\": \"VA\",\n",
    "    \"Washington\": \"WA\",\n",
    "    \"West Virginia\": \"WV\",\n",
    "    \"Wisconsin\": \"WI\",\n",
    "    \"Wyoming\": \"WY\",\n",
    "    \"District of Columbia\": \"DC\",\n",
    "    \"American Samoa\": \"AS\",\n",
    "    \"Guam\": \"GU\",\n",
    "    \"Northern Mariana Islands\": \"MP\",\n",
    "    \"Puerto Rico\": \"PR\",\n",
    "    \"United States Minor Outlying Islands\": \"UM\",\n",
    "    \"U.S. Virgin Islands\": \"VI\",\n",
    "}}\n",
    "location_df = location_df.replace(us_state_to_abbrev)\n",
    "location_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "2ab89b49-b7d0-4d77-bce7-e486ae5b3ee1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting scipy\n",
      "  Using cached scipy-1.10.1.tar.gz (42.4 MB)\n",
      "\u001b[31mERROR: Could not install packages due to an OSError: [Errno 28] No space left on device\n",
      "\u001b[0m\u001b[31m\n",
      "\u001b[0m"
     ]
    }
   ],
   "source": [
    "!pip install scipy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6bdc7d72-892b-414e-96d9-60b239783b79",
   "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>state</th>\n",
       "      <th>AL</th>\n",
       "      <th>AK</th>\n",
       "      <th>AZ</th>\n",
       "      <th>AR</th>\n",
       "      <th>CA</th>\n",
       "      <th>CO</th>\n",
       "      <th>CT</th>\n",
       "      <th>DE</th>\n",
       "      <th>DC</th>\n",
       "      <th>FL</th>\n",
       "      <th>...</th>\n",
       "      <th>SD</th>\n",
       "      <th>TN</th>\n",
       "      <th>TX</th>\n",
       "      <th>UT</th>\n",
       "      <th>VT</th>\n",
       "      <th>VA</th>\n",
       "      <th>WA</th>\n",
       "      <th>WV</th>\n",
       "      <th>WI</th>\n",
       "      <th>WY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>state</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>3476.952449</td>\n",
       "      <td>1433.460157</td>\n",
       "      <td>354.170490</td>\n",
       "      <td>1867.241601</td>\n",
       "      <td>1131.613777</td>\n",
       "      <td>986.173644</td>\n",
       "      <td>765.184413</td>\n",
       "      <td>693.655919</td>\n",
       "      <td>386.732876</td>\n",
       "      <td>...</td>\n",
       "      <td>1080.232672</td>\n",
       "      <td>213.954618</td>\n",
       "      <td>738.109503</td>\n",
       "      <td>1456.478516</td>\n",
       "      <td>1090.974086</td>\n",
       "      <td>557.099628</td>\n",
       "      <td>2024.199744</td>\n",
       "      <td>533.636791</td>\n",
       "      <td>834.584831</td>\n",
       "      <td>1328.358591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AK</th>\n",
       "      <td>3476.952449</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2675.275492</td>\n",
       "      <td>3183.979244</td>\n",
       "      <td>2299.905352</td>\n",
       "      <td>2559.799212</td>\n",
       "      <td>3391.636928</td>\n",
       "      <td>3458.898012</td>\n",
       "      <td>3418.112638</td>\n",
       "      <td>3855.474872</td>\n",
       "      <td>...</td>\n",
       "      <td>2406.735722</td>\n",
       "      <td>3311.320134</td>\n",
       "      <td>3184.662400</td>\n",
       "      <td>2370.852192</td>\n",
       "      <td>3255.821974</td>\n",
       "      <td>3442.374153</td>\n",
       "      <td>1663.916968</td>\n",
       "      <td>3324.641802</td>\n",
       "      <td>2706.157416</td>\n",
       "      <td>2271.726388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AZ</th>\n",
       "      <td>1433.460157</td>\n",
       "      <td>2675.275492</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1094.736197</td>\n",
       "      <td>482.459726</td>\n",
       "      <td>470.340950</td>\n",
       "      <td>2166.364245</td>\n",
       "      <td>2021.943897</td>\n",
       "      <td>1940.833548</td>\n",
       "      <td>1761.986118</td>\n",
       "      <td>...</td>\n",
       "      <td>929.347207</td>\n",
       "      <td>1434.654114</td>\n",
       "      <td>741.879342</td>\n",
       "      <td>346.924962</td>\n",
       "      <td>2177.098367</td>\n",
       "      <td>1844.529976</td>\n",
       "      <td>1013.453014</td>\n",
       "      <td>1746.217842</td>\n",
       "      <td>1354.639634</td>\n",
       "      <td>641.113991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AR</th>\n",
       "      <td>354.170490</td>\n",
       "      <td>3183.979244</td>\n",
       "      <td>1094.736197</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1516.503429</td>\n",
       "      <td>777.669806</td>\n",
       "      <td>1164.828467</td>\n",
       "      <td>977.437011</td>\n",
       "      <td>896.828318</td>\n",
       "      <td>728.885190</td>\n",
       "      <td>...</td>\n",
       "      <td>777.835123</td>\n",
       "      <td>350.279840</td>\n",
       "      <td>463.320872</td>\n",
       "      <td>1102.351963</td>\n",
       "      <td>1227.472212</td>\n",
       "      <td>779.859361</td>\n",
       "      <td>1682.484605</td>\n",
       "      <td>704.126775</td>\n",
       "      <td>683.768475</td>\n",
       "      <td>984.865003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CA</th>\n",
       "      <td>1867.241601</td>\n",
       "      <td>2299.905352</td>\n",
       "      <td>482.459726</td>\n",
       "      <td>1516.503429</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>768.309708</td>\n",
       "      <td>2489.645564</td>\n",
       "      <td>2376.435685</td>\n",
       "      <td>2297.622941</td>\n",
       "      <td>2215.862502</td>\n",
       "      <td>...</td>\n",
       "      <td>1122.595133</td>\n",
       "      <td>1836.112688</td>\n",
       "      <td>1214.042462</td>\n",
       "      <td>448.579322</td>\n",
       "      <td>2471.840033</td>\n",
       "      <td>2218.373060</td>\n",
       "      <td>705.678720</td>\n",
       "      <td>2109.112445</td>\n",
       "      <td>1615.958302</td>\n",
       "      <td>746.991455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CO</th>\n",
       "      <td>1131.613777</td>\n",
       "      <td>2559.799212</td>\n",
       "      <td>470.340950</td>\n",
       "      <td>777.669806</td>\n",
       "      <td>768.309708</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1732.522617</td>\n",
       "      <td>1609.819683</td>\n",
       "      <td>1530.503752</td>\n",
       "      <td>1502.494979</td>\n",
       "      <td>...</td>\n",
       "      <td>465.631647</td>\n",
       "      <td>1075.623411</td>\n",
       "      <td>626.106155</td>\n",
       "      <td>329.477021</td>\n",
       "      <td>1728.582959</td>\n",
       "      <td>1450.089949</td>\n",
       "      <td>946.715117</td>\n",
       "      <td>1341.064220</td>\n",
       "      <td>890.079849</td>\n",
       "      <td>295.105456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CT</th>\n",
       "      <td>986.173644</td>\n",
       "      <td>3391.636928</td>\n",
       "      <td>2166.364245</td>\n",
       "      <td>1164.828467</td>\n",
       "      <td>2489.645564</td>\n",
       "      <td>1732.522617</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>233.456869</td>\n",
       "      <td>293.803167</td>\n",
       "      <td>1049.676960</td>\n",
       "      <td>...</td>\n",
       "      <td>1399.373709</td>\n",
       "      <td>835.099169</td>\n",
       "      <td>1628.123403</td>\n",
       "      <td>2041.088388</td>\n",
       "      <td>168.926488</td>\n",
       "      <td>432.241837</td>\n",
       "      <td>2353.497591</td>\n",
       "      <td>465.726447</td>\n",
       "      <td>895.511977</td>\n",
       "      <td>1773.793119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DE</th>\n",
       "      <td>765.184413</td>\n",
       "      <td>3458.898012</td>\n",
       "      <td>2021.943897</td>\n",
       "      <td>977.437011</td>\n",
       "      <td>2376.435685</td>\n",
       "      <td>1609.819683</td>\n",
       "      <td>233.456869</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>81.503941</td>\n",
       "      <td>817.506227</td>\n",
       "      <td>...</td>\n",
       "      <td>1326.755627</td>\n",
       "      <td>633.899941</td>\n",
       "      <td>1438.483773</td>\n",
       "      <td>1929.599786</td>\n",
       "      <td>380.122570</td>\n",
       "      <td>208.360154</td>\n",
       "      <td>2308.538852</td>\n",
       "      <td>277.194377</td>\n",
       "      <td>841.494832</td>\n",
       "      <td>1687.655863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DC</th>\n",
       "      <td>693.655919</td>\n",
       "      <td>3418.112638</td>\n",
       "      <td>1940.833548</td>\n",
       "      <td>896.828318</td>\n",
       "      <td>2297.622941</td>\n",
       "      <td>1530.503752</td>\n",
       "      <td>293.803167</td>\n",
       "      <td>81.503941</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>774.071971</td>\n",
       "      <td>...</td>\n",
       "      <td>1255.248648</td>\n",
       "      <td>554.843924</td>\n",
       "      <td>1358.393683</td>\n",
       "      <td>1851.238672</td>\n",
       "      <td>421.352518</td>\n",
       "      <td>138.511640</td>\n",
       "      <td>2240.431136</td>\n",
       "      <td>195.690439</td>\n",
       "      <td>776.619257</td>\n",
       "      <td>1613.033252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FL</th>\n",
       "      <td>386.732876</td>\n",
       "      <td>3855.474872</td>\n",
       "      <td>1761.986118</td>\n",
       "      <td>728.885190</td>\n",
       "      <td>2215.862502</td>\n",
       "      <td>1502.494979</td>\n",
       "      <td>1049.676960</td>\n",
       "      <td>817.506227</td>\n",
       "      <td>774.071971</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1465.634256</td>\n",
       "      <td>547.755178</td>\n",
       "      <td>1029.268759</td>\n",
       "      <td>1821.673880</td>\n",
       "      <td>1194.129477</td>\n",
       "      <td>647.107426</td>\n",
       "      <td>2408.682511</td>\n",
       "      <td>697.868557</td>\n",
       "      <td>1178.544313</td>\n",
       "      <td>1711.766174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GA</th>\n",
       "      <td>197.487904</td>\n",
       "      <td>3587.490225</td>\n",
       "      <td>1628.729880</td>\n",
       "      <td>540.574287</td>\n",
       "      <td>2057.073972</td>\n",
       "      <td>1312.284756</td>\n",
       "      <td>855.115294</td>\n",
       "      <td>624.184114</td>\n",
       "      <td>562.872892</td>\n",
       "      <td>282.561179</td>\n",
       "      <td>...</td>\n",
       "      <td>1215.982702</td>\n",
       "      <td>277.190959</td>\n",
       "      <td>934.886444</td>\n",
       "      <td>1639.751899</td>\n",
       "      <td>979.878198</td>\n",
       "      <td>425.064107</td>\n",
       "      <td>2182.981663</td>\n",
       "      <td>442.947446</td>\n",
       "      <td>898.574087</td>\n",
       "      <td>1492.189858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HI</th>\n",
       "      <td>4317.927116</td>\n",
       "      <td>3027.578808</td>\n",
       "      <td>2887.977304</td>\n",
       "      <td>3982.711145</td>\n",
       "      <td>2501.929912</td>\n",
       "      <td>3268.957841</td>\n",
       "      <td>4986.890804</td>\n",
       "      <td>4878.309844</td>\n",
       "      <td>4799.322319</td>\n",
       "      <td>4621.924269</td>\n",
       "      <td>...</td>\n",
       "      <td>3595.614350</td>\n",
       "      <td>4319.976591</td>\n",
       "      <td>3595.259839</td>\n",
       "      <td>2949.514364</td>\n",
       "      <td>4956.983801</td>\n",
       "      <td>4716.884320</td>\n",
       "      <td>2742.560104</td>\n",
       "      <td>4609.820103</td>\n",
       "      <td>4099.915134</td>\n",
       "      <td>3216.699946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <td>1691.497630</td>\n",
       "      <td>1995.169309</td>\n",
       "      <td>712.781172</td>\n",
       "      <td>1344.585722</td>\n",
       "      <td>556.046610</td>\n",
       "      <td>596.479579</td>\n",
       "      <td>2107.859274</td>\n",
       "      <td>2037.266877</td>\n",
       "      <td>1964.727834</td>\n",
       "      <td>2073.129915</td>\n",
       "      <td>...</td>\n",
       "      <td>711.306742</td>\n",
       "      <td>1597.963021</td>\n",
       "      <td>1214.868205</td>\n",
       "      <td>379.831674</td>\n",
       "      <td>2060.081715</td>\n",
       "      <td>1913.265495</td>\n",
       "      <td>350.666680</td>\n",
       "      <td>1793.404633</td>\n",
       "      <td>1212.366735</td>\n",
       "      <td>365.896330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IL</th>\n",
       "      <td>517.785012</td>\n",
       "      <td>2985.089889</td>\n",
       "      <td>1297.952561</td>\n",
       "      <td>397.259156</td>\n",
       "      <td>1642.190178</td>\n",
       "      <td>875.400156</td>\n",
       "      <td>868.687174</td>\n",
       "      <td>734.452339</td>\n",
       "      <td>655.432899</td>\n",
       "      <td>875.358762</td>\n",
       "      <td>...</td>\n",
       "      <td>641.337618</td>\n",
       "      <td>327.698345</td>\n",
       "      <td>819.329185</td>\n",
       "      <td>1196.043722</td>\n",
       "      <td>892.717953</td>\n",
       "      <td>584.453005</td>\n",
       "      <td>1632.221530</td>\n",
       "      <td>469.131644</td>\n",
       "      <td>318.920923</td>\n",
       "      <td>971.484456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IN</th>\n",
       "      <td>491.517044</td>\n",
       "      <td>3081.825823</td>\n",
       "      <td>1449.149024</td>\n",
       "      <td>483.313148</td>\n",
       "      <td>1797.257985</td>\n",
       "      <td>1030.363031</td>\n",
       "      <td>720.330186</td>\n",
       "      <td>579.456675</td>\n",
       "      <td>500.365340</td>\n",
       "      <td>806.523630</td>\n",
       "      <td>...</td>\n",
       "      <td>780.499507</td>\n",
       "      <td>278.396636</td>\n",
       "      <td>933.999071</td>\n",
       "      <td>1351.027030</td>\n",
       "      <td>756.868377</td>\n",
       "      <td>433.361125</td>\n",
       "      <td>1773.207512</td>\n",
       "      <td>315.463470</td>\n",
       "      <td>377.810188</td>\n",
       "      <td>1121.803934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IA</th>\n",
       "      <td>737.940095</td>\n",
       "      <td>2740.604918</td>\n",
       "      <td>1122.539880</td>\n",
       "      <td>498.605875</td>\n",
       "      <td>1420.104592</td>\n",
       "      <td>668.354765</td>\n",
       "      <td>1069.546399</td>\n",
       "      <td>968.833895</td>\n",
       "      <td>893.675302</td>\n",
       "      <td>1115.090675</td>\n",
       "      <td>...</td>\n",
       "      <td>376.738690</td>\n",
       "      <td>575.753001</td>\n",
       "      <td>798.840857</td>\n",
       "      <td>971.542150</td>\n",
       "      <td>1060.228195</td>\n",
       "      <td>838.770183</td>\n",
       "      <td>1368.619886</td>\n",
       "      <td>718.751044</td>\n",
       "      <td>249.140094</td>\n",
       "      <td>719.439495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KS</th>\n",
       "      <td>759.282031</td>\n",
       "      <td>2797.737299</td>\n",
       "      <td>794.531070</td>\n",
       "      <td>412.563455</td>\n",
       "      <td>1154.487307</td>\n",
       "      <td>388.631627</td>\n",
       "      <td>1371.836328</td>\n",
       "      <td>1233.002602</td>\n",
       "      <td>1152.578730</td>\n",
       "      <td>1140.365941</td>\n",
       "      <td>...</td>\n",
       "      <td>421.655784</td>\n",
       "      <td>687.678525</td>\n",
       "      <td>486.777487</td>\n",
       "      <td>717.901783</td>\n",
       "      <td>1386.359134</td>\n",
       "      <td>1065.696858</td>\n",
       "      <td>1269.954194</td>\n",
       "      <td>960.189633</td>\n",
       "      <td>605.983178</td>\n",
       "      <td>572.315128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KY</th>\n",
       "      <td>339.003175</td>\n",
       "      <td>3246.227376</td>\n",
       "      <td>1490.481661</td>\n",
       "      <td>438.385146</td>\n",
       "      <td>1870.516504</td>\n",
       "      <td>1103.261017</td>\n",
       "      <td>727.227586</td>\n",
       "      <td>541.865565</td>\n",
       "      <td>460.621312</td>\n",
       "      <td>635.448679</td>\n",
       "      <td>...</td>\n",
       "      <td>912.350270</td>\n",
       "      <td>129.443431</td>\n",
       "      <td>901.566856</td>\n",
       "      <td>1430.959157</td>\n",
       "      <td>800.003289</td>\n",
       "      <td>354.106432</td>\n",
       "      <td>1901.010842</td>\n",
       "      <td>266.209931</td>\n",
       "      <td>546.904628</td>\n",
       "      <td>1230.568945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LA</th>\n",
       "      <td>325.712907</td>\n",
       "      <td>3423.466295</td>\n",
       "      <td>1165.188914</td>\n",
       "      <td>264.851958</td>\n",
       "      <td>1623.788909</td>\n",
       "      <td>941.188490</td>\n",
       "      <td>1293.179163</td>\n",
       "      <td>1080.362012</td>\n",
       "      <td>1005.209553</td>\n",
       "      <td>597.102757</td>\n",
       "      <td>...</td>\n",
       "      <td>1025.324848</td>\n",
       "      <td>463.833813</td>\n",
       "      <td>434.830246</td>\n",
       "      <td>1246.067362</td>\n",
       "      <td>1382.893687</td>\n",
       "      <td>872.288710</td>\n",
       "      <td>1878.806182</td>\n",
       "      <td>829.599041</td>\n",
       "      <td>941.212612</td>\n",
       "      <td>1186.182753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ME</th>\n",
       "      <td>1278.636248</td>\n",
       "      <td>3282.666178</td>\n",
       "      <td>2351.786330</td>\n",
       "      <td>1417.787735</td>\n",
       "      <td>2630.762177</td>\n",
       "      <td>1897.617808</td>\n",
       "      <td>312.344021</td>\n",
       "      <td>544.821255</td>\n",
       "      <td>597.869840</td>\n",
       "      <td>1361.924919</td>\n",
       "      <td>...</td>\n",
       "      <td>1512.367018</td>\n",
       "      <td>1109.703559</td>\n",
       "      <td>1876.711065</td>\n",
       "      <td>2186.356918</td>\n",
       "      <td>190.940164</td>\n",
       "      <td>735.406769</td>\n",
       "      <td>2407.259263</td>\n",
       "      <td>746.299019</td>\n",
       "      <td>1015.208446</td>\n",
       "      <td>1892.352254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MD</th>\n",
       "      <td>709.248189</td>\n",
       "      <td>3416.550766</td>\n",
       "      <td>1952.646134</td>\n",
       "      <td>910.859964</td>\n",
       "      <td>2307.628845</td>\n",
       "      <td>1540.807645</td>\n",
       "      <td>278.150994</td>\n",
       "      <td>69.340932</td>\n",
       "      <td>15.655615</td>\n",
       "      <td>788.303148</td>\n",
       "      <td>...</td>\n",
       "      <td>1261.956713</td>\n",
       "      <td>569.547849</td>\n",
       "      <td>1372.662723</td>\n",
       "      <td>1860.980339</td>\n",
       "      <td>406.609915</td>\n",
       "      <td>154.142141</td>\n",
       "      <td>2246.023495</td>\n",
       "      <td>208.643693</td>\n",
       "      <td>780.966220</td>\n",
       "      <td>1620.992143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MA</th>\n",
       "      <td>1049.975618</td>\n",
       "      <td>3382.635159</td>\n",
       "      <td>2214.335458</td>\n",
       "      <td>1223.168628</td>\n",
       "      <td>2529.911178</td>\n",
       "      <td>1776.223584</td>\n",
       "      <td>64.648763</td>\n",
       "      <td>297.733455</td>\n",
       "      <td>358.244674</td>\n",
       "      <td>1112.931876</td>\n",
       "      <td>...</td>\n",
       "      <td>1432.261801</td>\n",
       "      <td>896.387954</td>\n",
       "      <td>1686.267485</td>\n",
       "      <td>2081.582096</td>\n",
       "      <td>132.186969</td>\n",
       "      <td>496.728944</td>\n",
       "      <td>2376.840038</td>\n",
       "      <td>527.071793</td>\n",
       "      <td>927.211649</td>\n",
       "      <td>1808.750602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MI</th>\n",
       "      <td>801.533036</td>\n",
       "      <td>2860.145689</td>\n",
       "      <td>1559.604169</td>\n",
       "      <td>751.684892</td>\n",
       "      <td>1839.321395</td>\n",
       "      <td>1102.024218</td>\n",
       "      <td>668.928924</td>\n",
       "      <td>631.253098</td>\n",
       "      <td>573.691842</td>\n",
       "      <td>1095.946540</td>\n",
       "      <td>...</td>\n",
       "      <td>732.506780</td>\n",
       "      <td>587.782202</td>\n",
       "      <td>1165.626396</td>\n",
       "      <td>1392.895756</td>\n",
       "      <td>632.586257</td>\n",
       "      <td>582.263109</td>\n",
       "      <td>1689.007962</td>\n",
       "      <td>465.373866</td>\n",
       "      <td>227.359326</td>\n",
       "      <td>1110.048952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MN</th>\n",
       "      <td>1012.307839</td>\n",
       "      <td>2486.024624</td>\n",
       "      <td>1230.829148</td>\n",
       "      <td>791.730715</td>\n",
       "      <td>1436.052544</td>\n",
       "      <td>760.902313</td>\n",
       "      <td>1119.279849</td>\n",
       "      <td>1078.512041</td>\n",
       "      <td>1014.828905</td>\n",
       "      <td>1377.179044</td>\n",
       "      <td>...</td>\n",
       "      <td>314.812022</td>\n",
       "      <td>829.579680</td>\n",
       "      <td>1056.027035</td>\n",
       "      <td>1002.457011</td>\n",
       "      <td>1064.531238</td>\n",
       "      <td>997.109162</td>\n",
       "      <td>1235.810701</td>\n",
       "      <td>873.765375</td>\n",
       "      <td>238.690855</td>\n",
       "      <td>690.289776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <td>165.334460</td>\n",
       "      <td>3394.038861</td>\n",
       "      <td>1271.686938</td>\n",
       "      <td>218.135844</td>\n",
       "      <td>1711.550867</td>\n",
       "      <td>988.294757</td>\n",
       "      <td>1114.506349</td>\n",
       "      <td>902.732351</td>\n",
       "      <td>827.032228</td>\n",
       "      <td>514.263107</td>\n",
       "      <td>...</td>\n",
       "      <td>987.536884</td>\n",
       "      <td>286.847512</td>\n",
       "      <td>573.141474</td>\n",
       "      <td>1308.832730</td>\n",
       "      <td>1205.031300</td>\n",
       "      <td>694.982871</td>\n",
       "      <td>1900.382555</td>\n",
       "      <td>650.965927</td>\n",
       "      <td>820.198472</td>\n",
       "      <td>1202.736282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MO</th>\n",
       "      <td>498.158442</td>\n",
       "      <td>2982.588290</td>\n",
       "      <td>1105.567097</td>\n",
       "      <td>238.775500</td>\n",
       "      <td>1475.725552</td>\n",
       "      <td>708.545322</td>\n",
       "      <td>1068.526525</td>\n",
       "      <td>916.430642</td>\n",
       "      <td>835.415342</td>\n",
       "      <td>883.847719</td>\n",
       "      <td>...</td>\n",
       "      <td>582.075183</td>\n",
       "      <td>378.667148</td>\n",
       "      <td>613.833535</td>\n",
       "      <td>1036.710193</td>\n",
       "      <td>1100.731594</td>\n",
       "      <td>744.640206</td>\n",
       "      <td>1540.790669</td>\n",
       "      <td>641.385729</td>\n",
       "      <td>450.982171</td>\n",
       "      <td>853.532708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <td>1551.080495</td>\n",
       "      <td>1985.735915</td>\n",
       "      <td>888.052761</td>\n",
       "      <td>1224.648581</td>\n",
       "      <td>846.719073</td>\n",
       "      <td>593.100128</td>\n",
       "      <td>1848.883412</td>\n",
       "      <td>1799.532228</td>\n",
       "      <td>1731.368566</td>\n",
       "      <td>1937.805589</td>\n",
       "      <td>...</td>\n",
       "      <td>488.817526</td>\n",
       "      <td>1426.031818</td>\n",
       "      <td>1205.800046</td>\n",
       "      <td>544.561703</td>\n",
       "      <td>1788.332660</td>\n",
       "      <td>1695.173788</td>\n",
       "      <td>509.074817</td>\n",
       "      <td>1572.513069</td>\n",
       "      <td>960.113212</td>\n",
       "      <td>298.102416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NE</th>\n",
       "      <td>934.589140</td>\n",
       "      <td>2581.687315</td>\n",
       "      <td>818.040581</td>\n",
       "      <td>607.845122</td>\n",
       "      <td>1092.838666</td>\n",
       "      <td>350.848539</td>\n",
       "      <td>1396.809643</td>\n",
       "      <td>1291.525486</td>\n",
       "      <td>1214.734085</td>\n",
       "      <td>1321.050531</td>\n",
       "      <td>...</td>\n",
       "      <td>201.820356</td>\n",
       "      <td>824.284325</td>\n",
       "      <td>694.290238</td>\n",
       "      <td>644.303545</td>\n",
       "      <td>1383.602492</td>\n",
       "      <td>1149.418182</td>\n",
       "      <td>1093.968300</td>\n",
       "      <td>1033.184808</td>\n",
       "      <td>539.307641</td>\n",
       "      <td>409.985982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NV</th>\n",
       "      <td>1719.888665</td>\n",
       "      <td>2238.483172</td>\n",
       "      <td>444.202213</td>\n",
       "      <td>1366.017651</td>\n",
       "      <td>213.785465</td>\n",
       "      <td>595.282750</td>\n",
       "      <td>2293.724926</td>\n",
       "      <td>2189.392796</td>\n",
       "      <td>2111.697542</td>\n",
       "      <td>2081.517941</td>\n",
       "      <td>...</td>\n",
       "      <td>914.665138</td>\n",
       "      <td>1670.905667</td>\n",
       "      <td>1113.754550</td>\n",
       "      <td>265.806283</td>\n",
       "      <td>2270.067058</td>\n",
       "      <td>2038.670231</td>\n",
       "      <td>588.077548</td>\n",
       "      <td>1926.287261</td>\n",
       "      <td>1412.634770</td>\n",
       "      <td>536.471148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NH</th>\n",
       "      <td>1116.230173</td>\n",
       "      <td>3309.287605</td>\n",
       "      <td>2229.362037</td>\n",
       "      <td>1266.959668</td>\n",
       "      <td>2528.528974</td>\n",
       "      <td>1783.022928</td>\n",
       "      <td>153.625410</td>\n",
       "      <td>382.575431</td>\n",
       "      <td>433.781095</td>\n",
       "      <td>1200.078396</td>\n",
       "      <td>...</td>\n",
       "      <td>1419.790486</td>\n",
       "      <td>951.409468</td>\n",
       "      <td>1728.261532</td>\n",
       "      <td>2081.347044</td>\n",
       "      <td>60.439464</td>\n",
       "      <td>571.286271</td>\n",
       "      <td>2346.354453</td>\n",
       "      <td>585.336970</td>\n",
       "      <td>915.673270</td>\n",
       "      <td>1798.778531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NJ</th>\n",
       "      <td>846.737194</td>\n",
       "      <td>3415.165661</td>\n",
       "      <td>2064.423534</td>\n",
       "      <td>1039.673168</td>\n",
       "      <td>2405.041785</td>\n",
       "      <td>1641.675203</td>\n",
       "      <td>141.863557</td>\n",
       "      <td>94.016679</td>\n",
       "      <td>153.121124</td>\n",
       "      <td>911.382356</td>\n",
       "      <td>...</td>\n",
       "      <td>1335.610125</td>\n",
       "      <td>702.946552</td>\n",
       "      <td>1502.604436</td>\n",
       "      <td>1956.904825</td>\n",
       "      <td>286.806370</td>\n",
       "      <td>291.059347</td>\n",
       "      <td>2307.757624</td>\n",
       "      <td>335.772820</td>\n",
       "      <td>839.699933</td>\n",
       "      <td>1703.339969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NM</th>\n",
       "      <td>1116.190464</td>\n",
       "      <td>2816.712563</td>\n",
       "      <td>317.276353</td>\n",
       "      <td>778.815901</td>\n",
       "      <td>773.550232</td>\n",
       "      <td>318.057728</td>\n",
       "      <td>1875.499907</td>\n",
       "      <td>1720.258122</td>\n",
       "      <td>1638.828728</td>\n",
       "      <td>1448.326174</td>\n",
       "      <td>...</td>\n",
       "      <td>760.164395</td>\n",
       "      <td>1121.714023</td>\n",
       "      <td>442.665856</td>\n",
       "      <td>456.899488</td>\n",
       "      <td>1898.313393</td>\n",
       "      <td>1537.412043</td>\n",
       "      <td>1164.454255</td>\n",
       "      <td>1443.346291</td>\n",
       "      <td>1109.348599</td>\n",
       "      <td>597.482994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NY</th>\n",
       "      <td>933.247111</td>\n",
       "      <td>3233.685280</td>\n",
       "      <td>2027.463266</td>\n",
       "      <td>1064.664292</td>\n",
       "      <td>2335.951562</td>\n",
       "      <td>1584.889790</td>\n",
       "      <td>170.380572</td>\n",
       "      <td>273.553581</td>\n",
       "      <td>289.681605</td>\n",
       "      <td>1060.350230</td>\n",
       "      <td>...</td>\n",
       "      <td>1236.719586</td>\n",
       "      <td>757.279305</td>\n",
       "      <td>1524.883735</td>\n",
       "      <td>1887.841059</td>\n",
       "      <td>163.046252</td>\n",
       "      <td>413.947628</td>\n",
       "      <td>2184.600447</td>\n",
       "      <td>399.809396</td>\n",
       "      <td>731.695022</td>\n",
       "      <td>1613.286918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <td>467.113144</td>\n",
       "      <td>3539.958984</td>\n",
       "      <td>1826.453934</td>\n",
       "      <td>739.359452</td>\n",
       "      <td>2221.185832</td>\n",
       "      <td>1455.868710</td>\n",
       "      <td>551.984387</td>\n",
       "      <td>319.094177</td>\n",
       "      <td>265.738886</td>\n",
       "      <td>509.764601</td>\n",
       "      <td>...</td>\n",
       "      <td>1259.148040</td>\n",
       "      <td>392.001424</td>\n",
       "      <td>1182.873090</td>\n",
       "      <td>1784.524245</td>\n",
       "      <td>687.078184</td>\n",
       "      <td>138.765278</td>\n",
       "      <td>2251.064951</td>\n",
       "      <td>223.416435</td>\n",
       "      <td>839.609240</td>\n",
       "      <td>1586.013035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ND</th>\n",
       "      <td>1239.531342</td>\n",
       "      <td>2237.421669</td>\n",
       "      <td>1079.407683</td>\n",
       "      <td>960.927902</td>\n",
       "      <td>1198.699388</td>\n",
       "      <td>637.073768</td>\n",
       "      <td>1419.205892</td>\n",
       "      <td>1380.853297</td>\n",
       "      <td>1316.213954</td>\n",
       "      <td>1619.490901</td>\n",
       "      <td>...</td>\n",
       "      <td>207.917723</td>\n",
       "      <td>1080.016800</td>\n",
       "      <td>1103.681541</td>\n",
       "      <td>794.987627</td>\n",
       "      <td>1356.506280</td>\n",
       "      <td>1292.800220</td>\n",
       "      <td>934.361006</td>\n",
       "      <td>1169.270656</td>\n",
       "      <td>539.654235</td>\n",
       "      <td>462.456929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OH</th>\n",
       "      <td>564.042214</td>\n",
       "      <td>3165.365611</td>\n",
       "      <td>1635.833406</td>\n",
       "      <td>646.430095</td>\n",
       "      <td>1978.829541</td>\n",
       "      <td>1213.558154</td>\n",
       "      <td>534.307935</td>\n",
       "      <td>398.811884</td>\n",
       "      <td>322.638727</td>\n",
       "      <td>803.665575</td>\n",
       "      <td>...</td>\n",
       "      <td>935.170396</td>\n",
       "      <td>361.703927</td>\n",
       "      <td>1106.148789</td>\n",
       "      <td>1531.464134</td>\n",
       "      <td>581.240009</td>\n",
       "      <td>285.371643</td>\n",
       "      <td>1924.059455</td>\n",
       "      <td>162.349434</td>\n",
       "      <td>474.126322</td>\n",
       "      <td>1290.453557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OK</th>\n",
       "      <td>640.487395</td>\n",
       "      <td>2993.245991</td>\n",
       "      <td>808.587480</td>\n",
       "      <td>289.663758</td>\n",
       "      <td>1227.300969</td>\n",
       "      <td>501.848828</td>\n",
       "      <td>1397.962368</td>\n",
       "      <td>1230.894938</td>\n",
       "      <td>1149.397909</td>\n",
       "      <td>1002.478681</td>\n",
       "      <td>...</td>\n",
       "      <td>627.819640</td>\n",
       "      <td>626.441095</td>\n",
       "      <td>302.635813</td>\n",
       "      <td>819.449169</td>\n",
       "      <td>1437.152921</td>\n",
       "      <td>1043.750944</td>\n",
       "      <td>1433.864389</td>\n",
       "      <td>953.729835</td>\n",
       "      <td>738.508293</td>\n",
       "      <td>741.748103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OR</th>\n",
       "      <td>1969.553573</td>\n",
       "      <td>1861.858430</td>\n",
       "      <td>819.094009</td>\n",
       "      <td>1618.568760</td>\n",
       "      <td>469.217131</td>\n",
       "      <td>848.768600</td>\n",
       "      <td>2403.194064</td>\n",
       "      <td>2334.192236</td>\n",
       "      <td>2261.590899</td>\n",
       "      <td>2347.002750</td>\n",
       "      <td>...</td>\n",
       "      <td>1008.095478</td>\n",
       "      <td>1886.007822</td>\n",
       "      <td>1438.852605</td>\n",
       "      <td>559.729373</td>\n",
       "      <td>2352.203609</td>\n",
       "      <td>2209.113500</td>\n",
       "      <td>238.255775</td>\n",
       "      <td>2089.619514</td>\n",
       "      <td>1507.941209</td>\n",
       "      <td>656.552959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PA</th>\n",
       "      <td>749.052552</td>\n",
       "      <td>3282.549377</td>\n",
       "      <td>1900.792232</td>\n",
       "      <td>898.901760</td>\n",
       "      <td>2235.216038</td>\n",
       "      <td>1473.202629</td>\n",
       "      <td>269.068737</td>\n",
       "      <td>178.392986</td>\n",
       "      <td>142.038016</td>\n",
       "      <td>884.372534</td>\n",
       "      <td>...</td>\n",
       "      <td>1164.797702</td>\n",
       "      <td>578.749744</td>\n",
       "      <td>1361.790117</td>\n",
       "      <td>1786.888669</td>\n",
       "      <td>342.389737</td>\n",
       "      <td>238.358938</td>\n",
       "      <td>2139.718971</td>\n",
       "      <td>215.426653</td>\n",
       "      <td>671.222795</td>\n",
       "      <td>1532.045519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RI</th>\n",
       "      <td>1039.351953</td>\n",
       "      <td>3423.101700</td>\n",
       "      <td>2226.999559</td>\n",
       "      <td>1224.056590</td>\n",
       "      <td>2548.926544</td>\n",
       "      <td>1792.546583</td>\n",
       "      <td>60.734872</td>\n",
       "      <td>278.934837</td>\n",
       "      <td>345.713621</td>\n",
       "      <td>1088.455837</td>\n",
       "      <td>...</td>\n",
       "      <td>1456.149058</td>\n",
       "      <td>892.392893</td>\n",
       "      <td>1687.377290</td>\n",
       "      <td>2100.404762</td>\n",
       "      <td>174.489773</td>\n",
       "      <td>483.277342</td>\n",
       "      <td>2406.163402</td>\n",
       "      <td>523.311939</td>\n",
       "      <td>951.667165</td>\n",
       "      <td>1831.386520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>351.907610</td>\n",
       "      <td>3589.822810</td>\n",
       "      <td>1757.402097</td>\n",
       "      <td>662.700819</td>\n",
       "      <td>2169.958376</td>\n",
       "      <td>1412.243072</td>\n",
       "      <td>693.848221</td>\n",
       "      <td>460.816593</td>\n",
       "      <td>406.509719</td>\n",
       "      <td>375.604762</td>\n",
       "      <td>...</td>\n",
       "      <td>1261.459371</td>\n",
       "      <td>337.393804</td>\n",
       "      <td>1085.712996</td>\n",
       "      <td>1741.674065</td>\n",
       "      <td>827.685266</td>\n",
       "      <td>273.746992</td>\n",
       "      <td>2246.192806</td>\n",
       "      <td>326.077778</td>\n",
       "      <td>883.912837</td>\n",
       "      <td>1566.739987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SD</th>\n",
       "      <td>1080.232672</td>\n",
       "      <td>2406.735722</td>\n",
       "      <td>929.347207</td>\n",
       "      <td>777.835123</td>\n",
       "      <td>1122.595133</td>\n",
       "      <td>465.631647</td>\n",
       "      <td>1399.373709</td>\n",
       "      <td>1326.755627</td>\n",
       "      <td>1255.248648</td>\n",
       "      <td>1465.634256</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>941.479038</td>\n",
       "      <td>895.766371</td>\n",
       "      <td>687.695755</td>\n",
       "      <td>1361.372160</td>\n",
       "      <td>1210.813071</td>\n",
       "      <td>992.708284</td>\n",
       "      <td>1089.068283</td>\n",
       "      <td>505.173273</td>\n",
       "      <td>380.009527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TN</th>\n",
       "      <td>213.954618</td>\n",
       "      <td>3311.320134</td>\n",
       "      <td>1434.654114</td>\n",
       "      <td>350.279840</td>\n",
       "      <td>1836.112688</td>\n",
       "      <td>1075.623411</td>\n",
       "      <td>835.099169</td>\n",
       "      <td>633.899941</td>\n",
       "      <td>554.843924</td>\n",
       "      <td>547.755178</td>\n",
       "      <td>...</td>\n",
       "      <td>941.479038</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>805.875923</td>\n",
       "      <td>1405.100415</td>\n",
       "      <td>919.172735</td>\n",
       "      <td>431.694375</td>\n",
       "      <td>1916.685215</td>\n",
       "      <td>369.394440</td>\n",
       "      <td>634.602971</td>\n",
       "      <td>1232.095157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TX</th>\n",
       "      <td>738.109503</td>\n",
       "      <td>3184.662400</td>\n",
       "      <td>741.879342</td>\n",
       "      <td>463.320872</td>\n",
       "      <td>1214.042462</td>\n",
       "      <td>626.106155</td>\n",
       "      <td>1628.123403</td>\n",
       "      <td>1438.483773</td>\n",
       "      <td>1358.393683</td>\n",
       "      <td>1029.268759</td>\n",
       "      <td>...</td>\n",
       "      <td>895.766371</td>\n",
       "      <td>805.875923</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>879.806001</td>\n",
       "      <td>1687.179627</td>\n",
       "      <td>1237.551485</td>\n",
       "      <td>1565.138538</td>\n",
       "      <td>1166.878967</td>\n",
       "      <td>1038.406904</td>\n",
       "      <td>913.524945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UT</th>\n",
       "      <td>1456.478516</td>\n",
       "      <td>2370.852192</td>\n",
       "      <td>346.924962</td>\n",
       "      <td>1102.351963</td>\n",
       "      <td>448.579322</td>\n",
       "      <td>329.477021</td>\n",
       "      <td>2041.088388</td>\n",
       "      <td>1929.599786</td>\n",
       "      <td>1851.238672</td>\n",
       "      <td>1821.673880</td>\n",
       "      <td>...</td>\n",
       "      <td>687.695755</td>\n",
       "      <td>1405.100415</td>\n",
       "      <td>879.806001</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2025.034555</td>\n",
       "      <td>1775.398776</td>\n",
       "      <td>710.697293</td>\n",
       "      <td>1664.212198</td>\n",
       "      <td>1171.165252</td>\n",
       "      <td>333.088177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VT</th>\n",
       "      <td>1090.974086</td>\n",
       "      <td>3255.821974</td>\n",
       "      <td>2177.098367</td>\n",
       "      <td>1227.472212</td>\n",
       "      <td>2471.840033</td>\n",
       "      <td>1728.582959</td>\n",
       "      <td>168.926488</td>\n",
       "      <td>380.122570</td>\n",
       "      <td>421.352518</td>\n",
       "      <td>1194.129477</td>\n",
       "      <td>...</td>\n",
       "      <td>1361.372160</td>\n",
       "      <td>919.172735</td>\n",
       "      <td>1687.179627</td>\n",
       "      <td>2025.034555</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>555.866808</td>\n",
       "      <td>2285.996878</td>\n",
       "      <td>557.620033</td>\n",
       "      <td>857.802643</td>\n",
       "      <td>1740.630911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VA</th>\n",
       "      <td>557.099628</td>\n",
       "      <td>3442.374153</td>\n",
       "      <td>1844.529976</td>\n",
       "      <td>779.859361</td>\n",
       "      <td>2218.373060</td>\n",
       "      <td>1450.089949</td>\n",
       "      <td>432.241837</td>\n",
       "      <td>208.360154</td>\n",
       "      <td>138.511640</td>\n",
       "      <td>647.107426</td>\n",
       "      <td>...</td>\n",
       "      <td>1210.813071</td>\n",
       "      <td>431.694375</td>\n",
       "      <td>1237.551485</td>\n",
       "      <td>1775.398776</td>\n",
       "      <td>555.866808</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2202.691972</td>\n",
       "      <td>123.532243</td>\n",
       "      <td>759.478352</td>\n",
       "      <td>1554.992431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WA</th>\n",
       "      <td>2024.199744</td>\n",
       "      <td>1663.916968</td>\n",
       "      <td>1013.453014</td>\n",
       "      <td>1682.484605</td>\n",
       "      <td>705.678720</td>\n",
       "      <td>946.715117</td>\n",
       "      <td>2353.497591</td>\n",
       "      <td>2308.538852</td>\n",
       "      <td>2240.431136</td>\n",
       "      <td>2408.682511</td>\n",
       "      <td>...</td>\n",
       "      <td>992.708284</td>\n",
       "      <td>1916.685215</td>\n",
       "      <td>1565.138538</td>\n",
       "      <td>710.697293</td>\n",
       "      <td>2285.996878</td>\n",
       "      <td>2202.691972</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2080.363191</td>\n",
       "      <td>1468.496690</td>\n",
       "      <td>697.646746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WV</th>\n",
       "      <td>533.636791</td>\n",
       "      <td>3324.641802</td>\n",
       "      <td>1746.217842</td>\n",
       "      <td>704.126775</td>\n",
       "      <td>2109.112445</td>\n",
       "      <td>1341.064220</td>\n",
       "      <td>465.726447</td>\n",
       "      <td>277.194377</td>\n",
       "      <td>195.690439</td>\n",
       "      <td>697.868557</td>\n",
       "      <td>...</td>\n",
       "      <td>1089.068283</td>\n",
       "      <td>369.394440</td>\n",
       "      <td>1166.878967</td>\n",
       "      <td>1664.212198</td>\n",
       "      <td>557.620033</td>\n",
       "      <td>123.532243</td>\n",
       "      <td>2080.363191</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>636.391435</td>\n",
       "      <td>1436.712678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WI</th>\n",
       "      <td>834.584831</td>\n",
       "      <td>2706.157416</td>\n",
       "      <td>1354.639634</td>\n",
       "      <td>683.768475</td>\n",
       "      <td>1615.958302</td>\n",
       "      <td>890.079849</td>\n",
       "      <td>895.511977</td>\n",
       "      <td>841.494832</td>\n",
       "      <td>776.619257</td>\n",
       "      <td>1178.544313</td>\n",
       "      <td>...</td>\n",
       "      <td>505.173273</td>\n",
       "      <td>634.602971</td>\n",
       "      <td>1038.406904</td>\n",
       "      <td>1171.165252</td>\n",
       "      <td>857.802643</td>\n",
       "      <td>759.478352</td>\n",
       "      <td>1468.496690</td>\n",
       "      <td>636.391435</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>883.216742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WY</th>\n",
       "      <td>1328.358591</td>\n",
       "      <td>2271.726388</td>\n",
       "      <td>641.113991</td>\n",
       "      <td>984.865003</td>\n",
       "      <td>746.991455</td>\n",
       "      <td>295.105456</td>\n",
       "      <td>1773.793119</td>\n",
       "      <td>1687.655863</td>\n",
       "      <td>1613.033252</td>\n",
       "      <td>1711.766174</td>\n",
       "      <td>...</td>\n",
       "      <td>380.009527</td>\n",
       "      <td>1232.095157</td>\n",
       "      <td>913.524945</td>\n",
       "      <td>333.088177</td>\n",
       "      <td>1740.630911</td>\n",
       "      <td>1554.992431</td>\n",
       "      <td>697.646746</td>\n",
       "      <td>1436.712678</td>\n",
       "      <td>883.216742</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "state           AL           AK           AZ           AR           CA  \\\n",
       "state                                                                    \n",
       "AL        0.000000  3476.952449  1433.460157   354.170490  1867.241601   \n",
       "AK     3476.952449     0.000000  2675.275492  3183.979244  2299.905352   \n",
       "AZ     1433.460157  2675.275492     0.000000  1094.736197   482.459726   \n",
       "AR      354.170490  3183.979244  1094.736197     0.000000  1516.503429   \n",
       "CA     1867.241601  2299.905352   482.459726  1516.503429     0.000000   \n",
       "CO     1131.613777  2559.799212   470.340950   777.669806   768.309708   \n",
       "CT      986.173644  3391.636928  2166.364245  1164.828467  2489.645564   \n",
       "DE      765.184413  3458.898012  2021.943897   977.437011  2376.435685   \n",
       "DC      693.655919  3418.112638  1940.833548   896.828318  2297.622941   \n",
       "FL      386.732876  3855.474872  1761.986118   728.885190  2215.862502   \n",
       "GA      197.487904  3587.490225  1628.729880   540.574287  2057.073972   \n",
       "HI     4317.927116  3027.578808  2887.977304  3982.711145  2501.929912   \n",
       "ID     1691.497630  1995.169309   712.781172  1344.585722   556.046610   \n",
       "IL      517.785012  2985.089889  1297.952561   397.259156  1642.190178   \n",
       "IN      491.517044  3081.825823  1449.149024   483.313148  1797.257985   \n",
       "IA      737.940095  2740.604918  1122.539880   498.605875  1420.104592   \n",
       "KS      759.282031  2797.737299   794.531070   412.563455  1154.487307   \n",
       "KY      339.003175  3246.227376  1490.481661   438.385146  1870.516504   \n",
       "LA      325.712907  3423.466295  1165.188914   264.851958  1623.788909   \n",
       "ME     1278.636248  3282.666178  2351.786330  1417.787735  2630.762177   \n",
       "MD      709.248189  3416.550766  1952.646134   910.859964  2307.628845   \n",
       "MA     1049.975618  3382.635159  2214.335458  1223.168628  2529.911178   \n",
       "MI      801.533036  2860.145689  1559.604169   751.684892  1839.321395   \n",
       "MN     1012.307839  2486.024624  1230.829148   791.730715  1436.052544   \n",
       "MS      165.334460  3394.038861  1271.686938   218.135844  1711.550867   \n",
       "MO      498.158442  2982.588290  1105.567097   238.775500  1475.725552   \n",
       "MT     1551.080495  1985.735915   888.052761  1224.648581   846.719073   \n",
       "NE      934.589140  2581.687315   818.040581   607.845122  1092.838666   \n",
       "NV     1719.888665  2238.483172   444.202213  1366.017651   213.785465   \n",
       "NH     1116.230173  3309.287605  2229.362037  1266.959668  2528.528974   \n",
       "NJ      846.737194  3415.165661  2064.423534  1039.673168  2405.041785   \n",
       "NM     1116.190464  2816.712563   317.276353   778.815901   773.550232   \n",
       "NY      933.247111  3233.685280  2027.463266  1064.664292  2335.951562   \n",
       "NC      467.113144  3539.958984  1826.453934   739.359452  2221.185832   \n",
       "ND     1239.531342  2237.421669  1079.407683   960.927902  1198.699388   \n",
       "OH      564.042214  3165.365611  1635.833406   646.430095  1978.829541   \n",
       "OK      640.487395  2993.245991   808.587480   289.663758  1227.300969   \n",
       "OR     1969.553573  1861.858430   819.094009  1618.568760   469.217131   \n",
       "PA      749.052552  3282.549377  1900.792232   898.901760  2235.216038   \n",
       "RI     1039.351953  3423.101700  2226.999559  1224.056590  2548.926544   \n",
       "SC      351.907610  3589.822810  1757.402097   662.700819  2169.958376   \n",
       "SD     1080.232672  2406.735722   929.347207   777.835123  1122.595133   \n",
       "TN      213.954618  3311.320134  1434.654114   350.279840  1836.112688   \n",
       "TX      738.109503  3184.662400   741.879342   463.320872  1214.042462   \n",
       "UT     1456.478516  2370.852192   346.924962  1102.351963   448.579322   \n",
       "VT     1090.974086  3255.821974  2177.098367  1227.472212  2471.840033   \n",
       "VA      557.099628  3442.374153  1844.529976   779.859361  2218.373060   \n",
       "WA     2024.199744  1663.916968  1013.453014  1682.484605   705.678720   \n",
       "WV      533.636791  3324.641802  1746.217842   704.126775  2109.112445   \n",
       "WI      834.584831  2706.157416  1354.639634   683.768475  1615.958302   \n",
       "WY     1328.358591  2271.726388   641.113991   984.865003   746.991455   \n",
       "\n",
       "state           CO           CT           DE           DC           FL  ...  \\\n",
       "state                                                                   ...   \n",
       "AL     1131.613777   986.173644   765.184413   693.655919   386.732876  ...   \n",
       "AK     2559.799212  3391.636928  3458.898012  3418.112638  3855.474872  ...   \n",
       "AZ      470.340950  2166.364245  2021.943897  1940.833548  1761.986118  ...   \n",
       "AR      777.669806  1164.828467   977.437011   896.828318   728.885190  ...   \n",
       "CA      768.309708  2489.645564  2376.435685  2297.622941  2215.862502  ...   \n",
       "CO        0.000000  1732.522617  1609.819683  1530.503752  1502.494979  ...   \n",
       "CT     1732.522617     0.000000   233.456869   293.803167  1049.676960  ...   \n",
       "DE     1609.819683   233.456869     0.000000    81.503941   817.506227  ...   \n",
       "DC     1530.503752   293.803167    81.503941     0.000000   774.071971  ...   \n",
       "FL     1502.494979  1049.676960   817.506227   774.071971     0.000000  ...   \n",
       "GA     1312.284756   855.115294   624.184114   562.872892   282.561179  ...   \n",
       "HI     3268.957841  4986.890804  4878.309844  4799.322319  4621.924269  ...   \n",
       "ID      596.479579  2107.859274  2037.266877  1964.727834  2073.129915  ...   \n",
       "IL      875.400156   868.687174   734.452339   655.432899   875.358762  ...   \n",
       "IN     1030.363031   720.330186   579.456675   500.365340   806.523630  ...   \n",
       "IA      668.354765  1069.546399   968.833895   893.675302  1115.090675  ...   \n",
       "KS      388.631627  1371.836328  1233.002602  1152.578730  1140.365941  ...   \n",
       "KY     1103.261017   727.227586   541.865565   460.621312   635.448679  ...   \n",
       "LA      941.188490  1293.179163  1080.362012  1005.209553   597.102757  ...   \n",
       "ME     1897.617808   312.344021   544.821255   597.869840  1361.924919  ...   \n",
       "MD     1540.807645   278.150994    69.340932    15.655615   788.303148  ...   \n",
       "MA     1776.223584    64.648763   297.733455   358.244674  1112.931876  ...   \n",
       "MI     1102.024218   668.928924   631.253098   573.691842  1095.946540  ...   \n",
       "MN      760.902313  1119.279849  1078.512041  1014.828905  1377.179044  ...   \n",
       "MS      988.294757  1114.506349   902.732351   827.032228   514.263107  ...   \n",
       "MO      708.545322  1068.526525   916.430642   835.415342   883.847719  ...   \n",
       "MT      593.100128  1848.883412  1799.532228  1731.368566  1937.805589  ...   \n",
       "NE      350.848539  1396.809643  1291.525486  1214.734085  1321.050531  ...   \n",
       "NV      595.282750  2293.724926  2189.392796  2111.697542  2081.517941  ...   \n",
       "NH     1783.022928   153.625410   382.575431   433.781095  1200.078396  ...   \n",
       "NJ     1641.675203   141.863557    94.016679   153.121124   911.382356  ...   \n",
       "NM      318.057728  1875.499907  1720.258122  1638.828728  1448.326174  ...   \n",
       "NY     1584.889790   170.380572   273.553581   289.681605  1060.350230  ...   \n",
       "NC     1455.868710   551.984387   319.094177   265.738886   509.764601  ...   \n",
       "ND      637.073768  1419.205892  1380.853297  1316.213954  1619.490901  ...   \n",
       "OH     1213.558154   534.307935   398.811884   322.638727   803.665575  ...   \n",
       "OK      501.848828  1397.962368  1230.894938  1149.397909  1002.478681  ...   \n",
       "OR      848.768600  2403.194064  2334.192236  2261.590899  2347.002750  ...   \n",
       "PA     1473.202629   269.068737   178.392986   142.038016   884.372534  ...   \n",
       "RI     1792.546583    60.734872   278.934837   345.713621  1088.455837  ...   \n",
       "SC     1412.243072   693.848221   460.816593   406.509719   375.604762  ...   \n",
       "SD      465.631647  1399.373709  1326.755627  1255.248648  1465.634256  ...   \n",
       "TN     1075.623411   835.099169   633.899941   554.843924   547.755178  ...   \n",
       "TX      626.106155  1628.123403  1438.483773  1358.393683  1029.268759  ...   \n",
       "UT      329.477021  2041.088388  1929.599786  1851.238672  1821.673880  ...   \n",
       "VT     1728.582959   168.926488   380.122570   421.352518  1194.129477  ...   \n",
       "VA     1450.089949   432.241837   208.360154   138.511640   647.107426  ...   \n",
       "WA      946.715117  2353.497591  2308.538852  2240.431136  2408.682511  ...   \n",
       "WV     1341.064220   465.726447   277.194377   195.690439   697.868557  ...   \n",
       "WI      890.079849   895.511977   841.494832   776.619257  1178.544313  ...   \n",
       "WY      295.105456  1773.793119  1687.655863  1613.033252  1711.766174  ...   \n",
       "\n",
       "state           SD           TN           TX           UT           VT  \\\n",
       "state                                                                    \n",
       "AL     1080.232672   213.954618   738.109503  1456.478516  1090.974086   \n",
       "AK     2406.735722  3311.320134  3184.662400  2370.852192  3255.821974   \n",
       "AZ      929.347207  1434.654114   741.879342   346.924962  2177.098367   \n",
       "AR      777.835123   350.279840   463.320872  1102.351963  1227.472212   \n",
       "CA     1122.595133  1836.112688  1214.042462   448.579322  2471.840033   \n",
       "CO      465.631647  1075.623411   626.106155   329.477021  1728.582959   \n",
       "CT     1399.373709   835.099169  1628.123403  2041.088388   168.926488   \n",
       "DE     1326.755627   633.899941  1438.483773  1929.599786   380.122570   \n",
       "DC     1255.248648   554.843924  1358.393683  1851.238672   421.352518   \n",
       "FL     1465.634256   547.755178  1029.268759  1821.673880  1194.129477   \n",
       "GA     1215.982702   277.190959   934.886444  1639.751899   979.878198   \n",
       "HI     3595.614350  4319.976591  3595.259839  2949.514364  4956.983801   \n",
       "ID      711.306742  1597.963021  1214.868205   379.831674  2060.081715   \n",
       "IL      641.337618   327.698345   819.329185  1196.043722   892.717953   \n",
       "IN      780.499507   278.396636   933.999071  1351.027030   756.868377   \n",
       "IA      376.738690   575.753001   798.840857   971.542150  1060.228195   \n",
       "KS      421.655784   687.678525   486.777487   717.901783  1386.359134   \n",
       "KY      912.350270   129.443431   901.566856  1430.959157   800.003289   \n",
       "LA     1025.324848   463.833813   434.830246  1246.067362  1382.893687   \n",
       "ME     1512.367018  1109.703559  1876.711065  2186.356918   190.940164   \n",
       "MD     1261.956713   569.547849  1372.662723  1860.980339   406.609915   \n",
       "MA     1432.261801   896.387954  1686.267485  2081.582096   132.186969   \n",
       "MI      732.506780   587.782202  1165.626396  1392.895756   632.586257   \n",
       "MN      314.812022   829.579680  1056.027035  1002.457011  1064.531238   \n",
       "MS      987.536884   286.847512   573.141474  1308.832730  1205.031300   \n",
       "MO      582.075183   378.667148   613.833535  1036.710193  1100.731594   \n",
       "MT      488.817526  1426.031818  1205.800046   544.561703  1788.332660   \n",
       "NE      201.820356   824.284325   694.290238   644.303545  1383.602492   \n",
       "NV      914.665138  1670.905667  1113.754550   265.806283  2270.067058   \n",
       "NH     1419.790486   951.409468  1728.261532  2081.347044    60.439464   \n",
       "NJ     1335.610125   702.946552  1502.604436  1956.904825   286.806370   \n",
       "NM      760.164395  1121.714023   442.665856   456.899488  1898.313393   \n",
       "NY     1236.719586   757.279305  1524.883735  1887.841059   163.046252   \n",
       "NC     1259.148040   392.001424  1182.873090  1784.524245   687.078184   \n",
       "ND      207.917723  1080.016800  1103.681541   794.987627  1356.506280   \n",
       "OH      935.170396   361.703927  1106.148789  1531.464134   581.240009   \n",
       "OK      627.819640   626.441095   302.635813   819.449169  1437.152921   \n",
       "OR     1008.095478  1886.007822  1438.852605   559.729373  2352.203609   \n",
       "PA     1164.797702   578.749744  1361.790117  1786.888669   342.389737   \n",
       "RI     1456.149058   892.392893  1687.377290  2100.404762   174.489773   \n",
       "SC     1261.459371   337.393804  1085.712996  1741.674065   827.685266   \n",
       "SD        0.000000   941.479038   895.766371   687.695755  1361.372160   \n",
       "TN      941.479038     0.000000   805.875923  1405.100415   919.172735   \n",
       "TX      895.766371   805.875923     0.000000   879.806001  1687.179627   \n",
       "UT      687.695755  1405.100415   879.806001     0.000000  2025.034555   \n",
       "VT     1361.372160   919.172735  1687.179627  2025.034555     0.000000   \n",
       "VA     1210.813071   431.694375  1237.551485  1775.398776   555.866808   \n",
       "WA      992.708284  1916.685215  1565.138538   710.697293  2285.996878   \n",
       "WV     1089.068283   369.394440  1166.878967  1664.212198   557.620033   \n",
       "WI      505.173273   634.602971  1038.406904  1171.165252   857.802643   \n",
       "WY      380.009527  1232.095157   913.524945   333.088177  1740.630911   \n",
       "\n",
       "state           VA           WA           WV           WI           WY  \n",
       "state                                                                   \n",
       "AL      557.099628  2024.199744   533.636791   834.584831  1328.358591  \n",
       "AK     3442.374153  1663.916968  3324.641802  2706.157416  2271.726388  \n",
       "AZ     1844.529976  1013.453014  1746.217842  1354.639634   641.113991  \n",
       "AR      779.859361  1682.484605   704.126775   683.768475   984.865003  \n",
       "CA     2218.373060   705.678720  2109.112445  1615.958302   746.991455  \n",
       "CO     1450.089949   946.715117  1341.064220   890.079849   295.105456  \n",
       "CT      432.241837  2353.497591   465.726447   895.511977  1773.793119  \n",
       "DE      208.360154  2308.538852   277.194377   841.494832  1687.655863  \n",
       "DC      138.511640  2240.431136   195.690439   776.619257  1613.033252  \n",
       "FL      647.107426  2408.682511   697.868557  1178.544313  1711.766174  \n",
       "GA      425.064107  2182.981663   442.947446   898.574087  1492.189858  \n",
       "HI     4716.884320  2742.560104  4609.820103  4099.915134  3216.699946  \n",
       "ID     1913.265495   350.666680  1793.404633  1212.366735   365.896330  \n",
       "IL      584.453005  1632.221530   469.131644   318.920923   971.484456  \n",
       "IN      433.361125  1773.207512   315.463470   377.810188  1121.803934  \n",
       "IA      838.770183  1368.619886   718.751044   249.140094   719.439495  \n",
       "KS     1065.696858  1269.954194   960.189633   605.983178   572.315128  \n",
       "KY      354.106432  1901.010842   266.209931   546.904628  1230.568945  \n",
       "LA      872.288710  1878.806182   829.599041   941.212612  1186.182753  \n",
       "ME      735.406769  2407.259263   746.299019  1015.208446  1892.352254  \n",
       "MD      154.142141  2246.023495   208.643693   780.966220  1620.992143  \n",
       "MA      496.728944  2376.840038   527.071793   927.211649  1808.750602  \n",
       "MI      582.263109  1689.007962   465.373866   227.359326  1110.048952  \n",
       "MN      997.109162  1235.810701   873.765375   238.690855   690.289776  \n",
       "MS      694.982871  1900.382555   650.965927   820.198472  1202.736282  \n",
       "MO      744.640206  1540.790669   641.385729   450.982171   853.532708  \n",
       "MT     1695.173788   509.074817  1572.513069   960.113212   298.102416  \n",
       "NE     1149.418182  1093.968300  1033.184808   539.307641   409.985982  \n",
       "NV     2038.670231   588.077548  1926.287261  1412.634770   536.471148  \n",
       "NH      571.286271  2346.354453   585.336970   915.673270  1798.778531  \n",
       "NJ      291.059347  2307.757624   335.772820   839.699933  1703.339969  \n",
       "NM     1537.412043  1164.454255  1443.346291  1109.348599   597.482994  \n",
       "NY      413.947628  2184.600447   399.809396   731.695022  1613.286918  \n",
       "NC      138.765278  2251.064951   223.416435   839.609240  1586.013035  \n",
       "ND     1292.800220   934.361006  1169.270656   539.654235   462.456929  \n",
       "OH      285.371643  1924.059455   162.349434   474.126322  1290.453557  \n",
       "OK     1043.750944  1433.864389   953.729835   738.508293   741.748103  \n",
       "OR     2209.113500   238.255775  2089.619514  1507.941209   656.552959  \n",
       "PA      238.358938  2139.718971   215.426653   671.222795  1532.045519  \n",
       "RI      483.277342  2406.163402   523.311939   951.667165  1831.386520  \n",
       "SC      273.746992  2246.192806   326.077778   883.912837  1566.739987  \n",
       "SD     1210.813071   992.708284  1089.068283   505.173273   380.009527  \n",
       "TN      431.694375  1916.685215   369.394440   634.602971  1232.095157  \n",
       "TX     1237.551485  1565.138538  1166.878967  1038.406904   913.524945  \n",
       "UT     1775.398776   710.697293  1664.212198  1171.165252   333.088177  \n",
       "VT      555.866808  2285.996878   557.620033   857.802643  1740.630911  \n",
       "VA        0.000000  2202.691972   123.532243   759.478352  1554.992431  \n",
       "WA     2202.691972     0.000000  2080.363191  1468.496690   697.646746  \n",
       "WV      123.532243  2080.363191     0.000000   636.391435  1436.712678  \n",
       "WI      759.478352  1468.496690   636.391435     0.000000   883.216742  \n",
       "WY     1554.992431   697.646746  1436.712678   883.216742     0.000000  \n",
       "\n",
       "[51 rows x 51 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import scipy.spatial.distance\n",
    "from geopy.distance import geodesic\n",
    "mat = scipy.spatial.distance.cdist(location_df[[\"latitude\", \"longitude\"]], location_df[[\"latitude\", \"longitude\"]], lambda u, v: geodesic(u,v).mi)\n",
    "miles_distances = pd.DataFrame(mat, index=location_df['state'])\n",
    "miles_distances.columns = location_df['state']\n",
    "#miles_distances.replace(0, np.nan,inplace=True)\n",
    "miles_distances\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "32fc2b61-32b5-465f-af7e-998ab4d3536b",
   "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</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>Closest State #1</th>\n",
       "      <th>Distance to Closest State #1</th>\n",
       "      <th>Closest State #2</th>\n",
       "      <th>Distance to Closest State #2</th>\n",
       "      <th>Closest State #3</th>\n",
       "      <th>Distance to Closest State #3</th>\n",
       "      <th>Closest State #4</th>\n",
       "      <th>Distance to Closest State #4</th>\n",
       "      <th>Closest State #5</th>\n",
       "      <th>Distance to Closest State #5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>32.7794</td>\n",
       "      <td>-86.8287</td>\n",
       "      <td>MS</td>\n",
       "      <td>165.334460</td>\n",
       "      <td>GA</td>\n",
       "      <td>197.487904</td>\n",
       "      <td>TN</td>\n",
       "      <td>213.954618</td>\n",
       "      <td>LA</td>\n",
       "      <td>325.712907</td>\n",
       "      <td>KY</td>\n",
       "      <td>339.003175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AK</td>\n",
       "      <td>64.0685</td>\n",
       "      <td>-152.2782</td>\n",
       "      <td>WA</td>\n",
       "      <td>1663.916968</td>\n",
       "      <td>OR</td>\n",
       "      <td>1861.858430</td>\n",
       "      <td>MT</td>\n",
       "      <td>1985.735915</td>\n",
       "      <td>ID</td>\n",
       "      <td>1995.169309</td>\n",
       "      <td>ND</td>\n",
       "      <td>2237.421669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZ</td>\n",
       "      <td>34.2744</td>\n",
       "      <td>-111.6602</td>\n",
       "      <td>NM</td>\n",
       "      <td>317.276353</td>\n",
       "      <td>UT</td>\n",
       "      <td>346.924962</td>\n",
       "      <td>NV</td>\n",
       "      <td>444.202213</td>\n",
       "      <td>CO</td>\n",
       "      <td>470.340950</td>\n",
       "      <td>CA</td>\n",
       "      <td>482.459726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AR</td>\n",
       "      <td>34.8938</td>\n",
       "      <td>-92.4426</td>\n",
       "      <td>MS</td>\n",
       "      <td>218.135844</td>\n",
       "      <td>MO</td>\n",
       "      <td>238.775500</td>\n",
       "      <td>LA</td>\n",
       "      <td>264.851958</td>\n",
       "      <td>OK</td>\n",
       "      <td>289.663758</td>\n",
       "      <td>TN</td>\n",
       "      <td>350.279840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA</td>\n",
       "      <td>37.1841</td>\n",
       "      <td>-119.4696</td>\n",
       "      <td>NV</td>\n",
       "      <td>213.785465</td>\n",
       "      <td>UT</td>\n",
       "      <td>448.579322</td>\n",
       "      <td>OR</td>\n",
       "      <td>469.217131</td>\n",
       "      <td>AZ</td>\n",
       "      <td>482.459726</td>\n",
       "      <td>ID</td>\n",
       "      <td>556.046610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO</td>\n",
       "      <td>38.9972</td>\n",
       "      <td>-105.5478</td>\n",
       "      <td>WY</td>\n",
       "      <td>295.105456</td>\n",
       "      <td>NM</td>\n",
       "      <td>318.057728</td>\n",
       "      <td>UT</td>\n",
       "      <td>329.477021</td>\n",
       "      <td>NE</td>\n",
       "      <td>350.848539</td>\n",
       "      <td>KS</td>\n",
       "      <td>388.631627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CT</td>\n",
       "      <td>41.6219</td>\n",
       "      <td>-72.7273</td>\n",
       "      <td>RI</td>\n",
       "      <td>60.734872</td>\n",
       "      <td>MA</td>\n",
       "      <td>64.648763</td>\n",
       "      <td>NJ</td>\n",
       "      <td>141.863557</td>\n",
       "      <td>NH</td>\n",
       "      <td>153.625410</td>\n",
       "      <td>VT</td>\n",
       "      <td>168.926488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DE</td>\n",
       "      <td>38.9896</td>\n",
       "      <td>-75.5050</td>\n",
       "      <td>MD</td>\n",
       "      <td>69.340932</td>\n",
       "      <td>DC</td>\n",
       "      <td>81.503941</td>\n",
       "      <td>NJ</td>\n",
       "      <td>94.016679</td>\n",
       "      <td>PA</td>\n",
       "      <td>178.392986</td>\n",
       "      <td>VA</td>\n",
       "      <td>208.360154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DC</td>\n",
       "      <td>38.9101</td>\n",
       "      <td>-77.0147</td>\n",
       "      <td>MD</td>\n",
       "      <td>15.655615</td>\n",
       "      <td>DE</td>\n",
       "      <td>81.503941</td>\n",
       "      <td>VA</td>\n",
       "      <td>138.511640</td>\n",
       "      <td>PA</td>\n",
       "      <td>142.038016</td>\n",
       "      <td>NJ</td>\n",
       "      <td>153.121124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FL</td>\n",
       "      <td>28.6305</td>\n",
       "      <td>-82.4497</td>\n",
       "      <td>GA</td>\n",
       "      <td>282.561179</td>\n",
       "      <td>SC</td>\n",
       "      <td>375.604762</td>\n",
       "      <td>AL</td>\n",
       "      <td>386.732876</td>\n",
       "      <td>NC</td>\n",
       "      <td>509.764601</td>\n",
       "      <td>MS</td>\n",
       "      <td>514.263107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GA</td>\n",
       "      <td>32.6415</td>\n",
       "      <td>-83.4426</td>\n",
       "      <td>SC</td>\n",
       "      <td>171.597622</td>\n",
       "      <td>AL</td>\n",
       "      <td>197.487904</td>\n",
       "      <td>TN</td>\n",
       "      <td>277.190959</td>\n",
       "      <td>FL</td>\n",
       "      <td>282.561179</td>\n",
       "      <td>NC</td>\n",
       "      <td>307.194329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>HI</td>\n",
       "      <td>20.2927</td>\n",
       "      <td>-156.3737</td>\n",
       "      <td>CA</td>\n",
       "      <td>2501.929912</td>\n",
       "      <td>OR</td>\n",
       "      <td>2623.917672</td>\n",
       "      <td>NV</td>\n",
       "      <td>2693.397214</td>\n",
       "      <td>WA</td>\n",
       "      <td>2742.560104</td>\n",
       "      <td>AZ</td>\n",
       "      <td>2887.977304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ID</td>\n",
       "      <td>44.3509</td>\n",
       "      <td>-114.6130</td>\n",
       "      <td>OR</td>\n",
       "      <td>296.926251</td>\n",
       "      <td>MT</td>\n",
       "      <td>304.667591</td>\n",
       "      <td>WA</td>\n",
       "      <td>350.666680</td>\n",
       "      <td>NV</td>\n",
       "      <td>361.876858</td>\n",
       "      <td>WY</td>\n",
       "      <td>365.896330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IL</td>\n",
       "      <td>40.0417</td>\n",
       "      <td>-89.1965</td>\n",
       "      <td>IN</td>\n",
       "      <td>155.067884</td>\n",
       "      <td>MO</td>\n",
       "      <td>210.120097</td>\n",
       "      <td>IA</td>\n",
       "      <td>264.756030</td>\n",
       "      <td>KY</td>\n",
       "      <td>272.180058</td>\n",
       "      <td>WI</td>\n",
       "      <td>318.920923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>IN</td>\n",
       "      <td>39.8942</td>\n",
       "      <td>-86.2816</td>\n",
       "      <td>IL</td>\n",
       "      <td>155.067884</td>\n",
       "      <td>KY</td>\n",
       "      <td>171.143239</td>\n",
       "      <td>OH</td>\n",
       "      <td>186.784208</td>\n",
       "      <td>TN</td>\n",
       "      <td>278.396636</td>\n",
       "      <td>MI</td>\n",
       "      <td>310.547350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IA</td>\n",
       "      <td>42.0751</td>\n",
       "      <td>-93.4960</td>\n",
       "      <td>WI</td>\n",
       "      <td>249.140094</td>\n",
       "      <td>MO</td>\n",
       "      <td>262.365363</td>\n",
       "      <td>IL</td>\n",
       "      <td>264.756030</td>\n",
       "      <td>MN</td>\n",
       "      <td>293.138445</td>\n",
       "      <td>NE</td>\n",
       "      <td>327.295833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>KS</td>\n",
       "      <td>38.4937</td>\n",
       "      <td>-98.3804</td>\n",
       "      <td>OK</td>\n",
       "      <td>206.210260</td>\n",
       "      <td>NE</td>\n",
       "      <td>223.020859</td>\n",
       "      <td>MO</td>\n",
       "      <td>321.432900</td>\n",
       "      <td>IA</td>\n",
       "      <td>357.195660</td>\n",
       "      <td>CO</td>\n",
       "      <td>388.631627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>KY</td>\n",
       "      <td>37.5347</td>\n",
       "      <td>-85.3021</td>\n",
       "      <td>TN</td>\n",
       "      <td>129.443431</td>\n",
       "      <td>IN</td>\n",
       "      <td>171.143239</td>\n",
       "      <td>OH</td>\n",
       "      <td>233.000195</td>\n",
       "      <td>WV</td>\n",
       "      <td>266.209931</td>\n",
       "      <td>IL</td>\n",
       "      <td>272.180058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>LA</td>\n",
       "      <td>31.0689</td>\n",
       "      <td>-91.9968</td>\n",
       "      <td>MS</td>\n",
       "      <td>178.706777</td>\n",
       "      <td>AR</td>\n",
       "      <td>264.851958</td>\n",
       "      <td>AL</td>\n",
       "      <td>325.712907</td>\n",
       "      <td>TX</td>\n",
       "      <td>434.830246</td>\n",
       "      <td>OK</td>\n",
       "      <td>445.020204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ME</td>\n",
       "      <td>45.3695</td>\n",
       "      <td>-69.2428</td>\n",
       "      <td>NH</td>\n",
       "      <td>164.125414</td>\n",
       "      <td>VT</td>\n",
       "      <td>190.940164</td>\n",
       "      <td>MA</td>\n",
       "      <td>250.064210</td>\n",
       "      <td>RI</td>\n",
       "      <td>280.174951</td>\n",
       "      <td>CT</td>\n",
       "      <td>312.344021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>MD</td>\n",
       "      <td>39.0550</td>\n",
       "      <td>-76.7909</td>\n",
       "      <td>DC</td>\n",
       "      <td>15.655615</td>\n",
       "      <td>DE</td>\n",
       "      <td>69.340932</td>\n",
       "      <td>PA</td>\n",
       "      <td>136.703190</td>\n",
       "      <td>NJ</td>\n",
       "      <td>137.503247</td>\n",
       "      <td>VA</td>\n",
       "      <td>154.142141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MA</td>\n",
       "      <td>42.2596</td>\n",
       "      <td>-71.8083</td>\n",
       "      <td>RI</td>\n",
       "      <td>42.306624</td>\n",
       "      <td>CT</td>\n",
       "      <td>64.648763</td>\n",
       "      <td>NH</td>\n",
       "      <td>98.757712</td>\n",
       "      <td>VT</td>\n",
       "      <td>132.186969</td>\n",
       "      <td>NY</td>\n",
       "      <td>195.545642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>MI</td>\n",
       "      <td>44.3467</td>\n",
       "      <td>-85.4102</td>\n",
       "      <td>WI</td>\n",
       "      <td>227.359326</td>\n",
       "      <td>IN</td>\n",
       "      <td>310.547350</td>\n",
       "      <td>OH</td>\n",
       "      <td>310.617856</td>\n",
       "      <td>IL</td>\n",
       "      <td>354.940934</td>\n",
       "      <td>IA</td>\n",
       "      <td>437.120554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>MN</td>\n",
       "      <td>46.2807</td>\n",
       "      <td>-94.3053</td>\n",
       "      <td>WI</td>\n",
       "      <td>238.690855</td>\n",
       "      <td>IA</td>\n",
       "      <td>293.138445</td>\n",
       "      <td>ND</td>\n",
       "      <td>302.752163</td>\n",
       "      <td>SD</td>\n",
       "      <td>314.812022</td>\n",
       "      <td>NE</td>\n",
       "      <td>426.756350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MS</td>\n",
       "      <td>32.7364</td>\n",
       "      <td>-89.6678</td>\n",
       "      <td>AL</td>\n",
       "      <td>165.334460</td>\n",
       "      <td>LA</td>\n",
       "      <td>178.706777</td>\n",
       "      <td>AR</td>\n",
       "      <td>218.135844</td>\n",
       "      <td>TN</td>\n",
       "      <td>286.847512</td>\n",
       "      <td>GA</td>\n",
       "      <td>362.761852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MO</td>\n",
       "      <td>38.3566</td>\n",
       "      <td>-92.4580</td>\n",
       "      <td>IL</td>\n",
       "      <td>210.120097</td>\n",
       "      <td>AR</td>\n",
       "      <td>238.775500</td>\n",
       "      <td>IA</td>\n",
       "      <td>262.365363</td>\n",
       "      <td>KS</td>\n",
       "      <td>321.432900</td>\n",
       "      <td>OK</td>\n",
       "      <td>337.660435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MT</td>\n",
       "      <td>47.0527</td>\n",
       "      <td>-109.6333</td>\n",
       "      <td>WY</td>\n",
       "      <td>298.102416</td>\n",
       "      <td>ID</td>\n",
       "      <td>304.667591</td>\n",
       "      <td>ND</td>\n",
       "      <td>431.827193</td>\n",
       "      <td>SD</td>\n",
       "      <td>488.817526</td>\n",
       "      <td>WA</td>\n",
       "      <td>509.074817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NE</td>\n",
       "      <td>41.5378</td>\n",
       "      <td>-99.7951</td>\n",
       "      <td>SD</td>\n",
       "      <td>201.820356</td>\n",
       "      <td>KS</td>\n",
       "      <td>223.020859</td>\n",
       "      <td>IA</td>\n",
       "      <td>327.295833</td>\n",
       "      <td>CO</td>\n",
       "      <td>350.848539</td>\n",
       "      <td>ND</td>\n",
       "      <td>409.571531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NV</td>\n",
       "      <td>39.3289</td>\n",
       "      <td>-116.6312</td>\n",
       "      <td>CA</td>\n",
       "      <td>213.785465</td>\n",
       "      <td>UT</td>\n",
       "      <td>265.806283</td>\n",
       "      <td>ID</td>\n",
       "      <td>361.876858</td>\n",
       "      <td>OR</td>\n",
       "      <td>377.160892</td>\n",
       "      <td>AZ</td>\n",
       "      <td>444.202213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>NH</td>\n",
       "      <td>43.6805</td>\n",
       "      <td>-71.5811</td>\n",
       "      <td>VT</td>\n",
       "      <td>60.439464</td>\n",
       "      <td>MA</td>\n",
       "      <td>98.757712</td>\n",
       "      <td>RI</td>\n",
       "      <td>138.354502</td>\n",
       "      <td>CT</td>\n",
       "      <td>153.625410</td>\n",
       "      <td>ME</td>\n",
       "      <td>164.125414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>NJ</td>\n",
       "      <td>40.1907</td>\n",
       "      <td>-74.6728</td>\n",
       "      <td>DE</td>\n",
       "      <td>94.016679</td>\n",
       "      <td>MD</td>\n",
       "      <td>137.503247</td>\n",
       "      <td>CT</td>\n",
       "      <td>141.863557</td>\n",
       "      <td>DC</td>\n",
       "      <td>153.121124</td>\n",
       "      <td>PA</td>\n",
       "      <td>171.297139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>NM</td>\n",
       "      <td>34.4071</td>\n",
       "      <td>-106.1126</td>\n",
       "      <td>AZ</td>\n",
       "      <td>317.276353</td>\n",
       "      <td>CO</td>\n",
       "      <td>318.057728</td>\n",
       "      <td>TX</td>\n",
       "      <td>442.665856</td>\n",
       "      <td>UT</td>\n",
       "      <td>456.899488</td>\n",
       "      <td>OK</td>\n",
       "      <td>495.445581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NY</td>\n",
       "      <td>42.9538</td>\n",
       "      <td>-75.5268</td>\n",
       "      <td>VT</td>\n",
       "      <td>163.046252</td>\n",
       "      <td>CT</td>\n",
       "      <td>170.380572</td>\n",
       "      <td>PA</td>\n",
       "      <td>185.049712</td>\n",
       "      <td>MA</td>\n",
       "      <td>195.545642</td>\n",
       "      <td>NJ</td>\n",
       "      <td>195.754096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>NC</td>\n",
       "      <td>35.5557</td>\n",
       "      <td>-79.3877</td>\n",
       "      <td>VA</td>\n",
       "      <td>138.765278</td>\n",
       "      <td>SC</td>\n",
       "      <td>141.882794</td>\n",
       "      <td>WV</td>\n",
       "      <td>223.416435</td>\n",
       "      <td>DC</td>\n",
       "      <td>265.738886</td>\n",
       "      <td>MD</td>\n",
       "      <td>280.498462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>ND</td>\n",
       "      <td>47.4501</td>\n",
       "      <td>-100.4659</td>\n",
       "      <td>SD</td>\n",
       "      <td>207.917723</td>\n",
       "      <td>MN</td>\n",
       "      <td>302.752163</td>\n",
       "      <td>NE</td>\n",
       "      <td>409.571531</td>\n",
       "      <td>MT</td>\n",
       "      <td>431.827193</td>\n",
       "      <td>WY</td>\n",
       "      <td>462.456929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>OH</td>\n",
       "      <td>40.2862</td>\n",
       "      <td>-82.7937</td>\n",
       "      <td>WV</td>\n",
       "      <td>162.349434</td>\n",
       "      <td>IN</td>\n",
       "      <td>186.784208</td>\n",
       "      <td>KY</td>\n",
       "      <td>233.000195</td>\n",
       "      <td>PA</td>\n",
       "      <td>265.846300</td>\n",
       "      <td>VA</td>\n",
       "      <td>285.371643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>OK</td>\n",
       "      <td>35.5889</td>\n",
       "      <td>-97.4943</td>\n",
       "      <td>KS</td>\n",
       "      <td>206.210260</td>\n",
       "      <td>AR</td>\n",
       "      <td>289.663758</td>\n",
       "      <td>TX</td>\n",
       "      <td>302.635813</td>\n",
       "      <td>MO</td>\n",
       "      <td>337.660435</td>\n",
       "      <td>NE</td>\n",
       "      <td>428.789212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>OR</td>\n",
       "      <td>43.9336</td>\n",
       "      <td>-120.5583</td>\n",
       "      <td>WA</td>\n",
       "      <td>238.255775</td>\n",
       "      <td>ID</td>\n",
       "      <td>296.926251</td>\n",
       "      <td>NV</td>\n",
       "      <td>377.160892</td>\n",
       "      <td>CA</td>\n",
       "      <td>469.217131</td>\n",
       "      <td>UT</td>\n",
       "      <td>559.729373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>PA</td>\n",
       "      <td>40.8781</td>\n",
       "      <td>-77.7996</td>\n",
       "      <td>MD</td>\n",
       "      <td>136.703190</td>\n",
       "      <td>DC</td>\n",
       "      <td>142.038016</td>\n",
       "      <td>NJ</td>\n",
       "      <td>171.297139</td>\n",
       "      <td>DE</td>\n",
       "      <td>178.392986</td>\n",
       "      <td>NY</td>\n",
       "      <td>185.049712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>RI</td>\n",
       "      <td>41.6762</td>\n",
       "      <td>-71.5562</td>\n",
       "      <td>MA</td>\n",
       "      <td>42.306624</td>\n",
       "      <td>CT</td>\n",
       "      <td>60.734872</td>\n",
       "      <td>NH</td>\n",
       "      <td>138.354502</td>\n",
       "      <td>VT</td>\n",
       "      <td>174.489773</td>\n",
       "      <td>NJ</td>\n",
       "      <td>192.615210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>SC</td>\n",
       "      <td>33.9169</td>\n",
       "      <td>-80.8964</td>\n",
       "      <td>NC</td>\n",
       "      <td>141.882794</td>\n",
       "      <td>GA</td>\n",
       "      <td>171.597622</td>\n",
       "      <td>VA</td>\n",
       "      <td>273.746992</td>\n",
       "      <td>WV</td>\n",
       "      <td>326.077778</td>\n",
       "      <td>TN</td>\n",
       "      <td>337.393804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>SD</td>\n",
       "      <td>44.4443</td>\n",
       "      <td>-100.2263</td>\n",
       "      <td>NE</td>\n",
       "      <td>201.820356</td>\n",
       "      <td>ND</td>\n",
       "      <td>207.917723</td>\n",
       "      <td>MN</td>\n",
       "      <td>314.812022</td>\n",
       "      <td>IA</td>\n",
       "      <td>376.738690</td>\n",
       "      <td>WY</td>\n",
       "      <td>380.009527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>TN</td>\n",
       "      <td>35.8580</td>\n",
       "      <td>-86.3505</td>\n",
       "      <td>KY</td>\n",
       "      <td>129.443431</td>\n",
       "      <td>AL</td>\n",
       "      <td>213.954618</td>\n",
       "      <td>GA</td>\n",
       "      <td>277.190959</td>\n",
       "      <td>IN</td>\n",
       "      <td>278.396636</td>\n",
       "      <td>MS</td>\n",
       "      <td>286.847512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>TX</td>\n",
       "      <td>31.4757</td>\n",
       "      <td>-99.3312</td>\n",
       "      <td>OK</td>\n",
       "      <td>302.635813</td>\n",
       "      <td>LA</td>\n",
       "      <td>434.830246</td>\n",
       "      <td>NM</td>\n",
       "      <td>442.665856</td>\n",
       "      <td>AR</td>\n",
       "      <td>463.320872</td>\n",
       "      <td>KS</td>\n",
       "      <td>486.777487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>UT</td>\n",
       "      <td>39.3055</td>\n",
       "      <td>-111.6703</td>\n",
       "      <td>NV</td>\n",
       "      <td>265.806283</td>\n",
       "      <td>CO</td>\n",
       "      <td>329.477021</td>\n",
       "      <td>WY</td>\n",
       "      <td>333.088177</td>\n",
       "      <td>AZ</td>\n",
       "      <td>346.924962</td>\n",
       "      <td>ID</td>\n",
       "      <td>379.831674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>VT</td>\n",
       "      <td>44.0687</td>\n",
       "      <td>-72.6658</td>\n",
       "      <td>NH</td>\n",
       "      <td>60.439464</td>\n",
       "      <td>MA</td>\n",
       "      <td>132.186969</td>\n",
       "      <td>NY</td>\n",
       "      <td>163.046252</td>\n",
       "      <td>CT</td>\n",
       "      <td>168.926488</td>\n",
       "      <td>RI</td>\n",
       "      <td>174.489773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>VA</td>\n",
       "      <td>37.5215</td>\n",
       "      <td>-78.8537</td>\n",
       "      <td>WV</td>\n",
       "      <td>123.532243</td>\n",
       "      <td>DC</td>\n",
       "      <td>138.511640</td>\n",
       "      <td>NC</td>\n",
       "      <td>138.765278</td>\n",
       "      <td>MD</td>\n",
       "      <td>154.142141</td>\n",
       "      <td>DE</td>\n",
       "      <td>208.360154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>WA</td>\n",
       "      <td>47.3826</td>\n",
       "      <td>-120.4472</td>\n",
       "      <td>OR</td>\n",
       "      <td>238.255775</td>\n",
       "      <td>ID</td>\n",
       "      <td>350.666680</td>\n",
       "      <td>MT</td>\n",
       "      <td>509.074817</td>\n",
       "      <td>NV</td>\n",
       "      <td>588.077548</td>\n",
       "      <td>WY</td>\n",
       "      <td>697.646746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>WV</td>\n",
       "      <td>38.6409</td>\n",
       "      <td>-80.6227</td>\n",
       "      <td>VA</td>\n",
       "      <td>123.532243</td>\n",
       "      <td>OH</td>\n",
       "      <td>162.349434</td>\n",
       "      <td>DC</td>\n",
       "      <td>195.690439</td>\n",
       "      <td>MD</td>\n",
       "      <td>208.643693</td>\n",
       "      <td>PA</td>\n",
       "      <td>215.426653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>WI</td>\n",
       "      <td>44.6243</td>\n",
       "      <td>-89.9941</td>\n",
       "      <td>MI</td>\n",
       "      <td>227.359326</td>\n",
       "      <td>MN</td>\n",
       "      <td>238.690855</td>\n",
       "      <td>IA</td>\n",
       "      <td>249.140094</td>\n",
       "      <td>IL</td>\n",
       "      <td>318.920923</td>\n",
       "      <td>IN</td>\n",
       "      <td>377.810188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>WY</td>\n",
       "      <td>42.9957</td>\n",
       "      <td>-107.5512</td>\n",
       "      <td>CO</td>\n",
       "      <td>295.105456</td>\n",
       "      <td>MT</td>\n",
       "      <td>298.102416</td>\n",
       "      <td>UT</td>\n",
       "      <td>333.088177</td>\n",
       "      <td>ID</td>\n",
       "      <td>365.896330</td>\n",
       "      <td>SD</td>\n",
       "      <td>380.009527</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   state latitude  longitude Closest State #1  Distance to Closest State #1  \\\n",
       "0     AL  32.7794   -86.8287               MS                    165.334460   \n",
       "1     AK  64.0685  -152.2782               WA                   1663.916968   \n",
       "2     AZ  34.2744  -111.6602               NM                    317.276353   \n",
       "3     AR  34.8938   -92.4426               MS                    218.135844   \n",
       "4     CA  37.1841  -119.4696               NV                    213.785465   \n",
       "5     CO  38.9972  -105.5478               WY                    295.105456   \n",
       "6     CT  41.6219   -72.7273               RI                     60.734872   \n",
       "7     DE  38.9896   -75.5050               MD                     69.340932   \n",
       "8     DC  38.9101   -77.0147               MD                     15.655615   \n",
       "9     FL  28.6305   -82.4497               GA                    282.561179   \n",
       "10    GA  32.6415   -83.4426               SC                    171.597622   \n",
       "11    HI  20.2927  -156.3737               CA                   2501.929912   \n",
       "12    ID  44.3509  -114.6130               OR                    296.926251   \n",
       "13    IL  40.0417   -89.1965               IN                    155.067884   \n",
       "14    IN  39.8942   -86.2816               IL                    155.067884   \n",
       "15    IA  42.0751   -93.4960               WI                    249.140094   \n",
       "16    KS  38.4937   -98.3804               OK                    206.210260   \n",
       "17    KY  37.5347   -85.3021               TN                    129.443431   \n",
       "18    LA  31.0689   -91.9968               MS                    178.706777   \n",
       "19    ME  45.3695   -69.2428               NH                    164.125414   \n",
       "20    MD  39.0550   -76.7909               DC                     15.655615   \n",
       "21    MA  42.2596   -71.8083               RI                     42.306624   \n",
       "22    MI  44.3467   -85.4102               WI                    227.359326   \n",
       "23    MN  46.2807   -94.3053               WI                    238.690855   \n",
       "24    MS  32.7364   -89.6678               AL                    165.334460   \n",
       "25    MO  38.3566   -92.4580               IL                    210.120097   \n",
       "26    MT  47.0527  -109.6333               WY                    298.102416   \n",
       "27    NE  41.5378   -99.7951               SD                    201.820356   \n",
       "28    NV  39.3289  -116.6312               CA                    213.785465   \n",
       "29    NH  43.6805   -71.5811               VT                     60.439464   \n",
       "30    NJ  40.1907   -74.6728               DE                     94.016679   \n",
       "31    NM  34.4071  -106.1126               AZ                    317.276353   \n",
       "32    NY  42.9538   -75.5268               VT                    163.046252   \n",
       "33    NC  35.5557   -79.3877               VA                    138.765278   \n",
       "34    ND  47.4501  -100.4659               SD                    207.917723   \n",
       "35    OH  40.2862   -82.7937               WV                    162.349434   \n",
       "36    OK  35.5889   -97.4943               KS                    206.210260   \n",
       "37    OR  43.9336  -120.5583               WA                    238.255775   \n",
       "38    PA  40.8781   -77.7996               MD                    136.703190   \n",
       "39    RI  41.6762   -71.5562               MA                     42.306624   \n",
       "40    SC  33.9169   -80.8964               NC                    141.882794   \n",
       "41    SD  44.4443  -100.2263               NE                    201.820356   \n",
       "42    TN  35.8580   -86.3505               KY                    129.443431   \n",
       "43    TX  31.4757   -99.3312               OK                    302.635813   \n",
       "44    UT  39.3055  -111.6703               NV                    265.806283   \n",
       "45    VT  44.0687   -72.6658               NH                     60.439464   \n",
       "46    VA  37.5215   -78.8537               WV                    123.532243   \n",
       "47    WA  47.3826  -120.4472               OR                    238.255775   \n",
       "48    WV  38.6409   -80.6227               VA                    123.532243   \n",
       "49    WI  44.6243   -89.9941               MI                    227.359326   \n",
       "50    WY  42.9957  -107.5512               CO                    295.105456   \n",
       "\n",
       "   Closest State #2  Distance to Closest State #2 Closest State #3  \\\n",
       "0                GA                    197.487904               TN   \n",
       "1                OR                   1861.858430               MT   \n",
       "2                UT                    346.924962               NV   \n",
       "3                MO                    238.775500               LA   \n",
       "4                UT                    448.579322               OR   \n",
       "5                NM                    318.057728               UT   \n",
       "6                MA                     64.648763               NJ   \n",
       "7                DC                     81.503941               NJ   \n",
       "8                DE                     81.503941               VA   \n",
       "9                SC                    375.604762               AL   \n",
       "10               AL                    197.487904               TN   \n",
       "11               OR                   2623.917672               NV   \n",
       "12               MT                    304.667591               WA   \n",
       "13               MO                    210.120097               IA   \n",
       "14               KY                    171.143239               OH   \n",
       "15               MO                    262.365363               IL   \n",
       "16               NE                    223.020859               MO   \n",
       "17               IN                    171.143239               OH   \n",
       "18               AR                    264.851958               AL   \n",
       "19               VT                    190.940164               MA   \n",
       "20               DE                     69.340932               PA   \n",
       "21               CT                     64.648763               NH   \n",
       "22               IN                    310.547350               OH   \n",
       "23               IA                    293.138445               ND   \n",
       "24               LA                    178.706777               AR   \n",
       "25               AR                    238.775500               IA   \n",
       "26               ID                    304.667591               ND   \n",
       "27               KS                    223.020859               IA   \n",
       "28               UT                    265.806283               ID   \n",
       "29               MA                     98.757712               RI   \n",
       "30               MD                    137.503247               CT   \n",
       "31               CO                    318.057728               TX   \n",
       "32               CT                    170.380572               PA   \n",
       "33               SC                    141.882794               WV   \n",
       "34               MN                    302.752163               NE   \n",
       "35               IN                    186.784208               KY   \n",
       "36               AR                    289.663758               TX   \n",
       "37               ID                    296.926251               NV   \n",
       "38               DC                    142.038016               NJ   \n",
       "39               CT                     60.734872               NH   \n",
       "40               GA                    171.597622               VA   \n",
       "41               ND                    207.917723               MN   \n",
       "42               AL                    213.954618               GA   \n",
       "43               LA                    434.830246               NM   \n",
       "44               CO                    329.477021               WY   \n",
       "45               MA                    132.186969               NY   \n",
       "46               DC                    138.511640               NC   \n",
       "47               ID                    350.666680               MT   \n",
       "48               OH                    162.349434               DC   \n",
       "49               MN                    238.690855               IA   \n",
       "50               MT                    298.102416               UT   \n",
       "\n",
       "    Distance to Closest State #3 Closest State #4  \\\n",
       "0                     213.954618               LA   \n",
       "1                    1985.735915               ID   \n",
       "2                     444.202213               CO   \n",
       "3                     264.851958               OK   \n",
       "4                     469.217131               AZ   \n",
       "5                     329.477021               NE   \n",
       "6                     141.863557               NH   \n",
       "7                      94.016679               PA   \n",
       "8                     138.511640               PA   \n",
       "9                     386.732876               NC   \n",
       "10                    277.190959               FL   \n",
       "11                   2693.397214               WA   \n",
       "12                    350.666680               NV   \n",
       "13                    264.756030               KY   \n",
       "14                    186.784208               TN   \n",
       "15                    264.756030               MN   \n",
       "16                    321.432900               IA   \n",
       "17                    233.000195               WV   \n",
       "18                    325.712907               TX   \n",
       "19                    250.064210               RI   \n",
       "20                    136.703190               NJ   \n",
       "21                     98.757712               VT   \n",
       "22                    310.617856               IL   \n",
       "23                    302.752163               SD   \n",
       "24                    218.135844               TN   \n",
       "25                    262.365363               KS   \n",
       "26                    431.827193               SD   \n",
       "27                    327.295833               CO   \n",
       "28                    361.876858               OR   \n",
       "29                    138.354502               CT   \n",
       "30                    141.863557               DC   \n",
       "31                    442.665856               UT   \n",
       "32                    185.049712               MA   \n",
       "33                    223.416435               DC   \n",
       "34                    409.571531               MT   \n",
       "35                    233.000195               PA   \n",
       "36                    302.635813               MO   \n",
       "37                    377.160892               CA   \n",
       "38                    171.297139               DE   \n",
       "39                    138.354502               VT   \n",
       "40                    273.746992               WV   \n",
       "41                    314.812022               IA   \n",
       "42                    277.190959               IN   \n",
       "43                    442.665856               AR   \n",
       "44                    333.088177               AZ   \n",
       "45                    163.046252               CT   \n",
       "46                    138.765278               MD   \n",
       "47                    509.074817               NV   \n",
       "48                    195.690439               MD   \n",
       "49                    249.140094               IL   \n",
       "50                    333.088177               ID   \n",
       "\n",
       "    Distance to Closest State #4 Closest State #5  \\\n",
       "0                     325.712907               KY   \n",
       "1                    1995.169309               ND   \n",
       "2                     470.340950               CA   \n",
       "3                     289.663758               TN   \n",
       "4                     482.459726               ID   \n",
       "5                     350.848539               KS   \n",
       "6                     153.625410               VT   \n",
       "7                     178.392986               VA   \n",
       "8                     142.038016               NJ   \n",
       "9                     509.764601               MS   \n",
       "10                    282.561179               NC   \n",
       "11                   2742.560104               AZ   \n",
       "12                    361.876858               WY   \n",
       "13                    272.180058               WI   \n",
       "14                    278.396636               MI   \n",
       "15                    293.138445               NE   \n",
       "16                    357.195660               CO   \n",
       "17                    266.209931               IL   \n",
       "18                    434.830246               OK   \n",
       "19                    280.174951               CT   \n",
       "20                    137.503247               VA   \n",
       "21                    132.186969               NY   \n",
       "22                    354.940934               IA   \n",
       "23                    314.812022               NE   \n",
       "24                    286.847512               GA   \n",
       "25                    321.432900               OK   \n",
       "26                    488.817526               WA   \n",
       "27                    350.848539               ND   \n",
       "28                    377.160892               AZ   \n",
       "29                    153.625410               ME   \n",
       "30                    153.121124               PA   \n",
       "31                    456.899488               OK   \n",
       "32                    195.545642               NJ   \n",
       "33                    265.738886               MD   \n",
       "34                    431.827193               WY   \n",
       "35                    265.846300               VA   \n",
       "36                    337.660435               NE   \n",
       "37                    469.217131               UT   \n",
       "38                    178.392986               NY   \n",
       "39                    174.489773               NJ   \n",
       "40                    326.077778               TN   \n",
       "41                    376.738690               WY   \n",
       "42                    278.396636               MS   \n",
       "43                    463.320872               KS   \n",
       "44                    346.924962               ID   \n",
       "45                    168.926488               RI   \n",
       "46                    154.142141               DE   \n",
       "47                    588.077548               WY   \n",
       "48                    208.643693               PA   \n",
       "49                    318.920923               IN   \n",
       "50                    365.896330               SD   \n",
       "\n",
       "    Distance to Closest State #5  \n",
       "0                     339.003175  \n",
       "1                    2237.421669  \n",
       "2                     482.459726  \n",
       "3                     350.279840  \n",
       "4                     556.046610  \n",
       "5                     388.631627  \n",
       "6                     168.926488  \n",
       "7                     208.360154  \n",
       "8                     153.121124  \n",
       "9                     514.263107  \n",
       "10                    307.194329  \n",
       "11                   2887.977304  \n",
       "12                    365.896330  \n",
       "13                    318.920923  \n",
       "14                    310.547350  \n",
       "15                    327.295833  \n",
       "16                    388.631627  \n",
       "17                    272.180058  \n",
       "18                    445.020204  \n",
       "19                    312.344021  \n",
       "20                    154.142141  \n",
       "21                    195.545642  \n",
       "22                    437.120554  \n",
       "23                    426.756350  \n",
       "24                    362.761852  \n",
       "25                    337.660435  \n",
       "26                    509.074817  \n",
       "27                    409.571531  \n",
       "28                    444.202213  \n",
       "29                    164.125414  \n",
       "30                    171.297139  \n",
       "31                    495.445581  \n",
       "32                    195.754096  \n",
       "33                    280.498462  \n",
       "34                    462.456929  \n",
       "35                    285.371643  \n",
       "36                    428.789212  \n",
       "37                    559.729373  \n",
       "38                    185.049712  \n",
       "39                    192.615210  \n",
       "40                    337.393804  \n",
       "41                    380.009527  \n",
       "42                    286.847512  \n",
       "43                    486.777487  \n",
       "44                    379.831674  \n",
       "45                    174.489773  \n",
       "46                    208.360154  \n",
       "47                    697.646746  \n",
       "48                    215.426653  \n",
       "49                    377.810188  \n",
       "50                    380.009527  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df = location_df.copy()\n",
    "new_miles_distances = miles_distances.copy()\n",
    "for i in range(5):\n",
    "    for row in new_miles_distances.values:\n",
    "        row[np.nanargmin(row)] = np.NaN\n",
    "        new_close = np.where(new_miles_distances.values == np.nanmin(new_miles_distances.values, axis=1)[:,None],new_miles_distances.columns,False)\n",
    "        #print([[x for x in i if bool(x)][0] for i in new_close])\n",
    "        test_df['Closest State #' + str(i + 1)] = [[x for x in i if bool(x)][0] for i in new_close]\n",
    "    dist_to_state = []\n",
    "    for j in np.arange(len(test_df)):\n",
    "        dist_to_state = dist_to_state + [miles_distances.loc[test_df['state'][j],test_df['Closest State #' + str(i + 1)][j]]]\n",
    "    test_df['Distance to Closest State #' + str(i + 1)] = dist_to_state\n",
    "\n",
    "#miles_distances.loc[test_df.loc[0,['state']][0],test_df.loc[0,['Closest State #1']][0]]\n",
    "test_df\n",
    "#new_miles_distances.values\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e0d95dc4-56f7-4327-9f96-fe1e17fe4f10",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5054d9cc-371b-4774-acbc-d3ea4c097f62",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}