02_Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "5fb1fec8",
   "metadata": {},
   "source": [
    "# Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "a39e7ec8",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "import altair as alt\n",
    "\n",
    "alt.renderers.enable('default')\n",
    "\n",
    "%run ../altair-theme/arics_theme.py"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "852c219d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       "@import url('https://fonts.googleapis.com');\n",
       "@import url('https://fonts.gstatic.com');\n",
       "@import url('https://fonts.googleapis.com/css2?family=Roboto+Mono&display=swap');\n",
       "</style>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%%html\n",
    "<style>\n",
    "@import url('https://fonts.googleapis.com');\n",
    "@import url('https://fonts.gstatic.com');\n",
    "@import url('https://fonts.googleapis.com/css2?family=Roboto+Mono&display=swap');\n",
    "</style>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "af5f3560",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ThemeRegistry.enable('arics_theme')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Register the custom theme and give it a name.\n",
    "alt.themes.register('arics_theme', arics_theme)\n",
    "\n",
    "# Enable the theme\n",
    "alt.themes.enable('arics_theme')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "2d1ce975",
   "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>recipientName</th>\n",
       "      <th>recipientCommitteeName</th>\n",
       "      <th>officeSought</th>\n",
       "      <th>ballotIssue</th>\n",
       "      <th>contributorName</th>\n",
       "      <th>amount</th>\n",
       "      <th>date</th>\n",
       "      <th>contributorCity</th>\n",
       "      <th>contributorStateCode</th>\n",
       "      <th>zipCode</th>\n",
       "      <th>address1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ean Tafoya</td>\n",
       "      <td>Tafoya for Mayor</td>\n",
       "      <td>Mayor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nicole Servino</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2023-02-28T07:00:00</td>\n",
       "      <td>Denver</td>\n",
       "      <td>CO</td>\n",
       "      <td>80205</td>\n",
       "      <td>2947 Stout St</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ean Tafoya</td>\n",
       "      <td>Tafoya for Mayor</td>\n",
       "      <td>Mayor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Paula Bard</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2023-02-28T07:00:00</td>\n",
       "      <td>Morrison</td>\n",
       "      <td>CO</td>\n",
       "      <td>80465</td>\n",
       "      <td>10250 city view drive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ean Tafoya</td>\n",
       "      <td>Tafoya for Mayor</td>\n",
       "      <td>Mayor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lauren Swain</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2023-02-28T07:00:00</td>\n",
       "      <td>Denver</td>\n",
       "      <td>CO</td>\n",
       "      <td>80212</td>\n",
       "      <td>3277 N Raleigh St</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Leslie Herod</td>\n",
       "      <td>Leslie for Mayor</td>\n",
       "      <td>Mayor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tegan Kissane</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2023-02-28T07:00:00</td>\n",
       "      <td>Denver</td>\n",
       "      <td>CO</td>\n",
       "      <td>80207</td>\n",
       "      <td>2580 Cherry Street</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Leslie Herod</td>\n",
       "      <td>Leslie for Mayor</td>\n",
       "      <td>Mayor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Taylor Jordan</td>\n",
       "      <td>80.0</td>\n",
       "      <td>2023-02-28T07:00:00</td>\n",
       "      <td>Denver</td>\n",
       "      <td>CO</td>\n",
       "      <td>80205</td>\n",
       "      <td>2134 N Williams St</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  recipientName recipientCommitteeName officeSought  ballotIssue  \\\n",
       "0    Ean Tafoya      Tafoya for Mayor         Mayor          NaN   \n",
       "1    Ean Tafoya      Tafoya for Mayor         Mayor          NaN   \n",
       "2    Ean Tafoya      Tafoya for Mayor         Mayor          NaN   \n",
       "3  Leslie Herod       Leslie for Mayor        Mayor          NaN   \n",
       "4  Leslie Herod       Leslie for Mayor        Mayor          NaN   \n",
       "\n",
       "  contributorName  amount                 date contributorCity  \\\n",
       "0  Nicole Servino    25.0  2023-02-28T07:00:00          Denver   \n",
       "1      Paula Bard    10.0  2023-02-28T07:00:00        Morrison   \n",
       "2    Lauren Swain     5.0  2023-02-28T07:00:00          Denver   \n",
       "3   Tegan Kissane    50.0  2023-02-28T07:00:00          Denver   \n",
       "4   Taylor Jordan    80.0  2023-02-28T07:00:00          Denver   \n",
       "\n",
       "  contributorStateCode zipCode               address1  \n",
       "0                   CO   80205          2947 Stout St  \n",
       "1                   CO   80465  10250 city view drive  \n",
       "2                   CO   80212      3277 N Raleigh St  \n",
       "3                   CO   80207     2580 Cherry Street  \n",
       "4                   CO   80205     2134 N Williams St  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contribs_df = pd.read_csv(\"mayoral_contribs.csv\", usecols=[\n",
    "    \"recipientName\", \n",
    "    \"recipientCommitteeName\", \n",
    "    \"officeSought\", \n",
    "    \"ballotIssue\", \n",
    "    \"contributorName\", \n",
    "    \"address1\", \n",
    "    \"contributorCity\", \n",
    "    \"contributorStateCode\", \n",
    "    \"zipCode\", \n",
    "    \"amount\", \n",
    "    \"date\"\n",
    "], dtype={\"zipCode\": str}\n",
    ")\n",
    "contribs_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "30fb49cd",
   "metadata": {},
   "source": [
    "### Remove contributions to the current mayor."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "56f64d1d",
   "metadata": {},
   "outputs": [],
   "source": [
    "contribs_df = contribs_df[~(contribs_df[\"recipientName\"] == \"Michael Hancock\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "5ce18d2c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5311683.021"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Total cash in the mayoral race\n",
    "contribs_df[\"amount\"].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5fcf0ac8",
   "metadata": {},
   "source": [
    "## Totals by recipient"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "733f3843",
   "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>recipientName</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Kelly Brough</td>\n",
       "      <td>1148363.651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Andre Rougeot</td>\n",
       "      <td>797857.890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Leslie Herod</td>\n",
       "      <td>756602.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Mike Johnston</td>\n",
       "      <td>728240.440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chris Hansen</td>\n",
       "      <td>443011.510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Deborah Ortega</td>\n",
       "      <td>332727.090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Kwame Spearman</td>\n",
       "      <td>219074.250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Lisa Calderon</td>\n",
       "      <td>181629.240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ean Tafoya</td>\n",
       "      <td>153092.930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Trinidad Rodriguez</td>\n",
       "      <td>151036.260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Thomas Wolf</td>\n",
       "      <td>119119.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Terrance Roberts</td>\n",
       "      <td>90315.280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>James Walsh</td>\n",
       "      <td>60580.950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alex Valdez</td>\n",
       "      <td>56601.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Aurelio Martinez</td>\n",
       "      <td>49384.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Al Gardner</td>\n",
       "      <td>13505.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Anna Burrell</td>\n",
       "      <td>5984.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Jesse Parris</td>\n",
       "      <td>4003.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Renate Behrens</td>\n",
       "      <td>429.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Robert Treta</td>\n",
       "      <td>125.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         recipientName       amount\n",
       "10        Kelly Brough  1148363.651\n",
       "2        Andre Rougeot   797857.890\n",
       "12        Leslie Herod   756602.030\n",
       "14       Mike Johnston   728240.440\n",
       "5         Chris Hansen   443011.510\n",
       "6       Deborah Ortega   332727.090\n",
       "11      Kwame Spearman   219074.250\n",
       "13       Lisa Calderon   181629.240\n",
       "7           Ean Tafoya   153092.930\n",
       "19  Trinidad Rodriguez   151036.260\n",
       "18         Thomas Wolf   119119.700\n",
       "17    Terrance Roberts    90315.280\n",
       "8          James Walsh    60580.950\n",
       "1          Alex Valdez    56601.000\n",
       "4     Aurelio Martinez    49384.800\n",
       "0           Al Gardner    13505.000\n",
       "3         Anna Burrell     5984.000\n",
       "9         Jesse Parris     4003.000\n",
       "15      Renate Behrens      429.000\n",
       "16        Robert Treta      125.000"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Clean up names before grouping\n",
    "contribs_df[\"recipientName\"] = contribs_df[\"recipientName\"].str.replace(\"  \", \" \")\n",
    "contribs_df[\"recipientName\"] = contribs_df[\"recipientName\"].str.strip()\n",
    "contribs_df[\"recipientName\"] = contribs_df[\"recipientName\"].str.replace(\"Calderón\", \"Calderon\")\n",
    "\n",
    "# Group and save\n",
    "recipient_totals = contribs_df.groupby(\"recipientName\")[\"amount\"].sum().reset_index()\n",
    "recipient_totals.to_csv(\"recipient_totals.csv\", index=False)\n",
    "recipient_totals.sort_values(\"amount\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "dda51b72",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-c6ad09d76e0b44f8bec32248f1bf4439\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-c6ad09d76e0b44f8bec32248f1bf4439\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-c6ad09d76e0b44f8bec32248f1bf4439\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"width\": 700, \"config\": {\"arc\": {\"fill\": \"#15616D\"}, \"area\": {\"fill\": \"#15616D\"}, \"bar\": {\"size\": 20, \"binSpacing\": 10, \"continuousBandSize\": 5, \"fill\": \"#15616D\", \"stroke\": false}, \"circle\": {\"fill\": \"#15616D\", \"stroke\": \"#363636\", \"strokeWidth\": 0.5}, \"line\": {\"stroke\": \"#15616D\"}, \"path\": {\"stroke\": \"#15616D\"}, \"point\": {\"stroke\": \"#15616D\"}, \"rect\": {\"fill\": \"#15616D\"}, \"shape\": {\"stroke\": \"#15616D\"}, \"symbol\": {\"fill\": \"#15616D\"}, \"title\": {\"font\": \"Roboto Mono\", \"color\": \"#363636\", \"fontSize\": 20.0, \"anchor\": \"start\"}, \"axis\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8, \"gridColor\": \"#b9c4c1\", \"domainColor\": \"#363636\"}, \"header\": {\"labelFont\": \"Roboto Mono\", \"titleFont\": \"Roboto Mono\", \"labelFontSize\": 16, \"titleFontSize\": 16}, \"legend\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8}, \"range\": {\"category\": [\"#001524\", \"#15616D\", \"#ACBDBA\", \"#FF7D00\", \"#78290F\"], \"diverging\": [\"#850018\", \"#cd1549\", \"#f6618d\", \"#fbafc4\", \"#f5f5f5\", \"#93c5fe\", \"#5091e6\", \"#1d5ebd\", \"#002f84\"], \"heatmap\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ramp\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ordinal\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"]}}, \"layer\": [{\"mark\": \"bar\", \"encoding\": {\"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"labelFontSize\": 12, \"labelPadding\": 2, \"title\": \"\"}, \"field\": \"last_name\", \"sort\": \"-x\", \"type\": \"nominal\"}}}, {\"mark\": {\"type\": \"text\", \"align\": \"left\", \"baseline\": \"middle\", \"dx\": 3}, \"encoding\": {\"text\": {\"field\": \"amount\", \"format\": \"$.3s\", \"type\": \"quantitative\"}, \"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"labelFontSize\": 12, \"labelPadding\": 2, \"title\": \"\"}, \"field\": \"last_name\", \"sort\": \"-x\", \"type\": \"nominal\"}}}], \"data\": {\"name\": \"data-ded817ea127b1f0ca6708cdd4660c3a1\"}, \"height\": 700, \"title\": {\"text\": \"Denver Mayoral candidate contributions\"}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-ded817ea127b1f0ca6708cdd4660c3a1\": [{\"recipientName\": \"Al Gardner\", \"amount\": 13505.0, \"last_name\": \"Gardner\"}, {\"recipientName\": \"Alex Valdez\", \"amount\": 56601.0, \"last_name\": \"Valdez\"}, {\"recipientName\": \"Andre Rougeot\", \"amount\": 797857.89, \"last_name\": \"Rougeot\"}, {\"recipientName\": \"Anna Burrell\", \"amount\": 5984.0, \"last_name\": \"Burrell\"}, {\"recipientName\": \"Aurelio Martinez\", \"amount\": 49384.8, \"last_name\": \"Martinez\"}, {\"recipientName\": \"Chris Hansen\", \"amount\": 443011.51, \"last_name\": \"Hansen\"}, {\"recipientName\": \"Deborah Ortega\", \"amount\": 332727.09, \"last_name\": \"Ortega\"}, {\"recipientName\": \"Ean Tafoya\", \"amount\": 153092.93000000002, \"last_name\": \"Tafoya\"}, {\"recipientName\": \"James Walsh\", \"amount\": 60580.95, \"last_name\": \"Walsh\"}, {\"recipientName\": \"Jesse Parris\", \"amount\": 4003.0, \"last_name\": \"Parris\"}, {\"recipientName\": \"Kelly Brough\", \"amount\": 1148363.651, \"last_name\": \"Brough\"}, {\"recipientName\": \"Kwame Spearman\", \"amount\": 219074.25, \"last_name\": \"Spearman\"}, {\"recipientName\": \"Leslie Herod\", \"amount\": 756602.03, \"last_name\": \"Herod\"}, {\"recipientName\": \"Lisa Calderon\", \"amount\": 181629.24, \"last_name\": \"Calderon\"}, {\"recipientName\": \"Mike Johnston\", \"amount\": 728240.44, \"last_name\": \"Johnston\"}, {\"recipientName\": \"Renate Behrens\", \"amount\": 429.0, \"last_name\": \"Behrens\"}, {\"recipientName\": \"Robert Treta\", \"amount\": 125.0, \"last_name\": \"Treta\"}, {\"recipientName\": \"Terrance Roberts\", \"amount\": 90315.28, \"last_name\": \"Roberts\"}, {\"recipientName\": \"Thomas Wolf\", \"amount\": 119119.7, \"last_name\": \"Wolf\"}, {\"recipientName\": \"Trinidad Rodriguez\", \"amount\": 151036.26, \"last_name\": \"Rodriguez\"}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.LayerChart(...)"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recipient_totals[\"last_name\"] = recipient_totals[\"recipientName\"].apply(lambda x: x.split(\" \")[-1])\n",
    "\n",
    "bars = alt.Chart(recipient_totals).mark_bar().encode(\n",
    "    x=alt.X('amount', axis=alt.Axis(format='$.2s', title='Contributions')),\n",
    "    y=alt.Y('last_name', axis=alt.Axis(title='', labelFontSize=12, labelPadding=2), sort='-x'),\n",
    ")\n",
    "\n",
    "text = bars.mark_text(\n",
    "    align='left',\n",
    "    baseline='middle',\n",
    "    dx=3  # Nudges text to right so it doesn't appear on top of the bar\n",
    ").encode(\n",
    "    text=alt.Text( 'amount:Q', format='$.3s'),\n",
    ")\n",
    "\n",
    "\n",
    "(bars + text).properties(\n",
    "    title={\n",
    "        \"text\":\"Denver Mayoral candidate contributions\",\n",
    "#         \"subtitle\":\"Cash raised as of March 12, 2023\"\n",
    "    },\n",
    "    height=700,\n",
    "    width=700\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a170aa50",
   "metadata": {},
   "source": [
    "## Top donors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f17a181c",
   "metadata": {},
   "outputs": [],
   "source": [
    "donor_totals = contribs_df[~contribs_df[\"contributorName\"].isin([\"Denver Fair Elections Fund Disbursement\", \"Previous Balance\", \"Unitemized\"])]\n",
    "donor_totals = donor_totals.groupby([\"contributorName\"])[\"amount\"].sum().reset_index()\n",
    "donor_totals_top_10 = donor_totals.sort_values(\"amount\", ascending=False).reset_index().head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "ab8a93b0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-4ca0faa33d434a48bdb71953aafe373c\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-4ca0faa33d434a48bdb71953aafe373c\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-4ca0faa33d434a48bdb71953aafe373c\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"width\": 600, \"config\": {\"arc\": {\"fill\": \"#15616D\"}, \"area\": {\"fill\": \"#15616D\"}, \"bar\": {\"size\": 20, \"binSpacing\": 10, \"continuousBandSize\": 5, \"fill\": \"#15616D\", \"stroke\": false}, \"circle\": {\"fill\": \"#15616D\", \"stroke\": \"#363636\", \"strokeWidth\": 0.5}, \"line\": {\"stroke\": \"#15616D\"}, \"path\": {\"stroke\": \"#15616D\"}, \"point\": {\"stroke\": \"#15616D\"}, \"rect\": {\"fill\": \"#15616D\"}, \"shape\": {\"stroke\": \"#15616D\"}, \"symbol\": {\"fill\": \"#15616D\"}, \"title\": {\"font\": \"Roboto Mono\", \"color\": \"#363636\", \"fontSize\": 20.0, \"anchor\": \"start\"}, \"axis\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8, \"gridColor\": \"#b9c4c1\", \"domainColor\": \"#363636\"}, \"header\": {\"labelFont\": \"Roboto Mono\", \"titleFont\": \"Roboto Mono\", \"labelFontSize\": 16, \"titleFontSize\": 16}, \"legend\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8}, \"range\": {\"category\": [\"#001524\", \"#15616D\", \"#ACBDBA\", \"#FF7D00\", \"#78290F\"], \"diverging\": [\"#850018\", \"#cd1549\", \"#f6618d\", \"#fbafc4\", \"#f5f5f5\", \"#93c5fe\", \"#5091e6\", \"#1d5ebd\", \"#002f84\"], \"heatmap\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ramp\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ordinal\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"]}}, \"layer\": [{\"mark\": \"bar\", \"encoding\": {\"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"labelFontSize\": 12, \"title\": \"\"}, \"field\": \"split_name\", \"sort\": \"-x\", \"type\": \"nominal\"}}}, {\"mark\": {\"type\": \"text\", \"align\": \"left\", \"baseline\": \"middle\", \"dx\": 3}, \"encoding\": {\"text\": {\"field\": \"amount\", \"format\": \"$.3s\", \"type\": \"quantitative\"}, \"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"labelFontSize\": 12, \"title\": \"\"}, \"field\": \"split_name\", \"sort\": \"-x\", \"type\": \"nominal\"}}}], \"data\": {\"name\": \"data-0aede87cb53209de799534c160f02df8\"}, \"height\": 500, \"title\": {\"text\": \"Top donors\"}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-0aede87cb53209de799534c160f02df8\": [{\"index\": 662, \"contributorName\": \"Andre Rougcot\", \"amount\": 753562.6699999999, \"split_name\": [\"Andre Rougcot\"]}, {\"index\": 1029, \"contributorName\": \"Apartment Association of Metro Denver Denver Small Donor Committee\", \"amount\": 16000.0, \"split_name\": [\"Apartment Association \", \" Metro Denver Denver Small Donor Committee\"]}, {\"index\": 13261, \"contributorName\": \"Trinidad Rodriguez\", \"amount\": 5500.0, \"split_name\": [\"Trinidad Rodriguez\"]}, {\"index\": 7706, \"contributorName\": \"Kwame Spearman\", \"amount\": 5500.0, \"split_name\": [\"Kwame Spearman\"]}, {\"index\": 10307, \"contributorName\": \"Ortega at Large\", \"amount\": 5023.09, \"split_name\": [\"Ortega at Large\"]}, {\"index\": 10830, \"contributorName\": \"Rachel Romer\", \"amount\": 3500.0, \"split_name\": [\"Rachel Romer\"]}, {\"index\": 5395, \"contributorName\": \"James Iacino\", \"amount\": 3100.0, \"split_name\": [\"James Iacino\"]}, {\"index\": 3267, \"contributorName\": \"Dawn Bookhardt\", \"amount\": 3000.0, \"split_name\": [\"Dawn Bookhardt\"]}, {\"index\": 6153, \"contributorName\": \"Jim Walsh\", \"amount\": 3000.0, \"split_name\": [\"Jim Walsh\"]}, {\"index\": 895, \"contributorName\": \"Anna Burrell\", \"amount\": 2720.0, \"split_name\": [\"Anna Burrell\"]}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.LayerChart(...)"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# donor_totals_top_10[\"split_name\"] = donor_totals_top_10[\"contributorName\"].str.split(\"of\")\n",
    "donor_totals_top_10_chart = alt.Chart(donor_totals_top_10).mark_bar().encode(\n",
    "    x=alt.X('amount', axis=alt.Axis(format='$.2s', title='Contributions')),\n",
    "    y=alt.Y('split_name', axis=alt.Axis(title='', labelFontSize=12), sort='-x', ),\n",
    ")\n",
    "\n",
    "donor_totals_top_10_text = donor_totals_top_10_chart.mark_text(\n",
    "    align='left',\n",
    "    baseline='middle',\n",
    "    dx=3 \n",
    ").encode(\n",
    "    text=alt.Text( 'amount:Q', format='$.3s'),\n",
    ")\n",
    "\n",
    "\n",
    "(donor_totals_top_10_chart + donor_totals_top_10_text).properties(\n",
    "    title={\n",
    "        \"text\":\"Top donors\",\n",
    "#         \"subtitle\":\"Cash raised as of March 12, 2023\"\n",
    "    },\n",
    "    height=500,\n",
    "    width=600\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "35a1b830",
   "metadata": {},
   "source": [
    "## Top donors for each candidate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "2c4f7018",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/bq/b_2ct9jx66z1nh9qsrcwrbhh0000gn/T/ipykernel_27473/3049385735.py:3: FutureWarning: In a future version of pandas, a length 1 tuple will be returned when iterating over a groupby with a grouper equal to a list of length 1. Don't supply a list with a single grouper to avoid this warning.\n",
      "  for group_name, df_group in contributors_grouped.groupby([\"recipientName\"]):\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Al Gardner top donors\n",
      "   index recipientName     contributorName  amount\n",
      "0     31    Al Gardner     Eddie Victorian   500.0\n",
      "1     67    Al Gardner          Mark Jones   500.0\n",
      "2     18    Al Gardner  Christopher Marino   500.0\n",
      "3     16    Al Gardner       Chris Roberts   500.0\n",
      "4     90    Al Gardner      Ronald Zappolo   500.0\n",
      "Alex Valdez top donors\n",
      "   index recipientName  contributorName  amount\n",
      "0    292   Alex Valdez      John Morris  1000.0\n",
      "1    416   Alex Valdez  Philip Kingston   500.0\n",
      "2    488   Alex Valdez     Travis Berry   500.0\n",
      "3    149   Alex Valdez    Beth Kerttula   500.0\n",
      "4    151   Alex Valdez     Bob Satawake   500.0\n",
      "Andre Rougeot top donors\n",
      "   index  recipientName                                    contributorName  \\\n",
      "0    517  Andre Rougeot                                      Andre Rougcot   \n",
      "1    520  Andre Rougeot  Apartment Association of Metro Denver Denver S...   \n",
      "2    587  Andre Rougeot                                       Kaylyn Stone   \n",
      "3    509  Andre Rougeot                                      Aaron Stolear   \n",
      "4    608  Andre Rougeot                                       Mark Johnson   \n",
      "\n",
      "      amount  \n",
      "0  753562.67  \n",
      "1    2000.00  \n",
      "2    1000.00  \n",
      "3    1000.00  \n",
      "4    1000.00  \n",
      "Anna Burrell top donors\n",
      "   index recipientName    contributorName  amount\n",
      "0    684  Anna Burrell       Anna Burrell  2700.0\n",
      "1    698  Anna Burrell  Elizabeth Steiner   500.0\n",
      "2    707  Anna Burrell        Laszlo Soos   250.0\n",
      "3    694  Anna Burrell   Christina Garcia   221.0\n",
      "4    704  Anna Burrell     Jeffery Kinsey   150.0\n",
      "Aurelio Martinez top donors\n",
      "   index     recipientName                          contributorName    amount\n",
      "0    814  Aurelio Martinez  Denver Fair Elections Fund Disbursement  37259.82\n",
      "1    947  Aurelio Martinez                               Marc Mares    500.00\n",
      "2    762  Aurelio Martinez                             Arthur Stapp    500.00\n",
      "3    935  Aurelio Martinez                           Loretta DeLeon    500.00\n",
      "4    749  Aurelio Martinez                          Angelica Damian    500.00\n",
      "Chris Hansen top donors\n",
      "   index recipientName                                    contributorName  \\\n",
      "0   1419  Chris Hansen            Denver Fair Elections Fund Disbursement   \n",
      "1   1189  Chris Hansen  Apartment Association of Metro Denver Denver S...   \n",
      "2   1696  Chris Hansen                                    Jeanne Saunders   \n",
      "3   1132  Chris Hansen                                   Adriene Callahan   \n",
      "4   1717  Chris Hansen                                     Jennifer Drake   \n",
      "\n",
      "     amount  \n",
      "0  255960.0  \n",
      "1    5000.0  \n",
      "2    1000.0  \n",
      "3     850.0  \n",
      "4     800.0  \n",
      "Deborah Ortega top donors\n",
      "   index   recipientName                                    contributorName  \\\n",
      "0   2854  Deborah Ortega            Denver Fair Elections Fund Disbursement   \n",
      "1   3330  Deborah Ortega                                    Ortega at Large   \n",
      "2   2693  Deborah Ortega  Apartment Association of Metro Denver Denver S...   \n",
      "3   3234  Deborah Ortega                                     Martha Eubanks   \n",
      "4   3593  Deborah Ortega                                        thomas gart   \n",
      "\n",
      "      amount  \n",
      "0  195165.00  \n",
      "1    5023.09  \n",
      "2    2000.00  \n",
      "3     550.00  \n",
      "4     500.00  \n",
      "Ean Tafoya top donors\n",
      "   index recipientName                          contributorName     amount\n",
      "0   3823    Ean Tafoya  Denver Fair Elections Fund Disbursement  107012.07\n",
      "1   3843    Ean Tafoya                               Ean Tafoya    2500.00\n",
      "2   3733    Ean Tafoya                             Carol Miller     550.00\n",
      "3   4069    Ean Tafoya                             Joyce Keller     500.00\n",
      "4   3757    Ean Tafoya                         Christian Chiari     500.00\n",
      "James Walsh top donors\n",
      "   index recipientName                          contributorName   amount\n",
      "0   4643   James Walsh  Denver Fair Elections Fund Disbursement  41454.0\n",
      "1   4731   James Walsh                                Jim Walsh   3000.0\n",
      "2   4712   James Walsh                              James Walsh   1155.0\n",
      "3   4771   James Walsh                            Lammot Dupont    500.0\n",
      "4   4623   James Walsh                        Daniel Fitzgerald    500.0\n",
      "Jesse Parris top donors\n",
      "   index recipientName   contributorName  amount\n",
      "0   5037  Jesse Parris  Raverro Stinnett  2000.0\n",
      "1   5032  Jesse Parris     Norman Harris   250.0\n",
      "2   5031  Jesse Parris   Maedella Stiger   209.0\n",
      "3   5016  Jesse Parris    Carol Harrison   100.0\n",
      "4   5042  Jesse Parris     Sandy Robnett   100.0\n",
      "Kelly Brough top donors\n",
      "   index recipientName                                    contributorName  \\\n",
      "0   5685  Kelly Brough            Denver Fair Elections Fund Disbursement   \n",
      "1   5216  Kelly Brough  Apartment Association of Metro Denver Denver S...   \n",
      "2   5706  Kelly Brough                               Dominic Cingoranelli   \n",
      "3   6321  Kelly Brough                                        Karen Klein   \n",
      "4   6448  Kelly Brough                                        Kirk Monroe   \n",
      "\n",
      "      amount  \n",
      "0  530491.41  \n",
      "1    5000.00  \n",
      "2    1000.00  \n",
      "3     550.00  \n",
      "4     517.90  \n",
      "Kwame Spearman top donors\n",
      "   index   recipientName                          contributorName    amount\n",
      "0   7795  Kwame Spearman  Denver Fair Elections Fund Disbursement  118440.0\n",
      "1   8078  Kwame Spearman                           Kwame Spearman    5500.0\n",
      "2   8306  Kwame Spearman                            Priya Burkett     600.0\n",
      "3   8522  Kwame Spearman                         William spearman     550.0\n",
      "4   7688  Kwame Spearman                            Carissa Cerbo     550.0\n",
      "Leslie Herod top donors\n",
      "   index recipientName                          contributorName     amount\n",
      "0   9192  Leslie Herod  Denver Fair Elections Fund Disbursement  441231.12\n",
      "1   9877  Leslie Herod                      Katherine Rosechild     815.00\n",
      "2   9361  Leslie Herod                            Ethan Hackley     600.00\n",
      "3  11049  Leslie Herod                          Wellington Webb     550.00\n",
      "4  10009  Leslie Herod                          Laraine Guyette     540.00\n",
      "Lisa Calderon top donors\n",
      "   index  recipientName                          contributorName     amount\n",
      "0  11343  Lisa Calderon  Denver Fair Elections Fund Disbursement  116704.98\n",
      "1  11574  Lisa Calderon                                Kent Webb     600.00\n",
      "2  11524  Lisa Calderon                        Jonathon Calderon     550.00\n",
      "3  11149  Lisa Calderon                               Ageno Otii     505.00\n",
      "4  11446  Lisa Calderon                           Henry Alvarado     500.00\n",
      "Mike Johnston top donors\n",
      "   index  recipientName                                    contributorName  \\\n",
      "0  12616  Mike Johnston            Denver Fair Elections Fund Disbursement   \n",
      "1  12144  Mike Johnston  Apartment Association of Metro Denver Denver S...   \n",
      "2  13484  Mike Johnston                                       Loring Amass   \n",
      "3  14013  Mike Johnston                                Roger Kent Erickson   \n",
      "4  13808  Mike Johnston                                       Noel Congdon   \n",
      "\n",
      "     amount  \n",
      "0  253035.0  \n",
      "1    2000.0  \n",
      "2     850.0  \n",
      "3     750.0  \n",
      "4     600.0  \n",
      "Renate Behrens top donors\n",
      "   index   recipientName      contributorName  amount\n",
      "0  14413  Renate Behrens       Renate Behrens   408.0\n",
      "1  14414  Renate Behrens  anonymous anonymous    21.0\n",
      "Robert Treta top donors\n",
      "   index recipientName  contributorName  amount\n",
      "0  14415  Robert Treta      David Ahern    50.0\n",
      "1  14418  Robert Treta  Margaret Sweeny    50.0\n",
      "2  14417  Robert Treta     Lisa Ramirez    20.0\n",
      "3  14416  Robert Treta     Gordon Stone     5.0\n",
      "Terrance Roberts top donors\n",
      "   index     recipientName                          contributorName   amount\n",
      "0  14534  Terrance Roberts  Denver Fair Elections Fund Disbursement  64278.0\n",
      "1  14516  Terrance Roberts                             Dan Levinson    550.0\n",
      "2  14686  Terrance Roberts                             Lecrae Moore    500.0\n",
      "3  14500  Terrance Roberts                              Chris Myers    500.0\n",
      "4  14719  Terrance Roberts                               Marvin Lee    500.0\n",
      "Thomas Wolf top donors\n",
      "   index recipientName                          contributorName    amount\n",
      "0  14980   Thomas Wolf  Denver Fair Elections Fund Disbursement  97634.43\n",
      "1  15048   Thomas Wolf                             Jay Coughlon    500.00\n",
      "2  15057   Thomas Wolf                               Jim Kelley    500.00\n",
      "3  15025   Thomas Wolf                         Harrison Hellner    500.00\n",
      "4  15148   Thomas Wolf                            Monica Vernon    500.00\n",
      "Trinidad Rodriguez top donors\n",
      "   index       recipientName                          contributorName  \\\n",
      "0  15345  Trinidad Rodriguez  Denver Fair Elections Fund Disbursement   \n",
      "1  15673  Trinidad Rodriguez                       Trinidad Rodriguez   \n",
      "2  15601  Trinidad Rodriguez                         Regina Rodriguez   \n",
      "3  15617  Trinidad Rodriguez                              Roxane Baca   \n",
      "4  15520  Trinidad Rodriguez                           Maria Eckstein   \n",
      "\n",
      "     amount  \n",
      "0  88595.37  \n",
      "1   5500.00  \n",
      "2    758.75  \n",
      "3    600.00  \n",
      "4    500.00  \n"
     ]
    }
   ],
   "source": [
    "contributors_grouped = contribs_df.groupby([\"recipientName\", \"contributorName\"])[\"amount\"].sum().reset_index()\n",
    "contributors_grouped.to_csv(\"top_donors.csv\", index=False)\n",
    "for group_name, df_group in contributors_grouped.groupby([\"recipientName\"]):\n",
    "    top_donors = df_group.sort_values(\"amount\", ascending=False).reset_index().head(5)\n",
    "    print(f\"{group_name} top donors\")\n",
    "    print(top_donors)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e07e522b",
   "metadata": {},
   "source": [
    "## Out of state donations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "800b5f26",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "367606.58"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# What's the total from out of state?\n",
    "outside_co_df = contribs_df[contribs_df[\"contributorStateCode\"].str.upper() != \"CO\"]\n",
    "oos_total = outside_co_df[\"amount\"].sum()\n",
    "oos_total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "69917b75",
   "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>contributorName</th>\n",
       "      <th>contributorStateCode</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ariel Kiyomi Daoud</td>\n",
       "      <td>OH</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Audrey Kennedy</td>\n",
       "      <td>CA</td>\n",
       "      <td>250.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dahvi Wilson</td>\n",
       "      <td>VA</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>David Amster-Olszewski</td>\n",
       "      <td>CA</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jeff Hansen</td>\n",
       "      <td>KS</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2053</th>\n",
       "      <td>steve treegoob</td>\n",
       "      <td>OR</td>\n",
       "      <td>6.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2054</th>\n",
       "      <td>stuart pierre</td>\n",
       "      <td>NY</td>\n",
       "      <td>1.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2055</th>\n",
       "      <td>thomas england</td>\n",
       "      <td>NY</td>\n",
       "      <td>6.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2056</th>\n",
       "      <td>todd stribley</td>\n",
       "      <td>VA</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2057</th>\n",
       "      <td>walter smith</td>\n",
       "      <td>PA</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2058 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              contributorName contributorStateCode  amount\n",
       "0          Ariel Kiyomi Daoud                   OH   50.00\n",
       "1              Audrey Kennedy                   CA  250.00\n",
       "2                Dahvi Wilson                   VA   50.00\n",
       "3      David Amster-Olszewski                   CA   50.00\n",
       "4                 Jeff Hansen                   KS   65.00\n",
       "...                       ...                  ...     ...\n",
       "2053           steve treegoob                   OR    6.75\n",
       "2054            stuart pierre                   NY    1.25\n",
       "2055           thomas england                   NY    6.25\n",
       "2056            todd stribley                   VA   50.00\n",
       "2057             walter smith                   PA    2.50\n",
       "\n",
       "[2058 rows x 3 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outside_co_df.groupby([\"contributorName\", \"contributorStateCode\"])[\"amount\"].sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b1f99da2",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/bq/b_2ct9jx66z1nh9qsrcwrbhh0000gn/T/ipykernel_27473/840519579.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  outside_co_df[\"contributorStateCode\"] = outside_co_df[\"contributorStateCode\"].str.upper()\n",
      "/Users/achokey/Library/Caches/pypoetry/virtualenvs/notebooks-loWCrMEE-py3.9/lib/python3.9/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.\n",
      "  for col_name, dtype in df.dtypes.iteritems():\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-d90a5ff0e0954f72ba16afff9b668c74\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-d90a5ff0e0954f72ba16afff9b668c74\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-d90a5ff0e0954f72ba16afff9b668c74\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"width\": 800, \"config\": {\"arc\": {\"fill\": \"#15616D\"}, \"area\": {\"fill\": \"#15616D\"}, \"bar\": {\"size\": 20, \"binSpacing\": 10, \"continuousBandSize\": 5, \"fill\": \"#15616D\", \"stroke\": false}, \"circle\": {\"fill\": \"#15616D\", \"stroke\": \"#363636\", \"strokeWidth\": 0.5}, \"line\": {\"stroke\": \"#15616D\"}, \"path\": {\"stroke\": \"#15616D\"}, \"point\": {\"stroke\": \"#15616D\"}, \"rect\": {\"fill\": \"#15616D\"}, \"shape\": {\"stroke\": \"#15616D\"}, \"symbol\": {\"fill\": \"#15616D\"}, \"title\": {\"font\": \"Roboto Mono\", \"color\": \"#363636\", \"fontSize\": 20.0, \"anchor\": \"start\"}, \"axis\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8, \"gridColor\": \"#b9c4c1\", \"domainColor\": \"#363636\"}, \"header\": {\"labelFont\": \"Roboto Mono\", \"titleFont\": \"Roboto Mono\", \"labelFontSize\": 16, \"titleFontSize\": 16}, \"legend\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8}, \"range\": {\"category\": [\"#001524\", \"#15616D\", \"#ACBDBA\", \"#FF7D00\", \"#78290F\"], \"diverging\": [\"#850018\", \"#cd1549\", \"#f6618d\", \"#fbafc4\", \"#f5f5f5\", \"#93c5fe\", \"#5091e6\", \"#1d5ebd\", \"#002f84\"], \"heatmap\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ramp\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ordinal\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"]}}, \"layer\": [{\"mark\": \"bar\", \"encoding\": {\"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"title\": \"\"}, \"field\": \"contributorStateCode\", \"sort\": \"-x\", \"type\": \"nominal\"}}}, {\"mark\": {\"type\": \"text\", \"align\": \"left\", \"baseline\": \"middle\", \"dx\": 3}, \"encoding\": {\"text\": {\"field\": \"amount\", \"format\": \"$.3s\", \"type\": \"quantitative\"}, \"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"title\": \"\"}, \"field\": \"contributorStateCode\", \"sort\": \"-x\", \"type\": \"nominal\"}}}], \"data\": {\"name\": \"data-30a28360051deb1a02f549aa0f86b822\"}, \"height\": 1200, \"title\": {\"text\": \"Out-of-state sources\"}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-30a28360051deb1a02f549aa0f86b822\": [{\"contributorStateCode\": \"AE\", \"amount\": 100.0}, {\"contributorStateCode\": \"AK\", \"amount\": 1000.0}, {\"contributorStateCode\": \"AL\", \"amount\": 320.0}, {\"contributorStateCode\": \"AR\", \"amount\": 200.0}, {\"contributorStateCode\": \"AZ\", \"amount\": 4257.99}, {\"contributorStateCode\": \"CA\", \"amount\": 71268.7}, {\"contributorStateCode\": \"CT\", \"amount\": 10564.4}, {\"contributorStateCode\": \"DC\", \"amount\": 32576.98}, {\"contributorStateCode\": \"DE\", \"amount\": 460.0}, {\"contributorStateCode\": \"FL\", \"amount\": 8730.42}, {\"contributorStateCode\": \"GA\", \"amount\": 9469.45}, {\"contributorStateCode\": \"HI\", \"amount\": 760.5}, {\"contributorStateCode\": \"IA\", \"amount\": 1445.0}, {\"contributorStateCode\": \"ID\", \"amount\": 350.0}, {\"contributorStateCode\": \"IL\", \"amount\": 11395.75}, {\"contributorStateCode\": \"IN\", \"amount\": 3620.21}, {\"contributorStateCode\": \"KS\", \"amount\": 2530.0}, {\"contributorStateCode\": \"KY\", \"amount\": 623.5}, {\"contributorStateCode\": \"LA\", \"amount\": 3744.21}, {\"contributorStateCode\": \"MA\", \"amount\": 23850.23}, {\"contributorStateCode\": \"MD\", \"amount\": 10217.15}, {\"contributorStateCode\": \"ME\", \"amount\": 281.88}, {\"contributorStateCode\": \"MI\", \"amount\": 1760.11}, {\"contributorStateCode\": \"MN\", \"amount\": 2320.75}, {\"contributorStateCode\": \"MO\", \"amount\": 3249.25}, {\"contributorStateCode\": \"MS\", \"amount\": 250.0}, {\"contributorStateCode\": \"MT\", \"amount\": 733.23}, {\"contributorStateCode\": \"NC\", \"amount\": 3287.25}, {\"contributorStateCode\": \"NE\", \"amount\": 2071.5}, {\"contributorStateCode\": \"NH\", \"amount\": 477.5}, {\"contributorStateCode\": \"NJ\", \"amount\": 10334.01}, {\"contributorStateCode\": \"NM\", \"amount\": 5277.5}, {\"contributorStateCode\": \"NV\", \"amount\": 4018.7}, {\"contributorStateCode\": \"NY\", \"amount\": 54149.63}, {\"contributorStateCode\": \"OH\", \"amount\": 2010.13}, {\"contributorStateCode\": \"OK\", \"amount\": 1536.7}, {\"contributorStateCode\": \"OR\", \"amount\": 1631.75}, {\"contributorStateCode\": \"PA\", \"amount\": 5164.65}, {\"contributorStateCode\": \"PR\", \"amount\": 500.0}, {\"contributorStateCode\": \"RI\", \"amount\": 5402.5}, {\"contributorStateCode\": \"SC\", \"amount\": 1200.0}, {\"contributorStateCode\": \"SD\", \"amount\": 580.0}, {\"contributorStateCode\": \"TN\", \"amount\": 5460.82}, {\"contributorStateCode\": \"TX\", \"amount\": 33728.56}, {\"contributorStateCode\": \"UT\", \"amount\": 2166.95}, {\"contributorStateCode\": \"VA\", \"amount\": 7961.0}, {\"contributorStateCode\": \"VT\", \"amount\": 2581.83}, {\"contributorStateCode\": \"WA\", \"amount\": 8774.39}, {\"contributorStateCode\": \"WI\", \"amount\": 1902.5}, {\"contributorStateCode\": \"WV\", \"amount\": 300.0}, {\"contributorStateCode\": \"WY\", \"amount\": 320.0}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.LayerChart(...)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outside_co_df[\"contributorStateCode\"] = outside_co_df[\"contributorStateCode\"].str.upper()\n",
    "outside_by_state = outside_co_df.groupby([\"contributorStateCode\"])[\"amount\"].sum().reset_index()\n",
    "\n",
    "\n",
    "# Chart\n",
    "outside_by_state_chart = alt.Chart(outside_by_state).mark_bar().encode(\n",
    "    x=alt.X('amount', axis=alt.Axis(format='$.2s', title='Contributions')),\n",
    "    y=alt.Y('contributorStateCode', axis=alt.Axis(title=''), sort='-x'),\n",
    ")\n",
    "\n",
    "outside_by_state_text = outside_by_state_chart.mark_text(\n",
    "    align='left',\n",
    "    baseline='middle',\n",
    "    dx=3  # Nudges text to right so it doesn't appear on top of the bar\n",
    ").encode(\n",
    "    text=alt.Text( 'amount:Q', format='$.3s'),\n",
    ")\n",
    "\n",
    "\n",
    "(outside_by_state_chart + outside_by_state_text).properties(\n",
    "    title={\n",
    "        \"text\":\"Out-of-state sources\",\n",
    "#         \"subtitle\":\"Cash raised as of March 12, 2023\"\n",
    "    },\n",
    "    height=1200,\n",
    "    width=800\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9dc7b56a",
   "metadata": {},
   "source": [
    "## Top out-of-state donors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "feff53a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "top_outside_donors = outside_co_df.groupby([\"contributorName\", \"contributorStateCode\"])[\"amount\"].sum().reset_index()\n",
    "top_outside_donors = top_outside_donors.sort_values(\"amount\", ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "d29a46c6",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/achokey/Library/Caches/pypoetry/virtualenvs/notebooks-loWCrMEE-py3.9/lib/python3.9/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.\n",
      "  for col_name, dtype in df.dtypes.iteritems():\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-646152d42c33420fb2740ca262b74cc6\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-646152d42c33420fb2740ca262b74cc6\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-646152d42c33420fb2740ca262b74cc6\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"width\": 800, \"config\": {\"arc\": {\"fill\": \"#15616D\"}, \"area\": {\"fill\": \"#15616D\"}, \"bar\": {\"size\": 20, \"binSpacing\": 10, \"continuousBandSize\": 5, \"fill\": \"#15616D\", \"stroke\": false}, \"circle\": {\"fill\": \"#15616D\", \"stroke\": \"#363636\", \"strokeWidth\": 0.5}, \"line\": {\"stroke\": \"#15616D\"}, \"path\": {\"stroke\": \"#15616D\"}, \"point\": {\"stroke\": \"#15616D\"}, \"rect\": {\"fill\": \"#15616D\"}, \"shape\": {\"stroke\": \"#15616D\"}, \"symbol\": {\"fill\": \"#15616D\"}, \"title\": {\"font\": \"Roboto Mono\", \"color\": \"#363636\", \"fontSize\": 20.0, \"anchor\": \"start\"}, \"axis\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8, \"gridColor\": \"#b9c4c1\", \"domainColor\": \"#363636\"}, \"header\": {\"labelFont\": \"Roboto Mono\", \"titleFont\": \"Roboto Mono\", \"labelFontSize\": 16, \"titleFontSize\": 16}, \"legend\": {\"titleFont\": \"Roboto Mono\", \"titleColor\": \"#363636\", \"titleFontSize\": 12.8, \"labelFont\": \"Roboto Mono\", \"labelColor\": \"#363636\", \"labelFontSize\": 12.8}, \"range\": {\"category\": [\"#001524\", \"#15616D\", \"#ACBDBA\", \"#FF7D00\", \"#78290F\"], \"diverging\": [\"#850018\", \"#cd1549\", \"#f6618d\", \"#fbafc4\", \"#f5f5f5\", \"#93c5fe\", \"#5091e6\", \"#1d5ebd\", \"#002f84\"], \"heatmap\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ramp\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"], \"ordinal\": [\"#ffb5d4\", \"#ff97b8\", \"#ff7499\", \"#fc4c78\", \"#ec245f\", \"#d2004b\", \"#b10034\", \"#91001f\", \"#720008\"]}}, \"layer\": [{\"mark\": \"bar\", \"encoding\": {\"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"title\": \"\"}, \"field\": \"contributorName\", \"sort\": \"-x\", \"type\": \"nominal\"}}}, {\"mark\": {\"type\": \"text\", \"align\": \"left\", \"baseline\": \"middle\", \"dx\": 3}, \"encoding\": {\"text\": {\"field\": \"amount\", \"format\": \"$.2s\", \"type\": \"quantitative\"}, \"x\": {\"axis\": {\"format\": \"$.2s\", \"title\": \"Contributions\"}, \"field\": \"amount\", \"type\": \"quantitative\"}, \"y\": {\"axis\": {\"title\": \"\"}, \"field\": \"contributorName\", \"sort\": \"-x\", \"type\": \"nominal\"}}}], \"data\": {\"name\": \"data-cc7467f4a5dd10736f81e9ad9d32329b\"}, \"height\": 400, \"title\": {\"text\": \"Top out-of-state donors\"}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-cc7467f4a5dd10736f81e9ad9d32329b\": [{\"contributorName\": \"Aaron Stolear\", \"contributorStateCode\": \"FL\", \"amount\": 1000.0}, {\"contributorName\": \"Rosalie Waxman\", \"contributorStateCode\": \"CA\", \"amount\": 1000.0}, {\"contributorName\": \"Joseph Goldsmith\", \"contributorStateCode\": \"CA\", \"amount\": 1000.0}, {\"contributorName\": \"Lily Rougeot\", \"contributorStateCode\": \"NJ\", \"amount\": 1000.0}, {\"contributorName\": \"Jonathan Sheedy\", \"contributorStateCode\": \"IN\", \"amount\": 1000.0}, {\"contributorName\": \"Kaylyn Stone\", \"contributorStateCode\": \"GA\", \"amount\": 1000.0}, {\"contributorName\": \"Jeanandre Rougeot\", \"contributorStateCode\": \"CA\", \"amount\": 1000.0}, {\"contributorName\": \"Keith Tyler\", \"contributorStateCode\": \"WA\", \"amount\": 1000.0}, {\"contributorName\": \"Jonah Waxman\", \"contributorStateCode\": \"MN\", \"amount\": 1000.0}, {\"contributorName\": \"William Wojcieszek\", \"contributorStateCode\": \"IN\", \"amount\": 1000.0}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.LayerChart(...)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Chart\n",
    "top_outside_donors_chart = alt.Chart(top_outside_donors).mark_bar().encode(\n",
    "    x=alt.X('amount', axis=alt.Axis(format='$.2s', title='Contributions')),\n",
    "    y=alt.Y('contributorName', axis=alt.Axis(title=''), sort='-x'),\n",
    ")\n",
    "\n",
    "top_outside_donors_text = top_outside_donors_chart.mark_text(\n",
    "    align='left',\n",
    "    baseline='middle',\n",
    "    dx=3  # Nudges text to right so it doesn't appear on top of the bar\n",
    ").encode(\n",
    "    text=alt.Text( 'amount:Q', format='$.2s'),\n",
    ")\n",
    "\n",
    "\n",
    "(top_outside_donors_chart + top_outside_donors_text).properties(\n",
    "    title={\n",
    "        \"text\":\"Top out-of-state donors\",\n",
    "#         \"subtitle\":\"Cash raised as of March 12, 2023\"\n",
    "    },\n",
    "    height=400,\n",
    "    width=800\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d16299f8",
   "metadata": {},
   "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.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}