00: pdfplumber_Invoice_extract.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/gulabpatel/Table_Detection/blob/main/00%3A%20pdfplumber_Invoice_extract.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install pdfplumber"
      ],
      "metadata": {
        "id": "QG_YE3foVNs6"
      },
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "metadata": {
        "id": "IbNwPH5OPaQ4"
      },
      "outputs": [],
      "source": [
        "import re\n",
        "\n",
        "import requests\n",
        "import pdfplumber\n",
        "import pandas as pd\n",
        "from collections import namedtuple"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 9,
      "metadata": {
        "id": "uQ4raxhePaQ-"
      },
      "outputs": [],
      "source": [
        "Inv = namedtuple('Inv', 'vend_num vend_name inv_dt due_dt inv_amt net_amt description')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 10,
      "metadata": {
        "id": "8tm9gFkJPaQ_"
      },
      "outputs": [],
      "source": [
        "def download_file(url):\n",
        "    local_filename = url.split('/')[-1]\n",
        "    \n",
        "    with requests.get(url) as r:\n",
        "        with open(local_filename, 'wb') as f:\n",
        "            f.write(r.content)\n",
        "        \n",
        "    return local_filename"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "metadata": {
        "id": "1XStkpNWPaRA"
      },
      "outputs": [],
      "source": [
        "ap_url = 'https://www.tabs3.com/support/sample/apreports.pdf'"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "metadata": {
        "id": "EVj70ViFPaRB"
      },
      "outputs": [],
      "source": [
        "ap = download_file(ap_url)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "metadata": {
        "id": "lnKWcfwEPaRB"
      },
      "outputs": [],
      "source": [
        "with pdfplumber.open(ap) as pdf:\n",
        "    page = pdf.pages[9]\n",
        "    text = page.extract_text()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 15,
      "metadata": {
        "id": "Jb1wN75dPaRC",
        "outputId": "06a8092a-c234-48f0-db45-964bccc76356",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "AccountsPayableReportPack\n",
            "Summary Vendor List\n",
            "Date: 08/23/2022 Summary Numerical Vendor List Page: 1\n",
            "Jensen, Martin & Anderson, P.C.\n",
            "Due Discount\n",
            "Vendor Name Phone # Days % Days\n",
            "(200) United Parcel Service\n",
            "201 Fed Ex 800.622.1147\n",
            "202 Software Technology, LLC 402-419-2200 5\n",
            "203 Clerk of the County Court\n",
            "204 Clerk of the District Court\n",
            "205 Business Week\n",
            "225 * Jackson/Wylinda\n",
            "240 NELCO 800-266-4669 30 2.00 10\n",
            "242 Office Supply Megastore 30 1.50 5\n",
            "250 * D & B Real Estate Management Company 402-222-5543\n",
            "400 Sprint Local & Long Distance 20\n",
            "700 * Clean All Janitorial Services 30\n",
            "999M Miscellaneous Vendor\n",
            "Menu Reports|Vendors|VendorList\n",
            "ThereportshownaboveisasummaryVendorList.TheprogramtabsforthisreportincludethestandardVendortabaswellastheOptionstab.TheOptionstaballowsyoutoselectwhetherthereportshouldbeprintedindetailorsummaryformat.Thelistshownaboveisprintedinsummaryformatinnumericalvendororder.\n",
            "Definitions for Summary Vendor List\n",
            "Date TheReportDateenteredwhenthelistwasrun.\n",
            "Vendor Vendornumber.An“M”followingtheVendorNumberindicatesthevendorissetupasa“MiscellaneousVendor”.Inactivevendorsareindicatedbyparenthesesaroundthevendornumber.\n",
            "* An“*”followingthevendornumberindicatesthevendorissetuptoaccrue1099information.\n",
            "DueDays Thenumberofdaysfromtheinvoicedatethatthevendorallowstopaytheinvoice.Thisinformationisusedtocalculatetheinvoice’sdefaultDueDatewhenaddingnewinvoices.\n",
            "Discount% Thediscountpercentagethevendoroffersforearlypayment.Ifthevalueiszero,nopercentagewillprintinthiscolumn.\n",
            "DiscountDays Thenumberofdaysthevendorallowsyoutotakethediscountin.IftheDiscount%andDiscountDaysarebothzero,noinformationwillprintinthiscolumn.\n",
            "-10-\n"
          ]
        }
      ],
      "source": [
        "print(text)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 18,
      "metadata": {
        "id": "-I2B1c0OPaRD"
      },
      "outputs": [],
      "source": [
        "new_vend_re = re.compile(r'^\\d{3}|\\(\\d{3}\\) [A-Z].*')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 19,
      "metadata": {
        "id": "jES6IaZ9PaRE",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ae27c0ed-1e0f-452f-8233-cf4c2d37da9a"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "(200) United Parcel Service\n",
            "201 Fed Ex 800.622.1147\n",
            "202 Software Technology, LLC 402-419-2200 5\n",
            "203 Clerk of the County Court\n",
            "204 Clerk of the District Court\n",
            "205 Business Week\n",
            "225 * Jackson/Wylinda\n",
            "240 NELCO 800-266-4669 30 2.00 10\n",
            "242 Office Supply Megastore 30 1.50 5\n",
            "250 * D & B Real Estate Management Company 402-222-5543\n",
            "400 Sprint Local & Long Distance 20\n",
            "700 * Clean All Janitorial Services 30\n",
            "999M Miscellaneous Vendor\n"
          ]
        }
      ],
      "source": [
        "for line in text.split('\\n'):\n",
        "    if new_vend_re.match(line):\n",
        "        print(line)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 20,
      "metadata": {
        "id": "ksCcfIlEPaRF",
        "outputId": "12556948-80ee-4d1b-d901-db76bf5625d8",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "999M\n",
            "Miscellaneous Vendor\n"
          ]
        }
      ],
      "source": [
        "for line in text.split('\\n'):\n",
        "    if new_vend_re.match(line):\n",
        "        vend_num, *vend_name = line.split()\n",
        "        vend_name = ' '.join(vend_name)\n",
        "print(vend_num)\n",
        "print(vend_name)"
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "q-tL762Ta2Eu"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "with pdfplumber.open(ap) as pdf:\n",
        "    page = pdf.pages[16]\n",
        "    text = page.extract_text()"
      ],
      "metadata": {
        "id": "dDlTkhSva2BP"
      },
      "execution_count": 26,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": 27,
      "metadata": {
        "id": "r4pEYGp3PaRF"
      },
      "outputs": [],
      "source": [
        "inv_line_re = re.compile(r'(\\d{6}) (\\d{6}) ([\\d,]+\\.\\d{2}) [\\sP]*([\\d,]+\\.\\d{2}) [YN ]*\\d (.*?) [*\\s\\d]')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 28,
      "metadata": {
        "id": "Dg9fMb79PaRG"
      },
      "outputs": [],
      "source": [
        "line_items = []\n",
        "for line in text.split('\\n'):\n",
        "    if new_vend_re.match(line):\n",
        "        vend_num, *vend_name = line.split()\n",
        "        vend_name = ' '.join(vend_name)    \n",
        "    \n",
        "    line = inv_line_re.search(line)\n",
        "    if line:\n",
        "        inv_dt = line.group(1)\n",
        "        due_dt = line.group(2)\n",
        "        inv_amt = line.group(3)\n",
        "        net_amt = line.group(4)\n",
        "        desc = line.group(5)\n",
        "        line_items.append(Inv(vend_num, vend_name, inv_dt, due_dt, inv_amt, net_amt, desc))"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "line_items"
      ],
      "metadata": {
        "id": "d_VyPIpda6Vg"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": 31,
      "metadata": {
        "id": "qnnnVfZXPaRG"
      },
      "outputs": [],
      "source": [
        "df = pd.DataFrame(line_items)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 33,
      "metadata": {
        "id": "g7pcdSCKPaRH",
        "outputId": "8022fde4-a603-40c2-eef6-f417a0e89d7d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        vend_num                                          vend_name  inv_dt  \\\n",
              "0      200.01MLJ  3243387 032422 062422 75.00 P 75.00 1 Overnigh...  032422   \n",
              "1        3243387          032522 062522 75.00 P 75.00 3 Postage * 1  032522   \n",
              "2        3243387  072422 072422 75.00 P 75.00 2 Overnight docume...  072422   \n",
              "3         312205  081822 082322 490.00 P 490.00 1 Software Maint...  081822   \n",
              "4         312206  081822 082322 239.00 P 239.00 2 Software Maint...  081822   \n",
              "5         312207  081822 082322 239.00 P 239.00 3 Software Maint...  081822   \n",
              "6         312208  081822 082322 239.00 P 239.00 4 Software Maint...  081822   \n",
              "7         312209  081822 082322 800.00 P 800.00 5 Software Maint...  081822   \n",
              "8         312210  081822 082322 105.00 P 105.00 6 Software Maint...  081822   \n",
              "9         320559  082322 082822 205.00 205.00 7 Purchase Tabs3 D...  082322   \n",
              "10     200.01PAM  042422 042422 225.00 P 225.00 1 Documentation ...  042422   \n",
              "11        032522              032522 75.00 P 75.00 2 Filing fee * 1  032522   \n",
              "12        051822              051822 75.00 P 75.00 3 Filing fee * 1  051822   \n",
              "13        850.00  RON 081822 081822 150.00 150.00 1 Petition for...  081822   \n",
              "14        122221       122221 750.00 P 750.00 Y 2 Holiday Party * 1  122221   \n",
              "15        072422  072422 1,500.00 P 1,500.00 Y 1 Catering/Firm R...  072422   \n",
              "16          5065  2094756 072422 082422 129.85 P 129.85 1 Check ...  072422   \n",
              "17           250               D & B Real Estate Management Company  072022   \n",
              "18           250               D & B Real Estate Management Company  072422   \n",
              "19          5074  KEY 081122 081122 10.00 10.00 N 3 Duplicate Ke...  081122   \n",
              "20        042322     042322 4.00 P 4.00 3 Online Legal Research * 1  042322   \n",
              "21        052222   052222 75.00 P 75.00 1 Online Legal Research * 1  052222   \n",
              "22        062322   062322 40.00 P 40.00 4 Online Legal Research * 1  062322   \n",
              "23        072722     072722 4.00 P 4.00 2 Online Legal Research * 1  072722   \n",
              "24        072822   072822 50.00 P 50.00 5 Online Legal Research * 1  072822   \n",
              "25        072822   072822 50.00 P 50.00 6 Online Legal Research * 1  072822   \n",
              "26        072822   072822 50.00 P 50.00 7 Online Legal Research * 1  072822   \n",
              "27        072822   072822 50.00 P 50.00 8 Online Legal Research * 1  072822   \n",
              "28        061922           061922 20.00 P 20.00 Y 2 Courier Fee * 1  061922   \n",
              "29        062222           062222 25.00 P 25.00 Y 4 Courier Fee * 1  062222   \n",
              "30        082322           082322 47.50 P 47.50 Y 1 Courier Fee * 1  082322   \n",
              "31        082322           082322 35.00 P 35.00 Y 3 Courier Fee * 1  082322   \n",
              "32  402310760011  081822 082322 68.96 68.96 1 November Cell Phon...  081822   \n",
              "33           700                      Clean All Janitorial Services  072022   \n",
              "34           700                      Clean All Janitorial Services  072422   \n",
              "\n",
              "    due_dt   inv_amt   net_amt  \\\n",
              "0   062422     75.00     75.00   \n",
              "1   062522     75.00     75.00   \n",
              "2   072422     75.00     75.00   \n",
              "3   082322    490.00    490.00   \n",
              "4   082322    239.00    239.00   \n",
              "5   082322    239.00    239.00   \n",
              "6   082322    239.00    239.00   \n",
              "7   082322    800.00    800.00   \n",
              "8   082322    105.00    105.00   \n",
              "9   082822    205.00    205.00   \n",
              "10  042422    225.00    225.00   \n",
              "11  032522     75.00     75.00   \n",
              "12  051822     75.00     75.00   \n",
              "13  081822    150.00    150.00   \n",
              "14  122221    750.00    750.00   \n",
              "15  072422  1,500.00  1,500.00   \n",
              "16  082422    129.85    129.85   \n",
              "17  072022  7,500.00  7,500.00   \n",
              "18  072422  7,500.00  7,500.00   \n",
              "19  081122     10.00     10.00   \n",
              "20  042322      4.00      4.00   \n",
              "21  052222     75.00     75.00   \n",
              "22  062322     40.00     40.00   \n",
              "23  072722      4.00      4.00   \n",
              "24  072822     50.00     50.00   \n",
              "25  072822     50.00     50.00   \n",
              "26  072822     50.00     50.00   \n",
              "27  072822     50.00     50.00   \n",
              "28  061922     20.00     20.00   \n",
              "29  062222     25.00     25.00   \n",
              "30  082322     47.50     47.50   \n",
              "31  082322     35.00     35.00   \n",
              "32  082322     68.96     68.96   \n",
              "33  072322    750.00    750.00   \n",
              "34  082322    750.00    750.00   \n",
              "\n",
              "                                          description  \n",
              "0                         Overnight document delivery  \n",
              "1                                             Postage  \n",
              "2                         Overnight document delivery  \n",
              "3                Software Maintenance Agreement Tabs3  \n",
              "4   Software Maintenance Agreement Tabs3 General L...  \n",
              "5   Software Maintenance Agreement Tabs3 Accounts ...  \n",
              "6   Software Maintenance Agreement Tabs3 Trust Acc...  \n",
              "7   Software Maintenance Agreement PracticeMaster ...  \n",
              "8       Software Maintenance Agreement Tabs3 Taskbill  \n",
              "9             Purchase Tabs3 Device Interface Program  \n",
              "10  Documentation Fee, Filing Fee, and Sheriff Ser...  \n",
              "11                                         Filing fee  \n",
              "12                                         Filing fee  \n",
              "13    Petition for Dissolution of Marriage Filing Fee  \n",
              "14                                      Holiday Party  \n",
              "15                              Catering/Firm Retreat  \n",
              "16                 Check order for APS and TAS Checks  \n",
              "17   Monthly Rent (Including Electric, Gas & Garbage)  \n",
              "18   Monthly Rent (Including Electric, Gas & Garbage)  \n",
              "19                         Duplicate Key for building  \n",
              "20                              Online Legal Research  \n",
              "21                              Online Legal Research  \n",
              "22                              Online Legal Research  \n",
              "23                              Online Legal Research  \n",
              "24                              Online Legal Research  \n",
              "25                              Online Legal Research  \n",
              "26                              Online Legal Research  \n",
              "27                              Online Legal Research  \n",
              "28                                        Courier Fee  \n",
              "29                                        Courier Fee  \n",
              "30                                        Courier Fee  \n",
              "31                                        Courier Fee  \n",
              "32                        November Cell Phone Charges  \n",
              "33       Monthly Cleaning Charges (Bi-Weekly Service)  \n",
              "34       Monthly Cleaning Charges (Bi-Weekly Service)  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-02b58a77-0182-42f3-a349-9f99f3258561\">\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>vend_num</th>\n",
              "      <th>vend_name</th>\n",
              "      <th>inv_dt</th>\n",
              "      <th>due_dt</th>\n",
              "      <th>inv_amt</th>\n",
              "      <th>net_amt</th>\n",
              "      <th>description</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>200.01MLJ</td>\n",
              "      <td>3243387 032422 062422 75.00 P 75.00 1 Overnigh...</td>\n",
              "      <td>032422</td>\n",
              "      <td>062422</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Overnight document delivery</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>3243387</td>\n",
              "      <td>032522 062522 75.00 P 75.00 3 Postage * 1</td>\n",
              "      <td>032522</td>\n",
              "      <td>062522</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Postage</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3243387</td>\n",
              "      <td>072422 072422 75.00 P 75.00 2 Overnight docume...</td>\n",
              "      <td>072422</td>\n",
              "      <td>072422</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Overnight document delivery</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>312205</td>\n",
              "      <td>081822 082322 490.00 P 490.00 1 Software Maint...</td>\n",
              "      <td>081822</td>\n",
              "      <td>082322</td>\n",
              "      <td>490.00</td>\n",
              "      <td>490.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>312206</td>\n",
              "      <td>081822 082322 239.00 P 239.00 2 Software Maint...</td>\n",
              "      <td>081822</td>\n",
              "      <td>082322</td>\n",
              "      <td>239.00</td>\n",
              "      <td>239.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 General L...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>312207</td>\n",
              "      <td>081822 082322 239.00 P 239.00 3 Software Maint...</td>\n",
              "      <td>081822</td>\n",
              "      <td>082322</td>\n",
              "      <td>239.00</td>\n",
              "      <td>239.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 Accounts ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>312208</td>\n",
              "      <td>081822 082322 239.00 P 239.00 4 Software Maint...</td>\n",
              "      <td>081822</td>\n",
              "      <td>082322</td>\n",
              "      <td>239.00</td>\n",
              "      <td>239.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 Trust Acc...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>312209</td>\n",
              "      <td>081822 082322 800.00 P 800.00 5 Software Maint...</td>\n",
              "      <td>081822</td>\n",
              "      <td>082322</td>\n",
              "      <td>800.00</td>\n",
              "      <td>800.00</td>\n",
              "      <td>Software Maintenance Agreement PracticeMaster ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>312210</td>\n",
              "      <td>081822 082322 105.00 P 105.00 6 Software Maint...</td>\n",
              "      <td>081822</td>\n",
              "      <td>082322</td>\n",
              "      <td>105.00</td>\n",
              "      <td>105.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 Taskbill</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>320559</td>\n",
              "      <td>082322 082822 205.00 205.00 7 Purchase Tabs3 D...</td>\n",
              "      <td>082322</td>\n",
              "      <td>082822</td>\n",
              "      <td>205.00</td>\n",
              "      <td>205.00</td>\n",
              "      <td>Purchase Tabs3 Device Interface Program</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>200.01PAM</td>\n",
              "      <td>042422 042422 225.00 P 225.00 1 Documentation ...</td>\n",
              "      <td>042422</td>\n",
              "      <td>042422</td>\n",
              "      <td>225.00</td>\n",
              "      <td>225.00</td>\n",
              "      <td>Documentation Fee, Filing Fee, and Sheriff Ser...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>032522</td>\n",
              "      <td>032522 75.00 P 75.00 2 Filing fee * 1</td>\n",
              "      <td>032522</td>\n",
              "      <td>032522</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Filing fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>051822</td>\n",
              "      <td>051822 75.00 P 75.00 3 Filing fee * 1</td>\n",
              "      <td>051822</td>\n",
              "      <td>051822</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Filing fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>850.00</td>\n",
              "      <td>RON 081822 081822 150.00 150.00 1 Petition for...</td>\n",
              "      <td>081822</td>\n",
              "      <td>081822</td>\n",
              "      <td>150.00</td>\n",
              "      <td>150.00</td>\n",
              "      <td>Petition for Dissolution of Marriage Filing Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>122221</td>\n",
              "      <td>122221 750.00 P 750.00 Y 2 Holiday Party * 1</td>\n",
              "      <td>122221</td>\n",
              "      <td>122221</td>\n",
              "      <td>750.00</td>\n",
              "      <td>750.00</td>\n",
              "      <td>Holiday Party</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>072422</td>\n",
              "      <td>072422 1,500.00 P 1,500.00 Y 1 Catering/Firm R...</td>\n",
              "      <td>072422</td>\n",
              "      <td>072422</td>\n",
              "      <td>1,500.00</td>\n",
              "      <td>1,500.00</td>\n",
              "      <td>Catering/Firm Retreat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>5065</td>\n",
              "      <td>2094756 072422 082422 129.85 P 129.85 1 Check ...</td>\n",
              "      <td>072422</td>\n",
              "      <td>082422</td>\n",
              "      <td>129.85</td>\n",
              "      <td>129.85</td>\n",
              "      <td>Check order for APS and TAS Checks</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>250</td>\n",
              "      <td>D &amp; B Real Estate Management Company</td>\n",
              "      <td>072022</td>\n",
              "      <td>072022</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>Monthly Rent (Including Electric, Gas &amp; Garbage)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>250</td>\n",
              "      <td>D &amp; B Real Estate Management Company</td>\n",
              "      <td>072422</td>\n",
              "      <td>072422</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>Monthly Rent (Including Electric, Gas &amp; Garbage)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>5074</td>\n",
              "      <td>KEY 081122 081122 10.00 10.00 N 3 Duplicate Ke...</td>\n",
              "      <td>081122</td>\n",
              "      <td>081122</td>\n",
              "      <td>10.00</td>\n",
              "      <td>10.00</td>\n",
              "      <td>Duplicate Key for building</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>042322</td>\n",
              "      <td>042322 4.00 P 4.00 3 Online Legal Research * 1</td>\n",
              "      <td>042322</td>\n",
              "      <td>042322</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>052222</td>\n",
              "      <td>052222 75.00 P 75.00 1 Online Legal Research * 1</td>\n",
              "      <td>052222</td>\n",
              "      <td>052222</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>062322</td>\n",
              "      <td>062322 40.00 P 40.00 4 Online Legal Research * 1</td>\n",
              "      <td>062322</td>\n",
              "      <td>062322</td>\n",
              "      <td>40.00</td>\n",
              "      <td>40.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>072722</td>\n",
              "      <td>072722 4.00 P 4.00 2 Online Legal Research * 1</td>\n",
              "      <td>072722</td>\n",
              "      <td>072722</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 5 Online Legal Research * 1</td>\n",
              "      <td>072822</td>\n",
              "      <td>072822</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 6 Online Legal Research * 1</td>\n",
              "      <td>072822</td>\n",
              "      <td>072822</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 7 Online Legal Research * 1</td>\n",
              "      <td>072822</td>\n",
              "      <td>072822</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 8 Online Legal Research * 1</td>\n",
              "      <td>072822</td>\n",
              "      <td>072822</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>061922</td>\n",
              "      <td>061922 20.00 P 20.00 Y 2 Courier Fee * 1</td>\n",
              "      <td>061922</td>\n",
              "      <td>061922</td>\n",
              "      <td>20.00</td>\n",
              "      <td>20.00</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>062222</td>\n",
              "      <td>062222 25.00 P 25.00 Y 4 Courier Fee * 1</td>\n",
              "      <td>062222</td>\n",
              "      <td>062222</td>\n",
              "      <td>25.00</td>\n",
              "      <td>25.00</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>082322</td>\n",
              "      <td>082322 47.50 P 47.50 Y 1 Courier Fee * 1</td>\n",
              "      <td>082322</td>\n",
              "      <td>082322</td>\n",
              "      <td>47.50</td>\n",
              "      <td>47.50</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>082322</td>\n",
              "      <td>082322 35.00 P 35.00 Y 3 Courier Fee * 1</td>\n",
              "      <td>082322</td>\n",
              "      <td>082322</td>\n",
              "      <td>35.00</td>\n",
              "      <td>35.00</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>402310760011</td>\n",
              "      <td>081822 082322 68.96 68.96 1 November Cell Phon...</td>\n",
              "      <td>081822</td>\n",
              "      <td>082322</td>\n",
              "      <td>68.96</td>\n",
              "      <td>68.96</td>\n",
              "      <td>November Cell Phone Charges</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>700</td>\n",
              "      <td>Clean All Janitorial Services</td>\n",
              "      <td>072022</td>\n",
              "      <td>072322</td>\n",
              "      <td>750.00</td>\n",
              "      <td>750.00</td>\n",
              "      <td>Monthly Cleaning Charges (Bi-Weekly Service)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>700</td>\n",
              "      <td>Clean All Janitorial Services</td>\n",
              "      <td>072422</td>\n",
              "      <td>082322</td>\n",
              "      <td>750.00</td>\n",
              "      <td>750.00</td>\n",
              "      <td>Monthly Cleaning Charges (Bi-Weekly Service)</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-02b58a77-0182-42f3-a349-9f99f3258561')\"\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-02b58a77-0182-42f3-a349-9f99f3258561 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-02b58a77-0182-42f3-a349-9f99f3258561');\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",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ],
      "source": [
        "df"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 34,
      "metadata": {
        "id": "XUfvoOpDPaRH"
      },
      "outputs": [],
      "source": [
        "df['inv_dt'] = pd.to_datetime(df['inv_dt'])\n",
        "df['due_dt'] = pd.to_datetime(df['due_dt'])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 35,
      "metadata": {
        "id": "C3CR11KpPaRH",
        "outputId": "37600165-4c27-465b-b668-88bbbc692197",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        vend_num                                          vend_name  \\\n",
              "0      200.01MLJ  3243387 032422 062422 75.00 P 75.00 1 Overnigh...   \n",
              "1        3243387          032522 062522 75.00 P 75.00 3 Postage * 1   \n",
              "2        3243387  072422 072422 75.00 P 75.00 2 Overnight docume...   \n",
              "3         312205  081822 082322 490.00 P 490.00 1 Software Maint...   \n",
              "4         312206  081822 082322 239.00 P 239.00 2 Software Maint...   \n",
              "5         312207  081822 082322 239.00 P 239.00 3 Software Maint...   \n",
              "6         312208  081822 082322 239.00 P 239.00 4 Software Maint...   \n",
              "7         312209  081822 082322 800.00 P 800.00 5 Software Maint...   \n",
              "8         312210  081822 082322 105.00 P 105.00 6 Software Maint...   \n",
              "9         320559  082322 082822 205.00 205.00 7 Purchase Tabs3 D...   \n",
              "10     200.01PAM  042422 042422 225.00 P 225.00 1 Documentation ...   \n",
              "11        032522              032522 75.00 P 75.00 2 Filing fee * 1   \n",
              "12        051822              051822 75.00 P 75.00 3 Filing fee * 1   \n",
              "13        850.00  RON 081822 081822 150.00 150.00 1 Petition for...   \n",
              "14        122221       122221 750.00 P 750.00 Y 2 Holiday Party * 1   \n",
              "15        072422  072422 1,500.00 P 1,500.00 Y 1 Catering/Firm R...   \n",
              "16          5065  2094756 072422 082422 129.85 P 129.85 1 Check ...   \n",
              "17           250               D & B Real Estate Management Company   \n",
              "18           250               D & B Real Estate Management Company   \n",
              "19          5074  KEY 081122 081122 10.00 10.00 N 3 Duplicate Ke...   \n",
              "20        042322     042322 4.00 P 4.00 3 Online Legal Research * 1   \n",
              "21        052222   052222 75.00 P 75.00 1 Online Legal Research * 1   \n",
              "22        062322   062322 40.00 P 40.00 4 Online Legal Research * 1   \n",
              "23        072722     072722 4.00 P 4.00 2 Online Legal Research * 1   \n",
              "24        072822   072822 50.00 P 50.00 5 Online Legal Research * 1   \n",
              "25        072822   072822 50.00 P 50.00 6 Online Legal Research * 1   \n",
              "26        072822   072822 50.00 P 50.00 7 Online Legal Research * 1   \n",
              "27        072822   072822 50.00 P 50.00 8 Online Legal Research * 1   \n",
              "28        061922           061922 20.00 P 20.00 Y 2 Courier Fee * 1   \n",
              "29        062222           062222 25.00 P 25.00 Y 4 Courier Fee * 1   \n",
              "30        082322           082322 47.50 P 47.50 Y 1 Courier Fee * 1   \n",
              "31        082322           082322 35.00 P 35.00 Y 3 Courier Fee * 1   \n",
              "32  402310760011  081822 082322 68.96 68.96 1 November Cell Phon...   \n",
              "33           700                      Clean All Janitorial Services   \n",
              "34           700                      Clean All Janitorial Services   \n",
              "\n",
              "       inv_dt     due_dt   inv_amt   net_amt  \\\n",
              "0  2022-03-24 2022-06-24     75.00     75.00   \n",
              "1  2022-03-25 2022-06-25     75.00     75.00   \n",
              "2  2022-07-24 2022-07-24     75.00     75.00   \n",
              "3  2022-08-18 2022-08-23    490.00    490.00   \n",
              "4  2022-08-18 2022-08-23    239.00    239.00   \n",
              "5  2022-08-18 2022-08-23    239.00    239.00   \n",
              "6  2022-08-18 2022-08-23    239.00    239.00   \n",
              "7  2022-08-18 2022-08-23    800.00    800.00   \n",
              "8  2022-08-18 2022-08-23    105.00    105.00   \n",
              "9  2022-08-23 2022-08-28    205.00    205.00   \n",
              "10 2022-04-24 2022-04-24    225.00    225.00   \n",
              "11 2022-03-25 2022-03-25     75.00     75.00   \n",
              "12 2022-05-18 2022-05-18     75.00     75.00   \n",
              "13 2022-08-18 2022-08-18    150.00    150.00   \n",
              "14 2021-12-22 2021-12-22    750.00    750.00   \n",
              "15 2022-07-24 2022-07-24  1,500.00  1,500.00   \n",
              "16 2022-07-24 2022-08-24    129.85    129.85   \n",
              "17 2022-07-20 2022-07-20  7,500.00  7,500.00   \n",
              "18 2022-07-24 2022-07-24  7,500.00  7,500.00   \n",
              "19 2022-08-11 2022-08-11     10.00     10.00   \n",
              "20 2022-04-23 2022-04-23      4.00      4.00   \n",
              "21 2022-05-22 2022-05-22     75.00     75.00   \n",
              "22 2022-06-23 2022-06-23     40.00     40.00   \n",
              "23 2022-07-27 2022-07-27      4.00      4.00   \n",
              "24 2022-07-28 2022-07-28     50.00     50.00   \n",
              "25 2022-07-28 2022-07-28     50.00     50.00   \n",
              "26 2022-07-28 2022-07-28     50.00     50.00   \n",
              "27 2022-07-28 2022-07-28     50.00     50.00   \n",
              "28 2022-06-19 2022-06-19     20.00     20.00   \n",
              "29 2022-06-22 2022-06-22     25.00     25.00   \n",
              "30 2022-08-23 2022-08-23     47.50     47.50   \n",
              "31 2022-08-23 2022-08-23     35.00     35.00   \n",
              "32 2022-08-18 2022-08-23     68.96     68.96   \n",
              "33 2022-07-20 2022-07-23    750.00    750.00   \n",
              "34 2022-07-24 2022-08-23    750.00    750.00   \n",
              "\n",
              "                                          description  \n",
              "0                         Overnight document delivery  \n",
              "1                                             Postage  \n",
              "2                         Overnight document delivery  \n",
              "3                Software Maintenance Agreement Tabs3  \n",
              "4   Software Maintenance Agreement Tabs3 General L...  \n",
              "5   Software Maintenance Agreement Tabs3 Accounts ...  \n",
              "6   Software Maintenance Agreement Tabs3 Trust Acc...  \n",
              "7   Software Maintenance Agreement PracticeMaster ...  \n",
              "8       Software Maintenance Agreement Tabs3 Taskbill  \n",
              "9             Purchase Tabs3 Device Interface Program  \n",
              "10  Documentation Fee, Filing Fee, and Sheriff Ser...  \n",
              "11                                         Filing fee  \n",
              "12                                         Filing fee  \n",
              "13    Petition for Dissolution of Marriage Filing Fee  \n",
              "14                                      Holiday Party  \n",
              "15                              Catering/Firm Retreat  \n",
              "16                 Check order for APS and TAS Checks  \n",
              "17   Monthly Rent (Including Electric, Gas & Garbage)  \n",
              "18   Monthly Rent (Including Electric, Gas & Garbage)  \n",
              "19                         Duplicate Key for building  \n",
              "20                              Online Legal Research  \n",
              "21                              Online Legal Research  \n",
              "22                              Online Legal Research  \n",
              "23                              Online Legal Research  \n",
              "24                              Online Legal Research  \n",
              "25                              Online Legal Research  \n",
              "26                              Online Legal Research  \n",
              "27                              Online Legal Research  \n",
              "28                                        Courier Fee  \n",
              "29                                        Courier Fee  \n",
              "30                                        Courier Fee  \n",
              "31                                        Courier Fee  \n",
              "32                        November Cell Phone Charges  \n",
              "33       Monthly Cleaning Charges (Bi-Weekly Service)  \n",
              "34       Monthly Cleaning Charges (Bi-Weekly Service)  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-afbc561d-486b-4f3e-ad1e-f0b344b295d7\">\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>vend_num</th>\n",
              "      <th>vend_name</th>\n",
              "      <th>inv_dt</th>\n",
              "      <th>due_dt</th>\n",
              "      <th>inv_amt</th>\n",
              "      <th>net_amt</th>\n",
              "      <th>description</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>200.01MLJ</td>\n",
              "      <td>3243387 032422 062422 75.00 P 75.00 1 Overnigh...</td>\n",
              "      <td>2022-03-24</td>\n",
              "      <td>2022-06-24</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Overnight document delivery</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>3243387</td>\n",
              "      <td>032522 062522 75.00 P 75.00 3 Postage * 1</td>\n",
              "      <td>2022-03-25</td>\n",
              "      <td>2022-06-25</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Postage</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3243387</td>\n",
              "      <td>072422 072422 75.00 P 75.00 2 Overnight docume...</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Overnight document delivery</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>312205</td>\n",
              "      <td>081822 082322 490.00 P 490.00 1 Software Maint...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>490.00</td>\n",
              "      <td>490.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>312206</td>\n",
              "      <td>081822 082322 239.00 P 239.00 2 Software Maint...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>239.00</td>\n",
              "      <td>239.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 General L...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>312207</td>\n",
              "      <td>081822 082322 239.00 P 239.00 3 Software Maint...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>239.00</td>\n",
              "      <td>239.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 Accounts ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>312208</td>\n",
              "      <td>081822 082322 239.00 P 239.00 4 Software Maint...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>239.00</td>\n",
              "      <td>239.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 Trust Acc...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>312209</td>\n",
              "      <td>081822 082322 800.00 P 800.00 5 Software Maint...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>800.00</td>\n",
              "      <td>800.00</td>\n",
              "      <td>Software Maintenance Agreement PracticeMaster ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>312210</td>\n",
              "      <td>081822 082322 105.00 P 105.00 6 Software Maint...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>105.00</td>\n",
              "      <td>105.00</td>\n",
              "      <td>Software Maintenance Agreement Tabs3 Taskbill</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>320559</td>\n",
              "      <td>082322 082822 205.00 205.00 7 Purchase Tabs3 D...</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>2022-08-28</td>\n",
              "      <td>205.00</td>\n",
              "      <td>205.00</td>\n",
              "      <td>Purchase Tabs3 Device Interface Program</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>200.01PAM</td>\n",
              "      <td>042422 042422 225.00 P 225.00 1 Documentation ...</td>\n",
              "      <td>2022-04-24</td>\n",
              "      <td>2022-04-24</td>\n",
              "      <td>225.00</td>\n",
              "      <td>225.00</td>\n",
              "      <td>Documentation Fee, Filing Fee, and Sheriff Ser...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>032522</td>\n",
              "      <td>032522 75.00 P 75.00 2 Filing fee * 1</td>\n",
              "      <td>2022-03-25</td>\n",
              "      <td>2022-03-25</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Filing fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>051822</td>\n",
              "      <td>051822 75.00 P 75.00 3 Filing fee * 1</td>\n",
              "      <td>2022-05-18</td>\n",
              "      <td>2022-05-18</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Filing fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>850.00</td>\n",
              "      <td>RON 081822 081822 150.00 150.00 1 Petition for...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>150.00</td>\n",
              "      <td>150.00</td>\n",
              "      <td>Petition for Dissolution of Marriage Filing Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>122221</td>\n",
              "      <td>122221 750.00 P 750.00 Y 2 Holiday Party * 1</td>\n",
              "      <td>2021-12-22</td>\n",
              "      <td>2021-12-22</td>\n",
              "      <td>750.00</td>\n",
              "      <td>750.00</td>\n",
              "      <td>Holiday Party</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>072422</td>\n",
              "      <td>072422 1,500.00 P 1,500.00 Y 1 Catering/Firm R...</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>1,500.00</td>\n",
              "      <td>1,500.00</td>\n",
              "      <td>Catering/Firm Retreat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>5065</td>\n",
              "      <td>2094756 072422 082422 129.85 P 129.85 1 Check ...</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>2022-08-24</td>\n",
              "      <td>129.85</td>\n",
              "      <td>129.85</td>\n",
              "      <td>Check order for APS and TAS Checks</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>250</td>\n",
              "      <td>D &amp; B Real Estate Management Company</td>\n",
              "      <td>2022-07-20</td>\n",
              "      <td>2022-07-20</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>Monthly Rent (Including Electric, Gas &amp; Garbage)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>250</td>\n",
              "      <td>D &amp; B Real Estate Management Company</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>7,500.00</td>\n",
              "      <td>Monthly Rent (Including Electric, Gas &amp; Garbage)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>5074</td>\n",
              "      <td>KEY 081122 081122 10.00 10.00 N 3 Duplicate Ke...</td>\n",
              "      <td>2022-08-11</td>\n",
              "      <td>2022-08-11</td>\n",
              "      <td>10.00</td>\n",
              "      <td>10.00</td>\n",
              "      <td>Duplicate Key for building</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>042322</td>\n",
              "      <td>042322 4.00 P 4.00 3 Online Legal Research * 1</td>\n",
              "      <td>2022-04-23</td>\n",
              "      <td>2022-04-23</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>052222</td>\n",
              "      <td>052222 75.00 P 75.00 1 Online Legal Research * 1</td>\n",
              "      <td>2022-05-22</td>\n",
              "      <td>2022-05-22</td>\n",
              "      <td>75.00</td>\n",
              "      <td>75.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>062322</td>\n",
              "      <td>062322 40.00 P 40.00 4 Online Legal Research * 1</td>\n",
              "      <td>2022-06-23</td>\n",
              "      <td>2022-06-23</td>\n",
              "      <td>40.00</td>\n",
              "      <td>40.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>072722</td>\n",
              "      <td>072722 4.00 P 4.00 2 Online Legal Research * 1</td>\n",
              "      <td>2022-07-27</td>\n",
              "      <td>2022-07-27</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 5 Online Legal Research * 1</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 6 Online Legal Research * 1</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 7 Online Legal Research * 1</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>072822</td>\n",
              "      <td>072822 50.00 P 50.00 8 Online Legal Research * 1</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>2022-07-28</td>\n",
              "      <td>50.00</td>\n",
              "      <td>50.00</td>\n",
              "      <td>Online Legal Research</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>061922</td>\n",
              "      <td>061922 20.00 P 20.00 Y 2 Courier Fee * 1</td>\n",
              "      <td>2022-06-19</td>\n",
              "      <td>2022-06-19</td>\n",
              "      <td>20.00</td>\n",
              "      <td>20.00</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>062222</td>\n",
              "      <td>062222 25.00 P 25.00 Y 4 Courier Fee * 1</td>\n",
              "      <td>2022-06-22</td>\n",
              "      <td>2022-06-22</td>\n",
              "      <td>25.00</td>\n",
              "      <td>25.00</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>082322</td>\n",
              "      <td>082322 47.50 P 47.50 Y 1 Courier Fee * 1</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>47.50</td>\n",
              "      <td>47.50</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>082322</td>\n",
              "      <td>082322 35.00 P 35.00 Y 3 Courier Fee * 1</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>35.00</td>\n",
              "      <td>35.00</td>\n",
              "      <td>Courier Fee</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>402310760011</td>\n",
              "      <td>081822 082322 68.96 68.96 1 November Cell Phon...</td>\n",
              "      <td>2022-08-18</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>68.96</td>\n",
              "      <td>68.96</td>\n",
              "      <td>November Cell Phone Charges</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>700</td>\n",
              "      <td>Clean All Janitorial Services</td>\n",
              "      <td>2022-07-20</td>\n",
              "      <td>2022-07-23</td>\n",
              "      <td>750.00</td>\n",
              "      <td>750.00</td>\n",
              "      <td>Monthly Cleaning Charges (Bi-Weekly Service)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>700</td>\n",
              "      <td>Clean All Janitorial Services</td>\n",
              "      <td>2022-07-24</td>\n",
              "      <td>2022-08-23</td>\n",
              "      <td>750.00</td>\n",
              "      <td>750.00</td>\n",
              "      <td>Monthly Cleaning Charges (Bi-Weekly Service)</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-afbc561d-486b-4f3e-ad1e-f0b344b295d7')\"\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-afbc561d-486b-4f3e-ad1e-f0b344b295d7 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-afbc561d-486b-4f3e-ad1e-f0b344b295d7');\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",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ],
      "source": [
        "df"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 36,
      "metadata": {
        "id": "Oitq1u6HPaRI"
      },
      "outputs": [],
      "source": [
        "df['inv_amt'] = df['inv_amt'].map(lambda x: float(x.replace(',', '')))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 37,
      "metadata": {
        "id": "9_C1auyMPaRI"
      },
      "outputs": [],
      "source": [
        "df['net_amt'] = df['net_amt'].map(lambda x: float(x.replace(',', '')))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 38,
      "metadata": {
        "id": "yMQDPqgxPaRI",
        "outputId": "d6ee1176-5cd2-4e7c-da06-027701cf56fe",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-38-7e5fdb616c56>:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError.  Select only valid columns before calling the reduction.\n",
            "  df.sum()\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "vend_num       200.01MLJ3243387324338731220531220631220731220...\n",
              "vend_name      3243387 032422 062422 75.00 P 75.00 1 Overnigh...\n",
              "inv_amt                                                 22476.31\n",
              "net_amt                                                 22476.31\n",
              "description    Overnight document deliveryPostageOvernight do...\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ],
      "source": [
        "df.sum()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "2Zf8ubqMPaRJ"
      },
      "outputs": [],
      "source": [
        "df.to_csv('inv_lines.csv')"
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.7.6"
    },
    "colab": {
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}