Google Images Scraping.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "N46A81oSpWUG",
        "outputId": "323d2996-e5b1-48c2-af96-d1d4314dbbd4"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting google-search-results\n",
            "  Downloading google_search_results-2.4.1.tar.gz (11 kB)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.7/dist-packages (from google-search-results) (2.23.0)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests->google-search-results) (3.0.4)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests->google-search-results) (2022.9.24)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests->google-search-results) (1.24.3)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests->google-search-results) (2.10)\n",
            "Building wheels for collected packages: google-search-results\n",
            "  Building wheel for google-search-results (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for google-search-results: filename=google_search_results-2.4.1-py3-none-any.whl size=25788 sha256=4d9b387cff9259d00c4fa837ab7b561929dddf5e1d81ef40776ecb1f998777d3\n",
            "  Stored in directory: /root/.cache/pip/wheels/82/a3/c5/364155118f298722dff2f79ae4dd7c91e92b433ad36d6f7e0e\n",
            "Successfully built google-search-results\n",
            "Installing collected packages: google-search-results\n",
            "Successfully installed google-search-results-2.4.1\n"
          ]
        }
      ],
      "source": [
        "!pip install google-search-results"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import os, shutil, requests, lxml, re, json, urllib.request\n",
        "from bs4 import BeautifulSoup\n",
        "from serpapi import GoogleSearch\n",
        "import socket\n",
        "import hashlib\n",
        "\n",
        "socket.setdefaulttimeout(15)\n",
        "\n",
        "headers = {\n",
        "    \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Safari/537.36\"\n",
        "}\n",
        "\n",
        "def google_images_search(text, dst, qt=None, page=0, remain=0):\n",
        "    params = {\n",
        "        \"q\": text,        # search query\n",
        "        \"tbm\": \"isch\",  # image results\n",
        "        \"hl\": \"pt\",     # language of the search\n",
        "        \"gl\": \"br\",     # country where search comes from\n",
        "        \"ijn\": str(page)      # page number\n",
        "    }\n",
        "\n",
        "    param_soup = BeautifulSoup(requests.get(\"https://www.google.com.br/search\", params=params, headers=headers, timeout=30).text, \"lxml\")\n",
        "\n",
        "    all_script_tags = param_soup.select(\"script\")\n",
        "\n",
        "    matched_images_data = \"\".join(re.findall(r\"AF_initDataCallback\\(([^<]+)\\);\", str(all_script_tags)))\n",
        "    matched_images_data_fix = json.dumps(matched_images_data)\n",
        "    matched_images_data_json = json.loads(matched_images_data_fix)\n",
        "    matched_google_image_data = re.findall(r'\\\"b-GRID_STATE0\\\"(.*)sideChannel:\\s?{}}', matched_images_data_json)\n",
        "    matched_google_images_thumbnails = \", \".join(re.findall(r'\\[\\\"(https\\:\\/\\/encrypted-tbn0\\.gstatic\\.com\\/images\\?.*?)\\\",\\d+,\\d+\\]', str(matched_google_image_data))).split(\", \")\n",
        "    thumbnails = [bytes(bytes(thumbnail, \"ascii\").decode(\"unicode-escape\"), \"ascii\").decode(\"unicode-escape\") for thumbnail in matched_google_images_thumbnails]\n",
        "    removed_matched_google_images_thumbnails = re.sub(r'\\[\\\"(https\\:\\/\\/encrypted-tbn0\\.gstatic\\.com\\/images\\?.*?)\\\",\\d+,\\d+\\]', \"\", str(matched_google_image_data))\n",
        "    matched_google_full_resolution_images = re.findall(r\"(?:'|,),\\[\\\"(https:|http.*?)\\\",\\d+,\\d+\\]\", removed_matched_google_images_thumbnails)\n",
        "\n",
        "    full_res_images = [bytes(bytes(img, \"ascii\").decode(\"unicode-escape\"), \"ascii\").decode(\"unicode-escape\") for img in matched_google_full_resolution_images]\n",
        "\n",
        "    if not os.path.exists(\"Images/\"):\n",
        "      print(\"Creating new images folder\")\n",
        "      os.mkdir(\"Images/\")\n",
        "    \n",
        "    for index, (metadata, thumbnail, original) in enumerate(zip(param_soup.select('.isv-r.PNCib.MSM1fd.BUooTd'), thumbnails, full_res_images), start=len(dst)):\n",
        "        imgtitle = metadata.select_one(\".VFACy.kGQAp.sMi44c.lNHeqe.WGvvNb\")[\"title\"]\n",
        "\n",
        "        try:\n",
        "          opener=urllib.request.build_opener()\n",
        "          opener.addheaders=[('User-Agent','Mozilla/5.0 (Windows NT 10.0; Win64; x64)')]\n",
        "          urllib.request.install_opener(opener)\n",
        "\n",
        "          fname = f'Images/{index}.jpg'\n",
        "\n",
        "          urllib.request.urlretrieve(original, fname)\n",
        "\n",
        "          with open(fname, \"rb\") as f:\n",
        "            file_hash = hashlib.blake2b()\n",
        "            chunk = f.read(8192)\n",
        "            while chunk:\n",
        "                file_hash.update(chunk)\n",
        "                chunk = f.read(8192)\n",
        "\n",
        "            for img in dst:\n",
        "              if img[\"title\"] == imgtitle or img[\"hash\"] == file_hash.hexdigest():\n",
        "                os.remove(fname)\n",
        "                raise Exception(\"Warning: Duplicate file detected\")\n",
        "\n",
        "          dst.append({\n",
        "              \"title\": imgtitle,\n",
        "              \"tag\": text,\n",
        "              #\"link\": metadata.select_one(\".VFACy.kGQAp.sMi44c.lNHeqe.WGvvNb\")[\"href\"],\n",
        "              #\"source\": metadata.select_one(\".fxgdke\").text,\n",
        "              #\"thumbnail\": thumbnail,\n",
        "              #\"original\": original,\n",
        "              \"hash\": file_hash.hexdigest()\n",
        "          })\n",
        "\n",
        "          print(f\"Image file quantity: {len(os.listdir('Images/'))}\")\n",
        "\n",
        "        except Exception as e: print(e)\n",
        "\n",
        "        if len(dst) == qt+remain and qt is not None:\n",
        "          break\n",
        "      \n",
        "    print(f\"------------ query: {text} | image list size: {len(dst)} | page: {page} ------------\")\n",
        "\n",
        "    if not os.path.exists(\"tmp_img/\"):\n",
        "      os.mkdir(\"tmp_img/\")\n",
        "\n",
        "    files = sorted(os.listdir(\"Images/\"))[remain:]\n",
        "\n",
        "    for i, file in enumerate(files, start=remain):\n",
        "      shutil.copyfile(f'Images/{file}', f'tmp_img/{i}.jpg')\n",
        "\n",
        "    shutil.rmtree('Images')\n",
        "    os.rename('tmp_img', 'Images')\n",
        "\n",
        "    if len(dst) < qt+remain and qt is not None:\n",
        "      google_images_search(text, dst, qt=qt, page=(page + 1), remain=remain)"
      ],
      "metadata": {
        "id": "BTmIf5p5pig2"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [],
      "metadata": {
        "id": "RDPlL73hR2zn"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!rm -rf Images\n",
        "!rm -rf tmp_img"
      ],
      "metadata": {
        "id": "Lau-Dd_upmm0"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "gimages = []\n",
        "google_images_search(\"camisa\", gimages, qt=50) #Inicia a função asssim\n",
        "google_images_search(\"bermuda\", gimages, qt=50, remain=len(gimages)) #Para cada tag nova, adiciona mais uma chamada no modo recursivo\n",
        "google_images_search(\"regata\", gimages, qt=50, remain=len(gimages)) #Para cada tag nova, adiciona mais uma chamada no modo recursivo\n",
        "\n",
        "#Recomendo por em um loop com a lista das tags, mas não tive tempo de testar ainda."
      ],
      "metadata": {
        "id": "foVPHBjjpq2-",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "25b5e004-ee04-4e50-8265-413898ba9895"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Creating new images folder\n",
            "Image file quantity: 1\n",
            "Image file quantity: 2\n",
            "Image file quantity: 3\n",
            "Image file quantity: 4\n",
            "Image file quantity: 5\n",
            "Image file quantity: 6\n",
            "Image file quantity: 7\n",
            "Image file quantity: 8\n",
            "Image file quantity: 9\n",
            "Image file quantity: 10\n",
            "Image file quantity: 11\n",
            "Image file quantity: 12\n",
            "Image file quantity: 13\n",
            "Image file quantity: 14\n",
            "Image file quantity: 15\n",
            "Image file quantity: 16\n",
            "Image file quantity: 17\n",
            "Image file quantity: 18\n",
            "Image file quantity: 19\n",
            "Image file quantity: 20\n",
            "Image file quantity: 21\n",
            "Image file quantity: 22\n",
            "Image file quantity: 23\n",
            "Image file quantity: 24\n",
            "Image file quantity: 25\n",
            "Image file quantity: 26\n",
            "Image file quantity: 27\n",
            "Image file quantity: 28\n",
            "Image file quantity: 29\n",
            "Image file quantity: 30\n",
            "Image file quantity: 31\n",
            "Image file quantity: 32\n",
            "Image file quantity: 33\n",
            "Image file quantity: 34\n",
            "Image file quantity: 35\n",
            "Image file quantity: 36\n",
            "Image file quantity: 37\n",
            "Image file quantity: 38\n",
            "Image file quantity: 39\n",
            "Image file quantity: 40\n",
            "Image file quantity: 41\n",
            "Image file quantity: 42\n",
            "Image file quantity: 43\n",
            "Image file quantity: 44\n",
            "Image file quantity: 45\n",
            "Image file quantity: 46\n",
            "Image file quantity: 47\n",
            "Image file quantity: 48\n",
            "------------ query: camisa | image list size: 48 | page: 0 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Image file quantity: 49\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Image file quantity: 50\n",
            "------------ query: camisa | image list size: 50 | page: 1 ------------\n",
            "Image file quantity: 51\n",
            "Image file quantity: 52\n",
            "Image file quantity: 53\n",
            "Image file quantity: 54\n",
            "Image file quantity: 55\n",
            "Image file quantity: 56\n",
            "Image file quantity: 57\n",
            "Image file quantity: 58\n",
            "Image file quantity: 59\n",
            "Image file quantity: 60\n",
            "Image file quantity: 61\n",
            "Image file quantity: 62\n",
            "Image file quantity: 63\n",
            "Image file quantity: 64\n",
            "Image file quantity: 65\n",
            "Image file quantity: 66\n",
            "Image file quantity: 67\n",
            "Image file quantity: 68\n",
            "Image file quantity: 69\n",
            "Image file quantity: 70\n",
            "Image file quantity: 71\n",
            "Image file quantity: 72\n",
            "Image file quantity: 73\n",
            "Image file quantity: 74\n",
            "Image file quantity: 75\n",
            "Image file quantity: 76\n",
            "Image file quantity: 77\n",
            "Image file quantity: 78\n",
            "Image file quantity: 79\n",
            "Image file quantity: 80\n",
            "Warning: Duplicate file detected\n",
            "Image file quantity: 81\n",
            "Image file quantity: 82\n",
            "Image file quantity: 83\n",
            "Image file quantity: 84\n",
            "Image file quantity: 85\n",
            "Image file quantity: 86\n",
            "Image file quantity: 87\n",
            "Image file quantity: 88\n",
            "Image file quantity: 89\n",
            "Image file quantity: 90\n",
            "Image file quantity: 91\n",
            "Image file quantity: 92\n",
            "Image file quantity: 93\n",
            "Image file quantity: 94\n",
            "Image file quantity: 95\n",
            "Image file quantity: 96\n",
            "Image file quantity: 97\n",
            "------------ query: bermuda | image list size: 97 | page: 0 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 1 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 2 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 3 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 4 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 5 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 6 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 7 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 8 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 9 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 10 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 11 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "------------ query: bermuda | image list size: 97 | page: 12 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Image file quantity: 1\n",
            "Image file quantity: 2\n",
            "------------ query: bermuda | image list size: 99 | page: 13 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Image file quantity: 1\n",
            "------------ query: bermuda | image list size: 100 | page: 14 ------------\n",
            "Image file quantity: 1\n",
            "Image file quantity: 2\n",
            "Image file quantity: 3\n",
            "Image file quantity: 4\n",
            "Image file quantity: 5\n",
            "Image file quantity: 6\n",
            "Image file quantity: 7\n",
            "Image file quantity: 8\n",
            "Image file quantity: 9\n",
            "Image file quantity: 10\n",
            "Image file quantity: 11\n",
            "Image file quantity: 12\n",
            "Image file quantity: 13\n",
            "Image file quantity: 14\n",
            "Image file quantity: 15\n",
            "Image file quantity: 16\n",
            "Image file quantity: 17\n",
            "Image file quantity: 18\n",
            "Image file quantity: 19\n",
            "Image file quantity: 20\n",
            "Image file quantity: 21\n",
            "Image file quantity: 22\n",
            "Image file quantity: 23\n",
            "Image file quantity: 24\n",
            "Image file quantity: 25\n",
            "Image file quantity: 26\n",
            "Image file quantity: 27\n",
            "Image file quantity: 28\n",
            "Image file quantity: 29\n",
            "Image file quantity: 30\n",
            "Image file quantity: 31\n",
            "Image file quantity: 32\n",
            "Image file quantity: 33\n",
            "Image file quantity: 34\n",
            "Image file quantity: 35\n",
            "Image file quantity: 36\n",
            "Image file quantity: 37\n",
            "Image file quantity: 38\n",
            "Image file quantity: 39\n",
            "Image file quantity: 40\n",
            "Image file quantity: 41\n",
            "Image file quantity: 42\n",
            "Image file quantity: 43\n",
            "Image file quantity: 44\n",
            "Image file quantity: 45\n",
            "Image file quantity: 46\n",
            "Image file quantity: 47\n",
            "Image file quantity: 48\n",
            "------------ query: regata | image list size: 148 | page: 0 ------------\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Image file quantity: 1\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Warning: Duplicate file detected\n",
            "Image file quantity: 2\n",
            "------------ query: regata | image list size: 150 | page: 1 ------------\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "\n",
        "df = pd.DataFrame(gimages)\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 797
        },
        "id": "mX1QY44sDYaD",
        "outputId": "209380ce-dfbf-4f28-a71d-1fa1f25e1445"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                 title     tag  \\\n",
              "0    Oferta de Camisa Nike Brasil I 2022/23 Jogador...  camisa   \n",
              "1         Camisa de Sarja Endurance - Preta | Invictus  camisa   \n",
              "2    Camisa Manga Curta Slim em Algodão Fio a Fio -...  camisa   \n",
              "3    Camisa social branca masculina de microfibra m...  camisa   \n",
              "4    Camisa Social Masculina Slim Manga Longa Azul ...  camisa   \n",
              "..                                                 ...     ...   \n",
              "145                            REGATA MASCULINA MIZUNO  regata   \n",
              "146  Regata Branca Feminina Adulto | Ribana Poliést...  regata   \n",
              "147            Regata TFM Poliviscose | Branca - Elite  regata   \n",
              "148  Regata Algodão Branca - Compre Já - UW - Casa ...  regata   \n",
              "149  REGATA MASCULINA POLIÉSTER - MALHA PP - Kasa A...  regata   \n",
              "\n",
              "                                                  hash  \n",
              "0    325ce2742410c4e524309ac9567f14ea2fc6c2428bbbf9...  \n",
              "1    9fdd04717dc4c867218aa8012aa5d274b8b09ec6bb9ba3...  \n",
              "2    a651401f1bb22e16472c7a379e86e9d4063d144f428a75...  \n",
              "3    20d5256506faa1e05582f2902f21ae3f97f738ee59f3fb...  \n",
              "4    9e26734a8db81c66120bf2d21437c4e3a68f35e190c779...  \n",
              "..                                                 ...  \n",
              "145  7322428dd86f79e1c6453e7956e32c9829a4c6801b3673...  \n",
              "146  57a58d5397133bf5595dff294621c4dc6e61e39f8a8fab...  \n",
              "147  0bbce1938f9fc353da1e173960824c9e144098dbfab721...  \n",
              "148  c9b7db7ef2d0197ac77b0d31715f4f51e362469937d9d2...  \n",
              "149  4ed1ee15b902edd56f5474d76b33773384ca4cc00f73bd...  \n",
              "\n",
              "[150 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3677deb8-5a33-46c4-8c7a-662b83a1c42c\">\n",
              "    <div 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>title</th>\n",
              "      <th>tag</th>\n",
              "      <th>hash</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Oferta de Camisa Nike Brasil I 2022/23 Jogador...</td>\n",
              "      <td>camisa</td>\n",
              "      <td>325ce2742410c4e524309ac9567f14ea2fc6c2428bbbf9...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Camisa de Sarja Endurance - Preta | Invictus</td>\n",
              "      <td>camisa</td>\n",
              "      <td>9fdd04717dc4c867218aa8012aa5d274b8b09ec6bb9ba3...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Camisa Manga Curta Slim em Algodão Fio a Fio -...</td>\n",
              "      <td>camisa</td>\n",
              "      <td>a651401f1bb22e16472c7a379e86e9d4063d144f428a75...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Camisa social branca masculina de microfibra m...</td>\n",
              "      <td>camisa</td>\n",
              "      <td>20d5256506faa1e05582f2902f21ae3f97f738ee59f3fb...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Camisa Social Masculina Slim Manga Longa Azul ...</td>\n",
              "      <td>camisa</td>\n",
              "      <td>9e26734a8db81c66120bf2d21437c4e3a68f35e190c779...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>145</th>\n",
              "      <td>REGATA MASCULINA MIZUNO</td>\n",
              "      <td>regata</td>\n",
              "      <td>7322428dd86f79e1c6453e7956e32c9829a4c6801b3673...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>146</th>\n",
              "      <td>Regata Branca Feminina Adulto | Ribana Poliést...</td>\n",
              "      <td>regata</td>\n",
              "      <td>57a58d5397133bf5595dff294621c4dc6e61e39f8a8fab...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>147</th>\n",
              "      <td>Regata TFM Poliviscose | Branca - Elite</td>\n",
              "      <td>regata</td>\n",
              "      <td>0bbce1938f9fc353da1e173960824c9e144098dbfab721...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>148</th>\n",
              "      <td>Regata Algodão Branca - Compre Já - UW - Casa ...</td>\n",
              "      <td>regata</td>\n",
              "      <td>c9b7db7ef2d0197ac77b0d31715f4f51e362469937d9d2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>149</th>\n",
              "      <td>REGATA MASCULINA POLIÉSTER - MALHA PP - Kasa A...</td>\n",
              "      <td>regata</td>\n",
              "      <td>4ed1ee15b902edd56f5474d76b33773384ca4cc00f73bd...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>150 rows × 3 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3677deb8-5a33-46c4-8c7a-662b83a1c42c')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-3677deb8-5a33-46c4-8c7a-662b83a1c42c 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-3677deb8-5a33-46c4-8c7a-662b83a1c42c');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    }
  ]
}