nv2020.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "TODO:\n",
    "    - fix candidate names \n",
    "    - add rest of info\n",
    "    - check magnitude uncertainties with declan \n",
    "    - DONE: merge of candidates, district, party, office"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "\n",
    "path = 'raw'\n",
    "os.chdir(path)\n",
    "\n",
    "df = pd.read_csv('2020 General Election Precinct-Level Results.csv', encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop([0, 1, 182871])\n",
    "df = df.rename(columns={\"2020 Statewide General Election Results\": \"county_name\", \"Unnamed: 1\": \"precinct\", \"Unnamed: 2\": \"race\", \"Unnamed: 3\": \"candidate\", \"Unnamed: 4\": \"votes\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "cand = pd.read_excel('candidate_party_list.xlsx', index_col=None)  \n",
    "cand = cand.drop([27, 55, 83, 111, 139, 167, 195, 223, 251, 279, 307, 335, 362, 390, 418, 446, 474, 502, 530])\n",
    "cand = cand.rename(columns={\"Name as it Should Appear on the Ballot               (Last Name First)\": \"candidate\"})\n",
    "cand['candidate'] = cand['candidate'].str.upper()\n",
    "cand = cand.drop(['Filing Office', 'Last Name', 'First Name', 'Notes'], axis=1)\n",
    "cand = cand.replace(np.nan, '', regex = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['candidate'] = df['candidate'].str.upper()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['candidate'] = df['candidate'].replace({'BOSTA, JOHN': 'BOSTA, JOHN F.', \n",
    "                                           'HANSEN, ALEXIS': 'HANSEN, ALEXIS M.',\n",
    "                                           'HAFEN, II, GREGORY T.': 'HAFEN II, GREGORY T.',\n",
    "                                           'HAFEN II, GREGORY': 'HAFEN II, GREGORY T.',\n",
    "                                           'RUBINSON, BARRY': 'RUBINSON, BARRY L.',\n",
    "                                           'BUCK, CARRIE': 'BUCK, CARRIE ANN',\n",
    "                                           'CANNIZZARO, NICOLE': 'CANNIZZARO, NICOLE JEANETTE',\n",
    "                                           'DURAN, BEATRICE': 'DURAN, BEATRICE A.',\n",
    "                                           'JONES, TIERRA': 'JONES, TIERRA D.',\n",
    "                                           'HAFEN II, GREGORY': 'HAFEN, II, GREGORY T.',\n",
    "                                           'BURTON, REBECCA': 'BURTON, REBECCA L.',\n",
    "                                           'JOHNSON, SUSAN': 'JOHNSON, SUSAN HOLLAND',\n",
    "                                           'KISHNER, JOANNA': 'KISHNER, JOANNA S.',\n",
    "                                           'BELLONA, WM \"JOHN\"': 'WM \"JOHN\" BELLONA',\n",
    "                                           'STURMAN, GLORIA': 'STURMAN, GLORIA J.',\n",
    "                                           'ALLF, NANCY': 'ALLF, NANCY L.',\n",
    "                                           'GREGORY, THOMAS W.': 'THOMAS W GREGORY',\n",
    "                                           'YOUNG, TOD': 'TOD YOUNG',\n",
    "                                           'CAFFERATA-JENKINS, CAREN': 'CAREN CAFFERATA-JENKINS',\n",
    "                                           'MONTERO, MICHAEL': 'MONTERO, MICHAEL R.',\n",
    "                                           'ABERASTURI, LEON': 'ABERASTURI LEON',\n",
    "                                           'STEINHEIMER, CONNIE': 'STEINHEIMER, CONNIE J.',\n",
    "                                           'PETERS, SARAH': 'PETERS, SARAH C',\n",
    "                                           'GANSERT, HEIDI S.': 'GANSERT, HEIDI SEEVERS',\n",
    "                                           'WARD, JENNIFER M.': 'JENNIFER M. WARD',\n",
    "                                           'GILES, MICHAEL R.': 'MICHAEL R. GILES',\n",
    "                                           'PORTMAN, JOHN J.T.': 'JOHN J.T. PORTMAN',\n",
    "                                           'PILON, MARK W.': 'MARK W. PILON',\n",
    "                                           'MACHADO, KEVIN E.': 'KEVIN E. MACHADO',\n",
    "                                           'LIST, JAMES \"JIM\"': 'JAMES \"JIM\" LIST',\n",
    "                                           'KNIGHT, SHERRY LYNN': 'SHERRY LYNN KNIGHT',\n",
    "                                           'CARRUTH, MARCI': 'MARCI CARRUTH',\n",
    "                                           'RACKLEY, LARRY': 'LARRY RACKLEY',\n",
    "                                           'HUDSON, SHAYLA': 'SHAYLA HUDSON'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.merge(df, cand, on = ['candidate'], \n",
    "             how = 'left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "not in df at all: \n",
    "PAUL R. SCHLEHR\n",
    "GIOCOECHEA, JJ"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['district'] = df['race']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.rename(columns={\"Party Affiliation\": \"party\"})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.replace(np.nan, '', regex = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['party'] = df['party'].replace({'': 'NO PARTY'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['party_detailed'] = df['party'].replace({'NO POLITICAL PARTY': 'INDEPENDENT',\n",
    "                                                     'IAP': 'INDEPENDENT',\n",
    "                                                     'Independent': 'INDEPENDENT',\n",
    "                                                     'INDEPENDENT AMERICAN': 'INDEPENDENT',\n",
    "                                                     'Independent American': 'INDEPENDENT',\n",
    "                                                     'NonPartisan': 'NONPARTISAN',\n",
    "                                                     'Non-Partisan': 'NONPARTISAN',\n",
    "                                                     'NON-PARTISAN': 'NONPARTISAN',\n",
    "                                                     'NP': 'NONPARTISAN',\n",
    "                                                     'Nonpartisan': 'NONPARTISAN',\n",
    "                                                     'Democrat': 'DEMOCRAT',\n",
    "                                                     'DEMOCRATIC': 'DEMOCRAT',\n",
    "                                                     'DEM': 'DEMOCRAT',\n",
    "                                                     'Democratic': 'DEMOCRAT',\n",
    "                                                     'Libertarian': 'LIBERTARIAN',\n",
    "                                                     'Republican': 'REPUBLICAN',\n",
    "                                                     'REP': 'REPUBLICAN'})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[((df.candidate == 'NO') & (df.party_detailed == 'NO PARTY')), 'party_detailed'] = ''\n",
    "df.loc[((df.candidate == 'YES') & (df.party_detailed == 'NO PARTY')), 'party_detailed'] = ''\n",
    "\n",
    "df.loc[df.party_detailed == 'NO PARTY', 'party_detailed'] = 'NONPARTISAN'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['party_simplified'] = df['party_detailed'].replace({'INDEPENDENT': 'OTHER'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop(['Office Sought', 'party'], axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "***MAGNITUDE***\n",
    "\n",
    "'TOPAZ RANCH ESTATES GENERAL IMPROVEMENT DISTRICT (One, 4 Year Term and One 2 Year-Unexpired Term)' (mag 2?)\n",
    "'SKYLAND GENERAL IMPROVEMENT DISTRICT (Three, 4 Year Terms and Two, 2 Year-Unexpired Terms)' (mag 5?)\n",
    "Elko City Council, 2 Seats (may want to check for magnitude change to 2)\n",
    "Carlin City Council, 2 Seats (mag 2? )\n",
    "WELLS CITY COUNCIL, 3 SEATS \n",
    "WEST WENDOVER CITY COUNCIL, SEATS 3 AND 4\n",
    "\n",
    "SCHOOL DISTRICT TRUSTEE  **SEAT 1A, 1B, 1C, D**\n",
    "CITY COUNCIL, SEAT 5\n",
    "COUNTY COMMISSIONER **SEAT A, B, 2, 3, 4**\n",
    "PERSHING COUNTY SCHOOL DISTRICT TRUSTEE, SEAT E\n",
    "RENO CITY COUNCIL, AT-LARGE\n",
    "HOSPITAL DISTRICT TRUSTEE **SEAT 3, 5**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "def cleanDistrict(x):\n",
    "    if ',' in x and '(' not in x:  \n",
    "        index = x.index(',')\n",
    "        return x[index+2:]\n",
    "    else: \n",
    "        if 'President' in x or 'QUESTION' in x:\n",
    "            return 'STATEWIDE'\n",
    "        if 'District' in x and ('Water District' not in x and 'Improvement District' not in x and 'Sanitation District' not in x): \n",
    "            if 'Overton Power District 5 Mesquite' in x: \n",
    "                return '5'\n",
    "            else: \n",
    "                index = x.index('District')\n",
    "                return x[index+9]\n",
    "        if 'DISTRICT' in x and 'DISTRICT DIRECTOR' not in x and 'WATER DISTRICT TRUSTEE' not in x:\n",
    "            if 'SEAT' in x:\n",
    "                index = x.index('SEAT')\n",
    "                return x[index:]\n",
    "            else: \n",
    "                index = x.index('DISTRICT')\n",
    "                return x[index+9:]\n",
    "        if 'Department' in x or 'DEPARTMENT' in x or 'SEAT' in x or 'Seat' in x: \n",
    "                if 'Department' in x: \n",
    "                    index = x.index('Department')\n",
    "                    return x[index:]\n",
    "                elif 'DEPARTMENT' in x: \n",
    "                    index = x.index('DEPARTMENT')\n",
    "                    return x[index:]\n",
    "                elif 'SEAT' in x:\n",
    "                    index = x.index('SEAT')\n",
    "                    return x[index:]\n",
    "                else: \n",
    "                    index = x.index('Seat')\n",
    "                    return x[index:]\n",
    "        else: \n",
    "            return ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['district'] = df['district'].apply(cleanDistrict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "def cleanDistrict2(x):\n",
    "    if len(x) <=11 and ('District' in x or 'DISTRICT' in x):\n",
    "        x = x[-2:].strip()\n",
    "        if any(char.isdigit() for char in x):\n",
    "            return x.zfill(3)\n",
    "        else:\n",
    "            return x\n",
    "    elif 'Dist.' in x:\n",
    "        x = x[-1:]\n",
    "        return x.zfill(3)\n",
    "    else: \n",
    "        if '(One, 4 Year Term and One 2 Year-Unexpired Term)' in x or '(Three, 4 Year Terms and Two, 2 Year-Unexpired Terms)' in x:\n",
    "            return ''\n",
    "        elif 'CITY OF FERNLEY' in x:\n",
    "            index = x.index('WARD')\n",
    "            return x[index:]\n",
    "        else:\n",
    "            return x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['district'] = df['district'].apply(cleanDistrict2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['magnitude'] = 1\n",
    "df.loc[df['district'].str.contains('2 Seats'), 'magnitude'] = 2\n",
    "df.loc[df['district'].str.contains('3 SEATS'), 'magnitude'] = 3\n",
    "df.loc[df['district'].str.contains('SEATS 3 AND 4'), 'magnitude'] = 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/jennifermiranda/opt/anaconda3/lib/python3.8/site-packages/pandas/core/strings.py:1954: UserWarning: This pattern has match groups. To actually get the groups, use str.extract.\n",
      "  return func(self, *args, **kwargs)\n"
     ]
    }
   ],
   "source": [
    "df.loc[df['race'].str.contains('TOPAZ RANCH ESTATES GENERAL IMPROVEMENT DISTRICT (One, 4 Year Term and One 2 Year-Unexpired Term)'), 'magnitude'] = 2\n",
    "df.loc[df['race'].str.contains('SKYLAND GENERAL IMPROVEMENT DISTRICT (Three, 4 Year Terms and Two, 2 Year-Unexpired Terms)'), 'magnitude'] = 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"district\"] = df[\"district\"].str.replace('Dept.', 'Department', regex=True)\n",
    "\n",
    "df['district'] = df['district'].replace({\"2 Seats\": \"\"})\n",
    "df['district'] = df['district'].replace({\"3 SEATS\": \"\"})\n",
    "df['district'] = df['district'].replace({\"SEATS 3 AND 4\": \"\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"candidate\"] = df[\"candidate\"].str.replace('.', '', regex=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "def cleanCand(x):\n",
    "    if ', ' in x:\n",
    "        index = x.index(', ')\n",
    "        return x[index+2:] + ' ' + x[:index]\n",
    "    else:\n",
    "        return x\n",
    "    \n",
    "df['candidate'] = df['candidate'].apply(cleanCand)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "def cleanCand2(x):\n",
    "    if ', ' in x:\n",
    "        index = x.index(', ')\n",
    "        return x[index+2:] + ' ' + x[:index]\n",
    "    elif 'DAVID LÓPEZ-NEGRETE' in x:\n",
    "        return 'DAVID LOPEZ-NEGRETE'\n",
    "    elif 'CECELIA GONZÁLEZ' in x:\n",
    "        return 'CECELIA GONZALEZ'\n",
    "    else:\n",
    "        return x\n",
    "    \n",
    "df['candidate'] = df['candidate'].apply(cleanCand2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "def cleanOffice(x): \n",
    "    if ',' in x:\n",
    "        if '(' not in x:\n",
    "            index = x.index(',')\n",
    "            return x[:index]\n",
    "        else: \n",
    "            index = x.index('(')\n",
    "            return x[:index-1]\n",
    "    else:\n",
    "        if 'School' in x:\n",
    "            return 'SCHOOL BOARD OF TRUSTEES'\n",
    "        elif 'President' in x:\n",
    "            return 'US PRESIDENT'\n",
    "        elif 'County Commissioner' in x or 'COUNTY COMMISSIONER' in x:\n",
    "            return 'COUNTY COMMISSIONER'\n",
    "        elif 'Board' in x:\n",
    "            if 'Advisory' in x:\n",
    "                return 'TOWN ADVISORY BOARD'\n",
    "            else:\n",
    "                return 'TOWN BOARD'\n",
    "        elif 'Mayor' in x or 'MAYOR' in x:\n",
    "            return 'MAYOR'\n",
    "        else:\n",
    "            return x.upper()\n",
    "\n",
    "df['office'] = df['race'].apply(cleanOffice)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "def cleanOffice2(x): \n",
    "    if 'U.S. Representative in Congress' in x:\n",
    "            x = 'US HOUSE'\n",
    "    if 'State Assembly' in x:\n",
    "        x = 'STATE HOUSE'\n",
    "    if 'SEAT' in x: \n",
    "        i = x.index('SEAT')\n",
    "        if '-' in x: \n",
    "            j = x.index('-')\n",
    "            x = x[:j-1]\n",
    "        else: \n",
    "            x = x[:i-1]\n",
    "    if 'DEPARTMENT' in x: \n",
    "        k = x.index(\"DEPARTMENT\")\n",
    "        x = x[:k-1]\n",
    "    if '- 4 YEAR' in x: \n",
    "        l = x.index(\"- 4 YEAR\")\n",
    "        x = x[:l-1]\n",
    "    else:\n",
    "        return x.upper()\n",
    "    return x.upper()\n",
    "      \n",
    "df['office'] = df['office'].apply(cleanOffice2)\n",
    "df = df.drop(['race'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"state\"] = 'NEVADA'\n",
    "df[\"state_po\"] = 'NV'\n",
    "df[\"state_fips\"] = '32'\n",
    "df[\"state_cen\"] = '88'\n",
    "df[\"state_ic\"] = '65'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"stage\"] = \"GEN\"\n",
    "df[\"date\"] = \"2020-11-03\"\n",
    "df[\"year\"] = \"2020\"\n",
    "\n",
    "df[\"mode\"] = \"TOTAL\"\n",
    "\n",
    "df[\"special\"] = \"FALSE\"\n",
    "df[\"writein\"] = \"FALSE\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "# After county name fix, append on fips codes\n",
    "fips = pd.read_csv('/Users/jennifermiranda/Documents/GitHub/2020-precincts/help-files/county-fips-codes.csv')\n",
    "\n",
    "fips['state'] = fips['state'].str.upper()\n",
    "fips = fips.applymap(str)\n",
    "df['county_name'] = df['county_name'].str.upper()\n",
    "df=df.applymap(lambda x: x.strip() if type(x)==str else x)\n",
    "df = pd.merge(df, fips, on = ['state','county_name'], \n",
    "             how = 'left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['jurisdiction_name'] = df['county_name']\n",
    "df['jurisdiction_fips'] = df['county_fips']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "def getDataverse(x):\n",
    "    if 'US PRESIDENT' in x:\n",
    "        return \"PRESIDENT\"\n",
    "    elif \"US HOUSE\" in x:\n",
    "        return \"HOUSE\"\n",
    "    elif 'STATE ' in x:\n",
    "        return 'STATE'\n",
    "    elif 'BALLOTS' in x or 'REGISTERED' in x:\n",
    "        return ''\n",
    "    elif 'SUPREME COURT JUSTICE' in x or 'STATE SENATE' in x or 'COURT OF APPEALS JUDGE' in x or 'DISTRICT COURT JUDGE' in x or 'UNIVERSITY BOARD OF REGENTS' in x:\n",
    "        return 'STATE'\n",
    "    else: \n",
    "        return 'LOCAL'\n",
    "    \n",
    "df['dataverse'] = df['office'].apply(getDataverse)\n",
    "df['dataverse'] = df['dataverse'].str.replace('\\s+', ' ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "#QA Corrections \n",
    "df.loc[df['office'].str.contains('SCHOOL'), 'office'] = 'SCHOOL BOARD OF TRUSTEES'\n",
    "df.loc[df['office'].str.contains('COMMISSION'), 'office'] = 'COUNTY COMMISSIONER'\n",
    "df[\"office\"] = df[\"office\"].str.replace('COUNCILMEMBER', 'CITY COUNCIL')\n",
    "df.loc[df['votes'] == '*', 'votes'] = -1\n",
    "df.loc[df['office'].str.contains('JUSTICE OF THE PEACE NORTH LAS VEGAS TWNSH'), 'district'] = 'NORTH LAS VEGAS TWNSH TOWNSHIP, DEPARTMENT 3'\n",
    "df.loc[df['office'].str.contains('JUSTICE OF THE PEACE NORTH LAS VEGAS TWNSH'), 'office'] = 'JUSTICE OF THE PEACE'\n",
    "df.loc[df['office'].str.contains('JUSTICE OF THE PEACE PAHRUMP'), 'district'] = 'PAHRUMP TOWNSHIP, DEPARTMENT B'\n",
    "df.loc[df['office'].str.contains('JUSTICE OF THE PEACE PAHRUMP'), 'office'] = 'JUSTICE OF THE PEACE'\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "#QA Corrections #2\n",
    "# Readme Check \n",
    "df[\"readme_check\"] = \"FALSE\"\n",
    "df.loc[df['votes'] == -1, 'readme_check'] = 'TRUE'\n",
    "df['district'] = df['district'].replace({'1': '001',\n",
    "                                        '2': '002',\n",
    "                                        '3': '003',\n",
    "                                        '4': '004',\n",
    "                                        '5': '005'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "def QACleanDis(x):\n",
    "    if 'District' in x:\n",
    "        comma = x.index(',')\n",
    "        space = x.index(' ')\n",
    "        if comma == 10:\n",
    "            return '00' + x[space+1:comma+1] + x[comma+1:]\n",
    "        else: \n",
    "            return '0' + x[space+1:comma+1] + x[comma+1:]\n",
    "    else:\n",
    "        return x\n",
    "\n",
    "df['district'] = df['district'].apply(QACleanDis)\n",
    "df.district = df.district.str.replace(' +', ' ')\n",
    "df[\"district\"] = df[\"district\"].str.upper()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Final step: Remove all trailing white space and put columns in correct order. \n",
    "df=df.applymap(lambda x: x.strip() if type(x)==str else x)\n",
    "\n",
    "df=df[[\"precinct\", \"office\", \"party_detailed\", \"party_simplified\", \"mode\", \"votes\", \"county_name\", \"county_fips\", \"jurisdiction_name\",\n",
    "                      \"jurisdiction_fips\", \"candidate\", \"district\", \"dataverse\", \"year\", \"stage\", \"state\", \"special\", \"writein\", \"state_po\",\n",
    "                      \"state_fips\", \"state_cen\", \"state_ic\", \"date\", \"readme_check\", \"magnitude\"]]\n",
    "\n",
    "df=df.set_index('precinct')\n",
    "\n",
    "df.to_csv('2020-nv-precinct-general.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>office</th>\n",
       "      <th>party_detailed</th>\n",
       "      <th>party_simplified</th>\n",
       "      <th>mode</th>\n",
       "      <th>votes</th>\n",
       "      <th>county_name</th>\n",
       "      <th>county_fips</th>\n",
       "      <th>jurisdiction_name</th>\n",
       "      <th>jurisdiction_fips</th>\n",
       "      <th>candidate</th>\n",
       "      <th>...</th>\n",
       "      <th>state</th>\n",
       "      <th>special</th>\n",
       "      <th>writein</th>\n",
       "      <th>state_po</th>\n",
       "      <th>state_fips</th>\n",
       "      <th>state_cen</th>\n",
       "      <th>state_ic</th>\n",
       "      <th>date</th>\n",
       "      <th>readme_check</th>\n",
       "      <th>magnitude</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>precinct</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>BOARD OF SUPERVISORS</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>532</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>MAURICE \"MO\" WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>BOARD OF SUPERVISORS</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>467</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>STACIE WILKE-MCCULLOCH</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>COURT OF APPEALS JUDGE</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>402</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>BONNIE BULLA</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>COURT OF APPEALS JUDGE</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>367</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>SUSAN BUSH</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>COURT OF APPEALS JUDGE</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>230</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>CARSON CITY</td>\n",
       "      <td>32510</td>\n",
       "      <td>NONE OF THESE CANDIDATES</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precinct 9</th>\n",
       "      <td>SUPREME COURT JUSTICE</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>57</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>DOUGLAS HERNDON</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precinct 9</th>\n",
       "      <td>SUPREME COURT JUSTICE</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>15</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>NONE OF THESE CANDIDATES</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precinct 9</th>\n",
       "      <td>US HOUSE</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>68</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>STEVEN A HORSFORD</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precinct 9</th>\n",
       "      <td>US HOUSE</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>64</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>JIM MARCHANT</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precinct 9</th>\n",
       "      <td>US HOUSE</td>\n",
       "      <td>INDEPENDENT</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>1</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>WHITE PINE</td>\n",
       "      <td>32033</td>\n",
       "      <td>BARRY L RUBINSON</td>\n",
       "      <td>...</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>NV</td>\n",
       "      <td>32</td>\n",
       "      <td>88</td>\n",
       "      <td>65</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95178 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            office party_detailed party_simplified   mode  \\\n",
       "precinct                                                                    \n",
       "101           BOARD OF SUPERVISORS    NONPARTISAN      NONPARTISAN  TOTAL   \n",
       "101           BOARD OF SUPERVISORS    NONPARTISAN      NONPARTISAN  TOTAL   \n",
       "101         COURT OF APPEALS JUDGE    NONPARTISAN      NONPARTISAN  TOTAL   \n",
       "101         COURT OF APPEALS JUDGE    NONPARTISAN      NONPARTISAN  TOTAL   \n",
       "101         COURT OF APPEALS JUDGE    NONPARTISAN      NONPARTISAN  TOTAL   \n",
       "...                            ...            ...              ...    ...   \n",
       "Precinct 9   SUPREME COURT JUSTICE    NONPARTISAN      NONPARTISAN  TOTAL   \n",
       "Precinct 9   SUPREME COURT JUSTICE    NONPARTISAN      NONPARTISAN  TOTAL   \n",
       "Precinct 9                US HOUSE       DEMOCRAT         DEMOCRAT  TOTAL   \n",
       "Precinct 9                US HOUSE     REPUBLICAN       REPUBLICAN  TOTAL   \n",
       "Precinct 9                US HOUSE    INDEPENDENT            OTHER  TOTAL   \n",
       "\n",
       "           votes  county_name county_fips jurisdiction_name jurisdiction_fips  \\\n",
       "precinct                                                                        \n",
       "101          532  CARSON CITY       32510       CARSON CITY             32510   \n",
       "101          467  CARSON CITY       32510       CARSON CITY             32510   \n",
       "101          402  CARSON CITY       32510       CARSON CITY             32510   \n",
       "101          367  CARSON CITY       32510       CARSON CITY             32510   \n",
       "101          230  CARSON CITY       32510       CARSON CITY             32510   \n",
       "...          ...          ...         ...               ...               ...   \n",
       "Precinct 9    57   WHITE PINE       32033        WHITE PINE             32033   \n",
       "Precinct 9    15   WHITE PINE       32033        WHITE PINE             32033   \n",
       "Precinct 9    68   WHITE PINE       32033        WHITE PINE             32033   \n",
       "Precinct 9    64   WHITE PINE       32033        WHITE PINE             32033   \n",
       "Precinct 9     1   WHITE PINE       32033        WHITE PINE             32033   \n",
       "\n",
       "                           candidate  ...   state special writein state_po  \\\n",
       "precinct                              ...                                    \n",
       "101               MAURICE \"MO\" WHITE  ...  NEVADA   FALSE   FALSE       NV   \n",
       "101           STACIE WILKE-MCCULLOCH  ...  NEVADA   FALSE   FALSE       NV   \n",
       "101                     BONNIE BULLA  ...  NEVADA   FALSE   FALSE       NV   \n",
       "101                       SUSAN BUSH  ...  NEVADA   FALSE   FALSE       NV   \n",
       "101         NONE OF THESE CANDIDATES  ...  NEVADA   FALSE   FALSE       NV   \n",
       "...                              ...  ...     ...     ...     ...      ...   \n",
       "Precinct 9           DOUGLAS HERNDON  ...  NEVADA   FALSE   FALSE       NV   \n",
       "Precinct 9  NONE OF THESE CANDIDATES  ...  NEVADA   FALSE   FALSE       NV   \n",
       "Precinct 9         STEVEN A HORSFORD  ...  NEVADA   FALSE   FALSE       NV   \n",
       "Precinct 9              JIM MARCHANT  ...  NEVADA   FALSE   FALSE       NV   \n",
       "Precinct 9          BARRY L RUBINSON  ...  NEVADA   FALSE   FALSE       NV   \n",
       "\n",
       "           state_fips state_cen state_ic        date readme_check magnitude  \n",
       "precinct                                                                     \n",
       "101                32        88       65  2020-11-03        FALSE         1  \n",
       "101                32        88       65  2020-11-03        FALSE         1  \n",
       "101                32        88       65  2020-11-03        FALSE         1  \n",
       "101                32        88       65  2020-11-03        FALSE         1  \n",
       "101                32        88       65  2020-11-03        FALSE         1  \n",
       "...               ...       ...      ...         ...          ...       ...  \n",
       "Precinct 9         32        88       65  2020-11-03        FALSE         1  \n",
       "Precinct 9         32        88       65  2020-11-03        FALSE         1  \n",
       "Precinct 9         32        88       65  2020-11-03        FALSE         1  \n",
       "Precinct 9         32        88       65  2020-11-03        FALSE         1  \n",
       "Precinct 9         32        88       65  2020-11-03        FALSE         1  \n",
       "\n",
       "[95178 rows x 24 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>county_name</th>\n",
       "      <th>precinct</th>\n",
       "      <th>candidate</th>\n",
       "      <th>votes</th>\n",
       "      <th>district</th>\n",
       "      <th>party_detailed</th>\n",
       "      <th>party_simplified</th>\n",
       "      <th>magnitude</th>\n",
       "      <th>office</th>\n",
       "      <th>state</th>\n",
       "      <th>...</th>\n",
       "      <th>stage</th>\n",
       "      <th>date</th>\n",
       "      <th>year</th>\n",
       "      <th>mode</th>\n",
       "      <th>special</th>\n",
       "      <th>writein</th>\n",
       "      <th>county_fips</th>\n",
       "      <th>jurisdiction_name</th>\n",
       "      <th>jurisdiction_fips</th>\n",
       "      <th>dataverse</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2074</th>\n",
       "      <td>CLARK</td>\n",
       "      <td>1038</td>\n",
       "      <td>SHANON CLOWERS-SANBORN</td>\n",
       "      <td>52</td>\n",
       "      <td>LAS VEGAS TWNSH DEPARTMENT 12</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32003</td>\n",
       "      <td>CLARK</td>\n",
       "      <td>32003</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2075</th>\n",
       "      <td>CLARK</td>\n",
       "      <td>1038</td>\n",
       "      <td>DIANA L SULLIVAN</td>\n",
       "      <td>237</td>\n",
       "      <td>LAS VEGAS TWNSH DEPARTMENT 12</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32003</td>\n",
       "      <td>CLARK</td>\n",
       "      <td>32003</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2208</th>\n",
       "      <td>CLARK</td>\n",
       "      <td>1039</td>\n",
       "      <td>SHANON CLOWERS-SANBORN</td>\n",
       "      <td>112</td>\n",
       "      <td>LAS VEGAS TWNSH DEPARTMENT 12</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32003</td>\n",
       "      <td>CLARK</td>\n",
       "      <td>32003</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2209</th>\n",
       "      <td>CLARK</td>\n",
       "      <td>1039</td>\n",
       "      <td>DIANA L SULLIVAN</td>\n",
       "      <td>502</td>\n",
       "      <td>LAS VEGAS TWNSH DEPARTMENT 12</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32003</td>\n",
       "      <td>CLARK</td>\n",
       "      <td>32003</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2342</th>\n",
       "      <td>CLARK</td>\n",
       "      <td>1063</td>\n",
       "      <td>SHANON CLOWERS-SANBORN</td>\n",
       "      <td>206</td>\n",
       "      <td>LAS VEGAS TWNSH DEPARTMENT 12</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32003</td>\n",
       "      <td>CLARK</td>\n",
       "      <td>32003</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168460</th>\n",
       "      <td>NYE</td>\n",
       "      <td>PAHRUMP 30</td>\n",
       "      <td>KENT JASPERSON</td>\n",
       "      <td>645</td>\n",
       "      <td>PAHRUMP TOWNSHIP, DEPARTMENT B</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32023</td>\n",
       "      <td>NYE</td>\n",
       "      <td>32023</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168517</th>\n",
       "      <td>NYE</td>\n",
       "      <td>PAHRUMP 31</td>\n",
       "      <td>WALT GRUDZINSKI</td>\n",
       "      <td>399</td>\n",
       "      <td>PAHRUMP TOWNSHIP, DEPARTMENT B</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32023</td>\n",
       "      <td>NYE</td>\n",
       "      <td>32023</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168518</th>\n",
       "      <td>NYE</td>\n",
       "      <td>PAHRUMP 31</td>\n",
       "      <td>KENT JASPERSON</td>\n",
       "      <td>769</td>\n",
       "      <td>PAHRUMP TOWNSHIP, DEPARTMENT B</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32023</td>\n",
       "      <td>NYE</td>\n",
       "      <td>32023</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168576</th>\n",
       "      <td>NYE</td>\n",
       "      <td>PAHRUMP 32</td>\n",
       "      <td>WALT GRUDZINSKI</td>\n",
       "      <td>545</td>\n",
       "      <td>PAHRUMP TOWNSHIP, DEPARTMENT B</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32023</td>\n",
       "      <td>NYE</td>\n",
       "      <td>32023</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168577</th>\n",
       "      <td>NYE</td>\n",
       "      <td>PAHRUMP 32</td>\n",
       "      <td>KENT JASPERSON</td>\n",
       "      <td>948</td>\n",
       "      <td>PAHRUMP TOWNSHIP, DEPARTMENT B</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>NONPARTISAN</td>\n",
       "      <td>1</td>\n",
       "      <td>JUSTICE OF THE PEACE</td>\n",
       "      <td>NEVADA</td>\n",
       "      <td>...</td>\n",
       "      <td>GEN</td>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>2020</td>\n",
       "      <td>TOTAL</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>32023</td>\n",
       "      <td>NYE</td>\n",
       "      <td>32023</td>\n",
       "      <td>LOCAL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1888 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       county_name    precinct               candidate votes  \\\n",
       "2074         CLARK        1038  SHANON CLOWERS-SANBORN    52   \n",
       "2075         CLARK        1038        DIANA L SULLIVAN   237   \n",
       "2208         CLARK        1039  SHANON CLOWERS-SANBORN   112   \n",
       "2209         CLARK        1039        DIANA L SULLIVAN   502   \n",
       "2342         CLARK        1063  SHANON CLOWERS-SANBORN   206   \n",
       "...            ...         ...                     ...   ...   \n",
       "168460         NYE  PAHRUMP 30          KENT JASPERSON   645   \n",
       "168517         NYE  PAHRUMP 31         WALT GRUDZINSKI   399   \n",
       "168518         NYE  PAHRUMP 31          KENT JASPERSON   769   \n",
       "168576         NYE  PAHRUMP 32         WALT GRUDZINSKI   545   \n",
       "168577         NYE  PAHRUMP 32          KENT JASPERSON   948   \n",
       "\n",
       "                              district party_detailed party_simplified  \\\n",
       "2074     LAS VEGAS TWNSH DEPARTMENT 12    NONPARTISAN      NONPARTISAN   \n",
       "2075     LAS VEGAS TWNSH DEPARTMENT 12    NONPARTISAN      NONPARTISAN   \n",
       "2208     LAS VEGAS TWNSH DEPARTMENT 12    NONPARTISAN      NONPARTISAN   \n",
       "2209     LAS VEGAS TWNSH DEPARTMENT 12    NONPARTISAN      NONPARTISAN   \n",
       "2342     LAS VEGAS TWNSH DEPARTMENT 12    NONPARTISAN      NONPARTISAN   \n",
       "...                                ...            ...              ...   \n",
       "168460  PAHRUMP TOWNSHIP, DEPARTMENT B    NONPARTISAN      NONPARTISAN   \n",
       "168517  PAHRUMP TOWNSHIP, DEPARTMENT B    NONPARTISAN      NONPARTISAN   \n",
       "168518  PAHRUMP TOWNSHIP, DEPARTMENT B    NONPARTISAN      NONPARTISAN   \n",
       "168576  PAHRUMP TOWNSHIP, DEPARTMENT B    NONPARTISAN      NONPARTISAN   \n",
       "168577  PAHRUMP TOWNSHIP, DEPARTMENT B    NONPARTISAN      NONPARTISAN   \n",
       "\n",
       "        magnitude                office   state  ... stage        date  year  \\\n",
       "2074            1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "2075            1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "2208            1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "2209            1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "2342            1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "...           ...                   ...     ...  ...   ...         ...   ...   \n",
       "168460          1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "168517          1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "168518          1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "168576          1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "168577          1  JUSTICE OF THE PEACE  NEVADA  ...   GEN  2020-11-03  2020   \n",
       "\n",
       "         mode special writein county_fips jurisdiction_name jurisdiction_fips  \\\n",
       "2074    TOTAL   FALSE   FALSE       32003             CLARK             32003   \n",
       "2075    TOTAL   FALSE   FALSE       32003             CLARK             32003   \n",
       "2208    TOTAL   FALSE   FALSE       32003             CLARK             32003   \n",
       "2209    TOTAL   FALSE   FALSE       32003             CLARK             32003   \n",
       "2342    TOTAL   FALSE   FALSE       32003             CLARK             32003   \n",
       "...       ...     ...     ...         ...               ...               ...   \n",
       "168460  TOTAL   FALSE   FALSE       32023               NYE             32023   \n",
       "168517  TOTAL   FALSE   FALSE       32023               NYE             32023   \n",
       "168518  TOTAL   FALSE   FALSE       32023               NYE             32023   \n",
       "168576  TOTAL   FALSE   FALSE       32023               NYE             32023   \n",
       "168577  TOTAL   FALSE   FALSE       32023               NYE             32023   \n",
       "\n",
       "       dataverse  \n",
       "2074       LOCAL  \n",
       "2075       LOCAL  \n",
       "2208       LOCAL  \n",
       "2209       LOCAL  \n",
       "2342       LOCAL  \n",
       "...          ...  \n",
       "168460     LOCAL  \n",
       "168517     LOCAL  \n",
       "168518     LOCAL  \n",
       "168576     LOCAL  \n",
       "168577     LOCAL  \n",
       "\n",
       "[1888 rows x 24 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "index = df[df.office.str.contains('JUSTICE OF THE PEACE')]\n",
    "index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "LAS VEGAS TWNSH DEPARTMENT 12\n",
      "NORTH LAS VEGAS TWNSH TOWNSHIP, DEPARTMENT 3\n",
      "PAHRUMP TOWNSHIP, DEPARTMENT B\n"
     ]
    }
   ],
   "source": [
    "for x in index['district'].unique():\n",
    "    #if 'PEACE' in x: \n",
    "        print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WARD 2\n",
      "DEPARTMENT 3\n",
      "001, DEPARTMENT 1\n",
      "001, DEPARTMENT 2\n",
      "STATEWIDE\n",
      "007\n",
      "040\n",
      "SEAT B\n",
      "SEAT D\n",
      "002\n",
      "\n",
      "001\n",
      "003\n",
      "010\n",
      "038\n",
      "A\n",
      "008, DEPARTMENT 1\n",
      "008, DEPARTMENT 2\n",
      "008, DEPARTMENT 3\n",
      "008, DEPARTMENT 4\n",
      "008, DEPARTMENT 5\n",
      "008, DEPARTMENT 6\n",
      "008, DEPARTMENT 7\n",
      "008, DEPARTMENT 8\n",
      "008, DEPARTMENT 9\n",
      "008, DEPARTMENT 10\n",
      "008, DEPARTMENT 11\n",
      "008, DEPARTMENT 12\n",
      "008, DEPARTMENT 13\n",
      "008, DEPARTMENT 14\n",
      "008, DEPARTMENT 15\n",
      "008, DEPARTMENT 16\n",
      "008, DEPARTMENT 17\n",
      "008, DEPARTMENT 18\n",
      "008, DEPARTMENT 19\n",
      "008, DEPARTMENT 20\n",
      "008, DEPARTMENT 21\n",
      "008, DEPARTMENT 22\n",
      "008, DEPARTMENT 23\n",
      "008, DEPARTMENT 24\n",
      "008, DEPARTMENT 25\n",
      "008, DEPARTMENT 26\n",
      "008, DEPARTMENT 27\n",
      "008, DEPARTMENT 28\n",
      "008, DEPARTMENT 29\n",
      "008, DEPARTMENT 30\n",
      "008, DEPARTMENT 31\n",
      "008, DEPARTMENT 32\n",
      "008, FAMILY DIVISION, DEPARTMENT A\n",
      "008, FAMILY DIVISION, DEPARTMENT B\n",
      "008, FAMILY DIVISION, DEPARTMENT C\n",
      "008, FAMILY DIVISION, DEPARTMENT D\n",
      "008, FAMILY DIVISION, DEPARTMENT E\n",
      "008, FAMILY DIVISION, DEPARTMENT F\n",
      "008, FAMILY DIVISION, DEPARTMENT G\n",
      "008, FAMILY DIVISION, DEPARTMENT H\n",
      "008, FAMILY DIVISION, DEPARTMENT I\n",
      "008, FAMILY DIVISION, DEPARTMENT J\n",
      "008, FAMILY DIVISION, DEPARTMENT K\n",
      "008, FAMILY DIVISION, DEPARTMENT L\n",
      "008, FAMILY DIVISION, DEPARTMENT M\n",
      "008, FAMILY DIVISION, DEPARTMENT N\n",
      "008, FAMILY DIVISION, DEPARTMENT O\n",
      "008, FAMILY DIVISION, DEPARTMENT P\n",
      "008, FAMILY DIVISION, DEPARTMENT Q\n",
      "008, FAMILY DIVISION, DEPARTMENT R\n",
      "008, FAMILY DIVISION, DEPARTMENT S\n",
      "008, FAMILY DIVISION, DEPARTMENT T\n",
      "008, FAMILY DIVISION, DEPARTMENT U\n",
      "008, FAMILY DIVISION, DEPARTMENT V\n",
      "008, FAMILY DIVISION, DEPARTMENT W\n",
      "008, FAMILY DIVISION, DEPARTMENT X\n",
      "008, FAMILY DIVISION, DEPARTMENT Y\n",
      "008, FAMILY DIVISION, DEPARTMENT Z\n",
      "LAS VEGAS TWNSH DEPARTMENT 12\n",
      "008\n",
      "011\n",
      "021\n",
      "005\n",
      "023\n",
      "035\n",
      "041\n",
      "029\n",
      "022\n",
      "009\n",
      "042\n",
      "016\n",
      "036\n",
      "019\n",
      "B\n",
      "NORTH LAS VEGAS TWNSH TOWNSHIP, DEPARTMENT 3\n",
      "004\n",
      "C\n",
      "012\n",
      "018\n",
      "013\n",
      "E\n",
      "017\n",
      "014\n",
      "SEAT 5\n",
      "5\n",
      "037\n",
      "006\n",
      "028\n",
      "034\n",
      "D\n",
      "015\n",
      "020\n",
      "009, DEPARTMENT 1\n",
      "009, DEPARTMENT 2\n",
      "AREA 1\n",
      "AREA 3\n",
      "039\n",
      "004, DEPARTMENT 1\n",
      "004, DEPARTMENT 2\n",
      "004, DEPARTMENT 3\n",
      "033\n",
      "005, DEPARTMENT 1\n",
      "005, DEPARTMENT 2\n",
      "032\n",
      "2\n",
      "3\n",
      "1\n",
      "007, DEPARTMENT 1\n",
      "007, DEPARTMENT 2\n",
      "SEAT 4B\n",
      "SEAT 4E\n",
      "SEAT 1A\n",
      "SEAT 1B\n",
      "SEAT 1C\n",
      "006, DEPARTMENT 2\n",
      "SEAT A\n",
      "SEAT E\n",
      "4\n",
      "011, DEPARTMENT 1\n",
      "003, DEPARTMENT 1\n",
      "003, DEPARTMENT 2\n",
      "WARD F2\n",
      "WARD F5\n",
      "WARD F4\n",
      "PAHRUMP TOWNSHIP, DEPARTMENT B\n",
      "AREA IV\n",
      "AREA VI\n",
      "002, DEPARTMENT 1\n",
      "002, DEPARTMENT 2\n",
      "002, DEPARTMENT 3\n",
      "002, DEPARTMENT 4\n",
      "002, DEPARTMENT 5 FAMILY DIVISION\n",
      "002, DEPARTMENT 6\n",
      "002, DEPARTMENT 7\n",
      "002, DEPARTMENT 8\n",
      "002, DEPARTMENT 9\n",
      "002, DEPARTMENT 10\n",
      "002, DEPARTMENT 11 FAMILY DIVISION\n",
      "002, DEPARTMENT 12 FAMILY DIVISION\n",
      "002, DEPARTMENT 13 FAMILY DIVISION\n",
      "002, DEPARTMENT 14 FAMILY DIVISION\n",
      "002, DEPARTMENT 15\n",
      "002, DEPARTMENT 16 FAMILY DIVISION\n",
      "DISTRICT G AT-LARGE\n",
      "026\n",
      "025\n",
      "AT-LARGE\n",
      "WARD 1\n",
      "DEPARTMENT 1\n",
      "024\n",
      "027\n",
      "WARD 3\n",
      "030\n",
      "031\n",
      "WARD 5\n",
      "SEAT 2\n",
      "SEAT 3\n",
      "SEAT 4\n"
     ]
    }
   ],
   "source": [
    "for x in df['district'].unique():\n",
    "    #if x == -1: \n",
    "        print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "change candidate party:\n",
    "WASHINGTON, DAVID L. : NO POLITICAL PARTY -> INDEPENDENT\n",
    "ZAIDI, SAYED \"SM\" : NO POLITICAL PARTY -> INDEPENDENT\n",
    "GERHARDT, JOHN CARDIFF : NO POLITICAL PARTY -> INDEPENDENT"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "NO\n",
      "YES\n",
      "NOLL, JR., JAKE\n",
      "YOUNG, MIKE\n",
      "MILLER, GRATTON\n",
      "MORRIS, CLAIR\n",
      "SIMONS, MANDY\n",
      "SMITH, ROWENA\n",
      "JOHNSTON, MARGARET A.\n",
      "KINNEY, CAMERON\n",
      "GOOLSBY, JONATHAN\n",
      "MICHELI, CHRIS\n",
      "MOORE DELRIO, LAURA \"NIKI\"\n",
      "SAVEDRA, CARMEN \"BETH\"\n",
      "SCHWAB, JAMES L.\n",
      "SWETT, NOAH J.\n",
      "THORNAL, SHAUNIA\n",
      "ZANDER, ERNEST \"SKIPP\"\n",
      "DURHAM, JEFF\n",
      "FLORES, NICOLAS \"NICK\"\n",
      "CORONA, DANIEL\n",
      "KATSONIS, MICHAEL \"MIKE\"\n",
      "WINSOR, DELON \"DE\"\n",
      "KEYES, RALPH M.\n",
      "KIRBY, WILLIAM C.\n",
      "GOICOECHEA, J.J.\n",
      "CLINTON, ADRIENNE\n",
      "COATS, PAM\n",
      "HORKY, GARY\n",
      "MARBLE, CECELIA\n",
      "BREWSTER, TODD\n",
      "MARTIN, LESLIE\n",
      "MCKAY, HALEY\n",
      "ROBISON, WADE\n",
      "BLADES, KRYSTAL\n",
      "KUEHNERT, SHARYL\n",
      "36\n"
     ]
    }
   ],
   "source": [
    "\n",
    "for item in index['candidate'].unique():\n",
    "    if item != 'YES' and item != 'NO':\n",
    "        print(item)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>county_name</th>\n",
       "      <th>precinct</th>\n",
       "      <th>race</th>\n",
       "      <th>candidate</th>\n",
       "      <th>votes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Carson City</td>\n",
       "      <td>101</td>\n",
       "      <td>Board of Supervisors, Ward 2</td>\n",
       "      <td>WHITE, MAURICE \"MO\"</td>\n",
       "      <td>532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Carson City</td>\n",
       "      <td>101</td>\n",
       "      <td>Board of Supervisors, Ward 2</td>\n",
       "      <td>WILKE-MCCULLOCH, STACIE</td>\n",
       "      <td>467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Carson City</td>\n",
       "      <td>101</td>\n",
       "      <td>Court Of Appeals Judge, Dept. 3</td>\n",
       "      <td>BULLA, BONNIE</td>\n",
       "      <td>402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Carson City</td>\n",
       "      <td>101</td>\n",
       "      <td>Court Of Appeals Judge, Dept. 3</td>\n",
       "      <td>BUSH, SUSAN</td>\n",
       "      <td>367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carson City</td>\n",
       "      <td>101</td>\n",
       "      <td>Court Of Appeals Judge, Dept. 3</td>\n",
       "      <td>None Of These Candidates</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182866</th>\n",
       "      <td>White Pine</td>\n",
       "      <td>Precinct 9</td>\n",
       "      <td>Supreme Court Justice, Seat D</td>\n",
       "      <td>None Of These Candidates</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182867</th>\n",
       "      <td>White Pine</td>\n",
       "      <td>Precinct 9</td>\n",
       "      <td>U.S. Representative in Congress, Dist. 4</td>\n",
       "      <td>Esteban, Jonathan Royce</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182868</th>\n",
       "      <td>White Pine</td>\n",
       "      <td>Precinct 9</td>\n",
       "      <td>U.S. Representative in Congress, Dist. 4</td>\n",
       "      <td>Horsford, Steven A.</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182869</th>\n",
       "      <td>White Pine</td>\n",
       "      <td>Precinct 9</td>\n",
       "      <td>U.S. Representative in Congress, Dist. 4</td>\n",
       "      <td>Marchant, Jim</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182870</th>\n",
       "      <td>White Pine</td>\n",
       "      <td>Precinct 9</td>\n",
       "      <td>U.S. Representative in Congress, Dist. 4</td>\n",
       "      <td>Rubinson, Barry</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>182869 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        county_name    precinct                                      race  \\\n",
       "2       Carson City         101              Board of Supervisors, Ward 2   \n",
       "3       Carson City         101              Board of Supervisors, Ward 2   \n",
       "4       Carson City         101           Court Of Appeals Judge, Dept. 3   \n",
       "5       Carson City         101           Court Of Appeals Judge, Dept. 3   \n",
       "6       Carson City         101           Court Of Appeals Judge, Dept. 3   \n",
       "...             ...         ...                                       ...   \n",
       "182866   White Pine  Precinct 9             Supreme Court Justice, Seat D   \n",
       "182867   White Pine  Precinct 9  U.S. Representative in Congress, Dist. 4   \n",
       "182868   White Pine  Precinct 9  U.S. Representative in Congress, Dist. 4   \n",
       "182869   White Pine  Precinct 9  U.S. Representative in Congress, Dist. 4   \n",
       "182870   White Pine  Precinct 9  U.S. Representative in Congress, Dist. 4   \n",
       "\n",
       "                       candidate votes  \n",
       "2            WHITE, MAURICE \"MO\"   532  \n",
       "3        WILKE-MCCULLOCH, STACIE   467  \n",
       "4                  BULLA, BONNIE   402  \n",
       "5                    BUSH, SUSAN   367  \n",
       "6       None Of These Candidates   230  \n",
       "...                          ...   ...  \n",
       "182866  None Of These Candidates    15  \n",
       "182867   Esteban, Jonathan Royce     1  \n",
       "182868       Horsford, Steven A.    68  \n",
       "182869             Marchant, Jim    64  \n",
       "182870           Rubinson, Barry     1  \n",
       "\n",
       "[182869 rows x 5 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WHITE, MAURICE \"MO\"\n",
      "WILKE-MCCULLOCH, STACIE\n",
      "BULLA, BONNIE\n",
      "BUSH, SUSAN\n",
      "None Of These Candidates\n",
      "RUSSELL, JAMES TODD\n",
      "WILSON, JIM\n",
      "BIDEN, JOSEPH R.\n",
      "BLANKENSHIP, DON\n",
      "JORGENSEN, JO\n",
      "TRUMP, DONALD J.\n",
      "CACIOPPO, JOE\n",
      "TRUSHENSKI, JOY R.\n",
      "LOYD, SENA\n",
      "O'Neill, Philip \"PK\"\n",
      "No\n",
      "Yes\n",
      "Pickering, Kristina\n",
      "FUMO, Ozzie\n",
      "HERNDON, DOUGLAS\n",
      "ACKERMAN, PATRICIA\n",
      "Amodei, Mark E.\n",
      "JANINE HANSEN\n",
      "MALKOVICH, GREGG\n",
      "PINDER, PHILIP\n",
      "STRASDIN, TRICIA\n",
      "TISDALE, LEE\n",
      "WHITAKER, KATHRYN\n",
      "HEATH, JUSTIN\n",
      "KELLY, KELLI\n",
      "KOENIG, GREGORY S.\n",
      "STOCKARD, THOMAS\n",
      "TITUS, ROBIN L.\n",
      "Naft, Michael\n",
      "Thomas, Michael\n",
      "Villani, Jacob\n",
      "Yeager, Bita \"Marie\"\n",
      "Kierny, Carli Lynn\n",
      "Scotti, Richard\n",
      "Ganz, Adam\n",
      "Trujillo, Monica\n",
      "Aurbach, Phil\n",
      "Krall, Nadia\n",
      "Barisich, Veronica\n",
      "Coffing, Terry\n",
      "Bluth, Jacqueline\n",
      "Leventhal, Todd M.\n",
      "Bell, Linda Marie\n",
      "Atkin, Trevor\n",
      "Peterson, Jessica K.\n",
      "Silva, Cristina D.\n",
      "Jones, Tierra\n",
      "Gonzalez, Elizabeth \"Betsy\"\n",
      "Leavitt, Michelle\n",
      "Denton, Mark\n",
      "Escobar, Adriana\n",
      "Hardy, Jr., Joe\n",
      "Williams, Tim\n",
      "Albertson, Anna\n",
      "Villani, Michael\n",
      "Holthus, Mary Kay\n",
      "Hunt, John A.\n",
      "Eller, Crystal\n",
      "Kephart, William \"Bill\"\n",
      "Hooker, Dawn Allysa\n",
      "Johnson, Eric\n",
      "Clark Newberry, Tara\n",
      "Reynolds, Jacob\n",
      "Johnson, Susan\n",
      "Nadig, Ben\n",
      "Armstrong, Karl W.\n",
      "Lilly-Spells, Jasmin\n",
      "Ballou, Erika D.\n",
      "Gilliam, Dan\n",
      "Delaney, Kathleen E.\n",
      "Sturman, Gloria\n",
      "Allf, Nancy\n",
      "Israel, Ron\n",
      "JONES, DAVID M.\n",
      "López-Negrete, David\n",
      "Wiese, Jerry A.\n",
      "Call, Gary W.\n",
      "Kishner, Joanna\n",
      "Bare, Rob\n",
      "Craig, Christy\n",
      "Voy, William\n",
      "Marquis, Linda\n",
      "Burton, Rebecca\n",
      "Teuton, Robert W. \"Bob\"\n",
      "Hoskin, Charles J. \"Chuck\"\n",
      "Kurtz, Thomas G.\n",
      "Gentile, Denise L.\n",
      "Childs, Sr., Benjamin Boone\n",
      "Forsberg, Rhonda K.\n",
      "Ritchie, Art\n",
      "Bailey, Soonhee \"Sunny\"\n",
      "Tobler, Michelle O.\n",
      "Butler, Dedree \"Dee\"\n",
      "MacDonald, J. Scott\n",
      "Giuliani, Cynthia N.\n",
      "Gibson, Jr., David\n",
      "Hughes, Lynn\n",
      "MASTIN, AMY M.\n",
      "Harter, Mathew\n",
      "Sullivan, Frank P.\n",
      "Dayani, Sara\n",
      "Perry, Mary\n",
      "Duckworth, Bryce C.\n",
      "Henderson, Bill\n",
      "Ochoa, Vincent\n",
      "Cutter, Nadin\n",
      "Stoffel, Jason\n",
      "Gonzalez, Bill\n",
      "Throne, Dawn\n",
      "Pickard, Margaret E.\n",
      "Rincon White, Adriana\n",
      "Rocheleau, Stacy Michelle\n",
      "Almase, Heidi\n",
      "Davis, Jim\n",
      "Charter, Stephanie\n",
      "Mercer, Michele \"Shell\"\n",
      "Perez, Romeo\n",
      "Clowers-Sanborn, Shanon\n",
      "Sullivan, Diana L.\n",
      "Facey, Edward \"Eddie\"\n",
      "Frierson, Jason\n",
      "Casino, Angelo\n",
      "Hughes, Tim\n",
      "Dowden, Joshua\n",
      "HARRIS, DALLAS\n",
      "Bakari, Kamau A.\n",
      "Bentley, Joyce\n",
      "Strawder, Jr., Robert Van\n",
      "TITUS, Dina\n",
      "Arrington, Cherlyn\n",
      "Marzola, Elaine\n",
      "Buck, Carrie\n",
      "Hagan, Tim\n",
      "Watson, Kristee\n",
      "Guzman, Lisa\n",
      "Leavitt, Liberty\n",
      "BRIDGES II, EDWARD\n",
      "Brown, Steve\n",
      "LEE, SUZANNE\n",
      "Rodimer, Dan \"Big Dan\"\n",
      "Brooks, Byron\n",
      "Nigam, Swadeep\n",
      "Foutz, Brent\n",
      "Hoge, Bill\n",
      "LEAVITT, GLEN\n",
      "Bethards, Stephanie S.\n",
      "Doten, Fred\n",
      "Henry, Vincent\n",
      "Hoss, Kathleen\n",
      "Mackey, Gina\n",
      "Maniaci, James \"Jim\"\n",
      "Ochs, Kathy\n",
      "Taravella, Lynette\n",
      "Walker, Hermon\n",
      "Walker, Pamela\n",
      "Calhoun, Jay\n",
      "GORELOW, MICHELLE\n",
      "DaCosta, Victoria K.\n",
      "Jauregui, Sandra\n",
      "Smith, Erika\n",
      "Cohen, Lesley Elizabeth\n",
      "Delisle, Steven E.\n",
      "HARDY, MELISSA\n",
      "Altman, Barbara\n",
      "Yeager, Steve\n",
      "ASSEFA, ALEXANDER\n",
      "Delsignore, Liz\n",
      "Zaidi, Sayed \"SM\"\n",
      "Boylan, Patrick\n",
      "Spirtos, Nick M.\n",
      "González, Cecelia\n",
      "Sajdak, Reyna \"Alex\"\n",
      "HAFEN II, GREGORY\n",
      "Goicoechea, Pete\n",
      "Seeback, Tiffany \"Gholson\"\n",
      "Kirkpatrick, Marilyn\n",
      "Markowitz, Warren R.\n",
      "Williams, Kevin M.\n",
      "Harris, Belinda T. \"BTH\"\n",
      "Lee, Chris\n",
      "Monroe-Moreno, Daniele\n",
      "Cantu, Rene\n",
      "NEWBURN, MARK\n",
      "Spearman, Patricia \"Pat\"\n",
      "Garcia Morales, Evelyn\n",
      "Henry, Tameka\n",
      "Esteban, Jonathan Royce\n",
      "Horsford, Steven A.\n",
      "Marchant, Jim\n",
      "Rubinson, Barry\n",
      "Miller, Cameron \"C.H.\"\n",
      "Palmer, Anthony \"Tony\"\n",
      "Hickman, Esper M.\n",
      "Neal, Dina\n",
      "Tarkanian, Lois\n",
      "Whipple, Bret\n",
      "Campbell, Derek W.\n",
      "Farnsworth, Scott\n",
      "Robison, Kelby Ray\n",
      "Tobler, Mitchell\n",
      "Black, Ann \"Annie\"\n",
      "Proffitt, Jeff\n",
      "Williams, Katie\n",
      "Gerhardt, John Cardiff\n",
      "Graves, Jeremy A.\n",
      "MARTINEZ, SUSAN\n",
      "McArthur, Richard\n",
      "MUNK, CONNIE\n",
      "Becker, Liz\n",
      "Hammond, Scott T.\n",
      "ROBERTS, THOMAS\n",
      "Brooks, Lola\n",
      "Salt, Alexis\n",
      "Polcyn, Jack\n",
      "Thomas, Clara \"Claire\"\n",
      "CARLTON, Maggie\n",
      "Wayerski, Robert\n",
      "Laub, Randy\n",
      "McGreer, Mike\n",
      "Boger, Wes\n",
      "Fielding, Karen\n",
      "Litman, Allan S.\n",
      "Sweetin, Bob\n",
      "Noll, Jr., Jake\n",
      "Young, Mike\n",
      "Dalley, Lindsey\n",
      "Dorsey, Bryan\n",
      "Hardy, Stanley Glen\n",
      "BACKUS, SHEA\n",
      "Matthews, Andy\n",
      "Becker, April\n",
      "Cannizzaro, Nicole\n",
      "Bousley, Natasha\n",
      "Flores, Edgar\n",
      "Anthony, Stavros\n",
      "Miller, Ross\n",
      "Bilbray-Axelrod, Shannon\n",
      "Carlson, Jay Thomas\n",
      "KASAMA, HEIDI\n",
      "Kunnel, Radhika \"RPK\"\n",
      "LeDuff, Garrett\n",
      "TORRES, SELENA\n",
      "BROOKS, CHRISTOPHER\n",
      "Friedrich, Jonathan\n",
      "Hisgen, Chris\n",
      "NGUYEN, ROCHELLE\n",
      "Miller, Brittney\n",
      "Miller, Mack\n",
      "MCCURDY, II, WILLIAM\n",
      "Washington, David L.\n",
      "Duncan, Katie\n",
      "Summers-Armstrong, Shondra\n",
      "DURAN, BEATRICE\n",
      "Krattiger, Eric\n",
      "Vaughan, Stan\n",
      "WATTS, HOWARD\n",
      "Orentlicher, David\n",
      "Lange, Roberta\n",
      "Considine, Venicia\n",
      "Florian, Heather Ann\n",
      "CAFFERATA-JENKINS, CAREN\n",
      "YOUNG, TOD\n",
      "GREGORY, THOMAS W.\n",
      "TARKANIAN, DANNY\n",
      "GARDNER, MARK\n",
      "HOLT, CHARLES\n",
      "NOWOSAD, WALTER \"WALT\"\n",
      "MAGNOTTA, TONY\n",
      "WAGSTAFF, YVONNE\n",
      "ENGLEKIRK, DWIGHT \"DOUG\"\n",
      "SIDNEY, LAWRENCE \"LARRY\"\n",
      "BELLONA, WM \"JOHN\"\n",
      "FAFF, TERRY\n",
      "MIHELIC, STEVEN\n",
      "SOMMERS, MIKE\n",
      "BALIGAD, DARBY\n",
      "MCDOWELL, ROBERT \"BOB\"\n",
      "MCKALIP, JAMES\n",
      "CHANG, DEBORAH\n",
      "JONES, DAVE \"LIBERTY\"\n",
      "Wheeler, Jim\n",
      "ALTAMIRANO, SETH\n",
      "BUNTING, TIM\n",
      "SMALLWOOD, BARBARA S.\n",
      "WILSON, RAYMOND G.\n",
      "DUNHAM, DALE L.\n",
      "GRAY, TERI A.\n",
      "RIVANO, ANTHONY P.\n",
      "SIEGMAN, RUSS\n",
      "BARBER, GEORGE H.\n",
      "CLARK, GERALD \"SPARKY\" M.\n",
      "FERRIS, SHARON\n",
      "TAYLOR, JERRY \"BRANDON\"\n",
      "BERRY, DENNIS\n",
      "ENGLEKIRK, DANA M.\n",
      "HERWIG, JONATHAN\n",
      "KOFFMAN, MARK A.\n",
      "LAVO, KEVIN\n",
      "NICE, RICHARD\n",
      "WRIGHT, JEFFREY\n",
      "Murphy, Janet\n",
      "MURPHY, MICHAEL J.\n",
      "ROSSI, GREGG\n",
      "SMITH, DARIN R.\n",
      "BROUGH, WILDE FERRIS\n",
      "GUTIERREZ, ISMAEL \"IZZY\"\n",
      "KARR, JONATHAN\n",
      "STENINGER, REX\n",
      "HILL, KRISTON N.\n",
      "PORTER, NANCY\n",
      "KACIN, AL\n",
      "MUIJE, JOHN W.\n",
      "SIMONS, MASON\n",
      "MILLER, GRATTON\n",
      "MORRIS, CLAIR\n",
      "SIMONS, MANDY\n",
      "SMITH, ROWENA\n",
      "CRACRAFT DICKENSON, TAMMIE\n",
      "LEONHARDT, ROBERT\n",
      "BRORBY, GREG\n",
      "DASTRUP, TERESA\n",
      "Ellison, John C.\n",
      "JOHNSTON, MARGARET A.\n",
      "KINNEY, CAMERON\n",
      "GOOLSBY, JONATHAN\n",
      "MICHELI, CHRIS\n",
      "MOORE DELRIO, LAURA \"NIKI\"\n",
      "SAVEDRA, CARMEN \"BETH\"\n",
      "SCHWAB, JAMES L.\n",
      "SWETT, NOAH J.\n",
      "THORNAL, SHAUNIA\n",
      "ZANDER, ERNEST \"SKIPP\"\n",
      "DURHAM, JEFF\n",
      "FLORES, NICOLAS \"NICK\"\n",
      "PETERSON, HEATHER\n",
      "TRUJILLO, ROBERTO \"ROBERT\"\n",
      "CORONA, DANIEL\n",
      "KATSONIS, MICHAEL \"MIKE\"\n",
      "Wanker, Kimberly A. \"Kim\"\n",
      "LANE, ROBERT W.\n",
      "HANSEN, ALEXIS\n",
      "POVILAITIS, PAULA\n",
      "WINSOR, DELON \"DE\"\n",
      "KEYES, RALPH M.\n",
      "KIRBY, WILLIAM C.\n",
      "GOICOECHEA, J.J.\n",
      "BLEDSOE, CHARLES\n",
      "SHARKOZY, MIKE\n",
      "JOHNSON, PERNECIA \"NECIE\"\n",
      "DOBRESCU, STEVEN L.\n",
      "FAIRMAN, GARY D.\n",
      "KLATT, RANDY\n",
      "LEPPALA, BILL\n",
      "FILIPPINI, Mindy\n",
      "CONLEY, LYNN\n",
      "FIORENZI, LEONARD \"LENNY\"\n",
      "KELLERMAN, NONA\n",
      "KERSEY, MIKAYLA\n",
      "LAROCHELLE, CINDY\n",
      "WINKELKOTTER, DARCEY\n",
      "CLINTON, ADRIENNE\n",
      "COATS, PAM\n",
      "HORKY, GARY\n",
      "MONTERO, MICHAEL\n",
      "CRAMER, ALICIA\n",
      "HARTLEY, DALE E.\n",
      "HILL, JESSE\n",
      "HOSS, TOM\n",
      "TIPTON, ROBERT \"KEN\"\n",
      "ANGUS, DYLAN\n",
      "MARBLE, CECELIA\n",
      "CARDOZA, CLAUDIO THOMAS\n",
      "WAITS, PATSY A.\n",
      "THOMAS, WALLACE \"JR\"\n",
      "SHIRLEY, JIM\n",
      "BRACKENBURY, JARED\n",
      "HIGBEE, VARLIN\n",
      "PEARSON, KEITH\n",
      "CARR, LEANDRA\n",
      "HENDERSON, WES\n",
      "GRAY, KEN\n",
      "JACOBSON, ROBERT\n",
      "WAGNER, CODY J.\n",
      "HOCKADAY, DAVID\n",
      "SCHLEGELMILCH, JOHN \"JP\"\n",
      "ABERASTURI, LEON\n",
      "PARSONS, DONALD\n",
      "ZOBERSKI, FELICITY\n",
      "BROOKS, HELEN\n",
      "CLARKE, NANCY\n",
      "HOWELL, CHERYL\n",
      "JUDE-ASKEW, JANIE\n",
      "LOPEZ, DENA\n",
      "BLOCK, RAY\n",
      "HON, PAT\n",
      "MCCASSIE, DAN\n",
      "MURPHY, PAUL\n",
      "RODRIGUEZ, JAY\n",
      "WHEELER, HARRY J.\n",
      "MCKAY, FRANCES \"FRAN\"\n",
      "WARD, CHRIS\n",
      "BURROWS, BILL\n",
      "TORRES, ALBERT D.\n",
      "HALL, CASSIE\n",
      "HEGG, CHRIS\n",
      "ELLIS, DAVID\n",
      "NIEDZWIECKI, RICK\n",
      "SCHLEPP, CURTIS J.\n",
      "BOSTA, JOHN\n",
      "BUDD, ESPERANZA \"HOPE\"\n",
      "CLAESSENS, RICHARD A.\n",
      "MENDYK, DEBBERA L.\n",
      "SCRIVEN, DEBORAH \"MORGAN\"\n",
      "GARDNER, RICHARD \"DICK\"\n",
      "PRUDHONT, JOHN WESLEY\n",
      "CARBONE, FRANK\n",
      "GRUDZINSKI, WALT\n",
      "JASPERSON, KENT\n",
      "SCHAUS, MARJORIE ANN\n",
      "SMALL, LARRY\n",
      "COX, DONNA C.\n",
      "SCHAUS, LANCE ROY\n",
      "HANSEN, MARK D.\n",
      "PETERSON, LIESE S.\n",
      "HUDSON, SHAYLA\n",
      "RACKLEY, LARRY\n",
      "LIST, JAMES \"JIM\"\n",
      "MACHADO, KEVIN E.\n",
      "PILON, MARK W.\n",
      "PORTMAN, JOHN J.T.\n",
      "CARRUTH, MARCI\n",
      "KNIGHT, SHERRY LYNN\n",
      "GILES, MICHAEL R.\n",
      "WARD, JENNIFER M.\n",
      "MITCHELL, CLAY\n",
      "TOLL, SAM\n",
      "GILMAN, LANCE\n",
      "HILTON, PHILLIP A.\n",
      "HANSEN-MARTINEZ, MARNEY\n",
      "BAKER, MARIE\n",
      "HARTUNG, VAUGHN\n",
      "Drakulich, Kathleen M.\n",
      "Grossman, Dixie\n",
      "RIGGS, TAMMY M.\n",
      "STEINHEIMER, CONNIE\n",
      "Lu, Cynthia\n",
      "SIMONS, LYNNE K.\n",
      "WALKER, EGAN K.\n",
      "BRESLOW, BARRY LOUIS\n",
      "Freeman, Scott N.\n",
      "SATTLER, ELLIOTT A.\n",
      "SIGURDSON, KATHLEEN A.\n",
      "DOLLINGER, PAIGE\n",
      "SHANNON, GREG\n",
      "UNSWORTH, SANDRA A.\n",
      "BUSHUR, AARON\n",
      "ROBB, BRIDGET E.\n",
      "SCHREINERT, TAMATHA R.\n",
      "HARDY, DAVID A.\n",
      "BANALES, AMIEE\n",
      "BAKER, TOM\n",
      "CHESNEY, LARRY\n",
      "Currivan, James\n",
      "HELTON, CHRISTOPHER\n",
      "Otto, Donald\n",
      "PATTERSON, JOHN\n",
      "BERKBIGLER, MARSHA\n",
      "HILL, ALEXIS\n",
      "Dent, Matthew\n",
      "JOHNSON, BLANE\n",
      "KNAAK, YOLANDA\n",
      "Schmitz, Sara\n",
      "TONKING, MICHAELA\n",
      "WRIGHT, FRANK L.\n",
      "CHURCH, JEFF\n",
      "KELLEY, SCOTT\n",
      "NICOLET, DIANE\n",
      "WESNER, CRAIG\n",
      "ALM, VANCE\n",
      "Krasner, Lisa\n",
      "ARRASCADA, JOSEPH\n",
      "MELCHER, KEVIN\n",
      "Tolles, Jill\n",
      "Gansert, Heidi S.\n",
      "JAUREGUI-JACKINS, WENDY\n",
      "LORTON, GEORGE \"EDDIE\"\n",
      "REESE, DEVON THOMAS\n",
      "Brekhus, Jenny\n",
      "DRAKULICH, JOHN \"JD\"\n",
      "DRAKULICH, GENE\n",
      "Peters, Sarah\n",
      "Benitez-Thompson, Teresa\n",
      "HAWN, BARB\n",
      "MONTOGNESE, MATTHEW\n",
      "TAYLOR, ANGIE\n",
      "DELGADO, DARIO \"OSCAR\"\n",
      "LEON, RUTH \"RUDY\"\n",
      "ANDERSON, NATHA C.\n",
      "HOFF, RANDY\n",
      "YOUNG, CHARLENE\n",
      "Daly, Richard \"Skip\"\n",
      "Dickman, Jill Ann\n",
      "FINK, DARLA\n",
      "Jardon, Neoma\n",
      "Abbott, Donald\n",
      "STOLYAROV, WENDY\n",
      "ANDERSON, PAUL S.\n",
      "SMITH, QUENTIN\n",
      "BYBEE, SHANE A.\n",
      "CHACHAS, GEORGE\n",
      "CARSON, LAURIE L.\n",
      "HOWE, RICHARD\n",
      "BREWSTER, TODD\n",
      "MARTIN, LESLIE\n",
      "MCKAY, HALEY\n",
      "ROBISON, WADE\n",
      "BLADES, KRYSTAL\n",
      "KUEHNERT, SHARYL\n"
     ]
    }
   ],
   "source": [
    "for item in df['candidate'].unique():\n",
    "    print(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "MEMBER MOAPA VALLEY WATER DISTRICT OVERTON - 4 YEAR\n",
      "MEMBER MOAPA VALLEY WATER DISTRICT LOGANDALE - 4 YEAR\n",
      "MINDEN-GARDNERVILLE SANITATION DISTRICT\n",
      "HOSPITAL BOARD TRUSTEE - SEAT A\n",
      "SCHOOL DISTRICT TRUSTEE - SEAT E\n",
      "WC - 1\n"
     ]
    }
   ],
   "source": [
    "for item in df['office'].unique():\n",
    "    if '-' in item:\n",
    "        print(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "lst = ['School', 'President', 'County Commissioner', 'COUNTY COMMISSIONER', 'QUESTION', 'Board']\n",
    "lst2 = []\n",
    "for x in df['race'].unique():\n",
    "    if ',' not in x: \n",
    "        if 'School' not in x and 'Board' not in x and 'COUNTY COMMISSIONER' not in x and 'President' not in x and 'QUESTION' not in x and 'County Commissioner' not in x: \n",
    "                lst2.append(x)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Justice of the Peace North Las Vegas Twnsh Department 3',\n",
       " 'Member Moapa Valley Water District Overton - 4 Year',\n",
       " 'City of Mesquite Councilmember Seat 5',\n",
       " 'Mayor of Mesquite',\n",
       " 'Overton Power District 5 Mesquite',\n",
       " 'Member Moapa Valley Water District Logandale - 4 Year',\n",
       " 'Gardnerville Ranchos General Improvement District',\n",
       " 'Minden-Gardnerville Sanitation District',\n",
       " 'Indian Hills General Improvement District',\n",
       " 'Round Hill General Improvement District',\n",
       " 'WEST WENDOVER MAYOR',\n",
       " 'COUNTY TREASURER',\n",
       " 'EUREKA COUNTY TELEVISION DISTRICT SEAT 4B',\n",
       " 'EUREKA COUNTY TELEVISION DISTRICT SEAT 4E',\n",
       " 'HOSPITAL BOARD TRUSTEE - SEAT A',\n",
       " 'SCHOOL DISTRICT TRUSTEE - SEAT E',\n",
       " 'FERNLEY SWIMMING POOL DISTRICT DIRECTOR',\n",
       " 'NORTH LYON COUNTY FIRE DISTRICT DIRECTOR',\n",
       " 'JUSTICE OF THE PEACE PAHRUMP DEPARTMENT B',\n",
       " 'LOVELOCK MEADOWS WATER DISTRICT TRUSTEE',\n",
       " 'CITY OF LOVELOCK MAYOR',\n",
       " 'COUNTY RECORDER',\n",
       " 'Palomino Valley General Improvement District',\n",
       " 'WC - 1',\n",
       " 'Incline Village General Improvement District']"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lst2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mayor of Mesquite\n",
      "WEST WENDOVER MAYOR\n",
      "CITY OF LOVELOCK MAYOR\n"
     ]
    }
   ],
   "source": [
    "for x in lst2:\n",
    "    if 'Mayor' in x or 'MAYOR' in x:\n",
    "        print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "TOPAZ RANCH ESTATES GENERAL IMPROVEMENT DISTRICT (One, 4 Year Term and One 2 Year-Unexpired Term)\n",
      "SKYLAND GENERAL IMPROVEMENT DISTRICT (Three, 4 Year Terms and Two, 2 Year-Unexpired Terms)\n"
     ]
    }
   ],
   "source": [
    "for item in df['race'].unique():\n",
    "    if ',' in item and '(' in item:\n",
    "        print(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Board of Supervisors\n",
      "Court Of Appeals Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "School Trustee\n",
      "State Assembly\n",
      "Supreme Court Justice\n",
      "Supreme Court Justice\n",
      "U.S. Representative in Congress\n",
      "County Commissioner\n",
      "COUNTY COMMISSIONER\n",
      "District Court Judge\n",
      "State Assembly\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "Justice of the Peace\n",
      "State Assembly\n",
      "State Board of Education\n",
      "State Senate\n",
      "U.S. Representative in Congress\n",
      "State Assembly\n",
      "State Senate\n",
      "U.S. Representative in Congress\n",
      "University Board of Regents\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "University Board of Regents\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Senate\n",
      "State Assembly\n",
      "State Board of Education\n",
      "State Senate\n",
      "U.S. Representative in Congress\n",
      "State Assembly\n",
      "State Senate\n",
      "University Board of Regents\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Senate\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Senate\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Senate\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Assembly\n",
      "State Senate\n",
      "State Assembly\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "DOUGLAS COUNTY COMMISSIONER\n",
      "DOUGLAS COUNTY COMMISSIONER\n",
      "DOUGLAS COUNTY COMMISSIONER\n",
      "DOUGLAS COUNTY SCHOOL BOARD\n",
      "DOUGLAS COUNTY SCHOOL BOARD\n",
      "EAST FORK FIRE PROTECTION DISTRICT\n",
      "EAST FORK FIRE PROTECTION DISTRICT\n",
      "State Assembly\n",
      "TOPAZ RANCH ESTATES GENERAL IMPROVEMENT DISTRICT\n",
      "SKYLAND GENERAL IMPROVEMENT DISTRICT\n",
      "County Commissioner\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "Elko City Council\n",
      "SCHOOL BOARD OF TRUSTEES\n",
      "SCHOOL BOARD OF TRUSTEES\n",
      "State Assembly\n",
      "Carlin City Council\n",
      "WELLS CITY COUNCIL\n",
      "WEST WENDOVER CITY COUNCIL\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "State Assembly\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "SCHOOL DISTRICT TRUSTEE\n",
      "SCHOOL DISTRICT TRUSTEE\n",
      "SCHOOL DISTRICT TRUSTEE\n",
      "CITY COUNCIL\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "COUNCILMEMBER\n",
      "COUNCILMEMBER\n",
      "COUNCILMEMBER\n",
      "COUNTY COMMISSIONER\n",
      "COUNTY COMMISSIONER\n",
      "NYE COUNTY SCHOOL BOARD TRUSTEE\n",
      "NYE COUNTY SCHOOL BOARD TRUSTEE\n",
      "PERSHING COUNTY SCHOOL DISTRICT TRUSTEE\n",
      "COUNTY COMMISSION\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "District Court Judge\n",
      "COUNTY COMMISSION\n",
      "SCHOOL BOARD TRUSTEE\n",
      "SCHOOL BOARD TRUSTEE\n",
      "State Assembly\n",
      "University Board of Regents\n",
      "State Assembly\n",
      "State Senate\n",
      "RENO CITY COUNCIL\n",
      "Reno City Council\n",
      "RENO MUNICIPAL COURT JUDGE\n",
      "State Assembly\n",
      "State Assembly\n",
      "School Board Trustee\n",
      "Reno City Council\n",
      "State Assembly\n",
      "State Assembly\n",
      "Reno City Council\n",
      "Sparks City Council\n",
      "Sparks City Council\n",
      "COUNTY COMMISSIONER\n",
      "COUNTY COMMISSIONER\n",
      "COUNTY COMMISSIONER\n",
      "HOSPITAL DISTRICT TRUSTEE\n",
      "HOSPITAL DISTRICT TRUSTEE\n",
      "SCHOOL DISTRICT TRUSTEE\n"
     ]
    }
   ],
   "source": [
    "lst =[]\n",
    "for item in df['race'].unique():\n",
    "    if ',' in item: \n",
    "        if '(' not in item: \n",
    "            index = item.index(',')\n",
    "            print(item[:index])\n",
    "        else: \n",
    "            index = item.index('(')\n",
    "            print(item[:index-1])\n",
    "        \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "def unique(list1):\n",
    " \n",
    "    # intilize a null list\n",
    "    unique_list = []\n",
    "     \n",
    "    # traverse for all elements\n",
    "    for x in list1:\n",
    "        # check if exists in unique_list or not\n",
    "        if x not in unique_list:\n",
    "            unique_list.append(x)\n",
    "    # print list\n",
    "    for x in unique_list:\n",
    "        print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Board of Supervisors\n",
      "Court Of Appeals Judge\n",
      "District Court Judge\n",
      "School Trustee\n",
      "State Assembly\n",
      "Supreme Court Justice\n",
      "U.S. Representative in Congress\n",
      "County Commissioner\n",
      "COUNTY COMMISSIONER\n",
      "Justice of the Peace\n",
      "State Board of Education\n",
      "State Senate\n",
      "University Board of Regents\n",
      "DOUGLAS COUNTY COMMISSIONER\n",
      "DOUGLAS COUNTY SCHOOL BOARD\n",
      "EAST FORK FIRE PROTECTION DISTRICT\n",
      "TOPAZ RANCH ESTATES GENERAL IMPROVEMENT DISTRICT (One\n",
      "SKYLAND GENERAL IMPROVEMENT DISTRICT (Three\n",
      "Elko City Council\n",
      "SCHOOL BOARD OF TRUSTEES\n",
      "Carlin City Council\n",
      "WELLS CITY COUNCIL\n",
      "WEST WENDOVER CITY COUNCIL\n",
      "SCHOOL DISTRICT TRUSTEE\n",
      "CITY COUNCIL\n",
      "COUNCILMEMBER\n",
      "NYE COUNTY SCHOOL BOARD TRUSTEE\n",
      "PERSHING COUNTY SCHOOL DISTRICT TRUSTEE\n",
      "COUNTY COMMISSION\n",
      "SCHOOL BOARD TRUSTEE\n",
      "RENO CITY COUNCIL\n",
      "Reno City Council\n",
      "RENO MUNICIPAL COURT JUDGE\n",
      "School Board Trustee\n",
      "Sparks City Council\n",
      "HOSPITAL DISTRICT TRUSTEE\n"
     ]
    }
   ],
   "source": [
    "unique(lst)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "GIOCOECHEA, JJ\n",
      "PAUL R. SCHLEHR\n",
      "519\n",
      "2\n",
      "521\n"
     ]
    }
   ],
   "source": [
    "count = 0\n",
    "notin = 0\n",
    "total = 0 \n",
    "for x in cand['candidate']:\n",
    "    if x in df['candidate'].unique():\n",
    "        count+=1\n",
    "    else:\n",
    "        notin+=1\n",
    "        print(x)\n",
    "    total+=1\n",
    "print(count)\n",
    "print(notin)\n",
    "print(total)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "PAUL R. SCHLEHR\n",
    "GIOCOECHEA, JJ"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}