Skip to content

Instantly share code, notes, and snippets.

@alabrashJr

alabrashJr/geocoding

Created August 9, 2019 21:38
Show Gist options
  • Save alabrashJr/5c8559acd1459c18fb0add8db5022aab to your computer and use it in GitHub Desktop.
Save alabrashJr/5c8559acd1459c18fb0add8db5022aab to your computer and use it in GitHub Desktop.
Download ZIP
Raw
geocoding
{
"cells": [
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [],
"source": [
"import requests \n",
"from bs4 import BeautifulSoup\n",
"import time"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"def timeit(func):\n",
" def wrapper(*args, **kwargs):\n",
" start = time.time()\n",
" result = func(*args, **kwargs)\n",
" delta = time.time() - start\n",
" return result, delta\n",
" return wrapper"
]
},
{
"cell_type": "code",
"execution_count": 118,
"metadata": {},
"outputs": [],
"source": [
"#!/usr/bin/env python3\n",
"\n",
"#@timeit\n",
"def HTMLDic(c,html):\n",
" if html==None:\n",
" return {\"City\":c,\n",
" \"Country\":float(\"nan\") , \n",
" \"Population\":float(\"nan\") ,#soup[3].text.split()[-1],\n",
" \"latitude\":float(\"nan\"),\n",
" \"longitude\":float(\"nan\")\n",
" }\n",
" soup = BeautifulSoup(html,'lxml').findAll(\"td\")\n",
" if(len(soup[3].text.split(\"population\"))>1):\n",
" po=float(soup[3].text.split(\"population\")[1].strip().split()[0].rstrip(',').replace(\",\",\"\"))\n",
" else:\n",
" po=float(\"nan\") \n",
" dic={\"City\":c,\n",
" \"Country\":soup[2].text.rstrip(\"\\n\"), \n",
" \"Population\":po,#soup[3].text.split()[-1],\n",
" \"latitude\":soup[4].text,\n",
" \"longitude\":soup[5].text}\n",
" return dic\n",
"\n",
"#@timeit\n",
"def getCityHTML(c):\n",
" html=None\n",
" try:\n",
" URL = \"http://www.geonames.org/search.html?q=$&country=\"\n",
" HEADERS={\"Host\": \"www.geonames.org\",\n",
" \"Connection\": \"keep-alive\",\n",
" \"Upgrade-Insecure-Requests\": \"1\",\n",
" \"Accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3\",\n",
" \"Referer\": \"http://www.geonames.org/istanbul.html\",\n",
" \"Accept-Encoding\": \"gzip, deflate\",\n",
" \"Accept-Language\":\"en-US,en;q=0.9,ar;q=0.8,tr;q=0.7\"\n",
" }\n",
" URL=URL.replace(\"$\",c)\n",
" # sending get request and saving the response as response object \n",
" r = requests.get(url = URL,headers=HEADERS) \n",
" soup = BeautifulSoup(r.text,'lxml')\n",
" table=soup.find(\"table\", {\"class\":\"restable\"}).findAll(\"tr\")\n",
" for cell in range(2,len(table)-2):\n",
" if table[cell].findAll(\"td\")[1].find(\"a\",href=True).text==c : \n",
" html=str(table[cell])\n",
" break\n",
" except Exception: \n",
" return 0\n",
" return html\n",
"\n",
"@timeit\n",
"def cityDic(c):\n",
" #print(getCityHTML(c))\n",
" o=getCityHTML(c)\n",
" \n",
" if o!=0 :return HTMLDic(c,o)\n",
" return {'City': c,\n",
" 'Country': 'None',\n",
" \"Population\":float(\"nan\") ,\n",
" \"latitude\":float(\"nan\"),\n",
" \"longitude\":float(\"nan\")\n",
" }\n"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"wc=pd.read_csv(\"/Users/abdulrhmanalabrash/Downloads/simplemaps_worldcities_basicv1.5/worldcities.csv\")"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"12959"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"wc[\"city_ascii\"].count()"
]
},
{
"cell_type": "code",
"execution_count": 150,
"metadata": {
"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>City</th>\n",
" <th>Country</th>\n",
" <th>Population</th>\n",
" <th>latitude</th>\n",
" <th>longitude</th>\n",
" <th>time_to_execute(sec)</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Malisheve</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2.322156</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Prizren</td>\n",
" <td>Kosovo, PrizrenPrizren</td>\n",
" <td>171464.0</td>\n",
" <td>N 42° 12' 50''</td>\n",
" <td>E 20° 44' 23''</td>\n",
" <td>1.140796</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Zubin Potok</td>\n",
" <td>Kosovo, MitrovicaKomuna e Zubin Potokut</td>\n",
" <td>14900.0</td>\n",
" <td>N 42° 54' 52''</td>\n",
" <td>E 20° 41' 23''</td>\n",
" <td>0.543971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Kamenice</td>\n",
" <td>Montenegro,</td>\n",
" <td>NaN</td>\n",
" <td>N 42° 49' 33''</td>\n",
" <td>E 18° 52' 1''</td>\n",
" <td>0.674163</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Viti</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1.311455</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" City Country Population \\\n",
"0 Malisheve NaN NaN \n",
"1 Prizren Kosovo, PrizrenPrizren 171464.0 \n",
"2 Zubin Potok Kosovo, MitrovicaKomuna e Zubin Potokut 14900.0 \n",
"3 Kamenice Montenegro, NaN \n",
"4 Viti NaN NaN \n",
"\n",
" latitude longitude time_to_execute(sec) \n",
"0 NaN NaN 2.322156 \n",
"1 N 42° 12' 50'' E 20° 44' 23'' 1.140796 \n",
"2 N 42° 54' 52'' E 20° 41' 23'' 0.543971 \n",
"3 N 42° 49' 33'' E 18° 52' 1'' 0.674163 \n",
"4 NaN NaN 1.311455 "
]
},
"execution_count": 150,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#places = [\"Istanbul\",\"Ankara\",\"Homs\",\"Konya\",\"Izmir\",\"Paris\"]\n",
"sec_list=[]\n",
"plist=[]\n",
"#placesList=[print(\"get the info of {} model fit in {:0.3f} seconds\".format(cityDic(city)[1])) for city in places]\n",
"for x in wc[\"city_ascii\"][:1000]:\n",
" o=cityDic(x)\n",
" sec_list.append(o[1])\n",
" plist.append(o[0])\n",
" #print(\"it takes {1:0.3f} seconds to grap the following \\n {0} \\n \".format(o[0],o[1]))\n",
"\n",
"tdf=pd.DataFrame(plist)\n",
"tdf[\"time_to_execute(sec)\"]=sec_list\n",
"tdf.head()"
]
},
{
"cell_type": "code",
"execution_count": 151,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>City</th>\n",
" <th>Country</th>\n",
" <th>Population</th>\n",
" <th>latitude</th>\n",
" <th>longitude</th>\n",
" <th>time_to_execute(sec)</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Malisheve</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2.322156</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Prizren</td>\n",
" <td>Kosovo, PrizrenPrizren</td>\n",
" <td>171464.0</td>\n",
" <td>N 42° 12' 50''</td>\n",
" <td>E 20° 44' 23''</td>\n",
" <td>1.140796</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Zubin Potok</td>\n",
" <td>Kosovo, MitrovicaKomuna e Zubin Potokut</td>\n",
" <td>14900.0</td>\n",
" <td>N 42° 54' 52''</td>\n",
" <td>E 20° 41' 23''</td>\n",
" <td>0.543971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Kamenice</td>\n",
" <td>Montenegro,</td>\n",
" <td>NaN</td>\n",
" <td>N 42° 49' 33''</td>\n",
" <td>E 18° 52' 1''</td>\n",
" <td>0.674163</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Viti</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1.311455</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" City Country Population \\\n",
"0 Malisheve NaN NaN \n",
"1 Prizren Kosovo, PrizrenPrizren 171464.0 \n",
"2 Zubin Potok Kosovo, MitrovicaKomuna e Zubin Potokut 14900.0 \n",
"3 Kamenice Montenegro, NaN \n",
"4 Viti NaN NaN \n",
"\n",
" latitude longitude time_to_execute(sec) \n",
"0 NaN NaN 2.322156 \n",
"1 N 42° 12' 50'' E 20° 44' 23'' 1.140796 \n",
"2 N 42° 54' 52'' E 20° 41' 23'' 0.543971 \n",
"3 N 42° 49' 33'' E 18° 52' 1'' 0.674163 \n",
"4 NaN NaN 1.311455 "
]
},
"execution_count": 151,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tdf=pd.DataFrame(plist)\n",
"tdf[\"time_to_execute(sec)\"]=sec_list\n",
"tdf.head()"
]
},
{
"cell_type": "code",
"execution_count": 152,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"City 1000\n",
"Country 737\n",
"Population 602\n",
"latitude 720\n",
"longitude 720\n",
"time_to_execute(sec) 1000\n",
"dtype: int64"
]
},
"execution_count": 152,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tdf.count()"
]
},
{
"cell_type": "code",
"execution_count": 153,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>City</th>\n",
" <th>Country</th>\n",
" <th>Population</th>\n",
" <th>latitude</th>\n",
" <th>longitude</th>\n",
" <th>time_to_execute(sec)</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Prizren</td>\n",
" <td>Kosovo, PrizrenPrizren</td>\n",
" <td>171464.0</td>\n",
" <td>N 42° 12' 50''</td>\n",
" <td>E 20° 44' 23''</td>\n",
" <td>1.140796</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Zubin Potok</td>\n",
" <td>Kosovo, MitrovicaKomuna e Zubin Potokut</td>\n",
" <td>14900.0</td>\n",
" <td>N 42° 54' 52''</td>\n",
" <td>E 20° 41' 23''</td>\n",
" <td>0.543971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Shtime</td>\n",
" <td>Kosovo, FerizajKomuna e Shtimes</td>\n",
" <td>35000.0</td>\n",
" <td>N 42° 25' 59''</td>\n",
" <td>E 21° 2' 23''</td>\n",
" <td>0.912598</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Vushtrri</td>\n",
" <td>Kosovo, MitrovicaVushtrri</td>\n",
" <td>30651.0</td>\n",
" <td>N 42° 49' 23''</td>\n",
" <td>E 20° 58' 3''</td>\n",
" <td>1.515382</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Dragash</td>\n",
" <td>Kosovo, PrizrenKomuna e Dragashit</td>\n",
" <td>35000.0</td>\n",
" <td>N 42° 1' 35''</td>\n",
" <td>E 20° 39' 12''</td>\n",
" <td>1.854550</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" City Country Population \\\n",
"1 Prizren Kosovo, PrizrenPrizren 171464.0 \n",
"2 Zubin Potok Kosovo, MitrovicaKomuna e Zubin Potokut 14900.0 \n",
"6 Shtime Kosovo, FerizajKomuna e Shtimes 35000.0 \n",
"7 Vushtrri Kosovo, MitrovicaVushtrri 30651.0 \n",
"8 Dragash Kosovo, PrizrenKomuna e Dragashit 35000.0 \n",
"\n",
" latitude longitude time_to_execute(sec) \n",
"1 N 42° 12' 50'' E 20° 44' 23'' 1.140796 \n",
"2 N 42° 54' 52'' E 20° 41' 23'' 0.543971 \n",
"6 N 42° 25' 59'' E 21° 2' 23'' 0.912598 \n",
"7 N 42° 49' 23'' E 20° 58' 3'' 1.515382 \n",
"8 N 42° 1' 35'' E 20° 39' 12'' 1.854550 "
]
},
"execution_count": 153,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tdf[tdf[\"Population\"].notna()].head()"
]
},
{
"cell_type": "code",
"execution_count": 158,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"1000 cites' information crawled in 12.978 minutes \n",
"sucessful rate is 72.0%\n"
]
}
],
"source": [
"print(\"{2} cites' informations crawled in {0:0.3f} minutes \\nsucessful rate is {3}%\".format(tdf[\"time_to_execute(sec)\"].sum()/60,len(tdf[tdf[\"latitude\"].notna()]),len(tdf),(len(tdf[tdf[\"latitude\"].notna()])/len(tdf))*100 )\n",
" )"
]
},
{
"cell_type": "code",
"execution_count": 160,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda3/lib/python3.6/site-packages/IPython/core/interactiveshell.py:3018: DtypeWarning: Columns (8,9,10,11,12,13) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
]
},
{
"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>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>10</th>\n",
" <th>11</th>\n",
" <th>12</th>\n",
" <th>13</th>\n",
" <th>14</th>\n",
" <th>15</th>\n",
" <th>16</th>\n",
" <th>17</th>\n",
" <th>18</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>Pic de Font Blanca,Pic du Port</td>\n",
" <td>42.64991</td>\n",
" <td>1.53335</td>\n",
" <td>T</td>\n",
" <td>PK</td>\n",
" <td>AD</td>\n",
" <td>NaN</td>\n",
" <td>00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>2860</td>\n",
" <td>Europe/Andorra</td>\n",
" <td>2014-11-05</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>Roc Mele,Roc Meler,Roc Mélé</td>\n",
" <td>42.58765</td>\n",
" <td>1.74028</td>\n",
" <td>T</td>\n",
" <td>MT</td>\n",
" <td>AD</td>\n",
" <td>AD,FR</td>\n",
" <td>00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>2803</td>\n",
" <td>Europe/Andorra</td>\n",
" <td>2014-11-05</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>Pic des Langounelles</td>\n",
" <td>42.61203</td>\n",
" <td>1.47364</td>\n",
" <td>T</td>\n",
" <td>PK</td>\n",
" <td>AD</td>\n",
" <td>AD,FR</td>\n",
" <td>00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>2685</td>\n",
" <td>Europe/Andorra</td>\n",
" <td>2014-11-05</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>Pic de la Font-Negre,Pic de la Font-Nègre,Pic ...</td>\n",
" <td>42.52535</td>\n",
" <td>1.73343</td>\n",
" <td>T</td>\n",
" <td>PK</td>\n",
" <td>AD</td>\n",
" <td>FR</td>\n",
" <td>A9</td>\n",
" <td>66</td>\n",
" <td>663</td>\n",
" <td>66146</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>2411</td>\n",
" <td>Europe/Andorra</td>\n",
" <td>2014-11-05</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>Estany de les Abelletes,Etang de Font-Negre,Ét...</td>\n",
" <td>42.52915</td>\n",
" <td>1.73362</td>\n",
" <td>H</td>\n",
" <td>LK</td>\n",
" <td>AD</td>\n",
" <td>FR</td>\n",
" <td>A9</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>2260</td>\n",
" <td>Europe/Andorra</td>\n",
" <td>2014-11-05</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 0 1 2 \\\n",
"0 2986043 Pic de Font Blanca Pic de Font Blanca \n",
"1 2994701 Roc Mélé Roc Mele \n",
"2 3007683 Pic des Langounelles Pic des Langounelles \n",
"3 3017832 Pic de les Abelletes Pic de les Abelletes \n",
"4 3017833 Estany de les Abelletes Estany de les Abelletes \n",
"\n",
" 3 4 5 6 \\\n",
"0 Pic de Font Blanca,Pic du Port 42.64991 1.53335 T \n",
"1 Roc Mele,Roc Meler,Roc Mélé 42.58765 1.74028 T \n",
"2 Pic des Langounelles 42.61203 1.47364 T \n",
"3 Pic de la Font-Negre,Pic de la Font-Nègre,Pic ... 42.52535 1.73343 T \n",
"4 Estany de les Abelletes,Etang de Font-Negre,Ét... 42.52915 1.73362 H \n",
"\n",
" 7 8 9 10 11 12 13 14 15 16 17 \\\n",
"0 PK AD NaN 00 NaN NaN NaN 0 NaN 2860 Europe/Andorra \n",
"1 MT AD AD,FR 00 NaN NaN NaN 0 NaN 2803 Europe/Andorra \n",
"2 PK AD AD,FR 00 NaN NaN NaN 0 NaN 2685 Europe/Andorra \n",
"3 PK AD FR A9 66 663 66146 0 NaN 2411 Europe/Andorra \n",
"4 LK AD FR A9 NaN NaN NaN 0 NaN 2260 Europe/Andorra \n",
"\n",
" 18 \n",
"0 2014-11-05 \n",
"1 2014-11-05 \n",
"2 2014-11-05 \n",
"3 2014-11-05 \n",
"4 2014-11-05 "
]
},
"execution_count": 160,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"all_co=pd.read_csv(\"/Users/abdulrhmanalabrash/Downloads/allCountries 2.txt\",sep=\"\\t\",header=None)\n",
"all_co.head()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"# The main 'geoname' table has the following fields :\n",
"# ---------------------------------------------------\n",
"# geonameid : integer id of record in geonames database\n",
"# name : name of geographical point (utf8) varchar(200)\n",
"# asciiname : name of geographical point in plain ascii characters, varchar(200)\n",
"# alternatenames : alternatenames, comma separated, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000)\n",
"# latitude : latitude in decimal degrees (wgs84)\n",
"# longitude : longitude in decimal degrees (wgs84)\n",
"# feature class : see http://www.geonames.org/export/codes.html, char(1)\n",
"# feature code : see http://www.geonames.org/export/codes.html, varchar(10)\n",
"# country code : ISO-3166 2-letter country code, 2 characters\n",
"# cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 200 characters\n",
"# admin1 code : fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)\n",
"# admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80) \n",
"# admin3 code : code for third level administrative division, varchar(20)\n",
"# admin4 code : code for fourth level administrative division, varchar(20)\n",
"# population : bigint (8 byte int) \n",
"# elevation : in meters, integer\n",
"# dem : digital elevation model, srtm3 or gtopo30, average elevation of 3''x3'' (ca 90mx90m) or 30''x30'' (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.\n",
"# timezone : the iana timezone id (see file timeZone.txt) varchar(40)\n",
"# modification date : date of last modification in yyyy-MM-dd format"
]
},
{
"cell_type": "code",
"execution_count": 175,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>10</th>\n",
" <th>11</th>\n",
" <th>12</th>\n",
" <th>13</th>\n",
" <th>14</th>\n",
" <th>15</th>\n",
" <th>16</th>\n",
" <th>17</th>\n",
" <th>18</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3237017</th>\n",
" <td>615742</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>42.55685</td>\n",
" <td>43.39720</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>GE</td>\n",
" <td>NaN</td>\n",
" <td>70</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>1184</td>\n",
" <td>Asia/Tbilisi</td>\n",
" <td>2015-02-06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717142</th>\n",
" <td>1073231</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-25.46667</td>\n",
" <td>45.68333</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52514</td>\n",
" <td>5.2514e+07</td>\n",
" <td>5.2514e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>92</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717143</th>\n",
" <td>1073232</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-25.43333</td>\n",
" <td>45.71667</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52514</td>\n",
" <td>5.25141e+07</td>\n",
" <td>5.25141e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>70</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717144</th>\n",
" <td>1073233</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-25.28333</td>\n",
" <td>45.61667</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52514</td>\n",
" <td>5.2514e+07</td>\n",
" <td>5.2514e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>101</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717145</th>\n",
" <td>1073234</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-25.16667</td>\n",
" <td>45.70000</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52516</td>\n",
" <td>5.25161e+07</td>\n",
" <td>5.25161e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>192</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717146</th>\n",
" <td>1073235</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-25.10000</td>\n",
" <td>46.38333</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>53</td>\n",
" <td>53519</td>\n",
" <td>5.3519e+07</td>\n",
" <td>5.3519e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>36</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717147</th>\n",
" <td>1073236</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-24.80000</td>\n",
" <td>45.10000</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52513</td>\n",
" <td>5.25131e+07</td>\n",
" <td>5.25131e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>260</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717148</th>\n",
" <td>1073237</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-24.80000</td>\n",
" <td>45.08333</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52513</td>\n",
" <td>5.25131e+07</td>\n",
" <td>5.25131e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>241</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717149</th>\n",
" <td>1073238</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-24.26667</td>\n",
" <td>46.21667</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>53</td>\n",
" <td>53519</td>\n",
" <td>5.35192e+07</td>\n",
" <td>5.35193e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>178</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717150</th>\n",
" <td>1073239</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-23.48333</td>\n",
" <td>45.15000</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>51</td>\n",
" <td>51521</td>\n",
" <td>5.1521e+07</td>\n",
" <td>5.1521e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>322</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717151</th>\n",
" <td>1073240</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-22.93333</td>\n",
" <td>47.35000</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>25</td>\n",
" <td>25217</td>\n",
" <td>2.5217e+07</td>\n",
" <td>2.5217e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>196</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717152</th>\n",
" <td>1073241</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-21.45000</td>\n",
" <td>45.46667</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>51</td>\n",
" <td>51503</td>\n",
" <td>5.15031e+07</td>\n",
" <td>5.15031e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>194</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717153</th>\n",
" <td>1073242</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-17.03333</td>\n",
" <td>44.90000</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>44</td>\n",
" <td>44402</td>\n",
" <td>4.44021e+07</td>\n",
" <td>4.44021e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>148</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717154</th>\n",
" <td>1073243</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-24.83333</td>\n",
" <td>45.05000</td>\n",
" <td>L</td>\n",
" <td>LCTY</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52513</td>\n",
" <td>5.25131e+07</td>\n",
" <td>5.25131e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>214</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717155</th>\n",
" <td>1073244</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-22.75000</td>\n",
" <td>45.75000</td>\n",
" <td>L</td>\n",
" <td>LCTY</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>53</td>\n",
" <td>53517</td>\n",
" <td>5.35173e+07</td>\n",
" <td>5.35173e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>903</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717156</th>\n",
" <td>1073245</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-16.61667</td>\n",
" <td>46.86667</td>\n",
" <td>L</td>\n",
" <td>LCTY</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>41</td>\n",
" <td>41405</td>\n",
" <td>4.1405e+07</td>\n",
" <td>4.1405e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>38</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5717157</th>\n",
" <td>1073246</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-16.63333</td>\n",
" <td>46.86667</td>\n",
" <td>T</td>\n",
" <td>HLL</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>41</td>\n",
" <td>41405</td>\n",
" <td>4.1405e+07</td>\n",
" <td>4.1405e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>42</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5738696</th>\n",
" <td>11935964</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-23.48299</td>\n",
" <td>45.14828</td>\n",
" <td>A</td>\n",
" <td>ADM4</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>51</td>\n",
" <td>51521</td>\n",
" <td>5.1521e+07</td>\n",
" <td>5.1521e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>326</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5741713</th>\n",
" <td>11938981</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-18.03576</td>\n",
" <td>44.20897</td>\n",
" <td>A</td>\n",
" <td>ADM4</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>44</td>\n",
" <td>44421</td>\n",
" <td>4.44210e+07</td>\n",
" <td>4.44211e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>34</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5745705</th>\n",
" <td>11942973</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>-25.46009</td>\n",
" <td>45.69254</td>\n",
" <td>A</td>\n",
" <td>ADM4</td>\n",
" <td>MG</td>\n",
" <td>NaN</td>\n",
" <td>52</td>\n",
" <td>52514</td>\n",
" <td>5.2514e+07</td>\n",
" <td>5.2514e+10</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>74</td>\n",
" <td>Indian/Antananarivo</td>\n",
" <td>2018-09-07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6476324</th>\n",
" <td>2447653</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>12.93197</td>\n",
" <td>1.88233</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>NE</td>\n",
" <td>NaN</td>\n",
" <td>9</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>228</td>\n",
" <td>Africa/Niamey</td>\n",
" <td>2013-05-08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6553447</th>\n",
" <td>10641662</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>NaN</td>\n",
" <td>9.05064</td>\n",
" <td>7.86824</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>NG</td>\n",
" <td>NaN</td>\n",
" <td>56</td>\n",
" <td>26004</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>398</td>\n",
" <td>Africa/Lagos</td>\n",
" <td>2016-01-30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9079098</th>\n",
" <td>323784</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>Ancara,Angora,Anguriyah,Ankara,Ankara Province...</td>\n",
" <td>39.92063</td>\n",
" <td>32.85403</td>\n",
" <td>A</td>\n",
" <td>ADM1</td>\n",
" <td>TR</td>\n",
" <td>NaN</td>\n",
" <td>68</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>5045083</td>\n",
" <td>NaN</td>\n",
" <td>871</td>\n",
" <td>Europe/Istanbul</td>\n",
" <td>2017-11-29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9079100</th>\n",
" <td>323786</td>\n",
" <td>Ankara</td>\n",
" <td>Ankara</td>\n",
" <td>ANK,Anakara,Ancara,Ancyra,Ang-ka-la,Angkara,An...</td>\n",
" <td>39.91987</td>\n",
" <td>32.85427</td>\n",
" <td>P</td>\n",
" <td>PPLC</td>\n",
" <td>TR</td>\n",
" <td>NaN</td>\n",
" <td>68</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>3517182</td>\n",
" <td>850.0</td>\n",
" <td>874</td>\n",
" <td>Europe/Istanbul</td>\n",
" <td>2013-03-08</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 0 1 2 \\\n",
"3237017 615742 Ankara Ankara \n",
"5717142 1073231 Ankara Ankara \n",
"5717143 1073232 Ankara Ankara \n",
"5717144 1073233 Ankara Ankara \n",
"5717145 1073234 Ankara Ankara \n",
"5717146 1073235 Ankara Ankara \n",
"5717147 1073236 Ankara Ankara \n",
"5717148 1073237 Ankara Ankara \n",
"5717149 1073238 Ankara Ankara \n",
"5717150 1073239 Ankara Ankara \n",
"5717151 1073240 Ankara Ankara \n",
"5717152 1073241 Ankara Ankara \n",
"5717153 1073242 Ankara Ankara \n",
"5717154 1073243 Ankara Ankara \n",
"5717155 1073244 Ankara Ankara \n",
"5717156 1073245 Ankara Ankara \n",
"5717157 1073246 Ankara Ankara \n",
"5738696 11935964 Ankara Ankara \n",
"5741713 11938981 Ankara Ankara \n",
"5745705 11942973 Ankara Ankara \n",
"6476324 2447653 Ankara Ankara \n",
"6553447 10641662 Ankara Ankara \n",
"9079098 323784 Ankara Ankara \n",
"9079100 323786 Ankara Ankara \n",
"\n",
" 3 4 \\\n",
"3237017 NaN 42.55685 \n",
"5717142 NaN -25.46667 \n",
"5717143 NaN -25.43333 \n",
"5717144 NaN -25.28333 \n",
"5717145 NaN -25.16667 \n",
"5717146 NaN -25.10000 \n",
"5717147 NaN -24.80000 \n",
"5717148 NaN -24.80000 \n",
"5717149 NaN -24.26667 \n",
"5717150 NaN -23.48333 \n",
"5717151 NaN -22.93333 \n",
"5717152 NaN -21.45000 \n",
"5717153 NaN -17.03333 \n",
"5717154 NaN -24.83333 \n",
"5717155 NaN -22.75000 \n",
"5717156 NaN -16.61667 \n",
"5717157 NaN -16.63333 \n",
"5738696 NaN -23.48299 \n",
"5741713 NaN -18.03576 \n",
"5745705 NaN -25.46009 \n",
"6476324 NaN 12.93197 \n",
"6553447 NaN 9.05064 \n",
"9079098 Ancara,Angora,Anguriyah,Ankara,Ankara Province... 39.92063 \n",
"9079100 ANK,Anakara,Ancara,Ancyra,Ang-ka-la,Angkara,An... 39.91987 \n",
"\n",
" 5 6 7 8 9 10 11 12 13 \\\n",
"3237017 43.39720 P PPL GE NaN 70 NaN NaN NaN \n",
"5717142 45.68333 P PPL MG NaN 52 52514 5.2514e+07 5.2514e+10 \n",
"5717143 45.71667 P PPL MG NaN 52 52514 5.25141e+07 5.25141e+10 \n",
"5717144 45.61667 P PPL MG NaN 52 52514 5.2514e+07 5.2514e+10 \n",
"5717145 45.70000 P PPL MG NaN 52 52516 5.25161e+07 5.25161e+10 \n",
"5717146 46.38333 P PPL MG NaN 53 53519 5.3519e+07 5.3519e+10 \n",
"5717147 45.10000 P PPL MG NaN 52 52513 5.25131e+07 5.25131e+10 \n",
"5717148 45.08333 P PPL MG NaN 52 52513 5.25131e+07 5.25131e+10 \n",
"5717149 46.21667 P PPL MG NaN 53 53519 5.35192e+07 5.35193e+10 \n",
"5717150 45.15000 P PPL MG NaN 51 51521 5.1521e+07 5.1521e+10 \n",
"5717151 47.35000 P PPL MG NaN 25 25217 2.5217e+07 2.5217e+10 \n",
"5717152 45.46667 P PPL MG NaN 51 51503 5.15031e+07 5.15031e+10 \n",
"5717153 44.90000 P PPL MG NaN 44 44402 4.44021e+07 4.44021e+10 \n",
"5717154 45.05000 L LCTY MG NaN 52 52513 5.25131e+07 5.25131e+10 \n",
"5717155 45.75000 L LCTY MG NaN 53 53517 5.35173e+07 5.35173e+10 \n",
"5717156 46.86667 L LCTY MG NaN 41 41405 4.1405e+07 4.1405e+10 \n",
"5717157 46.86667 T HLL MG NaN 41 41405 4.1405e+07 4.1405e+10 \n",
"5738696 45.14828 A ADM4 MG NaN 51 51521 5.1521e+07 5.1521e+10 \n",
"5741713 44.20897 A ADM4 MG NaN 44 44421 4.44210e+07 4.44211e+10 \n",
"5745705 45.69254 A ADM4 MG NaN 52 52514 5.2514e+07 5.2514e+10 \n",
"6476324 1.88233 P PPL NE NaN 9 NaN NaN NaN \n",
"6553447 7.86824 P PPL NG NaN 56 26004 NaN NaN \n",
"9079098 32.85403 A ADM1 TR NaN 68 NaN NaN NaN \n",
"9079100 32.85427 P PPLC TR NaN 68 NaN NaN NaN \n",
"\n",
" 14 15 16 17 18 \n",
"3237017 0 NaN 1184 Asia/Tbilisi 2015-02-06 \n",
"5717142 0 NaN 92 Indian/Antananarivo 2018-09-10 \n",
"5717143 0 NaN 70 Indian/Antananarivo 2018-09-10 \n",
"5717144 0 NaN 101 Indian/Antananarivo 2018-09-10 \n",
"5717145 0 NaN 192 Indian/Antananarivo 2018-09-10 \n",
"5717146 0 NaN 36 Indian/Antananarivo 2018-09-10 \n",
"5717147 0 NaN 260 Indian/Antananarivo 2018-09-10 \n",
"5717148 0 NaN 241 Indian/Antananarivo 2018-09-10 \n",
"5717149 0 NaN 178 Indian/Antananarivo 2018-09-10 \n",
"5717150 0 NaN 322 Indian/Antananarivo 2018-09-10 \n",
"5717151 0 NaN 196 Indian/Antananarivo 2018-09-10 \n",
"5717152 0 NaN 194 Indian/Antananarivo 2018-09-10 \n",
"5717153 0 NaN 148 Indian/Antananarivo 2018-09-10 \n",
"5717154 0 NaN 214 Indian/Antananarivo 2018-09-10 \n",
"5717155 0 NaN 903 Indian/Antananarivo 2018-09-10 \n",
"5717156 0 NaN 38 Indian/Antananarivo 2018-09-10 \n",
"5717157 0 NaN 42 Indian/Antananarivo 2018-09-10 \n",
"5738696 0 NaN 326 Indian/Antananarivo 2018-09-07 \n",
"5741713 0 NaN 34 Indian/Antananarivo 2018-09-07 \n",
"5745705 0 NaN 74 Indian/Antananarivo 2018-09-07 \n",
"6476324 0 NaN 228 Africa/Niamey 2013-05-08 \n",
"6553447 0 NaN 398 Africa/Lagos 2016-01-30 \n",
"9079098 5045083 NaN 871 Europe/Istanbul 2017-11-29 \n",
"9079100 3517182 850.0 874 Europe/Istanbul 2013-03-08 "
]
},
"execution_count": 175,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"all_co[all_co[1].str.match(r\"Ankara$\")]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"@webio": {
"lastCommId": null,
"lastKernelId": null
},
"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.6.4"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment