scrapingDoc.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup as bs\n",
    "import pandas as pd\n",
    "import requests\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.common.exceptions import TimeoutException\n",
    "import pyautogui as auto\n",
    "import time\n",
    "\n",
    "auto.PAUSE =2.0\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(executable_path= \"/usr/bin/chromedriver\")\n",
    "driver.get(\"https://yellowpages.webindia123.com/o-d/Karnataka/Bangalore/2/1/\")\n",
    "\n",
    "#driver.findElement(\"<span class=\"\"jcl\"\" onclick=\"\"closePopUp('best_deal_div');\").click();\n",
    "#driver=driver.findElement(By.xpath(\"//span[contains(@class,'jcl') and contains(text(), 'best_deal_div')\")\n",
    "#driver.click()\n",
    "#new WebDriverWait(driver, 30).until(ExpectedConditions.visibilityOfElementLocated(By.xpath(\"//span[contains(@class,'middle') and contains(text(), '')]\"))).click()\n",
    "    \n",
    "# <span class=\"middle\">Next</span>\n",
    "#<span class=\"jcl\" onclick=\"closePopUp('best_deal_div');\">X</span>\n",
    "\n",
    "auto.click(579, 24, clicks= 2)\n",
    "\n",
    "time_end = time.time()+ 60*1\n",
    "time.sleep(5)\n",
    "auto.moveTo(1694, 808, duration=0.5)\n",
    "\n",
    "while time.time()< time_end:\n",
    "    continue\n",
    "    \n",
    "res = driver.execute_script(\"return document.documentElement.outerHTML\")\n",
    "soup = bs(res,'lxml')\n",
    "\n",
    "find= soup.find_all('a', href= True)\n",
    "\n",
    "url =[]\n",
    "for i in find:\n",
    "    if '/Bangalore/' in i.get('href'):\n",
    "        url.append(i.get('href'))\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/c-t/Karnataka/Bangalore/All/1/'"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url[0]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<h1>Veterinary Doctors in Bangalore</h1>]\n",
      "Veterinary Doctors in Bangalore\n"
     ]
    }
   ],
   "source": [
    "req = requests.get(\"https://yellowpages.webindia123.com/d-py/Karnataka/Bangalore/Veterinary-Doctors-891/1/\")\n",
    "soup = bs(req.text,\"lxml\")\n",
    "    \n",
    "title = soup.find_all('h1')\n",
    "print(title)\n",
    "title = title[0].text\n",
    "print(title)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "1\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n"
     ]
    }
   ],
   "source": [
    "base ='https://yellowpages.webindia123.com'\n",
    "\n",
    "doctor =[]\n",
    "\n",
    "for i in range(2,len(url)):\n",
    "    req = requests.get(base+url[i])\n",
    "    soup = bs(req.text,\"lxml\")\n",
    "    title = soup.find_all('h1')\n",
    "    print(len(title))\n",
    "    if len(title)!=0:\n",
    "        title = title[0].text\n",
    "    \n",
    "    name = soup.find_all('h4')\n",
    "    if len(name)!=0:\n",
    "        name = name[0].text\n",
    "    \n",
    "    loc = soup.find_all('div' ,class_='loc')\n",
    "    if len(loc)!=0:\n",
    "        loc = loc[0].text\n",
    "    \n",
    "    temp =[]\n",
    "    \n",
    "    temp.append(name)\n",
    "    temp.append(loc)\n",
    "    temp.append(title)\n",
    "    \n",
    "    \n",
    "    #temp.append(date[0])\n",
    "    \n",
    "    doctor.append(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "doc = pd.DataFrame(doctor, columns =['Name','Location','Speciality'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>Speciality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sanjeevini Acu Healthcare</td>\n",
       "      <td>83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...</td>\n",
       "      <td>Acupuncture Specialists in Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Triangle Print Communications</td>\n",
       "      <td>No. 1252, 10th Main, 5th Cross, Vijayanagar, B...</td>\n",
       "      <td>Allergy Doctors in Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dr. Venkatanarayan Raju</td>\n",
       "      <td>19, 1st Stage, Peenya, Bangalore - 560058</td>\n",
       "      <td>Anesthetists in Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Asthma Specialists in Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ear 2 Hear Clinic</td>\n",
       "      <td>323, Basement, 2nd Block, 2nd Cross, R M V 2nd...</td>\n",
       "      <td>Audiologists in Bangalore</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Name  \\\n",
       "0      Sanjeevini Acu Healthcare   \n",
       "1  Triangle Print Communications   \n",
       "2        Dr. Venkatanarayan Raju   \n",
       "3             Dr. Shashlkant Rao   \n",
       "4              Ear 2 Hear Clinic   \n",
       "\n",
       "                                            Location  \\\n",
       "0  83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...   \n",
       "1  No. 1252, 10th Main, 5th Cross, Vijayanagar, B...   \n",
       "2          19, 1st Stage, Peenya, Bangalore - 560058   \n",
       "3  Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "4  323, Basement, 2nd Block, 2nd Cross, R M V 2nd...   \n",
       "\n",
       "                             Speciality  \n",
       "0  Acupuncture Specialists in Bangalore  \n",
       "1          Allergy Doctors in Bangalore  \n",
       "2             Anesthetists in Bangalore  \n",
       "3       Asthma Specialists in Bangalore  \n",
       "4             Audiologists in Bangalore  "
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "doc.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "doc.to_csv('Doctor.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "data= pd.read_csv('Doctor.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Venkateshwara Complex, Agashettyhalli, Bangalore - 560094'"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Location'][55]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/shubhangi/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    "for i in range(1,98):\n",
    "    if(data['Location'][i]=='Indiranagar'):\n",
    "        data['Location'][i]='Avantika Complex, Marathahalli, Bangalore - 560094'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'R.T. Nagar'"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Location'][98].split(\", \")[-2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/shubhangi/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Vijayanagar\n",
      "Peenya\n",
      "Agashettyhalli\n",
      "R M V 2nd Stage\n",
      "Benson Town\n",
      "Banaswadi\n",
      "Sampangi Ram Nagar\n",
      "B.T.M. 1st Stage\n",
      "Millers Road\n",
      "Agashettyhalli\n",
      "Marathahalli\n",
      "Benson Town\n",
      "Sanjaynagar\n",
      "Kasthuri Nagar\n",
      "Marathahalli\n",
      "Sarjapura Main Road\n",
      "60 Feet Road\n",
      "Sunkadakatte\n",
      "Vijayanagar\n",
      "Peenya\n",
      "R M V 2nd Stage\n",
      "Benson Town\n",
      "Banaswadi\n",
      "Sampangi Ram Nagar\n",
      "B.T.M. 1st Stage\n",
      "Millers Road\n",
      "Agashettyhalli\n",
      "Marathahalli\n",
      "Benson Town\n",
      "Lakshmipuram\n",
      "Sanjaynagar\n",
      "Kasthuri Nagar\n",
      "Marathahalli\n",
      "Sarjapura Main Road\n",
      "60 Feet Road\n",
      "Koramangala\n",
      "Ganga Nagar\n",
      "Mathikere\n",
      "Lakshmipuram\n",
      "Rustumbagh\n",
      "Marathahalli\n",
      "Millers Road\n",
      "HSR Layout\n",
      "Lavelle Road\n",
      "2nd Stage\n",
      "Lavelle Road\n",
      "WOC Road\n",
      "Sampangi Ram Nagar\n",
      "Ganga Nagar\n",
      "Banaswadi\n",
      "Marathahalli\n",
      "Konanakunte Cross\n",
      "Sanjaynagar\n",
      "Brindavan Nagar\n",
      "Agashettyhalli\n",
      "Yelahanka\n",
      "Basaveshwara Nagar\n",
      "Commercial Street\n",
      "Marathahalli\n",
      "Rustumbagh\n",
      "Marathahalli\n",
      "Jaya Nagar\n",
      "Basaveshwara Nagar\n",
      "R.T. Nagar\n",
      "HSR Layout\n",
      "Koramangala\n",
      "Ganga Nagar\n",
      "Mathikere\n",
      "Lakshmipuram\n",
      "Rustumbagh\n",
      "HSR Layout\n",
      "Millers Road\n",
      "HSR Layout\n",
      "Marathahalli\n",
      "2nd Stage\n",
      "Lavelle Road\n",
      "WOC Road\n",
      "Marathahalli\n",
      "Ganga Nagar\n",
      "Banaswadi\n",
      "Marathahalli\n",
      "Marathahalli\n",
      "Marathahalli\n",
      "Hennur\n",
      "Konanakunte Cross\n",
      "Sanjaynagar\n",
      "Benson Town\n",
      "Brindavan Nagar\n",
      "Agashettyhalli\n",
      "Yelahanka\n",
      "Jayanagar 4th T Block\n",
      "Basaveshwara Nagar\n",
      "Marathahalli\n",
      "Koramangala\n",
      "Indiranagar\n",
      "Jaya Nagar\n",
      "Basaveshwara Nagar\n"
     ]
    }
   ],
   "source": [
    "for i in range(1,98):\n",
    "    m= data['Location'][i].split(\", \")[-2]\n",
    "    data['Locality'][i]= m\n",
    "    print(m)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        Basaveshwara Nagar\n",
       "1               Vijayanagar\n",
       "2                    Peenya\n",
       "3            Agashettyhalli\n",
       "4           R M V 2nd Stage\n",
       "5               Benson Town\n",
       "6                 Banaswadi\n",
       "7        Sampangi Ram Nagar\n",
       "8          B.T.M. 1st Stage\n",
       "9              Millers Road\n",
       "10           Agashettyhalli\n",
       "11             Marathahalli\n",
       "12              Benson Town\n",
       "13              Sanjaynagar\n",
       "14           Kasthuri Nagar\n",
       "15             Marathahalli\n",
       "16      Sarjapura Main Road\n",
       "17             60 Feet Road\n",
       "18             Sunkadakatte\n",
       "19              Vijayanagar\n",
       "20                   Peenya\n",
       "21          R M V 2nd Stage\n",
       "22              Benson Town\n",
       "23                Banaswadi\n",
       "24       Sampangi Ram Nagar\n",
       "25         B.T.M. 1st Stage\n",
       "26             Millers Road\n",
       "27           Agashettyhalli\n",
       "28             Marathahalli\n",
       "29              Benson Town\n",
       "              ...          \n",
       "69             Lakshmipuram\n",
       "70               Rustumbagh\n",
       "71               HSR Layout\n",
       "72             Millers Road\n",
       "73               HSR Layout\n",
       "74             Marathahalli\n",
       "75                2nd Stage\n",
       "76             Lavelle Road\n",
       "77                 WOC Road\n",
       "78             Marathahalli\n",
       "79              Ganga Nagar\n",
       "80                Banaswadi\n",
       "81             Marathahalli\n",
       "82             Marathahalli\n",
       "83             Marathahalli\n",
       "84                   Hennur\n",
       "85        Konanakunte Cross\n",
       "86              Sanjaynagar\n",
       "87              Benson Town\n",
       "88          Brindavan Nagar\n",
       "89           Agashettyhalli\n",
       "90                Yelahanka\n",
       "91    Jayanagar 4th T Block\n",
       "92       Basaveshwara Nagar\n",
       "93             Marathahalli\n",
       "94              Koramangala\n",
       "95              Indiranagar\n",
       "96               Jaya Nagar\n",
       "97       Basaveshwara Nagar\n",
       "98       Basaveshwara Nagar\n",
       "Name: Locality, Length: 99, dtype: object"
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Locality']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/shubhangi/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n"
     ]
    },
    {
     "ename": "AttributeError",
     "evalue": "'list' object has no attribute 'split'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-177-10291fe0ef8a>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m98\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m     \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Speciality'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m=\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Speciality'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\" \"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m: 'list' object has no attribute 'split'"
     ]
    }
   ],
   "source": [
    "for i in range(0,98):\n",
    "    data['Speciality'][i]= data['Speciality'][i].split(\" \")[0:2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [],
   "source": [
    "NewDoc = pd.DataFrame(data, columns =['Name','Location','Speciality', 'Locality'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "metadata": {},
   "outputs": [],
   "source": [
    "NewDoc.to_csv('Doktor.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('Doktor.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "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>Unnamed: 0</th>\n",
       "      <th>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>Speciality</th>\n",
       "      <th>Locality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Sanjeevini Acu Healthcare</td>\n",
       "      <td>83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...</td>\n",
       "      <td>Acupuncture Specialists in Bangalore</td>\n",
       "      <td>Basaveshwara Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Triangle Print Communications</td>\n",
       "      <td>No. 1252, 10th Main, 5th Cross, Vijayanagar, B...</td>\n",
       "      <td>Allergy Doctors in Bangalore</td>\n",
       "      <td>Vijayanagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Dr. Venkatanarayan Raju</td>\n",
       "      <td>19, 1st Stage, Peenya, Bangalore - 560058</td>\n",
       "      <td>Anesthetists in Bangalore</td>\n",
       "      <td>Peenya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Asthma Specialists in Bangalore</td>\n",
       "      <td>Agashettyhalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Ear 2 Hear Clinic</td>\n",
       "      <td>323, Basement, 2nd Block, 2nd Cross, R M V 2nd...</td>\n",
       "      <td>Audiologists in Bangalore</td>\n",
       "      <td>R M V 2nd Stage</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0                           Name  \\\n",
       "0           0      Sanjeevini Acu Healthcare   \n",
       "1           1  Triangle Print Communications   \n",
       "2           2        Dr. Venkatanarayan Raju   \n",
       "3           3             Dr. Shashlkant Rao   \n",
       "4           4              Ear 2 Hear Clinic   \n",
       "\n",
       "                                            Location  \\\n",
       "0  83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...   \n",
       "1  No. 1252, 10th Main, 5th Cross, Vijayanagar, B...   \n",
       "2          19, 1st Stage, Peenya, Bangalore - 560058   \n",
       "3  Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "4  323, Basement, 2nd Block, 2nd Cross, R M V 2nd...   \n",
       "\n",
       "                             Speciality            Locality  \n",
       "0  Acupuncture Specialists in Bangalore  Basaveshwara Nagar  \n",
       "1          Allergy Doctors in Bangalore         Vijayanagar  \n",
       "2             Anesthetists in Bangalore              Peenya  \n",
       "3       Asthma Specialists in Bangalore      Agashettyhalli  \n",
       "4             Audiologists in Bangalore     R M V 2nd Stage  "
      ]
     },
     "execution_count": 209,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>Speciality</th>\n",
       "      <th>Locality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sanjeevini Acu Healthcare</td>\n",
       "      <td>83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...</td>\n",
       "      <td>Acupuncture Specialists in Bangalore</td>\n",
       "      <td>Basaveshwara Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Triangle Print Communications</td>\n",
       "      <td>No. 1252, 10th Main, 5th Cross, Vijayanagar, B...</td>\n",
       "      <td>Allergy Doctors in Bangalore</td>\n",
       "      <td>Vijayanagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dr. Venkatanarayan Raju</td>\n",
       "      <td>19, 1st Stage, Peenya, Bangalore - 560058</td>\n",
       "      <td>Anesthetists in Bangalore</td>\n",
       "      <td>Peenya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Asthma Specialists in Bangalore</td>\n",
       "      <td>Agashettyhalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ear 2 Hear Clinic</td>\n",
       "      <td>323, Basement, 2nd Block, 2nd Cross, R M V 2nd...</td>\n",
       "      <td>Audiologists in Bangalore</td>\n",
       "      <td>R M V 2nd Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>The Benson Town Ayurvedic Clinic</td>\n",
       "      <td>Benson Town, Bangalore - 560005</td>\n",
       "      <td>Ayurvedic Doctors in Bangalore</td>\n",
       "      <td>Benson Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Total Orthocare</td>\n",
       "      <td>Muniswami Reddy Layout, Bangalore, Banaswadi, ...</td>\n",
       "      <td>Bone Specialists in Bangalore</td>\n",
       "      <td>Banaswadi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dr. Vishal Rao</td>\n",
       "      <td>HCG Cancer Center, Tower 3, 8 HCG Towers, P. K...</td>\n",
       "      <td>Cancer Specialists in Bangalore</td>\n",
       "      <td>Sampangi Ram Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dr. Kiron Varghese</td>\n",
       "      <td>Cardiovision, 53, 36th Main, 3rd Cross, Dollar...</td>\n",
       "      <td>Cardiac Surgeon in Bangalore</td>\n",
       "      <td>B.T.M. 1st Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Dr. Sunil Dwivedi</td>\n",
       "      <td>71/1, Millers Road, Bangalore - 560052</td>\n",
       "      <td>Cardiologists in Bangalore</td>\n",
       "      <td>Millers Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Chest Specialists in Bangalore</td>\n",
       "      <td>Agashettyhalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Dr. Sanjay Rao</td>\n",
       "      <td>Avantika Complex, Marathahalli, Bangalore - 56...</td>\n",
       "      <td>Child Specialists in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Dr. Alice Delahaye</td>\n",
       "      <td>Zinda Chiropractic Wellness, Durga Road, Benso...</td>\n",
       "      <td>Chiropractic Doctors in Bangalore</td>\n",
       "      <td>Benson Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Dr. Anantheshwar Y. N</td>\n",
       "      <td>17, 3rd Main Road, Sanjaynagar, Bangalore - 56...</td>\n",
       "      <td>Cosmetic Surgeon in Bangalore</td>\n",
       "      <td>Sanjaynagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Tooth Doctor</td>\n",
       "      <td>2nd Main Road, East of NGEF Layout, Kasthuri N...</td>\n",
       "      <td>Dentists in Bangalore</td>\n",
       "      <td>Kasthuri Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Neo Follicle Transplant</td>\n",
       "      <td>Opposite Innovative Multiplex, Marathahalli, B...</td>\n",
       "      <td>Dermatologists in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>M.V. Centre For Diabetes</td>\n",
       "      <td>NO.365, Sulochana Building, 1st Cross Road, Sa...</td>\n",
       "      <td>Diabetologists in Bangalore</td>\n",
       "      <td>Sarjapura Main Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Swasthya Nutrition</td>\n",
       "      <td>2nd Floor, Prema Paradise, AECS Layout - D Blo...</td>\n",
       "      <td>Dieticians in Bangalore</td>\n",
       "      <td>60 Feet Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sanjeevini Acu Healthcare</td>\n",
       "      <td>83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...</td>\n",
       "      <td>Doctors Acupuncture And Acupressure in Bangalore</td>\n",
       "      <td>Sunkadakatte</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Triangle Print Communications</td>\n",
       "      <td>No. 1252, 10th Main, 5th Cross, Vijayanagar, B...</td>\n",
       "      <td>Doctors Allergic in Bangalore</td>\n",
       "      <td>Vijayanagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Dr. Venkatanarayan Raju</td>\n",
       "      <td>19, 1st Stage, Peenya, Bangalore - 560058</td>\n",
       "      <td>Doctors Anesthetists in Bangalore</td>\n",
       "      <td>Peenya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Ear 2 Hear Clinic</td>\n",
       "      <td>323, Basement, 2nd Block, 2nd Cross, R M V 2nd...</td>\n",
       "      <td>Doctors Audiologist in Bangalore</td>\n",
       "      <td>R M V 2nd Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>The Benson Town Ayurvedic Clinic</td>\n",
       "      <td>Benson Town, Bangalore - 560005</td>\n",
       "      <td>Doctors Ayurvedic in Bangalore</td>\n",
       "      <td>Benson Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Total Orthocare</td>\n",
       "      <td>Muniswami Reddy Layout, Bangalore, Banaswadi, ...</td>\n",
       "      <td>Doctors Bone Specialists in Bangalore</td>\n",
       "      <td>Banaswadi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Dr. Vishal Rao</td>\n",
       "      <td>HCG Cancer Center, Tower 3, 8 HCG Towers, P. K...</td>\n",
       "      <td>Doctors Cancer Specialists in Bangalore</td>\n",
       "      <td>Sampangi Ram Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Dr. Kiron Varghese</td>\n",
       "      <td>Cardiovision, 53, 36th Main, 3rd Cross, Dollar...</td>\n",
       "      <td>Doctors Cardiac Surgeon in Bangalore</td>\n",
       "      <td>B.T.M. 1st Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Dr. Sunil Dwivedi</td>\n",
       "      <td>71/1, Millers Road, Bangalore - 560052</td>\n",
       "      <td>Doctors Cardiologists in Bangalore</td>\n",
       "      <td>Millers Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Doctors Chest Specialists in Bangalore</td>\n",
       "      <td>Agashettyhalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Dr. Sanjay Rao</td>\n",
       "      <td>Avantika Complex, Marathahalli, Bangalore - 56...</td>\n",
       "      <td>Doctors Child Specialists in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Dr. Alice Delahaye</td>\n",
       "      <td>Zinda Chiropractic Wellness, Durga Road, Benso...</td>\n",
       "      <td>Doctors Chiropractic in Bangalore</td>\n",
       "      <td>Benson Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Dr. B Ratnam</td>\n",
       "      <td>16, 16th Cross, CMH Road, Lakshmipuram, Bangal...</td>\n",
       "      <td>General Physicians in Bangalore</td>\n",
       "      <td>Lakshmipuram</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Dr. Adarsh M Patil</td>\n",
       "      <td>105, Vishnu, 5th Cross, Rustumbagh, Bangalore ...</td>\n",
       "      <td>General Surgeons in Bangalore</td>\n",
       "      <td>Rustumbagh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Dr. Narayana Hrudayalaya Super Specialty Clinic</td>\n",
       "      <td>43/AB, BDA COmplex, 1st Floor, HSR Layout, Ban...</td>\n",
       "      <td>Haematologists in Bangalore</td>\n",
       "      <td>HSR Layout</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Dr. Sunil Dwivedi</td>\n",
       "      <td>71/1, Millers Road, Bangalore - 560052</td>\n",
       "      <td>Heart Specialists in Bangalore</td>\n",
       "      <td>Millers Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Homeocare International- HSR Layout</td>\n",
       "      <td>437, 12th Cross, Near Cafe Coffee Day, 27th Ma...</td>\n",
       "      <td>Homeopathy Doctors in Bangalore</td>\n",
       "      <td>HSR Layout</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Cambridge Hospital</td>\n",
       "      <td>Avantika Complex, Marathahalli, Bangalore - 56...</td>\n",
       "      <td>Infertility Specialists in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Dr. Saurabh Misra</td>\n",
       "      <td>The Clinic Sure, 381, 7th Cross Road, Mico Lay...</td>\n",
       "      <td>Laproscopic Surgeon in Bangalore</td>\n",
       "      <td>2nd Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Dr. Sudarshan Ballal Hebri</td>\n",
       "      <td>17, Lavelle Road, Bangalore - 560001</td>\n",
       "      <td>Nephrologists in Bangalore</td>\n",
       "      <td>Lavelle Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Dr. Agadi J. B.</td>\n",
       "      <td>No. 63, 10th A Cross, 2nd Main, WOC Road, Bang...</td>\n",
       "      <td>Neuro Surgeon Neurologists in Bangalore</td>\n",
       "      <td>WOC Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Dr. Reshu Saraogi</td>\n",
       "      <td>Mannath Fertility Clinic, Kishan Icon 90/2, 2n...</td>\n",
       "      <td>Obstetricians in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Dr. R. K. Eye Clinic</td>\n",
       "      <td>Building No. 20/25, Bhargav Towers, Dinnur Mai...</td>\n",
       "      <td>Ophthalmologists in Bangalore</td>\n",
       "      <td>Ganga Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Total Orthocare</td>\n",
       "      <td>Muniswami Reddy Layout, Bangalore, Banaswadi, ...</td>\n",
       "      <td>Orthopaedics Doctors in Bangalore</td>\n",
       "      <td>Banaswadi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Dr. Sanjay Rao</td>\n",
       "      <td>Avantika Complex, Marathahalli, Bangalore - 56...</td>\n",
       "      <td>Paediatricians in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Dr. Sanjay Rao</td>\n",
       "      <td>Avantika Complex, Marathahalli, Bangalore - 56...</td>\n",
       "      <td>Peadiatricians in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Dr. ShivaKeerthi Reddy</td>\n",
       "      <td>Avantika Complex, Marathahalli, Bangalore - 56...</td>\n",
       "      <td>Pedodontists in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Dr. Supriya Ebenezer</td>\n",
       "      <td>Dental Den, 1st Floor, Hennur, Bangalore - 560043</td>\n",
       "      <td>Periodontists in Bangalore</td>\n",
       "      <td>Hennur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Astra Physiotherapy Centre</td>\n",
       "      <td>21/7, Vasanthapura Main Road, Konanakunte Cros...</td>\n",
       "      <td>Physiotherapists in Bangalore</td>\n",
       "      <td>Konanakunte Cross</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Dr. Anantheshwar Y. N</td>\n",
       "      <td>17, 3rd Main Road, Sanjaynagar, Bangalore - 56...</td>\n",
       "      <td>Plastic Surgeons in Bangalore</td>\n",
       "      <td>Sanjaynagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Dr. Alice Delahaye</td>\n",
       "      <td>Zinda Chiropractic Wellness, Durga Road, Benso...</td>\n",
       "      <td>Practitioners Chiropractic in Bangalore</td>\n",
       "      <td>Benson Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Dr. Ravi Prakash</td>\n",
       "      <td>1 , Thanushree Complex, 16th Cross, Tank Bund ...</td>\n",
       "      <td>Psychiatrists in Bangalore</td>\n",
       "      <td>Brindavan Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Pulmonologists in Bangalore</td>\n",
       "      <td>Agashettyhalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Dr. Sharath Kumar Shetty</td>\n",
       "      <td>No. 1304, B. B. Road, Yelahanka, Bangalore - 5...</td>\n",
       "      <td>Radiologists in Bangalore</td>\n",
       "      <td>Yelahanka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Dragon Astrology</td>\n",
       "      <td>No.A206, Spartacus Apartments, 30th Cross, Jay...</td>\n",
       "      <td>Reiki Consultants in Bangalore</td>\n",
       "      <td>Jayanagar 4th T Block</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Dr. Gynaec And Surgical Clinic</td>\n",
       "      <td>No 464, 1st Floor, Next Pavithra Paradise, 3rd...</td>\n",
       "      <td>Sexologists in Bangalore</td>\n",
       "      <td>Basaveshwara Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Neo Follicle Transplant</td>\n",
       "      <td>Opposite Innovative Multiplex, Marathahalli, B...</td>\n",
       "      <td>Skin Specialists in Bangalore</td>\n",
       "      <td>Marathahalli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Dr. Rajasekara Reddy H. V</td>\n",
       "      <td>319/A, Chest Specialist Clinic, 1st Cross, 1st...</td>\n",
       "      <td>Thoracic Surgeons in Bangalore</td>\n",
       "      <td>Koramangala</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Dr. Shahid Shamsher Reviews</td>\n",
       "      <td>1001, Dr Health Trichology Clinic, 12th A Main...</td>\n",
       "      <td>Trichologists in Bangalore</td>\n",
       "      <td>Indiranagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Dr. Mahendra Jain</td>\n",
       "      <td>206, 10th Main, 1st Block, Jaya Nagar, Bangalo...</td>\n",
       "      <td>Urologists in Bangalore</td>\n",
       "      <td>Jaya Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Dr. Gynaec And Surgical Clinic</td>\n",
       "      <td>No 464, 1st Floor, Next Pavithra Paradise, 3rd...</td>\n",
       "      <td>Venereologists in Bangalore</td>\n",
       "      <td>Basaveshwara Nagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Dr. Venugopal K. V</td>\n",
       "      <td>No. 9, 1st B Main Road, R.T. Nagar, Bangalore ...</td>\n",
       "      <td>Veterinary Doctors in Bangalore</td>\n",
       "      <td>Basaveshwara Nagar</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>99 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Name  \\\n",
       "0                         Sanjeevini Acu Healthcare   \n",
       "1                     Triangle Print Communications   \n",
       "2                           Dr. Venkatanarayan Raju   \n",
       "3                                Dr. Shashlkant Rao   \n",
       "4                                 Ear 2 Hear Clinic   \n",
       "5                  The Benson Town Ayurvedic Clinic   \n",
       "6                                   Total Orthocare   \n",
       "7                                    Dr. Vishal Rao   \n",
       "8                                Dr. Kiron Varghese   \n",
       "9                                 Dr. Sunil Dwivedi   \n",
       "10                               Dr. Shashlkant Rao   \n",
       "11                                   Dr. Sanjay Rao   \n",
       "12                               Dr. Alice Delahaye   \n",
       "13                            Dr. Anantheshwar Y. N   \n",
       "14                                     Tooth Doctor   \n",
       "15                          Neo Follicle Transplant   \n",
       "16                         M.V. Centre For Diabetes   \n",
       "17                               Swasthya Nutrition   \n",
       "18                        Sanjeevini Acu Healthcare   \n",
       "19                    Triangle Print Communications   \n",
       "20                          Dr. Venkatanarayan Raju   \n",
       "21                                Ear 2 Hear Clinic   \n",
       "22                 The Benson Town Ayurvedic Clinic   \n",
       "23                                  Total Orthocare   \n",
       "24                                   Dr. Vishal Rao   \n",
       "25                               Dr. Kiron Varghese   \n",
       "26                                Dr. Sunil Dwivedi   \n",
       "27                               Dr. Shashlkant Rao   \n",
       "28                                   Dr. Sanjay Rao   \n",
       "29                               Dr. Alice Delahaye   \n",
       "..                                              ...   \n",
       "69                                     Dr. B Ratnam   \n",
       "70                               Dr. Adarsh M Patil   \n",
       "71  Dr. Narayana Hrudayalaya Super Specialty Clinic   \n",
       "72                                Dr. Sunil Dwivedi   \n",
       "73              Homeocare International- HSR Layout   \n",
       "74                               Cambridge Hospital   \n",
       "75                                Dr. Saurabh Misra   \n",
       "76                       Dr. Sudarshan Ballal Hebri   \n",
       "77                                  Dr. Agadi J. B.   \n",
       "78                                Dr. Reshu Saraogi   \n",
       "79                             Dr. R. K. Eye Clinic   \n",
       "80                                  Total Orthocare   \n",
       "81                                   Dr. Sanjay Rao   \n",
       "82                                   Dr. Sanjay Rao   \n",
       "83                           Dr. ShivaKeerthi Reddy   \n",
       "84                             Dr. Supriya Ebenezer   \n",
       "85                       Astra Physiotherapy Centre   \n",
       "86                            Dr. Anantheshwar Y. N   \n",
       "87                               Dr. Alice Delahaye   \n",
       "88                                 Dr. Ravi Prakash   \n",
       "89                               Dr. Shashlkant Rao   \n",
       "90                         Dr. Sharath Kumar Shetty   \n",
       "91                                 Dragon Astrology   \n",
       "92                   Dr. Gynaec And Surgical Clinic   \n",
       "93                          Neo Follicle Transplant   \n",
       "94                        Dr. Rajasekara Reddy H. V   \n",
       "95                      Dr. Shahid Shamsher Reviews   \n",
       "96                                Dr. Mahendra Jain   \n",
       "97                   Dr. Gynaec And Surgical Clinic   \n",
       "98                               Dr. Venugopal K. V   \n",
       "\n",
       "                                             Location  \\\n",
       "0   83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...   \n",
       "1   No. 1252, 10th Main, 5th Cross, Vijayanagar, B...   \n",
       "2           19, 1st Stage, Peenya, Bangalore - 560058   \n",
       "3   Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "4   323, Basement, 2nd Block, 2nd Cross, R M V 2nd...   \n",
       "5                     Benson Town, Bangalore - 560005   \n",
       "6   Muniswami Reddy Layout, Bangalore, Banaswadi, ...   \n",
       "7   HCG Cancer Center, Tower 3, 8 HCG Towers, P. K...   \n",
       "8   Cardiovision, 53, 36th Main, 3rd Cross, Dollar...   \n",
       "9              71/1, Millers Road, Bangalore - 560052   \n",
       "10  Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "11  Avantika Complex, Marathahalli, Bangalore - 56...   \n",
       "12  Zinda Chiropractic Wellness, Durga Road, Benso...   \n",
       "13  17, 3rd Main Road, Sanjaynagar, Bangalore - 56...   \n",
       "14  2nd Main Road, East of NGEF Layout, Kasthuri N...   \n",
       "15  Opposite Innovative Multiplex, Marathahalli, B...   \n",
       "16  NO.365, Sulochana Building, 1st Cross Road, Sa...   \n",
       "17  2nd Floor, Prema Paradise, AECS Layout - D Blo...   \n",
       "18  83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...   \n",
       "19  No. 1252, 10th Main, 5th Cross, Vijayanagar, B...   \n",
       "20          19, 1st Stage, Peenya, Bangalore - 560058   \n",
       "21  323, Basement, 2nd Block, 2nd Cross, R M V 2nd...   \n",
       "22                    Benson Town, Bangalore - 560005   \n",
       "23  Muniswami Reddy Layout, Bangalore, Banaswadi, ...   \n",
       "24  HCG Cancer Center, Tower 3, 8 HCG Towers, P. K...   \n",
       "25  Cardiovision, 53, 36th Main, 3rd Cross, Dollar...   \n",
       "26             71/1, Millers Road, Bangalore - 560052   \n",
       "27  Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "28  Avantika Complex, Marathahalli, Bangalore - 56...   \n",
       "29  Zinda Chiropractic Wellness, Durga Road, Benso...   \n",
       "..                                                ...   \n",
       "69  16, 16th Cross, CMH Road, Lakshmipuram, Bangal...   \n",
       "70  105, Vishnu, 5th Cross, Rustumbagh, Bangalore ...   \n",
       "71  43/AB, BDA COmplex, 1st Floor, HSR Layout, Ban...   \n",
       "72             71/1, Millers Road, Bangalore - 560052   \n",
       "73  437, 12th Cross, Near Cafe Coffee Day, 27th Ma...   \n",
       "74  Avantika Complex, Marathahalli, Bangalore - 56...   \n",
       "75  The Clinic Sure, 381, 7th Cross Road, Mico Lay...   \n",
       "76               17, Lavelle Road, Bangalore - 560001   \n",
       "77  No. 63, 10th A Cross, 2nd Main, WOC Road, Bang...   \n",
       "78  Mannath Fertility Clinic, Kishan Icon 90/2, 2n...   \n",
       "79  Building No. 20/25, Bhargav Towers, Dinnur Mai...   \n",
       "80  Muniswami Reddy Layout, Bangalore, Banaswadi, ...   \n",
       "81  Avantika Complex, Marathahalli, Bangalore - 56...   \n",
       "82  Avantika Complex, Marathahalli, Bangalore - 56...   \n",
       "83  Avantika Complex, Marathahalli, Bangalore - 56...   \n",
       "84  Dental Den, 1st Floor, Hennur, Bangalore - 560043   \n",
       "85  21/7, Vasanthapura Main Road, Konanakunte Cros...   \n",
       "86  17, 3rd Main Road, Sanjaynagar, Bangalore - 56...   \n",
       "87  Zinda Chiropractic Wellness, Durga Road, Benso...   \n",
       "88  1 , Thanushree Complex, 16th Cross, Tank Bund ...   \n",
       "89  Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "90  No. 1304, B. B. Road, Yelahanka, Bangalore - 5...   \n",
       "91  No.A206, Spartacus Apartments, 30th Cross, Jay...   \n",
       "92  No 464, 1st Floor, Next Pavithra Paradise, 3rd...   \n",
       "93  Opposite Innovative Multiplex, Marathahalli, B...   \n",
       "94  319/A, Chest Specialist Clinic, 1st Cross, 1st...   \n",
       "95  1001, Dr Health Trichology Clinic, 12th A Main...   \n",
       "96  206, 10th Main, 1st Block, Jaya Nagar, Bangalo...   \n",
       "97  No 464, 1st Floor, Next Pavithra Paradise, 3rd...   \n",
       "98  No. 9, 1st B Main Road, R.T. Nagar, Bangalore ...   \n",
       "\n",
       "                                          Speciality               Locality  \n",
       "0               Acupuncture Specialists in Bangalore     Basaveshwara Nagar  \n",
       "1                       Allergy Doctors in Bangalore            Vijayanagar  \n",
       "2                          Anesthetists in Bangalore                 Peenya  \n",
       "3                    Asthma Specialists in Bangalore         Agashettyhalli  \n",
       "4                          Audiologists in Bangalore        R M V 2nd Stage  \n",
       "5                     Ayurvedic Doctors in Bangalore            Benson Town  \n",
       "6                      Bone Specialists in Bangalore              Banaswadi  \n",
       "7                    Cancer Specialists in Bangalore     Sampangi Ram Nagar  \n",
       "8                       Cardiac Surgeon in Bangalore       B.T.M. 1st Stage  \n",
       "9                         Cardiologists in Bangalore           Millers Road  \n",
       "10                    Chest Specialists in Bangalore         Agashettyhalli  \n",
       "11                    Child Specialists in Bangalore           Marathahalli  \n",
       "12                 Chiropractic Doctors in Bangalore            Benson Town  \n",
       "13                     Cosmetic Surgeon in Bangalore            Sanjaynagar  \n",
       "14                             Dentists in Bangalore         Kasthuri Nagar  \n",
       "15                       Dermatologists in Bangalore           Marathahalli  \n",
       "16                       Diabetologists in Bangalore    Sarjapura Main Road  \n",
       "17                           Dieticians in Bangalore           60 Feet Road  \n",
       "18  Doctors Acupuncture And Acupressure in Bangalore           Sunkadakatte  \n",
       "19                     Doctors Allergic in Bangalore            Vijayanagar  \n",
       "20                 Doctors Anesthetists in Bangalore                 Peenya  \n",
       "21                  Doctors Audiologist in Bangalore        R M V 2nd Stage  \n",
       "22                    Doctors Ayurvedic in Bangalore            Benson Town  \n",
       "23             Doctors Bone Specialists in Bangalore              Banaswadi  \n",
       "24           Doctors Cancer Specialists in Bangalore     Sampangi Ram Nagar  \n",
       "25              Doctors Cardiac Surgeon in Bangalore       B.T.M. 1st Stage  \n",
       "26                Doctors Cardiologists in Bangalore           Millers Road  \n",
       "27            Doctors Chest Specialists in Bangalore         Agashettyhalli  \n",
       "28            Doctors Child Specialists in Bangalore           Marathahalli  \n",
       "29                 Doctors Chiropractic in Bangalore            Benson Town  \n",
       "..                                               ...                    ...  \n",
       "69                   General Physicians in Bangalore           Lakshmipuram  \n",
       "70                     General Surgeons in Bangalore             Rustumbagh  \n",
       "71                       Haematologists in Bangalore             HSR Layout  \n",
       "72                    Heart Specialists in Bangalore           Millers Road  \n",
       "73                   Homeopathy Doctors in Bangalore             HSR Layout  \n",
       "74              Infertility Specialists in Bangalore           Marathahalli  \n",
       "75                  Laproscopic Surgeon in Bangalore              2nd Stage  \n",
       "76                        Nephrologists in Bangalore           Lavelle Road  \n",
       "77           Neuro Surgeon Neurologists in Bangalore               WOC Road  \n",
       "78                        Obstetricians in Bangalore           Marathahalli  \n",
       "79                     Ophthalmologists in Bangalore            Ganga Nagar  \n",
       "80                 Orthopaedics Doctors in Bangalore              Banaswadi  \n",
       "81                       Paediatricians in Bangalore           Marathahalli  \n",
       "82                       Peadiatricians in Bangalore           Marathahalli  \n",
       "83                         Pedodontists in Bangalore           Marathahalli  \n",
       "84                        Periodontists in Bangalore                 Hennur  \n",
       "85                     Physiotherapists in Bangalore      Konanakunte Cross  \n",
       "86                     Plastic Surgeons in Bangalore            Sanjaynagar  \n",
       "87           Practitioners Chiropractic in Bangalore            Benson Town  \n",
       "88                        Psychiatrists in Bangalore        Brindavan Nagar  \n",
       "89                       Pulmonologists in Bangalore         Agashettyhalli  \n",
       "90                         Radiologists in Bangalore              Yelahanka  \n",
       "91                    Reiki Consultants in Bangalore  Jayanagar 4th T Block  \n",
       "92                          Sexologists in Bangalore     Basaveshwara Nagar  \n",
       "93                     Skin Specialists in Bangalore           Marathahalli  \n",
       "94                    Thoracic Surgeons in Bangalore            Koramangala  \n",
       "95                        Trichologists in Bangalore            Indiranagar  \n",
       "96                           Urologists in Bangalore             Jaya Nagar  \n",
       "97                       Venereologists in Bangalore     Basaveshwara Nagar  \n",
       "98                   Veterinary Doctors in Bangalore     Basaveshwara Nagar  \n",
       "\n",
       "[99 rows x 4 columns]"
      ]
     },
     "execution_count": 210,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.drop('Unnamed: 0', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "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>Unnamed: 0</th>\n",
       "      <th>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>Speciality</th>\n",
       "      <th>Locality</th>\n",
       "      <th>tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Sanjeevini Acu Healthcare</td>\n",
       "      <td>83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...</td>\n",
       "      <td>Acupuncture Specialists in Bangalore</td>\n",
       "      <td>Basaveshwara Nagar</td>\n",
       "      <td>[Acupuncture, Specialists]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Triangle Print Communications</td>\n",
       "      <td>No. 1252, 10th Main, 5th Cross, Vijayanagar, B...</td>\n",
       "      <td>Allergy Doctors in Bangalore</td>\n",
       "      <td>Vijayanagar</td>\n",
       "      <td>[Allergy, Doctors]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Dr. Venkatanarayan Raju</td>\n",
       "      <td>19, 1st Stage, Peenya, Bangalore - 560058</td>\n",
       "      <td>Anesthetists in Bangalore</td>\n",
       "      <td>Peenya</td>\n",
       "      <td>[Anesthetists]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Asthma Specialists in Bangalore</td>\n",
       "      <td>Agashettyhalli</td>\n",
       "      <td>[Asthma, Specialists]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Ear 2 Hear Clinic</td>\n",
       "      <td>323, Basement, 2nd Block, 2nd Cross, R M V 2nd...</td>\n",
       "      <td>Audiologists in Bangalore</td>\n",
       "      <td>R M V 2nd Stage</td>\n",
       "      <td>[Audiologists]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0                           Name  \\\n",
       "0           0      Sanjeevini Acu Healthcare   \n",
       "1           1  Triangle Print Communications   \n",
       "2           2        Dr. Venkatanarayan Raju   \n",
       "3           3             Dr. Shashlkant Rao   \n",
       "4           4              Ear 2 Hear Clinic   \n",
       "\n",
       "                                            Location  \\\n",
       "0  83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...   \n",
       "1  No. 1252, 10th Main, 5th Cross, Vijayanagar, B...   \n",
       "2          19, 1st Stage, Peenya, Bangalore - 560058   \n",
       "3  Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "4  323, Basement, 2nd Block, 2nd Cross, R M V 2nd...   \n",
       "\n",
       "                             Speciality            Locality  \\\n",
       "0  Acupuncture Specialists in Bangalore  Basaveshwara Nagar   \n",
       "1          Allergy Doctors in Bangalore         Vijayanagar   \n",
       "2             Anesthetists in Bangalore              Peenya   \n",
       "3       Asthma Specialists in Bangalore      Agashettyhalli   \n",
       "4             Audiologists in Bangalore     R M V 2nd Stage   \n",
       "\n",
       "                          tag  \n",
       "0  [Acupuncture, Specialists]  \n",
       "1          [Allergy, Doctors]  \n",
       "2              [Anesthetists]  \n",
       "3       [Asthma, Specialists]  \n",
       "4              [Audiologists]  "
      ]
     },
     "execution_count": 213,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/shubhangi/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:7: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  import sys\n"
     ]
    }
   ],
   "source": [
    "data['tag']= data['Speciality']\n",
    "for i in range(0,98):\n",
    "    if data['Speciality'][i].split(\" \")[1]=='in':\n",
    "        m= data['Speciality'][i].split(\" \")[0:1]\n",
    "    else:\n",
    "        m= data['Speciality'][i].split(\" \")[0:2]\n",
    "    data['tag'][i]= m"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [],
   "source": [
    "NewDoc = pd.DataFrame(data, columns =['Name','Location','Speciality', 'Locality', 'tag'])\n",
    "NewDoc.to_csv('Doktor.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('Doktor.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.drop('Unnamed: 0', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>Speciality</th>\n",
       "      <th>Locality</th>\n",
       "      <th>tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sanjeevini Acu Healthcare</td>\n",
       "      <td>83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...</td>\n",
       "      <td>Acupuncture Specialists in Bangalore</td>\n",
       "      <td>Basaveshwara Nagar</td>\n",
       "      <td>['Acupuncture', 'Specialists']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Triangle Print Communications</td>\n",
       "      <td>No. 1252, 10th Main, 5th Cross, Vijayanagar, B...</td>\n",
       "      <td>Allergy Doctors in Bangalore</td>\n",
       "      <td>Vijayanagar</td>\n",
       "      <td>['Allergy', 'Doctors']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dr. Venkatanarayan Raju</td>\n",
       "      <td>19, 1st Stage, Peenya, Bangalore - 560058</td>\n",
       "      <td>Anesthetists in Bangalore</td>\n",
       "      <td>Peenya</td>\n",
       "      <td>['Anesthetists']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dr. Shashlkant Rao</td>\n",
       "      <td>Venkateshwara Complex, Agashettyhalli, Bangalo...</td>\n",
       "      <td>Asthma Specialists in Bangalore</td>\n",
       "      <td>Agashettyhalli</td>\n",
       "      <td>['Asthma', 'Specialists']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ear 2 Hear Clinic</td>\n",
       "      <td>323, Basement, 2nd Block, 2nd Cross, R M V 2nd...</td>\n",
       "      <td>Audiologists in Bangalore</td>\n",
       "      <td>R M V 2nd Stage</td>\n",
       "      <td>['Audiologists']</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Name  \\\n",
       "0      Sanjeevini Acu Healthcare   \n",
       "1  Triangle Print Communications   \n",
       "2        Dr. Venkatanarayan Raju   \n",
       "3             Dr. Shashlkant Rao   \n",
       "4              Ear 2 Hear Clinic   \n",
       "\n",
       "                                            Location  \\\n",
       "0  83/160, Opp Lakshmi NarasimhaSwamy Temple, Sun...   \n",
       "1  No. 1252, 10th Main, 5th Cross, Vijayanagar, B...   \n",
       "2          19, 1st Stage, Peenya, Bangalore - 560058   \n",
       "3  Venkateshwara Complex, Agashettyhalli, Bangalo...   \n",
       "4  323, Basement, 2nd Block, 2nd Cross, R M V 2nd...   \n",
       "\n",
       "                             Speciality            Locality  \\\n",
       "0  Acupuncture Specialists in Bangalore  Basaveshwara Nagar   \n",
       "1          Allergy Doctors in Bangalore         Vijayanagar   \n",
       "2             Anesthetists in Bangalore              Peenya   \n",
       "3       Asthma Specialists in Bangalore      Agashettyhalli   \n",
       "4             Audiologists in Bangalore     R M V 2nd Stage   \n",
       "\n",
       "                              tag  \n",
       "0  ['Acupuncture', 'Specialists']  \n",
       "1          ['Allergy', 'Doctors']  \n",
       "2                ['Anesthetists']  \n",
       "3       ['Asthma', 'Specialists']  \n",
       "4                ['Audiologists']  "
      ]
     },
     "execution_count": 234,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "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
}