Swiggy_Data_Scrapping.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "095a4950",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting webdriver-manager\n",
      "  Downloading webdriver_manager-3.8.6-py2.py3-none-any.whl (27 kB)\n",
      "Collecting python-dotenv\n",
      "  Downloading python_dotenv-1.0.0-py3-none-any.whl (19 kB)\n",
      "Requirement already satisfied: packaging in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from webdriver-manager) (21.3)\n",
      "Requirement already satisfied: tqdm in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from webdriver-manager) (4.64.1)\n",
      "Requirement already satisfied: requests in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from webdriver-manager) (2.28.1)\n",
      "Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from packaging->webdriver-manager) (3.0.9)\n",
      "Requirement already satisfied: charset-normalizer<3,>=2 in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from requests->webdriver-manager) (2.0.4)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from requests->webdriver-manager) (3.3)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from requests->webdriver-manager) (2022.9.14)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from requests->webdriver-manager) (1.26.11)\n",
      "Requirement already satisfied: colorama in c:\\users\\saurav\\anaconda3\\lib\\site-packages (from tqdm->webdriver-manager) (0.4.5)\n",
      "Installing collected packages: python-dotenv, webdriver-manager\n",
      "Successfully installed python-dotenv-1.0.0 webdriver-manager-3.8.6\n"
     ]
    }
   ],
   "source": [
    "!pip install webdriver-manager\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b19e96ee",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importing All the Important Libraries \n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from time import sleep\n",
    "from selenium import webdriver\n",
    "from webdriver_manager.chrome import ChromeDriverManager\n",
    "from selenium.webdriver.common.by import By\n",
    "# from selenium.webdriver.support.ui import WebDriverWait\n",
    "# from selenium.webdriver.support import expected_conditions as EC\n",
    "# from selenium.common.exceptions import TimeoutException"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "304a8f19",
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium.webdriver.common.keys import Keys\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "c5892802",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4.1\n",
      "•\n",
      "28 MINS\n",
      "•\n",
      "₹150 FOR TWO\n"
     ]
    }
   ],
   "source": [
    "Driver=webdriver.Chrome(options=webdriver.ChromeOptions())\n",
    "Driver.get(\"https://www.swiggy.com\")\n",
    "sleep(3)\n",
    "Driver.maximize_window()\n",
    "Driver.find_element(By.XPATH,'//*[@id=\"location\"]').send_keys('Bangalore')\n",
    "sleep(5)\n",
    "Driver.find_element(By.XPATH,'//*[@id=\"root\"]/div[1]/div[1]/div/div[1]/div[1]/div/div[2]/div/div[2]/button[1]').click()\n",
    "sleep(5)\n",
    "html = Driver.find_element(By.TAG_NAME, 'html')\n",
    "for i in range(80):\n",
    "    html.send_keys(Keys.PAGE_DOWN)\n",
    "    sleep(2)\n",
    "sleep(10)\n",
    "Urls = Driver.find_elements(By.CLASS_NAME,\"_1j_Yo\")\n",
    "Detail=Driver.find_elements(By.CLASS_NAME,\"_3Ztcd\")\n",
    "Rating= Driver.find_elements(By.CLASS_NAME,\"_3Mn31\")\n",
    "print(Rating[0].text)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "421d740a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Step Right Up\\nItalian-American, Fast Food, Snacks, Beverages'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Detail[0].text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "4d3cea07",
   "metadata": {},
   "outputs": [],
   "source": [
    "Dlist=[]\n",
    "for i in range(len(Detail)):\n",
    "    url=Urls[i].get_attribute('href')\n",
    "    item = Detail[i].text\n",
    "    Name=item.split('\\n')[0]\n",
    "    Cousines=item.split('\\n')[1]\n",
    "    id=url.split('-')[-1]\n",
    "    rat=Rating[i].text\n",
    "    Star_rat=rat.split(\"\\n\")[0]\n",
    "    Price_for_one=rat.split(\"\\n\")[-1]\n",
    "    \n",
    "    Dlist.append({\"Restaurant_id\" :id,\n",
    "                  \"Restaurant_link\" :url,\n",
    "                  \"Retaurant Name\":Name,\n",
    "                  \"Rating\":Star_rat,\n",
    "                  \"price_for_one_two\":Price_for_one,\n",
    "                  \"Cousines\" :Cousines})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "05763fd3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "id": "413e9bd6",
   "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>Restaurant_id</th>\n",
       "      <th>Restaurant_link</th>\n",
       "      <th>Retaurant Name</th>\n",
       "      <th>Rating</th>\n",
       "      <th>price_for_one_two</th>\n",
       "      <th>Cousines</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>667962</td>\n",
       "      <td>https://www.swiggy.com/restaurants/paris-panin...</td>\n",
       "      <td>Paris Panini - Gourmet Sandwiches &amp; Wraps</td>\n",
       "      <td>4.5</td>\n",
       "      <td>₹500 FOR TWO</td>\n",
       "      <td>Continental, Pastas, Salads, Snacks, Desserts,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3241</td>\n",
       "      <td>https://www.swiggy.com/restaurants/meghana-foo...</td>\n",
       "      <td>Meghana Foods</td>\n",
       "      <td>4.5</td>\n",
       "      <td>₹500 FOR TWO</td>\n",
       "      <td>Biryani, Andhra, South Indian, North Indian, C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>109787</td>\n",
       "      <td>https://www.swiggy.com/restaurants/chianti-mg-...</td>\n",
       "      <td>Chianti</td>\n",
       "      <td>4.4</td>\n",
       "      <td>₹1250 FOR TWO</td>\n",
       "      <td>Italian, Pizzas, Salads, Pastas, Desserts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>121603</td>\n",
       "      <td>https://www.swiggy.com/restaurants/kannur-food...</td>\n",
       "      <td>Kannur Food Point</td>\n",
       "      <td>3.9</td>\n",
       "      <td>₹300 FOR TWO</td>\n",
       "      <td>Kerala, Chinese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>574263</td>\n",
       "      <td>https://www.swiggy.com/restaurants/rahhams-pul...</td>\n",
       "      <td>Rahhams</td>\n",
       "      <td>4.3</td>\n",
       "      <td>₹700 FOR TWO</td>\n",
       "      <td>Biryani, Mughlai, North Indian, Kebabs, Chines...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>30531</td>\n",
       "      <td>https://www.swiggy.com/restaurants/hotel-empir...</td>\n",
       "      <td>Hotel Empire</td>\n",
       "      <td>4.3</td>\n",
       "      <td>₹450 FOR TWO</td>\n",
       "      <td>North Indian, Kebabs, Biryani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>484182</td>\n",
       "      <td>https://www.swiggy.com/restaurants/california-...</td>\n",
       "      <td>California Burrito</td>\n",
       "      <td>4.5</td>\n",
       "      <td>₹250 FOR TWO</td>\n",
       "      <td>Mexican, American, Salads, Continental, Keto, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>210945</td>\n",
       "      <td>https://www.swiggy.com/restaurants/royal-resta...</td>\n",
       "      <td>Royal Restaurant</td>\n",
       "      <td>3.9</td>\n",
       "      <td>₹300 FOR TWO</td>\n",
       "      <td>Chinese, North Indian, Tandoor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>29063</td>\n",
       "      <td>https://www.swiggy.com/restaurants/misu-ashok-...</td>\n",
       "      <td>Misu</td>\n",
       "      <td>4.4</td>\n",
       "      <td>₹1300 FOR TWO</td>\n",
       "      <td>Asian, Chinese, Vietnamese, Malaysian, Sushi, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>280474</td>\n",
       "      <td>https://www.swiggy.com/restaurants/empire-juic...</td>\n",
       "      <td>Empire Juices and Desserts</td>\n",
       "      <td>4.0</td>\n",
       "      <td>₹200 FOR TWO</td>\n",
       "      <td>Ice Cream, Juices</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>196047</td>\n",
       "      <td>https://www.swiggy.com/restaurants/new-taj-dar...</td>\n",
       "      <td>New Taj Darbar</td>\n",
       "      <td>3.4</td>\n",
       "      <td>₹300 FOR TWO</td>\n",
       "      <td>Biryani, Indian, Chinese, Tandoor, Seafood</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5938</td>\n",
       "      <td>https://www.swiggy.com/restaurants/burger-king...</td>\n",
       "      <td>Burger King</td>\n",
       "      <td>4.1</td>\n",
       "      <td>₹350 FOR TWO</td>\n",
       "      <td>Burgers, American</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3369</td>\n",
       "      <td>https://www.swiggy.com/restaurants/truffles-as...</td>\n",
       "      <td>Truffles</td>\n",
       "      <td>4.4</td>\n",
       "      <td>₹450 FOR TWO</td>\n",
       "      <td>American, Desserts, Continental, Italian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>252332</td>\n",
       "      <td>https://www.swiggy.com/restaurants/al-bek-samp...</td>\n",
       "      <td>Al-Bek</td>\n",
       "      <td>4.2</td>\n",
       "      <td>₹500 FOR TWO</td>\n",
       "      <td>Arabian, Tandoor, Biryani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>10575</td>\n",
       "      <td>https://www.swiggy.com/restaurants/pizza-hut-s...</td>\n",
       "      <td>Pizza Hut</td>\n",
       "      <td>3.9</td>\n",
       "      <td>₹600 FOR TWO</td>\n",
       "      <td>Pizzas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>424609</td>\n",
       "      <td>https://www.swiggy.com/restaurants/bikaner-swe...</td>\n",
       "      <td>Bikaner Sweets</td>\n",
       "      <td>4.1</td>\n",
       "      <td>₹99 FOR TWO</td>\n",
       "      <td>Sweets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>280474</td>\n",
       "      <td>https://www.swiggy.com/restaurants/empire-juic...</td>\n",
       "      <td>Empire Juices and Desserts</td>\n",
       "      <td>4.0</td>\n",
       "      <td>₹200 FOR TWO</td>\n",
       "      <td>Ice Cream, Juices</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>30959</td>\n",
       "      <td>https://www.swiggy.com/restaurants/kfc-garuda-...</td>\n",
       "      <td>KFC</td>\n",
       "      <td>3.7</td>\n",
       "      <td>₹400 FOR TWO</td>\n",
       "      <td>Burgers, Biryani, American, Snacks, Fast Food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>420484</td>\n",
       "      <td>https://www.swiggy.com/restaurants/keventers-i...</td>\n",
       "      <td>Keventers Ice Cream</td>\n",
       "      <td>4.4</td>\n",
       "      <td>₹200 FOR TWO</td>\n",
       "      <td>Ice Cream, Desserts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>414818</td>\n",
       "      <td>https://www.swiggy.com/restaurants/ath-all-thi...</td>\n",
       "      <td>ATH - All Things Healthy!</td>\n",
       "      <td>4.3</td>\n",
       "      <td>₹200 FOR TWO</td>\n",
       "      <td>Healthy Food, Indian, Bakery, Snacks, North In...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>424616</td>\n",
       "      <td>https://www.swiggy.com/restaurants/sea-spice-m...</td>\n",
       "      <td>Sea Spice Multicuisine Restaurant</td>\n",
       "      <td>4.6</td>\n",
       "      <td>₹400 FOR TWO</td>\n",
       "      <td>Seafood, Chinese, Biryani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>12808</td>\n",
       "      <td>https://www.swiggy.com/restaurants/a2b-adyar-a...</td>\n",
       "      <td>A2B - Adyar Ananda Bhavan</td>\n",
       "      <td>4.4</td>\n",
       "      <td>₹300 FOR TWO</td>\n",
       "      <td>South Indian, North Indian, Sweets, Chinese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2915</td>\n",
       "      <td>https://www.swiggy.com/restaurants/watsons-vas...</td>\n",
       "      <td>Watson's</td>\n",
       "      <td>3.2</td>\n",
       "      <td>₹450 FOR TWO</td>\n",
       "      <td>Continental, Chinese, North Indian, Asian, Eur...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>620897</td>\n",
       "      <td>https://www.swiggy.com/restaurants/narmada-cha...</td>\n",
       "      <td>Narmada Chain Of Restaurant</td>\n",
       "      <td>4.4</td>\n",
       "      <td>₹500 FOR TWO</td>\n",
       "      <td>Biryani, Andhra, South Indian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>609247</td>\n",
       "      <td>https://www.swiggy.com/restaurants/the-cake-fa...</td>\n",
       "      <td>The cake fancy</td>\n",
       "      <td>--</td>\n",
       "      <td>₹250 FOR TWO</td>\n",
       "      <td>Bakery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>698511</td>\n",
       "      <td>https://www.swiggy.com/restaurants/burma-burma...</td>\n",
       "      <td>Burma Burma - Brigade Road</td>\n",
       "      <td>--</td>\n",
       "      <td>₹1300 FOR TWO</td>\n",
       "      <td>Burmese, Asian, Salads, Ice Cream, Desserts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>464509</td>\n",
       "      <td>https://www.swiggy.com/restaurants/leons-burge...</td>\n",
       "      <td>Leon's - Burgers &amp; Wings (Leon Grill)</td>\n",
       "      <td>4.3</td>\n",
       "      <td>₹300 FOR TWO</td>\n",
       "      <td>American, Snacks, Turkish, Portuguese, Contine...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>263637</td>\n",
       "      <td>https://www.swiggy.com/restaurants/pure-veg-me...</td>\n",
       "      <td>Pure Veg Meals by Lunchbox</td>\n",
       "      <td>4.0</td>\n",
       "      <td>₹200 FOR TWO</td>\n",
       "      <td>Biryani, North Indian, Desserts, Beverages</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2824</td>\n",
       "      <td>https://www.swiggy.com/restaurants/fanoos-john...</td>\n",
       "      <td>Fanoos</td>\n",
       "      <td>4.0</td>\n",
       "      <td>₹300 FOR TWO</td>\n",
       "      <td>Biryani, Tandoor, Kebabs, Barbecue</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>643832</td>\n",
       "      <td>https://www.swiggy.com/restaurants/wefit-bowls...</td>\n",
       "      <td>WeFit-Bowls, Salads &amp; Sandwiches</td>\n",
       "      <td>--</td>\n",
       "      <td>₹250 FOR TWO</td>\n",
       "      <td>Healthy Food, Salads, Keto, Snacks</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Restaurant_id                                    Restaurant_link  \\\n",
       "0         667962  https://www.swiggy.com/restaurants/paris-panin...   \n",
       "1           3241  https://www.swiggy.com/restaurants/meghana-foo...   \n",
       "2         109787  https://www.swiggy.com/restaurants/chianti-mg-...   \n",
       "3         121603  https://www.swiggy.com/restaurants/kannur-food...   \n",
       "4         574263  https://www.swiggy.com/restaurants/rahhams-pul...   \n",
       "5          30531  https://www.swiggy.com/restaurants/hotel-empir...   \n",
       "6         484182  https://www.swiggy.com/restaurants/california-...   \n",
       "7         210945  https://www.swiggy.com/restaurants/royal-resta...   \n",
       "8          29063  https://www.swiggy.com/restaurants/misu-ashok-...   \n",
       "9         280474  https://www.swiggy.com/restaurants/empire-juic...   \n",
       "10        196047  https://www.swiggy.com/restaurants/new-taj-dar...   \n",
       "11          5938  https://www.swiggy.com/restaurants/burger-king...   \n",
       "12          3369  https://www.swiggy.com/restaurants/truffles-as...   \n",
       "13        252332  https://www.swiggy.com/restaurants/al-bek-samp...   \n",
       "14         10575  https://www.swiggy.com/restaurants/pizza-hut-s...   \n",
       "15        424609  https://www.swiggy.com/restaurants/bikaner-swe...   \n",
       "16        280474  https://www.swiggy.com/restaurants/empire-juic...   \n",
       "17         30959  https://www.swiggy.com/restaurants/kfc-garuda-...   \n",
       "18        420484  https://www.swiggy.com/restaurants/keventers-i...   \n",
       "19        414818  https://www.swiggy.com/restaurants/ath-all-thi...   \n",
       "20        424616  https://www.swiggy.com/restaurants/sea-spice-m...   \n",
       "21         12808  https://www.swiggy.com/restaurants/a2b-adyar-a...   \n",
       "22          2915  https://www.swiggy.com/restaurants/watsons-vas...   \n",
       "23        620897  https://www.swiggy.com/restaurants/narmada-cha...   \n",
       "24        609247  https://www.swiggy.com/restaurants/the-cake-fa...   \n",
       "25        698511  https://www.swiggy.com/restaurants/burma-burma...   \n",
       "26        464509  https://www.swiggy.com/restaurants/leons-burge...   \n",
       "27        263637  https://www.swiggy.com/restaurants/pure-veg-me...   \n",
       "28          2824  https://www.swiggy.com/restaurants/fanoos-john...   \n",
       "29        643832  https://www.swiggy.com/restaurants/wefit-bowls...   \n",
       "\n",
       "                               Retaurant Name Rating price_for_one_two  \\\n",
       "0   Paris Panini - Gourmet Sandwiches & Wraps    4.5      ₹500 FOR TWO   \n",
       "1                               Meghana Foods    4.5      ₹500 FOR TWO   \n",
       "2                                     Chianti    4.4     ₹1250 FOR TWO   \n",
       "3                           Kannur Food Point    3.9      ₹300 FOR TWO   \n",
       "4                                     Rahhams    4.3      ₹700 FOR TWO   \n",
       "5                                Hotel Empire    4.3      ₹450 FOR TWO   \n",
       "6                          California Burrito    4.5      ₹250 FOR TWO   \n",
       "7                            Royal Restaurant    3.9      ₹300 FOR TWO   \n",
       "8                                        Misu    4.4     ₹1300 FOR TWO   \n",
       "9                  Empire Juices and Desserts    4.0      ₹200 FOR TWO   \n",
       "10                             New Taj Darbar    3.4      ₹300 FOR TWO   \n",
       "11                                Burger King    4.1      ₹350 FOR TWO   \n",
       "12                                   Truffles    4.4      ₹450 FOR TWO   \n",
       "13                                     Al-Bek    4.2      ₹500 FOR TWO   \n",
       "14                                  Pizza Hut    3.9      ₹600 FOR TWO   \n",
       "15                             Bikaner Sweets    4.1       ₹99 FOR TWO   \n",
       "16                 Empire Juices and Desserts    4.0      ₹200 FOR TWO   \n",
       "17                                        KFC    3.7      ₹400 FOR TWO   \n",
       "18                        Keventers Ice Cream    4.4      ₹200 FOR TWO   \n",
       "19                  ATH - All Things Healthy!    4.3      ₹200 FOR TWO   \n",
       "20          Sea Spice Multicuisine Restaurant    4.6      ₹400 FOR TWO   \n",
       "21                  A2B - Adyar Ananda Bhavan    4.4      ₹300 FOR TWO   \n",
       "22                                   Watson's    3.2      ₹450 FOR TWO   \n",
       "23                Narmada Chain Of Restaurant    4.4      ₹500 FOR TWO   \n",
       "24                             The cake fancy     --      ₹250 FOR TWO   \n",
       "25                 Burma Burma - Brigade Road     --     ₹1300 FOR TWO   \n",
       "26      Leon's - Burgers & Wings (Leon Grill)    4.3      ₹300 FOR TWO   \n",
       "27                 Pure Veg Meals by Lunchbox    4.0      ₹200 FOR TWO   \n",
       "28                                     Fanoos    4.0      ₹300 FOR TWO   \n",
       "29           WeFit-Bowls, Salads & Sandwiches     --      ₹250 FOR TWO   \n",
       "\n",
       "                                             Cousines  \n",
       "0   Continental, Pastas, Salads, Snacks, Desserts,...  \n",
       "1   Biryani, Andhra, South Indian, North Indian, C...  \n",
       "2           Italian, Pizzas, Salads, Pastas, Desserts  \n",
       "3                                     Kerala, Chinese  \n",
       "4   Biryani, Mughlai, North Indian, Kebabs, Chines...  \n",
       "5                       North Indian, Kebabs, Biryani  \n",
       "6   Mexican, American, Salads, Continental, Keto, ...  \n",
       "7                      Chinese, North Indian, Tandoor  \n",
       "8   Asian, Chinese, Vietnamese, Malaysian, Sushi, ...  \n",
       "9                                   Ice Cream, Juices  \n",
       "10         Biryani, Indian, Chinese, Tandoor, Seafood  \n",
       "11                                  Burgers, American  \n",
       "12           American, Desserts, Continental, Italian  \n",
       "13                          Arabian, Tandoor, Biryani  \n",
       "14                                             Pizzas  \n",
       "15                                             Sweets  \n",
       "16                                  Ice Cream, Juices  \n",
       "17      Burgers, Biryani, American, Snacks, Fast Food  \n",
       "18                                Ice Cream, Desserts  \n",
       "19  Healthy Food, Indian, Bakery, Snacks, North In...  \n",
       "20                          Seafood, Chinese, Biryani  \n",
       "21        South Indian, North Indian, Sweets, Chinese  \n",
       "22  Continental, Chinese, North Indian, Asian, Eur...  \n",
       "23                      Biryani, Andhra, South Indian  \n",
       "24                                             Bakery  \n",
       "25        Burmese, Asian, Salads, Ice Cream, Desserts  \n",
       "26  American, Snacks, Turkish, Portuguese, Contine...  \n",
       "27         Biryani, North Indian, Desserts, Beverages  \n",
       "28                 Biryani, Tandoor, Kebabs, Barbecue  \n",
       "29                 Healthy Food, Salads, Keto, Snacks  "
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.DataFrame(Dlist)\n",
    "df.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "3e780c5c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"Trial1.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "79fa419e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.swiggy.com/restaurants/paris-panini-gourmet-sandwiches-and-wraps-church-street-central-bangalore-bangalore-667962\n",
      "Deviled Egg & Sriracha Wrap\n",
      "340\n",
      "https://www.swiggy.com/restaurants/paris-panini-gourmet-sandwiches-and-wraps-church-street-central-bangalore-bangalore-667962\n",
      "Fried Chicken & Mozzarella Wrap\n",
      "420\n",
      "https://www.swiggy.com/restaurants/paris-panini-gourmet-sandwiches-and-wraps-church-street-central-bangalore-bangalore-667962\n",
      "Peri-Peri Chicken & Mozzarella Wrap\n",
      "380\n",
      "https://www.swiggy.com/restaurants/meghana-foods-residency-road-ashok-nagar-bangalore-3241\n",
      "Paneer 65\n",
      "320\n",
      "https://www.swiggy.com/restaurants/meghana-foods-residency-road-ashok-nagar-bangalore-3241\n",
      "Golden Baby Corn\n",
      "300\n",
      "https://www.swiggy.com/restaurants/meghana-foods-residency-road-ashok-nagar-bangalore-3241\n",
      "Chilly Chicken (Boneless)\n",
      "320\n",
      "https://www.swiggy.com/restaurants/chianti-mg-road-bangalore-109787\n",
      "10\" Pizza Verdure\n",
      "645\n",
      "https://www.swiggy.com/restaurants/chianti-mg-road-bangalore-109787\n",
      "10\" Rustica Pizza\n",
      "645\n",
      "https://www.swiggy.com/restaurants/chianti-mg-road-bangalore-109787\n",
      "10\" Chianti Signature Pizza\n",
      "765\n",
      "https://www.swiggy.com/restaurants/kannur-food-point-sg-palya-tavarekere-bangalore-121603\n",
      "Paneer Hyderabadi\n",
      "260\n",
      "https://www.swiggy.com/restaurants/kannur-food-point-sg-palya-tavarekere-bangalore-121603\n",
      "Paneer Butter Masala\n",
      "130\n",
      "https://www.swiggy.com/restaurants/kannur-food-point-sg-palya-tavarekere-bangalore-121603\n",
      "Mushroom Masala\n",
      "260\n",
      "https://www.swiggy.com/restaurants/rahhams-pulikeshi-nagar-frazer-town-bangalore-574263\n",
      "Mutton Biryani R (portion Size : 900 Grams Net ) (serves -1)\n",
      "699\n",
      "https://www.swiggy.com/restaurants/rahhams-pulikeshi-nagar-frazer-town-bangalore-574263\n",
      "Chicken Biryani R (portion Size : 900 Grams Net ) (serves -1)\n",
      "549\n",
      "https://www.swiggy.com/restaurants/rahhams-pulikeshi-nagar-frazer-town-bangalore-574263\n",
      "Mutton Biryani + Cool Drink[r]+2piece Chicken Kabab\n",
      "749\n",
      "https://www.swiggy.com/restaurants/hotel-empire-brigade-road-bangalore-30531\n",
      "Bucket Chicken Biriyani\n",
      "1260\n",
      "https://www.swiggy.com/restaurants/hotel-empire-brigade-road-bangalore-30531\n",
      "Bucket Biriyani With Chicken Kabab\n",
      "1575\n",
      "https://www.swiggy.com/restaurants/hotel-empire-brigade-road-bangalore-30531\n",
      "Bucket Biriyani With Fiery Wings\n",
      "1631\n",
      "https://www.swiggy.com/restaurants/california-burrito-gandhi-bazaar-basavanagudi-bangalore-484182\n",
      "Grilled Barbeque Chicken Rice Bowl (Regular)\n",
      "309\n",
      "https://www.swiggy.com/restaurants/california-burrito-gandhi-bazaar-basavanagudi-bangalore-484182\n",
      "Crispy Peri Peri Chicken Rice Bowl (Regular)\n",
      "309\n",
      "https://www.swiggy.com/restaurants/california-burrito-gandhi-bazaar-basavanagudi-bangalore-484182\n",
      "Barbeque Paneer Rice Bowl (Regular)\n",
      "309\n",
      "https://www.swiggy.com/restaurants/royal-restaurant-sulthangunta-shivajinagar-bangalore-210945\n",
      "Mutton Biryani\n",
      "280\n",
      "https://www.swiggy.com/restaurants/royal-restaurant-sulthangunta-shivajinagar-bangalore-210945\n",
      "Ghee Rice\n",
      "182\n",
      "https://www.swiggy.com/restaurants/royal-restaurant-sulthangunta-shivajinagar-bangalore-210945\n",
      "Biryani Rice\n",
      "105\n",
      "https://www.swiggy.com/restaurants/misu-ashok-nagar-st-marks-road-bangalore-29063\n",
      "Steamed Wonton Chilli Dumpling Veg\n",
      "445\n",
      "https://www.swiggy.com/restaurants/misu-ashok-nagar-st-marks-road-bangalore-29063\n",
      "Steamed Wonton Chilli Dumpling Chicken\n",
      "475\n",
      "https://www.swiggy.com/restaurants/misu-ashok-nagar-st-marks-road-bangalore-29063\n",
      "Wonton Wasabi Mayo Chicken\n",
      "475\n",
      "https://www.swiggy.com/restaurants/empire-juices-and-desserts-gandhi-nagar-majestic-bangalore-280474\n",
      "Matka Kulfi\n",
      "107\n",
      "https://www.swiggy.com/restaurants/empire-juices-and-desserts-gandhi-nagar-majestic-bangalore-280474\n",
      "Mango Malba\n",
      "105\n",
      "https://www.swiggy.com/restaurants/empire-juices-and-desserts-gandhi-nagar-majestic-bangalore-280474\n",
      "Mango Punch Cooler\n",
      "75\n",
      "https://www.swiggy.com/restaurants/new-taj-darbar-saint-marys-church-road-shivajinagar-bangalore-196047\n",
      "Veg Fried Rice\n",
      "80\n",
      "https://www.swiggy.com/restaurants/new-taj-darbar-saint-marys-church-road-shivajinagar-bangalore-196047\n",
      "Egg Fried Rice\n",
      "100\n",
      "https://www.swiggy.com/restaurants/new-taj-darbar-saint-marys-church-road-shivajinagar-bangalore-196047\n",
      "Schezwan Chicken Fried Rice\n",
      "130\n",
      "https://www.swiggy.com/restaurants/burger-king-tasker-town-shivaji-nagar-bangalore-5938\n",
      "Veg Whopper\n",
      "179\n",
      "https://www.swiggy.com/restaurants/burger-king-tasker-town-shivaji-nagar-bangalore-5938\n",
      "Chicken Whopper\n",
      "199\n",
      "https://www.swiggy.com/restaurants/burger-king-tasker-town-shivaji-nagar-bangalore-5938\n",
      "Crispy Veg Double Patty Burger\n",
      "95\n",
      "https://www.swiggy.com/restaurants/truffles-ashok-nagar-st-marks-road-bangalore-3369\n",
      "Veg Baked Chocolate Cheese Cake\n",
      "171.43\n",
      "https://www.swiggy.com/restaurants/truffles-ashok-nagar-st-marks-road-bangalore-3369\n",
      "Baked Strawberry Cheese Cake Veg\n",
      "171.43\n",
      "https://www.swiggy.com/restaurants/truffles-ashok-nagar-st-marks-road-bangalore-3369\n",
      "Banoffee Pie\n",
      "171.43\n",
      "https://www.swiggy.com/restaurants/al-bek-sampige-road-malleshwaram-bangalore-252332\n",
      "Gulab Jamun [06pcs]\n",
      "120\n",
      "https://www.swiggy.com/restaurants/al-bek-sampige-road-malleshwaram-bangalore-252332\n",
      "Gulab Jamun [03pcs]\n",
      "60\n",
      "https://www.swiggy.com/restaurants/al-bek-sampige-road-malleshwaram-bangalore-252332\n",
      "Paneer Platter\n",
      "1000\n",
      "https://www.swiggy.com/restaurants/pizza-hut-shanti-nagar-bangalore-10575\n",
      "Schezwan Margherita - New\n",
      "219\n",
      "https://www.swiggy.com/restaurants/pizza-hut-shanti-nagar-bangalore-10575\n",
      "Mexican Fiesta - New\n",
      "319\n",
      "https://www.swiggy.com/restaurants/pizza-hut-shanti-nagar-bangalore-10575\n",
      "Cheezy Mushroom Magic - New\n",
      "319\n",
      "https://www.swiggy.com/restaurants/bikaner-sweets-4th-t-block-jayanagar-bangalore-424609\n",
      "Vada Pav\n",
      "25\n",
      "https://www.swiggy.com/restaurants/bikaner-sweets-4th-t-block-jayanagar-bangalore-424609\n",
      "Jalebi (250 gms)\n",
      "75\n",
      "https://www.swiggy.com/restaurants/bikaner-sweets-4th-t-block-jayanagar-bangalore-424609\n",
      "Vada Pav\n",
      "25\n",
      "https://www.swiggy.com/restaurants/empire-juices-and-desserts-gandhi-nagar-majestic-bangalore-280474\n",
      "Matka Kulfi\n",
      "107\n",
      "https://www.swiggy.com/restaurants/empire-juices-and-desserts-gandhi-nagar-majestic-bangalore-280474\n",
      "Mango Malba\n",
      "105\n",
      "https://www.swiggy.com/restaurants/empire-juices-and-desserts-gandhi-nagar-majestic-bangalore-280474\n",
      "Mango Punch Cooler\n",
      "75\n",
      "https://www.swiggy.com/restaurants/kfc-garuda-mall-magrath-road-bangalore-30959\n",
      "Biryani combo - for 2\n",
      "795.24\n",
      "https://www.swiggy.com/restaurants/kfc-garuda-mall-magrath-road-bangalore-30959\n",
      "Zinger & Chicken Combo -for 2\n",
      "524.76\n",
      "https://www.swiggy.com/restaurants/kfc-garuda-mall-magrath-road-bangalore-30959\n",
      "Chicken Longer Burger & 2 Strips Combo\n",
      "219.05\n",
      "https://www.swiggy.com/restaurants/keventers-ice-cream-garuda-mall-magrath-road-bangalore-420484\n",
      "Belgian Chocolate Ice Cream [100 ml]\n",
      "83.90\n",
      "https://www.swiggy.com/restaurants/keventers-ice-cream-garuda-mall-magrath-road-bangalore-420484\n",
      "Triple Chocolate Ice cream [100 ml]\n",
      "83.90\n",
      "https://www.swiggy.com/restaurants/keventers-ice-cream-garuda-mall-magrath-road-bangalore-420484\n",
      "Alphonso Mango Ice Cream [100 ml]\n",
      "83.90\n",
      "https://www.swiggy.com/restaurants/ath-all-things-healthy-doopanahalli-indiranagar-bangalore-414818\n",
      "Grilled Cheese Sandwich - 50 Gms Protein Chef Pro Meals\n",
      "299\n",
      "https://www.swiggy.com/restaurants/ath-all-things-healthy-doopanahalli-indiranagar-bangalore-414818\n",
      "Paneer Sandwich - 50 Gms Protein Chef Pro Meals\n",
      "299\n",
      "https://www.swiggy.com/restaurants/ath-all-things-healthy-doopanahalli-indiranagar-bangalore-414818\n",
      "Chicken Keema Sandwich - 50 Gms Protein Chef Pro Meals\n",
      "349\n",
      "https://www.swiggy.com/restaurants/sea-spice-multicuisine-restaurant-sampige-road-malleshwaram-bangalore-424616\n",
      "Gobi Manchurian\n",
      "180\n",
      "https://www.swiggy.com/restaurants/sea-spice-multicuisine-restaurant-sampige-road-malleshwaram-bangalore-424616\n",
      "Mushroom Pepper Chilly\n",
      "190\n",
      "https://www.swiggy.com/restaurants/sea-spice-multicuisine-restaurant-sampige-road-malleshwaram-bangalore-424616\n",
      "Chicken Biryani (Hyderabadi Style)\n",
      "220\n",
      "https://www.swiggy.com/restaurants/a2b-adyar-ananda-bhavan-wilson-garden-shanti-nagar-bangalore-12808\n",
      "Green Peas Masala\n",
      "210\n",
      "https://www.swiggy.com/restaurants/a2b-adyar-ananda-bhavan-wilson-garden-shanti-nagar-bangalore-12808\n",
      "Palak Mushroom\n",
      "240\n",
      "https://www.swiggy.com/restaurants/a2b-adyar-ananda-bhavan-wilson-garden-shanti-nagar-bangalore-12808\n",
      "Palak Paneer\n",
      "250\n",
      "https://www.swiggy.com/restaurants/watsons-vasanth-nagar-bangalore-2915\n",
      "Pork Chili\n",
      "425\n",
      "https://www.swiggy.com/restaurants/watsons-vasanth-nagar-bangalore-2915\n",
      "Pandi Dry\n",
      "425\n",
      "https://www.swiggy.com/restaurants/watsons-vasanth-nagar-bangalore-2915\n",
      "Kudla Garlic Pork\n",
      "425\n",
      "https://www.swiggy.com/restaurants/narmada-chain-of-restaurant-madhavraya-mudaliar-raod-frazer-town-bangalore-620897\n",
      "Chilly Baby Corn\n",
      "250\n",
      "https://www.swiggy.com/restaurants/narmada-chain-of-restaurant-madhavraya-mudaliar-raod-frazer-town-bangalore-620897\n",
      "Gobi 65\n",
      "235\n",
      "https://www.swiggy.com/restaurants/narmada-chain-of-restaurant-madhavraya-mudaliar-raod-frazer-town-bangalore-620897\n",
      "Gobi Chilly\n",
      "235\n",
      "https://www.swiggy.com/restaurants/the-cake-fancy-patelamma-temple-street-basavanagudi-bangalore-609247\n",
      "Chocolate dutch truffle cake\n",
      "425\n",
      "https://www.swiggy.com/restaurants/the-cake-fancy-patelamma-temple-street-basavanagudi-bangalore-609247\n",
      "Royal truffle chocolate cake\n",
      "439\n",
      "https://www.swiggy.com/restaurants/the-cake-fancy-patelamma-temple-street-basavanagudi-bangalore-609247\n",
      "Death by chocolate cake\n",
      "438\n",
      "https://www.swiggy.com/restaurants/burma-burma-brigade-road-gr-floor-brigade-road-bangalore-698511\n",
      "Samuza Hincho\n",
      "380\n",
      "https://www.swiggy.com/restaurants/burma-burma-brigade-road-gr-floor-brigade-road-bangalore-698511\n",
      "Chickpea Tohu Soup\n",
      "360\n",
      "https://www.swiggy.com/restaurants/burma-burma-brigade-road-gr-floor-brigade-road-bangalore-698511\n",
      "Mohinga Noodle Soup\n",
      "360\n",
      "https://www.swiggy.com/restaurants/leons-burgers-and-wings-leon-grill-pulkeshi-nagar-frazer-town-bangalore-464509\n",
      "Grilled Lamb Burger Combo\n",
      "460\n",
      "https://www.swiggy.com/restaurants/leons-burgers-and-wings-leon-grill-pulkeshi-nagar-frazer-town-bangalore-464509\n",
      "Jumbo Royal Burger Combo\n",
      "470.95\n",
      "https://www.swiggy.com/restaurants/leons-burgers-and-wings-leon-grill-pulkeshi-nagar-frazer-town-bangalore-464509\n",
      "Chicken Fillet Burger Combo\n",
      "388.57\n",
      "https://www.swiggy.com/restaurants/pure-veg-meals-by-lunchbox-1st-main-rd-vasanth-nagar-bangalore-263637\n",
      "Dal Makhani, Rice Lunchbox with Gulab Jamun (2 pcs)\n",
      "218\n",
      "https://www.swiggy.com/restaurants/pure-veg-meals-by-lunchbox-1st-main-rd-vasanth-nagar-bangalore-263637\n",
      "Dal Makhani & Rice Lunchbox\n",
      "199\n",
      "https://www.swiggy.com/restaurants/pure-veg-meals-by-lunchbox-1st-main-rd-vasanth-nagar-bangalore-263637\n",
      "Palak Paneer Rice Lunchbox\n",
      "229\n",
      "https://www.swiggy.com/restaurants/fanoos-johnson-market-richmond-road-bangalore-2824\n",
      "Chilly Beef Plate\n",
      "106\n",
      "https://www.swiggy.com/restaurants/fanoos-johnson-market-richmond-road-bangalore-2824\n",
      "Beef Sheek Roll (1 Pc)\n",
      "93\n",
      "https://www.swiggy.com/restaurants/fanoos-johnson-market-richmond-road-bangalore-2824\n",
      "Beef Sheek Kebab 1 Plate\n",
      "138\n",
      "https://www.swiggy.com/restaurants/wefit-bowls-salads-and-sandwiches-langford-road-santhinagar-bangalore-643832\n",
      "Paneer Tikka Whole Bowl\n",
      "249\n",
      "https://www.swiggy.com/restaurants/wefit-bowls-salads-and-sandwiches-langford-road-santhinagar-bangalore-643832\n",
      "Paneer Peri Peri Power Bowl\n",
      "259\n",
      "https://www.swiggy.com/restaurants/wefit-bowls-salads-and-sandwiches-langford-road-santhinagar-bangalore-643832\n",
      "Chicken Tikka Super Bowl\n",
      "289\n",
      "https://www.swiggy.com/restaurants/shrinidhi-military-hotel-south-end-road-basavanagudi-bangalore-375141\n",
      "Mutton Leg Soup With 1 Leg Piece\n",
      "145\n",
      "https://www.swiggy.com/restaurants/shrinidhi-military-hotel-south-end-road-basavanagudi-bangalore-375141\n",
      "Mutton Leg Soup\n",
      "33\n",
      "https://www.swiggy.com/restaurants/shrinidhi-military-hotel-south-end-road-basavanagudi-bangalore-375141\n",
      "Mutton Fry\n",
      "256\n",
      "https://www.swiggy.com/restaurants/aromas-of-biryani-jayanagar-bangalore-576474\n",
      "Coke - 330ml Can\n",
      "70\n",
      "https://www.swiggy.com/restaurants/aromas-of-biryani-jayanagar-bangalore-576474\n",
      "Sprite - 330ml Can\n",
      "70\n",
      "https://www.swiggy.com/restaurants/aromas-of-biryani-jayanagar-bangalore-576474\n",
      "Thums Up - 330ml Can\n",
      "70\n",
      "https://www.swiggy.com/restaurants/donne-biryani-house-sampige-road-malleshwaram-bangalore-32738\n",
      "Pepper Chicken\n",
      "160\n",
      "https://www.swiggy.com/restaurants/donne-biryani-house-sampige-road-malleshwaram-bangalore-32738\n",
      "Guntur Chicken\n",
      "180\n",
      "https://www.swiggy.com/restaurants/donne-biryani-house-sampige-road-malleshwaram-bangalore-32738\n",
      "Chilli Chicken\n",
      "160\n",
      "https://www.swiggy.com/restaurants/cakezone-domlur-layout-bangalore-29784\n",
      "Pineapple Dessert Jar Cake\n",
      "129\n",
      "https://www.swiggy.com/restaurants/cakezone-domlur-layout-bangalore-29784\n",
      "Rasmalai Jar cake\n",
      "179\n",
      "https://www.swiggy.com/restaurants/cakezone-domlur-layout-bangalore-29784\n",
      "Gulab Jamun Red Velvet Jar Cake\n",
      "179\n",
      "https://www.swiggy.com/restaurants/roti-ghar-gandhi-bazaar-main-road-basavanagudi-bangalore-94759\n",
      "Half Friedrice With Half Gobi Manchurian\n",
      "140\n",
      "https://www.swiggy.com/restaurants/roti-ghar-gandhi-bazaar-main-road-basavanagudi-bangalore-94759\n",
      "Butter Naan (1 Pc)\n",
      "60\n",
      "https://www.swiggy.com/restaurants/roti-ghar-gandhi-bazaar-main-road-basavanagudi-bangalore-94759\n",
      "Roti (1 Pc)\n",
      "40\n",
      "https://www.swiggy.com/restaurants/corner-house-ice-cream-residency-road-ashok-nagar-bangalore-5247\n",
      "Black Forest Cake With Ice Cream And Chocolate Sauce\n",
      "175\n",
      "https://www.swiggy.com/restaurants/corner-house-ice-cream-residency-road-ashok-nagar-bangalore-5247\n",
      "Black Currant Ice Cream (Single Scoop)\n",
      "80\n",
      "https://www.swiggy.com/restaurants/corner-house-ice-cream-residency-road-ashok-nagar-bangalore-5247\n",
      "Pista Ice Cream (Single Scoop)\n",
      "70\n",
      "https://www.swiggy.com/restaurants/hotel-moon-light-kuvempu-road-malleshwaram-bangalore-382861\n",
      "Ghee Rice\n",
      "110\n",
      "https://www.swiggy.com/restaurants/hotel-moon-light-kuvempu-road-malleshwaram-bangalore-382861\n",
      "Jeera Rice\n",
      "135\n",
      "https://www.swiggy.com/restaurants/hotel-moon-light-kuvempu-road-malleshwaram-bangalore-382861\n",
      "Biryani Rice\n",
      "140\n",
      "https://www.swiggy.com/restaurants/svss-biryani-cmh-road-indiranagar-bangalore-426393\n",
      "Chicken Boneless Dum Biryani 1 Kg\n",
      "320\n",
      "https://www.swiggy.com/restaurants/svss-biryani-cmh-road-indiranagar-bangalore-426393\n",
      "Chicken Dum Biryani 1 kg\n",
      "299\n",
      "https://www.swiggy.com/restaurants/svss-biryani-cmh-road-indiranagar-bangalore-426393\n",
      "Chicken Mutton Mix Biryani 1 kg\n",
      "349\n",
      "https://www.swiggy.com/restaurants/siddique-kabab-centre-coles-park-frazer-town-bangalore-380655\n",
      "Tandoori Chicken\n",
      "206\n",
      "https://www.swiggy.com/restaurants/siddique-kabab-centre-coles-park-frazer-town-bangalore-380655\n",
      "Andar Bahar\n",
      "150\n",
      "https://www.swiggy.com/restaurants/siddique-kabab-centre-coles-park-frazer-town-bangalore-380655\n",
      "Boneless Andhra Tikka\n",
      "150\n",
      "https://www.swiggy.com/restaurants/new-shanti-sagar-3rd-block-rajajinagar-bangalore-40443\n",
      "Shahi Paneer\n",
      "215\n",
      "https://www.swiggy.com/restaurants/new-shanti-sagar-3rd-block-rajajinagar-bangalore-40443\n",
      "Butter Kulcha\n",
      "50\n",
      "https://www.swiggy.com/restaurants/new-shanti-sagar-3rd-block-rajajinagar-bangalore-40443\n",
      "Masala Puri\n",
      "65\n",
      "https://www.swiggy.com/restaurants/n-razakhiya-hotel-umar-nagar-nagawara-bangalore-443424\n",
      "Beef Biryani\n",
      "190\n",
      "https://www.swiggy.com/restaurants/n-razakhiya-hotel-umar-nagar-nagawara-bangalore-443424\n",
      "Ghee Rice\n",
      "129\n",
      "https://www.swiggy.com/restaurants/n-razakhiya-hotel-umar-nagar-nagawara-bangalore-443424\n",
      "Masala Rice\n",
      "139\n",
      "https://www.swiggy.com/restaurants/freshmenu-johnson-market-richmond-road-bangalore-6924\n",
      "Classic Mac n Cheese Steak Meal\n",
      "299\n",
      "https://www.swiggy.com/restaurants/freshmenu-johnson-market-richmond-road-bangalore-6924\n",
      "Teriyaki Chicken Rice Bowl\n",
      "149\n",
      "https://www.swiggy.com/restaurants/freshmenu-johnson-market-richmond-road-bangalore-6924\n",
      "Mexican Burrito Bowl\n",
      "299\n",
      "https://www.swiggy.com/restaurants/chikpet-donne-biryani-house-palace-guttahalli-palace-guttahalli-seshadripuram-bangalore-222046\n",
      "Boiled Egg (1 Pcs)\n",
      "20\n",
      "https://www.swiggy.com/restaurants/chikpet-donne-biryani-house-palace-guttahalli-palace-guttahalli-seshadripuram-bangalore-222046\n",
      "Chicken Pepper Dry\n",
      "150\n",
      "https://www.swiggy.com/restaurants/chikpet-donne-biryani-house-palace-guttahalli-palace-guttahalli-seshadripuram-bangalore-222046\n",
      "Guntur Chicken\n",
      "150\n",
      "https://www.swiggy.com/restaurants/nagarjuna-residency-road-ashok-nagar-bangalore-41100\n",
      "Bhojanam In A Box (Andhra Meal For 1)\n",
      "305\n",
      "https://www.swiggy.com/restaurants/nagarjuna-residency-road-ashok-nagar-bangalore-41100\n",
      "Carrier Meal (Andhra Meal For 2-3 People)\n",
      "539\n",
      "https://www.swiggy.com/restaurants/nagarjuna-residency-road-ashok-nagar-bangalore-41100\n",
      "Mutton Biriyani\n",
      "385\n",
      "https://www.swiggy.com/restaurants/al-zara-mandi-arabian-restaurant-mm-road-frazer-town-bangalore-264863\n",
      "Thumbs Up (2 Variants)\n",
      "25\n",
      "https://www.swiggy.com/restaurants/al-zara-mandi-arabian-restaurant-mm-road-frazer-town-bangalore-264863\n",
      "Sprite\n",
      "25\n",
      "https://www.swiggy.com/restaurants/al-zara-mandi-arabian-restaurant-mm-road-frazer-town-bangalore-264863\n",
      "Chicken 65\n",
      "334\n",
      "https://www.swiggy.com/restaurants/maven-kitchen-vivek-nagar-ejipura-bangalore-252667\n",
      "Fresh Pork Bamboo Shoot\n",
      "300\n",
      "https://www.swiggy.com/restaurants/maven-kitchen-vivek-nagar-ejipura-bangalore-252667\n",
      "Smoked Pork Anishi Combo\n",
      "400\n",
      "https://www.swiggy.com/restaurants/maven-kitchen-vivek-nagar-ejipura-bangalore-252667\n",
      "Smoked Pork Axone Combo\n",
      "390\n",
      "https://www.swiggy.com/restaurants/razakhiya-hotel-3rd-stage-hebbala-bangalore-478720\n",
      "Masala Rice\n",
      "120\n",
      "https://www.swiggy.com/restaurants/razakhiya-hotel-3rd-stage-hebbala-bangalore-478720\n",
      "Beef Biryani\n",
      "160\n",
      "https://www.swiggy.com/restaurants/razakhiya-hotel-3rd-stage-hebbala-bangalore-478720\n",
      "Ghee Rice\n",
      "60\n",
      "https://www.swiggy.com/restaurants/raidan-1st-block-r-t-nagar-bangalore-432536\n",
      "French Fries\n",
      "140\n",
      "https://www.swiggy.com/restaurants/raidan-1st-block-r-t-nagar-bangalore-432536\n",
      "Chicken Tikka Roll\n",
      "208\n",
      "https://www.swiggy.com/restaurants/raidan-1st-block-r-t-nagar-bangalore-432536\n",
      "Hummus 250ml\n",
      "220\n",
      "https://www.swiggy.com/restaurants/imperial-restaurant-central-street-mg-road-bangalore-48556\n",
      "Chilli Chicken (Boneless)\n",
      "145\n",
      "https://www.swiggy.com/restaurants/imperial-restaurant-central-street-mg-road-bangalore-48556\n",
      "Crispy Honey Chicken\n",
      "125\n",
      "https://www.swiggy.com/restaurants/imperial-restaurant-central-street-mg-road-bangalore-48556\n",
      "Pepper Chicken Dry\n",
      "135\n",
      "https://www.swiggy.com/restaurants/chicken-county-restaurant-gandhi-nagar-k-g-circle-majestic-bangalore-137297\n",
      "Chicken Biriyani\n",
      "245\n",
      "https://www.swiggy.com/restaurants/chicken-county-restaurant-gandhi-nagar-k-g-circle-majestic-bangalore-137297\n",
      "Mutton Biriyani\n",
      "315\n",
      "https://www.swiggy.com/restaurants/chicken-county-restaurant-gandhi-nagar-k-g-circle-majestic-bangalore-137297\n",
      "Fish Biriyani\n",
      "450\n",
      "https://www.swiggy.com/restaurants/call-me-chow-8th-block-koramangala-bangalore-307050\n",
      "Chicken Fried Rice\n",
      "219\n",
      "https://www.swiggy.com/restaurants/call-me-chow-8th-block-koramangala-bangalore-307050\n",
      "Chicken Schezwan Fried Rice\n",
      "229\n",
      "https://www.swiggy.com/restaurants/call-me-chow-8th-block-koramangala-bangalore-307050\n",
      "Egg Fried Rice\n",
      "219\n"
     ]
    },
    {
     "ename": "NoSuchWindowException",
     "evalue": "Message: no such window: target window already closed\nfrom unknown error: web view not found\n  (Session info: chrome=114.0.5735.134)\nStacktrace:\nBacktrace:\n\tGetHandleVerifier [0x0078A813+48355]\n\t(No symbol) [0x0071C4B1]\n\t(No symbol) [0x00625358]\n\t(No symbol) [0x0060D293]\n\t(No symbol) [0x0066E37B]\n\t(No symbol) [0x0067C473]\n\t(No symbol) [0x0066A536]\n\t(No symbol) [0x006482DC]\n\t(No symbol) [0x006493DD]\n\tGetHandleVerifier [0x009EAABD+2539405]\n\tGetHandleVerifier [0x00A2A78F+2800735]\n\tGetHandleVerifier [0x00A2456C+2775612]\n\tGetHandleVerifier [0x008151E0+616112]\n\t(No symbol) [0x00725F8C]\n\t(No symbol) [0x00722328]\n\t(No symbol) [0x0072240B]\n\t(No symbol) [0x00714FF7]\n\tBaseThreadInitThunk [0x75E300C9+25]\n\tRtlGetAppContainerNamedObjectPath [0x77877B4E+286]\n\tRtlGetAppContainerNamedObjectPath [0x77877B1E+238]\n",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNoSuchWindowException\u001b[0m                     Traceback (most recent call last)",
      "\u001b[1;32m~\\AppData\\Local\\Temp\\ipykernel_12216\\2420269110.py\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m     12\u001b[0m         \u001b[0mhtml\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msend_keys\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mKeys\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mPAGE_DOWN\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     13\u001b[0m         \u001b[0msleep\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m2\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 14\u001b[1;33m     \u001b[0mdishes\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mDriver\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfind_elements\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mBy\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mCLASS_NAME\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m\"styles_itemNameText__3ZmZZ\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     15\u001b[0m     \u001b[0mprices\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mDriver\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfind_elements\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mBy\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mCLASS_NAME\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"rupee\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     16\u001b[0m     \u001b[1;32mfor\u001b[0m \u001b[0mk\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m3\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webdriver.py\u001b[0m in \u001b[0;36mfind_elements\u001b[1;34m(self, by, value)\u001b[0m\n\u001b[0;32m    768\u001b[0m         \u001b[1;31m# Return empty list if driver returns null\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    769\u001b[0m         \u001b[1;31m# See https://github.com/SeleniumHQ/selenium/issues/4555\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 770\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mCommand\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mFIND_ELEMENTS\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;34m\"using\"\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mby\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"value\"\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m\"value\"\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;32mor\u001b[0m \u001b[1;33m[\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    771\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    772\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webdriver.py\u001b[0m in \u001b[0;36mexecute\u001b[1;34m(self, driver_command, params)\u001b[0m\n\u001b[0;32m    344\u001b[0m         \u001b[0mresponse\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcommand_executor\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdriver_command\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    345\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 346\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0merror_handler\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcheck_response\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mresponse\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    347\u001b[0m             \u001b[0mresponse\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m\"value\"\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_unwrap_value\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mresponse\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"value\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    348\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\errorhandler.py\u001b[0m in \u001b[0;36mcheck_response\u001b[1;34m(self, response)\u001b[0m\n\u001b[0;32m    243\u001b[0m                 \u001b[0malert_text\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m\"alert\"\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"text\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    244\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0malert_text\u001b[0m\u001b[1;33m)\u001b[0m  \u001b[1;31m# type: ignore[call-arg]  # mypy is not smart enough here\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 245\u001b[1;33m         \u001b[1;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNoSuchWindowException\u001b[0m: Message: no such window: target window already closed\nfrom unknown error: web view not found\n  (Session info: chrome=114.0.5735.134)\nStacktrace:\nBacktrace:\n\tGetHandleVerifier [0x0078A813+48355]\n\t(No symbol) [0x0071C4B1]\n\t(No symbol) [0x00625358]\n\t(No symbol) [0x0060D293]\n\t(No symbol) [0x0066E37B]\n\t(No symbol) [0x0067C473]\n\t(No symbol) [0x0066A536]\n\t(No symbol) [0x006482DC]\n\t(No symbol) [0x006493DD]\n\tGetHandleVerifier [0x009EAABD+2539405]\n\tGetHandleVerifier [0x00A2A78F+2800735]\n\tGetHandleVerifier [0x00A2456C+2775612]\n\tGetHandleVerifier [0x008151E0+616112]\n\t(No symbol) [0x00725F8C]\n\t(No symbol) [0x00722328]\n\t(No symbol) [0x0072240B]\n\t(No symbol) [0x00714FF7]\n\tBaseThreadInitThunk [0x75E300C9+25]\n\tRtlGetAppContainerNamedObjectPath [0x77877B4E+286]\n\tRtlGetAppContainerNamedObjectPath [0x77877B1E+238]\n"
     ]
    }
   ],
   "source": [
    "Elist=[]\n",
    "for i in range(100):\n",
    "    Driver=webdriver.Chrome(options=webdriver.ChromeOptions())\n",
    "    Driver.get(df[\"Restaurant_link\"].iloc[i])\n",
    "    sleep(5)\n",
    "    location=Driver.find_element(By.CLASS_NAME,\"RestaurantNameAddress_area__2P9ib\")\n",
    "    Review_count=Driver.find_element(By.CLASS_NAME,\"RestaurantRatings_totalRatings__3d6Zc\")\n",
    "   \n",
    "   \n",
    "    html = Driver.find_element(By.TAG_NAME, 'html')  \n",
    "    for j in range(2):\n",
    "        html.send_keys(Keys.PAGE_DOWN)\n",
    "        sleep(2)\n",
    "    dishes=Driver.find_elements(By.CLASS_NAME,\"styles_itemNameText__3ZmZZ\")\n",
    "    prices=Driver.find_elements(By.CLASS_NAME, \"rupee\")\n",
    "    for k in range(20):\n",
    "        dish=dishes[k].text\n",
    "        price=prices[k].text\n",
    "#         print(df[\"Restaurant_link\"].iloc[i])\n",
    "#         print(dish)\n",
    "#         print(price)\n",
    "        \n",
    "        Elist.append({\"Restaurant_id\":df[\"Restaurant_id\"].iloc[i],\n",
    "                     \"Restaurant_Name\":df[\"Retaurant Name\"].iloc[i],\n",
    "                     \"location\":location.text,\n",
    "                     \"dish_name\":dish,\n",
    "                     \"Price\":price,\n",
    "                     \"Review_count\":Review_count.text})\n",
    "        sleep(1)\n",
    "    \n",
    "\n",
    "    \n",
    "   \n",
    "    \n",
    "    \n",
    "    \n",
    "    Driver.quit()\n",
    " \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "859bb5ef",
   "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>Restaurant_id</th>\n",
       "      <th>Restaurant_Name</th>\n",
       "      <th>location</th>\n",
       "      <th>dish_name</th>\n",
       "      <th>Price</th>\n",
       "      <th>Review_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>667962</td>\n",
       "      <td>Paris Panini - Gourmet Sandwiches &amp; Wraps</td>\n",
       "      <td>Central Bangalore</td>\n",
       "      <td>Deviled Egg &amp; Sriracha Wrap</td>\n",
       "      <td>340</td>\n",
       "      <td>500+ ratings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>667962</td>\n",
       "      <td>Paris Panini - Gourmet Sandwiches &amp; Wraps</td>\n",
       "      <td>Central Bangalore</td>\n",
       "      <td>Fried Chicken &amp; Mozzarella Wrap</td>\n",
       "      <td>420</td>\n",
       "      <td>500+ ratings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>667962</td>\n",
       "      <td>Paris Panini - Gourmet Sandwiches &amp; Wraps</td>\n",
       "      <td>Central Bangalore</td>\n",
       "      <td>Peri-Peri Chicken &amp; Mozzarella Wrap</td>\n",
       "      <td>380</td>\n",
       "      <td>500+ ratings</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Restaurant_id                            Restaurant_Name           location  \\\n",
       "0        667962  Paris Panini - Gourmet Sandwiches & Wraps  Central Bangalore   \n",
       "1        667962  Paris Panini - Gourmet Sandwiches & Wraps  Central Bangalore   \n",
       "2        667962  Paris Panini - Gourmet Sandwiches & Wraps  Central Bangalore   \n",
       "\n",
       "                             dish_name Price  Review_count  \n",
       "0          Deviled Egg & Sriracha Wrap   340  500+ ratings  \n",
       "1      Fried Chicken & Mozzarella Wrap   420  500+ ratings  \n",
       "2  Peri-Peri Chicken & Mozzarella Wrap   380  500+ ratings  "
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2=pd.DataFrame(Elist)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "2a95b48e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv(\"Table2_part_a\")"
   ]
  }
 ],
 "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.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}