get_cnn_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import the necessary packages\n",
    "from imutils import paths\n",
    "import cv2\n",
    "import os\n",
    "import io\n",
    "import re\n",
    "import base64\n",
    "from PIL import Image\n",
    "import selenium\n",
    "import requests\n",
    "import time\n",
    "import pandas as pd\n",
    "from splinter import Browser\n",
    "from bs4 import BeautifulSoup as bs\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver import ActionChains\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.common.exceptions import TimeoutException"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Download more than 500 images of any given parameter\n",
    "def download_extended_urls(param):\n",
    "    google_url = \"https://www.google.com/imghp\"\n",
    "    driver = webdriver.Chrome()\n",
    "    try:\n",
    "        driver.get(google_url)\n",
    "        #browser.visit(google_url)\n",
    "        que=driver.find_element_by_xpath(\"//input[@name='q']\")\n",
    "        que.send_keys(param)\n",
    "        que.send_keys(Keys.RETURN)       \n",
    "        element = driver.find_element_by_tag_name(\"body\")\n",
    "        # Scroll down\n",
    "        for i in range(60):\n",
    "            element.send_keys(Keys.PAGE_DOWN)\n",
    "            time.sleep(0.3)\n",
    "        try:\n",
    "            driver.find_element_by_xpath('//*[@id=\"islmp\"]/div/div/div/div/div[5]/input').click()\n",
    "            for i in range(100):\n",
    "                element.send_keys(Keys.PAGE_DOWN)\n",
    "                time.sleep(0.3)  # bot id protection\n",
    "        except:\n",
    "            for i in range(30):\n",
    "                element.send_keys(Keys.PAGE_DOWN)\n",
    "                time.sleep(0.3)  # bot id protection\n",
    "\n",
    "        print(\"Reached end of Page.\")\n",
    "        time.sleep(0.5)\n",
    "\n",
    "        source = driver.page_source #page source\n",
    "        #close the browser\n",
    "        driver.close()\n",
    "    except Error as e:\n",
    "        print(e)\n",
    "        \n",
    "    url_list = []\n",
    "    soup = bs(source, \"html.parser\")\n",
    "    img = soup.find_all(\"img\", class_='rg_i Q4LuWd tx8vtf')\n",
    "    for i in img:\n",
    "        try:\n",
    "            url_list.append(i['src'])\n",
    "        except:\n",
    "            pass\n",
    "    with open(f'urls_for_training/{param}.txt', 'w') as filehandle:\n",
    "        for listitem in url_list:\n",
    "            filehandle.write('%s\\n' % listitem)\n",
    "    return url_list\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def download_img_from_url(param):\n",
    "    # grab the list of URLs then initialize the\n",
    "    # total number of images downloaded thus far\n",
    "    total = 0\n",
    "    # loop the URLs\n",
    "    for url in download_extended_urls(param):#[:70]:\n",
    "        try:\n",
    "            r = requests.get(url, timeout=60)\n",
    "            result_file = 'result_file'\n",
    "\n",
    "            with open(result_file, 'wb') as file_handler:\n",
    "                file_handler.write(r.content)\n",
    "            try:\n",
    "                os.mkdir(f\"image/{param}/\")\n",
    "            except:\n",
    "                pass\n",
    "            p = os.path.join(\"image\", param, \"{}.jpg\".format(str(total).zfill(8)))\n",
    "            Image.open(result_file).save(p)\n",
    "            os.remove(result_file)\n",
    "\n",
    "            # update the counter\n",
    "            print(\"[INFO] downloaded: {}\".format(p))\n",
    "        except:\n",
    "            try:       \n",
    "                z = re.findall(f'.+base64,(.+)',url)[0]\n",
    "                p = os.path.join(\"image\", param, \"{}.jpg\".format(str(total).zfill(8)))\n",
    "                im = Image.open(io.BytesIO(base64.b64decode(z))).save(p)\n",
    "            # handle if any exceptions are thrown during the download process\n",
    "            except:\n",
    "                print(\"[INFO] error downloading {}...skipping\".format(p))\n",
    "        total += 1\n",
    "    # loop over the image paths we just downloaded\n",
    "    for imagePath in paths.list_images(os.path.join(\"image\", param)):\n",
    "    # initialize if the image should be deleted or not\n",
    "        delete = False\n",
    "\n",
    "        # try to load the image\n",
    "        try:\n",
    "            image = cv2.imread(imagePath)\n",
    "            # if the image is `None` then we could not properly load it\n",
    "            # from disk, so delete it\n",
    "            if image is None:\n",
    "                print(\"None\")\n",
    "                delete = True\n",
    "        # if OpenCV cannot load the image then the image is likely\n",
    "        # corrupt so we should delete it\n",
    "        except:\n",
    "            print(\"Except\")\n",
    "            delete = True\n",
    "\n",
    "        # check to see if the image should be deleted\n",
    "        if delete:\n",
    "            print(\"[INFO] deleting {}\".format(imagePath))\n",
    "            os.remove(imagePath)\n",
    "    return"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "kitchen = \"Silverware organizer, Plates, Coffee mugs, Tongs, Spatulas, Ladles and Skimmer, Whisks,\\\n",
    "    Utensil holder, Cutting board, Pots and Pans, Baking sheets, Tupperware,\\\n",
    "    Bottle Opener & Corkscrew, Measuring Cups, spoons, Toaster oven, Microwave, Coffee Maker,\\\n",
    "    Coffee Grinder, Kettle, Blender, Colander, Salad spinner, Trash can, Trash bags, Step stool,\\\n",
    "    Magnetic hooks, Sponges, Dish soap, Drying rack, Dish towels, Napkins, Paper Towels,\\\n",
    "    Aluminum foil, wax paper, plastic wrap, Parchment paper, Plastic bags, Ice cube trays,\\\n",
    "    Can opener, Oven mits, Cooling mat, Rags, Paper towels, Windex, Clorox wipes, Stove cleaner, Rubber Gloves\"\n",
    "\n",
    "\n",
    "\n",
    "coco = \"bottle, wine glass, cup, fork, knife, spoon, bowl, diningtable, microwave, oven, toaster, \\\n",
    "       sink, refrigerator, scissors\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "param = \"dog\"\n",
    "google_url = \"https://www.google.com/imghp\"\n",
    "ChromeOptions = webdriver.ChromeOptions()\n",
    "ChromeOptions.set_headless()\n",
    "driver = webdriver.Chrome(chrome_options=ChromeOptions)\n",
    "actionChains = ActionChains(driver)\n",
    "try:\n",
    "    driver.get(google_url)\n",
    "    #browser.visit(google_url)\n",
    "    que=driver.find_element_by_xpath(\"//input[@name='q']\")\n",
    "    que.send_keys(param)\n",
    "    que.send_keys(Keys.RETURN)       \n",
    "    element = driver.find_element_by_tag_name(\"body\")\n",
    "    # Scroll down\n",
    "#     for i in range(5):\n",
    "#         element.send_keys(Keys.PAGE_DOWN)\n",
    "#         time.sleep(0.3)\n",
    "#     try:\n",
    "#         driver.find_element_by_xpath('//*[@id=\"islmp\"]/div/div/div/div/div[5]/input').click()\n",
    "#         for i in range(5):\n",
    "#             element.send_keys(Keys.PAGE_DOWN)\n",
    "#             time.sleep(0.3)  # bot id protection\n",
    "#     except:\n",
    "#         for i in range(5):\n",
    "#             element.send_keys(Keys.PAGE_DOWN)\n",
    "#             time.sleep(0.3)  # bot id protection\n",
    "    driver.find_element_by_xpath('/html/body/div[2]/c-wiz/div[3]/div[1]/div/div/div/div/div[1]/div[1]/div[1]/a[1]/div[1]/img').click()\n",
    "    #img = driver.find_element_by_xpath('/html/body/div[2]/c-wiz/div[3]/div[2]/div[3]/div/div/div[3]/div[2]/div/div[1]/div[1]/div/div[2]/a/img')\n",
    "    \n",
    "    img = WebDriverWait(driver, 20).until(EC.visibility_of_element_located((By.XPATH, '/html/body/div[2]/c-wiz/div[3]/div[2]/div[3]/div/div/div[3]/div[2]/div/div[1]/div[1]/div/div[2]/a/img')))\n",
    "    src = img.get_attribute('src')\n",
    "    print(src)\n",
    "    print(\"Reached end of Page.\")\n",
    "    time.sleep(0.5)\n",
    "\n",
    "    source = driver.page_source #page source\n",
    "    soup = bs(source, \"html.parser\")\n",
    "    #close the browser\n",
    "    #driver.close()\n",
    "except Error as e:\n",
    "    print(e)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_images = driver.execute_script(\"return document.getElementsByTagName('img')\")\n",
    "for image in range(0, len(all_images)):\n",
    "    print(driver.execute_script(\"return document.getElementsByTagName('img')[{}].src\".format(image)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(300, 168)"
      ]
     },
     "execution_count": 196,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "z = re.findall(f'.+base64,(.+)',src)[0]\n",
    "#p = os.path.join(\"image\", param, \"{}.jpg\".format(str(total).zfill(8)))\n",
    "im = Image.open(io.BytesIO(base64.b64decode(z)))\n",
    "im.size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(300, 168)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Image.open(\"doggy.jpg\").size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(257, 257)"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Image.open(\"55043370.jpg\").size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_list = []\n",
    "soup = bs(source, \"html.parser\")\n",
    "img = soup.find_all(\"img\", class_='rg_i Q4LuWd tx8vtf')\n",
    "for i in img:\n",
    "    try:\n",
    "        url_list.append(i['src'])\n",
    "    except:\n",
    "        pass\n",
    "with open(f'urls_for_training/{param}.txt', 'w') as filehandle:\n",
    "    for listitem in url_list:\n",
    "        filehandle.write('%s\\n' % listitem)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "no_pages = 5\n",
    "query = 'pots'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Scrape Amazon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 563,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_amazon_data(query,no_of_pages): \n",
    "    def get_data(query,no_of_pages):\n",
    "        amazon_dict = {\n",
    "                        \"featured\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"prime_delivery\":[]\n",
    "                        }, \n",
    "                        \"low_to_high\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"prime_delivery\":[]\n",
    "                        },\n",
    "                        \"high_to_low\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"prime_delivery\":[]\n",
    "                        }, \n",
    "                        \"average_customer_review\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"prime_delivery\":[]\n",
    "                        },\n",
    "                        \"newest_arrival\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"prime_delivery\":[]\n",
    "                        }\n",
    "                      }\n",
    "\n",
    "        executable_path = {\"executable_path\": \"/usr/local/bin/chromedriver\"}\n",
    "        browser = Browser(\"chrome\", **executable_path, headless=True)\n",
    "        for j in list(range(5)):\n",
    "            for i in list(range(no_of_pages)):\n",
    "                news_url = f\"https://www.amazon.com/s?k={query}&page={i}\"\n",
    "                try:\n",
    "                    browser.visit(news_url)\n",
    "                    browser.find_by_xpath('//*[@id=\"a-autoid-0\"]').click()\n",
    "                    browser.find_by_xpath(f'//*[@id=\"s-result-sort-select_{str(j)}\"]').click()\n",
    "                    html = browser.html\n",
    "                    soup = bs(html, \"html.parser\")\n",
    "\n",
    "                    for d in soup.findAll('div', attrs={'class':'sg-col-4-of-24 sg-col-4-of-12 sg-col-4-of-36 s-result-item s-asin sg-col-4-of-28 sg-col-4-of-16 sg-col sg-col-4-of-20 sg-col-4-of-32'}):\n",
    "                        name = d.find('span', attrs={'class':'a-size-base-plus a-color-base a-text-normal'})\n",
    "                        price = d.find('span', attrs={'class':'a-offscreen'})\n",
    "                        rating = d.find('span', attrs={'class':'a-icon-alt'})\n",
    "                        prime = d.find('i', attrs={'class':'a-icon a-icon-prime a-icon-medium'})\n",
    "                        img = d.find('img', attrs={'class':'s-image'})\n",
    "                        url = d.find('a', attrs={'class':'a-link-normal a-text-normal'})\n",
    "\n",
    "                        if name is not None and price is not None:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"products_name\"].append(name.text)\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"prices\"].append(price.text)\n",
    "\n",
    "                            if rating is not None:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"ratings\"].append(rating.text)\n",
    "                            else:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"ratings\"].append(\"Missing\")\n",
    "\n",
    "                            if img is not None:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"products_img\"].append(img[\"src\"])\n",
    "                            else:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"products_img\"].append(\" \")\n",
    "\n",
    "                            if url is not None:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"products_url\"].append(\"https://amazon.com\"+url[\"href\"])\n",
    "                            else:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"products_url\"].append(\" \")\n",
    "\n",
    "                            if prime is not None:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"prime_delivery\"].append(\"Prime Delivery\")\n",
    "                            else:\n",
    "                                amazon_dict[list(amazon_dict.keys())[j]][\"prime_delivery\"].append(\"Not Prime Delivery\")\n",
    "\n",
    "                except Error as e:\n",
    "                    print(e)\n",
    "        browser.quit()\n",
    "        return amazon_dict\n",
    "    data = None\n",
    "    str_error = None\n",
    "    num_retries = 20\n",
    "    for x in range(0, num_retries):  \n",
    "        try:\n",
    "            data = get_data(query,no_of_pages)\n",
    "        except Error as e:\n",
    "            pass\n",
    "\n",
    "        if data[\"high_to_low\"] == None:\n",
    "            continue \n",
    "        else:\n",
    "            break\n",
    "    return data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scrape Walmart"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 565,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_walmart_data(query,no_of_pages):\n",
    "    def get_data(query,no_of_pages):\n",
    "        drop_down = [\n",
    "            \"best_match--Best Match\",\n",
    "            \"best_seller--Best Sellers\",\n",
    "            \"price_low--Price: low to high\",\n",
    "            \"price_high--Price: high to low\",\n",
    "            \"rating_high--Highest Rating\",\n",
    "            \"new--New\"\n",
    "        ]\n",
    "        walmart_dict = {\n",
    "                        \"best_match\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"no_of_reviews\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"delivery_info\":[]\n",
    "                        },\n",
    "                        \"best_sellers\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"no_of_reviews\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"delivery_info\":[]\n",
    "                        },\n",
    "                        \"high_to_low\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"no_of_reviews\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"delivery_info\":[]\n",
    "                        }, \n",
    "                        \"low_to_high\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"no_of_reviews\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"delivery_info\":[]\n",
    "                        },\n",
    "                        \"highest_rating\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"no_of_reviews\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"delivery_info\":[]\n",
    "                        },\n",
    "                        \"newest_arrival\": {\n",
    "                            \"products_name\":[],\n",
    "                            \"prices\": [],\n",
    "                            \"ratings\":[],\n",
    "                            \"no_of_reviews\":[],\n",
    "                            \"products_img\":[],\n",
    "                            \"products_url\":[],\n",
    "                            \"delivery_info\":[]\n",
    "                        }\n",
    "                      }\n",
    "\n",
    "        executable_path = {\"executable_path\": \"/usr/local/bin/chromedriver\"}\n",
    "        browser = Browser(\"chrome\", **executable_path, headless=True)\n",
    "        for i in list(range(1,no_of_pages+1)):\n",
    "            url = f\"https://www.walmart.com/search/?page={i}&query={query}\"\n",
    "            browser.visit(url)\n",
    "            for j in list(range(6)):\n",
    "                browser.execute_script(\"window.scrollTo(0, -document.body.scrollHeight);\")\n",
    "                browser.find_by_xpath('//*[@id=\"SearchContainer\"]/div/div[2]/div/div[2]/div/div[2]/div[1]/div/select').click()\n",
    "                browser.find_by_value(drop_down[j]).click()\n",
    "                html = browser.html\n",
    "                soup = bs(html, \"html.parser\")\n",
    "\n",
    "                for d in soup.findAll('li'):\n",
    "                    try:\n",
    "                        name = d.find('div', attrs={'class':'search-result-product-title gridview'})\n",
    "                        price = d.find('span', attrs={'class':'price display-inline-block arrange-fit price price-main'})\\\n",
    "                            .find('span', attrs={'class':'visuallyhidden'})\n",
    "                        rating = d.find('span', attrs={'class':'seo-avg-rating'})\n",
    "                        review = d.find('span', attrs={'class':'seo-review-count'})\n",
    "                        delivery = d.find('div', attrs={'class':'search-result-product-shipping-details gridview'})\n",
    "                        img = d.find('div', attrs={'class':'orientation-square'}).find(\"img\")\n",
    "                        url = d.find('a', attrs={'class':'product-title-link line-clamp line-clamp-2 truncate-title'})\n",
    "\n",
    "                        if name.find(\"a\").find(\"span\") is not None and price is not None:\n",
    "                            walmart_dict[list(walmart_dict.keys())[j]][\"products_name\"].append(name.find(\"a\").find(\"span\").text)\n",
    "                            walmart_dict[list(walmart_dict.keys())[j]][\"prices\"].append(price.text)\n",
    "\n",
    "                            if rating is not None:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"ratings\"].append(rating.text)\n",
    "                            else:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"ratings\"].append(\"Missing Ratings\")\n",
    "\n",
    "                            if review is not None:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"no_of_reviews\"].append(rating.text)\n",
    "                            else:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"no_of_reviews\"].append(\"Missing Reviews\")\n",
    "\n",
    "                            if img is not None:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"products_img\"].append(img[\"data-image-src\"])\n",
    "                            else:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"products_img\"].append(\" \")\n",
    "\n",
    "                            if url is not None:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"products_url\"].append(\"https://walmart.com\"+url[\"href\"])\n",
    "                            else:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"products_url\"].append(\" \")\n",
    "\n",
    "                            if delivery is not None:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"delivery_info\"].append(delivery.text.replace(\"\\xa0\", \" \"))\n",
    "                            else:\n",
    "                                walmart_dict[list(walmart_dict.keys())[j]][\"delivery_info\"].append(\"Missing\")\n",
    "\n",
    "                    except:\n",
    "                        pass\n",
    "        browser.quit()\n",
    "        return walmart_dict\n",
    "    data = None\n",
    "    str_error = None\n",
    "    num_retries = 20\n",
    "    for x in range(0, num_retries):  \n",
    "        try:\n",
    "            data = get_data(query,no_of_pages)\n",
    "        except ElementClickInterceptedException as e:\n",
    "            pass\n",
    "\n",
    "        if data[\"high_to_low\"] == None:\n",
    "            continue \n",
    "        else:\n",
    "            break\n",
    "    return data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 571,
   "metadata": {},
   "outputs": [],
   "source": [
    "a = get_amazon_data('pencil',1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 572,
   "metadata": {},
   "outputs": [],
   "source": [
    "b = get_walmart_data(\"pencil\",1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 566,
   "metadata": {},
   "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>products_name</th>\n",
       "      <th>prices</th>\n",
       "      <th>ratings</th>\n",
       "      <th>products_img</th>\n",
       "      <th>products_url</th>\n",
       "      <th>prime_delivery</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6th Graders Are #1-36 Sixth Grade Pencils D2009</td>\n",
       "      <td>$3,263.34</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/31fjYXIHFW...</td>\n",
       "      <td>https://amazon.com/D2009-6th-Graders-Are-Penci...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Montblanc Meisterstuck Solitaire Malachite Hom...</td>\n",
       "      <td>$2,900.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/91g7IAVrdZ...</td>\n",
       "      <td>https://amazon.com/Montblanc-Meisterstuck-Soli...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10000 Pack, Personalized Custom Pencils, Round...</td>\n",
       "      <td>$2,349.00</td>\n",
       "      <td>4.8 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61zoczn-w4...</td>\n",
       "      <td>https://amazon.com/Personalized-Incentive-Teac...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5000 Pack, Military Personalized Custom Pencil...</td>\n",
       "      <td>$2,198.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/81sU3MI2gi...</td>\n",
       "      <td>https://amazon.com/Military-Personalized-Patri...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>D2240 Virginia - 144 Virginia State Quick Fact...</td>\n",
       "      <td>$2,100.02</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/31b+p0uQ8e...</td>\n",
       "      <td>https://amazon.com/D2240-Virginia-State-Quick-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>D2460 Crush The ISTEP - 144 Indiana Test Pencils</td>\n",
       "      <td>$1,723.44</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61P+rYUSkM...</td>\n",
       "      <td>https://amazon.com/D2460-Crush-ISTEP-Indiana-P...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NRS Natural Roughout Pencil Roll Team 14.5</td>\n",
       "      <td>$1,701.72</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/01RmK+J4pJ...</td>\n",
       "      <td>https://amazon.com/NRS-Natural-Roughout-Pencil...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5000 Pack, Personalized Custom Pencils, NEON R...</td>\n",
       "      <td>$1,349.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71G-uImfiC...</td>\n",
       "      <td>https://amazon.com/Personalized-Incentive-Teac...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Montblanc Alexandre Dumas 1996 Limited Edition...</td>\n",
       "      <td>$999.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/01RmK+J4pJ...</td>\n",
       "      <td>https://amazon.com/Montblanc-Alexandre-Limited...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mont Blanc Meisterstück Leonardo Sketch Pencil</td>\n",
       "      <td>$957.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41s3J4BVQk...</td>\n",
       "      <td>https://amazon.com/Blanc-Meisterst%C3%BCck-Leo...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Montegrappa Emozione Mechanical Pencil Yellow</td>\n",
       "      <td>$900.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41i94QOxNB...</td>\n",
       "      <td>https://amazon.com/Montegrappa-Emozione-Mechan...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Montblanc Meisterstuck 165DV Doue Vermeil Bord...</td>\n",
       "      <td>$857.95</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/9144VVHHDj...</td>\n",
       "      <td>https://amazon.com/Montblanc-Meisterstuck-Verm...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Montblanc Writers Edition 1994 Oscar Wilde Mec...</td>\n",
       "      <td>$799.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61Esy1DbEB...</td>\n",
       "      <td>https://amazon.com/Montblanc-Writers-Oscar-Mec...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Cross Townsend Lapis Lazuli Mecanical Pencil</td>\n",
       "      <td>$765.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/413LogKFhf...</td>\n",
       "      <td>https://amazon.com/dp/B00FV8XCWY/ref=sr_1_21?d...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14 inches Jumbo Yellow Pencil, Case of 144</td>\n",
       "      <td>$717.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/31Of3Q4dsS...</td>\n",
       "      <td>https://amazon.com/JUMBO-YELLOW-PENCIL-Case-14...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Caran d'Ache Varius Mechanical Pencil - Carbon</td>\n",
       "      <td>$703.18</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51w0UcCWp8...</td>\n",
       "      <td>https://amazon.com/Caran-dAche-Mechanical-Silv...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Montblanc Boheme Solitaire Platinum Plated Mec...</td>\n",
       "      <td>$645.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/21nC9mWxz9...</td>\n",
       "      <td>https://amazon.com/Montblanc-Solitaire-Platinu...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Charles Leonard 2317598 0.40 in. Primary No.2 ...</td>\n",
       "      <td>$644.31</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/31nPVh3wlq...</td>\n",
       "      <td>https://amazon.com/Charles-Leonard-2317598-Pri...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>A+Homework - Pencils No.2 - 10 Count - Premium...</td>\n",
       "      <td>$609.28</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/01RmK+J4pJ...</td>\n",
       "      <td>https://amazon.com/Homework-Pencils-Count-Prem...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Caran d'Ache Leman Grand Bleu Silver Plated Rh...</td>\n",
       "      <td>$525.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71GM-Vf0EG...</td>\n",
       "      <td>https://amazon.com/Silver-Plated-Rhodium-Coate...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Platinum PEN Mother-of-pearl Craft Triple Way ...</td>\n",
       "      <td>$517.07</td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51Nu4PQTfb...</td>\n",
       "      <td>https://amazon.com/Platinum-Mother-Mechanical-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Caran d'Ache Varius Mechanical Pencil, Ebony W...</td>\n",
       "      <td>$533.23</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41sohHFauN...</td>\n",
       "      <td>https://amazon.com/Caran-dAche-Mechanical-Plat...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Primo Euro Blend Charcoal Pencil Display Assor...</td>\n",
       "      <td>$503.56</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51C74K9sAR...</td>\n",
       "      <td>https://amazon.com/Primo-Charcoal-Pencil-Displ...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Valor Products No #2 Yellow Wood Pencil Bulk S...</td>\n",
       "      <td>$499.99</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61c8P1AbOo...</td>\n",
       "      <td>https://amazon.com/Valor-Products-Yellow-Wood-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Global-Dental Fine Blasting Unit Sandblaster T...</td>\n",
       "      <td>$499.99</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61VCycm+dP...</td>\n",
       "      <td>https://amazon.com/Global-Dental-Blasting-Sand...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Montblanc Boheme Mechanical Pencil 0.9mm 05097...</td>\n",
       "      <td>$499.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51+hQzWU+b...</td>\n",
       "      <td>https://amazon.com/Montblanc-Boheme-Mechanical...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Montblanc Meisterstuck 100th Anniversary 1906-...</td>\n",
       "      <td>$499.00</td>\n",
       "      <td>2.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51ivEq4rvP...</td>\n",
       "      <td>https://amazon.com/Montblanc-Meisterstuck-Anni...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Vienna Pencil with Black Rubber Grip - 300 Qua...</td>\n",
       "      <td>$495.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41J6b+tPHy...</td>\n",
       "      <td>https://amazon.com/Vienna-Pencil-Black-Rubber-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DISPLAY-CHARCOAL PENCILS Displays</td>\n",
       "      <td>$462.58</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41aGew0TfQ...</td>\n",
       "      <td>https://amazon.com/Generals-DISPLAY-CHARCOAL-P...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Montblanc Meisterstuck LeGrand Pencil Black &amp; ...</td>\n",
       "      <td>$460.31</td>\n",
       "      <td>4.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61B2idyQoB...</td>\n",
       "      <td>https://amazon.com/Montblanc-Meisterstuck-LeGr...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Caran d'Ache Leman Lilac (Purple) Silver Plate...</td>\n",
       "      <td>$460.00</td>\n",
       "      <td>4.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/214+HsWmNp...</td>\n",
       "      <td>https://amazon.com/Leman-Purple-Silver-Rhodium...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Caran d'Ache CD4769.019 0.7 mm Leman De Nuit M...</td>\n",
       "      <td>$451.75</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41lq+HHP6f...</td>\n",
       "      <td>https://amazon.com/Caran-dAche-CD4769-019-Mech...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Caran d'Ache Varius Silver Plated Ivanhoe Mech...</td>\n",
       "      <td>$546.70</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71LzQzAAEO...</td>\n",
       "      <td>https://amazon.com/Caran-dAche-Mechanical-Ivan...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Alvin, Draft-Matic, DM65D, Mechanical Pencil D...</td>\n",
       "      <td>$441.89</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/81xdm8SUho...</td>\n",
       "      <td>https://amazon.com/Alvin-DM65D-Draft-Matic-Mec...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Graf von Faber-Castell Classic Propelling Penc...</td>\n",
       "      <td>$440.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51v+hcFOPT...</td>\n",
       "      <td>https://amazon.com/Graf-von-Faber-Castell-Clas...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>144 pcs 7.5 inches Pencil Assortment, Case of 20</td>\n",
       "      <td>$436.20</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61h6mAO0Bd...</td>\n",
       "      <td>https://amazon.com/144-7-5-PENCIL-ASSORTMENT-C...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Caran d'Ache Leman Silver Plated Bicolor Mecha...</td>\n",
       "      <td>$435.48</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61d7-yIwpB...</td>\n",
       "      <td>https://amazon.com/Caran-dAche-Bicolor-Mechani...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Custom Pencils - SimpliColor Carpenter Pencil ...</td>\n",
       "      <td>$432.00</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61aIZaihGT...</td>\n",
       "      <td>https://amazon.com/Custom-Pencils-SimpliColor-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        products_name     prices  \\\n",
       "0     6th Graders Are #1-36 Sixth Grade Pencils D2009  $3,263.34   \n",
       "1   Montblanc Meisterstuck Solitaire Malachite Hom...  $2,900.00   \n",
       "2   10000 Pack, Personalized Custom Pencils, Round...  $2,349.00   \n",
       "3   5000 Pack, Military Personalized Custom Pencil...  $2,198.00   \n",
       "4   D2240 Virginia - 144 Virginia State Quick Fact...  $2,100.02   \n",
       "5    D2460 Crush The ISTEP - 144 Indiana Test Pencils  $1,723.44   \n",
       "6          NRS Natural Roughout Pencil Roll Team 14.5  $1,701.72   \n",
       "7   5000 Pack, Personalized Custom Pencils, NEON R...  $1,349.00   \n",
       "8   Montblanc Alexandre Dumas 1996 Limited Edition...    $999.00   \n",
       "9      Mont Blanc Meisterstück Leonardo Sketch Pencil    $957.00   \n",
       "10      Montegrappa Emozione Mechanical Pencil Yellow    $900.00   \n",
       "11  Montblanc Meisterstuck 165DV Doue Vermeil Bord...    $857.95   \n",
       "12  Montblanc Writers Edition 1994 Oscar Wilde Mec...    $799.00   \n",
       "13       Cross Townsend Lapis Lazuli Mecanical Pencil    $765.00   \n",
       "14         14 inches Jumbo Yellow Pencil, Case of 144    $717.00   \n",
       "15     Caran d'Ache Varius Mechanical Pencil - Carbon    $703.18   \n",
       "16  Montblanc Boheme Solitaire Platinum Plated Mec...    $645.00   \n",
       "17  Charles Leonard 2317598 0.40 in. Primary No.2 ...    $644.31   \n",
       "18  A+Homework - Pencils No.2 - 10 Count - Premium...    $609.28   \n",
       "19  Caran d'Ache Leman Grand Bleu Silver Plated Rh...    $525.00   \n",
       "20  Platinum PEN Mother-of-pearl Craft Triple Way ...    $517.07   \n",
       "21  Caran d'Ache Varius Mechanical Pencil, Ebony W...    $533.23   \n",
       "22  Primo Euro Blend Charcoal Pencil Display Assor...    $503.56   \n",
       "23  Valor Products No #2 Yellow Wood Pencil Bulk S...    $499.99   \n",
       "24  Global-Dental Fine Blasting Unit Sandblaster T...    $499.99   \n",
       "25  Montblanc Boheme Mechanical Pencil 0.9mm 05097...    $499.00   \n",
       "26  Montblanc Meisterstuck 100th Anniversary 1906-...    $499.00   \n",
       "27  Vienna Pencil with Black Rubber Grip - 300 Qua...    $495.00   \n",
       "28                  DISPLAY-CHARCOAL PENCILS Displays    $462.58   \n",
       "29  Montblanc Meisterstuck LeGrand Pencil Black & ...    $460.31   \n",
       "30  Caran d'Ache Leman Lilac (Purple) Silver Plate...    $460.00   \n",
       "31  Caran d'Ache CD4769.019 0.7 mm Leman De Nuit M...    $451.75   \n",
       "32  Caran d'Ache Varius Silver Plated Ivanhoe Mech...    $546.70   \n",
       "33  Alvin, Draft-Matic, DM65D, Mechanical Pencil D...    $441.89   \n",
       "34  Graf von Faber-Castell Classic Propelling Penc...    $440.00   \n",
       "35   144 pcs 7.5 inches Pencil Assortment, Case of 20    $436.20   \n",
       "36  Caran d'Ache Leman Silver Plated Bicolor Mecha...    $435.48   \n",
       "37  Custom Pencils - SimpliColor Carpenter Pencil ...    $432.00   \n",
       "\n",
       "               ratings                                       products_img  \\\n",
       "0              Missing  https://m.media-amazon.com/images/I/31fjYXIHFW...   \n",
       "1   5.0 out of 5 stars  https://m.media-amazon.com/images/I/91g7IAVrdZ...   \n",
       "2   4.8 out of 5 stars  https://m.media-amazon.com/images/I/61zoczn-w4...   \n",
       "3   5.0 out of 5 stars  https://m.media-amazon.com/images/I/81sU3MI2gi...   \n",
       "4              Missing  https://m.media-amazon.com/images/I/31b+p0uQ8e...   \n",
       "5              Missing  https://m.media-amazon.com/images/I/61P+rYUSkM...   \n",
       "6              Missing  https://m.media-amazon.com/images/I/01RmK+J4pJ...   \n",
       "7   5.0 out of 5 stars  https://m.media-amazon.com/images/I/71G-uImfiC...   \n",
       "8              Missing  https://m.media-amazon.com/images/I/01RmK+J4pJ...   \n",
       "9              Missing  https://m.media-amazon.com/images/I/41s3J4BVQk...   \n",
       "10             Missing  https://m.media-amazon.com/images/I/41i94QOxNB...   \n",
       "11             Missing  https://m.media-amazon.com/images/I/9144VVHHDj...   \n",
       "12             Missing  https://m.media-amazon.com/images/I/61Esy1DbEB...   \n",
       "13             Missing  https://m.media-amazon.com/images/I/413LogKFhf...   \n",
       "14             Missing  https://m.media-amazon.com/images/I/31Of3Q4dsS...   \n",
       "15             Missing  https://m.media-amazon.com/images/I/51w0UcCWp8...   \n",
       "16  5.0 out of 5 stars  https://m.media-amazon.com/images/I/21nC9mWxz9...   \n",
       "17             Missing  https://m.media-amazon.com/images/I/31nPVh3wlq...   \n",
       "18             Missing  https://m.media-amazon.com/images/I/01RmK+J4pJ...   \n",
       "19             Missing  https://m.media-amazon.com/images/I/71GM-Vf0EG...   \n",
       "20  3.9 out of 5 stars  https://m.media-amazon.com/images/I/51Nu4PQTfb...   \n",
       "21  5.0 out of 5 stars  https://m.media-amazon.com/images/I/41sohHFauN...   \n",
       "22             Missing  https://m.media-amazon.com/images/I/51C74K9sAR...   \n",
       "23             Missing  https://m.media-amazon.com/images/I/61c8P1AbOo...   \n",
       "24             Missing  https://m.media-amazon.com/images/I/61VCycm+dP...   \n",
       "25             Missing  https://m.media-amazon.com/images/I/51+hQzWU+b...   \n",
       "26  2.0 out of 5 stars  https://m.media-amazon.com/images/I/51ivEq4rvP...   \n",
       "27             Missing  https://m.media-amazon.com/images/I/41J6b+tPHy...   \n",
       "28             Missing  https://m.media-amazon.com/images/I/41aGew0TfQ...   \n",
       "29  4.0 out of 5 stars  https://m.media-amazon.com/images/I/61B2idyQoB...   \n",
       "30  4.0 out of 5 stars  https://m.media-amazon.com/images/I/214+HsWmNp...   \n",
       "31             Missing  https://m.media-amazon.com/images/I/41lq+HHP6f...   \n",
       "32  5.0 out of 5 stars  https://m.media-amazon.com/images/I/71LzQzAAEO...   \n",
       "33             Missing  https://m.media-amazon.com/images/I/81xdm8SUho...   \n",
       "34  5.0 out of 5 stars  https://m.media-amazon.com/images/I/51v+hcFOPT...   \n",
       "35             Missing  https://m.media-amazon.com/images/I/61h6mAO0Bd...   \n",
       "36             Missing  https://m.media-amazon.com/images/I/61d7-yIwpB...   \n",
       "37             Missing  https://m.media-amazon.com/images/I/61aIZaihGT...   \n",
       "\n",
       "                                         products_url      prime_delivery  \n",
       "0   https://amazon.com/D2009-6th-Graders-Are-Penci...  Not Prime Delivery  \n",
       "1   https://amazon.com/Montblanc-Meisterstuck-Soli...  Not Prime Delivery  \n",
       "2   https://amazon.com/Personalized-Incentive-Teac...  Not Prime Delivery  \n",
       "3   https://amazon.com/Military-Personalized-Patri...  Not Prime Delivery  \n",
       "4   https://amazon.com/D2240-Virginia-State-Quick-...  Not Prime Delivery  \n",
       "5   https://amazon.com/D2460-Crush-ISTEP-Indiana-P...  Not Prime Delivery  \n",
       "6   https://amazon.com/NRS-Natural-Roughout-Pencil...  Not Prime Delivery  \n",
       "7   https://amazon.com/Personalized-Incentive-Teac...  Not Prime Delivery  \n",
       "8   https://amazon.com/Montblanc-Alexandre-Limited...  Not Prime Delivery  \n",
       "9   https://amazon.com/Blanc-Meisterst%C3%BCck-Leo...  Not Prime Delivery  \n",
       "10  https://amazon.com/Montegrappa-Emozione-Mechan...  Not Prime Delivery  \n",
       "11  https://amazon.com/Montblanc-Meisterstuck-Verm...  Not Prime Delivery  \n",
       "12  https://amazon.com/Montblanc-Writers-Oscar-Mec...  Not Prime Delivery  \n",
       "13  https://amazon.com/dp/B00FV8XCWY/ref=sr_1_21?d...  Not Prime Delivery  \n",
       "14  https://amazon.com/JUMBO-YELLOW-PENCIL-Case-14...  Not Prime Delivery  \n",
       "15  https://amazon.com/Caran-dAche-Mechanical-Silv...  Not Prime Delivery  \n",
       "16  https://amazon.com/Montblanc-Solitaire-Platinu...      Prime Delivery  \n",
       "17  https://amazon.com/Charles-Leonard-2317598-Pri...  Not Prime Delivery  \n",
       "18  https://amazon.com/Homework-Pencils-Count-Prem...  Not Prime Delivery  \n",
       "19  https://amazon.com/Silver-Plated-Rhodium-Coate...  Not Prime Delivery  \n",
       "20  https://amazon.com/Platinum-Mother-Mechanical-...  Not Prime Delivery  \n",
       "21  https://amazon.com/Caran-dAche-Mechanical-Plat...  Not Prime Delivery  \n",
       "22  https://amazon.com/Primo-Charcoal-Pencil-Displ...  Not Prime Delivery  \n",
       "23  https://amazon.com/Valor-Products-Yellow-Wood-...  Not Prime Delivery  \n",
       "24  https://amazon.com/Global-Dental-Blasting-Sand...  Not Prime Delivery  \n",
       "25  https://amazon.com/Montblanc-Boheme-Mechanical...  Not Prime Delivery  \n",
       "26  https://amazon.com/Montblanc-Meisterstuck-Anni...  Not Prime Delivery  \n",
       "27  https://amazon.com/Vienna-Pencil-Black-Rubber-...  Not Prime Delivery  \n",
       "28  https://amazon.com/Generals-DISPLAY-CHARCOAL-P...  Not Prime Delivery  \n",
       "29  https://amazon.com/Montblanc-Meisterstuck-LeGr...  Not Prime Delivery  \n",
       "30  https://amazon.com/Leman-Purple-Silver-Rhodium...  Not Prime Delivery  \n",
       "31  https://amazon.com/Caran-dAche-CD4769-019-Mech...  Not Prime Delivery  \n",
       "32  https://amazon.com/Caran-dAche-Mechanical-Ivan...  Not Prime Delivery  \n",
       "33  https://amazon.com/Alvin-DM65D-Draft-Matic-Mec...  Not Prime Delivery  \n",
       "34  https://amazon.com/Graf-von-Faber-Castell-Clas...      Prime Delivery  \n",
       "35  https://amazon.com/144-7-5-PENCIL-ASSORTMENT-C...  Not Prime Delivery  \n",
       "36  https://amazon.com/Caran-dAche-Bicolor-Mechani...  Not Prime Delivery  \n",
       "37  https://amazon.com/Custom-Pencils-SimpliColor-...  Not Prime Delivery  "
      ]
     },
     "execution_count": 566,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(a[\"high_to_low\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 568,
   "metadata": {},
   "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>products_name</th>\n",
       "      <th>prices</th>\n",
       "      <th>ratings</th>\n",
       "      <th>no_of_reviews</th>\n",
       "      <th>products_img</th>\n",
       "      <th>products_url</th>\n",
       "      <th>delivery_info</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ticonderoga Soft Pencil - Yellow - Pre-Sharpen...</td>\n",
       "      <td>$6.33</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/3e2be000-2800...</td>\n",
       "      <td>https://walmart.com/ip/Ticonderoga-Soft-Pencil...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bic Xtra-Life Mechanical Pencils, Medium Point...</td>\n",
       "      <td>$4.54</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>https://i5.walmartimages.com/asr/3f8fc045-03b2...</td>\n",
       "      <td>https://walmart.com/ip/Bic-Xtra-Life-Mechanica...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ticonderoga Pencil, 24 Count, Unsharpened</td>\n",
       "      <td>$7.57</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/4dfceb90-e553...</td>\n",
       "      <td>https://walmart.com/ip/Ticonderoga-Pencil-24-C...</td>\n",
       "      <td>Sold &amp; shipped by TheMarket</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bic 24+3 Bonus Mechanical Pencil 0.7mm</td>\n",
       "      <td>$4.48</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/a61922f0-a57f...</td>\n",
       "      <td>https://walmart.com/ip/Bic-24-3-Bonus-Mechanic...</td>\n",
       "      <td>Free delivery on orders over $35Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Crayola Erasable Twistables Colored Pencils, 1...</td>\n",
       "      <td>$5.76</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/b4ddf078-5ef6...</td>\n",
       "      <td>https://walmart.com/ip/Crayola-Erasable-Twista...</td>\n",
       "      <td>2-day deliveryon orders $35+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BIC Xtra-Precision Mechanical Pencil, Metallic...</td>\n",
       "      <td>$4.93</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.3</td>\n",
       "      <td>https://i5.walmartimages.com/asr/e4250bd5-4397...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Xtra-Precision-Mech...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BiC Xtra Precision Mechanical Pencils #2 Fine ...</td>\n",
       "      <td>$4.74</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d1bccc7c-c6ba...</td>\n",
       "      <td>https://walmart.com/ip/BiC-Xtra-Precision-Mech...</td>\n",
       "      <td>Sold &amp; shipped by United Art and Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Paper Mate Clearpoint Mechanical Pencil Set, 0...</td>\n",
       "      <td>$4.46</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>https://i5.walmartimages.com/asr/016f894e-b6aa...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Clearpoint-M...</td>\n",
       "      <td>Free delivery on orders over $35Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Crayola Erasable Colored Pencil Set, 24-Colors</td>\n",
       "      <td>$5.97</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.1</td>\n",
       "      <td>https://i5.walmartimages.com/asr/256a0c1f-f521...</td>\n",
       "      <td>https://walmart.com/ip/Crayola-Erasable-Colore...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BIC Mechanical Pencil Xtra Life, Black, 10+2 Pack</td>\n",
       "      <td>$19.95</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>https://i5.walmartimages.com/asr/5fd592bd-fd8d...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Mechanical-Pencil-X...</td>\n",
       "      <td>Sold &amp; shipped by Rocky Mountain TextbooksFree...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Bic Velocity Original Mechanical Pencil, Thick...</td>\n",
       "      <td>$3.64</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/3c00226b-c390...</td>\n",
       "      <td>https://walmart.com/ip/Bic-Velocity-Original-M...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Pen + Gear Mechanical Pencils with Grip, 24 Pack</td>\n",
       "      <td>$3.32</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/28ba4ca7-0d1f...</td>\n",
       "      <td>https://walmart.com/ip/Pen-Gear-Mechanical-Pen...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BIC Xtra Comfort Mechanical Pencil, Medium Poi...</td>\n",
       "      <td>$6.03</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/adc0d6b5-b764...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Xtra-Comfort-Mechan...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Paper Mate Clearpoint Mechanical Pencil Set, 0...</td>\n",
       "      <td>$10.32</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>https://i5.walmartimages.com/asr/cd5310bd-7ae0...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Clearpoint-M...</td>\n",
       "      <td>Sold &amp; shipped by ivaluemart</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BIC Velocity Max Mechanical Pencil, Thick Poin...</td>\n",
       "      <td>$5.99</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>https://i5.walmartimages.com/asr/2b643dd4-c5a0...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Velocity-Max-Mechan...</td>\n",
       "      <td>Sold &amp; shipped by The Official BIC Store</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>My First Ticonderoga Pencil, Wood-Cased Large ...</td>\n",
       "      <td>$5.25</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>https://i5.walmartimages.com/asr/f2418f31-ffcb...</td>\n",
       "      <td>https://walmart.com/ip/My-First-Ticonderoga-Pe...</td>\n",
       "      <td>Sold &amp; shipped by Stuff4Crafts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Prang Colored Pencil Set, 36 Colors</td>\n",
       "      <td>$10.26</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>https://i5.walmartimages.com/asr/3bbc260d-ad8e...</td>\n",
       "      <td>https://walmart.com/ip/Prang-Colored-Pencil-Se...</td>\n",
       "      <td>2-day deliveryon orders $35+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Zebra Pen M-301 Stainless Steel Mechanical Pen...</td>\n",
       "      <td>$8.96</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/57f08bfa-6e69...</td>\n",
       "      <td>https://walmart.com/ip/Zebra-Pen-M-301-Stainle...</td>\n",
       "      <td>Sold &amp; shipped by Taber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BIC Velocity Pro Mechanical Pencil, Medium Poi...</td>\n",
       "      <td>$2.84</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/0b1e61be-79cc...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Velocity-Pro-Mechan...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Paper Mate Handwriting Triangular Mechanical P...</td>\n",
       "      <td>$3.24</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/365f30ae-51d2...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Handwriting-...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Pen + Gear Mechanical Pencils, 50 Pack</td>\n",
       "      <td>$5.44</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.3</td>\n",
       "      <td>https://i5.walmartimages.com/asr/48cfac2b-b000...</td>\n",
       "      <td>https://walmart.com/ip/Pen-Gear-Mechanical-Pen...</td>\n",
       "      <td>Free delivery on orders over $35Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Paper Mate Clearpoint Mechanical Pencils, 0.7m...</td>\n",
       "      <td>$6.57</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/7557fda8-760e...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Clearpoint-M...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Paper Mate Write Bros Mechanical Pencils, #2 H...</td>\n",
       "      <td>$8.95</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>https://i5.walmartimages.com/asr/11e341ed-f255...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Write-Bros-M...</td>\n",
       "      <td>Sold &amp; shipped by The Want Knott Store</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Prismacolor Scholar Colored Pencils 24/Pkg-</td>\n",
       "      <td>$11.89</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>https://i5.walmartimages.com/asr/213fab3f-114b...</td>\n",
       "      <td>https://walmart.com/ip/Prismacolor-Scholar-Col...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Ticonderoga Pencil 96 Count</td>\n",
       "      <td>$16.26</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/9d597d0f-f4b6...</td>\n",
       "      <td>https://walmart.com/ip/Ticonderoga-Pencil-96-C...</td>\n",
       "      <td>Sold &amp; shipped by Toysanity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Prismacolor, SAN14420, Ebony Sketching Pencil,...</td>\n",
       "      <td>$7.98</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/a946b9fc-f0a3...</td>\n",
       "      <td>https://walmart.com/ip/Prismacolor-SAN14420-Eb...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Crayola Trayola Bulk Colored Pencils Set, 54 C...</td>\n",
       "      <td>$13.53</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>https://i5.walmartimages.com/asr/c5f03c39-51d6...</td>\n",
       "      <td>https://walmart.com/ip/Crayola-Trayola-Bulk-Co...</td>\n",
       "      <td>2-day deliveryon orders $35+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Paper Mate Write Bros. Mechanical Pencils, 0.7...</td>\n",
       "      <td>$3.46</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d528cc8c-17cb...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Write-Bros-M...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Prismacolor Col-Erase Pencil w/Eraser, Carmine...</td>\n",
       "      <td>$6.40</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d3c42784-cd26...</td>\n",
       "      <td>https://walmart.com/ip/Prismacolor-Col-Erase-P...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>#2 USA Gold 24 Count Woodcase Pencils</td>\n",
       "      <td>$7.49</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/2df4bcaf-be8d...</td>\n",
       "      <td>https://walmart.com/ip/2-USA-Gold-24-Count-Woo...</td>\n",
       "      <td>Sold &amp; shipped by Laser Tek Services Inc.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>BIC Velocity Original + BIC Velocity Max Mecha...</td>\n",
       "      <td>$7.37</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/6dbb02a3-6c79...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Velocity-Original-B...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Pentel Sharp Mechanical Pencil (0.9mm), Yellow...</td>\n",
       "      <td>$3.29</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/c3100de7-8f63...</td>\n",
       "      <td>https://walmart.com/ip/Pentel-Sharp-Mechanical...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Dixon Ticonderoga #2 HB Soft Pencils, 0.5 mm, ...</td>\n",
       "      <td>$7.03</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/8df87e88-3101...</td>\n",
       "      <td>https://walmart.com/ip/Dixon-Ticonderoga-2-HB-...</td>\n",
       "      <td>Sold &amp; shipped by TheMarket</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Dixon Economy - #2 Soft - Yellow 144 ct</td>\n",
       "      <td>$17.32</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>https://i5.walmartimages.com/asr/4dc96476-04a1...</td>\n",
       "      <td>https://walmart.com/ip/Dixon-Economy-2-Soft-Ye...</td>\n",
       "      <td>2-day deliveryon orders $35+Sold &amp; shipped by ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Pentel Twist-Erase III Mechanical Pencil, (0.9...</td>\n",
       "      <td>$4.28</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/e06a3bbd-4a0f...</td>\n",
       "      <td>https://walmart.com/ip/Pentel-Twist-Erase-III-...</td>\n",
       "      <td>2-day deliveryon orders $35+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Crayola Colored Pencil Set, 100-Colors</td>\n",
       "      <td>$14.94</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>https://i5.walmartimages.com/asr/745f0564-84b6...</td>\n",
       "      <td>https://walmart.com/ip/Crayola-Colored-Pencil-...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        products_name  prices ratings  \\\n",
       "0   Ticonderoga Soft Pencil - Yellow - Pre-Sharpen...   $6.33     4.7   \n",
       "1   Bic Xtra-Life Mechanical Pencils, Medium Point...   $4.54     4.6   \n",
       "2           Ticonderoga Pencil, 24 Count, Unsharpened   $7.57     4.7   \n",
       "3              Bic 24+3 Bonus Mechanical Pencil 0.7mm   $4.48     4.7   \n",
       "4   Crayola Erasable Twistables Colored Pencils, 1...   $5.76     4.5   \n",
       "5   BIC Xtra-Precision Mechanical Pencil, Metallic...   $4.93     4.3   \n",
       "6   BiC Xtra Precision Mechanical Pencils #2 Fine ...   $4.74       4   \n",
       "7   Paper Mate Clearpoint Mechanical Pencil Set, 0...   $4.46     4.4   \n",
       "8      Crayola Erasable Colored Pencil Set, 24-Colors   $5.97     4.1   \n",
       "9   BIC Mechanical Pencil Xtra Life, Black, 10+2 Pack  $19.95     4.9   \n",
       "10  Bic Velocity Original Mechanical Pencil, Thick...   $3.64     4.8   \n",
       "11   Pen + Gear Mechanical Pencils with Grip, 24 Pack   $3.32     4.7   \n",
       "12  BIC Xtra Comfort Mechanical Pencil, Medium Poi...   $6.03     4.8   \n",
       "13  Paper Mate Clearpoint Mechanical Pencil Set, 0...  $10.32     4.2   \n",
       "14  BIC Velocity Max Mechanical Pencil, Thick Poin...   $5.99     4.9   \n",
       "15  My First Ticonderoga Pencil, Wood-Cased Large ...   $5.25     4.9   \n",
       "16                Prang Colored Pencil Set, 36 Colors  $10.26     4.6   \n",
       "17  Zebra Pen M-301 Stainless Steel Mechanical Pen...   $8.96     4.8   \n",
       "18  BIC Velocity Pro Mechanical Pencil, Medium Poi...   $2.84       5   \n",
       "19  Paper Mate Handwriting Triangular Mechanical P...   $3.24       5   \n",
       "20             Pen + Gear Mechanical Pencils, 50 Pack   $5.44     4.3   \n",
       "21  Paper Mate Clearpoint Mechanical Pencils, 0.7m...   $6.57     4.5   \n",
       "22  Paper Mate Write Bros Mechanical Pencils, #2 H...   $8.95     4.2   \n",
       "23        Prismacolor Scholar Colored Pencils 24/Pkg-  $11.89     4.4   \n",
       "24                        Ticonderoga Pencil 96 Count  $16.26     4.8   \n",
       "25  Prismacolor, SAN14420, Ebony Sketching Pencil,...   $7.98       5   \n",
       "26  Crayola Trayola Bulk Colored Pencils Set, 54 C...  $13.53     3.6   \n",
       "27  Paper Mate Write Bros. Mechanical Pencils, 0.7...   $3.46     4.8   \n",
       "28  Prismacolor Col-Erase Pencil w/Eraser, Carmine...   $6.40     4.5   \n",
       "29              #2 USA Gold 24 Count Woodcase Pencils   $7.49     3.5   \n",
       "30  BIC Velocity Original + BIC Velocity Max Mecha...   $7.37     4.5   \n",
       "31  Pentel Sharp Mechanical Pencil (0.9mm), Yellow...   $3.29     4.8   \n",
       "32  Dixon Ticonderoga #2 HB Soft Pencils, 0.5 mm, ...   $7.03     4.7   \n",
       "33            Dixon Economy - #2 Soft - Yellow 144 ct  $17.32     4.6   \n",
       "34  Pentel Twist-Erase III Mechanical Pencil, (0.9...   $4.28     4.8   \n",
       "35             Crayola Colored Pencil Set, 100-Colors  $14.94     4.4   \n",
       "\n",
       "   no_of_reviews                                       products_img  \\\n",
       "0            4.7  https://i5.walmartimages.com/asr/3e2be000-2800...   \n",
       "1            4.6  https://i5.walmartimages.com/asr/3f8fc045-03b2...   \n",
       "2            4.7  https://i5.walmartimages.com/asr/4dfceb90-e553...   \n",
       "3            4.7  https://i5.walmartimages.com/asr/a61922f0-a57f...   \n",
       "4            4.5  https://i5.walmartimages.com/asr/b4ddf078-5ef6...   \n",
       "5            4.3  https://i5.walmartimages.com/asr/e4250bd5-4397...   \n",
       "6              4  https://i5.walmartimages.com/asr/d1bccc7c-c6ba...   \n",
       "7            4.4  https://i5.walmartimages.com/asr/016f894e-b6aa...   \n",
       "8            4.1  https://i5.walmartimages.com/asr/256a0c1f-f521...   \n",
       "9            4.9  https://i5.walmartimages.com/asr/5fd592bd-fd8d...   \n",
       "10           4.8  https://i5.walmartimages.com/asr/3c00226b-c390...   \n",
       "11           4.7  https://i5.walmartimages.com/asr/28ba4ca7-0d1f...   \n",
       "12           4.8  https://i5.walmartimages.com/asr/adc0d6b5-b764...   \n",
       "13           4.2  https://i5.walmartimages.com/asr/cd5310bd-7ae0...   \n",
       "14           4.9  https://i5.walmartimages.com/asr/2b643dd4-c5a0...   \n",
       "15           4.9  https://i5.walmartimages.com/asr/f2418f31-ffcb...   \n",
       "16           4.6  https://i5.walmartimages.com/asr/3bbc260d-ad8e...   \n",
       "17           4.8  https://i5.walmartimages.com/asr/57f08bfa-6e69...   \n",
       "18             5  https://i5.walmartimages.com/asr/0b1e61be-79cc...   \n",
       "19             5  https://i5.walmartimages.com/asr/365f30ae-51d2...   \n",
       "20           4.3  https://i5.walmartimages.com/asr/48cfac2b-b000...   \n",
       "21           4.5  https://i5.walmartimages.com/asr/7557fda8-760e...   \n",
       "22           4.2  https://i5.walmartimages.com/asr/11e341ed-f255...   \n",
       "23           4.4  https://i5.walmartimages.com/asr/213fab3f-114b...   \n",
       "24           4.8  https://i5.walmartimages.com/asr/9d597d0f-f4b6...   \n",
       "25             5  https://i5.walmartimages.com/asr/a946b9fc-f0a3...   \n",
       "26           3.6  https://i5.walmartimages.com/asr/c5f03c39-51d6...   \n",
       "27           4.8  https://i5.walmartimages.com/asr/d528cc8c-17cb...   \n",
       "28           4.5  https://i5.walmartimages.com/asr/d3c42784-cd26...   \n",
       "29           3.5  https://i5.walmartimages.com/asr/2df4bcaf-be8d...   \n",
       "30           4.5  https://i5.walmartimages.com/asr/6dbb02a3-6c79...   \n",
       "31           4.8  https://i5.walmartimages.com/asr/c3100de7-8f63...   \n",
       "32           4.7  https://i5.walmartimages.com/asr/8df87e88-3101...   \n",
       "33           4.6  https://i5.walmartimages.com/asr/4dc96476-04a1...   \n",
       "34           4.8  https://i5.walmartimages.com/asr/e06a3bbd-4a0f...   \n",
       "35           4.4  https://i5.walmartimages.com/asr/745f0564-84b6...   \n",
       "\n",
       "                                         products_url  \\\n",
       "0   https://walmart.com/ip/Ticonderoga-Soft-Pencil...   \n",
       "1   https://walmart.com/ip/Bic-Xtra-Life-Mechanica...   \n",
       "2   https://walmart.com/ip/Ticonderoga-Pencil-24-C...   \n",
       "3   https://walmart.com/ip/Bic-24-3-Bonus-Mechanic...   \n",
       "4   https://walmart.com/ip/Crayola-Erasable-Twista...   \n",
       "5   https://walmart.com/ip/BIC-Xtra-Precision-Mech...   \n",
       "6   https://walmart.com/ip/BiC-Xtra-Precision-Mech...   \n",
       "7   https://walmart.com/ip/Paper-Mate-Clearpoint-M...   \n",
       "8   https://walmart.com/ip/Crayola-Erasable-Colore...   \n",
       "9   https://walmart.com/ip/BIC-Mechanical-Pencil-X...   \n",
       "10  https://walmart.com/ip/Bic-Velocity-Original-M...   \n",
       "11  https://walmart.com/ip/Pen-Gear-Mechanical-Pen...   \n",
       "12  https://walmart.com/ip/BIC-Xtra-Comfort-Mechan...   \n",
       "13  https://walmart.com/ip/Paper-Mate-Clearpoint-M...   \n",
       "14  https://walmart.com/ip/BIC-Velocity-Max-Mechan...   \n",
       "15  https://walmart.com/ip/My-First-Ticonderoga-Pe...   \n",
       "16  https://walmart.com/ip/Prang-Colored-Pencil-Se...   \n",
       "17  https://walmart.com/ip/Zebra-Pen-M-301-Stainle...   \n",
       "18  https://walmart.com/ip/BIC-Velocity-Pro-Mechan...   \n",
       "19  https://walmart.com/ip/Paper-Mate-Handwriting-...   \n",
       "20  https://walmart.com/ip/Pen-Gear-Mechanical-Pen...   \n",
       "21  https://walmart.com/ip/Paper-Mate-Clearpoint-M...   \n",
       "22  https://walmart.com/ip/Paper-Mate-Write-Bros-M...   \n",
       "23  https://walmart.com/ip/Prismacolor-Scholar-Col...   \n",
       "24  https://walmart.com/ip/Ticonderoga-Pencil-96-C...   \n",
       "25  https://walmart.com/ip/Prismacolor-SAN14420-Eb...   \n",
       "26  https://walmart.com/ip/Crayola-Trayola-Bulk-Co...   \n",
       "27  https://walmart.com/ip/Paper-Mate-Write-Bros-M...   \n",
       "28  https://walmart.com/ip/Prismacolor-Col-Erase-P...   \n",
       "29  https://walmart.com/ip/2-USA-Gold-24-Count-Woo...   \n",
       "30  https://walmart.com/ip/BIC-Velocity-Original-B...   \n",
       "31  https://walmart.com/ip/Pentel-Sharp-Mechanical...   \n",
       "32  https://walmart.com/ip/Dixon-Ticonderoga-2-HB-...   \n",
       "33  https://walmart.com/ip/Dixon-Economy-2-Soft-Ye...   \n",
       "34  https://walmart.com/ip/Pentel-Twist-Erase-III-...   \n",
       "35  https://walmart.com/ip/Crayola-Colored-Pencil-...   \n",
       "\n",
       "                                        delivery_info  \n",
       "0                    Free delivery on orders over $35  \n",
       "1                       Sold & shipped by Pharmapacks  \n",
       "2                         Sold & shipped by TheMarket  \n",
       "3   Free delivery on orders over $35Free pickup today  \n",
       "4                        2-day deliveryon orders $35+  \n",
       "5                                   Free pickup today  \n",
       "6          Sold & shipped by United Art and Education  \n",
       "7   Free delivery on orders over $35Free pickup today  \n",
       "8                                   Free pickup today  \n",
       "9   Sold & shipped by Rocky Mountain TextbooksFree...  \n",
       "10                                  Free pickup today  \n",
       "11                                  Free pickup today  \n",
       "12                      Sold & shipped by Pharmapacks  \n",
       "13                       Sold & shipped by ivaluemart  \n",
       "14           Sold & shipped by The Official BIC Store  \n",
       "15                     Sold & shipped by Stuff4Crafts  \n",
       "16                       2-day deliveryon orders $35+  \n",
       "17                            Sold & shipped by Taber  \n",
       "18                                  Free pickup today  \n",
       "19                                                     \n",
       "20  Free delivery on orders over $35Free pickup today  \n",
       "21                                  Free pickup today  \n",
       "22             Sold & shipped by The Want Knott Store  \n",
       "23                   Free delivery on orders over $35  \n",
       "24                        Sold & shipped by Toysanity  \n",
       "25                   Free delivery on orders over $35  \n",
       "26                       2-day deliveryon orders $35+  \n",
       "27                      Sold & shipped by Pharmapacks  \n",
       "28                   Free delivery on orders over $35  \n",
       "29          Sold & shipped by Laser Tek Services Inc.  \n",
       "30                                  Free pickup today  \n",
       "31                   Free delivery on orders over $35  \n",
       "32                        Sold & shipped by TheMarket  \n",
       "33  2-day deliveryon orders $35+Sold & shipped by ...  \n",
       "34                       2-day deliveryon orders $35+  \n",
       "35                                                     "
      ]
     },
     "execution_count": 568,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(b['high_to_low'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 569,
   "metadata": {},
   "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>products_name</th>\n",
       "      <th>prices</th>\n",
       "      <th>ratings</th>\n",
       "      <th>products_img</th>\n",
       "      <th>products_url</th>\n",
       "      <th>prime_delivery</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DIXON No. 2 Yellow Pencils, Wood-Cased, Black ...</td>\n",
       "      <td>$3.48</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71-tCs1ObM...</td>\n",
       "      <td>https://amazon.com/Dixon-Pencils-Wood-Cased-8-...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cra-Z-Art No. 2 wood Pencils 8 Count</td>\n",
       "      <td>$3.79</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71VvJWWCtU...</td>\n",
       "      <td>https://amazon.com/Cra-Z-Art-No-l%C3%A1pices-m...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>General Pencil 557-HB-BP Generals Charcoal Pen...</td>\n",
       "      <td>$6.76</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61vd0PBUOL...</td>\n",
       "      <td>https://amazon.com/General-Pencil-557-HB-BP-Ge...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lead Small, 12 Color Small Pencil Painting Pen...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/517PUpn3ms...</td>\n",
       "      <td>https://amazon.com/Pencil-Painting-Stationery-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dergo ☀Count Rainbow Pencils Black and White W...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>4.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/5168bLsXJi...</td>\n",
       "      <td>https://amazon.com/Dergo-%E2%98%80Count-Rainbo...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Paper Mate 74402 .7mm Write Brothers Mechanica...</td>\n",
       "      <td>$0.87</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/2148rHdDpd...</td>\n",
       "      <td>https://amazon.com/Paper-Mate-74402-Brothers-M...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Dergo Count Rainbow Pencils Black And White Wo...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51PdnWM72M...</td>\n",
       "      <td>https://amazon.com/Dergo-Rainbow-Pencils-Schoo...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dergo ☀ Iron Metal Mechanical Automatic Pencil...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41SkilOpMd...</td>\n",
       "      <td>https://amazon.com/Dergo-Mechanical-Automatic-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dergo ☀ Iron Metal Mechanical Automatic Pencil...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>1.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/4117Ewizn3...</td>\n",
       "      <td>https://amazon.com/Dergo-Mechanical-Automatic-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5pc Pencils Set,Black and White Wood Set Rainb...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/517dq5nGg9...</td>\n",
       "      <td>https://amazon.com/l%C3%A1pices-madera-blanco-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Clothful Pencil Refill, 15Pcs 0.5mmLron Resin ...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41Ns6Rg6eg...</td>\n",
       "      <td>https://amazon.com/Clothful-Pencil-0-5mmLron-A...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ywoow Hb12 Diamond Pencil Round Rod Writing Pe...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71fux7c9uH...</td>\n",
       "      <td>https://amazon.com/dp/B0888S3Z55/ref=sr_1_15?d...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Ywoow 20pcs Fashio New penciil New stylea Penc...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61v3fRTVze...</td>\n",
       "      <td>https://amazon.com/Ywoow-penciil-Supplies-Two-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fineday Soft Pencil, Colorful Magic Flexible S...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61oBqtTAcJ...</td>\n",
       "      <td>https://amazon.com/Fineday-Colorful-Flexible-C...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Xisheep Mechanical Pencil, Iron Metal Mechanic...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>3.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41+O9dDTD3...</td>\n",
       "      <td>https://amazon.com/Xisheep-Mechanical-Automati...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Xisheep Rainbow Pencil,5Pcs Black and White Wo...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/517dq5nGg9...</td>\n",
       "      <td>https://amazon.com/Xisheep-Rainbow-Pencil-Penc...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Xisheep Black White,Black and White Wood Set R...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/5168bLsXJi...</td>\n",
       "      <td>https://amazon.com/Xisheep-Rainbow-Pencils-Sch...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ywoow Soft Pencil, Colorful Magic Flexible Sof...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61oBqtTAcJ...</td>\n",
       "      <td>https://amazon.com/Ywoow-Colorful-Flexible-Chi...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Euone_Home Rroom Organizer0.5mm Iron Metal Mec...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41Cj47QpuL...</td>\n",
       "      <td>https://amazon.com/Euone_Home-Organizer0-5mm-M...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Clothful Home Office Accessories Gift, 5PCS Bl...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/517dq5nGg9...</td>\n",
       "      <td>https://amazon.com/Clothful-Accessories-Rainbo...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Clothful Home Office Accessories Gift, Black a...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/5168bLsXJi...</td>\n",
       "      <td>https://amazon.com/Clothful-Accessories-Rainbo...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>St. Patrick's Day，Colorful Magic Flexible Soft...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61oBqtTAcJ...</td>\n",
       "      <td>https://amazon.com/Patricks-Day%EF%BC%8CColorf...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Rainbow pencil Office Stationery Onsales, Blac...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>4.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/5168bLsXJi...</td>\n",
       "      <td>https://amazon.com/Rainbow-Stationery-Onsales-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>12 Pcs/lot Pencil for Drawing Sketching, HB Wr...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61-OXk7aDx...</td>\n",
       "      <td>https://amazon.com/Sketching-Stationery-Childr...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>12 Color Small Pencil Painting Pen Color Lead ...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51pqyQnYH7...</td>\n",
       "      <td>https://amazon.com/Pencil-Clearance-Painting-L...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Fxbar Rainbow Pencils Black And White Wood Set...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51PdnWM72M...</td>\n",
       "      <td>https://amazon.com/Fxbar-Rainbow-Pencils-Stati...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>lead pencil Clearance, 12 Color Small Pencil P...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51cXSf2dG6...</td>\n",
       "      <td>https://amazon.com/pencil-Clearance-Painting-L...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>SuperUS 30/60 Piece Pencils, Kid's Children Fl...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51yfhvbz-S...</td>\n",
       "      <td>https://amazon.com/SuperUS-Children-Flexible-E...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rainbow Pencils Set Black and White Wood Recyc...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/5168bLsXJi...</td>\n",
       "      <td>https://amazon.com/Rainbow-Pencils-Recycled-Sc...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Mechanical Pencils Set for Kids, Iuhan Automat...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>3.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51aTAAvWWt...</td>\n",
       "      <td>https://amazon.com/Mechanical-Iuhan-Automatic-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Dora The Explorer 10pk Colored Wood Pencils in...</td>\n",
       "      <td>$0.01</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/41N2Rx5zRj...</td>\n",
       "      <td>https://amazon.com/Dora-Explorer-10pk-Colored-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>#2 Wood Pencils</td>\n",
       "      <td>$4.54</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/31UtPPNhRB...</td>\n",
       "      <td>https://amazon.com/Office-Depot-BC23346-Wood-P...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NPW Sketch Safari Fuzzy Pencils in Tin Case, S...</td>\n",
       "      <td>$8.74</td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/91SSbK3w6o...</td>\n",
       "      <td>https://amazon.com/NPW-Sketch-Safari-Fuzzy-Pen...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Derwent Studio Pencil - ZINC YELLOW</td>\n",
       "      <td>$0.08</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/81lQ3nzPqe...</td>\n",
       "      <td>https://amazon.com/Derwent-Studio-Pencil-ZINC-...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Finance Plan 1Pc 2.0mm Black Lead Holder Draft...</td>\n",
       "      <td>$0.09</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/61POYI87yl...</td>\n",
       "      <td>https://amazon.com/Finance-Plan-Drafting-Stati...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Putars Colorful Magic Flexible Soft Pencil wit...</td>\n",
       "      <td>$0.09</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51yfhvbz-S...</td>\n",
       "      <td>https://amazon.com/Putars-Colorful-Flexible-Ch...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Disney Mickey Mouse and Friends 12 Wood Pencil...</td>\n",
       "      <td>$4.04</td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71DsI4fSHt...</td>\n",
       "      <td>https://amazon.com/Disney-Mickey-Mouse-Friends...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>6Pcs 2B Exam Mechanical Pencil with Set Office...</td>\n",
       "      <td>$0.16</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/51c2+gBeRn...</td>\n",
       "      <td>https://amazon.com/Mechanical-Pencil-Refills-O...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>BIC Velocity Max Mechanical Pencil, Medium Poi...</td>\n",
       "      <td>$5.16</td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>https://m.media-amazon.com/images/I/81y4DlTTt2...</td>\n",
       "      <td>https://amazon.com/BIC-Velocity-Mechanical-Pen...</td>\n",
       "      <td>Prime Delivery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Xisheep 12 Color Pencil,HB12 Diamond Pencil Ro...</td>\n",
       "      <td>$0.21</td>\n",
       "      <td>Missing</td>\n",
       "      <td>https://m.media-amazon.com/images/I/71fux7c9uH...</td>\n",
       "      <td>https://amazon.com/Xisheep-Diamond-Childrens-S...</td>\n",
       "      <td>Not Prime Delivery</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        products_name prices  \\\n",
       "0   DIXON No. 2 Yellow Pencils, Wood-Cased, Black ...  $3.48   \n",
       "1                Cra-Z-Art No. 2 wood Pencils 8 Count  $3.79   \n",
       "2   General Pencil 557-HB-BP Generals Charcoal Pen...  $6.76   \n",
       "3   Lead Small, 12 Color Small Pencil Painting Pen...  $0.01   \n",
       "4   Dergo ☀Count Rainbow Pencils Black and White W...  $0.01   \n",
       "5   Paper Mate 74402 .7mm Write Brothers Mechanica...  $0.87   \n",
       "6   Dergo Count Rainbow Pencils Black And White Wo...  $0.01   \n",
       "7   Dergo ☀ Iron Metal Mechanical Automatic Pencil...  $0.01   \n",
       "8   Dergo ☀ Iron Metal Mechanical Automatic Pencil...  $0.01   \n",
       "9   5pc Pencils Set,Black and White Wood Set Rainb...  $0.01   \n",
       "10  Clothful Pencil Refill, 15Pcs 0.5mmLron Resin ...  $0.01   \n",
       "11  Ywoow Hb12 Diamond Pencil Round Rod Writing Pe...  $0.01   \n",
       "12  Ywoow 20pcs Fashio New penciil New stylea Penc...  $0.01   \n",
       "13  Fineday Soft Pencil, Colorful Magic Flexible S...  $0.01   \n",
       "14  Xisheep Mechanical Pencil, Iron Metal Mechanic...  $0.01   \n",
       "15  Xisheep Rainbow Pencil,5Pcs Black and White Wo...  $0.01   \n",
       "16  Xisheep Black White,Black and White Wood Set R...  $0.01   \n",
       "17  Ywoow Soft Pencil, Colorful Magic Flexible Sof...  $0.01   \n",
       "18  Euone_Home Rroom Organizer0.5mm Iron Metal Mec...  $0.01   \n",
       "19  Clothful Home Office Accessories Gift, 5PCS Bl...  $0.01   \n",
       "20  Clothful Home Office Accessories Gift, Black a...  $0.01   \n",
       "21  St. Patrick's Day，Colorful Magic Flexible Soft...  $0.01   \n",
       "22  Rainbow pencil Office Stationery Onsales, Blac...  $0.01   \n",
       "23  12 Pcs/lot Pencil for Drawing Sketching, HB Wr...  $0.01   \n",
       "24  12 Color Small Pencil Painting Pen Color Lead ...  $0.01   \n",
       "25  Fxbar Rainbow Pencils Black And White Wood Set...  $0.01   \n",
       "26  lead pencil Clearance, 12 Color Small Pencil P...  $0.01   \n",
       "27  SuperUS 30/60 Piece Pencils, Kid's Children Fl...  $0.01   \n",
       "28  Rainbow Pencils Set Black and White Wood Recyc...  $0.01   \n",
       "29  Mechanical Pencils Set for Kids, Iuhan Automat...  $0.01   \n",
       "30  Dora The Explorer 10pk Colored Wood Pencils in...  $0.01   \n",
       "31                                    #2 Wood Pencils  $4.54   \n",
       "32  NPW Sketch Safari Fuzzy Pencils in Tin Case, S...  $8.74   \n",
       "33                Derwent Studio Pencil - ZINC YELLOW  $0.08   \n",
       "34  Finance Plan 1Pc 2.0mm Black Lead Holder Draft...  $0.09   \n",
       "35  Putars Colorful Magic Flexible Soft Pencil wit...  $0.09   \n",
       "36  Disney Mickey Mouse and Friends 12 Wood Pencil...  $4.04   \n",
       "37  6Pcs 2B Exam Mechanical Pencil with Set Office...  $0.16   \n",
       "38  BIC Velocity Max Mechanical Pencil, Medium Poi...  $5.16   \n",
       "39  Xisheep 12 Color Pencil,HB12 Diamond Pencil Ro...  $0.21   \n",
       "\n",
       "               ratings                                       products_img  \\\n",
       "0   4.4 out of 5 stars  https://m.media-amazon.com/images/I/71-tCs1ObM...   \n",
       "1              Missing  https://m.media-amazon.com/images/I/71VvJWWCtU...   \n",
       "2   4.4 out of 5 stars  https://m.media-amazon.com/images/I/61vd0PBUOL...   \n",
       "3              Missing  https://m.media-amazon.com/images/I/517PUpn3ms...   \n",
       "4   4.0 out of 5 stars  https://m.media-amazon.com/images/I/5168bLsXJi...   \n",
       "5              Missing  https://m.media-amazon.com/images/I/2148rHdDpd...   \n",
       "6              Missing  https://m.media-amazon.com/images/I/51PdnWM72M...   \n",
       "7   5.0 out of 5 stars  https://m.media-amazon.com/images/I/41SkilOpMd...   \n",
       "8   1.0 out of 5 stars  https://m.media-amazon.com/images/I/4117Ewizn3...   \n",
       "9              Missing  https://m.media-amazon.com/images/I/517dq5nGg9...   \n",
       "10  5.0 out of 5 stars  https://m.media-amazon.com/images/I/41Ns6Rg6eg...   \n",
       "11             Missing  https://m.media-amazon.com/images/I/71fux7c9uH...   \n",
       "12             Missing  https://m.media-amazon.com/images/I/61v3fRTVze...   \n",
       "13             Missing  https://m.media-amazon.com/images/I/61oBqtTAcJ...   \n",
       "14  3.0 out of 5 stars  https://m.media-amazon.com/images/I/41+O9dDTD3...   \n",
       "15             Missing  https://m.media-amazon.com/images/I/517dq5nGg9...   \n",
       "16             Missing  https://m.media-amazon.com/images/I/5168bLsXJi...   \n",
       "17             Missing  https://m.media-amazon.com/images/I/61oBqtTAcJ...   \n",
       "18             Missing  https://m.media-amazon.com/images/I/41Cj47QpuL...   \n",
       "19             Missing  https://m.media-amazon.com/images/I/517dq5nGg9...   \n",
       "20             Missing  https://m.media-amazon.com/images/I/5168bLsXJi...   \n",
       "21             Missing  https://m.media-amazon.com/images/I/61oBqtTAcJ...   \n",
       "22  4.0 out of 5 stars  https://m.media-amazon.com/images/I/5168bLsXJi...   \n",
       "23             Missing  https://m.media-amazon.com/images/I/61-OXk7aDx...   \n",
       "24             Missing  https://m.media-amazon.com/images/I/51pqyQnYH7...   \n",
       "25             Missing  https://m.media-amazon.com/images/I/51PdnWM72M...   \n",
       "26             Missing  https://m.media-amazon.com/images/I/51cXSf2dG6...   \n",
       "27             Missing  https://m.media-amazon.com/images/I/51yfhvbz-S...   \n",
       "28             Missing  https://m.media-amazon.com/images/I/5168bLsXJi...   \n",
       "29  3.0 out of 5 stars  https://m.media-amazon.com/images/I/51aTAAvWWt...   \n",
       "30             Missing  https://m.media-amazon.com/images/I/41N2Rx5zRj...   \n",
       "31  5.0 out of 5 stars  https://m.media-amazon.com/images/I/31UtPPNhRB...   \n",
       "32  4.6 out of 5 stars  https://m.media-amazon.com/images/I/91SSbK3w6o...   \n",
       "33             Missing  https://m.media-amazon.com/images/I/81lQ3nzPqe...   \n",
       "34             Missing  https://m.media-amazon.com/images/I/61POYI87yl...   \n",
       "35             Missing  https://m.media-amazon.com/images/I/51yfhvbz-S...   \n",
       "36  4.6 out of 5 stars  https://m.media-amazon.com/images/I/71DsI4fSHt...   \n",
       "37             Missing  https://m.media-amazon.com/images/I/51c2+gBeRn...   \n",
       "38  4.6 out of 5 stars  https://m.media-amazon.com/images/I/81y4DlTTt2...   \n",
       "39             Missing  https://m.media-amazon.com/images/I/71fux7c9uH...   \n",
       "\n",
       "                                         products_url      prime_delivery  \n",
       "0   https://amazon.com/Dixon-Pencils-Wood-Cased-8-...      Prime Delivery  \n",
       "1   https://amazon.com/Cra-Z-Art-No-l%C3%A1pices-m...      Prime Delivery  \n",
       "2   https://amazon.com/General-Pencil-557-HB-BP-Ge...      Prime Delivery  \n",
       "3   https://amazon.com/Pencil-Painting-Stationery-...  Not Prime Delivery  \n",
       "4   https://amazon.com/Dergo-%E2%98%80Count-Rainbo...  Not Prime Delivery  \n",
       "5   https://amazon.com/Paper-Mate-74402-Brothers-M...  Not Prime Delivery  \n",
       "6   https://amazon.com/Dergo-Rainbow-Pencils-Schoo...  Not Prime Delivery  \n",
       "7   https://amazon.com/Dergo-Mechanical-Automatic-...  Not Prime Delivery  \n",
       "8   https://amazon.com/Dergo-Mechanical-Automatic-...  Not Prime Delivery  \n",
       "9   https://amazon.com/l%C3%A1pices-madera-blanco-...  Not Prime Delivery  \n",
       "10  https://amazon.com/Clothful-Pencil-0-5mmLron-A...  Not Prime Delivery  \n",
       "11  https://amazon.com/dp/B0888S3Z55/ref=sr_1_15?d...  Not Prime Delivery  \n",
       "12  https://amazon.com/Ywoow-penciil-Supplies-Two-...  Not Prime Delivery  \n",
       "13  https://amazon.com/Fineday-Colorful-Flexible-C...  Not Prime Delivery  \n",
       "14  https://amazon.com/Xisheep-Mechanical-Automati...  Not Prime Delivery  \n",
       "15  https://amazon.com/Xisheep-Rainbow-Pencil-Penc...  Not Prime Delivery  \n",
       "16  https://amazon.com/Xisheep-Rainbow-Pencils-Sch...  Not Prime Delivery  \n",
       "17  https://amazon.com/Ywoow-Colorful-Flexible-Chi...  Not Prime Delivery  \n",
       "18  https://amazon.com/Euone_Home-Organizer0-5mm-M...  Not Prime Delivery  \n",
       "19  https://amazon.com/Clothful-Accessories-Rainbo...  Not Prime Delivery  \n",
       "20  https://amazon.com/Clothful-Accessories-Rainbo...  Not Prime Delivery  \n",
       "21  https://amazon.com/Patricks-Day%EF%BC%8CColorf...  Not Prime Delivery  \n",
       "22  https://amazon.com/Rainbow-Stationery-Onsales-...  Not Prime Delivery  \n",
       "23  https://amazon.com/Sketching-Stationery-Childr...  Not Prime Delivery  \n",
       "24  https://amazon.com/Pencil-Clearance-Painting-L...  Not Prime Delivery  \n",
       "25  https://amazon.com/Fxbar-Rainbow-Pencils-Stati...  Not Prime Delivery  \n",
       "26  https://amazon.com/pencil-Clearance-Painting-L...  Not Prime Delivery  \n",
       "27  https://amazon.com/SuperUS-Children-Flexible-E...  Not Prime Delivery  \n",
       "28  https://amazon.com/Rainbow-Pencils-Recycled-Sc...  Not Prime Delivery  \n",
       "29  https://amazon.com/Mechanical-Iuhan-Automatic-...  Not Prime Delivery  \n",
       "30  https://amazon.com/Dora-Explorer-10pk-Colored-...  Not Prime Delivery  \n",
       "31  https://amazon.com/Office-Depot-BC23346-Wood-P...      Prime Delivery  \n",
       "32  https://amazon.com/NPW-Sketch-Safari-Fuzzy-Pen...      Prime Delivery  \n",
       "33  https://amazon.com/Derwent-Studio-Pencil-ZINC-...  Not Prime Delivery  \n",
       "34  https://amazon.com/Finance-Plan-Drafting-Stati...  Not Prime Delivery  \n",
       "35  https://amazon.com/Putars-Colorful-Flexible-Ch...  Not Prime Delivery  \n",
       "36  https://amazon.com/Disney-Mickey-Mouse-Friends...      Prime Delivery  \n",
       "37  https://amazon.com/Mechanical-Pencil-Refills-O...  Not Prime Delivery  \n",
       "38  https://amazon.com/BIC-Velocity-Mechanical-Pen...      Prime Delivery  \n",
       "39  https://amazon.com/Xisheep-Diamond-Childrens-S...  Not Prime Delivery  "
      ]
     },
     "execution_count": 569,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(a[\"low_to_high\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 570,
   "metadata": {
    "scrolled": false
   },
   "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>products_name</th>\n",
       "      <th>prices</th>\n",
       "      <th>ratings</th>\n",
       "      <th>no_of_reviews</th>\n",
       "      <th>products_img</th>\n",
       "      <th>products_url</th>\n",
       "      <th>delivery_info</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Paper Mate Write Bros. Mechanical Pencils, 0.7...</td>\n",
       "      <td>$1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>https://i5.walmartimages.com/asr/04daf5d4-dcdb...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Write-Bros-M...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BIC Velocity Pro Mechanical Pencil, Medium Poi...</td>\n",
       "      <td>$2.84</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/0b1e61be-79cc...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Velocity-Pro-Mechan...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Paper Mate Handwriting Triangular Mechanical P...</td>\n",
       "      <td>$3.24</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/365f30ae-51d2...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Handwriting-...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pentel Sharp Mechanical Pencil (0.9mm), Yellow...</td>\n",
       "      <td>$3.29</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/c3100de7-8f63...</td>\n",
       "      <td>https://walmart.com/ip/Pentel-Sharp-Mechanical...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Paper Mate Write Bros. Mechanical Pencils, 0.7...</td>\n",
       "      <td>$3.46</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d528cc8c-17cb...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Write-Bros-M...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BiC Xtra Precision Mechanical Pencils #2 Fine ...</td>\n",
       "      <td>$4.74</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d1bccc7c-c6ba...</td>\n",
       "      <td>https://walmart.com/ip/BiC-Xtra-Precision-Mech...</td>\n",
       "      <td>Sold &amp; shipped by United Art and Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bic Velocity Original Mechanical Pencil, Thick...</td>\n",
       "      <td>$3.64</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/3c00226b-c390...</td>\n",
       "      <td>https://walmart.com/ip/Bic-Velocity-Original-M...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Pentel Twist-Erase III Mechanical Pencil, (0.9...</td>\n",
       "      <td>$4.28</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/e06a3bbd-4a0f...</td>\n",
       "      <td>https://walmart.com/ip/Pentel-Twist-Erase-III-...</td>\n",
       "      <td>2-day deliveryon orders $35+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Paper Mate Clearpoint Mechanical Pencil Set, 0...</td>\n",
       "      <td>$4.46</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>https://i5.walmartimages.com/asr/016f894e-b6aa...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Clearpoint-M...</td>\n",
       "      <td>Free delivery on orders over $35Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Bic 24+3 Bonus Mechanical Pencil 0.7mm</td>\n",
       "      <td>$4.48</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/a61922f0-a57f...</td>\n",
       "      <td>https://walmart.com/ip/Bic-24-3-Bonus-Mechanic...</td>\n",
       "      <td>Free delivery on orders over $35Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Bic Xtra-Life Mechanical Pencils, Medium Point...</td>\n",
       "      <td>$4.54</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>https://i5.walmartimages.com/asr/3f8fc045-03b2...</td>\n",
       "      <td>https://walmart.com/ip/Bic-Xtra-Life-Mechanica...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BIC Pencil Xtra Precision Mechanical Pencil, C...</td>\n",
       "      <td>$4.89</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/9b5c543a-6a3e...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Pencil-Xtra-Precisi...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BIC Xtra-Precision Mechanical Pencil, Metallic...</td>\n",
       "      <td>$4.93</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.3</td>\n",
       "      <td>https://i5.walmartimages.com/asr/e4250bd5-4397...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Xtra-Precision-Mech...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Paper Mate Clearpoint Mechanical Pencils Start...</td>\n",
       "      <td>$4.97</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d83ac42b-9eea...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Clearpoint-M...</td>\n",
       "      <td>Free delivery on orders over $35Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BIC Pencil Xtra Life Mechanical Pencil, Clear ...</td>\n",
       "      <td>$5.10</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d6a8f13a-ede6...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Pencil-Xtra-Life-Me...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Pentel Twist-Erase EXPRESS Pencil (0.7mm) Asst...</td>\n",
       "      <td>$5.31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://i5.walmartimages.com/asr/40c72a9d-2c4b...</td>\n",
       "      <td>https://walmart.com/ip/Pentel-Twist-Erase-EXPR...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Paper Mate SharpWriter Mechanical Pencils, 0.7...</td>\n",
       "      <td>$5.39</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/a3f02d15-6599...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-SharpWriter-...</td>\n",
       "      <td>Sold &amp; shipped by School Specialty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Pen + Gear Mechanical Pencils, 50 Pack</td>\n",
       "      <td>$5.44</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.3</td>\n",
       "      <td>https://i5.walmartimages.com/asr/48cfac2b-b000...</td>\n",
       "      <td>https://walmart.com/ip/Pen-Gear-Mechanical-Pen...</td>\n",
       "      <td>Free delivery on orders over $35Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Zebra Pen M-701 stainless steel mechanical pen...</td>\n",
       "      <td>$5.61</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/5c7be0a6-445f...</td>\n",
       "      <td>https://walmart.com/ip/Zebra-Pen-M-701-stainle...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Crayola Erasable Twistables Colored Pencils, 1...</td>\n",
       "      <td>$5.76</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/b4ddf078-5ef6...</td>\n",
       "      <td>https://walmart.com/ip/Crayola-Erasable-Twista...</td>\n",
       "      <td>2-day deliveryon orders $35+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BIC Velocity Original Mechanical Pencil, Mediu...</td>\n",
       "      <td>$5.76</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/1631454e-7d2d...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Velocity-Original-M...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Crayola Erasable Colored Pencil Set, 24-Colors</td>\n",
       "      <td>$5.97</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.1</td>\n",
       "      <td>https://i5.walmartimages.com/asr/256a0c1f-f521...</td>\n",
       "      <td>https://walmart.com/ip/Crayola-Erasable-Colore...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BIC Velocity Max Mechanical Pencil, Thick Poin...</td>\n",
       "      <td>$5.99</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>https://i5.walmartimages.com/asr/2b643dd4-c5a0...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Velocity-Max-Mechan...</td>\n",
       "      <td>Sold &amp; shipped by The Official BIC Store</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BIC Velocity Max Mechanical Pencil, Medium Poi...</td>\n",
       "      <td>$5.99</td>\n",
       "      <td>4.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>https://i5.walmartimages.com/asr/aaddaf52-b6be...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Velocity-Max-Mechan...</td>\n",
       "      <td>Sold &amp; shipped by The Official BIC Store</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BIC Xtra Comfort Mechanical Pencil, Medium Poi...</td>\n",
       "      <td>$6.03</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/adc0d6b5-b764...</td>\n",
       "      <td>https://walmart.com/ip/BIC-Xtra-Comfort-Mechan...</td>\n",
       "      <td>Sold &amp; shipped by Pharmapacks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Ticonderoga Soft Pencil - Yellow - Pre-Sharpen...</td>\n",
       "      <td>$6.33</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/3e2be000-2800...</td>\n",
       "      <td>https://walmart.com/ip/Ticonderoga-Soft-Pencil...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Prismacolor Col-Erase Pencil w/Eraser, Carmine...</td>\n",
       "      <td>$6.40</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/d3c42784-cd26...</td>\n",
       "      <td>https://walmart.com/ip/Prismacolor-Col-Erase-P...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Paper Mate Clearpoint Mechanical Pencils, 0.7m...</td>\n",
       "      <td>$6.57</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/7557fda8-760e...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Clearpoint-M...</td>\n",
       "      <td>Free pickup today</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Paper Mate, PAP1738795, Comfortable Ultra Mech...</td>\n",
       "      <td>$8.75</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.7</td>\n",
       "      <td>https://i5.walmartimages.com/asr/ac0b39e8-4e04...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-PAP1738795-C...</td>\n",
       "      <td>Sold &amp; shipped by BestSource OfficeSupplies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>#2 USA Gold 24 Count Woodcase Pencils</td>\n",
       "      <td>$7.49</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/2df4bcaf-be8d...</td>\n",
       "      <td>https://walmart.com/ip/2-USA-Gold-24-Count-Woo...</td>\n",
       "      <td>Sold &amp; shipped by Laser Tek Services Inc.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Prismacolor, SAN14420, Ebony Sketching Pencil,...</td>\n",
       "      <td>$7.98</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>https://i5.walmartimages.com/asr/a946b9fc-f0a3...</td>\n",
       "      <td>https://walmart.com/ip/Prismacolor-SAN14420-Eb...</td>\n",
       "      <td>Free delivery on orders over $35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Paper Mate Write Bros Mechanical Pencils, #2 H...</td>\n",
       "      <td>$8.95</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>https://i5.walmartimages.com/asr/11e341ed-f255...</td>\n",
       "      <td>https://walmart.com/ip/Paper-Mate-Write-Bros-M...</td>\n",
       "      <td>Sold &amp; shipped by The Want Knott Store</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Zebra Pen M-301 Stainless Steel Mechanical Pen...</td>\n",
       "      <td>$8.96</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>https://i5.walmartimages.com/asr/57f08bfa-6e69...</td>\n",
       "      <td>https://walmart.com/ip/Zebra-Pen-M-301-Stainle...</td>\n",
       "      <td>Sold &amp; shipped by Taber</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        products_name prices ratings  \\\n",
       "0   Paper Mate Write Bros. Mechanical Pencils, 0.7...  $1.00       1   \n",
       "1   BIC Velocity Pro Mechanical Pencil, Medium Poi...  $2.84       5   \n",
       "2   Paper Mate Handwriting Triangular Mechanical P...  $3.24       5   \n",
       "3   Pentel Sharp Mechanical Pencil (0.9mm), Yellow...  $3.29     4.8   \n",
       "4   Paper Mate Write Bros. Mechanical Pencils, 0.7...  $3.46     4.8   \n",
       "5   BiC Xtra Precision Mechanical Pencils #2 Fine ...  $4.74       4   \n",
       "6   Bic Velocity Original Mechanical Pencil, Thick...  $3.64     4.8   \n",
       "7   Pentel Twist-Erase III Mechanical Pencil, (0.9...  $4.28     4.8   \n",
       "8   Paper Mate Clearpoint Mechanical Pencil Set, 0...  $4.46     4.4   \n",
       "9              Bic 24+3 Bonus Mechanical Pencil 0.7mm  $4.48     4.7   \n",
       "10  Bic Xtra-Life Mechanical Pencils, Medium Point...  $4.54     4.6   \n",
       "11  BIC Pencil Xtra Precision Mechanical Pencil, C...  $4.89     4.7   \n",
       "12  BIC Xtra-Precision Mechanical Pencil, Metallic...  $4.93     4.3   \n",
       "13  Paper Mate Clearpoint Mechanical Pencils Start...  $4.97     4.4   \n",
       "14  BIC Pencil Xtra Life Mechanical Pencil, Clear ...  $5.10     4.7   \n",
       "15  Pentel Twist-Erase EXPRESS Pencil (0.7mm) Asst...  $5.31       0   \n",
       "16  Paper Mate SharpWriter Mechanical Pencils, 0.7...  $5.39     4.5   \n",
       "17             Pen + Gear Mechanical Pencils, 50 Pack  $5.44     4.3   \n",
       "18  Zebra Pen M-701 stainless steel mechanical pen...  $5.61     4.8   \n",
       "19  Crayola Erasable Twistables Colored Pencils, 1...  $5.76     4.5   \n",
       "20  BIC Velocity Original Mechanical Pencil, Mediu...  $5.76     4.8   \n",
       "21     Crayola Erasable Colored Pencil Set, 24-Colors  $5.97     4.1   \n",
       "22  BIC Velocity Max Mechanical Pencil, Thick Poin...  $5.99     4.9   \n",
       "23  BIC Velocity Max Mechanical Pencil, Medium Poi...  $5.99     4.9   \n",
       "24  BIC Xtra Comfort Mechanical Pencil, Medium Poi...  $6.03     4.8   \n",
       "25  Ticonderoga Soft Pencil - Yellow - Pre-Sharpen...  $6.33     4.7   \n",
       "26  Prismacolor Col-Erase Pencil w/Eraser, Carmine...  $6.40     4.5   \n",
       "27  Paper Mate Clearpoint Mechanical Pencils, 0.7m...  $6.57     4.5   \n",
       "28  Paper Mate, PAP1738795, Comfortable Ultra Mech...  $8.75     2.7   \n",
       "29              #2 USA Gold 24 Count Woodcase Pencils  $7.49     3.5   \n",
       "30  Prismacolor, SAN14420, Ebony Sketching Pencil,...  $7.98       5   \n",
       "31  Paper Mate Write Bros Mechanical Pencils, #2 H...  $8.95     4.2   \n",
       "32  Zebra Pen M-301 Stainless Steel Mechanical Pen...  $8.96     4.8   \n",
       "\n",
       "   no_of_reviews                                       products_img  \\\n",
       "0              1  https://i5.walmartimages.com/asr/04daf5d4-dcdb...   \n",
       "1              5  https://i5.walmartimages.com/asr/0b1e61be-79cc...   \n",
       "2              5  https://i5.walmartimages.com/asr/365f30ae-51d2...   \n",
       "3            4.8  https://i5.walmartimages.com/asr/c3100de7-8f63...   \n",
       "4            4.8  https://i5.walmartimages.com/asr/d528cc8c-17cb...   \n",
       "5              4  https://i5.walmartimages.com/asr/d1bccc7c-c6ba...   \n",
       "6            4.8  https://i5.walmartimages.com/asr/3c00226b-c390...   \n",
       "7            4.8  https://i5.walmartimages.com/asr/e06a3bbd-4a0f...   \n",
       "8            4.4  https://i5.walmartimages.com/asr/016f894e-b6aa...   \n",
       "9            4.7  https://i5.walmartimages.com/asr/a61922f0-a57f...   \n",
       "10           4.6  https://i5.walmartimages.com/asr/3f8fc045-03b2...   \n",
       "11           4.7  https://i5.walmartimages.com/asr/9b5c543a-6a3e...   \n",
       "12           4.3  https://i5.walmartimages.com/asr/e4250bd5-4397...   \n",
       "13           4.4  https://i5.walmartimages.com/asr/d83ac42b-9eea...   \n",
       "14           4.7  https://i5.walmartimages.com/asr/d6a8f13a-ede6...   \n",
       "15             0  https://i5.walmartimages.com/asr/40c72a9d-2c4b...   \n",
       "16           4.5  https://i5.walmartimages.com/asr/a3f02d15-6599...   \n",
       "17           4.3  https://i5.walmartimages.com/asr/48cfac2b-b000...   \n",
       "18           4.8  https://i5.walmartimages.com/asr/5c7be0a6-445f...   \n",
       "19           4.5  https://i5.walmartimages.com/asr/b4ddf078-5ef6...   \n",
       "20           4.8  https://i5.walmartimages.com/asr/1631454e-7d2d...   \n",
       "21           4.1  https://i5.walmartimages.com/asr/256a0c1f-f521...   \n",
       "22           4.9  https://i5.walmartimages.com/asr/2b643dd4-c5a0...   \n",
       "23           4.9  https://i5.walmartimages.com/asr/aaddaf52-b6be...   \n",
       "24           4.8  https://i5.walmartimages.com/asr/adc0d6b5-b764...   \n",
       "25           4.7  https://i5.walmartimages.com/asr/3e2be000-2800...   \n",
       "26           4.5  https://i5.walmartimages.com/asr/d3c42784-cd26...   \n",
       "27           4.5  https://i5.walmartimages.com/asr/7557fda8-760e...   \n",
       "28           2.7  https://i5.walmartimages.com/asr/ac0b39e8-4e04...   \n",
       "29           3.5  https://i5.walmartimages.com/asr/2df4bcaf-be8d...   \n",
       "30             5  https://i5.walmartimages.com/asr/a946b9fc-f0a3...   \n",
       "31           4.2  https://i5.walmartimages.com/asr/11e341ed-f255...   \n",
       "32           4.8  https://i5.walmartimages.com/asr/57f08bfa-6e69...   \n",
       "\n",
       "                                         products_url  \\\n",
       "0   https://walmart.com/ip/Paper-Mate-Write-Bros-M...   \n",
       "1   https://walmart.com/ip/BIC-Velocity-Pro-Mechan...   \n",
       "2   https://walmart.com/ip/Paper-Mate-Handwriting-...   \n",
       "3   https://walmart.com/ip/Pentel-Sharp-Mechanical...   \n",
       "4   https://walmart.com/ip/Paper-Mate-Write-Bros-M...   \n",
       "5   https://walmart.com/ip/BiC-Xtra-Precision-Mech...   \n",
       "6   https://walmart.com/ip/Bic-Velocity-Original-M...   \n",
       "7   https://walmart.com/ip/Pentel-Twist-Erase-III-...   \n",
       "8   https://walmart.com/ip/Paper-Mate-Clearpoint-M...   \n",
       "9   https://walmart.com/ip/Bic-24-3-Bonus-Mechanic...   \n",
       "10  https://walmart.com/ip/Bic-Xtra-Life-Mechanica...   \n",
       "11  https://walmart.com/ip/BIC-Pencil-Xtra-Precisi...   \n",
       "12  https://walmart.com/ip/BIC-Xtra-Precision-Mech...   \n",
       "13  https://walmart.com/ip/Paper-Mate-Clearpoint-M...   \n",
       "14  https://walmart.com/ip/BIC-Pencil-Xtra-Life-Me...   \n",
       "15  https://walmart.com/ip/Pentel-Twist-Erase-EXPR...   \n",
       "16  https://walmart.com/ip/Paper-Mate-SharpWriter-...   \n",
       "17  https://walmart.com/ip/Pen-Gear-Mechanical-Pen...   \n",
       "18  https://walmart.com/ip/Zebra-Pen-M-701-stainle...   \n",
       "19  https://walmart.com/ip/Crayola-Erasable-Twista...   \n",
       "20  https://walmart.com/ip/BIC-Velocity-Original-M...   \n",
       "21  https://walmart.com/ip/Crayola-Erasable-Colore...   \n",
       "22  https://walmart.com/ip/BIC-Velocity-Max-Mechan...   \n",
       "23  https://walmart.com/ip/BIC-Velocity-Max-Mechan...   \n",
       "24  https://walmart.com/ip/BIC-Xtra-Comfort-Mechan...   \n",
       "25  https://walmart.com/ip/Ticonderoga-Soft-Pencil...   \n",
       "26  https://walmart.com/ip/Prismacolor-Col-Erase-P...   \n",
       "27  https://walmart.com/ip/Paper-Mate-Clearpoint-M...   \n",
       "28  https://walmart.com/ip/Paper-Mate-PAP1738795-C...   \n",
       "29  https://walmart.com/ip/2-USA-Gold-24-Count-Woo...   \n",
       "30  https://walmart.com/ip/Prismacolor-SAN14420-Eb...   \n",
       "31  https://walmart.com/ip/Paper-Mate-Write-Bros-M...   \n",
       "32  https://walmart.com/ip/Zebra-Pen-M-301-Stainle...   \n",
       "\n",
       "                                        delivery_info  \n",
       "0                                   Free pickup today  \n",
       "1                                   Free pickup today  \n",
       "2                                                      \n",
       "3                    Free delivery on orders over $35  \n",
       "4                       Sold & shipped by Pharmapacks  \n",
       "5          Sold & shipped by United Art and Education  \n",
       "6                                   Free pickup today  \n",
       "7                        2-day deliveryon orders $35+  \n",
       "8   Free delivery on orders over $35Free pickup today  \n",
       "9   Free delivery on orders over $35Free pickup today  \n",
       "10                      Sold & shipped by Pharmapacks  \n",
       "11                      Sold & shipped by Pharmapacks  \n",
       "12                                  Free pickup today  \n",
       "13  Free delivery on orders over $35Free pickup today  \n",
       "14                      Sold & shipped by Pharmapacks  \n",
       "15                   Free delivery on orders over $35  \n",
       "16                 Sold & shipped by School Specialty  \n",
       "17  Free delivery on orders over $35Free pickup today  \n",
       "18                   Free delivery on orders over $35  \n",
       "19                       2-day deliveryon orders $35+  \n",
       "20                      Sold & shipped by Pharmapacks  \n",
       "21                                  Free pickup today  \n",
       "22           Sold & shipped by The Official BIC Store  \n",
       "23           Sold & shipped by The Official BIC Store  \n",
       "24                      Sold & shipped by Pharmapacks  \n",
       "25                   Free delivery on orders over $35  \n",
       "26                   Free delivery on orders over $35  \n",
       "27                                  Free pickup today  \n",
       "28        Sold & shipped by BestSource OfficeSupplies  \n",
       "29          Sold & shipped by Laser Tek Services Inc.  \n",
       "30                   Free delivery on orders over $35  \n",
       "31             Sold & shipped by The Want Knott Store  \n",
       "32                            Sold & shipped by Taber  "
      ]
     },
     "execution_count": 570,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(b['low_to_high'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_data(query,no_of_pages):\n",
    "    executable_path = {\"executable_path\": \"/usr/local/bin/chromedriver\"}\n",
    "    browser = Browser(\"chrome\", **executable_path, headless=True)\n",
    "    for j in list(range(5)):\n",
    "        for i in list(range(no_of_pages)):\n",
    "            news_url = f\"https://www.amazon.com/s?k={query}&page={i}\"\n",
    "            try:\n",
    "                browser.visit(news_url)\n",
    "                browser.find_by_xpath('//*[@id=\"a-autoid-0\"]').click()\n",
    "                browser.find_by_xpath(f'//*[@id=\"s-result-sort-select_{str(j)}\"]').click()\n",
    "                html = browser.html\n",
    "                soup = bs(html, \"html.parser\")\n",
    "\n",
    "                for d in soup.findAll('div', attrs={'class':'sg-col-4-of-24 sg-col-4-of-12 sg-col-4-of-36 s-result-item s-asin sg-col-4-of-28 sg-col-4-of-16 sg-col sg-col-4-of-20 sg-col-4-of-32'}):\n",
    "                    url = d.find('a', attrs={'class':'a-link-normal a-text-normal'})\n",
    "\n",
    "                    if name is not None and price is not None:\n",
    "                        amazon_dict[list(amazon_dict.keys())[j]][\"products_name\"].append(name.text)\n",
    "                        amazon_dict[list(amazon_dict.keys())[j]][\"prices\"].append(price.text)\n",
    "\n",
    "                        if rating is not None:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"ratings\"].append(rating.text)\n",
    "                        else:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"ratings\"].append(\"Missing\")\n",
    "\n",
    "                        if img is not None:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"products_img\"].append(img[\"src\"])\n",
    "                        else:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"products_img\"].append(\" \")\n",
    "\n",
    "                        if url is not None:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"products_url\"].append(\"https://amazon.com\"+url[\"href\"])\n",
    "                        else:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"products_url\"].append(\" \")\n",
    "\n",
    "                        if prime is not None:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"prime_delivery\"].append(\"Prime Delivery\")\n",
    "                        else:\n",
    "                            amazon_dict[list(amazon_dict.keys())[j]][\"prime_delivery\"].append(\"Not Prime Delivery\")\n",
    "\n",
    "            except Error as e:\n",
    "                print(e)\n",
    "    browser.quit()\n",
    "    return amazon_dict"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.7.3 64-bit ('base': conda)",
   "language": "python",
   "name": "python37364bitbasecondaf7339001cfe34b54ae1ffacfd6447597"
  },
  "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}