Skip to content

Instantly share code, notes, and snippets.

@codebrain001

codebrain001/Validating data.ipynb

Created April 12, 2020 23:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save codebrain001/b94298a729a0e4521e2ae76de8a70e8b to your computer and use it in GitHub Desktop.
Save codebrain001/b94298a729a0e4521e2ae76de8a70e8b to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Validating data.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 36,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>county</th>\n",
" <th>fips</th>\n",
" <th>candidate(d)</th>\n",
" <th>votes (d)</th>\n",
" <th>year</th>\n",
" <th>candidate(r)</th>\n",
" <th>votes (r)</th>\n",
" <th>candidate(O)</th>\n",
" <th>votes (O)</th>\n",
" <th>votes_total</th>\n",
" <th>voter_share_major_party</th>\n",
" <th>voter_share_dem</th>\n",
" <th>voter_share_rep</th>\n",
" <th>voter_share_other</th>\n",
" <th>rawdiff_dem_vs_rep</th>\n",
" <th>rawdiff_rep_vs_dem</th>\n",
" <th>rawdiff_dem_vs_other</th>\n",
" <th>rawdiff_rep_vs_other</th>\n",
" <th>rawdiff_other_vs_dem</th>\n",
" <th>rawdiff_other_vs_rep</th>\n",
" <th>pctdiff_dem_vs_rep</th>\n",
" <th>pctdiff_rep_vs_dem</th>\n",
" <th>pctdiff_dem_vs_other</th>\n",
" <th>pctdiff_rep_vs_other</th>\n",
" <th>pctdiff_other_vs_dem</th>\n",
" <th>pctdiff_other_vs_rep</th>\n",
" <th>OBJECTID</th>\n",
" <th>GEONAME</th>\n",
" <th>Total_cvap_est</th>\n",
" <th>SHAPE</th>\n",
" <th>Shape__Area</th>\n",
" <th>Shape__Length</th>\n",
" <th>voter_turnout</th>\n",
" <th>voter_turnout_majparty</th>\n",
" <th>voter_turnout_dem</th>\n",
" <th>voter_turnout_rep</th>\n",
" <th>voter_turnout_other</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>446</th>\n",
" <td>District 1</td>\n",
" <td>02701</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2573.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3180.000000</td>\n",
" <td>Other</td>\n",
" <td>885.000000</td>\n",
" <td>6638.000000</td>\n",
" <td>0.866677</td>\n",
" <td>0.387617</td>\n",
" <td>0.479060</td>\n",
" <td>0.133323</td>\n",
" <td>-607.0</td>\n",
" <td>607.0</td>\n",
" <td>1688.0</td>\n",
" <td>2295.0</td>\n",
" <td>-1688.0</td>\n",
" <td>-2295.0</td>\n",
" <td>-0.091443</td>\n",
" <td>0.091443</td>\n",
" <td>0.254293</td>\n",
" <td>0.345737</td>\n",
" <td>-0.254293</td>\n",
" <td>-0.345737</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>447</th>\n",
" <td>District 2</td>\n",
" <td>02702</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1585.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3188.000000</td>\n",
" <td>Other</td>\n",
" <td>719.000000</td>\n",
" <td>5492.000000</td>\n",
" <td>0.869082</td>\n",
" <td>0.288602</td>\n",
" <td>0.580481</td>\n",
" <td>0.130918</td>\n",
" <td>-1603.0</td>\n",
" <td>1603.0</td>\n",
" <td>866.0</td>\n",
" <td>2469.0</td>\n",
" <td>-866.0</td>\n",
" <td>-2469.0</td>\n",
" <td>-0.291879</td>\n",
" <td>0.291879</td>\n",
" <td>0.157684</td>\n",
" <td>0.449563</td>\n",
" <td>-0.157684</td>\n",
" <td>-0.449563</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>448</th>\n",
" <td>District 3</td>\n",
" <td>02703</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1241.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>5403.000000</td>\n",
" <td>Other</td>\n",
" <td>969.000000</td>\n",
" <td>7613.000000</td>\n",
" <td>0.872718</td>\n",
" <td>0.163011</td>\n",
" <td>0.709707</td>\n",
" <td>0.127282</td>\n",
" <td>-4162.0</td>\n",
" <td>4162.0</td>\n",
" <td>272.0</td>\n",
" <td>4434.0</td>\n",
" <td>-272.0</td>\n",
" <td>-4434.0</td>\n",
" <td>-0.546696</td>\n",
" <td>0.546696</td>\n",
" <td>0.035728</td>\n",
" <td>0.582425</td>\n",
" <td>-0.035728</td>\n",
" <td>-0.582425</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>449</th>\n",
" <td>District 4</td>\n",
" <td>02704</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>4162.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4070.000000</td>\n",
" <td>Other</td>\n",
" <td>1289.000000</td>\n",
" <td>9521.000000</td>\n",
" <td>0.864615</td>\n",
" <td>0.437139</td>\n",
" <td>0.427476</td>\n",
" <td>0.135385</td>\n",
" <td>92.0</td>\n",
" <td>-92.0</td>\n",
" <td>2873.0</td>\n",
" <td>2781.0</td>\n",
" <td>-2873.0</td>\n",
" <td>-2781.0</td>\n",
" <td>0.009663</td>\n",
" <td>-0.009663</td>\n",
" <td>0.301754</td>\n",
" <td>0.292091</td>\n",
" <td>-0.301754</td>\n",
" <td>-0.292091</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>450</th>\n",
" <td>District 5</td>\n",
" <td>02705</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3187.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3683.000000</td>\n",
" <td>Other</td>\n",
" <td>1036.000000</td>\n",
" <td>7906.000000</td>\n",
" <td>0.868960</td>\n",
" <td>0.403112</td>\n",
" <td>0.465849</td>\n",
" <td>0.131040</td>\n",
" <td>-496.0</td>\n",
" <td>496.0</td>\n",
" <td>2151.0</td>\n",
" <td>2647.0</td>\n",
" <td>-2151.0</td>\n",
" <td>-2647.0</td>\n",
" <td>-0.062737</td>\n",
" <td>0.062737</td>\n",
" <td>0.272072</td>\n",
" <td>0.334809</td>\n",
" <td>-0.272072</td>\n",
" <td>-0.334809</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>451</th>\n",
" <td>District 6</td>\n",
" <td>02706</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2536.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4929.000000</td>\n",
" <td>Other</td>\n",
" <td>995.000000</td>\n",
" <td>8460.000000</td>\n",
" <td>0.882388</td>\n",
" <td>0.299764</td>\n",
" <td>0.582624</td>\n",
" <td>0.117612</td>\n",
" <td>-2393.0</td>\n",
" <td>2393.0</td>\n",
" <td>1541.0</td>\n",
" <td>3934.0</td>\n",
" <td>-1541.0</td>\n",
" <td>-3934.0</td>\n",
" <td>-0.282861</td>\n",
" <td>0.282861</td>\n",
" <td>0.182151</td>\n",
" <td>0.465012</td>\n",
" <td>-0.182151</td>\n",
" <td>-0.465012</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>452</th>\n",
" <td>District 7</td>\n",
" <td>02707</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1510.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>5935.000000</td>\n",
" <td>Other</td>\n",
" <td>849.000000</td>\n",
" <td>8294.000000</td>\n",
" <td>0.897637</td>\n",
" <td>0.182059</td>\n",
" <td>0.715578</td>\n",
" <td>0.102363</td>\n",
" <td>-4425.0</td>\n",
" <td>4425.0</td>\n",
" <td>661.0</td>\n",
" <td>5086.0</td>\n",
" <td>-661.0</td>\n",
" <td>-5086.0</td>\n",
" <td>-0.533518</td>\n",
" <td>0.533518</td>\n",
" <td>0.079696</td>\n",
" <td>0.613214</td>\n",
" <td>-0.079696</td>\n",
" <td>-0.613214</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>453</th>\n",
" <td>District 8</td>\n",
" <td>02708</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1218.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>6126.000000</td>\n",
" <td>Other</td>\n",
" <td>729.000000</td>\n",
" <td>8073.000000</td>\n",
" <td>0.909699</td>\n",
" <td>0.150873</td>\n",
" <td>0.758826</td>\n",
" <td>0.090301</td>\n",
" <td>-4908.0</td>\n",
" <td>4908.0</td>\n",
" <td>489.0</td>\n",
" <td>5397.0</td>\n",
" <td>-489.0</td>\n",
" <td>-5397.0</td>\n",
" <td>-0.607952</td>\n",
" <td>0.607952</td>\n",
" <td>0.060572</td>\n",
" <td>0.668525</td>\n",
" <td>-0.060572</td>\n",
" <td>-0.668525</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>454</th>\n",
" <td>District 9</td>\n",
" <td>02709</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1843.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>6100.000000</td>\n",
" <td>Other</td>\n",
" <td>1011.000000</td>\n",
" <td>8954.000000</td>\n",
" <td>0.887090</td>\n",
" <td>0.205830</td>\n",
" <td>0.681260</td>\n",
" <td>0.112910</td>\n",
" <td>-4257.0</td>\n",
" <td>4257.0</td>\n",
" <td>832.0</td>\n",
" <td>5089.0</td>\n",
" <td>-832.0</td>\n",
" <td>-5089.0</td>\n",
" <td>-0.475430</td>\n",
" <td>0.475430</td>\n",
" <td>0.092919</td>\n",
" <td>0.568349</td>\n",
" <td>-0.092919</td>\n",
" <td>-0.568349</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>455</th>\n",
" <td>District 10</td>\n",
" <td>02710</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1808.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>6255.000000</td>\n",
" <td>Other</td>\n",
" <td>977.000000</td>\n",
" <td>9040.000000</td>\n",
" <td>0.891925</td>\n",
" <td>0.200000</td>\n",
" <td>0.691925</td>\n",
" <td>0.108075</td>\n",
" <td>-4447.0</td>\n",
" <td>4447.0</td>\n",
" <td>831.0</td>\n",
" <td>5278.0</td>\n",
" <td>-831.0</td>\n",
" <td>-5278.0</td>\n",
" <td>-0.491925</td>\n",
" <td>0.491925</td>\n",
" <td>0.091925</td>\n",
" <td>0.583850</td>\n",
" <td>-0.091925</td>\n",
" <td>-0.583850</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>456</th>\n",
" <td>District 11</td>\n",
" <td>02711</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2142.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>6444.000000</td>\n",
" <td>Other</td>\n",
" <td>1103.000000</td>\n",
" <td>9689.000000</td>\n",
" <td>0.886160</td>\n",
" <td>0.221075</td>\n",
" <td>0.665084</td>\n",
" <td>0.113840</td>\n",
" <td>-4302.0</td>\n",
" <td>4302.0</td>\n",
" <td>1039.0</td>\n",
" <td>5341.0</td>\n",
" <td>-1039.0</td>\n",
" <td>-5341.0</td>\n",
" <td>-0.444009</td>\n",
" <td>0.444009</td>\n",
" <td>0.107235</td>\n",
" <td>0.551244</td>\n",
" <td>-0.107235</td>\n",
" <td>-0.551244</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>457</th>\n",
" <td>District 12</td>\n",
" <td>02712</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1928.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>6629.000000</td>\n",
" <td>Other</td>\n",
" <td>986.000000</td>\n",
" <td>9543.000000</td>\n",
" <td>0.896678</td>\n",
" <td>0.202033</td>\n",
" <td>0.694645</td>\n",
" <td>0.103322</td>\n",
" <td>-4701.0</td>\n",
" <td>4701.0</td>\n",
" <td>942.0</td>\n",
" <td>5643.0</td>\n",
" <td>-942.0</td>\n",
" <td>-5643.0</td>\n",
" <td>-0.492612</td>\n",
" <td>0.492612</td>\n",
" <td>0.098711</td>\n",
" <td>0.591323</td>\n",
" <td>-0.098711</td>\n",
" <td>-0.591323</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>458</th>\n",
" <td>District 13</td>\n",
" <td>02713</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1684.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4028.000000</td>\n",
" <td>Other</td>\n",
" <td>821.000000</td>\n",
" <td>6533.000000</td>\n",
" <td>0.874330</td>\n",
" <td>0.257768</td>\n",
" <td>0.616562</td>\n",
" <td>0.125670</td>\n",
" <td>-2344.0</td>\n",
" <td>2344.0</td>\n",
" <td>863.0</td>\n",
" <td>3207.0</td>\n",
" <td>-863.0</td>\n",
" <td>-3207.0</td>\n",
" <td>-0.358794</td>\n",
" <td>0.358794</td>\n",
" <td>0.132099</td>\n",
" <td>0.490892</td>\n",
" <td>-0.132099</td>\n",
" <td>-0.490892</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>459</th>\n",
" <td>District 14</td>\n",
" <td>02714</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3043.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>5978.000000</td>\n",
" <td>Other</td>\n",
" <td>1399.000000</td>\n",
" <td>10420.000000</td>\n",
" <td>0.865739</td>\n",
" <td>0.292035</td>\n",
" <td>0.573704</td>\n",
" <td>0.134261</td>\n",
" <td>-2935.0</td>\n",
" <td>2935.0</td>\n",
" <td>1644.0</td>\n",
" <td>4579.0</td>\n",
" <td>-1644.0</td>\n",
" <td>-4579.0</td>\n",
" <td>-0.281670</td>\n",
" <td>0.281670</td>\n",
" <td>0.157774</td>\n",
" <td>0.439443</td>\n",
" <td>-0.157774</td>\n",
" <td>-0.439443</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>460</th>\n",
" <td>District 15</td>\n",
" <td>02715</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1828.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>2525.000000</td>\n",
" <td>Other</td>\n",
" <td>629.000000</td>\n",
" <td>4982.000000</td>\n",
" <td>0.873745</td>\n",
" <td>0.366921</td>\n",
" <td>0.506825</td>\n",
" <td>0.126255</td>\n",
" <td>-697.0</td>\n",
" <td>697.0</td>\n",
" <td>1199.0</td>\n",
" <td>1896.0</td>\n",
" <td>-1199.0</td>\n",
" <td>-1896.0</td>\n",
" <td>-0.139904</td>\n",
" <td>0.139904</td>\n",
" <td>0.240666</td>\n",
" <td>0.380570</td>\n",
" <td>-0.240666</td>\n",
" <td>-0.380570</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>461</th>\n",
" <td>District 16</td>\n",
" <td>02716</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3294.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3203.000000</td>\n",
" <td>Other</td>\n",
" <td>939.000000</td>\n",
" <td>7436.000000</td>\n",
" <td>0.873722</td>\n",
" <td>0.442980</td>\n",
" <td>0.430742</td>\n",
" <td>0.126278</td>\n",
" <td>91.0</td>\n",
" <td>-91.0</td>\n",
" <td>2355.0</td>\n",
" <td>2264.0</td>\n",
" <td>-2355.0</td>\n",
" <td>-2264.0</td>\n",
" <td>0.012238</td>\n",
" <td>-0.012238</td>\n",
" <td>0.316703</td>\n",
" <td>0.304465</td>\n",
" <td>-0.316703</td>\n",
" <td>-0.304465</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>462</th>\n",
" <td>District 17</td>\n",
" <td>02717</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3290.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>2618.000000</td>\n",
" <td>Other</td>\n",
" <td>880.000000</td>\n",
" <td>6788.000000</td>\n",
" <td>0.870359</td>\n",
" <td>0.484679</td>\n",
" <td>0.385681</td>\n",
" <td>0.129641</td>\n",
" <td>672.0</td>\n",
" <td>-672.0</td>\n",
" <td>2410.0</td>\n",
" <td>1738.0</td>\n",
" <td>-2410.0</td>\n",
" <td>-1738.0</td>\n",
" <td>0.098998</td>\n",
" <td>-0.098998</td>\n",
" <td>0.355038</td>\n",
" <td>0.256040</td>\n",
" <td>-0.355038</td>\n",
" <td>-0.256040</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>463</th>\n",
" <td>District 18</td>\n",
" <td>02718</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3909.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>2684.000000</td>\n",
" <td>Other</td>\n",
" <td>809.000000</td>\n",
" <td>7402.000000</td>\n",
" <td>0.890705</td>\n",
" <td>0.528101</td>\n",
" <td>0.362605</td>\n",
" <td>0.109295</td>\n",
" <td>1225.0</td>\n",
" <td>-1225.0</td>\n",
" <td>3100.0</td>\n",
" <td>1875.0</td>\n",
" <td>-3100.0</td>\n",
" <td>-1875.0</td>\n",
" <td>0.165496</td>\n",
" <td>-0.165496</td>\n",
" <td>0.418806</td>\n",
" <td>0.253310</td>\n",
" <td>-0.418806</td>\n",
" <td>-0.253310</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>464</th>\n",
" <td>District 19</td>\n",
" <td>02719</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2669.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>1636.000000</td>\n",
" <td>Other</td>\n",
" <td>487.000000</td>\n",
" <td>4792.000000</td>\n",
" <td>0.898372</td>\n",
" <td>0.556970</td>\n",
" <td>0.341402</td>\n",
" <td>0.101628</td>\n",
" <td>1033.0</td>\n",
" <td>-1033.0</td>\n",
" <td>2182.0</td>\n",
" <td>1149.0</td>\n",
" <td>-2182.0</td>\n",
" <td>-1149.0</td>\n",
" <td>0.215568</td>\n",
" <td>-0.215568</td>\n",
" <td>0.455342</td>\n",
" <td>0.239775</td>\n",
" <td>-0.455342</td>\n",
" <td>-0.239775</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>465</th>\n",
" <td>District 20</td>\n",
" <td>02720</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>4151.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>2187.000000</td>\n",
" <td>Other</td>\n",
" <td>802.000000</td>\n",
" <td>7140.000000</td>\n",
" <td>0.887675</td>\n",
" <td>0.581373</td>\n",
" <td>0.306303</td>\n",
" <td>0.112325</td>\n",
" <td>1964.0</td>\n",
" <td>-1964.0</td>\n",
" <td>3349.0</td>\n",
" <td>1385.0</td>\n",
" <td>-3349.0</td>\n",
" <td>-1385.0</td>\n",
" <td>0.275070</td>\n",
" <td>-0.275070</td>\n",
" <td>0.469048</td>\n",
" <td>0.193978</td>\n",
" <td>-0.469048</td>\n",
" <td>-0.193978</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>466</th>\n",
" <td>District 21</td>\n",
" <td>02721</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>4224.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3479.000000</td>\n",
" <td>Other</td>\n",
" <td>944.000000</td>\n",
" <td>8647.000000</td>\n",
" <td>0.890829</td>\n",
" <td>0.488493</td>\n",
" <td>0.402336</td>\n",
" <td>0.109171</td>\n",
" <td>745.0</td>\n",
" <td>-745.0</td>\n",
" <td>3280.0</td>\n",
" <td>2535.0</td>\n",
" <td>-3280.0</td>\n",
" <td>-2535.0</td>\n",
" <td>0.086157</td>\n",
" <td>-0.086157</td>\n",
" <td>0.379322</td>\n",
" <td>0.293165</td>\n",
" <td>-0.379322</td>\n",
" <td>-0.293165</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>467</th>\n",
" <td>District 22</td>\n",
" <td>02722</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3270.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4203.000000</td>\n",
" <td>Other</td>\n",
" <td>899.000000</td>\n",
" <td>8372.000000</td>\n",
" <td>0.892618</td>\n",
" <td>0.390588</td>\n",
" <td>0.502031</td>\n",
" <td>0.107382</td>\n",
" <td>-933.0</td>\n",
" <td>933.0</td>\n",
" <td>2371.0</td>\n",
" <td>3304.0</td>\n",
" <td>-2371.0</td>\n",
" <td>-3304.0</td>\n",
" <td>-0.111443</td>\n",
" <td>0.111443</td>\n",
" <td>0.283206</td>\n",
" <td>0.394649</td>\n",
" <td>-0.283206</td>\n",
" <td>-0.394649</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>468</th>\n",
" <td>District 23</td>\n",
" <td>02723</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2894.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3246.000000</td>\n",
" <td>Other</td>\n",
" <td>784.000000</td>\n",
" <td>6924.000000</td>\n",
" <td>0.886771</td>\n",
" <td>0.417966</td>\n",
" <td>0.468804</td>\n",
" <td>0.113229</td>\n",
" <td>-352.0</td>\n",
" <td>352.0</td>\n",
" <td>2110.0</td>\n",
" <td>2462.0</td>\n",
" <td>-2110.0</td>\n",
" <td>-2462.0</td>\n",
" <td>-0.050838</td>\n",
" <td>0.050838</td>\n",
" <td>0.304737</td>\n",
" <td>0.355575</td>\n",
" <td>-0.304737</td>\n",
" <td>-0.355575</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>469</th>\n",
" <td>District 24</td>\n",
" <td>02724</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3578.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4709.000000</td>\n",
" <td>Other</td>\n",
" <td>793.000000</td>\n",
" <td>9080.000000</td>\n",
" <td>0.912665</td>\n",
" <td>0.394053</td>\n",
" <td>0.518612</td>\n",
" <td>0.087335</td>\n",
" <td>-1131.0</td>\n",
" <td>1131.0</td>\n",
" <td>2785.0</td>\n",
" <td>3916.0</td>\n",
" <td>-2785.0</td>\n",
" <td>-3916.0</td>\n",
" <td>-0.124559</td>\n",
" <td>0.124559</td>\n",
" <td>0.306718</td>\n",
" <td>0.431278</td>\n",
" <td>-0.306718</td>\n",
" <td>-0.431278</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>470</th>\n",
" <td>District 25</td>\n",
" <td>02725</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3378.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3816.000000</td>\n",
" <td>Other</td>\n",
" <td>933.000000</td>\n",
" <td>8127.000000</td>\n",
" <td>0.885197</td>\n",
" <td>0.415652</td>\n",
" <td>0.469546</td>\n",
" <td>0.114803</td>\n",
" <td>-438.0</td>\n",
" <td>438.0</td>\n",
" <td>2445.0</td>\n",
" <td>2883.0</td>\n",
" <td>-2445.0</td>\n",
" <td>-2883.0</td>\n",
" <td>-0.053894</td>\n",
" <td>0.053894</td>\n",
" <td>0.300849</td>\n",
" <td>0.354743</td>\n",
" <td>-0.300849</td>\n",
" <td>-0.354743</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>471</th>\n",
" <td>District 26</td>\n",
" <td>02726</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3374.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4548.000000</td>\n",
" <td>Other</td>\n",
" <td>983.000000</td>\n",
" <td>8905.000000</td>\n",
" <td>0.889613</td>\n",
" <td>0.378888</td>\n",
" <td>0.510724</td>\n",
" <td>0.110387</td>\n",
" <td>-1174.0</td>\n",
" <td>1174.0</td>\n",
" <td>2391.0</td>\n",
" <td>3565.0</td>\n",
" <td>-2391.0</td>\n",
" <td>-3565.0</td>\n",
" <td>-0.131836</td>\n",
" <td>0.131836</td>\n",
" <td>0.268501</td>\n",
" <td>0.400337</td>\n",
" <td>-0.268501</td>\n",
" <td>-0.400337</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>472</th>\n",
" <td>District 27</td>\n",
" <td>02727</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3729.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4085.000000</td>\n",
" <td>Other</td>\n",
" <td>969.000000</td>\n",
" <td>8783.000000</td>\n",
" <td>0.889673</td>\n",
" <td>0.424570</td>\n",
" <td>0.465103</td>\n",
" <td>0.110327</td>\n",
" <td>-356.0</td>\n",
" <td>356.0</td>\n",
" <td>2760.0</td>\n",
" <td>3116.0</td>\n",
" <td>-2760.0</td>\n",
" <td>-3116.0</td>\n",
" <td>-0.040533</td>\n",
" <td>0.040533</td>\n",
" <td>0.314243</td>\n",
" <td>0.354776</td>\n",
" <td>-0.314243</td>\n",
" <td>-0.354776</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>473</th>\n",
" <td>District 28</td>\n",
" <td>02728</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>4749.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>5423.000000</td>\n",
" <td>Other</td>\n",
" <td>1255.000000</td>\n",
" <td>11427.000000</td>\n",
" <td>0.890172</td>\n",
" <td>0.415595</td>\n",
" <td>0.474578</td>\n",
" <td>0.109828</td>\n",
" <td>-674.0</td>\n",
" <td>674.0</td>\n",
" <td>3494.0</td>\n",
" <td>4168.0</td>\n",
" <td>-3494.0</td>\n",
" <td>-4168.0</td>\n",
" <td>-0.058983</td>\n",
" <td>0.058983</td>\n",
" <td>0.305767</td>\n",
" <td>0.364750</td>\n",
" <td>-0.305767</td>\n",
" <td>-0.364750</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>474</th>\n",
" <td>District 29</td>\n",
" <td>02729</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2101.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>6347.000000</td>\n",
" <td>Other</td>\n",
" <td>946.000000</td>\n",
" <td>9394.000000</td>\n",
" <td>0.899297</td>\n",
" <td>0.223653</td>\n",
" <td>0.675644</td>\n",
" <td>0.100703</td>\n",
" <td>-4246.0</td>\n",
" <td>4246.0</td>\n",
" <td>1155.0</td>\n",
" <td>5401.0</td>\n",
" <td>-1155.0</td>\n",
" <td>-5401.0</td>\n",
" <td>-0.451991</td>\n",
" <td>0.451991</td>\n",
" <td>0.122951</td>\n",
" <td>0.574941</td>\n",
" <td>-0.122951</td>\n",
" <td>-0.574941</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>475</th>\n",
" <td>District 30</td>\n",
" <td>02730</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>1816.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>6194.000000</td>\n",
" <td>Other</td>\n",
" <td>940.000000</td>\n",
" <td>8950.000000</td>\n",
" <td>0.894972</td>\n",
" <td>0.202905</td>\n",
" <td>0.692067</td>\n",
" <td>0.105028</td>\n",
" <td>-4378.0</td>\n",
" <td>4378.0</td>\n",
" <td>876.0</td>\n",
" <td>5254.0</td>\n",
" <td>-876.0</td>\n",
" <td>-5254.0</td>\n",
" <td>-0.489162</td>\n",
" <td>0.489162</td>\n",
" <td>0.097877</td>\n",
" <td>0.587039</td>\n",
" <td>-0.097877</td>\n",
" <td>-0.587039</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>476</th>\n",
" <td>District 31</td>\n",
" <td>02731</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3466.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>5617.000000</td>\n",
" <td>Other</td>\n",
" <td>1099.000000</td>\n",
" <td>10182.000000</td>\n",
" <td>0.892064</td>\n",
" <td>0.340405</td>\n",
" <td>0.551660</td>\n",
" <td>0.107936</td>\n",
" <td>-2151.0</td>\n",
" <td>2151.0</td>\n",
" <td>2367.0</td>\n",
" <td>4518.0</td>\n",
" <td>-2367.0</td>\n",
" <td>-4518.0</td>\n",
" <td>-0.211255</td>\n",
" <td>0.211255</td>\n",
" <td>0.232469</td>\n",
" <td>0.443724</td>\n",
" <td>-0.232469</td>\n",
" <td>-0.443724</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>477</th>\n",
" <td>District 32</td>\n",
" <td>02732</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2701.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3764.000000</td>\n",
" <td>Other</td>\n",
" <td>1007.000000</td>\n",
" <td>7472.000000</td>\n",
" <td>0.865230</td>\n",
" <td>0.361483</td>\n",
" <td>0.503747</td>\n",
" <td>0.134770</td>\n",
" <td>-1063.0</td>\n",
" <td>1063.0</td>\n",
" <td>1694.0</td>\n",
" <td>2757.0</td>\n",
" <td>-1694.0</td>\n",
" <td>-2757.0</td>\n",
" <td>-0.142264</td>\n",
" <td>0.142264</td>\n",
" <td>0.226713</td>\n",
" <td>0.368978</td>\n",
" <td>-0.226713</td>\n",
" <td>-0.368978</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>478</th>\n",
" <td>District 33</td>\n",
" <td>02733</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>5978.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>2732.000000</td>\n",
" <td>Other</td>\n",
" <td>1224.000000</td>\n",
" <td>9934.000000</td>\n",
" <td>0.876787</td>\n",
" <td>0.601772</td>\n",
" <td>0.275015</td>\n",
" <td>0.123213</td>\n",
" <td>3246.0</td>\n",
" <td>-3246.0</td>\n",
" <td>4754.0</td>\n",
" <td>1508.0</td>\n",
" <td>-4754.0</td>\n",
" <td>-1508.0</td>\n",
" <td>0.326757</td>\n",
" <td>-0.326757</td>\n",
" <td>0.478558</td>\n",
" <td>0.151802</td>\n",
" <td>-0.478558</td>\n",
" <td>-0.151802</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>479</th>\n",
" <td>District 34</td>\n",
" <td>02734</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>4220.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>3955.000000</td>\n",
" <td>Other</td>\n",
" <td>1256.000000</td>\n",
" <td>9431.000000</td>\n",
" <td>0.866822</td>\n",
" <td>0.447461</td>\n",
" <td>0.419362</td>\n",
" <td>0.133178</td>\n",
" <td>265.0</td>\n",
" <td>-265.0</td>\n",
" <td>2964.0</td>\n",
" <td>2699.0</td>\n",
" <td>-2964.0</td>\n",
" <td>-2699.0</td>\n",
" <td>0.028099</td>\n",
" <td>-0.028099</td>\n",
" <td>0.314283</td>\n",
" <td>0.286184</td>\n",
" <td>-0.314283</td>\n",
" <td>-0.286184</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>480</th>\n",
" <td>District 35</td>\n",
" <td>02735</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3749.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4105.000000</td>\n",
" <td>Other</td>\n",
" <td>1188.000000</td>\n",
" <td>9042.000000</td>\n",
" <td>0.868613</td>\n",
" <td>0.414621</td>\n",
" <td>0.453992</td>\n",
" <td>0.131387</td>\n",
" <td>-356.0</td>\n",
" <td>356.0</td>\n",
" <td>2561.0</td>\n",
" <td>2917.0</td>\n",
" <td>-2561.0</td>\n",
" <td>-2917.0</td>\n",
" <td>-0.039372</td>\n",
" <td>0.039372</td>\n",
" <td>0.283234</td>\n",
" <td>0.322606</td>\n",
" <td>-0.283234</td>\n",
" <td>-0.322606</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>481</th>\n",
" <td>District 36</td>\n",
" <td>02736</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2693.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>4460.000000</td>\n",
" <td>Other</td>\n",
" <td>1111.000000</td>\n",
" <td>8264.000000</td>\n",
" <td>0.865561</td>\n",
" <td>0.325871</td>\n",
" <td>0.539690</td>\n",
" <td>0.134439</td>\n",
" <td>-1767.0</td>\n",
" <td>1767.0</td>\n",
" <td>1582.0</td>\n",
" <td>3349.0</td>\n",
" <td>-1582.0</td>\n",
" <td>-3349.0</td>\n",
" <td>-0.213819</td>\n",
" <td>0.213819</td>\n",
" <td>0.191433</td>\n",
" <td>0.405252</td>\n",
" <td>-0.191433</td>\n",
" <td>-0.405252</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>482</th>\n",
" <td>District 37</td>\n",
" <td>02737</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2421.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>1938.000000</td>\n",
" <td>Other</td>\n",
" <td>703.000000</td>\n",
" <td>5062.000000</td>\n",
" <td>0.861122</td>\n",
" <td>0.478269</td>\n",
" <td>0.382853</td>\n",
" <td>0.138878</td>\n",
" <td>483.0</td>\n",
" <td>-483.0</td>\n",
" <td>1718.0</td>\n",
" <td>1235.0</td>\n",
" <td>-1718.0</td>\n",
" <td>-1235.0</td>\n",
" <td>0.095417</td>\n",
" <td>-0.095417</td>\n",
" <td>0.339392</td>\n",
" <td>0.243975</td>\n",
" <td>-0.339392</td>\n",
" <td>-0.243975</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>483</th>\n",
" <td>District 38</td>\n",
" <td>02738</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2758.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>1143.000000</td>\n",
" <td>Other</td>\n",
" <td>1194.000000</td>\n",
" <td>5095.000000</td>\n",
" <td>0.765653</td>\n",
" <td>0.541315</td>\n",
" <td>0.224338</td>\n",
" <td>0.234347</td>\n",
" <td>1615.0</td>\n",
" <td>-1615.0</td>\n",
" <td>1564.0</td>\n",
" <td>-51.0</td>\n",
" <td>-1564.0</td>\n",
" <td>51.0</td>\n",
" <td>0.316977</td>\n",
" <td>-0.316977</td>\n",
" <td>0.306968</td>\n",
" <td>-0.010010</td>\n",
" <td>-0.306968</td>\n",
" <td>0.010010</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>484</th>\n",
" <td>District 39</td>\n",
" <td>02739</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3142.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>1405.000000</td>\n",
" <td>Other</td>\n",
" <td>1092.000000</td>\n",
" <td>5639.000000</td>\n",
" <td>0.806349</td>\n",
" <td>0.557191</td>\n",
" <td>0.249158</td>\n",
" <td>0.193651</td>\n",
" <td>1737.0</td>\n",
" <td>-1737.0</td>\n",
" <td>2050.0</td>\n",
" <td>313.0</td>\n",
" <td>-2050.0</td>\n",
" <td>-313.0</td>\n",
" <td>0.308033</td>\n",
" <td>-0.308033</td>\n",
" <td>0.363540</td>\n",
" <td>0.055506</td>\n",
" <td>-0.363540</td>\n",
" <td>-0.055506</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>485</th>\n",
" <td>District 40</td>\n",
" <td>02740</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2338.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>1377.000000</td>\n",
" <td>Other</td>\n",
" <td>895.000000</td>\n",
" <td>4610.000000</td>\n",
" <td>0.805857</td>\n",
" <td>0.507158</td>\n",
" <td>0.298698</td>\n",
" <td>0.194143</td>\n",
" <td>961.0</td>\n",
" <td>-961.0</td>\n",
" <td>1443.0</td>\n",
" <td>482.0</td>\n",
" <td>-1443.0</td>\n",
" <td>-482.0</td>\n",
" <td>0.208460</td>\n",
" <td>-0.208460</td>\n",
" <td>0.313015</td>\n",
" <td>0.104555</td>\n",
" <td>-0.313015</td>\n",
" <td>-0.104555</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2402</th>\n",
" <td>Kansas City</td>\n",
" <td>36000</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>97735.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>24654.000000</td>\n",
" <td>Other</td>\n",
" <td>6212.000000</td>\n",
" <td>128601.000000</td>\n",
" <td>0.951696</td>\n",
" <td>0.759986</td>\n",
" <td>0.191709</td>\n",
" <td>0.048304</td>\n",
" <td>73081.0</td>\n",
" <td>-73081.0</td>\n",
" <td>91523.0</td>\n",
" <td>18442.0</td>\n",
" <td>-91523.0</td>\n",
" <td>-18442.0</td>\n",
" <td>0.568277</td>\n",
" <td>-0.568277</td>\n",
" <td>0.711682</td>\n",
" <td>0.143405</td>\n",
" <td>-0.711682</td>\n",
" <td>-0.143405</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2667</th>\n",
" <td>Bedford</td>\n",
" <td>51515</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>14416.513202</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>14416.513202</td>\n",
" <td>Other</td>\n",
" <td>14416.513202</td>\n",
" <td>43249.539607</td>\n",
" <td>0.666667</td>\n",
" <td>0.333333</td>\n",
" <td>0.333333</td>\n",
" <td>0.333333</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2771</th>\n",
" <td>Oglala Lakota</td>\n",
" <td>46113</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>2510.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>241.000000</td>\n",
" <td>Other</td>\n",
" <td>154.000000</td>\n",
" <td>2905.000000</td>\n",
" <td>0.946988</td>\n",
" <td>0.864028</td>\n",
" <td>0.082960</td>\n",
" <td>0.053012</td>\n",
" <td>2269.0</td>\n",
" <td>-2269.0</td>\n",
" <td>2356.0</td>\n",
" <td>87.0</td>\n",
" <td>-2356.0</td>\n",
" <td>-87.0</td>\n",
" <td>0.781067</td>\n",
" <td>-0.781067</td>\n",
" <td>0.811015</td>\n",
" <td>0.029948</td>\n",
" <td>-0.811015</td>\n",
" <td>-0.029948</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3154</th>\n",
" <td>Statewide writein</td>\n",
" <td>30305</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>14416.513202</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>14416.513202</td>\n",
" <td>Other</td>\n",
" <td>14416.513202</td>\n",
" <td>43249.539607</td>\n",
" <td>0.666667</td>\n",
" <td>0.333333</td>\n",
" <td>0.333333</td>\n",
" <td>0.333333</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3155</th>\n",
" <td>Maine UOCAVA</td>\n",
" <td>30305</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>3017.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>648.000000</td>\n",
" <td>Other</td>\n",
" <td>321.000000</td>\n",
" <td>3986.000000</td>\n",
" <td>0.919468</td>\n",
" <td>0.756899</td>\n",
" <td>0.162569</td>\n",
" <td>0.080532</td>\n",
" <td>2369.0</td>\n",
" <td>-2369.0</td>\n",
" <td>2696.0</td>\n",
" <td>327.0</td>\n",
" <td>-2696.0</td>\n",
" <td>-327.0</td>\n",
" <td>0.594330</td>\n",
" <td>-0.594330</td>\n",
" <td>0.676367</td>\n",
" <td>0.082037</td>\n",
" <td>-0.676367</td>\n",
" <td>-0.082037</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3156</th>\n",
" <td>District 99</td>\n",
" <td>30305</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>274.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>40.000000</td>\n",
" <td>Other</td>\n",
" <td>28.000000</td>\n",
" <td>342.000000</td>\n",
" <td>0.918129</td>\n",
" <td>0.801170</td>\n",
" <td>0.116959</td>\n",
" <td>0.081871</td>\n",
" <td>234.0</td>\n",
" <td>-234.0</td>\n",
" <td>246.0</td>\n",
" <td>12.0</td>\n",
" <td>-246.0</td>\n",
" <td>-12.0</td>\n",
" <td>0.684211</td>\n",
" <td>-0.684211</td>\n",
" <td>0.719298</td>\n",
" <td>0.035088</td>\n",
" <td>-0.719298</td>\n",
" <td>-0.035088</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3157</th>\n",
" <td>Federal Precinct</td>\n",
" <td>30305</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>637.000000</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>53.000000</td>\n",
" <td>Other</td>\n",
" <td>38.000000</td>\n",
" <td>728.000000</td>\n",
" <td>0.947802</td>\n",
" <td>0.875000</td>\n",
" <td>0.072802</td>\n",
" <td>0.052198</td>\n",
" <td>584.0</td>\n",
" <td>-584.0</td>\n",
" <td>599.0</td>\n",
" <td>15.0</td>\n",
" <td>-599.0</td>\n",
" <td>-15.0</td>\n",
" <td>0.802198</td>\n",
" <td>-0.802198</td>\n",
" <td>0.822802</td>\n",
" <td>0.020604</td>\n",
" <td>-0.822802</td>\n",
" <td>-0.020604</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" county fips ... voter_turnout_rep voter_turnout_other\n",
"446 District 1 02701 ... NaN NaN\n",
"447 District 2 02702 ... NaN NaN\n",
"448 District 3 02703 ... NaN NaN\n",
"449 District 4 02704 ... NaN NaN\n",
"450 District 5 02705 ... NaN NaN\n",
"451 District 6 02706 ... NaN NaN\n",
"452 District 7 02707 ... NaN NaN\n",
"453 District 8 02708 ... NaN NaN\n",
"454 District 9 02709 ... NaN NaN\n",
"455 District 10 02710 ... NaN NaN\n",
"456 District 11 02711 ... NaN NaN\n",
"457 District 12 02712 ... NaN NaN\n",
"458 District 13 02713 ... NaN NaN\n",
"459 District 14 02714 ... NaN NaN\n",
"460 District 15 02715 ... NaN NaN\n",
"461 District 16 02716 ... NaN NaN\n",
"462 District 17 02717 ... NaN NaN\n",
"463 District 18 02718 ... NaN NaN\n",
"464 District 19 02719 ... NaN NaN\n",
"465 District 20 02720 ... NaN NaN\n",
"466 District 21 02721 ... NaN NaN\n",
"467 District 22 02722 ... NaN NaN\n",
"468 District 23 02723 ... NaN NaN\n",
"469 District 24 02724 ... NaN NaN\n",
"470 District 25 02725 ... NaN NaN\n",
"471 District 26 02726 ... NaN NaN\n",
"472 District 27 02727 ... NaN NaN\n",
"473 District 28 02728 ... NaN NaN\n",
"474 District 29 02729 ... NaN NaN\n",
"475 District 30 02730 ... NaN NaN\n",
"476 District 31 02731 ... NaN NaN\n",
"477 District 32 02732 ... NaN NaN\n",
"478 District 33 02733 ... NaN NaN\n",
"479 District 34 02734 ... NaN NaN\n",
"480 District 35 02735 ... NaN NaN\n",
"481 District 36 02736 ... NaN NaN\n",
"482 District 37 02737 ... NaN NaN\n",
"483 District 38 02738 ... NaN NaN\n",
"484 District 39 02739 ... NaN NaN\n",
"485 District 40 02740 ... NaN NaN\n",
"2402 Kansas City 36000 ... NaN NaN\n",
"2667 Bedford 51515 ... NaN NaN\n",
"2771 Oglala Lakota 46113 ... NaN NaN\n",
"3154 Statewide writein 30305 ... NaN NaN\n",
"3155 Maine UOCAVA 30305 ... NaN NaN\n",
"3156 District 99 30305 ... NaN NaN\n",
"3157 Federal Precinct 30305 ... NaN NaN\n",
"\n",
"[47 rows x 37 columns]"
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Check for null values\n",
"data_2016_df.loc[data_2016_df['voter_turnout'].isnull()]"
]
},
{
"cell_type": "code",
"execution_count": 37,
"metadata": {},
"outputs": [],
"source": [
"# Remove records with no voter turnout value\n",
"data_2016_df = data_2016_df.loc[data_2016_df['voter_turnout'].notnull()]"
]
},
{
"cell_type": "code",
"execution_count": 38,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"count 3111.000000\n",
"mean 0.594240\n",
"std 0.093300\n",
"min 0.158585\n",
"25% 0.530583\n",
"50% 0.595269\n",
"75% 0.655690\n",
"max 1.121277\n",
"Name: voter_turnout, dtype: float64"
]
},
"execution_count": 38,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Run a describe to get the distribution of voter turnout values\n",
"data_2016_df['voter_turnout'].describe()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"The describe function indicates that there are voter turnout values over one, indicating a voter turnout above 100%. You will further investigate by querying for these records."
]
},
{
"cell_type": "code",
"execution_count": 39,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>county</th>\n",
" <th>fips</th>\n",
" <th>candidate(d)</th>\n",
" <th>votes (d)</th>\n",
" <th>year</th>\n",
" <th>candidate(r)</th>\n",
" <th>votes (r)</th>\n",
" <th>candidate(O)</th>\n",
" <th>votes (O)</th>\n",
" <th>votes_total</th>\n",
" <th>voter_share_major_party</th>\n",
" <th>voter_share_dem</th>\n",
" <th>voter_share_rep</th>\n",
" <th>voter_share_other</th>\n",
" <th>rawdiff_dem_vs_rep</th>\n",
" <th>rawdiff_rep_vs_dem</th>\n",
" <th>rawdiff_dem_vs_other</th>\n",
" <th>rawdiff_rep_vs_other</th>\n",
" <th>rawdiff_other_vs_dem</th>\n",
" <th>rawdiff_other_vs_rep</th>\n",
" <th>pctdiff_dem_vs_rep</th>\n",
" <th>pctdiff_rep_vs_dem</th>\n",
" <th>pctdiff_dem_vs_other</th>\n",
" <th>pctdiff_rep_vs_other</th>\n",
" <th>pctdiff_other_vs_dem</th>\n",
" <th>pctdiff_other_vs_rep</th>\n",
" <th>OBJECTID</th>\n",
" <th>GEONAME</th>\n",
" <th>Total_cvap_est</th>\n",
" <th>SHAPE</th>\n",
" <th>Shape__Area</th>\n",
" <th>Shape__Length</th>\n",
" <th>voter_turnout</th>\n",
" <th>voter_turnout_majparty</th>\n",
" <th>voter_turnout_dem</th>\n",
" <th>voter_turnout_rep</th>\n",
" <th>voter_turnout_other</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>951</th>\n",
" <td>San Juan</td>\n",
" <td>08111</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>265.0</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>215.0</td>\n",
" <td>Other</td>\n",
" <td>26.0</td>\n",
" <td>506.0</td>\n",
" <td>0.948617</td>\n",
" <td>0.523715</td>\n",
" <td>0.424901</td>\n",
" <td>0.051383</td>\n",
" <td>50.0</td>\n",
" <td>-50.0</td>\n",
" <td>239.0</td>\n",
" <td>189.0</td>\n",
" <td>-239.0</td>\n",
" <td>-189.0</td>\n",
" <td>0.098814</td>\n",
" <td>-0.098814</td>\n",
" <td>0.472332</td>\n",
" <td>0.373518</td>\n",
" <td>-0.472332</td>\n",
" <td>-0.373518</td>\n",
" <td>301.0</td>\n",
" <td>San Juan County, Colorado</td>\n",
" <td>495.0</td>\n",
" <td>{'rings': [[[-11964863, 4528625.000100002], [-...</td>\n",
" <td>1.611963e+09</td>\n",
" <td>209299.379233</td>\n",
" <td>1.022222</td>\n",
" <td>0.969697</td>\n",
" <td>0.535354</td>\n",
" <td>0.434343</td>\n",
" <td>0.052525</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2385</th>\n",
" <td>Harding</td>\n",
" <td>35021</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>156.0</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>311.0</td>\n",
" <td>Other</td>\n",
" <td>60.0</td>\n",
" <td>527.0</td>\n",
" <td>0.886148</td>\n",
" <td>0.296015</td>\n",
" <td>0.590133</td>\n",
" <td>0.113852</td>\n",
" <td>-155.0</td>\n",
" <td>155.0</td>\n",
" <td>96.0</td>\n",
" <td>251.0</td>\n",
" <td>-96.0</td>\n",
" <td>-251.0</td>\n",
" <td>-0.294118</td>\n",
" <td>0.294118</td>\n",
" <td>0.182163</td>\n",
" <td>0.476281</td>\n",
" <td>-0.182163</td>\n",
" <td>-0.476281</td>\n",
" <td>1807.0</td>\n",
" <td>Harding County, New Mexico</td>\n",
" <td>470.0</td>\n",
" <td>{'rings': [[[-11578210, 4330676.000100002], [-...</td>\n",
" <td>8.400382e+09</td>\n",
" <td>492631.196575</td>\n",
" <td>1.121277</td>\n",
" <td>0.993617</td>\n",
" <td>0.331915</td>\n",
" <td>0.661702</td>\n",
" <td>0.127660</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2903</th>\n",
" <td>Loving</td>\n",
" <td>48301</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>4.0</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>58.0</td>\n",
" <td>Other</td>\n",
" <td>3.0</td>\n",
" <td>65.0</td>\n",
" <td>0.953846</td>\n",
" <td>0.061538</td>\n",
" <td>0.892308</td>\n",
" <td>0.046154</td>\n",
" <td>-54.0</td>\n",
" <td>54.0</td>\n",
" <td>1.0</td>\n",
" <td>55.0</td>\n",
" <td>-1.0</td>\n",
" <td>-55.0</td>\n",
" <td>-0.830769</td>\n",
" <td>0.830769</td>\n",
" <td>0.015385</td>\n",
" <td>0.846154</td>\n",
" <td>-0.015385</td>\n",
" <td>-0.846154</td>\n",
" <td>2674.0</td>\n",
" <td>Loving County, Texas</td>\n",
" <td>60.0</td>\n",
" <td>{'rings': [[[-11502370, 3717641.0001000017], [...</td>\n",
" <td>2.435674e+09</td>\n",
" <td>254898.035389</td>\n",
" <td>1.083333</td>\n",
" <td>1.033333</td>\n",
" <td>0.066667</td>\n",
" <td>0.966667</td>\n",
" <td>0.050000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2908</th>\n",
" <td>McMullen</td>\n",
" <td>48311</td>\n",
" <td>Hillary Clinton</td>\n",
" <td>40.0</td>\n",
" <td>2016</td>\n",
" <td>Donald Trump</td>\n",
" <td>454.0</td>\n",
" <td>Other</td>\n",
" <td>5.0</td>\n",
" <td>499.0</td>\n",
" <td>0.989980</td>\n",
" <td>0.080160</td>\n",
" <td>0.909820</td>\n",
" <td>0.010020</td>\n",
" <td>-414.0</td>\n",
" <td>414.0</td>\n",
" <td>35.0</td>\n",
" <td>449.0</td>\n",
" <td>-35.0</td>\n",
" <td>-449.0</td>\n",
" <td>-0.829659</td>\n",
" <td>0.829659</td>\n",
" <td>0.070140</td>\n",
" <td>0.899800</td>\n",
" <td>-0.070140</td>\n",
" <td>-0.899800</td>\n",
" <td>2679.0</td>\n",
" <td>McMullen County, Texas</td>\n",
" <td>460.0</td>\n",
" <td>{'rings': [[[-10946606, 3326438.0001000017], [...</td>\n",
" <td>3.882883e+09</td>\n",
" <td>253408.774844</td>\n",
" <td>1.084783</td>\n",
" <td>1.073913</td>\n",
" <td>0.086957</td>\n",
" <td>0.986957</td>\n",
" <td>0.010870</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" county fips ... voter_turnout_rep voter_turnout_other\n",
"951 San Juan 08111 ... 0.434343 0.052525\n",
"2385 Harding 35021 ... 0.661702 0.127660\n",
"2903 Loving 48301 ... 0.966667 0.050000\n",
"2908 McMullen 48311 ... 0.986957 0.010870\n",
"\n",
"[4 rows x 37 columns]"
]
},
"execution_count": 39,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Perform query for voter turnout above 100%\n",
"data_2016_df.loc[data_2016_df['voter_turnout'] > 1]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"There are four counties with very low population that resulted in voter turnout values above 100%. You could remove these records from the data or do additional research to identify the source of this issue. "
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment