hello_data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# First Python Notebook\n",
    "\n",
    "Hello world!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importing data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "%matplotlib inline\n",
    "props = pd.read_csv(\"http://www.firstpythonnotebook.org/_static/committees.csv\")\n",
    "contribs = pd.read_csv(\"http://www.firstpythonnotebook.org/_static/contributions.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Analysing general statistics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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",
       "    <tr>\n",
       "      <th>1</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>383</td>\n",
       "      <td>1220380</td>\n",
       "      <td>COMMUNITY COLLEGE FACILITY COALITION ISSUES CO...</td>\n",
       "      <td>SUPPORT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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>384</td>\n",
       "      <td>1282321</td>\n",
       "      <td>TORLAKSON'S INVEST IN CALIFORNIA A BALLOT MEAS...</td>\n",
       "      <td>SUPPORT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</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>385</td>\n",
       "      <td>1382843</td>\n",
       "      <td>CALIFORNIA TAXPAYERS AND EDUCATORS OPPOSED TO ...</td>\n",
       "      <td>OPPOSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ocd-contest/85990193-9d6f-4600-b8e7-bf1317841d82</td>\n",
       "      <td>1362198</td>\n",
       "      <td>71</td>\n",
       "      <td>PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...</td>\n",
       "      <td>386</td>\n",
       "      <td>1362973</td>\n",
       "      <td>YES ON PROPOSITION 52 - A COALITION OF CALIFOR...</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",
       "1  ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6            1376258   \n",
       "2  ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6            1376258   \n",
       "3  ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6            1376258   \n",
       "4  ocd-contest/85990193-9d6f-4600-b8e7-bf1317841d82            1362198   \n",
       "\n",
       "   ccdc_prop_id                                          prop_name  \\\n",
       "0            70  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...   \n",
       "1            70  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...   \n",
       "2            70  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...   \n",
       "3            70  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...   \n",
       "4            71  PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...   \n",
       "\n",
       "   ccdc_committee_id  calaccess_committee_id  \\\n",
       "0                382                 1374469   \n",
       "1                383                 1220380   \n",
       "2                384                 1282321   \n",
       "3                385                 1382843   \n",
       "4                386                 1362973   \n",
       "\n",
       "                                      committee_name committee_position  \n",
       "0  YES ON PROPOSITION 51 - CALIFORNIANS FOR QUALI...            SUPPORT  \n",
       "1  COMMUNITY COLLEGE FACILITY COALITION ISSUES CO...            SUPPORT  \n",
       "2  TORLAKSON'S INVEST IN CALIFORNIA A BALLOT MEAS...            SUPPORT  \n",
       "3  CALIFORNIA TAXPAYERS AND EDUCATORS OPPOSED TO ...             OPPOSE  \n",
       "4  YES ON PROPOSITION 52 - A COALITION OF CALIFOR...            SUPPORT  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "props.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contribs.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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": [
    "## Generating nice-looking tables with .reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>prop_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>72</td>\n",
       "      <td>PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>73</td>\n",
       "      <td>PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>74</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>75</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>76</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>77</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>78</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>79</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>80</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>81</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>82</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>83</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>84</td>\n",
       "      <td>PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>85</td>\n",
       "      <td>PROPOSITION 065- CARRY-OUT BAGS. CHARGES. INIT...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>86</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>87</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>88</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>89</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>90</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>91</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>92</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>93</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>94</td>\n",
       "      <td>PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>95</td>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>96</td>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>97</td>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>98</td>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>99</td>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>100</td>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>101</td>\n",
       "      <td>PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>102 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index                                          prop_name\n",
       "0        0  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...\n",
       "1        1  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...\n",
       "2        2  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...\n",
       "3        3  PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-...\n",
       "4        4  PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...\n",
       "5        5  PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...\n",
       "6        6  PROPOSITION 052 - STATE FEES ON HOSPITALS. FED...\n",
       "7        7  PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...\n",
       "8        8  PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...\n",
       "9        9  PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...\n",
       "10      10  PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOT...\n",
       "11      11  PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...\n",
       "12      12  PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...\n",
       "13      13  PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...\n",
       "14      14  PROPOSITION 054 - LEGISLATURE. LEGISLATION AND...\n",
       "15      15  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "16      16  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "17      17  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "18      18  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "19      19  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "20      20  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "21      21  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "22      22  PROPOSITION 055 - TAX EXTENSION TO FUND EDUCAT...\n",
       "23      23  PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...\n",
       "24      24  PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...\n",
       "25      25  PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...\n",
       "26      26  PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...\n",
       "27      27  PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...\n",
       "28      28  PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...\n",
       "29      29  PROPOSITION 056 - CIGARETTE TAX TO FUND HEALTH...\n",
       "..     ...                                                ...\n",
       "72      72  PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...\n",
       "73      73  PROPOSITION 063- FIREARMS. AMMUNITION SALES. I...\n",
       "74      74  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "75      75  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "76      76  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "77      77  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "78      78  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "79      79  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "80      80  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "81      81  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "82      82  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "83      83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "84      84  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...\n",
       "85      85  PROPOSITION 065- CARRY-OUT BAGS. CHARGES. INIT...\n",
       "86      86  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "87      87  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "88      88  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "89      89  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "90      90  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "91      91  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "92      92  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "93      93  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "94      94  PROPOSITION 066- DEATH PENALTY. PROCEDURES. IN...\n",
       "95      95  PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...\n",
       "96      96  PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...\n",
       "97      97  PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...\n",
       "98      98  PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...\n",
       "99      99  PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...\n",
       "100    100  PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...\n",
       "101    101  PROPOSITION 067- REFERENDUM TO OVERTURN BAN ON...\n",
       "\n",
       "[102 rows x 2 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "props.prop_name.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "props.prop_name.value_counts().reset_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filtering one specific proposition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>74</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</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",
       "    </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>460</td>\n",
       "      <td>1371855</td>\n",
       "      <td>MARIJUANA POLICY PROJECT OF CALIFORNIA, YES ON 64</td>\n",
       "      <td>SUPPORT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         ocd_prop_id  calaccess_prop_id  \\\n",
       "74  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "75  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "76  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "77  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "78  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "\n",
       "    ccdc_prop_id                                          prop_name  \\\n",
       "74            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "75            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "76            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "77            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "78            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "\n",
       "    ccdc_committee_id  calaccess_committee_id  \\\n",
       "74                456                 1381808   \n",
       "75                457                 1382525   \n",
       "76                458                 1376077   \n",
       "77                459                 1382568   \n",
       "78                460                 1371855   \n",
       "\n",
       "                                       committee_name committee_position  \n",
       "74  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT  \n",
       "75                             NEW APPROACH PAC (MPO)            SUPPORT  \n",
       "76  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...            SUPPORT  \n",
       "77  PUBLIC AND MENTAL HEALTH ADVOCATES AGAINST 64,...             OPPOSE  \n",
       "78  MARIJUANA POLICY PROJECT OF CALIFORNIA, YES ON 64            SUPPORT  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prop = props[props.prop_name == \"PROPOSITION 064- MARIJUANA LEGALIZATION. INITIATIVE STATUTE.\"]\n",
    "prop.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 11 entries, 74 to 84\n",
      "Data columns (total 8 columns):\n",
      "ocd_prop_id               11 non-null object\n",
      "calaccess_prop_id         11 non-null int64\n",
      "ccdc_prop_id              11 non-null int64\n",
      "prop_name                 11 non-null object\n",
      "ccdc_committee_id         11 non-null int64\n",
      "calaccess_committee_id    11 non-null int64\n",
      "committee_name            11 non-null object\n",
      "committee_position        11 non-null object\n",
      "dtypes: int64(4), object(4)\n",
      "memory usage: 792.0+ bytes\n"
     ]
    }
   ],
   "source": [
    "prop.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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": 11,
   "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": "markdown",
   "metadata": {},
   "source": [
    "## Merging two tables on one field"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>0</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>2038581</td>\n",
       "      <td>2016-02-04</td>\n",
       "      <td>BRADEN QUIGLEY</td>\n",
       "      <td>LAURA</td>\n",
       "      <td>SACRAMENTO</td>\n",
       "      <td>CA</td>\n",
       "      <td>95825</td>\n",
       "      <td>LBQ STRATEGIES</td>\n",
       "      <td>CONSULTANT</td>\n",
       "      <td>False</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</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>2038581</td>\n",
       "      <td>2016-01-05</td>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</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>250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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>2038581</td>\n",
       "      <td>2016-01-29</td>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</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>250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</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>2038581</td>\n",
       "      <td>2016-03-28</td>\n",
       "      <td>CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...</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>250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</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>2038581</td>\n",
       "      <td>2016-01-05</td>\n",
       "      <td>DRUG POLICY ACTION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>250000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        ocd_prop_id  calaccess_prop_id  \\\n",
       "0  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "1  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "2  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "3  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "4  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "\n",
       "   ccdc_prop_id                                          prop_name  \\\n",
       "0            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "1            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "2            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "3            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "4            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "\n",
       "   ccdc_committee_id  calaccess_committee_id  \\\n",
       "0                456                 1381808   \n",
       "1                456                 1381808   \n",
       "2                456                 1381808   \n",
       "3                456                 1381808   \n",
       "4                456                 1381808   \n",
       "\n",
       "                                    committee_name_x committee_position  \\\n",
       "0  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "1  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "2  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "3  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "4  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...            SUPPORT   \n",
       "\n",
       "                                    committee_name_y  calaccess_filing_id  \\\n",
       "0  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2038581   \n",
       "1  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2038581   \n",
       "2  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2038581   \n",
       "3  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2038581   \n",
       "4  YES ON 64, CALIFORNIANS TO CONTROL, REGULATE A...              2038581   \n",
       "\n",
       "  date_received                               contributor_lastname  \\\n",
       "0    2016-02-04                                     BRADEN QUIGLEY   \n",
       "1    2016-01-05  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...   \n",
       "2    2016-01-29  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...   \n",
       "3    2016-03-28  CALIFORNIANS FOR SENSIBLE REFORM, SPONSORED BY...   \n",
       "4    2016-01-05                                 DRUG POLICY ACTION   \n",
       "\n",
       "  contributor_firstname contributor_city contributor_state contributor_zip  \\\n",
       "0                 LAURA       SACRAMENTO                CA           95825   \n",
       "1                   NaN           IRVINE                CA           92618   \n",
       "2                   NaN           IRVINE                CA           92618   \n",
       "3                   NaN           IRVINE                CA           92618   \n",
       "4                   NaN         NEW YORK                NY           10001   \n",
       "\n",
       "  contributor_employer contributor_occupation contributor_is_self_employed  \\\n",
       "0       LBQ STRATEGIES             CONSULTANT                        False   \n",
       "1                  NaN                    NaN                        False   \n",
       "2                  NaN                    NaN                        False   \n",
       "3                  NaN                    NaN                        False   \n",
       "4                  NaN                    NaN                        False   \n",
       "\n",
       "     amount  \n",
       "0     100.0  \n",
       "1  250000.0  \n",
       "2  250000.0  \n",
       "3  250000.0  \n",
       "4  250000.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged = pd.merge(prop, contribs, on=\"calaccess_committee_id\")\n",
    "merged.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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": "markdown",
   "metadata": {},
   "source": [
    "## Summing the total amount from the merged table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "35177017.640000001"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.amount.sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Counting occurences in the merged table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SUPPORT    762\n",
       "OPPOSE      98\n",
       "Name: committee_position, dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.committee_position.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Selecting and summing per position"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "support = merged[merged.committee_position == \"SUPPORT\"]\n",
    "oppose = merged[merged.committee_position == \"OPPOSE\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2501211.6400000001"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oppose.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "32675806.0"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "support.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.92889642704798669"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "support.amount.sum() / merged.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.071103572952013333"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oppose.amount.sum() / merged.amount.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25522.567755102042"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oppose.amount.sum() / oppose.amount.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "42881.635170603673"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "support.amount.sum() / support.amount.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "98"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oppose.amount.count()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Sorting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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",
       "  </tbody>\n",
       "</table>\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",
       "\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",
       "\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",
       "\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",
       "\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",
       "\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",
       "\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",
       "\n",
       "    contributor_employer contributor_occupation contributor_is_self_employed  \\\n",
       "142                  NaN                    NaN                        False   \n",
       "79                   NaN                    NaN                        False   \n",
       "846                  NaN                    NaN                        False   \n",
       "851                  NaN                    NaN                        False   \n",
       "852                  NaN                    NaN                        False   \n",
       "\n",
       "        amount  \n",
       "142  4000000.0  \n",
       "79   2000000.0  \n",
       "846  1970000.0  \n",
       "851  1970000.0  \n",
       "852  1403000.0  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.sort_values(\"amount\", ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>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>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>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",
       "  </tbody>\n",
       "</table>\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",
       "851  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "846  ocd-contest/232cb72c-1b11-4293-b4e2-a181e80d172e            1381868   \n",
       "852  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",
       "851            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "846            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "852            83  PROPOSITION 064- MARIJUANA LEGALIZATION. INITI...   \n",
       "\n",
       "     ccdc_committee_id  calaccess_committee_id  \\\n",
       "142                456                 1381808   \n",
       "79                 456                 1381808   \n",
       "851                465                 1385745   \n",
       "846                464                 1385506   \n",
       "852                465                 1385745   \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",
       "851       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            SUPPORT   \n",
       "846  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...            SUPPORT   \n",
       "852       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))            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",
       "851       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2082414   \n",
       "846  DRUG POLICY ACTION - NON PROFIT 501C4, YES ON ...              2083608   \n",
       "852       FUND FOR POLICY REFORM (NONPROFIT 501(C)(4))              2096507   \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",
       "851    2016-09-15                             FUND FOR POLICY REFORM   \n",
       "846    2016-09-15      FUND FOR POLICY REFORM (NONPROFIT 501 (C)(4))   \n",
       "852    2016-09-27                             FUND FOR POLICY REFORM   \n",
       "\n",
       "    contributor_firstname contributor_city contributor_state contributor_zip  \\\n",
       "142                  SEAN        PALO ALTO                CA           94301   \n",
       "79                    NaN       SACRAMENTO                CA           95815   \n",
       "851                   NaN       WILMINGTON                DE           19809   \n",
       "846                   NaN         NEW YORK                NY           10019   \n",
       "852                   NaN       WILMINGTON                DE           19809   \n",
       "\n",
       "    contributor_employer contributor_occupation contributor_is_self_employed  \\\n",
       "142                  NaN                    NaN                        False   \n",
       "79                   NaN                    NaN                        False   \n",
       "851                  NaN                    NaN                        False   \n",
       "846                  NaN                    NaN                        False   \n",
       "852                  NaN                    NaN                        False   \n",
       "\n",
       "        amount  \n",
       "142  4000000.0  \n",
       "79   2000000.0  \n",
       "851  1970000.0  \n",
       "846  1970000.0  \n",
       "852  1403000.0  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "support.sort_values(\"amount\", ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oppose.sort_values(\"amount\", ascending=False).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Grouping\n",
    "### By one value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.groupby(\"committee_name_x\").amount.sum().reset_index().sort_values(\"amount\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### By several values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>contributor_firstname</th>\n",
       "      <th>contributor_lastname</th>\n",
       "      <th>committee_position</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>SEAN</td>\n",
       "      <td>PARKER AND AFFILIATED ENTITIES</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>7250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>SEAN</td>\n",
       "      <td>PARKER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>1500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>JULIE</td>\n",
       "      <td>SCHAUER</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>1364000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>DANIEL</td>\n",
       "      <td>LEWIS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>1250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>HENRY</td>\n",
       "      <td>VAN AMERINGEN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>NICHOLAS</td>\n",
       "      <td>PRITZKER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>900000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>PETER</td>\n",
       "      <td>THIEL</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>300000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>ROGER</td>\n",
       "      <td>JENKINS</td>\n",
       "      <td>SUPPORT</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>65000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>LAWRENCE</td>\n",
       "      <td>HESS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>JASON</td>\n",
       "      <td>POST</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>ROGER B.</td>\n",
       "      <td>MCNAMEE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>548</th>\n",
       "      <td>ZACHARY PYM</td>\n",
       "      <td>WILLIAMS</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>JEREMY</td>\n",
       "      <td>ZACHARY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>7500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>ROBERT</td>\n",
       "      <td>ADAMS</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>LAURIE</td>\n",
       "      <td>BENENSON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>CAMILLA</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>DEAN</td>\n",
       "      <td>OPPOSE</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>MARY QUINN</td>\n",
       "      <td>DELANEY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>SHARON K.</td>\n",
       "      <td>CHRISTIE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>TERRY</td>\n",
       "      <td>TURNER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>3664.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>KHURSHID</td>\n",
       "      <td>KHOJA</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>3300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>JULI</td>\n",
       "      <td>CROCKETT</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>3000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>DOUG</td>\n",
       "      <td>LANPHERE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>2920.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>CHARLES</td>\n",
       "      <td>ROVEN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>EMILY</td>\n",
       "      <td>PAXHIA</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>PATRICK</td>\n",
       "      <td>MCMANAMON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>STEVEN</td>\n",
       "      <td>PERSKY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>STEINMETZ</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>KLEIN</td>\n",
       "      <td>SUPPORT</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>CHARLES</td>\n",
       "      <td>LOVE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>GRETCHEN</td>\n",
       "      <td>BERGMAN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>MICHELLE</td>\n",
       "      <td>WOLFF</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>MICHELLE</td>\n",
       "      <td>SEXTON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>GREG</td>\n",
       "      <td>SMITH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>MIKE</td>\n",
       "      <td>BARNETT</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>WENDY</td>\n",
       "      <td>COLTON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>ETHAN</td>\n",
       "      <td>BROOKES</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>CHRISTINE A.</td>\n",
       "      <td>PORTER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>ROGER</td>\n",
       "      <td>TOWER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>SKIP</td>\n",
       "      <td>ROACHE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>LJUBOMIR</td>\n",
       "      <td>BUTUROVIC</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>PETER</td>\n",
       "      <td>KIRSCH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>LEONARD</td>\n",
       "      <td>KAUFMANN</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>DANA</td>\n",
       "      <td>HIRSCH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>DANIEL</td>\n",
       "      <td>DODSON</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>DAVID</td>\n",
       "      <td>MURRAY</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>JOSH</td>\n",
       "      <td>KLEYMEYER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>BRIAN</td>\n",
       "      <td>MITCHELL</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>WAYNE</td>\n",
       "      <td>SCHERER</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>ROBERT</td>\n",
       "      <td>LOCKART</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>GEORGE</td>\n",
       "      <td>OKEEFE</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>SUE ANN</td>\n",
       "      <td>LORIG</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>MARK</td>\n",
       "      <td>SLABAUGH</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>SANTSCHI</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>RICH</td>\n",
       "      <td>GOLDBERG</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>MARSTON</td>\n",
       "      <td>MEDLOCK</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>STEPHANIE</td>\n",
       "      <td>WARREN-SAMARIPA</td>\n",
       "      <td>SUPPORT</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>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>DAVID</td>\n",
       "      <td>WOOD</td>\n",
       "      <td>SUPPORT</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>549 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    contributor_firstname            contributor_lastname committee_position  \\\n",
       "483                  SEAN  PARKER AND AFFILIATED ENTITIES            SUPPORT   \n",
       "482                  SEAN                          PARKER            SUPPORT   \n",
       "281                 JULIE                         SCHAUER             OPPOSE   \n",
       "108                DANIEL                           LEWIS            SUPPORT   \n",
       "194                 HENRY                   VAN AMERINGEN            SUPPORT   \n",
       "405              NICHOLAS                        PRITZKER            SUPPORT   \n",
       "421                 PETER                           THIEL            SUPPORT   \n",
       "456                 ROGER                         JENKINS            SUPPORT   \n",
       "23                 ANGELA                          HOWARD            SUPPORT   \n",
       "322              LAWRENCE                            HESS            SUPPORT   \n",
       "221                 JASON                            POST            SUPPORT   \n",
       "460              ROGER B.                         MCNAMEE            SUPPORT   \n",
       "548           ZACHARY PYM                        WILLIAMS            SUPPORT   \n",
       "239                JEREMY                         ZACHARY            SUPPORT   \n",
       "440                ROBERT                           ADAMS             OPPOSE   \n",
       "320                LAURIE                        BENENSON            SUPPORT   \n",
       "63                CAMILLA                           FIELD            SUPPORT   \n",
       "375               MICHAEL                            DEAN             OPPOSE   \n",
       "361            MARY QUINN                         DELANEY            SUPPORT   \n",
       "488             SHARON K.                        CHRISTIE            SUPPORT   \n",
       "515                 TERRY                          TURNER            SUPPORT   \n",
       "301              KHURSHID                           KHOJA            SUPPORT   \n",
       "277                  JULI                        CROCKETT            SUPPORT   \n",
       "149                  DOUG                        LANPHERE            SUPPORT   \n",
       "76                CHARLES                           ROVEN            SUPPORT   \n",
       "158                 EMILY                          PAXHIA            SUPPORT   \n",
       "414               PATRICK                       MCMANAMON            SUPPORT   \n",
       "507                STEVEN                          PERSKY            SUPPORT   \n",
       "382               MICHAEL                       STEINMETZ            SUPPORT   \n",
       "377               MICHAEL                           KLEIN            SUPPORT   \n",
       "..                    ...                             ...                ...   \n",
       "75                CHARLES                            LOVE            SUPPORT   \n",
       "191              GRETCHEN                         BERGMAN            SUPPORT   \n",
       "387              MICHELLE                           WOLFF            SUPPORT   \n",
       "385              MICHELLE                          SEXTON            SUPPORT   \n",
       "189                  GREG                           SMITH            SUPPORT   \n",
       "389                  MIKE                         BARNETT            SUPPORT   \n",
       "534                 WENDY                          COLTON            SUPPORT   \n",
       "168                 ETHAN                         BROOKES            SUPPORT   \n",
       "85           CHRISTINE A.                          PORTER            SUPPORT   \n",
       "459                 ROGER                           TOWER            SUPPORT   \n",
       "492                  SKIP                          ROACHE            SUPPORT   \n",
       "335              LJUBOMIR                       BUTUROVIC            SUPPORT   \n",
       "418                 PETER                          KIRSCH            SUPPORT   \n",
       "326               LEONARD                        KAUFMANN            SUPPORT   \n",
       "104                  DANA                          HIRSCH            SUPPORT   \n",
       "105                DANIEL                          DODSON            SUPPORT   \n",
       "125                 DAVID                          MURRAY            SUPPORT   \n",
       "272                  JOSH                       KLEYMEYER            SUPPORT   \n",
       "51                  BRIAN                        MITCHELL            SUPPORT   \n",
       "533                 WAYNE                         SCHERER            SUPPORT   \n",
       "448                ROBERT                         LOCKART            SUPPORT   \n",
       "185                GEORGE                          OKEEFE            SUPPORT   \n",
       "510               SUE ANN                           LORIG            SUPPORT   \n",
       "355                  MARK                        SLABAUGH            SUPPORT   \n",
       "540               WILLIAM                        SANTSCHI            SUPPORT   \n",
       "430                  RICH                        GOLDBERG            SUPPORT   \n",
       "358               MARSTON                         MEDLOCK            SUPPORT   \n",
       "497             STEPHANIE                 WARREN-SAMARIPA            SUPPORT   \n",
       "16             AMIRGHASEM                 SAMIMI-ARDESTAN            SUPPORT   \n",
       "136                 DAVID                            WOOD            SUPPORT   \n",
       "\n",
       "        amount  \n",
       "483  7250000.0  \n",
       "482  1500000.0  \n",
       "281  1364000.0  \n",
       "108  1250000.0  \n",
       "194  1000000.0  \n",
       "405   900000.0  \n",
       "421   300000.0  \n",
       "456    75000.0  \n",
       "23     65000.0  \n",
       "322    30000.0  \n",
       "221    10000.0  \n",
       "460    10000.0  \n",
       "548    10000.0  \n",
       "239     7500.0  \n",
       "440     6500.0  \n",
       "320     5000.0  \n",
       "63      5000.0  \n",
       "375     5000.0  \n",
       "361     5000.0  \n",
       "488     5000.0  \n",
       "515     3664.0  \n",
       "301     3300.0  \n",
       "277     3000.0  \n",
       "149     2920.0  \n",
       "76      2500.0  \n",
       "158     2500.0  \n",
       "414     2500.0  \n",
       "507     2500.0  \n",
       "382     2500.0  \n",
       "377     2500.0  \n",
       "..         ...  \n",
       "75       100.0  \n",
       "191       84.0  \n",
       "387       84.0  \n",
       "385       84.0  \n",
       "189       75.0  \n",
       "389       50.0  \n",
       "534       50.0  \n",
       "168       50.0  \n",
       "85        50.0  \n",
       "459       50.0  \n",
       "492       50.0  \n",
       "335       50.0  \n",
       "418       50.0  \n",
       "326       50.0  \n",
       "104       50.0  \n",
       "105       50.0  \n",
       "125       50.0  \n",
       "272       42.0  \n",
       "51        35.0  \n",
       "533       30.0  \n",
       "448       25.0  \n",
       "185       25.0  \n",
       "510       25.0  \n",
       "355       25.0  \n",
       "540       25.0  \n",
       "430       25.0  \n",
       "358        0.0  \n",
       "497        0.0  \n",
       "16         0.0  \n",
       "136        0.0  \n",
       "\n",
       "[549 rows x 4 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.groupby([\"contributor_firstname\", \"contributor_lastname\", \"committee_position\"]).amount.sum().reset_index().sort_values(\"amount\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "top_supporters = support.groupby([\"contributor_firstname\", \"contributor_lastname\"]).amount.sum().reset_index().sort_values(\"amount\", ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_supporters.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f722d9602d0>"
      ]
     },
     "execution_count": 31,
     "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 0x7f725877ee90>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "top_supporters.amount.plot.bar()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>contributor_firstname</th>\n",
       "      <th>contributor_lastname</th>\n",
       "      <th>amount</th>\n",
       "      <th>contributor_fullname</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",
       "      <td>SEAN PARKER AND AFFILIATED ENTITIES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>SEAN</td>\n",
       "      <td>PARKER</td>\n",
       "      <td>1500000.0</td>\n",
       "      <td>SEAN PARKER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>DANIEL</td>\n",
       "      <td>LEWIS</td>\n",
       "      <td>1250000.0</td>\n",
       "      <td>DANIEL LEWIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>HENRY</td>\n",
       "      <td>VAN AMERINGEN</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>HENRY VAN AMERINGEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>NICHOLAS</td>\n",
       "      <td>PRITZKER</td>\n",
       "      <td>900000.0</td>\n",
       "      <td>NICHOLAS PRITZKER</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",
       "\n",
       "                    contributor_fullname  \n",
       "444  SEAN PARKER AND AFFILIATED ENTITIES  \n",
       "443                          SEAN PARKER  \n",
       "102                         DANIEL LEWIS  \n",
       "180                  HENRY VAN AMERINGEN  \n",
       "374                    NICHOLAS PRITZKER  "
      ]
     },
     "execution_count": 32,
     "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 0x7f722d8a8c50>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "chart = top_supporters.amount.head(5).plot.barh()\n",
    "top_supporters[\"contributor_fullname\"] = top_supporters.contributor_firstname + \" \" + top_supporters.contributor_lastname\n",
    "top_supporters.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<matplotlib.text.Text at 0x7f722b6c4390>,\n",
       " <matplotlib.text.Text at 0x7f722b6d1c90>,\n",
       " <matplotlib.text.Text at 0x7f722b6b6950>,\n",
       " <matplotlib.text.Text at 0x7f722b644090>,\n",
       " <matplotlib.text.Text at 0x7f722b644510>]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjEAAAD8CAYAAACGhvW3AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xu0ZFV5rvHn5daKKKKgp4PEDUhADKaBPiqKSlQURLwL\ndIiCmkNM4lFRO6KYhHhiJKKBGK94VJQgoBAUMSJeYChe0AYbGpSrtAhRETyCxI6X5jt/1Nywuqh9\n7d69e+HzG6PGrpprrjm/Vbug3j3XqupUFZIkSX2z0XwXIEmSNBuGGEmS1EuGGEmS1EuGGEmS1EuG\nGEmS1EuGGEmS1EuGGEmS1EuGGEmS1EuGGEmS1EubzHcB0r3Z1ltvXWNjY/NdhiT1xsUXX3xLVW0z\nnb6GGGkOjY2NsWzZsvkuQ5J6I8kPptvX00mSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGS\nJKmXDDGSJKmXDDGSJKmXDDGSJKmX/MZeaQ6tuOk2xo767HyXMdLKYw+Y7xIkaa24EiNJknrJECNJ\nknrJECNJknrJECNJknrJECNJknrJECNJknrJENMjSSrJOzuPX5/kmHb/mCSvH9p2ZZLlSb6d5CWt\n/YIkizv9xpJc3nm8d5JvtX2vTHJEZ9sacwzV9txW3y6dto2SvCvJ5UlWtDq2H7HvBUmuSnJpkq8l\n2XlE+7eTLOrsszLJQ9vxLU/y4yQ3dR4f3Lk/frszyf4jjvl/Jbk4yVZJTkpyfWefr7c+hyf5aWu7\nMsmR0/7FSZLmhCGmX34FPD/J1pN1SvIKYF/gMVW1CHgqkKkGT/I/gI8Dr6iqXYC9gT9PMp0vFFkC\nXNh+jjsY+D3g0VW1G/A84OcT7H9oVf0R8FHguBHt7x1qB1hdVYvaMb4fOH78cVWd3rm/qO3/VeDz\nQ8f8YuB/A8+oqv/Xmpd29n18p/vpbawnAEcn2W4az4skaY4YYvrlt8CJwFSrAG8C/qKqbgeoqtur\n6qPTGP+vgJOq6pK23y3AXwNHTbZTki0YBJ6XA4d0Ni0EflRVd7bxbuwEhYl8BXjEiPZvANtO4xhG\n1fcHwN8CLx6vpbUfxODYnt6OdVqq6lbgWgbHJ0maJ4aY/nkPcGiSLUdtTPIA4P5V9f1Jxjhl/HQJ\n8B+d9kcBFw/1XdbaJ/Mc4Nyquhq4Ncmerf0TwIFtrncm2X2KcQAOBFaMaN8P+NQ09l9Dkk0ZrC69\nrqpu6Gx6OPBuBgHmx0O7Hdc5nXTKiDF/H7gPcNlM65EkrTv+swM9U1W3J/kY8Cpg1SyHObSqlsHg\nmhjgnLUsawnwL+3+ae3xxVV1Y7u+5Snt9qUkL6qqL40Y45Qkq4CVDE7vdNs3A7YAFo3Ybyr/B7ii\nqk4fav8p8DPgIOD4oW1Lq+qMEWMdnORJwC7AK6vqv0dN2K4jOgJg4wdsM4uSJUnTYYjppxOAS4CP\nDG9oIeeOJDtMsRozyneBPYFPd9r2BK6YaIckD2IQUHZLUsDGQCVZWgO/Aj4HfC7JT4DnAqNCzF3B\naridwerQccC/As+f7sEk2Qd4AbDHiM2/BJ4JfDXJzVV1jxWXEU6vqle2C6PPS3L2iFUcqupEBqf9\nWLBwp5puvZKkmfF0Ug9V1c8YnKp5+QRd3ga8p51aIskW459OmsJ7gMPHPwWU5MHAPwFvn2SfFwIn\nV9XDq2qsqrYDrgeemGSPJL/XxtoIeDTwg2nUsYaqKuBvgMd1P/00mSRbMQh5L6mqX0ww7s0MTlP9\nY5JnzKCeZcDJwKunu48kad0zxPTXO4GJPqX0PuB84Nvto8RfBe6coO9dqupHwJ8CH0xyJfB14MNV\n9ZlOtzcnuXH8xuDU0VlDQ53Z2h8CfKbVcBmDC5PfPd0DHKptFYNjXjrNXV7R5n/f0MesDx4a93rg\n2cCHkzymNR83tM9mI8b/J+ClSe4/m+ORJK29DP7IlTQXFizcqRYedsJ8lzHSymOn88l5SVq/klxc\nVYun7ulKjCRJ6ilDjCRJ6iVDjCRJ6iVDjCRJ6iVDjCRJ6iVDjCRJ6iW/sVeaQ7ttuyXL/CizJM0J\nV2IkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIk\nSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIvGWIkSVIv\nGWIkSVIvGWIkSVIvbTLfBUj3Zituuo2xoz4732VM28pjD5jvEiRp2lyJkSRJvWSIkSRJvWSIkSRJ\nvWSIkSRJvWSIkSRJvWSIkSRJvWSImUNJ7hh6fHiSd7f7xyS5Kcnyzu2BSfZJUkkO7Ox3TpJ92v0L\nklyV5NIk306yqLWfkuQvOvs8NsllSTbttP1dkrcN1bQoyfeGHleS/Yb6VZJ3dh6/Pskxkxz7p5J8\nc6jtmDbOIzptr2lti9vjlUlWdJ6Td7X2k5Jc39ouTfLUzhgXDO1/ZmfbC5Oc1Hm8X5JvJbmyjXV6\nkt8fMcfyJF/v/N7uTPLozjiXJxmb6PglSXPPEDO/jq+qRZ3bz1v7jcDRk+x3aFX9EfBe4LjW9lpg\naZJtkmwEvBv4y6r6TWe/U4GDh8Y6pLWPWwJc2H52/Qp4fpKtpzqoJA8E9gS2TLLD0OYVbc5xLwKu\nGOrzx53n5FWd9qVVtQh4DfD+SUrYM8muI+r6Q+BfgcOqapc21inA2PAc7fb4TvtUvxNJ0npmiNkw\nXQrclmTfKfp9A9gWoKp+ArwDeDvwCuCyqrqw27mqrgb+X5LHdpoPooWYJGEQKg4H9k1yn06/3wIn\nAkdOo/7nA58BTmPNwALwKeA5bb4dgduAW6YxZtddxz2BdzI6cLwB+MequmvlqarOrqqvTGPOc4BH\nJdl5RpVKkuaMIWZu3bd7ugh4y9D2Izvbzx/a9lbgzVOMvx+DUDDu/cCuwFLgryfY51RasEjyOOBn\nVXVN2/Z44Pqqug64ABj++tb3AIcm2XKKupa0eU7lnis6twM/bKsihwCnj9j//M7zMio0DR/3sE8A\ne3RPWzWPAi6ZovbjOnOf0mm/k0FAfNMU+0uS1hP/2YG5taqdsgAG11YAizvbj6+qd4zasaq+koQk\ne4/YfEqSzYAtgEWdfe5M8gFgcVXdOkFNpwNfT/I6Rp9KOq3dPw14CXDX9SVVdXuSjwGvAlaNGjzJ\nQ4GdgAurqpL8JskfVtXlnW7jKzTPAJ4KvHRomD+uqlGrM8cl+UfgYcBeExwfwGoGp9neCHxugjof\nDHwJ2Bw4sfN7WFpVZ0ww7seBo5NsP8ncJDkCOAJg4wdsM1lXSdJacCVmwzbRasyhwA7ARxlc49F1\nZ7uNVFU/BK4Hngy8gLYSkmTj9vhvk6xs4+6X5P5DQ5wAvBy43wRTHARsBVzfxhnjnqsx5wAvBm6o\nqtsnqnWEpVX1BwxOC314ir4nA08Ctuu0XQHsAVBVt7aAeSKDMDilqvotg1NVb5ii34lVtbiqFm+8\n+VSLVpKk2TLEbMCq6jwGgeDRI7YV8DfA45LsMsOhTwWOB75fVTe2tqcyuI5mu6oaq6qHM1iFed7Q\nvD9jcLrm5ROMvQTYr40xxuAC3zWui6mqXzIIAm+dYd3j3g1slOQZE3VoFzQfz5rX8LydwUrKIztt\nm89w7pOApwEusUjSPDPEzK/uNTHLJ/jI7ltZczXhLlW1isHKwNIZzvtJBteHDJ9KOmuo35nccxWF\nNuc9PqXU6n84cNdHq6vqegYXKXcvJqaqTquqia5P6V4T87HhjS3A/QMTX/cz7kN0TplW1Qrg1cDH\n2sfUvwY8ksFponHHDf1ONhua+9fAu4CHTDG3JGmOZfB+IGkuLFi4Uy087IT5LmPaVh47fC23JK1f\nSS6uqsVT93QlRpIk9ZQhRpIk9ZIhRpIk9ZIhRpIk9ZIhRpIk9ZLf2CvNod223ZJlfuJHkuaEKzGS\nJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmX\nDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGS\nJKmXDDGSJKmXNpnvAqR7sxU33cbYUZ+d7zLmxMpjD5jvEiT9jnMlRpIk9ZIhRpIk9ZIhRpIk9ZIh\nRpIk9ZIhRpIk9ZIhRpIk9ZIhRtOWZHWS5UmuSHJpktcl2WiozwlJbuq2Jzk8yZ1JHt1puzzJWLu/\nMsnWQ3OM345q7RckWTxJbWNJLh/RflKS6zvjfT0DtyTZqvVZmKSS7N3Z76dJHpzkmCSvb22PS3JR\nG+d7SY6Z1RMpSVon/J4YzcSqqloEkOQhwMeBBwB/19o2Ap4H/BB4MnB+Z98bgaOBg6c7xzq0tKrO\n6DYk+SawF/AfwOOB77SfFybZGbi1qm5N0t3to8BBVXVpko2BnddxnZKkGXAlRrNSVTcDRwCvzN3v\n9PsAVwDvA5YM7XIO8KgWEDYEX2cQWmg/j2cQasYff23EPg8BfgRQVaur6rtzXaQkaWKGGM1aVX0f\n2JjBmzsMgsupwFnAAUk27XS/E3g78KYphr3v0OmkqVZupuO4znintLavcXeIeUyrebv2+PEMQs6w\n44GrkpyV5M+T3Gcd1CZJmiVDjNaJJJsBzwQ+VVW3AxcBzxjq9nHgcUm2n2SoVVW1qHM7fR2Ut7Qz\n3qGt7dvA7knuB2xaVXcA30/yCCZYiamqtwCLgfOAPwHOHTVZkiOSLEuybPUvb1sH5UuSRvGaGM1a\nkh2A1cDNwLOABwIr2tmlzYFVDE4jAVBVv03yTuAN67/aNVXVL5NcA7wMuKQ1f5NBEHsIcNUE+10H\nvC/JB4GfJnlwVd061OdE4ESABQt3qjk6BEn6nedKjGYlyTbA+4F3V1UxOJX0Z1U1VlVjwPbAvkk2\nH9r1JOBpwDbrsdyJfB14DfCN9vgbwKuBb7ZjWkOSAzrX/+zEIMD9fH0UKkm6J0OMZmL8epUrgC8y\nOK3y9y2o7Afc9c81V9V/ARcCB3YHqKpfA+/i7utoJppj/HZsZ9tnk9zYbp8cse/One03JnlRaz9u\naMzNWvvXgB24O8RcAjyM0dfDALyYwTUxy4GTgUOravUEfSVJcywj/uCUtI4sWLhTLTzshPkuY06s\nPPaA+S5B0r1QkourasLvBetyJUaSJPWSIUaSJPWSIUaSJPWSIUaSJPWSIUaSJPWSIUaSJPWS39gr\nzaHdtt2SZX4UWZLmhCsxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwx\nkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSp\nlwwxkiSplwwxkiSplwwxkiSplwwxkiSplzaZ7wKke7MVN93G2FGfne8y5t3KYw+Y7xIk3Qu5EiNJ\nknrJECNJknrJECNJknrJECNJknrJECNJknrJECNJknrJEKMZSXJ0kiuSXJZkeZLHtvYLklzV2pYn\nOWNov+VJThtqOynJTUkWtMdbJ1k5wbyr2xiXJ/lkks07256bpJLs0mkbS7Kq7fPdJB9Lsmnbtk+S\nczp9/yHJuUkWTHQcSY5ptY6Pt2Stn0xJ0loxxGjakuwFPAvYo6oeDTwN+GGny6FVtajdXtjZ75HA\nxsATk9xvaNjVwMumMf2qNu4fAr8GXtHZtgS4sP3suq6qFgG7AQ8DDhpxTG8GngA8r6p+NdlxAMe3\n8Z4DfGA8FEmS5ochRjOxELhl/M2+qm6pqv+cxn5LgJOB8xgEgK4TgCOTzOSLF78KPAIgyRbA3sDL\ngUNGda6q1cC3gG277UleB+wPHFhVq6Y7eVVdA/wS2GoGNUuS1jFDjGbiPGC7JFcneW+SJw9tP6Vz\nGua4TvvBwGnAqdxzteQGBqsoL55OAS3s7A+saE3PAc6tqquBW5PsOWKf+wCPBc7tND+BwWrO/lV1\nxzSPY3y8PYBrqurm6dQsSZobhhhNW3uz3xM4AvgpcHqSwztduqdhlgIkWcxg9eYG4EvA7kkeNDT0\n24ClTP56vG+S5cAyBsHnQ619CYOARPvZDUk7tn1+Avyoqi7rbLsWCLDviLnucRzNkUmuAC4C3jpR\noUmOSLIsybLVv7xtkkOSJK0N/+0kzUg7NXMBcEGSFcBhwEmT7LIE2KVzwe4DgBcAH+yMeU0LG/e4\nZqVjVbse5S4tDD0F2C1JMbjuppKMB4/rqmpRkq2BryV5dlWd3bb9BDgU+FKSn1XV+VMcOgyuiXlH\nkmcDH0qyY1X993CnqjoROBFgwcKdahrjSpJmwZUYTVuSnZPs1GlaBPxgkv4bMQgmu1XVWFWNMTj9\nM+qTPW8FXj/Dkl4InFxVD2/jbwdcDzyx26mqbgGOAt441H418Hzg35KsEZAm04LQMgYBTpI0Twwx\nmoktgI+2jxhfBuwKHNPZ3r2W5IsMwsRNQxf/fgXYNcnC7sBVdQVwyQzrWQKcNdR2JqND0qeAzZMM\nB5xvAy8Fzk6y4wTHMcpbgNe2oCZJmgepcrVbmisLFu5UCw87Yb7LmHcrjz1gvkuQ1BNJLq6qxdPp\n61+RkiSplwwxkiSplwwxkiSplwwxkiSplwwxkiSpl/yyO2kO7bbtlizzkzmSNCdciZEkSb1kiJEk\nSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1k\niJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEkSb1kiJEk\nSb20yXwXIN2brbjpNsaO+ux8lyFJ683KYw9Yb3O5EiNJknrJECNJknrJECNJknrJECNJknrJECNJ\nknrJECNJknppyhCT5OgkVyS5LMnyJI9t7Rckuaq1LU9yxtB+y5OcNtR2UpKbkixoj7dOsnKCeVe3\nMS5P8skkm3e2PTdJJdml0zaWZFXb57tJPpZk07ZtnyTndPr+Q5JzkyyY6DiSHNNqHR9vyRTP04yO\nt1Pvd5J8L8m3khw+xRwntPE26rQdnuSnnfo/1pn7+k77q1r7yiRbt/t3jJjjmCSv7zzepI1/bKft\nrDbmtUlu68zx+Gk+n9ck+fcku05wnMO1f71zrHcmeXSn7+Xtubyo9b1h6PkYa8f80E7bjzu1LE+y\n2fhzMfQ6Gr+9pG17WZIVGfy3cHmS50z2+5Ikza1JvycmyV7As4A9qupX7c1vs06XQ6tq2Yj9Hgls\nDDwxyf2q6r86m1cDLwPeN0Vtq6pqURvvFOAVwD+3bUuAC9vPv+vsc11VLUqyMfAF4CDglKHa3gw8\nAXhmO6YJjwM4vqrekWQn4OIkZ1TVb9bh8V5XVbu3MXYA/j1JquojI+bYCHge8EPgycD5nc2nV9Ur\nR4y/tKrOGNE+E/sCVwMvSvLGGnheq2kf4PVV9axOnTDF89n6HQx8OcluVfXTGdR+I3A0cHC3sarG\nw/XhwOLu89FqWt15PR0D3DFeS6fPuOvG+3a2P6zNu0dV3ZZkC2CbEfVJktaTqVZiFgK3VNWvAKrq\nlqr6z2mMuwQ4GTgPGP5r9QTgyCQz+aK9rwKPAGhvHnsDLwcOGdW5qlYD3wK27bYneR2wP3BgVa2a\n7uRVdQ3wS2CrCbqs9fFW1feB1wKvmqDLPsAVDMLQpKtC69gS4F+AG4C91tWgVXU6g+frT2a46znA\no5LsvK5qmaaHAL8A7gCoqjuq6vr1XIMkqWOqEHMesF2Sq5O8N8mTh7af0llyP67TfjBwGnAq93zD\nvYHBKsqLp1Nge/PfH1jRmp4DnFtVVwO3JtlzxD73AR4LnNtpfgKD1Zz9q2r4NMpExzE+3h7ANVV1\n8wRlrqvjvQTYZYJtS9r4ZwEHpJ0qG5+/U/9LO+3Hddp3m8b8a2jP49OAzzD62CYy6fPZMdnxdmvv\nrqbdCbwdeNM0a5mNHYdOJz0RuBT4CXB9ko8kOXAO55ckTcNUqwN3tJDwROCPgdOTHFVVJ7Uu9zht\nkGQxg9WbG5LcBHw4yYOq6medbm8DPg1M9n3s902yvN3/KvChdn98ZQAGwWEJcHF7vGPbZ3vgs1V1\nWWe8axmspOwLnDk010SnP45soeAPgJFvWuvweAEysjHZDHgm8Nqq+kWSi4BnMFiVgLk7nfQs4Pyq\nWpXkTOBvkrymrXRNZqLnc9jI420mq/3jwNFJtp/GHLNxj9NJAEn2A/4n8FTg+CR7VtUxI/odARwB\nsPEDPOMkSXNlylM67Q3rAuCCJCuAw4CTJtllCbBL7r5g9wHAC4APdsa8poWNgyYZZ9XwG0mSBwFP\nAXZLUgyuQ6kkS1uX8Wtitga+luTZVXV22/YT4FDgS0l+VlXda0omMn5NzLOBDyXZsar+e46OF2B3\n4Hsj2p8BPBBY0a7d2BxYxd0hZq4sAfbuHNuDGTz/X1hH4+8OTCfsrKGqfpvkncAb1lEd0523GJym\n/FaSLwAfAY4Z0e9E4ESABQt3qvVZoyT9Lpn0dFKSndtFreMWAT+YpP9GDN6od6uqsaoaY3D6Z9Rp\niLcCrx/RPpkXAidX1cPb+NsB1zNYKbpLVd0CHAW8caj9auD5wL8lucdf2hNpQWgZgwB3l3V5vEnG\ngHcA/zpi8xLgzzpzbA/sm84ntta1JA9g8Lz+fmfev2IdXY+T5AXA0xmcppqNkxic6lovSx1Jfq+d\nVhw36X8LkqS5N9U1MVsAH83gI8aXAbuy5l+e3WsfvsjgTe+moYt/vwLsmmRhd+CquoLBNREzsYTB\nNSFdZzL6jfVTwObteobuvN8GXgqcnWTHCY5jlLcAr03n482s/fHumPYRa+ATwLuGP5nUgsp+dE5F\ntU8/XcgEp7hmYPMkN3Zur+1sex7w5fGLuptPAwemfWR8EhM9n0e2tmuAPwWeMsEnk2DNa2KWt1Nq\nd6mqXwPvYnDB7bo2fE3Mq4BNgXckubKtqh0MvHoO5pYkTVMGK+SS5sKChTvVwsNOmO8yJGm9WXns\nAWu1f5KLq2rxdPr6jb2SJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXZvKPMEqaod22\n3ZJla/lxQ0nSaK7ESJKkXjLESJKkXjLESJKkXjLESJKkXjLESJKkXjLESJKkXjLESJKkXjLESJKk\nXjLESJKkXjLESJKkXkpVzXcN0r1Wkl8AV813HTOwNXDLfBcxA9Y7d/pUK1jvXFuf9T68qraZTkf/\n7SRpbl1VVYvnu4jpSrLMeudOn+rtU61gvXNtQ63X00mSJKmXDDGSJKmXDDHS3DpxvguYIeudW32q\nt0+1gvXOtQ2yXi/slSRJveRKjCRJ6iVDjDQHkuyX5Kok1yY5ao7m+HCSm5Nc3ml7UJIvJLmm/dyq\ntSfJu1o9lyXZo7PPYa3/NUkO67TvmWRF2+ddSbIWc2yX5Pwk301yRZJXb+D13ifJt5Jc2ur9+9a+\nfZKL2j6nJ9mstS9oj69t28c6Y72xtV+V5Bmd9pGvkdnM0dl34yTfSXLOhl5vkpXt97U8ybIN+fXQ\ntj8wyRlJrkzyvSR7baj1Jtm5Pa/jt9uTvGZDrXetVJU3b97W4Q3YGLgO2AHYDLgU2HUO5nkSsAdw\neaft7cBR7f5RwD+1+88EPgcEeBxwUWt/EPD99nOrdn+rtu1brW/avvvPZo62bSGwR7t/f+BqYNcN\nuN4AW7T7mwIXtT6fAA5p7e8H/qLd/0vg/e3+IcDp7f6u7fe/ANi+vS42nuw1MtM5hl4TrwU+Dpwz\nm7HWZ73ASmDrobYN8vXQtn8U+LN2fzPggRtyvUP/P/ox8PA+1Dvj/w+u6/+xevP2u34D9gI+33n8\nRuCNczTXGGuGmKuAhe3+QgbfUwPwAWDJcD9gCfCBTvsHWttC4MpO+139ZjrHBHV/Gti3D/UCmwOX\nAI9l8GVfmwz/noHPA3u1+5u0fhn+3Y/3m+g10vaZ0RydMR4GfAl4CnDObMZaz/Wu5J4hZoN8PQBb\nAtd369+Q6x2q8enA1/pS70xvnk6S1r1tgR92Ht/Y2taHh1bVj9r9HwMPnaKmydpvHNE+mznW0E4r\n7M5gdWODrTeDUzPLgZuBLzBYifh5Vf12RP+7xmrbbwMePIvjePAs5hh3AvDXwJ3t8WzGWp/1FnBe\nkouTHNHaNtTXw/bAT4GPZHC67v8mud8GXG/XIcCpsxxrPuqdEUOMdC9Vgz93akOaI8kWwJnAa6rq\n9rUZazZmMkdVra6qRQxWOB4D7DKXta2NJM8Cbq6qi+e7lhnYu6r2APYH/irJk7obN7DXwyYMTt2+\nr6p2B/6LwamS2Yw1a7P4720z4NnAJ9d2rNlYH3MYYqR17yZgu87jh7W29eEnSRYCtJ83T1HTZO0P\nG9E+mzlofTdlEGBOqap/39DrHVdVPwfOZ3Cq5IFJNhnR/66x2vYtgVtncRy3zmIOgCcAz06yEjiN\nwSmlf9mA66Wqbmo/bwbOYhAUN9TXw43AjVV1UXt8BoNQs6HWO25/4JKq+sksx1rv/73NlCFGWve+\nDeyUwac2NmOwnHv2epr7bOCwdv8wBteejLe/pH1C4HHAbW3J9/PA05Ns1T5F8HQG1zT8CLg9yePa\npw5eMjTWTOagjfEh4HtV9c89qHebJA9s9+/L4Pqd7zEIMy+cYKzxOV4IfLn9FXo2cEgGn9TZHtiJ\nwQWRI18jbZ+ZzkFVvbGqHlZVY22sL1fVoRtqvUnul+T+4/cZ/B4vn8Xvar28Hqrqx8APk+zc+j4V\n+O6GWm/HEu4+lTSbsdZ3vTO3thfVePPm7Z43BlfiX83gOoqj52iOU4EfAb9h8Jfiyxlcc/Al4Brg\ni8CDWt8A72n1rAAWd8Z5GXBtu720076YwRvLdcC7ufvLMWczx94MlpUvA5a32zM34HofDXyn1Xs5\n8LetfQcGb+rXMliiX9Da79MeX9u279AZ6+g2x1W0T3BM9hqZzRxDr4t9uPvTSRtkvW2fS9vtivHx\nNtTXQ9vvt4vRAAAAWElEQVS+CFjWXhOfYvBpnQ253vsxWPnastO2wdY725vf2CtJknrJ00mSJKmX\nDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmXDDGSJKmX/j8j0mPoR506CAAAAABJ\nRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f722d952450>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "chart = top_supporters.amount.head(5).plot.barh()\n",
    "chart.set_yticklabels(top_supporters.contributor_fullname)"
   ]
  }
 ],
 "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}