Review of Pandas Basics.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Review of Pandas\n",
    "\n",
    "-----"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Preliminaries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/home/data_scientist/accy575'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Print working directory\n",
    "%pwd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/home/data_scientist/accy575/readonly/Pcard\n"
     ]
    }
   ],
   "source": [
    "%cd '/home/data_scientist/accy575/readonly/Pcard'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[0m\u001b[01;32mPCard_FY2010.csv\u001b[0m*  \u001b[01;32mPCard_FY2012.csv\u001b[0m*  \u001b[01;32mPCard_FY2014.csv\u001b[0m*\r\n",
      "\u001b[01;32mPCard_FY2011.csv\u001b[0m*  \u001b[01;32mPCard_FY2013.csv\u001b[0m*  \u001b[01;32mPCard_FY2015.csv\u001b[0m*\r\n"
     ]
    }
   ],
   "source": [
    "%ls"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The `Series` Data Structure"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can think of a series as a single column of data. Each element of the series has a label (called the index). \n",
    "\n",
    "Let's create a simple series:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    a\n",
       "1    b\n",
       "2    c\n",
       "3    d\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s1 = pd.Series(['a','b','c','d'])\n",
    "s1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'c'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s1[2]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Notice that, by default, Pandas created labels for each element of my series. These default labels always start at 0. If I want to use different labels, I can do so:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "element 1    a\n",
       "element 2    b\n",
       "element 3    c\n",
       "element 4    d\n",
       "dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s2 = pd.Series(\n",
    "    ['a','b','c','d'], \n",
    "    index = ['element 1', 'element 2', 'element 3', 'element 4']\n",
    ")\n",
    "s2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'c'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s2['element 3']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The `DataFrame` Data Structure\n",
    "\n",
    "You can think of a DataFrame as a table of data, with rows and columns. Alternatively, you can think of a DataFrame as a collection of Series objects, _each of which share the same row index_.\n",
    "\n",
    "I will now show you how to create a DataFrames from a CSV file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df2012 = pd.read_csv('PCard_FY2012.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's look at the first 5 rows of the DataFrame using the head command."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Agency Number</th>\n",
       "      <th>Agency Name</th>\n",
       "      <th>Cardholder Last Name</th>\n",
       "      <th>Cardholder First Initial</th>\n",
       "      <th>Description</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Vendor</th>\n",
       "      <th>Transaction Date</th>\n",
       "      <th>Posted Date</th>\n",
       "      <th>Merchant Category Code (MCC)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$60.07</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$41.29</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BEROUSEK</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($180.00)</td>\n",
       "      <td>A.C.E. SUPPLY &amp; SERVICE</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>STATIONERY  OFFICE SUPPLIES  PRINTING AND WRIT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>FOCHT</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$9.36</td>\n",
       "      <td>NAPA AUTO PARTS</td>\n",
       "      <td>29-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>AUTOMOTIVE PARTS AND ACCESSORIES STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>FOCHT</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$16.86</td>\n",
       "      <td>NAPA AUTO PARTS</td>\n",
       "      <td>29-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>AUTOMOTIVE PARTS AND ACCESSORIES STORES</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Agency Number                Agency Name Cardholder Last Name  \\\n",
       "0           1000  OKLAHOMA STATE UNIVERSITY                 BELL   \n",
       "1           1000  OKLAHOMA STATE UNIVERSITY                 BELL   \n",
       "2           1000  OKLAHOMA STATE UNIVERSITY             BEROUSEK   \n",
       "3           1000  OKLAHOMA STATE UNIVERSITY                FOCHT   \n",
       "4           1000  OKLAHOMA STATE UNIVERSITY                FOCHT   \n",
       "\n",
       "  Cardholder First Initial       Description     Amount  \\\n",
       "0                        D  GENERAL PURCHASE    $60.07    \n",
       "1                        D  GENERAL PURCHASE    $41.29    \n",
       "2                        M  GENERAL PURCHASE  ($180.00)   \n",
       "3                        R  GENERAL PURCHASE     $9.36    \n",
       "4                        R  GENERAL PURCHASE    $16.86    \n",
       "\n",
       "                    Vendor Transaction Date Posted Date  \\\n",
       "0           WM SUPERCENTER        30-Jun-11    1-Jul-11   \n",
       "1           WM SUPERCENTER        30-Jun-11    1-Jul-11   \n",
       "2  A.C.E. SUPPLY & SERVICE        30-Jun-11    1-Jul-11   \n",
       "3          NAPA AUTO PARTS        29-Jun-11    1-Jul-11   \n",
       "4          NAPA AUTO PARTS        29-Jun-11    1-Jul-11   \n",
       "\n",
       "                        Merchant Category Code (MCC)  \n",
       "0                    GROCERY STORES AND SUPERMARKETS  \n",
       "1                    GROCERY STORES AND SUPERMARKETS  \n",
       "2  STATIONERY  OFFICE SUPPLIES  PRINTING AND WRIT...  \n",
       "3            AUTOMOTIVE PARTS AND ACCESSORIES STORES  \n",
       "4            AUTOMOTIVE PARTS AND ACCESSORIES STORES  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2012.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is looking pretty good. Let's get some basic stats about our DataFrame:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(442184, 10)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# This gives (number of rows, number of columns)\n",
    "df2012.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Agency Number', 'Agency Name', 'Cardholder Last Name',\n",
       "       'Cardholder First Initial', 'Description', 'Amount', 'Vendor',\n",
       "       'Transaction Date', 'Posted Date', 'Merchant Category Code (MCC)'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2012.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Agency Number                    int64\n",
       "Agency Name                     object\n",
       "Cardholder Last Name            object\n",
       "Cardholder First Initial        object\n",
       "Description                     object\n",
       "Amount                          object\n",
       "Vendor                          object\n",
       "Transaction Date                object\n",
       "Posted Date                     object\n",
       "Merchant Category Code (MCC)    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2012.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 442184 entries, 0 to 442183\n",
      "Data columns (total 10 columns):\n",
      "Agency Number                   442184 non-null int64\n",
      "Agency Name                     442184 non-null object\n",
      "Cardholder Last Name            442184 non-null object\n",
      "Cardholder First Initial        442184 non-null object\n",
      "Description                     442147 non-null object\n",
      "Amount                          442184 non-null object\n",
      "Vendor                          442184 non-null object\n",
      "Transaction Date                442184 non-null object\n",
      "Posted Date                     442184 non-null object\n",
      "Merchant Category Code (MCC)    442184 non-null object\n",
      "dtypes: int64(1), object(9)\n",
      "memory usage: 33.7+ MB\n"
     ]
    }
   ],
   "source": [
    "df2012.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Renaming Columns\n",
    "\n",
    "What if we want to rename the columns? The best practice is to rename columns as you import the data:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Note: if you don't say header = 0, it will import these names as the first row of your dataset!\n",
    "\n",
    "newcolnames = ['agency_number', 'agency_name', 'last_name', 'first_initial', 'description',\n",
    "               'amount','vendor', 'transaction_date', 'posted_date', 'MCC']\n",
    "\n",
    "df2012 = pd.read_csv('PCard_FY2012.csv', skiprows = 1, names = newcolnames)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency_number</th>\n",
       "      <th>agency_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>first_initial</th>\n",
       "      <th>description</th>\n",
       "      <th>amount</th>\n",
       "      <th>vendor</th>\n",
       "      <th>transaction_date</th>\n",
       "      <th>posted_date</th>\n",
       "      <th>MCC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$60.07</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$41.29</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BEROUSEK</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($180.00)</td>\n",
       "      <td>A.C.E. SUPPLY &amp; SERVICE</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>STATIONERY  OFFICE SUPPLIES  PRINTING AND WRIT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>FOCHT</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$9.36</td>\n",
       "      <td>NAPA AUTO PARTS</td>\n",
       "      <td>29-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>AUTOMOTIVE PARTS AND ACCESSORIES STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>FOCHT</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$16.86</td>\n",
       "      <td>NAPA AUTO PARTS</td>\n",
       "      <td>29-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>AUTOMOTIVE PARTS AND ACCESSORIES STORES</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency_number                agency_name last_name first_initial  \\\n",
       "0           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "1           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "2           1000  OKLAHOMA STATE UNIVERSITY  BEROUSEK             M   \n",
       "3           1000  OKLAHOMA STATE UNIVERSITY     FOCHT             R   \n",
       "4           1000  OKLAHOMA STATE UNIVERSITY     FOCHT             R   \n",
       "\n",
       "        description     amount                   vendor transaction_date  \\\n",
       "0  GENERAL PURCHASE    $60.07            WM SUPERCENTER        30-Jun-11   \n",
       "1  GENERAL PURCHASE    $41.29            WM SUPERCENTER        30-Jun-11   \n",
       "2  GENERAL PURCHASE  ($180.00)  A.C.E. SUPPLY & SERVICE        30-Jun-11   \n",
       "3  GENERAL PURCHASE     $9.36           NAPA AUTO PARTS        29-Jun-11   \n",
       "4  GENERAL PURCHASE    $16.86           NAPA AUTO PARTS        29-Jun-11   \n",
       "\n",
       "  posted_date                                                MCC  \n",
       "0    1-Jul-11                    GROCERY STORES AND SUPERMARKETS  \n",
       "1    1-Jul-11                    GROCERY STORES AND SUPERMARKETS  \n",
       "2    1-Jul-11  STATIONERY  OFFICE SUPPLIES  PRINTING AND WRIT...  \n",
       "3    1-Jul-11            AUTOMOTIVE PARTS AND ACCESSORIES STORES  \n",
       "4    1-Jul-11            AUTOMOTIVE PARTS AND ACCESSORIES STORES  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2012.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 442184 entries, 0 to 442183\n",
      "Data columns (total 10 columns):\n",
      "agency_number       442184 non-null int64\n",
      "agency_name         442184 non-null object\n",
      "last_name           442184 non-null object\n",
      "first_initial       442184 non-null object\n",
      "description         442147 non-null object\n",
      "amount              442184 non-null object\n",
      "vendor              442184 non-null object\n",
      "transaction_date    442184 non-null object\n",
      "posted_date         442184 non-null object\n",
      "MCC                 442184 non-null object\n",
      "dtypes: int64(1), object(9)\n",
      "memory usage: 33.7+ MB\n"
     ]
    }
   ],
   "source": [
    "df2012.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Subsets of the Data\n",
    "\n",
    "Sometimes, you only want to work with a subset of your DataFrame. There are many ways to filter a DataFrame and I will only show you a few.\n",
    "\n",
    "Let's say we're only interested in cardholders whose last name is Bell."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency_number</th>\n",
       "      <th>agency_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>first_initial</th>\n",
       "      <th>description</th>\n",
       "      <th>amount</th>\n",
       "      <th>vendor</th>\n",
       "      <th>transaction_date</th>\n",
       "      <th>posted_date</th>\n",
       "      <th>MCC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$60.07</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$41.29</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>644</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$136.43</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>11-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>645</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$10.00</td>\n",
       "      <td>DOLRTREE 3803 00038034</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>11-Jul-11</td>\n",
       "      <td>DISCOUNT STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>646</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($13.07)</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>11-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>SERVICE/HANDLING/FUEL SURC EA|BTLBULKDOT-2ENMC...</td>\n",
       "      <td>$460.30</td>\n",
       "      <td>VWR INTERNATIONAL INC</td>\n",
       "      <td>8-Jul-11</td>\n",
       "      <td>11-Jul-11</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$13.07</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>8-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$11.24</td>\n",
       "      <td>DUNN'S FOOD CENTER</td>\n",
       "      <td>6-Jul-11</td>\n",
       "      <td>8-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$12.06</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>8-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2578</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$144.56</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>12-Jul-11</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2579</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>HARDWARE CLOTH HEIGHT 36 EA</td>\n",
       "      <td>$75.02</td>\n",
       "      <td>W W GRAINGER 916</td>\n",
       "      <td>11-Jul-11</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>TAPESELF FUSINGSILICONE EA</td>\n",
       "      <td>$9.65</td>\n",
       "      <td>W W GRAINGER 916</td>\n",
       "      <td>12-Jul-11</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3184</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>P</td>\n",
       "      <td>SAND 40-100 MESH 5K EA</td>\n",
       "      <td>$201.03</td>\n",
       "      <td>FISHER SCI HUS</td>\n",
       "      <td>14-Jul-11</td>\n",
       "      <td>15-Jul-11</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3185</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>P</td>\n",
       "      <td>3M 3 EXTRA WIDE DUCT TAPE EA</td>\n",
       "      <td>$19.96</td>\n",
       "      <td>LOWES #00241</td>\n",
       "      <td>14-Jul-11</td>\n",
       "      <td>15-Jul-11</td>\n",
       "      <td>HOME SUPPLY WAREHOUSE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3279</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>4 PVC FEMALE ADAPTER  101 PCS|4 PVC CLEANOUT P...</td>\n",
       "      <td>$57.56</td>\n",
       "      <td>LOWES #00241</td>\n",
       "      <td>11-Jul-11</td>\n",
       "      <td>12-Jul-11</td>\n",
       "      <td>HOME SUPPLY WAREHOUSE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4583</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$274.78</td>\n",
       "      <td>JIMCOLEMAN LTD #2</td>\n",
       "      <td>12-Jul-11</td>\n",
       "      <td>14-Jul-11</td>\n",
       "      <td>NON-DURABLE GOODS NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4584</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$88.00</td>\n",
       "      <td>DOLRTREE 3803 00038034</td>\n",
       "      <td>12-Jul-11</td>\n",
       "      <td>14-Jul-11</td>\n",
       "      <td>DISCOUNT STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4585</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>P</td>\n",
       "      <td>Nylon Mesh Sheet 30 Micro PCE</td>\n",
       "      <td>$105.03</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>14-Jul-11</td>\n",
       "      <td>14-Jul-11</td>\n",
       "      <td>BOOK STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4765</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>CONTAINERPLASTIC GRAY EA</td>\n",
       "      <td>$177.24</td>\n",
       "      <td>W W GRAINGER 916</td>\n",
       "      <td>6-Jul-11</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4766</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$579.60</td>\n",
       "      <td>STILLWATER SAND &amp; GRAVEL</td>\n",
       "      <td>6-Jul-11</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>LUMBER AND BUILDING MATERIALS STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4767</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>9.8OZ DUP ALM  PRMR K&amp;B SI EA|1/4L (3/8O/D)X2'...</td>\n",
       "      <td>$45.46</td>\n",
       "      <td>LOWES #00241</td>\n",
       "      <td>6-Jul-11</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>HOME SUPPLY WAREHOUSE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4768</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>P</td>\n",
       "      <td>CUSHION PISTOL GRIP NOZZLE EA|JH GRABIT #2 SCR...</td>\n",
       "      <td>$19.03</td>\n",
       "      <td>LOWES #00241</td>\n",
       "      <td>6-Jul-11</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>HOME SUPPLY WAREHOUSE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4956</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$226.24</td>\n",
       "      <td>COPELINS OFFICE CENTER LL</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4957</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$36.90</td>\n",
       "      <td>OKLAHOMA RESTAURANT SUPPL</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>COMMERCIAL EQUIPMENT  NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4958</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>BUILDING WIRESTRANDED14A EA|COUPLING1/2 IN SLI...</td>\n",
       "      <td>$66.56</td>\n",
       "      <td>W W GRAINGER 916</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4959</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>G</td>\n",
       "      <td>PRIMERPURPLE8 OZPVC AND EA</td>\n",
       "      <td>$10.54</td>\n",
       "      <td>W W GRAINGER 916</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4960</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>P</td>\n",
       "      <td>2X5'PVC SCH40 PIPE SOLID PCS</td>\n",
       "      <td>$19.14</td>\n",
       "      <td>LOWES #00241</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>HOME SUPPLY WAREHOUSE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4990</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$22.07</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>5-Jul-11</td>\n",
       "      <td>7-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5069</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$65.55</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5507</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$55.03</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>20-Jul-11</td>\n",
       "      <td>22-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370428</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>BED BATH &amp; BEYOND #164</td>\n",
       "      <td>17-May-12</td>\n",
       "      <td>21-May-12</td>\n",
       "      <td>MISCELLANEOUS HOME FURNISHING SPECIALTY STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371488</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($199.05)</td>\n",
       "      <td>COPELINS OFFICE CENTER LL</td>\n",
       "      <td>7-May-12</td>\n",
       "      <td>9-May-12</td>\n",
       "      <td>OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371489</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$199.05</td>\n",
       "      <td>COPELINS OFFICE CENTER LL</td>\n",
       "      <td>7-May-12</td>\n",
       "      <td>9-May-12</td>\n",
       "      <td>OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371490</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$199.05</td>\n",
       "      <td>COPELINS OFFICE CENTER LL</td>\n",
       "      <td>7-May-12</td>\n",
       "      <td>9-May-12</td>\n",
       "      <td>OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371713</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$23.92</td>\n",
       "      <td>WM SUPERCENTER#1626</td>\n",
       "      <td>16-May-12</td>\n",
       "      <td>17-May-12</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372556</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>MYPLATE PLATE EA</td>\n",
       "      <td>$52.55</td>\n",
       "      <td>NASCO  CATALOG SALES</td>\n",
       "      <td>10-May-12</td>\n",
       "      <td>14-May-12</td>\n",
       "      <td>STATIONERY OFFICE AND SCHOOL SUPPLY STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373367</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>PAPERCOPYODCASE10-RE NMB</td>\n",
       "      <td>$208.92</td>\n",
       "      <td>OFFICE DEPOT #1079</td>\n",
       "      <td>9-May-12</td>\n",
       "      <td>11-May-12</td>\n",
       "      <td>COMBINATION CATALOG AND RETAIL MERCHANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373368</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>LABELLSRADDRWHT3000C NMB|CUTLERY KEEPERHVYWEIG...</td>\n",
       "      <td>$208.42</td>\n",
       "      <td>OFFICE DEPOT #1079</td>\n",
       "      <td>9-May-12</td>\n",
       "      <td>11-May-12</td>\n",
       "      <td>COMBINATION CATALOG AND RETAIL MERCHANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374054</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$14.40</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>8-May-12</td>\n",
       "      <td>10-May-12</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374055</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$152.74</td>\n",
       "      <td>BREVIS CORPORATION</td>\n",
       "      <td>9-May-12</td>\n",
       "      <td>10-May-12</td>\n",
       "      <td>PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374056</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>K</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$80.03</td>\n",
       "      <td>DOMINO'S 6460</td>\n",
       "      <td>8-May-12</td>\n",
       "      <td>10-May-12</td>\n",
       "      <td>FAST FOOD RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376046</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$23.92</td>\n",
       "      <td>WM SUPERCENTER#1626</td>\n",
       "      <td>30-Apr-12</td>\n",
       "      <td>1-May-12</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376047</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$5.92</td>\n",
       "      <td>WM SUPERCENTER#1626</td>\n",
       "      <td>30-Apr-12</td>\n",
       "      <td>1-May-12</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406027</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$93.11</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>22-Jun-12</td>\n",
       "      <td>25-Jun-12</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406800</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$39.96</td>\n",
       "      <td>BED BATH &amp; BEYOND #164</td>\n",
       "      <td>25-Jun-12</td>\n",
       "      <td>27-Jun-12</td>\n",
       "      <td>MISCELLANEOUS HOME FURNISHING SPECIALTY STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407873</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>MYPLATE GUIDELINES TEARPAD EA|PERIODIC TABLE/S...</td>\n",
       "      <td>$121.13</td>\n",
       "      <td>NASCO  CATALOG SALES</td>\n",
       "      <td>26-Jun-12</td>\n",
       "      <td>28-Jun-12</td>\n",
       "      <td>STATIONERY OFFICE AND SCHOOL SUPPLY STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407997</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>MYPLATE GUIDELINES TEARPAD EA|PERIODIC TABLE/S...</td>\n",
       "      <td>$334.65</td>\n",
       "      <td>NASCO  CATALOG SALES</td>\n",
       "      <td>26-Jun-12</td>\n",
       "      <td>28-Jun-12</td>\n",
       "      <td>STATIONERY OFFICE AND SCHOOL SUPPLY STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408143</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$117.65</td>\n",
       "      <td>LEARNINGZONEXPRESS COM</td>\n",
       "      <td>21-Jun-12</td>\n",
       "      <td>22-Jun-12</td>\n",
       "      <td>COMPUTERS  COMPUTER PERIPHERAL EQUIPMENT  SOFT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408144</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$42.85</td>\n",
       "      <td>LEARNINGZONEXPRESS COM</td>\n",
       "      <td>21-Jun-12</td>\n",
       "      <td>22-Jun-12</td>\n",
       "      <td>COMPUTERS  COMPUTER PERIPHERAL EQUIPMENT  SOFT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409575</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$47.12</td>\n",
       "      <td>OK DEPT OF VO-TECH ED</td>\n",
       "      <td>8-Jun-12</td>\n",
       "      <td>11-Jun-12</td>\n",
       "      <td>GOVERNMENT SERVICES--NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413292</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>P</td>\n",
       "      <td>CLEAR W&amp;D SILICONE II 9.8 EA</td>\n",
       "      <td>$11.90</td>\n",
       "      <td>LOWES #00241</td>\n",
       "      <td>4-Jun-12</td>\n",
       "      <td>5-Jun-12</td>\n",
       "      <td>HOME SUPPLY WAREHOUSE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413293</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>P</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$17.31</td>\n",
       "      <td>WM SUPERCENTER#0137</td>\n",
       "      <td>4-Jun-12</td>\n",
       "      <td>5-Jun-12</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414760</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$38.43</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>11-Jun-12</td>\n",
       "      <td>13-Jun-12</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428199</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BELL</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($324.95)</td>\n",
       "      <td>AVANGATE PERFECTTABLEP</td>\n",
       "      <td>19-Jun-12</td>\n",
       "      <td>20-Jun-12</td>\n",
       "      <td>COMPUTER SOFTWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429003</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BELL</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$120.00</td>\n",
       "      <td>UCDA</td>\n",
       "      <td>13-Jun-12</td>\n",
       "      <td>14-Jun-12</td>\n",
       "      <td>MEMBERSHIP ORGANIZATIONS--NOT ELSEWHERE CLASSI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429081</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BELL</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$30.00</td>\n",
       "      <td>CORBIS/VEER LICENSE</td>\n",
       "      <td>1-Jun-12</td>\n",
       "      <td>4-Jun-12</td>\n",
       "      <td>COMMERCIAL PHOTOGRAPHY ART AND GRAPHICS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432186</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BELL</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$324.95</td>\n",
       "      <td>AVANGATE PERFECTTABLEP</td>\n",
       "      <td>8-Jun-12</td>\n",
       "      <td>11-Jun-12</td>\n",
       "      <td>COMPUTER SOFTWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432187</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BELL</td>\n",
       "      <td>M</td>\n",
       "      <td>Description Unavailable NBR|Description Unavai...</td>\n",
       "      <td>$46.85</td>\n",
       "      <td>BARNES &amp; NOBLE #2807</td>\n",
       "      <td>9-Jun-12</td>\n",
       "      <td>11-Jun-12</td>\n",
       "      <td>BOOK STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432188</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BELL</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$2.60</td>\n",
       "      <td>INTERNATIONAL TRANSACTION</td>\n",
       "      <td>11-Jun-12</td>\n",
       "      <td>11-Jun-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433266</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BELL</td>\n",
       "      <td>M</td>\n",
       "      <td>PPRCPY28#100BLTRWE RM|PPRCPY28#100B11X17WE RM|...</td>\n",
       "      <td>$342.54</td>\n",
       "      <td>Staples Contra00710004</td>\n",
       "      <td>20-Jun-12</td>\n",
       "      <td>22-Jun-12</td>\n",
       "      <td>STATIONERY  OFFICE SUPPLIES  PRINTING AND WRIT...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>311 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        agency_number                agency_name last_name first_initial  \\\n",
       "0                1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "1                1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "644              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "645              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "646              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "647              1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "925              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "926              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "927              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "2578             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "2579             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "2580             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "3184             1000  OKLAHOMA STATE UNIVERSITY      BELL             P   \n",
       "3185             1000  OKLAHOMA STATE UNIVERSITY      BELL             P   \n",
       "3279             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "4583             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "4584             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "4585             1000  OKLAHOMA STATE UNIVERSITY      BELL             P   \n",
       "4765             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "4766             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "4767             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "4768             1000  OKLAHOMA STATE UNIVERSITY      BELL             P   \n",
       "4956             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "4957             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "4958             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "4959             1000  OKLAHOMA STATE UNIVERSITY      BELL             G   \n",
       "4960             1000  OKLAHOMA STATE UNIVERSITY      BELL             P   \n",
       "4990             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "5069             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "5507             1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "...               ...                        ...       ...           ...   \n",
       "370428           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "371488           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "371489           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "371490           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "371713           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "372556           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "373367           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "373368           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "374054           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "374055           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "374056           1000  OKLAHOMA STATE UNIVERSITY      BELL             K   \n",
       "376046           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "376047           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "406027           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "406800           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "407873           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "407997           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "408143           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "408144           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "409575           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "413292           1000  OKLAHOMA STATE UNIVERSITY      BELL             P   \n",
       "413293           1000  OKLAHOMA STATE UNIVERSITY      BELL             P   \n",
       "414760           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "428199          76000     UNIVERSITY OF OKLAHOMA      BELL             M   \n",
       "429003          76000     UNIVERSITY OF OKLAHOMA      BELL             M   \n",
       "429081          76000     UNIVERSITY OF OKLAHOMA      BELL             M   \n",
       "432186          76000     UNIVERSITY OF OKLAHOMA      BELL             M   \n",
       "432187          76000     UNIVERSITY OF OKLAHOMA      BELL             M   \n",
       "432188          76000     UNIVERSITY OF OKLAHOMA      BELL             M   \n",
       "433266          76000     UNIVERSITY OF OKLAHOMA      BELL             M   \n",
       "\n",
       "                                              description     amount  \\\n",
       "0                                        GENERAL PURCHASE    $60.07    \n",
       "1                                        GENERAL PURCHASE    $41.29    \n",
       "644                                      GENERAL PURCHASE   $136.43    \n",
       "645                                      GENERAL PURCHASE    $10.00    \n",
       "646                                      GENERAL PURCHASE   ($13.07)   \n",
       "647     SERVICE/HANDLING/FUEL SURC EA|BTLBULKDOT-2ENMC...   $460.30    \n",
       "925                                      GENERAL PURCHASE    $13.07    \n",
       "926                                      GENERAL PURCHASE    $11.24    \n",
       "927                                      GENERAL PURCHASE    $12.06    \n",
       "2578                                     GENERAL PURCHASE   $144.56    \n",
       "2579                          HARDWARE CLOTH HEIGHT 36 EA    $75.02    \n",
       "2580                           TAPESELF FUSINGSILICONE EA     $9.65    \n",
       "3184                               SAND 40-100 MESH 5K EA   $201.03    \n",
       "3185                         3M 3 EXTRA WIDE DUCT TAPE EA    $19.96    \n",
       "3279    4 PVC FEMALE ADAPTER  101 PCS|4 PVC CLEANOUT P...    $57.56    \n",
       "4583                                     GENERAL PURCHASE   $274.78    \n",
       "4584                                     GENERAL PURCHASE    $88.00    \n",
       "4585                        Nylon Mesh Sheet 30 Micro PCE   $105.03    \n",
       "4765                             CONTAINERPLASTIC GRAY EA   $177.24    \n",
       "4766                                     GENERAL PURCHASE   $579.60    \n",
       "4767    9.8OZ DUP ALM  PRMR K&B SI EA|1/4L (3/8O/D)X2'...    $45.46    \n",
       "4768    CUSHION PISTOL GRIP NOZZLE EA|JH GRABIT #2 SCR...    $19.03    \n",
       "4956                                     GENERAL PURCHASE   $226.24    \n",
       "4957                                     GENERAL PURCHASE    $36.90    \n",
       "4958    BUILDING WIRESTRANDED14A EA|COUPLING1/2 IN SLI...    $66.56    \n",
       "4959                           PRIMERPURPLE8 OZPVC AND EA    $10.54    \n",
       "4960                         2X5'PVC SCH40 PIPE SOLID PCS    $19.14    \n",
       "4990                                     GENERAL PURCHASE    $22.07    \n",
       "5069                                     GENERAL PURCHASE    $65.55    \n",
       "5507                                     GENERAL PURCHASE    $55.03    \n",
       "...                                                   ...        ...   \n",
       "370428                                   GENERAL PURCHASE     $9.99    \n",
       "371488                                   GENERAL PURCHASE  ($199.05)   \n",
       "371489                                   GENERAL PURCHASE   $199.05    \n",
       "371490                                   GENERAL PURCHASE   $199.05    \n",
       "371713                                   GENERAL PURCHASE    $23.92    \n",
       "372556                                   MYPLATE PLATE EA    $52.55    \n",
       "373367                           PAPERCOPYODCASE10-RE NMB   $208.92    \n",
       "373368  LABELLSRADDRWHT3000C NMB|CUTLERY KEEPERHVYWEIG...   $208.42    \n",
       "374054                                   GENERAL PURCHASE    $14.40    \n",
       "374055                                   GENERAL PURCHASE   $152.74    \n",
       "374056                                   GENERAL PURCHASE    $80.03    \n",
       "376046                                   GENERAL PURCHASE    $23.92    \n",
       "376047                                   GENERAL PURCHASE     $5.92    \n",
       "406027                                   GENERAL PURCHASE    $93.11    \n",
       "406800                                   GENERAL PURCHASE    $39.96    \n",
       "407873  MYPLATE GUIDELINES TEARPAD EA|PERIODIC TABLE/S...   $121.13    \n",
       "407997  MYPLATE GUIDELINES TEARPAD EA|PERIODIC TABLE/S...   $334.65    \n",
       "408143                                   GENERAL PURCHASE   $117.65    \n",
       "408144                                   GENERAL PURCHASE    $42.85    \n",
       "409575                                   GENERAL PURCHASE    $47.12    \n",
       "413292                       CLEAR W&D SILICONE II 9.8 EA    $11.90    \n",
       "413293                                   GENERAL PURCHASE    $17.31    \n",
       "414760                                   GENERAL PURCHASE    $38.43    \n",
       "428199                                   GENERAL PURCHASE  ($324.95)   \n",
       "429003                                   GENERAL PURCHASE   $120.00    \n",
       "429081                                   GENERAL PURCHASE    $30.00    \n",
       "432186                                   GENERAL PURCHASE   $324.95    \n",
       "432187  Description Unavailable NBR|Description Unavai...    $46.85    \n",
       "432188                                   GENERAL PURCHASE     $2.60    \n",
       "433266  PPRCPY28#100BLTRWE RM|PPRCPY28#100B11X17WE RM|...   $342.54    \n",
       "\n",
       "                           vendor transaction_date posted_date  \\\n",
       "0                  WM SUPERCENTER        30-Jun-11    1-Jul-11   \n",
       "1                  WM SUPERCENTER        30-Jun-11    1-Jul-11   \n",
       "644                CREST FOODS #5         7-Jul-11   11-Jul-11   \n",
       "645        DOLRTREE 3803 00038034         7-Jul-11   11-Jul-11   \n",
       "646                WM SUPERCENTER         7-Jul-11   11-Jul-11   \n",
       "647         VWR INTERNATIONAL INC         8-Jul-11   11-Jul-11   \n",
       "925                WM SUPERCENTER         7-Jul-11    8-Jul-11   \n",
       "926            DUNN'S FOOD CENTER         6-Jul-11    8-Jul-11   \n",
       "927                WM SUPERCENTER         7-Jul-11    8-Jul-11   \n",
       "2578               WM SUPERCENTER        12-Jul-11   13-Jul-11   \n",
       "2579             W W GRAINGER 916        11-Jul-11   13-Jul-11   \n",
       "2580             W W GRAINGER 916        12-Jul-11   13-Jul-11   \n",
       "3184               FISHER SCI HUS        14-Jul-11   15-Jul-11   \n",
       "3185                 LOWES #00241        14-Jul-11   15-Jul-11   \n",
       "3279                 LOWES #00241        11-Jul-11   12-Jul-11   \n",
       "4583            JIMCOLEMAN LTD #2        12-Jul-11   14-Jul-11   \n",
       "4584       DOLRTREE 3803 00038034        12-Jul-11   14-Jul-11   \n",
       "4585                   Amazon.com        14-Jul-11   14-Jul-11   \n",
       "4765             W W GRAINGER 916         6-Jul-11    7-Jul-11   \n",
       "4766     STILLWATER SAND & GRAVEL         6-Jul-11    7-Jul-11   \n",
       "4767                 LOWES #00241         6-Jul-11    7-Jul-11   \n",
       "4768                 LOWES #00241         6-Jul-11    7-Jul-11   \n",
       "4956    COPELINS OFFICE CENTER LL         1-Jul-11    4-Jul-11   \n",
       "4957    OKLAHOMA RESTAURANT SUPPL         1-Jul-11    4-Jul-11   \n",
       "4958             W W GRAINGER 916         1-Jul-11    4-Jul-11   \n",
       "4959             W W GRAINGER 916         1-Jul-11    4-Jul-11   \n",
       "4960                 LOWES #00241         1-Jul-11    4-Jul-11   \n",
       "4990               CREST FOODS #5         5-Jul-11    7-Jul-11   \n",
       "5069               CREST FOODS #5        30-Jun-11    4-Jul-11   \n",
       "5507               CREST FOODS #5        20-Jul-11   22-Jul-11   \n",
       "...                           ...              ...         ...   \n",
       "370428     BED BATH & BEYOND #164        17-May-12   21-May-12   \n",
       "371488  COPELINS OFFICE CENTER LL         7-May-12    9-May-12   \n",
       "371489  COPELINS OFFICE CENTER LL         7-May-12    9-May-12   \n",
       "371490  COPELINS OFFICE CENTER LL         7-May-12    9-May-12   \n",
       "371713        WM SUPERCENTER#1626        16-May-12   17-May-12   \n",
       "372556       NASCO  CATALOG SALES        10-May-12   14-May-12   \n",
       "373367         OFFICE DEPOT #1079         9-May-12   11-May-12   \n",
       "373368         OFFICE DEPOT #1079         9-May-12   11-May-12   \n",
       "374054             CREST FOODS #5         8-May-12   10-May-12   \n",
       "374055         BREVIS CORPORATION         9-May-12   10-May-12   \n",
       "374056              DOMINO'S 6460         8-May-12   10-May-12   \n",
       "376046        WM SUPERCENTER#1626        30-Apr-12    1-May-12   \n",
       "376047        WM SUPERCENTER#1626        30-Apr-12    1-May-12   \n",
       "406027             CREST FOODS #5        22-Jun-12   25-Jun-12   \n",
       "406800     BED BATH & BEYOND #164        25-Jun-12   27-Jun-12   \n",
       "407873       NASCO  CATALOG SALES        26-Jun-12   28-Jun-12   \n",
       "407997       NASCO  CATALOG SALES        26-Jun-12   28-Jun-12   \n",
       "408143     LEARNINGZONEXPRESS COM        21-Jun-12   22-Jun-12   \n",
       "408144     LEARNINGZONEXPRESS COM        21-Jun-12   22-Jun-12   \n",
       "409575      OK DEPT OF VO-TECH ED         8-Jun-12   11-Jun-12   \n",
       "413292               LOWES #00241         4-Jun-12    5-Jun-12   \n",
       "413293        WM SUPERCENTER#0137         4-Jun-12    5-Jun-12   \n",
       "414760             CREST FOODS #5        11-Jun-12   13-Jun-12   \n",
       "428199     AVANGATE PERFECTTABLEP        19-Jun-12   20-Jun-12   \n",
       "429003                       UCDA        13-Jun-12   14-Jun-12   \n",
       "429081        CORBIS/VEER LICENSE         1-Jun-12    4-Jun-12   \n",
       "432186     AVANGATE PERFECTTABLEP         8-Jun-12   11-Jun-12   \n",
       "432187       BARNES & NOBLE #2807         9-Jun-12   11-Jun-12   \n",
       "432188  INTERNATIONAL TRANSACTION        11-Jun-12   11-Jun-12   \n",
       "433266     Staples Contra00710004        20-Jun-12   22-Jun-12   \n",
       "\n",
       "                                                      MCC  \n",
       "0                         GROCERY STORES AND SUPERMARKETS  \n",
       "1                         GROCERY STORES AND SUPERMARKETS  \n",
       "644                       GROCERY STORES AND SUPERMARKETS  \n",
       "645                                       DISCOUNT STORES  \n",
       "646                       GROCERY STORES AND SUPERMARKETS  \n",
       "647     DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "925                       GROCERY STORES AND SUPERMARKETS  \n",
       "926                       GROCERY STORES AND SUPERMARKETS  \n",
       "927                       GROCERY STORES AND SUPERMARKETS  \n",
       "2578                      GROCERY STORES AND SUPERMARKETS  \n",
       "2579         INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED  \n",
       "2580         INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED  \n",
       "3184    DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "3185                         HOME SUPPLY WAREHOUSE STORES  \n",
       "3279                         HOME SUPPLY WAREHOUSE STORES  \n",
       "4583           NON-DURABLE GOODS NOT ELSEWHERE CLASSIFIED  \n",
       "4584                                      DISCOUNT STORES  \n",
       "4585                                          BOOK STORES  \n",
       "4765         INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED  \n",
       "4766                 LUMBER AND BUILDING MATERIALS STORES  \n",
       "4767                         HOME SUPPLY WAREHOUSE STORES  \n",
       "4768                         HOME SUPPLY WAREHOUSE STORES  \n",
       "4956    OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...  \n",
       "4957       COMMERCIAL EQUIPMENT  NOT ELSEWHERE CLASSIFIED  \n",
       "4958         INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED  \n",
       "4959         INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED  \n",
       "4960                         HOME SUPPLY WAREHOUSE STORES  \n",
       "4990                      GROCERY STORES AND SUPERMARKETS  \n",
       "5069                      GROCERY STORES AND SUPERMARKETS  \n",
       "5507                      GROCERY STORES AND SUPERMARKETS  \n",
       "...                                                   ...  \n",
       "370428     MISCELLANEOUS HOME FURNISHING SPECIALTY STORES  \n",
       "371488  OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...  \n",
       "371489  OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...  \n",
       "371490  OFFICE  PHOTOGRAPHIC  PHOTOCOPY  AND MICROFILM...  \n",
       "371713                    GROCERY STORES AND SUPERMARKETS  \n",
       "372556         STATIONERY OFFICE AND SCHOOL SUPPLY STORES  \n",
       "373367            COMBINATION CATALOG AND RETAIL MERCHANT  \n",
       "373368            COMBINATION CATALOG AND RETAIL MERCHANT  \n",
       "374054                    GROCERY STORES AND SUPERMARKETS  \n",
       "374055     PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED  \n",
       "374056                              FAST FOOD RESTAURANTS  \n",
       "376046                    GROCERY STORES AND SUPERMARKETS  \n",
       "376047                    GROCERY STORES AND SUPERMARKETS  \n",
       "406027                    GROCERY STORES AND SUPERMARKETS  \n",
       "406800     MISCELLANEOUS HOME FURNISHING SPECIALTY STORES  \n",
       "407873         STATIONERY OFFICE AND SCHOOL SUPPLY STORES  \n",
       "407997         STATIONERY OFFICE AND SCHOOL SUPPLY STORES  \n",
       "408143  COMPUTERS  COMPUTER PERIPHERAL EQUIPMENT  SOFT...  \n",
       "408144  COMPUTERS  COMPUTER PERIPHERAL EQUIPMENT  SOFT...  \n",
       "409575      GOVERNMENT SERVICES--NOT ELSEWHERE CLASSIFIED  \n",
       "413292                       HOME SUPPLY WAREHOUSE STORES  \n",
       "413293                    GROCERY STORES AND SUPERMARKETS  \n",
       "414760                    GROCERY STORES AND SUPERMARKETS  \n",
       "428199                           COMPUTER SOFTWARE STORES  \n",
       "429003  MEMBERSHIP ORGANIZATIONS--NOT ELSEWHERE CLASSI...  \n",
       "429081            COMMERCIAL PHOTOGRAPHY ART AND GRAPHICS  \n",
       "432186                           COMPUTER SOFTWARE STORES  \n",
       "432187                                        BOOK STORES  \n",
       "432188                                         OTHER FEES  \n",
       "433266  STATIONERY  OFFICE SUPPLIES  PRINTING AND WRIT...  \n",
       "\n",
       "[311 rows x 10 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The following are equivalent:\n",
    "\n",
    "#df2012[df2012['last_name'] == 'BELL']\n",
    "df2012[df2012.last_name == 'BELL']\n",
    "#df2012[df2012.loc[:,'last_name'] == 'BELL']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Subset with multiple filters\n",
    "\n",
    "What if we want to use multiple filters? Use the following tips:\n",
    "* Each condition *MUST* be grouped in parentheses\n",
    "* Use the operators & for and, | for or, and ~ for not\n",
    "\n",
    "In the following, note that the date field hasn't been converted to a Python date."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency_number</th>\n",
       "      <th>agency_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>first_initial</th>\n",
       "      <th>description</th>\n",
       "      <th>amount</th>\n",
       "      <th>vendor</th>\n",
       "      <th>transaction_date</th>\n",
       "      <th>posted_date</th>\n",
       "      <th>MCC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$60.07</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$41.29</td>\n",
       "      <td>WM SUPERCENTER</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5069</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BELL</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$65.55</td>\n",
       "      <td>CREST FOODS #5</td>\n",
       "      <td>30-Jun-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>GROCERY STORES AND SUPERMARKETS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      agency_number                agency_name last_name first_initial  \\\n",
       "0              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "1              1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "5069           1000  OKLAHOMA STATE UNIVERSITY      BELL             D   \n",
       "\n",
       "           description   amount          vendor transaction_date posted_date  \\\n",
       "0     GENERAL PURCHASE  $60.07   WM SUPERCENTER        30-Jun-11    1-Jul-11   \n",
       "1     GENERAL PURCHASE  $41.29   WM SUPERCENTER        30-Jun-11    1-Jul-11   \n",
       "5069  GENERAL PURCHASE  $65.55   CREST FOODS #5        30-Jun-11    4-Jul-11   \n",
       "\n",
       "                                  MCC  \n",
       "0     GROCERY STORES AND SUPERMARKETS  \n",
       "1     GROCERY STORES AND SUPERMARKETS  \n",
       "5069  GROCERY STORES AND SUPERMARKETS  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#df2012[(df2012['LastName'] == 'BELL') & (df2012['Transaction Date'] == '30-Jun-11')]\n",
    "df2012[(df2012.last_name == 'BELL') & (df2012.transaction_date == '30-Jun-11')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Sorting the Data\n",
    "Output data is easier to look at and understand when it is ordered or sorted on our variable or variables of interest. Suppose we care about the vendor. We can sort by vendor in the following way:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency_number</th>\n",
       "      <th>agency_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>first_initial</th>\n",
       "      <th>description</th>\n",
       "      <th>amount</th>\n",
       "      <th>vendor</th>\n",
       "      <th>transaction_date</th>\n",
       "      <th>posted_date</th>\n",
       "      <th>MCC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>203809</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>BRADLEY</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$7.37</td>\n",
       "      <td># 11 CITY BITES</td>\n",
       "      <td>1-Dec-11</td>\n",
       "      <td>2-Dec-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135430</th>\n",
       "      <td>55700</td>\n",
       "      <td>POLICE PENSION &amp; RET. SYSTEM</td>\n",
       "      <td>GORDON</td>\n",
       "      <td>D</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$269.99</td>\n",
       "      <td># 11 CITY BITES</td>\n",
       "      <td>19-Oct-11</td>\n",
       "      <td>20-Oct-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203632</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>ARMSTRONG</td>\n",
       "      <td>S</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$10.36</td>\n",
       "      <td># 17 CITY BITES</td>\n",
       "      <td>28-Dec-11</td>\n",
       "      <td>29-Dec-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41192</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>HANCOCK</td>\n",
       "      <td>K</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$156.99</td>\n",
       "      <td># 21 CITY BITES</td>\n",
       "      <td>14-Aug-11</td>\n",
       "      <td>15-Aug-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259006</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>LEONARD</td>\n",
       "      <td>A</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$59.68</td>\n",
       "      <td># 21 CITY BITES</td>\n",
       "      <td>5-Feb-12</td>\n",
       "      <td>6-Feb-12</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203755</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>TERRELL</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$6.38</td>\n",
       "      <td># 25 CITY BITES</td>\n",
       "      <td>9-Dec-11</td>\n",
       "      <td>12-Dec-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26167</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>ENGLE</td>\n",
       "      <td>H</td>\n",
       "      <td>Transaction Line Item</td>\n",
       "      <td>$5.99</td>\n",
       "      <td>#08 VS 323169265994</td>\n",
       "      <td>20-Jul-11</td>\n",
       "      <td>22-Jul-11</td>\n",
       "      <td>Record Shops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183852</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCE CENTER</td>\n",
       "      <td>EASLEY</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$55.68</td>\n",
       "      <td>#1 PARTY SUPPLIES</td>\n",
       "      <td>2-Nov-11</td>\n",
       "      <td>7-Nov-11</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187398</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>HUDSON</td>\n",
       "      <td>S</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$43.36</td>\n",
       "      <td>#21 VS</td>\n",
       "      <td>1-Dec-11</td>\n",
       "      <td>5-Dec-11</td>\n",
       "      <td>BOOK STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122563</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>JACKSON</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$43.08</td>\n",
       "      <td>#41 BRIO COUNTRY CLUB</td>\n",
       "      <td>1-Oct-11</td>\n",
       "      <td>3-Oct-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137080</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>RANGEL</td>\n",
       "      <td>A</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$25.13</td>\n",
       "      <td>#44 BRAVO| MEMORIAL SQUA</td>\n",
       "      <td>20-Oct-11</td>\n",
       "      <td>24-Oct-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137066</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>GRANGE</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$20.93</td>\n",
       "      <td>#44 BRAVO| MEMORIAL SQUA</td>\n",
       "      <td>21-Oct-11</td>\n",
       "      <td>24-Oct-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273523</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>PAGE</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$22.92</td>\n",
       "      <td>#44 BRAVO| MEMORIAL SQUA</td>\n",
       "      <td>23-Feb-12</td>\n",
       "      <td>27-Feb-12</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350180</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>TERRELL</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$12.60</td>\n",
       "      <td>#44 BRAVO| MEMORIAL SQUA</td>\n",
       "      <td>18-Apr-12</td>\n",
       "      <td>20-Apr-12</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425708</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>RANGEL</td>\n",
       "      <td>A</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$17.90</td>\n",
       "      <td>#44 BRAVO| MEMORIAL SQUA</td>\n",
       "      <td>19-Jun-12</td>\n",
       "      <td>21-Jun-12</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18313</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>ABERNATHY</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$20.64</td>\n",
       "      <td>#44 BRAVO| MEMORIAL SQUA</td>\n",
       "      <td>22-Jul-11</td>\n",
       "      <td>25-Jul-11</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237004</th>\n",
       "      <td>58500</td>\n",
       "      <td>DEPARTMENT OF PUBLIC SAFETY</td>\n",
       "      <td>HARBIN</td>\n",
       "      <td>T</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$16.64</td>\n",
       "      <td>#44 BRAVO| MEMORIAL SQUA</td>\n",
       "      <td>4-Jan-12</td>\n",
       "      <td>6-Jan-12</td>\n",
       "      <td>EATING PLACES AND RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46449</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>HANCOCK</td>\n",
       "      <td>K</td>\n",
       "      <td>ROOM CHARGES</td>\n",
       "      <td>$2,908.62</td>\n",
       "      <td>#464 RADISSON HOTEL CENTR</td>\n",
       "      <td>15-Aug-11</td>\n",
       "      <td>16-Aug-11</td>\n",
       "      <td>LODGING--HOTELS MOTELS AND RESORTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295797</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>BRORSEN</td>\n",
       "      <td>W</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$150.00</td>\n",
       "      <td>(SA)HANGUKJEUNGGYONHAGHOI</td>\n",
       "      <td>23-Feb-12</td>\n",
       "      <td>13-Mar-12</td>\n",
       "      <td>MISCELLANEOUS PERSONAL SERVICES--NOT ELSEWHERE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107715</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>NIELSEN</td>\n",
       "      <td>T</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$188.00</td>\n",
       "      <td>000 DILLARD'S INC.</td>\n",
       "      <td>31-Aug-11</td>\n",
       "      <td>1-Sep-11</td>\n",
       "      <td>DEPARTMENT STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23811</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BRAUNBECK</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$90.00</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191876</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>DAVIS</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$38.91</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>6-Dec-11</td>\n",
       "      <td>7-Dec-11</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331310</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>DAVIS</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$39.04</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>23-Apr-12</td>\n",
       "      <td>24-Apr-12</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245107</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BRAUNBECK</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$37.46</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>19-Jan-12</td>\n",
       "      <td>20-Jan-12</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242249</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BRAUNBECK</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$37.22</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>6-Jan-12</td>\n",
       "      <td>9-Jan-12</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176456</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BRAUNBECK</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$93.29</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>4-Nov-11</td>\n",
       "      <td>7-Nov-11</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293176</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>DAVIS</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$39.06</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>26-Mar-12</td>\n",
       "      <td>27-Mar-12</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277107</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BRAUNBECK</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$37.46</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>20-Feb-12</td>\n",
       "      <td>21-Feb-12</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107861</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BRAUNBECK</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$92.15</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>1-Sep-11</td>\n",
       "      <td>2-Sep-11</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227374</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>DAVIS</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$39.06</td>\n",
       "      <td>003 CENTURYLINK MY ACCOUN</td>\n",
       "      <td>17-Jan-12</td>\n",
       "      <td>18-Jan-12</td>\n",
       "      <td>TELECOMMUNICATION SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286707</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>YANDELL</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$233.58</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>10-Feb-12</td>\n",
       "      <td>13-Feb-12</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150464</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCE CENTER</td>\n",
       "      <td>EASLEY</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$181.17</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>19-Oct-11</td>\n",
       "      <td>20-Oct-11</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287566</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>EASLEY</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$103.20</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>3-Feb-12</td>\n",
       "      <td>6-Feb-12</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195142</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>TOLBART</td>\n",
       "      <td>S</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1,177.02</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>16-Dec-11</td>\n",
       "      <td>19-Dec-11</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181341</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCE CENTER</td>\n",
       "      <td>YANDELL</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$130.21</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>16-Nov-11</td>\n",
       "      <td>17-Nov-11</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399501</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>EASLEY</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$165.73</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>5-May-12</td>\n",
       "      <td>7-May-12</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398900</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>YANDELL</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$260.24</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>24-May-12</td>\n",
       "      <td>25-May-12</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147675</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCE CENTER</td>\n",
       "      <td>YANDELL</td>\n",
       "      <td>R</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$174.14</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>29-Oct-11</td>\n",
       "      <td>31-Oct-11</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435168</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>EASLEY</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1,904.98</td>\n",
       "      <td>pss_2025 INV MULTIPLE</td>\n",
       "      <td>23-Jun-12</td>\n",
       "      <td>25-Jun-12</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414172</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>DEAN</td>\n",
       "      <td>V</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$688.01</td>\n",
       "      <td>robotis-shop-en.com</td>\n",
       "      <td>15-Jun-12</td>\n",
       "      <td>18-Jun-12</td>\n",
       "      <td>DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74560</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCE CENTER</td>\n",
       "      <td>SUMMERS-ABLES</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$9.95</td>\n",
       "      <td>soilsleuth@aol.com</td>\n",
       "      <td>23-Aug-11</td>\n",
       "      <td>24-Aug-11</td>\n",
       "      <td>DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141781</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>FARROW</td>\n",
       "      <td>V</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$69.44</td>\n",
       "      <td>value plastics inc</td>\n",
       "      <td>18-Oct-11</td>\n",
       "      <td>19-Oct-11</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256724</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>JEYASINGH</td>\n",
       "      <td>P</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$87.15</td>\n",
       "      <td>value plastics inc</td>\n",
       "      <td>23-Feb-12</td>\n",
       "      <td>24-Feb-12</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285576</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>PALASZ</td>\n",
       "      <td>L</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$756.62</td>\n",
       "      <td>value plastics inc</td>\n",
       "      <td>7-Feb-12</td>\n",
       "      <td>8-Feb-12</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38888</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>MOFFAT</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$185.00</td>\n",
       "      <td>vet imaging</td>\n",
       "      <td>5-Aug-11</td>\n",
       "      <td>8-Aug-11</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12823</th>\n",
       "      <td>29000</td>\n",
       "      <td>EMPLOYMENT SECURITY COMMISSION</td>\n",
       "      <td>HAN</td>\n",
       "      <td>H</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$95.40</td>\n",
       "      <td>wmill.com ResponseOmatic</td>\n",
       "      <td>6-Jul-11</td>\n",
       "      <td>8-Jul-11</td>\n",
       "      <td>PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356968</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>HENKELS</td>\n",
       "      <td>S</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$399.00</td>\n",
       "      <td>www.anastasiadate.com</td>\n",
       "      <td>8-Apr-12</td>\n",
       "      <td>9-Apr-12</td>\n",
       "      <td>DIRECT MARKETING--INBOUND TELEMARKETING MERCHANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377750</th>\n",
       "      <td>2500</td>\n",
       "      <td>OKLAHOMA MILITARY DEPARTMENT</td>\n",
       "      <td>SWENSON</td>\n",
       "      <td>K</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$476.37</td>\n",
       "      <td>www.dumpster.com</td>\n",
       "      <td>8-May-12</td>\n",
       "      <td>10-May-12</td>\n",
       "      <td>FUEL DEALERS--FUEL OIL WOOD COAL AND LIQ. PETR...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415473</th>\n",
       "      <td>2500</td>\n",
       "      <td>OKLAHOMA MILITARY DEPARTMENT</td>\n",
       "      <td>SWENSON</td>\n",
       "      <td>K</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$509.75</td>\n",
       "      <td>www.dumpster.com</td>\n",
       "      <td>27-Jun-12</td>\n",
       "      <td>29-Jun-12</td>\n",
       "      <td>FUEL DEALERS--FUEL OIL WOOD COAL AND LIQ. PETR...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438854</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>CAMPBELL</td>\n",
       "      <td>K</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$489.00</td>\n",
       "      <td>www.favoriteplus.com</td>\n",
       "      <td>8-Jun-12</td>\n",
       "      <td>11-Jun-12</td>\n",
       "      <td>DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215934</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCE CENTER</td>\n",
       "      <td>KRANZ</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$259.00</td>\n",
       "      <td>www.karger.ch</td>\n",
       "      <td>16-Dec-11</td>\n",
       "      <td>19-Dec-11</td>\n",
       "      <td>COMBINATION CATALOG AND RETAIL MERCHANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74879</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCE CENTER</td>\n",
       "      <td>CROCKETT</td>\n",
       "      <td>M</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$179.00</td>\n",
       "      <td>www.karger.ch</td>\n",
       "      <td>12-Aug-11</td>\n",
       "      <td>15-Aug-11</td>\n",
       "      <td>COMBINATION CATALOG AND RETAIL MERCHANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248605</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>WILLIAMS</td>\n",
       "      <td>K</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$179.00</td>\n",
       "      <td>www.karger.ch</td>\n",
       "      <td>20-Jan-12</td>\n",
       "      <td>23-Jan-12</td>\n",
       "      <td>COMBINATION CATALOG AND RETAIL MERCHANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247481</th>\n",
       "      <td>77000</td>\n",
       "      <td>UNIV. OF OKLA. HEALTH SCIENCES CENTER</td>\n",
       "      <td>LE</td>\n",
       "      <td>Y</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$38.00</td>\n",
       "      <td>www.karger.ch</td>\n",
       "      <td>13-Jan-12</td>\n",
       "      <td>17-Jan-12</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433297</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>BARDGETT</td>\n",
       "      <td>L</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$88.82</td>\n",
       "      <td>www.mohr.de</td>\n",
       "      <td>27-Jun-12</td>\n",
       "      <td>28-Jun-12</td>\n",
       "      <td>BOOK STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276256</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>SUBLETT</td>\n",
       "      <td>G</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$329.50</td>\n",
       "      <td>www.realtimesoft.com</td>\n",
       "      <td>14-Feb-12</td>\n",
       "      <td>16-Feb-12</td>\n",
       "      <td>COMPUTER SOFTWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242936</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>SUBLETT</td>\n",
       "      <td>G</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$39.95</td>\n",
       "      <td>www.realtimesoft.com</td>\n",
       "      <td>3-Jan-12</td>\n",
       "      <td>5-Jan-12</td>\n",
       "      <td>COMPUTER SOFTWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188107</th>\n",
       "      <td>1000</td>\n",
       "      <td>OKLAHOMA STATE UNIVERSITY</td>\n",
       "      <td>THOMPSON</td>\n",
       "      <td>S</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$164.98</td>\n",
       "      <td>www.testking.com</td>\n",
       "      <td>30-Nov-11</td>\n",
       "      <td>2-Dec-11</td>\n",
       "      <td>BUSINESS SERVICES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141288</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>TURNER</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1.00</td>\n",
       "      <td>zombaio.com C19042613186</td>\n",
       "      <td>15-Oct-11</td>\n",
       "      <td>17-Oct-11</td>\n",
       "      <td>DIRECT MARKETING--INBOUND TELEMARKETING MERCHANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141293</th>\n",
       "      <td>76000</td>\n",
       "      <td>UNIVERSITY OF OKLAHOMA</td>\n",
       "      <td>TURNER</td>\n",
       "      <td>C</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1.00</td>\n",
       "      <td>zombaio.com C38178113186</td>\n",
       "      <td>15-Oct-11</td>\n",
       "      <td>17-Oct-11</td>\n",
       "      <td>DIRECT MARKETING--INBOUND TELEMARKETING MERCHANTS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>442184 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        agency_number                            agency_name      last_name  \\\n",
       "203809          58500            DEPARTMENT OF PUBLIC SAFETY        BRADLEY   \n",
       "135430          55700           POLICE PENSION & RET. SYSTEM         GORDON   \n",
       "203632          58500            DEPARTMENT OF PUBLIC SAFETY      ARMSTRONG   \n",
       "41192            1000              OKLAHOMA STATE UNIVERSITY        HANCOCK   \n",
       "259006           1000              OKLAHOMA STATE UNIVERSITY        LEONARD   \n",
       "203755          58500            DEPARTMENT OF PUBLIC SAFETY        TERRELL   \n",
       "26167           76000                 UNIVERSITY OF OKLAHOMA          ENGLE   \n",
       "183852          77000   UNIV. OF OKLA. HEALTH SCIENCE CENTER         EASLEY   \n",
       "187398           1000              OKLAHOMA STATE UNIVERSITY         HUDSON   \n",
       "122563           1000              OKLAHOMA STATE UNIVERSITY        JACKSON   \n",
       "137080          58500            DEPARTMENT OF PUBLIC SAFETY         RANGEL   \n",
       "137066          58500            DEPARTMENT OF PUBLIC SAFETY         GRANGE   \n",
       "273523          58500            DEPARTMENT OF PUBLIC SAFETY           PAGE   \n",
       "350180          58500            DEPARTMENT OF PUBLIC SAFETY        TERRELL   \n",
       "425708          58500            DEPARTMENT OF PUBLIC SAFETY         RANGEL   \n",
       "18313           58500            DEPARTMENT OF PUBLIC SAFETY      ABERNATHY   \n",
       "237004          58500            DEPARTMENT OF PUBLIC SAFETY         HARBIN   \n",
       "46449            1000              OKLAHOMA STATE UNIVERSITY        HANCOCK   \n",
       "295797           1000              OKLAHOMA STATE UNIVERSITY        BRORSEN   \n",
       "107715          76000                 UNIVERSITY OF OKLAHOMA        NIELSEN   \n",
       "23811           76000                 UNIVERSITY OF OKLAHOMA      BRAUNBECK   \n",
       "191876           1000              OKLAHOMA STATE UNIVERSITY          DAVIS   \n",
       "331310           1000              OKLAHOMA STATE UNIVERSITY          DAVIS   \n",
       "245107          76000                 UNIVERSITY OF OKLAHOMA      BRAUNBECK   \n",
       "242249          76000                 UNIVERSITY OF OKLAHOMA      BRAUNBECK   \n",
       "176456          76000                 UNIVERSITY OF OKLAHOMA      BRAUNBECK   \n",
       "293176           1000              OKLAHOMA STATE UNIVERSITY          DAVIS   \n",
       "277107          76000                 UNIVERSITY OF OKLAHOMA      BRAUNBECK   \n",
       "107861          76000                 UNIVERSITY OF OKLAHOMA      BRAUNBECK   \n",
       "227374           1000              OKLAHOMA STATE UNIVERSITY          DAVIS   \n",
       "...               ...                                    ...            ...   \n",
       "286707          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER        YANDELL   \n",
       "150464          77000   UNIV. OF OKLA. HEALTH SCIENCE CENTER         EASLEY   \n",
       "287566          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER         EASLEY   \n",
       "195142           1000              OKLAHOMA STATE UNIVERSITY        TOLBART   \n",
       "181341          77000   UNIV. OF OKLA. HEALTH SCIENCE CENTER        YANDELL   \n",
       "399501          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER         EASLEY   \n",
       "398900          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER        YANDELL   \n",
       "147675          77000   UNIV. OF OKLA. HEALTH SCIENCE CENTER        YANDELL   \n",
       "435168          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER         EASLEY   \n",
       "414172           1000              OKLAHOMA STATE UNIVERSITY           DEAN   \n",
       "74560           77000   UNIV. OF OKLA. HEALTH SCIENCE CENTER  SUMMERS-ABLES   \n",
       "141781          76000                 UNIVERSITY OF OKLAHOMA         FARROW   \n",
       "256724           1000              OKLAHOMA STATE UNIVERSITY      JEYASINGH   \n",
       "285576          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER         PALASZ   \n",
       "38888            1000              OKLAHOMA STATE UNIVERSITY         MOFFAT   \n",
       "12823           29000         EMPLOYMENT SECURITY COMMISSION            HAN   \n",
       "356968          76000                 UNIVERSITY OF OKLAHOMA        HENKELS   \n",
       "377750           2500           OKLAHOMA MILITARY DEPARTMENT        SWENSON   \n",
       "415473           2500           OKLAHOMA MILITARY DEPARTMENT        SWENSON   \n",
       "438854          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER       CAMPBELL   \n",
       "215934          77000   UNIV. OF OKLA. HEALTH SCIENCE CENTER          KRANZ   \n",
       "74879           77000   UNIV. OF OKLA. HEALTH SCIENCE CENTER       CROCKETT   \n",
       "248605          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER       WILLIAMS   \n",
       "247481          77000  UNIV. OF OKLA. HEALTH SCIENCES CENTER             LE   \n",
       "433297          76000                 UNIVERSITY OF OKLAHOMA       BARDGETT   \n",
       "276256          76000                 UNIVERSITY OF OKLAHOMA        SUBLETT   \n",
       "242936          76000                 UNIVERSITY OF OKLAHOMA        SUBLETT   \n",
       "188107           1000              OKLAHOMA STATE UNIVERSITY       THOMPSON   \n",
       "141288          76000                 UNIVERSITY OF OKLAHOMA         TURNER   \n",
       "141293          76000                 UNIVERSITY OF OKLAHOMA         TURNER   \n",
       "\n",
       "       first_initial            description      amount  \\\n",
       "203809             C       GENERAL PURCHASE      $7.37    \n",
       "135430             D       GENERAL PURCHASE    $269.99    \n",
       "203632             S       GENERAL PURCHASE     $10.36    \n",
       "41192              K       GENERAL PURCHASE    $156.99    \n",
       "259006             A       GENERAL PURCHASE     $59.68    \n",
       "203755             E       GENERAL PURCHASE      $6.38    \n",
       "26167              H  Transaction Line Item      $5.99    \n",
       "183852             C       GENERAL PURCHASE     $55.68    \n",
       "187398             S       GENERAL PURCHASE     $43.36    \n",
       "122563             J       GENERAL PURCHASE     $43.08    \n",
       "137080             A       GENERAL PURCHASE     $25.13    \n",
       "137066             R       GENERAL PURCHASE     $20.93    \n",
       "273523             M       GENERAL PURCHASE     $22.92    \n",
       "350180             E       GENERAL PURCHASE     $12.60    \n",
       "425708             A       GENERAL PURCHASE     $17.90    \n",
       "18313              M       GENERAL PURCHASE     $20.64    \n",
       "237004             T       GENERAL PURCHASE     $16.64    \n",
       "46449              K           ROOM CHARGES  $2,908.62    \n",
       "295797             W       GENERAL PURCHASE    $150.00    \n",
       "107715             T       GENERAL PURCHASE    $188.00    \n",
       "23811              J       GENERAL PURCHASE     $90.00    \n",
       "191876             M       GENERAL PURCHASE     $38.91    \n",
       "331310             M       GENERAL PURCHASE     $39.04    \n",
       "245107             J       GENERAL PURCHASE     $37.46    \n",
       "242249             J       GENERAL PURCHASE     $37.22    \n",
       "176456             J       GENERAL PURCHASE     $93.29    \n",
       "293176             M       GENERAL PURCHASE     $39.06    \n",
       "277107             J       GENERAL PURCHASE     $37.46    \n",
       "107861             J       GENERAL PURCHASE     $92.15    \n",
       "227374             M       GENERAL PURCHASE     $39.06    \n",
       "...              ...                    ...         ...   \n",
       "286707             R       GENERAL PURCHASE    $233.58    \n",
       "150464             C       GENERAL PURCHASE    $181.17    \n",
       "287566             C       GENERAL PURCHASE    $103.20    \n",
       "195142             S       GENERAL PURCHASE  $1,177.02    \n",
       "181341             R       GENERAL PURCHASE    $130.21    \n",
       "399501             C       GENERAL PURCHASE    $165.73    \n",
       "398900             R       GENERAL PURCHASE    $260.24    \n",
       "147675             R       GENERAL PURCHASE    $174.14    \n",
       "435168             C       GENERAL PURCHASE  $1,904.98    \n",
       "414172             V       GENERAL PURCHASE    $688.01    \n",
       "74560              J       GENERAL PURCHASE      $9.95    \n",
       "141781             V       GENERAL PURCHASE     $69.44    \n",
       "256724             P       GENERAL PURCHASE     $87.15    \n",
       "285576             L       GENERAL PURCHASE    $756.62    \n",
       "38888              M       GENERAL PURCHASE    $185.00    \n",
       "12823              H       GENERAL PURCHASE     $95.40    \n",
       "356968             S       GENERAL PURCHASE    $399.00    \n",
       "377750             K       GENERAL PURCHASE    $476.37    \n",
       "415473             K       GENERAL PURCHASE    $509.75    \n",
       "438854             K       GENERAL PURCHASE    $489.00    \n",
       "215934             J       GENERAL PURCHASE    $259.00    \n",
       "74879              M       GENERAL PURCHASE    $179.00    \n",
       "248605             K       GENERAL PURCHASE    $179.00    \n",
       "247481             Y       GENERAL PURCHASE     $38.00    \n",
       "433297             L       GENERAL PURCHASE     $88.82    \n",
       "276256             G       GENERAL PURCHASE    $329.50    \n",
       "242936             G       GENERAL PURCHASE     $39.95    \n",
       "188107             S       GENERAL PURCHASE    $164.98    \n",
       "141288             C       GENERAL PURCHASE      $1.00    \n",
       "141293             C       GENERAL PURCHASE      $1.00    \n",
       "\n",
       "                           vendor transaction_date posted_date  \\\n",
       "203809            # 11 CITY BITES         1-Dec-11    2-Dec-11   \n",
       "135430            # 11 CITY BITES        19-Oct-11   20-Oct-11   \n",
       "203632            # 17 CITY BITES        28-Dec-11   29-Dec-11   \n",
       "41192             # 21 CITY BITES        14-Aug-11   15-Aug-11   \n",
       "259006            # 21 CITY BITES         5-Feb-12    6-Feb-12   \n",
       "203755            # 25 CITY BITES         9-Dec-11   12-Dec-11   \n",
       "26167         #08 VS 323169265994        20-Jul-11   22-Jul-11   \n",
       "183852          #1 PARTY SUPPLIES         2-Nov-11    7-Nov-11   \n",
       "187398                     #21 VS         1-Dec-11    5-Dec-11   \n",
       "122563      #41 BRIO COUNTRY CLUB         1-Oct-11    3-Oct-11   \n",
       "137080   #44 BRAVO| MEMORIAL SQUA        20-Oct-11   24-Oct-11   \n",
       "137066   #44 BRAVO| MEMORIAL SQUA        21-Oct-11   24-Oct-11   \n",
       "273523   #44 BRAVO| MEMORIAL SQUA        23-Feb-12   27-Feb-12   \n",
       "350180   #44 BRAVO| MEMORIAL SQUA        18-Apr-12   20-Apr-12   \n",
       "425708   #44 BRAVO| MEMORIAL SQUA        19-Jun-12   21-Jun-12   \n",
       "18313    #44 BRAVO| MEMORIAL SQUA        22-Jul-11   25-Jul-11   \n",
       "237004   #44 BRAVO| MEMORIAL SQUA         4-Jan-12    6-Jan-12   \n",
       "46449   #464 RADISSON HOTEL CENTR        15-Aug-11   16-Aug-11   \n",
       "295797  (SA)HANGUKJEUNGGYONHAGHOI        23-Feb-12   13-Mar-12   \n",
       "107715         000 DILLARD'S INC.        31-Aug-11    1-Sep-11   \n",
       "23811   003 CENTURYLINK MY ACCOUN         1-Jul-11    4-Jul-11   \n",
       "191876  003 CENTURYLINK MY ACCOUN         6-Dec-11    7-Dec-11   \n",
       "331310  003 CENTURYLINK MY ACCOUN        23-Apr-12   24-Apr-12   \n",
       "245107  003 CENTURYLINK MY ACCOUN        19-Jan-12   20-Jan-12   \n",
       "242249  003 CENTURYLINK MY ACCOUN         6-Jan-12    9-Jan-12   \n",
       "176456  003 CENTURYLINK MY ACCOUN         4-Nov-11    7-Nov-11   \n",
       "293176  003 CENTURYLINK MY ACCOUN        26-Mar-12   27-Mar-12   \n",
       "277107  003 CENTURYLINK MY ACCOUN        20-Feb-12   21-Feb-12   \n",
       "107861  003 CENTURYLINK MY ACCOUN         1-Sep-11    2-Sep-11   \n",
       "227374  003 CENTURYLINK MY ACCOUN        17-Jan-12   18-Jan-12   \n",
       "...                           ...              ...         ...   \n",
       "286707      pss_2025 INV MULTIPLE        10-Feb-12   13-Feb-12   \n",
       "150464      pss_2025 INV MULTIPLE        19-Oct-11   20-Oct-11   \n",
       "287566      pss_2025 INV MULTIPLE         3-Feb-12    6-Feb-12   \n",
       "195142      pss_2025 INV MULTIPLE        16-Dec-11   19-Dec-11   \n",
       "181341      pss_2025 INV MULTIPLE        16-Nov-11   17-Nov-11   \n",
       "399501      pss_2025 INV MULTIPLE         5-May-12    7-May-12   \n",
       "398900      pss_2025 INV MULTIPLE        24-May-12   25-May-12   \n",
       "147675      pss_2025 INV MULTIPLE        29-Oct-11   31-Oct-11   \n",
       "435168      pss_2025 INV MULTIPLE        23-Jun-12   25-Jun-12   \n",
       "414172        robotis-shop-en.com        15-Jun-12   18-Jun-12   \n",
       "74560          soilsleuth@aol.com        23-Aug-11   24-Aug-11   \n",
       "141781         value plastics inc        18-Oct-11   19-Oct-11   \n",
       "256724         value plastics inc        23-Feb-12   24-Feb-12   \n",
       "285576         value plastics inc         7-Feb-12    8-Feb-12   \n",
       "38888                 vet imaging         5-Aug-11    8-Aug-11   \n",
       "12823    wmill.com ResponseOmatic         6-Jul-11    8-Jul-11   \n",
       "356968      www.anastasiadate.com         8-Apr-12    9-Apr-12   \n",
       "377750           www.dumpster.com         8-May-12   10-May-12   \n",
       "415473           www.dumpster.com        27-Jun-12   29-Jun-12   \n",
       "438854       www.favoriteplus.com         8-Jun-12   11-Jun-12   \n",
       "215934              www.karger.ch        16-Dec-11   19-Dec-11   \n",
       "74879               www.karger.ch        12-Aug-11   15-Aug-11   \n",
       "248605              www.karger.ch        20-Jan-12   23-Jan-12   \n",
       "247481              www.karger.ch        13-Jan-12   17-Jan-12   \n",
       "433297                www.mohr.de        27-Jun-12   28-Jun-12   \n",
       "276256       www.realtimesoft.com        14-Feb-12   16-Feb-12   \n",
       "242936       www.realtimesoft.com         3-Jan-12    5-Jan-12   \n",
       "188107           www.testking.com        30-Nov-11    2-Dec-11   \n",
       "141288   zombaio.com C19042613186        15-Oct-11   17-Oct-11   \n",
       "141293   zombaio.com C38178113186        15-Oct-11   17-Oct-11   \n",
       "\n",
       "                                                      MCC  \n",
       "203809                      EATING PLACES AND RESTAURANTS  \n",
       "135430                      EATING PLACES AND RESTAURANTS  \n",
       "203632                      EATING PLACES AND RESTAURANTS  \n",
       "41192                       EATING PLACES AND RESTAURANTS  \n",
       "259006                      EATING PLACES AND RESTAURANTS  \n",
       "203755                      EATING PLACES AND RESTAURANTS  \n",
       "26167                                        Record Shops  \n",
       "183852          MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "187398                                        BOOK STORES  \n",
       "122563                      EATING PLACES AND RESTAURANTS  \n",
       "137080                      EATING PLACES AND RESTAURANTS  \n",
       "137066                      EATING PLACES AND RESTAURANTS  \n",
       "273523                      EATING PLACES AND RESTAURANTS  \n",
       "350180                      EATING PLACES AND RESTAURANTS  \n",
       "425708                      EATING PLACES AND RESTAURANTS  \n",
       "18313                       EATING PLACES AND RESTAURANTS  \n",
       "237004                      EATING PLACES AND RESTAURANTS  \n",
       "46449                  LODGING--HOTELS MOTELS AND RESORTS  \n",
       "295797  MISCELLANEOUS PERSONAL SERVICES--NOT ELSEWHERE...  \n",
       "107715                                  DEPARTMENT STORES  \n",
       "23811                          TELECOMMUNICATION SERVICES  \n",
       "191876                         TELECOMMUNICATION SERVICES  \n",
       "331310                         TELECOMMUNICATION SERVICES  \n",
       "245107                         TELECOMMUNICATION SERVICES  \n",
       "242249                         TELECOMMUNICATION SERVICES  \n",
       "176456                         TELECOMMUNICATION SERVICES  \n",
       "293176                         TELECOMMUNICATION SERVICES  \n",
       "277107                         TELECOMMUNICATION SERVICES  \n",
       "107861                         TELECOMMUNICATION SERVICES  \n",
       "227374                         TELECOMMUNICATION SERVICES  \n",
       "...                                                   ...  \n",
       "286707  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "150464  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "287566  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "195142  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "181341  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "399501  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "398900  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "147675  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "435168  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "414172  DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE...  \n",
       "74560   DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE...  \n",
       "141781          MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "256724          MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "285576          MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "38888           MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "12823      PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED  \n",
       "356968  DIRECT MARKETING--INBOUND TELEMARKETING MERCHANTS  \n",
       "377750  FUEL DEALERS--FUEL OIL WOOD COAL AND LIQ. PETR...  \n",
       "415473  FUEL DEALERS--FUEL OIL WOOD COAL AND LIQ. PETR...  \n",
       "438854  DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP...  \n",
       "215934            COMBINATION CATALOG AND RETAIL MERCHANT  \n",
       "74879             COMBINATION CATALOG AND RETAIL MERCHANT  \n",
       "248605            COMBINATION CATALOG AND RETAIL MERCHANT  \n",
       "247481          MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "433297                                        BOOK STORES  \n",
       "276256                           COMPUTER SOFTWARE STORES  \n",
       "242936                           COMPUTER SOFTWARE STORES  \n",
       "188107         BUSINESS SERVICES NOT ELSEWHERE CLASSIFIED  \n",
       "141288  DIRECT MARKETING--INBOUND TELEMARKETING MERCHANTS  \n",
       "141293  DIRECT MARKETING--INBOUND TELEMARKETING MERCHANTS  \n",
       "\n",
       "[442184 rows x 10 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2012.sort_values('vendor', ascending=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Perhaps we care about both vendor and last name."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency_number</th>\n",
       "      <th>agency_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>first_initial</th>\n",
       "      <th>description</th>\n",
       "      <th>amount</th>\n",
       "      <th>vendor</th>\n",
       "      <th>transaction_date</th>\n",
       "      <th>posted_date</th>\n",
       "      <th>MCC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50962</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$20.00</td>\n",
       "      <td>BART-COLISEUM      QPS</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>12-Aug-11</td>\n",
       "      <td>LOCAL AND SUBURBAN COMMUTER PASS TRANS  INCLUD...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343834</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>ROOM CHARGES</td>\n",
       "      <td>$140.00</td>\n",
       "      <td>BEST WESTERN WESTERN INN</td>\n",
       "      <td>14-Apr-12</td>\n",
       "      <td>16-Apr-12</td>\n",
       "      <td>BEST WESTERN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15132</th>\n",
       "      <td>35000</td>\n",
       "      <td>HISTORICAL SOCIETY</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>T</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$2,540.00</td>\n",
       "      <td>DRIVESAVERS INC</td>\n",
       "      <td>1-Jul-11</td>\n",
       "      <td>4-Jul-11</td>\n",
       "      <td>DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343787</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$140.27</td>\n",
       "      <td>GOLDEN CORRAL 2407</td>\n",
       "      <td>12-Apr-12</td>\n",
       "      <td>13-Apr-12</td>\n",
       "      <td>FAST FOOD RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130956</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$415.00</td>\n",
       "      <td>HAWAII INTL CONF INTERNET</td>\n",
       "      <td>29-Sep-11</td>\n",
       "      <td>3-Oct-11</td>\n",
       "      <td>SCHOOLS AND EDUCATIONAL SERVICES NOT ELSEWHERE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166397</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($340.00)</td>\n",
       "      <td>HAWAII INTL CONF INTERNET</td>\n",
       "      <td>1-Nov-11</td>\n",
       "      <td>3-Nov-11</td>\n",
       "      <td>SCHOOLS AND EDUCATIONAL SERVICES NOT ELSEWHERE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343830</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$49.02</td>\n",
       "      <td>LJS 31512</td>\n",
       "      <td>13-Apr-12</td>\n",
       "      <td>16-Apr-12</td>\n",
       "      <td>FAST FOOD RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343831</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$52.94</td>\n",
       "      <td>LJS 31512</td>\n",
       "      <td>13-Apr-12</td>\n",
       "      <td>16-Apr-12</td>\n",
       "      <td>FAST FOOD RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343833</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($52.94)</td>\n",
       "      <td>LJS 31512</td>\n",
       "      <td>13-Apr-12</td>\n",
       "      <td>16-Apr-12</td>\n",
       "      <td>FAST FOOD RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51082</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($16.99)</td>\n",
       "      <td>MARRIOTT OAKLND CITY CNTR</td>\n",
       "      <td>17-Aug-11</td>\n",
       "      <td>18-Aug-11</td>\n",
       "      <td>MARRIOTT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51094</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>ROOM CHARGES</td>\n",
       "      <td>$506.23</td>\n",
       "      <td>MARRIOTT OAKLND CITY CNTR</td>\n",
       "      <td>16-Aug-11</td>\n",
       "      <td>17-Aug-11</td>\n",
       "      <td>MARRIOTT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343832</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>ZWEIACHER</td>\n",
       "      <td>E</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$29.25</td>\n",
       "      <td>MCDONALD'S F4581</td>\n",
       "      <td>14-Apr-12</td>\n",
       "      <td>16-Apr-12</td>\n",
       "      <td>FAST FOOD RESTAURANTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92461</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$2,027.97</td>\n",
       "      <td>ARNETT NEW HOLLAND</td>\n",
       "      <td>2-Sep-11</td>\n",
       "      <td>5-Sep-11</td>\n",
       "      <td>MISC. AUTOMOTIVE AIRCRAFT AND FARM EQUIPMENT D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419808</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$52.67</td>\n",
       "      <td>ATW OF ELK CITY # 07</td>\n",
       "      <td>6-Jun-12</td>\n",
       "      <td>7-Jun-12</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131636</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$31.98</td>\n",
       "      <td>CHEYENNE LUMBER</td>\n",
       "      <td>3-Oct-11</td>\n",
       "      <td>5-Oct-11</td>\n",
       "      <td>LUMBER AND BUILDING MATERIALS STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419373</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$134.64</td>\n",
       "      <td>CHEYENNE LUMBER</td>\n",
       "      <td>12-Jun-12</td>\n",
       "      <td>14-Jun-12</td>\n",
       "      <td>LUMBER AND BUILDING MATERIALS STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51698</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$28.52</td>\n",
       "      <td>LOCKE SUPPLY - WHC WOODWA</td>\n",
       "      <td>4-Aug-11</td>\n",
       "      <td>8-Aug-11</td>\n",
       "      <td>HARDWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419516</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$509.70</td>\n",
       "      <td>LOCKE SUPPLY - WOODWARD</td>\n",
       "      <td>13-Jun-12</td>\n",
       "      <td>15-Jun-12</td>\n",
       "      <td>HARDWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231267</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$26.34</td>\n",
       "      <td>NORTHWEST BEARING &amp; INDUS</td>\n",
       "      <td>13-Jan-12</td>\n",
       "      <td>16-Jan-12</td>\n",
       "      <td>MISCELLANEOUS AND SPECIALTY RETAIL STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344706</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$240.75</td>\n",
       "      <td>ROLL GRAIN &amp; FEED</td>\n",
       "      <td>13-Apr-12</td>\n",
       "      <td>16-Apr-12</td>\n",
       "      <td>AGRICULTURAL COOPERATIVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92439</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$340.66</td>\n",
       "      <td>SANDER SPORTING GOODS</td>\n",
       "      <td>19-Sep-11</td>\n",
       "      <td>21-Sep-11</td>\n",
       "      <td>CAMPER RECREATIONAL AND UTILITY TRAILER DEALERS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167279</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$239.97</td>\n",
       "      <td>SEARS DEALER    3636</td>\n",
       "      <td>7-Nov-11</td>\n",
       "      <td>9-Nov-11</td>\n",
       "      <td>DEPARTMENT STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306386</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$2,037.19</td>\n",
       "      <td>SOLAR POWER AND PUMP CO</td>\n",
       "      <td>7-Mar-12</td>\n",
       "      <td>8-Mar-12</td>\n",
       "      <td>PLUMBING AND HEATING EQUIPMENT AND SUPPLIES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419809</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$310.00</td>\n",
       "      <td>SOLAR POWER AND PUMP CO</td>\n",
       "      <td>6-Jun-12</td>\n",
       "      <td>7-Jun-12</td>\n",
       "      <td>PLUMBING AND HEATING EQUIPMENT AND SUPPLIES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306441</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>NUZZLE ASSEMBLY1/4-2010 EA</td>\n",
       "      <td>$24.51</td>\n",
       "      <td>W W GRAINGER 916</td>\n",
       "      <td>19-Mar-12</td>\n",
       "      <td>21-Mar-12</td>\n",
       "      <td>INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306442</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>BUSHING1 X 3/4 IN SPIGOT EA|BUSHING1 1/4 X 3/4...</td>\n",
       "      <td>$987.69</td>\n",
       "      <td>W W GRAINGER 916</td>\n",
       "      <td>19-Mar-12</td>\n",
       "      <td>21-Mar-12</td>\n",
       "      <td>INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51943</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$118.94</td>\n",
       "      <td>WOODWARD ACE HARDWARE</td>\n",
       "      <td>29-Aug-11</td>\n",
       "      <td>31-Aug-11</td>\n",
       "      <td>HARDWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199094</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$91.98</td>\n",
       "      <td>WOODWARD ACE HARDWARE</td>\n",
       "      <td>7-Dec-11</td>\n",
       "      <td>9-Dec-11</td>\n",
       "      <td>HARDWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231269</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$77.96</td>\n",
       "      <td>WOODWARD ACE HOME CTR.</td>\n",
       "      <td>13-Jan-12</td>\n",
       "      <td>16-Jan-12</td>\n",
       "      <td>HARDWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268307</th>\n",
       "      <td>32000</td>\n",
       "      <td>DEPARTMENT OF WILDLIFE CONSERVATION</td>\n",
       "      <td>ZURENDA</td>\n",
       "      <td>J</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$27.00</td>\n",
       "      <td>WOODWARD ACE HOME CTR.</td>\n",
       "      <td>27-Feb-12</td>\n",
       "      <td>29-Feb-12</td>\n",
       "      <td>HARDWARE STORES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12701</th>\n",
       "      <td>26500</td>\n",
       "      <td>DEPARTMENT OF EDUCATION</td>\n",
       "      <td>26500</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$17,654.47</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91961</th>\n",
       "      <td>26500</td>\n",
       "      <td>DEPARTMENT OF EDUCATION</td>\n",
       "      <td>26500</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$12,265.27</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9792</th>\n",
       "      <td>2500</td>\n",
       "      <td>OKLAHOMA MILITARY DEPARTMENT</td>\n",
       "      <td>2500</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1,932.41</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88603</th>\n",
       "      <td>2500</td>\n",
       "      <td>OKLAHOMA MILITARY DEPARTMENT</td>\n",
       "      <td>2500</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$512.59</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418813</th>\n",
       "      <td>24100</td>\n",
       "      <td>REDLANDS COMMUNITY COLLEGE</td>\n",
       "      <td>24100</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$502.63</td>\n",
       "      <td>LATE PAYMENT FEE</td>\n",
       "      <td>25-Jun-12</td>\n",
       "      <td>25-Jun-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230389</th>\n",
       "      <td>24000</td>\n",
       "      <td>EASTERN OKLA. STATE COLLEGE</td>\n",
       "      <td>24000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($250.00)</td>\n",
       "      <td>CREDIT LATE CHARGE FEE</td>\n",
       "      <td>10-Nov-11</td>\n",
       "      <td>26-Jan-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230390</th>\n",
       "      <td>24000</td>\n",
       "      <td>EASTERN OKLA. STATE COLLEGE</td>\n",
       "      <td>24000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($0.75)</td>\n",
       "      <td>CREDIT PURCHASE FINANCE C</td>\n",
       "      <td>30-Nov-11</td>\n",
       "      <td>26-Jan-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166270</th>\n",
       "      <td>24000</td>\n",
       "      <td>EASTERN OKLA. STATE COLLEGE</td>\n",
       "      <td>24000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$250.00</td>\n",
       "      <td>LATE PAYMENT FEE</td>\n",
       "      <td>10-Nov-11</td>\n",
       "      <td>10-Nov-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305066</th>\n",
       "      <td>24000</td>\n",
       "      <td>EASTERN OKLA. STATE COLLEGE</td>\n",
       "      <td>24000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$423.49</td>\n",
       "      <td>LATE PAYMENT FEE</td>\n",
       "      <td>12-Mar-12</td>\n",
       "      <td>12-Mar-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166311</th>\n",
       "      <td>24000</td>\n",
       "      <td>EASTERN OKLA. STATE COLLEGE</td>\n",
       "      <td>24000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$0.75</td>\n",
       "      <td>PURCHASE  FINANCE CHARGE</td>\n",
       "      <td>30-Nov-11</td>\n",
       "      <td>30-Nov-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305076</th>\n",
       "      <td>24000</td>\n",
       "      <td>EASTERN OKLA. STATE COLLEGE</td>\n",
       "      <td>24000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1.54</td>\n",
       "      <td>PURCHASE  FINANCE CHARGE</td>\n",
       "      <td>30-Mar-12</td>\n",
       "      <td>30-Mar-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12611</th>\n",
       "      <td>22000</td>\n",
       "      <td>DISTRICT ATTORNEYS COUNCIL</td>\n",
       "      <td>22000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$127.96</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91459</th>\n",
       "      <td>22000</td>\n",
       "      <td>DISTRICT ATTORNEYS COUNCIL</td>\n",
       "      <td>22000</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$435.00</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163854</th>\n",
       "      <td>2200</td>\n",
       "      <td>OKLAHOMA ABSTRACTORS BOARD</td>\n",
       "      <td>2200</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($0.05)</td>\n",
       "      <td>CREDIT PURCHASE FINANCE C</td>\n",
       "      <td>31-Oct-11</td>\n",
       "      <td>4-Nov-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88415</th>\n",
       "      <td>2200</td>\n",
       "      <td>OKLAHOMA ABSTRACTORS BOARD</td>\n",
       "      <td>2200</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1,690.23</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12572</th>\n",
       "      <td>21500</td>\n",
       "      <td>BOARD OF DENTISTRY</td>\n",
       "      <td>21500</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$298.26</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91399</th>\n",
       "      <td>21500</td>\n",
       "      <td>BOARD OF DENTISTRY</td>\n",
       "      <td>21500</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$115.66</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12569</th>\n",
       "      <td>20400</td>\n",
       "      <td>J. M. DAVIS ARMS &amp; HIST. MUSEUM</td>\n",
       "      <td>20400</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$4,538.31</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91391</th>\n",
       "      <td>20400</td>\n",
       "      <td>J. M. DAVIS ARMS &amp; HIST. MUSEUM</td>\n",
       "      <td>20400</td>\n",
       "      <td>2</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$2,285.94</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12547</th>\n",
       "      <td>19000</td>\n",
       "      <td>COSMETOLOGY BOARD</td>\n",
       "      <td>19000</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$2,645.92</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91380</th>\n",
       "      <td>19000</td>\n",
       "      <td>COSMETOLOGY BOARD</td>\n",
       "      <td>19000</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1,270.00</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304785</th>\n",
       "      <td>16000</td>\n",
       "      <td>DEPARTMENT OF COMMERCE</td>\n",
       "      <td>16000</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>($0.10)</td>\n",
       "      <td>ADJUSTMENT</td>\n",
       "      <td>31-Jan-12</td>\n",
       "      <td>30-Mar-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343337</th>\n",
       "      <td>16000</td>\n",
       "      <td>DEPARTMENT OF COMMERCE</td>\n",
       "      <td>16000</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$0.20</td>\n",
       "      <td>BALANCE ADJUSTMENT</td>\n",
       "      <td>5-Apr-12</td>\n",
       "      <td>5-Apr-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230239</th>\n",
       "      <td>16000</td>\n",
       "      <td>DEPARTMENT OF COMMERCE</td>\n",
       "      <td>16000</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$5,461.54</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>12-Jan-12</td>\n",
       "      <td>31-Jan-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266831</th>\n",
       "      <td>16000</td>\n",
       "      <td>DEPARTMENT OF COMMERCE</td>\n",
       "      <td>16000</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$9,262.49</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Feb-12</td>\n",
       "      <td>21-Feb-12</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12398</th>\n",
       "      <td>14500</td>\n",
       "      <td>ST. BD. OF CHIROPRACTIC EXAM.</td>\n",
       "      <td>14500</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1,157,092.14</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91214</th>\n",
       "      <td>14500</td>\n",
       "      <td>ST. BD. OF CHIROPRACTIC EXAM.</td>\n",
       "      <td>14500</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$280.17</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12286</th>\n",
       "      <td>13100</td>\n",
       "      <td>DEPARTMENT OF CORRECTIONS</td>\n",
       "      <td>13100</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$2,619.29</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10819</th>\n",
       "      <td>12500</td>\n",
       "      <td>DEPARTMENT OF MINES</td>\n",
       "      <td>12500</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$10,815.38</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>13-Jul-11</td>\n",
       "      <td>27-Jul-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89524</th>\n",
       "      <td>12500</td>\n",
       "      <td>DEPARTMENT OF MINES</td>\n",
       "      <td>12500</td>\n",
       "      <td>1</td>\n",
       "      <td>GENERAL PURCHASE</td>\n",
       "      <td>$1,565.14</td>\n",
       "      <td>PAYMENT ADJUSTMENT</td>\n",
       "      <td>11-Aug-11</td>\n",
       "      <td>7-Sep-11</td>\n",
       "      <td>OTHER FEES</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>442184 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        agency_number                          agency_name  last_name  \\\n",
       "50962           24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "343834          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "15132           35000                   HISTORICAL SOCIETY  ZWEIACHER   \n",
       "343787          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "130956          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "166397          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "343830          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "343831          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "343833          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "51082           24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "51094           24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "343832          24100           REDLANDS COMMUNITY COLLEGE  ZWEIACHER   \n",
       "92461           32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "419808          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "131636          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "419373          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "51698           32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "419516          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "231267          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "344706          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "92439           32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "167279          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "306386          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "419809          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "306441          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "306442          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "51943           32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "199094          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "231269          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "268307          32000  DEPARTMENT OF WILDLIFE CONSERVATION    ZURENDA   \n",
       "...               ...                                  ...        ...   \n",
       "12701           26500              DEPARTMENT OF EDUCATION      26500   \n",
       "91961           26500              DEPARTMENT OF EDUCATION      26500   \n",
       "9792             2500         OKLAHOMA MILITARY DEPARTMENT       2500   \n",
       "88603            2500         OKLAHOMA MILITARY DEPARTMENT       2500   \n",
       "418813          24100           REDLANDS COMMUNITY COLLEGE      24100   \n",
       "230389          24000          EASTERN OKLA. STATE COLLEGE      24000   \n",
       "230390          24000          EASTERN OKLA. STATE COLLEGE      24000   \n",
       "166270          24000          EASTERN OKLA. STATE COLLEGE      24000   \n",
       "305066          24000          EASTERN OKLA. STATE COLLEGE      24000   \n",
       "166311          24000          EASTERN OKLA. STATE COLLEGE      24000   \n",
       "305076          24000          EASTERN OKLA. STATE COLLEGE      24000   \n",
       "12611           22000           DISTRICT ATTORNEYS COUNCIL      22000   \n",
       "91459           22000           DISTRICT ATTORNEYS COUNCIL      22000   \n",
       "163854           2200           OKLAHOMA ABSTRACTORS BOARD       2200   \n",
       "88415            2200           OKLAHOMA ABSTRACTORS BOARD       2200   \n",
       "12572           21500                   BOARD OF DENTISTRY      21500   \n",
       "91399           21500                   BOARD OF DENTISTRY      21500   \n",
       "12569           20400      J. M. DAVIS ARMS & HIST. MUSEUM      20400   \n",
       "91391           20400      J. M. DAVIS ARMS & HIST. MUSEUM      20400   \n",
       "12547           19000                    COSMETOLOGY BOARD      19000   \n",
       "91380           19000                    COSMETOLOGY BOARD      19000   \n",
       "304785          16000               DEPARTMENT OF COMMERCE      16000   \n",
       "343337          16000               DEPARTMENT OF COMMERCE      16000   \n",
       "230239          16000               DEPARTMENT OF COMMERCE      16000   \n",
       "266831          16000               DEPARTMENT OF COMMERCE      16000   \n",
       "12398           14500        ST. BD. OF CHIROPRACTIC EXAM.      14500   \n",
       "91214           14500        ST. BD. OF CHIROPRACTIC EXAM.      14500   \n",
       "12286           13100            DEPARTMENT OF CORRECTIONS      13100   \n",
       "10819           12500                  DEPARTMENT OF MINES      12500   \n",
       "89524           12500                  DEPARTMENT OF MINES      12500   \n",
       "\n",
       "       first_initial                                        description  \\\n",
       "50962              E                                   GENERAL PURCHASE   \n",
       "343834             E                                       ROOM CHARGES   \n",
       "15132              T                                   GENERAL PURCHASE   \n",
       "343787             E                                   GENERAL PURCHASE   \n",
       "130956             E                                   GENERAL PURCHASE   \n",
       "166397             E                                   GENERAL PURCHASE   \n",
       "343830             E                                   GENERAL PURCHASE   \n",
       "343831             E                                   GENERAL PURCHASE   \n",
       "343833             E                                   GENERAL PURCHASE   \n",
       "51082              E                                   GENERAL PURCHASE   \n",
       "51094              E                                       ROOM CHARGES   \n",
       "343832             E                                   GENERAL PURCHASE   \n",
       "92461              J                                   GENERAL PURCHASE   \n",
       "419808             J                                   GENERAL PURCHASE   \n",
       "131636             J                                   GENERAL PURCHASE   \n",
       "419373             J                                   GENERAL PURCHASE   \n",
       "51698              J                                   GENERAL PURCHASE   \n",
       "419516             J                                   GENERAL PURCHASE   \n",
       "231267             J                                   GENERAL PURCHASE   \n",
       "344706             J                                   GENERAL PURCHASE   \n",
       "92439              J                                   GENERAL PURCHASE   \n",
       "167279             J                                   GENERAL PURCHASE   \n",
       "306386             J                                   GENERAL PURCHASE   \n",
       "419809             J                                   GENERAL PURCHASE   \n",
       "306441             J                         NUZZLE ASSEMBLY1/4-2010 EA   \n",
       "306442             J  BUSHING1 X 3/4 IN SPIGOT EA|BUSHING1 1/4 X 3/4...   \n",
       "51943              J                                   GENERAL PURCHASE   \n",
       "199094             J                                   GENERAL PURCHASE   \n",
       "231269             J                                   GENERAL PURCHASE   \n",
       "268307             J                                   GENERAL PURCHASE   \n",
       "...              ...                                                ...   \n",
       "12701              2                                   GENERAL PURCHASE   \n",
       "91961              2                                   GENERAL PURCHASE   \n",
       "9792               2                                   GENERAL PURCHASE   \n",
       "88603              2                                   GENERAL PURCHASE   \n",
       "418813             2                                   GENERAL PURCHASE   \n",
       "230389             2                                   GENERAL PURCHASE   \n",
       "230390             2                                   GENERAL PURCHASE   \n",
       "166270             2                                   GENERAL PURCHASE   \n",
       "305066             2                                   GENERAL PURCHASE   \n",
       "166311             2                                   GENERAL PURCHASE   \n",
       "305076             2                                   GENERAL PURCHASE   \n",
       "12611              2                                   GENERAL PURCHASE   \n",
       "91459              2                                   GENERAL PURCHASE   \n",
       "163854             2                                   GENERAL PURCHASE   \n",
       "88415              2                                   GENERAL PURCHASE   \n",
       "12572              2                                   GENERAL PURCHASE   \n",
       "91399              2                                   GENERAL PURCHASE   \n",
       "12569              2                                   GENERAL PURCHASE   \n",
       "91391              2                                   GENERAL PURCHASE   \n",
       "12547              1                                   GENERAL PURCHASE   \n",
       "91380              1                                   GENERAL PURCHASE   \n",
       "304785             1                                   GENERAL PURCHASE   \n",
       "343337             1                                   GENERAL PURCHASE   \n",
       "230239             1                                   GENERAL PURCHASE   \n",
       "266831             1                                   GENERAL PURCHASE   \n",
       "12398              1                                   GENERAL PURCHASE   \n",
       "91214              1                                   GENERAL PURCHASE   \n",
       "12286              1                                   GENERAL PURCHASE   \n",
       "10819              1                                   GENERAL PURCHASE   \n",
       "89524              1                                   GENERAL PURCHASE   \n",
       "\n",
       "                amount                     vendor transaction_date  \\\n",
       "50962          $20.00      BART-COLISEUM      QPS        11-Aug-11   \n",
       "343834        $140.00    BEST WESTERN WESTERN INN        14-Apr-12   \n",
       "15132       $2,540.00             DRIVESAVERS INC         1-Jul-11   \n",
       "343787        $140.27          GOLDEN CORRAL 2407        12-Apr-12   \n",
       "130956        $415.00   HAWAII INTL CONF INTERNET        29-Sep-11   \n",
       "166397       ($340.00)  HAWAII INTL CONF INTERNET         1-Nov-11   \n",
       "343830         $49.02                   LJS 31512        13-Apr-12   \n",
       "343831         $52.94                   LJS 31512        13-Apr-12   \n",
       "343833        ($52.94)                  LJS 31512        13-Apr-12   \n",
       "51082         ($16.99)  MARRIOTT OAKLND CITY CNTR        17-Aug-11   \n",
       "51094         $506.23   MARRIOTT OAKLND CITY CNTR        16-Aug-11   \n",
       "343832         $29.25            MCDONALD'S F4581        14-Apr-12   \n",
       "92461       $2,027.97          ARNETT NEW HOLLAND         2-Sep-11   \n",
       "419808         $52.67        ATW OF ELK CITY # 07         6-Jun-12   \n",
       "131636         $31.98             CHEYENNE LUMBER         3-Oct-11   \n",
       "419373        $134.64             CHEYENNE LUMBER        12-Jun-12   \n",
       "51698          $28.52   LOCKE SUPPLY - WHC WOODWA         4-Aug-11   \n",
       "419516        $509.70     LOCKE SUPPLY - WOODWARD        13-Jun-12   \n",
       "231267         $26.34   NORTHWEST BEARING & INDUS        13-Jan-12   \n",
       "344706        $240.75           ROLL GRAIN & FEED        13-Apr-12   \n",
       "92439         $340.66       SANDER SPORTING GOODS        19-Sep-11   \n",
       "167279        $239.97        SEARS DEALER    3636         7-Nov-11   \n",
       "306386      $2,037.19     SOLAR POWER AND PUMP CO         7-Mar-12   \n",
       "419809        $310.00     SOLAR POWER AND PUMP CO         6-Jun-12   \n",
       "306441         $24.51            W W GRAINGER 916        19-Mar-12   \n",
       "306442        $987.69            W W GRAINGER 916        19-Mar-12   \n",
       "51943         $118.94       WOODWARD ACE HARDWARE        29-Aug-11   \n",
       "199094         $91.98       WOODWARD ACE HARDWARE         7-Dec-11   \n",
       "231269         $77.96      WOODWARD ACE HOME CTR.        13-Jan-12   \n",
       "268307         $27.00      WOODWARD ACE HOME CTR.        27-Feb-12   \n",
       "...                ...                        ...              ...   \n",
       "12701      $17,654.47          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "91961      $12,265.27          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "9792        $1,932.41          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "88603         $512.59          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "418813        $502.63            LATE PAYMENT FEE        25-Jun-12   \n",
       "230389       ($250.00)     CREDIT LATE CHARGE FEE        10-Nov-11   \n",
       "230390         ($0.75)  CREDIT PURCHASE FINANCE C        30-Nov-11   \n",
       "166270        $250.00            LATE PAYMENT FEE        10-Nov-11   \n",
       "305066        $423.49            LATE PAYMENT FEE        12-Mar-12   \n",
       "166311          $0.75    PURCHASE  FINANCE CHARGE        30-Nov-11   \n",
       "305076          $1.54    PURCHASE  FINANCE CHARGE        30-Mar-12   \n",
       "12611         $127.96          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "91459         $435.00          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "163854         ($0.05)  CREDIT PURCHASE FINANCE C        31-Oct-11   \n",
       "88415       $1,690.23          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "12572         $298.26          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "91399         $115.66          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "12569       $4,538.31          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "91391       $2,285.94          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "12547       $2,645.92          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "91380       $1,270.00          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "304785         ($0.10)                 ADJUSTMENT        31-Jan-12   \n",
       "343337          $0.20          BALANCE ADJUSTMENT         5-Apr-12   \n",
       "230239      $5,461.54          PAYMENT ADJUSTMENT        12-Jan-12   \n",
       "266831      $9,262.49          PAYMENT ADJUSTMENT        13-Feb-12   \n",
       "12398   $1,157,092.14          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "91214         $280.17          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "12286       $2,619.29          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "10819      $10,815.38          PAYMENT ADJUSTMENT        13-Jul-11   \n",
       "89524       $1,565.14          PAYMENT ADJUSTMENT        11-Aug-11   \n",
       "\n",
       "       posted_date                                                MCC  \n",
       "50962    12-Aug-11  LOCAL AND SUBURBAN COMMUTER PASS TRANS  INCLUD...  \n",
       "343834   16-Apr-12                                       BEST WESTERN  \n",
       "15132     4-Jul-11  DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE...  \n",
       "343787   13-Apr-12                              FAST FOOD RESTAURANTS  \n",
       "130956    3-Oct-11  SCHOOLS AND EDUCATIONAL SERVICES NOT ELSEWHERE...  \n",
       "166397    3-Nov-11  SCHOOLS AND EDUCATIONAL SERVICES NOT ELSEWHERE...  \n",
       "343830   16-Apr-12                              FAST FOOD RESTAURANTS  \n",
       "343831   16-Apr-12                              FAST FOOD RESTAURANTS  \n",
       "343833   16-Apr-12                              FAST FOOD RESTAURANTS  \n",
       "51082    18-Aug-11                                           MARRIOTT  \n",
       "51094    17-Aug-11                                           MARRIOTT  \n",
       "343832   16-Apr-12                              FAST FOOD RESTAURANTS  \n",
       "92461     5-Sep-11  MISC. AUTOMOTIVE AIRCRAFT AND FARM EQUIPMENT D...  \n",
       "419808    7-Jun-12          MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "131636    5-Oct-11               LUMBER AND BUILDING MATERIALS STORES  \n",
       "419373   14-Jun-12               LUMBER AND BUILDING MATERIALS STORES  \n",
       "51698     8-Aug-11                                    HARDWARE STORES  \n",
       "419516   15-Jun-12                                    HARDWARE STORES  \n",
       "231267   16-Jan-12          MISCELLANEOUS AND SPECIALTY RETAIL STORES  \n",
       "344706   16-Apr-12                          AGRICULTURAL COOPERATIVES  \n",
       "92439    21-Sep-11    CAMPER RECREATIONAL AND UTILITY TRAILER DEALERS  \n",
       "167279    9-Nov-11                                  DEPARTMENT STORES  \n",
       "306386    8-Mar-12        PLUMBING AND HEATING EQUIPMENT AND SUPPLIES  \n",
       "419809    7-Jun-12        PLUMBING AND HEATING EQUIPMENT AND SUPPLIES  \n",
       "306441   21-Mar-12       INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED  \n",
       "306442   21-Mar-12       INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED  \n",
       "51943    31-Aug-11                                    HARDWARE STORES  \n",
       "199094    9-Dec-11                                    HARDWARE STORES  \n",
       "231269   16-Jan-12                                    HARDWARE STORES  \n",
       "268307   29-Feb-12                                    HARDWARE STORES  \n",
       "...            ...                                                ...  \n",
       "12701    27-Jul-11                                         OTHER FEES  \n",
       "91961     7-Sep-11                                         OTHER FEES  \n",
       "9792     27-Jul-11                                         OTHER FEES  \n",
       "88603     7-Sep-11                                         OTHER FEES  \n",
       "418813   25-Jun-12                                         OTHER FEES  \n",
       "230389   26-Jan-12                                         OTHER FEES  \n",
       "230390   26-Jan-12                                         OTHER FEES  \n",
       "166270   10-Nov-11                                         OTHER FEES  \n",
       "305066   12-Mar-12                                         OTHER FEES  \n",
       "166311   30-Nov-11                                         OTHER FEES  \n",
       "305076   30-Mar-12                                         OTHER FEES  \n",
       "12611    27-Jul-11                                         OTHER FEES  \n",
       "91459     7-Sep-11                                         OTHER FEES  \n",
       "163854    4-Nov-11                                         OTHER FEES  \n",
       "88415     7-Sep-11                                         OTHER FEES  \n",
       "12572    27-Jul-11                                         OTHER FEES  \n",
       "91399     7-Sep-11                                         OTHER FEES  \n",
       "12569    27-Jul-11                                         OTHER FEES  \n",
       "91391     7-Sep-11                                         OTHER FEES  \n",
       "12547    27-Jul-11                                         OTHER FEES  \n",
       "91380     7-Sep-11                                         OTHER FEES  \n",
       "304785   30-Mar-12                                         OTHER FEES  \n",
       "343337    5-Apr-12                                         OTHER FEES  \n",
       "230239   31-Jan-12                                         OTHER FEES  \n",
       "266831   21-Feb-12                                         OTHER FEES  \n",
       "12398    27-Jul-11                                         OTHER FEES  \n",
       "91214     7-Sep-11                                         OTHER FEES  \n",
       "12286    27-Jul-11                                         OTHER FEES  \n",
       "10819    27-Jul-11                                         OTHER FEES  \n",
       "89524     7-Sep-11                                         OTHER FEES  \n",
       "\n",
       "[442184 rows x 10 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2012.sort_values(['last_name', 'vendor'], ascending=[False, True])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Grouping data and summary statistics\n",
    "Let's look at subsets of data and get some summary statistics by group. There are a lot of ways to do this, including subsetting the data into seperate dataframes, as we did above. However, let's use a more efficient tool, `groupby`. Let me first pull in a data set that has the right dtypes, so that the amounts look right."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's say we want to look at how many transactions happen for OSU by vendor. </p>\n",
    "First, let's group the data together by vendor. There is nothing to see here, since we have just told the data how to group. What we have is a DataFrameGroupBy object. You can think of that as instructions on how to group, but without instructions on how to display values."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.DataFrameGroupBy object at 0x7fa8249260f0>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year_df = df2012.groupby('vendor')\n",
    "year_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now, let's tell it to do an operation on the groups using the agg function."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vendor</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vendor</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th># 11 CITY BITES</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th># 17 CITY BITES</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th># 21 CITY BITES</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th># 25 CITY BITES</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#08 VS 323169265994</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 PARTY SUPPLIES</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#21 VS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#41 BRIO COUNTRY CLUB</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#44 BRAVO| MEMORIAL SQUA</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#464 RADISSON HOTEL CENTR</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(SA)HANGUKJEUNGGYONHAGHOI</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000 DILLARD'S INC.</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>003 CENTURYLINK MY ACCOUN</th>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>004 CENTURYLINK IVR</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0187 CED</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0280 OKLAHOMA FAIR</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>040 CODE REVISERS OFFICE</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0410 AMERICAN</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>084-SPOTLIGHT 14</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 800 621 6427</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 800 869 4263</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 800 RADIATOR AND AC OF</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 800 RADIATOR OKC</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 CART COM</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 STOP SIGNS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 WORLD GLOBES AND MAPS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 WORLD SARONGS</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-800 CONFERENCE</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-800-DOORBELL-LORD HEN</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10 8 VIDEO</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 72898661</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 72929208</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 72979430</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 73009678</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 73047095</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 73455627</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 81430518</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 81723010</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 81737927</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 82063819</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 82064441</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 82283035</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 82607406</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 82755972</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV 82859286</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pss_2025 INV MULTIPLE</th>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>robotis-shop-en.com</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>soilsleuth@aol.com</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>value plastics inc</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vet imaging</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wmill.com ResponseOmatic</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>www.anastasiadate.com</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>www.dumpster.com</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>www.favoriteplus.com</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>www.karger.ch</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>www.mohr.de</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>www.realtimesoft.com</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>www.testking.com</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zombaio.com C19042613186</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zombaio.com C38178113186</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>92427 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           vendor\n",
       "vendor                           \n",
       "# 11 CITY BITES                 2\n",
       "# 17 CITY BITES                 1\n",
       "# 21 CITY BITES                 2\n",
       "# 25 CITY BITES                 1\n",
       "#08 VS 323169265994             1\n",
       "#1 PARTY SUPPLIES               1\n",
       "#21 VS                          1\n",
       "#41 BRIO COUNTRY CLUB           1\n",
       "#44 BRAVO| MEMORIAL SQUA        7\n",
       "#464 RADISSON HOTEL CENTR       1\n",
       "(SA)HANGUKJEUNGGYONHAGHOI       1\n",
       "000 DILLARD'S INC.              1\n",
       "003 CENTURYLINK MY ACCOUN      27\n",
       "004 CENTURYLINK IVR            11\n",
       "0187 CED                        4\n",
       "0280 OKLAHOMA FAIR              2\n",
       "040 CODE REVISERS OFFICE        2\n",
       "0410 AMERICAN                  16\n",
       "084-SPOTLIGHT 14                5\n",
       "1 800 621 6427                  3\n",
       "1 800 869 4263                  1\n",
       "1 800 RADIATOR AND AC OF        4\n",
       "1 800 RADIATOR OKC              1\n",
       "1 CART COM                      1\n",
       "1 STOP SIGNS                    1\n",
       "1 WORLD GLOBES AND MAPS         1\n",
       "1 WORLD SARONGS                 2\n",
       "1-800 CONFERENCE                3\n",
       "1-800-DOORBELL-LORD HEN         2\n",
       "10 8 VIDEO                      1\n",
       "...                           ...\n",
       "pss_2025 INV 72898661           1\n",
       "pss_2025 INV 72929208           1\n",
       "pss_2025 INV 72979430           1\n",
       "pss_2025 INV 73009678           1\n",
       "pss_2025 INV 73047095           1\n",
       "pss_2025 INV 73455627           1\n",
       "pss_2025 INV 81430518           1\n",
       "pss_2025 INV 81723010           1\n",
       "pss_2025 INV 81737927           1\n",
       "pss_2025 INV 82063819           1\n",
       "pss_2025 INV 82064441           1\n",
       "pss_2025 INV 82283035           1\n",
       "pss_2025 INV 82607406           1\n",
       "pss_2025 INV 82755972           1\n",
       "pss_2025 INV 82859286           1\n",
       "pss_2025 INV MULTIPLE          36\n",
       "robotis-shop-en.com             1\n",
       "soilsleuth@aol.com              1\n",
       "value plastics inc              3\n",
       "vet imaging                     1\n",
       "wmill.com ResponseOmatic        1\n",
       "www.anastasiadate.com           1\n",
       "www.dumpster.com                2\n",
       "www.favoriteplus.com            1\n",
       "www.karger.ch                   4\n",
       "www.mohr.de                     1\n",
       "www.realtimesoft.com            2\n",
       "www.testking.com                1\n",
       "zombaio.com C19042613186        1\n",
       "zombaio.com C38178113186        1\n",
       "\n",
       "[92427 rows x 1 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year_df.agg({'vendor': 'count'})"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We could do this all at once, and in multiple ways. The last one is a built-in function that you might find convenient."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Staples Contra00710004       12542\n",
       "WM SUPERCENTER                9844\n",
       "AMAZON MKTPLACE PMTS          9413\n",
       "Amazon.com                    8248\n",
       "WW GRAINGER                   7018\n",
       "VWR INTERNATIONAL INC         5097\n",
       "W W GRAINGER 916              4999\n",
       "LOWES #00241                  4460\n",
       "BILL WARREN OFFICE PRODUC     3369\n",
       "DMI  DELL HIGHER EDUC         3218\n",
       "STAPLES       00105288        2821\n",
       "FISHER SCI HUS                2659\n",
       "FASTENAL COMPANY01            2522\n",
       "SIGMA ALDRICH US              2491\n",
       "MCKESSON MEDICAL SUPPLY       2071\n",
       "AT&T DATA                     1753\n",
       "AIRGAS MID SOUTH              1646\n",
       "APL APPLE ONLINE STORE        1630\n",
       "EUREKA WATER COMPANY          1586\n",
       "XPEDX-INTL PAPER              1558\n",
       "WWW.NEWEGG.COM                1529\n",
       "DELL MARKETING L.P. ROUND     1497\n",
       "AIRGAS CENTRAL                1488\n",
       "LOWES #01165                  1488\n",
       "B&C BUSINESS PRODUCTS         1422\n",
       "GEXPRO                        1384\n",
       "QUILL CORPORATION             1380\n",
       "THE HOME DEPOT 3906           1321\n",
       "ATT BUS PHONE PMT             1314\n",
       "DMI  DELL K-12/GOVT           1208\n",
       "                             ...  \n",
       "PAYPAL  OKLAHOMAATH              1\n",
       "BEST WESTERN HOTELS MAIN         1\n",
       "GALLAGHER BENEFIT S              1\n",
       "SOUTHWESTAIR5262433465974        1\n",
       "AGENT FEE   8900547864906        1\n",
       "AMERICAN AI 0018665813413        1\n",
       "INVITROGEN 21012440              1\n",
       "DELTA AIR   0068743291432        1\n",
       "AGENT FEE   8900549285888        1\n",
       "SOUTHWESTAIR5262428027628        1\n",
       "AGENT FEE   8900572644721        1\n",
       "JOURNYHSE DINGELDEIN             1\n",
       "AGENT FEE   8900569946169        1\n",
       "FEDEX 794995719461               1\n",
       "OFFICEMAX CT IN#021299           1\n",
       "AMERICAN AI 0017059080894        1\n",
       "NAMMAR AGCY 0001663130630        1\n",
       "FEDEX 522882879440               1\n",
       "FEDEX 798357097877               1\n",
       "JOURNYHSE BIGGERSA               1\n",
       "STAPLS9220851295000              1\n",
       "FEDEX 793587755946               1\n",
       "OFFICEMAX CT IN#823856           1\n",
       "AGENT FEE   8900575834201        1\n",
       "ACT GARTNER FALL SYMPO           1\n",
       "FEDEX 793275373081               1\n",
       "DIRECT ADVANTAGE                 1\n",
       "AGENT FEE   8900571445118        1\n",
       "FEDEX 899702595702               1\n",
       "DELTA AIR   0068665813273        1\n",
       "Name: vendor, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#df2012.groupby('vendor').agg({'vendor': 'count'})\n",
    "#df2012.groupby('vendor').count()\n",
    "#df2012.groupby('vendor')['agency_number'].count()\n",
    "df2012.vendor.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Finally, let's look at both transaction data and vendor, and look at the count."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>vendor</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>transaction_date</th>\n",
       "      <th>vendor</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">1-Apr-12</th>\n",
       "      <th>59 DINER</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACCESSLINE   PHONE SVC</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGENT FEE   8900573345226</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALFALFA ELECTRIC COOPERA</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALL STAR AIRPORT EXPRESS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMAZON MKTPLACE PMTS</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267646861</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267647896</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267647982</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267648058</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267648120</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267648225</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267648302</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267648409</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0010267648476</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMERICAN AI 0017048271482</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMPCO PARKING OKLAHOMA CI</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>APL APPLE ITUNES STORE</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>APL APPLE ONLINE STORE</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARC SERVICES/TRAINING</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AT LINK SERVICES</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AT&amp;T DATA</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ATT POS PARTNER</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ATTM 827927751   NBI</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ATTM 827978547   NBI</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUTOST AREZZO/MASSAROSA</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUTOST LUCCA OVEST/AREZZO</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUTOST ROMA NORD/AREZZO</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AV  AVNET ELECTRONICS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amazon.com</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">9-Sep-11</th>\n",
       "      <th>WALMART.COM</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WATER STORE INC</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WAYEST SAFETY INC</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEATHERFORD ACE HOME CTR</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEATHERLY RCA</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEBSITEHOSTINGBILL.COM</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WESTERN DIGITAL CORPORAT</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WESTERN EQUIPMENT ALVA</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WESTLAKE HARDWARE</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WHITTIER MAILING PRODUCTS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WHITTON SUPPLY CO</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WILCOXON RESEARCH INC</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WILDFLOWERMEADOWS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WINFIELD SOLUTIONS OCITY</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WINKLE'S PLUMBING &amp; ELECT</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WKH LIPPINCOTT WMS/WIL</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WM EZPAY</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WM SUPERCENTER</th>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WOLVERINE BRASS INC</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WOODWARD HOLIDAY INN EXP</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WOSC BUSINESS OFFICE</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WSC Windstream Pmt&amp;Fee</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WSC Windstream PmtFee</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WSG WILSON SPTG GDS</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WW GRAINGER</th>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WWW.NEWEGG.COM</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XPEDX-INTL PAPER</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y BAR RENTAL &amp; EQUIPMENT</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YELLOW HOUSE SAND SPRINGS</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YODER BROTHERS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>257550 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            vendor\n",
       "transaction_date vendor                           \n",
       "1-Apr-12         59 DINER                        1\n",
       "                 ACCESSLINE   PHONE SVC          1\n",
       "                 AGENT FEE   8900573345226       1\n",
       "                 ALFALFA ELECTRIC COOPERA        1\n",
       "                 ALL STAR AIRPORT EXPRESS        1\n",
       "                 AMAZON MKTPLACE PMTS            8\n",
       "                 AMERICAN AI 0010267646861       1\n",
       "                 AMERICAN AI 0010267647896       1\n",
       "                 AMERICAN AI 0010267647982       1\n",
       "                 AMERICAN AI 0010267648058       1\n",
       "                 AMERICAN AI 0010267648120       1\n",
       "                 AMERICAN AI 0010267648225       1\n",
       "                 AMERICAN AI 0010267648302       1\n",
       "                 AMERICAN AI 0010267648409       1\n",
       "                 AMERICAN AI 0010267648476       1\n",
       "                 AMERICAN AI 0017048271482       1\n",
       "                 AMPCO PARKING OKLAHOMA CI       1\n",
       "                 APL APPLE ITUNES STORE          3\n",
       "                 APL APPLE ONLINE STORE          8\n",
       "                 ARC SERVICES/TRAINING           1\n",
       "                 AT LINK SERVICES                1\n",
       "                 AT&T DATA                       5\n",
       "                 ATT POS PARTNER                 3\n",
       "                 ATTM 827927751   NBI            1\n",
       "                 ATTM 827978547   NBI            1\n",
       "                 AUTOST AREZZO/MASSAROSA         1\n",
       "                 AUTOST LUCCA OVEST/AREZZO       1\n",
       "                 AUTOST ROMA NORD/AREZZO         1\n",
       "                 AV  AVNET ELECTRONICS           1\n",
       "                 Amazon.com                     10\n",
       "...                                            ...\n",
       "9-Sep-11         WALMART.COM                     1\n",
       "                 WATER STORE INC                 1\n",
       "                 WAYEST SAFETY INC               2\n",
       "                 WEATHERFORD ACE HOME CTR        1\n",
       "                 WEATHERLY RCA                   1\n",
       "                 WEBSITEHOSTINGBILL.COM          1\n",
       "                 WESTERN DIGITAL CORPORAT        1\n",
       "                 WESTERN EQUIPMENT ALVA          1\n",
       "                 WESTLAKE HARDWARE               1\n",
       "                 WHITTIER MAILING PRODUCTS       1\n",
       "                 WHITTON SUPPLY CO               2\n",
       "                 WILCOXON RESEARCH INC           1\n",
       "                 WILDFLOWERMEADOWS               1\n",
       "                 WINFIELD SOLUTIONS OCITY        1\n",
       "                 WINKLE'S PLUMBING & ELECT       1\n",
       "                 WKH LIPPINCOTT WMS/WIL          1\n",
       "                 WM EZPAY                        1\n",
       "                 WM SUPERCENTER                 56\n",
       "                 WOLVERINE BRASS INC             1\n",
       "                 WOODWARD HOLIDAY INN EXP        2\n",
       "                 WOSC BUSINESS OFFICE            1\n",
       "                 WSC Windstream Pmt&Fee          5\n",
       "                 WSC Windstream PmtFee           2\n",
       "                 WSG WILSON SPTG GDS             2\n",
       "                 WW GRAINGER                    18\n",
       "                 WWW.NEWEGG.COM                  8\n",
       "                 XPEDX-INTL PAPER               10\n",
       "                 Y BAR RENTAL & EQUIPMENT        1\n",
       "                 YELLOW HOUSE SAND SPRINGS       2\n",
       "                 YODER BROTHERS                  1\n",
       "\n",
       "[257550 rows x 1 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2012.groupby(['transaction_date', 'vendor']).agg({'vendor': 'count'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}