scrape_company_info.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "DK6TqHyj7_UU",
        "outputId": "e2fa1f07-946d-4306-dc63-e34ae07fc819"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\fuzzywuzzy\\fuzz.py:11: UserWarning: Using slow pure-python SequenceMatcher. Install python-Levenshtein to remove this warning\n",
            "  warnings.warn('Using slow pure-python SequenceMatcher. Install python-Levenshtein to remove this warning')\n",
            "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\requests\\__init__.py:89: RequestsDependencyWarning: urllib3 (1.26.14) or chardet (3.0.4) doesn't match a supported version!\n",
            "  warnings.warn(\"urllib3 ({}) or chardet ({}) doesn't match a supported \"\n"
          ]
        }
      ],
      "source": [
        "from fuzzywuzzy import fuzz\n",
        "from fuzzywuzzy import process\n",
        "from urllib.parse import urlparse\n",
        "\n",
        "from bs4 import BeautifulSoup\n",
        "from selenium import webdriver\n",
        "from webdriver_manager.firefox import GeckoDriverManager\n",
        "from selenium.webdriver.common.by import By\n",
        "\n",
        "import time\n",
        "\n",
        "from selenium.webdriver.firefox.options import Options\n",
        "from selenium.webdriver.firefox.firefox_profile import FirefoxProfile"
      ],
      "id": "DK6TqHyj7_UU"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "HmdX16nd7_Uc"
      },
      "outputs": [],
      "source": [
        "class UrlFind:\n",
        "    def __init__(self, search_engine='yahoo'):\n",
        "        self.search_engine=search_engine\n",
        "        self.dict_links={'query':[],'found_link':[]}\n",
        "        self.black_list = list(pd.read_excel('black_list.xlsx')['websites'])\n",
        "\n",
        "        self.count_rel=0\n",
        "        self.count_irr=0\n",
        "        self.links_captured=[]\n",
        "        \n",
        "    def send_query(self,queries: list):\n",
        "        for query in queries:\n",
        "            self.dict_links['query'].append(query)\n",
        "            self.dict_links['found_link'].append('0')\n",
        "            \n",
        "            self.find_links(query)\n",
        "            \n",
        "    def send_one_query(self, query:str):\n",
        "        self.dict_links['query'].append(query)\n",
        "        self.dict_links['found_link'].append('0')    \n",
        "        self.find_links(query)\n",
        "        return self.dict_links['found_link']\n",
        "\n",
        "    def find_links(self,query: str):\n",
        "#         print(f'=======query = {query}=======')\n",
        "        query_index = len(self.dict_links['found_link'])\n",
        "        url=''\n",
        "        if self.search_engine=='yahoo':\n",
        "            url = \"https://nl.search.yahoo.com/search?p=\" + query # + \"&start=\" +      str((page - 1) * 10)\n",
        "        else:\n",
        "            url='https://www.google.com/search?q='+query\n",
        "        driver.get(url)\n",
        "        try:\n",
        "            driver.find_element(By.NAME, \"agree\").click()\n",
        "        except:\n",
        "            pass\n",
        "        \n",
        "        time.sleep(5)\n",
        "        soup = BeautifulSoup(driver.page_source, 'html.parser')\n",
        "        search_list=[]\n",
        "        search_list = soup.find_all('div', class_=\"compTitle options-toggle\")\n",
        "        \n",
        "        for each in search_list:\n",
        "            link=each.a.get('href')\n",
        "            link=urlparse(link).netloc\n",
        "            flag = self.find_relevant_links(link,query)\n",
        "            if flag == True:\n",
        "                self.dict_links['found_link'][query_index-1] = link\n",
        "                return\n",
        "        \n",
        "  \n",
        "    def find_relevant_links(self,link: str, query: str):\n",
        "        # remove all after .com    \n",
        "        for black_website in self.black_list:\n",
        "            if link.__contains__(black_website):\n",
        "                return False\n",
        "            score = fuzz.partial_ratio(link, black_website)\n",
        "            if score > 80:\n",
        "                return False\n",
        "        return True\n",
        "    \n",
        "   \n",
        "              \n",
        "\n",
        "    "
      ],
      "id": "HmdX16nd7_Uc"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "jqV30_2R7_Ug",
        "outputId": "c862fecb-65a5-4c7e-e9ac-d72f6a311bbf"
      },
      "outputs": [
        {
          "ename": "NameError",
          "evalue": "name 'li' is not defined",
          "output_type": "error",
          "traceback": [
            "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
            "\u001b[1;32m<ipython-input-4-6ee3d818e020>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      2\u001b[0m \u001b[1;31m# saving the blacklist to xlsx.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mpandas\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 4\u001b[1;33m \u001b[0mdf\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mDataFrame\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mli\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      5\u001b[0m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_excel\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'black_list.xlsx'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mFalse\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheader\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'websites'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
            "\u001b[1;31mNameError\u001b[0m: name 'li' is not defined"
          ]
        }
      ],
      "source": [
        "# Dont run it if no change in blacklist\n",
        "# saving the blacklist to xlsx. \n",
        "import pandas as pd\n",
        "df = pd.DataFrame(li)\n",
        "df.to_excel('black_list.xlsx',index=False, header=['websites'])"
      ],
      "id": "jqV30_2R7_Ug"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "SDH9ofmp7_Uk"
      },
      "outputs": [],
      "source": [
        "import numpy as np\n",
        "import re\n",
        "\n",
        "def check_nan(val):\n",
        "    if np.isnan(val):\n",
        "        return ''\n",
        "    else:\n",
        "        return val\n",
        "\n",
        "def clean_text(string):\n",
        "    word = re.sub(r'[^\\w\\s]', ' ', string)\n",
        "    return word.strip()\n",
        "    \n",
        "def make_query(tuples):\n",
        "    name1 = (tuples[2])\n",
        "    name2=(tuples[3])\n",
        "    email=(tuples[10])\n",
        "    street = (tuples[4])\n",
        "    ort = (tuples[7])\n",
        "    \n",
        "    name1=clean_text(name1)\n",
        "    name2=clean_text(name2)\n",
        "    email=clean_text(email)\n",
        "    ort = clean_text(ort)\n",
        "    street=clean_text(street)\n",
        "    \n",
        "    query_dict={}\n",
        "    query_dict[name1]=[]\n",
        "    query_dict[name1].append(name1.strip())\n",
        "    if name2 != 'None':\n",
        "        query_dict[name1].append((name1+' '+name2).strip())\n",
        "    else:\n",
        "        query_dict[name1].append(name1)\n",
        "    if ort != 'None':\n",
        "        query_dict[name1].append((name1+' '+ort).strip())\n",
        "    else:\n",
        "        query_dict[name1].append(name1)\n",
        "    if name2 != 'None' and ort !='None':\n",
        "        query_dict[name1].append((name1 + ' ' + name2 + ' ' + ort).strip())\n",
        "    else:\n",
        "        query_dict[name1].append(name1)\n",
        "    \n",
        "    \n",
        "    return query_dict\n"
      ],
      "id": "SDH9ofmp7_Uk"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "LLzZcD1v7_Uo"
      },
      "outputs": [],
      "source": [
        "queries_all=[]\n",
        "for tuples in df_all.itertuples():\n",
        "    queries_all.append(make_query(tuples))"
      ],
      "id": "LLzZcD1v7_Uo"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "T8RLnTZO7_Up"
      },
      "outputs": [],
      "source": [
        "queries_keys=[]\n",
        "query1=[]\n",
        "query2=[]\n",
        "query3=[]\n",
        "query4=[]\n",
        "\n",
        "for each in queries_all:\n",
        "    queries_keys.append(list(each.keys())[0])\n",
        "    queries_list = list(each.values())\n",
        "    \n",
        "    query1.append(queries_list[0][0])  # name1\n",
        "    query2.append(queries_list[0][1])  # name1+name2\n",
        "    query3.append(queries_list[0][2])  # name1+ort\n",
        "    query4.append(queries_list[0][3])  # name1+ name2 +ort\n",
        "    "
      ],
      "id": "T8RLnTZO7_Up"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "5obJXEcQ7_Uq"
      },
      "outputs": [],
      "source": [
        "df_queries=pd.DataFrame()\n",
        "df_queries['query'] = queries_keys\n",
        "df_queries['query_1']=query1\n",
        "df_queries['query_2']=query2\n",
        "df_queries['query_3']=query3\n",
        "df_queries['query_4']=query4\n",
        "\n"
      ],
      "id": "5obJXEcQ7_Uq"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "w9mdfKt27_Ut",
        "outputId": "1ff14c15-3451-464c-a184-813788686382"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "<ipython-input-5-de798b481118>:8: DeprecationWarning: firefox_profile has been deprecated, please use an Options object\n",
            "  firefox_profile = FirefoxProfile()\n",
            "<ipython-input-5-de798b481118>:10: DeprecationWarning: Setting a profile has been deprecated. Please use the set_preference and install_addons methods\n",
            "  options.profile = firefox_profile\n",
            "<ipython-input-5-de798b481118>:11: DeprecationWarning: firefox_profile has been deprecated, please use an Options object\n",
            "  fp = webdriver.FirefoxProfile()\n",
            "[WDM] - Downloading:   0%|                                                                 | 0.00/2.58k [00:00<?, ?B/s]<ipython-input-5-de798b481118>:13: DeprecationWarning: executable_path has been deprecated, please pass in a Service object\n",
            "  driver = webdriver.Firefox(executable_path=GeckoDriverManager().install(), options=options,firefox_profile=fp)\n",
            "<ipython-input-5-de798b481118>:13: DeprecationWarning: firefox_profile has been deprecated, please pass in an Options object\n",
            "  driver = webdriver.Firefox(executable_path=GeckoDriverManager().install(), options=options,firefox_profile=fp)\n"
          ]
        }
      ],
      "source": [
        "options = Options()\n",
        "options.add_argument(\"-headless\")\n",
        "options.add_argument(\"--no-sandbox\")\n",
        "options.add_argument(\"disable-infobars\")\n",
        "options.add_argument(\"--enable-javascript\")\n",
        "options.add_argument(\"--disable-cookies\")\n",
        "options.add_argument('--proxy-server=%s' % '5.9.94.91:3128')\n",
        "firefox_profile = FirefoxProfile()\n",
        "firefox_profile.set_preference(\"javascript.enabled\", False)\n",
        "options.profile = firefox_profile\n",
        "fp = webdriver.FirefoxProfile()\n",
        "fp.set_preference(\"network.cookie.cookieBehavior\", 0)\n",
        "driver = webdriver.Firefox(executable_path=GeckoDriverManager().install(), options=options,firefox_profile=fp)\n",
        "# browser = webdriver.Firefox()\n"
      ],
      "id": "w9mdfKt27_Ut"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "LZ_1U8Xj7_Uu",
        "outputId": "86e532ec-af42-4955-ccc5-d1120aa3c524"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "\n",
            "\n",
            "[WDM] - Downloading: 100%|████████████████████████████████████████████████████████| 1.58M/1.58M [00:18<00:00, 4.09MB/s]\u001b[A\u001b[A"
          ]
        }
      ],
      "source": [
        "def print_time():\n",
        "    start_time = time.localtime()\n",
        "    print(str(start_time.tm_hour)+':'+str(start_time.tm_min))\n"
      ],
      "id": "LZ_1U8Xj7_Uu"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "XCby9tiA7_Uw",
        "outputId": "2ab8dd22-fb87-4ca0-f644-fbd1effa1fc5"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>display names</th>\n",
              "      <th>queries</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1&amp;1 Telecom GmbH</td>\n",
              "      <td>1&amp;1 Telecom GmbH</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Acino AG</td>\n",
              "      <td>Acino AG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>productive-data GmbH</td>\n",
              "      <td>ALD Autoleasing</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Iskander Business Partner GmbH</td>\n",
              "      <td>ALDI Nord</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Allianz Global Corporate and Specialty SE München</td>\n",
              "      <td>Allianz Global Corporate and Specialty SE München</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>118</th>\n",
              "      <td>VIYEMA Solutions GmbH</td>\n",
              "      <td>VIYEMA Solutions GmbH</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>1st solution consulting GmbH</td>\n",
              "      <td>Vodafone</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>Wipro Valueleaf GmbH</td>\n",
              "      <td>Wipro Technologies Ltd</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121</th>\n",
              "      <td>ZF Friedrichshafen AG</td>\n",
              "      <td>ZF Friedrichshafen AG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122</th>\n",
              "      <td>BNP Paribas Deutschland</td>\n",
              "      <td>BNP Paribas Deutschland</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>123 rows × 2 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                         display names  \\\n",
              "0                                     1&1 Telecom GmbH   \n",
              "1                                             Acino AG   \n",
              "2                                 productive-data GmbH   \n",
              "3                       Iskander Business Partner GmbH   \n",
              "4    Allianz Global Corporate and Specialty SE München   \n",
              "..                                                 ...   \n",
              "118                              VIYEMA Solutions GmbH   \n",
              "119                       1st solution consulting GmbH   \n",
              "120                               Wipro Valueleaf GmbH   \n",
              "121                              ZF Friedrichshafen AG   \n",
              "122                            BNP Paribas Deutschland   \n",
              "\n",
              "                                               queries  \n",
              "0                                     1&1 Telecom GmbH  \n",
              "1                                             Acino AG  \n",
              "2                                      ALD Autoleasing  \n",
              "3                                            ALDI Nord  \n",
              "4    Allianz Global Corporate and Specialty SE München  \n",
              "..                                                 ...  \n",
              "118                              VIYEMA Solutions GmbH  \n",
              "119                                           Vodafone  \n",
              "120                             Wipro Technologies Ltd  \n",
              "121                              ZF Friedrichshafen AG  \n",
              "122                            BNP Paribas Deutschland  \n",
              "\n",
              "[123 rows x 2 columns]"
            ]
          },
          "execution_count": 8,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df = df[['Abrechnungspartner / Kunde','Endkunde (Input)']]\n",
        "df.columns = ['display names','queries']\n",
        "df"
      ],
      "id": "XCby9tiA7_Uw"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "yllC9oAH7_Ux"
      },
      "outputs": [],
      "source": [
        "# print_time()\n",
        "finder= UrlFind('yahoo')\n",
        "finder.send_query(df['queries'])\n"
      ],
      "id": "yllC9oAH7_Ux"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "v9B9zg6I7_Uz",
        "outputId": "a6117716-5a5e-4443-fdab-5fb0f7cf6beb"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "10:32\n",
            "10:37\n"
          ]
        }
      ],
      "source": [
        "print_time()\n",
        "finder= UrlFind('yahoo')\n",
        "finder.send_query(df_queries['query_1'])\n",
        "df_found1=pd.DataFrame(finder.dict_links)\n",
        "df_found1['real_website']=list(df_all['Website'])\n",
        "df_found1['found_query1']=df_found1['found_link']\n",
        "df_found1.drop(columns=['found_link'],inplace=True)\n",
        "print_time()"
      ],
      "id": "v9B9zg6I7_Uz"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": true,
        "id": "sVBfQcSF7_U0",
        "outputId": "f8480e74-fb40-406c-c1c0-fe67bf2a60ca"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "10:37\n",
            "10:42\n"
          ]
        }
      ],
      "source": [
        "print_time()\n",
        "finder= UrlFind()\n",
        "finder.send_query(df_queries['query_2'])\n",
        "df_found2=pd.DataFrame(finder.dict_links)\n",
        "df_found1['found_query2']=df_found2['found_link']\n",
        "print_time()"
      ],
      "id": "sVBfQcSF7_U0"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "4h9fspw17_U1",
        "outputId": "c9088c15-1e39-4a47-b4ed-de26abaa31f9"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "10:42\n",
            "10:47\n"
          ]
        }
      ],
      "source": [
        "print_time()\n",
        "finder= UrlFind()\n",
        "finder.send_query(df_queries['query_3'])\n",
        "df_found3=pd.DataFrame(finder.dict_links)\n",
        "df_found1['found_query3']=df_found3['found_link']\n",
        "print_time()"
      ],
      "id": "4h9fspw17_U1"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": false,
        "id": "Tp3bRmaf7_U2",
        "outputId": "65be55be-f7be-4851-912f-b210cb1d489d"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "10:47\n",
            "10:52\n"
          ]
        }
      ],
      "source": [
        "print_time()\n",
        "finder= UrlFind()\n",
        "finder.send_query(df_queries['query_4'])\n",
        "df_found4=pd.DataFrame(finder.dict_links)\n",
        "df_found1['found_query4']=df_found4['found_link']\n",
        "print_time()"
      ],
      "id": "Tp3bRmaf7_U2"
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "JTCv0wKM7_U3",
        "outputId": "a3d530fe-92eb-49d5-b3e2-c7a314dd848b"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>query</th>\n",
              "      <th>real_website</th>\n",
              "      <th>found_query1</th>\n",
              "      <th>found_query2</th>\n",
              "      <th>found_query3</th>\n",
              "      <th>found_query4</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>A A Czylwick GmbH   Co  KG</td>\n",
              "      <td>http://www.czylwick.de</td>\n",
              "      <td>czylwick.de</td>\n",
              "      <td>czylwick.de</td>\n",
              "      <td>czylwick.de</td>\n",
              "      <td>czylwick.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>A F Solartechnik GmbH</td>\n",
              "      <td>www.af-solartechnik.de</td>\n",
              "      <td>oekoportal.de</td>\n",
              "      <td>0</td>\n",
              "      <td>oekoportal.de</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>A   Haustechnik GmbH</td>\n",
              "      <td>www.aplus-haustechnik.de</td>\n",
              "      <td>aplus-haustechnik.de</td>\n",
              "      <td>aplus-haustechnik.de</td>\n",
              "      <td>aplus-haustechnik.de</td>\n",
              "      <td>aplus-haustechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>A M Heizungs Sanitärtechnik GmbH</td>\n",
              "      <td>https://www.haustechnik-duisburg.com/</td>\n",
              "      <td>www.haustechnik-duisburg.com</td>\n",
              "      <td>www.haustechnik-duisburg.com</td>\n",
              "      <td>www.haustechnik-duisburg.com</td>\n",
              "      <td>www.haustechnik-duisburg.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AAAB Edgar Valk GmbH</td>\n",
              "      <td>www.berliner-handwerkerservice.de</td>\n",
              "      <td>www.aaab-berlin.de</td>\n",
              "      <td>www.aaab-berlin.de</td>\n",
              "      <td>www.aaab-berlin.de</td>\n",
              "      <td>www.aaab-berlin.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Aaron Baitinger</td>\n",
              "      <td>www.aaronbaitinger.de</td>\n",
              "      <td>www.aaronbaitinger.de</td>\n",
              "      <td>www.aaronbaitinger.de</td>\n",
              "      <td>www.aaronbaitinger.de</td>\n",
              "      <td>www.aaronbaitinger.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Aaron Kraus</td>\n",
              "      <td>www.aaronkraus.de</td>\n",
              "      <td>famouspeopletoday.com</td>\n",
              "      <td>www.aaronkraus.de</td>\n",
              "      <td>www.aaronkraus.de</td>\n",
              "      <td>www.aaronkraus.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Aartal Haustechnik</td>\n",
              "      <td>www.aartal-haustechnik.de</td>\n",
              "      <td>www.aartal-haustechnik.de</td>\n",
              "      <td>www.aartal-haustechnik.de</td>\n",
              "      <td>www.aartal-haustechnik.de</td>\n",
              "      <td>www.aartal-haustechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Abaco GmbH</td>\n",
              "      <td>www.abaco-oppau.de</td>\n",
              "      <td>abaco.de</td>\n",
              "      <td>abaco.de</td>\n",
              "      <td>www.abaco-oppau.de</td>\n",
              "      <td>www.abaco.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>abasto   ökologische Energietechnik</td>\n",
              "      <td>www.abasto.de</td>\n",
              "      <td>www.abasto.de</td>\n",
              "      <td>www.abasto.de</td>\n",
              "      <td>www.abasto.de</td>\n",
              "      <td>www.abasto.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>ABB STOTZ KONTAKT GmbH</td>\n",
              "      <td>www.abb.com/knx</td>\n",
              "      <td>new.abb.com</td>\n",
              "      <td>new.abb.com</td>\n",
              "      <td>new.abb.com</td>\n",
              "      <td>new.abb.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>ABC Klima  Heizung  Kältetechnik</td>\n",
              "      <td>www.abc-gruhn.de</td>\n",
              "      <td>www.abc-gruhn.de</td>\n",
              "      <td>www.abc-gruhn.de</td>\n",
              "      <td>www.abc-gruhn.de</td>\n",
              "      <td>www.abc-gruhn.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>ABD GmbH</td>\n",
              "      <td>www.fued.de</td>\n",
              "      <td>nl.kompass.com</td>\n",
              "      <td>www.abdgmbh.ch</td>\n",
              "      <td>www.abd-mg.de</td>\n",
              "      <td>www.abdgmbh.ch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Abdurrahman Koc</td>\n",
              "      <td>www.elektro-koc.de</td>\n",
              "      <td>www.haberler.com</td>\n",
              "      <td>www.elektrostellen.de</td>\n",
              "      <td>dachtechnik-koc.de</td>\n",
              "      <td>gilching.deutschbranchenbuch.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Abele   Volk GmbH</td>\n",
              "      <td>www.abele-volk.de</td>\n",
              "      <td>abele-volk.de</td>\n",
              "      <td>abele-volk.de</td>\n",
              "      <td>abele-volk.de</td>\n",
              "      <td>abele-volk.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Abele GmbH</td>\n",
              "      <td>www.abele.eu</td>\n",
              "      <td>abele-gmbh.de</td>\n",
              "      <td>abele-gmbh.de</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>abele-gmbh.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Abele Haustechnik GmbH</td>\n",
              "      <td>www.abele.eu</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>abele.eu</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Abel Elektrotechnik GmbH Co KG</td>\n",
              "      <td>www.abel-elektrotechnik.de</td>\n",
              "      <td>abel-elektrotechnik.de</td>\n",
              "      <td>abel-elektrotechnik.de</td>\n",
              "      <td>abel-elektrotechnik.de</td>\n",
              "      <td>abel-elektrotechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Abele Service GmbH</td>\n",
              "      <td>https://abele.eu/</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>abele.eu</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Abele Verwaltung GmbH</td>\n",
              "      <td>http://www.abele.eu</td>\n",
              "      <td>www.abele.de</td>\n",
              "      <td>www.abele.de</td>\n",
              "      <td>abele.eu</td>\n",
              "      <td>www.abele.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Abfluss Schmidt GmbH</td>\n",
              "      <td>www.abfluss-schmidt.de</td>\n",
              "      <td>abfluss-schmidt.de</td>\n",
              "      <td>abfluss-schmidt.de</td>\n",
              "      <td>abfluss-schmidt.de</td>\n",
              "      <td>abfluss-schmidt.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>AB Gebäudetechnik GmbH</td>\n",
              "      <td>www.ab-dienstleistung.de</td>\n",
              "      <td>www.ab-gebaudetechnik.at</td>\n",
              "      <td>www.ab-dienstleistung.de</td>\n",
              "      <td>www.ab-dienstleistung.de</td>\n",
              "      <td>www.ab-gebaudetechnik.at</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>AB Haustechnik</td>\n",
              "      <td>www.abh-hamburg.de</td>\n",
              "      <td>www.ab-haustechnik.de</td>\n",
              "      <td>www.ab-haustechnik.de</td>\n",
              "      <td>www.ab-haustechnik.de</td>\n",
              "      <td>www.ab-haustechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>ABIA</td>\n",
              "      <td>www.abia.ag</td>\n",
              "      <td>www.austintexas.gov</td>\n",
              "      <td>abia-versorgungstechnik.de</td>\n",
              "      <td>abia-gruppe.de</td>\n",
              "      <td>abia-versorgungstechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>ABL BROCHIER Klimatechnik und</td>\n",
              "      <td>www.a-brochier.de</td>\n",
              "      <td>abl-brochier.de</td>\n",
              "      <td>abl-brochier.de</td>\n",
              "      <td>abl-brochier.de</td>\n",
              "      <td>abl-brochier.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>ABL Haustechnik</td>\n",
              "      <td>abl-haustechnik.de</td>\n",
              "      <td>www.elektroshopwagner.de</td>\n",
              "      <td>mein-heizung-profi.de</td>\n",
              "      <td>www.wildeshauser-haustechnik.de</td>\n",
              "      <td>mein-heizung-profi.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Abo Haustechnik</td>\n",
              "      <td>www.abo-haustechnik.de</td>\n",
              "      <td>abo-haustechnik.de</td>\n",
              "      <td>abo-haustechnik.de</td>\n",
              "      <td>abo-haustechnik.de</td>\n",
              "      <td>abo-haustechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Abr  Bergmann Söhne GmbH</td>\n",
              "      <td>www.heizung-sanitaer-wuppertal.de</td>\n",
              "      <td>heizung-sanitaer-wuppertal.de</td>\n",
              "      <td>heizung-sanitaer-wuppertal.de</td>\n",
              "      <td>heizung-sanitaer-wuppertal.de</td>\n",
              "      <td>heizung-sanitaer-wuppertal.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Abraham</td>\n",
              "      <td>www.abraham-gmbh.de</td>\n",
              "      <td>kro-ncrv.nl</td>\n",
              "      <td>www.abraham-gmbh.de</td>\n",
              "      <td>www.abraham-gmbh.de</td>\n",
              "      <td>www.abraham-gmbh.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Abraham   Rathjens</td>\n",
              "      <td>www.abraham-rathjens.de</td>\n",
              "      <td>abraham-rathjens.de</td>\n",
              "      <td>abraham-rathjens.de</td>\n",
              "      <td>abraham-rathjens.de</td>\n",
              "      <td>abraham-rathjens.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>ABR   Ferdi Derin</td>\n",
              "      <td>www.abr-derin.de</td>\n",
              "      <td>abr-derin.de</td>\n",
              "      <td>abr-derin.de</td>\n",
              "      <td>abr-derin.business.site</td>\n",
              "      <td>abr-derin.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>ABRO Service GmbH</td>\n",
              "      <td>www.abro-service.de</td>\n",
              "      <td>www.abro-service.de</td>\n",
              "      <td>www.abro-service.de</td>\n",
              "      <td>www.abro-service.de</td>\n",
              "      <td>www.abro-service.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>ABROTEC Energietechnik GmbH</td>\n",
              "      <td>www.abrotec.de</td>\n",
              "      <td>www.abrotec.de</td>\n",
              "      <td>www.abrotec.de</td>\n",
              "      <td>abrotec.de</td>\n",
              "      <td>www.abrotec.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>ABS Haustechnik LEFFECK</td>\n",
              "      <td>www.abs-haustechnik.com</td>\n",
              "      <td>www.abs-haustechnik.com</td>\n",
              "      <td>www.abs-haustechnik.com</td>\n",
              "      <td>www.abs-haustechnik.com</td>\n",
              "      <td>www.abs-haustechnik.com</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Abstoss GmbH</td>\n",
              "      <td>www.abstoss-shk.de</td>\n",
              "      <td>www.unternehmen24.info</td>\n",
              "      <td>www.abstoss-wolters.de</td>\n",
              "      <td>0</td>\n",
              "      <td>www.abstoss-wolters.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>ABT Wärmetechnik Service  und</td>\n",
              "      <td>http://www.abt-waerme.de/</td>\n",
              "      <td>www.abt-waerme.de</td>\n",
              "      <td>www.abt-waerme.de</td>\n",
              "      <td>www.abt-waerme.de</td>\n",
              "      <td>www.abt-waerme.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>A B U</td>\n",
              "      <td>www.abuhaustechnik.de</td>\n",
              "      <td>www.abu.nl</td>\n",
              "      <td>www.abuhaustechnik.de</td>\n",
              "      <td>www.rtl.de</td>\n",
              "      <td>www.abuhaustechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>AC DC Elektroinstallation</td>\n",
              "      <td>www.acdc-elektro.de</td>\n",
              "      <td>wallbox.com</td>\n",
              "      <td>acdc-elektro.de</td>\n",
              "      <td>acdc-elektro.de</td>\n",
              "      <td>acdc-elektro.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Achahboun Sanitär   Sanitär</td>\n",
              "      <td>www.achahboun-shk.de</td>\n",
              "      <td>firmania.de</td>\n",
              "      <td>www.robrecht-sanitaer.de</td>\n",
              "      <td>0</td>\n",
              "      <td>www.sanitaergruber.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>AC Haus  und Energietechnik GmbH</td>\n",
              "      <td>www.ac-haustechnik-gmbh.de</td>\n",
              "      <td>ac-haustechnik-gmbh.de</td>\n",
              "      <td>ac-haustechnik-gmbh.de</td>\n",
              "      <td>ac-haustechnik-gmbh.de</td>\n",
              "      <td>ac-haustechnik-gmbh.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>Achim Engel</td>\n",
              "      <td>www.hbs-gebäudeservice.de</td>\n",
              "      <td>www.gettyimages.nl</td>\n",
              "      <td>finde-offen.de</td>\n",
              "      <td>www.weingut-schuetzenhof.de</td>\n",
              "      <td>www.immobilienscout24.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>Achim Fischer GmbH   Co  KG</td>\n",
              "      <td>www.fischer-bad.de</td>\n",
              "      <td>www.fischer-schliesstechnik.de</td>\n",
              "      <td>www.fischer-schliesstechnik.de</td>\n",
              "      <td>www.fischer-schliesstechnik.de</td>\n",
              "      <td>www.fischer-schliesstechnik.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>Achim Gadow GmbH</td>\n",
              "      <td>http://www.achim-gadow.de/</td>\n",
              "      <td>www.achim-gadow.de</td>\n",
              "      <td>www.achim-gadow.de</td>\n",
              "      <td>www.achim-gadow.de</td>\n",
              "      <td>www.achim-gadow.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>Achim Gottschalk</td>\n",
              "      <td>www.elektrogottschalk.de</td>\n",
              "      <td>www.duesseldorf.de</td>\n",
              "      <td>www.haaretz.com</td>\n",
              "      <td>www.oeffnungszeiten-firmen.de</td>\n",
              "      <td>www.duesseldorf.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Achim Hambücken</td>\n",
              "      <td>www.hambuecken.de</td>\n",
              "      <td>www.hambuecken.de</td>\n",
              "      <td>www.hambuecken.de</td>\n",
              "      <td>www.hambuecken.de</td>\n",
              "      <td>www.hambuecken.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>Achim Held</td>\n",
              "      <td>www.held-der-elektrik.de</td>\n",
              "      <td>www.faz.net</td>\n",
              "      <td>www.instagram.com</td>\n",
              "      <td>0</td>\n",
              "      <td>www.elektrikerjobs.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Achim Klug Heizung Sanitär</td>\n",
              "      <td>www.shark-mehlingen.de</td>\n",
              "      <td>directory.cosuno.com</td>\n",
              "      <td>shark-mehlingen.de</td>\n",
              "      <td>shark-mehlingen.de</td>\n",
              "      <td>shark-mehlingen.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Achim Richter</td>\n",
              "      <td>www.richter-haustechnik.com</td>\n",
              "      <td>www.gettyimages.nl</td>\n",
              "      <td>richter-herrsching-mde.de</td>\n",
              "      <td>richter-herrsching-mde.de</td>\n",
              "      <td>richter-herrsching-mde.de</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Achim Schendel</td>\n",
              "      <td>http://www.achim-schendel.de</td>\n",
              "      <td>karmenta.nl</td>\n",
              "      <td>de.kompass.com</td>\n",
              "      <td>kempen.branchen-info.net</td>\n",
              "      <td>kempen.branchen-info.net</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Achim Schumacher GmbH   Co  KG</td>\n",
              "      <td>www.schumacher-herdecke.de</td>\n",
              "      <td>schumacher-herdecke.de</td>\n",
              "      <td>schumacher-herdecke.de</td>\n",
              "      <td>schumacher-herdecke.de</td>\n",
              "      <td>schumacher-herdecke.de</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                  query  \\\n",
              "0            A A Czylwick GmbH   Co  KG   \n",
              "1                 A F Solartechnik GmbH   \n",
              "2                  A   Haustechnik GmbH   \n",
              "3      A M Heizungs Sanitärtechnik GmbH   \n",
              "4                  AAAB Edgar Valk GmbH   \n",
              "5                       Aaron Baitinger   \n",
              "6                           Aaron Kraus   \n",
              "7                    Aartal Haustechnik   \n",
              "8                            Abaco GmbH   \n",
              "9   abasto   ökologische Energietechnik   \n",
              "10               ABB STOTZ KONTAKT GmbH   \n",
              "11     ABC Klima  Heizung  Kältetechnik   \n",
              "12                             ABD GmbH   \n",
              "13                      Abdurrahman Koc   \n",
              "14                    Abele   Volk GmbH   \n",
              "15                           Abele GmbH   \n",
              "16               Abele Haustechnik GmbH   \n",
              "17       Abel Elektrotechnik GmbH Co KG   \n",
              "18                   Abele Service GmbH   \n",
              "19                Abele Verwaltung GmbH   \n",
              "20                 Abfluss Schmidt GmbH   \n",
              "21               AB Gebäudetechnik GmbH   \n",
              "22                       AB Haustechnik   \n",
              "23                                 ABIA   \n",
              "24        ABL BROCHIER Klimatechnik und   \n",
              "25                      ABL Haustechnik   \n",
              "26                      Abo Haustechnik   \n",
              "27             Abr  Bergmann Söhne GmbH   \n",
              "28                              Abraham   \n",
              "29                   Abraham   Rathjens   \n",
              "30                    ABR   Ferdi Derin   \n",
              "31                    ABRO Service GmbH   \n",
              "32          ABROTEC Energietechnik GmbH   \n",
              "33              ABS Haustechnik LEFFECK   \n",
              "34                         Abstoss GmbH   \n",
              "35        ABT Wärmetechnik Service  und   \n",
              "36                                A B U   \n",
              "37            AC DC Elektroinstallation   \n",
              "38          Achahboun Sanitär   Sanitär   \n",
              "39     AC Haus  und Energietechnik GmbH   \n",
              "40                          Achim Engel   \n",
              "41          Achim Fischer GmbH   Co  KG   \n",
              "42                     Achim Gadow GmbH   \n",
              "43                     Achim Gottschalk   \n",
              "44                      Achim Hambücken   \n",
              "45                           Achim Held   \n",
              "46           Achim Klug Heizung Sanitär   \n",
              "47                        Achim Richter   \n",
              "48                       Achim Schendel   \n",
              "49       Achim Schumacher GmbH   Co  KG   \n",
              "\n",
              "                             real_website                    found_query1  \\\n",
              "0                  http://www.czylwick.de                     czylwick.de   \n",
              "1                  www.af-solartechnik.de                   oekoportal.de   \n",
              "2                www.aplus-haustechnik.de            aplus-haustechnik.de   \n",
              "3   https://www.haustechnik-duisburg.com/    www.haustechnik-duisburg.com   \n",
              "4       www.berliner-handwerkerservice.de              www.aaab-berlin.de   \n",
              "5                   www.aaronbaitinger.de           www.aaronbaitinger.de   \n",
              "6                       www.aaronkraus.de           famouspeopletoday.com   \n",
              "7               www.aartal-haustechnik.de       www.aartal-haustechnik.de   \n",
              "8                      www.abaco-oppau.de                        abaco.de   \n",
              "9                           www.abasto.de                   www.abasto.de   \n",
              "10                        www.abb.com/knx                     new.abb.com   \n",
              "11                       www.abc-gruhn.de                www.abc-gruhn.de   \n",
              "12                            www.fued.de                  nl.kompass.com   \n",
              "13                     www.elektro-koc.de                www.haberler.com   \n",
              "14                      www.abele-volk.de                   abele-volk.de   \n",
              "15                           www.abele.eu                   abele-gmbh.de   \n",
              "16                           www.abele.eu                        abele.eu   \n",
              "17             www.abel-elektrotechnik.de          abel-elektrotechnik.de   \n",
              "18                      https://abele.eu/                        abele.eu   \n",
              "19                    http://www.abele.eu                    www.abele.de   \n",
              "20                 www.abfluss-schmidt.de              abfluss-schmidt.de   \n",
              "21               www.ab-dienstleistung.de        www.ab-gebaudetechnik.at   \n",
              "22                     www.abh-hamburg.de           www.ab-haustechnik.de   \n",
              "23                            www.abia.ag             www.austintexas.gov   \n",
              "24                      www.a-brochier.de                 abl-brochier.de   \n",
              "25                     abl-haustechnik.de        www.elektroshopwagner.de   \n",
              "26                 www.abo-haustechnik.de              abo-haustechnik.de   \n",
              "27      www.heizung-sanitaer-wuppertal.de   heizung-sanitaer-wuppertal.de   \n",
              "28                    www.abraham-gmbh.de                     kro-ncrv.nl   \n",
              "29                www.abraham-rathjens.de             abraham-rathjens.de   \n",
              "30                       www.abr-derin.de                    abr-derin.de   \n",
              "31                    www.abro-service.de             www.abro-service.de   \n",
              "32                         www.abrotec.de                  www.abrotec.de   \n",
              "33                www.abs-haustechnik.com         www.abs-haustechnik.com   \n",
              "34                     www.abstoss-shk.de          www.unternehmen24.info   \n",
              "35              http://www.abt-waerme.de/               www.abt-waerme.de   \n",
              "36                  www.abuhaustechnik.de                      www.abu.nl   \n",
              "37                    www.acdc-elektro.de                     wallbox.com   \n",
              "38                   www.achahboun-shk.de                     firmania.de   \n",
              "39             www.ac-haustechnik-gmbh.de          ac-haustechnik-gmbh.de   \n",
              "40              www.hbs-gebäudeservice.de              www.gettyimages.nl   \n",
              "41                     www.fischer-bad.de  www.fischer-schliesstechnik.de   \n",
              "42             http://www.achim-gadow.de/              www.achim-gadow.de   \n",
              "43               www.elektrogottschalk.de              www.duesseldorf.de   \n",
              "44                      www.hambuecken.de               www.hambuecken.de   \n",
              "45               www.held-der-elektrik.de                     www.faz.net   \n",
              "46                 www.shark-mehlingen.de            directory.cosuno.com   \n",
              "47            www.richter-haustechnik.com              www.gettyimages.nl   \n",
              "48           http://www.achim-schendel.de                     karmenta.nl   \n",
              "49             www.schumacher-herdecke.de          schumacher-herdecke.de   \n",
              "\n",
              "                      found_query2                     found_query3  \\\n",
              "0                      czylwick.de                      czylwick.de   \n",
              "1                                0                    oekoportal.de   \n",
              "2             aplus-haustechnik.de             aplus-haustechnik.de   \n",
              "3     www.haustechnik-duisburg.com     www.haustechnik-duisburg.com   \n",
              "4               www.aaab-berlin.de               www.aaab-berlin.de   \n",
              "5            www.aaronbaitinger.de            www.aaronbaitinger.de   \n",
              "6                www.aaronkraus.de                www.aaronkraus.de   \n",
              "7        www.aartal-haustechnik.de        www.aartal-haustechnik.de   \n",
              "8                         abaco.de               www.abaco-oppau.de   \n",
              "9                    www.abasto.de                    www.abasto.de   \n",
              "10                     new.abb.com                      new.abb.com   \n",
              "11                www.abc-gruhn.de                 www.abc-gruhn.de   \n",
              "12                  www.abdgmbh.ch                    www.abd-mg.de   \n",
              "13           www.elektrostellen.de               dachtechnik-koc.de   \n",
              "14                   abele-volk.de                    abele-volk.de   \n",
              "15                   abele-gmbh.de                         abele.eu   \n",
              "16                        abele.eu                         abele.eu   \n",
              "17          abel-elektrotechnik.de           abel-elektrotechnik.de   \n",
              "18                        abele.eu                         abele.eu   \n",
              "19                    www.abele.de                         abele.eu   \n",
              "20              abfluss-schmidt.de               abfluss-schmidt.de   \n",
              "21        www.ab-dienstleistung.de         www.ab-dienstleistung.de   \n",
              "22           www.ab-haustechnik.de            www.ab-haustechnik.de   \n",
              "23      abia-versorgungstechnik.de                   abia-gruppe.de   \n",
              "24                 abl-brochier.de                  abl-brochier.de   \n",
              "25           mein-heizung-profi.de  www.wildeshauser-haustechnik.de   \n",
              "26              abo-haustechnik.de               abo-haustechnik.de   \n",
              "27   heizung-sanitaer-wuppertal.de    heizung-sanitaer-wuppertal.de   \n",
              "28             www.abraham-gmbh.de              www.abraham-gmbh.de   \n",
              "29             abraham-rathjens.de              abraham-rathjens.de   \n",
              "30                    abr-derin.de          abr-derin.business.site   \n",
              "31             www.abro-service.de              www.abro-service.de   \n",
              "32                  www.abrotec.de                       abrotec.de   \n",
              "33         www.abs-haustechnik.com          www.abs-haustechnik.com   \n",
              "34          www.abstoss-wolters.de                                0   \n",
              "35               www.abt-waerme.de                www.abt-waerme.de   \n",
              "36           www.abuhaustechnik.de                       www.rtl.de   \n",
              "37                 acdc-elektro.de                  acdc-elektro.de   \n",
              "38        www.robrecht-sanitaer.de                                0   \n",
              "39          ac-haustechnik-gmbh.de           ac-haustechnik-gmbh.de   \n",
              "40                  finde-offen.de      www.weingut-schuetzenhof.de   \n",
              "41  www.fischer-schliesstechnik.de   www.fischer-schliesstechnik.de   \n",
              "42              www.achim-gadow.de               www.achim-gadow.de   \n",
              "43                 www.haaretz.com    www.oeffnungszeiten-firmen.de   \n",
              "44               www.hambuecken.de                www.hambuecken.de   \n",
              "45               www.instagram.com                                0   \n",
              "46              shark-mehlingen.de               shark-mehlingen.de   \n",
              "47       richter-herrsching-mde.de        richter-herrsching-mde.de   \n",
              "48                  de.kompass.com         kempen.branchen-info.net   \n",
              "49          schumacher-herdecke.de           schumacher-herdecke.de   \n",
              "\n",
              "                        found_query4  \n",
              "0                        czylwick.de  \n",
              "1                                  0  \n",
              "2               aplus-haustechnik.de  \n",
              "3       www.haustechnik-duisburg.com  \n",
              "4                 www.aaab-berlin.de  \n",
              "5              www.aaronbaitinger.de  \n",
              "6                  www.aaronkraus.de  \n",
              "7          www.aartal-haustechnik.de  \n",
              "8                      www.abaco.com  \n",
              "9                      www.abasto.de  \n",
              "10                       new.abb.com  \n",
              "11                  www.abc-gruhn.de  \n",
              "12                    www.abdgmbh.ch  \n",
              "13  gilching.deutschbranchenbuch.com  \n",
              "14                     abele-volk.de  \n",
              "15                     abele-gmbh.de  \n",
              "16                          abele.eu  \n",
              "17            abel-elektrotechnik.de  \n",
              "18                          abele.eu  \n",
              "19                      www.abele.de  \n",
              "20                abfluss-schmidt.de  \n",
              "21          www.ab-gebaudetechnik.at  \n",
              "22             www.ab-haustechnik.de  \n",
              "23        abia-versorgungstechnik.de  \n",
              "24                   abl-brochier.de  \n",
              "25             mein-heizung-profi.de  \n",
              "26                abo-haustechnik.de  \n",
              "27     heizung-sanitaer-wuppertal.de  \n",
              "28               www.abraham-gmbh.de  \n",
              "29               abraham-rathjens.de  \n",
              "30                      abr-derin.de  \n",
              "31               www.abro-service.de  \n",
              "32                    www.abrotec.de  \n",
              "33           www.abs-haustechnik.com  \n",
              "34            www.abstoss-wolters.de  \n",
              "35                 www.abt-waerme.de  \n",
              "36             www.abuhaustechnik.de  \n",
              "37                   acdc-elektro.de  \n",
              "38             www.sanitaergruber.de  \n",
              "39            ac-haustechnik-gmbh.de  \n",
              "40          www.immobilienscout24.de  \n",
              "41    www.fischer-schliesstechnik.de  \n",
              "42                www.achim-gadow.de  \n",
              "43                www.duesseldorf.de  \n",
              "44                 www.hambuecken.de  \n",
              "45             www.elektrikerjobs.de  \n",
              "46                shark-mehlingen.de  \n",
              "47         richter-herrsching-mde.de  \n",
              "48          kempen.branchen-info.net  \n",
              "49            schumacher-herdecke.de  "
            ]
          },
          "execution_count": 15,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_found1 # from yahoo"
      ],
      "id": "JTCv0wKM7_U3"
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.8.5"
    },
    "colab": {
      "provenance": []
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}