Data Analaysis with Pandas - ElectionData.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from pandas import *\n",
    "import matplotlib as mpl\n",
    "mpl.rc('figure', figsize=(12, 6))\n",
    "#set_printoptions(max_columns=18)\n",
    "pandas.options.display.max_columns = 18\n",
    "months = {'JAN' : 1, 'FEB' : 2, 'MAR' : 3, 'APR' : 4, 'MAY' : 5, 'JUN' : 6,\n",
    "          'JUL' : 7, 'AUG' : 8, 'SEP' : 9, 'OCT': 10, 'NOV': 11, 'DEC' : 12}\n",
    "of_interest = ['Obama, Barack', 'Romney, Mitt', 'Santorum, Rick', \n",
    "               'Paul, Ron', 'Gingrich, Newt']\n",
    "parties = {\n",
    "  'Bachmann, Michelle': 'Republican',\n",
    "  'Romney, Mitt': 'Republican',\n",
    "  'Obama, Barack': 'Democrat',\n",
    "  \"Roemer, Charles E. 'Buddy' III\": 'Reform',\n",
    "  'Pawlenty, Timothy': 'Republican',\n",
    "  'Johnson, Gary Earl': 'Libertarian',\n",
    "  'Paul, Ron': 'Republican',\n",
    "  'Santorum, Rick': 'Republican',\n",
    "  'Cain, Herman': 'Republican',\n",
    "  'Gingrich, Newt': 'Republican',\n",
    "  'McCotter, Thaddeus G': 'Republican',\n",
    "  'Huntsman, Jon': 'Republican',\n",
    "  'Perry, Rick': 'Republican'           \n",
    " }"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "fec = read_csv('data/P00000001-ALL.txt',dtype={6:np.object})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 536041 entries, 0 to 536040\n",
      "Data columns (total 16 columns):\n",
      "cmte_id              536041 non-null object\n",
      "cand_id              536041 non-null object\n",
      "cand_nm              536041 non-null object\n",
      "contbr_nm            536041 non-null object\n",
      "contbr_city          536026 non-null object\n",
      "contbr_st            536040 non-null object\n",
      "contbr_zip           535973 non-null object\n",
      "contbr_employer      525088 non-null object\n",
      "contbr_occupation    530520 non-null object\n",
      "contb_receipt_amt    536041 non-null float64\n",
      "contb_receipt_dt     536041 non-null object\n",
      "receipt_desc         8479 non-null object\n",
      "memo_cd              49718 non-null object\n",
      "memo_text            52740 non-null object\n",
      "form_tp              536041 non-null object\n",
      "file_num             536041 non-null int64\n",
      "dtypes: float64(1), int64(1), object(14)"
     ]
    }
   ],
   "source": [
    "fec.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Bachmann, Michelle': 'Republican',\n",
       " 'Cain, Herman': 'Republican',\n",
       " 'Gingrich, Newt': 'Republican',\n",
       " 'Huntsman, Jon': 'Republican',\n",
       " 'Johnson, Gary Earl': 'Libertarian',\n",
       " 'McCotter, Thaddeus G': 'Republican',\n",
       " 'Obama, Barack': 'Democrat',\n",
       " 'Paul, Ron': 'Republican',\n",
       " 'Pawlenty, Timothy': 'Republican',\n",
       " 'Perry, Rick': 'Republican',\n",
       " \"Roemer, Charles E. 'Buddy' III\": 'Reform',\n",
       " 'Romney, Mitt': 'Republican',\n",
       " 'Santorum, Rick': 'Republican'}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "parties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     Bachmann, Michelle\n",
       "1     Bachmann, Michelle\n",
       "2     Bachmann, Michelle\n",
       "3     Bachmann, Michelle\n",
       "4     Bachmann, Michelle\n",
       "5     Bachmann, Michelle\n",
       "6     Bachmann, Michelle\n",
       "7     Bachmann, Michelle\n",
       "8     Bachmann, Michelle\n",
       "9     Bachmann, Michelle\n",
       "10    Bachmann, Michelle\n",
       "11    Bachmann, Michelle\n",
       "12    Bachmann, Michelle\n",
       "13    Bachmann, Michelle\n",
       "14    Bachmann, Michelle\n",
       "...\n",
       "536026    Perry, Rick\n",
       "536027    Perry, Rick\n",
       "536028    Perry, Rick\n",
       "536029    Perry, Rick\n",
       "536030    Perry, Rick\n",
       "536031    Perry, Rick\n",
       "536032    Perry, Rick\n",
       "536033    Perry, Rick\n",
       "536034    Perry, Rick\n",
       "536035    Perry, Rick\n",
       "536036    Perry, Rick\n",
       "536037    Perry, Rick\n",
       "536038    Perry, Rick\n",
       "536039    Perry, Rick\n",
       "536040    Perry, Rick\n",
       "Name: cand_nm, Length: 536041, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fec.cand_nm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "application/javascript": [
       "IPython.OutputArea.auto_scroll_threshold = 9999;"
      ],
      "text/plain": [
       "<IPython.core.display.Javascript object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%%javascript\n",
    "IPython.OutputArea.auto_scroll_threshold = 9999;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     Republican\n",
       "1     Republican\n",
       "2     Republican\n",
       "3     Republican\n",
       "4     Republican\n",
       "5     Republican\n",
       "6     Republican\n",
       "7     Republican\n",
       "8     Republican\n",
       "9     Republican\n",
       "10    Republican\n",
       "11    Republican\n",
       "12    Republican\n",
       "13    Republican\n",
       "14    Republican\n",
       "...\n",
       "536026    Republican\n",
       "536027    Republican\n",
       "536028    Republican\n",
       "536029    Republican\n",
       "536030    Republican\n",
       "536031    Republican\n",
       "536032    Republican\n",
       "536033    Republican\n",
       "536034    Republican\n",
       "536035    Republican\n",
       "536036    Republican\n",
       "536037    Republican\n",
       "536038    Republican\n",
       "536039    Republican\n",
       "536040    Republican\n",
       "Name: cand_nm, Length: 536041, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To add a new column with parties, you can do\n",
    "# [parties[x] for x in fec.cand_nm]\n",
    "\n",
    "# Or\n",
    "fec.cand_nm.map(parties) # Maps name to the dictionary of parties."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/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>cmte_id</th>\n",
       "      <th>cand_id</th>\n",
       "      <th>cand_nm</th>\n",
       "      <th>contbr_nm</th>\n",
       "      <th>contbr_city</th>\n",
       "      <th>contbr_st</th>\n",
       "      <th>contbr_zip</th>\n",
       "      <th>contbr_employer</th>\n",
       "      <th>contbr_occupation</th>\n",
       "      <th>contb_receipt_amt</th>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th>receipt_desc</th>\n",
       "      <th>memo_cd</th>\n",
       "      <th>memo_text</th>\n",
       "      <th>form_tp</th>\n",
       "      <th>file_num</th>\n",
       "      <th>party</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>    HARVEY, WILLIAM</td>\n",
       "      <td>             MOBILE</td>\n",
       "      <td> AL</td>\n",
       "      <td> 366010290</td>\n",
       "      <td>               RETIRED</td>\n",
       "      <td>               RETIRED</td>\n",
       "      <td> 250</td>\n",
       "      <td> 20-JUN-11</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> SA17A</td>\n",
       "      <td> 736166</td>\n",
       "      <td> Republican</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>    HARVEY, WILLIAM</td>\n",
       "      <td>             MOBILE</td>\n",
       "      <td> AL</td>\n",
       "      <td> 366010290</td>\n",
       "      <td>               RETIRED</td>\n",
       "      <td>               RETIRED</td>\n",
       "      <td>  50</td>\n",
       "      <td> 23-JUN-11</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> SA17A</td>\n",
       "      <td> 736166</td>\n",
       "      <td> Republican</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>      SMITH, LANIER</td>\n",
       "      <td>             LANETT</td>\n",
       "      <td> AL</td>\n",
       "      <td> 368633403</td>\n",
       "      <td> INFORMATION REQUESTED</td>\n",
       "      <td> INFORMATION REQUESTED</td>\n",
       "      <td> 250</td>\n",
       "      <td> 05-JUL-11</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> SA17A</td>\n",
       "      <td> 749073</td>\n",
       "      <td> Republican</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>   BLEVINS, DARONDA</td>\n",
       "      <td>            PIGGOTT</td>\n",
       "      <td> AR</td>\n",
       "      <td> 724548253</td>\n",
       "      <td>                  NONE</td>\n",
       "      <td>               RETIRED</td>\n",
       "      <td> 250</td>\n",
       "      <td> 01-AUG-11</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> SA17A</td>\n",
       "      <td> 749073</td>\n",
       "      <td> Republican</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> WARDENBURG, HAROLD</td>\n",
       "      <td> HOT SPRINGS NATION</td>\n",
       "      <td> AR</td>\n",
       "      <td> 719016467</td>\n",
       "      <td>                  NONE</td>\n",
       "      <td>               RETIRED</td>\n",
       "      <td> 300</td>\n",
       "      <td> 20-JUN-11</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> SA17A</td>\n",
       "      <td> 736166</td>\n",
       "      <td> Republican</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cmte_id    cand_id             cand_nm           contbr_nm  \\\n",
       "0  C00410118  P20002978  Bachmann, Michelle     HARVEY, WILLIAM   \n",
       "1  C00410118  P20002978  Bachmann, Michelle     HARVEY, WILLIAM   \n",
       "2  C00410118  P20002978  Bachmann, Michelle       SMITH, LANIER   \n",
       "3  C00410118  P20002978  Bachmann, Michelle    BLEVINS, DARONDA   \n",
       "4  C00410118  P20002978  Bachmann, Michelle  WARDENBURG, HAROLD   \n",
       "\n",
       "          contbr_city contbr_st contbr_zip        contbr_employer  \\\n",
       "0              MOBILE        AL  366010290                RETIRED   \n",
       "1              MOBILE        AL  366010290                RETIRED   \n",
       "2              LANETT        AL  368633403  INFORMATION REQUESTED   \n",
       "3             PIGGOTT        AR  724548253                   NONE   \n",
       "4  HOT SPRINGS NATION        AR  719016467                   NONE   \n",
       "\n",
       "       contbr_occupation  contb_receipt_amt contb_receipt_dt receipt_desc  \\\n",
       "0                RETIRED                250        20-JUN-11          NaN   \n",
       "1                RETIRED                 50        23-JUN-11          NaN   \n",
       "2  INFORMATION REQUESTED                250        05-JUL-11          NaN   \n",
       "3                RETIRED                250        01-AUG-11          NaN   \n",
       "4                RETIRED                300        20-JUN-11          NaN   \n",
       "\n",
       "  memo_cd memo_text form_tp  file_num       party  \n",
       "0     NaN       NaN   SA17A    736166  Republican  \n",
       "1     NaN       NaN   SA17A    736166  Republican  \n",
       "2     NaN       NaN   SA17A    749073  Republican  \n",
       "3     NaN       NaN   SA17A    749073  Republican  \n",
       "4     NaN       NaN   SA17A    736166  Republican  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fec['party'] = fec.cand_nm.map(parties)\n",
    "fec.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Democrat       292400\n",
       "Republican     237575\n",
       "Reform           5364\n",
       "Libertarian       702\n",
       "dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fec.party.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count       536041\n",
       "unique           4\n",
       "top       Democrat\n",
       "freq        292400\n",
       "dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fec.party.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Democrat': 292400, 'Libertarian': 702, 'Reform': 5364, 'Republican': 237575}"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To do this in numpy,\n",
    "np.unique(fec.party) # numpy array of unique values\n",
    "dict = {x:0 for x in np.unique(fec.party)}\n",
    "for x in fec.party:\n",
    "    dict[x] = dict[x]+1\n",
    "dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "party\n",
       "Democrat       8.105758e+07\n",
       "Libertarian    4.132769e+05\n",
       "Reform         3.390338e+05\n",
       "Republican     1.192255e+08\n",
       "Name: contb_receipt_amt, dtype: float64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Group by the party and find the total contribution amount for each\n",
    "fec.groupby('party')['contb_receipt_amt'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "party     contb_receipt_dt\n",
       "Democrat  01-AUG-11           175281.00\n",
       "          01-DEC-11           651532.82\n",
       "          01-JAN-12            58098.80\n",
       "          01-JUL-11           165961.00\n",
       "          01-JUN-11           145459.00\n",
       "          01-MAY-11            82644.00\n",
       "          01-NOV-11           122529.87\n",
       "          01-OCT-11           148977.00\n",
       "          01-SEP-11           403297.62\n",
       "          02-AUG-11           164510.11\n",
       "          02-DEC-11           216056.96\n",
       "          02-JAN-12            89743.60\n",
       "          02-JUL-11            17105.00\n",
       "          02-JUN-11           422453.00\n",
       "          02-MAY-11           396675.00\n",
       "...\n",
       "Republican  30-JUL-11             12249.04\n",
       "            30-JUN-11           2744932.63\n",
       "            30-MAR-11             50240.00\n",
       "            30-MAY-11             17803.60\n",
       "            30-NOV-11            809014.83\n",
       "            30-OCT-11             43913.16\n",
       "            30-SEP-11           4886331.76\n",
       "            31-AUG-11           1017735.02\n",
       "            31-DEC-11           1094376.72\n",
       "            31-JAN-11              6000.00\n",
       "            31-JAN-12            869890.41\n",
       "            31-JUL-11             12781.02\n",
       "            31-MAR-11             62475.00\n",
       "            31-MAY-11            301339.80\n",
       "            31-OCT-11            734601.83\n",
       "Name: contb_receipt_amt, Length: 1183, dtype: float64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "# To find the contribution variation across time,\n",
    "fec.groupby(['party','contb_receipt_dt'])['contb_receipt_amt'].sum()\n",
    "#But this would look aweful if you try to plot it because \n",
    "# contb_receipt_dt is string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "20-6-11\n"
     ]
    }
   ],
   "source": [
    "# Convert string date to numerical date\n",
    "str_date = fec.contb_receipt_dt[0]\n",
    "[day,month,year] = str_date.split('-')\n",
    "print('-'.join([day,str(months[month]),year]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0    20-6-11\n",
      "1    23-6-11\n",
      "2    05-7-11\n",
      "3    01-8-11\n",
      "4    20-6-11\n",
      "Name: contb_receipt_dt, dtype: object\n"
     ]
    }
   ],
   "source": [
    "def date_convert(str_date):\n",
    "    [day,month,year] = str_date.split('-')\n",
    "    return '-'.join([day,str(months[month]),year])\n",
    "print(fec.contb_receipt_dt.apply(date_convert).head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    2011-06-20\n",
       "1    2011-06-23\n",
       "2    2011-07-05\n",
       "3    2011-08-01\n",
       "4    2011-06-20\n",
       "5    2011-06-23\n",
       "6    2011-06-21\n",
       "7    2011-07-05\n",
       "8    2011-06-21\n",
       "9    2011-06-20\n",
       "10   2011-06-22\n",
       "11   2011-06-22\n",
       "12   2011-06-21\n",
       "13   2011-06-17\n",
       "14   2011-07-11\n",
       "...\n",
       "536026   2011-08-26\n",
       "536027   2011-10-04\n",
       "536028   2011-10-04\n",
       "536029   2011-09-30\n",
       "536030   2011-08-15\n",
       "536031   2011-09-30\n",
       "536032   2011-08-26\n",
       "536033   2011-10-01\n",
       "536034   2011-09-30\n",
       "536035   2011-09-30\n",
       "536036   2011-08-31\n",
       "536037   2011-09-30\n",
       "536038   2011-09-29\n",
       "536039   2011-09-30\n",
       "536040   2011-09-29\n",
       "Name: contb_receipt_dt, Length: 536041, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Or better, convert it into datetime\n",
    "def date_convert(str_date):\n",
    "    day,month,year = str_date.split('-')\n",
    "    return datetime(int('20'+year),months[month],int(day))\n",
    "fec.contb_receipt_dt.map(date_convert)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "fec['contb_receipt_dt'] = fec.contb_receipt_dt.map(date_convert)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "by_date = fec.groupby(['party','contb_receipt_dt'])['contb_receipt_amt'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "party     contb_receipt_dt\n",
       "Democrat  2011-04-04          640235.12\n",
       "          2011-04-05          307641.00\n",
       "          2011-04-06          247542.59\n",
       "          2011-04-07          252336.00\n",
       "          2011-04-08          295452.00\n",
       "          2011-04-09          105879.00\n",
       "          2011-04-10          100373.00\n",
       "          2011-04-11          360728.00\n",
       "          2011-04-12          405160.46\n",
       "          2011-04-13          382836.33\n",
       "          2011-04-14          306643.50\n",
       "          2011-04-15          408377.00\n",
       "          2011-04-16           82658.00\n",
       "          2011-04-17           70802.00\n",
       "          2011-04-18          501971.37\n",
       "...\n",
       "Republican  2012-01-17           625365.77\n",
       "            2012-01-18           888681.17\n",
       "            2012-01-19          1066250.23\n",
       "            2012-01-20           401298.03\n",
       "            2012-01-21           374261.81\n",
       "            2012-01-22           507168.71\n",
       "            2012-01-23           645477.15\n",
       "            2012-01-24           462233.66\n",
       "            2012-01-25           416931.39\n",
       "            2012-01-26           256406.86\n",
       "            2012-01-27           368441.82\n",
       "            2012-01-28            82775.80\n",
       "            2012-01-29            75220.02\n",
       "            2012-01-30           255204.80\n",
       "            2012-01-31           869890.41\n",
       "Name: contb_receipt_amt, Length: 1183, dtype: float64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "by_date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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>party</th>\n",
       "      <th>Democrat</th>\n",
       "      <th>Libertarian</th>\n",
       "      <th>Reform</th>\n",
       "      <th>Republican</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011-01-01</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 8600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-03</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 4800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-04</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 5000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-12</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 4150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 4000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "party             Democrat  Libertarian  Reform  Republican\n",
       "contb_receipt_dt                                           \n",
       "2011-01-01             NaN          NaN     NaN        8600\n",
       "2011-01-03             NaN          NaN     NaN        4800\n",
       "2011-01-04             NaN          NaN     NaN        5000\n",
       "2011-01-12             NaN          NaN     NaN        4150\n",
       "2011-01-13             NaN          NaN     NaN        4000"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#As we can see above, now the date column is sorted\n",
    "by_date.unstack('party').head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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>party</th>\n",
       "      <th>Democrat</th>\n",
       "      <th>Libertarian</th>\n",
       "      <th>Reform</th>\n",
       "      <th>Republican</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011-01-01</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>  8600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-03</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 13400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-04</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 18400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-12</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 22550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td> 26550</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "party             Democrat  Libertarian  Reform  Republican\n",
       "contb_receipt_dt                                           \n",
       "2011-01-01             NaN          NaN     NaN        8600\n",
       "2011-01-03             NaN          NaN     NaN       13400\n",
       "2011-01-04             NaN          NaN     NaN       18400\n",
       "2011-01-12             NaN          NaN     NaN       22550\n",
       "2011-01-13             NaN          NaN     NaN       26550"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# So now, to track how the amount varies over time, we take the cumulative sum\n",
    "by_date.unstack('party').cumsum().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x11b0d6470>"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW8AAAEXCAYAAABiTcW4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzsnXe4XFXVh9/fvek9IZCEQOgt9BYQKSdIk947SBME7CAI\nSldUVMDKhxBBREBQpAiKIjmASif0IgFCSSCUkJAQEpLc9f2x9iST4fY7M2fm3P0+zzz3lH32WWv2\nnXX2WXvttWVmRCKRSKS+aMhagEgkEol0nGi8I5FIpA6JxjsSiUTqkGi8I5FIpA6JxjsSiUTqkGi8\nI5FIpA6pmvGW9FtJ0yU93Y6yq0u6X9IkSU9K+nw1ZIxEIpF6oZo976uAXdpZ9rvAtWa2MXAw8OuK\nSRWJRCJ1SNWMt5ndD3xQfEzSapL+JulRSfdJWiucegsYHLaHAFOrJWckEonUA6rmDEtJKwO3m9n6\nYf9fwAlmNlnSFsCFZvY5SYOAB4BBQH/gc2Y2qWqCRiKRSI3TI6sbSxoAfAa4SVLhcK/w92LgSjO7\nRNKWwLXAutWXMhKJRGqTzIw37rKZGfzapWwFnANgZg9K6iNpuJm9V1UJI5FIpEZp0+fdVpSIpMNC\nRMhTkv4jaYP23NjMPgRelbR/qEdF174A7BCOrwP0iYY7EolEltCeAcu2okReAbY1sw2AC4DfNFdI\n0vXAf4G1JL0h6WjgMOBYSU8AzwB7huLfAo4Ox68DvtAeZSKRSKS70K4By9KBxlbKDQWeNrMVyiJd\nJBKJRJql3KGCxwJ3lrnOSCQSiZRQtgFLSeOBY4DPlqvOSCQSiTRPWYx3GGi8AtjFzD5ooUxcsicS\niUQ6gZmp9FiXjbekMcDNwOFmNrmjApQbSVeb2VGVvk+lyYseBaI+tUuedIH86KM0HQS8yPjxI5s7\n36bxDlEi2wHDJb2Bx1/3BDCzy4GzgaHAZWGyzQIzG1ce8SORSKR7oTQdAYwFvgH8HTiquXJtGm8z\nO6SN88cBx3VcxIoxJWsBysSUrAUoM1OyFqDMTMlagDIyJWsBysyUrAXoDErTIcB5eGj008DdwE/p\nrPGuQ9KsBSgTadYClJk0awHKTJq1AGUkzVqAMpNmLUBHUZqOA27Be9qrWpLMWHyuhWvyaLwjkUik\nblCa7gJcAxxrSXJ7e6/L3HhXIgqlKNFVXVOLelRj0DkS6S4oTdfFDffeliT/7dC11UoJK8ma++G3\ndDxSe8S2ikTKh9L0c3j6j29YklzXYrkWfndxDctIJBKpMkrTY3HDfVBrhrs1cme8JSVZy1AO8qJH\ngahP7ZInXaD29VGargb8CNjGkiTtbD25M96RSCRS43wL+D9Lkv91pZLo864CkvYC/mdmz2ctS1fo\nDm0ViVQSpenawP3AOpYk7VqjIPq8M0JSD2AffMZUJBLppihNe+E5oH7QXsPdGrkz3pXwd0laWdIL\nkq6V9JykmyT1lXS2pIclPS3p8qLyqaRLJD0CnAbsAfxY0uOSVpX0WFHZNYr3K6lHlkR9apc86QK1\nqY/SdBRwK/ABcGk56syd8a4gawK/MrOxwIfAScAvzGxcWKSir6TdQ1kDeprZ5mZ2IXAbcKqZbWJm\nrwCzJG0Yyh4N/La6qkQikWqhNN0YeAJ4GNjPkqSpHPVmPkmn3JhZWqGq3zCzB8L2tcBXgSmSTgP6\nAsPwpdz+Gsr8seT6Yp/Vlfgyb98EDgQ2L71ZBfXIhKhP7ZInXaC29FGaroH3uE+2JPlTOeuOPe/2\nUzyyq7D/K2DfsH7nFUCfojIftXL9n4HPA7sDj7aUAz0SidQvStM9gX8DF5TbcEMOjXcF/V1jJG0Z\ntg/FGwXgfUkDgANKRSnang0MKuyY2XzgLuAyfIHnT1GLfruuEPWpXfKkC9SGPkrTY/Df916WJFdU\n4h65M94V5EXgZEnPAYPxhrkCd5X8HXiopHxxT/sG4FuSHpO0Sjh2HdAE/KOiUkcikaqiNP0qvu7B\neEuSByt2nxjn3TaSVgZuDwOT5arzVGCgmZ1TrjorTT20VSSSBWHW5CnAeHwscUdLkillqbuF313u\nBiwrSNmecpL+AqwCbF+uOiORSDYoTXcArsfHwA4FnrYkWVjx++at5y0pqaXR5s5Si3p0pa1qUZ+u\nkCd98qQLVE+fsPLNjsCvgX0tSe6vyH1izzsSiUS6jtJ0KD7FfSXgEeDQShnuVuXIW887UjliW0Ui\noDQ9A1gPONKSZFHF7xd73pFIJNI1lKZbAN/EI0kqbrhbI3ehgrUQ41kO8qJHgahP7ZInXaBy+ihN\nx+MzqI+yJHmmEvfoCLHnHYlEIm0QMgJOAI6wJPl71vJA9HlHOkBsq0h3Q2kqPG/RBcBKliS7VV2G\nmM+7Y0iaImmupA8lfSDpP5JOUC0u6d5OJCWS3shajkikllGaLqs0vVJp+g6wCHgFWA44PFvJlqZN\n4y3pt5KmS3q6lTI/l/SSpCclbVxeETtGGf1dBuxuZoOAMcAPgdPxV6eK01E9FKiQOF0m+lVrlzzp\nAl3TR2naG7gTmAdsAvS0JBlsSbK/JUlNJZBrT8/7KmCXlk5K2hVY3czWAI7Hc37kCjObbWa3AwcB\nX5A0VlJvST+R9JqktyVdJqkPLO7hvinpW5LekTRN0t6SdpX0P0nvS/p2of5Q16WSpobPJRSNR0ja\nS9ITkmZJmixpp3A8lfQ9Sf/BsxiuKulo+YIRH0p6WdLxoWx/4G/A8pJmh/Mjq/YlRiI1jtJ0JPAf\nvKf9FUuSN7OOKGmNNo23md2Pr/7QEnsCvwtlHwKGSBpRHvE6TiVnVpnZI8CbwLZ4T3x1YMPwdzRw\ndlHxEUBvYFQ4fiVwGLAxsA1wtqSVQtnvAONCXRuG7W0BJI3Dv99TzGxwOP5a0X0OB44DBoTj04Hd\nwhvD0cAlkjY2s4/wh/A0MxtoZoPM7O0yfTVtkqcZfJAvffKkC3ROn+DbvgSffHOwJUl1BgO7QDl8\n3qOBYj/qm8AKZai3VpmGD2B8Efimmc00sznAD4CDi8otAL5vZovwhRmGAZea2Udm9hzwHG6owfMh\nnG9m75nZe8B5wBHh3LHABDP7F4CZTTOzF8M5A642s+fNrMnMFprZnWb2aih7H561cJtQvmbdKpFI\nVoSVbu4D1gK+Ww+GG8o3YFlqFMqYxAkrx6dc8uAPqx5AP+CxMJj5Ae6SGF5U7n1bEsrzcfg7vej8\nx3hvGWB5lu5Nvx7uA/4gfLkVeZYagJT0eUkPBtfMB8CuwDLt0qyCRL9q7ZInXaBT+kwA/gJsbklS\nuohKzVKOOO+pwIpF+yuEY59C0tXAlLA7E1/XrXAugSWvPEX7auP8UvuFY+0t39I+virOhsA9RefX\nwo3qLcAZwLFmdnPp/QO9m0mQsyVumMFzgq8TtqcBe0gaEcqPAT4Mdb4BrN6CvEMID8qw3xNfpedw\n/PttAr7mp5WwpKff4e+jVL9OfJ8bSep0e9Taft706a77TJz4ILA2++33DDNmbEMNyBe2j8KZQkuY\nWZsfYGXg6RbO7QrcGba3BB5soZx15HjWH+BV4HNhexC+ZNlk3E0BvgL0H4Flw/5oYKewneBrXhbq\n6oEb0jFFx+4HDg3bF+ADJcPD59+4GwV8fcsP8PSxDeE+a4VzE/EHSKHOgcBC3C8ufKm1j4rqWhuY\nCwzq5HdSk20VP/HT2Q8TJ27GxIlPZi1HqzK28Ltrs+ct6XpgO2C4PEb4HLyHh5ldbmZ3hiiKycFQ\nHN1WnXXE7ZIW4ob3WeCnwP+Fc6fjA5EPShqOv238miUr45S6alpz3XwPf0A8FfZvDMcws0ckHY0P\npqyCu15Owlf2WapeM5st6avh+t7A7fjip4XzL4T2fEVSAzDWqjhoGYnUIJsCj2ctRGfI3QzLZlwV\ndUkt6tGVtqpFfbpCnvTJky7Qfn2UpivguUp+YUlSlfkbnaGl312cYRmJRLodISf3P/Exot9mLE6n\nyF3PO1I5YltF8oLS9HvAaEuSmnfztvS7i1kFI5FIt0JpOhA4Adgqa1m6Qu7cJnmJWc2LHgWiPrVL\nnnSB1vVRmjbgQRd/syR5qWpCVYDY845EIt0Cpen/AUeyJMVFXRN93pF2E9sqUq8oTXfHw203tySZ\nmbU8HSH6vCORSLdEadoP+AXwxXoz3K0Rfd41Sl70KBD1qV3ypAs0q88JwKOWJHdnIE7FyJ3xriSS\ntpH0QtH+FEmfy1KmUuR5xb+btRyRSC0QUr0eDfwqa1nKTfR5t4CkKXjekH+1UubVUOaeMt7zmHLV\nV25qta0ikZZQmo7D00WsaknSlLU8nSHOsOw4RhlT27aGpMLYg0Hnc26HfCWRSGQJZwE/qVfD3Rq5\n+7FX0n+n5hfwHSfpWUkz5Ot99i4qv7t8+bLCAsbrF52bIuk0SU8CcyRdh6eCvV2+TNllodxNkt6S\nNFPSvZLGFtVxdXCT3ClpDjA+HLsgnB8q6a/ypdhmSLpd0uii61NJ50v6t3xZtLskVST3dzfwq9Yt\nedIFluijNB2LJ566MlOBKkTujHeVEb4Kzk7AasCawHcB5AsxT8BX3BkGXA7cJqln0fUH4yl1B5vZ\noXiu793NbCCebhbgDnyZtWXx7Gd/KJHhEOACMxuAp5ItfmNQkGFM+HwM/LKZ64/CV8fuBZza8a8h\nEqlJjgOusiSZl7UglSB3xrvK2dEM+KWZTTWzD4Dv48YQfDHmy83sEXOuAebjOc8L1/48XDv/UxUH\nPczsavOl0xbgy6NtKGlgUdFbzOyBULZQj8L+DDP7i5nNM1+q7UI8vW+x/FeZ2WQzm4f7Bjfq2lfS\nPHnKWgf50idPugAwceJYpekkfAnBukw61R5qPs5b56ksfmc7p2IDbcVulNfxJc0AVgKOlPSVovM9\ni86XXvspgg/7QmB/vOdd8NsNB2bjxvfNVq7vh09M2BkYGg4PUBgBCfvF+byLl2aLROoOpelO+Nvv\n/sDTliSzMxapYtS88e6o0c0gN/GYku3CEnCv4wsQX9jKtS0u2BD8disCe+Ir+rwmaQgwg7YHNQv1\nnIK7csaZ2TuSNsJdL2rm3hWlu+aMrgfyoovSdAvgWi699AK75Zb/Zi1Ppcmd26TM9JLUp/Dh0w87\nASdLGi1pGPAdlviqrwC+JGmcnP6SdpPUWs92Ou47LzAAd7XMkNQf74WX3r8UFR0fgPemZwX5zmmh\nfCRS1yhN++IDk1/h1lufzlqeapA7413mHsSd+JqPhc85LN1jNXwA8R/4Cu8vsWT5ssfwwcpf4r3l\nl/CkOK31eH8AfFe+6vsmwDX4qvJTgWeAB5q5f3O998KxS4G+wHvAf/EV7ltbnq1i4ZF56NkVkyd9\n6l0XpekAIAUeA26sd33aS5ykE2k3sa0itUCYNbkmvjD6ysDe+Fvr0ZYkVXUHVoNuM0knLzGredGj\nQNSndqknXZSmo4En8bfdU4HN8V73yQXDXU/6dIWaH7CMRCIRWNzjvg5fd/L8PPayO0J0m0TaTWyr\nSJYoTTfDAwLWyON095aI+bwjkUhdojTtBayPh75e050Md2tEn3eNkhc9CkR9apda1kVpuixwL/B7\nPH3DFW1eU8P6lJM2jbekXSS9IOklSac3c364pL+HBEzPSDqqIpJGIpFuhdL0AOB5YCKwriXJfpYk\n0zIWq2Zo1ectqRF4EdgBjzV+BDjEzJ4vKnMu0NvMzpA0PJQfYWYLS+qKPu86J7ZVpFooTT+LD0x+\n3pJkUtbyZElnQwXHAZPNbEpIjHQDsFdJmbeAQWF7EPB+qeGORCKR9qI0HQpcDZwUDTcjWjrXlvEe\nzdLJk94Mx4q5AlhX0jQ8/vJrnRGyXGTt75I0QtJ9IT/2j7tQT1JGsTIn6lO71IouStNeStMT8ZnE\nt1uS3NypempEnzLxz5ZOtBVt0p44wjOBJ8wskbQa8E9JG5pZXWfzki9JthywCPgI/xJPNrMP27j0\neOAdMxvURrlIJLI0PwfGAicDNbkUYDWRWJ8l2UA/RVvGeyqe2a7Ainw6BelWeB5rzOxl+bqOawGP\nfloYXQ1MCbszgSeKziWhjrQW9oHewHfM7BJJI4D/4AsqHNLa9Xgq2Oc7ef/G4jUzi7O9Zf19lPZm\nOvF91qQ+Xfj/yI0+ZpZmLs+XvvRjVlttPzbffHVLklmSEtWzPl3Y920dBTtsDcu8BqxAc5hZix/c\nuL+M5w/ohRvbdUrKXAycE7ZH4MZ9WDN1WQv3aPZ41h/gVWD7ov2LgDvC9pZ4oqcPwneyXTh+NfAJ\nnglwNrB9+N4uxR+EU/H82r1C+SR8X6fhYwfX4MmvbsJDoz4EngLWAM7A8ze8BuyY0XdSk20VP/X9\nYeLEg5k48WUmTlw7a1my/oANBvs+2FSw+8GGtfS7a9XnbT7w+GXgLuA54I9m9rykEySdEIpdCGwm\nX4vxbuA0M5vRWr2VpMz+LoU6VwB2AR6SrwH5V+B8MxuK51f4s6RlzOwoPMvgj8xsoPkq8N/FB343\nDJ9x4ViBEfir0Rjc5SJgd/yhMBSYxBK/1/LABfgbQF2RMz9krvTJUhel6Qa4u+RAS5IXylJnnbaN\nxFbAC8AovOO3rRkt29LqPVGaf3q0dLwL90nKVM8UvPf8Ib6CzV+ARuB04JqSsn8HjgzbV+FrShbO\nTQZ2KdrfCXi1ICveS+9VdP5c/GGZhP09ghyFsM6BQZ5B1e8VdL6tytUutfLJkz5Z6cLEiaszceKb\nTJx4UB706ZrMtjfYO2C7fPoc1tw1tT89Xh1bBi2kFWvmRIfjkw3Yy8zukbQtcDu+EvVKwAGS9igq\n24OWB1iWx10dBYqXSgN418w+KbnmHVviW/0YeM9CK4Z98IUW2ho8rRmK9MkFedKn2rooTffEo9T6\nAd+2JPljG5d0iHpqG4l++ADtN4DPm/FYe6+tfeNdA5NCzOw+Sb8AfoT3in9vZse38/Jp+JhBYWLT\nmHBscfWlt+uCqJFITaM0XQG4DDgUuKc7ZgaUGIW7W4/BF0v5N7CV2eJgjnYRc5u0n0txf/W/gT0k\n7SSpUb5EWhJ84cCnlhW7Hl8dZ3iYgXo2PhjZEgU/e1Je8bMl6lO7VEsXpem6+Go3F1uS/KtShrsW\n20ZCEmMkfgo8i3ecNwT6mrFDRw031EPPu0Yws/ck/Q74Jr4o8I9xw7wIeAg4sVCUpXvP38Nnnj4V\n9m8MxygqT8l+W73xbtdbidQ3StMh+LjRaZYkv8tanmohsR4ekbc5MA+4DRhrxttdrnuJK7WytDQ/\nP+bLqB9iW0U6Q1hE4WbgTUuSr2QtTzWQaMBTifwGjy77ixnvdK6umM87EolUkbAw8AHAFsAqwEHZ\nSlRZJAYB6+FhfkfjM7P3NeP+Stwv+rxrlLzoUSDqU7tUQhelaT/cTXIIPrlsH0uS0qiqilA1H75o\nlFhN4niJu/FJeJcCI4GDgQ0rZbgh9rwjkUiZUZquhE9kexQ4zpJkUcYilRWJnsC/cD/2dOBBPIJm\nTzPmVk2O6POOtJfYVpG2UJpuCNwB/AT4WR5DASXWxFevX9eMjyp/v+jzjkQiFURp2pclESXXZS1P\nBVkdeLEahrs1os+7RsmLHgWiPrVLV3VRmq6sNP0tnqxtUtaGuwptswbwUoXv0Sa5M96RSKR6KE2H\n4/7fafgU78OzlagqrI7nLMqU6POOtJvYVpFSlKa3Ai9akpyWtSzVQuLvwC/MuKM69+vcGpaRKiLp\nXEktTp2XNEXS9mH7TElXVE+6SGRplKZjgM+ydIrjXCMhYB2i26T8lMvfFQzlXEmzJb0t6feSKr20\n2eLXoBb0WHzezC40sy9WWJ6ykScfMeRLny7osjdwW7Xit9tLhdtm3fA3Gu8axoDdzWwgnkBmfSrf\nw4guiUhdoDTtA3wR+FPWslSZfYCbzbLPL5Q7412JXL5mNp0Q1wkgaUtJ/5X0gaQnJG1XKCsplfQD\nSQ9JmiXpFklDw7lE0hvFdRe7QvAHRh9JNwC3SXpM0gbNyVTqYpG0dZFMr0v6Qji+m6RJQZbXJZ1T\ndM3KkpokHSnpNUnvSjqzLF9aCfWUY7k95EmfjuqiNO0BTMDTHP+tEjJ1hUq1TUjl+iWgJsIgc2e8\ny0yHlkEruu4IPLfBKGAhvsxTSxQ/wYUns7kRXwLtOuAWSY2tXSdpJeBO4GfAcGAjlizuPAc43MwG\nA7sBJ0raq6SuzwJrAp8Dzpa0divyRropStOBStPzcKM9DDgqj5NwmkOiP55c6zdmPJK1PJBD411G\nf5dww/khvvrNy8D38VCoO83s7wBmdjc+DXi3cJ3hy6Q9Z2ZzgbOAA6XmlvdplkfN7GZgGzyVZB98\nwePm5CtwKPBPM/ujmS0ysxlm9mSQ714zezZsPw3cAGxXUtd5ZjbfzJ4CnsTdRGUlTz5iyJc+7dFF\nabo28DCwKp6vZFdLkqpNBe8I5W4bicH4ouAvAOeXs+6uUPMzLJWmHXuyT5yI0vRThy1JqrkMWrFr\n5HWgJ94jbg9vLhbAzCS9ydLLpjXHisArzZ2QtAXwQ9zl0wvojffsiynOLTwX6N9OWSPdAKXp/nju\njjMsSa7MWp5qILEFcAmwNv6buQn4Yi34ugvUvPHuhNEtvwwdXwZtTMn2AuA9PEVkv8KJ4A5ZtuTa\nFcM9U0kNwAosvWxac7yOr/LTHNfhbpudzewTSZfQ/gdJ2ciTjxjypU9zuihNB+OTUb6Ov/ntaklS\nE+6Ctuhq20jsC1wOfA3/vc80o+aSa+XObVJBOrIM2uGS1pHUD3/NuiksIPw/fEByV0k98eiV3iX3\n2VTSPpJ64D+ceXjWsta4DthB0gGSekhaRlLB9TEA+CAY7nG4i6Wt3kPmD8xINihNhypNJ+BvjxPw\nrHkb1Yvh7goSvSUuxd2Vu5pxnRnv16Lhhhwa70r5Is3sPaB4GbQzgXfwXu8pLDF4hq9ReTXwFu6q\n+GqoYxZwEnAl7h6Zw9IuFgNuwZPWzwIOA/Y1s+b+eRYvl2ZmrwO7BjneByYBhSiVk4Dzg+/+LKB0\npe7mDHnZXw3z5COG/OijNJW23PJQpemhStNfAi/irrMVLUk2siQ51ZIk0wRMHaUjbSPRIHF4MNoP\n427RjWtlULI1cjc9XlKS5SutpIm4W+W3XawnUz2aoyttVYv6dIU86KM0bQSe49FHh7HZZvfia7He\naknyv4xF6xLtbRuJzfE36kZ8HOh/wB215NeGbpQStkZ+UF1+GNWIHmUj6lOTjAAG26mnlo671DVt\ntU2IHvk5sCPuuvxdrbpGWqNNt4mkXSS9IOklSae3UCYJE0GekZSWXcr6o6ae3JFICyyPL92VeyQk\nsaPED4AH8LGktcz4bT0abmjDeIdoiF/iE1TGAodIWqekzBDgV8AeZrYesH+FZG0XWfsizWx8V10m\nkL0e5SbqU5OMBqblRJfFlOoTwv4m4pPY5uJjQ18yY3b1pSsfbblNxgGTzWwKQJi2vRc+w6rAocCf\nzexNWDywF4lEap/c9rxD9r+xwHl4qOM5uHtkYaaClZG23CajWToa4s1wrJg1gGGSJkp6VNIR5RSw\no+TEF5kbPQpEfWqS0cC0nOgCgMQGYN8GPgT+ic9+XtOMCXky3NB2z7s9vtuewCZ4Xox+wAOSHjSz\nzFMmRiKRVlke+E/WQpQLieXwvEMXAYeY8UHGIlWUtoz3VMKMv8CKFE3fDrwBvGdmHwMfS7oPz43x\nKeMt6WpgStidyZLkSYv9VIVeQGf3C8fKVV+G+18HnqgheRKKyIs+eWufDu2ff/56bLPNTaW/nZqR\nr0P7x50I+54Cu04APQNsKNWSfO3fD9tH4UyhBVqN8w6z/F7Ee9XT8CD2Q8zs+aIya+ODmjvjswUf\nAg4ys+dK6moxzrtFASI1R4zzdvKgj9L0OeBgxo8fVm+6BJ/2YHxSzY745LnvAZeBtqs3fVqjU3He\nZrZQ0pfx+f2NwAQze17SCeH85Wb2gqS/A08BTcAVpYa7jXvEqdjdgDz9mKD+9VGaLg+MBJ43swVZ\ny9NeJHoBF+B5tYXPcH4FSMwIk4vqu23aS+YzLCORSPVRmn4J2NqSpG5We5dYA08YNRcP9St14eaS\nlmxnzG1So+RFjwJRn5rjMOAvULu6hIk1m0j8QuIN4L/Av4C9WzPctapPucnd9PhIJNI6StMEX+Xp\n1oxFWYxEX2BjfAWpYfhiJLvhydv+BGwPTK61vCNZEt0mkUg3Iqw/+QjwY0uSTNdiDIOOW+CRFQfg\nvut38YyaD+NJouo6SVY56DaJqSKRSKuciy8Mcn21bywxAp/tWPisi4cMXw1sZLbUhMBIG+Su552H\nEC7Ijx4Foj7ZEXrbZ+Ouh5HAVpYk7yw+XyFdJEbj6TRWAnbHXTUP4YuLPAg8A0wrtyukntqmPcSe\ndyTSffke7p44D7jfkmReJW8msR5wDPAF4DZgMh7a9x8zmip57+5E7nrekUhkCUrTEfiq52takrxb\nkXuIocCB+MryO+FrpF4PXGrW5vqrkTaIPe9IpHtyEnBjJQy3RCNutH8C3I9P1DsFSGMPu/Lkznjn\nxd+VFz0KRH2qi9K0F+7jPhl3mbRcthO6SIzD12qdARxgxn87KWrZqfW2KRe5M96RSATwZb62B86w\nJHm5HBVK9AEOx6NEDgNOMuNP5ag70nGizzsSyREhZ8lvgPWADS1JZnW5TtGAZwr9GTAfz5N9hxnP\ndrXuSNtEn3ckknOUpgPw5b6uAw62JJnTqXrExvjA42hgLXxFrZn4coeX1Ouaj3kj5japUfKiR4Go\nT1W4CHjAkuS8jhhuSYnEMhJfkLgfz3kyCp/x+EtgbTNWMeMn9WC4a7Rtyk7seUciOUBpujM+EWaD\nDl0ndoSrjge2wifQ/BL4c96WDMsj0ecdidQ5StOdgD8AB1iSpO2+TgzGF1k5Dw/ve7gyEka6QvR5\nRyI5Q2kqYH+8t7yPJcm/O1jFmsCLZlxUduEiFSf6vGuUvOhRIOpTxnun6b5K0xeAT4CLgZ06YbjB\njff/YtvUJ7HnHYnUCaGnfTpwIp435AFLkvldqHJNiClX65Xo845E6gSl6en45JjPW5JM7XJ94no8\nXvvaLgsf4lrrAAAgAElEQVQXqRjR5x2J1CFK068B+wHL4CvMbF4Owx1YF7ikTHVFqkz0edcoedGj\nQNSnE/dwN8kZuF/7YGBtS5KyLLorsRPQF5gU26Y+iT3vSKR2WQVYCNxqSVI2/2bIBvhj4HQzFig6\nM+uS6POORGoUpenhwJ6WJAeWtV7xBeCLwDZxQd/apyXbmTu3SSSSB4piuO+vQPVfBc6Phru+yZ3x\nzou/Ky96FIj6dJj98VC+K8tZqcQm+ODn3UuOxbapR9o03pJ2kfSCpJcknd5Kuc0lLZS0b3lFjES6\nF2EhhR8CJ1uSfFy2ej0f98/wzIBxpZs6p1Wft6RG4EVgB2Aq8AhwiJk930y5fwJzgavM7M/N1BV9\n3pFIO1CafgnY15Jkp7LUJ5YHJgDbAHcAh0TjXT901uc9DphsZlPMbAFwA7BXM+W+AvwJqMgCp5FI\nd0Fp2g84CzizLPWJscB/w2eUGQdFw50P2jLeo4E3ivbfDMcWI2k0btAvC4cyHQTJi78rL3oUiPq0\nm5Pxae+PdrUiic/iizOcZcYFZsxuvlxsm3qkrTjv9hjiS4Fvm5lJEtCia0TS1cCUsDsTeKKwUGjh\nC+/qftG9ylJfVvvARpJqRp6oT4X1Oe6477PSSjuxzTZrAJ/puryHHgNH/xR2PNiMu7L+vuJ++/fD\n9lE4U2iBtnzeWwLnmtkuYf8MoMnMflRU5hWWGOzhuN/7i2Z2W0ld0ecdiTSD0nQscC9wLPCoJcm0\nTtclRgB7466Xb5pxY3mkjGRFS7azLePdAx+w/ByetP1hmhmwLCp/FXC7md3cXgEike6M0rQBN9w3\nWJL8qkt1ic2Av+HBA78z464yiBjJmE4NWJrZQuDLwF3Ac8Afzex5SSdIOqEyonaNvPi78qJHgahP\nM3X4RJxzgF7A/3VNHtYGbgeOM+PQjhju2Db1SZu5Tczsb/jTvPjY5S2UPbpMckUi3YFvAfsCO1qS\ndHphX4kxeAfrdDNuLZdwkdom5jaJRKqM0nRFPLz2IOCzXckUKDEKSIHLzLi0PBJGaomY2yQSqQGU\npiPxsaMhwLjOGm6JrSR+hE+cuyoa7u5H7ox3XvxdedGjQNRn8QScPwG/sSQ53pJkesfvSw+JC/EJ\nc3OBfc34YUfrWbrO2Db1SMznHYlUAaVpb+BmYDJwXqfqEKsCVwBNwKZmcUZzdyb6vCORCqM07QNc\ni8+HOMiSZGG7rhP7AMcAqwOj8IUZfgZcaEanBzgj9UVLtjP2vCORCqI03Qi4CZgEHNEewx0SSX0b\n2A3PcfIsPs/ig5iDO1Igd8ZbUlI0hbluyYseBbqTPkrTEfhsyb3wXvOXLUmub7kulsFXtlkXWA1Y\nCw/P3dSMmWUWvZn7d5+2yRO5M96RSLUIk2zWxY3tAGALPH3ysrjxPQ14yJJk3lLXCeHRJjsCe+A9\n7FvwmZG/B1IzPqmSGpE6Jfq8I5EOojQdBRyPJw8S8DjwMe4a+SfwtCXJ4rSrEiPxyTg7A5vh/uuP\n8WnxtwO3mPFWFVWI1BGdym1SDQEikVpHadoX+BIwHhgIbAT8EZ/S/mTxyu4SQ0O5HYBV8SXHVgfu\nxA31Q8DrccAx0l66jfHOi78rL3oUqEd9lKbDgcPxaewP4REjHwEPMX78Rp6+k/WADYFBuAvks/jC\nB3fj+YBmAY+bMa+ZW9QE9dg2rZFDfWK0SSTSEiEO+yC8xzwaGIb3nO8E9rAkeXyp8oDEd4CTgPtw\no/4H4AAzPqqi6JFuSu563pFIR1GabgFcB7yEz4Ccgi8W8oIlyRwAiZ7ASsBgIAH2w33XW0V/daSS\ndBu3SSTSGiFCZDs8jG8T3Ic9Cg/na2bhbFbCk0gdBXwIzMZdKDcD98SokEil6TZuk7z4u/KiR4Gs\n9FGaroAb6UHAWODzQG/geuB83Bg/a0nykctJX9yHPQI4BA/nuwrYzGzJklRBn1wY7vi/Vp/kznhH\nIqF3/RV8osxovKc8E3gZ+CZwX3H+bAkJ1gGOA44EXgem42F/x5vxYXU1iETaJrpNIrlAaXoo7g4Z\nhPeahwMnAg+WLnQgsUIom+ATbNYGPsEHHC8345XqSR6JtE70eUdyi9J0GN5bPg3vYc/lP8s8yHfX\nH4ob5zG4q2Qt3GAPwSNEUuBp4CUzOr0gQiRSSaLPu87Iix4FKqrPIjZkep8ZHLbll/Ae91CgEY8a\neRF4DZ/R+ASele9ZM5paqK1d5Kl98qQL5E+flsid8Y50Q97uM55JQ4fjU9DfIvS+Ywa+SJ6JbpNI\n3aMJj9zLfcsOsN+tvGnWskQi5SauYRnJLwMXrsu7ve/LWoxIpJrkznjnZf26vOhRoFL66OeTtqSH\nDeHeZa+rRP0t3jdH7ZMnXSB/+rRE7ox3pPsgsRav97uFJwdPso96PJK1PJFINWmXz1vSLsCl+Aj+\nlWb2o5Lzh+FhWsJnrJ1oZk+VlIk+70iXCavOHAB8huHzd+fah3ojW8922m5KxqJFIhWh06GCkhqB\nX+LZ1qYCj0i6zcyeLyr2CrCtmc0Khv43wJblET0ScSSOAn4C3AWkXPEo9G56z5JkSqaCRSIZ0B63\nyThgsplNMbMFwA14Up/FmNkDZjYr7D4ErFBeMdtPXvxdedGjQFf0kWiQuAg4A9jOjMOYmP6DIQv2\nAH5cLhk7JlN+2idPukD+9GmJ9sR5jwbeKNp/E1+rryWOxXMgRyKdJqzz+Bm883AgsADYionpGkp5\nA58Gf7ElydsZihmJZEZ7jHe7A8EljQeOwVcTyYS8zKzKix4FOqKPRAPwO9x43wVcDPyFienmwG14\nB+GvxcuPVZs8tU+edIH86dMS7THeU4EVi/ZXhE/ngZC0AXAFsIuZfdBcRZKuhsVpNWcCTxS+6MKr\nTtyP+8CX4fZN4diTzN75B4BWW21PHj3xt2y22RcsSe6QlKh25I37cb9s+2H7KJwptECb0SaSeuD5\nIT4HTAMeBg4pHrCUNAa4BzjczB5soZ6qRJvkJa9BXvQo0F59JMbiSaM+Y8ZLAErTnvjiBy9bkny9\nooK2kzy1T550gVzq07loEzNbKOnL+OtrIzDBzJ6XdEI4fzlwNp4M6DJJAAvMbFw5FYjkH4mtgRuB\nb5rxUjDay+DJpISHo0YiEWJuk0jGhIHJw4C9gW2BI5mY3o8vpvAdYC5wL3CkJUnNrsAeiVSKbpMS\nNlI/SPTC5wRsgE8CO5GJ6W7Aq7jrZENLkrgwQiTSDLnreefF35UXPQqU6iMxBPgzjU1z+P3DlzJq\n3gBgG+BgYFdLkmcyErVd5Kl98qQL5FKf2POO1AYSq4LdxsmT32O/qZsifoavhPMysKUlybSMRYxE\nap7c9bwjtYnEKOAsYF1Gfbw+Fz79OivPbQAOtyR5qo3LI5FuS8znHckEiT4SBwCPAbM54eUbufah\nJlaeexPey46GOxLpBLnreefF31WvekgMBz6P57cZDOwJvMcmZ0/ip9uvhadWONiS5K4Mxewy9do+\nzZEnXSCX+sSed6QySEhie4lbcb/13rjhnsXIj8/mnnQ6Bw88FJ9os0a9G+5IpBbIXc87Uh0kRgKn\nA2sBqwKLgJ/zw6fuYYsZh+MJzfoBWwF3AydZknySlbyRSL3Sku2MxjvSIST6A6cAXwOuBv4FvMPf\n73uL3k2n4RNurgOeAj4GJluSPJSRuJFI3dNtQgXz4u+qJT0kegBrAAnwXXwCzWZmvAqgNO0DTAQm\nAVtYkrz86TpqR59ykCd98qQL5E+flsid8Y6UjzB1/QB8wYMFuHHe14yHAJSm++IDktsC/wa+bEnS\nlJG4kUi3IrpNIs0isTGeEGoQ8FUz7lvqfJqug/fAzwSesCSJCwBHIhWg27hNIp3HZz6yAz5NfUc8\nW+QEMxYtLpOmywNfBY4DzrAkuSILWSOR7k7uQgULSc3rnWrqESbSnIKvP/oZfELN2mb8psRwjwae\nBfoD4zpiuPPSLgXypE+edIH86dMSsefdjQk+7UOB7wNPAlub8WIrl3wWuNeS5CvVkC8SibRM7ox3\nXkaZK6mHxJr4LMgdgTHAEWbc345LNwM65dvOS7sUyJM+edIF8qdPS+TObRJpHYkjgP8AawO3A1u2\n03ADbE4njXckEikvuet55yXGs9x6SDQCX8bjtLcz47l2XZemA4AvAVsDm+L+8E7cPx/tUiBP+uRJ\nF8ifPi0Re97dgODb/glwELBrBwz3jsDTeI/798BGliTvV0zQSCTSbmKcd46RGA/sAowFVgS2N2NG\nm9el6XDgV8A44GRLkjsrKmgkEmmRmNukGxEWPrgYD/u7ApgO3GjGhy1ek6YbAKfihn41YAJwliXJ\nx5WXOBKJtES3SQmblxjPzuohcSKeFOoVYKwZ3zfjypYMt9K0UWl6OPBPPFzwRGAdS5JTy2m489Iu\nBfKkT550gfzp0xK5G7DsjkiMAPZiyaDiNma80GL5NB0BrIsvmPBlYCGwvyVJe6NOIpFIxkS3SZ0j\nsTOemvUevOd8lRnvfqqcR41sBxwLjAeeAN7FF0i4MSaUikRqk5jbJGdI9AS+h8+QPMSMdKnzabot\nvljCivh09pHA43jUyFGWJC36vyORSO3TpvGWtAtwKdAIXGlmP2qmzM/xGXtzgaPMbFK5BW0veYnx\nbEmPEPY3FrgSmAFsYsa7StN+wBBge2B/fAWbU/BQv4+A17JcySYv7VIgT/rkSRfInz4t0arxltQI\n/BLPNDcVeETSbWb2fFGZXYHVzWwNSVsAlwFbVlDmttgIlu6F1ilL6REW9v0OcCT+kLyUc5/9Odu9\nu69SvgWsB3wIPAD8Ce9dz6y61C2Tl3YpkCd98qQL5E+fZmmr5z0OmGxmUwAk3YAPjD1fVGZP4HcA\nZvaQpCGSRpjZ9ArI2x6GZHTf8iINVZr2YsLKg/jHyFMZ3XQ8Y+b+k32mHsfmH3wIbAK8iD9Uzwf+\nWuN+63y0yxLypE+edIH86dMsbRnv0cAbRftvAlu0o8wKeGxxh1CaChAewlj6t33bw4YNUpqO6eB1\nHbtH+6/rhS/C2z/87deO/QHAMI48cgBwBke81sDhrxuNNp0etgbwLWA+8D/gMEuSBzr6PbeJpAMP\nQHetxuCeTSx47yI+KpwpLXrudtivx7FcYf/d/nxk59gcnafl+n+CbfQ2H782mEEN/Ri4wikaPaMv\nNnKO/98ZyIR6LfKQ1cK+gXotQsc9zpuTRtHrsVEsN3IOs14cTq+3BtK7IMvI2fTot4DGd/qzcNmP\n6NmziQUv/pKXvSoagIUn78qgu1Zn1cYmb5dGo8FACxtg8jJ8MmIOPbd6nbdfG8LIhQ30bDS03EfM\namyi4f1+DG9ooqHRaDChBkMbv8Vrk4cxavCyrLnzEdorHG9oEpP+8Xs+Ahq/tw2jHlyRNRoMff4l\nnr9rddbt9wnzxr7H24+PZLUGaJAhQYNBg0AyGnZ8hafeGsDk55ZlX9xN2WiiYb/neGTQfBb9bkO2\nkuvVKGg4ZhL3bv8qs3+1Oas8PJr1Np/Gc88sy+of92RAqFOChib8rwwhPw40mjdow2qj+cxxe2ro\nWu/zwrv9WXZWb5bt0cQnv7qTvwA6dzu2nj6AFRv8OgSs+T4vzejLsBl9WQ6/T+G3W9BLfRcw94f/\n4lZAF27D9u/2Y/nGJhZt9xoP3LMK2xbk2XkyE+9aje0RyNsnbC6R11h8D3Z+mbv/sSo7BFkUdKX/\nJ8xe633+t8loDj1zB42ToZ6L+GTLN3n0v2PYWuaVHvoMd6z5PrPuWIN1Jo1iM7+R1yFDo2fz2hFP\n8SCg6f3p//sN2BNoQP773uFl0o2m8zZFOhf9Ptrz+Svu3uzXwu+qXYEdrUabSNoP2MXMvhj2Dwe2\nMLOvFJW5Hfihmf0n7N8NnGZmj5fUZUycOIfWjR74D8+ApqK/7d++4ILBnHXWjA5c15F72IaTJ689\ndPbsZRrM1NDURIMZMqPBjIampsXbMqP3ggX0mzePfvPnW/+PP6bf/Pn0mzeP/uFT2J/Tt+89g+bO\ntTHTp3+u/7x5NuzDD/nK3Lk9roFFhX/k0qZpZV9FX6I6Ech/QhNc0MASgxw4EB/s7FV88N1+HLjM\nXG4CuHkd5h9wEGfbOXaRztOru79I063Xs4oJHW1wleDAA/jgjzcxtPSmzcUh9WhiQTC0PRqNReeM\n5/Hvb8syQT1+ehfDvvwQQ4/em2kTbmVUo0HPJv6Kdya+COzXBH9e2BAeFuEeBkwfwCcrf4PnfnMb\no4+exNCFDTQWzjd4DnNb0EBj6XW9FzHvk0Z6Hr+Qnr/uxcKCrH9bnZ8e+gz7AEPmNdJrTi/6Azbw\nE2Z/2JuBDcaiPgv5OBwv1GcWGtfAhsxj5jPL8fXRs7kKW3xfW2Yu7zcYTe/0ZzgAwgxsuY94p/ci\nFnzYi34f9GXIkHnMnN2LAQuD3ICFsgXxF1drfg4M+9pHDLp0ALMGzWfW/B70ntdIb8Gi1T7gdcCm\nDmTZj3q6PoXvYvA8Zs7vQa+5PemzuL5wD3D5ejaxcI0ZTAHs1SGMmtuTfjJs1BzenjaQkfJyrPAh\nb705iJEUycnS9S11PJQfZcX3E/RcxCdD5zHzsIVs8tMhvAYgo2nUHKa/OYgRBf3Xep9X+y9g3rQB\nDJk2iOWs6PswsMHzmLX2+7wB2LxGGh9fnrUwmhTswRrv89rwj5lTJONSurfjczM+87lvM/p9al9w\nVodnWEraEjjXzHYJ+2cATcWDlpL+D0jN7Iaw/wKwXanbRFJ1YhIjkUgkZ3QmVPBRYA1JKwPT8MRG\nh5SUuQ2f6HFDMPYzm/N3xxjvSCQSKR+tGm8zWyjpy8BduA9ugpk9L+mEcP5yM7tT0q6SJuMhaUdX\nXOpIJBLp5lRthmUlkNRgZrUcYdHtUJgOlrUckUjeqbvEVJLWk3QkQL0bbkmDspahXEhaH8DMTFLd\nu8gkDZW0SthubKt8rSNpZUkDs5ajHEj6jKQ1wnbd/691lroy3mHA9D/ANyXtGI7V3Q9L0r6SXgW+\nIKl/mxfUMJJWkXQf8DdJhxUOZylTV5F0Oh6KeSmAmS2qVyMhqYekS/Ask4dIqtuUGJKWkXQX7sY9\nUFK/vHQWOkNdGW/gBeBw4CLgGKi/H5akMfjCv4/iebPHZitRl1kLN3SnAvtJGmxmTVJnohSzJ3QG\nCvH0b0k6tnAqO6m6xNrAW8Bp+EzpMdmK0yX6AXcAXwMGAtuAv+1lKVRW1LTPW9IGwPTi6JVgFFYD\nzgEmmtkESY1mtigrOdui4AcOD5k+wFDgHeAXwEvANWb2XpYydoRgoGcV7Q/DY1a/C7xuZj+oJ9+3\npMHAnML/kKQhwCfA7sARwDFm9m69jLFIWtbM3g3bvYDBQf7r8Fzvl5jZ/EyFbCeSRpnZW2G7N7AI\n/w19C4+7vtzM3q6n/7dyUZO9ozDF/lY8C95ukvqG44Ufz2vALcA+oXFrtvct6UxgIngPwcw+xh9I\nC4Eb8TwMG9aD+0fSjiGq6MRg8AoPphl4KOmfga0lrVsPr7OS+kj6A3A73g4AmNlMM5sL3A+8jIfC\n1vwYi6SVglvhfkmF2XsLgELH4KfATsD6te4+kbSlpOnAPwrHzGy+mS00szl4CuRhwOfCuW5luKFG\njTeexvQePKXpevir3+Ifj5l9AjwETMZn/oG/6tYMkhokfQNfIGH14K9HUo9CD8/MJuLpBMazZKps\nTSJpFLAbMAlPf7AeLBmgDD+eJ/AHbsHV0K9W3SeSegJ74DNG3wDGSRoazhVkno7PY9gs6E+ND/od\nj7sWHwLODccKb30NZvYY3n6HhzDgmny4hgfPNsCZwGxJR4fjKpL5Przd1pY0sN7HjjqFmdXEB3+C\njg3bhZwgvfE1GL8CDA3nVHTNpngvfA5wXNY6BJl6Aw1he2M8V8nawExgYDjeUFRmJTwT49fxgZj1\ns9ahSJdGYPkivcaE7UvwH9bIZtpkNN6TTYHLgSFZ61Gi05ii7eVDW+wIXIPPDC6cK9bpq8C/gf8W\nl6mFDzAK6BG2VwQGA+vgqYDXKWrHhqJr7sJTCj8BbJS1DkGmHsCaQL+wv2r4uyvwXOG3E44VfjtD\ngJ/j40dvFf4fu8snewH8H+4J3LVwN3Bc8Q8ezxN+Nd47LfjoewCrhH/QFNi8BvRoDA+aG4Hzio4X\nZL4euDZs9yy59hm8l3d+1noUyXRiaJc78Pzgw4rObY7nOdmtoEvR328CH+CZJodnrUfJ/9k/8B7b\nRcAGJecvAs4GViy0Z/i7CvBwMCAHZq1Hkbyb4Csn3R6+6z4l588HbgrbxYZ7NTylcAqMy1qPINO+\n+BjQrXjej6El52/B8ydByIcUtg/D3UKX19L/WrU+tfBKuzZwt5mNB36IRy+cUjhpZn/DfXafMTOT\n1NfcXzwbONvMEjN7JAvBC4TX7DPwN4ZTgUTSWcEfX/DFnQDsIWlTM1tQeP2TdBRuGNYxs7PDsUxf\nZ8MA5B54ZM8vcdfPtwvnw/f9Iv5AHRKOLQh+1LXxZGZfMLP3ashtcgBu7HbBByO/IWnTovN/wP/3\nNgaPYgrHE+A2MxtrZjdCTbSP8IiLX5vZHvhb0SVFfm6AXwErSdrJPPqnbxhX2RY4MfxuHq6+9EsT\n3B17AXuY2V74G+rXJa1bVOw04KDwe2oCCvMjPgESMzvB6mjAv2xk9KQdAfQK298GbgnbfYDP4L29\nzYvKLwdcG45PIbzK19InyHds2F4H75kegv+wCj2FU/Aezwa4K6gn4ZU3nO9B0et6leXvWbS9LfDv\nsN2AD+b9Gf+BFcosixuIr4d2SUrqayD0Xmvhg/dQ9w7bo/CH7NUlZb4I/AD4MXBVM3X0qKSMHdRn\nArBP2B4C/BPYh6V72Xvh7p4LgG/UivzAoJL9h4HdwvZY4Ee4q6r4t/Fd3N3ze2roDTXLT1V7RZIO\nlfQk7qe6MRyeAIyWtImZzcMXepiIv6oX2Aw3hB8A25jZtCqK/SkkjZb0E0nHhnBG8IG6/pL6m680\ndD/+IFrBwn8fcBVuGO/EQ+oWmL9FEMIdFxaVrRqSzgN+L+l8ADO7D+glaQ/zns5LwN/wiRENocy7\n+JjDWcDzVrTsVCEqyDIK35S0jaS7JF0oaY9w+B7cJYd56NkdQG/5SlAFZuMP2HH4q/jiXnYYlF1I\nBkg6QtIdks6XJ38DH+fpGd5EZwI34GGNxb/p4fhyeBsA12UlfzGSzgbukfQjSQeHw38B1gv/N8/h\n4YwrAqsXXVpY4u8NC2+o3Z2qGO8QeXE47kc9ycwOwhvrmGAEbgFOCsVn4YMPJqmXpD74P+HOZna4\nmb3R3D2qhaQT8d7zQryXcI6k5fCR71XxV2+AP+IRMIUohY3CsYvMbAUzu7W43iwMnaTVJT2ID5pe\niIdlFtL9TsCNAWb2Ee5y+AgYEwb998H99BuY2amhPoXymYTUyWcTnom7eq7BIy+uCe6c3wOLJO0d\nir+Dj5mMCNeOwH2vJ5rZdmb2YFEUDRk9VAdKugafkPYT/C3u6ODWehSPQx8R5JuAG7sdwrVb4T3v\n8Wa2l2W3shVBnpGS/hhkPBo30F8L0TtP4wtkbxeK34t3DJrCtdvh+a1XMbMzqy17zVKtLj7ee16h\naP8I4Ldhe1X8te+4sL87Ja+0tfDB3RznAuuF/dG462BrfJT/V8DJBT3xuNrzwnYPfLJEoa7MX2Hx\nh88+Rfsb40a6d9DtBuBb4dxg4F+EwWSC2ytsLxXNkKE+/fDQ0RFFx+4Ejg7bR+IP3kJ0xsW4sYYS\nF08ttE+Q4+ssibQai3d0Rof9G/AOUSEK6HvAwVnL3IIeA4FDi/aXwx+wa+IPoDPxQeNlwvk/s8SV\nkvn/Vi1+qhmo/7SZzS/qzWxIWAvTzF6R9APgx5I2xyNMzquibG0SXukWSPoN8C6AmU2VtI5v2ixJ\nt+ADYj+QdDG+EPN3QtmFwKwit0Pmr7B4voupsHjQtR/wjPnsu6mSLgJulvQOPjg5h5BG2DzWvuDu\nqYnZrWY2V1JqZu+EOG6AGXjUDGZ2TXCTXCnpIfw1/N/hXGF2ZcHlk2n7aMmEtN8EvXqY2XOSlsF7\nqVNx9+MBwPjgjjwcjwCqKcJvfrZ81a0CBqyP5/9/R9Kf8clQ10t6G+/QPQW1PzkqK8ruNgkukk/V\na0um4xZmEg7AX5cK5+/B/dx3AzuYvwZmiopmPdqSCULTghGXpAG4m2dmOPdP4Pv4K/n3gD9ZkS+4\nUE8W/4wttMk8C9PcbckoflOR++Nx/JV9WVzP/a1kVD9Lw11on+LoDzN7J2wuNLMF+ISiYhmPw3vj\nWwKnmNnNxXVmZShUlGEyGLvC/9vc8HehpDXx9UufDsf+i78JTmSJa/HZKov+KdTCbGEzm120uwww\ntdBeZvai+fKK/4ePH42zjF2kNU+5uvD4hIdlivaXeq1upvy9+PTWdYAzsn4FKZFNJfsbsfTIdyF6\nZE3g0aLjaxV0Z+lR/0wiSAr3ppnXzuZkwuPpjwjbCc24Dpprywx0Km6Lfq2UWwt4PGwPAzZp7/dT\nZX2WAS4M26sX/o9K2wrYmeBODL+brbNui2Z0Kf6/X7/0/6VIl88DV4TtPYBts5a93j7l7HlfA+wt\naYCkK/CBom/Dp3tnksbio8fn4vG188ooR6cp6nFa2N9S0m+Bgyl6Symcx43DQ5K2kHQ/nmulAe/1\nNUlqLB70qjbBpWFBlvUknadm8m4X9cobgYWSrsdnUY4sqa+htC2zwJZE6IwHbgyDp831+NYA/i1f\nDeoR4LPFJ4M+Ztn1tn2BY7P3gZUl/Q/39baUaXIM0CjpO3ho6oCqCNoBwv/ampLuwOc+jCk5X/gt\nbINH+0zAk0zVhA2oK7r4lG1kyUy0vfHX0YvwgaBN8BHxM5p5Im+Fh/39FOif9ROsoEvJ/nr4aHeL\nbwUsyWz2L3xiSuZ6NPNd98V7ORPxiIs/sGSQrqHkunfwdANfzFqHErlK34TG4ZOEfotPWf8DS+YN\niHle9SkAAAtESURBVCW9u9ND+1xFmG5dC59iGcP+6viA3fu00gPFY9U/xl1zA7LWI8hU+rsZUvw/\n1pLueM6Yl1sqFz/t+O472WAqbbRw/DLgMUJ+jmAAXwaWLW5oYGVgpayVD7IUG7rCbK/hYf9P+Ow6\nKJl+HI59C/haS/XVwgcPm/sfsFnY3w2PeS7kLCm0ySjcv92/6NqaiLgokqdP+HsmcHzY3g4Pa/xa\nM+25Lz4voLCfeVRMiXw7hIfPqUG2U4Hbw7niSVOFNtqHZlw/GelR+kAtRIksiy+YUoiA6dXC9XvT\nissrftrRBh1ssJFA36L9VfG8Ct/EQwFHAA/gPetCgplbgFOzVrQduu2PvyncHXoFO+B+0rnA6qFM\n4UfUnA85c19wQbbQDufgOUhG4NkXk3B+MB4z/JOw35zvO7OZnsV6lPw9APhG2P4DS3JdDMTDTu8q\neiCV5o5ptrNRRV3G4FFIg4r02QwPW9y5pOxTwH6Ftiq0R9b/V821TdjeAc9i+JvQDmvieeq3Lrmm\nEGJaU7rU86ddPu/guz0ff6KuFY5tifdM78En1VyLj4T/A08Jul64fH64riaQ9DmFtQnDfl/5aikX\n40n3d8BfTw/Fp+t/nzDbjjBpwIp8pCHqRJbdbMKLJX03bC8XZJuJP2h3NJ+ccS2eCwPgQ+A6YCdJ\nG1n4RRXVJ8topmcxRd9xIQqjFz6x6zP4G956kkabRzDMx91DXwjXLiipy7JonxB59SN8cP54fFzo\nwnB6GeBtM7srlO0djn8fOEXSZcCd8oUvMg8rlbS8pA1VlD9F0tb45LqD8Q7Pxfj/3Vx8/CuRNCyM\nge0PNRMimwvaNN6SdsaNcw88HeYT/9/eucfYVVVx+PuhFrA09hFKUsLDgtaisRCINWJRKdSCkEZJ\nI4LCtAngg6nVpGIsSiGZWNGG0sZQpIlt/1AKhZq0abVUEKRgSkpb+xKRSvFB4quKISEmZfnHWoc5\nc70zc6/MzLl3Zn3JyZyz7znnrj1nZu191t77t+Kjc/DXvEP4QoJHzJfpLsd7Gl2SNuMOb+8g2N40\nsTJtHXCfpBuj+DV86tUoXHENvBf3F/yVuwufR3txPYcWjqFKR/cTPKfnFOD7ki41n5b5AHBWPL/b\ngcmS5oSth/AFUXtqb1ZVXeo0qsdLWkDkkcRVGf+Kh0mO4kqMayVdgU//2wVMkmfBaRVuwP+mzjaz\nT+H/L5+VNAd/I3pZkdTCfA3E281sPe7AX8QXUP2r/q2Hhui4deFvpHfgqn+L4+O34dP6rsLf9JaZ\nSyusxMOli/C3i8NmtnqITR/+9Nc1B6YDr5eOP4prJczHezwbgQvjs9F4g3A9/gBP7+/+Q7nhgymb\n8Ne7Hfgy3SIUsgjXfyjOXQ18PvbfP9S2NlifYmDu/ngOV+Mp1YrPl+C91OOADtxp18YqKw2PhA3j\n8UUn2+mOZQufi70RmBllH8YbpdlRp4V42G4aHg++q+q6lOr0VnzmyMfj+KT4eX2UTwU24wJMY/Hp\nqPfRIvraYetsXAKhC59HfiI+Y+cVfNHWlcCBsLuIeU+gW1Z3EiUd7twG+Pk0+BAfwkMky/G48Cy8\nR/FE6R/rFHz0//KqK9VPXdbhCmsX4HG6xXgP4tRw6PfEH+V+4Iq4pkf8tVW2kvMejy+imRuN5nVR\nfiGeqeeGOJ5ShZ0N1KNeo3ocPoj3lZoG6ReEbkwcj8ElCQ4C11Zdl5p6/RjojP23lMr34QPH5+Kr\nJH+Kx7qvqcLOPuyv7bgVA8Zfxce2xkYDNA+XVJgG/IoYm8htkJ9Pgw9xLC5KtKqm/Bp8ytYqfAly\nV9UVaqAunwS+Hvud4fSW4UvDr8ZDPKtp0d52nfoUbw634aGDj0XDMw2XNl0HTCud31INUMmu3hrV\nSfgU1FvxrCpbC2cR112GS55OrLoOdep0UzjniXFcZFK6E7ildN77qra1jzo8SPfCoPIMmD/E39p5\nwN3RAD3bag3ocN4azh4vaQkeA54ZuhHHzCfkT8ZXUu0ysz82dLMKkfQ5vGdt+KDq9/BpS3/DX9Gn\nA6+ZWZdcje6YNfpLqhhJL+EDk2PxMMmTZra4z4tahFhoM8XMlkrqxOUFVuNC/FPweOsY4BvmuRiL\n61pGW6WWWM7eCbxgZstL5evxRAqPV2Zcg8jzeh7Bk6EckEsevypXO3zazO6J86aY2XOVGjvCaNh5\nA0g6gutBbJA0ykKcqJ2IAaLf4/Htm6Ps3XgP75d4PsMFeGKFlysztAlipeDrcn3k28xsavn5tLKD\nK6jTqH4Xf0t6BY/d/8lc771YCfuG/kcrI2k23vBsxt9Ov4TXcb5VrEvfKDHT7BIz+1CpbDPwTTPb\nXZ1lI5tmnXcxIDZq8EwafCTdBWw1s221jk2RHdx6iui0PMUyfEnbgXvN7MFYfm1t4uTqNarvwge9\nf146r+Ubolrk2toX4QOwW83s3n4uaTmi49aBa6Svwd9Uv2gVz4YZyTQlCWtm90uaGFoY1i7hhDpM\nBk6op9XRbk67IBz3GHyO7eEoaxsnZy6puxaPaRdO+nk8i0/5vLapU4G5+t9TVercDABfw2UgnsEF\npXLqX8U0redtZisGw5AhpsPMjlZtxCBwPj7g+j/zt9uEuo1qmzu9N2jnOpjZerls7TrrlndOKqSp\nsMlwQ92C90kLIGncMG1Uk2TAGdHOO2lNslFNkv5J550kSdKGDEn2+CRJkmRgSeedJEnShqTzTpIk\naUPSeSdJkrQh6byTJEnakHTeScsj6QxJnykdd0haWbFNV0q6pZ9zpkm6rMn7vhjZZ94h6Qtvzspk\nOJPOO2kH3onLDxf8X/Nbi5R1A2GQmW0ys+/0c9p5uIxtU7eOn+PwFGNJUpd03smgI+k6SXsl7ZG0\nNnrSj0bZdkmnxXlrJN0taYekFyRdFbdYCsyQtFvSwig7TdJjkn4r6Vt9fPeZkp4L3ZR9cd0iSTvj\n+5f0Yue6KDtZ0oY4f2eITPXo/YfdqyQ9E9/1iZBNvgP4dNg9txf7JkjaJmm/PNejYluKp7HbLc+D\nmSQ9qVpQPLfhvQHvxRN2jI/jcUTWnDieB2yM/TXA+tifCjwf+x8BNpXu2QH8Oe51Au6Uz+/l+88E\njgEfiONZuOoieOdlEzCjjp1FtvMf0Z3m73TgYMmGlSW7t8T+2XiiguPxlGcr+vn9rABujf3L8Zyv\n44EzgH1VP7/cWndrWpgqSZrkYuABM/sHgJkdlfRBPAEGeGb7O2Pf8ITKmNkhSadEeb1QxzYLHRRJ\nD+P5LXfVOQ/giJntjP1ZwCxJhQ71aNzhjq6x85/x+SXA1FK0ZYyk0TX3Nzy3Jmb2O0mHgff0YXuZ\nGbhuOWa2RVKh7TIg4Z1k+JLOOxlsjPqOqDfn9J8GzqmNeQvvsfbGqzXH3zazH/S4gXRzL98nYLrV\nJB6R1F/cvZm4fDrqpGky5p0MNo8CcyWNB4ifT+H5QgGuxRNZ98W/8RRoBQIulTRO0onAHDxxcSP8\nDJhf9J4lnSrp5Dp2jovzt+GZlYjyc0s2lO2ZG+OhZ+HStr+pY3c9niAGY2NmSvG9jVybjGDSeSeD\nipkdBLqAxyXtwXOGdgLzJO3FnfeXy5fU2d8LHIuBxIVRvhN4KD7bYGbP9mVGyZ5H8Dj205J+jYc7\nTqpj57K4ZAFwQQxkHgBuLN3TSvsvhU1bgJuip/4YcE5fA5bA7cBFkvbj4ZMjYeffgR2S9uWAZVKP\nVBVMkjeJpB/iA6oPV21LMnLInneSJEkbkj3vZFggaQKwvc5HM4sZJFUiqYOe4SGAJ82sswJzkmFA\nOu8kSZI2JMMmSZIkbUg67yRJkjYknXeSJEkbks47SZKkDUnnnSRJ0ob8F5FdVihDdgqHAAAAAElF\nTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x11419a8d0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "by_date.unstack('party').cumsum().plot()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###More Reshaping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "party        contb_receipt_dt\n",
       "Democrat     2011-04-04          640235.12\n",
       "             2011-07-13          158557.88\n",
       "             2011-10-21          343310.61\n",
       "             2012-01-29           93177.00\n",
       "Libertarian  2011-09-07            7150.00\n",
       "Reform       2011-03-09            1835.00\n",
       "             2011-07-02             200.00\n",
       "             2011-10-16             535.00\n",
       "             2012-01-25             282.00\n",
       "Republican   2011-04-24           16500.00\n",
       "             2011-08-02          237163.04\n",
       "             2011-11-10          387912.58\n",
       "Name: contb_receipt_amt, dtype: float64"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s = by_date[::100]\n",
    "s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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>party</th>\n",
       "      <th>Democrat</th>\n",
       "      <th>Libertarian</th>\n",
       "      <th>Reform</th>\n",
       "      <th>Republican</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011-03-09</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 1835</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-04-04</th>\n",
       "      <td> 640235.12</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-04-24</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  16500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-07-02</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  200</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-07-13</th>\n",
       "      <td> 158557.88</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-08-02</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 237163.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-09-07</th>\n",
       "      <td>       NaN</td>\n",
       "      <td> 7150</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-10-16</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  535</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-10-21</th>\n",
       "      <td> 343310.61</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-10</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 387912.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-01-25</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  282</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-01-29</th>\n",
       "      <td>  93177.00</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "party              Democrat  Libertarian  Reform  Republican\n",
       "contb_receipt_dt                                            \n",
       "2011-03-09              NaN          NaN    1835         NaN\n",
       "2011-04-04        640235.12          NaN     NaN         NaN\n",
       "2011-04-24              NaN          NaN     NaN    16500.00\n",
       "2011-07-02              NaN          NaN     200         NaN\n",
       "2011-07-13        158557.88          NaN     NaN         NaN\n",
       "2011-08-02              NaN          NaN     NaN   237163.04\n",
       "2011-09-07              NaN         7150     NaN         NaN\n",
       "2011-10-16              NaN          NaN     535         NaN\n",
       "2011-10-21        343310.61          NaN     NaN         NaN\n",
       "2011-11-10              NaN          NaN     NaN   387912.58\n",
       "2012-01-25              NaN          NaN     282         NaN\n",
       "2012-01-29         93177.00          NaN     NaN         NaN"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s.unstack('party')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "contb_receipt_dt  party      \n",
       "2011-03-09        Reform           1835.00\n",
       "2011-04-04        Democrat       640235.12\n",
       "2011-04-24        Republican      16500.00\n",
       "2011-07-02        Reform            200.00\n",
       "2011-07-13        Democrat       158557.88\n",
       "2011-08-02        Republican     237163.04\n",
       "2011-09-07        Libertarian      7150.00\n",
       "2011-10-16        Reform            535.00\n",
       "2011-10-21        Democrat       343310.61\n",
       "2011-11-10        Republican     387912.58\n",
       "2012-01-25        Reform            282.00\n",
       "2012-01-29        Democrat        93177.00\n",
       "dtype: float64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s.unstack('party').stack() # Now party is the inner index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">groupA</th>\n",
       "      <th colspan=\"3\" halign=\"left\">groupB</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>cmte_id</th>\n",
       "      <th>cand_id</th>\n",
       "      <th>cand_nm</th>\n",
       "      <th>cmte_id</th>\n",
       "      <th>cand_id</th>\n",
       "      <th>cand_nm</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       groupA                                    groupB             \\\n",
       "      cmte_id    cand_id             cand_nm    cmte_id    cand_id   \n",
       "0   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "1   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "2   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "3   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "4   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "5   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "6   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "7   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "8   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "9   C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "10  C00410118  P20002978  Bachmann, Michelle  C00410118  P20002978   \n",
       "\n",
       "                        \n",
       "               cand_nm  \n",
       "0   Bachmann, Michelle  \n",
       "1   Bachmann, Michelle  \n",
       "2   Bachmann, Michelle  \n",
       "3   Bachmann, Michelle  \n",
       "4   Bachmann, Michelle  \n",
       "5   Bachmann, Michelle  \n",
       "6   Bachmann, Michelle  \n",
       "7   Bachmann, Michelle  \n",
       "8   Bachmann, Michelle  \n",
       "9   Bachmann, Michelle  \n",
       "10  Bachmann, Michelle  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = fec.ix[:10,:3]\n",
    "# Join two tables and assign two keys\n",
    "concat([df,df],axis=1,keys=['groupA','groupB'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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>cmte_id</th>\n",
       "      <th>cand_id</th>\n",
       "      <th>cand_nm</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9 </th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td> C00410118</td>\n",
       "      <td> P20002978</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      cmte_id    cand_id             cand_nm\n",
       "0   C00410118  P20002978  Bachmann, Michelle\n",
       "1   C00410118  P20002978  Bachmann, Michelle\n",
       "2   C00410118  P20002978  Bachmann, Michelle\n",
       "3   C00410118  P20002978  Bachmann, Michelle\n",
       "4   C00410118  P20002978  Bachmann, Michelle\n",
       "5   C00410118  P20002978  Bachmann, Michelle\n",
       "6   C00410118  P20002978  Bachmann, Michelle\n",
       "7   C00410118  P20002978  Bachmann, Michelle\n",
       "8   C00410118  P20002978  Bachmann, Michelle\n",
       "9   C00410118  P20002978  Bachmann, Michelle\n",
       "10  C00410118  P20002978  Bachmann, Michelle"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Select only group A\n",
    "concat([df,df],axis=1,keys=['groupA','groupB'])['groupA']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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></th>\n",
       "      <th>groupA</th>\n",
       "      <th>groupB</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>party</th>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">Democrat</th>\n",
       "      <th>2011-04-04</th>\n",
       "      <td> 640235.12</td>\n",
       "      <td> 640235.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-07-13</th>\n",
       "      <td> 158557.88</td>\n",
       "      <td> 158557.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-10-21</th>\n",
       "      <td> 343310.61</td>\n",
       "      <td> 343310.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-01-29</th>\n",
       "      <td>  93177.00</td>\n",
       "      <td>  93177.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Libertarian</th>\n",
       "      <th>2011-09-07</th>\n",
       "      <td>   7150.00</td>\n",
       "      <td>   7150.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">Reform</th>\n",
       "      <th>2011-03-09</th>\n",
       "      <td>   1835.00</td>\n",
       "      <td>   1835.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-07-02</th>\n",
       "      <td>    200.00</td>\n",
       "      <td>    200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-10-16</th>\n",
       "      <td>    535.00</td>\n",
       "      <td>    535.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-01-25</th>\n",
       "      <td>    282.00</td>\n",
       "      <td>    282.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">Republican</th>\n",
       "      <th>2011-04-24</th>\n",
       "      <td>  16500.00</td>\n",
       "      <td>  16500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-08-02</th>\n",
       "      <td> 237163.04</td>\n",
       "      <td> 237163.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-10</th>\n",
       "      <td> 387912.58</td>\n",
       "      <td> 387912.58</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 groupA     groupB\n",
       "party       contb_receipt_dt                      \n",
       "Democrat    2011-04-04        640235.12  640235.12\n",
       "            2011-07-13        158557.88  158557.88\n",
       "            2011-10-21        343310.61  343310.61\n",
       "            2012-01-29         93177.00   93177.00\n",
       "Libertarian 2011-09-07          7150.00    7150.00\n",
       "Reform      2011-03-09          1835.00    1835.00\n",
       "            2011-07-02           200.00     200.00\n",
       "            2011-10-16           535.00     535.00\n",
       "            2012-01-25           282.00     282.00\n",
       "Republican  2011-04-24         16500.00   16500.00\n",
       "            2011-08-02        237163.04  237163.04\n",
       "            2011-11-10        387912.58  387912.58"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "concat([s,s],axis=1,keys=['groupA','groupB'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"4\" halign=\"left\">groupA</th>\n",
       "      <th colspan=\"4\" halign=\"left\">groupB</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>party</th>\n",
       "      <th>Democrat</th>\n",
       "      <th>Libertarian</th>\n",
       "      <th>Reform</th>\n",
       "      <th>Republican</th>\n",
       "      <th>Democrat</th>\n",
       "      <th>Libertarian</th>\n",
       "      <th>Reform</th>\n",
       "      <th>Republican</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011-03-09</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 1835</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 1835</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-04-04</th>\n",
       "      <td> 640235.12</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td> 640235.12</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-04-24</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  16500.00</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  16500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-07-02</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  200</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  200</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-07-13</th>\n",
       "      <td> 158557.88</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td> 158557.88</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-08-02</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 237163.04</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 237163.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-09-07</th>\n",
       "      <td>       NaN</td>\n",
       "      <td> 7150</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td> 7150</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-10-16</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  535</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  535</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-10-21</th>\n",
       "      <td> 343310.61</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td> 343310.61</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-10</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 387912.58</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td> 387912.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-01-25</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  282</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  282</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-01-29</th>\n",
       "      <td>  93177.00</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "      <td>  93177.00</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>  NaN</td>\n",
       "      <td>       NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     groupA                                      groupB  \\\n",
       "party              Democrat  Libertarian  Reform  Republican   Democrat   \n",
       "contb_receipt_dt                                                          \n",
       "2011-03-09              NaN          NaN    1835         NaN        NaN   \n",
       "2011-04-04        640235.12          NaN     NaN         NaN  640235.12   \n",
       "2011-04-24              NaN          NaN     NaN    16500.00        NaN   \n",
       "2011-07-02              NaN          NaN     200         NaN        NaN   \n",
       "2011-07-13        158557.88          NaN     NaN         NaN  158557.88   \n",
       "2011-08-02              NaN          NaN     NaN   237163.04        NaN   \n",
       "2011-09-07              NaN         7150     NaN         NaN        NaN   \n",
       "2011-10-16              NaN          NaN     535         NaN        NaN   \n",
       "2011-10-21        343310.61          NaN     NaN         NaN  343310.61   \n",
       "2011-11-10              NaN          NaN     NaN   387912.58        NaN   \n",
       "2012-01-25              NaN          NaN     282         NaN        NaN   \n",
       "2012-01-29         93177.00          NaN     NaN         NaN   93177.00   \n",
       "\n",
       "                                                   \n",
       "party             Libertarian  Reform  Republican  \n",
       "contb_receipt_dt                                   \n",
       "2011-03-09                NaN    1835         NaN  \n",
       "2011-04-04                NaN     NaN         NaN  \n",
       "2011-04-24                NaN     NaN    16500.00  \n",
       "2011-07-02                NaN     200         NaN  \n",
       "2011-07-13                NaN     NaN         NaN  \n",
       "2011-08-02                NaN     NaN   237163.04  \n",
       "2011-09-07               7150     NaN         NaN  \n",
       "2011-10-16                NaN     535         NaN  \n",
       "2011-10-21                NaN     NaN         NaN  \n",
       "2011-11-10                NaN     NaN   387912.58  \n",
       "2012-01-25                NaN     282         NaN  \n",
       "2012-01-29                NaN     NaN         NaN  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "concat([s,s],axis=1,keys=['groupA','groupB']).unstack('party')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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>party</th>\n",
       "      <th>Democrat</th>\n",
       "      <th>Libertarian</th>\n",
       "      <th>Reform</th>\n",
       "      <th>Republican</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011-01-01</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   8600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-05-01</th>\n",
       "      <td>  82644.00</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 480</td>\n",
       "      <td>  28663.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-08-09</th>\n",
       "      <td> 168220.00</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 522</td>\n",
       "      <td> 166582.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-17</th>\n",
       "      <td> 144239.72</td>\n",
       "      <td> 11400</td>\n",
       "      <td> 250</td>\n",
       "      <td> 265703.35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "party              Democrat  Libertarian  Reform  Republican\n",
       "contb_receipt_dt                                            \n",
       "2011-01-01              NaN          NaN     NaN     8600.00\n",
       "2011-05-01         82644.00          NaN     480    28663.87\n",
       "2011-08-09        168220.00          NaN     522   166582.81\n",
       "2011-11-17        144239.72        11400     250   265703.35"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = by_date.unstack('party')[::100]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/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>party</th>\n",
       "      <th>Democrat</th>\n",
       "      <th>Libertarian</th>\n",
       "      <th>Reform</th>\n",
       "      <th>Republican</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contb_receipt_dt</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2011-01-01</th>\n",
       "      <th>a</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   8600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td>       NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   8600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2011-05-01</th>\n",
       "      <th>a</th>\n",
       "      <td>  82644.00</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 480</td>\n",
       "      <td>  28663.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td>  82644.00</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 480</td>\n",
       "      <td>  28663.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2011-08-09</th>\n",
       "      <th>a</th>\n",
       "      <td> 168220.00</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 522</td>\n",
       "      <td> 166582.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td> 168220.00</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 522</td>\n",
       "      <td> 166582.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2011-11-17</th>\n",
       "      <th>a</th>\n",
       "      <td> 144239.72</td>\n",
       "      <td> 11400</td>\n",
       "      <td> 250</td>\n",
       "      <td> 265703.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td> 144239.72</td>\n",
       "      <td> 11400</td>\n",
       "      <td> 250</td>\n",
       "      <td> 265703.35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "party                Democrat  Libertarian  Reform  Republican\n",
       "contb_receipt_dt                                              \n",
       "2011-01-01       a        NaN          NaN     NaN     8600.00\n",
       "                 b        NaN          NaN     NaN     8600.00\n",
       "2011-05-01       a   82644.00          NaN     480    28663.87\n",
       "                 b   82644.00          NaN     480    28663.87\n",
       "2011-08-09       a  168220.00          NaN     522   166582.81\n",
       "                 b  168220.00          NaN     522   166582.81\n",
       "2011-11-17       a  144239.72        11400     250   265703.35\n",
       "                 b  144239.72        11400     250   265703.35"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We can stack the top level as well and compare both tables\n",
    "concat([df,df],axis=1,keys=[\"a\",\"b\"]).stack(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "cand_nm             contbr_occupation             \n",
       "Bachmann, Michelle  100% DISABLED VETERAN              1869.50\n",
       "                    100% DISABLED VIETNAM VETERAN       236.25\n",
       "                    A/C AND HEAT                        250.00\n",
       "                    ACADEMIC EMPLOYMENT SPECIALIST       25.00\n",
       "                    ACCOUNT                              50.00\n",
       "                    ACCOUNT ANALYST                     200.00\n",
       "                    ACCOUNT EXECUTIVE                   100.00\n",
       "                    ACCOUNT MANAGER                     230.00\n",
       "                    ACCOUNTANT                        12979.00\n",
       "                    ACCOUNTANT TRAINER                  250.00\n",
       "                    ACCOUNTING                          350.00\n",
       "                    ACCOUNTING MANAGER                   50.00\n",
       "                    ACCOUNTING SPECIALIST               250.00\n",
       "                    ACCOUNTING SUPERVISOR               125.00\n",
       "                    ACCOUNTING/AUDITING                 700.00\n",
       "...\n",
       "Santorum, Rick  WILDLIFE REFUGE MANAGER       200.00\n",
       "                WIND FARM DEVELOPER           400.00\n",
       "                WINDOW CLEANER                 85.00\n",
       "                WINERY                        300.00\n",
       "                WIRELESS NETWORK ENGINEER     220.15\n",
       "                WITHHELD                     1000.00\n",
       "                WNG                           700.00\n",
       "                WORKER II                     300.00\n",
       "                WRITER                       4894.55\n",
       "                WRITER ACTIVIST              1112.00\n",
       "                WRITER EDITOR                 250.00\n",
       "                WRITER/ACCOUNT EXEC           500.00\n",
       "                WRITER/JOURNALIST             250.00\n",
       "                WRITER/LAWYER                 300.00\n",
       "                YOUTH MINISTER                250.00\n",
       "Name: contb_receipt_amt, Length: 40161, dtype: float64"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = fec.groupby(['cand_nm','contbr_occupation'])['contb_receipt_amt'].sum()\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "cand_nm\n",
       "Paul, Ron    1556\n",
       "Name: contb_receipt_amt, dtype: float64"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result[:,'ZOMBIE SLAYER']  # Fun fact"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**dataframe.reset_index() will unstack all groupbys**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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>index</th>\n",
       "      <th>cand_nm</th>\n",
       "      <th>contbr_occupation</th>\n",
       "      <th>contb_receipt_amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0    </th>\n",
       "      <td>     0</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>          100% DISABLED VETERAN</td>\n",
       "      <td>  1869.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1    </th>\n",
       "      <td>     1</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>  100% DISABLED VIETNAM VETERAN</td>\n",
       "      <td>   236.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2    </th>\n",
       "      <td>     2</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                   A/C AND HEAT</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3    </th>\n",
       "      <td>     3</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td> ACADEMIC EMPLOYMENT SPECIALIST</td>\n",
       "      <td>    25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4    </th>\n",
       "      <td>     4</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                        ACCOUNT</td>\n",
       "      <td>    50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5    </th>\n",
       "      <td>     5</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                ACCOUNT ANALYST</td>\n",
       "      <td>   200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6    </th>\n",
       "      <td>     6</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>              ACCOUNT EXECUTIVE</td>\n",
       "      <td>   100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7    </th>\n",
       "      <td>     7</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                ACCOUNT MANAGER</td>\n",
       "      <td>   230.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8    </th>\n",
       "      <td>     8</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                     ACCOUNTANT</td>\n",
       "      <td> 12979.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9    </th>\n",
       "      <td>     9</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>             ACCOUNTANT TRAINER</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10   </th>\n",
       "      <td>    10</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                     ACCOUNTING</td>\n",
       "      <td>   350.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11   </th>\n",
       "      <td>    11</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>             ACCOUNTING MANAGER</td>\n",
       "      <td>    50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12   </th>\n",
       "      <td>    12</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>          ACCOUNTING SPECIALIST</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13   </th>\n",
       "      <td>    13</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>          ACCOUNTING SUPERVISOR</td>\n",
       "      <td>   125.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14   </th>\n",
       "      <td>    14</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>            ACCOUNTING/AUDITING</td>\n",
       "      <td>   700.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15   </th>\n",
       "      <td>    15</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>           ACTIVE DUTY MILITARY</td>\n",
       "      <td>   125.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16   </th>\n",
       "      <td>    16</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                        ACTRESS</td>\n",
       "      <td>   601.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17   </th>\n",
       "      <td>    17</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                        ACTUARY</td>\n",
       "      <td>  1050.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18   </th>\n",
       "      <td>    18</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                        AD EXEC</td>\n",
       "      <td>   401.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19   </th>\n",
       "      <td>    19</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>             ADJURET ASST. PROF</td>\n",
       "      <td>    31.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20   </th>\n",
       "      <td>    20</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                       ADJUSTER</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21   </th>\n",
       "      <td>    21</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>               ADMIN. ASSISTANT</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22   </th>\n",
       "      <td>    22</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>             ADMINISNATIVE ASST</td>\n",
       "      <td>   125.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23   </th>\n",
       "      <td>    23</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                 ADMINISTRATION</td>\n",
       "      <td>  1245.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24   </th>\n",
       "      <td>    24</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>       ADMINISTRATIVE ASSISTANT</td>\n",
       "      <td>   300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25   </th>\n",
       "      <td>    25</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>       ADMINISTRATIVE EXECUTIVE</td>\n",
       "      <td>   200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26   </th>\n",
       "      <td>    26</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>       ADMINISTRATIVE LAW JUDGE</td>\n",
       "      <td>   575.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27   </th>\n",
       "      <td>    27</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>        ADMINISTRATIVE MED PRAC</td>\n",
       "      <td>   100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28   </th>\n",
       "      <td>    28</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                  ADMINISTRATOR</td>\n",
       "      <td>  4587.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29   </th>\n",
       "      <td>    29</td>\n",
       "      <td> Bachmann, Michelle</td>\n",
       "      <td>                   ADMINSTRATOR</td>\n",
       "      <td>   300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40131</th>\n",
       "      <td> 40131</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>              WEB COMM. MANAGER</td>\n",
       "      <td>  1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40132</th>\n",
       "      <td> 40132</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                     WEB DESIGN</td>\n",
       "      <td>   500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40133</th>\n",
       "      <td> 40133</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                   WEB DESIGNER</td>\n",
       "      <td>   235.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40134</th>\n",
       "      <td> 40134</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                      WEBMASTER</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40135</th>\n",
       "      <td> 40135</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                  WELD ENGINEER</td>\n",
       "      <td>  1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40136</th>\n",
       "      <td> 40136</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                         WELDER</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40137</th>\n",
       "      <td> 40137</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                     WELL BEING</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40138</th>\n",
       "      <td> 40138</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>         WELL BEING COORDINATOR</td>\n",
       "      <td>   300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40139</th>\n",
       "      <td> 40139</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>          WELLBORN CABINET INC.</td>\n",
       "      <td>   500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40140</th>\n",
       "      <td> 40140</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>   WHEATON COLLEGE (IL) STUDENT</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40141</th>\n",
       "      <td> 40141</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                  WHOLESALE MFG</td>\n",
       "      <td>   400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40142</th>\n",
       "      <td> 40142</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                          WIDOW</td>\n",
       "      <td>    80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40143</th>\n",
       "      <td> 40143</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                WIFE AND MOTHER</td>\n",
       "      <td>  1500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40144</th>\n",
       "      <td> 40144</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>      WIFE AND MOTHER (AT HOME)</td>\n",
       "      <td>   100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40145</th>\n",
       "      <td> 40145</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>            WIFE MOTHER TEACHER</td>\n",
       "      <td>  1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40146</th>\n",
       "      <td> 40146</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>        WILDLIFE REFUGE MANAGER</td>\n",
       "      <td>   200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40147</th>\n",
       "      <td> 40147</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>            WIND FARM DEVELOPER</td>\n",
       "      <td>   400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40148</th>\n",
       "      <td> 40148</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                 WINDOW CLEANER</td>\n",
       "      <td>    85.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40149</th>\n",
       "      <td> 40149</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                         WINERY</td>\n",
       "      <td>   300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40150</th>\n",
       "      <td> 40150</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>      WIRELESS NETWORK ENGINEER</td>\n",
       "      <td>   220.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40151</th>\n",
       "      <td> 40151</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                       WITHHELD</td>\n",
       "      <td>  1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40152</th>\n",
       "      <td> 40152</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                            WNG</td>\n",
       "      <td>   700.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40153</th>\n",
       "      <td> 40153</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                      WORKER II</td>\n",
       "      <td>   300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40154</th>\n",
       "      <td> 40154</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                         WRITER</td>\n",
       "      <td>  4894.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40155</th>\n",
       "      <td> 40155</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                WRITER ACTIVIST</td>\n",
       "      <td>  1112.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40156</th>\n",
       "      <td> 40156</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                  WRITER EDITOR</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40157</th>\n",
       "      <td> 40157</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>            WRITER/ACCOUNT EXEC</td>\n",
       "      <td>   500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40158</th>\n",
       "      <td> 40158</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>              WRITER/JOURNALIST</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40159</th>\n",
       "      <td> 40159</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                  WRITER/LAWYER</td>\n",
       "      <td>   300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40160</th>\n",
       "      <td> 40160</td>\n",
       "      <td>     Santorum, Rick</td>\n",
       "      <td>                 YOUTH MINISTER</td>\n",
       "      <td>   250.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>40161 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       index             cand_nm               contbr_occupation  \\\n",
       "0          0  Bachmann, Michelle           100% DISABLED VETERAN   \n",
       "1          1  Bachmann, Michelle   100% DISABLED VIETNAM VETERAN   \n",
       "2          2  Bachmann, Michelle                    A/C AND HEAT   \n",
       "3          3  Bachmann, Michelle  ACADEMIC EMPLOYMENT SPECIALIST   \n",
       "4          4  Bachmann, Michelle                         ACCOUNT   \n",
       "5          5  Bachmann, Michelle                 ACCOUNT ANALYST   \n",
       "6          6  Bachmann, Michelle               ACCOUNT EXECUTIVE   \n",
       "7          7  Bachmann, Michelle                 ACCOUNT MANAGER   \n",
       "8          8  Bachmann, Michelle                      ACCOUNTANT   \n",
       "9          9  Bachmann, Michelle              ACCOUNTANT TRAINER   \n",
       "10        10  Bachmann, Michelle                      ACCOUNTING   \n",
       "11        11  Bachmann, Michelle              ACCOUNTING MANAGER   \n",
       "12        12  Bachmann, Michelle           ACCOUNTING SPECIALIST   \n",
       "13        13  Bachmann, Michelle           ACCOUNTING SUPERVISOR   \n",
       "14        14  Bachmann, Michelle             ACCOUNTING/AUDITING   \n",
       "15        15  Bachmann, Michelle            ACTIVE DUTY MILITARY   \n",
       "16        16  Bachmann, Michelle                         ACTRESS   \n",
       "17        17  Bachmann, Michelle                         ACTUARY   \n",
       "18        18  Bachmann, Michelle                         AD EXEC   \n",
       "19        19  Bachmann, Michelle              ADJURET ASST. PROF   \n",
       "20        20  Bachmann, Michelle                        ADJUSTER   \n",
       "21        21  Bachmann, Michelle                ADMIN. ASSISTANT   \n",
       "22        22  Bachmann, Michelle              ADMINISNATIVE ASST   \n",
       "23        23  Bachmann, Michelle                  ADMINISTRATION   \n",
       "24        24  Bachmann, Michelle        ADMINISTRATIVE ASSISTANT   \n",
       "25        25  Bachmann, Michelle        ADMINISTRATIVE EXECUTIVE   \n",
       "26        26  Bachmann, Michelle        ADMINISTRATIVE LAW JUDGE   \n",
       "27        27  Bachmann, Michelle         ADMINISTRATIVE MED PRAC   \n",
       "28        28  Bachmann, Michelle                   ADMINISTRATOR   \n",
       "29        29  Bachmann, Michelle                    ADMINSTRATOR   \n",
       "...      ...                 ...                             ...   \n",
       "40131  40131      Santorum, Rick               WEB COMM. MANAGER   \n",
       "40132  40132      Santorum, Rick                      WEB DESIGN   \n",
       "40133  40133      Santorum, Rick                    WEB DESIGNER   \n",
       "40134  40134      Santorum, Rick                       WEBMASTER   \n",
       "40135  40135      Santorum, Rick                   WELD ENGINEER   \n",
       "40136  40136      Santorum, Rick                          WELDER   \n",
       "40137  40137      Santorum, Rick                      WELL BEING   \n",
       "40138  40138      Santorum, Rick          WELL BEING COORDINATOR   \n",
       "40139  40139      Santorum, Rick           WELLBORN CABINET INC.   \n",
       "40140  40140      Santorum, Rick    WHEATON COLLEGE (IL) STUDENT   \n",
       "40141  40141      Santorum, Rick                   WHOLESALE MFG   \n",
       "40142  40142      Santorum, Rick                           WIDOW   \n",
       "40143  40143      Santorum, Rick                 WIFE AND MOTHER   \n",
       "40144  40144      Santorum, Rick       WIFE AND MOTHER (AT HOME)   \n",
       "40145  40145      Santorum, Rick             WIFE MOTHER TEACHER   \n",
       "40146  40146      Santorum, Rick         WILDLIFE REFUGE MANAGER   \n",
       "40147  40147      Santorum, Rick             WIND FARM DEVELOPER   \n",
       "40148  40148      Santorum, Rick                  WINDOW CLEANER   \n",
       "40149  40149      Santorum, Rick                          WINERY   \n",
       "40150  40150      Santorum, Rick       WIRELESS NETWORK ENGINEER   \n",
       "40151  40151      Santorum, Rick                        WITHHELD   \n",
       "40152  40152      Santorum, Rick                             WNG   \n",
       "40153  40153      Santorum, Rick                       WORKER II   \n",
       "40154  40154      Santorum, Rick                          WRITER   \n",
       "40155  40155      Santorum, Rick                 WRITER ACTIVIST   \n",
       "40156  40156      Santorum, Rick                   WRITER EDITOR   \n",
       "40157  40157      Santorum, Rick             WRITER/ACCOUNT EXEC   \n",
       "40158  40158      Santorum, Rick               WRITER/JOURNALIST   \n",
       "40159  40159      Santorum, Rick                   WRITER/LAWYER   \n",
       "40160  40160      Santorum, Rick                  YOUTH MINISTER   \n",
       "\n",
       "       contb_receipt_amt  \n",
       "0                1869.50  \n",
       "1                 236.25  \n",
       "2                 250.00  \n",
       "3                  25.00  \n",
       "4                  50.00  \n",
       "5                 200.00  \n",
       "6                 100.00  \n",
       "7                 230.00  \n",
       "8               12979.00  \n",
       "9                 250.00  \n",
       "10                350.00  \n",
       "11                 50.00  \n",
       "12                250.00  \n",
       "13                125.00  \n",
       "14                700.00  \n",
       "15                125.00  \n",
       "16                601.00  \n",
       "17               1050.00  \n",
       "18                401.00  \n",
       "19                 31.00  \n",
       "20                250.00  \n",
       "21                250.00  \n",
       "22                125.00  \n",
       "23               1245.00  \n",
       "24                300.00  \n",
       "25                200.00  \n",
       "26                575.00  \n",
       "27                100.00  \n",
       "28               4587.00  \n",
       "29                300.00  \n",
       "...                  ...  \n",
       "40131            1000.00  \n",
       "40132             500.00  \n",
       "40133             235.00  \n",
       "40134             250.00  \n",
       "40135            1000.00  \n",
       "40136             250.00  \n",
       "40137             250.00  \n",
       "40138             300.00  \n",
       "40139             500.00  \n",
       "40140             250.00  \n",
       "40141             400.00  \n",
       "40142              80.00  \n",
       "40143            1500.00  \n",
       "40144             100.00  \n",
       "40145            1000.00  \n",
       "40146             200.00  \n",
       "40147             400.00  \n",
       "40148              85.00  \n",
       "40149             300.00  \n",
       "40150             220.15  \n",
       "40151            1000.00  \n",
       "40152             700.00  \n",
       "40153             300.00  \n",
       "40154            4894.55  \n",
       "40155            1112.00  \n",
       "40156             250.00  \n",
       "40157             500.00  \n",
       "40158             250.00  \n",
       "40159             300.00  \n",
       "40160             250.00  \n",
       "\n",
       "[40161 rows x 4 columns]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = result.reset_index()\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/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></th>\n",
       "      <th>index</th>\n",
       "      <th>cand_nm</th>\n",
       "      <th>contbr_occupation</th>\n",
       "      <th>contb_receipt_amt</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cand_nm</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Bachmann, Michelle</th>\n",
       "      <th>920  </th>\n",
       "      <td>   920</td>\n",
       "      <td>             Bachmann, Michelle</td>\n",
       "      <td>                              PRESIDENT</td>\n",
       "      <td>   68781.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892  </th>\n",
       "      <td>   892</td>\n",
       "      <td>             Bachmann, Michelle</td>\n",
       "      <td>                              PHYSICIAN</td>\n",
       "      <td>   76134.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>555  </th>\n",
       "      <td>   555</td>\n",
       "      <td>             Bachmann, Michelle</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>  102540.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594  </th>\n",
       "      <td>   594</td>\n",
       "      <td>             Bachmann, Michelle</td>\n",
       "      <td>                  INFORMATION REQUESTED</td>\n",
       "      <td>  147638.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1058 </th>\n",
       "      <td>  1058</td>\n",
       "      <td>             Bachmann, Michelle</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>  824618.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Cain, Herman</th>\n",
       "      <th>1536 </th>\n",
       "      <td>  1536</td>\n",
       "      <td>                   Cain, Herman</td>\n",
       "      <td>                                    CEO</td>\n",
       "      <td>  125097.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2225 </th>\n",
       "      <td>  2225</td>\n",
       "      <td>                   Cain, Herman</td>\n",
       "      <td>                              PHYSICIAN</td>\n",
       "      <td>  125790.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1897 </th>\n",
       "      <td>  1897</td>\n",
       "      <td>                   Cain, Herman</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>  153964.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2389 </th>\n",
       "      <td>  2389</td>\n",
       "      <td>                   Cain, Herman</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>  779635.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1928 </th>\n",
       "      <td>  1928</td>\n",
       "      <td>                   Cain, Herman</td>\n",
       "      <td>                  INFORMATION REQUESTED</td>\n",
       "      <td> 3838719.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Gingrich, Newt</th>\n",
       "      <th>4065 </th>\n",
       "      <td>  4065</td>\n",
       "      <td>                 Gingrich, Newt</td>\n",
       "      <td>                                  OWNER</td>\n",
       "      <td>  273310.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4219 </th>\n",
       "      <td>  4219</td>\n",
       "      <td>                 Gingrich, Newt</td>\n",
       "      <td>                              PRESIDENT</td>\n",
       "      <td>  332403.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3559 </th>\n",
       "      <td>  3559</td>\n",
       "      <td>                 Gingrich, Newt</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>  426118.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3609 </th>\n",
       "      <td>  3609</td>\n",
       "      <td>                 Gingrich, Newt</td>\n",
       "      <td> INFORMATION REQUESTED PER BEST EFFORTS</td>\n",
       "      <td>  910147.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4481 </th>\n",
       "      <td>  4481</td>\n",
       "      <td>                 Gingrich, Newt</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td> 2279602.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Huntsman, Jon</th>\n",
       "      <th>5466 </th>\n",
       "      <td>  5466</td>\n",
       "      <td>                  Huntsman, Jon</td>\n",
       "      <td>                              PRESIDENT</td>\n",
       "      <td>   92251.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4981 </th>\n",
       "      <td>  4981</td>\n",
       "      <td>                  Huntsman, Jon</td>\n",
       "      <td>                               ATTORNEY</td>\n",
       "      <td>  143532.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5285 </th>\n",
       "      <td>  5285</td>\n",
       "      <td>                  Huntsman, Jon</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>  241524.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5559 </th>\n",
       "      <td>  5559</td>\n",
       "      <td>                  Huntsman, Jon</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>  352669.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5298 </th>\n",
       "      <td>  5298</td>\n",
       "      <td>                  Huntsman, Jon</td>\n",
       "      <td> INFORMATION REQUESTED PER BEST EFFORTS</td>\n",
       "      <td>  354500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Johnson, Gary Earl</th>\n",
       "      <th>5769 </th>\n",
       "      <td>  5769</td>\n",
       "      <td>             Johnson, Gary Earl</td>\n",
       "      <td>                              HOUSEWIFE</td>\n",
       "      <td>   11000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5851 </th>\n",
       "      <td>  5851</td>\n",
       "      <td>             Johnson, Gary Earl</td>\n",
       "      <td>                          SELF-EMPLOYED</td>\n",
       "      <td>   14750.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5731 </th>\n",
       "      <td>  5731</td>\n",
       "      <td>             Johnson, Gary Earl</td>\n",
       "      <td>                             CONSULTANT</td>\n",
       "      <td>   16767.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5849 </th>\n",
       "      <td>  5849</td>\n",
       "      <td>             Johnson, Gary Earl</td>\n",
       "      <td>                          SELF EMPLOYED</td>\n",
       "      <td>   18781.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5841 </th>\n",
       "      <td>  5841</td>\n",
       "      <td>             Johnson, Gary Earl</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>   85763.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">McCotter, Thaddeus G</th>\n",
       "      <th>5902 </th>\n",
       "      <td>  5902</td>\n",
       "      <td>           McCotter, Thaddeus G</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>    2400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5914 </th>\n",
       "      <td>  5914</td>\n",
       "      <td>           McCotter, Thaddeus G</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>    2450.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5900 </th>\n",
       "      <td>  5900</td>\n",
       "      <td>           McCotter, Thaddeus G</td>\n",
       "      <td>                             GOVERNMENT</td>\n",
       "      <td>    2500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5908 </th>\n",
       "      <td>  5908</td>\n",
       "      <td>           McCotter, Thaddeus G</td>\n",
       "      <td>                              PHYSICIAN</td>\n",
       "      <td>    3650.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5898 </th>\n",
       "      <td>  5898</td>\n",
       "      <td>           McCotter, Thaddeus G</td>\n",
       "      <td>                              EXECUTIVE</td>\n",
       "      <td>    3750.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Paul, Ron</th>\n",
       "      <th>25801</th>\n",
       "      <td> 25801</td>\n",
       "      <td>                      Paul, Ron</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>  310823.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28343</th>\n",
       "      <td> 28343</td>\n",
       "      <td>                      Paul, Ron</td>\n",
       "      <td>                              REQUESTED</td>\n",
       "      <td>  381440.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27643</th>\n",
       "      <td> 27643</td>\n",
       "      <td>                      Paul, Ron</td>\n",
       "      <td>                              PHYSICIAN</td>\n",
       "      <td>  509300.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24952</th>\n",
       "      <td> 24952</td>\n",
       "      <td>                      Paul, Ron</td>\n",
       "      <td>                               ENGINEER</td>\n",
       "      <td>  612693.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28455</th>\n",
       "      <td> 28455</td>\n",
       "      <td>                      Paul, Ron</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td> 1799513.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Pawlenty, Timothy</th>\n",
       "      <th>30752</th>\n",
       "      <td> 30752</td>\n",
       "      <td>              Pawlenty, Timothy</td>\n",
       "      <td> INFORMATION REQUESTED PER BEST EFFORTS</td>\n",
       "      <td>  197841.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30895</th>\n",
       "      <td> 30895</td>\n",
       "      <td>              Pawlenty, Timothy</td>\n",
       "      <td>                              PRESIDENT</td>\n",
       "      <td>  211708.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30511</th>\n",
       "      <td> 30511</td>\n",
       "      <td>              Pawlenty, Timothy</td>\n",
       "      <td>                               ATTORNEY</td>\n",
       "      <td>  238331.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30971</th>\n",
       "      <td> 30971</td>\n",
       "      <td>              Pawlenty, Timothy</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>  584195.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30744</th>\n",
       "      <td> 30744</td>\n",
       "      <td>              Pawlenty, Timothy</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>  769514.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Perry, Rick</th>\n",
       "      <th>31198</th>\n",
       "      <td> 31198</td>\n",
       "      <td>                    Perry, Rick</td>\n",
       "      <td>                               ATTORNEY</td>\n",
       "      <td>  768778.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32344</th>\n",
       "      <td> 32344</td>\n",
       "      <td>                    Perry, Rick</td>\n",
       "      <td>                              PRESIDENT</td>\n",
       "      <td>  845150.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32538</th>\n",
       "      <td> 32538</td>\n",
       "      <td>                    Perry, Rick</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td> 1091671.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31873</th>\n",
       "      <td> 31873</td>\n",
       "      <td>                    Perry, Rick</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td> 1818443.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31909</th>\n",
       "      <td> 31909</td>\n",
       "      <td>                    Perry, Rick</td>\n",
       "      <td> INFORMATION REQUESTED PER BEST EFFORTS</td>\n",
       "      <td> 1975508.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Roemer, Charles E. 'Buddy' III</th>\n",
       "      <th>34265</th>\n",
       "      <td> 34265</td>\n",
       "      <td> Roemer, Charles E. 'Buddy' III</td>\n",
       "      <td>                                STUDENT</td>\n",
       "      <td>    6733.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33530</th>\n",
       "      <td> 33530</td>\n",
       "      <td> Roemer, Charles E. 'Buddy' III</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>    8195.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32996</th>\n",
       "      <td> 32996</td>\n",
       "      <td> Roemer, Charles E. 'Buddy' III</td>\n",
       "      <td>                               ATTORNEY</td>\n",
       "      <td>   14186.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33576</th>\n",
       "      <td> 33576</td>\n",
       "      <td> Roemer, Charles E. 'Buddy' III</td>\n",
       "      <td>                  INFORMATION REQUESTED</td>\n",
       "      <td>   18707.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34117</th>\n",
       "      <td> 34117</td>\n",
       "      <td> Roemer, Charles E. 'Buddy' III</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>   73000.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Romney, Mitt</th>\n",
       "      <th>37406</th>\n",
       "      <td> 37406</td>\n",
       "      <td>                   Romney, Mitt</td>\n",
       "      <td>                              PRESIDENT</td>\n",
       "      <td> 1522751.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34625</th>\n",
       "      <td> 34625</td>\n",
       "      <td>                   Romney, Mitt</td>\n",
       "      <td>                               ATTORNEY</td>\n",
       "      <td> 3662610.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36317</th>\n",
       "      <td> 36317</td>\n",
       "      <td>                   Romney, Mitt</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td> 5442013.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36411</th>\n",
       "      <td> 36411</td>\n",
       "      <td>                   Romney, Mitt</td>\n",
       "      <td> INFORMATION REQUESTED PER BEST EFFORTS</td>\n",
       "      <td> 6394753.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37910</th>\n",
       "      <td> 37910</td>\n",
       "      <td>                   Romney, Mitt</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td> 6483596.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Santorum, Rick</th>\n",
       "      <th>38856</th>\n",
       "      <td> 38856</td>\n",
       "      <td>                 Santorum, Rick</td>\n",
       "      <td>                               ATTORNEY</td>\n",
       "      <td>  107130.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39180</th>\n",
       "      <td> 39180</td>\n",
       "      <td>                 Santorum, Rick</td>\n",
       "      <td>                              EXECUTIVE</td>\n",
       "      <td>  131456.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39341</th>\n",
       "      <td> 39341</td>\n",
       "      <td>                 Santorum, Rick</td>\n",
       "      <td>   INFORMATION REQUESTED (BEST EFFORTS)</td>\n",
       "      <td>  284718.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39305</th>\n",
       "      <td> 39305</td>\n",
       "      <td>                 Santorum, Rick</td>\n",
       "      <td>                              HOMEMAKER</td>\n",
       "      <td>  350597.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39812</th>\n",
       "      <td> 39812</td>\n",
       "      <td>                 Santorum, Rick</td>\n",
       "      <td>                                RETIRED</td>\n",
       "      <td>  421952.98</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>65 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      index                         cand_nm  \\\n",
       "cand_nm                                                                       \n",
       "Bachmann, Michelle             920      920              Bachmann, Michelle   \n",
       "                               892      892              Bachmann, Michelle   \n",
       "                               555      555              Bachmann, Michelle   \n",
       "                               594      594              Bachmann, Michelle   \n",
       "                               1058    1058              Bachmann, Michelle   \n",
       "Cain, Herman                   1536    1536                    Cain, Herman   \n",
       "                               2225    2225                    Cain, Herman   \n",
       "                               1897    1897                    Cain, Herman   \n",
       "                               2389    2389                    Cain, Herman   \n",
       "                               1928    1928                    Cain, Herman   \n",
       "Gingrich, Newt                 4065    4065                  Gingrich, Newt   \n",
       "                               4219    4219                  Gingrich, Newt   \n",
       "                               3559    3559                  Gingrich, Newt   \n",
       "                               3609    3609                  Gingrich, Newt   \n",
       "                               4481    4481                  Gingrich, Newt   \n",
       "Huntsman, Jon                  5466    5466                   Huntsman, Jon   \n",
       "                               4981    4981                   Huntsman, Jon   \n",
       "                               5285    5285                   Huntsman, Jon   \n",
       "                               5559    5559                   Huntsman, Jon   \n",
       "                               5298    5298                   Huntsman, Jon   \n",
       "Johnson, Gary Earl             5769    5769              Johnson, Gary Earl   \n",
       "                               5851    5851              Johnson, Gary Earl   \n",
       "                               5731    5731              Johnson, Gary Earl   \n",
       "                               5849    5849              Johnson, Gary Earl   \n",
       "                               5841    5841              Johnson, Gary Earl   \n",
       "McCotter, Thaddeus G           5902    5902            McCotter, Thaddeus G   \n",
       "                               5914    5914            McCotter, Thaddeus G   \n",
       "                               5900    5900            McCotter, Thaddeus G   \n",
       "                               5908    5908            McCotter, Thaddeus G   \n",
       "                               5898    5898            McCotter, Thaddeus G   \n",
       "...                                     ...                             ...   \n",
       "Paul, Ron                      25801  25801                       Paul, Ron   \n",
       "                               28343  28343                       Paul, Ron   \n",
       "                               27643  27643                       Paul, Ron   \n",
       "                               24952  24952                       Paul, Ron   \n",
       "                               28455  28455                       Paul, Ron   \n",
       "Pawlenty, Timothy              30752  30752               Pawlenty, Timothy   \n",
       "                               30895  30895               Pawlenty, Timothy   \n",
       "                               30511  30511               Pawlenty, Timothy   \n",
       "                               30971  30971               Pawlenty, Timothy   \n",
       "                               30744  30744               Pawlenty, Timothy   \n",
       "Perry, Rick                    31198  31198                     Perry, Rick   \n",
       "                               32344  32344                     Perry, Rick   \n",
       "                               32538  32538                     Perry, Rick   \n",
       "                               31873  31873                     Perry, Rick   \n",
       "                               31909  31909                     Perry, Rick   \n",
       "Roemer, Charles E. 'Buddy' III 34265  34265  Roemer, Charles E. 'Buddy' III   \n",
       "                               33530  33530  Roemer, Charles E. 'Buddy' III   \n",
       "                               32996  32996  Roemer, Charles E. 'Buddy' III   \n",
       "                               33576  33576  Roemer, Charles E. 'Buddy' III   \n",
       "                               34117  34117  Roemer, Charles E. 'Buddy' III   \n",
       "Romney, Mitt                   37406  37406                    Romney, Mitt   \n",
       "                               34625  34625                    Romney, Mitt   \n",
       "                               36317  36317                    Romney, Mitt   \n",
       "                               36411  36411                    Romney, Mitt   \n",
       "                               37910  37910                    Romney, Mitt   \n",
       "Santorum, Rick                 38856  38856                  Santorum, Rick   \n",
       "                               39180  39180                  Santorum, Rick   \n",
       "                               39341  39341                  Santorum, Rick   \n",
       "                               39305  39305                  Santorum, Rick   \n",
       "                               39812  39812                  Santorum, Rick   \n",
       "\n",
       "                                                           contbr_occupation  \\\n",
       "cand_nm                                                                        \n",
       "Bachmann, Michelle             920                                 PRESIDENT   \n",
       "                               892                                 PHYSICIAN   \n",
       "                               555                                 HOMEMAKER   \n",
       "                               594                     INFORMATION REQUESTED   \n",
       "                               1058                                  RETIRED   \n",
       "Cain, Herman                   1536                                      CEO   \n",
       "                               2225                                PHYSICIAN   \n",
       "                               1897                                HOMEMAKER   \n",
       "                               2389                                  RETIRED   \n",
       "                               1928                    INFORMATION REQUESTED   \n",
       "Gingrich, Newt                 4065                                    OWNER   \n",
       "                               4219                                PRESIDENT   \n",
       "                               3559                                HOMEMAKER   \n",
       "                               3609   INFORMATION REQUESTED PER BEST EFFORTS   \n",
       "                               4481                                  RETIRED   \n",
       "Huntsman, Jon                  5466                                PRESIDENT   \n",
       "                               4981                                 ATTORNEY   \n",
       "                               5285                                HOMEMAKER   \n",
       "                               5559                                  RETIRED   \n",
       "                               5298   INFORMATION REQUESTED PER BEST EFFORTS   \n",
       "Johnson, Gary Earl             5769                                HOUSEWIFE   \n",
       "                               5851                            SELF-EMPLOYED   \n",
       "                               5731                               CONSULTANT   \n",
       "                               5849                            SELF EMPLOYED   \n",
       "                               5841                                  RETIRED   \n",
       "McCotter, Thaddeus G           5902                                HOMEMAKER   \n",
       "                               5914                                  RETIRED   \n",
       "                               5900                               GOVERNMENT   \n",
       "                               5908                                PHYSICIAN   \n",
       "                               5898                                EXECUTIVE   \n",
       "...                                                                      ...   \n",
       "Paul, Ron                      25801                               HOMEMAKER   \n",
       "                               28343                               REQUESTED   \n",
       "                               27643                               PHYSICIAN   \n",
       "                               24952                                ENGINEER   \n",
       "                               28455                                 RETIRED   \n",
       "Pawlenty, Timothy              30752  INFORMATION REQUESTED PER BEST EFFORTS   \n",
       "                               30895                               PRESIDENT   \n",
       "                               30511                                ATTORNEY   \n",
       "                               30971                                 RETIRED   \n",
       "                               30744                               HOMEMAKER   \n",
       "Perry, Rick                    31198                                ATTORNEY   \n",
       "                               32344                               PRESIDENT   \n",
       "                               32538                                 RETIRED   \n",
       "                               31873                               HOMEMAKER   \n",
       "                               31909  INFORMATION REQUESTED PER BEST EFFORTS   \n",
       "Roemer, Charles E. 'Buddy' III 34265                                 STUDENT   \n",
       "                               33530                               HOMEMAKER   \n",
       "                               32996                                ATTORNEY   \n",
       "                               33576                   INFORMATION REQUESTED   \n",
       "                               34117                                 RETIRED   \n",
       "Romney, Mitt                   37406                               PRESIDENT   \n",
       "                               34625                                ATTORNEY   \n",
       "                               36317                               HOMEMAKER   \n",
       "                               36411  INFORMATION REQUESTED PER BEST EFFORTS   \n",
       "                               37910                                 RETIRED   \n",
       "Santorum, Rick                 38856                                ATTORNEY   \n",
       "                               39180                               EXECUTIVE   \n",
       "                               39341    INFORMATION REQUESTED (BEST EFFORTS)   \n",
       "                               39305                               HOMEMAKER   \n",
       "                               39812                                 RETIRED   \n",
       "\n",
       "                                      contb_receipt_amt  \n",
       "cand_nm                                                  \n",
       "Bachmann, Michelle             920             68781.00  \n",
       "                               892             76134.00  \n",
       "                               555            102540.00  \n",
       "                               594            147638.89  \n",
       "                               1058           824618.05  \n",
       "Cain, Herman                   1536           125097.00  \n",
       "                               2225           125790.96  \n",
       "                               1897           153964.07  \n",
       "                               2389           779635.51  \n",
       "                               1928          3838719.32  \n",
       "Gingrich, Newt                 4065           273310.00  \n",
       "                               4219           332403.00  \n",
       "                               3559           426118.26  \n",
       "                               3609           910147.00  \n",
       "                               4481          2279602.27  \n",
       "Huntsman, Jon                  5466            92251.00  \n",
       "                               4981           143532.50  \n",
       "                               5285           241524.79  \n",
       "                               5559           352669.00  \n",
       "                               5298           354500.00  \n",
       "Johnson, Gary Earl             5769            11000.00  \n",
       "                               5851            14750.00  \n",
       "                               5731            16767.76  \n",
       "                               5849            18781.00  \n",
       "                               5841            85763.96  \n",
       "McCotter, Thaddeus G           5902             2400.00  \n",
       "                               5914             2450.00  \n",
       "                               5900             2500.00  \n",
       "                               5908             3650.00  \n",
       "                               5898             3750.00  \n",
       "...                                                 ...  \n",
       "Paul, Ron                      25801          310823.42  \n",
       "                               28343          381440.72  \n",
       "                               27643          509300.85  \n",
       "                               24952          612693.61  \n",
       "                               28455         1799513.76  \n",
       "Pawlenty, Timothy              30752          197841.18  \n",
       "                               30895          211708.92  \n",
       "                               30511          238331.10  \n",
       "                               30971          584195.00  \n",
       "                               30744          769514.95  \n",
       "Perry, Rick                    31198          768778.80  \n",
       "                               32344          845150.00  \n",
       "                               32538         1091671.00  \n",
       "                               31873         1818443.00  \n",
       "                               31909         1975508.76  \n",
       "Roemer, Charles E. 'Buddy' III 34265            6733.34  \n",
       "                               33530            8195.00  \n",
       "                               32996           14186.00  \n",
       "                               33576           18707.37  \n",
       "                               34117           73000.31  \n",
       "Romney, Mitt                   37406         1522751.99  \n",
       "                               34625         3662610.21  \n",
       "                               36317         5442013.48  \n",
       "                               36411         6394753.06  \n",
       "                               37910         6483596.24  \n",
       "Santorum, Rick                 38856          107130.00  \n",
       "                               39180          131456.55  \n",
       "                               39341          284718.10  \n",
       "                               39305          350597.75  \n",
       "                               39812          421952.98  \n",
       "\n",
       "[65 rows x 4 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def top5_donors(group):\n",
    "    return group.sort_index(by='contb_receipt_amt')[-5:]\n",
    "result.groupby('cand_nm').apply(top5_donors)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}