{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "Sometimes you don't want to use OpenRefine. Why not? I don't know, it's the *best* for cleaning up fuzzy matches. But yes, sure, sometimes maybe you don't." ] }, { "cell_type": "code", "execution_count": 61, "metadata": { "collapsed": true }, "outputs": [], "source": [ "%matplotlib inline\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 62, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df = pd.read_csv(\"CD_Transactions_07-23-2017.CSV\", index_col=False)" ] }, { "cell_type": "code", "execution_count": 63, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ResultDateTransaction TypePayment TypePayment DetailAmountLast/Business NameFirst NameAddressCity...--------Report TypeElection NameElection TypeMunicipalityOfficeFiler TypeNameReport YearSubmitted
014/3/2017IncomeCheck12864$350.00Alaska Republican Party State AccountNaNNaNNaN...NaN24 Hour Report2017 - Anchorage Municipal ElectionAnchorage MunicipalAnchorage, Municipality ofSchool BoardCandidateKay E Schuster20174/3/2017
124/3/2017IncomeCredit CardNaN$500.00CoffeyDanNaNNaN...NaN24 Hour Report2017 - Anchorage Municipal ElectionAnchorage MunicipalAnchorage, Municipality ofSchool BoardCandidateKay E Schuster20174/3/2017
234/3/2017IncomeCheck3047$300.00ACS Employees PACNaNNaNNaN...NaN24 Hour Report2017 - Anchorage Municipal ElectionAnchorage MunicipalAnchorage, Municipality ofAssemblyCandidatePete Petersen20174/3/2017
344/3/2017IncomeCredit CardNaN$500.00HolmesPatrickNaNNaN...NaN24 Hour Report2017 - Anchorage Municipal ElectionAnchorage MunicipalAnchorage, Municipality ofNaNGroupAlaska Republican Party20174/3/2017
454/3/2017IncomeCredit CardNaN$500.00GonzalesMark L.NaNNaN...NaN24 Hour Report2017 - Anchorage Municipal ElectionAnchorage MunicipalAnchorage, Municipality ofNaNGroupAlaska Republican Party20174/3/2017
\n", "

5 rows × 26 columns

\n", "
" ], "text/plain": [ " Result Date Transaction Type Payment Type Payment Detail Amount \\\n", "0 1 4/3/2017 Income Check 12864 $350.00 \n", "1 2 4/3/2017 Income Credit Card NaN $500.00 \n", "2 3 4/3/2017 Income Check 3047 $300.00 \n", "3 4 4/3/2017 Income Credit Card NaN $500.00 \n", "4 5 4/3/2017 Income Credit Card NaN $500.00 \n", "\n", " Last/Business Name First Name Address City ... \\\n", "0 Alaska Republican Party State Account NaN NaN NaN ... \n", "1 Coffey Dan NaN NaN ... \n", "2 ACS Employees PAC NaN NaN NaN ... \n", "3 Holmes Patrick NaN NaN ... \n", "4 Gonzales Mark L. NaN NaN ... \n", "\n", " -------- Report Type Election Name \\\n", "0 NaN 24 Hour Report 2017 - Anchorage Municipal Election \n", "1 NaN 24 Hour Report 2017 - Anchorage Municipal Election \n", "2 NaN 24 Hour Report 2017 - Anchorage Municipal Election \n", "3 NaN 24 Hour Report 2017 - Anchorage Municipal Election \n", "4 NaN 24 Hour Report 2017 - Anchorage Municipal Election \n", "\n", " Election Type Municipality Office Filer Type \\\n", "0 Anchorage Municipal Anchorage, Municipality of School Board Candidate \n", "1 Anchorage Municipal Anchorage, Municipality of School Board Candidate \n", "2 Anchorage Municipal Anchorage, Municipality of Assembly Candidate \n", "3 Anchorage Municipal Anchorage, Municipality of NaN Group \n", "4 Anchorage Municipal Anchorage, Municipality of NaN Group \n", "\n", " Name Report Year Submitted \n", "0 Kay E Schuster 2017 4/3/2017 \n", "1 Kay E Schuster 2017 4/3/2017 \n", "2 Pete Petersen 2017 4/3/2017 \n", "3 Alaska Republican Party 2017 4/3/2017 \n", "4 Alaska Republican Party 2017 4/3/2017 \n", "\n", "[5 rows x 26 columns]" ] }, "execution_count": 63, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# What are all of our options for the \"Alaska Sea Pilot PAC fund\"?" ] }, { "cell_type": "code", "execution_count": 65, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(3, 26)" ] }, "execution_count": 65, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[df['Last/Business Name'] == 'Alaska Sea Pilot PAC fund'].shape" ] }, { "cell_type": "code", "execution_count": 67, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(6, 26)" ] }, "execution_count": 67, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[df['Last/Business Name'] == 'ALASKA SEA PILOT PAC FUND'].shape" ] }, { "cell_type": "code", "execution_count": 69, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(6, 26)" ] }, "execution_count": 69, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[df['Last/Business Name'] == 'Alaska Sea Pilot Pac Fund'].shape" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Maybe we can throw in a regex and catch some more?" ] }, { "cell_type": "code", "execution_count": 70, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Alaska Sea Pilot PAC Fund 46\n", "Alaska Sea Pilot PAC 17\n", "Alaska Sea Pilots PAC Fund 13\n", "Alaska Sea Pilot Pac Fund 6\n", "Alaska Sea Pilots 5\n", "Alaska Sea Pilot PAC fund 3\n", "Alaska Sea Pilot Pac 3\n", "Alaska Sea Pilot 3\n", "Alaska Sea Pilots Pac Fund 2\n", "Alaska Sea Pilot PAC Fund 2\n", "Alaska Sea Pilot Fund 2\n", "Alaska Sea Pilot PAC fund 2\n", "Alaska Sea Pilot PAC 1\n", "Alaska Sea Pilots, 1621 Tongass Ave., Ketchikan, AK. 99901 1\n", " Ak Sea Pilot PAC 1\n", "AlaskanSea Pilot PAC 1\n", "Alaska SeaPilot PAC 1\n", "Alaska Sea Pilots Ass'n 1\n", "AK Sea Pilot Pac Fund 1\n", "AK Sea Pilot PAC 1\n", "Alaska Sea Pilots, LLC. 1\n", "Alaska Sea Pilot 1\n", "Alaska Sea Pilot Pac 1\n", "AK Sea Pilot PAC Fund 1\n", "Name: Last/Business Name, dtype: int64" ] }, "execution_count": 70, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[df['Last/Business Name'].str.contains(\"Sea.*Pilot\", na=False)]['Last/Business Name'].value_counts()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Using fuzzywuzzy for finding fuzzy matches\n", "\n", "Fuzzy matches are incomplete or inexact matches. The Python package [fuzzywuzzy](https://github.com/seatgeek/fuzzywuzzy) has a few functions that can help you, although they're a little bit confusing! I'm going to take the examples from GitHub and annotate them a little, then we'll use them.\n", "\n", "First, install fuzzywuzzy with\n", "\n", "```bash\n", "pip3 install fuzzywuzzy[speedup]\n", "```\n", "\n", "Then we'll get to importing it" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# fuzz is used to compare TWO strings\n", "from fuzzywuzzy import fuzz\n", "\n", "# process is used to compare a string to MULTIPLE other strings\n", "from fuzzywuzzy import process" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "> **MAKE SURE YOU INSTALLED USING `pip3 install fuzzywuzzy[speedup]` OR ELSE IT WILL COMPLAIN HERE AND WILL ALSO BE SLOWER**" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### `fuzz.ratio` compares the entire string, in order\n", "\n", "Every single thing in the string is important here!" ] }, { "cell_type": "code", "execution_count": 79, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "74" ] }, "execution_count": 79, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fuzz.ratio(\"this is a test\", \"this is a fun\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### `fuzz.partial_ratio` compares subsections of the string\n", "\n", "Partial matches are fine! The exclamation mark at the end made `fuzz.ratio` not like the comparison last time, but this time it's OK." ] }, { "cell_type": "code", "execution_count": 84, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "57" ] }, "execution_count": 84, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fuzz.partial_ratio(\"this is a test\", \"test a is this\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### `fuzz.token_sort_ratio` ignores word order\n", "\n", "`fuzz.token_sort_ratio` orders all of the words first, so \"KENNEDY JOHN\" and \"JOHN KENNEDY\" would be the same." ] }, { "cell_type": "code", "execution_count": 85, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "100" ] }, "execution_count": 85, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fuzz.token_sort_ratio(\"fuzzy wuzzy was a bear\", \"wuzzy fuzzy was a bear\")" ] }, { "cell_type": "code", "execution_count": 86, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "100" ] }, "execution_count": 86, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fuzz.token_sort_ratio(\"this is a test\", \"is this a test\")" ] }, { "cell_type": "code", "execution_count": 88, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "84" ] }, "execution_count": 88, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fuzz.token_sort_ratio(\"fuzzy was a bear\", \"fuzzy fuzzy was a bear\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### `fuzz.token_set_ratio` ignores duplicate words\n", "\n", "I don't know why you'd ever have \"JOHN KENNEDY KENNEDY\" but if you use `fuzz.token_set_ratio` then it would definitely match \"JOHN KENNEDY\"." ] }, { "cell_type": "code", "execution_count": 91, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "100" ] }, "execution_count": 91, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fuzz.token_set_ratio(\"fuzzy was a bear\", \"fuzzy fuzzy was a bear\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Actually using fuzzywuzzy on our dataset, featuring `process.extract`" ] }, { "cell_type": "code", "execution_count": 94, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('THIS IS A TEST!!', 100),\n", " ('is this a test', 86),\n", " ('fuzzy fuzzy was a bear', 33)]" ] }, "execution_count": 94, "metadata": {}, "output_type": "execute_result" } ], "source": [ "choices = ['fuzzy fuzzy was a bear', 'is this a test', 'THIS IS A TEST!!']\n", "process.extract(\"this is a test\", choices, scorer=fuzz.ratio)" ] }, { "cell_type": "code", "execution_count": 95, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('is this a test', 100),\n", " ('THIS IS A TEST!!', 100),\n", " ('fuzzy fuzzy was a bear', 28)]" ] }, "execution_count": 95, "metadata": {}, "output_type": "execute_result" } ], "source": [ "choices = ['fuzzy fuzzy was a bear', 'is this a test', 'THIS IS A TEST!!']\n", "process.extract(\"this is a test\", choices, scorer=fuzz.token_sort_ratio)" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Since we already imported, let's collect all of the business names into a list. We're going to search through the list to find names that are similar to **Alaska Sea Pilot PAC Fun**." ] }, { "cell_type": "code", "execution_count": 96, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "array(['Alaska Republican Party State Account', 'Coffey',\n", " 'ACS Employees PAC', 'Holmes', 'Gonzales',\n", " 'Anchorage Taxicab Permit Owners Association (ATPOA)', 'Abdullah',\n", " 'Alimi', 'Barbosa', 'Bryant', 'Chamot', 'Farmer', 'Gautam',\n", " 'Guevara', 'Lena'], dtype=object)" ] }, "execution_count": 96, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# If we grab a column and use .unique(), it gives us every business name with no repeats\n", "choices = df['Last/Business Name'].unique()\n", "choices[:15]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now we'll use `process.extract` to find the top 15 matches" ] }, { "cell_type": "code", "execution_count": 98, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "CPU times: user 634 ms, sys: 5.38 ms, total: 639 ms\n", "Wall time: 642 ms\n" ] }, { "data": { "text/plain": [ "[('Alaska Sea Pilot PAC Fund', 100),\n", " ('Alaska Sea Pilot PAC fund', 100),\n", " ('ALASKA SEA PILOT PAC FUND', 100),\n", " ('Alaska Sea Pilot PAC Fund ', 100),\n", " ('Alaska SEA Pilot Pac Fund', 100),\n", " ('Alaska SEA Pilot PAC Fund', 100),\n", " ('Alaska Sea Pilot Pac Fund', 100),\n", " ('Alaska Sea Pilot PAC fund', 100),\n", " ('Alaska Sea Pilots PAC Fund', 98),\n", " ('Alaska Sea Pilots Pac Fund', 98),\n", " ('Alaska Sea Pilot Fund', 91),\n", " ('AK Sea Pilot Pac Fund', 91),\n", " ('ALASKA SEA PILOT FUND', 91),\n", " ('AK Sea Pilot PAC Fund', 91),\n", " ('Alaska Sea Pilot Pac', 89),\n", " ('Alaska Sea Pilot PAC', 89),\n", " ('Alaska Sea Pilot Pac ', 89),\n", " ('Alaska Sea Pilot PAC ', 89),\n", " ('ALASK SEA PILOT PAC', 86),\n", " ('Alaska Sea Pilot', 78),\n", " ('AK Sea Pilot PAC', 78),\n", " (' Ak Sea Pilot PAC', 78),\n", " ('Alaska Sea Pilot ', 78),\n", " ('Alaska Sea Pilots, LLC.', 78),\n", " ('Alaska Sea Pilots', 76),\n", " ('AlaskanSea Pilot PAC', 76),\n", " ('Alaska Marine Pilot PAC', 75),\n", " (\"Alaska Sea Pilots Ass'n\", 75),\n", " ('Alaska SeaPilot PAC', 73),\n", " ('Alaska Senate Majority Fund', 73)]" ] }, "execution_count": 98, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%%time\n", "process.extract(\"Alaska Sea Pilot PAC Fund\", choices, limit=30, scorer=fuzz.token_sort_ratio)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Wow, those look pretty nice! Maybe instead we should just find the ones that are above a certain score? You can also specify a `scorer` if you want to get particular." ] }, { "cell_type": "code", "execution_count": 99, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# Get 100 options so we're sure to have some non-matches\n", "possibilities = process.extract(\"Alaska Sea Pilot PAC Fund\", choices, limit=100, scorer=fuzz.token_sort_ratio)" ] }, { "cell_type": "code", "execution_count": 100, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('Alaska Sea Pilot PAC Fund', 100),\n", " ('Alaska Sea Pilot PAC fund', 100),\n", " ('ALASKA SEA PILOT PAC FUND', 100),\n", " ('Alaska Sea Pilot PAC Fund ', 100),\n", " ('Alaska SEA Pilot Pac Fund', 100),\n", " ('Alaska SEA Pilot PAC Fund', 100),\n", " ('Alaska Sea Pilot Pac Fund', 100),\n", " ('Alaska Sea Pilot PAC fund', 100),\n", " ('Alaska Sea Pilots PAC Fund', 98),\n", " ('Alaska Sea Pilots Pac Fund', 98),\n", " ('Alaska Sea Pilot Fund', 91),\n", " ('AK Sea Pilot Pac Fund', 91),\n", " ('ALASKA SEA PILOT FUND', 91),\n", " ('AK Sea Pilot PAC Fund', 91),\n", " ('Alaska Sea Pilot Pac', 89),\n", " ('Alaska Sea Pilot PAC', 89),\n", " ('Alaska Sea Pilot Pac ', 89),\n", " ('Alaska Sea Pilot PAC ', 89),\n", " ('ALASK SEA PILOT PAC', 86),\n", " ('Alaska Sea Pilot', 78),\n", " ('AK Sea Pilot PAC', 78),\n", " (' Ak Sea Pilot PAC', 78),\n", " ('Alaska Sea Pilot ', 78),\n", " ('Alaska Sea Pilots, LLC.', 78),\n", " ('Alaska Sea Pilots', 76),\n", " ('AlaskanSea Pilot PAC', 76),\n", " ('Alaska Marine Pilot PAC', 75),\n", " (\"Alaska Sea Pilots Ass'n\", 75)]" ] }, "execution_count": 100, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# And let's see everyting with a score above 73\n", "[possible for possible in possibilities if possible[1] > 73]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**Huh, pretty neat.**\n", "\n", "## Filtering directly with fuzzywuzzy\n", "\n", "We can also use this directly with our dataframe, if we'd like to use `fuzzywuzzy` to filter instead of giving us a list. It's going to be a lot slower, but that's life, I guess." ] }, { "cell_type": "code", "execution_count": 101, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ResultDateTransaction TypePayment TypePayment DetailAmountLast/Business NameFirst NameAddressCity...--------Report TypeElection NameElection TypeMunicipalityOfficeFiler TypeNameReport YearSubmitted
505055050612/3/2015IncomeCheck1278$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass Ave, Ste 300Ketchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNHouseCandidateJonathan Kreiss-Tomkins20166/13/2016
515575155811/23/2015IncomeCheck1279$500.00Alaska Sea Pilot PacNaN1621 Tongass Ave. Ste. 300Ketchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNSenateCandidateBert K. Stedman20166/23/2016
615856158611/21/2015IncomeCheck1090$500.00Alaska Sea Pilots PAC FundNaN1621 Tongass Avenue Ste. 300Ketchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNHouseCandidateSam S Kito III20168/9/2016
623516235211/16/2015IncomeCheck1084$500.00Alaska Sea Pilot PACNaN1621 Tongass AveKetchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNHouseCandidateNeal Winston Foster20168/28/2016
741557415611/16/2015IncomeCheck1087$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass AveKetchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNHouseCandidateLynn Gattis201610/9/2016
75904759059/13/2016IncomeCheck1289$1,000.00Alaska Sea Pilot PAC FundAlaska Sea Pilot PAC Fund1621 Tongass AvenueKetchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateAndrew \"Andy\" Josephson201610/9/2016
77090770919/13/2016IncomeCheck1285$500.00Alaska Sea PilotNaN1621 Tongass Avenue, Suite 300Ketchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateCathy L. Tilton201610/10/2016
771107711110/24/2016IncomeCheck1297$1,000.00Alaska Sea Pilot PAC FundNaN1621 Tongass Ave.Ketchikan...NaNSeven Day Report2016 - State General ElectionState GeneralNaNHouseCandidateDave Talerico201610/31/2016
77259772609/15/2016IncomeCheck1288$500.00ALASK SEA PILOT PACNaN1621 TONGASS AVEKETCHIKAN...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateGary Allan Knopp201610/10/2016
77473774749/14/2016IncomeCheck1284$500.00Alaska Sea Pilot Fundn/a1621 Tongass AvenueKetchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidatecathy munoz201610/10/2016
835128351310/18/2016IncomeCheck1206$500.00Alaska Sea Pilots PAC FundNaN1621 Tongass AveKetchikan...NaNSeven Day Report2016 - State General ElectionState GeneralNaNHouseCandidateChris Birch201611/1/2016
838248382510/20/2016IncomeCheck1300$1,000.00Alaska Sea Pilot PacNaN1621 Tongass Ave. Ste. 300Ketchikan...NaNSeven Day Report2016 - State General ElectionState GeneralNaNSenateCandidateBert K. Stedman201611/1/2016
895768957711/21/2015IncomeCheck1090$500.00Alaska Sea Pilots PAC FundNaN1621 Tongass Avenue Ste. 300Ketchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNHouseCandidateSam S Kito III20168/9/2016
910199102010/18/2016IncomeCheck1202$1,000.00Alaska Sea Pilots Pac FundNaN1621 TongassKetchikan...NaNSeven Day Report2016 - State General ElectionState GeneralNaNSenateCandidateDonald \"Donny\" C. Olson201611/1/2016
910319103210/18/2016IncomeCheck1299$500.00Alaska Sea Pilot PAC fundNaN1621 Tongass AveKetchikan...NaNSeven Day Report2016 - State General ElectionState GeneralNaNHouseCandidateMark Neuman201611/1/2016
915569155710/26/2016IncomeCheck1208$1,000.00Alaska Sea Pilot PAC FundNaN1621 Tongass Avenue, Suite 300Ketchikan...NaNSeven Day Report2016 - State General ElectionState GeneralNaNHouseCandidateZach Fansler201611/1/2016
92062920639/13/2016IncomeCheck1286$1,000.00Alaska Sea Pilot PAC FundNaN1621 Tongrass AveKetchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNSenateCandidateDavid S. Wilson201611/2/2016
925089250912/21/2016IncomeCheck1212$1,000.00Alaska Sea Pilots PAC FundNaN1621 Tongass Ave Ste 300Ketchikan...NaNYear End Report2016 - State General ElectionState GeneralNaNHouseCandidateJonathan Kreiss-Tomkins20162/15/2017
93756937579/13/2016IncomeCheck1291$500.00ALASKA SEA PILOT PAC FUNDNaN1621 Tongass ave.Ketchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateDeLena Johnson201612/15/2016
93896938979/13/2016IncomeCheck1287$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass AveKetchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateIvy A Spohnholz201612/19/2016
959969599711/25/2015IncomeCheck1277$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass Ave.Ketchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNSenateCandidateGary L. Stevens20162/3/2016
96262962639/19/2016IncomeCheck1201$1,000.00AK Sea Pilot PACNaN1621 Tongass AveKetchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNSenateCandidateShelley Hughes201610/10/2016
964519645211/16/2015IncomeCheck1280$500.00AK Sea Pilot Pac FundNaN1621 Tongass AveKetchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNHouseCandidateShelley Hughes20169/21/2016
97153971549/13/2016IncomeCheck1283$500.00Alaska SEA Pilot Pac FundNaN1621 Tongass Ave.Ketchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateGeran Tarr201610/10/2016
10214610214711/16/2015IncomeCheck1087$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass AveKetchikan...NaNYear Start Report2016 - State Primary ElectionState PrimaryNaNHouseCandidateLynn Gattis201610/9/2016
1038951038969/13/2016IncomeCheck1289$1,000.00Alaska Sea Pilot PAC FundAlaska Sea Pilot PAC Fund1621 Tongass AvenueKetchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateAndrew \"Andy\" Josephson201610/9/2016
1050811050829/13/2016IncomeCheck1285$500.00Alaska Sea PilotNaN1621 Tongass Avenue, Suite 300Ketchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateCathy L. Tilton201610/10/2016
10510110510210/24/2016IncomeCheck1297$1,000.00Alaska Sea Pilot PAC FundNaN1621 Tongass Ave.Ketchikan...NaNSeven Day Report2016 - State General ElectionState GeneralNaNHouseCandidateDave Talerico201610/31/2016
1052501052519/15/2016IncomeCheck1288$500.00ALASK SEA PILOT PACNaN1621 TONGASS AVEKETCHIKAN...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidateGary Allan Knopp201610/10/2016
1054641054659/14/2016IncomeCheck1284$500.00Alaska Sea Pilot Fundn/a1621 Tongass AvenueKetchikan...NaNThirty Day Report2016 - State General ElectionState GeneralNaNHouseCandidatecathy munoz201610/10/2016
..................................................................
36664636664712/8/2014IncomeCheck1076$1,000.00Alaska Sea Pilots Ass'nNaN1621 Tongass AvenueKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNGovernor / Lt. GovernorCandidateWalker Mallott for Alaska20142/17/2015
37135037135112/18/2013IncomeCheck1198$1,000.00Alaska Sea Pilots PAC FundNaN1621 Tongass AvenueKetchikan...NaNYear Start Report2014 - State Primary ElectionState PrimaryNaNSenateCandidatePeter Andrew Micciche20142/17/2015
37145037145110/3/2014IncomeCheck1324$1,000.00Alaska Sea Pilot PACNaN1621 Tongass Ave.Ketchikan...NaNThirty Day Report2014 - State General ElectionState GeneralNaNSenateCandidatePeter Andrew Micciche20142/17/2015
37526237526310/6/2014IncomeCheck1314$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass aveKetchikan...NaNSeven Day Report2014 - State General ElectionState GeneralNaNHouseCandidateDavid Guttenberg20144/13/2015
38016538016611/3/2014IncomeCheck1068$500.00Alaska Sea Pilot PACPACNaNNaN...NaN24 Hour Report2014 - State General ElectionState GeneralNaNSenateCandidateBerta Gardner20145/12/2015
38030938031011/3/2014IncomeCheck1070$1,000.00Alaska Sea Pilot PAC FundNaNNaNNaN...NaN24 Hour Report2014 - State General ElectionState GeneralNaNHouseCandidateWes Keller20145/19/2015
38081738081812/14/2013IncomeCheck128$500.00Alaska Sea Pilot PACNaN1621 Tongass Fund, Suite 300Ketchikan...NaNYear Start Report2014 - State Primary ElectionState PrimaryNaNSenateCandidateBill Stoltze20145/30/2015
38214738214810/9/2014IncomeCheck1304$500.00ALASKA SEA PILOT PAC FUNDNaN1621 TONGASS AVEKETCHIKAN...NaNSeven Day Report2014 - State General ElectionState GeneralNaNNaNCandidateClick Bishop20146/14/2015
38239938240012/5/2014IncomeCheck1079$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass AveKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNNaNCandidateGabrielle LeDoux20147/11/2015
38364638364711/5/2014IncomeCheck1072$1,000.00AK Sea Pilot PAC FundNaN1621 Tongass Ave. Suite 300Ketchican...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateAdam L. Wool20146/29/2015
3840353840368/7/2014IncomeCheck1301$1,000.00Alaska Sea Pilot PACNaN1621 Tongass AveKetchikan...NaNSeven Day Report2014 - State Primary ElectionState PrimaryNaNSenateCandidateBill Stoltze20146/30/2015
38449338449410/6/2014IncomeCheck1307$500.00ALASKA SEA PILOT PAC FUNDNaN1621 TONGASS AVENUEKETCHIKAN...NaNSeven Day Report2014 - State General ElectionState GeneralNaNNaNCandidateBryce Edgmon20147/1/2015
38462938463010/4/2014IncomeCheck1318$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass AveKetchikan...NaNSeven Day Report2014 - State General ElectionState GeneralNaNHouseCandidateGeran Tarr20147/1/2015
38521838521911/3/2014IncomeCheck1068$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass AvenueKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNSenateCandidateBerta Gardner20147/14/2015
38565638565711/7/2014IncomeCheck1075$1,000.00Alaska Sea Pilot PACNaN1621 Tongass Ave, Suit 300Ketchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateJonathan Kreiss-Tomkins20147/18/2015
38726638726710/3/2014IncomeCheck1321$500.00Alaska Sea Pilot PACNaN1621 Tongass AvenueKetchikan...NaNThirty Day Report2014 - State General ElectionState GeneralNaNHouseCandidateCathy Munoz201410/10/2015
38747638747710/3/2014IncomeCheck1320$500.00Alaska Sea Pilots PAC FundNaN1621 Tongass Avenue Ste. 300Ketchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateBenjamin P. Nageak \"Bennie\"201410/21/2015
38771538771611/11/2014IncomeCheck1074$1,000.00Alaska Sea PilotNaN1621 Tongass AveKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateLouise B. Stutes201411/14/2015
38778338778410/6/2014IncomeCheck1306$500.00Alaska Sea Pilots PAC FundNaN1621 Tongass Ave ste 300Ketchikan...NaNSeven Day Report2014 - State General ElectionState GeneralNaNHouseCandidateSam S Kito III201412/2/2015
38801338801410/8/2014IncomeCheck1313$1,000.00Alaska Sea Pilots PAC FundNaN1621 Tongass AveKetchikan...NaNSeven Day Report2014 - State General ElectionState GeneralNaNHouseCandidateDave M. Talerico201412/9/2015
38904638904712/9/2014IncomeCheck1077$500.00Alaska Sea Pilot Pac FundNaN1621 Tongass AveKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateDaniel H. Ortiz20141/22/2016
38908538908610/11/2014IncomeCheck1312$500.00Alaska Sea Pilot PACNaN1621 Tongass AveKetchikan...NaNSeven Day Report2014 - State General ElectionState GeneralNaNHouseCandidateMark Neuman20142/9/2016
38911738911811/3/2014IncomeCheck1071$1,000.00Alaska Sea Pilot PAC FundNaN1621 Tongass AveKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateWes Keller20142/13/2016
38925638925710/6/2014IncomeCheck1302$750.00AlaskanSea Pilot PACNaN1621 Tongass AveKetchikan...NaNSeven Day Report2014 - State General ElectionState GeneralNaNSenateCandidateMia Costello20142/15/2016
38940038940112/18/2014IncomeCheck1078$250.00Alaska Sea Pilot PACNaN1621 Tongass AveKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNSenateCandidateMia Costello20142/15/2016
38947038947112/17/2015IncomeCheck1086$500.00Alaska Sea PilotsNaN1621 Tongass Ave.Ketchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateDave M. Talerico20142/15/2016
38947338947412/21/2015IncomeCheck6531$250.00Alaska Sea Pilots, LLC.Richard MurphyPO Box 920226Dutch Harbor...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateDave M. Talerico20142/15/2016
39375039375111/5/2014IncomeCheck1073$1,000.00Alaska Sea Pilot PACNaN1621 Tongass AvenueKetchikan...NaNYear End Report2014 - State General ElectionState GeneralNaNHouseCandidateElizabeth (Liz) Vazquez20142/15/2017
39420939421012/19/2013IncomeCheck1195$1,000.00Alaska Sea Pilot PAC fundNaN1621 Tongass Ave.Ketchikan...NaNYear Start Report2014 - State Primary ElectionState PrimaryNaNSenateCandidateMichael J. Dunleavy20142/13/2014
39433639433712/18/2013IncomeCheck1196$500.00Alaska Sea Pilot PAC FundNaN1621 Tongass AveKetchikan...NaNYear Start Report2014 - State Primary ElectionState PrimaryNaNHouseCandidateShelley Hughes20142/16/2014
\n", "

128 rows × 26 columns

\n", "
" ], "text/plain": [ " Result Date Transaction Type Payment Type Payment Detail \\\n", "50505 50506 12/3/2015 Income Check 1278 \n", "51557 51558 11/23/2015 Income Check 1279 \n", "61585 61586 11/21/2015 Income Check 1090 \n", "62351 62352 11/16/2015 Income Check 1084 \n", "74155 74156 11/16/2015 Income Check 1087 \n", "75904 75905 9/13/2016 Income Check 1289 \n", "77090 77091 9/13/2016 Income Check 1285 \n", "77110 77111 10/24/2016 Income Check 1297 \n", "77259 77260 9/15/2016 Income Check 1288 \n", "77473 77474 9/14/2016 Income Check 1284 \n", "83512 83513 10/18/2016 Income Check 1206 \n", "83824 83825 10/20/2016 Income Check 1300 \n", "89576 89577 11/21/2015 Income Check 1090 \n", "91019 91020 10/18/2016 Income Check 1202 \n", "91031 91032 10/18/2016 Income Check 1299 \n", "91556 91557 10/26/2016 Income Check 1208 \n", "92062 92063 9/13/2016 Income Check 1286 \n", "92508 92509 12/21/2016 Income Check 1212 \n", "93756 93757 9/13/2016 Income Check 1291 \n", "93896 93897 9/13/2016 Income Check 1287 \n", "95996 95997 11/25/2015 Income Check 1277 \n", "96262 96263 9/19/2016 Income Check 1201 \n", "96451 96452 11/16/2015 Income Check 1280 \n", "97153 97154 9/13/2016 Income Check 1283 \n", "102146 102147 11/16/2015 Income Check 1087 \n", "103895 103896 9/13/2016 Income Check 1289 \n", "105081 105082 9/13/2016 Income Check 1285 \n", "105101 105102 10/24/2016 Income Check 1297 \n", "105250 105251 9/15/2016 Income Check 1288 \n", "105464 105465 9/14/2016 Income Check 1284 \n", "... ... ... ... ... ... \n", "366646 366647 12/8/2014 Income Check 1076 \n", "371350 371351 12/18/2013 Income Check 1198 \n", "371450 371451 10/3/2014 Income Check 1324 \n", "375262 375263 10/6/2014 Income Check 1314 \n", "380165 380166 11/3/2014 Income Check 1068 \n", "380309 380310 11/3/2014 Income Check 1070 \n", "380817 380818 12/14/2013 Income Check 128 \n", "382147 382148 10/9/2014 Income Check 1304 \n", "382399 382400 12/5/2014 Income Check 1079 \n", "383646 383647 11/5/2014 Income Check 1072 \n", "384035 384036 8/7/2014 Income Check 1301 \n", "384493 384494 10/6/2014 Income Check 1307 \n", "384629 384630 10/4/2014 Income Check 1318 \n", "385218 385219 11/3/2014 Income Check 1068 \n", "385656 385657 11/7/2014 Income Check 1075 \n", "387266 387267 10/3/2014 Income Check 1321 \n", "387476 387477 10/3/2014 Income Check 1320 \n", "387715 387716 11/11/2014 Income Check 1074 \n", "387783 387784 10/6/2014 Income Check 1306 \n", "388013 388014 10/8/2014 Income Check 1313 \n", "389046 389047 12/9/2014 Income Check 1077 \n", "389085 389086 10/11/2014 Income Check 1312 \n", "389117 389118 11/3/2014 Income Check 1071 \n", "389256 389257 10/6/2014 Income Check 1302 \n", "389400 389401 12/18/2014 Income Check 1078 \n", "389470 389471 12/17/2015 Income Check 1086 \n", "389473 389474 12/21/2015 Income Check 6531 \n", "393750 393751 11/5/2014 Income Check 1073 \n", "394209 394210 12/19/2013 Income Check 1195 \n", "394336 394337 12/18/2013 Income Check 1196 \n", "\n", " Amount Last/Business Name First Name \\\n", "50505 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "51557 $500.00 Alaska Sea Pilot Pac NaN \n", "61585 $500.00 Alaska Sea Pilots PAC Fund NaN \n", "62351 $500.00 Alaska Sea Pilot PAC NaN \n", "74155 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "75904 $1,000.00 Alaska Sea Pilot PAC Fund Alaska Sea Pilot PAC Fund \n", "77090 $500.00 Alaska Sea Pilot NaN \n", "77110 $1,000.00 Alaska Sea Pilot PAC Fund NaN \n", "77259 $500.00 ALASK SEA PILOT PAC NaN \n", "77473 $500.00 Alaska Sea Pilot Fund n/a \n", "83512 $500.00 Alaska Sea Pilots PAC Fund NaN \n", "83824 $1,000.00 Alaska Sea Pilot Pac NaN \n", "89576 $500.00 Alaska Sea Pilots PAC Fund NaN \n", "91019 $1,000.00 Alaska Sea Pilots Pac Fund NaN \n", "91031 $500.00 Alaska Sea Pilot PAC fund NaN \n", "91556 $1,000.00 Alaska Sea Pilot PAC Fund NaN \n", "92062 $1,000.00 Alaska Sea Pilot PAC Fund NaN \n", "92508 $1,000.00 Alaska Sea Pilots PAC Fund NaN \n", "93756 $500.00 ALASKA SEA PILOT PAC FUND NaN \n", "93896 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "95996 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "96262 $1,000.00 AK Sea Pilot PAC NaN \n", "96451 $500.00 AK Sea Pilot Pac Fund NaN \n", "97153 $500.00 Alaska SEA Pilot Pac Fund NaN \n", "102146 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "103895 $1,000.00 Alaska Sea Pilot PAC Fund Alaska Sea Pilot PAC Fund \n", "105081 $500.00 Alaska Sea Pilot NaN \n", "105101 $1,000.00 Alaska Sea Pilot PAC Fund NaN \n", "105250 $500.00 ALASK SEA PILOT PAC NaN \n", "105464 $500.00 Alaska Sea Pilot Fund n/a \n", "... ... ... ... \n", "366646 $1,000.00 Alaska Sea Pilots Ass'n NaN \n", "371350 $1,000.00 Alaska Sea Pilots PAC Fund NaN \n", "371450 $1,000.00 Alaska Sea Pilot PAC NaN \n", "375262 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "380165 $500.00 Alaska Sea Pilot PAC PAC \n", "380309 $1,000.00 Alaska Sea Pilot PAC Fund NaN \n", "380817 $500.00 Alaska Sea Pilot PAC NaN \n", "382147 $500.00 ALASKA SEA PILOT PAC FUND NaN \n", "382399 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "383646 $1,000.00 AK Sea Pilot PAC Fund NaN \n", "384035 $1,000.00 Alaska Sea Pilot PAC NaN \n", "384493 $500.00 ALASKA SEA PILOT PAC FUND NaN \n", "384629 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "385218 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "385656 $1,000.00 Alaska Sea Pilot PAC NaN \n", "387266 $500.00 Alaska Sea Pilot PAC NaN \n", "387476 $500.00 Alaska Sea Pilots PAC Fund NaN \n", "387715 $1,000.00 Alaska Sea Pilot NaN \n", "387783 $500.00 Alaska Sea Pilots PAC Fund NaN \n", "388013 $1,000.00 Alaska Sea Pilots PAC Fund NaN \n", "389046 $500.00 Alaska Sea Pilot Pac Fund NaN \n", "389085 $500.00 Alaska Sea Pilot PAC NaN \n", "389117 $1,000.00 Alaska Sea Pilot PAC Fund NaN \n", "389256 $750.00 AlaskanSea Pilot PAC NaN \n", "389400 $250.00 Alaska Sea Pilot PAC NaN \n", "389470 $500.00 Alaska Sea Pilots NaN \n", "389473 $250.00 Alaska Sea Pilots, LLC. Richard Murphy \n", "393750 $1,000.00 Alaska Sea Pilot PAC NaN \n", "394209 $1,000.00 Alaska Sea Pilot PAC fund NaN \n", "394336 $500.00 Alaska Sea Pilot PAC Fund NaN \n", "\n", " Address City ... -------- \\\n", "50505 1621 Tongass Ave, Ste 300 Ketchikan ... NaN \n", "51557 1621 Tongass Ave. Ste. 300 Ketchikan ... NaN \n", "61585 1621 Tongass Avenue Ste. 300 Ketchikan ... NaN \n", "62351 1621 Tongass Ave Ketchikan ... NaN \n", "74155 1621 Tongass Ave Ketchikan ... NaN \n", "75904 1621 Tongass Avenue Ketchikan ... NaN \n", "77090 1621 Tongass Avenue, Suite 300 Ketchikan ... NaN \n", "77110 1621 Tongass Ave. Ketchikan ... NaN \n", "77259 1621 TONGASS AVE KETCHIKAN ... NaN \n", "77473 1621 Tongass Avenue Ketchikan ... NaN \n", "83512 1621 Tongass Ave Ketchikan ... NaN \n", "83824 1621 Tongass Ave. Ste. 300 Ketchikan ... NaN \n", "89576 1621 Tongass Avenue Ste. 300 Ketchikan ... NaN \n", "91019 1621 Tongass Ketchikan ... NaN \n", "91031 1621 Tongass Ave Ketchikan ... NaN \n", "91556 1621 Tongass Avenue, Suite 300 Ketchikan ... NaN \n", "92062 1621 Tongrass Ave Ketchikan ... NaN \n", "92508 1621 Tongass Ave Ste 300 Ketchikan ... NaN \n", "93756 1621 Tongass ave. Ketchikan ... NaN \n", "93896 1621 Tongass Ave Ketchikan ... NaN \n", "95996 1621 Tongass Ave. Ketchikan ... NaN \n", "96262 1621 Tongass Ave Ketchikan ... NaN \n", "96451 1621 Tongass Ave Ketchikan ... NaN \n", "97153 1621 Tongass Ave. Ketchikan ... NaN \n", "102146 1621 Tongass Ave Ketchikan ... NaN \n", "103895 1621 Tongass Avenue Ketchikan ... NaN \n", "105081 1621 Tongass Avenue, Suite 300 Ketchikan ... NaN \n", "105101 1621 Tongass Ave. Ketchikan ... NaN \n", "105250 1621 TONGASS AVE KETCHIKAN ... NaN \n", "105464 1621 Tongass Avenue Ketchikan ... NaN \n", "... ... ... ... ... \n", "366646 1621 Tongass Avenue Ketchikan ... NaN \n", "371350 1621 Tongass Avenue Ketchikan ... NaN \n", "371450 1621 Tongass Ave. Ketchikan ... NaN \n", "375262 1621 Tongass ave Ketchikan ... NaN \n", "380165 NaN NaN ... NaN \n", "380309 NaN NaN ... NaN \n", "380817 1621 Tongass Fund, Suite 300 Ketchikan ... NaN \n", "382147 1621 TONGASS AVE KETCHIKAN ... NaN \n", "382399 1621 Tongass Ave Ketchikan ... NaN \n", "383646 1621 Tongass Ave. Suite 300 Ketchican ... NaN \n", "384035 1621 Tongass Ave Ketchikan ... NaN \n", "384493 1621 TONGASS AVENUE KETCHIKAN ... NaN \n", "384629 1621 Tongass Ave Ketchikan ... NaN \n", "385218 1621 Tongass Avenue Ketchikan ... NaN \n", "385656 1621 Tongass Ave, Suit 300 Ketchikan ... NaN \n", "387266 1621 Tongass Avenue Ketchikan ... NaN \n", "387476 1621 Tongass Avenue Ste. 300 Ketchikan ... NaN \n", "387715 1621 Tongass Ave Ketchikan ... NaN \n", "387783 1621 Tongass Ave ste 300 Ketchikan ... NaN \n", "388013 1621 Tongass Ave Ketchikan ... NaN \n", "389046 1621 Tongass Ave Ketchikan ... NaN \n", "389085 1621 Tongass Ave Ketchikan ... NaN \n", "389117 1621 Tongass Ave Ketchikan ... NaN \n", "389256 1621 Tongass Ave Ketchikan ... NaN \n", "389400 1621 Tongass Ave Ketchikan ... NaN \n", "389470 1621 Tongass Ave. Ketchikan ... NaN \n", "389473 PO Box 920226 Dutch Harbor ... NaN \n", "393750 1621 Tongass Avenue Ketchikan ... NaN \n", "394209 1621 Tongass Ave. Ketchikan ... NaN \n", "394336 1621 Tongass Ave Ketchikan ... NaN \n", "\n", " Report Type Election Name Election Type \\\n", "50505 Year Start Report 2016 - State Primary Election State Primary \n", "51557 Year Start Report 2016 - State Primary Election State Primary \n", "61585 Year Start Report 2016 - State Primary Election State Primary \n", "62351 Year Start Report 2016 - State Primary Election State Primary \n", "74155 Year Start Report 2016 - State Primary Election State Primary \n", "75904 Thirty Day Report 2016 - State General Election State General \n", "77090 Thirty Day Report 2016 - State General Election State General \n", "77110 Seven Day Report 2016 - State General Election State General \n", "77259 Thirty Day Report 2016 - State General Election State General \n", "77473 Thirty Day Report 2016 - State General Election State General \n", "83512 Seven Day Report 2016 - State General Election State General \n", "83824 Seven Day Report 2016 - State General Election State General \n", "89576 Year Start Report 2016 - State Primary Election State Primary \n", "91019 Seven Day Report 2016 - State General Election State General \n", "91031 Seven Day Report 2016 - State General Election State General \n", "91556 Seven Day Report 2016 - State General Election State General \n", "92062 Thirty Day Report 2016 - State General Election State General \n", "92508 Year End Report 2016 - State General Election State General \n", "93756 Thirty Day Report 2016 - State General Election State General \n", "93896 Thirty Day Report 2016 - State General Election State General \n", "95996 Year Start Report 2016 - State Primary Election State Primary \n", "96262 Thirty Day Report 2016 - State General Election State General \n", "96451 Year Start Report 2016 - State Primary Election State Primary \n", "97153 Thirty Day Report 2016 - State General Election State General \n", "102146 Year Start Report 2016 - State Primary Election State Primary \n", "103895 Thirty Day Report 2016 - State General Election State General \n", "105081 Thirty Day Report 2016 - State General Election State General \n", "105101 Seven Day Report 2016 - State General Election State General \n", "105250 Thirty Day Report 2016 - State General Election State General \n", "105464 Thirty Day Report 2016 - State General Election State General \n", "... ... ... ... \n", "366646 Year End Report 2014 - State General Election State General \n", "371350 Year Start Report 2014 - State Primary Election State Primary \n", "371450 Thirty Day Report 2014 - State General Election State General \n", "375262 Seven Day Report 2014 - State General Election State General \n", "380165 24 Hour Report 2014 - State General Election State General \n", "380309 24 Hour Report 2014 - State General Election State General \n", "380817 Year Start Report 2014 - State Primary Election State Primary \n", "382147 Seven Day Report 2014 - State General Election State General \n", "382399 Year End Report 2014 - State General Election State General \n", "383646 Year End Report 2014 - State General Election State General \n", "384035 Seven Day Report 2014 - State Primary Election State Primary \n", "384493 Seven Day Report 2014 - State General Election State General \n", "384629 Seven Day Report 2014 - State General Election State General \n", "385218 Year End Report 2014 - State General Election State General \n", "385656 Year End Report 2014 - State General Election State General \n", "387266 Thirty Day Report 2014 - State General Election State General \n", "387476 Year End Report 2014 - State General Election State General \n", "387715 Year End Report 2014 - State General Election State General \n", "387783 Seven Day Report 2014 - State General Election State General \n", "388013 Seven Day Report 2014 - State General Election State General \n", "389046 Year End Report 2014 - State General Election State General \n", "389085 Seven Day Report 2014 - State General Election State General \n", "389117 Year End Report 2014 - State General Election State General \n", "389256 Seven Day Report 2014 - State General Election State General \n", "389400 Year End Report 2014 - State General Election State General \n", "389470 Year End Report 2014 - State General Election State General \n", "389473 Year End Report 2014 - State General Election State General \n", "393750 Year End Report 2014 - State General Election State General \n", "394209 Year Start Report 2014 - State Primary Election State Primary \n", "394336 Year Start Report 2014 - State Primary Election State Primary \n", "\n", " Municipality Office Filer Type \\\n", "50505 NaN House Candidate \n", "51557 NaN Senate Candidate \n", "61585 NaN House Candidate \n", "62351 NaN House Candidate \n", "74155 NaN House Candidate \n", "75904 NaN House Candidate \n", "77090 NaN House Candidate \n", "77110 NaN House Candidate \n", "77259 NaN House Candidate \n", "77473 NaN House Candidate \n", "83512 NaN House Candidate \n", "83824 NaN Senate Candidate \n", "89576 NaN House Candidate \n", "91019 NaN Senate Candidate \n", "91031 NaN House Candidate \n", "91556 NaN House Candidate \n", "92062 NaN Senate Candidate \n", "92508 NaN House Candidate \n", "93756 NaN House Candidate \n", "93896 NaN House Candidate \n", "95996 NaN Senate Candidate \n", "96262 NaN Senate Candidate \n", "96451 NaN House Candidate \n", "97153 NaN House Candidate \n", "102146 NaN House Candidate \n", "103895 NaN House Candidate \n", "105081 NaN House Candidate \n", "105101 NaN House Candidate \n", "105250 NaN House Candidate \n", "105464 NaN House Candidate \n", "... ... ... ... \n", "366646 NaN Governor / Lt. Governor Candidate \n", "371350 NaN Senate Candidate \n", "371450 NaN Senate Candidate \n", "375262 NaN House Candidate \n", "380165 NaN Senate Candidate \n", "380309 NaN House Candidate \n", "380817 NaN Senate Candidate \n", "382147 NaN NaN Candidate \n", "382399 NaN NaN Candidate \n", "383646 NaN House Candidate \n", "384035 NaN Senate Candidate \n", "384493 NaN NaN Candidate \n", "384629 NaN House Candidate \n", "385218 NaN Senate Candidate \n", "385656 NaN House Candidate \n", "387266 NaN House Candidate \n", "387476 NaN House Candidate \n", "387715 NaN House Candidate \n", "387783 NaN House Candidate \n", "388013 NaN House Candidate \n", "389046 NaN House Candidate \n", "389085 NaN House Candidate \n", "389117 NaN House Candidate \n", "389256 NaN Senate Candidate \n", "389400 NaN Senate Candidate \n", "389470 NaN House Candidate \n", "389473 NaN House Candidate \n", "393750 NaN House Candidate \n", "394209 NaN Senate Candidate \n", "394336 NaN House Candidate \n", "\n", " Name Report Year Submitted \n", "50505 Jonathan Kreiss-Tomkins 2016 6/13/2016 \n", "51557 Bert K. Stedman 2016 6/23/2016 \n", "61585 Sam S Kito III 2016 8/9/2016 \n", "62351 Neal Winston Foster 2016 8/28/2016 \n", "74155 Lynn Gattis 2016 10/9/2016 \n", "75904 Andrew \"Andy\" Josephson 2016 10/9/2016 \n", "77090 Cathy L. Tilton 2016 10/10/2016 \n", "77110 Dave Talerico 2016 10/31/2016 \n", "77259 Gary Allan Knopp 2016 10/10/2016 \n", "77473 cathy munoz 2016 10/10/2016 \n", "83512 Chris Birch 2016 11/1/2016 \n", "83824 Bert K. Stedman 2016 11/1/2016 \n", "89576 Sam S Kito III 2016 8/9/2016 \n", "91019 Donald \"Donny\" C. Olson 2016 11/1/2016 \n", "91031 Mark Neuman 2016 11/1/2016 \n", "91556 Zach Fansler 2016 11/1/2016 \n", "92062 David S. Wilson 2016 11/2/2016 \n", "92508 Jonathan Kreiss-Tomkins 2016 2/15/2017 \n", "93756 DeLena Johnson 2016 12/15/2016 \n", "93896 Ivy A Spohnholz 2016 12/19/2016 \n", "95996 Gary L. Stevens 2016 2/3/2016 \n", "96262 Shelley Hughes 2016 10/10/2016 \n", "96451 Shelley Hughes 2016 9/21/2016 \n", "97153 Geran Tarr 2016 10/10/2016 \n", "102146 Lynn Gattis 2016 10/9/2016 \n", "103895 Andrew \"Andy\" Josephson 2016 10/9/2016 \n", "105081 Cathy L. Tilton 2016 10/10/2016 \n", "105101 Dave Talerico 2016 10/31/2016 \n", "105250 Gary Allan Knopp 2016 10/10/2016 \n", "105464 cathy munoz 2016 10/10/2016 \n", "... ... ... ... \n", "366646 Walker Mallott for Alaska 2014 2/17/2015 \n", "371350 Peter Andrew Micciche 2014 2/17/2015 \n", "371450 Peter Andrew Micciche 2014 2/17/2015 \n", "375262 David Guttenberg 2014 4/13/2015 \n", "380165 Berta Gardner 2014 5/12/2015 \n", "380309 Wes Keller 2014 5/19/2015 \n", "380817 Bill Stoltze 2014 5/30/2015 \n", "382147 Click Bishop 2014 6/14/2015 \n", "382399 Gabrielle LeDoux 2014 7/11/2015 \n", "383646 Adam L. Wool 2014 6/29/2015 \n", "384035 Bill Stoltze 2014 6/30/2015 \n", "384493 Bryce Edgmon 2014 7/1/2015 \n", "384629 Geran Tarr 2014 7/1/2015 \n", "385218 Berta Gardner 2014 7/14/2015 \n", "385656 Jonathan Kreiss-Tomkins 2014 7/18/2015 \n", "387266 Cathy Munoz 2014 10/10/2015 \n", "387476 Benjamin P. Nageak \"Bennie\" 2014 10/21/2015 \n", "387715 Louise B. Stutes 2014 11/14/2015 \n", "387783 Sam S Kito III 2014 12/2/2015 \n", "388013 Dave M. Talerico 2014 12/9/2015 \n", "389046 Daniel H. Ortiz 2014 1/22/2016 \n", "389085 Mark Neuman 2014 2/9/2016 \n", "389117 Wes Keller 2014 2/13/2016 \n", "389256 Mia Costello 2014 2/15/2016 \n", "389400 Mia Costello 2014 2/15/2016 \n", "389470 Dave M. Talerico 2014 2/15/2016 \n", "389473 Dave M. Talerico 2014 2/15/2016 \n", "393750 Elizabeth (Liz) Vazquez 2014 2/15/2017 \n", "394209 Michael J. Dunleavy 2014 2/13/2014 \n", "394336 Shelley Hughes 2014 2/16/2014 \n", "\n", "[128 rows x 26 columns]" ] }, "execution_count": 101, "metadata": {}, "output_type": "execute_result" } ], "source": [ "def get_ratio(row):\n", " name = row['Last/Business Name']\n", " return fuzz.token_sort_ratio(name, \"Alaska Sea Pilot PAC Fund\")\n", "\n", "df[df.apply(get_ratio, axis=1) > 70]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "You could also do it using a lambda if you wanted" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df[df.apply(lambda row: fuzz.token_sort_ratio(row['Last/Business Name'], \"Alaska Sea Pilot PAC Fund\"), axis=1) > 70]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## We could technically clean it like below, but... it seems risky. Because it *is* risky!\n", "\n", "```python\n", "df.loc[df.apply(get_ratio, axis=1) > 75, \"Last/Business Name\"] = \"Alaska Sea Pilot PAC Fund\"\n", "```" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.1" } }, "nbformat": 4, "nbformat_minor": 2 }