(1)_get_lat-lng.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name_Orig</th>\n",
       "      <th>Lat_Orig</th>\n",
       "      <th>Lng_Orig</th>\n",
       "      <th>Name_Des</th>\n",
       "      <th>Lat_Des</th>\n",
       "      <th>Lng_Des</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fort Worth, TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cincinnati, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dublin, Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Paso Robles, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Palm Springs, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Paso Robles, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Monterey, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Name_Orig  Lat_Orig  Lng_Orig          Name_Des  Lat_Des  Lng_Des\n",
       "15     Columbus, OH       NaN       NaN    Fort Worth, TX      NaN      NaN\n",
       "16     Columbus, OH       NaN       NaN    Cincinnati, OH      NaN      NaN\n",
       "17     Columbus, OH       NaN       NaN   Dublin, Ireland      NaN      NaN\n",
       "18  Paso Robles, CA       NaN       NaN  Palm Springs, CA      NaN      NaN\n",
       "19  Paso Robles, CA       NaN       NaN      Monterey, CA      NaN      NaN"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from map_functions import *\n",
    "\n",
    "df = pd.read_csv('data/locations (no_lat-lng)_2017.csv')\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name_Orig</th>\n",
       "      <th>Lat_Orig</th>\n",
       "      <th>Lng_Orig</th>\n",
       "      <th>Name_Des</th>\n",
       "      <th>Lat_Des</th>\n",
       "      <th>Lng_Des</th>\n",
       "      <th>Payload_Orig</th>\n",
       "      <th>Payload_Des</th>\n",
       "      <th>Distance (nm)</th>\n",
       "      <th>Distance (mi)</th>\n",
       "      <th>Distance (km)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fort Worth, TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cincinnati, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dublin, Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Paso Robles, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Palm Springs, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Paso Robles, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Monterey, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Name_Orig  Lat_Orig  Lng_Orig          Name_Des  Lat_Des  Lng_Des  \\\n",
       "15     Columbus, OH       NaN       NaN    Fort Worth, TX      NaN      NaN   \n",
       "16     Columbus, OH       NaN       NaN    Cincinnati, OH      NaN      NaN   \n",
       "17     Columbus, OH       NaN       NaN   Dublin, Ireland      NaN      NaN   \n",
       "18  Paso Robles, CA       NaN       NaN  Palm Springs, CA      NaN      NaN   \n",
       "19  Paso Robles, CA       NaN       NaN      Monterey, CA      NaN      NaN   \n",
       "\n",
       "                                         Payload_Orig  \\\n",
       "15  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "16  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "17  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "18  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "19  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "\n",
       "                                          Payload_Des  Distance (nm)  \\\n",
       "15  https://maps.googleapis.com/maps/api/geocode/j...              0   \n",
       "16  https://maps.googleapis.com/maps/api/geocode/j...              0   \n",
       "17  https://maps.googleapis.com/maps/api/geocode/j...              0   \n",
       "18  https://maps.googleapis.com/maps/api/geocode/j...              0   \n",
       "19  https://maps.googleapis.com/maps/api/geocode/j...              0   \n",
       "\n",
       "    Distance (mi)  Distance (km)  \n",
       "15              0              0  \n",
       "16              0              0  \n",
       "17              0              0  \n",
       "18              0              0  \n",
       "19              0              0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Add columns for origin and destination payloads (for Google API) \n",
    "payload_pre = 'https://maps.googleapis.com/maps/api/geocode/json?address='\n",
    "df['Payload_Orig'] = df['Name_Orig'].str.replace(', ','+').str.replace(' ','+')\n",
    "df['Payload_Des'] = df['Name_Des'].str.replace(', ','+').str.replace(' ','+')\n",
    "df['Payload_Orig'] = payload_pre + df['Payload_Orig']\n",
    "df['Payload_Des'] = payload_pre + df['Payload_Des']\n",
    "df['Distance (nm)'] = 0\n",
    "df['Distance (mi)'] = 0\n",
    "df['Distance (km)'] = 0\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I round the decimal degrees and distance measurements for readability. Pick what to round decimal degrees to based on the accuracy required. For our purposes, 3 decimal places should suffice. \n",
    "\n",
    "This table [from Wikipedia](https://en.wikipedia.org/wiki/Decimal_degrees#Precision) gives the precision of decimal degrees. \n",
    "\n",
    "| Decimal Degrees\t| Identifiable\t| Distance At Equator | \n",
    "|------|------|------|\n",
    "|1\t| country or large region\t| 111.32 km |\n",
    "|0.1\t| large city or district\t| 11.132 km |\n",
    "|0.01\t| town or village\t| 1.1132 km |\n",
    "|0.001\t| neighborhood, street\t| 111.32 m |\n",
    "|0.0001\t| individual street, land parcel\t| 11.132 m |\n",
    "|0.00001\t| individual trees\t| 1.1132 m |\n",
    "|0.000001\t| individual humans\t| 111.32 mm |\n",
    "|0.0000001\t| practical limit of commercial surveying\t| 11.132 mm |\n",
    "|0.00000001\t| specialized surveying (e.g. tectonic plate mapping)\t| 1.1132 mm |"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Completed...\n",
      "\tSKIPPING: Columbus, OH to Hotel de Rome, Berlin, Germany\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Columbus+OH\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Hotel+de+Rome+Berlin+Germany\n",
      "\tSKIPPING: Berlin, Germany to Cathedrale Notre-Dame de Paris, Paris, France\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Berlin+Germany\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Cathedrale+Notre-Dame+de+Paris+Paris+France\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/mkudija/anaconda/lib/python3.5/site-packages/ipykernel/__main__.py:15: DeprecationWarning: \n",
      ".ix is deprecated. Please use\n",
      ".loc for label based indexing or\n",
      ".iloc for positional indexing\n",
      "\n",
      "See the documentation here:\n",
      "http://pandas.pydata.org/pandas-docs/stable/indexing.html#deprecate_ix\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " - 42.3 nm Paris, France to Cathedrale Notre-Dame de Chartres\n",
      "\tSKIPPING: Paris, France to Columbus, OH\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Paris+France\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Columbus+OH\n",
      " - 1795.9 nm Columbus, OH to Paso Robles, CA\n",
      "\tSKIPPING: Paso Robles, CA to Dallas, TX\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Paso+Robles+CA\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Dallas+TX\n",
      " - 793.8 nm Dallas, TX to Columbus, OH\n",
      " - 927.3 nm Columbus, OH to Austin, TX\n",
      " - 1691.7 nm Columbus, OH to Reno, NV\n",
      "\tSKIPPING: Reno, NV to Incline Village, NV\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Reno+NV\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Incline+Village+NV\n",
      " - 30.1 nm Columbus, OH to Utica, OH\n",
      " - 129.9 nm Oakland, CA to Yosemite National Park, California\n",
      "\tSKIPPING: Columbus, OH to South Bend, IN\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Columbus+OH\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=South+Bend+IN\n",
      " - 424.1 nm Columbus, OH to Ossining, NY\n",
      " - 70.3 nm Columbus, OH to Wooster, OH\n",
      " - 816.3 nm Columbus, OH to Fort Worth, TX\n",
      " - 87.1 nm Columbus, OH to Cincinnati, OH\n",
      " - 3110.3 nm Columbus, OH to Dublin, Ireland\n",
      "\tSKIPPING: Paso Robles, CA to Palm Springs, CA\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Paso+Robles+CA\n",
      "\thttps://maps.googleapis.com/maps/api/geocode/json?address=Palm+Springs+CA\n",
      " - 83.5 nm Paso Robles, CA to Monterey, CA\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name_Orig</th>\n",
       "      <th>Lat_Orig</th>\n",
       "      <th>Lng_Orig</th>\n",
       "      <th>Name_Des</th>\n",
       "      <th>Lat_Des</th>\n",
       "      <th>Lng_Des</th>\n",
       "      <th>Payload_Orig</th>\n",
       "      <th>Payload_Des</th>\n",
       "      <th>Distance (nm)</th>\n",
       "      <th>Distance (mi)</th>\n",
       "      <th>Distance (km)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>39.961</td>\n",
       "      <td>-82.999</td>\n",
       "      <td>Fort Worth, TX</td>\n",
       "      <td>32.755</td>\n",
       "      <td>-97.331</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>816.3</td>\n",
       "      <td>939.3</td>\n",
       "      <td>1511.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>39.961</td>\n",
       "      <td>-82.999</td>\n",
       "      <td>Cincinnati, OH</td>\n",
       "      <td>39.103</td>\n",
       "      <td>-84.512</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>87.1</td>\n",
       "      <td>100.2</td>\n",
       "      <td>161.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>39.961</td>\n",
       "      <td>-82.999</td>\n",
       "      <td>Dublin, Ireland</td>\n",
       "      <td>53.350</td>\n",
       "      <td>-6.260</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>3110.3</td>\n",
       "      <td>3579.3</td>\n",
       "      <td>5760.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Paso Robles, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Palm Springs, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Paso Robles, CA</td>\n",
       "      <td>35.637</td>\n",
       "      <td>-120.655</td>\n",
       "      <td>Monterey, CA</td>\n",
       "      <td>36.600</td>\n",
       "      <td>-121.895</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>https://maps.googleapis.com/maps/api/geocode/j...</td>\n",
       "      <td>83.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>154.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Name_Orig  Lat_Orig  Lng_Orig          Name_Des  Lat_Des  Lng_Des  \\\n",
       "15     Columbus, OH    39.961   -82.999    Fort Worth, TX   32.755  -97.331   \n",
       "16     Columbus, OH    39.961   -82.999    Cincinnati, OH   39.103  -84.512   \n",
       "17     Columbus, OH    39.961   -82.999   Dublin, Ireland   53.350   -6.260   \n",
       "18  Paso Robles, CA       NaN       NaN  Palm Springs, CA      NaN      NaN   \n",
       "19  Paso Robles, CA    35.637  -120.655      Monterey, CA   36.600 -121.895   \n",
       "\n",
       "                                         Payload_Orig  \\\n",
       "15  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "16  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "17  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "18  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "19  https://maps.googleapis.com/maps/api/geocode/j...   \n",
       "\n",
       "                                          Payload_Des  Distance (nm)  \\\n",
       "15  https://maps.googleapis.com/maps/api/geocode/j...          816.3   \n",
       "16  https://maps.googleapis.com/maps/api/geocode/j...           87.1   \n",
       "17  https://maps.googleapis.com/maps/api/geocode/j...         3110.3   \n",
       "18  https://maps.googleapis.com/maps/api/geocode/j...            0.0   \n",
       "19  https://maps.googleapis.com/maps/api/geocode/j...           83.5   \n",
       "\n",
       "    Distance (mi)  Distance (km)  \n",
       "15          939.3         1511.7  \n",
       "16          100.2          161.2  \n",
       "17         3579.3         5760.3  \n",
       "18            0.0            0.0  \n",
       "19           96.0          154.6  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find latitude and longitude of each location, and distance between\n",
    "round_coord = 3\n",
    "round_dist = 1\n",
    "\n",
    "print('Completed...')\n",
    "for row in range(0,df.shape[0]):\n",
    "    try: \n",
    "        # Read payloads to pass to Google API\n",
    "        payload_orig = df.iloc[row,6]\n",
    "        payload_des = df.iloc[row,7]\n",
    "        \n",
    "        # Request and write latitude and longitude\n",
    "        lat_orig, lng_orig = get_lat_lng(payload_orig)\n",
    "        lat_des, lng_des = get_lat_lng(payload_des)\n",
    "        df.ix[row,'Lat_Orig'] = round(lat_orig,round_coord)\n",
    "        df.ix[row,'Lng_Orig'] = round(lng_orig,round_coord)\n",
    "        df.ix[row,'Lat_Des'] = round(lat_des,round_coord)\n",
    "        df.ix[row,'Lng_Des'] = round(lng_des,round_coord)\n",
    "        \n",
    "        # Calculate and write distance\n",
    "        nm, mi, km = get_distance(lat_orig, lng_orig, lat_des, lng_des)\n",
    "        df.ix[row,'Distance (nm)']  = round(nm,round_dist)\n",
    "        df.ix[row,'Distance (mi)']  = round(mi,round_dist)\n",
    "        df.ix[row,'Distance (km)'] = round(km,round_dist)\n",
    "        \n",
    "        print(' - '+ str(round(nm,round_dist))+' nm '+df.iloc[row,0]+' to '+df.iloc[row,3])\n",
    "    \n",
    "    except:\n",
    "        print('\\tSKIPPING: '+df.iloc[row,0]+' to '+df.iloc[row,3])\n",
    "        print('\\t'+payload_orig)\n",
    "        print('\\t'+payload_des)\n",
    "\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Save df to csv\n",
    "header = ['Name_Orig','Lat_Orig','Lng_Orig','Name_Des','Lat_Des','Lng_Des',\n",
    "          'Distance (nm)','Distance (mi)','Distance (km)']\n",
    "df.to_csv('data/locations.csv', columns=header, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [Root]",
   "language": "python",
   "name": "Python [Root]"
  },
  "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.5.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}