Prop-64-Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# My First Notebook\n",
    "THIS IS THE FIRST NOTEBOOK I AM PUBLISHING"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importing Pandas\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importing the CSV file and puting into a variable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "props = pd.read_csv(\"http://www.firstpythonnotebook.org/_static/committees.csv\")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## First Analyisis to see what is in the file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ocd_prop_id</th>\n",
       "      <th>calaccess_prop_id</th>\n",
       "      <th>ccdc_prop_id</th>\n",
       "      <th>prop_name</th>\n",
       "      <th>ccdc_committee_id</th>\n",
       "      <th>calaccess_committee_id</th>\n",
       "      <th>committee_name</th>\n",
       "      <th>committee_position</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6</td>\n",
       "      <td>1376258</td>\n",
       "      <td>70</td>\n",
       "      <td>PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...</td>\n",
       "      <td>382</td>\n",
       "      <td>1374469</td>\n",
       "      <td>YES ON PROPOSITION 51 - CALIFORNIANS FOR QUALI...</td>\n",
       "      <td>SUPPORT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        ocd_prop_id  calaccess_prop_id  \\\n",
       "0  ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6            1376258   \n",
       "\n",
       "   ccdc_prop_id                                          prop_name  \\\n",
       "0            70  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...   \n",
       "\n",
       "   ccdc_committee_id  calaccess_committee_id  \\\n",
       "0                382                 1374469   \n",
       "\n",
       "                                      committee_name committee_position  \n",
       "0  YES ON PROPOSITION 51 - CALIFORNIANS FOR QUALI...            SUPPORT  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "props.head(1)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 102 entries, 0 to 101\n",
      "Data columns (total 8 columns):\n",
      "ocd_prop_id               102 non-null object\n",
      "calaccess_prop_id         102 non-null int64\n",
      "ccdc_prop_id              102 non-null int64\n",
      "prop_name                 102 non-null object\n",
      "ccdc_committee_id         102 non-null int64\n",
      "calaccess_committee_id    102 non-null int64\n",
      "committee_name            102 non-null object\n",
      "committee_position        102 non-null object\n",
      "dtypes: int64(4), object(4)\n",
      "memory usage: 6.4+ KB\n"
     ]
    }
   ],
   "source": [
    "props.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "contribs = pd.read_csv(\"http://www.firstpythonnotebook.org/_static/contributions.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>calaccess_committee_id</th>\n",
       "      <th>committee_name</th>\n",
       "      <th>calaccess_filing_id</th>\n",
       "      <th>date_received</th>\n",
       "      <th>contributor_lastname</th>\n",
       "      <th>contributor_firstname</th>\n",
       "      <th>contributor_city</th>\n",
       "      <th>contributor_state</th>\n",
       "      <th>contributor_zip</th>\n",
       "      <th>contributor_employer</th>\n",
       "      <th>contributor_occupation</th>\n",
       "      <th>contributor_is_self_employed</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1386560</td>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>2083796</td>\n",
       "      <td>2016-09-18</td>\n",
       "      <td>BERGMAN</td>\n",
       "      <td>GRETCHEN</td>\n",
       "      <td>SPRING VALLEY</td>\n",
       "      <td>CA</td>\n",
       "      <td>91978</td>\n",
       "      <td>A NEW PATH</td>\n",
       "      <td>EXECUTIVE DIRECTOR</td>\n",
       "      <td>False</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1386560</td>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>2083796</td>\n",
       "      <td>2016-09-18</td>\n",
       "      <td>KAHLE</td>\n",
       "      <td>MYRNA</td>\n",
       "      <td>SAN DIEGO</td>\n",
       "      <td>CA</td>\n",
       "      <td>92109</td>\n",
       "      <td>NATIONAL SCHOOL DISTRICT</td>\n",
       "      <td>TEACHER</td>\n",
       "      <td>False</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1386560</td>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>2083796</td>\n",
       "      <td>2016-07-15</td>\n",
       "      <td>MCDEVITT</td>\n",
       "      <td>LEO</td>\n",
       "      <td>ESCONDIDO</td>\n",
       "      <td>CA</td>\n",
       "      <td>92025</td>\n",
       "      <td>LIFE IONIZERS</td>\n",
       "      <td>SEO/CONTENT MANAGER</td>\n",
       "      <td>False</td>\n",
       "      <td>198.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1386560</td>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>2083796</td>\n",
       "      <td>2016-08-10</td>\n",
       "      <td>WARREN-SAMARIPA</td>\n",
       "      <td>STEPHANIE</td>\n",
       "      <td>SAN DIEGO</td>\n",
       "      <td>CA</td>\n",
       "      <td>92116</td>\n",
       "      <td>STEPHANIE WARREN SAMARIPA</td>\n",
       "      <td>ENTREPRENEUR</td>\n",
       "      <td>False</td>\n",
       "      <td>-50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1386560</td>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>2083796</td>\n",
       "      <td>2016-07-26</td>\n",
       "      <td>WARREN-SAMARIPA</td>\n",
       "      <td>STEPHANIE</td>\n",
       "      <td>SAN DIEGO</td>\n",
       "      <td>CA</td>\n",
       "      <td>92116</td>\n",
       "      <td>STEPHANIE WARREN SAMARIPA</td>\n",
       "      <td>ENTREPRENEUR</td>\n",
       "      <td>True</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   calaccess_committee_id                              committee_name  \\\n",
       "0                 1386560  ADULT USE CAMPAIGN FOR PROPOSITION 64; THE   \n",
       "1                 1386560  ADULT USE CAMPAIGN FOR PROPOSITION 64; THE   \n",
       "2                 1386560  ADULT USE CAMPAIGN FOR PROPOSITION 64; THE   \n",
       "3                 1386560  ADULT USE CAMPAIGN FOR PROPOSITION 64; THE   \n",
       "4                 1386560  ADULT USE CAMPAIGN FOR PROPOSITION 64; THE   \n",
       "\n",
       "   calaccess_filing_id date_received contributor_lastname  \\\n",
       "0              2083796    2016-09-18              BERGMAN   \n",
       "1              2083796    2016-09-18                KAHLE   \n",
       "2              2083796    2016-07-15             MCDEVITT   \n",
       "3              2083796    2016-08-10      WARREN-SAMARIPA   \n",
       "4              2083796    2016-07-26      WARREN-SAMARIPA   \n",
       "\n",
       "  contributor_firstname contributor_city contributor_state contributor_zip  \\\n",
       "0              GRETCHEN    SPRING VALLEY                CA           91978   \n",
       "1                 MYRNA        SAN DIEGO                CA           92109   \n",
       "2                   LEO        ESCONDIDO                CA           92025   \n",
       "3             STEPHANIE        SAN DIEGO                CA           92116   \n",
       "4             STEPHANIE        SAN DIEGO                CA           92116   \n",
       "\n",
       "        contributor_employer contributor_occupation  \\\n",
       "0                 A NEW PATH     EXECUTIVE DIRECTOR   \n",
       "1   NATIONAL SCHOOL DISTRICT                TEACHER   \n",
       "2              LIFE IONIZERS    SEO/CONTENT MANAGER   \n",
       "3  STEPHANIE WARREN SAMARIPA           ENTREPRENEUR   \n",
       "4  STEPHANIE WARREN SAMARIPA           ENTREPRENEUR   \n",
       "\n",
       "   contributor_is_self_employed  amount  \n",
       "0                         False    84.0  \n",
       "1                         False    35.0  \n",
       "2                         False   198.0  \n",
       "3                         False   -50.0  \n",
       "4                          True    50.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contribs.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 56379 entries, 0 to 56378\n",
      "Data columns (total 13 columns):\n",
      "calaccess_committee_id          56379 non-null int64\n",
      "committee_name                  56379 non-null object\n",
      "calaccess_filing_id             56379 non-null int64\n",
      "date_received                   56379 non-null object\n",
      "contributor_lastname            56375 non-null object\n",
      "contributor_firstname           53411 non-null object\n",
      "contributor_city                56369 non-null object\n",
      "contributor_state               56363 non-null object\n",
      "contributor_zip                 56366 non-null object\n",
      "contributor_employer            48572 non-null object\n",
      "contributor_occupation          53273 non-null object\n",
      "contributor_is_self_employed    56379 non-null bool\n",
      "amount                          56379 non-null float64\n",
      "dtypes: bool(1), float64(1), int64(2), object(9)\n",
      "memory usage: 5.2+ MB\n"
     ]
    }
   ],
   "source": [
    "contribs.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Basic count to get Frequency Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>prop_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PROPOSITION 057 - CRIMINAL SENTENCES. JUVENILE...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PROPOSITION 062- DEATH PENALTY. INITIATIVE STA...</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PROPOSITION 059- SB 254 (CHAPTER 20, STATUTES ...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PROPOSITION 058 - SB 1174 (CHAPTER 753, STATUT...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PROPOSITION 061- STATE PRESCRIPTION DRUG PURCH...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PROPOSITION 060- ADULT FILMS. CONDOMS. HEALTH ...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PROPOSITION 065- CARRY-OUT BAGS. CHARGES. INIT...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                index  prop_name\n",
       "0   PROPOSITION 057 - CRIMINAL SENTENCES. JUVENILE...         13\n",
       "1   PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...         12\n",
       "2   PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...         11\n",
       "3   PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...          9\n",
       "4   PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...          8\n",
       "5   PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...          7\n",
       "6   PROPOSITION 062- DEATH PENALTY. INITIATIVE STA...          7\n",
       "7   PROPOSITION 059- SB 254 (CHAPTER 20, STATUTES ...          6\n",
       "8   PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...          4\n",
       "9   PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...          4\n",
       "10  PROPOSITION 058 - SB 1174 (CHAPTER 753, STATUT...          4\n",
       "11  PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...          4\n",
       "12  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...          4\n",
       "13  PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...          3\n",
       "14  PROPOSITION 061- STATE PRESCRIPTION DRUG PURCH...          3\n",
       "15  PROPOSITION 060- ADULT FILMS. CONDOMS. HEALTH ...          2\n",
       "16  PROPOSITION 065- CARRY-OUT BAGS. CHARGES. INIT...          1"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "props.prop_name.value_counts().reset_index()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>prop_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PROPOSITION 057 - CRIMINAL SENTENCES. JUVENILE...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PROPOSITION 062- DEATH PENALTY. INITIATIVE STA...</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PROPOSITION 059- SB 254 (CHAPTER 20, STATUTES ...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PROPOSITION 058 - SB 1174 (CHAPTER 753, STATUT...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PROPOSITION 061- STATE PRESCRIPTION DRUG PURCH...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PROPOSITION 060- ADULT FILMS. CONDOMS. HEALTH ...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PROPOSITION 065- CARRY-OUT BAGS. CHARGES. INIT...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                index  prop_name\n",
       "0   PROPOSITION 057 - CRIMINAL SENTENCES. JUVENILE...         13\n",
       "1   PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...         12\n",
       "2   PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...         11\n",
       "3   PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...          9\n",
       "4   PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...          8\n",
       "5   PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...          7\n",
       "6   PROPOSITION 062- DEATH PENALTY. INITIATIVE STA...          7\n",
       "7   PROPOSITION 059- SB 254 (CHAPTER 20, STATUTES ...          6\n",
       "8   PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...          4\n",
       "9   PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...          4\n",
       "10  PROPOSITION 058 - SB 1174 (CHAPTER 753, STATUT...          4\n",
       "11  PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...          4\n",
       "12  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...          4\n",
       "13  PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...          3\n",
       "14  PROPOSITION 061- STATE PRESCRIPTION DRUG PURCH...          3\n",
       "15  PROPOSITION 060- ADULT FILMS. CONDOMS. HEALTH ...          2\n",
       "16  PROPOSITION 065- CARRY-OUT BAGS. CHARGES. INIT...          1"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "props.prop_name.value_counts().reset_index()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Merging datasets on a common variable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "prop = props[props.prop_name == \"PROPOSITION 064- MARIJUANA LEGALIZATION. INITIATIVE STATUTE.\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 56379 entries, 0 to 56378\n",
      "Data columns (total 13 columns):\n",
      "calaccess_committee_id          56379 non-null int64\n",
      "committee_name                  56379 non-null object\n",
      "calaccess_filing_id             56379 non-null int64\n",
      "date_received                   56379 non-null object\n",
      "contributor_lastname            56375 non-null object\n",
      "contributor_firstname           53411 non-null object\n",
      "contributor_city                56369 non-null object\n",
      "contributor_state               56363 non-null object\n",
      "contributor_zip                 56366 non-null object\n",
      "contributor_employer            48572 non-null object\n",
      "contributor_occupation          53273 non-null object\n",
      "contributor_is_self_employed    56379 non-null bool\n",
      "amount                          56379 non-null float64\n",
      "dtypes: bool(1), float64(1), int64(2), object(9)\n",
      "memory usage: 5.2+ MB\n"
     ]
    }
   ],
   "source": [
    "contribs.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "merged = pd.merge(prop,contribs, on = \"calaccess_committee_id\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 860 entries, 0 to 859\n",
      "Data columns (total 20 columns):\n",
      "ocd_prop_id                     860 non-null object\n",
      "calaccess_prop_id               860 non-null int64\n",
      "ccdc_prop_id                    860 non-null int64\n",
      "prop_name                       860 non-null object\n",
      "ccdc_committee_id               860 non-null int64\n",
      "calaccess_committee_id          860 non-null int64\n",
      "committee_name_x                860 non-null object\n",
      "committee_position              860 non-null object\n",
      "committee_name_y                860 non-null object\n",
      "calaccess_filing_id             860 non-null int64\n",
      "date_received                   860 non-null object\n",
      "contributor_lastname            860 non-null object\n",
      "contributor_firstname           750 non-null object\n",
      "contributor_city                860 non-null object\n",
      "contributor_state               860 non-null object\n",
      "contributor_zip                 860 non-null object\n",
      "contributor_employer            657 non-null object\n",
      "contributor_occupation          742 non-null object\n",
      "contributor_is_self_employed    860 non-null bool\n",
      "amount                          860 non-null float64\n",
      "dtypes: bool(1), float64(1), int64(5), object(13)\n",
      "memory usage: 135.2+ KB\n"
     ]
    }
   ],
   "source": [
    "merged.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "35177017.640000001"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    8.600000e+02\n",
       "mean     4.090351e+04\n",
       "std      2.236710e+05\n",
       "min     -1.500000e+05\n",
       "25%      1.000000e+02\n",
       "50%      1.000000e+02\n",
       "75%      4.400000e+02\n",
       "max      4.000000e+06\n",
       "Name: amount, dtype: float64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.amount.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SUPPORT    762\n",
       "OPPOSE      98\n",
       "Name: committee_position, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.committee_position.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "support = merged[merged.committee_position ==\"SUPPORT\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "oppose = merged[merged.committee_position ==\"OPPOSE\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "32675806.0"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "support.amount.sum()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2501211.6400000001"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oppose.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.92889642704798669"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "support.amount.sum()/merged.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ocd_prop_id</th>\n",
       "      <th>calaccess_prop_id</th>\n",
       "      <th>ccdc_prop_id</th>\n",
       "      <th>prop_name</th>\n",
       "      <th>ccdc_committee_id</th>\n",
       "      <th>calaccess_committee_id</th>\n",
       "      <th>committee_name_x</th>\n",
       "      <th>committee_position</th>\n",
       "      <th>committee_name_y</th>\n",
       "      <th>calaccess_filing_id</th>\n",
       "      <th>date_received</th>\n",
       "      <th>contributor_lastname</th>\n",
       "      <th>contributor_firstname</th>\n",
       "      <th>contributor_city</th>\n",
       "      <th>contributor_state</th>\n",
       "      <th>contributor_zip</th>\n",
       "      <th>contributor_employer</th>\n",
       "      <th>contributor_occupation</th>\n",
       "      <th>contributor_is_self_employed</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>PARKER AND AFFILIATED ENTITIES</td>\n",
       "      <td>SEAN</td>\n",
       "      <td>PALO ALTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94301</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>4000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SACRAMENTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>95815</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>846</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>464</td>\n",
       "      <td>1385506</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>2083608</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>10019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1970000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>851</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>465</td>\n",
       "      <td>1385745</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>2082414</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>FUND FOR POLICY REFORM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILMINGTON</td>\n",
       "      <td>DE</td>\n",
       "      <td>19809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1970000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>465</td>\n",
       "      <td>1385745</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>2096507</td>\n",
       "      <td>2016-09-27</td>\n",
       "      <td>FUND FOR POLICY REFORM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILMINGTON</td>\n",
       "      <td>DE</td>\n",
       "      <td>19809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1403000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>PARKER AND AFFILIATED ENTITIES</td>\n",
       "      <td>SEAN</td>\n",
       "      <td>PALO ALTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94301</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-07-07</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SACRAMENTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>95815</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-09-16</td>\n",
       "      <td>PARKER AND AFFILIATED ENTITIES</td>\n",
       "      <td>SEAN</td>\n",
       "      <td>PALO ALTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94301</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>457</td>\n",
       "      <td>1382525</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>2063087</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>VAN AMERINGEN</td>\n",
       "      <td>HENRY</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>10011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>458</td>\n",
       "      <td>1376077</td>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</td>\n",
       "      <td>1982136</td>\n",
       "      <td>2015-04-16</td>\n",
       "      <td>GHOST MANAGEMENT GROUP, LLC DBA WEEDMAPS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IRVINE</td>\n",
       "      <td>CA</td>\n",
       "      <td>92618</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>465</td>\n",
       "      <td>1385745</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>2082414</td>\n",
       "      <td>2016-07-07</td>\n",
       "      <td>FUND FOR POLICY REFORM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILMINGTON</td>\n",
       "      <td>DE</td>\n",
       "      <td>19809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>463</td>\n",
       "      <td>1387789</td>\n",
       "      <td>SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...</td>\n",
       "      <td>2083142</td>\n",
       "      <td>2016-07-20</td>\n",
       "      <td>SCHAUER</td>\n",
       "      <td>JULIE</td>\n",
       "      <td>OAKS</td>\n",
       "      <td>PA</td>\n",
       "      <td>19456</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>845</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>464</td>\n",
       "      <td>1385506</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>2083608</td>\n",
       "      <td>2016-07-07</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>10019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>457</td>\n",
       "      <td>1382525</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>2083758</td>\n",
       "      <td>2016-07-27</td>\n",
       "      <td>PARKER</td>\n",
       "      <td>SEAN</td>\n",
       "      <td>PALO ALTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94301</td>\n",
       "      <td>SEAN PARKER FOUNDATION</td>\n",
       "      <td>CHAIRMAN</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WASHINGTON</td>\n",
       "      <td>DC</td>\n",
       "      <td>20036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>750000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>464</td>\n",
       "      <td>1385506</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>2064069</td>\n",
       "      <td>2016-05-03</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>10019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>550000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2098281</td>\n",
       "      <td>2016-10-11</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WASHINGTON</td>\n",
       "      <td>DC</td>\n",
       "      <td>20036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>550000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>848</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>465</td>\n",
       "      <td>1385745</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>2057298</td>\n",
       "      <td>2016-05-03</td>\n",
       "      <td>FUND FOR POLICY REFORM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILMINGTON</td>\n",
       "      <td>DE</td>\n",
       "      <td>19809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>550000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>465</td>\n",
       "      <td>1385745</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>2096507</td>\n",
       "      <td>2016-10-19</td>\n",
       "      <td>FUND FOR POLICY REFORM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILMINGTON</td>\n",
       "      <td>DE</td>\n",
       "      <td>19809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>457</td>\n",
       "      <td>1382525</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>2098142</td>\n",
       "      <td>2016-10-11</td>\n",
       "      <td>LEWIS</td>\n",
       "      <td>DANIEL</td>\n",
       "      <td>CORAL GABLES</td>\n",
       "      <td>FL</td>\n",
       "      <td>33146</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>457</td>\n",
       "      <td>1382525</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>2038497</td>\n",
       "      <td>2016-03-31</td>\n",
       "      <td>LEWIS</td>\n",
       "      <td>DANIEL</td>\n",
       "      <td>CORAL GABLES</td>\n",
       "      <td>FL</td>\n",
       "      <td>33146</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2064423</td>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WASHINGTON</td>\n",
       "      <td>DC</td>\n",
       "      <td>20036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>464</td>\n",
       "      <td>1385506</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>2064069</td>\n",
       "      <td>2016-05-26</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>10019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>420000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>465</td>\n",
       "      <td>1385745</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>2057298</td>\n",
       "      <td>2016-05-26</td>\n",
       "      <td>FUND FOR POLICY REFORM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILMINGTON</td>\n",
       "      <td>DE</td>\n",
       "      <td>19809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>420000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2063970</td>\n",
       "      <td>2016-05-26</td>\n",
       "      <td>DRUG POLICY ACTION - NON-PROFIT 501C4, YES ON ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SACRAMENTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>95815</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>420000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SACRAMENTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>95815</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>400000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>459</td>\n",
       "      <td>1382568</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>2098048</td>\n",
       "      <td>2016-09-27</td>\n",
       "      <td>SAM ACTION, INC.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALEXANDRIA</td>\n",
       "      <td>VA</td>\n",
       "      <td>22314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>400000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2063970</td>\n",
       "      <td>2016-05-03</td>\n",
       "      <td>DRUG POLICY ACTION - NON-PROFIT 501C4, YES ON ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SACRAMENTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>95815</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>300000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2130956</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>THIEL</td>\n",
       "      <td>PETER</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94129</td>\n",
       "      <td>THIEL CAPITAL, LLC</td>\n",
       "      <td>PRESIDENT</td>\n",
       "      <td>False</td>\n",
       "      <td>300000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>457</td>\n",
       "      <td>1382525</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>2098142</td>\n",
       "      <td>2016-10-04</td>\n",
       "      <td>DR BRONNER'S MAGIC SOAPS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VISTA</td>\n",
       "      <td>CA</td>\n",
       "      <td>92085</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2083494</td>\n",
       "      <td>2016-09-20</td>\n",
       "      <td>BONNELL</td>\n",
       "      <td>FRASER</td>\n",
       "      <td>BERKELEY</td>\n",
       "      <td>CA</td>\n",
       "      <td>94708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2130956</td>\n",
       "      <td>2016-12-01</td>\n",
       "      <td>PORTER</td>\n",
       "      <td>CHRISTINE A.</td>\n",
       "      <td>SAN JOSE</td>\n",
       "      <td>CA</td>\n",
       "      <td>95124</td>\n",
       "      <td>APPLE, INC.</td>\n",
       "      <td>ENGINEER</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2064423</td>\n",
       "      <td>2016-04-15</td>\n",
       "      <td>VIETS</td>\n",
       "      <td>DAN</td>\n",
       "      <td>COLUMBIA</td>\n",
       "      <td>MO</td>\n",
       "      <td>65201</td>\n",
       "      <td>DAN VIETS ATTORNEY AT LAW</td>\n",
       "      <td>ATTORNEY</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2064423</td>\n",
       "      <td>2016-04-08</td>\n",
       "      <td>VIETS</td>\n",
       "      <td>DAN</td>\n",
       "      <td>COLUMBIA</td>\n",
       "      <td>MO</td>\n",
       "      <td>65201</td>\n",
       "      <td>DAN VIETS ATTORNEY AT LAW</td>\n",
       "      <td>ATTORNEY</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2064423</td>\n",
       "      <td>2016-05-02</td>\n",
       "      <td>STEIGLEDER</td>\n",
       "      <td>MARC</td>\n",
       "      <td>SANTA MONICA</td>\n",
       "      <td>CA</td>\n",
       "      <td>90404</td>\n",
       "      <td>MARC STEIGLEDER, HANDYMAN</td>\n",
       "      <td>HANDYMAN</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2098546</td>\n",
       "      <td>2016-10-13</td>\n",
       "      <td>QUATTRIN</td>\n",
       "      <td>MONICA</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94123</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NOT EMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-08-18</td>\n",
       "      <td>SCHAIBLE</td>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>MOORPARK</td>\n",
       "      <td>CA</td>\n",
       "      <td>93021</td>\n",
       "      <td>TORTUGA ADVISERS LLC</td>\n",
       "      <td>INVESTMENT ADVISOR</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2063970</td>\n",
       "      <td>2016-06-17</td>\n",
       "      <td>MILLIGAN</td>\n",
       "      <td>BRUCE</td>\n",
       "      <td>BELLEVUE</td>\n",
       "      <td>WA</td>\n",
       "      <td>98005</td>\n",
       "      <td>MOBIUS BEVERAGE CORPORATION</td>\n",
       "      <td>FOUNDER</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2130986</td>\n",
       "      <td>2016-10-28</td>\n",
       "      <td>SANTSCHI</td>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>LOS ANGELES</td>\n",
       "      <td>CA</td>\n",
       "      <td>90077</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NOT EMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-07-07</td>\n",
       "      <td>KELSOE</td>\n",
       "      <td>JOHN</td>\n",
       "      <td>DEL MAR</td>\n",
       "      <td>CA</td>\n",
       "      <td>92014</td>\n",
       "      <td>UNIVERSITY OF CALIFORNIA, SAN DIEGO</td>\n",
       "      <td>PHYSICIAN</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2130956</td>\n",
       "      <td>2016-11-03</td>\n",
       "      <td>WINN</td>\n",
       "      <td>DYLAN</td>\n",
       "      <td>SAN MARCOS</td>\n",
       "      <td>CA</td>\n",
       "      <td>92069</td>\n",
       "      <td>FIRST DATA</td>\n",
       "      <td>SOFTWARE DEVELOPER</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-07-05</td>\n",
       "      <td>GOLDBERG</td>\n",
       "      <td>RICH</td>\n",
       "      <td>PENNGROVE</td>\n",
       "      <td>CA</td>\n",
       "      <td>94951</td>\n",
       "      <td>NONE</td>\n",
       "      <td>UNEMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2098281</td>\n",
       "      <td>2016-10-13</td>\n",
       "      <td>COX</td>\n",
       "      <td>KEVIN</td>\n",
       "      <td>ANTIOCH</td>\n",
       "      <td>CA</td>\n",
       "      <td>94509</td>\n",
       "      <td>NONE</td>\n",
       "      <td>UNEMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2130986</td>\n",
       "      <td>2016-10-28</td>\n",
       "      <td>OKEEFE</td>\n",
       "      <td>GEORGE</td>\n",
       "      <td>APPLE VALLEY</td>\n",
       "      <td>CA</td>\n",
       "      <td>92307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-09-22</td>\n",
       "      <td>MALMO</td>\n",
       "      <td>JOHN</td>\n",
       "      <td>FRESNO</td>\n",
       "      <td>CA</td>\n",
       "      <td>93737</td>\n",
       "      <td>NETZER &amp; MALMO</td>\n",
       "      <td>ATTORNEY</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2130956</td>\n",
       "      <td>2016-11-07</td>\n",
       "      <td>STOVER</td>\n",
       "      <td>MATTHEW</td>\n",
       "      <td>PHILADELPHIA</td>\n",
       "      <td>PA</td>\n",
       "      <td>19103</td>\n",
       "      <td>USA TRUCK</td>\n",
       "      <td>TRUCK DRIVER</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2098281</td>\n",
       "      <td>2016-10-06</td>\n",
       "      <td>FORD</td>\n",
       "      <td>JOHN</td>\n",
       "      <td>LAKEWOOD</td>\n",
       "      <td>CA</td>\n",
       "      <td>90713</td>\n",
       "      <td>NONE</td>\n",
       "      <td>UNEMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2130986</td>\n",
       "      <td>2016-10-31</td>\n",
       "      <td>DALLAS</td>\n",
       "      <td>JANICE</td>\n",
       "      <td>VENTURA</td>\n",
       "      <td>CA</td>\n",
       "      <td>93004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2064423</td>\n",
       "      <td>2016-06-29</td>\n",
       "      <td>HANNAN</td>\n",
       "      <td>LARRY</td>\n",
       "      <td>REDDING</td>\n",
       "      <td>CA</td>\n",
       "      <td>96003</td>\n",
       "      <td>NONE</td>\n",
       "      <td>UNEMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2098281</td>\n",
       "      <td>2016-10-14</td>\n",
       "      <td>VOEGTLI</td>\n",
       "      <td>JERRY</td>\n",
       "      <td>SIMI VALLEY</td>\n",
       "      <td>CA</td>\n",
       "      <td>93065</td>\n",
       "      <td>NONE</td>\n",
       "      <td>UNEMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-08-27</td>\n",
       "      <td>HANNAN</td>\n",
       "      <td>LARRY</td>\n",
       "      <td>REDDING</td>\n",
       "      <td>CA</td>\n",
       "      <td>96003</td>\n",
       "      <td>NONE</td>\n",
       "      <td>UNEMPLOYED</td>\n",
       "      <td>False</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-09-06</td>\n",
       "      <td>MITCHELL</td>\n",
       "      <td>BRIAN</td>\n",
       "      <td>REDONDO BEACH</td>\n",
       "      <td>CA</td>\n",
       "      <td>90278</td>\n",
       "      <td>DIRECTV</td>\n",
       "      <td>MANAGER</td>\n",
       "      <td>False</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2083528</td>\n",
       "      <td>2016-09-09</td>\n",
       "      <td>MALMO</td>\n",
       "      <td>JOHN</td>\n",
       "      <td>FRESNO</td>\n",
       "      <td>CA</td>\n",
       "      <td>93737</td>\n",
       "      <td>NETZER &amp; MALMO</td>\n",
       "      <td>ATTORNEY</td>\n",
       "      <td>False</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>456</td>\n",
       "      <td>1381808</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>2130956</td>\n",
       "      <td>2016-12-04</td>\n",
       "      <td>BROOKES</td>\n",
       "      <td>ETHAN</td>\n",
       "      <td>PLEASANT HILL</td>\n",
       "      <td>CA</td>\n",
       "      <td>94523</td>\n",
       "      <td>LONZA BIOSCIENCE</td>\n",
       "      <td>SALES CONSULTANT</td>\n",
       "      <td>False</td>\n",
       "      <td>-50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>462</td>\n",
       "      <td>1386560</td>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>2083796</td>\n",
       "      <td>2016-08-10</td>\n",
       "      <td>WARREN-SAMARIPA</td>\n",
       "      <td>STEPHANIE</td>\n",
       "      <td>SAN DIEGO</td>\n",
       "      <td>CA</td>\n",
       "      <td>92116</td>\n",
       "      <td>STEPHANIE WARREN SAMARIPA</td>\n",
       "      <td>ENTREPRENEUR</td>\n",
       "      <td>False</td>\n",
       "      <td>-50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2130986</td>\n",
       "      <td>2016-10-26</td>\n",
       "      <td>MEDLOCK</td>\n",
       "      <td>MARSTON</td>\n",
       "      <td>ALHAMBRA</td>\n",
       "      <td>CA</td>\n",
       "      <td>91801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>-100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2083494</td>\n",
       "      <td>2016-07-13</td>\n",
       "      <td>WOOD</td>\n",
       "      <td>DAVID</td>\n",
       "      <td>CALGARY</td>\n",
       "      <td>AB</td>\n",
       "      <td>T2P0R3</td>\n",
       "      <td>BORDEN LADNER GERVAIS</td>\n",
       "      <td>ATTORNEY</td>\n",
       "      <td>False</td>\n",
       "      <td>-100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2083494</td>\n",
       "      <td>2016-07-27</td>\n",
       "      <td>SAMIMI-ARDESTAN</td>\n",
       "      <td>AMIRGHASEM</td>\n",
       "      <td>NORTH VANCOUVER</td>\n",
       "      <td>BC</td>\n",
       "      <td>V7J1V2</td>\n",
       "      <td>MEDIGREEN</td>\n",
       "      <td>CHIEF EXECUTIVE OFFICER</td>\n",
       "      <td>False</td>\n",
       "      <td>-100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>793</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>461</td>\n",
       "      <td>1343793</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>2130986</td>\n",
       "      <td>2016-11-02</td>\n",
       "      <td>ROBINETT</td>\n",
       "      <td>PETER</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94114</td>\n",
       "      <td>APPLE, INC.</td>\n",
       "      <td>PROGRAMMER</td>\n",
       "      <td>False</td>\n",
       "      <td>-900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>458</td>\n",
       "      <td>1376077</td>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</td>\n",
       "      <td>2082735</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>GHOST MANAGEMENT GROUP, LLC DBA WEEDMAPS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IRVINE</td>\n",
       "      <td>CA</td>\n",
       "      <td>92618</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>-150000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>860 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          ocd_prop_id  calaccess_prop_id  \\\n",
       "142  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "79   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "846  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "851  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "852  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "141  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "78   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "143  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "253  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "259  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "850  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "839  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "845  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "254  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "134  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "843  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "206  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "848  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "853  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "257  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "251  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "44   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "844  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "849  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "521  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "69   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "312  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "520  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "245  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "255  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "..                                                ...                ...   \n",
       "589  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "242  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "62   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "61   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "55   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "774  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "149  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "397  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "794  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "108  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "249  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "96   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "183  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "807  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "119  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "244  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "185  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "801  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "28   ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "220  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "101  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "127  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "118  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "227  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "812  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "806  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "727  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "698  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "793  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "260  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "\n",
       "     ccdc_prop_id                                          prop_name  \\\n",
       "142            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "79             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "846            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "851            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "852            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "141            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "78             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "143            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "253            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "259            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "850            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "839            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "845            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "254            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "134            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "843            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "206            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "848            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "853            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "257            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "251            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "44             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "844            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "849            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "521            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "69             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "312            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "520            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "245            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "255            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "..            ...                                                ...   \n",
       "589            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "242            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "62             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "61             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "55             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "774            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "149            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "397            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "794            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "108            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "249            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "96             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "183            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "807            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "119            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "244            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "185            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "801            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "28             83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "220            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "101            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "127            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "118            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "227            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "812            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "806            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "727            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "698            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "793            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "260            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "\n",
       "     ccdc_committee_id  calaccess_committee_id  \\\n",
       "142                456                 1381808   \n",
       "79                 456                 1381808   \n",
       "846                464                 1385506   \n",
       "851                465                 1385745   \n",
       "852                465                 1385745   \n",
       "141                456                 1381808   \n",
       "78                 456                 1381808   \n",
       "143                456                 1381808   \n",
       "253                457                 1382525   \n",
       "259                458                 1376077   \n",
       "850                465                 1385745   \n",
       "839                463                 1387789   \n",
       "845                464                 1385506   \n",
       "254                457                 1382525   \n",
       "134                456                 1381808   \n",
       "843                464                 1385506   \n",
       "206                456                 1381808   \n",
       "848                465                 1385745   \n",
       "853                465                 1385745   \n",
       "257                457                 1382525   \n",
       "251                457                 1382525   \n",
       "44                 456                 1381808   \n",
       "844                464                 1385506   \n",
       "849                465                 1385745   \n",
       "521                461                 1343793   \n",
       "69                 456                 1381808   \n",
       "312                459                 1382568   \n",
       "520                461                 1343793   \n",
       "245                456                 1381808   \n",
       "255                457                 1382525   \n",
       "..                 ...                     ...   \n",
       "589                461                 1343793   \n",
       "242                456                 1381808   \n",
       "62                 456                 1381808   \n",
       "61                 456                 1381808   \n",
       "55                 456                 1381808   \n",
       "774                461                 1343793   \n",
       "149                456                 1381808   \n",
       "397                461                 1343793   \n",
       "794                461                 1343793   \n",
       "108                456                 1381808   \n",
       "249                456                 1381808   \n",
       "96                 456                 1381808   \n",
       "183                456                 1381808   \n",
       "807                461                 1343793   \n",
       "119                456                 1381808   \n",
       "244                456                 1381808   \n",
       "185                456                 1381808   \n",
       "801                461                 1343793   \n",
       "28                 456                 1381808   \n",
       "220                456                 1381808   \n",
       "101                456                 1381808   \n",
       "127                456                 1381808   \n",
       "118                456                 1381808   \n",
       "227                456                 1381808   \n",
       "812                462                 1386560   \n",
       "806                461                 1343793   \n",
       "727                461                 1343793   \n",
       "698                461                 1343793   \n",
       "793                461                 1343793   \n",
       "260                458                 1376077   \n",
       "\n",
       "                                      committee_name_x committee_position  \\\n",
       "142  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "79   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "846  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...            SUPPORT   \n",
       "851       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            SUPPORT   \n",
       "852       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            SUPPORT   \n",
       "141  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "78   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "143  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "253                             NEW APPROACH PAC (MPO)            SUPPORT   \n",
       "259  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...            SUPPORT   \n",
       "850       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            SUPPORT   \n",
       "839  SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...             OPPOSE   \n",
       "845  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...            SUPPORT   \n",
       "254                             NEW APPROACH PAC (MPO)            SUPPORT   \n",
       "134  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "843  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...            SUPPORT   \n",
       "206  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "848       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            SUPPORT   \n",
       "853       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            SUPPORT   \n",
       "257                             NEW APPROACH PAC (MPO)            SUPPORT   \n",
       "251                             NEW APPROACH PAC (MPO)            SUPPORT   \n",
       "44   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "844  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...            SUPPORT   \n",
       "849       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            SUPPORT   \n",
       "521  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "69   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "312  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...             OPPOSE   \n",
       "520  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "245  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "255                             NEW APPROACH PAC (MPO)            SUPPORT   \n",
       "..                                                 ...                ...   \n",
       "589  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "242  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "62   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "61   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "55   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "774  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "149  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "397  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "794  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "108  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "249  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "96   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "183  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "807  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "119  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "244  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "185  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "801  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "28   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "220  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "101  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "127  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "118  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "227  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "812         ADULT USE CAMPAIGN FOR PROPOSITION 64; THE            SUPPORT   \n",
       "806  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "727  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "698  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "793  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...            SUPPORT   \n",
       "260  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...            SUPPORT   \n",
       "\n",
       "                                      committee_name_y  calaccess_filing_id  \\\n",
       "142  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "79   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "846  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...              2083608   \n",
       "851       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2082414   \n",
       "852       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2096507   \n",
       "141  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "78   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "143  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "253                             NEW APPROACH PAC (MPO)              2063087   \n",
       "259  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...              1982136   \n",
       "850       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2082414   \n",
       "839  SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...              2083142   \n",
       "845  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...              2083608   \n",
       "254                             NEW APPROACH PAC (MPO)              2083758   \n",
       "134  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "843  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...              2064069   \n",
       "206  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2098281   \n",
       "848       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2057298   \n",
       "853       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2096507   \n",
       "257                             NEW APPROACH PAC (MPO)              2098142   \n",
       "251                             NEW APPROACH PAC (MPO)              2038497   \n",
       "44   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2064423   \n",
       "844  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...              2064069   \n",
       "849       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2057298   \n",
       "521  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2063970   \n",
       "69   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "312  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...              2098048   \n",
       "520  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2063970   \n",
       "245  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2130956   \n",
       "255                             NEW APPROACH PAC (MPO)              2098142   \n",
       "..                                                 ...                  ...   \n",
       "589  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2083494   \n",
       "242  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2130956   \n",
       "62   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2064423   \n",
       "61   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2064423   \n",
       "55   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2064423   \n",
       "774  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2098546   \n",
       "149  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "397  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2063970   \n",
       "794  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2130986   \n",
       "108  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "249  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2130956   \n",
       "96   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "183  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2098281   \n",
       "807  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2130986   \n",
       "119  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "244  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2130956   \n",
       "185  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2098281   \n",
       "801  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2130986   \n",
       "28   YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2064423   \n",
       "220  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2098281   \n",
       "101  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "127  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "118  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2083528   \n",
       "227  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2130956   \n",
       "812         ADULT USE CAMPAIGN FOR PROPOSITION 64; THE              2083796   \n",
       "806  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2130986   \n",
       "727  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2083494   \n",
       "698  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2083494   \n",
       "793  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...              2130986   \n",
       "260  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...              2082735   \n",
       "\n",
       "    date_received                               contributor_lastname  \\\n",
       "142    2016-09-15                     PARKER AND AFFILIATED ENTITIES   \n",
       "79     2016-09-15  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...   \n",
       "846    2016-09-15      FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))   \n",
       "851    2016-09-15                             FUND FOR POLICY REFORM   \n",
       "852    2016-09-27                             FUND FOR POLICY REFORM   \n",
       "141    2016-07-01                     PARKER AND AFFILIATED ENTITIES   \n",
       "78     2016-07-07  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...   \n",
       "143    2016-09-16                     PARKER AND AFFILIATED ENTITIES   \n",
       "253    2016-06-30                                      VAN AMERINGEN   \n",
       "259    2015-04-16           GHOST MANAGEMENT GROUP, LLC DBA WEEDMAPS   \n",
       "850    2016-07-07                             FUND FOR POLICY REFORM   \n",
       "839    2016-07-20                                            SCHAUER   \n",
       "845    2016-07-07      FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))   \n",
       "254    2016-07-27                                             PARKER   \n",
       "134    2016-07-01                             NEW APPROACH PAC (MPO)   \n",
       "843    2016-05-03      FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))   \n",
       "206    2016-10-11                             NEW APPROACH PAC (MPO)   \n",
       "848    2016-05-03                             FUND FOR POLICY REFORM   \n",
       "853    2016-10-19                             FUND FOR POLICY REFORM   \n",
       "257    2016-10-11                                              LEWIS   \n",
       "251    2016-03-31                                              LEWIS   \n",
       "44     2016-04-01                             NEW APPROACH PAC (MPO)   \n",
       "844    2016-05-26      FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))   \n",
       "849    2016-05-26                             FUND FOR POLICY REFORM   \n",
       "521    2016-05-26  DRUG POLICY ACTION - NON-PROFIT 501C4, YES ON ...   \n",
       "69     2016-09-15  CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...   \n",
       "312    2016-09-27                                   SAM ACTION, INC.   \n",
       "520    2016-05-03  DRUG POLICY ACTION - NON-PROFIT 501C4, YES ON ...   \n",
       "245    2016-11-01                                              THIEL   \n",
       "255    2016-10-04                           DR BRONNER'S MAGIC SOAPS   \n",
       "..            ...                                                ...   \n",
       "589    2016-09-20                                            BONNELL   \n",
       "242    2016-12-01                                             PORTER   \n",
       "62     2016-04-15                                              VIETS   \n",
       "61     2016-04-08                                              VIETS   \n",
       "55     2016-05-02                                         STEIGLEDER   \n",
       "774    2016-10-13                                           QUATTRIN   \n",
       "149    2016-08-18                                           SCHAIBLE   \n",
       "397    2016-06-17                                           MILLIGAN   \n",
       "794    2016-10-28                                           SANTSCHI   \n",
       "108    2016-07-07                                             KELSOE   \n",
       "249    2016-11-03                                               WINN   \n",
       "96     2016-07-05                                           GOLDBERG   \n",
       "183    2016-10-13                                                COX   \n",
       "807    2016-10-28                                             OKEEFE   \n",
       "119    2016-09-22                                              MALMO   \n",
       "244    2016-11-07                                             STOVER   \n",
       "185    2016-10-06                                               FORD   \n",
       "801    2016-10-31                                             DALLAS   \n",
       "28     2016-06-29                                             HANNAN   \n",
       "220    2016-10-14                                            VOEGTLI   \n",
       "101    2016-08-27                                             HANNAN   \n",
       "127    2016-09-06                                           MITCHELL   \n",
       "118    2016-09-09                                              MALMO   \n",
       "227    2016-12-04                                            BROOKES   \n",
       "812    2016-08-10                                    WARREN-SAMARIPA   \n",
       "806    2016-10-26                                            MEDLOCK   \n",
       "727    2016-07-13                                               WOOD   \n",
       "698    2016-07-27                                    SAMIMI-ARDESTAN   \n",
       "793    2016-11-02                                           ROBINETT   \n",
       "260    2016-08-04           GHOST MANAGEMENT GROUP, LLC DBA WEEDMAPS   \n",
       "\n",
       "    contributor_firstname contributor_city contributor_state contributor_zip  \\\n",
       "142                  SEAN        PALO ALTO                CA           94301   \n",
       "79                    NaN       SACRAMENTO                CA           95815   \n",
       "846                   NaN         NEW YORK                NY           10019   \n",
       "851                   NaN       WILMINGTON                DE           19809   \n",
       "852                   NaN       WILMINGTON                DE           19809   \n",
       "141                  SEAN        PALO ALTO                CA           94301   \n",
       "78                    NaN       SACRAMENTO                CA           95815   \n",
       "143                  SEAN        PALO ALTO                CA           94301   \n",
       "253                 HENRY         NEW YORK                NY           10011   \n",
       "259                   NaN           IRVINE                CA           92618   \n",
       "850                   NaN       WILMINGTON                DE           19809   \n",
       "839                 JULIE             OAKS                PA           19456   \n",
       "845                   NaN         NEW YORK                NY           10019   \n",
       "254                  SEAN        PALO ALTO                CA           94301   \n",
       "134                   NaN       WASHINGTON                DC           20036   \n",
       "843                   NaN         NEW YORK                NY           10019   \n",
       "206                   NaN       WASHINGTON                DC           20036   \n",
       "848                   NaN       WILMINGTON                DE           19809   \n",
       "853                   NaN       WILMINGTON                DE           19809   \n",
       "257                DANIEL     CORAL GABLES                FL           33146   \n",
       "251                DANIEL     CORAL GABLES                FL           33146   \n",
       "44                    NaN       WASHINGTON                DC           20036   \n",
       "844                   NaN         NEW YORK                NY           10019   \n",
       "849                   NaN       WILMINGTON                DE           19809   \n",
       "521                   NaN       SACRAMENTO                CA           95815   \n",
       "69                    NaN       SACRAMENTO                CA           95815   \n",
       "312                   NaN       ALEXANDRIA                VA           22314   \n",
       "520                   NaN       SACRAMENTO                CA           95815   \n",
       "245                 PETER    SAN FRANCISCO                CA           94129   \n",
       "255                   NaN            VISTA                CA           92085   \n",
       "..                    ...              ...               ...             ...   \n",
       "589                FRASER         BERKELEY                CA           94708   \n",
       "242          CHRISTINE A.         SAN JOSE                CA           95124   \n",
       "62                    DAN         COLUMBIA                MO           65201   \n",
       "61                    DAN         COLUMBIA                MO           65201   \n",
       "55                   MARC     SANTA MONICA                CA           90404   \n",
       "774                MONICA    SAN FRANCISCO                CA           94123   \n",
       "149               MICHAEL         MOORPARK                CA           93021   \n",
       "397                 BRUCE         BELLEVUE                WA           98005   \n",
       "794               WILLIAM      LOS ANGELES                CA           90077   \n",
       "108                  JOHN          DEL MAR                CA           92014   \n",
       "249                 DYLAN       SAN MARCOS                CA           92069   \n",
       "96                   RICH        PENNGROVE                CA           94951   \n",
       "183                 KEVIN          ANTIOCH                CA           94509   \n",
       "807                GEORGE     APPLE VALLEY                CA           92307   \n",
       "119                  JOHN           FRESNO                CA           93737   \n",
       "244               MATTHEW     PHILADELPHIA                PA           19103   \n",
       "185                  JOHN         LAKEWOOD                CA           90713   \n",
       "801                JANICE          VENTURA                CA           93004   \n",
       "28                  LARRY          REDDING                CA           96003   \n",
       "220                 JERRY      SIMI VALLEY                CA           93065   \n",
       "101                 LARRY          REDDING                CA           96003   \n",
       "127                 BRIAN    REDONDO BEACH                CA           90278   \n",
       "118                  JOHN           FRESNO                CA           93737   \n",
       "227                 ETHAN    PLEASANT HILL                CA           94523   \n",
       "812             STEPHANIE        SAN DIEGO                CA           92116   \n",
       "806               MARSTON         ALHAMBRA                CA           91801   \n",
       "727                 DAVID          CALGARY                AB          T2P0R3   \n",
       "698            AMIRGHASEM  NORTH VANCOUVER                BC          V7J1V2   \n",
       "793                 PETER    SAN FRANCISCO                CA           94114   \n",
       "260                   NaN           IRVINE                CA           92618   \n",
       "\n",
       "                    contributor_employer   contributor_occupation  \\\n",
       "142                                  NaN                      NaN   \n",
       "79                                   NaN                      NaN   \n",
       "846                                  NaN                      NaN   \n",
       "851                                  NaN                      NaN   \n",
       "852                                  NaN                      NaN   \n",
       "141                                  NaN                      NaN   \n",
       "78                                   NaN                      NaN   \n",
       "143                                  NaN                      NaN   \n",
       "253                                  NaN                  RETIRED   \n",
       "259                                  NaN                      NaN   \n",
       "850                                  NaN                      NaN   \n",
       "839                                  NaN                  RETIRED   \n",
       "845                                  NaN                      NaN   \n",
       "254               SEAN PARKER FOUNDATION                 CHAIRMAN   \n",
       "134                                  NaN                      NaN   \n",
       "843                                  NaN                      NaN   \n",
       "206                                  NaN                      NaN   \n",
       "848                                  NaN                      NaN   \n",
       "853                                  NaN                      NaN   \n",
       "257                              RETIRED                      NaN   \n",
       "251                                  NaN                  RETIRED   \n",
       "44                                   NaN                      NaN   \n",
       "844                                  NaN                      NaN   \n",
       "849                                  NaN                      NaN   \n",
       "521                                  NaN                      NaN   \n",
       "69                                   NaN                      NaN   \n",
       "312                                  NaN                      NaN   \n",
       "520                                  NaN                      NaN   \n",
       "245                   THIEL CAPITAL, LLC                PRESIDENT   \n",
       "255                                  NaN                      NaN   \n",
       "..                                   ...                      ...   \n",
       "589                                  NaN                  RETIRED   \n",
       "242                          APPLE, INC.                 ENGINEER   \n",
       "62             DAN VIETS ATTORNEY AT LAW                 ATTORNEY   \n",
       "61             DAN VIETS ATTORNEY AT LAW                 ATTORNEY   \n",
       "55             MARC STEIGLEDER, HANDYMAN                 HANDYMAN   \n",
       "774                                  NaN             NOT EMPLOYED   \n",
       "149                 TORTUGA ADVISERS LLC       INVESTMENT ADVISOR   \n",
       "397          MOBIUS BEVERAGE CORPORATION                  FOUNDER   \n",
       "794                                  NaN             NOT EMPLOYED   \n",
       "108  UNIVERSITY OF CALIFORNIA, SAN DIEGO                PHYSICIAN   \n",
       "249                           FIRST DATA       SOFTWARE DEVELOPER   \n",
       "96                                  NONE               UNEMPLOYED   \n",
       "183                                 NONE               UNEMPLOYED   \n",
       "807                                  NaN                  RETIRED   \n",
       "119                       NETZER & MALMO                 ATTORNEY   \n",
       "244                            USA TRUCK             TRUCK DRIVER   \n",
       "185                                 NONE               UNEMPLOYED   \n",
       "801                                  NaN                  RETIRED   \n",
       "28                                  NONE               UNEMPLOYED   \n",
       "220                                 NONE               UNEMPLOYED   \n",
       "101                                 NONE               UNEMPLOYED   \n",
       "127                              DIRECTV                  MANAGER   \n",
       "118                       NETZER & MALMO                 ATTORNEY   \n",
       "227                     LONZA BIOSCIENCE         SALES CONSULTANT   \n",
       "812            STEPHANIE WARREN SAMARIPA             ENTREPRENEUR   \n",
       "806                                  NaN                  RETIRED   \n",
       "727                BORDEN LADNER GERVAIS                 ATTORNEY   \n",
       "698                            MEDIGREEN  CHIEF EXECUTIVE OFFICER   \n",
       "793                          APPLE, INC.               PROGRAMMER   \n",
       "260                                  NaN                      NaN   \n",
       "\n",
       "     contributor_is_self_employed     amount  \n",
       "142                         False  4000000.0  \n",
       "79                          False  2000000.0  \n",
       "846                         False  1970000.0  \n",
       "851                         False  1970000.0  \n",
       "852                         False  1403000.0  \n",
       "141                         False  1250000.0  \n",
       "78                          False  1000000.0  \n",
       "143                         False  1000000.0  \n",
       "253                         False  1000000.0  \n",
       "259                         False  1000000.0  \n",
       "850                         False  1000000.0  \n",
       "839                         False  1000000.0  \n",
       "845                         False  1000000.0  \n",
       "254                         False  1000000.0  \n",
       "134                         False   750000.0  \n",
       "843                         False   550000.0  \n",
       "206                         False   550000.0  \n",
       "848                         False   550000.0  \n",
       "853                         False   500000.0  \n",
       "257                         False   500000.0  \n",
       "251                         False   500000.0  \n",
       "44                          False   500000.0  \n",
       "844                         False   420000.0  \n",
       "849                         False   420000.0  \n",
       "521                         False   420000.0  \n",
       "69                          False   400000.0  \n",
       "312                         False   400000.0  \n",
       "520                         False   300000.0  \n",
       "245                         False   300000.0  \n",
       "255                         False   250000.0  \n",
       "..                            ...        ...  \n",
       "589                         False       25.0  \n",
       "242                         False       25.0  \n",
       "62                          False       25.0  \n",
       "61                          False       25.0  \n",
       "55                          False       25.0  \n",
       "774                         False       25.0  \n",
       "149                         False       25.0  \n",
       "397                         False       25.0  \n",
       "794                         False       25.0  \n",
       "108                         False       25.0  \n",
       "249                         False       25.0  \n",
       "96                          False       25.0  \n",
       "183                         False       25.0  \n",
       "807                         False       25.0  \n",
       "119                         False       25.0  \n",
       "244                         False       25.0  \n",
       "185                         False       25.0  \n",
       "801                         False       25.0  \n",
       "28                          False       20.0  \n",
       "220                         False       10.0  \n",
       "101                         False       10.0  \n",
       "127                         False       10.0  \n",
       "118                         False       10.0  \n",
       "227                         False      -50.0  \n",
       "812                         False      -50.0  \n",
       "806                         False     -100.0  \n",
       "727                         False     -100.0  \n",
       "698                         False     -100.0  \n",
       "793                         False     -900.0  \n",
       "260                         False  -150000.0  \n",
       "\n",
       "[860 rows x 20 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.sort_values(\"amount\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ocd_prop_id</th>\n",
       "      <th>calaccess_prop_id</th>\n",
       "      <th>ccdc_prop_id</th>\n",
       "      <th>prop_name</th>\n",
       "      <th>ccdc_committee_id</th>\n",
       "      <th>calaccess_committee_id</th>\n",
       "      <th>committee_name_x</th>\n",
       "      <th>committee_position</th>\n",
       "      <th>committee_name_y</th>\n",
       "      <th>calaccess_filing_id</th>\n",
       "      <th>date_received</th>\n",
       "      <th>contributor_lastname</th>\n",
       "      <th>contributor_firstname</th>\n",
       "      <th>contributor_city</th>\n",
       "      <th>contributor_state</th>\n",
       "      <th>contributor_zip</th>\n",
       "      <th>contributor_employer</th>\n",
       "      <th>contributor_occupation</th>\n",
       "      <th>contributor_is_self_employed</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>463</td>\n",
       "      <td>1387789</td>\n",
       "      <td>SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...</td>\n",
       "      <td>2083142</td>\n",
       "      <td>2016-07-20</td>\n",
       "      <td>SCHAUER</td>\n",
       "      <td>JULIE</td>\n",
       "      <td>OAKS</td>\n",
       "      <td>PA</td>\n",
       "      <td>19456</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>459</td>\n",
       "      <td>1382568</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>2098048</td>\n",
       "      <td>2016-09-27</td>\n",
       "      <td>SAM ACTION, INC.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALEXANDRIA</td>\n",
       "      <td>VA</td>\n",
       "      <td>22314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>400000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>459</td>\n",
       "      <td>1382568</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>2083071</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>SAM ACTION, INC.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALEXANDRIA</td>\n",
       "      <td>VA</td>\n",
       "      <td>22314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>225000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>459</td>\n",
       "      <td>1382568</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>2083071</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>SAM ACTION, INC.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALEXANDRIA</td>\n",
       "      <td>VA</td>\n",
       "      <td>22314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>200000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e</td>\n",
       "      <td>1381868</td>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "      <td>463</td>\n",
       "      <td>1387789</td>\n",
       "      <td>SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...</td>\n",
       "      <td>2083142</td>\n",
       "      <td>2016-07-25</td>\n",
       "      <td>SCHAUER</td>\n",
       "      <td>JULIE</td>\n",
       "      <td>OAKS</td>\n",
       "      <td>CA</td>\n",
       "      <td>19456</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>False</td>\n",
       "      <td>150000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          ocd_prop_id  calaccess_prop_id  \\\n",
       "839  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "312  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "310  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "308  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "840  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "\n",
       "     ccdc_prop_id                                          prop_name  \\\n",
       "839            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "312            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "310            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "308            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "840            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "\n",
       "     ccdc_committee_id  calaccess_committee_id  \\\n",
       "839                463                 1387789   \n",
       "312                459                 1382568   \n",
       "310                459                 1382568   \n",
       "308                459                 1382568   \n",
       "840                463                 1387789   \n",
       "\n",
       "                                      committee_name_x committee_position  \\\n",
       "839  SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...             OPPOSE   \n",
       "312  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...             OPPOSE   \n",
       "310  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...             OPPOSE   \n",
       "308  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...             OPPOSE   \n",
       "840  SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...             OPPOSE   \n",
       "\n",
       "                                      committee_name_y  calaccess_filing_id  \\\n",
       "839  SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...              2083142   \n",
       "312  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...              2098048   \n",
       "310  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...              2083071   \n",
       "308  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...              2083071   \n",
       "840  SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...              2083142   \n",
       "\n",
       "    date_received contributor_lastname contributor_firstname contributor_city  \\\n",
       "839    2016-07-20              SCHAUER                 JULIE             OAKS   \n",
       "312    2016-09-27     SAM ACTION, INC.                   NaN       ALEXANDRIA   \n",
       "310    2016-09-15     SAM ACTION, INC.                   NaN       ALEXANDRIA   \n",
       "308    2016-09-12     SAM ACTION, INC.                   NaN       ALEXANDRIA   \n",
       "840    2016-07-25              SCHAUER                 JULIE             OAKS   \n",
       "\n",
       "    contributor_state contributor_zip contributor_employer  \\\n",
       "839                PA           19456                  NaN   \n",
       "312                VA           22314                  NaN   \n",
       "310                VA           22314                  NaN   \n",
       "308                VA           22314                  NaN   \n",
       "840                CA           19456                  NaN   \n",
       "\n",
       "    contributor_occupation  contributor_is_self_employed     amount  \n",
       "839                RETIRED                         False  1000000.0  \n",
       "312                    NaN                         False   400000.0  \n",
       "310                    NaN                         False   225000.0  \n",
       "308                    NaN                         False   200000.0  \n",
       "840                RETIRED                         False   150000.0  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oppose.sort_values(\"amount\", ascending=False).head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Grouping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>committee_name_x</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...</td>\n",
       "      <td>15734047.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))</td>\n",
       "      <td>6140000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...</td>\n",
       "      <td>4470000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NEW APPROACH PAC (MPO)</td>\n",
       "      <td>3865000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...</td>\n",
       "      <td>1364000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...</td>\n",
       "      <td>1130930.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...</td>\n",
       "      <td>860470.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</td>\n",
       "      <td>850000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>MARIJUANA POLICY PROJECT OF CALIFORNIA, YES ON 64</td>\n",
       "      <td>739200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ADULT USE CAMPAIGN FOR PROPOSITION 64; THE</td>\n",
       "      <td>17089.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>MOMS STRONG AGAINST PROP 64</td>\n",
       "      <td>6281.64</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     committee_name_x       amount\n",
       "10  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...  15734047.00\n",
       "4        FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))   6140000.00\n",
       "3   DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...   4470000.00\n",
       "7                              NEW APPROACH PAC (MPO)   3865000.00\n",
       "9   SAM ACTION, INC., A COMMITTEE AGAINST PROPOSIT...   1364000.00\n",
       "8   PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...   1130930.00\n",
       "1   CALIFORNIANS FOR RESPONSIBLE MARIJUANA REFORM,...    860470.00\n",
       "2   CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...    850000.00\n",
       "5   MARIJUANA POLICY PROJECT OF CALIFORNIA, YES ON 64    739200.00\n",
       "0          ADULT USE CAMPAIGN FOR PROPOSITION 64; THE     17089.00\n",
       "6                         MOMS STRONG AGAINST PROP 64      6281.64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.groupby(\"committee_name_x\").amount.sum().reset_index().sort_values(\"amount\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>contributor_firstname</th>\n",
       "      <th>contributor_lastname</th>\n",
       "      <th>committee_position</th>\n",
       "      <th>contributor_employer</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>SEAN</td>\n",
       "      <td>PARKER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>SEAN PARKER FOUNDATION</td>\n",
       "      <td>1250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>DANIEL</td>\n",
       "      <td>LEWIS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>RETIRED</td>\n",
       "      <td>500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>NICHOLAS</td>\n",
       "      <td>PRITZKER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>TAO CAPITAL PARTNERS LLC</td>\n",
       "      <td>450000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>NICHOLAS</td>\n",
       "      <td>PRITZKER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>TAO CAPITAL PARTNERS, LLC</td>\n",
       "      <td>450000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>PETER</td>\n",
       "      <td>THIEL</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>THIEL CAPITAL, LLC</td>\n",
       "      <td>300000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>SEAN</td>\n",
       "      <td>PARKER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>SEAN N PARKER FOUNDATION</td>\n",
       "      <td>250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>ROGER</td>\n",
       "      <td>JENKINS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NONE</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ANGELA</td>\n",
       "      <td>HOWARD</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DESIGNER</td>\n",
       "      <td>65000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>LAWRENCE</td>\n",
       "      <td>HESS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>LEHBROS LIMITED, LLC</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>ZACHARY PYM</td>\n",
       "      <td>WILLIAMS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CONDE NAST TRAVELER</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>ROGER B.</td>\n",
       "      <td>MCNAMEE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>ELEVATION PARTNERS</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>JASON</td>\n",
       "      <td>POST</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>POST INVESTMENT GROUP</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>ROBERT</td>\n",
       "      <td>ADAMS</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>CS</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>JEREMY</td>\n",
       "      <td>ZACHARY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CULTURE MAGAZINE</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>LAURIE</td>\n",
       "      <td>BENENSON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>LAURIE BENENSON</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>MARY QUINN</td>\n",
       "      <td>DELANEY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>AKONADI FOUNDATION</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>DEAN</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>CSI</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>CAMILLA</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CAMILLA FIELD</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>SHARON K.</td>\n",
       "      <td>CHRISTIE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>AROMAFLORIA</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>KHURSHID</td>\n",
       "      <td>KHOJA</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>KHURSID KHOJA</td>\n",
       "      <td>3300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>JULI</td>\n",
       "      <td>CROCKETT</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>W VAPES</td>\n",
       "      <td>3000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>STEVEN</td>\n",
       "      <td>PERSKY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>PERSKY FINANCIAL MANAGEMENT</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>SHARI</td>\n",
       "      <td>FOOS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>THE NARRATIVE METHOD</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>DOUG</td>\n",
       "      <td>LANPHERE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>GREEN OREGON ENTERPRISE</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>CHARLES</td>\n",
       "      <td>ROVEN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CHARLES ROVEN</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>KLEIN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>BIO365, LLC</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>PATRICK</td>\n",
       "      <td>MCMANAMON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CANNASURE INSURANCE SERVICES, LLC</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>STEINMETZ</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>FLOW KANA</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>STEVE</td>\n",
       "      <td>HITTER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>HITTER FAMILY FOUNDATION</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>EMILY</td>\n",
       "      <td>PAXHIA</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>POSEIDON ASSET MANAGEMENT</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>DAN</td>\n",
       "      <td>JORAANSTAD</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NONE</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>DAN</td>\n",
       "      <td>GOESE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NONE</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>KATHRYN</td>\n",
       "      <td>CHAMBERS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>INYO COUNTY</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>MICHELLE</td>\n",
       "      <td>WOLFF</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>MICHELLE WOLFF</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>MICHELLE</td>\n",
       "      <td>SEXTON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CENTER FOR THE STUDY OF CANNABIS AND SOCIAL PO...</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>GRETCHEN</td>\n",
       "      <td>BERGMAN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>A NEW PATH</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>GREG</td>\n",
       "      <td>SMITH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>GREG SMITH</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>WENDY</td>\n",
       "      <td>COLTON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>WENDY COLTON</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>ETHAN</td>\n",
       "      <td>BROOKES</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>LONZA BIOSCIENCE</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>ROGER</td>\n",
       "      <td>TOWER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>RIVERINE, INC.</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>DAVID</td>\n",
       "      <td>REAGAN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>LAW OFFICES OF DAVID REAGAN</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>CHRISTINE A.</td>\n",
       "      <td>PORTER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>APPLE, INC.</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>LEONARD</td>\n",
       "      <td>KAUFMANN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>COASTAL PIPCO</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>DANIEL</td>\n",
       "      <td>DODSON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DANIEL DODSON, INTERNET CONSULTANT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>DANA</td>\n",
       "      <td>HIRSCH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DANA HIRSCH</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>SUSAN</td>\n",
       "      <td>PODOLSKY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>SUSAN PODOLSKY</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>SKIP</td>\n",
       "      <td>ROACHE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>SKIP ROACHE</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>PETER</td>\n",
       "      <td>KIRSCH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NONE</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>LJUBOMIR</td>\n",
       "      <td>BUTUROVIC</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CLINICAL PERSONA INC.</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>JOSH</td>\n",
       "      <td>KLEYMEYER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>JOSH KLEYMEYER</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>BRIAN</td>\n",
       "      <td>MITCHELL</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>DIRECTV</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>WAYNE</td>\n",
       "      <td>SCHERER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>WAYNE SCHERER</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>ROBERT</td>\n",
       "      <td>LOCKART</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>CALIFORNIA STATE UNIVERSITY, NORTHRIDGE</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>SUE ANN</td>\n",
       "      <td>LORIG</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NONE</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>MARK</td>\n",
       "      <td>SLABAUGH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>ORBIT TOOL WORKS</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>MARC</td>\n",
       "      <td>STEIGLEDER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NONE</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>RICH</td>\n",
       "      <td>GOLDBERG</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>NONE</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>DAVID</td>\n",
       "      <td>WOOD</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>BORDEN LADNER GERVAIS</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>AMIRGHASEM</td>\n",
       "      <td>SAMIMI-ARDESTAN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>MEDIGREEN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>STEPHANIE</td>\n",
       "      <td>WARREN-SAMARIPA</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>STEPHANIE WARREN SAMARIPA</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>507 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    contributor_firstname contributor_lastname committee_position  \\\n",
       "446                  SEAN               PARKER            SUPPORT   \n",
       "98                 DANIEL                LEWIS            SUPPORT   \n",
       "368              NICHOLAS             PRITZKER            SUPPORT   \n",
       "369              NICHOLAS             PRITZKER            SUPPORT   \n",
       "383                 PETER                THIEL            SUPPORT   \n",
       "445                  SEAN               PARKER            SUPPORT   \n",
       "419                 ROGER              JENKINS            SUPPORT   \n",
       "23                 ANGELA               HOWARD            SUPPORT   \n",
       "291              LAWRENCE                 HESS            SUPPORT   \n",
       "506           ZACHARY PYM             WILLIAMS            SUPPORT   \n",
       "423              ROGER B.              MCNAMEE            SUPPORT   \n",
       "194                 JASON                 POST            SUPPORT   \n",
       "403                ROBERT                ADAMS             OPPOSE   \n",
       "210                JEREMY              ZACHARY            SUPPORT   \n",
       "289                LAURIE             BENENSON            SUPPORT   \n",
       "330            MARY QUINN              DELANEY            SUPPORT   \n",
       "343               MICHAEL                 DEAN             OPPOSE   \n",
       "59                CAMILLA                FIELD            SUPPORT   \n",
       "450             SHARON K.             CHRISTIE            SUPPORT   \n",
       "271              KHURSHID                KHOJA            SUPPORT   \n",
       "248                  JULI             CROCKETT            SUPPORT   \n",
       "467                STEVEN               PERSKY            SUPPORT   \n",
       "448                 SHARI                 FOOS            SUPPORT   \n",
       "134                  DOUG             LANPHERE            SUPPORT   \n",
       "70                CHARLES                ROVEN            SUPPORT   \n",
       "346               MICHAEL                KLEIN            SUPPORT   \n",
       "376               PATRICK            MCMANAMON            SUPPORT   \n",
       "350               MICHAEL            STEINMETZ            SUPPORT   \n",
       "463                 STEVE               HITTER            SUPPORT   \n",
       "145                 EMILY               PAXHIA            SUPPORT   \n",
       "..                    ...                  ...                ...   \n",
       "93                    DAN           JORAANSTAD            SUPPORT   \n",
       "92                    DAN                GOESE            SUPPORT   \n",
       "257               KATHRYN             CHAMBERS            SUPPORT   \n",
       "355              MICHELLE                WOLFF            SUPPORT   \n",
       "353              MICHELLE               SEXTON            SUPPORT   \n",
       "171              GRETCHEN              BERGMAN            SUPPORT   \n",
       "169                  GREG                SMITH            SUPPORT   \n",
       "495                 WENDY               COLTON            SUPPORT   \n",
       "154                 ETHAN              BROOKES            SUPPORT   \n",
       "422                 ROGER                TOWER            SUPPORT   \n",
       "116                 DAVID               REAGAN            SUPPORT   \n",
       "78           CHRISTINE A.               PORTER            SUPPORT   \n",
       "295               LEONARD             KAUFMANN            SUPPORT   \n",
       "96                 DANIEL               DODSON            SUPPORT   \n",
       "95                   DANA               HIRSCH            SUPPORT   \n",
       "475                 SUSAN             PODOLSKY            SUPPORT   \n",
       "454                  SKIP               ROACHE            SUPPORT   \n",
       "380                 PETER               KIRSCH            SUPPORT   \n",
       "304              LJUBOMIR            BUTUROVIC            SUPPORT   \n",
       "243                  JOSH            KLEYMEYER            SUPPORT   \n",
       "47                  BRIAN             MITCHELL            SUPPORT   \n",
       "494                 WAYNE              SCHERER            SUPPORT   \n",
       "410                ROBERT              LOCKART            SUPPORT   \n",
       "472               SUE ANN                LORIG            SUPPORT   \n",
       "325                  MARK             SLABAUGH            SUPPORT   \n",
       "316                  MARC           STEIGLEDER            SUPPORT   \n",
       "393                  RICH             GOLDBERG            SUPPORT   \n",
       "123                 DAVID                 WOOD            SUPPORT   \n",
       "16             AMIRGHASEM      SAMIMI-ARDESTAN            SUPPORT   \n",
       "458             STEPHANIE      WARREN-SAMARIPA            SUPPORT   \n",
       "\n",
       "                                  contributor_employer     amount  \n",
       "446                             SEAN PARKER FOUNDATION  1250000.0  \n",
       "98                                             RETIRED   500000.0  \n",
       "368                           TAO CAPITAL PARTNERS LLC   450000.0  \n",
       "369                          TAO CAPITAL PARTNERS, LLC   450000.0  \n",
       "383                                 THIEL CAPITAL, LLC   300000.0  \n",
       "445                           SEAN N PARKER FOUNDATION   250000.0  \n",
       "419                                               NONE    75000.0  \n",
       "23                                            DESIGNER    65000.0  \n",
       "291                               LEHBROS LIMITED, LLC    30000.0  \n",
       "506                                CONDE NAST TRAVELER    10000.0  \n",
       "423                                 ELEVATION PARTNERS    10000.0  \n",
       "194                              POST INVESTMENT GROUP    10000.0  \n",
       "403                                                 CS     6500.0  \n",
       "210                                   CULTURE MAGAZINE     5000.0  \n",
       "289                                    LAURIE BENENSON     5000.0  \n",
       "330                                 AKONADI FOUNDATION     5000.0  \n",
       "343                                                CSI     5000.0  \n",
       "59                                       CAMILLA FIELD     5000.0  \n",
       "450                                        AROMAFLORIA     5000.0  \n",
       "271                                      KHURSID KHOJA     3300.0  \n",
       "248                                            W VAPES     3000.0  \n",
       "467                        PERSKY FINANCIAL MANAGEMENT     2500.0  \n",
       "448                               THE NARRATIVE METHOD     2500.0  \n",
       "134                            GREEN OREGON ENTERPRISE     2500.0  \n",
       "70                                       CHARLES ROVEN     2500.0  \n",
       "346                                        BIO365, LLC     2500.0  \n",
       "376                  CANNASURE INSURANCE SERVICES, LLC     2500.0  \n",
       "350                                          FLOW KANA     2500.0  \n",
       "463                           HITTER FAMILY FOUNDATION     2500.0  \n",
       "145                          POSEIDON ASSET MANAGEMENT     2500.0  \n",
       "..                                                 ...        ...  \n",
       "93                                                NONE      100.0  \n",
       "92                                                NONE      100.0  \n",
       "257                                        INYO COUNTY      100.0  \n",
       "355                                     MICHELLE WOLFF       84.0  \n",
       "353  CENTER FOR THE STUDY OF CANNABIS AND SOCIAL PO...       84.0  \n",
       "171                                         A NEW PATH       84.0  \n",
       "169                                         GREG SMITH       75.0  \n",
       "495                                       WENDY COLTON       50.0  \n",
       "154                                   LONZA BIOSCIENCE       50.0  \n",
       "422                                     RIVERINE, INC.       50.0  \n",
       "116                        LAW OFFICES OF DAVID REAGAN       50.0  \n",
       "78                                         APPLE, INC.       50.0  \n",
       "295                                      COASTAL PIPCO       50.0  \n",
       "96                  DANIEL DODSON, INTERNET CONSULTANT       50.0  \n",
       "95                                         DANA HIRSCH       50.0  \n",
       "475                                     SUSAN PODOLSKY       50.0  \n",
       "454                                        SKIP ROACHE       50.0  \n",
       "380                                               NONE       50.0  \n",
       "304                              CLINICAL PERSONA INC.       50.0  \n",
       "243                                     JOSH KLEYMEYER       42.0  \n",
       "47                                             DIRECTV       35.0  \n",
       "494                                      WAYNE SCHERER       30.0  \n",
       "410            CALIFORNIA STATE UNIVERSITY, NORTHRIDGE       25.0  \n",
       "472                                               NONE       25.0  \n",
       "325                                   ORBIT TOOL WORKS       25.0  \n",
       "316                                               NONE       25.0  \n",
       "393                                               NONE       25.0  \n",
       "123                              BORDEN LADNER GERVAIS        0.0  \n",
       "16                                           MEDIGREEN        0.0  \n",
       "458                          STEPHANIE WARREN SAMARIPA        0.0  \n",
       "\n",
       "[507 rows x 5 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.groupby([\"contributor_firstname\", \"contributor_lastname\", \"committee_position\", \"contributor_employer\"]).amount.sum().reset_index().sort_values(\"amount\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "CA = merged[merged.contributor_state == \"CA\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CA    693\n",
       "CO     25\n",
       "NY     18\n",
       "DC     12\n",
       "PA     12\n",
       "WA     10\n",
       "VA     10\n",
       "FL     10\n",
       "IL     10\n",
       "DE      9\n",
       "MO      6\n",
       "NV      6\n",
       "AZ      5\n",
       "MA      4\n",
       "TX      4\n",
       "OR      4\n",
       "OH      4\n",
       "MD      3\n",
       "MI      2\n",
       "OK      2\n",
       "BC      2\n",
       "AB      2\n",
       "RI      1\n",
       "AL      1\n",
       "GA      1\n",
       "NC      1\n",
       "LA      1\n",
       "ID      1\n",
       "CT      1\n",
       "Name: contributor_state, dtype: int64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.contributor_state.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.49723353977884294"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "CA.amount.sum()/merged.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "top_supporters = support.groupby(\n",
    "    [\"contributor_firstname\", \"contributor_lastname\"]\n",
    ").amount.sum().reset_index().sort_values(\"amount\", ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>contributor_firstname</th>\n",
       "      <th>contributor_lastname</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>SEAN</td>\n",
       "      <td>PARKER AND AFFILIATED ENTITIES</td>\n",
       "      <td>7250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>SEAN</td>\n",
       "      <td>PARKER</td>\n",
       "      <td>1500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>DANIEL</td>\n",
       "      <td>LEWIS</td>\n",
       "      <td>1250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>HENRY</td>\n",
       "      <td>VAN AMERINGEN</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>NICHOLAS</td>\n",
       "      <td>PRITZKER</td>\n",
       "      <td>900000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>PETER</td>\n",
       "      <td>THIEL</td>\n",
       "      <td>300000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>ROGER</td>\n",
       "      <td>JENKINS</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ANGELA</td>\n",
       "      <td>HOWARD</td>\n",
       "      <td>65000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>LAWRENCE</td>\n",
       "      <td>HESS</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>ROGER B.</td>\n",
       "      <td>MCNAMEE</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    contributor_firstname            contributor_lastname     amount\n",
       "444                  SEAN  PARKER AND AFFILIATED ENTITIES  7250000.0\n",
       "443                  SEAN                          PARKER  1500000.0\n",
       "102                DANIEL                           LEWIS  1250000.0\n",
       "180                 HENRY                   VAN AMERINGEN  1000000.0\n",
       "374              NICHOLAS                        PRITZKER   900000.0\n",
       "390                 PETER                           THIEL   300000.0\n",
       "421                 ROGER                         JENKINS    75000.0\n",
       "22                 ANGELA                          HOWARD    65000.0\n",
       "297              LAWRENCE                            HESS    30000.0\n",
       "425              ROGER B.                         MCNAMEE    10000.0"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_supporters.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x111aeabd0>"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZMAAAEFCAYAAAAmIwo/AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGv1JREFUeJzt3X+0XXV95vH3AwFkRCDIbcokwTCa0VI7ImRCbLusQg0J\nOoaZqoXOMlmIpGsA0Y5LjWNdGaW6Ytslmg6ijKQkjiVS/EFUQpqJWFdnJpDLD0FAmytCSRaBmAQi\n0oLoM3/s74XD9d7cH9/cfU7M81rrrLvPZ+9zvp/knJzn7r2/+0S2iYiIqHFItxuIiIgDX8IkIiKq\nJUwiIqJawiQiIqolTCIiolrCJCIiqiVMIiKiWsIkIiKqJUwiIqLalG430Jbjjz/es2bN6nYbEREH\nlNtuu+3HtvtG2+6gCZNZs2bR39/f7TYiIg4okh4cy3Y5zBUREdUSJhERUS1hEhER1RImERFRLWES\nERHVEiYREVEtYRIREdUSJhERUS1hEhER1Q6aK+BHM2vZN6uf44EVb9wPnUREHHiyZxIREdUSJhER\nUW3UMJH0ckl3dtz2SnqPpOMkbZS0tfycWraXpJWSBiTdJenUjudaUrbfKmlJR/00SXeXx6yUpFIf\n9xgREdG+UcPE9g9sn2L7FOA04Engq8AyYJPt2cCmch9gITC73JYCV0ITDMBy4HRgLrB8MBzKNhd2\nPG5BqY9rjIiI6I7xHuY6E/ih7QeBRcDqUl8NnFOWFwFr3NgMHCvpBOAsYKPt3bb3ABuBBWXd0bY3\n2zawZshzjWeMiIjogvGGybnAtWV5mu2Hy/IOYFpZng481PGYbaW2r/q2YeoTGSMiIrpgzGEi6XDg\nzcDfDl1X9ii8H/v6JRMZQ9JSSf2S+nfu3DlJnUVExHj2TBYCt9t+pNx/ZPDQUvn5aKlvB2Z2PG5G\nqe2rPmOY+kTGeB7bV9meY3tOX9+o/+tkRERM0HjC5DyeO8QFsA4YnJG1BLiho764zLiaBzxeDlVt\nAOZLmlpOvM8HNpR1eyXNK7O4Fg95rvGMERERXTCmK+AlvRB4A/DHHeUVwHWSLgAeBN5W6jcCZwMD\nNDO/zgewvVvSZcCWst1Hbe8uyxcB1wBHAuvLbdxjREREd4wpTGz/FHjxkNoumtldQ7c1cPEIz7MK\nWDVMvR945TD1cY8RERHtyxXwERFRLWESERHVEiYREVEtYRIREdUSJhERUS1hEhER1RImERFRLWES\nERHVEiYREVEtYRIREdUSJhERUS1hEhER1RImERFRLWESERHVEiYREVEtYRIREdUSJhERUS1hEhER\n1RImERFRLWESERHVxhQmko6VdL2k70u6T9JrJB0naaOkreXn1LKtJK2UNCDpLkmndjzPkrL9VklL\nOuqnSbq7PGalJJX6uMeIiIj2jXXP5NPATbZfAbwKuA9YBmyyPRvYVO4DLARml9tS4EpoggFYDpwO\nzAWWD4ZD2ebCjsctKPVxjREREd0xaphIOgZ4LXA1gO2nbT8GLAJWl81WA+eU5UXAGjc2A8dKOgE4\nC9hoe7ftPcBGYEFZd7TtzbYNrBnyXOMZIyIiumAseyYnATuBv5Z0h6TPS3ohMM32w2WbHcC0sjwd\neKjj8dtKbV/1bcPUmcAYzyNpqaR+Sf07d+4cwx81IiImYixhMgU4FbjS9quBn/Lc4SYAyh6F9397\ndWPYvsr2HNtz+vr6JqmziIgYS5hsA7bZvqXcv54mXB4ZPLRUfj5a1m8HZnY8fkap7as+Y5g6Exgj\nIiK6YNQwsb0DeEjSy0vpTOBeYB0wOCNrCXBDWV4HLC4zruYBj5dDVRuA+ZKmlhPv84ENZd1eSfPK\nLK7FQ55rPGNEREQXTBnjdu8CvijpcOB+4HyaILpO0gXAg8DbyrY3AmcDA8CTZVts75Z0GbClbPdR\n27vL8kXANcCRwPpyA1gxnjEiIqI7xhQmtu8E5gyz6sxhtjVw8QjPswpYNUy9H3jlMPVd4x0jIiLa\nlyvgIyKiWsIkIiKqJUwiIqJawiQiIqolTCIiolrCJCIiqiVMIiKiWsIkIiKqJUwiIqJawiQiIqol\nTCIiolrCJCIiqiVMIiKiWsIkIiKqJUwiIqJawiQiIqolTCIiolrCJCIiqiVMIiKi2pjCRNIDku6W\ndKek/lI7TtJGSVvLz6mlLkkrJQ1IukvSqR3Ps6Rsv1XSko76aeX5B8pjNdExIiKifePZM3m97VNs\nzyn3lwGbbM8GNpX7AAuB2eW2FLgSmmAAlgOnA3OB5YPhULa5sONxCyYyRkREdEfNYa5FwOqyvBo4\np6O+xo3NwLGSTgDOAjba3m17D7ARWFDWHW17s20Da4Y813jGiIiILhhrmBj4O0m3SVpaatNsP1yW\ndwDTyvJ04KGOx24rtX3Vtw1Tn8gYERHRBVPGuN3v2t4u6deAjZK+37nStiV5/7dXN0YJvqUAJ554\n4qT0FRERY9wzsb29/HwU+CrNOY9HBg8tlZ+Pls23AzM7Hj6j1PZVnzFMnQmMMbTvq2zPsT2nr69v\nLH/UiIiYgFHDRNILJb1ocBmYD3wPWAcMzshaAtxQltcBi8uMq3nA4+VQ1QZgvqSp5cT7fGBDWbdX\n0rwyi2vxkOcazxgREdEFYznMNQ34apmtOwX4G9s3SdoCXCfpAuBB4G1l+xuBs4EB4EngfADbuyVd\nBmwp233U9u6yfBFwDXAksL7cAFaMZ4yIiOiOUcPE9v3Aq4ap7wLOHKZu4OIRnmsVsGqYej/wyv0x\nRkREtC9XwEdERLWESUREVEuYREREtYRJRERUS5hERES1hElERFRLmERERLWESUREVEuYREREtYRJ\nRERUS5hERES1hElERFRLmERERLWESUREVEuYREREtYRJRERUS5hERES1hElERFRLmERERLWESURE\nVBtzmEg6VNIdkr5R7p8k6RZJA5K+JOnwUj+i3B8o62d1PMcHS/0Hks7qqC8otQFJyzrq4x4jIiLa\nN549k3cD93Xc/wRwue2XAXuAC0r9AmBPqV9etkPSycC5wG8CC4DPlIA6FLgCWAicDJxXth33GBER\n0R1jChNJM4A3Ap8v9wWcAVxfNlkNnFOWF5X7lPVnlu0XAWttP2X7R8AAMLfcBmzfb/tpYC2waIJj\nREREF4x1z+RTwPuBX5T7LwYes/1Mub8NmF6WpwMPAZT1j5ftn60PecxI9YmM8TySlkrql9S/c+fO\nMf5RIyJivEYNE0lvAh61fVsL/exXtq+yPcf2nL6+vm63ExHxK2vKGLb5HeDNks4GXgAcDXwaOFbS\nlLJnMAPYXrbfDswEtkmaAhwD7OqoD+p8zHD1XRMYIyIiumDUPRPbH7Q9w/YsmhPo37L9n4GbgbeU\nzZYAN5TldeU+Zf23bLvUzy0zsU4CZgO3AluA2WXm1uFljHXlMeMdIyIiumAseyYj+QCwVtKfAXcA\nV5f61cAXJA0Au2nCAdv3SLoOuBd4BrjY9s8BJF0CbAAOBVbZvmciY0RERHfoYPmFfs6cOe7v7x9x\n/axl36we44EVb6x+joiIXiLpNttzRtsuV8BHRES1hElERFRLmERERLWESUREVEuYREREtYRJRERU\nS5hERES1hElERFRLmERERLWESUREVEuYREREtYRJRERUS5hERES1hElERFRLmERERLWESUREVEuY\nREREtYRJRERUS5hERES1UcNE0gsk3Srpu5LukfSRUj9J0i2SBiR9SdLhpX5EuT9Q1s/qeK4PlvoP\nJJ3VUV9QagOSlnXUxz1GRES0byx7Jk8BZ9h+FXAKsEDSPOATwOW2XwbsAS4o218A7Cn1y8t2SDoZ\nOBf4TWAB8BlJh0o6FLgCWAicDJxXtmW8Y0RERHeMGiZuPFHuHlZuBs4Ari/11cA5ZXlRuU9Zf6Yk\nlfpa20/Z/hEwAMwttwHb99t+GlgLLCqPGe8YERHRBWM6Z1L2IO4EHgU2Aj8EHrP9TNlkGzC9LE8H\nHgIo6x8HXtxZH/KYkeovnsAYERHRBWMKE9s/t30KMINmT+IVk9rVfiJpqaR+Sf07d+7sdjsREb+y\nxjWby/ZjwM3Aa4BjJU0pq2YA28vydmAmQFl/DLCrsz7kMSPVd01gjKH9XmV7ju05fX194/mjRkTE\nOIxlNlefpGPL8pHAG4D7aELlLWWzJcANZXlduU9Z/y3bLvVzy0ysk4DZwK3AFmB2mbl1OM1J+nXl\nMeMdIyIiumDK6JtwArC6zLo6BLjO9jck3QuslfRnwB3A1WX7q4EvSBoAdtOEA7bvkXQdcC/wDHCx\n7Z8DSLoE2AAcCqyyfU95rg+MZ4yIiOiOUcPE9l3Aq4ep309z/mRo/V+At47wXB8DPjZM/Ubgxv0x\nRkREtC9XwEdERLWESUREVEuYREREtYRJRERUS5hERES1hElERFRLmERERLWESUREVEuYREREtYRJ\nRERUS5hERES1hElERFRLmERERLWESUREVEuYREREtYRJRERUS5hERES1hElERFRLmERERLWESURE\nVBs1TCTNlHSzpHsl3SPp3aV+nKSNkraWn1NLXZJWShqQdJekUzuea0nZfqukJR310yTdXR6zUpIm\nOkZERLRvLHsmzwDvtX0yMA+4WNLJwDJgk+3ZwKZyH2AhMLvclgJXQhMMwHLgdGAusHwwHMo2F3Y8\nbkGpj2uMiIjojlHDxPbDtm8vyz8B7gOmA4uA1WWz1cA5ZXkRsMaNzcCxkk4AzgI22t5tew+wEVhQ\n1h1te7NtA2uGPNd4xoiIiC4Y1zkTSbOAVwO3ANNsP1xW7QCmleXpwEMdD9tWavuqbxumzgTGiIiI\nLhhzmEg6Cvgy8B7bezvXlT0K7+fenmciY0haKqlfUv/OnTsnqbOIiBhTmEg6jCZIvmj7K6X8yOCh\npfLz0VLfDszsePiMUttXfcYw9YmM8Ty2r7I9x/acvr6+sfxRIyJiAsYym0vA1cB9tj/ZsWodMDgj\nawlwQ0d9cZlxNQ94vByq2gDMlzS1nHifD2wo6/ZKmlfGWjzkucYzRkREdMGUMWzzO8Dbgbsl3Vlq\n/w1YAVwn6QLgQeBtZd2NwNnAAPAkcD6A7d2SLgO2lO0+ant3Wb4IuAY4Elhfbox3jIiI6I5Rw8T2\nPwAaYfWZw2xv4OIRnmsVsGqYej/wymHqu8Y7RkREtC9XwEdERLWESUREVEuYREREtYRJRERUS5hE\nRES1hElERFRLmERERLWESUREVEuYREREtbF8nUq0aNayb1Y/xwMr3rgfOomIGLvsmURERLWESURE\nVEuYREREtYRJRERUS5hERES1hElERFTL1OD4JZmeHBHjlT2TiIioljCJiIhqCZOIiKg2aphIWiXp\nUUnf66gdJ2mjpK3l59RSl6SVkgYk3SXp1I7HLCnbb5W0pKN+mqS7y2NWStJEx4iIiO4Yy57JNcCC\nIbVlwCbbs4FN5T7AQmB2uS0FroQmGIDlwOnAXGD5YDiUbS7seNyCiYwRERHdM2qY2P4OsHtIeRGw\nuiyvBs7pqK9xYzNwrKQTgLOAjbZ3294DbAQWlHVH295s28CaIc81njEiIqJLJjo1eJrth8vyDmBa\nWZ4OPNSx3bZS21d92zD1iYzxMENIWkqz98KJJ544xj9a9IpMUY44cFSfgC97FN4Pvez3MWxfZXuO\n7Tl9fX2T0FlERMDEw+SRwUNL5eejpb4dmNmx3YxS21d9xjD1iYwRERFdMtHDXOuAJcCK8vOGjvol\nktbSnGx/3PbDkjYAH+846T4f+KDt3ZL2SpoH3AIsBv5qImNM8M8RsU851BYxNqOGiaRrgdcBx0va\nRjMrawVwnaQLgAeBt5XNbwTOBgaAJ4HzAUpoXAZsKdt91PbgSf2LaGaMHQmsLzfGO0ZERHTPqGFi\n+7wRVp05zLYGLh7heVYBq4ap9wOvHKa+a7xjREREd+QK+IiIqJYwiYiIagmTiIioljCJiIhqCZOI\niKiWMImIiGoJk4iIqJYwiYiIagmTiIioljCJiIhqCZOIiKiWMImIiGoJk4iIqJYwiYiIahP9z7Ei\nokX5T7qi12XPJCIiqiVMIiKiWsIkIiKqJUwiIqLaARsmkhZI+oGkAUnLut1PRMTB7IAME0mHAlcA\nC4GTgfMkndzdriIiDl4H6tTgucCA7fsBJK0FFgH3drWriF9hvTI9uVf6iOc7UMNkOvBQx/1twOld\n6iUiDjK9Emi90geAbO+XJ2qTpLcAC2y/s9x/O3C67UuGbLcUWFruvhz4QeXQxwM/rnyOWr3QA/RG\nH73QA/RGH73QA/RGH73QA/RGH/ujh5fY7httowN1z2Q7MLPj/oxSex7bVwFX7a9BJfXbnrO/nu9A\n7aFX+uiFHnqlj17ooVf66IUeeqWPNns4IE/AA1uA2ZJOknQ4cC6wrss9RUQctA7IPRPbz0i6BNgA\nHAqssn1Pl9uKiDhoHZBhAmD7RuDGlofdb4fMKvRCD9AbffRCD9AbffRCD9AbffRCD9AbfbTWwwF5\nAj4iInrLgXrOJCIiekjCJCIiqiVMIiKiWsJkjCSd2u0eovdIenMXx54m6dRym9atPoaSdFS3e2iT\npH/X7R5GIum4tsY6YGdzTaZhgkPADZL+A82khdtb6uMVwOXAL4BLgQ8D5wD/CCyxfV8bffSS8qE5\nvdzdbvuRFsf+T0NLwBWSpgDY/kpLfZwCfBY4hucu1p0h6THgorben/twL3BiGwNJOhr4IM2Fy+tt\n/03Hus/YvqiFNu6QdD+wFrjWdle+I1DSn9r+s7J8MvA14DBJAv7Q9i2TOn5mc/0ySb8ANgNPdZTn\nlZptn9FSH98B/gI4ClgBfAD4EvAm4D22z2ypj98C/ifNh/h64AO295R1t9qe20IPw36AAq19gEr6\nGc21TY/SBAnAW4Drad4X75jsHkofdwJ/PPTDQdI84HO2X9VCD/91pFXAh2y38huxpC8DW2n+bb4D\n+BnwR7afknS77Uk/oiDpDuDtwHnAHwI/Ba4F1tp+YLLH7+jj2T+vpG8C/8P2eklzgU/Z/u3JHD+H\nuYb3Vpo35Z/bfr3t1wM7ynIrQVK8yPbXbV8L/Mz2Wje+DkxtsY8rgf8O/BbNXtE/SHppWXdYSz1c\nA7zb9m/Y/v1yewXwHuCvW+rht4EjgS22z7d9PvDjstxKkBQvHO63TNubgRe21MPHad6DLxpyO4p2\nP1deanuZ7a/ZfjNwO/AtSS9usQfb/p7tD9l+GXAh8Gs0/07+b4t9dPrXtteX5m6led9OqhzmGobt\nL0vaAFwm6R3Ae4Fu7MId2rH8ySHrDm+xjxfZvqks/6Wk24CbyhdstvX3MuIHqKRWPkBtb5H0BuBd\nkm6m2VPsxvtiffnNcw3PfXv2TGAxcNOIj9q/bge+Zvu2oSskvbOlHgCOkHSI7V8A2P6YpO3Ad2iC\nrQ3qvFM+vG+V9F7gtS31APBvJK0r/cyQ9K9sP1nWTfovfQmTEdh+AvgTSa8GVtP81tW2KyQdZfsJ\n258ZLEp6GfC/22xE0jG2HwewfbOkPwC+DLR1gq8XPkApH1qflvS3wKfaGndID5dKWkjzf/g8e/4I\nuKJ8M0Qbzgd2j7CuzS83/DpwBh3/HmxfI2kH8Fct9fAXwxXdnEP4+5Z6gOb90OkQePY845WTPXjO\nmYxBOYH1Itt7u91LN0j6I+D+chils34i8GHbF7bUx9nAm3n+B+i6Fj9AoweViSrTgVvKL4GD9YWD\nh3pi8iVMxkjSP9r+t+nj4CXpK8BXaA7vPDHa9pPYxyHAEuAPaPbOfk5zLuuztr/dUg+HAu+kmQRx\nk+3/07Hu2VlFLfTxLuAS4D7gFJrzajeUdW2dgD8KeD/N6zEDeBr4Ic3rcc1kj9/RR1dfk5yAH4ak\nn0jaW24/kfQT4KWD9YOwj2MkrZD0fUm7Je2SdF+pHdtSD/9e0s2S/pekmZI2SnpM0pZyKLINp9NM\nzf4nSddJ+o/lv0Bo29XAS2hm+N0MfKPU/rR8uLbhc8DvAbuAlZI6z+kNnUI9mZYCp9k+B3gd8GFJ\n7y7rNOKj9q8vAvcDZwEfAVbSzO56vaSPt9QDdPs1sZ3bkBvNm2ENMK2j9qODuI8NNCebf72j9uul\n9nct9XArsJBm+uVDwFtK/Uzg/7XUwx3l59E0HxY3AjtpZpPNb/H1uGvI/c3l5xHAfW33QHPu9Sqa\nvbYjBv+eWurjniH3j6I5h/ZJ4M6WevjukPtbys9DgO93433RjdckeybDsH0p8GngWkmXlsMKrR8P\n7JU+gFm2P2F7R0dvO2x/guY35DYcZnu9m2nStn196WMT8IKWenAZc6/tL9g+G3gFcAuwrKUeAH42\nODW7XGD7dOnrKdp7fzy7R2b7GdtLge8C36K9WVQAj5RrkAZ7eYLmOqzjaaayt+Gnkn4Xnv1GhN2l\nl1/Q3t4RdPk1SZiMwM2Ux98vd/+e9j6werGPByW9Xx1f2aHmqzw+wHMzqybbv0iaL+mtgCWdU/r4\nPZpzBm34pfMktnfZ/qzbvf7ofcDNkrbSzKh7H4CkPppDXm3ol7Sgs2D7IzR7abNa6gGa2Xw7Ogvl\ng3Qx7U3L/S/AJyXtoTl3cik8+3pc0VIP0OXXJCfgx0DSCcD3bLd5IVTP9CFpKs1v3otoLsYCeITm\nv0pe4XI1/CT38Crgz2m+WuZPaP4BL6GZ0XWh7VYuDitXE9vNNScnAwtoDmW0OqNM0muAZ7rdx5Ce\n1pQP8YOOpN+gmVG22c+fUbbAz12j1Y2+WntNEibDKBf+DHUGze4ibq60PWj62BdJ59tu6wr0rvYg\naTnNeZspwEaaE/I3A28ANtj+2GT3MEIfc4Fvt9nHMO9NAa+nh96bbZF0KXAR8H26NKOsjNXV1yRh\nMgxJt9N8Wd3naY5Bi+a7ds4FsN3KhUi90se+SPon2618qV+3e5B0N82HxRE0h1Zm2N4r6Uiaaxxa\n+fbYXuhDzfdR3UMPvzfbUl6P19h+QtIsmu9q+4LtT0u6w3Yrsw27/ZrkCvjhzQHeDXwIeJ/tOyX9\ncxf+gfREH5LuGmkV0MpXn/dCDzSHlX4OPCnphy4Xsdr+ZzVfDtqWXujjNHrgvdkjDhk8tGX7AUmv\nA66X9BLaPQHf1dckYTKMMgvjcjVfmXG5pEfowt9Vr/RB82F9FjD03IiAtr7Irhd6eFrPfd/Rac82\nIB1Dcy6nLV3vo4fem73gEUmn2L4Tmhllkt4ErKK9GWVdf00O1hd/TGxvA94q6Y1A175KpQf6+AZw\n1OA/lk6Svn0Q9fDaMv128B/uoMNoJgO0pVf66IX3Zi9YDDzTWbD9DLBY0ufabqZbr0nOmURERLVc\nZxIREdUSJhERUS1hEhER1RImERFRLWESERHV/j8Ebkt+hzq/YAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x11042e250>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "top_supporters.amount.plot.bar()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1110c2ad0>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAFURJREFUeJzt3X20XXV95/H3xwBRBAIaqpmE8eJMWhc1CpihUHygdKo8\nLegsaSdZVqnKZGrpDFRHDWOXLtt/fOhikE5Fs5RKVynWVlSGhyLDw0KnPPQGIgF5ijUuiGCmWoNO\nRivhO3+cfeF4vck9j7kne96vtc66+/z2b+/9vbknn/u7++yzf6kqJEnt9ZyFLkCSNF4GvSS1nEEv\nSS1n0EtSyxn0ktRyBr0ktZxBL0ktZ9BLUssZ9JLUcvstdAEAS5curampqYUuQ5L2KRs3bvzHqjp8\nvn4TEfRTU1NMT08vdBmStE9J8q1e+nnqRpJazqCXpJYz6CWp5Qx6SWq5iQj6zdt2LHQJktRaExH0\nkqTx6TnokyxKck+Sa5rnVyR5KMl9SS5Lsn/TflKSHUk2NY/3j6t4SdL8+hnRnw880PX8CuBlwCrg\necC5Xeu+UlVHN48/HL5MSdKgegr6JCuA04FPzbRV1XXVAO4CVoynREnSMHod0V8MvAd4evaK5pTN\nm4G/7Wo+IcnXklyf5Bfn2mGSdUmmk0zv2umbsZI0LvMGfZIzgO1VtXE3XT4O3FZVX2me3w28pKpe\nCfwJ8MW5NqqqDVW1uqpWLzpwyQClS5J60cuI/kTgzCRbgc8CJyf5C4AkHwAOB94507mqnqyqHzbL\n1wH7J1k66sIlSb2ZN+ir6sKqWlFVU8Aa4Oaq+q0k5wJvANZW1TOndJK8OEma5eOaY3x3LNVLkuY1\nzN0rPwF8C7i9yfWrmitszgbekeQp4P8Ca5o3bCVJCyCTkMGLl62sHz/+yEKXIUn7lCQbq2r1fP0m\n4pOxq5b7ZqwkjctEBL0kaXwMeklqOYNeklrOoJekljPoJanlDHpJajmDXpJazqCXpJYz6CWp5Qx6\nSWq5iQj6zdt2MLX+2oUuQ5JaqZeJR45IckuSrye5P8n5Tfsrk9yeZHOS/5HkkKb9TV0Tg29K8nSS\no8f9jUiS5tbLiP4p4F1VdRRwPHBekqPozB+7vqpWAV8A3g1QVVfMTAxOZ4rBb1bVpvGUL0maTy8T\njzxeVXc3yz8AHgCWAz8P3NZ0uxF44xybr6UzK5UkaYH0dY4+yRRwDHAncD9wVrPqN4Aj5tjk3wNX\nDl6eJGlYPQd9koOAzwMXVNWTwNuA302yETgY+OdZ/X8J2FlV9+1mf+uSTCeZ3rVzx8DfgCRpz3qa\nSjDJ/nRC/oqqugqgqh4EXt+s/3ng9FmbrWEPo/mq2gBsgM4MU31XLknqybxB30z0/Wnggaq6qKv9\n56pqe5LnAH9AZw7ZmXXPAX4TeM3oS5Yk9aOXUzcn0rl65uSuSyZPA9YmeRh4EPg28Gdd27wWeLSq\n/mHkFUuS+jLviL6qvgpkN6s/tpttbqVzKaYkaYFNxCdjVy1fwtYPzT7FL0kahYkIeknS+Bj0ktRy\nBr0ktZxBL0ktZ9BLUssZ9JLUcga9JLWcQS9JLWfQS1LLGfSS1HITEfQzk4M7Qbgkjd5EBL0kaXwG\nDvokRyS5JcnXk9yf5Pym/aNJHkxyb5IvJDl0dOVKkvo1zIj+KeBdVXUUnVsSn5fkKDoThb+8ql4B\nPAxcOHyZkqRBDRz0VfV4Vd3dLP8AeABYXlVfrqqnmm53ACuGL1OSNKiRnKNPMgUcA9w5a9XbgOtH\ncQxJ0mCGDvokB9GZOPyCqnqyq/19dE7vXLGb7dYlmU4yvWvnjmHLkCTtxlBBn2R/OiF/RVVd1dX+\n28AZwJuqqubatqo2VNXqqlq96MAlw5QhSdqDeeeM3Z0kAT4NPFBVF3W1nwK8B3hdVe0cvkRJ0jAG\nDnrgRODNwOYkm5q2/wpcAiwGbuz8LuCOqvqdoaqUJA1s4KCvqq8CmWPVdYOXI0katWFG9COzavkS\npj90+kKXIUmt5C0QJKnlDHpJajmDXpJazqCXpJYz6CWp5Qx6SWo5g16SWs6gl6SWM+glqeUMeklq\nuYm4BcLmbTuYWn/tM8+3ejsESRoZR/SS1HI9B32SRUnuSXJN8/yKJA8luS/JZc0kJCR5WZLbk/w4\nyX8ZV+GSpN70M6I/n84E4DOuAF4GrAKeB5zbtH8P+M/AH4+iQEnScHoK+iQrgNOBT820VdV11QDu\nAlY07dur6u+Bn4yhXklSn3od0V9MZ3rAp2evaE7ZvBn4234O7OTgkrR3zBv0Sc4AtlfVxt10+Thw\nW1V9pZ8DOzm4JO0dvVxeeSJwZpLTgOcChyT5i6r6rSQfAA4H/uM4i5QkDW7eEX1VXVhVK6pqClgD\n3NyE/LnAG4C1VfUzp3QkSZNhmA9MfQL4FnB7EoCrquoPk7wYmAYOAZ5OcgFwVFU9OXS1kqS+9RX0\nVXUrcGuzPOe2VfUEzRU4kqSFNxG3QFi1fAnT3vZAksbCWyBIUssZ9JLUcga9JLWcQS9JLWfQS1LL\nGfSS1HIGvSS1nEEvSS1n0EtSyxn0ktRyE3ELhM3bdjC1/tq+t9vqbRMkaV6O6CWp5XqZYeq5Se5K\n8rUk9yf5YNN+cpK7k9yX5PIk+zXtSXJJki1J7k1y7Li/CUnS7vUyov8xcHJVvRI4GjglyS8DlwNr\nqurldO5Lf07T/1RgZfNYB1w68qolST3rZYapqqofNk/3bx67gH+uqoeb9huBNzbLZwF/3mx3B3Bo\nkmUjrluS1KOeztEnWZRkE7CdTqjfBeyXZHXT5WzgiGZ5OfBo1+aPNW2z97kuyXSS6V07dwxavyRp\nHj0FfVXtqqqj6cwcdRzwi3Tmj/1vSe4CfkBnlN+zqtpQVauravWiA5f0WbYkqVd9XXVTVd8HbgFO\nqarbq+o1VXUccBswcxpnG8+O7qHzy2HbKIqVJPWvl6tuDk9yaLP8PODXgAeT/FzTthh4L53JwgGu\nBt7SXH1zPLCjqh4fS/WSpHn18oGpZcDlSRbR+cXwuaq6JslHk5zRtF1aVTc3/a8DTgO2ADuBt46h\nbklSj+YN+qq6FzhmjvZ3A++eo72A80ZSnSRpaBNxC4RVy5cw7e0MJGksvAWCJLWcQS9JLWfQS1LL\nGfSS1HIGvSS1nEEvSS1n0EtSyxn0ktRyBr0ktZxBL0ktNxG3QNi8bQdT669d6DJ2a6u3Z5C0Dxtm\ncvCvJNnUPL6d5Iuztvs3SZ5Kcva4ipckza+XEf3M5OA/TLI/8NUk11fVa2Y6JPk88KWu54uADwNf\nHnXBkqT+DDo5eM2sT3IIcDLQPaL/T8Dn6cwxK0laQANNDl5Vd3at/nXgpqp6sum7HPh3wKWjLlaS\n1L+BJgdP8vKu1WuBK7ueXwy8t6qe3tM+k6xLMp1ketfOHf3WLUnqUV9X3VTV95PcApwC3JdkKXAc\nnRH8jNXAZ5MALAVOS/JUVX1x1r42ABsAFi9bWUiSxmLeoE9yOPCTJuRnJgf/cLP6bOCaqvrRTP+q\nOrJr2880638q5CVJe8/Ak4M369YAHxpXcZKk4Q08OXiz7qR5tv3tgaqSJI3MRHwy1snBJWl8vNeN\nJLWcQS9JLWfQS1LLGfSS1HIGvSS1nEEvSS1n0EtSyxn0ktRyBr0ktZxBL0ktNxG3QJj0ycFnc7Jw\nSfsSR/SS1HK9TiV4WZLtSe7rajs6yR1JNjUzRR3XtCfJJUm2JLk3ybHjKl6SNL9eR/SfoTOrVLeP\nAB9sphh8f/Mc4FRgZfNYh3PHStKC6nXO2NuA781uBg5plpcA326WzwL+vDruAA5NsmwUxUqS+jfM\nm7EXADck+WM6vzB+uWlfDjza1e+xpu3xIY4lSRrQMG/GvgP4/ao6Avh94NP9bJxkXXNuf3rXzh1D\nlCFJ2pNhgv4c4Kpm+a+B45rlbcARXf1WNG0/pao2VNXqqlq96MAlQ5QhSdqTYYL+28DrmuWTgUea\n5auBtzRX3xwP7KgqT9tI0gLp6Rx9kiuBk4ClSR4DPgD8B+BjSfYDfkTnChuA64DTgC3ATuCtI65Z\nktSHnoK+qtbuZtWr5uhbwHnDFCVJGp2JuAXCquVLmPa2ApI0Ft4CQZJazqCXpJYz6CWp5Qx6SWo5\ng16SWs6gl6SWM+glqeUMeklqOYNeklrOoJeklpuIWyBs3raDqfXXLnQZY7HVWztIWmCO6CWp5eYN\n+iSXJdme5L6uthckuTHJI83Xw5r2NyW5N8nmJH+X5JXjLF6SNL9eRvSfAU6Z1bYeuKmqVgI3Nc8B\nvgm8rqpWAX8EbBhRnZKkAc0b9FV1G/C9Wc1nAZc3y5cDv970/buq+qem/Q460whKkhbQoOfoX9Q1\nPeATwIvm6PN24Prd7cDJwSVp7xj6qpuqqiTV3ZbkV+gE/av3sN0GmlM7i5etrN31kyQNZ9AR/XeS\nLANovm6fWZHkFcCngLOq6rvDlyhJGsagQX81cE6zfA7wJYAk/xK4CnhzVT08fHmSpGHNe+omyZXA\nScDSJI8BHwA+BHwuyduBbwG/2XR/P/BC4ONJAJ6qqtVjqFuS1KN5g76q1u5m1a/O0fdc4Nxhi5Ik\njc5E3AJh1fIlTHurAEkaC2+BIEktZ9BLUssZ9JLUcga9JLWcQS9JLWfQS1LLGfSS1HIGvSS1nEEv\nSS1n0EtSy03ELRA2b9vB1PprF7qMBbfV20BIGgNH9JLUcj0HfZJFSe5Jcs2s9kuS/LDr+e8k2Zxk\nU5KvJjlqlAVLkvrTz4j+fOCB7oYkq4HDZvX7y6paVVVHAx8BLhquREnSMHoK+iQrgNPpTBE407YI\n+Cjwnu6+VfVk19PnA84HK0kLqNc3Yy+mE+gHd7X9HnB1VT3ezCb1jCTnAe8EDgBOnmuHSdYB6wAW\nHXJ4f1VLkno274g+yRnA9qra2NX2L4DfAP5krm2q6k+r6l8B7wX+YDd9NlTV6qpavejAJQMVL0ma\nXy8j+hOBM5OcBjwXOAS4H/gxsKUZzR+YZEtV/etZ234WuHSE9UqS+jTviL6qLqyqFVU1BawBbq6q\nw6rqxVU11bTvnAn5JCu7Nj8deGQMdUuSejSOD0z9XpJ/C/wE+CfgnDEcQ5LUo76CvqpuBW6do/2g\nruXzh65KkjQyE3ELhFXLlzDtx/8laSy8BYIktZxBL0ktZ9BLUssZ9JLUcga9JLWcQS9JLWfQS1LL\nGfSS1HIGvSS13ER8MtbJwSX9/2jrXrojgCN6SWq5kU8O3tX+xiTVzCsrSVog45gcnCQHN/3vHKo6\nSdLQRj45eOOPgA8DPxpBjZKkIfQ6op+ZHPzprrZnJgfv7pjkWOCIqvLdVUmaACOdHDzJc4CLgHf1\nsN91SaaTTO/auaPvwiVJvRnp5ODAq4CXA7c27S8Grk5yZlVNd++0qjYAGwAWL1tZo/l2JEmzjXRy\n8KraUVVLu9rvAH4m5CVJe4/X0UtSy418cvBZ7ScNUpQkaXQm4hYITg4uSePjqRtJajmDXpJazqCX\npJYz6CWp5Qx6SWq5VC38h1KT/AB4aKHr6MNS4B8Xuog+WO94We94We/uvaSqDp+v00RcXgk8VFX7\nzH3rk0xb7/hY73hZ73hNYr2eupGkljPoJanlJiXoNyx0AX2y3vGy3vGy3vGauHon4s1YSdL4TMqI\nXpI0LlW1oA/gFDqXVm4B1o9h/5cB24H7utpeANwIPNJ8PaxpD3BJU8u9wLFd25zT9H8EOKer/VXA\n5mabS3j2r6S+j9GsPwK4Bfg6nQlezp/kmulMRnMX8LWm3g827UfSmRx+C/BXwAFN++Lm+ZZm/VTX\nvi5s2h8C3jDfa2SQY3Rtuwi4B7hm0usFtjY/r03A9CS/Hpr1hwJ/AzwIPACcMKn1Ar/Q/LvOPJ4E\nLpjUegfOwVEHa58hvAj4BvBS4AA6YXHUiI/xWuBYfjroP0LzHxBYD3y4WT4NuL75hz4euLPrB/IP\nzdfDmuWZH8pdTd802546yDG6als284MFDgYeBo6a1JqbtoOa5f3pBNXxwOeANU37J4B3NMu/C3yi\nWV4D/FWzfFTz819MJxC/0bw+dvsa6fcYs/6d3wn8Jc8G/cTWSyfol85qm8jXQ7P+cuDcZvkAOsE/\nsfXOyqMngJfsC/X2lYOjDNUBQvgE4Iau5xcCF47hOFP8dNA/BCxrlpfRuY4f4JPA2tn9gLXAJ7va\nP9m0LQMe7Gp/pl+/x9hD7V8Cfm1fqBk4ELgb+CU6HxjZb/bPGbgBOKFZ3q/pl9k/+5l+u3uNNNv0\ndYyufawAbgJOBq4ZZF97ud6t/GzQT+TrAVgCfLO7/kmud1aNrwf+175Sbz+PhT5Hvxx4tOv5Y03b\nuL2oqh5vlp8AXjRPPXtqf2yO9kGO8TOSTAHH0BklT2zNSRYl2UTnFNmNdEa036+qp+bo/8y+mvU7\ngBcO8H28cIBjzLgYeA/wdPN8kH3tzXoL+HKSjUnWNW2T+no4EvjfwJ8luSfJp5I8f4Lr7bYGuHLA\nfS1IRvRqoYN+wVXnV2ZN2jGSHAR8Hrigqp4cdn/96ucYVbWrqo6mM1I+DnjZOGsbRpIzgO1VtXGh\na+nDq6vqWOBU4Lwkr+1eOWGvh/3onCq9tKqOAf4PndMSg+xrYP0eI8kBwJnAXw+7r0GM+xgLHfTb\n6Lz5OGNF0zZu30myDKD5un2eevbUvmKO9kGO8Ywk+9MJ+Suq6qp9oWaAqvo+nTeSTwAOTbLfHP2f\n2Vezfgnw3QG+j+8OcAyAE4Ezk2wFPkvn9M3HJrheqmpb83U78AU6v0wn9fXwGPBYVd3ZPP8bOsE/\nqfXOOBW4u6q+M+C+9vr/t34sdND/PbAyyZHNb9Q1wNV74bhX03mHnObrl7ra35KO44EdzZ9WNwCv\nT3JYksPonMu7oVn3ZJLjkwR4y6x99XMMAJr9fBp4oKoumvSakxye5NBm+Xl03k94gE7gn72bfc0c\n42zg5mY0czWwJsniJEcCK+m8iTXna6TZpt9jUFUXVtWKqppq9nVzVb1pUutN8vwkB88s0/k53jfA\nz2qvvB6q6gng0SS/0PT9VTpXkE1kvV3W8uxpm0H2tbfr7c8wJ/hH8aDzDvPDdM7rvm8M+78SeBz4\nCZ3RxtvpnP+8ic5lTf8TeMHM/yvgT5taNgOru/bzNjqXO20B3trVvprOf7xvAP+dZy+d6vsYzfpX\n0/kT7l6eveTrtEmtGXgFncsU7232+f6m/aV0gm8LnT+HFzftz22eb2nWv7RrX+9rjvEQzZUJe3qN\nDHKMWf/WJ/HsVTcTWW+zzdd49vLV9w3xs9pbr+GjgenmNfFFOlehTHK9z6fzF9SSrraJrXeQh5+M\nlaSWW+hTN5KkMTPoJanlDHpJajmDXpJazqCXpJYz6CWp5Qx6SWo5g16SWu7/AYLu2EVTXTgMAAAA\nAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x111089cd0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "top_supporters.amount.plot.barh()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x10d89e850>"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAEBlJREFUeJzt3X2MXNV5x/Hvgw0mvBmDETg2zUJjpUJxyotLodCEkiYF\njCBVSWUrKjSFWk2hgqQSMaIiQvnHkAoR0oRgEQqVGggJFCwoIhSC0jQCug4vhhLANI6wMbghYSm1\nQLw8/eOexcOyy7zsjmc4+X6k0dw599xzn925+9uzd+7MRmYiSarXToMuQJLUXwa9JFXOoJekyhn0\nklQ5g16SKmfQS1LlDHpJqpxBL0mVM+glqXKzB10AwPz583NkZGTQZUjSe8q6det+kZn7tes3FEE/\nMjLC6OjooMuQpPeUiPh5J/08dSNJlTPoJalyBr0kVc6gl6TKGfSSVDmDXpIqZ9BLUuUMekmqnEEv\nSZUbinfGrt88xsiq2wddxpQ2rl426BIkqWfO6CWpcga9JFXOoJekyhn0klQ5g16SKmfQS1Ll2gZ9\nROwaEQ9ExMMR8VhEXFza/z0iHiq3ZyPilgnb/U5EvB4Rp/WreElSe51cR/8qcHxmvhwROwM/iog7\nMvP3xztExE3ArS2PZwGXAN+f6YIlSd1pO6PPxsvl4c7lluPrI2Iv4HigdUb/N8BNwNaZK1WS1IuO\nztFHxKyIeIgmuO/KzPtbVn8KuDszXyp9FwJ/DFw508VKkrrXUdBn5huZeSiwCDgyIj7csnoFcH3L\n48uBL2bmm+82ZkSsjIjRiBh9Y9tYt3VLkjrU1WfdZOaLEfED4ATg0YiYDxxJM4MftxS4ISIA5gMn\nRcTrmXnLhLHWAGsA5ixYnEiS+qJt0EfEfsBrJeTfB3yC5oVWgNOA2zLzlfH+mXlQy7bXlvVvC3lJ\n0o7TyYx+AXBduZJmJ+DGzLytrFsOrO5XcZKk6Wsb9Jn5CHDYFOuOa7Ptn/dUlSRpxvjOWEmqnEEv\nSZUz6CWpcga9JFXOoJekyhn0klS5rt4Z2y9LFs5ldPWyQZchSVVyRi9JlTPoJalyBr0kVc6gl6TK\nGfSSVDmDXpIqZ9BLUuUMekmqnEEvSZUz6CWpcga9JFXOoJekyhn0klQ5g16SKmfQS1LlDHpJqpxB\nL0mVM+glqXIGvSRVzqCXpMoZ9JJUudmDLgBg/eYxRlbdPugyOrZx9bJBlyBJHXNGL0mVM+glqXIG\nvSRVzqCXpMoZ9JJUOYNekirXNugj4pqI2BoRj7a0HRoR90XEQxExGhFHlvaIiCsiYkNEPBIRh/ez\neElSe53M6K8FTpjQdilwcWYeClxUHgOcCCwut5XAlTNTpiSpV22DPjN/CPxyYjOwV1meCzxblk8F\n/ikb9wF7R8SCmSpWktS9Xt8Zex5wZ0T8Pc0vi98r7QuBZ1r6bSptW3quUJI0Lb2+GPs54POZeSDw\neeBb3Q4QESvL+f3RN7aN9ViGJKmdXoP+DODmsvxd4MiyvBk4sKXfotL2Dpm5JjOXZubSWbvN7bEM\nSVI7vQb9s8DHyvLxwFNleS1wern65ihgLDM9bSNJA9T2HH1EXA8cB8yPiE3Al4C/BL4aEbOBV2iu\nsAH4V+AkYAOwDfhsH2qWJHWhbdBn5oopVh0xSd8Ezp5uUZKkmeM7YyWpcga9JFXOoJekyhn0klQ5\ng16SKjcU/xx8ycK5jPoPtyWpL5zRS1LlDHpJqpxBL0mVM+glqXIGvSRVzqCXpMoZ9JJUOYNekipn\n0EtS5Qx6SaqcQS9JlTPoJalyBr0kVc6gl6TKGfSSVDmDXpIqZ9BLUuUMekmqnEEvSZUz6CWpcga9\nJFVu9qALAFi/eYyRVbcPuoy+2Lh62aBLkPRrzhm9JFXOoJekyhn0klQ5g16SKmfQS1LlDHpJqlzb\noI+IayJia0Q82tK2T0TcFRFPlft5pf0zEfFIRKyPiB9HxG/3s3hJUnudzOivBU6Y0LYKuDszFwN3\nl8cAPwM+lplLgC8Da2aoTklSj9oGfWb+EPjlhOZTgevK8nXAp0rfH2fmr0r7fcCiGapTktSjXs/R\n75+ZW8ryc8D+k/Q5E7ijx/ElSTNk2h+BkJkZEdnaFhF/QBP0x061XUSsBFYCzNprv+mWIUmaQq8z\n+ucjYgFAud86viIiPgJcDZyamS9MNUBmrsnMpZm5dNZuc3ssQ5LUTq9BvxY4oyyfAdwKEBG/AdwM\n/FlmPjn98iRJ09X21E1EXA8cB8yPiE3Al4DVwI0RcSbwc+BPS/eLgH2Bb0QEwOuZubQPdUuSOtQ2\n6DNzxRSrPj5J37OAs6ZblCRp5vjOWEmqnEEvSZUz6CWpcga9JFXOoJekyhn0klS5aX8EwkxYsnAu\no6uXDboMSaqSM3pJqpxBL0mVM+glqXIGvSRVzqCXpMoZ9JJUOYNekipn0EtS5Qx6SaqcQS9JlTPo\nJalyBr0kVc6gl6TKGfSSVDmDXpIqZ9BLUuUMekmqnEEvSZUz6CWpcga9JFXOoJekys0edAEA6zeP\nMbLq9kGXMXAbVy8bdAmSKuSMXpIqZ9BLUuUMekmqnEEvSZUz6CWpcga9JFWu46CPiFkR8WBE3Dah\n/YqIeLnl8V9FxPqIeCgifhQRh8xkwZKk7nQzoz8XeLy1ISKWAvMm9Pt2Zi7JzEOBS4HLpleiJGk6\nOgr6iFgELAOubmmbBXwFOL+1b2a+1PJwdyCnX6YkqVedvjP2cppA37Ol7RxgbWZuiYi3dY6Is4Ev\nALsAx89AnZKkHrWd0UfEycDWzFzX0vZ+4NPA1ybbJjO/npm/CXwR+Lspxl0ZEaMRMfrGtrGeipck\ntdfJjP4Y4JSIOAnYFdgLeAx4FdhQZvO7RcSGzPzghG1vAK6cbNDMXAOsAZizYLGndySpT9rO6DPz\ngsxclJkjwHLgnsycl5kHZOZIad82HvIRsbhl82XAU32oW5LUoX58euU5EfGHwGvAr4Az+rAPSVKH\nugr6zLwXuHeS9j1als+ddlWSpBnjO2MlqXIGvSRVzqCXpMoZ9JJUOYNekio3FP8cfMnCuYz6j7El\nqS+c0UtS5Qx6SaqcQS9JlTPoJalyBr0kVc6gl6TKGfSSVDmDXpIqZ9BLUuUMekmqnEEvSZUz6CWp\ncga9JFXOoJekyhn0klQ5g16SKmfQS1LlDHpJqpxBL0mVM+glqXIGvSRVbvagCwBYv3mMkVW3D7oM\nSdqhNq5etkP244xekipn0EtS5Qx6SaqcQS9JlTPoJalyBr0kVa7joI+IWRHxYETcNqH9ioh4eZL+\nfxIRGRFLZ6JQSVJvupnRnws83tpQQnzexI4RsWfpf/+0qpMkTVtHQR8Ri4BlwNUtbbOArwDnT7LJ\nl4FLgFdmoEZJ0jR0OqO/nCbQ32xpOwdYm5lbWjtGxOHAgZnpW10laQi0DfqIOBnYmpnrWtreD3wa\n+NqEvjsBlwF/28G4KyNiNCJG39g21nXhkqTOdPJZN8cAp0TEScCuwF7AY8CrwIaIANgtIjYARwAf\nBu4t7QcAayPilMwcbR00M9cAawDmLFicM/PlSJImajujz8wLMnNRZo4Ay4F7MnNeZh6QmSOlfVtm\nfjAzxzJzfkv7fcA7Ql6StON4Hb0kVa6rjynOzHuBeydp32OK/sf1UpQkaeY4o5ekyhn0klQ5g16S\nKmfQS1LlDHpJqpxBL0mV6+ryyn5ZsnAuozvov6FL0q8bZ/SSVDmDXpIqZ9BLUuUMekmqnEEvSZUz\n6CWpcga9JFXOoJekyhn0klQ5g16SKheZg/+/3BHxv8ATg66jC/OBXwy6iC5Yb39Zb39Z79Q+kJn7\ntes0FJ91AzyRmUsHXUSnImLUevvHevvLevtrGOv11I0kVc6gl6TKDUvQrxl0AV2y3v6y3v6y3v4a\nunqH4sVYSVL/DMuMXpLUL5k50BtwAs2llRuAVX0Y/xpgK/BoS9s+wF3AU+V+XmkP4IpSyyPA4S3b\nnFH6PwWc0dJ+BLC+bHMF2/9K6nofZf2BwA+A/wIeA84d5pqBXYEHgIdLvReX9oOA+8s23wF2Ke1z\nyuMNZf1Iy1gXlPYngD9qd4z0so+WbWcBDwK3DXu9wMbyfD0EjA7z8VDW7w18D/gp8Dhw9LDWC3yo\nfF/Hby8B5w1rvT3n4EwHa5chPAt4GjgY2IUmLA6Z4X18FDictwf9pZQfQGAVcElZPgm4o3yjjwLu\nb3lC/rvczyvL40/KA6VvlG1P7GUfLbUtGH9igT2BJ4FDhrXm0rZHWd6ZJqiOAm4Elpf2bwKfK8t/\nDXyzLC8HvlOWDynP/xyaQHy6HB9THiPd7mPC9/kLwLfZHvRDWy9N0M+f0DaUx0NZfx1wVlnehSb4\nh7beCXn0HPCB90K9XeXgTIZqDyF8NHBny+MLgAv6sJ8R3h70TwALyvICmuv4Aa4CVkzsB6wArmpp\nv6q0LQB+2tL+Vr9u9/Eutd8KfOK9UDOwG/AT4Hdp3jAye+LzDNwJHF2WZ5d+MfG5H+831TFStulq\nHy1jLALuBo4HbutlrB1c70beGfRDeTwAc4GftdY/zPVOqPGTwH+8V+rt5jboc/QLgWdaHm8qbf22\nf2ZuKcvPAfu3qefd2jdN0t7LPt4hIkaAw2hmyUNbc0TMioiHaE6R3UUzo30xM1+fpP9bY5X1Y8C+\nPXwd+/awj3GXA+cDb5bHvYy1I+tN4PsRsS4iVpa2YT0eDgL+B/jHiHgwIq6OiN2HuN5Wy4Hrexxr\nIBnRqUEH/cBl8yszh20fEbEHcBNwXma+NN3xutXNPjLzjcw8lGamfCTwW/2sbToi4mRga2auG3Qt\nXTg2Mw8HTgTOjoiPtq4csuNhNs2p0isz8zDg/2hOS/QyVs+63UdE7AKcAnx3umP1ot/7GHTQb6Z5\n8XHcotLWb89HxAKAcr+1TT3v1r5okvZe9vGWiNiZJuT/OTNvfi/UDJCZL9K8kHw0sHdEzJ6k/1tj\nlfVzgRd6+Dpe6GEfAMcAp0TERuAGmtM3Xx3iesnMzeV+K/AvNL9Mh/V42ARsysz7y+Pv0QT/sNY7\n7kTgJ5n5fI9j7fCft24MOuj/E1gcEQeV36jLgbU7YL9raV4hp9zf2tJ+ejSOAsbKn1Z3Ap+MiHkR\nMY/mXN6dZd1LEXFURARw+oSxutkHAGWcbwGPZ+Zlw15zROwXEXuX5ffRvJ7wOE3gnzbFWOP7OA24\np8xm1gLLI2JORBwELKZ5EWvSY6Rs0+0+yMwLMnNRZo6Use7JzM8Ma70RsXtE7Dm+TPM8PtrDc7VD\njofMfA54JiI+VPp+nOYKsqGst8UKtp+26WWsHV1vd6Zzgn8mbjSvMD9Jc173wj6Mfz2wBXiNZrZx\nJs35z7tpLmv6N2Cf8Z8r4OullvXA0pZx/oLmcqcNwGdb2pfS/OA9DfwD2y+d6nofZf2xNH/CPcL2\nS75OGtaagY/QXKb4SBnzotJ+ME3wbaD5c3hOad+1PN5Q1h/cMtaFZR9PUK5MeLdjpJd9TPheH8f2\nq26Gst6yzcNsv3z1wmk8VzvqGD4UGC3HxC00V6EMc7270/wFNbelbWjr7eXmO2MlqXKDPnUjSeoz\ng16SKmfQS1LlDHpJqpxBL0mVM+glqXIGvSRVzqCXpMr9PzyZbvUHzjDyAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1113dbf50>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "top_supporters.head(5).amount.plot.barh()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<matplotlib.text.Text at 0x1114e9cd0>,\n",
       " <matplotlib.text.Text at 0x1114f4150>,\n",
       " <matplotlib.text.Text at 0x11155c0d0>,\n",
       " <matplotlib.text.Text at 0x111551cd0>,\n",
       " <matplotlib.text.Text at 0x11155cc50>]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAhMAAAD8CAYAAADNLiZaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGk9JREFUeJzt3X+UXWV97/H3xwSi0RpAvDaCZZBS0TY2Ylp/AC1qURHx\nJyrRSvzRxdJrSwWlhYu9F7u0YrWC1LtU7lWs1YoKooirKMV4RbRgooGgyK+SIimK6DJKiVrj9/5x\nnoHNyZlkZnbmR+D9WuusOefZz36e7zlzkvOZ/ew9k6pCkiRpuu431wVIkqSdm2FCkiT1YpiQJEm9\nGCYkSVIvhglJktSLYUKSJPVimJAkSb0YJiRJUi+GCUmS1MvCuS5Amg177rlnjY2NzXUZkrTTWLt2\n7e1V9dDJ9DVM6D5hbGyMNWvWzHUZkrTTSPLvk+3rMockSerFMCFJknoxTEiSpF4ME5IkqRfDhCRJ\n6sUwIUmSejFMSJKkXgwTkiSpF8OEJEnqxd+AqfuE9Rs3MXbS5+a6jJE2nHbEXJcgSb14ZEKSJPVi\nmJAkSb0YJiRJUi+GCUmS1IthQpIk9WKYkCRJvXhpqO6SZAuwnsH74hpgVVXdOdR+E/DyqvpxkjHg\nQuANwNvbML8JbAQ2A1cB3wW61z4uBvYDlgBHASuq6k+T3A84G9gCvLrN89P2GODLVXVckg8Bfwhs\nAgKcUFWX7NhXQpI0FYYJdW2uquUAST4KvAZ411D7PwCvA946vlNVfR74fNv+JeCNVbWmM+4p43fa\nuJ+oqjuSjLcFeB+wC/DKqqq27SlVdfuIOk+sqnOTPAU4C9h/Bzx3SdI0GSY0kUuBx45o/9oE7duV\n5I8ZHLlYNbTpTOAhwEuq6ldTGPJrwF7TqUWStOMYJrSVJAuBw4GLhtoXAE8DPjCNMceA04BDq+qX\nnU0vZbCkMtwOsLotsQD8Q1WdPrT9mcCnp1qLJGnHMkyo6wFJ1rX7l3J3aBhv34vBB//FUxm0hZCP\nAH9VVTcMbf4GcADw+8BlQ9smWuZ4R5K/AfYGnrSNeY8FjgVY8OCHTqVkSdIUeDWHujZX1fJ2+7Oq\n+kW3HdiHwUmPr5viuG8Cbq2qs0ds+w7wYuDjSX57kuOdWFW/Bfwl8MGJOlXVWVW1oqpWLFi8ZIol\nS5ImyzChSauqO4HjgDe0pZDtSvJE4BW0IwQTjPtV4LXAhUl+YwolvQe4X5JnTGEfSdIO5jKHpqSq\nvpnkKmAlg6WQ7Xkzg8tBV49fvdG8cGjczybZE7goySGtuXvOxFVVdczQPpXkLcBf0K4mkSTNvlTV\nXNcgzbhFS/evpavOmOsyRvJPkEuaj5KsraoVk+nrMockSerFMCFJknoxTEiSpF4ME5IkqRfDhCRJ\n6sUwIUmSevH3TOg+YdleS1jjJZiSNCM8MiFJknoxTEiSpF4ME5IkqRfDhCRJ6sUwIUmSejFMSJKk\nXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqReDBOSJKkXw4QkSerFMCFJknoxTEiSpF4ME5IkqRfDhCRJ\n6sUwIUmSejFMSJKkXgwTkiSpF8OEJEnqxTAhSZJ6WTjXBUizYf3GTYyd9Lm5LmPSNpx2xFyXIEmT\n5pEJSZLUi2FCkiT1YpiQJEm9GCYkSVIvhglJktSLYUKSJPVimJgjSVYnecZQ2+uTvHfo8c+SLOm0\nHZqkkhzZabswyaETzLMwyQ+SnDbU/qUkNydJp+3TSe5o98eSbE6yrnM7pm3bkGR9kquS/L8k+3TG\n6O5fSf6ss+09SV7ReXxCku+0sa5M8q4kuwzNMT73ma39Q0k2JlnUHu+ZZMMkXnJJ0gwxTMydjwFH\nD7Ud3drHrQS+DrxgqN8twCmTnOcw4DrgRd3g0PwYOAggyW7A0qHtN1bV8s7tw51tT6mqxwJfAt40\nwdy3AX+eZNfhDUleAzwdeGJVLQN+r/V/wNAc43Mf12nfArxq4qcsSZpNhom5cy5wxPgHbZIx4OHA\npe3xfsCDGHxQrxza90pgU5LDJjHPSuDdwM3Ak4a2ncPdgeYFwKem+iSArwF7TbDtB8AlwKoR204B\nXltVPwaoql9U1WlV9ZNJzHkGcHwSf+maJM0Dhok5UlU/Aq4ADm9NRwOfqKrqPD6HQbh4VJKHDQ3x\nViY+IgBAkvsDfwR8lsERj+FQcgnwB0kWtPk+PrR9v6FljkNGTPNM4NPbKOPtwBvbHON1PRh4UFXd\ntK36gdWduY/vtN8MfAV4+Xb2lyTNAsPE3OoudYxa4jinqn4FnAe8qLtjVX0ZIMnB2xj/2cDqqtrc\nxnhe90OdwXLBV9rcD6iqDUP7Dy9zXNrZtjrJRgZh6GNMoKr+DbgceOlEfZI8owWGDUme3NnUXeY4\nfWi3twEnso33cJJjk6xJsmbLnZsm6iZJ6skwMbc+AzwtyYHA4qpaC5BkGbA/cHE7ufBotj6qANs/\nOrES+KM2xlrgIcBTh/qcA5wJfGKKtT8F2AdYB7x5O33/BvhLIABtKeOOJPu2x5+vquXA1cBW51eM\nUlXXt7lfvI0+Z1XViqpasWDxkom6SZJ6MkzMoaq6A1gNfJCtj0qcWlVj7fZw4OHdqyba/l8Adgce\nOzx2W0o4BPiN8XGA17F1KLmUwU/5Ex5d2Eb9vwReDxyTZI9t9PsO8G3gyE7z24D3thM/aSeH3n+K\nJbwVeOMU95Ek7WCGibn3MeB3ueeH+dHA+UP9zmfrqz9g8IH6iBHtzwe+WFU/77R9Bjhy/LJKgBp4\nZ1XdPmKM4XMmjhvuUFW3ttpfN2L/4Tr37jx+L4NzNi5PchVwGfDNdhvXPWeieyXJ+NzfAr6xnXkl\nSTMsd5/vJ917LVq6fy1ddcZclzFp/glySXMtydqqWjGZvh6ZkCRJvRgmJElSL4YJSZLUi2FCkiT1\nYpiQJEm9+LcNdJ+wbK8lrPEKCUmaER6ZkCRJvRgmJElSL4YJSZLUi2FCkiT1YpiQJEm9GCYkSVIv\nhglJktSLYUKSJPVimJAkSb0YJiRJUi+GCUmS1IthQpIk9WKYkCRJvRgmJElSL4YJSZLUi2FCkiT1\nYpiQJEm9GCYkSVIvhglJktSLYUKSJPVimJAkSb0snOsCpNmwfuMmxk763FyXMSM2nHbEXJcg6T7O\nIxOSJKkXw4QkSerFMCFJknoxTEiSpF4ME5IkqRfDhCRJ6sUwoR0uyR0j2k5NsjHJus5ttyTfTLK8\n9VmY5I4kf9zZb22SA5O8Isl7WtujknypjXFNkrNm79lJkoYZJjSbTq+q5Z3bj4HLgCe37b8LXDf+\nOMkDgf2AK4fGObMz1qOBv5+d8iVJoxgmNNe+yt1h4snA+4Dl7fHvA2urasvQPkuBW8YfVNX6mS5S\nkjQxw4Rm0/GdJY7Vra17ZOLJwJeBnyf5tfb4qyPGOR34YpJ/TnJ8kt1mvHJJ0oQME5pN3WWOpwBU\n1b8Duyb5deAA4Frg68ATGISJy4YHqaqzgUcDnwQOBf41yaLhfkmOTbImyZotd26aqeckSfd5hgnN\nB18FXgTcWlUF/CtwEINljq+N2qGq/qOqPlhVzwV+CfzOiD5nVdWKqlqxYPGSmateku7jDBOaD74K\nvJ67g8PXgGOA71XVVocUkjwzyS7t/q8DDwE2zlKtkqQh/tVQzYTFSW7pPH5X+3p897JP4HlVtYHB\nUsbptDBRVbcmWcDo8yUAng68O8nP2uMTq+p7O6x6SdKUZHBUWbp3W7R0/1q66oy5LmNG+CfIJc2E\nJGurasVk+rrMIUmSejFMSJKkXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqRe/D0Tuk9YttcS1ngJpSTN\nCI9MSJKkXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqReDBOSJKkXw4QkSerFMCFJknoxTEiSpF4ME5Ik\nqRfDhCRJ6sUwIUmSejFMSJKkXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqReDBOSJKkXw4QkSerFMCFJ\nknoxTEiSpF4WznUB0mxYv3ETYyd9bq7LmHMbTjtirkuQdC/kkQlJktSLYUKSJPVimJAkSb0YJiRJ\nUi+GCUmS1IthQpIk9WKY0JQk2ZJkXZKrk3wyyeLOtuclqSQHdNrGkmxu+3w7yYeT7NK2HZrkwk7f\ntyS5KMmiJF9Kcm3bb12Sc1ufU5Ns7Iy3cjafvyRpa4YJTdXmqlpeVb8D/AJ4TWfbSuAr7WvXjVW1\nHFgG7A28eHjQJG8CDgKeX1U/b80va3Mtr6qjOt1Pb+M9F3j/eDiRJM0Nw4T6uBT4TYAkDwIOBl4N\nHD2qc1VtAa4A9uq2J3kDcDhwZFVtnuzkVXU9cCew+3SKlyTtGIYJTUuShQwCwPrW9Fzgoqq6Dvhh\nkseP2Of+wBOAizrNBzE4unF4Vd0xtMtHO8sc7xgx3oHA9VV1W/9nJEmaLsOEpuoBSdYBa4CbgQ+0\n9pXAOe3+OdxzqWO/ts/3gVur6qrOthuAAIeNmKu7zHFip/34JN8CLgfeOlGhSY5NsibJmi13bprC\nU5QkTYV/m0NTtbmdr3CXJHsATwWWJSlgAVBJxgPAjVW1PMmewGVJnlNVF7Rt3wdeBlyS5EdVtXoS\nNZxeVe9M8hzgA0n2q6qfDXeqqrOAswAWLd2/pvNkJUnb55EJ7QhHAf9YVftU1VhVPQK4CTik26mq\nbgdOAk4ear8OeAHwkST3CCrb0gLJGmBVz/olST0YJrQjrATOH2o7j62v6gD4NLA4yXDQ+DrwSuCC\nJPu15u45E/8ywdx/DZyQxPeyJM2RVHn0V/d+i5buX0tXnTHXZcw5/wS5pMlKsraqVkymrz/NSZKk\nXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqRe/KVVuk9YttcS1nglgyTNCI9MSJKkXgwTkiSpF8OEJEnq\nxTAhSZJ6MUxIkqReDBOSJKkXw4QkSerFMCFJknoxTEiSpF4ME5IkqRfDhCRJ6sUwIUmSejFMSJKk\nXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqReDBOSJKkXw4QkSerFMCFJknoxTEiSpF4WznUB0mxYv3ET\nYyd9bq7LkKRZs+G0I2ZtLo9MSJKkXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqReDBOSJKmX7YaJJFuS\nrEtydZJPJlnc2fa8JJXkgE7bWJLNbZ9vJ/lwkl3atkOTXNjp+5YkFyVZlORLSa5t+61Lcm7rc2qS\njZ3xVm6n3nVJzhlq+1AbY1F7vGeSDUP1fjPJNUmuSPKK7cxxRhvvfp22VyT5Qaf+D3fmvqnTflxr\n35Bkz3b/jhFznJrkjZ3HC9v4p3Xazm9j3pBkU2eOJ0/y9bw+yaeSPGaC5zlc+1c7z/VXSR7b6Xt1\ney0vb31vHno9xtpzflin7XudWtYl2XX8tRh6H43fjmnbXpVkfZKr2rzP3db3S5I0sybzeyY2V9Vy\ngCQfBV4DvKttWwl8pX39X519bqyq5UkWABcDLwY+2h00yZuAg4BnVdXPkwC8rKrWjKjh9Kp6Z5L9\ngbVJzq2q/xrulOTRwALgkCQPrKr/7GzeArwKeO+I8W+sqse1MR4JfCpJqursEXPcD3g+8F3gD4HV\nnc0fr6o/HTH+iVV17oj2qTgMuA54UZKTa+D5raZDgTdW1bM7dcJ2Xs/W7yXAF5Msq6ofTKH2W4BT\ngJd0G6vqCW3cVwAruq9Hq2lL5/10KnDHeC2dPuNuHO/b2b53m/fAqtqU5EHAQ0fUJ0maJVNd5rgU\n+E2A9p/4wcCrgaNHda6qLcAVwF7d9iRvAA4HjqyqzZOdvKquB+4Edp+gy0rgH4EvAMM/rZ4BHJ9k\nmwGqqv4NOAE4boIuhwLfYhBKtnmUZAdbCbwbuBl40o4atKo+zuD1eukUd70Q+O0kj9pRtUzSfwN+\nCtwBUFV3VNVNs1yDJKlj0mGifQgfDqxvTc8FLqqq64AfJnn8iH3uDzwBuKjTfBCDoxuHV9Xw4f2P\ndg5pv2PEeAcC11fVbROU+RLgHOBjbP1BfzODoygv38bTHPcN4IAJtq1s458PHJG2hDM+f6f+V3ba\n39FpXzaJ+e+hvY5/BHyW0c9tItt8PTu29Xy7tXePLv0K+Fvgf0yylunYb2iZ4xDgSuD7wE1Jzk5y\n5AzOL0mahMksczwgybp2/1LgA+3++E/KMPgAXwmsbY/3a/vsC3yuqq7qjHcDgyMLhwHnDc010WH5\n49uH828BIz88kqwAbq+qm5NsBD6YZI+q+lGn29uAzwDb+73KGdmY7Ao8Czihqn6a5HLgGQx+SoeZ\nW+Z4NrC6qjYnOQ/4qySvb0d+tmWi13PYyOfbbKv2fwJOSbLvJOaYjq2WOQCSPBP4PeBpwOlJHl9V\np47odyxwLMCCB7sSIkkzZUrnTIxLsgfwVGBZkmJwnkIlObF1GT9nYk/gsiTPqaoL2rbvAy8DLkny\no6rqnnMwkfFzJp4DfCDJflX1s6E+K4ED0k6sBB4MvBD4P+Mdqur6FnJevJ35HgdcM6L9GcBuwPq2\ntr8Y2MzdYWKmrAQO7jy3hzB4/S/eQeM/DphM6LiHqvplkr8D/nIH1THZeYvB8tkVSS4GzgZOHdHv\nLOAsgEVL96/ZrFGS7kume2noUcA/VtU+VTVWVY8AbgIO6XaqqtuBk4CTh9qvA14AfCTJVj95TqQF\nkjXAqm57OynyxcCyVs8Yg2WYUcsBbwXeOKJ9fKwx4J3A34/YvBL4k84c+wKHpXOFy46W5MEMXtff\n6Mz7OnbQ+RpJXgg8ncHyyXR8iMESzKz86J/k4W25a9xy4N9nY25J0mjTDRMrGZwz0HUeoz/gPg0s\nbuvdd6mqrwOvBC5Isl9r7q7x/8sEc/81cEI6l2Uy+LDdWFX/0Wn7MvCYJEuH5v0Wg3MEuvZLuzQU\n+ARw5vCVHC0wPJPOEkm7WuQrTLD0MgWLk9zSuZ3Q2fZ84ItV9fNO22eAI9Mudd2GiV7P41vb9cAf\nA0+d4EoOuOc5E+vaUs9dquoXwJkMTozc0YbPmTgO2AV4Z5LvtKNMLwH+fAbmliRNUgZHjKV7t0VL\n96+lq86Y6zIkadb0/RPkSdZW1YrJ9PU3YEqSpF4ME5IkqRfDhCRJ6sUwIUmSejFMSJKkXgwTkiSp\nl8n8Bkxpp7dsryWs6XmZlCRpNI9MSJKkXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqReDBOSJKkXw4Qk\nSerFMCFJknoxTEiSpF4ME5IkqZdU1VzXIM24JD8Frp3rOqZgT+D2uS5iCqx35uxMtYL1zrTZrHef\nqnroZDr6tzl0X3FtVa2Y6yImK8ka6505O1O9O1OtYL0zbb7W6zKHJEnqxTAhSZJ6MUzovuKsuS5g\niqx3Zu1M9e5MtYL1zrR5Wa8nYEqSpF48MiFJknoxTOheLckzk1yb5IYkJ83QHB9McluSqztteyS5\nOMn17evurT1Jzmz1XJXkwM4+q1r/65Os6rQ/Psn6ts+ZSdJjjkckWZ3k20m+leTP53m9909yRZIr\nW71vbu37Jrm87fPxJLu29kXt8Q1t+1hnrJNb+7VJntFpH/kemc4cnX0XJPlmkgvne71JNrTv17ok\na+bz+6Ft3y3JuUm+k+SaJE+ar/UmeVR7XcdvP0ny+vlaby9V5c3bvfIGLABuBB4J7ApcCTxmBub5\nA+BA4OpO298CJ7X7JwFvb/efBfwzEOCJwOWtfQ/g39rX3dv93du2K1rftH0Pn84cbdtS4MB2/9eA\n64DHzON6Azyo3d8FuLz1+QRwdGt/H/Dadv+/A+9r948GPt7uP6Z9/xcB+7b3xYJtvUemOsfQe+IE\n4J+AC6cz1mzWC2wA9hxqm5fvh7b9H4A/afd3BXabz/UO/X/0PWCfnaHeKf8/uKP/Y/Xmbb7cgCcB\nn+88Phk4eYbmGuOeYeJaYGm7v5TB77kAeD+wcrgfsBJ4f6f9/a1tKfCdTvtd/aY6xwR1fwY4bGeo\nF1gMfAN4AoNf2rNw+PsMfB54Uru/sPXL8Pd+vN9E75G2z5Tm6IyxN3AJ8FTgwumMNcv1bmDrMDEv\n3w/AEuCmbv3zud6hGp8OXLaz1DvVm8scujfbC/hu5/EtrW02PKyqbm33vwc8bDs1bav9lhHt05nj\nHtrh7scx+Gl/3tabwZLBOuA24GIGP5n/uKp+OaL/XWO17ZuAh0zjeTxkGnOMOwP4C+BX7fF0xprN\negv4QpK1SY5tbfP1/bAv8APg7AyWkf5vkgfO43q7jgY+Ns2x5qLeKTFMSDOsBvG/5tMcSR4EnAe8\nvqp+0mes6ZjKHFW1paqWM/iJ//eBA2aytj6SPBu4rarWznUtU3BwVR0IHA68LskfdDfOs/fDQgZL\niu+tqscB/8ngEP50xpq2afx72xV4DvDJvmNNx2zMYZjQvdlG4BGdx3u3ttnw/SRLAdrX27ZT07ba\n9x7RPp05aH13YRAkPlpVn5rv9Y6rqh8Dqxkcwt8tycIR/e8aq21fAvxwGs/jh9OYA+Ag4DlJNgDn\nMFjqePc8rpeq2ti+3gaczyCwzdf3wy3ALVV1eXt8LoNwMV/rHXc48I2q+v40x5r1f29TZZjQvdnX\ngf0zOMt9VwaHGS+YpbkvAFa1+6sYnJsw3n5MO6P6icCmdijy88DTk+zezrp+OoM171uBnyR5YjtL\n+5ihsaYyB22MDwDXVNW7doJ6H5pkt3b/AQzO77iGQag4aoKxxuc4Cvhi+6nsAuDoDK5s2BfYn8GJ\nayPfI22fqc5BVZ1cVXtX1Vgb64tV9bL5Wm+SByb5tfH7DL6PV0/jezUr74eq+h7w3SSPan2fBnx7\nvtbbsZK7lzimM9Zs1zt1fU+68OZtPt8YnLl8HYN19lNmaI6PAbcC/8XgJ6dXM1iTvgS4HvgXYI/W\nN8D/bvWsB1Z0xnkVcEO7vbLTvoLBf/A3Au/h7l82N505DmZwuPMqYF27PWse1/tY4Jut3quB/9na\nH8ngw/UGBoeOF7X2+7fHN7Ttj+yMdUqb41raGe/beo9MZ46h98Wh3H01x7yst+1zZbt9a3y8+fp+\naNuXA2vae+LTDK5umM/1PpDBkaAlnbZ5W+90b/4GTEmS1IvLHJIkqRfDhCRJ6sUwIUmSejFMSJKk\nXgwTkiSpF8OEJEnqxTAhSZJ6MUxIkqRe/j9GqvMkWhMQowAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x11149df90>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "chart = top_supporters.head(5).amount.plot.barh()\n",
    "chart.set_yticklabels(top_supporters.contributor_lastname)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def combine_names(row):\n",
    "    if row.contributor_fullname.startswith('SEAN PARKER'):\n",
    "        return 'SEAN PARKER'\n",
    "    return row.contributor_fullname\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "(\"'Series' object has no attribute 'contributor_fullname'\", u'occurred at index 444')",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-43-447c64b4a49a>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mtop_supporters\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcombine_names\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/Users/Mununuri/Code/first-python-notebook/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36mapply\u001b[0;34m(self, func, axis, broadcast, raw, reduce, args, **kwds)\u001b[0m\n\u001b[1;32m   4260\u001b[0m                         \u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4261\u001b[0m                         \u001b[0mreduce\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mreduce\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 4262\u001b[0;31m                         ignore_failures=ignore_failures)\n\u001b[0m\u001b[1;32m   4263\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4264\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_apply_broadcast\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/Mununuri/Code/first-python-notebook/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m_apply_standard\u001b[0;34m(self, func, axis, ignore_failures, reduce)\u001b[0m\n\u001b[1;32m   4356\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4357\u001b[0m                 \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mv\u001b[0m \u001b[0;32min\u001b[0m \u001b[0menumerate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mseries_gen\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 4358\u001b[0;31m                     \u001b[0mresults\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mv\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   4359\u001b[0m                     \u001b[0mkeys\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mv\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4360\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mException\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-42-0956eaddcd48>\u001b[0m in \u001b[0;36mcombine_names\u001b[0;34m(row)\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;32mdef\u001b[0m \u001b[0mcombine_names\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m     \u001b[0;32mif\u001b[0m \u001b[0mrow\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcontributor_fullname\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstartswith\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'SEAN PARKER'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      3\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0;34m'SEAN PARKER'\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m     \u001b[0;32mreturn\u001b[0m \u001b[0mrow\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcontributor_fullname\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/Mununuri/Code/first-python-notebook/lib/python2.7/site-packages/pandas/core/generic.pyc\u001b[0m in \u001b[0;36m__getattr__\u001b[0;34m(self, name)\u001b[0m\n\u001b[1;32m   3079\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mname\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_info_axis\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3080\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3081\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3082\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3083\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__setattr__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: (\"'Series' object has no attribute 'contributor_fullname'\", u'occurred at index 444')"
     ]
    }
   ],
   "source": [
    "top_supporters.apply(combine_names, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}