Web Scrapping 3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "cd82db5a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: selenium in c:\\users\\pooja\\anaconda3\\lib\\site-packages (4.7.2)\n",
      "Requirement already satisfied: certifi>=2021.10.8 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from selenium) (2021.10.8)\n",
      "Requirement already satisfied: trio-websocket~=0.9 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from selenium) (0.9.2)\n",
      "Requirement already satisfied: trio~=0.17 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from selenium) (0.22.0)\n",
      "Requirement already satisfied: urllib3[socks]~=1.26 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from selenium) (1.26.9)\n",
      "Requirement already satisfied: outcome in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (1.2.0)\n",
      "Requirement already satisfied: sniffio in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (1.2.0)\n",
      "Requirement already satisfied: exceptiongroup>=1.0.0rc9 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (1.1.0)\n",
      "Requirement already satisfied: async-generator>=1.9 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (1.10)\n",
      "Requirement already satisfied: cffi>=1.14 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (1.15.0)\n",
      "Requirement already satisfied: attrs>=19.2.0 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (21.4.0)\n",
      "Requirement already satisfied: sortedcontainers in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (2.4.0)\n",
      "Requirement already satisfied: idna in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio~=0.17->selenium) (3.3)\n",
      "Requirement already satisfied: pycparser in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from cffi>=1.14->trio~=0.17->selenium) (2.21)\n",
      "Requirement already satisfied: wsproto>=0.14 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from trio-websocket~=0.9->selenium) (1.2.0)\n",
      "Requirement already satisfied: PySocks!=1.5.7,<2.0,>=1.5.6 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from urllib3[socks]~=1.26->selenium) (1.7.1)\n",
      "Requirement already satisfied: h11<1,>=0.9.0 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from wsproto>=0.14->trio-websocket~=0.9->selenium) (0.14.0)\n",
      "Requirement already satisfied: bs4 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (0.0.1)\n",
      "Requirement already satisfied: beautifulsoup4 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from bs4) (4.11.1)\n",
      "Requirement already satisfied: soupsieve>1.2 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from beautifulsoup4->bs4) (2.3.1)\n",
      "Requirement already satisfied: requests in c:\\users\\pooja\\anaconda3\\lib\\site-packages (2.27.1)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from requests) (1.26.9)\n",
      "Requirement already satisfied: charset-normalizer~=2.0.0 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from requests) (2.0.4)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from requests) (3.3)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\users\\pooja\\anaconda3\\lib\\site-packages (from requests) (2021.10.8)\n"
     ]
    }
   ],
   "source": [
    "!pip install selenium \n",
    "!pip install bs4\n",
    "!pip install requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "79849518",
   "metadata": {},
   "outputs": [],
   "source": [
    "#*************************************\n",
    "#1.Python program to search a product\n",
    "#*************************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "82b1c517",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.common.exceptions import StaleElementReferenceException , NoSuchElementException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "be6f1a62",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c32b8fe5",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get('http://www.amazon.in/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a96d868b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Enter Product to Search: Smart TV\n"
     ]
    }
   ],
   "source": [
    "product = input (\"Enter Product to Search: \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "86ca5eff",
   "metadata": {},
   "outputs": [],
   "source": [
    "enter_product =driver.find_element(By.XPATH,\"/html/body/div[1]/header/div/div[1]/div[2]/div/form/div[2]/div[1]/input\")\n",
    "enter_product.send_keys(product)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "fd4bbc30",
   "metadata": {},
   "outputs": [],
   "source": [
    "search=driver.find_element(By.XPATH,\"/html/body/div[1]/header/div/div[1]/div[2]/div/form/div[3]/div/span\")\n",
    "search.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c8e43fe3",
   "metadata": {},
   "outputs": [],
   "source": [
    "#************************************************\n",
    "#2.Scraping Data For 1 to3 pages of Q1\n",
    "#************************************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "700c8e26",
   "metadata": {},
   "outputs": [],
   "source": [
    "URL = []\n",
    "\n",
    "\n",
    "\n",
    "start=0\n",
    "end=3\n",
    "\n",
    "for page in range(start,end):\n",
    "    \n",
    "     #URL\n",
    "    url=driver.find_elements(By.XPATH, '//a[@class=\"a-link-normal s-no-outline\"]')\n",
    "    for i in url:\n",
    "        U = (i.get_attribute('href'))\n",
    "        if U == (\"\"):\n",
    "            URL.append(\"-\")\n",
    "        else:\n",
    "            URL.append(U)\n",
    "            \n",
    "\n",
    "   \n",
    "        \n",
    "    \n",
    "    \n",
    "    \n",
    "\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "e1fde7b0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "66\n"
     ]
    }
   ],
   "source": [
    "print (len(URL))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f1f35f2f",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "Brand = []\n",
    "P_name = []\n",
    "RnE = []\n",
    "Avl = []\n",
    "Price = []\n",
    "Del = []\n",
    "       \n",
    "\n",
    "\n",
    "\n",
    "for i in URL:\n",
    "    driver.get(i)\n",
    "    brand=driver.find_elements(By.XPATH, '//tr[@class=\"a-spacing-small po-brand\"]')\n",
    "    for x in brand:\n",
    "        b = (x.text)\n",
    "        if b == (\"\"):\n",
    "            Brand.append('-')\n",
    "        else:\n",
    "            Brand.append(b)\n",
    "            \n",
    "    p_name=driver.find_elements(By.XPATH, '//span[@class=\"a-size-large product-title-word-break\"]')\n",
    "    for x in p_name:\n",
    "        pn = (x.text)\n",
    "        if pn == (\"\"):\n",
    "            P_name.append('-')\n",
    "        else:\n",
    "            P_name.append(pn)\n",
    "                \n",
    "    price=driver.find_elements(By.ID,(\"corePriceDisplay_desktop_feature_div\"))\n",
    "    for i in price:\n",
    "        pr = (i.text)\n",
    "        if pr != (\"\"):\n",
    "            Price.append(pr)\n",
    "        \n",
    "    delv=driver.find_elements(By.ID ,\"mir-layout-DELIVERY_BLOCK-slot-PRIMARY_DELIVERY_MESSAGE_LARGE\")\n",
    "    for x in delv:\n",
    "        d = (x.text)\n",
    "        if d == (\"\"):\n",
    "            Del.append(\"-\")\n",
    "        else:\n",
    "            Del.append(d)\n",
    "   \n",
    "    \n",
    "    \n",
    "                \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    rne=driver.find_elements(By.ID, \"RETURNS_POLICY\")\n",
    "    for x in rne:\n",
    "        re = (x.text)\n",
    "        if re == (\"\"):\n",
    "            RnE.append(\"-\")\n",
    "        else:\n",
    "            RnE.append(re)\n",
    "                \n",
    "                \n",
    "\n",
    "                \n",
    "    avl=driver.find_elements(By.XPATH, '//span[@class=\"a-size-medium a-color-success\"]')\n",
    "    for x in avl:\n",
    "        a = (x.text)\n",
    "        if a == (\"\"):\n",
    "            Avl.append(\"-\")\n",
    "        else:\n",
    "            Avl.append(a)       \n",
    "\n",
    "                "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "da02b6b4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "66 66 66 66 66 66\n"
     ]
    }
   ],
   "source": [
    "print (len(P_name), len(Brand),len(Avl), len(RnE),len(Price),len(Del))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "92bb4b7d",
   "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>Brand</th>\n",
       "      <th>Product Name</th>\n",
       "      <th>Price</th>\n",
       "      <th>Availability</th>\n",
       "      <th>Delivery</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Brand Kodak</td>\n",
       "      <td>Kodak 98 cm (40 inches) Full HD Certified Andr...</td>\n",
       "      <td>-42%\\n₹14,499\\nM.R.P.:\\n₹24,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/sspa/click?ie=UTF8&amp;spc=M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Brand Redmi</td>\n",
       "      <td>Redmi 80 cm (32 inches) Android 11 Series HD R...</td>\n",
       "      <td>-44%\\n₹13,999\\nM.R.P.:\\n₹24,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/sspa/click?ie=UTF8&amp;spc=M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Brand OnePlus</td>\n",
       "      <td>OnePlus 80 cm (32 inches) Y Series HD Ready LE...</td>\n",
       "      <td>-25%\\n₹14,999\\nM.R.P.:\\n₹19,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/OnePlus-inches-Ready-And...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Brand Redmi</td>\n",
       "      <td>Redmi 80 cm (32 inches) Android 11 Series HD R...</td>\n",
       "      <td>-44%\\n₹13,999\\nM.R.P.:\\n₹24,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/Redmi-inches-Ready-L32M6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Brand VW</td>\n",
       "      <td>VW 80 cm (32 inches) HD Ready Android Smart LE...</td>\n",
       "      <td>-53%\\n₹7,999\\nM.R.P.:\\n₹16,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/Visio-World-inches-VW32S...</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>61</th>\n",
       "      <td>Brand OnePlus</td>\n",
       "      <td>OnePlus 108 cm (43 inches) Y Series Full HD Sm...</td>\n",
       "      <td>-22%\\n₹24,999\\nM.R.P.:\\n₹31,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/OnePlus-inches-Smart-And...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Brand OnePlus</td>\n",
       "      <td>OnePlus 108 cm (43 inches) Y Series 4K Ultra H...</td>\n",
       "      <td>-25%\\n₹29,999\\nM.R.P.:\\n₹39,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/OnePlus-43-inches-Androi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Brand iFFALCON</td>\n",
       "      <td>iFFALCON 80 cm (32 inches) HD Ready Smart LED ...</td>\n",
       "      <td>-64%\\n₹9,999\\nM.R.P.:\\n₹27,990</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/iFFALCON-inches-Ready-Sm...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Brand MI</td>\n",
       "      <td>MI 108 cm (43 inches) 5A Series Full HD Smart ...</td>\n",
       "      <td>-31%\\n₹24,999\\nM.R.P.:\\n₹35,999</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/sspa/click?ie=UTF8&amp;spc=M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Brand AmazonBasics</td>\n",
       "      <td>AmazonBasics 81cm (32 inches) Fire TV Edition ...</td>\n",
       "      <td>-54%\\n₹12,299\\nM.R.P.:\\n₹27,000</td>\n",
       "      <td>In stock.</td>\n",
       "      <td>FREE scheduled delivery as soon as Monday, 30 ...</td>\n",
       "      <td>https://www.amazon.in/sspa/click?ie=UTF8&amp;spc=M...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>66 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Brand                                       Product Name  \\\n",
       "0          Brand Kodak  Kodak 98 cm (40 inches) Full HD Certified Andr...   \n",
       "1          Brand Redmi  Redmi 80 cm (32 inches) Android 11 Series HD R...   \n",
       "2        Brand OnePlus  OnePlus 80 cm (32 inches) Y Series HD Ready LE...   \n",
       "3          Brand Redmi  Redmi 80 cm (32 inches) Android 11 Series HD R...   \n",
       "4             Brand VW  VW 80 cm (32 inches) HD Ready Android Smart LE...   \n",
       "..                 ...                                                ...   \n",
       "61       Brand OnePlus  OnePlus 108 cm (43 inches) Y Series Full HD Sm...   \n",
       "62       Brand OnePlus  OnePlus 108 cm (43 inches) Y Series 4K Ultra H...   \n",
       "63      Brand iFFALCON  iFFALCON 80 cm (32 inches) HD Ready Smart LED ...   \n",
       "64            Brand MI  MI 108 cm (43 inches) 5A Series Full HD Smart ...   \n",
       "65  Brand AmazonBasics  AmazonBasics 81cm (32 inches) Fire TV Edition ...   \n",
       "\n",
       "                              Price Availability  \\\n",
       "0   -42%\\n₹14,499\\nM.R.P.:\\n₹24,999    In stock.   \n",
       "1   -44%\\n₹13,999\\nM.R.P.:\\n₹24,999    In stock.   \n",
       "2   -25%\\n₹14,999\\nM.R.P.:\\n₹19,999    In stock.   \n",
       "3   -44%\\n₹13,999\\nM.R.P.:\\n₹24,999    In stock.   \n",
       "4    -53%\\n₹7,999\\nM.R.P.:\\n₹16,999    In stock.   \n",
       "..                              ...          ...   \n",
       "61  -22%\\n₹24,999\\nM.R.P.:\\n₹31,999    In stock.   \n",
       "62  -25%\\n₹29,999\\nM.R.P.:\\n₹39,999    In stock.   \n",
       "63   -64%\\n₹9,999\\nM.R.P.:\\n₹27,990    In stock.   \n",
       "64  -31%\\n₹24,999\\nM.R.P.:\\n₹35,999    In stock.   \n",
       "65  -54%\\n₹12,299\\nM.R.P.:\\n₹27,000    In stock.   \n",
       "\n",
       "                                             Delivery  \\\n",
       "0   FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "1   FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "2   FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "3   FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "4   FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "..                                                ...   \n",
       "61  FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "62  FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "63  FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "64  FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "65  FREE scheduled delivery as soon as Monday, 30 ...   \n",
       "\n",
       "                                                  URL  \n",
       "0   https://www.amazon.in/sspa/click?ie=UTF8&spc=M...  \n",
       "1   https://www.amazon.in/sspa/click?ie=UTF8&spc=M...  \n",
       "2   https://www.amazon.in/OnePlus-inches-Ready-And...  \n",
       "3   https://www.amazon.in/Redmi-inches-Ready-L32M6...  \n",
       "4   https://www.amazon.in/Visio-World-inches-VW32S...  \n",
       "..                                                ...  \n",
       "61  https://www.amazon.in/OnePlus-inches-Smart-And...  \n",
       "62  https://www.amazon.in/OnePlus-43-inches-Androi...  \n",
       "63  https://www.amazon.in/iFFALCON-inches-Ready-Sm...  \n",
       "64  https://www.amazon.in/sspa/click?ie=UTF8&spc=M...  \n",
       "65  https://www.amazon.in/sspa/click?ie=UTF8&spc=M...  \n",
       "\n",
       "[66 rows x 6 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame ({'Brand':Brand,'Product Name':P_name,'Price':Price,'Availability':Avl,'Delivery':Del,'URL':URL})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "839f8b1b",
   "metadata": {},
   "outputs": [],
   "source": [
    "WSAmazon = df.to_csv()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "4945f00f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "',Brand,Product Name,Price,Availability,Delivery,URL\\r\\n0,Brand Kodak,Kodak 98 cm (40 inches) Full HD Certified Android LED TV 40FHDX7XPRO (Black),\"-42%\\n₹14,499\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYXRmOjIwMDU2NTMyMTQ5NDAxOjowOjo&url=%2FKodak-Inches-Certified-Android-40FHDX7XPRO%2Fdp%2FB08CS2SRVQ%2Fref%3Dsr_1_1_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-1-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9hdGY%26psc%3D1\\r\\n1,Brand Redmi,Redmi 80 cm (32 inches) Android 11 Series HD Ready Smart LED TV | L32M6-RA/L32M7-RA (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYXRmOjIwMDY2ODE0NjkzNTk4OjowOjo&url=%2FRedmi-inches-Ready-L32M6-RA-Android%2Fdp%2FB09F9YQQ7B%2Fref%3Dsr_1_2_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-2-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9hdGY%26psc%3D1\\r\\n2,Brand OnePlus,OnePlus 80 cm (32 inches) Y Series HD Ready LED Smart Android TV 32Y1 (Black),\"-25%\\n₹14,999\\nM.R.P.:\\n₹19,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-inches-Ready-Android-32Y1/dp/B08B42LWKN/ref=sr_1_3?keywords=Smart+TV&qid=1674883346&sr=8-3\\r\\n3,Brand Redmi,Redmi 80 cm (32 inches) Android 11 Series HD Ready Smart LED TV | L32M6-RA/L32M7-RA (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Redmi-inches-Ready-L32M6-RA-Android/dp/B09F9YQQ7B/ref=sr_1_4?keywords=Smart+TV&qid=1674883346&sr=8-4\\r\\n4,Brand VW,VW 80 cm (32 inches) HD Ready Android Smart LED TV VW32S (Black),\"-53%\\n₹7,999\\nM.R.P.:\\n₹16,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/Visio-World-inches-VW32S-Ready/dp/B07MNNH484/ref=sr_1_5?keywords=Smart+TV&qid=1674883346&sr=8-5\\r\\n5,Brand Acer,Acer 80 cm (32 inches) I Series HD Ready Android Smart LED TV AR32AR2841HDFL (Black),\"-45%\\n₹10,999\\nM.R.P.:\\n₹19,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ready-Android-AR32AR2841HDFL/dp/B0B1YVCJ2Y/ref=sr_1_6?keywords=Smart+TV&qid=1674883346&sr=8-6\\r\\n6,Brand Samsung,Samsung 80 cm (32 Inches) Wondertainment Series HD Ready LED Smart TV UA32T4340BKXXL (Glossy Black),\"-41%\\n₹13,490\\nM.R.P.:\\n₹22,900\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/Samsung-Inches-Wondertainment-UA32T4340BKXXL-Glossy/dp/B09F6S8BT6/ref=sr_1_7?keywords=Smart+TV&qid=1674883346&sr=8-7\\r\\n7,Brand VW,VW 80 cm (32 inches) Linux Series Frameless HD Ready Smart LED TV VW32C2 (Black),\"-53%\\n₹7,999\\nM.R.P.:\\n₹16,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/VW-inches-Linux-Frameless-VW32C2/dp/B0BQZQ3QTV/ref=sr_1_8?keywords=Smart+TV&qid=1674883346&sr=8-8\\r\\n8,Brand MI,MI 80 cm (32 inches) 5A Series HD Ready Smart Android LED TV L32M7-5AIN (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/MI-inches-Ready-Android-L32M7-5AIN/dp/B0B6F7LX4C/ref=sr_1_9?keywords=Smart+TV&qid=1674883346&sr=8-9\\r\\n9,Brand Acer,Acer 127 cm (50 inches) I Series 4K Ultra HD Android Smart LED TV AR50AR2851UDFL (Black),\"-34%\\n₹26,999\\nM.R.P.:\\n₹40,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR50AR2851UDFL/dp/B0B1YZX72F/ref=sr_1_10?keywords=Smart+TV&qid=1674883346&sr=8-10\\r\\n10,Brand coocaa,coocaa 80 cm (32 inches) Frameless Series HD Ready Smart IPS LED TV 32S3U Pro (Black),\"-76%\\n₹8,999\\nM.R.P.:\\n₹36,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfbXRmOjIwMTEwNDQ3NjIwMzk4OjowOjo&url=%2Fcoocaa-inches-Frameless-32S3U-Pro%2Fdp%2FB0B45VT3WK%2Fref%3Dsr_1_11_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-11-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9tdGY%26psc%3D1\\r\\n11,Brand Samsung,Samsung 80 cm (32 Inches) Wondertainment Series HD Ready LED Smart TV UA32T4340BKXXL (Glossy Black),\"-41%\\n₹13,490\\nM.R.P.:\\n₹22,900\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfbXRmOjIwMDUyNTkyOTM1MDk4OjowOjo&url=%2FSamsung-Inches-Wondertainment-UA32T4340BKXXL-Glossy%2Fdp%2FB09F6S8BT6%2Fref%3Dsr_1_12_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-12-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9tdGY%26psc%3D1\\r\\n12,Brand Acer,Acer 109 cm (43 inches) I Series 4K Ultra HD Android Smart LED TV AR43AR2851UDFL (Black),\"-34%\\n₹22,999\\nM.R.P.:\\n₹34,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR43AR2851UDFL/dp/B0B1YY6JJL/ref=sr_1_13?keywords=Smart+TV&qid=1674883346&sr=8-13\\r\\n13,Brand Acer,Acer 139 cm (55 inches) I Series 4K Ultra HD Android Smart LED TV AR55AR2851UDFL (Black),\"-37%\\n₹29,999\\nM.R.P.:\\n₹47,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR55AR2851UDFL/dp/B0B1YZ9CB8/ref=sr_1_14?keywords=Smart+TV&qid=1674883346&sr=8-14\\r\\n14,Brand MI,Mi 80 cm (32 inches) Horizon Edition HD Ready Android Smart LED TV 4A | L32M6-EI (Grey),\"-40%\\n₹11,999\\nM.R.P.:\\n₹19,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/inches-Horizon-Ready-Android-L32M6-EI/dp/B08WPPDFLD/ref=sr_1_15?keywords=Smart+TV&qid=1674883346&sr=8-15\\r\\n15,Brand Redmi,Redmi 108 cm (43 inches) 4K Ultra HD Android Smart LED TV X43 | L43R7-7AIN (Black),\"-37%\\n₹26,999\\nM.R.P.:\\n₹42,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Redmi-inches-Ultra-Android-L43R7-7AIN/dp/B09RFC46VP/ref=sr_1_16?keywords=Smart+TV&qid=1674883346&sr=8-16\\r\\n16,Brand VW,VW 60 cm (24 inches) HD Ready Smart LED TV VW24S (Black) (2021 Model),\"-43%\\n₹6,799\\nM.R.P.:\\n₹11,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/inches-Ready-Smart-VW24S-Black/dp/B08Z35H8L6/ref=sr_1_17?keywords=Smart+TV&qid=1674883346&sr=8-17\\r\\n17,Brand OnePlus,OnePlus 108 cm (43 inches) Y Series Full HD Smart Android LED TV 43 Y1S (Black),\"-22%\\n₹24,999\\nM.R.P.:\\n₹31,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-inches-Smart-Android-Black/dp/B09Q5P2MT3/ref=sr_1_18?keywords=Smart+TV&qid=1674883346&sr=8-18\\r\\n18,Brand OnePlus,OnePlus 108 cm (43 inches) Y Series 4K Ultra HD Smart Android LED TV 43Y1S Pro (Black),\"-25%\\n₹29,999\\nM.R.P.:\\n₹39,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-43-inches-Android-Pro/dp/B09VCHLSJF/ref=sr_1_19?keywords=Smart+TV&qid=1674883346&sr=8-19\\r\\n19,Brand iFFALCON,iFFALCON 80 cm (32 inches) HD Ready Smart LED TV 32F53 (Black),\"-64%\\n₹9,999\\nM.R.P.:\\n₹27,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/iFFALCON-inches-Ready-Smart-TV-32F53/dp/B09X1M3DHX/ref=sr_1_20?keywords=Smart+TV&qid=1674883346&sr=8-20\\r\\n20,Brand MI,MI 108 cm (43 inches) 5A Series Full HD Smart Android LED TV L43M7-EAIN (Black),\"-31%\\n₹24,999\\nM.R.P.:\\n₹35,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYnRmOjIwMDgwMjY4NTU1Njk4OjowOjo&url=%2FMI-inches-Smart-Android-L43M7-EAIN%2Fdp%2FB0B6F8HHR6%2Fref%3Dsr_1_21_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-21-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9idGY%26psc%3D1\\r\\n21,Brand AmazonBasics,AmazonBasics 81cm (32 inches) Fire TV Edition HD Ready Smart LED TV AB32E10SS (Black),\"-54%\\n₹12,299\\nM.R.P.:\\n₹27,000\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYnRmOjIwMDQ2MTYyNDEwNzk4OjowOjo&url=%2FAmazonBasics-80cm-inch-Smart-LED%2Fdp%2FB087JX4TT4%2Fref%3Dsr_1_22_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-22-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9idGY%26psc%3D1\\r\\n22,Brand Kodak,Kodak 98 cm (40 inches) Full HD Certified Android LED TV 40FHDX7XPRO (Black),\"-42%\\n₹14,499\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYXRmOjIwMDU2NTMyMTQ5NDAxOjowOjo&url=%2FKodak-Inches-Certified-Android-40FHDX7XPRO%2Fdp%2FB08CS2SRVQ%2Fref%3Dsr_1_1_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-1-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9hdGY%26psc%3D1\\r\\n23,Brand Redmi,Redmi 80 cm (32 inches) Android 11 Series HD Ready Smart LED TV | L32M6-RA/L32M7-RA (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYXRmOjIwMDY2ODE0NjkzNTk4OjowOjo&url=%2FRedmi-inches-Ready-L32M6-RA-Android%2Fdp%2FB09F9YQQ7B%2Fref%3Dsr_1_2_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-2-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9hdGY%26psc%3D1\\r\\n24,Brand OnePlus,OnePlus 80 cm (32 inches) Y Series HD Ready LED Smart Android TV 32Y1 (Black),\"-25%\\n₹14,999\\nM.R.P.:\\n₹19,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-inches-Ready-Android-32Y1/dp/B08B42LWKN/ref=sr_1_3?keywords=Smart+TV&qid=1674883346&sr=8-3\\r\\n25,Brand Redmi,Redmi 80 cm (32 inches) Android 11 Series HD Ready Smart LED TV | L32M6-RA/L32M7-RA (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Redmi-inches-Ready-L32M6-RA-Android/dp/B09F9YQQ7B/ref=sr_1_4?keywords=Smart+TV&qid=1674883346&sr=8-4\\r\\n26,Brand VW,VW 80 cm (32 inches) HD Ready Android Smart LED TV VW32S (Black),\"-53%\\n₹7,999\\nM.R.P.:\\n₹16,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/Visio-World-inches-VW32S-Ready/dp/B07MNNH484/ref=sr_1_5?keywords=Smart+TV&qid=1674883346&sr=8-5\\r\\n27,Brand Acer,Acer 80 cm (32 inches) I Series HD Ready Android Smart LED TV AR32AR2841HDFL (Black),\"-45%\\n₹10,999\\nM.R.P.:\\n₹19,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ready-Android-AR32AR2841HDFL/dp/B0B1YVCJ2Y/ref=sr_1_6?keywords=Smart+TV&qid=1674883346&sr=8-6\\r\\n28,Brand Samsung,Samsung 80 cm (32 Inches) Wondertainment Series HD Ready LED Smart TV UA32T4340BKXXL (Glossy Black),\"-41%\\n₹13,490\\nM.R.P.:\\n₹22,900\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/Samsung-Inches-Wondertainment-UA32T4340BKXXL-Glossy/dp/B09F6S8BT6/ref=sr_1_7?keywords=Smart+TV&qid=1674883346&sr=8-7\\r\\n29,Brand VW,VW 80 cm (32 inches) Linux Series Frameless HD Ready Smart LED TV VW32C2 (Black),\"-53%\\n₹7,999\\nM.R.P.:\\n₹16,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/VW-inches-Linux-Frameless-VW32C2/dp/B0BQZQ3QTV/ref=sr_1_8?keywords=Smart+TV&qid=1674883346&sr=8-8\\r\\n30,Brand MI,MI 80 cm (32 inches) 5A Series HD Ready Smart Android LED TV L32M7-5AIN (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/MI-inches-Ready-Android-L32M7-5AIN/dp/B0B6F7LX4C/ref=sr_1_9?keywords=Smart+TV&qid=1674883346&sr=8-9\\r\\n31,Brand Acer,Acer 127 cm (50 inches) I Series 4K Ultra HD Android Smart LED TV AR50AR2851UDFL (Black),\"-34%\\n₹26,999\\nM.R.P.:\\n₹40,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR50AR2851UDFL/dp/B0B1YZX72F/ref=sr_1_10?keywords=Smart+TV&qid=1674883346&sr=8-10\\r\\n32,Brand coocaa,coocaa 80 cm (32 inches) Frameless Series HD Ready Smart IPS LED TV 32S3U Pro (Black),\"-76%\\n₹8,999\\nM.R.P.:\\n₹36,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfbXRmOjIwMTEwNDQ3NjIwMzk4OjowOjo&url=%2Fcoocaa-inches-Frameless-32S3U-Pro%2Fdp%2FB0B45VT3WK%2Fref%3Dsr_1_11_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-11-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9tdGY%26psc%3D1\\r\\n33,Brand Samsung,Samsung 80 cm (32 Inches) Wondertainment Series HD Ready LED Smart TV UA32T4340BKXXL (Glossy Black),\"-41%\\n₹13,490\\nM.R.P.:\\n₹22,900\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfbXRmOjIwMDUyNTkyOTM1MDk4OjowOjo&url=%2FSamsung-Inches-Wondertainment-UA32T4340BKXXL-Glossy%2Fdp%2FB09F6S8BT6%2Fref%3Dsr_1_12_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-12-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9tdGY%26psc%3D1\\r\\n34,Brand Acer,Acer 109 cm (43 inches) I Series 4K Ultra HD Android Smart LED TV AR43AR2851UDFL (Black),\"-34%\\n₹22,999\\nM.R.P.:\\n₹34,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR43AR2851UDFL/dp/B0B1YY6JJL/ref=sr_1_13?keywords=Smart+TV&qid=1674883346&sr=8-13\\r\\n35,Brand Acer,Acer 139 cm (55 inches) I Series 4K Ultra HD Android Smart LED TV AR55AR2851UDFL (Black),\"-37%\\n₹29,999\\nM.R.P.:\\n₹47,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR55AR2851UDFL/dp/B0B1YZ9CB8/ref=sr_1_14?keywords=Smart+TV&qid=1674883346&sr=8-14\\r\\n36,Brand MI,Mi 80 cm (32 inches) Horizon Edition HD Ready Android Smart LED TV 4A | L32M6-EI (Grey),\"-40%\\n₹11,999\\nM.R.P.:\\n₹19,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/inches-Horizon-Ready-Android-L32M6-EI/dp/B08WPPDFLD/ref=sr_1_15?keywords=Smart+TV&qid=1674883346&sr=8-15\\r\\n37,Brand Redmi,Redmi 108 cm (43 inches) 4K Ultra HD Android Smart LED TV X43 | L43R7-7AIN (Black),\"-37%\\n₹26,999\\nM.R.P.:\\n₹42,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Redmi-inches-Ultra-Android-L43R7-7AIN/dp/B09RFC46VP/ref=sr_1_16?keywords=Smart+TV&qid=1674883346&sr=8-16\\r\\n38,Brand VW,VW 60 cm (24 inches) HD Ready Smart LED TV VW24S (Black) (2021 Model),\"-43%\\n₹6,799\\nM.R.P.:\\n₹11,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/inches-Ready-Smart-VW24S-Black/dp/B08Z35H8L6/ref=sr_1_17?keywords=Smart+TV&qid=1674883346&sr=8-17\\r\\n39,Brand OnePlus,OnePlus 108 cm (43 inches) Y Series Full HD Smart Android LED TV 43 Y1S (Black),\"-22%\\n₹24,999\\nM.R.P.:\\n₹31,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-inches-Smart-Android-Black/dp/B09Q5P2MT3/ref=sr_1_18?keywords=Smart+TV&qid=1674883346&sr=8-18\\r\\n40,Brand OnePlus,OnePlus 108 cm (43 inches) Y Series 4K Ultra HD Smart Android LED TV 43Y1S Pro (Black),\"-25%\\n₹29,999\\nM.R.P.:\\n₹39,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-43-inches-Android-Pro/dp/B09VCHLSJF/ref=sr_1_19?keywords=Smart+TV&qid=1674883346&sr=8-19\\r\\n41,Brand iFFALCON,iFFALCON 80 cm (32 inches) HD Ready Smart LED TV 32F53 (Black),\"-64%\\n₹9,999\\nM.R.P.:\\n₹27,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/iFFALCON-inches-Ready-Smart-TV-32F53/dp/B09X1M3DHX/ref=sr_1_20?keywords=Smart+TV&qid=1674883346&sr=8-20\\r\\n42,Brand MI,MI 108 cm (43 inches) 5A Series Full HD Smart Android LED TV L43M7-EAIN (Black),\"-31%\\n₹24,999\\nM.R.P.:\\n₹35,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYnRmOjIwMDgwMjY4NTU1Njk4OjowOjo&url=%2FMI-inches-Smart-Android-L43M7-EAIN%2Fdp%2FB0B6F8HHR6%2Fref%3Dsr_1_21_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-21-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9idGY%26psc%3D1\\r\\n43,Brand AmazonBasics,AmazonBasics 81cm (32 inches) Fire TV Edition HD Ready Smart LED TV AB32E10SS (Black),\"-54%\\n₹12,299\\nM.R.P.:\\n₹27,000\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYnRmOjIwMDQ2MTYyNDEwNzk4OjowOjo&url=%2FAmazonBasics-80cm-inch-Smart-LED%2Fdp%2FB087JX4TT4%2Fref%3Dsr_1_22_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-22-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9idGY%26psc%3D1\\r\\n44,Brand Kodak,Kodak 98 cm (40 inches) Full HD Certified Android LED TV 40FHDX7XPRO (Black),\"-42%\\n₹14,499\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYXRmOjIwMDU2NTMyMTQ5NDAxOjowOjo&url=%2FKodak-Inches-Certified-Android-40FHDX7XPRO%2Fdp%2FB08CS2SRVQ%2Fref%3Dsr_1_1_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-1-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9hdGY%26psc%3D1\\r\\n45,Brand Redmi,Redmi 80 cm (32 inches) Android 11 Series HD Ready Smart LED TV | L32M6-RA/L32M7-RA (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYXRmOjIwMDY2ODE0NjkzNTk4OjowOjo&url=%2FRedmi-inches-Ready-L32M6-RA-Android%2Fdp%2FB09F9YQQ7B%2Fref%3Dsr_1_2_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-2-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9hdGY%26psc%3D1\\r\\n46,Brand OnePlus,OnePlus 80 cm (32 inches) Y Series HD Ready LED Smart Android TV 32Y1 (Black),\"-25%\\n₹14,999\\nM.R.P.:\\n₹19,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-inches-Ready-Android-32Y1/dp/B08B42LWKN/ref=sr_1_3?keywords=Smart+TV&qid=1674883346&sr=8-3\\r\\n47,Brand Redmi,Redmi 80 cm (32 inches) Android 11 Series HD Ready Smart LED TV | L32M6-RA/L32M7-RA (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Redmi-inches-Ready-L32M6-RA-Android/dp/B09F9YQQ7B/ref=sr_1_4?keywords=Smart+TV&qid=1674883346&sr=8-4\\r\\n48,Brand VW,VW 80 cm (32 inches) HD Ready Android Smart LED TV VW32S (Black),\"-53%\\n₹7,999\\nM.R.P.:\\n₹16,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/Visio-World-inches-VW32S-Ready/dp/B07MNNH484/ref=sr_1_5?keywords=Smart+TV&qid=1674883346&sr=8-5\\r\\n49,Brand Acer,Acer 80 cm (32 inches) I Series HD Ready Android Smart LED TV AR32AR2841HDFL (Black),\"-45%\\n₹10,999\\nM.R.P.:\\n₹19,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ready-Android-AR32AR2841HDFL/dp/B0B1YVCJ2Y/ref=sr_1_6?keywords=Smart+TV&qid=1674883346&sr=8-6\\r\\n50,Brand Samsung,Samsung 80 cm (32 Inches) Wondertainment Series HD Ready LED Smart TV UA32T4340BKXXL (Glossy Black),\"-41%\\n₹13,490\\nM.R.P.:\\n₹22,900\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/Samsung-Inches-Wondertainment-UA32T4340BKXXL-Glossy/dp/B09F6S8BT6/ref=sr_1_7?keywords=Smart+TV&qid=1674883346&sr=8-7\\r\\n51,Brand VW,VW 80 cm (32 inches) Linux Series Frameless HD Ready Smart LED TV VW32C2 (Black),\"-53%\\n₹7,999\\nM.R.P.:\\n₹16,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/VW-inches-Linux-Frameless-VW32C2/dp/B0BQZQ3QTV/ref=sr_1_8?keywords=Smart+TV&qid=1674883346&sr=8-8\\r\\n52,Brand MI,MI 80 cm (32 inches) 5A Series HD Ready Smart Android LED TV L32M7-5AIN (Black),\"-44%\\n₹13,999\\nM.R.P.:\\n₹24,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/MI-inches-Ready-Android-L32M7-5AIN/dp/B0B6F7LX4C/ref=sr_1_9?keywords=Smart+TV&qid=1674883346&sr=8-9\\r\\n53,Brand Acer,Acer 127 cm (50 inches) I Series 4K Ultra HD Android Smart LED TV AR50AR2851UDFL (Black),\"-34%\\n₹26,999\\nM.R.P.:\\n₹40,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR50AR2851UDFL/dp/B0B1YZX72F/ref=sr_1_10?keywords=Smart+TV&qid=1674883346&sr=8-10\\r\\n54,Brand coocaa,coocaa 80 cm (32 inches) Frameless Series HD Ready Smart IPS LED TV 32S3U Pro (Black),\"-76%\\n₹8,999\\nM.R.P.:\\n₹36,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfbXRmOjIwMTEwNDQ3NjIwMzk4OjowOjo&url=%2Fcoocaa-inches-Frameless-32S3U-Pro%2Fdp%2FB0B45VT3WK%2Fref%3Dsr_1_11_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-11-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9tdGY%26psc%3D1\\r\\n55,Brand Samsung,Samsung 80 cm (32 Inches) Wondertainment Series HD Ready LED Smart TV UA32T4340BKXXL (Glossy Black),\"-41%\\n₹13,490\\nM.R.P.:\\n₹22,900\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfbXRmOjIwMDUyNTkyOTM1MDk4OjowOjo&url=%2FSamsung-Inches-Wondertainment-UA32T4340BKXXL-Glossy%2Fdp%2FB09F6S8BT6%2Fref%3Dsr_1_12_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-12-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9tdGY%26psc%3D1\\r\\n56,Brand Acer,Acer 109 cm (43 inches) I Series 4K Ultra HD Android Smart LED TV AR43AR2851UDFL (Black),\"-34%\\n₹22,999\\nM.R.P.:\\n₹34,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR43AR2851UDFL/dp/B0B1YY6JJL/ref=sr_1_13?keywords=Smart+TV&qid=1674883346&sr=8-13\\r\\n57,Brand Acer,Acer 139 cm (55 inches) I Series 4K Ultra HD Android Smart LED TV AR55AR2851UDFL (Black),\"-37%\\n₹29,999\\nM.R.P.:\\n₹47,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Acer-inches-Ultra-Android-AR55AR2851UDFL/dp/B0B1YZ9CB8/ref=sr_1_14?keywords=Smart+TV&qid=1674883346&sr=8-14\\r\\n58,Brand MI,Mi 80 cm (32 inches) Horizon Edition HD Ready Android Smart LED TV 4A | L32M6-EI (Grey),\"-40%\\n₹11,999\\nM.R.P.:\\n₹19,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/inches-Horizon-Ready-Android-L32M6-EI/dp/B08WPPDFLD/ref=sr_1_15?keywords=Smart+TV&qid=1674883346&sr=8-15\\r\\n59,Brand Redmi,Redmi 108 cm (43 inches) 4K Ultra HD Android Smart LED TV X43 | L43R7-7AIN (Black),\"-37%\\n₹26,999\\nM.R.P.:\\n₹42,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/Redmi-inches-Ultra-Android-L43R7-7AIN/dp/B09RFC46VP/ref=sr_1_16?keywords=Smart+TV&qid=1674883346&sr=8-16\\r\\n60,Brand VW,VW 60 cm (24 inches) HD Ready Smart LED TV VW24S (Black) (2021 Model),\"-43%\\n₹6,799\\nM.R.P.:\\n₹11,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/inches-Ready-Smart-VW24S-Black/dp/B08Z35H8L6/ref=sr_1_17?keywords=Smart+TV&qid=1674883346&sr=8-17\\r\\n61,Brand OnePlus,OnePlus 108 cm (43 inches) Y Series Full HD Smart Android LED TV 43 Y1S (Black),\"-22%\\n₹24,999\\nM.R.P.:\\n₹31,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-inches-Smart-Android-Black/dp/B09Q5P2MT3/ref=sr_1_18?keywords=Smart+TV&qid=1674883346&sr=8-18\\r\\n62,Brand OnePlus,OnePlus 108 cm (43 inches) Y Series 4K Ultra HD Smart Android LED TV 43Y1S Pro (Black),\"-25%\\n₹29,999\\nM.R.P.:\\n₹39,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/OnePlus-43-inches-Android-Pro/dp/B09VCHLSJF/ref=sr_1_19?keywords=Smart+TV&qid=1674883346&sr=8-19\\r\\n63,Brand iFFALCON,iFFALCON 80 cm (32 inches) HD Ready Smart LED TV 32F53 (Black),\"-64%\\n₹9,999\\nM.R.P.:\\n₹27,990\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 11 AM - 9 PM. Details\",https://www.amazon.in/iFFALCON-inches-Ready-Smart-TV-32F53/dp/B09X1M3DHX/ref=sr_1_20?keywords=Smart+TV&qid=1674883346&sr=8-20\\r\\n64,Brand MI,MI 108 cm (43 inches) 5A Series Full HD Smart Android LED TV L43M7-EAIN (Black),\"-31%\\n₹24,999\\nM.R.P.:\\n₹35,999\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYnRmOjIwMDgwMjY4NTU1Njk4OjowOjo&url=%2FMI-inches-Smart-Android-L43M7-EAIN%2Fdp%2FB0B6F8HHR6%2Fref%3Dsr_1_21_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-21-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9idGY%26psc%3D1\\r\\n65,Brand AmazonBasics,AmazonBasics 81cm (32 inches) Fire TV Edition HD Ready Smart LED TV AB32E10SS (Black),\"-54%\\n₹12,299\\nM.R.P.:\\n₹27,000\",In stock.,\"FREE scheduled delivery as soon as Monday, 30 January, 10 AM - 7 PM. Details\",https://www.amazon.in/sspa/click?ie=UTF8&spc=MTo4ODIzMjA1MjAyODc1MzAxOjE2NzQ4ODMzNDY6c3BfYnRmOjIwMDQ2MTYyNDEwNzk4OjowOjo&url=%2FAmazonBasics-80cm-inch-Smart-LED%2Fdp%2FB087JX4TT4%2Fref%3Dsr_1_22_sspa%3Fkeywords%3DSmart%2BTV%26qid%3D1674883346%26sr%3D8-22-spons%26sp_csd%3Dd2lkZ2V0TmFtZT1zcF9idGY%26psc%3D1\\r\\n'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "WSAmazon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "be7ad740",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d0a63d6c",
   "metadata": {},
   "outputs": [],
   "source": [
    "#*************************************\n",
    "#3. Google Images\n",
    "#*************************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "1f0e3b5a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.common.exceptions import StaleElementReferenceException , NoSuchElementException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "62113cc8",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "feb1ff3f",
   "metadata": {},
   "outputs": [],
   "source": [
    "images = ['Fruits' , 'Car' , 'Machine Learning' , 'Guitar' , 'Cake']\n",
    "    \n",
    "for i in images:\n",
    "    driver.get('http://www.images.google.com/')\n",
    "    time.sleep(5)\n",
    "    \n",
    "  \n",
    "    \n",
    "\n",
    "    img =driver.find_element(By.XPATH,\"/html/body/div[1]/div[3]/form/div[1]/div[1]/div[1]/div/div[2]/input\")\n",
    "    img.send_keys(i)\n",
    "    \n",
    "    search=driver.find_element(By.XPATH,\"/html/body/div[1]/div[3]/form/div[1]/div[1]/div[1]/button\")\n",
    "    search.click()\n",
    "    \n",
    "    if i == images[0]:\n",
    "        Url0 =[]\n",
    "        url0=driver.find_elements(By.TAG_NAME, 'img')\n",
    "        for i in url0:\n",
    "            try:\n",
    "                U = (i.get_attribute('src'))\n",
    "                Url0.append(U)\n",
    "            except:\n",
    "                Url0.append(\"-\")\n",
    "    elif i == images[1]:\n",
    "        Url1 =[]\n",
    "        url1=driver.find_elements(By.TAG_NAME, 'img')\n",
    "        for i in url1:\n",
    "            try:\n",
    "                U = (i.get_attribute('src'))\n",
    "                Url1.append(U)\n",
    "            except:\n",
    "                Url1.append(\"-\")\n",
    "    elif i == images[2]:\n",
    "        Url2 =[]\n",
    "        url2=driver.find_elements(By.TAG_NAME, 'img')\n",
    "        for i in url2:\n",
    "            try:\n",
    "                U = (i.get_attribute('src'))\n",
    "                Url2.append(U)\n",
    "            except:\n",
    "                Url2.append(\"-\")\n",
    "    elif i == images[3]:\n",
    "        Url3 =[]\n",
    "        url3=driver.find_elements(By.TAG_NAME, 'img')\n",
    "        for i in url3:\n",
    "            try:\n",
    "                U = (i.get_attribute('src'))\n",
    "                Url3.append(U)\n",
    "            except:\n",
    "                Url3.append(\"-\")\n",
    "                \n",
    "    else:\n",
    "        Url4 =[]\n",
    "        url4=driver.find_elements(By.TAG_NAME, 'img')\n",
    "        for i in url4:\n",
    "            try:\n",
    "                U = (i.get_attribute('src'))\n",
    "                Url4.append(U)\n",
    "            except:\n",
    "                Url4.append(\"-\")\n",
    "    \n",
    "        \n",
    "    \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "8e2fd40b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 10 10 10 10\n"
     ]
    }
   ],
   "source": [
    "Fruits = Url0[5:15]\n",
    "Cars = Url1[5:15]\n",
    "MachineLearning = Url2[5:15]\n",
    "Guitar = Url3[5:15]\n",
    "Cakes = Url4[5:15]\n",
    "\n",
    "print (len(Fruits),len(Cars),len(MachineLearning),len(Guitar),len(Cakes))\n",
    "  \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "fbf8761e",
   "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>Fruits</th>\n",
       "      <th>Cars</th>\n",
       "      <th>Machine Learning</th>\n",
       "      <th>Guitar</th>\n",
       "      <th>Cakes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "      <td>data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Fruits  \\\n",
       "0  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "1  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "2  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "3  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "4  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "5  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "6  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "7  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "8  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "9  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "\n",
       "                                                Cars  \\\n",
       "0  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "1  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "2  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "3  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "4  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "5  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "6  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "7  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "8  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "9  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "\n",
       "                                    Machine Learning  \\\n",
       "0  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "1  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "2  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "3  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "4  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "5  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "6  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "7  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "8  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "9  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "\n",
       "                                              Guitar  \\\n",
       "0  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "1  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "2  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "3  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "4  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "5  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "6  data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAA...   \n",
       "7  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "8  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "9  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...   \n",
       "\n",
       "                                               Cakes  \n",
       "0  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "1  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "2  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "3  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "4  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "5  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "6  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "7  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "8  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  \n",
       "9  data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQA...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Image_urls = pd.DataFrame({'Fruits':Fruits,'Cars':Cars,'Machine Learning':MachineLearning,'Guitar':Guitar,'Cakes':Cakes})\n",
    "Image_urls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0fea60b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "113e42a8",
   "metadata": {},
   "outputs": [],
   "source": [
    "#**********************************\n",
    "#4.Flipkart SmartPhone\n",
    "#*********************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "91c96b91",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.common.exceptions import StaleElementReferenceException , NoSuchElementException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c378d10e",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "24631ee6",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get('http://www.flipkart.com/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "64f2bb5b",
   "metadata": {},
   "outputs": [],
   "source": [
    "close =driver.find_element(By.XPATH,\"/html/body/div[2]/div/div/button\")\n",
    "close.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "527be1ea",
   "metadata": {},
   "outputs": [],
   "source": [
    "product = driver.find_element(By.XPATH,\"/html/body/div[1]/div/div[1]/div[1]/div[2]/div[2]/form/div/div/input\")\n",
    "product.send_keys('Motorola Edge30')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "e67d8f1e",
   "metadata": {},
   "outputs": [],
   "source": [
    "search = driver.find_element(By.XPATH,\"/html/body/div[1]/div/div[1]/div[1]/div[2]/div[2]/form/div/button\")\n",
    "search.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "477e3d72",
   "metadata": {},
   "outputs": [],
   "source": [
    "P_name = []\n",
    "\n",
    "p_name=driver.find_elements(By.XPATH, '//div[@class=\"_4rR01T\"]')\n",
    "for x in p_name:\n",
    "    pn = (x.text)\n",
    "    if pn == (\"\"):\n",
    "        P_name.append('-')\n",
    "    else:\n",
    "        P_name.append(x.text.split(' '))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "0b2a52cd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['MOTOROLA', 'Edge', '30', '(Meteor', 'Grey,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'edge', '30', '(Meteor', 'Grey,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', '(Aurora', 'Green,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'edge', '30', '(Aurora', 'Green,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Fusion', '(Solar', 'Gold,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Fusion', '(Viva', 'Magenta,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Fusion', '(Cosmic', 'grey,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Pro', '(Cosmos', 'Blue,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Ultra', '(Interstellar', 'Black,', '256', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Pro', '(Stardust', 'White,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Ultra', '(Interstellar', 'Black,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Ultra', '(Starlight', 'White,', '128', 'GB)'],\n",
       " ['MOTOROLA', 'Edge', '30', 'Ultra', '(Starlight', 'White,', '256', 'GB)'],\n",
       " ['MOTOROLA', 'G30', '(Dark', 'Pearl,', '64', 'GB)'],\n",
       " ['MOTOROLA', 'G30', '(Pastel', 'Sky,', '64', 'GB)']]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "P_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2eaedf7a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "376f9b96",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA',\n",
       " 'MOTOROLA']"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Brand=[]\n",
    "for i in range(0,15):\n",
    "    B = P_name[i][0]\n",
    "    Brand.append(B)\n",
    "Brand\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "70be2af1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Meteor Grey,',\n",
       " 'Meteor Grey,',\n",
       " 'Aurora Green,',\n",
       " 'Aurora Green,',\n",
       " 'Solar Gold,',\n",
       " 'Viva Magenta,',\n",
       " 'Cosmic grey,',\n",
       " 'Cosmos Blue,',\n",
       " 'Interstellar Black,',\n",
       " 'Stardust White,',\n",
       " 'Interstellar Black,',\n",
       " 'Starlight White,',\n",
       " 'Starlight White,',\n",
       " 'Dark Pearl,',\n",
       " 'Pastel Sky,']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Colour =[]\n",
    "for i in range(0,15):\n",
    "    c = P_name[i][-4] +\" \" + P_name[i][-3]\n",
    "    Colour.append(c.strip('('))\n",
    "Colour\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "b8d0fa53",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['MOTOROLA Edge 30 (Meteor Grey, 128 GB)',\n",
       " 'MOTOROLA edge 30 (Meteor Grey, 128 GB)',\n",
       " 'MOTOROLA Edge 30 (Aurora Green, 128 GB)',\n",
       " 'MOTOROLA edge 30 (Aurora Green, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Fusion (Solar Gold, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Fusion (Viva Magenta, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Fusion (Cosmic grey, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Pro (Cosmos Blue, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Ultra (Interstellar Black, 256 GB)',\n",
       " 'MOTOROLA Edge 30 Pro (Stardust White, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Ultra (Interstellar Black, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Ultra (Starlight White, 128 GB)',\n",
       " 'MOTOROLA Edge 30 Ultra (Starlight White, 256 GB)',\n",
       " 'MOTOROLA G30 (Dark Pearl, 64 GB)',\n",
       " 'MOTOROLA G30 (Pastel Sky, 64 GB)']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Name=[]\n",
    "name=driver.find_elements(By.XPATH, '//div[@class=\"_4rR01T\"]')\n",
    "for x in name:\n",
    "    n = (x.text)\n",
    "    if n == (\"\"):\n",
    "        Name.append('-')\n",
    "    else:\n",
    "        Name.append(x.text)\n",
    "Name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b0d420de",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['8 GB RAM | 128 GB ROM',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '50MP + 50MP + 2MP | 32MP Front Camera',\n",
       " '4020 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 778G Plus Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '6 GB RAM | 128 GB ROM',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '50MP + 50MP + 2MP | 32MP Front Camera',\n",
       " '4020 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 778G Plus Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '50MP + 50MP + 2MP | 32MP Front Camera',\n",
       " '4020 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 778G Plus Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '6 GB RAM | 128 GB ROM',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '50MP + 50MP + 2MP | 32MP Front Camera',\n",
       " '4020 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 778G Plus Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '50MP + 13MP + 2MP | 32MP Front Camera',\n",
       " '4400 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 888 + Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '50MP + 13MP + 2MP | 32MP Front Camera',\n",
       " '4400 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 888 + Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '50MP + 13MP + 2MP | 32MP Front Camera',\n",
       " '4400 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 888 + Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '17.02 cm (6.7 inch) Full HD+ AMOLED Display',\n",
       " '50MP + 50MP + 2MP | 60MP Front Camera',\n",
       " '4800 mAh Lithium Polymer Battery',\n",
       " 'Qualcomm Snapdragon 8 Gen 1 Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '12 GB RAM | 256 GB ROM',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '200MP + 50MP + 12MP | 60MP Front Camera',\n",
       " '4610 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 8+ Gen 1 Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '17.02 cm (6.7 inch) Full HD+ AMOLED Display',\n",
       " '50MP + 50MP + 2MP | 60MP Front Camera',\n",
       " '4800 mAh Lithium Polymer Battery',\n",
       " 'Qualcomm Snapdragon 8 Gen 1 Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '200MP + 50MP + 12MP | 60MP Front Camera',\n",
       " '4610 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 8+ Gen 1 Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '8 GB RAM | 128 GB ROM',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '200MP + 50MP + 12MP | 60MP Front Camera',\n",
       " '4610 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 8+ Gen 1 Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '12 GB RAM | 256 GB ROM',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '200MP + 50MP + 12MP | 60MP Front Camera',\n",
       " '4610 mAh Lithium Battery',\n",
       " 'Qualcomm Snapdragon 8+ Gen 1 Processor',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '4 GB RAM | 64 GB ROM',\n",
       " '16.54 cm (6.51 inch) HD+ Display',\n",
       " '64MP + 8MP + 2MP + 2MP | 13MP Front Camera',\n",
       " '5000 mAh Battery',\n",
       " 'Snapdragon 662 Processor',\n",
       " 'Stock Android Experience | 90Hz Refresh Rate',\n",
       " '1 Year on Handset and 6 Months on Accessories',\n",
       " '4 GB RAM | 64 GB ROM',\n",
       " '16.54 cm (6.51 inch) HD+ Display',\n",
       " '64MP + 8MP + 2MP + 2MP | 13MP Front Camera',\n",
       " '5000 mAh Battery',\n",
       " 'Snapdragon 662 Processor',\n",
       " 'Stock Android Experience | 90Hz Refresh Rate',\n",
       " '1 Year on Handset and 6 Months on Accessories']"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Info=[]\n",
    "info=driver.find_elements(By.XPATH, '//li[@class=\"rgWa7D\"]')\n",
    "for x in info:\n",
    "    i = (x.text)\n",
    "    Info.append(i)\n",
    "Info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "97ab3373",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['8 GB RAM ',\n",
       " '6 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '6 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '12 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '8 GB RAM ',\n",
       " '12 GB RAM ',\n",
       " '4 GB RAM ',\n",
       " '4 GB RAM ']"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "RAM=[]\n",
    "for i in Info:\n",
    "    if 'RAM' in i:\n",
    "        RAM.append(i.split('|')[0])\n",
    "RAM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "44b5e8b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 256 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 128 GB ROM',\n",
       " ' 256 GB ROM',\n",
       " ' 64 GB ROM',\n",
       " ' 64 GB ROM']"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ROM=[]\n",
    "for i in Info:\n",
    "    if 'ROM' in i:\n",
    "        ROM.append(i.split('|')[1])\n",
    "ROM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "33bb4b06",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['50MP + 50MP + 2MP ',\n",
       " '50MP + 50MP + 2MP ',\n",
       " '50MP + 50MP + 2MP ',\n",
       " '50MP + 50MP + 2MP ',\n",
       " '50MP + 13MP + 2MP ',\n",
       " '50MP + 13MP + 2MP ',\n",
       " '50MP + 13MP + 2MP ',\n",
       " '50MP + 50MP + 2MP ',\n",
       " '200MP + 50MP + 12MP ',\n",
       " '50MP + 50MP + 2MP ',\n",
       " '200MP + 50MP + 12MP ',\n",
       " '200MP + 50MP + 12MP ',\n",
       " '200MP + 50MP + 12MP ',\n",
       " '64MP + 8MP + 2MP + 2MP ',\n",
       " '64MP + 8MP + 2MP + 2MP ']"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "P_Cam=[]\n",
    "for i in Info:\n",
    "    if 'MP' in i:\n",
    "        P_Cam.append(i.split('|')[0])\n",
    "P_Cam"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e962631a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[' 32MP Front Camera',\n",
       " ' 32MP Front Camera',\n",
       " ' 32MP Front Camera',\n",
       " ' 32MP Front Camera',\n",
       " ' 32MP Front Camera',\n",
       " ' 32MP Front Camera',\n",
       " ' 32MP Front Camera',\n",
       " ' 60MP Front Camera',\n",
       " ' 60MP Front Camera',\n",
       " ' 60MP Front Camera',\n",
       " ' 60MP Front Camera',\n",
       " ' 60MP Front Camera',\n",
       " ' 60MP Front Camera',\n",
       " ' 13MP Front Camera',\n",
       " ' 13MP Front Camera']"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "S_Cam=[]\n",
    "for i in Info:\n",
    "    if 'MP' in i:\n",
    "        S_Cam.append(i.split('|')[1])\n",
    "S_Cam"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6fa8121c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '16.64 cm (6.55 inch) Full HD+ Display',\n",
       " '17.02 cm (6.7 inch) Full HD+ AMOLED Display',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '17.02 cm (6.7 inch) Full HD+ AMOLED Display',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '16.94 cm (6.67 inch) Full HD+ Display',\n",
       " '16.54 cm (6.51 inch) HD+ Display',\n",
       " '16.54 cm (6.51 inch) HD+ Display']"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Display=[]\n",
    "for i in Info:\n",
    "    if 'Display' in i:\n",
    "        Display.append(i)\n",
    "Display"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "12646438",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['4020 mAh Lithium Battery',\n",
       " '4020 mAh Lithium Battery',\n",
       " '4020 mAh Lithium Battery',\n",
       " '4020 mAh Lithium Battery',\n",
       " '4400 mAh Lithium Battery',\n",
       " '4400 mAh Lithium Battery',\n",
       " '4400 mAh Lithium Battery',\n",
       " '4800 mAh Lithium Polymer Battery',\n",
       " '4610 mAh Lithium Battery',\n",
       " '4800 mAh Lithium Polymer Battery',\n",
       " '4610 mAh Lithium Battery',\n",
       " '4610 mAh Lithium Battery',\n",
       " '4610 mAh Lithium Battery',\n",
       " '5000 mAh Battery',\n",
       " '5000 mAh Battery']"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Battery = []\n",
    "for i in Info:\n",
    "    if 'Battery' in i:\n",
    "        Battery.append(i)\n",
    "Battery"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "2f3b01d3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['₹24,999',\n",
       " '₹22,999',\n",
       " '₹24,999',\n",
       " '₹22,999',\n",
       " '₹39,999',\n",
       " '₹39,999',\n",
       " '₹39,999',\n",
       " '₹34,999',\n",
       " '₹59,999',\n",
       " '₹34,999',\n",
       " '₹54,999',\n",
       " '₹54,999',\n",
       " '₹59,999',\n",
       " '₹10,999',\n",
       " '₹10,999']"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Price = []\n",
    "\n",
    "price=driver.find_elements(By.XPATH, '//div[@class=\"_30jeq3 _1_WHN1\"]')\n",
    "for x in price:\n",
    "    p = (x.text)\n",
    "    if p == (\"\"):\n",
    "        Price.append('-')\n",
    "    else:\n",
    "        Price.append(p)\n",
    "Price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "90ce2808",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.flipkart.com/motorola-edge-30-meteor-grey-128-gb/p/itmb93fab2af209f?pid=MOBGAKFYPFFYGUTP&lid=LSTMOBGAKFYPFFYGUTPQXPLKW&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&spotlightTagId=BestvalueId_tyy%2F4io&srno=s_1_1&otracker=search&otracker1=search&fm=Search&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGAKFYPFFYGUTP.SEARCH&ppt=sp&ppn=sp&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-meteor-grey-128-gb/p/itma02c4f5bca2df?pid=MOBGDCYGCZCYGYYZ&lid=LSTMOBGDCYGCZCYGYYZDNNWFQ&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_2&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGDCYGCZCYGYYZ.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-aurora-green-128-gb/p/itm365d09ff88e9f?pid=MOBGAKFYXEMTSPWM&lid=LSTMOBGAKFYXEMTSPWMXPSBRO&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_3&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGAKFYXEMTSPWM.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-aurora-green-128-gb/p/itm819f84fdde956?pid=MOBGDCYGSKMGHQTA&lid=LSTMOBGDCYGSKMGHQTAEBOV0X&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_4&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGDCYGSKMGHQTA.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-fusion-solar-gold-128-gb/p/itm68ac494d3a503?pid=MOBGFGM2RYYQQASG&lid=LSTMOBGFGM2RYYQQASGDTY3A2&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_5&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2RYYQQASG.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-fusion-viva-magenta-128-gb/p/itmbd04903ac45f7?pid=MOBGKV3EFHKFRMRR&lid=LSTMOBGKV3EFHKFRMRRT73RCP&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_6&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGKV3EFHKFRMRR.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-fusion-cosmic-grey-128-gb/p/itmcc103ec39dbdf?pid=MOBGFGM2XEFCJYQF&lid=LSTMOBGFGM2XEFCJYQFLXCJS0&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_7&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2XEFCJYQF.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-pro-cosmos-blue-128-gb/p/itm98bcbdae6fe78?pid=MOBG9CKYHGJGWCXX&lid=LSTMOBG9CKYHGJGWCXXQKBD04&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_8&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBG9CKYHGJGWCXX.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-ultra-interstellar-black-256-gb/p/itm54434f08345f3?pid=MOBGGAPRC96YFDSH&lid=LSTMOBGGAPRC96YFDSHMNOKD5&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_9&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGGAPRC96YFDSH.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-pro-stardust-white-128-gb/p/itmc60ad815a2cbd?pid=MOBG9CKYEEUCNHUM&lid=LSTMOBG9CKYEEUCNHUMJDG8TW&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_10&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBG9CKYEEUCNHUM.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-ultra-interstellar-black-128-gb/p/itm36c69ef9d1313?pid=MOBGFGM2PHKKGB78&lid=LSTMOBGFGM2PHKKGB78NUNL0L&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_11&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2PHKKGB78.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-ultra-starlight-white-128-gb/p/itmfa7c7c01456e6?pid=MOBGFGM2GRYGBEPH&lid=LSTMOBGFGM2GRYGBEPHL5ASGI&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_12&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2GRYGBEPH.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-edge-30-ultra-starlight-white-256-gb/p/itm055386afc6641?pid=MOBGGAPR2KCFCTPT&lid=LSTMOBGGAPR2KCFCTPTHOXLPQ&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_13&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGGAPR2KCFCTPT.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-g30-dark-pearl-64-gb/p/itme5ae7fa01f345?pid=MOBFVXGZWDHJHQGZ&lid=LSTMOBFVXGZWDHJHQGZDMPNHC&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_14&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBFVXGZWDHJHQGZ.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0',\n",
       " 'https://www.flipkart.com/motorola-g30-pastel-sky-64-gb/p/itmc7ceaa1d753f4?pid=MOBFVXGZMHTXSHPN&lid=LSTMOBFVXGZMHTXSHPN2JNPQV&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_15&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBFVXGZMHTXSHPN.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0']"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "URL = []\n",
    "\n",
    "url=driver.find_elements(By.XPATH, '//a[@class=\"_1fQZEK\"]')\n",
    "for x in url:\n",
    "    u = (x.get_attribute('href'))\n",
    "    if u == (\"\"):\n",
    "        URL.append('-')\n",
    "    else:\n",
    "        URL.append(u)\n",
    "URL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "e57ce9a5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "15 15 15 15 15 15 15 15 15 15 15\n"
     ]
    }
   ],
   "source": [
    "print (len(Brand),len(Name),len(Colour),len(RAM),len(ROM),len(Display),len(P_Cam),len(S_Cam),len(Battery),len(Price),len(URL))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "3712e3f9",
   "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>Brand</th>\n",
       "      <th>Name</th>\n",
       "      <th>Colour</th>\n",
       "      <th>RAM</th>\n",
       "      <th>ROM</th>\n",
       "      <th>Display</th>\n",
       "      <th>Primary Camera</th>\n",
       "      <th>Secondary Camera</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Price</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 (Meteor Grey, 128 GB)</td>\n",
       "      <td>Meteor Grey,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.64 cm (6.55 inch) Full HD+ Display</td>\n",
       "      <td>50MP + 50MP + 2MP</td>\n",
       "      <td>32MP Front Camera</td>\n",
       "      <td>4020 mAh Lithium Battery</td>\n",
       "      <td>₹24,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-mete...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA edge 30 (Meteor Grey, 128 GB)</td>\n",
       "      <td>Meteor Grey,</td>\n",
       "      <td>6 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.64 cm (6.55 inch) Full HD+ Display</td>\n",
       "      <td>50MP + 50MP + 2MP</td>\n",
       "      <td>32MP Front Camera</td>\n",
       "      <td>4020 mAh Lithium Battery</td>\n",
       "      <td>₹22,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-mete...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 (Aurora Green, 128 GB)</td>\n",
       "      <td>Aurora Green,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.64 cm (6.55 inch) Full HD+ Display</td>\n",
       "      <td>50MP + 50MP + 2MP</td>\n",
       "      <td>32MP Front Camera</td>\n",
       "      <td>4020 mAh Lithium Battery</td>\n",
       "      <td>₹24,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-auro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA edge 30 (Aurora Green, 128 GB)</td>\n",
       "      <td>Aurora Green,</td>\n",
       "      <td>6 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.64 cm (6.55 inch) Full HD+ Display</td>\n",
       "      <td>50MP + 50MP + 2MP</td>\n",
       "      <td>32MP Front Camera</td>\n",
       "      <td>4020 mAh Lithium Battery</td>\n",
       "      <td>₹22,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-auro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Fusion (Solar Gold, 128 GB)</td>\n",
       "      <td>Solar Gold,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.64 cm (6.55 inch) Full HD+ Display</td>\n",
       "      <td>50MP + 13MP + 2MP</td>\n",
       "      <td>32MP Front Camera</td>\n",
       "      <td>4400 mAh Lithium Battery</td>\n",
       "      <td>₹39,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-fusi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Fusion (Viva Magenta, 128 GB)</td>\n",
       "      <td>Viva Magenta,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.64 cm (6.55 inch) Full HD+ Display</td>\n",
       "      <td>50MP + 13MP + 2MP</td>\n",
       "      <td>32MP Front Camera</td>\n",
       "      <td>4400 mAh Lithium Battery</td>\n",
       "      <td>₹39,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-fusi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Fusion (Cosmic grey, 128 GB)</td>\n",
       "      <td>Cosmic grey,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.64 cm (6.55 inch) Full HD+ Display</td>\n",
       "      <td>50MP + 13MP + 2MP</td>\n",
       "      <td>32MP Front Camera</td>\n",
       "      <td>4400 mAh Lithium Battery</td>\n",
       "      <td>₹39,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-fusi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Pro (Cosmos Blue, 128 GB)</td>\n",
       "      <td>Cosmos Blue,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>17.02 cm (6.7 inch) Full HD+ AMOLED Display</td>\n",
       "      <td>50MP + 50MP + 2MP</td>\n",
       "      <td>60MP Front Camera</td>\n",
       "      <td>4800 mAh Lithium Polymer Battery</td>\n",
       "      <td>₹34,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-pro-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Ultra (Interstellar Black, 25...</td>\n",
       "      <td>Interstellar Black,</td>\n",
       "      <td>12 GB RAM</td>\n",
       "      <td>256 GB ROM</td>\n",
       "      <td>16.94 cm (6.67 inch) Full HD+ Display</td>\n",
       "      <td>200MP + 50MP + 12MP</td>\n",
       "      <td>60MP Front Camera</td>\n",
       "      <td>4610 mAh Lithium Battery</td>\n",
       "      <td>₹59,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-ultr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Pro (Stardust White, 128 GB)</td>\n",
       "      <td>Stardust White,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>17.02 cm (6.7 inch) Full HD+ AMOLED Display</td>\n",
       "      <td>50MP + 50MP + 2MP</td>\n",
       "      <td>60MP Front Camera</td>\n",
       "      <td>4800 mAh Lithium Polymer Battery</td>\n",
       "      <td>₹34,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-pro-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Ultra (Interstellar Black, 12...</td>\n",
       "      <td>Interstellar Black,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.94 cm (6.67 inch) Full HD+ Display</td>\n",
       "      <td>200MP + 50MP + 12MP</td>\n",
       "      <td>60MP Front Camera</td>\n",
       "      <td>4610 mAh Lithium Battery</td>\n",
       "      <td>₹54,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-ultr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Ultra (Starlight White, 128 GB)</td>\n",
       "      <td>Starlight White,</td>\n",
       "      <td>8 GB RAM</td>\n",
       "      <td>128 GB ROM</td>\n",
       "      <td>16.94 cm (6.67 inch) Full HD+ Display</td>\n",
       "      <td>200MP + 50MP + 12MP</td>\n",
       "      <td>60MP Front Camera</td>\n",
       "      <td>4610 mAh Lithium Battery</td>\n",
       "      <td>₹54,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-ultr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA Edge 30 Ultra (Starlight White, 256 GB)</td>\n",
       "      <td>Starlight White,</td>\n",
       "      <td>12 GB RAM</td>\n",
       "      <td>256 GB ROM</td>\n",
       "      <td>16.94 cm (6.67 inch) Full HD+ Display</td>\n",
       "      <td>200MP + 50MP + 12MP</td>\n",
       "      <td>60MP Front Camera</td>\n",
       "      <td>4610 mAh Lithium Battery</td>\n",
       "      <td>₹59,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-edge-30-ultr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA G30 (Dark Pearl, 64 GB)</td>\n",
       "      <td>Dark Pearl,</td>\n",
       "      <td>4 GB RAM</td>\n",
       "      <td>64 GB ROM</td>\n",
       "      <td>16.54 cm (6.51 inch) HD+ Display</td>\n",
       "      <td>64MP + 8MP + 2MP + 2MP</td>\n",
       "      <td>13MP Front Camera</td>\n",
       "      <td>5000 mAh Battery</td>\n",
       "      <td>₹10,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-g30-dark-pea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>MOTOROLA</td>\n",
       "      <td>MOTOROLA G30 (Pastel Sky, 64 GB)</td>\n",
       "      <td>Pastel Sky,</td>\n",
       "      <td>4 GB RAM</td>\n",
       "      <td>64 GB ROM</td>\n",
       "      <td>16.54 cm (6.51 inch) HD+ Display</td>\n",
       "      <td>64MP + 8MP + 2MP + 2MP</td>\n",
       "      <td>13MP Front Camera</td>\n",
       "      <td>5000 mAh Battery</td>\n",
       "      <td>₹10,999</td>\n",
       "      <td>https://www.flipkart.com/motorola-g30-pastel-s...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Brand                                               Name  \\\n",
       "0   MOTOROLA             MOTOROLA Edge 30 (Meteor Grey, 128 GB)   \n",
       "1   MOTOROLA             MOTOROLA edge 30 (Meteor Grey, 128 GB)   \n",
       "2   MOTOROLA            MOTOROLA Edge 30 (Aurora Green, 128 GB)   \n",
       "3   MOTOROLA            MOTOROLA edge 30 (Aurora Green, 128 GB)   \n",
       "4   MOTOROLA       MOTOROLA Edge 30 Fusion (Solar Gold, 128 GB)   \n",
       "5   MOTOROLA     MOTOROLA Edge 30 Fusion (Viva Magenta, 128 GB)   \n",
       "6   MOTOROLA      MOTOROLA Edge 30 Fusion (Cosmic grey, 128 GB)   \n",
       "7   MOTOROLA         MOTOROLA Edge 30 Pro (Cosmos Blue, 128 GB)   \n",
       "8   MOTOROLA  MOTOROLA Edge 30 Ultra (Interstellar Black, 25...   \n",
       "9   MOTOROLA      MOTOROLA Edge 30 Pro (Stardust White, 128 GB)   \n",
       "10  MOTOROLA  MOTOROLA Edge 30 Ultra (Interstellar Black, 12...   \n",
       "11  MOTOROLA   MOTOROLA Edge 30 Ultra (Starlight White, 128 GB)   \n",
       "12  MOTOROLA   MOTOROLA Edge 30 Ultra (Starlight White, 256 GB)   \n",
       "13  MOTOROLA                   MOTOROLA G30 (Dark Pearl, 64 GB)   \n",
       "14  MOTOROLA                   MOTOROLA G30 (Pastel Sky, 64 GB)   \n",
       "\n",
       "                 Colour         RAM          ROM  \\\n",
       "0          Meteor Grey,   8 GB RAM    128 GB ROM   \n",
       "1          Meteor Grey,   6 GB RAM    128 GB ROM   \n",
       "2         Aurora Green,   8 GB RAM    128 GB ROM   \n",
       "3         Aurora Green,   6 GB RAM    128 GB ROM   \n",
       "4           Solar Gold,   8 GB RAM    128 GB ROM   \n",
       "5         Viva Magenta,   8 GB RAM    128 GB ROM   \n",
       "6          Cosmic grey,   8 GB RAM    128 GB ROM   \n",
       "7          Cosmos Blue,   8 GB RAM    128 GB ROM   \n",
       "8   Interstellar Black,  12 GB RAM    256 GB ROM   \n",
       "9       Stardust White,   8 GB RAM    128 GB ROM   \n",
       "10  Interstellar Black,   8 GB RAM    128 GB ROM   \n",
       "11     Starlight White,   8 GB RAM    128 GB ROM   \n",
       "12     Starlight White,  12 GB RAM    256 GB ROM   \n",
       "13          Dark Pearl,   4 GB RAM     64 GB ROM   \n",
       "14          Pastel Sky,   4 GB RAM     64 GB ROM   \n",
       "\n",
       "                                        Display           Primary Camera  \\\n",
       "0         16.64 cm (6.55 inch) Full HD+ Display       50MP + 50MP + 2MP    \n",
       "1         16.64 cm (6.55 inch) Full HD+ Display       50MP + 50MP + 2MP    \n",
       "2         16.64 cm (6.55 inch) Full HD+ Display       50MP + 50MP + 2MP    \n",
       "3         16.64 cm (6.55 inch) Full HD+ Display       50MP + 50MP + 2MP    \n",
       "4         16.64 cm (6.55 inch) Full HD+ Display       50MP + 13MP + 2MP    \n",
       "5         16.64 cm (6.55 inch) Full HD+ Display       50MP + 13MP + 2MP    \n",
       "6         16.64 cm (6.55 inch) Full HD+ Display       50MP + 13MP + 2MP    \n",
       "7   17.02 cm (6.7 inch) Full HD+ AMOLED Display       50MP + 50MP + 2MP    \n",
       "8         16.94 cm (6.67 inch) Full HD+ Display     200MP + 50MP + 12MP    \n",
       "9   17.02 cm (6.7 inch) Full HD+ AMOLED Display       50MP + 50MP + 2MP    \n",
       "10        16.94 cm (6.67 inch) Full HD+ Display     200MP + 50MP + 12MP    \n",
       "11        16.94 cm (6.67 inch) Full HD+ Display     200MP + 50MP + 12MP    \n",
       "12        16.94 cm (6.67 inch) Full HD+ Display     200MP + 50MP + 12MP    \n",
       "13             16.54 cm (6.51 inch) HD+ Display  64MP + 8MP + 2MP + 2MP    \n",
       "14             16.54 cm (6.51 inch) HD+ Display  64MP + 8MP + 2MP + 2MP    \n",
       "\n",
       "      Secondary Camera                           Battery    Price  \\\n",
       "0    32MP Front Camera          4020 mAh Lithium Battery  ₹24,999   \n",
       "1    32MP Front Camera          4020 mAh Lithium Battery  ₹22,999   \n",
       "2    32MP Front Camera          4020 mAh Lithium Battery  ₹24,999   \n",
       "3    32MP Front Camera          4020 mAh Lithium Battery  ₹22,999   \n",
       "4    32MP Front Camera          4400 mAh Lithium Battery  ₹39,999   \n",
       "5    32MP Front Camera          4400 mAh Lithium Battery  ₹39,999   \n",
       "6    32MP Front Camera          4400 mAh Lithium Battery  ₹39,999   \n",
       "7    60MP Front Camera  4800 mAh Lithium Polymer Battery  ₹34,999   \n",
       "8    60MP Front Camera          4610 mAh Lithium Battery  ₹59,999   \n",
       "9    60MP Front Camera  4800 mAh Lithium Polymer Battery  ₹34,999   \n",
       "10   60MP Front Camera          4610 mAh Lithium Battery  ₹54,999   \n",
       "11   60MP Front Camera          4610 mAh Lithium Battery  ₹54,999   \n",
       "12   60MP Front Camera          4610 mAh Lithium Battery  ₹59,999   \n",
       "13   13MP Front Camera                  5000 mAh Battery  ₹10,999   \n",
       "14   13MP Front Camera                  5000 mAh Battery  ₹10,999   \n",
       "\n",
       "                                                  URL  \n",
       "0   https://www.flipkart.com/motorola-edge-30-mete...  \n",
       "1   https://www.flipkart.com/motorola-edge-30-mete...  \n",
       "2   https://www.flipkart.com/motorola-edge-30-auro...  \n",
       "3   https://www.flipkart.com/motorola-edge-30-auro...  \n",
       "4   https://www.flipkart.com/motorola-edge-30-fusi...  \n",
       "5   https://www.flipkart.com/motorola-edge-30-fusi...  \n",
       "6   https://www.flipkart.com/motorola-edge-30-fusi...  \n",
       "7   https://www.flipkart.com/motorola-edge-30-pro-...  \n",
       "8   https://www.flipkart.com/motorola-edge-30-ultr...  \n",
       "9   https://www.flipkart.com/motorola-edge-30-pro-...  \n",
       "10  https://www.flipkart.com/motorola-edge-30-ultr...  \n",
       "11  https://www.flipkart.com/motorola-edge-30-ultr...  \n",
       "12  https://www.flipkart.com/motorola-edge-30-ultr...  \n",
       "13  https://www.flipkart.com/motorola-g30-dark-pea...  \n",
       "14  https://www.flipkart.com/motorola-g30-pastel-s...  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'Brand':Brand,'Name':Name,'Colour':Colour,'RAM':RAM,'ROM':ROM,'Display':Display,'Primary Camera':P_Cam,'Secondary Camera':S_Cam,'Battery':Battery,'Price':Price,'URL':URL})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "e11eb755",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "',Brand,Name,Colour,RAM,ROM,Display,Primary Camera,Secondary Camera,Battery,Price,URL\\r\\n0,MOTOROLA,\"MOTOROLA Edge 30 (Meteor Grey, 128 GB)\",\"Meteor Grey,\",8 GB RAM , 128 GB ROM,16.64 cm (6.55 inch) Full HD+ Display,50MP + 50MP + 2MP , 32MP Front Camera,4020 mAh Lithium Battery,\"₹24,999\",https://www.flipkart.com/motorola-edge-30-meteor-grey-128-gb/p/itmb93fab2af209f?pid=MOBGAKFYPFFYGUTP&lid=LSTMOBGAKFYPFFYGUTPQXPLKW&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&spotlightTagId=BestvalueId_tyy%2F4io&srno=s_1_1&otracker=search&otracker1=search&fm=Search&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGAKFYPFFYGUTP.SEARCH&ppt=sp&ppn=sp&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n1,MOTOROLA,\"MOTOROLA edge 30 (Meteor Grey, 128 GB)\",\"Meteor Grey,\",6 GB RAM , 128 GB ROM,16.64 cm (6.55 inch) Full HD+ Display,50MP + 50MP + 2MP , 32MP Front Camera,4020 mAh Lithium Battery,\"₹22,999\",https://www.flipkart.com/motorola-edge-30-meteor-grey-128-gb/p/itma02c4f5bca2df?pid=MOBGDCYGCZCYGYYZ&lid=LSTMOBGDCYGCZCYGYYZDNNWFQ&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_2&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGDCYGCZCYGYYZ.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n2,MOTOROLA,\"MOTOROLA Edge 30 (Aurora Green, 128 GB)\",\"Aurora Green,\",8 GB RAM , 128 GB ROM,16.64 cm (6.55 inch) Full HD+ Display,50MP + 50MP + 2MP , 32MP Front Camera,4020 mAh Lithium Battery,\"₹24,999\",https://www.flipkart.com/motorola-edge-30-aurora-green-128-gb/p/itm365d09ff88e9f?pid=MOBGAKFYXEMTSPWM&lid=LSTMOBGAKFYXEMTSPWMXPSBRO&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_3&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGAKFYXEMTSPWM.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n3,MOTOROLA,\"MOTOROLA edge 30 (Aurora Green, 128 GB)\",\"Aurora Green,\",6 GB RAM , 128 GB ROM,16.64 cm (6.55 inch) Full HD+ Display,50MP + 50MP + 2MP , 32MP Front Camera,4020 mAh Lithium Battery,\"₹22,999\",https://www.flipkart.com/motorola-edge-30-aurora-green-128-gb/p/itm819f84fdde956?pid=MOBGDCYGSKMGHQTA&lid=LSTMOBGDCYGSKMGHQTAEBOV0X&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_4&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGDCYGSKMGHQTA.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n4,MOTOROLA,\"MOTOROLA Edge 30 Fusion (Solar Gold, 128 GB)\",\"Solar Gold,\",8 GB RAM , 128 GB ROM,16.64 cm (6.55 inch) Full HD+ Display,50MP + 13MP + 2MP , 32MP Front Camera,4400 mAh Lithium Battery,\"₹39,999\",https://www.flipkart.com/motorola-edge-30-fusion-solar-gold-128-gb/p/itm68ac494d3a503?pid=MOBGFGM2RYYQQASG&lid=LSTMOBGFGM2RYYQQASGDTY3A2&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_5&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2RYYQQASG.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n5,MOTOROLA,\"MOTOROLA Edge 30 Fusion (Viva Magenta, 128 GB)\",\"Viva Magenta,\",8 GB RAM , 128 GB ROM,16.64 cm (6.55 inch) Full HD+ Display,50MP + 13MP + 2MP , 32MP Front Camera,4400 mAh Lithium Battery,\"₹39,999\",https://www.flipkart.com/motorola-edge-30-fusion-viva-magenta-128-gb/p/itmbd04903ac45f7?pid=MOBGKV3EFHKFRMRR&lid=LSTMOBGKV3EFHKFRMRRT73RCP&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_6&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGKV3EFHKFRMRR.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n6,MOTOROLA,\"MOTOROLA Edge 30 Fusion (Cosmic grey, 128 GB)\",\"Cosmic grey,\",8 GB RAM , 128 GB ROM,16.64 cm (6.55 inch) Full HD+ Display,50MP + 13MP + 2MP , 32MP Front Camera,4400 mAh Lithium Battery,\"₹39,999\",https://www.flipkart.com/motorola-edge-30-fusion-cosmic-grey-128-gb/p/itmcc103ec39dbdf?pid=MOBGFGM2XEFCJYQF&lid=LSTMOBGFGM2XEFCJYQFLXCJS0&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_7&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2XEFCJYQF.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n7,MOTOROLA,\"MOTOROLA Edge 30 Pro (Cosmos Blue, 128 GB)\",\"Cosmos Blue,\",8 GB RAM , 128 GB ROM,17.02 cm (6.7 inch) Full HD+ AMOLED Display,50MP + 50MP + 2MP , 60MP Front Camera,4800 mAh Lithium Polymer Battery,\"₹34,999\",https://www.flipkart.com/motorola-edge-30-pro-cosmos-blue-128-gb/p/itm98bcbdae6fe78?pid=MOBG9CKYHGJGWCXX&lid=LSTMOBG9CKYHGJGWCXXQKBD04&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_8&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBG9CKYHGJGWCXX.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n8,MOTOROLA,\"MOTOROLA Edge 30 Ultra (Interstellar Black, 256 GB)\",\"Interstellar Black,\",12 GB RAM , 256 GB ROM,16.94 cm (6.67 inch) Full HD+ Display,200MP + 50MP + 12MP , 60MP Front Camera,4610 mAh Lithium Battery,\"₹59,999\",https://www.flipkart.com/motorola-edge-30-ultra-interstellar-black-256-gb/p/itm54434f08345f3?pid=MOBGGAPRC96YFDSH&lid=LSTMOBGGAPRC96YFDSHMNOKD5&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_9&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGGAPRC96YFDSH.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n9,MOTOROLA,\"MOTOROLA Edge 30 Pro (Stardust White, 128 GB)\",\"Stardust White,\",8 GB RAM , 128 GB ROM,17.02 cm (6.7 inch) Full HD+ AMOLED Display,50MP + 50MP + 2MP , 60MP Front Camera,4800 mAh Lithium Polymer Battery,\"₹34,999\",https://www.flipkart.com/motorola-edge-30-pro-stardust-white-128-gb/p/itmc60ad815a2cbd?pid=MOBG9CKYEEUCNHUM&lid=LSTMOBG9CKYEEUCNHUMJDG8TW&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_10&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBG9CKYEEUCNHUM.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n10,MOTOROLA,\"MOTOROLA Edge 30 Ultra (Interstellar Black, 128 GB)\",\"Interstellar Black,\",8 GB RAM , 128 GB ROM,16.94 cm (6.67 inch) Full HD+ Display,200MP + 50MP + 12MP , 60MP Front Camera,4610 mAh Lithium Battery,\"₹54,999\",https://www.flipkart.com/motorola-edge-30-ultra-interstellar-black-128-gb/p/itm36c69ef9d1313?pid=MOBGFGM2PHKKGB78&lid=LSTMOBGFGM2PHKKGB78NUNL0L&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_11&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2PHKKGB78.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n11,MOTOROLA,\"MOTOROLA Edge 30 Ultra (Starlight White, 128 GB)\",\"Starlight White,\",8 GB RAM , 128 GB ROM,16.94 cm (6.67 inch) Full HD+ Display,200MP + 50MP + 12MP , 60MP Front Camera,4610 mAh Lithium Battery,\"₹54,999\",https://www.flipkart.com/motorola-edge-30-ultra-starlight-white-128-gb/p/itmfa7c7c01456e6?pid=MOBGFGM2GRYGBEPH&lid=LSTMOBGFGM2GRYGBEPHL5ASGI&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_12&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGFGM2GRYGBEPH.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n12,MOTOROLA,\"MOTOROLA Edge 30 Ultra (Starlight White, 256 GB)\",\"Starlight White,\",12 GB RAM , 256 GB ROM,16.94 cm (6.67 inch) Full HD+ Display,200MP + 50MP + 12MP , 60MP Front Camera,4610 mAh Lithium Battery,\"₹59,999\",https://www.flipkart.com/motorola-edge-30-ultra-starlight-white-256-gb/p/itm055386afc6641?pid=MOBGGAPR2KCFCTPT&lid=LSTMOBGGAPR2KCFCTPTHOXLPQ&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_13&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBGGAPR2KCFCTPT.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n13,MOTOROLA,\"MOTOROLA G30 (Dark Pearl, 64 GB)\",\"Dark Pearl,\",4 GB RAM , 64 GB ROM,16.54 cm (6.51 inch) HD+ Display,64MP + 8MP + 2MP + 2MP , 13MP Front Camera,5000 mAh Battery,\"₹10,999\",https://www.flipkart.com/motorola-g30-dark-pearl-64-gb/p/itme5ae7fa01f345?pid=MOBFVXGZWDHJHQGZ&lid=LSTMOBFVXGZWDHJHQGZDMPNHC&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_14&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBFVXGZWDHJHQGZ.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n14,MOTOROLA,\"MOTOROLA G30 (Pastel Sky, 64 GB)\",\"Pastel Sky,\",4 GB RAM , 64 GB ROM,16.54 cm (6.51 inch) HD+ Display,64MP + 8MP + 2MP + 2MP , 13MP Front Camera,5000 mAh Battery,\"₹10,999\",https://www.flipkart.com/motorola-g30-pastel-sky-64-gb/p/itmc7ceaa1d753f4?pid=MOBFVXGZMHTXSHPN&lid=LSTMOBFVXGZMHTXSHPN2JNPQV&marketplace=FLIPKART&q=Motorola+Edge30&store=tyy%2F4io&srno=s_1_15&otracker=search&otracker1=search&fm=organic&iid=b64f92db-045a-427f-a2b4-627b995b56c8.MOBFVXGZMHTXSHPN.SEARCH&ppt=hp&ppn=homepage&ssid=npl88ue8hc0000001674973231554&qH=af27b1dc506a70d0\\r\\n'"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "WSFlipkart = df.to_csv()\n",
    "WSFlipkart"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "2352e55b",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "91a6fe52",
   "metadata": {},
   "outputs": [],
   "source": [
    "#**********************\n",
    "# Google Maps\n",
    "#**********************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c357e9db",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.common.exceptions import StaleElementReferenceException , NoSuchElementException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2b3e92e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7a1f6f86",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get('https://maps.google.com/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "8623b06e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Enter City to Search: Dubai\n"
     ]
    }
   ],
   "source": [
    "city = input (\"Enter City to Search: \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "52acd7c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "enter_city =driver.find_element(By.XPATH,\"/html/body/div[3]/div[9]/div[3]/div[1]/div[1]/div[1]/div[2]/form/div[2]/div[3]/div/input[1]\")\n",
    "enter_city.send_keys(city)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9940bb34",
   "metadata": {},
   "outputs": [],
   "source": [
    "search=driver.find_element(By.XPATH,\"/html/body/div[3]/div[9]/div[3]/div[1]/div[1]/div[1]/div[2]/div[1]/button\")\n",
    "search.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "42a78b04",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.google.com/maps/place/Dubai+-+United+Arab+Emirates/@25.0757594,54.9472896,10z/data=!3m1!4b1!4m5!3m4!1s0x3e5f43496ad9c645:0xbde66e5084295162!8m2!3d25.2048493!4d55.2707828\n"
     ]
    }
   ],
   "source": [
    "Co_ords=driver.current_url\n",
    "print (Co_ords)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "08e0c553",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['25.0757594', '54.9472896']]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "C=[]\n",
    "Cords= [Co_ords]\n",
    "for i in Cords:\n",
    "    c1 = (i.split('@')[1])\n",
    "    C.append(c1)\n",
    "\n",
    "Coordinates=[]\n",
    "for i in C:\n",
    "    c = (i.split(',')[0:2])\n",
    "    Coordinates.append(c)\n",
    "Coordinates\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "c1985747",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Latitude and Longitude are : [['25.0757594', '54.9472896']]\n"
     ]
    }
   ],
   "source": [
    "print (\"Latitude and Longitude are :\" ,Coordinates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "3677cc78",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "aeb73b56",
   "metadata": {},
   "outputs": [],
   "source": [
    "#*******************************\n",
    "#7. Digit.in\n",
    "#*******************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "675bb8e3",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.common.exceptions import StaleElementReferenceException , NoSuchElementException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "aa9d416c",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b06ed987",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get('https://digit.in')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "dc815683",
   "metadata": {},
   "outputs": [],
   "source": [
    "t10=driver.find_element(By.XPATH,\"/html/body/div[2]/div/ul/li[3]/a\")\n",
    "t10.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "3ddcf463",
   "metadata": {},
   "outputs": [],
   "source": [
    "bestgame_lps=driver.find_element(By.XPATH,\"/html/body/div[2]/div/ul/li[3]/div/div/div[2]/div/ul[2]/li[1]/a\")\n",
    "bestgame_lps.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "4ba8dd5c",
   "metadata": {},
   "outputs": [],
   "source": [
    "P_name=[]\n",
    "name=driver.find_elements(By.XPATH,'//div[@class=\"TopNumbeHeading\"]//h3')\n",
    "for x in name:\n",
    "    p = (x.text)\n",
    "    P_name.append(p)\n",
    "\n",
    "URL=[]\n",
    "url=driver.find_elements(By.XPATH,'//div[@class=\"TopNumbeHeading\"]//a')\n",
    "for x in url:\n",
    "    p = (x.get_attribute('href'))\n",
    "    URL.append(p)\n",
    "\n",
    "Link= URL[0::3]\n",
    "\n",
    "Price= []\n",
    "try:\n",
    "    price=driver.find_elements(By.XPATH,'//td[@class=\"smprice\"]')\n",
    "    for i in price:\n",
    "        Price.append(i.text)\n",
    "except:\n",
    "    Price.append('-')\n",
    "    \n",
    "Specs =[]\n",
    "specs=driver.find_elements(By.XPATH,'//div[@class=\"Spcs-details\"]')\n",
    "for x in specs:\n",
    "    p = (x.text.split('\\n'))\n",
    "    Specs.append(p)\n",
    "\n",
    "    \n",
    "\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "092d3b2d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['MORE SPECIFICATIONS',\n",
       "  'Processor : 12th Gen Intel Core i9-12900HX 16 core processor',\n",
       "  'Display : 17.3″ (3840 x 2160) screen, 120 Hz refresh rate',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 64 GB DDR5 RAM & 2 TB SSD',\n",
       "  'Graphics Processor : 16 GB DDR6 NVIDIA GeForce RTX 3080 Ti Graphics card',\n",
       "  'Body : 397 x 330 x 23 mm dimension & 3.3 kg weight'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : 12th Gen Intel Core i9-12900H 14 core processor with 5 GHz clock speed',\n",
       "  'Display : 17.3″ (1920 x 1080) screen, 360 Hz refresh rate',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 32 GB DDR5 RAM & 1 TB SSD',\n",
       "  'Graphics Processor : 16 GB DDR6 NVIDIA GEFORCE RTX 3080 Ti Graphics card',\n",
       "  'Body : 299 x 359 x 21 mm dimension & 2.96 kg weight',\n",
       "  'Price : ₹ 389,990'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : 12th Gen Intel Core i7-12700H 14 core processor with 3.5 GHz clock speed',\n",
       "  'Display : 16″ (2560 x 1600) screen',\n",
       "  'OS : Windows 11',\n",
       "  'Memory : 32 GB DDR5 RAM & 2 TB SSD',\n",
       "  'Graphics Processor : 8 GB DDR6 NVIDIA GeForce RTX 3070 Ti Graphics card',\n",
       "  'Body : 262 x 359 x 20 mm dimension & 2.4 kg weight',\n",
       "  'Price : ₹ 229,990'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : 12th Gen Intel Core i7-12700H 14 core processor with 4.7 GHz clock speed',\n",
       "  'Display : 16.1″ (2560 x 1440) screen',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 8 GB DDR5 RAM & 1 TB SSD',\n",
       "  'Graphics Processor : 8 GB GDDR6 NVIDIA GeForce RTX 3070 Graphics card',\n",
       "  'Body : 369 x 248 x 23 mm dimension & 2.32 kg weight',\n",
       "  'Price : ₹ 176,490'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : AMD Ryzen 9-5900HX 8 core processor',\n",
       "  'Display : 15.6″ (2560 x 1440) screen, 165 Hz refresh rate',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 16 GB DDR4 RAM & 512 GB SSD',\n",
       "  'Graphics Processor : 8 GB DDR6 NVIDIA GeForce RTX 3070 Graphics card',\n",
       "  'Body : 363 x 255 x 23.9 mm dimension & 2.4 kg weight',\n",
       "  'Price : ₹ 172,999'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : AMD 5th Gen Ryzen 9-5900HX 8 core processor with 3.3GHz clock speed',\n",
       "  'Display : 15.6″ (1920 x 1080) screen, 240Hz refresh rate',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 16 GB DDR4 RAM & 1 TB SSD',\n",
       "  'Graphics Processor : 10 GB DDR6 AMD Radeon RX 6700M Graphics card',\n",
       "  'Body : 357 x 247 x 19 mm dimension & 1.9 kg weight',\n",
       "  'Price : ₹ 188,990'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : AMD Ryzen™ 9 5900HX 8 core processor with 3.3 GHz clock speed',\n",
       "  'Display : 16.1″ (2560 x 1440) screen',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 16 GB DDR4 RAM & 1 TB NVMe',\n",
       "  'Graphics Processor : 8 GB GDDR6 AMD Radeon™ RX 6600M Graphics card',\n",
       "  'Body : 36.92 x 24.8 x 2.3 mm dimension & 2.3 kg weight',\n",
       "  'Price : ₹ 124,990'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : 12th Gen Intel Core i7-12700H 14 core processor with 2.3 GHz clock speed',\n",
       "  'Display : 16″ (2560 x 1600) screen, 165 Hz refresh rate',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 16 GB DDR5 RAM & 1 TB SSD',\n",
       "  'Graphics Processor : 6 GB DDR6 NVIDIA GeForce RTX 3060 Graphics card',\n",
       "  'Body : 360 x 264 x 20 mm dimension & 2.49 kg weight',\n",
       "  'Price : ₹ 167,990'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : AMD Ryzen R7-5800H 8 core processor with 4.40 GHz clock speed',\n",
       "  'Display : 15.6″ (1920 x 1080) screen, 165Hz refresh rate',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 16 GB DDR4 RAM & 512 GB SSD',\n",
       "  'Graphics Processor : 6 GB DDR6 NVIDIA GeForce RTX 3060 Graphics card',\n",
       "  'Body : 356.2 x 272.5 x 22.85 mm dimension & 2.69 kg weight',\n",
       "  'Price : ₹ 174,000'],\n",
       " ['MORE SPECIFICATIONS',\n",
       "  'Processor : Lenovo Ryzen 7-5800H processor with 3.2 GHz clock speed',\n",
       "  'Display : 15.6″ screen, 165 Hz refresh rate',\n",
       "  'OS : Windows 11 Home',\n",
       "  'Memory : 16 GB DDR4 RAM & 1 TB SSD',\n",
       "  'Graphics Processor : 6 GB DDR6 NVIDIA GeForce 3060 Max-Q Graphics card',\n",
       "  'Body : 356 x 252 x 16 mm dimension & 1.9 kg weight',\n",
       "  'Price : ₹ 131,990']]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Specs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "7b9b87af",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 10 10 10\n"
     ]
    }
   ],
   "source": [
    "print (len(P_name),len(Price),len(Link),len(Specs))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b0c6a1f2",
   "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>Specifications</th>\n",
       "      <th>URL</th>\n",
       "      <th>Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MSI Titan GT77-12UHS</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : 12th Gen Int...</td>\n",
       "      <td>https://www.digit.in/laptops/msi-titan-gt77-12...</td>\n",
       "      <td>N/A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alienware X17 R2</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : 12th Gen Int...</td>\n",
       "      <td>https://www.digit.in/laptops/dell-new-alienwar...</td>\n",
       "      <td>₹ 389,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Acer Predator Triton 500 SE PT516-52s</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : 12th Gen Int...</td>\n",
       "      <td>https://www.digit.in/laptops/acer-predator-tri...</td>\n",
       "      <td>₹ 229,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Omen By HP (16-B1371TX)</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : 12th Gen Int...</td>\n",
       "      <td>https://www.digit.in/laptops/omen-by-hp-16-b13...</td>\n",
       "      <td>₹ 176,490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Acer Predator Helios 300 AN515-45</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : AMD Ryzen 9-...</td>\n",
       "      <td>https://www.digit.in/laptops/acer-nitro-5-an51...</td>\n",
       "      <td>₹ 172,999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>MSI Delta 15 (A5EFK-083IN)</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : AMD 5th Gen ...</td>\n",
       "      <td>https://www.digit.in/laptops/msi-delta-15-5th-...</td>\n",
       "      <td>₹ 188,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Omen By HP (16-C0141AX)</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : AMD Ryzen™ 9...</td>\n",
       "      <td>https://www.digit.in/laptops/hp-omen-16-c0141a...</td>\n",
       "      <td>₹ 124,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lenovo Legion 5i Pro (82RF00MGIN)</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : 12th Gen Int...</td>\n",
       "      <td>https://www.digit.in/laptops/lenovo-legion-5-p...</td>\n",
       "      <td>₹ 167,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alienware M15 R5 Ryzen Edition Icc-C780001win</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : AMD Ryzen R7...</td>\n",
       "      <td>https://www.digit.in/laptops/dell-alienware-m1...</td>\n",
       "      <td>₹ 174,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Lenovo Slim 7 Gen 6 (82K8002JIN)</td>\n",
       "      <td>[MORE SPECIFICATIONS, Processor : Lenovo Ryzen...</td>\n",
       "      <td>https://www.digit.in/laptops/lenovo-legion-s7-...</td>\n",
       "      <td>₹ 131,990</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Product Name  \\\n",
       "0                           MSI Titan GT77-12UHS   \n",
       "1                               Alienware X17 R2   \n",
       "2          Acer Predator Triton 500 SE PT516-52s   \n",
       "3                        Omen By HP (16-B1371TX)   \n",
       "4              Acer Predator Helios 300 AN515-45   \n",
       "5                     MSI Delta 15 (A5EFK-083IN)   \n",
       "6                        Omen By HP (16-C0141AX)   \n",
       "7              Lenovo Legion 5i Pro (82RF00MGIN)   \n",
       "8  Alienware M15 R5 Ryzen Edition Icc-C780001win   \n",
       "9               Lenovo Slim 7 Gen 6 (82K8002JIN)   \n",
       "\n",
       "                                      Specifications  \\\n",
       "0  [MORE SPECIFICATIONS, Processor : 12th Gen Int...   \n",
       "1  [MORE SPECIFICATIONS, Processor : 12th Gen Int...   \n",
       "2  [MORE SPECIFICATIONS, Processor : 12th Gen Int...   \n",
       "3  [MORE SPECIFICATIONS, Processor : 12th Gen Int...   \n",
       "4  [MORE SPECIFICATIONS, Processor : AMD Ryzen 9-...   \n",
       "5  [MORE SPECIFICATIONS, Processor : AMD 5th Gen ...   \n",
       "6  [MORE SPECIFICATIONS, Processor : AMD Ryzen™ 9...   \n",
       "7  [MORE SPECIFICATIONS, Processor : 12th Gen Int...   \n",
       "8  [MORE SPECIFICATIONS, Processor : AMD Ryzen R7...   \n",
       "9  [MORE SPECIFICATIONS, Processor : Lenovo Ryzen...   \n",
       "\n",
       "                                                 URL      Price  \n",
       "0  https://www.digit.in/laptops/msi-titan-gt77-12...        N/A  \n",
       "1  https://www.digit.in/laptops/dell-new-alienwar...  ₹ 389,990  \n",
       "2  https://www.digit.in/laptops/acer-predator-tri...  ₹ 229,990  \n",
       "3  https://www.digit.in/laptops/omen-by-hp-16-b13...  ₹ 176,490  \n",
       "4  https://www.digit.in/laptops/acer-nitro-5-an51...  ₹ 172,999  \n",
       "5  https://www.digit.in/laptops/msi-delta-15-5th-...  ₹ 188,990  \n",
       "6  https://www.digit.in/laptops/hp-omen-16-c0141a...  ₹ 124,990  \n",
       "7  https://www.digit.in/laptops/lenovo-legion-5-p...  ₹ 167,990  \n",
       "8  https://www.digit.in/laptops/dell-alienware-m1...  ₹ 174,000  \n",
       "9  https://www.digit.in/laptops/lenovo-legion-s7-...  ₹ 131,990  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'Product Name':P_name,'Specifications':Specs,'URL':Link,'Price':Price})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "446303aa",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "5025c3f9",
   "metadata": {},
   "outputs": [],
   "source": [
    "#*******************************\n",
    "#8.Forbe : List of Billionaires\n",
    "#*******************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "57c8b9c0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.common.exceptions import StaleElementReferenceException , NoSuchElementException\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.common.exceptions import TimeoutException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e79935a2",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "49f0226b",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get('https://www.forbes.com')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "cdc78b2a",
   "metadata": {},
   "outputs": [],
   "source": [
    "menu=driver.find_element(By.XPATH,\"/html/body/div[1]/header/nav/div[1]/div/div/div\")\n",
    "menu.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "02793627",
   "metadata": {},
   "outputs": [],
   "source": [
    "billionaires=driver.find_element(By.XPATH,\"/html/body/div[1]/header/nav/div[1]/div/div/div[2]/ul/li[1]/div[1]\")\n",
    "billionaires.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "fd32c258",
   "metadata": {},
   "outputs": [],
   "source": [
    "l_billionaires=driver.find_element(By.XPATH,\"/html/body/div[1]/main/div/section/section[1]/div/div/div[1]/div/div[1]/div[1]/div[2]/a/h2\")\n",
    "l_billionaires.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "86100fa0",
   "metadata": {},
   "outputs": [],
   "source": [
    "Rank = []\n",
    "Name = []\n",
    "NetWorth = []\n",
    "Country = []\n",
    "Source = []\n",
    "Industry = []\n",
    "Net = []\n",
    "\n",
    "delay = 10\n",
    "\n",
    "try:\n",
    "\n",
    "    WebDriverWait(driver,delay).until(EC.presence_of_element_located((By.CLASS_NAME,'rank')))\n",
    "       \n",
    "\n",
    "\n",
    "    rank=driver.find_elements(By.XPATH, '//div[@class=\"rank\"]')\n",
    "    for x in rank:\n",
    "        r = (x.text)\n",
    "        if r == (\"\"):\n",
    "            Rank.append('-')\n",
    "        else:\n",
    "            Rank.append(r)\n",
    "            \n",
    "    name=driver.find_elements(By.XPATH,'//div[@class=\"personName\"]//div')\n",
    "    for x in name:\n",
    "        n = (x.text)\n",
    "        if n == (\"\"):\n",
    "            Name.append('-')\n",
    "        else:\n",
    "            Name.append(n)\n",
    "                \n",
    "    networth=driver.find_elements(By.XPATH,'//div[@class=\"netWorth\"]//div')\n",
    "    for i in networth:\n",
    "        nw = (i.text)\n",
    "        NetWorth.append(nw)\n",
    "    Net = NetWorth [0::2]\n",
    "        \n",
    "    country=driver.find_elements(By.XPATH ,'//div[@class=\"countryOfCitizenship\"]')\n",
    "    for x in country:\n",
    "        c = (x.text)\n",
    "        if c == (\"\"):\n",
    "            Country.append(\"-\")\n",
    "        else:\n",
    "            Country.append(c)\n",
    "   \n",
    "    \n",
    "    source=driver.find_elements(By.XPATH,'//span[@class=\"source-text\"]')\n",
    "    for x in source:\n",
    "        s = (x.text)\n",
    "        if s == (\"\"):\n",
    "            Source.append(\"-\")\n",
    "        else:\n",
    "            Source.append(s)\n",
    "                \n",
    "                \n",
    "    industry=driver.find_elements(By.XPATH, '//div[@class=\"category\"]')\n",
    "    for x in industry:\n",
    "        i = (x.text)\n",
    "        if i == (\"\"):\n",
    "            Industry.append(\"-\")\n",
    "        else:\n",
    "            Industry.append(i)\n",
    "            \n",
    "except TimeoutException as e:\n",
    "    print (\"Exception Raised\" , e)\n",
    "\n",
    "                "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "4070dbb9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "200 200 200 200 200 200\n"
     ]
    }
   ],
   "source": [
    "print (len(Rank),len(Name),len(Net),len(Country),len(Source),len(Industry))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "76bb69a6",
   "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>Rank</th>\n",
       "      <th>Name</th>\n",
       "      <th>Net Worth</th>\n",
       "      <th>Country</th>\n",
       "      <th>Source</th>\n",
       "      <th>Industry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.</td>\n",
       "      <td>Elon Musk</td>\n",
       "      <td>$219 B</td>\n",
       "      <td>United States</td>\n",
       "      <td>Tesla, SpaceX</td>\n",
       "      <td>Automotive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.</td>\n",
       "      <td>Jeff Bezos</td>\n",
       "      <td>$171 B</td>\n",
       "      <td>United States</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.</td>\n",
       "      <td>Bernard Arnault &amp; family</td>\n",
       "      <td>$158 B</td>\n",
       "      <td>France</td>\n",
       "      <td>LVMH</td>\n",
       "      <td>Fashion &amp; Retail</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.</td>\n",
       "      <td>Bill Gates</td>\n",
       "      <td>$129 B</td>\n",
       "      <td>United States</td>\n",
       "      <td>Microsoft</td>\n",
       "      <td>Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.</td>\n",
       "      <td>Warren Buffett</td>\n",
       "      <td>$118 B</td>\n",
       "      <td>United States</td>\n",
       "      <td>Berkshire Hathaway</td>\n",
       "      <td>Finance &amp; Investments</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>195</th>\n",
       "      <td>192.</td>\n",
       "      <td>Marcel Herrmann Telles</td>\n",
       "      <td>$10.3 B</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>beer</td>\n",
       "      <td>Food &amp; Beverage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>197.</td>\n",
       "      <td>Leon Black</td>\n",
       "      <td>$10 B</td>\n",
       "      <td>United States</td>\n",
       "      <td>private equity</td>\n",
       "      <td>Finance &amp; Investments</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>197.</td>\n",
       "      <td>Joe Gebbia</td>\n",
       "      <td>$10 B</td>\n",
       "      <td>United States</td>\n",
       "      <td>Airbnb</td>\n",
       "      <td>Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>197.</td>\n",
       "      <td>David Geffen</td>\n",
       "      <td>$10 B</td>\n",
       "      <td>United States</td>\n",
       "      <td>movies, record labels</td>\n",
       "      <td>Media &amp; Entertainment</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>197.</td>\n",
       "      <td>Yu Renrong</td>\n",
       "      <td>$10 B</td>\n",
       "      <td>China</td>\n",
       "      <td>semiconductors</td>\n",
       "      <td>Manufacturing</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Rank                      Name Net Worth        Country  \\\n",
       "0      1.                 Elon Musk    $219 B  United States   \n",
       "1      2.                Jeff Bezos    $171 B  United States   \n",
       "2      3.  Bernard Arnault & family    $158 B         France   \n",
       "3      4.                Bill Gates    $129 B  United States   \n",
       "4      5.            Warren Buffett    $118 B  United States   \n",
       "..    ...                       ...       ...            ...   \n",
       "195  192.    Marcel Herrmann Telles   $10.3 B         Brazil   \n",
       "196  197.                Leon Black     $10 B  United States   \n",
       "197  197.                Joe Gebbia     $10 B  United States   \n",
       "198  197.              David Geffen     $10 B  United States   \n",
       "199  197.                Yu Renrong     $10 B          China   \n",
       "\n",
       "                    Source               Industry  \n",
       "0            Tesla, SpaceX             Automotive  \n",
       "1                   Amazon             Technology  \n",
       "2                     LVMH       Fashion & Retail  \n",
       "3                Microsoft             Technology  \n",
       "4       Berkshire Hathaway  Finance & Investments  \n",
       "..                     ...                    ...  \n",
       "195                   beer        Food & Beverage  \n",
       "196         private equity  Finance & Investments  \n",
       "197                 Airbnb             Technology  \n",
       "198  movies, record labels  Media & Entertainment  \n",
       "199         semiconductors          Manufacturing  \n",
       "\n",
       "[200 rows x 6 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'Rank':Rank,'Name':Name,'Net Worth':Net,'Country':Country,'Source':Source,'Industry':Industry})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "4505e5b3",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3694e2e8",
   "metadata": {},
   "outputs": [],
   "source": [
    "#*********************************\n",
    "# 9 . YouTube Comments\n",
    "#********************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4c1f5106",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.common.exceptions import TimeoutException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "db577eb3",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f954df2b",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get('https://www.youtube.com/watch?v=2hl-H3ygx_I')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e38474dc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "627"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Comments = []\n",
    "Time = []\n",
    "Likes = []\n",
    "\n",
    "delay = 30\n",
    "\n",
    "try:\n",
    "\n",
    "    WebDriverWait(driver,delay).until(EC.presence_of_element_located((By.CLASS_NAME,'style-scope ytd-comment-renderer')))\n",
    "    comments=driver.find_elements(By.XPATH, '//yt-formatted-string[@class=\"style-scope ytd-comment-renderer\"]')\n",
    "    for x in comments:\n",
    "        r = (x.text)\n",
    "        if r == (\"\"):\n",
    "            Comments.append('-')\n",
    "        else:\n",
    "            Comments.append(r)\n",
    "\n",
    "        \n",
    "    time=driver.find_elements(By.XPATH, '//yt-formatted-string[@class=\"published-time-text style-scope ytd-comment-renderer\"]')\n",
    "    for x in time:\n",
    "        r = (x.text)\n",
    "        if r == (\"\"):\n",
    "            Time.append('-')\n",
    "        else:\n",
    "            Time.append(r)\n",
    "\n",
    "    likes=driver.find_elements(By.ID, \"vote-count-middle\")\n",
    "    for x in likes:\n",
    "        r = (x.text)\n",
    "        if r == (\"\"):\n",
    "            Likes.append('-')\n",
    "        else:\n",
    "            Likes.append(r)\n",
    "except TimeoutException as e:\n",
    "    print (\"Exception Raised\" , e)\n",
    "        \n",
    "len(Comments)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "65e455f4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "627 627 627\n"
     ]
    }
   ],
   "source": [
    "print (len(Comments),len(Time),len(Likes))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9779d16e",
   "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>Comments</th>\n",
       "      <th>Time</th>\n",
       "      <th>Likes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thanks for watching! Comment, like, dislike, s...</td>\n",
       "      <td>2 years ago</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>$87,000 USD per person.   Save your minutes of...</td>\n",
       "      <td>2 years ago (edited)</td>\n",
       "      <td>1.1K</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>So, a year on a cruise ship costs about the sa...</td>\n",
       "      <td>1 year ago</td>\n",
       "      <td>298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>We met an elderly couple on a Royal Caribbean ...</td>\n",
       "      <td>2 years ago</td>\n",
       "      <td>274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>My late wife and I cruised every year and some...</td>\n",
       "      <td>1 year ago</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>622</th>\n",
       "      <td>vajate del carnival por que si no te mueres sá...</td>\n",
       "      <td>2 years ago</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>Terrible pronounciation.Poor</td>\n",
       "      <td>2 years ago</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>Rubbish. You didn’t do your homework.</td>\n",
       "      <td>1 year ago</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>This guys has 0 clue what he's talking about.</td>\n",
       "      <td>2 years ago</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>Any Biden advertisement forces my thumbs down ...</td>\n",
       "      <td>2 years ago</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>627 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Comments                  Time  \\\n",
       "0    Thanks for watching! Comment, like, dislike, s...           2 years ago   \n",
       "1    $87,000 USD per person.   Save your minutes of...  2 years ago (edited)   \n",
       "2    So, a year on a cruise ship costs about the sa...            1 year ago   \n",
       "3    We met an elderly couple on a Royal Caribbean ...           2 years ago   \n",
       "4    My late wife and I cruised every year and some...            1 year ago   \n",
       "..                                                 ...                   ...   \n",
       "622  vajate del carnival por que si no te mueres sá...           2 years ago   \n",
       "623                       Terrible pronounciation.Poor           2 years ago   \n",
       "624              Rubbish. You didn’t do your homework.            1 year ago   \n",
       "625      This guys has 0 clue what he's talking about.           2 years ago   \n",
       "626  Any Biden advertisement forces my thumbs down ...           2 years ago   \n",
       "\n",
       "    Likes  \n",
       "0      34  \n",
       "1    1.1K  \n",
       "2     298  \n",
       "3     274  \n",
       "4     138  \n",
       "..    ...  \n",
       "622     -  \n",
       "623     -  \n",
       "624     -  \n",
       "625     -  \n",
       "626     -  \n",
       "\n",
       "[627 rows x 3 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'Comments':Comments,'Time':Time,'Likes':Likes})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "fcc666ae",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0ba3e0e8",
   "metadata": {},
   "outputs": [],
   "source": [
    "#*****************************\n",
    "#10. Hostel world\n",
    "#*****************************"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "bedfe920",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Libraries\n",
    "import pandas as pd\n",
    "import selenium\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.common.exceptions import TimeoutException\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings ('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a88bbd35",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(r\"C:\\Users\\pooja\\chromedriver.exe\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "cbe20657",
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get(\"http://www.hostelworld.com/\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "490f0d9f",
   "metadata": {},
   "outputs": [],
   "source": [
    "enter_city =driver.find_element(By.ID,\"search-input-field\")\n",
    "enter_city.send_keys('London England')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "285e3fc8",
   "metadata": {},
   "outputs": [],
   "source": [
    "click=driver.find_element(By.XPATH,\"/html/body/div[3]/div/div/div[2]/div[2]/div/div/div[4]/div/div[2]/div/div[1]/div/div/ul/li[2]\")\n",
    "click.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "a2c8a7db",
   "metadata": {},
   "outputs": [],
   "source": [
    "search=driver.find_element(By.XPATH,\"/html/body/div[3]/div/div/div[2]/div[2]/div/div/div[4]/div/div[2]/div/div[5]/button\")\n",
    "search.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "cdd40e36",
   "metadata": {},
   "outputs": [],
   "source": [
    "H_Name =[]\n",
    "Dist = []\n",
    "Ratings = []\n",
    "T_Reviews = []\n",
    "O_Reviews= []\n",
    "p_price = []\n",
    "d_price = []\n",
    "Facilities = []\n",
    "P_discrp = []\n",
    "\n",
    "start=0\n",
    "end=3\n",
    "\n",
    "for page in range(start,end):\n",
    "        \n",
    "    h_name=driver.find_elements(By.XPATH, '//h2[@class=\"title title-6\"]')\n",
    "    for x in h_name:\n",
    "        h = (x.text)\n",
    "        if h == (\"\"):\n",
    "            H_Name.append('-')\n",
    "        else:\n",
    "            H_Name.append(h)\n",
    "            \n",
    "    dist=driver.find_elements(By.XPATH, '//span[@class=\"description\"]')\n",
    "    for x in dist:\n",
    "        d = (x.text.split(\" \"))\n",
    "        if d == (\"\"):\n",
    "            Dist.append('-')\n",
    "        else:\n",
    "            Dist.append(d[2])\n",
    "                \n",
    "    rate=driver.find_elements(By.XPATH,'//div[@class=\"rating rating-summary-container big\"]')\n",
    "    for x in rate:\n",
    "        r = (x.text.split(\"\\n\"))\n",
    "        if r == (\"\"):\n",
    "            Ratings.append('-')\n",
    "        else:\n",
    "            Ratings.append(r[0])\n",
    "        \n",
    "    trw=driver.find_elements(By.XPATH ,'//div[@class=\"reviews\"]')\n",
    "    for x in trw:\n",
    "        tr = (x.text.split(\" \"))\n",
    "        if tr == (\"\"):\n",
    "            T_Reviews.append(\"-\")\n",
    "        else:\n",
    "            T_Reviews.append(tr[0])\n",
    "   \n",
    "    \n",
    "    orw=driver.find_elements(By.XPATH,'//div[@class=\"keyword\"]//span')\n",
    "    for x in orw:\n",
    "        ow = (x.text)\n",
    "        O_Reviews.append(ow)\n",
    "                \n",
    "                \n",
    "    ppr=driver.find_elements(By.XPATH, '//div[@class=\"price-col\"]')\n",
    "    for x in ppr:\n",
    "        pp = (x.text)\n",
    "        if pp == (\"\"):\n",
    "            p_price.append(\"-\")\n",
    "        else:\n",
    "            p_price.append(pp)\n",
    "            \n",
    "            \n",
    "    dpr=driver.find_elements(By.XPATH, '//div[@class=\"price-col\"]')\n",
    "    for x in dpr:\n",
    "        dp = (x.text)\n",
    "        if dp == (\"\"):\n",
    "            d_price.append(\"-\")\n",
    "        else:\n",
    "            d_price.append(dp)\n",
    "                \n",
    "    fac=driver.find_elements(By.XPATH, '//div[@class=\"facilities-label facilities\"]')\n",
    "    for x in fac:\n",
    "        f = (x.text.split(\"\\n\"))\n",
    "        if f == (\"\"):\n",
    "            Facilities.append(\"-\")\n",
    "        else:\n",
    "            Facilities.append(f)\n",
    "                \n",
    "    des=driver.find_elements(By.XPATH, '//div[@class=\"rating-factors prop-card-tablet rating-factors small\"]')\n",
    "    for x in des:\n",
    "        d = (x.text.split(\"\\n\"))\n",
    "        if d == (\"\"):\n",
    "            P_discrp.append(\"-\")\n",
    "        else:\n",
    "            P_discrp.append(d)\n",
    "                \n",
    "        \n",
    "  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "fc21372f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "90 90\n"
     ]
    }
   ],
   "source": [
    "Privates = []\n",
    "Dorms = []\n",
    "\n",
    "Privates = p_price[0::2]\n",
    "Dorms = d_price[1::2]\n",
    "print (len(Private),len(Dorms))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "906aa45d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "90"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in O_Reviews:\n",
    "    if i == ('Rating'):\n",
    "        O_Reviews.remove('i')\n",
    "len(O_Reviews)\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "f7aa3642",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "90 90 90 90 90 90 90 90 90\n"
     ]
    }
   ],
   "source": [
    "print (len(H_Name),len(Dist),len(Ratings),len(T_Reviews),len(O_Reviews),len(Privates),len(Dorms),len(Facilities),len(P_discrp))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "1fcdac73",
   "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>Hostel Name</th>\n",
       "      <th>Distance from city centre</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Total Reviews</th>\n",
       "      <th>Overall Reviews</th>\n",
       "      <th>Private Price</th>\n",
       "      <th>Dorm Price</th>\n",
       "      <th>Facilities</th>\n",
       "      <th>Place Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Wombat's City Hostel London</td>\n",
       "      <td>3.6km</td>\n",
       "      <td>8.9</td>\n",
       "      <td>14535</td>\n",
       "      <td>Fabulous</td>\n",
       "      <td>Privates From\\nRs17913.06 Rs14330</td>\n",
       "      <td>Dorms From\\nRs5580.65 Rs4465</td>\n",
       "      <td>[Free WiFi, Follows Covid-19 sanitation guidance]</td>\n",
       "      <td>[Perfect Location, Superb Staff, Fantastic Cle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>St Christopher's Village</td>\n",
       "      <td>1.8km</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11882</td>\n",
       "      <td>Fabulous</td>\n",
       "      <td>No Privates Available</td>\n",
       "      <td>Dorms From\\nRs2810.97 Rs2530</td>\n",
       "      <td>[Free WiFi, Follows Covid-19 sanitation guidance]</td>\n",
       "      <td>[Perfect Location, Marvellous Staff, Excellent...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hostel One Notting Hill</td>\n",
       "      <td>5.5km</td>\n",
       "      <td>9.4</td>\n",
       "      <td>1727</td>\n",
       "      <td>Fabulous</td>\n",
       "      <td>Privates From\\nRs12522</td>\n",
       "      <td>Dorms From\\nRs5315</td>\n",
       "      <td>[Free WiFi]</td>\n",
       "      <td>[Perfect Location, Superb Staff, Fantastic Cle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Generator London</td>\n",
       "      <td>3km</td>\n",
       "      <td>7.7</td>\n",
       "      <td>7338</td>\n",
       "      <td>Fabulous</td>\n",
       "      <td>Privates From\\nRs9963</td>\n",
       "      <td>Dorms From\\nRs2406</td>\n",
       "      <td>[Free WiFi, Follows Covid-19 sanitation guidance]</td>\n",
       "      <td>[Perfect Location, Marvellous Staff, Excellent...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Urbany Hostel London</td>\n",
       "      <td>5.4km</td>\n",
       "      <td>9.2</td>\n",
       "      <td>637</td>\n",
       "      <td>Superb</td>\n",
       "      <td>Privates From\\nRs13201</td>\n",
       "      <td>Dorms From\\nRs4964</td>\n",
       "      <td>[Free WiFi, Follows Covid-19 sanitation guidance]</td>\n",
       "      <td>[Perfect Location, Superb Staff, Fantastic Cle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>PubLove @ The Crown, Battersea</td>\n",
       "      <td>4.7km</td>\n",
       "      <td>7.7</td>\n",
       "      <td>285</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>No Privates Available</td>\n",
       "      <td>Dorms From\\nRs3430</td>\n",
       "      <td>[Free WiFi]</td>\n",
       "      <td>[Perfect Location, Superb Staff, Awesome Clean...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>PubLove @ The Rose &amp; Crown</td>\n",
       "      <td>1.6km</td>\n",
       "      <td>7.4</td>\n",
       "      <td>173</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>No Privates Available</td>\n",
       "      <td>Dorms From\\nRs5313</td>\n",
       "      <td>[Free WiFi]</td>\n",
       "      <td>[Perfect Location, Marvellous Staff, Awesome C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Elmwood Hotel</td>\n",
       "      <td>3.2km</td>\n",
       "      <td>8.3</td>\n",
       "      <td>122</td>\n",
       "      <td>Fabulous</td>\n",
       "      <td>Privates From\\nRs8743</td>\n",
       "      <td>No Dorms Available</td>\n",
       "      <td>[]</td>\n",
       "      <td>[Perfect Location, Superb Staff, Fantastic Cle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Selina Camden</td>\n",
       "      <td>5.5km</td>\n",
       "      <td>8.8</td>\n",
       "      <td>43</td>\n",
       "      <td>Fabulous</td>\n",
       "      <td>No Privates Available</td>\n",
       "      <td>Dorms From\\nRs8474.39 Rs7203</td>\n",
       "      <td>[Free WiFi]</td>\n",
       "      <td>[Perfect Location, Superb Staff, Fantastic Cle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Bell House Hostel</td>\n",
       "      <td>4.2km</td>\n",
       "      <td>6.9</td>\n",
       "      <td>31</td>\n",
       "      <td>Good</td>\n",
       "      <td>No Privates Available</td>\n",
       "      <td>Dorms From\\nRs2588</td>\n",
       "      <td>[Free WiFi]</td>\n",
       "      <td>[Perfect Location, Marvellous Staff, Good Clea...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Hostel Name Distance from city centre Rating  \\\n",
       "0      Wombat's City Hostel London                     3.6km    8.9   \n",
       "1         St Christopher's Village                     1.8km    8.0   \n",
       "2          Hostel One Notting Hill                     5.5km    9.4   \n",
       "3                 Generator London                       3km    7.7   \n",
       "4             Urbany Hostel London                     5.4km    9.2   \n",
       "..                             ...                       ...    ...   \n",
       "85  PubLove @ The Crown, Battersea                     4.7km    7.7   \n",
       "86      PubLove @ The Rose & Crown                     1.6km    7.4   \n",
       "87                   Elmwood Hotel                     3.2km    8.3   \n",
       "88                   Selina Camden                     5.5km    8.8   \n",
       "89               Bell House Hostel                     4.2km    6.9   \n",
       "\n",
       "   Total Reviews Overall Reviews                      Private Price  \\\n",
       "0          14535        Fabulous  Privates From\\nRs17913.06 Rs14330   \n",
       "1          11882        Fabulous              No Privates Available   \n",
       "2           1727        Fabulous             Privates From\\nRs12522   \n",
       "3           7338        Fabulous              Privates From\\nRs9963   \n",
       "4            637          Superb             Privates From\\nRs13201   \n",
       "..           ...             ...                                ...   \n",
       "85           285       Very Good              No Privates Available   \n",
       "86           173       Very Good              No Privates Available   \n",
       "87           122        Fabulous              Privates From\\nRs8743   \n",
       "88            43        Fabulous              No Privates Available   \n",
       "89            31            Good              No Privates Available   \n",
       "\n",
       "                      Dorm Price  \\\n",
       "0   Dorms From\\nRs5580.65 Rs4465   \n",
       "1   Dorms From\\nRs2810.97 Rs2530   \n",
       "2             Dorms From\\nRs5315   \n",
       "3             Dorms From\\nRs2406   \n",
       "4             Dorms From\\nRs4964   \n",
       "..                           ...   \n",
       "85            Dorms From\\nRs3430   \n",
       "86            Dorms From\\nRs5313   \n",
       "87            No Dorms Available   \n",
       "88  Dorms From\\nRs8474.39 Rs7203   \n",
       "89            Dorms From\\nRs2588   \n",
       "\n",
       "                                           Facilities  \\\n",
       "0   [Free WiFi, Follows Covid-19 sanitation guidance]   \n",
       "1   [Free WiFi, Follows Covid-19 sanitation guidance]   \n",
       "2                                         [Free WiFi]   \n",
       "3   [Free WiFi, Follows Covid-19 sanitation guidance]   \n",
       "4   [Free WiFi, Follows Covid-19 sanitation guidance]   \n",
       "..                                                ...   \n",
       "85                                        [Free WiFi]   \n",
       "86                                        [Free WiFi]   \n",
       "87                                                 []   \n",
       "88                                        [Free WiFi]   \n",
       "89                                        [Free WiFi]   \n",
       "\n",
       "                                    Place Description  \n",
       "0   [Perfect Location, Superb Staff, Fantastic Cle...  \n",
       "1   [Perfect Location, Marvellous Staff, Excellent...  \n",
       "2   [Perfect Location, Superb Staff, Fantastic Cle...  \n",
       "3   [Perfect Location, Marvellous Staff, Excellent...  \n",
       "4   [Perfect Location, Superb Staff, Fantastic Cle...  \n",
       "..                                                ...  \n",
       "85  [Perfect Location, Superb Staff, Awesome Clean...  \n",
       "86  [Perfect Location, Marvellous Staff, Awesome C...  \n",
       "87  [Perfect Location, Superb Staff, Fantastic Cle...  \n",
       "88  [Perfect Location, Superb Staff, Fantastic Cle...  \n",
       "89  [Perfect Location, Marvellous Staff, Good Clea...  \n",
       "\n",
       "[90 rows x 9 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'Hostel Name':H_Name,'Distance from city centre':Dist,'Rating':Ratings,'Total Reviews':T_Reviews,'Overall Reviews':O_Reviews,'Private Price':Privates,'Dorm Price':Dorms,'Facilities':Facilities,'Place Description':P_discrp})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dda68fdc",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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
}