Messy_Data_Breakout_Pandas.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:a54fcb4b11db5aa420212ce3902532b294e671b3aa5226ec0631fcf5190e7507"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# Intro\n",
      "For one of the breakout sessions in the \"Dealing with Messy Data\" session run by [Milena](http://twitter.com/milena_iul) and [Yuandra](http://twitter.com/iniandra) dealt with getting data into pandas and trying to fix as much as feasible using pandas. Intro by [Jeramia](http://twitter.com/DrLabRatOry), panda-fu by [Kyle](http://twitter.com/rgbkrk).\n",
      "\n",
      "First we need to import `pandas`"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 49
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Using IPython notebook's shell magic, we can see what excel files exist in the directory:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "!ls *.xlsx"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\u001b[31mNassau_police_union_contribs_dirty.xlsx\u001b[m\u001b[m\r\n",
        "~$Nassau_police_union_contribs_dirty.xlsx\r\n"
       ]
      }
     ],
     "prompt_number": 50
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "We can read the excel file (warts and all) using the `read_excel` command:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df = pd.read_excel('Nassau_police_union_contribs_dirty.xlsx')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 51
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Display an (abbreviated) contents of the dataFrame using IPython notebooks display magic:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>DATE</th>\n",
        "      <th>NAME OF INITIATIVE/ADDRESS</th>\n",
        "      <th>City</th>\n",
        "      <th>State</th>\n",
        "      <th>Zip Code</th>\n",
        "      <th>CHECK NO.</th>\n",
        "      <th>AMOUNT ($ )</th>\n",
        "      <th>RECORD DATE</th>\n",
        "      <th>Party</th>\n",
        "      <th>Source</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0   </th>\n",
        "      <td> 02/21/02</td>\n",
        "      <td>        BRONX CONSERVATIVE COMM;415 MINNIEFORD AVE</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td> N.Y.</td>\n",
        "      <td> 10458</td>\n",
        "      <td> 1562</td>\n",
        "      <td>  $ 140</td>\n",
        "      <td> JUL-03-02 10:16 AM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1   </th>\n",
        "      <td> 02/23/09</td>\n",
        "      <td>      BRONX CONSERVATIVE COMM.;188D EDGEWATER PARK</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 10465</td>\n",
        "      <td> 2628</td>\n",
        "      <td>    100</td>\n",
        "      <td> JUL-13-09 04:13 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2   </th>\n",
        "      <td> 03/01/00</td>\n",
        "      <td>   BRONX CONSERVATIVE COMMITTEE;475 MINNEFORD AVE.</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 10464</td>\n",
        "      <td> 1346</td>\n",
        "      <td>    405</td>\n",
        "      <td> JUL-10-00 02:50 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3   </th>\n",
        "      <td> 03/04/03</td>\n",
        "      <td>   BRONX CONSERVATIVE COMMITTEE;188 EDGEWATER PARK</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 10465</td>\n",
        "      <td> 1727</td>\n",
        "      <td>    100</td>\n",
        "      <td> JUL-14-03 02:41 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4   </th>\n",
        "      <td> 03/18/04</td>\n",
        "      <td>   BRONX CONSERVATIVE COMMITTEE;188D EDGEMERE PARK</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 10465</td>\n",
        "      <td> 1869</td>\n",
        "      <td>    100</td>\n",
        "      <td> JUL-14-04 01:09 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5   </th>\n",
        "      <td> 03/01/05</td>\n",
        "      <td>  BRONX CONSERVATIVE COMMITTEE;1880 EDGEWATER PARK</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 10465</td>\n",
        "      <td> 1975</td>\n",
        "      <td>    100</td>\n",
        "      <td> JUL-13-05 03:48 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6   </th>\n",
        "      <td> 02/26/07</td>\n",
        "      <td>   BRONX CONSERVATIVE COMMITTEE;188D EDGEMERE PARK</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 10465</td>\n",
        "      <td> 2371</td>\n",
        "      <td>    100</td>\n",
        "      <td> JUL-16-07 05:32 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7   </th>\n",
        "      <td> 03/20/08</td>\n",
        "      <td>   BRONX CONSERVATIVE COMMITTEE;188D EDGEMERE PARK</td>\n",
        "      <td>         BRONX</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 10465</td>\n",
        "      <td> 2504</td>\n",
        "      <td>    100</td>\n",
        "      <td> JUL-15-08 02:53 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8   </th>\n",
        "      <td> 05/25/04</td>\n",
        "      <td> NASSAU  COUNTY CONSERVATIVE COMMITTEE;105 BOBO...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1902</td>\n",
        "      <td>    200</td>\n",
        "      <td> JUL-14-04 02:08 PM</td>\n",
        "      <td> C</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9   </th>\n",
        "      <td> 01/20/09</td>\n",
        "      <td> NASSAU CO. CONSERVATIVE COMMITTEE;105 BOBOLINK LA</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 2603</td>\n",
        "      <td>    200</td>\n",
        "      <td> JUL-13-09 03:51 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10  </th>\n",
        "      <td> 04/30/09</td>\n",
        "      <td>  NASSAU CO. CONSERVATIVE COMMITTEE;105 BOBLINK LA</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 2646</td>\n",
        "      <td>    250</td>\n",
        "      <td> JUL-13-09 04:42 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11  </th>\n",
        "      <td> 02/15/05</td>\n",
        "      <td>   NASSAU CO. CONSERVATIVE PARTY;105 BOBOLINK LANE</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1968</td>\n",
        "      <td>    120</td>\n",
        "      <td> JUL-13-05 03:34 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12  </th>\n",
        "      <td> 04/14/11</td>\n",
        "      <td>         NASSAU CO. CONSERVATIVE PARTY;1 SYDNEY ST</td>\n",
        "      <td>     PLAINVIEW</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11803</td>\n",
        "      <td> 2854</td>\n",
        "      <td>  $ 200</td>\n",
        "      <td> JUL-11-11 03:19 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13  </th>\n",
        "      <td> 05/28/02</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td> N.Y.</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1858</td>\n",
        "      <td>  $ 300</td>\n",
        "      <td> JUL-15-02 10:36 AM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14  </th>\n",
        "      <td> 05/23/03</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1953</td>\n",
        "      <td>   2000</td>\n",
        "      <td> JUL-11-03 02:42 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15  </th>\n",
        "      <td> 05/23/03</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1954</td>\n",
        "      <td>    300</td>\n",
        "      <td> JUL-11-03 02:43 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16  </th>\n",
        "      <td> 06/01/04</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBLI...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 2032</td>\n",
        "      <td> $ 3500</td>\n",
        "      <td> JUL-15-04 12:08 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17  </th>\n",
        "      <td> 05/05/06</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 2238</td>\n",
        "      <td>    400</td>\n",
        "      <td> JUN-16-06 09:09 AM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18  </th>\n",
        "      <td> 02/13/09</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1236</td>\n",
        "      <td>    400</td>\n",
        "      <td> JUL-08-09 01:26 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19  </th>\n",
        "      <td> 04/10/09</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1263</td>\n",
        "      <td>   1500</td>\n",
        "      <td> JUL-08-09 02:27 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20  </th>\n",
        "      <td> 05/05/11</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;1 SYDNEY ...</td>\n",
        "      <td>     PLAINVIEW</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11803</td>\n",
        "      <td> 1548</td>\n",
        "      <td>    100</td>\n",
        "      <td> JUL-08-11 08:53 AM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21  </th>\n",
        "      <td> 06/10/11</td>\n",
        "      <td>  NASSAU COUNTY CONSERVATIVE COMMITTEE;1 SYDNEY ST</td>\n",
        "      <td>     PLAINVIEW</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11803</td>\n",
        "      <td> 1567</td>\n",
        "      <td>    200</td>\n",
        "      <td> JUL-08-11 09:57 AM</td>\n",
        "      <td> C</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22  </th>\n",
        "      <td> 02/16/99</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;36 SUNRIS...</td>\n",
        "      <td>     PLAINVIEW</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11803</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>    200</td>\n",
        "      <td> JUN-10-99 06:06 PM</td>\n",
        "      <td> C</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23  </th>\n",
        "      <td> 02/12/03</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOB O...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1802</td>\n",
        "      <td>  $ 200</td>\n",
        "      <td> JUN-19-03 03:38 PM</td>\n",
        "      <td> C</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24  </th>\n",
        "      <td> 04/26/05</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOB O...</td>\n",
        "      <td>    LEVITTOWN </td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1976</td>\n",
        "      <td>    200</td>\n",
        "      <td> JUL-11-05 02:19 PM</td>\n",
        "      <td> C</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25  </th>\n",
        "      <td> 02/09/06</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 2034</td>\n",
        "      <td>    200</td>\n",
        "      <td> JUN-27-06 12:47 PM</td>\n",
        "      <td> C</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26  </th>\n",
        "      <td> 05/10/07</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1602</td>\n",
        "      <td>    200</td>\n",
        "      <td> JUL-05-07 05:26 PM</td>\n",
        "      <td> C</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27  </th>\n",
        "      <td> 02/09/99</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;36 SUNRIS...</td>\n",
        "      <td>     PLAINVIEW</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11803</td>\n",
        "      <td> 1253</td>\n",
        "      <td>    250</td>\n",
        "      <td> JUL-07-99 10:35 AM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28  </th>\n",
        "      <td> 04/27/00</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;36 SUNRIS...</td>\n",
        "      <td>     PLAINVIEW</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11803</td>\n",
        "      <td> 1364</td>\n",
        "      <td>    300</td>\n",
        "      <td> JUL-10-00 03:22 PM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29  </th>\n",
        "      <td> 01/24/02</td>\n",
        "      <td> NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...</td>\n",
        "      <td>     LEVITTOWN</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11756</td>\n",
        "      <td> 1551</td>\n",
        "      <td>    400</td>\n",
        "      <td> JUL-03-02 10:00 AM</td>\n",
        "      <td> C</td>\n",
        "      <td>        SOA</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>3251</th>\n",
        "      <td> 09/06/06</td>\n",
        "      <td> TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 2333</td>\n",
        "      <td>    300</td>\n",
        "      <td> SEP-21-06 04:36 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3252</th>\n",
        "      <td> 03/19/07</td>\n",
        "      <td> TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 2389</td>\n",
        "      <td>    250</td>\n",
        "      <td> JUL-16-07 05:32 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3253</th>\n",
        "      <td> 03/20/08</td>\n",
        "      <td> TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 2503</td>\n",
        "      <td>    250</td>\n",
        "      <td> JUL-15-08 02:52 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3254</th>\n",
        "      <td> 07/08/09</td>\n",
        "      <td> TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 2676</td>\n",
        "      <td>    150</td>\n",
        "      <td> JUL-13-09 05:15 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3255</th>\n",
        "      <td> 07/06/11</td>\n",
        "      <td> TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 2883</td>\n",
        "      <td>    300</td>\n",
        "      <td> JUL-11-11 03:52 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3256</th>\n",
        "      <td> 04/06/10</td>\n",
        "      <td> TOWN OF N. HEMPSTEAD REPUBLICAN COMM;164 POST ...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 1424</td>\n",
        "      <td>    625</td>\n",
        "      <td> JUL-15-10 10:51 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3257</th>\n",
        "      <td> 10/19/01</td>\n",
        "      <td> TOWN OF N. HEMPSTEAD REPUBLICAN COMMITTEE;164 ...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 1812</td>\n",
        "      <td>    400</td>\n",
        "      <td> NOV-28-01 02:20 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3258</th>\n",
        "      <td> 06/01/00</td>\n",
        "      <td> TOWN OF N. HEMPSTEAD REPUBLICAN COMMITTEE;164 ...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 1375</td>\n",
        "      <td>   1550</td>\n",
        "      <td> JUL-10-00 03:44 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3259</th>\n",
        "      <td> 07/16/10</td>\n",
        "      <td> TOWN OF NORTH HEMPSTEAD REPUBLICAN COMMITTEE;1...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 1205</td>\n",
        "      <td>    550</td>\n",
        "      <td> AUG-11-10 02:13 PM</td>\n",
        "      <td> R</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3260</th>\n",
        "      <td> 10/01/10</td>\n",
        "      <td> TOWN OF OYSTER BAY REPUBLICAN COMMITTEE;164 PO...</td>\n",
        "      <td>      WESTBURY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11590</td>\n",
        "      <td> 1486</td>\n",
        "      <td> $ 1200</td>\n",
        "      <td> OCT-22-10 11:33 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3261</th>\n",
        "      <td> 04/05/02</td>\n",
        "      <td>          TRUNZO CAMPAIGN FUND;105 WASHINGTON AVE.</td>\n",
        "      <td>   BRENTWOOD  </td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11717</td>\n",
        "      <td> 1847</td>\n",
        "      <td>    350</td>\n",
        "      <td> JUL-15-02 10:28 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3262</th>\n",
        "      <td> 09/26/05</td>\n",
        "      <td> VALLEY STREAM REPUBLICAN CLUB;362 PICCADILLY POND</td>\n",
        "      <td>    LYNBROOK  </td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11563</td>\n",
        "      <td> 2184</td>\n",
        "      <td>    250</td>\n",
        "      <td> OCT-07-05 03:13 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3263</th>\n",
        "      <td> 09/14/09</td>\n",
        "      <td> VALLEY STREAM REPUBLICAN COMM;362 PICCADILLY D...</td>\n",
        "      <td>      LYNBROOK</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11563</td>\n",
        "      <td> 1320</td>\n",
        "      <td>    400</td>\n",
        "      <td> SEP-30-09 12:54 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3264</th>\n",
        "      <td> 10/15/09</td>\n",
        "      <td> VALLEY STREAM REPUBLICAN COMM;362 PICCADILLY D...</td>\n",
        "      <td>      LYNBROOK</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11563</td>\n",
        "      <td> 1338</td>\n",
        "      <td>   2000</td>\n",
        "      <td> OCT-21-09 09:46 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3265</th>\n",
        "      <td> 07/19/11</td>\n",
        "      <td> VALLEY STREAM REPUBLICAN COMM;362 PICCADILLY D...</td>\n",
        "      <td>      LYNBROOK</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11563</td>\n",
        "      <td> 1582</td>\n",
        "      <td>   1000</td>\n",
        "      <td> OCT-03-11 02:26 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3266</th>\n",
        "      <td> 09/06/07</td>\n",
        "      <td> VALLEY STREAM REPUBLICAN COMMITTEE;362 PICCADI...</td>\n",
        "      <td>      LYNBROOK</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11563</td>\n",
        "      <td> 1056</td>\n",
        "      <td>    225</td>\n",
        "      <td> OCT-05-07 12:55 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3267</th>\n",
        "      <td> 09/01/10</td>\n",
        "      <td> VALLEY STREAM REPUBLICAN COMMITTEE;362 PICCADI...</td>\n",
        "      <td>    LYNBROOK  </td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11563</td>\n",
        "      <td> 1472</td>\n",
        "      <td>    400</td>\n",
        "      <td> SEP-30-10 11:01 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3268</th>\n",
        "      <td> 03/02/01</td>\n",
        "      <td>              VOLKER CAMPAIGN COMMITTEE;PO BOX 494</td>\n",
        "      <td>   LANCASTER  </td>\n",
        "      <td>   NY</td>\n",
        "      <td> 14086</td>\n",
        "      <td> 1747</td>\n",
        "      <td>  $ 300</td>\n",
        "      <td> JUL-13-01 03:09 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3269</th>\n",
        "      <td> 08/27/99</td>\n",
        "      <td>                    WANTAGH GOP;775 WANTAGH AVENUE</td>\n",
        "      <td>       WANTAGH</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11793</td>\n",
        "      <td> 1309</td>\n",
        "      <td>  $ 100</td>\n",
        "      <td> AUG-31-99 05:04 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3270</th>\n",
        "      <td> 07/14/01</td>\n",
        "      <td>                       WANTAGH GOP;75 WANTAGH  AVE</td>\n",
        "      <td>       WANTAGH</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11793</td>\n",
        "      <td> 1497</td>\n",
        "      <td>    700</td>\n",
        "      <td> AUG-09-01 10:01 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3271</th>\n",
        "      <td> 08/03/99</td>\n",
        "      <td> WANTAGH REPUBLICAN COMMITTEE;2196 BROOKSIDE AV...</td>\n",
        "      <td>       WANTAGH</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11793</td>\n",
        "      <td> 1305</td>\n",
        "      <td>    550</td>\n",
        "      <td> AUG-11-99 07:35 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3272</th>\n",
        "      <td> 08/25/10</td>\n",
        "      <td>         WOODMERE REPUBLICAN CLUB;36 CENTER STREET</td>\n",
        "      <td>      WOODMERE</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11598</td>\n",
        "      <td> 1210</td>\n",
        "      <td>    200</td>\n",
        "      <td> AUG-31-10 06:09 PM</td>\n",
        "      <td> R</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3273</th>\n",
        "      <td> 03/14/11</td>\n",
        "      <td>                      ZELDIN FOR SENATE;PO BOX 628</td>\n",
        "      <td>       SHIRLEY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11967</td>\n",
        "      <td> 1526</td>\n",
        "      <td>    500</td>\n",
        "      <td> JUL-07-11 04:12 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3274</th>\n",
        "      <td> 06/06/11</td>\n",
        "      <td>                      ZELDIN FOR SENATE;PO BOX 628</td>\n",
        "      <td>       SHIRLEY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11967</td>\n",
        "      <td> 1560</td>\n",
        "      <td>    250</td>\n",
        "      <td> JUL-08-11 09:01 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3275</th>\n",
        "      <td> 01/09/12</td>\n",
        "      <td>                      ZELDIN FOR SENATE;PO BOX 628</td>\n",
        "      <td>       SHIRLEY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11967</td>\n",
        "      <td> 1618</td>\n",
        "      <td>    500</td>\n",
        "      <td> JAN-16-12 12:00 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3276</th>\n",
        "      <td> 01/11/12</td>\n",
        "      <td>                      ZELDIN FOR SENATE;PO BOX 628</td>\n",
        "      <td>     SHIRLEY  </td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11967</td>\n",
        "      <td> 1621</td>\n",
        "      <td>    500</td>\n",
        "      <td> JAN-16-12 12:00 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3277</th>\n",
        "      <td> 01/09/12</td>\n",
        "      <td>              ZELDIN FOR SENATE;47 FLINTLOCK DRIVE</td>\n",
        "      <td>       SHIRLEY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11967</td>\n",
        "      <td> 1326</td>\n",
        "      <td>    500</td>\n",
        "      <td> JAN-16-12 12:00 AM</td>\n",
        "      <td> R</td>\n",
        "      <td> DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3278</th>\n",
        "      <td> 06/06/11</td>\n",
        "      <td>                      ZELDIN FOR SENATE;PO BOX 628</td>\n",
        "      <td>       SHIRLEY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11967</td>\n",
        "      <td> 2872</td>\n",
        "      <td>    250</td>\n",
        "      <td> JUL-11-11 03:37 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3279</th>\n",
        "      <td> 01/09/12</td>\n",
        "      <td>                      ZELDIN FOR SENATE;PO BOX 628</td>\n",
        "      <td>       SHIRLEY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11967</td>\n",
        "      <td> 2916</td>\n",
        "      <td>    500</td>\n",
        "      <td> JAN-12-12 12:00 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>        SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3280</th>\n",
        "      <td> 06/30/09</td>\n",
        "      <td>                                   ;235 CARMEN AVE</td>\n",
        "      <td> EAST ROCKAWAY</td>\n",
        "      <td>   NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 1290</td>\n",
        "      <td>  $ 600</td>\n",
        "      <td> JUL-08-09 02:59 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>        PBA</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>3281 rows \u00d7 10 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 52,
       "text": [
        "          DATE                         NAME OF INITIATIVE/ADDRESS  \\\n",
        "0     02/21/02         BRONX CONSERVATIVE COMM;415 MINNIEFORD AVE   \n",
        "1     02/23/09       BRONX CONSERVATIVE COMM.;188D EDGEWATER PARK   \n",
        "2     03/01/00    BRONX CONSERVATIVE COMMITTEE;475 MINNEFORD AVE.   \n",
        "3     03/04/03    BRONX CONSERVATIVE COMMITTEE;188 EDGEWATER PARK   \n",
        "4     03/18/04    BRONX CONSERVATIVE COMMITTEE;188D EDGEMERE PARK   \n",
        "5     03/01/05   BRONX CONSERVATIVE COMMITTEE;1880 EDGEWATER PARK   \n",
        "6     02/26/07    BRONX CONSERVATIVE COMMITTEE;188D EDGEMERE PARK   \n",
        "7     03/20/08    BRONX CONSERVATIVE COMMITTEE;188D EDGEMERE PARK   \n",
        "8     05/25/04  NASSAU  COUNTY CONSERVATIVE COMMITTEE;105 BOBO...   \n",
        "9     01/20/09  NASSAU CO. CONSERVATIVE COMMITTEE;105 BOBOLINK LA   \n",
        "10    04/30/09   NASSAU CO. CONSERVATIVE COMMITTEE;105 BOBLINK LA   \n",
        "11    02/15/05    NASSAU CO. CONSERVATIVE PARTY;105 BOBOLINK LANE   \n",
        "12    04/14/11          NASSAU CO. CONSERVATIVE PARTY;1 SYDNEY ST   \n",
        "13    05/28/02  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "14    05/23/03  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "15    05/23/03  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "16    06/01/04  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBLI...   \n",
        "17    05/05/06  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "18    02/13/09  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "19    04/10/09  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "20    05/05/11  NASSAU COUNTY CONSERVATIVE COMMITTEE;1 SYDNEY ...   \n",
        "21    06/10/11   NASSAU COUNTY CONSERVATIVE COMMITTEE;1 SYDNEY ST   \n",
        "22    02/16/99  NASSAU COUNTY CONSERVATIVE COMMITTEE;36 SUNRIS...   \n",
        "23    02/12/03  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOB O...   \n",
        "24    04/26/05  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOB O...   \n",
        "25    02/09/06  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "26    05/10/07  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "27    02/09/99  NASSAU COUNTY CONSERVATIVE COMMITTEE;36 SUNRIS...   \n",
        "28    04/27/00  NASSAU COUNTY CONSERVATIVE COMMITTEE;36 SUNRIS...   \n",
        "29    01/24/02  NASSAU COUNTY CONSERVATIVE COMMITTEE;105 BOBOL...   \n",
        "...        ...                                                ...   \n",
        "3251  09/06/06  TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...   \n",
        "3252  03/19/07  TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...   \n",
        "3253  03/20/08  TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...   \n",
        "3254  07/08/09  TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...   \n",
        "3255  07/06/11  TOWN OF HEMPSTEAD REPUBLICAN COMMITTEE;164 POS...   \n",
        "3256  04/06/10  TOWN OF N. HEMPSTEAD REPUBLICAN COMM;164 POST ...   \n",
        "3257  10/19/01  TOWN OF N. HEMPSTEAD REPUBLICAN COMMITTEE;164 ...   \n",
        "3258  06/01/00  TOWN OF N. HEMPSTEAD REPUBLICAN COMMITTEE;164 ...   \n",
        "3259  07/16/10  TOWN OF NORTH HEMPSTEAD REPUBLICAN COMMITTEE;1...   \n",
        "3260  10/01/10  TOWN OF OYSTER BAY REPUBLICAN COMMITTEE;164 PO...   \n",
        "3261  04/05/02           TRUNZO CAMPAIGN FUND;105 WASHINGTON AVE.   \n",
        "3262  09/26/05  VALLEY STREAM REPUBLICAN CLUB;362 PICCADILLY POND   \n",
        "3263  09/14/09  VALLEY STREAM REPUBLICAN COMM;362 PICCADILLY D...   \n",
        "3264  10/15/09  VALLEY STREAM REPUBLICAN COMM;362 PICCADILLY D...   \n",
        "3265  07/19/11  VALLEY STREAM REPUBLICAN COMM;362 PICCADILLY D...   \n",
        "3266  09/06/07  VALLEY STREAM REPUBLICAN COMMITTEE;362 PICCADI...   \n",
        "3267  09/01/10  VALLEY STREAM REPUBLICAN COMMITTEE;362 PICCADI...   \n",
        "3268  03/02/01               VOLKER CAMPAIGN COMMITTEE;PO BOX 494   \n",
        "3269  08/27/99                     WANTAGH GOP;775 WANTAGH AVENUE   \n",
        "3270  07/14/01                        WANTAGH GOP;75 WANTAGH  AVE   \n",
        "3271  08/03/99  WANTAGH REPUBLICAN COMMITTEE;2196 BROOKSIDE AV...   \n",
        "3272  08/25/10          WOODMERE REPUBLICAN CLUB;36 CENTER STREET   \n",
        "3273  03/14/11                       ZELDIN FOR SENATE;PO BOX 628   \n",
        "3274  06/06/11                       ZELDIN FOR SENATE;PO BOX 628   \n",
        "3275  01/09/12                       ZELDIN FOR SENATE;PO BOX 628   \n",
        "3276  01/11/12                       ZELDIN FOR SENATE;PO BOX 628   \n",
        "3277  01/09/12               ZELDIN FOR SENATE;47 FLINTLOCK DRIVE   \n",
        "3278  06/06/11                       ZELDIN FOR SENATE;PO BOX 628   \n",
        "3279  01/09/12                       ZELDIN FOR SENATE;PO BOX 628   \n",
        "3280  06/30/09                                    ;235 CARMEN AVE   \n",
        "\n",
        "               City State  Zip Code  CHECK NO. AMOUNT ($ )  \\\n",
        "0             BRONX  N.Y.     10458       1562       $ 140   \n",
        "1             BRONX    NY     10465       2628         100   \n",
        "2             BRONX    NY     10464       1346         405   \n",
        "3             BRONX    NY     10465       1727         100   \n",
        "4             BRONX    NY     10465       1869         100   \n",
        "5             BRONX    NY     10465       1975         100   \n",
        "6             BRONX    NY     10465       2371         100   \n",
        "7             BRONX    NY     10465       2504         100   \n",
        "8         LEVITTOWN    NY     11756       1902         200   \n",
        "9         LEVITTOWN    NY     11756       2603         200   \n",
        "10        LEVITTOWN    NY     11756       2646         250   \n",
        "11        LEVITTOWN    NY     11756       1968         120   \n",
        "12        PLAINVIEW    NY     11803       2854       $ 200   \n",
        "13        LEVITTOWN  N.Y.     11756       1858       $ 300   \n",
        "14        LEVITTOWN    NY     11756       1953        2000   \n",
        "15        LEVITTOWN    NY     11756       1954         300   \n",
        "16        LEVITTOWN    NY     11756       2032      $ 3500   \n",
        "17        LEVITTOWN    NY     11756       2238         400   \n",
        "18        LEVITTOWN    NY     11756       1236         400   \n",
        "19        LEVITTOWN    NY     11756       1263        1500   \n",
        "20        PLAINVIEW    NY     11803       1548         100   \n",
        "21        PLAINVIEW    NY     11803       1567         200   \n",
        "22        PLAINVIEW    NY     11803        NaN         200   \n",
        "23        LEVITTOWN    NY     11756       1802       $ 200   \n",
        "24       LEVITTOWN     NY     11756       1976         200   \n",
        "25        LEVITTOWN    NY     11756       2034         200   \n",
        "26        LEVITTOWN    NY     11756       1602         200   \n",
        "27        PLAINVIEW    NY     11803       1253         250   \n",
        "28        PLAINVIEW    NY     11803       1364         300   \n",
        "29        LEVITTOWN    NY     11756       1551         400   \n",
        "...             ...   ...       ...        ...         ...   \n",
        "3251       WESTBURY    NY     11590       2333         300   \n",
        "3252       WESTBURY    NY     11590       2389         250   \n",
        "3253       WESTBURY    NY     11590       2503         250   \n",
        "3254       WESTBURY    NY     11590       2676         150   \n",
        "3255       WESTBURY    NY     11590       2883         300   \n",
        "3256       WESTBURY    NY     11590       1424         625   \n",
        "3257       WESTBURY    NY     11590       1812         400   \n",
        "3258       WESTBURY    NY     11590       1375        1550   \n",
        "3259       WESTBURY    NY     11590       1205         550   \n",
        "3260       WESTBURY    NY     11590       1486      $ 1200   \n",
        "3261    BRENTWOOD      NY     11717       1847         350   \n",
        "3262     LYNBROOK      NY     11563       2184         250   \n",
        "3263       LYNBROOK    NY     11563       1320         400   \n",
        "3264       LYNBROOK    NY     11563       1338        2000   \n",
        "3265       LYNBROOK    NY     11563       1582        1000   \n",
        "3266       LYNBROOK    NY     11563       1056         225   \n",
        "3267     LYNBROOK      NY     11563       1472         400   \n",
        "3268    LANCASTER      NY     14086       1747       $ 300   \n",
        "3269        WANTAGH    NY     11793       1309       $ 100   \n",
        "3270        WANTAGH    NY     11793       1497         700   \n",
        "3271        WANTAGH    NY     11793       1305         550   \n",
        "3272       WOODMERE    NY     11598       1210         200   \n",
        "3273        SHIRLEY    NY     11967       1526         500   \n",
        "3274        SHIRLEY    NY     11967       1560         250   \n",
        "3275        SHIRLEY    NY     11967       1618         500   \n",
        "3276      SHIRLEY      NY     11967       1621         500   \n",
        "3277        SHIRLEY    NY     11967       1326         500   \n",
        "3278        SHIRLEY    NY     11967       2872         250   \n",
        "3279        SHIRLEY    NY     11967       2916         500   \n",
        "3280  EAST ROCKAWAY    NY     11518       1290       $ 600   \n",
        "\n",
        "             RECORD DATE Party      Source  \n",
        "0     JUL-03-02 10:16 AM     C         SOA  \n",
        "1     JUL-13-09 04:13 PM     C         SOA  \n",
        "2     JUL-10-00 02:50 PM     C         SOA  \n",
        "3     JUL-14-03 02:41 PM     C         SOA  \n",
        "4     JUL-14-04 01:09 PM     C         SOA  \n",
        "5     JUL-13-05 03:48 PM     C         SOA  \n",
        "6     JUL-16-07 05:32 PM     C         SOA  \n",
        "7     JUL-15-08 02:53 PM     C         SOA  \n",
        "8     JUL-14-04 02:08 PM     C  DETECTIVES  \n",
        "9     JUL-13-09 03:51 PM     C         SOA  \n",
        "10    JUL-13-09 04:42 PM     C         SOA  \n",
        "11    JUL-13-05 03:34 PM     C         SOA  \n",
        "12    JUL-11-11 03:19 PM     C         SOA  \n",
        "13    JUL-15-02 10:36 AM     C         PBA  \n",
        "14    JUL-11-03 02:42 PM     C         PBA  \n",
        "15    JUL-11-03 02:43 PM     C         PBA  \n",
        "16    JUL-15-04 12:08 PM     C         PBA  \n",
        "17    JUN-16-06 09:09 AM     C         PBA  \n",
        "18    JUL-08-09 01:26 PM     C         PBA  \n",
        "19    JUL-08-09 02:27 PM     C         PBA  \n",
        "20    JUL-08-11 08:53 AM     C         PBA  \n",
        "21    JUL-08-11 09:57 AM     C         PBA  \n",
        "22    JUN-10-99 06:06 PM     C  DETECTIVES  \n",
        "23    JUN-19-03 03:38 PM     C  DETECTIVES  \n",
        "24    JUL-11-05 02:19 PM     C  DETECTIVES  \n",
        "25    JUN-27-06 12:47 PM     C  DETECTIVES  \n",
        "26    JUL-05-07 05:26 PM     C  DETECTIVES  \n",
        "27    JUL-07-99 10:35 AM     C         SOA  \n",
        "28    JUL-10-00 03:22 PM     C         SOA  \n",
        "29    JUL-03-02 10:00 AM     C         SOA  \n",
        "...                  ...   ...         ...  \n",
        "3251  SEP-21-06 04:36 PM     R         SOA  \n",
        "3252  JUL-16-07 05:32 PM     R         SOA  \n",
        "3253  JUL-15-08 02:52 PM     R         SOA  \n",
        "3254  JUL-13-09 05:15 PM     R         SOA  \n",
        "3255  JUL-11-11 03:52 PM     R         SOA  \n",
        "3256  JUL-15-10 10:51 AM     R         PBA  \n",
        "3257  NOV-28-01 02:20 PM     R         PBA  \n",
        "3258  JUL-10-00 03:44 PM     R         SOA  \n",
        "3259  AUG-11-10 02:13 PM     R  DETECTIVES  \n",
        "3260  OCT-22-10 11:33 AM     R         PBA  \n",
        "3261  JUL-15-02 10:28 AM     R         PBA  \n",
        "3262  OCT-07-05 03:13 PM     R         PBA  \n",
        "3263  SEP-30-09 12:54 PM     R         PBA  \n",
        "3264  OCT-21-09 09:46 AM     R         PBA  \n",
        "3265  OCT-03-11 02:26 PM     R         PBA  \n",
        "3266  OCT-05-07 12:55 PM     R         PBA  \n",
        "3267  SEP-30-10 11:01 AM     R         PBA  \n",
        "3268  JUL-13-01 03:09 PM     R         PBA  \n",
        "3269  AUG-31-99 05:04 PM     R         SOA  \n",
        "3270  AUG-09-01 10:01 PM     R         SOA  \n",
        "3271  AUG-11-99 07:35 PM     R         SOA  \n",
        "3272  AUG-31-10 06:09 PM     R  DETECTIVES  \n",
        "3273  JUL-07-11 04:12 PM     R         PBA  \n",
        "3274  JUL-08-11 09:01 AM     R         PBA  \n",
        "3275  JAN-16-12 12:00 AM     R         PBA  \n",
        "3276  JAN-16-12 12:00 AM     R         PBA  \n",
        "3277  JAN-16-12 12:00 AM     R  DETECTIVES  \n",
        "3278  JUL-11-11 03:37 PM     R         SOA  \n",
        "3279  JAN-12-12 12:00 AM     R         SOA  \n",
        "3280  JUL-08-09 02:59 PM     R         PBA  \n",
        "\n",
        "[3281 rows x 10 columns]"
       ]
      }
     ],
     "prompt_number": 52
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Looking at the data, we can tell it has all kinds of problems. \n",
      "\n",
      "For the remainder of this breakout, we focused on trying to get the City column into better shape.\n",
      "\n",
      "To look at only the `City` column using IPython magic, we can type:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df['City']"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 54,
       "text": [
        "0           BRONX\n",
        "1           BRONX\n",
        "2           BRONX\n",
        "3           BRONX\n",
        "4           BRONX\n",
        "5           BRONX\n",
        "6           BRONX\n",
        "7           BRONX\n",
        "8       LEVITTOWN\n",
        "9       LEVITTOWN\n",
        "10      LEVITTOWN\n",
        "11      LEVITTOWN\n",
        "12      PLAINVIEW\n",
        "13      LEVITTOWN\n",
        "14      LEVITTOWN\n",
        "...\n",
        "3266         LYNBROOK\n",
        "3267       LYNBROOK  \n",
        "3268      LANCASTER  \n",
        "3269          WANTAGH\n",
        "3270          WANTAGH\n",
        "3271          WANTAGH\n",
        "3272         WOODMERE\n",
        "3273          SHIRLEY\n",
        "3274          SHIRLEY\n",
        "3275          SHIRLEY\n",
        "3276        SHIRLEY  \n",
        "3277          SHIRLEY\n",
        "3278          SHIRLEY\n",
        "3279          SHIRLEY\n",
        "3280    EAST ROCKAWAY\n",
        "Name: City, Length: 3281, dtype: object"
       ]
      }
     ],
     "prompt_number": 54
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "This still doesn't give us a great idea of how big a mess we have, so let's see how many unique names exist and sort them by name:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cities = df['City'].unique()\n",
      "cities.sort()\n",
      "cities"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 58,
       "text": [
        "array([nan, u'   MASSAPEQUA', u'   WANTAGH', u'  ALBANY', u'  BALDWIN',\n",
        "       u'  BRONX', u'  BROOKLYN', u'  COHOES', u'  GREAT NECK',\n",
        "       u'  HEMPSTEAD', u'  HUNTINGTON', u'  JEFFERSON VALLEY',\n",
        "       u'  LEVITTOWN', u'  LEVITTOWN ', u'  MERRICK', u'  MIDDLE VILLAGE',\n",
        "       u'  STATEN ISLAND', u'  WANTAGH', u'  WESTBURY',\n",
        "       u'  WILLISTON PARK', u'  WOODMERE', u' ALBANY', u' BALDWIN',\n",
        "       u' BROOKLYN', u' CARMEL', u' EAST NASSAU', u' GARDEN   CITY',\n",
        "       u' GARDEN CITY', u' GREAT   NECK', u' GREAT NECK', u' HUNTINGTON',\n",
        "       u' JERICHO', u' LIDO BEACH', u' LYNBROOK', u' MASSAPEQUA',\n",
        "       u' MASSAPEQUA  PARK', u' MERRICK', u' MINEOLA', u' PLAINVIEW',\n",
        "       u' ROSLYN', u' SHIRLEY', u' SOUTHOLD', u' STATEN ISLAND',\n",
        "       u' STATEN ISLAND  ', u' WEST ISLIP', u' WESTBURY', u' WOODBURY',\n",
        "       u'ALBANI', u'ALBANNY', u'ALBANY', u'ALBANY ', u'ALBANY  ',\n",
        "       u'ALBANY    ', u'ALBERTSON', u'ALBION', u'AMITYVILLE', u'AUBURN',\n",
        "       u'BABYLON', u'BALDWIN', u'BALWIN', u'BARDONIA', u'BAYPORT',\n",
        "       u'BAYVILLE', u'BELLEMORE', u'BELLEROSE', u'BELLMORE', u'BETHPAGE',\n",
        "       u'BOHEMIA', u'BRENTWOOD', u'BRENTWOOD  ', u'BREWSTER',\n",
        "       u'BRIDGEPORT', u'BROCKPORT', u'BRONX', u'BROOKLYN', u'BROOKLYN ',\n",
        "       u'BROOKLYN  ', u'BROOKYN', u'CANADAIGUA', u'CANANDAIGUA',\n",
        "       u'CANANDALGUA', u'CAPITAL STATION', u'CARL PLACE', u'CARLE PLACE',\n",
        "       u'CARMEL', u'CIRCLEVILLE', u'COHOES', u'COHOES  ', u'COMMACK',\n",
        "       u'COOPERSTOWN', u'CORONA', u'CROTON-ON-HUDO', u'E ISLIP',\n",
        "       u'E. GREENBUSH', u'E. ISLIP', u'E. MEADOW', u'E. NORTHPORT',\n",
        "       u'E. NORWICH', u'E. ROCHESTER', u'E. ROCKAWAY', u'E. SETAUKET',\n",
        "       u'E. WILLISTON', u'EAST', u'EAST GREENBUSH', u'EAST ISLIP',\n",
        "       u'EAST MEADOW', u'EAST NORTHPOND', u'EAST NORTHPORT',\n",
        "       u'EAST NORWICH', u'EAST ROCKAWAY', u'EAST SETAUKET', u'ELMIRA',\n",
        "       u'ELMONT', u'FARMINGDALE', u'FARMINGVILLE', u'FRANKLIN',\n",
        "       u'FRANKLIN SQUARE', u'FREEPORT', u'FREEPORT ', u'FRESH MEADOW',\n",
        "       u'FT HAMILTON STATE', u'GARDEN CITY', u'GARDEN CITY ',\n",
        "       u'GARDEN CITY PARK', u'GLEN COVE', u'GOSHEN', u'GREAT   NECK',\n",
        "       u'GREAT  NECK', u'GREAT NECK', u'GREAT NECK  ', u'HAMPTON',\n",
        "       u'HAPPAGUE', u'HAPPAUGE', u'HAUPPAUGE', u'HAUPPAUSE', u'HEMPSTEAD',\n",
        "       u'HEWLETT', u'HICKSVILLE', u'HOLBROOK', u'HUNTINGTON',\n",
        "       u'HUNTINGTON ', u'HUNTINGTON   STATION', u'HUNTINGTON STAT',\n",
        "       u'HUNTINGTON STATION', u'HUNTINGTONST', u'IRVINGTON-ON-HU',\n",
        "       u'ISLAND PARK', u'ISLIP', u'JAMAICA ESTATES', u'JEFFERSON',\n",
        "       u'JEFFERSON   VALLEY', u'JEFFERSON  VALLEY', u'JEFFERSON VALLE',\n",
        "       u'JEFFERSON VALLEY', u'JERICHO', u'KINDERHOOK', u'LANCASTER',\n",
        "       u'LANCASTER  ', u'LAWRENCE', u'LEVITOWN', u'LEVITTOWN',\n",
        "       u'LEVITTOWN ', u'LEVITTSTOWN', u'LINDENHURST', u'LINDENHURST  ',\n",
        "       u'LOCUST  VALLEY', u'LOCUST VALLEY', u'LONG  BEACH', u'LONG BEACH',\n",
        "       u'LONGBEACH', u'LYNBROOK', u'LYNBROOK ', u'LYNBROOK  ', u'MALVERNE',\n",
        "       u'MANORVILLE', u'MASSAPEAQUA', u'MASSAPEQUA', u'MASSAPEQUA ',\n",
        "       u'MASSAPEQUA  ', u'MASSAPEQUA PARK', u'MASTIC', u'MEDFORD',\n",
        "       u'MELVILLE', u'MERCERVILLE', u'MERICK', u'MERRICK',\n",
        "       u'MIDDLE   VILLAGE', u'MIDDLE VILLAGE', u'MILL NECK', u'MINEOLA',\n",
        "       u'MINEOLA  ', u'MT. SINAI', u'N MERRICK', u'N VALLEY',\n",
        "       u'N VALLEY STREAM', u'N. BABYLON', u'N. BALDWIN', u'N. MASSAPEQUA',\n",
        "       u'N. MERRICK', u'N. VALLEY', u'N. VALLEY STREAM', u'N.MASSAPEQUA',\n",
        "       u'N.MASSAPEQUA ', u'N.VALLEY STREAM', u'NANUET', u'NESCONSET',\n",
        "       u'NEW   YORK', u'NEW  YORK', u'NEW BALTIMORE', u'NEW HAMPTON',\n",
        "       u'NEW HYDE PARK', u'NEW HYDE PK', u'NEW ROCHELLE', u'NEW YORK',\n",
        "       u'NEW YORK ', u'NIAGARA FALLS', u'NO. BALDWIN', u'NO. MASSAPEQUA',\n",
        "       u'NO. MERRICK', u'NO. VALLEY STREAM', u'NO.VALLEY STREAM',\n",
        "       u'NORHTPORT', u'NORTH MASSAPEQUA', u'NORTH MERRICK',\n",
        "       u'NORTH VALLEY', u'NORTH VALLEY STREAM', u'NORTHPORT', u'NY',\n",
        "       u'NYC', u'OCEANSIDE', u'OLD BETHPAGE', u'OLD BETHPARE',\n",
        "       u'OLD WESTBURY', u'ORISKANY', u'OYSTER BAY', u'PATTERSONVILLE',\n",
        "       u'PENFIELD', u'PLAINVIEW', u'PORT', u'PORT   WASHINGTON',\n",
        "       u'PORT JEFFERSON', u'PORT WASHINGTON', u'POUGHKEEPSIE',\n",
        "       u'PT. LOOKOUT', u'PT. WASHINGTON', u'PT.WASHINGTON', u'RENSSALAER',\n",
        "       u'RENSSELAER', u'RENSSELAU', u'RENSSELEAR', u'RICHMOND HILL',\n",
        "       u'RICHMOND HILLS', u'RIVERHEAD', u'ROCHESTER', u'ROCKEVILLE CENTRE',\n",
        "       u'ROCKILLE CTR', u'ROCKVILLE', u'ROCKVILLE CENTER',\n",
        "       u'ROCKVILLE CENTR', u'ROCKVILLE CENTRE', u'ROCKVILLE CTR',\n",
        "       u'RONKONKOMA', u'ROOSEVELT', u'ROSLYN', u'S.MERRICK',\n",
        "       u'SANDS POINT', u'SARATOGA SPRING', u'SARATOGA SPRING  ',\n",
        "       u'SCHENECTADY', u'SEA CLIFF', u'SEACLIFF', u'SEAFORD', u'SEATAUKET',\n",
        "       u'SETAUKET', u'SHIRLEY', u'SHIRLEY  ', u'SHOREHAM', u'SHOREHARN',\n",
        "       u'SMITHTOWN', u'ST JAMES', u'ST. JAMES', u'STATEN',\n",
        "       u'STATEN  ISLAND', u'STATEN ISLAND', u'STONY POINT', u'SUFFERN',\n",
        "       u'SYOSSET', u'SYRACUSE', u'UNIONDALE', u'UPPER NYACK',\n",
        "       u'VALLEY STREAM', u'W BABYLON', u'W ISLIP', u'W. BABYLON',\n",
        "       u'W. HEMPSTEAD', u'W. ISLIP', u'W.BABYLON', u'WADING RIVER',\n",
        "       u'WANTAGH', u'WASHINGTONVILLE', u'WEST BABLYON', u'WEST BABYLON',\n",
        "       u'WEST BURY', u'WEST ISLIP', u'WEST MERRICK', u'WESTBURY',\n",
        "       u'WESTBURY  ', u'WESTBUTY', u'WESYBURY', u'WHITESTONE',\n",
        "       u'WILLISTIN PK', u'WILLISTON', u'WILLISTON PARK', u'WILLISTON PK',\n",
        "       u'WOODBURY', u'WOODMERE', u'YAPHANK', u'YONKERS'], dtype=object)"
       ]
      }
     ],
     "prompt_number": 58
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Wow, that's... a mess. The most obvious mess is trailing and leading white space. Let's get rid of it with `.strip()`"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cities = df['City'].str.strip().unique()\n",
      "cities.sort()\n",
      "cities"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 70,
       "text": [
        "array([nan, u'ALBANI', u'ALBANNY', u'ALBANY', u'ALBERTSON', u'ALBION',\n",
        "       u'AMITYVILLE', u'AUBURN', u'BABYLON', u'BALDWIN', u'BALWIN',\n",
        "       u'BARDONIA', u'BAYPORT', u'BAYVILLE', u'BELLEMORE', u'BELLEROSE',\n",
        "       u'BELLMORE', u'BETHPAGE', u'BOHEMIA', u'BRENTWOOD', u'BREWSTER',\n",
        "       u'BRIDGEPORT', u'BROCKPORT', u'BRONX', u'BROOKLYN', u'BROOKYN',\n",
        "       u'CANADAIGUA', u'CANANDAIGUA', u'CANANDALGUA', u'CAPITAL STATION',\n",
        "       u'CARL PLACE', u'CARLE PLACE', u'CARMEL', u'CIRCLEVILLE', u'COHOES',\n",
        "       u'COMMACK', u'COOPERSTOWN', u'CORONA', u'CROTON-ON-HUDO',\n",
        "       u'E ISLIP', u'E. GREENBUSH', u'E. ISLIP', u'E. MEADOW',\n",
        "       u'E. NORTHPORT', u'E. NORWICH', u'E. ROCHESTER', u'E. ROCKAWAY',\n",
        "       u'E. SETAUKET', u'E. WILLISTON', u'EAST', u'EAST GREENBUSH',\n",
        "       u'EAST ISLIP', u'EAST MEADOW', u'EAST NASSAU', u'EAST NORTHPOND',\n",
        "       u'EAST NORTHPORT', u'EAST NORWICH', u'EAST ROCKAWAY',\n",
        "       u'EAST SETAUKET', u'ELMIRA', u'ELMONT', u'FARMINGDALE',\n",
        "       u'FARMINGVILLE', u'FRANKLIN', u'FRANKLIN SQUARE', u'FREEPORT',\n",
        "       u'FRESH MEADOW', u'FT HAMILTON STATE', u'GARDEN   CITY',\n",
        "       u'GARDEN CITY', u'GARDEN CITY PARK', u'GLEN COVE', u'GOSHEN',\n",
        "       u'GREAT   NECK', u'GREAT  NECK', u'GREAT NECK', u'HAMPTON',\n",
        "       u'HAPPAGUE', u'HAPPAUGE', u'HAUPPAUGE', u'HAUPPAUSE', u'HEMPSTEAD',\n",
        "       u'HEWLETT', u'HICKSVILLE', u'HOLBROOK', u'HUNTINGTON',\n",
        "       u'HUNTINGTON   STATION', u'HUNTINGTON STAT', u'HUNTINGTON STATION',\n",
        "       u'HUNTINGTONST', u'IRVINGTON-ON-HU', u'ISLAND PARK', u'ISLIP',\n",
        "       u'JAMAICA ESTATES', u'JEFFERSON', u'JEFFERSON   VALLEY',\n",
        "       u'JEFFERSON  VALLEY', u'JEFFERSON VALLE', u'JEFFERSON VALLEY',\n",
        "       u'JERICHO', u'KINDERHOOK', u'LANCASTER', u'LAWRENCE', u'LEVITOWN',\n",
        "       u'LEVITTOWN', u'LEVITTSTOWN', u'LIDO BEACH', u'LINDENHURST',\n",
        "       u'LOCUST  VALLEY', u'LOCUST VALLEY', u'LONG  BEACH', u'LONG BEACH',\n",
        "       u'LONGBEACH', u'LYNBROOK', u'MALVERNE', u'MANORVILLE',\n",
        "       u'MASSAPEAQUA', u'MASSAPEQUA', u'MASSAPEQUA  PARK',\n",
        "       u'MASSAPEQUA PARK', u'MASTIC', u'MEDFORD', u'MELVILLE',\n",
        "       u'MERCERVILLE', u'MERICK', u'MERRICK', u'MIDDLE   VILLAGE',\n",
        "       u'MIDDLE VILLAGE', u'MILL NECK', u'MINEOLA', u'MT. SINAI',\n",
        "       u'N MERRICK', u'N VALLEY', u'N VALLEY STREAM', u'N. BABYLON',\n",
        "       u'N. BALDWIN', u'N. MASSAPEQUA', u'N. MERRICK', u'N. VALLEY',\n",
        "       u'N. VALLEY STREAM', u'N.MASSAPEQUA', u'N.VALLEY STREAM', u'NANUET',\n",
        "       u'NESCONSET', u'NEW   YORK', u'NEW  YORK', u'NEW BALTIMORE',\n",
        "       u'NEW HAMPTON', u'NEW HYDE PARK', u'NEW HYDE PK', u'NEW ROCHELLE',\n",
        "       u'NEW YORK', u'NIAGARA FALLS', u'NO. BALDWIN', u'NO. MASSAPEQUA',\n",
        "       u'NO. MERRICK', u'NO. VALLEY STREAM', u'NO.VALLEY STREAM',\n",
        "       u'NORHTPORT', u'NORTH MASSAPEQUA', u'NORTH MERRICK',\n",
        "       u'NORTH VALLEY', u'NORTH VALLEY STREAM', u'NORTHPORT', u'NY',\n",
        "       u'NYC', u'OCEANSIDE', u'OLD BETHPAGE', u'OLD BETHPARE',\n",
        "       u'OLD WESTBURY', u'ORISKANY', u'OYSTER BAY', u'PATTERSONVILLE',\n",
        "       u'PENFIELD', u'PLAINVIEW', u'PORT', u'PORT   WASHINGTON',\n",
        "       u'PORT JEFFERSON', u'PORT WASHINGTON', u'POUGHKEEPSIE',\n",
        "       u'PT. LOOKOUT', u'PT. WASHINGTON', u'PT.WASHINGTON', u'RENSSALAER',\n",
        "       u'RENSSELAER', u'RENSSELAU', u'RENSSELEAR', u'RICHMOND HILL',\n",
        "       u'RICHMOND HILLS', u'RIVERHEAD', u'ROCHESTER', u'ROCKEVILLE CENTRE',\n",
        "       u'ROCKILLE CTR', u'ROCKVILLE', u'ROCKVILLE CENTER',\n",
        "       u'ROCKVILLE CENTR', u'ROCKVILLE CENTRE', u'ROCKVILLE CTR',\n",
        "       u'RONKONKOMA', u'ROOSEVELT', u'ROSLYN', u'S.MERRICK',\n",
        "       u'SANDS POINT', u'SARATOGA SPRING', u'SCHENECTADY', u'SEA CLIFF',\n",
        "       u'SEACLIFF', u'SEAFORD', u'SEATAUKET', u'SETAUKET', u'SHIRLEY',\n",
        "       u'SHOREHAM', u'SHOREHARN', u'SMITHTOWN', u'SOUTHOLD', u'ST JAMES',\n",
        "       u'ST. JAMES', u'STATEN', u'STATEN  ISLAND', u'STATEN ISLAND',\n",
        "       u'STONY POINT', u'SUFFERN', u'SYOSSET', u'SYRACUSE', u'UNIONDALE',\n",
        "       u'UPPER NYACK', u'VALLEY STREAM', u'W BABYLON', u'W ISLIP',\n",
        "       u'W. BABYLON', u'W. HEMPSTEAD', u'W. ISLIP', u'W.BABYLON',\n",
        "       u'WADING RIVER', u'WANTAGH', u'WASHINGTONVILLE', u'WEST BABLYON',\n",
        "       u'WEST BABYLON', u'WEST BURY', u'WEST ISLIP', u'WEST MERRICK',\n",
        "       u'WESTBURY', u'WESTBUTY', u'WESYBURY', u'WHITESTONE',\n",
        "       u'WILLISTIN PK', u'WILLISTON', u'WILLISTON PARK', u'WILLISTON PK',\n",
        "       u'WOODBURY', u'WOODMERE', u'YAPHANK', u'YONKERS'], dtype=object)"
       ]
      }
     ],
     "prompt_number": 70
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "We can work with this, let's reassign all the `strip`ped values in place:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df['City'] = df['City'].str.strip()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 71
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "First thing the group decided to tackle was standardizing the name \"EAST.\" It currently is \"E \", \"E.\" and \"EAST\" \n",
      "\n",
      "To make the list more manageable, we can find all cells that start with \"E\":"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df[df['City'].str.startswith(\"E\")]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "ename": "ValueError",
       "evalue": "cannot index with vector containing NA / NaN values",
       "output_type": "pyerr",
       "traceback": [
        "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m\n\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
        "\u001b[0;32m<ipython-input-73-3f556c32aa54>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'City'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstartswith\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"E\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
        "\u001b[0;32m/Users/jeramiaory/miniconda/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   1735\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mSeries\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mndarray\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mIndex\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1736\u001b[0m             \u001b[0;31m# either boolean or fancy integer index\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1737\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_array\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1738\u001b[0m         \u001b[0;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mDataFrame\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1739\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_frame\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
        "\u001b[0;32m/Users/jeramiaory/miniconda/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m_getitem_array\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   1762\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_getitem_array\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1763\u001b[0m         \u001b[0;31m# also raises Exception if object array with NA values\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1764\u001b[0;31m         \u001b[0;32mif\u001b[0m \u001b[0mcom\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_is_bool_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1765\u001b[0m             \u001b[0;31m# warning here just in case -- previously __setitem__ was\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1766\u001b[0m             \u001b[0;31m# reindexing but __getitem__ was not; it seems more reasonable to\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
        "\u001b[0;32m/Users/jeramiaory/miniconda/lib/python2.7/site-packages/pandas/core/common.pyc\u001b[0m in \u001b[0;36m_is_bool_indexer\u001b[0;34m(key)\u001b[0m\n\u001b[1;32m   2039\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mlib\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_bool_array\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2040\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0misnull\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0many\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2041\u001b[0;31m                     raise ValueError('cannot index with vector containing '\n\u001b[0m\u001b[1;32m   2042\u001b[0m                                      'NA / NaN values')\n\u001b[1;32m   2043\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mFalse\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
        "\u001b[0;31mValueError\u001b[0m: cannot index with vector containing NA / NaN values"
       ]
      }
     ],
     "prompt_number": 73
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Or... we could, if all of the data was `string` data. Turns out some of it is missing (of course!) \n",
      "\n",
      "The group discussed what to do with the data, and decided they wanted to convert it to the string \"UNKNOWN\"\n",
      "\n",
      "Using the `fillna` command, we can do this in place(ish):"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df['City'] = df['City'].fillna(\"UNKNOWN\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 80
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cities = df['City'].unique()\n",
      "cities.sort()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 81
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cities"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 82,
       "text": [
        "array([u'ALBANI', u'ALBANNY', u'ALBANY', u'ALBERTSON', u'ALBION',\n",
        "       u'AMITYVILLE', u'AUBURN', u'BABYLON', u'BALDWIN', u'BALWIN',\n",
        "       u'BARDONIA', u'BAYPORT', u'BAYVILLE', u'BELLEMORE', u'BELLEROSE',\n",
        "       u'BELLMORE', u'BETHPAGE', u'BOHEMIA', u'BRENTWOOD', u'BREWSTER',\n",
        "       u'BRIDGEPORT', u'BROCKPORT', u'BRONX', u'BROOKLYN', u'BROOKYN',\n",
        "       u'CANADAIGUA', u'CANANDAIGUA', u'CANANDALGUA', u'CAPITAL STATION',\n",
        "       u'CARL PLACE', u'CARLE PLACE', u'CARMEL', u'CIRCLEVILLE', u'COHOES',\n",
        "       u'COMMACK', u'COOPERSTOWN', u'CORONA', u'CROTON-ON-HUDO',\n",
        "       u'E ISLIP', u'E. GREENBUSH', u'E. ISLIP', u'E. MEADOW',\n",
        "       u'E. NORTHPORT', u'E. NORWICH', u'E. ROCHESTER', u'E. ROCKAWAY',\n",
        "       u'E. SETAUKET', u'E. WILLISTON', u'EAST', u'EAST GREENBUSH',\n",
        "       u'EAST ISLIP', u'EAST MEADOW', u'EAST NASSAU', u'EAST NORTHPOND',\n",
        "       u'EAST NORTHPORT', u'EAST NORWICH', u'EAST ROCKAWAY',\n",
        "       u'EAST SETAUKET', u'ELMIRA', u'ELMONT', u'FARMINGDALE',\n",
        "       u'FARMINGVILLE', u'FRANKLIN', u'FRANKLIN SQUARE', u'FREEPORT',\n",
        "       u'FRESH MEADOW', u'FT HAMILTON STATE', u'GARDEN   CITY',\n",
        "       u'GARDEN CITY', u'GARDEN CITY PARK', u'GLEN COVE', u'GOSHEN',\n",
        "       u'GREAT   NECK', u'GREAT  NECK', u'GREAT NECK', u'HAMPTON',\n",
        "       u'HAPPAGUE', u'HAPPAUGE', u'HAUPPAUGE', u'HAUPPAUSE', u'HEMPSTEAD',\n",
        "       u'HEWLETT', u'HICKSVILLE', u'HOLBROOK', u'HUNTINGTON',\n",
        "       u'HUNTINGTON   STATION', u'HUNTINGTON STAT', u'HUNTINGTON STATION',\n",
        "       u'HUNTINGTONST', u'IRVINGTON-ON-HU', u'ISLAND PARK', u'ISLIP',\n",
        "       u'JAMAICA ESTATES', u'JEFFERSON', u'JEFFERSON   VALLEY',\n",
        "       u'JEFFERSON  VALLEY', u'JEFFERSON VALLE', u'JEFFERSON VALLEY',\n",
        "       u'JERICHO', u'KINDERHOOK', u'LANCASTER', u'LAWRENCE', u'LEVITOWN',\n",
        "       u'LEVITTOWN', u'LEVITTSTOWN', u'LIDO BEACH', u'LINDENHURST',\n",
        "       u'LOCUST  VALLEY', u'LOCUST VALLEY', u'LONG  BEACH', u'LONG BEACH',\n",
        "       u'LONGBEACH', u'LYNBROOK', u'MALVERNE', u'MANORVILLE',\n",
        "       u'MASSAPEAQUA', u'MASSAPEQUA', u'MASSAPEQUA  PARK',\n",
        "       u'MASSAPEQUA PARK', u'MASTIC', u'MEDFORD', u'MELVILLE',\n",
        "       u'MERCERVILLE', u'MERICK', u'MERRICK', u'MIDDLE   VILLAGE',\n",
        "       u'MIDDLE VILLAGE', u'MILL NECK', u'MINEOLA', u'MT. SINAI',\n",
        "       u'N MERRICK', u'N VALLEY', u'N VALLEY STREAM', u'N. BABYLON',\n",
        "       u'N. BALDWIN', u'N. MASSAPEQUA', u'N. MERRICK', u'N. VALLEY',\n",
        "       u'N. VALLEY STREAM', u'N.MASSAPEQUA', u'N.VALLEY STREAM', u'NANUET',\n",
        "       u'NESCONSET', u'NEW   YORK', u'NEW  YORK', u'NEW BALTIMORE',\n",
        "       u'NEW HAMPTON', u'NEW HYDE PARK', u'NEW HYDE PK', u'NEW ROCHELLE',\n",
        "       u'NEW YORK', u'NIAGARA FALLS', u'NO. BALDWIN', u'NO. MASSAPEQUA',\n",
        "       u'NO. MERRICK', u'NO. VALLEY STREAM', u'NO.VALLEY STREAM',\n",
        "       u'NORHTPORT', u'NORTH MASSAPEQUA', u'NORTH MERRICK',\n",
        "       u'NORTH VALLEY', u'NORTH VALLEY STREAM', u'NORTHPORT', u'NY',\n",
        "       u'NYC', u'OCEANSIDE', u'OLD BETHPAGE', u'OLD BETHPARE',\n",
        "       u'OLD WESTBURY', u'ORISKANY', u'OYSTER BAY', u'PATTERSONVILLE',\n",
        "       u'PENFIELD', u'PLAINVIEW', u'PORT', u'PORT   WASHINGTON',\n",
        "       u'PORT JEFFERSON', u'PORT WASHINGTON', u'POUGHKEEPSIE',\n",
        "       u'PT. LOOKOUT', u'PT. WASHINGTON', u'PT.WASHINGTON', u'RENSSALAER',\n",
        "       u'RENSSELAER', u'RENSSELAU', u'RENSSELEAR', u'RICHMOND HILL',\n",
        "       u'RICHMOND HILLS', u'RIVERHEAD', u'ROCHESTER', u'ROCKEVILLE CENTRE',\n",
        "       u'ROCKILLE CTR', u'ROCKVILLE', u'ROCKVILLE CENTER',\n",
        "       u'ROCKVILLE CENTR', u'ROCKVILLE CENTRE', u'ROCKVILLE CTR',\n",
        "       u'RONKONKOMA', u'ROOSEVELT', u'ROSLYN', u'S.MERRICK',\n",
        "       u'SANDS POINT', u'SARATOGA SPRING', u'SCHENECTADY', u'SEA CLIFF',\n",
        "       u'SEACLIFF', u'SEAFORD', u'SEATAUKET', u'SETAUKET', u'SHIRLEY',\n",
        "       u'SHOREHAM', u'SHOREHARN', u'SMITHTOWN', u'SOUTHOLD', u'ST JAMES',\n",
        "       u'ST. JAMES', u'STATEN', u'STATEN  ISLAND', u'STATEN ISLAND',\n",
        "       u'STONY POINT', u'SUFFERN', u'SYOSSET', u'SYRACUSE', u'UNIONDALE',\n",
        "       'UNKNOWN', u'UPPER NYACK', u'VALLEY STREAM', u'W BABYLON',\n",
        "       u'W ISLIP', u'W. BABYLON', u'W. HEMPSTEAD', u'W. ISLIP',\n",
        "       u'W.BABYLON', u'WADING RIVER', u'WANTAGH', u'WASHINGTONVILLE',\n",
        "       u'WEST BABLYON', u'WEST BABYLON', u'WEST BURY', u'WEST ISLIP',\n",
        "       u'WEST MERRICK', u'WESTBURY', u'WESTBUTY', u'WESYBURY',\n",
        "       u'WHITESTONE', u'WILLISTIN PK', u'WILLISTON', u'WILLISTON PARK',\n",
        "       u'WILLISTON PK', u'WOODBURY', u'WOODMERE', u'YAPHANK', u'YONKERS'], dtype=object)"
       ]
      }
     ],
     "prompt_number": 82
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Ok, no more `nan`, yay!\n",
      "\n",
      "Let's try that again:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df['City'].str.startswith('E')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 85,
       "text": [
        "0     False\n",
        "1     False\n",
        "2     False\n",
        "3     False\n",
        "4     False\n",
        "5     False\n",
        "6     False\n",
        "7     False\n",
        "8     False\n",
        "9     False\n",
        "10    False\n",
        "11    False\n",
        "12    False\n",
        "13    False\n",
        "14    False\n",
        "...\n",
        "3266    False\n",
        "3267    False\n",
        "3268    False\n",
        "3269    False\n",
        "3270    False\n",
        "3271    False\n",
        "3272    False\n",
        "3273    False\n",
        "3274    False\n",
        "3275    False\n",
        "3276    False\n",
        "3277    False\n",
        "3278    False\n",
        "3279    False\n",
        "3280     True\n",
        "Name: City, Length: 3281, dtype: bool"
       ]
      }
     ],
     "prompt_number": 85
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "We can now select all the rows in our dataframe by feeding the `True`/`False` back into the dataframe:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df[df['City'].str.startswith(\"E\")]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>DATE</th>\n",
        "      <th>NAME OF INITIATIVE/ADDRESS</th>\n",
        "      <th>City</th>\n",
        "      <th>State</th>\n",
        "      <th>Zip Code</th>\n",
        "      <th>CHECK NO.</th>\n",
        "      <th>AMOUNT ($ )</th>\n",
        "      <th>RECORD DATE</th>\n",
        "      <th>Party</th>\n",
        "      <th>Source</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>123 </th>\n",
        "      <td> 04/14/11</td>\n",
        "      <td>             BROOKHAVEN DEMOCRATIC COMM;PO BOX 561</td>\n",
        "      <td>           EAST</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11733</td>\n",
        "      <td> 1538</td>\n",
        "      <td>      500</td>\n",
        "      <td> JUL-07-11 04:21 PM</td>\n",
        "      <td> D</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>362 </th>\n",
        "      <td> 10/03/01</td>\n",
        "      <td>        ENGLEBRIGHT FOR STATE ASSEMBLY;PO BOX 2703</td>\n",
        "      <td>  EAST SETAUKET</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11733</td>\n",
        "      <td> 1523</td>\n",
        "      <td>      250</td>\n",
        "      <td> OCT-23-01 12:08 PM</td>\n",
        "      <td> D</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>363 </th>\n",
        "      <td> 02/09/99</td>\n",
        "      <td>       ENGLEBRITE FOR STATE ASSEMBLY;P.O. BOX 2703</td>\n",
        "      <td>  EAST SETAUKET</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11733</td>\n",
        "      <td> 1250</td>\n",
        "      <td>      200</td>\n",
        "      <td> JUL-07-99 09:05 AM</td>\n",
        "      <td> D</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>390 </th>\n",
        "      <td> 11/07/11</td>\n",
        "      <td>     FRIENDS OF CARRIE SOLAGES;1630 DUTCH BROADWAY</td>\n",
        "      <td>         ELMONT</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11003</td>\n",
        "      <td> 2907</td>\n",
        "      <td>     2000</td>\n",
        "      <td> NOV-29-11 12:00 AM</td>\n",
        "      <td> D</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>484 </th>\n",
        "      <td> 02/12/99</td>\n",
        "      <td>                    FRIENDS OF ENGELBRIGHT;POB 703</td>\n",
        "      <td>    E. SETAUKET</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11733</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>      100</td>\n",
        "      <td> JUN-10-99 06:04 PM</td>\n",
        "      <td> D</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>727 </th>\n",
        "      <td> 04/04/00</td>\n",
        "      <td>         FRIENDS OF STEVE ENGLEBRITE;P.O. BOX 2703</td>\n",
        "      <td>  EAST SETAUKET</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11733</td>\n",
        "      <td> 1356</td>\n",
        "      <td>      250</td>\n",
        "      <td> JUL-10-00 03:03 PM</td>\n",
        "      <td> D</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>871 </th>\n",
        "      <td> 11/03/11</td>\n",
        "      <td>       NASSAU DEMOCRATIC COMMITTEE;6 NEIGHBOUR WAY</td>\n",
        "      <td>    EAST NASSAU</td>\n",
        "      <td> NY</td>\n",
        "      <td> 12062</td>\n",
        "      <td> 1000</td>\n",
        "      <td> 31659.77</td>\n",
        "      <td> DEC-05-11 12:00 AM</td>\n",
        "      <td> D</td>\n",
        "      <td> SAFE NASSAU</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1128</th>\n",
        "      <td> 03/08/10</td>\n",
        "      <td> CITIZENS FOMM TO RE-ELECT KEN LA VALLE;9 BERKS...</td>\n",
        "      <td>   E. GREENBUSH</td>\n",
        "      <td> NY</td>\n",
        "      <td> 12061</td>\n",
        "      <td> 1405</td>\n",
        "      <td>      500</td>\n",
        "      <td> JUL-15-10 10:31 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1150</th>\n",
        "      <td> 08/03/99</td>\n",
        "      <td>                CITIZENS FOR CIOTTI;P.O. BOX 03068</td>\n",
        "      <td>         ELMONT</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11003</td>\n",
        "      <td> 1307</td>\n",
        "      <td>      450</td>\n",
        "      <td> AUG-11-99 07:39 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1166</th>\n",
        "      <td> 09/21/05</td>\n",
        "      <td>             CITIZENS FOR GREG PETERSON;PO BOX 455</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2171</td>\n",
        "      <td>    10000</td>\n",
        "      <td> OCT-07-05 03:02 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1167</th>\n",
        "      <td> 10/05/05</td>\n",
        "      <td>             CITIZENS FOR GREG PETERSON;PO BOX 455</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2186</td>\n",
        "      <td>    10000</td>\n",
        "      <td> OCT-25-05 11:29 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1250</th>\n",
        "      <td> 09/13/10</td>\n",
        "      <td>        CITIZENS FOR MONTESANO;25 MEADOWLARK DRIVE</td>\n",
        "      <td>   E. NORTHPORT</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11731</td>\n",
        "      <td> 1475</td>\n",
        "      <td>      250</td>\n",
        "      <td> SEP-30-10 11:02 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1288</th>\n",
        "      <td> 06/10/05</td>\n",
        "      <td>                  CITIZENS FOR PETERSON;PO BOX 455</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1988</td>\n",
        "      <td>      350</td>\n",
        "      <td> JUL-11-05 03:06 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1289</th>\n",
        "      <td> 09/21/05</td>\n",
        "      <td>                  CITIZENS FOR PETERSON;PO BOX 455</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2012</td>\n",
        "      <td>     1250</td>\n",
        "      <td> OCT-07-05 05:17 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1290</th>\n",
        "      <td> 09/07/05</td>\n",
        "      <td>                  CITIZENS FOR PETERSON;PO BOX 455</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2078</td>\n",
        "      <td>     1500</td>\n",
        "      <td> SEP-27-05 11:53 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1332</th>\n",
        "      <td> 09/15/05</td>\n",
        "      <td>                    CITIZENS FOR SANTINO;PO BOX 22</td>\n",
        "      <td>  EAST ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11515</td>\n",
        "      <td> 2160</td>\n",
        "      <td>      500</td>\n",
        "      <td> OCT-07-05 02:53 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1333</th>\n",
        "      <td> 10/24/01</td>\n",
        "      <td>                       CITIZENS FOR SANTINO;POB 22</td>\n",
        "      <td>    E. ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>      100</td>\n",
        "      <td> NOV-26-01 02:28 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1334</th>\n",
        "      <td> 06/01/07</td>\n",
        "      <td>                       CITIZENS FOR SANTINO;POB 22</td>\n",
        "      <td>    E. ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 1605</td>\n",
        "      <td>      100</td>\n",
        "      <td> JUL-05-07 05:27 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1335</th>\n",
        "      <td> 06/12/09</td>\n",
        "      <td>                  CITIZENS FOR SANTINO;P.O. BOX 22</td>\n",
        "      <td>    E. ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 1089</td>\n",
        "      <td>      100</td>\n",
        "      <td> JUL-13-09 02:19 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1336</th>\n",
        "      <td> 05/07/00</td>\n",
        "      <td>                  CITIZENS FOR SANTINO;P.O. BOX 22</td>\n",
        "      <td>  EAST ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 1371</td>\n",
        "      <td>      500</td>\n",
        "      <td> JUL-10-00 03:40 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1338</th>\n",
        "      <td> 08/04/05</td>\n",
        "      <td>                    CITIZENS FOR SANTINO;PO BOX 22</td>\n",
        "      <td>  EAST ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 2053</td>\n",
        "      <td>      200</td>\n",
        "      <td> AUG-08-05 12:34 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1358</th>\n",
        "      <td> 09/05/02</td>\n",
        "      <td>              COMM. TO ELECT JIM ALESSI;PO BOX 200</td>\n",
        "      <td>   E. ROCHESTER</td>\n",
        "      <td> NY</td>\n",
        "      <td> 14445</td>\n",
        "      <td> 1881</td>\n",
        "      <td>      200</td>\n",
        "      <td> OCT-03-02 10:22 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1406</th>\n",
        "      <td> 05/06/99</td>\n",
        "      <td> COMMITTEE TO RE-ELECT R. GAFFNEY;90 MERRICK AV...</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1613</td>\n",
        "      <td>     1000</td>\n",
        "      <td> JUL-22-99 11:26 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1409</th>\n",
        "      <td> 09/27/07</td>\n",
        "      <td>       COMMITTEE TO REELECT ROBERT SCHMIDT;POB 320</td>\n",
        "      <td>     E. NORWICH</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11732</td>\n",
        "      <td> 1635</td>\n",
        "      <td>      500</td>\n",
        "      <td> OCT-05-07 05:23 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1410</th>\n",
        "      <td> 09/04/07</td>\n",
        "      <td> COMMITTEE TO RE-ELECT ROBERT SCHMIDT SUPREME C...</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2434</td>\n",
        "      <td>      500</td>\n",
        "      <td> OCT-01-07 03:31 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1424</th>\n",
        "      <td> 01/14/08</td>\n",
        "      <td>  COMMITTEE TO RE-ELECT SENATOR BRUNO;4 SPRUCE RUN</td>\n",
        "      <td> EAST GREENBUSH</td>\n",
        "      <td> NY</td>\n",
        "      <td> 12061</td>\n",
        "      <td> 1096</td>\n",
        "      <td>     1000</td>\n",
        "      <td> OCT-23-09 01:29 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1438</th>\n",
        "      <td> 10/20/00</td>\n",
        "      <td> COUNCILMAN JOE KEARNEY ELECTION COMMITTEE;1199...</td>\n",
        "      <td>         ELMONT</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11580</td>\n",
        "      <td> 1418</td>\n",
        "      <td>      250</td>\n",
        "      <td> OCT-24-00 11:40 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1443</th>\n",
        "      <td> 07/20/99</td>\n",
        "      <td>       E. ROCKAWAY REPUBLICAN COMM;94 FRANKLIN AVE</td>\n",
        "      <td>    E. ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 1622</td>\n",
        "      <td>      100</td>\n",
        "      <td> OCT-08-99 10:14 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1472</th>\n",
        "      <td> 09/11/00</td>\n",
        "      <td>     FRIENDS FOR ANGIE M. CULLEN;90 MERRICK AVENUE</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1402</td>\n",
        "      <td>      125</td>\n",
        "      <td> SEP-19-00 09:18 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1561</th>\n",
        "      <td> 04/04/07</td>\n",
        "      <td>        FRIENDS FOR NORMA GONSALVES;1901 MERION ST</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2391</td>\n",
        "      <td>      500</td>\n",
        "      <td> JUL-16-07 05:32 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</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>2265</th>\n",
        "      <td> 09/23/03</td>\n",
        "      <td>        FRIENDS OF NORMA GONSALVES;1901 MERCUM ST.</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1980</td>\n",
        "      <td>     1500</td>\n",
        "      <td> OCT-03-03 12:50 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2266</th>\n",
        "      <td> 09/02/05</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2155</td>\n",
        "      <td>      500</td>\n",
        "      <td> OCT-07-05 03:09 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2267</th>\n",
        "      <td> 09/26/05</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2177</td>\n",
        "      <td>     1988</td>\n",
        "      <td> OCT-07-05 03:09 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2268</th>\n",
        "      <td> 04/23/09</td>\n",
        "      <td>         FRIENDS OF NORMA GONSALVES;1901 MERION ST</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1265</td>\n",
        "      <td>      700</td>\n",
        "      <td> JUL-08-09 02:28 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2269</th>\n",
        "      <td> 09/13/10</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1477</td>\n",
        "      <td>     1000</td>\n",
        "      <td> SEP-30-10 11:03 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2270</th>\n",
        "      <td> 03/14/05</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1957</td>\n",
        "      <td>      250</td>\n",
        "      <td> JUL-11-05 01:56 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2271</th>\n",
        "      <td> 06/21/05</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MARION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1994</td>\n",
        "      <td>      100</td>\n",
        "      <td> JUL-11-05 03:11 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2272</th>\n",
        "      <td> 04/09/09</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1065</td>\n",
        "      <td>      350</td>\n",
        "      <td> JUL-13-09 02:08 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2273</th>\n",
        "      <td> 08/19/09</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1109</td>\n",
        "      <td>      495</td>\n",
        "      <td> SEP-04-09 12:51 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2274</th>\n",
        "      <td> 09/21/10</td>\n",
        "      <td>     FRIENDS OF NORMA GONSALVES;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1216</td>\n",
        "      <td>      250</td>\n",
        "      <td> SEP-22-10 03:15 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2275</th>\n",
        "      <td> 08/11/03</td>\n",
        "      <td>        FRIENDS OF NORMA GONSALVES;1901 MERION ST.</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1780</td>\n",
        "      <td>      250</td>\n",
        "      <td> SEP-03-03 01:46 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2276</th>\n",
        "      <td> 10/09/03</td>\n",
        "      <td>         FRIENDS OF NORMA GONSALVES;1901 MERION ST</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1808</td>\n",
        "      <td>     1000</td>\n",
        "      <td> OCT-24-03 02:03 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2277</th>\n",
        "      <td> 03/21/05</td>\n",
        "      <td>        FRIENDS OF NORMA GONSALVES;1901 MERION ST.</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1988</td>\n",
        "      <td>      250</td>\n",
        "      <td> JUL-13-05 04:00 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2278</th>\n",
        "      <td> 10/13/05</td>\n",
        "      <td>         FRIENDS OF NORMA GONSALVES;1901 MERION ST</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2090</td>\n",
        "      <td>     2000</td>\n",
        "      <td> OCT-27-05 03:40 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2279</th>\n",
        "      <td> 04/30/09</td>\n",
        "      <td>         FRIENDS OF NORMA GONSALVES;1901 MERION ST</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2650</td>\n",
        "      <td>      500</td>\n",
        "      <td> JUL-13-09 04:45 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2280</th>\n",
        "      <td> 09/21/09</td>\n",
        "      <td>         FRIENDS OF NORMA GONSALVES;1901 MERION ST</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2700</td>\n",
        "      <td>     1000</td>\n",
        "      <td> SEP-24-09 03:30 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2281</th>\n",
        "      <td> 08/03/99</td>\n",
        "      <td>      FRIENDS OF NORMA GONZALEZ;1901 MERION STREET</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1308</td>\n",
        "      <td>      300</td>\n",
        "      <td> AUG-11-99 07:40 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2322</th>\n",
        "      <td> 11/02/11</td>\n",
        "      <td>             FRIENDS OF PAT MAHER;335 SPRING DRIVE</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1320</td>\n",
        "      <td>     2000</td>\n",
        "      <td> DEC-01-11 12:00 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2323</th>\n",
        "      <td> 10/27/11</td>\n",
        "      <td>                FRIENDS OF PAT MAHER;335 SPRING DR</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2905</td>\n",
        "      <td>     1000</td>\n",
        "      <td> NOV-29-11 12:00 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2371</th>\n",
        "      <td> 06/19/07</td>\n",
        "      <td>           FRIENDS OF PHIL BOYLE;136 E MAIN STREET</td>\n",
        "      <td>       E. ISLIP</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11730</td>\n",
        "      <td> 1614</td>\n",
        "      <td>      200</td>\n",
        "      <td> AUG-16-07 04:12 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2372</th>\n",
        "      <td> 06/12/00</td>\n",
        "      <td>           FRIENDS OF PHIL BOYLE;15 STEWART STREET</td>\n",
        "      <td>     EAST ISLIP</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11730</td>\n",
        "      <td> 1377</td>\n",
        "      <td>      125</td>\n",
        "      <td> JUL-10-00 03:47 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2373</th>\n",
        "      <td> 07/13/01</td>\n",
        "      <td>               FRIENDS OF PHIL BOYLE;15 STEWART ST</td>\n",
        "      <td>        E ISLIP</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11730</td>\n",
        "      <td> 1499</td>\n",
        "      <td>      400</td>\n",
        "      <td> AUG-09-01 10:07 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2374</th>\n",
        "      <td> 03/01/02</td>\n",
        "      <td>               FRIENDS OF PHIL BOYLE;15 STEWART ST</td>\n",
        "      <td>        E ISLIP</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11730</td>\n",
        "      <td> 1564</td>\n",
        "      <td>      200</td>\n",
        "      <td> JUL-03-02 10:20 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2375</th>\n",
        "      <td> 06/19/07</td>\n",
        "      <td>             FRIENDS OF PHIL BOYLE;136 E. MAIN ST.</td>\n",
        "      <td>     EAST ISLIP</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11730</td>\n",
        "      <td> 2417</td>\n",
        "      <td>      200</td>\n",
        "      <td> JUL-16-07 05:35 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2431</th>\n",
        "      <td> 09/27/07</td>\n",
        "      <td>              FRIENDS OF ROBERT SCHMIDT;PO BOX 320</td>\n",
        "      <td>   EAST NORWICH</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11732</td>\n",
        "      <td> 1635</td>\n",
        "      <td>      500</td>\n",
        "      <td> SEP-28-07 04:24 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2464</th>\n",
        "      <td> 01/09/12</td>\n",
        "      <td> FRIENDS OF SENATOR JACK MARTIN;192 CLEARMEADOW...</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1325</td>\n",
        "      <td>      500</td>\n",
        "      <td> JAN-16-12 12:00 AM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2505</th>\n",
        "      <td> 02/23/06</td>\n",
        "      <td>              FRIENDS OF TOM MCKEVITT;P.O. BOX 455</td>\n",
        "      <td>      E. MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 2039</td>\n",
        "      <td>      500</td>\n",
        "      <td> JUN-27-06 12:52 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2740</th>\n",
        "      <td> 10/03/01</td>\n",
        "      <td> N. HEPMSTEAD REPUBLICAN COMMITTEE;C/O AXELROD ...</td>\n",
        "      <td>    EAST MEADOW</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11554</td>\n",
        "      <td> 1522</td>\n",
        "      <td>      400</td>\n",
        "      <td> OCT-23-01 01:04 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         SOA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3195</th>\n",
        "      <td> 10/20/10</td>\n",
        "      <td>            TAXPAYERS FOR LENAHAN;17 EVERDELL ROAD</td>\n",
        "      <td>  EAST ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 1221</td>\n",
        "      <td>      100</td>\n",
        "      <td> NOV-29-10 04:58 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>  DETECTIVES</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3280</th>\n",
        "      <td> 06/30/09</td>\n",
        "      <td>                                   ;235 CARMEN AVE</td>\n",
        "      <td>  EAST ROCKAWAY</td>\n",
        "      <td> NY</td>\n",
        "      <td> 11518</td>\n",
        "      <td> 1290</td>\n",
        "      <td>    $ 600</td>\n",
        "      <td> JUL-08-09 02:59 PM</td>\n",
        "      <td> R</td>\n",
        "      <td>         PBA</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>86 rows \u00d7 10 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 86,
       "text": [
        "          DATE                         NAME OF INITIATIVE/ADDRESS  \\\n",
        "123   04/14/11              BROOKHAVEN DEMOCRATIC COMM;PO BOX 561   \n",
        "362   10/03/01         ENGLEBRIGHT FOR STATE ASSEMBLY;PO BOX 2703   \n",
        "363   02/09/99        ENGLEBRITE FOR STATE ASSEMBLY;P.O. BOX 2703   \n",
        "390   11/07/11      FRIENDS OF CARRIE SOLAGES;1630 DUTCH BROADWAY   \n",
        "484   02/12/99                     FRIENDS OF ENGELBRIGHT;POB 703   \n",
        "727   04/04/00          FRIENDS OF STEVE ENGLEBRITE;P.O. BOX 2703   \n",
        "871   11/03/11        NASSAU DEMOCRATIC COMMITTEE;6 NEIGHBOUR WAY   \n",
        "1128  03/08/10  CITIZENS FOMM TO RE-ELECT KEN LA VALLE;9 BERKS...   \n",
        "1150  08/03/99                 CITIZENS FOR CIOTTI;P.O. BOX 03068   \n",
        "1166  09/21/05              CITIZENS FOR GREG PETERSON;PO BOX 455   \n",
        "1167  10/05/05              CITIZENS FOR GREG PETERSON;PO BOX 455   \n",
        "1250  09/13/10         CITIZENS FOR MONTESANO;25 MEADOWLARK DRIVE   \n",
        "1288  06/10/05                   CITIZENS FOR PETERSON;PO BOX 455   \n",
        "1289  09/21/05                   CITIZENS FOR PETERSON;PO BOX 455   \n",
        "1290  09/07/05                   CITIZENS FOR PETERSON;PO BOX 455   \n",
        "1332  09/15/05                     CITIZENS FOR SANTINO;PO BOX 22   \n",
        "1333  10/24/01                        CITIZENS FOR SANTINO;POB 22   \n",
        "1334  06/01/07                        CITIZENS FOR SANTINO;POB 22   \n",
        "1335  06/12/09                   CITIZENS FOR SANTINO;P.O. BOX 22   \n",
        "1336  05/07/00                   CITIZENS FOR SANTINO;P.O. BOX 22   \n",
        "1338  08/04/05                     CITIZENS FOR SANTINO;PO BOX 22   \n",
        "1358  09/05/02               COMM. TO ELECT JIM ALESSI;PO BOX 200   \n",
        "1406  05/06/99  COMMITTEE TO RE-ELECT R. GAFFNEY;90 MERRICK AV...   \n",
        "1409  09/27/07        COMMITTEE TO REELECT ROBERT SCHMIDT;POB 320   \n",
        "1410  09/04/07  COMMITTEE TO RE-ELECT ROBERT SCHMIDT SUPREME C...   \n",
        "1424  01/14/08   COMMITTEE TO RE-ELECT SENATOR BRUNO;4 SPRUCE RUN   \n",
        "1438  10/20/00  COUNCILMAN JOE KEARNEY ELECTION COMMITTEE;1199...   \n",
        "1443  07/20/99        E. ROCKAWAY REPUBLICAN COMM;94 FRANKLIN AVE   \n",
        "1472  09/11/00      FRIENDS FOR ANGIE M. CULLEN;90 MERRICK AVENUE   \n",
        "1561  04/04/07         FRIENDS FOR NORMA GONSALVES;1901 MERION ST   \n",
        "...        ...                                                ...   \n",
        "2265  09/23/03         FRIENDS OF NORMA GONSALVES;1901 MERCUM ST.   \n",
        "2266  09/02/05      FRIENDS OF NORMA GONSALVES;1901 MERION STREET   \n",
        "2267  09/26/05      FRIENDS OF NORMA GONSALVES;1901 MERION STREET   \n",
        "2268  04/23/09          FRIENDS OF NORMA GONSALVES;1901 MERION ST   \n",
        "2269  09/13/10      FRIENDS OF NORMA GONSALVES;1901 MERION STREET   \n",
        "2270  03/14/05      FRIENDS OF NORMA GONSALVES;1901 MERION STREET   \n",
        "2271  06/21/05      FRIENDS OF NORMA GONSALVES;1901 MARION STREET   \n",
        "2272  04/09/09      FRIENDS OF NORMA GONSALVES;1901 MERION STREET   \n",
        "2273  08/19/09      FRIENDS OF NORMA GONSALVES;1901 MERION STREET   \n",
        "2274  09/21/10      FRIENDS OF NORMA GONSALVES;1901 MERION STREET   \n",
        "2275  08/11/03         FRIENDS OF NORMA GONSALVES;1901 MERION ST.   \n",
        "2276  10/09/03          FRIENDS OF NORMA GONSALVES;1901 MERION ST   \n",
        "2277  03/21/05         FRIENDS OF NORMA GONSALVES;1901 MERION ST.   \n",
        "2278  10/13/05          FRIENDS OF NORMA GONSALVES;1901 MERION ST   \n",
        "2279  04/30/09          FRIENDS OF NORMA GONSALVES;1901 MERION ST   \n",
        "2280  09/21/09          FRIENDS OF NORMA GONSALVES;1901 MERION ST   \n",
        "2281  08/03/99       FRIENDS OF NORMA GONZALEZ;1901 MERION STREET   \n",
        "2322  11/02/11              FRIENDS OF PAT MAHER;335 SPRING DRIVE   \n",
        "2323  10/27/11                 FRIENDS OF PAT MAHER;335 SPRING DR   \n",
        "2371  06/19/07            FRIENDS OF PHIL BOYLE;136 E MAIN STREET   \n",
        "2372  06/12/00            FRIENDS OF PHIL BOYLE;15 STEWART STREET   \n",
        "2373  07/13/01                FRIENDS OF PHIL BOYLE;15 STEWART ST   \n",
        "2374  03/01/02                FRIENDS OF PHIL BOYLE;15 STEWART ST   \n",
        "2375  06/19/07              FRIENDS OF PHIL BOYLE;136 E. MAIN ST.   \n",
        "2431  09/27/07               FRIENDS OF ROBERT SCHMIDT;PO BOX 320   \n",
        "2464  01/09/12  FRIENDS OF SENATOR JACK MARTIN;192 CLEARMEADOW...   \n",
        "2505  02/23/06               FRIENDS OF TOM MCKEVITT;P.O. BOX 455   \n",
        "2740  10/03/01  N. HEPMSTEAD REPUBLICAN COMMITTEE;C/O AXELROD ...   \n",
        "3195  10/20/10             TAXPAYERS FOR LENAHAN;17 EVERDELL ROAD   \n",
        "3280  06/30/09                                    ;235 CARMEN AVE   \n",
        "\n",
        "                City State  Zip Code  CHECK NO. AMOUNT ($ )  \\\n",
        "123             EAST    NY     11733       1538         500   \n",
        "362    EAST SETAUKET    NY     11733       1523         250   \n",
        "363    EAST SETAUKET    NY     11733       1250         200   \n",
        "390           ELMONT    NY     11003       2907        2000   \n",
        "484      E. SETAUKET    NY     11733        NaN         100   \n",
        "727    EAST SETAUKET    NY     11733       1356         250   \n",
        "871      EAST NASSAU    NY     12062       1000    31659.77   \n",
        "1128    E. GREENBUSH    NY     12061       1405         500   \n",
        "1150          ELMONT    NY     11003       1307         450   \n",
        "1166     EAST MEADOW    NY     11554       2171       10000   \n",
        "1167     EAST MEADOW    NY     11554       2186       10000   \n",
        "1250    E. NORTHPORT    NY     11731       1475         250   \n",
        "1288     EAST MEADOW    NY     11554       1988         350   \n",
        "1289     EAST MEADOW    NY     11554       2012        1250   \n",
        "1290     EAST MEADOW    NY     11554       2078        1500   \n",
        "1332   EAST ROCKAWAY    NY     11515       2160         500   \n",
        "1333     E. ROCKAWAY    NY     11518        NaN         100   \n",
        "1334     E. ROCKAWAY    NY     11518       1605         100   \n",
        "1335     E. ROCKAWAY    NY     11518       1089         100   \n",
        "1336   EAST ROCKAWAY    NY     11518       1371         500   \n",
        "1338   EAST ROCKAWAY    NY     11518       2053         200   \n",
        "1358    E. ROCHESTER    NY     14445       1881         200   \n",
        "1406     EAST MEADOW    NY     11554       1613        1000   \n",
        "1409      E. NORWICH    NY     11732       1635         500   \n",
        "1410     EAST MEADOW    NY     11554       2434         500   \n",
        "1424  EAST GREENBUSH    NY     12061       1096        1000   \n",
        "1438          ELMONT    NY     11580       1418         250   \n",
        "1443     E. ROCKAWAY    NY     11518       1622         100   \n",
        "1472     EAST MEADOW    NY     11554       1402         125   \n",
        "1561     EAST MEADOW    NY     11554       2391         500   \n",
        "...              ...   ...       ...        ...         ...   \n",
        "2265     EAST MEADOW    NY     11554       1980        1500   \n",
        "2266     EAST MEADOW    NY     11554       2155         500   \n",
        "2267     EAST MEADOW    NY     11554       2177        1988   \n",
        "2268     EAST MEADOW    NY     11554       1265         700   \n",
        "2269     EAST MEADOW    NY     11554       1477        1000   \n",
        "2270     EAST MEADOW    NY     11554       1957         250   \n",
        "2271     EAST MEADOW    NY     11554       1994         100   \n",
        "2272     EAST MEADOW    NY     11554       1065         350   \n",
        "2273     EAST MEADOW    NY     11554       1109         495   \n",
        "2274     EAST MEADOW    NY     11554       1216         250   \n",
        "2275     EAST MEADOW    NY     11554       1780         250   \n",
        "2276     EAST MEADOW    NY     11554       1808        1000   \n",
        "2277     EAST MEADOW    NY     11554       1988         250   \n",
        "2278     EAST MEADOW    NY     11554       2090        2000   \n",
        "2279     EAST MEADOW    NY     11554       2650         500   \n",
        "2280     EAST MEADOW    NY     11554       2700        1000   \n",
        "2281     EAST MEADOW    NY     11554       1308         300   \n",
        "2322     EAST MEADOW    NY     11554       1320        2000   \n",
        "2323     EAST MEADOW    NY     11554       2905        1000   \n",
        "2371        E. ISLIP    NY     11730       1614         200   \n",
        "2372      EAST ISLIP    NY     11730       1377         125   \n",
        "2373         E ISLIP    NY     11730       1499         400   \n",
        "2374         E ISLIP    NY     11730       1564         200   \n",
        "2375      EAST ISLIP    NY     11730       2417         200   \n",
        "2431    EAST NORWICH    NY     11732       1635         500   \n",
        "2464     EAST MEADOW    NY     11554       1325         500   \n",
        "2505       E. MEADOW    NY     11554       2039         500   \n",
        "2740     EAST MEADOW    NY     11554       1522         400   \n",
        "3195   EAST ROCKAWAY    NY     11518       1221         100   \n",
        "3280   EAST ROCKAWAY    NY     11518       1290       $ 600   \n",
        "\n",
        "             RECORD DATE Party       Source  \n",
        "123   JUL-07-11 04:21 PM     D          PBA  \n",
        "362   OCT-23-01 12:08 PM     D          SOA  \n",
        "363   JUL-07-99 09:05 AM     D          SOA  \n",
        "390   NOV-29-11 12:00 AM     D          SOA  \n",
        "484   JUN-10-99 06:04 PM     D   DETECTIVES  \n",
        "727   JUL-10-00 03:03 PM     D          SOA  \n",
        "871   DEC-05-11 12:00 AM     D  SAFE NASSAU  \n",
        "1128  JUL-15-10 10:31 AM     R          PBA  \n",
        "1150  AUG-11-99 07:39 PM     R          SOA  \n",
        "1166  OCT-07-05 03:02 PM     R          PBA  \n",
        "1167  OCT-25-05 11:29 AM     R          PBA  \n",
        "1250  SEP-30-10 11:02 AM     R          PBA  \n",
        "1288  JUL-11-05 03:06 PM     R   DETECTIVES  \n",
        "1289  OCT-07-05 05:17 PM     R   DETECTIVES  \n",
        "1290  SEP-27-05 11:53 AM     R          SOA  \n",
        "1332  OCT-07-05 02:53 PM     R          PBA  \n",
        "1333  NOV-26-01 02:28 PM     R   DETECTIVES  \n",
        "1334  JUL-05-07 05:27 PM     R   DETECTIVES  \n",
        "1335  JUL-13-09 02:19 PM     R   DETECTIVES  \n",
        "1336  JUL-10-00 03:40 PM     R          SOA  \n",
        "1338  AUG-08-05 12:34 PM     R          SOA  \n",
        "1358  OCT-03-02 10:22 AM     R          PBA  \n",
        "1406  JUL-22-99 11:26 AM     R          PBA  \n",
        "1409  OCT-05-07 05:23 PM     R   DETECTIVES  \n",
        "1410  OCT-01-07 03:31 PM     R          SOA  \n",
        "1424  OCT-23-09 01:29 PM     R          PBA  \n",
        "1438  OCT-24-00 11:40 AM     R          SOA  \n",
        "1443  OCT-08-99 10:14 AM     R          PBA  \n",
        "1472  SEP-19-00 09:18 AM     R          SOA  \n",
        "1561  JUL-16-07 05:32 PM     R          SOA  \n",
        "...                  ...   ...          ...  \n",
        "2265  OCT-03-03 12:50 PM     R          PBA  \n",
        "2266  OCT-07-05 03:09 PM     R          PBA  \n",
        "2267  OCT-07-05 03:09 PM     R          PBA  \n",
        "2268  JUL-08-09 02:28 PM     R          PBA  \n",
        "2269  SEP-30-10 11:03 AM     R          PBA  \n",
        "2270  JUL-11-05 01:56 PM     R   DETECTIVES  \n",
        "2271  JUL-11-05 03:11 PM     R   DETECTIVES  \n",
        "2272  JUL-13-09 02:08 PM     R   DETECTIVES  \n",
        "2273  SEP-04-09 12:51 PM     R   DETECTIVES  \n",
        "2274  SEP-22-10 03:15 PM     R   DETECTIVES  \n",
        "2275  SEP-03-03 01:46 PM     R          SOA  \n",
        "2276  OCT-24-03 02:03 PM     R          SOA  \n",
        "2277  JUL-13-05 04:00 PM     R          SOA  \n",
        "2278  OCT-27-05 03:40 PM     R          SOA  \n",
        "2279  JUL-13-09 04:45 PM     R          SOA  \n",
        "2280  SEP-24-09 03:30 PM     R          SOA  \n",
        "2281  AUG-11-99 07:40 PM     R          SOA  \n",
        "2322  DEC-01-11 12:00 AM     R   DETECTIVES  \n",
        "2323  NOV-29-11 12:00 AM     R          SOA  \n",
        "2371  AUG-16-07 04:12 PM     R   DETECTIVES  \n",
        "2372  JUL-10-00 03:47 PM     R          SOA  \n",
        "2373  AUG-09-01 10:07 PM     R          SOA  \n",
        "2374  JUL-03-02 10:20 AM     R          SOA  \n",
        "2375  JUL-16-07 05:35 PM     R          SOA  \n",
        "2431  SEP-28-07 04:24 PM     R   DETECTIVES  \n",
        "2464  JAN-16-12 12:00 AM     R   DETECTIVES  \n",
        "2505  JUN-27-06 12:52 PM     R   DETECTIVES  \n",
        "2740  OCT-23-01 01:04 PM     R          SOA  \n",
        "3195  NOV-29-10 04:58 PM     R   DETECTIVES  \n",
        "3280  JUL-08-09 02:59 PM     R          PBA  \n",
        "\n",
        "[86 rows x 10 columns]"
       ]
      }
     ],
     "prompt_number": 86
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Let's create a new dataframe that only contains the cities that start with \"E\" that we can play with:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ecities = df[df['City'].str.startswith(\"E\")]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 87
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ecities['City'].unique()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 89,
       "text": [
        "array([u'EAST', u'EAST SETAUKET', u'ELMONT', u'E. SETAUKET',\n",
        "       u'EAST NASSAU', u'E. GREENBUSH', u'EAST MEADOW', u'E. NORTHPORT',\n",
        "       u'EAST ROCKAWAY', u'E. ROCKAWAY', u'E. ROCHESTER', u'E. NORWICH',\n",
        "       u'EAST GREENBUSH', u'E. MEADOW', u'ELMIRA', u'EAST NORTHPOND',\n",
        "       u'EAST NORTHPORT', u'E. WILLISTON', u'E. ISLIP', u'EAST ISLIP',\n",
        "       u'E ISLIP', u'EAST NORWICH'], dtype=object)"
       ]
      }
     ],
     "prompt_number": 89
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "It's stil petty much a mess. However, using regular expressions, we can replace every \"E \" or \"E. \" with the string \"EAST \"\n",
      "\n",
      "breaking `replace(r\"\\s*E\\.?\\s\", \"EAST \")` down into chunks:\n",
      "    \n",
      "```\n",
      "r = use regular expression language\n",
      "\\s = space\n",
      "* = wildcard (anything)\n",
      "\\.? = one or no \".\" characters\n",
      "```"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ecities['City'].str.replace(r\"\\s*E\\.?\\s\", \"EAST \").unique()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 91,
       "text": [
        "array([u'EAST', u'EAST SETAUKET', u'ELMONT', u'EAST NASSAU',\n",
        "       u'EAST GREENBUSH', u'EAST MEADOW', u'EAST NORTHPORT',\n",
        "       u'EAST ROCKAWAY', u'EAST ROCHESTER', u'EAST NORWICH', u'ELMIRA',\n",
        "       u'EAST NORTHPOND', u'EAST WILLISTON', u'EAST ISLIP'], dtype=object)"
       ]
      }
     ],
     "prompt_number": 91
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df['City'] = df['City'].str.replace(r\"\\s*E\\.?\\s\", \"EAST \")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 92
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df[df['City'].str.startswith(\"E\")]['City'].unique()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 96,
       "text": [
        "array([u'EAST', u'EAST SETAUKET', u'ELMONT', u'EAST NASSAU',\n",
        "       u'EAST GREENBUSH', u'EAST MEADOW', u'EAST NORTHPORT',\n",
        "       u'EAST ROCKAWAY', u'EAST ROCHESTER', u'EAST NORWICH', u'ELMIRA',\n",
        "       u'EAST NORTHPOND', u'EAST WILLISTON', u'EAST ISLIP'], dtype=object)"
       ]
      }
     ],
     "prompt_number": 96
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}