Last active
March 1, 2017 05:56
-
-
Save psthomas/ed54ed0586f224544c5ad83763cb7267 to your computer and use it in GitHub Desktop.
Code for post looking at midterm 2018 prospects in House and Senate. https://pstblog.com/2017/02/15/midterm-election
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "# Democratic Prospects for the 2018 Midterm\n", | |
| "\n", | |
| "Below, I look at the prospects for each party in the 2018 election. Overall, the House actually looks pretty good for Democrats, with many Republicans up for re-election in districts that Clinton won. The Senate is a different story, with many Democrats running in states that Trump won by a considerable margin. But who knows what will happen if the election becomes a referendum on Trump.\n", | |
| "\n", | |
| "The data for this post come from [The DailyKos](https://docs.google.com/spreadsheets/d/1oRl7vxEJUUDWJCyrjo62cELJD2ONIVl-D9TSUKiK9jk/edit#gid=2132957126). If you're viewing this notebook on Github, view it in NBViewer [here](http://nbviewer.jupyter.org/gist/psthomas/ed54ed0586f224544c5ad83763cb7267) instead to see the interactive plots and tables. I don't have an in-depth understanding of politics, so it's possible I'm missing some good indicators for midterm success. Let me know if you have any ideas for additions." | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 2, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "%matplotlib inline\n", | |
| "\n", | |
| "import pandas as pd \n", | |
| "import numpy as np\n", | |
| "import json\n", | |
| " \n", | |
| "from IPython.display import HTML" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "# House Seats at Risk\n", | |
| "\n", | |
| "The plot below shows the 2016 Deocratic presidential lead on the x-axis, and the 2016 Democratic House lead on the y-axis. Any point near the x-axis was a close race, with those just above the axis won by Democrats and those just below won by Republicans. Points in the top left quadrant are seats that are especially at risk for Democrats because Trump won these districts. \n", | |
| "\n", | |
| "In the bottom right are districts that were won by Clinton in the presidential race, yet still held by House Republicans. There seem to be more Republican House seats at risk in 2018, which could especially be dangerous if the election becomes a referendum on Trump. " | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 3, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "house_df = pd.read_csv('house_data.csv', sep=',', encoding='utf-8')\n", | |
| "house_df['demlead_house2016'] = house_df['housedem_2016'] - house_df['houserep_2016']\n", | |
| "house_df['demlead_pres2016'] = ((house_df['clinton_2016'] - house_df['trump_2016'])/house_df['total_2016'])*100\n", | |
| "house_df['sum'] = house_df['demlead_house2016'] + house_df['demlead_pres2016']\n", | |
| "house_df = house_df.round(2)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 48, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<iframe srcdoc=\"\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset="utf-8">\n", | |
| " <title>Zoom + Pan</title>\n", | |
| " <style>\n", | |
| " \n", | |
| " body {\n", | |
| " position: relative;\n", | |
| " width: 650px; /*960px*/\n", | |
| " }\n", | |
| "\n", | |
| " svg {font: 10px sans-serif;}\n", | |
| "\n", | |
| " rect {fill: #e5e5e5; }\n", | |
| "\n", | |
| " .label {\n", | |
| " font-size: 12px;\n", | |
| " /*stroke: #ddd;*/\n", | |
| " fill: #555;\n", | |
| " }\n", | |
| "\n", | |
| " .dot {\n", | |
| " /*stroke: #aaa;*/\n", | |
| " /*stroke: red;*/\n", | |
| " /*border: 1;*/\n", | |
| " }\n", | |
| " .dot:hover {fill-opacity: 0.4;}\n", | |
| "\n", | |
| " .axis path,\n", | |
| " .axis line {\n", | |
| " stroke: #fff; /*black;*/\n", | |
| " fill: none; \n", | |
| " stroke-width: 1px;\n", | |
| " }\n", | |
| " \n", | |
| " #main-tick{\n", | |
| " fill: none;\n", | |
| " stroke: #777; \n", | |
| " stroke-width: 1px;\n", | |
| " opacity: 1;\n", | |
| " }\n", | |
| "\n", | |
| " .buttons {\n", | |
| " position: absolute;\n", | |
| " right: 30px;\n", | |
| " top: 30px;\n", | |
| " }\n", | |
| " button {\n", | |
| " font: 16px sans-serif;\n", | |
| " display: block;\n", | |
| " border-radius: 0px;\n", | |
| " width: 25px;\n", | |
| " /*outline: none;*/\n", | |
| " /*outline:0;*/\n", | |
| " background-color: white;\n", | |
| " border: none;\n", | |
| " }\n", | |
| " \n", | |
| " button:hover {\n", | |
| " background-image:none;\n", | |
| " background-color:#d5d5d5;\n", | |
| " }\n", | |
| " \n", | |
| " button:focus{ \n", | |
| " /*outline-color: #ddd;\n", | |
| " outline:none;*/\n", | |
| " outline: 1;\n", | |
| " outline-color: #b5b5b5;\n", | |
| " }\n", | |
| " \n", | |
| "\n", | |
| "\n", | |
| " div.tooltip {\n", | |
| " position: absolute;\n", | |
| " padding: 5px;\n", | |
| " font: 12px sans-serif;\n", | |
| " background: white;\n", | |
| " border: 0px;\n", | |
| " border-radius: 0px;\n", | |
| " pointer-events:none;\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| " <body>\n", | |
| " \n", | |
| " <div class="buttons">\n", | |
| " <button data-zoom="+1">+</button>\n", | |
| " <button data-zoom="-1">-</button>\n", | |
| " </div>\n", | |
| " <script src="//d3js.org/d3.v3.min.js"></script>\n", | |
| " <script>\n", | |
| "\n", | |
| " var margin = {top: 20, right: 20, bottom: 40, left: 40},\n", | |
| " width = 650 - margin.left - margin.right,\n", | |
| " height = 515 - margin.top - margin.bottom;\n", | |
| "\n", | |
| " var keys = {"demlead_house2016": 12, "trump_2016": 9, "first": 3, "houserep_2016": 6, "district": 0, "last": 4, "pvi_2016": 10, "demlead_pres2016": 13, "housedem_2016": 5, "party": 2, "total_2016": 7, "sum": 14, "code": 1, "clinton_2016": 8, "voting_age_pop": 11};\n", | |
| " var data = [["Nationwide","USA","240R-193D-2V",null,null,48.0,49.1,137098601.0,65853625.0,62985106.0,0.0,234562019.0,-1.1,2.09,0.99],["Alabama 1st","AL-01","Republican","Bradley","Byrne",0.0,96.4,303478.0,103364.0,192634.0,-16.2,515948.0,-96.4,-29.42,-125.82],["Alabama 2nd","AL-02","Republican","Martha","Roby",40.5,48.8,285664.0,94299.0,185505.0,-17.4,522837.0,-8.3,-31.93,-40.23],["Alabama 3rd","AL-03","Republican","Mike","Rogers",32.9,66.9,288776.0,93300.0,188477.0,-18.0,523481.0,-34.0,-32.96,-66.96],["Alabama 4th","AL-04","Republican","Robert","Aderholt",0.0,98.5,290726.0,50722.0,233661.0,-33.3,521081.0,-98.5,-62.92,-161.42],["Alabama 5th","AL-05","Republican","Mo","Brooks",33.2,66.7,309937.0,97159.0,200571.0,-18.5,523079.0,-33.5,-33.37,-66.87],["Alabama 6th","AL-06","Republican","Gary","Palmer",25.4,74.5,329849.0,86116.0,233493.0,-24.2,517305.0,-49.1,-44.68,-93.78],["Alabama 7th","AL-07","Democratic","Terri","Sewell",98.4,0.0,293231.0,204586.0,83915.0,19.8,523546.0,98.4,41.15,139.55],["Alaska At-Large","AK-AL","Republican","Don","Young",36.0,50.3,318608.0,116454.0,163387.0,-9.5,521588.0,-14.3,-14.73,-29.03],["Arizona 1st","AZ-01","Democratic","Tom","O'Halleran",50.7,43.4,284973.0,132874.0,135928.0,-1.7,522309.0,7.3,-1.07,6.23],["Arizona 2nd","AZ-02","Republican","Martha","McSally",43.0,57.0,315839.0,156676.0,141196.0,1.5,558252.0,-14.0,4.9,-9.1],["Arizona 3rd","AZ-03","Democratic","Ra\\u00fal","Grijalva",88.1,0.0,208934.0,130466.0,67952.0,14.6,497743.0,88.1,29.92,118.02],["Arizona 4th","AZ-04","Republican","Paul","Gosar",28.5,71.5,298483.0,82192.0,202043.0,-22.2,556383.0,-43.0,-40.15,-83.15],["Arizona 5th","AZ-05","Republican","Andy","Biggs",35.9,64.1,332093.0,121280.0,191432.0,-12.3,512943.0,-28.2,-21.12,-49.32],["Arizona 6th","AZ-06","Republican","David","Schweikert",37.9,62.1,338331.0,143571.0,177332.0,-6.4,554574.0,-24.2,-9.98,-34.18],["Arizona 7th","AZ-07","Democratic","Ruben","Gallego",75.2,24.7,164399.0,117958.0,37232.0,24.9,474491.0,50.5,49.1,99.6],["Arizona 8th","AZ-08","Republican","Trent","Franks",0.0,68.5,327325.0,120992.0,190163.0,-12.2,536590.0,-68.5,-21.13,-89.63],["Arizona 9th","AZ-09","Democratic","Kyrsten","Sinema",60.9,39.0,283863.0,155158.0,109123.0,7.6,549718.0,21.9,16.22,38.12],["Arkansas 1st","AR-01","Republican","Rick","Crawford",0.0,76.3,260717.0,78688.0,169438.0,-19.4,553023.0,-76.3,-34.81,-111.11],["Arkansas 2nd","AR-02","Republican","French","Hill",36.8,58.3,306974.0,127883.0,160782.0,-6.8,553609.0,-21.5,-10.72,-32.22],["Arkansas 3rd","AR-03","Republican","Steve","Womack",0.0,77.3,292163.0,89081.0,180921.0,-18.1,541997.0,-77.3,-31.43,-108.73],["Arkansas 4th","AR-04","Republican","Bruce","Westerman",0.0,74.9,270781.0,84842.0,173731.0,-18.3,555814.0,-74.9,-32.83,-107.73],["California 1st","CA-01","Republican","Doug","LaMalfa",40.9,59.1,313968.0,114727.0,176358.0,-11.7,555171.0,-18.2,-19.63,-37.83],["California 2nd","CA-02","Democratic","Jared","Huffman",76.9,23.1,344971.0,238157.0,80545.0,23.6,554173.0,53.8,45.69,99.49],["California 3rd","CA-03","Democratic","John","Garamendi",59.4,40.6,262086.0,138882.0,105860.0,5.6,525021.0,18.8,12.6,31.4],["California 4th","CA-04","Republican","Tom","McClintock",37.3,62.7,353388.0,138790.0,190924.0,-9.0,543649.0,-25.4,-14.75,-40.15],["California 5th","CA-05","Democratic","Mike","Thompson",76.9,23.1,305052.0,210950.0,74088.0,22.9,547233.0,53.8,44.87,98.67],["California 6th","CA-06","Democratic","Doris","Matsui",75.4,24.6,243910.0,168687.0,59549.0,22.8,520901.0,50.8,44.75,95.55],["California 7th","CA-07","Democratic","Ami","Bera",51.2,48.8,304118.0,159066.0,124249.0,5.0,521668.0,2.4,11.45,13.85],["California 8th","CA-08","Republican","Paul","Cook",37.7,62.3,232835.0,92234.0,127464.0,-9.1,504172.0,-24.6,-15.13,-39.73],["California 9th","CA-09","Democratic","Jerry","McNerney",57.4,42.6,238191.0,134719.0,90484.0,8.7,498183.0,14.8,18.57,33.37],["California 10th","CA-10","Republican","Jeff","Denham",48.3,51.7,239680.0,116335.0,109145.0,0.5,501640.0,-3.4,3.0,-0.4],["California 11th","CA-11","Democratic","Mark","DeSaulnier",72.1,27.9,312568.0,223559.0,70869.0,24.8,536843.0,44.2,48.85,93.05],["California 12th","CA-12","Democratic","Nancy","Pelosi",80.9,0.0,358774.0,309221.0,31158.0,39.7,614229.0,80.9,77.5,158.4],["California 13th","CA-13","Democratic","Barbara","Lee",90.8,9.2,334194.0,291926.0,22743.0,41.7,561936.0,81.6,80.55,162.15],["California 14th","CA-14","Democratic","Jackie","Speier",80.9,19.1,297743.0,229008.0,54229.0,29.7,553566.0,61.8,58.7,120.5],["California 15th","CA-15","Democratic","Eric","Swalwell",73.8,26.2,284536.0,198964.0,68808.0,23.2,525308.0,47.6,45.74,93.34],["California 16th","CA-16","Democratic","Jim","Costa",58.0,42.0,169964.0,98504.0,61813.0,10.3,478738.0,16.0,21.59,37.59],["California 17th","CA-17","Democratic","Ro","Khanna",100.0,0.0,248695.0,183801.0,50926.0,27.2,539199.0,100.0,53.43,153.43],["California 18th","CA-18","Democratic","Anna","Eshoo",71.1,28.9,335138.0,246015.0,67808.0,27.3,541587.0,42.2,53.17,95.37],["California 19th","CA-19","Democratic","Zoe","Lofgren",73.9,26.1,257624.0,187828.0,55371.0,26.1,521393.0,47.8,51.41,99.21],["California 20th","CA-20","Democratic","Jimmy","Panetta",70.8,29.2,256538.0,180486.0,59573.0,24.1,525025.0,41.6,47.13,88.73],["California 21st","CA-21","Republican","David","Valadao",43.3,56.7,133544.0,73773.0,52972.0,7.1,473659.0,-13.4,15.58,2.18],["California 22nd","CA-22","Republican","Devin","Nunes",32.4,67.6,240137.0,102292.0,125089.0,-6.1,499241.0,-35.2,-9.49,-44.69],["California 23rd","CA-23","Republican","Kevin","McCarthy",30.8,69.2,244864.0,88314.0,142351.0,-12.8,503535.0,-38.4,-22.07,-60.47],["California 24th","CA-24","Democratic","Salud","Carbajal",53.4,46.6,312160.0,176979.0,113887.0,9.7,553080.0,6.8,20.21,27.01],["California 25th","CA-25","Republican","Steve","Knight",46.9,53.1,273218.0,137491.0,119249.0,2.4,501767.0,-6.2,6.68,0.48],["California 26th","CA-26","Democratic","Julia","Brownley",60.4,39.6,292232.0,169083.0,105259.0,10.5,523593.0,20.8,21.84,42.64],["California 27th","CA-27","Democratic","Judy","Chu",67.4,32.6,264466.0,174544.0,74984.0,18.8,558942.0,34.8,37.65,72.45],["California 28th","CA-28","Democratic","Adam","Schiff",78.0,22.0,289254.0,208645.0,64607.0,25.2,582270.0,56.0,49.8,105.8],["California 29th","CA-29","Democratic","Tony","Cardenas",100.0,0.0,196196.0,152517.0,32963.0,31.1,512286.0,100.0,60.94,160.94],["California 30th","CA-30","Democratic","Brad","Sherman",72.6,27.4,302805.0,209149.0,77701.0,21.8,559607.0,45.2,43.41,88.61],["California 31st","CA-31","Democratic","Pete","Aguilar",56.1,43.9,228825.0,131960.0,83701.0,10.1,501208.0,12.2,21.09,33.29],["California 32nd","CA-32","Democratic","Grace","Napolitano",100.0,0.0,220046.0,146459.0,60921.0,19.5,521893.0,100.0,38.87,138.87],["California 33rd","CA-33","Democratic","Ted","Lieu",66.4,33.6,353897.0,239982.0,93706.0,20.8,568279.0,32.8,41.33,74.13],["California 34th","CA-34","Vacant (D)","Vacant","Vacant",100.0,0.0,184601.0,154259.0,19784.0,37.5,539883.0,100.0,72.85,172.85],["California 35th","CA-35","Democratic","Norma","Torres",72.4,27.6,188611.0,127757.0,50822.0,20.4,484975.0,44.8,40.79,85.59],["California 36th","CA-36","Democratic","Raul","Ruiz",62.1,37.9,237370.0,123795.0,103051.0,3.5,521859.0,24.2,8.74,32.94],["California 37th","CA-37","Democratic","Karen","Bass",100.0,0.0,276134.0,236621.0,26608.0,38.8,553286.0,100.0,76.05,176.05],["California 38th","CA-38","Democratic","Linda","S\\u00e1nchez",70.5,29.5,248224.0,166224.0,68033.0,19.8,516385.0,41.0,39.56,80.56],["California 39th","CA-39","Republican","Ed","Royce",42.8,57.2,272471.0,140230.0,116782.0,3.4,530634.0,-14.4,8.61,-5.79],["California 40th","CA-40","Democratic","Lucille","Roybal-Allard",71.4,0.0,164714.0,135472.0,21077.0,35.4,478423.0,71.4,69.45,140.85],["California 41st","CA-41","Democratic","Mark","Takano",65.0,35.0,206961.0,126197.0,68526.0,13.7,490407.0,30.0,27.87,57.87],["California 42nd","CA-42","Republican","Ken","Calvert",41.2,58.8,268305.0,111103.0,143175.0,-7.4,502971.0,-17.6,-11.95,-29.55],["California 43rd","CA-43","Democratic","Maxine","Waters",76.1,23.9,234060.0,183434.0,39039.0,31.3,520049.0,52.2,61.69,113.89],["California 44th","CA-44","Democratic","Nanette","Barragan",100.0,0.0,197802.0,164251.0,24261.0,36.0,487334.0,100.0,70.77,170.77],["California 45th","CA-45","Republican","Mimi","Walters",41.4,58.6,325967.0,162449.0,144713.0,1.8,531667.0,-17.2,5.44,-11.76],["California 46th","CA-46","Democratic","Lou","Correa",100.0,0.0,180750.0,119762.0,50403.0,19.3,504841.0,100.0,38.37,138.37],["California 47th","CA-47","Democratic","Alan","Lowenthal",63.7,36.3,258320.0,161743.0,80162.0,15.7,533085.0,27.4,31.58,58.98],["California 48th","CA-48","Republican","Dana","Rohrabacher",41.7,58.3,317328.0,152035.0,146595.0,-0.2,561701.0,-16.6,1.71,-14.89],["California 49th","CA-49","Republican","Darrell","Issa",49.7,50.3,314011.0,159081.0,135576.0,2.9,541472.0,-0.6,7.49,6.89],["California 50th","CA-50","Republican","Duncan","Hunter",36.5,63.5,292878.0,115864.0,159822.0,-9.1,520756.0,-27.0,-15.01,-42.01],["California 51st","CA-51","Democratic","Juan","Vargas",72.8,27.2,205437.0,147603.0,46825.0,24.8,503460.0,45.6,49.06,94.66],["California 52nd","CA-52","Democratic","Scott","Peters",56.5,43.5,329258.0,191325.0,117057.0,10.9,560637.0,13.0,22.56,35.56],["California 53rd","CA-53","Democratic","Susan","Davis",67.0,33.0,310373.0,200237.0,91822.0,17.4,546096.0,34.0,34.93,68.93],["Colorado 1st","CO-01","Democratic","Diana","DeGette",67.9,27.7,402463.0,277790.0,93486.0,23.7,561585.0,40.2,45.79,85.99],["Colorado 2nd","CO-02","Democratic","Jared","Polis",56.9,37.2,471308.0,264925.0,164710.0,10.5,568934.0,19.7,21.26,40.96],["Colorado 3rd","CO-03","Republican","Scott","Tipton",40.3,54.6,377176.0,151057.0,195966.0,-7.6,549229.0,-14.3,-11.91,-26.21],["Colorado 4th","CO-04","Republican","Ken","Buck",31.7,63.5,402197.0,137779.0,230945.0,-13.7,522909.0,-31.8,-23.16,-54.96],["Colorado 5th","CO-05","Republican","Doug","Lamborn",30.9,62.3,371751.0,123508.0,212517.0,-14.4,539460.0,-31.4,-23.94,-55.34],["Colorado 6th","CO-06","Republican","Mike","Coffman",42.6,50.9,380535.0,191103.0,157115.0,3.8,521204.0,-8.3,8.93,0.63],["Colorado 7th","CO-07","Democratic","Ed","Perlmutter",55.2,39.8,374616.0,192637.0,147645.0,5.5,540266.0,15.4,12.01,27.41],["Connecticut 1st","CT-01","Democratic","John","Larson",64.1,33.8,328774.0,195305.0,119395.0,10.9,550375.0,30.3,23.09,53.39],["Connecticut 2nd","CT-02","Democratic","Joe","Courtney",63.2,33.7,340758.0,165799.0,155975.0,0.4,559634.0,29.5,2.88,32.38],["Connecticut 3rd","CT-03","Democratic","Rosa","DeLauro",69.0,31.0,321837.0,179832.0,129968.0,6.9,563641.0,38.0,15.49,53.49],["Connecticut 4th","CT-04","Democratic","Jim","Himes",59.9,40.1,328198.0,195494.0,119976.0,10.9,536108.0,19.8,23.01,42.81],["Connecticut 5th","CT-05","Democratic","Elizabeth","Esty",58.0,42.0,322737.0,161142.0,147901.0,1.0,547324.0,16.0,4.1,20.1],["Delaware At-Large","DE-AL","Democratic","Lisa","Blunt Rochester",55.5,41.0,441590.0,235603.0,185127.0,4.9,692169.0,14.5,11.43,25.93],["Florida 1st","FL-01","Republican","Matt","Gaetz",30.9,69.1,380100.0,107063.0,256609.0,-21.7,541847.0,-38.2,-39.34,-77.54],["Florida 2nd","FL-02","Republican","Neal","Dunn",29.9,67.3,354948.0,108636.0,234991.0,-19.5,549325.0,-37.4,-35.6,-73.0],["Florida 3rd","FL-03","Republican","Ted","Yoho",39.8,56.6,351688.0,141362.0,197478.0,-9.4,544863.0,-16.8,-15.96,-32.76],["Florida 4th","FL-04","Republican","John","Rutherford",27.6,70.2,421618.0,143675.0,261826.0,-15.7,548152.0,-42.6,-28.02,-70.62],["Florida 5th","FL-05","Democratic","Al","Lawson",64.2,35.8,312071.0,191194.0,111892.0,12.0,528480.0,28.4,25.41,53.81],["Florida 6th","FL-06","Republican","Ron","DeSantis",41.4,58.6,379804.0,151453.0,215941.0,-9.9,564224.0,-17.2,-16.98,-34.18],["Florida 7th","FL-07","Democratic","Stephanie","Murphy",51.5,48.5,363186.0,186658.0,160178.0,2.7,548186.0,3.0,7.29,10.29],["Florida 8th","FL-08","Republican","Bill","Posey",32.5,63.1,401911.0,151412.0,234648.0,-11.9,558439.0,-30.6,-20.71,-51.31],["Florida 9th","FL-09","Democratic","Darren","Soto",57.5,42.5,356530.0,195368.0,149352.0,5.6,520247.0,15.0,12.91,27.91],["Florida 10th","FL-10","Democratic","Val","Demings",64.9,35.1,315611.0,194934.0,110062.0,12.8,519891.0,29.8,26.89,56.69],["Florida 11th","FL-11","Republican","Daniel","Webster",31.6,65.4,410998.0,133448.0,266256.0,-17.7,574603.0,-33.8,-32.31,-66.11],["Florida 12th","FL-12","Republican","Gus","Bilirakis",31.4,68.6,380357.0,147759.0,218487.0,-10.8,554847.0,-37.2,-18.6,-55.8],["Florida 13th","FL-13","Democratic","Charlie","Crist",51.9,48.1,360760.0,178892.0,167348.0,0.6,572547.0,3.8,3.2,7.0],["Florida 14th","FL-14","Democratic","Kathy","Castor",61.8,38.2,330433.0,188870.0,128797.0,8.3,540408.0,23.6,18.18,41.78],["Florida 15th","FL-15","Republican","Dennis","Ross",42.5,57.5,334518.0,144225.0,177635.0,-6.3,533364.0,-15.0,-9.99,-24.99],["Florida 16th","FL-16","Republican","Vern","Buchanan",40.2,59.8,396807.0,170442.0,213271.0,-6.7,555284.0,-19.6,-10.79,-30.39],["Florida 17th","FL-17","Republican","Tom","Rooney",34.2,61.8,353861.0,123919.0,220156.0,-15.1,563830.0,-27.6,-27.2,-54.8],["Florida 18th","FL-18","Republican","Brian","Mast",43.1,53.6,382474.0,168558.0,203771.0,-5.8,557944.0,-10.5,-9.21,-19.71],["Florida 19th","FL-19","Republican","Francis","Rooney",34.1,65.9,381158.0,143001.0,227097.0,-12.5,569135.0,-31.8,-22.06,-53.86],["Florida 20th","FL-20","Democratic","Alcee","Hastings",80.3,19.7,288811.0,231596.0,52251.0,30.5,523033.0,60.6,62.1,122.7],["Florida 21st","FL-21","Democratic","Lois","Frankel",62.7,35.1,351661.0,206239.0,137490.0,8.9,554416.0,27.6,19.55,47.15],["Florida 22nd","FL-22","Democratic","Ted","Deutch",58.9,41.1,356482.0,202355.0,146228.0,6.9,562571.0,17.8,15.74,33.54],["Florida 23rd","FL-23","Democratic","Debbie","Wasserman Schultz",56.7,40.5,337782.0,209079.0,120967.0,12.2,542450.0,16.2,26.09,42.29],["Florida 24th","FL-24","Democratic","Frederica","Wilson",100.0,0.0,263196.0,218424.0,40234.0,33.3,530066.0,100.0,67.7,167.7],["Florida 25th","FL-25","Republican","Mario","Diaz-Balart",37.6,62.4,264255.0,126702.0,131186.0,-2.0,540846.0,-24.8,-1.7,-26.5],["Florida 26th","FL-26","Republican","Carlos","Curbelo",41.2,53.0,284735.0,161555.0,115529.0,7.2,530119.0,-11.8,16.16,4.36],["Florida 27th","FL-27","Republican","Ileana","Ros-Lehtinen",45.1,54.9,304130.0,178154.0,118206.0,9.0,569381.0,-9.8,19.71,9.91],["Georgia 1st","GA-01","Republican","Buddy","Carter",0.0,100.0,269568.0,110190.0,151996.0,-9.1,518703.0,-100.0,-15.51,-115.51],["Georgia 2nd","GA-02","Democratic","Sanford","Bishop",61.2,38.8,248103.0,136455.0,107361.0,4.9,515612.0,22.4,11.73,34.13],["Georgia 3rd","GA-03","Republican","Drew","Ferguson",31.7,68.3,311865.0,102155.0,200624.0,-17.4,515563.0,-36.6,-31.57,-68.17],["Georgia 4th","GA-04","Democratic","Hank","Johnson",75.7,24.3,298663.0,224907.0,66433.0,26.1,504112.0,51.4,53.06,104.46],["Georgia 5th","GA-05","Democratic","John","Lewis",84.4,15.6,305754.0,259805.0,36385.0,36.6,539971.0,68.8,73.07,141.87],["Georgia 6th","GA-06","Republican","Tom","Price",38.3,61.7,331246.0,155077.0,160022.0,-1.9,519945.0,-23.4,-1.49,-24.89],["Georgia 7th","GA-07","Republican","Rob","Woodall",39.6,60.4,294972.0,132012.0,150845.0,-4.4,489192.0,-20.8,-6.38,-27.18],["Georgia 8th","GA-08","Republican","Austin","Scott",32.4,67.6,265514.0,91360.0,168193.0,-15.9,517611.0,-35.2,-28.94,-64.14],["Georgia 9th","GA-09","Republican","Doug","Collins",0.0,100.0,297215.0,57468.0,231194.0,-31.2,522084.0,-100.0,-58.45,-158.45],["Georgia 10th","GA-10","Republican","Jody","Hice",0.0,100.0,315073.0,112691.0,193030.0,-14.3,519419.0,-100.0,-25.5,-125.5],["Georgia 11th","GA-11","Republican","Barry","Loudermilk",32.6,67.4,329615.0,116457.0,198813.0,-14.2,512972.0,-34.8,-24.99,-59.79],["Georgia 12th","GA-12","Republican","Rick","Allen",38.4,61.6,267674.0,108937.0,152204.0,-9.4,519454.0,-23.2,-16.16,-39.36],["Georgia 13th","GA-13","Democratic","David","Scott",100.0,0.0,301238.0,213936.0,80157.0,21.6,492458.0,100.0,44.41,144.41],["Georgia 14th","GA-14","Republican","Tom","Graves",0.0,100.0,255872.0,56513.0,191849.0,-28.4,509005.0,-100.0,-52.89,-152.89],["Hawaii 1st","HI-01","Democratic","Colleen","Hanabusa",71.9,22.7,209300.0,132009.0,63916.0,16.3,537531.0,49.2,32.53,81.73],["Hawaii 2nd","HI-02","Democratic","Tulsi","Gabbard",81.2,18.8,219637.0,134882.0,64931.0,16.4,518952.0,62.4,31.85,94.25],["Idaho 1st","ID-01","Republican","Ra\\u00fal","Labrador",31.8,68.2,359661.0,91284.0,229034.0,-22.6,571430.0,-36.4,-38.3,-74.7],["Idaho 2nd","ID-02","Republican","Mike","Simpson",29.4,62.9,330594.0,98481.0,180021.0,-15.8,567080.0,-33.5,-24.66,-58.16],["Illinois 1st","IL-01","Democratic","Bobby","Rush",74.1,25.9,326175.0,245908.0,69956.0,26.7,533507.0,48.2,53.94,102.14],["Illinois 2nd","IL-02","Democratic","Robin","Kelly",79.8,20.2,303622.0,236726.0,58024.0,29.2,522175.0,59.6,58.86,118.46],["Illinois 3rd","IL-03","Democratic","Dan","Lipinski",100.0,0.0,284970.0,157383.0,113779.0,6.9,530768.0,100.0,15.3,115.3],["Illinois 4th","IL-04","Democratic","Luis","Guti\\u00e9rrez",100.0,0.0,209931.0,172374.0,27807.0,35.0,509233.0,100.0,68.86,168.86],["Illinois 5th","IL-05","Democratic","Mike","Quigley",67.8,27.5,326036.0,229937.0,78069.0,23.5,582376.0,40.3,46.58,86.88],["Illinois 6th","IL-06","Republican","Peter","Roskam",40.8,59.2,353766.0,177578.0,152909.0,2.6,531232.0,-18.4,6.97,-11.43],["Illinois 7th","IL-07","Democratic","Danny","Davis",84.2,15.8,310159.0,271100.0,28580.0,39.3,551986.0,68.4,78.19,146.59],["Illinois 8th","IL-08","Democratic","Raja","Krishnamoorthi",58.3,41.7,255064.0,148233.0,92926.0,10.4,535959.0,16.6,21.68,38.28],["Illinois 9th","IL-09","Democratic","Jan","Schakowsky",66.5,33.5,339587.0,238096.0,84456.0,22.7,564386.0,33.0,45.24,78.24],["Illinois 10th","IL-10","Democratic","Brad","Schneider",52.6,47.4,288303.0,178857.0,94108.0,14.4,525064.0,5.2,29.4,34.6],["Illinois 11th","IL-11","Democratic","Bill","Foster",60.4,39.6,279620.0,164632.0,99104.0,11.3,508627.0,20.8,23.43,44.23],["Illinois 12th","IL-12","Republican","Mike","Bost",39.7,54.3,315846.0,126817.0,173693.0,-8.9,547710.0,-14.6,-14.84,-29.44],["Illinois 13th","IL-13","Republican","Rodney","Davis",40.3,59.7,319979.0,141541.0,159013.0,-4.0,561827.0,-19.4,-5.46,-24.86],["Illinois 14th","IL-14","Republican","Randy","Hultgren",40.7,59.3,343417.0,153989.0,167348.0,-3.2,508613.0,-18.6,-3.89,-22.49],["Illinois 15th","IL-15","Republican","John","Shimkus",0.0,100.0,320442.0,78574.0,226605.0,-25.4,550135.0,-100.0,-46.2,-146.2],["Illinois 16th","IL-16","Republican","Adam","Kinzinger",0.0,99.9,311988.0,119542.0,173093.0,-10.3,544420.0,-99.9,-17.16,-117.06],["Illinois 17th","IL-17","Democratic","Cheri","Bustos",60.3,39.7,287103.0,133999.0,136017.0,-1.5,545747.0,20.6,-0.7,19.9],["Illinois 18th","IL-18","Republican","Darin","LaHood",27.9,72.1,347134.0,115442.0,210529.0,-15.7,547688.0,-44.2,-27.39,-71.59],["Indiana 1st","IN-01","Democratic","Pete","Visclosky",81.5,0.0,300283.0,162358.0,124638.0,5.5,539744.0,81.5,12.56,94.06],["Indiana 2nd","IN-02","Republican","Jackie","Walorski",36.9,59.3,275928.0,99496.0,163527.0,-13.3,536097.0,-22.4,-23.21,-45.61],["Indiana 3rd","IN-03","Republican","Jim","Banks",23.0,70.1,291173.0,87697.0,189573.0,-19.5,526624.0,-47.1,-34.99,-82.09],["Indiana 4th","IN-04","Republican","Todd","Rokita",30.5,64.6,302370.0,91264.0,194402.0,-19.2,546655.0,-34.1,-34.11,-68.21],["Indiana 5th","IN-05","Republican","Susan","Brooks",34.3,61.5,363584.0,150081.0,192998.0,-7.4,535579.0,-27.2,-11.8,-39.0],["Indiana 6th","IN-06","Republican","Luke","Messer",26.7,69.1,301524.0,82498.0,204129.0,-22.3,548538.0,-42.4,-40.34,-82.74],["Indiana 7th","IN-07","Democratic","Andr\\u00e9","Carson",60.0,35.7,264325.0,156015.0,95625.0,10.9,533492.0,24.3,22.85,47.15],["Indiana 8th","IN-08","Republican","Larry","Bucshon",31.7,63.7,300621.0,92844.0,194208.0,-18.8,554038.0,-32.0,-33.72,-65.72],["Indiana 9th","IN-09","Republican","Trey","Hollingsworth",40.5,54.1,324475.0,110835.0,198106.0,-15.2,554737.0,-13.6,-26.9,-40.5],["Iowa 1st","IA-01","Republican","Rod","Blum",46.1,53.7,390934.0,176535.0,190410.0,-3.0,581256.0,-7.6,-3.55,-11.15],["Iowa 2nd","IA-02","Democratic","Dave","Loebsack",53.7,46.2,379959.0,170796.0,186384.0,-3.3,584497.0,7.5,-4.1,3.4],["Iowa 3rd","IA-03","Republican","David","Young",39.7,53.4,397492.0,178937.0,192960.0,-3.0,568128.0,-13.7,-3.53,-17.23],["Iowa 4th","IA-04","Republican","Steve","King",38.6,61.2,379900.0,127401.0,231229.0,-15.6,584481.0,-22.6,-27.33,-49.93],["Kansas 1st","KS-01","Republican","Roger","Marshall",0.0,65.9,264783.0,64384.0,183473.0,-25.1,536568.0,-65.9,-44.98,-110.88],["Kansas 2nd","KS-02","Republican","Lynn","Jenkins",32.6,60.9,295657.0,110596.0,165000.0,-11.0,543270.0,-28.3,-18.4,-46.7],["Kansas 3rd","KS-03","Republican","Kevin","Yoder",40.6,51.3,341967.0,161479.0,157304.0,-0.5,522489.0,-10.7,1.22,-9.48],["Kansas 4th","KS-04","Vacant (R)","Vacant","Vacant",29.6,60.7,274528.0,90546.0,165241.0,-15.7,523820.0,-31.1,-27.21,-58.31],["Kentucky 1st","KY-01","Republican","James","Comer",27.3,72.6,310299.0,74179.0,224657.0,-26.3,554556.0,-45.3,-48.49,-93.79],["Kentucky 2nd","KY-02","Republican","Brett","Guthrie",0.0,100.0,324512.0,89563.0,219152.0,-22.1,548073.0,-100.0,-39.93,-139.93],["Kentucky 3rd","KY-03","Democratic","John","Yarmuth",63.5,36.5,340043.0,186549.0,135714.0,6.8,556038.0,27.0,14.95,41.95],["Kentucky 4th","KY-04","Republican","Thomas","Massie",28.7,71.3,337149.0,98664.0,219749.0,-20.1,539855.0,-42.6,-35.91,-78.51],["Kentucky 5th","KY-05","Republican","Hal","Rogers",0.0,100.0,278383.0,48628.0,221558.0,-33.1,559487.0,-100.0,-62.12,-162.12],["Kentucky 6th","KY-06","Republican","Andy","Barr",38.9,61.1,333012.0,131271.0,182141.0,-9.2,557982.0,-22.2,-15.28,-37.48],["Louisiana 1st","LA-01","Republican","Steve","Scalise",19.5,74.6,356482.0,95169.0,244907.0,-23.1,580152.0,-55.1,-42.0,-97.1],["Louisiana 2nd","LA-02","Democratic","Cedric","Richmond",100.0,0.0,331702.0,247490.0,73779.0,25.9,569251.0,100.0,52.37,152.37],["Louisiana 3rd","LA-03","Republican","Clay","Higgins",17.5,80.7,343025.0,100241.0,231017.0,-20.9,561690.0,-63.2,-38.12,-101.32],["Louisiana 4th","LA-04","Republican","Mike","Johnson",28.2,69.8,318462.0,116599.0,192977.0,-13.4,566615.0,-41.6,-23.98,-65.58],["Louisiana 5th","LA-05","Republican","Ralph","Abraham",0.0,100.0,323409.0,110259.0,205258.0,-16.2,567467.0,-100.0,-29.37,-129.37],["Louisiana 6th","LA-06","Republican","Garret","Graves",23.9,72.8,355951.0,110395.0,230700.0,-18.7,570182.0,-48.9,-33.8,-82.7],["Maine 1st","ME-01","Democratic","Chellie","Pingree",58.0,41.9,393343.0,212773.0,154425.0,6.8,526524.0,16.1,14.83,30.93],["Maine 2nd","ME-02","Republican","Bruce","Poliquin",45.2,54.8,352341.0,144962.0,181168.0,-6.7,527304.0,-9.6,-10.28,-19.88],["Maryland 1st","MD-01","Republican","Andy","Harris",28.6,67.0,363917.0,121841.0,225249.0,-16.0,556858.0,-38.4,-28.42,-66.82],["Maryland 2nd","MD-02","Democratic","Dutch","Ruppersberger",62.1,33.1,321234.0,193236.0,114461.0,11.7,548029.0,29.0,24.52,53.52],["Maryland 3rd","MD-03","Democratic","John","Sarbanes",63.2,33.9,352627.0,221842.0,113317.0,15.1,561258.0,29.3,30.78,60.08],["Maryland 4th","MD-04","Democratic","Anthony","Brown",74.1,21.4,330115.0,256575.0,63390.0,29.1,546219.0,52.7,58.52,111.22],["Maryland 5th","MD-05","Democratic","Steny","Hoyer",67.4,29.4,355428.0,225989.0,115868.0,15.0,546582.0,38.0,30.98,68.98],["Maryland 6th","MD-06","Democratic","John","Delaney",56.0,40.1,339563.0,189512.0,134827.0,7.3,551978.0,15.9,16.1,32.0],["Maryland 7th","MD-07","Democratic","Elijah","Cummings",74.9,21.8,309849.0,233796.0,63444.0,27.5,554898.0,53.1,54.98,108.08],["Maryland 8th","MD-08","Democratic","Jamie","Raskin",60.6,34.2,363916.0,235137.0,112613.0,16.5,554766.0,26.4,33.67,60.07],["Massachusetts 1st","MA-01","Democratic","Richie","Neal",73.3,0.0,339326.0,194036.0,123953.0,9.9,564391.0,73.3,20.65,93.95],["Massachusetts 2nd","MA-02","Democratic","Jim","McGovern",98.2,0.0,351423.0,197492.0,129437.0,9.3,566402.0,98.2,19.37,117.57],["Massachusetts 3rd","MA-03","Democratic","Niki","Tsongas",68.7,31.2,348563.0,202952.0,123347.0,11.1,549384.0,37.5,22.84,60.34],["Massachusetts 4th","MA-04","Democratic","Joe","Kennedy",70.1,29.8,381767.0,225976.0,133705.0,11.7,556642.0,40.3,24.17,64.47],["Massachusetts 5th","MA-05","Democratic","Katherine","Clark",98.6,0.0,373498.0,258908.0,95922.0,21.9,579172.0,98.6,43.64,142.24],["Massachusetts 6th","MA-06","Democratic","Seth","Moulton",98.4,0.0,401046.0,224858.0,153244.0,8.4,564150.0,98.4,17.86,116.26],["Massachusetts 7th","MA-07","Democratic","Mike","Capuano",98.6,0.0,301939.0,254037.0,36018.0,36.5,599387.0,98.6,72.21,170.81],["Massachusetts 8th","MA-08","Democratic","Stephen","Lynch",72.4,27.5,382917.0,231356.0,131624.0,12.6,575118.0,44.9,26.05,70.95],["Massachusetts 9th","MA-09","Democratic","Bill","Keating",55.7,33.6,391289.0,205581.0,163643.0,4.6,574060.0,22.1,10.72,32.82],["Michigan 1st","MI-01","Republican","Jack","Bergman",40.1,54.9,364131.1,133236.7,210822.1,-12.4,562018.0,-14.8,-21.31,-36.11],["Michigan 2nd","MI-02","Republican","Bill","Huizenga",32.5,62.6,346504.8,132462.3,193198.1,-10.4,526885.0,-30.1,-17.53,-47.63],["Michigan 3rd","MI-03","Republican","Justin","Amash",37.5,59.5,349489.7,147329.8,180344.0,-6.2,525031.0,-22.0,-9.45,-31.45],["Michigan 4th","MI-04","Republican","John","Moolenaar",32.1,61.6,328239.9,113817.1,195302.5,-14.3,549309.0,-29.5,-24.82,-54.32],["Michigan 5th","MI-05","Democratic","Dan","Kildee",61.2,35.1,327572.3,162961.1,148972.0,1.1,535819.0,26.1,4.27,30.37],["Michigan 6th","MI-06","Republican","Fred","Upton",36.4,58.6,331985.5,142305.1,170314.3,-5.6,536850.0,-22.2,-8.44,-30.64],["Michigan 7th","MI-07","Republican","Tim","Walberg",40.0,55.1,340357.8,131566.2,189655.5,-10.2,539775.0,-15.1,-17.07,-32.17],["Michigan 8th","MI-08","Republican","Mike","Bishop",39.2,56.0,374968.0,164436.0,189891.0,-4.7,537989.0,-16.8,-6.79,-23.59],["Michigan 9th","MI-09","Democratic","Sandy","Levin",57.9,37.4,355751.0,183085.0,155597.0,2.9,554396.0,20.5,7.73,28.23],["Michigan 10th","MI-10","Republican","Paul","Mitchell",32.3,63.1,357784.7,113064.9,228171.0,-18.0,535917.0,-30.8,-32.17,-62.97],["Michigan 11th","MI-11","Republican","Dave","Trott",40.2,52.9,390926.0,177143.0,194245.0,-3.4,537930.0,-12.7,-4.37,-17.07],["Michigan 12th","MI-12","Democratic","Debbie","Dingell",64.3,29.3,338523.2,205938.8,116740.5,12.7,545365.0,35.0,26.35,61.35],["Michigan 13th","MI-13","Democratic","John","Conyers",77.1,15.7,265343.0,209105.0,48111.0,30.2,523898.0,61.4,60.67,122.07],["Michigan 14th","MI-14","Democratic","Brenda","Lawrence",78.5,18.7,318751.0,252387.0,58179.0,30.2,528390.0,59.8,60.93,120.73],["Minnesota 1st","MN-01","Democratic","Tim","Walz",50.3,49.6,340831.0,130831.0,181647.0,-9.2,505339.0,0.7,-14.91,-14.21],["Minnesota 2nd","MN-02","Republican","Jason","Lewis",45.2,47.0,377887.0,171287.0,175807.0,-1.8,485541.0,-1.8,-1.2,-3.0],["Minnesota 3rd","MN-03","Republican","Erik","Paulsen",43.0,56.7,397008.0,201833.0,164259.0,4.0,496951.0,-13.7,9.46,-4.24],["Minnesota 4th","MN-04","Democratic","Betty","McCollum",57.8,34.4,363650.0,223803.0,111163.0,15.7,504063.0,23.4,30.97,54.37],["Minnesota 5th","MN-05","Democratic","Keith","Ellison",69.1,22.3,370869.0,273402.0,68535.0,28.8,523712.0,46.8,55.24,102.04],["Minnesota 6th","MN-06","Republican","Tom","Emmer",34.3,65.6,370947.0,123329.0,218546.0,-15.0,482759.0,-31.3,-25.67,-56.97],["Minnesota 7th","MN-07","Democratic","Collin","Peterson",52.5,47.4,337005.0,104566.0,208215.0,-17.7,505477.0,5.1,-30.76,-25.66],["Minnesota 8th","MN-08","Democratic","Rick","Nolan",50.2,49.6,359353.0,138665.0,194779.0,-9.5,516020.0,0.6,-15.62,-15.02],["Mississippi 1st","MS-01","Republican","Trent","Kelly",27.9,68.7,310622.2,100769.5,203143.7,-18.0,553526.0,-40.8,-32.96,-73.76],["Mississippi 2nd","MS-02","Democratic","Bennie","Thompson",67.1,29.1,291426.7,185208.3,102391.5,13.3,543684.0,38.0,28.42,66.42],["Mississippi 3rd","MS-03","Republican","Gregg","Harper",30.4,66.2,323853.1,119108.2,198526.8,-13.6,557605.0,-35.8,-24.52,-60.32],["Mississippi 4th","MS-04","Republican","Steven","Palazzo",27.8,65.0,283455.0,80045.0,196652.0,-22.2,556927.0,-37.2,-41.14,-78.34],["Missouri 1st","MO-01","Democratic","Lacy","Clay",75.5,20.0,319606.0,246107.0,60136.0,29.3,575685.0,55.5,58.19,113.69],["Missouri 2nd","MO-02","Republican","Ann","Wagner",37.7,58.5,420072.0,177647.0,220842.0,-6.5,572513.0,-20.8,-10.28,-31.08],["Missouri 3rd","MO-03","Republican","Blaine","Luetkemeyer",27.9,67.8,378846.0,106365.0,254183.0,-21.6,563086.0,-39.9,-39.02,-78.92],["Missouri 4th","MO-04","Republican","Vicky","Hartzler",27.8,67.8,340290.0,99844.0,222162.0,-20.1,573748.0,-40.0,-35.95,-75.95],["Missouri 5th","MO-05","Democratic","Emanuel","Cleaver",58.8,38.2,328803.0,177772.0,133458.0,6.0,569063.0,20.6,13.48,34.08],["Missouri 6th","MO-06","Republican","Sam","Graves",28.4,68.0,354014.0,112056.0,223375.0,-17.7,564869.0,-39.6,-31.44,-71.04],["Missouri 7th","MO-07","Republican","Billy","Long",27.4,67.5,342069.0,84419.0,240690.0,-25.1,571140.0,-40.1,-45.68,-85.78],["Missouri 8th","MO-08","Republican","Jason","Smith",22.7,74.4,317749.0,66858.0,239666.0,-29.3,573387.0,-51.7,-54.39,-106.09],["Montana At-Large","MT-AL","Republican","Ryan","Zinke",40.5,56.2,494525.0,177709.0,279240.0,-12.2,765852.0,-15.7,-20.53,-36.23],["Nebraska 1st","NE-01","Republican","Jeff","Fortenberry",30.5,69.5,276046.0,100030.0,158629.0,-12.4,458727.0,-39.0,-21.23,-60.23],["Nebraska 2nd","NE-02","Republican","Don","Bacon",47.7,48.9,285211.0,131102.0,137506.0,-2.3,447161.0,-1.2,-2.25,-3.45],["Nebraska 3rd","NE-03","Republican","Adrian","Smith",0.0,100.0,266918.0,53362.0,199826.0,-30.0,461232.0,-100.0,-54.87,-154.87],["Nevada 1st","NV-01","Democratic","Dina","Titus",61.9,28.8,196840.0,121321.0,64233.0,14.3,509371.0,33.1,29.0,62.1],["Nevada 2nd","NV-02","Republican","Mark","Amodei",36.9,58.3,326011.0,129318.0,169631.0,-7.9,515125.0,-21.4,-12.37,-33.77],["Nevada 3rd","NV-03","Democratic","Jacky","Rosen",47.2,46.0,325602.0,151552.0,154815.0,-1.6,521733.0,1.2,-1.0,0.2],["Nevada 4th","NV-04","Democratic","Ruben","Kihuen",48.5,44.5,276932.0,137070.0,123380.0,1.5,489314.0,4.0,4.94,8.94],["New Hampshire 1st","NH-01","Democratic","Carol","Shea-Porter",45.8,44.4,371973.0,173344.0,179259.0,-2.0,514495.0,1.4,-1.59,-0.19],["New Hampshire 2nd","NH-02","Democratic","Annie","Kuster",49.8,45.4,360294.0,175182.0,166531.0,0.2,514741.0,4.4,2.4,6.8],["New Jersey 1st","NJ-01","Democratic","Donald","Norcross",60.0,36.8,329188.0,199386.0,118880.0,11.5,556968.0,23.2,24.46,47.66],["New Jersey 2nd","NJ-02","Republican","Frank","LoBiondo",37.2,59.2,321004.0,147656.0,162486.0,-3.5,564025.0,-22.0,-4.62,-26.62],["New Jersey 3rd","NJ-03","Republican","Tom","MacArthur",38.9,59.3,365240.0,165090.0,187703.0,-4.3,571390.0,-20.4,-6.19,-26.59],["New Jersey 4th","NJ-04","Republican","Chris","Smith",33.5,63.7,356583.0,146191.0,198859.0,-8.7,547849.0,-30.2,-14.77,-44.97],["New Jersey 5th","NJ-05","Democratic","Josh","Gottheimer",51.1,46.7,364545.0,173963.0,178058.0,-1.7,559815.0,4.4,-1.12,3.28],["New Jersey 6th","NJ-06","Democratic","Frank","Pallone",63.7,34.9,289648.0,162857.0,117679.0,6.9,566466.0,28.8,15.6,44.4],["New Jersey 7th","NJ-07","Republican","Leonard","Lance",43.1,54.1,371592.0,180530.0,176386.0,-0.5,547532.0,-11.0,1.12,-9.88],["New Jersey 8th","NJ-08","Democratic","Albio","Sires",77.0,18.5,229736.0,173834.0,49336.0,26.8,572563.0,58.5,54.19,112.69],["New Jersey 9th","NJ-09","Democratic","Bill","Pascrell",69.7,28.0,276738.0,177954.0,91696.0,14.9,559066.0,41.7,31.17,72.87],["New Jersey 10th","NJ-10","Democratic","Donald","Payne",85.7,11.9,274410.0,233822.0,35111.0,35.8,556646.0,73.8,72.41,146.21],["New Jersey 11th","NJ-11","Republican","Rodney","Frelinghuysen",38.9,58.0,380595.0,182334.0,185696.0,-1.6,564075.0,-19.1,-0.88,-19.98],["New Jersey 12th","NJ-12","Democratic","Bonnie","Watson Coleman",62.9,32.0,314766.0,204661.0,100043.0,16.1,560285.0,30.9,33.24,64.14],["New Mexico 1st","NM-01","Democratic","Michelle","Lujan Grisham",65.1,34.9,285170.0,147250.0,100132.0,8.4,523774.0,30.2,16.52,46.72],["New Mexico 2nd","NM-02","Republican","Steve","Pearce",37.2,62.7,234095.0,93363.0,117211.0,-6.8,508668.0,-25.5,-10.19,-35.69],["New Mexico 3rd","NM-03","Democratic","Ben Ray","Luj\\u00e1n",62.4,37.6,279053.0,144621.0,102323.0,7.5,508065.0,24.8,15.16,39.96],["New York 1st","NY-01","Republican","Lee","Zeldin",41.0,58.9,336437.0,141900.0,183233.0,-7.5,549345.0,-17.9,-12.29,-30.19],["New York 2nd","NY-02","Republican","Pete","King",37.5,62.4,313286.0,137680.0,165908.0,-5.8,546482.0,-24.9,-9.01,-33.91],["New York 3rd","NY-03","Democratic","Tom","Suozzi",52.8,47.2,345275.0,178288.0,156942.0,2.1,553265.0,5.6,6.18,11.78],["New York 4th","NY-04","Democratic","Kathleen","Rice",59.5,40.4,336811.0,179845.0,147469.0,3.8,552258.0,19.1,9.61,28.71],["New York 5th","NY-05","Democratic","Gregory","Meeks",85.4,13.0,246961.0,211667.0,31322.0,36.0,539006.0,72.4,73.03,145.43],["New York 6th","NY-06","Democratic","Grace","Meng",72.1,26.7,207285.0,134970.0,66487.0,15.9,590986.0,45.4,33.04,78.44],["New York 7th","NY-07","Democratic","Nydia","Vel\\u00e1zquez",90.7,9.2,204473.0,177664.0,21198.0,38.2,542978.0,81.5,76.52,158.02],["New York 8th","NY-08","Democratic","Hakeem","Jeffries",93.2,0.0,254930.0,215689.0,34356.0,35.1,550237.0,93.2,71.13,164.33],["New York 9th","NY-09","Democratic","Yvette","Clarke",92.3,0.0,253789.0,211812.0,36600.0,34.2,558573.0,92.3,69.04,161.34],["New York 10th","NY-10","Democratic","Jerry","Nadler",78.0,21.9,261945.0,205114.0,49179.0,29.5,580997.0,56.1,59.53,115.63],["New York 11th","NY-11","Republican","Dan","Donovan",36.7,61.5,248457.0,108807.0,133232.0,-6.2,556859.0,-24.8,-9.83,-34.63],["New York 12th","NY-12","Democratic","Carolyn","Maloney",83.1,16.8,306909.0,255601.0,41383.0,35.0,632656.0,66.3,69.8,136.1],["New York 13th","NY-13","Democratic","Adriano","Espaillat",88.6,6.9,252393.0,232925.0,13727.0,43.3,556707.0,81.7,86.85,168.55],["New York 14th","NY-14","Democratic","Joe","Crowley",82.8,17.1,194923.0,151407.0,38560.0,28.6,569765.0,65.7,57.89,123.59],["New York 15th","NY-15","Democratic","Jos\\u00e9","Serrano",95.2,3.5,191383.0,179454.0,9371.0,43.9,504655.0,91.7,88.87,180.57],["New York 16th","NY-16","Democratic","Eliot","Engel",94.4,0.0,283114.0,212644.0,63590.0,25.9,549246.0,94.4,52.65,147.05],["New York 17th","NY-17","Democratic","Nita","Lowey",99.1,0.0,318220.0,186437.0,122339.0,9.3,531665.0,99.1,20.14,119.24],["New York 18th","NY-18","Democratic","Sean Patrick","Maloney",55.6,44.4,310455.0,146175.0,152137.0,-2.1,536296.0,11.2,-1.92,9.28],["New York 19th","NY-19","Republican","John","Faso",45.7,54.2,315518.0,138019.0,161027.0,-5.0,568027.0,-8.5,-7.29,-15.79],["New York 20th","NY-20","Democratic","Paul","Tonko",67.9,32.1,325088.0,175390.0,131559.0,6.0,565607.0,35.8,13.48,49.28],["New York 21st","NY-21","Republican","Elise","Stefanik",30.1,65.3,279438.0,111760.0,150481.0,-8.5,560156.0,-35.2,-13.86,-49.06],["New York 22nd","NY-22","Republican","Claudia","Tenney",41.0,46.5,289954.0,114016.0,158913.0,-9.3,562336.0,-5.5,-15.48,-20.98],["New York 23rd","NY-23","Republican","Tom","Reed",42.4,57.6,290013.0,115010.0,158155.0,-9.0,561120.0,-15.2,-14.88,-30.08],["New York 24th","NY-24","Republican","John","Katko",39.4,60.5,308574.0,151021.0,139763.0,0.8,553204.0,-21.1,3.65,-17.45],["New York 25th","NY-25","Democratic","Louise","Slaughter",56.1,43.8,329443.0,182896.0,128955.0,7.5,555664.0,12.3,16.37,28.67],["New York 26th","NY-26","Democratic","Brian","Higgins",74.6,25.4,304440.0,175336.0,115558.0,9.2,565026.0,49.2,19.64,68.84],["New York 27th","NY-27","Republican","Chris","Collins",32.8,67.2,346762.0,122102.0,206866.0,-14.0,560034.0,-34.4,-24.44,-58.84],["North Carolina 1st","NC-01","Democratic","G.K.","Butterfield",68.6,29.0,354704.0,239585.0,108100.0,17.8,567106.0,39.6,37.07,76.67],["North Carolina 2nd","NC-02","Republican","George","Holding",43.3,56.7,397167.0,173131.0,211450.0,-6.1,530179.0,-13.4,-9.65,-23.05],["North Carolina 3rd","NC-03","Republican","Walter","Jones",32.8,67.2,328403.0,121070.0,198843.0,-13.3,563610.0,-34.4,-23.68,-58.08],["North Carolina 4th","NC-04","Democratic","David","Price",68.2,31.8,412533.0,281517.0,116383.0,19.6,561968.0,36.4,40.03,76.43],["North Carolina 5th","NC-05","Republican","Virginia","Foxx",41.6,58.4,356490.0,142028.0,204207.0,-10.1,567664.0,-16.8,-17.44,-34.24],["North Carolina 6th","NC-06","Republican","Mark","Walker",40.8,59.2,358941.0,148761.0,201437.0,-8.6,558250.0,-18.4,-14.68,-33.08],["North Carolina 7th","NC-07","Republican","David","Rouzer",39.1,60.9,357908.0,142809.0,206150.0,-10.2,569264.0,-21.8,-17.7,-39.5],["North Carolina 8th","NC-08","Republican","Richard","Hudson",41.2,58.8,331236.0,136233.0,185875.0,-8.8,544179.0,-17.6,-14.99,-32.59],["North Carolina 9th","NC-09","Republican","Robert","Pittenger",41.8,58.2,343915.0,147084.0,186989.0,-7.1,536830.0,-16.4,-11.6,-28.0],["North Carolina 10th","NC-10","Republican","Patrick","McHenry",36.9,63.1,358269.0,130711.0,218369.0,-13.7,568988.0,-26.2,-24.47,-50.67],["North Carolina 11th","NC-11","Republican","Mark","Meadows",35.9,64.1,362420.0,122682.0,229545.0,-16.3,580523.0,-28.2,-29.49,-57.69],["North Carolina 12th","NC-12","Democratic","Alma","Adams",67.0,33.0,356321.0,243736.0,101161.0,19.6,546981.0,34.0,40.01,74.01],["North Carolina 13th","NC-13","Republican","Ted","Budd",43.9,56.1,363763.0,159968.0,194119.0,-5.9,558306.0,-12.2,-9.39,-21.59],["North Dakota At-Large","ND-AL","Republican","Kevin","Cramer",23.7,69.1,337963.0,93758.0,216794.0,-20.9,522720.0,-45.4,-36.41,-81.81],["Ohio 1st","OH-01","Republican","Steve","Chabot",40.8,59.2,361297.0,160988.0,185025.0,-4.6,539642.0,-18.4,-6.65,-25.05],["Ohio 2nd","OH-02","Republican","Brad","Wenstrup",32.8,65.0,354868.0,140773.0,197877.0,-9.5,547568.0,-32.2,-16.09,-48.29],["Ohio 3rd","OH-03","Democratic","Joyce","Beatty",68.6,31.4,314155.0,210445.0,89824.0,19.0,535897.0,37.2,38.4,75.6],["Ohio 4th","OH-04","Republican","Jim","Jordan",32.0,68.0,324648.0,99641.0,208715.0,-18.8,546601.0,-36.0,-33.6,-69.6],["Ohio 5th","OH-05","Republican","Bob","Latta",29.1,70.9,359624.0,124410.0,214653.0,-14.4,549592.0,-41.8,-25.09,-66.89],["Ohio 6th","OH-06","Republican","Bill","Johnson",29.3,70.7,320064.0,85512.0,221852.0,-23.3,561586.0,-41.4,-42.6,-84.0],["Ohio 7th","OH-07","Republican","Bob","Gibbs",29.0,64.0,328938.0,108004.0,205565.0,-16.7,544526.0,-35.0,-29.66,-64.66],["Ohio 8th","OH-08","Republican","Warren","Davidson",27.0,68.8,342785.0,104927.0,223221.0,-19.1,542712.0,-41.8,-34.51,-76.31],["Ohio 9th","OH-09","Democratic","Marcy","Kaptur",68.7,31.3,301655.0,177118.0,110204.0,10.5,552056.0,37.4,22.18,59.58],["Ohio 10th","OH-10","Republican","Mike","Turner",32.7,64.1,348181.0,153323.0,178703.0,-4.9,557295.0,-31.4,-7.29,-38.69],["Ohio 11th","OH-11","Democratic","Marcia","Fudge",80.3,19.7,323301.0,260298.0,55018.0,31.4,548819.0,60.6,63.5,124.1],["Ohio 12th","OH-12","Republican","Pat","Tiberi",29.8,66.6,387279.0,162245.0,205883.0,-7.0,545814.0,-36.8,-11.27,-48.07],["Ohio 13th","OH-13","Democratic","Tim","Ryan",67.7,32.3,319877.0,163553.0,142800.0,2.3,570274.0,35.4,6.49,41.89],["Ohio 14th","OH-14","Republican","David","Joyce",37.4,62.6,369274.0,155602.0,197884.0,-7.1,551969.0,-25.2,-11.45,-36.65],["Ohio 15th","OH-15","Republican","Steve","Stivers",33.8,66.2,355390.0,141654.0,196679.0,-9.2,556070.0,-32.4,-15.48,-47.88],["Ohio 16th","OH-16","Republican","Jim","Renacci",34.7,65.3,368837.0,145672.0,207101.0,-9.8,555332.0,-30.6,-16.65,-47.25],["Oklahoma 1st","OK-01","Republican","Jim","Bridenstine",0.0,100.0,311506.0,101757.0,191343.0,-16.4,558360.0,-100.0,-28.76,-128.76],["Oklahoma 2nd","OK-02","Republican","Markwayne","Mullin",23.2,70.6,271844.0,62022.0,198155.0,-27.3,567268.0,-47.4,-50.08,-97.48],["Oklahoma 3rd","OK-03","Republican","Frank","Lucas",21.7,78.3,293417.0,61179.0,216078.0,-29.0,567154.0,-56.6,-52.79,-109.39],["Oklahoma 4th","OK-04","Republican","Tom","Cole",26.1,69.6,295464.0,83648.0,194160.0,-21.0,568351.0,-43.5,-37.4,-80.9],["Oklahoma 5th","OK-05","Republican","Steve","Russell",36.8,57.1,280761.0,111769.0,149400.0,-8.3,560552.0,-20.3,-13.4,-33.7],["Oregon 1st","OR-01","Democratic","Suzanne","Bonamici",59.6,37.0,382673.0,219412.0,132160.0,11.3,576034.0,22.6,22.8,45.4],["Oregon 2nd","OR-02","Republican","Greg","Walden",28.0,71.7,381561.0,139059.0,215711.0,-11.9,589203.0,-43.7,-20.09,-63.79],["Oregon 3rd","OR-03","Democratic","Earl","Blumenauer",71.8,0.0,399204.0,282346.0,89678.0,24.8,604077.0,71.8,48.26,120.06],["Oregon 4th","OR-04","Democratic","Peter","DeFazio",55.5,39.7,392006.0,180872.0,180318.0,-1.0,613372.0,15.8,0.14,15.94],["Oregon 5th","OR-05","Democratic","Kurt","Schrader",53.5,43.0,373298.0,180417.0,164536.0,1.2,581935.0,10.5,4.25,14.75],["Pennsylvania 1st","PA-01","Democratic","Bob","Brady",82.2,17.8,315605.0,250924.0,57521.0,30.2,535939.0,64.4,61.28,125.68],["Pennsylvania 2nd","PA-02","Democratic","Dwight","Evans",90.2,9.8,369756.0,334322.0,28067.0,41.1,557094.0,80.4,82.83,163.23],["Pennsylvania 3rd","PA-03","Republican","Mike","Kelly",0.0,100.0,324203.0,113563.0,197960.0,-14.7,549101.0,-100.0,-26.03,-126.03],["Pennsylvania 4th","PA-04","Republican","Scott","Perry",33.9,66.1,338687.0,125762.0,198571.0,-12.3,544246.0,-32.2,-21.5,-53.7],["Pennsylvania 5th","PA-05","Republican","Glenn","Thompson",32.8,67.2,314143.0,105138.0,195736.0,-16.2,566600.0,-34.4,-28.84,-63.24],["Pennsylvania 6th","PA-06","Republican","Ryan","Costello",42.7,57.3,368554.0,177639.0,175340.0,-0.8,539084.0,-14.6,0.62,-13.98],["Pennsylvania 7th","PA-07","Republican","Pat","Meehan",40.5,59.5,386339.0,190599.0,181455.0,0.1,541045.0,-19.0,2.37,-16.63],["Pennsylvania 8th","PA-08","Republican","Brian","Fitzpatrick",45.5,54.5,387025.0,185685.0,186607.0,-1.2,542944.0,-9.0,-0.24,-9.24],["Pennsylvania 9th","PA-09","Republican","Bill","Shuster",36.7,63.3,305937.0,83263.0,213383.0,-23.0,556989.0,-26.6,-42.53,-69.13],["Pennsylvania 10th","PA-10","Republican","Tom","Marino",29.8,70.2,308952.0,93240.0,204114.0,-19.8,553619.0,-40.4,-35.89,-76.29],["Pennsylvania 11th","PA-11","Republican","Lou","Barletta",36.3,63.7,319035.0,115480.0,191473.0,-13.5,559032.0,-27.4,-23.82,-51.22],["Pennsylvania 12th","PA-12","Republican","Keith","Rothfus",38.2,61.8,363139.0,137482.0,213003.0,-11.9,558549.0,-23.6,-20.8,-44.4],["Pennsylvania 13th","PA-13","Democratic","Brendan","Boyle",100.0,0.0,332645.0,217268.0,105558.0,16.2,542293.0,100.0,33.58,133.58],["Pennsylvania 14th","PA-14","Democratic","Mike","Doyle",74.4,25.6,346773.0,231552.0,107099.0,17.3,576561.0,48.8,35.89,84.69],["Pennsylvania 15th","PA-15","Republican","Charlie","Dent",38.0,58.4,334869.0,148080.0,173597.0,-5.1,545594.0,-20.4,-7.62,-28.02],["Pennsylvania 16th","PA-16","Republican","Lloyd","Smucker",42.9,53.8,317019.0,140186.0,161763.0,-4.7,526440.0,-10.9,-6.81,-17.71],["Pennsylvania 17th","PA-17","Democratic","Matt","Cartwright",53.8,46.2,306641.0,132702.0,163730.0,-6.3,554815.0,7.6,-10.12,-2.52],["Pennsylvania 18th","PA-18","Republican","Tim","Murphy",0.0,100.0,370498.0,142705.0,215102.0,-11.2,560279.0,-100.0,-19.54,-119.54],["Rhode Island 1st","RI-01","Democratic","David","Cicilline",64.5,35.1,216116.0,130682.0,75510.0,12.3,412614.0,29.4,25.53,54.93],["Rhode Island 2nd","RI-02","Democratic","Jim","Langevin",58.1,30.7,238589.0,121843.0,105033.0,2.6,415997.0,27.4,7.05,34.45],["South Carolina 1st","SC-01","Republican","Mark","Sanford",36.8,58.6,333021.0,134685.0,178052.0,-8.0,501866.0,-21.8,-13.02,-34.82],["South Carolina 2nd","SC-02","Republican","Joe","Wilson",35.9,60.2,312625.0,120591.0,175985.0,-10.5,504664.0,-24.3,-17.72,-42.02],["South Carolina 3rd","SC-03","Republican","Jeff","Duncan",27.1,72.8,284348.0,82527.0,190540.0,-20.9,510519.0,-45.7,-37.99,-83.69],["South Carolina 4th","SC-04","Republican","Trey","Gowdy",31.0,67.2,301747.0,103975.0,181634.0,-14.7,501815.0,-36.2,-25.74,-61.94],["South Carolina 5th","SC-05","Republican","Mick","Mulvaney",38.7,59.2,306200.0,118791.0,175391.0,-10.7,498138.0,-20.5,-18.48,-38.98],["South Carolina 6th","SC-06","Democratic","James","Clyburn",70.1,27.6,266848.0,178159.0,80741.0,17.7,514995.0,42.5,36.51,79.01],["South Carolina 7th","SC-07","Republican","Tom","Rice",38.9,61.0,298237.0,116645.0,173046.0,-10.8,512893.0,-22.1,-18.91,-41.01],["South Dakota At-Large","SD-AL","Republican","Kristi","Noem",35.9,64.1,370047.0,117442.0,227701.0,-17.1,611383.0,-28.2,-29.8,-58.0],["Tennessee 1st","TN-01","Republican","Phil","Roe",15.4,78.4,265493.0,52240.0,203668.0,-30.7,557064.0,-63.0,-57.04,-120.04],["Tennessee 2nd","TN-02","Republican","John","Duncan",24.4,75.6,290193.0,86214.0,188956.0,-19.8,549646.0,-51.2,-35.4,-86.6],["Tennessee 3rd","TN-03","Republican","Chuck","Fleischmann",28.8,66.4,276457.0,83524.0,180932.0,-19.5,550020.0,-37.6,-35.23,-72.83],["Tennessee 4th","TN-04","Republican","Scott","DesJarlais",35.0,65.0,276582.0,75831.0,189613.0,-22.5,534051.0,-30.0,-41.14,-71.14],["Tennessee 5th","TN-05","Democratic","Jim","Cooper",62.6,37.4,276959.0,156608.0,105776.0,8.6,547011.0,25.2,18.35,43.55],["Tennessee 6th","TN-06","Republican","Diane","Black",21.8,71.1,297967.0,70549.0,216461.0,-26.5,539694.0,-49.3,-48.97,-98.27],["Tennessee 7th","TN-07","Republican","Marsha","Blackburn",23.5,72.2,291561.0,82313.0,196848.0,-21.6,522321.0,-48.7,-39.28,-87.98],["Tennessee 8th","TN-08","Republican","David","Kustoff",25.1,68.8,296672.0,91025.0,196702.0,-19.5,533039.0,-43.7,-35.62,-79.32],["Tennessee 9th","TN-09","Democratic","Steve","Cohen",78.7,18.9,222353.0,172391.0,43970.0,28.6,517258.0,59.8,57.76,117.56],["Texas 1st","TX-01","Republican","Louie","Gohmert",24.1,73.9,262492.0,66389.0,189604.0,-25.2,523109.0,-49.8,-46.94,-96.74],["Texas 2nd","TX-02","Republican","Ted","Poe",36.0,60.6,277873.0,119659.0,145530.0,-6.0,535783.0,-24.6,-9.31,-33.91],["Texas 3rd","TX-03","Republican","Sam","Johnson",34.6,61.2,318536.0,129384.0,174561.0,-8.5,501350.0,-26.6,-14.18,-40.78],["Texas 4th","TX-04","Republican","John","Ratcliffe",0.0,88.0,279188.0,60841.0,210587.0,-28.7,526203.0,-88.0,-53.64,-141.64],["Texas 5th","TX-05","Republican","Jeb","Hensarling",0.0,80.6,232735.0,79759.0,145841.0,-15.8,503906.0,-80.6,-28.39,-108.99],["Texas 6th","TX-06","Republican","Joe","Barton",39.0,58.3,274848.0,115272.0,148945.0,-7.5,499013.0,-19.3,-12.25,-31.55],["Texas 7th","TX-07","Republican","John","Culberson",43.8,56.2,257308.0,124722.0,121204.0,-0.4,519856.0,-12.4,1.37,-11.03],["Texas 8th","TX-08","Republican","Kevin","Brady",0.0,100.0,295099.0,70532.0,214605.0,-26.4,513910.0,-100.0,-48.82,-148.82],["Texas 9th","TX-09","Democratic","Al","Green",80.6,19.4,191042.0,151559.0,34447.0,30.4,499324.0,61.2,61.3,122.5],["Texas 10th","TX-10","Republican","Michael","McCaul",38.4,57.3,315133.0,135984.0,164912.0,-5.9,507359.0,-18.9,-9.18,-28.08],["Texas 11th","TX-11","Republican","Mike","Conaway",0.0,89.5,248860.0,47468.0,193620.0,-31.4,537073.0,-89.5,-58.73,-148.23],["Texas 12th","TX-12","Republican","Kay","Granger",26.9,69.4,282691.0,92549.0,177939.0,-16.9,514594.0,-42.5,-30.21,-72.71],["Texas 13th","TX-13","Republican","Mac","Thornberry",0.0,90.0,238846.0,40253.0,190838.0,-33.7,518568.0,-90.0,-63.05,-153.05],["Texas 14th","TX-14","Republican","Randy","Weber",38.1,61.9,263381.0,101228.0,153191.0,-11.3,524374.0,-23.8,-19.73,-43.53],["Texas 15th","TX-15","Democratic","Vicente","Gonz\\u00e1lez",57.3,37.7,184358.0,104454.0,73689.0,7.5,466070.0,19.6,16.69,36.29],["Texas 16th","TX-16","Democratic","Beto","O'Rourke",85.7,0.0,192692.0,130784.0,52334.0,20.3,489548.0,85.7,40.71,126.41],["Texas 17th","TX-17","Republican","Bill","Flores",35.2,60.8,247625.0,96156.0,139415.0,-10.3,534916.0,-25.6,-17.47,-43.07],["Texas 18th","TX-18","Democratic","Shelia","Jackson Lee",73.5,23.6,205514.0,157117.0,41011.0,28.2,492316.0,49.9,56.5,106.4],["Texas 19th","TX-19","Republican","Jodey","Arrington",0.0,86.7,228008.0,53519.0,165384.0,-26.7,524057.0,-86.7,-49.06,-135.76],["Texas 20th","TX-20","Democratic","Joaquin","Castro",79.7,0.0,216952.0,132363.0,74386.0,12.9,503169.0,79.7,26.72,106.42],["Texas 21st","TX-21","Republican","Lamar","Smith",36.4,57.0,358985.0,152528.0,188335.0,-6.4,539982.0,-20.6,-9.97,-30.57],["Texas 22nd","TX-22","Republican","Pete","Olson",40.5,59.5,306777.0,135525.0,159717.0,-5.2,494113.0,-19.0,-7.89,-26.89],["Texas 23rd","TX-23","Republican","Will","Hurd",47.0,48.3,231365.0,115154.0,107276.0,0.7,495646.0,-1.3,3.41,2.11],["Texas 24th","TX-24","Republican","Kenny","Marchant",39.3,56.2,276137.0,122872.0,140128.0,-4.4,523431.0,-16.9,-6.25,-23.15],["Texas 25th","TX-25","Republican","Roger","Williams",37.7,58.3,313111.0,125949.0,172476.0,-8.9,536383.0,-20.6,-14.86,-35.46],["Texas 26th","TX-26","Republican","Michael","Burgess",29.6,66.4,318854.0,109536.0,194033.0,-15.0,496578.0,-36.8,-26.5,-63.3],["Texas 27th","TX-27","Republican","Blake","Farenthold",38.3,61.7,234367.0,85589.0,140787.0,-13.3,520958.0,-23.4,-23.55,-46.95],["Texas 28th","TX-28","Democratic","Henry","Cuellar",66.2,31.3,188600.0,110023.0,72518.0,9.2,477030.0,34.9,19.89,54.79],["Texas 29th","TX-29","Democratic","Gene","Green",72.5,24.0,133642.0,95027.0,34011.0,22.5,470400.0,48.5,45.66,94.16],["Texas 30th","TX-30","Democratic","Eddie Bernice","Johnson",81.6,15.1,220711.0,174528.0,40333.0,30.1,501433.0,66.5,60.8,127.3],["Texas 31st","TX-31","Republican","John","Carter",36.5,58.4,287510.0,117181.0,153823.0,-7.9,500711.0,-21.9,-12.74,-34.64],["Texas 32nd","TX-32","Republican","Pete","Sessions",0.0,71.1,278080.0,134895.0,129701.0,-0.1,527032.0,-71.1,1.87,-69.23],["Texas 33rd","TX-33","Democratic","Marc","Veasey",73.7,26.3,129653.0,94513.0,30787.0,24.3,475960.0,47.4,49.15,96.55],["Texas 34th","TX-34","Democratic","Filemon","Vela",62.7,37.3,171969.0,101796.0,64767.0,10.0,476984.0,25.4,21.53,46.93],["Texas 35th","TX-35","Democratic","Lloyd","Doggett",63.1,31.6,200576.0,128535.0,61136.0,16.7,490339.0,31.5,33.6,65.1],["Texas 36th","TX-36","Republican","Brian","Babin",0.0,88.6,254447.0,64225.0,183176.0,-25.2,518256.0,-88.6,-46.75,-135.35],["Utah 1st","UT-01","Republican","Rob","Bishop",26.4,65.9,280442.0,62733.0,139503.0,-20.1,467487.0,-39.5,-27.37,-66.87],["Utah 2nd","UT-02","Republican","Chris","Stewart",33.9,61.6,283699.0,90686.0,130525.0,-10.1,484976.0,-27.7,-14.04,-41.74],["Utah 3rd","UT-03","Republican","Jason","Chaffetz",26.5,73.5,289923.0,67461.0,136782.0,-18.1,474644.0,-47.0,-23.91,-70.91],["Utah 4th","UT-04","Republican","Mia","Love",41.3,53.8,277311.0,89796.0,108421.0,-5.8,465748.0,-12.5,-6.72,-19.22],["Vermont At-Large","VT-AL","Democratic","Peter","Welch",89.5,0.0,315067.0,178573.0,95369.0,14.1,496508.0,89.5,26.41,115.91],["Virginia 1st","VA-01","Republican","Rob","Wittman",36.6,59.9,395289.0,162931.0,211991.0,-7.7,543207.0,-23.3,-12.41,-35.71],["Virginia 2nd","VA-02","Republican","Scott","Taylor",38.5,61.3,321068.0,145762.0,156694.0,-2.9,561599.0,-22.8,-3.4,-26.2],["Virginia 3rd","VA-03","Democratic","Bobby","Scott",66.7,33.1,323422.0,205746.0,103064.0,15.5,551449.0,33.6,31.75,65.35],["Virginia 4th","VA-04","Democratic","Donald","McEachin",57.7,42.0,362532.0,212677.0,134676.0,10.1,563650.0,15.7,21.52,37.22],["Virginia 5th","VA-05","Republican","Tom","Garrett",41.6,58.2,365403.0,154665.0,195190.0,-6.9,574403.0,-16.6,-11.09,-27.69],["Virginia 6th","VA-06","Republican","Bob","Goodlatte",33.1,66.6,345500.0,120596.0,206303.0,-14.2,572758.0,-33.5,-24.81,-58.31],["Virginia 7th","VA-07","Republican","Dave","Brat",42.2,57.5,392168.0,172544.0,198032.0,-4.6,544939.0,-15.3,-6.5,-21.8],["Virginia 8th","VA-08","Democratic","Don","Beyer",68.4,27.3,367885.0,270415.0,76854.0,26.8,578936.0,41.1,52.61,93.71],["Virginia 9th","VA-09","Republican","Morgan","Griffith",28.3,68.6,316740.0,86463.0,217837.0,-22.7,584866.0,-40.3,-41.48,-81.78],["Virginia 10th","VA-10","Republican","Barbara","Comstock",46.9,52.7,403821.0,210692.0,170580.0,4.1,522584.0,-5.8,9.93,4.13],["Virginia 11th","VA-11","Democratic","Gerry","Connolly",87.9,0.0,357054.0,238982.0,98222.0,19.8,548956.0,87.9,39.42,127.32],["Washington 1st","WA-01","Democratic","Suzan","DelBene",55.4,44.6,349064.0,188952.0,132109.0,7.7,507779.0,10.8,16.28,27.08],["Washington 2nd","WA-02","Democratic","Rick","Larsen",64.0,36.0,326462.0,185821.0,113670.0,10.9,521526.0,28.0,22.1,50.1],["Washington 3rd","WA-03","Republican","Jaime","Herrera Beutler",38.2,61.8,315150.0,134009.0,157359.0,-5.1,503246.0,-23.6,-7.41,-31.01],["Washington 4th","WA-04","Republican","Dan","Newhouse",0.0,100.0,242668.0,85083.0,140560.0,-13.4,474350.0,-100.0,-22.86,-122.86],["Washington 5th","WA-05","Republican","Cathy","McMorris Rodgers",40.4,59.6,319635.0,125112.0,166765.0,-8.2,521176.0,-19.2,-13.03,-32.23],["Washington 6th","WA-06","Democratic","Derek","Kilmer",61.5,38.5,332992.0,172596.0,131449.0,5.7,529928.0,23.0,12.36,35.36],["Washington 7th","WA-07","Democratic","Pramila","Jayapal",100.0,0.0,415693.0,341412.0,50615.0,36.0,565602.0,100.0,69.95,169.95],["Washington 8th","WA-08","Republican","Dave","Reichert",39.8,60.2,321002.0,153167.0,143403.0,0.5,498830.0,-20.4,3.04,-17.36],["Washington 9th","WA-09","Democratic","Adam","Smith",72.9,27.1,291192.0,205193.0,67956.0,24.0,517163.0,45.8,47.13,92.93],["Washington 10th","WA-10","Democratic","Denny","Heck",58.7,41.3,295356.0,151373.0,117861.0,5.1,503586.0,17.4,11.35,28.75],["West Virginia 1st","WV-01","Republican","David","McKinley",31.0,69.0,243894.0,64384.0,165934.0,-23.2,494743.0,-38.0,-41.64,-79.64],["West Virginia 2nd","WV-02","Republican","Alex","Mooney",41.8,58.2,250267.0,73487.0,164674.0,-20.3,484668.0,-16.4,-36.44,-52.84],["West Virginia 3rd","WV-03","Republican","Evan","Jenkins",24.0,67.9,218890.0,50923.0,158763.0,-26.8,486165.0,-43.9,-49.27,-93.17],["Wisconsin 1st","WI-01","Republican","Paul","Ryan",30.2,64.9,355961.0,150436.0,187372.0,-6.6,534871.0,-34.7,-10.38,-45.08],["Wisconsin 2nd","WI-02","Democratic","Mark","Pocan",68.7,31.2,412803.0,271507.0,119608.0,18.3,549282.0,37.5,36.8,74.3],["Wisconsin 3rd","WI-03","Democratic","Ron","Kind",98.9,0.0,359555.0,160999.0,177172.0,-3.5,553645.0,98.9,-4.5,94.4],["Wisconsin 4th","WI-04","Democratic","Gwen","Moore",76.7,0.0,308575.0,228226.0,67287.0,26.1,524444.0,76.7,52.16,128.86],["Wisconsin 5th","WI-05","Republican","Jim","Sensenbrenner",29.3,66.7,399261.0,148900.0,229325.0,-11.7,548075.0,-37.4,-20.14,-57.54],["Wisconsin 6th","WI-06","Republican","Glenn","Grothman",37.3,57.2,365442.0,141917.0,203433.0,-10.0,550929.0,-19.9,-16.83,-36.73],["Wisconsin 7th","WI-07","Republican","Sean","Duffy",38.3,61.7,369841.0,137874.0,213467.0,-11.9,547463.0,-23.4,-20.44,-43.84],["Wisconsin 8th","WI-08","Republican","Mike","Gallagher",37.3,62.6,369562.0,142677.0,207620.0,-10.4,538785.0,-25.3,-17.57,-42.87],["Wyoming At-Large","WY-AL","Republican","Liz","Cheney",30.0,62.0,255849.0,55973.0,174419.0,-26.8,428224.0,-32.0,-46.3,-78.3]];\n", | |
| " \n", | |
| " var xName = "demlead_pres2016";\n", | |
| " var yName = "demlead_house2016";\n", | |
| " var xLabel = "Democratic Lead, President 2016 (%)";\n", | |
| " var yLabel = "Democratic Lead, House 2016 (%)";\n", | |
| " \n", | |
| " var min_x = d3.min(data, function(d) { return +d[keys[xName]]; });\n", | |
| " var max_x = d3.max(data, function(d) { return +d[keys[xName]]; });\n", | |
| " var min_y = d3.min(data, function(d) { return +d[keys[yName]]; });\n", | |
| " var max_y = d3.max(data, function(d) { return +d[keys[yName]]; });\n", | |
| " var max = d3.max([min_x, min_y, max_x, max_y].map(Math.abs));\n", | |
| "\n", | |
| " var x = d3.scale.linear()\n", | |
| " .domain([-1.2*max, 1.2*max])\n", | |
| " .range([ 0, width ]);\n", | |
| "\n", | |
| " var y = d3.scale.linear()\n", | |
| " //.domain([min_y - Math.abs(0.2*min_y), max_y + Math.abs(0.2*max_y)])\n", | |
| " .domain([-1.2*max, 1.2*max])\n", | |
| " .range([ height, 0 ]);\n", | |
| "\n", | |
| " var xAxis = d3.svg.axis()\n", | |
| " .scale(x)\n", | |
| " .orient("bottom")\n", | |
| " .ticks(6) //5\n", | |
| " .tickSize(-height);\n", | |
| "\n", | |
| " var yAxis = d3.svg.axis()\n", | |
| " .scale(y)\n", | |
| " .orient("left")\n", | |
| " .ticks(6) //5\n", | |
| " .tickSize(-width); //-width\n", | |
| "\n", | |
| " var zoom = d3.behavior.zoom()\n", | |
| " .x(x)\n", | |
| " .y(y)\n", | |
| " .scaleExtent([1, 10])\n", | |
| " .center([width / 2, height / 2])\n", | |
| " .size([width, height])\n", | |
| " .on("zoom", zoomed);\n", | |
| "\n", | |
| " var svg = d3.select("body").append("svg")\n", | |
| " .attr("width", width + margin.left + margin.right)\n", | |
| " .attr("height", height + margin.top + margin.bottom)\n", | |
| " .append("g")\n", | |
| " .attr("transform", "translate(" + margin.left + "," + margin.top + ")")\n", | |
| " .call(zoom);\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/28723551\n", | |
| " //Create clip, then apply it to each dot\n", | |
| " var clip = svg.append("defs").append("svg:clipPath")\n", | |
| " .attr("id", "clip")\n", | |
| " .append("svg:rect")\n", | |
| " .attr("id", "clip-rect")\n", | |
| " .attr("x", "0") //\n", | |
| " .attr("y", "0") //\n", | |
| " .attr('width', width)\n", | |
| " .attr('height', height);\n", | |
| "\n", | |
| " svg.append("rect")\n", | |
| " .attr("width", width)\n", | |
| " .attr("height", height);\n", | |
| "\n", | |
| " svg.append("g")\n", | |
| " .attr("class", "x axis")\n", | |
| " .attr("transform", "translate(0," + height + ")")\n", | |
| " .call(xAxis);\n", | |
| "\n", | |
| " svg.append("g")\n", | |
| " .attr("class", "y axis")\n", | |
| " .call(yAxis);\n", | |
| "\n", | |
| " d3.selectAll('g.tick')\n", | |
| " .filter(function(d){ return d==0;} )\n", | |
| " .select('line') \n", | |
| " .attr('id', 'main-tick');\n", | |
| "\n", | |
| " // Tooltips\n", | |
| " var div = d3.select("body")\n", | |
| " .append("div") \n", | |
| " .attr("class", "tooltip")\n", | |
| " .style("opacity", 0); \n", | |
| "\n", | |
| " svg.selectAll(".dot")\n", | |
| " .data(data)\n", | |
| " .enter().append("circle")\n", | |
| " .attr("class", "dot")\n", | |
| " .attr("clip-path", "url(#clip)") //add the clip to each dot\n", | |
| " .attr("r", 4.0) //3.5 4.5 3*zoom.scale()\n", | |
| " .attr("cx", function(d) { return x(+d[keys[xName]]); })\n", | |
| " .attr("cy", function(d) { return y(+d[keys[yName]]); })\n", | |
| " .style("fill", 'red' ) \n", | |
| " .attr('fill-opacity', 0.6)\n", | |
| " .on("mouseover", function(d) { drawTooltip(d); })\n", | |
| " .on("mouseout", function() {\n", | |
| " div.style("opacity", 0);\n", | |
| " });\n", | |
| "\n", | |
| " svg.append("text")\n", | |
| " .attr("class", "x label")\n", | |
| " .attr("text-anchor", "middle")\n", | |
| " .attr("x", width/2)\n", | |
| " .attr("y", height + 30)\n", | |
| " .text("Democratic Lead, President 2016 (%)");\n", | |
| "\n", | |
| " svg.append("text")\n", | |
| " .attr("class", "y label")\n", | |
| " .attr("text-anchor", "middle")\n", | |
| " .attr("x", -height/2)\n", | |
| " .attr("y", -30) //-30\n", | |
| " .attr("transform", "rotate(-90)")\n", | |
| " .text("Democratic Lead, House 2016 (%)");\n", | |
| "\n", | |
| " d3.selectAll("button[data-zoom]")\n", | |
| " .on("click", clicked);\n", | |
| "\n", | |
| " function zoomed() {\n", | |
| " svg.select(".x.axis").call(xAxis);\n", | |
| " svg.select(".y.axis").call(yAxis);\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/37573228\n", | |
| " svg.selectAll(".dot")\n", | |
| " //.attr("r", 3*zoom.scale())\n", | |
| " .attr("cx", function (d) {\n", | |
| " return x(+d[keys[xName]]);\n", | |
| " })\n", | |
| " .attr("cy", function (d) {\n", | |
| " return y(+d[keys[yName]]);\n", | |
| " });\n", | |
| "\n", | |
| " d3.selectAll('g.tick')\n", | |
| " .filter(function(d){ return d==0;} )\n", | |
| " .select('line') //grab the tick line\n", | |
| " .attr('id', 'main-tick');\n", | |
| " }\n", | |
| "\n", | |
| " function clicked() {\n", | |
| " svg.call(zoom.event); // https://github.com/mbostock/d3/issues/2387\n", | |
| "\n", | |
| " // Record the coordinates (in data space) of the center (in screen space).\n", | |
| " var center0 = zoom.center(), translate0 = zoom.translate(), coordinates0 = coordinates(center0);\n", | |
| " zoom.scale(zoom.scale() * Math.pow(2, +this.getAttribute("data-zoom")));\n", | |
| "\n", | |
| " // Translate back to the center.\n", | |
| " var center1 = point(coordinates0);\n", | |
| " zoom.translate([translate0[0] + center0[0] - center1[0], translate0[1] + center0[1] - center1[1]]);\n", | |
| "\n", | |
| " svg.transition().duration(750).call(zoom.event);\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " function coordinates(point) {\n", | |
| " var scale = zoom.scale(), translate = zoom.translate();\n", | |
| " return [(point[0] - translate[0]) / scale, (point[1] - translate[1]) / scale];\n", | |
| " }\n", | |
| "\n", | |
| " function point(coordinates) {\n", | |
| " var scale = zoom.scale(), translate = zoom.translate();\n", | |
| " return [coordinates[0] * scale + translate[0], coordinates[1] * scale + translate[1]];\n", | |
| " }\n", | |
| "\n", | |
| " function drawTooltip(d) {\n", | |
| " div.style("opacity", 1.0);\n", | |
| " div.html(\n", | |
| " '<b>District:</b> '+ d[keys.code] + \n", | |
| " '<br><b>Name:</b> ' + d[keys.first] + ' ' + d[keys.last] + \n", | |
| " '<br><b>President:</b> ' + d[keys.demlead_pres2016] + "%" + \n", | |
| " '<br><b>House:</b> ' + d[keys.demlead_house2016] +"%" \n", | |
| ")\n", | |
| " .style("left", (d3.event.pageX) + "px")\n", | |
| " .style("top", (d3.event.pageY ) + "px");\n", | |
| " }\n", | |
| "\n", | |
| " </script>\n", | |
| " </body>\n", | |
| " </html>\n", | |
| " \" style=\"width: 960px; height: 600px; display:block; width: 100%; margin: 25px auto; border: none\"></iframe>" | |
| ], | |
| "text/plain": [ | |
| "<IPython.core.display.HTML object>" | |
| ] | |
| }, | |
| "execution_count": 48, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "tooltip = '''\n", | |
| " '<b>District:</b> '+ d[keys.code] + \n", | |
| " '<br><b>Name:</b> ' + d[keys.first] + ' ' + d[keys.last] + \n", | |
| " '<br><b>President:</b> ' + d[keys.demlead_pres2016] + \"%\" + \n", | |
| " '<br><b>House:</b> ' + d[keys.demlead_house2016] +\"%\" \n", | |
| "''' \n", | |
| "\n", | |
| "settings = {\"x_label\": \"Democratic Lead, President 2016 (%)\", \n", | |
| " \"y_label\": \"Democratic Lead, House 2016 (%)\",\n", | |
| " \"x\": 'demlead_pres2016' ,\n", | |
| " \"y\": 'demlead_house2016', \n", | |
| " \"tooltip\": tooltip}\n", | |
| "\n", | |
| "interactive_scatter(house_df, settings=settings)\n" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "## Close House Seats for Democrats\n", | |
| "\n", | |
| "The first two numeric columns below show the Democrat's lead in the House race and Presidential race for each district. When the sum column of these two values is negative it indicates a district that had a larger margin for Trump than for the Democrat that was elected. \n", | |
| "\n", | |
| "Interestingly, Minnesota had a number of close seats, including the 7th district with a 35 point spread between Collin Peterson and Trump. Someone needs to ask these guys in Minnesota how they appealed to Trump voters ([Peterson](https://en.wikipedia.org/wiki/Collin_Peterson) is a Blue Dog Democrat, and both [Nolan](https://en.wikipedia.org/wiki/Rick_Nolan) and [Walz](https://en.wikipedia.org/wiki/Rick_Nolan) are moderate Democrats). I think Walz provides an especially good template for moderate Democrats to follow in contentious districts. \n", | |
| "\n", | |
| "I also include the [Partisan Voter Index](https://en.wikipedia.org/wiki/Cook_Partisan_Voting_Index) (pvi_2016), which combines the past two elections into an index of how the district votes relative to the country. Currently, the table is sorted by the 'sum' column, but Bokeh outputs interactive tables so feel free to sort the columns by any of the indicators. " | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 58, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<iframe srcdoc=\"\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset="utf-8">\n", | |
| " <style>\n", | |
| "\n", | |
| " /*\n", | |
| " body {\n", | |
| " width: 800px;\n", | |
| " }*/\n", | |
| "\n", | |
| " table {\n", | |
| " font-size: 12px;\n", | |
| " border-collapse: collapse;\n", | |
| " border-top: 1px solid #ddd;\n", | |
| " border-right: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " th {\n", | |
| " padding: 10px;\n", | |
| " cursor: pointer;\n", | |
| " background-color: #f2f2f2;\n", | |
| " }\n", | |
| "\n", | |
| " th, td {\n", | |
| " text-align: left;\n", | |
| " border-bottom: 1px solid #ddd;\n", | |
| " border-left: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " td {\n", | |
| " padding: 5px 8px;\n", | |
| " }\n", | |
| "\n", | |
| " tr:nth-child(even) {\n", | |
| " background-color: #f9f9f9;\n", | |
| " }\n", | |
| "\n", | |
| " tr:hover {\n", | |
| " background-color: #F0F8FF; /*#f9f9f9;*/\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| "\n", | |
| " <body>\n", | |
| "\n", | |
| " <div id ="tableInsert"></div>\n", | |
| "\n", | |
| " <script>\n", | |
| " //http://stackoverflow.com/questions/14267781/sorting-html-table-with-javascript\n", | |
| "\n", | |
| " function sortTable(table, col, reverse) {\n", | |
| " var tb = table.tBodies[0], \n", | |
| " tr = Array.prototype.slice.call(tb.rows, 0), // put rows into array\n", | |
| " i;\n", | |
| "\n", | |
| " reverse = -((+reverse) || -1);\n", | |
| " tr = tr.sort(function (a, b) { \n", | |
| " var first = a.cells[col].textContent.trim();\n", | |
| " var second = b.cells[col].textContent.trim();\n", | |
| "\n", | |
| " if (isNumeric(first) && isNumeric(second)) { \n", | |
| " return reverse * (Number(first) - Number(second));\n", | |
| " } else {\n", | |
| " return reverse * first.localeCompare(second);\n", | |
| " };\n", | |
| " });\n", | |
| " for(i = 0; i < tr.length; ++i) { // append each row in order\n", | |
| " tb.appendChild(tr[i]);\n", | |
| " }\n", | |
| " }\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/18082\n", | |
| " function isNumeric(n) {\n", | |
| " return !isNaN(parseFloat(n)) && isFinite(n);\n", | |
| " }\n", | |
| "\n", | |
| " function makeSortable(table) {\n", | |
| " var th = table.tHead, i;\n", | |
| " th && (th = th.rows[0]) && (th = th.cells);\n", | |
| " if (th) i = th.length;\n", | |
| " else return; // if no `<thead>` then do nothing\n", | |
| " while (--i >= 0) (function (i) {\n", | |
| " var dir = 1;\n", | |
| " th[i].addEventListener('click', function () {sortTable(table, i, (dir = 1 - dir))});\n", | |
| " }(i));\n", | |
| " }\n", | |
| "\n", | |
| " function makeAllSortable(parent) {\n", | |
| " parent = parent || document.body;\n", | |
| " var t = parent.getElementsByTagName('table'), i = t.length;\n", | |
| " while (--i >= 0) makeSortable(t[i]);\n", | |
| " }\n", | |
| "\n", | |
| " function addTable() {\n", | |
| " var tableDiv = document.getElementById("tableInsert")\n", | |
| " var table = document.createElement('table')\n", | |
| " var tableHead = document.createElement('thead')\n", | |
| " var tableBody = document.createElement('tbody')\n", | |
| "\n", | |
| " table.appendChild(tableHead)\n", | |
| " table.appendChild(tableBody);\n", | |
| "\n", | |
| " var heading = ["district", "party", "first", "last", "demlead_house2016", "demlead_pres2016", "sum", "pvi_2016"];\n", | |
| " var data = [["Minnesota 7th","Democratic","Collin","Peterson",5.1,-30.76,-25.66,-17.7],["Minnesota 8th","Democratic","Rick","Nolan",0.6,-15.62,-15.02,-9.5],["Minnesota 1st","Democratic","Tim","Walz",0.7,-14.91,-14.21,-9.2],["Pennsylvania 17th","Democratic","Matt","Cartwright",7.6,-10.12,-2.52,-6.3],["New Hampshire 1st","Democratic","Carol","Shea-Porter",1.4,-1.59,-0.19,-2.0],["Nevada 3rd","Democratic","Jacky","Rosen",1.2,-1.0,0.2,-1.6],["New Jersey 5th","Democratic","Josh","Gottheimer",4.4,-1.12,3.28,-1.7],["Iowa 2nd","Democratic","Dave","Loebsack",7.5,-4.1,3.4,-3.3],["Arizona 1st","Democratic","Tom","O'Halleran",7.3,-1.07,6.23,-1.7],["New Hampshire 2nd","Democratic","Annie","Kuster",4.4,2.4,6.8,0.2],["Florida 13th","Democratic","Charlie","Crist",3.8,3.2,7.0,0.6],["Nevada 4th","Democratic","Ruben","Kihuen",4.0,4.94,8.94,1.5],["New York 18th","Democratic","Sean Patrick","Maloney",11.2,-1.92,9.28,-2.1],["Florida 7th","Democratic","Stephanie","Murphy",3.0,7.29,10.29,2.7],["New York 3rd","Democratic","Tom","Suozzi",5.6,6.18,11.78,2.1],["California 7th","Democratic","Ami","Bera",2.4,11.45,13.85,5.0],["Oregon 5th","Democratic","Kurt","Schrader",10.5,4.25,14.75,1.2],["Oregon 4th","Democratic","Peter","DeFazio",15.8,0.14,15.94,-1.0],["Illinois 17th","Democratic","Cheri","Bustos",20.6,-0.7,19.9,-1.5],["Connecticut 5th","Democratic","Elizabeth","Esty",16.0,4.1,20.1,1.0],["Delaware At-Large","Democratic","Lisa","Blunt Rochester",14.5,11.43,25.93,4.9],["California 24th","Democratic","Salud","Carbajal",6.8,20.21,27.01,9.7],["Washington 1st","Democratic","Suzan","DelBene",10.8,16.28,27.08,7.7],["Colorado 7th","Democratic","Ed","Perlmutter",15.4,12.01,27.41,5.5],["Florida 9th","Democratic","Darren","Soto",15.0,12.91,27.91,5.6],["Michigan 9th","Democratic","Sandy","Levin",20.5,7.73,28.23,2.9],["New York 25th","Democratic","Louise","Slaughter",12.3,16.37,28.67,7.5],["New York 4th","Democratic","Kathleen","Rice",19.1,9.61,28.71,3.8],["Washington 10th","Democratic","Denny","Heck",17.4,11.35,28.75,5.1],["Michigan 5th","Democratic","Dan","Kildee",26.1,4.27,30.37,1.1],["Maine 1st","Democratic","Chellie","Pingree",16.1,14.83,30.93,6.8],["California 3rd","Democratic","John","Garamendi",18.8,12.6,31.4,5.6],["Maryland 6th","Democratic","John","Delaney",15.9,16.1,32.0,7.3],["Connecticut 2nd","Democratic","Joe","Courtney",29.5,2.88,32.38,0.4],["Massachusetts 9th","Democratic","Bill","Keating",22.1,10.72,32.82,4.6],["California 36th","Democratic","Raul","Ruiz",24.2,8.74,32.94,3.5],["California 31st","Democratic","Pete","Aguilar",12.2,21.09,33.29,10.1],["California 9th","Democratic","Jerry","McNerney",14.8,18.57,33.37,8.7],["Florida 22nd","Democratic","Ted","Deutch",17.8,15.74,33.54,6.9],["Missouri 5th","Democratic","Emanuel","Cleaver",20.6,13.48,34.08,6.0],["Georgia 2nd","Democratic","Sanford","Bishop",22.4,11.73,34.13,4.9],["Rhode Island 2nd","Democratic","Jim","Langevin",27.4,7.05,34.45,2.6],["Illinois 10th","Democratic","Brad","Schneider",5.2,29.4,34.6,14.4],["Washington 6th","Democratic","Derek","Kilmer",23.0,12.36,35.36,5.7],["California 52nd","Democratic","Scott","Peters",13.0,22.56,35.56,10.9],["Texas 15th","Democratic","Vicente","Gonz\\u00e1lez",19.6,16.69,36.29,7.5],["Virginia 4th","Democratic","Donald","McEachin",15.7,21.52,37.22,10.1],["California 16th","Democratic","Jim","Costa",16.0,21.59,37.59,10.3],["Arizona 9th","Democratic","Kyrsten","Sinema",21.9,16.22,38.12,7.6],["Illinois 8th","Democratic","Raja","Krishnamoorthi",16.6,21.68,38.28,10.4],["New Mexico 3rd","Democratic","Ben Ray","Luj\\u00e1n",24.8,15.16,39.96,7.5],["Colorado 2nd","Democratic","Jared","Polis",19.7,21.26,40.96,10.5],["Florida 14th","Democratic","Kathy","Castor",23.6,18.18,41.78,8.3],["Ohio 13th","Democratic","Tim","Ryan",35.4,6.49,41.89,2.3],["Kentucky 3rd","Democratic","John","Yarmuth",27.0,14.95,41.95,6.8],["Florida 23rd","Democratic","Debbie","Wasserman Schultz",16.2,26.09,42.29,12.2],["California 26th","Democratic","Julia","Brownley",20.8,21.84,42.64,10.5],["Connecticut 4th","Democratic","Jim","Himes",19.8,23.01,42.81,10.9],["Tennessee 5th","Democratic","Jim","Cooper",25.2,18.35,43.55,8.6],["Illinois 11th","Democratic","Bill","Foster",20.8,23.43,44.23,11.3],["New Jersey 6th","Democratic","Frank","Pallone",28.8,15.6,44.4,6.9],["Oregon 1st","Democratic","Suzanne","Bonamici",22.6,22.8,45.4,11.3],["New Mexico 1st","Democratic","Michelle","Lujan Grisham",30.2,16.52,46.72,8.4],["Texas 34th","Democratic","Filemon","Vela",25.4,21.53,46.93,10.0],["Florida 21st","Democratic","Lois","Frankel",27.6,19.55,47.15,8.9],["Indiana 7th","Democratic","Andr\\u00e9","Carson",24.3,22.85,47.15,10.9],["New Jersey 1st","Democratic","Donald","Norcross",23.2,24.46,47.66,11.5],["New York 20th","Democratic","Paul","Tonko",35.8,13.48,49.28,6.0],["Washington 2nd","Democratic","Rick","Larsen",28.0,22.1,50.1,10.9],["Connecticut 1st","Democratic","John","Larson",30.3,23.09,53.39,10.9],["Connecticut 3rd","Democratic","Rosa","DeLauro",38.0,15.49,53.49,6.9],["Maryland 2nd","Democratic","Dutch","Ruppersberger",29.0,24.52,53.52,11.7],["Florida 5th","Democratic","Al","Lawson",28.4,25.41,53.81,12.0],["Minnesota 4th","Democratic","Betty","McCollum",23.4,30.97,54.37,15.7],["Texas 28th","Democratic","Henry","Cuellar",34.9,19.89,54.79,9.2],["Rhode Island 1st","Democratic","David","Cicilline",29.4,25.53,54.93,12.3],["Florida 10th","Democratic","Val","Demings",29.8,26.89,56.69,12.8],["California 41st","Democratic","Mark","Takano",30.0,27.87,57.87,13.7],["California 47th","Democratic","Alan","Lowenthal",27.4,31.58,58.98,15.7],["Ohio 9th","Democratic","Marcy","Kaptur",37.4,22.18,59.58,10.5],["Maryland 8th","Democratic","Jamie","Raskin",26.4,33.67,60.07,16.5],["Maryland 3rd","Democratic","John","Sarbanes",29.3,30.78,60.08,15.1],["Massachusetts 3rd","Democratic","Niki","Tsongas",37.5,22.84,60.34,11.1],["Michigan 12th","Democratic","Debbie","Dingell",35.0,26.35,61.35,12.7],["Nevada 1st","Democratic","Dina","Titus",33.1,29.0,62.1,14.3],["New Jersey 12th","Democratic","Bonnie","Watson Coleman",30.9,33.24,64.14,16.1],["Massachusetts 4th","Democratic","Joe","Kennedy",40.3,24.17,64.47,11.7],["Texas 35th","Democratic","Lloyd","Doggett",31.5,33.6,65.1,16.7],["Virginia 3rd","Democratic","Bobby","Scott",33.6,31.75,65.35,15.5],["Mississippi 2nd","Democratic","Bennie","Thompson",38.0,28.42,66.42,13.3],["New York 26th","Democratic","Brian","Higgins",49.2,19.64,68.84,9.2],["California 53rd","Democratic","Susan","Davis",34.0,34.93,68.93,17.4],["Maryland 5th","Democratic","Steny","Hoyer",38.0,30.98,68.98,15.0],["Massachusetts 8th","Democratic","Stephen","Lynch",44.9,26.05,70.95,12.6],["California 27th","Democratic","Judy","Chu",34.8,37.65,72.45,18.8],["New Jersey 9th","Democratic","Bill","Pascrell",41.7,31.17,72.87,14.9],["North Carolina 12th","Democratic","Alma","Adams",34.0,40.01,74.01,19.6],["California 33rd","Democratic","Ted","Lieu",32.8,41.33,74.13,20.8],["Wisconsin 2nd","Democratic","Mark","Pocan",37.5,36.8,74.3,18.3],["Ohio 3rd","Democratic","Joyce","Beatty",37.2,38.4,75.6,19.0],["North Carolina 4th","Democratic","David","Price",36.4,40.03,76.43,19.6],["North Carolina 1st","Democratic","G.K.","Butterfield",39.6,37.07,76.67,17.8],["Illinois 9th","Democratic","Jan","Schakowsky",33.0,45.24,78.24,22.7],["New York 6th","Democratic","Grace","Meng",45.4,33.04,78.44,15.9],["South Carolina 6th","Democratic","James","Clyburn",42.5,36.51,79.01,17.7],["California 38th","Democratic","Linda","S\\u00e1nchez",41.0,39.56,80.56,19.8],["Hawaii 1st","Democratic","Colleen","Hanabusa",49.2,32.53,81.73,16.3],["Pennsylvania 14th","Democratic","Mike","Doyle",48.8,35.89,84.69,17.3],["California 35th","Democratic","Norma","Torres",44.8,40.79,85.59,20.4],["Colorado 1st","Democratic","Diana","DeGette",40.2,45.79,85.99,23.7],["Illinois 5th","Democratic","Mike","Quigley",40.3,46.58,86.88,23.5],["California 30th","Democratic","Brad","Sherman",45.2,43.41,88.61,21.8],["California 20th","Democratic","Jimmy","Panetta",41.6,47.13,88.73,24.1],["Washington 9th","Democratic","Adam","Smith",45.8,47.13,92.93,24.0],["California 11th","Democratic","Mark","DeSaulnier",44.2,48.85,93.05,24.8],["California 15th","Democratic","Eric","Swalwell",47.6,45.74,93.34,23.2],["Virginia 8th","Democratic","Don","Beyer",41.1,52.61,93.71,26.8],["Massachusetts 1st","Democratic","Richie","Neal",73.3,20.65,93.95,9.9],["Indiana 1st","Democratic","Pete","Visclosky",81.5,12.56,94.06,5.5],["Texas 29th","Democratic","Gene","Green",48.5,45.66,94.16,22.5],["Hawaii 2nd","Democratic","Tulsi","Gabbard",62.4,31.85,94.25,16.4],["Wisconsin 3rd","Democratic","Ron","Kind",98.9,-4.5,94.4,-3.5],["California 51st","Democratic","Juan","Vargas",45.6,49.06,94.66,24.8],["California 18th","Democratic","Anna","Eshoo",42.2,53.17,95.37,27.3],["California 6th","Democratic","Doris","Matsui",50.8,44.75,95.55,22.8],["Texas 33rd","Democratic","Marc","Veasey",47.4,49.15,96.55,24.3],["California 5th","Democratic","Mike","Thompson",53.8,44.87,98.67,22.9],["California 19th","Democratic","Zoe","Lofgren",47.8,51.41,99.21,26.1],["California 2nd","Democratic","Jared","Huffman",53.8,45.69,99.49,23.6],["Arizona 7th","Democratic","Ruben","Gallego",50.5,49.1,99.6,24.9],["Minnesota 5th","Democratic","Keith","Ellison",46.8,55.24,102.04,28.8],["Illinois 1st","Democratic","Bobby","Rush",48.2,53.94,102.14,26.7],["Georgia 4th","Democratic","Hank","Johnson",51.4,53.06,104.46,26.1],["California 28th","Democratic","Adam","Schiff",56.0,49.8,105.8,25.2],["Texas 18th","Democratic","Shelia","Jackson Lee",49.9,56.5,106.4,28.2],["Texas 20th","Democratic","Joaquin","Castro",79.7,26.72,106.42,12.9],["Maryland 7th","Democratic","Elijah","Cummings",53.1,54.98,108.08,27.5],["Maryland 4th","Democratic","Anthony","Brown",52.7,58.52,111.22,29.1],["New Jersey 8th","Democratic","Albio","Sires",58.5,54.19,112.69,26.8],["Missouri 1st","Democratic","Lacy","Clay",55.5,58.19,113.69,29.3],["California 43rd","Democratic","Maxine","Waters",52.2,61.69,113.89,31.3],["Illinois 3rd","Democratic","Dan","Lipinski",100.0,15.3,115.3,6.9],["New York 10th","Democratic","Jerry","Nadler",56.1,59.53,115.63,29.5],["Vermont At-Large","Democratic","Peter","Welch",89.5,26.41,115.91,14.1],["Massachusetts 6th","Democratic","Seth","Moulton",98.4,17.86,116.26,8.4],["Tennessee 9th","Democratic","Steve","Cohen",59.8,57.76,117.56,28.6],["Massachusetts 2nd","Democratic","Jim","McGovern",98.2,19.37,117.57,9.3],["Arizona 3rd","Democratic","Ra\\u00fal","Grijalva",88.1,29.92,118.02,14.6],["Illinois 2nd","Democratic","Robin","Kelly",59.6,58.86,118.46,29.2],["New York 17th","Democratic","Nita","Lowey",99.1,20.14,119.24,9.3],["Oregon 3rd","Democratic","Earl","Blumenauer",71.8,48.26,120.06,24.8],["California 14th","Democratic","Jackie","Speier",61.8,58.7,120.5,29.7],["Michigan 14th","Democratic","Brenda","Lawrence",59.8,60.93,120.73,30.2],["Michigan 13th","Democratic","John","Conyers",61.4,60.67,122.07,30.2],["Texas 9th","Democratic","Al","Green",61.2,61.3,122.5,30.4],["Florida 20th","Democratic","Alcee","Hastings",60.6,62.1,122.7,30.5],["New York 14th","Democratic","Joe","Crowley",65.7,57.89,123.59,28.6],["Ohio 11th","Democratic","Marcia","Fudge",60.6,63.5,124.1,31.4],["Pennsylvania 1st","Democratic","Bob","Brady",64.4,61.28,125.68,30.2],["Texas 16th","Democratic","Beto","O'Rourke",85.7,40.71,126.41,20.3],["Texas 30th","Democratic","Eddie Bernice","Johnson",66.5,60.8,127.3,30.1],["Virginia 11th","Democratic","Gerry","Connolly",87.9,39.42,127.32,19.8],["Wisconsin 4th","Democratic","Gwen","Moore",76.7,52.16,128.86,26.1],["Pennsylvania 13th","Democratic","Brendan","Boyle",100.0,33.58,133.58,16.2],["New York 12th","Democratic","Carolyn","Maloney",66.3,69.8,136.1,35.0],["California 46th","Democratic","Lou","Correa",100.0,38.37,138.37,19.3],["California 32nd","Democratic","Grace","Napolitano",100.0,38.87,138.87,19.5],["Alabama 7th","Democratic","Terri","Sewell",98.4,41.15,139.55,19.8],["California 40th","Democratic","Lucille","Roybal-Allard",71.4,69.45,140.85,35.4],["Georgia 5th","Democratic","John","Lewis",68.8,73.07,141.87,36.6],["Massachusetts 5th","Democratic","Katherine","Clark",98.6,43.64,142.24,21.9],["Georgia 13th","Democratic","David","Scott",100.0,44.41,144.41,21.6],["New York 5th","Democratic","Gregory","Meeks",72.4,73.03,145.43,36.0],["New Jersey 10th","Democratic","Donald","Payne",73.8,72.41,146.21,35.8],["Illinois 7th","Democratic","Danny","Davis",68.4,78.19,146.59,39.3],["New York 16th","Democratic","Eliot","Engel",94.4,52.65,147.05,25.9],["Louisiana 2nd","Democratic","Cedric","Richmond",100.0,52.37,152.37,25.9],["California 17th","Democratic","Ro","Khanna",100.0,53.43,153.43,27.2],["New York 7th","Democratic","Nydia","Vel\\u00e1zquez",81.5,76.52,158.02,38.2],["California 12th","Democratic","Nancy","Pelosi",80.9,77.5,158.4,39.7],["California 29th","Democratic","Tony","Cardenas",100.0,60.94,160.94,31.1],["New York 9th","Democratic","Yvette","Clarke",92.3,69.04,161.34,34.2],["California 13th","Democratic","Barbara","Lee",81.6,80.55,162.15,41.7],["Pennsylvania 2nd","Democratic","Dwight","Evans",80.4,82.83,163.23,41.1],["New York 8th","Democratic","Hakeem","Jeffries",93.2,71.13,164.33,35.1],["Florida 24th","Democratic","Frederica","Wilson",100.0,67.7,167.7,33.3],["New York 13th","Democratic","Adriano","Espaillat",81.7,86.85,168.55,43.3],["Illinois 4th","Democratic","Luis","Guti\\u00e9rrez",100.0,68.86,168.86,35.0],["Washington 7th","Democratic","Pramila","Jayapal",100.0,69.95,169.95,36.0],["California 44th","Democratic","Nanette","Barragan",100.0,70.77,170.77,36.0],["Massachusetts 7th","Democratic","Mike","Capuano",98.6,72.21,170.81,36.5],["California 37th","Democratic","Karen","Bass",100.0,76.05,176.05,38.8],["New York 15th","Democratic","Jos\\u00e9","Serrano",91.7,88.87,180.57,43.9]];\n", | |
| "\n", | |
| " //TABLE HEAD\n", | |
| " var tr = document.createElement('tr');\n", | |
| " tableHead.appendChild(tr);\n", | |
| " for (i = 0; i < heading.length; i++) {\n", | |
| " var th = document.createElement('th')\n", | |
| " //th.width = '75';\n", | |
| " th.appendChild(document.createTextNode(heading[i]));\n", | |
| " tr.appendChild(th);\n", | |
| " }\n", | |
| "\n", | |
| " //TABLE ROWS\n", | |
| " for (i = 0; i < data.length; i++) {\n", | |
| " var tr = document.createElement('TR');\n", | |
| " for (j = 0; j < data[i].length; j++) {\n", | |
| " var td = document.createElement('TD')\n", | |
| " td.appendChild(document.createTextNode(data[i][j]));\n", | |
| " tr.appendChild(td)\n", | |
| " }\n", | |
| " tableBody.appendChild(tr);\n", | |
| " } \n", | |
| " tableDiv.appendChild(table)\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " window.onload = function () {addTable(); makeAllSortable(); };\n", | |
| " // use callback makeAllSortable(); at end?\n", | |
| " // window.onload = function () {addTable(makeAllSortable); }; \n", | |
| "\n", | |
| " </script>\n", | |
| "\n", | |
| " </body>\n", | |
| " </html>\" style=\"width: 800px; height: 500px; \n", | |
| " display:block; margin: 25px; border: none\"></iframe>\n", | |
| " " | |
| ], | |
| "text/plain": [ | |
| "<IPython.core.display.HTML object>" | |
| ] | |
| }, | |
| "execution_count": 58, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "temp_df = house_df[(house_df['party'] == 'Democratic')].copy() \n", | |
| "temp_df.sort_values(by='sum', ascending=True, inplace=True)\n", | |
| "\n", | |
| "temp_df = temp_df[['district', 'party', 'first', 'last', 'demlead_house2016', \n", | |
| " 'demlead_pres2016', 'sum', 'pvi_2016']]\n", | |
| "\n", | |
| "interactive_table(temp_df, width=800, height=500)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "## Close House Seats for Republicans\n", | |
| "\n", | |
| "I do the same thing below for House Republicans, but this time a positive sum indicates a district that had a larger margin for Clinton than for the Republican elected. I also include a column showing whether or not the [Democratic Congressional Campaign Committee](http://dccc.org/) has indicated that this member of the House is a target for the 2018 election. This shows that the 'sum' column is a fairly good indicator for a midterm target.\n", | |
| " " | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 59, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<iframe srcdoc=\"\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset="utf-8">\n", | |
| " <style>\n", | |
| "\n", | |
| " /*\n", | |
| " body {\n", | |
| " width: 800px;\n", | |
| " }*/\n", | |
| "\n", | |
| " table {\n", | |
| " font-size: 12px;\n", | |
| " border-collapse: collapse;\n", | |
| " border-top: 1px solid #ddd;\n", | |
| " border-right: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " th {\n", | |
| " padding: 10px;\n", | |
| " cursor: pointer;\n", | |
| " background-color: #f2f2f2;\n", | |
| " }\n", | |
| "\n", | |
| " th, td {\n", | |
| " text-align: left;\n", | |
| " border-bottom: 1px solid #ddd;\n", | |
| " border-left: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " td {\n", | |
| " padding: 5px 8px;\n", | |
| " }\n", | |
| "\n", | |
| " tr:nth-child(even) {\n", | |
| " background-color: #f9f9f9;\n", | |
| " }\n", | |
| "\n", | |
| " tr:hover {\n", | |
| " background-color: #F0F8FF; /*#f9f9f9;*/\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| "\n", | |
| " <body>\n", | |
| "\n", | |
| " <div id ="tableInsert"></div>\n", | |
| "\n", | |
| " <script>\n", | |
| " //http://stackoverflow.com/questions/14267781/sorting-html-table-with-javascript\n", | |
| "\n", | |
| " function sortTable(table, col, reverse) {\n", | |
| " var tb = table.tBodies[0], \n", | |
| " tr = Array.prototype.slice.call(tb.rows, 0), // put rows into array\n", | |
| " i;\n", | |
| "\n", | |
| " reverse = -((+reverse) || -1);\n", | |
| " tr = tr.sort(function (a, b) { \n", | |
| " var first = a.cells[col].textContent.trim();\n", | |
| " var second = b.cells[col].textContent.trim();\n", | |
| "\n", | |
| " if (isNumeric(first) && isNumeric(second)) { \n", | |
| " return reverse * (Number(first) - Number(second));\n", | |
| " } else {\n", | |
| " return reverse * first.localeCompare(second);\n", | |
| " };\n", | |
| " });\n", | |
| " for(i = 0; i < tr.length; ++i) { // append each row in order\n", | |
| " tb.appendChild(tr[i]);\n", | |
| " }\n", | |
| " }\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/18082\n", | |
| " function isNumeric(n) {\n", | |
| " return !isNaN(parseFloat(n)) && isFinite(n);\n", | |
| " }\n", | |
| "\n", | |
| " function makeSortable(table) {\n", | |
| " var th = table.tHead, i;\n", | |
| " th && (th = th.rows[0]) && (th = th.cells);\n", | |
| " if (th) i = th.length;\n", | |
| " else return; // if no `<thead>` then do nothing\n", | |
| " while (--i >= 0) (function (i) {\n", | |
| " var dir = 1;\n", | |
| " th[i].addEventListener('click', function () {sortTable(table, i, (dir = 1 - dir))});\n", | |
| " }(i));\n", | |
| " }\n", | |
| "\n", | |
| " function makeAllSortable(parent) {\n", | |
| " parent = parent || document.body;\n", | |
| " var t = parent.getElementsByTagName('table'), i = t.length;\n", | |
| " while (--i >= 0) makeSortable(t[i]);\n", | |
| " }\n", | |
| "\n", | |
| " function addTable() {\n", | |
| " var tableDiv = document.getElementById("tableInsert")\n", | |
| " var table = document.createElement('table')\n", | |
| " var tableHead = document.createElement('thead')\n", | |
| " var tableBody = document.createElement('tbody')\n", | |
| "\n", | |
| " table.appendChild(tableHead)\n", | |
| " table.appendChild(tableBody);\n", | |
| "\n", | |
| " var heading = ["district", "party", "first", "last", "demlead_house2016", "demlead_pres2016", "sum", "dccc_target", "pvi_2016"];\n", | |
| " var data = [["Florida 27th","Republican","Ileana","Ros-Lehtinen",-9.8,19.71,9.91,true,9.0],["California 49th","Republican","Darrell","Issa",-0.6,7.49,6.89,true,2.9],["Florida 26th","Republican","Carlos","Curbelo",-11.8,16.16,4.36,true,7.2],["Virginia 10th","Republican","Barbara","Comstock",-5.8,9.93,4.13,true,4.1],["California 21st","Republican","David","Valadao",-13.4,15.58,2.18,true,7.1],["Texas 23rd","Republican","Will","Hurd",-1.3,3.41,2.11,true,0.7],["Colorado 6th","Republican","Mike","Coffman",-8.3,8.93,0.63,true,3.8],["California 25th","Republican","Steve","Knight",-6.2,6.68,0.48,true,2.4],["California 10th","Republican","Jeff","Denham",-3.4,3.0,-0.4,true,0.5],["Minnesota 2nd","Republican","Jason","Lewis",-1.8,-1.2,-3.0,true,-1.8],["Nebraska 2nd","Republican","Don","Bacon",-1.2,-2.25,-3.45,true,-2.3],["Minnesota 3rd","Republican","Erik","Paulsen",-13.7,9.46,-4.24,true,4.0],["California 39th","Republican","Ed","Royce",-14.4,8.61,-5.79,true,3.4],["Arizona 2nd","Republican","Martha","McSally",-14.0,4.9,-9.1,true,1.5],["Pennsylvania 8th","Republican","Brian","Fitzpatrick",-9.0,-0.24,-9.24,true,-1.2],["Kansas 3rd","Republican","Kevin","Yoder",-10.7,1.22,-9.48,true,-0.5],["New Jersey 7th","Republican","Leonard","Lance",-11.0,1.12,-9.88,true,-0.5],["Texas 7th","Republican","John","Culberson",-12.4,1.37,-11.03,true,-0.4],["Iowa 1st","Republican","Rod","Blum",-7.6,-3.55,-11.15,true,-3.0],["Illinois 6th","Republican","Peter","Roskam",-18.4,6.97,-11.43,true,2.6],["California 45th","Republican","Mimi","Walters",-17.2,5.44,-11.76,true,1.8],["Pennsylvania 6th","Republican","Ryan","Costello",-14.6,0.62,-13.98,true,-0.8],["California 48th","Republican","Dana","Rohrabacher",-16.6,1.71,-14.89,true,-0.2],["New York 19th","Republican","John","Faso",-8.5,-7.29,-15.79,true,-5.0],["Pennsylvania 7th","Republican","Pat","Meehan",-19.0,2.37,-16.63,true,0.1],["Michigan 11th","Republican","Dave","Trott",-12.7,-4.37,-17.07,true,-3.4],["Iowa 3rd","Republican","David","Young",-13.7,-3.53,-17.23,true,-3.0],["Washington 8th","Republican","Dave","Reichert",-20.4,3.04,-17.36,true,0.5],["New York 24th","Republican","John","Katko",-21.1,3.65,-17.45,true,0.8],["Pennsylvania 16th","Republican","Lloyd","Smucker",-10.9,-6.81,-17.71,true,-4.7],["Utah 4th","Republican","Mia","Love",-12.5,-6.72,-19.22,false,-5.8],["Florida 18th","Republican","Brian","Mast",-10.5,-9.21,-19.71,true,-5.8],["Maine 2nd","Republican","Bruce","Poliquin",-9.6,-10.28,-19.88,true,-6.7],["New Jersey 11th","Republican","Rodney","Frelinghuysen",-19.1,-0.88,-19.98,true,-1.6],["New York 22nd","Republican","Claudia","Tenney",-5.5,-15.48,-20.98,true,-9.3],["North Carolina 13th","Republican","Ted","Budd",-12.2,-9.39,-21.59,true,-5.9],["Virginia 7th","Republican","Dave","Brat",-15.3,-6.5,-21.8,false,-4.6],["Illinois 14th","Republican","Randy","Hultgren",-18.6,-3.89,-22.49,true,-3.2],["North Carolina 2nd","Republican","George","Holding",-13.4,-9.65,-23.05,false,-6.1],["Texas 24th","Republican","Kenny","Marchant",-16.9,-6.25,-23.15,false,-4.4],["Michigan 8th","Republican","Mike","Bishop",-16.8,-6.79,-23.59,true,-4.7],["Illinois 13th","Republican","Rodney","Davis",-19.4,-5.46,-24.86,true,-4.0],["Georgia 6th","Republican","Tom","Price",-23.4,-1.49,-24.89,true,-1.9],["Florida 15th","Republican","Dennis","Ross",-15.0,-9.99,-24.99,false,-6.3],["Ohio 1st","Republican","Steve","Chabot",-18.4,-6.65,-25.05,true,-4.6],["Virginia 2nd","Republican","Scott","Taylor",-22.8,-3.4,-26.2,true,-2.9],["Colorado 3rd","Republican","Scott","Tipton",-14.3,-11.91,-26.21,true,-7.6],["Florida 25th","Republican","Mario","Diaz-Balart",-24.8,-1.7,-26.5,true,-2.0],["New Jersey 3rd","Republican","Tom","MacArthur",-20.4,-6.19,-26.59,true,-4.3],["New Jersey 2nd","Republican","Frank","LoBiondo",-22.0,-4.62,-26.62,true,-3.5],["Texas 22nd","Republican","Pete","Olson",-19.0,-7.89,-26.89,false,-5.2],["Georgia 7th","Republican","Rob","Woodall",-20.8,-6.38,-27.18,false,-4.4],["Virginia 5th","Republican","Tom","Garrett",-16.6,-11.09,-27.69,false,-6.9],["North Carolina 9th","Republican","Robert","Pittenger",-16.4,-11.6,-28.0,true,-7.1],["Pennsylvania 15th","Republican","Charlie","Dent",-20.4,-7.62,-28.02,false,-5.1],["Texas 10th","Republican","Michael","McCaul",-18.9,-9.18,-28.08,false,-5.9],["Alaska At-Large","Republican","Don","Young",-14.3,-14.73,-29.03,false,-9.5],["Illinois 12th","Republican","Mike","Bost",-14.6,-14.84,-29.44,false,-8.9],["California 42nd","Republican","Ken","Calvert",-17.6,-11.95,-29.55,false,-7.4],["New York 23rd","Republican","Tom","Reed",-15.2,-14.88,-30.08,false,-9.0],["New York 1st","Republican","Lee","Zeldin",-17.9,-12.29,-30.19,true,-7.5],["Florida 16th","Republican","Vern","Buchanan",-19.6,-10.79,-30.39,false,-6.7],["Texas 21st","Republican","Lamar","Smith",-20.6,-9.97,-30.57,false,-6.4],["Michigan 6th","Republican","Fred","Upton",-22.2,-8.44,-30.64,false,-5.6],["Washington 3rd","Republican","Jaime","Herrera Beutler",-23.6,-7.41,-31.01,true,-5.1],["Missouri 2nd","Republican","Ann","Wagner",-20.8,-10.28,-31.08,false,-6.5],["Michigan 3rd","Republican","Justin","Amash",-22.0,-9.45,-31.45,false,-6.2],["Texas 6th","Republican","Joe","Barton",-19.3,-12.25,-31.55,false,-7.5],["Michigan 7th","Republican","Tim","Walberg",-15.1,-17.07,-32.17,true,-10.2],["Arkansas 2nd","Republican","French","Hill",-21.5,-10.72,-32.22,true,-6.8],["Washington 5th","Republican","Cathy","McMorris Rodgers",-19.2,-13.03,-32.23,false,-8.2],["North Carolina 8th","Republican","Richard","Hudson",-17.6,-14.99,-32.59,true,-8.8],["Florida 3rd","Republican","Ted","Yoho",-16.8,-15.96,-32.76,false,-9.4],["North Carolina 6th","Republican","Mark","Walker",-18.4,-14.68,-33.08,false,-8.6],["Oklahoma 5th","Republican","Steve","Russell",-20.3,-13.4,-33.7,false,-8.3],["Nevada 2nd","Republican","Mark","Amodei",-21.4,-12.37,-33.77,false,-7.9],["New York 2nd","Republican","Pete","King",-24.9,-9.01,-33.91,false,-5.8],["Texas 2nd","Republican","Ted","Poe",-24.6,-9.31,-33.91,false,-6.0],["Arizona 6th","Republican","David","Schweikert",-24.2,-9.98,-34.18,false,-6.4],["Florida 6th","Republican","Ron","DeSantis",-17.2,-16.98,-34.18,false,-9.9],["North Carolina 5th","Republican","Virginia","Foxx",-16.8,-17.44,-34.24,false,-10.1],["New York 11th","Republican","Dan","Donovan",-24.8,-9.83,-34.63,true,-6.2],["Texas 31st","Republican","John","Carter",-21.9,-12.74,-34.64,false,-7.9],["South Carolina 1st","Republican","Mark","Sanford",-21.8,-13.02,-34.82,false,-8.0],["Texas 25th","Republican","Roger","Williams",-20.6,-14.86,-35.46,false,-8.9],["New Mexico 2nd","Republican","Steve","Pearce",-25.5,-10.19,-35.69,false,-6.8],["Virginia 1st","Republican","Rob","Wittman",-23.3,-12.41,-35.71,false,-7.7],["Michigan 1st","Republican","Jack","Bergman",-14.8,-21.31,-36.11,false,-12.4],["Montana At-Large","Republican","Ryan","Zinke",-15.7,-20.53,-36.23,false,-12.2],["Ohio 14th","Republican","David","Joyce",-25.2,-11.45,-36.65,false,-7.1],["Wisconsin 6th","Republican","Glenn","Grothman",-19.9,-16.83,-36.73,false,-10.0],["Kentucky 6th","Republican","Andy","Barr",-22.2,-15.28,-37.48,true,-9.2],["California 1st","Republican","Doug","LaMalfa",-18.2,-19.63,-37.83,false,-11.7],["Ohio 10th","Republican","Mike","Turner",-31.4,-7.29,-38.69,false,-4.9],["South Carolina 5th","Republican","Mick","Mulvaney",-20.5,-18.48,-38.98,false,-10.7],["Indiana 5th","Republican","Susan","Brooks",-27.2,-11.8,-39.0,false,-7.4],["Georgia 12th","Republican","Rick","Allen",-23.2,-16.16,-39.36,false,-9.4],["North Carolina 7th","Republican","David","Rouzer",-21.8,-17.7,-39.5,false,-10.2],["California 8th","Republican","Paul","Cook",-24.6,-15.13,-39.73,false,-9.1],["California 4th","Republican","Tom","McClintock",-25.4,-14.75,-40.15,false,-9.0],["Alabama 2nd","Republican","Martha","Roby",-8.3,-31.93,-40.23,true,-17.4],["Indiana 9th","Republican","Trey","Hollingsworth",-13.6,-26.9,-40.5,false,-15.2],["Texas 3rd","Republican","Sam","Johnson",-26.6,-14.18,-40.78,false,-8.5],["South Carolina 7th","Republican","Tom","Rice",-22.1,-18.91,-41.01,false,-10.8],["Utah 2nd","Republican","Chris","Stewart",-27.7,-14.04,-41.74,false,-10.1],["California 50th","Republican","Duncan","Hunter",-27.0,-15.01,-42.01,false,-9.1],["South Carolina 2nd","Republican","Joe","Wilson",-24.3,-17.72,-42.02,false,-10.5],["Wisconsin 8th","Republican","Mike","Gallagher",-25.3,-17.57,-42.87,false,-10.4],["Texas 17th","Republican","Bill","Flores",-25.6,-17.47,-43.07,false,-10.3],["Texas 14th","Republican","Randy","Weber",-23.8,-19.73,-43.53,false,-11.3],["Wisconsin 7th","Republican","Sean","Duffy",-23.4,-20.44,-43.84,false,-11.9],["Pennsylvania 12th","Republican","Keith","Rothfus",-23.6,-20.8,-44.4,false,-11.9],["California 22nd","Republican","Devin","Nunes",-35.2,-9.49,-44.69,false,-6.1],["New Jersey 4th","Republican","Chris","Smith",-30.2,-14.77,-44.97,false,-8.7],["Wisconsin 1st","Republican","Paul","Ryan",-34.7,-10.38,-45.08,false,-6.6],["Indiana 2nd","Republican","Jackie","Walorski",-22.4,-23.21,-45.61,false,-13.3],["Kansas 2nd","Republican","Lynn","Jenkins",-28.3,-18.4,-46.7,true,-11.0],["Texas 27th","Republican","Blake","Farenthold",-23.4,-23.55,-46.95,false,-13.3],["Ohio 16th","Republican","Jim","Renacci",-30.6,-16.65,-47.25,false,-9.8],["Michigan 2nd","Republican","Bill","Huizenga",-30.1,-17.53,-47.63,false,-10.4],["Ohio 15th","Republican","Steve","Stivers",-32.4,-15.48,-47.88,false,-9.2],["Ohio 12th","Republican","Pat","Tiberi",-36.8,-11.27,-48.07,false,-7.0],["Ohio 2nd","Republican","Brad","Wenstrup",-32.2,-16.09,-48.29,false,-9.5],["New York 21st","Republican","Elise","Stefanik",-35.2,-13.86,-49.06,false,-8.5],["Arizona 5th","Republican","Andy","Biggs",-28.2,-21.12,-49.32,false,-12.3],["Iowa 4th","Republican","Steve","King",-22.6,-27.33,-49.93,false,-15.6],["North Carolina 10th","Republican","Patrick","McHenry",-26.2,-24.47,-50.67,false,-13.7],["Pennsylvania 11th","Republican","Lou","Barletta",-27.4,-23.82,-51.22,false,-13.5],["Florida 8th","Republican","Bill","Posey",-30.6,-20.71,-51.31,false,-11.9],["West Virginia 2nd","Republican","Alex","Mooney",-16.4,-36.44,-52.84,true,-20.3],["Pennsylvania 4th","Republican","Scott","Perry",-32.2,-21.5,-53.7,false,-12.3],["Florida 19th","Republican","Francis","Rooney",-31.8,-22.06,-53.86,false,-12.5],["Michigan 4th","Republican","John","Moolenaar",-29.5,-24.82,-54.32,false,-14.3],["Florida 17th","Republican","Tom","Rooney",-27.6,-27.2,-54.8,false,-15.1],["Colorado 4th","Republican","Ken","Buck",-31.8,-23.16,-54.96,false,-13.7],["Colorado 5th","Republican","Doug","Lamborn",-31.4,-23.94,-55.34,false,-14.4],["Florida 12th","Republican","Gus","Bilirakis",-37.2,-18.6,-55.8,false,-10.8],["Minnesota 6th","Republican","Tom","Emmer",-31.3,-25.67,-56.97,false,-15.0],["Wisconsin 5th","Republican","Jim","Sensenbrenner",-37.4,-20.14,-57.54,false,-11.7],["North Carolina 11th","Republican","Mark","Meadows",-28.2,-29.49,-57.69,false,-16.3],["South Dakota At-Large","Republican","Kristi","Noem",-28.2,-29.8,-58.0,false,-17.1],["North Carolina 3rd","Republican","Walter","Jones",-34.4,-23.68,-58.08,false,-13.3],["Idaho 2nd","Republican","Mike","Simpson",-33.5,-24.66,-58.16,false,-15.8],["Virginia 6th","Republican","Bob","Goodlatte",-33.5,-24.81,-58.31,false,-14.2],["New York 27th","Republican","Chris","Collins",-34.4,-24.44,-58.84,true,-14.0],["Georgia 11th","Republican","Barry","Loudermilk",-34.8,-24.99,-59.79,false,-14.2],["Nebraska 1st","Republican","Jeff","Fortenberry",-39.0,-21.23,-60.23,false,-12.4],["Mississippi 3rd","Republican","Gregg","Harper",-35.8,-24.52,-60.32,false,-13.6],["California 23rd","Republican","Kevin","McCarthy",-38.4,-22.07,-60.47,false,-12.8],["South Carolina 4th","Republican","Trey","Gowdy",-36.2,-25.74,-61.94,false,-14.7],["Michigan 10th","Republican","Paul","Mitchell",-30.8,-32.17,-62.97,false,-18.0],["Pennsylvania 5th","Republican","Glenn","Thompson",-34.4,-28.84,-63.24,false,-16.2],["Texas 26th","Republican","Michael","Burgess",-36.8,-26.5,-63.3,false,-15.0],["Oregon 2nd","Republican","Greg","Walden",-43.7,-20.09,-63.79,false,-11.9],["Georgia 8th","Republican","Austin","Scott",-35.2,-28.94,-64.14,false,-15.9],["Ohio 7th","Republican","Bob","Gibbs",-35.0,-29.66,-64.66,true,-16.7],["Louisiana 4th","Republican","Mike","Johnson",-41.6,-23.98,-65.58,false,-13.4],["Indiana 8th","Republican","Larry","Bucshon",-32.0,-33.72,-65.72,false,-18.8],["Florida 11th","Republican","Daniel","Webster",-33.8,-32.31,-66.11,false,-17.7],["Maryland 1st","Republican","Andy","Harris",-38.4,-28.42,-66.82,false,-16.0],["Alabama 5th","Republican","Mo","Brooks",-33.5,-33.37,-66.87,false,-18.5],["Utah 1st","Republican","Rob","Bishop",-39.5,-27.37,-66.87,false,-20.1],["Ohio 5th","Republican","Bob","Latta",-41.8,-25.09,-66.89,false,-14.4],["Alabama 3rd","Republican","Mike","Rogers",-34.0,-32.96,-66.96,false,-18.0],["Georgia 3rd","Republican","Drew","Ferguson",-36.6,-31.57,-68.17,false,-17.4],["Indiana 4th","Republican","Todd","Rokita",-34.1,-34.11,-68.21,false,-19.2],["Pennsylvania 9th","Republican","Bill","Shuster",-26.6,-42.53,-69.13,false,-23.0],["Texas 32nd","Republican","Pete","Sessions",-71.1,1.87,-69.23,true,-0.1],["Ohio 4th","Republican","Jim","Jordan",-36.0,-33.6,-69.6,false,-18.8],["Florida 4th","Republican","John","Rutherford",-42.6,-28.02,-70.62,false,-15.7],["Utah 3rd","Republican","Jason","Chaffetz",-47.0,-23.91,-70.91,false,-18.1],["Missouri 6th","Republican","Sam","Graves",-39.6,-31.44,-71.04,false,-17.7],["Tennessee 4th","Republican","Scott","DesJarlais",-30.0,-41.14,-71.14,false,-22.5],["Illinois 18th","Republican","Darin","LaHood",-44.2,-27.39,-71.59,false,-15.7],["Texas 12th","Republican","Kay","Granger",-42.5,-30.21,-72.71,false,-16.9],["Tennessee 3rd","Republican","Chuck","Fleischmann",-37.6,-35.23,-72.83,false,-19.5],["Florida 2nd","Republican","Neal","Dunn",-37.4,-35.6,-73.0,false,-19.5],["Mississippi 1st","Republican","Trent","Kelly",-40.8,-32.96,-73.76,false,-18.0],["Idaho 1st","Republican","Ra\\u00fal","Labrador",-36.4,-38.3,-74.7,false,-22.6],["Missouri 4th","Republican","Vicky","Hartzler",-40.0,-35.95,-75.95,false,-20.1],["Pennsylvania 10th","Republican","Tom","Marino",-40.4,-35.89,-76.29,false,-19.8],["Ohio 8th","Republican","Warren","Davidson",-41.8,-34.51,-76.31,false,-19.1],["Florida 1st","Republican","Matt","Gaetz",-38.2,-39.34,-77.54,false,-21.7],["Wyoming At-Large","Republican","Liz","Cheney",-32.0,-46.3,-78.3,false,-26.8],["Mississippi 4th","Republican","Steven","Palazzo",-37.2,-41.14,-78.34,false,-22.2],["Kentucky 4th","Republican","Thomas","Massie",-42.6,-35.91,-78.51,false,-20.1],["Missouri 3rd","Republican","Blaine","Luetkemeyer",-39.9,-39.02,-78.92,false,-21.6],["Tennessee 8th","Republican","David","Kustoff",-43.7,-35.62,-79.32,false,-19.5],["West Virginia 1st","Republican","David","McKinley",-38.0,-41.64,-79.64,false,-23.2],["Oklahoma 4th","Republican","Tom","Cole",-43.5,-37.4,-80.9,false,-21.0],["Virginia 9th","Republican","Morgan","Griffith",-40.3,-41.48,-81.78,false,-22.7],["North Dakota At-Large","Republican","Kevin","Cramer",-45.4,-36.41,-81.81,false,-20.9],["Indiana 3rd","Republican","Jim","Banks",-47.1,-34.99,-82.09,false,-19.5],["Louisiana 6th","Republican","Garret","Graves",-48.9,-33.8,-82.7,false,-18.7],["Indiana 6th","Republican","Luke","Messer",-42.4,-40.34,-82.74,false,-22.3],["Arizona 4th","Republican","Paul","Gosar",-43.0,-40.15,-83.15,false,-22.2],["South Carolina 3rd","Republican","Jeff","Duncan",-45.7,-37.99,-83.69,false,-20.9],["Ohio 6th","Republican","Bill","Johnson",-41.4,-42.6,-84.0,false,-23.3],["Missouri 7th","Republican","Billy","Long",-40.1,-45.68,-85.78,false,-25.1],["Tennessee 2nd","Republican","John","Duncan",-51.2,-35.4,-86.6,false,-19.8],["Tennessee 7th","Republican","Marsha","Blackburn",-48.7,-39.28,-87.98,false,-21.6],["Arizona 8th","Republican","Trent","Franks",-68.5,-21.13,-89.63,false,-12.2],["West Virginia 3rd","Republican","Evan","Jenkins",-43.9,-49.27,-93.17,false,-26.8],["Alabama 6th","Republican","Gary","Palmer",-49.1,-44.68,-93.78,false,-24.2],["Kentucky 1st","Republican","James","Comer",-45.3,-48.49,-93.79,false,-26.3],["Texas 1st","Republican","Louie","Gohmert",-49.8,-46.94,-96.74,false,-25.2],["Louisiana 1st","Republican","Steve","Scalise",-55.1,-42.0,-97.1,false,-23.1],["Oklahoma 2nd","Republican","Markwayne","Mullin",-47.4,-50.08,-97.48,false,-27.3],["Tennessee 6th","Republican","Diane","Black",-49.3,-48.97,-98.27,false,-26.5],["Louisiana 3rd","Republican","Clay","Higgins",-63.2,-38.12,-101.32,false,-20.9],["Missouri 8th","Republican","Jason","Smith",-51.7,-54.39,-106.09,false,-29.3],["Arkansas 4th","Republican","Bruce","Westerman",-74.9,-32.83,-107.73,false,-18.3],["Arkansas 3rd","Republican","Steve","Womack",-77.3,-31.43,-108.73,false,-18.1],["Texas 5th","Republican","Jeb","Hensarling",-80.6,-28.39,-108.99,false,-15.8],["Oklahoma 3rd","Republican","Frank","Lucas",-56.6,-52.79,-109.39,false,-29.0],["Kansas 1st","Republican","Roger","Marshall",-65.9,-44.98,-110.88,false,-25.1],["Arkansas 1st","Republican","Rick","Crawford",-76.3,-34.81,-111.11,false,-19.4],["Georgia 1st","Republican","Buddy","Carter",-100.0,-15.51,-115.51,false,-9.1],["Illinois 16th","Republican","Adam","Kinzinger",-99.9,-17.16,-117.06,false,-10.3],["Pennsylvania 18th","Republican","Tim","Murphy",-100.0,-19.54,-119.54,false,-11.2],["Tennessee 1st","Republican","Phil","Roe",-63.0,-57.04,-120.04,false,-30.7],["Washington 4th","Republican","Dan","Newhouse",-100.0,-22.86,-122.86,false,-13.4],["Georgia 10th","Republican","Jody","Hice",-100.0,-25.5,-125.5,false,-14.3],["Alabama 1st","Republican","Bradley","Byrne",-96.4,-29.42,-125.82,false,-16.2],["Pennsylvania 3rd","Republican","Mike","Kelly",-100.0,-26.03,-126.03,false,-14.7],["Oklahoma 1st","Republican","Jim","Bridenstine",-100.0,-28.76,-128.76,false,-16.4],["Louisiana 5th","Republican","Ralph","Abraham",-100.0,-29.37,-129.37,false,-16.2],["Texas 36th","Republican","Brian","Babin",-88.6,-46.75,-135.35,false,-25.2],["Texas 19th","Republican","Jodey","Arrington",-86.7,-49.06,-135.76,false,-26.7],["Kentucky 2nd","Republican","Brett","Guthrie",-100.0,-39.93,-139.93,false,-22.1],["Texas 4th","Republican","John","Ratcliffe",-88.0,-53.64,-141.64,false,-28.7],["Illinois 15th","Republican","John","Shimkus",-100.0,-46.2,-146.2,false,-25.4],["Texas 11th","Republican","Mike","Conaway",-89.5,-58.73,-148.23,false,-31.4],["Texas 8th","Republican","Kevin","Brady",-100.0,-48.82,-148.82,false,-26.4],["Georgia 14th","Republican","Tom","Graves",-100.0,-52.89,-152.89,false,-28.4],["Texas 13th","Republican","Mac","Thornberry",-90.0,-63.05,-153.05,false,-33.7],["Nebraska 3rd","Republican","Adrian","Smith",-100.0,-54.87,-154.87,false,-30.0],["Georgia 9th","Republican","Doug","Collins",-100.0,-58.45,-158.45,false,-31.2],["Alabama 4th","Republican","Robert","Aderholt",-98.5,-62.92,-161.42,false,-33.3],["Kentucky 5th","Republican","Hal","Rogers",-100.0,-62.12,-162.12,false,-33.1]];\n", | |
| "\n", | |
| " //TABLE HEAD\n", | |
| " var tr = document.createElement('tr');\n", | |
| " tableHead.appendChild(tr);\n", | |
| " for (i = 0; i < heading.length; i++) {\n", | |
| " var th = document.createElement('th')\n", | |
| " //th.width = '75';\n", | |
| " th.appendChild(document.createTextNode(heading[i]));\n", | |
| " tr.appendChild(th);\n", | |
| " }\n", | |
| "\n", | |
| " //TABLE ROWS\n", | |
| " for (i = 0; i < data.length; i++) {\n", | |
| " var tr = document.createElement('TR');\n", | |
| " for (j = 0; j < data[i].length; j++) {\n", | |
| " var td = document.createElement('TD')\n", | |
| " td.appendChild(document.createTextNode(data[i][j]));\n", | |
| " tr.appendChild(td)\n", | |
| " }\n", | |
| " tableBody.appendChild(tr);\n", | |
| " } \n", | |
| " tableDiv.appendChild(table)\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " window.onload = function () {addTable(); makeAllSortable(); };\n", | |
| " // use callback makeAllSortable(); at end?\n", | |
| " // window.onload = function () {addTable(makeAllSortable); }; \n", | |
| "\n", | |
| " </script>\n", | |
| "\n", | |
| " </body>\n", | |
| " </html>\" style=\"width: 800px; height: 500px; \n", | |
| " display:block; margin: 25px; border: none\"></iframe>\n", | |
| " " | |
| ], | |
| "text/plain": [ | |
| "<IPython.core.display.HTML object>" | |
| ] | |
| }, | |
| "execution_count": 59, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "#http://action.dccc.org/pdf/dccc-on-offense.pdf\n", | |
| "#59 total targets for 2018 elections\n", | |
| "dccc_target = [\"AL-02\", \"AR-02\", \"AZ-02\", \"CA-10\", \"CA-21\", \"CA-25\", \"CA-39\", \"CA-45\", \n", | |
| " \"CA-48\", \"CA-49\", \"CO-03\", \"CO-06\", \"FL-18\", \"FL-25\", \"FL-26\", \"FL-27\", \n", | |
| " \"GA-06\", \"IA-01\", \"IA-03\", \"IL-06\", \"IL-13\", \"IL-14\", \"KS-02\", \"KS-03\", \n", | |
| " \"KY-06\", \"ME-02\", \"MI-07\", \"MI-08\", \"MI-11\", \"MN-02\", \"MN-03\", \"NC-08\", \n", | |
| " \"NC-09\", \"NC-13\", \"NE-02\", \"NJ-02\", \"NJ-03\", \"NJ-07\", \"NJ-11\", \"NY-01\", \n", | |
| " \"NY-11\", \"NY-19\", \"NY-22\", \"NY-24\", \"NY-27\", \"OH-01\", \"OH-07\", \"PA-06\", \n", | |
| " \"PA-07\", \"PA-08\", \"PA-16\", \"TX-07\", \"TX-23\", \"TX-32\", \"VA-02\", \"VA-10\", \n", | |
| " \"WA-03\", \"WA-08\", \"WV-02\"]\n", | |
| "\n", | |
| "#Build dataframe\n", | |
| "temp_df = house_df[(house_df['party'] == 'Republican')].copy() #.loc[:,:]\n", | |
| "temp_df['dccc_target'] = temp_df['code'].isin(dccc_target)\n", | |
| "temp_df.sort_values(by='sum', ascending=False, inplace=True)\n", | |
| "temp_df = temp_df[['district', 'party', 'first', 'last', 'demlead_house2016',\n", | |
| " 'demlead_pres2016', 'sum', 'dccc_target', 'pvi_2016']]\n", | |
| "\n", | |
| "#Build Table\n", | |
| "interactive_table(temp_df, width=800, height=500)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "# Senate Seats at Risk\n", | |
| "\n", | |
| "Next, I look at the Senate seats at risk for each party. \n", | |
| "\n", | |
| "Below is a plot similar plot to the one above, except it only shows the Senators up for re-election in 2018. This plot is also slightly different, as I am using the Democratic Lead in the 2012 Senate election for each candidate on the y-axis. This might not be the best indicator of the state's support for the candidate as a lot has changed since 2012, but it's the best one I can think of.\n", | |
| "\n", | |
| "This plot makes it clear that Senate Democrats have a tough 2018 coming up, as 9 senators are up for re-election in states that Trump won. " | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 8, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "# Note, demlead_lastsenate refers to the 2010 election for \n", | |
| "# senators elected in 2016\n", | |
| "senate_df = pd.read_csv('senate_data.csv', sep=',', encoding='utf-8') \n", | |
| "senate_df['demlead_pres2016'] = ((senate_df['clinton_2016'] - senate_df['trump_2016'])/senate_df['prestotal_2016'])*100\n", | |
| "senate_df['demlead_lastsenate'] = senate_df['lastelect_dem'] - senate_df['lastelect_rep']\n", | |
| "senate_df['sum'] = senate_df['demlead_lastsenate'] + senate_df['demlead_pres2016']\n", | |
| "\n", | |
| "senate_df = senate_df.round(2)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 49, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<iframe srcdoc=\"\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset="utf-8">\n", | |
| " <title>Zoom + Pan</title>\n", | |
| " <style>\n", | |
| " \n", | |
| " body {\n", | |
| " position: relative;\n", | |
| " width: 650px; /*960px*/\n", | |
| " }\n", | |
| "\n", | |
| " svg {font: 10px sans-serif;}\n", | |
| "\n", | |
| " rect {fill: #e5e5e5; }\n", | |
| "\n", | |
| " .label {\n", | |
| " font-size: 12px;\n", | |
| " /*stroke: #ddd;*/\n", | |
| " fill: #555;\n", | |
| " }\n", | |
| "\n", | |
| " .dot {\n", | |
| " /*stroke: #aaa;*/\n", | |
| " /*stroke: red;*/\n", | |
| " /*border: 1;*/\n", | |
| " }\n", | |
| " .dot:hover {fill-opacity: 0.4;}\n", | |
| "\n", | |
| " .axis path,\n", | |
| " .axis line {\n", | |
| " stroke: #fff; /*black;*/\n", | |
| " fill: none; \n", | |
| " stroke-width: 1px;\n", | |
| " }\n", | |
| " \n", | |
| " #main-tick{\n", | |
| " fill: none;\n", | |
| " stroke: #777; \n", | |
| " stroke-width: 1px;\n", | |
| " opacity: 1;\n", | |
| " }\n", | |
| "\n", | |
| " .buttons {\n", | |
| " position: absolute;\n", | |
| " right: 30px;\n", | |
| " top: 30px;\n", | |
| " }\n", | |
| " button {\n", | |
| " font: 16px sans-serif;\n", | |
| " display: block;\n", | |
| " border-radius: 0px;\n", | |
| " width: 25px;\n", | |
| " /*outline: none;*/\n", | |
| " /*outline:0;*/\n", | |
| " background-color: white;\n", | |
| " border: none;\n", | |
| " }\n", | |
| " \n", | |
| " button:hover {\n", | |
| " background-image:none;\n", | |
| " background-color:#d5d5d5;\n", | |
| " }\n", | |
| " \n", | |
| " button:focus{ \n", | |
| " /*outline-color: #ddd;\n", | |
| " outline:none;*/\n", | |
| " outline: 1;\n", | |
| " outline-color: #b5b5b5;\n", | |
| " }\n", | |
| " \n", | |
| "\n", | |
| "\n", | |
| " div.tooltip {\n", | |
| " position: absolute;\n", | |
| " padding: 5px;\n", | |
| " font: 12px sans-serif;\n", | |
| " background: white;\n", | |
| " border: 0px;\n", | |
| " border-radius: 0px;\n", | |
| " pointer-events:none;\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| " <body>\n", | |
| " \n", | |
| " <div class="buttons">\n", | |
| " <button data-zoom="+1">+</button>\n", | |
| " <button data-zoom="-1">-</button>\n", | |
| " </div>\n", | |
| " <script src="//d3js.org/d3.v3.min.js"></script>\n", | |
| " <script>\n", | |
| "\n", | |
| " var margin = {top: 20, right: 20, bottom: 40, left: 40},\n", | |
| " width = 650 - margin.left - margin.right,\n", | |
| " height = 515 - margin.top - margin.bottom;\n", | |
| "\n", | |
| " var keys = {"class": 1, "trump_2016": 7, "prestotal_2016": 5, "first": 3, "pvi_2016": 8, "lastelect_dem": 10, "sum": 14, "last": 4, "lastelect_rep": 11, "demlead_pres2016": 12, "party": 2, "state": 0, "clinton_2016": 6, "demlead_lastsenate": 13, "voting_age_pop": 9};\n", | |
| " var data = [["Arizona",2012.0,"Republican","Jeff","Flake",2604657.0,1161167.0,1252401.0,-2.93,4763003.0,46.16,49.18,-3.5,-3.02,-6.53],["California",2012.0,"Democratic","Dianne","Feinstein",14237884.0,8753788.0,4483810.0,15.09,27958916.0,62.52,37.48,29.99,25.05,55.04],["Connecticut",2012.0,"Democratic","Chris","Murphy",1644920.0,897572.0,673215.0,6.1,2757082.0,55.29,43.03,13.64,12.26,25.9],["Delaware",2012.0,"Democratic","Tom","Carper",443814.0,235603.0,185127.0,4.96,692169.0,66.42,28.95,11.37,37.47,48.84],["Florida",2012.0,"Democratic","Bill","Nelson",9501617.0,4504975.0,4617886.0,-1.66,14798498.0,55.23,42.23,-1.19,13.01,11.82],["Hawaii",2012.0,"Democratic","Mazie","Hirono",428937.0,266891.0,128847.0,16.4,1056483.0,62.6,37.4,32.18,25.2,57.39],["Indiana",2012.0,"Democratic","Joe","Donnelly",2757828.0,1033126.0,1557286.0,-11.02,4875504.0,50.03,44.3,-19.01,5.74,-13.27],["Maine",2012.0,"Independent - Dem Caucus","Angus","King",747927.0,357735.0,335593.0,0.41,1053828.0,52.89,30.74,2.96,22.15,25.11],["Maryland",2012.0,"Democratic","Ben","Cardin",2781446.0,1677928.0,943169.0,12.97,4420588.0,55.98,26.33,26.42,29.65,56.07],["Massachusetts",2012.0,"Democratic","Elizabeth","Warren",3325046.0,1995196.0,1090893.0,13.61,5128706.0,53.74,46.19,27.2,7.55,34.75],["Michigan",2012.0,"Democratic","Debbie","Stabenow",4824119.0,2268839.0,2279543.0,-1.16,7539572.0,58.8,37.98,-0.22,20.81,20.59],["Minnesota",2012.0,"Democratic","Amy","Klobuchar",2945233.0,1367825.0,1323232.0,-0.21,4019862.0,65.23,30.53,1.51,34.7,36.22],["Mississippi",2012.0,"Republican","Roger","Wicker",1211088.0,485131.0,700714.0,-10.14,2211742.0,40.55,57.16,-17.8,-16.6,-34.41],["Missouri",2012.0,"Democratic","Claire","McCaskill",2827673.0,1071068.0,1594511.0,-10.85,4563491.0,54.81,39.11,-18.51,15.7,-2.81],["Montana",2012.0,"Democratic","Jon","Tester",501822.0,177709.0,279240.0,-12.15,765852.0,48.58,44.86,-20.23,3.72,-16.51],["Nebraska",2012.0,"Republican","Deb","Fischer",844227.0,284494.0,495961.0,-14.59,1367120.0,42.23,57.77,-25.05,-15.55,-40.6],["Nevada",2012.0,"Republican","Dean","Heller",1125385.0,539260.0,512058.0,0.25,2035543.0,44.71,45.87,2.42,-1.16,1.26],["New Jersey",2012.0,"Democratic","Bob","Menendez",3906723.0,2148278.0,1601933.0,6.24,6726680.0,58.84,39.4,13.98,19.44,33.42],["New Mexico",2012.0,"Democratic","Martin","Heinrich",798318.0,385234.0,319666.0,3.61,1540507.0,51.01,45.28,8.21,5.73,13.94],["New York",2012.0,"Democratic","Kirsten","Gillibrand",7707363.0,4547562.0,2814589.0,10.05,15053150.0,72.22,26.34,22.48,45.88,68.36],["North Dakota",2012.0,"Democratic","Heidi","Heitkamp",344360.0,93758.0,216794.0,-20.85,522720.0,50.23,49.33,-35.73,0.9,-34.83],["Ohio",2012.0,"Democratic","Sherrod","Brown",5536528.0,2394164.0,2841005.0,-5.31,8805753.0,50.7,44.7,-8.07,6.0,-2.07],["Pennsylvania",2012.0,"Democratic","Bob","Casey",6166698.0,2926441.0,2970733.0,-1.42,9910224.0,53.69,44.59,-0.72,9.1,8.38],["Rhode Island",2012.0,"Democratic","Sheldon","Whitehouse",464144.0,252525.0,180543.0,7.27,828611.0,64.81,34.97,15.51,29.85,45.35],["Tennessee",2012.0,"Republican","Bob","Corker",2508027.0,870695.0,1522925.0,-14.68,4850104.0,30.41,64.89,-26.01,-34.48,-60.49],["Texas",2012.0,"Republican","Ted","Cruz",8969226.0,3877868.0,4685047.0,-5.76,18279734.0,40.62,56.46,-9.0,-15.83,-24.83],["Utah",2012.0,"Republican","Orrin","Hatch",1143601.0,310676.0,515231.0,-13.43,1892855.0,29.98,65.31,-17.89,-35.33,-53.22],["Vermont",2012.0,"Independent - Dem Caucus","Bernie","Sanders",315067.0,178573.0,95369.0,14.14,496508.0,71.04,24.87,26.41,46.17,72.58],["Virginia",2012.0,"Democratic","Tim","Kaine",3982752.0,1981473.0,1769443.0,1.78,6147347.0,52.87,46.96,5.32,5.91,11.23],["Washington",2012.0,"Democratic","Maria","Cantwell",3316996.0,1742718.0,1221747.0,7.74,5143186.0,60.45,39.55,15.71,20.9,36.61],["West Virginia",2012.0,"Democratic","Joe","Manchin",721231.0,188794.0,489371.0,-23.21,1465576.0,60.57,36.47,-41.68,24.1,-17.57],["Wisconsin",2012.0,"Democratic","Tammy","Baldwin",2976150.0,1382536.0,1405284.0,-1.44,4347494.0,51.41,45.86,-0.76,5.55,4.78],["Wyoming",2012.0,"Republican","John","Barrasso",255849.0,55973.0,174419.0,-26.75,428224.0,21.65,75.65,-46.3,-54.0,-100.3]];\n", | |
| " \n", | |
| " var xName = "demlead_pres2016";\n", | |
| " var yName = "demlead_lastsenate";\n", | |
| " var xLabel = "Democratic Lead, President 2016 (%)";\n", | |
| " var yLabel = "Democratic Lead, Last Senate (%)";\n", | |
| " \n", | |
| " var min_x = d3.min(data, function(d) { return +d[keys[xName]]; });\n", | |
| " var max_x = d3.max(data, function(d) { return +d[keys[xName]]; });\n", | |
| " var min_y = d3.min(data, function(d) { return +d[keys[yName]]; });\n", | |
| " var max_y = d3.max(data, function(d) { return +d[keys[yName]]; });\n", | |
| " var max = d3.max([min_x, min_y, max_x, max_y].map(Math.abs));\n", | |
| "\n", | |
| " var x = d3.scale.linear()\n", | |
| " .domain([-1.2*max, 1.2*max])\n", | |
| " .range([ 0, width ]);\n", | |
| "\n", | |
| " var y = d3.scale.linear()\n", | |
| " //.domain([min_y - Math.abs(0.2*min_y), max_y + Math.abs(0.2*max_y)])\n", | |
| " .domain([-1.2*max, 1.2*max])\n", | |
| " .range([ height, 0 ]);\n", | |
| "\n", | |
| " var xAxis = d3.svg.axis()\n", | |
| " .scale(x)\n", | |
| " .orient("bottom")\n", | |
| " .ticks(6) //5\n", | |
| " .tickSize(-height);\n", | |
| "\n", | |
| " var yAxis = d3.svg.axis()\n", | |
| " .scale(y)\n", | |
| " .orient("left")\n", | |
| " .ticks(6) //5\n", | |
| " .tickSize(-width); //-width\n", | |
| "\n", | |
| " var zoom = d3.behavior.zoom()\n", | |
| " .x(x)\n", | |
| " .y(y)\n", | |
| " .scaleExtent([1, 10])\n", | |
| " .center([width / 2, height / 2])\n", | |
| " .size([width, height])\n", | |
| " .on("zoom", zoomed);\n", | |
| "\n", | |
| " var svg = d3.select("body").append("svg")\n", | |
| " .attr("width", width + margin.left + margin.right)\n", | |
| " .attr("height", height + margin.top + margin.bottom)\n", | |
| " .append("g")\n", | |
| " .attr("transform", "translate(" + margin.left + "," + margin.top + ")")\n", | |
| " .call(zoom);\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/28723551\n", | |
| " //Create clip, then apply it to each dot\n", | |
| " var clip = svg.append("defs").append("svg:clipPath")\n", | |
| " .attr("id", "clip")\n", | |
| " .append("svg:rect")\n", | |
| " .attr("id", "clip-rect")\n", | |
| " .attr("x", "0") //\n", | |
| " .attr("y", "0") //\n", | |
| " .attr('width', width)\n", | |
| " .attr('height', height);\n", | |
| "\n", | |
| " svg.append("rect")\n", | |
| " .attr("width", width)\n", | |
| " .attr("height", height);\n", | |
| "\n", | |
| " svg.append("g")\n", | |
| " .attr("class", "x axis")\n", | |
| " .attr("transform", "translate(0," + height + ")")\n", | |
| " .call(xAxis);\n", | |
| "\n", | |
| " svg.append("g")\n", | |
| " .attr("class", "y axis")\n", | |
| " .call(yAxis);\n", | |
| "\n", | |
| " d3.selectAll('g.tick')\n", | |
| " .filter(function(d){ return d==0;} )\n", | |
| " .select('line') \n", | |
| " .attr('id', 'main-tick');\n", | |
| "\n", | |
| " // Tooltips\n", | |
| " var div = d3.select("body")\n", | |
| " .append("div") \n", | |
| " .attr("class", "tooltip")\n", | |
| " .style("opacity", 0); \n", | |
| "\n", | |
| " svg.selectAll(".dot")\n", | |
| " .data(data)\n", | |
| " .enter().append("circle")\n", | |
| " .attr("class", "dot")\n", | |
| " .attr("clip-path", "url(#clip)") //add the clip to each dot\n", | |
| " .attr("r", 4.0) //3.5 4.5 3*zoom.scale()\n", | |
| " .attr("cx", function(d) { return x(+d[keys[xName]]); })\n", | |
| " .attr("cy", function(d) { return y(+d[keys[yName]]); })\n", | |
| " .style("fill", 'red' ) \n", | |
| " .attr('fill-opacity', 0.6)\n", | |
| " .on("mouseover", function(d) { drawTooltip(d); })\n", | |
| " .on("mouseout", function() {\n", | |
| " div.style("opacity", 0);\n", | |
| " });\n", | |
| "\n", | |
| " svg.append("text")\n", | |
| " .attr("class", "x label")\n", | |
| " .attr("text-anchor", "middle")\n", | |
| " .attr("x", width/2)\n", | |
| " .attr("y", height + 30)\n", | |
| " .text("Democratic Lead, President 2016 (%)");\n", | |
| "\n", | |
| " svg.append("text")\n", | |
| " .attr("class", "y label")\n", | |
| " .attr("text-anchor", "middle")\n", | |
| " .attr("x", -height/2)\n", | |
| " .attr("y", -30) //-30\n", | |
| " .attr("transform", "rotate(-90)")\n", | |
| " .text("Democratic Lead, Last Senate (%)");\n", | |
| "\n", | |
| " d3.selectAll("button[data-zoom]")\n", | |
| " .on("click", clicked);\n", | |
| "\n", | |
| " function zoomed() {\n", | |
| " svg.select(".x.axis").call(xAxis);\n", | |
| " svg.select(".y.axis").call(yAxis);\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/37573228\n", | |
| " svg.selectAll(".dot")\n", | |
| " //.attr("r", 3*zoom.scale())\n", | |
| " .attr("cx", function (d) {\n", | |
| " return x(+d[keys[xName]]);\n", | |
| " })\n", | |
| " .attr("cy", function (d) {\n", | |
| " return y(+d[keys[yName]]);\n", | |
| " });\n", | |
| "\n", | |
| " d3.selectAll('g.tick')\n", | |
| " .filter(function(d){ return d==0;} )\n", | |
| " .select('line') //grab the tick line\n", | |
| " .attr('id', 'main-tick');\n", | |
| " }\n", | |
| "\n", | |
| " function clicked() {\n", | |
| " svg.call(zoom.event); // https://github.com/mbostock/d3/issues/2387\n", | |
| "\n", | |
| " // Record the coordinates (in data space) of the center (in screen space).\n", | |
| " var center0 = zoom.center(), translate0 = zoom.translate(), coordinates0 = coordinates(center0);\n", | |
| " zoom.scale(zoom.scale() * Math.pow(2, +this.getAttribute("data-zoom")));\n", | |
| "\n", | |
| " // Translate back to the center.\n", | |
| " var center1 = point(coordinates0);\n", | |
| " zoom.translate([translate0[0] + center0[0] - center1[0], translate0[1] + center0[1] - center1[1]]);\n", | |
| "\n", | |
| " svg.transition().duration(750).call(zoom.event);\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " function coordinates(point) {\n", | |
| " var scale = zoom.scale(), translate = zoom.translate();\n", | |
| " return [(point[0] - translate[0]) / scale, (point[1] - translate[1]) / scale];\n", | |
| " }\n", | |
| "\n", | |
| " function point(coordinates) {\n", | |
| " var scale = zoom.scale(), translate = zoom.translate();\n", | |
| " return [coordinates[0] * scale + translate[0], coordinates[1] * scale + translate[1]];\n", | |
| " }\n", | |
| "\n", | |
| " function drawTooltip(d) {\n", | |
| " div.style("opacity", 1.0);\n", | |
| " div.html(\n", | |
| " '<b>Class:</b> '+ d[keys.class] + \n", | |
| " '<br><b>State:</b> '+ d[keys.state] + \n", | |
| " '<br><b>Name:</b> ' + d[keys.first] + ' ' + d[keys.last] + \n", | |
| " '<br><b>President:</b> ' + d[keys.demlead_pres2016] + "%" + \n", | |
| " '<br><b>Last Senate:</b> ' + d[keys.demlead_lastsenate] +"%" \n", | |
| " )\n", | |
| " .style("left", (d3.event.pageX) + "px")\n", | |
| " .style("top", (d3.event.pageY ) + "px");\n", | |
| " }\n", | |
| "\n", | |
| " </script>\n", | |
| " </body>\n", | |
| " </html>\n", | |
| " \" style=\"width: 960px; height: 600px; display:block; width: 100%; margin: 25px auto; border: none\"></iframe>" | |
| ], | |
| "text/plain": [ | |
| "<IPython.core.display.HTML object>" | |
| ] | |
| }, | |
| "execution_count": 49, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "plot_df = senate_df[senate_df['class'] == 2012]\n", | |
| "\n", | |
| "# p.circle(x='demlead_pres2016', y='demlead_lastsenate', size=8, \n", | |
| "# color='red', source=source, fill_alpha=0.4)\n", | |
| "\n", | |
| "tooltip = '''\n", | |
| " '<b>Class:</b> '+ d[keys.class] + \n", | |
| " '<br><b>State:</b> '+ d[keys.state] + \n", | |
| " '<br><b>Name:</b> ' + d[keys.first] + ' ' + d[keys.last] + \n", | |
| " '<br><b>President:</b> ' + d[keys.demlead_pres2016] + \"%\" + \n", | |
| " '<br><b>Last Senate:</b> ' + d[keys.demlead_lastsenate] +\"%\" \n", | |
| " ''' \n", | |
| "\n", | |
| "settings = {\"x_label\": \"Democratic Lead, President 2016 (%)\", \n", | |
| " \"y_label\": \"Democratic Lead, Last Senate (%)\",\n", | |
| " \"x\": 'demlead_pres2016' ,\n", | |
| " \"y\": 'demlead_lastsenate', \n", | |
| " \"tooltip\": tooltip}\n", | |
| "\n", | |
| "interactive_scatter(plot_df, settings=settings)\n" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "## Close Senate Seats for Democrats\n", | |
| "\n", | |
| "The Senate is a little different because voting happens every six years. I order this by the sum of the Democratic lead in the 2016 presidential election and the Senator's lead in their last election. A district could shift quite a bit during a Senator's term, so this sum should be taken with a grain of salt. \n", | |
| "\n", | |
| "These data make it clear that Senate Democrats have a very difficult election ahead in 2018. " | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 60, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<iframe srcdoc=\"\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset="utf-8">\n", | |
| " <style>\n", | |
| "\n", | |
| " /*\n", | |
| " body {\n", | |
| " width: 800px;\n", | |
| " }*/\n", | |
| "\n", | |
| " table {\n", | |
| " font-size: 12px;\n", | |
| " border-collapse: collapse;\n", | |
| " border-top: 1px solid #ddd;\n", | |
| " border-right: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " th {\n", | |
| " padding: 10px;\n", | |
| " cursor: pointer;\n", | |
| " background-color: #f2f2f2;\n", | |
| " }\n", | |
| "\n", | |
| " th, td {\n", | |
| " text-align: left;\n", | |
| " border-bottom: 1px solid #ddd;\n", | |
| " border-left: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " td {\n", | |
| " padding: 5px 8px;\n", | |
| " }\n", | |
| "\n", | |
| " tr:nth-child(even) {\n", | |
| " background-color: #f9f9f9;\n", | |
| " }\n", | |
| "\n", | |
| " tr:hover {\n", | |
| " background-color: #F0F8FF; /*#f9f9f9;*/\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| "\n", | |
| " <body>\n", | |
| "\n", | |
| " <div id ="tableInsert"></div>\n", | |
| "\n", | |
| " <script>\n", | |
| " //http://stackoverflow.com/questions/14267781/sorting-html-table-with-javascript\n", | |
| "\n", | |
| " function sortTable(table, col, reverse) {\n", | |
| " var tb = table.tBodies[0], \n", | |
| " tr = Array.prototype.slice.call(tb.rows, 0), // put rows into array\n", | |
| " i;\n", | |
| "\n", | |
| " reverse = -((+reverse) || -1);\n", | |
| " tr = tr.sort(function (a, b) { \n", | |
| " var first = a.cells[col].textContent.trim();\n", | |
| " var second = b.cells[col].textContent.trim();\n", | |
| "\n", | |
| " if (isNumeric(first) && isNumeric(second)) { \n", | |
| " return reverse * (Number(first) - Number(second));\n", | |
| " } else {\n", | |
| " return reverse * first.localeCompare(second);\n", | |
| " };\n", | |
| " });\n", | |
| " for(i = 0; i < tr.length; ++i) { // append each row in order\n", | |
| " tb.appendChild(tr[i]);\n", | |
| " }\n", | |
| " }\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/18082\n", | |
| " function isNumeric(n) {\n", | |
| " return !isNaN(parseFloat(n)) && isFinite(n);\n", | |
| " }\n", | |
| "\n", | |
| " function makeSortable(table) {\n", | |
| " var th = table.tHead, i;\n", | |
| " th && (th = th.rows[0]) && (th = th.cells);\n", | |
| " if (th) i = th.length;\n", | |
| " else return; // if no `<thead>` then do nothing\n", | |
| " while (--i >= 0) (function (i) {\n", | |
| " var dir = 1;\n", | |
| " th[i].addEventListener('click', function () {sortTable(table, i, (dir = 1 - dir))});\n", | |
| " }(i));\n", | |
| " }\n", | |
| "\n", | |
| " function makeAllSortable(parent) {\n", | |
| " parent = parent || document.body;\n", | |
| " var t = parent.getElementsByTagName('table'), i = t.length;\n", | |
| " while (--i >= 0) makeSortable(t[i]);\n", | |
| " }\n", | |
| "\n", | |
| " function addTable() {\n", | |
| " var tableDiv = document.getElementById("tableInsert")\n", | |
| " var table = document.createElement('table')\n", | |
| " var tableHead = document.createElement('thead')\n", | |
| " var tableBody = document.createElement('tbody')\n", | |
| "\n", | |
| " table.appendChild(tableHead)\n", | |
| " table.appendChild(tableBody);\n", | |
| "\n", | |
| " var heading = ["state", "class", "party", "first", "last", "demlead_lastsenate", "demlead_pres2016", "sum", "pvi_2016"];\n", | |
| " var data = [["North Dakota",2012.0,"Democratic","Heidi","Heitkamp",0.9,-35.73,-34.83,-20.85],["West Virginia",2012.0,"Democratic","Joe","Manchin",24.1,-41.68,-17.57,-23.21],["Montana",2012.0,"Democratic","Jon","Tester",3.72,-20.23,-16.51,-12.15],["Indiana",2012.0,"Democratic","Joe","Donnelly",5.74,-19.01,-13.27,-11.02],["Missouri",2012.0,"Democratic","Claire","McCaskill",15.7,-18.51,-2.81,-10.85],["Ohio",2012.0,"Democratic","Sherrod","Brown",6.0,-8.07,-2.07,-5.31],["Wisconsin",2012.0,"Democratic","Tammy","Baldwin",5.55,-0.76,4.78,-1.44],["Pennsylvania",2012.0,"Democratic","Bob","Casey",9.1,-0.72,8.38,-1.42],["Virginia",2012.0,"Democratic","Tim","Kaine",5.91,5.32,11.23,1.78],["Florida",2012.0,"Democratic","Bill","Nelson",13.01,-1.19,11.82,-1.66],["New Mexico",2012.0,"Democratic","Martin","Heinrich",5.73,8.21,13.94,3.61],["Michigan",2012.0,"Democratic","Debbie","Stabenow",20.81,-0.22,20.59,-1.16],["Connecticut",2012.0,"Democratic","Chris","Murphy",12.26,13.64,25.9,6.1],["New Jersey",2012.0,"Democratic","Bob","Menendez",19.44,13.98,33.42,6.24],["Massachusetts",2012.0,"Democratic","Elizabeth","Warren",7.55,27.2,34.75,13.61],["Minnesota",2012.0,"Democratic","Amy","Klobuchar",34.7,1.51,36.22,-0.21],["Washington",2012.0,"Democratic","Maria","Cantwell",20.9,15.71,36.61,7.74],["Rhode Island",2012.0,"Democratic","Sheldon","Whitehouse",29.85,15.51,45.35,7.27],["Delaware",2012.0,"Democratic","Tom","Carper",37.47,11.37,48.84,4.96],["California",2012.0,"Democratic","Dianne","Feinstein",25.05,29.99,55.04,15.09],["Maryland",2012.0,"Democratic","Ben","Cardin",29.65,26.42,56.07,12.97],["Hawaii",2012.0,"Democratic","Mazie","Hirono",25.2,32.18,57.39,16.4],["New York",2012.0,"Democratic","Kirsten","Gillibrand",45.88,22.48,68.36,10.05]];\n", | |
| "\n", | |
| " //TABLE HEAD\n", | |
| " var tr = document.createElement('tr');\n", | |
| " tableHead.appendChild(tr);\n", | |
| " for (i = 0; i < heading.length; i++) {\n", | |
| " var th = document.createElement('th')\n", | |
| " //th.width = '75';\n", | |
| " th.appendChild(document.createTextNode(heading[i]));\n", | |
| " tr.appendChild(th);\n", | |
| " }\n", | |
| "\n", | |
| " //TABLE ROWS\n", | |
| " for (i = 0; i < data.length; i++) {\n", | |
| " var tr = document.createElement('TR');\n", | |
| " for (j = 0; j < data[i].length; j++) {\n", | |
| " var td = document.createElement('TD')\n", | |
| " td.appendChild(document.createTextNode(data[i][j]));\n", | |
| " tr.appendChild(td)\n", | |
| " }\n", | |
| " tableBody.appendChild(tr);\n", | |
| " } \n", | |
| " tableDiv.appendChild(table)\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " window.onload = function () {addTable(); makeAllSortable(); };\n", | |
| " // use callback makeAllSortable(); at end?\n", | |
| " // window.onload = function () {addTable(makeAllSortable); }; \n", | |
| "\n", | |
| " </script>\n", | |
| "\n", | |
| " </body>\n", | |
| " </html>\" style=\"width: 800px; height: 500px; \n", | |
| " display:block; margin: 25px; border: none\"></iframe>\n", | |
| " " | |
| ], | |
| "text/plain": [ | |
| "<IPython.core.display.HTML object>" | |
| ] | |
| }, | |
| "execution_count": 60, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "#Build Dataframe\n", | |
| "temp_df = senate_df[(senate_df['party'] == 'Democratic') &\n", | |
| " (senate_df['class'] == 2012)\n", | |
| " ].sort_values(by='sum', ascending=True) \n", | |
| "temp_df = temp_df[['state', 'class', 'party', 'first', 'last', 'demlead_lastsenate',\n", | |
| " 'demlead_pres2016', 'sum', 'pvi_2016']]\n", | |
| "\n", | |
| "#Build Table\n", | |
| "interactive_table(temp_df, width=800, height=500)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "## Close Senate Seat(s) for Republicans\n", | |
| "\n", | |
| "Relative to the Democrats, Senate Republicans have an easier 2018. Dean Heller's seat in Nevada is the only one in a state that was won by Clinton in 2016, and many of the other seats look pretty safe." | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 61, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<iframe srcdoc=\"\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset="utf-8">\n", | |
| " <style>\n", | |
| "\n", | |
| " /*\n", | |
| " body {\n", | |
| " width: 800px;\n", | |
| " }*/\n", | |
| "\n", | |
| " table {\n", | |
| " font-size: 12px;\n", | |
| " border-collapse: collapse;\n", | |
| " border-top: 1px solid #ddd;\n", | |
| " border-right: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " th {\n", | |
| " padding: 10px;\n", | |
| " cursor: pointer;\n", | |
| " background-color: #f2f2f2;\n", | |
| " }\n", | |
| "\n", | |
| " th, td {\n", | |
| " text-align: left;\n", | |
| " border-bottom: 1px solid #ddd;\n", | |
| " border-left: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " td {\n", | |
| " padding: 5px 8px;\n", | |
| " }\n", | |
| "\n", | |
| " tr:nth-child(even) {\n", | |
| " background-color: #f9f9f9;\n", | |
| " }\n", | |
| "\n", | |
| " tr:hover {\n", | |
| " background-color: #F0F8FF; /*#f9f9f9;*/\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| "\n", | |
| " <body>\n", | |
| "\n", | |
| " <div id ="tableInsert"></div>\n", | |
| "\n", | |
| " <script>\n", | |
| " //http://stackoverflow.com/questions/14267781/sorting-html-table-with-javascript\n", | |
| "\n", | |
| " function sortTable(table, col, reverse) {\n", | |
| " var tb = table.tBodies[0], \n", | |
| " tr = Array.prototype.slice.call(tb.rows, 0), // put rows into array\n", | |
| " i;\n", | |
| "\n", | |
| " reverse = -((+reverse) || -1);\n", | |
| " tr = tr.sort(function (a, b) { \n", | |
| " var first = a.cells[col].textContent.trim();\n", | |
| " var second = b.cells[col].textContent.trim();\n", | |
| "\n", | |
| " if (isNumeric(first) && isNumeric(second)) { \n", | |
| " return reverse * (Number(first) - Number(second));\n", | |
| " } else {\n", | |
| " return reverse * first.localeCompare(second);\n", | |
| " };\n", | |
| " });\n", | |
| " for(i = 0; i < tr.length; ++i) { // append each row in order\n", | |
| " tb.appendChild(tr[i]);\n", | |
| " }\n", | |
| " }\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/18082\n", | |
| " function isNumeric(n) {\n", | |
| " return !isNaN(parseFloat(n)) && isFinite(n);\n", | |
| " }\n", | |
| "\n", | |
| " function makeSortable(table) {\n", | |
| " var th = table.tHead, i;\n", | |
| " th && (th = th.rows[0]) && (th = th.cells);\n", | |
| " if (th) i = th.length;\n", | |
| " else return; // if no `<thead>` then do nothing\n", | |
| " while (--i >= 0) (function (i) {\n", | |
| " var dir = 1;\n", | |
| " th[i].addEventListener('click', function () {sortTable(table, i, (dir = 1 - dir))});\n", | |
| " }(i));\n", | |
| " }\n", | |
| "\n", | |
| " function makeAllSortable(parent) {\n", | |
| " parent = parent || document.body;\n", | |
| " var t = parent.getElementsByTagName('table'), i = t.length;\n", | |
| " while (--i >= 0) makeSortable(t[i]);\n", | |
| " }\n", | |
| "\n", | |
| " function addTable() {\n", | |
| " var tableDiv = document.getElementById("tableInsert")\n", | |
| " var table = document.createElement('table')\n", | |
| " var tableHead = document.createElement('thead')\n", | |
| " var tableBody = document.createElement('tbody')\n", | |
| "\n", | |
| " table.appendChild(tableHead)\n", | |
| " table.appendChild(tableBody);\n", | |
| "\n", | |
| " var heading = ["state", "class", "party", "first", "last", "demlead_lastsenate", "demlead_pres2016", "sum", "pvi_2016"];\n", | |
| " var data = [["Nevada",2012.0,"Republican","Dean","Heller",-1.16,2.42,1.26,0.25],["Arizona",2012.0,"Republican","Jeff","Flake",-3.02,-3.5,-6.53,-2.93],["Texas",2012.0,"Republican","Ted","Cruz",-15.83,-9.0,-24.83,-5.76],["Mississippi",2012.0,"Republican","Roger","Wicker",-16.6,-17.8,-34.41,-10.14],["Nebraska",2012.0,"Republican","Deb","Fischer",-15.55,-25.05,-40.6,-14.59],["Utah",2012.0,"Republican","Orrin","Hatch",-35.33,-17.89,-53.22,-13.43],["Tennessee",2012.0,"Republican","Bob","Corker",-34.48,-26.01,-60.49,-14.68],["Wyoming",2012.0,"Republican","John","Barrasso",-54.0,-46.3,-100.3,-26.75]];\n", | |
| "\n", | |
| " //TABLE HEAD\n", | |
| " var tr = document.createElement('tr');\n", | |
| " tableHead.appendChild(tr);\n", | |
| " for (i = 0; i < heading.length; i++) {\n", | |
| " var th = document.createElement('th')\n", | |
| " //th.width = '75';\n", | |
| " th.appendChild(document.createTextNode(heading[i]));\n", | |
| " tr.appendChild(th);\n", | |
| " }\n", | |
| "\n", | |
| " //TABLE ROWS\n", | |
| " for (i = 0; i < data.length; i++) {\n", | |
| " var tr = document.createElement('TR');\n", | |
| " for (j = 0; j < data[i].length; j++) {\n", | |
| " var td = document.createElement('TD')\n", | |
| " td.appendChild(document.createTextNode(data[i][j]));\n", | |
| " tr.appendChild(td)\n", | |
| " }\n", | |
| " tableBody.appendChild(tr);\n", | |
| " } \n", | |
| " tableDiv.appendChild(table)\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " window.onload = function () {addTable(); makeAllSortable(); };\n", | |
| " // use callback makeAllSortable(); at end?\n", | |
| " // window.onload = function () {addTable(makeAllSortable); }; \n", | |
| "\n", | |
| " </script>\n", | |
| "\n", | |
| " </body>\n", | |
| " </html>\" style=\"width: 800px; height: 275px; \n", | |
| " display:block; margin: 25px; border: none\"></iframe>\n", | |
| " " | |
| ], | |
| "text/plain": [ | |
| "<IPython.core.display.HTML object>" | |
| ] | |
| }, | |
| "execution_count": 61, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "temp_df = senate_df[(senate_df['party'] == 'Republican') &\n", | |
| " (senate_df['class'] == 2012)\n", | |
| " ].sort_values(by='sum', ascending=False) #by= 'demlead_pres2016'\n", | |
| "\n", | |
| "temp_df = temp_df[['state', 'class', 'party', 'first', 'last', 'demlead_lastsenate',\n", | |
| " 'demlead_pres2016', 'sum','pvi_2016']]\n", | |
| "\n", | |
| "#Build Table\n", | |
| "interactive_table(temp_df, width=800, height=275)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": {}, | |
| "source": [ | |
| "# Code for the Visualizations\n", | |
| "\n", | |
| "Below are the two functions for the interactive scatter and tables. I couldn't find a Python library with interactive features that I liked, so I decided to build the basics of my own. The scatter is built with d3.js, and then embedded in an iframe along with the data. I use plain javascript to add interactivity to the tables and then embed it in an iframe as well. \n", | |
| "\n", | |
| "I find this works pretty well, as I have complete control over the visualization, and can copy and paste the iframe wherever it's needed, data included. " | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 47, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "\n", | |
| "def interactive_scatter(df, settings):\n", | |
| " srcdoc = r'''\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset=\"utf-8\">\n", | |
| " <title>Zoom + Pan</title>\n", | |
| " <style>\n", | |
| " \n", | |
| " body {\n", | |
| " position: relative;\n", | |
| " width: 650px; /*960px*/\n", | |
| " }\n", | |
| "\n", | |
| " svg {font: 10px sans-serif;}\n", | |
| "\n", | |
| " rect {fill: #e5e5e5; }\n", | |
| "\n", | |
| " .label {\n", | |
| " font-size: 12px;\n", | |
| " /*stroke: #ddd;*/\n", | |
| " fill: #555;\n", | |
| " }\n", | |
| "\n", | |
| " .dot {\n", | |
| " /*stroke: #aaa;*/\n", | |
| " /*stroke: red;*/\n", | |
| " /*border: 1;*/\n", | |
| " }\n", | |
| " .dot:hover {fill-opacity: 0.4;}\n", | |
| "\n", | |
| " .axis path,\n", | |
| " .axis line {\n", | |
| " stroke: #fff; /*black;*/\n", | |
| " fill: none; \n", | |
| " stroke-width: 1px;\n", | |
| " }\n", | |
| " \n", | |
| " #main-tick{\n", | |
| " fill: none;\n", | |
| " stroke: #777; \n", | |
| " stroke-width: 1px;\n", | |
| " opacity: 1;\n", | |
| " }\n", | |
| "\n", | |
| " .buttons {\n", | |
| " position: absolute;\n", | |
| " right: 30px;\n", | |
| " top: 30px;\n", | |
| " }\n", | |
| " button {\n", | |
| " font: 16px sans-serif;\n", | |
| " display: block;\n", | |
| " border-radius: 0px;\n", | |
| " width: 25px;\n", | |
| " /*outline: none;*/\n", | |
| " /*outline:0;*/\n", | |
| " background-color: white;\n", | |
| " border: none;\n", | |
| " }\n", | |
| " \n", | |
| " button:hover {\n", | |
| " background-image:none;\n", | |
| " background-color:#d5d5d5;\n", | |
| " }\n", | |
| " \n", | |
| " button:focus{ \n", | |
| " /*outline-color: #ddd;\n", | |
| " outline:none;\n", | |
| " outline: 1;*/\n", | |
| " outline-color: #b5b5b5;\n", | |
| " }\n", | |
| " \n", | |
| " div.tooltip {\n", | |
| " position: absolute;\n", | |
| " padding: 5px;\n", | |
| " font: 12px sans-serif;\n", | |
| " background: white;\n", | |
| " border: 0px;\n", | |
| " border-radius: 0px;\n", | |
| " pointer-events:none;\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| " <body>\n", | |
| " \n", | |
| " <div class=\"buttons\">\n", | |
| " <button data-zoom=\"+1\">+</button>\n", | |
| " <button data-zoom=\"-1\">-</button>\n", | |
| " </div>\n", | |
| " <script src=\"//d3js.org/d3.v3.min.js\"></script>\n", | |
| " <script>\n", | |
| "\n", | |
| " var margin = {top: 20, right: 20, bottom: 40, left: 40},\n", | |
| " width = 650 - margin.left - margin.right,\n", | |
| " height = 515 - margin.top - margin.bottom;\n", | |
| "\n", | |
| " var keys = ||keys||;\n", | |
| " var data = ||datainsert||;\n", | |
| " \n", | |
| " var xName = \"||x||\";\n", | |
| " var yName = \"||y||\";\n", | |
| " var xLabel = \"||x_label||\";\n", | |
| " var yLabel = \"||y_label||\";\n", | |
| " \n", | |
| " var min_x = d3.min(data, function(d) { return +d[keys[xName]]; });\n", | |
| " var max_x = d3.max(data, function(d) { return +d[keys[xName]]; });\n", | |
| " var min_y = d3.min(data, function(d) { return +d[keys[yName]]; });\n", | |
| " var max_y = d3.max(data, function(d) { return +d[keys[yName]]; });\n", | |
| " var max = d3.max([min_x, min_y, max_x, max_y].map(Math.abs));\n", | |
| "\n", | |
| " var x = d3.scale.linear()\n", | |
| " .domain([-1.2*max, 1.2*max])\n", | |
| " .range([ 0, width ]);\n", | |
| "\n", | |
| " var y = d3.scale.linear()\n", | |
| " //.domain([min_y - Math.abs(0.2*min_y), max_y + Math.abs(0.2*max_y)])\n", | |
| " .domain([-1.2*max, 1.2*max])\n", | |
| " .range([ height, 0 ]);\n", | |
| "\n", | |
| " var xAxis = d3.svg.axis()\n", | |
| " .scale(x)\n", | |
| " .orient(\"bottom\")\n", | |
| " .ticks(6) //5\n", | |
| " .tickSize(-height);\n", | |
| "\n", | |
| " var yAxis = d3.svg.axis()\n", | |
| " .scale(y)\n", | |
| " .orient(\"left\")\n", | |
| " .ticks(6) //5\n", | |
| " .tickSize(-width); //-width\n", | |
| "\n", | |
| " var zoom = d3.behavior.zoom()\n", | |
| " .x(x)\n", | |
| " .y(y)\n", | |
| " .scaleExtent([1, 10])\n", | |
| " .center([width / 2, height / 2])\n", | |
| " .size([width, height])\n", | |
| " .on(\"zoom\", zoomed);\n", | |
| "\n", | |
| " var svg = d3.select(\"body\").append(\"svg\")\n", | |
| " .attr(\"width\", width + margin.left + margin.right)\n", | |
| " .attr(\"height\", height + margin.top + margin.bottom)\n", | |
| " .append(\"g\")\n", | |
| " .attr(\"transform\", \"translate(\" + margin.left + \",\" + margin.top + \")\")\n", | |
| " .call(zoom);\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/28723551\n", | |
| " //Create clip, then apply it to each dot\n", | |
| " var clip = svg.append(\"defs\").append(\"svg:clipPath\")\n", | |
| " .attr(\"id\", \"clip\")\n", | |
| " .append(\"svg:rect\")\n", | |
| " .attr(\"id\", \"clip-rect\")\n", | |
| " .attr(\"x\", \"0\") //\n", | |
| " .attr(\"y\", \"0\") //\n", | |
| " .attr('width', width)\n", | |
| " .attr('height', height);\n", | |
| "\n", | |
| " svg.append(\"rect\")\n", | |
| " .attr(\"width\", width)\n", | |
| " .attr(\"height\", height);\n", | |
| "\n", | |
| " svg.append(\"g\")\n", | |
| " .attr(\"class\", \"x axis\")\n", | |
| " .attr(\"transform\", \"translate(0,\" + height + \")\")\n", | |
| " .call(xAxis);\n", | |
| "\n", | |
| " svg.append(\"g\")\n", | |
| " .attr(\"class\", \"y axis\")\n", | |
| " .call(yAxis);\n", | |
| "\n", | |
| " d3.selectAll('g.tick')\n", | |
| " .filter(function(d){ return d==0;} )\n", | |
| " .select('line') \n", | |
| " .attr('id', 'main-tick');\n", | |
| "\n", | |
| " // Tooltips\n", | |
| " var div = d3.select(\"body\")\n", | |
| " .append(\"div\") \n", | |
| " .attr(\"class\", \"tooltip\")\n", | |
| " .style(\"opacity\", 0); \n", | |
| "\n", | |
| " svg.selectAll(\".dot\")\n", | |
| " .data(data)\n", | |
| " .enter().append(\"circle\")\n", | |
| " .attr(\"class\", \"dot\")\n", | |
| " .attr(\"clip-path\", \"url(#clip)\") //add the clip to each dot\n", | |
| " .attr(\"r\", 4.0) //3.5 4.5 3*zoom.scale()\n", | |
| " .attr(\"cx\", function(d) { return x(+d[keys[xName]]); })\n", | |
| " .attr(\"cy\", function(d) { return y(+d[keys[yName]]); })\n", | |
| " .style(\"fill\", 'red' ) \n", | |
| " .attr('fill-opacity', 0.6)\n", | |
| " .on(\"mouseover\", function(d) { drawTooltip(d); })\n", | |
| " .on(\"mouseout\", function() {\n", | |
| " div.style(\"opacity\", 0);\n", | |
| " });\n", | |
| "\n", | |
| " svg.append(\"text\")\n", | |
| " .attr(\"class\", \"x label\")\n", | |
| " .attr(\"text-anchor\", \"middle\")\n", | |
| " .attr(\"x\", width/2)\n", | |
| " .attr(\"y\", height + 30)\n", | |
| " .text(\"||x_label||\");\n", | |
| "\n", | |
| " svg.append(\"text\")\n", | |
| " .attr(\"class\", \"y label\")\n", | |
| " .attr(\"text-anchor\", \"middle\")\n", | |
| " .attr(\"x\", -height/2)\n", | |
| " .attr(\"y\", -30) //-30\n", | |
| " .attr(\"transform\", \"rotate(-90)\")\n", | |
| " .text(\"||y_label||\");\n", | |
| "\n", | |
| " d3.selectAll(\"button[data-zoom]\")\n", | |
| " .on(\"click\", clicked);\n", | |
| "\n", | |
| " function zoomed() {\n", | |
| " svg.select(\".x.axis\").call(xAxis);\n", | |
| " svg.select(\".y.axis\").call(yAxis);\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/37573228\n", | |
| " svg.selectAll(\".dot\")\n", | |
| " //.attr(\"r\", 3*zoom.scale())\n", | |
| " .attr(\"cx\", function (d) {\n", | |
| " return x(+d[keys[xName]]);\n", | |
| " })\n", | |
| " .attr(\"cy\", function (d) {\n", | |
| " return y(+d[keys[yName]]);\n", | |
| " });\n", | |
| "\n", | |
| " d3.selectAll('g.tick')\n", | |
| " .filter(function(d){ return d==0;} )\n", | |
| " .select('line') //grab the tick line\n", | |
| " .attr('id', 'main-tick');\n", | |
| " }\n", | |
| "\n", | |
| " function clicked() {\n", | |
| " svg.call(zoom.event); // https://github.com/mbostock/d3/issues/2387\n", | |
| "\n", | |
| " // Record the coordinates (in data space) of the center (in screen space).\n", | |
| " var center0 = zoom.center(), translate0 = zoom.translate(), coordinates0 = coordinates(center0);\n", | |
| " zoom.scale(zoom.scale() * Math.pow(2, +this.getAttribute(\"data-zoom\")));\n", | |
| "\n", | |
| " // Translate back to the center.\n", | |
| " var center1 = point(coordinates0);\n", | |
| " zoom.translate([translate0[0] + center0[0] - center1[0], translate0[1] + center0[1] - center1[1]]);\n", | |
| "\n", | |
| " svg.transition().duration(750).call(zoom.event);\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " function coordinates(point) {\n", | |
| " var scale = zoom.scale(), translate = zoom.translate();\n", | |
| " return [(point[0] - translate[0]) / scale, (point[1] - translate[1]) / scale];\n", | |
| " }\n", | |
| "\n", | |
| " function point(coordinates) {\n", | |
| " var scale = zoom.scale(), translate = zoom.translate();\n", | |
| " return [coordinates[0] * scale + translate[0], coordinates[1] * scale + translate[1]];\n", | |
| " }\n", | |
| "\n", | |
| " function drawTooltip(d) {\n", | |
| " div.style(\"opacity\", 1.0);\n", | |
| " div.html(||tooltip||)\n", | |
| " .style(\"left\", (d3.event.pageX) + \"px\")\n", | |
| " .style(\"top\", (d3.event.pageY ) + \"px\");\n", | |
| " }\n", | |
| "\n", | |
| " </script>\n", | |
| " </body>\n", | |
| " </html>\n", | |
| " ''' \n", | |
| "\n", | |
| " width=960\n", | |
| " height=600\n", | |
| "\n", | |
| " srcdoc = srcdoc.replace('||datainsert||', df.to_json(orient=\"values\"))\n", | |
| " \n", | |
| " key_list = list(df)\n", | |
| " key_dict = {i: key_list.index(i) for i in key_list}\n", | |
| " srcdoc = srcdoc.replace('||keys||', json.dumps(key_dict) )\n", | |
| " \n", | |
| " for s in settings.keys():\n", | |
| " srcdoc = srcdoc.replace('||{0}||'.format(s), str(settings[s]))\n", | |
| " \n", | |
| " srcdoc = srcdoc.replace('\"', '"')\n", | |
| "\n", | |
| " embed = HTML('<iframe srcdoc=\"{0}\" '\n", | |
| " 'style=\"width: {1}px; height: {2}px; display:block; width: 100%; margin: 25px auto; '\n", | |
| " 'border: none\"></iframe>'.format(srcdoc, width, height))\n", | |
| " return embed\n", | |
| "\n" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 57, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "\n", | |
| "def interactive_table(df, width, height):\n", | |
| " srcdoc = r'''\n", | |
| " <!DOCTYPE html>\n", | |
| " <html>\n", | |
| " <head>\n", | |
| " <meta charset=\"utf-8\">\n", | |
| " <style>\n", | |
| "\n", | |
| " /*\n", | |
| " body {\n", | |
| " width: 800px;\n", | |
| " }*/\n", | |
| "\n", | |
| " table {\n", | |
| " font-size: 12px;\n", | |
| " border-collapse: collapse;\n", | |
| " border-top: 1px solid #ddd;\n", | |
| " border-right: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " th {\n", | |
| " padding: 10px;\n", | |
| " cursor: pointer;\n", | |
| " background-color: #f2f2f2;\n", | |
| " }\n", | |
| "\n", | |
| " th, td {\n", | |
| " text-align: left;\n", | |
| " border-bottom: 1px solid #ddd;\n", | |
| " border-left: 1px solid #ddd;\n", | |
| " }\n", | |
| "\n", | |
| " td {\n", | |
| " padding: 5px 8px;\n", | |
| " }\n", | |
| "\n", | |
| " tr:nth-child(even) {\n", | |
| " background-color: #f9f9f9;\n", | |
| " }\n", | |
| "\n", | |
| " tr:hover {\n", | |
| " background-color: #F0F8FF; /*#f9f9f9;*/\n", | |
| " }\n", | |
| "\n", | |
| " </style>\n", | |
| " </head>\n", | |
| "\n", | |
| " <body>\n", | |
| "\n", | |
| " <div id =\"tableInsert\"></div>\n", | |
| "\n", | |
| " <script>\n", | |
| " //http://stackoverflow.com/questions/14267781/sorting-html-table-with-javascript\n", | |
| "\n", | |
| " function sortTable(table, col, reverse) {\n", | |
| " var tb = table.tBodies[0], \n", | |
| " tr = Array.prototype.slice.call(tb.rows, 0), // put rows into array\n", | |
| " i;\n", | |
| "\n", | |
| " reverse = -((+reverse) || -1);\n", | |
| " tr = tr.sort(function (a, b) { \n", | |
| " var first = a.cells[col].textContent.trim();\n", | |
| " var second = b.cells[col].textContent.trim();\n", | |
| "\n", | |
| " if (isNumeric(first) && isNumeric(second)) { \n", | |
| " return reverse * (Number(first) - Number(second));\n", | |
| " } else {\n", | |
| " return reverse * first.localeCompare(second);\n", | |
| " };\n", | |
| " });\n", | |
| " for(i = 0; i < tr.length; ++i) { // append each row in order\n", | |
| " tb.appendChild(tr[i]);\n", | |
| " }\n", | |
| " }\n", | |
| "\n", | |
| " //http://stackoverflow.com/questions/18082\n", | |
| " function isNumeric(n) {\n", | |
| " return !isNaN(parseFloat(n)) && isFinite(n);\n", | |
| " }\n", | |
| "\n", | |
| " function makeSortable(table) {\n", | |
| " var th = table.tHead, i;\n", | |
| " th && (th = th.rows[0]) && (th = th.cells);\n", | |
| " if (th) i = th.length;\n", | |
| " else return; // if no `<thead>` then do nothing\n", | |
| " while (--i >= 0) (function (i) {\n", | |
| " var dir = 1;\n", | |
| " th[i].addEventListener('click', function () {sortTable(table, i, (dir = 1 - dir))});\n", | |
| " }(i));\n", | |
| " }\n", | |
| "\n", | |
| " function makeAllSortable(parent) {\n", | |
| " parent = parent || document.body;\n", | |
| " var t = parent.getElementsByTagName('table'), i = t.length;\n", | |
| " while (--i >= 0) makeSortable(t[i]);\n", | |
| " }\n", | |
| "\n", | |
| " function addTable() {\n", | |
| " var tableDiv = document.getElementById(\"tableInsert\")\n", | |
| " var table = document.createElement('table')\n", | |
| " var tableHead = document.createElement('thead')\n", | |
| " var tableBody = document.createElement('tbody')\n", | |
| "\n", | |
| " table.appendChild(tableHead)\n", | |
| " table.appendChild(tableBody);\n", | |
| "\n", | |
| " var heading = ||headinginsert||;\n", | |
| " var data = ||datainsert||;\n", | |
| "\n", | |
| " //TABLE HEAD\n", | |
| " var tr = document.createElement('tr');\n", | |
| " tableHead.appendChild(tr);\n", | |
| " for (i = 0; i < heading.length; i++) {\n", | |
| " var th = document.createElement('th')\n", | |
| " //th.width = '75';\n", | |
| " th.appendChild(document.createTextNode(heading[i]));\n", | |
| " tr.appendChild(th);\n", | |
| " }\n", | |
| "\n", | |
| " //TABLE ROWS\n", | |
| " for (i = 0; i < data.length; i++) {\n", | |
| " var tr = document.createElement('TR');\n", | |
| " for (j = 0; j < data[i].length; j++) {\n", | |
| " var td = document.createElement('TD')\n", | |
| " td.appendChild(document.createTextNode(data[i][j]));\n", | |
| " tr.appendChild(td)\n", | |
| " }\n", | |
| " tableBody.appendChild(tr);\n", | |
| " } \n", | |
| " tableDiv.appendChild(table)\n", | |
| "\n", | |
| " }\n", | |
| "\n", | |
| " window.onload = function () {addTable(); makeAllSortable(); };\n", | |
| " // use callback makeAllSortable(); at end?\n", | |
| " // window.onload = function () {addTable(makeAllSortable); }; \n", | |
| "\n", | |
| " </script>\n", | |
| "\n", | |
| " </body>\n", | |
| " </html>'''\n", | |
| "\n", | |
| " srcdoc = srcdoc.replace('||headinginsert||', json.dumps(list(df)))\n", | |
| " srcdoc = srcdoc.replace('||datainsert||', df.to_json(orient=\"values\"))\n", | |
| " srcdoc = srcdoc.replace('\"', '"')\n", | |
| "\n", | |
| " html = '''<iframe srcdoc=\"{0}\" style=\"width: {1}px; height: {2}px; \n", | |
| " display:block; margin: 25px; border: none\"></iframe>\n", | |
| " '''.format(srcdoc, width, height) #width: 100%; margin: 25px auto;\n", | |
| "\n", | |
| " embed = HTML(html)\n", | |
| " return embed\n", | |
| " " | |
| ] | |
| } | |
| ], | |
| "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.5.2" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 0 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment