ibfappliances-checkpoint.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import lxml\n",
    "import re\n",
    "import selenium\n",
    "from selenium import webdriver\n",
    "import pandas as pd\n",
    "from time import sleep\n",
    "import requests\n",
    "from bs4 import BeautifulSoup as bs\n",
    "from selenium.webdriver.common.action_chains import ActionChains\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.support.ui import Select\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = selenium.webdriver.Chrome(executable_path='C:/Users/abdenather/Desktop/chromedriver_win32/chromedriver.exe')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "stores_address=[]\n",
    "contact=[]\n",
    "latitude=[]\n",
    "longitude=[]\n",
    "url='https://www.ifbappliances.com/storelocator'\n",
    "driver.get(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "select = Select(driver.find_element_by_id('storetype'))\n",
    "select.select_by_value('2')\n",
    "sleep(1)\n",
    "select = Select(driver.find_element_by_id('state'))\n",
    "select.select_by_value('Maharashtra')\n",
    "sleep(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "element=driver.find_element_by_id(\"city\")\n",
    "cities=element.text\n",
    "cities=[s.strip() for s in cities.splitlines()]\n",
    "cities=cities[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Baramati',\n",
       " 'Lonavla',\n",
       " 'Mumbai',\n",
       " 'Navi Mumbai',\n",
       " 'Powai',\n",
       " 'Pune',\n",
       " 'Raigad',\n",
       " 'Rajgurunagar',\n",
       " 'Shirur',\n",
       " 'Solapur',\n",
       " 'Talegaon Dabhade',\n",
       " 'Thane',\n",
       " 'Vasai',\n",
       " 'Virar']"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Baramati 0\n",
      "https://www.ifbappliances.com/maharashtra/baramati/v-r-electranics\n",
      "Lonavla 1\n",
      "https://www.ifbappliances.com/maharashtra/lonavla/suraj-novelties\n",
      "https://www.ifbappliances.com/maharashtra/lonavla/khozema-traders\n",
      "Mumbai 2\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/gemini-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/hreenkar-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/anil-audio-video-distributors-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/shreeyog-distributors\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/omega-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/mayur-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/gala-sons\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/panavision-televideo-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/globe-radios\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/maharashtra-radio-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/elite-services\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/ethos-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/royal-enterprises\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/royal-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/sahakar-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/kirti-radio-television-centre\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/new-shah-enterprises\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/mansukh-distributors-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/alfa\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/max-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/rahul-electronics-appliances\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/jp-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/electronics-world\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/meera-enterprises\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/warsi\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/rahi-electronics-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/sapna-electric-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/arihant-electronics-vile-parle\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/infiniti-wholesale-limited\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/punamiya-electronics-electricals\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/roopam-trading-syndicate\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/anukool-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/deluxe-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/united-agencies-bombaypvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/bhawal-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/beena-sales\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/shriram-refrigeration\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/meghdoot-electrovision\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/shams-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/gurunanak-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/sst-corporation\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/fair-electronics-app-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/consumer-shoppee\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/zee-novelties\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/b-j-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/amar-tv-centre\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/vijay-sales-corporation\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/happy-home-emporium\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/sanjay-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/kings-electronics-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/swift-associates\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/shanti-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/royal-cooling\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/rishab-enterprises\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/vikas-sales-2\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/shree-kalika-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/digital-collection\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/vardhman-watch-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/electronics-centre\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/fairdeal-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/urvashi-creators\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/ses-classic\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/a-1-electronic-centre\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/jain-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/sapna-electronics\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/kitchen-art\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/kaybee-appliances-electronics-pvt\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/vikas-sales\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/satyam-electrovision\n",
      "https://www.ifbappliances.com/maharashtra/mumbai/ragesh-electronics\n",
      "Navi Mumbai 3\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/yash-electronics-home-appliances\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/vighnaharata-electronics\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/yash-electronics\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/arcee-electronics\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/meera-electronics\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/om-sai-electronics\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/reliance-digital-retail-limited\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/nanda-electronics\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/matrix-electronics-mobile-gallary\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/laxmi-plaza\n",
      "https://www.ifbappliances.com/maharashtra/navi-mumbai/top-ten-electronics-shoppee-nx\n",
      "Powai 4\n",
      "https://www.ifbappliances.com/maharashtra/powai/maharashtra-electronics\n",
      "https://www.ifbappliances.com/maharashtra/powai/malaika-appliances-pvt-ltd\n",
      "Pune 5\n",
      "https://www.ifbappliances.com/maharashtra/pune/deep-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/fancy-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/triveni-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/pawan-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/shri-siddhivinayak-ent\n",
      "https://www.ifbappliances.com/maharashtra/pune/godawari-sales\n",
      "https://www.ifbappliances.com/maharashtra/pune/super-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/maa-sharda-enterprises\n",
      "https://www.ifbappliances.com/maharashtra/pune/sai-kitchen\n",
      "https://www.ifbappliances.com/maharashtra/pune/maharashtra-electronics-corporation\n",
      "https://www.ifbappliances.com/maharashtra/pune/vividh-lahari\n",
      "https://www.ifbappliances.com/maharashtra/pune/mahavir-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/kitchen-magic\n",
      "https://www.ifbappliances.com/maharashtra/pune/mahavir-electronics-furniture-bibvevadi-pune\n",
      "https://www.ifbappliances.com/maharashtra/pune/r-k-music-centre\n",
      "https://www.ifbappliances.com/maharashtra/pune/m-k-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/radhika-sales-corporation\n",
      "https://www.ifbappliances.com/maharashtra/pune/modern-electronics-appliances\n",
      "https://www.ifbappliances.com/maharashtra/pune/vinny-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/priya-associates\n",
      "https://www.ifbappliances.com/maharashtra/pune/keyour\n",
      "https://www.ifbappliances.com/maharashtra/pune/pravin-furniture-elctronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/plug-n-play\n",
      "https://www.ifbappliances.com/maharashtra/pune/saket-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/memorex-home-appliances\n",
      "https://www.ifbappliances.com/maharashtra/pune/modern-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/hans-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/vidya-sales\n",
      "https://www.ifbappliances.com/maharashtra/pune/bhawani-electrical-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/d-p-kolte-sales-corporation\n",
      "https://www.ifbappliances.com/maharashtra/pune/jogdeo-company\n",
      "https://www.ifbappliances.com/maharashtra/pune/sidharth-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/gokul-electricals\n",
      "https://www.ifbappliances.com/maharashtra/pune/arihant-electronics-pune\n",
      "https://www.ifbappliances.com/maharashtra/pune/variety-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/shiba-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/gayatri-electronics\n",
      "https://www.ifbappliances.com/maharashtra/pune/agents-corner\n",
      "https://www.ifbappliances.com/maharashtra/pune/mahavir-electronics-furniture-pune\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Raigad 6\n",
      "https://www.ifbappliances.com/maharashtra/raigad/evergreen-electronics\n",
      "https://www.ifbappliances.com/maharashtra/raigad/modern-enterprises\n",
      "https://www.ifbappliances.com/maharashtra/raigad/my-kitchen-home-appliance\n",
      "Rajgurunagar 7\n",
      "https://www.ifbappliances.com/maharashtra/rajgurunagar/jayhind-electricals\n",
      "Shirur 8\n",
      "https://www.ifbappliances.com/maharashtra/shirur/darda-agencys\n",
      "Solapur 9\n",
      "https://www.ifbappliances.com/maharashtra/solapur/arihant-electronics-solapur\n",
      "Talegaon Dabhade 10\n",
      "https://www.ifbappliances.com/maharashtra/talegaon-dabhade/sursangam-electronics\n",
      "Thane 11\n",
      "https://www.ifbappliances.com/maharashtra/thane/embassy-electronics\n",
      "https://www.ifbappliances.com/maharashtra/thane/kiran-electronics\n",
      "https://www.ifbappliances.com/maharashtra/thane/shree-jain-traders\n",
      "https://www.ifbappliances.com/maharashtra/thane/perfect-electrovision\n",
      "https://www.ifbappliances.com/maharashtra/thane/ruchit-electronics\n",
      "https://www.ifbappliances.com/maharashtra/thane/anant-electronics-maharashtra\n",
      "https://www.ifbappliances.com/maharashtra/thane/om-parshwanath-electronics\n",
      "https://www.ifbappliances.com/maharashtra/thane/mascot-refrigeration\n",
      "https://www.ifbappliances.com/maharashtra/thane/jumbo-distributors-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/thane/ichha-electronics\n",
      "https://www.ifbappliances.com/maharashtra/thane/gaurav-elelctronics\n",
      "https://www.ifbappliances.com/maharashtra/thane/see-kitchen\n",
      "Vasai 12\n",
      "https://www.ifbappliances.com/maharashtra/vasai/rana-electronics-appliances\n",
      "https://www.ifbappliances.com/maharashtra/vasai/shree-lords-electronics\n",
      "Virar 13\n",
      "https://www.ifbappliances.com/maharashtra/virar/vikas-enterprises\n",
      "https://www.ifbappliances.com/maharashtra/virar/viva-supermarket-pvt-ltd\n",
      "https://www.ifbappliances.com/maharashtra/virar/national-electronics\n"
     ]
    }
   ],
   "source": [
    "i=0\n",
    "driver.get(url)\n",
    "select = Select(driver.find_element_by_id('storetype'))\n",
    "select.select_by_value('2')\n",
    "sleep(1)\n",
    "select = Select(driver.find_element_by_id('state'))\n",
    "select.select_by_value('Maharashtra')\n",
    "sleep(1)\n",
    "urls=[]\n",
    "while i<len(cities):  \n",
    "    select = Select(driver.find_element_by_id('city'))\n",
    "    select.select_by_value(cities[i])\n",
    "    print(cities[i],i)\n",
    "    sleep(3)\n",
    "    b=driver.find_element_by_id(\"store-search\")\n",
    "    #print(b)\n",
    "    b.click()\n",
    "    #break\n",
    "    sleep(3)\n",
    "    items=driver.find_elements_by_class_name('store-link-btn')\n",
    "    for j in items:\n",
    "        a=j.get_attribute('href')\n",
    "        urls.append(a)\n",
    "        print(a)\n",
    "    sleep(2)\n",
    "    i+=1\n",
    "    #print(\"j\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "18.148765\n",
      "74.571757\n",
      "34 Mahavi Rpeth Rd Gandhi Chowk Landmark : Rng Tower Baramati,maharashtra,\n",
      "V R Electranics\n",
      "9422519034 2112229204\n",
      "dd\n",
      "18.749871\n",
      "73.406016\n",
      "D 35 M G Road Lonavla,maharashtra,\n",
      "Suraj Novelties\n",
      "9822653366 2114272466\n",
      "dd\n",
      "18.747515\n",
      "73.408381\n",
      "Market Road Lonavla,maharashtra,\n",
      "Khozema Traders\n",
      "9960009786 2114272325\n",
      "dd\n",
      "19.018291\n",
      "72.840944\n",
      "Dadar Shopping Complex Dadar West Mumbai,maharashtra,\n",
      "Gemini Electronics\n",
      "24224060\n",
      "dd\n",
      "19.012259\n",
      "72.833138\n",
      "St Bus Depot Gokhale Road Prabhadevi Mumbai,maharashtra,\n",
      "Hreenkar Electronics\n",
      "222905247\n",
      "dd\n",
      "19.05026\n",
      "72.89375\n",
      "Shop No 4 & 14 Savla Sadan R. C. Marg Opp Ration Office Chembur Mumbai,maharashtra,\n",
      "Anil Audio Video Distributors Pvt. Ltd\n",
      "225281989\n",
      "dd\n",
      "19.238031\n",
      "72.859472\n",
      "Shree Yash Plaza Gr.Floor M.G.Road Near Lic Office Mumbai,maharashtra,\n",
      "Shreeyog Distributors\n",
      "2143257469\n",
      "dd\n",
      "19.230564\n",
      "72.856484\n",
      "Canravarkar Lane Borivali West Mumbai,maharashtra,\n",
      "Omega Electronics\n",
      "2220585858\n",
      "dd\n",
      "19.078952\n",
      "72.908707\n",
      "14 Kailash Mahal Bldg Opp Odeon Mumbai,maharashtra,\n",
      "Mayur Electronics\n",
      "2221024335\n",
      "dd\n",
      "19.187168\n",
      "72.840766\n",
      "Opp Natraj Market S V Rd Malad West Mumbai,maharashtra,\n",
      "Gala & Sons\n",
      "2222908615\n",
      "dd\n",
      "18.953498\n",
      "72.816821\n",
      "Near Tbz Opera House Mumbai,maharashtra,\n",
      "Panavision Televideo Pvt. Ltd\n",
      "2223631038\n",
      "dd\n",
      "18.954698\n",
      "72.816214\n",
      "Opera House Charni Road Mumbai,maharashtra,\n",
      "Globe Radios\n",
      "2223681955\n",
      "dd\n",
      "19.029837\n",
      "72.841416\n",
      "City Cinema Road Mahim Mumbai,maharashtra,\n",
      "Maharashtra Radio & Electronics\n",
      "2224466105\n",
      "dd\n",
      "18.98967\n",
      "72.835558\n",
      "Near Church Station Road Mahim West Mumbai,maharashtra,\n",
      "Elite Services\n",
      "2224475968\n",
      "dd\n",
      "19.050478\n",
      "72.904815\n",
      "Shop No 10 Atul Park Sion Trombay Road Chembur(E) Mumbai,maharashtra,\n",
      "Ethos Electronics\n",
      "2225203056\n",
      "dd\n",
      "19.052097\n",
      "72.900183\n",
      "Shop No. 19 Sundar Apts Sion Trombay Road Opp Diamond Garden Chembur Mumbai,maharashtra,\n",
      "Royal Enterprises\n",
      "2225223842\n",
      "dd\n",
      "19.052199\n",
      "72.899683\n",
      "Shop No. 3 Sundar Apts Sion Trombay Road Opp Diamond Garden Chembur Mumbai,maharashtra,\n",
      "Royal Electronics\n",
      "2225224219 98200330725\n",
      "dd\n",
      "19.068119\n",
      "72.90103\n",
      "Shop No 3 Amar Mahal Chembur (W) Mumbai,maharashtra,\n",
      "Sahakar Electronics\n",
      "2225242202\n",
      "dd\n",
      "19.189411\n",
      "72.976161\n",
      "Station Road Thane (W),maharashtra,\n",
      "Kirti Radio & Television Centre\n",
      "2225476757\n",
      "dd\n",
      "19.155171\n",
      "72.937183\n",
      "Pannalal Compund L.B.S Marg Bhandup (W) Mumbai,maharashtra,\n",
      "New Shah Enterprises\n",
      "2225916666\n",
      "dd\n",
      "19.099991\n",
      "72.845289\n",
      "Shyam Kamal Society Near Parle Internationla Hotel Agarwal Market Vile Parle (E) Mumbai,maharashtra,\n",
      "Mansukh Distributors Pvt Ltd\n",
      "2226131967\n",
      "dd\n",
      "19.108305\n",
      "72.839365\n",
      "Ayub Khan Compound Irla Vile Parle (W) Mumbai,maharashtra,\n",
      "Alfa\n",
      "2226719696\n",
      "dd\n",
      "19.018881\n",
      "73.017282\n",
      "Near Seawood Rly. Station Nerul Mumbai,maharashtra,\n",
      "Max Electronics\n",
      "2227723632\n",
      "dd\n",
      "19.156844\n",
      "72.845653\n",
      "Near Cine Max S V Rd Goregaon West Mumbai,maharashtra,\n",
      "Rahul Electronics & Appliances\n",
      "2228778640\n",
      "dd\n",
      "19.249153\n",
      "72.850007\n",
      "Holy Cross Road Boriwali West Mumbai,maharashtra,\n",
      "J.P. Electronics\n",
      "2228922020\n",
      "dd\n",
      "23.366339\n",
      "85.324308\n",
      "Shop No 70 & 71 Plot No 26 Shelter Arcade Sector-42 Seawoods Mumbai,maharashtra,\n",
      "Electronics World\n",
      "2232981199\n",
      "dd\n",
      "19.017604\n",
      "72.856062\n",
      "Raju Pote Marg Mumbai,maharashtra,\n",
      "Meera Enterprises\n",
      "9028377069\n",
      "dd\n",
      "19.024786\n",
      "73.022088\n",
      "Shop No.4 Olive Excel Chs Plot 16 Sec-42 Seawood Mumbai,maharashtra,\n",
      "Warsi\n",
      "9324343766\n",
      "dd\n",
      "19.163761\n",
      "72.846024\n",
      "S V Rd Goregaon West Mumbai,maharashtra,\n",
      "Rahi Electronics Pvt. Ltd\n",
      "9820042315\n",
      "dd\n",
      "19.579919\n",
      "72.831687\n",
      "Dadasaheb Pandit Market Saphale East Mumbai,maharashtra,\n",
      "Sapna Electric & Electronics\n",
      "95250230204\n",
      "dd\n",
      "17.677469\n",
      "75.903081\n",
      "Shyam Kamal Society Near Parle Internationla Hotel Agarwal Market Vile Parle (E) Mumbai,maharashtra,\n",
      "Arihant Electronics\n",
      "226104501 2226104498\n",
      "dd\n",
      "19.017597\n",
      "72.855957\n",
      "Midc Andheri (E) Mumbai,maharashtra,\n",
      "Infiniti Wholesale Limited\n",
      "2267100011\n",
      "dd\n",
      "19.108466\n",
      "72.867145\n",
      "Bhagwan Mahavir Marg Mumbai,maharashtra,\n",
      "Punamiya Electronics & Electricals\n",
      "02143-254739\n",
      "dd\n",
      "18.946362\n",
      "72.832614\n",
      "40 Jay Mahal Estate Lohar Chawl Mumbai,maharashtra,\n",
      "Roopam Trading Syndicate\n",
      "022-22066998\n",
      "dd\n",
      "18.965793\n",
      "72.828161\n",
      "Near Bharat Gas Agency Mumbai,maharashtra,\n",
      "Anukool Electronics\n",
      "022-23077000\n",
      "dd\n",
      "18.971006\n",
      "72.831732\n",
      "Byculla Bridge Ap Ansari Road Mumbai,maharashtra,\n",
      "Deluxe Electronics\n",
      "022-23086262\n",
      "dd\n",
      "18.956036\n",
      "72.815627\n",
      "Opp. Panchratna Bldg Opera House Mumbai,maharashtra,\n",
      "United Agencies (Bombay)Pvt. Ltd.\n",
      "022-23635977 9821559050\n",
      "dd\n",
      "19.006254\n",
      "72.845726\n",
      "Parel Bhoiwada Parel Mumbai,maharashtra,\n",
      "Bhawal Electronics\n",
      "022-24115409\n",
      "dd\n",
      "19.413701\n",
      "72.82561\n",
      "Shop No1 & 2 Sainath Apts Achule Road Opp Paras Shopping Centre Nalasopara (E) Mumbai,maharashtra,\n",
      "Beena Sales\n",
      "022-2435675\n",
      "dd\n",
      "19.222821\n",
      "73.085763\n",
      "N S S Road Dombivali (W) Mumbai,maharashtra,\n",
      "Shriram Refrigeration\n",
      "022-2489757\n",
      "dd\n",
      "19.088763\n",
      "72.905082\n",
      "Near New Life Hospital Shop No 3 Lbs Marg Ghatkopar (W) Mumbai,maharashtra,\n",
      "Meghdoot Electrovision\n",
      "022-25100808\n",
      "dd\n",
      "19.167556\n",
      "73.026487\n",
      "Kausa Mumbai,maharashtra,\n",
      "Shams Electronics\n",
      "022-25495541\n",
      "dd\n",
      "19.045757\n",
      "72.896581\n",
      "Transit Camp Chembur Mumbai,maharashtra,\n",
      "Gurunanak Electronics\n",
      "022-25538068\n",
      "dd\n",
      "19.113108\n",
      "72.930575\n",
      "Shop No 19 Hazari Baug Station Road Vikhroli W Mumbai,maharashtra,\n",
      "Sst Corporation\n",
      "022-25781801\n",
      "dd\n",
      "19.15702\n",
      "72.932789\n",
      "Shop No 2 Gautam Udyog Udyog Bhavan Lbs Marg Bhandup (W) Mumbai,maharashtra,\n",
      "Fair Electronics & App. Pvt Ltd\n",
      "022-25947446\n",
      "dd\n",
      "19.073968\n",
      "72.8263\n",
      "Danpada Khar West Mumbai,maharashtra,\n",
      "Consumer Shoppee\n",
      "022-26007379\n",
      "dd\n",
      "19.100826\n",
      "72.845758\n",
      "Shyam Kamal Society Near Parle Internationla Hotel Agarwal Market Vile Parle (E) Mumbai,maharashtra,\n",
      "Zee Novelties\n",
      "022-26106248\n",
      "dd\n",
      "19.085358\n",
      "72.829582\n",
      "Near Petrol Pump Santacruz West Mumbai,maharashtra,\n",
      "B J Electronics\n",
      "022-26231520\n",
      "dd\n",
      "19.113611\n",
      "72.87139\n",
      "7 Bunglow Andheri West Mumbai,maharashtra,\n",
      "Amar Tv Centre\n",
      "022-26356910 226356806\n",
      "dd\n",
      "19.052883\n",
      "72.83791\n",
      "S.V. Road Near Lucky Hotel Bandra (W) Mumbai,maharashtra,\n",
      "Vijay Sales Corporation\n",
      "022-26422119\n",
      "dd\n",
      "19.066874\n",
      "72.877777\n",
      "Near Station Kurla West Mumbai,maharashtra,\n",
      "Happy Home Emporium\n",
      "022-26548226\n",
      "dd\n",
      "19.104075\n",
      "72.861521\n",
      "Koldongar Near Shivaji Chow,maharashtra,\n",
      "Sanjay Electronics\n",
      "022-26835238\n",
      "dd\n",
      "18.987946\n",
      "73.113953\n",
      "101 Durga Prasad Complex Plot No-156 M.C.C.H. Society Panvel Mumbai,maharashtra,\n",
      "Kings Electronics Pvt. Ltd.\n",
      "2227459430\n",
      "dd\n",
      "19.024834\n",
      "73.021842\n",
      "G-32A Centurion Mall Sector-19A Opp Hp Petrol Pump Seawood-East Mumbai,maharashtra,\n",
      "Swift Associates\n",
      "022-27700651\n",
      "dd\n",
      "19.225135\n",
      "72.977717\n",
      "Laxmi Plaza Near Bank Of Baroda Mira Road (E) Mumbai,maharashtra,\n",
      "Shanti Electronics\n",
      "022-28105625 8108128300\n",
      "dd\n",
      "19.120866\n",
      "72.889231\n",
      "Sakinaka Road Andheri (E) Mumbai,maharashtra,\n",
      "Royal Cooling\n",
      "022-28571077\n",
      "dd\n",
      "19.189899\n",
      "72.834846\n",
      "Chincholi Malad West Mumbai,maharashtra,\n",
      "Rishab Enterprises\n",
      "022-28813527\n",
      "dd\n",
      "19.10557\n",
      "72.86926\n",
      "Ashok Nagar Andheri Mumbai,maharashtra,\n",
      "Vikas Sales -2\n",
      "022-29200211\n",
      "dd\n",
      "19.116899\n",
      "72.879827\n",
      "Marol Andheri East Mumbai,maharashtra,\n",
      "Shree Kalika Electronics\n",
      "022-29200872\n",
      "dd\n",
      "19.032569\n",
      "72.896567\n",
      "Vashi Naka Road Chembur Mumbai,maharashtra,\n",
      "Digital Collection\n",
      "022-32052711\n",
      "dd\n",
      "19.205316\n",
      "72.851286\n",
      "Nr Kandivali Stn Kandivali West Mumbai,maharashtra,\n",
      "Vardhman Watch & Electronics\n",
      "022-80612325 228618088\n",
      "dd\n",
      "19.456294\n",
      "72.829106\n",
      "Opp. Petrol Pump Virar West Mumbai,maharashtra,\n",
      "Electronics Centre\n",
      "0250-2515668\n",
      "dd\n",
      "28.607058\n",
      "77.052917\n",
      "Nead Hdfc Bank Crawford Mkt Mumbai,maharashtra,\n",
      "Fairdeal Electronics\n",
      "43444786 9619222519\n",
      "dd\n",
      "19.118757\n",
      "72.845904\n",
      "S V Road Andheri West Mumbai,maharashtra,\n",
      "Urvashi Creators\n",
      "9967632844\n",
      "dd\n",
      "18.949255\n",
      "72.835033\n",
      "Mohammad Ali Road Mumbai,maharashtra,\n",
      "Ses Classic\n",
      "\n",
      "dd\n",
      "18.954289\n",
      "72.816248\n",
      "Opera House Charni Road Mumbai,maharashtra,\n",
      "A 1 Electronic Centre\n",
      "2223611877\n",
      "dd\n",
      "19.082692\n",
      "72.882457\n",
      "Lbs Marg Kurla West Mumbai,maharashtra,\n",
      "Jain Electronics\n",
      "\n",
      "dd\n",
      "19.163111\n",
      "72.939856\n",
      "Opp D Mart Mulund Goregaon Link Road Mulund (W) Mumbai,maharashtra,\n",
      "Sapna Electronics\n",
      "\n",
      "dd\n",
      "19.017656\n",
      "72.856047\n",
      "Shop No. 21 Grandeur Mumbai,maharashtra,\n",
      "Kitchen Art\n",
      "\n",
      "dd\n",
      "19.108043\n",
      "72.839134\n",
      "Shop No 7 Arihant Apts Opp Icici Bank Irla Vile Parle (W) Mumbai,maharashtra,\n",
      "Kaybee Appliances & Electronics Pvt\n",
      "\n",
      "dd\n",
      "19.10595\n",
      "72.860887\n",
      "Andheri East Mumbai,maharashtra,\n",
      "Vikas Sales\n",
      "\n",
      "dd\n",
      "19.20975\n",
      "72.873711\n",
      "Thakur Village Kandivali East Mumbai,maharashtra,\n",
      "Satyam Electrovision\n",
      "2240160079\n",
      "dd\n",
      "19.184553\n",
      "72.847403\n",
      "S V Road Malad West Mumbai,maharashtra,\n",
      "Ragesh Electronics\n",
      "2228823686\n",
      "dd\n",
      "19.147709\n",
      "72.997549\n",
      "Airoli Mumbai,maharashtra,\n",
      "Yash Electronics & Home Appliances\n",
      "27037383\n",
      "dd\n",
      "19.15879\n",
      "72.999339\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shree Swami Samarth Complex Shop No 10-11 Airoli Sector 9 Opp Diva Circle Navi Mumbai,maharashtra,\n",
      "Vighnaharata Electronics\n",
      "2227607745 2227607262\n",
      "dd\n",
      "23.073539\n",
      "72.572118\n",
      "Shop No-10 Yash Residence Sec-6 Nr.Bank Of Baroda Airoli Navi Mumbai,maharashtra,\n",
      "Yash Electronics\n",
      "2227693832\n",
      "dd\n",
      "19.072305\n",
      "73.000676\n",
      "27/8 Chadda Crescent Sector-17 Vashi Navi Mumbai,maharashtra,\n",
      "Arcee Electronics\n",
      "2227892357\n",
      "dd\n",
      "19.144476\n",
      "72.994009\n",
      "Shop No.03 Yash Paradise Sec-8A Plot No-4/5 & 6 Airoli Navi Mumabi,maharashtra,\n",
      "Meera Electronics\n",
      "9322646144\n",
      "dd\n",
      "26.13324\n",
      "91.806348\n",
      "Shop No-17/23/29 Sec-7 Shopping Center Vashi Navi Mumabi,maharashtra,\n",
      "Om Sai Electronics\n",
      "9324191988\n",
      "dd\n",
      "19.125021\n",
      "73.010208\n",
      "Thane- Belapur Road Navi Mumbai,maharashtra,\n",
      "Reliance Digital Retail Limited\n",
      "2244771628\n",
      "dd\n",
      "19.108137\n",
      "73.004995\n",
      "24/25/26 Sector-2 Koper Khairane Navi Mumbai,maharashtra,\n",
      "Nanda Electronics\n",
      "022-27542794\n",
      "dd\n",
      "19.015288\n",
      "73.090234\n",
      "Shree Krishna Palace Bldg Plot No-3 Shop No-5 Sec-16 Kamothe Navi Mumbai,maharashtra,\n",
      "Matrix Electronics & Mobile Gallary\n",
      "022-65211622\n",
      "dd\n",
      "19.048187\n",
      "73.069697\n",
      "Shop No-56/57 Chaturbhuj Chs Plot No-61/62 Sec-21 Shilp Chowk Near Icici Bank Kharghar Navi Mumbai,maharashtra,\n",
      "Laxmi Plaza\n",
      "022-65280880\n",
      "dd\n",
      "19.066425\n",
      "72.999101\n",
      "Tech Park Ground Floor Sector-30A Vashi Navi Mumbai,maharashtra,\n",
      "Top Ten Electronics Shoppee Nx\n",
      "2278102067\n",
      "dd\n",
      "19.1002\n",
      "72.908966\n",
      "Vimla Sadan Shop Shop No 1 Opp Phulora Hsg Society Powai,maharashtra,\n",
      "Maharashtra Electronics\n",
      "2225780271\n",
      "dd\n",
      "19.12138\n",
      "72.8895\n",
      "Saki Vihar Road Powai,maharashtra,\n",
      "Malaika Appliances Pvt. Ltd\n",
      "2228575665\n",
      "dd\n",
      "18.650408\n",
      "73.78277\n",
      "Akurdi-Landmark Main Road Pune,maharashtra,\n",
      "Deep Electronics\n",
      "9011063789 020-32522689\n",
      "dd\n",
      "18.62335\n",
      "73.850853\n",
      "201/10 Block Alandi Bhosri Road Pune Bhosri-Landmark : Bihand Pmt Stop Pune,maharashtra,\n",
      "Fancy Electronics\n",
      "9011088039 2027122147\n",
      "dd\n",
      "18.496459\n",
      "73.943687\n",
      "Saswad Road Hadapsar Pune,maharashtra,\n",
      "Triveni Electronics\n",
      "9422003865 2024490178\n",
      "dd\n",
      "18.474599\n",
      "73.822125\n",
      "Singhad Rd Manikbag Pune,maharashtra,\n",
      "Pawan Electronics\n",
      "9545251682 2024350474\n",
      "dd\n",
      "18.633385\n",
      "73.786585\n",
      "Chapekar Chowk Chinchwad Pune,maharashtra,\n",
      "Shri Siddhivinayak Ent\n",
      "9766317719\n",
      "dd\n",
      "18.502412\n",
      "73.815724\n",
      "Karve Road Karveputla Kothrud-Landmark : Opp Karve Putla Pune,maharashtra,\n",
      "Godawari Sales\n",
      "9822032132 2025391490\n",
      "dd\n",
      "22.293804\n",
      "70.802309\n",
      "Hutatmachowk-Landmark : Nagar Parishad Building Pune,maharashtra,\n",
      "Super Electronics\n",
      "9822187602 2117262287\n",
      "dd\n",
      "18.620515\n",
      "73.80157\n",
      "Pimpri Shagun Chowk Pune,maharashtra,\n",
      "Maa Sharda Enterprises\n",
      "9822211249\n",
      "dd\n",
      "18.519835\n",
      "73.845594\n",
      "Warje Pune,maharashtra,\n",
      "Sai Kitchen\n",
      "9822330277\n",
      "dd\n",
      "18.510093\n",
      "73.846566\n",
      "Tilak Road Sadashivpeth Pune,maharashtra,\n",
      "Maharashtra Electronics Corporation\n",
      "9822879991 2024334959\n",
      "dd\n",
      "18.511891\n",
      "73.844201\n",
      "1549 B Sadashivpeth-Landmark : Indira Chambers Pune,maharashtra,\n",
      "Vividh Lahari\n",
      "9823039040 2024335899\n",
      "dd\n",
      "18.449809\n",
      "73.858026\n",
      "Katraj Pune,maharashtra,\n",
      "Mahavir Electronics\n",
      "9850068889\n",
      "dd\n",
      "18.505924\n",
      "73.928027\n",
      "Magarpatta Hadapsar Pune,maharashtra,\n",
      "Kitchen Magic\n",
      "9850488284\n",
      "dd\n",
      "18.478871\n",
      "73.862054\n",
      "Bibvevadi Road Bibvevadi Pune,maharashtra,\n",
      "Mahavir Electronics & Furniture\n",
      "9860911777 2024210909\n",
      "dd\n",
      "18.639961\n",
      "73.794418\n",
      "Pune Mumbai Road Khinchwad Station Pune,maharashtra,\n",
      "R K Music Centre\n",
      "9881040140 202745031\n",
      "dd\n",
      "18.552384\n",
      "73.889331\n",
      "7/8 Air Port Road Vishratwadi Pune,maharashtra,\n",
      "M K Electronics\n",
      "9881123211 2026688448\n",
      "dd\n",
      "18.621467\n",
      "73.802299\n",
      "Arya Samaj Arya Samaj Bhavan Pimpri Pune,maharashtra,\n",
      "Radhika Sales Corporation\n",
      "9881123390 2027416498\n",
      "dd\n",
      "18.567387\n",
      "73.850526\n",
      "38 Shoppo New Bazar Khadki Landmark : Parfkha Jewellery Pune,maharashtra,\n",
      "Modern Electronics & Appliances\n",
      "9881123395 2025817380\n",
      "dd\n",
      "18.514587\n",
      "73.845521\n",
      "217 Narayanpeth Landmark : Nr Universal Booksta Pune,maharashtra,\n",
      "Vinny Electronics\n",
      "9881123491 2024450144\n",
      "dd\n",
      "18.610333\n",
      "73.789137\n",
      "5 Arya Samaj Pimpri Pune Landmark : Arya Samaj Pune,maharashtra,\n",
      "Priya Associates\n",
      "9881123496 020-27416006\n",
      "dd\n",
      "18.503855\n",
      "73.807739\n",
      "88/20 Kothrud Gujrat Company Gurraj Colony Landmark : Suthar Hospital Pune,maharashtra,\n",
      "Keyour\n",
      "9881123520 2025390217\n",
      "dd\n",
      "18.505337\n",
      "73.882928\n",
      "Pune Solapur Road Hadpsar Landmark : Naya Electronic Pune,maharashtra,\n",
      "Pravin Furniture & Elctronics\n",
      "9881123726 2026878262\n",
      "dd\n",
      "18.64223\n",
      "73.791749\n",
      "5 Cm Chambars New Sangui Landmark : Krishna Chowk Pune,maharashtra,\n",
      "Plug N Play\n",
      "9890048505 2027280304\n",
      "dd\n",
      "18.518291\n",
      "73.859446\n",
      "765 Phadke Haud Chowk Budhawar Peth Pune,maharashtra,\n",
      "Saket Electronics\n",
      "9890095050 2024430771\n",
      "dd\n",
      "18.501471\n",
      "73.813782\n",
      "1/1B Karve Rroad Laukit Ap Kothrud Landmark : Near Shivaji Statue Pune,maharashtra,\n",
      "Memorex Home Appliances\n",
      "9922936203 2025380942\n",
      "dd\n",
      "18.661381\n",
      "73.794213\n",
      "Chikli Pune,maharashtra,\n",
      "Modern Electronics.\n",
      "9922936304\n",
      "dd\n",
      "18.510456\n",
      "73.878723\n",
      "Mg Road Camp Pune,maharashtra,\n",
      "Hans Electronics\n",
      "9922967765\n",
      "dd\n",
      "18.468398\n",
      "73.819686\n",
      "Fun Time Multiplex Singhgarh Rd. Pune,maharashtra,\n",
      "Vidya Sales\n",
      "9960292764\n",
      "dd\n",
      "18.461389\n",
      "73.813046\n",
      "Sinhagadh Road Vadgaon Budruk Pune,maharashtra,India\n",
      "Bhawani Electrical & Electronics\n",
      "\n",
      "dd\n",
      "18.480443\n",
      "73.805059\n",
      "13/15 Flybridde Warje Mawad Pune Akshaya Palace Landmark : Fly Over Pune,maharashtra,\n",
      "D P Kolte Sales Corporation\n",
      "25234066 2025233448\n",
      "dd\n",
      "18.514353\n",
      "73.851803\n",
      "601 Laxmi Road Sadashiv Peth Landmark : Kunte Chowk Pune,maharashtra,\n",
      "Jogdeo & Company\n",
      "9822052447 2024455065\n",
      "dd\n",
      "18.49266\n",
      "73.815158\n",
      "122 Karve Nagar Opp Vadacha Bus Stop Karve Nagar-Landmark : Vandevi Mandi Pune,maharashtra,\n",
      "Sidharth Electronics\n",
      "9822993774\n",
      "dd\n",
      "18.553302\n",
      "73.885138\n",
      "Shop 6 Golf Club Road Bund Garden-Yerwada Landmark : Near Gunjan Theatre Pune,maharashtra,\n",
      "Gokul Electricals\n",
      "98811123523 2026612035\n",
      "dd\n",
      "17.677469\n",
      "75.903081\n",
      "Bibevadi Kondva Road Market Yard-Landmark : Gaganviharm Pune,maharashtra,\n",
      "Arihant Electronics\n",
      "9881123246 2024245432\n",
      "dd\n",
      "18.519165\n",
      "73.862076\n",
      "1481 Daruwala Pool Road Kasba Peth Landmark : Opp-Rajesh Trading Pune,maharashtra,\n",
      "Variety Electronics\n",
      "9881123295\n",
      "dd\n",
      "18.479544\n",
      "73.824411\n",
      "Sinhgad Road Hingane Khurd Landmark : Neelay Complex Pune,maharashtra,\n",
      "Shiba Electronics\n",
      "9881123409 020-24349242\n",
      "dd\n",
      "18.520293\n",
      "73.857488\n",
      "88/5 Kankeshwar Sooi Kutp Road Ajad Nagar-Landmark : Opp Bhazima,maharashtra,\n",
      "Gayatri Electronics\n",
      "9881123416 2025381158\n",
      "dd\n",
      "18.515913\n",
      "73.842636\n",
      "Main Road Gymkhana Deccan Gymkhana Landmark : Deccan Cus Stand Pune,maharashtra,\n",
      "Agents Corner\n",
      "9881123815\n",
      "dd\n",
      "18.478871\n",
      "73.862054\n",
      "217-220 Karve Road Sobashilp Kothrud Landmark : Near Shivaji Statue Pune,maharashtra,\n",
      "Mahavir Electronics & Furniture\n",
      "9890146046 2025388171\n",
      "dd\n",
      "18.648794\n",
      "72.875099\n",
      "Sneha Apartment Near St Stand Opp Icici Bank Alibaug Raigad,maharashtra,\n",
      "Evergreen Electronics\n",
      "2141222352\n",
      "dd\n",
      "18.991662\n",
      "73.113573\n",
      "2 Amit Apts Shivaji Rd Opp S.T.Stand Panvel Raigad,maharashtra,\n",
      "Modern Enterprises\n",
      "022-27461138\n",
      "dd\n",
      "19.002571\n",
      "73.11711\n",
      "Shop No-12-13 Kalpatru Arcade Sec-4 New Panvel Raigad,maharashtra,\n",
      "My Kitchen Home Appliance\n",
      "022-27483270\n",
      "dd\n",
      "18.856368\n",
      "73.88136\n",
      "Wada Road Rajguru Nagar,maharashtra,\n",
      "Jayhind Electricals\n",
      "9881176055 2135222846\n",
      "dd\n",
      "18.826497\n",
      "74.376461\n",
      "Shubhash Bazar Chowk Shubhash Chowk Landmark : Mmk Late Ali Shirur,maharashtra,\n",
      "Darda Agencys\n",
      "9890464591 2138222640\n",
      "dd\n",
      "17.677469\n",
      "75.903081\n",
      "Durga Devi Mandir Road Sai Nagar Landmark : Durgadevi Mandir Bhigwan Solapur,maharashtra,\n",
      "Arihant Electronics\n",
      "9922822422 2118-246409\n",
      "dd\n",
      "18.721229\n",
      "73.686425\n",
      "601 Raviwar Peth Main Bazar Raviwar Peth-Landmark : Jain Mandir Talegaon Dabhade,maharashtra,\n",
      "Sursangam Electronics\n",
      "9822129909 2114222025\n",
      "dd\n",
      "19.060221\n",
      "72.901493\n",
      "Shop No 4 & 14 Savla Sadan R. C. Marg Next To Flyover Opp Ration Office Near Station Chembur (E) Mumbai,maharashtra,\n",
      "Embassy Electronics\n",
      "2225273060\n",
      "dd\n",
      "19.189232\n",
      "72.97249\n",
      "Ram Maruti Road Shop No 3 Taskar House Near Station Opp Bank Of Baroda Thane (W),maharashtra,\n",
      "Kiran Electronics\n",
      "2225391621\n",
      "dd\n",
      "19.188116\n",
      "72.972386\n",
      "Ram Maruti Road Shop No 2 Near Station Opp Titan Showroom Thane (W),maharashtra,\n",
      "Shree Jain Traders\n",
      "2225403631\n",
      "dd\n",
      "19.800088\n",
      "72.759215\n",
      "Jagdish Enclave Shop No 36 Near St Stand Boisar (W) Palghar Thane,maharashtra,\n",
      "Perfect Electrovision\n",
      "2525266415\n",
      "dd\n",
      "19.697703\n",
      "72.740516\n",
      "Alyali Dhansar Palghar Thane,maharashtra,\n",
      "Ruchit Electronics\n",
      "2525250716\n",
      "dd\n",
      "22.611364\n",
      "77.769028\n",
      "Yashoda Smruti Near Bank Of India B.P. Road Bhayandar (E) Thane,maharashtra,\n",
      "Anant Electronics\n",
      "022-28046702\n",
      "dd\n",
      "19.696813\n",
      "72.770266\n",
      "11 Pushpanjanli Enterprises Opp Ram Mandir Panchathi Mahim Road Palghar Thane,maharashtra,\n",
      "Om Parshwanath Electronics\n",
      "022-28904186\n",
      "dd\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "19.419394\n",
      "72.819987\n",
      "14 Sitaram Bhavan Achole Talati Road Near Railway Station Nalasopara (E) Thane,maharashtra,\n",
      "Mascot Refrigeration\n",
      "0250-2430235 9320538818\n",
      "dd\n",
      "19.27512\n",
      "73.059721\n",
      "Ovali Gaon Bhiwandi Thane,maharashtra,\n",
      "Jumbo Distributors Pvt. Ltd\n",
      "02522-296083\n",
      "dd\n",
      "19.218331\n",
      "72.97809\n",
      "Jalaram Nagar Sagar Naka Dahanu Thane,maharashtra,\n",
      "Ichha Electronics\n",
      "02528-224120\n",
      "dd\n",
      "19.419595\n",
      "72.80826\n",
      "Khodiyal Apts Nallasopara(W) Thane,maharashtra,\n",
      "Gaurav Elelctronics\n",
      "68200000000000 9029304300\n",
      "dd\n",
      "19.226661\n",
      "72.983837\n",
      "Thane West Thane,maharashtra,\n",
      "See Kitchen\n",
      "\n",
      "dd\n",
      "19.378086\n",
      "72.827154\n",
      "Shop No 1 2 & 3 Nirmal Apts Station Road Navghar Vasai,maharashtra,\n",
      "Rana Electronics & Appliances\n",
      "2502342324\n",
      "dd\n",
      "19.379345\n",
      "72.828641\n",
      "Shop No 5 & 6 Panchal Nagar Near K.T Cinema Vasai (W,maharashtra,\n",
      "Shree Lord'S Electronics\n",
      "95250-2348056\n",
      "dd\n",
      "19.4471\n",
      "72.819287\n",
      "Vivah Dhavalgiri Opp More Manvay Pada Road Virar (W),maharashtra,\n",
      "Vikas Enterprises\n",
      "2502828247\n",
      "dd\n",
      "19.454766\n",
      "72.811375\n",
      "Ground Floor Bldg No 1 Near Station Virar (W),maharashtra,\n",
      "Viva Supermarket Pvt. Ltd.\n",
      "2512508363\n",
      "dd\n",
      "22.801768\n",
      "86.205155\n",
      "Virar West Virar,maharashtra,\n",
      "National Electronics\n",
      "2502505956\n",
      "dd\n"
     ]
    }
   ],
   "source": [
    "i=0\n",
    "latitude=[]\n",
    "longitude=[]\n",
    "address=[]\n",
    "contact=[]\n",
    "name=[]\n",
    "while i<len(urls):\n",
    "    url=urls[i]\n",
    "    url=url[:30]+\"storelocator/\"+url[30:]\n",
    "    driver.get(url)\n",
    "    elem=driver.find_element_by_id('latitude')\n",
    "    latitude.append(elem.get_attribute('value'))\n",
    "    print(elem.get_attribute('value'))\n",
    "    elem=driver.find_element_by_id('longitude')\n",
    "    longitude.append(elem.get_attribute('value'))\n",
    "    print(elem.get_attribute('value'))\n",
    "    elem=driver.find_element_by_class_name('each-store-address')\n",
    "    address.append(elem.text)\n",
    "    print(elem.text)\n",
    "    elem=driver.find_element_by_class_name('each-store-name')\n",
    "    name.append(elem.text)\n",
    "    print(elem.text)\n",
    "    elem=driver.find_element_by_class_name('wd50').text\n",
    "    print(elem)\n",
    "    contact.append(elem)\n",
    "    print(\"dd\")\n",
    "    i+=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {},
   "outputs": [],
   "source": [
    "ifbpoints=pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "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>Address</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Contact</th>\n",
       "      <th>Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34 Mahavi Rpeth Rd Gandhi Chowk Landmark : Rng...</td>\n",
       "      <td>18.148765</td>\n",
       "      <td>74.571757</td>\n",
       "      <td>9422519034 2112229204</td>\n",
       "      <td>V R Electranics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>D 35 M G Road Lonavla,maharashtra,</td>\n",
       "      <td>18.749871</td>\n",
       "      <td>73.406016</td>\n",
       "      <td>9822653366 2114272466</td>\n",
       "      <td>Suraj Novelties</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Market Road Lonavla,maharashtra,</td>\n",
       "      <td>18.747515</td>\n",
       "      <td>73.408381</td>\n",
       "      <td>9960009786 2114272325</td>\n",
       "      <td>Khozema Traders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dadar Shopping Complex Dadar West Mumbai,mahar...</td>\n",
       "      <td>19.018291</td>\n",
       "      <td>72.840944</td>\n",
       "      <td>24224060</td>\n",
       "      <td>Gemini Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>St Bus Depot Gokhale Road Prabhadevi Mumbai,ma...</td>\n",
       "      <td>19.012259</td>\n",
       "      <td>72.833138</td>\n",
       "      <td>222905247</td>\n",
       "      <td>Hreenkar Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Shop No 4 &amp; 14 Savla Sadan R. C. Marg Opp Rati...</td>\n",
       "      <td>19.05026</td>\n",
       "      <td>72.89375</td>\n",
       "      <td>225281989</td>\n",
       "      <td>Anil Audio Video Distributors Pvt. Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Shree Yash Plaza Gr.Floor M.G.Road Near Lic Of...</td>\n",
       "      <td>19.238031</td>\n",
       "      <td>72.859472</td>\n",
       "      <td>2143257469</td>\n",
       "      <td>Shreeyog Distributors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Canravarkar Lane Borivali West Mumbai,maharash...</td>\n",
       "      <td>19.230564</td>\n",
       "      <td>72.856484</td>\n",
       "      <td>2220585858</td>\n",
       "      <td>Omega Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>14 Kailash Mahal Bldg Opp Odeon Mumbai,maharas...</td>\n",
       "      <td>19.078952</td>\n",
       "      <td>72.908707</td>\n",
       "      <td>2221024335</td>\n",
       "      <td>Mayur Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Opp Natraj Market S V Rd Malad West Mumbai,mah...</td>\n",
       "      <td>19.187168</td>\n",
       "      <td>72.840766</td>\n",
       "      <td>2222908615</td>\n",
       "      <td>Gala &amp; Sons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Near Tbz Opera House Mumbai,maharashtra,</td>\n",
       "      <td>18.953498</td>\n",
       "      <td>72.816821</td>\n",
       "      <td>2223631038</td>\n",
       "      <td>Panavision Televideo Pvt. Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Opera House Charni Road Mumbai,maharashtra,</td>\n",
       "      <td>18.954698</td>\n",
       "      <td>72.816214</td>\n",
       "      <td>2223681955</td>\n",
       "      <td>Globe Radios</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>City Cinema Road Mahim Mumbai,maharashtra,</td>\n",
       "      <td>19.029837</td>\n",
       "      <td>72.841416</td>\n",
       "      <td>2224466105</td>\n",
       "      <td>Maharashtra Radio &amp; Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Near Church Station Road Mahim West Mumbai,mah...</td>\n",
       "      <td>18.98967</td>\n",
       "      <td>72.835558</td>\n",
       "      <td>2224475968</td>\n",
       "      <td>Elite Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Shop No 10 Atul Park Sion Trombay Road Chembur...</td>\n",
       "      <td>19.050478</td>\n",
       "      <td>72.904815</td>\n",
       "      <td>2225203056</td>\n",
       "      <td>Ethos Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Shop No. 19 Sundar Apts Sion Trombay Road Opp ...</td>\n",
       "      <td>19.052097</td>\n",
       "      <td>72.900183</td>\n",
       "      <td>2225223842</td>\n",
       "      <td>Royal Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Shop No. 3 Sundar Apts Sion Trombay Road Opp D...</td>\n",
       "      <td>19.052199</td>\n",
       "      <td>72.899683</td>\n",
       "      <td>2225224219 98200330725</td>\n",
       "      <td>Royal Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Shop No 3 Amar Mahal Chembur (W) Mumbai,mahara...</td>\n",
       "      <td>19.068119</td>\n",
       "      <td>72.90103</td>\n",
       "      <td>2225242202</td>\n",
       "      <td>Sahakar Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Station Road Thane (W),maharashtra,</td>\n",
       "      <td>19.189411</td>\n",
       "      <td>72.976161</td>\n",
       "      <td>2225476757</td>\n",
       "      <td>Kirti Radio &amp; Television Centre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Pannalal Compund L.B.S Marg Bhandup (W) Mumbai...</td>\n",
       "      <td>19.155171</td>\n",
       "      <td>72.937183</td>\n",
       "      <td>2225916666</td>\n",
       "      <td>New Shah Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Shyam Kamal Society Near Parle Internationla H...</td>\n",
       "      <td>19.099991</td>\n",
       "      <td>72.845289</td>\n",
       "      <td>2226131967</td>\n",
       "      <td>Mansukh Distributors Pvt Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Ayub Khan Compound Irla Vile Parle (W) Mumbai,...</td>\n",
       "      <td>19.108305</td>\n",
       "      <td>72.839365</td>\n",
       "      <td>2226719696</td>\n",
       "      <td>Alfa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Near Seawood Rly. Station Nerul Mumbai,maharas...</td>\n",
       "      <td>19.018881</td>\n",
       "      <td>73.017282</td>\n",
       "      <td>2227723632</td>\n",
       "      <td>Max Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Near Cine Max S V Rd Goregaon West Mumbai,maha...</td>\n",
       "      <td>19.156844</td>\n",
       "      <td>72.845653</td>\n",
       "      <td>2228778640</td>\n",
       "      <td>Rahul Electronics &amp; Appliances</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Holy Cross Road Boriwali West Mumbai,maharashtra,</td>\n",
       "      <td>19.249153</td>\n",
       "      <td>72.850007</td>\n",
       "      <td>2228922020</td>\n",
       "      <td>J.P. Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Shop No 70 &amp; 71 Plot No 26 Shelter Arcade Sect...</td>\n",
       "      <td>23.366339</td>\n",
       "      <td>85.324308</td>\n",
       "      <td>2232981199</td>\n",
       "      <td>Electronics World</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Raju Pote Marg Mumbai,maharashtra,</td>\n",
       "      <td>19.017604</td>\n",
       "      <td>72.856062</td>\n",
       "      <td>9028377069</td>\n",
       "      <td>Meera Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Shop No.4 Olive Excel Chs Plot 16 Sec-42 Seawo...</td>\n",
       "      <td>19.024786</td>\n",
       "      <td>73.022088</td>\n",
       "      <td>9324343766</td>\n",
       "      <td>Warsi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>S V Rd Goregaon West Mumbai,maharashtra,</td>\n",
       "      <td>19.163761</td>\n",
       "      <td>72.846024</td>\n",
       "      <td>9820042315</td>\n",
       "      <td>Rahi Electronics Pvt. Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Dadasaheb Pandit Market Saphale East Mumbai,ma...</td>\n",
       "      <td>19.579919</td>\n",
       "      <td>72.831687</td>\n",
       "      <td>95250230204</td>\n",
       "      <td>Sapna Electric &amp; Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Bibevadi Kondva Road Market Yard-Landmark : Ga...</td>\n",
       "      <td>17.677469</td>\n",
       "      <td>75.903081</td>\n",
       "      <td>9881123246 2024245432</td>\n",
       "      <td>Arihant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>1481 Daruwala Pool Road Kasba Peth Landmark : ...</td>\n",
       "      <td>18.519165</td>\n",
       "      <td>73.862076</td>\n",
       "      <td>9881123295</td>\n",
       "      <td>Variety Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Sinhgad Road Hingane Khurd Landmark : Neelay C...</td>\n",
       "      <td>18.479544</td>\n",
       "      <td>73.824411</td>\n",
       "      <td>9881123409 020-24349242</td>\n",
       "      <td>Shiba Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>88/5 Kankeshwar Sooi Kutp Road Ajad Nagar-Land...</td>\n",
       "      <td>18.520293</td>\n",
       "      <td>73.857488</td>\n",
       "      <td>9881123416 2025381158</td>\n",
       "      <td>Gayatri Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>Main Road Gymkhana Deccan Gymkhana Landmark : ...</td>\n",
       "      <td>18.515913</td>\n",
       "      <td>73.842636</td>\n",
       "      <td>9881123815</td>\n",
       "      <td>Agents Corner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>217-220 Karve Road Sobashilp Kothrud Landmark ...</td>\n",
       "      <td>18.478871</td>\n",
       "      <td>73.862054</td>\n",
       "      <td>9890146046 2025388171</td>\n",
       "      <td>Mahavir Electronics &amp; Furniture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Sneha Apartment Near St Stand Opp Icici Bank A...</td>\n",
       "      <td>18.648794</td>\n",
       "      <td>72.875099</td>\n",
       "      <td>2141222352</td>\n",
       "      <td>Evergreen Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2 Amit Apts Shivaji Rd Opp S.T.Stand Panvel Ra...</td>\n",
       "      <td>18.991662</td>\n",
       "      <td>73.113573</td>\n",
       "      <td>022-27461138</td>\n",
       "      <td>Modern Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Shop No-12-13 Kalpatru Arcade Sec-4 New Panvel...</td>\n",
       "      <td>19.002571</td>\n",
       "      <td>73.11711</td>\n",
       "      <td>022-27483270</td>\n",
       "      <td>My Kitchen Home Appliance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Wada Road Rajguru Nagar,maharashtra,</td>\n",
       "      <td>18.856368</td>\n",
       "      <td>73.88136</td>\n",
       "      <td>9881176055 2135222846</td>\n",
       "      <td>Jayhind Electricals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Shubhash Bazar Chowk Shubhash Chowk Landmark :...</td>\n",
       "      <td>18.826497</td>\n",
       "      <td>74.376461</td>\n",
       "      <td>9890464591 2138222640</td>\n",
       "      <td>Darda Agencys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>Durga Devi Mandir Road Sai Nagar Landmark : Du...</td>\n",
       "      <td>17.677469</td>\n",
       "      <td>75.903081</td>\n",
       "      <td>9922822422 2118-246409</td>\n",
       "      <td>Arihant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>601 Raviwar Peth Main Bazar Raviwar Peth-Landm...</td>\n",
       "      <td>18.721229</td>\n",
       "      <td>73.686425</td>\n",
       "      <td>9822129909 2114222025</td>\n",
       "      <td>Sursangam Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Shop No 4 &amp; 14 Savla Sadan R. C. Marg Next To ...</td>\n",
       "      <td>19.060221</td>\n",
       "      <td>72.901493</td>\n",
       "      <td>2225273060</td>\n",
       "      <td>Embassy Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Ram Maruti Road Shop No 3 Taskar House Near St...</td>\n",
       "      <td>19.189232</td>\n",
       "      <td>72.97249</td>\n",
       "      <td>2225391621</td>\n",
       "      <td>Kiran Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>Ram Maruti Road Shop No 2 Near Station Opp Tit...</td>\n",
       "      <td>19.188116</td>\n",
       "      <td>72.972386</td>\n",
       "      <td>2225403631</td>\n",
       "      <td>Shree Jain Traders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>Jagdish Enclave Shop No 36 Near St Stand Boisa...</td>\n",
       "      <td>19.800088</td>\n",
       "      <td>72.759215</td>\n",
       "      <td>2525266415</td>\n",
       "      <td>Perfect Electrovision</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Alyali Dhansar Palghar Thane,maharashtra,</td>\n",
       "      <td>19.697703</td>\n",
       "      <td>72.740516</td>\n",
       "      <td>2525250716</td>\n",
       "      <td>Ruchit Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Yashoda Smruti Near Bank Of India B.P. Road Bh...</td>\n",
       "      <td>22.611364</td>\n",
       "      <td>77.769028</td>\n",
       "      <td>022-28046702</td>\n",
       "      <td>Anant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>11 Pushpanjanli Enterprises Opp Ram Mandir Pan...</td>\n",
       "      <td>19.696813</td>\n",
       "      <td>72.770266</td>\n",
       "      <td>022-28904186</td>\n",
       "      <td>Om Parshwanath Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>14 Sitaram Bhavan Achole Talati Road Near Rail...</td>\n",
       "      <td>19.419394</td>\n",
       "      <td>72.819987</td>\n",
       "      <td>0250-2430235 9320538818</td>\n",
       "      <td>Mascot Refrigeration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>Ovali Gaon Bhiwandi Thane,maharashtra,</td>\n",
       "      <td>19.27512</td>\n",
       "      <td>73.059721</td>\n",
       "      <td>02522-296083</td>\n",
       "      <td>Jumbo Distributors Pvt. Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Jalaram Nagar Sagar Naka Dahanu Thane,maharash...</td>\n",
       "      <td>19.218331</td>\n",
       "      <td>72.97809</td>\n",
       "      <td>02528-224120</td>\n",
       "      <td>Ichha Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Khodiyal Apts Nallasopara(W) Thane,maharashtra,</td>\n",
       "      <td>19.419595</td>\n",
       "      <td>72.80826</td>\n",
       "      <td>68200000000000 9029304300</td>\n",
       "      <td>Gaurav Elelctronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>Thane West Thane,maharashtra,</td>\n",
       "      <td>19.226661</td>\n",
       "      <td>72.983837</td>\n",
       "      <td></td>\n",
       "      <td>See Kitchen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Shop No 1 2 &amp; 3 Nirmal Apts Station Road Navgh...</td>\n",
       "      <td>19.378086</td>\n",
       "      <td>72.827154</td>\n",
       "      <td>2502342324</td>\n",
       "      <td>Rana Electronics &amp; Appliances</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>Shop No 5 &amp; 6 Panchal Nagar Near K.T Cinema Va...</td>\n",
       "      <td>19.379345</td>\n",
       "      <td>72.828641</td>\n",
       "      <td>95250-2348056</td>\n",
       "      <td>Shree Lord'S Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Vivah Dhavalgiri Opp More Manvay Pada Road Vir...</td>\n",
       "      <td>19.4471</td>\n",
       "      <td>72.819287</td>\n",
       "      <td>2502828247</td>\n",
       "      <td>Vikas Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Ground Floor Bldg No 1 Near Station Virar (W),...</td>\n",
       "      <td>19.454766</td>\n",
       "      <td>72.811375</td>\n",
       "      <td>2512508363</td>\n",
       "      <td>Viva Supermarket Pvt. Ltd.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Virar West Virar,maharashtra,</td>\n",
       "      <td>22.801768</td>\n",
       "      <td>86.205155</td>\n",
       "      <td>2502505956</td>\n",
       "      <td>National Electronics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>149 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Address   Latitude  Longitude  \\\n",
       "0    34 Mahavi Rpeth Rd Gandhi Chowk Landmark : Rng...  18.148765  74.571757   \n",
       "1                   D 35 M G Road Lonavla,maharashtra,  18.749871  73.406016   \n",
       "2                     Market Road Lonavla,maharashtra,  18.747515  73.408381   \n",
       "3    Dadar Shopping Complex Dadar West Mumbai,mahar...  19.018291  72.840944   \n",
       "4    St Bus Depot Gokhale Road Prabhadevi Mumbai,ma...  19.012259  72.833138   \n",
       "5    Shop No 4 & 14 Savla Sadan R. C. Marg Opp Rati...   19.05026   72.89375   \n",
       "6    Shree Yash Plaza Gr.Floor M.G.Road Near Lic Of...  19.238031  72.859472   \n",
       "7    Canravarkar Lane Borivali West Mumbai,maharash...  19.230564  72.856484   \n",
       "8    14 Kailash Mahal Bldg Opp Odeon Mumbai,maharas...  19.078952  72.908707   \n",
       "9    Opp Natraj Market S V Rd Malad West Mumbai,mah...  19.187168  72.840766   \n",
       "10            Near Tbz Opera House Mumbai,maharashtra,  18.953498  72.816821   \n",
       "11         Opera House Charni Road Mumbai,maharashtra,  18.954698  72.816214   \n",
       "12          City Cinema Road Mahim Mumbai,maharashtra,  19.029837  72.841416   \n",
       "13   Near Church Station Road Mahim West Mumbai,mah...   18.98967  72.835558   \n",
       "14   Shop No 10 Atul Park Sion Trombay Road Chembur...  19.050478  72.904815   \n",
       "15   Shop No. 19 Sundar Apts Sion Trombay Road Opp ...  19.052097  72.900183   \n",
       "16   Shop No. 3 Sundar Apts Sion Trombay Road Opp D...  19.052199  72.899683   \n",
       "17   Shop No 3 Amar Mahal Chembur (W) Mumbai,mahara...  19.068119   72.90103   \n",
       "18                 Station Road Thane (W),maharashtra,  19.189411  72.976161   \n",
       "19   Pannalal Compund L.B.S Marg Bhandup (W) Mumbai...  19.155171  72.937183   \n",
       "20   Shyam Kamal Society Near Parle Internationla H...  19.099991  72.845289   \n",
       "21   Ayub Khan Compound Irla Vile Parle (W) Mumbai,...  19.108305  72.839365   \n",
       "22   Near Seawood Rly. Station Nerul Mumbai,maharas...  19.018881  73.017282   \n",
       "23   Near Cine Max S V Rd Goregaon West Mumbai,maha...  19.156844  72.845653   \n",
       "24   Holy Cross Road Boriwali West Mumbai,maharashtra,  19.249153  72.850007   \n",
       "25   Shop No 70 & 71 Plot No 26 Shelter Arcade Sect...  23.366339  85.324308   \n",
       "26                  Raju Pote Marg Mumbai,maharashtra,  19.017604  72.856062   \n",
       "27   Shop No.4 Olive Excel Chs Plot 16 Sec-42 Seawo...  19.024786  73.022088   \n",
       "28            S V Rd Goregaon West Mumbai,maharashtra,  19.163761  72.846024   \n",
       "29   Dadasaheb Pandit Market Saphale East Mumbai,ma...  19.579919  72.831687   \n",
       "..                                                 ...        ...        ...   \n",
       "119  Bibevadi Kondva Road Market Yard-Landmark : Ga...  17.677469  75.903081   \n",
       "120  1481 Daruwala Pool Road Kasba Peth Landmark : ...  18.519165  73.862076   \n",
       "121  Sinhgad Road Hingane Khurd Landmark : Neelay C...  18.479544  73.824411   \n",
       "122  88/5 Kankeshwar Sooi Kutp Road Ajad Nagar-Land...  18.520293  73.857488   \n",
       "123  Main Road Gymkhana Deccan Gymkhana Landmark : ...  18.515913  73.842636   \n",
       "124  217-220 Karve Road Sobashilp Kothrud Landmark ...  18.478871  73.862054   \n",
       "125  Sneha Apartment Near St Stand Opp Icici Bank A...  18.648794  72.875099   \n",
       "126  2 Amit Apts Shivaji Rd Opp S.T.Stand Panvel Ra...  18.991662  73.113573   \n",
       "127  Shop No-12-13 Kalpatru Arcade Sec-4 New Panvel...  19.002571   73.11711   \n",
       "128               Wada Road Rajguru Nagar,maharashtra,  18.856368   73.88136   \n",
       "129  Shubhash Bazar Chowk Shubhash Chowk Landmark :...  18.826497  74.376461   \n",
       "130  Durga Devi Mandir Road Sai Nagar Landmark : Du...  17.677469  75.903081   \n",
       "131  601 Raviwar Peth Main Bazar Raviwar Peth-Landm...  18.721229  73.686425   \n",
       "132  Shop No 4 & 14 Savla Sadan R. C. Marg Next To ...  19.060221  72.901493   \n",
       "133  Ram Maruti Road Shop No 3 Taskar House Near St...  19.189232   72.97249   \n",
       "134  Ram Maruti Road Shop No 2 Near Station Opp Tit...  19.188116  72.972386   \n",
       "135  Jagdish Enclave Shop No 36 Near St Stand Boisa...  19.800088  72.759215   \n",
       "136          Alyali Dhansar Palghar Thane,maharashtra,  19.697703  72.740516   \n",
       "137  Yashoda Smruti Near Bank Of India B.P. Road Bh...  22.611364  77.769028   \n",
       "138  11 Pushpanjanli Enterprises Opp Ram Mandir Pan...  19.696813  72.770266   \n",
       "139  14 Sitaram Bhavan Achole Talati Road Near Rail...  19.419394  72.819987   \n",
       "140             Ovali Gaon Bhiwandi Thane,maharashtra,   19.27512  73.059721   \n",
       "141  Jalaram Nagar Sagar Naka Dahanu Thane,maharash...  19.218331   72.97809   \n",
       "142    Khodiyal Apts Nallasopara(W) Thane,maharashtra,  19.419595   72.80826   \n",
       "143                      Thane West Thane,maharashtra,  19.226661  72.983837   \n",
       "144  Shop No 1 2 & 3 Nirmal Apts Station Road Navgh...  19.378086  72.827154   \n",
       "145  Shop No 5 & 6 Panchal Nagar Near K.T Cinema Va...  19.379345  72.828641   \n",
       "146  Vivah Dhavalgiri Opp More Manvay Pada Road Vir...    19.4471  72.819287   \n",
       "147  Ground Floor Bldg No 1 Near Station Virar (W),...  19.454766  72.811375   \n",
       "148                      Virar West Virar,maharashtra,  22.801768  86.205155   \n",
       "\n",
       "                       Contact                                    Name  \n",
       "0        9422519034 2112229204                         V R Electranics  \n",
       "1        9822653366 2114272466                         Suraj Novelties  \n",
       "2        9960009786 2114272325                         Khozema Traders  \n",
       "3                     24224060                      Gemini Electronics  \n",
       "4                    222905247                    Hreenkar Electronics  \n",
       "5                    225281989  Anil Audio Video Distributors Pvt. Ltd  \n",
       "6                   2143257469                   Shreeyog Distributors  \n",
       "7                   2220585858                       Omega Electronics  \n",
       "8                   2221024335                       Mayur Electronics  \n",
       "9                   2222908615                             Gala & Sons  \n",
       "10                  2223631038           Panavision Televideo Pvt. Ltd  \n",
       "11                  2223681955                            Globe Radios  \n",
       "12                  2224466105         Maharashtra Radio & Electronics  \n",
       "13                  2224475968                          Elite Services  \n",
       "14                  2225203056                       Ethos Electronics  \n",
       "15                  2225223842                       Royal Enterprises  \n",
       "16      2225224219 98200330725                       Royal Electronics  \n",
       "17                  2225242202                     Sahakar Electronics  \n",
       "18                  2225476757         Kirti Radio & Television Centre  \n",
       "19                  2225916666                    New Shah Enterprises  \n",
       "20                  2226131967            Mansukh Distributors Pvt Ltd  \n",
       "21                  2226719696                                    Alfa  \n",
       "22                  2227723632                         Max Electronics  \n",
       "23                  2228778640          Rahul Electronics & Appliances  \n",
       "24                  2228922020                        J.P. Electronics  \n",
       "25                  2232981199                       Electronics World  \n",
       "26                  9028377069                       Meera Enterprises  \n",
       "27                  9324343766                                   Warsi  \n",
       "28                  9820042315               Rahi Electronics Pvt. Ltd  \n",
       "29                 95250230204            Sapna Electric & Electronics  \n",
       "..                         ...                                     ...  \n",
       "119      9881123246 2024245432                     Arihant Electronics  \n",
       "120                 9881123295                     Variety Electronics  \n",
       "121    9881123409 020-24349242                       Shiba Electronics  \n",
       "122      9881123416 2025381158                     Gayatri Electronics  \n",
       "123                 9881123815                           Agents Corner  \n",
       "124      9890146046 2025388171         Mahavir Electronics & Furniture  \n",
       "125                 2141222352                   Evergreen Electronics  \n",
       "126               022-27461138                      Modern Enterprises  \n",
       "127               022-27483270               My Kitchen Home Appliance  \n",
       "128      9881176055 2135222846                     Jayhind Electricals  \n",
       "129      9890464591 2138222640                           Darda Agencys  \n",
       "130     9922822422 2118-246409                     Arihant Electronics  \n",
       "131      9822129909 2114222025                   Sursangam Electronics  \n",
       "132                 2225273060                     Embassy Electronics  \n",
       "133                 2225391621                       Kiran Electronics  \n",
       "134                 2225403631                      Shree Jain Traders  \n",
       "135                 2525266415                   Perfect Electrovision  \n",
       "136                 2525250716                      Ruchit Electronics  \n",
       "137               022-28046702                       Anant Electronics  \n",
       "138               022-28904186              Om Parshwanath Electronics  \n",
       "139    0250-2430235 9320538818                    Mascot Refrigeration  \n",
       "140               02522-296083             Jumbo Distributors Pvt. Ltd  \n",
       "141               02528-224120                       Ichha Electronics  \n",
       "142  68200000000000 9029304300                     Gaurav Elelctronics  \n",
       "143                                                        See Kitchen  \n",
       "144                 2502342324           Rana Electronics & Appliances  \n",
       "145              95250-2348056                Shree Lord'S Electronics  \n",
       "146                 2502828247                       Vikas Enterprises  \n",
       "147                 2512508363              Viva Supermarket Pvt. Ltd.  \n",
       "148                 2502505956                    National Electronics  \n",
       "\n",
       "[149 rows x 5 columns]"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ifbpoints['Address']=address\n",
    "ifbpoints['Latitude']=latitude\n",
    "ifbpoints['Longitude']=longitude\n",
    "ifbpoints['Contact']=contact\n",
    "ifbpoints['Name']=name\n",
    "ifbpoints"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [],
   "source": [
    "ifbpoints.to_csv('C:/Users/abdenather/Desktop/xelpmoc/ifbdealers_maharashtra.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [],
   "source": [
    "ifb=pd.read_csv('C:/Users/abdenather/Desktop/xelpmoc/ifbpoints_maharashtra.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "ifb=ifb.append(ifbpoints)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "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>Address</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Contact</th>\n",
       "      <th>Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Prasad Agencies, Shop No a/b 10, Gurukul, Oppo...</td>\n",
       "      <td>19.1055</td>\n",
       "      <td>74.7327</td>\n",
       "      <td>9325106465 | 8999776308</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mercury Co-Hsg Society, Plot No: 4, Shop No: 6...</td>\n",
       "      <td>19.1479</td>\n",
       "      <td>72.9981</td>\n",
       "      <td>022 - 27699976 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C/O - Shendge Agencies, Rajmata Ji Gaon Nagar,...</td>\n",
       "      <td>18.7275</td>\n",
       "      <td>76.3</td>\n",
       "      <td>9422243493 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Swaraj Electronics, Shop No: 209, Shilpi Compl...</td>\n",
       "      <td>20.9184</td>\n",
       "      <td>77.7538</td>\n",
       "      <td>07212569424 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Shop No: 2, Sunil Niwas Chsl, Plot No: 89/90, ...</td>\n",
       "      <td>19.1334</td>\n",
       "      <td>72.8256</td>\n",
       "      <td>022-26310208 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>IFB Point, Padmaawati Chowk, Opposite Shivaji ...</td>\n",
       "      <td>20.9941</td>\n",
       "      <td>78.228</td>\n",
       "      <td>9175580154 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Shop No: 3, Ground Floor, Niyoshi Park 3 Chsl,...</td>\n",
       "      <td>18.5609</td>\n",
       "      <td>73.8129</td>\n",
       "      <td>7420056242 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Akanksha Sales &amp; Services, Shop No: 19, Kailas...</td>\n",
       "      <td>19.8772</td>\n",
       "      <td>75.3644</td>\n",
       "      <td>9325666050 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Gut No: 17/5/1, Plot No: 5, Opposite State Ban...</td>\n",
       "      <td>19.8666</td>\n",
       "      <td>75.3546</td>\n",
       "      <td>9823442277 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ifb Point, Pratik Digital World, Bansilal Naga...</td>\n",
       "      <td>19.8635</td>\n",
       "      <td>75.315</td>\n",
       "      <td>9975531333 | 8668221087</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Anand Sales &amp; Services, Juna Nagar Naka, Nagar...</td>\n",
       "      <td>18.9891</td>\n",
       "      <td>75.7554</td>\n",
       "      <td>9422233038 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Shop No: 8, Atur Park Shiv Parvati Co-Op Hsg S...</td>\n",
       "      <td>19.0506</td>\n",
       "      <td>72.9043</td>\n",
       "      <td>022 - 25218174 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Shop No: B6, Gokhale Vrindavan, Near P.N Gadgi...</td>\n",
       "      <td>18.6306</td>\n",
       "      <td>73.7762</td>\n",
       "      <td>02027350123 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Poona E House, Lane No: 5, Nagapatti,maharasht...</td>\n",
       "      <td>20.9051</td>\n",
       "      <td>74.775</td>\n",
       "      <td>0256 - 2234361 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Uday Electronics, Nehru Chowk, Gadhinglaj,maha...</td>\n",
       "      <td>16.225</td>\n",
       "      <td>74.353</td>\n",
       "      <td>02327223332 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Shop No: 3 B, Orion Business Park, Next To Cin...</td>\n",
       "      <td>19.2236</td>\n",
       "      <td>72.9772</td>\n",
       "      <td>8291007487 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>S No: 79/2/1, Shop No: 2/8 &amp; 2/9, Wanowrie, Op...</td>\n",
       "      <td>18.5065</td>\n",
       "      <td>73.9105</td>\n",
       "      <td>7420056227 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Padmavati Prajkta Electronics, Prateek Plaza, ...</td>\n",
       "      <td>16.692</td>\n",
       "      <td>74.453</td>\n",
       "      <td>9860009833 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Deepali Mobiles, 32, Visanji Nagar, Opposite K...</td>\n",
       "      <td>21.0127</td>\n",
       "      <td>75.5634</td>\n",
       "      <td>0257 - 2233283 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Shop No: 2, Marina Chs Ltd, Juhu Tara Road,mah...</td>\n",
       "      <td>19.0996</td>\n",
       "      <td>72.8275</td>\n",
       "      <td>022-26100974 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Shop No 1, 1A &amp; 2, Balaji Arcade, S V Road, Ka...</td>\n",
       "      <td>19.2016</td>\n",
       "      <td>72.8473</td>\n",
       "      <td>022-28010788 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>IFB Point, Sanadi Refrigeration Services, Shop...</td>\n",
       "      <td>16.2722</td>\n",
       "      <td>73.7056</td>\n",
       "      <td>7972798943 | 9422596968</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Shop No 2 &amp; 3, CTS No 3522 to 3527, Mulani Pla...</td>\n",
       "      <td>18.5689</td>\n",
       "      <td>73.8422</td>\n",
       "      <td>7387967890 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Shop No: 28, Hari Om Heritage Chs , Plot No: 8...</td>\n",
       "      <td>19.048</td>\n",
       "      <td>73.0647</td>\n",
       "      <td>022 - 27749187 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Ug-1 In Ace Arcade, 1660 - E, 9Th Lane, Rajara...</td>\n",
       "      <td>16.6933</td>\n",
       "      <td>74.2419</td>\n",
       "      <td>0231 - 2538900 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Shop No: 3 &amp; 4, Asha Deep Chsl, Opposite Vijay...</td>\n",
       "      <td>19.2815</td>\n",
       "      <td>72.8747</td>\n",
       "      <td>022 - 28129975 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Shop No: 7, Vikas Paradise Building, LBS Marg,...</td>\n",
       "      <td>19.1811</td>\n",
       "      <td>72.946</td>\n",
       "      <td>022 - 25909798 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Shop No: 3 &amp; 4, Plot No: 18/1, House No: 83, D...</td>\n",
       "      <td>21.1379</td>\n",
       "      <td>79.0825</td>\n",
       "      <td>0712 - 2422554 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Shop No: 4 &amp; 5, Ground Floor, Pratibha Sankul ...</td>\n",
       "      <td>21.1376</td>\n",
       "      <td>79.0675</td>\n",
       "      <td>7420056246 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Karhale Sales, Shop No. 13, Godawari Complex, ...</td>\n",
       "      <td>19.1687</td>\n",
       "      <td>77.3048</td>\n",
       "      <td>02462254215 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Bibevadi Kondva Road Market Yard-Landmark : Ga...</td>\n",
       "      <td>17.677469</td>\n",
       "      <td>75.903081</td>\n",
       "      <td>9881123246 2024245432</td>\n",
       "      <td>Arihant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>1481 Daruwala Pool Road Kasba Peth Landmark : ...</td>\n",
       "      <td>18.519165</td>\n",
       "      <td>73.862076</td>\n",
       "      <td>9881123295</td>\n",
       "      <td>Variety Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Sinhgad Road Hingane Khurd Landmark : Neelay C...</td>\n",
       "      <td>18.479544</td>\n",
       "      <td>73.824411</td>\n",
       "      <td>9881123409 020-24349242</td>\n",
       "      <td>Shiba Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>88/5 Kankeshwar Sooi Kutp Road Ajad Nagar-Land...</td>\n",
       "      <td>18.520293</td>\n",
       "      <td>73.857488</td>\n",
       "      <td>9881123416 2025381158</td>\n",
       "      <td>Gayatri Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>Main Road Gymkhana Deccan Gymkhana Landmark : ...</td>\n",
       "      <td>18.515913</td>\n",
       "      <td>73.842636</td>\n",
       "      <td>9881123815</td>\n",
       "      <td>Agents Corner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>217-220 Karve Road Sobashilp Kothrud Landmark ...</td>\n",
       "      <td>18.478871</td>\n",
       "      <td>73.862054</td>\n",
       "      <td>9890146046 2025388171</td>\n",
       "      <td>Mahavir Electronics &amp; Furniture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Sneha Apartment Near St Stand Opp Icici Bank A...</td>\n",
       "      <td>18.648794</td>\n",
       "      <td>72.875099</td>\n",
       "      <td>2141222352</td>\n",
       "      <td>Evergreen Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2 Amit Apts Shivaji Rd Opp S.T.Stand Panvel Ra...</td>\n",
       "      <td>18.991662</td>\n",
       "      <td>73.113573</td>\n",
       "      <td>022-27461138</td>\n",
       "      <td>Modern Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Shop No-12-13 Kalpatru Arcade Sec-4 New Panvel...</td>\n",
       "      <td>19.002571</td>\n",
       "      <td>73.11711</td>\n",
       "      <td>022-27483270</td>\n",
       "      <td>My Kitchen Home Appliance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Wada Road Rajguru Nagar,maharashtra,</td>\n",
       "      <td>18.856368</td>\n",
       "      <td>73.88136</td>\n",
       "      <td>9881176055 2135222846</td>\n",
       "      <td>Jayhind Electricals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Shubhash Bazar Chowk Shubhash Chowk Landmark :...</td>\n",
       "      <td>18.826497</td>\n",
       "      <td>74.376461</td>\n",
       "      <td>9890464591 2138222640</td>\n",
       "      <td>Darda Agencys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>Durga Devi Mandir Road Sai Nagar Landmark : Du...</td>\n",
       "      <td>17.677469</td>\n",
       "      <td>75.903081</td>\n",
       "      <td>9922822422 2118-246409</td>\n",
       "      <td>Arihant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>601 Raviwar Peth Main Bazar Raviwar Peth-Landm...</td>\n",
       "      <td>18.721229</td>\n",
       "      <td>73.686425</td>\n",
       "      <td>9822129909 2114222025</td>\n",
       "      <td>Sursangam Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Shop No 4 &amp; 14 Savla Sadan R. C. Marg Next To ...</td>\n",
       "      <td>19.060221</td>\n",
       "      <td>72.901493</td>\n",
       "      <td>2225273060</td>\n",
       "      <td>Embassy Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Ram Maruti Road Shop No 3 Taskar House Near St...</td>\n",
       "      <td>19.189232</td>\n",
       "      <td>72.97249</td>\n",
       "      <td>2225391621</td>\n",
       "      <td>Kiran Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>Ram Maruti Road Shop No 2 Near Station Opp Tit...</td>\n",
       "      <td>19.188116</td>\n",
       "      <td>72.972386</td>\n",
       "      <td>2225403631</td>\n",
       "      <td>Shree Jain Traders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>Jagdish Enclave Shop No 36 Near St Stand Boisa...</td>\n",
       "      <td>19.800088</td>\n",
       "      <td>72.759215</td>\n",
       "      <td>2525266415</td>\n",
       "      <td>Perfect Electrovision</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Alyali Dhansar Palghar Thane,maharashtra,</td>\n",
       "      <td>19.697703</td>\n",
       "      <td>72.740516</td>\n",
       "      <td>2525250716</td>\n",
       "      <td>Ruchit Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Yashoda Smruti Near Bank Of India B.P. Road Bh...</td>\n",
       "      <td>22.611364</td>\n",
       "      <td>77.769028</td>\n",
       "      <td>022-28046702</td>\n",
       "      <td>Anant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>11 Pushpanjanli Enterprises Opp Ram Mandir Pan...</td>\n",
       "      <td>19.696813</td>\n",
       "      <td>72.770266</td>\n",
       "      <td>022-28904186</td>\n",
       "      <td>Om Parshwanath Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>14 Sitaram Bhavan Achole Talati Road Near Rail...</td>\n",
       "      <td>19.419394</td>\n",
       "      <td>72.819987</td>\n",
       "      <td>0250-2430235 9320538818</td>\n",
       "      <td>Mascot Refrigeration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>Ovali Gaon Bhiwandi Thane,maharashtra,</td>\n",
       "      <td>19.27512</td>\n",
       "      <td>73.059721</td>\n",
       "      <td>02522-296083</td>\n",
       "      <td>Jumbo Distributors Pvt. Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Jalaram Nagar Sagar Naka Dahanu Thane,maharash...</td>\n",
       "      <td>19.218331</td>\n",
       "      <td>72.97809</td>\n",
       "      <td>02528-224120</td>\n",
       "      <td>Ichha Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Khodiyal Apts Nallasopara(W) Thane,maharashtra,</td>\n",
       "      <td>19.419595</td>\n",
       "      <td>72.80826</td>\n",
       "      <td>68200000000000 9029304300</td>\n",
       "      <td>Gaurav Elelctronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>Thane West Thane,maharashtra,</td>\n",
       "      <td>19.226661</td>\n",
       "      <td>72.983837</td>\n",
       "      <td></td>\n",
       "      <td>See Kitchen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Shop No 1 2 &amp; 3 Nirmal Apts Station Road Navgh...</td>\n",
       "      <td>19.378086</td>\n",
       "      <td>72.827154</td>\n",
       "      <td>2502342324</td>\n",
       "      <td>Rana Electronics &amp; Appliances</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>Shop No 5 &amp; 6 Panchal Nagar Near K.T Cinema Va...</td>\n",
       "      <td>19.379345</td>\n",
       "      <td>72.828641</td>\n",
       "      <td>95250-2348056</td>\n",
       "      <td>Shree Lord'S Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Vivah Dhavalgiri Opp More Manvay Pada Road Vir...</td>\n",
       "      <td>19.4471</td>\n",
       "      <td>72.819287</td>\n",
       "      <td>2502828247</td>\n",
       "      <td>Vikas Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Ground Floor Bldg No 1 Near Station Virar (W),...</td>\n",
       "      <td>19.454766</td>\n",
       "      <td>72.811375</td>\n",
       "      <td>2512508363</td>\n",
       "      <td>Viva Supermarket Pvt. Ltd.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Virar West Virar,maharashtra,</td>\n",
       "      <td>22.801768</td>\n",
       "      <td>86.205155</td>\n",
       "      <td>2502505956</td>\n",
       "      <td>National Electronics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>198 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Address   Latitude  Longitude  \\\n",
       "0    Prasad Agencies, Shop No a/b 10, Gurukul, Oppo...    19.1055    74.7327   \n",
       "1    Mercury Co-Hsg Society, Plot No: 4, Shop No: 6...    19.1479    72.9981   \n",
       "2    C/O - Shendge Agencies, Rajmata Ji Gaon Nagar,...    18.7275       76.3   \n",
       "3    Swaraj Electronics, Shop No: 209, Shilpi Compl...    20.9184    77.7538   \n",
       "4    Shop No: 2, Sunil Niwas Chsl, Plot No: 89/90, ...    19.1334    72.8256   \n",
       "5    IFB Point, Padmaawati Chowk, Opposite Shivaji ...    20.9941     78.228   \n",
       "6    Shop No: 3, Ground Floor, Niyoshi Park 3 Chsl,...    18.5609    73.8129   \n",
       "7    Akanksha Sales & Services, Shop No: 19, Kailas...    19.8772    75.3644   \n",
       "8    Gut No: 17/5/1, Plot No: 5, Opposite State Ban...    19.8666    75.3546   \n",
       "9    Ifb Point, Pratik Digital World, Bansilal Naga...    19.8635     75.315   \n",
       "10   Anand Sales & Services, Juna Nagar Naka, Nagar...    18.9891    75.7554   \n",
       "11   Shop No: 8, Atur Park Shiv Parvati Co-Op Hsg S...    19.0506    72.9043   \n",
       "12   Shop No: B6, Gokhale Vrindavan, Near P.N Gadgi...    18.6306    73.7762   \n",
       "13   Poona E House, Lane No: 5, Nagapatti,maharasht...    20.9051     74.775   \n",
       "14   Uday Electronics, Nehru Chowk, Gadhinglaj,maha...     16.225     74.353   \n",
       "15   Shop No: 3 B, Orion Business Park, Next To Cin...    19.2236    72.9772   \n",
       "16   S No: 79/2/1, Shop No: 2/8 & 2/9, Wanowrie, Op...    18.5065    73.9105   \n",
       "17   Padmavati Prajkta Electronics, Prateek Plaza, ...     16.692     74.453   \n",
       "18   Deepali Mobiles, 32, Visanji Nagar, Opposite K...    21.0127    75.5634   \n",
       "19   Shop No: 2, Marina Chs Ltd, Juhu Tara Road,mah...    19.0996    72.8275   \n",
       "20   Shop No 1, 1A & 2, Balaji Arcade, S V Road, Ka...    19.2016    72.8473   \n",
       "21   IFB Point, Sanadi Refrigeration Services, Shop...    16.2722    73.7056   \n",
       "22   Shop No 2 & 3, CTS No 3522 to 3527, Mulani Pla...    18.5689    73.8422   \n",
       "23   Shop No: 28, Hari Om Heritage Chs , Plot No: 8...     19.048    73.0647   \n",
       "24   Ug-1 In Ace Arcade, 1660 - E, 9Th Lane, Rajara...    16.6933    74.2419   \n",
       "25   Shop No: 3 & 4, Asha Deep Chsl, Opposite Vijay...    19.2815    72.8747   \n",
       "26   Shop No: 7, Vikas Paradise Building, LBS Marg,...    19.1811     72.946   \n",
       "27   Shop No: 3 & 4, Plot No: 18/1, House No: 83, D...    21.1379    79.0825   \n",
       "28   Shop No: 4 & 5, Ground Floor, Pratibha Sankul ...    21.1376    79.0675   \n",
       "29   Karhale Sales, Shop No. 13, Godawari Complex, ...    19.1687    77.3048   \n",
       "..                                                 ...        ...        ...   \n",
       "119  Bibevadi Kondva Road Market Yard-Landmark : Ga...  17.677469  75.903081   \n",
       "120  1481 Daruwala Pool Road Kasba Peth Landmark : ...  18.519165  73.862076   \n",
       "121  Sinhgad Road Hingane Khurd Landmark : Neelay C...  18.479544  73.824411   \n",
       "122  88/5 Kankeshwar Sooi Kutp Road Ajad Nagar-Land...  18.520293  73.857488   \n",
       "123  Main Road Gymkhana Deccan Gymkhana Landmark : ...  18.515913  73.842636   \n",
       "124  217-220 Karve Road Sobashilp Kothrud Landmark ...  18.478871  73.862054   \n",
       "125  Sneha Apartment Near St Stand Opp Icici Bank A...  18.648794  72.875099   \n",
       "126  2 Amit Apts Shivaji Rd Opp S.T.Stand Panvel Ra...  18.991662  73.113573   \n",
       "127  Shop No-12-13 Kalpatru Arcade Sec-4 New Panvel...  19.002571   73.11711   \n",
       "128               Wada Road Rajguru Nagar,maharashtra,  18.856368   73.88136   \n",
       "129  Shubhash Bazar Chowk Shubhash Chowk Landmark :...  18.826497  74.376461   \n",
       "130  Durga Devi Mandir Road Sai Nagar Landmark : Du...  17.677469  75.903081   \n",
       "131  601 Raviwar Peth Main Bazar Raviwar Peth-Landm...  18.721229  73.686425   \n",
       "132  Shop No 4 & 14 Savla Sadan R. C. Marg Next To ...  19.060221  72.901493   \n",
       "133  Ram Maruti Road Shop No 3 Taskar House Near St...  19.189232   72.97249   \n",
       "134  Ram Maruti Road Shop No 2 Near Station Opp Tit...  19.188116  72.972386   \n",
       "135  Jagdish Enclave Shop No 36 Near St Stand Boisa...  19.800088  72.759215   \n",
       "136          Alyali Dhansar Palghar Thane,maharashtra,  19.697703  72.740516   \n",
       "137  Yashoda Smruti Near Bank Of India B.P. Road Bh...  22.611364  77.769028   \n",
       "138  11 Pushpanjanli Enterprises Opp Ram Mandir Pan...  19.696813  72.770266   \n",
       "139  14 Sitaram Bhavan Achole Talati Road Near Rail...  19.419394  72.819987   \n",
       "140             Ovali Gaon Bhiwandi Thane,maharashtra,   19.27512  73.059721   \n",
       "141  Jalaram Nagar Sagar Naka Dahanu Thane,maharash...  19.218331   72.97809   \n",
       "142    Khodiyal Apts Nallasopara(W) Thane,maharashtra,  19.419595   72.80826   \n",
       "143                      Thane West Thane,maharashtra,  19.226661  72.983837   \n",
       "144  Shop No 1 2 & 3 Nirmal Apts Station Road Navgh...  19.378086  72.827154   \n",
       "145  Shop No 5 & 6 Panchal Nagar Near K.T Cinema Va...  19.379345  72.828641   \n",
       "146  Vivah Dhavalgiri Opp More Manvay Pada Road Vir...    19.4471  72.819287   \n",
       "147  Ground Floor Bldg No 1 Near Station Virar (W),...  19.454766  72.811375   \n",
       "148                      Virar West Virar,maharashtra,  22.801768  86.205155   \n",
       "\n",
       "                       Contact                             Name  \n",
       "0      9325106465 | 8999776308                        IFB POINT  \n",
       "1             022 - 27699976 |                        IFB POINT  \n",
       "2                 9422243493 |                        IFB POINT  \n",
       "3                07212569424 |                        IFB POINT  \n",
       "4               022-26310208 |                        IFB POINT  \n",
       "5                 9175580154 |                        IFB POINT  \n",
       "6                 7420056242 |                        IFB POINT  \n",
       "7                 9325666050 |                        IFB POINT  \n",
       "8                 9823442277 |                        IFB POINT  \n",
       "9      9975531333 | 8668221087                        IFB POINT  \n",
       "10                9422233038 |                        IFB POINT  \n",
       "11            022 - 25218174 |                        IFB POINT  \n",
       "12               02027350123 |                        IFB POINT  \n",
       "13            0256 - 2234361 |                        IFB POINT  \n",
       "14               02327223332 |                        IFB POINT  \n",
       "15                8291007487 |                        IFB POINT  \n",
       "16                7420056227 |                        IFB POINT  \n",
       "17                9860009833 |                        IFB POINT  \n",
       "18            0257 - 2233283 |                        IFB POINT  \n",
       "19              022-26100974 |                        IFB POINT  \n",
       "20              022-28010788 |                        IFB POINT  \n",
       "21     7972798943 | 9422596968                        IFB POINT  \n",
       "22                7387967890 |                        IFB POINT  \n",
       "23            022 - 27749187 |                        IFB POINT  \n",
       "24            0231 - 2538900 |                        IFB POINT  \n",
       "25            022 - 28129975 |                        IFB POINT  \n",
       "26            022 - 25909798 |                        IFB POINT  \n",
       "27            0712 - 2422554 |                        IFB POINT  \n",
       "28                7420056246 |                        IFB POINT  \n",
       "29               02462254215 |                        IFB POINT  \n",
       "..                         ...                              ...  \n",
       "119      9881123246 2024245432              Arihant Electronics  \n",
       "120                 9881123295              Variety Electronics  \n",
       "121    9881123409 020-24349242                Shiba Electronics  \n",
       "122      9881123416 2025381158              Gayatri Electronics  \n",
       "123                 9881123815                    Agents Corner  \n",
       "124      9890146046 2025388171  Mahavir Electronics & Furniture  \n",
       "125                 2141222352            Evergreen Electronics  \n",
       "126               022-27461138               Modern Enterprises  \n",
       "127               022-27483270        My Kitchen Home Appliance  \n",
       "128      9881176055 2135222846              Jayhind Electricals  \n",
       "129      9890464591 2138222640                    Darda Agencys  \n",
       "130     9922822422 2118-246409              Arihant Electronics  \n",
       "131      9822129909 2114222025            Sursangam Electronics  \n",
       "132                 2225273060              Embassy Electronics  \n",
       "133                 2225391621                Kiran Electronics  \n",
       "134                 2225403631               Shree Jain Traders  \n",
       "135                 2525266415            Perfect Electrovision  \n",
       "136                 2525250716               Ruchit Electronics  \n",
       "137               022-28046702                Anant Electronics  \n",
       "138               022-28904186       Om Parshwanath Electronics  \n",
       "139    0250-2430235 9320538818             Mascot Refrigeration  \n",
       "140               02522-296083      Jumbo Distributors Pvt. Ltd  \n",
       "141               02528-224120                Ichha Electronics  \n",
       "142  68200000000000 9029304300              Gaurav Elelctronics  \n",
       "143                                                 See Kitchen  \n",
       "144                 2502342324    Rana Electronics & Appliances  \n",
       "145              95250-2348056         Shree Lord'S Electronics  \n",
       "146                 2502828247                Vikas Enterprises  \n",
       "147                 2512508363       Viva Supermarket Pvt. Ltd.  \n",
       "148                 2502505956             National Electronics  \n",
       "\n",
       "[198 rows x 5 columns]"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ifb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [],
   "source": [
    "ifb.to_csv('C:/Users/abdenather/Desktop/xelpmoc/ibf.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "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>Address</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Contact</th>\n",
       "      <th>Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Prasad Agencies, Shop No a/b 10, Gurukul, Oppo...</td>\n",
       "      <td>19.105514</td>\n",
       "      <td>74.732671</td>\n",
       "      <td>9325106465 | 8999776308</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mercury Co-Hsg Society, Plot No: 4, Shop No: 6...</td>\n",
       "      <td>19.147932</td>\n",
       "      <td>72.998125</td>\n",
       "      <td>022 - 27699976 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C/O - Shendge Agencies, Rajmata Ji Gaon Nagar,...</td>\n",
       "      <td>18.727525</td>\n",
       "      <td>76.300000</td>\n",
       "      <td>9422243493 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Swaraj Electronics, Shop No: 209, Shilpi Compl...</td>\n",
       "      <td>20.918419</td>\n",
       "      <td>77.753820</td>\n",
       "      <td>07212569424 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Shop No: 2, Sunil Niwas Chsl, Plot No: 89/90, ...</td>\n",
       "      <td>19.133406</td>\n",
       "      <td>72.825645</td>\n",
       "      <td>022-26310208 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>IFB Point, Padmaawati Chowk, Opposite Shivaji ...</td>\n",
       "      <td>20.994108</td>\n",
       "      <td>78.227962</td>\n",
       "      <td>9175580154 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Shop No: 3, Ground Floor, Niyoshi Park 3 Chsl,...</td>\n",
       "      <td>18.560854</td>\n",
       "      <td>73.812852</td>\n",
       "      <td>7420056242 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Akanksha Sales &amp; Services, Shop No: 19, Kailas...</td>\n",
       "      <td>19.877157</td>\n",
       "      <td>75.364441</td>\n",
       "      <td>9325666050 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Gut No: 17/5/1, Plot No: 5, Opposite State Ban...</td>\n",
       "      <td>19.866617</td>\n",
       "      <td>75.354591</td>\n",
       "      <td>9823442277 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ifb Point, Pratik Digital World, Bansilal Naga...</td>\n",
       "      <td>19.863547</td>\n",
       "      <td>75.314978</td>\n",
       "      <td>9975531333 | 8668221087</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Anand Sales &amp; Services, Juna Nagar Naka, Nagar...</td>\n",
       "      <td>18.989091</td>\n",
       "      <td>75.755445</td>\n",
       "      <td>9422233038 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Shop No: 8, Atur Park Shiv Parvati Co-Op Hsg S...</td>\n",
       "      <td>19.050631</td>\n",
       "      <td>72.904260</td>\n",
       "      <td>022 - 25218174 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Shop No: B6, Gokhale Vrindavan, Near P.N Gadgi...</td>\n",
       "      <td>18.630612</td>\n",
       "      <td>73.776234</td>\n",
       "      <td>02027350123 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Poona E House, Lane No: 5, Nagapatti,maharasht...</td>\n",
       "      <td>20.905085</td>\n",
       "      <td>74.775002</td>\n",
       "      <td>0256 - 2234361 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Uday Electronics, Nehru Chowk, Gadhinglaj,maha...</td>\n",
       "      <td>16.225000</td>\n",
       "      <td>74.353000</td>\n",
       "      <td>02327223332 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Shop No: 3 B, Orion Business Park, Next To Cin...</td>\n",
       "      <td>19.223611</td>\n",
       "      <td>72.977210</td>\n",
       "      <td>8291007487 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>S No: 79/2/1, Shop No: 2/8 &amp; 2/9, Wanowrie, Op...</td>\n",
       "      <td>18.506502</td>\n",
       "      <td>73.910539</td>\n",
       "      <td>7420056227 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Padmavati Prajkta Electronics, Prateek Plaza, ...</td>\n",
       "      <td>16.692000</td>\n",
       "      <td>74.453000</td>\n",
       "      <td>9860009833 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Deepali Mobiles, 32, Visanji Nagar, Opposite K...</td>\n",
       "      <td>21.012742</td>\n",
       "      <td>75.563358</td>\n",
       "      <td>0257 - 2233283 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Shop No: 2, Marina Chs Ltd, Juhu Tara Road,mah...</td>\n",
       "      <td>19.099603</td>\n",
       "      <td>72.827488</td>\n",
       "      <td>022-26100974 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Shop No 1, 1A &amp; 2, Balaji Arcade, S V Road, Ka...</td>\n",
       "      <td>19.201603</td>\n",
       "      <td>72.847259</td>\n",
       "      <td>022-28010788 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>IFB Point, Sanadi Refrigeration Services, Shop...</td>\n",
       "      <td>16.272178</td>\n",
       "      <td>73.705647</td>\n",
       "      <td>7972798943 | 9422596968</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Shop No 2 &amp; 3, CTS No 3522 to 3527, Mulani Pla...</td>\n",
       "      <td>18.568880</td>\n",
       "      <td>73.842233</td>\n",
       "      <td>7387967890 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Shop No: 28, Hari Om Heritage Chs , Plot No: 8...</td>\n",
       "      <td>19.048044</td>\n",
       "      <td>73.064706</td>\n",
       "      <td>022 - 27749187 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Ug-1 In Ace Arcade, 1660 - E, 9Th Lane, Rajara...</td>\n",
       "      <td>16.693333</td>\n",
       "      <td>74.241944</td>\n",
       "      <td>0231 - 2538900 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Shop No: 3 &amp; 4, Asha Deep Chsl, Opposite Vijay...</td>\n",
       "      <td>19.281505</td>\n",
       "      <td>72.874740</td>\n",
       "      <td>022 - 28129975 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Shop No: 7, Vikas Paradise Building, LBS Marg,...</td>\n",
       "      <td>19.181057</td>\n",
       "      <td>72.946010</td>\n",
       "      <td>022 - 25909798 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Shop No: 3 &amp; 4, Plot No: 18/1, House No: 83, D...</td>\n",
       "      <td>21.137945</td>\n",
       "      <td>79.082456</td>\n",
       "      <td>0712 - 2422554 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Shop No: 4 &amp; 5, Ground Floor, Pratibha Sankul ...</td>\n",
       "      <td>21.137634</td>\n",
       "      <td>79.067505</td>\n",
       "      <td>7420056246 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Karhale Sales, Shop No. 13, Godawari Complex, ...</td>\n",
       "      <td>19.168688</td>\n",
       "      <td>77.304815</td>\n",
       "      <td>02462254215 |</td>\n",
       "      <td>IFB POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Bibevadi Kondva Road Market Yard-Landmark : Ga...</td>\n",
       "      <td>17.677469</td>\n",
       "      <td>75.903081</td>\n",
       "      <td>9881123246 2024245432</td>\n",
       "      <td>Arihant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>1481 Daruwala Pool Road Kasba Peth Landmark : ...</td>\n",
       "      <td>18.519165</td>\n",
       "      <td>73.862076</td>\n",
       "      <td>9881123295</td>\n",
       "      <td>Variety Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Sinhgad Road Hingane Khurd Landmark : Neelay C...</td>\n",
       "      <td>18.479544</td>\n",
       "      <td>73.824411</td>\n",
       "      <td>9881123409 020-24349242</td>\n",
       "      <td>Shiba Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>88/5 Kankeshwar Sooi Kutp Road Ajad Nagar-Land...</td>\n",
       "      <td>18.520293</td>\n",
       "      <td>73.857488</td>\n",
       "      <td>9881123416 2025381158</td>\n",
       "      <td>Gayatri Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>Main Road Gymkhana Deccan Gymkhana Landmark : ...</td>\n",
       "      <td>18.515913</td>\n",
       "      <td>73.842636</td>\n",
       "      <td>9881123815</td>\n",
       "      <td>Agents Corner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>217-220 Karve Road Sobashilp Kothrud Landmark ...</td>\n",
       "      <td>18.478871</td>\n",
       "      <td>73.862054</td>\n",
       "      <td>9890146046 2025388171</td>\n",
       "      <td>Mahavir Electronics &amp; Furniture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>Sneha Apartment Near St Stand Opp Icici Bank A...</td>\n",
       "      <td>18.648794</td>\n",
       "      <td>72.875099</td>\n",
       "      <td>2141222352</td>\n",
       "      <td>Evergreen Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2 Amit Apts Shivaji Rd Opp S.T.Stand Panvel Ra...</td>\n",
       "      <td>18.991662</td>\n",
       "      <td>73.113573</td>\n",
       "      <td>022-27461138</td>\n",
       "      <td>Modern Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Shop No-12-13 Kalpatru Arcade Sec-4 New Panvel...</td>\n",
       "      <td>19.002571</td>\n",
       "      <td>73.117110</td>\n",
       "      <td>022-27483270</td>\n",
       "      <td>My Kitchen Home Appliance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Wada Road Rajguru Nagar,maharashtra,</td>\n",
       "      <td>18.856368</td>\n",
       "      <td>73.881360</td>\n",
       "      <td>9881176055 2135222846</td>\n",
       "      <td>Jayhind Electricals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>Shubhash Bazar Chowk Shubhash Chowk Landmark :...</td>\n",
       "      <td>18.826497</td>\n",
       "      <td>74.376461</td>\n",
       "      <td>9890464591 2138222640</td>\n",
       "      <td>Darda Agencys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Durga Devi Mandir Road Sai Nagar Landmark : Du...</td>\n",
       "      <td>17.677469</td>\n",
       "      <td>75.903081</td>\n",
       "      <td>9922822422 2118-246409</td>\n",
       "      <td>Arihant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>601 Raviwar Peth Main Bazar Raviwar Peth-Landm...</td>\n",
       "      <td>18.721229</td>\n",
       "      <td>73.686425</td>\n",
       "      <td>9822129909 2114222025</td>\n",
       "      <td>Sursangam Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Shop No 4 &amp; 14 Savla Sadan R. C. Marg Next To ...</td>\n",
       "      <td>19.060221</td>\n",
       "      <td>72.901493</td>\n",
       "      <td>2225273060</td>\n",
       "      <td>Embassy Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>Ram Maruti Road Shop No 3 Taskar House Near St...</td>\n",
       "      <td>19.189232</td>\n",
       "      <td>72.972490</td>\n",
       "      <td>2225391621</td>\n",
       "      <td>Kiran Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Ram Maruti Road Shop No 2 Near Station Opp Tit...</td>\n",
       "      <td>19.188116</td>\n",
       "      <td>72.972386</td>\n",
       "      <td>2225403631</td>\n",
       "      <td>Shree Jain Traders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Jagdish Enclave Shop No 36 Near St Stand Boisa...</td>\n",
       "      <td>19.800088</td>\n",
       "      <td>72.759215</td>\n",
       "      <td>2525266415</td>\n",
       "      <td>Perfect Electrovision</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Alyali Dhansar Palghar Thane,maharashtra,</td>\n",
       "      <td>19.697703</td>\n",
       "      <td>72.740516</td>\n",
       "      <td>2525250716</td>\n",
       "      <td>Ruchit Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Yashoda Smruti Near Bank Of India B.P. Road Bh...</td>\n",
       "      <td>22.611364</td>\n",
       "      <td>77.769028</td>\n",
       "      <td>022-28046702</td>\n",
       "      <td>Anant Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>11 Pushpanjanli Enterprises Opp Ram Mandir Pan...</td>\n",
       "      <td>19.696813</td>\n",
       "      <td>72.770266</td>\n",
       "      <td>022-28904186</td>\n",
       "      <td>Om Parshwanath Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>14 Sitaram Bhavan Achole Talati Road Near Rail...</td>\n",
       "      <td>19.419394</td>\n",
       "      <td>72.819987</td>\n",
       "      <td>0250-2430235 9320538818</td>\n",
       "      <td>Mascot Refrigeration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Ovali Gaon Bhiwandi Thane,maharashtra,</td>\n",
       "      <td>19.275120</td>\n",
       "      <td>73.059721</td>\n",
       "      <td>02522-296083</td>\n",
       "      <td>Jumbo Distributors Pvt. Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>Jalaram Nagar Sagar Naka Dahanu Thane,maharash...</td>\n",
       "      <td>19.218331</td>\n",
       "      <td>72.978090</td>\n",
       "      <td>02528-224120</td>\n",
       "      <td>Ichha Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Khodiyal Apts Nallasopara(W) Thane,maharashtra,</td>\n",
       "      <td>19.419595</td>\n",
       "      <td>72.808260</td>\n",
       "      <td>68200000000000 9029304300</td>\n",
       "      <td>Gaurav Elelctronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Thane West Thane,maharashtra,</td>\n",
       "      <td>19.226661</td>\n",
       "      <td>72.983837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>See Kitchen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>Shop No 1 2 &amp; 3 Nirmal Apts Station Road Navgh...</td>\n",
       "      <td>19.378086</td>\n",
       "      <td>72.827154</td>\n",
       "      <td>2502342324</td>\n",
       "      <td>Rana Electronics &amp; Appliances</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>Shop No 5 &amp; 6 Panchal Nagar Near K.T Cinema Va...</td>\n",
       "      <td>19.379345</td>\n",
       "      <td>72.828641</td>\n",
       "      <td>95250-2348056</td>\n",
       "      <td>Shree Lord'S Electronics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Vivah Dhavalgiri Opp More Manvay Pada Road Vir...</td>\n",
       "      <td>19.447100</td>\n",
       "      <td>72.819287</td>\n",
       "      <td>2502828247</td>\n",
       "      <td>Vikas Enterprises</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>Ground Floor Bldg No 1 Near Station Virar (W),...</td>\n",
       "      <td>19.454766</td>\n",
       "      <td>72.811375</td>\n",
       "      <td>2512508363</td>\n",
       "      <td>Viva Supermarket Pvt. Ltd.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>Virar West Virar,maharashtra,</td>\n",
       "      <td>22.801768</td>\n",
       "      <td>86.205155</td>\n",
       "      <td>2502505956</td>\n",
       "      <td>National Electronics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>198 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Address   Latitude  Longitude  \\\n",
       "0    Prasad Agencies, Shop No a/b 10, Gurukul, Oppo...  19.105514  74.732671   \n",
       "1    Mercury Co-Hsg Society, Plot No: 4, Shop No: 6...  19.147932  72.998125   \n",
       "2    C/O - Shendge Agencies, Rajmata Ji Gaon Nagar,...  18.727525  76.300000   \n",
       "3    Swaraj Electronics, Shop No: 209, Shilpi Compl...  20.918419  77.753820   \n",
       "4    Shop No: 2, Sunil Niwas Chsl, Plot No: 89/90, ...  19.133406  72.825645   \n",
       "5    IFB Point, Padmaawati Chowk, Opposite Shivaji ...  20.994108  78.227962   \n",
       "6    Shop No: 3, Ground Floor, Niyoshi Park 3 Chsl,...  18.560854  73.812852   \n",
       "7    Akanksha Sales & Services, Shop No: 19, Kailas...  19.877157  75.364441   \n",
       "8    Gut No: 17/5/1, Plot No: 5, Opposite State Ban...  19.866617  75.354591   \n",
       "9    Ifb Point, Pratik Digital World, Bansilal Naga...  19.863547  75.314978   \n",
       "10   Anand Sales & Services, Juna Nagar Naka, Nagar...  18.989091  75.755445   \n",
       "11   Shop No: 8, Atur Park Shiv Parvati Co-Op Hsg S...  19.050631  72.904260   \n",
       "12   Shop No: B6, Gokhale Vrindavan, Near P.N Gadgi...  18.630612  73.776234   \n",
       "13   Poona E House, Lane No: 5, Nagapatti,maharasht...  20.905085  74.775002   \n",
       "14   Uday Electronics, Nehru Chowk, Gadhinglaj,maha...  16.225000  74.353000   \n",
       "15   Shop No: 3 B, Orion Business Park, Next To Cin...  19.223611  72.977210   \n",
       "16   S No: 79/2/1, Shop No: 2/8 & 2/9, Wanowrie, Op...  18.506502  73.910539   \n",
       "17   Padmavati Prajkta Electronics, Prateek Plaza, ...  16.692000  74.453000   \n",
       "18   Deepali Mobiles, 32, Visanji Nagar, Opposite K...  21.012742  75.563358   \n",
       "19   Shop No: 2, Marina Chs Ltd, Juhu Tara Road,mah...  19.099603  72.827488   \n",
       "20   Shop No 1, 1A & 2, Balaji Arcade, S V Road, Ka...  19.201603  72.847259   \n",
       "21   IFB Point, Sanadi Refrigeration Services, Shop...  16.272178  73.705647   \n",
       "22   Shop No 2 & 3, CTS No 3522 to 3527, Mulani Pla...  18.568880  73.842233   \n",
       "23   Shop No: 28, Hari Om Heritage Chs , Plot No: 8...  19.048044  73.064706   \n",
       "24   Ug-1 In Ace Arcade, 1660 - E, 9Th Lane, Rajara...  16.693333  74.241944   \n",
       "25   Shop No: 3 & 4, Asha Deep Chsl, Opposite Vijay...  19.281505  72.874740   \n",
       "26   Shop No: 7, Vikas Paradise Building, LBS Marg,...  19.181057  72.946010   \n",
       "27   Shop No: 3 & 4, Plot No: 18/1, House No: 83, D...  21.137945  79.082456   \n",
       "28   Shop No: 4 & 5, Ground Floor, Pratibha Sankul ...  21.137634  79.067505   \n",
       "29   Karhale Sales, Shop No. 13, Godawari Complex, ...  19.168688  77.304815   \n",
       "..                                                 ...        ...        ...   \n",
       "168  Bibevadi Kondva Road Market Yard-Landmark : Ga...  17.677469  75.903081   \n",
       "169  1481 Daruwala Pool Road Kasba Peth Landmark : ...  18.519165  73.862076   \n",
       "170  Sinhgad Road Hingane Khurd Landmark : Neelay C...  18.479544  73.824411   \n",
       "171  88/5 Kankeshwar Sooi Kutp Road Ajad Nagar-Land...  18.520293  73.857488   \n",
       "172  Main Road Gymkhana Deccan Gymkhana Landmark : ...  18.515913  73.842636   \n",
       "173  217-220 Karve Road Sobashilp Kothrud Landmark ...  18.478871  73.862054   \n",
       "174  Sneha Apartment Near St Stand Opp Icici Bank A...  18.648794  72.875099   \n",
       "175  2 Amit Apts Shivaji Rd Opp S.T.Stand Panvel Ra...  18.991662  73.113573   \n",
       "176  Shop No-12-13 Kalpatru Arcade Sec-4 New Panvel...  19.002571  73.117110   \n",
       "177               Wada Road Rajguru Nagar,maharashtra,  18.856368  73.881360   \n",
       "178  Shubhash Bazar Chowk Shubhash Chowk Landmark :...  18.826497  74.376461   \n",
       "179  Durga Devi Mandir Road Sai Nagar Landmark : Du...  17.677469  75.903081   \n",
       "180  601 Raviwar Peth Main Bazar Raviwar Peth-Landm...  18.721229  73.686425   \n",
       "181  Shop No 4 & 14 Savla Sadan R. C. Marg Next To ...  19.060221  72.901493   \n",
       "182  Ram Maruti Road Shop No 3 Taskar House Near St...  19.189232  72.972490   \n",
       "183  Ram Maruti Road Shop No 2 Near Station Opp Tit...  19.188116  72.972386   \n",
       "184  Jagdish Enclave Shop No 36 Near St Stand Boisa...  19.800088  72.759215   \n",
       "185          Alyali Dhansar Palghar Thane,maharashtra,  19.697703  72.740516   \n",
       "186  Yashoda Smruti Near Bank Of India B.P. Road Bh...  22.611364  77.769028   \n",
       "187  11 Pushpanjanli Enterprises Opp Ram Mandir Pan...  19.696813  72.770266   \n",
       "188  14 Sitaram Bhavan Achole Talati Road Near Rail...  19.419394  72.819987   \n",
       "189             Ovali Gaon Bhiwandi Thane,maharashtra,  19.275120  73.059721   \n",
       "190  Jalaram Nagar Sagar Naka Dahanu Thane,maharash...  19.218331  72.978090   \n",
       "191    Khodiyal Apts Nallasopara(W) Thane,maharashtra,  19.419595  72.808260   \n",
       "192                      Thane West Thane,maharashtra,  19.226661  72.983837   \n",
       "193  Shop No 1 2 & 3 Nirmal Apts Station Road Navgh...  19.378086  72.827154   \n",
       "194  Shop No 5 & 6 Panchal Nagar Near K.T Cinema Va...  19.379345  72.828641   \n",
       "195  Vivah Dhavalgiri Opp More Manvay Pada Road Vir...  19.447100  72.819287   \n",
       "196  Ground Floor Bldg No 1 Near Station Virar (W),...  19.454766  72.811375   \n",
       "197                      Virar West Virar,maharashtra,  22.801768  86.205155   \n",
       "\n",
       "                       Contact                             Name  \n",
       "0      9325106465 | 8999776308                        IFB POINT  \n",
       "1             022 - 27699976 |                        IFB POINT  \n",
       "2                 9422243493 |                        IFB POINT  \n",
       "3                07212569424 |                        IFB POINT  \n",
       "4               022-26310208 |                        IFB POINT  \n",
       "5                 9175580154 |                        IFB POINT  \n",
       "6                 7420056242 |                        IFB POINT  \n",
       "7                 9325666050 |                        IFB POINT  \n",
       "8                 9823442277 |                        IFB POINT  \n",
       "9      9975531333 | 8668221087                        IFB POINT  \n",
       "10                9422233038 |                        IFB POINT  \n",
       "11            022 - 25218174 |                        IFB POINT  \n",
       "12               02027350123 |                        IFB POINT  \n",
       "13            0256 - 2234361 |                        IFB POINT  \n",
       "14               02327223332 |                        IFB POINT  \n",
       "15                8291007487 |                        IFB POINT  \n",
       "16                7420056227 |                        IFB POINT  \n",
       "17                9860009833 |                        IFB POINT  \n",
       "18            0257 - 2233283 |                        IFB POINT  \n",
       "19              022-26100974 |                        IFB POINT  \n",
       "20              022-28010788 |                        IFB POINT  \n",
       "21     7972798943 | 9422596968                        IFB POINT  \n",
       "22                7387967890 |                        IFB POINT  \n",
       "23            022 - 27749187 |                        IFB POINT  \n",
       "24            0231 - 2538900 |                        IFB POINT  \n",
       "25            022 - 28129975 |                        IFB POINT  \n",
       "26            022 - 25909798 |                        IFB POINT  \n",
       "27            0712 - 2422554 |                        IFB POINT  \n",
       "28                7420056246 |                        IFB POINT  \n",
       "29               02462254215 |                        IFB POINT  \n",
       "..                         ...                              ...  \n",
       "168      9881123246 2024245432              Arihant Electronics  \n",
       "169                 9881123295              Variety Electronics  \n",
       "170    9881123409 020-24349242                Shiba Electronics  \n",
       "171      9881123416 2025381158              Gayatri Electronics  \n",
       "172                 9881123815                    Agents Corner  \n",
       "173      9890146046 2025388171  Mahavir Electronics & Furniture  \n",
       "174                 2141222352            Evergreen Electronics  \n",
       "175               022-27461138               Modern Enterprises  \n",
       "176               022-27483270        My Kitchen Home Appliance  \n",
       "177      9881176055 2135222846              Jayhind Electricals  \n",
       "178      9890464591 2138222640                    Darda Agencys  \n",
       "179     9922822422 2118-246409              Arihant Electronics  \n",
       "180      9822129909 2114222025            Sursangam Electronics  \n",
       "181                 2225273060              Embassy Electronics  \n",
       "182                 2225391621                Kiran Electronics  \n",
       "183                 2225403631               Shree Jain Traders  \n",
       "184                 2525266415            Perfect Electrovision  \n",
       "185                 2525250716               Ruchit Electronics  \n",
       "186               022-28046702                Anant Electronics  \n",
       "187               022-28904186       Om Parshwanath Electronics  \n",
       "188    0250-2430235 9320538818             Mascot Refrigeration  \n",
       "189               02522-296083      Jumbo Distributors Pvt. Ltd  \n",
       "190               02528-224120                Ichha Electronics  \n",
       "191  68200000000000 9029304300              Gaurav Elelctronics  \n",
       "192                        NaN                      See Kitchen  \n",
       "193                 2502342324    Rana Electronics & Appliances  \n",
       "194              95250-2348056         Shree Lord'S Electronics  \n",
       "195                 2502828247                Vikas Enterprises  \n",
       "196                 2512508363       Viva Supermarket Pvt. Ltd.  \n",
       "197                 2502505956             National Electronics  \n",
       "\n",
       "[198 rows x 5 columns]"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.read_excel(r'C:/Users/abdenather/Desktop/xelpmoc/census/ibf.xlsx')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}