RQ3-reprint-viz.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import networkx as nx\n",
    "from ast import literal_eval\n",
    "import plotly.graph_objects as go\n",
    "from tqdm import tqdm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "path='/Users/mstudio/Library/CloudStorage/Box-Box/coolie/token/'\n",
    "df=pd.read_csv(path+'reprint.csv', converters={'pair_state1':literal_eval, 'pair_state2':literal_eval, 'pair_text1':literal_eval, 'pair_text2':literal_eval})\n",
    "original=pd.read_csv(path+'coolie-token-lemma.csv', converters={'state':literal_eval, 'sent':literal_eval, 'city':literal_eval, 'lemma':literal_eval})\n",
    "state_df=pd.read_csv('us-state-capitals.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(96115, 9)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['state1']=df['pair_state1'].str[0]\n",
    "df['state2']=df['pair_state2'].str[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>no_reuse</th>\n",
       "      <th>pair_index1</th>\n",
       "      <th>pair_index2</th>\n",
       "      <th>pair_date1</th>\n",
       "      <th>pair_date2</th>\n",
       "      <th>pair_text1</th>\n",
       "      <th>pair_text2</th>\n",
       "      <th>pair_state1</th>\n",
       "      <th>pair_state2</th>\n",
       "      <th>state1</th>\n",
       "      <th>state2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>72742</td>\n",
       "      <td>18910826</td>\n",
       "      <td>18910826</td>\n",
       "      <td>[tho, steamer, namchow, sail, port, chinese, c...</td>\n",
       "      <td>[bteamer, namchow, sail, port, chinese, coolie...</td>\n",
       "      <td>[New York]</td>\n",
       "      <td>[New York]</td>\n",
       "      <td>New York</td>\n",
       "      <td>New York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>31542</td>\n",
       "      <td>18841025</td>\n",
       "      <td>18841029</td>\n",
       "      <td>[chinese, general, send, soldier, disguise, co...</td>\n",
       "      <td>[chinese, general, send, soldier, disguise, co...</td>\n",
       "      <td>[Montana]</td>\n",
       "      <td>[South Dakota]</td>\n",
       "      <td>Montana</td>\n",
       "      <td>South Dakota</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   no_reuse  pair_index1  pair_index2  pair_date1  pair_date2  \\\n",
       "0         3            1        72742    18910826    18910826   \n",
       "1         3            6        31542    18841025    18841029   \n",
       "\n",
       "                                          pair_text1  \\\n",
       "0  [tho, steamer, namchow, sail, port, chinese, c...   \n",
       "1  [chinese, general, send, soldier, disguise, co...   \n",
       "\n",
       "                                          pair_text2 pair_state1  \\\n",
       "0  [bteamer, namchow, sail, port, chinese, coolie...  [New York]   \n",
       "1  [chinese, general, send, soldier, disguise, co...   [Montana]   \n",
       "\n",
       "      pair_state2    state1        state2  \n",
       "0      [New York]  New York      New York  \n",
       "1  [South Dakota]   Montana  South Dakota  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "interim=pd.merge(df, state_df, left_on='state1', right_on='name')\n",
    "final=pd.merge(interim, state_df, left_on='state2', right_on='name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "final=final[['state1', 'state2', 'latitude_x', 'longitude_x', 'latitude_y', 'longitude_y']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>state1</th>\n",
       "      <th>state2</th>\n",
       "      <th>latitude_x</th>\n",
       "      <th>longitude_x</th>\n",
       "      <th>latitude_y</th>\n",
       "      <th>longitude_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>New York</td>\n",
       "      <td>New York</td>\n",
       "      <td>42.652843</td>\n",
       "      <td>-73.757874</td>\n",
       "      <td>42.652843</td>\n",
       "      <td>-73.757874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>New York</td>\n",
       "      <td>New York</td>\n",
       "      <td>42.652843</td>\n",
       "      <td>-73.757874</td>\n",
       "      <td>42.652843</td>\n",
       "      <td>-73.757874</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     state1    state2  latitude_x  longitude_x  latitude_y  longitude_y\n",
       "0  New York  New York   42.652843   -73.757874   42.652843   -73.757874\n",
       "1  New York  New York   42.652843   -73.757874   42.652843   -73.757874"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "final.drop(final[final['state1']==final['state2']].index, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(72802, 6)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "viz_count=final.groupby(['state1', 'state2', 'latitude_x', 'longitude_x', 'latitude_y', 'longitude_y']).size().reset_index(name='count')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>state1</th>\n",
       "      <th>state2</th>\n",
       "      <th>latitude_x</th>\n",
       "      <th>longitude_x</th>\n",
       "      <th>latitude_y</th>\n",
       "      <th>longitude_y</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>58.301598</td>\n",
       "      <td>-134.420212</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>33.448143</td>\n",
       "      <td>-112.096962</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>34.746613</td>\n",
       "      <td>-92.288986</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>California</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>38.576668</td>\n",
       "      <td>-121.493629</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>39.739227</td>\n",
       "      <td>-104.984856</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>41.764046</td>\n",
       "      <td>-72.682198</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Delaware</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>39.157307</td>\n",
       "      <td>-75.519722</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Florida</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>30.438118</td>\n",
       "      <td>-84.281296</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>33.749027</td>\n",
       "      <td>-84.388229</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Hawaii</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>21.307442</td>\n",
       "      <td>-157.857376</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>43.617775</td>\n",
       "      <td>-116.199722</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>39.798363</td>\n",
       "      <td>-89.654961</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Indiana</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>39.768623</td>\n",
       "      <td>-86.162643</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>41.591087</td>\n",
       "      <td>-93.603729</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Kansas</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>39.048191</td>\n",
       "      <td>-95.677956</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Kentucky</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>38.186722</td>\n",
       "      <td>-84.875374</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Louisiana</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>30.457069</td>\n",
       "      <td>-91.187393</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Maine</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>44.307167</td>\n",
       "      <td>-69.781693</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Maryland</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>38.978764</td>\n",
       "      <td>-76.490936</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>42.358162</td>\n",
       "      <td>-71.063698</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>42.733635</td>\n",
       "      <td>-84.555328</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>44.955097</td>\n",
       "      <td>-93.102211</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Mississippi</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>32.303848</td>\n",
       "      <td>-90.182106</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>38.579201</td>\n",
       "      <td>-92.172935</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Montana</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>46.585709</td>\n",
       "      <td>-112.018417</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>40.808075</td>\n",
       "      <td>-96.699654</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Nevada</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>39.163914</td>\n",
       "      <td>-119.766121</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>40.220596</td>\n",
       "      <td>-74.769913</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>35.682240</td>\n",
       "      <td>-105.939728</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>New York</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>42.652843</td>\n",
       "      <td>-73.757874</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>North Carolina</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>35.780430</td>\n",
       "      <td>-78.639099</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>North Dakota</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>46.820850</td>\n",
       "      <td>-100.783318</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>39.961346</td>\n",
       "      <td>-82.999069</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>35.492207</td>\n",
       "      <td>-97.503342</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>44.938461</td>\n",
       "      <td>-123.030403</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>40.264378</td>\n",
       "      <td>-76.883598</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>41.830914</td>\n",
       "      <td>-71.414963</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>34.000343</td>\n",
       "      <td>-81.033211</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>44.367031</td>\n",
       "      <td>-100.346405</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>36.165810</td>\n",
       "      <td>-86.784241</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Texas</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>30.274670</td>\n",
       "      <td>-97.740349</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Utah</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>40.777477</td>\n",
       "      <td>-111.888237</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Vermont</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>44.262436</td>\n",
       "      <td>-72.580536</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>37.538857</td>\n",
       "      <td>-77.433640</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Washington</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>47.035805</td>\n",
       "      <td>-122.905014</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>West Virginia</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>38.336246</td>\n",
       "      <td>-81.612328</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>43.074684</td>\n",
       "      <td>-89.384445</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>41.140259</td>\n",
       "      <td>-104.820236</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     state1          state2  latitude_x  longitude_x  latitude_y  longitude_y  \\\n",
       "0   Alabama          Alaska   32.377716   -86.300568   58.301598  -134.420212   \n",
       "1   Alabama         Arizona   32.377716   -86.300568   33.448143  -112.096962   \n",
       "2   Alabama        Arkansas   32.377716   -86.300568   34.746613   -92.288986   \n",
       "3   Alabama      California   32.377716   -86.300568   38.576668  -121.493629   \n",
       "4   Alabama        Colorado   32.377716   -86.300568   39.739227  -104.984856   \n",
       "5   Alabama     Connecticut   32.377716   -86.300568   41.764046   -72.682198   \n",
       "6   Alabama        Delaware   32.377716   -86.300568   39.157307   -75.519722   \n",
       "7   Alabama         Florida   32.377716   -86.300568   30.438118   -84.281296   \n",
       "8   Alabama         Georgia   32.377716   -86.300568   33.749027   -84.388229   \n",
       "9   Alabama          Hawaii   32.377716   -86.300568   21.307442  -157.857376   \n",
       "10  Alabama           Idaho   32.377716   -86.300568   43.617775  -116.199722   \n",
       "11  Alabama        Illinois   32.377716   -86.300568   39.798363   -89.654961   \n",
       "12  Alabama         Indiana   32.377716   -86.300568   39.768623   -86.162643   \n",
       "13  Alabama            Iowa   32.377716   -86.300568   41.591087   -93.603729   \n",
       "14  Alabama          Kansas   32.377716   -86.300568   39.048191   -95.677956   \n",
       "15  Alabama        Kentucky   32.377716   -86.300568   38.186722   -84.875374   \n",
       "16  Alabama       Louisiana   32.377716   -86.300568   30.457069   -91.187393   \n",
       "17  Alabama           Maine   32.377716   -86.300568   44.307167   -69.781693   \n",
       "18  Alabama        Maryland   32.377716   -86.300568   38.978764   -76.490936   \n",
       "19  Alabama   Massachusetts   32.377716   -86.300568   42.358162   -71.063698   \n",
       "20  Alabama        Michigan   32.377716   -86.300568   42.733635   -84.555328   \n",
       "21  Alabama       Minnesota   32.377716   -86.300568   44.955097   -93.102211   \n",
       "22  Alabama     Mississippi   32.377716   -86.300568   32.303848   -90.182106   \n",
       "23  Alabama        Missouri   32.377716   -86.300568   38.579201   -92.172935   \n",
       "24  Alabama         Montana   32.377716   -86.300568   46.585709  -112.018417   \n",
       "25  Alabama        Nebraska   32.377716   -86.300568   40.808075   -96.699654   \n",
       "26  Alabama          Nevada   32.377716   -86.300568   39.163914  -119.766121   \n",
       "27  Alabama      New Jersey   32.377716   -86.300568   40.220596   -74.769913   \n",
       "28  Alabama      New Mexico   32.377716   -86.300568   35.682240  -105.939728   \n",
       "29  Alabama        New York   32.377716   -86.300568   42.652843   -73.757874   \n",
       "30  Alabama  North Carolina   32.377716   -86.300568   35.780430   -78.639099   \n",
       "31  Alabama    North Dakota   32.377716   -86.300568   46.820850  -100.783318   \n",
       "32  Alabama            Ohio   32.377716   -86.300568   39.961346   -82.999069   \n",
       "33  Alabama        Oklahoma   32.377716   -86.300568   35.492207   -97.503342   \n",
       "34  Alabama          Oregon   32.377716   -86.300568   44.938461  -123.030403   \n",
       "35  Alabama    Pennsylvania   32.377716   -86.300568   40.264378   -76.883598   \n",
       "36  Alabama    Rhode Island   32.377716   -86.300568   41.830914   -71.414963   \n",
       "37  Alabama  South Carolina   32.377716   -86.300568   34.000343   -81.033211   \n",
       "38  Alabama    South Dakota   32.377716   -86.300568   44.367031  -100.346405   \n",
       "39  Alabama       Tennessee   32.377716   -86.300568   36.165810   -86.784241   \n",
       "40  Alabama           Texas   32.377716   -86.300568   30.274670   -97.740349   \n",
       "41  Alabama            Utah   32.377716   -86.300568   40.777477  -111.888237   \n",
       "42  Alabama         Vermont   32.377716   -86.300568   44.262436   -72.580536   \n",
       "43  Alabama        Virginia   32.377716   -86.300568   37.538857   -77.433640   \n",
       "44  Alabama      Washington   32.377716   -86.300568   47.035805  -122.905014   \n",
       "45  Alabama   West Virginia   32.377716   -86.300568   38.336246   -81.612328   \n",
       "46  Alabama       Wisconsin   32.377716   -86.300568   43.074684   -89.384445   \n",
       "47  Alabama         Wyoming   32.377716   -86.300568   41.140259  -104.820236   \n",
       "\n",
       "    count  \n",
       "0       4  \n",
       "1      28  \n",
       "2       9  \n",
       "3      50  \n",
       "4      36  \n",
       "5      24  \n",
       "6       5  \n",
       "7      11  \n",
       "8      24  \n",
       "9      14  \n",
       "10     42  \n",
       "11     19  \n",
       "12     28  \n",
       "13     23  \n",
       "14     58  \n",
       "15     13  \n",
       "16     17  \n",
       "17     28  \n",
       "18      9  \n",
       "19      1  \n",
       "20     14  \n",
       "21     61  \n",
       "22     22  \n",
       "23     30  \n",
       "24     25  \n",
       "25     47  \n",
       "26     10  \n",
       "27     20  \n",
       "28     37  \n",
       "29     30  \n",
       "30     47  \n",
       "31     38  \n",
       "32     15  \n",
       "33      3  \n",
       "34     17  \n",
       "35     11  \n",
       "36      5  \n",
       "37     21  \n",
       "38     56  \n",
       "39     11  \n",
       "40     17  \n",
       "41     26  \n",
       "42     10  \n",
       "43     12  \n",
       "44     22  \n",
       "45     13  \n",
       "46     55  \n",
       "47     17  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "viz_count[viz_count['state1']=='Alabama']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>state1</th>\n",
       "      <th>state2</th>\n",
       "      <th>latitude_x</th>\n",
       "      <th>longitude_x</th>\n",
       "      <th>latitude_y</th>\n",
       "      <th>longitude_y</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>58.301598</td>\n",
       "      <td>-134.420212</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>33.448143</td>\n",
       "      <td>-112.096962</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>34.746613</td>\n",
       "      <td>-92.288986</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>California</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>38.576668</td>\n",
       "      <td>-121.493629</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>39.739227</td>\n",
       "      <td>-104.984856</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>41.764046</td>\n",
       "      <td>-72.682198</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>39.157307</td>\n",
       "      <td>-75.519722</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>Florida</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>30.438118</td>\n",
       "      <td>-84.281296</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>33.749027</td>\n",
       "      <td>-84.388229</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>21.307442</td>\n",
       "      <td>-157.857376</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>43.617775</td>\n",
       "      <td>-116.199722</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>39.798363</td>\n",
       "      <td>-89.654961</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>39.768623</td>\n",
       "      <td>-86.162643</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>41.591087</td>\n",
       "      <td>-93.603729</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>39.048191</td>\n",
       "      <td>-95.677956</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>38.186722</td>\n",
       "      <td>-84.875374</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>30.457069</td>\n",
       "      <td>-91.187393</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>Maine</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>44.307167</td>\n",
       "      <td>-69.781693</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>38.978764</td>\n",
       "      <td>-76.490936</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>42.358162</td>\n",
       "      <td>-71.063698</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>42.733635</td>\n",
       "      <td>-84.555328</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>44.955097</td>\n",
       "      <td>-93.102211</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>32.303848</td>\n",
       "      <td>-90.182106</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1117</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>38.579201</td>\n",
       "      <td>-92.172935</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1165</th>\n",
       "      <td>Montana</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>46.585709</td>\n",
       "      <td>-112.018417</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1213</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>40.808075</td>\n",
       "      <td>-96.699654</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1261</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>39.163914</td>\n",
       "      <td>-119.766121</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1308</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>40.220596</td>\n",
       "      <td>-74.769913</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1355</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>35.682240</td>\n",
       "      <td>-105.939728</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1402</th>\n",
       "      <td>New York</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>42.652843</td>\n",
       "      <td>-73.757874</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1450</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>35.780430</td>\n",
       "      <td>-78.639099</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1498</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>46.820850</td>\n",
       "      <td>-100.783318</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1545</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>39.961346</td>\n",
       "      <td>-82.999069</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1593</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>35.492207</td>\n",
       "      <td>-97.503342</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1640</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>44.938461</td>\n",
       "      <td>-123.030403</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1687</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>40.264378</td>\n",
       "      <td>-76.883598</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1733</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>41.830914</td>\n",
       "      <td>-71.414963</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1777</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>34.000343</td>\n",
       "      <td>-81.033211</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1825</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>44.367031</td>\n",
       "      <td>-100.346405</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1872</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>36.165810</td>\n",
       "      <td>-86.784241</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1920</th>\n",
       "      <td>Texas</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>30.274670</td>\n",
       "      <td>-97.740349</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1967</th>\n",
       "      <td>Utah</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>40.777477</td>\n",
       "      <td>-111.888237</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>44.262436</td>\n",
       "      <td>-72.580536</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2061</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>37.538857</td>\n",
       "      <td>-77.433640</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2109</th>\n",
       "      <td>Washington</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>47.035805</td>\n",
       "      <td>-122.905014</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2156</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>38.336246</td>\n",
       "      <td>-81.612328</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2204</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>43.074684</td>\n",
       "      <td>-89.384445</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2251</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>41.140259</td>\n",
       "      <td>-104.820236</td>\n",
       "      <td>32.377716</td>\n",
       "      <td>-86.300568</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              state1   state2  latitude_x  longitude_x  latitude_y  \\\n",
       "48            Alaska  Alabama   58.301598  -134.420212   32.377716   \n",
       "89           Arizona  Alabama   33.448143  -112.096962   32.377716   \n",
       "136         Arkansas  Alabama   34.746613   -92.288986   32.377716   \n",
       "184       California  Alabama   38.576668  -121.493629   32.377716   \n",
       "232         Colorado  Alabama   39.739227  -104.984856   32.377716   \n",
       "279      Connecticut  Alabama   41.764046   -72.682198   32.377716   \n",
       "327         Delaware  Alabama   39.157307   -75.519722   32.377716   \n",
       "374          Florida  Alabama   30.438118   -84.281296   32.377716   \n",
       "420          Georgia  Alabama   33.749027   -84.388229   32.377716   \n",
       "468           Hawaii  Alabama   21.307442  -157.857376   32.377716   \n",
       "516            Idaho  Alabama   43.617775  -116.199722   32.377716   \n",
       "563         Illinois  Alabama   39.798363   -89.654961   32.377716   \n",
       "611          Indiana  Alabama   39.768623   -86.162643   32.377716   \n",
       "659             Iowa  Alabama   41.591087   -93.603729   32.377716   \n",
       "707           Kansas  Alabama   39.048191   -95.677956   32.377716   \n",
       "755         Kentucky  Alabama   38.186722   -84.875374   32.377716   \n",
       "802        Louisiana  Alabama   30.457069   -91.187393   32.377716   \n",
       "849            Maine  Alabama   44.307167   -69.781693   32.377716   \n",
       "897         Maryland  Alabama   38.978764   -76.490936   32.377716   \n",
       "945    Massachusetts  Alabama   42.358162   -71.063698   32.377716   \n",
       "974         Michigan  Alabama   42.733635   -84.555328   32.377716   \n",
       "1021       Minnesota  Alabama   44.955097   -93.102211   32.377716   \n",
       "1069     Mississippi  Alabama   32.303848   -90.182106   32.377716   \n",
       "1117        Missouri  Alabama   38.579201   -92.172935   32.377716   \n",
       "1165         Montana  Alabama   46.585709  -112.018417   32.377716   \n",
       "1213        Nebraska  Alabama   40.808075   -96.699654   32.377716   \n",
       "1261          Nevada  Alabama   39.163914  -119.766121   32.377716   \n",
       "1308      New Jersey  Alabama   40.220596   -74.769913   32.377716   \n",
       "1355      New Mexico  Alabama   35.682240  -105.939728   32.377716   \n",
       "1402        New York  Alabama   42.652843   -73.757874   32.377716   \n",
       "1450  North Carolina  Alabama   35.780430   -78.639099   32.377716   \n",
       "1498    North Dakota  Alabama   46.820850  -100.783318   32.377716   \n",
       "1545            Ohio  Alabama   39.961346   -82.999069   32.377716   \n",
       "1593        Oklahoma  Alabama   35.492207   -97.503342   32.377716   \n",
       "1640          Oregon  Alabama   44.938461  -123.030403   32.377716   \n",
       "1687    Pennsylvania  Alabama   40.264378   -76.883598   32.377716   \n",
       "1733    Rhode Island  Alabama   41.830914   -71.414963   32.377716   \n",
       "1777  South Carolina  Alabama   34.000343   -81.033211   32.377716   \n",
       "1825    South Dakota  Alabama   44.367031  -100.346405   32.377716   \n",
       "1872       Tennessee  Alabama   36.165810   -86.784241   32.377716   \n",
       "1920           Texas  Alabama   30.274670   -97.740349   32.377716   \n",
       "1967            Utah  Alabama   40.777477  -111.888237   32.377716   \n",
       "2014         Vermont  Alabama   44.262436   -72.580536   32.377716   \n",
       "2061        Virginia  Alabama   37.538857   -77.433640   32.377716   \n",
       "2109      Washington  Alabama   47.035805  -122.905014   32.377716   \n",
       "2156   West Virginia  Alabama   38.336246   -81.612328   32.377716   \n",
       "2204       Wisconsin  Alabama   43.074684   -89.384445   32.377716   \n",
       "2251         Wyoming  Alabama   41.140259  -104.820236   32.377716   \n",
       "\n",
       "      longitude_y  count  \n",
       "48     -86.300568      2  \n",
       "89     -86.300568     16  \n",
       "136    -86.300568      8  \n",
       "184    -86.300568     46  \n",
       "232    -86.300568     30  \n",
       "279    -86.300568     27  \n",
       "327    -86.300568      2  \n",
       "374    -86.300568      4  \n",
       "420    -86.300568     23  \n",
       "468    -86.300568     15  \n",
       "516    -86.300568     21  \n",
       "563    -86.300568     19  \n",
       "611    -86.300568     27  \n",
       "659    -86.300568     35  \n",
       "707    -86.300568     31  \n",
       "755    -86.300568     15  \n",
       "802    -86.300568     23  \n",
       "849    -86.300568     15  \n",
       "897    -86.300568      5  \n",
       "945    -86.300568      1  \n",
       "974    -86.300568     14  \n",
       "1021   -86.300568     38  \n",
       "1069   -86.300568     27  \n",
       "1117   -86.300568     16  \n",
       "1165   -86.300568     16  \n",
       "1213   -86.300568     37  \n",
       "1261   -86.300568     11  \n",
       "1308   -86.300568     14  \n",
       "1355   -86.300568     19  \n",
       "1402   -86.300568     27  \n",
       "1450   -86.300568     22  \n",
       "1498   -86.300568     24  \n",
       "1545   -86.300568      7  \n",
       "1593   -86.300568     10  \n",
       "1640   -86.300568     19  \n",
       "1687   -86.300568     13  \n",
       "1733   -86.300568      7  \n",
       "1777   -86.300568     28  \n",
       "1825   -86.300568     40  \n",
       "1872   -86.300568      7  \n",
       "1920   -86.300568      9  \n",
       "1967   -86.300568     15  \n",
       "2014   -86.300568     10  \n",
       "2061   -86.300568     16  \n",
       "2109   -86.300568     21  \n",
       "2156   -86.300568      3  \n",
       "2204   -86.300568     40  \n",
       "2251   -86.300568      2  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "viz_count[viz_count['state2']=='Alabama']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>start_lat</th>\n",
       "      <th>start_lon</th>\n",
       "      <th>end_lat</th>\n",
       "      <th>end_lon</th>\n",
       "      <th>airline</th>\n",
       "      <th>airport1</th>\n",
       "      <th>airport2</th>\n",
       "      <th>cnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32.895951</td>\n",
       "      <td>-97.037200</td>\n",
       "      <td>35.040222</td>\n",
       "      <td>-106.609194</td>\n",
       "      <td>AA</td>\n",
       "      <td>DFW</td>\n",
       "      <td>ABQ</td>\n",
       "      <td>444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41.979595</td>\n",
       "      <td>-87.904464</td>\n",
       "      <td>30.194533</td>\n",
       "      <td>-97.669872</td>\n",
       "      <td>AA</td>\n",
       "      <td>ORD</td>\n",
       "      <td>AUS</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>32.895951</td>\n",
       "      <td>-97.037200</td>\n",
       "      <td>41.938874</td>\n",
       "      <td>-72.683228</td>\n",
       "      <td>AA</td>\n",
       "      <td>DFW</td>\n",
       "      <td>BDL</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>18.439417</td>\n",
       "      <td>-66.001833</td>\n",
       "      <td>41.938874</td>\n",
       "      <td>-72.683228</td>\n",
       "      <td>AA</td>\n",
       "      <td>SJU</td>\n",
       "      <td>BDL</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32.895951</td>\n",
       "      <td>-97.037200</td>\n",
       "      <td>33.562943</td>\n",
       "      <td>-86.753550</td>\n",
       "      <td>AA</td>\n",
       "      <td>DFW</td>\n",
       "      <td>BHM</td>\n",
       "      <td>168</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   start_lat  start_lon    end_lat     end_lon airline airport1 airport2  cnt\n",
       "0  32.895951 -97.037200  35.040222 -106.609194      AA      DFW      ABQ  444\n",
       "1  41.979595 -87.904464  30.194533  -97.669872      AA      ORD      AUS  166\n",
       "2  32.895951 -97.037200  41.938874  -72.683228      AA      DFW      BDL  162\n",
       "3  18.439417 -66.001833  41.938874  -72.683228      AA      SJU      BDL   56\n",
       "4  32.895951 -97.037200  33.562943  -86.753550      AA      DFW      BHM  168"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_airports = pd.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/2011_february_us_airport_traffic.csv')\n",
    "df_airports.head()\n",
    "\n",
    "df_flight_paths = pd.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/2011_february_aa_flight_paths.csv')\n",
    "df_flight_paths.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>iata</th>\n",
       "      <th>airport</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>long</th>\n",
       "      <th>cnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ORD</td>\n",
       "      <td>Chicago O'Hare International</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>USA</td>\n",
       "      <td>41.979595</td>\n",
       "      <td>-87.904464</td>\n",
       "      <td>25129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ATL</td>\n",
       "      <td>William B Hartsfield-Atlanta Intl</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>USA</td>\n",
       "      <td>33.640444</td>\n",
       "      <td>-84.426944</td>\n",
       "      <td>21925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DFW</td>\n",
       "      <td>Dallas-Fort Worth International</td>\n",
       "      <td>Dallas-Fort Worth</td>\n",
       "      <td>TX</td>\n",
       "      <td>USA</td>\n",
       "      <td>32.895951</td>\n",
       "      <td>-97.037200</td>\n",
       "      <td>20662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PHX</td>\n",
       "      <td>Phoenix Sky Harbor International</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>AZ</td>\n",
       "      <td>USA</td>\n",
       "      <td>33.434167</td>\n",
       "      <td>-112.008056</td>\n",
       "      <td>17290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver Intl</td>\n",
       "      <td>Denver</td>\n",
       "      <td>CO</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.858408</td>\n",
       "      <td>-104.667002</td>\n",
       "      <td>13781</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  iata                            airport               city state country  \\\n",
       "0  ORD       Chicago O'Hare International            Chicago    IL     USA   \n",
       "1  ATL  William B Hartsfield-Atlanta Intl            Atlanta    GA     USA   \n",
       "2  DFW    Dallas-Fort Worth International  Dallas-Fort Worth    TX     USA   \n",
       "3  PHX   Phoenix Sky Harbor International            Phoenix    AZ     USA   \n",
       "4  DEN                        Denver Intl             Denver    CO     USA   \n",
       "\n",
       "         lat        long    cnt  \n",
       "0  41.979595  -87.904464  25129  \n",
       "1  33.640444  -84.426944  21925  \n",
       "2  32.895951  -97.037200  20662  \n",
       "3  33.434167 -112.008056  17290  \n",
       "4  39.858408 -104.667002  13781  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_airports.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>start_lat</th>\n",
       "      <th>start_lon</th>\n",
       "      <th>end_lat</th>\n",
       "      <th>end_lon</th>\n",
       "      <th>airline</th>\n",
       "      <th>airport1</th>\n",
       "      <th>airport2</th>\n",
       "      <th>cnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32.895951</td>\n",
       "      <td>-97.037200</td>\n",
       "      <td>35.040222</td>\n",
       "      <td>-106.609194</td>\n",
       "      <td>AA</td>\n",
       "      <td>DFW</td>\n",
       "      <td>ABQ</td>\n",
       "      <td>444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41.979595</td>\n",
       "      <td>-87.904464</td>\n",
       "      <td>30.194533</td>\n",
       "      <td>-97.669872</td>\n",
       "      <td>AA</td>\n",
       "      <td>ORD</td>\n",
       "      <td>AUS</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>32.895951</td>\n",
       "      <td>-97.037200</td>\n",
       "      <td>41.938874</td>\n",
       "      <td>-72.683228</td>\n",
       "      <td>AA</td>\n",
       "      <td>DFW</td>\n",
       "      <td>BDL</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>18.439417</td>\n",
       "      <td>-66.001833</td>\n",
       "      <td>41.938874</td>\n",
       "      <td>-72.683228</td>\n",
       "      <td>AA</td>\n",
       "      <td>SJU</td>\n",
       "      <td>BDL</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32.895951</td>\n",
       "      <td>-97.037200</td>\n",
       "      <td>33.562943</td>\n",
       "      <td>-86.753550</td>\n",
       "      <td>AA</td>\n",
       "      <td>DFW</td>\n",
       "      <td>BHM</td>\n",
       "      <td>168</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   start_lat  start_lon    end_lat     end_lon airline airport1 airport2  cnt\n",
       "0  32.895951 -97.037200  35.040222 -106.609194      AA      DFW      ABQ  444\n",
       "1  41.979595 -87.904464  30.194533  -97.669872      AA      ORD      AUS  166\n",
       "2  32.895951 -97.037200  41.938874  -72.683228      AA      DFW      BDL  162\n",
       "3  18.439417 -66.001833  41.938874  -72.683228      AA      SJU      BDL   56\n",
       "4  32.895951 -97.037200  33.562943  -86.753550      AA      DFW      BHM  168"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_flight_paths.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "\nImage export using the \"kaleido\" engine requires the kaleido package,\nwhich can be installed using pip:\n    $ pip install -U kaleido\n",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "Cell \u001b[0;32mIn[17], line 52\u001b[0m\n\u001b[1;32m     25\u001b[0m     fig\u001b[38;5;241m.\u001b[39madd_trace(\n\u001b[1;32m     26\u001b[0m         go\u001b[38;5;241m.\u001b[39mScattergeo(\n\u001b[1;32m     27\u001b[0m             locationmode \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mUSA-states\u001b[39m\u001b[38;5;124m'\u001b[39m,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m     34\u001b[0m         )\n\u001b[1;32m     35\u001b[0m     )\n\u001b[1;32m     37\u001b[0m fig\u001b[38;5;241m.\u001b[39mupdate_layout(\n\u001b[1;32m     38\u001b[0m     \u001b[38;5;66;03m# title_text = 'Feb. 2011 American Airline flight paths<br>(Hover for airport names)',\u001b[39;00m\n\u001b[1;32m     39\u001b[0m     showlegend \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mFalse\u001b[39;00m,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m     49\u001b[0m     margin\u001b[38;5;241m=\u001b[39m\u001b[38;5;28mdict\u001b[39m(l\u001b[38;5;241m=\u001b[39m\u001b[38;5;241m0\u001b[39m, r\u001b[38;5;241m=\u001b[39m\u001b[38;5;241m0\u001b[39m, t\u001b[38;5;241m=\u001b[39m\u001b[38;5;241m0\u001b[39m, b\u001b[38;5;241m=\u001b[39m\u001b[38;5;241m0\u001b[39m), \n\u001b[1;32m     50\u001b[0m )\n\u001b[0;32m---> 52\u001b[0m \u001b[43mfig\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mwrite_image\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43meacl2023_latex/figure/reprintviz1.pdf\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mengine\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mkaleido\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m)\u001b[49m\n\u001b[1;32m     53\u001b[0m fig\u001b[38;5;241m.\u001b[39mshow()\n",
      "File \u001b[0;32m~/miniconda3/envs/py3.10/lib/python3.10/site-packages/plotly/basedatatypes.py:3829\u001b[0m, in \u001b[0;36mBaseFigure.write_image\u001b[0;34m(self, *args, **kwargs)\u001b[0m\n\u001b[1;32m   3769\u001b[0m \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[1;32m   3770\u001b[0m \u001b[38;5;124;03mConvert a figure to a static image and write it to a file or writeable\u001b[39;00m\n\u001b[1;32m   3771\u001b[0m \u001b[38;5;124;03mobject\u001b[39;00m\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   3825\u001b[0m \u001b[38;5;124;03mNone\u001b[39;00m\n\u001b[1;32m   3826\u001b[0m \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[1;32m   3827\u001b[0m \u001b[38;5;28;01mimport\u001b[39;00m \u001b[38;5;21;01mplotly\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mio\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m \u001b[38;5;21;01mpio\u001b[39;00m\n\u001b[0;32m-> 3829\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mpio\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mwrite_image\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/py3.10/lib/python3.10/site-packages/plotly/io/_kaleido.py:267\u001b[0m, in \u001b[0;36mwrite_image\u001b[0;34m(fig, file, format, scale, width, height, validate, engine)\u001b[0m\n\u001b[1;32m    251\u001b[0m             \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m(\n\u001b[1;32m    252\u001b[0m                 \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[1;32m    253\u001b[0m \u001b[38;5;124;03mCannot infer image type from output path '{file}'.\u001b[39;00m\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m    261\u001b[0m                 )\n\u001b[1;32m    262\u001b[0m             )\n\u001b[1;32m    264\u001b[0m     \u001b[38;5;66;03m# Request image\u001b[39;00m\n\u001b[1;32m    265\u001b[0m     \u001b[38;5;66;03m# -------------\u001b[39;00m\n\u001b[1;32m    266\u001b[0m     \u001b[38;5;66;03m# Do this first so we don't create a file if image conversion fails\u001b[39;00m\n\u001b[0;32m--> 267\u001b[0m     img_data \u001b[38;5;241m=\u001b[39m \u001b[43mto_image\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m    268\u001b[0m \u001b[43m        \u001b[49m\u001b[43mfig\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    269\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;28;43mformat\u001b[39;49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mformat\u001b[39;49m\u001b[43m,\u001b[49m\n\u001b[1;32m    270\u001b[0m \u001b[43m        \u001b[49m\u001b[43mscale\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mscale\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    271\u001b[0m \u001b[43m        \u001b[49m\u001b[43mwidth\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mwidth\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    272\u001b[0m \u001b[43m        \u001b[49m\u001b[43mheight\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mheight\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    273\u001b[0m \u001b[43m        \u001b[49m\u001b[43mvalidate\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mvalidate\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    274\u001b[0m \u001b[43m        \u001b[49m\u001b[43mengine\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    275\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    277\u001b[0m     \u001b[38;5;66;03m# Open file\u001b[39;00m\n\u001b[1;32m    278\u001b[0m     \u001b[38;5;66;03m# ---------\u001b[39;00m\n\u001b[1;32m    279\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m path \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m    280\u001b[0m         \u001b[38;5;66;03m# We previously failed to make sense of `file` as a pathlib object.\u001b[39;00m\n\u001b[1;32m    281\u001b[0m         \u001b[38;5;66;03m# Attempt to write to `file` as an open file descriptor.\u001b[39;00m\n",
      "File \u001b[0;32m~/miniconda3/envs/py3.10/lib/python3.10/site-packages/plotly/io/_kaleido.py:133\u001b[0m, in \u001b[0;36mto_image\u001b[0;34m(fig, format, width, height, scale, validate, engine)\u001b[0m\n\u001b[1;32m    131\u001b[0m     \u001b[38;5;66;03m# Raise informative error message if Kaleido is not installed\u001b[39;00m\n\u001b[1;32m    132\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m scope \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[0;32m--> 133\u001b[0m         \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m(\n\u001b[1;32m    134\u001b[0m             \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[1;32m    135\u001b[0m \u001b[38;5;124;03mImage export using the \"kaleido\" engine requires the kaleido package,\u001b[39;00m\n\u001b[1;32m    136\u001b[0m \u001b[38;5;124;03mwhich can be installed using pip:\u001b[39;00m\n\u001b[1;32m    137\u001b[0m \u001b[38;5;124;03m    $ pip install -U kaleido\u001b[39;00m\n\u001b[1;32m    138\u001b[0m \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[1;32m    139\u001b[0m         )\n\u001b[1;32m    141\u001b[0m     \u001b[38;5;66;03m# Validate figure\u001b[39;00m\n\u001b[1;32m    142\u001b[0m     \u001b[38;5;66;03m# ---------------\u001b[39;00m\n\u001b[1;32m    143\u001b[0m     fig_dict \u001b[38;5;241m=\u001b[39m validate_coerce_fig_to_dict(fig, validate)\n",
      "\u001b[0;31mValueError\u001b[0m: \nImage export using the \"kaleido\" engine requires the kaleido package,\nwhich can be installed using pip:\n    $ pip install -U kaleido\n"
     ]
    }
   ],
   "source": [
    "import plotly.graph_objects as go\n",
    "import pandas as pd\n",
    "\n",
    "\n",
    "fig = go.Figure()\n",
    "\n",
    "fig.add_trace(go.Scattergeo(\n",
    "    locationmode = 'USA-states',\n",
    "    lon = viz_count['longitude_x'],\n",
    "    lat = viz_count['latitude_x'],\n",
    "    hoverinfo = 'text',\n",
    "    text = viz_count['state1'],\n",
    "    mode = 'markers',\n",
    "    marker = dict(\n",
    "        size = 5,\n",
    "        color = 'rgb(255, 255, 255)',\n",
    "        line = dict(\n",
    "            width = 0.5,\n",
    "            color = 'rgba(255, 255, 255, 255)'\n",
    "        )\n",
    "    )))\n",
    "\n",
    "flight_paths = []\n",
    "for i in range(len(viz_count)):\n",
    "    fig.add_trace(\n",
    "        go.Scattergeo(\n",
    "            locationmode = 'USA-states',\n",
    "            lon = [viz_count['longitude_x'][i], viz_count['longitude_y'][i]],\n",
    "            lat = [viz_count['latitude_x'][i], viz_count['latitude_y'][i]],\n",
    "            mode = 'lines',\n",
    "            line = dict(width = 0.0001, color = 'red'),\n",
    "            # opacity=0.01,\n",
    "            opacity = float(viz_count['count'][i]) / float(viz_count['count'].max()),\n",
    "        )\n",
    "    )\n",
    "\n",
    "fig.update_layout(\n",
    "    # title_text = 'Feb. 2011 American Airline flight paths<br>(Hover for airport names)',\n",
    "    showlegend = False,\n",
    "    geo = dict(\n",
    "        center=dict(lon=-100, lat=40),\n",
    "        scope = 'north america',\n",
    "        projection_type = 'azimuthal equal area',\n",
    "        showland = True,\n",
    "        landcolor = 'rgb(83, 83, 83)',\n",
    "        countrycolor = 'rgb(83, 83, 83)',\n",
    "    ),\n",
    "    autosize=False,  # Disable autosizing\n",
    "    margin=dict(l=0, r=0, t=0, b=0), \n",
    ")\n",
    "\n",
    "fig.write_image(\"eacl2023_latex/figure/reprintviz1.pdf\", engine='kaleido')\n",
    "fig.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "G=nx.from_pandas_edgelist(viz_count, 'state1', 'state2', ['count'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(G.nodes())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "nx.degree_centrality(G)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from networkx.algorithms import community\n",
    "nx.average_clustering(G)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.groupby('pair_index1').count()['no_reuse'].sort_values(ascending=False)[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[df['pair_index1']==39].head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[df['pair_index1']==2272].head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[df['pair_index1']==4197].head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "original"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "G.edges['Alabama', 'Alaska']['count']"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "py3.11",
   "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.10.9"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}