data_wrangling_xml_exercise.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# XML example and exercise\n",
    "****\n",
    "+ study examples of accessing nodes in XML tree structure  \n",
    "+ work on exercise to be completed and submitted\n",
    "****\n",
    "+ reference: https://docs.python.org/2.7/library/xml.etree.elementtree.html\n",
    "+ data source: http://www.dbis.informatik.uni-goettingen.de/Mondial\n",
    "****"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from xml.etree import ElementTree as ET"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## XML example\n",
    "\n",
    "+ for details about tree traversal and iterators, see https://docs.python.org/2.7/library/xml.etree.elementtree.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "document_tree = ET.parse('E:\\Data Science\\Assignments\\data_wrangling_xml\\data\\mondial_database_less.xml' )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Albania\n",
      "Greece\n",
      "Macedonia\n",
      "Serbia\n",
      "Montenegro\n",
      "Kosovo\n",
      "Andorra\n"
     ]
    }
   ],
   "source": [
    "# print names of all countries\n",
    "for child in document_tree.getroot():\n",
    "    print (child.find('name').text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "* Albania:\n",
      "Tirana, Shkodër, Durrës, Vlorë, Elbasan, Korçë\n",
      "* Greece:\n",
      "Komotini, Kavala, Athina, Peiraias, Peristeri, Acharnes, Patra, Kozani, Kerkyra, Ioannina, Thessaloniki, Iraklio, Chania, Ermoupoli, Rhodes, Tripoli, Lamia, Chalkida, Larissa, Volos, Mytilini, Karyes\n",
      "* Macedonia:\n",
      "Skopje, Kumanovo\n",
      "* Serbia:\n",
      "Beograd, Novi Sad, Niš\n",
      "* Montenegro:\n",
      "Podgorica\n",
      "* Kosovo:\n",
      "Prishtine\n",
      "* Andorra:\n",
      "Andorra la Vella\n"
     ]
    }
   ],
   "source": [
    "# print names of all countries and their cities\n",
    "for element in document_tree.iterfind('country'):\n",
    "    print('* ' + element.find('name').text + ':',)\n",
    "    capitals_string = ''\n",
    "    for subelement in element.getiterator('city'):\n",
    "        capitals_string += subelement.find('name').text + ', '\n",
    "    print(capitals_string[:-2])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "****\n",
    "## XML exercise\n",
    "\n",
    "Using data in 'data/mondial_database.xml', the examples above, and refering to https://docs.python.org/2.7/library/xml.etree.elementtree.html, find\n",
    "\n",
    "1. 10 countries with the lowest infant mortality rates\n",
    "2. 10 cities with the largest population\n",
    "3. 10 ethnic groups with the largest overall populations (sum of best/latest estimates over all countries)\n",
    "4. name and country of a) longest river, b) largest lake and c) airport at highest elevation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "document = ET.parse( 'E:\\Data Science\\Assignments\\data_wrangling_xml\\data\\mondial_database.xml' )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1. 10 countries with the lowest infant mortality rates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Element 'mondial' at 0x000001EDDEE03638>"
      ]
     },
     "execution_count": 181,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# root is an instance of Element class\n",
    "root = document.getroot()\n",
    "root"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Create an empty dictionary lim\n",
    "lim = {}\n",
    "# Loop through each subelement in element country\n",
    "for el in document.iter('country'):\n",
    "    # Get the name of each country\n",
    "    cntry = el.find('name')\n",
    "    # Get the infant_mortality of each country\n",
    "    inf = el.find('infant_mortality')\n",
    "    if cntry is not None:\n",
    "        if inf is not None:\n",
    "            # Create a key value pair and fill the dictionary \n",
    "            lim[cntry.text] = float(inf.text)\n",
    "        #else:\n",
    "            #lim[cntry.text] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Afghanistan': 117.23,\n",
       " 'Albania': 13.19,\n",
       " 'Algeria': 21.76,\n",
       " 'American Samoa': 8.92,\n",
       " 'Andorra': 3.69,\n",
       " 'Angola': 79.99,\n",
       " 'Anguilla': 3.4,\n",
       " 'Antigua and Barbuda': 13.29,\n",
       " 'Argentina': 9.96,\n",
       " 'Armenia': 13.97,\n",
       " 'Aruba': 11.74,\n",
       " 'Australia': 4.43,\n",
       " 'Austria': 4.16,\n",
       " 'Azerbaijan': 26.67,\n",
       " 'Bahamas': 12.5,\n",
       " 'Bahrain': 9.68,\n",
       " 'Bangladesh': 45.67,\n",
       " 'Barbados': 10.93,\n",
       " 'Belarus': 3.64,\n",
       " 'Belgium': 4.18,\n",
       " 'Belize': 20.31,\n",
       " 'Benin': 57.09,\n",
       " 'Bermuda': 2.48,\n",
       " 'Bhutan': 37.89,\n",
       " 'Bolivia': 38.61,\n",
       " 'Bosnia and Herzegovina': 5.84,\n",
       " 'Botswana': 9.38,\n",
       " 'Brazil': 19.21,\n",
       " 'British Virgin Islands': 13.45,\n",
       " 'Brunei': 10.48,\n",
       " 'Bulgaria': 15.08,\n",
       " 'Burkina Faso': 76.8,\n",
       " 'Burundi': 63.44,\n",
       " 'Cambodia': 51.36,\n",
       " 'Cameroon': 55.1,\n",
       " 'Canada': 4.71,\n",
       " 'Cape Verde': 24.28,\n",
       " 'Cayman Islands': 6.21,\n",
       " 'Central African Republic': 92.86,\n",
       " 'Chad': 90.3,\n",
       " 'Chile': 7.02,\n",
       " 'China': 14.79,\n",
       " 'Colombia': 15.02,\n",
       " 'Comoros': 65.31,\n",
       " 'Congo': 59.34,\n",
       " 'Cook Islands': 14.33,\n",
       " 'Costa Rica': 8.7,\n",
       " 'Cote dIvoire': 60.16,\n",
       " 'Croatia': 5.87,\n",
       " 'Cuba': 4.7,\n",
       " 'Cyprus': 8.54,\n",
       " 'Czech Republic': 2.63,\n",
       " 'Denmark': 4.1,\n",
       " 'Djibouti': 50.2,\n",
       " 'Dominica': 11.61,\n",
       " 'Dominican Republic': 19.63,\n",
       " 'Ecuador': 17.93,\n",
       " 'Egypt': 22.41,\n",
       " 'El Salvador': 18.44,\n",
       " 'Equatorial Guinea': 71.12,\n",
       " 'Eritrea': 38.44,\n",
       " 'Estonia': 6.7,\n",
       " 'Ethiopia': 55.77,\n",
       " 'Faroe Islands': 5.71,\n",
       " 'Fiji': 10.2,\n",
       " 'Finland': 3.36,\n",
       " 'France': 3.31,\n",
       " 'French Guiana': 14.6,\n",
       " 'French Polynesia': 4.78,\n",
       " 'Gabon': 47.03,\n",
       " 'Gambia': 65.74,\n",
       " 'Gaza Strip': 30.6,\n",
       " 'Georgia': 16.68,\n",
       " 'Germany': 3.46,\n",
       " 'Ghana': 38.52,\n",
       " 'Gibraltar': 6.29,\n",
       " 'Greece': 4.78,\n",
       " 'Greenland': 9.42,\n",
       " 'Grenada': 10.5,\n",
       " 'Guadeloupe': 8.3,\n",
       " 'Guam': 5.51,\n",
       " 'Guatemala': 23.51,\n",
       " 'Guernsey': 3.47,\n",
       " 'Guinea': 55.24,\n",
       " 'Guinea-Bissau': 90.92,\n",
       " 'Guyana': 33.56,\n",
       " 'Haiti': 49.43,\n",
       " 'Honduras': 18.72,\n",
       " 'Hong Kong': 2.73,\n",
       " 'Hungary': 5.09,\n",
       " 'Iceland': 3.15,\n",
       " 'India': 43.19,\n",
       " 'Indonesia': 25.16,\n",
       " 'Iran': 39.0,\n",
       " 'Iraq': 37.53,\n",
       " 'Ireland': 3.74,\n",
       " 'Isle of Man': 4.17,\n",
       " 'Israel': 3.98,\n",
       " 'Italy': 3.31,\n",
       " 'Jamaica': 13.69,\n",
       " 'Japan': 2.13,\n",
       " 'Jersey': 3.86,\n",
       " 'Jordan': 15.73,\n",
       " 'Kazakhstan': 21.61,\n",
       " 'Kenya': 40.71,\n",
       " 'Kiribati': 35.37,\n",
       " 'Kuwait': 7.51,\n",
       " 'Kyrgyzstan': 28.71,\n",
       " 'Laos': 54.53,\n",
       " 'Latvia': 7.91,\n",
       " 'Lebanon': 7.98,\n",
       " 'Lesotho': 50.48,\n",
       " 'Liberia': 69.19,\n",
       " 'Libya': 11.87,\n",
       " 'Liechtenstein': 4.33,\n",
       " 'Lithuania': 6.0,\n",
       " 'Luxembourg': 4.28,\n",
       " 'Macao': 3.13,\n",
       " 'Macedonia': 7.9,\n",
       " 'Madagascar': 44.88,\n",
       " 'Malawi': 48.01,\n",
       " 'Malaysia': 13.69,\n",
       " 'Maldives': 24.59,\n",
       " 'Mali': 104.34,\n",
       " 'Malta': 3.59,\n",
       " 'Marshall Islands': 21.39,\n",
       " 'Martinique': 7.1,\n",
       " 'Mauritania': 56.06,\n",
       " 'Mauritius': 10.59,\n",
       " 'Mayotte': 56.29,\n",
       " 'Mexico': 12.58,\n",
       " 'Micronesia': 21.93,\n",
       " 'Moldova': 12.93,\n",
       " 'Monaco': 1.81,\n",
       " 'Mongolia': 23.15,\n",
       " 'Montserrat': 13.66,\n",
       " 'Morocco': 24.52,\n",
       " 'Mozambique': 72.42,\n",
       " 'Myanmar': 44.91,\n",
       " 'Namibia': 45.64,\n",
       " 'Nauru': 8.21,\n",
       " 'Nepal': 40.43,\n",
       " 'Netherlands': 3.66,\n",
       " 'New Caledonia': 5.46,\n",
       " 'New Zealand': 4.59,\n",
       " 'Nicaragua': 20.36,\n",
       " 'Niger': 86.27,\n",
       " 'Nigeria': 74.09,\n",
       " 'North Korea': 24.5,\n",
       " 'Northern Mariana Islands': 5.5,\n",
       " 'Norway': 2.48,\n",
       " 'Oman': 14.0,\n",
       " 'Pakistan': 57.48,\n",
       " 'Palau': 11.46,\n",
       " 'Panama': 10.7,\n",
       " 'Papua New Guinea': 39.67,\n",
       " 'Paraguay': 20.75,\n",
       " 'Peru': 20.21,\n",
       " 'Philippines': 17.64,\n",
       " 'Poland': 6.19,\n",
       " 'Portugal': 4.48,\n",
       " 'Puerto Rico': 7.73,\n",
       " 'Qatar': 6.42,\n",
       " 'Reunion': 7.5,\n",
       " 'Romania': 10.16,\n",
       " 'Russia': 7.08,\n",
       " 'Rwanda': 59.59,\n",
       " 'Saint Helena': 17.63,\n",
       " 'Saint Kitts and Nevis': 8.98,\n",
       " 'Saint Lucia': 11.75,\n",
       " 'Saint Pierre and Miquelon': 6.95,\n",
       " 'Saint Vincent and the Grenadines': 13.07,\n",
       " 'Samoa': 20.5,\n",
       " 'San Marino': 4.52,\n",
       " 'Sao Tome and Principe': 49.16,\n",
       " 'Saudi Arabia': 14.58,\n",
       " 'Senegal': 52.72,\n",
       " 'Serbia': 6.16,\n",
       " 'Seychelles': 10.77,\n",
       " 'Sierra Leone': 73.29,\n",
       " 'Singapore': 2.53,\n",
       " 'Sint Maarten': 9.05,\n",
       " 'Slovakia': 5.35,\n",
       " 'Slovenia': 4.04,\n",
       " 'Solomon Islands': 16.17,\n",
       " 'Somalia': 100.14,\n",
       " 'South Africa': 41.61,\n",
       " 'South Korea': 3.93,\n",
       " 'South Sudan': 68.16,\n",
       " 'Spain': 3.33,\n",
       " 'Sri Lanka': 9.02,\n",
       " 'Sudan': 52.86,\n",
       " 'Suriname': 27.07,\n",
       " 'Swaziland': 54.82,\n",
       " 'Sweden': 2.6,\n",
       " 'Switzerland': 3.73,\n",
       " 'Syria': 15.79,\n",
       " 'Taiwan': 4.49,\n",
       " 'Tajikistan': 35.03,\n",
       " 'Tanzania': 43.74,\n",
       " 'Thailand': 9.86,\n",
       " 'Timor-Leste': 38.79,\n",
       " 'Togo': 46.73,\n",
       " 'Tonga': 12.36,\n",
       " 'Trinidad and Tobago': 24.82,\n",
       " 'Tunisia': 23.19,\n",
       " 'Turkey': 21.43,\n",
       " 'Turkmenistan': 38.13,\n",
       " 'Turks and Caicos Islands': 10.97,\n",
       " 'Tuvalu': 31.69,\n",
       " 'Uganda': 60.82,\n",
       " 'Ukraine': 8.1,\n",
       " 'United Arab Emirates': 10.92,\n",
       " 'United Kingdom': 4.44,\n",
       " 'United States': 6.17,\n",
       " 'Uruguay': 8.97,\n",
       " 'Uzbekistan': 19.84,\n",
       " 'Vanuatu': 16.41,\n",
       " 'Venezuela': 19.33,\n",
       " 'Vietnam': 18.99,\n",
       " 'Virgin Islands': 6.79,\n",
       " 'Wallis and Futuna': 4.49,\n",
       " 'West Bank': 28.6,\n",
       " 'Western Sahara': 145.82,\n",
       " 'Yemen': 50.41,\n",
       " 'Zaire': 73.15,\n",
       " 'Zambia': 66.62,\n",
       " 'Zimbabwe': 26.55}"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lim"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 184,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Create a DataFrame (infdf) from the dictionary (lim)\n",
    "infdf = pd.DataFrame(list(lim.items()), columns=['Country', 'Infant_Mortality'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>Infant_Mortality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Albania</td>\n",
       "      <td>13.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Greece</td>\n",
       "      <td>4.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Macedonia</td>\n",
       "      <td>7.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Serbia</td>\n",
       "      <td>6.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>3.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>France</td>\n",
       "      <td>3.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Spain</td>\n",
       "      <td>3.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Austria</td>\n",
       "      <td>4.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>2.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Germany</td>\n",
       "      <td>3.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>5.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Italy</td>\n",
       "      <td>3.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>4.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>5.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>4.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>3.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Belarus</td>\n",
       "      <td>3.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Latvia</td>\n",
       "      <td>7.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lithuania</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Poland</td>\n",
       "      <td>6.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>8.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Russia</td>\n",
       "      <td>7.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>4.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>4.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Netherlands</td>\n",
       "      <td>3.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>5.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>5.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>15.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Romania</td>\n",
       "      <td>10.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Turkey</td>\n",
       "      <td>21.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>Chad</td>\n",
       "      <td>90.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>Equatorial Guinea</td>\n",
       "      <td>71.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>Gabon</td>\n",
       "      <td>47.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>Cape Verde</td>\n",
       "      <td>24.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Sudan</td>\n",
       "      <td>52.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>South Sudan</td>\n",
       "      <td>68.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>Comoros</td>\n",
       "      <td>65.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>Guinea</td>\n",
       "      <td>55.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Liberia</td>\n",
       "      <td>69.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>Djibouti</td>\n",
       "      <td>50.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>Eritrea</td>\n",
       "      <td>38.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>55.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>Somalia</td>\n",
       "      <td>100.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>Kenya</td>\n",
       "      <td>40.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>Gambia</td>\n",
       "      <td>65.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>Senegal</td>\n",
       "      <td>52.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>90.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>73.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>Uganda</td>\n",
       "      <td>60.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>Lesotho</td>\n",
       "      <td>50.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>Madagascar</td>\n",
       "      <td>44.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Malawi</td>\n",
       "      <td>48.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>Mozambique</td>\n",
       "      <td>72.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>Mauritius</td>\n",
       "      <td>10.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Mayotte</td>\n",
       "      <td>56.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Swaziland</td>\n",
       "      <td>54.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>Reunion</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Saint Helena</td>\n",
       "      <td>17.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>Sao Tome and Principe</td>\n",
       "      <td>49.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>Seychelles</td>\n",
       "      <td>10.77</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>228 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Country  Infant_Mortality\n",
       "0                   Albania             13.19\n",
       "1                    Greece              4.78\n",
       "2                 Macedonia              7.90\n",
       "3                    Serbia              6.16\n",
       "4                   Andorra              3.69\n",
       "5                    France              3.31\n",
       "6                     Spain              3.33\n",
       "7                   Austria              4.16\n",
       "8            Czech Republic              2.63\n",
       "9                   Germany              3.46\n",
       "10                  Hungary              5.09\n",
       "11                    Italy              3.31\n",
       "12            Liechtenstein              4.33\n",
       "13                 Slovakia              5.35\n",
       "14                 Slovenia              4.04\n",
       "15              Switzerland              3.73\n",
       "16                  Belarus              3.64\n",
       "17                   Latvia              7.91\n",
       "18                Lithuania              6.00\n",
       "19                   Poland              6.19\n",
       "20                  Ukraine              8.10\n",
       "21                   Russia              7.08\n",
       "22                  Belgium              4.18\n",
       "23               Luxembourg              4.28\n",
       "24              Netherlands              3.66\n",
       "25   Bosnia and Herzegovina              5.84\n",
       "26                  Croatia              5.87\n",
       "27                 Bulgaria             15.08\n",
       "28                  Romania             10.16\n",
       "29                   Turkey             21.43\n",
       "..                      ...               ...\n",
       "198                    Chad             90.30\n",
       "199       Equatorial Guinea             71.12\n",
       "200                   Gabon             47.03\n",
       "201              Cape Verde             24.28\n",
       "202                   Sudan             52.86\n",
       "203             South Sudan             68.16\n",
       "204                 Comoros             65.31\n",
       "205                  Guinea             55.24\n",
       "206                 Liberia             69.19\n",
       "207                Djibouti             50.20\n",
       "208                 Eritrea             38.44\n",
       "209                Ethiopia             55.77\n",
       "210                 Somalia            100.14\n",
       "211                   Kenya             40.71\n",
       "212                  Gambia             65.74\n",
       "213                 Senegal             52.72\n",
       "214           Guinea-Bissau             90.92\n",
       "215            Sierra Leone             73.29\n",
       "216                  Uganda             60.82\n",
       "217                 Lesotho             50.48\n",
       "218              Madagascar             44.88\n",
       "219                  Malawi             48.01\n",
       "220              Mozambique             72.42\n",
       "221               Mauritius             10.59\n",
       "222                 Mayotte             56.29\n",
       "223               Swaziland             54.82\n",
       "224                 Reunion              7.50\n",
       "225            Saint Helena             17.63\n",
       "226   Sao Tome and Principe             49.16\n",
       "227              Seychelles             10.77\n",
       "\n",
       "[228 rows x 2 columns]"
      ]
     },
     "execution_count": 185,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "infdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>Infant_Mortality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Monaco</td>\n",
       "      <td>1.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Japan</td>\n",
       "      <td>2.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Bermuda</td>\n",
       "      <td>2.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Norway</td>\n",
       "      <td>2.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Singapore</td>\n",
       "      <td>2.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>2.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>2.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>2.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Macao</td>\n",
       "      <td>3.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>3.15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Country  Infant_Mortality\n",
       "36           Monaco              1.81\n",
       "90            Japan              2.13\n",
       "109         Bermuda              2.48\n",
       "34           Norway              2.48\n",
       "98        Singapore              2.53\n",
       "35           Sweden              2.60\n",
       "8    Czech Republic              2.63\n",
       "72        Hong Kong              2.73\n",
       "73            Macao              3.13\n",
       "39          Iceland              3.15"
      ]
     },
     "execution_count": 186,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sort the countries with lowest infant mortality rates and display the first 'ten' in the list\n",
    "infdf = infdf.sort_values('Infant_Mortality').head(10)\n",
    "infdf"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2. 10 cities with the largest population"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Looking carefully at the XML Document tree, one can notice that some cities are subelements to the subelement province.\n",
    "# To retrieve those cities and population I defined the path \"./country/province/city\"\n",
    "#Create a dictionary 'provdict'\n",
    "provdict = {}\n",
    "for cty in document.findall(\"./country/province/city\"):\n",
    "    # Retreive all the names of the cities, and corresponding population figures\n",
    "    name = cty.find('name')\n",
    "    pop = cty.findall('population')\n",
    "    if pop:\n",
    "        # To retrieve the most recent year's population\n",
    "        provdict[name.text] = int(pop[len(pop)-1].text)    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Kavala': 58790,\n",
       " 'Athina': 664046,\n",
       " 'Peiraias': 163688,\n",
       " 'Peristeri': 139981,\n",
       " 'Acharnes': 106943,\n",
       " 'Patra': 213984,\n",
       " 'Kerkyra': 102071,\n",
       " 'Ioannina': 112486,\n",
       " 'Thessaloniki': 325182,\n",
       " 'Iraklio': 173993,\n",
       " 'Chania': 108642,\n",
       " 'Rhodes': 115490,\n",
       " 'Lamia': 75315,\n",
       " 'Chalkida': 102223,\n",
       " 'Larissa': 162591,\n",
       " 'Volos': 144449,\n",
       " 'Karyes': 233,\n",
       " 'Strasbourg': 272222,\n",
       " 'Mulhouse': 110351,\n",
       " 'Bordeaux': 239399,\n",
       " 'Clermont-Ferrand': 140957,\n",
       " 'Caen': 108793,\n",
       " 'Rennes': 208033,\n",
       " 'Brest': 309764,\n",
       " 'Dijon': 151672,\n",
       " 'Orléans': 114185,\n",
       " 'Tours': 134633,\n",
       " 'Reims': 180752,\n",
       " 'Ajaccio': 66245,\n",
       " 'Besançon': 115879,\n",
       " 'Rouen': 111553,\n",
       " 'Le Havre': 174156,\n",
       " 'Paris': 2249975,\n",
       " 'Boulogne-Billancourt': 116220,\n",
       " 'Argenteuil': 104282,\n",
       " 'Montreuil': 103068,\n",
       " 'Saint-Paul': 103916,\n",
       " 'Montpellier': 264538,\n",
       " 'Nîmes': 144940,\n",
       " 'Perpignan': 118238,\n",
       " 'Limoges': 137758,\n",
       " 'Metz': 119962,\n",
       " 'Nancy': 105382,\n",
       " 'Toulouse': 447340,\n",
       " 'Lille': 227533,\n",
       " 'Nantes': 287845,\n",
       " 'Angers': 148803,\n",
       " 'Le Mans': 143240,\n",
       " 'Amiens': 133327,\n",
       " 'Poitiers': 87646,\n",
       " 'Marseille': 850636,\n",
       " 'Nice': 344064,\n",
       " 'Toulon': 163974,\n",
       " 'Aix-en-Provence': 140684,\n",
       " 'Lyon': 491268,\n",
       " 'Grenoble': 157424,\n",
       " 'Saint-Étienne': 170049,\n",
       " 'Villeurbanne': 145034,\n",
       " 'Sevilla': 698042,\n",
       " 'Almería': 189680,\n",
       " 'Cádiz': 124014,\n",
       " 'Córdoba': 1267774,\n",
       " 'Granada': 241003,\n",
       " 'Huelva': 147808,\n",
       " 'Málaga': 561435,\n",
       " 'Jerez de la Frontera': 211784,\n",
       " 'Jaén': 116469,\n",
       " 'Algeciras': 117695,\n",
       " 'Marbella': 135124,\n",
       " 'Dos Hermanas': 128433,\n",
       " 'Zaragoza': 678115,\n",
       " 'Oviedo': 225005,\n",
       " 'Gijón': 276969,\n",
       " 'Palma de Mallorca': 402044,\n",
       " 'Vitoria-Gasteiz': 240753,\n",
       " 'Bilbao': 351356,\n",
       " 'Barakaldo': 100064,\n",
       " 'Donostia': 185512,\n",
       " 'Santa Cruz de Tenerife': 204476,\n",
       " 'San Cristóbal de La Laguna': 152025,\n",
       " 'Las Palmas de Gran Canaria': 381271,\n",
       " 'Telde': 101080,\n",
       " 'Santander': 178095,\n",
       " 'Valladolid': 311682,\n",
       " 'Burgos': 178864,\n",
       " 'León': 1238962,\n",
       " 'Salamanca': 160169,\n",
       " 'Albacete': 171999,\n",
       " 'Barcelona': 410643,\n",
       " 'Lleida': 137283,\n",
       " 'Tarragona': 133223,\n",
       " 'Reus': 106849,\n",
       " 'Hospitalet de Llobregat': 256509,\n",
       " 'Badalona': 219241,\n",
       " 'Sabadell': 206949,\n",
       " 'Terrassa': 214406,\n",
       " 'Santa Coloma de Gramenet': 119391,\n",
       " 'Mataró': 123367,\n",
       " 'Badajoz': 151214,\n",
       " 'A Coruña': 245053,\n",
       " 'Vigo': 295623,\n",
       " 'Ourense': 107314,\n",
       " 'Madrid': 3198645,\n",
       " 'Móstoles': 203493,\n",
       " 'Leganés': 185758,\n",
       " 'Alcalá de Henares': 200505,\n",
       " 'Fuenlabrada': 196986,\n",
       " 'Getafe': 168642,\n",
       " 'Alcorcón': 167217,\n",
       " 'Torrejón de Ardoz': 123213,\n",
       " 'Parla': 122045,\n",
       " 'Alcobendas': 110351,\n",
       " 'Murcia': 437667,\n",
       " 'Cartagena': 990179,\n",
       " 'Pamplona': 195943,\n",
       " 'Logroño': 152698,\n",
       " 'Valencia': 832229,\n",
       " 'Alicante': 329325,\n",
       " 'Elche': 227417,\n",
       " 'Castellón de la Plana': 176298,\n",
       " 'Eisenstadt': 13485,\n",
       " 'Klagenfurt': 96531,\n",
       " 'Villach': 59942,\n",
       " 'Wien': 1761738,\n",
       " 'Linz': 193511,\n",
       " 'Wels': 59239,\n",
       " 'Innsbruck': 124386,\n",
       " 'Graz': 269211,\n",
       " 'Salzburg': 146676,\n",
       " 'St. Pölten': 52100,\n",
       " 'Praha': 1289556,\n",
       " 'České Budějovice': 95589,\n",
       " 'Brno': 404820,\n",
       " 'Karlovy Vary': 53310,\n",
       " 'Jihlava': 51162,\n",
       " 'Hradec Králové': 95594,\n",
       " 'Liberec': 104973,\n",
       " 'Ostrava': 311508,\n",
       " 'Olomouc': 101954,\n",
       " 'Pardubice': 90844,\n",
       " 'Plzeň': 171346,\n",
       " 'Ústí nad Labem': 98596,\n",
       " 'Zlín': 77137,\n",
       " 'Stuttgart': 585890,\n",
       " 'Mannheim': 290117,\n",
       " 'Karlsruhe': 289173,\n",
       " 'Freiburg': 209628,\n",
       " 'Heidelberg': 146751,\n",
       " 'Heilbronn': 116059,\n",
       " 'Pforzheim': 114411,\n",
       " 'Ulm': 116761,\n",
       " 'Reutlingen': 109799,\n",
       " 'München': 1348335,\n",
       " 'Nürnberg': 486314,\n",
       " 'Augsburg': 267767,\n",
       " 'Würzburg': 124297,\n",
       " 'Regensburg': 135403,\n",
       " 'Ingolstadt': 124927,\n",
       " 'Fürth': 115613,\n",
       " 'Erlangen': 103719,\n",
       " 'Berlin': 3292365,\n",
       " 'Potsdam': 156021,\n",
       " 'Cottbus': 99984,\n",
       " 'Bremen': 542707,\n",
       " 'Bremerhaven': 108156,\n",
       " 'Hamburg': 1706696,\n",
       " 'Wiesbaden': 269121,\n",
       " 'Frankfurt am Main': 667925,\n",
       " 'Kassel': 190765,\n",
       " 'Darmstadt': 143499,\n",
       " 'Offenbach am Main': 113443,\n",
       " 'Schwerin': 91293,\n",
       " 'Rostock': 200265,\n",
       " 'Hannover': 506416,\n",
       " 'Braunschweig': 242537,\n",
       " 'Osnabrück': 153699,\n",
       " 'Oldenburg': 157267,\n",
       " 'Göttingen': 115843,\n",
       " 'Wolfsburg': 119984,\n",
       " 'Salzgitter': 98895,\n",
       " 'Hildesheim': 99554,\n",
       " 'Düsseldorf': 586291,\n",
       " 'Köln': 1005775,\n",
       " 'Essen': 566201,\n",
       " 'Dortmund': 571143,\n",
       " 'Duisburg': 488468,\n",
       " 'Bochum': 362286,\n",
       " 'Wuppertal': 342661,\n",
       " 'Bielefeld': 326870,\n",
       " 'Gelsenkirchen': 258766,\n",
       " 'Bonn': 305765,\n",
       " 'Mönchengladbach': 255188,\n",
       " 'Münster': 289576,\n",
       " 'Krefeld': 222247,\n",
       " 'Aachen': 236420,\n",
       " 'Oberhausen': 210216,\n",
       " 'Hagen': 187944,\n",
       " 'Hamm': 176037,\n",
       " 'Herne': 155160,\n",
       " 'Mülheim an der Ruhr': 166865,\n",
       " 'Solingen': 155265,\n",
       " 'Leverkusen': 158984,\n",
       " 'Neuss': 150568,\n",
       " 'Paderborn': 142365,\n",
       " 'Recklinghausen': 115958,\n",
       " 'Remscheid': 110708,\n",
       " 'Bottrop': 117311,\n",
       " 'Siegen': 99187,\n",
       " 'Moers': 104009,\n",
       " 'Witten': 96382,\n",
       " 'Bergisch Gladbach': 108878,\n",
       " 'Mainz': 200344,\n",
       " 'Ludwigshafen': 157584,\n",
       " 'Koblenz': 107825,\n",
       " 'Kaiserslautern': 96340,\n",
       " 'Trier': 105671,\n",
       " 'Saarbrücken': 175853,\n",
       " 'Dresden': 512354,\n",
       " 'Leipzig': 502979,\n",
       " 'Chemnitz': 240253,\n",
       " 'Zwickau': 93081,\n",
       " 'Magdeburg': 228144,\n",
       " 'Halle': 229153,\n",
       " 'Kiel': 235782,\n",
       " 'Lübeck': 210305,\n",
       " 'Erfurt': 200868,\n",
       " 'Gera': 96067,\n",
       " 'Jena': 105739,\n",
       " 'Pécs': 156049,\n",
       " 'Kecskemét': 111411,\n",
       " 'Békéscsaba': 62050,\n",
       " 'Miskolc': 167754,\n",
       " 'Szeged': 168048,\n",
       " 'Székesfehérvár': 100570,\n",
       " 'Győr': 129527,\n",
       " 'Debrecen': 211320,\n",
       " 'Eger': 56569,\n",
       " 'Tatabánya': 67753,\n",
       " 'Kaposvár': 66245,\n",
       " 'Nyíregyháza': 119746,\n",
       " 'Szolnok': 72953,\n",
       " 'Szombathely': 78884,\n",
       " 'Veszprém': 61721,\n",
       " 'Zalaegerszeg': 59499,\n",
       " 'Budapest': 1729040,\n",
       " 'Novara': 101952,\n",
       " 'Torino': 872367,\n",
       " 'Bérgamo': 115349,\n",
       " 'Bréscia': 189902,\n",
       " 'Milano': 1242123,\n",
       " 'Monza': 119856,\n",
       " 'Bolzano': 102575,\n",
       " 'Trento': 114198,\n",
       " 'Pádova': 206192,\n",
       " 'Verona': 252520,\n",
       " 'Vicenza': 111500,\n",
       " 'Venézia': 261362,\n",
       " 'Trieste': 202123,\n",
       " 'La Spezia': 92659,\n",
       " 'Génova': 586180,\n",
       " 'Bologna': 371337,\n",
       " 'Ferrara': 132545,\n",
       " 'Forlí': 116434,\n",
       " 'Módena': 179149,\n",
       " 'Parma': 175895,\n",
       " 'Piacenza': 100311,\n",
       " 'Ravenna': 153740,\n",
       " \"Réggio nell'Emilia\": 162082,\n",
       " 'Rímini': 139601,\n",
       " 'Livorno': 157052,\n",
       " 'Pisa': 85858,\n",
       " 'Firenze': 358079,\n",
       " 'Prato': 185456,\n",
       " 'Perúgia': 162449,\n",
       " 'Terni': 109193,\n",
       " 'Ancona': 100497,\n",
       " 'Roma': 2617175,\n",
       " 'Latina': 117892,\n",
       " 'Pescara': 117166,\n",
       " 'Salerno': 132608,\n",
       " 'Nápoli': 962003,\n",
       " 'Torre del Greco': 85922,\n",
       " 'Giugliano in Campania': 108793,\n",
       " 'Bari': 315933,\n",
       " 'Fóggia': 147036,\n",
       " 'Lecce': 89916,\n",
       " 'Andria': 100052,\n",
       " 'Táranto': 200154,\n",
       " 'Catanzaro': 89364,\n",
       " 'Cosenza': 69484,\n",
       " 'Réggio di Calabria': 180817,\n",
       " 'Palermo': 657561,\n",
       " 'Messina': 243262,\n",
       " 'Catánia': 293902,\n",
       " 'Siracusa': 118385,\n",
       " 'Cágliari': 149883,\n",
       " 'Sássari': 123782,\n",
       " 'Bratislava': 411228,\n",
       " 'Banská Bystrica': 80003,\n",
       " 'Žilina': 81494,\n",
       " 'Košice': 240433,\n",
       " 'Prešov': 91782,\n",
       " 'Nitra': 78916,\n",
       " 'Trenčín': 55877,\n",
       " 'Trnava': 66358,\n",
       " 'Basel': 167386,\n",
       " 'Bern': 128848,\n",
       " 'Biel': 53031,\n",
       " 'Genève': 191557,\n",
       " 'Luzern': 80501,\n",
       " 'Sankt Gallen': 74581,\n",
       " 'Lugano': 62792,\n",
       " 'Lausanne': 132788,\n",
       " 'Zürich': 384786,\n",
       " 'Winterthur': 105676,\n",
       " 'Vitebsk': 347928,\n",
       " 'Gomel': 482652,\n",
       " 'Grodno': 327540,\n",
       " 'Mogilev': 358279,\n",
       " 'Bobruysk': 215092,\n",
       " 'Minsk': 1836808,\n",
       " 'Wrocław': 631377,\n",
       " 'Legnica': 102708,\n",
       " 'Wałbrzych': 119216,\n",
       " 'Bydgoszcz': 362286,\n",
       " 'Toruń': 204847,\n",
       " 'Grudziadz': 98726,\n",
       " 'Włocławek': 115982,\n",
       " 'Lublin': 348120,\n",
       " 'Zielona Góra': 119182,\n",
       " 'Gorzów Wielkopolski': 124470,\n",
       " 'Łódź': 722022,\n",
       " 'Kraków': 759131,\n",
       " 'Tarnów': 113188,\n",
       " 'Warszawa': 1711324,\n",
       " 'Płock': 124048,\n",
       " 'Radom': 220062,\n",
       " 'Opole': 122120,\n",
       " 'Rzeszów': 180776,\n",
       " 'Białystok': 294675,\n",
       " 'Gdańsk': 460354,\n",
       " 'Gdynia': 248574,\n",
       " 'Katowice': 308269,\n",
       " 'Jastrzebie Zdroj': 92465,\n",
       " 'Sosnowiec': 214488,\n",
       " 'Dąbrowa Górnicza': 125063,\n",
       " 'Bytom': 175377,\n",
       " 'Gliwice': 186347,\n",
       " 'Zabrze': 179861,\n",
       " 'Tychy': 129087,\n",
       " 'Ruda Śląska': 142672,\n",
       " 'Rybnik': 140863,\n",
       " 'Chorzów': 111314,\n",
       " 'Częstochowa': 235156,\n",
       " 'Bielsko-Biała': 174291,\n",
       " 'Kielce': 201363,\n",
       " 'Olsztyn': 175482,\n",
       " 'Elbląg': 123977,\n",
       " 'Poznań': 552393,\n",
       " 'Kalisz': 104867,\n",
       " 'Szczecin': 409211,\n",
       " 'Koszalin': 109183,\n",
       " 'Cherkasy': 286163,\n",
       " 'Chernihiv': 296723,\n",
       " 'Chernivtsi': 255929,\n",
       " 'Dnipropetrovs´k': 999577,\n",
       " 'Kryvyi Rih': 660203,\n",
       " 'Dniprodzerzhyns´k': 242646,\n",
       " 'Nikopol´': 120000,\n",
       " 'Donets´k': 955041,\n",
       " 'Mariupol´': 464457,\n",
       " 'Makiïvka': 356118,\n",
       " 'Horlivka': 258879,\n",
       " 'Kramators´k': 165469,\n",
       " 'Ivano-Frankivs´k': 224660,\n",
       " 'Kharkiv': 1441362,\n",
       " 'Kherson': 300666,\n",
       " 'Khmel´nyts´kyi': 263703,\n",
       " 'Prypjat': 0,\n",
       " 'Kirovohrad': 234919,\n",
       " 'Luhans´k': 427187,\n",
       " 'L´viv': 729842,\n",
       " 'Mykolaïv': 497032,\n",
       " 'Odesa': 1008162,\n",
       " 'Poltava': 297589,\n",
       " 'Kremenchuk': 226434,\n",
       " 'Rivne': 250174,\n",
       " 'Sumy': 269663,\n",
       " 'Ternopil´': 217300,\n",
       " 'Vinnytsia': 370814,\n",
       " 'Luts´k': 213063,\n",
       " 'Uzhhorod': 116556,\n",
       " 'Zaporizhzhia': 772627,\n",
       " 'Melitopol´': 156885,\n",
       " 'Zhytomyr': 271895,\n",
       " 'Simferopol´': 335582,\n",
       " 'Kerch': 145845,\n",
       " 'Kyïv': 2814258,\n",
       " 'Bila Tserkva': 210551,\n",
       " 'Sevastopol´': 340559,\n",
       " 'Petrozavodsk': 268946,\n",
       " 'Syktyvkar': 235006,\n",
       " 'Ukhta': 99591,\n",
       " 'Vorkuta': 70548,\n",
       " 'Arkhangelsk': 350985,\n",
       " 'Severodvinsk': 192353,\n",
       " 'Vologda': 306487,\n",
       " 'Cherepovets': 315738,\n",
       " 'Murmansk': 302468,\n",
       " 'Kaliningrad': 441376,\n",
       " 'Sankt Peterburg': 5028000,\n",
       " 'Velikij Novgorod': 218717,\n",
       " 'Pskov': 203279,\n",
       " 'Bryansk': 410837,\n",
       " 'Vladimir': 347930,\n",
       " 'Kovrov': 145214,\n",
       " 'Murom': 116075,\n",
       " 'Ivanovo': 409075,\n",
       " 'Kaluga': 331351,\n",
       " 'Obninsk': 104739,\n",
       " 'Kostroma': 271445,\n",
       " 'Moskva': 11979529,\n",
       " \"Podol'sk\": 187961,\n",
       " 'Železnodorožnyj': 131257,\n",
       " 'Krasnogorsk': 116896,\n",
       " \"L'ubercy\": 172525,\n",
       " 'Kolomna': 144589,\n",
       " 'Mytišči': 173160,\n",
       " \"Elektrostal'\": 155196,\n",
       " 'Serpuchov': 127041,\n",
       " 'Balašicha': 215494,\n",
       " 'Chimki': 207425,\n",
       " 'Odincovo': 138930,\n",
       " 'Orechovo-Zujevo': 120670,\n",
       " 'Noginsk': 100072,\n",
       " 'Ščëlkovo': 110411,\n",
       " 'Sergijev Posad': 111179,\n",
       " 'Korolëv': 183402,\n",
       " 'Žukovskij': 104736,\n",
       " 'Puškino': 102874,\n",
       " 'Orel': 318136,\n",
       " 'Ryazan': 527905,\n",
       " 'Smolensk': 330970,\n",
       " 'Tver': 408877,\n",
       " 'Tula': 493813,\n",
       " 'Novomoskovsk': 131386,\n",
       " 'Yaroslavl': 599169,\n",
       " 'Rybinsk': 200771,\n",
       " 'Yoshkar-Ola': 257015,\n",
       " 'Saransk': 298287,\n",
       " 'Cheboksary': 464940,\n",
       " 'Novočeboksarsk': 124097,\n",
       " 'Kirov': 483176,\n",
       " 'Nizhnii Novgorod': 1259921,\n",
       " 'Dzeržinsk': 240742,\n",
       " 'Arzamas': 106362,\n",
       " 'Belgorod': 373528,\n",
       " 'Staryj Oskol': 221085,\n",
       " 'Voronezh': 1003638,\n",
       " 'Kursk': 428741,\n",
       " 'Lipetsk': 509098,\n",
       " 'Jelec': 108404,\n",
       " 'Tambov': 281834,\n",
       " 'Elista': 103749,\n",
       " 'Kazan': 1176187,\n",
       " 'Naberezhnye Tchelny': 519025,\n",
       " 'Nižnekamsk': 234044,\n",
       " \"Al'metjevsk\": 146393,\n",
       " 'Astrakhan': 527345,\n",
       " 'Volgograd': 1018790,\n",
       " 'Volzhsky': 327356,\n",
       " 'Kamyšin': 119565,\n",
       " 'Penza': 519900,\n",
       " 'Samara': 1171598,\n",
       " 'Tolyatti': 719149,\n",
       " \"Syzran'\": 178750,\n",
       " 'Novokujbyševsk': 108438,\n",
       " 'Saratov': 839755,\n",
       " 'Balakovo': 199690,\n",
       " \"Ėngel's\": 202419,\n",
       " 'Ulyanovsk': 615306,\n",
       " 'Dimitrovgrad': 122580,\n",
       " 'Rostov-na-Donu': 1103733,\n",
       " 'Batajsk': 111843,\n",
       " 'Taganrog': 254783,\n",
       " 'Šachty': 239987,\n",
       " 'Novočerkassk': 168746,\n",
       " 'Volgodonsk': 170841,\n",
       " 'Novošachtinsk': 111075,\n",
       " 'Ufa': 1077719,\n",
       " 'Sterlitamak': 275798,\n",
       " 'Salavat': 156095,\n",
       " \"Okt'abr'skij\": 109474,\n",
       " 'Izhevsk': 632913,\n",
       " 'Sarapul': 101381,\n",
       " 'Orenburg': 556127,\n",
       " 'Orsk': 239800,\n",
       " 'Perm': 1013887,\n",
       " 'Berezniki': 156466,\n",
       " 'Majkop': 144249,\n",
       " 'Makhachkala': 576194,\n",
       " 'Derbent': 119200,\n",
       " 'Kaspijsk': 100129,\n",
       " 'Chasavjurt': 131187,\n",
       " \"Nazran'\": 93335,\n",
       " \"Nal'čik\": 240203,\n",
       " 'Čerkessk': 129069,\n",
       " 'Vladikavkaz': 308285,\n",
       " 'Grozny': 277414,\n",
       " 'Krasnodar': 784048,\n",
       " 'Sochi': 368011,\n",
       " 'Novorossiysk': 251013,\n",
       " 'Armavir': 188832,\n",
       " 'Stavropol': 412116,\n",
       " \"P'atigorsk\": 142511,\n",
       " 'Nevinnomyssk': 118360,\n",
       " 'Kislovodsk': 128553,\n",
       " 'Jessentuki': 100996,\n",
       " 'Neftekamsk': 121733,\n",
       " 'Kurgan': 325565,\n",
       " 'Yekaterinburg': 1396074,\n",
       " 'Nizhny Tagil': 358378,\n",
       " \"Kamensk-Ural'skij\": 174689,\n",
       " \"Pervoural'sk\": 124528,\n",
       " 'Chelyabinsk': 1156201,\n",
       " 'Magnitogorsk': 411880,\n",
       " 'Zlatoust': 174962,\n",
       " 'Miass': 151751,\n",
       " 'Kopejsk': 137601,\n",
       " 'Gorno Altaysk': 56933,\n",
       " 'Barnaul': 629681,\n",
       " 'Bijsk': 210115,\n",
       " 'Rubcovsk': 147002,\n",
       " 'Kemerovo': 540095,\n",
       " 'Novokuznetsk': 549182,\n",
       " 'Prokopjevsk': 210130,\n",
       " 'Novosibirsk': 1523801,\n",
       " 'Omsk': 1160670,\n",
       " 'Tomsk': 547989,\n",
       " 'Seversk': 108590,\n",
       " 'Tyumen': 634171,\n",
       " 'Ulan-Ude': 416079,\n",
       " 'Kyzyl': 109918,\n",
       " 'Abakan': 165214,\n",
       " 'Krasnoyarsk': 1016385,\n",
       " \"Noril'sk\": 175365,\n",
       " 'Ačinsk': 109155,\n",
       " 'Irkutsk': 606137,\n",
       " 'Angarsk': 233567,\n",
       " 'Bratsk': 246319,\n",
       " 'Chita': 331346,\n",
       " 'Yakutsk': 286456,\n",
       " 'Birobidzhan': 75413,\n",
       " 'Anadyr': 13045,\n",
       " 'Vladivostok': 600378,\n",
       " 'Nachodka': 159719,\n",
       " 'Ussurijsk': 158004,\n",
       " 'Khabarovsk': 593636,\n",
       " 'Komsomolsk-na-Amure': 257891,\n",
       " 'Blagoveščensk': 214390,\n",
       " 'Petropavlovsk-Kamčatskij': 179780,\n",
       " 'Magadan': 95982,\n",
       " 'Okhotsk': 4215,\n",
       " 'Južno-Sachalinsk': 181728,\n",
       " 'Khanty Mansijsk': 80151,\n",
       " 'Surgut': 325511,\n",
       " 'Nizhnevartovsk': 263228,\n",
       " 'Neftejugansk': 122855,\n",
       " 'Salekhard': 42544,\n",
       " \"Nojabr'sk\": 110620,\n",
       " 'Novyj Urengoj': 104107,\n",
       " 'Bruxelles': 168576,\n",
       " 'Schaerbeek': 130587,\n",
       " 'Molenbeek-Saint-Jean': 94653,\n",
       " 'Anderlecht': 113462,\n",
       " 'Antwerpen': 507911,\n",
       " 'Gent': 248813,\n",
       " 'Charleroi': 203753,\n",
       " 'Mons': 93941,\n",
       " 'Liège': 195931,\n",
       " 'Hasselt': 75579,\n",
       " 'Arlon': 28759,\n",
       " 'Namur': 110500,\n",
       " 'Brugge': 117577,\n",
       " 'Leuven': 97692,\n",
       " 'Groningen': 198023,\n",
       " 'Leeuwarden': 108145,\n",
       " 'Enschede': 158494,\n",
       " 'Zwolle': 123440,\n",
       " 'Lelystad': 76252,\n",
       " 'Almere': 196244,\n",
       " 'Arnhem': 150989,\n",
       " 'Nijmegen': 168810,\n",
       " 'Apeldoorn': 157540,\n",
       " 'Utrecht': 330081,\n",
       " 'Amersfoort': 151270,\n",
       " 'Amsterdam': 812895,\n",
       " 'Haarlem': 155361,\n",
       " 'Zaanstad': 151058,\n",
       " 'Hilversum': 86738,\n",
       " 'Den Haag': 509623,\n",
       " 'Rotterdam': 619180,\n",
       " 'Dordrecht': 118780,\n",
       " 'Leiden': 121387,\n",
       " \"'s-Hertogenbosch\": 143822,\n",
       " 'Eindhoven': 221279,\n",
       " 'Tilburg': 210283,\n",
       " 'Breda': 180263,\n",
       " 'Maastricht': 122243,\n",
       " 'Heerlen': 88139,\n",
       " 'Sittard-Geleen': 93726,\n",
       " 'Sarajevo': 291422,\n",
       " 'Tuzla': 120441,\n",
       " 'Zenica': 115134,\n",
       " 'Mostar': 113169,\n",
       " 'Banja Luka': 199191,\n",
       " 'Bijeljina': 114663,\n",
       " 'Brčko': 93028,\n",
       " 'Arad': 159074,\n",
       " 'Piteşti': 155383,\n",
       " 'Bacău': 144307,\n",
       " 'Oradea': 196367,\n",
       " 'Botoşani': 106847,\n",
       " 'Brăila': 180302,\n",
       " 'Braşov': 253200,\n",
       " 'Bucureşti': 1883425,\n",
       " 'Buzău': 115494,\n",
       " 'Cluj-Napoca': 324576,\n",
       " 'Constanţa': 283872,\n",
       " 'Craiova': 269506,\n",
       " 'Galaţi': 249432,\n",
       " 'Iaşi': 290422,\n",
       " 'Baia Mare': 123738,\n",
       " 'Drobeta-Turnu Severin': 92617,\n",
       " 'Târgu Mureş': 134290,\n",
       " 'Piatra-Neamţ': 85055,\n",
       " 'Ploieşti': 209945,\n",
       " 'Satu Mare': 102411,\n",
       " 'Sibiu': 147245,\n",
       " 'Suceava': 92121,\n",
       " 'Timişoara': 319279,\n",
       " 'Râmnicu Vâlcea': 98776,\n",
       " 'Adana': 1636229,\n",
       " 'Adiyaman': 217463,\n",
       " 'Afyonkarahisar': 186991,\n",
       " 'Agri': 107839,\n",
       " 'Aksaray': 186599,\n",
       " 'Amasya': 91874,\n",
       " 'Ankara': 4630735,\n",
       " 'Antalya': 1073794,\n",
       " 'Aydin': 195951,\n",
       " 'Balikesir': 267903,\n",
       " 'Batman': 348963,\n",
       " 'Bingol': 98424,\n",
       " 'Bolu': 131264,\n",
       " 'Bursa': 1734705,\n",
       " 'İnegöl': 177617,\n",
       " 'Canakkale': 111137,\n",
       " 'Corum': 231146,\n",
       " 'Denizli': 525497,\n",
       " 'Diyarbakir': 892713,\n",
       " 'Edirne': 148474,\n",
       " 'Elazig': 347857,\n",
       " 'Erzincan': 96474,\n",
       " 'Erzurum': 384399,\n",
       " 'Eskisehir': 659924,\n",
       " 'Gaziantep': 1438373,\n",
       " 'Giresun': 100712,\n",
       " 'Iskenderun': 184833,\n",
       " 'Hatay': 216960,\n",
       " 'Mersin': 876958,\n",
       " 'Tarsus': 245671,\n",
       " 'Isparta': 198385,\n",
       " 'Istanbul': 13710512,\n",
       " 'Izmir': 3401994,\n",
       " 'Karaman': 141630,\n",
       " 'Kahramanmaraş': 443575,\n",
       " 'Kars': 78100,\n",
       " 'Kastamonu': 96217,\n",
       " 'Kayseri': 1004276,\n",
       " 'Kirikkale': 192473,\n",
       " 'Luleburgaz': 105279,\n",
       " 'Kirsehir': 114244,\n",
       " 'Kocaeli': 1527407,\n",
       " 'Gebze': 290868,\n",
       " 'Konya': 1107886,\n",
       " 'Kütahya': 224898,\n",
       " 'Malatya': 426381,\n",
       " 'Manisa': 309050,\n",
       " 'Mardin': 86948,\n",
       " 'Kızıltepe': 147585,\n",
       " 'Mus': 81764,\n",
       " 'Nevsehir': 92068,\n",
       " 'Nigde': 118186,\n",
       " 'Ordu': 147913,\n",
       " 'Rize': 104508,\n",
       " 'Sakarya': 590498,\n",
       " 'Samsun': 547778,\n",
       " 'Şanlıurfa': 526247,\n",
       " 'Siirt': 135350,\n",
       " 'Sivas': 312587,\n",
       " 'Tekirdag': 150112,\n",
       " 'Çorlu': 235354,\n",
       " 'Tokat': 132437,\n",
       " 'Trabzon': 243735,\n",
       " 'Usak': 187886,\n",
       " 'Van': 370190,\n",
       " 'Yozgat': 78328,\n",
       " 'Zonguldak': 109080,\n",
       " 'Karabük': 110537,\n",
       " 'Iğdır': 82656,\n",
       " 'Yalova': 102874,\n",
       " 'Kilis': 85119,\n",
       " 'Duzce': 135557,\n",
       " 'Osmaniye': 209255,\n",
       " 'Aalborg': 104885,\n",
       " 'Århus': 252213,\n",
       " 'Randers': 61121,\n",
       " 'Vejle': 51804,\n",
       " 'Odense': 168798,\n",
       " 'Esbjerg': 71579,\n",
       " 'København': 549050,\n",
       " 'Mariehamn': 10851,\n",
       " 'Tampere': 220678,\n",
       " 'Lahti': 103396,\n",
       " 'Hämeenlinna': 67803,\n",
       " 'Kuopio': 106475,\n",
       " 'Lappeenranta': 72617,\n",
       " 'Kotka': 54714,\n",
       " 'Rovaniemi': 61244,\n",
       " 'Mikkeli': 54633,\n",
       " 'Jyväskylä': 134862,\n",
       " 'Joensuu': 74332,\n",
       " 'Oulu': 194181,\n",
       " 'Pori': 83457,\n",
       " 'Turku': 182154,\n",
       " 'Helsinki': 614535,\n",
       " 'Espoo': 261654,\n",
       " 'Vaasa': 66415,\n",
       " 'Oslo': 623966,\n",
       " 'Sandvika': 116677,\n",
       " 'Moss': 24517,\n",
       " 'Hamar': 15685,\n",
       " 'Lillehammer': 22118,\n",
       " 'Drammen': 65473,\n",
       " 'Tonsberg': 8984,\n",
       " 'Skien': 53015,\n",
       " 'Arendal': 12174,\n",
       " 'Kristiansand': 84476,\n",
       " 'Stavanger': 129191,\n",
       " 'Bergen': 267950,\n",
       " 'Hermannsverk': 706,\n",
       " 'Molde': 21448,\n",
       " 'Trondheim': 179692,\n",
       " 'Steinkjer': 20480,\n",
       " 'Svolvaer': 4500,\n",
       " 'Narvik': 18754,\n",
       " 'Bodoe': 34479,\n",
       " 'Tromsø': 70358,\n",
       " 'Hammerfest': 7089,\n",
       " 'Vadsoe': 5961,\n",
       " 'Göteborg': 526089,\n",
       " 'Vanersborg': 35804,\n",
       " 'Mariestad': 24255,\n",
       " 'Borås': 104867,\n",
       " 'Karlskrona': 59007,\n",
       " 'Gävle': 96170,\n",
       " 'Visby': 20000,\n",
       " 'Halmstad': 93231,\n",
       " 'Ostersund': 56662,\n",
       " 'Jönköping': 129478,\n",
       " 'Kalmar': 54554,\n",
       " 'Falun': 51900,\n",
       " 'Malmö': 307758,\n",
       " 'Helsingborg': 132011,\n",
       " 'Kristianstad': 80507,\n",
       " 'Lund': 112950,\n",
       " 'Växjö': 84800,\n",
       " 'Lulea': 66526,\n",
       " 'Jokkmokk': 6822,\n",
       " 'Örebro': 138952,\n",
       " 'Linköping': 148521,\n",
       " 'Norrköping': 132124,\n",
       " 'Nykoping': 64199,\n",
       " 'Eskilstuna': 98765,\n",
       " 'Stockholm': 881235,\n",
       " 'Huddinge': 101010,\n",
       " 'Uppsala': 202625,\n",
       " 'Karlstad': 86929,\n",
       " 'Umeå': 117294,\n",
       " 'Harnosand': 27287,\n",
       " 'Västerås': 140499,\n",
       " 'Aveiro': 53496,\n",
       " 'Braga': 114003,\n",
       " 'Coimbra': 118016,\n",
       " 'Leiria': 50608,\n",
       " 'Lisboa': 559248,\n",
       " 'Amadora': 89232,\n",
       " 'Barreiro': 79042,\n",
       " 'Almada': 49578,\n",
       " 'Oporto': 266790,\n",
       " 'Vila Nova de Gaia': 72576,\n",
       " 'Setúbal': 91108,\n",
       " 'Ponta Delgada': 46102,\n",
       " 'Funchal': 112362,\n",
       " 'Newcastle upon Tyne': 268064,\n",
       " 'Sunderland': 174286,\n",
       " 'Gateshead': 120046,\n",
       " 'Middlesbrough': 174700,\n",
       " 'Manchester': 109571,\n",
       " 'Wigan': 103608,\n",
       " 'Stockport': 105878,\n",
       " 'Bolton': 194189,\n",
       " 'Salford': 103886,\n",
       " 'Oldham': 96555,\n",
       " 'Rochdale': 107926,\n",
       " 'Warrington': 165456,\n",
       " 'Blackpool': 147663,\n",
       " 'Blackburn': 117963,\n",
       " 'Liverpool': 552267,\n",
       " 'Birkenhead': 142968,\n",
       " 'St Helens': 102885,\n",
       " 'Preston': 97886,\n",
       " 'Leeds': 474632,\n",
       " 'Wakefield': 99251,\n",
       " 'Bradford': 349561,\n",
       " 'Huddersfield': 162949,\n",
       " 'Sheffield': 518090,\n",
       " 'Doncaster': 109805,\n",
       " 'Rotherham': 109691,\n",
       " 'York': 152841,\n",
       " 'Kingston upon Hull': 284321,\n",
       " 'Nottingham': 289301,\n",
       " 'Northampton': 215173,\n",
       " 'Leicester': 443760,\n",
       " 'Derby': 255394,\n",
       " 'Lincoln': 258468,\n",
       " 'Birmingham': 212193,\n",
       " 'Coventry': 325949,\n",
       " 'Wolverhampton': 210319,\n",
       " 'Solihull': 123187,\n",
       " 'Stoke-on-Trent': 270726,\n",
       " 'Worcester': 181041,\n",
       " 'Sutton Coldfield': 109015,\n",
       " 'Telford': 142723,\n",
       " 'Cambridge': 145818,\n",
       " 'Peterborough': 161707,\n",
       " 'Ipswich': 144957,\n",
       " 'Chelmsford': 110507,\n",
       " 'Watford': 131982,\n",
       " 'Southend-on-Sea': 175547,\n",
       " 'Basildon': 107123,\n",
       " 'Colchester': 119441,\n",
       " 'Norwich': 186682,\n",
       " 'Luton': 211228,\n",
       " 'London': 366151,\n",
       " 'Southampton': 253651,\n",
       " 'Portsmouth': 238137,\n",
       " 'Basingstoke': 107355,\n",
       " 'Milton Keynes': 171750,\n",
       " 'High Wycombe': 120256,\n",
       " 'Brighton and Hove': 229700,\n",
       " 'Maidstone': 107627,\n",
       " 'Oxford': 159994,\n",
       " 'Reading': 218705,\n",
       " 'Slough': 155298,\n",
       " 'Eastbourne': 109185,\n",
       " 'Gillingham': 104157,\n",
       " 'Crawley': 106943,\n",
       " 'Worthing': 109120,\n",
       " 'Woking': 105367,\n",
       " 'Bristol': 535907,\n",
       " 'Plymouth': 234982,\n",
       " 'Exeter': 113507,\n",
       " 'Bournemouth': 187503,\n",
       " 'Poole': 154718,\n",
       " 'Cheltenham': 116447,\n",
       " 'Gloucester': 136362,\n",
       " 'Swindon': 182441,\n",
       " 'Edinburgh': 459366,\n",
       " 'Glasgow': 590507,\n",
       " 'Aberdeen': 195021,\n",
       " 'Dundee': 147285,\n",
       " 'Kirkwall': 6330,\n",
       " 'Lerwick': 6570,\n",
       " 'Cardiff': 335145,\n",
       " 'Swansea': 179485,\n",
       " 'Newport': 128060,\n",
       " 'Belfast': 280561,\n",
       " 'Hefei': 3310268,\n",
       " 'Huainan': 1200000,\n",
       " 'Bengbu': 449245,\n",
       " 'Wuhu': 425740,\n",
       " 'Huaibei': 366549,\n",
       " 'Maanshan': 305421,\n",
       " 'Anqing': 250718,\n",
       " 'Tongling': 228017,\n",
       " 'Fuyang': 179572,\n",
       " 'Luan': 144248,\n",
       " 'Chuxian': 125341,\n",
       " 'Chaoxian': 123676,\n",
       " 'Xuancheng': 112673,\n",
       " 'Fuzhou': 3572421,\n",
       " 'Xiamen': 3531347,\n",
       " 'Nanping': 195064,\n",
       " 'Quanzhou': 185154,\n",
       " 'Zhangzhou': 181424,\n",
       " 'Sanming': 160691,\n",
       " 'Longyan': 134481,\n",
       " 'Yongan': 111762,\n",
       " 'Lanzhou': 2628426,\n",
       " 'Tianshui': 244974,\n",
       " 'Baiyin': 204970,\n",
       " 'Wuwei': 133101,\n",
       " 'Yumen': 109234,\n",
       " 'Guangzhou': 11071424,\n",
       " 'Shantou': 5329024,\n",
       " 'Zhanjiang': 400997,\n",
       " 'Shenzhen': 10358381,\n",
       " 'Shaoguan': 350043,\n",
       " 'Chaozhou': 313469,\n",
       " 'Dongguan': 8220207,\n",
       " 'Foshan': 7194311,\n",
       " 'Zhongshan': 3121275,\n",
       " 'Jiangmen': 230587,\n",
       " 'Yangjiang': 215196,\n",
       " 'Zhaoqing': 194784,\n",
       " 'Maoming': 178683,\n",
       " 'Zhuhai': 164747,\n",
       " 'Huizhou': 2344634,\n",
       " 'Meixian': 132156,\n",
       " 'Heyuan': 120101,\n",
       " 'Shanwei': 107847,\n",
       " 'Guiyang': 3034750,\n",
       " 'Liupanshui': 363954,\n",
       " 'Zunyi': 261862,\n",
       " 'Anshun': 174142,\n",
       " 'Duyun': 132971,\n",
       " 'Kaili': 113958,\n",
       " 'Haikou': 280153,\n",
       " 'Sanya': 102820,\n",
       " 'Shijiazhuang': 2834942,\n",
       " 'Tangshan': 3372102,\n",
       " 'Handan': 1110000,\n",
       " 'Zhangjiakou': 529136,\n",
       " 'Baoding': 483155,\n",
       " 'Qinhuangdao': 364972,\n",
       " 'Xingtai': 302789,\n",
       " 'Chengde': 246799,\n",
       " 'Renqiu': 114256,\n",
       " 'Quzhou': 112373,\n",
       " 'Hengshui': 104269,\n",
       " 'Harbin': 5878939,\n",
       " 'Qiqihar': 1380000,\n",
       " 'Yichun': 151585,\n",
       " 'Jixi': 683885,\n",
       " 'Daqing': 657297,\n",
       " 'Mudanjiang': 571705,\n",
       " 'Hegang': 522747,\n",
       " 'Jiamusi': 493409,\n",
       " 'Shuangyashan': 386081,\n",
       " 'Suihua': 227881,\n",
       " 'Shangzhi': 215373,\n",
       " 'Qitaihe': 214957,\n",
       " 'Beian': 204899,\n",
       " 'Acheng': 197595,\n",
       " 'Zhaodong': 179976,\n",
       " 'Fuling': 173878,\n",
       " 'Shuangcheng': 142659,\n",
       " 'Anda': 136446,\n",
       " 'Mishan': 132744,\n",
       " 'Zhengzhou': 4253913,\n",
       " 'Luoyang': 1190000,\n",
       " 'Kaifeng': 507763,\n",
       " 'Xinxiang': 473762,\n",
       " 'Anyang': 420332,\n",
       " 'Pingdingshan': 410775,\n",
       " 'Jiaozuo': 409100,\n",
       " 'Nanyang': 243303,\n",
       " 'Hebi': 212976,\n",
       " 'Xuchang': 208815,\n",
       " 'Xinyang': 192509,\n",
       " 'Puyang': 175988,\n",
       " 'Shangqiu': 164880,\n",
       " 'Zhoukou': 146288,\n",
       " 'Luohe': 126438,\n",
       " 'Zhumadian': 123232,\n",
       " 'Sanmenxia': 120523,\n",
       " 'Wuhan': 9785388,\n",
       " 'Huangshi': 457601,\n",
       " 'Xiangfan': 410407,\n",
       " 'Yichang': 371601,\n",
       " 'Shashi': 281352,\n",
       " 'Shiyan': 273786,\n",
       " 'Cangzhou': 242708,\n",
       " 'Honghu': 190772,\n",
       " 'Echeng': 190123,\n",
       " 'Tianmen': 186332,\n",
       " 'Xiaogan': 166280,\n",
       " 'Zaoyang': 162198,\n",
       " ...}"
      ]
     },
     "execution_count": 189,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "provdict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Create DataFrame 'cpdf' from dictionary 'provdict'\n",
    "cpdf = pd.DataFrame(list(provdict.items()), columns=['City', 'Population'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#Create a dictionary 'dict'\n",
    "dict = {}\n",
    "for city in document.findall(\"./country/city\"):\n",
    "    # Retreive all the names of the cities, and thier respective population figures\n",
    "    name = city.find('name')\n",
    "    pop = city.findall('population')\n",
    "    if pop:\n",
    "        # To retrieve the most recent year's population\n",
    "        dict[name.text] = int(pop[len(pop)-1].text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Abomey-Calavi': 307745,\n",
       " 'Abu Dhabi': 552000,\n",
       " 'Aden': 570551,\n",
       " 'Akureyri': 17490,\n",
       " 'Al Ain': 348000,\n",
       " 'Al Fashir': 141884,\n",
       " 'Al Fayyum': 316772,\n",
       " 'Al Gazira': 211362,\n",
       " 'Al Gedaref': 191164,\n",
       " 'Al Iskandariyah': 4123869,\n",
       " \"Al Isma'iliyah\": 300449,\n",
       " 'Al Jizah': 2681863,\n",
       " 'Al Mahallah al Kubra': 442884,\n",
       " 'Al Mansurah': 437311,\n",
       " 'Al Manāmah': 143035,\n",
       " 'Al Minya': 235234,\n",
       " 'Al Qahirah': 8471859,\n",
       " 'Al Rayyan': 272860,\n",
       " 'Al Sharjah': 519000,\n",
       " 'Al Ubayyiḑ': 229425,\n",
       " 'Al Uqsur': 451318,\n",
       " 'Algiers': 2364230,\n",
       " 'Amman': 1812941,\n",
       " 'Andorra la Vella': 22256,\n",
       " 'Anju': 240117,\n",
       " 'Annaba': 342703,\n",
       " 'Ansan': 722598,\n",
       " 'Antananarivo': 710236,\n",
       " 'Antsirabe': 126062,\n",
       " 'Antsiranana': 59040,\n",
       " 'Anyang': 603184,\n",
       " 'Apia': 36735,\n",
       " 'Apopa': 143718,\n",
       " 'As Seeb': 302992,\n",
       " 'As Suways': 510935,\n",
       " 'Asmara': 380568,\n",
       " 'Asunción': 518792,\n",
       " 'Aswan': 265004,\n",
       " 'Asyut': 386086,\n",
       " 'Auckland': 419418,\n",
       " 'Az Zaqaziq': 302611,\n",
       " 'Baku': 2150800,\n",
       " 'Bandar Seri Begawan': 279924,\n",
       " 'Bangkok': 7506700,\n",
       " 'Bangui': 622771,\n",
       " 'Banha': 158389,\n",
       " 'Bani Suwayf': 193535,\n",
       " 'Banjul': 357238,\n",
       " 'Basseterre': 15500,\n",
       " 'Batna': 289504,\n",
       " 'Batumi': 121806,\n",
       " 'Bayamón': 185996,\n",
       " 'Bayrūt': 1100000,\n",
       " 'Bejaïa': 176139,\n",
       " 'Belize City': 53532,\n",
       " 'Belmopan': 13654,\n",
       " 'Benghazi': 800000,\n",
       " 'Beograd': 1639121,\n",
       " 'Bien Hoa': 652646,\n",
       " 'Bimbo': 124176,\n",
       " 'Biratnagar': 204949,\n",
       " 'Bishkek': 901700,\n",
       " 'Biskra': 204661,\n",
       " 'Blantyre': 661256,\n",
       " 'Blida': 331779,\n",
       " 'Bo': 149957,\n",
       " 'Bobo Dioulasso': 489967,\n",
       " 'Bridgetown': 88529,\n",
       " 'Bucheon': 847841,\n",
       " 'Bujumbura': 497166,\n",
       " 'Bulawayo': 653337,\n",
       " 'Buon Ma Thuot': 211891,\n",
       " \"Bur Sa'id\": 570768,\n",
       " 'Burgas': 197301,\n",
       " 'Busan': 3403135,\n",
       " 'Béchar': 165241,\n",
       " 'Bălţi': 143300,\n",
       " 'Cam Pha': 168196,\n",
       " 'Can Tho': 783122,\n",
       " 'Cap-Haïtien': 155505,\n",
       " 'Carolina': 157832,\n",
       " 'Carrefour': 430250,\n",
       " 'Castries': 3661,\n",
       " 'Cayenne': 57229,\n",
       " 'Ceuta': 82376,\n",
       " 'Changhua': 236636,\n",
       " 'Changwon': 1062731,\n",
       " 'Charlotte Amalie': 10354,\n",
       " 'Cheongju': 667726,\n",
       " 'Chiang Mai': 160200,\n",
       " 'Chiayi': 271220,\n",
       " 'Chinandega': 133361,\n",
       " 'Chitungwiza': 356840,\n",
       " 'Chişinău': 663400,\n",
       " 'Chon Buri': 233200,\n",
       " 'Chongjin': 667929,\n",
       " 'Christchurch': 361941,\n",
       " 'Chuncheon': 273737,\n",
       " 'Cité Soleil': 241055,\n",
       " 'Ciudad Delgado': 129965,\n",
       " 'Ciudad de Guatemala': 992541,\n",
       " 'Ciudad del Este': 222274,\n",
       " 'Cobán': 232703,\n",
       " 'Colombo': 647100,\n",
       " 'Conakry': 1667864,\n",
       " 'Constantine': 448028,\n",
       " 'Cork': 118912,\n",
       " 'Cotonou': 665100,\n",
       " 'Cuenca': 331888,\n",
       " 'Da Nang': 770911,\n",
       " 'Daegu': 2444085,\n",
       " 'Daejeon': 1495453,\n",
       " 'Damanhur': 241895,\n",
       " 'Delmas': 359451,\n",
       " 'Dili': 193563,\n",
       " 'Djibouti': 475322,\n",
       " 'Djougou': 181895,\n",
       " 'Doha': 339847,\n",
       " 'Dubai': 1171000,\n",
       " 'Dublin': 525383,\n",
       " 'Dunedin': 123516,\n",
       " 'Durrës': 113249,\n",
       " 'El Aaiun': 183691,\n",
       " 'El Djelfa': 265833,\n",
       " 'Elbasan': 78703,\n",
       " 'Eldoret': 289380,\n",
       " 'Estelí': 122924,\n",
       " 'Fakaofo': 490,\n",
       " 'Fianarantsoa': 109260,\n",
       " 'Fort-de-France': 100000,\n",
       " 'Franceville': 103840,\n",
       " 'Francistown': 100079,\n",
       " 'Freetown': 772873,\n",
       " 'Funafuti': 4492,\n",
       " 'Gaborone': 227333,\n",
       " 'Galway': 75414,\n",
       " 'Ganja': 322600,\n",
       " 'Gaza': 449477,\n",
       " 'Georgetown': 118363,\n",
       " 'Ghardaïa': 142913,\n",
       " 'Gonaïves': 228725,\n",
       " 'Goyang': 897174,\n",
       " 'Granada': 123697,\n",
       " 'Guayaquil': 2291158,\n",
       " 'Gunsan': 256755,\n",
       " 'Gustavia': 2299,\n",
       " 'Gwangju': 1469293,\n",
       " 'Ha Long': 201990,\n",
       " 'Haeju': 273300,\n",
       " 'Hafnarfjordur': 26099,\n",
       " 'Haiphong': 846191,\n",
       " 'Hamhung-Hungnam': 768551,\n",
       " 'Hamilton': 132060,\n",
       " 'Hanoi': 2644536,\n",
       " 'Harare': 1485231,\n",
       " 'Hebron': 163146,\n",
       " 'Herat': 335200,\n",
       " 'Ho Chi Minh': 5968384,\n",
       " 'Hong Kong': 7055071,\n",
       " 'Honiara': 49107,\n",
       " 'Hsinchu': 425071,\n",
       " 'Hualien': 108077,\n",
       " 'Hue': 302983,\n",
       " 'Huichon': 168180,\n",
       " 'Incheon': 2637652,\n",
       " 'Irbid': 250645,\n",
       " 'Jeju': 399416,\n",
       " 'Jeonju': 643079,\n",
       " 'Jhongli': 376217,\n",
       " 'Jinju': 337230,\n",
       " 'Jinotega': 123548,\n",
       " 'Juba': 372410,\n",
       " 'Kabul': 2435400,\n",
       " 'Kaechon': 319554,\n",
       " 'Kaesong': 308440,\n",
       " 'Kafr ad Dawwar': 262748,\n",
       " 'Kampala': 1516210,\n",
       " 'Kandahar': 311800,\n",
       " 'Kanggye': 251971,\n",
       " 'Kaohsiung': 2778659,\n",
       " 'Kassala': 234622,\n",
       " 'Kathmandu': 1003285,\n",
       " 'Kaunas': 307498,\n",
       " 'Keelung': 377153,\n",
       " 'Keflavik': 13862,\n",
       " 'Khartoum': 947483,\n",
       " 'Khartoum North': 700887,\n",
       " 'Khon Kaen': 223300,\n",
       " 'Kigali': 603049,\n",
       " 'Kim Chaek': 207299,\n",
       " 'Kingston': 662426,\n",
       " 'Kingstown': 12909,\n",
       " 'Kisumu': 388311,\n",
       " 'Klaipeda': 158891,\n",
       " 'Kolonia': 5681,\n",
       " 'Koror': 11665,\n",
       " 'Korçë': 51152,\n",
       " 'Kumanovo': 107745,\n",
       " 'Kusong': 196515,\n",
       " 'Kutaisi': 185965,\n",
       " 'Kuwait': 637411,\n",
       " 'Laghouat': 134372,\n",
       " 'Lalitpur': 226728,\n",
       " 'Larnaka': 51468,\n",
       " 'Lefkosia': 55014,\n",
       " 'Lemesos': 101000,\n",
       " 'León': 201100,\n",
       " 'Libreville': 538195,\n",
       " 'Lilongwe': 674448,\n",
       " 'Limerick': 56779,\n",
       " 'Ljubljana': 282994,\n",
       " 'Lomé': 839566,\n",
       " 'Long Xuyen': 245699,\n",
       " 'Luxembourg': 99852,\n",
       " 'Machakos': 150041,\n",
       " 'Majunga': 106780,\n",
       " 'Majuro': 27797,\n",
       " 'Male': 133019,\n",
       " 'Malindi': 118265,\n",
       " 'Managua': 1028808,\n",
       " 'Maribor': 111374,\n",
       " 'Marigot': 5700,\n",
       " 'Masaya': 166588,\n",
       " 'Maseru': 227880,\n",
       " 'Matagalpa': 150643,\n",
       " 'Mazar-i-Sharif': 288700,\n",
       " 'Mbabane': 57992,\n",
       " 'Mbarara': 195013,\n",
       " 'Mejicanos': 157188,\n",
       " 'Melekeok': 391,\n",
       " 'Melilla': 78476,\n",
       " 'Misratah': 360000,\n",
       " 'Mixco': 483705,\n",
       " 'Mokpo': 244543,\n",
       " 'Mombasa': 938131,\n",
       " 'Monaco': 975,\n",
       " 'Monrovia': 1010970,\n",
       " 'Montevideo': 1318755,\n",
       " 'Moroni': 41557,\n",
       " 'Mostaganem': 162885,\n",
       " 'Mukono': 161996,\n",
       " 'Muscat': 27216,\n",
       " \"N'Djamena\": 951418,\n",
       " \"N'Zérékoré\": 194178,\n",
       " 'Nablus': 126132,\n",
       " 'Nairobi': 3133518,\n",
       " 'Nakhon Ratchasima': 254900,\n",
       " 'Nakhon Sawan': 142500,\n",
       " 'Nakhon Si Thammarat': 167400,\n",
       " 'Nakuru': 307990,\n",
       " 'Nam Dinh': 193768,\n",
       " 'Nampho': 366815,\n",
       " 'Nassau': 248948,\n",
       " 'New Taipei': 3939305,\n",
       " 'Nha Trang': 292693,\n",
       " 'Niš': 257867,\n",
       " 'Nonthaburi': 481900,\n",
       " 'Novi Sad': 335701,\n",
       " 'Nukualofa': 23658,\n",
       " 'Nyala': 227183,\n",
       " 'Omdurman': 1271403,\n",
       " 'Oran': 803329,\n",
       " 'Osh': 265200,\n",
       " 'Osijek': 83496,\n",
       " 'Ouagadougou': 1475223,\n",
       " 'Palikir': 6444,\n",
       " 'Paramaribo': 240924,\n",
       " 'Philipsburg': 1338,\n",
       " 'Phnom Penh': 703963,\n",
       " 'Phuket': 75573,\n",
       " 'Pingtung': 207862,\n",
       " 'Plovdiv': 331796,\n",
       " 'Plymouth': 0,\n",
       " 'Podgorica': 150977,\n",
       " 'Pokhara': 264991,\n",
       " 'Ponce': 132502,\n",
       " 'Port Moresby': 318128,\n",
       " 'Port Sudan': 308195,\n",
       " 'Port Vila': 44040,\n",
       " 'Port-Gentil': 105712,\n",
       " 'Port-au-Prince': 875978,\n",
       " 'Port-of-Spain': 548299,\n",
       " 'Porto-Novo': 223552,\n",
       " 'Praia': 131719,\n",
       " 'Prishtine': 198214,\n",
       " 'Pyongyang': 3255288,\n",
       " 'Pétion-Ville': 271175,\n",
       " 'Qina': 206831,\n",
       " 'Qui Nhon': 255463,\n",
       " 'Quito': 1619146,\n",
       " 'Rach Gia': 210784,\n",
       " 'Reykjavik': 118061,\n",
       " 'Rijeka': 127498,\n",
       " 'Roseau': 14725,\n",
       " 'Ruse': 146609,\n",
       " 'Rīga': 696618,\n",
       " \"Saint George's\": 37000,\n",
       " 'Saint Johns': 22219,\n",
       " 'Saint-Denis': 145347,\n",
       " 'Saint-Pierre': 5618,\n",
       " 'Salto': 104011,\n",
       " 'Samut Prakan': 277600,\n",
       " 'San Juan': 381931,\n",
       " 'San Marino': 4227,\n",
       " 'San Miguel': 218410,\n",
       " 'San Salvador': 354174,\n",
       " \"Sana'a\": 1527861,\n",
       " 'Santa Ana': 245421,\n",
       " 'Santa Tecla': 126353,\n",
       " 'Santiago': 591985,\n",
       " 'Santo Domingo': 2749703,\n",
       " 'Santo Domingo de los Colorados': 305632,\n",
       " 'Saraburi': 125300,\n",
       " 'Sariwon': 307764,\n",
       " 'Seongnam': 951424,\n",
       " 'Seoul': 9708483,\n",
       " 'Sfax': 299235,\n",
       " 'Shibin al Kum': 177060,\n",
       " 'Shkodër': 77075,\n",
       " 'Shubra al Khimah': 1016722,\n",
       " 'Sidi Bel Abbës': 210146,\n",
       " 'Singapore': 5076700,\n",
       " 'Sinpho': 152759,\n",
       " 'Sinuiju': 359341,\n",
       " 'Skikda': 182903,\n",
       " 'Skopje': 514967,\n",
       " 'Sofia': 1270284,\n",
       " 'Sokhumi': 62914,\n",
       " 'Songkhla': 294200,\n",
       " 'Sousse': 223844,\n",
       " 'Soyapango': 268228,\n",
       " 'Split': 165893,\n",
       " 'Sri Jayawardhanapura Kotte': 116366,\n",
       " 'Stara Zagora': 136363,\n",
       " 'Suhaj': 189638,\n",
       " 'Sumgayit': 290500,\n",
       " 'Sunchon': 297317,\n",
       " 'Suva': 75225,\n",
       " 'Suwon': 1064951,\n",
       " 'São Tomé': 49957,\n",
       " 'Sétif': 252127,\n",
       " \"Ta'izz\": 458933,\n",
       " 'Taichung': 2684893,\n",
       " 'Tainan': 1881645,\n",
       " 'Taipei': 2673226,\n",
       " 'Taitung': 107720,\n",
       " 'Tallinn': 399340,\n",
       " 'Tamanrasset': 92635,\n",
       " 'Tamatave': 137782,\n",
       " 'Tanchon': 345875,\n",
       " 'Tanta': 421076,\n",
       " 'Taoyuan': 413488,\n",
       " 'Tarawa': 50182,\n",
       " 'Tartu': 103284,\n",
       " 'Tbilisi': 1073345,\n",
       " 'Thai Nguyen': 199732,\n",
       " 'Thimphu': 42465,\n",
       " 'Tipitapa': 130627,\n",
       " 'Tirana': 418495,\n",
       " 'Tiraspol': 148917,\n",
       " 'Tlemcen': 173531,\n",
       " 'Tokchon': 237133,\n",
       " 'Toliara': 80826,\n",
       " 'Tougourt': 143270,\n",
       " 'Tripoli': 1500000,\n",
       " 'Tunis': 651284,\n",
       " 'Tébessa': 194461,\n",
       " 'Tórshavn': 12245,\n",
       " 'Ubon Ratchathani': 149700,\n",
       " 'Ulaanbaatar': 760077,\n",
       " 'Ulsan': 1081985,\n",
       " 'Vaduz': 5241,\n",
       " 'Valletta': 5748,\n",
       " 'Varna': 330486,\n",
       " 'Vatican City': 842,\n",
       " 'Victoria': 24970,\n",
       " 'Vientiane': 698318,\n",
       " 'Villa Nueva': 527174,\n",
       " 'Vilnius': 538747,\n",
       " 'Vinh': 215577,\n",
       " 'Vlorë': 79513,\n",
       " 'Vung Tau': 282415,\n",
       " 'Wellington': 185187,\n",
       " 'Willemstad': 125000,\n",
       " 'Windhoek': 322500,\n",
       " 'Wonsan': 363127,\n",
       " 'Yeosu': 267921,\n",
       " 'Yerevan': 1066264,\n",
       " 'Yongin': 852505,\n",
       " 'Zadar': 70674,\n",
       " 'Zagreb': 686568,\n",
       " 'Zarqa': 395227,\n",
       " 'al Hudaydah': 402560}"
      ]
     },
     "execution_count": 192,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "cpdf1 = pd.DataFrame(list(dict.items()), columns=['City', 'Population'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>Population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kavala</td>\n",
       "      <td>58790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Athina</td>\n",
       "      <td>664046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Peiraias</td>\n",
       "      <td>163688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Peristeri</td>\n",
       "      <td>139981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Acharnes</td>\n",
       "      <td>106943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Patra</td>\n",
       "      <td>213984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Kerkyra</td>\n",
       "      <td>102071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ioannina</td>\n",
       "      <td>112486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Thessaloniki</td>\n",
       "      <td>325182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Iraklio</td>\n",
       "      <td>173993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Chania</td>\n",
       "      <td>108642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Rhodes</td>\n",
       "      <td>115490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Lamia</td>\n",
       "      <td>75315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Chalkida</td>\n",
       "      <td>102223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Larissa</td>\n",
       "      <td>162591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Volos</td>\n",
       "      <td>144449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Karyes</td>\n",
       "      <td>233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Strasbourg</td>\n",
       "      <td>272222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Mulhouse</td>\n",
       "      <td>110351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Bordeaux</td>\n",
       "      <td>239399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Clermont-Ferrand</td>\n",
       "      <td>140957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Caen</td>\n",
       "      <td>108793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Rennes</td>\n",
       "      <td>208033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Brest</td>\n",
       "      <td>309764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Dijon</td>\n",
       "      <td>151672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Orléans</td>\n",
       "      <td>114185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Tours</td>\n",
       "      <td>134633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Reims</td>\n",
       "      <td>180752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ajaccio</td>\n",
       "      <td>66245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Besançon</td>\n",
       "      <td>115879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>N'Zérékoré</td>\n",
       "      <td>194178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>Monrovia</td>\n",
       "      <td>1010970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>Djibouti</td>\n",
       "      <td>475322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>Asmara</td>\n",
       "      <td>380568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>Mombasa</td>\n",
       "      <td>938131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>Malindi</td>\n",
       "      <td>118265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>Machakos</td>\n",
       "      <td>150041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>Nairobi</td>\n",
       "      <td>3133518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>Kisumu</td>\n",
       "      <td>388311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>Nakuru</td>\n",
       "      <td>307990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>Eldoret</td>\n",
       "      <td>289380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>Banjul</td>\n",
       "      <td>357238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>Freetown</td>\n",
       "      <td>772873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>Bo</td>\n",
       "      <td>149957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>Kampala</td>\n",
       "      <td>1516210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Mbarara</td>\n",
       "      <td>195013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>Mukono</td>\n",
       "      <td>161996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>Maseru</td>\n",
       "      <td>227880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>Antsiranana</td>\n",
       "      <td>59040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>Antananarivo</td>\n",
       "      <td>710236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>Antsirabe</td>\n",
       "      <td>126062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>Fianarantsoa</td>\n",
       "      <td>109260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>Majunga</td>\n",
       "      <td>106780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>Tamatave</td>\n",
       "      <td>137782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>Toliara</td>\n",
       "      <td>80826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>Lilongwe</td>\n",
       "      <td>674448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>Blantyre</td>\n",
       "      <td>661256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>Mbabane</td>\n",
       "      <td>57992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>Saint-Denis</td>\n",
       "      <td>145347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>São Tomé</td>\n",
       "      <td>49957</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3010 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 City  Population\n",
       "0              Kavala       58790\n",
       "1              Athina      664046\n",
       "2            Peiraias      163688\n",
       "3           Peristeri      139981\n",
       "4            Acharnes      106943\n",
       "5               Patra      213984\n",
       "6             Kerkyra      102071\n",
       "7            Ioannina      112486\n",
       "8        Thessaloniki      325182\n",
       "9             Iraklio      173993\n",
       "10             Chania      108642\n",
       "11             Rhodes      115490\n",
       "12              Lamia       75315\n",
       "13           Chalkida      102223\n",
       "14            Larissa      162591\n",
       "15              Volos      144449\n",
       "16             Karyes         233\n",
       "17         Strasbourg      272222\n",
       "18           Mulhouse      110351\n",
       "19           Bordeaux      239399\n",
       "20   Clermont-Ferrand      140957\n",
       "21               Caen      108793\n",
       "22             Rennes      208033\n",
       "23              Brest      309764\n",
       "24              Dijon      151672\n",
       "25            Orléans      114185\n",
       "26              Tours      134633\n",
       "27              Reims      180752\n",
       "28            Ajaccio       66245\n",
       "29           Besançon      115879\n",
       "..                ...         ...\n",
       "363        N'Zérékoré      194178\n",
       "364          Monrovia     1010970\n",
       "365          Djibouti      475322\n",
       "366            Asmara      380568\n",
       "367           Mombasa      938131\n",
       "368           Malindi      118265\n",
       "369          Machakos      150041\n",
       "370           Nairobi     3133518\n",
       "371            Kisumu      388311\n",
       "372            Nakuru      307990\n",
       "373           Eldoret      289380\n",
       "374            Banjul      357238\n",
       "375          Freetown      772873\n",
       "376                Bo      149957\n",
       "377           Kampala     1516210\n",
       "378           Mbarara      195013\n",
       "379            Mukono      161996\n",
       "380            Maseru      227880\n",
       "381       Antsiranana       59040\n",
       "382      Antananarivo      710236\n",
       "383         Antsirabe      126062\n",
       "384      Fianarantsoa      109260\n",
       "385           Majunga      106780\n",
       "386          Tamatave      137782\n",
       "387           Toliara       80826\n",
       "388          Lilongwe      674448\n",
       "389          Blantyre      661256\n",
       "390           Mbabane       57992\n",
       "391       Saint-Denis      145347\n",
       "392          São Tomé       49957\n",
       "\n",
       "[3010 rows x 2 columns]"
      ]
     },
     "execution_count": 194,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cpdf.append(cpdf1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>Population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1189</th>\n",
       "      <td>Shanghai</td>\n",
       "      <td>22315474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>Istanbul</td>\n",
       "      <td>13710512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1350</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>12442373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>Moskva</td>\n",
       "      <td>11979529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1188</th>\n",
       "      <td>Beijing</td>\n",
       "      <td>11716620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2269</th>\n",
       "      <td>São Paulo</td>\n",
       "      <td>11152344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1190</th>\n",
       "      <td>Tianjin</td>\n",
       "      <td>11090314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>Guangzhou</td>\n",
       "      <td>11071424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>11034555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918</th>\n",
       "      <td>Shenzhen</td>\n",
       "      <td>10358381</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           City  Population\n",
       "1189   Shanghai    22315474\n",
       "673    Istanbul    13710512\n",
       "1350     Mumbai    12442373\n",
       "421      Moskva    11979529\n",
       "1188    Beijing    11716620\n",
       "2269  São Paulo    11152344\n",
       "1190    Tianjin    11090314\n",
       "915   Guangzhou    11071424\n",
       "1396      Delhi    11034555\n",
       "918    Shenzhen    10358381"
      ]
     },
     "execution_count": 195,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cpdf.sort_values('Population', ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "# 3. 10 ethnic groups with the largest overall populations (sum of best/latest estimates over all countries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "c_p = {}\n",
    "for e in document.iter('country'):\n",
    "    cntry = e.find('name')\n",
    "    pop = e.find('.//population[last()]')\n",
    "    if cntry != None:\n",
    "        if pop != None:\n",
    "            c_p[cntry.text] = int(pop.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Afghanistan': 26023100,\n",
       " 'Albania': 2800138,\n",
       " 'Algeria': 37062820,\n",
       " 'American Samoa': 55519,\n",
       " 'Andorra': 78115,\n",
       " 'Angola': 24383301,\n",
       " 'Anguilla': 13037,\n",
       " 'Antigua and Barbuda': 81799,\n",
       " 'Argentina': 42669500,\n",
       " 'Armenia': 3026879,\n",
       " 'Aruba': 101484,\n",
       " 'Australia': 23135281,\n",
       " 'Austria': 8499759,\n",
       " 'Azerbaijan': 9356500,\n",
       " 'Bahamas': 353658,\n",
       " 'Bahrain': 1234596,\n",
       " 'Bangladesh': 149772364,\n",
       " 'Barbados': 277821,\n",
       " 'Belarus': 9460692,\n",
       " 'Belgium': 11099554,\n",
       " 'Belize': 312971,\n",
       " 'Benin': 9983884,\n",
       " 'Bermuda': 64237,\n",
       " 'Bhutan': 733004,\n",
       " 'Bolivia': 10027262,\n",
       " 'Bosnia and Herzegovina': 3791622,\n",
       " 'Botswana': 2038228,\n",
       " 'Brazil': 202768562,\n",
       " 'British Virgin Islands': 23161,\n",
       " 'Brunei': 393372,\n",
       " 'Bulgaria': 7284552,\n",
       " 'Burkina Faso': 17322796,\n",
       " 'Burundi': 8444784,\n",
       " 'Cambodia': 14364931,\n",
       " 'Cameroon': 19406100,\n",
       " 'Canada': 35158304,\n",
       " 'Cape Verde': 491875,\n",
       " 'Cayman Islands': 55691,\n",
       " 'Central African Republic': 4349921,\n",
       " 'Ceuta': 82376,\n",
       " 'Chad': 11720781,\n",
       " 'Chile': 16341929,\n",
       " 'China': 1360720000,\n",
       " 'Christmas Island': 2072,\n",
       " 'Cocos Islands': 596,\n",
       " 'Colombia': 47661787,\n",
       " 'Comoros': 683081,\n",
       " 'Congo': 4001831,\n",
       " 'Cook Islands': 17794,\n",
       " 'Costa Rica': 4773119,\n",
       " 'Cote dIvoire': 22671331,\n",
       " 'Croatia': 4290612,\n",
       " 'Cuba': 11167325,\n",
       " 'Curacao': 150563,\n",
       " 'Cyprus': 840407,\n",
       " 'Czech Republic': 10562214,\n",
       " 'Denmark': 5580516,\n",
       " 'Djibouti': 834036,\n",
       " 'Dominica': 70739,\n",
       " 'Dominican Republic': 9445281,\n",
       " 'Ecuador': 14483499,\n",
       " 'Egypt': 83667047,\n",
       " 'El Salvador': 6290420,\n",
       " 'Equatorial Guinea': 696167,\n",
       " 'Eritrea': 5741159,\n",
       " 'Estonia': 1294455,\n",
       " 'Ethiopia': 84320987,\n",
       " 'Falkland Islands': 2931,\n",
       " 'Faroe Islands': 48197,\n",
       " 'Fiji': 860559,\n",
       " 'Finland': 5455068,\n",
       " 'France': 64933400,\n",
       " 'French Guiana': 237549,\n",
       " 'French Polynesia': 268270,\n",
       " 'Gabon': 1556222,\n",
       " 'Gambia': 1882450,\n",
       " 'Gaza Strip': 1760037,\n",
       " 'Georgia': 4483800,\n",
       " 'Germany': 80219695,\n",
       " 'Ghana': 24658823,\n",
       " 'Gibraltar': 27495,\n",
       " 'Greece': 10816286,\n",
       " 'Greenland': 56370,\n",
       " 'Grenada': 103328,\n",
       " 'Guadeloupe': 404635,\n",
       " 'Guam': 159358,\n",
       " 'Guatemala': 15073375,\n",
       " 'Guernsey': 59807,\n",
       " 'Guinea': 10628972,\n",
       " 'Guinea-Bissau': 1586624,\n",
       " 'Guyana': 747884,\n",
       " 'Haiti': 9896400,\n",
       " 'Holy See': 842,\n",
       " 'Honduras': 8045990,\n",
       " 'Hong Kong': 7071576,\n",
       " 'Hungary': 9937628,\n",
       " 'Iceland': 318452,\n",
       " 'India': 1210854977,\n",
       " 'Indonesia': 252124458,\n",
       " 'Iran': 75149669,\n",
       " 'Iraq': 33330512,\n",
       " 'Ireland': 4588252,\n",
       " 'Isle of Man': 84497,\n",
       " 'Israel': 7420368,\n",
       " 'Italy': 59433744,\n",
       " 'Jamaica': 2697983,\n",
       " 'Japan': 127298000,\n",
       " 'Jersey': 97857,\n",
       " 'Jordan': 6249000,\n",
       " 'Kazakhstan': 17165239,\n",
       " 'Kenya': 40909194,\n",
       " 'Kiribati': 103058,\n",
       " 'Kosovo': 1733872,\n",
       " 'Kuwait': 2991580,\n",
       " 'Kyrgyzstan': 5776600,\n",
       " 'Laos': 6514432,\n",
       " 'Latvia': 2201196,\n",
       " 'Lebanon': 4341092,\n",
       " 'Lesotho': 2008921,\n",
       " 'Liberia': 3957990,\n",
       " 'Libya': 6040612,\n",
       " 'Liechtenstein': 36636,\n",
       " 'Lithuania': 2979310,\n",
       " 'Luxembourg': 524853,\n",
       " 'Macao': 552503,\n",
       " 'Macedonia': 2059794,\n",
       " 'Madagascar': 21842167,\n",
       " 'Malawi': 15013694,\n",
       " 'Malaysia': 27565821,\n",
       " 'Maldives': 341256,\n",
       " 'Mali': 13985961,\n",
       " 'Malta': 417432,\n",
       " 'Marshall Islands': 53158,\n",
       " 'Martinique': 392291,\n",
       " 'Mauritania': 3537368,\n",
       " 'Mauritius': 1237091,\n",
       " 'Mayotte': 212645,\n",
       " 'Melilla': 78476,\n",
       " 'Mexico': 112336538,\n",
       " 'Micronesia': 102843,\n",
       " 'Moldova': 3559541,\n",
       " 'Monaco': 36845,\n",
       " 'Mongolia': 2754685,\n",
       " 'Montenegro': 620029,\n",
       " 'Montserrat': 4922,\n",
       " 'Morocco': 32901622,\n",
       " 'Mozambique': 23700715,\n",
       " 'Myanmar': 51419420,\n",
       " 'Namibia': 2113077,\n",
       " 'Nauru': 10025,\n",
       " 'Nepal': 26494504,\n",
       " 'Netherlands': 16843181,\n",
       " 'New Caledonia': 245580,\n",
       " 'New Zealand': 4242048,\n",
       " 'Nicaragua': 6071045,\n",
       " 'Niger': 17138707,\n",
       " 'Nigeria': 164294516,\n",
       " 'Niue': 1611,\n",
       " 'Norfolk Island': 2169,\n",
       " 'North Korea': 24500520,\n",
       " 'Northern Mariana Islands': 53883,\n",
       " 'Norway': 5051275,\n",
       " 'Oman': 3623001,\n",
       " 'Pakistan': 173149306,\n",
       " 'Palau': 17501,\n",
       " 'Panama': 3405813,\n",
       " 'Papua New Guinea': 7275324,\n",
       " 'Paraguay': 6672631,\n",
       " 'Peru': 30135875,\n",
       " 'Philippines': 92337852,\n",
       " 'Pitcairn': 66,\n",
       " 'Poland': 38533789,\n",
       " 'Portugal': 10561614,\n",
       " 'Puerto Rico': 3725789,\n",
       " 'Qatar': 1699435,\n",
       " 'Reunion': 828581,\n",
       " 'Romania': 20121641,\n",
       " 'Russia': 143666931,\n",
       " 'Rwanda': 10515973,\n",
       " 'Saint Barthelemy': 9072,\n",
       " 'Saint Helena': 5663,\n",
       " 'Saint Kitts and Nevis': 52352,\n",
       " 'Saint Lucia': 165595,\n",
       " 'Saint Martin': 37630,\n",
       " 'Saint Pierre and Miquelon': 6312,\n",
       " 'Saint Vincent and the Grenadines': 109991,\n",
       " 'Samoa': 187820,\n",
       " 'San Marino': 32440,\n",
       " 'Sao Tome and Principe': 187356,\n",
       " 'Saudi Arabia': 27136977,\n",
       " 'Senegal': 13508715,\n",
       " 'Serbia': 7120666,\n",
       " 'Seychelles': 90945,\n",
       " 'Sierra Leone': 5751976,\n",
       " 'Singapore': 5076700,\n",
       " 'Sint Maarten': 37429,\n",
       " 'Slovakia': 5397036,\n",
       " 'Slovenia': 2058821,\n",
       " 'Solomon Islands': 526447,\n",
       " 'Somalia': 9636173,\n",
       " 'South Africa': 51770560,\n",
       " 'South Korea': 51141463,\n",
       " 'South Sudan': 8260490,\n",
       " 'Spain': 46815916,\n",
       " 'Sri Lanka': 20263723,\n",
       " 'Sudan': 35652002,\n",
       " 'Suriname': 541638,\n",
       " 'Svalbard': 1872,\n",
       " 'Swaziland': 1193148,\n",
       " 'Sweden': 9555893,\n",
       " 'Switzerland': 8139631,\n",
       " 'Syria': 20866000,\n",
       " 'Taiwan': 23315822,\n",
       " 'Tajikistan': 8161100,\n",
       " 'Tanzania': 44928923,\n",
       " 'Thailand': 65981659,\n",
       " 'Timor-Leste': 1066582,\n",
       " 'Togo': 6191155,\n",
       " 'Tokelau': 1383,\n",
       " 'Tonga': 103252,\n",
       " 'Trinidad and Tobago': 1328019,\n",
       " 'Tunisia': 10982754,\n",
       " 'Turkey': 75627384,\n",
       " 'Turkmenistan': 5041995,\n",
       " 'Turks and Caicos Islands': 31458,\n",
       " 'Tuvalu': 9827,\n",
       " 'Uganda': 34856813,\n",
       " 'Ukraine': 45633637,\n",
       " 'United Arab Emirates': 8441537,\n",
       " 'United Kingdom': 64105654,\n",
       " 'United States': 318857056,\n",
       " 'Uruguay': 3286314,\n",
       " 'Uzbekistan': 27769270,\n",
       " 'Vanuatu': 236299,\n",
       " 'Venezuela': 28946101,\n",
       " 'Vietnam': 88772900,\n",
       " 'Virgin Islands': 106405,\n",
       " 'Wallis and Futuna': 12197,\n",
       " 'West Bank': 2790331,\n",
       " 'Western Sahara': 554795,\n",
       " 'Yemen': 24527000,\n",
       " 'Zaire': 62191161,\n",
       " 'Zambia': 13046508,\n",
       " 'Zimbabwe': 13061239}"
      ]
     },
     "execution_count": 245,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c_p"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "co_etg = []\n",
    "for el in document.iterfind('country'):\n",
    "    co = el.find('name').text\n",
    "    for et in el.iterfind('ethnicgroup'):\n",
    "        etg_name = et.text\n",
    "        etg_prcnt = et.attrib['percentage']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "co_etg.append([co,etg_name,etg_prcnt])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['Seychelles', 'Seychellois', '100']]"
      ]
     },
     "execution_count": 235,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "co_etg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "c.append(cols)\n",
    "c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "labels = ['Country', 'Population', 'Ethnic_Group']\n",
    "eg_df = pd.DataFrame.from_records(c, columns=labels)\n",
    "eg_df\n",
    "#city_df.sort_values('Population', ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for po in popl:\n",
    "        p = po.find('.//population[last()]')\n",
    "        if p != None:\n",
    "                p = int(population.text)\n",
    "        for et in etg:\n",
    "            eg = et.find('.//ethnicgroup[1]')\n",
    "            #if eg != None:\n",
    "                #eg = eg.text            \n",
    "                #df = ldf.append(cntry, eg, p)\n",
    "                #df = pd.DataFrame"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 4. Name and Country of a) longest river, b) largest lake and c) airport at highest elevation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "cit_pop_list = []\n",
    "\n",
    "#start a loop to go through all the countries in the XML\n",
    "for element in document.iterfind('country'):\n",
    "    ctry = element.find('name').text\n",
    "    '''\n",
    "    Countries may or may not have provinces, and there are some countries where the city name is not unique. e.g.\n",
    "    Richmond in United States. So the only way to uniquely identify a city to show the city along with the country\n",
    "    and the province.\n",
    "    \n",
    "    we store the provice names of a country in a dictionary here. This dictionary will be used to fill in the \n",
    "    province names. Storing the provinces here reduces the amount of code required.   \n",
    "    '''\n",
    "  \n",
    "    prov_dict = {}\n",
    "    for province in element.findall('province'):\n",
    "        prov_dict[province.attrib['id']] = province.find('name').text\n",
    "        \n",
    "    # setup a loop for all the cities within a country    \n",
    "    for subelement in element.getiterator('city'):\n",
    "        city = subelement.find('name')\n",
    "        if city != None: # check to see if 'city' element is present\n",
    "            # for each city there may be more than one population entry, the below code stores only the latest\n",
    "            # population entry, i.e. entry whose year value is max\n",
    "            yr = 0\n",
    "            pop = 0\n",
    "            #get the population elements for each city\n",
    "            for popelement in subelement.getiterator('population'):\n",
    "                if popelement != None: # check to see if any 'population' element is present\n",
    "                    #store the population for the year that is the greatest for this particular city\n",
    "                    if int(popelement.attrib['year']) > yr:\n",
    "                        yr = int(popelement.attrib['year'])\n",
    "                        pop = int(popelement.text)\n",
    "                        #if this city has provinces, store the province name from the dict values created\n",
    "                        #earlier in the program\n",
    "                        if 'province' in subelement.attrib:\n",
    "                            prov = prov_dict[subelement.attrib['province']]\n",
    "                        else:\n",
    "                            prov = 'No Province'\n",
    "            #create a list with the elements and append to the list\n",
    "            cit_pop_list.append([ctry,city.text,prov,int(popelement.attrib['year']),int(popelement.text)])\n",
    "        \n",
    "#once the list is constructed, create a DataFrame from the list\n",
    "#cit_pop_df=pd.DataFrame.from_records(cit_pop_list)\n",
    "\n",
    "#set the column names\n",
    "#cit_pop_df.columns=['Country','City','Province','Year','Population']\n",
    "\n",
    "\n",
    "#cit_pop_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['Albania', 'Tirana', 'No Province', 2011, 418495],\n",
       " ['Albania', 'Shkodër', 'No Province', 2011, 77075],\n",
       " ['Albania', 'Durrës', 'No Province', 2011, 113249],\n",
       " ['Albania', 'Vlorë', 'No Province', 2011, 79513],\n",
       " ['Albania', 'Elbasan', 'No Province', 2011, 78703],\n",
       " ['Albania', 'Korçë', 'No Province', 2011, 51152],\n",
       " ['Greece', 'Komotini', 'No Province', 2011, 51152],\n",
       " ['Greece', 'Kavala', 'Anatolikis Makedonias kai Thrakis', 2011, 58790],\n",
       " ['Greece', 'Athina', 'Attikis', 2011, 664046],\n",
       " ['Greece', 'Peiraias', 'Attikis', 2011, 163688],\n",
       " ['Greece', 'Peristeri', 'Attikis', 2011, 139981],\n",
       " ['Greece', 'Acharnes', 'Attikis', 2011, 106943],\n",
       " ['Greece', 'Patra', 'Dytikis Elladas', 2011, 213984],\n",
       " ['Greece', 'Kozani', 'Dytikis Elladas', 2011, 213984],\n",
       " ['Greece', 'Kerkyra', 'Ionion Nison', 2011, 102071],\n",
       " ['Greece', 'Ioannina', 'Ipeiroy', 2011, 112486],\n",
       " ['Greece', 'Thessaloniki', 'Kentrikis Makedonias', 2011, 325182],\n",
       " ['Greece', 'Iraklio', 'Kritis', 2011, 173993],\n",
       " ['Greece', 'Chania', 'Kritis', 2011, 108642],\n",
       " ['Greece', 'Ermoupoli', 'Kritis', 2011, 108642],\n",
       " ['Greece', 'Rhodes', 'Notioy Aigaioy', 2011, 115490],\n",
       " ['Greece', 'Tripoli', 'Notioy Aigaioy', 2011, 115490],\n",
       " ['Greece', 'Lamia', 'Stereas Elladas', 2011, 75315],\n",
       " ['Greece', 'Chalkida', 'Stereas Elladas', 2011, 102223],\n",
       " ['Greece', 'Larissa', 'Thessalias', 2011, 162591],\n",
       " ['Greece', 'Volos', 'Thessalias', 2011, 144449],\n",
       " ['Greece', 'Mytilini', 'Thessalias', 2011, 144449],\n",
       " ['Greece', 'Karyes', 'Aghion Oros', 2014, 233],\n",
       " ['Macedonia', 'Skopje', 'No Province', 2011, 514967],\n",
       " ['Macedonia', 'Kumanovo', 'No Province', 2011, 107745],\n",
       " ['Serbia', 'Beograd', 'No Province', 2011, 1639121],\n",
       " ['Serbia', 'Novi Sad', 'No Province', 2011, 335701],\n",
       " ['Serbia', 'Niš', 'No Province', 2011, 257867],\n",
       " ['Montenegro', 'Podgorica', 'No Province', 2011, 150977],\n",
       " ['Kosovo', 'Prishtine', 'No Province', 2011, 198214],\n",
       " ['Andorra', 'Andorra la Vella', 'No Province', 2011, 22256],\n",
       " ['France', 'Strasbourg', 'Alsace', 2011, 272222],\n",
       " ['France', 'Mulhouse', 'Alsace', 2011, 110351],\n",
       " ['France', 'Bordeaux', 'Aquitaine', 2011, 239399],\n",
       " ['France', 'Clermont-Ferrand', 'Auvergne', 2011, 140957],\n",
       " ['France', 'Caen', 'Basse Normandie', 2011, 108793],\n",
       " ['France', 'Rennes', 'Bretagne', 2011, 208033],\n",
       " ['France', 'Brest', 'Bretagne', 2011, 140547],\n",
       " ['France', 'Dijon', 'Bourgogne', 2011, 151672],\n",
       " ['France', 'Orléans', 'Centre', 2011, 114185],\n",
       " ['France', 'Tours', 'Centre', 2011, 134633],\n",
       " ['France', 'Reims', 'Champagne-Ardenne', 2011, 180752],\n",
       " ['France', 'Chalons en Champagne', 'Champagne-Ardenne', 2011, 180752],\n",
       " ['France', 'Ajaccio', 'Corse', 2011, 66245],\n",
       " ['France', 'Besançon', 'Franche-Comté', 2011, 115879],\n",
       " ['France', 'Rouen', 'Haute-Normandie', 2011, 111553],\n",
       " ['France', 'Le Havre', 'Haute-Normandie', 2011, 174156],\n",
       " ['France', 'Paris', 'Île-de-France', 2011, 2249975],\n",
       " ['France', 'Boulogne-Billancourt', 'Île-de-France', 2011, 116220],\n",
       " ['France', 'Argenteuil', 'Île-de-France', 2011, 104282],\n",
       " ['France', 'Montreuil', 'Île-de-France', 2011, 103068],\n",
       " ['France', 'Saint-Paul', 'Île-de-France', 2011, 103916],\n",
       " ['France', 'Montpellier', 'Languedoc-Roussillon', 2011, 264538],\n",
       " ['France', 'Nîmes', 'Languedoc-Roussillon', 2011, 144940],\n",
       " ['France', 'Perpignan', 'Languedoc-Roussillon', 2011, 118238],\n",
       " ['France', 'Limoges', 'Limousin', 2011, 137758],\n",
       " ['France', 'Metz', 'Lorraine', 2011, 119962],\n",
       " ['France', 'Nancy', 'Lorraine', 2011, 105382],\n",
       " ['France', 'Toulouse', 'Midi-Pyrénées', 2011, 447340],\n",
       " ['France', 'Lille', 'Nord-Pas-de-Calais', 2011, 227533],\n",
       " ['France', 'Nantes', 'Pays de la Loire', 2011, 287845],\n",
       " ['France', 'Angers', 'Pays de la Loire', 2011, 148803],\n",
       " ['France', 'Le Mans', 'Pays de la Loire', 2011, 143240],\n",
       " ['France', 'Amiens', 'Picardie', 2011, 133327],\n",
       " ['France', 'Poitiers', 'Poitou Charentes', 2011, 87646],\n",
       " ['France', 'Marseille', \"Provence-Alpes-Côte d'Azur\", 2011, 850636],\n",
       " ['France', 'Nice', \"Provence-Alpes-Côte d'Azur\", 2011, 344064],\n",
       " ['France', 'Toulon', \"Provence-Alpes-Côte d'Azur\", 2011, 163974],\n",
       " ['France', 'Aix-en-Provence', \"Provence-Alpes-Côte d'Azur\", 2011, 140684],\n",
       " ['France', 'Lyon', 'Rhône-Alpes', 2011, 491268],\n",
       " ['France', 'Grenoble', 'Rhône-Alpes', 2011, 157424],\n",
       " ['France', 'Saint-Étienne', 'Rhône-Alpes', 2011, 170049],\n",
       " ['France', 'Villeurbanne', 'Rhône-Alpes', 2011, 145034],\n",
       " ['Spain', 'Sevilla', 'Andalucía', 2011, 698042],\n",
       " ['Spain', 'Almería', 'Andalucía', 2011, 189680],\n",
       " ['Spain', 'Cádiz', 'Andalucía', 2011, 124014],\n",
       " ['Spain', 'Córdoba', 'Andalucía', 2011, 328326],\n",
       " ['Spain', 'Granada', 'Andalucía', 2011, 241003],\n",
       " ['Spain', 'Huelva', 'Andalucía', 2011, 147808],\n",
       " ['Spain', 'Málaga', 'Andalucía', 2011, 561435],\n",
       " ['Spain', 'Jerez de la Frontera', 'Andalucía', 2011, 211784],\n",
       " ['Spain', 'Jaén', 'Andalucía', 2011, 116469],\n",
       " ['Spain', 'Algeciras', 'Andalucía', 2011, 117695],\n",
       " ['Spain', 'Marbella', 'Andalucía', 2011, 135124],\n",
       " ['Spain', 'Dos Hermanas', 'Andalucía', 2011, 128433],\n",
       " ['Spain', 'Zaragoza', 'Aragón', 2011, 678115],\n",
       " ['Spain', 'Oviedo', 'Asturias', 2011, 225005],\n",
       " ['Spain', 'Gijón', 'Asturias', 2011, 276969],\n",
       " ['Spain', 'Palma de Mallorca', 'Illes Balears', 2011, 402044],\n",
       " ['Spain', 'Vitoria-Gasteiz', 'País Vasco', 2011, 240753],\n",
       " ['Spain', 'Bilbao', 'País Vasco', 2011, 351356],\n",
       " ['Spain', 'Barakaldo', 'País Vasco', 2011, 100064],\n",
       " ['Spain', 'Donostia', 'País Vasco', 2011, 185512],\n",
       " ['Spain', 'Santa Cruz de Tenerife', 'Canarias', 2011, 204476],\n",
       " ['Spain', 'San Cristóbal de La Laguna', 'Canarias', 2011, 152025],\n",
       " ['Spain', 'Las Palmas de Gran Canaria', 'Canarias', 2011, 381271],\n",
       " ['Spain', 'Telde', 'Canarias', 2011, 101080],\n",
       " ['Spain', 'Santander', 'Cantabria', 2011, 178095],\n",
       " ['Spain', 'Valladolid', 'Castilla y León', 2011, 311682],\n",
       " ['Spain', 'Burgos', 'Castilla y León', 2011, 178864],\n",
       " ['Spain', 'León', 'Castilla y León', 2011, 131411],\n",
       " ['Spain', 'Salamanca', 'Castilla y León', 2011, 151658],\n",
       " ['Spain', 'Toledo', 'Castilla y León', 2011, 151658],\n",
       " ['Spain', 'Albacete', 'Castilla-La Mancha', 2011, 171999],\n",
       " ['Spain', 'Barcelona', 'Cataluña', 2011, 1611013],\n",
       " ['Spain', 'Lleida', 'Cataluña', 2011, 137283],\n",
       " ['Spain', 'Tarragona', 'Cataluña', 2011, 133223],\n",
       " ['Spain', 'Reus', 'Cataluña', 2011, 106849],\n",
       " ['Spain', 'Hospitalet de Llobregat', 'Cataluña', 2011, 256509],\n",
       " ['Spain', 'Badalona', 'Cataluña', 2011, 219241],\n",
       " ['Spain', 'Sabadell', 'Cataluña', 2011, 206949],\n",
       " ['Spain', 'Terrassa', 'Cataluña', 2011, 214406],\n",
       " ['Spain', 'Santa Coloma de Gramenet', 'Cataluña', 2011, 119391],\n",
       " ['Spain', 'Mataró', 'Cataluña', 2011, 123367],\n",
       " ['Spain', 'Badajoz', 'Extremadura', 2011, 151214],\n",
       " ['Spain', 'Merida', 'Extremadura', 2011, 151214],\n",
       " ['Spain', 'A Coruña', 'Galicia', 2011, 245053],\n",
       " ['Spain', 'Vigo', 'Galicia', 2011, 295623],\n",
       " ['Spain', 'Ourense', 'Galicia', 2011, 107314],\n",
       " ['Spain', 'Santiago de Compostela', 'Galicia', 2011, 107314],\n",
       " ['Spain', 'Madrid', 'Madrid', 2011, 3198645],\n",
       " ['Spain', 'Móstoles', 'Madrid', 2011, 203493],\n",
       " ['Spain', 'Leganés', 'Madrid', 2011, 185758],\n",
       " ['Spain', 'Alcalá de Henares', 'Madrid', 2011, 200505],\n",
       " ['Spain', 'Fuenlabrada', 'Madrid', 2011, 196986],\n",
       " ['Spain', 'Getafe', 'Madrid', 2011, 168642],\n",
       " ['Spain', 'Alcorcón', 'Madrid', 2011, 167217],\n",
       " ['Spain', 'Torrejón de Ardoz', 'Madrid', 2011, 123213],\n",
       " ['Spain', 'Parla', 'Madrid', 2011, 122045],\n",
       " ['Spain', 'Alcobendas', 'Madrid', 2011, 110351],\n",
       " ['Spain', 'Murcia', 'Murcia', 2011, 437667],\n",
       " ['Spain', 'Cartagena', 'Murcia', 2011, 215757],\n",
       " ['Spain', 'Pamplona', 'Navarra', 2011, 195943],\n",
       " ['Spain', 'Logroño', 'La Rioja', 2011, 152698],\n",
       " ['Spain', 'Valencia', 'Valenciana', 2011, 792054],\n",
       " ['Spain', 'Alicante', 'Valenciana', 2011, 329325],\n",
       " ['Spain', 'Elche', 'Valenciana', 2011, 227417],\n",
       " ['Spain', 'Castellón de la Plana', 'Valenciana', 2011, 176298],\n",
       " ['Austria', 'Eisenstadt', 'Burgenland', 2013, 13485],\n",
       " ['Austria', 'Klagenfurt', 'Kärnten', 2013, 96531],\n",
       " ['Austria', 'Villach', 'Kärnten', 2013, 59942],\n",
       " ['Austria', 'Bregenz', 'Kärnten', 2013, 59942],\n",
       " ['Austria', 'Wien', 'Wien', 2013, 1761738],\n",
       " ['Austria', 'Linz', 'Oberösterreich', 2013, 193511],\n",
       " ['Austria', 'Wels', 'Oberösterreich', 2013, 59239],\n",
       " ['Austria', 'Innsbruck', 'Tirol', 2013, 124386],\n",
       " ['Austria', 'Graz', 'Steiermark', 2013, 269211],\n",
       " ['Austria', 'Salzburg', 'Salzburg', 2013, 146676],\n",
       " ['Austria', 'St. Pölten', 'Niederösterreich', 2013, 52100],\n",
       " ['Czech Republic', 'Praha', 'Praha', 2011, 1289556],\n",
       " ['Czech Republic', 'České Budějovice', 'Jihočeský', 2011, 95589],\n",
       " ['Czech Republic', 'Brno', 'Jihomoravský', 2011, 404820],\n",
       " ['Czech Republic', 'Karlovy Vary', 'Karlovarský', 2011, 53310],\n",
       " ['Czech Republic', 'Jihlava', 'Vysočina', 2011, 51162],\n",
       " ['Czech Republic', 'Hradec Králové', 'Královéhradecký', 2011, 95594],\n",
       " ['Czech Republic', 'Liberec', 'Liberecký', 2011, 104973],\n",
       " ['Czech Republic', 'Ostrava', 'Moravskoslezský', 2011, 311508],\n",
       " ['Czech Republic', 'Olomouc', 'Olomoucký', 2011, 101954],\n",
       " ['Czech Republic', 'Pardubice', 'Pardubický', 2011, 90844],\n",
       " ['Czech Republic', 'Plzeň', 'Plzeňský', 2011, 171346],\n",
       " ['Czech Republic', 'Ústí nad Labem', 'Ústecký', 2011, 98596],\n",
       " ['Czech Republic', 'Zlín', 'Zlínský', 2011, 77137],\n",
       " ['Germany', 'Stuttgart', 'Baden-Württemberg', 2011, 585890],\n",
       " ['Germany', 'Mannheim', 'Baden-Württemberg', 2011, 290117],\n",
       " ['Germany', 'Karlsruhe', 'Baden-Württemberg', 2011, 289173],\n",
       " ['Germany', 'Freiburg', 'Baden-Württemberg', 2011, 209628],\n",
       " ['Germany', 'Heidelberg', 'Baden-Württemberg', 2011, 146751],\n",
       " ['Germany', 'Heilbronn', 'Baden-Württemberg', 2011, 116059],\n",
       " ['Germany', 'Pforzheim', 'Baden-Württemberg', 2011, 114411],\n",
       " ['Germany', 'Ulm', 'Baden-Württemberg', 2011, 116761],\n",
       " ['Germany', 'Reutlingen', 'Baden-Württemberg', 2011, 109799],\n",
       " ['Germany', 'München', 'Bayern', 2011, 1348335],\n",
       " ['Germany', 'Nürnberg', 'Bayern', 2011, 486314],\n",
       " ['Germany', 'Augsburg', 'Bayern', 2011, 267767],\n",
       " ['Germany', 'Würzburg', 'Bayern', 2011, 124297],\n",
       " ['Germany', 'Regensburg', 'Bayern', 2011, 135403],\n",
       " ['Germany', 'Ingolstadt', 'Bayern', 2011, 124927],\n",
       " ['Germany', 'Fürth', 'Bayern', 2011, 115613],\n",
       " ['Germany', 'Erlangen', 'Bayern', 2011, 103719],\n",
       " ['Germany', 'Berlin', 'Berlin', 2011, 3292365],\n",
       " ['Germany', 'Potsdam', 'Brandenburg', 2011, 156021],\n",
       " ['Germany', 'Cottbus', 'Brandenburg', 2011, 99984],\n",
       " ['Germany', 'Bremen', 'Bremen', 2011, 542707],\n",
       " ['Germany', 'Bremerhaven', 'Bremen', 2011, 108156],\n",
       " ['Germany', 'Hamburg', 'Hamburg', 2011, 1706696],\n",
       " ['Germany', 'Wiesbaden', 'Hessen', 2011, 269121],\n",
       " ['Germany', 'Frankfurt am Main', 'Hessen', 2011, 667925],\n",
       " ['Germany', 'Kassel', 'Hessen', 2011, 190765],\n",
       " ['Germany', 'Darmstadt', 'Hessen', 2011, 143499],\n",
       " ['Germany', 'Offenbach am Main', 'Hessen', 2011, 113443],\n",
       " ['Germany', 'Schwerin', 'Mecklenburg-Vorpommern', 2011, 91293],\n",
       " ['Germany', 'Rostock', 'Mecklenburg-Vorpommern', 2011, 200265],\n",
       " ['Germany', 'Hannover', 'Niedersachsen', 2011, 506416],\n",
       " ['Germany', 'Braunschweig', 'Niedersachsen', 2011, 242537],\n",
       " ['Germany', 'Osnabrück', 'Niedersachsen', 2011, 153699],\n",
       " ['Germany', 'Oldenburg', 'Niedersachsen', 2011, 157267],\n",
       " ['Germany', 'Göttingen', 'Niedersachsen', 2011, 115843],\n",
       " ['Germany', 'Wolfsburg', 'Niedersachsen', 2011, 119984],\n",
       " ['Germany', 'Salzgitter', 'Niedersachsen', 2011, 98895],\n",
       " ['Germany', 'Hildesheim', 'Niedersachsen', 2011, 99554],\n",
       " ['Germany', 'Düsseldorf', 'Nordrhein-Westfalen', 2011, 586291],\n",
       " ['Germany', 'Köln', 'Nordrhein-Westfalen', 2011, 1005775],\n",
       " ['Germany', 'Essen', 'Nordrhein-Westfalen', 2011, 566201],\n",
       " ['Germany', 'Dortmund', 'Nordrhein-Westfalen', 2011, 571143],\n",
       " ['Germany', 'Duisburg', 'Nordrhein-Westfalen', 2011, 488468],\n",
       " ['Germany', 'Bochum', 'Nordrhein-Westfalen', 2011, 362286],\n",
       " ['Germany', 'Wuppertal', 'Nordrhein-Westfalen', 2011, 342661],\n",
       " ['Germany', 'Bielefeld', 'Nordrhein-Westfalen', 2011, 326870],\n",
       " ['Germany', 'Gelsenkirchen', 'Nordrhein-Westfalen', 2011, 258766],\n",
       " ['Germany', 'Bonn', 'Nordrhein-Westfalen', 2011, 305765],\n",
       " ['Germany', 'Mönchengladbach', 'Nordrhein-Westfalen', 2011, 255188],\n",
       " ['Germany', 'Münster', 'Nordrhein-Westfalen', 2011, 289576],\n",
       " ['Germany', 'Krefeld', 'Nordrhein-Westfalen', 2011, 222247],\n",
       " ['Germany', 'Aachen', 'Nordrhein-Westfalen', 2011, 236420],\n",
       " ['Germany', 'Oberhausen', 'Nordrhein-Westfalen', 2011, 210216],\n",
       " ['Germany', 'Hagen', 'Nordrhein-Westfalen', 2011, 187944],\n",
       " ['Germany', 'Hamm', 'Nordrhein-Westfalen', 2011, 176037],\n",
       " ['Germany', 'Herne', 'Nordrhein-Westfalen', 2011, 155160],\n",
       " ['Germany', 'Mülheim an der Ruhr', 'Nordrhein-Westfalen', 2011, 166865],\n",
       " ['Germany', 'Solingen', 'Nordrhein-Westfalen', 2011, 155265],\n",
       " ['Germany', 'Leverkusen', 'Nordrhein-Westfalen', 2011, 158984],\n",
       " ['Germany', 'Neuss', 'Nordrhein-Westfalen', 2011, 150568],\n",
       " ['Germany', 'Paderborn', 'Nordrhein-Westfalen', 2011, 142365],\n",
       " ['Germany', 'Recklinghausen', 'Nordrhein-Westfalen', 2011, 115958],\n",
       " ['Germany', 'Remscheid', 'Nordrhein-Westfalen', 2011, 110708],\n",
       " ['Germany', 'Bottrop', 'Nordrhein-Westfalen', 2011, 117311],\n",
       " ['Germany', 'Siegen', 'Nordrhein-Westfalen', 2011, 99187],\n",
       " ['Germany', 'Moers', 'Nordrhein-Westfalen', 2011, 104009],\n",
       " ['Germany', 'Witten', 'Nordrhein-Westfalen', 2011, 96382],\n",
       " ['Germany', 'Bergisch Gladbach', 'Nordrhein-Westfalen', 2011, 108878],\n",
       " ['Germany', 'Mainz', 'Rheinland-Pfalz', 2011, 200344],\n",
       " ['Germany', 'Ludwigshafen', 'Rheinland-Pfalz', 2011, 157584],\n",
       " ['Germany', 'Koblenz', 'Rheinland-Pfalz', 2011, 107825],\n",
       " ['Germany', 'Kaiserslautern', 'Rheinland-Pfalz', 2011, 96340],\n",
       " ['Germany', 'Trier', 'Rheinland-Pfalz', 2011, 105671],\n",
       " ['Germany', 'Saarbrücken', 'Saarland', 2011, 175853],\n",
       " ['Germany', 'Dresden', 'Sachsen', 2011, 512354],\n",
       " ['Germany', 'Leipzig', 'Sachsen', 2011, 502979],\n",
       " ['Germany', 'Chemnitz', 'Sachsen', 2011, 240253],\n",
       " ['Germany', 'Zwickau', 'Sachsen', 2011, 93081],\n",
       " ['Germany', 'Magdeburg', 'Sachsen-Anhalt', 2011, 228144],\n",
       " ['Germany', 'Halle', 'Sachsen-Anhalt', 2011, 229153],\n",
       " ['Germany', 'Kiel', 'Schleswig-Holstein', 2011, 235782],\n",
       " ['Germany', 'Lübeck', 'Schleswig-Holstein', 2011, 210305],\n",
       " ['Germany', 'Erfurt', 'Thüringen', 2011, 200868],\n",
       " ['Germany', 'Gera', 'Thüringen', 2011, 96067],\n",
       " ['Germany', 'Jena', 'Thüringen', 2011, 105739],\n",
       " ['Hungary', 'Pécs', 'Baranya', 2011, 156049],\n",
       " ['Hungary', 'Kecskemét', 'Bács-Kiskun', 2011, 111411],\n",
       " ['Hungary', 'Békéscsaba', 'Békés', 2011, 62050],\n",
       " ['Hungary', 'Miskolc', 'Borsod-Abaúj-Zemplén', 2011, 167754],\n",
       " ['Hungary', 'Szeged', 'Csongrád', 2011, 168048],\n",
       " ['Hungary', 'Hodmezovasarhely', 'Csongrád', 2011, 168048],\n",
       " ['Hungary', 'Székesfehérvár', 'Fejér', 2011, 100570],\n",
       " ['Hungary', 'Győr', 'Győr-Moson-Sopron', 2011, 129527],\n",
       " ['Hungary', 'Debrecen', 'Hajdú-Bihar', 2011, 211320],\n",
       " ['Hungary', 'Eger', 'Heves', 2011, 56569],\n",
       " ['Hungary', 'Tatabánya', 'Komárom-Esztergom', 2011, 67753],\n",
       " ['Hungary', 'Salgotarjan', 'Komárom-Esztergom', 2011, 67753],\n",
       " ['Hungary', 'Kaposvár', 'Somogy', 2011, 66245],\n",
       " ['Hungary', 'Nyíregyháza', 'Szabolcs-Szatmár-Bereg', 2011, 119746],\n",
       " ['Hungary', 'Szolnok', 'Jász-Nagykun-Szolnok', 2011, 72953],\n",
       " ['Hungary', 'Szekszard', 'Jász-Nagykun-Szolnok', 2011, 72953],\n",
       " ['Hungary', 'Szombathely', 'Vas', 2011, 78884],\n",
       " ['Hungary', 'Veszprém', 'Veszprém', 2011, 61721],\n",
       " ['Hungary', 'Zalaegerszeg', 'Zala', 2011, 59499],\n",
       " ['Hungary', 'Budapest', 'Budapest', 2011, 1729040],\n",
       " ['Italy', 'Novara', 'Piemonte', 2011, 101952],\n",
       " ['Italy', 'Torino', 'Piemonte', 2011, 872367],\n",
       " ['Italy', 'Aosta', 'Piemonte', 2011, 872367],\n",
       " ['Italy', 'Bérgamo', 'Lombardia', 2011, 115349],\n",
       " ['Italy', 'Bréscia', 'Lombardia', 2011, 189902],\n",
       " ['Italy', 'Milano', 'Lombardia', 2011, 1242123],\n",
       " ['Italy', 'Monza', 'Lombardia', 2011, 119856],\n",
       " ['Italy', 'Bolzano', 'Trentino-Alto Adige', 2011, 102575],\n",
       " ['Italy', 'Trento', 'Trentino-Alto Adige', 2011, 114198],\n",
       " ['Italy', 'Pádova', 'Veneto', 2011, 206192],\n",
       " ['Italy', 'Verona', 'Veneto', 2011, 252520],\n",
       " ['Italy', 'Vicenza', 'Veneto', 2011, 111500],\n",
       " ['Italy', 'Venézia', 'Veneto', 2011, 261362],\n",
       " ['Italy', 'Trieste', 'Friuli-Venezia Giulia', 2011, 202123],\n",
       " ['Italy', 'La Spezia', 'Liguria', 2011, 92659],\n",
       " ['Italy', 'Génova', 'Liguria', 2011, 586180],\n",
       " ['Italy', 'Bologna', 'Emilia-Romagna', 2011, 371337],\n",
       " ['Italy', 'Ferrara', 'Emilia-Romagna', 2011, 132545],\n",
       " ['Italy', 'Forlí', 'Emilia-Romagna', 2011, 116434],\n",
       " ['Italy', 'Módena', 'Emilia-Romagna', 2011, 179149],\n",
       " ['Italy', 'Parma', 'Emilia-Romagna', 2011, 175895],\n",
       " ['Italy', 'Piacenza', 'Emilia-Romagna', 2011, 100311],\n",
       " ['Italy', 'Ravenna', 'Emilia-Romagna', 2011, 153740],\n",
       " ['Italy', \"Réggio nell'Emilia\", 'Emilia-Romagna', 2011, 162082],\n",
       " ['Italy', 'Rímini', 'Emilia-Romagna', 2011, 139601],\n",
       " ['Italy', 'Livorno', 'Toscana', 2011, 157052],\n",
       " ['Italy', 'Pisa', 'Toscana', 2011, 85858],\n",
       " ['Italy', 'Firenze', 'Toscana', 2011, 358079],\n",
       " ['Italy', 'Prato', 'Toscana', 2011, 185456],\n",
       " ['Italy', 'Perúgia', 'Umbria', 2011, 162449],\n",
       " ['Italy', 'Terni', 'Umbria', 2011, 109193],\n",
       " ['Italy', 'Ancona', 'Marche', 2011, 100497],\n",
       " ['Italy', 'Roma', 'Lazio', 2011, 2617175],\n",
       " ['Italy', 'Latina', 'Lazio', 2011, 117892],\n",
       " ['Italy', 'Pescara', 'Abruzzo', 2011, 117166],\n",
       " ['Italy', 'LAquila', 'Abruzzo', 2011, 117166],\n",
       " ['Italy', 'Campobasso', 'Abruzzo', 2011, 117166],\n",
       " ['Italy', 'Salerno', 'Campania', 2011, 132608],\n",
       " ['Italy', 'Nápoli', 'Campania', 2011, 962003],\n",
       " ['Italy', 'Torre del Greco', 'Campania', 2011, 85922],\n",
       " ['Italy', 'Giugliano in Campania', 'Campania', 2011, 108793],\n",
       " ['Italy', 'Bari', 'Puglia', 2011, 315933],\n",
       " ['Italy', 'Fóggia', 'Puglia', 2011, 147036],\n",
       " ['Italy', 'Lecce', 'Puglia', 2011, 89916],\n",
       " ['Italy', 'Andria', 'Puglia', 2011, 100052],\n",
       " ['Italy', 'Táranto', 'Puglia', 2011, 200154],\n",
       " ['Italy', 'Potenza', 'Puglia', 2011, 200154],\n",
       " ['Italy', 'Catanzaro', 'Calabria', 2011, 89364],\n",
       " ['Italy', 'Cosenza', 'Calabria', 2011, 69484],\n",
       " ['Italy', 'Réggio di Calabria', 'Calabria', 2011, 180817],\n",
       " ['Italy', 'Palermo', 'Sicilia', 2011, 657561],\n",
       " ['Italy', 'Messina', 'Sicilia', 2011, 243262],\n",
       " ['Italy', 'Catánia', 'Sicilia', 2011, 293902],\n",
       " ['Italy', 'Siracusa', 'Sicilia', 2011, 118385],\n",
       " ['Italy', 'Cágliari', 'Sardegna', 2011, 149883],\n",
       " ['Italy', 'Sássari', 'Sardegna', 2011, 123782],\n",
       " ['Liechtenstein', 'Vaduz', 'No Province', 2012, 5241],\n",
       " ['Slovakia', 'Bratislava', 'Bratislavský', 2011, 411228],\n",
       " ['Slovakia', 'Banská Bystrica', 'Banskobystrický', 2011, 80003],\n",
       " ['Slovakia', 'Žilina', 'Žilinský', 2011, 81494],\n",
       " ['Slovakia', 'Košice', 'Košický', 2011, 240433],\n",
       " ['Slovakia', 'Prešov', 'Prešovský', 2011, 91782],\n",
       " ['Slovakia', 'Nitra', 'Nitriansky', 2011, 78916],\n",
       " ['Slovakia', 'Trenčín', 'Trenčiansky', 2011, 55877],\n",
       " ['Slovakia', 'Trnava', 'Trnavský', 2011, 66358],\n",
       " ['Slovenia', 'Ljubljana', 'No Province', 2013, 282994],\n",
       " ['Slovenia', 'Maribor', 'No Province', 2013, 111374],\n",
       " ['Switzerland', 'Aarau', 'No Province', 2013, 111374],\n",
       " ['Switzerland', 'Herisau', 'No Province', 2013, 111374],\n",
       " ['Switzerland', 'Appenzell', 'No Province', 2013, 111374],\n",
       " ['Switzerland', 'Liestal', 'No Province', 2013, 111374],\n",
       " ['Switzerland', 'Basel', 'Basel-Stadt', 2013, 167386],\n",
       " ['Switzerland', 'Bern', 'Bern', 2013, 128848],\n",
       " ['Switzerland', 'Biel', 'Bern', 2013, 53031],\n",
       " ['Switzerland', 'Fribourg', 'Bern', 2013, 53031],\n",
       " ['Switzerland', 'Genève', 'Genève', 2013, 191557],\n",
       " ['Switzerland', 'Glarus', 'Genève', 2013, 191557],\n",
       " ['Switzerland', 'Chur', 'Genève', 2013, 191557],\n",
       " ['Switzerland', 'Delemont', 'Genève', 2013, 191557],\n",
       " ['Switzerland', 'Luzern', 'Luzern', 2013, 80501],\n",
       " ['Switzerland', 'Neuchatel', 'Luzern', 2013, 80501],\n",
       " ['Switzerland', 'Stans', 'Luzern', 2013, 80501],\n",
       " ['Switzerland', 'Sarnen', 'Luzern', 2013, 80501],\n",
       " ['Switzerland', 'Sankt Gallen', 'Sankt Gallen', 2013, 74581],\n",
       " ['Switzerland', 'Schaffhausen', 'Sankt Gallen', 2013, 74581],\n",
       " ['Switzerland', 'Schwyz', 'Sankt Gallen', 2013, 74581],\n",
       " ['Switzerland', 'Solothurn', 'Sankt Gallen', 2013, 74581],\n",
       " ['Switzerland', 'Frauenfeld', 'Sankt Gallen', 2013, 74581],\n",
       " ['Switzerland', 'Bellinzona', 'Sankt Gallen', 2013, 74581],\n",
       " ['Switzerland', 'Lugano', 'Ticino', 2013, 62792],\n",
       " ['Switzerland', 'Altdorf', 'Ticino', 2013, 62792],\n",
       " ['Switzerland', 'Sion', 'Ticino', 2013, 62792],\n",
       " ['Switzerland', 'Lausanne', 'Vaud', 2013, 132788],\n",
       " ['Switzerland', 'Zug', 'Vaud', 2013, 132788],\n",
       " ['Switzerland', 'Zürich', 'Zürich', 2013, 384786],\n",
       " ['Switzerland', 'Winterthur', 'Zürich', 2013, 105676],\n",
       " ['Belarus', 'Brest', 'Brest', 2009, 309764],\n",
       " ['Belarus', 'Vitebsk', 'Vitebsk', 2009, 347928],\n",
       " ['Belarus', 'Gomel', 'Gomel', 2009, 482652],\n",
       " ['Belarus', 'Grodno', 'Grodno', 2009, 327540],\n",
       " ['Belarus', 'Mogilev', 'Mogilev', 2009, 358279],\n",
       " ['Belarus', 'Bobruysk', 'Mogilev', 2009, 215092],\n",
       " ['Belarus', 'Minsk', 'Minsk City', 2009, 1836808],\n",
       " ['Latvia', 'Rīga', 'No Province', 2013, 696618],\n",
       " ['Lithuania', 'Vilnius', 'No Province', 2013, 538747],\n",
       " ['Lithuania', 'Kaunas', 'No Province', 2013, 307498],\n",
       " ['Lithuania', 'Klaipeda', 'No Province', 2013, 158891],\n",
       " ['Poland', 'Wrocław', 'Dolnośląskie', 2012, 631377],\n",
       " ['Poland', 'Legnica', 'Dolnośląskie', 2012, 102708],\n",
       " ['Poland', 'Wałbrzych', 'Dolnośląskie', 2012, 119216],\n",
       " ['Poland', 'Bydgoszcz', 'Kujawsko-Pomorskie', 2012, 362286],\n",
       " ['Poland', 'Toruń', 'Kujawsko-Pomorskie', 2012, 204847],\n",
       " ['Poland', 'Grudziadz', 'Kujawsko-Pomorskie', 2012, 98726],\n",
       " ['Poland', 'Włocławek', 'Kujawsko-Pomorskie', 2012, 115982],\n",
       " ['Poland', 'Lublin', 'Lubelskie', 2012, 348120],\n",
       " ['Poland', 'Zielona Góra', 'Lubuskie', 2012, 119182],\n",
       " ['Poland', 'Gorzów Wielkopolski', 'Lubuskie', 2012, 124470],\n",
       " ['Poland', 'Łódź', 'Łódzkie', 2012, 722022],\n",
       " ['Poland', 'Kraków', 'Małopolskie', 2012, 759131],\n",
       " ['Poland', 'Tarnów', 'Małopolskie', 2012, 113188],\n",
       " ['Poland', 'Warszawa', 'Mazowieckie', 2012, 1711324],\n",
       " ['Poland', 'Płock', 'Mazowieckie', 2012, 124048],\n",
       " ['Poland', 'Radom', 'Mazowieckie', 2012, 220062],\n",
       " ['Poland', 'Opole', 'Opolskie', 2012, 122120],\n",
       " ['Poland', 'Rzeszów', 'Podkarpackie', 2012, 180776],\n",
       " ['Poland', 'Białystok', 'Podlaskie', 2012, 294675],\n",
       " ['Poland', 'Gdańsk', 'Pomorskie', 2012, 460354],\n",
       " ['Poland', 'Gdynia', 'Pomorskie', 2012, 248574],\n",
       " ['Poland', 'Katowice', 'Śląskie', 2012, 308269],\n",
       " ['Poland', 'Jastrzebie Zdroj', 'Śląskie', 2012, 92465],\n",
       " ['Poland', 'Sosnowiec', 'Śląskie', 2012, 214488],\n",
       " ['Poland', 'Dąbrowa Górnicza', 'Śląskie', 2012, 125063],\n",
       " ['Poland', 'Bytom', 'Śląskie', 2012, 175377],\n",
       " ['Poland', 'Gliwice', 'Śląskie', 2012, 186347],\n",
       " ['Poland', 'Zabrze', 'Śląskie', 2012, 179861],\n",
       " ['Poland', 'Tychy', 'Śląskie', 2012, 129087],\n",
       " ['Poland', 'Ruda Śląska', 'Śląskie', 2012, 142672],\n",
       " ['Poland', 'Rybnik', 'Śląskie', 2012, 140863],\n",
       " ['Poland', 'Chorzów', 'Śląskie', 2012, 111314],\n",
       " ['Poland', 'Częstochowa', 'Śląskie', 2012, 235156],\n",
       " ['Poland', 'Bielsko-Biała', 'Śląskie', 2012, 174291],\n",
       " ['Poland', 'Kielce', 'Świętokrzyskie', 2012, 201363],\n",
       " ['Poland', 'Olsztyn', 'Warmińsko-Mazurskie', 2012, 175482],\n",
       " ['Poland', 'Elbląg', 'Warmińsko-Mazurskie', 2012, 123977],\n",
       " ['Poland', 'Poznań', 'Wielkopolskie', 2012, 552393],\n",
       " ['Poland', 'Kalisz', 'Wielkopolskie', 2012, 104867],\n",
       " ['Poland', 'Szczecin', 'Zachodniopomorskie', 2012, 409211],\n",
       " ['Poland', 'Koszalin', 'Zachodniopomorskie', 2012, 109183],\n",
       " ['Ukraine', 'Cherkasy', 'Cherkas´ka', 2012, 286163],\n",
       " ['Ukraine', 'Chernihiv', 'Chernihivs´ka', 2012, 296723],\n",
       " ['Ukraine', 'Chernivtsi', 'Chernivets´ka', 2012, 255929],\n",
       " ['Ukraine', 'Dnipropetrovs´k', 'Dnipropetrovs´ka', 2012, 999577],\n",
       " ['Ukraine', 'Kryvyi Rih', 'Dnipropetrovs´ka', 2012, 660203],\n",
       " ['Ukraine', 'Dniprodzerzhyns´k', 'Dnipropetrovs´ka', 2012, 242646],\n",
       " ['Ukraine', 'Nikopol´', 'Dnipropetrovs´ka', 2012, 120000],\n",
       " ['Ukraine', 'Donets´k', 'Donets´ka', 2012, 955041],\n",
       " ['Ukraine', 'Mariupol´', 'Donets´ka', 2012, 464457],\n",
       " ['Ukraine', 'Makiïvka', 'Donets´ka', 2012, 356118],\n",
       " ['Ukraine', 'Horlivka', 'Donets´ka', 2012, 258879],\n",
       " ['Ukraine', 'Kramators´k', 'Donets´ka', 2012, 165469],\n",
       " ['Ukraine', 'Ivano-Frankivs´k', 'Ivano-Frankivs´ka', 2012, 224660],\n",
       " ['Ukraine', 'Kharkiv', 'Kharkivs´ka', 2012, 1441362],\n",
       " ['Ukraine', 'Kherson', 'Khersons´ka', 2012, 300666],\n",
       " ['Ukraine', 'Khmel´nyts´kyi', 'Khmel´nyts´ka', 2012, 263703],\n",
       " ['Ukraine', 'Prypjat', 'Kyïvs´ka', 2001, 0],\n",
       " ['Ukraine', 'Kirovohrad', 'Kirovohrads´ka', 2012, 234919],\n",
       " ['Ukraine', 'Luhans´k', 'Luhans´ka', 2012, 427187],\n",
       " ['Ukraine', 'L´viv', 'L´vivs´ka', 2012, 729842],\n",
       " ['Ukraine', 'Mykolaïv', 'Mykolaïvs´ka', 2012, 497032],\n",
       " ['Ukraine', 'Odesa', 'Odes´ka', 2012, 1008162],\n",
       " ['Ukraine', 'Poltava', 'Poltavs´ka', 2012, 297589],\n",
       " ['Ukraine', 'Kremenchuk', 'Poltavs´ka', 2012, 226434],\n",
       " ['Ukraine', 'Rivne', 'Rivnens´ka', 2012, 250174],\n",
       " ['Ukraine', 'Sumy', 'Sums´ka', 2012, 269663],\n",
       " ['Ukraine', 'Ternopil´', 'Ternopil´s´ka', 2012, 217300],\n",
       " ['Ukraine', 'Vinnytsia', 'Vinnyts´ka', 2012, 370814],\n",
       " ['Ukraine', 'Luts´k', 'Volyns´ka', 2012, 213063],\n",
       " ['Ukraine', 'Uzhhorod', 'Zakarpats´ka', 2012, 116556],\n",
       " ['Ukraine', 'Zaporizhzhia', 'Zaporiz´ka', 2012, 772627],\n",
       " ['Ukraine', 'Melitopol´', 'Zaporiz´ka', 2012, 156885],\n",
       " ['Ukraine', 'Zhytomyr', 'Zhytomyrs´ka', 2012, 271895],\n",
       " ['Ukraine', 'Simferopol´', 'Krym', 2012, 335582],\n",
       " ['Ukraine', 'Kerch', 'Krym', 2012, 145845],\n",
       " ['Ukraine', 'Kyïv', 'Kyïv', 2012, 2814258],\n",
       " ['Ukraine', 'Bila Tserkva', 'Kyïv', 2012, 210551],\n",
       " ['Ukraine', 'Sevastopol´', 'Sevastopol´', 2012, 340559],\n",
       " ['Russia', 'Petrozavodsk', 'Karelia', 2013, 268946],\n",
       " ['Russia', 'Syktyvkar', 'Komi', 2010, 235006],\n",
       " ['Russia', 'Ukhta', 'Komi', 2010, 99591],\n",
       " ['Russia', 'Vorkuta', 'Komi', 2010, 70548],\n",
       " ['Russia', 'Arkhangelsk', 'Arkhangel´skaya', 2013, 350985],\n",
       " ['Russia', 'Severodvinsk', 'Arkhangel´skaya', 2010, 192353],\n",
       " ['Russia', 'Vologda', 'Vologodskaya', 2013, 306487],\n",
       " ['Russia', 'Cherepovets', 'Vologodskaya', 2013, 315738],\n",
       " ['Russia', 'Murmansk', 'Murmanskaya', 2013, 302468],\n",
       " ['Russia', 'Kaliningrad', 'Kaliningradskaya', 2013, 441376],\n",
       " ['Russia', 'Sankt Peterburg', 'Sankt-Peterburg', 2013, 5028000],\n",
       " ['Russia', 'Velikij Novgorod', 'Novgorodskaya', 2010, 218717],\n",
       " ['Russia', 'Pskov', 'Pskovskaya', 2010, 203279],\n",
       " ['Russia', 'Bryansk', 'Bryanskaya', 2013, 410837],\n",
       " ['Russia', 'Vladimir', 'Vladimirskaya', 2013, 347930],\n",
       " ['Russia', 'Kovrov', 'Vladimirskaya', 2010, 145214],\n",
       " ['Russia', 'Murom', 'Vladimirskaya', 2010, 116075],\n",
       " ['Russia', 'Ivanovo', 'Ivanovskaya', 2013, 409075],\n",
       " ['Russia', 'Kaluga', 'Kaluzhskaya', 2013, 331351],\n",
       " ['Russia', 'Obninsk', 'Kaluzhskaya', 2010, 104739],\n",
       " ['Russia', 'Kostroma', 'Kostromskaya', 2013, 271445],\n",
       " ['Russia', 'Moskva', 'Moscow', 2013, 11979529],\n",
       " ['Russia', \"Podol'sk\", 'Moskovskaya', 2010, 187961],\n",
       " ['Russia', 'Železnodorožnyj', 'Moskovskaya', 2010, 131257],\n",
       " ['Russia', 'Krasnogorsk', 'Moskovskaya', 2010, 116896],\n",
       " ['Russia', \"L'ubercy\", 'Moskovskaya', 2010, 172525],\n",
       " ['Russia', 'Kolomna', 'Moskovskaya', 2010, 144589],\n",
       " ['Russia', 'Mytišči', 'Moskovskaya', 2010, 173160],\n",
       " ['Russia', \"Elektrostal'\", 'Moskovskaya', 2010, 155196],\n",
       " ['Russia', 'Serpuchov', 'Moskovskaya', 2010, 127041],\n",
       " ['Russia', 'Balašicha', 'Moskovskaya', 2010, 215494],\n",
       " ['Russia', 'Chimki', 'Moskovskaya', 2010, 207425],\n",
       " ['Russia', 'Odincovo', 'Moskovskaya', 2010, 138930],\n",
       " ['Russia', 'Orechovo-Zujevo', 'Moskovskaya', 2010, 120670],\n",
       " ['Russia', 'Noginsk', 'Moskovskaya', 2010, 100072],\n",
       " ['Russia', 'Ščëlkovo', 'Moskovskaya', 2010, 110411],\n",
       " ['Russia', 'Sergijev Posad', 'Moskovskaya', 2010, 111179],\n",
       " ['Russia', 'Korolëv', 'Moskovskaya', 2010, 183402],\n",
       " ['Russia', 'Žukovskij', 'Moskovskaya', 2010, 104736],\n",
       " ['Russia', 'Puškino', 'Moskovskaya', 2010, 102874],\n",
       " ['Russia', 'Orel', 'Orlovskaya', 2013, 318136],\n",
       " ['Russia', 'Ryazan', 'Ryazanskaya', 2013, 527905],\n",
       " ['Russia', 'Smolensk', 'Smolenskaya', 2013, 330970],\n",
       " ['Russia', 'Tver', 'Tverskaya', 2013, 408877],\n",
       " ['Russia', 'Tula', 'Tul´skaya', 2013, 493813],\n",
       " ['Russia', 'Novomoskovsk', 'Tul´skaya', 2010, 131386],\n",
       " ['Russia', 'Yaroslavl', 'Yaroslavskaya', 2013, 599169],\n",
       " ['Russia', 'Rybinsk', 'Yaroslavskaya', 2010, 200771],\n",
       " ['Russia', 'Yoshkar-Ola', 'Mariy-El', 2013, 257015],\n",
       " ['Russia', 'Saransk', 'Mordoviya', 2013, 298287],\n",
       " ['Russia', 'Cheboksary', 'Chuvash', 2013, 464940],\n",
       " ['Russia', 'Novočeboksarsk', 'Chuvash', 2010, 124097],\n",
       " ['Russia', 'Kirov', 'Kirov', 2013, 483176],\n",
       " ['Russia', 'Nizhnii Novgorod', 'Nizhnii Novgorod', 2013, 1259921],\n",
       " ['Russia', 'Dzeržinsk', 'Nizhnii Novgorod', 2010, 240742],\n",
       " ['Russia', 'Arzamas', 'Nizhnii Novgorod', 2010, 106362],\n",
       " ['Russia', 'Belgorod', 'Belgorodskaya', 2013, 373528],\n",
       " ['Russia', 'Staryj Oskol', 'Belgorodskaya', 2010, 221085],\n",
       " ['Russia', 'Voronezh', 'Voronezhskaya', 2013, 1003638],\n",
       " ['Russia', 'Kursk', 'Kurskaya', 2013, 428741],\n",
       " ['Russia', 'Lipetsk', 'Lipetskaya', 2013, 509098],\n",
       " ['Russia', 'Jelec', 'Lipetskaya', 2010, 108404],\n",
       " ['Russia', 'Tambov', 'Tambovskaya', 2013, 281834],\n",
       " ['Russia', 'Elista', 'Kalmykiya', 2010, 103749],\n",
       " ['Russia', 'Kazan', 'Tatarstan', 2013, 1176187],\n",
       " ['Russia', 'Naberezhnye Tchelny', 'Tatarstan', 2013, 519025],\n",
       " ['Russia', 'Nižnekamsk', 'Tatarstan', 2010, 234044],\n",
       " ['Russia', \"Al'metjevsk\", 'Tatarstan', 2010, 146393],\n",
       " ['Russia', 'Astrakhan', 'Astrakhanskaya', 2013, 527345],\n",
       " ['Russia', 'Volgograd', 'Volgogradskaya', 2013, 1018790],\n",
       " ['Russia', 'Volzhsky', 'Volgogradskaya', 2013, 327356],\n",
       " ['Russia', 'Kamyšin', 'Volgogradskaya', 2010, 119565],\n",
       " ['Russia', 'Penza', 'Penza', 2013, 519900],\n",
       " ['Russia', 'Samara', 'Samara', 2013, 1171598],\n",
       " ['Russia', 'Tolyatti', 'Samara', 2013, 719149],\n",
       " ['Russia', \"Syzran'\", 'Samara', 2010, 178750],\n",
       " ['Russia', 'Novokujbyševsk', 'Samara', 2010, 108438],\n",
       " ['Russia', 'Saratov', 'Saratov', 2013, 839755],\n",
       " ['Russia', 'Balakovo', 'Saratov', 2010, 199690],\n",
       " ['Russia', \"Ėngel's\", 'Saratov', 2010, 202419],\n",
       " ['Russia', 'Ulyanovsk', 'Ul´yanovsk', 2013, 615306],\n",
       " ['Russia', 'Dimitrovgrad', 'Ul´yanovsk', 2010, 122580],\n",
       " ['Russia', 'Rostov-na-Donu', 'Rostovskaya', 2013, 1103733],\n",
       " ['Russia', 'Batajsk', 'Rostovskaya', 2010, 111843],\n",
       " ['Russia', 'Taganrog', 'Rostovskaya', 2013, 254783],\n",
       " ['Russia', 'Šachty', 'Rostovskaya', 2010, 239987],\n",
       " ['Russia', 'Novočerkassk', 'Rostovskaya', 2010, 168746],\n",
       " ['Russia', 'Volgodonsk', 'Rostovskaya', 2010, 170841],\n",
       " ['Russia', 'Novošachtinsk', 'Rostovskaya', 2010, 111075],\n",
       " ['Russia', 'Ufa', 'Bashkortostan', 2013, 1077719],\n",
       " ['Russia', 'Sterlitamak', 'Bashkortostan', 2013, 275798],\n",
       " ['Russia', 'Salavat', 'Bashkortostan', 2010, 156095],\n",
       " ['Russia', \"Okt'abr'skij\", 'Bashkortostan', 2010, 109474],\n",
       " ['Russia', 'Izhevsk', 'Udmurt', 2013, 632913],\n",
       " ['Russia', 'Sarapul', 'Udmurt', 2010, 101381],\n",
       " ['Russia', 'Orenburg', 'Orenburg', 2013, 556127],\n",
       " ['Russia', 'Orsk', 'Orenburg', 2010, 239800],\n",
       " ['Russia', 'Perm', 'Perm', 2013, 1013887],\n",
       " ['Russia', 'Berezniki', 'Perm', 2010, 156466],\n",
       " ['Russia', 'Majkop', 'Adygeya', 2010, 144249],\n",
       " ['Russia', 'Makhachkala', 'Dagestan', 2013, 576194],\n",
       " ['Russia', 'Derbent', 'Dagestan', 2010, 119200],\n",
       " ['Russia', 'Kaspijsk', 'Dagestan', 2010, 100129],\n",
       " ['Russia', 'Chasavjurt', 'Dagestan', 2010, 131187],\n",
       " ['Russia', \"Nazran'\", 'Ingushskaya', 2010, 93335],\n",
       " ['Russia', \"Nal'čik\", 'Kabardino-Balkarskaya', 2010, 240203],\n",
       " ['Russia', 'Čerkessk', 'Karachayevo-Cherkesskaya', 2010, 129069],\n",
       " ['Russia', 'Vladikavkaz', 'North Ossetia-Alania', 2013, 308285],\n",
       " ['Russia', 'Grozny', 'Chechenskaya', 2013, 277414],\n",
       " ['Russia', 'Krasnodar', 'Krasnodarskiy', 2013, 784048],\n",
       " ['Russia', 'Sochi', 'Krasnodarskiy', 2013, 368011],\n",
       " ['Russia', 'Novorossiysk', 'Krasnodarskiy', 2013, 251013],\n",
       " ['Russia', 'Armavir', 'Krasnodarskiy', 2010, 188832],\n",
       " ['Russia', 'Stavropol', 'Stavropol´skiy', 2013, 412116],\n",
       " ['Russia', \"P'atigorsk\", 'Stavropol´skiy', 2010, 142511],\n",
       " ['Russia', 'Nevinnomyssk', 'Stavropol´skiy', 2010, 118360],\n",
       " ['Russia', 'Kislovodsk', 'Stavropol´skiy', 2010, 128553],\n",
       " ['Russia', 'Jessentuki', 'Stavropol´skiy', 2010, 100996],\n",
       " ['Russia', 'Neftekamsk', 'Stavropol´skiy', 2010, 121733],\n",
       " ['Russia', 'Kurgan', 'Kurgan', 2013, 325565],\n",
       " ['Russia', 'Yekaterinburg', 'Sverdlov', 2013, 1396074],\n",
       " ['Russia', 'Nizhny Tagil', 'Sverdlov', 2013, 358378],\n",
       " ['Russia', \"Kamensk-Ural'skij\", 'Sverdlov', 2010, 174689],\n",
       " ['Russia', \"Pervoural'sk\", 'Sverdlov', 2010, 124528],\n",
       " ['Russia', 'Chelyabinsk', 'Chelyabinsk', 2013, 1156201],\n",
       " ['Russia', 'Magnitogorsk', 'Chelyabinsk', 2013, 411880],\n",
       " ['Russia', 'Zlatoust', 'Chelyabinsk', 2010, 174962],\n",
       " ['Russia', 'Miass', 'Chelyabinsk', 2010, 151751],\n",
       " ['Russia', 'Kopejsk', 'Chelyabinsk', 2010, 137601],\n",
       " ['Russia', 'Gorno Altaysk', 'Altay', 2010, 56933],\n",
       " ['Russia', 'Barnaul', 'Altayskiy', 2013, 629681],\n",
       " ['Russia', 'Bijsk', 'Altayskiy', 2010, 210115],\n",
       " ['Russia', 'Rubcovsk', 'Altayskiy', 2010, 147002],\n",
       " ['Russia', 'Kemerovo', 'Kemerov', 2013, 540095],\n",
       " ['Russia', 'Novokuznetsk', 'Kemerov', 2013, 549182],\n",
       " ['Russia', 'Prokopjevsk', 'Kemerov', 2010, 210130],\n",
       " ['Russia', 'Novosibirsk', 'Novosibirsk', 2013, 1523801],\n",
       " ['Russia', 'Omsk', 'Omsk', 2013, 1160670],\n",
       " ['Russia', 'Tomsk', 'Tomsk', 2013, 547989],\n",
       " ['Russia', 'Seversk', 'Tomsk', 2010, 108590],\n",
       " ['Russia', 'Tyumen', 'Tyumen', 2013, 634171],\n",
       " ['Russia', 'Ulan-Ude', 'Buryat', 2013, 416079],\n",
       " ['Russia', 'Kyzyl', 'Tyva', 2010, 109918],\n",
       " ['Russia', 'Abakan', 'Khakasiya', 2010, 165214],\n",
       " ['Russia', 'Krasnoyarsk', 'Krasnoyarsk', 2013, 1016385],\n",
       " ['Russia', \"Noril'sk\", 'Krasnoyarsk', 2010, 175365],\n",
       " ['Russia', 'Ačinsk', 'Krasnoyarsk', 2010, 109155],\n",
       " ['Russia', 'Irkutsk', 'Irkutsk', 2013, 606137],\n",
       " ['Russia', 'Angarsk', 'Irkutsk', 2010, 233567],\n",
       " ['Russia', 'Bratsk', 'Irkutsk', 2010, 246319],\n",
       " ['Russia', 'Chita', 'Zabaykalskiy', 2013, 331346],\n",
       " ['Russia', 'Yakutsk', 'Sakha', 2013, 286456],\n",
       " ['Russia', 'Birobidzhan', 'Jewish ao.', 2010, 75413],\n",
       " ['Russia', 'Anadyr', 'Chukotka', 2010, 13045],\n",
       " ['Russia', 'Vladivostok', 'Primorskiy', 2013, 600378],\n",
       " ['Russia', 'Nachodka', 'Primorskiy', 2010, 159719],\n",
       " ['Russia', 'Ussurijsk', 'Primorskiy', 2010, 158004],\n",
       " ['Russia', 'Khabarovsk', 'Khabarov', 2013, 593636],\n",
       " ['Russia', 'Komsomolsk-na-Amure', 'Khabarov', 2013, 257891],\n",
       " ['Russia', 'Blagoveščensk', 'Amur', 2010, 214390],\n",
       " ['Russia', 'Petropavlovsk-Kamčatskij', 'Kamchatka', 2010, 179780],\n",
       " ['Russia', 'Magadan', 'Magadan', 2010, 95982],\n",
       " ['Russia', 'Okhotsk', 'Magadan', 2010, 4215],\n",
       " ['Russia', 'Južno-Sachalinsk', 'Sakhalin', 2010, 181728],\n",
       " ['Russia', 'Khanty Mansijsk', 'Khanty Mansi ao', 2010, 80151],\n",
       " ['Russia', 'Surgut', 'Khanty Mansi ao', 2013, 325511],\n",
       " ['Russia', 'Nizhnevartovsk', 'Khanty Mansi ao', 2013, 263228],\n",
       " ['Russia', 'Neftejugansk', 'Khanty Mansi ao', 2010, 122855],\n",
       " ['Russia', 'Salekhard', 'Yamalo Nenets ao', 2010, 42544],\n",
       " ['Russia', \"Nojabr'sk\", 'Yamalo Nenets ao', 2010, 110620],\n",
       " ['Russia', 'Novyj Urengoj', 'Yamalo Nenets ao', 2010, 104107],\n",
       " ['Belgium', 'Bruxelles', 'Bruxelles', 2013, 168576],\n",
       " ['Belgium', 'Schaerbeek', 'Bruxelles', 2013, 130587],\n",
       " ['Belgium', 'Molenbeek-Saint-Jean', 'Bruxelles', 2013, 94653],\n",
       " ['Belgium', 'Anderlecht', 'Bruxelles', 2013, 113462],\n",
       " ['Belgium', 'Antwerpen', 'Antwerpen', 2013, 507911],\n",
       " ['Belgium', 'Gent', 'Oost-Vlaanderen', 2013, 248813],\n",
       " ['Belgium', 'Charleroi', 'Hainaut', 2013, 203753],\n",
       " ['Belgium', 'Mons', 'Hainaut', 2013, 93941],\n",
       " ['Belgium', 'Liège', 'Liège', 2013, 195931],\n",
       " ['Belgium', 'Hasselt', 'Limburg', 2013, 75579],\n",
       " ['Belgium', 'Arlon', 'Luxembourg', 2013, 28759],\n",
       " ['Belgium', 'Namur', 'Namur', 2013, 110500],\n",
       " ['Belgium', 'Brugge', 'West-Vlaanderen', 2013, 117577],\n",
       " ['Belgium', 'Wavre', 'West-Vlaanderen', 2013, 117577],\n",
       " ['Belgium', 'Leuven', 'Vlaams-Brabant', 2013, 97692],\n",
       " ['Luxembourg', 'Luxembourg', 'No Province', 2012, 99852],\n",
       " ['Netherlands', 'Groningen', 'Groningen', 2014, 198023],\n",
       " ['Netherlands', 'Leeuwarden', 'Friesland', 2014, 108145],\n",
       " ['Netherlands', 'Assen', 'Friesland', 2014, 108145],\n",
       " ['Netherlands', 'Enschede', 'Overijssel', 2014, 158494],\n",
       " ['Netherlands', 'Zwolle', 'Overijssel', 2014, 123440],\n",
       " ['Netherlands', 'Lelystad', 'Flevoland', 2014, 76252],\n",
       " ['Netherlands', 'Almere', 'Flevoland', 2014, 196244],\n",
       " ['Netherlands', 'Arnhem', 'Gelderland', 2014, 150989],\n",
       " ['Netherlands', 'Nijmegen', 'Gelderland', 2014, 168810],\n",
       " ['Netherlands', 'Apeldoorn', 'Gelderland', 2014, 157540],\n",
       " ['Netherlands', 'Utrecht', 'Utrecht', 2014, 330081],\n",
       " ['Netherlands', 'Amersfoort', 'Utrecht', 2014, 151270],\n",
       " ['Netherlands', 'Amsterdam', 'Noord-Holland', 2014, 812895],\n",
       " ['Netherlands', 'Haarlem', 'Noord-Holland', 2014, 155361],\n",
       " ['Netherlands', 'Zaanstad', 'Noord-Holland', 2014, 151058],\n",
       " ['Netherlands', 'Hilversum', 'Noord-Holland', 2014, 86738],\n",
       " ['Netherlands', 'Den Haag', 'Zuid-Holland', 2014, 509623],\n",
       " ['Netherlands', 'Rotterdam', 'Zuid-Holland', 2014, 619180],\n",
       " ['Netherlands', 'Dordrecht', 'Zuid-Holland', 2014, 118780],\n",
       " ['Netherlands', 'Leiden', 'Zuid-Holland', 2014, 121387],\n",
       " ['Netherlands', 'Middelburg', 'Zuid-Holland', 2014, 121387],\n",
       " ['Netherlands', \"'s-Hertogenbosch\", 'Noord-Brabant', 2014, 143822],\n",
       " ['Netherlands', 'Eindhoven', 'Noord-Brabant', 2014, 221279],\n",
       " ['Netherlands', 'Tilburg', 'Noord-Brabant', 2014, 210283],\n",
       " ['Netherlands', 'Breda', 'Noord-Brabant', 2014, 180263],\n",
       " ['Netherlands', 'Maastricht', 'Limburg', 2014, 122243],\n",
       " ['Netherlands', 'Heerlen', 'Limburg', 2014, 88139],\n",
       " ['Netherlands', 'Sittard-Geleen', 'Limburg', 2014, 93726],\n",
       " ['Bosnia and Herzegovina',\n",
       "  'Sarajevo',\n",
       "  'Federacija Bosne i Hercegovine',\n",
       "  2013,\n",
       "  291422],\n",
       " ['Bosnia and Herzegovina',\n",
       "  'Tuzla',\n",
       "  'Federacija Bosne i Hercegovine',\n",
       "  2013,\n",
       "  120441],\n",
       " ['Bosnia and Herzegovina',\n",
       "  'Zenica',\n",
       "  'Federacija Bosne i Hercegovine',\n",
       "  2013,\n",
       "  115134],\n",
       " ['Bosnia and Herzegovina',\n",
       "  'Mostar',\n",
       "  'Federacija Bosne i Hercegovine',\n",
       "  2013,\n",
       "  113169],\n",
       " ['Bosnia and Herzegovina', 'Banja Luka', 'Republika Srpska', 2013, 199191],\n",
       " ['Bosnia and Herzegovina', 'Bijeljina', 'Republika Srpska', 2013, 114663],\n",
       " ['Bosnia and Herzegovina', 'Brčko', 'Brčko', 2013, 93028],\n",
       " ['Croatia', 'Zagreb', 'No Province', 2011, 686568],\n",
       " ['Croatia', 'Split', 'No Province', 2011, 165893],\n",
       " ['Croatia', 'Rijeka', 'No Province', 2011, 127498],\n",
       " ['Croatia', 'Osijek', 'No Province', 2011, 83496],\n",
       " ['Croatia', 'Zadar', 'No Province', 2011, 70674],\n",
       " ['Bulgaria', 'Sofia', 'No Province', 2011, 1270284],\n",
       " ['Bulgaria', 'Plovdiv', 'No Province', 2011, 331796],\n",
       " ['Bulgaria', 'Varna', 'No Province', 2011, 330486],\n",
       " ['Bulgaria', 'Burgas', 'No Province', 2011, 197301],\n",
       " ['Bulgaria', 'Ruse', 'No Province', 2011, 146609],\n",
       " ['Bulgaria', 'Stara Zagora', 'No Province', 2011, 136363],\n",
       " ['Romania', 'Alba Iulia', 'No Province', 2011, 136363],\n",
       " ['Romania', 'Arad', 'Arad', 2011, 159074],\n",
       " ['Romania', 'Piteşti', 'Argeş', 2011, 155383],\n",
       " ['Romania', 'Bacău', 'Bacău', 2011, 144307],\n",
       " ['Romania', 'Oradea', 'Bihor', 2011, 196367],\n",
       " ['Romania', 'Bistrita', 'Bihor', 2011, 196367],\n",
       " ['Romania', 'Botoşani', 'Botoşani', 2011, 106847],\n",
       " ['Romania', 'Brăila', 'Brăila', 2011, 180302],\n",
       " ['Romania', 'Braşov', 'Braşov', 2011, 253200],\n",
       " ['Romania', 'Bucureşti', 'Bucureşti', 2011, 1883425],\n",
       " ['Romania', 'Buzău', 'Buzău', 2011, 115494],\n",
       " ['Romania', 'Calarasi', 'Buzău', 2011, 115494],\n",
       " ['Romania', 'Resita', 'Buzău', 2011, 115494],\n",
       " ['Romania', 'Cluj-Napoca', 'Cluj', 2011, 324576],\n",
       " ['Romania', 'Constanţa', 'Constanţa', 2011, 283872],\n",
       " ['Romania', 'Sfintu Gheorghe', 'Constanţa', 2011, 283872],\n",
       " ['Romania', 'Targoviste', 'Constanţa', 2011, 283872],\n",
       " ['Romania', 'Craiova', 'Dolj', 2011, 269506],\n",
       " ['Romania', 'Galaţi', 'Galaţi', 2011, 249432],\n",
       " ['Romania', 'Giurgiu', 'Galaţi', 2011, 249432],\n",
       " ['Romania', 'Tirgu Jiu', 'Galaţi', 2011, 249432],\n",
       " ['Romania', 'Miercurea Ciuc', 'Galaţi', 2011, 249432],\n",
       " ['Romania', 'Deva', 'Galaţi', 2011, 249432],\n",
       " ['Romania', 'Slobozia', 'Galaţi', 2011, 249432],\n",
       " ['Romania', 'Iaşi', 'Iaşi', 2011, 290422],\n",
       " ['Romania', 'Baia Mare', 'Maramureş', 2011, 123738],\n",
       " ['Romania', 'Drobeta-Turnu Severin', 'Mehedinţi', 2011, 92617],\n",
       " ['Romania', 'Târgu Mureş', 'Mureş', 2011, 134290],\n",
       " ['Romania', 'Piatra-Neamţ', 'Neamţ', 2011, 85055],\n",
       " ['Romania', 'Slatina', 'Neamţ', 2011, 85055],\n",
       " ['Romania', 'Ploieşti', 'Prahova', 2011, 209945],\n",
       " ['Romania', 'Zalau', 'Prahova', 2011, 209945],\n",
       " ['Romania', 'Satu Mare', 'Satu-Mare', 2011, 102411],\n",
       " ['Romania', 'Sibiu', 'Sibiu', 2011, 147245],\n",
       " ['Romania', 'Suceava', 'Suceava', 2011, 92121],\n",
       " ['Romania', 'Alexandria', 'Suceava', 2011, 92121],\n",
       " ['Romania', 'Timişoara', 'Timiş', 2011, 319279],\n",
       " ['Romania', 'Tulcea', 'Timiş', 2011, 319279],\n",
       " ['Romania', 'Vaslui', 'Timiş', 2011, 319279],\n",
       " ['Romania', 'Râmnicu Vâlcea', 'Vâlcea', 2011, 98776],\n",
       " ['Romania', 'Focsani', 'Vâlcea', 2011, 98776],\n",
       " ['Turkey', 'Adana', 'Adana', 2012, 1636229],\n",
       " ['Turkey', 'Adiyaman', 'Adıyaman', 2012, 217463],\n",
       " ['Turkey', 'Afyonkarahisar', 'Afyonkarahisar', 2012, 186991],\n",
       " ['Turkey', 'Agri', 'Ağrı', 2012, 107839],\n",
       " ['Turkey', 'Aksaray', 'Aksaray', 2012, 186599],\n",
       " ['Turkey', 'Amasya', 'Amasya', 2012, 91874],\n",
       " ['Turkey', 'Ankara', 'Ankara', 2012, 4630735],\n",
       " ['Turkey', 'Antalya', 'Antalya', 2012, 1073794],\n",
       " ['Turkey', 'Artvin', 'Antalya', 2012, 1073794],\n",
       " ['Turkey', 'Aydin', 'Aydın', 2012, 195951],\n",
       " ['Turkey', 'Balikesir', 'Balıkesir', 2012, 267903],\n",
       " ['Turkey', 'Batman', 'Batman', 2012, 348963],\n",
       " ['Turkey', 'Bayburt', 'Batman', 2012, 348963],\n",
       " ['Turkey', 'Bilecik', 'Batman', 2012, 348963],\n",
       " ['Turkey', 'Bingol', 'Bingöl', 2012, 98424],\n",
       " ['Turkey', 'Bitlis', 'Bingöl', 2012, 98424],\n",
       " ['Turkey', 'Bolu', 'Bolu', 2012, 131264],\n",
       " ['Turkey', 'Burdur', 'Bolu', 2012, 131264],\n",
       " ['Turkey', 'Bursa', 'Bursa', 2012, 1734705],\n",
       " ['Turkey', 'İnegöl', 'Bursa', 2012, 177617],\n",
       " ['Turkey', 'Canakkale', 'Çanakkale', 2012, 111137],\n",
       " ['Turkey', 'Cankiri', 'Çanakkale', 2012, 111137],\n",
       " ['Turkey', 'Corum', 'Çorum', 2012, 231146],\n",
       " ['Turkey', 'Denizli', 'Denizli', 2012, 525497],\n",
       " ['Turkey', 'Diyarbakir', 'Diyarbakır', 2012, 892713],\n",
       " ['Turkey', 'Edirne', 'Edirne', 2012, 148474],\n",
       " ['Turkey', 'Elazig', 'Elazığ', 2012, 347857],\n",
       " ['Turkey', 'Erzincan', 'Erzincan', 2012, 96474],\n",
       " ['Turkey', 'Erzurum', 'Erzurum', 2012, 384399],\n",
       " ['Turkey', 'Eskisehir', 'Eskişehir', 2012, 659924],\n",
       " ['Turkey', 'Gaziantep', 'Gaziantep', 2012, 1438373],\n",
       " ['Turkey', 'Giresun', 'Giresun', 2012, 100712],\n",
       " ['Turkey', 'Gumushane', 'Giresun', 2012, 100712],\n",
       " ['Turkey', 'Hakkari', 'Giresun', 2012, 100712],\n",
       " ['Turkey', 'Iskenderun', 'Hatay', 2012, 184833],\n",
       " ['Turkey', 'Hatay', 'Hatay', 2012, 216960],\n",
       " ['Turkey', 'Mersin', 'Mersin', 2012, 876958],\n",
       " ['Turkey', 'Tarsus', 'Mersin', 2012, 245671],\n",
       " ['Turkey', 'Isparta', 'Isparta', 2012, 198385],\n",
       " ['Turkey', 'Istanbul', 'İstanbul', 2012, 13710512],\n",
       " ['Turkey', 'Izmir', 'İzmir', 2012, 3401994],\n",
       " ['Turkey', 'Karaman', 'Karaman', 2012, 141630],\n",
       " ['Turkey', 'Kahramanmaraş', 'Kahramanmaraş', 2012, 443575],\n",
       " ['Turkey', 'Kars', 'Kars', 2012, 78100],\n",
       " ['Turkey', 'Kastamonu', 'Kastamonu', 2012, 96217],\n",
       " ['Turkey', 'Kayseri', 'Kayseri', 2012, 1004276],\n",
       " ['Turkey', 'Kirikkale', 'Kırıkkale', 2012, 192473],\n",
       " ['Turkey', 'Kirklareli', 'Kırıkkale', 2012, 192473],\n",
       " ['Turkey', 'Luleburgaz', 'Kırklareli', 2012, 105279],\n",
       " ['Turkey', 'Kirsehir', 'Kırşehir', 2012, 114244],\n",
       " ['Turkey', 'Kocaeli', 'Kocaeli', 2012, 1527407],\n",
       " ['Turkey', 'Gebze', 'Kocaeli', 2010, 290868],\n",
       " ['Turkey', 'Konya', 'Konya', 2012, 1107886],\n",
       " ['Turkey', 'Kütahya', 'Kütahya', 2012, 224898],\n",
       " ['Turkey', 'Malatya', 'Malatya', 2012, 426381],\n",
       " ['Turkey', 'Manisa', 'Manisa', 2012, 309050],\n",
       " ['Turkey', 'Mardin', 'Mardin', 2012, 86948],\n",
       " ['Turkey', 'Kızıltepe', 'Mardin', 2012, 147585],\n",
       " ['Turkey', 'Mugla', 'Mardin', 2012, 147585],\n",
       " ['Turkey', 'Mus', 'Muş', 2012, 81764],\n",
       " ['Turkey', 'Nevsehir', 'Nevşehir', 2012, 92068],\n",
       " ['Turkey', 'Nigde', 'Niğde', 2012, 118186],\n",
       " ['Turkey', 'Ordu', 'Ordu', 2012, 147913],\n",
       " ['Turkey', 'Rize', 'Rize', 2012, 104508],\n",
       " ['Turkey', 'Sakarya', 'Sakarya', 2012, 590498],\n",
       " ['Turkey', 'Samsun', 'Samsun', 2012, 547778],\n",
       " ['Turkey', 'Şanlıurfa', 'Şanlıurfa', 2012, 526247],\n",
       " ['Turkey', 'Siirt', 'Siirt', 2012, 135350],\n",
       " ['Turkey', 'Sinop', 'Siirt', 2012, 135350],\n",
       " ['Turkey', 'Sirnak', 'Siirt', 2012, 135350],\n",
       " ['Turkey', 'Sivas', 'Sivas', 2012, 312587],\n",
       " ['Turkey', 'Tekirdag', 'Tekirdağ', 2012, 150112],\n",
       " ['Turkey', 'Çorlu', 'Tekirdağ', 2012, 235354],\n",
       " ['Turkey', 'Tokat', 'Tokat', 2012, 132437],\n",
       " ['Turkey', 'Trabzon', 'Trabzon', 2012, 243735],\n",
       " ['Turkey', 'Tunceli', 'Trabzon', 2012, 243735],\n",
       " ['Turkey', 'Usak', 'Uşak', 2012, 187886],\n",
       " ['Turkey', 'Van', 'Van', 2012, 370190],\n",
       " ['Turkey', 'Yozgat', 'Yozgat', 2012, 78328],\n",
       " ['Turkey', 'Zonguldak', 'Zonguldak', 2012, 109080],\n",
       " ['Turkey', 'Bartin', 'Zonguldak', 2012, 109080],\n",
       " ['Turkey', 'Karabük', 'Karabük', 2012, 110537],\n",
       " ['Turkey', 'Ardahan', 'Karabük', 2012, 110537],\n",
       " ['Turkey', 'Iğdır', 'Iğdır', 2012, 82656],\n",
       " ['Turkey', 'Yalova', 'Yalova', 2012, 102874],\n",
       " ['Turkey', 'Kilis', 'Kilis', 2012, 85119],\n",
       " ['Turkey', 'Duzce', 'Düzce', 2012, 135557],\n",
       " ['Turkey', 'Osmaniye', 'Osmaniye', 2012, 209255],\n",
       " ['Denmark', 'Aalborg', 'Nordjylland', 2012, 104885],\n",
       " ['Denmark', 'Viborg', 'Nordjylland', 2012, 104885],\n",
       " ['Denmark', 'Århus', 'Midtjylland', 2012, 252213],\n",
       " ['Denmark', 'Randers', 'Midtjylland', 2012, 61121],\n",
       " ['Denmark', 'Vejle', 'Syddanmark', 2012, 51804],\n",
       " ['Denmark', 'Odense', 'Syddanmark', 2012, 168798],\n",
       " ['Denmark', 'Esbjerg', 'Syddanmark', 2012, 71579],\n",
       " ['Denmark', 'Hilleroed', 'Syddanmark', 2012, 71579],\n",
       " ['Denmark', 'København', 'Hovedstaden', 2012, 549050],\n",
       " ['Denmark', 'Soroe', 'Hovedstaden', 2012, 549050],\n",
       " ['Estonia', 'Tallinn', 'No Province', 2010, 399340],\n",
       " ['Estonia', 'Tartu', 'No Province', 2010, 103284],\n",
       " ['Faroe Islands', 'Tórshavn', 'No Province', 2013, 12245],\n",
       " ['Finland', 'Mariehamn', 'Aland', 2007, 10851],\n",
       " ['Finland', 'Tampere', 'Haeme', 2014, 220678],\n",
       " ['Finland', 'Lahti', 'Haeme', 2014, 103396],\n",
       " ['Finland', 'Hämeenlinna', 'Haeme', 2014, 67803],\n",
       " ['Finland', 'Kuopio', 'Kuopio', 2014, 106475],\n",
       " ['Finland', 'Lappeenranta', 'Kymi', 2014, 72617],\n",
       " ['Finland', 'Kotka', 'Kymi', 2014, 54714],\n",
       " ['Finland', 'Rovaniemi', 'Lappia', 2014, 61244],\n",
       " ['Finland', 'Mikkeli', 'Mikkeli', 2014, 54633],\n",
       " ['Finland', 'Jyväskylä', 'Suomi', 2014, 134862],\n",
       " ['Finland', 'Joensuu', 'Pohjols-Karjala', 2014, 74332],\n",
       " ['Finland', 'Oulu', 'Oulu', 2014, 194181],\n",
       " ['Finland', 'Pori', 'Turku-Pori', 2014, 83457],\n",
       " ['Finland', 'Turku', 'Turku-Pori', 2014, 182154],\n",
       " ['Finland', 'Helsinki', 'Uusimaa', 2014, 614535],\n",
       " ['Finland', 'Espoo', 'Uusimaa', 2014, 261654],\n",
       " ['Finland', 'Vaasa', 'Vaasa', 2014, 66415],\n",
       " ['Norway', 'Oslo', 'Oslo', 2013, 623966],\n",
       " ['Norway', 'Sandvika', 'Akershus', 2013, 116677],\n",
       " ['Norway', 'Moss', 'Østfold', 1987, 24517],\n",
       " ['Norway', 'Hamar', 'Hedmark', 1987, 15685],\n",
       " ['Norway', 'Lillehammer', 'Oppland', 1987, 22118],\n",
       " ['Norway', 'Drammen', 'Buskerud', 2013, 65473],\n",
       " ['Norway', 'Tonsberg', 'Vestfold', 1987, 8984],\n",
       " ['Norway', 'Skien', 'Telemark', 2013, 53015],\n",
       " ['Norway', 'Arendal', 'Aust-Agder', 1987, 12174],\n",
       " ['Norway', 'Kristiansand', 'Vest-Agder', 2013, 84476],\n",
       " ['Norway', 'Stavanger', 'Rogaland', 2013, 129191],\n",
       " ['Norway', 'Bergen', 'Hordaland', 2013, 267950],\n",
       " ['Norway', 'Hermannsverk', 'Sogn og Fjordane', 1987, 706],\n",
       " ['Norway', 'Molde', 'Møre og Romsdal', 1987, 21448],\n",
       " ['Norway', 'Trondheim', 'Sør-Trøndelag', 2013, 179692],\n",
       " ['Norway', 'Steinkjer', 'Nord-Trøndelag', 1987, 20480],\n",
       " ['Norway', 'Svolvaer', 'Nordland', 1987, 4500],\n",
       " ['Norway', 'Narvik', 'Nordland', 1987, 18754],\n",
       " ['Norway', 'Bodoe', 'Nordland', 1987, 34479],\n",
       " ['Norway', 'Tromsø', 'Troms', 2013, 70358],\n",
       " ['Norway', 'Hammerfest', 'Finnmark', 1987, 7089],\n",
       " ['Norway', 'Vadsoe', 'Finnmark', 1987, 5961],\n",
       " ['Sweden', 'Göteborg', 'Västra Götaland', 2012, 526089],\n",
       " ['Sweden', 'Vanersborg', 'Västra Götaland', 1987, 35804],\n",
       " ['Sweden', 'Mariestad', 'Västra Götaland', 1987, 24255],\n",
       " ['Sweden', 'Borås', 'Västra Götaland', 2012, 104867],\n",
       " ['Sweden', 'Karlskrona', 'Blekinge', 1987, 59007],\n",
       " ['Sweden', 'Gävle', 'Gävleborg', 2012, 96170],\n",
       " ['Sweden', 'Visby', 'Gotland', 1987, 20000],\n",
       " ['Sweden', 'Halmstad', 'Halland', 2012, 93231],\n",
       " ['Sweden', 'Ostersund', 'Jämtland', 1987, 56662],\n",
       " ['Sweden', 'Jönköping', 'Jönköping', 2012, 129478],\n",
       " ['Sweden', 'Kalmar', 'Kalmar', 1987, 54554],\n",
       " ['Sweden', 'Falun', 'Dalarna', 1987, 51900],\n",
       " ['Sweden', 'Malmö', 'Skåne', 2012, 307758],\n",
       " ['Sweden', 'Helsingborg', 'Skåne', 2012, 132011],\n",
       " ['Sweden', 'Kristianstad', 'Skåne', 2012, 80507],\n",
       " ['Sweden', 'Lund', 'Skåne', 2012, 112950],\n",
       " ['Sweden', 'Växjö', 'Kronoberg', 2012, 84800],\n",
       " ['Sweden', 'Lulea', 'Norrbotten', 1987, 66526],\n",
       " ['Sweden', 'Jokkmokk', 'Norrbotten', 1987, 6822],\n",
       " ['Sweden', 'Örebro', 'Örebro', 2012, 138952],\n",
       " ['Sweden', 'Linköping', 'Östergötland', 2012, 148521],\n",
       " ['Sweden', 'Norrköping', 'Östergötland', 2012, 132124],\n",
       " ['Sweden', 'Nykoping', 'Södermanland', 1987, 64199],\n",
       " ['Sweden', 'Eskilstuna', 'Södermanland', 2012, 98765],\n",
       " ['Sweden', 'Stockholm', 'Stockholm', 2012, 881235],\n",
       " ['Sweden', 'Huddinge', 'Stockholm', 2012, 101010],\n",
       " ['Sweden', 'Uppsala', 'Uppsala', 2012, 202625],\n",
       " ['Sweden', 'Karlstad', 'Värmland', 2012, 86929],\n",
       " ['Sweden', 'Umeå', 'Västerbotten', 2012, 117294],\n",
       " ['Sweden', 'Harnosand', 'Västernorrland', 1987, 27287],\n",
       " ['Sweden', 'Västerås', 'Västmanland', 2012, 140499],\n",
       " ['Monaco', 'Monaco', 'No Province', 2008, 975],\n",
       " ['Gibraltar', 'Gibraltar', 'No Province', 2008, 975],\n",
       " ['Guernsey', 'Saint Peter Port', 'No Province', 2008, 975],\n",
       " ['Holy See', 'Vatican City', 'No Province', 2014, 842],\n",
       " ['Ceuta', 'Ceuta', 'No Province', 2011, 82376],\n",
       " ['Melilla', 'Melilla', 'No Province', 2011, 78476],\n",
       " ['Iceland', 'Reykjavik', 'No Province', 2011, 118061],\n",
       " ['Iceland', 'Keflavik', 'No Province', 2011, 13862],\n",
       " ['Iceland', 'Hafnarfjordur', 'No Province', 2011, 26099],\n",
       " ['Iceland', 'Akureyri', 'No Province', 2011, 17490],\n",
       " ['Ireland', 'Dublin', 'No Province', 2011, 525383],\n",
       " ['Ireland', 'Cork', 'No Province', 2011, 118912],\n",
       " ['Ireland', 'Galway', 'No Province', 2011, 75414],\n",
       " ['Ireland', 'Limerick', 'No Province', 2011, 56779],\n",
       " ['San Marino', 'San Marino', 'No Province', 2012, 4227],\n",
       " ['Jersey', 'Saint Helier', 'No Province', 2012, 4227],\n",
       " ['Malta', 'Valletta', 'No Province', 2010, 5748],\n",
       " ['Malta', 'Victoria', 'No Province', 2010, 6252],\n",
       " ['Isle of Man', 'Douglas', 'No Province', 2010, 6252],\n",
       " ['Moldova', 'Chişinău', 'No Province', 2010, 663400],\n",
       " ['Moldova', 'Tiraspol', 'No Province', 2010, 148917],\n",
       " ['Moldova', 'Bălţi', 'No Province', 2010, 143300],\n",
       " ['Portugal', 'Aveiro', 'Aveiro', 2001, 53496],\n",
       " ['Portugal', 'Beja', 'Aveiro', 2001, 53496],\n",
       " ['Portugal', 'Braga', 'Braga', 2001, 114003],\n",
       " ['Portugal', 'Braganca', 'Braga', 2001, 114003],\n",
       " ['Portugal', 'Castelo Branco', 'Braga', 2001, 114003],\n",
       " ['Portugal', 'Coimbra', 'Coimbra', 2001, 118016],\n",
       " ['Portugal', 'Evora', 'Coimbra', 2001, 118016],\n",
       " ['Portugal', 'Faro', 'Coimbra', 2001, 118016],\n",
       " ['Portugal', 'Guarda', 'Coimbra', 2001, 118016],\n",
       " ['Portugal', 'Leiria', 'Leiria', 2001, 50608],\n",
       " ['Portugal', 'Lisboa', 'Lisboa', 2001, 559248],\n",
       " ['Portugal', 'Amadora', 'Lisboa', 2001, 89232],\n",
       " ['Portugal', 'Barreiro', 'Lisboa', 2011, 79042],\n",
       " ['Portugal', 'Almada', 'Lisboa', 2011, 49578],\n",
       " ['Portugal', 'Portalegre', 'Lisboa', 2011, 49578],\n",
       " ['Portugal', 'Oporto', 'Porto', 2001, 266790],\n",
       " ['Portugal', 'Vila Nova de Gaia', 'Porto', 2001, 72576],\n",
       " ['Portugal', 'Santarem', 'Porto', 2001, 72576],\n",
       " ['Portugal', 'Setúbal', 'Setubal', 2001, 91108],\n",
       " ['Portugal', 'Viana do Castelo', 'Setubal', 2001, 91108],\n",
       " ['Portugal', 'Vila Real', 'Setubal', 2001, 91108],\n",
       " ['Portugal', 'Viseu', 'Setubal', 2001, 91108],\n",
       " ['Portugal', 'Ponta Delgada', 'Azores', 2002, 46102],\n",
       " ['Portugal', 'Funchal', 'Madeira', 2001, 112362],\n",
       " ['Svalbard', 'Longyearbyen', 'Madeira', 2001, 112362],\n",
       " ['United Kingdom', 'Newcastle upon Tyne', 'North East', 2011, 268064],\n",
       " ['United Kingdom', 'Sunderland', 'North East', 2011, 174286],\n",
       " ['United Kingdom', 'Gateshead', 'North East', 2011, 120046],\n",
       " ['United Kingdom', 'Middlesbrough', 'North East', 2011, 174700],\n",
       " ['United Kingdom', 'Manchester', 'North West', 2011, 510746],\n",
       " ['United Kingdom', 'Wigan', 'North West', 2011, 103608],\n",
       " ['United Kingdom', 'Stockport', 'North West', 2011, 105878],\n",
       " ['United Kingdom', 'Bolton', 'North West', 2011, 194189],\n",
       " ['United Kingdom', 'Salford', 'North West', 2011, 103886],\n",
       " ['United Kingdom', 'Oldham', 'North West', 2011, 96555],\n",
       " ['United Kingdom', 'Rochdale', 'North West', 2011, 107926],\n",
       " ['United Kingdom', 'Warrington', 'North West', 2011, 165456],\n",
       " ['United Kingdom', 'Blackpool', 'North West', 2011, 147663],\n",
       " ['United Kingdom', 'Blackburn', 'North West', 2011, 117963],\n",
       " ['United Kingdom', 'Liverpool', 'North West', 2011, 552267],\n",
       " ['United Kingdom', 'Birkenhead', 'North West', 2011, 142968],\n",
       " ['United Kingdom', 'St Helens', 'North West', 2011, 102885],\n",
       " ['United Kingdom', 'Preston', 'North West', 2011, 97886],\n",
       " ['United Kingdom', 'Leeds', 'Yorkshire and the Humber', 2011, 474632],\n",
       " ['United Kingdom', 'Wakefield', 'Yorkshire and the Humber', 2011, 99251],\n",
       " ['United Kingdom', 'Bradford', 'Yorkshire and the Humber', 2011, 349561],\n",
       " ['United Kingdom', 'Huddersfield', 'Yorkshire and the Humber', 2011, 162949],\n",
       " ['United Kingdom', 'Sheffield', 'Yorkshire and the Humber', 2011, 518090],\n",
       " ['United Kingdom', 'Doncaster', 'Yorkshire and the Humber', 2011, 109805],\n",
       " ['United Kingdom', 'Rotherham', 'Yorkshire and the Humber', 2011, 109691],\n",
       " ['United Kingdom', 'York', 'Yorkshire and the Humber', 2011, 152841],\n",
       " ['United Kingdom',\n",
       "  'Kingston upon Hull',\n",
       "  'Yorkshire and the Humber',\n",
       "  2011,\n",
       "  284321],\n",
       " ['United Kingdom', 'Nottingham', 'East Midlands', 2011, 289301],\n",
       " ['United Kingdom', 'Northampton', 'East Midlands', 2011, 215173],\n",
       " ['United Kingdom', 'Leicester', 'East Midlands', 2011, 443760],\n",
       " ['United Kingdom', 'Derby', 'East Midlands', 2011, 255394],\n",
       " ['United Kingdom', 'Lincoln', 'East Midlands', 2011, 100160],\n",
       " ['United Kingdom', 'Birmingham', 'West Midlands', 2011, 1085810],\n",
       " ['United Kingdom', 'Coventry', 'West Midlands', 2011, 325949],\n",
       " ['United Kingdom', 'Wolverhampton', 'West Midlands', 2011, 210319],\n",
       " ['United Kingdom', 'Solihull', 'West Midlands', 2011, 123187],\n",
       " ['United Kingdom', 'Stoke-on-Trent', 'West Midlands', 2011, 270726],\n",
       " ['United Kingdom', 'Worcester', 'West Midlands', 2011, 100153],\n",
       " ['United Kingdom', 'Sutton Coldfield', 'West Midlands', 2011, 109015],\n",
       " ['United Kingdom', 'Telford', 'West Midlands', 2011, 142723],\n",
       " ['United Kingdom', 'Cambridge', 'East of England', 2011, 145818],\n",
       " ['United Kingdom', 'Peterborough', 'East of England', 2011, 161707],\n",
       " ['United Kingdom', 'Ipswich', 'East of England', 2011, 144957],\n",
       " ['United Kingdom', 'Chelmsford', 'East of England', 2011, 110507],\n",
       " ['United Kingdom', 'Watford', 'East of England', 2011, 131982],\n",
       " ['United Kingdom', 'Southend-on-Sea', 'East of England', 2011, 175547],\n",
       " ['United Kingdom', 'Basildon', 'East of England', 2011, 107123],\n",
       " ['United Kingdom', 'Colchester', 'East of England', 2011, 119441],\n",
       " ['United Kingdom', 'Norwich', 'East of England', 2011, 186682],\n",
       " ['United Kingdom', 'Luton', 'East of England', 2011, 211228],\n",
       " ...]"
      ]
     },
     "execution_count": 243,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cit_pop_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "r = {}\n",
    "for e in document.iterfind('country'):\n",
    "    name = e.find('name')\n",
    "    for city in e.iterfind('city'):\n",
    "        lk = "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}