extract_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d7f42854",
   "metadata": {},
   "outputs": [],
   "source": [
    "import PyPDF2, os\n",
    "from pprint import pprint\n",
    "import pandas as pd\n",
    "\n",
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "533acff6",
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_pdf_form(filename):\n",
    "    with open(filename, \"rb\") as pdf_obj:\n",
    "        pdf = PyPDF2.PdfFileReader(pdf_obj)\n",
    "        return pdf.getFormTextFields()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "b9298ddf",
   "metadata": {},
   "outputs": [],
   "source": [
    "def export_to_excel(df):\n",
    "    writer = pd.ExcelWriter(\"POs.xlsx\", engine = 'xlsxwriter')\n",
    "    df.to_excel(writer, index = False)\n",
    "    print(writer.sheets)\n",
    "    worksheet = writer.sheets[\"Sheet1\"]  # pull worksheet object\n",
    "    for idx, col in enumerate(df):  # loop through all columns\n",
    "        series = df[col]\n",
    "        max_len = max((\n",
    "            series.astype(str).map(len).max(),  # len of largest item\n",
    "            len(str(series.name))  # len of column name/header\n",
    "            )) + 1  # adding a little extra space\n",
    "        worksheet.set_column(idx, idx, max_len)  # set column width\n",
    "    writer.save()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "d5b8eec8",
   "metadata": {},
   "outputs": [],
   "source": [
    "def find_pdfs():\n",
    "    dfs, cwd = [], os.getcwd()\n",
    "    for root, dirs, files in os.walk(cwd + \"/POs\"):\n",
    "        for file in files:\n",
    "            filename, extension = os.path.splitext(file)\n",
    "            if extension == \".pdf\":\n",
    "                curr_path = f\"{root}/{filename}{extension}\"\n",
    "                pdf_data = extract_pdf_form(curr_path)\n",
    "                # pprint(pdf_data)\n",
    "                df = pd.DataFrame([pdf_data])\n",
    "                df.insert(0, \"Filename\", filename)\n",
    "                column_mapping = {\"NumericField1[0]\" : \"Qty\",\n",
    "                                  \"DateTimeField1[0]\" : \"Date of Shipment\",\n",
    "                                  \"DateTimeField1[1]\" : 'wow',\n",
    "                                  \"TextField5[0]\" : \"Buyer Name and Address (4)\",\n",
    "                                  \"TextField3[0]\" : \"Lot Number 1\",\n",
    "                                  \"TextField3[1]\" : \"Lot Number 2\",\n",
    "                                  \"TextField3[2]\" : \"Lot Number 3\"}\n",
    "                dfs.append(df)\n",
    "    df = pd.concat(dfs)\n",
    "    display(df)\n",
    "    export_to_excel(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "2e2142cc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Filename</th>\n",
       "      <th>TextField5[0]</th>\n",
       "      <th>TextField2[0]</th>\n",
       "      <th>NumericField1[0]</th>\n",
       "      <th>TextField4[0]</th>\n",
       "      <th>DateTimeField1[0]</th>\n",
       "      <th>DateTimeField1[1]</th>\n",
       "      <th>TextField1[0]</th>\n",
       "      <th>TextField3[0]</th>\n",
       "      <th>TextField5[1]</th>\n",
       "      <th>TextField5[2]</th>\n",
       "      <th>TextField5[3]</th>\n",
       "      <th>TextField5[4]</th>\n",
       "      <th>TextField3[1]</th>\n",
       "      <th>TextField5[5]</th>\n",
       "      <th>TextField5[6]</th>\n",
       "      <th>TextField3[2]</th>\n",
       "      <th>TextField5[7]</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12140(Vital)</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>55150-0120-30</td>\n",
       "      <td>7</td>\n",
       "      <td>29649</td>\n",
       "      <td>None</td>\n",
       "      <td>Oct 14, 2015</td>\n",
       "      <td>Piper/Taz 3.375gm</td>\n",
       "      <td>PTO315091A Exp.8/17</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Skilled Nursing Pharmacy San Diego 9920 Scripp...</td>\n",
       "      <td>McKesson   10504 McKesson Drive   Ruther Glen,...</td>\n",
       "      <td>Buford Road Pharmacy Wholesale  2608 Buford Rd...</td>\n",
       "      <td>PTO315091A Exp.8/17</td>\n",
       "      <td>Buford Road Pharmacy Wholesale  2608 Buford Rd...</td>\n",
       "      <td>Vital Healthcare LLC.   2900 Capital Street Su...</td>\n",
       "      <td>PTO315091A Exp.8/17</td>\n",
       "      <td>Vital Healthcare LLC.   2900 Capital Street Su...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12154(Vital)</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>55150-0120-30</td>\n",
       "      <td>25</td>\n",
       "      <td>29664</td>\n",
       "      <td>None</td>\n",
       "      <td>Oct 15, 2015</td>\n",
       "      <td>Piper/Taz 3.375gm</td>\n",
       "      <td>PTO315091A Exp.8/17</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Skilled Nursing Pharmacy San Diego 9920 Scripp...</td>\n",
       "      <td>McKesson   10504 McKesson Drive   Ruther Glen,...</td>\n",
       "      <td>Buford Road Pharmacy Wholesale  2608 Buford Rd...</td>\n",
       "      <td>PTO315091A Exp.8/17</td>\n",
       "      <td>Buford Road Pharmacy Wholesale  2608 Buford Rd...</td>\n",
       "      <td>Vital Healthcare LLC.   2900 Capital Street Su...</td>\n",
       "      <td>PTO315091A Exp.8/17</td>\n",
       "      <td>Vital Healthcare LLC.   2900 Capital Street Su...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17133(2)</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>Tamsulosin .4mg 100ct</td>\n",
       "      <td>1401043A</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Maxor Correctional Pharmacy Svcs 416 Mary Lind...</td>\n",
       "      <td>Bell Medical Svcs, Inc. 120 Vanderburg Rd. Mal...</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17133(3)</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>68382-0132-01</td>\n",
       "      <td>16</td>\n",
       "      <td>26800</td>\n",
       "      <td>None</td>\n",
       "      <td>Jan 5, 2015</td>\n",
       "      <td>Tamsulosin .4mg 100ct</td>\n",
       "      <td>MP9372</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Maxor Correctional Pharmacy Svcs 416 Mary Lind...</td>\n",
       "      <td>Amerisource Bergen 6305 La Salle Dr. Lockbourn...</td>\n",
       "      <td>Poca Value Rite 119 C Main Street Poca, WV 25159</td>\n",
       "      <td>MP9372</td>\n",
       "      <td>Poca Value Rite 119 C Main Street Poca, WV 25159</td>\n",
       "      <td>Vital Healthcare LLC. 11 East Lathrop Ave. Sav...</td>\n",
       "      <td>MP9372</td>\n",
       "      <td>Vital Healthcare LLC. 11 East Lathrop Ave. Sav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17133(4)</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>68382-0132-01</td>\n",
       "      <td>16</td>\n",
       "      <td>26800</td>\n",
       "      <td>None</td>\n",
       "      <td>Jan 5, 2015</td>\n",
       "      <td>Tamsulosin .4mg 100ct</td>\n",
       "      <td>MP9372</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Maxor Correctional Pharmacy Svcs 416 Mary Lind...</td>\n",
       "      <td>Amerisource Bergen 6305 La Salle Dr. Lockbourn...</td>\n",
       "      <td>Poca Value Rite 119 C Main Street Poca, WV 25159</td>\n",
       "      <td>MP9372</td>\n",
       "      <td>Poca Value Rite 119 C Main Street Poca, WV 25159</td>\n",
       "      <td>Vital Healthcare LLC. 11 East Lathrop Ave. Sav...</td>\n",
       "      <td>MP9372</td>\n",
       "      <td>Vital Healthcare LLC. 11 East Lathrop Ave. Sav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17133</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>Tamsulosin .4mg 100ct</td>\n",
       "      <td>1401044A</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Maxor Correctional Pharmacy Svcs 416 Mary Lind...</td>\n",
       "      <td>Bell Medical Svcs, Inc. 120 Vanderburg Rd. Mal...</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17134(BELL)</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>4</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>Tamsulosin .4mg 100ct</td>\n",
       "      <td>MP9600</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Maxor Correctional Pharmacy Svcs 416 Mary Lind...</td>\n",
       "      <td>Bell Medical Svcs, Inc. 120 Vanderburg Rd. Mal...</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MP9601</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>173(HARFORD)</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>00409-6533-01</td>\n",
       "      <td>10</td>\n",
       "      <td>22187</td>\n",
       "      <td>None</td>\n",
       "      <td>Jan 8, 2015</td>\n",
       "      <td>Vecuronium 10mg</td>\n",
       "      <td>JKN3443</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Long Beach Memorial Medical Center  2801 Atlan...</td>\n",
       "      <td>McKesson Corp. DC #8180  1900 South 4490  West...</td>\n",
       "      <td>Birch Family Pharmacy 213 E. Main Street  Gran...</td>\n",
       "      <td>JKN3443A</td>\n",
       "      <td>Birch Family Pharmacy 213 E. Main Street  Gran...</td>\n",
       "      <td>Harford Health Services, Inc.  1 Vale Rd. Unit...</td>\n",
       "      <td>JKN3443A</td>\n",
       "      <td>Harford Health Services Inc.  1 Vale Rd. Unit ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>28+2(HARFORD)</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>00409-3796-01</td>\n",
       "      <td>1</td>\n",
       "      <td>44922</td>\n",
       "      <td>None</td>\n",
       "      <td>Feb 18, 2015</td>\n",
       "      <td>Ketorolac 60mg/ml 2ml</td>\n",
       "      <td>46048DK</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>FCER Kingwood Medical Center  2158 Northpark D...</td>\n",
       "      <td>Ideal Pharmacy  2333 Morris Ave Unit B101  Uni...</td>\n",
       "      <td>VRC Medical Services  6681 Snowdrift Rd.  Alle...</td>\n",
       "      <td>46308DK</td>\n",
       "      <td>VRC Medical Services  6681 Snowdrift Rd.  Alle...</td>\n",
       "      <td>Harford Health Services Inc.  1 Vale Rd. Unit ...</td>\n",
       "      <td>46308DK</td>\n",
       "      <td>Harford Health Services Inc.  1 Vale Rd. Unit ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>289(harford)</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>00409-3796-01</td>\n",
       "      <td>4</td>\n",
       "      <td>22515</td>\n",
       "      <td>None</td>\n",
       "      <td>Feb 23, 2015</td>\n",
       "      <td>Ketorolac 30mg/ml 2mL</td>\n",
       "      <td>46-045-DK</td>\n",
       "      <td>Broughton Pharmaceuticals LLC, 413 W Montgomer...</td>\n",
       "      <td>Connally Memorial Medical  499 10th Street  Fl...</td>\n",
       "      <td>Mckesson 3000 Kenskill Ave Washington Ct. Hous...</td>\n",
       "      <td>Your Family Pharmacy, LLC.  15 N Kringle Place...</td>\n",
       "      <td>46-045-DK</td>\n",
       "      <td>Your Family Pharmacy, LLC.  15 N Kringle Place...</td>\n",
       "      <td>Harford Health Services Inc.  1 Vale Rd. Unit ...</td>\n",
       "      <td>46-045-DK</td>\n",
       "      <td>Harford Health Services, Inc.  1 Vale Rd. Unit...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Filename                                      TextField5[0]  \\\n",
       "0   12140(Vital)  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0   12154(Vital)  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0       17133(2)                                                      \n",
       "0       17133(3)  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0       17133(4)  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0          17133                                                      \n",
       "0    17134(BELL)                                                      \n",
       "0   173(HARFORD)  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  28+2(HARFORD)  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0   289(harford)  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "\n",
       "   TextField2[0] NumericField1[0] TextField4[0] DateTimeField1[0]  \\\n",
       "0  55150-0120-30                7         29649              None   \n",
       "0  55150-0120-30               25         29664              None   \n",
       "0                                                            None   \n",
       "0  68382-0132-01               16         26800              None   \n",
       "0  68382-0132-01               16         26800              None   \n",
       "0                                                            None   \n",
       "0                               4                            None   \n",
       "0  00409-6533-01               10         22187              None   \n",
       "0  00409-3796-01                1         44922              None   \n",
       "0  00409-3796-01                4         22515              None   \n",
       "\n",
       "  DateTimeField1[1]          TextField1[0]        TextField3[0]  \\\n",
       "0      Oct 14, 2015      Piper/Taz 3.375gm  PTO315091A Exp.8/17   \n",
       "0      Oct 15, 2015      Piper/Taz 3.375gm  PTO315091A Exp.8/17   \n",
       "0                    Tamsulosin .4mg 100ct             1401043A   \n",
       "0       Jan 5, 2015  Tamsulosin .4mg 100ct               MP9372   \n",
       "0       Jan 5, 2015  Tamsulosin .4mg 100ct               MP9372   \n",
       "0                    Tamsulosin .4mg 100ct             1401044A   \n",
       "0                    Tamsulosin .4mg 100ct               MP9600   \n",
       "0       Jan 8, 2015        Vecuronium 10mg              JKN3443   \n",
       "0      Feb 18, 2015  Ketorolac 60mg/ml 2ml              46048DK   \n",
       "0      Feb 23, 2015  Ketorolac 30mg/ml 2mL            46-045-DK   \n",
       "\n",
       "                                       TextField5[1]  \\\n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...   \n",
       "\n",
       "                                       TextField5[2]  \\\n",
       "0  Skilled Nursing Pharmacy San Diego 9920 Scripp...   \n",
       "0  Skilled Nursing Pharmacy San Diego 9920 Scripp...   \n",
       "0  Maxor Correctional Pharmacy Svcs 416 Mary Lind...   \n",
       "0  Maxor Correctional Pharmacy Svcs 416 Mary Lind...   \n",
       "0  Maxor Correctional Pharmacy Svcs 416 Mary Lind...   \n",
       "0  Maxor Correctional Pharmacy Svcs 416 Mary Lind...   \n",
       "0  Maxor Correctional Pharmacy Svcs 416 Mary Lind...   \n",
       "0  Long Beach Memorial Medical Center  2801 Atlan...   \n",
       "0  FCER Kingwood Medical Center  2158 Northpark D...   \n",
       "0  Connally Memorial Medical  499 10th Street  Fl...   \n",
       "\n",
       "                                       TextField5[3]  \\\n",
       "0  McKesson   10504 McKesson Drive   Ruther Glen,...   \n",
       "0  McKesson   10504 McKesson Drive   Ruther Glen,...   \n",
       "0  Bell Medical Svcs, Inc. 120 Vanderburg Rd. Mal...   \n",
       "0  Amerisource Bergen 6305 La Salle Dr. Lockbourn...   \n",
       "0  Amerisource Bergen 6305 La Salle Dr. Lockbourn...   \n",
       "0  Bell Medical Svcs, Inc. 120 Vanderburg Rd. Mal...   \n",
       "0  Bell Medical Svcs, Inc. 120 Vanderburg Rd. Mal...   \n",
       "0  McKesson Corp. DC #8180  1900 South 4490  West...   \n",
       "0  Ideal Pharmacy  2333 Morris Ave Unit B101  Uni...   \n",
       "0  Mckesson 3000 Kenskill Ave Washington Ct. Hous...   \n",
       "\n",
       "                                       TextField5[4]        TextField3[1]  \\\n",
       "0  Buford Road Pharmacy Wholesale  2608 Buford Rd...  PTO315091A Exp.8/17   \n",
       "0  Buford Road Pharmacy Wholesale  2608 Buford Rd...  PTO315091A Exp.8/17   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...                        \n",
       "0   Poca Value Rite 119 C Main Street Poca, WV 25159               MP9372   \n",
       "0   Poca Value Rite 119 C Main Street Poca, WV 25159               MP9372   \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...                        \n",
       "0  Broughton Pharmaceuticals LLC, 413 W Montgomer...                        \n",
       "0  Birch Family Pharmacy 213 E. Main Street  Gran...             JKN3443A   \n",
       "0  VRC Medical Services  6681 Snowdrift Rd.  Alle...              46308DK   \n",
       "0  Your Family Pharmacy, LLC.  15 N Kringle Place...            46-045-DK   \n",
       "\n",
       "                                       TextField5[5]  \\\n",
       "0  Buford Road Pharmacy Wholesale  2608 Buford Rd...   \n",
       "0  Buford Road Pharmacy Wholesale  2608 Buford Rd...   \n",
       "0                                                      \n",
       "0   Poca Value Rite 119 C Main Street Poca, WV 25159   \n",
       "0   Poca Value Rite 119 C Main Street Poca, WV 25159   \n",
       "0                                                      \n",
       "0                                                      \n",
       "0  Birch Family Pharmacy 213 E. Main Street  Gran...   \n",
       "0  VRC Medical Services  6681 Snowdrift Rd.  Alle...   \n",
       "0  Your Family Pharmacy, LLC.  15 N Kringle Place...   \n",
       "\n",
       "                                       TextField5[6]        TextField3[2]  \\\n",
       "0  Vital Healthcare LLC.   2900 Capital Street Su...  PTO315091A Exp.8/17   \n",
       "0  Vital Healthcare LLC.   2900 Capital Street Su...  PTO315091A Exp.8/17   \n",
       "0                                                                           \n",
       "0  Vital Healthcare LLC. 11 East Lathrop Ave. Sav...               MP9372   \n",
       "0  Vital Healthcare LLC. 11 East Lathrop Ave. Sav...               MP9372   \n",
       "0                                                                           \n",
       "0                                                                  MP9601   \n",
       "0  Harford Health Services, Inc.  1 Vale Rd. Unit...             JKN3443A   \n",
       "0  Harford Health Services Inc.  1 Vale Rd. Unit ...              46308DK   \n",
       "0  Harford Health Services Inc.  1 Vale Rd. Unit ...            46-045-DK   \n",
       "\n",
       "                                       TextField5[7]  \n",
       "0  Vital Healthcare LLC.   2900 Capital Street Su...  \n",
       "0  Vital Healthcare LLC.   2900 Capital Street Su...  \n",
       "0                                                     \n",
       "0  Vital Healthcare LLC. 11 East Lathrop Ave. Sav...  \n",
       "0  Vital Healthcare LLC. 11 East Lathrop Ave. Sav...  \n",
       "0                                                     \n",
       "0                                                     \n",
       "0  Harford Health Services Inc.  1 Vale Rd. Unit ...  \n",
       "0  Harford Health Services Inc.  1 Vale Rd. Unit ...  \n",
       "0  Harford Health Services, Inc.  1 Vale Rd. Unit...  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Sheet1': <xlsxwriter.worksheet.Worksheet object at 0x000002008D21CA30>}\n"
     ]
    }
   ],
   "source": [
    "find_pdfs()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}