scraper.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c68eaed3-128b-4fe1-a57b-d6e3b568fcab",
   "metadata": {},
   "source": [
    "# U.S. Elections 2024\n",
    "\n",
    "This is a scraper for (unofficial) election night results from the [New York City Board of Elections](https://enr.boenyc.gov/index.html), specifically for election districts in the South Bronx. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "dbfcc05c-a1dc-4700-af6e-c80597538bd1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# importing libraries\n",
    "import pandas as pd\n",
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "from random import randrange\n",
    "import time\n",
    "from io import StringIO"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d5c93c12-9ffd-49c6-819c-d73b1aff01a2",
   "metadata": {},
   "source": [
    "### Assembly districts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e9a8e014-df52-44c6-a180-d825d48621db",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# fetch URL\n",
    "\n",
    "# main link for the Bronx assembly districts\n",
    "url = \"https://enr.boenyc.gov/CD26825AD2.html\" \n",
    "response = requests.get(url)\n",
    "response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "254d6639-b449-4b6e-b8fc-b22d848dc09f",
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(response.text, \"html.parser\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4f33cc67-7218-400f-a68b-e8a33ab14b37",
   "metadata": {},
   "source": [
    "### Targeting links for each of the assembly districts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ac66e17c-874c-4c9a-a19b-2542fc31fa65",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "175"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "assembly_district = soup.find_all(\"table\", class_=\"underline\")\n",
    "targets = soup.find_all(\"td\")\n",
    "len(targets)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "df5d3707-d0c7-4e09-a19c-16db951d315e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# finding and identifying our main table\n",
    "main_table = targets[6]\n",
    "# main_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a496fc89-2284-48f0-a556-12d2af3e5e11",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<a href=\"CD26825AD772.html\" nowrap=\"\" title=\"AD 77\">AD   77</a>,\n",
       " <a href=\"CD26825AD782.html\" nowrap=\"\" title=\"AD 78\">AD   78</a>,\n",
       " <a href=\"CD26825AD792.html\" nowrap=\"\" title=\"AD 79\">AD   79</a>,\n",
       " <a href=\"CD26825AD802.html\" nowrap=\"\" title=\"AD 80\">AD   80</a>,\n",
       " <a href=\"CD26825AD812.html\" nowrap=\"\" title=\"AD 81\">AD   81</a>,\n",
       " <a href=\"CD26825AD822.html\" nowrap=\"\" title=\"AD 82\">AD   82</a>,\n",
       " <a href=\"CD26825AD832.html\" nowrap=\"\" title=\"AD 83\">AD   83</a>,\n",
       " <a href=\"CD26825AD842.html\" nowrap=\"\" title=\"AD 84\">AD   84</a>,\n",
       " <a href=\"CD26825AD852.html\" nowrap=\"\" title=\"AD 85\">AD   85</a>,\n",
       " <a href=\"CD26825AD862.html\" nowrap=\"\" title=\"AD 86\">AD   86</a>,\n",
       " <a href=\"CD26825AD872.html\" nowrap=\"\" title=\"AD 87\">AD   87</a>,\n",
       " <a href=\"https://nyenr.elections.ny.gov/\" target=\"_blank\">State Board of Elections</a>]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_target = main_table.find_all(\"a\")\n",
    "main_target"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "942bfc7f-595b-4867-9c0b-0a887d9b102b",
   "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>assembly_district</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AD   77</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD772.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AD   78</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD782.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AD   79</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD792.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AD   80</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD802.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AD   81</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD812.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AD   82</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD822.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AD   83</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD832.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AD   84</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD842.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AD   85</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD852.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AD   86</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD862.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AD   87</td>\n",
       "      <td>https://enr.boenyc.gov/CD26825AD872.html</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   assembly_district                                      link\n",
       "0            AD   77  https://enr.boenyc.gov/CD26825AD772.html\n",
       "1            AD   78  https://enr.boenyc.gov/CD26825AD782.html\n",
       "2            AD   79  https://enr.boenyc.gov/CD26825AD792.html\n",
       "3            AD   80  https://enr.boenyc.gov/CD26825AD802.html\n",
       "4            AD   81  https://enr.boenyc.gov/CD26825AD812.html\n",
       "5            AD   82  https://enr.boenyc.gov/CD26825AD822.html\n",
       "6            AD   83  https://enr.boenyc.gov/CD26825AD832.html\n",
       "7            AD   84  https://enr.boenyc.gov/CD26825AD842.html\n",
       "8            AD   85  https://enr.boenyc.gov/CD26825AD852.html\n",
       "9            AD   86  https://enr.boenyc.gov/CD26825AD862.html\n",
       "10           AD   87  https://enr.boenyc.gov/CD26825AD872.html"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# initializing\n",
    "base_url = \"https://enr.boenyc.gov/\"\n",
    "assembly_districts_links = [] # holds links to each assembly district\n",
    "assembly_districts_num = [] # holds assembly district number\n",
    "\n",
    "for district in main_target:\n",
    "    try:\n",
    "        if district != None and \"AD\" in district.get(\"title\"):\n",
    "            num = district.get_text()\n",
    "            link = base_url + district.get(\"href\")\n",
    "            assembly_districts_num.append(num)\n",
    "            assembly_districts_links.append(link)\n",
    "    except:\n",
    "        pass\n",
    "\n",
    "# convert to df\n",
    "assembly_districts_df = pd.DataFrame(zip(assembly_districts_num, assembly_districts_links),\n",
    "                  columns=[\"assembly_district\", \"link\"])\n",
    "assembly_districts_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "cc2287bf-1d47-4e38-a3ed-9cf1efdfd374",
   "metadata": {},
   "outputs": [],
   "source": [
    "assembly_districts_df.to_csv(\"bx-assembly_districts.csv\", encoding=\"UTF-8\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69645651-96aa-4dbc-954f-efc6fe090fde",
   "metadata": {},
   "source": [
    "### Targeting links for each of the electoral districts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "3f1a334a-e85e-4f9c-97d2-203cccc4d73d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# initializing headers\n",
    "header = {\n",
    "        \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n",
    "        \"Accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8\",\n",
    "        \"Accept-Language\": \"en-US,en;q=0.9\",\n",
    "        \"Accept-Encoding\": \"gzip, deflate, br\",\n",
    "        \"Connection\": \"keep-alive\",\n",
    "        \"Upgrade-Insecure-Requests\": \"1\",\n",
    "        \"Sec-Fetch-Dest\": \"document\",\n",
    "        \"Sec-Fetch-Mode\": \"navigate\",\n",
    "        \"Sec-Fetch-Site\": \"none\",\n",
    "        \"Sec-Fetch-User\": \"?1\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "83f12ded-d370-44c2-a97f-62312066cb44",
   "metadata": {},
   "outputs": [],
   "source": [
    "# initializing a snoozer, to be safe\n",
    "def snoozer(start_time, end_time):\n",
    "    '''\n",
    "    This function creates a snoozer that can be used when scraping.\n",
    "    It requires `from random import randrange` and `import time`. \n",
    "    \n",
    "    Parameters: \n",
    "    start_time (int) = start time of range, in seconds\n",
    "    end_time (int) = end time of range, in seconds\n",
    "    '''\n",
    "    timer = randrange(start_time, end_time)\n",
    "    print(f\"Snoozing for {timer} seconds...\")\n",
    "    time.sleep(timer)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b6296b6a-5ac9-449b-b8de-05045070c224",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fetching table 1 out of 11 from AD   77...\n",
      "Snoozing for 16 seconds...\n",
      "\n",
      "Fetching table 2 out of 11 from AD   78...\n",
      "Snoozing for 30 seconds...\n",
      "\n",
      "Fetching table 3 out of 11 from AD   79...\n",
      "Snoozing for 16 seconds...\n",
      "\n",
      "Fetching table 4 out of 11 from AD   80...\n",
      "Snoozing for 24 seconds...\n",
      "\n",
      "Fetching table 5 out of 11 from AD   81...\n",
      "Snoozing for 12 seconds...\n",
      "\n",
      "Fetching table 6 out of 11 from AD   82...\n",
      "Snoozing for 32 seconds...\n",
      "\n",
      "Fetching table 7 out of 11 from AD   83...\n",
      "Snoozing for 17 seconds...\n",
      "\n",
      "Fetching table 8 out of 11 from AD   84...\n",
      "Snoozing for 23 seconds...\n",
      "\n",
      "Fetching table 9 out of 11 from AD   85...\n",
      "Snoozing for 12 seconds...\n",
      "\n",
      "Fetching table 10 out of 11 from AD   86...\n",
      "Snoozing for 21 seconds...\n",
      "\n",
      "Fetching table 11 out of 11 from AD   87...\n",
      "\n",
      "Done!\n"
     ]
    }
   ],
   "source": [
    "# downloading tables\n",
    "\n",
    "counter = 0\n",
    "errors_list = []\n",
    "all_dfs = []\n",
    "\n",
    "for ad_num, target_url in zip(assembly_districts_num, assembly_districts_links):\n",
    "    counter += 1\n",
    "    print(f\"Fetching table {counter} out of {len(assembly_districts_num)} from {ad_num}...\")\n",
    "    \n",
    "    # request each of the urls\n",
    "    response = requests.get(target_url, headers=header)\n",
    "    if 200 <= response.status_code < 400:\n",
    "        try:\n",
    "            # get all dfs per url\n",
    "            # temp_dfs = pd.read_html(response.text)\n",
    "            html_content = StringIO(response.text)\n",
    "            temp_dfs = pd.read_html(html_content)\n",
    "\n",
    "            if len(temp_dfs) > 2:\n",
    "                df = temp_dfs[2]\n",
    "    \n",
    "                # drop unnecessary columns and rows                \n",
    "                df = df.drop(columns=[2, 4, 6, 8, 10, 12])\\\n",
    "                .drop([0, 1])\\\n",
    "                .drop(df.index[-1])\\\n",
    "                .reset_index(drop=True)\n",
    "        \n",
    "                # define new columns\n",
    "                df.columns = [\n",
    "                    \"electoral_district\", \"reported\", \"Harris-Walz_Democratic\",\n",
    "                    \"Trump-Vance_Republican\", \"Trump-Vance_Conservative\", \n",
    "                    \"Harris-Walz_Working_Families\", \"write_in\"\n",
    "                ]\n",
    "\n",
    "                # add new column for assembly district\n",
    "                df[\"assembly_district\"] = ad_num\n",
    "   \n",
    "        except Exception as e:\n",
    "            print(f\"Error fetching {target_url}: {e}\")\n",
    "            errors_list.append(e)\n",
    "\n",
    "    all_dfs.append(df)\n",
    "\n",
    "    if counter <= len(assembly_districts_num) - 1: # so it does not snooze when the downloads are all done\n",
    "        snoozer(12, 34)\n",
    "    print(\"\") # adds a line break per item downloaded    \n",
    "\n",
    "print(\"Done!\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f06614f5-5a82-4a54-bce6-dbb7d37e845b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(all_dfs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "089e4402-ecc4-49d9-87cf-3a724c716f6b",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[   electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    371                    168   \n",
       " 1                ED 2   99.00%                    503                    200   \n",
       " 2                ED 3   99.00%                    471                    144   \n",
       " 3                ED 4   83.33%                     94                     27   \n",
       " 4                ED 5   99.00%                    470                    178   \n",
       " ..                ...      ...                    ...                    ...   \n",
       " 58              ED 59   99.00%                      0                      0   \n",
       " 59              ED 60   99.00%                      0                      0   \n",
       " 60              ED 61   99.00%                      0                      0   \n",
       " 61              ED 62   99.00%                      0                      0   \n",
       " 62              ED 63   99.00%                      0                      0   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                         7                           26        3   \n",
       " 1                         7                           17        6   \n",
       " 2                        18                           12        2   \n",
       " 3                         2                            6        2   \n",
       " 4                        11                           11        2   \n",
       " ..                      ...                          ...      ...   \n",
       " 58                        0                            0        0   \n",
       " 59                        0                            0        0   \n",
       " 60                        0                            0        0   \n",
       " 61                        0                            0        0   \n",
       " 62                        0                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   77  \n",
       " 1            AD   77  \n",
       " 2            AD   77  \n",
       " 3            AD   77  \n",
       " 4            AD   77  \n",
       " ..               ...  \n",
       " 58           AD   77  \n",
       " 59           AD   77  \n",
       " 60           AD   77  \n",
       " 61           AD   77  \n",
       " 62           AD   77  \n",
       " \n",
       " [63 rows x 8 columns],\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    366                    117   \n",
       " 1                ED 2   99.00%                    484                    123   \n",
       " 2                ED 3   99.00%                    407                    142   \n",
       " 3                ED 4   99.00%                    360                     96   \n",
       " 4                ED 5   99.00%                    265                    122   \n",
       " 5                ED 6   99.00%                    262                    115   \n",
       " 6                ED 7   99.00%                    381                    161   \n",
       " 7                ED 8   99.00%                    230                    125   \n",
       " 8                ED 9   99.00%                    229                     96   \n",
       " 9               ED 10   99.00%                    401                    113   \n",
       " 10              ED 11   99.00%                    211                     58   \n",
       " 11              ED 12   87.50%                    243                    119   \n",
       " 12              ED 13   87.50%                    248                     77   \n",
       " 13              ED 14   99.00%                    335                    144   \n",
       " 14              ED 15   99.00%                     64                     33   \n",
       " 15              ED 16   99.00%                    225                     99   \n",
       " 16              ED 17   99.00%                    397                    215   \n",
       " 17              ED 18   99.00%                    373                    203   \n",
       " 18              ED 19   99.00%                    355                    142   \n",
       " 19              ED 20   99.00%                    428                    159   \n",
       " 20              ED 21   99.00%                    309                    171   \n",
       " 21              ED 22   99.00%                    350                    203   \n",
       " 22              ED 23   87.50%                    363                    147   \n",
       " 23              ED 24   87.50%                     56                     18   \n",
       " 24              ED 25   99.00%                    381                    152   \n",
       " 25              ED 26   87.50%                    284                    117   \n",
       " 26              ED 27   87.50%                    379                    170   \n",
       " 27              ED 28   99.00%                    502                    241   \n",
       " 28              ED 29   99.00%                    468                    244   \n",
       " 29              ED 30   99.00%                    452                    162   \n",
       " 30              ED 31   99.00%                    248                     88   \n",
       " 31              ED 32   99.00%                    512                     96   \n",
       " 32              ED 33   90.00%                    354                    191   \n",
       " 33              ED 34   90.00%                    313                    195   \n",
       " 34              ED 35   90.00%                    257                    185   \n",
       " 35              ED 36   99.00%                    512                    182   \n",
       " 36              ED 37   99.00%                    422                    212   \n",
       " 37              ED 38   90.00%                    236                    114   \n",
       " 38              ED 39   99.00%                    366                    196   \n",
       " 39              ED 40   99.00%                    306                    132   \n",
       " 40              ED 41   99.00%                    306                    206   \n",
       " 41              ED 42   99.00%                    376                    163   \n",
       " 42              ED 43   99.00%                    340                    232   \n",
       " 43              ED 44   99.00%                    268                    161   \n",
       " 44              ED 45   99.00%                    248                    120   \n",
       " 45              ED 46   99.00%                    317                    153   \n",
       " 46              ED 47   99.00%                    342                    203   \n",
       " 47              ED 48   99.00%                      1                      1   \n",
       " 48              ED 49   99.00%                    393                    147   \n",
       " 49              ED 50   99.00%                    141                    105   \n",
       " 50              ED 52   99.00%                      0                      0   \n",
       " 51              ED 53   99.00%                      0                      0   \n",
       " 52              ED 54   87.50%                      0                      0   \n",
       " 53              ED 55   99.00%                      0                      0   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                         8                           15        4   \n",
       " 1                         8                           19        4   \n",
       " 2                        11                            9        0   \n",
       " 3                         8                           12        1   \n",
       " 4                         9                           10        4   \n",
       " 5                         6                            9        3   \n",
       " 6                        14                           14        3   \n",
       " 7                         8                            7        8   \n",
       " 8                        10                           12        9   \n",
       " 9                        12                           18        4   \n",
       " 10                        6                           12        6   \n",
       " 11                       12                           14        6   \n",
       " 12                        4                            7        1   \n",
       " 13                       13                           11        3   \n",
       " 14                        4                            3        0   \n",
       " 15                        6                           10        7   \n",
       " 16                        8                            8        9   \n",
       " 17                       12                            8        3   \n",
       " 18                        9                           21        4   \n",
       " 19                       14                           14        5   \n",
       " 20                        5                           17        3   \n",
       " 21                       16                           21        6   \n",
       " 22                        9                           20        8   \n",
       " 23                        0                            2        1   \n",
       " 24                       16                           19       11   \n",
       " 25                        5                           18        5   \n",
       " 26                       16                           21       10   \n",
       " 27                       17                           38       14   \n",
       " 28                       10                           33        5   \n",
       " 29                       11                           21       13   \n",
       " 30                        6                           14        3   \n",
       " 31                        4                           18        7   \n",
       " 32                       12                           12        6   \n",
       " 33                        5                           15        5   \n",
       " 34                        9                           16        3   \n",
       " 35                       15                           14       12   \n",
       " 36                       11                           13        4   \n",
       " 37                        8                           13        0   \n",
       " 38                       16                           21        0   \n",
       " 39                        7                            9        2   \n",
       " 40                       18                           11       11   \n",
       " 41                        3                           13        5   \n",
       " 42                       22                            7        4   \n",
       " 43                       14                           13        8   \n",
       " 44                        2                            2        3   \n",
       " 45                        7                           11        6   \n",
       " 46                        9                           14        3   \n",
       " 47                        0                            0        0   \n",
       " 48                       13                           19       12   \n",
       " 49                        6                            8        4   \n",
       " 50                        0                            0        0   \n",
       " 51                        0                            0        0   \n",
       " 52                        0                            0        0   \n",
       " 53                        0                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   78  \n",
       " 1            AD   78  \n",
       " 2            AD   78  \n",
       " 3            AD   78  \n",
       " 4            AD   78  \n",
       " 5            AD   78  \n",
       " 6            AD   78  \n",
       " 7            AD   78  \n",
       " 8            AD   78  \n",
       " 9            AD   78  \n",
       " 10           AD   78  \n",
       " 11           AD   78  \n",
       " 12           AD   78  \n",
       " 13           AD   78  \n",
       " 14           AD   78  \n",
       " 15           AD   78  \n",
       " 16           AD   78  \n",
       " 17           AD   78  \n",
       " 18           AD   78  \n",
       " 19           AD   78  \n",
       " 20           AD   78  \n",
       " 21           AD   78  \n",
       " 22           AD   78  \n",
       " 23           AD   78  \n",
       " 24           AD   78  \n",
       " 25           AD   78  \n",
       " 26           AD   78  \n",
       " 27           AD   78  \n",
       " 28           AD   78  \n",
       " 29           AD   78  \n",
       " 30           AD   78  \n",
       " 31           AD   78  \n",
       " 32           AD   78  \n",
       " 33           AD   78  \n",
       " 34           AD   78  \n",
       " 35           AD   78  \n",
       " 36           AD   78  \n",
       " 37           AD   78  \n",
       " 38           AD   78  \n",
       " 39           AD   78  \n",
       " 40           AD   78  \n",
       " 41           AD   78  \n",
       " 42           AD   78  \n",
       " 43           AD   78  \n",
       " 44           AD   78  \n",
       " 45           AD   78  \n",
       " 46           AD   78  \n",
       " 47           AD   78  \n",
       " 48           AD   78  \n",
       " 49           AD   78  \n",
       " 50           AD   78  \n",
       " 51           AD   78  \n",
       " 52           AD   78  \n",
       " 53           AD   78  ,\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    464                    103   \n",
       " 1                ED 2   99.00%                     62                     30   \n",
       " 2                ED 3   99.00%                    391                    106   \n",
       " 3                ED 4   99.00%                    267                    124   \n",
       " 4                ED 5   99.00%                    251                     82   \n",
       " 5                ED 6   99.00%                    221                     84   \n",
       " 6                ED 7   99.00%                     51                     13   \n",
       " 7                ED 8   99.00%                    250                     61   \n",
       " 8                ED 9   99.00%                    133                     44   \n",
       " 9               ED 10   99.00%                    345                    101   \n",
       " 10              ED 11   99.00%                    436                    100   \n",
       " 11              ED 12   99.00%                    476                    138   \n",
       " 12              ED 13   99.00%                    365                     74   \n",
       " 13              ED 14   99.00%                    370                    110   \n",
       " 14              ED 15   99.00%                    504                    133   \n",
       " 15              ED 16   99.00%                    245                     62   \n",
       " 16              ED 17   99.00%                    333                    123   \n",
       " 17              ED 18   99.00%                    285                     70   \n",
       " 18              ED 19   99.00%                    190                     50   \n",
       " 19              ED 20   99.00%                    386                    101   \n",
       " 20              ED 21   99.00%                    283                     84   \n",
       " 21              ED 22   99.00%                    380                    119   \n",
       " 22              ED 23   99.00%                    397                    196   \n",
       " 23              ED 24   99.00%                    314                    103   \n",
       " 24              ED 25   99.00%                    206                     76   \n",
       " 25              ED 26   99.00%                    224                     65   \n",
       " 26              ED 27   99.00%                    424                    117   \n",
       " 27              ED 28   99.00%                    506                    132   \n",
       " 28              ED 29   99.00%                    484                    154   \n",
       " 29              ED 30   99.00%                    328                     78   \n",
       " 30              ED 31   99.00%                    312                     98   \n",
       " 31              ED 32   99.00%                    492                    158   \n",
       " 32              ED 33   99.00%                    233                     56   \n",
       " 33              ED 34   99.00%                    406                    158   \n",
       " 34              ED 35   99.00%                    445                    109   \n",
       " 35              ED 36   99.00%                    339                    103   \n",
       " 36              ED 37   99.00%                    449                    149   \n",
       " 37              ED 38   99.00%                    330                    101   \n",
       " 38              ED 39   99.00%                    277                     82   \n",
       " 39              ED 40   99.00%                    513                    138   \n",
       " 40              ED 41   99.00%                    313                     89   \n",
       " 41              ED 42   99.00%                    321                    101   \n",
       " 42              ED 43   99.00%                    707                    155   \n",
       " 43              ED 44   90.00%                    331                    115   \n",
       " 44              ED 45   99.00%                    329                     93   \n",
       " 45              ED 46   99.00%                    493                    149   \n",
       " 46              ED 47   99.00%                    505                    132   \n",
       " 47              ED 48   90.00%                     76                     21   \n",
       " 48              ED 49   90.00%                    147                     53   \n",
       " 49              ED 50   90.00%                    334                    109   \n",
       " 50              ED 51   90.00%                    319                    148   \n",
       " 51              ED 52   90.00%                    354                    105   \n",
       " 52              ED 53   99.00%                    303                     77   \n",
       " 53              ED 54   99.00%                    565                     63   \n",
       " 54              ED 55   99.00%                    690                     92   \n",
       " 55              ED 56   99.00%                    396                     60   \n",
       " 56              ED 57   99.00%                    174                     63   \n",
       " 57              ED 58   99.00%                     65                     23   \n",
       " 58              ED 59   90.00%                    207                     59   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                         8                            8        3   \n",
       " 1                         4                            0        2   \n",
       " 2                         6                           16        1   \n",
       " 3                         7                            7        3   \n",
       " 4                         5                            5        2   \n",
       " 5                         4                            5        2   \n",
       " 6                         1                            2        0   \n",
       " 7                         3                           10        0   \n",
       " 8                         3                            2        1   \n",
       " 9                         7                            2        4   \n",
       " 10                       10                            6        5   \n",
       " 11                       19                           16        2   \n",
       " 12                       12                           12        3   \n",
       " 13                        9                            8        4   \n",
       " 14                       10                           13        5   \n",
       " 15                        4                            7        3   \n",
       " 16                        6                           12        1   \n",
       " 17                        6                           11        3   \n",
       " 18                        2                            4        0   \n",
       " 19                        8                           12        4   \n",
       " 20                        7                           13        7   \n",
       " 21                       10                           11        4   \n",
       " 22                        7                           13        4   \n",
       " 23                        5                           13        1   \n",
       " 24                        2                            6        0   \n",
       " 25                        5                           14        3   \n",
       " 26                       11                           15        5   \n",
       " 27                       11                           23        8   \n",
       " 28                        7                           22        4   \n",
       " 29                        6                           12        2   \n",
       " 30                       11                           13        3   \n",
       " 31                       15                           15        6   \n",
       " 32                        8                           12        3   \n",
       " 33                        9                           15        4   \n",
       " 34                       17                           18        2   \n",
       " 35                       11                            9        6   \n",
       " 36                       13                           13        6   \n",
       " 37                        8                            6        7   \n",
       " 38                        6                            7        2   \n",
       " 39                       12                            6        1   \n",
       " 40                        9                           10        6   \n",
       " 41                       10                           12        3   \n",
       " 42                       19                           32        7   \n",
       " 43                       12                           18        2   \n",
       " 44                        5                           14        3   \n",
       " 45                        9                           27        3   \n",
       " 46                       11                           32        9   \n",
       " 47                        0                            6        1   \n",
       " 48                        2                            5        1   \n",
       " 49                        7                           21        1   \n",
       " 50                       13                           14        6   \n",
       " 51                        6                           11        2   \n",
       " 52                        5                           12        0   \n",
       " 53                       13                           15        6   \n",
       " 54                       17                           26        6   \n",
       " 55                        8                           12        2   \n",
       " 56                        5                            8        3   \n",
       " 57                        4                            4        0   \n",
       " 58                        4                            2        1   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   79  \n",
       " 1            AD   79  \n",
       " 2            AD   79  \n",
       " 3            AD   79  \n",
       " 4            AD   79  \n",
       " 5            AD   79  \n",
       " 6            AD   79  \n",
       " 7            AD   79  \n",
       " 8            AD   79  \n",
       " 9            AD   79  \n",
       " 10           AD   79  \n",
       " 11           AD   79  \n",
       " 12           AD   79  \n",
       " 13           AD   79  \n",
       " 14           AD   79  \n",
       " 15           AD   79  \n",
       " 16           AD   79  \n",
       " 17           AD   79  \n",
       " 18           AD   79  \n",
       " 19           AD   79  \n",
       " 20           AD   79  \n",
       " 21           AD   79  \n",
       " 22           AD   79  \n",
       " 23           AD   79  \n",
       " 24           AD   79  \n",
       " 25           AD   79  \n",
       " 26           AD   79  \n",
       " 27           AD   79  \n",
       " 28           AD   79  \n",
       " 29           AD   79  \n",
       " 30           AD   79  \n",
       " 31           AD   79  \n",
       " 32           AD   79  \n",
       " 33           AD   79  \n",
       " 34           AD   79  \n",
       " 35           AD   79  \n",
       " 36           AD   79  \n",
       " 37           AD   79  \n",
       " 38           AD   79  \n",
       " 39           AD   79  \n",
       " 40           AD   79  \n",
       " 41           AD   79  \n",
       " 42           AD   79  \n",
       " 43           AD   79  \n",
       " 44           AD   79  \n",
       " 45           AD   79  \n",
       " 46           AD   79  \n",
       " 47           AD   79  \n",
       " 48           AD   79  \n",
       " 49           AD   79  \n",
       " 50           AD   79  \n",
       " 51           AD   79  \n",
       " 52           AD   79  \n",
       " 53           AD   79  \n",
       " 54           AD   79  \n",
       " 55           AD   79  \n",
       " 56           AD   79  \n",
       " 57           AD   79  \n",
       " 58           AD   79  ,\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                     85                     30   \n",
       " 1                ED 2   99.00%                    296                    125   \n",
       " 2                ED 3   99.00%                    289                    163   \n",
       " 3                ED 4   99.00%                    175                    220   \n",
       " 4                ED 5   99.00%                    249                    175   \n",
       " ..                ...      ...                    ...                    ...   \n",
       " 62              ED 63   99.00%                    110                     76   \n",
       " 63              ED 64   99.00%                     28                      7   \n",
       " 64              ED 65   99.00%                      0                      0   \n",
       " 65              ED 66   99.00%                      0                      0   \n",
       " 66              ED 67   99.00%                      0                      0   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                         3                            5        2   \n",
       " 1                         6                           12        9   \n",
       " 2                        16                           15       12   \n",
       " 3                        21                            8        6   \n",
       " 4                        11                           19       38   \n",
       " ..                      ...                          ...      ...   \n",
       " 62                        0                            6        2   \n",
       " 63                        1                            0        0   \n",
       " 64                        0                            0        0   \n",
       " 65                        0                            0        0   \n",
       " 66                        0                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   80  \n",
       " 1            AD   80  \n",
       " 2            AD   80  \n",
       " 3            AD   80  \n",
       " 4            AD   80  \n",
       " ..               ...  \n",
       " 62           AD   80  \n",
       " 63           AD   80  \n",
       " 64           AD   80  \n",
       " 65           AD   80  \n",
       " 66           AD   80  \n",
       " \n",
       " [67 rows x 8 columns],\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    323                    176   \n",
       " 1                ED 2   99.00%                    427                    201   \n",
       " 2                ED 3   99.00%                    225                    155   \n",
       " 3                ED 4   99.00%                    256                     84   \n",
       " 4                ED 5   99.00%                    236                    157   \n",
       " ..                ...      ...                    ...                    ...   \n",
       " 58              ED 59   99.00%                    378                     79   \n",
       " 59              ED 60   80.00%                      0                      0   \n",
       " 60              ED 61   99.00%                      0                      0   \n",
       " 61              ED 62   99.00%                      0                      0   \n",
       " 62              ED 63   99.00%                      1                      0   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                        14                            8        9   \n",
       " 1                        16                           23        7   \n",
       " 2                         9                            9        6   \n",
       " 3                         4                            8        1   \n",
       " 4                        10                           23       12   \n",
       " ..                      ...                          ...      ...   \n",
       " 58                        1                            6        3   \n",
       " 59                        0                            0        0   \n",
       " 60                        0                            0        0   \n",
       " 61                        0                            0        0   \n",
       " 62                        0                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   81  \n",
       " 1            AD   81  \n",
       " 2            AD   81  \n",
       " 3            AD   81  \n",
       " 4            AD   81  \n",
       " ..               ...  \n",
       " 58           AD   81  \n",
       " 59           AD   81  \n",
       " 60           AD   81  \n",
       " 61           AD   81  \n",
       " 62           AD   81  \n",
       " \n",
       " [63 rows x 8 columns],\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    295                    557   \n",
       " 1                ED 2   99.00%                    110                    223   \n",
       " 2                ED 3   99.00%                    345                    326   \n",
       " 3                ED 4   99.00%                    338                    335   \n",
       " 4                ED 5   99.00%                    240                    287   \n",
       " ..                ...      ...                    ...                    ...   \n",
       " 74              ED 75   99.00%                      0                      0   \n",
       " 75              ED 76   99.00%                      0                      0   \n",
       " 76              ED 77   99.00%                      0                      0   \n",
       " 77              ED 78   99.00%                      0                      0   \n",
       " 78              ED 79   99.00%                      0                      0   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                        50                           19        8   \n",
       " 1                        21                            4        2   \n",
       " 2                        32                           10       10   \n",
       " 3                        23                           17        4   \n",
       " 4                        26                           15        6   \n",
       " ..                      ...                          ...      ...   \n",
       " 74                        0                            0        0   \n",
       " 75                        0                            0        0   \n",
       " 76                        0                            0        0   \n",
       " 77                        0                            0        0   \n",
       " 78                        0                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   82  \n",
       " 1            AD   82  \n",
       " 2            AD   82  \n",
       " 3            AD   82  \n",
       " 4            AD   82  \n",
       " ..               ...  \n",
       " 74           AD   82  \n",
       " 75           AD   82  \n",
       " 76           AD   82  \n",
       " 77           AD   82  \n",
       " 78           AD   82  \n",
       " \n",
       " [79 rows x 8 columns],\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   88.89%                    632                     87   \n",
       " 1                ED 2   88.89%                    620                     66   \n",
       " 2                ED 3   88.89%                    582                     96   \n",
       " 3                ED 4   88.89%                    496                     52   \n",
       " 4                ED 5   88.89%                    527                     49   \n",
       " ..                ...      ...                    ...                    ...   \n",
       " 62              ED 63   88.89%                    274                     16   \n",
       " 63              ED 64   88.89%                     66                     12   \n",
       " 64              ED 65   88.89%                     59                     14   \n",
       " 65              ED 66   99.00%                    126                      9   \n",
       " 66              ED 67   99.00%                    101                      8   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                         9                            5        1   \n",
       " 1                        14                           20        8   \n",
       " 2                        17                           17        5   \n",
       " 3                         6                           16        2   \n",
       " 4                        11                            9        3   \n",
       " ..                      ...                          ...      ...   \n",
       " 62                        2                            6        0   \n",
       " 63                        2                            5        0   \n",
       " 64                        1                            3        0   \n",
       " 65                        2                            2        0   \n",
       " 66                        1                            2        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   83  \n",
       " 1            AD   83  \n",
       " 2            AD   83  \n",
       " 3            AD   83  \n",
       " 4            AD   83  \n",
       " ..               ...  \n",
       " 62           AD   83  \n",
       " 63           AD   83  \n",
       " 64           AD   83  \n",
       " 65           AD   83  \n",
       " 66           AD   83  \n",
       " \n",
       " [67 rows x 8 columns],\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    478                    209   \n",
       " 1                ED 2   99.00%                    146                     62   \n",
       " 2                ED 3   99.00%                    377                    213   \n",
       " 3                ED 4   99.00%                    432                    203   \n",
       " 4                ED 5   99.00%                    417                    177   \n",
       " ..                ...      ...                    ...                    ...   \n",
       " 62              ED 63   83.33%                      0                      0   \n",
       " 63              ED 64   99.00%                    123                     46   \n",
       " 64              ED 65   99.00%                    158                     67   \n",
       " 65              ED 66   99.00%                    142                     32   \n",
       " 66              ED 67   99.00%                    219                     23   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                        10                            7        5   \n",
       " 1                         4                            7        1   \n",
       " 2                         8                           11        2   \n",
       " 3                        12                           15       12   \n",
       " 4                         9                           13        4   \n",
       " ..                      ...                          ...      ...   \n",
       " 62                        0                            0        0   \n",
       " 63                        3                            7        1   \n",
       " 64                        2                            5        3   \n",
       " 65                        5                           19        3   \n",
       " 66                        5                           14        2   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   84  \n",
       " 1            AD   84  \n",
       " 2            AD   84  \n",
       " 3            AD   84  \n",
       " 4            AD   84  \n",
       " ..               ...  \n",
       " 62           AD   84  \n",
       " 63           AD   84  \n",
       " 64           AD   84  \n",
       " 65           AD   84  \n",
       " 66           AD   84  \n",
       " \n",
       " [67 rows x 8 columns],\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    747                    177   \n",
       " 1                ED 2   83.33%                    492                    188   \n",
       " 2                ED 3   83.33%                    367                    179   \n",
       " 3                ED 4   99.00%                    409                    185   \n",
       " 4                ED 5   99.00%                    588                    179   \n",
       " ..                ...      ...                    ...                    ...   \n",
       " 81              ED 82   99.00%                      0                      0   \n",
       " 82              ED 83   99.00%                      0                      0   \n",
       " 83              ED 84   99.00%                     43                      8   \n",
       " 84              ED 85   83.33%                     12                      9   \n",
       " 85              ED 86   83.33%                      1                      5   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                        22                           47        9   \n",
       " 1                        15                           26        8   \n",
       " 2                         7                           12        7   \n",
       " 3                        14                           21        7   \n",
       " 4                         8                           25       13   \n",
       " ..                      ...                          ...      ...   \n",
       " 81                        0                            0        0   \n",
       " 82                        0                            0        0   \n",
       " 83                        2                            0        0   \n",
       " 84                        0                            0        0   \n",
       " 85                        1                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   85  \n",
       " 1            AD   85  \n",
       " 2            AD   85  \n",
       " 3            AD   85  \n",
       " 4            AD   85  \n",
       " ..               ...  \n",
       " 81           AD   85  \n",
       " 82           AD   85  \n",
       " 83           AD   85  \n",
       " 84           AD   85  \n",
       " 85           AD   85  \n",
       " \n",
       " [86 rows x 8 columns],\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    338                    151   \n",
       " 1                ED 2   99.00%                    422                    168   \n",
       " 2                ED 3   99.00%                     46                     17   \n",
       " 3                ED 4   99.00%                    339                    151   \n",
       " 4                ED 5   99.00%                    324                    184   \n",
       " 5                ED 6   99.00%                    305                    170   \n",
       " 6                ED 7   99.00%                    445                    207   \n",
       " 7                ED 8   99.00%                    301                    172   \n",
       " 8                ED 9   99.00%                    486                    230   \n",
       " 9               ED 10   85.71%                    335                    103   \n",
       " 10              ED 11   85.71%                    278                    131   \n",
       " 11              ED 12   99.00%                    388                    178   \n",
       " 12              ED 13   99.00%                    363                    256   \n",
       " 13              ED 14   99.00%                    292                    155   \n",
       " 14              ED 15   99.00%                    266                    100   \n",
       " 15              ED 16   99.00%                    414                    187   \n",
       " 16              ED 17   99.00%                    287                    105   \n",
       " 17              ED 18   99.00%                    362                    190   \n",
       " 18              ED 19   99.00%                    307                    162   \n",
       " 19              ED 20   99.00%                    302                    132   \n",
       " 20              ED 21   99.00%                    323                    186   \n",
       " 21              ED 22   99.00%                    293                    132   \n",
       " 22              ED 23   99.00%                    296                    127   \n",
       " 23              ED 24   99.00%                    256                    175   \n",
       " 24              ED 25   99.00%                    222                    183   \n",
       " 25              ED 26   90.00%                    338                    193   \n",
       " 26              ED 27   90.00%                    261                    134   \n",
       " 27              ED 28   90.00%                    257                    110   \n",
       " 28              ED 29   90.00%                    248                    123   \n",
       " 29              ED 30   99.00%                    350                    205   \n",
       " 30              ED 31   99.00%                    408                    134   \n",
       " 31              ED 32   99.00%                    336                    105   \n",
       " 32              ED 33   99.00%                    426                    216   \n",
       " 33              ED 34   99.00%                    297                    175   \n",
       " 34              ED 35   99.00%                    184                     54   \n",
       " 35              ED 36   99.00%                    279                     93   \n",
       " 36              ED 37   99.00%                    378                    129   \n",
       " 37              ED 38   99.00%                    389                    136   \n",
       " 38              ED 39   99.00%                    209                     86   \n",
       " 39              ED 40   99.00%                     39                     23   \n",
       " 40              ED 41   99.00%                    368                    147   \n",
       " 41              ED 42   99.00%                     39                     15   \n",
       " 42              ED 43   99.00%                    375                    144   \n",
       " 43              ED 44   99.00%                     90                     37   \n",
       " 44              ED 45   99.00%                     62                     42   \n",
       " 45              ED 46   99.00%                    208                    117   \n",
       " 46              ED 47   99.00%                    316                    137   \n",
       " 47              ED 48   99.00%                    258                    115   \n",
       " 48              ED 49   99.00%                    433                    134   \n",
       " 49              ED 50   99.00%                    384                    189   \n",
       " 50              ED 51   99.00%                    336                    187   \n",
       " 51              ED 52   99.00%                    393                    232   \n",
       " 52              ED 53   99.00%                    269                    122   \n",
       " 53              ED 54   99.00%                      0                      0   \n",
       " 54              ED 55   99.00%                      0                      0   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                         7                            8        2   \n",
       " 1                        10                           14        5   \n",
       " 2                         0                            3        2   \n",
       " 3                         7                            8        4   \n",
       " 4                        11                           11        2   \n",
       " 5                         6                           10        5   \n",
       " 6                        10                            7        7   \n",
       " 7                        10                           15        5   \n",
       " 8                        16                           15        2   \n",
       " 9                        12                            5        8   \n",
       " 10                       10                            9        3   \n",
       " 11                        5                           11        2   \n",
       " 12                       13                           13        7   \n",
       " 13                        5                            4        4   \n",
       " 14                        6                            3        4   \n",
       " 15                       13                            7       21   \n",
       " 16                        3                           10        1   \n",
       " 17                       11                            3        5   \n",
       " 18                        9                           16        2   \n",
       " 19                        5                           11        6   \n",
       " 20                       11                            3        2   \n",
       " 21                        9                            7        5   \n",
       " 22                        6                           14        8   \n",
       " 23                        8                            7        2   \n",
       " 24                        8                            6        2   \n",
       " 25                       10                            9        2   \n",
       " 26                        5                           11        2   \n",
       " 27                       11                           17        3   \n",
       " 28                        7                           12        4   \n",
       " 29                       10                           16        9   \n",
       " 30                       11                           16        4   \n",
       " 31                        5                           14        4   \n",
       " 32                       17                            4        2   \n",
       " 33                        9                            7        5   \n",
       " 34                        2                            7        0   \n",
       " 35                        8                            5        5   \n",
       " 36                        7                           15        5   \n",
       " 37                       11                           16        3   \n",
       " 38                       10                            9        1   \n",
       " 39                        0                            3        0   \n",
       " 40                       10                           12        5   \n",
       " 41                        0                            1        0   \n",
       " 42                        7                           11        5   \n",
       " 43                        0                            2        2   \n",
       " 44                        1                            3        0   \n",
       " 45                        5                            7        2   \n",
       " 46                        6                            6        1   \n",
       " 47                        7                           11        4   \n",
       " 48                       11                           12        3   \n",
       " 49                        8                           23        5   \n",
       " 50                        7                            6        5   \n",
       " 51                        9                            8        6   \n",
       " 52                        8                           12        3   \n",
       " 53                        0                            0        0   \n",
       " 54                        0                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   86  \n",
       " 1            AD   86  \n",
       " 2            AD   86  \n",
       " 3            AD   86  \n",
       " 4            AD   86  \n",
       " 5            AD   86  \n",
       " 6            AD   86  \n",
       " 7            AD   86  \n",
       " 8            AD   86  \n",
       " 9            AD   86  \n",
       " 10           AD   86  \n",
       " 11           AD   86  \n",
       " 12           AD   86  \n",
       " 13           AD   86  \n",
       " 14           AD   86  \n",
       " 15           AD   86  \n",
       " 16           AD   86  \n",
       " 17           AD   86  \n",
       " 18           AD   86  \n",
       " 19           AD   86  \n",
       " 20           AD   86  \n",
       " 21           AD   86  \n",
       " 22           AD   86  \n",
       " 23           AD   86  \n",
       " 24           AD   86  \n",
       " 25           AD   86  \n",
       " 26           AD   86  \n",
       " 27           AD   86  \n",
       " 28           AD   86  \n",
       " 29           AD   86  \n",
       " 30           AD   86  \n",
       " 31           AD   86  \n",
       " 32           AD   86  \n",
       " 33           AD   86  \n",
       " 34           AD   86  \n",
       " 35           AD   86  \n",
       " 36           AD   86  \n",
       " 37           AD   86  \n",
       " 38           AD   86  \n",
       " 39           AD   86  \n",
       " 40           AD   86  \n",
       " 41           AD   86  \n",
       " 42           AD   86  \n",
       " 43           AD   86  \n",
       " 44           AD   86  \n",
       " 45           AD   86  \n",
       " 46           AD   86  \n",
       " 47           AD   86  \n",
       " 48           AD   86  \n",
       " 49           AD   86  \n",
       " 50           AD   86  \n",
       " 51           AD   86  \n",
       " 52           AD   86  \n",
       " 53           AD   86  \n",
       " 54           AD   86  ,\n",
       "    electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       " 0                ED 1   99.00%                    121                     30   \n",
       " 1                ED 2   99.00%                    363                    152   \n",
       " 2                ED 3   99.00%                    407                    194   \n",
       " 3                ED 4   99.00%                    221                     83   \n",
       " 4                ED 5   99.00%                    168                     57   \n",
       " 5                ED 6   99.00%                    487                    166   \n",
       " 6                ED 7   99.00%                    449                    142   \n",
       " 7                ED 8   99.00%                    141                     50   \n",
       " 8                ED 9   99.00%                    468                    154   \n",
       " 9               ED 10   99.00%                    303                    119   \n",
       " 10              ED 11   99.00%                    386                    171   \n",
       " 11              ED 12   99.00%                    359                    112   \n",
       " 12              ED 13   99.00%                    334                    117   \n",
       " 13              ED 14   99.00%                    492                    144   \n",
       " 14              ED 15   99.00%                    559                    100   \n",
       " 15              ED 16   99.00%                    517                    125   \n",
       " 16              ED 17   99.00%                    457                     85   \n",
       " 17              ED 18   99.00%                    610                     97   \n",
       " 18              ED 19   99.00%                    599                    115   \n",
       " 19              ED 20   99.00%                    479                     93   \n",
       " 20              ED 21   99.00%                    471                    108   \n",
       " 21              ED 22   99.00%                    505                    132   \n",
       " 22              ED 23   99.00%                    593                    138   \n",
       " 23              ED 24   99.00%                    560                    160   \n",
       " 24              ED 25   85.71%                    502                    164   \n",
       " 25              ED 26   85.71%                    466                    156   \n",
       " 26              ED 27   85.71%                    405                    163   \n",
       " 27              ED 28   99.00%                    434                    204   \n",
       " 28              ED 29   99.00%                    374                    136   \n",
       " 29              ED 30   99.00%                    413                    193   \n",
       " 30              ED 31   99.00%                    421                    243   \n",
       " 31              ED 32   99.00%                    429                    227   \n",
       " 32              ED 33   99.00%                      1                      3   \n",
       " 33              ED 34   99.00%                    134                     72   \n",
       " 34              ED 35   99.00%                    314                    105   \n",
       " 35              ED 36   99.00%                     43                     33   \n",
       " 36              ED 37   99.00%                     34                      8   \n",
       " 37              ED 38   99.00%                    363                    202   \n",
       " 38              ED 39   99.00%                    350                    240   \n",
       " 39              ED 40   99.00%                    405                    152   \n",
       " 40              ED 41   99.00%                    283                    197   \n",
       " 41              ED 42   99.00%                    506                    182   \n",
       " 42              ED 43   99.00%                    331                    152   \n",
       " 43              ED 44   99.00%                    349                    159   \n",
       " 44              ED 45   99.00%                    456                    192   \n",
       " 45              ED 46   99.00%                    488                    102   \n",
       " 46              ED 47   99.00%                    457                    197   \n",
       " 47              ED 48   99.00%                    461                    186   \n",
       " 48              ED 49   99.00%                    545                    116   \n",
       " 49              ED 50   99.00%                    337                     92   \n",
       " 50              ED 51   99.00%                    384                    116   \n",
       " 51              ED 52   99.00%                    323                     60   \n",
       " 52              ED 53   99.00%                    480                    129   \n",
       " 53              ED 54   99.00%                    574                    117   \n",
       " 54              ED 55   99.00%                    448                    166   \n",
       " 55              ED 56   99.00%                      4                      3   \n",
       " 56              ED 57   99.00%                      0                      0   \n",
       " 57              ED 58   99.00%                      0                      0   \n",
       " 58              ED 59   99.00%                      0                      0   \n",
       " \n",
       "    Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       " 0                         2                            6        0   \n",
       " 1                         9                           12        3   \n",
       " 2                        10                           15        5   \n",
       " 3                         8                            6        3   \n",
       " 4                         3                            2        0   \n",
       " 5                        12                           23        6   \n",
       " 6                         6                           13        7   \n",
       " 7                         4                            5        2   \n",
       " 8                        12                           18        4   \n",
       " 9                        12                           12        4   \n",
       " 10                       16                           17       11   \n",
       " 11                        7                           33        8   \n",
       " 12                       10                            8       12   \n",
       " 13                        6                           24       29   \n",
       " 14                       14                           18       12   \n",
       " 15                        9                           17       10   \n",
       " 16                        7                           21       16   \n",
       " 17                       11                           25       15   \n",
       " 18                       15                           23       12   \n",
       " 19                        8                           25       14   \n",
       " 20                       10                           45        5   \n",
       " 21                       15                           25        9   \n",
       " 22                       15                           38       17   \n",
       " 23                       15                           24       31   \n",
       " 24                       13                           22       14   \n",
       " 25                       14                           11       20   \n",
       " 26                       11                           25       21   \n",
       " 27                       14                           19       17   \n",
       " 28                       11                           25       26   \n",
       " 29                       19                           15       26   \n",
       " 30                       18                           20       32   \n",
       " 31                       16                           19       21   \n",
       " 32                        1                            0        0   \n",
       " 33                        6                           11       10   \n",
       " 34                        7                           21        5   \n",
       " 35                        1                            1        0   \n",
       " 36                        0                            0        0   \n",
       " 37                        9                           13       14   \n",
       " 38                        5                           15       22   \n",
       " 39                        8                            6       18   \n",
       " 40                        7                           14       25   \n",
       " 41                       19                           26       22   \n",
       " 42                        7                           11       19   \n",
       " 43                       17                           14       24   \n",
       " 44                       19                           15       16   \n",
       " 45                       10                           12        1   \n",
       " 46                       19                           21       11   \n",
       " 47                       12                           26        8   \n",
       " 48                       11                           21        3   \n",
       " 49                       10                            5        1   \n",
       " 50                        7                           13        2   \n",
       " 51                        5                           18        1   \n",
       " 52                       13                            9        8   \n",
       " 53                        5                           19        1   \n",
       " 54                       13                           18        8   \n",
       " 55                        0                            1        0   \n",
       " 56                        0                            0        0   \n",
       " 57                        0                            0        0   \n",
       " 58                        0                            0        0   \n",
       " \n",
       "    assembly_district  \n",
       " 0            AD   87  \n",
       " 1            AD   87  \n",
       " 2            AD   87  \n",
       " 3            AD   87  \n",
       " 4            AD   87  \n",
       " 5            AD   87  \n",
       " 6            AD   87  \n",
       " 7            AD   87  \n",
       " 8            AD   87  \n",
       " 9            AD   87  \n",
       " 10           AD   87  \n",
       " 11           AD   87  \n",
       " 12           AD   87  \n",
       " 13           AD   87  \n",
       " 14           AD   87  \n",
       " 15           AD   87  \n",
       " 16           AD   87  \n",
       " 17           AD   87  \n",
       " 18           AD   87  \n",
       " 19           AD   87  \n",
       " 20           AD   87  \n",
       " 21           AD   87  \n",
       " 22           AD   87  \n",
       " 23           AD   87  \n",
       " 24           AD   87  \n",
       " 25           AD   87  \n",
       " 26           AD   87  \n",
       " 27           AD   87  \n",
       " 28           AD   87  \n",
       " 29           AD   87  \n",
       " 30           AD   87  \n",
       " 31           AD   87  \n",
       " 32           AD   87  \n",
       " 33           AD   87  \n",
       " 34           AD   87  \n",
       " 35           AD   87  \n",
       " 36           AD   87  \n",
       " 37           AD   87  \n",
       " 38           AD   87  \n",
       " 39           AD   87  \n",
       " 40           AD   87  \n",
       " 41           AD   87  \n",
       " 42           AD   87  \n",
       " 43           AD   87  \n",
       " 44           AD   87  \n",
       " 45           AD   87  \n",
       " 46           AD   87  \n",
       " 47           AD   87  \n",
       " 48           AD   87  \n",
       " 49           AD   87  \n",
       " 50           AD   87  \n",
       " 51           AD   87  \n",
       " 52           AD   87  \n",
       " 53           AD   87  \n",
       " 54           AD   87  \n",
       " 55           AD   87  \n",
       " 56           AD   87  \n",
       " 57           AD   87  \n",
       " 58           AD   87  ]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_dfs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "a5884c83-e645-463c-89de-107fd13271dd",
   "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>electoral_district</th>\n",
       "      <th>reported</th>\n",
       "      <th>Harris-Walz_Democratic</th>\n",
       "      <th>Trump-Vance_Republican</th>\n",
       "      <th>Trump-Vance_Conservative</th>\n",
       "      <th>Harris-Walz_Working_Families</th>\n",
       "      <th>write_in</th>\n",
       "      <th>assembly_district</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ED 1</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>371</td>\n",
       "      <td>168</td>\n",
       "      <td>7</td>\n",
       "      <td>26</td>\n",
       "      <td>3</td>\n",
       "      <td>AD   77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ED 2</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>503</td>\n",
       "      <td>200</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>6</td>\n",
       "      <td>AD   77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ED 3</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>471</td>\n",
       "      <td>144</td>\n",
       "      <td>18</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>AD   77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ED 4</td>\n",
       "      <td>83.33%</td>\n",
       "      <td>94</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>AD   77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ED 5</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>470</td>\n",
       "      <td>178</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>AD   77</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>ED 55</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>448</td>\n",
       "      <td>166</td>\n",
       "      <td>13</td>\n",
       "      <td>18</td>\n",
       "      <td>8</td>\n",
       "      <td>AD   87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>ED 56</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>AD   87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>ED 57</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>AD   87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>ED 58</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>AD   87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>ED 59</td>\n",
       "      <td>99.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>AD   87</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>719 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   electoral_district reported Harris-Walz_Democratic Trump-Vance_Republican  \\\n",
       "0                ED 1   99.00%                    371                    168   \n",
       "1                ED 2   99.00%                    503                    200   \n",
       "2                ED 3   99.00%                    471                    144   \n",
       "3                ED 4   83.33%                     94                     27   \n",
       "4                ED 5   99.00%                    470                    178   \n",
       "..                ...      ...                    ...                    ...   \n",
       "54              ED 55   99.00%                    448                    166   \n",
       "55              ED 56   99.00%                      4                      3   \n",
       "56              ED 57   99.00%                      0                      0   \n",
       "57              ED 58   99.00%                      0                      0   \n",
       "58              ED 59   99.00%                      0                      0   \n",
       "\n",
       "   Trump-Vance_Conservative Harris-Walz_Working_Families write_in  \\\n",
       "0                         7                           26        3   \n",
       "1                         7                           17        6   \n",
       "2                        18                           12        2   \n",
       "3                         2                            6        2   \n",
       "4                        11                           11        2   \n",
       "..                      ...                          ...      ...   \n",
       "54                       13                           18        8   \n",
       "55                        0                            1        0   \n",
       "56                        0                            0        0   \n",
       "57                        0                            0        0   \n",
       "58                        0                            0        0   \n",
       "\n",
       "   assembly_district  \n",
       "0            AD   77  \n",
       "1            AD   77  \n",
       "2            AD   77  \n",
       "3            AD   77  \n",
       "4            AD   77  \n",
       "..               ...  \n",
       "54           AD   87  \n",
       "55           AD   87  \n",
       "56           AD   87  \n",
       "57           AD   87  \n",
       "58           AD   87  \n",
       "\n",
       "[719 rows x 8 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results = pd.concat(all_dfs, axis=0)\n",
    "results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "5d3432dc-9485-416f-9b99-989ee427f6b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "results.to_csv(\"electoral_district_votes.csv\", encoding=\"UTF-8\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "36c31c96-ab1c-49ce-83d8-8cb36fe54ff6",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}