LaptopsDirect Scraper.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Web Scraper To Generate Product Database From E-Commerce Site \n",
    "<p align = \"justified\"> This project is aimed to implement basic web scraping using Python's BeautifulSoup library to create an informative dataset of available products. The e-commerce website targetted in the notebook is laptopsdirect.uk, with primary focus on the available laptops being sold. The project is divided into two parts - the first part scrapes only the first result page of the concerned product while the second part fetches all the available results from multiple pages. The scraped data is formatted using pandas library and exported in .xlsx format. </p>   \n",
    "\n",
    "The following data points were fetched in this project:\n",
    "* Product Name\n",
    "* Price\n",
    "* Rating\n",
    "* Review Count\n",
    "* Product Details\n",
    "* Relative URL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup             #Importing necessary Libraries\n",
    "import requests\n",
    "import pandas as pd\n",
    "import urllib.parse"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Part 1 - Scraping the First Result Page\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "website  = \"https://www.laptopsdirect.co.uk/st/new-laptops\"   #Storing Website's target URL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "response = requests.get(website)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response.status_code   #Check HTTP Status"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(response.content, 'html.parser')           #Creating a Soup object for scraping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = soup.find_all('div', {'class': 'OfferBox'})                  #storing the first page's target results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(results)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<div class=\"OfferBox\">\n",
       "<div class=\"merchTopofCentreColumn top5icon\" onload=\"dataLayer.push({'event':'top5IconShown'});\" style=\"display:none; z-index: 20; position: absolute; top: 50px; left: 10px; cursor: pointer;  pointer-events: none; width: 70px;\">\n",
       "<img alt=\"Top 5\" border=\"0\" src=\"https://www.appliancesdirect.co.uk/images/top5-apd.png\">\n",
       "</img></div>\n",
       "<div class=\"sr_image\">\n",
       "<div class=\"sr_compare\">\n",
       "<div class=\"sli_compare\" id=\"1573430_compare\">\n",
       "<input class=\"compare\" onclick=\"AddRemoveFromProductCompareCookie(this, event);\" type=\"checkbox\" value=\"1573430\"/>\n",
       "<input id=\"comphid_1573430\" type=\"hidden\" value=\"Laptops\">\n",
       "<span class=\"compareText\">Compare</span>\n",
       "</input></div>\n",
       "<div class=\"comparedialog\" id=\"msg_1573430\" style=\"display:none;\" title=\"Compare products\">\n",
       "<p>Sorry, you can only compare a maximum of 4 items per category.</p>\n",
       "</div>\n",
       "<div class=\"compBtn\" id=\"compBtn_1573430\">\n",
       "<a href=\"/Compare\" type=\"button\">Compare products »</a>\n",
       "</div>\n",
       "</div>\n",
       "<a href=\"/acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp\" onclick=\"EnEcomProdClick('NX.HSLEK.007', 'acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp', '2');\" title=\"Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15.6 Inch Windows 10 Home Laptop\">\n",
       "<img alt=\"Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15.6 Inch Windows 10 Home Laptop\" border=\"0\" class=\"offerImage\" id=\"productImage_1573430\" pid=\"1573430\" src=\"/Images/NX.HSLEK.007_1_Classic.jpg?v=24&amp;width=200&amp;height=200&amp;switchoff=enabled\" title=\"Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15.6 Inch Windows 10 Home Laptop\"/>\n",
       "</a>\n",
       "<div class=\"merchTopofCentreColumn plogo plogo-acer\" style=\"\">\n",
       "<img border=\"0\" src=\"/files/images/logo-acer.png\"/>\n",
       "</div>\n",
       "</div>\n",
       "<div class=\"OfferBoxProdInfo\">\n",
       "<div class=\"OfferBoxTitle\">\n",
       "<h3>\n",
       "<a class=\"offerboxtitle\" href=\"/acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp\" onclick=\"EnEcomProdClick('NX.HSLEK.007', 'acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp', '2');\" title=\"Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15.6 Inch Windows 10 Home Laptop - NX.HSLEK.007\">Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15.6 Inch Windows 10 Home Laptop - NX.HSLEK.007</a>\n",
       "</h3>\n",
       "<star-rating product-url=\"acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp\" rating-value=\"8.5\" ratings-count=\"2\"></star-rating>\n",
       "<wishlist-amend currency=\"GBP\" exvatprice=\"483.31\" multiple-mode=\"true\" productavailable=\"true\" productid=\"1573430\" siteid=\"3\" vatrate=\"1.200\"></wishlist-amend>\n",
       "</div>\n",
       "<div class=\"productInfo\" id=\"productInfo_1573430\">\n",
       "<ul>\n",
       "<li><span class=\"proddescvalue\">Intel Core i5 1035G1</span> <span class=\"proddesctitle\">Processor</span></li>\n",
       "<li><span class=\"proddescvalue\">UHD Graphics 620</span> <span class=\"proddesctitle\">Graphics card</span></li>\n",
       "<li><span class=\"proddescvalue\">15.6 Inch Full HD Screen</span></li>\n",
       "<li><span class=\"proddescvalue\">8GB</span> <span class=\"proddesctitle\">RAM</span></li>\n",
       "<li><span class=\"proddescvalue\">512GB</span> <span class=\"proddesctitle\">SSD</span></li>\n",
       "</ul>\n",
       "</div>\n",
       "<div class=\"merchTopofCentreColumn searchicon-laptops\" style=\"\">\n",
       "<img alt=\"Intel Laptop Icon Test\" border=\"0\" src=\"/files/images/ld/558949_942Icons_Intel_101519.png\"/>\n",
       "</div>\n",
       "<div class=\"merchTopofCentreColumn searchicon-laptops\" style=\"\">\n",
       "<img alt=\"Thin and Light icon test\" border=\"0\" src=\"/files/images/ld/Lightweight-Icon.png\"/>\n",
       "</div>\n",
       "<div class=\"merchTopofCentreColumn searchicon-laptops\" style=\"\">\n",
       "<img alt=\"usb c icon test\" border=\"0\" src=\"/files/images/ld/USB-C-Iconnew.png\"/>\n",
       "</div>\n",
       "<div class=\"merchTopofCentreColumn searchicon-laptops\" style=\"\">\n",
       "<img alt=\"hdmi icon laptop test\" border=\"0\" src=\"/files/images/ld/HDMI2.png\"/>\n",
       "</div>\n",
       "</div>\n",
       "<div class=\"OfferBoxPrice\">\n",
       "<div class=\"accpricemsgs\">\n",
       "</div>\n",
       "<span class=\"offerpricetext\">Only </span>\n",
       "<span class=\"offerprice\">£579.97<span class=\"tilesUnitText\"></span></span>\n",
       "<div class=\"accpricemsgs\">\n",
       "</div>\n",
       "<a class=\"finance\" onclick=\"ga('send', 'event', 'product page', 'Pay Later');\">\n",
       "<span class=\"financemessage\">or </span>\n",
       "<span class=\"financeprice\">£19.82 a month</span>\n",
       "<span class=\"paypal-credit-ab-test-show\"><span class=\"paypalcredit-srtext\">0% finance available <span class=\"paypal-credit-logo\"></span></span></span>\n",
       "</a>\n",
       "<div class=\"Availability\" id=\"availability_1573430\"></div>\n",
       "<a class=\"offerboxlink btn-prime\" href=\"/acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp\" onclick=\"document.location.href='/acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp'; EnEcomProdClick('NX.HSLEK.007', 'acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp', '2'); return false;\" title=\"Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15.6 Inch Windows 10 Home Laptop\">Find Out More</a>\n",
       "<div class=\"quickview\">\n",
       "<a class=\"dialoganchor btn-second\" id=\"alink_1573430\" onclick=\"CaptureProductClick(69364,1573430,8,24,1,2,20) ; ga('send', 'event', 'QuickView', 'quick view – view', 'NX.HSLEK.007');\" style=\"cursor:pointer\">Quick View</a>\n",
       "</div>\n",
       "</div>\n",
       "<script type=\"text/javascript\">\n",
       "            $(function () {\n",
       "                if ('False' == 'True') {\n",
       "                    //get the keywords for videos\n",
       "                    GetKeywordsForSearchPage('1573430')\n",
       "                }\n",
       "            });\n",
       "        </script>\n",
       "</div>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results[0]                           #Checking the first "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15.6 Inch Windows 10 Home Laptop - NX.HSLEK.007'"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results[0].find('a', {'class':'offerboxtitle'}).get_text()         #finding the product name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'£579.97'"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results[0].find('span', {'class':'offerprice'}).get_text()         #finding the product price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'8.5'"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results[0].find('star-rating').get('rating-value')                 #finding the rating value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2'"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results[0].find('star-rating').get('ratings-count')                #Counting number of reviews"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "relative_url = results[0].find('a', {'class':'offerboxtitle'}).get('href')    #fetching relative URL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "root_url = 'https://www.laptopsdirect.co.uk'\n",
    "url_combine = root_url + relative_url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://www.laptopsdirect.co.uk/acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp'"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url_combine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Intel Core i5 1035G1 Processor, UHD Graphics 620 Graphics card, 15.6 Inch Full HD Screen, 8GB RAM, 512GB SSD'"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results[0].find('div', {'class': 'productInfo'}).get_text().strip().replace('\\n', ', ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_name = []\n",
    "product_price = []\n",
    "review_rating = []\n",
    "review_count = []\n",
    "relative_url = []\n",
    "product_details = []\n",
    "\n",
    "for result in results:\n",
    "    \n",
    "    #Product Name    \n",
    "    try:\n",
    "        product_name.append(result.find('a', {'class':'offerboxtitle'}).get_text())\n",
    "    except:\n",
    "        product_name.append('NA')\n",
    "    \n",
    "    #Product Price    \n",
    "    try:\n",
    "        product_price.append(result.find('span', {'class':'offerprice'}).get_text())\n",
    "    except:\n",
    "        product_price.append('NA')\n",
    "        \n",
    "    #Product Rating    \n",
    "    try:\n",
    "        review_rating.append(result.find('star-rating').get('rating-value'))\n",
    "    except:\n",
    "        review_rating.append('NA')\n",
    "        \n",
    "    #Review Count\n",
    "    try:\n",
    "        review_count.append(result.find('star-rating').get('ratings-count'))\n",
    "    except:\n",
    "        review_count.append('NA') \n",
    "        \n",
    "    #Relative URL\n",
    "    try:\n",
    "        relative_url.append(result.find('a', {'class':'offerboxtitle'}).get('href'))\n",
    "    except:\n",
    "        relative_url.append('NA') \n",
    "        \n",
    "    #Product Details\n",
    "    try:\n",
    "        product_details.append(result.find('div', {'class': 'productInfo'}).get_text().strip().replace('\\n', ', '))\n",
    "    except:\n",
    "        product_details.append('NA') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_combined = []\n",
    "for link in relative_url:\n",
    "    url_combined.append(urllib.parse.urljoin(root_url, link))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.laptopsdirect.co.uk/acer-aspire-5-core-i5-1035g1-8gb-512gb-ssd-15.6-inch-windows-10-laptop-nx.hslek.007/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/-core-i5-1035g1-8gb-256gb-ssd-15.6-inch-windows-10-laptop-30030444/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/asus-c223na-intel-celeron-n3350-4gb-32gb-emmc-11.6-inch-windows-10-chromebo-c223na-gj0040/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/coda-1.2-intel-celeron-n4020-4gb-64gb-emmc-12.5-inch-windows-10-laptop-inc-coda037/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/-c523na-br0067/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/lenovo-v14-ada-amd-ryzen-3-3250u-8-gb-ram-256-gb-ssd-14-inch-windows-home-1-82c6006cuk/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/dell-latitude-3520-core-i5-1135g7-8gb-256gb-ssd-15.6-inch-fhd-windows-10-pr-thy6r/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/lenovo-v15-iil-core-i5-1035u-8gb-256gb-ssd-15.6-inch-fhd-windows-10-laptop-82c50075uk/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/asus-core-i3-1005g1-8gb-256gb-ssd-14-inch-windows-10-laptop-s413ja-am495t/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/acer-swift-3-sf313-53-core-i7-1165g7-8gb-512gb-ssd-13.5-inch-qhd-windows-10-nx.a4kek.003/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/medion-deputy-p10-core-i5-10300h-16gb-512gb-ssd-15.6-inch-geforce-gtx-1660-30029473/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/hp-255-g8-amd-ryzen-5-3500u-8gb-256gb-ssd-15-inch-windows-10-laptop-2e9j2ea/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/asus-vivobook-x712ja-core-i3-1005g1-8gb-1tb-17.3-inch-windows-10-laptop-x712ja-bx353t/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/hp-250-g8-core-i7-1065g7-8gb-256gb-ssd-15.6-inch-windows-10-pro-laptop-2e9j1ea/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/lenovo-thinkbook-15-core-i5-10350u-8gb-256gb-ssd-15.6-inch-fhd-windows-10-p-20sm000fuk/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/hp-probook-450-g8-core-i5-1135g7-8gb-256gb-ssd-15.6-inch-fhd-windows-10-pro-2x7u1ea/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/lenovo-l340-core-i5-9300h-8gb-256gb-ssd-15.6-inch-geforce-gtx-1650-windows-81lk01pruk/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/asus-vivobook-core-i5-1035g1-8gb-256gb-ssd-14-inch-windows-10-laptop-x413ja-eb249t/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/dell-latitude-3510-i5-10210u-vcfvm/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/lenovo-legion-5-amd-ryzen-5-5600h-8gb-512gb-ssd-15.6-inch-fhd-geforce-rtx-3-82ju002xuk/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/acer-travelmate-p2-p215-52-72cv-core-i7-10510u-8gb-512gb-ssd-15.-6-inch-win-nx.vllek.006/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/lenovo-ideapad-l340-17-core-i5-9300hf-8gb-256gb-ssd-nvidia-geforce-gtx-1650-81ll00kwuk/version.asp',\n",
       " 'https://www.laptopsdirect.co.uk/asus-vivobook-d413ia-ryzen-7-4700u-8gb-512gb-14-inch-windows-10-pro-laptop-d413ia-ek894r/version.asp']"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url_combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_overview = pd.DataFrame({'Name': product_name, 'Price': product_price, 'Rating': review_rating, 'Review Count': review_count, 'Link': url_combined, 'Details': product_details})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "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>Name</th>\n",
       "      <th>Price</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Review Count</th>\n",
       "      <th>Link</th>\n",
       "      <th>Details</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15....</td>\n",
       "      <td>£579.97</td>\n",
       "      <td>8.5</td>\n",
       "      <td>2</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/acer-aspire-5-...</td>\n",
       "      <td>Intel Core i5 1035G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Medion Akoya E15407 Core i5-1035G1 8GB 256GB S...</td>\n",
       "      <td>£459.97</td>\n",
       "      <td>8</td>\n",
       "      <td>42</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/-core-i5-1035g...</td>\n",
       "      <td>Intel Core i5 1035G1 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Asus C223NA Intel Celeron N3350 4GB 32GB eMMC ...</td>\n",
       "      <td>£179.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-c223na-in...</td>\n",
       "      <td>Intel Celeron N3350 Processor, 11.6 Inch 1366 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CODA 1.2 Intel Celeron N4020 4GB 64GB eMMC 12....</td>\n",
       "      <td>£199.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/coda-1.2-intel...</td>\n",
       "      <td>Intel Celeron N4020 Processor, UHD Graphics 62...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Asus C523 Intel Celeron N3350 4GB 64GB eMMC 15...</td>\n",
       "      <td>£227.97</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/-c523na-br0067...</td>\n",
       "      <td>Intel Celeron N3350 Processor, 15.6 Inch 1366 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Lenovo V14-ADA AMD Ryzen 3 3250U 8GB 256GB SSD...</td>\n",
       "      <td>£399.97</td>\n",
       "      <td>8.8</td>\n",
       "      <td>25</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-v14-ada...</td>\n",
       "      <td>AMD Ryzen 3 3250U Processor, Radeon Graphics G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Dell Latitude 3520 Core i5-1135G7 8GB 256GB SS...</td>\n",
       "      <td>£719.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/dell-latitude-...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lenovo V15-IIL Core i5-1035G1 8GB 256GB SSD 15...</td>\n",
       "      <td>£549.97</td>\n",
       "      <td>8.7</td>\n",
       "      <td>903</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-v15-iil...</td>\n",
       "      <td>Intel Core i5 1035G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Asus Vivobook14 Core i3-1005G1 8GB 256GB SSD 1...</td>\n",
       "      <td>£399.97</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-core-i3-1...</td>\n",
       "      <td>Intel Core i3 1005G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Acer Swift 3 SF313-53 Core i7-1165G7 8GB 512GB...</td>\n",
       "      <td>£882.97</td>\n",
       "      <td>9.8</td>\n",
       "      <td>4</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/acer-swift-3-s...</td>\n",
       "      <td>Intel Core i7 1165G7 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Medion Deputy P10 Core i5-10300H 16GB 512GB SS...</td>\n",
       "      <td>£699.97</td>\n",
       "      <td>9.2</td>\n",
       "      <td>23</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/medion-deputy-...</td>\n",
       "      <td>Intel Core i5 10300H Processor, GeForce GTX 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>HP 255 G8 AMD Ryzen 5-3500U 8GB 256GB SSD 15 I...</td>\n",
       "      <td>£509.97</td>\n",
       "      <td>8.5</td>\n",
       "      <td>10</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/hp-255-g8-amd-...</td>\n",
       "      <td>AMD Ryzen 5 3500U Processor, Radeon Graphics G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ASUS Vivobook X712JA Core i3-1005G1 8GB 1TB 17...</td>\n",
       "      <td>£419.97</td>\n",
       "      <td>6.5</td>\n",
       "      <td>11</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-vivobook-...</td>\n",
       "      <td>Intel Core i3 1005G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>HP 250 G8 Core i7-1065G7 8GB 256GB SSD 15.6 In...</td>\n",
       "      <td>£759.97</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/hp-250-g8-core...</td>\n",
       "      <td>Intel Core i7 I7-1065G7 Processor, UHD Graphic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Lenovo ThinkBook 15 Core i5-1035G1 8GB 256GB S...</td>\n",
       "      <td>£688.97</td>\n",
       "      <td>8.8</td>\n",
       "      <td>102</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-thinkbo...</td>\n",
       "      <td>Intel Core i5 I5-1035G1 Processor, Iris Xe Gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>HP ProBook 450 G8 Core i5-1135G7 8GB 256GB SSD...</td>\n",
       "      <td>£799.97</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/hp-probook-450...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Lenovo IdeaPad L340 Core i5-9300H 8GB 256GB SS...</td>\n",
       "      <td>£579.97</td>\n",
       "      <td>8.9</td>\n",
       "      <td>38</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-l340-co...</td>\n",
       "      <td>Intel Core i5 9300HF Processor, GeForce GTX 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Asus Vivobook Core i5-1035G1 8GB 256GB SSD 14 ...</td>\n",
       "      <td>£469.97</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-vivobook-...</td>\n",
       "      <td>Intel Core i5 I5-1035G1 Processor, UHD Graphic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Dell Latitude 3510 Core i5-10210U 8GB 256GB SS...</td>\n",
       "      <td>£709.97</td>\n",
       "      <td>8.7</td>\n",
       "      <td>22</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/dell-latitude-...</td>\n",
       "      <td>Intel Core i5 10210U Processor, 15.6 Inch Full...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Lenovo Legion 5 AMD Ryzen 5 15.6 Inch Full HD ...</td>\n",
       "      <td>£899.97</td>\n",
       "      <td>9.2</td>\n",
       "      <td>70</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-legion-...</td>\n",
       "      <td>AMD Ryzen 5 5600H Processor, GeForce RTX 3060 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Acer TravelMate P2 P215-52-72CV Core i7-10510U...</td>\n",
       "      <td>£699.97</td>\n",
       "      <td>9.1</td>\n",
       "      <td>44</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/acer-travelmat...</td>\n",
       "      <td>Intel Core i7 10510U Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Lenovo IdeaPad L340-17 Core i5-9300HF 8GB 256G...</td>\n",
       "      <td>£824.97</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-ideapad...</td>\n",
       "      <td>Intel Core i5 9300HF Processor, GeForce GTX 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ASUS Vivobook D413IA Ryzen 7-4700U 8GB 512GB 1...</td>\n",
       "      <td>£599.97</td>\n",
       "      <td>9.8</td>\n",
       "      <td>4</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-vivobook-...</td>\n",
       "      <td>AMD Ryzen 7 4700U Processor, Radeon Graphics G...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Name    Price Rating  \\\n",
       "0   Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15....  £579.97    8.5   \n",
       "1   Medion Akoya E15407 Core i5-1035G1 8GB 256GB S...  £459.97      8   \n",
       "2   Asus C223NA Intel Celeron N3350 4GB 32GB eMMC ...  £179.97     NA   \n",
       "3   CODA 1.2 Intel Celeron N4020 4GB 64GB eMMC 12....  £199.97     NA   \n",
       "4   Asus C523 Intel Celeron N3350 4GB 64GB eMMC 15...  £227.97      9   \n",
       "5   Lenovo V14-ADA AMD Ryzen 3 3250U 8GB 256GB SSD...  £399.97    8.8   \n",
       "6   Dell Latitude 3520 Core i5-1135G7 8GB 256GB SS...  £719.97     NA   \n",
       "7   Lenovo V15-IIL Core i5-1035G1 8GB 256GB SSD 15...  £549.97    8.7   \n",
       "8   Asus Vivobook14 Core i3-1005G1 8GB 256GB SSD 1...  £399.97     10   \n",
       "9   Acer Swift 3 SF313-53 Core i7-1165G7 8GB 512GB...  £882.97    9.8   \n",
       "10  Medion Deputy P10 Core i5-10300H 16GB 512GB SS...  £699.97    9.2   \n",
       "11  HP 255 G8 AMD Ryzen 5-3500U 8GB 256GB SSD 15 I...  £509.97    8.5   \n",
       "12  ASUS Vivobook X712JA Core i3-1005G1 8GB 1TB 17...  £419.97    6.5   \n",
       "13  HP 250 G8 Core i7-1065G7 8GB 256GB SSD 15.6 In...  £759.97      8   \n",
       "14  Lenovo ThinkBook 15 Core i5-1035G1 8GB 256GB S...  £688.97    8.8   \n",
       "15  HP ProBook 450 G8 Core i5-1135G7 8GB 256GB SSD...  £799.97    9.7   \n",
       "16  Lenovo IdeaPad L340 Core i5-9300H 8GB 256GB SS...  £579.97    8.9   \n",
       "17  Asus Vivobook Core i5-1035G1 8GB 256GB SSD 14 ...  £469.97      9   \n",
       "18  Dell Latitude 3510 Core i5-10210U 8GB 256GB SS...  £709.97    8.7   \n",
       "19  Lenovo Legion 5 AMD Ryzen 5 15.6 Inch Full HD ...  £899.97    9.2   \n",
       "20  Acer TravelMate P2 P215-52-72CV Core i7-10510U...  £699.97    9.1   \n",
       "21  Lenovo IdeaPad L340-17 Core i5-9300HF 8GB 256G...  £824.97      8   \n",
       "22  ASUS Vivobook D413IA Ryzen 7-4700U 8GB 512GB 1...  £599.97    9.8   \n",
       "\n",
       "   Review Count                                               Link  \\\n",
       "0             2  https://www.laptopsdirect.co.uk/acer-aspire-5-...   \n",
       "1            42  https://www.laptopsdirect.co.uk/-core-i5-1035g...   \n",
       "2            NA  https://www.laptopsdirect.co.uk/asus-c223na-in...   \n",
       "3            NA  https://www.laptopsdirect.co.uk/coda-1.2-intel...   \n",
       "4            11  https://www.laptopsdirect.co.uk/-c523na-br0067...   \n",
       "5            25  https://www.laptopsdirect.co.uk/lenovo-v14-ada...   \n",
       "6            NA  https://www.laptopsdirect.co.uk/dell-latitude-...   \n",
       "7           903  https://www.laptopsdirect.co.uk/lenovo-v15-iil...   \n",
       "8             2  https://www.laptopsdirect.co.uk/asus-core-i3-1...   \n",
       "9             4  https://www.laptopsdirect.co.uk/acer-swift-3-s...   \n",
       "10           23  https://www.laptopsdirect.co.uk/medion-deputy-...   \n",
       "11           10  https://www.laptopsdirect.co.uk/hp-255-g8-amd-...   \n",
       "12           11  https://www.laptopsdirect.co.uk/asus-vivobook-...   \n",
       "13            1  https://www.laptopsdirect.co.uk/hp-250-g8-core...   \n",
       "14          102  https://www.laptopsdirect.co.uk/lenovo-thinkbo...   \n",
       "15            3  https://www.laptopsdirect.co.uk/hp-probook-450...   \n",
       "16           38  https://www.laptopsdirect.co.uk/lenovo-l340-co...   \n",
       "17            2  https://www.laptopsdirect.co.uk/asus-vivobook-...   \n",
       "18           22  https://www.laptopsdirect.co.uk/dell-latitude-...   \n",
       "19           70  https://www.laptopsdirect.co.uk/lenovo-legion-...   \n",
       "20           44  https://www.laptopsdirect.co.uk/acer-travelmat...   \n",
       "21            1  https://www.laptopsdirect.co.uk/lenovo-ideapad...   \n",
       "22            4  https://www.laptopsdirect.co.uk/asus-vivobook-...   \n",
       "\n",
       "                                              Details  \n",
       "0   Intel Core i5 1035G1 Processor, UHD Graphics 6...  \n",
       "1   Intel Core i5 1035G1 Processor, Iris Xe Graphi...  \n",
       "2   Intel Celeron N3350 Processor, 11.6 Inch 1366 ...  \n",
       "3   Intel Celeron N4020 Processor, UHD Graphics 62...  \n",
       "4   Intel Celeron N3350 Processor, 15.6 Inch 1366 ...  \n",
       "5   AMD Ryzen 3 3250U Processor, Radeon Graphics G...  \n",
       "6   Intel Core i5 1135G7 Processor, UHD Graphics 6...  \n",
       "7   Intel Core i5 1035G1 Processor, UHD Graphics 6...  \n",
       "8   Intel Core i3 1005G1 Processor, UHD Graphics 6...  \n",
       "9   Intel Core i7 1165G7 Processor, Iris Xe Graphi...  \n",
       "10  Intel Core i5 10300H Processor, GeForce GTX 16...  \n",
       "11  AMD Ryzen 5 3500U Processor, Radeon Graphics G...  \n",
       "12  Intel Core i3 1005G1 Processor, UHD Graphics 6...  \n",
       "13  Intel Core i7 I7-1065G7 Processor, UHD Graphic...  \n",
       "14  Intel Core i5 I5-1035G1 Processor, Iris Xe Gra...  \n",
       "15  Intel Core i5 1135G7 Processor, UHD Graphics 6...  \n",
       "16  Intel Core i5 9300HF Processor, GeForce GTX 16...  \n",
       "17  Intel Core i5 I5-1035G1 Processor, UHD Graphic...  \n",
       "18  Intel Core i5 10210U Processor, 15.6 Inch Full...  \n",
       "19  AMD Ryzen 5 5600H Processor, GeForce RTX 3060 ...  \n",
       "20  Intel Core i7 10510U Processor, UHD Graphics 6...  \n",
       "21  Intel Core i5 9300HF Processor, GeForce GTX 16...  \n",
       "22  AMD Ryzen 7 4700U Processor, Radeon Graphics G...  "
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product_overview"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_overview.to_excel(\"ResultSingle.xlsx\", index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Part 2 -  Scraping Multiple Result Pages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_name = []\n",
    "product_price = []\n",
    "review_rating = []\n",
    "review_count = []\n",
    "relative_url = []\n",
    "product_details = []\n",
    "\n",
    "for i in range(1, 21):\n",
    "        website = \"https://www.laptopsdirect.co.uk/st/new-laptops?pageNumber=\" + str(i)\n",
    "        response = requests.get(website)\n",
    "        soup = BeautifulSoup(response.content, 'html.parser')\n",
    "        results = soup.find_all('div', {'class': 'OfferBox'})\n",
    "        for result in results:\n",
    "            \n",
    "            try:\n",
    "                product_name.append(result.find('a', {'class':'offerboxtitle'}).get_text())\n",
    "            except:\n",
    "                product_name.append('NA')\n",
    "\n",
    "            #Product Price    \n",
    "            try:\n",
    "                product_price.append(result.find('span', {'class':'offerprice'}).get_text())\n",
    "            except:\n",
    "                product_price.append('NA')\n",
    "\n",
    "            #Product Rating    \n",
    "            try:\n",
    "                review_rating.append(result.find('star-rating').get('rating-value'))\n",
    "            except:\n",
    "                review_rating.append('NA')\n",
    "\n",
    "            #Review Count\n",
    "            try:\n",
    "                review_count.append(result.find('star-rating').get('ratings-count'))\n",
    "            except:\n",
    "                review_count.append('NA') \n",
    "\n",
    "            #Relative URL\n",
    "            try:\n",
    "                relative_url.append(result.find('a', {'class':'offerboxtitle'}).get('href'))\n",
    "            except:\n",
    "                relative_url.append('NA') \n",
    "\n",
    "            #Product Details\n",
    "            try:\n",
    "                product_details.append(result.find('div', {'class': 'productInfo'}).get_text().strip().replace('\\n', ', '))\n",
    "            except:\n",
    "                product_details.append('NA') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_combined = []\n",
    "for link in relative_url:\n",
    "    url_combined.append(urllib.parse.urljoin(root_url, link))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_overview = pd.DataFrame({'Name': product_name, 'Price': product_price, 'Rating': review_rating, 'Review Count': review_count, 'Link': url_combined, 'Details': product_details})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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>Name</th>\n",
       "      <th>Price</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Review Count</th>\n",
       "      <th>Link</th>\n",
       "      <th>Details</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15....</td>\n",
       "      <td>£579.97</td>\n",
       "      <td>8.5</td>\n",
       "      <td>2</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/acer-aspire-5-...</td>\n",
       "      <td>Intel Core i5 1035G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Dell Latitude 3520 Core i5-1135G7 8GB 256GB SS...</td>\n",
       "      <td>£719.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/dell-latitude-...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Medion Akoya E15407 Core i5-1035G1 8GB 256GB S...</td>\n",
       "      <td>£459.97</td>\n",
       "      <td>8</td>\n",
       "      <td>42</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/-core-i5-1035g...</td>\n",
       "      <td>Intel Core i5 1035G1 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Asus C223NA Intel Celeron N3350 4GB 32GB eMMC ...</td>\n",
       "      <td>£179.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-c223na-in...</td>\n",
       "      <td>Intel Celeron N3350 Processor, 11.6 Inch 1366 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CODA 1.2 Intel Celeron N4020 4GB 64GB eMMC 12....</td>\n",
       "      <td>£199.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/coda-1.2-intel...</td>\n",
       "      <td>Intel Celeron N4020 Processor, UHD Graphics 62...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Asus C523 Intel Celeron N3350 4GB 64GB eMMC 15...</td>\n",
       "      <td>£227.97</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/-c523na-br0067...</td>\n",
       "      <td>Intel Celeron N3350 Processor, 15.6 Inch 1366 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Lenovo V14-ADA AMD Ryzen 3 3250U 8GB 256GB SSD...</td>\n",
       "      <td>£399.97</td>\n",
       "      <td>8.8</td>\n",
       "      <td>25</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-v14-ada...</td>\n",
       "      <td>AMD Ryzen 3 3250U Processor, Radeon Graphics G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lenovo V15-IIL Core i5-1035G1 8GB 256GB SSD 15...</td>\n",
       "      <td>£549.97</td>\n",
       "      <td>8.7</td>\n",
       "      <td>903</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-v15-iil...</td>\n",
       "      <td>Intel Core i5 1035G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Asus Vivobook14 Core i3-1005G1 8GB 256GB SSD 1...</td>\n",
       "      <td>£399.97</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-core-i3-1...</td>\n",
       "      <td>Intel Core i3 1005G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Lenovo V15 Althlon Silver 3050U 4GB 128GB SSD ...</td>\n",
       "      <td>£299.97</td>\n",
       "      <td>8.7</td>\n",
       "      <td>903</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-v15-alt...</td>\n",
       "      <td>Athlon Silver 3050U Processor, Radeon Graphics...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>HP 255 G8 AMD Ryzen 5-3500U 8GB 256GB SSD 15 I...</td>\n",
       "      <td>£509.97</td>\n",
       "      <td>8.5</td>\n",
       "      <td>10</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/hp-255-g8-amd-...</td>\n",
       "      <td>AMD Ryzen 5 3500U Processor, Radeon Graphics G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Medion Deputy P10 Core i5-10300H 16GB 512GB SS...</td>\n",
       "      <td>£699.97</td>\n",
       "      <td>9.2</td>\n",
       "      <td>23</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/medion-deputy-...</td>\n",
       "      <td>Intel Core i5 10300H Processor, GeForce GTX 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Acer Swift 3 SF313-53 Core i7-1165G7 8GB 512GB...</td>\n",
       "      <td>£882.97</td>\n",
       "      <td>9.8</td>\n",
       "      <td>4</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/acer-swift-3-s...</td>\n",
       "      <td>Intel Core i7 1165G7 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ASUS Vivobook X712JA Core i3-1005G1 8GB 1TB 17...</td>\n",
       "      <td>£419.97</td>\n",
       "      <td>6.5</td>\n",
       "      <td>11</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-vivobook-...</td>\n",
       "      <td>Intel Core i3 1005G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Lenovo ThinkBook 15 Core i5-1035G1 8GB 256GB S...</td>\n",
       "      <td>£688.97</td>\n",
       "      <td>8.8</td>\n",
       "      <td>102</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-thinkbo...</td>\n",
       "      <td>Intel Core i5 I5-1035G1 Processor, Iris Xe Gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Lenovo IdeaPad L340 Core i5-9300H 8GB 256GB SS...</td>\n",
       "      <td>£579.97</td>\n",
       "      <td>8.9</td>\n",
       "      <td>38</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-l340-co...</td>\n",
       "      <td>Intel Core i5 9300HF Processor, GeForce GTX 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>HP 250 G8 Core i7-1065G7 8GB 256GB SSD 15.6 In...</td>\n",
       "      <td>£759.97</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/hp-250-g8-core...</td>\n",
       "      <td>Intel Core i7 I7-1065G7 Processor, UHD Graphic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>HP ProBook 450 G8 Core i5-1135G7 8GB 256GB SSD...</td>\n",
       "      <td>£814.97</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/hp-probook-450...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Asus Vivobook Core i5-1035G1 8GB 256GB SSD 14 ...</td>\n",
       "      <td>£469.97</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-vivobook-...</td>\n",
       "      <td>Intel Core i5 I5-1035G1 Processor, UHD Graphic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Dell Latitude 3510 Core i5-10210U 8GB 256GB SS...</td>\n",
       "      <td>£709.97</td>\n",
       "      <td>8.7</td>\n",
       "      <td>22</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/dell-latitude-...</td>\n",
       "      <td>Intel Core i5 10210U Processor, 15.6 Inch Full...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Lenovo Legion 5 AMD Ryzen 5 15.6 Inch Full HD ...</td>\n",
       "      <td>£899.97</td>\n",
       "      <td>9.2</td>\n",
       "      <td>70</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-legion-...</td>\n",
       "      <td>AMD Ryzen 5 5600H Processor, GeForce RTX 3060 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>ASUS VivoBook S513EA Core i7-1165G7 16GB 1TB S...</td>\n",
       "      <td>£799.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-vivobook-...</td>\n",
       "      <td>Intel Core i7 1165G7 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Acer TravelMate P2 P215-52-72CV Core i7-10510U...</td>\n",
       "      <td>£699.97</td>\n",
       "      <td>9.1</td>\n",
       "      <td>44</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/acer-travelmat...</td>\n",
       "      <td>Intel Core i7 10510U Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>HP ZBook Firefly 15 G7 Core i7-10510U 16GB 512...</td>\n",
       "      <td>£1449.97</td>\n",
       "      <td>9.2</td>\n",
       "      <td>6</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/hp-zbook-firef...</td>\n",
       "      <td>Intel Core i7 10510U Processor, Quadro P520 4G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>ASUS Vivobook D413IA Ryzen 7-4700U 8GB 512GB 1...</td>\n",
       "      <td>£599.97</td>\n",
       "      <td>9.8</td>\n",
       "      <td>4</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-vivobook-...</td>\n",
       "      <td>AMD Ryzen 7 4700U Processor, Radeon Graphics G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Lenovo V15-IIL Core i5-1035G1 8GB 256GB SSD 15...</td>\n",
       "      <td>£649.97</td>\n",
       "      <td>8.7</td>\n",
       "      <td>903</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-v15-iil...</td>\n",
       "      <td>Intel Core i5 1035G1 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Dell Vostro 5502 Core i5-1135G7 8GB 256GB SSD ...</td>\n",
       "      <td>£679.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/-cmtwc/version...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Acer TravelMate P2 Core i5-10210U 8GB 256GB SS...</td>\n",
       "      <td>£587.98</td>\n",
       "      <td>9.3</td>\n",
       "      <td>4</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/acer-travelmat...</td>\n",
       "      <td>Intel Core i5 10210U Processor, UHD Graphics 6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CODA 3.4 Core i3-6157U 4GB 128GB SSD 14.1 Inch...</td>\n",
       "      <td>£269.97</td>\n",
       "      <td>7.6</td>\n",
       "      <td>25</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/coda-340-core-...</td>\n",
       "      <td>Intel Core i3 6157U Processor, UHD Graphics 62...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Lenovo IdeaPad L340-17 Core i5-9300HF 8GB 256G...</td>\n",
       "      <td>£824.97</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-ideapad...</td>\n",
       "      <td>Intel Core i5 9300HF Processor, GeForce GTX 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>Samsung Galaxy Book Pro Core i7 16GB 256GB 13....</td>\n",
       "      <td>£1334.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/samsung-galaxy...</td>\n",
       "      <td>Intel Core i7 1165G7 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>Samsung Galaxy Book LTE Core i5 8GB 256GB 15.6...</td>\n",
       "      <td>£899.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/samsung-galaxy...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>Samsung Galaxy Book Pro 360 Core i7 16GB 256GB...</td>\n",
       "      <td>£1449.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/samsung-galaxy...</td>\n",
       "      <td>Intel Core i7 1165G7 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>Asus TUF Dash F15 Core i7-11370H 16GB 1TB SSD ...</td>\n",
       "      <td>£1477.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-tuf-dash-...</td>\n",
       "      <td>Intel Core i7 11370H Processor, GeForce RTX 30...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>Asus ROG Zephyrus G14 AMD Ryzen 7-5800HS 16GB ...</td>\n",
       "      <td>£1476.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-rog-zephy...</td>\n",
       "      <td>AMD Ryzen 7 5800HS Processor, GeForce RTX 3050...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>Asus TUF F15 Core i5-10300H 8GB 512GB SSD 15.6...</td>\n",
       "      <td>£843.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-tuf-f15-c...</td>\n",
       "      <td>Intel Core i5 10300H Processor, GeForce GTX 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>Asus CB5500FEA Core i3-1115G4 8GB 128GB SSD 15...</td>\n",
       "      <td>£577.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-cb5500fea...</td>\n",
       "      <td>Intel Core i3 1115G4 Processor, 15.6 Inch Full...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>Lenovo ThinkPad P15s Core i7-1185G7 16GB 512GB...</td>\n",
       "      <td>£1702.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-thinkpa...</td>\n",
       "      <td>Intel Core i7 1185G7 Processor, Quadro T500 4G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>dell Vostro 3000 3510 Core i5-1135G7 8GB 256GB...</td>\n",
       "      <td>£668.98</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/-vh27t/version...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>Asus ExpertBook B1400 Core i3-1115G1 8GB 256GB...</td>\n",
       "      <td>£549.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-expertboo...</td>\n",
       "      <td>Intel Core i3 i3-1115G1 Processor, Iris Xe Gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>Asus ExpertBook B1400 Core i5-1135G7 8GB 256GB...</td>\n",
       "      <td>£699.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-expertboo...</td>\n",
       "      <td>Intel Core i5 I5-1135G7 Processor, Iris Xe Gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>Fujitsu LifeBook E5511 Core i5-1135G7 8GB 256G...</td>\n",
       "      <td>£894.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/fujitsu-lifebo...</td>\n",
       "      <td>Intel Core i5 I5-1135G7 Processor, Iris Xe Gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>Microsoft Surface Go Core i5-1035G 8GB 256GB S...</td>\n",
       "      <td>£927.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/microsoft-surf...</td>\n",
       "      <td>Intel Core i5 I5-1035G1 Processor, UHD Graphic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>Lenovo 100e AMD 3015Ce 4GB 32GB eMMC 11.6 Inch...</td>\n",
       "      <td>£238.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-100e-am...</td>\n",
       "      <td>3000 Series 3015Ce Processor, 11.6 Inch 1366 x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>Lenovo 300e AMD 3015Ce 4GB 32GB eMMC 11.6 Inch...</td>\n",
       "      <td>£318.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-300e-am...</td>\n",
       "      <td>3000 Series 3015Ce Processor, 11.6 Inch 1366 x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>Dell Latitude 3420 Core i3-1115G4 8 GB 256GB S...</td>\n",
       "      <td>£699.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/dell-latitude-...</td>\n",
       "      <td>Intel Core i3 I3-1115G4 Processor, Iris Xe Gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Samsung Galaxy Book Go 7C 4GB 256GB 14 Inch Wi...</td>\n",
       "      <td>£378.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/samsung-galaxy...</td>\n",
       "      <td>Snapdragon 7c Kryo 468 Processor, 14 Inch Full...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>New Apple MacBook Air 13-inch Apple M1 8GB 256...</td>\n",
       "      <td>£899.97</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2639</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/macbook-air-13...</td>\n",
       "      <td>M1 Processor, 13.3 Inch 2560 x 1600 Screen, 8G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>Lenovo ThinkBook 14 Gen 2 Core i5-1135G7 8GB 2...</td>\n",
       "      <td>£599.97</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-thinkbo...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, Iris Xe Graphi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>MSI Katana GF76 11UC-095UK Core i7-11800H 16GB...</td>\n",
       "      <td>£1079.97</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/msi-katana-gf7...</td>\n",
       "      <td>Intel Core i7 11800H Processor, GeForce RTX 30...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>Asus TUF Dash F15 Core i7-11370H 8GB 512GB SSD...</td>\n",
       "      <td>£940.97</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-tuf-dash-...</td>\n",
       "      <td>Intel Core i7 11370H Processor, GeForce RTX 30...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>ASUS ZenBook 14 with Screen Pad Core i7-10510U...</td>\n",
       "      <td>£731.97</td>\n",
       "      <td>9.1</td>\n",
       "      <td>59</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-zenbook-1...</td>\n",
       "      <td>Intel Core i7 10510U Processor, GeForce MX 350...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>Lenovo ThinkBook 14 Gen 2 Core i5-1135 8GB 256...</td>\n",
       "      <td>£819.97</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-thinkbo...</td>\n",
       "      <td>Intel Core i5 1135G7 Processor, 14 Inch Full H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>Asus ROG Strix Ryzen 9-5900H 32GB 2TB SSD 17.3...</td>\n",
       "      <td>£2999.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-rog-strix...</td>\n",
       "      <td>Ryzen 9 5900HX Processor, GeForce RTX 3080 16G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>Lenovo ThinkBook 14 Gen 2 Ryzen 5-4500 8GB 256...</td>\n",
       "      <td>£664.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-thinkbo...</td>\n",
       "      <td>AMD Ryzen 5 4500U Processor, Radeon Graphics G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>Lenovo ThinkPad X1 Carbon Gen8 Core i5-10210U ...</td>\n",
       "      <td>£1652.98</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/lenovo-thinkpa...</td>\n",
       "      <td>Intel Core i5 10210U Processor, 14 Inch Full H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>Asus TUF Dash F15 Core i7-11370H 16GB 512GB SS...</td>\n",
       "      <td>£1399.97</td>\n",
       "      <td>8.8</td>\n",
       "      <td>4</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/asus-tuf-gamin...</td>\n",
       "      <td>Intel Core i7 11370H Processor, GeForce RTX 30...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>Gigabyte AERO 15 OLED YC Core i9-10980HK 64GB ...</td>\n",
       "      <td>£4199.00</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/gigabyte-aero-...</td>\n",
       "      <td>Intel Core i9 I9-10980HK Processor, GeForce RT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>Razer Blade 15 Advanced Core i7-11800H 32GB 1T...</td>\n",
       "      <td>£2799.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/razer-blade-15...</td>\n",
       "      <td>Intel Core i7 11800H Processor, GeForce RTX 30...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>Razer Blade 15 Advanced Core i7-11800H 32GB 1T...</td>\n",
       "      <td>£2899.97</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.laptopsdirect.co.uk/razer-blade-15...</td>\n",
       "      <td>Intel Core i7 11800H Processor, GeForce RTX 30...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>464 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  Name     Price Rating  \\\n",
       "0    Acer Aspire 5 Core i5-1035G1 8GB 512GB SSD 15....   £579.97    8.5   \n",
       "1    Dell Latitude 3520 Core i5-1135G7 8GB 256GB SS...   £719.97     NA   \n",
       "2    Medion Akoya E15407 Core i5-1035G1 8GB 256GB S...   £459.97      8   \n",
       "3    Asus C223NA Intel Celeron N3350 4GB 32GB eMMC ...   £179.97     NA   \n",
       "4    CODA 1.2 Intel Celeron N4020 4GB 64GB eMMC 12....   £199.97     NA   \n",
       "5    Asus C523 Intel Celeron N3350 4GB 64GB eMMC 15...   £227.97      9   \n",
       "6    Lenovo V14-ADA AMD Ryzen 3 3250U 8GB 256GB SSD...   £399.97    8.8   \n",
       "7    Lenovo V15-IIL Core i5-1035G1 8GB 256GB SSD 15...   £549.97    8.7   \n",
       "8    Asus Vivobook14 Core i3-1005G1 8GB 256GB SSD 1...   £399.97     10   \n",
       "9    Lenovo V15 Althlon Silver 3050U 4GB 128GB SSD ...   £299.97    8.7   \n",
       "10   HP 255 G8 AMD Ryzen 5-3500U 8GB 256GB SSD 15 I...   £509.97    8.5   \n",
       "11   Medion Deputy P10 Core i5-10300H 16GB 512GB SS...   £699.97    9.2   \n",
       "12   Acer Swift 3 SF313-53 Core i7-1165G7 8GB 512GB...   £882.97    9.8   \n",
       "13   ASUS Vivobook X712JA Core i3-1005G1 8GB 1TB 17...   £419.97    6.5   \n",
       "14   Lenovo ThinkBook 15 Core i5-1035G1 8GB 256GB S...   £688.97    8.8   \n",
       "15   Lenovo IdeaPad L340 Core i5-9300H 8GB 256GB SS...   £579.97    8.9   \n",
       "16   HP 250 G8 Core i7-1065G7 8GB 256GB SSD 15.6 In...   £759.97      8   \n",
       "17   HP ProBook 450 G8 Core i5-1135G7 8GB 256GB SSD...   £814.97    9.7   \n",
       "18   Asus Vivobook Core i5-1035G1 8GB 256GB SSD 14 ...   £469.97      9   \n",
       "19   Dell Latitude 3510 Core i5-10210U 8GB 256GB SS...   £709.97    8.7   \n",
       "20   Lenovo Legion 5 AMD Ryzen 5 15.6 Inch Full HD ...   £899.97    9.2   \n",
       "21   ASUS VivoBook S513EA Core i7-1165G7 16GB 1TB S...   £799.97     NA   \n",
       "22   Acer TravelMate P2 P215-52-72CV Core i7-10510U...   £699.97    9.1   \n",
       "23   HP ZBook Firefly 15 G7 Core i7-10510U 16GB 512...  £1449.97    9.2   \n",
       "24   ASUS Vivobook D413IA Ryzen 7-4700U 8GB 512GB 1...   £599.97    9.8   \n",
       "25   Lenovo V15-IIL Core i5-1035G1 8GB 256GB SSD 15...   £649.97    8.7   \n",
       "26   Dell Vostro 5502 Core i5-1135G7 8GB 256GB SSD ...   £679.97     NA   \n",
       "27   Acer TravelMate P2 Core i5-10210U 8GB 256GB SS...   £587.98    9.3   \n",
       "28   CODA 3.4 Core i3-6157U 4GB 128GB SSD 14.1 Inch...   £269.97    7.6   \n",
       "29   Lenovo IdeaPad L340-17 Core i5-9300HF 8GB 256G...   £824.97      8   \n",
       "..                                                 ...       ...    ...   \n",
       "434  Samsung Galaxy Book Pro Core i7 16GB 256GB 13....  £1334.97     NA   \n",
       "435  Samsung Galaxy Book LTE Core i5 8GB 256GB 15.6...   £899.97     NA   \n",
       "436  Samsung Galaxy Book Pro 360 Core i7 16GB 256GB...  £1449.97     NA   \n",
       "437  Asus TUF Dash F15 Core i7-11370H 16GB 1TB SSD ...  £1477.97     NA   \n",
       "438  Asus ROG Zephyrus G14 AMD Ryzen 7-5800HS 16GB ...  £1476.97     NA   \n",
       "439  Asus TUF F15 Core i5-10300H 8GB 512GB SSD 15.6...   £843.97     NA   \n",
       "440  Asus CB5500FEA Core i3-1115G4 8GB 128GB SSD 15...   £577.97     NA   \n",
       "441  Lenovo ThinkPad P15s Core i7-1185G7 16GB 512GB...  £1702.97     NA   \n",
       "442  dell Vostro 3000 3510 Core i5-1135G7 8GB 256GB...   £668.98     NA   \n",
       "443  Asus ExpertBook B1400 Core i3-1115G1 8GB 256GB...   £549.97     NA   \n",
       "444  Asus ExpertBook B1400 Core i5-1135G7 8GB 256GB...   £699.97     NA   \n",
       "445  Fujitsu LifeBook E5511 Core i5-1135G7 8GB 256G...   £894.97     NA   \n",
       "446  Microsoft Surface Go Core i5-1035G 8GB 256GB S...   £927.97     NA   \n",
       "447  Lenovo 100e AMD 3015Ce 4GB 32GB eMMC 11.6 Inch...   £238.97     NA   \n",
       "448  Lenovo 300e AMD 3015Ce 4GB 32GB eMMC 11.6 Inch...   £318.97     NA   \n",
       "449  Dell Latitude 3420 Core i3-1115G4 8 GB 256GB S...   £699.97     NA   \n",
       "450  Samsung Galaxy Book Go 7C 4GB 256GB 14 Inch Wi...   £378.97     NA   \n",
       "451  New Apple MacBook Air 13-inch Apple M1 8GB 256...   £899.97    9.4   \n",
       "452  Lenovo ThinkBook 14 Gen 2 Core i5-1135G7 8GB 2...   £599.97      6   \n",
       "453  MSI Katana GF76 11UC-095UK Core i7-11800H 16GB...  £1079.97     10   \n",
       "454  Asus TUF Dash F15 Core i7-11370H 8GB 512GB SSD...   £940.97    7.9   \n",
       "455  ASUS ZenBook 14 with Screen Pad Core i7-10510U...   £731.97    9.1   \n",
       "456  Lenovo ThinkBook 14 Gen 2 Core i5-1135 8GB 256...   £819.97     10   \n",
       "457  Asus ROG Strix Ryzen 9-5900H 32GB 2TB SSD 17.3...  £2999.97     NA   \n",
       "458  Lenovo ThinkBook 14 Gen 2 Ryzen 5-4500 8GB 256...   £664.97     NA   \n",
       "459  Lenovo ThinkPad X1 Carbon Gen8 Core i5-10210U ...  £1652.98     NA   \n",
       "460  Asus TUF Dash F15 Core i7-11370H 16GB 512GB SS...  £1399.97    8.8   \n",
       "461  Gigabyte AERO 15 OLED YC Core i9-10980HK 64GB ...  £4199.00     10   \n",
       "462  Razer Blade 15 Advanced Core i7-11800H 32GB 1T...  £2799.97     NA   \n",
       "463  Razer Blade 15 Advanced Core i7-11800H 32GB 1T...  £2899.97     NA   \n",
       "\n",
       "    Review Count                                               Link  \\\n",
       "0              2  https://www.laptopsdirect.co.uk/acer-aspire-5-...   \n",
       "1             NA  https://www.laptopsdirect.co.uk/dell-latitude-...   \n",
       "2             42  https://www.laptopsdirect.co.uk/-core-i5-1035g...   \n",
       "3             NA  https://www.laptopsdirect.co.uk/asus-c223na-in...   \n",
       "4             NA  https://www.laptopsdirect.co.uk/coda-1.2-intel...   \n",
       "5             11  https://www.laptopsdirect.co.uk/-c523na-br0067...   \n",
       "6             25  https://www.laptopsdirect.co.uk/lenovo-v14-ada...   \n",
       "7            903  https://www.laptopsdirect.co.uk/lenovo-v15-iil...   \n",
       "8              2  https://www.laptopsdirect.co.uk/asus-core-i3-1...   \n",
       "9            903  https://www.laptopsdirect.co.uk/lenovo-v15-alt...   \n",
       "10            10  https://www.laptopsdirect.co.uk/hp-255-g8-amd-...   \n",
       "11            23  https://www.laptopsdirect.co.uk/medion-deputy-...   \n",
       "12             4  https://www.laptopsdirect.co.uk/acer-swift-3-s...   \n",
       "13            11  https://www.laptopsdirect.co.uk/asus-vivobook-...   \n",
       "14           102  https://www.laptopsdirect.co.uk/lenovo-thinkbo...   \n",
       "15            38  https://www.laptopsdirect.co.uk/lenovo-l340-co...   \n",
       "16             1  https://www.laptopsdirect.co.uk/hp-250-g8-core...   \n",
       "17             3  https://www.laptopsdirect.co.uk/hp-probook-450...   \n",
       "18             2  https://www.laptopsdirect.co.uk/asus-vivobook-...   \n",
       "19            22  https://www.laptopsdirect.co.uk/dell-latitude-...   \n",
       "20            70  https://www.laptopsdirect.co.uk/lenovo-legion-...   \n",
       "21            NA  https://www.laptopsdirect.co.uk/asus-vivobook-...   \n",
       "22            44  https://www.laptopsdirect.co.uk/acer-travelmat...   \n",
       "23             6  https://www.laptopsdirect.co.uk/hp-zbook-firef...   \n",
       "24             4  https://www.laptopsdirect.co.uk/asus-vivobook-...   \n",
       "25           903  https://www.laptopsdirect.co.uk/lenovo-v15-iil...   \n",
       "26            NA  https://www.laptopsdirect.co.uk/-cmtwc/version...   \n",
       "27             4  https://www.laptopsdirect.co.uk/acer-travelmat...   \n",
       "28            25  https://www.laptopsdirect.co.uk/coda-340-core-...   \n",
       "29             1  https://www.laptopsdirect.co.uk/lenovo-ideapad...   \n",
       "..           ...                                                ...   \n",
       "434           NA  https://www.laptopsdirect.co.uk/samsung-galaxy...   \n",
       "435           NA  https://www.laptopsdirect.co.uk/samsung-galaxy...   \n",
       "436           NA  https://www.laptopsdirect.co.uk/samsung-galaxy...   \n",
       "437           NA  https://www.laptopsdirect.co.uk/asus-tuf-dash-...   \n",
       "438           NA  https://www.laptopsdirect.co.uk/asus-rog-zephy...   \n",
       "439           NA  https://www.laptopsdirect.co.uk/asus-tuf-f15-c...   \n",
       "440           NA  https://www.laptopsdirect.co.uk/asus-cb5500fea...   \n",
       "441           NA  https://www.laptopsdirect.co.uk/lenovo-thinkpa...   \n",
       "442           NA  https://www.laptopsdirect.co.uk/-vh27t/version...   \n",
       "443           NA  https://www.laptopsdirect.co.uk/asus-expertboo...   \n",
       "444           NA  https://www.laptopsdirect.co.uk/asus-expertboo...   \n",
       "445           NA  https://www.laptopsdirect.co.uk/fujitsu-lifebo...   \n",
       "446           NA  https://www.laptopsdirect.co.uk/microsoft-surf...   \n",
       "447           NA  https://www.laptopsdirect.co.uk/lenovo-100e-am...   \n",
       "448           NA  https://www.laptopsdirect.co.uk/lenovo-300e-am...   \n",
       "449           NA  https://www.laptopsdirect.co.uk/dell-latitude-...   \n",
       "450           NA  https://www.laptopsdirect.co.uk/samsung-galaxy...   \n",
       "451         2639  https://www.laptopsdirect.co.uk/macbook-air-13...   \n",
       "452            1  https://www.laptopsdirect.co.uk/lenovo-thinkbo...   \n",
       "453            1  https://www.laptopsdirect.co.uk/msi-katana-gf7...   \n",
       "454           16  https://www.laptopsdirect.co.uk/asus-tuf-dash-...   \n",
       "455           59  https://www.laptopsdirect.co.uk/asus-zenbook-1...   \n",
       "456            2  https://www.laptopsdirect.co.uk/lenovo-thinkbo...   \n",
       "457           NA  https://www.laptopsdirect.co.uk/asus-rog-strix...   \n",
       "458           NA  https://www.laptopsdirect.co.uk/lenovo-thinkbo...   \n",
       "459           NA  https://www.laptopsdirect.co.uk/lenovo-thinkpa...   \n",
       "460            4  https://www.laptopsdirect.co.uk/asus-tuf-gamin...   \n",
       "461            1  https://www.laptopsdirect.co.uk/gigabyte-aero-...   \n",
       "462           NA  https://www.laptopsdirect.co.uk/razer-blade-15...   \n",
       "463           NA  https://www.laptopsdirect.co.uk/razer-blade-15...   \n",
       "\n",
       "                                               Details  \n",
       "0    Intel Core i5 1035G1 Processor, UHD Graphics 6...  \n",
       "1    Intel Core i5 1135G7 Processor, UHD Graphics 6...  \n",
       "2    Intel Core i5 1035G1 Processor, Iris Xe Graphi...  \n",
       "3    Intel Celeron N3350 Processor, 11.6 Inch 1366 ...  \n",
       "4    Intel Celeron N4020 Processor, UHD Graphics 62...  \n",
       "5    Intel Celeron N3350 Processor, 15.6 Inch 1366 ...  \n",
       "6    AMD Ryzen 3 3250U Processor, Radeon Graphics G...  \n",
       "7    Intel Core i5 1035G1 Processor, UHD Graphics 6...  \n",
       "8    Intel Core i3 1005G1 Processor, UHD Graphics 6...  \n",
       "9    Athlon Silver 3050U Processor, Radeon Graphics...  \n",
       "10   AMD Ryzen 5 3500U Processor, Radeon Graphics G...  \n",
       "11   Intel Core i5 10300H Processor, GeForce GTX 16...  \n",
       "12   Intel Core i7 1165G7 Processor, Iris Xe Graphi...  \n",
       "13   Intel Core i3 1005G1 Processor, UHD Graphics 6...  \n",
       "14   Intel Core i5 I5-1035G1 Processor, Iris Xe Gra...  \n",
       "15   Intel Core i5 9300HF Processor, GeForce GTX 16...  \n",
       "16   Intel Core i7 I7-1065G7 Processor, UHD Graphic...  \n",
       "17   Intel Core i5 1135G7 Processor, UHD Graphics 6...  \n",
       "18   Intel Core i5 I5-1035G1 Processor, UHD Graphic...  \n",
       "19   Intel Core i5 10210U Processor, 15.6 Inch Full...  \n",
       "20   AMD Ryzen 5 5600H Processor, GeForce RTX 3060 ...  \n",
       "21   Intel Core i7 1165G7 Processor, Iris Xe Graphi...  \n",
       "22   Intel Core i7 10510U Processor, UHD Graphics 6...  \n",
       "23   Intel Core i7 10510U Processor, Quadro P520 4G...  \n",
       "24   AMD Ryzen 7 4700U Processor, Radeon Graphics G...  \n",
       "25   Intel Core i5 1035G1 Processor, UHD Graphics 6...  \n",
       "26   Intel Core i5 1135G7 Processor, UHD Graphics 6...  \n",
       "27   Intel Core i5 10210U Processor, UHD Graphics 6...  \n",
       "28   Intel Core i3 6157U Processor, UHD Graphics 62...  \n",
       "29   Intel Core i5 9300HF Processor, GeForce GTX 16...  \n",
       "..                                                 ...  \n",
       "434  Intel Core i7 1165G7 Processor, Iris Xe Graphi...  \n",
       "435  Intel Core i5 1135G7 Processor, Iris Xe Graphi...  \n",
       "436  Intel Core i7 1165G7 Processor, Iris Xe Graphi...  \n",
       "437  Intel Core i7 11370H Processor, GeForce RTX 30...  \n",
       "438  AMD Ryzen 7 5800HS Processor, GeForce RTX 3050...  \n",
       "439  Intel Core i5 10300H Processor, GeForce GTX 16...  \n",
       "440  Intel Core i3 1115G4 Processor, 15.6 Inch Full...  \n",
       "441  Intel Core i7 1185G7 Processor, Quadro T500 4G...  \n",
       "442                                                     \n",
       "443  Intel Core i3 i3-1115G1 Processor, Iris Xe Gra...  \n",
       "444  Intel Core i5 I5-1135G7 Processor, Iris Xe Gra...  \n",
       "445  Intel Core i5 I5-1135G7 Processor, Iris Xe Gra...  \n",
       "446  Intel Core i5 I5-1035G1 Processor, UHD Graphic...  \n",
       "447  3000 Series 3015Ce Processor, 11.6 Inch 1366 x...  \n",
       "448  3000 Series 3015Ce Processor, 11.6 Inch 1366 x...  \n",
       "449  Intel Core i3 I3-1115G4 Processor, Iris Xe Gra...  \n",
       "450  Snapdragon 7c Kryo 468 Processor, 14 Inch Full...  \n",
       "451  M1 Processor, 13.3 Inch 2560 x 1600 Screen, 8G...  \n",
       "452  Intel Core i5 1135G7 Processor, Iris Xe Graphi...  \n",
       "453  Intel Core i7 11800H Processor, GeForce RTX 30...  \n",
       "454  Intel Core i7 11370H Processor, GeForce RTX 30...  \n",
       "455  Intel Core i7 10510U Processor, GeForce MX 350...  \n",
       "456  Intel Core i5 1135G7 Processor, 14 Inch Full H...  \n",
       "457  Ryzen 9 5900HX Processor, GeForce RTX 3080 16G...  \n",
       "458  AMD Ryzen 5 4500U Processor, Radeon Graphics G...  \n",
       "459  Intel Core i5 10210U Processor, 14 Inch Full H...  \n",
       "460  Intel Core i7 11370H Processor, GeForce RTX 30...  \n",
       "461  Intel Core i9 I9-10980HK Processor, GeForce RT...  \n",
       "462  Intel Core i7 11800H Processor, GeForce RTX 30...  \n",
       "463  Intel Core i7 11800H Processor, GeForce RTX 30...  \n",
       "\n",
       "[464 rows x 6 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product_overview"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_overview.to_excel(\"ResultAll.xlsx\", index = False)  #Exporting results to MS Excel file (.xlsx format)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}