Exploratory_data_analysis.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/sammitako/CS-GY-6513-Big-Data/blob/master/Exploratory_data_analysis.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "b076c570",
      "metadata": {
        "scrolled": true,
        "id": "b076c570",
        "outputId": "a1049ca6-9ce9-4d56-85ca-24c42d3d8bd2"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Defaulting to user installation because normal site-packages is not writeable\n",
            "Requirement already satisfied: pyarrow in /opt/conda/miniconda3/lib/python3.8/site-packages (2.0.0)\n",
            "Requirement already satisfied: numpy>=1.14 in /opt/conda/miniconda3/lib/python3.8/site-packages (from pyarrow) (1.19.5)\n",
            "Defaulting to user installation because normal site-packages is not writeable\n",
            "Requirement already satisfied: fastparquet in /opt/conda/miniconda3/lib/python3.8/site-packages (0.5.0)\n",
            "Requirement already satisfied: numpy>=1.11 in /opt/conda/miniconda3/lib/python3.8/site-packages (from fastparquet) (1.19.5)\n",
            "Requirement already satisfied: numba>=0.49 in /opt/conda/miniconda3/lib/python3.8/site-packages (from fastparquet) (0.53.1)\n",
            "Requirement already satisfied: pandas>=1.1.0 in /opt/conda/miniconda3/lib/python3.8/site-packages (from fastparquet) (1.2.5)\n",
            "Requirement already satisfied: thrift>=0.11.0 in /opt/conda/miniconda3/lib/python3.8/site-packages (from fastparquet) (0.16.0)\n",
            "Requirement already satisfied: setuptools in /opt/conda/miniconda3/lib/python3.8/site-packages (from numba>=0.49->fastparquet) (59.8.0)\n",
            "Requirement already satisfied: llvmlite<0.37,>=0.36.0rc1 in /opt/conda/miniconda3/lib/python3.8/site-packages (from numba>=0.49->fastparquet) (0.36.0)\n",
            "Requirement already satisfied: python-dateutil>=2.7.3 in ./.local/lib/python3.8/site-packages (from pandas>=1.1.0->fastparquet) (2.8.2)\n",
            "Requirement already satisfied: pytz>=2017.3 in /opt/conda/miniconda3/lib/python3.8/site-packages (from pandas>=1.1.0->fastparquet) (2022.1)\n",
            "Requirement already satisfied: six>=1.7.2 in /opt/conda/miniconda3/lib/python3.8/site-packages (from thrift>=0.11.0->fastparquet) (1.16.0)\n"
          ]
        }
      ],
      "source": [
        "!pip install pyarrow\n",
        "!pip install fastparquet"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "200f1264",
      "metadata": {
        "scrolled": false,
        "id": "200f1264",
        "outputId": "b5bd00a3-7c99-4e01-d3a5-b23d8d82ac9f"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "Setting default log level to \"WARN\".\n",
            "To adjust logging level use sc.setLogLevel(newLevel). For SparkR, use setLogLevel(newLevel).\n",
            "23/11/15 15:45:47 INFO org.apache.spark.SparkEnv: Registering MapOutputTracker\n",
            "23/11/15 15:45:47 INFO org.apache.spark.SparkEnv: Registering BlockManagerMaster\n",
            "23/11/15 15:45:47 INFO org.apache.spark.SparkEnv: Registering BlockManagerMasterHeartbeat\n",
            "23/11/15 15:45:47 INFO org.apache.spark.SparkEnv: Registering OutputCommitCoordinator\n"
          ]
        }
      ],
      "source": [
        "from pyspark import SparkContext, SparkConf\n",
        "cf = SparkConf()\n",
        "cf.set(\"spark.submit.deployMode\",\"client\")\n",
        "sc = SparkContext.getOrCreate(cf)\n",
        "from pyspark.sql import SparkSession\n",
        "spark = SparkSession \\\n",
        "\t    .builder \\\n",
        "\t    .appName(\"Python Spark SQL basic example\") \\\n",
        "\t    .config(\"spark.some.config.option\", \"some-value\") \\\n",
        "\t    .getOrCreate()\n",
        ""
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# import libraries\n",
        "import os\n",
        "import pandas as pd\n",
        "import pyarrow.parquet as pq\n",
        "from pathlib import Path"
      ],
      "metadata": {
        "id": "SJRtylGE6wDq"
      },
      "id": "SJRtylGE6wDq",
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "id": "85722a22",
      "metadata": {
        "id": "85722a22"
      },
      "source": [
        "# File Reader"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "6528a25f",
      "metadata": {
        "id": "6528a25f"
      },
      "outputs": [],
      "source": [
        "processed_path = '/home/hp2229_nyu_edu/Project/WildLife/processed-data-oct'\n",
        "parquet_files = []\n",
        "\n",
        "for file in os.listdir(processed_path):\n",
        "    if file.endswith('.parquet'):\n",
        "        parquet_files.append(os.path.join(processed_path, file))"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "37fab3c1",
      "metadata": {
        "id": "37fab3c1"
      },
      "source": [
        "# Pre-processed parquet file"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "7360ca28",
      "metadata": {
        "scrolled": true,
        "id": "7360ca28",
        "outputId": "1f065446-949d-4036-c27c-fc2e7ef7a449"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Index(['url', 'title', 'text', 'domain', 'name', 'description', 'image',\n",
            "       'retrieved', 'production_data', 'category', 'price', 'currency',\n",
            "       'seller', 'seller_type', 'seller_url', 'location', 'ships to', 'id',\n",
            "       'loc_name', 'lat', 'lon', 'country', 'product', 'label_product',\n",
            "       'score_product', 'label', 'score'],\n",
            "      dtype='object')\n",
            "(27,)\n"
          ]
        }
      ],
      "source": [
        "import pandas as pd\n",
        "\n",
        "# Explore the first parquet file\n",
        "df = pd.read_parquet(parquet_files[0])\n",
        "print(df.columns)\n",
        "print(df.columns.shape)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "27fe4b1a",
      "metadata": {
        "id": "27fe4b1a",
        "outputId": "61f87cc0-6e43-4c28-f8ff-a55875f73cbf"
      },
      "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>url</th>\n",
              "      <th>title</th>\n",
              "      <th>text</th>\n",
              "      <th>domain</th>\n",
              "      <th>name</th>\n",
              "      <th>description</th>\n",
              "      <th>image</th>\n",
              "      <th>retrieved</th>\n",
              "      <th>production_data</th>\n",
              "      <th>category</th>\n",
              "      <th>...</th>\n",
              "      <th>id</th>\n",
              "      <th>loc_name</th>\n",
              "      <th>lat</th>\n",
              "      <th>lon</th>\n",
              "      <th>country</th>\n",
              "      <th>product</th>\n",
              "      <th>label_product</th>\n",
              "      <th>score_product</th>\n",
              "      <th>label</th>\n",
              "      <th>score</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>http://picclick.com/20mm-Red-Leather-Watch-Str...</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>20mm Red Leather Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>https://www.picclickimg.com/4asAAOSwAatkmpPo/2...</td>\n",
              "      <td>2023-10-03T22:06:06.750+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>5e1fa87e-5214-46d4-a0ef-d11ed86989cb</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.274589</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.648759</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>http://picclick.com/20pks-3-Fishing-Rock-Cod-R...</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>20pks 3\" Fishing Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/2...</td>\n",
              "      <td>2023-10-03T22:06:57.499+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>dbf4b8bc-b1f8-4453-88ae-b90b6f2785c2</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.628286</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.920214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>http://picclick.com/25-Unpainted-Saltwater-Rou...</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>25 Unpainted Saltwater Round Ball Jig Heads Re...</td>\n",
              "      <td>https://www.picclickimg.com/NH0AAOSwNmVkutkl/2...</td>\n",
              "      <td>2023-10-03T22:11:18.679+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>5eb63bfd-b489-4b28-8239-1cf46eac06c7</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.827852</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.866959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>http://picclick.com/2893-Kuhnert-1911-African-...</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich</td>\n",
              "      <td>2893 Kuhnert 1911 - African Ostrich. Giclee Fi...</td>\n",
              "      <td>https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...</td>\n",
              "      <td>2023-10-03T22:13:25.279+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>8ea71f75-0454-4775-85e1-da381f52e9f4</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.325769</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.998850</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>http://picclick.com/40-20Pcs-Soft-Fishing-Lure...</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>40/20Pcs Soft Fishing Lure Paddle Tail Swimbai...</td>\n",
              "      <td>https://www.picclickimg.com/qFgAAOSwsxdkrjzO/4...</td>\n",
              "      <td>2023-10-03T22:09:00.700+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>8d163d16-d4de-428f-9eef-44a69a421d22</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.699756</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.758410</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>http://picclick.com/Apt-9-Ladies-Chemise-Night...</td>\n",
              "      <td>APT 9 LADIES Chemise Nightgown Mauve With Blac...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>APT 9 LADIES Chemise Nightgown Mauve With Blac...</td>\n",
              "      <td>Apt 9 Ladies Chemise Nightgown Mauve With Blac...</td>\n",
              "      <td>https://www.picclickimg.com/VWkAAOSwxBtk8~Yt/A...</td>\n",
              "      <td>2023-10-03T22:06:01.308+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>8fab4cae-4230-422a-951e-f69ccd88fd35</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>APT 9 LADIES Chemise Nightgown Mauve With Blac...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.853579</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.885418</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>http://picclick.com/Artificial-Soft-baits-Stri...</td>\n",
              "      <td>ARTIFICIAL SOFT BAITS Strike King Rage Swimmer...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>ARTIFICIAL SOFT BAITS Strike King Rage Swimmer...</td>\n",
              "      <td>Artificial Soft baits Strike King Rage Swimmer...</td>\n",
              "      <td>https://www.picclickimg.com/wGoAAOSw1y5jC3js/A...</td>\n",
              "      <td>2023-10-03T22:08:40.274+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>5b07f0ce-2bbd-4f7e-a924-b4f0cf39074b</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>ARTIFICIAL SOFT BAITS Strike King Rage Swimmer...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.546885</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.714226</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>http://picclick.com/BARRONS-PSAT-NMSQT-19TH-ED...</td>\n",
              "      <td>BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...</td>\n",
              "      <td>BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...</td>\n",
              "      <td>https://www.picclickimg.com/f-EAAOSwXaFlG0oF/B...</td>\n",
              "      <td>2023-10-03T22:13:50.562+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>e9dd0702-59f5-4148-a3fd-14444fbb2a13</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.426800</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.954990</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>http://picclick.com/BATTLE-BEASTS-1987-Condora...</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>https://www.picclickimg.com/ZN0AAOSw6l9lB2yi/B...</td>\n",
              "      <td>2023-10-03T22:14:00.901+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>1a1fd99d-2f20-4806-aa02-5392683da20c</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.307560</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.999964</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>http://picclick.com/Boomtown-Green-Howling-Wol...</td>\n",
              "      <td>BOOMTOWN GREEN HOWLING Wolf Vintage Nature Ani...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>BOOMTOWN GREEN HOWLING Wolf Vintage Nature Ani...</td>\n",
              "      <td>Boomtown Green Howling Wolf Vintage Nature Ani...</td>\n",
              "      <td>https://www.picclickimg.com/yEIAAOSwG81lD8Wh/B...</td>\n",
              "      <td>2023-10-03T22:09:36.245+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>1aa83b88-4b51-4db5-9ebb-e5275079cf6e</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>BOOMTOWN GREEN HOWLING Wolf Vintage Nature Ani...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.672545</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.997833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>http://picclick.com/Bosporan-Kingdom-Sauromate...</td>\n",
              "      <td>BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE...</td>\n",
              "      <td>Bosporan Kingdom. Sauromates III. Denarius. AE...</td>\n",
              "      <td>https://www.picclickimg.com/kHYAAOSwCKJkAkZp/B...</td>\n",
              "      <td>2023-10-03T22:09:46.413+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>45aac35b-2704-4e67-99f5-b046ddb9a4ce</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.594813</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.998632</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>http://picclick.com/Botswana-Birds-on-Stamps-2...</td>\n",
              "      <td>BOTSWANA BIRDS ON Stamps 2020 MNH Owls African...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>BOTSWANA BIRDS ON Stamps 2020 MNH Owls African...</td>\n",
              "      <td>Botswana Birds on Stamps 2020 MNH Owls African...</td>\n",
              "      <td>https://www.picclickimg.com/rmUAAOSwoR1f~V~U/B...</td>\n",
              "      <td>2023-10-03T22:10:32.302+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>7521d2e6-d3d4-4673-8701-7efa1bdb1740</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>BOTSWANA BIRDS ON Stamps 2020 MNH Owls African...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.482197</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.999999</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>http://picclick.com/Bring-Good-Luck-Koi-Red-Fi...</td>\n",
              "      <td>BRING GOOD LUCK Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>BRING GOOD LUCK Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>Bring Good Luck Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>https://www.picclickimg.com/tnsAAOSwDZljSbGz/B...</td>\n",
              "      <td>2023-10-03T22:11:23.712+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>77eb0613-4adb-4fff-bdcd-c6a3b77e9921</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>BRING GOOD LUCK Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.426337</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.841318</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>http://picclick.com/Fossilized-Hemipristis-Sha...</td>\n",
              "      <td>FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...</td>\n",
              "      <td>Fossilized Hemipristis Shark Tooth 1 3/8 Inch ...</td>\n",
              "      <td>https://www.picclickimg.com/mVoAAOSwPyReqhRO/F...</td>\n",
              "      <td>2023-10-03T22:06:16.609+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>741b565f-1722-40ab-8414-e0f2b5262656</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.349030</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.999783</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>http://picclick.com/Funny-Ostrich-Poster-Vinta...</td>\n",
              "      <td>FUNNY OSTRICH POSTER Vintage Print Nice Butt G...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>FUNNY OSTRICH POSTER Vintage Print Nice Butt G...</td>\n",
              "      <td>Funny Ostrich Poster Vintage Print Nice Butt G...</td>\n",
              "      <td>https://www.picclickimg.com/SawAAOSwhU1kZn3q/F...</td>\n",
              "      <td>2023-10-03T22:07:54.274+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>152098a5-4ab2-46c7-830c-fdc71ec31f35</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>FUNNY OSTRICH POSTER Vintage Print Nice Butt G...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.437409</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.935444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>http://picclick.com/GREAT-WHITE-SHARK-2021-Top...</td>\n",
              "      <td>GREAT WHITE SHARK 2021 Topps Allen &amp; Ginter #D...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>GREAT WHITE SHARK 2021 Topps Allen &amp; Ginter #D...</td>\n",
              "      <td>GREAT WHITE SHARK 2021 Topps Allen &amp; Ginter #D...</td>\n",
              "      <td>https://www.picclickimg.com/O-8AAOSw9QtlGU1w/G...</td>\n",
              "      <td>2023-10-03T22:08:55.319+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>23d5b67d-106e-4235-a657-429f44075faa</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>GREAT WHITE SHARK 2021 Topps Allen &amp; Ginter #D...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.316585</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.969200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>http://picclick.com/GUESS-Sunglasses-Eyewear-G...</td>\n",
              "      <td>GUESS SUNGLASSES EYEWEAR Glasses Drawstring Po...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>GUESS SUNGLASSES EYEWEAR Glasses Drawstring Po...</td>\n",
              "      <td>GUESS Sunglasses Eyewear Glasses Drawstring Po...</td>\n",
              "      <td>https://www.picclickimg.com/UmIAAOSw5WVlGRUc/G...</td>\n",
              "      <td>2023-10-03T22:09:31.525+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>fec3f5b5-312a-47f8-ab7a-1c50fa56a829</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>GUESS SUNGLASSES EYEWEAR Glasses Drawstring Po...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.961095</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.604004</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>http://picclick.com/Genuine-Alligator-Head-5-S...</td>\n",
              "      <td>GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real...</td>\n",
              "      <td>GENUINE ALLIGATOR HEAD 5\" SKULL TAXIDERMY REAL...</td>\n",
              "      <td>https://www.picclickimg.com/DYQAAOSwEDZkyTAL/G...</td>\n",
              "      <td>2023-10-03T22:10:52.555+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>eae31545-96fc-4f26-8112-a06fcebb8aa2</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.423272</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.999942</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>http://picclick.com/Gift-Sticker-Mad-Bulldog-S...</td>\n",
              "      <td>GIFT STICKER : Mad Bulldog Strong Brave Attack...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>GIFT STICKER : Mad Bulldog Strong Brave Attack...</td>\n",
              "      <td>Gift Sticker : Mad Bulldog Strong Brave Attack...</td>\n",
              "      <td>https://www.picclickimg.com/M4kAAOSw8YlhIq7k/G...</td>\n",
              "      <td>2023-10-03T22:13:40.910+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>37326385-8c37-43ad-b315-a4e2ee9b896c</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>GIFT STICKER : Mad Bulldog Strong Brave Attack...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.374083</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.981659</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>http://picclick.com/Hot-Toys-Wolf-Predator-Act...</td>\n",
              "      <td>HOT TOYS WOLF Predator Action Figure - MMS443 ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>HOT TOYS WOLF Predator Action Figure - MMS443</td>\n",
              "      <td>Hot Toys Wolf Predator Action Figure - MMS443....</td>\n",
              "      <td>https://www.picclickimg.com/0GIAAOSw-l5lBhem/H...</td>\n",
              "      <td>2023-10-03T22:05:56.739+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>59701e85-f0a7-45d1-9d05-e7ea2e0654ee</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>HOT TOYS WOLF Predator Action Figure - MMS443 ...</td>\n",
              "      <td>a toy</td>\n",
              "      <td>0.327783</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.999666</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>http://picclick.com/Hunthouse-Yozuri-Style-Las...</td>\n",
              "      <td>HUNTHOUSE YOZURI STYLE Laser Minnow Lure for B...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>HUNTHOUSE YOZURI STYLE Laser Minnow Lure for B...</td>\n",
              "      <td>Hunthouse Yozuri Style Laser Minnow Lure for B...</td>\n",
              "      <td>https://www.picclickimg.com/Xd8AAOSwKExhCW10/H...</td>\n",
              "      <td>2023-10-03T22:06:12.055+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>c6805f4f-9e59-4665-86ce-79986b7a4957</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>HUNTHOUSE YOZURI STYLE Laser Minnow Lure for B...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.779278</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.881105</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>http://picclick.com/Hyaena-Spelea-Ursus-Speleu...</td>\n",
              "      <td>HYAENA SPELEA URSUS Speleus Felis Canis Hyena ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>HYAENA SPELEA URSUS Speleus Felis Canis Hyena ...</td>\n",
              "      <td>Hyaena Spelea Ursus Speleus Felis Canis Hyena ...</td>\n",
              "      <td>https://www.picclickimg.com/5e0AAOSwraBgFLpw/H...</td>\n",
              "      <td>2023-10-03T22:06:37.138+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>12af0c31-177b-47dc-827d-25a0c850ce39</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>HYAENA SPELEA URSUS Speleus Felis Canis Hyena ...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.378279</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.883996</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>http://picclick.com/Im-Scary-Without-A-Costume...</td>\n",
              "      <td>I'M SCARY WITHOUT A Costume Shirt - Funny Hall...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>I'M SCARY WITHOUT A Costume Shirt - Funny Hall...</td>\n",
              "      <td>I'm Scary Without A Costume Shirt - Funny Hall...</td>\n",
              "      <td>https://www.picclickimg.com/9L8AAOSwjPVdtfkh/I...</td>\n",
              "      <td>2023-10-03T22:06:42.563+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>b710353c-31e7-4f2c-9ca8-0c5b553cd364</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>I'M SCARY WITHOUT A Costume Shirt - Funny Hall...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.825524</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.996483</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>http://picclick.com/Japan-Kaiyodo-Furuta-Megam...</td>\n",
              "      <td>JAPAN KAIYODO FURUTA Megamouth Shark Fish Real...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>JAPAN KAIYODO FURUTA Megamouth Shark Fish Real...</td>\n",
              "      <td>Japan Kaiyodo Furuta Megamouth Shark Fish Real...</td>\n",
              "      <td>https://www.picclickimg.com/6mgAAOSwNj5dFh8u/J...</td>\n",
              "      <td>2023-10-03T22:09:51.654+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>1abc48ae-2345-4827-82b1-03155f3b357f</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>JAPAN KAIYODO FURUTA Megamouth Shark Fish Real...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.376070</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.996852</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>http://picclick.com/Javelin-Beetle-2-Pact-Ritu...</td>\n",
              "      <td>JAVELIN BEETLE &amp; 2 Pact Ritual PP01-EN012 PP01...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>JAVELIN BEETLE &amp; 2 Pact Ritual PP01-EN012 PP01...</td>\n",
              "      <td>Javelin Beetle &amp; 2 Pact Ritual PP01-EN012 PP01...</td>\n",
              "      <td>https://www.picclickimg.com/ELIAAOSw~SxkGZC1/J...</td>\n",
              "      <td>2023-10-03T22:10:01.881+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>84432345-3e7d-4f96-ba3c-c91ff6a54a43</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>JAVELIN BEETLE &amp; 2 Pact Ritual PP01-EN012 PP01...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.497031</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.882093</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>http://picclick.com/KAHALA-Mens-Avi-Collection...</td>\n",
              "      <td>KAHALA MENS AVI Collection Hawaiian Aloha Shir...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>KAHALA MENS AVI Collection Hawaiian Aloha Shir...</td>\n",
              "      <td>KAHALA Mens Avi Collection Hawaiian Aloha Shir...</td>\n",
              "      <td>https://www.picclickimg.com/0hsAAOSwt~Ji1wkj/K...</td>\n",
              "      <td>2023-10-03T22:12:29.377+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>2d527a52-b2ac-4d66-8696-cff8e4a75f05</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>KAHALA MENS AVI Collection Hawaiian Aloha Shir...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.542786</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.999344</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>http://picclick.com/Kaiyodo-Capsule-Q-Museum-F...</td>\n",
              "      <td>KAIYODO CAPSULE Q Museum  Figure Hirazugensei ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>KAIYODO CAPSULE Q Museum  Figure Hirazugensei ...</td>\n",
              "      <td>Kaiyodo Capsule Q Museum Figure Hirazugensei B...</td>\n",
              "      <td>https://www.picclickimg.com/TFwAAOSwBiBjeyMY/K...</td>\n",
              "      <td>2023-10-03T22:12:54.585+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>03d2c914-4291-46b8-88f6-33e7302febf1</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>KAIYODO CAPSULE Q Museum  Figure Hirazugensei ...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.327119</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.906765</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>http://picclick.com/Kaiyodo-Kabaya-Japan-Exclu...</td>\n",
              "      <td>KAIYODO KABAYA JAPAN Exclusive Japanese rhinoc...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>KAIYODO KABAYA JAPAN Exclusive Japanese rhinoc...</td>\n",
              "      <td>Kaiyodo Kabaya Japan Exclusive Japanese rhinoc...</td>\n",
              "      <td>https://www.picclickimg.com/nw8AAOSwSqJfmcKO/K...</td>\n",
              "      <td>2023-10-03T22:12:59.822+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>8dc77c3e-6317-412d-80f7-eec7b7fc14fc</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>KAIYODO KABAYA JAPAN Exclusive Japanese rhinoc...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.406265</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.996131</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>http://picclick.com/Kaiyodo-Wild-Rush-2-Wild-A...</td>\n",
              "      <td>KAIYODO WILD RUSH 2 Wild Animal Mini Figure Sp...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>KAIYODO WILD RUSH 2 Wild Animal Mini Figure Sp...</td>\n",
              "      <td>Kaiyodo Wild Rush 2 Wild Animal Mini Figure Sp...</td>\n",
              "      <td>https://www.picclickimg.com/MyAAAOSw7SZejE0u/K...</td>\n",
              "      <td>2023-10-03T22:13:04.998+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>6c5a5699-48cd-4057-b301-af9b63d08571</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>KAIYODO WILD RUSH 2 Wild Animal Mini Figure Sp...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.294887</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.979462</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>http://picclick.com/SALT-LIFE-ANCHOR-SIGNATURE...</td>\n",
              "      <td>SALT LIFE ANCHOR &amp; SIGNATURE \"WHITE\"  MEDIUM 1...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>SALT LIFE ANCHOR &amp; SIGNATURE \"WHITE\"  MEDIUM 1...</td>\n",
              "      <td>SALT LIFE ANCHOR &amp; SIGNATURE \"WHITE\" MEDIUM 12...</td>\n",
              "      <td>https://www.picclickimg.com/TdAAAOSwRsliqn8X/S...</td>\n",
              "      <td>2023-10-03T22:05:51.549+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>1d9e1a59-10ac-411e-8647-5c941d685e53</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>SALT LIFE ANCHOR &amp; SIGNATURE \"WHITE\"  MEDIUM 1...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.667840</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.886176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>http://picclick.com/Sao-Tome-2013-Fauna-Of-Afr...</td>\n",
              "      <td>SAO TOME  2013  Fauna Of Africa Nile Crocodile...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>SAO TOME  2013  Fauna Of Africa Nile Crocodile...</td>\n",
              "      <td>SAO TOME 2013 FAUNA OF AFRICA NILE CROCODILE S...</td>\n",
              "      <td>https://www.picclickimg.com/px8AAOxy9ERSRJab/S...</td>\n",
              "      <td>2023-10-03T22:08:44.968+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>559896ee-7433-4bce-999a-ee9bc99f800b</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>SAO TOME  2013  Fauna Of Africa Nile Crocodile...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.616697</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.999612</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>http://picclick.com/Sawfish-Carpenter-shark-Ra...</td>\n",
              "      <td>SAWFISH, CARPENTER SHARK, Ray, Very Realistic ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>SAWFISH, CARPENTER SHARK, Ray, Very Realistic ...</td>\n",
              "      <td>Sawfish, Carpenter shark, Ray, Very Realistic ...</td>\n",
              "      <td>https://www.picclickimg.com/JjcAAOSw2-9jBVsH/S...</td>\n",
              "      <td>2023-10-03T22:09:05.676+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>763b326d-f0e7-4b41-bbc7-56bb68c6f419</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>SAWFISH, CARPENTER SHARK, Ray, Very Realistic ...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.346656</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.738583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>http://picclick.com/Shimano-Butterfly-Flat-Fal...</td>\n",
              "      <td>SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat...</td>\n",
              "      <td>Shimano Butterfly Flat-Fall Jig - Sinking Flat...</td>\n",
              "      <td>https://www.picclickimg.com/vzMAAOSwNlldoaPQ/S...</td>\n",
              "      <td>2023-10-03T22:12:14.353+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>fc1862df-732f-4b6b-af46-7e4d27457c6a</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.355850</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.820385</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>http://picclick.com/US-Stamp-Scott-4804-March-...</td>\n",
              "      <td>US STAMP SCOTT# 4804 March on Washington, 50th...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>US STAMP SCOTT# 4804 March on Washington, 50th...</td>\n",
              "      <td>US Stamp Scott# 4804 March on Washington, 50th...</td>\n",
              "      <td>https://www.picclickimg.com/cq8AAOSwaIBkxFMb/U...</td>\n",
              "      <td>2023-10-03T22:05:41.239+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>a0425f55-2e12-4824-b2b7-632f628353f4</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>US STAMP SCOTT# 4804 March on Washington, 50th...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.645893</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.999915</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>http://picclick.com/Vintage-80s-Wolf-Minnesota...</td>\n",
              "      <td>VINTAGE 80S WOLF Minnesota T Shirt 1987 Single...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>VINTAGE 80S WOLF Minnesota T Shirt 1987 Single...</td>\n",
              "      <td>Vintage 80s Wolf Minnesota T Shirt 1987 Single...</td>\n",
              "      <td>https://www.picclickimg.com/nPwAAOSwwRplDPDU/V...</td>\n",
              "      <td>2023-10-03T22:07:18.158+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>8776946c-e91f-487b-b488-afcb33285bc2</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>VINTAGE 80S WOLF Minnesota T Shirt 1987 Single...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.410971</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.997274</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>http://picclick.com/Vintage-Animal-Postcard-RE...</td>\n",
              "      <td>VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUF...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUF...</td>\n",
              "      <td>Vintage Animal Postcard RED WOLF (CANIS RUFUS)...</td>\n",
              "      <td>https://www.picclickimg.com/zuoAAOSw4A1fzCd1/V...</td>\n",
              "      <td>2023-10-03T22:07:33.827+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>2df874f0-2290-4c4c-b4d5-e7b485abfbab</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUF...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.750289</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.833897</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>http://picclick.com/Vintage-Delta-Pro-Weight-G...</td>\n",
              "      <td>VINTAGE DELTA PRO Weight - Gray Wolf / Black W...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>VINTAGE DELTA PRO Weight - Gray Wolf / Black W...</td>\n",
              "      <td>Vintage Delta Pro Weight - Gray Wolf / Black W...</td>\n",
              "      <td>https://www.picclickimg.com/HOEAAOSw3QFlBGq2/V...</td>\n",
              "      <td>2023-10-03T22:07:38.583+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>4984ad7d-880d-4f1f-9e75-139c0ffe3d7e</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>VINTAGE DELTA PRO Weight - Gray Wolf / Black W...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.479547</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.691014</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>http://picclick.com/Vintage-Postcard-1907-Happ...</td>\n",
              "      <td>VINTAGE POSTCARD 1907 Happy Thanksgiving Ostri...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>VINTAGE POSTCARD 1907 Happy Thanksgiving Ostri...</td>\n",
              "      <td>Vintage Postcard 1907 Happy Thanksgiving Ostri...</td>\n",
              "      <td>https://www.picclickimg.com/1xgAAOSwuOxjWe~Y/V...</td>\n",
              "      <td>2023-10-03T22:08:24.740+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>18fefee1-f195-4f13-9b43-0f945ab9f50f</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>VINTAGE POSTCARD 1907 Happy Thanksgiving Ostri...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.446144</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.998603</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>http://picclick.com/Vintage-Wolf-Nature-T-Shir...</td>\n",
              "      <td>VINTAGE WOLF  Nature T-Shirt. Size Adult Large...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>VINTAGE WOLF  Nature T-Shirt. Size Adult Large...</td>\n",
              "      <td>Vintage Wolf Nature T-Shirt. Size Adult Large ...</td>\n",
              "      <td>https://www.picclickimg.com/bNgAAOSwSPhlBIsB/V...</td>\n",
              "      <td>2023-10-03T22:09:10.553+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>d2629803-b341-4697-9082-5d127881e3ce</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>VINTAGE WOLF  Nature T-Shirt. Size Adult Large...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.435287</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.991418</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>http://picclick.com/Wasserl%C3%A4ufer-Strandl%...</td>\n",
              "      <td>WATERRUNNER BEACH RUNNER tringa bird birds lit...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>WATERRUNNER BEACH RUNNER tringa bird birds lit...</td>\n",
              "      <td>Waterrunner beach runner tringa bird birds lit...</td>\n",
              "      <td>https://www.picclickimg.com/qWgAAOSwKnBkrvzM/W...</td>\n",
              "      <td>2023-10-03T22:10:06.956+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>2742be58-dcbc-45e2-8346-4f3b1f56b903</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>WATERRUNNER BEACH RUNNER tringa bird birds lit...</td>\n",
              "      <td>a print of an animal</td>\n",
              "      <td>0.380378</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.995933</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>http://picclick.com/White-Tiger-Cub-T-Shirt-Pi...</td>\n",
              "      <td>WHITE TIGER &amp; Cub T Shirt Pick Your Size Youth...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>WHITE TIGER &amp; Cub T Shirt Pick Your Size Youth...</td>\n",
              "      <td>White Tiger &amp; Cub T Shirt Pick Your Size Youth...</td>\n",
              "      <td>https://www.picclickimg.com/R7AAAOSwstNawoWy/W...</td>\n",
              "      <td>2023-10-03T22:10:42.837+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>66d3867d-479f-4e8b-ab6c-720fb5eebc71</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>WHITE TIGER &amp; Cub T Shirt Pick Your Size Youth...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.483208</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.941009</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>http://picclick.com/Wild-Alligator-Envelope-Wa...</td>\n",
              "      <td>WILD ALLIGATOR ENVELOPE Wallet Credit Card cas...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>WILD ALLIGATOR ENVELOPE Wallet Credit Card cas...</td>\n",
              "      <td>Wild Alligator Envelope Wallet Credit Card cas...</td>\n",
              "      <td>https://www.picclickimg.com/hjwAAOSwBfZhhCT3/W...</td>\n",
              "      <td>2023-10-03T22:10:47.623+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>f605ef03-462d-4fc3-b9c5-45ea4bb505c3</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>WILD ALLIGATOR ENVELOPE Wallet Credit Card cas...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.398545</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.738256</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>http://picclick.com/Wolf-Face-License-Plate-Ne...</td>\n",
              "      <td>WOLF FACE, LICENSE Plate New Car Tag Metal Alu...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>WOLF FACE, LICENSE Plate New Car Tag Metal Alu...</td>\n",
              "      <td>Wolf Face, License Plate New Car Tag Metal Alu...</td>\n",
              "      <td>https://www.picclickimg.com/A0EAAOSwj7hesXWG/W...</td>\n",
              "      <td>2023-10-03T22:12:24.404+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>b3b0712a-42a1-4f60-ab53-508c7e1f02fe</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>WOLF FACE, LICENSE Plate New Car Tag Metal Alu...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.330337</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.509469</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>http://picclick.com/Wolf-Tooth-Seatpost-Clamp-...</td>\n",
              "      <td>WOLF TOOTH SEATPOST Clamp - 34.9mm Red $14.99 ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>WOLF TOOTH SEATPOST Clamp - 34.9mm Red</td>\n",
              "      <td>Wolf Tooth Seatpost Clamp - 34.9mm Red. Bought...</td>\n",
              "      <td>https://www.picclickimg.com/p~8AAOSwCqllF1gl/W...</td>\n",
              "      <td>2023-10-03T22:12:34.596+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>a021155f-0139-422c-b99f-cface3fd1908</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>WOLF TOOTH SEATPOST Clamp - 34.9mm Red $14.99 ...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.363676</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.668809</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>http://picclick.com/Wolf-Wolves-Bark-At-The-Fu...</td>\n",
              "      <td>WOLF WOLVES BARK At The Full Moon The Mountain...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>WOLF WOLVES BARK At The Full Moon The Mountain...</td>\n",
              "      <td>Wolf Wolves Bark At The Full Moon The Mountain...</td>\n",
              "      <td>https://www.picclickimg.com/Q~cAAOSwDJZb5hPe/W...</td>\n",
              "      <td>2023-10-03T22:12:49.954+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>fd4d47b0-3d8b-413c-b5a8-b62400f7063b</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>WOLF WOLVES BARK At The Full Moon The Mountain...</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>0.375287</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.559804</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>http://www.gumtree.com.au/s-accounts-receivabl...</td>\n",
              "      <td>Accounts Receivable/Credit Control Jobs | Gumt...</td>\n",
              "      <td>Accounts Receivable/Credit Control Jobs | Gumt...</td>\n",
              "      <td>gumtree.com.au</td>\n",
              "      <td>Free local classified ads</td>\n",
              "      <td>Find Accounts Receivable/Credit Control Jobs a...</td>\n",
              "      <td>https://static.gumtree.com.au/master-7aa11a336...</td>\n",
              "      <td>2023-10-03T22:06:58.451+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>9a6e44a7-bdd3-460d-b16c-e66517b01a8f</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>Accounts Receivable/Credit Control Jobs | Gumt...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.385943</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.788725</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>http://www.gumtree.com.au/s-ad/bacchus-marsh/o...</td>\n",
              "      <td>None</td>\n",
              "      <td>\\n</td>\n",
              "      <td>gumtree.com.au</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>2023-10-03T22:10:27.007+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>82ab9bfb-cf58-4325-98ed-6b284eed404b</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.380854</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.982064</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>http://www.gumtree.com.au/s-ad/badgingarra/oth...</td>\n",
              "      <td>None</td>\n",
              "      <td>\\n</td>\n",
              "      <td>gumtree.com.au</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>2023-10-03T22:08:39.745+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>27ef228a-ab2f-4144-a18e-ed1900ba0208</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.380854</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.982064</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>http://www.gumtree.com.au/s-ad/ballina/cooking...</td>\n",
              "      <td>2x20L Pull Out Bin - White | Cooking Accessori...</td>\n",
              "      <td>2x20L Pull Out Bin - White | Cooking Accessori...</td>\n",
              "      <td>gumtree.com.au</td>\n",
              "      <td>2x20L Pull Out Bin - White | Cooking Accessori...</td>\n",
              "      <td>Dual Pull Out Bin\\n\\nPractical and aesthetical...</td>\n",
              "      <td>https://gumtreeau-res.cloudinary.com/image/pri...</td>\n",
              "      <td>2023-10-03T22:09:41.648+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>f33f8676-56fb-400a-87c8-ef74b80a6dab</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>2x20L Pull Out Bin - White | Cooking Accessori...</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.972654</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.922411</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>http://www.gumtree.com.au/s-ad/balmain/bags/br...</td>\n",
              "      <td>None</td>\n",
              "      <td>\\n</td>\n",
              "      <td>gumtree.com.au</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>2023-10-03T22:07:58.665+0000</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>962fa2bd-ccd0-44f8-8a71-c5df028b5d5f</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>an object</td>\n",
              "      <td>0.380854</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.982064</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>50 rows × 27 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                  url  \\\n",
              "0   http://picclick.com/20mm-Red-Leather-Watch-Str...   \n",
              "1   http://picclick.com/20pks-3-Fishing-Rock-Cod-R...   \n",
              "2   http://picclick.com/25-Unpainted-Saltwater-Rou...   \n",
              "3   http://picclick.com/2893-Kuhnert-1911-African-...   \n",
              "4   http://picclick.com/40-20Pcs-Soft-Fishing-Lure...   \n",
              "5   http://picclick.com/Apt-9-Ladies-Chemise-Night...   \n",
              "6   http://picclick.com/Artificial-Soft-baits-Stri...   \n",
              "7   http://picclick.com/BARRONS-PSAT-NMSQT-19TH-ED...   \n",
              "8   http://picclick.com/BATTLE-BEASTS-1987-Condora...   \n",
              "9   http://picclick.com/Boomtown-Green-Howling-Wol...   \n",
              "10  http://picclick.com/Bosporan-Kingdom-Sauromate...   \n",
              "11  http://picclick.com/Botswana-Birds-on-Stamps-2...   \n",
              "12  http://picclick.com/Bring-Good-Luck-Koi-Red-Fi...   \n",
              "13  http://picclick.com/Fossilized-Hemipristis-Sha...   \n",
              "14  http://picclick.com/Funny-Ostrich-Poster-Vinta...   \n",
              "15  http://picclick.com/GREAT-WHITE-SHARK-2021-Top...   \n",
              "16  http://picclick.com/GUESS-Sunglasses-Eyewear-G...   \n",
              "17  http://picclick.com/Genuine-Alligator-Head-5-S...   \n",
              "18  http://picclick.com/Gift-Sticker-Mad-Bulldog-S...   \n",
              "19  http://picclick.com/Hot-Toys-Wolf-Predator-Act...   \n",
              "20  http://picclick.com/Hunthouse-Yozuri-Style-Las...   \n",
              "21  http://picclick.com/Hyaena-Spelea-Ursus-Speleu...   \n",
              "22  http://picclick.com/Im-Scary-Without-A-Costume...   \n",
              "23  http://picclick.com/Japan-Kaiyodo-Furuta-Megam...   \n",
              "24  http://picclick.com/Javelin-Beetle-2-Pact-Ritu...   \n",
              "25  http://picclick.com/KAHALA-Mens-Avi-Collection...   \n",
              "26  http://picclick.com/Kaiyodo-Capsule-Q-Museum-F...   \n",
              "27  http://picclick.com/Kaiyodo-Kabaya-Japan-Exclu...   \n",
              "28  http://picclick.com/Kaiyodo-Wild-Rush-2-Wild-A...   \n",
              "29  http://picclick.com/SALT-LIFE-ANCHOR-SIGNATURE...   \n",
              "30  http://picclick.com/Sao-Tome-2013-Fauna-Of-Afr...   \n",
              "31  http://picclick.com/Sawfish-Carpenter-shark-Ra...   \n",
              "32  http://picclick.com/Shimano-Butterfly-Flat-Fal...   \n",
              "33  http://picclick.com/US-Stamp-Scott-4804-March-...   \n",
              "34  http://picclick.com/Vintage-80s-Wolf-Minnesota...   \n",
              "35  http://picclick.com/Vintage-Animal-Postcard-RE...   \n",
              "36  http://picclick.com/Vintage-Delta-Pro-Weight-G...   \n",
              "37  http://picclick.com/Vintage-Postcard-1907-Happ...   \n",
              "38  http://picclick.com/Vintage-Wolf-Nature-T-Shir...   \n",
              "39  http://picclick.com/Wasserl%C3%A4ufer-Strandl%...   \n",
              "40  http://picclick.com/White-Tiger-Cub-T-Shirt-Pi...   \n",
              "41  http://picclick.com/Wild-Alligator-Envelope-Wa...   \n",
              "42  http://picclick.com/Wolf-Face-License-Plate-Ne...   \n",
              "43  http://picclick.com/Wolf-Tooth-Seatpost-Clamp-...   \n",
              "44  http://picclick.com/Wolf-Wolves-Bark-At-The-Fu...   \n",
              "45  http://www.gumtree.com.au/s-accounts-receivabl...   \n",
              "46  http://www.gumtree.com.au/s-ad/bacchus-marsh/o...   \n",
              "47  http://www.gumtree.com.au/s-ad/badgingarra/oth...   \n",
              "48  http://www.gumtree.com.au/s-ad/ballina/cooking...   \n",
              "49  http://www.gumtree.com.au/s-ad/balmain/bags/br...   \n",
              "\n",
              "                                                title  \\\n",
              "0   20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1   20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2   25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3   2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   \n",
              "4   40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "5   APT 9 LADIES Chemise Nightgown Mauve With Blac...   \n",
              "6   ARTIFICIAL SOFT BAITS Strike King Rage Swimmer...   \n",
              "7   BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...   \n",
              "8   BATTLE BEASTS 1987 Condorassin figure LASER be...   \n",
              "9   BOOMTOWN GREEN HOWLING Wolf Vintage Nature Ani...   \n",
              "10  BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE...   \n",
              "11  BOTSWANA BIRDS ON Stamps 2020 MNH Owls African...   \n",
              "12  BRING GOOD LUCK Koi Red Fish Pendant Necklace ...   \n",
              "13  FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...   \n",
              "14  FUNNY OSTRICH POSTER Vintage Print Nice Butt G...   \n",
              "15  GREAT WHITE SHARK 2021 Topps Allen & Ginter #D...   \n",
              "16  GUESS SUNGLASSES EYEWEAR Glasses Drawstring Po...   \n",
              "17  GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real...   \n",
              "18  GIFT STICKER : Mad Bulldog Strong Brave Attack...   \n",
              "19  HOT TOYS WOLF Predator Action Figure - MMS443 ...   \n",
              "20  HUNTHOUSE YOZURI STYLE Laser Minnow Lure for B...   \n",
              "21  HYAENA SPELEA URSUS Speleus Felis Canis Hyena ...   \n",
              "22  I'M SCARY WITHOUT A Costume Shirt - Funny Hall...   \n",
              "23  JAPAN KAIYODO FURUTA Megamouth Shark Fish Real...   \n",
              "24  JAVELIN BEETLE & 2 Pact Ritual PP01-EN012 PP01...   \n",
              "25  KAHALA MENS AVI Collection Hawaiian Aloha Shir...   \n",
              "26  KAIYODO CAPSULE Q Museum  Figure Hirazugensei ...   \n",
              "27  KAIYODO KABAYA JAPAN Exclusive Japanese rhinoc...   \n",
              "28  KAIYODO WILD RUSH 2 Wild Animal Mini Figure Sp...   \n",
              "29  SALT LIFE ANCHOR & SIGNATURE \"WHITE\"  MEDIUM 1...   \n",
              "30  SAO TOME  2013  Fauna Of Africa Nile Crocodile...   \n",
              "31  SAWFISH, CARPENTER SHARK, Ray, Very Realistic ...   \n",
              "32  SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat...   \n",
              "33  US STAMP SCOTT# 4804 March on Washington, 50th...   \n",
              "34  VINTAGE 80S WOLF Minnesota T Shirt 1987 Single...   \n",
              "35  VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUF...   \n",
              "36  VINTAGE DELTA PRO Weight - Gray Wolf / Black W...   \n",
              "37  VINTAGE POSTCARD 1907 Happy Thanksgiving Ostri...   \n",
              "38  VINTAGE WOLF  Nature T-Shirt. Size Adult Large...   \n",
              "39  WATERRUNNER BEACH RUNNER tringa bird birds lit...   \n",
              "40  WHITE TIGER & Cub T Shirt Pick Your Size Youth...   \n",
              "41  WILD ALLIGATOR ENVELOPE Wallet Credit Card cas...   \n",
              "42  WOLF FACE, LICENSE Plate New Car Tag Metal Alu...   \n",
              "43  WOLF TOOTH SEATPOST Clamp - 34.9mm Red $14.99 ...   \n",
              "44  WOLF WOLVES BARK At The Full Moon The Mountain...   \n",
              "45  Accounts Receivable/Credit Control Jobs | Gumt...   \n",
              "46                                               None   \n",
              "47                                               None   \n",
              "48  2x20L Pull Out Bin - White | Cooking Accessori...   \n",
              "49                                               None   \n",
              "\n",
              "                                                 text          domain  \\\n",
              "0   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "1   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "2   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "3   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "4   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "5   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "6   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "7   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "8   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "9   \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "10  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "11  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "12  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "13  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "14  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "15  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "16  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "17  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "18  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "19  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "20  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "21  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "22  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "23  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "24  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "25  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "26  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "27  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "28  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "29  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "30  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "31  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "32  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "33  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "34  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "35  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "36  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "37  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "38  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "39  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "40  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "41  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "42  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "43  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "44  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...    picclick.com   \n",
              "45  Accounts Receivable/Credit Control Jobs | Gumt...  gumtree.com.au   \n",
              "46                                                 \\n  gumtree.com.au   \n",
              "47                                                 \\n  gumtree.com.au   \n",
              "48  2x20L Pull Out Bin - White | Cooking Accessori...  gumtree.com.au   \n",
              "49                                                 \\n  gumtree.com.au   \n",
              "\n",
              "                                                 name  \\\n",
              "0   20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1   20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2   25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3                 2893 KUHNERT 1911 - African Ostrich   \n",
              "4   40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "5   APT 9 LADIES Chemise Nightgown Mauve With Blac...   \n",
              "6   ARTIFICIAL SOFT BAITS Strike King Rage Swimmer...   \n",
              "7   BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...   \n",
              "8   BATTLE BEASTS 1987 Condorassin figure LASER be...   \n",
              "9   BOOMTOWN GREEN HOWLING Wolf Vintage Nature Ani...   \n",
              "10  BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE...   \n",
              "11  BOTSWANA BIRDS ON Stamps 2020 MNH Owls African...   \n",
              "12  BRING GOOD LUCK Koi Red Fish Pendant Necklace ...   \n",
              "13  FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...   \n",
              "14  FUNNY OSTRICH POSTER Vintage Print Nice Butt G...   \n",
              "15  GREAT WHITE SHARK 2021 Topps Allen & Ginter #D...   \n",
              "16  GUESS SUNGLASSES EYEWEAR Glasses Drawstring Po...   \n",
              "17  GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real...   \n",
              "18  GIFT STICKER : Mad Bulldog Strong Brave Attack...   \n",
              "19      HOT TOYS WOLF Predator Action Figure - MMS443   \n",
              "20  HUNTHOUSE YOZURI STYLE Laser Minnow Lure for B...   \n",
              "21  HYAENA SPELEA URSUS Speleus Felis Canis Hyena ...   \n",
              "22  I'M SCARY WITHOUT A Costume Shirt - Funny Hall...   \n",
              "23  JAPAN KAIYODO FURUTA Megamouth Shark Fish Real...   \n",
              "24  JAVELIN BEETLE & 2 Pact Ritual PP01-EN012 PP01...   \n",
              "25  KAHALA MENS AVI Collection Hawaiian Aloha Shir...   \n",
              "26  KAIYODO CAPSULE Q Museum  Figure Hirazugensei ...   \n",
              "27  KAIYODO KABAYA JAPAN Exclusive Japanese rhinoc...   \n",
              "28  KAIYODO WILD RUSH 2 Wild Animal Mini Figure Sp...   \n",
              "29  SALT LIFE ANCHOR & SIGNATURE \"WHITE\"  MEDIUM 1...   \n",
              "30  SAO TOME  2013  Fauna Of Africa Nile Crocodile...   \n",
              "31  SAWFISH, CARPENTER SHARK, Ray, Very Realistic ...   \n",
              "32  SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat...   \n",
              "33  US STAMP SCOTT# 4804 March on Washington, 50th...   \n",
              "34  VINTAGE 80S WOLF Minnesota T Shirt 1987 Single...   \n",
              "35  VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUF...   \n",
              "36  VINTAGE DELTA PRO Weight - Gray Wolf / Black W...   \n",
              "37  VINTAGE POSTCARD 1907 Happy Thanksgiving Ostri...   \n",
              "38  VINTAGE WOLF  Nature T-Shirt. Size Adult Large...   \n",
              "39  WATERRUNNER BEACH RUNNER tringa bird birds lit...   \n",
              "40  WHITE TIGER & Cub T Shirt Pick Your Size Youth...   \n",
              "41  WILD ALLIGATOR ENVELOPE Wallet Credit Card cas...   \n",
              "42  WOLF FACE, LICENSE Plate New Car Tag Metal Alu...   \n",
              "43             WOLF TOOTH SEATPOST Clamp - 34.9mm Red   \n",
              "44  WOLF WOLVES BARK At The Full Moon The Mountain...   \n",
              "45                          Free local classified ads   \n",
              "46                                               None   \n",
              "47                                               None   \n",
              "48  2x20L Pull Out Bin - White | Cooking Accessori...   \n",
              "49                                               None   \n",
              "\n",
              "                                          description  \\\n",
              "0   20mm Red Leather Watch Strap Real Flat Ostrich...   \n",
              "1   20pks 3\" Fishing Rock Cod Rig Twin Bulb Squids...   \n",
              "2   25 Unpainted Saltwater Round Ball Jig Heads Re...   \n",
              "3   2893 Kuhnert 1911 - African Ostrich. Giclee Fi...   \n",
              "4   40/20Pcs Soft Fishing Lure Paddle Tail Swimbai...   \n",
              "5   Apt 9 Ladies Chemise Nightgown Mauve With Blac...   \n",
              "6   Artificial Soft baits Strike King Rage Swimmer...   \n",
              "7   BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...   \n",
              "8   BATTLE BEASTS 1987 Condorassin figure LASER be...   \n",
              "9   Boomtown Green Howling Wolf Vintage Nature Ani...   \n",
              "10  Bosporan Kingdom. Sauromates III. Denarius. AE...   \n",
              "11  Botswana Birds on Stamps 2020 MNH Owls African...   \n",
              "12  Bring Good Luck Koi Red Fish Pendant Necklace ...   \n",
              "13  Fossilized Hemipristis Shark Tooth 1 3/8 Inch ...   \n",
              "14  Funny Ostrich Poster Vintage Print Nice Butt G...   \n",
              "15  GREAT WHITE SHARK 2021 Topps Allen & Ginter #D...   \n",
              "16  GUESS Sunglasses Eyewear Glasses Drawstring Po...   \n",
              "17  GENUINE ALLIGATOR HEAD 5\" SKULL TAXIDERMY REAL...   \n",
              "18  Gift Sticker : Mad Bulldog Strong Brave Attack...   \n",
              "19  Hot Toys Wolf Predator Action Figure - MMS443....   \n",
              "20  Hunthouse Yozuri Style Laser Minnow Lure for B...   \n",
              "21  Hyaena Spelea Ursus Speleus Felis Canis Hyena ...   \n",
              "22  I'm Scary Without A Costume Shirt - Funny Hall...   \n",
              "23  Japan Kaiyodo Furuta Megamouth Shark Fish Real...   \n",
              "24  Javelin Beetle & 2 Pact Ritual PP01-EN012 PP01...   \n",
              "25  KAHALA Mens Avi Collection Hawaiian Aloha Shir...   \n",
              "26  Kaiyodo Capsule Q Museum Figure Hirazugensei B...   \n",
              "27  Kaiyodo Kabaya Japan Exclusive Japanese rhinoc...   \n",
              "28  Kaiyodo Wild Rush 2 Wild Animal Mini Figure Sp...   \n",
              "29  SALT LIFE ANCHOR & SIGNATURE \"WHITE\" MEDIUM 12...   \n",
              "30  SAO TOME 2013 FAUNA OF AFRICA NILE CROCODILE S...   \n",
              "31  Sawfish, Carpenter shark, Ray, Very Realistic ...   \n",
              "32  Shimano Butterfly Flat-Fall Jig - Sinking Flat...   \n",
              "33  US Stamp Scott# 4804 March on Washington, 50th...   \n",
              "34  Vintage 80s Wolf Minnesota T Shirt 1987 Single...   \n",
              "35  Vintage Animal Postcard RED WOLF (CANIS RUFUS)...   \n",
              "36  Vintage Delta Pro Weight - Gray Wolf / Black W...   \n",
              "37  Vintage Postcard 1907 Happy Thanksgiving Ostri...   \n",
              "38  Vintage Wolf Nature T-Shirt. Size Adult Large ...   \n",
              "39  Waterrunner beach runner tringa bird birds lit...   \n",
              "40  White Tiger & Cub T Shirt Pick Your Size Youth...   \n",
              "41  Wild Alligator Envelope Wallet Credit Card cas...   \n",
              "42  Wolf Face, License Plate New Car Tag Metal Alu...   \n",
              "43  Wolf Tooth Seatpost Clamp - 34.9mm Red. Bought...   \n",
              "44  Wolf Wolves Bark At The Full Moon The Mountain...   \n",
              "45  Find Accounts Receivable/Credit Control Jobs a...   \n",
              "46                                               None   \n",
              "47                                               None   \n",
              "48  Dual Pull Out Bin\\n\\nPractical and aesthetical...   \n",
              "49                                               None   \n",
              "\n",
              "                                                image  \\\n",
              "0   https://www.picclickimg.com/4asAAOSwAatkmpPo/2...   \n",
              "1   https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/2...   \n",
              "2   https://www.picclickimg.com/NH0AAOSwNmVkutkl/2...   \n",
              "3   https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...   \n",
              "4   https://www.picclickimg.com/qFgAAOSwsxdkrjzO/4...   \n",
              "5   https://www.picclickimg.com/VWkAAOSwxBtk8~Yt/A...   \n",
              "6   https://www.picclickimg.com/wGoAAOSw1y5jC3js/A...   \n",
              "7   https://www.picclickimg.com/f-EAAOSwXaFlG0oF/B...   \n",
              "8   https://www.picclickimg.com/ZN0AAOSw6l9lB2yi/B...   \n",
              "9   https://www.picclickimg.com/yEIAAOSwG81lD8Wh/B...   \n",
              "10  https://www.picclickimg.com/kHYAAOSwCKJkAkZp/B...   \n",
              "11  https://www.picclickimg.com/rmUAAOSwoR1f~V~U/B...   \n",
              "12  https://www.picclickimg.com/tnsAAOSwDZljSbGz/B...   \n",
              "13  https://www.picclickimg.com/mVoAAOSwPyReqhRO/F...   \n",
              "14  https://www.picclickimg.com/SawAAOSwhU1kZn3q/F...   \n",
              "15  https://www.picclickimg.com/O-8AAOSw9QtlGU1w/G...   \n",
              "16  https://www.picclickimg.com/UmIAAOSw5WVlGRUc/G...   \n",
              "17  https://www.picclickimg.com/DYQAAOSwEDZkyTAL/G...   \n",
              "18  https://www.picclickimg.com/M4kAAOSw8YlhIq7k/G...   \n",
              "19  https://www.picclickimg.com/0GIAAOSw-l5lBhem/H...   \n",
              "20  https://www.picclickimg.com/Xd8AAOSwKExhCW10/H...   \n",
              "21  https://www.picclickimg.com/5e0AAOSwraBgFLpw/H...   \n",
              "22  https://www.picclickimg.com/9L8AAOSwjPVdtfkh/I...   \n",
              "23  https://www.picclickimg.com/6mgAAOSwNj5dFh8u/J...   \n",
              "24  https://www.picclickimg.com/ELIAAOSw~SxkGZC1/J...   \n",
              "25  https://www.picclickimg.com/0hsAAOSwt~Ji1wkj/K...   \n",
              "26  https://www.picclickimg.com/TFwAAOSwBiBjeyMY/K...   \n",
              "27  https://www.picclickimg.com/nw8AAOSwSqJfmcKO/K...   \n",
              "28  https://www.picclickimg.com/MyAAAOSw7SZejE0u/K...   \n",
              "29  https://www.picclickimg.com/TdAAAOSwRsliqn8X/S...   \n",
              "30  https://www.picclickimg.com/px8AAOxy9ERSRJab/S...   \n",
              "31  https://www.picclickimg.com/JjcAAOSw2-9jBVsH/S...   \n",
              "32  https://www.picclickimg.com/vzMAAOSwNlldoaPQ/S...   \n",
              "33  https://www.picclickimg.com/cq8AAOSwaIBkxFMb/U...   \n",
              "34  https://www.picclickimg.com/nPwAAOSwwRplDPDU/V...   \n",
              "35  https://www.picclickimg.com/zuoAAOSw4A1fzCd1/V...   \n",
              "36  https://www.picclickimg.com/HOEAAOSw3QFlBGq2/V...   \n",
              "37  https://www.picclickimg.com/1xgAAOSwuOxjWe~Y/V...   \n",
              "38  https://www.picclickimg.com/bNgAAOSwSPhlBIsB/V...   \n",
              "39  https://www.picclickimg.com/qWgAAOSwKnBkrvzM/W...   \n",
              "40  https://www.picclickimg.com/R7AAAOSwstNawoWy/W...   \n",
              "41  https://www.picclickimg.com/hjwAAOSwBfZhhCT3/W...   \n",
              "42  https://www.picclickimg.com/A0EAAOSwj7hesXWG/W...   \n",
              "43  https://www.picclickimg.com/p~8AAOSwCqllF1gl/W...   \n",
              "44  https://www.picclickimg.com/Q~cAAOSwDJZb5hPe/W...   \n",
              "45  https://static.gumtree.com.au/master-7aa11a336...   \n",
              "46                                               None   \n",
              "47                                               None   \n",
              "48  https://gumtreeau-res.cloudinary.com/image/pri...   \n",
              "49                                               None   \n",
              "\n",
              "                       retrieved production_data category  ...  \\\n",
              "0   2023-10-03T22:06:06.750+0000            None     None  ...   \n",
              "1   2023-10-03T22:06:57.499+0000            None     None  ...   \n",
              "2   2023-10-03T22:11:18.679+0000            None     None  ...   \n",
              "3   2023-10-03T22:13:25.279+0000            None     None  ...   \n",
              "4   2023-10-03T22:09:00.700+0000            None     None  ...   \n",
              "5   2023-10-03T22:06:01.308+0000            None     None  ...   \n",
              "6   2023-10-03T22:08:40.274+0000            None     None  ...   \n",
              "7   2023-10-03T22:13:50.562+0000            None     None  ...   \n",
              "8   2023-10-03T22:14:00.901+0000            None     None  ...   \n",
              "9   2023-10-03T22:09:36.245+0000            None     None  ...   \n",
              "10  2023-10-03T22:09:46.413+0000            None     None  ...   \n",
              "11  2023-10-03T22:10:32.302+0000            None     None  ...   \n",
              "12  2023-10-03T22:11:23.712+0000            None     None  ...   \n",
              "13  2023-10-03T22:06:16.609+0000            None     None  ...   \n",
              "14  2023-10-03T22:07:54.274+0000            None     None  ...   \n",
              "15  2023-10-03T22:08:55.319+0000            None     None  ...   \n",
              "16  2023-10-03T22:09:31.525+0000            None     None  ...   \n",
              "17  2023-10-03T22:10:52.555+0000            None     None  ...   \n",
              "18  2023-10-03T22:13:40.910+0000            None     None  ...   \n",
              "19  2023-10-03T22:05:56.739+0000            None     None  ...   \n",
              "20  2023-10-03T22:06:12.055+0000            None     None  ...   \n",
              "21  2023-10-03T22:06:37.138+0000            None     None  ...   \n",
              "22  2023-10-03T22:06:42.563+0000            None     None  ...   \n",
              "23  2023-10-03T22:09:51.654+0000            None     None  ...   \n",
              "24  2023-10-03T22:10:01.881+0000            None     None  ...   \n",
              "25  2023-10-03T22:12:29.377+0000            None     None  ...   \n",
              "26  2023-10-03T22:12:54.585+0000            None     None  ...   \n",
              "27  2023-10-03T22:12:59.822+0000            None     None  ...   \n",
              "28  2023-10-03T22:13:04.998+0000            None     None  ...   \n",
              "29  2023-10-03T22:05:51.549+0000            None     None  ...   \n",
              "30  2023-10-03T22:08:44.968+0000            None     None  ...   \n",
              "31  2023-10-03T22:09:05.676+0000            None     None  ...   \n",
              "32  2023-10-03T22:12:14.353+0000            None     None  ...   \n",
              "33  2023-10-03T22:05:41.239+0000            None     None  ...   \n",
              "34  2023-10-03T22:07:18.158+0000            None     None  ...   \n",
              "35  2023-10-03T22:07:33.827+0000            None     None  ...   \n",
              "36  2023-10-03T22:07:38.583+0000            None     None  ...   \n",
              "37  2023-10-03T22:08:24.740+0000            None     None  ...   \n",
              "38  2023-10-03T22:09:10.553+0000            None     None  ...   \n",
              "39  2023-10-03T22:10:06.956+0000            None     None  ...   \n",
              "40  2023-10-03T22:10:42.837+0000            None     None  ...   \n",
              "41  2023-10-03T22:10:47.623+0000            None     None  ...   \n",
              "42  2023-10-03T22:12:24.404+0000            None     None  ...   \n",
              "43  2023-10-03T22:12:34.596+0000            None     None  ...   \n",
              "44  2023-10-03T22:12:49.954+0000            None     None  ...   \n",
              "45  2023-10-03T22:06:58.451+0000            None     None  ...   \n",
              "46  2023-10-03T22:10:27.007+0000            None     None  ...   \n",
              "47  2023-10-03T22:08:39.745+0000            None     None  ...   \n",
              "48  2023-10-03T22:09:41.648+0000            None     None  ...   \n",
              "49  2023-10-03T22:07:58.665+0000            None     None  ...   \n",
              "\n",
              "                                      id loc_name lat lon country  \\\n",
              "0   5e1fa87e-5214-46d4-a0ef-d11ed86989cb     None NaN NaN    None   \n",
              "1   dbf4b8bc-b1f8-4453-88ae-b90b6f2785c2     None NaN NaN    None   \n",
              "2   5eb63bfd-b489-4b28-8239-1cf46eac06c7     None NaN NaN    None   \n",
              "3   8ea71f75-0454-4775-85e1-da381f52e9f4     None NaN NaN    None   \n",
              "4   8d163d16-d4de-428f-9eef-44a69a421d22     None NaN NaN    None   \n",
              "5   8fab4cae-4230-422a-951e-f69ccd88fd35     None NaN NaN    None   \n",
              "6   5b07f0ce-2bbd-4f7e-a924-b4f0cf39074b     None NaN NaN    None   \n",
              "7   e9dd0702-59f5-4148-a3fd-14444fbb2a13     None NaN NaN    None   \n",
              "8   1a1fd99d-2f20-4806-aa02-5392683da20c     None NaN NaN    None   \n",
              "9   1aa83b88-4b51-4db5-9ebb-e5275079cf6e     None NaN NaN    None   \n",
              "10  45aac35b-2704-4e67-99f5-b046ddb9a4ce     None NaN NaN    None   \n",
              "11  7521d2e6-d3d4-4673-8701-7efa1bdb1740     None NaN NaN    None   \n",
              "12  77eb0613-4adb-4fff-bdcd-c6a3b77e9921     None NaN NaN    None   \n",
              "13  741b565f-1722-40ab-8414-e0f2b5262656     None NaN NaN    None   \n",
              "14  152098a5-4ab2-46c7-830c-fdc71ec31f35     None NaN NaN    None   \n",
              "15  23d5b67d-106e-4235-a657-429f44075faa     None NaN NaN    None   \n",
              "16  fec3f5b5-312a-47f8-ab7a-1c50fa56a829     None NaN NaN    None   \n",
              "17  eae31545-96fc-4f26-8112-a06fcebb8aa2     None NaN NaN    None   \n",
              "18  37326385-8c37-43ad-b315-a4e2ee9b896c     None NaN NaN    None   \n",
              "19  59701e85-f0a7-45d1-9d05-e7ea2e0654ee     None NaN NaN    None   \n",
              "20  c6805f4f-9e59-4665-86ce-79986b7a4957     None NaN NaN    None   \n",
              "21  12af0c31-177b-47dc-827d-25a0c850ce39     None NaN NaN    None   \n",
              "22  b710353c-31e7-4f2c-9ca8-0c5b553cd364     None NaN NaN    None   \n",
              "23  1abc48ae-2345-4827-82b1-03155f3b357f     None NaN NaN    None   \n",
              "24  84432345-3e7d-4f96-ba3c-c91ff6a54a43     None NaN NaN    None   \n",
              "25  2d527a52-b2ac-4d66-8696-cff8e4a75f05     None NaN NaN    None   \n",
              "26  03d2c914-4291-46b8-88f6-33e7302febf1     None NaN NaN    None   \n",
              "27  8dc77c3e-6317-412d-80f7-eec7b7fc14fc     None NaN NaN    None   \n",
              "28  6c5a5699-48cd-4057-b301-af9b63d08571     None NaN NaN    None   \n",
              "29  1d9e1a59-10ac-411e-8647-5c941d685e53     None NaN NaN    None   \n",
              "30  559896ee-7433-4bce-999a-ee9bc99f800b     None NaN NaN    None   \n",
              "31  763b326d-f0e7-4b41-bbc7-56bb68c6f419     None NaN NaN    None   \n",
              "32  fc1862df-732f-4b6b-af46-7e4d27457c6a     None NaN NaN    None   \n",
              "33  a0425f55-2e12-4824-b2b7-632f628353f4     None NaN NaN    None   \n",
              "34  8776946c-e91f-487b-b488-afcb33285bc2     None NaN NaN    None   \n",
              "35  2df874f0-2290-4c4c-b4d5-e7b485abfbab     None NaN NaN    None   \n",
              "36  4984ad7d-880d-4f1f-9e75-139c0ffe3d7e     None NaN NaN    None   \n",
              "37  18fefee1-f195-4f13-9b43-0f945ab9f50f     None NaN NaN    None   \n",
              "38  d2629803-b341-4697-9082-5d127881e3ce     None NaN NaN    None   \n",
              "39  2742be58-dcbc-45e2-8346-4f3b1f56b903     None NaN NaN    None   \n",
              "40  66d3867d-479f-4e8b-ab6c-720fb5eebc71     None NaN NaN    None   \n",
              "41  f605ef03-462d-4fc3-b9c5-45ea4bb505c3     None NaN NaN    None   \n",
              "42  b3b0712a-42a1-4f60-ab53-508c7e1f02fe     None NaN NaN    None   \n",
              "43  a021155f-0139-422c-b99f-cface3fd1908     None NaN NaN    None   \n",
              "44  fd4d47b0-3d8b-413c-b5a8-b62400f7063b     None NaN NaN    None   \n",
              "45  9a6e44a7-bdd3-460d-b16c-e66517b01a8f     None NaN NaN    None   \n",
              "46  82ab9bfb-cf58-4325-98ed-6b284eed404b     None NaN NaN    None   \n",
              "47  27ef228a-ab2f-4144-a18e-ed1900ba0208     None NaN NaN    None   \n",
              "48  f33f8676-56fb-400a-87c8-ef74b80a6dab     None NaN NaN    None   \n",
              "49  962fa2bd-ccd0-44f8-8a71-c5df028b5d5f     None NaN NaN    None   \n",
              "\n",
              "                                              product         label_product  \\\n",
              "0   20MM RED LEATHER Watch Strap Real Flat Ostrich...   an animal body part   \n",
              "1   20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...             an object   \n",
              "2   25 UNPAINTED SALTWATER Round Ball Jig Heads Re...             an object   \n",
              "3   2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   an animal body part   \n",
              "4   40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...             an object   \n",
              "5   APT 9 LADIES Chemise Nightgown Mauve With Blac...             an object   \n",
              "6   ARTIFICIAL SOFT BAITS Strike King Rage Swimmer...             an object   \n",
              "7   BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS ...             an object   \n",
              "8   BATTLE BEASTS 1987 Condorassin figure LASER be...   an animal body part   \n",
              "9   BOOMTOWN GREEN HOWLING Wolf Vintage Nature Ani...  a print of an animal   \n",
              "10  BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE...             an object   \n",
              "11  BOTSWANA BIRDS ON Stamps 2020 MNH Owls African...  a print of an animal   \n",
              "12  BRING GOOD LUCK Koi Red Fish Pendant Necklace ...   an animal body part   \n",
              "13  FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...   an animal body part   \n",
              "14  FUNNY OSTRICH POSTER Vintage Print Nice Butt G...   an animal body part   \n",
              "15  GREAT WHITE SHARK 2021 Topps Allen & Ginter #D...  a print of an animal   \n",
              "16  GUESS SUNGLASSES EYEWEAR Glasses Drawstring Po...             an object   \n",
              "17  GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real...   an animal body part   \n",
              "18  GIFT STICKER : Mad Bulldog Strong Brave Attack...  a print of an animal   \n",
              "19  HOT TOYS WOLF Predator Action Figure - MMS443 ...                 a toy   \n",
              "20  HUNTHOUSE YOZURI STYLE Laser Minnow Lure for B...             an object   \n",
              "21  HYAENA SPELEA URSUS Speleus Felis Canis Hyena ...  a print of an animal   \n",
              "22  I'M SCARY WITHOUT A Costume Shirt - Funny Hall...             an object   \n",
              "23  JAPAN KAIYODO FURUTA Megamouth Shark Fish Real...   an animal body part   \n",
              "24  JAVELIN BEETLE & 2 Pact Ritual PP01-EN012 PP01...             an object   \n",
              "25  KAHALA MENS AVI Collection Hawaiian Aloha Shir...             an object   \n",
              "26  KAIYODO CAPSULE Q Museum  Figure Hirazugensei ...   an animal body part   \n",
              "27  KAIYODO KABAYA JAPAN Exclusive Japanese rhinoc...   an animal body part   \n",
              "28  KAIYODO WILD RUSH 2 Wild Animal Mini Figure Sp...             an object   \n",
              "29  SALT LIFE ANCHOR & SIGNATURE \"WHITE\"  MEDIUM 1...             an object   \n",
              "30  SAO TOME  2013  Fauna Of Africa Nile Crocodile...   an animal body part   \n",
              "31  SAWFISH, CARPENTER SHARK, Ray, Very Realistic ...   an animal body part   \n",
              "32  SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat...             an object   \n",
              "33  US STAMP SCOTT# 4804 March on Washington, 50th...             an object   \n",
              "34  VINTAGE 80S WOLF Minnesota T Shirt 1987 Single...   an animal body part   \n",
              "35  VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUF...  a print of an animal   \n",
              "36  VINTAGE DELTA PRO Weight - Gray Wolf / Black W...   an animal body part   \n",
              "37  VINTAGE POSTCARD 1907 Happy Thanksgiving Ostri...  a print of an animal   \n",
              "38  VINTAGE WOLF  Nature T-Shirt. Size Adult Large...   an animal body part   \n",
              "39  WATERRUNNER BEACH RUNNER tringa bird birds lit...  a print of an animal   \n",
              "40  WHITE TIGER & Cub T Shirt Pick Your Size Youth...   an animal body part   \n",
              "41  WILD ALLIGATOR ENVELOPE Wallet Credit Card cas...   an animal body part   \n",
              "42  WOLF FACE, LICENSE Plate New Car Tag Metal Alu...   an animal body part   \n",
              "43  WOLF TOOTH SEATPOST Clamp - 34.9mm Red $14.99 ...   an animal body part   \n",
              "44  WOLF WOLVES BARK At The Full Moon The Mountain...   an animal body part   \n",
              "45  Accounts Receivable/Credit Control Jobs | Gumt...             an object   \n",
              "46                                               None             an object   \n",
              "47                                               None             an object   \n",
              "48  2x20L Pull Out Bin - White | Cooking Accessori...             an object   \n",
              "49                                               None             an object   \n",
              "\n",
              "   score_product label     score  \n",
              "0       0.274589   0.0  0.648759  \n",
              "1       0.628286   1.0  0.920214  \n",
              "2       0.827852   1.0  0.866959  \n",
              "3       0.325769   0.0  0.998850  \n",
              "4       0.699756   1.0  0.758410  \n",
              "5       0.853579   0.0  0.885418  \n",
              "6       0.546885   0.0  0.714226  \n",
              "7       0.426800   0.0  0.954990  \n",
              "8       0.307560   0.0  0.999964  \n",
              "9       0.672545   0.0  0.997833  \n",
              "10      0.594813   0.0  0.998632  \n",
              "11      0.482197   0.0  0.999999  \n",
              "12      0.426337   0.0  0.841318  \n",
              "13      0.349030   1.0  0.999783  \n",
              "14      0.437409   0.0  0.935444  \n",
              "15      0.316585   0.0  0.969200  \n",
              "16      0.961095   0.0  0.604004  \n",
              "17      0.423272   1.0  0.999942  \n",
              "18      0.374083   0.0  0.981659  \n",
              "19      0.327783   0.0  0.999666  \n",
              "20      0.779278   1.0  0.881105  \n",
              "21      0.378279   0.0  0.883996  \n",
              "22      0.825524   0.0  0.996483  \n",
              "23      0.376070   0.0  0.996852  \n",
              "24      0.497031   0.0  0.882093  \n",
              "25      0.542786   0.0  0.999344  \n",
              "26      0.327119   0.0  0.906765  \n",
              "27      0.406265   0.0  0.996131  \n",
              "28      0.294887   0.0  0.979462  \n",
              "29      0.667840   0.0  0.886176  \n",
              "30      0.616697   0.0  0.999612  \n",
              "31      0.346656   1.0  0.738583  \n",
              "32      0.355850   0.0  0.820385  \n",
              "33      0.645893   0.0  0.999915  \n",
              "34      0.410971   0.0  0.997274  \n",
              "35      0.750289   0.0  0.833897  \n",
              "36      0.479547   0.0  0.691014  \n",
              "37      0.446144   0.0  0.998603  \n",
              "38      0.435287   0.0  0.991418  \n",
              "39      0.380378   0.0  0.995933  \n",
              "40      0.483208   0.0  0.941009  \n",
              "41      0.398545   1.0  0.738256  \n",
              "42      0.330337   0.0  0.509469  \n",
              "43      0.363676   1.0  0.668809  \n",
              "44      0.375287   1.0  0.559804  \n",
              "45      0.385943   0.0  0.788725  \n",
              "46      0.380854   0.0  0.982064  \n",
              "47      0.380854   0.0  0.982064  \n",
              "48      0.972654   0.0  0.922411  \n",
              "49      0.380854   0.0  0.982064  \n",
              "\n",
              "[50 rows x 27 columns]"
            ]
          },
          "execution_count": 12,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.head(50)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "6cec6a60",
      "metadata": {
        "id": "6cec6a60",
        "outputId": "8db3d8a1-6920-4481-e851-8fd51fe01676"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "=====Column: url=====\n",
            "http://picclick.com/20mm-Red-Leather-Watch-Stra...\n",
            "http://picclick.com/20pks-3-Fishing-Rock-Cod-Ri...\n",
            "http://picclick.com/25-Unpainted-Saltwater-Roun...\n",
            "http://picclick.com/2893-Kuhnert-1911-African-O...\n",
            "http://picclick.com/40-20Pcs-Soft-Fishing-Lure-...\n",
            "http://picclick.com/Apt-9-Ladies-Chemise-Nightg...\n",
            "http://picclick.com/Artificial-Soft-baits-Strik...\n",
            "http://picclick.com/BARRONS-PSAT-NMSQT-19TH-EDI...\n",
            "http://picclick.com/BATTLE-BEASTS-1987-Condoras...\n",
            "http://picclick.com/Boomtown-Green-Howling-Wolf...\n",
            "http://picclick.com/Bosporan-Kingdom-Sauromates...\n",
            "http://picclick.com/Botswana-Birds-on-Stamps-20...\n",
            "http://picclick.com/Bring-Good-Luck-Koi-Red-Fis...\n",
            "http://picclick.com/Fossilized-Hemipristis-Shar...\n",
            "http://picclick.com/Funny-Ostrich-Poster-Vintag...\n",
            "http://picclick.com/GREAT-WHITE-SHARK-2021-Topp...\n",
            "http://picclick.com/GUESS-Sunglasses-Eyewear-Gl...\n",
            "http://picclick.com/Genuine-Alligator-Head-5-Sk...\n",
            "http://picclick.com/Gift-Sticker-Mad-Bulldog-St...\n",
            "http://picclick.com/Hot-Toys-Wolf-Predator-Acti...\n",
            "http://picclick.com/Hunthouse-Yozuri-Style-Lase...\n",
            "http://picclick.com/Hyaena-Spelea-Ursus-Speleus...\n",
            "http://picclick.com/Im-Scary-Without-A-Costume-...\n",
            "http://picclick.com/Japan-Kaiyodo-Furuta-Megamo...\n",
            "http://picclick.com/Javelin-Beetle-2-Pact-Ritua...\n",
            "http://picclick.com/KAHALA-Mens-Avi-Collection-...\n",
            "http://picclick.com/Kaiyodo-Capsule-Q-Museum-Fi...\n",
            "http://picclick.com/Kaiyodo-Kabaya-Japan-Exclus...\n",
            "http://picclick.com/Kaiyodo-Wild-Rush-2-Wild-An...\n",
            "http://picclick.com/SALT-LIFE-ANCHOR-SIGNATURE-...\n",
            "http://picclick.com/Sao-Tome-2013-Fauna-Of-Afri...\n",
            "http://picclick.com/Sawfish-Carpenter-shark-Ray...\n",
            "http://picclick.com/Shimano-Butterfly-Flat-Fall...\n",
            "http://picclick.com/US-Stamp-Scott-4804-March-o...\n",
            "http://picclick.com/Vintage-80s-Wolf-Minnesota-...\n",
            "http://picclick.com/Vintage-Animal-Postcard-RED...\n",
            "http://picclick.com/Vintage-Delta-Pro-Weight-Gr...\n",
            "http://picclick.com/Vintage-Postcard-1907-Happy...\n",
            "http://picclick.com/Vintage-Wolf-Nature-T-Shirt...\n",
            "http://picclick.com/Wasserl%C3%A4ufer-Strandl%C...\n",
            "http://picclick.com/White-Tiger-Cub-T-Shirt-Pic...\n",
            "http://picclick.com/Wild-Alligator-Envelope-Wal...\n",
            "http://picclick.com/Wolf-Face-License-Plate-New...\n",
            "http://picclick.com/Wolf-Tooth-Seatpost-Clamp-3...\n",
            "http://picclick.com/Wolf-Wolves-Bark-At-The-Ful...\n",
            "http://www.gumtree.com.au/s-accounts-receivable...\n",
            "http://www.gumtree.com.au/s-ad/bacchus-marsh/ot...\n",
            "http://www.gumtree.com.au/s-ad/badgingarra/othe...\n",
            "http://www.gumtree.com.au/s-ad/ballina/cooking-...\n",
            "http://www.gumtree.com.au/s-ad/balmain/bags/bra...\n",
            "\n",
            "\n",
            "=====Column: title=====\n",
            "20MM RED LEATHER Watch Strap Real Flat Ostrich ...\n",
            "20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids ...\n",
            "25 UNPAINTED SALTWATER Round Ball Jig Heads Red...\n",
            "2893 KUHNERT 1911 - African Ostrich $7.34 - Pic...\n",
            "40/20PCS SOFT FISHING Lure Paddle Tail Swimbait...\n",
            "APT 9 LADIES Chemise Nightgown Mauve With Black...\n",
            "ARTIFICIAL SOFT BAITS Strike King Rage Swimmer ...\n",
            "BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS O...\n",
            "BATTLE BEASTS 1987 Condorassin figure LASER bea...\n",
            "BOOMTOWN GREEN HOWLING Wolf Vintage Nature Anim...\n",
            "BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE....\n",
            "BOTSWANA BIRDS ON Stamps 2020 MNH Owls African ...\n",
            "BRING GOOD LUCK Koi Red Fish Pendant Necklace C...\n",
            "FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch &...\n",
            "FUNNY OSTRICH POSTER Vintage Print Nice Butt Gi...\n",
            "GREAT WHITE SHARK 2021 Topps Allen & Ginter #DS...\n",
            "GUESS SUNGLASSES EYEWEAR Glasses Drawstring Pou...\n",
            "GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real ...\n",
            "GIFT STICKER : Mad Bulldog Strong Brave Attack ...\n",
            "HOT TOYS WOLF Predator Action Figure - MMS443 $...\n",
            "HUNTHOUSE YOZURI STYLE Laser Minnow Lure for Ba...\n",
            "HYAENA SPELEA URSUS Speleus Felis Canis Hyena l...\n",
            "I'M SCARY WITHOUT A Costume Shirt - Funny Hallo...\n",
            "JAPAN KAIYODO FURUTA Megamouth Shark Fish Reali...\n",
            "JAVELIN BEETLE & 2 Pact Ritual PP01-EN012 PP01-...\n",
            "KAHALA MENS AVI Collection Hawaiian Aloha Shirt...\n",
            "KAIYODO CAPSULE Q Museum  Figure Hirazugensei B...\n",
            "KAIYODO KABAYA JAPAN Exclusive Japanese rhinoce...\n",
            "KAIYODO WILD RUSH 2 Wild Animal Mini Figure Spe...\n",
            "SALT LIFE ANCHOR & SIGNATURE \"WHITE\"  MEDIUM 12...\n",
            "SAO TOME  2013  Fauna Of Africa Nile Crocodile ...\n",
            "SAWFISH, CARPENTER SHARK, Ray, Very Realistic R...\n",
            "SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat ...\n",
            "US STAMP SCOTT# 4804 March on Washington, 50th ...\n",
            "VINTAGE 80S WOLF Minnesota T Shirt 1987 Single ...\n",
            "VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUFU...\n",
            "VINTAGE DELTA PRO Weight - Gray Wolf / Black Wo...\n",
            "VINTAGE POSTCARD 1907 Happy Thanksgiving Ostric...\n",
            "VINTAGE WOLF  Nature T-Shirt. Size Adult Large ...\n",
            "WATERRUNNER BEACH RUNNER tringa bird birds lith...\n",
            "WHITE TIGER & Cub T Shirt Pick Your Size Youth ...\n",
            "WILD ALLIGATOR ENVELOPE Wallet Credit Card case...\n",
            "WOLF FACE, LICENSE Plate New Car Tag Metal Alum...\n",
            "WOLF TOOTH SEATPOST Clamp - 34.9mm Red $14.99 -...\n",
            "WOLF WOLVES BARK At The Full Moon The Mountain ...\n",
            "Accounts Receivable/Credit Control Jobs | Gumtr...\n",
            "                                              None\n",
            "                                              None\n",
            "2x20L Pull Out Bin - White | Cooking Accessorie...\n",
            "                                              None\n",
            "\n",
            "\n",
            "=====Column: text=====\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\...\n",
            "Accounts Receivable/Credit Control Jobs | Gumtr...\n",
            "                                                \\n\n",
            "                                                \\n\n",
            "2x20L Pull Out Bin - White | Cooking Accessorie...\n",
            "                                                \\n\n",
            "\n",
            "\n",
            "=====Column: domain=====\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "  picclick.com\n",
            "gumtree.com.au\n",
            "gumtree.com.au\n",
            "gumtree.com.au\n",
            "gumtree.com.au\n",
            "gumtree.com.au\n",
            "\n",
            "\n",
            "=====Column: name=====\n",
            "20MM RED LEATHER Watch Strap Real Flat Ostrich ...\n",
            "20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids ...\n",
            "25 UNPAINTED SALTWATER Round Ball Jig Heads Red...\n",
            "               2893 KUHNERT 1911 - African Ostrich\n",
            "40/20PCS SOFT FISHING Lure Paddle Tail Swimbait...\n",
            "APT 9 LADIES Chemise Nightgown Mauve With Black...\n",
            "ARTIFICIAL SOFT BAITS Strike King Rage Swimmer ...\n",
            "BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS O...\n",
            "BATTLE BEASTS 1987 Condorassin figure LASER bea...\n",
            "BOOMTOWN GREEN HOWLING Wolf Vintage Nature Anim...\n",
            "BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE....\n",
            "BOTSWANA BIRDS ON Stamps 2020 MNH Owls African ...\n",
            "BRING GOOD LUCK Koi Red Fish Pendant Necklace C...\n",
            "FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch &...\n",
            "FUNNY OSTRICH POSTER Vintage Print Nice Butt Gi...\n",
            "GREAT WHITE SHARK 2021 Topps Allen & Ginter #DS...\n",
            "GUESS SUNGLASSES EYEWEAR Glasses Drawstring Pou...\n",
            "GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real ...\n",
            "GIFT STICKER : Mad Bulldog Strong Brave Attack ...\n",
            "     HOT TOYS WOLF Predator Action Figure - MMS443\n",
            "HUNTHOUSE YOZURI STYLE Laser Minnow Lure for Ba...\n",
            "HYAENA SPELEA URSUS Speleus Felis Canis Hyena l...\n",
            "I'M SCARY WITHOUT A Costume Shirt - Funny Hallo...\n",
            "JAPAN KAIYODO FURUTA Megamouth Shark Fish Reali...\n",
            "JAVELIN BEETLE & 2 Pact Ritual PP01-EN012 PP01-...\n",
            "KAHALA MENS AVI Collection Hawaiian Aloha Shirt...\n",
            "KAIYODO CAPSULE Q Museum  Figure Hirazugensei B...\n",
            "KAIYODO KABAYA JAPAN Exclusive Japanese rhinoce...\n",
            "KAIYODO WILD RUSH 2 Wild Animal Mini Figure Spe...\n",
            "SALT LIFE ANCHOR & SIGNATURE \"WHITE\"  MEDIUM 12...\n",
            "SAO TOME  2013  Fauna Of Africa Nile Crocodile ...\n",
            "SAWFISH, CARPENTER SHARK, Ray, Very Realistic R...\n",
            "SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat ...\n",
            "US STAMP SCOTT# 4804 March on Washington, 50th ...\n",
            "VINTAGE 80S WOLF Minnesota T Shirt 1987 Single ...\n",
            "VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUFU...\n",
            "VINTAGE DELTA PRO Weight - Gray Wolf / Black Wo...\n",
            "VINTAGE POSTCARD 1907 Happy Thanksgiving Ostric...\n",
            "VINTAGE WOLF  Nature T-Shirt. Size Adult Large ...\n",
            "WATERRUNNER BEACH RUNNER tringa bird birds lith...\n",
            "WHITE TIGER & Cub T Shirt Pick Your Size Youth ...\n",
            "WILD ALLIGATOR ENVELOPE Wallet Credit Card case...\n",
            "WOLF FACE, LICENSE Plate New Car Tag Metal Alum...\n",
            "            WOLF TOOTH SEATPOST Clamp - 34.9mm Red\n",
            "WOLF WOLVES BARK At The Full Moon The Mountain ...\n",
            "                         Free local classified ads\n",
            "                                              None\n",
            "                                              None\n",
            "2x20L Pull Out Bin - White | Cooking Accessorie...\n",
            "                                              None\n",
            "\n",
            "\n",
            "=====Column: description=====\n",
            "20mm Red Leather Watch Strap Real Flat Ostrich ...\n",
            "20pks 3\" Fishing Rock Cod Rig Twin Bulb Squids ...\n",
            "25 Unpainted Saltwater Round Ball Jig Heads Red...\n",
            "2893 Kuhnert 1911 - African Ostrich. Giclee Fin...\n",
            "40/20Pcs Soft Fishing Lure Paddle Tail Swimbait...\n",
            "Apt 9 Ladies Chemise Nightgown Mauve With Black...\n",
            "Artificial Soft baits Strike King Rage Swimmer ...\n",
            "BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS O...\n",
            "BATTLE BEASTS 1987 Condorassin figure LASER bea...\n",
            "Boomtown Green Howling Wolf Vintage Nature Anim...\n",
            "Bosporan Kingdom. Sauromates III. Denarius. AE....\n",
            "Botswana Birds on Stamps 2020 MNH Owls African ...\n",
            "Bring Good Luck Koi Red Fish Pendant Necklace C...\n",
            "Fossilized Hemipristis Shark Tooth 1 3/8 Inch &...\n",
            "Funny Ostrich Poster Vintage Print Nice Butt Gi...\n",
            "GREAT WHITE SHARK 2021 Topps Allen & Ginter #DS...\n",
            "GUESS Sunglasses Eyewear Glasses Drawstring Pou...\n",
            "GENUINE ALLIGATOR HEAD 5\" SKULL TAXIDERMY REAL ...\n",
            "Gift Sticker : Mad Bulldog Strong Brave Attack ...\n",
            "Hot Toys Wolf Predator Action Figure - MMS443. ...\n",
            "Hunthouse Yozuri Style Laser Minnow Lure for Ba...\n",
            "Hyaena Spelea Ursus Speleus Felis Canis Hyena l...\n",
            "I'm Scary Without A Costume Shirt - Funny Hallo...\n",
            "Japan Kaiyodo Furuta Megamouth Shark Fish Reali...\n",
            "Javelin Beetle & 2 Pact Ritual PP01-EN012 PP01-...\n",
            "KAHALA Mens Avi Collection Hawaiian Aloha Shirt...\n",
            "Kaiyodo Capsule Q Museum Figure Hirazugensei Be...\n",
            "Kaiyodo Kabaya Japan Exclusive Japanese rhinoce...\n",
            "Kaiyodo Wild Rush 2 Wild Animal Mini Figure Spe...\n",
            "SALT LIFE ANCHOR & SIGNATURE \"WHITE\" MEDIUM 12 ...\n",
            "SAO TOME 2013 FAUNA OF AFRICA NILE CROCODILE SO...\n",
            "Sawfish, Carpenter shark, Ray, Very Realistic R...\n",
            "Shimano Butterfly Flat-Fall Jig - Sinking Flat ...\n",
            "US Stamp Scott# 4804 March on Washington, 50th ...\n",
            "Vintage 80s Wolf Minnesota T Shirt 1987 Single ...\n",
            "Vintage Animal Postcard RED WOLF (CANIS RUFUS) ...\n",
            "Vintage Delta Pro Weight - Gray Wolf / Black Wo...\n",
            "Vintage Postcard 1907 Happy Thanksgiving Ostric...\n",
            "Vintage Wolf Nature T-Shirt. Size Adult Large G...\n",
            "Waterrunner beach runner tringa bird birds lith...\n",
            "White Tiger & Cub T Shirt Pick Your Size Youth ...\n",
            "Wild Alligator Envelope Wallet Credit Card case...\n",
            "Wolf Face, License Plate New Car Tag Metal Alum...\n",
            "Wolf Tooth Seatpost Clamp - 34.9mm Red. Bought ...\n",
            "Wolf Wolves Bark At The Full Moon The Mountain ...\n",
            "Find Accounts Receivable/Credit Control Jobs ad...\n",
            "                                              None\n",
            "                                              None\n",
            "Dual Pull Out Bin\\n\\nPractical and aestheticall...\n",
            "                                              None\n",
            "\n",
            "\n",
            "=====Column: image=====\n",
            "https://www.picclickimg.com/4asAAOSwAatkmpPo/20...\n",
            "https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/20...\n",
            "https://www.picclickimg.com/NH0AAOSwNmVkutkl/25...\n",
            "https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/28...\n",
            "https://www.picclickimg.com/qFgAAOSwsxdkrjzO/40...\n",
            "https://www.picclickimg.com/VWkAAOSwxBtk8~Yt/Ap...\n",
            "https://www.picclickimg.com/wGoAAOSw1y5jC3js/Ar...\n",
            "https://www.picclickimg.com/f-EAAOSwXaFlG0oF/BA...\n",
            "https://www.picclickimg.com/ZN0AAOSw6l9lB2yi/BA...\n",
            "https://www.picclickimg.com/yEIAAOSwG81lD8Wh/Bo...\n",
            "https://www.picclickimg.com/kHYAAOSwCKJkAkZp/Bo...\n",
            "https://www.picclickimg.com/rmUAAOSwoR1f~V~U/Bo...\n",
            "https://www.picclickimg.com/tnsAAOSwDZljSbGz/Br...\n",
            "https://www.picclickimg.com/mVoAAOSwPyReqhRO/Fo...\n",
            "https://www.picclickimg.com/SawAAOSwhU1kZn3q/Fu...\n",
            "https://www.picclickimg.com/O-8AAOSw9QtlGU1w/GR...\n",
            "https://www.picclickimg.com/UmIAAOSw5WVlGRUc/GU...\n",
            "https://www.picclickimg.com/DYQAAOSwEDZkyTAL/Ge...\n",
            "https://www.picclickimg.com/M4kAAOSw8YlhIq7k/Gi...\n",
            "https://www.picclickimg.com/0GIAAOSw-l5lBhem/Ho...\n",
            "https://www.picclickimg.com/Xd8AAOSwKExhCW10/Hu...\n",
            "https://www.picclickimg.com/5e0AAOSwraBgFLpw/Hy...\n",
            "https://www.picclickimg.com/9L8AAOSwjPVdtfkh/Im...\n",
            "https://www.picclickimg.com/6mgAAOSwNj5dFh8u/Ja...\n",
            "https://www.picclickimg.com/ELIAAOSw~SxkGZC1/Ja...\n",
            "https://www.picclickimg.com/0hsAAOSwt~Ji1wkj/KA...\n",
            "https://www.picclickimg.com/TFwAAOSwBiBjeyMY/Ka...\n",
            "https://www.picclickimg.com/nw8AAOSwSqJfmcKO/Ka...\n",
            "https://www.picclickimg.com/MyAAAOSw7SZejE0u/Ka...\n",
            "https://www.picclickimg.com/TdAAAOSwRsliqn8X/SA...\n",
            "https://www.picclickimg.com/px8AAOxy9ERSRJab/Sa...\n",
            "https://www.picclickimg.com/JjcAAOSw2-9jBVsH/Sa...\n",
            "https://www.picclickimg.com/vzMAAOSwNlldoaPQ/Sh...\n",
            "https://www.picclickimg.com/cq8AAOSwaIBkxFMb/US...\n",
            "https://www.picclickimg.com/nPwAAOSwwRplDPDU/Vi...\n",
            "https://www.picclickimg.com/zuoAAOSw4A1fzCd1/Vi...\n",
            "https://www.picclickimg.com/HOEAAOSw3QFlBGq2/Vi...\n",
            "https://www.picclickimg.com/1xgAAOSwuOxjWe~Y/Vi...\n",
            "https://www.picclickimg.com/bNgAAOSwSPhlBIsB/Vi...\n",
            "https://www.picclickimg.com/qWgAAOSwKnBkrvzM/Wa...\n",
            "https://www.picclickimg.com/R7AAAOSwstNawoWy/Wh...\n",
            "https://www.picclickimg.com/hjwAAOSwBfZhhCT3/Wi...\n",
            "https://www.picclickimg.com/A0EAAOSwj7hesXWG/Wo...\n",
            "https://www.picclickimg.com/p~8AAOSwCqllF1gl/Wo...\n",
            "https://www.picclickimg.com/Q~cAAOSwDJZb5hPe/Wo...\n",
            "https://static.gumtree.com.au/master-7aa11a3366...\n",
            "                                              None\n",
            "                                              None\n",
            "https://gumtreeau-res.cloudinary.com/image/priv...\n",
            "                                              None\n",
            "\n",
            "\n",
            "=====Column: retrieved=====\n",
            "2023-10-03T22:06:06.750+0000\n",
            "2023-10-03T22:06:57.499+0000\n",
            "2023-10-03T22:11:18.679+0000\n",
            "2023-10-03T22:13:25.279+0000\n",
            "2023-10-03T22:09:00.700+0000\n",
            "2023-10-03T22:06:01.308+0000\n",
            "2023-10-03T22:08:40.274+0000\n",
            "2023-10-03T22:13:50.562+0000\n",
            "2023-10-03T22:14:00.901+0000\n",
            "2023-10-03T22:09:36.245+0000\n",
            "2023-10-03T22:09:46.413+0000\n",
            "2023-10-03T22:10:32.302+0000\n",
            "2023-10-03T22:11:23.712+0000\n",
            "2023-10-03T22:06:16.609+0000\n",
            "2023-10-03T22:07:54.274+0000\n",
            "2023-10-03T22:08:55.319+0000\n",
            "2023-10-03T22:09:31.525+0000\n",
            "2023-10-03T22:10:52.555+0000\n",
            "2023-10-03T22:13:40.910+0000\n",
            "2023-10-03T22:05:56.739+0000\n",
            "2023-10-03T22:06:12.055+0000\n",
            "2023-10-03T22:06:37.138+0000\n",
            "2023-10-03T22:06:42.563+0000\n",
            "2023-10-03T22:09:51.654+0000\n",
            "2023-10-03T22:10:01.881+0000\n",
            "2023-10-03T22:12:29.377+0000\n",
            "2023-10-03T22:12:54.585+0000\n",
            "2023-10-03T22:12:59.822+0000\n",
            "2023-10-03T22:13:04.998+0000\n",
            "2023-10-03T22:05:51.549+0000\n",
            "2023-10-03T22:08:44.968+0000\n",
            "2023-10-03T22:09:05.676+0000\n",
            "2023-10-03T22:12:14.353+0000\n",
            "2023-10-03T22:05:41.239+0000\n",
            "2023-10-03T22:07:18.158+0000\n",
            "2023-10-03T22:07:33.827+0000\n",
            "2023-10-03T22:07:38.583+0000\n",
            "2023-10-03T22:08:24.740+0000\n",
            "2023-10-03T22:09:10.553+0000\n",
            "2023-10-03T22:10:06.956+0000\n",
            "2023-10-03T22:10:42.837+0000\n",
            "2023-10-03T22:10:47.623+0000\n",
            "2023-10-03T22:12:24.404+0000\n",
            "2023-10-03T22:12:34.596+0000\n",
            "2023-10-03T22:12:49.954+0000\n",
            "2023-10-03T22:06:58.451+0000\n",
            "2023-10-03T22:10:27.007+0000\n",
            "2023-10-03T22:08:39.745+0000\n",
            "2023-10-03T22:09:41.648+0000\n",
            "2023-10-03T22:07:58.665+0000\n",
            "\n",
            "\n",
            "=====Column: production_data=====\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: category=====\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: price=====\n",
            " 21.99\n",
            " 46.88\n",
            " 30.20\n",
            "  7.34\n",
            "  7.99\n",
            " 17.58\n",
            "  7.26\n",
            " 12.49\n",
            " 45.99\n",
            " 26.99\n",
            "250.00\n",
            "  7.27\n",
            "  1.80\n",
            " 24.99\n",
            " 18.17\n",
            "  1.25\n",
            "  5.00\n",
            " 24.69\n",
            " 15.99\n",
            "600.00\n",
            "  8.67\n",
            "  7.00\n",
            " 14.99\n",
            " 15.87\n",
            " 36.97\n",
            " 29.97\n",
            "  9.99\n",
            " 15.99\n",
            " 11.99\n",
            " 13.99\n",
            " 16.95\n",
            "  8.79\n",
            " 13.99\n",
            "  8.50\n",
            " 24.99\n",
            "  3.15\n",
            " 19.99\n",
            "  8.99\n",
            " 14.95\n",
            " 40.93\n",
            " 14.99\n",
            "135.00\n",
            " 12.94\n",
            " 14.99\n",
            " 18.70\n",
            "   NaN\n",
            "   NaN\n",
            "   NaN\n",
            "   NaN\n",
            "   NaN\n",
            "\n",
            "\n",
            "=====Column: currency=====\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            " USD\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: seller=====\n",
            "       vietnamcreations1\n",
            "                 fishwow\n",
            "                htlureco\n",
            "             banknoten-1\n",
            "              potatoshop\n",
            "              memesplace\n",
            "          masterturtle12\n",
            "                   zuber\n",
            "          guitarnick1012\n",
            "       southtexasresell1\n",
            "                tilubi-0\n",
            "                eren3049\n",
            "      wholesalejewelryer\n",
            "     jeffssharkteethplus\n",
            "           florinaflorea\n",
            "        eckertcollection\n",
            "              matbroo-60\n",
            "             noodlebacca\n",
            "                xpgifts7\n",
            "   retrorad_collectibles\n",
            "              bodyart210\n",
            "           portugalcards\n",
            "               halfit_co\n",
            "         figureking.shop\n",
            "          geekygreatness\n",
            "              kmonkie_98\n",
            "                kobe_one\n",
            "                 jubei88\n",
            "                kobe_one\n",
            "          workingthelife\n",
            "           marlen-stamps\n",
            "collectiblewildlifegifts\n",
            "      chaosfishingoutlet\n",
            "                gpip8166\n",
            "          camsvintage215\n",
            "         designsbystella\n",
            "                 kidnoah\n",
            "    colbear*collectibles\n",
            "            gordonsgoods\n",
            "     antiquariat-voelkel\n",
            "             buchanan126\n",
            "              southnjent\n",
            "             locosprints\n",
            "           googoomichael\n",
            "              empiretees\n",
            "                    None\n",
            "                    None\n",
            "                    None\n",
            "                    None\n",
            "                    None\n",
            "\n",
            "\n",
            "=====Column: seller_type=====\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: seller_url=====\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: location=====\n",
            "               Houston, Texas, US\n",
            "      Chino Hills, California, US\n",
            "          Sayre, Pennsylvania, US\n",
            "        Kirchen - Herkersdorf, DE\n",
            "                    Guangzhou, CN\n",
            "        Indianapolis, Indiana, US\n",
            "                     worthing, GB\n",
            "                           US, US\n",
            "           Fairdale, Kentucky, US\n",
            "          Raymondville, Texas, US\n",
            "                       Odessa, UA\n",
            "              TRURO, Cornwall, GB\n",
            "                         Yiwu, CN\n",
            "            Sarasota, Florida, US\n",
            "                    Kettering, GB\n",
            "             Eckert, Colorado, US\n",
            "           Kissimmee, Florida, US\n",
            "     Apache Junction, Arizona, US\n",
            "     Fort Lauderdale, Florida, US\n",
            "           Santee, California, US\n",
            "                     East Ham, GB\n",
            "                       Sintra, PT\n",
            "         San Jose, California, US\n",
            "          Muang, Samutprakarn, TH\n",
            "                   Whitstable, GB\n",
            "    Redondo Beach, California, US\n",
            "          Kobe-shi, Hyogo-ken, JP\n",
            "                       Canada, CA\n",
            "          Kobe-shi, Hyogo-ken, JP\n",
            "              Stuart, Florida, US\n",
            "         Great Neck, New York, US\n",
            "        Bremerton, Washington, US\n",
            "       Pompano Beach, Florida, US\n",
            "         Louisville, Kentucky, US\n",
            "   Philadelphia, Pennsylvania, US\n",
            "          Tonawanda, New York, US\n",
            "         Great Neck, New York, US\n",
            "Boiling Springs, Pennsylvania, US\n",
            "       Costa Mesa, California, US\n",
            "                  Seubersdorf, DE\n",
            "       Minneapolis, Minnesota, US\n",
            "               Tampa, Florida, US\n",
            "           Jefferson, Georgia, US\n",
            "     Doylestown, Pennsylvania, US\n",
            "           Clarence, New York, US\n",
            "                             None\n",
            "                             None\n",
            "                             None\n",
            "                             None\n",
            "                             None\n",
            "\n",
            "\n",
            "=====Column: ships to=====\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: id=====\n",
            "5e1fa87e-5214-46d4-a0ef-d11ed86989cb\n",
            "dbf4b8bc-b1f8-4453-88ae-b90b6f2785c2\n",
            "5eb63bfd-b489-4b28-8239-1cf46eac06c7\n",
            "8ea71f75-0454-4775-85e1-da381f52e9f4\n",
            "8d163d16-d4de-428f-9eef-44a69a421d22\n",
            "8fab4cae-4230-422a-951e-f69ccd88fd35\n",
            "5b07f0ce-2bbd-4f7e-a924-b4f0cf39074b\n",
            "e9dd0702-59f5-4148-a3fd-14444fbb2a13\n",
            "1a1fd99d-2f20-4806-aa02-5392683da20c\n",
            "1aa83b88-4b51-4db5-9ebb-e5275079cf6e\n",
            "45aac35b-2704-4e67-99f5-b046ddb9a4ce\n",
            "7521d2e6-d3d4-4673-8701-7efa1bdb1740\n",
            "77eb0613-4adb-4fff-bdcd-c6a3b77e9921\n",
            "741b565f-1722-40ab-8414-e0f2b5262656\n",
            "152098a5-4ab2-46c7-830c-fdc71ec31f35\n",
            "23d5b67d-106e-4235-a657-429f44075faa\n",
            "fec3f5b5-312a-47f8-ab7a-1c50fa56a829\n",
            "eae31545-96fc-4f26-8112-a06fcebb8aa2\n",
            "37326385-8c37-43ad-b315-a4e2ee9b896c\n",
            "59701e85-f0a7-45d1-9d05-e7ea2e0654ee\n",
            "c6805f4f-9e59-4665-86ce-79986b7a4957\n",
            "12af0c31-177b-47dc-827d-25a0c850ce39\n",
            "b710353c-31e7-4f2c-9ca8-0c5b553cd364\n",
            "1abc48ae-2345-4827-82b1-03155f3b357f\n",
            "84432345-3e7d-4f96-ba3c-c91ff6a54a43\n",
            "2d527a52-b2ac-4d66-8696-cff8e4a75f05\n",
            "03d2c914-4291-46b8-88f6-33e7302febf1\n",
            "8dc77c3e-6317-412d-80f7-eec7b7fc14fc\n",
            "6c5a5699-48cd-4057-b301-af9b63d08571\n",
            "1d9e1a59-10ac-411e-8647-5c941d685e53\n",
            "559896ee-7433-4bce-999a-ee9bc99f800b\n",
            "763b326d-f0e7-4b41-bbc7-56bb68c6f419\n",
            "fc1862df-732f-4b6b-af46-7e4d27457c6a\n",
            "a0425f55-2e12-4824-b2b7-632f628353f4\n",
            "8776946c-e91f-487b-b488-afcb33285bc2\n",
            "2df874f0-2290-4c4c-b4d5-e7b485abfbab\n",
            "4984ad7d-880d-4f1f-9e75-139c0ffe3d7e\n",
            "18fefee1-f195-4f13-9b43-0f945ab9f50f\n",
            "d2629803-b341-4697-9082-5d127881e3ce\n",
            "2742be58-dcbc-45e2-8346-4f3b1f56b903\n",
            "66d3867d-479f-4e8b-ab6c-720fb5eebc71\n",
            "f605ef03-462d-4fc3-b9c5-45ea4bb505c3\n",
            "b3b0712a-42a1-4f60-ab53-508c7e1f02fe\n",
            "a021155f-0139-422c-b99f-cface3fd1908\n",
            "fd4d47b0-3d8b-413c-b5a8-b62400f7063b\n",
            "9a6e44a7-bdd3-460d-b16c-e66517b01a8f\n",
            "82ab9bfb-cf58-4325-98ed-6b284eed404b\n",
            "27ef228a-ab2f-4144-a18e-ed1900ba0208\n",
            "f33f8676-56fb-400a-87c8-ef74b80a6dab\n",
            "962fa2bd-ccd0-44f8-8a71-c5df028b5d5f\n",
            "\n",
            "\n",
            "=====Column: loc_name=====\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: lat=====\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "\n",
            "\n",
            "=====Column: lon=====\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "NaN\n",
            "\n",
            "\n",
            "=====Column: country=====\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "None\n",
            "\n",
            "\n",
            "=====Column: product=====\n",
            "20MM RED LEATHER Watch Strap Real Flat Ostrich ...\n",
            "20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids ...\n",
            "25 UNPAINTED SALTWATER Round Ball Jig Heads Red...\n",
            "2893 KUHNERT 1911 - African Ostrich $7.34 - Pic...\n",
            "40/20PCS SOFT FISHING Lure Paddle Tail Swimbait...\n",
            "APT 9 LADIES Chemise Nightgown Mauve With Black...\n",
            "ARTIFICIAL SOFT BAITS Strike King Rage Swimmer ...\n",
            "BARRON'S PSAT/NMSQT, 19TH EDITION: WITH BONUS O...\n",
            "BATTLE BEASTS 1987 Condorassin figure LASER bea...\n",
            "BOOMTOWN GREEN HOWLING Wolf Vintage Nature Anim...\n",
            "BOSPORAN KINGDOM. SAUROMATES III. Denarius. AE....\n",
            "BOTSWANA BIRDS ON Stamps 2020 MNH Owls African ...\n",
            "BRING GOOD LUCK Koi Red Fish Pendant Necklace C...\n",
            "FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch &...\n",
            "FUNNY OSTRICH POSTER Vintage Print Nice Butt Gi...\n",
            "GREAT WHITE SHARK 2021 Topps Allen & Ginter #DS...\n",
            "GUESS SUNGLASSES EYEWEAR Glasses Drawstring Pou...\n",
            "GENUINE ALLIGATOR HEAD 5\" Skull Taxidermy Real ...\n",
            "GIFT STICKER : Mad Bulldog Strong Brave Attack ...\n",
            "HOT TOYS WOLF Predator Action Figure - MMS443 $...\n",
            "HUNTHOUSE YOZURI STYLE Laser Minnow Lure for Ba...\n",
            "HYAENA SPELEA URSUS Speleus Felis Canis Hyena l...\n",
            "I'M SCARY WITHOUT A Costume Shirt - Funny Hallo...\n",
            "JAPAN KAIYODO FURUTA Megamouth Shark Fish Reali...\n",
            "JAVELIN BEETLE & 2 Pact Ritual PP01-EN012 PP01-...\n",
            "KAHALA MENS AVI Collection Hawaiian Aloha Shirt...\n",
            "KAIYODO CAPSULE Q Museum  Figure Hirazugensei B...\n",
            "KAIYODO KABAYA JAPAN Exclusive Japanese rhinoce...\n",
            "KAIYODO WILD RUSH 2 Wild Animal Mini Figure Spe...\n",
            "SALT LIFE ANCHOR & SIGNATURE \"WHITE\"  MEDIUM 12...\n",
            "SAO TOME  2013  Fauna Of Africa Nile Crocodile ...\n",
            "SAWFISH, CARPENTER SHARK, Ray, Very Realistic R...\n",
            "SHIMANO BUTTERFLY FLAT-FALL Jig - Sinking Flat ...\n",
            "US STAMP SCOTT# 4804 March on Washington, 50th ...\n",
            "VINTAGE 80S WOLF Minnesota T Shirt 1987 Single ...\n",
            "VINTAGE ANIMAL  Postcard   RED WOLF (CANIS RUFU...\n",
            "VINTAGE DELTA PRO Weight - Gray Wolf / Black Wo...\n",
            "VINTAGE POSTCARD 1907 Happy Thanksgiving Ostric...\n",
            "VINTAGE WOLF  Nature T-Shirt. Size Adult Large ...\n",
            "WATERRUNNER BEACH RUNNER tringa bird birds lith...\n",
            "WHITE TIGER & Cub T Shirt Pick Your Size Youth ...\n",
            "WILD ALLIGATOR ENVELOPE Wallet Credit Card case...\n",
            "WOLF FACE, LICENSE Plate New Car Tag Metal Alum...\n",
            "WOLF TOOTH SEATPOST Clamp - 34.9mm Red $14.99 -...\n",
            "WOLF WOLVES BARK At The Full Moon The Mountain ...\n",
            "Accounts Receivable/Credit Control Jobs | Gumtr...\n",
            "                                              None\n",
            "                                              None\n",
            "2x20L Pull Out Bin - White | Cooking Accessorie...\n",
            "                                              None\n",
            "\n",
            "\n",
            "=====Column: label_product=====\n",
            " an animal body part\n",
            "           an object\n",
            "           an object\n",
            " an animal body part\n",
            "           an object\n",
            "           an object\n",
            "           an object\n",
            "           an object\n",
            " an animal body part\n",
            "a print of an animal\n",
            "           an object\n",
            "a print of an animal\n",
            " an animal body part\n",
            " an animal body part\n",
            " an animal body part\n",
            "a print of an animal\n",
            "           an object\n",
            " an animal body part\n",
            "a print of an animal\n",
            "               a toy\n",
            "           an object\n",
            "a print of an animal\n",
            "           an object\n",
            " an animal body part\n",
            "           an object\n",
            "           an object\n",
            " an animal body part\n",
            " an animal body part\n",
            "           an object\n",
            "           an object\n",
            " an animal body part\n",
            " an animal body part\n",
            "           an object\n",
            "           an object\n",
            " an animal body part\n",
            "a print of an animal\n",
            " an animal body part\n",
            "a print of an animal\n",
            " an animal body part\n",
            "a print of an animal\n",
            " an animal body part\n",
            " an animal body part\n",
            " an animal body part\n",
            " an animal body part\n",
            " an animal body part\n",
            "           an object\n",
            "           an object\n",
            "           an object\n",
            "           an object\n",
            "           an object\n",
            "\n",
            "\n",
            "=====Column: score_product=====\n",
            "0.274589\n",
            "0.628286\n",
            "0.827852\n",
            "0.325769\n",
            "0.699756\n",
            "0.853579\n",
            "0.546885\n",
            "0.426800\n",
            "0.307560\n",
            "0.672545\n",
            "0.594813\n",
            "0.482197\n",
            "0.426337\n",
            "0.349030\n",
            "0.437409\n",
            "0.316585\n",
            "0.961095\n",
            "0.423272\n",
            "0.374083\n",
            "0.327783\n",
            "0.779278\n",
            "0.378279\n",
            "0.825524\n",
            "0.376070\n",
            "0.497031\n",
            "0.542786\n",
            "0.327119\n",
            "0.406265\n",
            "0.294887\n",
            "0.667840\n",
            "0.616697\n",
            "0.346656\n",
            "0.355850\n",
            "0.645893\n",
            "0.410971\n",
            "0.750289\n",
            "0.479547\n",
            "0.446144\n",
            "0.435287\n",
            "0.380378\n",
            "0.483208\n",
            "0.398545\n",
            "0.330337\n",
            "0.363676\n",
            "0.375287\n",
            "0.385943\n",
            "0.380854\n",
            "0.380854\n",
            "0.972654\n",
            "0.380854\n",
            "\n",
            "\n",
            "=====Column: label=====\n",
            "0.0\n",
            "1.0\n",
            "1.0\n",
            "0.0\n",
            "1.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "1.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "1.0\n",
            "0.0\n",
            "0.0\n",
            "1.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "1.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "1.0\n",
            "0.0\n",
            "1.0\n",
            "1.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "0.0\n",
            "\n",
            "\n",
            "=====Column: score=====\n",
            "0.648759\n",
            "0.920214\n",
            "0.866959\n",
            "0.998850\n",
            "0.758410\n",
            "0.885418\n",
            "0.714226\n",
            "0.954990\n",
            "0.999964\n",
            "0.997833\n",
            "0.998632\n",
            "0.999999\n",
            "0.841318\n",
            "0.999783\n",
            "0.935444\n",
            "0.969200\n",
            "0.604004\n",
            "0.999942\n",
            "0.981659\n",
            "0.999666\n",
            "0.881105\n",
            "0.883996\n",
            "0.996483\n",
            "0.996852\n",
            "0.882093\n",
            "0.999344\n",
            "0.906765\n",
            "0.996131\n",
            "0.979462\n",
            "0.886176\n",
            "0.999612\n",
            "0.738583\n",
            "0.820385\n",
            "0.999915\n",
            "0.997274\n",
            "0.833897\n",
            "0.691014\n",
            "0.998603\n",
            "0.991418\n",
            "0.995933\n",
            "0.941009\n",
            "0.738256\n",
            "0.509469\n",
            "0.668809\n",
            "0.559804\n",
            "0.788725\n",
            "0.982064\n",
            "0.982064\n",
            "0.922411\n",
            "0.982064\n",
            "\n",
            "\n"
          ]
        }
      ],
      "source": [
        "for column in df.columns:\n",
        "    print(f\"=====Column: {column}=====\")\n",
        "    print(df[column].head(50).to_string(index=False))\n",
        "    print(\"\\n\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "5ffdfbcb",
      "metadata": {
        "scrolled": true,
        "id": "5ffdfbcb",
        "outputId": "b108ba17-ba9c-43b3-d42d-c420918b1139"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "url                2205\n",
              "title              2205\n",
              "text               2205\n",
              "domain             2205\n",
              "name               2205\n",
              "description        2205\n",
              "image              2205\n",
              "retrieved          2205\n",
              "production_data    2205\n",
              "category           2205\n",
              "price              1273\n",
              "currency           2205\n",
              "seller             2205\n",
              "seller_type        2205\n",
              "seller_url         2205\n",
              "location             64\n",
              "ships to           2205\n",
              "id                 2205\n",
              "loc_name              1\n",
              "lat                   1\n",
              "lon                   1\n",
              "country               1\n",
              "product            2205\n",
              "label_product      2205\n",
              "score_product      2205\n",
              "label              2205\n",
              "score              2205\n",
              "dtype: int64"
            ]
          },
          "execution_count": 13,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.count()"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "723324f1",
      "metadata": {
        "id": "723324f1"
      },
      "source": [
        "# Exploratory Data Analysis (EDA)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "1bb0238c",
      "metadata": {
        "id": "1bb0238c"
      },
      "source": [
        "## Interesting columns to check\n",
        "- label_product\n",
        "- product\n",
        "- category\n",
        "- description\n",
        "- name\n",
        "- text\n",
        "- title\n",
        "- url (scraper)\n",
        "- image (API)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "b2d7b19f",
      "metadata": {
        "id": "b2d7b19f",
        "outputId": "99598c76-200a-4eee-e605-2e3261dd5080"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "['an animal body part' 'an object' 'a print of an animal' 'a toy'\n",
            " 'a faux animal body part' 'a faux animal' 'a real animal']\n"
          ]
        }
      ],
      "source": [
        "unique_label_products = df['label_product'].unique()\n",
        "print(unique_label_products)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "7161ae5e",
      "metadata": {
        "id": "7161ae5e",
        "outputId": "60d23e83-f04b-48cf-d707-eede579042ef"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "['20MM RED LEATHER Watch Strap Real Flat Ostrich Watch Band Quick Release Men $21.99 - PicClick'\n",
            " '20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids Rockfish lingcod Soft Lure Blue $46.88 - PicClick'\n",
            " '25 UNPAINTED SALTWATER Round Ball Jig Heads RedFish Fluke Tinned Hook Lure $30.20 - PicClick'\n",
            " ... 'Green Cable Knit Cashmere Sweater Auction'\n",
            " 'All Bisque Asian Artist Doll 9 Inch Tall Auction'\n",
            " 'Keith Haring 1986 mural in Amsterdam to be restored']\n",
            "1768\n"
          ]
        }
      ],
      "source": [
        "unique_product = df['product'].unique()\n",
        "print(unique_product)\n",
        "\n",
        "unique_product_count = df['product'].nunique()\n",
        "print(unique_product_count)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "e03beaae",
      "metadata": {
        "scrolled": false,
        "id": "e03beaae",
        "outputId": "48201212-bb3d-4068-8e7f-4403545db08d"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "['None' 'Landscape Paintings' 'Portrait Paintings' 'Still-life Paintings'\n",
            " 'More Prints' 'Prints and Multiples' 'Portrait Prints'\n",
            " 'Figurative Sculptures' 'Barware' 'Platters and Serveware' 'Chairs'\n",
            " 'Pendant Necklaces' 'Watches' 'Scrolls, Screens & Fan Paintings'\n",
            " 'Paintings' 'Sideboards & Buffets' 'Collectibles' 'Railroad Collectibles'\n",
            " 'Belts' 'Candle Holders' 'Sweaters' \"Women's Clothing\"]\n",
            "22\n"
          ]
        }
      ],
      "source": [
        "unique_category = df['category'].unique()\n",
        "print(unique_category)\n",
        "\n",
        "unique_category_count = df['category'].nunique()\n",
        "print(unique_category_count)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "1ea712af",
      "metadata": {
        "id": "1ea712af",
        "outputId": "7578e828-6f55-4cd2-e6da-3573c38d5b61"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "['None' '17th Century' '2010-' 'Early 19th Century' '1710-1719'\n",
            " '1940-1949' '1990-1999' '1950-1959' 'Late 18th Century' '1980-1989'\n",
            " 'Mid-20th Century' 'Late 19th Century' 'Late 20th Century']\n",
            "13\n"
          ]
        }
      ],
      "source": [
        "unique_production_data = df['production_data'].unique()\n",
        "print(unique_production_data)\n",
        "\n",
        "unique_production_data_count = df['production_data'].nunique()\n",
        "print(unique_production_data_count)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "b96b227e",
      "metadata": {
        "id": "b96b227e",
        "outputId": "a2bc739b-deee-4f6b-b125-a12c7eabc0ef"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "['None' 'ArtGallery' 'FurnitureStore' 'JewelryStore' 'Person']\n",
            "5\n"
          ]
        }
      ],
      "source": [
        "unique_seller_type = df['seller_type'].unique()\n",
        "print(unique_seller_type)\n",
        "\n",
        "unique_seller_type_count = df['seller_type'].nunique()\n",
        "print(unique_seller_type_count)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "518392b0",
      "metadata": {
        "id": "518392b0"
      },
      "source": [
        "## Keep the data that has 'None' or null as category\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "16ef5890",
      "metadata": {
        "id": "16ef5890",
        "outputId": "eeb79302-2d07-49ab-9eca-bb1b45cfbaf0"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "url                2179\n",
              "title              2179\n",
              "text               2179\n",
              "domain             2179\n",
              "name               2179\n",
              "description        2179\n",
              "image              2179\n",
              "retrieved          2179\n",
              "production_data    2179\n",
              "category           2179\n",
              "price              1248\n",
              "currency           2179\n",
              "seller             2179\n",
              "seller_type        2179\n",
              "seller_url         2179\n",
              "location             48\n",
              "ships to           2179\n",
              "id                 2179\n",
              "loc_name              0\n",
              "lat                   0\n",
              "lon                   0\n",
              "country               0\n",
              "product            2179\n",
              "label_product      2179\n",
              "score_product      2179\n",
              "label              2179\n",
              "score              2179\n",
              "dtype: int64"
            ]
          },
          "execution_count": 4,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_filtered_by_category = df[(df['category'] == 'None') | (df['category'].isna())]\n",
        "\n",
        "df_filtered_by_category.count()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "5c6b894e",
      "metadata": {
        "scrolled": true,
        "id": "5c6b894e",
        "outputId": "b1e12bac-e887-4dfd-e81f-93bf18a8863c"
      },
      "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>label_product</th>\n",
              "      <th>product</th>\n",
              "      <th>category</th>\n",
              "      <th>description</th>\n",
              "      <th>name</th>\n",
              "      <th>text</th>\n",
              "      <th>title</th>\n",
              "      <th>url</th>\n",
              "      <th>image</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>None</td>\n",
              "      <td>20mm Red Leather Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>http://picclick.com/20mm-Red-Leather-Watch-Str...</td>\n",
              "      <td>https://www.picclickimg.com/4asAAOSwAatkmpPo/2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>an object</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>None</td>\n",
              "      <td>20pks 3\" Fishing Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>http://picclick.com/20pks-3-Fishing-Rock-Cod-R...</td>\n",
              "      <td>https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>an object</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>None</td>\n",
              "      <td>25 Unpainted Saltwater Round Ball Jig Heads Re...</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>http://picclick.com/25-Unpainted-Saltwater-Rou...</td>\n",
              "      <td>https://www.picclickimg.com/NH0AAOSwNmVkutkl/2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>None</td>\n",
              "      <td>2893 Kuhnert 1911 - African Ostrich. Giclee Fi...</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>http://picclick.com/2893-Kuhnert-1911-African-...</td>\n",
              "      <td>https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>an object</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>None</td>\n",
              "      <td>40/20Pcs Soft Fishing Lure Paddle Tail Swimbai...</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>http://picclick.com/40-20Pcs-Soft-Fishing-Lure...</td>\n",
              "      <td>https://www.picclickimg.com/qFgAAOSwsxdkrjzO/4...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2200</th>\n",
              "      <td>an object</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>\\n</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.liveauctioneers.com/item/68939501_...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2201</th>\n",
              "      <td>an object</td>\n",
              "      <td>Keith Haring 1986 mural in Amsterdam to be res...</td>\n",
              "      <td>None</td>\n",
              "      <td>AMSTERDAM – The mural by Keith Haring at the F...</td>\n",
              "      <td>Keith Haring 1986 mural in Amsterdam to be res...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\nKeith Haring 1986 mura...</td>\n",
              "      <td>Keith Haring 1986 mural in Amsterdam to be res...</td>\n",
              "      <td>https://www.liveauctioneers.com/news/top-news/...</td>\n",
              "      <td>https://www.liveauctioneers.com/news/wp-conten...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2202</th>\n",
              "      <td>an object</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>\\n</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.liveauctioneers.com/search/?catego...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2203</th>\n",
              "      <td>an object</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>\\n</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.liveauctioneers.com/search/?catego...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2204</th>\n",
              "      <td>an object</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>\\n</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.liveauctioneers.com/search/?catego...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2179 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            label_product                                            product  \\\n",
              "0     an animal body part  20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1               an object  20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2               an object  25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3     an animal body part  2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   \n",
              "4               an object  40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "...                   ...                                                ...   \n",
              "2200            an object                                               None   \n",
              "2201            an object  Keith Haring 1986 mural in Amsterdam to be res...   \n",
              "2202            an object                                               None   \n",
              "2203            an object                                               None   \n",
              "2204            an object                                               None   \n",
              "\n",
              "     category                                        description  \\\n",
              "0        None  20mm Red Leather Watch Strap Real Flat Ostrich...   \n",
              "1        None  20pks 3\" Fishing Rock Cod Rig Twin Bulb Squids...   \n",
              "2        None  25 Unpainted Saltwater Round Ball Jig Heads Re...   \n",
              "3        None  2893 Kuhnert 1911 - African Ostrich. Giclee Fi...   \n",
              "4        None  40/20Pcs Soft Fishing Lure Paddle Tail Swimbai...   \n",
              "...       ...                                                ...   \n",
              "2200     None                                               None   \n",
              "2201     None  AMSTERDAM – The mural by Keith Haring at the F...   \n",
              "2202     None                                               None   \n",
              "2203     None                                               None   \n",
              "2204     None                                               None   \n",
              "\n",
              "                                                   name  \\\n",
              "0     20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1     20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2     25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3                   2893 KUHNERT 1911 - African Ostrich   \n",
              "4     40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "...                                                 ...   \n",
              "2200                                               None   \n",
              "2201  Keith Haring 1986 mural in Amsterdam to be res...   \n",
              "2202                                               None   \n",
              "2203                                               None   \n",
              "2204                                               None   \n",
              "\n",
              "                                                   text  \\\n",
              "0     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "1     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "2     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "3     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "4     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "...                                                 ...   \n",
              "2200                                                 \\n   \n",
              "2201  \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\nKeith Haring 1986 mura...   \n",
              "2202                                                 \\n   \n",
              "2203                                                 \\n   \n",
              "2204                                                 \\n   \n",
              "\n",
              "                                                  title  \\\n",
              "0     20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1     20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2     25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3     2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   \n",
              "4     40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "...                                                 ...   \n",
              "2200                                               None   \n",
              "2201  Keith Haring 1986 mural in Amsterdam to be res...   \n",
              "2202                                               None   \n",
              "2203                                               None   \n",
              "2204                                               None   \n",
              "\n",
              "                                                    url  \\\n",
              "0     http://picclick.com/20mm-Red-Leather-Watch-Str...   \n",
              "1     http://picclick.com/20pks-3-Fishing-Rock-Cod-R...   \n",
              "2     http://picclick.com/25-Unpainted-Saltwater-Rou...   \n",
              "3     http://picclick.com/2893-Kuhnert-1911-African-...   \n",
              "4     http://picclick.com/40-20Pcs-Soft-Fishing-Lure...   \n",
              "...                                                 ...   \n",
              "2200  https://www.liveauctioneers.com/item/68939501_...   \n",
              "2201  https://www.liveauctioneers.com/news/top-news/...   \n",
              "2202  https://www.liveauctioneers.com/search/?catego...   \n",
              "2203  https://www.liveauctioneers.com/search/?catego...   \n",
              "2204  https://www.liveauctioneers.com/search/?catego...   \n",
              "\n",
              "                                                  image  \n",
              "0     https://www.picclickimg.com/4asAAOSwAatkmpPo/2...  \n",
              "1     https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/2...  \n",
              "2     https://www.picclickimg.com/NH0AAOSwNmVkutkl/2...  \n",
              "3     https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...  \n",
              "4     https://www.picclickimg.com/qFgAAOSwsxdkrjzO/4...  \n",
              "...                                                 ...  \n",
              "2200                                               None  \n",
              "2201  https://www.liveauctioneers.com/news/wp-conten...  \n",
              "2202                                               None  \n",
              "2203                                               None  \n",
              "2204                                               None  \n",
              "\n",
              "[2179 rows x 9 columns]"
            ]
          },
          "execution_count": 6,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "columns_to_keep = ['label_product', 'product', 'category', 'description', 'name', 'text', 'title', 'url', 'image']\n",
        "\n",
        "new_table = df_filtered_by_category[columns_to_keep]\n",
        "\n",
        "new_table\n",
        "# new_table.to_csv('/home/hp2229_nyu_edu/Project/WildLife/filtered_data.csv', index=False)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "9ce1aba7",
      "metadata": {
        "id": "9ce1aba7"
      },
      "source": [
        "## Check label_product\n",
        "> not only \"an animal body part\", other label might have a potential trafficking\n",
        "- search param is not related to wildlife trafficking\n",
        "- e.g: an object [404]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "ab8b9c12",
      "metadata": {
        "scrolled": true,
        "id": "ab8b9c12"
      },
      "outputs": [],
      "source": [
        "df_filtered_by_object = df[df['label_product'] == \"an object\"]\n",
        "df_filtered_by_url_image = df_filtered_by_object[['url', 'image', 'label_product']]\n",
        "\n",
        "\n",
        "object_file_path = '/home/hp2229_nyu_edu/Project/WildLife/filtered_by_object.csv'\n",
        "df_filtered_by_url_image.to_csv(object_file_path, index=False)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "05c5f4e1",
      "metadata": {
        "id": "05c5f4e1"
      },
      "source": [
        "## Check url and image\n",
        "> image might help to figure out\n",
        "1. image data sometimes cannot represent the product on the url <br />\n",
        "e.g: [402]\n",
        "\n",
        "2. the image data is one part of images from page <br />\n",
        "e.g: [1]\n",
        "\n",
        "3. Null - how can we choose one from many? <br />\n",
        "e.g: [410]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "4e503702",
      "metadata": {
        "id": "4e503702",
        "outputId": "e3235029-8e7e-4d89-a0f1-2a7ad65ebbf1"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "                                                                            url\n",
            "1  http://picclick.com/20pks-3-Fishing-Rock-Cod-Rig-Twin-Bulb-115430603496.html\n",
            "                                                                                      image\n",
            "1  https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/20pks-3-Fishing-Rock-Cod-Rig-Twin-Bulb.webp\n"
          ]
        }
      ],
      "source": [
        "# many images\n",
        "row_part = df_filtered_by_url_image.loc[[1]]\n",
        "print(row_part[[\"url\"]].to_string())\n",
        "print(row_part[[\"image\"]].to_string())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "467d5232",
      "metadata": {
        "scrolled": true,
        "id": "467d5232",
        "outputId": "ddfa72dd-10c5-4d3e-ea6e-7f030f72df2b"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "                                                                                               url\n",
            "538  https://www.ebay.ca/str/marinebargains/Teleflex-Steering-Systems/_i.html?store_cat=3510467017\n",
            "                                                          image\n",
            "538  https://i.ebayimg.com/images/g/nJ8AAOSwovNaDdVx/s-l300.jpg\n"
          ]
        }
      ],
      "source": [
        "# non-related (image: user's profile)\n",
        "row_part = df_filtered_by_url_image.iloc[[398]]\n",
        "print(row_part[[\"url\"]].to_string())\n",
        "print(row_part[[\"image\"]].to_string())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "fe76c3d8",
      "metadata": {
        "id": "fe76c3d8",
        "outputId": "f7ceaaf2-f06b-44bb-d9c2-03cd0d4ca841"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "                                                                                          url\n",
            "548  https://www.ebay.ch/b/Great-Planes-RC-Flugzeug-Modelle-Modellbausatze/182182/bn_86334806\n",
            "    image\n",
            "548  None\n"
          ]
        }
      ],
      "source": [
        "# Null\n",
        "row_part = df_filtered_by_url_image.iloc[[408]]\n",
        "print(row_part[[\"url\"]].to_string())\n",
        "print(row_part[[\"image\"]].to_string())"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "e00a093f",
      "metadata": {
        "id": "e00a093f"
      },
      "source": [
        "# How can we tell if it is a real animal?\n",
        "label: an object"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "40f63b0f",
      "metadata": {
        "scrolled": false,
        "id": "40f63b0f",
        "outputId": "82f6e70b-11e0-44b8-ea03-2550c7252a22"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "                                                                                                                                                                                                                                                                                                                                                                                                                                                  url\n",
            "400  https://www.ebay.at/itm/374960753312?amdata=enc%3AAQAIAAAA4BTaKAOaaSdCK3A8JxkvzYLlbxefvZS9q1ZYczzt%2BHTPAtNtBTbIpmsIgmd0y8el%2BVyq8DBKKiVKYniwd4H9JUEkacf5jqtNtfVVFXeF3j98BxfnSSIiWSPG7BgWO%2Bpmen3i5iot7q8GIleMGgJoD2r2EkE3aoJ4z%2Fe42plCXk6aoOaPuxoMoJctLcu213wUB0l7eK%2FP1XTPlxgkQNRfS8rgO85FEKHWQ7zDzh8eWemczcEUCQdf8B9BbSBCAwSg58IRXIDUU53tuCsvJV5aLP37E8z9mj5AcT6L%2BTJYWVzN%7Ctkp%3ABk9SR4LnoKneYg&hash=item574d670aa0:g:JmkAAOSwmuFhdCJh\n"
          ]
        }
      ],
      "source": [
        "row_null = df_filtered_by_url_image.loc[[400]]\n",
        "print(row_null[[\"url\"]].to_string())\n",
        "# print(row_part[[\"image\"]].to_string())"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "b8d4ab76",
      "metadata": {
        "id": "b8d4ab76"
      },
      "source": [
        "## Check label: 'an animal body part' and 'a real animal'\n",
        "Already filtered by category and organized with some of columns"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "125884eb",
      "metadata": {
        "id": "125884eb",
        "outputId": "ac5f0966-316f-4758-a633-52abbf439ddd"
      },
      "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>label_product</th>\n",
              "      <th>product</th>\n",
              "      <th>category</th>\n",
              "      <th>description</th>\n",
              "      <th>name</th>\n",
              "      <th>text</th>\n",
              "      <th>title</th>\n",
              "      <th>url</th>\n",
              "      <th>image</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>None</td>\n",
              "      <td>20mm Red Leather Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>http://picclick.com/20mm-Red-Leather-Watch-Str...</td>\n",
              "      <td>https://www.picclickimg.com/4asAAOSwAatkmpPo/2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>None</td>\n",
              "      <td>2893 Kuhnert 1911 - African Ostrich. Giclee Fi...</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>http://picclick.com/2893-Kuhnert-1911-African-...</td>\n",
              "      <td>https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>None</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>BATTLE BEASTS 1987 Condorassin figure LASER be...</td>\n",
              "      <td>http://picclick.com/BATTLE-BEASTS-1987-Condora...</td>\n",
              "      <td>https://www.picclickimg.com/ZN0AAOSw6l9lB2yi/B...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>BRING GOOD LUCK Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>None</td>\n",
              "      <td>Bring Good Luck Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>BRING GOOD LUCK Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>BRING GOOD LUCK Koi Red Fish Pendant Necklace ...</td>\n",
              "      <td>http://picclick.com/Bring-Good-Luck-Koi-Red-Fi...</td>\n",
              "      <td>https://www.picclickimg.com/tnsAAOSwDZljSbGz/B...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...</td>\n",
              "      <td>None</td>\n",
              "      <td>Fossilized Hemipristis Shark Tooth 1 3/8 Inch ...</td>\n",
              "      <td>FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...</td>\n",
              "      <td>FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...</td>\n",
              "      <td>http://picclick.com/Fossilized-Hemipristis-Sha...</td>\n",
              "      <td>https://www.picclickimg.com/mVoAAOSwPyReqhRO/F...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2040</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>Fishouflage Cotton T-Shirt Redfish/black Large...</td>\n",
              "      <td>None</td>\n",
              "      <td>Fishouflage Cotton T-Shirt Redfish/black Large...</td>\n",
              "      <td>Fishouflage Cotton T-Shirt Redfish/black Large</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\nFishouflage Cotton T-Shirt R...</td>\n",
              "      <td>Fishouflage Cotton T-Shirt Redfish/black Large...</td>\n",
              "      <td>https://www.ebid.net/ca/for-sale/848969002570-...</td>\n",
              "      <td>https://pic.ebid.net/upload_medbig/2/6/0/14619...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2070</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>2004 Burger King Yu Gi Oh The Movie Silver Fan...</td>\n",
              "      <td>None</td>\n",
              "      <td>2004 Burger King Yu Gi Oh The Movie Silver Fan...</td>\n",
              "      <td>2004 Burger King Yu Gi Oh The Movie Silver Fan...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\n2004 Burger King Yu Gi Oh Th...</td>\n",
              "      <td>2004 Burger King Yu Gi Oh The Movie Silver Fan...</td>\n",
              "      <td>https://www.ebid.net/uk/for-sale/2004-burger-k...</td>\n",
              "      <td>https://pic.ebid.net/upload_medbig/3/8/9/uo_16...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2079</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>the clyde valley stompers, peter and the wolf....</td>\n",
              "      <td>None</td>\n",
              "      <td>the clyde valley stompers, peter and the wolf....</td>\n",
              "      <td>the clyde valley stompers, peter and the wolf....</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\nthe clyde valley stompers, p...</td>\n",
              "      <td>the clyde valley stompers, peter and the wolf....</td>\n",
              "      <td>https://www.ebid.net/uk/for-sale/the-clyde-val...</td>\n",
              "      <td>https://pic.ebid.net/upload_medbig/8/3/3/13491...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2080</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>Wolf wolve Complete Counted Cross Stitch Kit 1...</td>\n",
              "      <td>None</td>\n",
              "      <td>Wolf wolve Complete Counted Cross Stitch Kit 1...</td>\n",
              "      <td>Wolf wolve Complete Counted Cross Stitch Kit 1...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\nWolf wolve Complete Counted ...</td>\n",
              "      <td>Wolf wolve Complete Counted Cross Stitch Kit 1...</td>\n",
              "      <td>https://www.ebid.net/uk/for-sale/wolf-wolve-co...</td>\n",
              "      <td>https://pic.ebid.net/upload_medbig/6/7/9/16806...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2087</th>\n",
              "      <td>an animal body part</td>\n",
              "      <td>Wolf | Items for Sale in Coins &amp; Banknotes &gt; C...</td>\n",
              "      <td>None</td>\n",
              "      <td>Wolf related items for sale in Coins &amp; Banknot...</td>\n",
              "      <td>Wolf | Items for Sale in Coins &amp; Banknotes &gt; C...</td>\n",
              "      <td>\\n\\n\\n\\n\\n\\n\\n\\n\\nWolf | Items for Sale in Coi...</td>\n",
              "      <td>Wolf | Items for Sale in Coins &amp; Banknotes &gt; C...</td>\n",
              "      <td>https://www.ebid.net/uk/perl/main.cgi?adult&amp;ca...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>634 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            label_product                                            product  \\\n",
              "0     an animal body part  20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "3     an animal body part  2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   \n",
              "8     an animal body part  BATTLE BEASTS 1987 Condorassin figure LASER be...   \n",
              "12    an animal body part  BRING GOOD LUCK Koi Red Fish Pendant Necklace ...   \n",
              "13    an animal body part  FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...   \n",
              "...                   ...                                                ...   \n",
              "2040  an animal body part  Fishouflage Cotton T-Shirt Redfish/black Large...   \n",
              "2070  an animal body part  2004 Burger King Yu Gi Oh The Movie Silver Fan...   \n",
              "2079  an animal body part  the clyde valley stompers, peter and the wolf....   \n",
              "2080  an animal body part  Wolf wolve Complete Counted Cross Stitch Kit 1...   \n",
              "2087  an animal body part  Wolf | Items for Sale in Coins & Banknotes > C...   \n",
              "\n",
              "     category                                        description  \\\n",
              "0        None  20mm Red Leather Watch Strap Real Flat Ostrich...   \n",
              "3        None  2893 Kuhnert 1911 - African Ostrich. Giclee Fi...   \n",
              "8        None  BATTLE BEASTS 1987 Condorassin figure LASER be...   \n",
              "12       None  Bring Good Luck Koi Red Fish Pendant Necklace ...   \n",
              "13       None  Fossilized Hemipristis Shark Tooth 1 3/8 Inch ...   \n",
              "...       ...                                                ...   \n",
              "2040     None  Fishouflage Cotton T-Shirt Redfish/black Large...   \n",
              "2070     None  2004 Burger King Yu Gi Oh The Movie Silver Fan...   \n",
              "2079     None  the clyde valley stompers, peter and the wolf....   \n",
              "2080     None  Wolf wolve Complete Counted Cross Stitch Kit 1...   \n",
              "2087     None  Wolf related items for sale in Coins & Banknot...   \n",
              "\n",
              "                                                   name  \\\n",
              "0     20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "3                   2893 KUHNERT 1911 - African Ostrich   \n",
              "8     BATTLE BEASTS 1987 Condorassin figure LASER be...   \n",
              "12    BRING GOOD LUCK Koi Red Fish Pendant Necklace ...   \n",
              "13    FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...   \n",
              "...                                                 ...   \n",
              "2040     Fishouflage Cotton T-Shirt Redfish/black Large   \n",
              "2070  2004 Burger King Yu Gi Oh The Movie Silver Fan...   \n",
              "2079  the clyde valley stompers, peter and the wolf....   \n",
              "2080  Wolf wolve Complete Counted Cross Stitch Kit 1...   \n",
              "2087  Wolf | Items for Sale in Coins & Banknotes > C...   \n",
              "\n",
              "                                                   text  \\\n",
              "0     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "3     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "8     \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "12    \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "13    \\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n...   \n",
              "...                                                 ...   \n",
              "2040  \\n\\n\\n\\n\\n\\n\\n\\n\\nFishouflage Cotton T-Shirt R...   \n",
              "2070  \\n\\n\\n\\n\\n\\n\\n\\n\\n2004 Burger King Yu Gi Oh Th...   \n",
              "2079  \\n\\n\\n\\n\\n\\n\\n\\n\\nthe clyde valley stompers, p...   \n",
              "2080  \\n\\n\\n\\n\\n\\n\\n\\n\\nWolf wolve Complete Counted ...   \n",
              "2087  \\n\\n\\n\\n\\n\\n\\n\\n\\nWolf | Items for Sale in Coi...   \n",
              "\n",
              "                                                  title  \\\n",
              "0     20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "3     2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   \n",
              "8     BATTLE BEASTS 1987 Condorassin figure LASER be...   \n",
              "12    BRING GOOD LUCK Koi Red Fish Pendant Necklace ...   \n",
              "13    FOSSILIZED HEMIPRISTIS SHARK Tooth 1 3/8 Inch ...   \n",
              "...                                                 ...   \n",
              "2040  Fishouflage Cotton T-Shirt Redfish/black Large...   \n",
              "2070  2004 Burger King Yu Gi Oh The Movie Silver Fan...   \n",
              "2079  the clyde valley stompers, peter and the wolf....   \n",
              "2080  Wolf wolve Complete Counted Cross Stitch Kit 1...   \n",
              "2087  Wolf | Items for Sale in Coins & Banknotes > C...   \n",
              "\n",
              "                                                    url  \\\n",
              "0     http://picclick.com/20mm-Red-Leather-Watch-Str...   \n",
              "3     http://picclick.com/2893-Kuhnert-1911-African-...   \n",
              "8     http://picclick.com/BATTLE-BEASTS-1987-Condora...   \n",
              "12    http://picclick.com/Bring-Good-Luck-Koi-Red-Fi...   \n",
              "13    http://picclick.com/Fossilized-Hemipristis-Sha...   \n",
              "...                                                 ...   \n",
              "2040  https://www.ebid.net/ca/for-sale/848969002570-...   \n",
              "2070  https://www.ebid.net/uk/for-sale/2004-burger-k...   \n",
              "2079  https://www.ebid.net/uk/for-sale/the-clyde-val...   \n",
              "2080  https://www.ebid.net/uk/for-sale/wolf-wolve-co...   \n",
              "2087  https://www.ebid.net/uk/perl/main.cgi?adult&ca...   \n",
              "\n",
              "                                                  image  \n",
              "0     https://www.picclickimg.com/4asAAOSwAatkmpPo/2...  \n",
              "3     https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...  \n",
              "8     https://www.picclickimg.com/ZN0AAOSw6l9lB2yi/B...  \n",
              "12    https://www.picclickimg.com/tnsAAOSwDZljSbGz/B...  \n",
              "13    https://www.picclickimg.com/mVoAAOSwPyReqhRO/F...  \n",
              "...                                                 ...  \n",
              "2040  https://pic.ebid.net/upload_medbig/2/6/0/14619...  \n",
              "2070  https://pic.ebid.net/upload_medbig/3/8/9/uo_16...  \n",
              "2079  https://pic.ebid.net/upload_medbig/8/3/3/13491...  \n",
              "2080  https://pic.ebid.net/upload_medbig/6/7/9/16806...  \n",
              "2087                                               None  \n",
              "\n",
              "[634 rows x 9 columns]"
            ]
          },
          "execution_count": 7,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_filtered_by_animal = new_table[(new_table['label_product'] == 'an animal body part') | (new_table['label_product'] == 'a real animal')]\n",
        "\n",
        "animal_file_path = '/home/hp2229_nyu_edu/Project/WildLife/filtered_by_animal.csv'\n",
        "df_filtered_by_animal.to_csv(animal_file_path, index=False)\n",
        "df_filtered_by_animal"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "acda34d9",
      "metadata": {
        "scrolled": true,
        "id": "acda34d9",
        "outputId": "d864ae0d-d0f8-4457-924f-07abe997296d"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "label_product    634\n",
              "product          634\n",
              "category         634\n",
              "description      634\n",
              "name             634\n",
              "text             634\n",
              "title            634\n",
              "url              634\n",
              "image            634\n",
              "dtype: int64"
            ]
          },
          "execution_count": 8,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_filtered_by_animal.count()"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "1c52cdf5",
      "metadata": {
        "id": "1c52cdf5"
      },
      "source": [
        "# File Merger"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "f65382c7",
      "metadata": {
        "id": "f65382c7"
      },
      "outputs": [],
      "source": [
        "processed_path = '/home/hp2229_nyu_edu/Project/WildLife/processed-data-oct'\n",
        "\n",
        "# Get a list of all Parquet files in the directory\n",
        "parquet_files = list(Path(processed_path).rglob('*.parquet'))\n",
        "\n",
        "combined_df = pd.DataFrame()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "142d9a33",
      "metadata": {
        "id": "142d9a33"
      },
      "outputs": [],
      "source": [
        "# Loop through each Parquet file\n",
        "# Selected columns: species, geography, prices\n",
        "for file in parquet_files:\n",
        "    table = pq.read_table(file, columns=['name', 'title', 'product', 'description', 'domain', 'country', 'label_product', 'price', 'currency', 'production_data', 'image', 'url', 'location', 'ships to', 'loc_name', 'lat', 'lon'])\n",
        "    df = table.to_pandas()\n",
        "    combined_df = combined_df.append(df, ignore_index=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "eb6ca391",
      "metadata": {
        "id": "eb6ca391"
      },
      "outputs": [],
      "source": [
        "file_path = '/home/hp2229_nyu_edu/Project/WildLife/combined_files.csv'\n",
        "combined_df.to_csv(file_path, index=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "50b06b5f",
      "metadata": {
        "scrolled": true,
        "id": "50b06b5f",
        "outputId": "f700d86d-eecf-4df9-e322-1557a10b44d4"
      },
      "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>name</th>\n",
              "      <th>title</th>\n",
              "      <th>product</th>\n",
              "      <th>description</th>\n",
              "      <th>domain</th>\n",
              "      <th>country</th>\n",
              "      <th>label_product</th>\n",
              "      <th>price</th>\n",
              "      <th>currency</th>\n",
              "      <th>production_data</th>\n",
              "      <th>image</th>\n",
              "      <th>url</th>\n",
              "      <th>location</th>\n",
              "      <th>ships to</th>\n",
              "      <th>loc_name</th>\n",
              "      <th>lat</th>\n",
              "      <th>lon</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>20MM RED LEATHER Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>20mm Red Leather Watch Strap Real Flat Ostrich...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>None</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>21.99</td>\n",
              "      <td>USD</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.picclickimg.com/4asAAOSwAatkmpPo/2...</td>\n",
              "      <td>http://picclick.com/20mm-Red-Leather-Watch-Str...</td>\n",
              "      <td>Houston, Texas, US</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>20pks 3\" Fishing Rock Cod Rig Twin Bulb Squids...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>None</td>\n",
              "      <td>an object</td>\n",
              "      <td>46.88</td>\n",
              "      <td>USD</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/2...</td>\n",
              "      <td>http://picclick.com/20pks-3-Fishing-Rock-Cod-R...</td>\n",
              "      <td>Chino Hills, California, US</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>25 UNPAINTED SALTWATER Round Ball Jig Heads Re...</td>\n",
              "      <td>25 Unpainted Saltwater Round Ball Jig Heads Re...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>None</td>\n",
              "      <td>an object</td>\n",
              "      <td>30.20</td>\n",
              "      <td>USD</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.picclickimg.com/NH0AAOSwNmVkutkl/2...</td>\n",
              "      <td>http://picclick.com/25-Unpainted-Saltwater-Rou...</td>\n",
              "      <td>Sayre, Pennsylvania, US</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...</td>\n",
              "      <td>2893 Kuhnert 1911 - African Ostrich. Giclee Fi...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>None</td>\n",
              "      <td>an animal body part</td>\n",
              "      <td>7.34</td>\n",
              "      <td>USD</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...</td>\n",
              "      <td>http://picclick.com/2893-Kuhnert-1911-African-...</td>\n",
              "      <td>Kirchen - Herkersdorf, DE</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...</td>\n",
              "      <td>40/20Pcs Soft Fishing Lure Paddle Tail Swimbai...</td>\n",
              "      <td>picclick.com</td>\n",
              "      <td>None</td>\n",
              "      <td>an object</td>\n",
              "      <td>7.99</td>\n",
              "      <td>USD</td>\n",
              "      <td>None</td>\n",
              "      <td>https://www.picclickimg.com/qFgAAOSwsxdkrjzO/4...</td>\n",
              "      <td>http://picclick.com/40-20Pcs-Soft-Fishing-Lure...</td>\n",
              "      <td>Guangzhou, CN</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                name  \\\n",
              "0  20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1  20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2  25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3                2893 KUHNERT 1911 - African Ostrich   \n",
              "4  40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "\n",
              "                                               title  \\\n",
              "0  20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1  20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2  25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3  2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   \n",
              "4  40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "\n",
              "                                             product  \\\n",
              "0  20MM RED LEATHER Watch Strap Real Flat Ostrich...   \n",
              "1  20PKS 3\" FISHING Rock Cod Rig Twin Bulb Squids...   \n",
              "2  25 UNPAINTED SALTWATER Round Ball Jig Heads Re...   \n",
              "3  2893 KUHNERT 1911 - African Ostrich $7.34 - Pi...   \n",
              "4  40/20PCS SOFT FISHING Lure Paddle Tail Swimbai...   \n",
              "\n",
              "                                         description        domain country  \\\n",
              "0  20mm Red Leather Watch Strap Real Flat Ostrich...  picclick.com    None   \n",
              "1  20pks 3\" Fishing Rock Cod Rig Twin Bulb Squids...  picclick.com    None   \n",
              "2  25 Unpainted Saltwater Round Ball Jig Heads Re...  picclick.com    None   \n",
              "3  2893 Kuhnert 1911 - African Ostrich. Giclee Fi...  picclick.com    None   \n",
              "4  40/20Pcs Soft Fishing Lure Paddle Tail Swimbai...  picclick.com    None   \n",
              "\n",
              "         label_product  price currency production_data  \\\n",
              "0  an animal body part  21.99      USD            None   \n",
              "1            an object  46.88      USD            None   \n",
              "2            an object  30.20      USD            None   \n",
              "3  an animal body part   7.34      USD            None   \n",
              "4            an object   7.99      USD            None   \n",
              "\n",
              "                                               image  \\\n",
              "0  https://www.picclickimg.com/4asAAOSwAatkmpPo/2...   \n",
              "1  https://www.picclickimg.com/ZW4AAOSwBKNjTkVr/2...   \n",
              "2  https://www.picclickimg.com/NH0AAOSwNmVkutkl/2...   \n",
              "3  https://www.picclickimg.com/ABAAAOSwYrtjm-Ii/2...   \n",
              "4  https://www.picclickimg.com/qFgAAOSwsxdkrjzO/4...   \n",
              "\n",
              "                                                 url  \\\n",
              "0  http://picclick.com/20mm-Red-Leather-Watch-Str...   \n",
              "1  http://picclick.com/20pks-3-Fishing-Rock-Cod-R...   \n",
              "2  http://picclick.com/25-Unpainted-Saltwater-Rou...   \n",
              "3  http://picclick.com/2893-Kuhnert-1911-African-...   \n",
              "4  http://picclick.com/40-20Pcs-Soft-Fishing-Lure...   \n",
              "\n",
              "                      location ships to loc_name  lat  lon  \n",
              "0           Houston, Texas, US     None     None  NaN  NaN  \n",
              "1  Chino Hills, California, US     None     None  NaN  NaN  \n",
              "2      Sayre, Pennsylvania, US     None     None  NaN  NaN  \n",
              "3    Kirchen - Herkersdorf, DE     None     None  NaN  NaN  \n",
              "4                Guangzhou, CN     None     None  NaN  NaN  "
            ]
          },
          "execution_count": 4,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "combined_df.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "261e0e87",
      "metadata": {
        "id": "261e0e87",
        "outputId": "b28147f6-8896-4c67-fbb9-801bc82fe67c"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "375726"
            ]
          },
          "execution_count": 15,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "combined_df.shape[0]"
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "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.13"
    },
    "colab": {
      "provenance": [],
      "collapsed_sections": [
        "37fab3c1",
        "1bb0238c",
        "518392b0",
        "9ce1aba7",
        "05c5f4e1",
        "b8d4ab76"
      ],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}