{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "

\"FT

\n", "

Saint Paul (MN) Mayor Election Voting Report [Data Only]:
\n", " Report Completed 07/31/19

\n", "

By Frogtown Crusader (Abu Nayeem)

" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Table of contents \n", "\n", "* [Brief Introduction](#intro)\n", "* [About Saint Paul Open Data Initiative](#opendata)\n", "* [Reader Note](#reader)\n", "* [Section I: Data Analysis](#sect1)\n", " * [About Data](#aboutdata)\n", " * [Data Assumptions](#data_assumption)\n", " * [Voter Age Demographics](#demo)\n", " * [Voting Trends](#trend)\n", " * [Youth/ Ward Votes](#youth)\n", " * [Precinct Analysis: Fragmentation](#precinct)\n", " * [Ward 1](#ward1)\n", " * [Ward 2](#ward2)\n", " * [Ward 3](#ward3)\n", " * [Ward 4](#ward4)\n", " * [Ward 5](#ward5)\n", " * [Ward 6](#ward6)\n", " * [Ward 7](#ward7)\n", "* [Run Code](#code)\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Brief Introduction \n", "\n", "In this report, I will be using Minnesota Voting Data/Records to show insight on the 2017 Saint Paul mayoral elections as well to illustrate systemic inequities. As part of the Saint Paul Open-Data Project, the coding will be accessible to everyone. This is **only a data report**, the qualitative and solution portion was excluded so readers can come up with their own conclusions. \n", "\n", "1. **Data Analysis [Informational]**: Include voting rate for different elections, Ward analysis, Youth voter rate, and Precinct fragmentation analysis\n", "\n", "**Disclaimer:** I am running for Saint Paul city council for Ward 1 (election on November 5th, 2019). One core feature of the Citizen-First campaign is to educate citizens about current systemic inequities and local issues so we can work on them together. I have decided to create an open data report for **_all of Saint Paul (not just my Ward)_**, so citizens and candidates throughout the city have discussions on systematic voter suppression, and take active actions in addressing it. \n" ] }, { "cell_type": "markdown", "metadata": { "heading_collapsed": true }, "source": [ "### Saint Paul Open Data Initiative \n", "\n", "This initiative focuses on taking public information/data from municipalities and organizations to create interactive reports and analysis to better inform and assist community members to take action. This is an open-source project meaning that all coding is accessible to everyone, and thus there is transparency on the results. It is currently all python-based. As always, I encourage other programmers and developers to participate in making this more accessible. You can learn more information on the project [Github](https://github.com/sustainabu/OpenData_Saint_Paul) page as well as accessing documents.\n", "\n", "Unlike my previous reports, the Minnesota voting records is not publicly available, but is publicly accessible. I will not provide the raw data on the project page as it contains sensitive personal information, you can contact the Minnesota Secretary of State for the voting records [here](https://www.sos.state.mn.us/media/2641/registered-voter-list-request-form.pdf), which also includes the columns provided. \n", "\n", "\n", "**If you use any material/graphs from the report, please give credit to me and the project**\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Reader's Note \n", "\n", "There are a few questions that I want you to consider when reviewing the data analysis:\n", "\n", "1. Why does our local elections matter?\n", "2. Who benefits from the current system and who doesn't? \n", "3. What can we do about it?\n", "\n", "Here are some FACTS (i.e. data results) from the 2017 Mayoral Elections to get you motivated to read further\n", "\n", "\"Drawing\"\n", "\n", "* During the last presidential election, registered voter turnout was 78%, while the 2017 mayoral election average around 36%, with Ward 3 voter turnout was close to 50%\n", "* Despite younger adults being the largest demographic, it is the senior citizens who vote disproportionately more. \n", "* The 18-20 age group voting percentage for the mayoral election was around 13% \n", "* 32 out of 95 voting precincts are under-representated (less than 75% representation). See Map Below\n", "\n" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Section I: Data Analysis " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### About the Data: \n", "\n", "The data is taken from Minnesota voting records and the data was current of 6/24/2019 as indicated in the picture below. There are two datasets in the CD: Voter profile and Voting Records. This is the bare basic voting information obtained from the state that it is utilized by most campaigns. In addition, I got geojson file for my map [here](https://www.sos.state.mn.us/election-administration-campaigns/data-maps/geojson-files/)\n", "\n", "\"Drawing\"\n", "\n", "\n", "### Background: \n", "\n", "As a Saint Paul resident, I am represented by different layers of governance, whom I can vote for during an election. The layers of governance can be broken down to four categories: Federal, State, County, and Local. **Only the local city election occur during the odd calendar years**. The other government roles have the elections on even years and the available open seats are staggered. In Saint Paul, the city council elections shares the staggered term of the school board. The Saint Paul City Council member term is four years and is not staggered. In contrast, the sister city, Minneapolis, has the mayoral and city council election occurs at the same time calendar year, which will be used for comparison.\n", "\n", "The last four more major elections in Saint Paul:\n", "\n", "* 2018: Governor, Senator\n", "* 2017: Mayor\n", "* 2016: Presidential \n", "* 2015: City Council\n", "\n", "All of these governmental bodies are interconnected providing services/representing citizens directly. Within Saint Paul’s Ward 1, there are 4 state representatives, 3 county commissioners, and 3 state senators. In other words, there is considerable overlap between agencies based on living location. The Saint Paul city council is the legislative board of the city, totaling 7 council members for each Ward, which holds roughly 41,000 people respectively. The ward can be further broken down even further into non-elected district planning councils that represent neighborhoods areas, and serve an essential role for the city's comprehensive development plan. \n", "\n", "\"Drawing\"\n", "\n", "From the map above, we can see there is potential **fragmentation**, where certain pockets of a neighborhood may be isolated. I will be implementing a precinct analysis, to find which precincts are under-represented compared to surrounding precincts in the ward. \n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Data Assumptions: \n", "\n", "**Assumptions:** \n", "The raw data contains the records of registered voters, so there might be some voters whom that have not registered within and/or outside Saint Paul. In addition, some voters may likely be deceased (i.e. there are 120 year olds), and their voter information has not been removed from the records. In both cases, the numbers are negligible and substantial data cleaning is unnecessary for this report.\n", "\n", "Methodology:\n", "\n", "1) **Time Sensitivity on Registered Voters:** It is sensitive to time, especially within the last three years. Time sensitivity is less for older populations as there is numerous years giving accurate number on the total potentional registered voters. It is recommended to do a youth analysis, after at least one major federal/state elections \n", "\n", "2) **Finding the approximate age of registered voters:** For each registered voter, the year for date of birth was provided, which was used to determine their relative age. The actual age is important for 18 year olds, as they are not able to vote if they turn 18 after a general election, so they have 1/6 less representation\n", "\n", "3) **Finding the number of potential registered voters at a given election year:** This is done through a post-hoc method where I take the voter registration of succeeding elections to determine the number of people in the age group that could have voted. This is similar to the time sensitivity\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Age/Voter Demographics: \n", "\n", "First, let’s explore the age demographic relationship between Saint Paul and Minneapolis as these two cities are closely connected. From the plots below, we see that Minneapolis has greater concentration of younger voters than Saint Paul, and the total number of voters are higher in general. For both cities, the younger adults make up the bulk of voting population.\n", "\n", "\"Drawing\"\n", "\n", "\"Drawing\"\n", "\n", "When plotting the age distribution of each wards within Saint Paul, Ward 3 differs by having a more even age distribution as demonstrated below. \n", "\n", "\"Drawing\"\n", "\n", "Finally, if we break down voter registration by ward, we see that Ward 3 has the most registered voters with around 50% more registered voters than Ward 5 & 6 respectively. It is important to note: the normalized weighting metric that will be used expects the Ward 3 will vote more since they have more registered voters. \n", "\n", "\"Drawing\"\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Voting Trends: \n", "\n", "As explained in the Background section, local elections are only during the odd years. As many would expect, the turnout is low for local elections\n", "\n", "\"Drawing\"\n", "\n", "The following graph below compares participation on city council election of Saint Paul and Minneapolis.\n", "\n", "\"Drawing\"\n", "\n", "Finally, the graph below plots the voter participation rate by age group. Notice, the Saint Paul young adult participation is low despite being the larger demographic and Minneapolis has considerable voter turnout for their local election, which is probably directly related to having the mayoral and city council election at the same time.\n", "\n", "\"Drawing\"\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward/Youth Vote: \n", " \n", "From the following tables below we see the voting and youth participation significantly less for the city council and mayoral election in comparison to the presidential election. The competitive wards, highlighted in yellow, have greater voter turnout. Though Ward 3 had a moderate turnout despite not being a competitive race. Note: I used Google Sheet because it has conditional color formating. \n", "\n", "\"Drawing\"\n", "\n", "Mayor Information is below:\n", "\n", "\"Drawing\"" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Ward/Precinct Analysis: Fragmentation \n", "\n", "\n", "**Ward Analysis**\n", "\n", "For my analysis, it is assumed that each precinct should vote at equal rate in comparison to neighboring wards. For each ward, I create some column calculations:\n", "\n", "* **Projected Weight:** (The total registered voters within Ward) / (The total registered voters)\n", "* **Actual Weight:** (The total actual votes within Ward) / (The total actual voters)\n", "* **Representation:** (Actual Weight) - (Projected Weight)\n", "* **H_Density%:**: The percentage of registered voters that live in an address with 10 or more people\n", "* **H_Density_Vote%:**: The voting rate for residents living in dense areas\n", "* **L_Density_Votes%:**: The voting rate for residents living in non-dense areas (less than 10 people in household)\n", " \n", "Ideally, the \"Representation\" should be near zero across the wards. However, the base weight favors those Wards that have greater number of registered voters. We see that Ward 3 and Ward 4 are over-represented in the mayoral race. Over 25% of the vote for the Mayoral election came from Ward 3 alone. There is a voting gap for renters ranging minimum for 10%. Many renters may not even register to vote if they are staying in a location for short period of time.\n", "\n", "\n" ] }, { "cell_type": "code", "execution_count": 54, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardTot_RegisterTot_VotesTot_Vote%H_Density%H_Density_Vote%L_Density_Vote%Representation
01.0214207470.034.8721.0026.7737.03-0.51
12.0264999056.034.1738.7928.4637.80-0.95
23.02863914232.049.6920.9631.4854.536.55
34.02598911090.042.6724.6524.7848.522.84
45.0196716182.031.4315.1017.5733.89-1.63
56.0191415247.027.418.0219.9328.06-2.89
67.0203235376.026.4516.4016.3628.43-3.40
\n", "
" ], "text/plain": [ " Ward Tot_Register Tot_Votes Tot_Vote% H_Density% H_Density_Vote% \\\n", "0 1.0 21420 7470.0 34.87 21.00 26.77 \n", "1 2.0 26499 9056.0 34.17 38.79 28.46 \n", "2 3.0 28639 14232.0 49.69 20.96 31.48 \n", "3 4.0 25989 11090.0 42.67 24.65 24.78 \n", "4 5.0 19671 6182.0 31.43 15.10 17.57 \n", "5 6.0 19141 5247.0 27.41 8.02 19.93 \n", "6 7.0 20323 5376.0 26.45 16.40 16.36 \n", "\n", " L_Density_Vote% Representation \n", "0 37.03 -0.51 \n", "1 37.80 -0.95 \n", "2 54.53 6.55 \n", "3 48.52 2.84 \n", "4 33.89 -1.63 \n", "5 28.06 -2.89 \n", "6 28.43 -3.40 " ] }, "execution_count": 54, "metadata": {}, "output_type": "execute_result" } ], "source": [ "W_15" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\n", "**Precinct Analysis**\n", "\n", "For my analysis, it is assumed that each precinct should vote at equal rate in comparison to neighboring precincts. For each precinct, I create some column calculations:\n", "\n", "* **Projected Weight:** (The total registered voters on precinct) / (The total registered voters)\n", "* **Actual Weight:** (The total actual votes on precinct) / (The total actual voters)\n", "* **Representation%:** (Actual Weight/ Projected Weight) x 100\n", "* **H_Density%:**: The percentage of registered voters that live in an address with 10 or more people\n", "* **H_Density_Vote%%:**: The voting rate for residents living in dense areas\n", "* **L_Density_Votes%:**: The voting rate for residents living in non-dense areas (less than 10 people in household)\n", "\n", "For \"Representation%, I've normalized the data to see the representation of turnout for voting precinct. Ideally, this percentage should be 100% for each district. Once again, the base weight favors those precincts that have greater number of registered voters. " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward 1 Precinct Analysis \n", "\n", "\"Drawing\"\n" ] }, { "cell_type": "code", "execution_count": 55, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%H_Density_Vote%L_Density_Vote%Representation%
01.0Saint Paul W-1 P-1639.0116155.0415.4236.3158.45151.39
11.0Saint Paul W-1 P-1097.045021.5615.3320.2921.7860.71
21.0Saint Paul W-1 P-11293.0111126.3741.3127.2325.7772.46
31.0Saint Paul W-1 P-12162.033548.3631.6439.6252.40133.33
41.0Saint Paul W-1 P-13518.0115045.0426.7839.6147.03123.94
51.0Saint Paul W-1 P-14288.096129.9729.1437.5026.8783.05
61.0Saint Paul W-1 P-15162.072222.4411.2218.5222.9362.22
71.0Saint Paul W-1 P-1677.023832.358.824.7635.0286.67
81.0Saint Paul W-1 P-2786.0215936.4133.4020.6744.30100.00
91.0Saint Paul W-1 P-3568.0184430.809.719.5033.0985.09
101.0Saint Paul W-1 P-4414.0135030.671.335.5631.0185.54
111.0Saint Paul W-1 P-5420.0132431.726.5713.7932.9887.80
121.0Saint Paul W-1 P-61004.0271736.9510.4520.4238.88101.79
131.0Saint Paul W-1 P-7698.0148147.1316.8126.9151.22129.35
141.0Saint Paul W-1 P-8821.0214738.2455.2431.4546.62105.26
151.0Saint Paul W-1 P-9523.0227023.0411.9414.0224.2663.57
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density% \\\n", "0 1.0 Saint Paul W-1 P-1 639.0 1161 55.04 15.42 \n", "1 1.0 Saint Paul W-1 P-10 97.0 450 21.56 15.33 \n", "2 1.0 Saint Paul W-1 P-11 293.0 1111 26.37 41.31 \n", "3 1.0 Saint Paul W-1 P-12 162.0 335 48.36 31.64 \n", "4 1.0 Saint Paul W-1 P-13 518.0 1150 45.04 26.78 \n", "5 1.0 Saint Paul W-1 P-14 288.0 961 29.97 29.14 \n", "6 1.0 Saint Paul W-1 P-15 162.0 722 22.44 11.22 \n", "7 1.0 Saint Paul W-1 P-16 77.0 238 32.35 8.82 \n", "8 1.0 Saint Paul W-1 P-2 786.0 2159 36.41 33.40 \n", "9 1.0 Saint Paul W-1 P-3 568.0 1844 30.80 9.71 \n", "10 1.0 Saint Paul W-1 P-4 414.0 1350 30.67 1.33 \n", "11 1.0 Saint Paul W-1 P-5 420.0 1324 31.72 6.57 \n", "12 1.0 Saint Paul W-1 P-6 1004.0 2717 36.95 10.45 \n", "13 1.0 Saint Paul W-1 P-7 698.0 1481 47.13 16.81 \n", "14 1.0 Saint Paul W-1 P-8 821.0 2147 38.24 55.24 \n", "15 1.0 Saint Paul W-1 P-9 523.0 2270 23.04 11.94 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "0 36.31 58.45 151.39 \n", "1 20.29 21.78 60.71 \n", "2 27.23 25.77 72.46 \n", "3 39.62 52.40 133.33 \n", "4 39.61 47.03 123.94 \n", "5 37.50 26.87 83.05 \n", "6 18.52 22.93 62.22 \n", "7 4.76 35.02 86.67 \n", "8 20.67 44.30 100.00 \n", "9 9.50 33.09 85.09 \n", "10 5.56 31.01 85.54 \n", "11 13.79 32.98 87.80 \n", "12 20.42 38.88 101.79 \n", "13 26.91 51.22 129.35 \n", "14 31.45 46.62 105.26 \n", "15 14.02 24.26 63.57 " ] }, "execution_count": 55, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15.query('Ward==1')" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct(1)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward 2 Precinct Analysis\n", "\n", "\"Drawing\"\n", "\n", "[Additional Map Link](https://www.ramseycounty.us/sites/default/files/Elections%20and%20Voting/Maps/Saint%20Paul%20maps/Saint%20Paul%202019%20maps/Saint%20Paul%20Ward%202_5.25.pdf)\n" ] }, { "cell_type": "code", "execution_count": 57, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%H_Density_Vote%L_Density_Vote%Representation%
162.0Saint Paul W-2 P-1790.0159849.4418.6527.8554.38136.36
172.0Saint Paul W-2 P-11842.0286429.4099.1629.4029.1781.36
182.0Saint Paul W-2 P-13563.0153336.7323.9427.5239.62101.05
192.0Saint Paul W-2 P-14453.0169826.684.9511.9027.4573.33
202.0Saint Paul W-2 P-15531.0267419.8613.6117.0320.3055.15
212.0Saint Paul W-2 P-2826.0170048.5916.4736.7950.92134.29
222.0Saint Paul W-2 P-3865.0261933.0322.1116.5837.7090.74
232.0Saint Paul W-2 P-4626.0154840.4430.1029.4045.19111.46
242.0Saint Paul W-2 P-5894.0236837.7515.8429.8739.24104.11
252.0Saint Paul W-2 P-6209.061434.0473.6234.5132.7294.74
262.0Saint Paul W-2 P-7747.0221333.7650.7528.5039.1792.70
272.0Saint Paul W-2 P-8324.0123326.2883.3722.2846.3472.37
282.0Saint Paul W-2 P-9700.0201934.6795.7434.8231.4095.20
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density% \\\n", "16 2.0 Saint Paul W-2 P-1 790.0 1598 49.44 18.65 \n", "17 2.0 Saint Paul W-2 P-11 842.0 2864 29.40 99.16 \n", "18 2.0 Saint Paul W-2 P-13 563.0 1533 36.73 23.94 \n", "19 2.0 Saint Paul W-2 P-14 453.0 1698 26.68 4.95 \n", "20 2.0 Saint Paul W-2 P-15 531.0 2674 19.86 13.61 \n", "21 2.0 Saint Paul W-2 P-2 826.0 1700 48.59 16.47 \n", "22 2.0 Saint Paul W-2 P-3 865.0 2619 33.03 22.11 \n", "23 2.0 Saint Paul W-2 P-4 626.0 1548 40.44 30.10 \n", "24 2.0 Saint Paul W-2 P-5 894.0 2368 37.75 15.84 \n", "25 2.0 Saint Paul W-2 P-6 209.0 614 34.04 73.62 \n", "26 2.0 Saint Paul W-2 P-7 747.0 2213 33.76 50.75 \n", "27 2.0 Saint Paul W-2 P-8 324.0 1233 26.28 83.37 \n", "28 2.0 Saint Paul W-2 P-9 700.0 2019 34.67 95.74 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "16 27.85 54.38 136.36 \n", "17 29.40 29.17 81.36 \n", "18 27.52 39.62 101.05 \n", "19 11.90 27.45 73.33 \n", "20 17.03 20.30 55.15 \n", "21 36.79 50.92 134.29 \n", "22 16.58 37.70 90.74 \n", "23 29.40 45.19 111.46 \n", "24 29.87 39.24 104.11 \n", "25 34.51 32.72 94.74 \n", "26 28.50 39.17 92.70 \n", "27 22.28 46.34 72.37 \n", "28 34.82 31.40 95.20 " ] }, "execution_count": 57, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15.query('Ward==2')" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct(2)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward 3 Precinct Analysis \n", "\n", "\"Drawing\"" ] }, { "cell_type": "code", "execution_count": 58, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%H_Density_Vote%L_Density_Vote%Representation%
293.0Saint Paul W-3 P-11212.0206558.693.7830.7759.79161.72
303.0Saint Paul W-3 P-10854.0148157.664.8644.4458.34158.70
313.0Saint Paul W-3 P-11489.0194125.1970.7928.3817.4669.17
323.0Saint Paul W-3 P-12975.0177954.8112.4824.7759.09150.91
333.0Saint Paul W-3 P-13972.0184452.7119.5845.4354.48145.61
343.0Saint Paul W-3 P-141892.0359052.706.0255.0952.55145.50
353.0Saint Paul W-3 P-21368.0248155.147.5821.8157.87152.29
363.0Saint Paul W-3 P-31309.0271548.2122.7635.2852.03132.74
373.0Saint Paul W-3 P-4666.0132550.2640.0834.8460.58139.02
383.0Saint Paul W-3 P-5748.0193038.7655.1831.2747.98107.56
393.0Saint Paul W-3 P-61062.0212949.889.3927.5052.20137.12
403.0Saint Paul W-3 P-7525.0126541.5048.6224.3957.69115.38
413.0Saint Paul W-3 P-8883.0159955.225.2519.0557.23152.53
423.0Saint Paul W-3 P-91277.0249551.1815.2328.4255.27141.56
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density% \\\n", "29 3.0 Saint Paul W-3 P-1 1212.0 2065 58.69 3.78 \n", "30 3.0 Saint Paul W-3 P-10 854.0 1481 57.66 4.86 \n", "31 3.0 Saint Paul W-3 P-11 489.0 1941 25.19 70.79 \n", "32 3.0 Saint Paul W-3 P-12 975.0 1779 54.81 12.48 \n", "33 3.0 Saint Paul W-3 P-13 972.0 1844 52.71 19.58 \n", "34 3.0 Saint Paul W-3 P-14 1892.0 3590 52.70 6.02 \n", "35 3.0 Saint Paul W-3 P-2 1368.0 2481 55.14 7.58 \n", "36 3.0 Saint Paul W-3 P-3 1309.0 2715 48.21 22.76 \n", "37 3.0 Saint Paul W-3 P-4 666.0 1325 50.26 40.08 \n", "38 3.0 Saint Paul W-3 P-5 748.0 1930 38.76 55.18 \n", "39 3.0 Saint Paul W-3 P-6 1062.0 2129 49.88 9.39 \n", "40 3.0 Saint Paul W-3 P-7 525.0 1265 41.50 48.62 \n", "41 3.0 Saint Paul W-3 P-8 883.0 1599 55.22 5.25 \n", "42 3.0 Saint Paul W-3 P-9 1277.0 2495 51.18 15.23 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "29 30.77 59.79 161.72 \n", "30 44.44 58.34 158.70 \n", "31 28.38 17.46 69.17 \n", "32 24.77 59.09 150.91 \n", "33 45.43 54.48 145.61 \n", "34 55.09 52.55 145.50 \n", "35 21.81 57.87 152.29 \n", "36 35.28 52.03 132.74 \n", "37 34.84 60.58 139.02 \n", "38 31.27 47.98 107.56 \n", "39 27.50 52.20 137.12 \n", "40 24.39 57.69 115.38 \n", "41 19.05 57.23 152.53 \n", "42 28.42 55.27 141.56 " ] }, "execution_count": 58, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15.query('Ward==3')" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct(3)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward 4 Precinct Analysis\n", "\n", "\"Drawing\"" ] }, { "cell_type": "code", "execution_count": 59, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%H_Density_Vote%L_Density_Vote%Representation%
434.0Saint Paul W-4 P-1791.0162148.8017.8927.5953.42135.00
444.0Saint Paul W-4 P-10991.0202548.948.9935.7150.24135.20
454.0Saint Paul W-4 P-111025.0220246.5516.8521.8351.56128.68
464.0Saint Paul W-4 P-12564.0170333.1258.9022.6348.1491.43
474.0Saint Paul W-4 P-13580.0148838.9822.7224.2643.30107.61
484.0Saint Paul W-4 P-14648.0144444.884.165.0046.60123.60
494.0Saint Paul W-4 P-15707.0153146.188.1014.5248.97127.37
504.0Saint Paul W-4 P-2766.0130358.798.8355.6559.09161.73
514.0Saint Paul W-4 P-3734.0232131.6273.5927.8142.2586.81
524.0Saint Paul W-4 P-4827.0181445.597.2822.7347.38125.89
534.0Saint Paul W-4 P-5608.0133445.588.7723.9347.66125.30
544.0Saint Paul W-4 P-6420.0146828.6154.2915.0644.7179.12
554.0Saint Paul W-4 P-7925.0184550.1416.9620.1356.27138.60
564.0Saint Paul W-4 P-8911.0220941.2413.4918.7944.74113.14
574.0Saint Paul W-4 P-9593.0168135.2833.1435.0135.4197.12
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density% \\\n", "43 4.0 Saint Paul W-4 P-1 791.0 1621 48.80 17.89 \n", "44 4.0 Saint Paul W-4 P-10 991.0 2025 48.94 8.99 \n", "45 4.0 Saint Paul W-4 P-11 1025.0 2202 46.55 16.85 \n", "46 4.0 Saint Paul W-4 P-12 564.0 1703 33.12 58.90 \n", "47 4.0 Saint Paul W-4 P-13 580.0 1488 38.98 22.72 \n", "48 4.0 Saint Paul W-4 P-14 648.0 1444 44.88 4.16 \n", "49 4.0 Saint Paul W-4 P-15 707.0 1531 46.18 8.10 \n", "50 4.0 Saint Paul W-4 P-2 766.0 1303 58.79 8.83 \n", "51 4.0 Saint Paul W-4 P-3 734.0 2321 31.62 73.59 \n", "52 4.0 Saint Paul W-4 P-4 827.0 1814 45.59 7.28 \n", "53 4.0 Saint Paul W-4 P-5 608.0 1334 45.58 8.77 \n", "54 4.0 Saint Paul W-4 P-6 420.0 1468 28.61 54.29 \n", "55 4.0 Saint Paul W-4 P-7 925.0 1845 50.14 16.96 \n", "56 4.0 Saint Paul W-4 P-8 911.0 2209 41.24 13.49 \n", "57 4.0 Saint Paul W-4 P-9 593.0 1681 35.28 33.14 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "43 27.59 53.42 135.00 \n", "44 35.71 50.24 135.20 \n", "45 21.83 51.56 128.68 \n", "46 22.63 48.14 91.43 \n", "47 24.26 43.30 107.61 \n", "48 5.00 46.60 123.60 \n", "49 14.52 48.97 127.37 \n", "50 55.65 59.09 161.73 \n", "51 27.81 42.25 86.81 \n", "52 22.73 47.38 125.89 \n", "53 23.93 47.66 125.30 \n", "54 15.06 44.71 79.12 \n", "55 20.13 56.27 138.60 \n", "56 18.79 44.74 113.14 \n", "57 35.01 35.41 97.12 " ] }, "execution_count": 59, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15.query('Ward==4')" ] }, { "cell_type": "code", "execution_count": 27, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct(4)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward 5 Precinct Analysis\n", "\n", "\"Drawing\"" ] }, { "cell_type": "code", "execution_count": 60, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%H_Density_Vote%L_Density_Vote%Representation%
585.0Saint Paul W-5 P-1803.0202339.6911.5221.4642.07109.60
595.0Saint Paul W-5 P-10119.064118.5612.321.2721.0050.00
605.0Saint Paul W-5 P-21261.0247251.017.0424.7153.00140.52
615.0Saint Paul W-5 P-3876.0204242.9013.1724.1645.74118.25
625.0Saint Paul W-5 P-4937.0353126.5428.8314.2431.5273.39
635.0Saint Paul W-5 P-5421.0184822.7829.0023.5122.4863.16
645.0Saint Paul W-5 P-6469.0185225.325.027.5326.2669.57
655.0Saint Paul W-5 P-7283.0116624.273.3435.9023.8766.67
665.0Saint Paul W-5 P-8618.0237925.9820.4313.5829.1671.43
675.0Saint Paul W-5 P-9395.0171723.012.5611.3623.3163.21
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density% \\\n", "58 5.0 Saint Paul W-5 P-1 803.0 2023 39.69 11.52 \n", "59 5.0 Saint Paul W-5 P-10 119.0 641 18.56 12.32 \n", "60 5.0 Saint Paul W-5 P-2 1261.0 2472 51.01 7.04 \n", "61 5.0 Saint Paul W-5 P-3 876.0 2042 42.90 13.17 \n", "62 5.0 Saint Paul W-5 P-4 937.0 3531 26.54 28.83 \n", "63 5.0 Saint Paul W-5 P-5 421.0 1848 22.78 29.00 \n", "64 5.0 Saint Paul W-5 P-6 469.0 1852 25.32 5.02 \n", "65 5.0 Saint Paul W-5 P-7 283.0 1166 24.27 3.34 \n", "66 5.0 Saint Paul W-5 P-8 618.0 2379 25.98 20.43 \n", "67 5.0 Saint Paul W-5 P-9 395.0 1717 23.01 2.56 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "58 21.46 42.07 109.60 \n", "59 1.27 21.00 50.00 \n", "60 24.71 53.00 140.52 \n", "61 24.16 45.74 118.25 \n", "62 14.24 31.52 73.39 \n", "63 23.51 22.48 63.16 \n", "64 7.53 26.26 69.57 \n", "65 35.90 23.87 66.67 \n", "66 13.58 29.16 71.43 \n", "67 11.36 23.31 63.21 " ] }, "execution_count": 60, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15.query('Ward==5')" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct(5)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward 6 Precinct Analysis \n", "\n", "\"Drawing\"" ] }, { "cell_type": "code", "execution_count": 61, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%H_Density_Vote%L_Density_Vote%Representation%
686.0Saint Paul W-6 P-1482.0140934.214.198.4735.3394.25
696.0Saint Paul W-6 P-10251.099525.2314.8727.0324.9169.35
706.0Saint Paul W-6 P-11469.0167428.021.7923.3328.1076.92
716.0Saint Paul W-6 P-2554.0125644.114.8627.8744.94120.51
726.0Saint Paul W-6 P-3473.0155830.362.3716.2230.7084.38
736.0Saint Paul W-6 P-4464.0192024.1715.369.1526.8966.39
746.0Saint Paul W-6 P-5595.0212827.963.244.3528.7576.52
756.0Saint Paul W-6 P-6615.0249324.674.4110.0025.3568.18
766.0Saint Paul W-6 P-7152.064023.7525.4749.0815.0965.00
776.0Saint Paul W-6 P-8363.0158222.9521.0523.4222.8263.27
786.0Saint Paul W-6 P-9544.0231823.479.9213.9124.5265.03
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density% \\\n", "68 6.0 Saint Paul W-6 P-1 482.0 1409 34.21 4.19 \n", "69 6.0 Saint Paul W-6 P-10 251.0 995 25.23 14.87 \n", "70 6.0 Saint Paul W-6 P-11 469.0 1674 28.02 1.79 \n", "71 6.0 Saint Paul W-6 P-2 554.0 1256 44.11 4.86 \n", "72 6.0 Saint Paul W-6 P-3 473.0 1558 30.36 2.37 \n", "73 6.0 Saint Paul W-6 P-4 464.0 1920 24.17 15.36 \n", "74 6.0 Saint Paul W-6 P-5 595.0 2128 27.96 3.24 \n", "75 6.0 Saint Paul W-6 P-6 615.0 2493 24.67 4.41 \n", "76 6.0 Saint Paul W-6 P-7 152.0 640 23.75 25.47 \n", "77 6.0 Saint Paul W-6 P-8 363.0 1582 22.95 21.05 \n", "78 6.0 Saint Paul W-6 P-9 544.0 2318 23.47 9.92 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "68 8.47 35.33 94.25 \n", "69 27.03 24.91 69.35 \n", "70 23.33 28.10 76.92 \n", "71 27.87 44.94 120.51 \n", "72 16.22 30.70 84.38 \n", "73 9.15 26.89 66.39 \n", "74 4.35 28.75 76.52 \n", "75 10.00 25.35 68.18 \n", "76 49.08 15.09 65.00 \n", "77 23.42 22.82 63.27 \n", "78 13.91 24.52 65.03 " ] }, "execution_count": 61, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15.query('Ward==6')" ] }, { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct(6)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Ward 7 Precinct Analysis \n", "\n", "Note: it is uniformly under-representated\n", "\n", "\"Drawing\"" ] }, { "cell_type": "code", "execution_count": 75, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%_H_Density_Vote%L_Density_Vote%Representation%
797.0Saint Paul W-7 P-1545.0212925.6010.8519.4826.3470.45
807.0Saint Paul W-7 P-10361.0141725.483.0323.2625.5570.45
817.0Saint Paul W-7 P-11218.0125017.4461.7611.7926.5748.05
827.0Saint Paul W-7 P-12716.0261827.3532.3516.0632.7575.31
837.0Saint Paul W-7 P-13606.0191231.6921.5015.5736.1187.29
847.0Saint Paul W-7 P-2288.0129322.272.4016.1322.4261.25
857.0Saint Paul W-7 P-3390.0147326.481.220.0026.8072.53
867.0Saint Paul W-7 P-4234.092025.4312.6123.2825.7570.18
877.0Saint Paul W-7 P-5486.0138535.0919.4923.3337.9496.51
887.0Saint Paul W-7 P-7311.0123225.2422.3226.9124.7669.74
897.0Saint Paul W-7 P-8458.0172426.5712.5310.6528.8572.90
907.0Saint Paul W-7 P-9357.0155822.916.556.8624.0463.54
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density%_ \\\n", "79 7.0 Saint Paul W-7 P-1 545.0 2129 25.60 10.85 \n", "80 7.0 Saint Paul W-7 P-10 361.0 1417 25.48 3.03 \n", "81 7.0 Saint Paul W-7 P-11 218.0 1250 17.44 61.76 \n", "82 7.0 Saint Paul W-7 P-12 716.0 2618 27.35 32.35 \n", "83 7.0 Saint Paul W-7 P-13 606.0 1912 31.69 21.50 \n", "84 7.0 Saint Paul W-7 P-2 288.0 1293 22.27 2.40 \n", "85 7.0 Saint Paul W-7 P-3 390.0 1473 26.48 1.22 \n", "86 7.0 Saint Paul W-7 P-4 234.0 920 25.43 12.61 \n", "87 7.0 Saint Paul W-7 P-5 486.0 1385 35.09 19.49 \n", "88 7.0 Saint Paul W-7 P-7 311.0 1232 25.24 22.32 \n", "89 7.0 Saint Paul W-7 P-8 458.0 1724 26.57 12.53 \n", "90 7.0 Saint Paul W-7 P-9 357.0 1558 22.91 6.55 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "79 19.48 26.34 70.45 \n", "80 23.26 25.55 70.45 \n", "81 11.79 26.57 48.05 \n", "82 16.06 32.75 75.31 \n", "83 15.57 36.11 87.29 \n", "84 16.13 22.42 61.25 \n", "85 0.00 26.80 72.53 \n", "86 23.28 25.75 70.18 \n", "87 23.33 37.94 96.51 \n", "88 26.91 24.76 69.74 \n", "89 10.65 28.85 72.90 \n", "90 6.86 24.04 63.54 " ] }, "execution_count": 75, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15.query('Ward==7')" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct(7)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Run Code (Prior to running report) " ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorRepresentation_byPrecinct()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density%H_Density_Vote%L_Density_Vote%Representation%
01.0Saint Paul W-1 P-1639.0116155.0415.4236.3158.45151.39
11.0Saint Paul W-1 P-1097.045021.5615.3320.2921.7860.71
21.0Saint Paul W-1 P-11293.0111126.3741.3127.2325.7772.46
31.0Saint Paul W-1 P-12162.033548.3631.6439.6252.40133.33
41.0Saint Paul W-1 P-13518.0115045.0426.7839.6147.03123.94
51.0Saint Paul W-1 P-14288.096129.9729.1437.5026.8783.05
61.0Saint Paul W-1 P-15162.072222.4411.2218.5222.9362.22
71.0Saint Paul W-1 P-1677.023832.358.824.7635.0286.67
81.0Saint Paul W-1 P-2786.0215936.4133.4020.6744.30100.00
91.0Saint Paul W-1 P-3568.0184430.809.719.5033.0985.09
101.0Saint Paul W-1 P-4414.0135030.671.335.5631.0185.54
111.0Saint Paul W-1 P-5420.0132431.726.5713.7932.9887.80
121.0Saint Paul W-1 P-61004.0271736.9510.4520.4238.88101.79
131.0Saint Paul W-1 P-7698.0148147.1316.8126.9151.22129.35
141.0Saint Paul W-1 P-8821.0214738.2455.2431.4546.62105.26
151.0Saint Paul W-1 P-9523.0227023.0411.9414.0224.2663.57
162.0Saint Paul W-2 P-1790.0159849.4418.6527.8554.38136.36
172.0Saint Paul W-2 P-11842.0286429.4099.1629.4029.1781.36
182.0Saint Paul W-2 P-13563.0153336.7323.9427.5239.62101.05
192.0Saint Paul W-2 P-14453.0169826.684.9511.9027.4573.33
202.0Saint Paul W-2 P-15531.0267419.8613.6117.0320.3055.15
212.0Saint Paul W-2 P-2826.0170048.5916.4736.7950.92134.29
222.0Saint Paul W-2 P-3865.0261933.0322.1116.5837.7090.74
232.0Saint Paul W-2 P-4626.0154840.4430.1029.4045.19111.46
242.0Saint Paul W-2 P-5894.0236837.7515.8429.8739.24104.11
252.0Saint Paul W-2 P-6209.061434.0473.6234.5132.7294.74
262.0Saint Paul W-2 P-7747.0221333.7650.7528.5039.1792.70
272.0Saint Paul W-2 P-8324.0123326.2883.3722.2846.3472.37
282.0Saint Paul W-2 P-9700.0201934.6795.7434.8231.4095.20
293.0Saint Paul W-3 P-11212.0206558.693.7830.7759.79161.72
..............................
615.0Saint Paul W-5 P-3876.0204242.9013.1724.1645.74118.25
625.0Saint Paul W-5 P-4937.0353126.5428.8314.2431.5273.39
635.0Saint Paul W-5 P-5421.0184822.7829.0023.5122.4863.16
645.0Saint Paul W-5 P-6469.0185225.325.027.5326.2669.57
655.0Saint Paul W-5 P-7283.0116624.273.3435.9023.8766.67
665.0Saint Paul W-5 P-8618.0237925.9820.4313.5829.1671.43
675.0Saint Paul W-5 P-9395.0171723.012.5611.3623.3163.21
686.0Saint Paul W-6 P-1482.0140934.214.198.4735.3394.25
696.0Saint Paul W-6 P-10251.099525.2314.8727.0324.9169.35
706.0Saint Paul W-6 P-11469.0167428.021.7923.3328.1076.92
716.0Saint Paul W-6 P-2554.0125644.114.8627.8744.94120.51
726.0Saint Paul W-6 P-3473.0155830.362.3716.2230.7084.38
736.0Saint Paul W-6 P-4464.0192024.1715.369.1526.8966.39
746.0Saint Paul W-6 P-5595.0212827.963.244.3528.7576.52
756.0Saint Paul W-6 P-6615.0249324.674.4110.0025.3568.18
766.0Saint Paul W-6 P-7152.064023.7525.4749.0815.0965.00
776.0Saint Paul W-6 P-8363.0158222.9521.0523.4222.8263.27
786.0Saint Paul W-6 P-9544.0231823.479.9213.9124.5265.03
797.0Saint Paul W-7 P-1545.0212925.6010.8519.4826.3470.45
807.0Saint Paul W-7 P-10361.0141725.483.0323.2625.5570.45
817.0Saint Paul W-7 P-11218.0125017.4461.7611.7926.5748.05
827.0Saint Paul W-7 P-12716.0261827.3532.3516.0632.7575.31
837.0Saint Paul W-7 P-13606.0191231.6921.5015.5736.1187.29
847.0Saint Paul W-7 P-2288.0129322.272.4016.1322.4261.25
857.0Saint Paul W-7 P-3390.0147326.481.220.0026.8072.53
867.0Saint Paul W-7 P-4234.092025.4312.6123.2825.7570.18
877.0Saint Paul W-7 P-5486.0138535.0919.4923.3337.9496.51
887.0Saint Paul W-7 P-7311.0123225.2422.3226.9124.7669.74
897.0Saint Paul W-7 P-8458.0172426.5712.5310.6528.8572.90
907.0Saint Paul W-7 P-9357.0155822.916.556.8624.0463.54
\n", "

91 rows × 9 columns

\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density% \\\n", "0 1.0 Saint Paul W-1 P-1 639.0 1161 55.04 15.42 \n", "1 1.0 Saint Paul W-1 P-10 97.0 450 21.56 15.33 \n", "2 1.0 Saint Paul W-1 P-11 293.0 1111 26.37 41.31 \n", "3 1.0 Saint Paul W-1 P-12 162.0 335 48.36 31.64 \n", "4 1.0 Saint Paul W-1 P-13 518.0 1150 45.04 26.78 \n", "5 1.0 Saint Paul W-1 P-14 288.0 961 29.97 29.14 \n", "6 1.0 Saint Paul W-1 P-15 162.0 722 22.44 11.22 \n", "7 1.0 Saint Paul W-1 P-16 77.0 238 32.35 8.82 \n", "8 1.0 Saint Paul W-1 P-2 786.0 2159 36.41 33.40 \n", "9 1.0 Saint Paul W-1 P-3 568.0 1844 30.80 9.71 \n", "10 1.0 Saint Paul W-1 P-4 414.0 1350 30.67 1.33 \n", "11 1.0 Saint Paul W-1 P-5 420.0 1324 31.72 6.57 \n", "12 1.0 Saint Paul W-1 P-6 1004.0 2717 36.95 10.45 \n", "13 1.0 Saint Paul W-1 P-7 698.0 1481 47.13 16.81 \n", "14 1.0 Saint Paul W-1 P-8 821.0 2147 38.24 55.24 \n", "15 1.0 Saint Paul W-1 P-9 523.0 2270 23.04 11.94 \n", "16 2.0 Saint Paul W-2 P-1 790.0 1598 49.44 18.65 \n", "17 2.0 Saint Paul W-2 P-11 842.0 2864 29.40 99.16 \n", "18 2.0 Saint Paul W-2 P-13 563.0 1533 36.73 23.94 \n", "19 2.0 Saint Paul W-2 P-14 453.0 1698 26.68 4.95 \n", "20 2.0 Saint Paul W-2 P-15 531.0 2674 19.86 13.61 \n", "21 2.0 Saint Paul W-2 P-2 826.0 1700 48.59 16.47 \n", "22 2.0 Saint Paul W-2 P-3 865.0 2619 33.03 22.11 \n", "23 2.0 Saint Paul W-2 P-4 626.0 1548 40.44 30.10 \n", "24 2.0 Saint Paul W-2 P-5 894.0 2368 37.75 15.84 \n", "25 2.0 Saint Paul W-2 P-6 209.0 614 34.04 73.62 \n", "26 2.0 Saint Paul W-2 P-7 747.0 2213 33.76 50.75 \n", "27 2.0 Saint Paul W-2 P-8 324.0 1233 26.28 83.37 \n", "28 2.0 Saint Paul W-2 P-9 700.0 2019 34.67 95.74 \n", "29 3.0 Saint Paul W-3 P-1 1212.0 2065 58.69 3.78 \n", ".. ... ... ... ... ... ... \n", "61 5.0 Saint Paul W-5 P-3 876.0 2042 42.90 13.17 \n", "62 5.0 Saint Paul W-5 P-4 937.0 3531 26.54 28.83 \n", "63 5.0 Saint Paul W-5 P-5 421.0 1848 22.78 29.00 \n", "64 5.0 Saint Paul W-5 P-6 469.0 1852 25.32 5.02 \n", "65 5.0 Saint Paul W-5 P-7 283.0 1166 24.27 3.34 \n", "66 5.0 Saint Paul W-5 P-8 618.0 2379 25.98 20.43 \n", "67 5.0 Saint Paul W-5 P-9 395.0 1717 23.01 2.56 \n", "68 6.0 Saint Paul W-6 P-1 482.0 1409 34.21 4.19 \n", "69 6.0 Saint Paul W-6 P-10 251.0 995 25.23 14.87 \n", "70 6.0 Saint Paul W-6 P-11 469.0 1674 28.02 1.79 \n", "71 6.0 Saint Paul W-6 P-2 554.0 1256 44.11 4.86 \n", "72 6.0 Saint Paul W-6 P-3 473.0 1558 30.36 2.37 \n", "73 6.0 Saint Paul W-6 P-4 464.0 1920 24.17 15.36 \n", "74 6.0 Saint Paul W-6 P-5 595.0 2128 27.96 3.24 \n", "75 6.0 Saint Paul W-6 P-6 615.0 2493 24.67 4.41 \n", "76 6.0 Saint Paul W-6 P-7 152.0 640 23.75 25.47 \n", "77 6.0 Saint Paul W-6 P-8 363.0 1582 22.95 21.05 \n", "78 6.0 Saint Paul W-6 P-9 544.0 2318 23.47 9.92 \n", "79 7.0 Saint Paul W-7 P-1 545.0 2129 25.60 10.85 \n", "80 7.0 Saint Paul W-7 P-10 361.0 1417 25.48 3.03 \n", "81 7.0 Saint Paul W-7 P-11 218.0 1250 17.44 61.76 \n", "82 7.0 Saint Paul W-7 P-12 716.0 2618 27.35 32.35 \n", "83 7.0 Saint Paul W-7 P-13 606.0 1912 31.69 21.50 \n", "84 7.0 Saint Paul W-7 P-2 288.0 1293 22.27 2.40 \n", "85 7.0 Saint Paul W-7 P-3 390.0 1473 26.48 1.22 \n", "86 7.0 Saint Paul W-7 P-4 234.0 920 25.43 12.61 \n", "87 7.0 Saint Paul W-7 P-5 486.0 1385 35.09 19.49 \n", "88 7.0 Saint Paul W-7 P-7 311.0 1232 25.24 22.32 \n", "89 7.0 Saint Paul W-7 P-8 458.0 1724 26.57 12.53 \n", "90 7.0 Saint Paul W-7 P-9 357.0 1558 22.91 6.55 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "0 36.31 58.45 151.39 \n", "1 20.29 21.78 60.71 \n", "2 27.23 25.77 72.46 \n", "3 39.62 52.40 133.33 \n", "4 39.61 47.03 123.94 \n", "5 37.50 26.87 83.05 \n", "6 18.52 22.93 62.22 \n", "7 4.76 35.02 86.67 \n", "8 20.67 44.30 100.00 \n", "9 9.50 33.09 85.09 \n", "10 5.56 31.01 85.54 \n", "11 13.79 32.98 87.80 \n", "12 20.42 38.88 101.79 \n", "13 26.91 51.22 129.35 \n", "14 31.45 46.62 105.26 \n", "15 14.02 24.26 63.57 \n", "16 27.85 54.38 136.36 \n", "17 29.40 29.17 81.36 \n", "18 27.52 39.62 101.05 \n", "19 11.90 27.45 73.33 \n", "20 17.03 20.30 55.15 \n", "21 36.79 50.92 134.29 \n", "22 16.58 37.70 90.74 \n", "23 29.40 45.19 111.46 \n", "24 29.87 39.24 104.11 \n", "25 34.51 32.72 94.74 \n", "26 28.50 39.17 92.70 \n", "27 22.28 46.34 72.37 \n", "28 34.82 31.40 95.20 \n", "29 30.77 59.79 161.72 \n", ".. ... ... ... \n", "61 24.16 45.74 118.25 \n", "62 14.24 31.52 73.39 \n", "63 23.51 22.48 63.16 \n", "64 7.53 26.26 69.57 \n", "65 35.90 23.87 66.67 \n", "66 13.58 29.16 71.43 \n", "67 11.36 23.31 63.21 \n", "68 8.47 35.33 94.25 \n", "69 27.03 24.91 69.35 \n", "70 23.33 28.10 76.92 \n", "71 27.87 44.94 120.51 \n", "72 16.22 30.70 84.38 \n", "73 9.15 26.89 66.39 \n", "74 4.35 28.75 76.52 \n", "75 10.00 25.35 68.18 \n", "76 49.08 15.09 65.00 \n", "77 23.42 22.82 63.27 \n", "78 13.91 24.52 65.03 \n", "79 19.48 26.34 70.45 \n", "80 23.26 25.55 70.45 \n", "81 11.79 26.57 48.05 \n", "82 16.06 32.75 75.31 \n", "83 15.57 36.11 87.29 \n", "84 16.13 22.42 61.25 \n", "85 0.00 26.80 72.53 \n", "86 23.28 25.75 70.18 \n", "87 23.33 37.94 96.51 \n", "88 26.91 24.76 69.74 \n", "89 10.65 28.85 72.90 \n", "90 6.86 24.04 63.54 \n", "\n", "[91 rows x 9 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "P_15" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [], "source": [ "def map_2017_SP_MayorRepresentation_byPrecinct(Ward=0):\n", " #setup\n", " sp_geo = r'Shapefiles/SaintPaul_VotingPrecincts.json'\n", " \n", " if Ward==0:\n", " B=P_15 \n", " A='Mayor'\n", " zo= 12\n", " else: \n", " B= P_15[(P_15['Ward'] == Ward)]\n", " A= 'Ward ' + str(Ward) +' '\n", " zo=13\n", " \n", " #Set up Variable Zoom Locations\n", " data = [[0, [44.948530, -93.096058]], [1, [44.958326, -93.122926]], [2, [44.933159, -93.115535]], [3, [44.918270, -93.176131]], [4, [44.961494, -93.176991]], [5, [44.978117, -93.106602]], [6, [44.978945, -93.047281]], [7, [44.942040, -93.033178]]] \n", "\n", " #44.951655, -93.096323\n", " \n", " # Create the pandas DataFrame \n", " Loc = pd.DataFrame(data, columns = ['Ward', 'Location']) \n", " Loc.iloc[Ward,1:]\n", " \n", " \n", " # generate a new map\n", " SP_map = folium.Map(location=Loc.iloc[Ward,1], zoom_start=zo,tiles='Stamen Terrain') #tiles=\"OpenStreetMap\")\n", "\n", " SP_map.choropleth(\n", " geo_data=sp_geo,\n", " data=B,\n", " columns=['PrecinctName','Representation%'],\n", " key_on=\"feature.properties.Precinct\",\n", " fill_color='YlOrRd', \n", " fill_opacity=0.7, \n", " line_opacity=0.2,\n", " legend_name='2017 Saint Paul ' + A +' Precinct Representation: 06/24/19',\n", " highlight= True\n", " )\n", " folium.LayerControl().add_to(SP_map)\n", " \n", " # display map\n", " return SP_map\n" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [], "source": [ "#Run Code\n", "import pandas as pd\n", "import numpy as np\n", "import warnings\n", "warnings.filterwarnings('ignore')\n", "import matplotlib as mpl\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline \n", "import requests # library to handle requests\n", "import folium\n", "import seaborn as sns\n", "import scipy.stats as stats #used to get correlation coefficient\n", "\n", "\n", "#load Data\n", "P_15= pd.read_csv('Data/SaintPaul_Mayor_PrecinctAnalysis_06-24-19.csv')\n", "P_15.columns= ['Ward', 'PrecinctName', 'Tot_Vote', 'Tot_Register','Vote%', 'Projected_Weight', 'Actual_Weight', 'Representation%', 'HDensity_Register', 'H_Vote17', 'H_Density_Vote%', 'L_Registered','L_Vote17', 'L_Density_Vote%', 'H_Density%']\n", "Features= ['Ward','PrecinctName', 'Tot_Vote', 'Tot_Register','Vote%','H_Density%', 'H_Density_Vote%', 'L_Density_Vote%', 'Representation%']\n", "P_15= P_15[Features]\n", "\n", "W_15= pd.read_csv('Data/SaintPaul_Mayor_Ward_PrecinctAnalysis_06-24-19.csv')\n", "Features= ['Ward', 'Tot_Register', 'Tot_Votes','Tot_Vote%', 'H_Density%', 'H_Density_Vote%', 'L_Density_Vote%','Representation']\n", "W_15= W_15[Features]\n", "\n", "J_15= pd.read_csv('Data/SaintPaul_Mayor_PrecinctAnalysis_06-24-19.csv')\n", "J_15.columns= ['Ward', 'Precinct', 'Tot_Vote', 'Tot_Register','Vote%', 'Projected_Weight', 'Actual_Weight', 'Representation%', 'HDensity_Register', 'H_Vote17', 'H_Density_Vote%', 'L_Registered','L_Vote17', 'L_Density_Vote%', 'H_Density_Per']\n", "Features= ['Ward','Precinct', 'Tot_Vote', 'Tot_Register','Vote%','H_Density_Per', 'H_Density_Vote%', 'L_Density_Vote%', 'Representation%']\n", "J_15= J_15[Features]\n", "\n", "\n", "def map_2017_SP_MayorRepresentation_byPrecinct(Ward=0):\n", " #setup\n", " sp_geo = r'Shapefiles/SaintPaul_VotingPrecincts.json'\n", " \n", " if Ward==0:\n", " B=P_15 \n", " A='Mayor'\n", " zo= 12\n", " else: \n", " B= P_15[(P_15['Ward'] == Ward)]\n", " A= 'Ward ' + str(Ward) +' '\n", " zo=13\n", " \n", " #Set up Variable Zoom Locations\n", " data = [[0, [44.948530, -93.096058]], [1, [44.958326, -93.122926]], [2, [44.933159, -93.115535]], [3, [44.918270, -93.176131]], [4, [44.961494, -93.176991]], [5, [44.978117, -93.106602]], [6, [44.978945, -93.047281]], [7, [44.942040, -93.033178]]] \n", "\n", " #44.951655, -93.096323\n", " \n", " # Create the pandas DataFrame \n", " Loc = pd.DataFrame(data, columns = ['Ward', 'Location']) \n", " Loc.iloc[Ward,1:]\n", " \n", " \n", " # generate a new map\n", " SP_map = folium.Map(location=Loc.iloc[Ward,1], zoom_start=zo,tiles='Stamen Terrain') #tiles=\"OpenStreetMap\")\n", "\n", " SP_map.choropleth(\n", " geo_data=sp_geo,\n", " data=B,\n", " columns=['PrecinctName','Representation%'],\n", " key_on=\"feature.properties.Precinct\",\n", " fill_color='YlOrRd', \n", " fill_opacity=0.7, \n", " line_opacity=0.2,\n", " legend_name='2017 Saint Paul ' + A +' Precinct Representation: 06/24/19',\n", " highlight= True\n", " )\n", " folium.LayerControl().add_to(SP_map)\n", " \n", " # display map\n", " return SP_map\n", "\n", "\n", "def map_2017_SP_MayorDensity_byPrecinct(Ward=0):\n", " #setup\n", " sp_geo = r'Shapefiles/SaintPaul_VotingPrecincts.json'\n", " \n", " \n", " \n", " if Ward==0:\n", " B=J_15 \n", " A='Mayor'\n", " zo= 12\n", " else: \n", " B= J_15[(J_15['Ward'] == Ward)]\n", " A= 'Ward ' + str(Ward) +' '\n", " zo=13\n", " \n", " B= J_15.query('H_Density_Per > 10')\n", " \n", " #Set up Variable Zoom Locations\n", " data = [[0, [44.948530, -93.096058]], [1, [44.958326, -93.122926]], [2, [44.933159, -93.115535]], [3, [44.918270, -93.176131]], [4, [44.961494, -93.176991]], [5, [44.978117, -93.106602]], [6, [44.978945, -93.047281]], [7, [44.942040, -93.033178]]] \n", "\n", " #44.951655, -93.096323\n", " \n", " # Create the pandas DataFrame \n", " Loc = pd.DataFrame(data, columns = ['Ward', 'Location']) \n", " Loc.iloc[Ward,1:]\n", " \n", " \n", " # generate a new map\n", " SP_map = folium.Map(location=Loc.iloc[Ward,1], zoom_start=zo,tiles='Stamen Terrain') #tiles=\"OpenStreetMap\")\n", "\n", " SP_map.choropleth(\n", " geo_data=sp_geo,\n", " data=B,\n", " columns=['Precinct','H_Density_Vote%'],\n", " key_on=\"feature.properties.Precinct\",\n", " fill_color='YlOrRd', \n", " fill_opacity=0.7, \n", " line_opacity=0.2,\n", " legend_name='2017 Saint Paul High Density Voter Rate 06/24/19',\n", " highlight= True\n", " )\n", " folium.LayerControl().add_to(SP_map)\n", " \n", " # display map\n", " return SP_map\n" ] }, { "cell_type": "code", "execution_count": 101, "metadata": {}, "outputs": [], "source": [ "#map_2015_SP_CityCouncilRepresentation_byPrecinct()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "[Click to go to Table of Contents](#content)" ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [], "source": [ "P_15= pd.read_csv('Data/SaintPaul_Mayor_PrecinctAnalysis_06-24-19.csv')" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardTot_RegisterTot_VotesTot_Vote%H_Density%H_Density_Vote%L_Density_Vote%Representation
01.0214207470.034.8721.0026.7737.03-0.51
12.0264999056.034.1738.7928.4637.80-0.95
23.02863914232.049.6920.9631.4854.536.55
34.02598911090.042.6724.6524.7848.522.84
45.0196716182.031.4315.1017.5733.89-1.63
56.0191415247.027.418.0219.9328.06-2.89
67.0203235376.026.4516.4016.3628.43-3.40
\n", "
" ], "text/plain": [ " Ward Tot_Register Tot_Votes Tot_Vote% H_Density% H_Density_Vote% \\\n", "0 1.0 21420 7470.0 34.87 21.00 26.77 \n", "1 2.0 26499 9056.0 34.17 38.79 28.46 \n", "2 3.0 28639 14232.0 49.69 20.96 31.48 \n", "3 4.0 25989 11090.0 42.67 24.65 24.78 \n", "4 5.0 19671 6182.0 31.43 15.10 17.57 \n", "5 6.0 19141 5247.0 27.41 8.02 19.93 \n", "6 7.0 20323 5376.0 26.45 16.40 16.36 \n", "\n", " L_Density_Vote% Representation \n", "0 37.03 -0.51 \n", "1 37.80 -0.95 \n", "2 54.53 6.55 \n", "3 48.52 2.84 \n", "4 33.89 -1.63 \n", "5 28.06 -2.89 \n", "6 28.43 -3.40 " ] }, "execution_count": 53, "metadata": {}, "output_type": "execute_result" } ], "source": [ "W_15" ] }, { "cell_type": "code", "execution_count": 95, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
" ], "text/plain": [ "" ] }, "execution_count": 95, "metadata": {}, "output_type": "execute_result" } ], "source": [ "map_2017_SP_MayorDensity_byPrecinct()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 83, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density_PerH_Density_Vote%L_Density_Vote%Representation%
01.0Saint Paul W-1 P-1639.0116155.0415.4236.3158.45151.39
11.0Saint Paul W-1 P-1097.045021.5615.3320.2921.7860.71
21.0Saint Paul W-1 P-11293.0111126.3741.3127.2325.7772.46
31.0Saint Paul W-1 P-12162.033548.3631.6439.6252.40133.33
41.0Saint Paul W-1 P-13518.0115045.0426.7839.6147.03123.94
51.0Saint Paul W-1 P-14288.096129.9729.1437.5026.8783.05
61.0Saint Paul W-1 P-15162.072222.4411.2218.5222.9362.22
81.0Saint Paul W-1 P-2786.0215936.4133.4020.6744.30100.00
121.0Saint Paul W-1 P-61004.0271736.9510.4520.4238.88101.79
131.0Saint Paul W-1 P-7698.0148147.1316.8126.9151.22129.35
141.0Saint Paul W-1 P-8821.0214738.2455.2431.4546.62105.26
151.0Saint Paul W-1 P-9523.0227023.0411.9414.0224.2663.57
162.0Saint Paul W-2 P-1790.0159849.4418.6527.8554.38136.36
172.0Saint Paul W-2 P-11842.0286429.4099.1629.4029.1781.36
182.0Saint Paul W-2 P-13563.0153336.7323.9427.5239.62101.05
202.0Saint Paul W-2 P-15531.0267419.8613.6117.0320.3055.15
212.0Saint Paul W-2 P-2826.0170048.5916.4736.7950.92134.29
222.0Saint Paul W-2 P-3865.0261933.0322.1116.5837.7090.74
232.0Saint Paul W-2 P-4626.0154840.4430.1029.4045.19111.46
242.0Saint Paul W-2 P-5894.0236837.7515.8429.8739.24104.11
252.0Saint Paul W-2 P-6209.061434.0473.6234.5132.7294.74
262.0Saint Paul W-2 P-7747.0221333.7650.7528.5039.1792.70
272.0Saint Paul W-2 P-8324.0123326.2883.3722.2846.3472.37
282.0Saint Paul W-2 P-9700.0201934.6795.7434.8231.4095.20
313.0Saint Paul W-3 P-11489.0194125.1970.7928.3817.4669.17
323.0Saint Paul W-3 P-12975.0177954.8112.4824.7759.09150.91
333.0Saint Paul W-3 P-13972.0184452.7119.5845.4354.48145.61
363.0Saint Paul W-3 P-31309.0271548.2122.7635.2852.03132.74
373.0Saint Paul W-3 P-4666.0132550.2640.0834.8460.58139.02
383.0Saint Paul W-3 P-5748.0193038.7655.1831.2747.98107.56
403.0Saint Paul W-3 P-7525.0126541.5048.6224.3957.69115.38
423.0Saint Paul W-3 P-91277.0249551.1815.2328.4255.27141.56
434.0Saint Paul W-4 P-1791.0162148.8017.8927.5953.42135.00
454.0Saint Paul W-4 P-111025.0220246.5516.8521.8351.56128.68
464.0Saint Paul W-4 P-12564.0170333.1258.9022.6348.1491.43
474.0Saint Paul W-4 P-13580.0148838.9822.7224.2643.30107.61
514.0Saint Paul W-4 P-3734.0232131.6273.5927.8142.2586.81
544.0Saint Paul W-4 P-6420.0146828.6154.2915.0644.7179.12
554.0Saint Paul W-4 P-7925.0184550.1416.9620.1356.27138.60
564.0Saint Paul W-4 P-8911.0220941.2413.4918.7944.74113.14
574.0Saint Paul W-4 P-9593.0168135.2833.1435.0135.4197.12
585.0Saint Paul W-5 P-1803.0202339.6911.5221.4642.07109.60
595.0Saint Paul W-5 P-10119.064118.5612.321.2721.0050.00
615.0Saint Paul W-5 P-3876.0204242.9013.1724.1645.74118.25
625.0Saint Paul W-5 P-4937.0353126.5428.8314.2431.5273.39
635.0Saint Paul W-5 P-5421.0184822.7829.0023.5122.4863.16
665.0Saint Paul W-5 P-8618.0237925.9820.4313.5829.1671.43
696.0Saint Paul W-6 P-10251.099525.2314.8727.0324.9169.35
736.0Saint Paul W-6 P-4464.0192024.1715.369.1526.8966.39
766.0Saint Paul W-6 P-7152.064023.7525.4749.0815.0965.00
776.0Saint Paul W-6 P-8363.0158222.9521.0523.4222.8263.27
797.0Saint Paul W-7 P-1545.0212925.6010.8519.4826.3470.45
817.0Saint Paul W-7 P-11218.0125017.4461.7611.7926.5748.05
827.0Saint Paul W-7 P-12716.0261827.3532.3516.0632.7575.31
837.0Saint Paul W-7 P-13606.0191231.6921.5015.5736.1187.29
867.0Saint Paul W-7 P-4234.092025.4312.6123.2825.7570.18
877.0Saint Paul W-7 P-5486.0138535.0919.4923.3337.9496.51
887.0Saint Paul W-7 P-7311.0123225.2422.3226.9124.7669.74
897.0Saint Paul W-7 P-8458.0172426.5712.5310.6528.8572.90
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density_Per \\\n", "0 1.0 Saint Paul W-1 P-1 639.0 1161 55.04 15.42 \n", "1 1.0 Saint Paul W-1 P-10 97.0 450 21.56 15.33 \n", "2 1.0 Saint Paul W-1 P-11 293.0 1111 26.37 41.31 \n", "3 1.0 Saint Paul W-1 P-12 162.0 335 48.36 31.64 \n", "4 1.0 Saint Paul W-1 P-13 518.0 1150 45.04 26.78 \n", "5 1.0 Saint Paul W-1 P-14 288.0 961 29.97 29.14 \n", "6 1.0 Saint Paul W-1 P-15 162.0 722 22.44 11.22 \n", "8 1.0 Saint Paul W-1 P-2 786.0 2159 36.41 33.40 \n", "12 1.0 Saint Paul W-1 P-6 1004.0 2717 36.95 10.45 \n", "13 1.0 Saint Paul W-1 P-7 698.0 1481 47.13 16.81 \n", "14 1.0 Saint Paul W-1 P-8 821.0 2147 38.24 55.24 \n", "15 1.0 Saint Paul W-1 P-9 523.0 2270 23.04 11.94 \n", "16 2.0 Saint Paul W-2 P-1 790.0 1598 49.44 18.65 \n", "17 2.0 Saint Paul W-2 P-11 842.0 2864 29.40 99.16 \n", "18 2.0 Saint Paul W-2 P-13 563.0 1533 36.73 23.94 \n", "20 2.0 Saint Paul W-2 P-15 531.0 2674 19.86 13.61 \n", "21 2.0 Saint Paul W-2 P-2 826.0 1700 48.59 16.47 \n", "22 2.0 Saint Paul W-2 P-3 865.0 2619 33.03 22.11 \n", "23 2.0 Saint Paul W-2 P-4 626.0 1548 40.44 30.10 \n", "24 2.0 Saint Paul W-2 P-5 894.0 2368 37.75 15.84 \n", "25 2.0 Saint Paul W-2 P-6 209.0 614 34.04 73.62 \n", "26 2.0 Saint Paul W-2 P-7 747.0 2213 33.76 50.75 \n", "27 2.0 Saint Paul W-2 P-8 324.0 1233 26.28 83.37 \n", "28 2.0 Saint Paul W-2 P-9 700.0 2019 34.67 95.74 \n", "31 3.0 Saint Paul W-3 P-11 489.0 1941 25.19 70.79 \n", "32 3.0 Saint Paul W-3 P-12 975.0 1779 54.81 12.48 \n", "33 3.0 Saint Paul W-3 P-13 972.0 1844 52.71 19.58 \n", "36 3.0 Saint Paul W-3 P-3 1309.0 2715 48.21 22.76 \n", "37 3.0 Saint Paul W-3 P-4 666.0 1325 50.26 40.08 \n", "38 3.0 Saint Paul W-3 P-5 748.0 1930 38.76 55.18 \n", "40 3.0 Saint Paul W-3 P-7 525.0 1265 41.50 48.62 \n", "42 3.0 Saint Paul W-3 P-9 1277.0 2495 51.18 15.23 \n", "43 4.0 Saint Paul W-4 P-1 791.0 1621 48.80 17.89 \n", "45 4.0 Saint Paul W-4 P-11 1025.0 2202 46.55 16.85 \n", "46 4.0 Saint Paul W-4 P-12 564.0 1703 33.12 58.90 \n", "47 4.0 Saint Paul W-4 P-13 580.0 1488 38.98 22.72 \n", "51 4.0 Saint Paul W-4 P-3 734.0 2321 31.62 73.59 \n", "54 4.0 Saint Paul W-4 P-6 420.0 1468 28.61 54.29 \n", "55 4.0 Saint Paul W-4 P-7 925.0 1845 50.14 16.96 \n", "56 4.0 Saint Paul W-4 P-8 911.0 2209 41.24 13.49 \n", "57 4.0 Saint Paul W-4 P-9 593.0 1681 35.28 33.14 \n", "58 5.0 Saint Paul W-5 P-1 803.0 2023 39.69 11.52 \n", "59 5.0 Saint Paul W-5 P-10 119.0 641 18.56 12.32 \n", "61 5.0 Saint Paul W-5 P-3 876.0 2042 42.90 13.17 \n", "62 5.0 Saint Paul W-5 P-4 937.0 3531 26.54 28.83 \n", "63 5.0 Saint Paul W-5 P-5 421.0 1848 22.78 29.00 \n", "66 5.0 Saint Paul W-5 P-8 618.0 2379 25.98 20.43 \n", "69 6.0 Saint Paul W-6 P-10 251.0 995 25.23 14.87 \n", "73 6.0 Saint Paul W-6 P-4 464.0 1920 24.17 15.36 \n", "76 6.0 Saint Paul W-6 P-7 152.0 640 23.75 25.47 \n", "77 6.0 Saint Paul W-6 P-8 363.0 1582 22.95 21.05 \n", "79 7.0 Saint Paul W-7 P-1 545.0 2129 25.60 10.85 \n", "81 7.0 Saint Paul W-7 P-11 218.0 1250 17.44 61.76 \n", "82 7.0 Saint Paul W-7 P-12 716.0 2618 27.35 32.35 \n", "83 7.0 Saint Paul W-7 P-13 606.0 1912 31.69 21.50 \n", "86 7.0 Saint Paul W-7 P-4 234.0 920 25.43 12.61 \n", "87 7.0 Saint Paul W-7 P-5 486.0 1385 35.09 19.49 \n", "88 7.0 Saint Paul W-7 P-7 311.0 1232 25.24 22.32 \n", "89 7.0 Saint Paul W-7 P-8 458.0 1724 26.57 12.53 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "0 36.31 58.45 151.39 \n", "1 20.29 21.78 60.71 \n", "2 27.23 25.77 72.46 \n", "3 39.62 52.40 133.33 \n", "4 39.61 47.03 123.94 \n", "5 37.50 26.87 83.05 \n", "6 18.52 22.93 62.22 \n", "8 20.67 44.30 100.00 \n", "12 20.42 38.88 101.79 \n", "13 26.91 51.22 129.35 \n", "14 31.45 46.62 105.26 \n", "15 14.02 24.26 63.57 \n", "16 27.85 54.38 136.36 \n", "17 29.40 29.17 81.36 \n", "18 27.52 39.62 101.05 \n", "20 17.03 20.30 55.15 \n", "21 36.79 50.92 134.29 \n", "22 16.58 37.70 90.74 \n", "23 29.40 45.19 111.46 \n", "24 29.87 39.24 104.11 \n", "25 34.51 32.72 94.74 \n", "26 28.50 39.17 92.70 \n", "27 22.28 46.34 72.37 \n", "28 34.82 31.40 95.20 \n", "31 28.38 17.46 69.17 \n", "32 24.77 59.09 150.91 \n", "33 45.43 54.48 145.61 \n", "36 35.28 52.03 132.74 \n", "37 34.84 60.58 139.02 \n", "38 31.27 47.98 107.56 \n", "40 24.39 57.69 115.38 \n", "42 28.42 55.27 141.56 \n", "43 27.59 53.42 135.00 \n", "45 21.83 51.56 128.68 \n", "46 22.63 48.14 91.43 \n", "47 24.26 43.30 107.61 \n", "51 27.81 42.25 86.81 \n", "54 15.06 44.71 79.12 \n", "55 20.13 56.27 138.60 \n", "56 18.79 44.74 113.14 \n", "57 35.01 35.41 97.12 \n", "58 21.46 42.07 109.60 \n", "59 1.27 21.00 50.00 \n", "61 24.16 45.74 118.25 \n", "62 14.24 31.52 73.39 \n", "63 23.51 22.48 63.16 \n", "66 13.58 29.16 71.43 \n", "69 27.03 24.91 69.35 \n", "73 9.15 26.89 66.39 \n", "76 49.08 15.09 65.00 \n", "77 23.42 22.82 63.27 \n", "79 19.48 26.34 70.45 \n", "81 11.79 26.57 48.05 \n", "82 16.06 32.75 75.31 \n", "83 15.57 36.11 87.29 \n", "86 23.28 25.75 70.18 \n", "87 23.33 37.94 96.51 \n", "88 26.91 24.76 69.74 \n", "89 10.65 28.85 72.90 " ] }, "execution_count": 83, "metadata": {}, "output_type": "execute_result" } ], "source": [ "J_15.query('H_Density_Per > 10')" ] }, { "cell_type": "code", "execution_count": 93, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
WardPrecinctTot_VoteTot_RegisterVote%H_Density_PerH_Density_Vote%L_Density_Vote%Representation%
01.0Saint Paul W-1 P-1639.0116155.0415.4236.3158.45151.39
11.0Saint Paul W-1 P-1097.045021.5615.3320.2921.7860.71
21.0Saint Paul W-1 P-11293.0111126.3741.3127.2325.7772.46
31.0Saint Paul W-1 P-12162.033548.3631.6439.6252.40133.33
41.0Saint Paul W-1 P-13518.0115045.0426.7839.6147.03123.94
51.0Saint Paul W-1 P-14288.096129.9729.1437.5026.8783.05
61.0Saint Paul W-1 P-15162.072222.4411.2218.5222.9362.22
81.0Saint Paul W-1 P-2786.0215936.4133.4020.6744.30100.00
121.0Saint Paul W-1 P-61004.0271736.9510.4520.4238.88101.79
131.0Saint Paul W-1 P-7698.0148147.1316.8126.9151.22129.35
141.0Saint Paul W-1 P-8821.0214738.2455.2431.4546.62105.26
151.0Saint Paul W-1 P-9523.0227023.0411.9414.0224.2663.57
162.0Saint Paul W-2 P-1790.0159849.4418.6527.8554.38136.36
172.0Saint Paul W-2 P-11842.0286429.4099.1629.4029.1781.36
182.0Saint Paul W-2 P-13563.0153336.7323.9427.5239.62101.05
202.0Saint Paul W-2 P-15531.0267419.8613.6117.0320.3055.15
212.0Saint Paul W-2 P-2826.0170048.5916.4736.7950.92134.29
222.0Saint Paul W-2 P-3865.0261933.0322.1116.5837.7090.74
232.0Saint Paul W-2 P-4626.0154840.4430.1029.4045.19111.46
242.0Saint Paul W-2 P-5894.0236837.7515.8429.8739.24104.11
252.0Saint Paul W-2 P-6209.061434.0473.6234.5132.7294.74
262.0Saint Paul W-2 P-7747.0221333.7650.7528.5039.1792.70
272.0Saint Paul W-2 P-8324.0123326.2883.3722.2846.3472.37
282.0Saint Paul W-2 P-9700.0201934.6795.7434.8231.4095.20
313.0Saint Paul W-3 P-11489.0194125.1970.7928.3817.4669.17
323.0Saint Paul W-3 P-12975.0177954.8112.4824.7759.09150.91
333.0Saint Paul W-3 P-13972.0184452.7119.5845.4354.48145.61
363.0Saint Paul W-3 P-31309.0271548.2122.7635.2852.03132.74
373.0Saint Paul W-3 P-4666.0132550.2640.0834.8460.58139.02
383.0Saint Paul W-3 P-5748.0193038.7655.1831.2747.98107.56
403.0Saint Paul W-3 P-7525.0126541.5048.6224.3957.69115.38
423.0Saint Paul W-3 P-91277.0249551.1815.2328.4255.27141.56
434.0Saint Paul W-4 P-1791.0162148.8017.8927.5953.42135.00
454.0Saint Paul W-4 P-111025.0220246.5516.8521.8351.56128.68
464.0Saint Paul W-4 P-12564.0170333.1258.9022.6348.1491.43
474.0Saint Paul W-4 P-13580.0148838.9822.7224.2643.30107.61
514.0Saint Paul W-4 P-3734.0232131.6273.5927.8142.2586.81
544.0Saint Paul W-4 P-6420.0146828.6154.2915.0644.7179.12
554.0Saint Paul W-4 P-7925.0184550.1416.9620.1356.27138.60
564.0Saint Paul W-4 P-8911.0220941.2413.4918.7944.74113.14
574.0Saint Paul W-4 P-9593.0168135.2833.1435.0135.4197.12
585.0Saint Paul W-5 P-1803.0202339.6911.5221.4642.07109.60
595.0Saint Paul W-5 P-10119.064118.5612.321.2721.0050.00
615.0Saint Paul W-5 P-3876.0204242.9013.1724.1645.74118.25
625.0Saint Paul W-5 P-4937.0353126.5428.8314.2431.5273.39
635.0Saint Paul W-5 P-5421.0184822.7829.0023.5122.4863.16
665.0Saint Paul W-5 P-8618.0237925.9820.4313.5829.1671.43
696.0Saint Paul W-6 P-10251.099525.2314.8727.0324.9169.35
736.0Saint Paul W-6 P-4464.0192024.1715.369.1526.8966.39
766.0Saint Paul W-6 P-7152.064023.7525.4749.0815.0965.00
776.0Saint Paul W-6 P-8363.0158222.9521.0523.4222.8263.27
797.0Saint Paul W-7 P-1545.0212925.6010.8519.4826.3470.45
817.0Saint Paul W-7 P-11218.0125017.4461.7611.7926.5748.05
827.0Saint Paul W-7 P-12716.0261827.3532.3516.0632.7575.31
837.0Saint Paul W-7 P-13606.0191231.6921.5015.5736.1187.29
867.0Saint Paul W-7 P-4234.092025.4312.6123.2825.7570.18
877.0Saint Paul W-7 P-5486.0138535.0919.4923.3337.9496.51
887.0Saint Paul W-7 P-7311.0123225.2422.3226.9124.7669.74
897.0Saint Paul W-7 P-8458.0172426.5712.5310.6528.8572.90
\n", "
" ], "text/plain": [ " Ward Precinct Tot_Vote Tot_Register Vote% H_Density_Per \\\n", "0 1.0 Saint Paul W-1 P-1 639.0 1161 55.04 15.42 \n", "1 1.0 Saint Paul W-1 P-10 97.0 450 21.56 15.33 \n", "2 1.0 Saint Paul W-1 P-11 293.0 1111 26.37 41.31 \n", "3 1.0 Saint Paul W-1 P-12 162.0 335 48.36 31.64 \n", "4 1.0 Saint Paul W-1 P-13 518.0 1150 45.04 26.78 \n", "5 1.0 Saint Paul W-1 P-14 288.0 961 29.97 29.14 \n", "6 1.0 Saint Paul W-1 P-15 162.0 722 22.44 11.22 \n", "8 1.0 Saint Paul W-1 P-2 786.0 2159 36.41 33.40 \n", "12 1.0 Saint Paul W-1 P-6 1004.0 2717 36.95 10.45 \n", "13 1.0 Saint Paul W-1 P-7 698.0 1481 47.13 16.81 \n", "14 1.0 Saint Paul W-1 P-8 821.0 2147 38.24 55.24 \n", "15 1.0 Saint Paul W-1 P-9 523.0 2270 23.04 11.94 \n", "16 2.0 Saint Paul W-2 P-1 790.0 1598 49.44 18.65 \n", "17 2.0 Saint Paul W-2 P-11 842.0 2864 29.40 99.16 \n", "18 2.0 Saint Paul W-2 P-13 563.0 1533 36.73 23.94 \n", "20 2.0 Saint Paul W-2 P-15 531.0 2674 19.86 13.61 \n", "21 2.0 Saint Paul W-2 P-2 826.0 1700 48.59 16.47 \n", "22 2.0 Saint Paul W-2 P-3 865.0 2619 33.03 22.11 \n", "23 2.0 Saint Paul W-2 P-4 626.0 1548 40.44 30.10 \n", "24 2.0 Saint Paul W-2 P-5 894.0 2368 37.75 15.84 \n", "25 2.0 Saint Paul W-2 P-6 209.0 614 34.04 73.62 \n", "26 2.0 Saint Paul W-2 P-7 747.0 2213 33.76 50.75 \n", "27 2.0 Saint Paul W-2 P-8 324.0 1233 26.28 83.37 \n", "28 2.0 Saint Paul W-2 P-9 700.0 2019 34.67 95.74 \n", "31 3.0 Saint Paul W-3 P-11 489.0 1941 25.19 70.79 \n", "32 3.0 Saint Paul W-3 P-12 975.0 1779 54.81 12.48 \n", "33 3.0 Saint Paul W-3 P-13 972.0 1844 52.71 19.58 \n", "36 3.0 Saint Paul W-3 P-3 1309.0 2715 48.21 22.76 \n", "37 3.0 Saint Paul W-3 P-4 666.0 1325 50.26 40.08 \n", "38 3.0 Saint Paul W-3 P-5 748.0 1930 38.76 55.18 \n", "40 3.0 Saint Paul W-3 P-7 525.0 1265 41.50 48.62 \n", "42 3.0 Saint Paul W-3 P-9 1277.0 2495 51.18 15.23 \n", "43 4.0 Saint Paul W-4 P-1 791.0 1621 48.80 17.89 \n", "45 4.0 Saint Paul W-4 P-11 1025.0 2202 46.55 16.85 \n", "46 4.0 Saint Paul W-4 P-12 564.0 1703 33.12 58.90 \n", "47 4.0 Saint Paul W-4 P-13 580.0 1488 38.98 22.72 \n", "51 4.0 Saint Paul W-4 P-3 734.0 2321 31.62 73.59 \n", "54 4.0 Saint Paul W-4 P-6 420.0 1468 28.61 54.29 \n", "55 4.0 Saint Paul W-4 P-7 925.0 1845 50.14 16.96 \n", "56 4.0 Saint Paul W-4 P-8 911.0 2209 41.24 13.49 \n", "57 4.0 Saint Paul W-4 P-9 593.0 1681 35.28 33.14 \n", "58 5.0 Saint Paul W-5 P-1 803.0 2023 39.69 11.52 \n", "59 5.0 Saint Paul W-5 P-10 119.0 641 18.56 12.32 \n", "61 5.0 Saint Paul W-5 P-3 876.0 2042 42.90 13.17 \n", "62 5.0 Saint Paul W-5 P-4 937.0 3531 26.54 28.83 \n", "63 5.0 Saint Paul W-5 P-5 421.0 1848 22.78 29.00 \n", "66 5.0 Saint Paul W-5 P-8 618.0 2379 25.98 20.43 \n", "69 6.0 Saint Paul W-6 P-10 251.0 995 25.23 14.87 \n", "73 6.0 Saint Paul W-6 P-4 464.0 1920 24.17 15.36 \n", "76 6.0 Saint Paul W-6 P-7 152.0 640 23.75 25.47 \n", "77 6.0 Saint Paul W-6 P-8 363.0 1582 22.95 21.05 \n", "79 7.0 Saint Paul W-7 P-1 545.0 2129 25.60 10.85 \n", "81 7.0 Saint Paul W-7 P-11 218.0 1250 17.44 61.76 \n", "82 7.0 Saint Paul W-7 P-12 716.0 2618 27.35 32.35 \n", "83 7.0 Saint Paul W-7 P-13 606.0 1912 31.69 21.50 \n", "86 7.0 Saint Paul W-7 P-4 234.0 920 25.43 12.61 \n", "87 7.0 Saint Paul W-7 P-5 486.0 1385 35.09 19.49 \n", "88 7.0 Saint Paul W-7 P-7 311.0 1232 25.24 22.32 \n", "89 7.0 Saint Paul W-7 P-8 458.0 1724 26.57 12.53 \n", "\n", " H_Density_Vote% L_Density_Vote% Representation% \n", "0 36.31 58.45 151.39 \n", "1 20.29 21.78 60.71 \n", "2 27.23 25.77 72.46 \n", "3 39.62 52.40 133.33 \n", "4 39.61 47.03 123.94 \n", "5 37.50 26.87 83.05 \n", "6 18.52 22.93 62.22 \n", "8 20.67 44.30 100.00 \n", "12 20.42 38.88 101.79 \n", "13 26.91 51.22 129.35 \n", "14 31.45 46.62 105.26 \n", "15 14.02 24.26 63.57 \n", "16 27.85 54.38 136.36 \n", "17 29.40 29.17 81.36 \n", "18 27.52 39.62 101.05 \n", "20 17.03 20.30 55.15 \n", "21 36.79 50.92 134.29 \n", "22 16.58 37.70 90.74 \n", "23 29.40 45.19 111.46 \n", "24 29.87 39.24 104.11 \n", "25 34.51 32.72 94.74 \n", "26 28.50 39.17 92.70 \n", "27 22.28 46.34 72.37 \n", "28 34.82 31.40 95.20 \n", "31 28.38 17.46 69.17 \n", "32 24.77 59.09 150.91 \n", "33 45.43 54.48 145.61 \n", "36 35.28 52.03 132.74 \n", "37 34.84 60.58 139.02 \n", "38 31.27 47.98 107.56 \n", "40 24.39 57.69 115.38 \n", "42 28.42 55.27 141.56 \n", "43 27.59 53.42 135.00 \n", "45 21.83 51.56 128.68 \n", "46 22.63 48.14 91.43 \n", "47 24.26 43.30 107.61 \n", "51 27.81 42.25 86.81 \n", "54 15.06 44.71 79.12 \n", "55 20.13 56.27 138.60 \n", "56 18.79 44.74 113.14 \n", "57 35.01 35.41 97.12 \n", "58 21.46 42.07 109.60 \n", "59 1.27 21.00 50.00 \n", "61 24.16 45.74 118.25 \n", "62 14.24 31.52 73.39 \n", "63 23.51 22.48 63.16 \n", "66 13.58 29.16 71.43 \n", "69 27.03 24.91 69.35 \n", "73 9.15 26.89 66.39 \n", "76 49.08 15.09 65.00 \n", "77 23.42 22.82 63.27 \n", "79 19.48 26.34 70.45 \n", "81 11.79 26.57 48.05 \n", "82 16.06 32.75 75.31 \n", "83 15.57 36.11 87.29 \n", "86 23.28 25.75 70.18 \n", "87 23.33 37.94 96.51 \n", "88 26.91 24.76 69.74 \n", "89 10.65 28.85 72.90 " ] }, "execution_count": 93, "metadata": {}, "output_type": "execute_result" } ], "source": [ "J_15.query('H_Density_Per > 10')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.3" } }, "nbformat": 4, "nbformat_minor": 2 }