world_map.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "world map.ipynb",
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "vU5GOpF0TTRv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 615
        },
        "outputId": "10724bad-06af-4c0c-e178-cd8dd45db540"
      },
      "source": [
        "!pip install fiona\n",
        "!pip install geopandas"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Collecting fiona\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/ec/20/4e63bc5c6e62df889297b382c3ccd4a7a488b00946aaaf81a118158c6f09/Fiona-1.8.13.post1-cp36-cp36m-manylinux1_x86_64.whl (14.7MB)\n",
            "\u001b[K     |████████████████████████████████| 14.7MB 1.3MB/s \n",
            "\u001b[?25hRequirement already satisfied: six>=1.7 in /usr/local/lib/python3.6/dist-packages (from fiona) (1.12.0)\n",
            "Collecting click-plugins>=1.0\n",
            "  Downloading https://files.pythonhosted.org/packages/e9/da/824b92d9942f4e472702488857914bdd50f73021efea15b4cad9aca8ecef/click_plugins-1.1.1-py2.py3-none-any.whl\n",
            "Requirement already satisfied: attrs>=17 in /usr/local/lib/python3.6/dist-packages (from fiona) (19.3.0)\n",
            "Collecting munch\n",
            "  Downloading https://files.pythonhosted.org/packages/cc/ab/85d8da5c9a45e072301beb37ad7f833cd344e04c817d97e0cc75681d248f/munch-2.5.0-py2.py3-none-any.whl\n",
            "Requirement already satisfied: click<8,>=4.0 in /usr/local/lib/python3.6/dist-packages (from fiona) (7.1.2)\n",
            "Collecting cligj>=0.5\n",
            "  Downloading https://files.pythonhosted.org/packages/e4/be/30a58b4b0733850280d01f8bd132591b4668ed5c7046761098d665ac2174/cligj-0.5.0-py3-none-any.whl\n",
            "Installing collected packages: click-plugins, munch, cligj, fiona\n",
            "Successfully installed click-plugins-1.1.1 cligj-0.5.0 fiona-1.8.13.post1 munch-2.5.0\n",
            "Collecting geopandas\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/83/c5/3cf9cdc39a6f2552922f79915f36b45a95b71fd343cfc51170a5b6ddb6e8/geopandas-0.7.0-py2.py3-none-any.whl (928kB)\n",
            "\u001b[K     |████████████████████████████████| 931kB 2.8MB/s \n",
            "\u001b[?25hCollecting pyproj>=2.2.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/e5/c3/071e080230ac4b6c64f1a2e2f9161c9737a2bc7b683d2c90b024825000c0/pyproj-2.6.1.post1-cp36-cp36m-manylinux2010_x86_64.whl (10.9MB)\n",
            "\u001b[K     |████████████████████████████████| 10.9MB 17.1MB/s \n",
            "\u001b[?25hRequirement already satisfied: fiona in /usr/local/lib/python3.6/dist-packages (from geopandas) (1.8.13.post1)\n",
            "Requirement already satisfied: shapely in /usr/local/lib/python3.6/dist-packages (from geopandas) (1.7.0)\n",
            "Requirement already satisfied: pandas>=0.23.0 in /usr/local/lib/python3.6/dist-packages (from geopandas) (1.0.3)\n",
            "Requirement already satisfied: attrs>=17 in /usr/local/lib/python3.6/dist-packages (from fiona->geopandas) (19.3.0)\n",
            "Requirement already satisfied: cligj>=0.5 in /usr/local/lib/python3.6/dist-packages (from fiona->geopandas) (0.5.0)\n",
            "Requirement already satisfied: click-plugins>=1.0 in /usr/local/lib/python3.6/dist-packages (from fiona->geopandas) (1.1.1)\n",
            "Requirement already satisfied: click<8,>=4.0 in /usr/local/lib/python3.6/dist-packages (from fiona->geopandas) (7.1.2)\n",
            "Requirement already satisfied: munch in /usr/local/lib/python3.6/dist-packages (from fiona->geopandas) (2.5.0)\n",
            "Requirement already satisfied: six>=1.7 in /usr/local/lib/python3.6/dist-packages (from fiona->geopandas) (1.12.0)\n",
            "Requirement already satisfied: python-dateutil>=2.6.1 in /usr/local/lib/python3.6/dist-packages (from pandas>=0.23.0->geopandas) (2.8.1)\n",
            "Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.6/dist-packages (from pandas>=0.23.0->geopandas) (2018.9)\n",
            "Requirement already satisfied: numpy>=1.13.3 in /usr/local/lib/python3.6/dist-packages (from pandas>=0.23.0->geopandas) (1.18.4)\n",
            "Installing collected packages: pyproj, geopandas\n",
            "Successfully installed geopandas-0.7.0 pyproj-2.6.1.post1\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "R2lvLRaATaN3",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import math\n",
        "\n",
        "import geopandas\n",
        "import json\n",
        "\n",
        "import requests\n",
        "\n",
        "from bokeh.io import output_notebook, show, output_file\n",
        "from bokeh.plotting import figure\n",
        "from bokeh.models import GeoJSONDataSource, LinearColorMapper, ColorBar, NumeralTickFormatter\n",
        "from bokeh.palettes import brewer\n",
        "\n",
        "from bokeh.io.doc import curdoc\n",
        "from bokeh.models import Slider, HoverTool, Select\n",
        "from bokeh.layouts import widgetbox, row, column"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fLW4nC3EUTMX",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "46e51789-54cb-46a6-cf08-80763e62a131"
      },
      "source": [
        "raw= requests.get(\"https://services1.arcgis.com/0MSEUqKaxRlEPj5g/arcgis/rest/services/ncov_cases2_v1/FeatureServer/2/query?where=1%3D1&outFields=*&outSR=4326&f=json\")\n",
        "raw_json = raw.json()\n",
        "d = pd.DataFrame(raw_json[\"features\"])\n",
        "d.head()"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>attributes</th>\n",
              "      <th>geometry</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>{'OBJECTID': 1, 'Country_Region': 'Australia',...</td>\n",
              "      <td>{'x': 133.0000000000001, 'y': -24.999999999999...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>{'OBJECTID': 2, 'Country_Region': 'Austria', '...</td>\n",
              "      <td>{'x': 14.550100000000045, 'y': 47.516200000000...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>{'OBJECTID': 3, 'Country_Region': 'Canada', 'L...</td>\n",
              "      <td>{'x': -95.00099999999996, 'y': 60.00100000000003}</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>{'OBJECTID': 4, 'Country_Region': 'China', 'La...</td>\n",
              "      <td>{'x': 114.30550000000004, 'y': 30.592800000000...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>{'OBJECTID': 5, 'Country_Region': 'Denmark', '...</td>\n",
              "      <td>{'x': 9.50180000000006, 'y': 56.263900000000035}</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                          attributes                                           geometry\n",
              "0  {'OBJECTID': 1, 'Country_Region': 'Australia',...  {'x': 133.0000000000001, 'y': -24.999999999999...\n",
              "1  {'OBJECTID': 2, 'Country_Region': 'Austria', '...  {'x': 14.550100000000045, 'y': 47.516200000000...\n",
              "2  {'OBJECTID': 3, 'Country_Region': 'Canada', 'L...  {'x': -95.00099999999996, 'y': 60.00100000000003}\n",
              "3  {'OBJECTID': 4, 'Country_Region': 'China', 'La...  {'x': 114.30550000000004, 'y': 30.592800000000...\n",
              "4  {'OBJECTID': 5, 'Country_Region': 'Denmark', '...   {'x': 9.50180000000006, 'y': 56.263900000000035}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fj7hMskOZ2Li",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "04913cbb-3f21-4362-e3d6-853e8f51d3dd"
      },
      "source": [
        "data_list = d[\"attributes\"].tolist()\n",
        "df = pd.DataFrame(data_list)\n",
        "df.set_index(\"OBJECTID\")\n",
        "df = df[[\"Country_Region\", \"Lat\", \"Long_\", \"Confirmed\", \"Deaths\", \"Recovered\"]]\n",
        "df.head()"
      ],
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Country_Region</th>\n",
              "      <th>Lat</th>\n",
              "      <th>Long_</th>\n",
              "      <th>Confirmed</th>\n",
              "      <th>Deaths</th>\n",
              "      <th>Recovered</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Australia</td>\n",
              "      <td>-25.0000</td>\n",
              "      <td>133.0000</td>\n",
              "      <td>7204</td>\n",
              "      <td>102</td>\n",
              "      <td>6619</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Austria</td>\n",
              "      <td>47.5162</td>\n",
              "      <td>14.5501</td>\n",
              "      <td>16733</td>\n",
              "      <td>668</td>\n",
              "      <td>15596</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Canada</td>\n",
              "      <td>60.0010</td>\n",
              "      <td>-95.0010</td>\n",
              "      <td>92479</td>\n",
              "      <td>7374</td>\n",
              "      <td>49214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>China</td>\n",
              "      <td>30.5928</td>\n",
              "      <td>114.3055</td>\n",
              "      <td>84150</td>\n",
              "      <td>4638</td>\n",
              "      <td>79390</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Denmark</td>\n",
              "      <td>56.2639</td>\n",
              "      <td>9.5018</td>\n",
              "      <td>11899</td>\n",
              "      <td>576</td>\n",
              "      <td>10610</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Country_Region      Lat     Long_  Confirmed  Deaths  Recovered\n",
              "0      Australia -25.0000  133.0000       7204     102       6619\n",
              "1        Austria  47.5162   14.5501      16733     668      15596\n",
              "2         Canada  60.0010  -95.0010      92479    7374      49214\n",
              "3          China  30.5928  114.3055      84150    4638      79390\n",
              "4        Denmark  56.2639    9.5018      11899     576      10610"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "n27NA9tnbqmo",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "d92fa0d1-e776-4843-b7b3-d6543bae9895"
      },
      "source": [
        "df"
      ],
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Country_Region</th>\n",
              "      <th>Lat</th>\n",
              "      <th>Long_</th>\n",
              "      <th>Confirmed</th>\n",
              "      <th>Deaths</th>\n",
              "      <th>Recovered</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Australia</td>\n",
              "      <td>-25.000000</td>\n",
              "      <td>133.000000</td>\n",
              "      <td>7204</td>\n",
              "      <td>102</td>\n",
              "      <td>6619</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Austria</td>\n",
              "      <td>47.516200</td>\n",
              "      <td>14.550100</td>\n",
              "      <td>16733</td>\n",
              "      <td>668</td>\n",
              "      <td>15596</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Canada</td>\n",
              "      <td>60.001000</td>\n",
              "      <td>-95.001000</td>\n",
              "      <td>92479</td>\n",
              "      <td>7374</td>\n",
              "      <td>49214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>China</td>\n",
              "      <td>30.592800</td>\n",
              "      <td>114.305500</td>\n",
              "      <td>84150</td>\n",
              "      <td>4638</td>\n",
              "      <td>79390</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Denmark</td>\n",
              "      <td>56.263900</td>\n",
              "      <td>9.501800</td>\n",
              "      <td>11899</td>\n",
              "      <td>576</td>\n",
              "      <td>10610</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>183</th>\n",
              "      <td>West Bank and Gaza</td>\n",
              "      <td>31.952200</td>\n",
              "      <td>35.233200</td>\n",
              "      <td>449</td>\n",
              "      <td>3</td>\n",
              "      <td>372</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>Western Sahara</td>\n",
              "      <td>24.215500</td>\n",
              "      <td>-12.885800</td>\n",
              "      <td>9</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>185</th>\n",
              "      <td>Yemen</td>\n",
              "      <td>15.552727</td>\n",
              "      <td>48.516388</td>\n",
              "      <td>323</td>\n",
              "      <td>80</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>186</th>\n",
              "      <td>Zambia</td>\n",
              "      <td>-13.133897</td>\n",
              "      <td>27.849332</td>\n",
              "      <td>1089</td>\n",
              "      <td>7</td>\n",
              "      <td>912</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>187</th>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>-19.015438</td>\n",
              "      <td>29.154857</td>\n",
              "      <td>178</td>\n",
              "      <td>4</td>\n",
              "      <td>29</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>188 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "         Country_Region        Lat       Long_  Confirmed  Deaths  Recovered\n",
              "0             Australia -25.000000  133.000000       7204     102       6619\n",
              "1               Austria  47.516200   14.550100      16733     668      15596\n",
              "2                Canada  60.001000  -95.001000      92479    7374      49214\n",
              "3                 China  30.592800  114.305500      84150    4638      79390\n",
              "4               Denmark  56.263900    9.501800      11899     576      10610\n",
              "..                  ...        ...         ...        ...     ...        ...\n",
              "183  West Bank and Gaza  31.952200   35.233200        449       3        372\n",
              "184      Western Sahara  24.215500  -12.885800          9       1          6\n",
              "185               Yemen  15.552727   48.516388        323      80         14\n",
              "186              Zambia -13.133897   27.849332       1089       7        912\n",
              "187            Zimbabwe -19.015438   29.154857        178       4         29\n",
              "\n",
              "[188 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lgk9TK-Te82j",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 71
        },
        "outputId": "0462c09b-0a03-49d1-d044-76f08e56fbf2"
      },
      "source": [
        "mapp=geopandas.read_file('custom.geo.json')\n",
        "mapp.crs = {'init': 'epsg:4326'}"
      ],
      "execution_count": 48,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/pyproj/crs/crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6\n",
            "  return _prepare_from_string(\" \".join(pjargs))\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7QINImoSgPD_",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "f081dfcc-1460-4080-feaf-a833f9291e01"
      },
      "source": [
        "mapp"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>scalerank</th>\n",
              "      <th>featurecla</th>\n",
              "      <th>labelrank</th>\n",
              "      <th>sovereignt</th>\n",
              "      <th>sov_a3</th>\n",
              "      <th>adm0_dif</th>\n",
              "      <th>level</th>\n",
              "      <th>type</th>\n",
              "      <th>admin</th>\n",
              "      <th>adm0_a3</th>\n",
              "      <th>geou_dif</th>\n",
              "      <th>geounit</th>\n",
              "      <th>gu_a3</th>\n",
              "      <th>su_dif</th>\n",
              "      <th>subunit</th>\n",
              "      <th>su_a3</th>\n",
              "      <th>brk_diff</th>\n",
              "      <th>name</th>\n",
              "      <th>name_long</th>\n",
              "      <th>brk_a3</th>\n",
              "      <th>brk_name</th>\n",
              "      <th>brk_group</th>\n",
              "      <th>abbrev</th>\n",
              "      <th>postal</th>\n",
              "      <th>formal_en</th>\n",
              "      <th>formal_fr</th>\n",
              "      <th>note_adm0</th>\n",
              "      <th>note_brk</th>\n",
              "      <th>name_sort</th>\n",
              "      <th>name_alt</th>\n",
              "      <th>mapcolor7</th>\n",
              "      <th>mapcolor8</th>\n",
              "      <th>mapcolor9</th>\n",
              "      <th>mapcolor13</th>\n",
              "      <th>pop_est</th>\n",
              "      <th>gdp_md_est</th>\n",
              "      <th>pop_year</th>\n",
              "      <th>lastcensus</th>\n",
              "      <th>gdp_year</th>\n",
              "      <th>economy</th>\n",
              "      <th>income_grp</th>\n",
              "      <th>wikipedia</th>\n",
              "      <th>fips_10_</th>\n",
              "      <th>iso_a2</th>\n",
              "      <th>iso_a3</th>\n",
              "      <th>iso_n3</th>\n",
              "      <th>un_a3</th>\n",
              "      <th>wb_a2</th>\n",
              "      <th>wb_a3</th>\n",
              "      <th>woe_id</th>\n",
              "      <th>woe_id_eh</th>\n",
              "      <th>woe_note</th>\n",
              "      <th>adm0_a3_is</th>\n",
              "      <th>adm0_a3_us</th>\n",
              "      <th>adm0_a3_un</th>\n",
              "      <th>adm0_a3_wb</th>\n",
              "      <th>continent</th>\n",
              "      <th>region_un</th>\n",
              "      <th>subregion</th>\n",
              "      <th>region_wb</th>\n",
              "      <th>name_len</th>\n",
              "      <th>long_len</th>\n",
              "      <th>abbrev_len</th>\n",
              "      <th>tiny</th>\n",
              "      <th>homepart</th>\n",
              "      <th>filename</th>\n",
              "      <th>geometry</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>3</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>5</td>\n",
              "      <td>Netherlands</td>\n",
              "      <td>NL1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>Country</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>ABW</td>\n",
              "      <td>0</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>ABW</td>\n",
              "      <td>0</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>ABW</td>\n",
              "      <td>0</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>ABW</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>None</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>AW</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>None</td>\n",
              "      <td>Neth.</td>\n",
              "      <td>None</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>None</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>9</td>\n",
              "      <td>103065</td>\n",
              "      <td>2258.00</td>\n",
              "      <td>-99</td>\n",
              "      <td>2010</td>\n",
              "      <td>-99</td>\n",
              "      <td>6. Developing region</td>\n",
              "      <td>2. High income: nonOECD</td>\n",
              "      <td>-99</td>\n",
              "      <td>AA</td>\n",
              "      <td>AW</td>\n",
              "      <td>ABW</td>\n",
              "      <td>533</td>\n",
              "      <td>533</td>\n",
              "      <td>AW</td>\n",
              "      <td>ABW</td>\n",
              "      <td>23424736</td>\n",
              "      <td>23424736</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>ABW</td>\n",
              "      <td>ABW</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>North America</td>\n",
              "      <td>Americas</td>\n",
              "      <td>Caribbean</td>\n",
              "      <td>Latin America &amp; Caribbean</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>-99</td>\n",
              "      <td>ABW.geojson</td>\n",
              "      <td>POLYGON ((-69.99694 12.57758, -69.93639 12.531...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>3</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>6</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>Dependency</td>\n",
              "      <td>Anguilla</td>\n",
              "      <td>AIA</td>\n",
              "      <td>0</td>\n",
              "      <td>Anguilla</td>\n",
              "      <td>AIA</td>\n",
              "      <td>0</td>\n",
              "      <td>Anguilla</td>\n",
              "      <td>AIA</td>\n",
              "      <td>0</td>\n",
              "      <td>Anguilla</td>\n",
              "      <td>Anguilla</td>\n",
              "      <td>AIA</td>\n",
              "      <td>Anguilla</td>\n",
              "      <td>None</td>\n",
              "      <td>Ang.</td>\n",
              "      <td>AI</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>U.K.</td>\n",
              "      <td>None</td>\n",
              "      <td>Anguilla</td>\n",
              "      <td>None</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>14436</td>\n",
              "      <td>108.90</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>6. Developing region</td>\n",
              "      <td>3. Upper middle income</td>\n",
              "      <td>-99</td>\n",
              "      <td>AV</td>\n",
              "      <td>AI</td>\n",
              "      <td>AIA</td>\n",
              "      <td>660</td>\n",
              "      <td>660</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>23424751</td>\n",
              "      <td>23424751</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>AIA</td>\n",
              "      <td>AIA</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>North America</td>\n",
              "      <td>Americas</td>\n",
              "      <td>Caribbean</td>\n",
              "      <td>Latin America &amp; Caribbean</td>\n",
              "      <td>8</td>\n",
              "      <td>8</td>\n",
              "      <td>4</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>AIA.geojson</td>\n",
              "      <td>MULTIPOLYGON (((-63.03767 18.21296, -63.09952 ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>6</td>\n",
              "      <td>Antigua and Barbuda</td>\n",
              "      <td>ATG</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Sovereign country</td>\n",
              "      <td>Antigua and Barbuda</td>\n",
              "      <td>ATG</td>\n",
              "      <td>0</td>\n",
              "      <td>Antigua and Barbuda</td>\n",
              "      <td>ATG</td>\n",
              "      <td>0</td>\n",
              "      <td>Antigua and Barbuda</td>\n",
              "      <td>ATG</td>\n",
              "      <td>0</td>\n",
              "      <td>Antigua and Barb.</td>\n",
              "      <td>Antigua and Barbuda</td>\n",
              "      <td>ATG</td>\n",
              "      <td>Antigua and Barb.</td>\n",
              "      <td>None</td>\n",
              "      <td>Ant.B.</td>\n",
              "      <td>AG</td>\n",
              "      <td>Antigua and Barbuda</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Antigua and Barbuda</td>\n",
              "      <td>None</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>85632</td>\n",
              "      <td>1657.00</td>\n",
              "      <td>-99</td>\n",
              "      <td>2011</td>\n",
              "      <td>-99</td>\n",
              "      <td>6. Developing region</td>\n",
              "      <td>3. Upper middle income</td>\n",
              "      <td>-99</td>\n",
              "      <td>AC</td>\n",
              "      <td>AG</td>\n",
              "      <td>ATG</td>\n",
              "      <td>028</td>\n",
              "      <td>028</td>\n",
              "      <td>AG</td>\n",
              "      <td>ATG</td>\n",
              "      <td>23424737</td>\n",
              "      <td>23424737</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>ATG</td>\n",
              "      <td>ATG</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>North America</td>\n",
              "      <td>Americas</td>\n",
              "      <td>Caribbean</td>\n",
              "      <td>Latin America &amp; Caribbean</td>\n",
              "      <td>17</td>\n",
              "      <td>19</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>ATG.geojson</td>\n",
              "      <td>MULTIPOLYGON (((-61.77302 17.12653, -61.75642 ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>6</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>8</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>BJN</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Indeterminate</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>BJN</td>\n",
              "      <td>0</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>BJN</td>\n",
              "      <td>0</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>BJN</td>\n",
              "      <td>1</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Islands)</td>\n",
              "      <td>B41</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Disputed</td>\n",
              "      <td>Claimed by Columbia, Jamaica, Nicaragua and th...</td>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>None</td>\n",
              "      <td>3</td>\n",
              "      <td>7</td>\n",
              "      <td>6</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99.00</td>\n",
              "      <td>2012</td>\n",
              "      <td>-99</td>\n",
              "      <td>2012</td>\n",
              "      <td>7. Least developed region</td>\n",
              "      <td>5. Low income</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-099</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>No WOE equivalent.</td>\n",
              "      <td>-99</td>\n",
              "      <td>B41</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>North America</td>\n",
              "      <td>Americas</td>\n",
              "      <td>Caribbean</td>\n",
              "      <td>Latin America &amp; Caribbean</td>\n",
              "      <td>28</td>\n",
              "      <td>32</td>\n",
              "      <td>0</td>\n",
              "      <td>-99</td>\n",
              "      <td>1</td>\n",
              "      <td>bajonuevobankpetrelis.geojson</td>\n",
              "      <td>POLYGON ((-79.98929 15.79495, -79.98782 15.796...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>6</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>6</td>\n",
              "      <td>France</td>\n",
              "      <td>FR1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>Dependency</td>\n",
              "      <td>Saint Barthelemy</td>\n",
              "      <td>BLM</td>\n",
              "      <td>0</td>\n",
              "      <td>Saint Barthelemy</td>\n",
              "      <td>BLM</td>\n",
              "      <td>0</td>\n",
              "      <td>Saint Barthelemy</td>\n",
              "      <td>BLM</td>\n",
              "      <td>0</td>\n",
              "      <td>St-Barthélemy</td>\n",
              "      <td>Saint-Barthélemy</td>\n",
              "      <td>BLM</td>\n",
              "      <td>St-Barthélemy</td>\n",
              "      <td>None</td>\n",
              "      <td>St. B.</td>\n",
              "      <td>BL</td>\n",
              "      <td>Saint-Barthélemy</td>\n",
              "      <td>None</td>\n",
              "      <td>Fr.</td>\n",
              "      <td>None</td>\n",
              "      <td>St-Barthélemy</td>\n",
              "      <td>None</td>\n",
              "      <td>7</td>\n",
              "      <td>5</td>\n",
              "      <td>9</td>\n",
              "      <td>11</td>\n",
              "      <td>7448</td>\n",
              "      <td>255.00</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>2. Developed region: nonG7</td>\n",
              "      <td>1. High income: OECD</td>\n",
              "      <td>-99</td>\n",
              "      <td>TB</td>\n",
              "      <td>BL</td>\n",
              "      <td>BLM</td>\n",
              "      <td>652</td>\n",
              "      <td>652</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>56042304</td>\n",
              "      <td>56042304</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>BLM</td>\n",
              "      <td>BLM</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>North America</td>\n",
              "      <td>Americas</td>\n",
              "      <td>Caribbean</td>\n",
              "      <td>Latin America &amp; Caribbean</td>\n",
              "      <td>13</td>\n",
              "      <td>16</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>-99</td>\n",
              "      <td>BLM.geojson</td>\n",
              "      <td>POLYGON ((-62.83886 17.88198, -62.85094 17.890...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>240</th>\n",
              "      <td>5</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>4</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>TON</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Sovereign country</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>TON</td>\n",
              "      <td>0</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>TON</td>\n",
              "      <td>0</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>TON</td>\n",
              "      <td>0</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>TON</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>None</td>\n",
              "      <td>Tongo</td>\n",
              "      <td>TO</td>\n",
              "      <td>Kingdom of Tonga</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Tonga</td>\n",
              "      <td>None</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>120898</td>\n",
              "      <td>549.00</td>\n",
              "      <td>-99</td>\n",
              "      <td>2006</td>\n",
              "      <td>-99</td>\n",
              "      <td>6. Developing region</td>\n",
              "      <td>4. Lower middle income</td>\n",
              "      <td>-99</td>\n",
              "      <td>TN</td>\n",
              "      <td>TO</td>\n",
              "      <td>TON</td>\n",
              "      <td>776</td>\n",
              "      <td>776</td>\n",
              "      <td>TO</td>\n",
              "      <td>TON</td>\n",
              "      <td>23424964</td>\n",
              "      <td>23424964</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>TON</td>\n",
              "      <td>TON</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Polynesia</td>\n",
              "      <td>East Asia &amp; Pacific</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>TON.geojson</td>\n",
              "      <td>MULTIPOLYGON (((-176.20702 -22.33880, -176.210...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>241</th>\n",
              "      <td>5</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>6</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>TUV</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Sovereign country</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>TUV</td>\n",
              "      <td>0</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>TUV</td>\n",
              "      <td>0</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>TUV</td>\n",
              "      <td>0</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>TUV</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>None</td>\n",
              "      <td>Tuv.</td>\n",
              "      <td>TV</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>None</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>12373</td>\n",
              "      <td>14.94</td>\n",
              "      <td>-99</td>\n",
              "      <td>2002</td>\n",
              "      <td>-99</td>\n",
              "      <td>7. Least developed region</td>\n",
              "      <td>3. Upper middle income</td>\n",
              "      <td>-99</td>\n",
              "      <td>TV</td>\n",
              "      <td>TV</td>\n",
              "      <td>TUV</td>\n",
              "      <td>798</td>\n",
              "      <td>798</td>\n",
              "      <td>TV</td>\n",
              "      <td>TUV</td>\n",
              "      <td>23424970</td>\n",
              "      <td>23424970</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>TUV</td>\n",
              "      <td>TUV</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Polynesia</td>\n",
              "      <td>East Asia &amp; Pacific</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>TUV.geojson</td>\n",
              "      <td>MULTIPOLYGON (((179.90610 -9.41863, 179.90528 ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>242</th>\n",
              "      <td>1</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>4</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>VUT</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Sovereign country</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>VUT</td>\n",
              "      <td>0</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>VUT</td>\n",
              "      <td>0</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>VUT</td>\n",
              "      <td>0</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>VUT</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>None</td>\n",
              "      <td>Van.</td>\n",
              "      <td>VU</td>\n",
              "      <td>Republic of Vanuatu</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>None</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>218519</td>\n",
              "      <td>988.50</td>\n",
              "      <td>-99</td>\n",
              "      <td>2009</td>\n",
              "      <td>-99</td>\n",
              "      <td>7. Least developed region</td>\n",
              "      <td>4. Lower middle income</td>\n",
              "      <td>-99</td>\n",
              "      <td>NH</td>\n",
              "      <td>VU</td>\n",
              "      <td>VUT</td>\n",
              "      <td>548</td>\n",
              "      <td>548</td>\n",
              "      <td>VU</td>\n",
              "      <td>VUT</td>\n",
              "      <td>23424907</td>\n",
              "      <td>23424907</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>VUT</td>\n",
              "      <td>VUT</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Melanesia</td>\n",
              "      <td>East Asia &amp; Pacific</td>\n",
              "      <td>7</td>\n",
              "      <td>7</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>VUT.geojson</td>\n",
              "      <td>MULTIPOLYGON (((169.83815 -20.24863, 169.83009...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>243</th>\n",
              "      <td>5</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>4</td>\n",
              "      <td>France</td>\n",
              "      <td>FR1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>Dependency</td>\n",
              "      <td>Wallis and Futuna</td>\n",
              "      <td>WLF</td>\n",
              "      <td>0</td>\n",
              "      <td>Wallis and Futuna</td>\n",
              "      <td>WLF</td>\n",
              "      <td>0</td>\n",
              "      <td>Wallis and Futuna</td>\n",
              "      <td>WLF</td>\n",
              "      <td>0</td>\n",
              "      <td>Wallis and Futuna Is.</td>\n",
              "      <td>Wallis and Futuna Islands</td>\n",
              "      <td>WLF</td>\n",
              "      <td>Wallis and Futuna Islands</td>\n",
              "      <td>None</td>\n",
              "      <td>Wlf.</td>\n",
              "      <td>WF</td>\n",
              "      <td>Wallis and Futuna Islands</td>\n",
              "      <td>None</td>\n",
              "      <td>Fr.</td>\n",
              "      <td>None</td>\n",
              "      <td>Wallis and Futuna</td>\n",
              "      <td>None</td>\n",
              "      <td>7</td>\n",
              "      <td>5</td>\n",
              "      <td>9</td>\n",
              "      <td>11</td>\n",
              "      <td>15289</td>\n",
              "      <td>60.00</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>6. Developing region</td>\n",
              "      <td>4. Lower middle income</td>\n",
              "      <td>-99</td>\n",
              "      <td>WF</td>\n",
              "      <td>WF</td>\n",
              "      <td>WLF</td>\n",
              "      <td>876</td>\n",
              "      <td>876</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>23424989</td>\n",
              "      <td>23424989</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>WLF</td>\n",
              "      <td>WLF</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Polynesia</td>\n",
              "      <td>East Asia &amp; Pacific</td>\n",
              "      <td>21</td>\n",
              "      <td>25</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>-99</td>\n",
              "      <td>WLF.geojson</td>\n",
              "      <td>MULTIPOLYGON (((-178.04674 -14.31260, -178.046...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>244</th>\n",
              "      <td>3</td>\n",
              "      <td>Admin-0 country</td>\n",
              "      <td>4</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>WSM</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Sovereign country</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>WSM</td>\n",
              "      <td>0</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>WSM</td>\n",
              "      <td>0</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>WSM</td>\n",
              "      <td>0</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>WSM</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>None</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>WS</td>\n",
              "      <td>Independent State of Samoa</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Samoa</td>\n",
              "      <td>None</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>6</td>\n",
              "      <td>219998</td>\n",
              "      <td>1049.00</td>\n",
              "      <td>-99</td>\n",
              "      <td>2006</td>\n",
              "      <td>-99</td>\n",
              "      <td>7. Least developed region</td>\n",
              "      <td>4. Lower middle income</td>\n",
              "      <td>-99</td>\n",
              "      <td>WS</td>\n",
              "      <td>WS</td>\n",
              "      <td>WSM</td>\n",
              "      <td>882</td>\n",
              "      <td>882</td>\n",
              "      <td>WS</td>\n",
              "      <td>WSM</td>\n",
              "      <td>23424992</td>\n",
              "      <td>23424992</td>\n",
              "      <td>Exact WOE match as country</td>\n",
              "      <td>WSM</td>\n",
              "      <td>WSM</td>\n",
              "      <td>-99</td>\n",
              "      <td>-99</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Oceania</td>\n",
              "      <td>Polynesia</td>\n",
              "      <td>East Asia &amp; Pacific</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>-99</td>\n",
              "      <td>1</td>\n",
              "      <td>WSM.geojson</td>\n",
              "      <td>MULTIPOLYGON (((-171.57002 -13.93816, -171.564...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>245 rows × 67 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     scalerank  ...                                           geometry\n",
              "0            3  ...  POLYGON ((-69.99694 12.57758, -69.93639 12.531...\n",
              "1            3  ...  MULTIPOLYGON (((-63.03767 18.21296, -63.09952 ...\n",
              "2            3  ...  MULTIPOLYGON (((-61.77302 17.12653, -61.75642 ...\n",
              "3            6  ...  POLYGON ((-79.98929 15.79495, -79.98782 15.796...\n",
              "4            6  ...  POLYGON ((-62.83886 17.88198, -62.85094 17.890...\n",
              "..         ...  ...                                                ...\n",
              "240          5  ...  MULTIPOLYGON (((-176.20702 -22.33880, -176.210...\n",
              "241          5  ...  MULTIPOLYGON (((179.90610 -9.41863, 179.90528 ...\n",
              "242          1  ...  MULTIPOLYGON (((169.83815 -20.24863, 169.83009...\n",
              "243          5  ...  MULTIPOLYGON (((-178.04674 -14.31260, -178.046...\n",
              "244          3  ...  MULTIPOLYGON (((-171.57002 -13.93816, -171.564...\n",
              "\n",
              "[245 rows x 67 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qh-8Oczkgjr_",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mapp = mapp.rename(columns={'geometry': 'geometry','name':'Country_Region'}).set_geometry('geometry')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vwSOeMfjhNT5",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mapp.drop(mapp.columns.difference(['Country_Region','geometry']), 1, inplace=True)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rtx_JAaZlWO2",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "4b4f6cb8-2ac8-457b-e1c1-b2dc1892f263"
      },
      "source": [
        "mapp"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Country_Region</th>\n",
              "      <th>geometry</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Aruba</td>\n",
              "      <td>POLYGON ((-69.99694 12.57758, -69.93639 12.531...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Anguilla</td>\n",
              "      <td>MULTIPOLYGON (((-63.03767 18.21296, -63.09952 ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Antigua and Barb.</td>\n",
              "      <td>MULTIPOLYGON (((-61.77302 17.12653, -61.75642 ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>POLYGON ((-79.98929 15.79495, -79.98782 15.796...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>St-Barthélemy</td>\n",
              "      <td>POLYGON ((-62.83886 17.88198, -62.85094 17.890...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>240</th>\n",
              "      <td>Tonga</td>\n",
              "      <td>MULTIPOLYGON (((-176.20702 -22.33880, -176.210...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>241</th>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>MULTIPOLYGON (((179.90610 -9.41863, 179.90528 ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>242</th>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>MULTIPOLYGON (((169.83815 -20.24863, 169.83009...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>243</th>\n",
              "      <td>Wallis and Futuna Is.</td>\n",
              "      <td>MULTIPOLYGON (((-178.04674 -14.31260, -178.046...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>244</th>\n",
              "      <td>Samoa</td>\n",
              "      <td>MULTIPOLYGON (((-171.57002 -13.93816, -171.564...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>245 rows × 2 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                   Country_Region                                           geometry\n",
              "0                           Aruba  POLYGON ((-69.99694 12.57758, -69.93639 12.531...\n",
              "1                        Anguilla  MULTIPOLYGON (((-63.03767 18.21296, -63.09952 ...\n",
              "2               Antigua and Barb.  MULTIPOLYGON (((-61.77302 17.12653, -61.75642 ...\n",
              "3    Bajo Nuevo Bank (Petrel Is.)  POLYGON ((-79.98929 15.79495, -79.98782 15.796...\n",
              "4                   St-Barthélemy  POLYGON ((-62.83886 17.88198, -62.85094 17.890...\n",
              "..                            ...                                                ...\n",
              "240                         Tonga  MULTIPOLYGON (((-176.20702 -22.33880, -176.210...\n",
              "241                        Tuvalu  MULTIPOLYGON (((179.90610 -9.41863, 179.90528 ...\n",
              "242                       Vanuatu  MULTIPOLYGON (((169.83815 -20.24863, 169.83009...\n",
              "243         Wallis and Futuna Is.  MULTIPOLYGON (((-178.04674 -14.31260, -178.046...\n",
              "244                         Samoa  MULTIPOLYGON (((-171.57002 -13.93816, -171.564...\n",
              "\n",
              "[245 rows x 2 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5kbrcZURltX9",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 71
        },
        "outputId": "150eed75-4f91-4e29-da53-de923d5d3a88"
      },
      "source": [
        "mapp.crs = {'init': 'epsg:4326'}"
      ],
      "execution_count": 52,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/pyproj/crs/crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6\n",
            "  return _prepare_from_string(\" \".join(pjargs))\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "thapUQcftBVc",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 71
        },
        "outputId": "c8de5a9a-2274-42fd-a396-e93e08eadd6d"
      },
      "source": [
        "mapp.crs = {'init': 'epsg:4326'}"
      ],
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/pyproj/crs/crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6\n",
            "  return _prepare_from_string(\" \".join(pjargs))\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tPT9wpt5wzDW",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "merged = pd.merge(mapp, df, on='Country_Region', how='left')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8exX2mkI0WJW",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "fd2505f7-fe54-4986-ed51-e6d496889efa"
      },
      "source": [
        "merged.head()"
      ],
      "execution_count": 58,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Country_Region</th>\n",
              "      <th>geometry</th>\n",
              "      <th>Lat</th>\n",
              "      <th>Long_</th>\n",
              "      <th>Confirmed</th>\n",
              "      <th>Deaths</th>\n",
              "      <th>Recovered</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Aruba</td>\n",
              "      <td>POLYGON ((-69.99694 12.57758, -69.93639 12.531...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Anguilla</td>\n",
              "      <td>MULTIPOLYGON (((-63.03767 18.21296, -63.09952 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Antigua and Barb.</td>\n",
              "      <td>MULTIPOLYGON (((-61.77302 17.12653, -61.75642 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>POLYGON ((-79.98929 15.79495, -79.98782 15.796...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>St-Barthélemy</td>\n",
              "      <td>POLYGON ((-62.83886 17.88198, -62.85094 17.890...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                 Country_Region  ... Recovered\n",
              "0                         Aruba  ...       NaN\n",
              "1                      Anguilla  ...       NaN\n",
              "2             Antigua and Barb.  ...       NaN\n",
              "3  Bajo Nuevo Bank (Petrel Is.)  ...       NaN\n",
              "4                 St-Barthélemy  ...       NaN\n",
              "\n",
              "[5 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xT7sKsmH0X2G",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "values = {'Lat': 0, 'Long_': 0, 'Confirmed': 0,\n",
        "              'Deaths': 0, 'Recovered': 0}\n",
        "merged = merged.fillna(value=values)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0hBr98Cv1a1B",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "67ce9396-d141-4146-dd3d-bb1c6b4634fe"
      },
      "source": [
        "merged"
      ],
      "execution_count": 61,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Country_Region</th>\n",
              "      <th>geometry</th>\n",
              "      <th>Lat</th>\n",
              "      <th>Long_</th>\n",
              "      <th>Confirmed</th>\n",
              "      <th>Deaths</th>\n",
              "      <th>Recovered</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Aruba</td>\n",
              "      <td>POLYGON ((-69.99694 12.57758, -69.93639 12.531...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Anguilla</td>\n",
              "      <td>MULTIPOLYGON (((-63.03767 18.21296, -63.09952 ...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Antigua and Barb.</td>\n",
              "      <td>MULTIPOLYGON (((-61.77302 17.12653, -61.75642 ...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bajo Nuevo Bank (Petrel Is.)</td>\n",
              "      <td>POLYGON ((-79.98929 15.79495, -79.98782 15.796...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>St-Barthélemy</td>\n",
              "      <td>POLYGON ((-62.83886 17.88198, -62.85094 17.890...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>240</th>\n",
              "      <td>Tonga</td>\n",
              "      <td>MULTIPOLYGON (((-176.20702 -22.33880, -176.210...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>241</th>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>MULTIPOLYGON (((179.90610 -9.41863, 179.90528 ...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>242</th>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>MULTIPOLYGON (((169.83815 -20.24863, 169.83009...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>243</th>\n",
              "      <td>Wallis and Futuna Is.</td>\n",
              "      <td>MULTIPOLYGON (((-178.04674 -14.31260, -178.046...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>244</th>\n",
              "      <td>Samoa</td>\n",
              "      <td>MULTIPOLYGON (((-171.57002 -13.93816, -171.564...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>245 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                   Country_Region  ... Recovered\n",
              "0                           Aruba  ...       0.0\n",
              "1                        Anguilla  ...       0.0\n",
              "2               Antigua and Barb.  ...       0.0\n",
              "3    Bajo Nuevo Bank (Petrel Is.)  ...       0.0\n",
              "4                   St-Barthélemy  ...       0.0\n",
              "..                            ...  ...       ...\n",
              "240                         Tonga  ...       0.0\n",
              "241                        Tuvalu  ...       0.0\n",
              "242                       Vanuatu  ...       0.0\n",
              "243         Wallis and Futuna Is.  ...       0.0\n",
              "244                         Samoa  ...       0.0\n",
              "\n",
              "[245 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 61
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "crRw5Azi1fMB",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 272
        },
        "outputId": "e5c811b9-ce9a-41f8-8d90-649e5a20f42b"
      },
      "source": [
        "print (merged[78:90])"
      ],
      "execution_count": 71,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "     Country_Region  ... Recovered\n",
            "78  Siachen Glacier  ...       0.0\n",
            "79            Japan  ...   14422.0\n",
            "80       Kazakhstan  ...    5458.0\n",
            "81       Kyrgyzstan  ...    1181.0\n",
            "82         Cambodia  ...     123.0\n",
            "83            Korea  ...       0.0\n",
            "84           Kuwait  ...   12899.0\n",
            "85          Lao PDR  ...       0.0\n",
            "86          Lebanon  ...     715.0\n",
            "87        Sri Lanka  ...     811.0\n",
            "88            Macao  ...       0.0\n",
            "89          Myanmar  ...       0.0\n",
            "\n",
            "[12 rows x 7 columns]\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "x5-LL2-O1xPX",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}