Geolocate_Clean.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QZ5gmSG7w7M0"
      },
      "source": [
        "# Climate Change Analysis"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DmJvPZ_SYlQ7",
        "outputId": "32d81295-3417-44e1-db1d-b6725eb6afd3"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: opencage in /usr/local/lib/python3.10/dist-packages (2.4.0)\n",
            "Requirement already satisfied: Requests>=2.31.0 in /usr/local/lib/python3.10/dist-packages (from opencage) (2.31.0)\n",
            "Requirement already satisfied: backoff>=2.2.1 in /usr/local/lib/python3.10/dist-packages (from opencage) (2.2.1)\n",
            "Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from Requests>=2.31.0->opencage) (3.3.2)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from Requests>=2.31.0->opencage) (3.6)\n",
            "Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from Requests>=2.31.0->opencage) (2.0.7)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from Requests>=2.31.0->opencage) (2023.11.17)\n"
          ]
        }
      ],
      "source": [
        "pip install opencage"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "81KGl2lZVovh",
        "outputId": "74dacbba-939c-42a7-a2bc-70b4e6d11049"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: pgeocode in /usr/local/lib/python3.10/dist-packages (0.4.1)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.10/dist-packages (from pgeocode) (2.31.0)\n",
            "Requirement already satisfied: numpy in /usr/local/lib/python3.10/dist-packages (from pgeocode) (1.23.5)\n",
            "Requirement already satisfied: pandas in /usr/local/lib/python3.10/dist-packages (from pgeocode) (1.5.3)\n",
            "Requirement already satisfied: python-dateutil>=2.8.1 in /usr/local/lib/python3.10/dist-packages (from pandas->pgeocode) (2.8.2)\n",
            "Requirement already satisfied: pytz>=2020.1 in /usr/local/lib/python3.10/dist-packages (from pandas->pgeocode) (2023.3.post1)\n",
            "Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests->pgeocode) (3.3.2)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests->pgeocode) (3.6)\n",
            "Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from requests->pgeocode) (2.0.7)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests->pgeocode) (2023.11.17)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.10/dist-packages (from python-dateutil>=2.8.1->pandas->pgeocode) (1.16.0)\n"
          ]
        }
      ],
      "source": [
        "pip install pgeocode"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "O1rmR9x3-LJW"
      },
      "outputs": [],
      "source": [
        "# Importing libraries\n",
        "\n",
        "import pandas as pd\n",
        "import folium\n",
        "from opencage.geocoder import OpenCageGeocode\n",
        "from folium.plugins import MarkerCluster"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Ob_kyJOF-9F1",
        "outputId": "ae0cbc3f-b005-41f9-e50b-440ddf4a1cda"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/gdrive; to attempt to forcibly remount, call drive.mount(\"/content/gdrive\", force_remount=True).\n"
          ]
        }
      ],
      "source": [
        "# Importing google drive\n",
        "\n",
        "from google.colab import drive\n",
        "drive.mount(\"/content/gdrive\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "KM6Jyzfh-_KQ"
      },
      "outputs": [],
      "source": [
        "# importing the whole dataset but not doing this because of efficiency issues in the google colab environment\n",
        "\n",
        "#df = pd.read_excel('/content/gdrive/MyDrive/nets research/companies and their subs.xlsx')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "a2HkmiTFChZY"
      },
      "outputs": [],
      "source": [
        "# Reading only the first 100 rows\n",
        "\n",
        "small_df = pd.read_excel('/content/gdrive/MyDrive/nets research/companies and their subs.xlsx', nrows=100)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 533
        },
        "id": "t8QgvjS3F0P4",
        "outputId": "df84feee-4ed9-408a-e5cb-ce271b5ecf26"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Unnamed: 0    Company name Latin alphabet_x BvD ID number  \\\n",
              "0           0  JOINT-STOCK COMPANY VTB CAPITAL    RU94102445   \n",
              "1           1                     WALMART INC.   US710415188   \n",
              "2           2            ROYAL DUTCH SHELL PLC    GB04366849   \n",
              "3           3        SAUDI ARABIAN OIL COMPANY     SA30947GS   \n",
              "4           4                           BP PLC    GB00102498   \n",
              "\n",
              "                  Address line 1\\nLatin Alphabet Postcode\\nLatin Alphabet  \\\n",
              "0  NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA                   123100   \n",
              "1                     702, SOUTH WEST 8TH STREET                    72716   \n",
              "2                                   SHELL CENTRE                  SE1 7NA   \n",
              "3                                 P.O. BOX: 5000                    31311   \n",
              "4                        1, SAINT JAMES'S SQUARE                 SW1Y 4PD   \n",
              "\n",
              "  City\\nLatin Alphabet                   Country Country ISO code  \\\n",
              "0               MOSCOW        Russian Federation               RU   \n",
              "1          BENTONVILLE  United States of America               US   \n",
              "2               LONDON            United Kingdom               GB   \n",
              "3              DHAHRAN              Saudi Arabia               SA   \n",
              "4               LONDON            United Kingdom               GB   \n",
              "\n",
              "                             GUO - Name GUO - BvD ID number  ...  \\\n",
              "0  GOVERNMENT OF THE RUSSIAN FEDERATION          RU00031093  ...   \n",
              "1                         WALTON FAMILY        WW*901466840  ...   \n",
              "2                 ROYAL DUTCH SHELL PLC          GB04366849  ...   \n",
              "3           THE KINGDOM OF SAUDI ARABIA        SA0000114597  ...   \n",
              "4                                BP PLC          GB00102498  ...   \n",
              "\n",
              "  Financial expenses\\nth USD Last avail. yr  \\\n",
              "0                              12104.176472   \n",
              "1                                  10714000   \n",
              "2                                    550000   \n",
              "3                             501066.692799   \n",
              "4                                   3427000   \n",
              "\n",
              "  Financial expenses\\nth USD Year - 1 Financial expenses\\nth USD Year - 2  \\\n",
              "0                        76731.035919                        83156.963396   \n",
              "1                             5466000                             2367000   \n",
              "2                             2480000                              455000   \n",
              "3                       522133.360565                                n.a.   \n",
              "4                             1382000                             1692000   \n",
              "\n",
              "  Financial expenses\\nth USD Year - 3 Financial expenses\\nth USD Year - 4  \\\n",
              "0                        58234.861049                       109943.231131   \n",
              "1                             2548000                             2461000   \n",
              "2                            -1379000                            -2101000   \n",
              "3                                n.a.                                n.a.   \n",
              "4                              875000                              173000   \n",
              "\n",
              "  Financial expenses\\nth USD Year - 5 Financial expenses\\nth USD Year - 6  \\\n",
              "0                        80535.871538                        61455.423488   \n",
              "1                             2335000                             2249000   \n",
              "2                              829000                            -3464000   \n",
              "3                                n.a.                                n.a.   \n",
              "4                           -11846000                            -5300000   \n",
              "\n",
              "  Financial expenses\\nth USD Year - 7 Financial expenses\\nth USD Year - 8  \\\n",
              "0                        36656.263538                             1.17732   \n",
              "1                             2320000                             2205000   \n",
              "2                            -4005000                            -2662000   \n",
              "3                                n.a.                                n.a.   \n",
              "4                            -3051000                            -4723000   \n",
              "\n",
              "  Financial expenses\\nth USD Year - 9  \n",
              "0                                n.a.  \n",
              "1                             2192000  \n",
              "2                                5000  \n",
              "3                                n.a.  \n",
              "4                            -1317000  \n",
              "\n",
              "[5 rows x 199 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1110bfa5-1bd6-45e3-a98d-2e455ee6974f\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>Company name Latin alphabet_x</th>\n",
              "      <th>BvD ID number</th>\n",
              "      <th>Address line 1\\nLatin Alphabet</th>\n",
              "      <th>Postcode\\nLatin Alphabet</th>\n",
              "      <th>City\\nLatin Alphabet</th>\n",
              "      <th>Country</th>\n",
              "      <th>Country ISO code</th>\n",
              "      <th>GUO - Name</th>\n",
              "      <th>GUO - BvD ID number</th>\n",
              "      <th>...</th>\n",
              "      <th>Financial expenses\\nth USD Last avail. yr</th>\n",
              "      <th>Financial expenses\\nth USD Year - 1</th>\n",
              "      <th>Financial expenses\\nth USD Year - 2</th>\n",
              "      <th>Financial expenses\\nth USD Year - 3</th>\n",
              "      <th>Financial expenses\\nth USD Year - 4</th>\n",
              "      <th>Financial expenses\\nth USD Year - 5</th>\n",
              "      <th>Financial expenses\\nth USD Year - 6</th>\n",
              "      <th>Financial expenses\\nth USD Year - 7</th>\n",
              "      <th>Financial expenses\\nth USD Year - 8</th>\n",
              "      <th>Financial expenses\\nth USD Year - 9</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>JOINT-STOCK COMPANY VTB CAPITAL</td>\n",
              "      <td>RU94102445</td>\n",
              "      <td>NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA</td>\n",
              "      <td>123100</td>\n",
              "      <td>MOSCOW</td>\n",
              "      <td>Russian Federation</td>\n",
              "      <td>RU</td>\n",
              "      <td>GOVERNMENT OF THE RUSSIAN FEDERATION</td>\n",
              "      <td>RU00031093</td>\n",
              "      <td>...</td>\n",
              "      <td>12104.176472</td>\n",
              "      <td>76731.035919</td>\n",
              "      <td>83156.963396</td>\n",
              "      <td>58234.861049</td>\n",
              "      <td>109943.231131</td>\n",
              "      <td>80535.871538</td>\n",
              "      <td>61455.423488</td>\n",
              "      <td>36656.263538</td>\n",
              "      <td>1.17732</td>\n",
              "      <td>n.a.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>WALMART INC.</td>\n",
              "      <td>US710415188</td>\n",
              "      <td>702, SOUTH WEST 8TH STREET</td>\n",
              "      <td>72716</td>\n",
              "      <td>BENTONVILLE</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>US</td>\n",
              "      <td>WALTON FAMILY</td>\n",
              "      <td>WW*901466840</td>\n",
              "      <td>...</td>\n",
              "      <td>10714000</td>\n",
              "      <td>5466000</td>\n",
              "      <td>2367000</td>\n",
              "      <td>2548000</td>\n",
              "      <td>2461000</td>\n",
              "      <td>2335000</td>\n",
              "      <td>2249000</td>\n",
              "      <td>2320000</td>\n",
              "      <td>2205000</td>\n",
              "      <td>2192000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>SHELL CENTRE</td>\n",
              "      <td>SE1 7NA</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>...</td>\n",
              "      <td>550000</td>\n",
              "      <td>2480000</td>\n",
              "      <td>455000</td>\n",
              "      <td>-1379000</td>\n",
              "      <td>-2101000</td>\n",
              "      <td>829000</td>\n",
              "      <td>-3464000</td>\n",
              "      <td>-4005000</td>\n",
              "      <td>-2662000</td>\n",
              "      <td>5000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>SAUDI ARABIAN OIL COMPANY</td>\n",
              "      <td>SA30947GS</td>\n",
              "      <td>P.O. BOX: 5000</td>\n",
              "      <td>31311</td>\n",
              "      <td>DHAHRAN</td>\n",
              "      <td>Saudi Arabia</td>\n",
              "      <td>SA</td>\n",
              "      <td>THE KINGDOM OF SAUDI ARABIA</td>\n",
              "      <td>SA0000114597</td>\n",
              "      <td>...</td>\n",
              "      <td>501066.692799</td>\n",
              "      <td>522133.360565</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>1, SAINT JAMES'S SQUARE</td>\n",
              "      <td>SW1Y 4PD</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>...</td>\n",
              "      <td>3427000</td>\n",
              "      <td>1382000</td>\n",
              "      <td>1692000</td>\n",
              "      <td>875000</td>\n",
              "      <td>173000</td>\n",
              "      <td>-11846000</td>\n",
              "      <td>-5300000</td>\n",
              "      <td>-3051000</td>\n",
              "      <td>-4723000</td>\n",
              "      <td>-1317000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 199 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1110bfa5-1bd6-45e3-a98d-2e455ee6974f')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-1110bfa5-1bd6-45e3-a98d-2e455ee6974f button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-1110bfa5-1bd6-45e3-a98d-2e455ee6974f');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-1b516391-5cdb-41b1-9e3d-3134ad98171c\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1b516391-5cdb-41b1-9e3d-3134ad98171c')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-1b516391-5cdb-41b1-9e3d-3134ad98171c button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 73
        }
      ],
      "source": [
        "small_df.head(5)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "gpIspoK8DErW",
        "outputId": "1b3ad07d-be96-498a-dd94-a1d1463982d9"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['Unnamed: 0', 'Company name Latin alphabet_x', 'BvD ID number',\n",
              "       'Address line 1\\nLatin Alphabet', 'Postcode\\nLatin Alphabet',\n",
              "       'City\\nLatin Alphabet', 'Country', 'Country ISO code', 'GUO - Name',\n",
              "       'GUO - BvD ID number',\n",
              "       ...\n",
              "       'Financial expenses\\nth USD Last avail. yr',\n",
              "       'Financial expenses\\nth USD Year - 1',\n",
              "       'Financial expenses\\nth USD Year - 2',\n",
              "       'Financial expenses\\nth USD Year - 3',\n",
              "       'Financial expenses\\nth USD Year - 4',\n",
              "       'Financial expenses\\nth USD Year - 5',\n",
              "       'Financial expenses\\nth USD Year - 6',\n",
              "       'Financial expenses\\nth USD Year - 7',\n",
              "       'Financial expenses\\nth USD Year - 8',\n",
              "       'Financial expenses\\nth USD Year - 9'],\n",
              "      dtype='object', length=199)"
            ]
          },
          "metadata": {},
          "execution_count": 74
        }
      ],
      "source": [
        "# Print the column names\n",
        "\n",
        "small_df.columns"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "2PnGp7P9AHeq"
      },
      "source": [
        "# Data Cleaning"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "2oS15gSAAMqU",
        "outputId": "f9b19ac4-5935-4c79-8364-4741846cc5ce"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Unnamed: 0                             0\n",
            "Company name Latin alphabet_x          0\n",
            "BvD ID number                          0\n",
            "Address line 1\\nLatin Alphabet         0\n",
            "Postcode\\nLatin Alphabet               5\n",
            "                                      ..\n",
            "Financial expenses\\nth USD Year - 5    0\n",
            "Financial expenses\\nth USD Year - 6    0\n",
            "Financial expenses\\nth USD Year - 7    0\n",
            "Financial expenses\\nth USD Year - 8    0\n",
            "Financial expenses\\nth USD Year - 9    0\n",
            "Length: 199, dtype: int64\n"
          ]
        }
      ],
      "source": [
        "# Checking for missing values\n",
        "\n",
        "missing_values = small_df.isnull().sum()\n",
        "print(missing_values)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 826
        },
        "id": "m3L0-rFvIFwj",
        "outputId": "cc30d9aa-4fc0-42ad-d5da-9545553393aa"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Unnamed: 0         Company name Latin alphabet_x    BvD ID number  \\\n",
              "0            0       JOINT-STOCK COMPANY VTB CAPITAL       RU94102445   \n",
              "1            1                          WALMART INC.      US710415188   \n",
              "2            2                 ROYAL DUTCH SHELL PLC       GB04366849   \n",
              "3            3             SAUDI ARABIAN OIL COMPANY        SA30947GS   \n",
              "4            4                                BP PLC       GB00102498   \n",
              "..         ...                                   ...              ...   \n",
              "95          95           PETRO CHINA COMPANY LIMITED        CN30081PC   \n",
              "96          96                           EQUINOR ASA      NO923609016   \n",
              "97          97  INTERNATIONAL BUSINESS MACHINES CORP      US130871985   \n",
              "98          98                      SONY CORPORATION  JP5010401067252   \n",
              "99          99   ENGIE SERVICES HOLDINGS PTY LIMITED      AU615894794   \n",
              "\n",
              "                   Address line 1\\nLatin Alphabet Postcode\\nLatin Alphabet  \\\n",
              "0   NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA                   123100   \n",
              "1                      702, SOUTH WEST 8TH STREET                    72716   \n",
              "2                                    SHELL CENTRE                  SE1 7NA   \n",
              "3                                  P.O. BOX: 5000                    31311   \n",
              "4                         1, SAINT JAMES'S SQUARE                 SW1Y 4PD   \n",
              "..                                            ...                      ...   \n",
              "95                 NO. 9, DONGZHIMEN NORTH STREET                   100011   \n",
              "96                                   FORUSBEEN 50                     4035   \n",
              "97                            1, NEW ORCHARD ROAD                    10504   \n",
              "98                        1-7-1, KONAN, MINATO-KU                 108-0075   \n",
              "99                                  124 ABBOTT RD                     3803   \n",
              "\n",
              "   City\\nLatin Alphabet                   Country Country ISO code  \\\n",
              "0                MOSCOW        Russian Federation               RU   \n",
              "1           BENTONVILLE  United States of America               US   \n",
              "2                LONDON            United Kingdom               GB   \n",
              "3               DHAHRAN              Saudi Arabia               SA   \n",
              "4                LONDON            United Kingdom               GB   \n",
              "..                  ...                       ...              ...   \n",
              "95              BEIJING                     China               CN   \n",
              "96            STAVANGER                    Norway               NO   \n",
              "97               ARMONK  United States of America               US   \n",
              "98                TOKYO                     Japan               JP   \n",
              "99               HALLAM                 Australia               AU   \n",
              "\n",
              "                              GUO - Name GUO - BvD ID number  ...  \\\n",
              "0   GOVERNMENT OF THE RUSSIAN FEDERATION          RU00031093  ...   \n",
              "1                          WALTON FAMILY        WW*901466840  ...   \n",
              "2                  ROYAL DUTCH SHELL PLC          GB04366849  ...   \n",
              "3            THE KINGDOM OF SAUDI ARABIA        SA0000114597  ...   \n",
              "4                                 BP PLC          GB00102498  ...   \n",
              "..                                   ...                 ...  ...   \n",
              "95                   CHINA-PEOPLE'S REP.         CN*J00S4140  ...   \n",
              "96                                NORWAY         NO*J00S1220  ...   \n",
              "97  INTERNATIONAL BUSINESS MACHINES CORP         US130871985  ...   \n",
              "98                      SONY CORPORATION     JP5010401067252  ...   \n",
              "99                                 ENGIE         FR542107651  ...   \n",
              "\n",
              "   Financial expenses\\nth USD Last avail. yr  \\\n",
              "0                               12104.176472   \n",
              "1                                   10714000   \n",
              "2                                     550000   \n",
              "3                              501066.692799   \n",
              "4                                    3427000   \n",
              "..                                       ...   \n",
              "95                            1104432.345808   \n",
              "96                                   1423000   \n",
              "97                                   1343000   \n",
              "98                            -863640.499269   \n",
              "99                            2544913.695812   \n",
              "\n",
              "   Financial expenses\\nth USD Year - 1 Financial expenses\\nth USD Year - 2  \\\n",
              "0                         76731.035919                        83156.963396   \n",
              "1                              5466000                             2367000   \n",
              "2                              2480000                              455000   \n",
              "3                        522133.360565                                n.a.   \n",
              "4                              1382000                             1692000   \n",
              "..                                 ...                                 ...   \n",
              "95                      2696629.292965                      3324528.442383   \n",
              "96                              603000                              585000   \n",
              "97                              723000                             1556000   \n",
              "98                       523542.683967                       401419.026998   \n",
              "99                      1599155.934453                                n.a.   \n",
              "\n",
              "   Financial expenses\\nth USD Year - 3 Financial expenses\\nth USD Year - 4  \\\n",
              "0                         58234.861049                       109943.231131   \n",
              "1                              2548000                             2461000   \n",
              "2                             -1379000                            -2101000   \n",
              "3                                 n.a.                                n.a.   \n",
              "4                               875000                              173000   \n",
              "..                                 ...                                 ...   \n",
              "95                      2971596.449018                      3670337.962121   \n",
              "96                             1544000                       349932.721257   \n",
              "97                              689000                             1934000   \n",
              "98                         -799.076585                        314586.63418   \n",
              "99                                n.a.                                n.a.   \n",
              "\n",
              "   Financial expenses\\nth USD Year - 5 Financial expenses\\nth USD Year - 6  \\\n",
              "0                         80535.871538                        61455.423488   \n",
              "1                              2335000                             2249000   \n",
              "2                               829000                            -3464000   \n",
              "3                                 n.a.                                n.a.   \n",
              "4                            -11846000                            -5300000   \n",
              "..                                 ...                                 ...   \n",
              "95                      4065533.697024                       3588260.23373   \n",
              "96                      3059210.497141                       179533.213377   \n",
              "97                             1146000                              459000   \n",
              "98                        169236.75881                         68040.36379   \n",
              "99                                n.a.                                n.a.   \n",
              "\n",
              "   Financial expenses\\nth USD Year - 7 Financial expenses\\nth USD Year - 8  \\\n",
              "0                         36656.263538                             1.17732   \n",
              "1                              2320000                             2205000   \n",
              "2                             -4005000                            -2662000   \n",
              "3                                 n.a.                                n.a.   \n",
              "4                             -3051000                            -4723000   \n",
              "..                                 ...                                 ...   \n",
              "95                      2674891.810656                      1557872.668862   \n",
              "96                      -148080.131724                       476962.475106   \n",
              "97                             1024000                             1104000   \n",
              "98                       377504.563924                        79285.456834   \n",
              "99                                n.a.                                n.a.   \n",
              "\n",
              "   Financial expenses\\nth USD Year - 9  \n",
              "0                                 n.a.  \n",
              "1                              2192000  \n",
              "2                                 5000  \n",
              "3                                 n.a.  \n",
              "4                             -1317000  \n",
              "..                                 ...  \n",
              "95                       908500.699446  \n",
              "96                      1646539.777666  \n",
              "97                             -559000  \n",
              "98                       193576.413726  \n",
              "99                                n.a.  \n",
              "\n",
              "[95 rows x 199 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c80ba90e-9140-4fce-ae57-7c47fa3374a4\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>Company name Latin alphabet_x</th>\n",
              "      <th>BvD ID number</th>\n",
              "      <th>Address line 1\\nLatin Alphabet</th>\n",
              "      <th>Postcode\\nLatin Alphabet</th>\n",
              "      <th>City\\nLatin Alphabet</th>\n",
              "      <th>Country</th>\n",
              "      <th>Country ISO code</th>\n",
              "      <th>GUO - Name</th>\n",
              "      <th>GUO - BvD ID number</th>\n",
              "      <th>...</th>\n",
              "      <th>Financial expenses\\nth USD Last avail. yr</th>\n",
              "      <th>Financial expenses\\nth USD Year - 1</th>\n",
              "      <th>Financial expenses\\nth USD Year - 2</th>\n",
              "      <th>Financial expenses\\nth USD Year - 3</th>\n",
              "      <th>Financial expenses\\nth USD Year - 4</th>\n",
              "      <th>Financial expenses\\nth USD Year - 5</th>\n",
              "      <th>Financial expenses\\nth USD Year - 6</th>\n",
              "      <th>Financial expenses\\nth USD Year - 7</th>\n",
              "      <th>Financial expenses\\nth USD Year - 8</th>\n",
              "      <th>Financial expenses\\nth USD Year - 9</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>JOINT-STOCK COMPANY VTB CAPITAL</td>\n",
              "      <td>RU94102445</td>\n",
              "      <td>NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA</td>\n",
              "      <td>123100</td>\n",
              "      <td>MOSCOW</td>\n",
              "      <td>Russian Federation</td>\n",
              "      <td>RU</td>\n",
              "      <td>GOVERNMENT OF THE RUSSIAN FEDERATION</td>\n",
              "      <td>RU00031093</td>\n",
              "      <td>...</td>\n",
              "      <td>12104.176472</td>\n",
              "      <td>76731.035919</td>\n",
              "      <td>83156.963396</td>\n",
              "      <td>58234.861049</td>\n",
              "      <td>109943.231131</td>\n",
              "      <td>80535.871538</td>\n",
              "      <td>61455.423488</td>\n",
              "      <td>36656.263538</td>\n",
              "      <td>1.17732</td>\n",
              "      <td>n.a.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>WALMART INC.</td>\n",
              "      <td>US710415188</td>\n",
              "      <td>702, SOUTH WEST 8TH STREET</td>\n",
              "      <td>72716</td>\n",
              "      <td>BENTONVILLE</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>US</td>\n",
              "      <td>WALTON FAMILY</td>\n",
              "      <td>WW*901466840</td>\n",
              "      <td>...</td>\n",
              "      <td>10714000</td>\n",
              "      <td>5466000</td>\n",
              "      <td>2367000</td>\n",
              "      <td>2548000</td>\n",
              "      <td>2461000</td>\n",
              "      <td>2335000</td>\n",
              "      <td>2249000</td>\n",
              "      <td>2320000</td>\n",
              "      <td>2205000</td>\n",
              "      <td>2192000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>SHELL CENTRE</td>\n",
              "      <td>SE1 7NA</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>...</td>\n",
              "      <td>550000</td>\n",
              "      <td>2480000</td>\n",
              "      <td>455000</td>\n",
              "      <td>-1379000</td>\n",
              "      <td>-2101000</td>\n",
              "      <td>829000</td>\n",
              "      <td>-3464000</td>\n",
              "      <td>-4005000</td>\n",
              "      <td>-2662000</td>\n",
              "      <td>5000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>SAUDI ARABIAN OIL COMPANY</td>\n",
              "      <td>SA30947GS</td>\n",
              "      <td>P.O. BOX: 5000</td>\n",
              "      <td>31311</td>\n",
              "      <td>DHAHRAN</td>\n",
              "      <td>Saudi Arabia</td>\n",
              "      <td>SA</td>\n",
              "      <td>THE KINGDOM OF SAUDI ARABIA</td>\n",
              "      <td>SA0000114597</td>\n",
              "      <td>...</td>\n",
              "      <td>501066.692799</td>\n",
              "      <td>522133.360565</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>1, SAINT JAMES'S SQUARE</td>\n",
              "      <td>SW1Y 4PD</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>...</td>\n",
              "      <td>3427000</td>\n",
              "      <td>1382000</td>\n",
              "      <td>1692000</td>\n",
              "      <td>875000</td>\n",
              "      <td>173000</td>\n",
              "      <td>-11846000</td>\n",
              "      <td>-5300000</td>\n",
              "      <td>-3051000</td>\n",
              "      <td>-4723000</td>\n",
              "      <td>-1317000</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>95</th>\n",
              "      <td>95</td>\n",
              "      <td>PETRO CHINA COMPANY LIMITED</td>\n",
              "      <td>CN30081PC</td>\n",
              "      <td>NO. 9, DONGZHIMEN NORTH STREET</td>\n",
              "      <td>100011</td>\n",
              "      <td>BEIJING</td>\n",
              "      <td>China</td>\n",
              "      <td>CN</td>\n",
              "      <td>CHINA-PEOPLE'S REP.</td>\n",
              "      <td>CN*J00S4140</td>\n",
              "      <td>...</td>\n",
              "      <td>1104432.345808</td>\n",
              "      <td>2696629.292965</td>\n",
              "      <td>3324528.442383</td>\n",
              "      <td>2971596.449018</td>\n",
              "      <td>3670337.962121</td>\n",
              "      <td>4065533.697024</td>\n",
              "      <td>3588260.23373</td>\n",
              "      <td>2674891.810656</td>\n",
              "      <td>1557872.668862</td>\n",
              "      <td>908500.699446</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>96</th>\n",
              "      <td>96</td>\n",
              "      <td>EQUINOR ASA</td>\n",
              "      <td>NO923609016</td>\n",
              "      <td>FORUSBEEN 50</td>\n",
              "      <td>4035</td>\n",
              "      <td>STAVANGER</td>\n",
              "      <td>Norway</td>\n",
              "      <td>NO</td>\n",
              "      <td>NORWAY</td>\n",
              "      <td>NO*J00S1220</td>\n",
              "      <td>...</td>\n",
              "      <td>1423000</td>\n",
              "      <td>603000</td>\n",
              "      <td>585000</td>\n",
              "      <td>1544000</td>\n",
              "      <td>349932.721257</td>\n",
              "      <td>3059210.497141</td>\n",
              "      <td>179533.213377</td>\n",
              "      <td>-148080.131724</td>\n",
              "      <td>476962.475106</td>\n",
              "      <td>1646539.777666</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>97</td>\n",
              "      <td>INTERNATIONAL BUSINESS MACHINES CORP</td>\n",
              "      <td>US130871985</td>\n",
              "      <td>1, NEW ORCHARD ROAD</td>\n",
              "      <td>10504</td>\n",
              "      <td>ARMONK</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>US</td>\n",
              "      <td>INTERNATIONAL BUSINESS MACHINES CORP</td>\n",
              "      <td>US130871985</td>\n",
              "      <td>...</td>\n",
              "      <td>1343000</td>\n",
              "      <td>723000</td>\n",
              "      <td>1556000</td>\n",
              "      <td>689000</td>\n",
              "      <td>1934000</td>\n",
              "      <td>1146000</td>\n",
              "      <td>459000</td>\n",
              "      <td>1024000</td>\n",
              "      <td>1104000</td>\n",
              "      <td>-559000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>98</td>\n",
              "      <td>SONY CORPORATION</td>\n",
              "      <td>JP5010401067252</td>\n",
              "      <td>1-7-1, KONAN, MINATO-KU</td>\n",
              "      <td>108-0075</td>\n",
              "      <td>TOKYO</td>\n",
              "      <td>Japan</td>\n",
              "      <td>JP</td>\n",
              "      <td>SONY CORPORATION</td>\n",
              "      <td>JP5010401067252</td>\n",
              "      <td>...</td>\n",
              "      <td>-863640.499269</td>\n",
              "      <td>523542.683967</td>\n",
              "      <td>401419.026998</td>\n",
              "      <td>-799.076585</td>\n",
              "      <td>314586.63418</td>\n",
              "      <td>169236.75881</td>\n",
              "      <td>68040.36379</td>\n",
              "      <td>377504.563924</td>\n",
              "      <td>79285.456834</td>\n",
              "      <td>193576.413726</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>99</th>\n",
              "      <td>99</td>\n",
              "      <td>ENGIE SERVICES HOLDINGS PTY LIMITED</td>\n",
              "      <td>AU615894794</td>\n",
              "      <td>124 ABBOTT RD</td>\n",
              "      <td>3803</td>\n",
              "      <td>HALLAM</td>\n",
              "      <td>Australia</td>\n",
              "      <td>AU</td>\n",
              "      <td>ENGIE</td>\n",
              "      <td>FR542107651</td>\n",
              "      <td>...</td>\n",
              "      <td>2544913.695812</td>\n",
              "      <td>1599155.934453</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>n.a.</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>95 rows × 199 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c80ba90e-9140-4fce-ae57-7c47fa3374a4')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-c80ba90e-9140-4fce-ae57-7c47fa3374a4 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-c80ba90e-9140-4fce-ae57-7c47fa3374a4');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-db6482f7-0e88-431c-91c2-23e4e40ab573\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-db6482f7-0e88-431c-91c2-23e4e40ab573')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-db6482f7-0e88-431c-91c2-23e4e40ab573 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 76
        }
      ],
      "source": [
        "# Creating a new df which contains only COMPLETE FULL VALUES in relevant columns\n",
        "\n",
        "columns_to_check = [\n",
        "    'Company name Latin alphabet_x',\n",
        "    'BvD ID number',\n",
        "    'Address line 1\\nLatin Alphabet',\n",
        "    'Postcode\\nLatin Alphabet',\n",
        "    'City\\nLatin Alphabet'\n",
        "]\n",
        "\n",
        "complete_rows_df = small_df.dropna(subset=columns_to_check)\n",
        "complete_rows_df"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 667
        },
        "id": "Ii-KWsjAxs0d",
        "outputId": "eb8dfc4e-733a-4476-988d-d27c98d7d561"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           Company name Latin alphabet_x    BvD ID number  \\\n",
              "0        JOINT-STOCK COMPANY VTB CAPITAL       RU94102445   \n",
              "1                           WALMART INC.      US710415188   \n",
              "2                  ROYAL DUTCH SHELL PLC       GB04366849   \n",
              "3              SAUDI ARABIAN OIL COMPANY        SA30947GS   \n",
              "4                                 BP PLC       GB00102498   \n",
              "..                                   ...              ...   \n",
              "95           PETRO CHINA COMPANY LIMITED        CN30081PC   \n",
              "96                           EQUINOR ASA      NO923609016   \n",
              "97  INTERNATIONAL BUSINESS MACHINES CORP      US130871985   \n",
              "98                      SONY CORPORATION  JP5010401067252   \n",
              "99   ENGIE SERVICES HOLDINGS PTY LIMITED      AU615894794   \n",
              "\n",
              "                   Address line 1\\nLatin Alphabet Postcode\\nLatin Alphabet  \\\n",
              "0   NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA                   123100   \n",
              "1                      702, SOUTH WEST 8TH STREET                    72716   \n",
              "2                                    SHELL CENTRE                  SE1 7NA   \n",
              "3                                  P.O. BOX: 5000                    31311   \n",
              "4                         1, SAINT JAMES'S SQUARE                 SW1Y 4PD   \n",
              "..                                            ...                      ...   \n",
              "95                 NO. 9, DONGZHIMEN NORTH STREET                   100011   \n",
              "96                                   FORUSBEEN 50                     4035   \n",
              "97                            1, NEW ORCHARD ROAD                    10504   \n",
              "98                        1-7-1, KONAN, MINATO-KU                 108-0075   \n",
              "99                                  124 ABBOTT RD                     3803   \n",
              "\n",
              "   City\\nLatin Alphabet                   Country Country ISO code  \\\n",
              "0                MOSCOW        Russian Federation               RU   \n",
              "1           BENTONVILLE  United States of America               US   \n",
              "2                LONDON            United Kingdom               GB   \n",
              "3               DHAHRAN              Saudi Arabia               SA   \n",
              "4                LONDON            United Kingdom               GB   \n",
              "..                  ...                       ...              ...   \n",
              "95              BEIJING                     China               CN   \n",
              "96            STAVANGER                    Norway               NO   \n",
              "97               ARMONK  United States of America               US   \n",
              "98                TOKYO                     Japan               JP   \n",
              "99               HALLAM                 Australia               AU   \n",
              "\n",
              "                              GUO - Name GUO - BvD ID number  \\\n",
              "0   GOVERNMENT OF THE RUSSIAN FEDERATION          RU00031093   \n",
              "1                          WALTON FAMILY        WW*901466840   \n",
              "2                  ROYAL DUTCH SHELL PLC          GB04366849   \n",
              "3            THE KINGDOM OF SAUDI ARABIA        SA0000114597   \n",
              "4                                 BP PLC          GB00102498   \n",
              "..                                   ...                 ...   \n",
              "95                   CHINA-PEOPLE'S REP.         CN*J00S4140   \n",
              "96                                NORWAY         NO*J00S1220   \n",
              "97  INTERNATIONAL BUSINESS MACHINES CORP         US130871985   \n",
              "98                      SONY CORPORATION     JP5010401067252   \n",
              "99                                 ENGIE         FR542107651   \n",
              "\n",
              "   GUO - Country ISO code         Latitude        Longitude  \n",
              "0                      RU  55° 44' 58.2\" N  37° 32' 13.5\" E  \n",
              "1                    n.a.              NaN              NaN  \n",
              "2                      GB              NaN              NaN  \n",
              "3                      SA              NaN              NaN  \n",
              "4                      GB              NaN              NaN  \n",
              "..                    ...              ...              ...  \n",
              "95                     CN              NaN              NaN  \n",
              "96                     NO              NaN              NaN  \n",
              "97                     US              NaN              NaN  \n",
              "98                     JP              NaN              NaN  \n",
              "99                     FR              NaN              NaN  \n",
              "\n",
              "[100 rows x 12 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7b06fc12-0206-4c89-b0ac-a7cdd209bbbb\" class=\"colab-df-container\">\n",
              "    <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>Company name Latin alphabet_x</th>\n",
              "      <th>BvD ID number</th>\n",
              "      <th>Address line 1\\nLatin Alphabet</th>\n",
              "      <th>Postcode\\nLatin Alphabet</th>\n",
              "      <th>City\\nLatin Alphabet</th>\n",
              "      <th>Country</th>\n",
              "      <th>Country ISO code</th>\n",
              "      <th>GUO - Name</th>\n",
              "      <th>GUO - BvD ID number</th>\n",
              "      <th>GUO - Country ISO code</th>\n",
              "      <th>Latitude</th>\n",
              "      <th>Longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>JOINT-STOCK COMPANY VTB CAPITAL</td>\n",
              "      <td>RU94102445</td>\n",
              "      <td>NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA</td>\n",
              "      <td>123100</td>\n",
              "      <td>MOSCOW</td>\n",
              "      <td>Russian Federation</td>\n",
              "      <td>RU</td>\n",
              "      <td>GOVERNMENT OF THE RUSSIAN FEDERATION</td>\n",
              "      <td>RU00031093</td>\n",
              "      <td>RU</td>\n",
              "      <td>55° 44' 58.2\" N</td>\n",
              "      <td>37° 32' 13.5\" E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>WALMART INC.</td>\n",
              "      <td>US710415188</td>\n",
              "      <td>702, SOUTH WEST 8TH STREET</td>\n",
              "      <td>72716</td>\n",
              "      <td>BENTONVILLE</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>US</td>\n",
              "      <td>WALTON FAMILY</td>\n",
              "      <td>WW*901466840</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>SHELL CENTRE</td>\n",
              "      <td>SE1 7NA</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>GB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SAUDI ARABIAN OIL COMPANY</td>\n",
              "      <td>SA30947GS</td>\n",
              "      <td>P.O. BOX: 5000</td>\n",
              "      <td>31311</td>\n",
              "      <td>DHAHRAN</td>\n",
              "      <td>Saudi Arabia</td>\n",
              "      <td>SA</td>\n",
              "      <td>THE KINGDOM OF SAUDI ARABIA</td>\n",
              "      <td>SA0000114597</td>\n",
              "      <td>SA</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>1, SAINT JAMES'S SQUARE</td>\n",
              "      <td>SW1Y 4PD</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>GB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>95</th>\n",
              "      <td>PETRO CHINA COMPANY LIMITED</td>\n",
              "      <td>CN30081PC</td>\n",
              "      <td>NO. 9, DONGZHIMEN NORTH STREET</td>\n",
              "      <td>100011</td>\n",
              "      <td>BEIJING</td>\n",
              "      <td>China</td>\n",
              "      <td>CN</td>\n",
              "      <td>CHINA-PEOPLE'S REP.</td>\n",
              "      <td>CN*J00S4140</td>\n",
              "      <td>CN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>96</th>\n",
              "      <td>EQUINOR ASA</td>\n",
              "      <td>NO923609016</td>\n",
              "      <td>FORUSBEEN 50</td>\n",
              "      <td>4035</td>\n",
              "      <td>STAVANGER</td>\n",
              "      <td>Norway</td>\n",
              "      <td>NO</td>\n",
              "      <td>NORWAY</td>\n",
              "      <td>NO*J00S1220</td>\n",
              "      <td>NO</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>INTERNATIONAL BUSINESS MACHINES CORP</td>\n",
              "      <td>US130871985</td>\n",
              "      <td>1, NEW ORCHARD ROAD</td>\n",
              "      <td>10504</td>\n",
              "      <td>ARMONK</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>US</td>\n",
              "      <td>INTERNATIONAL BUSINESS MACHINES CORP</td>\n",
              "      <td>US130871985</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>SONY CORPORATION</td>\n",
              "      <td>JP5010401067252</td>\n",
              "      <td>1-7-1, KONAN, MINATO-KU</td>\n",
              "      <td>108-0075</td>\n",
              "      <td>TOKYO</td>\n",
              "      <td>Japan</td>\n",
              "      <td>JP</td>\n",
              "      <td>SONY CORPORATION</td>\n",
              "      <td>JP5010401067252</td>\n",
              "      <td>JP</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>99</th>\n",
              "      <td>ENGIE SERVICES HOLDINGS PTY LIMITED</td>\n",
              "      <td>AU615894794</td>\n",
              "      <td>124 ABBOTT RD</td>\n",
              "      <td>3803</td>\n",
              "      <td>HALLAM</td>\n",
              "      <td>Australia</td>\n",
              "      <td>AU</td>\n",
              "      <td>ENGIE</td>\n",
              "      <td>FR542107651</td>\n",
              "      <td>FR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>100 rows × 12 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7b06fc12-0206-4c89-b0ac-a7cdd209bbbb')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-7b06fc12-0206-4c89-b0ac-a7cdd209bbbb button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-7b06fc12-0206-4c89-b0ac-a7cdd209bbbb');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-59ea6aad-732d-40ba-817a-979f298237f2\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-59ea6aad-732d-40ba-817a-979f298237f2')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-59ea6aad-732d-40ba-817a-979f298237f2 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 77
        }
      ],
      "source": [
        "# Dropping the irrelevant columns for better efficiency\n",
        "\n",
        "columns_to_keep = [\n",
        "    'Company name Latin alphabet_x',\n",
        "    'BvD ID number',\n",
        "    'Address line 1\\nLatin Alphabet',\n",
        "    'Postcode\\nLatin Alphabet',\n",
        "    'City\\nLatin Alphabet',\n",
        "    'Country',\n",
        "    'Country ISO code',\n",
        "    'GUO - Name',\n",
        "    'GUO - BvD ID number',\n",
        "    'GUO - Country ISO code',\n",
        "    'Latitude',\n",
        "    'Longitude'\n",
        "]\n",
        "\n",
        "df_clean = small_df[columns_to_keep]\n",
        "df_clean"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "9GtZCp8JyuIL",
        "outputId": "4bd416c4-8afb-45d7-e6df-1f18dbb2b66b"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Company name Latin alphabet_x      0\n",
              "BvD ID number                      0\n",
              "Address line 1\\nLatin Alphabet     0\n",
              "Postcode\\nLatin Alphabet           5\n",
              "City\\nLatin Alphabet               0\n",
              "Country                            0\n",
              "Country ISO code                   0\n",
              "GUO - Name                         1\n",
              "GUO - BvD ID number                1\n",
              "GUO - Country ISO code             1\n",
              "Latitude                          90\n",
              "Longitude                         90\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 78
        }
      ],
      "source": [
        "# checking for missing values in each column of our clean df\n",
        "\n",
        "missing_values = df_clean.isnull().sum()\n",
        "missing_values"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8RuGa7xLxaOw"
      },
      "source": [
        "# Creating Geospatial Map"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "geocoder = OpenCageGeocode('c3e8fc2d7b5e4c318dedf4c22c493da6')\n",
        "\n",
        "def geocode_address_opencage(row):\n",
        "    try:\n",
        "        address_parts = [\n",
        "            row['Address line 1\\nLatin Alphabet'],\n",
        "            row['Postcode\\nLatin Alphabet'],\n",
        "            row['City\\nLatin Alphabet']\n",
        "        ]\n",
        "        address = ', '.join(filter(pd.notna, address_parts))\n",
        "\n",
        "        if address:\n",
        "            result = geocoder.geocode(address, no_annotations=\"1\")\n",
        "            if result and len(result):\n",
        "                return result[0]['geometry']['lat'], result[0]['geometry']['lng'], \"Success\"\n",
        "            else:\n",
        "                return None, None, \"No result found\"\n",
        "        else:\n",
        "            return None, None, \"Insufficient address information\"\n",
        "    except Exception as e:\n",
        "        return None, None, f\"Error: {e}\"\n",
        "\n",
        "\n",
        "df_clean[['Latitude', 'Longitude', 'Status']] = df_clean.apply(geocode_address_opencage, axis=1, result_type='expand')\n",
        "\n",
        "\n",
        "m = folium.Map(location=[45, 0], zoom_start=2)\n",
        "\n",
        "\n",
        "marker_cluster = MarkerCluster().add_to(m)\n",
        "\n",
        "\n",
        "plotted_count = 0\n",
        "not_plotted_count = 0\n",
        "reasons_for_not_plotting = []\n",
        "\n",
        "# creating popups\n",
        "for index, row in df_clean.iterrows():\n",
        "    if row['Status'] == \"Success\":\n",
        "        address_line_1 = row['Address line 1\\nLatin Alphabet']\n",
        "        postcode = row['Postcode\\nLatin Alphabet']\n",
        "        city = row['City\\nLatin Alphabet']\n",
        "\n",
        "        popup_message = f\"BvD ID number: {row['BvD ID number']}<br>\"\n",
        "        popup_message += f\"Address: {address_line_1}<br>\"\n",
        "        popup_message += f\"Postcode: {postcode}<br>\"\n",
        "        popup_message += f\"City: {city}\"\n",
        "        popup = folium.Popup(popup_message, max_width=300)\n",
        "\n",
        "        folium.Marker(\n",
        "            [row['Latitude'], row['Longitude']],\n",
        "            popup=popup\n",
        "        ).add_to(marker_cluster)\n",
        "        plotted_count += 1\n",
        "    else:\n",
        "        not_plotted_count += 1\n",
        "        reasons_for_not_plotting.append(row['Status'])\n",
        "\n",
        "# Print the counts and reasons\n",
        "print(\"Number of points successfully plotted:\", plotted_count)\n",
        "print(\"Number of points not plotted:\", not_plotted_count)\n",
        "if reasons_for_not_plotting:\n",
        "    print(\"Reasons for not plotting points:\")\n",
        "    for reason in set(reasons_for_not_plotting):\n",
        "        print(f\"{reason}: {reasons_for_not_plotting.count(reason)} times\")\n",
        "\n",
        "# Adding a title to the map\n",
        "title_html = '''\n",
        "             <h3 align=\"center\" style=\"font-size:20px\"><b>Company Locations</b></h3>\n",
        "             '''\n",
        "m.get_root().html.add_child(folium.Element(title_html))\n",
        "\n",
        "# displaying the map\n",
        "m"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "eUvHIXDIhdKB",
        "outputId": "9b897547-0f76-4974-bd46-1b2376db560f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Number of points successfully plotted: 97\n",
            "Number of points not plotted: 3\n",
            "Reasons for not plotting points:\n",
            "No result found: 3 times\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-79-9ce47eb978f5>:24: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  df_clean[['Latitude', 'Longitude', 'Status']] = df_clean.apply(geocode_address_opencage, axis=1, result_type='expand')\n",
            "<ipython-input-79-9ce47eb978f5>:24: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  df_clean[['Latitude', 'Longitude', 'Status']] = df_clean.apply(geocode_address_opencage, axis=1, result_type='expand')\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x78ed3de11180>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_e4c5a9e3ba388d49fe8d9993bc88f54d {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/1.1.0/leaflet.markercluster.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/1.1.0/MarkerCluster.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/1.1.0/MarkerCluster.Default.css&quot;/&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "             &lt;h3 align=&quot;center&quot; style=&quot;font-size:20px&quot;&gt;&lt;b&gt;Company Locations&lt;/b&gt;&lt;/h3&gt;\n",
              "             \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_e4c5a9e3ba388d49fe8d9993bc88f54d&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_e4c5a9e3ba388d49fe8d9993bc88f54d = L.map(\n",
              "                &quot;map_e4c5a9e3ba388d49fe8d9993bc88f54d&quot;,\n",
              "                {\n",
              "                    center: [45.0, 0.0],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 2,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_b23f3dff56a0ddada7521ebacc4c0989 = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_e4c5a9e3ba388d49fe8d9993bc88f54d);\n",
              "        \n",
              "    \n",
              "            var marker_cluster_53c69b2762667771b6b6f36892488014 = L.markerClusterGroup(\n",
              "                {}\n",
              "            );\n",
              "            map_e4c5a9e3ba388d49fe8d9993bc88f54d.addLayer(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "            var marker_64c4f822e6ec3d873c45430ef1f09765 = L.marker(\n",
              "                [55.75222, 37.61556],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_7a3d003c00b783978075b5f0af76b2f0 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_275045d1125a165d921c560d8d9fce0d = $(`&lt;div id=&quot;html_275045d1125a165d921c560d8d9fce0d&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: RU94102445&lt;br&gt;Address: NAB. PRESNENSKAYA D. 12, BASHNYA &quot;FEDERATSIYA&lt;br&gt;Postcode: 123100&lt;br&gt;City: MOSCOW&lt;/div&gt;`)[0];\n",
              "                popup_7a3d003c00b783978075b5f0af76b2f0.setContent(html_275045d1125a165d921c560d8d9fce0d);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_64c4f822e6ec3d873c45430ef1f09765.bindPopup(popup_7a3d003c00b783978075b5f0af76b2f0)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_5f7c4f3b13394eb6eb0a78675340bbd8 = L.marker(\n",
              "                [36.2995, -93.9568],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_4b260c05aef4b4944acb24b7c187a530 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_70356f0671fe646a3e9d00a83dab26dc = $(`&lt;div id=&quot;html_70356f0671fe646a3e9d00a83dab26dc&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US710415188&lt;br&gt;Address: 702, SOUTH WEST 8TH STREET&lt;br&gt;Postcode: 72716&lt;br&gt;City: BENTONVILLE&lt;/div&gt;`)[0];\n",
              "                popup_4b260c05aef4b4944acb24b7c187a530.setContent(html_70356f0671fe646a3e9d00a83dab26dc);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_5f7c4f3b13394eb6eb0a78675340bbd8.bindPopup(popup_4b260c05aef4b4944acb24b7c187a530)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_873901dc1f70036505722969bce04455 = L.marker(\n",
              "                [51.5038502, -0.1167734],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_ebcff7c3863a1f0c57358c67b542eb35 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_bf433ba964c0f7999acc28272b49ab98 = $(`&lt;div id=&quot;html_bf433ba964c0f7999acc28272b49ab98&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: GB04366849&lt;br&gt;Address: SHELL CENTRE&lt;br&gt;Postcode: SE1 7NA&lt;br&gt;City: LONDON&lt;/div&gt;`)[0];\n",
              "                popup_ebcff7c3863a1f0c57358c67b542eb35.setContent(html_bf433ba964c0f7999acc28272b49ab98);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_873901dc1f70036505722969bce04455.bindPopup(popup_ebcff7c3863a1f0c57358c67b542eb35)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_1770a5d620187f5c72fe8e0d01988e2e = L.marker(\n",
              "                [26.28864, 50.11396],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_fb1ddf77d02de7dfce1c5805e431cf8b = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_bfc030f7ac625971bd018e37d7bf7f37 = $(`&lt;div id=&quot;html_bfc030f7ac625971bd018e37d7bf7f37&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: SA30947GS&lt;br&gt;Address: P.O. BOX: 5000&lt;br&gt;Postcode: 31311&lt;br&gt;City: DHAHRAN&lt;/div&gt;`)[0];\n",
              "                popup_fb1ddf77d02de7dfce1c5805e431cf8b.setContent(html_bfc030f7ac625971bd018e37d7bf7f37);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_1770a5d620187f5c72fe8e0d01988e2e.bindPopup(popup_fb1ddf77d02de7dfce1c5805e431cf8b)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_8040e4f8f42c985ca17fa94bb1315504 = L.marker(\n",
              "                [51.507732, -0.13457],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_e926b7f646645964cc8f3100b80917e1 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_a763198b76f5ac24072f67bb0379b83a = $(`&lt;div id=&quot;html_a763198b76f5ac24072f67bb0379b83a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: GB00102498&lt;br&gt;Address: 1, SAINT JAMES&#x27;S SQUARE&lt;br&gt;Postcode: SW1Y 4PD&lt;br&gt;City: LONDON&lt;/div&gt;`)[0];\n",
              "                popup_e926b7f646645964cc8f3100b80917e1.setContent(html_a763198b76f5ac24072f67bb0379b83a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_8040e4f8f42c985ca17fa94bb1315504.bindPopup(popup_e926b7f646645964cc8f3100b80917e1)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_b2763f99183a02548376e9892ca996c8 = L.marker(\n",
              "                [32.8697, -96.9389],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_7ea0a625bb4dd113ee4787b4ce0eb072 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_2a55c24aa782b8ded15600111e9551b0 = $(`&lt;div id=&quot;html_2a55c24aa782b8ded15600111e9551b0&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US135409005&lt;br&gt;Address: 5959, LAS COLINAS BOULEVARD&lt;br&gt;Postcode: 75039&lt;br&gt;City: IRVING&lt;/div&gt;`)[0];\n",
              "                popup_7ea0a625bb4dd113ee4787b4ce0eb072.setContent(html_2a55c24aa782b8ded15600111e9551b0);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_b2763f99183a02548376e9892ca996c8.bindPopup(popup_7ea0a625bb4dd113ee4787b4ce0eb072)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_853e27e6f16b0ff9cd41d491d1f71753 = L.marker(\n",
              "                [52.42452, 10.7815],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_ca7708d8b24ae59ca84e35439bd8c370 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_49d5c60eedee9f0ae96bff32a166c791 = $(`&lt;div id=&quot;html_49d5c60eedee9f0ae96bff32a166c791&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: DE2070000543&lt;br&gt;Address: BRIEFFACH 1849&lt;br&gt;Postcode: 38436&lt;br&gt;City: WOLFSBURG&lt;/div&gt;`)[0];\n",
              "                popup_ca7708d8b24ae59ca84e35439bd8c370.setContent(html_49d5c60eedee9f0ae96bff32a166c791);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_853e27e6f16b0ff9cd41d491d1f71753.bindPopup(popup_ca7708d8b24ae59ca84e35439bd8c370)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_49b7337b221243ae85e6144f712c1f21 = L.marker(\n",
              "                [37.3305355, -122.0113415],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_cb9df6f515dfd7dc2fc4b84468464138 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_1cdcb84fac6773f5019990b8cd0bd14f = $(`&lt;div id=&quot;html_1cdcb84fac6773f5019990b8cd0bd14f&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US942404110&lt;br&gt;Address: 1, APPLE PARK WAY&lt;br&gt;Postcode: 95014&lt;br&gt;City: CUPERTINO&lt;/div&gt;`)[0];\n",
              "                popup_cb9df6f515dfd7dc2fc4b84468464138.setContent(html_1cdcb84fac6773f5019990b8cd0bd14f);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_49b7337b221243ae85e6144f712c1f21.bindPopup(popup_cb9df6f515dfd7dc2fc4b84468464138)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_c8a4bf9e95d349ed8dd6f3a8c2247a75 = L.marker(\n",
              "                [47.622254, -122.3370283],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_74cc110335dd1f49debe64f3c7debbd3 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_d5936ee5728559be701439166fbd55c9 = $(`&lt;div id=&quot;html_d5936ee5728559be701439166fbd55c9&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US911646860&lt;br&gt;Address: 410, TERRY AVENUE NORTH&lt;br&gt;Postcode: 98109&lt;br&gt;City: SEATTLE&lt;/div&gt;`)[0];\n",
              "                popup_74cc110335dd1f49debe64f3c7debbd3.setContent(html_d5936ee5728559be701439166fbd55c9);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_c8a4bf9e95d349ed8dd6f3a8c2247a75.bindPopup(popup_74cc110335dd1f49debe64f3c7debbd3)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_32aa845bd41f2847e13dd4e26762691b = L.marker(\n",
              "                [49.186077, -2.1042186],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_15496404f7adf5196d820e0ee23f1b55 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_168d2cecc41232656150ce4e26e91cf8 = $(`&lt;div id=&quot;html_168d2cecc41232656150ce4e26e91cf8&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: GBJE107710&lt;br&gt;Address: QUEENSWAY HOUSE&lt;br&gt;Postcode: JE1 1ES&lt;br&gt;City: ST HELIER&lt;/div&gt;`)[0];\n",
              "                popup_15496404f7adf5196d820e0ee23f1b55.setContent(html_168d2cecc41232656150ce4e26e91cf8);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_32aa845bd41f2847e13dd4e26762691b.bindPopup(popup_15496404f7adf5196d820e0ee23f1b55)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_eb6bd43f41a3c6e5286d8d55c75f3104 = L.marker(\n",
              "                [37.2481742, 127.049106],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_f2dd358b43936e312f09ba8b40a90f48 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c2df54c6e0badd85050aaf48a07600eb = $(`&lt;div id=&quot;html_c2df54c6e0badd85050aaf48a07600eb&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: KR1301110006246&lt;br&gt;Address: 129, SAMSEONG-RO GYEONGGI&lt;br&gt;Postcode: nan&lt;br&gt;City: SUWON-SI&lt;/div&gt;`)[0];\n",
              "                popup_f2dd358b43936e312f09ba8b40a90f48.setContent(html_c2df54c6e0badd85050aaf48a07600eb);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_eb6bd43f41a3c6e5286d8d55c75f3104.bindPopup(popup_f2dd358b43936e312f09ba8b40a90f48)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_a1bd329d2c10c6782d54027f6f1e7da1 = L.marker(\n",
              "                [32.8697, -96.9389],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_4be349a7bdf567df3b14a3f6e58e9b7d = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c7bbbd58f0841431e6b209c0bbeeb16a = $(`&lt;div id=&quot;html_c7bbbd58f0841431e6b209c0bbeeb16a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US943207296&lt;br&gt;Address: 6555, STATE HIGHWAY 161&lt;br&gt;Postcode: 75039&lt;br&gt;City: IRVING&lt;/div&gt;`)[0];\n",
              "                popup_4be349a7bdf567df3b14a3f6e58e9b7d.setContent(html_c7bbbd58f0841431e6b209c0bbeeb16a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_a1bd329d2c10c6782d54027f6f1e7da1.bindPopup(popup_4be349a7bdf567df3b14a3f6e58e9b7d)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_ebfc487d4ec0cd92127fd1faba6b06fe = L.marker(\n",
              "                [14.6028444, 120.9765887],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_9185e1c5fbf1e0073b184ce81770bd8e = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_6c1e5cc4784bb47a6d9e17b57ddb57c0 = $(`&lt;div id=&quot;html_6c1e5cc4784bb47a6d9e17b57ddb57c0&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: HK0000174212&lt;br&gt;Address: UNIT 1202&lt;br&gt;Postcode: nan&lt;br&gt;City: WANCHAI&lt;/div&gt;`)[0];\n",
              "                popup_9185e1c5fbf1e0073b184ce81770bd8e.setContent(html_6c1e5cc4784bb47a6d9e17b57ddb57c0);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_ebfc487d4ec0cd92127fd1faba6b06fe.bindPopup(popup_9185e1c5fbf1e0073b184ce81770bd8e)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_8b9e13c1055c96edbd941459c021d104 = L.marker(\n",
              "                [41.9915192, -71.4762693],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_ad753618d5837a07a11aff449dd73de0 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_e594789c0cbee615cac044370e2e87df = $(`&lt;div id=&quot;html_e594789c0cbee615cac044370e2e87df&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US050494040&lt;br&gt;Address: 1, CVS DRIVE&lt;br&gt;Postcode: 02895&lt;br&gt;City: WOONSOCKET&lt;/div&gt;`)[0];\n",
              "                popup_ad753618d5837a07a11aff449dd73de0.setContent(html_e594789c0cbee615cac044370e2e87df);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_8b9e13c1055c96edbd941459c021d104.bindPopup(popup_ad753618d5837a07a11aff449dd73de0)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_fdb54c8da5a74f6e3ef087f382b5c057 = L.marker(\n",
              "                [48.7854021, 9.2410876],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_fde6073d1911490002627d31ba1bc6da = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_84b322df3c9ff1dd8f7d6d6ef93f75c0 = $(`&lt;div id=&quot;html_84b322df3c9ff1dd8f7d6d6ef93f75c0&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: DE7330530056&lt;br&gt;Address: MERCEDESSTRASSE 137&lt;br&gt;Postcode: 70327&lt;br&gt;City: STUTTGART&lt;/div&gt;`)[0];\n",
              "                popup_fde6073d1911490002627d31ba1bc6da.setContent(html_84b322df3c9ff1dd8f7d6d6ef93f75c0);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_fdb54c8da5a74f6e3ef087f382b5c057.bindPopup(popup_fde6073d1911490002627d31ba1bc6da)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_c30cb9206ab100250c7d254880f7c274 = L.marker(\n",
              "                [48.89672, 2.25666],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_67a788c3bfe64388ed645782e56480a3 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_aa6192e61604bebe3336138718e21807 = $(`&lt;div id=&quot;html_aa6192e61604bebe3336138718e21807&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: FR542051180&lt;br&gt;Address: 2, PLACE JEAN MILLIER, LA DEFENSE&lt;br&gt;Postcode: 92078&lt;br&gt;City: COURBEVOIE&lt;/div&gt;`)[0];\n",
              "                popup_67a788c3bfe64388ed645782e56480a3.setContent(html_aa6192e61604bebe3336138718e21807);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_c30cb9206ab100250c7d254880f7c274.bindPopup(popup_67a788c3bfe64388ed645782e56480a3)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_e5862244157939fe99331a5e559f150b = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_4b7d467f77acb5b877dba026c5bec9d8 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_e5939e59791cb0d5e1244d866cfebb31 = $(`&lt;div id=&quot;html_e5939e59791cb0d5e1244d866cfebb31&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9360646475&lt;br&gt;Address: NO. 22, CHAOYANGMEN NORTH STREET&lt;br&gt;Postcode: 100728&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_4b7d467f77acb5b877dba026c5bec9d8.setContent(html_e5939e59791cb0d5e1244d866cfebb31);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_e5862244157939fe99331a5e559f150b.bindPopup(popup_4b7d467f77acb5b877dba026c5bec9d8)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_b008416b4765fc38176fea8e746ea7d2 = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_aa0355c32869b79bc014cb1faebb51f7 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_7f197137ecaf5b23b80e7a2a6574b483 = $(`&lt;div id=&quot;html_7f197137ecaf5b23b80e7a2a6574b483&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9360645018&lt;br&gt;Address: 18F, NO. 22, CHAOYANGMEN NORTH STREET&lt;br&gt;Postcode: 100728&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_aa0355c32869b79bc014cb1faebb51f7.setContent(html_7f197137ecaf5b23b80e7a2a6574b483);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_b008416b4765fc38176fea8e746ea7d2.bindPopup(popup_aa0355c32869b79bc014cb1faebb51f7)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_9ec77a0a91a1f388803807de11217218 = L.marker(\n",
              "                [25.04776, 121.53185],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_fc082b744aa3e7de998007d4ae9f02f4 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_e485ed717024d97791abe8f03e839717 = $(`&lt;div id=&quot;html_e485ed717024d97791abe8f03e839717&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: TW04541302&lt;br&gt;Address: 2, ZIHYOU STREET, TU-CHENG DISTRICT&lt;br&gt;Postcode: 236&lt;br&gt;City: NEW TAIPEI&lt;/div&gt;`)[0];\n",
              "                popup_fc082b744aa3e7de998007d4ae9f02f4.setContent(html_e485ed717024d97791abe8f03e839717);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_9ec77a0a91a1f388803807de11217218.bindPopup(popup_fc082b744aa3e7de998007d4ae9f02f4)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_de76de8dbc16c485719417439e81fcfe = L.marker(\n",
              "                [32.7796042, -96.798763],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_701035f1619dde9405c8956991eba073 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_9456ca467545a5ddf337ce006d27f9ea = $(`&lt;div id=&quot;html_9456ca467545a5ddf337ce006d27f9ea&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US431301883&lt;br&gt;Address: 208, SOUTH AKARD STREET&lt;br&gt;Postcode: 75202&lt;br&gt;City: DALLAS&lt;/div&gt;`)[0];\n",
              "                popup_701035f1619dde9405c8956991eba073.setContent(html_9456ca467545a5ddf337ce006d27f9ea);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_de76de8dbc16c485719417439e81fcfe.bindPopup(popup_701035f1619dde9405c8956991eba073)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_25315c387982b32b8a41c94df45482dd = L.marker(\n",
              "                [40.0685201, -75.4683297],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_cdd90ac68584c09bec9f1e7d7f19a507 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_a8afff7c738121f2152ad5b8928fd3ab = $(`&lt;div id=&quot;html_a8afff7c738121f2152ad5b8928fd3ab&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US233079390&lt;br&gt;Address: 1300, MORRIS DRIVE&lt;br&gt;Postcode: 19087&lt;br&gt;City: CHESTERBROOK&lt;/div&gt;`)[0];\n",
              "                popup_cdd90ac68584c09bec9f1e7d7f19a507.setContent(html_a8afff7c738121f2152ad5b8928fd3ab);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_25315c387982b32b8a41c94df45482dd.bindPopup(popup_cdd90ac68584c09bec9f1e7d7f19a507)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_11ed7e0a7443953ed31f3feec7d4ce1b = L.marker(\n",
              "                [30.3548925, 104.5117419],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c64ce66b2c001277bab0f2bb5cbcc499 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_b8a4d4212462b52d0e07a812c257c65e = $(`&lt;div id=&quot;html_b8a4d4212462b52d0e07a812c257c65e&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9393074104&lt;br&gt;Address: NO. 6, YINGBING AVENUE&lt;br&gt;Postcode: 610036&lt;br&gt;City: CHENG DOU SHI&lt;/div&gt;`)[0];\n",
              "                popup_c64ce66b2c001277bab0f2bb5cbcc499.setContent(html_b8a4d4212462b52d0e07a812c257c65e);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_11ed7e0a7443953ed31f3feec7d4ce1b.bindPopup(popup_c64ce66b2c001277bab0f2bb5cbcc499)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_3c9ab54366c556432bed6e4edf2cee1b = L.marker(\n",
              "                [42.3349, -83.1801],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_322fa860f50ec8ed0e97505f3fcf27bb = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_7141a369633e5d4cea64675d92bdb441 = $(`&lt;div id=&quot;html_7141a369633e5d4cea64675d92bdb441&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US380549190&lt;br&gt;Address: 1, AMERICAN ROAD&lt;br&gt;Postcode: 48126&lt;br&gt;City: DEARBORN&lt;/div&gt;`)[0];\n",
              "                popup_322fa860f50ec8ed0e97505f3fcf27bb.setContent(html_7141a369633e5d4cea64675d92bdb441);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_3c9ab54366c556432bed6e4edf2cee1b.bindPopup(popup_322fa860f50ec8ed0e97505f3fcf27bb)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_84a69454a056ebf5a1c8638552bb03d6 = L.marker(\n",
              "                [37.7583351, -121.9594581],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_e45aa6523f22406795688b4ebe85e84c = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_518a83fe3f4a0d0c29e96e7e292ae7a9 = $(`&lt;div id=&quot;html_518a83fe3f4a0d0c29e96e7e292ae7a9&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US940890210&lt;br&gt;Address: 6001, BOLLINGER CANYON ROAD&lt;br&gt;Postcode: 94583&lt;br&gt;City: SAN RAMON&lt;/div&gt;`)[0];\n",
              "                popup_e45aa6523f22406795688b4ebe85e84c.setContent(html_518a83fe3f4a0d0c29e96e7e292ae7a9);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_84a69454a056ebf5a1c8638552bb03d6.bindPopup(popup_e45aa6523f22406795688b4ebe85e84c)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_c1773bef1a234a19ab7e6a73e2061ce9 = L.marker(\n",
              "                [47.5486034, -122.0506179],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_6abf22637a4cf538d34b6f295b84995a = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_cba895fdebbd62cea27ed231e73254db = $(`&lt;div id=&quot;html_cba895fdebbd62cea27ed231e73254db&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US911223280&lt;br&gt;Address: 999, LAKE DRIVE&lt;br&gt;Postcode: 98027&lt;br&gt;City: ISSAQUAH&lt;/div&gt;`)[0];\n",
              "                popup_6abf22637a4cf538d34b6f295b84995a.setContent(html_cba895fdebbd62cea27ed231e73254db);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_c1773bef1a234a19ab7e6a73e2061ce9.bindPopup(popup_6abf22637a4cf538d34b6f295b84995a)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_f5c862231784b1ec1fd3345aaae91889 = L.marker(\n",
              "                [52.3364095, 4.8740794],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_8677e1cb0c6fe7d7fee59664a2d11bf0 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_49d7a113a23b0f787ac8b6763451362e = $(`&lt;div id=&quot;html_49d7a113a23b0f787ac8b6763451362e&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: NL64236277&lt;br&gt;Address: GUSTAV MAHLERPLEIN 25&lt;br&gt;Postcode: 1082 MS&lt;br&gt;City: AMSTERDAM&lt;/div&gt;`)[0];\n",
              "                popup_8677e1cb0c6fe7d7fee59664a2d11bf0.setContent(html_49d7a113a23b0f787ac8b6763451362e);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_f5c862231784b1ec1fd3345aaae91889.bindPopup(popup_8677e1cb0c6fe7d7fee59664a2d11bf0)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_ebd809dfa6e45df3b678883fd20dcf53 = L.marker(\n",
              "                [40.110128, -83.117655],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_68978f3106847c62edc69a6879d0aec6 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_a28b0b17f771db8df3d86cf85e0345d9 = $(`&lt;div id=&quot;html_a28b0b17f771db8df3d86cf85e0345d9&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US310958666&lt;br&gt;Address: 7000, CARDINAL PLACE&lt;br&gt;Postcode: 43017&lt;br&gt;City: DUBLIN&lt;/div&gt;`)[0];\n",
              "                popup_68978f3106847c62edc69a6879d0aec6.setContent(html_a28b0b17f771db8df3d86cf85e0345d9);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_ebd809dfa6e45df3b678883fd20dcf53.bindPopup(popup_68978f3106847c62edc69a6879d0aec6)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_b2c3d277816614a5553828d0495f8f2f = L.marker(\n",
              "                [35.69402, 139.75363],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_10d18eb12c83e06e5ad547154a0d0caf = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_8ebf2c80741fb27cd0fcbef9c60a0829 = $(`&lt;div id=&quot;html_8ebf2c80741fb27cd0fcbef9c60a0829&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP5010001008771&lt;br&gt;Address: 2-3-1, MARUNOUCHI, CHIYODA-KU&lt;br&gt;Postcode: 100-8086&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_10d18eb12c83e06e5ad547154a0d0caf.setContent(html_8ebf2c80741fb27cd0fcbef9c60a0829);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_b2c3d277816614a5553828d0495f8f2f.bindPopup(popup_10d18eb12c83e06e5ad547154a0d0caf)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_9ed3e855e6746178a6bdb178e3f0820d = L.marker(\n",
              "                [35.668585, 139.7248202],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_1f50ca78d43641bbe3974d601435ae5d = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_d576204b99d6b8a7d1e91e2a9d6108a7 = $(`&lt;div id=&quot;html_d576204b99d6b8a7d1e91e2a9d6108a7&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP6010401027577&lt;br&gt;Address: 2-1-1, MINAMI-AOYAMA, MINATO-KU&lt;br&gt;Postcode: 107-8556&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_1f50ca78d43641bbe3974d601435ae5d.setContent(html_d576204b99d6b8a7d1e91e2a9d6108a7);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_9ed3e855e6746178a6bdb178e3f0820d.bindPopup(popup_1f50ca78d43641bbe3974d601435ae5d)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_45d6b98c038f973410ac1fdf2e02a93c = L.marker(\n",
              "                [42.1554948, -87.8688505],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_2fabefab1c79e3d4061baf49d3316c5a = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_e0fb454a85db5536a1d2df0ac2427b41 = $(`&lt;div id=&quot;html_e0fb454a85db5536a1d2df0ac2427b41&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US471758322&lt;br&gt;Address: 108, WILMOT ROAD&lt;br&gt;Postcode: 60015&lt;br&gt;City: DEERFIELD&lt;/div&gt;`)[0];\n",
              "                popup_2fabefab1c79e3d4061baf49d3316c5a.setContent(html_e0fb454a85db5536a1d2df0ac2427b41);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_45d6b98c038f973410ac1fdf2e02a93c.bindPopup(popup_2fabefab1c79e3d4061baf49d3316c5a)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_a06352f6b4117e8e98ca6a9f4d4f583f = L.marker(\n",
              "                [37.4217636, -122.084614],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_6c534dc4efcf02ad3fe1c785571044b8 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_9d0bd3b9bf43cd23b78201d9bf5f7924 = $(`&lt;div id=&quot;html_9d0bd3b9bf43cd23b78201d9bf5f7924&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US611767919&lt;br&gt;Address: 1600, AMPHITHEATRE PARKWAY&lt;br&gt;Postcode: 94043&lt;br&gt;City: MOUNTAIN VIEW&lt;/div&gt;`)[0];\n",
              "                popup_6c534dc4efcf02ad3fe1c785571044b8.setContent(html_9d0bd3b9bf43cd23b78201d9bf5f7924);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_a06352f6b4117e8e98ca6a9f4d4f583f.bindPopup(popup_6c534dc4efcf02ad3fe1c785571044b8)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_461de2d96ddd65db7918b2abf09b41ef = L.marker(\n",
              "                [40.7546279, -73.9845292],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_32c6509e4fc3e63c83837d3a32e166c1 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_edf728b4030c87190eff85dad8f3cbd3 = $(`&lt;div id=&quot;html_edf728b4030c87190eff85dad8f3cbd3&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US232259884&lt;br&gt;Address: 1095, AVENUE OF THE AMERICAS&lt;br&gt;Postcode: 10036&lt;br&gt;City: NEW YORK&lt;/div&gt;`)[0];\n",
              "                popup_32c6509e4fc3e63c83837d3a32e166c1.setContent(html_edf728b4030c87190eff85dad8f3cbd3);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_461de2d96ddd65db7918b2abf09b41ef.bindPopup(popup_32c6509e4fc3e63c83837d3a32e166c1)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_380601764c33f69634b0730dd110710a = L.marker(\n",
              "                [47.6411346, -122.1267676],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_19ea44dda98e1977b5f1f9b8a39bab07 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_f66dffa740511083a0dda967d3afa5cf = $(`&lt;div id=&quot;html_f66dffa740511083a0dda967d3afa5cf&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US911144442&lt;br&gt;Address: 1, MICROSOFT WAY&lt;br&gt;Postcode: 98052-6399&lt;br&gt;City: REDMOND&lt;/div&gt;`)[0];\n",
              "                popup_19ea44dda98e1977b5f1f9b8a39bab07.setContent(html_f66dffa740511083a0dda967d3afa5cf);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_380601764c33f69634b0730dd110710a.bindPopup(popup_19ea44dda98e1977b5f1f9b8a39bab07)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_dd1dfa144654994176889be3dca2d200 = L.marker(\n",
              "                [42.3520329, -71.0478414],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c09d244998a5d03cb66993faea3bc9cf = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_013ce830ca14dc5e586069d7a931952c = $(`&lt;div id=&quot;html_013ce830ca14dc5e586069d7a931952c&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US140689340&lt;br&gt;Address: 41, FARNSWORTH STREET&lt;br&gt;Postcode: 02210&lt;br&gt;City: BOSTON&lt;/div&gt;`)[0];\n",
              "                popup_c09d244998a5d03cb66993faea3bc9cf.setContent(html_013ce830ca14dc5e586069d7a931952c);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_dd1dfa144654994176889be3dca2d200.bindPopup(popup_c09d244998a5d03cb66993faea3bc9cf)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_0b9ff6914c79dc23b4c1256f014c0a96 = L.marker(\n",
              "                [39.1069268, -84.5142328],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_6596212f5a7ab42f6d8974fa921eec88 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_2292ad8953342e87f9398b137f87b69a = $(`&lt;div id=&quot;html_2292ad8953342e87f9398b137f87b69a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US310345740&lt;br&gt;Address: 1014, VINE STREET&lt;br&gt;Postcode: 45202&lt;br&gt;City: CINCINNATI&lt;/div&gt;`)[0];\n",
              "                popup_6596212f5a7ab42f6d8974fa921eec88.setContent(html_2292ad8953342e87f9398b137f87b69a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_0b9ff6914c79dc23b4c1256f014c0a96.bindPopup(popup_6596212f5a7ab42f6d8974fa921eec88)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_56f07aa6a8154d28e3d43988bda3a2d2 = L.marker(\n",
              "                [45.032436, 7.6671158],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_4fed66410f01edd80065a0a287074b14 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_e701d881d74a89f2bcf13da729906302 = $(`&lt;div id=&quot;html_e701d881d74a89f2bcf13da729906302&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: IT00469580013&lt;br&gt;Address: VIA NIZZA 250&lt;br&gt;Postcode: 10126&lt;br&gt;City: TORINO&lt;/div&gt;`)[0];\n",
              "                popup_4fed66410f01edd80065a0a287074b14.setContent(html_e701d881d74a89f2bcf13da729906302);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_56f07aa6a8154d28e3d43988bda3a2d2.bindPopup(popup_4fed66410f01edd80065a0a287074b14)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_63642c2fbee7b394780c0e0dc16b835a = L.marker(\n",
              "                [55.752, 37.615],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_3bbf17565b879c334b8ac9ec34d15b02 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_72ffdff67919a71bc14e09ae930f1142 = $(`&lt;div id=&quot;html_72ffdff67919a71bc14e09ae930f1142&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: RU00040778&lt;br&gt;Address: 16, NAMETKINA STREET&lt;br&gt;Postcode: 117997&lt;br&gt;City: MOSCOW&lt;/div&gt;`)[0];\n",
              "                popup_3bbf17565b879c334b8ac9ec34d15b02.setContent(html_72ffdff67919a71bc14e09ae930f1142);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_63642c2fbee7b394780c0e0dc16b835a.bindPopup(popup_3bbf17565b879c334b8ac9ec34d15b02)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_cd35405ebbb0d4ed74c1e1ab7220ee16 = L.marker(\n",
              "                [29.5860801, -98.6049768],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c699572ccd4d9cde4c30f576c28c63f2 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_0aa0c23b69c39e72a1b28d2d363828e5 = $(`&lt;div id=&quot;html_0aa0c23b69c39e72a1b28d2d363828e5&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US741828067&lt;br&gt;Address: 1, VALERO WAY&lt;br&gt;Postcode: 78249&lt;br&gt;City: SAN ANTONIO&lt;/div&gt;`)[0];\n",
              "                popup_c699572ccd4d9cde4c30f576c28c63f2.setContent(html_0aa0c23b69c39e72a1b28d2d363828e5);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_cd35405ebbb0d4ed74c1e1ab7220ee16.bindPopup(popup_c699572ccd4d9cde4c30f576c28c63f2)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_140842fba673fdcf4ab2597cb72d1bd7 = L.marker(\n",
              "                [35.69402, 139.75363],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_18cd418e582691a564e671754ebbb363 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_39c0d413c22778498d79f0bc2b706b16 = $(`&lt;div id=&quot;html_39c0d413c22778498d79f0bc2b706b16&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP5010001112697&lt;br&gt;Address: 2-3-1 OTEMACHI, CHIYODA-KU&lt;br&gt;Postcode: 100-8791&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_18cd418e582691a564e671754ebbb363.setContent(html_39c0d413c22778498d79f0bc2b706b16);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_140842fba673fdcf4ab2597cb72d1bd7.bindPopup(popup_18cd418e582691a564e671754ebbb363)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_2e5b713f6eb8707707060fc985fb9270 = L.marker(\n",
              "                [48.13743, 11.57549],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_8c0447858a35251ae63aaac1cbdcef98 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_0fe54a87998e4ae2956941b605b42a6c = $(`&lt;div id=&quot;html_0fe54a87998e4ae2956941b605b42a6c&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: DE8170003036&lt;br&gt;Address: PETUELRING 130&lt;br&gt;Postcode: 80788&lt;br&gt;City: MUENCHEN&lt;/div&gt;`)[0];\n",
              "                popup_8c0447858a35251ae63aaac1cbdcef98.setContent(html_0fe54a87998e4ae2956941b605b42a6c);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_2e5b713f6eb8707707060fc985fb9270.bindPopup(popup_8c0447858a35251ae63aaac1cbdcef98)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_e2db904280ae30284259dea266f7fbdc = L.marker(\n",
              "                [29.741165, -95.5623279],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c25e3e8b87ee48da40e90dd4ddcb1240 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_05d3b558b260b76630b4fb37df2d89bd = $(`&lt;div id=&quot;html_05d3b558b260b76630b4fb37df2d89bd&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US453779385&lt;br&gt;Address: 2331, CITYWEST BOULEVARD&lt;br&gt;Postcode: 77042&lt;br&gt;City: HOUSTON&lt;/div&gt;`)[0];\n",
              "                popup_c25e3e8b87ee48da40e90dd4ddcb1240.setContent(html_05d3b558b260b76630b4fb37df2d89bd);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_e2db904280ae30284259dea266f7fbdc.bindPopup(popup_c25e3e8b87ee48da40e90dd4ddcb1240)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_5b97b49ecaf6b51bf3b51be786fdada1 = L.marker(\n",
              "                [48.8712949, 2.3136468],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_3161b435b14850f06e53376b5b95a6c7 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_1cb61c958364a8881f2434616c56ce5f = $(`&lt;div id=&quot;html_1cb61c958364a8881f2434616c56ce5f&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: FR572093920&lt;br&gt;Address: 25, AVENUE MATIGNON&lt;br&gt;Postcode: 75008&lt;br&gt;City: PARIS&lt;/div&gt;`)[0];\n",
              "                popup_3161b435b14850f06e53376b5b95a6c7.setContent(html_1cb61c958364a8881f2434616c56ce5f);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_5b97b49ecaf6b51bf3b51be786fdada1.bindPopup(popup_3161b435b14850f06e53376b5b95a6c7)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_ba4f31128dd6086dcd39e7b15a8bc6d2 = L.marker(\n",
              "                [44.9640279, -93.4957918],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_deb925ccf7f21b7c9164ca1ae90ee5a5 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_4169f323dfa7f7ade9120325248037b1 = $(`&lt;div id=&quot;html_4169f323dfa7f7ade9120325248037b1&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US126054559L&lt;br&gt;Address: 15407 MCGINTY RD W&lt;br&gt;Postcode: 55391-2365&lt;br&gt;City: WAYZATA&lt;/div&gt;`)[0];\n",
              "                popup_deb925ccf7f21b7c9164ca1ae90ee5a5.setContent(html_4169f323dfa7f7ade9120325248037b1);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_ba4f31128dd6086dcd39e7b15a8bc6d2.bindPopup(popup_deb925ccf7f21b7c9164ca1ae90ee5a5)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_fc08ff8aec9f50ef0689f1c8f5b7606b = L.marker(\n",
              "                [40.7558181, -73.9751006],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c8f49b5e1627eaefaa39f345700d4e5e = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_48c1560db3775a9e01ea958d74526a79 = $(`&lt;div id=&quot;html_48c1560db3775a9e01ea958d74526a79&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US132624428&lt;br&gt;Address: 270 PARK AVENUE&lt;br&gt;Postcode: 10017&lt;br&gt;City: NEW YORK, NY&lt;/div&gt;`)[0];\n",
              "                popup_c8f49b5e1627eaefaa39f345700d4e5e.setContent(html_48c1560db3775a9e01ea958d74526a79);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_fc08ff8aec9f50ef0689f1c8f5b7606b.bindPopup(popup_c8f49b5e1627eaefaa39f345700d4e5e)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_5002bab22324cfd38ca77cd28829aebb = L.marker(\n",
              "                [33.8713, -84.4629],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_28f9d0cd7086567f270d5a15b5663ec1 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_35d9fcc77c9f0e349eaa0650843a1b0a = $(`&lt;div id=&quot;html_35d9fcc77c9f0e349eaa0650843a1b0a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US953261426&lt;br&gt;Address: 2455, PACES FERRY ROAD NORTH WEST&lt;br&gt;Postcode: 30339&lt;br&gt;City: ATLANTA&lt;/div&gt;`)[0];\n",
              "                popup_28f9d0cd7086567f270d5a15b5663ec1.setContent(html_35d9fcc77c9f0e349eaa0650843a1b0a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_5002bab22324cfd38ca77cd28829aebb.bindPopup(popup_28f9d0cd7086567f270d5a15b5663ec1)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_6b078f2a05a4e45236a56a83cc27dc04 = L.marker(\n",
              "                [35.6895, 139.69171],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_873507706af41de0078d0931643f4918 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_7dea69eef1a67d5e35a3d8a27869909a = $(`&lt;div id=&quot;html_7dea69eef1a67d5e35a3d8a27869909a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP7010001065142&lt;br&gt;Address: OTEMACHI FIRST SQUARE, EAST TOWER&lt;br&gt;Postcode: 100-8116&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_873507706af41de0078d0931643f4918.setContent(html_7dea69eef1a67d5e35a3d8a27869909a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_6b078f2a05a4e45236a56a83cc27dc04.bindPopup(popup_873507706af41de0078d0931643f4918)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_bd2ab9b3106e6d840dc966b443baaff3 = L.marker(\n",
              "                [1.3059953, 103.7911009],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_382082c93ec57bf2da1d02210fd918f1 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_d22b9e2681281eaf38233da468273e5a = $(`&lt;div id=&quot;html_d22b9e2681281eaf38233da468273e5a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: SG198902087C&lt;br&gt;Address: #07-01 THE METROPOLIS&lt;br&gt;Postcode: 138588&lt;br&gt;City: SINGAPORE&lt;/div&gt;`)[0];\n",
              "                popup_382082c93ec57bf2da1d02210fd918f1.setContent(html_d22b9e2681281eaf38233da468273e5a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_bd2ab9b3106e6d840dc966b443baaff3.bindPopup(popup_382082c93ec57bf2da1d02210fd918f1)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_495a540691f883d58743bd1526874de9 = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_3cf249b33118b8bd0df0bc570861b1ce = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_a99ff5fd77897f508cebaed7ef4e6826 = $(`&lt;div id=&quot;html_a99ff5fd77897f508cebaed7ef4e6826&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN31859PC&lt;br&gt;Address: EAST YARD NO. 40, FUXING ROAD&lt;br&gt;Postcode: 100855&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_3cf249b33118b8bd0df0bc570861b1ce.setContent(html_a99ff5fd77897f508cebaed7ef4e6826);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_495a540691f883d58743bd1526874de9.bindPopup(popup_3cf249b33118b8bd0df0bc570861b1ce)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_3638d8b39ab25577dfb073ee35fb681b = L.marker(\n",
              "                [35.65, 139.73333],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_640e265ef82e5029739dd014887e3732 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_3c6da09e7c2ccacceedd1f3af68cd821 = $(`&lt;div id=&quot;html_3c6da09e7c2ccacceedd1f3af68cd821&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP7120001077358&lt;br&gt;Address: 5-1, KITA-AOYAMA 2-CHOME, MINATO-KU&lt;br&gt;Postcode: 107-8077&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_640e265ef82e5029739dd014887e3732.setContent(html_3c6da09e7c2ccacceedd1f3af68cd821);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_3638d8b39ab25577dfb073ee35fb681b.bindPopup(popup_640e265ef82e5029739dd014887e3732)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_1ac9ea5931388f3482a69bb341d222b7 = L.marker(\n",
              "                [35.45677, 139.6186],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_6aab902beb9f913451d77422bfba6515 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_4747e5cec404929260425556b31df000 = $(`&lt;div id=&quot;html_4747e5cec404929260425556b31df000&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP9020001031109&lt;br&gt;Address: 1-1, TAKASHIMA 1-CHOME, NISHI-KU&lt;br&gt;Postcode: 104-8023&lt;br&gt;City: YOKOHAMA&lt;/div&gt;`)[0];\n",
              "                popup_6aab902beb9f913451d77422bfba6515.setContent(html_4747e5cec404929260425556b31df000);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_1ac9ea5931388f3482a69bb341d222b7.bindPopup(popup_6aab902beb9f913451d77422bfba6515)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_e265d6fa0f721fa96e3659421b4e7f0e = L.marker(\n",
              "                [1.2831049, 103.8519489],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_e4c88334ba52962d32fefee71656593c = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_17ac94e91fab77bfc83f1de2c5a41adc = $(`&lt;div id=&quot;html_17ac94e91fab77bfc83f1de2c5a41adc&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: SG199601595D&lt;br&gt;Address: #29-00 OCEAN FINANCIAL CENTRE&lt;br&gt;Postcode: 049315&lt;br&gt;City: SINGAPORE&lt;/div&gt;`)[0];\n",
              "                popup_e4c88334ba52962d32fefee71656593c.setContent(html_17ac94e91fab77bfc83f1de2c5a41adc);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_e265d6fa0f721fa96e3659421b4e7f0e.bindPopup(popup_e4c88334ba52962d32fefee71656593c)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_93a88d0622e5112f3b611612c90049a4 = L.marker(\n",
              "                [35.69402, 139.75363],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_bde53339ceb1c235ba233d4f2464252c = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_97fbc6d4541692a286915ac89ffc688e = $(`&lt;div id=&quot;html_97fbc6d4541692a286915ac89ffc688e&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP9010001131743&lt;br&gt;Address: 1-2, OTEMACHI, 1-CHOME, CHIYODA-KU&lt;br&gt;Postcode: 100-8161&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_bde53339ceb1c235ba233d4f2464252c.setContent(html_97fbc6d4541692a286915ac89ffc688e);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_93a88d0622e5112f3b611612c90049a4.bindPopup(popup_bde53339ceb1c235ba233d4f2464252c)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_eb4747bd5a51c8082bc8a31b6f0887a9 = L.marker(\n",
              "                [41.8868, -87.6386],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_d6dd9c32a255d80bbf5560710178571e = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_fa5d7eba16f4675e5940d20b836cb4ee = $(`&lt;div id=&quot;html_fa5d7eba16f4675e5940d20b836cb4ee&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US910425694&lt;br&gt;Address: 100, NORTH RIVERSIDE PLAZA&lt;br&gt;Postcode: 60606&lt;br&gt;City: CHICAGO&lt;/div&gt;`)[0];\n",
              "                popup_d6dd9c32a255d80bbf5560710178571e.setContent(html_fa5d7eba16f4675e5940d20b836cb4ee);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_eb4747bd5a51c8082bc8a31b6f0887a9.bindPopup(popup_d6dd9c32a255d80bbf5560710178571e)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_c51f783935068ad88e23f3e760997642 = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_b2ec5b808f843a478ad99e5fe8bfd9ba = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_4fb414eb79f60937285be5225852d7e4 = $(`&lt;div id=&quot;html_4fb414eb79f60937285be5225852d7e4&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9364410981&lt;br&gt;Address: NO. 25, CHAOYANGMEN NORTH STREET&lt;br&gt;Postcode: 100010&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_b2ec5b808f843a478ad99e5fe8bfd9ba.setContent(html_4fb414eb79f60937285be5225852d7e4);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_c51f783935068ad88e23f3e760997642.bindPopup(popup_b2ec5b808f843a478ad99e5fe8bfd9ba)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_ffb3c969debabc875da9c3814a3011d0 = L.marker(\n",
              "                [38.7198675, -90.310093],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_f4487aada828b1fe7a39f4a71268e3de = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_037ac7c76fae9a0b4dec3416b9e8e1c5 = $(`&lt;div id=&quot;html_037ac7c76fae9a0b4dec3416b9e8e1c5&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US452884094&lt;br&gt;Address: 1, EXPRESS WAY&lt;br&gt;Postcode: 63121&lt;br&gt;City: ST. LOUIS&lt;/div&gt;`)[0];\n",
              "                popup_f4487aada828b1fe7a39f4a71268e3de.setContent(html_037ac7c76fae9a0b4dec3416b9e8e1c5);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_ffb3c969debabc875da9c3814a3011d0.bindPopup(popup_f4487aada828b1fe7a39f4a71268e3de)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_deee8d75934168a91963624abe751f53 = L.marker(\n",
              "                [1.2831049, 103.8519489],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c819a05b24720826ea336a84a957541d = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_ad10004d6f85c1bf95bb3303d5d4e92b = $(`&lt;div id=&quot;html_ad10004d6f85c1bf95bb3303d5d4e92b&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: SG201017488D&lt;br&gt;Address: OCEAN FINANCIAL CENTRE&lt;br&gt;Postcode: 49315&lt;br&gt;City: SINGAPORE&lt;/div&gt;`)[0];\n",
              "                popup_c819a05b24720826ea336a84a957541d.setContent(html_ad10004d6f85c1bf95bb3303d5d4e92b);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_deee8d75934168a91963624abe751f53.bindPopup(popup_c819a05b24720826ea336a84a957541d)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_e277a06518d1b36b21da225413d528cb = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_edf6372d81a8e81b08b8c290858646d7 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_401b4d7e4d45f274da19f8aa7ac7d2f1 = $(`&lt;div id=&quot;html_401b4d7e4d45f274da19f8aa7ac7d2f1&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN30086PC&lt;br&gt;Address: NO. 22, CHAOYANGMEN NORTH STREET&lt;br&gt;Postcode: 100728&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_edf6372d81a8e81b08b8c290858646d7.setContent(html_401b4d7e4d45f274da19f8aa7ac7d2f1);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_e277a06518d1b36b21da225413d528cb.bindPopup(popup_edf6372d81a8e81b08b8c290858646d7)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_98d61f7bf9a9677b6b1effc0e82fcaad = L.marker(\n",
              "                [41.036497, -83.6501626],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_666ade29b15933afb68e54421609f529 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_75c54054f4a5cef0997c95e48682328e = $(`&lt;div id=&quot;html_75c54054f4a5cef0997c95e48682328e&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US271284632&lt;br&gt;Address: 539, SOUTH MAIN STREET&lt;br&gt;Postcode: 45840&lt;br&gt;City: FINDLAY&lt;/div&gt;`)[0];\n",
              "                popup_666ade29b15933afb68e54421609f529.setContent(html_75c54054f4a5cef0997c95e48682328e);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_98d61f7bf9a9677b6b1effc0e82fcaad.bindPopup(popup_666ade29b15933afb68e54421609f529)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_ce7bc67f4a016016315e85da42cb7bff = L.marker(\n",
              "                [48.1438836, 11.5763153],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_0d24f73d41b199d1eae329d38761b9d1 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_8319cc6068c5cc4a2b9dce79092b95f8 = $(`&lt;div id=&quot;html_8319cc6068c5cc4a2b9dce79092b95f8&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: DE2010000581&lt;br&gt;Address: WITTELSBACHERPLATZ 2&lt;br&gt;Postcode: 80333&lt;br&gt;City: MUNCHEN&lt;/div&gt;`)[0];\n",
              "                popup_0d24f73d41b199d1eae329d38761b9d1.setContent(html_8319cc6068c5cc4a2b9dce79092b95f8);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_ce7bc67f4a016016315e85da42cb7bff.bindPopup(popup_0d24f73d41b199d1eae329d38761b9d1)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_eed9ed3fb79f4ed4f9ed846d5285523f = L.marker(\n",
              "                [46.4664328, 6.8349919],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_e46a6361e3c72e0f68e30db96deb1922 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_f726874813232a1335f895f699667fdf = $(`&lt;div id=&quot;html_f726874813232a1335f895f699667fdf&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CHCHE105909036&lt;br&gt;Address: AVENUE NESTLE 55&lt;br&gt;Postcode: 1800&lt;br&gt;City: VEVEY&lt;/div&gt;`)[0];\n",
              "                popup_e46a6361e3c72e0f68e30db96deb1922.setContent(html_f726874813232a1335f895f699667fdf);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_eed9ed3fb79f4ed4f9ed846d5285523f.bindPopup(popup_e46a6361e3c72e0f68e30db96deb1922)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_65fb3d8fb5b048b6a84a9e1ac104cf3f = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_3c2e58e8f9de9bc87869b5a081ca1388 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_f51a388a6a57c90b815b78584ab4a94e = $(`&lt;div id=&quot;html_f51a388a6a57c90b815b78584ab4a94e&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9360002629&lt;br&gt;Address: SHI XI CHENG QU XI CHANG AN JIE 86HAO&lt;br&gt;Postcode: nan&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_3c2e58e8f9de9bc87869b5a081ca1388.setContent(html_f51a388a6a57c90b815b78584ab4a94e);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_65fb3d8fb5b048b6a84a9e1ac104cf3f.bindPopup(popup_3c2e58e8f9de9bc87869b5a081ca1388)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_c4eefb09fb256de5dba3e3af99f3f3e6 = L.marker(\n",
              "                [39.9550947, -75.170895],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_b500f8139debcbbf6ee7701227ee6dba = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_3bc44eed202e3eea78c0da4fec7d0c62 = $(`&lt;div id=&quot;html_3bc44eed202e3eea78c0da4fec7d0c62&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US270000798&lt;br&gt;Address: 1, COMCAST CENTER&lt;br&gt;Postcode: 19103&lt;br&gt;City: PHILADELPHIA&lt;/div&gt;`)[0];\n",
              "                popup_b500f8139debcbbf6ee7701227ee6dba.setContent(html_3bc44eed202e3eea78c0da4fec7d0c62);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_c4eefb09fb256de5dba3e3af99f3f3e6.bindPopup(popup_b500f8139debcbbf6ee7701227ee6dba)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_26d56c42fb9ac330090549f4eca8bca9 = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_7209a5db70ecd25a0a6f4be5daba66b1 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_213a4ed5ba35272ee3e665054a994021 = $(`&lt;div id=&quot;html_213a4ed5ba35272ee3e665054a994021&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CNFEI1013684&lt;br&gt;Address: CHINA LIFE CENTER, 22-28TH FLOOR&lt;br&gt;Postcode: 100140&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_7209a5db70ecd25a0a6f4be5daba66b1.setContent(html_213a4ed5ba35272ee3e665054a994021);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_26d56c42fb9ac330090549f4eca8bca9.bindPopup(popup_7209a5db70ecd25a0a6f4be5daba66b1)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_75382d6354969b5dc99b60677182d300 = L.marker(\n",
              "                [35.2274294, -80.8422014],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_a1f74544ef73ded816bd7dc90d2b71cd = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_84ee5214dbf895c4cbcd77b55615b130 = $(`&lt;div id=&quot;html_84ee5214dbf895c4cbcd77b55615b130&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US560906609&lt;br&gt;Address: 100 NORTH TRYON STREET&lt;br&gt;Postcode: 28255&lt;br&gt;City: CHARLOTTE, NC&lt;/div&gt;`)[0];\n",
              "                popup_a1f74544ef73ded816bd7dc90d2b71cd.setContent(html_84ee5214dbf895c4cbcd77b55615b130);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_75382d6354969b5dc99b60677182d300.bindPopup(popup_a1f74544ef73ded816bd7dc90d2b71cd)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_398ccf350c2123faefa789c72ab3780b = L.marker(\n",
              "                [40.1411401, -82.9962413],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_989f9dc5c6dbecaf034997498bfebb3f = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_a61ac9d1a99dd22f24142daf6e990b89 = $(`&lt;div id=&quot;html_a61ac9d1a99dd22f24142daf6e990b89&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US134994650&lt;br&gt;Address: 1111 POLARIS PARKWAY&lt;br&gt;Postcode: 43240&lt;br&gt;City: COLUMBUS, OH&lt;/div&gt;`)[0];\n",
              "                popup_989f9dc5c6dbecaf034997498bfebb3f.setContent(html_a61ac9d1a99dd22f24142daf6e990b89);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_398ccf350c2123faefa789c72ab3780b.bindPopup(popup_989f9dc5c6dbecaf034997498bfebb3f)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_47e2eac9696c2c2d1ba12abde2c7a187 = L.marker(\n",
              "                [48.7944, 9.0492],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_e024d050fb7a8166f0b6c8012878da01 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_ccc91549962abeeed810159007ab6b70 = $(`&lt;div id=&quot;html_ccc91549962abeeed810159007ab6b70&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: DE7330000658&lt;br&gt;Address: ROBERT-BOSCH-PLATZ 1&lt;br&gt;Postcode: 70839&lt;br&gt;City: GERLINGEN-SCHILLERHOHE&lt;/div&gt;`)[0];\n",
              "                popup_e024d050fb7a8166f0b6c8012878da01.setContent(html_ccc91549962abeeed810159007ab6b70);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_47e2eac9696c2c2d1ba12abde2c7a187.bindPopup(popup_e024d050fb7a8166f0b6c8012878da01)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_1ab230c4c5d3dded3fa0775eb4a8f988 = L.marker(\n",
              "                [37.5710156, 127.005044],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_4eac9db97c24e6d26bbb96dd0feac911 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_56c126630e13dbfe21b321093f3c8354 = $(`&lt;div id=&quot;html_56c126630e13dbfe21b321093f3c8354&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: KR1101110769583&lt;br&gt;Address: 26, JONG-RO&lt;br&gt;Postcode: nan&lt;br&gt;City: SEOUL&lt;/div&gt;`)[0];\n",
              "                popup_4eac9db97c24e6d26bbb96dd0feac911.setContent(html_56c126630e13dbfe21b321093f3c8354);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_1ab230c4c5d3dded3fa0775eb4a8f988.bindPopup(popup_4eac9db97c24e6d26bbb96dd0feac911)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_57ab17d981261a3efc0edf28988fd959 = L.marker(\n",
              "                [-22.25, -42.5],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_907b61ede62d26fda984241e74c2ed84 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_5b6da6fd238ecf72099814e096218313 = $(`&lt;div id=&quot;html_5b6da6fd238ecf72099814e096218313&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: BR33000167000101&lt;br&gt;Address: 24TH FLOOR&lt;br&gt;Postcode: 20031-912&lt;br&gt;City: RIO DE JANEIRO&lt;/div&gt;`)[0];\n",
              "                popup_907b61ede62d26fda984241e74c2ed84.setContent(html_5b6da6fd238ecf72099814e096218313);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_57ab17d981261a3efc0edf28988fd959.bindPopup(popup_907b61ede62d26fda984241e74c2ed84)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_b9d6d74a7004eb83e94a2189e67b22a3 = L.marker(\n",
              "                [30.4839675, -97.6660801],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_f2347ef3f16411f289f8f8a14c23f612 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_643446d59e1903f3a576b8264b2c0030 = $(`&lt;div id=&quot;html_643446d59e1903f3a576b8264b2c0030&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US800890963&lt;br&gt;Address: 1, DELL WAY&lt;br&gt;Postcode: 78682&lt;br&gt;City: ROUND ROCK&lt;/div&gt;`)[0];\n",
              "                popup_f2347ef3f16411f289f8f8a14c23f612.setContent(html_643446d59e1903f3a576b8264b2c0030);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_b9d6d74a7004eb83e94a2189e67b22a3.bindPopup(popup_f2347ef3f16411f289f8f8a14c23f612)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_39c23f462bb0ac72cad580081ef0f269 = L.marker(\n",
              "                [35.6869, 139.765],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_498c97c40f1aafcf74ad2c2547ad01f1 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_2cee5494e0c1e50af5d0e475a8807b48 = $(`&lt;div id=&quot;html_2cee5494e0c1e50af5d0e475a8807b48&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP4010001133876&lt;br&gt;Address: 1-2, OTE-MACHI 1-CHOME&lt;br&gt;Postcode: 100-0004&lt;br&gt;City: CHIYODA-KU&lt;/div&gt;`)[0];\n",
              "                popup_498c97c40f1aafcf74ad2c2547ad01f1.setContent(html_2cee5494e0c1e50af5d0e475a8807b48);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_39c23f462bb0ac72cad580081ef0f269.bindPopup(popup_498c97c40f1aafcf74ad2c2547ad01f1)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_4b5c58d4249cc1c87976db6c4c464ea8 = L.marker(\n",
              "                [48.8268582, 2.2382005],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_e3ce36942419cb2c56a48e82fe48a2d0 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_f381f7c0339e62f1ccfc77b425872886 = $(`&lt;div id=&quot;html_f381f7c0339e62f1ccfc77b425872886&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: FR652014051&lt;br&gt;Address: 33, AVENUE EMILE ZOLA&lt;br&gt;Postcode: 92100&lt;br&gt;City: BOULOGNE-BILLANCOURT&lt;/div&gt;`)[0];\n",
              "                popup_e3ce36942419cb2c56a48e82fe48a2d0.setContent(html_f381f7c0339e62f1ccfc77b425872886);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_4b5c58d4249cc1c87976db6c4c464ea8.bindPopup(popup_e3ce36942419cb2c56a48e82fe48a2d0)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_e895d06728d0104b80bdfd775b1a9df5 = L.marker(\n",
              "                [48.1545311, 11.5885612],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_d1d0c43b9efb8a2c20b1bd178f7c1984 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_d7df753e3aaa5c1930d64e563ffd1504 = $(`&lt;div id=&quot;html_d7df753e3aaa5c1930d64e563ffd1504&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: DEFEI1007380&lt;br&gt;Address: KONIGINSTRASSE 28&lt;br&gt;Postcode: 80802&lt;br&gt;City: MUNCHEN&lt;/div&gt;`)[0];\n",
              "                popup_d1d0c43b9efb8a2c20b1bd178f7c1984.setContent(html_d7df753e3aaa5c1930d64e563ffd1504);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_e895d06728d0104b80bdfd775b1a9df5.bindPopup(popup_d1d0c43b9efb8a2c20b1bd178f7c1984)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_9285573517d523324cdfc7d1595b05e4 = L.marker(\n",
              "                [41.8271833, 12.4716613],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_409be55b1b307f70c4079c0e2a0ae99c = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_084631045d35ce25407482d62bb2cae0 = $(`&lt;div id=&quot;html_084631045d35ce25407482d62bb2cae0&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: IT00484960588&lt;br&gt;Address: PIAZZALE ENRICO MATTEI 1&lt;br&gt;Postcode: 00144&lt;br&gt;City: ROMA&lt;/div&gt;`)[0];\n",
              "                popup_409be55b1b307f70c4079c0e2a0ae99c.setContent(html_084631045d35ce25407482d62bb2cae0);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_9285573517d523324cdfc7d1595b05e4.bindPopup(popup_409be55b1b307f70c4079c0e2a0ae99c)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_6cdb897bc1519d36736eefd76fbe3569 = L.marker(\n",
              "                [50.7084796, 7.126853],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c7d5fed0188987d3ef57292e18d43965 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_7942c4375957840d7ca05f49a9a528c1 = $(`&lt;div id=&quot;html_7942c4375957840d7ca05f49a9a528c1&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: DE5030147137&lt;br&gt;Address: FRIEDRICH-EBERT-ALLEE 140&lt;br&gt;Postcode: 53113&lt;br&gt;City: BONN&lt;/div&gt;`)[0];\n",
              "                popup_c7d5fed0188987d3ef57292e18d43965.setContent(html_7942c4375957840d7ca05f49a9a528c1);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_6cdb897bc1519d36736eefd76fbe3569.bindPopup(popup_c7d5fed0188987d3ef57292e18d43965)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_16675083061e41bb4e37ba5e63b939c4 = L.marker(\n",
              "                [35.6895, 139.69171],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_0bfbece10b2cadf6abba4ee8adfb056e = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_19eca7c125078a350ff16fbaa9d564cd = $(`&lt;div id=&quot;html_19eca7c125078a350ff16fbaa9d564cd&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP7010001008844&lt;br&gt;Address: NIHON SEIMEI MARUNOUCHI BUILDING&lt;br&gt;Postcode: 100-8280&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_0bfbece10b2cadf6abba4ee8adfb056e.setContent(html_19eca7c125078a350ff16fbaa9d564cd);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_16675083061e41bb4e37ba5e63b939c4.bindPopup(popup_0bfbece10b2cadf6abba4ee8adfb056e)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_057b84c56d5578140aa88288011d85f4 = L.marker(\n",
              "                [48.8763892, 2.2969276],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_f3424e5d25d3959d40401ebd5e50fc6a = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c234ea5c50bb49645ef0663dd52bd88a = $(`&lt;div id=&quot;html_c234ea5c50bb49645ef0663dd52bd88a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: FR552081317&lt;br&gt;Address: 22-30, AVENUE DE WAGRAM&lt;br&gt;Postcode: 75382&lt;br&gt;City: PARIS&lt;/div&gt;`)[0];\n",
              "                popup_f3424e5d25d3959d40401ebd5e50fc6a.setContent(html_c234ea5c50bb49645ef0663dd52bd88a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_057b84c56d5578140aa88288011d85f4.bindPopup(popup_f3424e5d25d3959d40401ebd5e50fc6a)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_cce52dc0b10d44925ab8fefa7766f46e = L.marker(\n",
              "                [37.465272, 127.1006424],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c00155a01e16ea353ec34142bea9bea3 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_a91664d59f58de7840d5ef3df9b40b25 = $(`&lt;div id=&quot;html_a91664d59f58de7840d5ef3df9b40b25&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: KR1101110085450&lt;br&gt;Address: 12, HEOLLEUNG-RO&lt;br&gt;Postcode: nan&lt;br&gt;City: SEOUL&lt;/div&gt;`)[0];\n",
              "                popup_c00155a01e16ea353ec34142bea9bea3.setContent(html_a91664d59f58de7840d5ef3df9b40b25);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_cce52dc0b10d44925ab8fefa7766f46e.bindPopup(popup_c00155a01e16ea353ec34142bea9bea3)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_790d480f7b6b952389f818a99808d3cd = L.marker(\n",
              "                [37.7931258, -122.4027178],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_7b61afc11c67151a6487cbac8c9c5f0c = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_7fd8c841040b1dab0fbb93bb1cfa8fec = $(`&lt;div id=&quot;html_7fd8c841040b1dab0fbb93bb1cfa8fec&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US410449260&lt;br&gt;Address: 420 MONTGOMERY STREET&lt;br&gt;Postcode: 94104&lt;br&gt;City: SAN FRANCISCO, CA&lt;/div&gt;`)[0];\n",
              "                popup_7b61afc11c67151a6487cbac8c9c5f0c.setContent(html_7fd8c841040b1dab0fbb93bb1cfa8fec);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_790d480f7b6b952389f818a99808d3cd.bindPopup(popup_7b61afc11c67151a6487cbac8c9c5f0c)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_7d8453d494b2564377f9b83eaf5b1798 = L.marker(\n",
              "                [35.65, 139.73333],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_4a47c7a70ca2b0c3c2d9f8896e9af14e = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_d85256cb82ea6edf45fc07c9840e74ab = $(`&lt;div id=&quot;html_d85256cb82ea6edf45fc07c9840e74ab&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP1010401056795&lt;br&gt;Address: 1-9-1, HIGASHI-SHIMBASHI, MINATO-KU&lt;br&gt;Postcode: 105-7303&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_4a47c7a70ca2b0c3c2d9f8896e9af14e.setContent(html_d85256cb82ea6edf45fc07c9840e74ab);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_7d8453d494b2564377f9b83eaf5b1798.bindPopup(popup_4a47c7a70ca2b0c3c2d9f8896e9af14e)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_dd7bbd72a36131b4b63c9eff006b7fed = L.marker(\n",
              "                [41.9146177, 12.5046393],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_036728721dabcaaf6c5d80c51eac4c01 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c0b1283e4f9d53d2ae9b256f4b785e28 = $(`&lt;div id=&quot;html_c0b1283e4f9d53d2ae9b256f4b785e28&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: IT00811720580&lt;br&gt;Address: VIALE REGINA MARGHERITA 137&lt;br&gt;Postcode: 00198&lt;br&gt;City: ROMA&lt;/div&gt;`)[0];\n",
              "                popup_036728721dabcaaf6c5d80c51eac4c01.setContent(html_c0b1283e4f9d53d2ae9b256f4b785e28);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_dd7bbd72a36131b4b63c9eff006b7fed.bindPopup(popup_036728721dabcaaf6c5d80c51eac4c01)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_607a2015fef7680c257aa4e838c5eac2 = L.marker(\n",
              "                [22.5205401, 113.9272104],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_d816f2532c67c0734776a3f7a1d47d78 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_0041132e858a78015f3ada5623acf0c4 = $(`&lt;div id=&quot;html_0041132e858a78015f3ada5623acf0c4&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9360902152&lt;br&gt;Address: NO. 3001, BINHAI AVENUE&lt;br&gt;Postcode: 518000&lt;br&gt;City: SHENZHEN&lt;/div&gt;`)[0];\n",
              "                popup_d816f2532c67c0734776a3f7a1d47d78.setContent(html_0041132e858a78015f3ada5623acf0c4);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_607a2015fef7680c257aa4e838c5eac2.bindPopup(popup_d816f2532c67c0734776a3f7a1d47d78)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_a617b4f954b59e6699c40332bbe66189 = L.marker(\n",
              "                [39.7631664, -86.1508708],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_0674b10438d632e3a334bb006ff23b1b = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c3b7e4deee8dc7f1f5093f252ac8a8d9 = $(`&lt;div id=&quot;html_c3b7e4deee8dc7f1f5093f252ac8a8d9&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US352145715&lt;br&gt;Address: 220 VIRGINIA AVENUE&lt;br&gt;Postcode: 46204&lt;br&gt;City: INDIANAPOLIS&lt;/div&gt;`)[0];\n",
              "                popup_0674b10438d632e3a334bb006ff23b1b.setContent(html_c3b7e4deee8dc7f1f5093f252ac8a8d9);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_a617b4f954b59e6699c40332bbe66189.bindPopup(popup_0674b10438d632e3a334bb006ff23b1b)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_fd5a9d94fa12d5ae4094a5fd01b88da2 = L.marker(\n",
              "                [51.809974, -0.196346],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_92239a614bce2f66a0b23f15ea8b7d04 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_6483edcf358ad54becb00fba8a09c6c6 = $(`&lt;div id=&quot;html_6483edcf358ad54becb00fba8a09c6c6&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: GB00445790&lt;br&gt;Address: SHIRE PARK, TESCO HOUSE&lt;br&gt;Postcode: AL7 1GA&lt;br&gt;City: WELWYN GARDEN CITY&lt;/div&gt;`)[0];\n",
              "                popup_92239a614bce2f66a0b23f15ea8b7d04.setContent(html_6483edcf358ad54becb00fba8a09c6c6);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_fd5a9d94fa12d5ae4094a5fd01b88da2.bindPopup(popup_92239a614bce2f66a0b23f15ea8b7d04)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_aa86818c5f7ed466a6e60dbd99d205a0 = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_6719f58704e6df618b9b4b8813db1af2 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_3f114bb42d1d33c862ab3b6228c941dc = $(`&lt;div id=&quot;html_3f114bb42d1d33c862ab3b6228c941dc&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9367130725&lt;br&gt;Address: NO. 28, FUXINGMEN INNER STREET&lt;br&gt;Postcode: 100031&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_6719f58704e6df618b9b4b8813db1af2.setContent(html_3f114bb42d1d33c862ab3b6228c941dc);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_aa86818c5f7ed466a6e60dbd99d205a0.bindPopup(popup_6719f58704e6df618b9b4b8813db1af2)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_9eb4c42675a257f3c66335546ee6f943 = L.marker(\n",
              "                [48.8919583, 2.174073],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_f5df48da38f790d581fc149c8260d6e4 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_71b03fcb9882726234e4c5d54685f550 = $(`&lt;div id=&quot;html_71b03fcb9882726234e4c5d54685f550&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: FR552100554&lt;br&gt;Address: 7, RUE HENRI SAINTE-CLAIRE DEVILLE&lt;br&gt;Postcode: 92500&lt;br&gt;City: RUEIL-MALMAISON&lt;/div&gt;`)[0];\n",
              "                popup_f5df48da38f790d581fc149c8260d6e4.setContent(html_71b03fcb9882726234e4c5d54685f550);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_9eb4c42675a257f3c66335546ee6f943.bindPopup(popup_f5df48da38f790d581fc149c8260d6e4)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_02c000540fbcf710fb5854b6748e2fa9 = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_7602d3ba4e4970f607ebf1b497c95d02 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_0d339e7b00e4e922563ef049a94e386d = $(`&lt;div id=&quot;html_0d339e7b00e4e922563ef049a94e386d&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9360658507&lt;br&gt;Address: NO. 85, DESHENGMEN OUTER STREET&lt;br&gt;Postcode: 100088&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_7602d3ba4e4970f607ebf1b497c95d02.setContent(html_0d339e7b00e4e922563ef049a94e386d);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_02c000540fbcf710fb5854b6748e2fa9.bindPopup(popup_7602d3ba4e4970f607ebf1b497c95d02)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_3da2924dd9390476167414d0d030c583 = L.marker(\n",
              "                [51.5038502, -0.1167734],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_9dcc68fd4317b3c3452cc6cb26caa50a = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_ed7fd1d461c725776b606090b570aa65 = $(`&lt;div id=&quot;html_ed7fd1d461c725776b606090b570aa65&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: GB03634752&lt;br&gt;Address: SHELL CENTRE&lt;br&gt;Postcode: SE1 7NA&lt;br&gt;City: LONDON&lt;/div&gt;`)[0];\n",
              "                popup_9dcc68fd4317b3c3452cc6cb26caa50a.setContent(html_ed7fd1d461c725776b606090b570aa65);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_3da2924dd9390476167414d0d030c583.bindPopup(popup_9dcc68fd4317b3c3452cc6cb26caa50a)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_68d7e3e3d8fe0981bb15f159a956b91b = L.marker(\n",
              "                [19.07283, 72.88261],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_9a0a7e362aa1376382a3e3353d0a8247 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c0d75bcee117ba5f0225e838fa606299 = $(`&lt;div id=&quot;html_c0d75bcee117ba5f0225e838fa606299&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: IN30074FI&lt;br&gt;Address: MAKERS CHAMBERS IV, 3RD FLOOR&lt;br&gt;Postcode: 400 021&lt;br&gt;City: MUMBAI&lt;/div&gt;`)[0];\n",
              "                popup_9a0a7e362aa1376382a3e3353d0a8247.setContent(html_c0d75bcee117ba5f0225e838fa606299);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_68d7e3e3d8fe0981bb15f159a956b91b.bindPopup(popup_9a0a7e362aa1376382a3e3353d0a8247)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_2a0d9bef414001c5a6f798277e3d418d = L.marker(\n",
              "                [39.9075, 116.39723],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_544361d187139f00896e68915adf29e0 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_5ebca30796b93aa8ce1288b36d3ee0a5 = $(`&lt;div id=&quot;html_5ebca30796b93aa8ce1288b36d3ee0a5&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN9360812774&lt;br&gt;Address: NO. A3, FINANCE AVENUE&lt;br&gt;Postcode: 100808&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_544361d187139f00896e68915adf29e0.setContent(html_5ebca30796b93aa8ce1288b36d3ee0a5);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_2a0d9bef414001c5a6f798277e3d418d.bindPopup(popup_544361d187139f00896e68915adf29e0)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_e7896c29320ab330fb82941b620104dc = L.marker(\n",
              "                [40.498436, -74.4417003],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_e92946e04704b55ae014104c50ddafc2 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c80968a8f1c742956e42be3997a7150f = $(`&lt;div id=&quot;html_c80968a8f1c742956e42be3997a7150f&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US221024240&lt;br&gt;Address: JOHNSON &amp; JOHNSON PLAZA&lt;br&gt;Postcode: 08933&lt;br&gt;City: NEW BRUNSWICK&lt;/div&gt;`)[0];\n",
              "                popup_e92946e04704b55ae014104c50ddafc2.setContent(html_c80968a8f1c742956e42be3997a7150f);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_e7896c29320ab330fb82941b620104dc.bindPopup(popup_e92946e04704b55ae014104c50ddafc2)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_2d34db1c89afe49d3341f10eac662027 = L.marker(\n",
              "                [51.507659, -0.143003],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_3de54d1ec025d6eac1ffce5769881ae6 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_e02f62aaadd8d8d9a4bd549e755e793a = $(`&lt;div id=&quot;html_e02f62aaadd8d8d9a4bd549e755e793a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: GB04542769&lt;br&gt;Address: 50 BERKELEY STREET&lt;br&gt;Postcode: W1J 8HD&lt;br&gt;City: LONDON&lt;/div&gt;`)[0];\n",
              "                popup_3de54d1ec025d6eac1ffce5769881ae6.setContent(html_e02f62aaadd8d8d9a4bd549e755e793a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_2d34db1c89afe49d3341f10eac662027.bindPopup(popup_3de54d1ec025d6eac1ffce5769881ae6)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_d109bc0d7704781c08924d377b2db75f = L.marker(\n",
              "                [1.28967, 103.85007],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_00ed6bc1f18272333d90fea816846c7a = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c81abc74dad1a0f38111b86e67661119 = $(`&lt;div id=&quot;html_c81abc74dad1a0f38111b86e67661119&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: SG198903166R&lt;br&gt;Address: 7 ANG MO KIO STREET 64&lt;br&gt;Postcode: 569086&lt;br&gt;City: SINGAPORE&lt;/div&gt;`)[0];\n",
              "                popup_00ed6bc1f18272333d90fea816846c7a.setContent(html_c81abc74dad1a0f38111b86e67661119);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_d109bc0d7704781c08924d377b2db75f.bindPopup(popup_00ed6bc1f18272333d90fea816846c7a)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_774b5838c3b96d8b9d10a20eb2876f73 = L.marker(\n",
              "                [39.9337739, 116.4282174],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_aaae1d60c275afabbdd11947a81155d2 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_c922c1b8dd1bc868307d13f1210753f0 = $(`&lt;div id=&quot;html_c922c1b8dd1bc868307d13f1210753f0&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: CN30081PC&lt;br&gt;Address: NO. 9, DONGZHIMEN NORTH STREET&lt;br&gt;Postcode: 100011&lt;br&gt;City: BEIJING&lt;/div&gt;`)[0];\n",
              "                popup_aaae1d60c275afabbdd11947a81155d2.setContent(html_c922c1b8dd1bc868307d13f1210753f0);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_774b5838c3b96d8b9d10a20eb2876f73.bindPopup(popup_aaae1d60c275afabbdd11947a81155d2)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_8360d2d1f02f462ee5c9cb17e1498ca4 = L.marker(\n",
              "                [58.8928159, 5.7191106],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_33013baaa60d1c3041f5b4b4701b0d09 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_bc9a0873e31df63b85ea9dbf6ad0058e = $(`&lt;div id=&quot;html_bc9a0873e31df63b85ea9dbf6ad0058e&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: NO923609016&lt;br&gt;Address: FORUSBEEN 50&lt;br&gt;Postcode: 4035&lt;br&gt;City: STAVANGER&lt;/div&gt;`)[0];\n",
              "                popup_33013baaa60d1c3041f5b4b4701b0d09.setContent(html_bc9a0873e31df63b85ea9dbf6ad0058e);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_8360d2d1f02f462ee5c9cb17e1498ca4.bindPopup(popup_33013baaa60d1c3041f5b4b4701b0d09)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_e55aae463498d8c3d40fc5d69109b4ef = L.marker(\n",
              "                [41.1134016, -73.720356],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_23eadf06a1b7560e5ebe180c0c6c5d40 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_ab1618606c7268725af61569c9d1e62a = $(`&lt;div id=&quot;html_ab1618606c7268725af61569c9d1e62a&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: US130871985&lt;br&gt;Address: 1, NEW ORCHARD ROAD&lt;br&gt;Postcode: 10504&lt;br&gt;City: ARMONK&lt;/div&gt;`)[0];\n",
              "                popup_23eadf06a1b7560e5ebe180c0c6c5d40.setContent(html_ab1618606c7268725af61569c9d1e62a);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_e55aae463498d8c3d40fc5d69109b4ef.bindPopup(popup_23eadf06a1b7560e5ebe180c0c6c5d40)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_de0ce95271d090b496bb1efa9bde2054 = L.marker(\n",
              "                [35.6381025, 139.7526987],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_c42e9c421d27e6bfeb788e74045e6000 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_4d19700d1003e392f26e4a4cde1c9ac2 = $(`&lt;div id=&quot;html_4d19700d1003e392f26e4a4cde1c9ac2&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: JP5010401067252&lt;br&gt;Address: 1-7-1, KONAN, MINATO-KU&lt;br&gt;Postcode: 108-0075&lt;br&gt;City: TOKYO&lt;/div&gt;`)[0];\n",
              "                popup_c42e9c421d27e6bfeb788e74045e6000.setContent(html_4d19700d1003e392f26e4a4cde1c9ac2);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_de0ce95271d090b496bb1efa9bde2054.bindPopup(popup_c42e9c421d27e6bfeb788e74045e6000)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "    \n",
              "            var marker_0a126d6f3a50fa75bf60a7f5cf6a975b = L.marker(\n",
              "                [-38.0104982, 145.2724804],\n",
              "                {}\n",
              "            ).addTo(marker_cluster_53c69b2762667771b6b6f36892488014);\n",
              "        \n",
              "    \n",
              "        var popup_273916d3a903fc1db26b4cf9fd10d6d8 = L.popup({&quot;maxWidth&quot;: 300});\n",
              "\n",
              "        \n",
              "            \n",
              "                var html_1740283508b5b95f9657cc2cbb908cec = $(`&lt;div id=&quot;html_1740283508b5b95f9657cc2cbb908cec&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;BvD ID number: AU615894794&lt;br&gt;Address:  124 ABBOTT RD&lt;br&gt;Postcode: 3803&lt;br&gt;City: HALLAM&lt;/div&gt;`)[0];\n",
              "                popup_273916d3a903fc1db26b4cf9fd10d6d8.setContent(html_1740283508b5b95f9657cc2cbb908cec);\n",
              "            \n",
              "        \n",
              "\n",
              "        marker_0a126d6f3a50fa75bf60a7f5cf6a975b.bindPopup(popup_273916d3a903fc1db26b4cf9fd10d6d8)\n",
              "        ;\n",
              "\n",
              "        \n",
              "    \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 79
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Saving the map to an HTML file\n",
        "m.save('company_locations.html')"
      ],
      "metadata": {
        "id": "nrOYZP0WhgbO"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Function to perform reverse geocoding to get postcode and city\n",
        "def reverse_geocode_opencage(lat, lng):\n",
        "    try:\n",
        "        result = geocoder.reverse_geocode(lat, lng, no_annotations=\"1\")\n",
        "        if result and len(result):\n",
        "            # Extracting postcode and city from the result\n",
        "            components = result[0]['components']\n",
        "            postcode = components.get('postcode', '').strip()\n",
        "            city = components.get('city', components.get('town', '')).strip()\n",
        "            # Return the combined postcode and city only if both are present\n",
        "            if postcode and city:\n",
        "                return f\"{postcode}, {city}\"\n",
        "        return None\n",
        "    except Exception as e:\n",
        "        print(f\"Error: {e}\")\n",
        "        return None\n",
        "\n",
        "# Applying reverse geocoding for rows with successful geolocation\n",
        "for index, row in df_clean.iterrows():\n",
        "    if row['Status'] == \"Success\":\n",
        "        combined_value = reverse_geocode_opencage(row['Latitude'], row['Longitude'])\n",
        "        if combined_value:  # Check if the combined value is not None\n",
        "            df_clean.at[index, 'Postcode_City'] = combined_value\n",
        "        else:\n",
        "            df_clean.at[index, 'Postcode_City'] = \"Incomplete Data\"  # or keep it as None\n",
        "\n",
        "df_clean.head()  # Displaying the first few rows of the updated DataFrame\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 504
        },
        "id": "8n4X1kklc0qj",
        "outputId": "cd4ea3e8-0d63-4ede-f9c5-bca35dab9d64"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-81-e4183c298b64>:23: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  df_clean.at[index, 'Postcode_City'] = combined_value\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     Company name Latin alphabet_x BvD ID number  \\\n",
              "0  JOINT-STOCK COMPANY VTB CAPITAL    RU94102445   \n",
              "1                     WALMART INC.   US710415188   \n",
              "2            ROYAL DUTCH SHELL PLC    GB04366849   \n",
              "3        SAUDI ARABIAN OIL COMPANY     SA30947GS   \n",
              "4                           BP PLC    GB00102498   \n",
              "\n",
              "                  Address line 1\\nLatin Alphabet Postcode\\nLatin Alphabet  \\\n",
              "0  NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA                   123100   \n",
              "1                     702, SOUTH WEST 8TH STREET                    72716   \n",
              "2                                   SHELL CENTRE                  SE1 7NA   \n",
              "3                                 P.O. BOX: 5000                    31311   \n",
              "4                        1, SAINT JAMES'S SQUARE                 SW1Y 4PD   \n",
              "\n",
              "  City\\nLatin Alphabet                   Country Country ISO code  \\\n",
              "0               MOSCOW        Russian Federation               RU   \n",
              "1          BENTONVILLE  United States of America               US   \n",
              "2               LONDON            United Kingdom               GB   \n",
              "3              DHAHRAN              Saudi Arabia               SA   \n",
              "4               LONDON            United Kingdom               GB   \n",
              "\n",
              "                             GUO - Name GUO - BvD ID number  \\\n",
              "0  GOVERNMENT OF THE RUSSIAN FEDERATION          RU00031093   \n",
              "1                         WALTON FAMILY        WW*901466840   \n",
              "2                 ROYAL DUTCH SHELL PLC          GB04366849   \n",
              "3           THE KINGDOM OF SAUDI ARABIA        SA0000114597   \n",
              "4                                BP PLC          GB00102498   \n",
              "\n",
              "  GUO - Country ISO code   Latitude  Longitude   Status  \\\n",
              "0                     RU  55.752220  37.615560  Success   \n",
              "1                   n.a.  36.299500 -93.956800  Success   \n",
              "2                     GB  51.503850  -0.116773  Success   \n",
              "3                     SA  26.288640  50.113960  Success   \n",
              "4                     GB  51.507732  -0.134570  Success   \n",
              "\n",
              "             Postcode_City  \n",
              "0           115035, Moscow  \n",
              "1          Incomplete Data  \n",
              "2          SE1 7NA, London  \n",
              "3  34453, Dhahran Compound  \n",
              "4         SW1Y 4AL, London  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f138a4cc-c384-40d9-adbf-9a86504dfbdd\" class=\"colab-df-container\">\n",
              "    <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>Company name Latin alphabet_x</th>\n",
              "      <th>BvD ID number</th>\n",
              "      <th>Address line 1\\nLatin Alphabet</th>\n",
              "      <th>Postcode\\nLatin Alphabet</th>\n",
              "      <th>City\\nLatin Alphabet</th>\n",
              "      <th>Country</th>\n",
              "      <th>Country ISO code</th>\n",
              "      <th>GUO - Name</th>\n",
              "      <th>GUO - BvD ID number</th>\n",
              "      <th>GUO - Country ISO code</th>\n",
              "      <th>Latitude</th>\n",
              "      <th>Longitude</th>\n",
              "      <th>Status</th>\n",
              "      <th>Postcode_City</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>JOINT-STOCK COMPANY VTB CAPITAL</td>\n",
              "      <td>RU94102445</td>\n",
              "      <td>NAB. PRESNENSKAYA D. 12, BASHNYA \"FEDERATSIYA</td>\n",
              "      <td>123100</td>\n",
              "      <td>MOSCOW</td>\n",
              "      <td>Russian Federation</td>\n",
              "      <td>RU</td>\n",
              "      <td>GOVERNMENT OF THE RUSSIAN FEDERATION</td>\n",
              "      <td>RU00031093</td>\n",
              "      <td>RU</td>\n",
              "      <td>55.752220</td>\n",
              "      <td>37.615560</td>\n",
              "      <td>Success</td>\n",
              "      <td>115035, Moscow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>WALMART INC.</td>\n",
              "      <td>US710415188</td>\n",
              "      <td>702, SOUTH WEST 8TH STREET</td>\n",
              "      <td>72716</td>\n",
              "      <td>BENTONVILLE</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>US</td>\n",
              "      <td>WALTON FAMILY</td>\n",
              "      <td>WW*901466840</td>\n",
              "      <td>n.a.</td>\n",
              "      <td>36.299500</td>\n",
              "      <td>-93.956800</td>\n",
              "      <td>Success</td>\n",
              "      <td>Incomplete Data</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>SHELL CENTRE</td>\n",
              "      <td>SE1 7NA</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>ROYAL DUTCH SHELL PLC</td>\n",
              "      <td>GB04366849</td>\n",
              "      <td>GB</td>\n",
              "      <td>51.503850</td>\n",
              "      <td>-0.116773</td>\n",
              "      <td>Success</td>\n",
              "      <td>SE1 7NA, London</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SAUDI ARABIAN OIL COMPANY</td>\n",
              "      <td>SA30947GS</td>\n",
              "      <td>P.O. BOX: 5000</td>\n",
              "      <td>31311</td>\n",
              "      <td>DHAHRAN</td>\n",
              "      <td>Saudi Arabia</td>\n",
              "      <td>SA</td>\n",
              "      <td>THE KINGDOM OF SAUDI ARABIA</td>\n",
              "      <td>SA0000114597</td>\n",
              "      <td>SA</td>\n",
              "      <td>26.288640</td>\n",
              "      <td>50.113960</td>\n",
              "      <td>Success</td>\n",
              "      <td>34453, Dhahran Compound</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>1, SAINT JAMES'S SQUARE</td>\n",
              "      <td>SW1Y 4PD</td>\n",
              "      <td>LONDON</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>GB</td>\n",
              "      <td>BP PLC</td>\n",
              "      <td>GB00102498</td>\n",
              "      <td>GB</td>\n",
              "      <td>51.507732</td>\n",
              "      <td>-0.134570</td>\n",
              "      <td>Success</td>\n",
              "      <td>SW1Y 4AL, London</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f138a4cc-c384-40d9-adbf-9a86504dfbdd')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-f138a4cc-c384-40d9-adbf-9a86504dfbdd button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-f138a4cc-c384-40d9-adbf-9a86504dfbdd');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-654d312f-401a-4b56-bdc2-5a15443cb780\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-654d312f-401a-4b56-bdc2-5a15443cb780')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-654d312f-401a-4b56-bdc2-5a15443cb780 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 81
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# printing out the Postcode_City column\n",
        "df_clean[\"Postcode_City\"]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1soPZPhfd4dA",
        "outputId": "e46598f7-288c-4962-f91d-1b2255296165"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0                 115035, Moscow\n",
              "1                Incomplete Data\n",
              "2                SE1 7NA, London\n",
              "3        34453, Dhahran Compound\n",
              "4               SW1Y 4AL, London\n",
              "                 ...            \n",
              "95    100010, Dongcheng District\n",
              "96               4035, Stavanger\n",
              "97               Incomplete Data\n",
              "98              108-0022, Minato\n",
              "99               3803, Melbourne\n",
              "Name: Postcode_City, Length: 100, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 82
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#counting the proportion of missing data in the first 100 rows of the dataset\n",
        "\n",
        "no_result_count = df_clean.head(100)[df_clean['Status'] == 'No result found'].shape[0]\n",
        "proportion_missing = no_result_count / 100\n",
        "\n",
        "# Printing the result\n",
        "print(f\"Number of rows with 'No result found' in the first 100 rows: {no_result_count}\")\n",
        "print(f\"Proportion of missing data in the first 100 rows: {proportion_missing * 100}%\")\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_UGi32FEmtlS",
        "outputId": "e7d6e970-85b9-4f84-da32-d7c9b5f532aa"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Number of rows with 'No result found' in the first 100 rows: 3\n",
            "Proportion of missing data in the first 100 rows: 3.0%\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_clean.to_csv('Final.csv')"
      ],
      "metadata": {
        "id": "xULuBeR7lzW2"
      },
      "execution_count": null,
      "outputs": []
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}