datapacpkl_to_csv.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from leaper import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1089, 10)\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\birdm\\Anaconda2\\lib\\site-packages\\ipykernel_launcher.py:5: DtypeWarning: Columns (23,33,34) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  \"\"\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(60845, 12)\n",
      "(58365, 12)\n",
      "(58365, 12)\n",
      "1550365339.03\n",
      "58365\n",
      "Meow\n",
      "216.881999969\n",
      "19278\n",
      "Make manual corrections\n",
      "Converting data_ie.all_candidates.keys() to match data_pac.all_candidates.keys()\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "leaper.py:850: FutureWarning: from_items is deprecated. Please use DataFrame.from_dict(dict(items), ...) instead. DataFrame.from_dict(OrderedDict(items)) may be used to preserve the key order.\n",
      "  cand_change = pd.DataFrame.from_items([('oldnames', oldname), ('newnames', newname)])\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Finding matches between data_ie.all_donors.keys() and data_pac.all_donors.keys()\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "leaper.py:870: FutureWarning: from_items is deprecated. Please use DataFrame.from_dict(dict(items), ...) instead. DataFrame.from_dict(OrderedDict(items)) may be used to preserve the key order.\n",
      "  donor_change = pd.DataFrame.from_items([('oldnames', oldname), ('newnames', newname)])\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SULLIVAN PATRICK J\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\birdm\\Anaconda2\\lib\\site-packages\\pandas\\core\\indexing.py:189: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  self._setitem_with_indexer(indexer, value)\n",
      "C:\\Users\\birdm\\Anaconda2\\lib\\site-packages\\pandas\\core\\frame.py:6211: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n",
      "of pandas will change to not sort by default.\n",
      "\n",
      "To accept the future behavior, pass 'sort=False'.\n",
      "\n",
      "To retain the current behavior and silence the warning, pass 'sort=True'.\n",
      "\n",
      "  sort=sort)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "VAN WERVEN LUANNE E\n",
      "PEDERSEN JAMIE D\n",
      "HARRISON NOAH F\n",
      "No Match - skipped:\n",
      "DALZELL JUELIE B\n",
      "-0.0\n",
      "FRANCIK REBECCA A\n",
      "STANFORD DEREK C\n",
      "FRENCH ALFRED G II\n",
      "SALDANA REBECCA J\n",
      "BROWN STEVE D\n",
      "GOEHNER KEITH W\n",
      "PEACH WILLIAM W\n",
      "PELLICCIOTTI MICHAEL J\n",
      "VICK BRANDON P\n",
      "TAYLOR DAVID V\n",
      "TOM RODNEY\n",
      "WALSH JAMES W\n",
      "GOULET JENNIFER D\n",
      "KRETZ JOEL A\n",
      "GRAVES PAUL S\n",
      "FAIN JOSEPH F\n",
      "HARRIS TANISHA L\n",
      "KILDUFF CHRISTINE J\n",
      "STANFORD JOY\n",
      "MAGENDANZ CHAD L\n",
      "KUNEY MARY L\n",
      "PARIS PATRICIA A\n",
      "WALEN AMY D\n",
      "RAMOS BILL G\n",
      "MILOSCIA MARK A\n",
      "GRAHAM VIRGINIA C\n",
      "RADZIMSKI LECH J\n",
      "No Match - skipped:\n",
      "KRISTIANSON  LARRY M\n",
      "669.0\n",
      "SLATTER VANDANA\n",
      "BLAKE WALTER (BUD) T\n",
      "PADULA ELIZABETH A\n",
      "No Match - skipped:\n",
      "III BRANCHES LAW\n",
      "500.0\n",
      "SAWYER DAVID J\n",
      "MCMULLEN SCOTT T\n",
      "MAYCUMBER JACQUELIN M\n",
      "CHOPP FRANK V\n",
      "SHORT SHELLY A\n",
      "VOLZ JAMES M\n",
      "NGUYEN JOSEPH-THANH T\n",
      "GONZALEZ STEVEN C\n",
      "DAVIS LAUREN\n",
      "STONIER MONICA J\n",
      "FITZGERALD TIMOTHY W\n",
      "GILLESPIE KATHY E\n",
      "WOLFE REBECCA J\n",
      "ANDERSON MARCINE S\n",
      "GILDON CHRIS\n",
      "ERICKSEN DOUGLAS J\n",
      "THARINGER STEPHEN P\n",
      "MCCLENDON MARTIN V\n",
      "DOLAN LAURIE H\n",
      "KOCHMAR LINDA L\n",
      "ORTIZ-SELF LILLIAN\n",
      "WILSON DAVID J\n",
      "OOSTERMAN LINDA L\n",
      "BALLEW TIMOTHY J II\n",
      "DETRO JAMES G\n",
      "HASKELL LAWRENCE H\n",
      "LUCAS DAVID\n",
      "ORMSBY TIMM S\n",
      "BROTHERTON GREGORY A\n",
      "No Match - skipped:\n",
      "HUNTER RAYMOND\n",
      "-70.0\n",
      "SENN TANA D\n",
      "MAROON EVERETT\n",
      "BENTLEY-FEINBERG SASHA ROSE L\n",
      "DHINGRA MANKA\n",
      "BRADDOCK SHANNON\n",
      "MACEWEN DREW C\n",
      "MENA VICTORIA\n",
      "ROULSTONE DOUGLAS R\n",
      "WALKER MINDY L\n",
      "No Match - skipped:\n",
      "DALZELL JUELIE B\n",
      "984.38\n",
      "QUIRING EILEEN J\n",
      "LOVICK JOHNNY R\n",
      "GRIFFEY DANIEL G\n",
      "SHELDON TIMOTHY M\n",
      "BOSS RANDY\n",
      "SMALL SHON R\n",
      "HAYES DAVID J\n",
      "CHAMBERS KELLY M\n",
      "MORGAN MELANIE V\n",
      "COOPER ANGELA J\n",
      "POLLET GERALD M\n",
      "HOBBS STEVEN R\n",
      "ENTENMAN DEBRA J\n",
      "KLOBA SHELLEY A\n",
      "SMITH JAMIE L\n",
      "YOUNG JESSE L\n",
      "SHUMWAY LINDSEY E\n",
      "WILKE JODI M\n",
      "BOWLING IRENE R\n",
      "CALDIER MICHELLE D\n",
      "WEIKER WENDY L\n",
      "REEVES KRISTINE M\n",
      "DUTHIE BRIAN S\n",
      "HOLY JEFFREY M\n",
      "WILSON CLAIRE E\n",
      "WITTING NED W\n",
      "FITZPATRICK CONSTANCE M\n",
      "PONOMARCHUK LEONID\n",
      "VALDEZ JAVIER\n",
      "LEKANOFF DEBRA E\n",
      "CHRISTOPHER DWAYNE L\n",
      "No Match - skipped:\n",
      "III BRANCHES LAW\n",
      "500.0\n",
      "HAYDEN RANDOLPH J\n",
      "RICCELLI MARCUS M\n",
      "WAGONER KEITH L\n",
      "FRASIER ERIN M\n",
      "MURI RICHARD W\n",
      "PETERSON STROM H\n",
      "LEWIS JESSA\n",
      "HARMSWORTH MARK J\n",
      "CHRISTIAN LEONARD G\n",
      "MURANO KAY E\n",
      "SCHMICK JOSEPH S\n",
      "MACRI NICOLE\n",
      "FERRERIA IMMACULATE\n",
      "TRASK SHARON K\n",
      "VARGAS PINKY T\n",
      "BREWER TERRY L\n",
      "MANWELLER MATHEW S\n",
      "KEISER KAREN L\n",
      "SMITH NORMA C\n",
      "HAMMOND SYLVIA\n",
      "ROBNETT MARY E\n",
      "No Match - skipped:\n",
      "III BRANCHES LAW\n",
      "10005.0\n",
      "NOLE JOE\n",
      "No Match - skipped:\n",
      "HUNTER RAYMOND\n",
      "-70.0\n",
      "BUYS VINCENT K\n",
      "KONIS THOMAS F\n",
      "FROCKT DAVID S\n",
      "CUMMINGS TED F\n",
      "ROLLINS MARY F\n",
      "HOFF LARRY A\n",
      "FOSTER JEFFREY B\n",
      "MCENTIRE JAMES F\n",
      "KUDERER PATRICIA E\n",
      "HARDY KAREN L\n",
      "THAI MY-LINH T\n",
      "NOMA ARIAN E\n",
      "LOGAN SIDNEY M\n",
      "MCCOY JOHN R\n",
      "KRAFT VICKI C\n",
      "MENSER SAMUEL T\n",
      "RUDE SKYLER D\n",
      "CAMPAGNA JOSEPH A\n",
      "CALLAN LISA M\n",
      "SALOMON JESSE M\n",
      "DIAMOND ANN\n",
      "SHEERAN JOHN M\n",
      "No Match - skipped:\n",
      "COMMITTEE FOR JUDICIAL READINESS\n",
      "-9293.43\n",
      "HALVORSON ERIC\n",
      "PAUL DAVID M\n",
      "MEAD JARED M\n",
      "KRUGER LEAVITT MARI L\n",
      "DAS MONA\n",
      "WILLIAMS KARL L\n",
      "No Match - skipped:\n",
      "III BRANCHES LAW\n",
      "500.0\n",
      "HARGROVE MARK D\n",
      "KNEZOVICH OZZIE D\n",
      "CHASE MARALYN\n",
      "No Match - skipped:\n",
      "FRIENDS OF ELAINE PHELPS\n",
      "5000.0\n",
      "SHEWMAKE SHARON A\n",
      "STEELE MICHEAL A\n",
      "BLAKE BRIAN E\n",
      "STEWART JEANNE E\n",
      "RANDALL EMILY E\n",
      "WA REALTORS PAC\n",
      "ASSN OF WA BUSINESS PAC\n",
      "CIT FOR BETTER SCHOOLS BATTLE GROUND\n",
      "CIT TO RECALL PEPPER\n",
      "CIVIC ALLIANCE FOR A SOUND ECONOMY SPONSORED BY THE SEATTLE CHAMBER\n",
      "ENTERPRISE WASHINGTON\n",
      "resolve_donations: Recursion loop, ignoring donation to self by ENTERPRISE WASHINGTON\n",
      "MAINSTREAM REPUB OF WA ST PAC\n",
      "THURSTON CO REPUB CENT COMM NON EXEMPT\n",
      "HARRY TRUMAN FUND\n",
      "AB PAC\n",
      "CLARK CO DEMO CENT COMM EXEMPT\n",
      "LM PAC\n",
      "LOCAL DEMOCRATIC ORGS\n",
      "COWLITZ CO DEMO CENT COMM NON EXEMPT\n",
      "FOR 940\n",
      "FAMILIES YES\n",
      "KING CO DEMO CENT COMM NON EXEMPT\n",
      "KITSAP CO DEMO CENT COMM NON EXEMPT\n",
      "LAKE WA CIT LEVY COMM\n",
      "resolve_donations: Recursion loop, ignoring donation to self by LOCAL DEMOCRATIC ORGS\n",
      "MASON CO DEMO CENT COMM NON EXEMPT\n",
      "PIERCE CO DEMO CENT COMM NON EXEMPT\n",
      "RIVERVIEW SCHOOLS COMM\n",
      "SNOHOMISH COUNTY DEMOCRATS\n",
      "EVERETT DISTRICTS NOW\n",
      "resolve_donations: Recursion loop, ignoring donation to self by EVERETT DISTRICTS NOW\n",
      "resolve_donations: Recursion loop from LOCAL DEMOCRATIC ORGS to SOUTH KING COUNTY DEMOCRATS\n",
      "From: 30.02  To: 100.0\n",
      "SOUTH KITSAP SCHOOL SUPPORTERS\n",
      "SPOKANE CO DEMO CENT COMM NON EXEMPT\n",
      "STAND UP FOR PENINSULA SCHOOLS\n",
      "resolve_donations: Recursion loop from LOCAL DEMOCRATIC ORGS to WA STATE DEMOCRATIC PARTY\n",
      "From: 4328.49  To: 1354.8600000000001\n",
      "WA STATE DEMOCRATIC PARTY\n",
      "CLARK CO DEMO CENT COMM NON EXEMPT\n",
      "ISLANDERS YES\n",
      "NEIGHBORS FOR BELLINGHAM HOME FUND\n",
      "SPOKANE CO DEMO CENT COMM EXEMPT\n",
      "TACOMA CIT FOR SCHOOLS\n",
      "THE FIRST AMERICAN PROJECT\n",
      "YES FOR HOMES COALITION OF SAN JUAN CO\n",
      "YES LIBRARIES PIERCE\n",
      "MAINSTREAM VOTERS OF WA\n",
      "ENOUGH IS ENOUGH PAC\n",
      "NATL WOMENS POLITICAL CAUCUS OF WA CAMP FUND\n",
      "NEW DIRECTION PAC\n",
      "CHILDRENS CAMPAIGN FUND\n",
      "EASTSIDE LEADERSHIP COUNCIL\n",
      "OURVOTESCOUNT\n",
      "resolve_donations: Recursion loop from NEW DIRECTION PAC to SEIU 775\n",
      "From: 2898.17  To: 102898.17\n",
      "SOUTH SOUND WOMENS LEADERSHIP PAC\n",
      "SOUTHWEST WA PRIORITIES\n",
      "SPOKANE LEADERSHIP COUNCIL\n",
      "resolve_donations: Recursion loop from NEW DIRECTION PAC to WASHINGTON CONSERVATION VOTERS\n",
      "From: 756.0  To: 100000.0\n",
      "WASHINGTON WORKS PAC\n",
      "WASHINGTON WORKS FOR US PAC\n",
      "SOUTH KING COUNTY DESERVES BETTER\n",
      "SUSTAINABLE FUTURE PAC\n",
      "WIN WITH WOMEN\n",
      "WASHINGTON VALUES PAC\n",
      "WASHINGTON SENATE DEMOCRATIC CAMPAIGN\n",
      "WHATCOM DEMOCRATS\n",
      "FOR 1631\n",
      "FOR 1639\n",
      "WA ST FEDERATION OF DEMO WOMEN\n",
      "resolve_donations: Recursion loop, ignoring donation to self by WHATCOM DEMOCRATS\n",
      "KENNEDY FUND\n",
      "ISLAND PAC\n",
      "REAGAN FUND\n",
      "CONCERNED TAXPAYERS OF WASHINGTON STATE\n",
      "EVERGREEN PROGRESS\n",
      "KING COUNTY REPUBLICAN PARTY\n",
      "resolve_donations: Recursion loop, ignoring donation to self by KING COUNTY REPUBLICAN PARTY\n",
      "QUALITY COMMUNITIES COMM (REAGAN FUND)\n",
      "SNOHOMISH COUNTY REPUBLICAN PARTY\n",
      "AGAINST 940\n",
      "AGAINST 1631\n",
      "LOCAL REPUBLICAN ORGS\n",
      "resolve_donations: Recursion loop, ignoring donation to self by LOCAL REPUBLICAN ORGS\n",
      "PIERCE CO REPUB CENT COMM NON EXEMPT\n",
      "TRUTH FOR WA SPONSOR WORKING FAMILIES OF KING CO\n",
      "resolve_donations: Recursion loop from LOCAL REPUBLICAN ORGS to WHATCOM REPUBLICANS\n",
      "From: 11630.0  To: 4000.0\n",
      "WHATCOM REPUBLICANS\n",
      "AGAINST 1639\n",
      "resolve_donations: Recursion loop, ignoring donation to self by WHATCOM REPUBLICANS\n",
      "WORKING FAMILIES OF KING CO\n",
      "resolve_donations: Recursion loop from SNOHOMISH COUNTY REPUBLICAN PARTY to WA STATE REPUBLICAN PARTY\n",
      "From: 5000.0  To: 1650.0\n",
      "WA STATE REPUBLICAN PARTY\n",
      "SPOKANE CO REPUB CENT COMM NON EXEMPT\n",
      "STEVENS CO REPUB CENT COMM NON EXEMPT\n",
      "STEVENS COUNTY REPUBLICAN CENTRAL COMMITTEE EXEMPT ACCOUNT\n",
      "TACOMA-PIERCE CO BUSINESS ALLIANCE PAC\n",
      "resolve_donations: Recursion loop, ignoring donation to self by WA REALTORS PAC\n",
      "COCA COLA NORTH AMERICA\n",
      "FOR 1634\n",
      "PEPSI COLA NW BUSINESS UNIT\n",
      "WASHINGTON BEVERAGE ASSOCIATION\n",
      "THE LEADERSHIP COUNCIL\n",
      "WA FORWARD (THE LEADERSHIP COUNCIL)\n",
      "DR PEPPER SNAPPLE GROUP\n",
      "WA HOSPITALITY ASSOCIATION\n",
      "HOUSE DEMOCRATIC CAUCUS CAMPAIGN COMMITTEE\n",
      "RETIRED PUBLIC EMPLOYEES COUNCIL OF WA\n",
      "HOUSE REPUBLICAN ORGANIZATION COMMITTEE\n",
      "CHELAN CO REPUB CENT COMM\n",
      "SEATTLE HOSPITALITY FOR PROGRESS\n",
      "SENATE REPUBLICAN CAMPAIGN COMMITTEE\n",
      "ANHEUSER BUSCH CO.\n",
      "BOEING COMPANY\n",
      "BOEING EMPLOYEES CREDIT UNION\n",
      "ANDEAVOR\n",
      "PHILLIPS 66\n",
      "AMERICAN FUEL AND PETROCHEMICAL MANUFACTURERS\n",
      "BP AMERICA\n",
      "BP AMERICA EMPLOYEE PAC\n",
      "WEYERHAEUSER CO\n",
      "WA FOREST PROTECTION ASSN ST PAC\n",
      "WA SELF INSURERS ASSN LEG FUND\n",
      "KOCH INDUSTRIES, INC.\n",
      "WASHINGTON EDUCATION ASSOCIATION\n",
      "CIT COMM FOR ARLINGTON SCHOOL DIST\n",
      "CIT FOR EVERETT PUBLIC SCHOOLS\n",
      "CIT FOR SUPPORT OF YELM SCHOOLS\n",
      "CITIZENS TEAM FOR MUKILTEO SCHOOLS\n",
      "SUPPORT FERNDALE SCHOOLS COMM\n",
      "VOICE OF TAHOMA EDUCATION\n",
      "resolve_donations: Recursion loop, ignoring donation to self by WASHINGTON EDUCATION ASSOCIATION\n",
      "MUCKLESHOOT INDIAN TRIBE\n",
      "NATIVE WOMENS PAC\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\birdm\\Anaconda2\\lib\\site-packages\\ipykernel_launcher.py:23: DeprecationWarning: \n",
      ".ix is deprecated. Please use\n",
      ".loc for label based indexing or\n",
      ".iloc for positional indexing\n",
      "\n",
      "See the documentation here:\n",
      "http://pandas.pydata.org/pandas-docs/stable/indexing.html#ix-indexer-is-deprecated\n"
     ]
    }
   ],
   "source": [
    "# cloud storage \n",
    "filename_IE = 'data\\Independent_Campaign_Expenditures_and_Electioneering_Communications20181110.csv'\n",
    "filename_pac = 'data\\Contributions_to_Candidates_and_Political_Committees20181110.csv'\n",
    "config_file = 'config.yml'\n",
    "\n",
    "df = IEnPAC_to_csv(filename_IE, filename_pac, config_file)\n",
    "\n",
    "# Dataframe to table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>CALLAN LISA M</td>\n",
       "      <td>5355.620000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>DAS MONA</td>\n",
       "      <td>10675.550000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>ENTENMAN DEBRA J</td>\n",
       "      <td>10675.560000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>KILDUFF CHRISTINE J</td>\n",
       "      <td>15410.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>KRUGER LEAVITT MARI L</td>\n",
       "      <td>15410.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>PELLICCIOTTI MICHAEL J</td>\n",
       "      <td>7131.120000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>RAMOS BILL G</td>\n",
       "      <td>5355.620000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>REEVES KRISTINE M</td>\n",
       "      <td>7131.130000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>SULLIVAN PATRICK J</td>\n",
       "      <td>10181.700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>WILSON CLAIRE E</td>\n",
       "      <td>6999.140000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>OURVOTESCOUNT</td>\n",
       "      <td>363577.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>CHAMBERS KELLY M</td>\n",
       "      <td>25490.710000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>ESPINOZA MAIA L</td>\n",
       "      <td>1000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>FAIN JOSEPH F</td>\n",
       "      <td>1000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>GILDON CHRIS</td>\n",
       "      <td>6890.710000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>GOEHNER KEITH W</td>\n",
       "      <td>1000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>GRAHAM VIRGINIA C</td>\n",
       "      <td>5899.180000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>GRAVES PAUL S</td>\n",
       "      <td>9764.240000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>HAYDEN RANDOLPH J</td>\n",
       "      <td>6395.770000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>HAYES DAVID J</td>\n",
       "      <td>10600.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>HOFF LARRY A</td>\n",
       "      <td>1000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>KUDERER PATRICIA E</td>\n",
       "      <td>-5219.620000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>KUNEY MARY L</td>\n",
       "      <td>1000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>MAGENDANZ CHAD L</td>\n",
       "      <td>54612.870000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>MILOSCIA MARK A</td>\n",
       "      <td>24048.390000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>MURI RICHARD W</td>\n",
       "      <td>1000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>ROULSTONE DOUGLAS R</td>\n",
       "      <td>18391.290000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>RUDE SKYLER D</td>\n",
       "      <td>6727.650000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>THURSTON CO REPUB CENT COMM NON EXEMPT</td>\n",
       "      <td>60.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>TOM RODNEY</td>\n",
       "      <td>34503.980000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>WAGONER KEITH L</td>\n",
       "      <td>22395.770000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>MAINSTREAM REPUB OF WA ST PAC</td>\n",
       "      <td>WALSH JAMES W</td>\n",
       "      <td>27680.470000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>AGAINST 1631</td>\n",
       "      <td>0.266251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>AGAINST 1639</td>\n",
       "      <td>0.153234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>AGAINST 940</td>\n",
       "      <td>0.266301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>AGUILAR EVANGELINA</td>\n",
       "      <td>4.236159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>AMETU RION A</td>\n",
       "      <td>0.392593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>ANDREWS PAUL D</td>\n",
       "      <td>1.393392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>ANGEL JANICE E</td>\n",
       "      <td>2006.530717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>APPLEBY MICHAEL A</td>\n",
       "      <td>0.110842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>APPLETON SHERRY V</td>\n",
       "      <td>0.126471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>ARAGON SOFIA A</td>\n",
       "      <td>0.395098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BAILEY BRENNAN F</td>\n",
       "      <td>0.154821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BALLEW TIMOTHY J II</td>\n",
       "      <td>0.386483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BARKIS ANDREW K</td>\n",
       "      <td>2000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BAUMGARTNER MICHAEL J</td>\n",
       "      <td>4003.401997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BELL MICHAEL R</td>\n",
       "      <td>0.390555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BIGEA PETRONELA</td>\n",
       "      <td>0.134495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BLAKE BRIAN E</td>\n",
       "      <td>2001.020356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>ANHEUSER BUSCH CO.</td>\n",
       "      <td>BLODGETT DEBRA F</td>\n",
       "      <td>0.500993</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                0                                       1  \\\n",
       "0                   OURVOTESCOUNT                           CALLAN LISA M   \n",
       "1                   OURVOTESCOUNT                                DAS MONA   \n",
       "2                   OURVOTESCOUNT                        ENTENMAN DEBRA J   \n",
       "3                   OURVOTESCOUNT                     KILDUFF CHRISTINE J   \n",
       "4                   OURVOTESCOUNT                   KRUGER LEAVITT MARI L   \n",
       "5                   OURVOTESCOUNT                  PELLICCIOTTI MICHAEL J   \n",
       "6                   OURVOTESCOUNT                            RAMOS BILL G   \n",
       "7                   OURVOTESCOUNT                       REEVES KRISTINE M   \n",
       "8                   OURVOTESCOUNT                      SULLIVAN PATRICK J   \n",
       "9                   OURVOTESCOUNT                         WILSON CLAIRE E   \n",
       "10                  OURVOTESCOUNT                           OURVOTESCOUNT   \n",
       "11  MAINSTREAM REPUB OF WA ST PAC                        CHAMBERS KELLY M   \n",
       "12  MAINSTREAM REPUB OF WA ST PAC                         ESPINOZA MAIA L   \n",
       "13  MAINSTREAM REPUB OF WA ST PAC                           FAIN JOSEPH F   \n",
       "14  MAINSTREAM REPUB OF WA ST PAC                            GILDON CHRIS   \n",
       "15  MAINSTREAM REPUB OF WA ST PAC                         GOEHNER KEITH W   \n",
       "16  MAINSTREAM REPUB OF WA ST PAC                       GRAHAM VIRGINIA C   \n",
       "17  MAINSTREAM REPUB OF WA ST PAC                           GRAVES PAUL S   \n",
       "18  MAINSTREAM REPUB OF WA ST PAC                       HAYDEN RANDOLPH J   \n",
       "19  MAINSTREAM REPUB OF WA ST PAC                           HAYES DAVID J   \n",
       "20  MAINSTREAM REPUB OF WA ST PAC                            HOFF LARRY A   \n",
       "21  MAINSTREAM REPUB OF WA ST PAC                      KUDERER PATRICIA E   \n",
       "22  MAINSTREAM REPUB OF WA ST PAC                            KUNEY MARY L   \n",
       "23  MAINSTREAM REPUB OF WA ST PAC                        MAGENDANZ CHAD L   \n",
       "24  MAINSTREAM REPUB OF WA ST PAC                         MILOSCIA MARK A   \n",
       "25  MAINSTREAM REPUB OF WA ST PAC                          MURI RICHARD W   \n",
       "26  MAINSTREAM REPUB OF WA ST PAC                     ROULSTONE DOUGLAS R   \n",
       "27  MAINSTREAM REPUB OF WA ST PAC                           RUDE SKYLER D   \n",
       "28  MAINSTREAM REPUB OF WA ST PAC  THURSTON CO REPUB CENT COMM NON EXEMPT   \n",
       "29  MAINSTREAM REPUB OF WA ST PAC                              TOM RODNEY   \n",
       "30  MAINSTREAM REPUB OF WA ST PAC                         WAGONER KEITH L   \n",
       "31  MAINSTREAM REPUB OF WA ST PAC                           WALSH JAMES W   \n",
       "32             ANHEUSER BUSCH CO.                            AGAINST 1631   \n",
       "33             ANHEUSER BUSCH CO.                            AGAINST 1639   \n",
       "34             ANHEUSER BUSCH CO.                             AGAINST 940   \n",
       "35             ANHEUSER BUSCH CO.                      AGUILAR EVANGELINA   \n",
       "36             ANHEUSER BUSCH CO.                            AMETU RION A   \n",
       "37             ANHEUSER BUSCH CO.                          ANDREWS PAUL D   \n",
       "38             ANHEUSER BUSCH CO.                          ANGEL JANICE E   \n",
       "39             ANHEUSER BUSCH CO.                       APPLEBY MICHAEL A   \n",
       "40             ANHEUSER BUSCH CO.                       APPLETON SHERRY V   \n",
       "41             ANHEUSER BUSCH CO.                          ARAGON SOFIA A   \n",
       "42             ANHEUSER BUSCH CO.                        BAILEY BRENNAN F   \n",
       "43             ANHEUSER BUSCH CO.                     BALLEW TIMOTHY J II   \n",
       "44             ANHEUSER BUSCH CO.                         BARKIS ANDREW K   \n",
       "45             ANHEUSER BUSCH CO.                   BAUMGARTNER MICHAEL J   \n",
       "46             ANHEUSER BUSCH CO.                          BELL MICHAEL R   \n",
       "47             ANHEUSER BUSCH CO.                         BIGEA PETRONELA   \n",
       "48             ANHEUSER BUSCH CO.                           BLAKE BRIAN E   \n",
       "49             ANHEUSER BUSCH CO.                        BLODGETT DEBRA F   \n",
       "\n",
       "                2  \n",
       "0     5355.620000  \n",
       "1    10675.550000  \n",
       "2    10675.560000  \n",
       "3    15410.750000  \n",
       "4    15410.750000  \n",
       "5     7131.120000  \n",
       "6     5355.620000  \n",
       "7     7131.130000  \n",
       "8    10181.700000  \n",
       "9     6999.140000  \n",
       "10  363577.750000  \n",
       "11   25490.710000  \n",
       "12    1000.000000  \n",
       "13    1000.000000  \n",
       "14    6890.710000  \n",
       "15    1000.000000  \n",
       "16    5899.180000  \n",
       "17    9764.240000  \n",
       "18    6395.770000  \n",
       "19   10600.000000  \n",
       "20    1000.000000  \n",
       "21   -5219.620000  \n",
       "22    1000.000000  \n",
       "23   54612.870000  \n",
       "24   24048.390000  \n",
       "25    1000.000000  \n",
       "26   18391.290000  \n",
       "27    6727.650000  \n",
       "28      60.000000  \n",
       "29   34503.980000  \n",
       "30   22395.770000  \n",
       "31   27680.470000  \n",
       "32       0.266251  \n",
       "33       0.153234  \n",
       "34       0.266301  \n",
       "35       4.236159  \n",
       "36       0.392593  \n",
       "37       1.393392  \n",
       "38    2006.530717  \n",
       "39       0.110842  \n",
       "40       0.126471  \n",
       "41       0.395098  \n",
       "42       0.154821  \n",
       "43       0.386483  \n",
       "44    2000.000000  \n",
       "45    4003.401997  \n",
       "46       0.390555  \n",
       "47       0.134495  \n",
       "48    2001.020356  \n",
       "49       0.500993  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}