Scrap Ebay.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "92f38319",
   "metadata": {},
   "source": [
    "# Scrap ebay.in\n",
    "\n",
    "### Objective: Scrap ebay.com using the link below & generate the following info: ProductName, Price, Shipping_Cost, Image URL, Number of Watchers & Product Condition(Brand New, Opened Box or Pre-Owned)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ef4f4991",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importing the Required Libraries\n",
    "import requests # Sends requests...\n",
    "from bs4 import BeautifulSoup # Used for scraping data out of HTML and XML files\n",
    "import pandas as pd # Used to construct a DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "cdfb5a78",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "# Creating a user agent\n",
    "user_agent ={\"User-Agent\":\"chrome\"} \n",
    "link = \"https://www.ebay.com/sch/i.html?_nkw=table\"\n",
    "page = requests.get(link,headers=user_agent) # Requests module allows you to send HTTP requests using Python.\n",
    "print(page) # Response 200 suggests that we can do web scraping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "f533a771",
   "metadata": {},
   "outputs": [],
   "source": [
    "# We will use Beautiful Soup to Generate the HTML Structure of the Page & is Saved in \"soup\" variable.\n",
    "soup = BeautifulSoup(page.content, features=\"html.parser\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b64ebba9",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Generating a Parent Structure from which the desired items will be scraped. \n",
    "products = soup.find_all(\"li\", class_=\"s-item s-item__pl-on-bottom\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6752a741",
   "metadata": {},
   "source": [
    "**Now, we will extract the following items:-**\n",
    "* ProductName\n",
    "* Price\n",
    "* Link\n",
    "* Image URL\n",
    "* Number of Watchers\n",
    "* Product Condition(Brand New, Opened Box or Pre-Owned)\n",
    "\n",
    "### 1. Product Name\n",
    "\n",
    "This code sets up an empty list called \"product_name\" which will be used to store data. It then loops through each item in the \"products\" list and searches for the product name by looking for a specific HTML tag and class. Once it has found the name, it removes any extra spaces or commas before adding it to the \"product_name\" list. Finally, the code prints the name of each product."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e4bb7cef",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Product Name:Shop on eBay\n",
      "\n",
      "Product Name:Malachite Round Top Coffee Table Top Semi Precious Mosaic Art Inlay Home Decor\n",
      "\n",
      "Product Name:Live edge very old giant size great shape olive Acacia wood slab coffee table\n",
      "\n",
      "Product Name:Foldable Indoor Plastic Round Dining Table Portable Outdoor Picnic Desk w/Handle\n",
      "\n",
      "Product Name:Foldable Adjustable Height TV Tray Home Portable Sofa Bed Side Table Laptop Desk\n",
      "\n",
      "Product Name:End Table Espresso Storage Living Room Half Round Table Moon Drawer Shelf Design\n",
      "\n",
      "Product Name:Industrial Style Porch Table Single Layer Black Oak Triamine Board [105 * 30 * 7\n",
      "\n",
      "Product Name:Industrial Style Porch Table Single Layer Light Walnut Color Triamine Board\n",
      "\n",
      "Product Name:New ListingShellmond Rustic Distressed Metal Accent Cocktail Table with Lift Top 20\" Gray\n",
      "\n",
      "Product Name:Silicone Chair Leg Caps Covers Furniture Table Feet Pads Floor Protectors\n",
      "\n",
      "Product Name:46*46*46cm Single Layer Round HDPE Side Table Black\n",
      "\n",
      "Product Name:Million Dollar Cube Side Table - coffee side table great for home and office\n",
      "\n",
      "Product Name:Million Dollar Cube Side Table - With Free Money Stack\n",
      "\n",
      "Product Name:CRZDEAL TV Tray Table - 22'' TV Dinner Tray 6 Adjustable Height Settings TV-01\n",
      "\n",
      "Product Name:Portable Adjustable Folding Laptop Desk Foldable Study Computer Bed Table Stand\n",
      "\n",
      "Product Name:4X Chair Leg Cap Silicon Rubber Feet Floor Protector Pad Furniture Table Cover\n",
      "\n",
      "Product Name:Sofa Side Table with Storage Shelf Metal Frame for Home Decor Dining Room\n",
      "\n",
      "Product Name:Rolling Computer Desk Laptop PC Coner Table Desktop w/ Rolling Wheel Home Office\n",
      "\n",
      "Product Name:New ListingAlex 2-Pc Set TV Table Natural 19.06 X 14.57 X 25.98\"\n",
      "\n",
      "Product Name:Height Adjustable Notebook Laptop Computer Desk Portable Table Sofa Bed Tray\n",
      "\n",
      "Product Name:New ListingDane 20 Inch Black Frame Side Table / End Table / Easy Assembly Red Mahogany Wo\n",
      "\n",
      "Product Name:Murphy Folding Table Space Saving Wall Mounted Foldable Dining Kitchen Table\n",
      "\n",
      "Product Name:New Listing21 3/4\" Round Solid Oak Pedestal Table For Repair\n",
      "\n",
      "Product Name:New Listingdining table base\n",
      "\n",
      "Product Name:46*46*46cm Single Layer Round HDPE Side Table White\n",
      "\n",
      "Product Name:Round[360-DEGREE SWIVEL]Counter Pub Bar Table Adjustable Height Wooden Tabletop\n",
      "\n",
      "Product Name:herman miller noguchi Coffee Table dowel pin assembly part\n",
      "\n",
      "Product Name:Living Room Best Table For Decor Home Modern Coffee Table Round Nesting Gift\n",
      "\n",
      "Product Name:New ListingAcadian SOLID WOOD 19 Inch Wide Square Transitional Transitional End Side Table\n",
      "\n",
      "Product Name:Table legs a set of 4 various lengths\n",
      "\n",
      "Product Name:Folding Table 4ft Adjustable Height Portable Lightweight Aluminum Camping Table\n",
      "\n",
      "Product Name:10pcs Silicone Chair Leg Caps Covers Furniture Table Feet Pads Floor Protectors\n",
      "\n",
      "Product Name:Mainstays 5pc XL Oversized Tray Table Set Rustic Grey\n",
      "\n",
      "Product Name:3 Tier End Table with WheelsSide Table Nightstand Storage Shelf for BedroomKit\n",
      "\n",
      "Product Name:36*36*47cm Single Layer Square HDPE Side Table White\n",
      "\n",
      "Product Name:New Listing15\" Triangle Shape Wood Stool with Brass Work | Wooden Sitting Table | Handmade\n",
      "\n",
      "Product Name:FCH Retro Color Particleboard Triamine Curved Handle One Drawer Bedside Table\n",
      "\n",
      "Product Name:New ListingOak Wood Octagon Side Living Room End Table Nightstand w/ scratches\n",
      "\n",
      "Product Name:Wooden 2 Tier Coffee Table For Living Room Solid Legs Large Nesting Table\n",
      "\n",
      "Product Name:High Gloss Designer White Black Glass Modern Giovani Coffee Living Side Table\n",
      "\n",
      "Product Name:Wooden Coffee Table With Storage Lift Top Up Drawer Shelf Living Room Furniture\n",
      "\n",
      "Product Name:Nightstand Modern End Table Side Table with 1 Drawer and Storage Shelf White\n",
      "\n",
      "Product Name:New ListingSkyler Solid Mango Wood and Metal 18 Inch Wide Rectangle Inrial C Side Table in\n",
      "\n",
      "Product Name:New ListingSingle Layer Bamboo Side Table 40*37*59.5cm Round White Table Top Natural Wood T\n",
      "\n",
      "Product Name:New Listingwood framed inset glass topped nesting tables - (2) - $175.00\n",
      "\n",
      "Product Name:M6 M8 M10 Adjustable Table Chair Feet Leveling Glide Furniture Legs Pad Mat\n",
      "\n",
      "Product Name:Modern LED Light 2 Drawers Nightstand Storage Shelf Bedside End Table Cabinet wi\n",
      "\n",
      "Product Name:New ListingAnderson Teak Chester 32\" Round Folding Picnic Table\n",
      "\n",
      "Product Name:Home Decor Modern Coffee Table Round Center For Living Room Nesting Table Gift\n",
      "\n",
      "Product Name:45*38*63cm Country Style Three Drawer Night Table Large Size Brown\n",
      "\n",
      "Product Name:6 Foot Heavy Duty Centerfold Folding Table Black Portable Outdoor Picnic Party\n",
      "\n",
      "Product Name:Portable Adjustable Folding Laptop Desk Foldable Study Computer Bed Table Stand\n",
      "\n",
      "Product Name:Round Adirondack Side End Table Outdoor Small Coffee Table for Patio Garden Blue\n",
      "\n",
      "Product Name:New ListingRemovable E1 15MM Chipboard & Steel Side Table Wood Color S\n",
      "\n",
      "Product Name:32X20X20\" Prayer Bench Padded kneeler Easy Fold-away Prayer Table Chair\n",
      "\n",
      "Product Name:10X Rubber Feet Protector Furniture Chair Table Leg Pads Floor Protector Black\n",
      "\n",
      "Product Name:12Pcs 10-25mm Rubber Furniture Leg Table Chair Foot Tips Cap Cover Pad Protector\n",
      "\n",
      "Product Name:Round Chair Leg Cap Rubber Feet Protector Pads Furniture Table Covers Bottom\n",
      "\n",
      "Product Name:12Pc Table Chair Feet Rubber Leg Tips Caps Floor Protectors for Indoor/Outdoor\n",
      "\n",
      "Product Name:HXL Folding Utility Table 6ft Fold-in-Half Portable Plastic Picnic Party Dining\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Creating list where the data will be stored...\n",
    "product_name = [] \n",
    "\n",
    "for prod in products:\n",
    "    # Finding Product Name & saving it in var 'name'\n",
    "    name = prod.find(\"div\", class_=\"s-item__title\").find(\"span\").text.strip().replace(\",\", \"\")\n",
    "    \n",
    "    # Appending the Product Name in 'product_name' list.\n",
    "    product_name.append(name)\n",
    "    \n",
    "    # Print the Product Names...\n",
    "    print(f\"Product Name:{name}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a62042ee",
   "metadata": {},
   "source": [
    "### 2. Product Condition\n",
    "\n",
    "This code creates a list called \"prod_condition\" to store product condition data. It loops through each product in the \"products\" list and extracts its condition status by searching for a specific HTML tag and class. The condition status is then stripped of any unnecessary spaces and added to the \"prod_condition\" list. Lastly, it prints the condition status of each product, which can be \"Brand New\", \"Opened Box\", \"Pre-Owned\", or other similar terms."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6047d67b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Pre-Owned\n",
      "\n",
      "Product_Condition:Pre-Owned\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Pre-Owned\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Pre-Owned\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Pre-Owned\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Pre-Owned\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n",
      "Product_Condition:Brand New\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Product Condition(Brand New, Opened Box or Pre-Owned)\n",
    "prod_condition=[]\n",
    "\n",
    "for prod in products:\n",
    "    status = prod.find(\"div\", class_=\"s-item__subtitle\").find_next(\"span\", class_=\"SECONDARY_INFO\").text.strip()\n",
    "    \n",
    "    # Appending the Product Condition Status in the 'prod_condition' list\n",
    "    prod_condition.append(status)\n",
    "    \n",
    "    # Print the Product Condition Status...\n",
    "    print(f\"Product_Condition:{status}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9b78fad4",
   "metadata": {},
   "source": [
    "### 3. Price\n",
    "\n",
    "This code finds the price of each product by searching for a specific HTML tag and class name called \"s-item__price\". It then stores the price value in a list called \"price\" & prints the output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "b0e09f3b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Price:$20.00\n",
      "\n",
      "Price:$333.00 to $2,300.40\n",
      "\n",
      "Price:$704.96 to $6,471.47\n",
      "\n",
      "Price:$105.99 to $199.99\n",
      "\n",
      "Price:$38.99\n",
      "\n",
      "Price:$55.15\n",
      "\n",
      "Price:$55.87\n",
      "\n",
      "Price:$55.63\n",
      "\n",
      "Price:$189.19\n",
      "\n",
      "Price:$2.41 to $12.20\n",
      "\n",
      "Price:$54.69\n",
      "\n",
      "Price:$260.00\n",
      "\n",
      "Price:$284.00\n",
      "\n",
      "Price:$29.95\n",
      "\n",
      "Price:$19.99\n",
      "\n",
      "Price:$3.13 to $4.67\n",
      "\n",
      "Price:$40.99 to $47.22\n",
      "\n",
      "Price:$38.69\n",
      "\n",
      "Price:$49.27\n",
      "\n",
      "Price:$38.99 to $39.99\n",
      "\n",
      "Price:$38.47\n",
      "\n",
      "Price:$319.95\n",
      "\n",
      "Price:$75.00\n",
      "\n",
      "Price:$500.00\n",
      "\n",
      "Price:$55.32\n",
      "\n",
      "Price:$59.99\n",
      "\n",
      "Price:$89.00\n",
      "\n",
      "Price:$59.80\n",
      "\n",
      "Price:$103.14\n",
      "\n",
      "Price:$24.99\n",
      "\n",
      "Price:$39.99\n",
      "\n",
      "Price:$3.03 to $13.28\n",
      "\n",
      "Price:$48.99\n",
      "\n",
      "Price:$54.69\n",
      "\n",
      "Price:$54.63\n",
      "\n",
      "Price:$79.00\n",
      "\n",
      "Price:$55.85\n",
      "\n",
      "Price:$0.33\n",
      "\n",
      "Price:$59.80\n",
      "\n",
      "Price:$247.61\n",
      "\n",
      "Price:$74.22 to $81.65\n",
      "\n",
      "Price:$55.36\n",
      "\n",
      "Price:$129.81\n",
      "\n",
      "Price:$55.63\n",
      "\n",
      "Price:$175.00\n",
      "\n",
      "Price:$1.65 to $53.05\n",
      "\n",
      "Price:$55.98\n",
      "\n",
      "Price:$75.00\n",
      "\n",
      "Price:$57.61\n",
      "\n",
      "Price:$54.20\n",
      "\n",
      "Price:$15.00\n",
      "\n",
      "Price:$23.18\n",
      "\n",
      "Price:$47.49\n",
      "\n",
      "Price:$55.12\n",
      "\n",
      "Price:$107.27\n",
      "\n",
      "Price:$2.07 to $5.22\n",
      "\n",
      "Price:$9.72\n",
      "\n",
      "Price:$1.39 to $49.85\n",
      "\n",
      "Price:$5.44 to $10.61\n",
      "\n",
      "Price:$49.98\n",
      "\n"
     ]
    }
   ],
   "source": [
    "price = []\n",
    "\n",
    "for prod in products:\n",
    "    amt = prod.find(\"span\", class_=\"s-item__price\").text.strip()\n",
    "    \n",
    "    # Appending it in the 'price' list\n",
    "    price.append(amt)\n",
    "    \n",
    "    # Print the Price..\n",
    "    print(f\"Price:{amt}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3dbeae58",
   "metadata": {},
   "source": [
    "### 4. No of Watchers\n",
    "\n",
    "* This code creates an empty list called \"no_watchers\" to store data. It loops through each product in the \"products\" list and tries to find the number of watchers by looking for a specific HTML tag and class. \n",
    "\n",
    "* If the watcher count is not available, it sets the value as \"Not Available\". Then it adds the watcher count to the \"no_watchers\" list & generates the Output."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "600eb080",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: 49 watchers\n",
      "\n",
      "Watcher Count: 36 watchers\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: 6+ watchers\n",
      "\n",
      "Watcher Count: 6 watchers\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: 18 watchers\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: 1 watchers\n",
      "\n",
      "Watcher Count: 28 watchers\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: 58+ watchers\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: 2 watchers\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: Not Available\n",
      "\n",
      "Watcher Count: 3 watchers\n",
      "\n"
     ]
    }
   ],
   "source": [
    "no_watchers = []\n",
    "\n",
    "for prod in products:\n",
    "    watchers = prod.find(\"span\", class_=\"s-item__dynamic s-item__watchCountTotal\")\n",
    "    \n",
    "    # Since watcher count is not available and hence saving it in watch_tags where it is NA\n",
    "    watch_tags = (watchers.text.strip() if watchers else \"Not Available\")\n",
    "    \n",
    "    # Append the watch_tags in 'no_watchers' list\n",
    "    no_watchers.append(watch_tags)\n",
    "    \n",
    "    # Print the Watch tags...\n",
    "    print(f\"Watcher Count: {watch_tags}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a1dbfa5c",
   "metadata": {},
   "source": [
    "### 5. Image Links  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "e075086d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Image Source:https://ir.ebaystatic.com/rs/v/fxxj3ttftm5ltcqnto1o4baovyl.png\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/NPcAAOSwHbZjfKCh/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/IroAAOSwhw9gzwqd/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/0usAAOSwePxjWJh5/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/9eEAAOSw8whjLUuH/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/ZUEAAOSwZrtarDcb/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/IiAAAOSwl01kHXRb/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/NaoAAOSw2EtkHWqG/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/6BsAAOSwBzFkJxgx/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/KlcAAOSwawxhytd~/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/87YAAOSwB2NkFXZH/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/hJMAAOSwpfxfmbMW/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/a5kAAOSwi~dfhpR6/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/rnQAAOSwfOdivL4B/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/QeQAAOSwYoFfikl0/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/C90AAOSwHc1iU86L/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/ycoAAOSwZPRje3QK/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/buMAAOSwpdpkEDUf/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/8mQAAOSwJFJkJxgp/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/a34AAOSwSyBfikS8/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/REYAAOSwtgFkJxhA/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/PCwAAOSw6YxjV7DY/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/COcAAOSwkOhkJuV~/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/2LQAAOSwFJNkJvuN/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/l2MAAOSwkOhkHWsJ/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/O-wAAOSwY1xjv24b/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/Bj0AAOSw-Jdj~NlV/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/1o0AAOSwagtkJX-f/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/sZEAAOSwlBJkJxgq/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/v3gAAOSwLDRiJB3r/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/YZ0AAOSwCstkEUp4/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/XMsAAOSw0iFjosYo/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/72MAAOSw0RVkAipc/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/KzsAAOSwSlpkHWbz/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/oBgAAOSwXkZkHYHa/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/iscAAOSwMeZkJqLp/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/~XQAAOSw-zVkHW3Z/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/YLMAAOSwnbhkJwDN/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/5HQAAOSwtyBkJX51/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/eNsAAOSwEHNfCIqG/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/4iIAAOSwRJNjj18G/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/IusAAOSw6DFkFXV-/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/DW0AAOSw97hkJxgn/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/alYAAOSw3PtkJnsu/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/eTgAAOSwxN5kJkKB/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/K90AAOSwGYtjaL9s/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/Z7kAAOSwlxFkHXBD/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/qA4AAOSwG6BkJxKh/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/29QAAOSwPgZkJYDm/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/RH4AAOSwBLdkHW22/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/6QAAAOSw-c5jxcfC/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/stEAAOSwxhxfigci/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/jw0AAOSwhWdj7yXJ/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/DYcAAOSwvIJkJnT5/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/4FUAAOSwtwph676~/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/2CEAAOSwKHNi9f63/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/g9kAAOSwYyhfkVms/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/4GAAAOSwc8xjF~ek/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/SU8AAOSw3ZJhd6yS/s-l225.jpg\n",
      "\n",
      "Image Source:https://i.ebayimg.com/thumbs/images/g/kN8AAOSwPqtkHT4e/s-l225.jpg\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Generating Image Links\n",
    "img_url=[]\n",
    "\n",
    "root = \"https://www.ebay.com\"\n",
    "for prod in products:\n",
    "    #Image Links\n",
    "    img_src=prod.find(\"div\", class_=\"s-item__image-wrapper image-treatment\").find(\"img\").get(\"src\")\n",
    "    # Append the Image Links in the 'image_url' list\n",
    "    img_url.append(img_src)\n",
    "    # Print the Image Source\n",
    "    print(f\"Image Source:{img_src}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f86fc54c",
   "metadata": {},
   "source": [
    "### 6. Webpage Links\n",
    "\n",
    "Generating web page links and storing it in 'links' list which will be used in Question 2."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "df189e7f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Link:https://ebay.com/itm/123456?hash=item28caef0a3a:g:E3kAAOSwlGJiMikD&amdata=enc%3AAQAHAAAAsJoWXGf0hxNZspTmhb8%2FTJCCurAWCHuXJ2Xi3S9cwXL6BX04zSEiVaDMCvsUbApftgXEAHGJU1ZGugZO%2FnW1U7Gb6vgoL%2BmXlqCbLkwoZfF3AUAK8YvJ5B4%2BnhFA7ID4dxpYs4jjExEnN5SR2g1mQe7QtLkmGt%2FZ%2FbH2W62cXPuKbf550ExbnBPO2QJyZTXYCuw5KVkMdFMDuoB4p3FwJKcSPzez5kyQyVjyiIq6PB2q%7Ctkp%3ABlBMULq7kqyXYA\n",
      "\n",
      "Link:https://www.ebay.com/itm/125624687528?hash=item1d3fd09ba8:g:NPcAAOSwHbZjfKCh&amdata=enc%3AAQAHAAAA4CSWdvDQNNrPCXslFkR%2F2olgcqWz3VDg46IbUuJmGoSdTiOz%2FNQje0nkplS6a4O6W005ZB1%2BJZYKMkkhy5Fs5QDGTHHo2truDwy3SAvdaxJAUF%2FOzzQQJaTwjJ%2FNDQWRcHpzewcJP3RNAxJ4rHGsuGvbZ7ZtZW8VHVdARMiExPjmPwRz9FAuve2nHbiRMH0PlmQbfGgK48AmC4Glv5%2BI%2FsR9%2BDNfaTAi9NEEf0Z7gPxFrCJ51vQq95Pa9Upi9ap0IwIqvvqETdqXUwaKUglQ1G5l4EYjVsJJZ6ammv7uZ%2FPK%7Ctkp%3ABFBMgO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/114858552175?hash=item1abe1a6b6f:g:IroAAOSwhw9gzwqd&amdata=enc%3AAQAHAAAA4Ph8L%2F35sYUBwl2c06VCDomTwuJO7TMee3T2YvtwjFnEWCpj9Lye1RuxZo0LYJ1pR%2BVqilcmutHrnyaoWnuDvPN8cuYeaIWsiBcL6UOeS%2FcP9e8jPNccg8wHxEgkzcaOzM%2FJ3WJxUSd7ZS66jJazfueVwJDezlv8SZa5juUUOiXdnvFI8ko9g7OiZY%2FS5p9P8qbhvGKqTvRbwHCKWdbG%2F2oCu2Df0On%2BM9A50i07PZYySCeORcNJRJPKBTkLRnIGbqHSYuj8xogkT%2F8FvzhfmcoqbOIMkcWJiRM%2F%2Bss1%2FtfH%7Ctkp%3ABFBMgO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/134177164095?hash=item1f3d950b3f:g:0usAAOSwePxjWJh5&amdata=enc%3AAQAHAAAA0E%2FxDfI64chYn82kI3YMjU1srWHGH5HCRwEeeQJuNUR6d3ZV5irNaBgmOyL2vTcHoc5a6q4IeHzp%2BXgTXn%2BL0iu6vTuaEFDxTAY%2BCgJQNkpmy%2BhPVt7dU4NcJHlp6%2Fzacini1SIBOllCqASturcu3FkTNHhQsJfP2lOX1p3fP7xZ0SgSddx6t8Oal2y74fsGvXSta7IvDk9%2FyEY9tjD5xgM%2BuovhvMNtsAZXI3fMPkZfpA6vEecq2pLDOjcphR1wUUo%2FBoucsIpP2tnHBpjRtT8%3D%7Ctkp%3ABFBMgO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/134246341723?hash=item1f41b49c5b:g:9eEAAOSw8whjLUuH&amdata=enc%3AAQAHAAAA0Mln6C3%2Fu%2BPkNNmdkTPPV%2BCB1nE0%2BgclAgf9jNObAivcog1Mi%2FaB2gMQpZmWbmpPDjk3RJN36Eq%2FWD0AdKOCCICu0ThRtFWWB4fvyDVz%2FC2Yv1na4DLwUB81YRhTZHsYJBgzSWPpakMpIKQ7t36tcfaGU1T5nRBJX45BOtaa2cuKX2QLzsICFc%2BtZeJSAoyP6wIVkVL131bjbRv8Nk148iwj3EW7i8hApQ9MAE%2Bow4zA2AeBWuBUFEfDZusLMTMdDoxM7BiTHnYckxUQU09A1V8%3D%7Ctkp%3ABFBMgO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/253496191779?hash=item3b058ceb23:g:ZUEAAOSwZrtarDcb&amdata=enc%3AAQAHAAAAwC8t3sbCOlqjy2XOMGGqBBaMpJX8KY4YDGtg2wVEgYmx0KXJcDZLakG0vFt5zn%2BlyVvbahlR3vATEJtxg1AY7EuBHzCMemkG1Fs6kTZS6LPrcuu3K1O7kKD%2FJ7HKAAhwNbpaUZ7kzZWU%2BTMCqJRKOCthd45axS2%2B9pm7FxTfA4MoFGKDNQc6MwyzFXp%2B5GM8mSZeRxuwAa6T%2BzJb18vtbYurjNBgGcfKut9OuCaQNm2HZlVDEaML%2BhGs6U%2ByAhIHXw%3D%3D%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/295583123463?hash=item44d2208807:g:IiAAAOSwl01kHXRb&amdata=enc%3AAQAHAAAAwMx5k31VU6g92hNbhM0yVYMYXbSxpb8ZiNJa6mqlsiN9WxESDFjtfM1qjMPF6pAjXWiwqS%2BHJ10SQsGrGAnR8hZlkMOhvdgfqJ%2BJV6SasYSuqTqAD1eqGMIxRZzS4U8E9puc5YrfVf4hjBl5QTj53uUsz%2BvNKeVaz3sKULNjWHWmKNzsrgd25vqhJZOEyOMPiNStbawANFPcQ7ju8BGdCApWrch1yug2eNYyy%2FU%2BpByQiybERC70gLSdPpQwIM07kQ%3D%3D%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/314481011464?hash=item4938876b08:g:NaoAAOSw2EtkHWqG&amdata=enc%3AAQAHAAAAwCS7x%2Bp0FolasEEcNCYDM%2Bahj9vSa96W8iz%2BgRVY2jHIKgWqdn9XEKx45VzPar5NVgT9A2F0Bhw5Hd3z95a9QY%2FAuVj5ZuyCT97f02tiADO3XKs22yYzMw9PACg0k9GSb0nxbpppOda9N7A1QcrZrcmyJhB2T3RJ2PbJkOkHn%2FOQ9HLoQWsxTAM9tN%2FoZHfWQUXrlPyGyYIRmAn7evcXYGm6bCaBMZn48fGdFZzPzIG5u3PpzCF82suSAeBM99lWtg%3D%3D%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/275769401156?hash=item4035231f44:g:6BsAAOSwBzFkJxgx&amdata=enc%3AAQAHAAAAwBswfmOXPFOytiY%2Bc0BOE2QlaUaF%2Fz0IOLkKprGAznOQKuNTXdYERUzt6dM6LqnSjfNRDdNqaVm2SMpDKX5kP3WdqfHWfXJCTh5Nd4bqZ5M%2B0jiCdTERjAwroA%2FHO0vj862lxB4jxLvbnGkjm8DfD563Cp47OLLngXybSoFpodi2un8%2BtAJsEKoJdwllUgyd%2FH2ge0O4LS6c2J4C%2FmWvbqzp0jvgVJdKsSw2IyjjIzDkpLKsqYysSh62ACxZs%2F8KXA%3D%3D%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/265473237961?hash=item3dcf7023c9:g:KlcAAOSwawxhytd~&amdata=enc%3AAQAHAAAA4LVcDB0LNJOWiPhfJ5kmzeoRp2E44NVxuYm9ZK8Woa1VSqd2IZmBsTttB23Fg7R6qUxkhtMNtS9rONFh3kPQ33UBwM8J2Ahhx%2BFiWU9v8ApRCCmu4uuUZlllZ5SCQOmztvZncvn9IVchkqknmuEXQhsspdMqwMZPDxABmCIgvB%2BIusAt49Wys%2Fl9juB9P39qQbQZGSM15%2BVCXQBictAkKWxvi5%2FG%2ByIPUl6Ya3gmCQCf%2BHr5j9PO%2BjoDC9ZY8UJrmjnokMt95nTBqJLB0bI5%2BmQhbXC8f1NnN%2FlBcZTAqxRP%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/175655606617?hash=item28e5e3d959:g:87YAAOSwB2NkFXZH&amdata=enc%3AAQAHAAAAwEaPQm5BG0VXlU4giDrLStOJVoRisn2ZXzDV8%2BQF6HSC1cTqsIQv3%2B11bNsYeFTRzIZ0feFzlOBzNdiUKNRU5oqPnGPg09VPEGP9Ucumlx8K5p8mH5ZeRRvdAEZ6iOTE%2FWaeL1O%2BIGJYRJFTQ6ckJw1O0v7FY5lETLtbOBrheNL7mQey9HI2DyYi4UGE%2FxaZrjuqq7YNLYS6JXzUOEga%2F4YQVBiNUifuCDyVdKNnC%2BnzLDGwDCmTfsBx9Yl4DlMEEg%3D%3D%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/283997113265?hash=item421f8c0bb1:g:hJMAAOSwpfxfmbMW&amdata=enc%3AAQAHAAAA4K5eyrP8IqU1Et0GtYUEqJmppeECshxUaf6ry%2BllOGIUfhq5TDD7iPlRH%2BXZx668FfQA8yT8%2FwNuQKM%2Fr2%2BxsQE9EouRahEqIZuMPnbiJFF2%2BbDFIAAdAu7vAlugumP%2Fit0%2FzWsmeDd3Wo1TNclqJuANXBRLuV11cp4szEuLCzuj%2Fgd26i25PGHYiIj%2FAxliF%2BqbGe6y9BfN696ZQpnxb6qIYM6F12qCXEK1vV9R3mOMLCxET1inxCFzADtebd4KPebT7Zv5tt0AoT1FsEbx80eIb9D%2Budv54vrR57e25TH9%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/284402248308?hash=item4237b1ea74:g:a5kAAOSwi~dfhpR6&amdata=enc%3AAQAHAAAA4MF5TXQ0Mq6o%2FqM8vDpGjiOYrm4TLy3bnT3cfWerHk00OysMcJn2OMPYiFdMfsEVeiCq94nkv%2BQ4I2nMckLsc32JRxDmmOLGfFXnNfWXMg9LbLC8NZNhwx%2FhBWdTHejJknoa%2BIGN9i3P%2B39JmMDF%2B2DNyrWUaTkNV9wBNtxUlCxwHuABgWTZnjYV1JuKoKFLXtR20qEyG683O%2BYaczL41Up%2FcvPJZ7PrcKH4uOZbiAY5zi4cx7Z0u4viEi0KePbSzmvttdciuwZI%2FRDAde5NLEn6%2Fj1FaBR0ntcB3z%2FGOM%2B1%7Ctkp%3ABk9SR4Dt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/195178653961?hash=item2d718de909:g:rnQAAOSwfOdivL4B&amdata=enc%3AAQAHAAAAwBL%2FQvvkRGmzmHuLmovDfnYNpsNezPy4iml%2B1Mh3BBiNC2C6RuxSDpC3zJJ3e8OJOzMPYVHRvZRYNeNQZzH1rssSCOb%2FhzSw6BwdujKpRY1L9FkvB40TL%2BJlOWSJ%2FLQVSu7WLi7kkG9eXjqOyv%2BhkP6FO5tHd2YXzAN3l19likQCV2Bc1o1kX47M%2FQj6LBEguHyDeMxBJVECcNFxMuMYuRRi%2FnGaFkcIFotd9OmJ8%2FrI3q2yZZK45bgYHL1txCY4Ng%3D%3D%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/303730033918?hash=item46b7b884fe:g:QeQAAOSwYoFfikl0&amdata=enc%3AAQAHAAAA0ItHnV8JU9eBK9Mgo57vytGXR8y35TD%2FtUSY5IEX5dhnD%2FB%2Bq42dR9g1dw8YsrKpvr4E7Sk0YFMCP%2F85k12rMTFl3Mq%2B6dX7T1nC6uUq6eB%2BBrf57n2N46%2B06rdyQ77Zf8hJ0ob1DUoho%2Bpxbk1fL6qyIZPTjk61evCNkbQwNOiJVyUxiikuhD%2BT794X01pOCm%2BUPelMMro1zirJe3UpnnGwKZFAMV3CgaTRL37zzVgP7ZZv19bt6fESBPWRVYzEN9onC9ACEXquFvbsiWf9G8g%3D%7Ctkp%3ABFBMgu33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/403595806095?hash=item5df82f458f:g:C90AAOSwHc1iU86L&amdata=enc%3AAQAHAAAA4Je2xu4KK%2BjagaVqgMafDV646wtyocJyzbUfial7%2FMgLATCgJPmVLvXzV9OEgeNGwTO9Jl1z%2BAIn2t1ENktYGfFhXe47KyQj5SLzH3I5uYiJDWyJPXturN8OYSdHr1TGsZbaAeTwFFU6gbQe4Fdzhn4I4qvMNYrO5d1ryiyyUZo8IusMoM1zCn8iYuDTlsxDxIwQkes%2Fb8ZOuDD0ndG2gbVhDDY4R2jz0vsDrDLfPFEXDaD8Oy2wxA1kJ9fh%2FICBJlr36X31cVIY2Qg0znqaccprKUK%2BLfGELSi7jPEll9uT%7Ctkp%3ABFBMgu33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/304710855999?hash=item46f22ead3f:g:ycoAAOSwZPRje3QK&amdata=enc%3AAQAHAAAA0L1nActsA2mvAfKuXZ3a6aUULK9F5gKRX3h4ZC4yG%2BFxHW95F1pfYNeXP3ffjF77wxigrWcx60uM%2BITPtLsGKqo7bE%2FG9rMDYVvWWsYnDaDjeOag33ToZT49D3hem%2FIx0rDwrV%2FzlU1sGn1TyHQYA9cQ9C6%2FXGTcy1IG%2BTr3I6yT22a0iAIWxIwXV3oFYgUrBE7mOUmYuubNBBBfERp3dcNzlJD42PDU5XqBuP9i6hY9YXATuCqmEnSWo4EOhWDQBqVOz9%2FpT6mB0CCfip6m2ZM%3D%7Ctkp%3ABFBMgu33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/404202395176?hash=item5e1c571628:g:buMAAOSwpdpkEDUf&amdata=enc%3AAQAHAAAA4FaJD%2FuitjH8nY57T28scC%2BWO5d7eHmV58ulGlV1QJ2iwwIzmUVujJZ7ZANmrAzCOmGn93ErXSSAIB2LZ0won0LdQMkILuphT89Z5XWvEZU%2BT2e8EYOfJrEddT7qRkcrsnpqjAGfv0hOw1EWv%2BLgFxT8Z%2B%2Bu3JPebbQBhYY4whGLtbg67hqGFVCH%2Fo%2BTUeNoG19wK%2FtQ7j1VkHHjfQ88KvPlrljMA9u6r5Amg2OGGFmE8f%2FX%2Bg854Qe9cIrNJ5%2FAEX8fMsGsoo7GxL4nnyEmLWQS44HHKOhz9U9aVyZrcxNB%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/285213074253?hash=item426806234d:g:8mQAAOSwJFJkJxgp&amdata=enc%3AAQAHAAAAwHS4HjSm7afd3yTUWUqfZ9Ba3frDdQjgYuej8DYCvjJJU%2BpUbDhjqhF8GxpiQzurVG%2BAE1ID2e2LrKa6MXcEiKLH57q3lsyvgvhytNT1HSy%2BK8NUwnAcfMlZlognAKY6w%2FG82jATFloFsA%2BWE6GIQbgRVU3GTHmL2uYgVLROI%2BRx%2Fq86P8HWONUrLi3X%2FGZ83eljVTHnGHwnxIfFvyEGpjttgvMxBhCiCRzS%2BVwDRkvWbu%2FxiqCyIu6dGEHXp9BBUw%3D%3D%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/303729898354?hash=item46b7b67372:g:a34AAOSwSyBfikS8&amdata=enc%3AAQAHAAAA4ILskHuHwON5%2BAu2nqMwIJEYhLAEiE6%2FFNK5IHG2v%2FHKAo4wvuIxUAKUHX1DOhJaYKv99vqRJHrbwsnhXVxbDC2ML4ahGqz5jCIRJx8ypSuo6WaJfSRUAv2EP1rcGsR1JfrefZ5TK3KRa1tS2Yugpw9R1yQHH5cAvPlSm2%2FTxiIovqoer80%2FGVRZlaWE2dT%2Bdvv9E0fxfAQ4O8gNl%2F8mXT5MDyspJOSiT4qtK7HxRzEGmDGZWEnfhStTF2LMkmmX%2FFy8h08s6AqjEw8iHpxA9LWbGrtDkjLa9asuuUEXFxPS%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/285213074755?hash=item4268062543:g:REYAAOSwtgFkJxhA&amdata=enc%3AAQAHAAAA4MhtYOf3ZrbapiX7OkrNxsojUsnFb0QuOn3ZwgOtLEWxJOkDed%2FrVTSYwe7PxLp78idZTO11MlOg%2Bzzg5sWoLCyn1huu6fa700aTFRB1be4M1KqnWJaeFFFA6BpyIaQqwbO7KGl2yHODEztW00oOheI2KPyuVu9MUwjAxr5xngO1XS3Nc6tdlQfZOXXMZgVE3rDODiNahrWuWFlbnBGYLoNldossAfPAJwhFL%2BIxRhquKrippuJFucPlwGBdcBmV268ewE6aWdQhjxT3TgeG4lfcl%2FY0HpHtkvAK1XY0V97O%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/334580984616?hash=item4de694ab28:g:PCwAAOSw6YxjV7DY&amdata=enc%3AAQAHAAAA4Owtkv5uYqc7PRIkAJX4t%2F0FPWn9pBSmcYGHhdNsv21yjoAIxTTFQnBsZ7i6MwlFWlShOjm4qvsw9IiZqPXdJm3ejrqS%2BR8zJxCd39nVOUIl7TP6Gz2DMMgGQDHLf5tjzPP9HVWrCyyjR2N6YL9J3DGyya6nAbjEFwvJmodQmKZ%2BDy%2FXc7c2R6t4%2FutsPYC6093PtHyCoQJviPT1EdoZXPsv9sxIxu%2ByImE8FN%2FPwvimO8mTK%2BAawnoIZPgMaGWEZg4m%2F38JPZ30F2%2B4Qj3vCbWSSiiJ6LMU97vfJn0rdMBy%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/234953392493?hash=item36b450416d:g:COcAAOSwkOhkJuV~&amdata=enc%3AAQAHAAAA0ACl5TPVP6IB5vWg49zAJQCveNRdk41FdtW263Xcrz7wahHic2jvZM0dzULNgcOhHor10U9LrPBErLC1zFyEg%2B3d2ntry%2FCOly7VWUUsKnjvaJLz1Lic5LzAfLni2tihs86cqmlXowDuJfgkTJZMj0JH3B7Kz2K0s4eXxXHjQW3Hq1MHKIherQKE6rqan8hXs%2BZ6pYWmoQJya4N48oNoGMKpSbbn7kVI7RFry107IKlDzZZJH9eGFHAhZpSidAd3Bt7sFkBM2XUSIJ%2Bo%2BnP5wZc%3D%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/354687239103?hash=item529501c3bf:g:2LQAAOSwFJNkJvuN&amdata=enc%3AAQAHAAAAsDc%2FTzDYrEp4Odq5edkjdjyhayHYKK14qSOithroxoVjt6EcM5wAI7pq8AFksxuef6QDMYg72%2BM0CWNhEHX9Z59hOV%2FtFzFCX8sJLfN6m0uPDKTMkqJJJSrVcLWL%2F97RFMuftCz7m0tWcmaNuoXWfra8qwtJ1oh%2F14CRAoyljM8X0EUAHp5oS49Kpz%2BXh4yZJWEScxPi2dm57k7CuaB3%2F%2Fssu6yWxMC38DPRD8t%2B6EsN%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/314481011474?hash=item4938876b12:g:l2MAAOSwkOhkHWsJ&amdata=enc%3AAQAHAAAA4AW2bwYGKKKE523tdmuOF32iz4T0SnpCpROSdyhVz%2BEHZN5dQXcVtO%2FIHFI4hF6bwjG3pVN1Gis6hMHs0Wow4a4zOGi8RSNhLNv2t35GrnPC1pHztQxmsvrsxs9zqwwXETil%2FofL1Mvl1bkSqNfHh7BU7iwtnJMhRJLQf9sJ4E0iQUd2yD9SOEtGlqPQqBYiDWlTW8FB6N59D%2FBTPYZqluxri4zujE%2FCweknccX2um6Nz%2BQcdSv1Mo5luTvIJCcniQaB9kMEk%2FTuFF0lwKjo5afZM8%2B8bThj7INBgOq6IqmP%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/144897000471?hash=item21bc88c417:g:O-wAAOSwY1xjv24b&amdata=enc%3AAQAHAAAA4MYru14mHJ8hS%2BMDJvl%2BxFzeyNn2yo1J9iLyMdmlW%2FYxOqDOcxL8X5E1NsqhjriXk%2BEk%2BpOHFsmizJP%2FC4szvp6yc7wuBKHdNcriB4XAl%2FkOjchtWJR9bzjG6CDgxf9G8rYItdPwJZOothV2JdfIRkelOD9lb5ENMTXIdBk2TtE%2Fiaj162itcXHMN4EuVFXJO01qY0jeX0vHRnfcukkmh7Ge2ByE17rmWjUGJlA8xPwA3raj8rkXUrrFyv2BVKO%2FPbiihriDUmIWSSKd1tbGqi%2BEODCmlqa5wlv7AsLJfr1T%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/266178394032?hash=item3df977f7b0:g:Bj0AAOSw-Jdj~NlV&amdata=enc%3AAQAHAAAA4Df2LrR7SVVCuLz%2FyN66JLNNJNdW56ox9Dxdts70LpX6I%2FBkPtItYHt%2BHIjzuaDXbDsRQ%2BXTgeaw6VXNJDGaut40ESv%2FNr2zEG3fg9QhEALT9QIeq2oCtzB5Nin6nf4zYn0IG8O1QRX9T68tZ2mZSjKkyFZlK%2FkbHImbDZarJnftzublWm1rpoz0%2FoZMaNRPVBsau%2B8zHmnx7JO8NM5uiRv1BZRdw9DMqiF0%2BlByUpbSUD%2F0O%2FDkDTtWW6%2FWFbPa0H10wLxr%2Bze71NctzlhOvRRVoWyRO8cgcSavdOWASnf3%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/364199950938?hash=item54cc023a5a:g:1o0AAOSwagtkJX-f&amdata=enc%3AAQAHAAAA4JR4fOIK0BzrRiovjGiwA6Tt%2FZTUYavwpJN25x1QsVvNS9g%2BdKckB1txcf8qB8t%2F2lvLhiB01ogw152Ydh5cCAtqANSBHoIfvICtiiRVk7ixFuoQMNvzqFYEKDgsDp3rUhfvQ6f4JhHIBMifPHNFoUn9nQM19zHX4B1CLcBcg80TW1chKBC0pLeREouESo%2FGXsPZNRUf2KKXuB1m39RIBDE663QtxfHwVEen49BhV%2BP86W2lqB%2F%2BqoTft8Dzs2PWqX0LqBAO3BxRVwaVNg8x862eec06rTb%2FWauTMVphHuNz%7Ctkp%3ABk9SR4Lt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/275769401127?hash=item4035231f27:g:sZEAAOSwlBJkJxgq&amdata=enc%3AAQAHAAAAwICDv4n%2FKaVHxSTFlOdebFC3ati9EBPt7MO71UGOqzFLcZhtUbU%2F%2BHzhwJEqZueeeb2j4Hrd4LSxQj37SrzyAJycNhkVBSh2sYo59X%2FZApoNs03IjnaTLRWjXEf8GG84ZD84VU7zW12ZvCJLJkLLdSDOwsPRi2CsmMIPWz5Hgd9cw9Q5L31jVXeJpN%2BbnGIq4%2FNxWTrn0XybOYPsLk8J2zDF8MrydXayQogp1hwqs7ctKLCTPbMiFfj0gLUiWpVjMQ%3D%3D%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/325086753195?hash=item4bb0ae31ab:g:v3gAAOSwLDRiJB3r&amdata=enc%3AAQAHAAAA0NEdIOk8QHKUek2U69WyWcwTFXI5ao%2FNVRwZg6mdcCD6vtdUUDQxDymG7hWWIyhcmsBvALasTBg7sDlar9wsY6zc1K3rMSnX%2FYLJKwIlgAk5p751cbeJ5N2gPhCTOb4Dh2s%2BOZmX%2FPV27B2mOlIzNXFGKyGoYqDGb0TcUVW%2BBv2tddf%2FXIXLLzq%2FRn5xoBjIy8uZs2L%2FcaSCjmu2yHq4ZOhkpHX154ys4PwUASgQrR%2F25LBJDmdhpRQqbqag4ZWbM1OLyEHwtK17y8XENnL3vZE%3D%7Ctkp%3ABFBMhO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/374526817006?epid=6052677067&hash=item573389b2ee:g:YZ0AAOSwCstkEUp4&amdata=enc%3AAQAHAAAA0K%2Bqz3feuX4%2FbkMGxOPm9B%2F9eGdMV2xTNZImnzp%2Fo%2FA5m2Y%2FYFWEoF8ojN1T5JatP1JpGEyhlAf8QVxXQlCeXyqglrpOLg29SMHw2qn3tAiU8Ka%2BVMUhERVd8swlUoLnzUlI5ug1JkDz6Pwe%2BaaaeePW5PXTJ34IjUKtdp5uG3J8P0Mw5eETP1EqbQogdCU3Agxmwp3J6ZJamjfd%2FqAphphZaHtyeyRJZnGcPG1%2F6LscSW0JB5ISIFiYPAiJhVBHu1q%2BzJ3s0VPbIdZ6g7TGO2Q%3D%7Ctkp%3ABFBMhO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/304746106601?hash=item46f4488ee9:g:XMsAAOSw0iFjosYo&amdata=enc%3AAQAHAAAA4FMmdVdyL5onoy6lIWWao9%2FBgjoIv8SxdWcqN7Q5yEEXVsX6xZfEK7Q08j003%2F1uG8clHvul%2BN2ticIEW6KUqX%2B9oJB%2BhK2g38XXTVgKR3WZH%2BchpBH%2F4%2B7VVLj5dDDz3RRUUprZq2qBYyxS5X%2B7%2ByGDVsvFvL63HL4mhVcFsCHTVn0UuFNxTE4Lzs30flWxMCLfXWVoIXLlWLSrArPcRINdGoabbtKp%2FV3YUB8Yri7Bhrdr3r3k0wbO9bsArdT0ZmZ5x6IDfjMPJakxvKNRN4fYfeVennAU1w%2BVSZ7ROTOo%7Ctkp%3ABFBMhO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/204263396801?hash=item2f8f0c15c1:g:72MAAOSw0RVkAipc&amdata=enc%3AAQAHAAAA0BkBJcIDq9zoHgEJbNLEWFkf0g9irEBt%2BORoG1hZnvMpvwPaGpgP2RNwnPDEOY%2BWIb1QRxZY%2FIxLdiwW8sVmHGGrFY5jrQ0rCgmr1st7wmYrXnkrLZ3xn3qXFfam0DC4q4HV3H30dSdqQxBHDmmP3xrRaFPVoC3rpfoivHugx3Jo%2Fjb4VIAv6ZfgEhQVXzbIPPghOdecGeC4qOL5Omz9ZX%2BJYdfmOL3iltMy8nMj6qA9ZhX4OLXxR02CW%2FmVV6z1dcQ3%2B38pS%2BkteGU%2BCGLNYCc%3D%7Ctkp%3ABFBMhO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/185826723913?hash=item2b4422c849:g:KzsAAOSwSlpkHWbz&amdata=enc%3AAQAHAAAA4De1V0sdC2k11uMisB8fxd8bqnAGPevuOjTH8XlKXomW260js5FlfmnWR3Y9T9ERywiCR7JmbCnDaNJ4vbyNs1Ivk1oTMGtA2myKYs8t6xpKCWzLJevwDd8uclSXa72BCf1z%2BR2y9rXveb4u3jxUWlo4vJ%2F8m2OeLfX7pTtnBfAzo4%2B5S4p6SVTXesOgABLO6mNiSE4gJlQQoDpldKlis8fg8yjm6pWtCEsqEgi32HkUdt3dK1pWTu7zkZDSt4Bu%2F259giNaY63Bp4ekH8ffCHCNC4R53BHnnBE3DNta9SOu%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/145002110485?hash=item21c2cc9e15:g:oBgAAOSwXkZkHYHa&amdata=enc%3AAQAHAAAAwIeRKkvSMnagpC1CojkzscWaPhF21PgMLjDOQ2Y9p1O0zrwKrAvnH%2BH8FLUqmJU9gJvG%2FPmefFWD1xzMcHZiwjvzm%2FRDYR74xVLO9fdGjZB1sm9m0qzepI6TG1eZKfHMtGoMmX0eBKvd7iYGQbMLBAR1c4kDWbCF3%2BxiZrMqSd9bcnHrylfuIb%2FohMO0A3d8npeBd7LdEuT2fmrU2cD1wN0QT9lAjFMuzoGtmVwdhNsKm%2BRYCzLH7D5lTdks%2BonKfQ%3D%3D%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/314493577197?hash=item49394727ed:g:iscAAOSwMeZkJqLp&amdata=enc%3AAQAHAAAA4BbL3cyBVfQ5qx1p99Bz4x5VAT%2BL03R5X3nD0A0Vu7vXXZJiu6T0HDyZrpZkvphIxMUeVxTiVJQabIsszuZDR66yRdRa0W%2FEE0D%2BuUog%2BmnMjrrj52KBwwljjf2Q34F57YXvF7G4XbwGQRuEtX48w0GkVAh0ZF8IOQgcClGlPkBvUw9eaE8JjYDK2B5nnBLlGR4IosDrN7og6lqUQy%2FfTVAtMfzHuTAoSla3iQM9eDTI2Bj469kIrPHwenljoOlSNPztaYMf4HmXZbBRRXFljLxOOpj%2BUjDRgfjmjaVzrd9K%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/195676444385?hash=item2d8f3996e1:g:~XQAAOSw-zVkHW3Z&amdata=enc%3AAQAHAAAAwLWQVzgA7b1eQnI45r7lvMn3Gi0qaLpVWzYaoCFwvZhPft%2FbEDK1Vmme0MLqFxhzYQNVuYELLhCmipUmvT1VRg8Ko7JllFdddJ4EZ%2B65wUiHGsYibzBXFaiWZyCS%2BR9qt0gQ0eIWB0rjlHOKVm6jKKdr%2FIBXJuW1fLdkWI2hHmp%2BPMlNP3q5GGsa50pf%2B1Cm1t1%2BmDoWTRdNHkMKi%2B3RNBX33EV1B4CG2GL3TUPtpMFdKU3bsp8itg09Mo0opK4WFw%3D%3D%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/295597722039?hash=item44d2ff49b7:g:YLMAAOSwnbhkJwDN&amdata=enc%3AAQAHAAAA0JEhWB7gv2UQU20QiBpGp7%2BPVU1UaHwOD11bHYV7k1W7XJmaKt4Dk89IfSqVSzIEvM11mkSLgcwOHzibjbZd3BvI1c2UoATJ4kV13P%2FwaLvtlOP33i5%2FZuzBXO901p0zOCjUxdor2QIWVPYfdX9qGaEvQ%2BJY5FOyq76geVAyZog7a5VYf0f31HVJnNmMglOr8m978ADzro9OufpaEtFhozeW2h5KimWQENQ55kTe0yr4jch8Cx2%2FPdY2hnJVL02Y7UIYTYhxMWBiOmxq%2BMetZA8%3D%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/364199946310?hash=item54cc022846:g:5HQAAOSwtyBkJX51&amdata=enc%3AAQAHAAAA4PBIdILVo7MOKtz9uaRkAx0I1tHPZsMmZF50zWVFbw%2FUwmjLe8i6FINxbv98JjlH64AAXiNQR49n9MBGHAjkJkDNyQ9hZDgjFQK55YMKgAcbrAXY%2FVFBYrfHpI0wSecJDjiD9hHGL%2BnSmuX9jVdjvVWCI4R0Rd92gpkjiCLAQOClKhDHY7CXDfIEB5Y8mPdnitpg0vprKO8OFdoPjtoi9Iqu4c%2BJ31hb6ZZbPO%2FZzDQnHymGnN247IHaElSYbymk7V0Kl99wQ9As8zECjimvLSfGGSfbh3pS8W7r41XZC9xg%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/224074916316?hash=item342be7e1dc:g:eNsAAOSwEHNfCIqG&amdata=enc%3AAQAHAAAA4KbXvF6a3c%2BSALe955QCk%2BUzHBS0jkXxaBxzccZ2JPTPITGhyXyKwv9M9zAcmw2cs6Hm%2FlUWVybsoKRpqzfx7MOqUQOc4xkyNYag5JYAjZdzKBdiVaSjJleh1KGlDBV8NRWi6Y%2FBbvmkHbeDOMGwuRkvtSB0B6%2F2OfU71EQGMHhMh5u5CHsUP0TkEdrTbCtzg8IHD%2FKCboNwKWyqaXbPOtRlSKhKiNCOGfbut4mqyAHWlTWpboHeVOhPg9WMLZT%2Fd0Xt0mcbnaIuttuy3pfUig%2FovE4ECJvq1rWUFPUY9qDs%7Ctkp%3ABFBMhO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/265563335373?hash=item3dd4ceeacd:g:4iIAAOSwRJNjj18G&amdata=enc%3AAQAHAAAA4FObUefXtMBuICS7ZqqmfqKpn02goaclkgY215X%2FbdVIxEgcKfIr%2ByD7EShC57fuMvyxqTJjoE578fR2zb9lG09KZxM%2FGQCEw%2BLdbTondMT7QeDG2xOpA5Ce2DEfILX8k0zM0DCyLtTetAgb66Tx5wM3tAIenuq%2BZ%2FQvgEbPIXG2GCa%2BZJfxOPB0eWKZRrB3nw6gkq%2FXZpZydYhgvzeOvkkZ4s1BlCtGoVpxEEYbC31REEOyqXV3nR4HPSuSWV5C%2FN%2Bqflkp4llxwzznxynHQJ9qFqFtdqyq2jvoJV%2FhjLr%2B%7Ctkp%3ABFBMhO33i-dh\n",
      "\n",
      "Link:https://www.ebay.com/itm/175655601762?hash=item28e5e3c662:g:IusAAOSw6DFkFXV-&amdata=enc%3AAQAHAAAA4CgGh2zNRFbJ25Wg0fW26LB0ysuI10t72boGZQNem3M%2BSqagbzAzKqTh45v5C222NLzV%2BPkKLqCPFxIDg2MdJaiV9J0VrzwPaLlFH8QqKKHUfiMFpvzajvsM1P%2BE89IPbEfXIfNlINuJKvdyt3OCEOpqcxv8eEFHixk0fpwIN32joqFiusNghLKbYPPaYJJblQFUbnR%2FOtXmOJ4nGUUr4pGYaw3XnvK%2FdNz7A5iXYZuhtdAnTviEOOYGSRO4A20P8iSVr39yDb38Rk6XsUUh5%2BcsmqR1xJe3rIp%2FBPTj9JZB%7Ctkp%3ABk9SR4Tt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/285213074185?hash=item4268062309:g:DW0AAOSw97hkJxgn&amdata=enc%3AAQAHAAAAwFBgR%2B1Bvfm7OmETfPNyAFOA9Sh35t7klnW8Qzlx5TItlw7S4wANJ565kJMQbpNWVq6FHeoBP3%2Bo8Kkxl2OiXzKFFjkDBPIIs6wNVZZa0jCTc7neF4yy344vyn3lMbCBcCQZTYojGdf%2Bii6ld6gnPFZkJc0xhhsfaNzhfFKvy6TgRNKnfg%2FGQTLW2Vq0xhDMcPzefAMJXToAztGOLVxqMCfAEDLpP0H3soLojoU4xwZFLgiWq2eCDQb0YHC6G%2BoR6A%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/175671000049?hash=item28e6cebbf1:g:alYAAOSw3PtkJnsu&amdata=enc%3AAQAHAAAA4PKy9EyVbWROuFV88jsNbqapn9zTYqLcifkSiivtX52ub6XcJ%2BCm8MKJa0A%2FjeTRGWsPCIoWpuASYzGk8GbTWlAMOpQQgQb5IGRdNqDzvuoGXgAraHra6G4RC5f21v23gypbDRZUU69kh5%2FpHoCzMT2HsamACcq4RIPWyC7vF%2Bji02aNopWYvduKqzbyuzTMpBbtyzs5H8R1JKoTGfxMz6se3E8pHIObMVijM2zwDwsqnbh8caTuvfmNuRSJAoj5rl8c7wP%2BVPwxvvrdAcCRrTOGtAzyFSnoPodh%2FKSTzubG%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/125856317791?hash=item1d4d9f015f:g:eTgAAOSwxN5kJkKB&amdata=enc%3AAQAHAAAA4G4gYe9geTyamXLytec%2BhwZXi%2F4mmFM0Czibg51igRVK5loWwSUt8oaACC4f%2BBD%2FBmrkZolfWh0P8Ju8mv0kJJcJNAjvzwGtdQ3ERrrMHaggxwyhI%2FAtuwRo6EaCY3py00dcmKC6Vlsx5wTIH4%2FqiwrJDk1VTdOP%2BjgVzrpCv256l8EjJ0GPnHvjJlhOM6%2BixTz2qz6Ry4Qj2xEJKy7PZgprzxKzabPpDUFUUHudtNeVq59Moe7Wy5b03wjFD3PUXkF24tSAFOmCCSIcTmjoFk%2BJrlEzVVjSXQo2MVeUwT%2Ba%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/195458853245?hash=item2d8241697d:g:K90AAOSwGYtjaL9s&amdata=enc%3AAQAHAAAAwAug%2FNs3gND80v19jpmokM9ExXo962XzLA5VX5awmZF%2Bn1XjzHr9HZDiGJLV3ZiyidVCUhDI%2F3CVx2Jf0u8l8Wt5IuJdPn%2BVx7Xwn0MhFOytiGXus%2BSC3kRpwmeLTVytL7F%2B%2FuIJWBRdWNd6hxx%2BmXeUEtVWL%2F9utcsB1jJQo5pir0xnQYNmb3pEMhyy3vCYvMhHP3IdR7L06qF%2FiI1RLDGaDIo64ughOWi59cNk6A6xfNPazDcUMdg6vzp2tw%2Bpmg%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/374582250381?hash=item5736d78b8d:g:Z7kAAOSwlxFkHXBD&amdata=enc%3AAQAHAAAAwFBT6WgstRm93ki1a%2FrwxJmoFHHfUe254Y9V7rA92yjCFe%2FiRPkAQzcSFBCfrvuHkxeH2lFZGbPb46mmRYgLu6glRLBWCxiZ2NZLNd5Cqj4xk1glIhVCDO6ob9w5O%2BNW1uwcX51Hsv5o1%2Bw8atr6x%2FIsV9dufv6Kq3H5UkoikNvCrbN89hH%2BJdD7Dj7IH2flU68I3MvqIALHPoTX3Sbi1dWjtlvPlMr8N6ag8aoBSjxwDnLfNQwn7qJpaB9GL17EfQ%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/166008916806?epid=1929387822&hash=item26a6e70b46:g:qA4AAOSwG6BkJxKh&amdata=enc%3AAQAHAAAAsD9cfSRPqAasDRQXigvzEjD%2BvfunXCJl7AYejcZ9%2BDg393YNpH2E39SK%2BD%2B8TgOij3HpbXBtkTmq9hSsYe3oOddFcXOBqpNZEJwzLj57IXXDj8DApkiKKR6YKeIw54f6OpQo2Iwjq7SmRAvpJZMnRsMxwSn%2BS9xeRxYJmDc7L9QhYV2vONT1CPfuet1ZSDia55GPNjRZly7z13KBgQ%2B6GiY8jbFB5JgCRJ3v%2B%2Fr1rofB%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/364199956208?hash=item54cc024ef0:g:29QAAOSwPgZkJYDm&amdata=enc%3AAQAHAAAA4AZwfSBNZiitjp7aHLjK%2FGwpIgOaar4nCtlJsVJOXpyY69Shpiqi095BzV3SUnFUufqZslx0wySNE1w9vYk5gSUbfUPR%2BmWqRKFGlNaRc7ptzvNIqilnJV%2Fr1vIlA9g74qAJozXG7Tk7FZ67rPkQQfpYiNaK9wRZlLNjf3CQcGO%2Bu4dLANaSHu9WJwjpEm5upGElVztMljNwLIZBhZBx064AXP8PPxzWPv79FAJSEnC71V1JawGs5VUlqCcMNUVmhkJiUaPTY5BHD0eCrGAKePVezv80AIKQ5a6%2By4g3vuYi%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/195676444387?hash=item2d8f3996e3:g:RH4AAOSwBLdkHW22&amdata=enc%3AAQAHAAAAwL2qteSQIOXXCMzR5472Qvu2tF3zy5NBKVxZBWSQHkABXZ8clP7cZjYvS4nD2ZtwcclYBY1%2BmOX0qgOw5i6AgodsXkufaiCtH0gqAuigCBQcFxWn2RChxFs0QPvNJBdHJ45E6uY0IcsI1uwF0GoRbNpGNhUCDKb2AlbLq%2FSDHlxqgo7WsAyg2n068ybETgVCiB4%2BstTKM%2FGa49gtR5wX0SqCrhdDe2G0KWWmwo8wmGe74OO9E1ZjpkJm4j8Xl%2BHT1w%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/185834229653?hash=item2b44954f95:g:6QAAAOSw-c5jxcfC&amdata=enc%3AAQAHAAAA4IfuqkeeA%2BnUNVmMXnW0W9B%2BOlEgw%2FbcRESzftq49lV9LBxlmqnw91ymQkTLRvD9bpMHTXUdRQ0x2iWAohdErAXjx5wORWPbTNXOSPTwwcpx3ZNi7au8JThjYjmKKRY%2FHBgWFSZ1TtMuLbxl4%2Bf%2BSNl7ArMhkKJw%2FNdfb4ZbADE5E4o5Dl%2BxZFADah%2B2cvSVteU%2FNttfh5jTmEZTdruRRej%2F0oSstd%2FdnAxktA1oMXF5nHhQzt%2BkRvQUpxuMmGZ2gOs3bi%2FByR%2BwHq4wCQmwBMDKP3wQ9X6P4zqtjmTqJQS2%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/303729681585?hash=item46b7b324b1:g:stEAAOSwxhxfigci&amdata=enc%3AAQAHAAAAwNE2zkIVEEYSTGngV8gIVim1EPD6eF4nt5UH9r679Nl%2FEatTOtSfM%2FvKrur90gU5XIZcJwGZxrQH1jhwv8bqzAoCnV6bor5HsbkzvpMZapqfeLlZmX83ybQM5EDkDtM0ZShdI2dYu5auZth6gTtiwF%2FIiY0aA5s%2BQCPDZbjnpWtkP65WFCsNVd1bYrdOD%2BfnpJwGijvpwKNQ%2BSlOynxzBAoP2UQ3KZ2djUfn9t%2F0XLLd%2BXF%2BQX17k1Ihf%2BfoL5FHsg%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/255982569658?hash=item3b99c008ba:g:jw0AAOSwhWdj7yXJ&amdata=enc%3AAQAHAAAA4GmcPanNYATP4%2F%2B9hmF6CsKze9G2SITwDffIFFOZj0x0BTUTPY36QhWHzfM8pAbiMp58sESQ7KHjk8%2FsPz4NrVyb4np3ZOchR8gH%2FK13AN7WRzZI8u0PNKYnT767ZQ6vVv79HpQ6NSO%2Fhvj3Tb5zZX%2B4jRSPoAB%2FFESiBYAoxi2TI9LB%2F3xKWP7hlj%2FP4VPeyVIVdohYw8fvxfehVno7wKQ2nnr7SGormtC3e78bA3NWzgQpLSfFjuh6FbM7vxa3u9eBniXcnFZZ9OaUVZcWT9EAkKZ1IG2vbo8mnmY4wbcv%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/385515254268?hash=item59c27ff1fc:g:DYcAAOSwvIJkJnT5&amdata=enc%3AAQAHAAAAwHg0fPXdSLARe8ZQS7XuFjtoLmnG6fJewA5lmkE3X1wShglYxE2tjdOXEv7Lf4I3q2dtpnagkwiLFodL2osbWHt82ekGypKyiSgzQjnkl%2BUPRnIeszlYvfW53IH21lLAYpPYn9MfWt0Lf%2FhseJn6O1dMgrHxNqqQopiBCQZtpE0aAVoaWOQ3MK1v2yF8iAOL7AjIC7mB54aPMtd2Zv4GFqp8EdoVbIwezR0N34HxkeoHTymEM7jRTknZIGhKyMHNXA%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/304326119317?hash=item46db400f95:g:4FUAAOSwtwph676~&amdata=enc%3AAQAHAAAA4BbDeoOFBf74NvyZkZTLyECIftNmJWo63VvLl1LgVr79xjv5nuynEn8yKCKgvmm0ZFXLcz8OlVIJc2bWqj%2B%2FFUXveMI%2BIByHnztFAUVGMVf56IYclo%2BCPr89qpkrTBO4oloxZPHM8RM0qMzJid3XG9wOME0xmZiQhxuvS%2FysA9%2FRYdYN4%2BdNZxFLsKm7kRoqwZr2nJS0vzVpklFCMY25RLiHxF4Oa%2Baha%2BDpfiITn9W8Rb95NymhjQQWEKJM7CWc7GNFJhuX3yTMUaWGhxKSWTEmseMOjwRn46cTHL2eD4gI%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/394198563681?hash=item5bc810bb61:g:2CEAAOSwKHNi9f63&amdata=enc%3AAQAHAAAA4I16v%2FMlGyzTWDzigU4ba%2BrqXt2lmOj%2FQPVltKL0rWccKE63ZLt4rdsQJnl4ByOvKU5oEUQWP5SW8VOOVJTmnycYZlQ5wIrRFH5Z4Q8aVJr71HZr%2F18NymWdc8G%2BITJN%2FgokPjstSZu1rEkR4VQYvqzh4h2C%2F63zDuwHFgQmgoRLWusq337exaDC%2Ba6%2F4OwZGV2d6bkEkw23T%2BM%2Bv2EEV1eLyJq%2BHBLjMCudR8Wl%2Bhu%2FvgfygsvFm6p2dWt8IOsRq0Wqgzoa0uYE8J5lkyM6fe13pWz2UpRkpUbvYumLPUWQ%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/363158394854?hash=item548ded57e6:g:g9kAAOSwYyhfkVms&amdata=enc%3AAQAHAAAA4Mzdep%2FdflQH5HnPWFi0t0mrxxZN6qSboYub8Cfy1c2GHaLFgrQx5UlIGsZokE%2FaWOL1M1%2FnXzVr1ypPhlVW5CldZ8lrkNSiXBKvNTZbYBWoJJg585pY0bZd0U0XhnulBdjcMMQv1fvJ2AT3axm4%2Ff0BKKgoYwdG%2FZT1wZXCprM%2FVBszxYyNIiSmB3mPOw3Rvb586QgHhtXHdEEx9hmkNpfHF7kwrauuMXVUEH84CArTQDyu7Z8VPi8K8gI%2BbQSEFoiK5Au0JdCvXjNLwnq3ISnitzkU4hwsXKgk8gBLB12E%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/195333572723?hash=item2d7ac9c873:g:4GAAAOSwc8xjF~ek&amdata=enc%3AAQAHAAAAwDE6aiozyOTHpvH1H1plSZgZhNeYmN9Q7PI5CY4vZotF6hvMcjdPbjKfsGkWBX%2FFp7Ec91scUYHuHr0Q6LNlIDGq9A8b2wSDONRBz%2BQgXbo%2BzVmiFqaNADIQms2nPRu6aub%2BUByRYW3zOVXf%2BCGQp6PKeNYJIh7AeOF%2BniUHugZt1FJiE0ZI2V1evBA%2B7nP7jj8a35is35Vk4ovlqzbbRtUbA%2BAaagexV62ZZpiZegQQDoKygynRMxFXOS3kGXnA8A%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/294989815546?hash=item44aec35efa:g:SU8AAOSw3ZJhd6yS&amdata=enc%3AAQAHAAAAwIioD1JVXk2c%2BCY9tzEmlotekyDA7I947reeHQXNvHjxK7uBowOvs3e2QVmNa4RkF0STvzPBJPNEQwETMZbQaWXSEvRMJPRgVM4cat%2FKaH8WUInisha1L9iQNgnIk%2B0nmoAFpRP2aZuupiGiZ41IKuC15fGPitugv35SXqSKRe%2FoPyzDaImqKOO7wuDVBas%2Fkt5zDQ60v8MB8lr0ALC%2BTLes%2BLVVILCRnydA7Gs8UlrmTuQkqyHeAIncn1t8Q%2F0e9Q%3D%3D%7Ctkp%3ABk9SR4bt94vnYQ\n",
      "\n",
      "Link:https://www.ebay.com/itm/285181033841?hash=item42661d3d71:g:kN8AAOSwPqtkHT4e&amdata=enc%3AAQAHAAAA0OEX4ACtKdV%2Fs1RpBeaZlxN0OZK7HxOIKZgGYaERpt9W34rQh1mH1PDlQyvmPl3BtjmVOuljRPDPShhpY5LumCBxq4u%2B%2BYH2p6Ac3xfSUyD3Ay9D0hes%2FYrb2WL%2FzK28fKXZIQ1%2BcGxWl2cz6l2Stc5ccGl%2FMLgihLFam69vIOuKOT6GPbUuRVuKtpJq6wFvOVc7mZ86nLKfiD5UtpS1xCITNqnHekgggy44lXmHV2rbO50b9oOkAFlJc2RyY6pmzyAGWG8TFqHM6PW0QWl9%2ByE%3D%7Ctkp%3ABFBMiO33i-dh\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Generating Webpage Links - It would be used for Question 2.\n",
    "links=[]\n",
    "\n",
    "for prod in products:\n",
    "    \n",
    "    # Generating Links and storing it in var 'links'\n",
    "    link = prod.find(\"div\", class_= \"s-item__info clearfix\").find(\"a\").get(\"href\")\n",
    "    \n",
    "    # Appending the Links in 'links' list.\n",
    "    links.append(link)\n",
    "    \n",
    "    # Printing the Link\n",
    "    print(f\"Link:{link}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d3f1049d",
   "metadata": {},
   "source": [
    "### 7. Shipping Cost"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "8a299890",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shipping Cost:N/A\n",
      "\n",
      "Shipping Cost:Free shipping\n",
      "\n",
      "Shipping Cost:Free shipping\n",
      "\n",
      "Shipping Cost:+$206.01 shipping\n",
      "\n",
      "Shipping Cost:+$203.74 shipping\n",
      "\n",
      "Shipping Cost:+$203.98 shipping\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:Shipping not specified\n",
      "\n",
      "Shipping Cost:Free International Shipping\n",
      "\n",
      "Shipping Cost:+$2.00 shipping\n",
      "\n",
      "Shipping Cost:+$1,307.69 shipping\n",
      "\n",
      "Shipping Cost:+$1,058.69 shipping\n",
      "\n",
      "Shipping Cost:+$75.03 shipping\n",
      "\n",
      "Shipping Cost:+$203.46 shipping\n",
      "\n",
      "Shipping Cost:Free International Shipping\n",
      "\n",
      "Shipping Cost:+$8.00 shipping\n",
      "\n",
      "Shipping Cost:Free International Shipping\n",
      "\n",
      "Shipping Cost:+$202.80 shipping\n",
      "\n",
      "Shipping Cost:+$203.74 shipping\n",
      "\n",
      "Shipping Cost:+$216.72 shipping\n",
      "\n",
      "Shipping Cost:+$90.00 shipping\n",
      "\n",
      "Shipping Cost:Shipping not specified\n",
      "\n",
      "Shipping Cost:Shipping not specified\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:+$204.06 shipping\n",
      "\n",
      "Shipping Cost:+$19.06 shipping\n",
      "\n",
      "Shipping Cost:Free shipping\n",
      "\n",
      "Shipping Cost:+$197.53 shipping\n",
      "\n",
      "Shipping Cost:+$107.25 shipping\n",
      "\n",
      "Shipping Cost:+$203.76 shipping\n",
      "\n",
      "Shipping Cost:+$0.62 shipping\n",
      "\n",
      "Shipping Cost:Shipping not specified\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:Free shipping\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:N/A\n",
      "\n",
      "Shipping Cost:Free shipping\n",
      "\n",
      "Shipping Cost:Shipping not specified\n",
      "\n",
      "Shipping Cost:Shipping not specified\n",
      "\n",
      "Shipping Cost:+$2.00 shipping\n",
      "\n",
      "Shipping Cost:+$153.06 shipping\n",
      "\n",
      "Shipping Cost:+$3.00 shipping\n",
      "\n",
      "Shipping Cost:N/A\n",
      "\n",
      "Shipping Cost:+$0.80 shipping\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:N/A\n",
      "\n",
      "Shipping Cost:Free shipping\n",
      "\n",
      "Shipping Cost:+$3.99 shipping\n",
      "\n",
      "Shipping Cost:N/A\n",
      "\n",
      "Shipping Cost:+$127.70 shipping\n",
      "\n",
      "Shipping Cost:+$97.36 shipping\n",
      "\n",
      "Shipping Cost:+$3.00 shipping\n",
      "\n",
      "Shipping Cost:+$185.50 shipping\n",
      "\n",
      "Shipping Cost:Free International Shipping\n",
      "\n",
      "Shipping Cost:Free International Shipping\n",
      "\n",
      "Shipping Cost:+$0.80 shipping\n",
      "\n",
      "Shipping Cost:Free International Shipping\n",
      "\n",
      "Shipping Cost:Shipping not specified\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Shipping Cost\n",
    "\n",
    "shipping_cost=[]\n",
    "\n",
    "for prod in products:\n",
    "    # Finding Shipping Cost & if the Shipping Cost is N.A., it will generate N/A\n",
    "    shipping_tag = prod.find(\"span\", class_=\"s-item__shipping s-item__logisticsCost\")\n",
    "    # saved the shipping cost in var 'tags'\n",
    "    tags = (shipping_tag.text.strip() if shipping_tag else \"N/A\")\n",
    "    # Appending it in the 'shipping_cost' list\n",
    "    shipping_cost.append(tags)\n",
    "    # Print the Shipping Cost...\n",
    "    print(f\"Shipping Cost:{tags}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7f8be6fa",
   "metadata": {},
   "source": [
    "## Create a DataFrame and Generate the tsv file named 'tableList.tsv' as instructed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "4d02f2e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating Dataframe..\n",
    "\n",
    "tableList = pd.DataFrame(product_name, columns=[\"Product_Name\"])\n",
    "tableList[\"Product_Condition\"] = pd.Series(prod_condition)\n",
    "tableList[\"Price\"] = pd.Series(price)\n",
    "tableList[\"No_Watchers\"] = pd.Series(no_watchers)\n",
    "tableList[\"Image_URL\"] = pd.Series(img_url)\n",
    "tableList[\"Webpage_Link\"] = pd.Series(links)\n",
    "tableList[\"Shipping_Cost\"] = pd.Series(shipping_cost)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "74d458fc",
   "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>Product_Name</th>\n",
       "      <th>Product_Condition</th>\n",
       "      <th>Price</th>\n",
       "      <th>No_Watchers</th>\n",
       "      <th>Image_URL</th>\n",
       "      <th>Webpage_Link</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shop on eBay</td>\n",
       "      <td>Brand New</td>\n",
       "      <td>$20.00</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>https://ir.ebaystatic.com/rs/v/fxxj3ttftm5ltcq...</td>\n",
       "      <td>https://ebay.com/itm/123456?hash=item28caef0a3...</td>\n",
       "      <td>N/A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Malachite Round Top Coffee Table Top Semi Prec...</td>\n",
       "      <td>Brand New</td>\n",
       "      <td>$333.00 to $2,300.40</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>https://i.ebayimg.com/thumbs/images/g/NPcAAOSw...</td>\n",
       "      <td>https://www.ebay.com/itm/125624687528?hash=ite...</td>\n",
       "      <td>Free shipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Live edge very old giant size great shape oliv...</td>\n",
       "      <td>Brand New</td>\n",
       "      <td>$704.96 to $6,471.47</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>https://i.ebayimg.com/thumbs/images/g/IroAAOSw...</td>\n",
       "      <td>https://www.ebay.com/itm/114858552175?hash=ite...</td>\n",
       "      <td>Free shipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Foldable Indoor Plastic Round Dining Table Por...</td>\n",
       "      <td>Brand New</td>\n",
       "      <td>$105.99 to $199.99</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>https://i.ebayimg.com/thumbs/images/g/0usAAOSw...</td>\n",
       "      <td>https://www.ebay.com/itm/134177164095?hash=ite...</td>\n",
       "      <td>+$206.01 shipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Foldable Adjustable Height TV Tray Home Portab...</td>\n",
       "      <td>Brand New</td>\n",
       "      <td>$38.99</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>https://i.ebayimg.com/thumbs/images/g/9eEAAOSw...</td>\n",
       "      <td>https://www.ebay.com/itm/134246341723?hash=ite...</td>\n",
       "      <td>+$203.74 shipping</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Product_Name Product_Condition  \\\n",
       "0                                       Shop on eBay         Brand New   \n",
       "1  Malachite Round Top Coffee Table Top Semi Prec...         Brand New   \n",
       "2  Live edge very old giant size great shape oliv...         Brand New   \n",
       "3  Foldable Indoor Plastic Round Dining Table Por...         Brand New   \n",
       "4  Foldable Adjustable Height TV Tray Home Portab...         Brand New   \n",
       "\n",
       "                  Price    No_Watchers  \\\n",
       "0                $20.00  Not Available   \n",
       "1  $333.00 to $2,300.40  Not Available   \n",
       "2  $704.96 to $6,471.47  Not Available   \n",
       "3    $105.99 to $199.99  Not Available   \n",
       "4                $38.99  Not Available   \n",
       "\n",
       "                                           Image_URL  \\\n",
       "0  https://ir.ebaystatic.com/rs/v/fxxj3ttftm5ltcq...   \n",
       "1  https://i.ebayimg.com/thumbs/images/g/NPcAAOSw...   \n",
       "2  https://i.ebayimg.com/thumbs/images/g/IroAAOSw...   \n",
       "3  https://i.ebayimg.com/thumbs/images/g/0usAAOSw...   \n",
       "4  https://i.ebayimg.com/thumbs/images/g/9eEAAOSw...   \n",
       "\n",
       "                                        Webpage_Link      Shipping_Cost  \n",
       "0  https://ebay.com/itm/123456?hash=item28caef0a3...                N/A  \n",
       "1  https://www.ebay.com/itm/125624687528?hash=ite...      Free shipping  \n",
       "2  https://www.ebay.com/itm/114858552175?hash=ite...      Free shipping  \n",
       "3  https://www.ebay.com/itm/134177164095?hash=ite...  +$206.01 shipping  \n",
       "4  https://www.ebay.com/itm/134246341723?hash=ite...  +$203.74 shipping  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tableList.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bb06d329",
   "metadata": {},
   "source": [
    "### Exporting the tsv file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "2943fdae",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the tsv file as 'tableList.tsv'\n",
    "tableList.to_csv(\"tableList.tsv\", index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a4a3375b",
   "metadata": {},
   "source": [
    "## For each product, we will go into each link and would extract the Product Name, Return Policy, Ships to, Item Location, Shipping Cost, Estimated delivery date, Payment modes available, Price, Starting bid, eBay item number Condition, Brand, Color, Type and Material**\n",
    "\n",
    "### Product Name\n",
    "\n",
    "* Now, We will use the \"links\" list created above. It has all the links to the webpages and now we will run the loop on the web pages to extract the above mentioned information.\n",
    "\n",
    "* The key aspect is to run the loop on the links and find the correct tag that can help extract the desired information.\n",
    "\n",
    "* The below code would extract the name of each product from a list of links. For each link, it sends an HTTP request to that link, gets the HTML content of the page, and then extracts the product name from the HTML using Beautiful Soup. The extracted product names are then stored in a list called \"product_titles\". The code then prints the name of each product to the console."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "617bd00a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Product Name: Malachite Round Top Coffee Table Top Semi Precious Mosaic Art Inlay Home Decor\n",
      "\n",
      "Product Name: Live edge very old giant size, great shape, olive Acacia wood slab, coffee table\n",
      "\n",
      "Product Name: Foldable Indoor Plastic Round Dining Table Portable Outdoor Picnic Desk w/Handle\n",
      "\n",
      "Product Name: Foldable Adjustable Height TV Tray Home Portable Sofa Bed Side Table Laptop Desk\n",
      "\n",
      "Product Name: End Table Espresso Storage Living Room Half Round Table Moon Drawer Shelf Design\n",
      "\n",
      "Product Name: Industrial Style Porch Table Single Layer Black Oak Triamine Board [105 * 30 * 7\n",
      "\n",
      "Product Name: Industrial Style Porch Table Single Layer Light Walnut Color Triamine Board\n",
      "\n",
      "Product Name: Shellmond Rustic Distressed Metal Accent Cocktail Table with Lift Top 20\", Gray\n",
      "\n",
      "Product Name: Silicone Chair Leg Caps Covers Furniture Table Feet Pads Floor Protectors\n",
      "\n",
      "Product Name: 46*46*46cm Single Layer Round HDPE Side Table Black\n",
      "\n",
      "Product Name: Million Dollar Cube Side Table - coffee side table great for home and office\n",
      "\n",
      "Product Name: Million Dollar Cube Side Table - With Free Money Stack\n",
      "\n",
      "Product Name: CRZDEAL TV Tray Table - 22'' TV Dinner Tray 6 Adjustable Height Settings TV-01\n",
      "\n",
      "Product Name: Portable Adjustable Folding Laptop Desk Foldable Study Computer Bed Table Stand\n",
      "\n",
      "Product Name: 4X Chair Leg Cap Silicon Rubber Feet Floor Protector Pad Furniture Table Cover\n",
      "\n",
      "Product Name: Sofa Side Table with Storage Shelf Metal Frame for Home Decor Dining Room\n",
      "\n",
      "Product Name: Rolling Computer Desk Laptop PC Coner Table Desktop w/ Rolling Wheel Home Office\n",
      "\n",
      "Product Name: Alex 2-Pc Set TV Table, Natural, 19.06 X 14.57 X 25.98\"\n",
      "\n",
      "Product Name: Height Adjustable Notebook Laptop Computer Desk Portable Table Sofa Bed Tray\n",
      "\n",
      "Product Name: Dane 20 Inch Black Frame Side Table / End Table / Easy Assembly, Red Mahogany Wo\n",
      "\n",
      "Product Name: Murphy Folding Table Space Saving Wall Mounted Foldable Dining Kitchen Table\n",
      "\n",
      "Product Name: 21 3/4\" Round Solid Oak Pedestal Table For Repair\n",
      "\n",
      "Product Name: dining table base\n",
      "\n",
      "Product Name: 46*46*46cm Single Layer Round HDPE Side Table White\n",
      "\n",
      "Product Name: Round[360-DEGREE SWIVEL]Counter Pub Bar Table Adjustable Height Wooden Tabletop\n",
      "\n",
      "Product Name: herman miller noguchi Coffee Table dowel pin assembly part\n",
      "\n",
      "Product Name: Living Room Best Table For Decor Home Modern Coffee Table Round Nesting Gift\n",
      "\n",
      "Product Name: Acadian SOLID WOOD 19 Inch Wide Square Transitional Transitional End Side Table \n",
      "\n",
      "Product Name: Table legs, a set of 4, various lengths\n",
      "\n",
      "Product Name: Folding Table 4ft Adjustable Height Portable Lightweight Aluminum Camping Table\n",
      "\n",
      "Product Name: 10pcs Silicone Chair Leg Caps Covers Furniture Table Feet Pads Floor Protectors\n",
      "\n",
      "Product Name: Mainstays 5pc XL Oversized Tray Table Set, Rustic Grey\n",
      "\n",
      "Product Name: 3 Tier End Table with Wheels,Side Table Nightstand Storage Shelf for Bedroom,Kit\n",
      "\n",
      "Product Name: 36*36*47cm Single Layer Square HDPE Side Table White\n",
      "\n",
      "Product Name: 15\" Triangle Shape Wood Stool with Brass Work | Wooden Sitting Table | Handmade\n",
      "\n",
      "Product Name: FCH Retro Color Particleboard Triamine Curved Handle One Drawer Bedside Table\n",
      "\n",
      "Product Name: Oak Wood Octagon Side Living Room End Table Nightstand w/ scratches\n",
      "\n",
      "Product Name: Wooden 2 Tier Coffee Table For Living Room Solid Legs Large Nesting Table\n",
      "\n",
      "Product Name: High Gloss Designer White Black Glass Modern Giovani Coffee Living Side Table\n",
      "\n",
      "Product Name: Wooden Coffee Table With Storage Lift Top Up Drawer Shelf Living Room Furniture\n",
      "\n",
      "Product Name: Nightstand Modern End Table, Side Table with 1 Drawer and Storage Shelf, White\n",
      "\n",
      "Product Name: Skyler Solid Mango Wood and Metal 18 Inch Wide Rectangle Inrial C Side Table in \n",
      "\n",
      "Product Name: Single Layer Bamboo Side Table 40*37*59.5cm Round White Table Top Natural Wood T\n",
      "\n",
      "Product Name: wood framed inset glass topped nesting tables - (2) - $175.00\n",
      "\n",
      "Product Name: M6 M8 M10 Adjustable Table Chair Feet Leveling Glide Furniture Legs Pad Mat\n",
      "\n",
      "Product Name: Modern LED Light 2 Drawers Nightstand Storage Shelf Bedside End Table Cabinet wi\n",
      "\n",
      "Product Name: Anderson Teak Chester 32\" Round Folding Picnic Table\n",
      "\n",
      "Product Name: Home Decor Modern Coffee Table Round Center For Living Room Nesting Table Gift\n",
      "\n",
      "Product Name: 45*38*63cm Country Style Three Drawer Night Table Large Size Brown\n",
      "\n",
      "Product Name: 6 Foot Heavy Duty Centerfold Folding Table Black Portable Outdoor Picnic Party\n",
      "\n",
      "Product Name: Portable Adjustable Folding Laptop Desk Foldable Study Computer Bed Table Stand\n",
      "\n",
      "Product Name: Round Adirondack Side End Table Outdoor Small Coffee Table for Patio Garden Blue\n",
      "\n",
      "Product Name: Removable E1 15MM Chipboard & Steel Side Table Wood Color S\n",
      "\n",
      "Product Name: 32X20X20\" Prayer Bench, Padded kneeler Easy Fold-away Prayer Table Chair\n",
      "\n",
      "Product Name: 10X Rubber Feet Protector Furniture Chair Table Leg Pads Floor Protector Black\n",
      "\n",
      "Product Name: 12Pcs 10-25mm Rubber Furniture Leg Table Chair Foot Tips Cap Cover Pad Protector\n",
      "\n",
      "Product Name: Round Chair Leg Cap Rubber Feet Protector Pads Furniture Table Covers Bottom\n",
      "\n",
      "Product Name: 12Pc Table Chair Feet Rubber Leg Tips Caps Floor Protectors for Indoor/Outdoor\n",
      "\n",
      "Product Name: HXL Folding Utility Table 6ft Fold-in-Half Portable Plastic Picnic Party Dining\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Extract Product Names\n",
    "product_titles=[]\n",
    "\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    \n",
    "    # Extracting Product Names...\n",
    "    titles = page_soup.find_all(\"div\", class_=\"vim x-item-title\")\n",
    "    for names in titles:\n",
    "        titles = names.find(\"h1\", class_=\"x-item-title__mainTitle\").find(\"span\", class_=\"ux-textspans ux-textspans--BOLD\").text\n",
    "        product_titles.append(titles)\n",
    "        print(f\"Product Name: {titles}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "15578ae6",
   "metadata": {},
   "source": [
    "### Return Policy\n",
    "\n",
    "Below code would return the Return Policy from the webpages. There are three statements for the Return Policy which are published/printed using refund_policy1, 2 & 3.\n",
    "\n",
    "* First, the code starts with 03 blank lists for the purpose of containing the values. Then, for each link in the 'links' list, the code sends a request to the webpage and extracts its content using BeautifulSoup.\n",
    "\n",
    "* The code then searches for all the div tags with class 'vim x-returns-maxview' in the content using BeautifulSoup's 'find_all' method. For each of these tags, the code extracts the first refund policy and appends it to the 'refund_policy1' list.\n",
    "\n",
    "* If the first refund policy has a next sibling with class 'ux-table-section__cell', the code extracts the second refund policy and appends it to the 'refund_policy2' list and the same goes for the 3rd policy."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "4230fc0a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back, Replacement\n",
      "\n",
      "Refund Policy3: Seller pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back, Replacement\n",
      "\n",
      "Refund Policy3: Seller pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy3: Free shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 14 days\n",
      "\n",
      "Refund Policy2: Money Back, Replacement\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Seller pays for return shipping\n",
      "\n",
      "Refund Policy3: Free shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Seller pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy3: GBP 0.50\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back, Replacement\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Seller pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy3: Will usually ship within 3 business days of receiving cleared payment.\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 60 days\n",
      "\n",
      "Refund Policy2: Money Back, Replacement\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Seller pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping. Personalized items cannot be returned\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 60 days\n",
      "\n",
      "Refund Policy2: Money Back, Replacement\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: 30 days\n",
      "\n",
      "Refund Policy2: Money Back\n",
      "\n",
      "Refund Policy3: Buyer pays for return shipping\n",
      "\n",
      "Refund Policy1: Seller does not accept returns\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Extracting Return Policy\n",
    "refund_policy1=[]\n",
    "refund_policy2=[]\n",
    "refund_policy3=[]\n",
    "\n",
    "for link in links:\n",
    "    # Extracting Refund Policy\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    refunds = page_soup.find_all(\"div\", class_=\"vim x-returns-maxview\")\n",
    "    for refund in refunds:\n",
    "        refund1 = refund.find(\"td\", class_=\"ux-table-section__cell\").find(\"span\")\n",
    "        refund_policy1.append(refund1.text.strip())\n",
    "        print(f\"Refund Policy1: {refund1.text.strip()}\\n\")\n",
    "        \n",
    "        \n",
    "        refund2 = refund1.find_next(\"td\", class_=\"ux-table-section__cell\")\n",
    "        if refund2 is not None:\n",
    "            refund2 = refund2.find(\"span\", class_=\"ux-textspans\")\n",
    "            refund_policy2.append(refund2.text.strip())\n",
    "            print(f\"Refund Policy2: {refund2.text.strip()}\\n\")\n",
    "        \n",
    "            refund3 = refund2.find_next(\"td\", class_=\"ux-table-section__cell\")\n",
    "            if refund3 is not None:\n",
    "                refund3 = refund3.find(\"span\", class_=\"ux-textspans\")\n",
    "                refund_policy3.append(refund3.text.strip())\n",
    "                print(f\"Refund Policy3: {refund3.text.strip()}\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1054b201",
   "metadata": {},
   "source": [
    "### Ships to:\n",
    "\n",
    "* This code tries to extract information about where a product can be shipped to. It does this by first sending a request to a webpage using the requests library and then using BeautifulSoup to parse the HTML response. \n",
    "\n",
    "* It then looks for a section of the HTML that contains information about shipping locations and saves that information to a list called ships_to. Finally, it prints the shipping location information for each product and adds it to the ships_to list."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "4cfb3783",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Andorra Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Bermuda Bhutan Bolivia Bosnia and Herzegovina Brazil Brunei Darussalam Bulgaria Cambodia Canada Cayman Islands Chile China Colombia Costa Rica Cyprus Czech Republic Denmark Dominican Republic Ecuador El Salvador Estonia Fiji Finland France Georgia Germany Gibraltar Greece Greenland Grenada Guatemala Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Liechtenstein Lithuania Luxembourg Macau Macedonia Malaysia Maldives Malta Mexico Moldova Monaco Mongolia Montenegro Montserrat Nauru Nepal Netherlands New Zealand Nicaragua Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Romania Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Serbia Singapore Slovakia Slovenia Solomon Islands South Korea Spain Sri Lanka Suriname Sweden Switzerland Taiwan Tajikistan Thailand Tonga Trinidad and Tobago Turkmenistan Turks and Caicos Islands United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Andorra Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Bermuda Bhutan Bolivia Bosnia and Herzegovina Brazil Brunei Darussalam Bulgaria Cambodia Canada Cayman Islands Chile China Colombia Costa Rica Cyprus Czech Republic Denmark Dominican Republic Ecuador El Salvador Estonia Fiji Finland France Georgia Germany Gibraltar Greece Greenland Grenada Guatemala Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Liechtenstein Lithuania Luxembourg Macau Macedonia Malaysia Maldives Malta Mexico Moldova Monaco Mongolia Montenegro Montserrat Nauru Nepal Netherlands Nicaragua Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Romania Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Serbia Singapore Slovakia Slovenia Solomon Islands South Korea Spain Sri Lanka Suriname Sweden Switzerland Taiwan Tajikistan Thailand Tonga Trinidad and Tobago Turkmenistan Turks and Caicos Islands United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Afghanistan Albania Andorra Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Bermuda Bhutan Bolivia Bosnia and Herzegovina Brazil Brunei Darussalam Bulgaria Cambodia Canada Cayman Islands Chile China Colombia Costa Rica Cyprus Czech Republic Denmark Dominican Republic Ecuador El Salvador Estonia Fiji Finland France Georgia Germany Gibraltar Greece Greenland Grenada Guatemala Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Liechtenstein Lithuania Luxembourg Macau Macedonia Malaysia Maldives Malta Mexico Moldova Monaco Mongolia Montenegro Montserrat Nauru Nepal Netherlands New Zealand Nicaragua Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Romania Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Serbia Singapore Slovakia Slovenia Solomon Islands South Korea Spain Sri Lanka Suriname Sweden Switzerland Taiwan Tajikistan Thailand Tonga Trinidad and Tobago Turkmenistan Turks and Caicos Islands United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: United States\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Andorra Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Bermuda Bhutan Bolivia Bosnia and Herzegovina Brazil Brunei Darussalam Bulgaria Cambodia Canada Cayman Islands Chile China Colombia Costa Rica Cyprus Czech Republic Denmark Dominican Republic Ecuador El Salvador Estonia Fiji Finland France Georgia Germany Gibraltar Greece Greenland Grenada Guatemala Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Liechtenstein Lithuania Luxembourg Macau Macedonia Malaysia Maldives Malta Mexico Moldova Monaco Mongolia Montenegro Montserrat Nauru Nepal Netherlands New Zealand Nicaragua Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Romania Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Serbia Singapore Slovakia Slovenia Solomon Islands South Korea Spain Sri Lanka Suriname Sweden Switzerland Taiwan Tajikistan Thailand Tonga Trinidad and Tobago Turkmenistan Turks and Caicos Islands United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Algeria Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Azerbaijan Republic Bahamas Bahrain Bangladesh Belize Benin Bermuda Bhutan Bolivia Botswana Brazil Brunei Darussalam Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Ethiopia Fiji Gabon Republic Gambia Georgia Ghana Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong India Indonesia Israel Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Lebanon Lesotho Liberia Macau Madagascar Malawi Malaysia Maldives Mali Mauritania Mauritius Mexico Mongolia Montserrat Morocco Mozambique Namibia Nauru Nepal New Zealand Nicaragua Niger Nigeria Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Qatar Republic of the Congo Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines Saudi Arabia Senegal Seychelles Sierra Leone Singapore Solomon Islands South Africa South Korea Sri Lanka Suriname Swaziland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United States Uzbekistan Vanuatu Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: United States\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: United States\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Antigua and Barbuda Aruba Australia Austria Bahamas Bahrain Bangladesh Barbados Belgium Belize Bermuda Bolivia Brazil Brunei Darussalam Bulgaria Cambodia Canada Cayman Islands Chile China Colombia Costa Rica Cyprus Czech Republic Denmark Dominica Dominican Republic Ecuador Egypt El Salvador Estonia Finland France French Guiana Germany Gibraltar Greece Grenada Guadeloupe Guatemala Guernsey Honduras Hong Kong Hungary Iceland Indonesia Ireland Israel Italy Jamaica Japan Jersey Jordan Kuwait Latvia Liechtenstein Lithuania Luxembourg Macau Malaysia Maldives Malta Martinique Mexico Monaco Montserrat Netherlands New Zealand Nicaragua Norway Oman Pakistan Panama Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Reunion Romania Saint Kitts-Nevis Saint Lucia Saudi Arabia Singapore Slovakia Slovenia South Africa South Korea Spain Sri Lanka Sweden Switzerland Taiwan Thailand Trinidad and Tobago Turks and Caicos Islands United Arab Emirates United Kingdom United States Vietnam\n",
      "\n",
      "Shipping to: Antigua and Barbuda Aruba Austria Bahamas Bahrain Bangladesh Barbados Belgium Bermuda Bolivia Brunei Darussalam Bulgaria Cambodia Canada Cayman Islands China Colombia Costa Rica Cyprus Czech Republic Denmark Dominica Dominican Republic Ecuador Egypt El Salvador Estonia Finland France French Guiana Germany Gibraltar Greece Grenada Guadeloupe Guatemala Guernsey Honduras Hong Kong Hungary Iceland Indonesia Ireland Jamaica Japan Jersey Jordan Kuwait Latvia Liechtenstein Lithuania Luxembourg Macau Malaysia Maldives Malta Martinique Mexico Monaco Montserrat Netherlands Nicaragua Norway Oman Pakistan Panama Paraguay Philippines Poland Portugal Qatar Republic of Croatia Reunion Romania Saint Kitts-Nevis Saint Lucia Saudi Arabia Singapore Slovakia Slovenia South Africa South Korea Spain Sweden Switzerland Taiwan Thailand Trinidad and Tobago Turks and Caicos Islands United Arab Emirates United Kingdom United States Vietnam\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Afghanistan Albania Andorra Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Bermuda Bhutan Bolivia Bosnia and Herzegovina Brazil Brunei Darussalam Bulgaria Cambodia Canada Cayman Islands Chile China Colombia Costa Rica Cyprus Czech Republic Denmark Dominican Republic Ecuador El Salvador Estonia Fiji Finland France Georgia Germany Gibraltar Greece Greenland Grenada Guatemala Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Liechtenstein Lithuania Luxembourg Macau Macedonia Malaysia Maldives Malta Mexico Moldova Monaco Mongolia Montenegro Montserrat Nauru Nepal Netherlands Nicaragua Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Romania Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Serbia Singapore Slovakia Slovenia Solomon Islands South Korea Spain Sri Lanka Suriname Sweden Switzerland Taiwan Tajikistan Thailand Tonga Trinidad and Tobago Turkmenistan Turks and Caicos Islands United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: United States\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: United States\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: United States\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom United States Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Afghanistan Albania Algeria Americas Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Asia Australia Austria Azerbaijan Republic Bahamas Bahrain Bangladesh Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Islands Cayman Islands Central African Republic Chad Chile China Colombia Costa Rica Cyprus Czech Republic Côte d'Ivoire (Ivory Coast) Democratic Republic of the Congo Denmark Djibouti Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Europe Fiji Finland France Gabon Republic Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Croatia Republic of the Congo Romania Rwanda Saint Helena Saint Kitts-Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands South Africa South Korea Spain Sri Lanka Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkmenistan Turks and Caicos Islands Uganda United Arab Emirates United Kingdom Uzbekistan Vanuatu Vatican City State Vietnam Wallis and Futuna Western Samoa Yemen Zambia Zimbabwe\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: Worldwide\n",
      "\n",
      "Shipping to: United States\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Ships to...\n",
    "ships_to=[]\n",
    "\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    main = page_soup.find_all(\"div\", class_=\"vim sh-tab-bdr\")\n",
    "    for ship in main:\n",
    "        loc = ship.find(\"div\", class_=\"ux-layout-section-module\").find(\"div\", class_=\"ux-layout-section ux-layout-section--shipping\")\n",
    "        shipto_loc = loc.find_next(\"span\", class_=\"ux-textspans ux-textspans--SECONDARY\").text.strip().replace(\",\", \"\")\n",
    "        print(f\"Shipping to: {shipto_loc}\\n\")\n",
    "        ships_to.append(shipto_loc)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ff48f99c",
   "metadata": {},
   "source": [
    "### Item Location\n",
    "\n",
    "* This code extracts the location where the product is being sold from. It first creates an empty list called item_location. It then loops over each link in the links list. Inside the loop, it uses the requests library to get the content of the page specified by the link, and then uses BeautifulSoup to parse the HTML content of the page.\n",
    "\n",
    "* It then looks for the HTML element that contains the item location information, using find(). If it finds the element, it extracts the item location text and adds it to the item_location list. Finally, it prints the item location and appends it to the item_location list."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "2bed9324",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Item Location: AGRA, UTTAR PRADESH, India\n",
      "\n",
      "Item Location: AGRA, UTTAR PRADESH, India\n",
      "\n",
      "Item Location: Houston, TX, United States\n",
      "\n",
      "Item Location: Houston, TX, United States\n",
      "\n",
      "Item Location: Englewood, Colorado, United States\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Rosedale, Maryland, United States\n",
      "\n",
      "Item Location: Guangzhou, China\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Miami, Florida, United States\n",
      "\n",
      "Item Location: Miami, Florida, United States\n",
      "\n",
      "Item Location: Las Vegas, Nevada, United States\n",
      "\n",
      "Item Location: El Monte, California, United States\n",
      "\n",
      "Item Location: putian, China\n",
      "\n",
      "Item Location: Shenzhen, China\n",
      "\n",
      "Item Location: XiXianXinQu, null, China\n",
      "\n",
      "Item Location: Rosedale, Maryland, United States\n",
      "\n",
      "Item Location: El Monte, California, United States\n",
      "\n",
      "Item Location: Rosedale, Maryland, United States\n",
      "\n",
      "Item Location: ANKARA, Turkey\n",
      "\n",
      "Item Location: Santa Fe, New Mexico, United States\n",
      "\n",
      "Item Location: Miami, Florida, United States\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Houston,TX, United States\n",
      "\n",
      "Item Location: Chicago, Illinois, United States\n",
      "\n",
      "Item Location: SAHARANPUR, UTTAR PRADESH, India\n",
      "\n",
      "Item Location: Rosedale, Maryland, United States\n",
      "\n",
      "Item Location: Franklin, Michigan, United States\n",
      "\n",
      "Item Location: Rancho Cucamonga, California, United States\n",
      "\n",
      "Item Location: 义乌, China\n",
      "\n",
      "Item Location: 深圳市, China\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Delhi, DELHI, India\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Chicago, Illinois, United States\n",
      "\n",
      "Item Location: SAHARANPUR, UTTAR PRADESH, India\n",
      "\n",
      "Item Location: BIRMINGHAM, United Kingdom\n",
      "\n",
      "Item Location: Peterborough, Cambridgeshire, United Kingdom\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Rosedale, Maryland, United States\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Dallas, Texas, United States\n",
      "\n",
      "Item Location: Dongguan, GD, China\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Elmsford, New York, United States\n",
      "\n",
      "Item Location: SAHARANPUR, UTTAR PRADESH, India\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Charlotte, North Carolina, United States\n",
      "\n",
      "Item Location: El Monte, California, United States\n",
      "\n",
      "Item Location: Dallas, Texas, United States\n",
      "\n",
      "Item Location: china, China\n",
      "\n",
      "Item Location: Downers Grove, IL, United States\n",
      "\n",
      "Item Location: 义乌, China\n",
      "\n",
      "Item Location: shenzhen, China\n",
      "\n",
      "Item Location: Dongguan, GD, China\n",
      "\n",
      "Item Location: shenzhen, China\n",
      "\n",
      "Item Location: FuJianXiaMen, China\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Item Location\n",
    "item_location=[]\n",
    "\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    main = page_soup.find_all(\"div\", class_=\"vim sh-tab-bdr\")\n",
    "    for ship in main:\n",
    "        item = ship.find(\"div\", class_=\"ux-labels-values col-12 ux-labels-values--itemLocation\").find(\"div\", class_=\"ux-labels-values__values col-6\")\n",
    "        for locs in item:\n",
    "            item_locs = locs.find(\"span\", class_=\"ux-textspans ux-textspans--BOLD\").text.strip()\n",
    "            print(f\"Item Location: {item_locs}\\n\")\n",
    "            item_location.append(item_locs)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ce6ba0c0",
   "metadata": {},
   "source": [
    "## Payment Types\n",
    "\n",
    "This code is searching for the payment methods that are available for each product in a list of links. It does this by visiting each link in the list, getting the web page content, and looking for a specific section that lists the payment methods."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "fd170160",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n",
      "Payment Modes:  ['PayPal', 'Apple Pay', 'Google Pay', 'Visa', 'Master Card', 'American Express', 'Discover']\n"
     ]
    }
   ],
   "source": [
    "# Payment Types\n",
    "\n",
    "payment_types=[]\n",
    "\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    modes_of_pay = page_soup.find_all(\"div\", class_=\"ux-layout-section ux-layout-section--payments\")\n",
    "    for payment_modes in modes_of_pay:\n",
    "        payments = payment_modes.find_all(\"span\", role = \"img\")\n",
    "        paymentmodes_ = [payment[\"title\"] for payment in payments]\n",
    "        print(\"Payment Modes: \", paymentmodes_)\n",
    "        payment_types.append(paymentmodes_)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe350fd3",
   "metadata": {},
   "source": [
    "## Shipping Cost\n",
    "\n",
    "* This code is trying to extract the cost of shipping for a list of items from different websites. For each website link, the code first sends a request to the website and uses BeautifulSoup to extract the shipping cost. \n",
    "* It looks for a table that contains information about the shipping costs, and then extracts the cost information from the first cell in the table. Finally, the extracted cost is added to a list called \"cost_of_shipping\". The code also prints the shipping cost for each item."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "65d02b42",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $14.12\n",
      "\n",
      "Shipping Cost: US $13.12\n",
      "\n",
      "Shipping Cost: US $203.98\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $2.00\n",
      "\n",
      "Shipping Cost: US $1,307.69\n",
      "\n",
      "Shipping Cost: US $1,058.69\n",
      "\n",
      "Shipping Cost: US $75.03\n",
      "\n",
      "Shipping Cost: US $49.98\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $8.00\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $202.80\n",
      "\n",
      "Shipping Cost: US $75.16\n",
      "\n",
      "Shipping Cost: US $216.72\n",
      "\n",
      "Shipping Cost: US $90.00\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: US $13.43\n",
      "\n",
      "Shipping Cost: US $19.06\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $197.53\n",
      "\n",
      "Shipping Cost: US $107.25\n",
      "\n",
      "Shipping Cost: US $203.76\n",
      "\n",
      "Shipping Cost: GBP 0.50\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $2.00\n",
      "\n",
      "Shipping Cost: US $153.06\n",
      "\n",
      "Shipping Cost: US $3.00\n",
      "\n",
      "Shipping Cost: US $0.80\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $3.99\n",
      "\n",
      "Shipping Cost: US $127.70\n",
      "\n",
      "Shipping Cost: US $97.36\n",
      "\n",
      "Shipping Cost: US $3.00\n",
      "\n",
      "Shipping Cost: US $185.50\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n",
      "Shipping Cost: US $0.80\n",
      "\n",
      "Shipping Cost: Free shipping\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Shipping Cost\n",
    "\n",
    "cost_of_shipping =[]\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    costing = page_soup.find_all(\"table\", class_=\"ux-table-section ux-table-section--html-table ux-table-section-with-hints--shippingTable\")\n",
    "    for cost in costing:\n",
    "        # cost.find(\"td\", class_=\"ux-table-section__cell\").find(\"span\").text)\n",
    "        transit_cost = cost.find(\"td\", class_=\"ux-table-section__cell\").find(\"span\").text.strip()\n",
    "        print(f\"Shipping Cost: {transit_cost}\\n\") \n",
    "        cost_of_shipping.append(transit_cost)\n",
    "        "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7b2b6d9b",
   "metadata": {},
   "source": [
    "## Price\n",
    "\n",
    "* This code is finding the price of a product on a webpage. It goes through a list of links to different product pages, and then it uses the requests library to get the HTML content of each page. \n",
    "\n",
    "* Then it uses BeautifulSoup to parse the HTML content and find the section of the page that displays the product price. Once it finds this section, it extracts the price and adds it to a list called \"price\". Finally, it prints the price of the product and adds it to the list."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "caa573a8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Price: US $333.00\n",
      "\n",
      "Price: US $704.96\n",
      "\n",
      "Price: US $105.99/ea\n",
      "\n",
      "Price: US $38.99/ea\n",
      "\n",
      "Price: US $55.15\n",
      "\n",
      "Price: US $55.87\n",
      "\n",
      "Price: US $55.63\n",
      "\n",
      "Price: US $189.19\n",
      "\n",
      "Price: GBP 1.95\n",
      "\n",
      "Price: US $54.69\n",
      "\n",
      "Price: US $260.00/ea\n",
      "\n",
      "Price: US $284.00/ea\n",
      "\n",
      "Price: US $29.95\n",
      "\n",
      "Price: US $19.99/ea\n",
      "\n",
      "Price: GBP 2.53\n",
      "\n",
      "Price: US $40.99\n",
      "\n",
      "Price: US $38.69\n",
      "\n",
      "Price: US $49.27\n",
      "\n",
      "Price: US $38.99/ea\n",
      "\n",
      "Price: US $38.47\n",
      "\n",
      "Price: US $319.95/ea\n",
      "\n",
      "Price: US $75.00\n",
      "\n",
      "Price: US $500.00\n",
      "\n",
      "Price: US $55.32\n",
      "\n",
      "Price: US $59.99/ea\n",
      "\n",
      "Price: US $89.00\n",
      "\n",
      "Price: US $59.80\n",
      "\n",
      "Price: US $103.14\n",
      "\n",
      "Price: US $24.99/ea\n",
      "\n",
      "Price: US $39.99\n",
      "\n",
      "Price: GBP 2.45\n",
      "\n",
      "Price: US $48.99/ea\n",
      "\n",
      "Price: US $54.69\n",
      "\n",
      "Price: US $54.63\n",
      "\n",
      "Price: US $79.00\n",
      "\n",
      "Price: US $55.85\n",
      "\n",
      "Price: US $0.33\n",
      "\n",
      "Price: US $59.80\n",
      "\n",
      "Price: GBP 199.99\n",
      "\n",
      "Price: GBP 59.95\n",
      "\n",
      "Price: US $55.36\n",
      "\n",
      "Price: US $129.81\n",
      "\n",
      "Price: US $55.63\n",
      "\n",
      "Price: US $175.00\n",
      "\n",
      "Price: US $1.65\n",
      "\n",
      "Price: US $55.98\n",
      "\n",
      "Price: US $75.00\n",
      "\n",
      "Price: US $57.61\n",
      "\n",
      "Price: US $54.20\n",
      "\n",
      "Price: US $15.00\n",
      "\n",
      "Price: US $23.18/ea\n",
      "\n",
      "Price: US $47.49\n",
      "\n",
      "Price: US $55.12\n",
      "\n",
      "Price: US $107.27\n",
      "\n",
      "Price: AU $3.09\n",
      "\n",
      "Price: US $9.72/ea\n",
      "\n",
      "Price: US $1.39\n",
      "\n",
      "Price: US $5.44/ea\n",
      "\n",
      "Price: US $49.98\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Price\n",
    "\n",
    "price_of_product=[]\n",
    "\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    price_prod = page_soup.find_all(\"div\", class_=\"x-price-primary\")\n",
    "    for p in price_prod:\n",
    "        product_price = p.find(\"span\").text.strip()\n",
    "        print(f\"Price: {product_price}\\n\")\n",
    "        price_of_product.append(product_price)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e87e5e2c",
   "metadata": {},
   "source": [
    "## E Bay Number \n",
    "\n",
    "* This code is finding the Ebay number of each product in a list of links to Ebay products. It starts by making a request to each link in the list, and then using BeautifulSoup to extract the Ebay number from the webpage. \n",
    "\n",
    "* It then adds each Ebay number to a list called ebay_number & prints the same"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "efe9cfac",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Ebay Number: 125624687528\n",
      "\n",
      "Ebay Number: 125624687528\n",
      "\n",
      "Ebay Number: 114858552175\n",
      "\n",
      "Ebay Number: 114858552175\n",
      "\n",
      "Ebay Number: 134177164095\n",
      "\n",
      "Ebay Number: 134177164095\n",
      "\n",
      "Ebay Number: 134246341723\n",
      "\n",
      "Ebay Number: 134246341723\n",
      "\n",
      "Ebay Number: 253496191779\n",
      "\n",
      "Ebay Number: 253496191779\n",
      "\n",
      "Ebay Number: 295583123463\n",
      "\n",
      "Ebay Number: 295583123463\n",
      "\n",
      "Ebay Number: 314481011464\n",
      "\n",
      "Ebay Number: 314481011464\n",
      "\n",
      "Ebay Number: 275769401156\n",
      "\n",
      "Ebay Number: 275769401156\n",
      "\n",
      "Ebay Number: 265473237961\n",
      "\n",
      "Ebay Number: 265473237961\n",
      "\n",
      "Ebay Number: 175655606617\n",
      "\n",
      "Ebay Number: 175655606617\n",
      "\n",
      "Ebay Number: 283997113265\n",
      "\n",
      "Ebay Number: 283997113265\n",
      "\n",
      "Ebay Number: 284402248308\n",
      "\n",
      "Ebay Number: 284402248308\n",
      "\n",
      "Ebay Number: 195178653961\n",
      "\n",
      "Ebay Number: 195178653961\n",
      "\n",
      "Ebay Number: 303730033918\n",
      "\n",
      "Ebay Number: 303730033918\n",
      "\n",
      "Ebay Number: 403595806095\n",
      "\n",
      "Ebay Number: 403595806095\n",
      "\n",
      "Ebay Number: 304710855999\n",
      "\n",
      "Ebay Number: 304710855999\n",
      "\n",
      "Ebay Number: 404202395176\n",
      "\n",
      "Ebay Number: 404202395176\n",
      "\n",
      "Ebay Number: 285213074253\n",
      "\n",
      "Ebay Number: 285213074253\n",
      "\n",
      "Ebay Number: 303729898354\n",
      "\n",
      "Ebay Number: 303729898354\n",
      "\n",
      "Ebay Number: 285213074755\n",
      "\n",
      "Ebay Number: 285213074755\n",
      "\n",
      "Ebay Number: 334580984616\n",
      "\n",
      "Ebay Number: 334580984616\n",
      "\n",
      "Ebay Number: 234953392493\n",
      "\n",
      "Ebay Number: 234953392493\n",
      "\n",
      "Ebay Number: 354687239103\n",
      "\n",
      "Ebay Number: 354687239103\n",
      "\n",
      "Ebay Number: 314481011474\n",
      "\n",
      "Ebay Number: 314481011474\n",
      "\n",
      "Ebay Number: 144897000471\n",
      "\n",
      "Ebay Number: 144897000471\n",
      "\n",
      "Ebay Number: 266178394032\n",
      "\n",
      "Ebay Number: 266178394032\n",
      "\n",
      "Ebay Number: 364199950938\n",
      "\n",
      "Ebay Number: 364199950938\n",
      "\n",
      "Ebay Number: 275769401127\n",
      "\n",
      "Ebay Number: 275769401127\n",
      "\n",
      "Ebay Number: 325086753195\n",
      "\n",
      "Ebay Number: 325086753195\n",
      "\n",
      "Ebay Number: 374526817006\n",
      "\n",
      "Ebay Number: 374526817006\n",
      "\n",
      "Ebay Number: 304746106601\n",
      "\n",
      "Ebay Number: 304746106601\n",
      "\n",
      "Ebay Number: 204263396801\n",
      "\n",
      "Ebay Number: 204263396801\n",
      "\n",
      "Ebay Number: 185826723913\n",
      "\n",
      "Ebay Number: 185826723913\n",
      "\n",
      "Ebay Number: 145002110485\n",
      "\n",
      "Ebay Number: 145002110485\n",
      "\n",
      "Ebay Number: 314493577197\n",
      "\n",
      "Ebay Number: 314493577197\n",
      "\n",
      "Ebay Number: 195676444385\n",
      "\n",
      "Ebay Number: 195676444385\n",
      "\n",
      "Ebay Number: 295597722039\n",
      "\n",
      "Ebay Number: 295597722039\n",
      "\n",
      "Ebay Number: 364199946310\n",
      "\n",
      "Ebay Number: 364199946310\n",
      "\n",
      "Ebay Number: 224074916316\n",
      "\n",
      "Ebay Number: 224074916316\n",
      "\n",
      "Ebay Number: 265563335373\n",
      "\n",
      "Ebay Number: 265563335373\n",
      "\n",
      "Ebay Number: 175655601762\n",
      "\n",
      "Ebay Number: 175655601762\n",
      "\n",
      "Ebay Number: 285213074185\n",
      "\n",
      "Ebay Number: 285213074185\n",
      "\n",
      "Ebay Number: 175671000049\n",
      "\n",
      "Ebay Number: 175671000049\n",
      "\n",
      "Ebay Number: 125856317791\n",
      "\n",
      "Ebay Number: 125856317791\n",
      "\n",
      "Ebay Number: 195458853245\n",
      "\n",
      "Ebay Number: 195458853245\n",
      "\n",
      "Ebay Number: 374582250381\n",
      "\n",
      "Ebay Number: 374582250381\n",
      "\n",
      "Ebay Number: 166008916806\n",
      "\n",
      "Ebay Number: 166008916806\n",
      "\n",
      "Ebay Number: 364199956208\n",
      "\n",
      "Ebay Number: 364199956208\n",
      "\n",
      "Ebay Number: 195676444387\n",
      "\n",
      "Ebay Number: 195676444387\n",
      "\n",
      "Ebay Number: 185834229653\n",
      "\n",
      "Ebay Number: 185834229653\n",
      "\n",
      "Ebay Number: 303729681585\n",
      "\n",
      "Ebay Number: 303729681585\n",
      "\n",
      "Ebay Number: 255982569658\n",
      "\n",
      "Ebay Number: 255982569658\n",
      "\n",
      "Ebay Number: 385515254268\n",
      "\n",
      "Ebay Number: 385515254268\n",
      "\n",
      "Ebay Number: 304326119317\n",
      "\n",
      "Ebay Number: 304326119317\n",
      "\n",
      "Ebay Number: 394198563681\n",
      "\n",
      "Ebay Number: 394198563681\n",
      "\n",
      "Ebay Number: 363158394854\n",
      "\n",
      "Ebay Number: 363158394854\n",
      "\n",
      "Ebay Number: 195333572723\n",
      "\n",
      "Ebay Number: 195333572723\n",
      "\n",
      "Ebay Number: 294989815546\n",
      "\n",
      "Ebay Number: 294989815546\n",
      "\n",
      "Ebay Number: 285181033841\n",
      "\n",
      "Ebay Number: 285181033841\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Ebay Number\n",
    "\n",
    "ebay_number=[]\n",
    "\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    number = page_soup.find_all(\"div\", class_=\"ux-layout-section__textual-display ux-layout-section__textual-display--itemId\")\n",
    "    for ebayno in number:\n",
    "         ebay_no = ebayno.find(\"span\", class_=\"ux-textspans ux-textspans--BOLD\").text.strip()\n",
    "         print(f\"Ebay Number: {ebay_no}\\n\")\n",
    "         ebay_number.append(ebay_no)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e6d01cd4",
   "metadata": {},
   "source": [
    "## Condition, Brand & Color\n",
    "\n",
    "* This code generates the Description of the Product followed by the Brand and the Color of the Product.\n",
    "* It uses the requests and BeautifulSoup libraries to scrape the webpages. The code first finds the section of the webpage that contains the product details, then extracts the product description, brand, and color using the find method. \n",
    "\n",
    "* If the color is not available, it adds \"Not Available\" to the color list. Finally, the extracted values are printed for each link, and added to the corresponding lists."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "ce783cde",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Agra Heritage Marble Crafts\n",
      "\n",
      "Color: Green\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Tabletopsemporium\n",
      "\n",
      "Color: As Photo\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: MoNiBloom\n",
      "\n",
      "Color: White\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: MoNiBloom\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: MegaHome\n",
      "\n",
      "Color: Dark Brown\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Does not apply\n",
      "\n",
      "Color: Two-tone\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: casanarco\n",
      "\n",
      "Color: full color art\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: casanarco\n",
      "\n",
      "Color: full color art\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Table\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: FCH\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Does not apply\n",
      "\n",
      "Color: Natural\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Does not apply\n",
      "\n",
      "Color: Red Mahogany Wood Grain\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Branded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: Used:\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: Used: An item that has been used previously. The item may have some signs of cosmetic wear but is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: MoNiBloom\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Herman Miller\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Does not apply\n",
      "\n",
      "Color: Farmhouse Brown\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: SoftTech\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: MPM\n",
      "\n",
      "Color: White\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Mainstays\n",
      "\n",
      "Color: Gray\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Handmade\n",
      "\n",
      "Color: Gold\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: Used: An item that has been used previously. The item may have some signs of cosmetic wear but is ...  Read moreabout the condition\n",
      "\n",
      "Brand: PHI VILLA\n",
      "\n",
      "Color: Wood\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: White\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: White\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: White\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Does not apply\n",
      "\n",
      "Color: Birch\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: White\n",
      "\n",
      "Product Desc: Used: An item that has been used previously. The item may have some signs of cosmetic wear but is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: Used: An item that has been used previously. The item may have some signs of cosmetic wear but is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Anderson Teak\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: Used: An item that has been used previously. The item may have some signs of cosmetic wear but is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Table\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: TAUS\n",
      "\n",
      "Color: Blue\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: FixtureDisplays\n",
      "\n",
      "Color: Mahogany\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Not Avilable\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: Unbranded\n",
      "\n",
      "Color: Black\n",
      "\n",
      "Product Desc: New: A brand-new unused unopened undamaged item in its original packaging (where packaging is ...  Read moreabout the condition\n",
      "\n",
      "Brand: HXL\n",
      "\n",
      "Color: White\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Product Condition, Brand and Color\n",
    "\n",
    "product_desc=[]\n",
    "brand=[]\n",
    "color = []\n",
    "\n",
    "for link in links:\n",
    "    page_urls = requests.get(link, headers=user_agent)\n",
    "    page_soup = BeautifulSoup(page_urls.content, features=\"html.parser\")\n",
    "    condition = page_soup.find_all(\"div\", class_=\"tab-content-m\")\n",
    "    for product_detail in condition:\n",
    "        desc = product_detail.find(\"div\", class_=\"ux-labels-values__values-content\").find(\"span\").text.strip().replace(\",\", \"\")\n",
    "        print(f\"Product Desc: {desc}\\n\")\n",
    "        product_desc.append(desc)\n",
    "        # Brand\n",
    "        prod_brand = product_detail.find(\"span\", itemprop = \"brand\").find(\"span\", class_=\"ux-textspans\").text.strip()    \n",
    "        print(f\"Brand: {prod_brand}\\n\")\n",
    "        brand.append(prod_brand)\n",
    "        \n",
    "        # Color\n",
    "        prod_color = product_detail.find(\"span\", itemprop = \"color\")\n",
    "        if prod_color is not None:\n",
    "            color_prod = prod_color.find(\"span\", class_=\"ux-textspans\").text.strip()\n",
    "            print(f\"Color: {color_prod}\\n\")\n",
    "            color.append(color_prod)\n",
    "        else:\n",
    "            print(\"Not Avilable\")\n",
    "            color.append(\"Not Available\")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c852227c",
   "metadata": {},
   "source": [
    "## Create a DataFrame and Generate the tsv file named 'tableDetails.tsv' as instructed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "bd05ce27",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Generate a DataFrame\n",
    "\n",
    "tableDetails = pd.DataFrame(product_titles, columns=[\"Product_Name\"])\n",
    "tableDetails[\"Return_Policy_1\"] = pd.Series(refund_policy1)\n",
    "tableDetails[\"Return_Policy_2\"] = pd.Series(refund_policy2)\n",
    "tableDetails[\"Return_Policy_3\"] = pd.Series(refund_policy3)\n",
    "tableDetails[\"Ships_To\"] = pd.Series(ships_to)\n",
    "tableDetails[\"Item_Location\"] = pd.Series(item_location)\n",
    "tableDetails[\"Shipping_Cost\"] = pd.Series(cost_of_shipping)\n",
    "tableDetails[\"Payment_Modes\"] = pd.Series(payment_types)\n",
    "tableDetails[\"Price\"] = pd.Series(price_of_product)\n",
    "\n",
    "tableDetails[\"eBay_Item_Number\"] = pd.Series(ebay_number)\n",
    "tableDetails[\"Condition\"] = pd.Series(product_desc)\n",
    "tableDetails[\"Brand\"] = pd.Series(brand)\n",
    "tableDetails[\"Color\"] = pd.Series(color)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "1627eb07",
   "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>Product_Name</th>\n",
       "      <th>Return_Policy_1</th>\n",
       "      <th>Return_Policy_2</th>\n",
       "      <th>Return_Policy_3</th>\n",
       "      <th>Ships_To</th>\n",
       "      <th>Item_Location</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Payment_Modes</th>\n",
       "      <th>Price</th>\n",
       "      <th>eBay_Item_Number</th>\n",
       "      <th>Condition</th>\n",
       "      <th>Brand</th>\n",
       "      <th>Color</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Malachite Round Top Coffee Table Top Semi Prec...</td>\n",
       "      <td>30 days</td>\n",
       "      <td>Money Back, Replacement</td>\n",
       "      <td>Seller pays for return shipping</td>\n",
       "      <td>Worldwide</td>\n",
       "      <td>AGRA, UTTAR PRADESH, India</td>\n",
       "      <td>Free shipping</td>\n",
       "      <td>[PayPal, Apple Pay, Google Pay, Visa, Master C...</td>\n",
       "      <td>US $333.00</td>\n",
       "      <td>125624687528</td>\n",
       "      <td>New: A brand-new unused unopened undamaged ite...</td>\n",
       "      <td>Agra Heritage Marble Crafts</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Live edge very old giant size, great shape, ol...</td>\n",
       "      <td>30 days</td>\n",
       "      <td>Money Back, Replacement</td>\n",
       "      <td>Seller pays for return shipping</td>\n",
       "      <td>Worldwide</td>\n",
       "      <td>AGRA, UTTAR PRADESH, India</td>\n",
       "      <td>Free shipping</td>\n",
       "      <td>[PayPal, Apple Pay, Google Pay, Visa, Master C...</td>\n",
       "      <td>US $704.96</td>\n",
       "      <td>125624687528</td>\n",
       "      <td>New: A brand-new unused unopened undamaged ite...</td>\n",
       "      <td>Tabletopsemporium</td>\n",
       "      <td>As Photo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Foldable Indoor Plastic Round Dining Table Por...</td>\n",
       "      <td>30 days</td>\n",
       "      <td>Money Back</td>\n",
       "      <td>Buyer pays for return shipping</td>\n",
       "      <td>Afghanistan Albania Algeria Andorra Angola Ang...</td>\n",
       "      <td>Houston, TX, United States</td>\n",
       "      <td>US $14.12</td>\n",
       "      <td>[PayPal, Apple Pay, Google Pay, Visa, Master C...</td>\n",
       "      <td>US $105.99/ea</td>\n",
       "      <td>114858552175</td>\n",
       "      <td>New: A brand-new unused unopened undamaged ite...</td>\n",
       "      <td>MoNiBloom</td>\n",
       "      <td>White</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Foldable Adjustable Height TV Tray Home Portab...</td>\n",
       "      <td>30 days</td>\n",
       "      <td>Money Back</td>\n",
       "      <td>Buyer pays for return shipping</td>\n",
       "      <td>Afghanistan Albania Algeria Andorra Angola Ang...</td>\n",
       "      <td>Houston, TX, United States</td>\n",
       "      <td>US $13.12</td>\n",
       "      <td>[PayPal, Apple Pay, Google Pay, Visa, Master C...</td>\n",
       "      <td>US $38.99/ea</td>\n",
       "      <td>114858552175</td>\n",
       "      <td>New: A brand-new unused unopened undamaged ite...</td>\n",
       "      <td>MoNiBloom</td>\n",
       "      <td>Not Available</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>End Table Espresso Storage Living Room Half Ro...</td>\n",
       "      <td>30 days</td>\n",
       "      <td>Money Back</td>\n",
       "      <td>Buyer pays for return shipping</td>\n",
       "      <td>Afghanistan Albania Algeria Andorra Angola Ang...</td>\n",
       "      <td>Englewood, Colorado, United States</td>\n",
       "      <td>US $203.98</td>\n",
       "      <td>[PayPal, Apple Pay, Google Pay, Visa, Master C...</td>\n",
       "      <td>US $55.15</td>\n",
       "      <td>134177164095</td>\n",
       "      <td>New: A brand-new unused unopened undamaged ite...</td>\n",
       "      <td>MegaHome</td>\n",
       "      <td>Dark Brown</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Product_Name Return_Policy_1  \\\n",
       "0  Malachite Round Top Coffee Table Top Semi Prec...         30 days   \n",
       "1  Live edge very old giant size, great shape, ol...         30 days   \n",
       "2  Foldable Indoor Plastic Round Dining Table Por...         30 days   \n",
       "3  Foldable Adjustable Height TV Tray Home Portab...         30 days   \n",
       "4  End Table Espresso Storage Living Room Half Ro...         30 days   \n",
       "\n",
       "           Return_Policy_2                  Return_Policy_3  \\\n",
       "0  Money Back, Replacement  Seller pays for return shipping   \n",
       "1  Money Back, Replacement  Seller pays for return shipping   \n",
       "2               Money Back   Buyer pays for return shipping   \n",
       "3               Money Back   Buyer pays for return shipping   \n",
       "4               Money Back   Buyer pays for return shipping   \n",
       "\n",
       "                                            Ships_To  \\\n",
       "0                                          Worldwide   \n",
       "1                                          Worldwide   \n",
       "2  Afghanistan Albania Algeria Andorra Angola Ang...   \n",
       "3  Afghanistan Albania Algeria Andorra Angola Ang...   \n",
       "4  Afghanistan Albania Algeria Andorra Angola Ang...   \n",
       "\n",
       "                        Item_Location  Shipping_Cost  \\\n",
       "0          AGRA, UTTAR PRADESH, India  Free shipping   \n",
       "1          AGRA, UTTAR PRADESH, India  Free shipping   \n",
       "2          Houston, TX, United States      US $14.12   \n",
       "3          Houston, TX, United States      US $13.12   \n",
       "4  Englewood, Colorado, United States     US $203.98   \n",
       "\n",
       "                                       Payment_Modes          Price  \\\n",
       "0  [PayPal, Apple Pay, Google Pay, Visa, Master C...     US $333.00   \n",
       "1  [PayPal, Apple Pay, Google Pay, Visa, Master C...     US $704.96   \n",
       "2  [PayPal, Apple Pay, Google Pay, Visa, Master C...  US $105.99/ea   \n",
       "3  [PayPal, Apple Pay, Google Pay, Visa, Master C...   US $38.99/ea   \n",
       "4  [PayPal, Apple Pay, Google Pay, Visa, Master C...      US $55.15   \n",
       "\n",
       "  eBay_Item_Number                                          Condition  \\\n",
       "0     125624687528  New: A brand-new unused unopened undamaged ite...   \n",
       "1     125624687528  New: A brand-new unused unopened undamaged ite...   \n",
       "2     114858552175  New: A brand-new unused unopened undamaged ite...   \n",
       "3     114858552175  New: A brand-new unused unopened undamaged ite...   \n",
       "4     134177164095  New: A brand-new unused unopened undamaged ite...   \n",
       "\n",
       "                         Brand          Color  \n",
       "0  Agra Heritage Marble Crafts          Green  \n",
       "1            Tabletopsemporium       As Photo  \n",
       "2                    MoNiBloom          White  \n",
       "3                    MoNiBloom  Not Available  \n",
       "4                     MegaHome     Dark Brown  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Preview the Dataset Created\n",
    "\n",
    "tableDetails.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "da9b7913",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the Data outside as tsv file\n",
    "tableDetails.to_csv(\"tableDetails.tsv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "e608fac1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/Users/mukulchauhan\n"
     ]
    }
   ],
   "source": [
    "cd"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}