WebScrape_Accredited Pharm.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "a138ba0b-6f3d-4e12-8703-f941b8974185",
   "metadata": {
    "id": "a138ba0b-6f3d-4e12-8703-f941b8974185"
   },
   "source": [
    "## Web Scrape for Accredited Pharmacies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "25dd51d7-a606-4ff4-8fb9-72bc5c4f5c58",
   "metadata": {
    "id": "25dd51d7-a606-4ff4-8fb9-72bc5c4f5c58"
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import shutil\n",
    "from urllib.request import urlopen\n",
    "from bs4 import BeautifulSoup\n",
    "import pdb\n",
    "from urllib.request import urlopen, Request\n",
    "import requests\n",
    "from IPython.core.display import HTML"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "50f236f2",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "50f236f2",
    "outputId": "6d45c8fb-79d3-4ae5-e66b-bf96a22c34bb"
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:3: FutureWarning: The default value of regex will change from True to False in a future version.\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n",
      "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:9: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  if __name__ == '__main__':\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['https://acariahealth.envolvehealth.com',\n",
       " 'https://www.accredo.pharmacy',\n",
       " 'https://www.alphascriptrx.com',\n",
       " 'https://alto.com',\n",
       " 'https://www.amberpharmacy.com',\n",
       " 'https://www.medvantxrx.com',\n",
       " 'https://www.aoncology.com',\n",
       " 'https://www.citizenpharmacy.com',\n",
       " 'https://www.bioplusrx.com',\n",
       " 'https://www.birdirx.com',\n",
       " 'https://www.cornerstonehealthsolutions.org',\n",
       " 'https://www.cfspharmacy.pharmacy',\n",
       " 'https://www.caremark.com',\n",
       " 'https://www.carepointrx.com',\n",
       " 'https://redrockhome.pharmacy',\n",
       " 'https://www.centerwellpharmacy.com',\n",
       " 'https://www.carolinacarerx.org',\n",
       " 'https://www.costco.com',\n",
       " 'https://www.curanthealth.com',\n",
       " 'https://www.ccsmed.com',\n",
       " 'https://www.divvydose.com',\n",
       " 'https://www.friendswoodhealthmartpharmacy.com',\n",
       " 'https://eaglepharmacy.com',\n",
       " 'https://envisionpharmacies.com',\n",
       " 'https://www.express-scripts.com',\n",
       " 'https://www.essentiahealth.org',\n",
       " 'https://www.ecspecialtyrx.com',\n",
       " 'https://rosh.pharmacy',\n",
       " 'https://gentryhealthservices.com',\n",
       " 'https://www.dfwwellnesspharmacy.com',\n",
       " 'https://ameripharma.u',\n",
       " 'https://www.harristeeter.com',\n",
       " 'https://www.hometownpharmacy.com',\n",
       " 'https://www.healthwarehouse.com',\n",
       " 'https://www.hy-vee.com',\n",
       " 'https://www.hvrxsolutions.com',\n",
       " 'https://intermountainhealthcare.org/services/pharmacy',\n",
       " 'https://www.iuhealth.org/patients/pharmacie',\n",
       " 'https://www.icsrx.com',\n",
       " 'https://www.memorial.pharmacy',\n",
       " 'https://www.kmart.com',\n",
       " 'https://www.magellanrx.pharmacy',\n",
       " 'https://www.medimpact.com',\n",
       " 'https://www.meijer.com',\n",
       " 'https://www.geniusrx.com',\n",
       " 'https://www.thepillclub.com',\n",
       " 'https://www.noblehealthservices.com',\n",
       " 'https://www.northcoastmed.com',\n",
       " 'https://www.onco360.com',\n",
       " 'https://www.optumrx.com',\n",
       " 'https://www.orsinihealthcare.com',\n",
       " 'https://www.pantherxrare.com',\n",
       " 'https://www.rosemontspecialtyrx.com',\n",
       " 'https://www.mintrxpharmacy.com',\n",
       " 'https://www.amazon.com',\n",
       " 'https://ruepill.pharmacy',\n",
       " 'https://www.powerhousepharmacy.com',\n",
       " 'https://www.ridgeway.pharmacy',\n",
       " 'https://www.blueskyspecialtypharmacy.com',\n",
       " 'https://www.rxoutreach.org',\n",
       " 'https://www.flcancer.com',\n",
       " 'https://www.stpeterscommunitypharmacy.com',\n",
       " 'https://www.schrafts2.com',\n",
       " 'https://www.scriptsrxpharmacy.com',\n",
       " 'https://www.senderrarx.com',\n",
       " 'https://medhope.pharmacy',\n",
       " 'https://www.solerarx.com',\n",
       " 'https://www.sortpak.com',\n",
       " 'https://www.smrtrx.ne',\n",
       " 'https://www.synergenrx.com',\n",
       " 'https://www.bakersplus.com',\n",
       " 'https://metrohealth.pharmacy',\n",
       " 'https://mylocalrx.org',\n",
       " 'https://www.hopesp.com',\n",
       " 'https://www.medicorx.com',\n",
       " 'https://aging.depotdrug.com',\n",
       " 'https://www.usmed-rx.com',\n",
       " 'https://www.vascorx.com',\n",
       " 'https://rescriptions.wakehealth.edu',\n",
       " 'https://www.walmart.com/cp/pharmacy/5431',\n",
       " 'https://www.walgreens.com',\n",
       " 'https://www.weismarkets.com',\n",
       " 'https://www.welldynerx.com',\n",
       " 'https://www.yourrxpharmacy.com']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('Accredited Digital Pharmacies _ National Association of Boards of Pharmacy.csv')\n",
    "df['url'] = df['Website'].str.strip()\n",
    "df['u2'] = df['url'].str.replace(r'\\n\\n\\n\\tif', ' ')\n",
    "df['urls'] = df['u2'].str.split(' ').str[0]\n",
    "df['Name'] = df['BusinessName_PharmacyName'].str.split('\\n\\t\\t').str[1]\n",
    "gg = df[['Name','urls']]\n",
    "\n",
    "# strip https:// bc they only occur for some of the urls\n",
    "gg['urls'] = gg['urls'].str.strip('https://')\n",
    "gg = gg.iloc[: , 0:]\n",
    "gg.to_csv('good_guys.csv',index = False)\n",
    "gg = gg.drop([2, 46, 78]) ##### I DROPPED THREE ROWS THAT WERE MISSING URLs!!!!\n",
    "gg.tail(10)\n",
    "\n",
    "# add the https:// part back in for all of them\n",
    "gg['link'] = 'https://' + gg['urls'].astype(str)\n",
    "raw_links = gg['link'].tolist()\n",
    "raw_links"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "384a5f6a-34d1-4f57-8ff4-2e207c1f341b",
   "metadata": {
    "id": "384a5f6a-34d1-4f57-8ff4-2e207c1f341b"
   },
   "source": [
    "### List of URLs\n",
    "\n",
    "The ones commented out return various types of errors. Initially broke them out into chunks to see which ones were bad, some of them couldn't be looped and had to manually go through them. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b75a2421-bd8a-413b-98fe-b994ac05a776",
   "metadata": {
    "id": "b75a2421-bd8a-413b-98fe-b994ac05a776"
   },
   "outputs": [],
   "source": [
    "d1 = ['https://acariahealth.envolvehealth.com',\n",
    " 'https://www.accredo.pharmacy',\n",
    " 'https://www.alphascriptrx.com',\n",
    " 'https://alto.com',\n",
    " 'https://www.amberpharmacy.com',\n",
    "# 'https://www.medvantxrx.com', RETURNS RESPONSE: 503\n",
    " 'https://www.aoncology.com',\n",
    " 'https://www.citizenpharmacy.com',\n",
    " 'https://www.bioplusrx.com',\n",
    " 'https://www.birdirx.com',\n",
    " 'https://www.cornerstonehealthsolutions.org',\n",
    " 'https://www.cfspharmacy.pharmacy',\n",
    " 'https://www.caremark.com',\n",
    " 'https://www.carepointrx.com',\n",
    "# 'https://redrockhome.pharmacy', RETURNS SSLERROR\n",
    " 'https://www.centerwellpharmacy.com',\n",
    " 'https://www.carolinacarerx.org',\n",
    "# 'https://www.costco.com', KERNAL KEEPS RUNNING, NOT SURE WHAT THE ERROR IS. DOESN'T OUTPUT ANYTHING.\n",
    " 'https://www.curanthealth.com',\n",
    " 'https://www.ccsmed.com',\n",
    " 'https://www.divvydose.com',\n",
    " 'https://www.friendswoodhealthmartpharmacy.com',\n",
    " 'https://eaglepharmacy.com',\n",
    "# 'https://envisionpharmacies.com', RETURNS SSLERROR\n",
    " 'https://www.express-scripts.com',\n",
    " 'https://www.essentiahealth.org',\n",
    " 'https://www.ecspecialtyrx.com',\n",
    "# 'https://rosh.pharmacy', RETURNS CONNECTIONERROR\n",
    " 'https://gentryhealthservices.com',\n",
    " 'https://www.dfwwellnesspharmacy.com',\n",
    "# 'https://ameripharma.u', RETURNS CONNECTIONERROR\n",
    "# 'https://www.harristeeter.com', KERNAL KEEPS RUNNING, NOT SURE WHAT THE ERROR IS. DOESN'T OUTPUT ANYTHING.\n",
    " 'https://www.hometownpharmacy.com',\n",
    " 'https://www.healthwarehouse.com',\n",
    " 'https://www.hy-vee.com',\n",
    " 'https://www.hvrxsolutions.com',\n",
    " 'https://intermountainhealthcare.org/services/pharmacy',\n",
    "# 'https://www.iuhealth.org/patients/pharmacie', RETURNS RESPONSE: 404\n",
    "# 'https://www.icsrx.com', RETURNS SSLERROR\n",
    "# 'https://www.memorial.pharmacy', RETURNS CONNECTIONERROR\n",
    "# 'https://www.kmart.com', KERNAL KEEPS RUNNING, NOT SURE WHAT THE ERROR IS. DOESN'T OUTPUT ANYTHING.\n",
    " 'https://www.magellanrx.pharmacy', \n",
    " 'https://www.medimpact.com',\n",
    "# 'https://www.meijer.com', KERNAL KEEPS RUNNING, NOT SURE WHAT THE ERROR IS. DOESN'T OUTPUT ANYTHING.\n",
    " 'https://www.geniusrx.com',\n",
    " 'https://www.thepillclub.com',\n",
    "# 'https://www.noblehealthservices.com', RETURNS SSLERROR\n",
    " 'https://www.northcoastmed.com',\n",
    " 'https://www.onco360.com',\n",
    " 'https://www.optumrx.com',\n",
    " 'https://www.orsinihealthcare.com',\n",
    " 'https://www.pantherxrare.com',\n",
    "# 'https://www.rosemontspecialtyrx.com', RETURNS RESPONSE: 500\n",
    " 'https://www.mintrxpharmacy.com',\n",
    " 'https://www.amazon.com',\n",
    "# 'https://ruepill.pharmacy', RETURNS CONNECTIONERROR\n",
    " 'https://www.powerhousepharmacy.com',\n",
    " 'https://www.ridgeway.pharmacy',\n",
    " 'https://www.blueskyspecialtypharmacy.com',\n",
    " 'https://www.rxoutreach.org',\n",
    " 'https://www.flcancer.com',\n",
    " 'https://www.stpeterscommunitypharmacy.com',\n",
    " 'https://www.schrafts2.com',\n",
    " 'https://www.scriptsrxpharmacy.com',\n",
    " 'https://www.senderrarx.com',\n",
    "# 'https://medhope.pharmacy', RETURNS CONNECTIONERROR\n",
    " 'https://www.solerarx.com',\n",
    " 'https://www.sortpak.com',\n",
    "# 'https://www.smrtrx.ne', RETURNS CONNECTIONERROR\n",
    " 'https://www.synergenrx.com',\n",
    "# 'https://www.bakersplus.com', KERNAL KEEPS RUNNING, NOT SURE WHAT THE ERROR IS. DOESN'T OUTPUT ANYTHING.\n",
    " 'https://metrohealth.org/pharmacy',\n",
    " 'https://mylocalrx.org',\n",
    " 'https://www.hopesp.com',\n",
    " 'https://www.medicorx.com',\n",
    "# 'https://aging.depotdrug.com', RETURNS CONNECTIONERROR\n",
    " 'https://www.usmed-rx.com',\n",
    " 'https://www.vascorx.com',\n",
    "# 'https://rescriptions.wakehealth.edu', RETURNS CONNECTIONERROR\n",
    " 'https://www.walmart.com/cp/pharmacy/5431',\n",
    " 'https://www.walgreens.com',\n",
    "# 'https://www.weismarkets.com', RETURNS RESPONSE: 403\n",
    " 'https://www.welldynerx.com',\n",
    " 'https://www.yourrxpharmacy.com']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "cdb2acd1-80ca-46a3-9796-a5cb2cb01767",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "cdb2acd1-80ca-46a3-9796-a5cb2cb01767",
    "outputId": "361c2e06-3b01-47b0-867a-1426b23dd182"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "### test\n",
    "\n",
    "website = 'https://acariahealth.envolvehealth.com'\n",
    "headers = {'user-agent': 'ds6050 (fdf7gn@virginia.edu)'}\n",
    "r = requests.get(website, headers=headers)\n",
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "b7a94660-03a3-487f-98dd-15da15b698bd",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 36
    },
    "id": "b7a94660-03a3-487f-98dd-15da15b698bd",
    "outputId": "9b911de1-e7a6-41e4-b98e-07c8db96b904"
   },
   "outputs": [
    {
     "data": {
      "application/vnd.google.colaboratory.intrinsic+json": {
       "type": "string"
      },
      "text/plain": [
       "'https://acariahealth.envolvehealth.com'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def good_urls(url):\n",
    "    headers = {'user-agent': 'ds6050 (fdf7gn@virginia.edu)'}\n",
    "    r = requests.get(url, headers=headers)\n",
    "    #print(r)\n",
    "    if r.status_code == 200:\n",
    "        return url \n",
    "\n",
    "good_urls(website)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8968e5e4-ad4c-43f5-8c41-b466f4733295",
   "metadata": {
    "id": "8968e5e4-ad4c-43f5-8c41-b466f4733295"
   },
   "outputs": [],
   "source": [
    "url_list = []\n",
    "for d in d1:\n",
    "    links = good_urls(d)\n",
    "    url_list.append(links)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7ffdadaf-fb6b-4d09-b3fd-2e244db5793d",
   "metadata": {
    "id": "7ffdadaf-fb6b-4d09-b3fd-2e244db5793d"
   },
   "source": [
    "Creates a list of urls that actually work"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "10299398-89c2-453f-b283-426a92dd94fe",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "10299398-89c2-453f-b283-426a92dd94fe",
    "outputId": "93a8f413-ac0e-4c4f-9d11-4abed173f542"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://acariahealth.envolvehealth.com',\n",
       " 'https://www.accredo.pharmacy',\n",
       " 'https://www.alphascriptrx.com',\n",
       " 'https://alto.com',\n",
       " 'https://www.amberpharmacy.com',\n",
       " 'https://www.aoncology.com',\n",
       " 'https://www.citizenpharmacy.com',\n",
       " 'https://www.bioplusrx.com',\n",
       " 'https://www.birdirx.com',\n",
       " 'https://www.cornerstonehealthsolutions.org',\n",
       " 'https://www.cfspharmacy.pharmacy',\n",
       " 'https://www.caremark.com',\n",
       " 'https://www.carepointrx.com',\n",
       " 'https://www.centerwellpharmacy.com',\n",
       " 'https://www.carolinacarerx.org',\n",
       " 'https://www.curanthealth.com',\n",
       " 'https://www.ccsmed.com',\n",
       " 'https://www.divvydose.com',\n",
       " 'https://www.friendswoodhealthmartpharmacy.com',\n",
       " 'https://eaglepharmacy.com',\n",
       " 'https://www.express-scripts.com',\n",
       " 'https://www.essentiahealth.org',\n",
       " 'https://www.ecspecialtyrx.com',\n",
       " 'https://gentryhealthservices.com',\n",
       " 'https://www.dfwwellnesspharmacy.com',\n",
       " 'https://www.hometownpharmacy.com',\n",
       " 'https://www.healthwarehouse.com',\n",
       " 'https://www.hy-vee.com',\n",
       " 'https://www.hvrxsolutions.com',\n",
       " 'https://intermountainhealthcare.org/services/pharmacy',\n",
       " 'https://www.magellanrx.pharmacy',\n",
       " 'https://www.medimpact.com',\n",
       " 'https://www.geniusrx.com',\n",
       " 'https://www.thepillclub.com',\n",
       " 'https://www.northcoastmed.com',\n",
       " 'https://www.onco360.com',\n",
       " 'https://www.optumrx.com',\n",
       " 'https://www.orsinihealthcare.com',\n",
       " 'https://www.pantherxrare.com',\n",
       " 'https://www.mintrxpharmacy.com',\n",
       " 'https://www.amazon.com',\n",
       " 'https://www.powerhousepharmacy.com',\n",
       " 'https://www.ridgeway.pharmacy',\n",
       " 'https://www.blueskyspecialtypharmacy.com',\n",
       " 'https://www.rxoutreach.org',\n",
       " 'https://www.flcancer.com',\n",
       " 'https://www.stpeterscommunitypharmacy.com',\n",
       " 'https://www.schrafts2.com',\n",
       " 'https://www.scriptsrxpharmacy.com',\n",
       " 'https://www.senderrarx.com',\n",
       " 'https://www.solerarx.com',\n",
       " 'https://www.sortpak.com',\n",
       " 'https://www.synergenrx.com',\n",
       " 'https://metrohealth.org/pharmacy',\n",
       " 'https://mylocalrx.org',\n",
       " 'https://www.hopesp.com',\n",
       " 'https://www.medicorx.com',\n",
       " 'https://www.usmed-rx.com',\n",
       " 'https://www.vascorx.com',\n",
       " 'https://www.walmart.com/cp/pharmacy/5431',\n",
       " 'https://www.walgreens.com',\n",
       " 'https://www.welldynerx.com',\n",
       " 'https://www.yourrxpharmacy.com']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url_list"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "af2387e5-2fe6-4413-ac9a-e259bc79d019",
   "metadata": {
    "id": "af2387e5-2fe6-4413-ac9a-e259bc79d019"
   },
   "source": [
    "### Loop through url_list to scrape text & images "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ab143b0b",
   "metadata": {
    "id": "ab143b0b"
   },
   "outputs": [],
   "source": [
    "### TEST\n",
    "#url = 'https://acariahealth.envolvehealth.com' #'https://www.carolinacarerx.org'\n",
    "#image_url = 'https://www.carolinacarerx.org'\n",
    "\n",
    "def url_to_df(url):\n",
    "    try:\n",
    "        html = urlopen(url)\n",
    "        headers = {'user-agent': 'Mozilla/5.0'}\n",
    "        page = requests.get(url, headers)\n",
    "        soup = BeautifulSoup(page.content,'html.parser')\n",
    "        body = soup.body\n",
    "        header = soup.header\n",
    "        footer = soup.footer\n",
    "        \n",
    "        head = []\n",
    "        for h in header.strings:\n",
    "            head.append(h)\n",
    "        \n",
    "        foot = []\n",
    "        for f in footer.strings:\n",
    "            foot.append(f)\n",
    "        \n",
    "        text = []\n",
    "        for s in body.strings:\n",
    "            text.append(s)\n",
    "        \n",
    "        images = []    \n",
    "        for item in soup.find_all('img'):\n",
    "            images.append(url + item['src'])\n",
    "    \n",
    "        image2 = []\n",
    "        for item in soup.find_all('img'):\n",
    "            image2.append(item['src'])\n",
    "        \n",
    "        url_df = pd.DataFrame(data= {'url':[url],'text':[text], 'header':[head],'footer':[foot],\n",
    "                                     'image_url':[images], 'image_source':[image2]})\n",
    "        return url_df\n",
    "    except: \n",
    "        pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ef2b49b2",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "ef2b49b2",
    "outputId": "7a5e91aa-3ef3-46f3-947b-6f54df175f0c"
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "WARNING:bs4.dammit:Some characters could not be decoded, and were replaced with REPLACEMENT CHARACTER.\n"
     ]
    }
   ],
   "source": [
    "df = pd.DataFrame()\n",
    "\n",
    "for u in url_list:\n",
    "    dictObj =url_to_df(u)\n",
    "    df = df.append(dictObj) # can we suppress/ignore the deprecation messages ??"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "30e19ef7-bd3e-4a46-95e3-22f8c237386b",
   "metadata": {
    "id": "30e19ef7-bd3e-4a46-95e3-22f8c237386b"
   },
   "outputs": [],
   "source": [
    "# df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "9a02cd21-5071-4994-9fef-901ee9a4f434",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 1000
    },
    "id": "9a02cd21-5071-4994-9fef-901ee9a4f434",
    "outputId": "03bf2cbc-01c9-4945-fdc3-f545171679d0"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"df-0c15851f-d08a-405e-9da4-58ce4db2f0bd\">\n",
       "    <div class=\"colab-df-container\">\n",
       "      <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>index</th>\n",
       "      <th>url</th>\n",
       "      <th>text</th>\n",
       "      <th>header</th>\n",
       "      <th>footer</th>\n",
       "      <th>image_url</th>\n",
       "      <th>image_source</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>https://acariahealth.envolvehealth.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n]</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...</td>\n",
       "      <td>[https://acariahealth.envolvehealth.com/conten...</td>\n",
       "      <td>[/content/dam/centene/envolve-pharmacy-solutio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.accredo.pharmacy</td>\n",
       "      <td>[\\n, \\n            Skip to main content\\n     ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...</td>\n",
       "      <td>[https://www.accredo.pharmacyhttps://esi-drupa...</td>\n",
       "      <td>[https://esi-drupal-cdn.s3.amazonaws.com/accre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.alphascriptrx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.alphascriptrx.comdata:image/gif;b...</td>\n",
       "      <td>[data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.aoncology.com</td>\n",
       "      <td>[\\n, \\n    &lt;div class=\"wpautoterms-update-noti...</td>\n",
       "      <td>[\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...</td>\n",
       "      <td>[\\n, \\n, © 2020 American Oncology Network, LLC...</td>\n",
       "      <td>[https://www.aoncology.comhttps://dc.ads.linke...</td>\n",
       "      <td>[https://dc.ads.linkedin.com/collect/?pid=9449...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.cornerstonehealthsolutions.org</td>\n",
       "      <td>[\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...</td>\n",
       "      <td>[https://www.cornerstonehealthsolutions.org/th...</td>\n",
       "      <td>[/themes/contrib/emulsify/images/logos/logo.sv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.curanthealth.com</td>\n",
       "      <td>[\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...</td>\n",
       "      <td>[\\n, \\n, \\n, Terms &amp; Conditions, \\n, Web Polic...</td>\n",
       "      <td>[https://www.curanthealth.comhttps://curanthea...</td>\n",
       "      <td>[https://curanthealth.com/wp-content/uploads/2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.friendswoodhealthmartpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>https://eaglepharmacy.com</td>\n",
       "      <td>[\\n, \\n, We are currently experiencing issues ...</td>\n",
       "      <td>[We are currently experiencing issues with our...</td>\n",
       "      <td>[Refills, Forms, Help (FAQ), Medication Dispos...</td>\n",
       "      <td>[https://eaglepharmacy.comhttps://global-uploa...</td>\n",
       "      <td>[https://global-uploads.webflow.com/59516e6b55...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.express-scripts.com</td>\n",
       "      <td>[ ,  Skip to main content ,  , Menu,  ,  ,  , ...</td>\n",
       "      <td>[ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...</td>\n",
       "      <td>[ , About Us,  , Careers,  , Corporate Site,  ...</td>\n",
       "      <td>[https://www.express-scripts.com/themes/custom...</td>\n",
       "      <td>[/themes/custom/dsf/img/ui/1x1-transparent.gif...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.essentiahealth.org</td>\n",
       "      <td>[\\n, \\n,  COVID-19 Update, \\n, Masks must stil...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...</td>\n",
       "      <td>[\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...</td>\n",
       "      <td>[https://www.essentiahealth.org/app/files/publ...</td>\n",
       "      <td>[/app/files/public/2897/Essentia-Health-Logo.s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.dfwwellnesspharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.comhttps://ww...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.com/wp-conten...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0</td>\n",
       "      <td>https://intermountainhealthcare.org/services/p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]</td>\n",
       "      <td>[https://intermountainhealthcare.org/services/...</td>\n",
       "      <td>[/-/media/images/global/1-1/woman-on-a-laptop....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.geniusrx.com</td>\n",
       "      <td>[\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...</td>\n",
       "      <td>[\\n, \\n, \\n, Looking to save up to 80% on your...</td>\n",
       "      <td>[\\n, \\n, GeniusRx is a licensed and accredited...</td>\n",
       "      <td>[https://www.geniusrx.com/assets/images/genius...</td>\n",
       "      <td>[/assets/images/geniusrx-logo.png, /assets/ima...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.orsinihealthcare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[https://www.orsinihealthcare.comhttps://www.o...</td>\n",
       "      <td>[https://www.orsinispecialtypharmacy.com/hs-fs...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.pantherxrare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.pantherxrare.comhttps://www.panth...</td>\n",
       "      <td>[https://www.pantherxrare.com/wp-content/theme...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.mintrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...</td>\n",
       "      <td>[\\n, Skip to main content, \\n, Skip to footer ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...</td>\n",
       "      <td>[https://www.mintrxpharmacy.comhttps://www.fac...</td>\n",
       "      <td>[https://www.facebook.com/tr?id=19764215183921...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.flcancer.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.flcancer.comhttps://flcancer.com/...</td>\n",
       "      <td>[https://flcancer.com/app/uploads/2021/06/2017...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.scriptsrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...</td>\n",
       "      <td>[ABOUT US, Our Pharmacy, Locations, Careers, C...</td>\n",
       "      <td>[https://www.scriptsrxpharmacy.comhttps://stat...</td>\n",
       "      <td>[https://static.wixstatic.com/media/f44edb_33a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.senderrarx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to the main content....</td>\n",
       "      <td>[\\n, \\n, \\n, Skip to the main content., \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.senderrarx.comhttps://www.senderr...</td>\n",
       "      <td>[https://www.senderrarx.com/hs-fs/hubfs/Sender...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.synergenrx.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Home, Specialties, Providers, Patients, Pharm...</td>\n",
       "      <td>[Contact info, \\n,                     , \\n, A...</td>\n",
       "      <td>[https://www.synergenrx.comhttps://static.wixs...</td>\n",
       "      <td>[https://static.wixstatic.com/media/35816e_e98...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>https://mylocalrx.org</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...</td>\n",
       "      <td>[\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://mylocalrx.orghttps://www.trilliumheal...</td>\n",
       "      <td>[https://www.trilliumhealth.pharmacy/images/lo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.vascorx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...</td>\n",
       "      <td>[https://www.vascorx.comhttps://vascorx.com/wp...</td>\n",
       "      <td>[https://vascorx.com/wp-content/themes/vascorx...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.walgreens.com</td>\n",
       "      <td>[\\n, \\n                Skip to main content\\n ...</td>\n",
       "      <td>[\\r\\n  .global_nav_text {\\r\\n    /*font-family...</td>\n",
       "      <td>[Enter email for weekly deals, Sign up,  ,  , ...</td>\n",
       "      <td>[https://www.walgreens.com/images/adaptive/sp/...</td>\n",
       "      <td>[/images/adaptive/sp/giftbox_22x20.png, data:i...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>\n",
       "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0c15851f-d08a-405e-9da4-58ce4db2f0bd')\"\n",
       "              title=\"Convert this dataframe to an interactive table.\"\n",
       "              style=\"display:none;\">\n",
       "        \n",
       "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
       "       width=\"24px\">\n",
       "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
       "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
       "  </svg>\n",
       "      </button>\n",
       "      \n",
       "  <style>\n",
       "    .colab-df-container {\n",
       "      display:flex;\n",
       "      flex-wrap:wrap;\n",
       "      gap: 12px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert {\n",
       "      background-color: #E8F0FE;\n",
       "      border: none;\n",
       "      border-radius: 50%;\n",
       "      cursor: pointer;\n",
       "      display: none;\n",
       "      fill: #1967D2;\n",
       "      height: 32px;\n",
       "      padding: 0 0 0 0;\n",
       "      width: 32px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert:hover {\n",
       "      background-color: #E2EBFA;\n",
       "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
       "      fill: #174EA6;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert {\n",
       "      background-color: #3B4455;\n",
       "      fill: #D2E3FC;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert:hover {\n",
       "      background-color: #434B5C;\n",
       "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
       "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
       "      fill: #FFFFFF;\n",
       "    }\n",
       "  </style>\n",
       "\n",
       "      <script>\n",
       "        const buttonEl =\n",
       "          document.querySelector('#df-0c15851f-d08a-405e-9da4-58ce4db2f0bd button.colab-df-convert');\n",
       "        buttonEl.style.display =\n",
       "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
       "\n",
       "        async function convertToInteractive(key) {\n",
       "          const element = document.querySelector('#df-0c15851f-d08a-405e-9da4-58ce4db2f0bd');\n",
       "          const dataTable =\n",
       "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
       "                                                     [key], {});\n",
       "          if (!dataTable) return;\n",
       "\n",
       "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
       "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
       "            + ' to learn more about interactive tables.';\n",
       "          element.innerHTML = '';\n",
       "          dataTable['output_type'] = 'display_data';\n",
       "          await google.colab.output.renderOutput(dataTable, element);\n",
       "          const docLink = document.createElement('div');\n",
       "          docLink.innerHTML = docLinkHtml;\n",
       "          element.appendChild(docLink);\n",
       "        }\n",
       "      </script>\n",
       "    </div>\n",
       "  </div>\n",
       "  "
      ],
      "text/plain": [
       "    index                                                url  \\\n",
       "0       0             https://acariahealth.envolvehealth.com   \n",
       "1       0                       https://www.accredo.pharmacy   \n",
       "2       0                      https://www.alphascriptrx.com   \n",
       "3       0                          https://www.aoncology.com   \n",
       "4       0         https://www.cornerstonehealthsolutions.org   \n",
       "5       0                       https://www.curanthealth.com   \n",
       "6       0      https://www.friendswoodhealthmartpharmacy.com   \n",
       "7       0                          https://eaglepharmacy.com   \n",
       "8       0                    https://www.express-scripts.com   \n",
       "9       0                     https://www.essentiahealth.org   \n",
       "10      0                https://www.dfwwellnesspharmacy.com   \n",
       "11      0  https://intermountainhealthcare.org/services/p...   \n",
       "12      0                           https://www.geniusrx.com   \n",
       "13      0                   https://www.orsinihealthcare.com   \n",
       "14      0                       https://www.pantherxrare.com   \n",
       "15      0                     https://www.mintrxpharmacy.com   \n",
       "16      0                           https://www.flcancer.com   \n",
       "17      0                  https://www.scriptsrxpharmacy.com   \n",
       "18      0                         https://www.senderrarx.com   \n",
       "19      0                         https://www.synergenrx.com   \n",
       "20      0                              https://mylocalrx.org   \n",
       "21      0                            https://www.vascorx.com   \n",
       "22      0                          https://www.walgreens.com   \n",
       "\n",
       "                                                 text  \\\n",
       "0                                    [\\n, \\n, \\n, \\n]   \n",
       "1   [\\n, \\n            Skip to main content\\n     ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...   \n",
       "3   [\\n, \\n    <div class=\"wpautoterms-update-noti...   \n",
       "4   [\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...   \n",
       "5   [\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...   \n",
       "6   [\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...   \n",
       "7   [\\n, \\n, We are currently experiencing issues ...   \n",
       "8   [ ,  Skip to main content ,  , Menu,  ,  ,  , ...   \n",
       "9   [\\n, \\n,  COVID-19 Update, \\n, Masks must stil...   \n",
       "10  [\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...   \n",
       "12  [\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...   \n",
       "17  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, Skip to the main content....   \n",
       "19  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "22  [\\n, \\n                Skip to main content\\n ...   \n",
       "\n",
       "                                               header  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...   \n",
       "3   [\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...   \n",
       "4   [\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...   \n",
       "5   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...   \n",
       "7   [We are currently experiencing issues with our...   \n",
       "8   [ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...   \n",
       "9   [\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "12  [\\n, \\n, \\n, Looking to save up to 80% on your...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, Skip to main content, \\n, Skip to footer ...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...   \n",
       "18  [\\n, \\n, \\n, Skip to the main content., \\n, \\n...   \n",
       "19  [Home, Specialties, Providers, Patients, Pharm...   \n",
       "20  [\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...   \n",
       "22  [\\r\\n  .global_nav_text {\\r\\n    /*font-family...   \n",
       "\n",
       "                                               footer  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "3   [\\n, \\n, © 2020 American Oncology Network, LLC...   \n",
       "4   [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...   \n",
       "5   [\\n, \\n, \\n, Terms & Conditions, \\n, Web Polic...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...   \n",
       "7   [Refills, Forms, Help (FAQ), Medication Dispos...   \n",
       "8   [ , About Us,  , Careers,  , Corporate Site,  ...   \n",
       "9   [\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...   \n",
       "11               [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]   \n",
       "12  [\\n, \\n, GeniusRx is a licensed and accredited...   \n",
       "13  [\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [ABOUT US, Our Pharmacy, Locations, Careers, C...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "19  [Contact info, \\n,                     , \\n, A...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...   \n",
       "22  [Enter email for weekly deals, Sign up,  ,  , ...   \n",
       "\n",
       "                                            image_url  \\\n",
       "0   [https://acariahealth.envolvehealth.com/conten...   \n",
       "1   [https://www.accredo.pharmacyhttps://esi-drupa...   \n",
       "2   [https://www.alphascriptrx.comdata:image/gif;b...   \n",
       "3   [https://www.aoncology.comhttps://dc.ads.linke...   \n",
       "4   [https://www.cornerstonehealthsolutions.org/th...   \n",
       "5   [https://www.curanthealth.comhttps://curanthea...   \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...   \n",
       "7   [https://eaglepharmacy.comhttps://global-uploa...   \n",
       "8   [https://www.express-scripts.com/themes/custom...   \n",
       "9   [https://www.essentiahealth.org/app/files/publ...   \n",
       "10  [https://www.dfwwellnesspharmacy.comhttps://ww...   \n",
       "11  [https://intermountainhealthcare.org/services/...   \n",
       "12  [https://www.geniusrx.com/assets/images/genius...   \n",
       "13  [https://www.orsinihealthcare.comhttps://www.o...   \n",
       "14  [https://www.pantherxrare.comhttps://www.panth...   \n",
       "15  [https://www.mintrxpharmacy.comhttps://www.fac...   \n",
       "16  [https://www.flcancer.comhttps://flcancer.com/...   \n",
       "17  [https://www.scriptsrxpharmacy.comhttps://stat...   \n",
       "18  [https://www.senderrarx.comhttps://www.senderr...   \n",
       "19  [https://www.synergenrx.comhttps://static.wixs...   \n",
       "20  [https://mylocalrx.orghttps://www.trilliumheal...   \n",
       "21  [https://www.vascorx.comhttps://vascorx.com/wp...   \n",
       "22  [https://www.walgreens.com/images/adaptive/sp/...   \n",
       "\n",
       "                                         image_source  \n",
       "0   [/content/dam/centene/envolve-pharmacy-solutio...  \n",
       "1   [https://esi-drupal-cdn.s3.amazonaws.com/accre...  \n",
       "2   [data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...  \n",
       "3   [https://dc.ads.linkedin.com/collect/?pid=9449...  \n",
       "4   [/themes/contrib/emulsify/images/logos/logo.sv...  \n",
       "5   [https://curanthealth.com/wp-content/uploads/2...  \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...  \n",
       "7   [https://global-uploads.webflow.com/59516e6b55...  \n",
       "8   [/themes/custom/dsf/img/ui/1x1-transparent.gif...  \n",
       "9   [/app/files/public/2897/Essentia-Health-Logo.s...  \n",
       "10  [https://www.dfwwellnesspharmacy.com/wp-conten...  \n",
       "11  [/-/media/images/global/1-1/woman-on-a-laptop....  \n",
       "12  [/assets/images/geniusrx-logo.png, /assets/ima...  \n",
       "13  [https://www.orsinispecialtypharmacy.com/hs-fs...  \n",
       "14  [https://www.pantherxrare.com/wp-content/theme...  \n",
       "15  [https://www.facebook.com/tr?id=19764215183921...  \n",
       "16  [https://flcancer.com/app/uploads/2021/06/2017...  \n",
       "17  [https://static.wixstatic.com/media/f44edb_33a...  \n",
       "18  [https://www.senderrarx.com/hs-fs/hubfs/Sender...  \n",
       "19  [https://static.wixstatic.com/media/35816e_e98...  \n",
       "20  [https://www.trilliumhealth.pharmacy/images/lo...  \n",
       "21  [https://vascorx.com/wp-content/themes/vascorx...  \n",
       "22  [/images/adaptive/sp/giftbox_22x20.png, data:i...  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.reset_index()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "JAv4Y-cq9s1T",
   "metadata": {
    "id": "JAv4Y-cq9s1T"
   },
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import io\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import http.client\n",
    "import mimetypes\n",
    "import json\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "CuXbd67w92m5",
   "metadata": {
    "id": "CuXbd67w92m5"
   },
   "outputs": [],
   "source": [
    "def zipLookup(zcode):\n",
    "  root = ET.Element(\"CityStateLookupRequest\", USERID=\"847WIPRO1073\")\n",
    "  m1 = ET.SubElement(root, \"ZipCode\", ID=\"0\")\n",
    "  ET.SubElement(m1, \"Zip5\").text = zcode\n",
    "  tree = ET.ElementTree(root)\n",
    "  out = io.BytesIO()\n",
    "  tree.write(out)\n",
    "  zip_xml = out.getvalue().decode()\n",
    "  site = f\"https://secure.shippingapis.com/ShippingAPITest.dll?API=CityStateLookup&XML={zip_xml}\"\n",
    "  response = requests.get(site)\n",
    "  r = BeautifulSoup(response.text, 'html')\n",
    "  city = r.find_all('city')\n",
    "  #print(city)\n",
    "  if not city:\n",
    "     z = 'no'\n",
    "  else:\n",
    "     z = 'yes'\n",
    "  return z"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "vxRObAkb948J",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 1000
    },
    "id": "vxRObAkb948J",
    "outputId": "51735d63-bdc0-42f3-f784-2c805421e36c"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"df-7fb8ad5b-fc64-4e6d-95da-955ad3df6284\">\n",
       "    <div class=\"colab-df-container\">\n",
       "      <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>index</th>\n",
       "      <th>url</th>\n",
       "      <th>text</th>\n",
       "      <th>header</th>\n",
       "      <th>footer</th>\n",
       "      <th>image_url</th>\n",
       "      <th>image_source</th>\n",
       "      <th>html</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>https://acariahealth.envolvehealth.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n]</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...</td>\n",
       "      <td>[https://acariahealth.envolvehealth.com/conten...</td>\n",
       "      <td>[/content/dam/centene/envolve-pharmacy-solutio...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Locat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.accredo.pharmacy</td>\n",
       "      <td>[\\n, \\n            Skip to main content\\n     ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...</td>\n",
       "      <td>[https://www.accredo.pharmacyhttps://esi-drupa...</td>\n",
       "      <td>[https://esi-drupal-cdn.s3.amazonaws.com/accre...</td>\n",
       "      <td>[\\n, \\n            Skip to main content\\n     ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.alphascriptrx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.alphascriptrx.comdata:image/gif;b...</td>\n",
       "      <td>[data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.aoncology.com</td>\n",
       "      <td>[\\n, \\n    &lt;div class=\"wpautoterms-update-noti...</td>\n",
       "      <td>[\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...</td>\n",
       "      <td>[\\n, \\n, © 2020 American Oncology Network, LLC...</td>\n",
       "      <td>[https://www.aoncology.comhttps://dc.ads.linke...</td>\n",
       "      <td>[https://dc.ads.linkedin.com/collect/?pid=9449...</td>\n",
       "      <td>[\\n, \\n    &lt;div class=\"wpautoterms-update-noti...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.cornerstonehealthsolutions.org</td>\n",
       "      <td>[\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...</td>\n",
       "      <td>[https://www.cornerstonehealthsolutions.org/th...</td>\n",
       "      <td>[/themes/contrib/emulsify/images/logos/logo.sv...</td>\n",
       "      <td>[\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.curanthealth.com</td>\n",
       "      <td>[\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...</td>\n",
       "      <td>[\\n, \\n, \\n, Terms &amp; Conditions, \\n, Web Polic...</td>\n",
       "      <td>[https://www.curanthealth.comhttps://curanthea...</td>\n",
       "      <td>[https://curanthealth.com/wp-content/uploads/2...</td>\n",
       "      <td>[\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.friendswoodhealthmartpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "      <td>[\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>https://eaglepharmacy.com</td>\n",
       "      <td>[\\n, \\n, We are currently experiencing issues ...</td>\n",
       "      <td>[We are currently experiencing issues with our...</td>\n",
       "      <td>[Refills, Forms, Help (FAQ), Medication Dispos...</td>\n",
       "      <td>[https://eaglepharmacy.comhttps://global-uploa...</td>\n",
       "      <td>[https://global-uploads.webflow.com/59516e6b55...</td>\n",
       "      <td>[\\n, \\n, We are currently experiencing issues ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.express-scripts.com</td>\n",
       "      <td>[ ,  Skip to main content ,  , Menu,  ,  ,  , ...</td>\n",
       "      <td>[ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...</td>\n",
       "      <td>[ , About Us,  , Careers,  , Corporate Site,  ...</td>\n",
       "      <td>[https://www.express-scripts.com/themes/custom...</td>\n",
       "      <td>[/themes/custom/dsf/img/ui/1x1-transparent.gif...</td>\n",
       "      <td>[ ,  Skip to main content ,  , Menu,  ,  ,  , ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.essentiahealth.org</td>\n",
       "      <td>[\\n, \\n,  COVID-19 Update, \\n, Masks must stil...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...</td>\n",
       "      <td>[\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...</td>\n",
       "      <td>[https://www.essentiahealth.org/app/files/publ...</td>\n",
       "      <td>[/app/files/public/2897/Essentia-Health-Logo.s...</td>\n",
       "      <td>[\\n, \\n,  COVID-19 Update, \\n, Masks must stil...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.dfwwellnesspharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.comhttps://ww...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.com/wp-conten...</td>\n",
       "      <td>[\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0</td>\n",
       "      <td>https://intermountainhealthcare.org/services/p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]</td>\n",
       "      <td>[https://intermountainhealthcare.org/services/...</td>\n",
       "      <td>[/-/media/images/global/1-1/woman-on-a-laptop....</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.geniusrx.com</td>\n",
       "      <td>[\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...</td>\n",
       "      <td>[\\n, \\n, \\n, Looking to save up to 80% on your...</td>\n",
       "      <td>[\\n, \\n, GeniusRx is a licensed and accredited...</td>\n",
       "      <td>[https://www.geniusrx.com/assets/images/genius...</td>\n",
       "      <td>[/assets/images/geniusrx-logo.png, /assets/ima...</td>\n",
       "      <td>[\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.orsinihealthcare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[https://www.orsinihealthcare.comhttps://www.o...</td>\n",
       "      <td>[https://www.orsinispecialtypharmacy.com/hs-fs...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.pantherxrare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.pantherxrare.comhttps://www.panth...</td>\n",
       "      <td>[https://www.pantherxrare.com/wp-content/theme...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.mintrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...</td>\n",
       "      <td>[\\n, Skip to main content, \\n, Skip to footer ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...</td>\n",
       "      <td>[https://www.mintrxpharmacy.comhttps://www.fac...</td>\n",
       "      <td>[https://www.facebook.com/tr?id=19764215183921...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.flcancer.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.flcancer.comhttps://flcancer.com/...</td>\n",
       "      <td>[https://flcancer.com/app/uploads/2021/06/2017...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.scriptsrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...</td>\n",
       "      <td>[ABOUT US, Our Pharmacy, Locations, Careers, C...</td>\n",
       "      <td>[https://www.scriptsrxpharmacy.comhttps://stat...</td>\n",
       "      <td>[https://static.wixstatic.com/media/f44edb_33a...</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.senderrarx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to the main content....</td>\n",
       "      <td>[\\n, \\n, \\n, Skip to the main content., \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.senderrarx.comhttps://www.senderr...</td>\n",
       "      <td>[https://www.senderrarx.com/hs-fs/hubfs/Sender...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to the main content....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.synergenrx.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Home, Specialties, Providers, Patients, Pharm...</td>\n",
       "      <td>[Contact info, \\n,                     , \\n, A...</td>\n",
       "      <td>[https://www.synergenrx.comhttps://static.wixs...</td>\n",
       "      <td>[https://static.wixstatic.com/media/35816e_e98...</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>https://mylocalrx.org</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...</td>\n",
       "      <td>[\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://mylocalrx.orghttps://www.trilliumheal...</td>\n",
       "      <td>[https://www.trilliumhealth.pharmacy/images/lo...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.vascorx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...</td>\n",
       "      <td>[https://www.vascorx.comhttps://vascorx.com/wp...</td>\n",
       "      <td>[https://vascorx.com/wp-content/themes/vascorx...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.walgreens.com</td>\n",
       "      <td>[\\n, \\n                Skip to main content\\n ...</td>\n",
       "      <td>[\\r\\n  .global_nav_text {\\r\\n    /*font-family...</td>\n",
       "      <td>[Enter email for weekly deals, Sign up,  ,  , ...</td>\n",
       "      <td>[https://www.walgreens.com/images/adaptive/sp/...</td>\n",
       "      <td>[/images/adaptive/sp/giftbox_22x20.png, data:i...</td>\n",
       "      <td>[\\n, \\n                Skip to main content\\n ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>\n",
       "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7fb8ad5b-fc64-4e6d-95da-955ad3df6284')\"\n",
       "              title=\"Convert this dataframe to an interactive table.\"\n",
       "              style=\"display:none;\">\n",
       "        \n",
       "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
       "       width=\"24px\">\n",
       "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
       "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
       "  </svg>\n",
       "      </button>\n",
       "      \n",
       "  <style>\n",
       "    .colab-df-container {\n",
       "      display:flex;\n",
       "      flex-wrap:wrap;\n",
       "      gap: 12px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert {\n",
       "      background-color: #E8F0FE;\n",
       "      border: none;\n",
       "      border-radius: 50%;\n",
       "      cursor: pointer;\n",
       "      display: none;\n",
       "      fill: #1967D2;\n",
       "      height: 32px;\n",
       "      padding: 0 0 0 0;\n",
       "      width: 32px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert:hover {\n",
       "      background-color: #E2EBFA;\n",
       "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
       "      fill: #174EA6;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert {\n",
       "      background-color: #3B4455;\n",
       "      fill: #D2E3FC;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert:hover {\n",
       "      background-color: #434B5C;\n",
       "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
       "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
       "      fill: #FFFFFF;\n",
       "    }\n",
       "  </style>\n",
       "\n",
       "      <script>\n",
       "        const buttonEl =\n",
       "          document.querySelector('#df-7fb8ad5b-fc64-4e6d-95da-955ad3df6284 button.colab-df-convert');\n",
       "        buttonEl.style.display =\n",
       "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
       "\n",
       "        async function convertToInteractive(key) {\n",
       "          const element = document.querySelector('#df-7fb8ad5b-fc64-4e6d-95da-955ad3df6284');\n",
       "          const dataTable =\n",
       "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
       "                                                     [key], {});\n",
       "          if (!dataTable) return;\n",
       "\n",
       "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
       "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
       "            + ' to learn more about interactive tables.';\n",
       "          element.innerHTML = '';\n",
       "          dataTable['output_type'] = 'display_data';\n",
       "          await google.colab.output.renderOutput(dataTable, element);\n",
       "          const docLink = document.createElement('div');\n",
       "          docLink.innerHTML = docLinkHtml;\n",
       "          element.appendChild(docLink);\n",
       "        }\n",
       "      </script>\n",
       "    </div>\n",
       "  </div>\n",
       "  "
      ],
      "text/plain": [
       "    index                                                url  \\\n",
       "0       0             https://acariahealth.envolvehealth.com   \n",
       "1       0                       https://www.accredo.pharmacy   \n",
       "2       0                      https://www.alphascriptrx.com   \n",
       "3       0                          https://www.aoncology.com   \n",
       "4       0         https://www.cornerstonehealthsolutions.org   \n",
       "5       0                       https://www.curanthealth.com   \n",
       "6       0      https://www.friendswoodhealthmartpharmacy.com   \n",
       "7       0                          https://eaglepharmacy.com   \n",
       "8       0                    https://www.express-scripts.com   \n",
       "9       0                     https://www.essentiahealth.org   \n",
       "10      0                https://www.dfwwellnesspharmacy.com   \n",
       "11      0  https://intermountainhealthcare.org/services/p...   \n",
       "12      0                           https://www.geniusrx.com   \n",
       "13      0                   https://www.orsinihealthcare.com   \n",
       "14      0                       https://www.pantherxrare.com   \n",
       "15      0                     https://www.mintrxpharmacy.com   \n",
       "16      0                           https://www.flcancer.com   \n",
       "17      0                  https://www.scriptsrxpharmacy.com   \n",
       "18      0                         https://www.senderrarx.com   \n",
       "19      0                         https://www.synergenrx.com   \n",
       "20      0                              https://mylocalrx.org   \n",
       "21      0                            https://www.vascorx.com   \n",
       "22      0                          https://www.walgreens.com   \n",
       "\n",
       "                                                 text  \\\n",
       "0                                    [\\n, \\n, \\n, \\n]   \n",
       "1   [\\n, \\n            Skip to main content\\n     ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...   \n",
       "3   [\\n, \\n    <div class=\"wpautoterms-update-noti...   \n",
       "4   [\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...   \n",
       "5   [\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...   \n",
       "6   [\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...   \n",
       "7   [\\n, \\n, We are currently experiencing issues ...   \n",
       "8   [ ,  Skip to main content ,  , Menu,  ,  ,  , ...   \n",
       "9   [\\n, \\n,  COVID-19 Update, \\n, Masks must stil...   \n",
       "10  [\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...   \n",
       "12  [\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...   \n",
       "17  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, Skip to the main content....   \n",
       "19  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "22  [\\n, \\n                Skip to main content\\n ...   \n",
       "\n",
       "                                               header  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...   \n",
       "3   [\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...   \n",
       "4   [\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...   \n",
       "5   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...   \n",
       "7   [We are currently experiencing issues with our...   \n",
       "8   [ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...   \n",
       "9   [\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "12  [\\n, \\n, \\n, Looking to save up to 80% on your...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, Skip to main content, \\n, Skip to footer ...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...   \n",
       "18  [\\n, \\n, \\n, Skip to the main content., \\n, \\n...   \n",
       "19  [Home, Specialties, Providers, Patients, Pharm...   \n",
       "20  [\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...   \n",
       "22  [\\r\\n  .global_nav_text {\\r\\n    /*font-family...   \n",
       "\n",
       "                                               footer  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "3   [\\n, \\n, © 2020 American Oncology Network, LLC...   \n",
       "4   [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...   \n",
       "5   [\\n, \\n, \\n, Terms & Conditions, \\n, Web Polic...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...   \n",
       "7   [Refills, Forms, Help (FAQ), Medication Dispos...   \n",
       "8   [ , About Us,  , Careers,  , Corporate Site,  ...   \n",
       "9   [\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...   \n",
       "11               [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]   \n",
       "12  [\\n, \\n, GeniusRx is a licensed and accredited...   \n",
       "13  [\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [ABOUT US, Our Pharmacy, Locations, Careers, C...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "19  [Contact info, \\n,                     , \\n, A...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...   \n",
       "22  [Enter email for weekly deals, Sign up,  ,  , ...   \n",
       "\n",
       "                                            image_url  \\\n",
       "0   [https://acariahealth.envolvehealth.com/conten...   \n",
       "1   [https://www.accredo.pharmacyhttps://esi-drupa...   \n",
       "2   [https://www.alphascriptrx.comdata:image/gif;b...   \n",
       "3   [https://www.aoncology.comhttps://dc.ads.linke...   \n",
       "4   [https://www.cornerstonehealthsolutions.org/th...   \n",
       "5   [https://www.curanthealth.comhttps://curanthea...   \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...   \n",
       "7   [https://eaglepharmacy.comhttps://global-uploa...   \n",
       "8   [https://www.express-scripts.com/themes/custom...   \n",
       "9   [https://www.essentiahealth.org/app/files/publ...   \n",
       "10  [https://www.dfwwellnesspharmacy.comhttps://ww...   \n",
       "11  [https://intermountainhealthcare.org/services/...   \n",
       "12  [https://www.geniusrx.com/assets/images/genius...   \n",
       "13  [https://www.orsinihealthcare.comhttps://www.o...   \n",
       "14  [https://www.pantherxrare.comhttps://www.panth...   \n",
       "15  [https://www.mintrxpharmacy.comhttps://www.fac...   \n",
       "16  [https://www.flcancer.comhttps://flcancer.com/...   \n",
       "17  [https://www.scriptsrxpharmacy.comhttps://stat...   \n",
       "18  [https://www.senderrarx.comhttps://www.senderr...   \n",
       "19  [https://www.synergenrx.comhttps://static.wixs...   \n",
       "20  [https://mylocalrx.orghttps://www.trilliumheal...   \n",
       "21  [https://www.vascorx.comhttps://vascorx.com/wp...   \n",
       "22  [https://www.walgreens.com/images/adaptive/sp/...   \n",
       "\n",
       "                                         image_source  \\\n",
       "0   [/content/dam/centene/envolve-pharmacy-solutio...   \n",
       "1   [https://esi-drupal-cdn.s3.amazonaws.com/accre...   \n",
       "2   [data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...   \n",
       "3   [https://dc.ads.linkedin.com/collect/?pid=9449...   \n",
       "4   [/themes/contrib/emulsify/images/logos/logo.sv...   \n",
       "5   [https://curanthealth.com/wp-content/uploads/2...   \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...   \n",
       "7   [https://global-uploads.webflow.com/59516e6b55...   \n",
       "8   [/themes/custom/dsf/img/ui/1x1-transparent.gif...   \n",
       "9   [/app/files/public/2897/Essentia-Health-Logo.s...   \n",
       "10  [https://www.dfwwellnesspharmacy.com/wp-conten...   \n",
       "11  [/-/media/images/global/1-1/woman-on-a-laptop....   \n",
       "12  [/assets/images/geniusrx-logo.png, /assets/ima...   \n",
       "13  [https://www.orsinispecialtypharmacy.com/hs-fs...   \n",
       "14  [https://www.pantherxrare.com/wp-content/theme...   \n",
       "15  [https://www.facebook.com/tr?id=19764215183921...   \n",
       "16  [https://flcancer.com/app/uploads/2021/06/2017...   \n",
       "17  [https://static.wixstatic.com/media/f44edb_33a...   \n",
       "18  [https://www.senderrarx.com/hs-fs/hubfs/Sender...   \n",
       "19  [https://static.wixstatic.com/media/35816e_e98...   \n",
       "20  [https://www.trilliumhealth.pharmacy/images/lo...   \n",
       "21  [https://vascorx.com/wp-content/themes/vascorx...   \n",
       "22  [/images/adaptive/sp/giftbox_22x20.png, data:i...   \n",
       "\n",
       "                                                 html  \n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Locat...  \n",
       "1   [\\n, \\n            Skip to main content\\n     ...  \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...  \n",
       "3   [\\n, \\n    <div class=\"wpautoterms-update-noti...  \n",
       "4   [\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...  \n",
       "5   [\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...  \n",
       "6   [\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...  \n",
       "7   [\\n, \\n, We are currently experiencing issues ...  \n",
       "8   [ ,  Skip to main content ,  , Menu,  ,  ,  , ...  \n",
       "9   [\\n, \\n,  COVID-19 Update, \\n, Masks must stil...  \n",
       "10  [\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...  \n",
       "11  [\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...  \n",
       "12  [\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...  \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...  \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...  \n",
       "15  [\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...  \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...  \n",
       "17  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...  \n",
       "18  [\\n, \\n, \\n, \\n, \\n, Skip to the main content....  \n",
       "19  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...  \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...  \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...  \n",
       "22  [\\n, \\n                Skip to main content\\n ...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['html'] = df['text'] + df['footer'] + df['header']\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "bo1AM33S-BoF",
   "metadata": {
    "id": "bo1AM33S-BoF"
   },
   "outputs": [],
   "source": [
    "search=[]\n",
    "for i in df['html']:\n",
    "  k = re.findall('(\\d{5})([- ])?(\\d{4})?', str(i))\n",
    "  \n",
    "  if k:\n",
    "    zip = []\n",
    "    for z in k:\n",
    "      zip.append(zipLookup(z[0]))\n",
    "    if 'yes' in zip:\n",
    "        search.append('yes')\n",
    "    else:\n",
    "        search.append('no')\n",
    "  else:\n",
    "    search.append('no')\n",
    "df['zipcode'] = search \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "JtTsoejAB2H7",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 1000
    },
    "id": "JtTsoejAB2H7",
    "outputId": "7e273c26-be79-41e8-847d-463da76c659e"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"df-cea27a01-9ab6-479c-a1e9-28742ee6a1c7\">\n",
       "    <div class=\"colab-df-container\">\n",
       "      <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>index</th>\n",
       "      <th>url</th>\n",
       "      <th>text</th>\n",
       "      <th>header</th>\n",
       "      <th>footer</th>\n",
       "      <th>image_url</th>\n",
       "      <th>image_source</th>\n",
       "      <th>html</th>\n",
       "      <th>zipcode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>https://acariahealth.envolvehealth.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n]</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...</td>\n",
       "      <td>[https://acariahealth.envolvehealth.com/conten...</td>\n",
       "      <td>[/content/dam/centene/envolve-pharmacy-solutio...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Locat...</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.accredo.pharmacy</td>\n",
       "      <td>[\\n, \\n            Skip to main content\\n     ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...</td>\n",
       "      <td>[https://www.accredo.pharmacyhttps://esi-drupa...</td>\n",
       "      <td>[https://esi-drupal-cdn.s3.amazonaws.com/accre...</td>\n",
       "      <td>[\\n, \\n            Skip to main content\\n     ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.alphascriptrx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.alphascriptrx.comdata:image/gif;b...</td>\n",
       "      <td>[data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.aoncology.com</td>\n",
       "      <td>[\\n, \\n    &lt;div class=\"wpautoterms-update-noti...</td>\n",
       "      <td>[\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...</td>\n",
       "      <td>[\\n, \\n, © 2020 American Oncology Network, LLC...</td>\n",
       "      <td>[https://www.aoncology.comhttps://dc.ads.linke...</td>\n",
       "      <td>[https://dc.ads.linkedin.com/collect/?pid=9449...</td>\n",
       "      <td>[\\n, \\n    &lt;div class=\"wpautoterms-update-noti...</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.cornerstonehealthsolutions.org</td>\n",
       "      <td>[\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...</td>\n",
       "      <td>[https://www.cornerstonehealthsolutions.org/th...</td>\n",
       "      <td>[/themes/contrib/emulsify/images/logos/logo.sv...</td>\n",
       "      <td>[\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.curanthealth.com</td>\n",
       "      <td>[\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...</td>\n",
       "      <td>[\\n, \\n, \\n, Terms &amp; Conditions, \\n, Web Polic...</td>\n",
       "      <td>[https://www.curanthealth.comhttps://curanthea...</td>\n",
       "      <td>[https://curanthealth.com/wp-content/uploads/2...</td>\n",
       "      <td>[\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.friendswoodhealthmartpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "      <td>[\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>https://eaglepharmacy.com</td>\n",
       "      <td>[\\n, \\n, We are currently experiencing issues ...</td>\n",
       "      <td>[We are currently experiencing issues with our...</td>\n",
       "      <td>[Refills, Forms, Help (FAQ), Medication Dispos...</td>\n",
       "      <td>[https://eaglepharmacy.comhttps://global-uploa...</td>\n",
       "      <td>[https://global-uploads.webflow.com/59516e6b55...</td>\n",
       "      <td>[\\n, \\n, We are currently experiencing issues ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.express-scripts.com</td>\n",
       "      <td>[ ,  Skip to main content ,  , Menu,  ,  ,  , ...</td>\n",
       "      <td>[ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...</td>\n",
       "      <td>[ , About Us,  , Careers,  , Corporate Site,  ...</td>\n",
       "      <td>[https://www.express-scripts.com/themes/custom...</td>\n",
       "      <td>[/themes/custom/dsf/img/ui/1x1-transparent.gif...</td>\n",
       "      <td>[ ,  Skip to main content ,  , Menu,  ,  ,  , ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.essentiahealth.org</td>\n",
       "      <td>[\\n, \\n,  COVID-19 Update, \\n, Masks must stil...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...</td>\n",
       "      <td>[\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...</td>\n",
       "      <td>[https://www.essentiahealth.org/app/files/publ...</td>\n",
       "      <td>[/app/files/public/2897/Essentia-Health-Logo.s...</td>\n",
       "      <td>[\\n, \\n,  COVID-19 Update, \\n, Masks must stil...</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.dfwwellnesspharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.comhttps://ww...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.com/wp-conten...</td>\n",
       "      <td>[\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0</td>\n",
       "      <td>https://intermountainhealthcare.org/services/p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]</td>\n",
       "      <td>[https://intermountainhealthcare.org/services/...</td>\n",
       "      <td>[/-/media/images/global/1-1/woman-on-a-laptop....</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.geniusrx.com</td>\n",
       "      <td>[\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...</td>\n",
       "      <td>[\\n, \\n, \\n, Looking to save up to 80% on your...</td>\n",
       "      <td>[\\n, \\n, GeniusRx is a licensed and accredited...</td>\n",
       "      <td>[https://www.geniusrx.com/assets/images/genius...</td>\n",
       "      <td>[/assets/images/geniusrx-logo.png, /assets/ima...</td>\n",
       "      <td>[\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.orsinihealthcare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[https://www.orsinihealthcare.comhttps://www.o...</td>\n",
       "      <td>[https://www.orsinispecialtypharmacy.com/hs-fs...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.pantherxrare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.pantherxrare.comhttps://www.panth...</td>\n",
       "      <td>[https://www.pantherxrare.com/wp-content/theme...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.mintrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...</td>\n",
       "      <td>[\\n, Skip to main content, \\n, Skip to footer ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...</td>\n",
       "      <td>[https://www.mintrxpharmacy.comhttps://www.fac...</td>\n",
       "      <td>[https://www.facebook.com/tr?id=19764215183921...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.flcancer.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.flcancer.comhttps://flcancer.com/...</td>\n",
       "      <td>[https://flcancer.com/app/uploads/2021/06/2017...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.scriptsrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...</td>\n",
       "      <td>[ABOUT US, Our Pharmacy, Locations, Careers, C...</td>\n",
       "      <td>[https://www.scriptsrxpharmacy.comhttps://stat...</td>\n",
       "      <td>[https://static.wixstatic.com/media/f44edb_33a...</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.senderrarx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to the main content....</td>\n",
       "      <td>[\\n, \\n, \\n, Skip to the main content., \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.senderrarx.comhttps://www.senderr...</td>\n",
       "      <td>[https://www.senderrarx.com/hs-fs/hubfs/Sender...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to the main content....</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.synergenrx.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Home, Specialties, Providers, Patients, Pharm...</td>\n",
       "      <td>[Contact info, \\n,                     , \\n, A...</td>\n",
       "      <td>[https://www.synergenrx.comhttps://static.wixs...</td>\n",
       "      <td>[https://static.wixstatic.com/media/35816e_e98...</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>https://mylocalrx.org</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...</td>\n",
       "      <td>[\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://mylocalrx.orghttps://www.trilliumheal...</td>\n",
       "      <td>[https://www.trilliumhealth.pharmacy/images/lo...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.vascorx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...</td>\n",
       "      <td>[https://www.vascorx.comhttps://vascorx.com/wp...</td>\n",
       "      <td>[https://vascorx.com/wp-content/themes/vascorx...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.walgreens.com</td>\n",
       "      <td>[\\n, \\n                Skip to main content\\n ...</td>\n",
       "      <td>[\\r\\n  .global_nav_text {\\r\\n    /*font-family...</td>\n",
       "      <td>[Enter email for weekly deals, Sign up,  ,  , ...</td>\n",
       "      <td>[https://www.walgreens.com/images/adaptive/sp/...</td>\n",
       "      <td>[/images/adaptive/sp/giftbox_22x20.png, data:i...</td>\n",
       "      <td>[\\n, \\n                Skip to main content\\n ...</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>\n",
       "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cea27a01-9ab6-479c-a1e9-28742ee6a1c7')\"\n",
       "              title=\"Convert this dataframe to an interactive table.\"\n",
       "              style=\"display:none;\">\n",
       "        \n",
       "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
       "       width=\"24px\">\n",
       "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
       "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
       "  </svg>\n",
       "      </button>\n",
       "      \n",
       "  <style>\n",
       "    .colab-df-container {\n",
       "      display:flex;\n",
       "      flex-wrap:wrap;\n",
       "      gap: 12px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert {\n",
       "      background-color: #E8F0FE;\n",
       "      border: none;\n",
       "      border-radius: 50%;\n",
       "      cursor: pointer;\n",
       "      display: none;\n",
       "      fill: #1967D2;\n",
       "      height: 32px;\n",
       "      padding: 0 0 0 0;\n",
       "      width: 32px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert:hover {\n",
       "      background-color: #E2EBFA;\n",
       "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
       "      fill: #174EA6;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert {\n",
       "      background-color: #3B4455;\n",
       "      fill: #D2E3FC;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert:hover {\n",
       "      background-color: #434B5C;\n",
       "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
       "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
       "      fill: #FFFFFF;\n",
       "    }\n",
       "  </style>\n",
       "\n",
       "      <script>\n",
       "        const buttonEl =\n",
       "          document.querySelector('#df-cea27a01-9ab6-479c-a1e9-28742ee6a1c7 button.colab-df-convert');\n",
       "        buttonEl.style.display =\n",
       "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
       "\n",
       "        async function convertToInteractive(key) {\n",
       "          const element = document.querySelector('#df-cea27a01-9ab6-479c-a1e9-28742ee6a1c7');\n",
       "          const dataTable =\n",
       "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
       "                                                     [key], {});\n",
       "          if (!dataTable) return;\n",
       "\n",
       "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
       "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
       "            + ' to learn more about interactive tables.';\n",
       "          element.innerHTML = '';\n",
       "          dataTable['output_type'] = 'display_data';\n",
       "          await google.colab.output.renderOutput(dataTable, element);\n",
       "          const docLink = document.createElement('div');\n",
       "          docLink.innerHTML = docLinkHtml;\n",
       "          element.appendChild(docLink);\n",
       "        }\n",
       "      </script>\n",
       "    </div>\n",
       "  </div>\n",
       "  "
      ],
      "text/plain": [
       "    index                                                url  \\\n",
       "0       0             https://acariahealth.envolvehealth.com   \n",
       "1       0                       https://www.accredo.pharmacy   \n",
       "2       0                      https://www.alphascriptrx.com   \n",
       "3       0                          https://www.aoncology.com   \n",
       "4       0         https://www.cornerstonehealthsolutions.org   \n",
       "5       0                       https://www.curanthealth.com   \n",
       "6       0      https://www.friendswoodhealthmartpharmacy.com   \n",
       "7       0                          https://eaglepharmacy.com   \n",
       "8       0                    https://www.express-scripts.com   \n",
       "9       0                     https://www.essentiahealth.org   \n",
       "10      0                https://www.dfwwellnesspharmacy.com   \n",
       "11      0  https://intermountainhealthcare.org/services/p...   \n",
       "12      0                           https://www.geniusrx.com   \n",
       "13      0                   https://www.orsinihealthcare.com   \n",
       "14      0                       https://www.pantherxrare.com   \n",
       "15      0                     https://www.mintrxpharmacy.com   \n",
       "16      0                           https://www.flcancer.com   \n",
       "17      0                  https://www.scriptsrxpharmacy.com   \n",
       "18      0                         https://www.senderrarx.com   \n",
       "19      0                         https://www.synergenrx.com   \n",
       "20      0                              https://mylocalrx.org   \n",
       "21      0                            https://www.vascorx.com   \n",
       "22      0                          https://www.walgreens.com   \n",
       "\n",
       "                                                 text  \\\n",
       "0                                    [\\n, \\n, \\n, \\n]   \n",
       "1   [\\n, \\n            Skip to main content\\n     ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...   \n",
       "3   [\\n, \\n    <div class=\"wpautoterms-update-noti...   \n",
       "4   [\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...   \n",
       "5   [\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...   \n",
       "6   [\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...   \n",
       "7   [\\n, \\n, We are currently experiencing issues ...   \n",
       "8   [ ,  Skip to main content ,  , Menu,  ,  ,  , ...   \n",
       "9   [\\n, \\n,  COVID-19 Update, \\n, Masks must stil...   \n",
       "10  [\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...   \n",
       "12  [\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...   \n",
       "17  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, Skip to the main content....   \n",
       "19  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "22  [\\n, \\n                Skip to main content\\n ...   \n",
       "\n",
       "                                               header  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...   \n",
       "3   [\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...   \n",
       "4   [\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...   \n",
       "5   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...   \n",
       "7   [We are currently experiencing issues with our...   \n",
       "8   [ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...   \n",
       "9   [\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "12  [\\n, \\n, \\n, Looking to save up to 80% on your...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, Skip to main content, \\n, Skip to footer ...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...   \n",
       "18  [\\n, \\n, \\n, Skip to the main content., \\n, \\n...   \n",
       "19  [Home, Specialties, Providers, Patients, Pharm...   \n",
       "20  [\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...   \n",
       "22  [\\r\\n  .global_nav_text {\\r\\n    /*font-family...   \n",
       "\n",
       "                                               footer  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "3   [\\n, \\n, © 2020 American Oncology Network, LLC...   \n",
       "4   [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...   \n",
       "5   [\\n, \\n, \\n, Terms & Conditions, \\n, Web Polic...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...   \n",
       "7   [Refills, Forms, Help (FAQ), Medication Dispos...   \n",
       "8   [ , About Us,  , Careers,  , Corporate Site,  ...   \n",
       "9   [\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...   \n",
       "11               [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]   \n",
       "12  [\\n, \\n, GeniusRx is a licensed and accredited...   \n",
       "13  [\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [ABOUT US, Our Pharmacy, Locations, Careers, C...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "19  [Contact info, \\n,                     , \\n, A...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...   \n",
       "22  [Enter email for weekly deals, Sign up,  ,  , ...   \n",
       "\n",
       "                                            image_url  \\\n",
       "0   [https://acariahealth.envolvehealth.com/conten...   \n",
       "1   [https://www.accredo.pharmacyhttps://esi-drupa...   \n",
       "2   [https://www.alphascriptrx.comdata:image/gif;b...   \n",
       "3   [https://www.aoncology.comhttps://dc.ads.linke...   \n",
       "4   [https://www.cornerstonehealthsolutions.org/th...   \n",
       "5   [https://www.curanthealth.comhttps://curanthea...   \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...   \n",
       "7   [https://eaglepharmacy.comhttps://global-uploa...   \n",
       "8   [https://www.express-scripts.com/themes/custom...   \n",
       "9   [https://www.essentiahealth.org/app/files/publ...   \n",
       "10  [https://www.dfwwellnesspharmacy.comhttps://ww...   \n",
       "11  [https://intermountainhealthcare.org/services/...   \n",
       "12  [https://www.geniusrx.com/assets/images/genius...   \n",
       "13  [https://www.orsinihealthcare.comhttps://www.o...   \n",
       "14  [https://www.pantherxrare.comhttps://www.panth...   \n",
       "15  [https://www.mintrxpharmacy.comhttps://www.fac...   \n",
       "16  [https://www.flcancer.comhttps://flcancer.com/...   \n",
       "17  [https://www.scriptsrxpharmacy.comhttps://stat...   \n",
       "18  [https://www.senderrarx.comhttps://www.senderr...   \n",
       "19  [https://www.synergenrx.comhttps://static.wixs...   \n",
       "20  [https://mylocalrx.orghttps://www.trilliumheal...   \n",
       "21  [https://www.vascorx.comhttps://vascorx.com/wp...   \n",
       "22  [https://www.walgreens.com/images/adaptive/sp/...   \n",
       "\n",
       "                                         image_source  \\\n",
       "0   [/content/dam/centene/envolve-pharmacy-solutio...   \n",
       "1   [https://esi-drupal-cdn.s3.amazonaws.com/accre...   \n",
       "2   [data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...   \n",
       "3   [https://dc.ads.linkedin.com/collect/?pid=9449...   \n",
       "4   [/themes/contrib/emulsify/images/logos/logo.sv...   \n",
       "5   [https://curanthealth.com/wp-content/uploads/2...   \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...   \n",
       "7   [https://global-uploads.webflow.com/59516e6b55...   \n",
       "8   [/themes/custom/dsf/img/ui/1x1-transparent.gif...   \n",
       "9   [/app/files/public/2897/Essentia-Health-Logo.s...   \n",
       "10  [https://www.dfwwellnesspharmacy.com/wp-conten...   \n",
       "11  [/-/media/images/global/1-1/woman-on-a-laptop....   \n",
       "12  [/assets/images/geniusrx-logo.png, /assets/ima...   \n",
       "13  [https://www.orsinispecialtypharmacy.com/hs-fs...   \n",
       "14  [https://www.pantherxrare.com/wp-content/theme...   \n",
       "15  [https://www.facebook.com/tr?id=19764215183921...   \n",
       "16  [https://flcancer.com/app/uploads/2021/06/2017...   \n",
       "17  [https://static.wixstatic.com/media/f44edb_33a...   \n",
       "18  [https://www.senderrarx.com/hs-fs/hubfs/Sender...   \n",
       "19  [https://static.wixstatic.com/media/35816e_e98...   \n",
       "20  [https://www.trilliumhealth.pharmacy/images/lo...   \n",
       "21  [https://vascorx.com/wp-content/themes/vascorx...   \n",
       "22  [/images/adaptive/sp/giftbox_22x20.png, data:i...   \n",
       "\n",
       "                                                 html zipcode  \n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Locat...      no  \n",
       "1   [\\n, \\n            Skip to main content\\n     ...     yes  \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...     yes  \n",
       "3   [\\n, \\n    <div class=\"wpautoterms-update-noti...      no  \n",
       "4   [\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...     yes  \n",
       "5   [\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...     yes  \n",
       "6   [\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...     yes  \n",
       "7   [\\n, \\n, We are currently experiencing issues ...     yes  \n",
       "8   [ ,  Skip to main content ,  , Menu,  ,  ,  , ...     yes  \n",
       "9   [\\n, \\n,  COVID-19 Update, \\n, Masks must stil...      no  \n",
       "10  [\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...     yes  \n",
       "11  [\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...     yes  \n",
       "12  [\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...     yes  \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...     yes  \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...     yes  \n",
       "15  [\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...     yes  \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...      no  \n",
       "17  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...     yes  \n",
       "18  [\\n, \\n, \\n, \\n, \\n, Skip to the main content....     yes  \n",
       "19  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...     yes  \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...      no  \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...     yes  \n",
       "22  [\\n, \\n                Skip to main content\\n ...     yes  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "8lWL5y8I-eFK",
   "metadata": {
    "id": "8lWL5y8I-eFK"
   },
   "outputs": [],
   "source": [
    "import http.client\n",
    "import mimetypes\n",
    "import json\n",
    "def phoneLookup(contact):\n",
    "  conn = http.client.HTTPSConnection(\"api.veriphone.io\")\n",
    "  phone = contact\n",
    "  key = '9FF3B68481994437A10B698E6EB5D5A4'\n",
    "  default_country = '+1'\n",
    "  url = '/v2/verify?phone='+phone+'&key='+key+'&default_country='+default_country\n",
    "  conn.request(\"GET\", url)\n",
    "  res = conn.getresponse()\n",
    "  datajs = res.read()\n",
    "  data = json.loads(datajs.decode(\"utf-8\"))\n",
    "  return data['phone_valid']    \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "1Hz-Tv3z-hPG",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "1Hz-Tv3z-hPG",
    "outputId": "483a1488-6637-4992-f4c7-d026626e7b9c"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ph: [True]\n",
      "ph: []\n",
      "ph: [True, True, True, True, True, True]\n",
      "ph: [True, True, True, True, True, True, True, True, True]\n",
      "ph: []\n",
      "ph: [True, True, True, True, True, True, True, True]\n",
      "ph: [True, True, True, True, True, True]\n",
      "ph: [True, False, True, False, False, True, False]\n",
      "ph: [False, False, False, False, False, False]\n",
      "ph: [False, True, True, False, True, True]\n",
      "ph: [False, False, False, False, True, False, False, False, True, True, True, True, False, True, True, True, True]\n",
      "ph: []\n",
      "ph: [False, True, False, False, False, False, False, False, False, False]\n",
      "ph: [True, True]\n",
      "ph: [False, False, False, False, False, False]\n",
      "ph: [False, False, False, False, False, False, False, False, False, False, False, False]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['no',\n",
       " 'no',\n",
       " 'yes',\n",
       " 'no',\n",
       " 'no',\n",
       " 'yes',\n",
       " 'yes',\n",
       " 'no',\n",
       " 'no',\n",
       " 'no',\n",
       " 'yes',\n",
       " 'no',\n",
       " 'yes',\n",
       " 'yes',\n",
       " 'no',\n",
       " 'yes',\n",
       " 'no',\n",
       " 'yes',\n",
       " 'no',\n",
       " 'yes',\n",
       " 'yes',\n",
       " 'no',\n",
       " 'no']"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "search = []\n",
    "for i in df['html']:\n",
    "  k = re.findall(r'[\\+\\(]?[1-9][0-9 .\\-\\(\\)]{8,}[0-9]', str(i))\n",
    "  if k:\n",
    "    ph = []\n",
    "    for z in k:\n",
    "      z = re.sub(\"\\D\", \"\", z)\n",
    "      if z[0] == \"1\":\n",
    "        z = z[1:]\n",
    "\n",
    "      if len(z) != 10:\n",
    "        pass\n",
    "      else:\n",
    "        #print(\"no: \" + z)\n",
    "        ph.append(phoneLookup(z))\n",
    "    print(\"ph: \" + str(ph))\n",
    "    if True in ph:\n",
    "      search.append('yes')\n",
    "    else:\n",
    "      search.append('no')\n",
    "  else:\n",
    "    search.append('no')\n",
    "search\n",
    "   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "qH8AW-cr-ifl",
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 1000
    },
    "id": "qH8AW-cr-ifl",
    "outputId": "1eb8ff0f-fcf5-476a-edd1-35488ed77df8"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"df-267d1b52-c873-4447-bfc0-66808350a8c4\">\n",
       "    <div class=\"colab-df-container\">\n",
       "      <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>index</th>\n",
       "      <th>url</th>\n",
       "      <th>text</th>\n",
       "      <th>header</th>\n",
       "      <th>footer</th>\n",
       "      <th>image_url</th>\n",
       "      <th>image_source</th>\n",
       "      <th>html</th>\n",
       "      <th>zipcode</th>\n",
       "      <th>valid_phone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>https://acariahealth.envolvehealth.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n]</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...</td>\n",
       "      <td>[https://acariahealth.envolvehealth.com/conten...</td>\n",
       "      <td>[/content/dam/centene/envolve-pharmacy-solutio...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Locat...</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.accredo.pharmacy</td>\n",
       "      <td>[\\n, \\n            Skip to main content\\n     ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...</td>\n",
       "      <td>[https://www.accredo.pharmacyhttps://esi-drupa...</td>\n",
       "      <td>[https://esi-drupal-cdn.s3.amazonaws.com/accre...</td>\n",
       "      <td>[\\n, \\n            Skip to main content\\n     ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.alphascriptrx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.alphascriptrx.comdata:image/gif;b...</td>\n",
       "      <td>[data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.aoncology.com</td>\n",
       "      <td>[\\n, \\n    &lt;div class=\"wpautoterms-update-noti...</td>\n",
       "      <td>[\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...</td>\n",
       "      <td>[\\n, \\n, © 2020 American Oncology Network, LLC...</td>\n",
       "      <td>[https://www.aoncology.comhttps://dc.ads.linke...</td>\n",
       "      <td>[https://dc.ads.linkedin.com/collect/?pid=9449...</td>\n",
       "      <td>[\\n, \\n    &lt;div class=\"wpautoterms-update-noti...</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.cornerstonehealthsolutions.org</td>\n",
       "      <td>[\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...</td>\n",
       "      <td>[https://www.cornerstonehealthsolutions.org/th...</td>\n",
       "      <td>[/themes/contrib/emulsify/images/logos/logo.sv...</td>\n",
       "      <td>[\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.curanthealth.com</td>\n",
       "      <td>[\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...</td>\n",
       "      <td>[\\n, \\n, \\n, Terms &amp; Conditions, \\n, Web Polic...</td>\n",
       "      <td>[https://www.curanthealth.comhttps://curanthea...</td>\n",
       "      <td>[https://curanthealth.com/wp-content/uploads/2...</td>\n",
       "      <td>[\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.friendswoodhealthmartpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "      <td>[https://www.friendswoodhealthmartpharmacy.com...</td>\n",
       "      <td>[\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>https://eaglepharmacy.com</td>\n",
       "      <td>[\\n, \\n, We are currently experiencing issues ...</td>\n",
       "      <td>[We are currently experiencing issues with our...</td>\n",
       "      <td>[Refills, Forms, Help (FAQ), Medication Dispos...</td>\n",
       "      <td>[https://eaglepharmacy.comhttps://global-uploa...</td>\n",
       "      <td>[https://global-uploads.webflow.com/59516e6b55...</td>\n",
       "      <td>[\\n, \\n, We are currently experiencing issues ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.express-scripts.com</td>\n",
       "      <td>[ ,  Skip to main content ,  , Menu,  ,  ,  , ...</td>\n",
       "      <td>[ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...</td>\n",
       "      <td>[ , About Us,  , Careers,  , Corporate Site,  ...</td>\n",
       "      <td>[https://www.express-scripts.com/themes/custom...</td>\n",
       "      <td>[/themes/custom/dsf/img/ui/1x1-transparent.gif...</td>\n",
       "      <td>[ ,  Skip to main content ,  , Menu,  ,  ,  , ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.essentiahealth.org</td>\n",
       "      <td>[\\n, \\n,  COVID-19 Update, \\n, Masks must stil...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...</td>\n",
       "      <td>[\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...</td>\n",
       "      <td>[https://www.essentiahealth.org/app/files/publ...</td>\n",
       "      <td>[/app/files/public/2897/Essentia-Health-Logo.s...</td>\n",
       "      <td>[\\n, \\n,  COVID-19 Update, \\n, Masks must stil...</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.dfwwellnesspharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.comhttps://ww...</td>\n",
       "      <td>[https://www.dfwwellnesspharmacy.com/wp-conten...</td>\n",
       "      <td>[\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0</td>\n",
       "      <td>https://intermountainhealthcare.org/services/p...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]</td>\n",
       "      <td>[https://intermountainhealthcare.org/services/...</td>\n",
       "      <td>[/-/media/images/global/1-1/woman-on-a-laptop....</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.geniusrx.com</td>\n",
       "      <td>[\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...</td>\n",
       "      <td>[\\n, \\n, \\n, Looking to save up to 80% on your...</td>\n",
       "      <td>[\\n, \\n, GeniusRx is a licensed and accredited...</td>\n",
       "      <td>[https://www.geniusrx.com/assets/images/genius...</td>\n",
       "      <td>[/assets/images/geniusrx-logo.png, /assets/ima...</td>\n",
       "      <td>[\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.orsinihealthcare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...</td>\n",
       "      <td>[https://www.orsinihealthcare.comhttps://www.o...</td>\n",
       "      <td>[https://www.orsinispecialtypharmacy.com/hs-fs...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.pantherxrare.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.pantherxrare.comhttps://www.panth...</td>\n",
       "      <td>[https://www.pantherxrare.com/wp-content/theme...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.mintrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...</td>\n",
       "      <td>[\\n, Skip to main content, \\n, Skip to footer ...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...</td>\n",
       "      <td>[https://www.mintrxpharmacy.comhttps://www.fac...</td>\n",
       "      <td>[https://www.facebook.com/tr?id=19764215183921...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.flcancer.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.flcancer.comhttps://flcancer.com/...</td>\n",
       "      <td>[https://flcancer.com/app/uploads/2021/06/2017...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.scriptsrxpharmacy.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...</td>\n",
       "      <td>[ABOUT US, Our Pharmacy, Locations, Careers, C...</td>\n",
       "      <td>[https://www.scriptsrxpharmacy.comhttps://stat...</td>\n",
       "      <td>[https://static.wixstatic.com/media/f44edb_33a...</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.senderrarx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to the main content....</td>\n",
       "      <td>[\\n, \\n, \\n, Skip to the main content., \\n, \\n...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://www.senderrarx.comhttps://www.senderr...</td>\n",
       "      <td>[https://www.senderrarx.com/hs-fs/hubfs/Sender...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, Skip to the main content....</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.synergenrx.com</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>[Home, Specialties, Providers, Patients, Pharm...</td>\n",
       "      <td>[Contact info, \\n,                     , \\n, A...</td>\n",
       "      <td>[https://www.synergenrx.comhttps://static.wixs...</td>\n",
       "      <td>[https://static.wixstatic.com/media/35816e_e98...</td>\n",
       "      <td>[\\n, \\n    var bodyCacheable = true;\\n    \\n  ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>https://mylocalrx.org</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...</td>\n",
       "      <td>[\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[https://mylocalrx.orghttps://www.trilliumheal...</td>\n",
       "      <td>[https://www.trilliumhealth.pharmacy/images/lo...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.vascorx.com</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...</td>\n",
       "      <td>[https://www.vascorx.comhttps://vascorx.com/wp...</td>\n",
       "      <td>[https://vascorx.com/wp-content/themes/vascorx...</td>\n",
       "      <td>[\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>https://www.walgreens.com</td>\n",
       "      <td>[\\n, \\n                Skip to main content\\n ...</td>\n",
       "      <td>[\\r\\n  .global_nav_text {\\r\\n    /*font-family...</td>\n",
       "      <td>[Enter email for weekly deals, Sign up,  ,  , ...</td>\n",
       "      <td>[https://www.walgreens.com/images/adaptive/sp/...</td>\n",
       "      <td>[/images/adaptive/sp/giftbox_22x20.png, data:i...</td>\n",
       "      <td>[\\n, \\n                Skip to main content\\n ...</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>\n",
       "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-267d1b52-c873-4447-bfc0-66808350a8c4')\"\n",
       "              title=\"Convert this dataframe to an interactive table.\"\n",
       "              style=\"display:none;\">\n",
       "        \n",
       "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
       "       width=\"24px\">\n",
       "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
       "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
       "  </svg>\n",
       "      </button>\n",
       "      \n",
       "  <style>\n",
       "    .colab-df-container {\n",
       "      display:flex;\n",
       "      flex-wrap:wrap;\n",
       "      gap: 12px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert {\n",
       "      background-color: #E8F0FE;\n",
       "      border: none;\n",
       "      border-radius: 50%;\n",
       "      cursor: pointer;\n",
       "      display: none;\n",
       "      fill: #1967D2;\n",
       "      height: 32px;\n",
       "      padding: 0 0 0 0;\n",
       "      width: 32px;\n",
       "    }\n",
       "\n",
       "    .colab-df-convert:hover {\n",
       "      background-color: #E2EBFA;\n",
       "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
       "      fill: #174EA6;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert {\n",
       "      background-color: #3B4455;\n",
       "      fill: #D2E3FC;\n",
       "    }\n",
       "\n",
       "    [theme=dark] .colab-df-convert:hover {\n",
       "      background-color: #434B5C;\n",
       "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
       "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
       "      fill: #FFFFFF;\n",
       "    }\n",
       "  </style>\n",
       "\n",
       "      <script>\n",
       "        const buttonEl =\n",
       "          document.querySelector('#df-267d1b52-c873-4447-bfc0-66808350a8c4 button.colab-df-convert');\n",
       "        buttonEl.style.display =\n",
       "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
       "\n",
       "        async function convertToInteractive(key) {\n",
       "          const element = document.querySelector('#df-267d1b52-c873-4447-bfc0-66808350a8c4');\n",
       "          const dataTable =\n",
       "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
       "                                                     [key], {});\n",
       "          if (!dataTable) return;\n",
       "\n",
       "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
       "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
       "            + ' to learn more about interactive tables.';\n",
       "          element.innerHTML = '';\n",
       "          dataTable['output_type'] = 'display_data';\n",
       "          await google.colab.output.renderOutput(dataTable, element);\n",
       "          const docLink = document.createElement('div');\n",
       "          docLink.innerHTML = docLinkHtml;\n",
       "          element.appendChild(docLink);\n",
       "        }\n",
       "      </script>\n",
       "    </div>\n",
       "  </div>\n",
       "  "
      ],
      "text/plain": [
       "    index                                                url  \\\n",
       "0       0             https://acariahealth.envolvehealth.com   \n",
       "1       0                       https://www.accredo.pharmacy   \n",
       "2       0                      https://www.alphascriptrx.com   \n",
       "3       0                          https://www.aoncology.com   \n",
       "4       0         https://www.cornerstonehealthsolutions.org   \n",
       "5       0                       https://www.curanthealth.com   \n",
       "6       0      https://www.friendswoodhealthmartpharmacy.com   \n",
       "7       0                          https://eaglepharmacy.com   \n",
       "8       0                    https://www.express-scripts.com   \n",
       "9       0                     https://www.essentiahealth.org   \n",
       "10      0                https://www.dfwwellnesspharmacy.com   \n",
       "11      0  https://intermountainhealthcare.org/services/p...   \n",
       "12      0                           https://www.geniusrx.com   \n",
       "13      0                   https://www.orsinihealthcare.com   \n",
       "14      0                       https://www.pantherxrare.com   \n",
       "15      0                     https://www.mintrxpharmacy.com   \n",
       "16      0                           https://www.flcancer.com   \n",
       "17      0                  https://www.scriptsrxpharmacy.com   \n",
       "18      0                         https://www.senderrarx.com   \n",
       "19      0                         https://www.synergenrx.com   \n",
       "20      0                              https://mylocalrx.org   \n",
       "21      0                            https://www.vascorx.com   \n",
       "22      0                          https://www.walgreens.com   \n",
       "\n",
       "                                                 text  \\\n",
       "0                                    [\\n, \\n, \\n, \\n]   \n",
       "1   [\\n, \\n            Skip to main content\\n     ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...   \n",
       "3   [\\n, \\n    <div class=\"wpautoterms-update-noti...   \n",
       "4   [\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...   \n",
       "5   [\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...   \n",
       "6   [\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...   \n",
       "7   [\\n, \\n, We are currently experiencing issues ...   \n",
       "8   [ ,  Skip to main content ,  , Menu,  ,  ,  , ...   \n",
       "9   [\\n, \\n,  COVID-19 Update, \\n, Masks must stil...   \n",
       "10  [\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...   \n",
       "12  [\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...   \n",
       "17  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, Skip to the main content....   \n",
       "19  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "22  [\\n, \\n                Skip to main content\\n ...   \n",
       "\n",
       "                                               header  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, Home, \\n, Contact...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, Orders may be delayed...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Patie...   \n",
       "3   [\\n, \\n, \\n, For Patients, \\n, Careers, \\n, Bl...   \n",
       "4   [\\n, \\n, \\n,  , \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n...   \n",
       "5   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Home,...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n...   \n",
       "7   [We are currently experiencing issues with our...   \n",
       "8   [ , Menu,  ,  ,  , Log In,  , Register,  ,  , ...   \n",
       "9   [\\n, \\n, \\n, \\n, \\n, Your Location: , Set Your...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n,  , \\n, 85...   \n",
       "11  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "12  [\\n, \\n, \\n, Looking to save up to 80% on your...   \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, Skip to main content, \\n, Skip to footer ...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [Map Pin, \\n, \\n, \\n, \\n, \\n, Chicago: (800) 2...   \n",
       "18  [\\n, \\n, \\n, Skip to the main content., \\n, \\n...   \n",
       "19  [Home, Specialties, Providers, Patients, Pharm...   \n",
       "20  [\\n, \\n, \\n, 800.923.9394, \\n, \\n, Para Españo...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, T...   \n",
       "22  [\\r\\n  .global_nav_text {\\r\\n    /*font-family...   \n",
       "\n",
       "                                               footer  \\\n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, Locations, \\n, Referr...   \n",
       "1   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n           ...   \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "3   [\\n, \\n, © 2020 American Oncology Network, LLC...   \n",
       "4   [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, \\n, \\n, \\n,  ,...   \n",
       "5   [\\n, \\n, \\n, Terms & Conditions, \\n, Web Polic...   \n",
       "6   [\\n, \\n, \\n, \\n, \\n, \\n, \\r\\n\\t\\t\\t\\t\\t\\t\\tCop...   \n",
       "7   [Refills, Forms, Help (FAQ), Medication Dispos...   \n",
       "8   [ , About Us,  , Careers,  , Corporate Site,  ...   \n",
       "9   [\\n, Footer, \\n, \\n, \\n, scroll to top, \\n, \\n...   \n",
       "10  [\\n, \\n, \\n, \\n, \\n, \\n,  , \\n, Address, \\n, 7...   \n",
       "11               [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n]   \n",
       "12  [\\n, \\n, GeniusRx is a licensed and accredited...   \n",
       "13  [\\n, \\n, \\n, \\n, FOLLOW US, \\n, \\n, \\n, \\n, \\n...   \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "15  [\\n, \\n, \\n, \\n, \\n, Operating Hours, \\n, CLIE...   \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "17  [ABOUT US, Our Pharmacy, Locations, Careers, C...   \n",
       "18  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "19  [Contact info, \\n,                     , \\n, A...   \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...   \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, 4045 E. Bell Rd., Sui...   \n",
       "22  [Enter email for weekly deals, Sign up,  ,  , ...   \n",
       "\n",
       "                                            image_url  \\\n",
       "0   [https://acariahealth.envolvehealth.com/conten...   \n",
       "1   [https://www.accredo.pharmacyhttps://esi-drupa...   \n",
       "2   [https://www.alphascriptrx.comdata:image/gif;b...   \n",
       "3   [https://www.aoncology.comhttps://dc.ads.linke...   \n",
       "4   [https://www.cornerstonehealthsolutions.org/th...   \n",
       "5   [https://www.curanthealth.comhttps://curanthea...   \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...   \n",
       "7   [https://eaglepharmacy.comhttps://global-uploa...   \n",
       "8   [https://www.express-scripts.com/themes/custom...   \n",
       "9   [https://www.essentiahealth.org/app/files/publ...   \n",
       "10  [https://www.dfwwellnesspharmacy.comhttps://ww...   \n",
       "11  [https://intermountainhealthcare.org/services/...   \n",
       "12  [https://www.geniusrx.com/assets/images/genius...   \n",
       "13  [https://www.orsinihealthcare.comhttps://www.o...   \n",
       "14  [https://www.pantherxrare.comhttps://www.panth...   \n",
       "15  [https://www.mintrxpharmacy.comhttps://www.fac...   \n",
       "16  [https://www.flcancer.comhttps://flcancer.com/...   \n",
       "17  [https://www.scriptsrxpharmacy.comhttps://stat...   \n",
       "18  [https://www.senderrarx.comhttps://www.senderr...   \n",
       "19  [https://www.synergenrx.comhttps://static.wixs...   \n",
       "20  [https://mylocalrx.orghttps://www.trilliumheal...   \n",
       "21  [https://www.vascorx.comhttps://vascorx.com/wp...   \n",
       "22  [https://www.walgreens.com/images/adaptive/sp/...   \n",
       "\n",
       "                                         image_source  \\\n",
       "0   [/content/dam/centene/envolve-pharmacy-solutio...   \n",
       "1   [https://esi-drupal-cdn.s3.amazonaws.com/accre...   \n",
       "2   [data:image/gif;base64,R0lGODlhAQABAAAAACH5BAE...   \n",
       "3   [https://dc.ads.linkedin.com/collect/?pid=9449...   \n",
       "4   [/themes/contrib/emulsify/images/logos/logo.sv...   \n",
       "5   [https://curanthealth.com/wp-content/uploads/2...   \n",
       "6   [https://www.friendswoodhealthmartpharmacy.com...   \n",
       "7   [https://global-uploads.webflow.com/59516e6b55...   \n",
       "8   [/themes/custom/dsf/img/ui/1x1-transparent.gif...   \n",
       "9   [/app/files/public/2897/Essentia-Health-Logo.s...   \n",
       "10  [https://www.dfwwellnesspharmacy.com/wp-conten...   \n",
       "11  [/-/media/images/global/1-1/woman-on-a-laptop....   \n",
       "12  [/assets/images/geniusrx-logo.png, /assets/ima...   \n",
       "13  [https://www.orsinispecialtypharmacy.com/hs-fs...   \n",
       "14  [https://www.pantherxrare.com/wp-content/theme...   \n",
       "15  [https://www.facebook.com/tr?id=19764215183921...   \n",
       "16  [https://flcancer.com/app/uploads/2021/06/2017...   \n",
       "17  [https://static.wixstatic.com/media/f44edb_33a...   \n",
       "18  [https://www.senderrarx.com/hs-fs/hubfs/Sender...   \n",
       "19  [https://static.wixstatic.com/media/35816e_e98...   \n",
       "20  [https://www.trilliumhealth.pharmacy/images/lo...   \n",
       "21  [https://vascorx.com/wp-content/themes/vascorx...   \n",
       "22  [/images/adaptive/sp/giftbox_22x20.png, data:i...   \n",
       "\n",
       "                                                 html zipcode valid_phone  \n",
       "0   [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, Locat...      no          no  \n",
       "1   [\\n, \\n            Skip to main content\\n     ...     yes          no  \n",
       "2   [\\n, \\n, \\n, \\n, \\n, \\n, (650) 412-4530, \\n, p...     yes         yes  \n",
       "3   [\\n, \\n    <div class=\"wpautoterms-update-noti...      no          no  \n",
       "4   [\\n, Skip to main content\\n    ,  , \\n, \\n, \\n...     yes          no  \n",
       "5   [\\n,  , \\n, \\n, \\n, \\n, Join Our Team, \\n, \\n,...     yes         yes  \n",
       "6   [\\n, \\n, \\r\\n\\t\\tSkip to content, \\n, \\n, \\n, ...     yes         yes  \n",
       "7   [\\n, \\n, We are currently experiencing issues ...     yes          no  \n",
       "8   [ ,  Skip to main content ,  , Menu,  ,  ,  , ...     yes          no  \n",
       "9   [\\n, \\n,  COVID-19 Update, \\n, Masks must stil...      no          no  \n",
       "10  [\\n, \\n, \\n, \\r\\n    Curbside Pick-Up and No-C...     yes         yes  \n",
       "11  [\\n, \\n, \\n, \\n, \\n, Skip to main content, \\n,...     yes          no  \n",
       "12  [\\n,  ,  , \\n, \\n, \\n, \\n, Looking to save up ...     yes         yes  \n",
       "13  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...     yes         yes  \n",
       "14  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...     yes          no  \n",
       "15  [\\n, \\n, \\n, \\n, \\n, \\n, Skip to main content,...     yes         yes  \n",
       "16  [\\n, \\n, \\n, \\n, \\n, \\r\\n    window._monsido =...      no          no  \n",
       "17  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...     yes         yes  \n",
       "18  [\\n, \\n, \\n, \\n, \\n, Skip to the main content....     yes          no  \n",
       "19  [\\n, \\n    var bodyCacheable = true;\\n    \\n  ...     yes         yes  \n",
       "20  [\\n, \\n, \\n, \\n, \\n, \\n, \\n\\t\\tSkip to Main Co...      no         yes  \n",
       "21  [\\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\n, \\...     yes          no  \n",
       "22  [\\n, \\n                Skip to main content\\n ...     yes          no  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['valid_phone'] = search \n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "97428b7c-5b08-41c2-bafb-c380e4941867",
   "metadata": {
    "id": "97428b7c-5b08-41c2-bafb-c380e4941867"
   },
   "source": [
    "## *** TO DO\n",
    "\n",
    "Need to clean up the image_url column. Some of the urls are not .png/.jpeg files, some don't have a suffix at all, some have more than 1 'https://' within the url, etc. which are preventing the image from showing up. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b3e3d562-63b1-4066-8b3a-dea7ca17f9bd",
   "metadata": {
    "id": "b3e3d562-63b1-4066-8b3a-dea7ca17f9bd",
    "outputId": "c1d4cca3-a6be-4168-bb20-508f31aab8f7"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2019/08/logo.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/08/Alphascript-Specialty-Pharmacy.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/08/Alphasccript-Pharmacist-On-Phone.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2019/09/heart-1.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2019/09/folder.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2019/11/Alphascript-Icon-White-1.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2019/11/2019-11-25_URAC-Accreditation-Seal.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/09/URAC-Mail-Service-Accredited-Alphascript-198x300.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/09/URAC-Mail-Service-Accredited-Alphascript-198x300.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2019/11/2019-11-25_URAC-Accreditation-Seal.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/01/Alphascript-ACHC-Accredited.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/01/Alphascript-ACHC-Accredited.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/01/PCAB.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/01/PCAB.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://alphascriptrx.com/wp-content/uploads/2020/01/PCAB.png',\n",
       " 'https://www.alphascriptrx.comdata:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',\n",
       " 'https://www.alphascriptrx.comhttps://openbadges.blob.core.windows.net/bakedbadges-us/f279c890-aa1f-43bc-822d-c78c619a148e-2fd08020-00fe-4dbc-8334-dcb2b4e7f941.png']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['image_url'][2]  "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "06d02d8e-23e8-45eb-81b2-c4b5f3592c5e",
   "metadata": {
    "id": "06d02d8e-23e8-45eb-81b2-c4b5f3592c5e"
   },
   "source": [
    "### Convert image_url to actual images/icon\n",
    "\n",
    "*** Another issue I found is that when you convert the images in the pandas dataframe and use the below function, it converts df into a table and haven't been able to figure out how to get it back to a dataframe. Not sure if there's a way to export this to a .csv but we'll need to look into that too. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "800eba1f-f22d-4488-8fe5-baf0735e0741",
   "metadata": {
    "id": "800eba1f-f22d-4488-8fe5-baf0735e0741"
   },
   "outputs": [],
   "source": [
    "def path_to_image_html(path):\n",
    "    return '<img src =\"' + path + '\"width = \"60\" >'\n",
    "df2 = df.explode('image_url')\n",
    "df2 = HTML(df2.to_html(escape = False, formatters = dict(image_url= path_to_image_html)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "932c6beb-e9c7-4024-a304-bc1b2a52e193",
   "metadata": {
    "id": "932c6beb-e9c7-4024-a304-bc1b2a52e193"
   },
   "outputs": [],
   "source": [
    "# df2"
   ]
  }
 ],
 "metadata": {
  "colab": {
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}