Zomato.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 280,
   "id": "61de8655-8dde-4e52-9378-84c91439b613",
   "metadata": {},
   "outputs": [],
   "source": [
    "#importing libraries \n",
    "from selenium import webdriver\n",
    "import selenium \n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium import webdriver # used to control web browsers programmatically\n",
    "from selenium.webdriver.chrome.service import Service #used to manage the lifecycle of the ChromeDriver service.\n",
    "from webdriver_manager.chrome import ChromeDriverManager\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 \n",
    "import pandas as pd \n",
    "import time \n",
    "import csv"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "19e9715a-a16f-42f5-9244-4c1a1f940821",
   "metadata": {},
   "source": [
    "# Task 1 : Web Scraping Zomato restaurant Listings"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "552e2d0b-9d41-46b7-8ca4-b4d366287c93",
   "metadata": {},
   "source": [
    "Objective : Create a python script to scrape a minimum of 300 restaurant listings from zomato and save the data in a pandas dataframe or use gspread \n",
    "library in combination with Google service account to automatically load up the data in a google spreadsheet.  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "03c6f40b-db9c-4c71-9d22-704cd108a3a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "#initialize the chrome Driver \n",
    "driver = webdriver.Chrome(service = Service(ChromeDriverManager().install()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "id": "40ed1e44-27b1-469e-89b2-814b1c9d029d",
   "metadata": {},
   "outputs": [],
   "source": [
    "#open the website \n",
    "driver.get(\"https://www.zomato.com/ncr/delivery\")  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "id": "9f7800fa-82d1-4126-99d8-2f673d472011",
   "metadata": {},
   "outputs": [],
   "source": [
    "def scroll_page(driver):\n",
    "    # Scroll down the page to load all elements dynamically\n",
    "    last_height = driver.execute_script(\"return document.body.scrollHeight\")\n",
    "    while True:\n",
    "        driver.execute_script(\"window.scrollTo(0, document.body.scrollHeight);\")\n",
    "        time.sleep(30)  # Allow time for the page to load\n",
    "        new_height = driver.execute_script(\"return document.body.scrollHeight\")\n",
    "        if new_height == last_height:\n",
    "            break\n",
    "        last_height = new_height\n",
    "\n",
    "        \n",
    "# Use this function before finding elements\n",
    "#scroll_page(driver)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "389018a3-3c8d-4487-8940-5f3f882395ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Number of rows we want to scrap - \n",
    "target_rows = 300 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "id": "a2b0e1cb-3d09-45d5-8908-c65d9a436463",
   "metadata": {},
   "outputs": [],
   "source": [
    "wait = WebDriverWait(driver, 40)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "id": "17e955cf-ddbd-47be-881e-c8a7df7595fa",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Scrolling page...\n",
      "Scrolling complete, looking for containers...\n"
     ]
    }
   ],
   "source": [
    "# Scrolling through the page \n",
    "print(\"Scrolling page...\")\n",
    "scroll_page(driver)\n",
    "print(\"Scrolling complete, looking for containers...\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "id": "6e3f15fe-fb87-49ec-81ef-630236a16422",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Found 744 containers\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# Initialize lists to store the extracted data\n",
    "restaurant_name = []\n",
    "ratings = []\n",
    "cuisine_type = []\n",
    "cost_for_one = []\n",
    "delivery_time = []\n",
    "offers = []\n",
    "urls = []\n",
    "\n",
    "# Wait for the container to load and locate the container\n",
    "try:\n",
    "    containers = wait.until(EC.visibility_of_all_elements_located((By.XPATH, \"//div[contains(@class, 'sc-kDgGX') and contains(@class, 'fjYwDL')]\" )))\n",
    "    print(f\"Found {len(containers)} containers\")\n",
    "except TimeoutException:\n",
    "    print(\"Containers not found\")\n",
    "    containers = []\n",
    "\n",
    "# Extract data from each element\n",
    "for box in containers:\n",
    "    try:\n",
    "        name = box.find_element(By.CLASS_NAME, \"sc-1hp8d8a-0\").text\n",
    "    except:\n",
    "        name = 'N/A'\n",
    "    \n",
    "    try:\n",
    "        rating = box.find_element(By.XPATH, \".//div[@class='sc-1q7bklc-1 cILgox']\").text\n",
    "    except:\n",
    "        rating = 'N/A'\n",
    "    \n",
    "    try:\n",
    "        cuisine = box.find_element(By.XPATH, \".//p[@class='sc-1hez2tp-0 sc-dcOKER zafot']\").text\n",
    "    except:\n",
    "        cuisine = 'N/A'\n",
    "    \n",
    "    try:\n",
    "        cost = box.find_element(By.XPATH, \".//p[@class='sc-1hez2tp-0 sc-dcOKER imYCjj']\").text\n",
    "    except:\n",
    "        cost = 'N/A'\n",
    "    \n",
    "    try:\n",
    "        time = box.find_element(By.XPATH, \".//div[@class='min-basic-info-right']\").text\n",
    "    except:\n",
    "        time = 'N/A'\n",
    "    \n",
    "    try:\n",
    "        offer = box.find_element(By.XPATH, \".//p[@class='sc-1hez2tp-0 sc-hPeUyl kxuuMh']\").text\n",
    "    except:\n",
    "        offer = 'No Offers'\n",
    "    \n",
    "    try:\n",
    "        link = box.find_element(By.TAG_NAME, 'a').get_attribute('href')\n",
    "    except:\n",
    "        link = \"N/A\"\n",
    "    \n",
    "    # Append data to the corresponding lists\n",
    "    restaurant_name.append(name)\n",
    "    ratings.append(rating)\n",
    "    cuisine_type.append(cuisine)\n",
    "    cost_for_one.append(cost)\n",
    "    delivery_time.append(time)\n",
    "    offers.append(offer)\n",
    "    urls.append(link)\n",
    "    \n",
    "    # Check if we have reached the target number of rows\n",
    "    if len(restaurant_name) >= target_rows:\n",
    "        break\n",
    "        \n",
    "#Close the driver \n",
    "driver.quit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 621,
   "id": "73fdb7cc-bbe6-4408-bc67-24a52365e9f8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "restaurant_name: [\"McDonald's\", 'KFC', 'Pizza Hut', \"La Pino'z Pizza\", 'The Burger Club', 'Burger Singh - Big Punjabi Burgers', \"Haldiram's\", \"Kwality Wall's Ice Cream And More\", 'RollsKing', \"Wendy's Burgers\", 'Veer Ji Malai Chaap Wale', 'Nazeer Foods', 'Biryani Blues', 'Bikkgane Biryani', 'Khadak Singh Da Dhaba', 'Bakingo', 'Apni Rasoi', 'Chinese Wok', 'Subway', 'Behrouz Biryani', 'WOW! Momo', 'Gianis - Ice Cream, Shakes & Sundaes', 'The Pizza Kings', 'BTW', 'Bikanervala', 'Faasos - Wraps, Rolls & Shawarma', 'NIC Ice Creams', \"Nirula's\", 'Thalairaj Biryani', 'Daily Kitchen - Homely Meals', 'LunchBox - Meals and Thalis', 'Biryani By Kilo', 'The Waffle Co.', 'Giani', 'Chicago Pizza', 'Rominus Pizza And Burger', 'Vadilal Ice Creams', 'Punjabi Rasoi', 'The Burger Company', 'Flavours', 'Wraps Kathi Rolls', 'Theobroma', 'Ghee and Turmeric', 'Mansi Chinese Food', 'Sweet Truth - Cake and Desserts', 'Baskin Robbins - Ice Cream Desserts', 'MOJO Pizza - 2X Toppings', 'Parantha Express', 'Pizza Galleria', 'NH1 Bowls - Highway To North', 'Sandoz', 'Oven Story Pizza - Standout Toppings', 'Cheesecake & Co.', 'FreshMenu', 'Keventers - Milkshakes & Desserts', 'CakeZone Patisserie', 'Sardar G Malai Chaap Junction', 'Biryani Badshah', 'The Yellow Bowl', 'Olio - The Wood Fired Pizzeria', 'ZAZA Mughal Biryani', 'Keny Premium Food', 'Hussaini Hotel', 'Burgrill - The Win Win Burger', 'Mashaallah Chicken Corner', 'Fleurons - Handcrafted Cakes And Brownies', 'Punjabi Hut', 'Havmor Havfunn Ice Cream', 'SGF - Spice Grill Flame', 'Puran Dhaba', 'EatFit', 'Taco Bell', 'The Biryani Life', 'The Good Bowl', 'King Shawarma', 'Gulab', 'Baking Love Bakers', 'Chai Point', 'House of Chow', 'Keventers Ice Cream', 'ICP Italian Crust Pizza', 'Punjabi Dhaba', 'Louis Burger', 'Great Indian Khichdi by EatFit', 'Momo Shomo', 'Pizza Flix', 'Goila Butter Chicken', 'Burger Point', 'Dhading KTM', \"Berco's - If You Love Chinese\", 'Grameen Kulfi', 'California Burrito', 'Hudson Chopsticks - Fresh Chinese', 'Burgerama', 'Nomad Pizza - Traveller Series', 'Ghar ka Khana by EatFit', 'Kings Kulfi', \"Shivji's Day Night Kitchen\", \"SashMick's Bakery\", 'No. 1 Uncles Parantha', 'Lords Of Shawarma', 'The Momos Booth', 'LeanCrust Pizza - ThinCrust Experts', 'Makhani Darbar', 'Jain Chawal Wale', \"Mealful Rolls - India's Biggest Rolls\", 'Food Bus Of India', '34 Chowringhee Lane', 'Moti Mahal Delux', 'Urban Chulha', 'The Tummy Section', 'Chaayos Chai+Snacks=Relax', 'Prasuma Momo Kitchen', 'Tikka Junction', 'Ghar Ki Rasoi', 'Salad Days', 'Hashtag Foods', 'Simple Burger', \"Dunkin' - Donuts & Coffee\", 'The Dhaba Junction', 'Pizza Studio', 'Veg Meals by Lunchbox', 'Slyce Pizza', \"Qureshi's Kabab Corner\", 'Chinese Corner', 'Flavours Of Punjab', 'Jyoti Chinese Kitchen', 'Concept Shawarma', 'GetAWay - Ice Creams & Desserts', 'Mad Over Donuts', 'Waah Punjabi', 'Kerala Night Kitchen', 'Go Zero - Ice Creams & Desserts', \"Crusto's - Cheese Burst Pizza\", 'Sai Cake And Bake', 'NOTO - Ice Creams & Desserts', 'Sheikh Chang Singh', 'Itminaan Matka Biryani - Slow Cooked', 'Lazeez Kebab & Curries', 'ROLL XPRESS', 'Smoor', 'Andhra Kodi Pulao', 'The Momo Co.', 'Qureshi Fast Food', 'Kake Di Hatti', 'Bawarchi', 'Third Wave Coffee', 'Amritsari Kulcha Factory', 'Changezi Chicken', 'Oh! Hunger', 'BOOM Sandwich - Sub of India', 'Starbucks Coffee', 'Wrap & Roll', 'Abdul Ghani Qureshi Kabab Corner - Jama Masjid', 'NutrioBox', 'Delhi Parantha Company', 'The Brooklyn Creamery - Healthy Ice Cream', \"Hulk's Burger\", 'Chaubara', 'Firangi Bake', 'Creative Chef Baker', 'Khichdi Hub', 'Choko La', 'GLOBO Ice Creams Of The World', 'Handi 47', 'Pink Box', 'Pizza Kingdom', 'The Dessert Heaven - Pure Veg', 'ENSO - Sourdough Pizza by Nomad', 'Rajinder Da Dhaba', 'Chimney Sizzlers', \"Chili's Grill & Bar\", 'Cocoberry', 'Housewife Kitchen', 'The New Shop', 'Oh! Biryani The Taste of Delhi', 'Sai Ki Rasoi', 'Angels In My Kitchen', 'Roll Crave', 'HRX by EatFit', 'Cafe Coffee Day', 'Punjabi Zaika', 'Curry House', 'Brown Sugar - OG Wheat Momos & More', 'Pearl Grill & Cafe', 'The Dessert Zone', 'Yangkiez By Momo Mami', 'Relax Restaurant', 'Guru Kripa Kitchen', 'Punjabi Chaap Corner', 'Pakiza Shahi Chicken Biryani', 'Faasos Signature Wraps and Rolls', 'Student Hub', 'Rollcano', 'Picante - Mexican by Nomad', 'Mister Kiyoshi', \"Saleem's Restaurant\", 'New Hot Pot', 'Buff Grill', 'Bakisto', 'High On Desserts', 'Special No1 Biryani House', 'Le Winkies', 'Swagat - Food Pallette Of India', \"AKU'S - The Burger Co.\", 'Punjabi Nitin Vaishno Dhaba', 'Cafe Delhi Heights', 'Flavours Of Chaap', \"The Karim's Food\", 'Hafiz Foods', 'Handi Chhadeyan Di', 'A One Food Center', 'Ghalib Kabab Corner', 'Capital Diner', 'Blue Water Grille', \"H. Roll's & Shawarma\", 'Havemore', 'Door To Door', 'Railway Yard', 'Healthy Chef', \"Cafe Healthy High By Nirula's\", 'Homemade Kitchen', 'Wat-a-Burger! - India ka Burger', 'The Magician Chef', 'Roll Express', 'Galaxy Pizza', 'Chinese Mania', 'Hotel Le Roi', 'The Delish', 'High On Burgers', 'Gulati', \"Valentino Pizzeria by Nirula's\", 'The F Spot Shawarma & More', 'Para Chicken Point', 'Chaurasia Dhaba', 'Chef Bhaijaans', 'Junkies Zone', \"Amigo's Hub\", 'Khao Dilli', 'Pind Kaneda', 'Shree Manokamana Fast Food', 'Barista Coffee', 'Divine Home Kitchen', 'Chaat Mahal', 'Al Yameen', 'Eat And Smile', 'Aapki Apni Rasoi', 'Ghar Ka Swaad', 'PVR Café', 'Krispy Kreme', 'Chinese Hut', 'Cafe Sandoz', 'Garhwali Rasoi', 'Sabka Chulha', \"Mom's Own Kitchen\", 'Teavaro', 'Frozen Bottle - Milkshakes, Desserts And Ice Cream', 'Delhi Biryani Corner', 'Indigo Paradise Cafe', 'Arabian Delites - Lebanese Legacy Since 1994', \"The Mus'k Bakers\", 'Delights By Inox', 'Star Bite Roll', \"Nagpal's\", 'Oriental Mom', \"Shova's Kitchen\", 'Indian Naan Club', 'White Cub', 'Veg Daawat By Behrouz', 'The Biryani Point', 'Sauce In My Pizza', 'Khushdil Sweets and Milkbar', 'The Great China', 'Uncle Cake Shop', 'Kings Paan', \"Waffle O'Clock\", 'Ballu Bawarchi', 'Bhatti Chicken - Grilled, NOT Fried!', 'Blue Umbrella Cafe & Restaurant', 'Akram Qureshi Foods', 'WarmOven Cake & Desserts', 'FroGo - One Stop Ice Cream Shop', 'SubKing', 'WeFit - Protein Bowls, Salads & Sandwiches', 'Peppy Parathas & Rolls by Chai Point', 'Golden Wings', 'Delhi Cacies', 'Sandoz', 'One Tap Biryani', 'Iconic Food Plaza', 'Desi Mojo', 'The Pizza Project by Oven Story', 'Slurpy Momos', 'Hello G Sas Kitchen', 'Pizza Gallery', 'Hide Out Cafe', 'The Changezi Chicken', 'Dev Rasoi', \"Nagpal's Chole Bhature\", 'FFC Restaurant']\n",
      " \n",
      "ratings: ['4.4', '4.1', '4.0', '4.0', '4.0', '4.2', '4.0', '4.5', '4.1', '4.3', '4.1', '4.1', '4.3', '4.3', '4.3', '4.5', '4.2', '4.2', '3.9', '4.3', '3.8', '4.2', '3.6', '4.2', '4.3', '4.2', '4.5', '4.2', '4.5', '4.3', '4.3', '4.2', '4.3', '4.0', '3.9', '4.2', '4.3', '3.9', '4.3', '3.9', '4.1', '4.5', '4.4', '3.8', '4.3', '4.4', '4.5', '4.2', '4.1', '4.5', '4.1', '4.2', '4.5', '4.1', '4.3', '4.2', '4.4', '4.3', '4.2', '4.3', '4.5', '4.3', '4.1', '4.3', '4.1', '4.2', '3.6', '4.4', '4.0', '4.3', '4.3', '4.1', '4.2', '4.3', '4.1', '4.2', '4.2', '4.2', '4.1', '4.1', '3.4', '3.5', '4.2', '4.5', '4.2', '3.9', '4.1', '4.1', '4.3', '4.0', '4.6', '4.5', '4.1', '4.6', '4.3', '4.4', '4.6', '3.9', '4.4', '4.0', '4.1', '4.0', '4.3', '2.3', '4.1', '4.1', '4.1', '4.2', '4.0', '4.0', '4.2', '4.4', '4.2', '4.0', '4.1', '4.4', '4.3', '4.1', '4.4', '3.8', '4.0', '4.4', '4.2', '4.4', '4.2', '4.0', '3.9', '4.4', '4.4', '4.3', '3.6', '3.8', '4.3', '4.5', '3.3', '4.4', '4.3', '4.1', '4.2', '3.8', '4.5', '4.3', '4.3', '4.3', '4.1', '4.2', '4.4', '4.3', '3.9', '4.2', '4.1', '4.3', '4.0', '4.1', '4.4', '4.2', '4.5', '4.3', '4.1', '4.4', '4.2', '4.3', '4.4', '4.1', '4.2', '4.5', '3.8', '4.0', '4.3', '4.4', '4.3', '4.3', '4.3', '4.3', '3.8', '3.7', '3.5', '3.7', '4.2', '4.4', '4.4', '4.3', '3.8', '4.1', '4.3', '3.7', '3.8', '4.0', '4.4', '4.1', '4.1', '4.4', '4.2', '3.8', '4.2', '3.8', '4.1', '3.7', '4.4', '4.2', '4.2', '3.9', '4.3', '4.1', '4.5', '3.6', '4.3', '4.3', '3.5', '4.2', '4.2', '4.2', '4.3', '4.3', '4.1', '3.9', '4.4', '3.7', '3.8', '4.3', '4.1', '4.3', '4.3', '4.1', '4.1', '4.5', '3.5', '4.2', '4.1', '3.8', '4.5', '3.8', '4.1', '3.9', '4.0', '3.9', '4.1', '4.1', '3.7', '4.6', '4.2', '4.2', '4.3', '3.7', '3.5', '4.4', '3.9', '4.2', '4.3', '4.1', '4.1', '4.1', '3.8', '3.7', '4.1', '4.6', '4.2', '4.2', '3.7', '4.1', '4.1', '4.1', '4.2', '3.6', '3.7', '4.0', '3.7', '3.5', '4.1', '3.6', '3.7', '4.0', '4.1', '4.3', '4.6', '4.1', '4.6', '4.1', '3.9', '4.0', '4.5', '-', '4.2', '4.4', '4.3', '3.5', '4.0', '4.3', '4.2', '4.1', '4.0', '-', '3.8', '3.5', '3.4', '3.9', '3.5', '4.1', '3.6', '4.0']\n",
      " \n",
      "cuisine_type: ['Burger, Wraps, Fast Food, Beverages', 'Burger, Rolls, Fast Food', 'Pizza, Fast Food, Italian, Desserts, Beverages', 'Pizza, Italian, Pasta, Fast Food, Desserts, Beverages', 'Burger, Fast Food, Coffee, Beverages', 'Burger, Fast Food, Momos, Beverages, Desserts', 'North Indian, Chinese, South Indian, Sandwich, Pasta, Desserts, Beverages', 'Ice Cream, Desserts', 'Rolls, North Indian, Beverages, Fast Food', 'Burger, Fast Food, American', 'North Indian, Rolls, Momos, Biryani, Chinese, Shake, Beverages', 'North Indian, Mughlai, Biryani, Rolls, Burger, Fast Food, Beverages', 'Biryani, Hyderabadi, Mughlai', 'Biryani, Hyderabadi, Andhra, North Indian, Mughlai', 'North Indian, Mughlai, Rolls, Chinese, Biryani, Kebab', 'Bakery, Desserts', 'North Indian, Chinese, Fast Food, Beverages', 'Chinese, Momos', 'Healthy Food, Sandwich, Fast Food, Wraps, Salad, Beverages', 'Biryani, Kebab, North Indian', 'Momos, Fast Food, Chinese, Tibetan, Sichuan, Beverages, Desserts', 'Ice Cream, Shake, Desserts', 'Pizza, Pasta, Sandwich, Burger, Fast Food', 'North Indian, South Indian, Chinese, Mithai, Street Food', 'Mithai, North Indian, South Indian, Chinese, Fast Food, Street Food, Beverages, Desserts', 'Rolls, Wraps, Shawarma', 'Ice Cream, Desserts', 'Ice Cream, Pizza, Fast Food, Momos, Shake, Sandwich, Rolls, Burger', 'Andhra, Biryani, Hyderabadi, South Indian, Indian, Kebabs, Snacks, Beverages', 'North Indian, Desserts, Beverages', 'North Indian, Biryani, Mughlai', 'Biryani, Hyderabadi, Kebab, North Indian, Ice Cream, Desserts', 'Waffle, Pancake, Desserts, Shake, Beverages, Coffee', 'Ice Cream, Desserts, Shake, Beverages', 'Pizza, Pasta, Fast Food, Italian, Beverages', 'Pizza, Fast Food, Burger, Pasta', 'Ice Cream, Desserts, Shake', 'North Indian, Mughlai, Chinese, Fast Food, Ice Cream', 'Burger, Fast Food, Pizza, Desserts, Shake, Beverages', 'North Indian, Chinese, South Indian', 'Rolls, Wraps, Momos, Shawarma, Biryani', 'Bakery, Desserts, Beverages, Sandwich', 'North Indian, Mughlai, Biryani', 'Chinese, Italian, South Indian, Pasta, Momos, Pizza', 'Desserts, Bakery, Ice Cream', 'Ice Cream, Desserts, Beverages', 'Pizza, Fast Food, Desserts, Beverages', 'North Indian, Fast Food, Beverages', 'Pizza, Fast Food, Beverages', 'North Indian', 'North Indian, Chinese, Mughlai, Seafood, Rolls', 'Pizza, Italian, Pasta', 'Bakery', 'Continental, Oriental, Asian, Chinese, Healthy Food, Sandwich, Desserts', 'Shake, Beverages, Desserts', 'Bakery, Desserts', 'North Indian, Rolls, Momos', 'Biryani, Hyderabadi, Andhra, North Indian, Mughlai', 'Chinese, North Indian, Momos, Rolls, Fast Food, Sichuan', 'Pizza, Italian, Fast Food, Beverages', 'Biryani, North Indian, Desserts', 'North Indian, Street Food, Desserts, Shake, Beverages', 'Mughlai, North Indian, Rolls', 'Burger, Sandwich, Wraps, Fast Food', 'North Indian, Biryani', 'Bakery, Desserts', 'North Indian, Chinese, Fast Food, Rolls, Momos', 'Ice Cream, Desserts, Shake, Beverages, Waffle', 'Chinese, Continental, Pasta, Pizza, Burger', 'North Indian', 'Healthy Food, Pizza, North Indian, Burger, Biryani, Chinese, Desserts, Beverages', 'Mexican, Fast Food, Wraps', 'Biryani, Mughlai', 'North Indian, Biryani, Mughlai', 'Shawarma, Chinese, Fast Food, Momos, Burger, Street Food', 'Mithai, Desserts, Fast Food', 'Bakery, Desserts', 'Tea, Coffee, Beverages, Shake, Fast Food, Rolls, Desserts, Cafe', 'Chinese, Thai, Momos, Sichuan', 'Ice Cream, Desserts', 'Pizza, Pasta, Fast Food', 'Chinese, North Indian', 'Burger, Fast Food, Beverages', 'North Indian, Healthy Food, South Indian, Fast Food, Mithai, Juices, Desserts, Beverages', 'Momos', 'Pizza, Fast Food', 'North Indian, Biryani, Mughlai', 'Burger, Pizza, Pasta, Fast Food, Shake, Beverages', 'Chinese, Fast Food, Burger, Rolls', 'Chinese, Thai, Asian, Desserts', 'Ice Cream, Desserts', 'Mexican, American, Continental, Healthy Food, Beverages, Fast Food', 'Chinese, Asian, Momos, Thai, Fast Food, Desserts, Beverages', 'Burger, Fast Food, Beverages', 'Pizza, Italian, Fast Food, Desserts, Beverages', 'North Indian, South Indian, Healthy Food, Desserts, Beverages, Andhra, Mithai, Pizza', 'Ice Cream, Desserts, Shake', 'North Indian, Chinese, South Indian, Beverages', 'Bakery, Desserts', 'North Indian, Fast Food, Street Food, Beverages', 'Shawarma, Momos, Chinese', 'Momos, Chinese', 'Pizza, Italian, Fast Food, Desserts', 'North Indian', 'North Indian, Chinese, Street Food, Beverages', 'Rolls, North Indian, Desserts, Beverages', 'Fast Food, North Indian, Biryani, Beverages, Desserts, Burger', 'Rolls, Momos', 'North Indian, Mughlai, Biryani, Kebab, Rolls, Desserts', 'North Indian, Chinese, Biryani, Mughlai, Fast Food, Desserts', 'Shawarma, Momos, Burger, Fast Food, Chinese', 'Tea, Cafe, Coffee, Rolls, Fast Food, Beverages', 'Momos, Chinese, Asian, Japanese, Tibetan, Street Food, Finger Food, Beverages', 'North Indian, Mughlai, Biryani, Chinese, Kebab, Rolls, Fast Food', 'North Indian, Burger, Continental, Fast Food, Street Food', 'Salad, Healthy Food, Sandwich, Juices', 'Fast Food, Pizza, Sandwich, Pasta, Street Food, Chinese, Momos, Beverages', 'Burger, Momos, Fast Food, Shake, Beverages', 'Desserts, Coffee, Bakery, Beverages', 'North Indian, Oriental, Chinese, Sandwich, Pizza, Biryani, Fast Food', 'Pizza, Fast Food', 'North Indian, Biryani, Mughlai', 'Pizza, Italian, Fast Food', 'North Indian, Mughlai, Rolls, BBQ, Biryani', 'Chinese, Fast Food', 'North Indian, Chinese, Biryani, Rolls', 'Chinese, Sichuan, Desserts, Beverages', 'North Indian, Chinese', 'Ice Cream, Healthy Food, Desserts, Bakery', 'Desserts, Bakery, Beverages', 'North Indian, Chinese', 'North Indian, Chinese, Biryani, South Indian', 'Ice Cream, Desserts, Healthy Food', 'Pizza, Italian, Fast Food, Beverages', 'Bakery', 'Ice Cream, Mithai, Desserts', 'Momos, Rolls, Fast Food, Biryani, North Indian, Beverages', 'Biryani, North Indian, Mughlai', 'North Indian, Mughlai, Kebab, Chinese, Rolls, Momos', 'Rolls', 'Cake, Desserts, Bakery, Beverages, Shake', 'Biryani, Andhra, Mughlai, North Indian, Street Food, Chinese', 'Momos, Chinese', 'Fast Food, Burger', 'North Indian, Chinese, Rolls, Shake, Beverages', 'North Indian, Chinese, Mughlai, Momos, Biryani, Rolls, Fast Food, Asian', 'Cafe, Coffee, Tea, Beverages, Sandwich, Fast Food, Desserts, Pizza', 'North Indian, Beverages', 'North Indian, Rolls, Kebab, Biryani', 'North Indian, South Indian, Sandwich, Burger, Pasta, Salad, Biryani, Beverages', 'Sandwich', 'Cafe, Coffee, Fast Food, Bakery, Desserts, Beverages', 'Chinese, Modern Indian, Kebab, Rolls, Fast Food', 'Kebab, North Indian, Biryani, Fast Food', 'Salad', 'North Indian', 'Ice Cream, Desserts', 'Burger, Fast Food, American', 'Fast Food, Burger, Momos, Street Food, Chinese, Desserts, Shake, Beverages', 'Italian, Mexican, Pasta', 'Bakery', 'Healthy Food, North Indian, Street Food, Desserts, Beverages', 'Bakery, Desserts', 'Ice Cream', 'North Indian', 'Bakery, Desserts', 'Pizza', 'Desserts', 'Pizza, Fast Food, Desserts, Burger', 'North Indian, Chinese, Mughlai', 'Chinese, Tibetan, Momos', 'Mexican, Pizza, Pasta, American, Burger, Tex-Mex, Desserts', 'Frozen Yogurt, Desserts, Healthy Food', 'North Indian, Beverages', 'Bakery, Sandwich, Burger, Momos, Fast Food, Street Food, Desserts, Shake', 'Biryani', 'North Indian, Mughlai', 'Bakery, Desserts, Fast Food', 'Rolls, Sandwich, North Indian', 'Healthy Food, Salad, Burger, Mexican, Pasta, Desserts, Beverages', 'Cafe, Bakery, Tea, Shake, Beverages, Sandwich, Desserts', 'North Indian, Rolls, Chinese, Momos', 'North Indian, Chinese', 'Momos, Sandwich, Beverages, Shake, Fast Food, Bakery, Coffee, Chinese', 'Fast Food, Sandwich, Cake', 'Desserts, Ice Cream, Bakery, Shake, Beverages', 'Momos, Chinese', 'North Indian, Mughlai, Kebab, Biryani, Chinese, Wraps', 'North Indian', 'Chinese, Momos, Fast Food, Rolls', 'Biryani, Mughlai', 'Rolls, Wraps, Shawarma', 'Chinese, Pizza, Sandwich, Momos, Fast Food, Street Food, Shake', 'Rolls', 'Mexican, Salad, Desserts, Beverages', 'Chinese, Momos, Fast Food', 'North Indian, Mughlai, Chinese', 'North Indian, Chinese, Biryani', 'Burger, Pizza, Wraps, Sandwich, Fast Food', 'Chinese, Sandwich, Burger, Fast Food, Momos, Bakery', 'Cafe, Pancake, Waffle, Desserts, Shake, Beverages, Coffee, Ice Cream', 'Mughlai, Biryani', 'Pizza, Beverages, Burger, Sandwich, Shake, Fast Food', 'North Indian, Chinese, Street Food, Sandwich, Fast Food, Shake, Desserts, Beverages', 'Burger, Fast Food, Beverages', 'North Indian', 'North Indian, Italian, Burger, Continental, Pizza, Pasta, Asian, Desserts', 'Pizza, Burger, Rolls, North Indian', 'North Indian, Mughlai', 'Pizza, Fast Food', 'North Indian, Chinese, Mughlai, Rolls', 'North Indian, Mughlai', 'North Indian, Mughlai, Kebab', 'North Indian, Chinese, Burger, Pizza, Sandwich, Rolls, Bakery, Desserts', 'North Indian, Mughlai, Seafood, Rolls', 'Rolls, Shawarma, Fast Food', 'North Indian, Mughlai, Biryani, Beverages', 'Street Food, Chinese, North Indian, Mughlai, Biryani, Beverages', 'Chinese, Beverages', 'Healthy Food, Continental, American, Burger, Salad, Desserts, Beverages', 'Healthy Food, Grilled Chicken, Salad, Sandwich, Wraps, Pizza, Burger', 'North Indian', 'Burger, Sandwich, Wraps, Fast Food, Desserts, Shake, Beverages, Momos', 'North Indian, Chinese, Biryani', 'Rolls', 'Pizza', 'Chinese, Fast Food', 'North Indian, Mughlai, Chinese, Biryani', 'North Indian', 'Burger, Wraps, Shake, Beverages', 'North Indian, Mughlai, Biryani, Kebab, Desserts, Beverages', 'Pizza, Pasta, Sandwich, Italian, Shake, Beverages, Ice Cream, Desserts', 'Shawarma, Street Food, Salad, Burger, Beverages', 'North Indian, Chinese, Mughlai', 'North Indian', 'Burger, Pizza, Rolls, Momos, Shake, Desserts', 'Burger, Fast Food, Shake, Coffee, Beverages', 'Cafe, Momos, Pizza, Desserts, Burger, Fast Food, Beverages, Shake', 'North Indian, Biryani', 'North Indian, Biryani, Mughlai', 'Fast Food, Burger, Momos, Chinese', 'Cafe, Coffee, Tea, Fast Food, Beverages, Desserts', 'North Indian, Chinese', 'Chinese, Momos, North Indian', 'North Indian, Mughlai, Biryani', 'North Indian, Pizza, Burger, Pasta, Sandwich, Fast Food, Street Food', 'North Indian, Fast Food, Street Food', 'North Indian', 'Fast Food', 'Desserts, Beverages', 'Chinese, Momos, Rolls', 'Cafe, North Indian, Mughlai, Chinese, Biryani, Fast Food, Desserts', 'North Indian, Chinese, Biryani, Mughlai', 'North Indian, Rolls, Biryani, Kebab, Mughlai, Chinese, Desserts', 'North Indian, Burger, Fast Food, Street Food, Chinese', 'Fast Food, Sandwich, Wraps, Bubble Tea, Waffle, Desserts, Beverages', 'Shake, Beverages, Desserts, Ice Cream, Waffle, Healthy Food', 'Biryani, North Indian, Mughlai', 'North Indian, Chinese, Burger, Wraps, Sandwich, Biryani, Fast Food, Shake', 'Lebanese, Wraps, Arabian, Shawarma, Mediterranean', 'Bakery', 'Street Food, Fast Food', 'Rolls, Fast Food', 'North Indian, Beverages', 'Asian, Chinese, Sichuan', 'North Indian, South Indian, Chinese, Biryani, Street Food', 'North Indian, Chinese, Fast Food', 'Ice Cream, Shake', 'Biryani, Mughlai', 'Biryani, North Indian, Chinese, Shake, Beverages', 'Pizza, Fast Food', 'Desserts, Street Food', 'Chinese, Rolls, Momos, Pasta, Burger', 'Bakery, Desserts, Pizza, Burger, Sandwich, Chinese', 'Paan, Ice Cream', 'Waffle, Pancake, Shake', 'North Indian, Biryani, Mughlai, Kebab', 'North Indian', 'North Indian, Biryani, Chinese, Pasta, Burger, Sandwich', 'Mughlai, North Indian', 'Bakery, Desserts, Ice Cream, Shake, Beverages', 'Ice Cream, Desserts', 'Sandwich, Burger, Pasta, Fast Food, Salad', 'Salad, Sandwich', 'Fast Food, North Indian, Rolls, Healthy Food', 'Burger, Fast Food, Shake, Beverages', 'Desserts, Drinks Only, North Indian, Roast Chicken, Healthy Food', 'North Indian, Mughlai, Chinese', 'Biryani, North Indian, Mughlai', 'North Indian, Biryani, Street Food', 'North Indian, South Indian, Chinese, Beverages, Continental, Desserts', 'Pizza', 'Momos, Rolls, Sandwich, Street Food, Fast Food, Shake, Beverages', 'North Indian, Biryani, Chinese, Mughlai, Desserts, Beverages', 'Pizza, Pasta, Fast Food, Shake', 'Rolls, Sandwich, North Indian', 'North Indian', 'North Indian, Rolls, Chinese', 'North Indian, Beverages', 'Fast Food, Wraps, Burger']\n",
      " \n",
      "cost_for_one: ['₹200 for one', '₹200 for one', '₹250 for one', '₹250 for one', '₹350 for one', '₹150 for one', '₹200 for one', '₹100 for one', '₹150 for one', '₹150 for one', '₹200 for one', '₹400 for one', '₹500 for one', '₹300 for one', '₹250 for one', '₹200 for one', '₹150 for one', '₹300 for one', '₹200 for one', '₹300 for one', '₹200 for one', '₹100 for one', '₹100 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹250 for one', '₹100 for one', '₹150 for one', '₹250 for one', '₹150 for one', '₹150 for one', '₹150 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹150 for one', '₹300 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹100 for one', '₹600 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹100 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹250 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹150 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹150 for one', '₹250 for one', '₹200 for one', '₹150 for one', '₹150 for one', '₹200 for one', '₹150 for one', '₹250 for one', '₹150 for one', '₹150 for one', '₹200 for one', '₹300 for one', '₹150 for one', '₹150 for one', '₹600 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹250 for one', '₹400 for one', '₹200 for one', '₹100 for one', '₹150 for one', '₹200 for one', '₹100 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹100 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹100 for one', '₹600 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹550 for one', '₹100 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹400 for one', '₹400 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹400 for one', '₹100 for one', '₹350 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹100 for one', '₹150 for one', '₹150 for one', '₹300 for one', '₹100 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹300 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹500 for one', '₹250 for one', '₹350 for one', '₹200 for one', '₹250 for one', '₹150 for one', '₹100 for one', '₹400 for one', '₹150 for one', '₹40 for one', '₹250 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹250 for one', '₹200 for one', '₹100 for one', '₹200 for one', '₹200 for one', '₹100 for one', '₹100 for one', '₹200 for one', '₹250 for one', '₹350 for one', '₹1,000 for one', '₹150 for one', '₹100 for one', '₹150 for one', '₹150 for one', '₹150 for one', '₹200 for one', '₹40 for one', '₹150 for one', '₹300 for one', '₹300 for one', '₹150 for one', '₹200 for one', '₹100 for one', '₹150 for one', '₹150 for one', '₹400 for one', '₹100 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹150 for one', '₹400 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹150 for one', '₹150 for one', '₹250 for one', '₹250 for one', '₹100 for one', '₹600 for one', '₹150 for one', '₹250 for one', '₹150 for one', '₹200 for one', '₹150 for one', '₹200 for one', '₹250 for one', '₹400 for one', '₹100 for one', '₹1,200 for one', '₹200 for one', '₹200 for one', '₹400 for one', '₹200 for one', '₹100 for one', '₹150 for one', '₹200 for one', '₹100 for one', '₹150 for one', '₹150 for one', '₹350 for one', '₹200 for one', '₹150 for one', '₹900 for one', '₹200 for one', '₹100 for one', '₹200 for one', '₹100 for one', '₹100 for one', '₹150 for one', '₹150 for one', '₹100 for one', '₹250 for one', '₹150 for one', '₹200 for one', '₹250 for one', '₹100 for one', '₹200 for one', '₹100 for one', '₹100 for one', '₹150 for one', '₹350 for one', '₹150 for one', '₹150 for one', '₹600 for one', '₹200 for one', '₹200 for one', '₹150 for one', '₹400 for one', '₹200 for one', '₹200 for one', '₹300 for one', '₹200 for one', '₹250 for one', '₹200 for one', '₹100 for one', '₹100 for one', '₹250 for one', '₹150 for one', '₹150 for one', '₹100 for one', '₹300 for one', '₹200 for one', '₹150 for one', '₹100 for one', '₹200 for one', '₹150 for one', '₹100 for one', '₹200 for one', '₹250 for one', '₹100 for one', '₹100 for one', '₹150 for one', '₹350 for one', '₹150 for one', '₹200 for one', '₹100 for one', '₹150 for one', '₹150 for one', '₹500 for one', '₹400 for one', '₹300 for one', '₹150 for one', '₹150 for one', '₹100 for one', '₹150 for one', '₹200 for one', '₹200 for one', '₹100 for one', '₹200 for one', '₹150 for one', '₹150 for one', '₹100 for one']\n",
      " \n",
      "delivery_time: ['18 min', '36 min', '34 min', '29 min', '25 min', '19 min', '37 min', '30 min', '19 min', '38 min', '38 min', '20 min', '17 min', '17 min', '36 min', '32 min', '27 min', 'N/A', '17 min', '32 min', '28 min', '23 min', '42 min', 'N/A', '23 min', '27 min', '26 min', '18 min', '25 min', '28 min', '28 min', '44 min', '35 min', '16 min', '41 min', '40 min', '37 min', '37 min', 'N/A', '37 min', '25 min', '19 min', '23 min', '52 min', '37 min', '15 min', '26 min', '34 min', 'N/A', '22 min', '22 min', '28 min', '22 min', '41 min', 'N/A', '42 min', '32 min', '19 min', '38 min', '36 min', '23 min', '43 min', '32 min', '32 min', '30 min', '27 min', '38 min', '25 min', '27 min', '39 min', '29 min', 'N/A', '31 min', '28 min', '33 min', 'N/A', '40 min', '27 min', '34 min', 'N/A', '44 min', 'N/A', '36 min', '28 min', '34 min', '45 min', '33 min', '45 min', '40 min', '34 min', '22 min', '26 min', '34 min', '40 min', '27 min', '29 min', '23 min', '57 min', '38 min', '35 min', '38 min', '34 min', '25 min', '33 min', '22 min', '29 min', '35 min', '36 min', '29 min', '34 min', '32 min', '34 min', '29 min', '42 min', '45 min', '24 min', 'N/A', '33 min', '25 min', '36 min', '41 min', '33 min', '46 min', '37 min', '39 min', '32 min', '48 min', '36 min', '19 min', '35 min', '38 min', '46 min', '35 min', '40 min', '35 min', '32 min', '30 min', '35 min', '25 min', '33 min', '40 min', '20 min', 'N/A', '54 min', '51 min', '37 min', '25 min', '41 min', '26 min', '30 min', '27 min', '22 min', '29 min', '49 min', '34 min', '48 min', '37 min', '39 min', '21 min', '46 min', '46 min', '27 min', '38 min', '23 min', '33 min', '17 min', '52 min', '43 min', '33 min', '46 min', '30 min', '24 min', '31 min', '51 min', '38 min', '38 min', '26 min', '37 min', '36 min', '31 min', '42 min', '31 min', '37 min', '39 min', '34 min', '45 min', '34 min', '47 min', '53 min', '35 min', '31 min', '36 min', '36 min', '40 min', '30 min', '36 min', '42 min', '48 min', '54 min', '34 min', '25 min', '23 min', '35 min', '31 min', '38 min', '47 min', '48 min', '23 min', '54 min', '64 min', '22 min', '42 min', '30 min', '30 min', '35 min', '42 min', '45 min', '48 min', '53 min', '35 min', '41 min', '53 min', '39 min', '44 min', '30 min', '52 min', '42 min', '41 min', '39 min', '42 min', '49 min', '25 min', '29 min', '36 min', '36 min', '60 min', '33 min', '38 min', '30 min', '53 min', '38 min', '32 min', '42 min', '38 min', '56 min', '48 min', '44 min', '47 min', '28 min', 'N/A', '36 min', '27 min', '48 min', '49 min', '47 min', '31 min', '23 min', '30 min', '51 min', '40 min', '34 min', '45 min', '48 min', '44 min', '37 min', '51 min', '34 min', '38 min', '40 min', '48 min', '45 min', '44 min', '40 min', '34 min', '37 min', '36 min', '39 min', '34 min', '46 min', '57 min', '48 min', '38 min', '31 min', '34 min', '30 min', '42 min', '34 min', '38 min', '33 min', '51 min', '31 min', '33 min', '36 min', '40 min', '61 min', '41 min', '51 min', '31 min', '41 min', '52 min']\n",
      " \n",
      "offers: ['No Offers', 'No Offers', '20% OFF', '₹150 OFF', '₹150 OFF', '₹125 OFF', '₹50 OFF', '₹150 OFF', 'No Offers', '20% OFF', 'Flat 15% OFF', 'No Offers', '₹125 OFF', '₹125 OFF', '40% OFF', 'No Offers', '₹150 OFF', 'Flat 20% OFF', 'No Offers', '₹125 OFF', '40% OFF', 'No Offers', 'Flat 10% OFF', 'No Offers', 'No Offers', '₹150 OFF', '₹150 OFF', '10% OFF', '50% OFF', '₹200 OFF', '20% OFF', '30% OFF', '₹100 OFF', 'No Offers', '60% OFF', '60% OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '40% OFF', 'No Offers', '20% OFF', '₹100 OFF', '₹200 OFF', '₹125 OFF', 'Free Choco Lava', '₹200 OFF', 'No Offers', '₹150 OFF', '₹100 OFF', 'No Offers', '50% OFF', 'No Offers', 'Flat 20% OFF', '₹125 OFF', '40% OFF', '50% OFF', '₹200 OFF', 'Flat 20% OFF', 'Flat 10% OFF', '₹150 OFF', 'No Offers', '₹100 OFF', '50% OFF', 'No Offers', '50% OFF', '50% OFF', '40% OFF', 'No Offers', '10% OFF', '20% OFF', 'No Offers', 'No Offers', '50% OFF', '40% OFF', '50% OFF', '50% OFF', 'No Offers', 'No Offers', '₹100 OFF', '60% OFF', 'Flat 20% OFF', 'No Offers', '40% OFF', 'No Offers', 'No Offers', '30% OFF', 'No Offers', '50% OFF', '₹100 OFF', '40% OFF', '₹100 OFF', '60% OFF', 'No Offers', '10% OFF', '60% OFF', '₹150 OFF', '50% OFF', 'No Offers', '₹200 OFF', '20% OFF', 'No Offers', '₹200 OFF', '60% OFF', 'No Offers', '₹400 OFF', '₹150 OFF', 'No Offers', '20% OFF', '40% OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '30% OFF', '20% OFF', '60% OFF', 'No Offers', '20% OFF', '₹125 OFF', 'No Offers', '₹150 OFF', '₹175 OFF', 'No Offers', 'No Offers', '40% OFF', '20% OFF', '50% OFF', 'No Offers', '₹200 OFF', '50% OFF', '50% OFF', 'No Offers', '₹150 OFF', '₹200 OFF', 'Flat 15% OFF', 'Free Mojito', '₹175 OFF', '₹125 OFF', 'Flat 20% OFF', 'No Offers', 'No Offers', 'Flat 20% OFF', '10% OFF', '₹125 OFF', '₹125 OFF', 'No Offers', '₹200 OFF', '₹100 OFF', '₹175 OFF', 'No Offers', '₹200 OFF', '₹125 OFF', '₹125 OFF', '₹125 OFF', 'No Offers', '₹150 OFF', '50% OFF', 'No Offers', '₹125 OFF', '₹200 OFF', 'No Offers', '50% OFF', 'Free Farm House Pizza [9 inches]', 'No Offers', '₹100 OFF', 'No Offers', '₹200 OFF', '₹125 OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'Free Dal Rice', '20% OFF', 'No Offers', '10% OFF', '₹150 OFF', '₹150 OFF', 'Free Veg Noodles', '20% OFF', 'Free Fries', '60% OFF', '₹175 OFF', '40% OFF', '10% OFF', 'Free Pcc Special Chaap Pizza', 'No Offers', '20% OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '₹75 OFF', 'No Offers', 'Free Margherita Pizza', '20% OFF', 'No Offers', 'No Offers', 'Free Virgin Mojito', '40% OFF', '20% OFF', 'No Offers', '₹125 OFF', '₹125 OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '40% OFF', 'No Offers', '60% OFF', 'No Offers', '₹125 OFF', 'Flat 15% OFF', '20% OFF', 'No Offers', 'Flat 20% OFF', 'No Offers', 'No Offers', 'No Offers', '50% OFF', 'No Offers', 'No Offers', 'No Offers', '50% OFF', '50% OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '20% OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '60% OFF', 'No Offers', '10% OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '50% OFF', 'No Offers', 'No Offers', 'No Offers', '₹100 OFF', '50% OFF', '60% OFF', 'No Offers', 'No Offers', '40% OFF', 'No Offers', 'No Offers', '₹100 OFF', '20% OFF', 'Flat 20% OFF', '20% OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'Free Chololate Icecream (single Scoop)', '₹125 OFF', '₹200 OFF', 'No Offers', 'No Offers', '60% OFF', 'No Offers', 'No Offers', '₹200 OFF', '50% OFF', 'Free French Fries', '₹125 OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', '50% OFF', 'No Offers', '₹150 OFF', 'No Offers', 'No Offers', 'No Offers', 'No Offers', 'Free Sweet Kullad Lassi', 'No Offers']\n",
      " \n",
      "urls: ['https://www.zomato.com/ncr/mcdonalds-1-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/kfc-2-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/pizza-hut-1-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/la-pinoz-pizza-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/the-burger-club-1-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/burger-singh-big-punjabi-burgers-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/haldirams-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/kwality-walls-ice-cream-and-more-6-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/rollsking-2-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/wendys-burgers-rajendra-place-new-delhi/order', 'https://www.zomato.com/ncr/veer-ji-malai-chaap-wale-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/nazeer-foods-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/biryani-blues-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/bikkgane-biryani-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/khadak-singh-da-dhaba-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/bakingo-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/apni-rasoi-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/chinese-wok-kashmiri-gate-new-delhi/order', 'https://www.zomato.com/ncr/subway-1-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/behrouz-biryani-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/wow-momo-asaf-ali-road-new-delhi/order', 'https://www.zomato.com/ncr/gianis-ice-cream-shakes-sundaes-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/the-pizza-kings-1-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/btw-1-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/bikanervala-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/faasos-wraps-rolls-shawarma-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/nic-ice-creams-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/nirulas-3-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/thalairaj-biryani-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/daily-kitchen-homely-meals-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/lunchbox-meals-and-thalis-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/biryani-by-kilo-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/the-waffle-co-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/giani-gole-market-new-delhi/order', 'https://www.zomato.com/ncr/chicago-pizza-satyaniketan-new-delhi/order', 'https://www.zomato.com/ncr/rominus-pizza-and-burger-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/vadilal-ice-creams-1-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/punjabi-rasoi-3-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/the-burger-company-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/flavours-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/wraps-kathi-rolls-1-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/theobroma-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/ghee-and-turmeric-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/mansi-chinese-food-pitampura-new-delhi/order', 'https://www.zomato.com/ncr/sweet-truth-cake-and-desserts-rajendra-place-new-delhi/order', 'https://www.zomato.com/ncr/baskin-robbins-ice-cream-desserts-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/mojo-pizza-2x-toppings-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/parantha-express-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/pizza-galleria-1-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/nh1-bowls-highway-to-north-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/sandoz-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/oven-story-pizza-standout-toppings-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/cheesecake-co-asaf-ali-road-new-delhi/order', 'https://www.zomato.com/ncr/freshmenu-pandav-nagar-new-delhi/order', 'https://www.zomato.com/ncr/keventers-milkshakes-desserts-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/cakezone-patisserie-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/sardar-g-malai-chaap-junction-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/biryani-badshah-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/the-yellow-bowl-daryaganj-new-delhi/order', 'https://www.zomato.com/ncr/olio-the-wood-fired-pizzeria-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/zaza-mughal-biryani-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/keny-premium-food-shadipur-new-delhi/order', 'https://www.zomato.com/ncr/hussaini-hotel-nizamuddin-new-delhi/order', 'https://www.zomato.com/ncr/burgrill-the-win-win-burger-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/mashaallah-chicken-corner-1-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/fleurons-handcrafted-cakes-and-brownies-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/punjabi-hut-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/havmor-havfunn-ice-cream-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/sgf-spice-grill-flame-1-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/puran-dhaba-ashok-vihar-new-delhi/order', 'https://www.zomato.com/ncr/eatfit-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/taco-bell-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/the-biryani-life-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/the-good-bowl-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/king-shawarma-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/gulab-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/baking-love-bakers-shadipur-new-delhi/order', 'https://www.zomato.com/ncr/chai-point-3-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/house-of-chow-1-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/keventers-ice-cream-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/icp-italian-crust-pizza-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/punjabi-dhaba-5-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/louis-burger-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/great-indian-khichdi-by-eatfit-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/momo-shomo-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/pizza-flix-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/goila-butter-chicken-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/burger-point-3-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/dhading-ktm-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/bercos-if-you-love-chinese-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/grameen-kulfi-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/california-burrito-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/hudson-chopsticks-fresh-chinese-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/burgerama-safdarjung-new-delhi/order', 'https://www.zomato.com/ncr/nomad-pizza-traveller-series-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/ghar-ka-khana-by-eatfit-rajendra-place-new-delhi/order', 'https://www.zomato.com/ncr/kings-kulfi-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/shivjis-day-night-kitchen-1-rana-pratap-bagh-new-delhi/order', 'https://www.zomato.com/ncr/sashmicks-bakery-shakarpur-new-delhi/order', 'https://www.zomato.com/ncr/no-1-uncles-parantha-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/lords-of-shawarma-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/the-momos-booth-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/leancrust-pizza-thincrust-experts-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/makhani-darbar-asaf-ali-road-new-delhi/order', 'https://www.zomato.com/ncr/jain-chawal-wale-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/mealful-rolls-indias-biggest-rolls-paharganj-new-delhi/order', 'https://www.zomato.com/-2-food-truck/order', 'https://www.zomato.com/ncr/34-chowringhee-lane-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/moti-mahal-delux-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/urban-chulha-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/the-tummy-section-rajendra-place-new-delhi/order', 'https://www.zomato.com/ncr/chaayos-chai-snacks-relax-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/prasuma-momo-kitchen-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/tikka-junction-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/ghar-ki-rasoi-3-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/salad-days-gole-market-new-delhi/order', 'https://www.zomato.com/ncr/hashtag-foods-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/simple-burger-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/dunkin-donuts-coffee-barakhamba-road-new-delhi/order', 'https://www.zomato.com/ncr/the-dhaba-junction-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/pizza-studio-1-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/veg-meals-by-lunchbox-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/slyce-pizza-pandav-nagar-new-delhi/order', 'https://www.zomato.com/ncr/qureshis-kabab-corner-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/chinese-corner-lajpat-nagar-1-new-delhi/order', 'https://www.zomato.com/ncr/flavours-of-punjab-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/jyoti-chinese-kitchen-delhi-university-gtb-nagar-new-delhi/order', 'https://www.zomato.com/ncr/concept-shawarma-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/getaway-ice-creams-desserts-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/mad-over-donuts-1-rajendra-place-new-delhi/order', 'https://www.zomato.com/ncr/waah-punjabi-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/kerala-night-kitchen-1-rana-pratap-bagh-new-delhi/order', 'https://www.zomato.com/ncr/go-zero-ice-creams-desserts-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/crustos-cheese-burst-pizza-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/sai-cake-and-bake-shadipur-new-delhi/order', 'https://www.zomato.com/ncr/noto-ice-creams-desserts-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/sheikh-chang-singh-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/itminaan-matka-biryani-slow-cooked-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/lazeez-kebab-curries-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/roll-xpress-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/smoor-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/andhra-kodi-pulao-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/the-momo-co-kashmiri-gate-new-delhi/order', 'https://www.zomato.com/ncr/qureshi-fast-food-daryaganj-new-delhi/order', 'https://www.zomato.com/ncr/kake-di-hatti-chandni-chowk-new-delhi/order', 'https://www.zomato.com/ncr/bawarchi-chanakyapuri-new-delhi/order', 'https://www.zomato.com/ncr/third-wave-coffee-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/amritsari-kulcha-factory-moti-nagar-new-delhi/order', 'https://www.zomato.com/ncr/changezi-chicken-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/oh-hunger-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/boom-sandwich-sub-of-india-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/starbucks-coffee-1-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/wrap-roll-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/abdul-ghani-qureshi-kabab-corner-jama-masjid-jama-masjid-new-delhi/order', 'https://www.zomato.com/ncr/nutriobox-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/delhi-parantha-company-kirti-nagar-new-delhi/order', 'https://www.zomato.com/ncr/the-brooklyn-creamery-healthy-ice-cream-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/hulks-burger-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/chaubara-2-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/firangi-bake-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/creative-chef-baker-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/khichdi-hub-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/choko-la-1-khan-market-new-delhi/order', 'https://www.zomato.com/ncr/globo-ice-creams-of-the-world-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/handi-47-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/pink-box-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/pizza-kingdom-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/the-dessert-heaven-pure-veg-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/enso-sourdough-pizza-by-nomad-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/rajinder-da-dhaba-safdarjung-new-delhi/order', 'https://www.zomato.com/ncr/chimney-sizzlers-chanakyapuri-new-delhi/order', 'https://www.zomato.com/ncr/chilis-grill-bar-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/cocoberry-2-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/housewife-kitchen-ashok-vihar-phase-3-new-delhi/order', 'https://www.zomato.com/ncr/the-new-shop-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/oh-biryani-the-taste-of-delhi-south-extension-1-new-delhi/order', 'https://www.zomato.com/ncr/sai-ki-rasoi-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/angels-in-my-kitchen-1-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/roll-crave-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/hrx-by-eatfit-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/cafe-coffee-day-lajpat-nagar-2-new-delhi/order', 'https://www.zomato.com/ncr/punjabi-zaika-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/curry-house-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/brown-sugar-og-wheat-momos-more-south-extension-2-new-delhi/order', 'https://www.zomato.com/ncr/pearl-grill-cafe-netaji-nagar-new-delhi/order', 'https://www.zomato.com/ncr/the-dessert-zone-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/yangkiez-by-momo-mami-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/relax-restaurant-lajpat-nagar-2-new-delhi/order', 'https://www.zomato.com/ncr/guru-kripa-kitchen-geeta-colony-new-delhi/order', 'https://www.zomato.com/ncr/punjabi-chaap-corner-1-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/pakiza-shahi-chicken-biryani-1-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/faasos-signature-wraps-and-rolls-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/student-hub-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/rollcano-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/picante-mexican-by-nomad-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/mister-kiyoshi-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/saleems-restaurant-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/new-hot-pot-rana-pratap-bagh-new-delhi/order', 'https://www.zomato.com/ncr/buff-grill-chawri-bazar-new-delhi/order', 'https://www.zomato.com/ncr/bakisto-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/high-on-desserts-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/special-no1-biryani-house-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/le-winkies-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/swagat-food-pallette-of-india-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/akus-the-burger-co-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/punjabi-nitin-vaishno-dhaba-asaf-ali-road-new-delhi/order', 'https://www.zomato.com/ncr/cafe-delhi-heights-naraina-new-delhi/order', 'https://www.zomato.com/ncr/flavours-of-chaap-2-gole-market-new-delhi/order', 'https://www.zomato.com/ncr/the-karims-food-azad-market-new-delhi/order', 'https://www.zomato.com/ncr/hafiz-foods-chawri-bazar-new-delhi/order', 'https://www.zomato.com/ncr/handi-chhadeyan-di-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/a-one-food-center-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/ghalib-kabab-corner-nizamuddin-new-delhi/order', 'https://www.zomato.com/ncr/capital-diner-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/blue-water-grille-1-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/h-rolls-shawarma-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/havemore-pandara-road-new-delhi/order', 'https://www.zomato.com/ncr/door-to-door-model-town-new-delhi/order', 'https://www.zomato.com/ncr/railway-yard-moti-nagar-new-delhi/order', 'https://www.zomato.com/ncr/healthy-chef-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/cafe-healthy-high-by-nirulas-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/homemade-kitchen-geeta-colony-new-delhi/order', 'https://www.zomato.com/ncr/wat-a-burger-india-ka-burger-krishna-nagar-new-delhi/order', 'https://www.zomato.com/ncr/the-magician-chef-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/roll-express-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/galaxy-pizza-lajpat-nagar-1-new-delhi/order', 'https://www.zomato.com/ncr/chinese-mania-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/hotel-le-roi-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/the-delish-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/high-on-burgers-satyaniketan-new-delhi/order', 'https://www.zomato.com/ncr/gulati-pandara-road-new-delhi/order', 'https://www.zomato.com/ncr/valentino-pizzeria-by-nirulas-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/the-f-spot-shawarma-more-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/para-chicken-point-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/chaurasia-dhaba-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/chef-bhaijaans-daryaganj-new-delhi/order', 'https://www.zomato.com/ncr/junkies-zone-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/amigos-hub-satyaniketan-new-delhi/order', 'https://www.zomato.com/ncr/khao-dilli-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/pind-kaneda-chanakyapuri-new-delhi/order', 'https://www.zomato.com/ncr/shree-manokamana-fast-food-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/barista-coffee-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/divine-home-kitchen-lodhi-colony-new-delhi/order', 'https://www.zomato.com/ncr/chaat-mahal-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/al-yameen-azad-market-new-delhi/order', 'https://www.zomato.com/ncr/eat-and-smile-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/aapki-apni-rasoi-1-civil-lines-new-delhi/order', 'https://www.zomato.com/ncr/ghar-ka-swaad-1-civil-lines-new-delhi/order', 'https://www.zomato.com/ncr/pvr-caf%C3%A9-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/krispy-kreme-kamla-nagar-new-delhi/order', 'https://www.zomato.com/ncr/chinese-hut-jangpura-new-delhi/order', 'https://www.zomato.com/ncr/cafe-sandoz-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/garhwali-rasoi-delhi-university-gtb-nagar-new-delhi/order', 'https://www.zomato.com/ncr/sabka-chulha-lajpat-nagar-1-new-delhi/order', 'https://www.zomato.com/ncr/moms-own-kitchen-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/teavaro-satyaniketan-new-delhi/order', 'https://www.zomato.com/ncr/frozen-bottle-milkshakes-desserts-and-ice-cream-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/delhi-biryani-corner-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/indigo-paradise-cafe-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/arabian-delites-lebanese-legacy-since-1994-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/the-musk-bakers-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/delights-by-inox-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/star-bite-roll-azad-market-new-delhi/order', 'https://www.zomato.com/ncr/nagpals-lajpat-nagar-1-new-delhi/order', 'https://www.zomato.com/ncr/oriental-mom-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/shovas-kitchen-rana-pratap-bagh-new-delhi/order', 'https://www.zomato.com/ncr/indian-naan-club-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/white-cub-satyaniketan-new-delhi/order', 'https://www.zomato.com/ncr/veg-daawat-by-behrouz-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/the-biryani-point-model-town-new-delhi/order', 'https://www.zomato.com/ncr/sauce-in-my-pizza-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/khushdil-sweets-and-milkbar-azad-market-new-delhi/order', 'https://www.zomato.com/ncr/the-great-china-2-west-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/uncle-cake-shop-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/kings-paan-safdarjung-new-delhi/order', 'https://www.zomato.com/ncr/waffle-oclock-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/ballu-bawarchi-chanakyapuri-new-delhi/order', 'https://www.zomato.com/ncr/bhatti-chicken-grilled-not-fried-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/blue-umbrella-cafe-restaurant-geeta-colony-new-delhi/order', 'https://www.zomato.com/ncr/akram-qureshi-foods-1-jama-masjid-new-delhi/order', 'https://www.zomato.com/ncr/warmoven-cake-desserts-laxmi-nagar-new-delhi/order', 'https://www.zomato.com/ncr/frogo-one-stop-ice-cream-shop-satyaniketan-new-delhi/order', 'https://www.zomato.com/ncr/subking-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/wefit-protein-bowls-salads-sandwiches-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/peppy-parathas-rolls-by-chai-point-connaught-place-new-delhi/order', 'https://www.zomato.com/ncr/golden-wings-vikas-marg-new-delhi/order', 'https://www.zomato.com/ncr/delhi-cacies-chanakyapuri-new-delhi/order', 'https://www.zomato.com/ncr/sandoz-1-satyaniketan-new-delhi/order', 'https://www.zomato.com/ncr/one-tap-biryani-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/iconic-food-plaza-east-patel-nagar-new-delhi/order', 'https://www.zomato.com/ncr/desi-mojo-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/the-pizza-project-by-oven-story-1-asaf-ali-road-new-delhi/order', 'https://www.zomato.com/ncr/slurpy-momos-1-rajinder-nagar-new-delhi/order', 'https://www.zomato.com/ncr/hello-g-sas-kitchen-paharganj-new-delhi/order', 'https://www.zomato.com/ncr/pizza-gallery-geeta-colony-new-delhi/order', 'https://www.zomato.com/ncr/hide-out-cafe-inderlok-new-delhi/order', 'https://www.zomato.com/ncr/the-changezi-chicken-azad-market-new-delhi/order', 'https://www.zomato.com/ncr/dev-rasoi-karol-bagh-new-delhi/order', 'https://www.zomato.com/ncr/nagpals-chole-bhature-defence-colony-new-delhi/order', 'https://www.zomato.com/ncr/ffc-restaurant-asaf-ali-road-new-delhi/order']\n"
     ]
    }
   ],
   "source": [
    "# printing all the lists  we initialized to store the data - \n",
    "\n",
    "print(\"restaurant_name:\" , restaurant_name)\n",
    "print(\" \")\n",
    "print(\"ratings:\", ratings)\n",
    "print(\" \")\n",
    "print(\"cuisine_type:\", cuisine_type)\n",
    "print(\" \")\n",
    "print(\"cost_for_one:\", cost_for_one)\n",
    "print(\" \")\n",
    "print(\"delivery_time:\", delivery_time)\n",
    "print(\" \")\n",
    "print(\"offers:\", offers)\n",
    "print(\" \")\n",
    "print(\"urls:\", urls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "id": "7996986b-a61b-450e-9997-cdebcfedf23d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating a dataframe to store the data - \n",
    "df = pd.DataFrame({\n",
    "    'Restaurant_Name': restaurant_name,\n",
    "    'Rating': ratings,\n",
    "    'Cuisine_Type': cuisine_type,\n",
    "    'Cost_for_one': cost_for_one,\n",
    "    'Delivery_time': delivery_time,\n",
    "    'Offers' : offers,\n",
    "    'Restaurant_url': urls\n",
    "})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "id": "7a2c1a8a-ba4f-4125-a7af-95203676f28d",
   "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_Name</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Cuisine_Type</th>\n",
       "      <th>Cost_for_one</th>\n",
       "      <th>Delivery_time</th>\n",
       "      <th>Offers</th>\n",
       "      <th>Restaurant_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>McDonald's</td>\n",
       "      <td>4.4</td>\n",
       "      <td>Burger, Wraps, Fast Food, Beverages</td>\n",
       "      <td>₹200 for one</td>\n",
       "      <td>18 min</td>\n",
       "      <td>No Offers</td>\n",
       "      <td>https://www.zomato.com/ncr/mcdonalds-1-connaug...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KFC</td>\n",
       "      <td>4.1</td>\n",
       "      <td>Burger, Rolls, Fast Food</td>\n",
       "      <td>₹200 for one</td>\n",
       "      <td>36 min</td>\n",
       "      <td>No Offers</td>\n",
       "      <td>https://www.zomato.com/ncr/kfc-2-paharganj-new...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Pizza Hut</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Pizza, Fast Food, Italian, Desserts, Beverages</td>\n",
       "      <td>₹250 for one</td>\n",
       "      <td>34 min</td>\n",
       "      <td>20% OFF</td>\n",
       "      <td>https://www.zomato.com/ncr/pizza-hut-1-karol-b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>La Pino'z Pizza</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Pizza, Italian, Pasta, Fast Food, Desserts, Be...</td>\n",
       "      <td>₹250 for one</td>\n",
       "      <td>29 min</td>\n",
       "      <td>₹150 OFF</td>\n",
       "      <td>https://www.zomato.com/ncr/la-pinoz-pizza-karo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Burger Club</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Burger, Fast Food, Coffee, Beverages</td>\n",
       "      <td>₹350 for one</td>\n",
       "      <td>25 min</td>\n",
       "      <td>₹150 OFF</td>\n",
       "      <td>https://www.zomato.com/ncr/the-burger-club-1-c...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>Hide Out Cafe</td>\n",
       "      <td>3.9</td>\n",
       "      <td>Rolls, Sandwich, North Indian</td>\n",
       "      <td>₹100 for one</td>\n",
       "      <td>41 min</td>\n",
       "      <td>No Offers</td>\n",
       "      <td>https://www.zomato.com/ncr/hide-out-cafe-inder...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>The Changezi Chicken</td>\n",
       "      <td>3.5</td>\n",
       "      <td>North Indian</td>\n",
       "      <td>₹200 for one</td>\n",
       "      <td>51 min</td>\n",
       "      <td>No Offers</td>\n",
       "      <td>https://www.zomato.com/ncr/the-changezi-chicke...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>Dev Rasoi</td>\n",
       "      <td>4.1</td>\n",
       "      <td>North Indian, Rolls, Chinese</td>\n",
       "      <td>₹150 for one</td>\n",
       "      <td>31 min</td>\n",
       "      <td>No Offers</td>\n",
       "      <td>https://www.zomato.com/ncr/dev-rasoi-karol-bag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>Nagpal's Chole Bhature</td>\n",
       "      <td>3.6</td>\n",
       "      <td>North Indian, Beverages</td>\n",
       "      <td>₹150 for one</td>\n",
       "      <td>41 min</td>\n",
       "      <td>Free Sweet Kullad Lassi</td>\n",
       "      <td>https://www.zomato.com/ncr/nagpals-chole-bhatu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>FFC Restaurant</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Fast Food, Wraps, Burger</td>\n",
       "      <td>₹100 for one</td>\n",
       "      <td>52 min</td>\n",
       "      <td>No Offers</td>\n",
       "      <td>https://www.zomato.com/ncr/ffc-restaurant-asaf...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Restaurant_Name Rating  \\\n",
       "0                McDonald's    4.4   \n",
       "1                       KFC    4.1   \n",
       "2                 Pizza Hut    4.0   \n",
       "3           La Pino'z Pizza    4.0   \n",
       "4           The Burger Club    4.0   \n",
       "..                      ...    ...   \n",
       "295           Hide Out Cafe    3.9   \n",
       "296    The Changezi Chicken    3.5   \n",
       "297               Dev Rasoi    4.1   \n",
       "298  Nagpal's Chole Bhature    3.6   \n",
       "299          FFC Restaurant    4.0   \n",
       "\n",
       "                                          Cuisine_Type  Cost_for_one  \\\n",
       "0                  Burger, Wraps, Fast Food, Beverages  ₹200 for one   \n",
       "1                             Burger, Rolls, Fast Food  ₹200 for one   \n",
       "2       Pizza, Fast Food, Italian, Desserts, Beverages  ₹250 for one   \n",
       "3    Pizza, Italian, Pasta, Fast Food, Desserts, Be...  ₹250 for one   \n",
       "4                 Burger, Fast Food, Coffee, Beverages  ₹350 for one   \n",
       "..                                                 ...           ...   \n",
       "295                      Rolls, Sandwich, North Indian  ₹100 for one   \n",
       "296                                       North Indian  ₹200 for one   \n",
       "297                       North Indian, Rolls, Chinese  ₹150 for one   \n",
       "298                            North Indian, Beverages  ₹150 for one   \n",
       "299                           Fast Food, Wraps, Burger  ₹100 for one   \n",
       "\n",
       "    Delivery_time                   Offers  \\\n",
       "0          18 min                No Offers   \n",
       "1          36 min                No Offers   \n",
       "2          34 min                  20% OFF   \n",
       "3          29 min                 ₹150 OFF   \n",
       "4          25 min                 ₹150 OFF   \n",
       "..            ...                      ...   \n",
       "295        41 min                No Offers   \n",
       "296        51 min                No Offers   \n",
       "297        31 min                No Offers   \n",
       "298        41 min  Free Sweet Kullad Lassi   \n",
       "299        52 min                No Offers   \n",
       "\n",
       "                                        Restaurant_url  \n",
       "0    https://www.zomato.com/ncr/mcdonalds-1-connaug...  \n",
       "1    https://www.zomato.com/ncr/kfc-2-paharganj-new...  \n",
       "2    https://www.zomato.com/ncr/pizza-hut-1-karol-b...  \n",
       "3    https://www.zomato.com/ncr/la-pinoz-pizza-karo...  \n",
       "4    https://www.zomato.com/ncr/the-burger-club-1-c...  \n",
       "..                                                 ...  \n",
       "295  https://www.zomato.com/ncr/hide-out-cafe-inder...  \n",
       "296  https://www.zomato.com/ncr/the-changezi-chicke...  \n",
       "297  https://www.zomato.com/ncr/dev-rasoi-karol-bag...  \n",
       "298  https://www.zomato.com/ncr/nagpals-chole-bhatu...  \n",
       "299  https://www.zomato.com/ncr/ffc-restaurant-asaf...  \n",
       "\n",
       "[300 rows x 7 columns]"
      ]
     },
     "execution_count": 241,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Displaying the data - \n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "id": "154a0d65-9ce9-4f05-8fe2-c54df3845bad",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Saving the extracted data into a csv file - \n",
    "df.to_csv('zomato_restaurant.csv', index=False, encoding='utf-8-sig')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a239b719-1d21-4b9d-adc6-396eca691424",
   "metadata": {},
   "source": [
    "# Task 2 : Scrape 50 reviews from a zomato restaurant page "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ac27c2af-732b-4718-9446-387aaea882f8",
   "metadata": {},
   "source": [
    "Objective : Develop a python function scrape_zomato_reviews to scrape the first 50  user reviews from a given Zomato restaurant URL and store them in \n",
    "a pandas DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 637,
   "id": "7c1ef78b-6e06-45ff-a307-e1c91985e719",
   "metadata": {},
   "outputs": [],
   "source": [
    "#initialize the chrome Driver \n",
    "driver = webdriver.Chrome(service = Service(ChromeDriverManager().install()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 638,
   "id": "27bbc057-fc86-4de4-92b1-34e86046cf61",
   "metadata": {},
   "outputs": [],
   "source": [
    "#open the website \n",
    "driver.get(\"https://www.zomato.com/ncr/dominos-pizza-4-connaught-place-new-delhi/reviews\")  \n",
    "# Wait for content to load - \n",
    "wait = WebDriverWait(driver, 40)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 639,
   "id": "b32c1868-f410-4144-a620-7853efb35fbc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Scrolling page...\n",
      "Scrolling complete, looking for containers...\n"
     ]
    }
   ],
   "source": [
    "# Scrolling through the page \n",
    "print(\"Scrolling page...\")\n",
    "scroll_page(driver)\n",
    "print(\"Scrolling complete, looking for containers...\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 647,
   "id": "c31b914f-caaf-47ea-bfbc-9c31606de943",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# Initialize lists to store the extracted data\n",
    "user_name = []\n",
    "numberOfReviews= []\n",
    "user_follower = []\n",
    "rating = []\n",
    "timeOfPosting = []\n",
    "vote_list = []\n",
    "review = []\n",
    "review_type=[] \n",
    "\n",
    "\n",
    "# Running a loop to get 50 reviews information \n",
    "for page in range (10): # Loop through 10 pages\n",
    "    # Selecting a element with all information regarding reviews -\n",
    "    box = driver.find_element(By.XPATH, '//*[@id=\"root\"]/div/main/div/section[4]/div/div/section/div[2]')\n",
    "\n",
    "    #Selecting element to scrap user name , time of posting , vote list and review-\n",
    "    names = box.find_elements(By.CLASS_NAME, \"sc-1hez2tp-0\")\n",
    "    # using a for loop to iterate through each element \n",
    "    for i in range(0, len(names),4):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            user_name.append(names[i].text)\n",
    "        except:\n",
    "            user_name.append(\"N/A\")\n",
    "\n",
    "    for i in range(1, len(names),4):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            timeOfPosting.append(names[i].text)\n",
    "        except:\n",
    "            timeOfPosting.append(\"N/A\")\n",
    "\n",
    "    for i in range(3, len(names),4):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            vote_list.append(names[i].text)\n",
    "        except:\n",
    "            vote_list.append(\"N/A\")\n",
    "\n",
    "    for i in range(2,len(names),4):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            review.append(names[i].text)\n",
    "        except:\n",
    "            review.append(\"N/A\")\n",
    "\n",
    "\n",
    "     # Selecting element to scrap number of reviews and user follower - \n",
    "    nreviews = box.find_elements(By.CSS_SELECTOR, \"span\")\n",
    "    \n",
    "    for i in range(0,len(nreviews),7):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            numberOfReviews.append(nreviews[i].text)\n",
    "        except:\n",
    "            numberOfReviews.append(\"N/A\")\n",
    "\n",
    "    for i in range(1,len(nreviews),7):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            user_follower.append(nreviews[i].text)\n",
    "        except:\n",
    "            user_follower.append(\"N/A\") \n",
    "\n",
    "     # Selecting element to scrap rating- \n",
    "    container = box.find_elements(By.XPATH, \".//div[@class='sc-1q7bklc-1 cILgox']\")\n",
    "    \n",
    "    for i in range(len(container)):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            rating.append(container[i].text)\n",
    "        except:\n",
    "            rating.append(\"N/A\")\n",
    "\n",
    "     # Selecting element to scrap review- \n",
    "    containers = box.find_elements(By.XPATH, \".//div[@class='sc-1q7bklc-9 dYrjiw']\")\n",
    "    \n",
    "    for i in range(len(containers)):\n",
    "    # To handle errors -\n",
    "        try:\n",
    "            review_type.append(containers[i].text)\n",
    "        except:\n",
    "            review_type.append(\"N/A\")\n",
    "\n",
    "\n",
    "    # Handling pagination\n",
    "    try:\n",
    "        next_button = driver.find_element(By.XPATH, \".//div[@class='sc-kAPOMq gbiCdQ']\" )\n",
    "        next_button.click()\n",
    "        time.sleep(60)  # Wait for the content to load\n",
    "    except:\n",
    "        print(\"Next page not found or error in clicking.\")\n",
    "        break  # Exit loop if there's no next page\n",
    "\n",
    "    \n",
    "\n",
    "# Close the browser \n",
    "# driver.quit()\n",
    "\n",
    "\n",
    "\n",
    "   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 648,
   "id": "520e12c7-18e5-4e77-9bdb-b650901d1afe",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "user_name: ['Peeyush Agarwal', 'Megha Jain', 'Gaurav', 'Gaurav Christian', 'Mohd Kasim', 'SWAGATA MOHAPATRA', 'Nitisha Pande', 'Sanjana Nayak', 'Shantanu', 'Vikas Bhardwaj', 'Vanamali Gowthami', 'Manita Kumari', 'Sawan Yaduvanshi', 'Akanksha Chauhan', 'Arjun Singh Negi', 'Avinash Sappidi', 'Tanya Yadav', 'Kruthi', 'Satish Prajapati', 'Vrinda Sharma', 'Aarti Lamba', 'Gagandeep Kaur', 'Tanvi Khanna', 'Achu2312', 'Drishti', 'Abhishek Singh', 'Kruthi', 'Godfrey', 'Manoj Kumar', 'Hrishikesh', 'Yukta Keer', 'Vijay', 'Afaque Jawaid', 'Anjali', 'Dhananjay Aneja', 'UDIT KAPAHI', 'Prachi Sharma', 'Vishnu', 'Vibhav', 'Dinesh Kumar', 'Nishi Kavi', 'Kruthi', 'Creative Manoj', 'Rajan', 'Randeep Singh', 'Aarush Nayak', 'Aditya Sen', 'Sumegdha', 'Harshit', 'Drishti']\n",
      " \n",
      "timeOfPosting: ['yesterday', '10 days ago', '10 days ago', '11 days ago', '13 days ago', '26 days ago', '27 days ago', '28 days ago', '30 days ago', 'one month ago', 'one month ago', 'one month ago', 'one month ago', 'one month ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '2 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago', '3 months ago']\n",
      " \n",
      "vote_list: ['0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '1 Helpful vote, 0 Comments', '0 Votes for helpful, 1 Comment', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 2 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments', '0 Votes for helpful, 0 Comments']\n",
      " \n",
      "user_follower: ['0 Followers', '1 Followers', '0 Followers', '1 Followers', '0 Followers', '1 Followers', '1 Followers', '0 Followers', '17 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '12 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '1 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '1 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '1 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '7 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers', '0 Followers']\n",
      " \n",
      "numberOfReviews: ['0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews', '0 reviews']\n",
      " \n",
      "rating: ['1', '1', '5', '1', '2', '5', '4', '5', '1', '1', '5', '1', '5', '1', '3', '1', '5', '2', '1', '5', '1', '3', '5', '5', '5', '1', '5', '5', '1', '1', '5', '5', '5', '4', '1', '1', '5', '4', '5', '3', '5', '3', '4', '5', '5', '3', '1', '4', '1', '5']\n",
      " \n",
      "review: ['not delivered order', 'very bad experience cheese is rotten', '', 'terrible packing, pizzq stuck to the pizzq box and did not even send a carry bag', 'cost bhot jayada hai', '', '', '', 'I received a wrong pizza.', 'I ordered stuffed garlic bread and the sent garlic breadsticks. It was utter and complete disappointment.', '', \"we got different pizza. very bad experience and you can't contact the store coz they have given wrong number.\", '', 'pizza not good as per prize', 'not too delicious for garlic bread and veg parcel stuffing was lesser', '', 'sooooo delicious 😋 , fresh cheese toppings well given', 'Too much salty', 'very bad quality', '', '', 'no mayo or filling inside, too blank', '', '', '', \"Bad delivery experience and food quality. Please serve the food nicely. Else don't accept the order.\", '', '', 'Delayed delivery. Chat support said delay coupon would be given which can be claimed after delivery. But then after delivery, the chat assistant refused to give any coupons.\\n\\nPlease look into this blatant misinformation being communicated to customers.', 'The service from the store was horrible, as they wouldn’t pick up even the call to say the order will be delivered after a delay of 1.5hrs', 'Kindly provide 4-5 sachets of villi flecks and oregano', '', '', 'peri peri chicken lacked peri peri', '', '', '', '', '', 'no paneer in pizza', '', '', '', '', '', '', 'No ketchup', '', 'please delivered on time for next tine', 'lateee service']\n",
      " \n",
      "review_type: ['DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY', 'DELIVERY']\n"
     ]
    }
   ],
   "source": [
    "# printing all the lists  we initialized to store the data - \n",
    "\n",
    "print(\"user_name:\" , user_name)\n",
    "print(\" \")\n",
    "print(\"timeOfPosting:\", timeOfPosting)\n",
    "print(\" \")\n",
    "print(\"vote_list:\", vote_list)\n",
    "print(\" \")\n",
    "print(\"user_follower:\", user_follower)\n",
    "print(\" \")\n",
    "print(\"numberOfReviews:\", numberOfReviews)\n",
    "print(\" \")\n",
    "print(\"rating:\", rating)\n",
    "print(\" \")\n",
    "print(\"review:\", review)\n",
    "print(\" \")\n",
    "print(\"review_type:\", review_type)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 651,
   "id": "24f63c9e-4a9d-40a6-8cfc-247480d2b3a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating a dataframe to store the data - \n",
    "df1 = pd.DataFrame({\n",
    "    'user_name': user_name,\n",
    "    'numberOfReviews': numberOfReviews,\n",
    "    'user_follower': user_follower,\n",
    "    'star_rating': rating,\n",
    "    'time_of_posting ': timeOfPosting ,\n",
    "    'votes' : vote_list,\n",
    "    'review': review,\n",
    "    'review_type' : review_type\n",
    "})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 653,
   "id": "82b3e567-ccdc-433b-b866-f13304c3a52e",
   "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>user_name</th>\n",
       "      <th>numberOfReviews</th>\n",
       "      <th>user_follower</th>\n",
       "      <th>star_rating</th>\n",
       "      <th>time_of_posting</th>\n",
       "      <th>votes</th>\n",
       "      <th>review</th>\n",
       "      <th>review_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Peeyush Agarwal</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>yesterday</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>not delivered order</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Megha Jain</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>1 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>10 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>very bad experience cheese is rotten</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gaurav</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>10 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gaurav Christian</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>1 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>11 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>terrible packing, pizzq stuck to the pizzq box...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mohd Kasim</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>2</td>\n",
       "      <td>13 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>cost bhot jayada hai</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SWAGATA MOHAPATRA</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>1 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>26 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Nitisha Pande</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>1 Followers</td>\n",
       "      <td>4</td>\n",
       "      <td>27 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sanjana Nayak</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>28 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Shantanu</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>17 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>30 days ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>I received a wrong pizza.</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Vikas Bhardwaj</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>one month ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>I ordered stuffed garlic bread and the sent ga...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Vanamali Gowthami</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>one month ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Manita Kumari</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>one month ago</td>\n",
       "      <td>1 Helpful vote, 0 Comments</td>\n",
       "      <td>we got different pizza. very bad experience an...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sawan Yaduvanshi</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>one month ago</td>\n",
       "      <td>0 Votes for helpful, 1 Comment</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Akanksha Chauhan</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>one month ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>pizza not good as per prize</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Arjun Singh Negi</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>3</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>not too delicious for garlic bread and veg par...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Avinash Sappidi</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>12 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Tanya Yadav</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>sooooo delicious 😋 , fresh cheese toppings wel...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kruthi</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>2</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>Too much salty</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Satish Prajapati</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>very bad quality</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Vrinda Sharma</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Aarti Lamba</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Gagandeep Kaur</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>3</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 2 Comments</td>\n",
       "      <td>no mayo or filling inside, too blank</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Tanvi Khanna</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Achu2312</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>1 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Drishti</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Abhishek Singh</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>Bad delivery experience and food quality. Plea...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Kruthi</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Godfrey</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Manoj Kumar</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>1 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>Delayed delivery. Chat support said delay coup...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Hrishikesh</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>The service from the store was horrible, as th...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Yukta Keer</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>Kindly provide 4-5 sachets of villi flecks and...</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Vijay</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Afaque Jawaid</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Anjali</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>1 Followers</td>\n",
       "      <td>4</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>peri peri chicken lacked peri peri</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Dhananjay Aneja</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>UDIT KAPAHI</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Prachi Sharma</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Vishnu</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>4</td>\n",
       "      <td>2 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Vibhav</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Dinesh Kumar</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>3</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>no paneer in pizza</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Nishi Kavi</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>7 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Kruthi</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>3</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Creative Manoj</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>4</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Rajan</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Randeep Singh</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Aarush Nayak</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>3</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Aditya Sen</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>No ketchup</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Sumegdha</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>4</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td></td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Harshit</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>1</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>please delivered on time for next tine</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Drishti</td>\n",
       "      <td>0 reviews</td>\n",
       "      <td>0 Followers</td>\n",
       "      <td>5</td>\n",
       "      <td>3 months ago</td>\n",
       "      <td>0 Votes for helpful, 0 Comments</td>\n",
       "      <td>lateee service</td>\n",
       "      <td>DELIVERY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            user_name numberOfReviews user_follower star_rating  \\\n",
       "0     Peeyush Agarwal       0 reviews   0 Followers           1   \n",
       "1          Megha Jain       0 reviews   1 Followers           1   \n",
       "2              Gaurav       0 reviews   0 Followers           5   \n",
       "3    Gaurav Christian       0 reviews   1 Followers           1   \n",
       "4          Mohd Kasim       0 reviews   0 Followers           2   \n",
       "5   SWAGATA MOHAPATRA       0 reviews   1 Followers           5   \n",
       "6       Nitisha Pande       0 reviews   1 Followers           4   \n",
       "7       Sanjana Nayak       0 reviews   0 Followers           5   \n",
       "8            Shantanu       0 reviews  17 Followers           1   \n",
       "9      Vikas Bhardwaj       0 reviews   0 Followers           1   \n",
       "10  Vanamali Gowthami       0 reviews   0 Followers           5   \n",
       "11      Manita Kumari       0 reviews   0 Followers           1   \n",
       "12   Sawan Yaduvanshi       0 reviews   0 Followers           5   \n",
       "13   Akanksha Chauhan       0 reviews   0 Followers           1   \n",
       "14   Arjun Singh Negi       0 reviews   0 Followers           3   \n",
       "15    Avinash Sappidi       0 reviews  12 Followers           1   \n",
       "16        Tanya Yadav       0 reviews   0 Followers           5   \n",
       "17             Kruthi       0 reviews   0 Followers           2   \n",
       "18   Satish Prajapati       0 reviews   0 Followers           1   \n",
       "19      Vrinda Sharma       0 reviews   0 Followers           5   \n",
       "20        Aarti Lamba       0 reviews   0 Followers           1   \n",
       "21     Gagandeep Kaur       0 reviews   0 Followers           3   \n",
       "22       Tanvi Khanna       0 reviews   0 Followers           5   \n",
       "23           Achu2312       0 reviews   1 Followers           5   \n",
       "24            Drishti       0 reviews   0 Followers           5   \n",
       "25     Abhishek Singh       0 reviews   0 Followers           1   \n",
       "26             Kruthi       0 reviews   0 Followers           5   \n",
       "27            Godfrey       0 reviews   0 Followers           5   \n",
       "28        Manoj Kumar       0 reviews   1 Followers           1   \n",
       "29         Hrishikesh       0 reviews   0 Followers           1   \n",
       "30         Yukta Keer       0 reviews   0 Followers           5   \n",
       "31              Vijay       0 reviews   0 Followers           5   \n",
       "32      Afaque Jawaid       0 reviews   0 Followers           5   \n",
       "33             Anjali       0 reviews   1 Followers           4   \n",
       "34    Dhananjay Aneja       0 reviews   0 Followers           1   \n",
       "35        UDIT KAPAHI       0 reviews   0 Followers           1   \n",
       "36      Prachi Sharma       0 reviews   0 Followers           5   \n",
       "37             Vishnu       0 reviews   0 Followers           4   \n",
       "38             Vibhav       0 reviews   0 Followers           5   \n",
       "39       Dinesh Kumar       0 reviews   0 Followers           3   \n",
       "40         Nishi Kavi       0 reviews   7 Followers           5   \n",
       "41             Kruthi       0 reviews   0 Followers           3   \n",
       "42     Creative Manoj       0 reviews   0 Followers           4   \n",
       "43              Rajan       0 reviews   0 Followers           5   \n",
       "44      Randeep Singh       0 reviews   0 Followers           5   \n",
       "45       Aarush Nayak       0 reviews   0 Followers           3   \n",
       "46         Aditya Sen       0 reviews   0 Followers           1   \n",
       "47           Sumegdha       0 reviews   0 Followers           4   \n",
       "48            Harshit       0 reviews   0 Followers           1   \n",
       "49            Drishti       0 reviews   0 Followers           5   \n",
       "\n",
       "   time_of_posting                             votes  \\\n",
       "0         yesterday  0 Votes for helpful, 0 Comments   \n",
       "1       10 days ago  0 Votes for helpful, 0 Comments   \n",
       "2       10 days ago  0 Votes for helpful, 0 Comments   \n",
       "3       11 days ago  0 Votes for helpful, 0 Comments   \n",
       "4       13 days ago  0 Votes for helpful, 0 Comments   \n",
       "5       26 days ago  0 Votes for helpful, 0 Comments   \n",
       "6       27 days ago  0 Votes for helpful, 0 Comments   \n",
       "7       28 days ago  0 Votes for helpful, 0 Comments   \n",
       "8       30 days ago  0 Votes for helpful, 0 Comments   \n",
       "9     one month ago  0 Votes for helpful, 0 Comments   \n",
       "10    one month ago  0 Votes for helpful, 0 Comments   \n",
       "11    one month ago       1 Helpful vote, 0 Comments   \n",
       "12    one month ago   0 Votes for helpful, 1 Comment   \n",
       "13    one month ago  0 Votes for helpful, 0 Comments   \n",
       "14     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "15     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "16     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "17     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "18     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "19     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "20     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "21     2 months ago  0 Votes for helpful, 2 Comments   \n",
       "22     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "23     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "24     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "25     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "26     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "27     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "28     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "29     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "30     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "31     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "32     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "33     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "34     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "35     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "36     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "37     2 months ago  0 Votes for helpful, 0 Comments   \n",
       "38     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "39     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "40     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "41     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "42     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "43     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "44     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "45     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "46     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "47     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "48     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "49     3 months ago  0 Votes for helpful, 0 Comments   \n",
       "\n",
       "                                               review review_type  \n",
       "0                                 not delivered order    DELIVERY  \n",
       "1                very bad experience cheese is rotten    DELIVERY  \n",
       "2                                                        DELIVERY  \n",
       "3   terrible packing, pizzq stuck to the pizzq box...    DELIVERY  \n",
       "4                                cost bhot jayada hai    DELIVERY  \n",
       "5                                                        DELIVERY  \n",
       "6                                                        DELIVERY  \n",
       "7                                                        DELIVERY  \n",
       "8                           I received a wrong pizza.    DELIVERY  \n",
       "9   I ordered stuffed garlic bread and the sent ga...    DELIVERY  \n",
       "10                                                       DELIVERY  \n",
       "11  we got different pizza. very bad experience an...    DELIVERY  \n",
       "12                                                       DELIVERY  \n",
       "13                        pizza not good as per prize    DELIVERY  \n",
       "14  not too delicious for garlic bread and veg par...    DELIVERY  \n",
       "15                                                       DELIVERY  \n",
       "16  sooooo delicious 😋 , fresh cheese toppings wel...    DELIVERY  \n",
       "17                                     Too much salty    DELIVERY  \n",
       "18                                   very bad quality    DELIVERY  \n",
       "19                                                       DELIVERY  \n",
       "20                                                       DELIVERY  \n",
       "21               no mayo or filling inside, too blank    DELIVERY  \n",
       "22                                                       DELIVERY  \n",
       "23                                                       DELIVERY  \n",
       "24                                                       DELIVERY  \n",
       "25  Bad delivery experience and food quality. Plea...    DELIVERY  \n",
       "26                                                       DELIVERY  \n",
       "27                                                       DELIVERY  \n",
       "28  Delayed delivery. Chat support said delay coup...    DELIVERY  \n",
       "29  The service from the store was horrible, as th...    DELIVERY  \n",
       "30  Kindly provide 4-5 sachets of villi flecks and...    DELIVERY  \n",
       "31                                                       DELIVERY  \n",
       "32                                                       DELIVERY  \n",
       "33                 peri peri chicken lacked peri peri    DELIVERY  \n",
       "34                                                       DELIVERY  \n",
       "35                                                       DELIVERY  \n",
       "36                                                       DELIVERY  \n",
       "37                                                       DELIVERY  \n",
       "38                                                       DELIVERY  \n",
       "39                                 no paneer in pizza    DELIVERY  \n",
       "40                                                       DELIVERY  \n",
       "41                                                       DELIVERY  \n",
       "42                                                       DELIVERY  \n",
       "43                                                       DELIVERY  \n",
       "44                                                       DELIVERY  \n",
       "45                                                       DELIVERY  \n",
       "46                                         No ketchup    DELIVERY  \n",
       "47                                                       DELIVERY  \n",
       "48             please delivered on time for next tine    DELIVERY  \n",
       "49                                     lateee service    DELIVERY  "
      ]
     },
     "execution_count": 653,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Displaying the data - \n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 655,
   "id": "418508c0-72be-47ce-b0bb-c9fe8d2fe024",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Saving the extracted data into a csv file - \n",
    "df1.to_csv('zomato_reviews.csv', index=False, encoding='utf-8-sig') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d9473531-cdcf-4a9e-80c5-d23e5cf9b5dd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "71d85bfa-d9fd-4479-ba2b-c78eb8434f49",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1683fa9f-198c-4a0b-86c6-86c5f40417aa",
   "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.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}