GeoNames.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "toc": true
   },
   "source": [
    "<h1>Table of Contents<span class=\"tocSkip\"></span></h1>\n",
    "<div class=\"toc\"><ul class=\"toc-item\"></ul></div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
<<<<<<< Updated upstream
     "end_time": "2021-01-14T21:35:54.781109Z",
     "start_time": "2021-01-14T21:35:54.254417Z"
=======
     "end_time": "2021-01-20T22:37:08.815521Z",
     "start_time": "2021-01-20T22:37:08.190876Z"
>>>>>>> Stashed changes
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:01:41.817729Z",
     "start_time": "2021-01-14T22:01:14.972170Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/myfriendscallmej/anaconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3057: DtypeWarning: Columns (8) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "GeoNames = pd.read_csv('allCountries.txt', sep='\\t',header=None,\n",
    "                       usecols=[0,1,2,4,5,8]\n",
    "#                        nrows=100, \n",
    "              )\n",
    "GeoNames.columns = ['geonameid',\n",
    "                    'name',\n",
    "                    'asciiname',\n",
    "#                     'alternatenames',\n",
    "                    'latitude','longitude',\n",
    "#                     'feature class','feature code',\n",
    "                    'country code', \n",
    "#                     'cc2',\n",
    "#                     'admin1 code','admin2 code','admin3 code','admin4 code',\n",
    "#                     'population','elevation','dem','timezone','modification date'\n",
    "                   ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:01:41.881553Z",
     "start_time": "2021-01-14T22:01:41.855252Z"
    }
   },
   "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>geonameid</th>\n",
       "      <th>name</th>\n",
       "      <th>asciiname</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>country code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2986043</td>\n",
       "      <td>Pic de Font Blanca</td>\n",
       "      <td>Pic de Font Blanca</td>\n",
       "      <td>42.64991</td>\n",
       "      <td>1.53335</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2994701</td>\n",
       "      <td>Roc Mélé</td>\n",
       "      <td>Roc Mele</td>\n",
       "      <td>42.58765</td>\n",
       "      <td>1.74028</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3007683</td>\n",
       "      <td>Pic des Langounelles</td>\n",
       "      <td>Pic des Langounelles</td>\n",
       "      <td>42.61203</td>\n",
       "      <td>1.47364</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3017832</td>\n",
       "      <td>Pic de les Abelletes</td>\n",
       "      <td>Pic de les Abelletes</td>\n",
       "      <td>42.52535</td>\n",
       "      <td>1.73343</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3017833</td>\n",
       "      <td>Estany de les Abelletes</td>\n",
       "      <td>Estany de les Abelletes</td>\n",
       "      <td>42.52915</td>\n",
       "      <td>1.73362</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3023203</td>\n",
       "      <td>Port Vieux de la Coume d’Ose</td>\n",
       "      <td>Port Vieux de la Coume d'Ose</td>\n",
       "      <td>42.62568</td>\n",
       "      <td>1.61823</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3029315</td>\n",
       "      <td>Port de la Cabanette</td>\n",
       "      <td>Port de la Cabanette</td>\n",
       "      <td>42.60000</td>\n",
       "      <td>1.73333</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3034945</td>\n",
       "      <td>Port Dret</td>\n",
       "      <td>Port Dret</td>\n",
       "      <td>42.60172</td>\n",
       "      <td>1.45562</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3038814</td>\n",
       "      <td>Costa de Xurius</td>\n",
       "      <td>Costa de Xurius</td>\n",
       "      <td>42.50692</td>\n",
       "      <td>1.47569</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3038815</td>\n",
       "      <td>Font de la Xona</td>\n",
       "      <td>Font de la Xona</td>\n",
       "      <td>42.55003</td>\n",
       "      <td>1.44986</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3038816</td>\n",
       "      <td>Xixerella</td>\n",
       "      <td>Xixerella</td>\n",
       "      <td>42.55327</td>\n",
       "      <td>1.48736</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3038818</td>\n",
       "      <td>Riu Xic</td>\n",
       "      <td>Riu Xic</td>\n",
       "      <td>42.57165</td>\n",
       "      <td>1.67554</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3038819</td>\n",
       "      <td>Pas del Xic</td>\n",
       "      <td>Pas del Xic</td>\n",
       "      <td>42.49766</td>\n",
       "      <td>1.57597</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3038820</td>\n",
       "      <td>Roc del Xeig</td>\n",
       "      <td>Roc del Xeig</td>\n",
       "      <td>42.56068</td>\n",
       "      <td>1.48980</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3038821</td>\n",
       "      <td>Collada del Xeig</td>\n",
       "      <td>Collada del Xeig</td>\n",
       "      <td>42.57512</td>\n",
       "      <td>1.49009</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3038822</td>\n",
       "      <td>Fonts Vives</td>\n",
       "      <td>Fonts Vives</td>\n",
       "      <td>42.49829</td>\n",
       "      <td>1.56428</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3038823</td>\n",
       "      <td>Roc de Vista</td>\n",
       "      <td>Roc de Vista</td>\n",
       "      <td>42.49922</td>\n",
       "      <td>1.48118</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3038824</td>\n",
       "      <td>Obaga de Vista</td>\n",
       "      <td>Obaga de Vista</td>\n",
       "      <td>42.47935</td>\n",
       "      <td>1.44621</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>3038825</td>\n",
       "      <td>Coll de Vista</td>\n",
       "      <td>Coll de Vista</td>\n",
       "      <td>42.47611</td>\n",
       "      <td>1.60578</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3038826</td>\n",
       "      <td>Coll de Vista</td>\n",
       "      <td>Coll de Vista</td>\n",
       "      <td>42.47552</td>\n",
       "      <td>1.44173</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3038827</td>\n",
       "      <td>Visanseny</td>\n",
       "      <td>Visanseny</td>\n",
       "      <td>42.57488</td>\n",
       "      <td>1.61616</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>3038828</td>\n",
       "      <td>Roc de la Vinya</td>\n",
       "      <td>Roc de la Vinya</td>\n",
       "      <td>42.52776</td>\n",
       "      <td>1.56446</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3038829</td>\n",
       "      <td>Canal de la Vinya</td>\n",
       "      <td>Canal de la Vinya</td>\n",
       "      <td>42.52232</td>\n",
       "      <td>1.52319</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3038830</td>\n",
       "      <td>Bosc de Villar</td>\n",
       "      <td>Bosc de Villar</td>\n",
       "      <td>42.60135</td>\n",
       "      <td>1.54340</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>3038831</td>\n",
       "      <td>Torrent de Vila</td>\n",
       "      <td>Torrent de Vila</td>\n",
       "      <td>42.53414</td>\n",
       "      <td>1.56678</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3038832</td>\n",
       "      <td>Vila</td>\n",
       "      <td>Vila</td>\n",
       "      <td>42.53176</td>\n",
       "      <td>1.56654</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3038833</td>\n",
       "      <td>Basers de Vicenç</td>\n",
       "      <td>Basers de Vicenc</td>\n",
       "      <td>42.47669</td>\n",
       "      <td>1.48290</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3038834</td>\n",
       "      <td>Pla de Viàs</td>\n",
       "      <td>Pla de Vias</td>\n",
       "      <td>42.59001</td>\n",
       "      <td>1.65996</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>3038835</td>\n",
       "      <td>Vial del Cardaire</td>\n",
       "      <td>Vial del Cardaire</td>\n",
       "      <td>42.56372</td>\n",
       "      <td>1.50503</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3038836</td>\n",
       "      <td>Font del Vi</td>\n",
       "      <td>Font del Vi</td>\n",
       "      <td>42.52342</td>\n",
       "      <td>1.47698</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063174</th>\n",
       "      <td>12199561</td>\n",
       "      <td>Shisōnohoshi Basin</td>\n",
       "      <td>Shisonohoshi Basin</td>\n",
       "      <td>18.08246</td>\n",
       "      <td>135.55482</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063175</th>\n",
       "      <td>12199562</td>\n",
       "      <td>Shittaka Seamount</td>\n",
       "      <td>Shittaka Seamount</td>\n",
       "      <td>22.18170</td>\n",
       "      <td>156.67134</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063176</th>\n",
       "      <td>12199563</td>\n",
       "      <td>Soeboshi Escarpment</td>\n",
       "      <td>Soeboshi Escarpment</td>\n",
       "      <td>17.28697</td>\n",
       "      <td>134.97571</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063177</th>\n",
       "      <td>12199564</td>\n",
       "      <td>South Ritchie Trough</td>\n",
       "      <td>South Ritchie Trough</td>\n",
       "      <td>-39.59948</td>\n",
       "      <td>178.26528</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063178</th>\n",
       "      <td>12199565</td>\n",
       "      <td>Suzugamo Seamount</td>\n",
       "      <td>Suzugamo Seamount</td>\n",
       "      <td>21.65932</td>\n",
       "      <td>149.39013</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063179</th>\n",
       "      <td>12199567</td>\n",
       "      <td>Tanakadate Seamounts</td>\n",
       "      <td>Tanakadate Seamounts</td>\n",
       "      <td>23.77892</td>\n",
       "      <td>158.22712</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063180</th>\n",
       "      <td>12199574</td>\n",
       "      <td>Tianlong Seamounts</td>\n",
       "      <td>Tianlong Seamounts</td>\n",
       "      <td>5.07587</td>\n",
       "      <td>61.94515</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063181</th>\n",
       "      <td>12199575</td>\n",
       "      <td>Tomoza Seamount</td>\n",
       "      <td>Tomoza Seamount</td>\n",
       "      <td>15.23393</td>\n",
       "      <td>133.13439</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063182</th>\n",
       "      <td>12199576</td>\n",
       "      <td>Tsukamoto Guyot</td>\n",
       "      <td>Tsukamoto Guyot</td>\n",
       "      <td>20.10000</td>\n",
       "      <td>151.66921</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063183</th>\n",
       "      <td>12199577</td>\n",
       "      <td>Uek Ridge</td>\n",
       "      <td>Uek Ridge</td>\n",
       "      <td>12.32578</td>\n",
       "      <td>134.87377</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063184</th>\n",
       "      <td>12199578</td>\n",
       "      <td>Ulerratel Ridge</td>\n",
       "      <td>Ulerratel Ridge</td>\n",
       "      <td>12.28053</td>\n",
       "      <td>134.73337</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063185</th>\n",
       "      <td>12199579</td>\n",
       "      <td>Uljin Valley</td>\n",
       "      <td>Uljin Valley</td>\n",
       "      <td>36.99567</td>\n",
       "      <td>129.95806</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063186</th>\n",
       "      <td>12199580</td>\n",
       "      <td>Umiushi Spur</td>\n",
       "      <td>Umiushi Spur</td>\n",
       "      <td>21.02651</td>\n",
       "      <td>150.24312</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063187</th>\n",
       "      <td>12199581</td>\n",
       "      <td>Usagiza Ridge</td>\n",
       "      <td>Usagiza Ridge</td>\n",
       "      <td>14.87846</td>\n",
       "      <td>132.52095</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063188</th>\n",
       "      <td>12199582</td>\n",
       "      <td>Utashiro Guyot</td>\n",
       "      <td>Utashiro Guyot</td>\n",
       "      <td>22.13197</td>\n",
       "      <td>155.33468</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063189</th>\n",
       "      <td>12199583</td>\n",
       "      <td>Vaza-Barris Canyons</td>\n",
       "      <td>Vaza-Barris Canyons</td>\n",
       "      <td>-11.75482</td>\n",
       "      <td>-36.46447</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063190</th>\n",
       "      <td>12199584</td>\n",
       "      <td>Viti Canyons</td>\n",
       "      <td>Viti Canyons</td>\n",
       "      <td>-39.05119</td>\n",
       "      <td>172.41087</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063191</th>\n",
       "      <td>12199585</td>\n",
       "      <td>Wenwang Ridge</td>\n",
       "      <td>Wenwang Ridge</td>\n",
       "      <td>-22.70107</td>\n",
       "      <td>-13.14611</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063192</th>\n",
       "      <td>12199586</td>\n",
       "      <td>West Ngātoro Knolls</td>\n",
       "      <td>West Ngatoro Knolls</td>\n",
       "      <td>-36.96184</td>\n",
       "      <td>176.85005</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063193</th>\n",
       "      <td>12199587</td>\n",
       "      <td>Yabe Seamounts</td>\n",
       "      <td>Yabe Seamounts</td>\n",
       "      <td>22.97995</td>\n",
       "      <td>155.43012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063194</th>\n",
       "      <td>12199588</td>\n",
       "      <td>Yagiza Seamount</td>\n",
       "      <td>Yagiza Seamount</td>\n",
       "      <td>15.66725</td>\n",
       "      <td>133.09599</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063195</th>\n",
       "      <td>12199589</td>\n",
       "      <td>Yakal Seamount</td>\n",
       "      <td>Yakal Seamount</td>\n",
       "      <td>18.20298</td>\n",
       "      <td>126.23908</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063196</th>\n",
       "      <td>12199590</td>\n",
       "      <td>Yaus Basin</td>\n",
       "      <td>Yaus Basin</td>\n",
       "      <td>12.40328</td>\n",
       "      <td>135.19997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063197</th>\n",
       "      <td>12199591</td>\n",
       "      <td>Yoshigamo Seamount</td>\n",
       "      <td>Yoshigamo Seamount</td>\n",
       "      <td>21.28315</td>\n",
       "      <td>149.21376</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063198</th>\n",
       "      <td>12199592</td>\n",
       "      <td>Yuangu Knoll</td>\n",
       "      <td>Yuangu Knoll</td>\n",
       "      <td>10.44564</td>\n",
       "      <td>-154.30034</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063199</th>\n",
       "      <td>12199593</td>\n",
       "      <td>Zhongnan Seamount</td>\n",
       "      <td>Zhongnan Seamount</td>\n",
       "      <td>14.00910</td>\n",
       "      <td>115.40966</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063200</th>\n",
       "      <td>12199594</td>\n",
       "      <td>Zichun Hills</td>\n",
       "      <td>Zichun Hills</td>\n",
       "      <td>17.17473</td>\n",
       "      <td>129.18114</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063201</th>\n",
       "      <td>12199596</td>\n",
       "      <td>Tenbinza Seamount</td>\n",
       "      <td>Tenbinza Seamount</td>\n",
       "      <td>15.89699</td>\n",
       "      <td>133.46307</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063202</th>\n",
       "      <td>12199597</td>\n",
       "      <td>Tenkai Escarpment</td>\n",
       "      <td>Tenkai Escarpment</td>\n",
       "      <td>19.33675</td>\n",
       "      <td>135.91997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12063203</th>\n",
       "      <td>12199598</td>\n",
       "      <td>Tenkai Basin</td>\n",
       "      <td>Tenkai Basin</td>\n",
       "      <td>19.24310</td>\n",
       "      <td>135.92763</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12063204 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          geonameid                          name  \\\n",
       "0           2986043            Pic de Font Blanca   \n",
       "1           2994701                      Roc Mélé   \n",
       "2           3007683          Pic des Langounelles   \n",
       "3           3017832          Pic de les Abelletes   \n",
       "4           3017833       Estany de les Abelletes   \n",
       "5           3023203  Port Vieux de la Coume d’Ose   \n",
       "6           3029315          Port de la Cabanette   \n",
       "7           3034945                     Port Dret   \n",
       "8           3038814               Costa de Xurius   \n",
       "9           3038815               Font de la Xona   \n",
       "10          3038816                     Xixerella   \n",
       "11          3038818                       Riu Xic   \n",
       "12          3038819                   Pas del Xic   \n",
       "13          3038820                  Roc del Xeig   \n",
       "14          3038821              Collada del Xeig   \n",
       "15          3038822                   Fonts Vives   \n",
       "16          3038823                  Roc de Vista   \n",
       "17          3038824                Obaga de Vista   \n",
       "18          3038825                 Coll de Vista   \n",
       "19          3038826                 Coll de Vista   \n",
       "20          3038827                     Visanseny   \n",
       "21          3038828               Roc de la Vinya   \n",
       "22          3038829             Canal de la Vinya   \n",
       "23          3038830                Bosc de Villar   \n",
       "24          3038831               Torrent de Vila   \n",
       "25          3038832                          Vila   \n",
       "26          3038833              Basers de Vicenç   \n",
       "27          3038834                   Pla de Viàs   \n",
       "28          3038835             Vial del Cardaire   \n",
       "29          3038836                   Font del Vi   \n",
       "...             ...                           ...   \n",
       "12063174   12199561            Shisōnohoshi Basin   \n",
       "12063175   12199562             Shittaka Seamount   \n",
       "12063176   12199563           Soeboshi Escarpment   \n",
       "12063177   12199564          South Ritchie Trough   \n",
       "12063178   12199565             Suzugamo Seamount   \n",
       "12063179   12199567          Tanakadate Seamounts   \n",
       "12063180   12199574            Tianlong Seamounts   \n",
       "12063181   12199575               Tomoza Seamount   \n",
       "12063182   12199576               Tsukamoto Guyot   \n",
       "12063183   12199577                     Uek Ridge   \n",
       "12063184   12199578               Ulerratel Ridge   \n",
       "12063185   12199579                  Uljin Valley   \n",
       "12063186   12199580                  Umiushi Spur   \n",
       "12063187   12199581                 Usagiza Ridge   \n",
       "12063188   12199582                Utashiro Guyot   \n",
       "12063189   12199583           Vaza-Barris Canyons   \n",
       "12063190   12199584                  Viti Canyons   \n",
       "12063191   12199585                 Wenwang Ridge   \n",
       "12063192   12199586           West Ngātoro Knolls   \n",
       "12063193   12199587                Yabe Seamounts   \n",
       "12063194   12199588               Yagiza Seamount   \n",
       "12063195   12199589                Yakal Seamount   \n",
       "12063196   12199590                    Yaus Basin   \n",
       "12063197   12199591            Yoshigamo Seamount   \n",
       "12063198   12199592                  Yuangu Knoll   \n",
       "12063199   12199593             Zhongnan Seamount   \n",
       "12063200   12199594                  Zichun Hills   \n",
       "12063201   12199596             Tenbinza Seamount   \n",
       "12063202   12199597             Tenkai Escarpment   \n",
       "12063203   12199598                  Tenkai Basin   \n",
       "\n",
       "                             asciiname  latitude  longitude country code  \n",
       "0                   Pic de Font Blanca  42.64991    1.53335           AD  \n",
       "1                             Roc Mele  42.58765    1.74028           AD  \n",
       "2                 Pic des Langounelles  42.61203    1.47364           AD  \n",
       "3                 Pic de les Abelletes  42.52535    1.73343           AD  \n",
       "4              Estany de les Abelletes  42.52915    1.73362           AD  \n",
       "5         Port Vieux de la Coume d'Ose  42.62568    1.61823           AD  \n",
       "6                 Port de la Cabanette  42.60000    1.73333           AD  \n",
       "7                            Port Dret  42.60172    1.45562           AD  \n",
       "8                      Costa de Xurius  42.50692    1.47569           AD  \n",
       "9                      Font de la Xona  42.55003    1.44986           AD  \n",
       "10                           Xixerella  42.55327    1.48736           AD  \n",
       "11                             Riu Xic  42.57165    1.67554           AD  \n",
       "12                         Pas del Xic  42.49766    1.57597           AD  \n",
       "13                        Roc del Xeig  42.56068    1.48980           AD  \n",
       "14                    Collada del Xeig  42.57512    1.49009           AD  \n",
       "15                         Fonts Vives  42.49829    1.56428           AD  \n",
       "16                        Roc de Vista  42.49922    1.48118           AD  \n",
       "17                      Obaga de Vista  42.47935    1.44621           AD  \n",
       "18                       Coll de Vista  42.47611    1.60578           AD  \n",
       "19                       Coll de Vista  42.47552    1.44173           AD  \n",
       "20                           Visanseny  42.57488    1.61616           AD  \n",
       "21                     Roc de la Vinya  42.52776    1.56446           AD  \n",
       "22                   Canal de la Vinya  42.52232    1.52319           AD  \n",
       "23                      Bosc de Villar  42.60135    1.54340           AD  \n",
       "24                     Torrent de Vila  42.53414    1.56678           AD  \n",
       "25                                Vila  42.53176    1.56654           AD  \n",
       "26                    Basers de Vicenc  42.47669    1.48290           AD  \n",
       "27                         Pla de Vias  42.59001    1.65996           AD  \n",
       "28                   Vial del Cardaire  42.56372    1.50503           AD  \n",
       "29                         Font del Vi  42.52342    1.47698           AD  \n",
       "...                                ...       ...        ...          ...  \n",
       "12063174            Shisonohoshi Basin  18.08246  135.55482          NaN  \n",
       "12063175             Shittaka Seamount  22.18170  156.67134          NaN  \n",
       "12063176           Soeboshi Escarpment  17.28697  134.97571          NaN  \n",
       "12063177          South Ritchie Trough -39.59948  178.26528          NaN  \n",
       "12063178             Suzugamo Seamount  21.65932  149.39013          NaN  \n",
       "12063179          Tanakadate Seamounts  23.77892  158.22712          NaN  \n",
       "12063180            Tianlong Seamounts   5.07587   61.94515          NaN  \n",
       "12063181               Tomoza Seamount  15.23393  133.13439          NaN  \n",
       "12063182               Tsukamoto Guyot  20.10000  151.66921          NaN  \n",
       "12063183                     Uek Ridge  12.32578  134.87377          NaN  \n",
       "12063184               Ulerratel Ridge  12.28053  134.73337          NaN  \n",
       "12063185                  Uljin Valley  36.99567  129.95806          NaN  \n",
       "12063186                  Umiushi Spur  21.02651  150.24312          NaN  \n",
       "12063187                 Usagiza Ridge  14.87846  132.52095          NaN  \n",
       "12063188                Utashiro Guyot  22.13197  155.33468          NaN  \n",
       "12063189           Vaza-Barris Canyons -11.75482  -36.46447          NaN  \n",
       "12063190                  Viti Canyons -39.05119  172.41087          NaN  \n",
       "12063191                 Wenwang Ridge -22.70107  -13.14611          NaN  \n",
       "12063192           West Ngatoro Knolls -36.96184  176.85005          NaN  \n",
       "12063193                Yabe Seamounts  22.97995  155.43012          NaN  \n",
       "12063194               Yagiza Seamount  15.66725  133.09599          NaN  \n",
       "12063195                Yakal Seamount  18.20298  126.23908          NaN  \n",
       "12063196                    Yaus Basin  12.40328  135.19997          NaN  \n",
       "12063197            Yoshigamo Seamount  21.28315  149.21376          NaN  \n",
       "12063198                  Yuangu Knoll  10.44564 -154.30034          NaN  \n",
       "12063199             Zhongnan Seamount  14.00910  115.40966          NaN  \n",
       "12063200                  Zichun Hills  17.17473  129.18114          NaN  \n",
       "12063201             Tenbinza Seamount  15.89699  133.46307          NaN  \n",
       "12063202             Tenkai Escarpment  19.33675  135.91997          NaN  \n",
       "12063203                  Tenkai Basin  19.24310  135.92763          NaN  \n",
       "\n",
       "[12063204 rows x 6 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GeoNames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:01:41.923250Z",
     "start_time": "2021-01-14T22:01:41.916239Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 12063204 entries, 0 to 12063203\n",
      "Data columns (total 6 columns):\n",
      "geonameid       int64\n",
      "name            object\n",
      "asciiname       object\n",
      "latitude        float64\n",
      "longitude       float64\n",
      "country code    object\n",
      "dtypes: float64(2), int64(1), object(3)\n",
      "memory usage: 552.2+ MB\n"
     ]
    }
   ],
   "source": [
    "GeoNames.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:11:16.730144Z",
     "start_time": "2021-01-14T22:10:07.272075Z"
    }
   },
   "outputs": [],
   "source": [
    "GeoNames.to_csv('GeoNames.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:54:24.044311Z",
     "start_time": "2021-01-14T22:54:22.151498Z"
    }
   },
   "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>geonameid</th>\n",
       "      <th>name</th>\n",
       "      <th>asciiname</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>country code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>193776</th>\n",
       "      <td>6637888</td>\n",
       "      <td>McMurdo Dry Valleys</td>\n",
       "      <td>McMurdo Dry Valleys</td>\n",
       "      <td>-77.5</td>\n",
       "      <td>162.0</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        geonameid                 name            asciiname  latitude  \\\n",
       "193776    6637888  McMurdo Dry Valleys  McMurdo Dry Valleys     -77.5   \n",
       "\n",
       "        longitude country code  \n",
       "193776      162.0           AQ  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GeoNames[GeoNames.name == 'McMurdo Dry Valleys']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:14:18.200373Z",
     "start_time": "2021-01-14T22:14:17.527887Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "18529"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(GeoNames[GeoNames['country code']=='AQ'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:53:12.071036Z",
     "start_time": "2021-01-14T22:53:11.390529Z"
    }
   },
   "outputs": [],
   "source": [
    "GeoNamesAnt = GeoNames[GeoNames['country code']=='AQ']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:53:19.717370Z",
     "start_time": "2021-01-14T22:53:19.690675Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 18529 entries, 177344 to 195872\n",
      "Data columns (total 6 columns):\n",
      "geonameid       18529 non-null int64\n",
      "name            18529 non-null object\n",
      "asciiname       18529 non-null object\n",
      "latitude        18529 non-null float64\n",
      "longitude       18529 non-null float64\n",
      "country code    18529 non-null object\n",
      "dtypes: float64(2), int64(1), object(3)\n",
      "memory usage: 1013.3+ KB\n"
     ]
    }
   ],
   "source": [
    "GeoNamesAnt.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:53:33.036544Z",
     "start_time": "2021-01-14T22:53:33.010173Z"
    },
    "scrolled": true
   },
   "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>geonameid</th>\n",
       "      <th>name</th>\n",
       "      <th>asciiname</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>country code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>177344</th>\n",
       "      <td>4036624</td>\n",
       "      <td>Weddell Sea</td>\n",
       "      <td>Weddell Sea</td>\n",
       "      <td>-73.00000</td>\n",
       "      <td>-45.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177345</th>\n",
       "      <td>4036625</td>\n",
       "      <td>Ross Sea</td>\n",
       "      <td>Ross Sea</td>\n",
       "      <td>-75.00000</td>\n",
       "      <td>-175.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177346</th>\n",
       "      <td>4036627</td>\n",
       "      <td>Davis Sea</td>\n",
       "      <td>Davis Sea</td>\n",
       "      <td>-66.00000</td>\n",
       "      <td>93.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177347</th>\n",
       "      <td>4036628</td>\n",
       "      <td>Bellingshausen Sea</td>\n",
       "      <td>Bellingshausen Sea</td>\n",
       "      <td>-71.00000</td>\n",
       "      <td>-85.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177348</th>\n",
       "      <td>4036629</td>\n",
       "      <td>Amundsen Sea</td>\n",
       "      <td>Amundsen Sea</td>\n",
       "      <td>-72.50000</td>\n",
       "      <td>-111.91667</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177349</th>\n",
       "      <td>4036648</td>\n",
       "      <td>Vigilante</td>\n",
       "      <td>Vigilante</td>\n",
       "      <td>-69.98333</td>\n",
       "      <td>-69.98333</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177350</th>\n",
       "      <td>4036652</td>\n",
       "      <td>Wilson Canyon</td>\n",
       "      <td>Wilson Canyon</td>\n",
       "      <td>-70.58333</td>\n",
       "      <td>176.25000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177351</th>\n",
       "      <td>4036653</td>\n",
       "      <td>Whales Bay Furrows</td>\n",
       "      <td>Whales Bay Furrows</td>\n",
       "      <td>-78.00000</td>\n",
       "      <td>-169.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177352</th>\n",
       "      <td>4036654</td>\n",
       "      <td>Wegener Canyon</td>\n",
       "      <td>Wegener Canyon</td>\n",
       "      <td>-70.75000</td>\n",
       "      <td>-14.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177353</th>\n",
       "      <td>4036655</td>\n",
       "      <td>Weddell Plain</td>\n",
       "      <td>Weddell Plain</td>\n",
       "      <td>-65.00000</td>\n",
       "      <td>-20.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177354</th>\n",
       "      <td>4036656</td>\n",
       "      <td>Vaughan Bank</td>\n",
       "      <td>Vaughan Bank</td>\n",
       "      <td>-67.61667</td>\n",
       "      <td>163.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177355</th>\n",
       "      <td>4036657</td>\n",
       "      <td>Vanderford Valley</td>\n",
       "      <td>Vanderford Valley</td>\n",
       "      <td>-66.41667</td>\n",
       "      <td>110.16667</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177356</th>\n",
       "      <td>4036658</td>\n",
       "      <td>Umitaka Bank</td>\n",
       "      <td>Umitaka Bank</td>\n",
       "      <td>-67.41667</td>\n",
       "      <td>167.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177357</th>\n",
       "      <td>4036659</td>\n",
       "      <td>Tressler Bank</td>\n",
       "      <td>Tressler Bank</td>\n",
       "      <td>-65.00000</td>\n",
       "      <td>95.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177358</th>\n",
       "      <td>4036660</td>\n",
       "      <td>Terra Nova Canyon</td>\n",
       "      <td>Terra Nova Canyon</td>\n",
       "      <td>-69.00000</td>\n",
       "      <td>159.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177359</th>\n",
       "      <td>4036662</td>\n",
       "      <td>Sulzberger Basin</td>\n",
       "      <td>Sulzberger Basin</td>\n",
       "      <td>-77.00000</td>\n",
       "      <td>-152.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177360</th>\n",
       "      <td>4036663</td>\n",
       "      <td>South Shetland Trough</td>\n",
       "      <td>South Shetland Trough</td>\n",
       "      <td>-61.00000</td>\n",
       "      <td>-59.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177361</th>\n",
       "      <td>4036665</td>\n",
       "      <td>South Sandwich Fracture Zone</td>\n",
       "      <td>South Sandwich Fracture Zone</td>\n",
       "      <td>-63.00000</td>\n",
       "      <td>-20.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177362</th>\n",
       "      <td>4036669</td>\n",
       "      <td>Shirase Bank</td>\n",
       "      <td>Shirase Bank</td>\n",
       "      <td>-76.66667</td>\n",
       "      <td>-158.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177363</th>\n",
       "      <td>4036671</td>\n",
       "      <td>Scott Shoal</td>\n",
       "      <td>Scott Shoal</td>\n",
       "      <td>-73.25000</td>\n",
       "      <td>177.75000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177364</th>\n",
       "      <td>4036672</td>\n",
       "      <td>Scott Seamounts</td>\n",
       "      <td>Scott Seamounts</td>\n",
       "      <td>-68.00000</td>\n",
       "      <td>-179.83333</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177365</th>\n",
       "      <td>4036673</td>\n",
       "      <td>Scott Island Bank</td>\n",
       "      <td>Scott Island Bank</td>\n",
       "      <td>-67.75000</td>\n",
       "      <td>-179.91667</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177366</th>\n",
       "      <td>4036674</td>\n",
       "      <td>Saunders Basin</td>\n",
       "      <td>Saunders Basin</td>\n",
       "      <td>-76.83333</td>\n",
       "      <td>-155.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177367</th>\n",
       "      <td>4036675</td>\n",
       "      <td>Ross Canyon</td>\n",
       "      <td>Ross Canyon</td>\n",
       "      <td>-75.00000</td>\n",
       "      <td>-163.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177368</th>\n",
       "      <td>4036676</td>\n",
       "      <td>Ross Bank</td>\n",
       "      <td>Ross Bank</td>\n",
       "      <td>-76.75000</td>\n",
       "      <td>176.00000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177369</th>\n",
       "      <td>4036677</td>\n",
       "      <td>Prestrud Bank</td>\n",
       "      <td>Prestrud Bank</td>\n",
       "      <td>-77.50000</td>\n",
       "      <td>-159.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177370</th>\n",
       "      <td>4036678</td>\n",
       "      <td>Powell Basin</td>\n",
       "      <td>Powell Basin</td>\n",
       "      <td>-62.25000</td>\n",
       "      <td>-49.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177371</th>\n",
       "      <td>4036679</td>\n",
       "      <td>Porpoise Basin</td>\n",
       "      <td>Porpoise Basin</td>\n",
       "      <td>-66.16667</td>\n",
       "      <td>128.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177372</th>\n",
       "      <td>4036680</td>\n",
       "      <td>Petersen Bank</td>\n",
       "      <td>Petersen Bank</td>\n",
       "      <td>-65.75000</td>\n",
       "      <td>109.91667</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177373</th>\n",
       "      <td>4036681</td>\n",
       "      <td>Pennell Bank</td>\n",
       "      <td>Pennell Bank</td>\n",
       "      <td>-74.50000</td>\n",
       "      <td>179.98333</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195843</th>\n",
       "      <td>8521288</td>\n",
       "      <td>Stedøy</td>\n",
       "      <td>Stedoy</td>\n",
       "      <td>-69.13425</td>\n",
       "      <td>76.74658</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195844</th>\n",
       "      <td>8521289</td>\n",
       "      <td>Vernadsky Station</td>\n",
       "      <td>Vernadsky Station</td>\n",
       "      <td>-65.24528</td>\n",
       "      <td>-64.25667</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195845</th>\n",
       "      <td>8521290</td>\n",
       "      <td>Kranevo Point</td>\n",
       "      <td>Kranevo Point</td>\n",
       "      <td>-63.55861</td>\n",
       "      <td>-59.87972</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195846</th>\n",
       "      <td>8521291</td>\n",
       "      <td>Boyd Island</td>\n",
       "      <td>Boyd Island</td>\n",
       "      <td>-68.54483</td>\n",
       "      <td>77.94389</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195847</th>\n",
       "      <td>8521292</td>\n",
       "      <td>Sidell Spur</td>\n",
       "      <td>Sidell Spur</td>\n",
       "      <td>-64.35879</td>\n",
       "      <td>-62.55808</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195848</th>\n",
       "      <td>8521293</td>\n",
       "      <td>Ajmonecat Lake</td>\n",
       "      <td>Ajmonecat Lake</td>\n",
       "      <td>-62.92222</td>\n",
       "      <td>-60.67778</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195849</th>\n",
       "      <td>8521294</td>\n",
       "      <td>Pisagua Hill</td>\n",
       "      <td>Pisagua Hill</td>\n",
       "      <td>-62.92472</td>\n",
       "      <td>-60.67611</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195850</th>\n",
       "      <td>8521295</td>\n",
       "      <td>Marchesi, Cape</td>\n",
       "      <td>Marchesi, Cape</td>\n",
       "      <td>-72.39444</td>\n",
       "      <td>-77.62222</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195851</th>\n",
       "      <td>8521296</td>\n",
       "      <td>Haumea Glacier</td>\n",
       "      <td>Haumea Glacier</td>\n",
       "      <td>-71.00000</td>\n",
       "      <td>-68.65000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195852</th>\n",
       "      <td>8521297</td>\n",
       "      <td>Eris Glacier</td>\n",
       "      <td>Eris Glacier</td>\n",
       "      <td>-70.60000</td>\n",
       "      <td>-68.70833</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195853</th>\n",
       "      <td>8521298</td>\n",
       "      <td>Downie Ridge</td>\n",
       "      <td>Downie Ridge</td>\n",
       "      <td>-62.96667</td>\n",
       "      <td>-60.73750</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195854</th>\n",
       "      <td>8521299</td>\n",
       "      <td>Caliente Hill</td>\n",
       "      <td>Caliente Hill</td>\n",
       "      <td>-62.97333</td>\n",
       "      <td>-60.71167</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195855</th>\n",
       "      <td>8521300</td>\n",
       "      <td>Benguela Gully</td>\n",
       "      <td>Benguela Gully</td>\n",
       "      <td>-62.98167</td>\n",
       "      <td>-60.51750</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195856</th>\n",
       "      <td>8521301</td>\n",
       "      <td>Balakirev Glacier</td>\n",
       "      <td>Balakirev Glacier</td>\n",
       "      <td>-71.03333</td>\n",
       "      <td>-69.96667</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195857</th>\n",
       "      <td>8521302</td>\n",
       "      <td>Rott Inlet</td>\n",
       "      <td>Rott Inlet</td>\n",
       "      <td>-64.45000</td>\n",
       "      <td>-59.88330</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195858</th>\n",
       "      <td>8521303</td>\n",
       "      <td>Foord Glacier</td>\n",
       "      <td>Foord Glacier</td>\n",
       "      <td>-64.13890</td>\n",
       "      <td>-58.03810</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195859</th>\n",
       "      <td>8521304</td>\n",
       "      <td>Barnola Glacier</td>\n",
       "      <td>Barnola Glacier</td>\n",
       "      <td>-64.24390</td>\n",
       "      <td>-58.06000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195860</th>\n",
       "      <td>8521305</td>\n",
       "      <td>Herniman Glacier</td>\n",
       "      <td>Herniman Glacier</td>\n",
       "      <td>-64.28310</td>\n",
       "      <td>-58.16610</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195861</th>\n",
       "      <td>8521306</td>\n",
       "      <td>Sunnyside Bowl</td>\n",
       "      <td>Sunnyside Bowl</td>\n",
       "      <td>-67.41720</td>\n",
       "      <td>-68.16670</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195862</th>\n",
       "      <td>8521307</td>\n",
       "      <td>Lovell Glacier</td>\n",
       "      <td>Lovell Glacier</td>\n",
       "      <td>-72.00000</td>\n",
       "      <td>-69.50000</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195863</th>\n",
       "      <td>8521308</td>\n",
       "      <td>Trathan Coast</td>\n",
       "      <td>Trathan Coast</td>\n",
       "      <td>-72.50000</td>\n",
       "      <td>-78.33333</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195864</th>\n",
       "      <td>8521309</td>\n",
       "      <td>Woodman Highlands</td>\n",
       "      <td>Woodman Highlands</td>\n",
       "      <td>-64.35065</td>\n",
       "      <td>-59.20906</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195865</th>\n",
       "      <td>8693006</td>\n",
       "      <td>DRV magnetic observatory area</td>\n",
       "      <td>DRV magnetic observatory area</td>\n",
       "      <td>-66.66480</td>\n",
       "      <td>140.00039</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195866</th>\n",
       "      <td>9072762</td>\n",
       "      <td>Villa Las Estrellas</td>\n",
       "      <td>Villa Las Estrellas</td>\n",
       "      <td>-62.20001</td>\n",
       "      <td>-58.96109</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195867</th>\n",
       "      <td>11257232</td>\n",
       "      <td>Svarthamaren</td>\n",
       "      <td>Svarthamaren</td>\n",
       "      <td>-72.01300</td>\n",
       "      <td>5.16600</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195868</th>\n",
       "      <td>11258141</td>\n",
       "      <td>Troll</td>\n",
       "      <td>Troll</td>\n",
       "      <td>-72.01196</td>\n",
       "      <td>2.53407</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195869</th>\n",
       "      <td>11749467</td>\n",
       "      <td>McMurdo Station Pegasus Field</td>\n",
       "      <td>McMurdo Station Pegasus Field</td>\n",
       "      <td>-77.96306</td>\n",
       "      <td>166.50862</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195870</th>\n",
       "      <td>12110491</td>\n",
       "      <td>Union Glacier Blue-Ice Runway</td>\n",
       "      <td>Union Glacier Blue-Ice Runway</td>\n",
       "      <td>-79.77683</td>\n",
       "      <td>-83.31852</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195871</th>\n",
       "      <td>12122275</td>\n",
       "      <td>Omelchenko Bluff</td>\n",
       "      <td>Omelchenko Bluff</td>\n",
       "      <td>-77.63556</td>\n",
       "      <td>166.75917</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195872</th>\n",
       "      <td>12148841</td>\n",
       "      <td>Union Glacier Camp</td>\n",
       "      <td>Union Glacier Camp</td>\n",
       "      <td>-79.76738</td>\n",
       "      <td>-83.25646</td>\n",
       "      <td>AQ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18529 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        geonameid                           name  \\\n",
       "177344    4036624                    Weddell Sea   \n",
       "177345    4036625                       Ross Sea   \n",
       "177346    4036627                      Davis Sea   \n",
       "177347    4036628             Bellingshausen Sea   \n",
       "177348    4036629                   Amundsen Sea   \n",
       "177349    4036648                      Vigilante   \n",
       "177350    4036652                  Wilson Canyon   \n",
       "177351    4036653             Whales Bay Furrows   \n",
       "177352    4036654                 Wegener Canyon   \n",
       "177353    4036655                  Weddell Plain   \n",
       "177354    4036656                   Vaughan Bank   \n",
       "177355    4036657              Vanderford Valley   \n",
       "177356    4036658                   Umitaka Bank   \n",
       "177357    4036659                  Tressler Bank   \n",
       "177358    4036660              Terra Nova Canyon   \n",
       "177359    4036662               Sulzberger Basin   \n",
       "177360    4036663          South Shetland Trough   \n",
       "177361    4036665   South Sandwich Fracture Zone   \n",
       "177362    4036669                   Shirase Bank   \n",
       "177363    4036671                    Scott Shoal   \n",
       "177364    4036672                Scott Seamounts   \n",
       "177365    4036673              Scott Island Bank   \n",
       "177366    4036674                 Saunders Basin   \n",
       "177367    4036675                    Ross Canyon   \n",
       "177368    4036676                      Ross Bank   \n",
       "177369    4036677                  Prestrud Bank   \n",
       "177370    4036678                   Powell Basin   \n",
       "177371    4036679                 Porpoise Basin   \n",
       "177372    4036680                  Petersen Bank   \n",
       "177373    4036681                   Pennell Bank   \n",
       "...           ...                            ...   \n",
       "195843    8521288                         Stedøy   \n",
       "195844    8521289              Vernadsky Station   \n",
       "195845    8521290                  Kranevo Point   \n",
       "195846    8521291                    Boyd Island   \n",
       "195847    8521292                    Sidell Spur   \n",
       "195848    8521293                 Ajmonecat Lake   \n",
       "195849    8521294                   Pisagua Hill   \n",
       "195850    8521295                 Marchesi, Cape   \n",
       "195851    8521296                 Haumea Glacier   \n",
       "195852    8521297                   Eris Glacier   \n",
       "195853    8521298                   Downie Ridge   \n",
       "195854    8521299                  Caliente Hill   \n",
       "195855    8521300                 Benguela Gully   \n",
       "195856    8521301              Balakirev Glacier   \n",
       "195857    8521302                     Rott Inlet   \n",
       "195858    8521303                  Foord Glacier   \n",
       "195859    8521304                Barnola Glacier   \n",
       "195860    8521305               Herniman Glacier   \n",
       "195861    8521306                 Sunnyside Bowl   \n",
       "195862    8521307                 Lovell Glacier   \n",
       "195863    8521308                  Trathan Coast   \n",
       "195864    8521309              Woodman Highlands   \n",
       "195865    8693006  DRV magnetic observatory area   \n",
       "195866    9072762            Villa Las Estrellas   \n",
       "195867   11257232                   Svarthamaren   \n",
       "195868   11258141                          Troll   \n",
       "195869   11749467  McMurdo Station Pegasus Field   \n",
       "195870   12110491  Union Glacier Blue-Ice Runway   \n",
       "195871   12122275               Omelchenko Bluff   \n",
       "195872   12148841             Union Glacier Camp   \n",
       "\n",
       "                            asciiname  latitude  longitude country code  \n",
       "177344                    Weddell Sea -73.00000  -45.00000           AQ  \n",
       "177345                       Ross Sea -75.00000 -175.00000           AQ  \n",
       "177346                      Davis Sea -66.00000   93.50000           AQ  \n",
       "177347             Bellingshausen Sea -71.00000  -85.00000           AQ  \n",
       "177348                   Amundsen Sea -72.50000 -111.91667           AQ  \n",
       "177349                      Vigilante -69.98333  -69.98333           AQ  \n",
       "177350                  Wilson Canyon -70.58333  176.25000           AQ  \n",
       "177351             Whales Bay Furrows -78.00000 -169.00000           AQ  \n",
       "177352                 Wegener Canyon -70.75000  -14.00000           AQ  \n",
       "177353                  Weddell Plain -65.00000  -20.00000           AQ  \n",
       "177354                   Vaughan Bank -67.61667  163.50000           AQ  \n",
       "177355              Vanderford Valley -66.41667  110.16667           AQ  \n",
       "177356                   Umitaka Bank -67.41667  167.00000           AQ  \n",
       "177357                  Tressler Bank -65.00000   95.00000           AQ  \n",
       "177358              Terra Nova Canyon -69.00000  159.00000           AQ  \n",
       "177359               Sulzberger Basin -77.00000 -152.50000           AQ  \n",
       "177360          South Shetland Trough -61.00000  -59.50000           AQ  \n",
       "177361   South Sandwich Fracture Zone -63.00000  -20.00000           AQ  \n",
       "177362                   Shirase Bank -76.66667 -158.00000           AQ  \n",
       "177363                    Scott Shoal -73.25000  177.75000           AQ  \n",
       "177364                Scott Seamounts -68.00000 -179.83333           AQ  \n",
       "177365              Scott Island Bank -67.75000 -179.91667           AQ  \n",
       "177366                 Saunders Basin -76.83333 -155.00000           AQ  \n",
       "177367                    Ross Canyon -75.00000 -163.00000           AQ  \n",
       "177368                      Ross Bank -76.75000  176.00000           AQ  \n",
       "177369                  Prestrud Bank -77.50000 -159.50000           AQ  \n",
       "177370                   Powell Basin -62.25000  -49.50000           AQ  \n",
       "177371                 Porpoise Basin -66.16667  128.50000           AQ  \n",
       "177372                  Petersen Bank -65.75000  109.91667           AQ  \n",
       "177373                   Pennell Bank -74.50000  179.98333           AQ  \n",
       "...                               ...       ...        ...          ...  \n",
       "195843                         Stedoy -69.13425   76.74658           AQ  \n",
       "195844              Vernadsky Station -65.24528  -64.25667           AQ  \n",
       "195845                  Kranevo Point -63.55861  -59.87972           AQ  \n",
       "195846                    Boyd Island -68.54483   77.94389           AQ  \n",
       "195847                    Sidell Spur -64.35879  -62.55808           AQ  \n",
       "195848                 Ajmonecat Lake -62.92222  -60.67778           AQ  \n",
       "195849                   Pisagua Hill -62.92472  -60.67611           AQ  \n",
       "195850                 Marchesi, Cape -72.39444  -77.62222           AQ  \n",
       "195851                 Haumea Glacier -71.00000  -68.65000           AQ  \n",
       "195852                   Eris Glacier -70.60000  -68.70833           AQ  \n",
       "195853                   Downie Ridge -62.96667  -60.73750           AQ  \n",
       "195854                  Caliente Hill -62.97333  -60.71167           AQ  \n",
       "195855                 Benguela Gully -62.98167  -60.51750           AQ  \n",
       "195856              Balakirev Glacier -71.03333  -69.96667           AQ  \n",
       "195857                     Rott Inlet -64.45000  -59.88330           AQ  \n",
       "195858                  Foord Glacier -64.13890  -58.03810           AQ  \n",
       "195859                Barnola Glacier -64.24390  -58.06000           AQ  \n",
       "195860               Herniman Glacier -64.28310  -58.16610           AQ  \n",
       "195861                 Sunnyside Bowl -67.41720  -68.16670           AQ  \n",
       "195862                 Lovell Glacier -72.00000  -69.50000           AQ  \n",
       "195863                  Trathan Coast -72.50000  -78.33333           AQ  \n",
       "195864              Woodman Highlands -64.35065  -59.20906           AQ  \n",
       "195865  DRV magnetic observatory area -66.66480  140.00039           AQ  \n",
       "195866            Villa Las Estrellas -62.20001  -58.96109           AQ  \n",
       "195867                   Svarthamaren -72.01300    5.16600           AQ  \n",
       "195868                          Troll -72.01196    2.53407           AQ  \n",
       "195869  McMurdo Station Pegasus Field -77.96306  166.50862           AQ  \n",
       "195870  Union Glacier Blue-Ice Runway -79.77683  -83.31852           AQ  \n",
       "195871               Omelchenko Bluff -77.63556  166.75917           AQ  \n",
       "195872             Union Glacier Camp -79.76738  -83.25646           AQ  \n",
       "\n",
       "[18529 rows x 6 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GeoNamesAnt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-14T22:56:05.281953Z",
     "start_time": "2021-01-14T22:56:05.123814Z"
    }
   },
   "outputs": [],
   "source": [
    "GeoNamesAnt.to_csv('GeoNamesAnt.csv')"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< Updated upstream
=======
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-20T22:37:53.187227Z",
     "start_time": "2021-01-20T22:37:30.950401Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/myfriendscallmej/anaconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3057: DtypeWarning: Columns (6) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "GeoNames = pd.read_csv('GeoNames.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-21T00:24:33.871205Z",
     "start_time": "2021-01-21T00:24:33.109652Z"
    }
   },
   "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>Unnamed: 0</th>\n",
       "      <th>geonameid</th>\n",
       "      <th>name</th>\n",
       "      <th>asciiname</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>country code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9408946</th>\n",
       "      <td>9408946</td>\n",
       "      <td>4059475</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>33.10817</td>\n",
       "      <td>-86.83832</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9408947</th>\n",
       "      <td>9408947</td>\n",
       "      <td>4059476</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>33.07790</td>\n",
       "      <td>-86.81665</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9408952</th>\n",
       "      <td>9408952</td>\n",
       "      <td>4059481</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>33.58344</td>\n",
       "      <td>-86.09081</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9541058</th>\n",
       "      <td>9541058</td>\n",
       "      <td>4192188</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>34.53258</td>\n",
       "      <td>-85.35690</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9638922</th>\n",
       "      <td>9638922</td>\n",
       "      <td>4290431</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>37.90340</td>\n",
       "      <td>-86.45276</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9638924</th>\n",
       "      <td>9638924</td>\n",
       "      <td>4290433</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.89147</td>\n",
       "      <td>-84.61688</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9701920</th>\n",
       "      <td>9701920</td>\n",
       "      <td>4353692</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>38.87123</td>\n",
       "      <td>-76.57468</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9732723</th>\n",
       "      <td>9732723</td>\n",
       "      <td>4384637</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.95255</td>\n",
       "      <td>-91.09068</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9732724</th>\n",
       "      <td>9732724</td>\n",
       "      <td>4384638</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>37.02506</td>\n",
       "      <td>-94.04160</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9732725</th>\n",
       "      <td>9732725</td>\n",
       "      <td>4384639</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>37.24783</td>\n",
       "      <td>-90.96735</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959959</th>\n",
       "      <td>9959959</td>\n",
       "      <td>4619351</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>35.66370</td>\n",
       "      <td>-83.78545</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959961</th>\n",
       "      <td>9959961</td>\n",
       "      <td>4619353</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>34.96424</td>\n",
       "      <td>-84.97161</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959962</th>\n",
       "      <td>9959962</td>\n",
       "      <td>4619354</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>35.19007</td>\n",
       "      <td>-84.81050</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959963</th>\n",
       "      <td>9959963</td>\n",
       "      <td>4619355</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.37759</td>\n",
       "      <td>-83.44629</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959964</th>\n",
       "      <td>9959964</td>\n",
       "      <td>4619356</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.57982</td>\n",
       "      <td>-82.94933</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959965</th>\n",
       "      <td>9959965</td>\n",
       "      <td>4619357</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.59482</td>\n",
       "      <td>-82.91155</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959966</th>\n",
       "      <td>9959966</td>\n",
       "      <td>4619358</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.07090</td>\n",
       "      <td>-85.46470</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9959967</th>\n",
       "      <td>9959967</td>\n",
       "      <td>4619359</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.10673</td>\n",
       "      <td>-85.44386</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10027276</th>\n",
       "      <td>10027276</td>\n",
       "      <td>4687141</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>33.53233</td>\n",
       "      <td>-97.67864</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10027279</th>\n",
       "      <td>10027279</td>\n",
       "      <td>4687144</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>33.55455</td>\n",
       "      <td>-97.69086</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10403558</th>\n",
       "      <td>10403558</td>\n",
       "      <td>5067201</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>41.47862</td>\n",
       "      <td>-99.37427</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10403559</th>\n",
       "      <td>10403559</td>\n",
       "      <td>5067202</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>41.87723</td>\n",
       "      <td>-99.61484</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10523436</th>\n",
       "      <td>10523436</td>\n",
       "      <td>5187424</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>40.62674</td>\n",
       "      <td>-77.55694</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10628958</th>\n",
       "      <td>10628958</td>\n",
       "      <td>5293350</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>34.09893</td>\n",
       "      <td>-110.06761</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10679523</th>\n",
       "      <td>10679523</td>\n",
       "      <td>5344132</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>39.95824</td>\n",
       "      <td>-120.01631</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10679525</th>\n",
       "      <td>10679525</td>\n",
       "      <td>5344134</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>32.66867</td>\n",
       "      <td>-116.68557</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10679526</th>\n",
       "      <td>10679526</td>\n",
       "      <td>5344135</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>36.62134</td>\n",
       "      <td>-118.99677</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10838112</th>\n",
       "      <td>10838112</td>\n",
       "      <td>5503261</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>37.86052</td>\n",
       "      <td>-114.32304</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10838114</th>\n",
       "      <td>10838114</td>\n",
       "      <td>5503263</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>38.99493</td>\n",
       "      <td>-116.33618</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10873233</th>\n",
       "      <td>10873233</td>\n",
       "      <td>5538502</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>37.64970</td>\n",
       "      <td>-112.67355</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10873234</th>\n",
       "      <td>10873234</td>\n",
       "      <td>5538503</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>37.51137</td>\n",
       "      <td>-112.72522</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10873236</th>\n",
       "      <td>10873236</td>\n",
       "      <td>5538505</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>37.37554</td>\n",
       "      <td>-112.18464</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10873237</th>\n",
       "      <td>10873237</td>\n",
       "      <td>5538506</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>38.23693</td>\n",
       "      <td>-109.43345</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10873238</th>\n",
       "      <td>10873238</td>\n",
       "      <td>5538507</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>39.86524</td>\n",
       "      <td>-111.11711</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10873239</th>\n",
       "      <td>10873239</td>\n",
       "      <td>5538508</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>38.37387</td>\n",
       "      <td>-110.62709</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10873240</th>\n",
       "      <td>10873240</td>\n",
       "      <td>5538509</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>38.44276</td>\n",
       "      <td>-111.63241</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10897410</th>\n",
       "      <td>10897410</td>\n",
       "      <td>5562903</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>40.84240</td>\n",
       "      <td>-120.62690</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10925990</th>\n",
       "      <td>10925990</td>\n",
       "      <td>5591628</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>42.77409</td>\n",
       "      <td>-111.35855</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028730</th>\n",
       "      <td>11028730</td>\n",
       "      <td>5694948</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>42.24194</td>\n",
       "      <td>-100.95377</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028735</th>\n",
       "      <td>11028735</td>\n",
       "      <td>5694953</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>42.24472</td>\n",
       "      <td>-101.02266</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11037197</th>\n",
       "      <td>11037197</td>\n",
       "      <td>5703449</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>40.20907</td>\n",
       "      <td>-119.83187</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11057895</th>\n",
       "      <td>11057895</td>\n",
       "      <td>5724224</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>43.09765</td>\n",
       "      <td>-119.70829</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11057896</th>\n",
       "      <td>11057896</td>\n",
       "      <td>5724225</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>42.15682</td>\n",
       "      <td>-120.77497</td>\n",
       "      <td>US</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12045722</th>\n",
       "      <td>12045722</td>\n",
       "      <td>892082</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>-20.14062</td>\n",
       "      <td>29.60043</td>\n",
       "      <td>ZW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12055619</th>\n",
       "      <td>12055619</td>\n",
       "      <td>7505407</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>Dry Valley</td>\n",
       "      <td>-20.08405</td>\n",
       "      <td>29.44430</td>\n",
       "      <td>ZW</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Unnamed: 0  geonameid        name   asciiname  latitude  longitude  \\\n",
       "9408946      9408946    4059475  Dry Valley  Dry Valley  33.10817  -86.83832   \n",
       "9408947      9408947    4059476  Dry Valley  Dry Valley  33.07790  -86.81665   \n",
       "9408952      9408952    4059481  Dry Valley  Dry Valley  33.58344  -86.09081   \n",
       "9541058      9541058    4192188  Dry Valley  Dry Valley  34.53258  -85.35690   \n",
       "9638922      9638922    4290431  Dry Valley  Dry Valley  37.90340  -86.45276   \n",
       "9638924      9638924    4290433  Dry Valley  Dry Valley  36.89147  -84.61688   \n",
       "9701920      9701920    4353692  Dry Valley  Dry Valley  38.87123  -76.57468   \n",
       "9732723      9732723    4384637  Dry Valley  Dry Valley  36.95255  -91.09068   \n",
       "9732724      9732724    4384638  Dry Valley  Dry Valley  37.02506  -94.04160   \n",
       "9732725      9732725    4384639  Dry Valley  Dry Valley  37.24783  -90.96735   \n",
       "9959959      9959959    4619351  Dry Valley  Dry Valley  35.66370  -83.78545   \n",
       "9959961      9959961    4619353  Dry Valley  Dry Valley  34.96424  -84.97161   \n",
       "9959962      9959962    4619354  Dry Valley  Dry Valley  35.19007  -84.81050   \n",
       "9959963      9959963    4619355  Dry Valley  Dry Valley  36.37759  -83.44629   \n",
       "9959964      9959964    4619356  Dry Valley  Dry Valley  36.57982  -82.94933   \n",
       "9959965      9959965    4619357  Dry Valley  Dry Valley  36.59482  -82.91155   \n",
       "9959966      9959966    4619358  Dry Valley  Dry Valley  36.07090  -85.46470   \n",
       "9959967      9959967    4619359  Dry Valley  Dry Valley  36.10673  -85.44386   \n",
       "10027276    10027276    4687141  Dry Valley  Dry Valley  33.53233  -97.67864   \n",
       "10027279    10027279    4687144  Dry Valley  Dry Valley  33.55455  -97.69086   \n",
       "10403558    10403558    5067201  Dry Valley  Dry Valley  41.47862  -99.37427   \n",
       "10403559    10403559    5067202  Dry Valley  Dry Valley  41.87723  -99.61484   \n",
       "10523436    10523436    5187424  Dry Valley  Dry Valley  40.62674  -77.55694   \n",
       "10628958    10628958    5293350  Dry Valley  Dry Valley  34.09893 -110.06761   \n",
       "10679523    10679523    5344132  Dry Valley  Dry Valley  39.95824 -120.01631   \n",
       "10679525    10679525    5344134  Dry Valley  Dry Valley  32.66867 -116.68557   \n",
       "10679526    10679526    5344135  Dry Valley  Dry Valley  36.62134 -118.99677   \n",
       "10838112    10838112    5503261  Dry Valley  Dry Valley  37.86052 -114.32304   \n",
       "10838114    10838114    5503263  Dry Valley  Dry Valley  38.99493 -116.33618   \n",
       "10873233    10873233    5538502  Dry Valley  Dry Valley  37.64970 -112.67355   \n",
       "10873234    10873234    5538503  Dry Valley  Dry Valley  37.51137 -112.72522   \n",
       "10873236    10873236    5538505  Dry Valley  Dry Valley  37.37554 -112.18464   \n",
       "10873237    10873237    5538506  Dry Valley  Dry Valley  38.23693 -109.43345   \n",
       "10873238    10873238    5538507  Dry Valley  Dry Valley  39.86524 -111.11711   \n",
       "10873239    10873239    5538508  Dry Valley  Dry Valley  38.37387 -110.62709   \n",
       "10873240    10873240    5538509  Dry Valley  Dry Valley  38.44276 -111.63241   \n",
       "10897410    10897410    5562903  Dry Valley  Dry Valley  40.84240 -120.62690   \n",
       "10925990    10925990    5591628  Dry Valley  Dry Valley  42.77409 -111.35855   \n",
       "11028730    11028730    5694948  Dry Valley  Dry Valley  42.24194 -100.95377   \n",
       "11028735    11028735    5694953  Dry Valley  Dry Valley  42.24472 -101.02266   \n",
       "11037197    11037197    5703449  Dry Valley  Dry Valley  40.20907 -119.83187   \n",
       "11057895    11057895    5724224  Dry Valley  Dry Valley  43.09765 -119.70829   \n",
       "11057896    11057896    5724225  Dry Valley  Dry Valley  42.15682 -120.77497   \n",
       "12045722    12045722     892082  Dry Valley  Dry Valley -20.14062   29.60043   \n",
       "12055619    12055619    7505407  Dry Valley  Dry Valley -20.08405   29.44430   \n",
       "\n",
       "         country code  \n",
       "9408946            US  \n",
       "9408947            US  \n",
       "9408952            US  \n",
       "9541058            US  \n",
       "9638922            US  \n",
       "9638924            US  \n",
       "9701920            US  \n",
       "9732723            US  \n",
       "9732724            US  \n",
       "9732725            US  \n",
       "9959959            US  \n",
       "9959961            US  \n",
       "9959962            US  \n",
       "9959963            US  \n",
       "9959964            US  \n",
       "9959965            US  \n",
       "9959966            US  \n",
       "9959967            US  \n",
       "10027276           US  \n",
       "10027279           US  \n",
       "10403558           US  \n",
       "10403559           US  \n",
       "10523436           US  \n",
       "10628958           US  \n",
       "10679523           US  \n",
       "10679525           US  \n",
       "10679526           US  \n",
       "10838112           US  \n",
       "10838114           US  \n",
       "10873233           US  \n",
       "10873234           US  \n",
       "10873236           US  \n",
       "10873237           US  \n",
       "10873238           US  \n",
       "10873239           US  \n",
       "10873240           US  \n",
       "10897410           US  \n",
       "10925990           US  \n",
       "11028730           US  \n",
       "11028735           US  \n",
       "11037197           US  \n",
       "11057895           US  \n",
       "11057896           US  \n",
       "12045722           ZW  \n",
       "12055619           ZW  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GeoNames[GeoNames.name == 'Dry Valley']"
   ]
  },
  {
   "cell_type": "code",
>>>>>>> Stashed changes
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": true,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": true,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}