Merge data together 2018.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "This is the notebook I use to merge different datasets together."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The autoreload extension is already loaded. To reload it, use:\n",
      "  %reload_ext autoreload\n"
     ]
    }
   ],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import merging_functions as mf\n",
    "import os\n",
    "\n",
    "from merging_functions import state_counts\n",
    "years = mf.years"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "source": [
    "Access and define functions for reading the wikipedia-extracted entries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "529 matches between the sets\n"
     ]
    }
   ],
   "source": [
    "state = \"ME\"\n",
    "alperin,wiki,cesta = state_counts(state)\n",
    "a = alperin\n",
    "b = wiki\n",
    "\n",
    "\n",
    "matches = mf.match_matrices(alperin[1],wiki[1],min=2,sources = (alperin[0],wiki[0]))\n",
    "as_a = set([m['a'] for m in matches])\n",
    "as_b = set([m['b'] for m in matches])\n",
    "\n",
    "only_b = set(range(len(b[1]))).difference(as_b)\n",
    "only_a = set(range(len(a[1]))).difference(as_a)\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Just Alperin\n",
      "259                                 Louds Island\n",
      "388                                     Rangeley\n",
      "307                         Muscle Ridge Islands\n",
      "362     Passamaquoddy Pleasant Point Reservation\n",
      "365          Penobscot Indian Island Reservation\n",
      "366          Penobscot Indian Island Reservation\n",
      "369                                      Perkins\n",
      "275                              Marshall Island\n",
      "361    Passamaquoddy Indian Township Reservation\n",
      "250                                      Lincoln\n",
      "Name: Alperin_Place, dtype: object\n",
      "\n",
      "\n",
      "Just Wikipedia, not Alperin\n",
      "93                           Maine\n",
      "186                 Deering, Maine\n",
      "368    Loring Air Force Base (CDP)\n",
      "Name: title, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print \"Just Alperin\"\n",
    "print a[0].iloc[list(only_a)][\"Alperin_Place\"]\n",
    "\n",
    "print \"\\n\\nJust Wikipedia, not Alperin\"\n",
    "print b[0].iloc[list(only_b)][\"title\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Deering is a neighborhood of portland independent in the late 19th century. \n",
    "\n",
    "Rangeley is missing from Wikipedia b/c, I guess, wikipedia somehow has two population boxes. (One for the plantation, one for the town, probably?).\n",
    "\n",
    "Perkins vanishes mid-19C: not sure why Alperin has it, not Wikipedia. Should be the other way 'round."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "505 matches between the sets\n",
      "617 matches between the sets\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Alperin_County</th>\n",
       "      <th>Alperin_Place</th>\n",
       "      <th>COUSUB</th>\n",
       "      <th>Census_Name_2010</th>\n",
       "      <th>City</th>\n",
       "      <th>City Source</th>\n",
       "      <th>CityST</th>\n",
       "      <th>County</th>\n",
       "      <th>County_Name</th>\n",
       "      <th>Incorporation Date</th>\n",
       "      <th>...</th>\n",
       "      <th>country</th>\n",
       "      <th>id</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>other_years</th>\n",
       "      <th>poptype</th>\n",
       "      <th>settlement_type</th>\n",
       "      <th>state</th>\n",
       "      <th>title</th>\n",
       "      <th>wiki_pops</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Perry County</td>\n",
       "      <td>Adona city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adona</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Adona, AR</td>\n",
       "      <td>Perry</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107172.0</td>\n",
       "      <td>35.039444</td>\n",
       "      <td>-92.898889</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Adona, Arkansas</td>\n",
       "      <td>209,187,146,230,204,154,194,218,200,241,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pulaski County</td>\n",
       "      <td>Alexander city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alexander city</td>\n",
       "      <td>Alexander</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Alexander, AR</td>\n",
       "      <td>Pulaski And Saline</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107215.0</td>\n",
       "      <td>34.631389</td>\n",
       "      <td>-92.444167</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Alexander, Arkansas</td>\n",
       "      <td>2901,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Lawrence County</td>\n",
       "      <td>Alicia town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alicia</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Alicia, AR</td>\n",
       "      <td>Lawrence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107071.0</td>\n",
       "      <td>35.894444</td>\n",
       "      <td>-91.083611</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Alicia, Arkansas</td>\n",
       "      <td>124,145,157,246,246,236,299,333,342,297,168,15...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lonoke County</td>\n",
       "      <td>Allport town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Allport</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Allport, AR</td>\n",
       "      <td>Lonoke</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107108.0</td>\n",
       "      <td>34.539444</td>\n",
       "      <td>-91.785000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Allport, Arkansas</td>\n",
       "      <td>115,127,188,295,307,0,0,0,0,0,0,0,0,0,0,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Crawford County</td>\n",
       "      <td>Alma city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alma city</td>\n",
       "      <td>Alma</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Alma, AR</td>\n",
       "      <td>Crawford</td>\n",
       "      <td>Crawford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106928.0</td>\n",
       "      <td>35.488056</td>\n",
       "      <td>-94.220833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Alma, Arkansas</td>\n",
       "      <td>5419,4160,2959,2755,1613,1370,1228,774,731,779...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Arkansas County</td>\n",
       "      <td>Almyra town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Almyra</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Almyra, AR</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106807.0</td>\n",
       "      <td>34.405833</td>\n",
       "      <td>-91.411944</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Almyra, Arkansas</td>\n",
       "      <td>283,319,311,294,220,240,235,233,287,323,252,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Boone County</td>\n",
       "      <td>Alpena town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alpena</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Alpena, AR</td>\n",
       "      <td>Boone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106853.0</td>\n",
       "      <td>36.293611</td>\n",
       "      <td>-93.296111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Alpena, Arkansas</td>\n",
       "      <td>392,371,319,344,309,283,304,313,361,250,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Jefferson County</td>\n",
       "      <td>Altheimer city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Altheimer</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Altheimer, AR</td>\n",
       "      <td>Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107056.0</td>\n",
       "      <td>34.319250</td>\n",
       "      <td>-91.847361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Altheimer, Arkansas</td>\n",
       "      <td>984,1192,972,1231,1037,979,680,494,475,450,0,0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Franklin County</td>\n",
       "      <td>Altus city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Altus</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Altus, AR</td>\n",
       "      <td>Franklin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106979.0</td>\n",
       "      <td>35.454722</td>\n",
       "      <td>-93.771944</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Altus, Arkansas</td>\n",
       "      <td>758,817,433,441,418,392,431,541,595,709,659,50...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Jackson County</td>\n",
       "      <td>Amagon town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Amagon</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Amagon, AR</td>\n",
       "      <td>Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107044.0</td>\n",
       "      <td>35.562500</td>\n",
       "      <td>-91.109722</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Amagon, Arkansas</td>\n",
       "      <td>98,95,108,126,136,234,181,0,0,0,0,0,0,0,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Clark County</td>\n",
       "      <td>Amity city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Amity</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Amity, AR</td>\n",
       "      <td>Clark</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106882.0</td>\n",
       "      <td>34.266111</td>\n",
       "      <td>-93.464167</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Amity, Arkansas</td>\n",
       "      <td>723,762,526,859,614,543,591,608,608,680,813,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Crittenden County</td>\n",
       "      <td>Anthonyville town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anthonyville town</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Anthonyville town, AR</td>\n",
       "      <td>Crittenden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106937.0</td>\n",
       "      <td>35.039444</td>\n",
       "      <td>-90.340833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Anthonyville, Arkansas</td>\n",
       "      <td>161,250,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Pike County</td>\n",
       "      <td>Antoine town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Antoine</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Antoine, AR</td>\n",
       "      <td>Pike</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107185.0</td>\n",
       "      <td>34.036111</td>\n",
       "      <td>-93.421667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Antoine, Arkansas</td>\n",
       "      <td>117,156,160,194,182,163,209,233,210,0,0,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Clark County</td>\n",
       "      <td>Arkadelphia city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arkadelphia city</td>\n",
       "      <td>Arkadelphia</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Arkadelphia, AR</td>\n",
       "      <td>Clark</td>\n",
       "      <td>Clark</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106883.0</td>\n",
       "      <td>34.121944</td>\n",
       "      <td>-93.066111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Arkadelphia, Arkansas</td>\n",
       "      <td>10714,10912,10014,10005,9841,8069,6819,5078,33...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Desha County</td>\n",
       "      <td>Arkansas City city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arkansas City</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Arkansas City, AR</td>\n",
       "      <td>Desha</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106957.0</td>\n",
       "      <td>33.608889</td>\n",
       "      <td>-91.203611</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Arkansas City, Arkansas</td>\n",
       "      <td>366,589,523,668,615,783,1018,1446,1432,1482,14...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sharp County</td>\n",
       "      <td>Ash Flat city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ash Flat</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Ash Flat, AR</td>\n",
       "      <td>Sharp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106984.0</td>\n",
       "      <td>36.231111</td>\n",
       "      <td>-91.609167</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Ash Flat, Arkansas</td>\n",
       "      <td>1082,977,667,524,211,192,265,315,0,0,0,0,0,0,0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Little River County</td>\n",
       "      <td>Ashdown city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ashdown city</td>\n",
       "      <td>Ashdown</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Ashdown, AR</td>\n",
       "      <td>Little River</td>\n",
       "      <td>Little River</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107094.0</td>\n",
       "      <td>33.673333</td>\n",
       "      <td>-94.127222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Ashdown, Arkansas</td>\n",
       "      <td>4723,4781,5150,4218,3522,2725,2738,2332,1607,2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Pope County</td>\n",
       "      <td>Atkins city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Atkins city</td>\n",
       "      <td>Atkins</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Atkins, AR</td>\n",
       "      <td>Pope</td>\n",
       "      <td>Pope</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107204.0</td>\n",
       "      <td>35.243611</td>\n",
       "      <td>-92.938333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Atkins, Arkansas</td>\n",
       "      <td>3016,2878,2834,3002,2015,1391,1291,1322,1364,1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lee County</td>\n",
       "      <td>Aubrey town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aubrey</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Aubrey, AR</td>\n",
       "      <td>Lee</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107085.0</td>\n",
       "      <td>34.718056</td>\n",
       "      <td>-90.899444</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Aubrey, Arkansas</td>\n",
       "      <td>170,221,204,267,351,0,0,0,0,0,0,0,0,0,0,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Woodruff County</td>\n",
       "      <td>Augusta city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Augusta</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Augusta, AR</td>\n",
       "      <td>Woodruff</td>\n",
       "      <td>Woodruff</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107318.0</td>\n",
       "      <td>35.286389</td>\n",
       "      <td>-91.360833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Augusta, Arkansas</td>\n",
       "      <td>2199,2665,2759,3496,2777,2272,2317,2235,2243,1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Lonoke County</td>\n",
       "      <td>Austin city (Austin Station)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Austin (Station)</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Austin (Station), AR</td>\n",
       "      <td>Lonoke</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107109.0</td>\n",
       "      <td>35.005278</td>\n",
       "      <td>-91.989167</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Austin, Arkansas</td>\n",
       "      <td>2038,605,235,269,236,210,154,145,123,163,177,1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Benton County</td>\n",
       "      <td>Avoca town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Avoca</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Avoca, AR</td>\n",
       "      <td>Benton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106830.0</td>\n",
       "      <td>36.401389</td>\n",
       "      <td>-94.070833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Avoca, Arkansas</td>\n",
       "      <td>488,423,269,256,173,0,0,0,0,0,0,0,0,0,0,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>White County</td>\n",
       "      <td>Bald Knob city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bald Knob city</td>\n",
       "      <td>Bald Knob</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Bald Knob, AR</td>\n",
       "      <td>White</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107302.0</td>\n",
       "      <td>35.311667</td>\n",
       "      <td>-91.570000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Bald Knob, Arkansas</td>\n",
       "      <td>2897,3210,2653,2756,2094,1705,2022,1445,1273,9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bradley County</td>\n",
       "      <td>Banks town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Banks</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Banks, AR</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106865.0</td>\n",
       "      <td>33.576667</td>\n",
       "      <td>-92.268056</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Banks, Arkansas</td>\n",
       "      <td>124,120,88,216,189,233,240,248,199,347,244,0,0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Sebastian County</td>\n",
       "      <td>Barling city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barling city</td>\n",
       "      <td>Barling</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Barling, AR</td>\n",
       "      <td>Sebastian</td>\n",
       "      <td>Sebastian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107251.0</td>\n",
       "      <td>35.322778</td>\n",
       "      <td>-94.300556</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Barling, Arkansas</td>\n",
       "      <td>4649,4176,4078,3761,1739,770,0,0,0,0,0,0,0,0,0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Mississippi County</td>\n",
       "      <td>Bassett town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bassett</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Bassett, AR</td>\n",
       "      <td>Mississippi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107130.0</td>\n",
       "      <td>35.535833</td>\n",
       "      <td>-90.126111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Bassett, Arkansas</td>\n",
       "      <td>173,168,199,243,265,0,0,0,0,0,0,0,0,0,0,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Independence County</td>\n",
       "      <td>Batesville city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Batesville city</td>\n",
       "      <td>Batesville</td>\n",
       "      <td>US Census Bureau</td>\n",
       "      <td>Batesville, AR</td>\n",
       "      <td>Independence</td>\n",
       "      <td>Independence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107028.0</td>\n",
       "      <td>35.773611</td>\n",
       "      <td>-91.641389</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Batesville, Arkansas</td>\n",
       "      <td>10248,9445,9187,8447,7209,6207,6414,5267,4484,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Saline County</td>\n",
       "      <td>Bauxite town</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bauxite</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Bauxite, AR</td>\n",
       "      <td>Saline</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107236.0</td>\n",
       "      <td>34.559167</td>\n",
       "      <td>-92.514167</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>Town</td>\n",
       "      <td>AR</td>\n",
       "      <td>Bauxite, Arkansas</td>\n",
       "      <td>487,432,412,433,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Craighead County</td>\n",
       "      <td>Bay city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bay</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Bay, AR</td>\n",
       "      <td>Craighead</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>106918.0</td>\n",
       "      <td>35.745278</td>\n",
       "      <td>-90.562778</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Bay, Arkansas</td>\n",
       "      <td>1801,1800,1660,1605,751,627,500,357,300,0,0,0,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Ouachita County</td>\n",
       "      <td>Bearden city</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bearden</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Bearden, AR</td>\n",
       "      <td>Ouachita</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>US</td>\n",
       "      <td>107166.0</td>\n",
       "      <td>33.726111</td>\n",
       "      <td>-92.617500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Census</td>\n",
       "      <td>City</td>\n",
       "      <td>AR</td>\n",
       "      <td>Bearden, Arkansas</td>\n",
       "      <td>966,1125,1021,1191,1272,1268,1300,961,1147,687...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>North Crossett</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>North Crossett, AR</td>\n",
       "      <td>Ashley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norvell</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Norvell, AR</td>\n",
       "      <td>Crittenden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Oak Grove Heights</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Oak Grove Heights, AR</td>\n",
       "      <td>Greene</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Paraloma</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Paraloma, AR</td>\n",
       "      <td>Sevier</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Parkers-Iron Springs CD</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Parkers-Iron Springs CD, AR</td>\n",
       "      <td>Pulaski</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pendleton</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Pendleton, AR</td>\n",
       "      <td>Desha</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pike City</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Pike City, AR</td>\n",
       "      <td>Pike</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>697</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Piney</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Piney, AR</td>\n",
       "      <td>Garland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poplar Grove</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Poplar Grove, AR</td>\n",
       "      <td>Phillips</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Prairie Creek</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Prairie Creek, AR</td>\n",
       "      <td>Benton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Princeton</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Princeton, AR</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pulaski Heights</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Pulaski Heights, AR</td>\n",
       "      <td>Pulaski</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Raggio</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Raggio, AR</td>\n",
       "      <td>Lee</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Readland</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Readland, AR</td>\n",
       "      <td>Chicot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red Fork</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Red Fork, AR</td>\n",
       "      <td>Desha</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Varner</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Varner, AR</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richmond</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Richmond, AR</td>\n",
       "      <td>Little River</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Arkinda</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Arkinda, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Ashdown</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Ashdown, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>709</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Foreman</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Foreman, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>710</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River New Rocky Comfort</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River New Rocky Comfort, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>711</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Ogden</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Ogden, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>712</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Richmond</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Richmond, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Rocky Comfort</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Rocky Comfort, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>714</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River White Cliffs</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River White Cliffs, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Wilton</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Wilton, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>River Winthrop</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>River Winthrop, AR</td>\n",
       "      <td>Little</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rockwel</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Rockwell, AR</td>\n",
       "      <td>Garland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocky Comfort</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Rocky Comfort, AR</td>\n",
       "      <td>Little River</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rohwer</td>\n",
       "      <td>Arkansas State Data Center</td>\n",
       "      <td>Rohwer, AR</td>\n",
       "      <td>Desha</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>720 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Alperin_County                 Alperin_Place  COUSUB  \\\n",
       "0           Perry County                    Adona city     NaN   \n",
       "1         Pulaski County                Alexander city     NaN   \n",
       "2        Lawrence County                   Alicia town     NaN   \n",
       "3          Lonoke County                  Allport town     NaN   \n",
       "4        Crawford County                     Alma city     NaN   \n",
       "5        Arkansas County                   Almyra town     NaN   \n",
       "6           Boone County                   Alpena town     NaN   \n",
       "7       Jefferson County                Altheimer city     NaN   \n",
       "8        Franklin County                    Altus city     NaN   \n",
       "9         Jackson County                   Amagon town     NaN   \n",
       "10          Clark County                    Amity city     NaN   \n",
       "11     Crittenden County             Anthonyville town     NaN   \n",
       "12           Pike County                  Antoine town     NaN   \n",
       "13          Clark County              Arkadelphia city     NaN   \n",
       "14          Desha County            Arkansas City city     NaN   \n",
       "15          Sharp County                 Ash Flat city     NaN   \n",
       "16   Little River County                  Ashdown city     NaN   \n",
       "17           Pope County                   Atkins city     NaN   \n",
       "18            Lee County                   Aubrey town     NaN   \n",
       "19       Woodruff County                  Augusta city     NaN   \n",
       "20         Lonoke County  Austin city (Austin Station)     NaN   \n",
       "21         Benton County                    Avoca town     NaN   \n",
       "22          White County                Bald Knob city     NaN   \n",
       "23        Bradley County                    Banks town     NaN   \n",
       "24      Sebastian County                  Barling city     NaN   \n",
       "25    Mississippi County                  Bassett town     NaN   \n",
       "26   Independence County               Batesville city     NaN   \n",
       "27         Saline County                  Bauxite town     NaN   \n",
       "28      Craighead County                      Bay city     NaN   \n",
       "29       Ouachita County                  Bearden city     NaN   \n",
       "..                   ...                           ...     ...   \n",
       "690                  NaN                           NaN     NaN   \n",
       "691                  NaN                           NaN     NaN   \n",
       "692                  NaN                           NaN     NaN   \n",
       "693                  NaN                           NaN     NaN   \n",
       "694                  NaN                           NaN     NaN   \n",
       "695                  NaN                           NaN     NaN   \n",
       "696                  NaN                           NaN     NaN   \n",
       "697                  NaN                           NaN     NaN   \n",
       "698                  NaN                           NaN     NaN   \n",
       "699                  NaN                           NaN     NaN   \n",
       "700                  NaN                           NaN     NaN   \n",
       "701                  NaN                           NaN     NaN   \n",
       "702                  NaN                           NaN     NaN   \n",
       "703                  NaN                           NaN     NaN   \n",
       "704                  NaN                           NaN     NaN   \n",
       "705                  NaN                           NaN     NaN   \n",
       "706                  NaN                           NaN     NaN   \n",
       "707                  NaN                           NaN     NaN   \n",
       "708                  NaN                           NaN     NaN   \n",
       "709                  NaN                           NaN     NaN   \n",
       "710                  NaN                           NaN     NaN   \n",
       "711                  NaN                           NaN     NaN   \n",
       "712                  NaN                           NaN     NaN   \n",
       "713                  NaN                           NaN     NaN   \n",
       "714                  NaN                           NaN     NaN   \n",
       "715                  NaN                           NaN     NaN   \n",
       "716                  NaN                           NaN     NaN   \n",
       "717                  NaN                           NaN     NaN   \n",
       "718                  NaN                           NaN     NaN   \n",
       "719                  NaN                           NaN     NaN   \n",
       "\n",
       "     Census_Name_2010                     City                 City Source  \\\n",
       "0                 NaN                    Adona  Arkansas State Data Center   \n",
       "1      Alexander city                Alexander            US Census Bureau   \n",
       "2                 NaN                   Alicia  Arkansas State Data Center   \n",
       "3                 NaN                  Allport  Arkansas State Data Center   \n",
       "4           Alma city                     Alma            US Census Bureau   \n",
       "5                 NaN                   Almyra  Arkansas State Data Center   \n",
       "6                 NaN                   Alpena  Arkansas State Data Center   \n",
       "7                 NaN                Altheimer  Arkansas State Data Center   \n",
       "8                 NaN                    Altus  Arkansas State Data Center   \n",
       "9                 NaN                   Amagon  Arkansas State Data Center   \n",
       "10                NaN                    Amity  Arkansas State Data Center   \n",
       "11                NaN        Anthonyville town  Arkansas State Data Center   \n",
       "12                NaN                  Antoine  Arkansas State Data Center   \n",
       "13   Arkadelphia city              Arkadelphia            US Census Bureau   \n",
       "14                NaN            Arkansas City  Arkansas State Data Center   \n",
       "15                NaN                 Ash Flat  Arkansas State Data Center   \n",
       "16       Ashdown city                  Ashdown            US Census Bureau   \n",
       "17        Atkins city                   Atkins            US Census Bureau   \n",
       "18                NaN                   Aubrey  Arkansas State Data Center   \n",
       "19                NaN                  Augusta            US Census Bureau   \n",
       "20                NaN         Austin (Station)  Arkansas State Data Center   \n",
       "21                NaN                    Avoca  Arkansas State Data Center   \n",
       "22     Bald Knob city                Bald Knob            US Census Bureau   \n",
       "23                NaN                    Banks  Arkansas State Data Center   \n",
       "24       Barling city                  Barling            US Census Bureau   \n",
       "25                NaN                  Bassett  Arkansas State Data Center   \n",
       "26    Batesville city               Batesville            US Census Bureau   \n",
       "27                NaN                  Bauxite  Arkansas State Data Center   \n",
       "28                NaN                      Bay  Arkansas State Data Center   \n",
       "29                NaN                  Bearden  Arkansas State Data Center   \n",
       "..                ...                      ...                         ...   \n",
       "690               NaN           North Crossett  Arkansas State Data Center   \n",
       "691               NaN                  Norvell  Arkansas State Data Center   \n",
       "692               NaN        Oak Grove Heights  Arkansas State Data Center   \n",
       "693               NaN                 Paraloma  Arkansas State Data Center   \n",
       "694               NaN  Parkers-Iron Springs CD  Arkansas State Data Center   \n",
       "695               NaN                Pendleton  Arkansas State Data Center   \n",
       "696               NaN                Pike City  Arkansas State Data Center   \n",
       "697               NaN                    Piney  Arkansas State Data Center   \n",
       "698               NaN             Poplar Grove  Arkansas State Data Center   \n",
       "699               NaN            Prairie Creek  Arkansas State Data Center   \n",
       "700               NaN                Princeton  Arkansas State Data Center   \n",
       "701               NaN          Pulaski Heights  Arkansas State Data Center   \n",
       "702               NaN                   Raggio  Arkansas State Data Center   \n",
       "703               NaN                 Readland  Arkansas State Data Center   \n",
       "704               NaN                 Red Fork  Arkansas State Data Center   \n",
       "705               NaN                   Varner  Arkansas State Data Center   \n",
       "706               NaN                 Richmond  Arkansas State Data Center   \n",
       "707               NaN            River Arkinda  Arkansas State Data Center   \n",
       "708               NaN            River Ashdown  Arkansas State Data Center   \n",
       "709               NaN            River Foreman  Arkansas State Data Center   \n",
       "710               NaN  River New Rocky Comfort  Arkansas State Data Center   \n",
       "711               NaN              River Ogden  Arkansas State Data Center   \n",
       "712               NaN           River Richmond  Arkansas State Data Center   \n",
       "713               NaN      River Rocky Comfort  Arkansas State Data Center   \n",
       "714               NaN       River White Cliffs  Arkansas State Data Center   \n",
       "715               NaN             River Wilton  Arkansas State Data Center   \n",
       "716               NaN           River Winthrop  Arkansas State Data Center   \n",
       "717               NaN                  Rockwel  Arkansas State Data Center   \n",
       "718               NaN            Rocky Comfort  Arkansas State Data Center   \n",
       "719               NaN                   Rohwer  Arkansas State Data Center   \n",
       "\n",
       "                          CityST              County   County_Name  \\\n",
       "0                      Adona, AR               Perry           NaN   \n",
       "1                  Alexander, AR  Pulaski And Saline           NaN   \n",
       "2                     Alicia, AR            Lawrence           NaN   \n",
       "3                    Allport, AR              Lonoke           NaN   \n",
       "4                       Alma, AR            Crawford      Crawford   \n",
       "5                     Almyra, AR            Arkansas           NaN   \n",
       "6                     Alpena, AR               Boone           NaN   \n",
       "7                  Altheimer, AR           Jefferson           NaN   \n",
       "8                      Altus, AR            Franklin           NaN   \n",
       "9                     Amagon, AR             Jackson           NaN   \n",
       "10                     Amity, AR               Clark           NaN   \n",
       "11         Anthonyville town, AR          Crittenden           NaN   \n",
       "12                   Antoine, AR                Pike           NaN   \n",
       "13               Arkadelphia, AR               Clark         Clark   \n",
       "14             Arkansas City, AR               Desha           NaN   \n",
       "15                  Ash Flat, AR               Sharp           NaN   \n",
       "16                   Ashdown, AR        Little River  Little River   \n",
       "17                    Atkins, AR                Pope          Pope   \n",
       "18                    Aubrey, AR                 Lee           NaN   \n",
       "19                   Augusta, AR            Woodruff      Woodruff   \n",
       "20          Austin (Station), AR              Lonoke           NaN   \n",
       "21                     Avoca, AR              Benton           NaN   \n",
       "22                 Bald Knob, AR               White         White   \n",
       "23                     Banks, AR             Bradley           NaN   \n",
       "24                   Barling, AR           Sebastian     Sebastian   \n",
       "25                   Bassett, AR         Mississippi           NaN   \n",
       "26                Batesville, AR        Independence  Independence   \n",
       "27                   Bauxite, AR              Saline           NaN   \n",
       "28                       Bay, AR           Craighead           NaN   \n",
       "29                   Bearden, AR            Ouachita           NaN   \n",
       "..                           ...                 ...           ...   \n",
       "690           North Crossett, AR              Ashley           NaN   \n",
       "691                  Norvell, AR          Crittenden           NaN   \n",
       "692        Oak Grove Heights, AR              Greene           NaN   \n",
       "693                 Paraloma, AR              Sevier           NaN   \n",
       "694  Parkers-Iron Springs CD, AR             Pulaski           NaN   \n",
       "695                Pendleton, AR               Desha           NaN   \n",
       "696                Pike City, AR                Pike           NaN   \n",
       "697                    Piney, AR             Garland           NaN   \n",
       "698             Poplar Grove, AR            Phillips           NaN   \n",
       "699            Prairie Creek, AR              Benton           NaN   \n",
       "700                Princeton, AR              Dallas           NaN   \n",
       "701          Pulaski Heights, AR             Pulaski           NaN   \n",
       "702                   Raggio, AR                 Lee           NaN   \n",
       "703                 Readland, AR              Chicot           NaN   \n",
       "704                 Red Fork, AR               Desha           NaN   \n",
       "705                   Varner, AR             Lincoln           NaN   \n",
       "706                 Richmond, AR        Little River           NaN   \n",
       "707            River Arkinda, AR              Little           NaN   \n",
       "708            River Ashdown, AR              Little           NaN   \n",
       "709            River Foreman, AR              Little           NaN   \n",
       "710  River New Rocky Comfort, AR              Little           NaN   \n",
       "711              River Ogden, AR              Little           NaN   \n",
       "712           River Richmond, AR              Little           NaN   \n",
       "713      River Rocky Comfort, AR              Little           NaN   \n",
       "714       River White Cliffs, AR              Little           NaN   \n",
       "715             River Wilton, AR              Little           NaN   \n",
       "716           River Winthrop, AR              Little           NaN   \n",
       "717                 Rockwell, AR             Garland           NaN   \n",
       "718            Rocky Comfort, AR        Little River           NaN   \n",
       "719                   Rohwer, AR               Desha           NaN   \n",
       "\n",
       "     Incorporation Date                        ...                          \\\n",
       "0                   NaN                        ...                           \n",
       "1                   NaN                        ...                           \n",
       "2                   NaN                        ...                           \n",
       "3                   NaN                        ...                           \n",
       "4                   NaN                        ...                           \n",
       "5                   NaN                        ...                           \n",
       "6                   NaN                        ...                           \n",
       "7                   NaN                        ...                           \n",
       "8                   NaN                        ...                           \n",
       "9                   NaN                        ...                           \n",
       "10                  NaN                        ...                           \n",
       "11                  NaN                        ...                           \n",
       "12                  NaN                        ...                           \n",
       "13                  NaN                        ...                           \n",
       "14                  NaN                        ...                           \n",
       "15                  NaN                        ...                           \n",
       "16                  NaN                        ...                           \n",
       "17                  NaN                        ...                           \n",
       "18                  NaN                        ...                           \n",
       "19                  NaN                        ...                           \n",
       "20                  NaN                        ...                           \n",
       "21                  NaN                        ...                           \n",
       "22                  NaN                        ...                           \n",
       "23                  NaN                        ...                           \n",
       "24                  NaN                        ...                           \n",
       "25                  NaN                        ...                           \n",
       "26                  NaN                        ...                           \n",
       "27                  NaN                        ...                           \n",
       "28                  NaN                        ...                           \n",
       "29                  NaN                        ...                           \n",
       "..                  ...                        ...                           \n",
       "690                 NaN                        ...                           \n",
       "691                 NaN                        ...                           \n",
       "692                 NaN                        ...                           \n",
       "693                 NaN                        ...                           \n",
       "694                 NaN                        ...                           \n",
       "695                 NaN                        ...                           \n",
       "696                 NaN                        ...                           \n",
       "697                 NaN                        ...                           \n",
       "698                 NaN                        ...                           \n",
       "699                 NaN                        ...                           \n",
       "700                 NaN                        ...                           \n",
       "701                 NaN                        ...                           \n",
       "702                 NaN                        ...                           \n",
       "703                 NaN                        ...                           \n",
       "704                 NaN                        ...                           \n",
       "705                 NaN                        ...                           \n",
       "706                 NaN                        ...                           \n",
       "707                 NaN                        ...                           \n",
       "708                 NaN                        ...                           \n",
       "709                 NaN                        ...                           \n",
       "710                 NaN                        ...                           \n",
       "711                 NaN                        ...                           \n",
       "712                 NaN                        ...                           \n",
       "713                 NaN                        ...                           \n",
       "714                 NaN                        ...                           \n",
       "715                 NaN                        ...                           \n",
       "716                 NaN                        ...                           \n",
       "717                 NaN                        ...                           \n",
       "718                 NaN                        ...                           \n",
       "719                 NaN                        ...                           \n",
       "\n",
       "     country        id        lat        lon  other_years poptype  \\\n",
       "0         US  107172.0  35.039444 -92.898889          NaN  Census   \n",
       "1         US  107215.0  34.631389 -92.444167          NaN  Census   \n",
       "2         US  107071.0  35.894444 -91.083611          NaN  Census   \n",
       "3         US  107108.0  34.539444 -91.785000          NaN  Census   \n",
       "4         US  106928.0  35.488056 -94.220833          NaN  Census   \n",
       "5         US  106807.0  34.405833 -91.411944          NaN  Census   \n",
       "6         US  106853.0  36.293611 -93.296111          NaN  Census   \n",
       "7         US  107056.0  34.319250 -91.847361          NaN  Census   \n",
       "8         US  106979.0  35.454722 -93.771944          NaN  Census   \n",
       "9         US  107044.0  35.562500 -91.109722          NaN  Census   \n",
       "10        US  106882.0  34.266111 -93.464167          NaN  Census   \n",
       "11        US  106937.0  35.039444 -90.340833          NaN  Census   \n",
       "12        US  107185.0  34.036111 -93.421667          NaN  Census   \n",
       "13        US  106883.0  34.121944 -93.066111          NaN  Census   \n",
       "14        US  106957.0  33.608889 -91.203611          NaN  Census   \n",
       "15        US  106984.0  36.231111 -91.609167          NaN  Census   \n",
       "16        US  107094.0  33.673333 -94.127222          NaN  Census   \n",
       "17        US  107204.0  35.243611 -92.938333          NaN  Census   \n",
       "18        US  107085.0  34.718056 -90.899444          NaN  Census   \n",
       "19        US  107318.0  35.286389 -91.360833          NaN  Census   \n",
       "20        US  107109.0  35.005278 -91.989167          NaN  Census   \n",
       "21        US  106830.0  36.401389 -94.070833          NaN  Census   \n",
       "22        US  107302.0  35.311667 -91.570000          NaN  Census   \n",
       "23        US  106865.0  33.576667 -92.268056          NaN  Census   \n",
       "24        US  107251.0  35.322778 -94.300556          NaN  Census   \n",
       "25        US  107130.0  35.535833 -90.126111          NaN  Census   \n",
       "26        US  107028.0  35.773611 -91.641389          NaN  Census   \n",
       "27        US  107236.0  34.559167 -92.514167          NaN  Census   \n",
       "28        US  106918.0  35.745278 -90.562778          NaN  Census   \n",
       "29        US  107166.0  33.726111 -92.617500          NaN  Census   \n",
       "..       ...       ...        ...        ...          ...     ...   \n",
       "690      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "691      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "692      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "693      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "694      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "695      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "696      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "697      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "698      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "699      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "700      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "701      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "702      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "703      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "704      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "705      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "706      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "707      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "708      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "709      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "710      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "711      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "712      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "713      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "714      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "715      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "716      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "717      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "718      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "719      NaN       NaN        NaN        NaN          NaN     NaN   \n",
       "\n",
       "    settlement_type state                    title  \\\n",
       "0              City    AR          Adona, Arkansas   \n",
       "1              City    AR      Alexander, Arkansas   \n",
       "2              Town    AR         Alicia, Arkansas   \n",
       "3              Town    AR        Allport, Arkansas   \n",
       "4              City    AR           Alma, Arkansas   \n",
       "5              Town    AR         Almyra, Arkansas   \n",
       "6              Town    AR         Alpena, Arkansas   \n",
       "7              City    AR      Altheimer, Arkansas   \n",
       "8              City    AR          Altus, Arkansas   \n",
       "9              Town    AR         Amagon, Arkansas   \n",
       "10             City    AR          Amity, Arkansas   \n",
       "11             Town    AR   Anthonyville, Arkansas   \n",
       "12             Town    AR        Antoine, Arkansas   \n",
       "13             City    AR    Arkadelphia, Arkansas   \n",
       "14             Town    AR  Arkansas City, Arkansas   \n",
       "15             City    AR       Ash Flat, Arkansas   \n",
       "16             City    AR        Ashdown, Arkansas   \n",
       "17             City    AR         Atkins, Arkansas   \n",
       "18             Town    AR         Aubrey, Arkansas   \n",
       "19             City    AR        Augusta, Arkansas   \n",
       "20             City    AR         Austin, Arkansas   \n",
       "21             Town    AR          Avoca, Arkansas   \n",
       "22             City    AR      Bald Knob, Arkansas   \n",
       "23             Town    AR          Banks, Arkansas   \n",
       "24             City    AR        Barling, Arkansas   \n",
       "25             Town    AR        Bassett, Arkansas   \n",
       "26             City    AR     Batesville, Arkansas   \n",
       "27             Town    AR        Bauxite, Arkansas   \n",
       "28             City    AR            Bay, Arkansas   \n",
       "29             City    AR        Bearden, Arkansas   \n",
       "..              ...   ...                      ...   \n",
       "690             NaN   NaN                      NaN   \n",
       "691             NaN   NaN                      NaN   \n",
       "692             NaN   NaN                      NaN   \n",
       "693             NaN   NaN                      NaN   \n",
       "694             NaN   NaN                      NaN   \n",
       "695             NaN   NaN                      NaN   \n",
       "696             NaN   NaN                      NaN   \n",
       "697             NaN   NaN                      NaN   \n",
       "698             NaN   NaN                      NaN   \n",
       "699             NaN   NaN                      NaN   \n",
       "700             NaN   NaN                      NaN   \n",
       "701             NaN   NaN                      NaN   \n",
       "702             NaN   NaN                      NaN   \n",
       "703             NaN   NaN                      NaN   \n",
       "704             NaN   NaN                      NaN   \n",
       "705             NaN   NaN                      NaN   \n",
       "706             NaN   NaN                      NaN   \n",
       "707             NaN   NaN                      NaN   \n",
       "708             NaN   NaN                      NaN   \n",
       "709             NaN   NaN                      NaN   \n",
       "710             NaN   NaN                      NaN   \n",
       "711             NaN   NaN                      NaN   \n",
       "712             NaN   NaN                      NaN   \n",
       "713             NaN   NaN                      NaN   \n",
       "714             NaN   NaN                      NaN   \n",
       "715             NaN   NaN                      NaN   \n",
       "716             NaN   NaN                      NaN   \n",
       "717             NaN   NaN                      NaN   \n",
       "718             NaN   NaN                      NaN   \n",
       "719             NaN   NaN                      NaN   \n",
       "\n",
       "                                             wiki_pops  \n",
       "0    209,187,146,230,204,154,194,218,200,241,0,0,0,...  \n",
       "1     2901,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0  \n",
       "2    124,145,157,246,246,236,299,333,342,297,168,15...  \n",
       "3    115,127,188,295,307,0,0,0,0,0,0,0,0,0,0,0,0,0,...  \n",
       "4    5419,4160,2959,2755,1613,1370,1228,774,731,779...  \n",
       "5    283,319,311,294,220,240,235,233,287,323,252,0,...  \n",
       "6    392,371,319,344,309,283,304,313,361,250,0,0,0,...  \n",
       "7    984,1192,972,1231,1037,979,680,494,475,450,0,0...  \n",
       "8    758,817,433,441,418,392,431,541,595,709,659,50...  \n",
       "9    98,95,108,126,136,234,181,0,0,0,0,0,0,0,0,0,0,...  \n",
       "10   723,762,526,859,614,543,591,608,608,680,813,0,...  \n",
       "11   161,250,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0  \n",
       "12   117,156,160,194,182,163,209,233,210,0,0,0,0,0,...  \n",
       "13   10714,10912,10014,10005,9841,8069,6819,5078,33...  \n",
       "14   366,589,523,668,615,783,1018,1446,1432,1482,14...  \n",
       "15   1082,977,667,524,211,192,265,315,0,0,0,0,0,0,0...  \n",
       "16   4723,4781,5150,4218,3522,2725,2738,2332,1607,2...  \n",
       "17   3016,2878,2834,3002,2015,1391,1291,1322,1364,1...  \n",
       "18   170,221,204,267,351,0,0,0,0,0,0,0,0,0,0,0,0,0,...  \n",
       "19   2199,2665,2759,3496,2777,2272,2317,2235,2243,1...  \n",
       "20   2038,605,235,269,236,210,154,145,123,163,177,1...  \n",
       "21   488,423,269,256,173,0,0,0,0,0,0,0,0,0,0,0,0,0,...  \n",
       "22   2897,3210,2653,2756,2094,1705,2022,1445,1273,9...  \n",
       "23   124,120,88,216,189,233,240,248,199,347,244,0,0...  \n",
       "24   4649,4176,4078,3761,1739,770,0,0,0,0,0,0,0,0,0...  \n",
       "25   173,168,199,243,265,0,0,0,0,0,0,0,0,0,0,0,0,0,...  \n",
       "26   10248,9445,9187,8447,7209,6207,6414,5267,4484,...  \n",
       "27   487,432,412,433,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,...  \n",
       "28   1801,1800,1660,1605,751,627,500,357,300,0,0,0,...  \n",
       "29   966,1125,1021,1191,1272,1268,1300,961,1147,687...  \n",
       "..                                                 ...  \n",
       "690                                                NaN  \n",
       "691                                                NaN  \n",
       "692                                                NaN  \n",
       "693                                                NaN  \n",
       "694                                                NaN  \n",
       "695                                                NaN  \n",
       "696                                                NaN  \n",
       "697                                                NaN  \n",
       "698                                                NaN  \n",
       "699                                                NaN  \n",
       "700                                                NaN  \n",
       "701                                                NaN  \n",
       "702                                                NaN  \n",
       "703                                                NaN  \n",
       "704                                                NaN  \n",
       "705                                                NaN  \n",
       "706                                                NaN  \n",
       "707                                                NaN  \n",
       "708                                                NaN  \n",
       "709                                                NaN  \n",
       "710                                                NaN  \n",
       "711                                                NaN  \n",
       "712                                                NaN  \n",
       "713                                                NaN  \n",
       "714                                                NaN  \n",
       "715                                                NaN  \n",
       "716                                                NaN  \n",
       "717                                                NaN  \n",
       "718                                                NaN  \n",
       "719                                                NaN  \n",
       "\n",
       "[720 rows x 38 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def complete_merge(state=\"AR\"):\n",
    "    alperin,wiki,cesta = state_counts(state)\n",
    "    alp_wik_merge = mf.merge_two_sets(alperin,wiki)\n",
    "    full_merge = mf.merge_two_sets(alp_wik_merge,cesta)\n",
    "    return full_merge\n",
    "\n",
    "complete_merge()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "VA\n",
      "227 matches between the sets\n",
      "93 matches between the sets\n",
      "AR\n",
      "505 matches between the sets\n",
      "617 matches between the sets\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python2.7/dist-packages/ipykernel/__main__.py:16: RuntimeWarning: All-NaN slice encountered\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "IL\n",
      "1310 matches between the sets\n",
      "475 matches between the sets\n",
      "TN\n",
      "343 matches between the sets\n",
      "144 matches between the sets\n",
      "NC\n",
      "550 matches between the sets\n",
      "229 matches between the sets\n",
      "MN\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "864 matches between the sets\n",
      "230 matches between the sets\n",
      "KS\n",
      "630 matches between the sets\n",
      "121 matches between the sets\n",
      "IN\n",
      "567 matches between the sets\n",
      "188 matches between the sets\n",
      "WI\n",
      "599 matches between the sets\n",
      "223 matches between the sets\n",
      "MA\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "510 matches between the sets\n",
      "286 matches between the sets\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval'"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HI\n",
      "0 matches between the sets\n",
      "6 matches between the sets\n",
      "FL\n",
      "406 matches between the sets\n",
      "272 matches between the sets\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      " ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n",
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "IA\n",
      "953 matches between the sets\n",
      "954 matches between the sets\n",
      "MD\n",
      "156 matches between the sets\n",
      "68 matches between the sets\n",
      "NY\n",
      "925 matches between the sets\n",
      "282 matches between the sets\n",
      "NJ\n",
      "567 matches between the sets\n",
      "280 matches between the sets\n",
      "RI\n",
      "38 matches between the sets\n",
      "18 matches between the sets\n",
      "TX\n",
      "1220 matches between the sets\n",
      "529 matches between the sets\n",
      "WV\n",
      "231 matches between the sets\n",
      "58 matches between the sets\n",
      "KY\n",
      "417 matches between the sets\n",
      "136 matches between the sets\n",
      "NM\n",
      "101 matches between the sets\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "47 matches between the sets\n",
      "PR\n",
      "0 matches between the sets\n",
      "0 matches between the sets\n",
      "PA\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1170 matches between the sets\n",
      "446 matches between the sets\n",
      "SD\n",
      "310 matches between the sets\n",
      "34 matches between the sets\n",
      "DE\n",
      "57 matches between the sets\n",
      "18 matches between the sets\n",
      "VT\n",
      "252 matches between the sets\n",
      "14 matches between the sets\n",
      "ME\n",
      "529 matches between the sets\n",
      "22 matches between the sets\n",
      "OR\n",
      "240 matches between the sets\n",
      "196 matches between the sets\n",
      "SC\n",
      "270 matches between the sets\n",
      "108 matches between the sets\n",
      "MO\n",
      "977 matches between the sets\n",
      "225 matches between the sets\n",
      "CO\n",
      "270 matches between the sets\n",
      "283 matches between the sets\n",
      "MI\n",
      "532 matches between the sets\n",
      "233 matches between the sets\n",
      "CA\n",
      "482 matches between the sets\n",
      "573 matches between the sets\n",
      "DC\n",
      "0 matches between the sets\n",
      "1 matches between the sets\n",
      "NE\n",
      "534 matches between the sets\n",
      "52 matches between the sets\n",
      "UT\n",
      "247 matches between the sets\n",
      "98 matches between the sets\n",
      "OH\n",
      "935 matches between the sets\n",
      "372 matches between the sets\n",
      "ID\n",
      "201 matches between the sets\n",
      "55 matches between the sets\n",
      "NH\n",
      "258 matches between the sets\n",
      "17 matches between the sets\n",
      "WY\n",
      "99 matches between the sets\n",
      "26 matches between the sets\n",
      "GA\n",
      "539 matches between the sets\n",
      "209 matches between the sets\n",
      "WA\n",
      "282 matches between the sets\n",
      "147 matches between the sets\n",
      "NV\n",
      "14 matches between the sets\n",
      "16 matches between the sets\n",
      "AK\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception TypeError: \"object of type 'float' has no len()\" in 'editdistance.bycython.eval' ignored\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "148 matches between the sets\n",
      "20 matches between the sets\n",
      "AZ\n",
      "91 matches between the sets\n",
      "77 matches between the sets\n",
      "MT\n",
      "131 matches between the sets\n",
      "34 matches between the sets\n",
      "AL\n",
      "474 matches between the sets\n",
      "156 matches between the sets\n",
      "MS\n",
      "300 matches between the sets\n",
      "105 matches between the sets\n",
      "GU\n",
      "0 matches between the sets\n",
      "0 matches between the sets\n",
      "OK\n",
      "594 matches between the sets\n",
      "140 matches between the sets\n",
      "ND\n",
      "362 matches between the sets\n",
      "21 matches between the sets\n",
      "CT\n",
      "163 matches between the sets\n",
      "25 matches between the sets\n",
      "LA\n",
      "304 matches between the sets\n",
      "108 matches between the sets\n"
     ]
    }
   ],
   "source": [
    "all = []\n",
    "\n",
    "states = [f[:-4] for f in os.listdir(\"wikipedia_state_data/\") if f.endswith(\".csv\")]\n",
    "# Four states that don't actually have cities written for them.\n",
    "states.remove(\"AS\")\n",
    "states.remove(\"MP\")\n",
    "states.remove(\"UM\")\n",
    "states.remove(\"VI\")\n",
    "\n",
    "for state in states:\n",
    "    print state\n",
    "    newdat,matform = complete_merge(state)\n",
    "    td = matform.transpose()\n",
    "    for i,y in enumerate(years):\n",
    "        newdat[str(y)] = td[i]\n",
    "    newdat[\"maxpop\"] = np.nanmax(matform,axis=1)\n",
    "    all.append(newdat)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "everything = pd.concat(all)\n",
    "\n",
    "for y in years:\n",
    "    everything[str(y)] = everything[str(y)].fillna(0) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "share_clustering = np.zeros((everything.shape[0],23),np.float)\n",
    "\n",
    "for i,row in enumerate(everything.iterrows()):\n",
    "    dat = np.array([row[1][str(y)] for y in years])\n",
    "    maxpop = max(dat)\n",
    "    if maxpop == 0:\n",
    "        maxpop = float(\"inf\")\n",
    "    share_clustering[i] = dat/maxpop\n",
    "    \n",
    "multi_year_filter = np.count_nonzero(share_clustering,1) > 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "import umap\n",
    "embedding = umap.UMAP(n_neighbors=25).fit_transform(share_clustering[multi_year_filter])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "[x,y] = map(list,zip(*embedding))\n",
    "everything['umap_x'] = None\n",
    "everything['umap_y'] = None\n",
    "\n",
    "everything.ix[multi_year_filter,'umap_x'] = x\n",
    "everything.ix[multi_year_filter,'umap_y'] = y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<matplotlib.collections.PathCollection object at 0x7f3c58262890>\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXwAAAEACAYAAACwB81wAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzsvXuQVdd5L/idPn2e/Twt3gjopkECBIjGlq2XJaGnZct6\nWFZkI9lWjBBChcGDFEmmggjicuuCA6ngWwKDXaFuANOpucXcaU/mdiaV45m0clPtmXHkmznKw9fR\n2GM73iSZJDfJndgmv/ljrR/r2+us0wLUj9P0+qq6+jz22Xvttff+fd/6fa8MAIkSJUqUKFe/tEz1\nAKJEiRIlyuRIBPwoUaJEmSESAT9KlChRZohEwI8SJUqUGSIR8KNEiRJlhkgE/ChRokSZITIugJ/J\nZL6WyWR+kslkvqM+q2Qymd/JZDJ/mslkhjOZTNd4HCtKlChRolyZjJeF/xsi8oD32asi8rsArheR\n3xORL47TsaJEiRIlyhVIZrwSrzKZzBIRGQKw1r7/ExG5E8BPMpnMPBH5JoAV43KwKFGiRIly2TKR\nHP4cAD8REQHwlyIyZwKPFSVKlChR3kUm02kbazhEiRIlyhRK6wTu+yeZTGauonSS0EaZTCYqgihR\nokS5AgGQuZztx9PCz9g/yv8oIs/Y158Vkf/Q6IcA4h8ge/bsmfIxNMtfnIs4F3Euxv67EhmvsMwz\nIvIHInJdJpP5fiaT+UUR+Tcicl8mk/lTEbnHvo8SJUqUKFMk40LpANjY4Kt7x2P/UaJEiRLlvUvM\ntG0iueuuu6Z6CE0jcS6cxLlwEufivcm4xeFf8QAyGUz1GKJEiRJlukkmkxFModM2SpQoUaI0sUTA\njxIlSpQZIhHwo0SJEmWGSAT8KFGiRJkhEgE/SpQoUWaIRMCPEiVKlBkiEfCjRIkSZYZIBPwoUaJE\nmSESAT9KlChRZohEwJ/Gcv78eenv75dMJiP9/f1y/vz5qR5SlChRmlgi4E9T+frXB2XOnPnyve/9\nSEQWyfe+9yOZM2eufP3rg1M9tChRojSpxFo601DOnz8vc+bMEZGCiJRFpE9E/kJE/lFEfipJksjs\n2bOncohRokSZYIm1dGaIvPPOO/ZVVkS+KSL/UUT+rX0vcurUqakYVpQoUZpcIuBPQ+nt7bWv5ovI\n2yKyQkQOCRuOfe1rX5uScUWJEqW5JQL+NJTZs2dLX99SEfmhiGwVkX8vIsdE5H8SkZK8/fbbUzm8\noHzjG9+QWbNmSSaTkZtvvnmqhxMlyoyUyOFPY8lkMiIyT0R+KiKLROQHIpIXkb9sKh5/zZr18sd/\n/CciMktEfiwiPxcRueK+nFGiRIkc/gyVvxORqoj8kf3/dyKief6plW984xvyx3/8tog8JiJ/JcbB\nXBKRVslkMrJv374YTholyiRJtPCnsbS2tsqFC70i8l316TIR+S9NY+EvWdIr3//+v4gB+z8UkbUi\n8h0RuVnMyuTCxW2ff/55OXr06FQMM0qUaSfRwp9hcuHCBTEUyXfsJ9+x72VKwf7NN9+UG264QTKZ\njHz/+z+wY1okBuzF/l8gIq0i0i/G4s/KsWPHJJPJyD333CNf/epXo+UfJco4SwT8aS8XROQuEVlv\n/xuL+fz583L+/Hn51re+dUnAefDgQVm5cqU88cQT78npe//9H5Hbb79TarW/EAPmRfvNDyStmH4k\nJpz0u2Is/7yYvILZ8nu/94eyefM2mTt3SUwkixJlHCVSOtNYli5dKn/xFz8UYyHPFZGfiMh/E5Gf\nyrPPbpbf/M1ByeeXyM9//kP52tfekHvvvVu+/e1vy9/+7d/K3//930uSJFIqlWTnzl8SE9LZLiL/\nVUQuyLZt2+XLX/71yxrPN77xDfnYxz5mx6Ppm1tE5GdiLPqFYqKL5onI99Svl4vIZ0TksIicE5GP\ni8i/SKEg8oMf/HlT0FNRojSTXAmlEwF/Gstv/dZvyZNPPiUm4apDRP5eRCAGVH8iIj32s9skm/3f\npKWlVX72s9lirOufi1vgZcXE9P9IRLpF5G9F5L9JrVaTlStXXtJYvv71Qfn0p5+VCxe6xFj12q+w\nXkReEpFN9rhZMRnC35Q0p/9/iMhGETkuIltE5B+lUPi5/P7vn5WbbrrpMmcnSpSrWyKHP8NkzZo1\nYgC+RURyYoC0XwzI/4qYiJ2DIvK/yoULF+RnPzsgIq+KyHYxFn1ODPD+J3HUyj+LyG+LSEl+7dd+\n7ZLGcf78edm06QW5cOFNEfm2iPy1pOmb/1tE7hORBZLLZcXQTv8oxvJfJgbsN4tZBXzffveOGKX1\n1yrRLEqUKO9FIuBPY3n00UfFcN+/LQao/1BM5m1VRP61GGB9w279cxHZKSL/RkR+3X7XJSZMUjtT\nrxWRNhFZKN/9rrbSG8s777wj+Xyv/f1sMUlgN4sB87vsGH4shcLfyA9/+AOp1b4ju3a9JPn8BRH5\nLyLyLyLyDfubnIh8VET+STKZn8pv/MZXmorOOXjwoCxatEj6+vpiRFEDOX/+vHz1q1+Vl156Sd58\n882pHk4ULQCm9M8MIcqVSCaTgchyiIxCZD1EoP76IXLavn4LIiWIlCGyAyIViPRBpGhfv6W264FI\nFSIlnDp16pLGkSQJSqUebz8liGQgUkA+vxKlUg/OnDlb99uRkRHcc899aGnJo6WlGyKCG264ASdO\nnECSJOM9ZVcsSZIgny9DJGvnbTlESujpmT3VQ5tSGRoawq233opFixaht7cXHR0dEGmBSIedK8Hc\nufNQq9WmeqhXnVjsvDy8vdwfjPdfBPwrl/Xr11tgrVqg9gF3GCKJ/WwtRNotWHG7AxDJW0XQb38z\nDyIlLFrUe1ljOXPmLEqlHnR2DiCf78L69e/HqVOnkCQJRkdH3xW8L3W78ZZTp05hYGAAy5cvx6OP\nPoqRkREkSYLh4WEMDw8jSRIcO3bczhvnqRMiZy/O8xtvvDGpY55KqdVq2L9/P2677TaIiAX1AkR6\n7fy02vtouf2fs/dYDhs3Po2TJ09G8B8niYA/A8VY0Q6oDSC12dc3WkVwwP5fBZHF3kqgzz647u9S\nLXtfpgq0L1dOnTqFhx9+GN3dsywYaZBqtfNQhkgZmUxhjJVQApFl+NCHPnRx376yuFrk+eef9+6T\nAkTmePfZi/a9b3h02DnMQWQJRErYtm37VJ/StJcI+DNUjKXPB3F+A2t/N0S6PQuf383C/v37p/o0\nJkUqFYIULdCsAqk++7rPApooZepTZmthKDNn4Z85cxb5fBdElkGkjFyuHWfOnMXQ0BA2btyIl19+\nGUeOHJlWFm6tVoOhaArKoChb8G737qUuO3d6npZbI2Oh3ceRi/fddJqHZpQI+DNccrmcfahu9B66\nZfbzvAKxZfZ/BSIlDA4OTvXwx0VqtVqQNjh16hSy2XzAAi3D0BGn7HdcDd1o34udN9/CL0OkiHK5\nE0AjP0bFAmPB/hUvAt+cOXObzk+hJUkSrF69FmYFmbNg7oN7r3efrbbnGbLwqTgHLyqCkydPTvVp\nTmuJgD/D5eWXX4bI7AColdDdXcHIyAiGh4fhVgOzIFJCS0uxaYHncmTbth323JdCpICPf/xxPPfc\nc8hmCzBUTau1zDVIrbOAdJe1TkOrI0E9h/8EREoX5210dBRtbb6iXWuVRRccLbTe/s/DWM65oDN7\nqiRJEtxww2p1zv0WxPsD8xYC9xbPoMjBUIz8SxAt/PGRCPgzXJIkQZq+WXMRsLScOXMWhUInisXF\nKBQ6mwpwrlQM9aAt9B44h6IGIF8Z9kDkOJwl7oP2GpDeaWkpoKWliELhehSLldS8hS38dogsgKHZ\nyqhfIRhnZrMo3Bde2AbnE+q3iuksGLUVXr1wW4K95vmzcL4lOm8NlTYRHD79JydOnMBnPvMZbNiw\n4Yr9UdNBIuBHwZkzZ5HLdcIst/Po7e0LbjddHKyXKidPnoSx7HsgcqcHRAcUULWhHtDestYs6S5f\nIRjH9tDQ0Jjz5jh8w3Nns0W732zAQu63yiAHkQyGh4enYNacdHVdA+eMrXrnn9j7SXP4eTDscvbs\n2bjllluwY8eOi1Z7rVbDjh07cN999138vBHdNh5i7vsOOPqsBEOf5ZHN5nDo0CG88cYbWL9+PQYG\nBq4KRRABPwqAqw/ML0WMhV8AfRLhiBpAZMBa3Iyn70c2247PfOYZbNiwAY6SWGN/t/uihZ/LFd51\nHH6Uzpo165TVrMfUaY9/ECJF9PUtnYRZCo+3ra0Lznm93J73WTVfp+280pEtdvzNEW2TJAkKhU4Y\naq7NKqQumFVuDo6KK8LQesY5f7mhx80mEfCjzGipVGZZULrBs6bXwiSnvWVBoA0iJy9a3yMjIwB0\nREqr3Q/3R+tW8MIL2y57XENDQxb0yYnTQi7DcPpliMikctq1Wg2PPPKoAnBfIXVZS79sv8vbcxCI\nPG/ns4pSqWfKDYvPf36HGlvO/m+DCxt9yyqwCgy1x1DlS08ubEZpSsAXUxTlLTFFVkYD30/YhEQZ\nWyZyiT3ZYkBV7EPdiXpnIhODchCZe/G1b6F+9KMP2/3Q0meM+TaQ9rlSgCuVGAaaDYyxiF27do3H\nVIwpSZLgYx97DGnKSxCmnPJ2vjphomuWoVBYmNqus3MAo6OjEz7uRvKpT30azneQVVb9QzA+lOUQ\nqaHeGW+ouocffnjKxv5epVkB/3siUhnj+wmajiiNJEkSzJs3X1l2xaZYml+pnDlzFo42WW6Byo8Z\nX4tcrgMjIyMYHBxsGA9vopiYiOU7WY3z8aGHPnbFY3XA5APsUmQyhQl1oB87dhyZTBlm1XIUhuY6\nYMcTcir3wWVxVyFSstSJ224qLHxSlnv27LXXis55htgyKovO+g4Yis5f9RWihT/efyLyFyJyzRjf\nT9B0RAmJAUdar0w+ykAkj8OHD0+rxKBTp07hpptuQpiSYGZnDoa+MbTEuwGqAfx8AJDJZRuL+EpB\n7n3vex9cdIu/CvnAhABokiSW9tB8dtlawO0QOQeXazAAFzY6HzqLe9u27akSGo3qI02k8PgdHWss\n0LfY8+qG8bd0QuR6b36rwfnu6qpM6tjHW5oV8L8nIv+7iHxLRDYHvp+wCYmSFhO22QhsGKHRi2Zx\nxo0l117bB8cr56zy0gC9zALXfjiKooiWlvKYZQ+SJEFLSzEwR3T89kNEcO21i69o3Js2bYLLXNUA\nW4BIZlwpkiRJsH37F9DS0qaUvB9aWbLntd0qyWtB6uqRRx7Fjh07sH///pQRMFVBAenQ14VKgS2E\noelIwXXDlHDQ9wO/Xw2u1Kba9/BepVkBf779P1tE/khEbve+x549ey7+VavViZqfGS/Geg3Fms+C\ncyh2gw6tZrX0T506BcfblqyFGlJiOehEH+OILKFUWoNisRv79u0PPvSmWFoexvr1wzdLoDPw8cef\nuOyx79+/H44zT2Ccn1QkeeTz7eMCRG4l1wKRT9rr7tMaAxYsWVX1HERyKBbLTQmGo6OjyGavhynV\nwES4t2A4+tD1r3rvO+085HDs2PGpPp3Llmq1msLKpgT81MFE9ojITu+zCZqeKL4YwO9F2oHFsMNu\nZR2VIbIER44cmeohB4UUVFp5bUc6wYrc7oA937n2N+mIjWKxgn37jAWrwylfeulle5weOyd6P8MX\nQeRyleLhw4cRpqBMHZqbbrrpPc+PWclxxbbYnkcoi7gCE81SVPOWbUqwN+fUqubuNFx9o1EYy10r\ns1X2/FfCKf8dEFmEcnnplDqax0uaDvDFtFNqt6/bRORNEbnf22biZiRKSkxN9y6kq2eS4jkHw3Wf\nu/iAPPvs5qkecp248S5TIFa1D/1JON4+A5FHIPIaHIffC2NNa+CrXrT6DDgWkMnkcffd9yhw4f6r\n9n0NpI2ee+65yxr/k09+Ei58kBSDCxN8+umn3/Mc5XLMKF4Ax3MzAc0lhrkkpTxEHofIIjzxxJPv\n+fjjJUzeMjV9eF0LMPSdvo4J6msdsU4UaxgdB8Nyi8XuplRqlyvNCPh9lsb5toj8ZxF5NbDNxM1I\nlDqh08twtS0WAMjlXge39G0ZN3phvKSvj1Yol/FtEPm4N/YeGMqF58TfMIpHW4ZnYSI4WMmRSqEA\n5xsIOTN3KfDP4+GHH72kcsiGKiLYX2dBqNOCvonF37JlyxXPz9DQEPr6ltoxbkDaMV+ywLfUztsO\nuGJmzE/onHQwTJIEg4OD2LVrF55++mncd999+MQnPoHFi5cgXaaB16eqgJ4rNYaQlmFyMLjCexF+\n/gMrmF4N0nSAf0kDiIA/6bJx46cVGIRCEOnEnYt9+5qjbPLIyIh9ePvtg94Dt1w/4I29gHAsvtiw\nwjLMSoYZmWuQtoCpJB6GsybJtS+DS+jJwcTnlyCyGPl8V0MwMZQEq5UuVnOeWCVkHKVbt269ovnp\n7mbRvDlwYan11T3Nsbmi6ILLQO6HyNYJj6tPkgSHDx/G448/joceehjOar/Gvubc0rHNktWdMEqS\nirrHXoui3XarN5dmP5/73GYMDw9jcHDwqutREAE/yrvKl750yAODV5COcCGomVopzbL8vfvuu+2Y\nihaoTsM5ZHXphH77sF+vzgn2nDrR2tqB9es/gHQ9nf0wlqHPcbPujq84anAceLcFpZMYKy59cHAQ\nrpxDGSIbkbbAjeU/NDR02XPjlPZuuLIQZbjyCIALK3Ux9WZ7fV7nxjUslNE8IyMj2LVrF+644064\nPATWvSHg665rdyKd9HbAzpsfaslSDy0Xf5/JlLFnz96rJqFwLImAH2VMSZIEuVw70lE6OsJBp5+b\nhKWpzqSkzJkzB84Ry5IErPmiSye0WzDpDgB1J8IRPT32d34Uyzw45zAtze0eiJJCOQGRYZRKKy86\nfwcHBy9alnPnLgzM8yK4UgB5iOQvuYgaa/b09PTYeVmG+pr1FdQrxQE7Vyvtea2Di8kvj8uK7o03\n3rDXK2OvBRUS4/rpQ6ACDF2rc3B+ExawY70frsAE2ewctLa24wMf+CAOHTrUFMbJZEkE/Bkuofho\nXcxreHgYhcIK1Fuy2vL0k5eaI2rDlSTwqzlW7DhXw3HsbNihwYHNR06iPmZ/AMaBHbIgK3A183Pe\nsbvh6syU1bEKHrjRh6C7QSUwfpQdcMXUWiGSf9eQwRde2IZMpgjnb9DOTH1e/facdViptvD3wlEg\nm97zaq5Wq6FQYNQP4+RJLxG49fyW7Rwu88a9zM4HlfpipBv4mL+ZWCRQSwT8GSx0xra1rUQu14Y9\ne/bi1Vd3IZtts0BTRjZLHnebfZDWwvGl5Mc1IC28CLRTuTw2dXIaVXPsh3GikmNfDZcRm4PI63AU\nTAmGvmnEbzNTUzsB/e3ycFZxDiKbUR8h0oWwY7Fk517nBrRD5DF1boaT3rNnb3AuKpXZdpvldqxc\ngZxDvSKn8inC+TuYgDT74vkUCouuKGt2aGgI73//+7Fw4UJUKtfYe4hKkiuilfY4W2EUK+A4eJ4v\n/S2ag69658EVgeCpp54aj9tq2ksE/BkqLgNxowWAHrh65SEelBw9I1dIKYSoHQKnoL29A1u2bJl0\n8L/vvvsCIK0tVd/qJvAvQr3lmIXhiMkZd8FFzQAmcobWZKig2BIYJUJ6qN3+NlHbXWfn3Q8BJXgV\n7f63wymSdhhr3ymHhx9+LGW9zpnDaKIKjPWrr2c3jPKhM7NdnQNr8i+wn7n5KhS6r8iZuWLFarjK\nolRCXG0dRT1NQ6XqW/qahtNljPcj7Zdhs/neKe8d0CwSAX+GimmvtxKO8qB11QJn3TKh6i2IPIg0\np7rQPrSz4Kwp3+Kik60XIkVs3Pje48UvVXp7exEuncA4cu3wY7x1F8It+AQiIzAO2eUwSVTL4azk\nbvtXRT0n3mn30QajFM/CUTmaNqGFr0NA+bccrm67rtF/FCEHcT7fjmPHjuMDH/ggnFI+ba9rO1yO\nwDl7Ds+refHPPQffT9HWtvaSfDTaAXvbbR+Co6tYs6gbRsGWYBzgvtN4HUxbSHa9Alz003VwCiJc\nxtjcy7vR2tqBJElmPJ0DRMCfsWJC/kh53Og9KI8qgOy3YOdzqokFoaIFopVwy27Wa8/BXy186lOT\nA/pdXeTjfQC724IrHbrsvVqCUXq0cnUsfjeKxT7LgevIFsbxX6NA8Tgcx0wrfJ59PYjGVmwOzur1\naSGuTMpwGbs99jVXGXpF0QpnPbO5x3q4Bh89cGGlVOBZ1DcYXwaj7NJK7N2icmq1GrZs2Yp8vh0t\nLZ12360Q+QhEPq3GFLLctdO4BNfkPA+Rp+z419rPlqHxikjAXs2vvvpFHDt2HKVSD7q61jekomaC\nQoiAPwNl586dKBTI1VY9YGGBsSocl/sYjIU1irT1edYClQYYn5fWER+9EJmcph2uAbkOY8xD5AiM\n47EMo6QqgXlog7HMGQpowD+TqcApSd9RzZj8HhhrlXO3W537XNRTPtdB922t76nr+x7mY+y+sUX1\ne195hLanMuHqhiWQCZxZGIVmrPNGeQNJkuD111/H7Nnk+6kwW+wc6s82wYTADttr4CusBWo+n4MD\nfN9BzpWLvyJaZq99Drlch62SmT5vX2nRnzWWQrgaJAL+DJEkSXDo0CG4bFBaqBpQaDnNhikXUILL\nJA1FTbioHAMKfuQEQx/1vgWf/ewzE3qud9yxwR7rCRjwZh9YbZUfUOdQRppPX9sAYAoQuRX1oD0P\n4WQ08tNsEF9DOJ2/6r0vwzlXNQB3wOUV9MK13yM9RcuZCsgHw1GEo41GIbICjr/XHavKMKuBNmQy\n+boqmABsjXldmC60gvHPuQ9OEfjfkSZ8Ci6HogP1BfzmqnP293HSjv8gzMqKyXDmtx0d63Dy5EmM\njIxg//79NvTYUZI6+ujdLP/ptDKIgD8DxFRBJHCHMiq1M9OE65nmzhqcSPfMs/+XWhBjtEgoNpog\nR06fkT1XXhv+3cQkidEKJ7iHkqH8xKvTSANGBvk8rU8/QsRXBPRX+MW4BmA46gJcyWVy+KSRZiGt\nbJbba8Dj6Dr0Z2HA9xm4yKBuuPpGBQtwc+y517xrwmvszwN9AVzNHbXH64XIs3abG+FWD61Ys+ZG\nPPjgg+joYJjpPDQO81wS+Gy/PT4znHWtnq32u5ydv+vh+gXrsXfAdabSK4gHka7/k4MJZ+2Aic56\nDS6sOA/nv/qQ3dcARMr46Ecfwpe+dAjFYjfa2q5HodCJffv249SpU3j88cexY8cO7NmzF4VCNzo6\nBlAsduPVV3dhcHAQhw8fxosvvoihoaGmUgYR8K9yMWWBS/YharMPkG+h0gFpYqCz2SLK5etQv1S+\n3j4UXTDgzYqJebj4aYJZO1ztcR25Y5brGzbcPe4PgqlLTzrDt/h8flonXnUpgDDjzOWY9FQNAE0e\nrhom6+qEAKkC57iuqs+LMHVrGpVSJoD59NhBGHCsoL44WxFuxUZgrigwIz20HS4qh7QeE7Co1LUD\nv1ENmja44mR0XB9F/QqmG/UWfgUuMqrXzpHOgiaPz5LGrN1Eyoyhwcft+TNapwRD2fmO8xLMCob3\nuDZcGHVFv4z/uwxc/XxuT98HHd07YJQsax5pw4pZvXn09y/DgQMHUvf9ZLcMjYB/lUqSJGhr67I3\nHDn2NWDBq/ob24TLtba24dix4ygWuwMPr1kJlEo9OHbsuI3R11TGs/ZGX2CP1+49yIxJ3wSuCMbi\nSxslhTVSFKOjo8jlrkE4Oie07GflzLN2jEvt+bzfjp0x9r5jdJUCgSKc/+IA0pYlFaCmXUpo3A6x\nCFOB0u8/wPwGWtHz4JzjLL/MeT4Nt6JhNdMjcEongQHmNtQDI6uhUhFylTQCF91zD9J+EVJQdAzz\n/YCa23mBzwbgch/G6hT2OFzeQBkucUxb5iwLcSsM4Pr7WwvjLyCFRAXlK6alqL9v2PqQ4aGMbiLl\nRce/vr5cYfbD+VPSr7PZdrS1dcApCcHGjROfKxAB/yqUT31qI1y8PMGHYYGaJ14KkSI2bLinrlDU\nmTNnLa/pbuRisTcF0EmS4MiRIyiX16qHhDx1qJwBrUMCZQYiLwajPkJOtGPHjqNQ6ERHx5qgojBl\nIEL0DSmRdnC5boCrAw4ESTsRRObbce9FGBhrFkSWwkX2EJDKcErtlAWOQRgLnc5k39/RDwPctLh9\ny5phnI9751e1v9kLpwRo3fu0FvnuZfb1DagHxk44iqkPbiW3HI3rBLV54ykirehLqLfiqeAqgX3y\nO95Di+zrWRD5DIwSKwSuC48TMlSG4ZRmSInTec7w1dNwobZU3h0wxgwVwDX289A4eF9xNTaMtJLh\nako3hZdUg5ydO3di8eLF2Llz57hhQwT8q0hMdchGJQ/0MrofdLKNtZTUJRZqtVrQsk63kOOxQi0R\nK3BUyHr1voz29tWpuO7QPo1PoQQd5lkq9dSN65FHHlHH9+kS8tV0emrLkTSU3pbL/MVqf8w61vQD\n/RNzYKzpGpxVTv6YNAsVChuraJAQCygFOHBttDIB0r6FEkxp31E7hhAwdyANzKFtdgYAqRuGcz+K\ncGLZQu8z3Rqww86fpvu4MpgNc7+6BvItLW1Yt249Wlq4zTy4e5rK62n7Wai8wvVqXqjcN8EoXN4X\nVTRObutXx+2y++q1v21HuuxGCQb0/TlZZq/DKIxB0GPHxfGOFUoq2LNnLzIZrgbMtc1m8+OCERHw\nrxJZtmwFwp19+DdgH5jToMUyMjIyLsd29fL77QPegnpahZE+viVXrquhPzo6iq4uPf4Eodj0YnEF\n8vl2lMv9yOfbce21S+Aad8yxQKQdoqR2jsOAJpN/Qo7AdUhTX+eQXqrTwcgHn6WGb7T76ITjiVfa\n/0uQzmAuwzUzYe2X19Q87QiAyRq770agdT1cgpgPQj4w99rzXw4DbrOhexSHV0khJeFz9D0wQFiA\nATzSKEdglFIZrsHMQ3a+F0OkBS0tOintuN1eH9P3M/hj8Usu0E9BCo7zqZUlaTe/mmpVnbM2Hqgs\nq3b+/BUFv9NFBhO13SjqI45IH5mghtC5jYelHwH/KhDjqGRNEr+zD28YLp27INKOlpbxbdmWJAm2\nbNkK1mgXaF0uAAAgAElEQVSvv2GZ4KRvctPcO5stp4p/uS5b/P3pwG/Z0YiUQz8cIFdhltChpfaI\nej0f9YqR4Y2sJ5TYh1xnHWsQJLdLxaGX8f41IIjQybjC/o6x+n0wgL8cIocQjqjqhEmMK6trPWr/\n0xFNjrmKeseuP55zcCUfKjCW8IsIh2++DmO903rugeuQRS5dJ/C12n322nEcR3pF0gKnGDSoHrfX\nvB3pyB//vqbiXAJ33+mVBFdVmrrzo5ZY4I70I1czq+xc8JpTgXTDJbyN2t/4KwrSqVrBUMmQ9isF\n9svrxCS8tEJYvHjxe35OI+BPY6nVakh399HFsHRUBTnIOWDD8fGsYU5JkgStrW0wXCsVDB/uUMw1\nG0Sbpfqrr37xYgq88R9UYHhmOoBDliWX2OvsObJZBzNLCzBAyPA8rkJ2wIC6b52VYbj2kn0wGQMe\nWjURoEbhinwRBEYD2w9YsAjRNOwT/BQc9cDVAjN/08t8s10FjiJrh1NQftLZber3pEbmev9Z675R\nOegaXIasViSkrQhU2lLlOFbb/we88+bK5hWIHIZpIMPrSactx0LLmEruONIrrhxEbocJvXxKHVvn\nm4R+Q6rLrwdFI4UK/3r7+SbUU0PaD8QENvpx9MqBfou9cCsPVvo8DnOvMoP9XGquooU/g+WjH30Y\n6T6nrAipw+5o9Wil0Dtml6X3Kq++uks9aDthQJUPCi2+ATiA6oVZ6lchUrgY62woHbYkpNVdsQ98\nIw48ZBGXYACc0TS6fZ0fSkrulhTLKBxvHVo1UaE8D6eQ3s3CD/HgLNBWhMsy1b/rRn1Zhmpgu047\nZx0IO5pX27ngedNBeRSupy+PT4c9wyZZb4hzvAQuzJHKqAjnkGc4ZkhxkGZbAxdiqQ0TXynQScpC\nbhW40hD+tSbfHvJjMfy2D+Z+4gpjoMH1pVFB40P7nrgq8DOLKzDKj4pXR22V4fJWqggbMW32Ol0L\nZ6yUkMnkxuX5jIA/DWXZspVIO7tCy3R29qG10IKnnnp6wlu2mRo9bDoS4oFrSFMQjGPugbHEupDL\ntduw0NPqxmd1ySNwKxcNmv0wVmEITAswVUFpNdVg6An94Pqx8iW4SBwCxxfheHfyyLQS+eCzCJi2\nnKnwFsOAsnaevmUfcgKZdu7xbwUM1TOgPhtFOMmJcf9+FAp74GpK5SwczaBpkIy9frR+6fvIwwA/\nndlc4bAjWhccLcLw2xAVNwrnL/HvkQpccAGVQs7ue4Xa72Bgntbaz0swSsznyXWCne8LCK3g1sIk\nuYWoPCrIVnv9aEgQ/LtRD+hMRGT8vn/91sKFy3KlkMONNw6M2/MZAX+aianzTqBi1AcBFHBJVFl7\nEz4CF+pXfNdGGeMhJrNXAg97KKOVD0z6gTJ1+QmcVbiomW4Yyij0ENJx6j9kpA164JqAM3abQOaD\nx3UwjsVz9nvyyZoT5jG6YBQDFS2dtL0wK4ZhmCV8u71eulYOuWyej3b0aWBa7X1eDZwrfQr0CfjW\no69oupGmtUI0oKYr2mCol5Kdm1HUgz+jnMoIx/pzXkoQuSMw7wNwUS7ayj4A1zuYCjpk7OyH8c00\n8rkkaOwLqA8MCCsWFqir2u9fQThklcfTv1sIdioLj7/X7ns7mCw2ngZaBPxpJk89xfoi5FzJ9XbD\nhAt2wnD1rLPCh6sPIhVks22TkubtMnzH4t07IfJA8MF46KGHbXVKPmyb4Thg1pnR9FDBzgE537VI\nOxAFzvL2q4P6qxF+TktYA32oZlA/jGWuqSANbu0wYMWiaq1wSV3Lka6jPwqXEOaDPHvacv7ugStL\noMGWio3UHjtKhSprzoaxbEOURlntZz2cZcsKm5wfX4kMw1E+vP+4wmi1c7FBXQ/fwi+q382zr0NB\nCFyxkBbaDdM2kkbCfjsel0FtFNewvRbaUOqFqb3UqbY/YL8PJSrOUfPSY//ezcBh68aseu3fqx1w\ngQUViPSNa3BFBPxpJocPH4YBL4KCb5mxrgt56gqcIjgHkTIGBwcnfJyjo6PIZFgiwA9pa4eJBGFf\n15Dln4MrolW147/e/t8Ct+xljDsbgzBypE2BBgGqFfUW1XwYC5sOUB9kOR6Og7XvfZBL1LYjFkxW\nWXCpqO2rcPVj6MyrqmNqH8BJCwaAA+Qq6iNv0oXBHG3CY52EsURDwEUnYiOntL8q6IS77/zwQtJD\n5NfpBK7CUU03qONeAxfvrkNds0hnBpftdR6GowRXwCiwYfteX2udidxp/1giQdNTvuKnommDKaNN\nMGazFZZhCFnnIX8F96lXTLvhVkxsv1iAUZA0LjjvBy7W8h8viYA/zcRw5LxJ/A5JGvi7kV5eE0Q7\n0NJSwJe+dGjCx2li8w/ChTdqIFkIt+wvwdWmKdsHnst3jnsRnEWkY7tP2j86LFfBRT9w2a0fwBoc\ngNKxSJrlKbuvdUgD3w1wMexn4RyatATPqn3Otfulc/mLcEBKOokrsH77fj8cHcV9diAdvueDK+dx\nHsLOv167byowriQ6kI6YOYvGSV4dSPfUBVxnLq2EtKLyFeowXLIfgTxrz5mO6nMQedJeL7bI5HF3\nqOtJxU2lUUA6Ae4E0kl/fB5CeQUVpJV0K8xqU/tyGDnFyqTsV5BDfZYyE/f0CiyLDRvuxhe+8AXc\ncccdNpnK3DetrR145JHH8Oijj+LBBx/E+973PrjgCtbjKY17cEUE/GkopiIkY31pmYWW5HQSrYap\nc6MBpXXCm5GcOXPW9sf1gUQ/bBX7oDCdvTOwPR1YGvy4zCf4M3mIbRizqKcwlsHwrfvttqxk2QYH\n0HtRbwn3IB3DXrVjfE19zogMjp1WXDfSxblIP7SpsesaLBm4yo4tcOUFQiuPbrCJuaO3uuxv2hEO\nhWyz57wATgkndix3qPFoOkcfswv1/HcJBqgbUV0VO8a7ke6zoLNuGYmlnccE4LESzXTpiOUwCnAp\nXBXNRspyAK509zq4JK2Pwgdtt0LWyVEhvt4YK4888miwjLTOXG9kte/evRtLly7Fpk2bJoR6jYA/\nTeVzn9uMdBkFf0mewBUxaxQxU2zY+Ho8JEkS7Nq1C/UZqmeRfvAIFj324fK50GuRzt6lYzMEAlw6\nh8Ib6dcowfHh5KFJCWlOX3OrLv3fZZ2ehbHo/WvARBzy3sz+9cG6UferHhgAmwOXVHQaxtotwyU9\nHbfnsxiO6vCdvlRYdFbS1+G3WOSx22D4da3IuGos2Xmgpc3ooy44GsWnf7QV3Wc/I5deg3Pq6hWC\nf8x5COc1LIdRur12f4yxZ/VPrhJCxpA2Ojg/y+Aa+ggqlVnq2nEVuBpmRcLPOcYetLa2T0pQxHuR\nCPjTWGq1Gp544gk4iofWpaYdaJWs8h6WNaBVc8cdd+DEiRPjalHs2bMX2Wy7BS1SDG2opx/opCvD\nxVCHltWaIx2Fc7qFeOf5FphuUwCgI2N0BIq2Fmv297pQGFcBjAVfDiavmbGzoTnb7YVS7RuF4F3v\nfTYAZ2mStsjBKac+pBN5noWziAnejbKSR2FCFUORKyWI3GvHyQgf1vThMXMwioXhmgvU9gTrA0jz\n8VSKegxcEXBFpZ3VjVaqpO8afV5G2qLX3/M+4nFpufu+JU3tZC9SnrVaDR/+8INgiWMH8EU4w6KA\nD37wlqapeT+WRMC/CuTMmbO22BRBqYR6R6Fv9ZHzXgi9Enj11V0NC6W9mwwNDWHjxo249tpFqC85\nwIdOJzrRSdcDtqQz41wFRxPQqViF4XkJfI0s/E6kLfkqDLfrOx/9yKDlMLH5tPyqcJUQmfVJaqRq\nj7MILg2f57kf9dSG/p7Hb+T8HUa6RHEHXOneLFwWcyhChvPph7mW4HrDhiJJcnBhqnSmEhBDsfIM\nDND8/lk4IA3VpGGmrr5e+r6k0hjLeUwunbXpSU/lG/zuevs9Sz7QeFhkr+ujcM7YEkRacP/9DwTv\n+1AhwaGhIbz22mvjVpNqMiQC/lUiSZLggQdoiSwM3PyL4BpAUzmw+l8nnBVukj0KhcWXVKueN79J\nBvPrgu+CW1nU4LhY8tu0+KmkfO6cDycrDjLqghandsjpSIguOwfrYMI5cwgnKfmRQUU4i3RYgZcu\nl+vXg7nTjvMWpCODfErlEByVQmBkYhYdfl1wlu9x+/sbYJLNWIqZtMschMGbSkHvV2fA+quPElw0\nDd+HFIlWjlQevsLS4aVakRZglGWIS2f5Co61UcvCAuqL0Wk/QL7B71irh9dF+zN0VFArVq5cPclP\n7eRLBPyrTF566eUxHuzF9oEK1XjvRDq6pBUiz4xZq75UMk7HbHZZg2MSyA/Yffs9dPvhLFJaYj4Y\n+LHaVbvtJy1AEMgY3/xxuPLAPP4NqAcxcvVcLVyPtGOWdAkdq4wjD+2H42TGLVP7Ce4b7XnrOHyt\nTDYF9kuLlCseOmN1uGLoGhMMWQ2UfooCTCgj/QsDdswVb84Xor5Vo68c6WPQTtaSvcah+XlejSl0\nnlxpzrP7uBVp+uUehBWR5uG7UZ+nkIUBfF4Pv+vZ9RDJYMmSJRgaGpqiJ3ZyJQL+VSimzg5LBjB2\nmMvZQwg3gAhZvKZhdrhWfRXpKIjlqF9VzEPjeipVO75BCz5sTBECZVqNBCvy6IdgQF83+i5BZAj1\nNfk1h8tqlQvhkqraYWr/dMOBpj5Hjsm3djX94oflleCiPvQ+upBWbqMI13YvBOZDd+li3DsV2pPq\nWL5CqHrf0VdQ9I5RbHAdSAeVYBzr5NuH4apHtqK+mibDRsnp00cQ4s83qetYUH+MhV/pzdEAXKTN\ncjjFPweutEgeTkGG6gv14eTJk1P4tE6uRMC/SuX97/+guuGXwDkAdYhbFS5Bxwey/osPeKUy62JH\nrMHBQbS13Yi0w9R3ViZwjUZOw1iWBAZGQ5BqYFleOsFKcMCSRbrkcSjs1I+HXg4TS38b6uvhr4Kz\n9ioWQMgB85hcBfWjsVPYV4xseOJTCswIXuvtI1RrP2QZr/B+pxOqOtXv9sOU0GiFo6786zMKx13z\nXHfAWcV+ZrL/GcMOn0W4bAGvF8tOcJxUFnPhSlQsg/M3kZ+/GelEOq5m6JwPOWW1hd8J46thueYi\njAWvo8IYxZM+1+nEwb9XiYB/FYuhd1wTZfewwz7sXO6TwtHWYDtMxihLvpI7bwFbE6Yjbg7ARdjQ\n4VqCyKdRXwaWvUBZyz6HbLaIwcFBPPvsczZ2nxUNyXWHIl1IVfjAQ0djyIpkRNAB+9BrzpzW94fh\nnM6h7FYmielSCqdRb6WvhlxseuIrql1waf9tqLeMGd3kW6S+D4G+DM4tlSxbTfrnSd9KBS6DlfXq\nqRwXBj4bsPvtgVGoBFX2ST4OF4mlaR5utxQuoikLZ4xwdUZFQz/Sfajv/atXaVyB6tBN+nAY9kll\nwFpHVfs9E9J60Nq6aFxLFzS7RMC/ysWUK9at5MoIW8sEQzrG+CAxLJEg6tdQz8GF7jE8tAJXj76R\nP4FOtA0XgeGzn31GtTb0KQl2SPKpEa4KCAI+SJCG4fllEa7N0g2nBJkBW4bjpRmHnUO9AuC5hKz0\nIgwFwvh51rcnBdEG10JR71dz+LpUQaMoFw2IdGCH8i9YrZMWOldn/ryGlE2C+jo68+0+mZx0EK44\nGJ3HLGGwDa5MNaOD9Pz5yqmMtFOec8LfvYj6Kqes1LnSbs/cBX1/uHmeiL4QzSwR8K9ySZIExWLF\nPhy09DsQjlphGVofQBjZ8zjSYXZVOKuqDc5vwN+fRjhiqB/G4tK8dM6Or98Cy0m4csDk7gk2OiJH\nl12gYvIpFIJFEcaBWEa4TIG/WijCrGJ8IKJlWYZzOB+FsXIrcMryHjhHZMlu44NrCcaJzrlmchKj\ndJgTQH+D9r2Mqveh+HUmCvnn+TrSpZb3I53QdRbOEe3XQfIVAWvv85x1/aNQYhl9AFToR2EUHls9\n+vtOYKirnJoDKhzOi09FLobrJBZS/kbhFIuVCesL0awSAX8GiInTL8NY5XPQuFHIEqR539AqgKVr\n6TBbbR/40xYkdFheYn/jW/jMwOQDSu5ZUxSNHKdVOIqoZM+nxe5jEZy/wh83FQPguFx/n34i1EKw\nymj9/rpgHM4JnPN0NRztlbNARU57P8K9ZlfBdaq6FmE+vWrn+no0boLSKOTRT3Qrw9A9/n50Qpd2\n1NLap4ILhYIe9OZxPtJdwHgvXAcD8KyxQ8dvt52nkBJmZJe+P5hVq+sS7bWfdyHN6+sSEoChllqQ\nz8/H8PDwVD+aky5NCfgi8mER+RMR+TMReSXw/YRNyNUqpo4+KQSGQmqulck2BLcQgDD1nNRC1T5U\nA/ahYjSGD47+sQ54AKQBQy/tlyDM3fdb4KDiIhjQ+tM12mmFs0Rw1Y6VzspFSFNCemysgR8CuYWo\n9w/k4XwXS+DaSnIsjWq4r7bnE1JUs+GiYZjh2wO36tJlK0K/n+N9z218BybnY7W9pm1qTjZD5PNw\nJaZ9BdIO12mNtW12or6oH8tnLEa6iigVpj/+irpmgIs0Y40gHXZKJdyFdARTyI9TQmtr2xUnGE5n\naTrAF5EWEfmuiCwRkZyI/JGIrPC2mcApuXrl/vsf9B5aHZ5XtiBAcA4lEJVgqJYCjIKowNEYb8E1\n3u6Gi1s/qwCLTrsKXB37PJwFNgqXZMXjNopg2dXg816kk6Zo7ZVhwJ2000K4pb+/j1VwQBfyQXR5\n+yX4fBYid8GBMB2pL8JYsDWE6/WXEVYsN6j5YtIZ+WnSPv1wvDUtclJPVF60vBm2yC5WObiWegR5\nv5GH9gtQqerr1w6nqAnMWlnRSe7P8UK4ZDMmcs2x266Dc1AvgMmrYFct+gN2Nrj+55DOYmZ3M/oO\nKuB9mMt1oqtr/ZgJhlebNCPg3ywi/7N6/6pv5UfAv3KZM6dRhuYzcEvvpTBVJX2H6INwy2sCw1IF\nNqSNijDLej/Gu6KAh5awrmlDYNKNqhO7zy4LMvq4/nlwLEcRrtzIY1PZhWiE5XBJVK/AWKx+stJW\nNVf9EPkFOODXq4rjcFFOC9T5aKDthivYFQrrDMXJP2WBjApnhZrblTBAutg7rwE7Fm7HpLMErnoo\nQySZIxCi9brg8jhK9reAo/r0fOdgIrpCOQZsVXgIrhQ2DQJSNix7QH+NHkeIHmMxtfkwiv+Tdowc\n6wa4lWlaQc0U520zAv7jInJcvX9aRI5420zYhFztcuAALbaQZcT3jMgYgLHScjCWfYjTz8PRIrSo\n2mBAl7XM6ZA7C2O9zYOxunQ4Hpfe70M60ofLelqKPI4fxaPphbHS83Xcvs/lcx/Mhi14xyN4n7O/\nJVCF2tsxz4Bgk4MBN4ZvaoXG2H4f5HTSGZCmKUiVMXJIW7+a+w9d02vROL+BYNiI1lsLs4Ly+fKQ\nhZ+Ho4p8paEdvQdQf51C10Vz8dcFtinBVfDUtZR0RNUKuK5iJy/us7NzYEaEZ0bAn4HS1sbaOToF\nXYMu+U6CLWPpfYuKv99lX5+FK6HQAWMJMp7+kHrYi97D2wdX+93PzNUKwac9GvG0Fbjm0wyxPI5w\nlElO7b8LxnonLVCEyPuR5okzqHd6+xUqE9QrLSqFToT7vDK+fg1czXXd6zak4EgNhfwCjGdvdE1Z\n38a3lBl62YnGtB4/z8OVnqggnUfA3AmuyphwxbIMfoE13g+rYVYwoVWon/DGkgu6hIX+nrkN6+3/\na+yc7oSLeOqEidzK4+6778aWLVvwiU98AgsWLEA2m0U+n8f69evxzDPPjHtF2amQZgT8m0XkP6r3\nQUpnz549F/+q1epEzc9VKwcOHMDq1auxadMmDA4OYnBwED095Fz1Mnq7BaNQTHfZPjCkShiRQnCi\ng5GcMmvN+FZdG1xsOKseakflWHx+EYb79UPzWN+H3Dm/Y8z7SrtvFtZaYN8THBbD0E5sq3cSxjKe\nDUc7aZDU42pUhniR3R+VmHY+hsB8MVwY7bUI01ShgmUsRVCDi33X15RZrSNIKyA6V/vt97egvg9A\nDoaK0U3bdQa3tqar6nxYJoE1ijjPZ+EyiN9SxwjNn65PtNv+ltVEfQprBcL3KzO6qbRWwFUIpSIs\nIR0CXIJRFKYjVaFQxIc//GEMDQ01vdO3Wq2msLIZAT+rnLZ567Rd6W0zgVM0s+XUqVO4/fbb4ZKo\nqnBlEw7Y1732QdsLQ82Qw58D17JvJcIU0HH1ehVcrPsmGFCr2X1XYECVjl9YUJiPtCW5GPXx8yz9\nzIeckRs8Lp2EfainbvRY/aSeDrgG2P65cWUSWolocGYBMVIOuxtsr+vHM5EplCDVaOzH1b6W2/He\niXqaqQ/OWc+6M9wP/QsdcMrab9491+5f+zloXVMZjtprHQoH5opDF6BrteOpwFCA5PbpqOWqbKzV\nTzvqS1PQj6GdujqCqNMe+whc6YsEplMXDQOOMQ9mDGcyBezbt7+pgZ/SdIBvxiQfFpE/FZE/F5FX\nA99P2IREMWLaExL0FsHF53/B3vS0lHVzEQIJrT7fIl0DF4PPTFMdusiM3RAoJEhbjrQke1DfD5aN\nsekzOA1n3elGMVAAEAJoTXXpiCMdxkiq53EYi7miAMkH4ZdhnIojdm64qgiFJGqaYzFc0hxpqg47\nnn44JbgOLmLHPzZr01S9zwnobAyjm5YwiYljO9XgvDQ4noa7H/wVHlcP/jzvglGk8+0459vP6E+h\nNc5VQhEmTFQnlfn+DeY0hOaUzWe0U1qvbtrgooRKSPtHqKA1FWj8KZlMEU899emmDvdsSsB/1wFE\nwJ8USZIEg4ODyOVocVfV/0YlELR17H/eA2PpnYaLcSfAExwaUReM6iEI67BGKg5SStpCpYJhwa7Z\n3v4TNK4QWYQrqaCVxMcRdgjqWjL3wiidlWrcmtPPw1UInYf6eHpNeXXDrKZoIR9EOiy02xsLt+Mc\nfRxuRUMahYokpFy5P/pnboSJ0GqUE7EN6dyAeQgrvZAy71bnQkAvI5wXQZqLhdd82oe/5z2g/T/a\nj0ELX9OHfK/ntZHiXgxXMsMPPDAVZnO5FU0Z7hkBP8q7ypkzZ5HLEaB1pi0Qrii5DAagucxfax+g\nJ+CANAdDB/XDWFtjKRCWHSanzSJttPwyaFzCYZd6UFfC8frcPx9W3YwkFAbIca+CK9nrHysH5yzV\nCiDk/yjBrHgI/nkYymIrnFXpAxW305ZsK5yy5NhYL2gU9fHr3PZZhAF8AGZF16m2pcO5inpg5Fh5\n3qRdFiBszVfs90uRPs8uOBqn0UpntT03KmdtlVOp+mW/b4DxRWj+n9U7qTQ+j3q/wg1wIa/+OdBA\nWAaXJawL1rnxFwrddc3Mp1Ii4Ee5JDEdtR5AfevCRhZ+EY7zZ118PphM/hqAA0ftBNXLc4LvEruv\nTXAc6i4LLB1obKWvhgPVmvq8DBfCx99U7b4GEU7zXwDjvA3VffGdlN1wJaKLgf35jkqWab4O6fIM\nzD/ogvM3HLVj1Ptn03YCkgZoH0AXqe/98+iE84FQAdwEx9MzFJXX5Thc6WvWAWImrX9sNtlhIxiB\na8L+DAyV4yttPU9U+tqvk8Ao+2yD82HcPef3CJzSatR8hn6FUMOWItJRVlpZdKK+iY8xBNgjd6ol\nAn6US5bh4WH7kJbgeHNGhHTCATqjHhqBCj+ns7BRgtFSuHICHUjHqNPhSN8BlUAF6SzeR+B8BifV\nQ0hrOWThDgfGTB8AQZTlG9ba90sC+xm1x5rXAIhouZI3psW+CEaZ3enNJYGWZQzW2/cMHdX757z6\n58fVFldoXIUth6s+qlsecq5DGcclpPM3uuGajX8RrtQGr5lf10evrGh9h/rx8r5aArdKqcCtMrhq\nSNT5cH+s/pqHoWDaUV+ALkRTVex5+0EC18D5DrQPgAZDaCVnGp1//OOfmOpHGBHwo1yyJAn5bvbN\nZccpWnZ0XK61D0s/wpTPUoh8CGkQIw9PC9fnsBuF6W21nzEWnlEhdM4V4MI5deQOAb+Rg5hUzzq4\nOPovwoVXFux5jCLcnIOWJVcfpEdY6lifXxcMdTAbjrJiTwDSWWOtJkpINxSnwhlEuHTEoQBQ0apf\nCkdZ9cCAZB6GNvMpGpZnICBz5VCG6znQDeOXyaN+lbOywfg0yPMa6vNlngELq7EEA2vr6zpLr8Pk\nkTSi60IgzRwMKqMqnH9EW/ijgXOaa6+5NjqKYFeyW2+9bUqf4Qj4US5LvvSlQzBWPi3ymn0o2BTE\nD6GrImzhh8ouFOG6FO2Hs4DnBcBmAK4O0HHUx8ITGFh6mUlAfAi3wmUJ98AlaLXDtQzUzkNG6JAO\n2OsdjwqC3DTLQZy1r8twPDd7C5AaYsQPQY7gSMANAe2oer8Oab+EVly6kBzr5ZD/ZnSS9hPQJ8IM\n6S47J40UTxtcRAwjiV6HUWD6uodKFYfKN6+DKWnRDhfnH6JJWlFfklo7fDtg7hvfCtf3H+fbrwia\nt9fzLBzluMzbln4L/5zKMM8EDYGFMLSRO3a53DFlETwR8KNcttx1191woKVvehaqYoINaR9Gg6yy\n//mA+gDeD0O7VOGiT3YjTCeQEmGoZxUutt0vL8yoDjY850PbAqeUWE+GoMxuXAuQVk7cp+FmW1s7\n0N5+I3K5Ttx88y0KIHSfXd0YpAXOudmGdFkKH6y1tTmWhU8rtwxXtK5NjX0+XN14TeF0QuQBOx7d\nDP6cnYujdhs6aR9CGvw4LjpPmazEhLIl3jUmNcXr06hefTccR9+H+lUAjQM2qXkLjX1JR1G/wuQc\nMYkuA9fwvBVG4WtFUYPIw/Y7niM7ts2141sLV9yOc9Jlr0EeZlWVwNV7EuzZs3fSn90I+FEuWwy1\nQ2tuDow1ym5RjMXPwigF0j6kQXYj3GWJD/EauCU7Y7pDBcz2o96Kp1XHEESOoxVMklm2bLl9bbKK\n585luCczcwWtrbOQybTi9ttvx65du7BhA1P4nf8gmy3i2LHjSJIkFXNteg9wdUALktTAfTAKkRYx\nE44o4ToAACAASURBVL9Cyo8WPKN/uL8uOOAMhRsOwoA9nasVpCuaAmkKhw7yFXabefbYW9VxdfTK\nQvv5QbiQRtJXjXw1jM/Pw4AtKTegvsNaiK7ahPoGLf0w/hmG2I6ifiWwFI5eGmtcXJXm4KKkGLKp\n98cSIOuQVnyGozfXhaGcBbhIHvpBdL6DuR/vvPOeSX12I+BHuSIZGFgP58wrI7zc/6R9PwjX1IQP\nTygS54D3+xrSFjAf0CJc9ugB1Md3V+Fq/reiUqnglVdeuQjKtVoNJ0+evBguNzIygtdeew0jIyN1\nAE6p1Wo4cuQITpw4geHh4TGX5MxfOHLkCEZGRrBv33641QcVUdWCVKhchLbwfXDSPYFZDpkAdMBu\n50cr6RVAv7etrwgKMJEsQw3GxZBaXncCYyNfTdY7ru+U7YYrud0GVzW0H8ZQoNIpoj5OXq/8SC36\n9yAtdyqVLnsNaEAw6zoLV6VVl/rwxxqicajwSvZ6+sX7qoHfcPyZSW2iHgE/yhWJi9jJwVg9ocJq\nn0eaK/adlbRIr7EPkv79ajgLn23zmNV6DVx54TJMDfr6SIulS/ubJgY6SRKcOHECN910E+ot+h44\nC5acOaNmfGdsP9wKgcDLip2dMBa4n7hGf0cRIifgQhF1iWlN9RAoQwlw77PHXwMTSURuv4pwuYmQ\ndc0x6ySwARj6hTz8LBjwZ98FrsRoILTC+Ht0VI7fCJ4JbZ0wCuxJOGWpm8kwE7gd6WSsJ5G25Dfb\nefZj/bkiW27/7/Ku8TDCnc62QKSAvr6+SbsPI+BHuSJJkgSZDJeuH0TYumq0nO61DyGpiFB54TJc\nDRc/UqIEEw1EEKtvcF4odDdlanuSJGht9R2s5OlpwVbtubNUg7+ttv5pEZPr3oXGIaV5OMd1q31P\n/8elONbLMAqaTtyK3V+73VcP0or5AYST8nIwQKxDOjuQVjgfQFph6LLbnCO98jvY4D45AheDr8fW\nGThnVngtqznR++uBqaw5loVfheu1oLn80HNAB79MmmESAT/KFcv27Tvg6uXTEcoHioW3QtmWD8M5\nukowNWYYQ78OrohVGcahNhvpipf9cCF55OxbUCh0o7NzoClT2rUcO+a3FzygAIkrIRZU86tV6lo3\n18NFutA/AtR3qcrA9XZlklQFaf45FK+vC8IVYUD6eoQVNBWEBshuhBuocOVSsNeWn/n7o5+Aq0Re\nc0ZwLbZj0XOmLXJ2zgqVkCihvocxk+tYoqF+1Wr8M1nvOPTR6JpOLBtCoPezgtP05f333z8p914E\n/ChXLIcPH0Y6nv06+wButP9DtUiYZMWKm+wK1Q/XmHqNfVAYRUMlsh3Oyh2Gs6oKyOXam7polS/H\njh1HodCJUmklCoVuHDt2HCMjI3jxxRfx+uuvY8eOHdi6dSuGhoZQLPrlDHyLUoMYOWY2q98IF49P\nCoOx7Z0WUBlx5VutK+AaxGt/ywfhon4cGJrPfKXB6CdSOO2op1JyqKdJSFOFyi2U4ZLEFiIdp38S\nBpBJNx2FsfJD+8+hfkWwys4VC/q54+ZynRgZGUFLC52wZbsd/Sk6e5ehwDrslFE6Pk23DLNmzZqU\n+y4CfpQrlmXLroPLvPWtJ1pbukYN49J77Wta+aQ09IO9c4z9usYbudxcFIvdTW3RN5JGDmIto6Oj\n6OryaZHldh7meZ8z1p7NR1hnn05dTYH4IMrr5Ye0+oXjtGLREUJ6/3q7PrXvo3BRWP52Ps3F0NIW\nNM7BaIdR/KEyGATkRh3JSurepUFxm/d9Bboz1549e3Hy5Em89NLLqPdbbIez+rk6CAUzkF6rv68n\n4x6OgB/limRkZASuDn6oLyw7KgGOkyZfXFKvaV1p+iexD7O/32UQyaClpYh9+/ZPK4v+SiVJEpRK\nGiDPIZst4bHHPo76yJVuOOfjZy24JnaOh5EOYQwVmstbcGTd97zd/4C3rV8HiJnEmrbogWnenoWJ\ntCItE7pfGBLLVYRWJIxu8lcfCVxxvJCzOEQRaRoma+85fxtSh6vt+Y9AZCEWLVoC10uggGz2+sA8\n1mCczKwUewAuYkeHnc6xx55lt70VItVJ8TtFwI9y2XLmzFlkMuQ5VwUeOB2XzWX/AEx0B7lNv+rj\nRhigohII7dc4KZsl8may5MyZsyiVetDaytXS8otz4cCZVvQOC3bXKiA2imJsC78EV6DuNIyCWIVw\nETS/DtBSBXoJDM0y3/5uIxzlknjv9bGrduyaKmKoJSkgXxlUkK5rRCco2yn6RkgOpttXJ1wBt0NI\nK70jcIqsBJPpXIJRWmUYBcO55D3uz+O1cAELvXCKlOfiN2fPQaQbLS0LJryvbgT8KJclJsqEiSMs\nRXDAPnh+qJ22BCsWgEjVFOy2W2E6CmknI51fmnM2zsdjx45P9RRMiZgVVYiW4PyXYJK6yHmvhysj\nwfpEpGe0tcnXO+Eyi2sWCHWHrhLCdYDorPXHdYMFNvL3dOTrY1KBsQQCi61xX6/DOU4TuKSoAXWf\nLbe/22nvSdau8RWa9nu8iHTQgO7CNgf1VNVtcApAh4Vy7PqcGD5ahfGdvAJX2G8x6lcefC5+ASIF\n3Hrr7RN6H0XAj3JJUqvVsGXLFhjeM4N0LRLWpMkjXVKAHC752N1wWbSMEmnU6IIO2yVgKnqzlJid\nCjl58iTqHY+LLcgxkolJTj5nXEK6mNl8BYxPwNX6YY8BP9qFpYxzSCcx0ULNq9/yWoaSunyFpVs0\nnoZRKDrc03cmVxGmsWow1IveTygzGwg5Yx0tlYMLe9VWPxVfB0SetmPstb9hslijxiv0FWTRuP/A\nQjgFkp3QRKwI+FHeVbZtY9mEdnUj+1ZQAWkgaIdrB9cG56xjt6BGvCwfMmaRtkIkN2Mte0qt5meS\n+i0WGVc/G+mKob0Q+Qxcj+EqXKnp6yxYMsrqRrguYTqU0A8/zCnQJbixphF72fr8NhOTGoEdY9X1\napGVWbUz2S80R99B2e4/QbqZDksnMHY/5EPohwFkUkMEbt7bm+y5Vex2C+0Y2SCexo/eJ8t9bEQu\n14aWljaEKSAaPkWY0hsl3HzzzRN2H0XAjzKmOKCpT25yIM3IhEZWkx8NUg48dGuQdgSaNnlPPfX0\nVe2UvRz53Oc222vQKK5ctwgk/VJUr5fAcPI6sego0quC0/Z6auDU17tqt08abEPApIVfReMSEiwd\nvRFOWZVgFBHDd0+jvv7OKjijgc5evX8/5p2A3AZHO+pxdMKEoA7DrFSZV0IqZj5ciLFWsCzKFwo/\nZm+AEgxNRp8CE7FoGLUhbTiZ/sUTdc9HwI8yphw5csTenK8hbKGdhutipL+7wT4o89VnLDe7tAFQ\nsDuVURaf+tTTU336TSe/+IubYKxM/1osh6ErrrUgQivZX4kd9MCnHWnrNEG6Ro5/vUft9qcRrgfP\nZDBGavkgWYGrpskVA7dhGCZDTtnfIKR4VsPQS/PVGKgQGeq7Da4kNH0TDDnVvqHdcKsen5PPonGL\nSpa2YAgsncX0hXTbc3wE9fRWK8wqwM9lMPscHh6ekPsnAn6UMWVwcBCNLXwmwBwPPJQdcBZQFS7a\no9rgoSNnbCymmczXN5Jjx45bh/lYuQ+dcJVGNUAy6cevb+Nb3lUFZL4/QDs+CcqNgDCP+uieMgzX\nzpBc/ZtnkS4pcRRhi533Tjdc9ItuSLIC6dWApo24L84RM325WuC96Y85D7OqoEJkFBmVBGkdJht2\nwdFj9G8cgkgZLS1UfpkGc/c4RPqxffuOCbmHIuBHGVOSJLHp5HT8aWdeC8KOqpBltxjOkmSSCpNy\nsuoBzODVV3dN9Wk3nZjGM0wm6lWAsUzNMcMwSbloy/w0nGP2VqS5eTp7SRXdYPf1AFzrSgJfEa6Y\nHZ2sur1lwYJuo7Iar6C+ATybk3fAtbU8C2O9M4SRzlGGoXIu1qjjhipZVpBu4qLLRLwGE0mzCa47\n20rUKwwqHxopzBBeBEOTdcDVy9chqKz1tACMwnHfD8MoTCqHHhjFxOtUnBCjJwJ+lHeVM2fOorW1\nDc5aMZE6s2cz4oHxz3k0Xv6esg/GOQsQ55BOad9hX1dQLDZn4bOpkj179sKl6r8O12T9FFxfW1YP\n7UHYn8IsZ16Pk3ANx2ml+iGDPUg3QNEWvL+aYw8C3iOhxi7064Qyd4sK+A7AhSuyumUJrgVkKNKG\nRc+4LQ0IcuTMfGX11azajsbMi3DOa70KTeCaxIfGrRUilVSXujZUzpomI1VVVc8BY/d3gc/FeAcr\nRMCPckmSJAmGh4frasGzTvzLL78MowhCjbPp1GVEAmvZM16fURIJRNahre26CU9AmS7yuc89B9eV\niQ5NAg0jUbRztAoXdUML/ho4J+uoBWauBkoQeQYGxP1kpdWoDwVlHR4/dPE0DLWnAfMBuLLP3XAK\nxXeq+gqKobvaGUqLmY1GQqsHln0mcFMBHrD3pY4+6rLfFQPH0oDOGP1CYH543ty+oo7jK8lFqPdH\n6FWx9nEUYFYjc5HNFsfV+ImAH2XcZPfu3Qps/AfnHBpHfTDc80WIdEUL34qJkDJNMhpz5dfBdVNi\nw/UcjKWpFYVPR/DvMZha8Y0ALxSZ5fsISjA9fkONV/xVCcGSGbmvIFy6gYXP6LglzbIMhkoM5Ru0\nWmANNUZvhVmJJkgnhFVgQP0JhJUIE6mYQ+If06fOZqG+SxidsSFlJ3Ad2TQNSj9KblwduBHwo4yr\n5PMl1JePnY9w/Zbl9uFj4lYGra1t07IQ2kSIiZBiT4DQqukaBQyMg38WrmgYaYZGCiMPV9Ruobpu\njHl/EY37BNPiZRVO7kuPcYm6DzgWHzAZOeOPrc0CMVeGOnN4BKZEAq1jhvnq91w9EriZMLYJYUqJ\nTWX8z9epudfNVkhx+qGYftYxqamSnWeWnc4ik2mFoadaGhx7FkS6IuBHwG9u2b17NxYsWIA1a9ag\nVKKjtxp4sJklaeqcPP74J6Jlr2T79i9YMJgdAIQCGodeav9IBc7R6yuM1+Eic0owIZt9qO85S/9B\nL4zlTScvqRs64TWQcp8+z04KhaGMvtXbCUejdAX2QZolsYC7BOGqlBU4SoWO5SpcnwE9F1SWXAXp\nyLGDqA+ppPJiAxldbiG0SrgJxmdShOHnTQG2e+99wB6jgrBCN6UiIqUTAX9ayerVtL50jHMapNra\nOqd6mE0lSZKgWKxA5F6kKRlaiO0ewOkkONa5J/2yEPXlh0twlSGZBZsgXGVyIVjeor5fK7epesBd\nQH2DkVVwqwhdloPhuH5Zg4UBAF1tx3AOjoZ6IgCYbJJThrHuyzDlFUKRPN1wDdATu50eIx3CA3A1\n/emATeCaypDO0T4Hhmzm4KKgWiEyS3U+a1QnSaLTFhHwp6WMjIygr28p0rV4SPlkpnp4TSejo6Mo\nlVYhnRhFLns+0g3hCYSnFfhq4KBlqWvLaDqiqgCHTWgIdrToyS2HErKW2XFxjLyujaJa9HELMDTU\nc6jvmFVEWFGxoFsXXIRQyNdwFOmyCu1woZEa0DU/Tyd4aNysIspm56GyzFwNkVYjZclINpaGyKFc\n1uGpDyJNg44/2AMR8KNMstRqNdx6663IZDLIZrN48sknp3pITSlJkiCXa0c4BDFUi4iUykILmDX7\nv9cCNhOBNsJYmG1w9EoJJnaesfwsL7BT7Z8WewjoQkqmFUYxUcn0wGSdUnmRD5+vwJe9cRmJ9Djq\ny2gfCABxFSKPeoC5EI7L57GotO5WAH7cAvxc9bsQLcMm8SvU3O9XY+OK9SE1HzrccliNeTEymTko\nFHznch7ZbBZ33HFHLK2QGkAE/CgzQF54YRtcyd8KXANyxqL7YOrHlt8AF/ExBJH3W6DTkSBsBKIj\nRBgTT74cSNfv0dQNK15W1PFY894HPj+jlf8bce/0UeyHiebpRTpiZymMs5XAPGLPp+gd3z+GX7WS\nq5IcGsf4F2EoqU6YImfMNaD1PgwXljrPHpO02lyYKCWA/qrW1jYcO3YcpVIPOjrWXWxzOdESAT9K\nlCaV1157DcayJL+uQxOZsamtyEYAx4SjHtQnYDUKo60p0K1aMJwHRzGRsjkO1/ybCWBr7Ws6JenU\nvAaGjumEseJDkVsDcPTQKrhoIEYr+RE7LJkApKmpBKaWTgH1uQQEbv+c/SbwbIKufRb8jhFmjICi\nsjvYYD4H1evMxSzaS2lzOZ4SAT9KlCYV0/SkUXy8H7edhSsP4IPoagtODKNsh1MclQAgLoeJKoHd\nhrQKOXOdVFSBy9QNWcas3zMHrjHJOaTrKjWy8HXEUajaZgkmion+IJZ10OeyAuEMYjaKWWfHP8f7\nXS9c/gATrhrRWUfhuH3dSpJ//XDUVQYPP/zIlN1TEfCjRGliuf/+B1FfN2cz6rNrGbkTAlGfYy/D\n1Yd5Nwu/ZI+/DCJPor6yJiN4GmWitsLx3DxWGeluV9qByno5JTjaaj2M8vD3v8xun7H/7wicSwWO\np+cxtsFF2NDfEYo8Ktgx8LtRhGvpXweXSVxFONJJIFJAodA5paHHEfCjRGlyOXHihAWN2XDO2FAT\n8k67HcGUHHtfAKRzENlgt6V1ToXCJCqCHv9Ydpk8Pjl2Vo0MZb/6ZRM6YSKG2iDyPFzBsc9bcGcx\nND8ZqRoA8xJcr9gcisVuZDLskqXPZTlcMTg6pv2x6oJ/BPoSRD4Ep6hWBcagVyQcC+sI6RLLOYhk\nUC6XcfPNN09oV6uxJAJ+lChNLiYmvxsuRLFR6OB+GA6Z5Yl9cNPO1g4Yy7eMdP9VhkIW4IrhFexn\n7B/LUhj+8cmxa+eyTvhiZ6obLTjS8dmH8KrETxZjATNdhVX39OW5soibH+ZJRdICV22ToJyDyAtw\n9BAziDvhatePwpUCZ/awn9HbApcnoFdf9Q1U7r//wUm/l5oK8EVkj4j8PyLyf9q/DzfYbuJmJEqU\nJpQzZ86ipYWANmCBjtY767C3WzDVcfZ0Xoas2m64Pq6r4WghllNgKeEc0pRQEWaVkMDRIr0wFrQG\nTLYMDCmp0/Y3nRb4/ZLJa1C/OqD1XLBj3A7HyffaedD7D4VXsp7OYTtHr6n9+WUc2LvW7z9QhWvB\nGfKtcG543FDlULN6mmxLvxkBf+clbDdB0xElSvOKceIyfjxRgNqoEbwGnfkNALADhiZ6Aa72PPfl\nNx5hTLuOm2c9d5ZXzsNQNondlvz+PNTz/2W4Ojw+IPbAWfSkefT5kUpJkG407u/fp5h0ItcBuFVG\nb4Ptma/AvruMw58L13yFpRioKP1yFyxyp+fedCh77bXXJvUeakbAf/EStpug6YgSpbll2zbWrQmV\nCPAbwR9V34Xq3bMjUzkAdj2orzrZYwHzKAwFxL6tW+GUBVcXh6xCIMXTifpiY6SHtBN3FdJF2hbB\nRAyx9AH/1sJQWB1wReTyqC8TTWcv+XydyNWJXG6ubTDOfre+QtwFo0jWwGXRVtU5cL8bA3PIUNnG\nHcqihS/yPRH5IxH5qoh0Ndhu4mYkSpQml1qthsceewz1FvtapBvBa+frXLjM0AG4LlDsJesD6mrU\n18JhRI3ub8DM3CIcxVJBuruTBjk2DKnAlFQIUSWkQK6xgF5FmOP3eXE/VHUj3KqDDV+osIYhUkWp\n1INXX/0iGoeVchXFVUwoUugahMMxV8NVK9XW/wzi8EXkfxGR76i//2z/f0xEZosprCIi8q9E5GsN\n9jHR8xIlSlPLsWPM6vRBkI3gixB5Ayayp0UBZ7cFPFrvCdL9Y/W+xoqSOYl6zjsPQw+thgvTDDW6\nocM2FDe/1G7DUgkH7D6oBBgpw3LHHE8oTp/c/jUwinAZstkS8vkudHYOIJ/vQi7Xjq6u9SgWu21p\nbx1d41cp9edARwpVEeL0i0VT7jufb7fbCfr7+6dVlA4BeUIlk8ksEZEhAGsD32HPnj0X3991111y\n1113TfiYokRpBjl//rzMndsrwB4ROSAiC0XkuyLyMxGZKyJ/LSJdIvL3IrJARH4kIv8iIi0iUhaR\n/yoiS0Rkn4i8ICK9IvJ/2e8XisgP7fYXRCRn9/FDdRwRkS+LyKsi8p9EZK0Ym+0WEblXjE332yJy\nl/18g4h8TUQ+KSKtdt89IgIR+X9F5A/VPm623z8kIn8gIv8sIm0ikojItSLyExHpFJG/EZFFIvJn\nIjIoIs/Zc/8zNVNrROTPRaQgIv9BCoXH5Nvf/gMREfnd3/1d+aVf+mX553/+fXvs/0FEfsGe41dE\n5G/tsb7s7XORnd9rxcSX/FREZtm57hKRvxOR+SLyI8nlID/96f938Zq988470tvbK7Nnz5bJkm9+\n85vyzW9+8+L7vXv3CoDMZe3kcjXEpf6JyDz1+r8TkTMNtpsQ7RclynSQvXv3wtE5x2GomQVwJYY7\nUF8+WUe45OBCKPU2XTDc/EE4/pshjlmkyxEcRNgJzJjz46gvBUHLmRm77MylawLNt5b1tfZ8XlQW\ntD6Xj8IllDWqy8MwzLnI57tw5sxZnDlzFqVSD9raGM101u6LPPulWPQLIJLDAw98GLfc8iG4CB+z\nmrrmmlk4cODAVN8mQZEm4/D/nRg1/0diVO7cBttN3IxEidLk8sADrFFTtWDYAcPBk1bZjfr2e0zt\nvx6OS9dRLYChYjrh6sL4sfusC69r6fhguBSON9dj8gH7HFxyUxXpWPkyXLcrcvKaGmKGLZ2ooY5U\n5PhbceLECSRJgiRJUCpppVCFK7ZG3r8Frj6+icHP57vQ1rYW+XwX7r33PuzatQu1Wu3i9RgZGcHW\nrVvrPm9GaSrAv+QBRMCPMoPl+eefh4s4oUORkS0MJZwPE2M+CmcNs+wwI0pC5QQIvmsQrh1D0J8H\n5+hcifqwSb8ksFM++fxKOI6flrVzZrqa/CFO/pz9LbN1fWdr1X7P6p6zkc22Y9++/RgeHkZ7+zql\nHBhZ1I10QTm2lDQcf61Wm9QCZxMpEfCjRJlmcvvtt1tA0zH52kmpo3NC5X41vVOCSRRqsyAOBfSh\nZif9SDcwZ6TM0sB2w8HflEo9GBoasvX+z1nQJ/DznBahPnZdU0NsZqIdu6F4/RJMXf+S3b4Iowh1\nkhbpLNJPXRDpRqHQddX1V46AHyXKNJNHH30UrigZa66fhQnLZBkE9oXthqFoNHAut0DNTk+r4aJN\ndFJSKDu3DNcakftiTL6/EtBVLxkOWsa+ffsB4CKf3tk5AJE8Mhldm79Rk5eqet+uzi2BiRzSiieB\n8QW0Il3KuFGTE1dQ7tZbb78qLHpfIuBHiTLN5NSpU0i3CiSwE6CrFriOw5T/1c7WqlIKIScnuf1O\nmOSpHUiHKs5FfdP0KtJcP63pXrgs1TcgchrFYncKSJMkwfDwsC0Qx3NKYHwNjKtfa89viQfSpJJC\nTlZ/PDrEMlSLiHkLLVi+fMUUXt2JlQj4UaJMM9myZUsDC7UThuoZtiDZgXRNGzpu6aCc5e1juQey\nPfa3VBDaui5bgN6IdHP1LAyFkveOZfb7uc9tTvHhtPJLpdWoL0bWBmOV62QsP1O32253AwwVwxWC\nvzLphFnJcN8s5LYWzrEsOHXq1BRf3YmVCPhRokwzWbFiRQD8mGzVB9fkpBeuREKo0TejZfieHbH0\nNgUYCiTE5VfgyjywAFkfXEkB/1gCkSI6OtagVOq52OKv/jwS7zdsfO+3eqRy6rPHH4BrbxjKevVp\npyKMEjSKas+evVN9aSdcIuBHiTLNxAA+o2UYv04On6UV2IeV1msW6T6utOgZkdIDU3rBB/ZetR+f\nQkrgKKIhuPo1BdQ3CmFEzrKLYywUOtHRMRBQJMaa37ZtO5IkweHDh7F06VL7HatzDiHtsGUP3gxc\nXXo/wocrHV3zJwuRLO68856pvqyTIhHwo0SZZrJ582a4iBM/SkcXT9sGF2bYyMLn91U0rrPPmvg6\nBl9TL7olYgVuZeHvJ6MUBdDevhqFQtrqLhYrOHLkSF08e5Ik3rZb0LiOfgH14Z5z7fhzdhyCYrGI\n9evXT1mZg6mQCPhRokwzqdVqFrT8YmE6HJHg32/Bbg5cFykd887fMtyR3DutYNa9GYTIZ2Ccn77D\nuATXEpHNUWh5s3Sw2H27MWpap7NzAKVSz5hhkGfOnEVrawdMJE6jlcRSiDyEYrEbhw8fxtatW7Ft\n2zb09/ejVCph8eLFVz1PP5ZEwI8SZRqKKZNMEH0dJqKGUSl+IhErVNJRm7NgX0U6wzUDF7evVw5l\nC/g1uMQt3yHrOkdlMixsZnICuroqGB4ebgjuSZJccmJTkiS2tERWWfF+wbLuqy5+frzkSgB/Uoqn\njSWZTAZTPYYoUaZa3n77bVmzZkAuXGgRVyTtp2IKni207y+IyLfEFSfbICL/XkQ+Iqao2FIReUdE\n8mIKlJXEFP/6c3WkZSLyhojME5EPikhGTGHbH4sp2DZbstl/lKef/gXZvPlZyefz0t7eLv/wD/9Q\nVyxsvIqIPfDAR+R3fud37Lu8HfOPZd++X5YtWzZPaoGy6SSZTEZwmcXTIuA3obz99tty7tw5ERF5\n7LHHZOXKlVM8oiiTJQcPHpS9e/fKP/3TP4kB+2vEVKGEiPSLSE1tvV5MNchPicjrIjIgIv+9iOy3\n3/9rEfllqa9gOUeMQugUUxHyZ8Jqmvv2/cqUgOybb74pv/qrvyo//vGP5SMf+Yhs3bo1Av27SAT8\naSznz5+XarUqv/Ir++Ttt98WY+kYS2/bts3y5S//+hSPMMpky9GjR+UrX/mK/OQnifzlX/6NiGQl\nXcKYFv5HReRpEflNMSV/f2C3/YqI/KOIvCTGiueqAWLKJ1+QJUuWyP333yf33nuvbNiwIYLsNJII\n+NNE9FL4r/7qr+TIkX8rJ078O7lwoSymdndGRP7/9u49OMrqjOP49wk01kvrBYM4WAwqatoZp3Wm\n3mJtOkMpzDhVW8faMhWsMsFLtVWsoFXjpU5VZEbjUKk46qhIsTNe8K6VqKFFGdCiJSpeooIQEUsr\nHwAAC/5JREFU1qrTQRdy4fSP5427gUAIm+y7yfl9ZjK7eTe7e/Ly8svZ5z3nvJcDp+K9r2NYuXKZ\nevoRa2pq4tZb67nrrgfYtGkYHt574gG+EQ/xLXvy7fgfgI/xks9GRo4cTl3dlWSzWcaOHatjagBT\n4A8ADzzwN84661zMhvPll2/iPa1y4BJgJv4RPv+iDFOAx7n77iuYNGlSWs2WEpHJZJgz5w6uueZ6\n2tragaeABcBzdL24xxggw+TJp9De3k42m2Xy5MmceOKJaTRb+oECv8RlMhkOPPBwstkf4ZcIKMeD\nfQ3eq78POBN4ga49tQ4aG5+nuro6nYZLyclkMpx33m958MFH8as0fcLWPfzA+vUfqkwzSO1M4Jf1\nV2Nka83NzbS370ou7JfgvbJ/4R+/J+En1DqvBHkEPkKjlfLy8uI3WEpWRUUFCxbM57777sBr9pvw\nkB+T3LYybdoFCnvpQoFfJJlMhsbGRtraMni99QBywb4/fpLtEbyntiLZvgJYw5Ahu1JZWVnkFstA\nMHHiRMaNm4BfOzYLvA9kqaqq4qabbki3cVJyhqbdgBjMmXMHU6eejwf9XviJttV4oB+BXyh6f/xC\n0bPx0Rf74KWeLPfeO189Ndmmp59+gsWLF3PbbbexYcMGamtrVauXbqmG389mzpzFJZdcjI+p3gcf\n9zwMyOC9+pH4R/IA3AL8HPgPMB5oZ+HCh/WfV0S2opO2JcZ79ufg9frOYO+cObkOH3K5idyY+7X4\nBJghwDc4+uiDWLLkn2k0XURKnAK/hGQyGYYPH4WPvlmCl2wOwgN/NF5r/QIP9/zRFTVAFrMyWlqa\nVcoRkW5plE4JueyyP+I9+JF4mL+Kn1hrAJYlt4b37PNH5VQCwxg2bDeFvYj0KQV+P5g48Qzmzr0X\nn86+Bg/3t9g63PfHZ0Hmj8ppBv5LW1tbEVssIjHQKJ0+NnPmLObN+ztepnkV+D2+mqGvAJgbmbMC\nn1EbgB+QW7GwHdgTDbsXkb6mHn4fymQyTJ9+JV6rPwL4AF/nZAnwLlCHT4o5GDgWmI6vbNiKl3vK\ngEuBDUydOrXYzReRQU4nbfvQ0qVLOeqon+JDL58ATsLLOE15P1WJj9YpBw5L7tcAj+NrlK+nrKyD\njo5NxWu4iAw4Ommbos6ZtL7a5Vl4GWcPfN3x/Br9Z3jYvwy8BiwCnsTX0FkHZFm3bnVxGy8iUVAN\nvxe6u8JPU1MTt9xSz9y599DR0YYPu1yUPGMzPs7+BGA/fCjmcXitfsv1co4BnmX8+DEanSMi/UKB\nv4M6lzVubS2jo+MTxowZw4gRB/DSSy/ipZjN+JrjC/Ga/HvADOAxYBxeuqkEXsGHa+afvF2T3H7M\nmWdeX9xfTESioRr+Dsgta/wFXgUbga+FUwaMSu6PBj7FJ1N1kLsu6RTgr2y9dO1mvIa/Gj9RWwdk\nWb9+vXr4ItIj1fD7SXNzM62tZfjuqsNPyh4IfB2YjJ+gfR+vzw/FlzteldzOoevKmJ0lnL2BucCb\nwB+Akey+++4KexHpNwr8HVBZWUlHxyd4z/4GvEZ/Hb777sIXPPtm8jWaruFeQW5lTMiVcD7DS0AV\nX22rra0txq8jIpFSSWcHnXDCD3nppZfxMsxzwOF48G9ZptkNn1mbv72V3NWtVuOTrSqA/+FXK/qY\nIUM6aG/XUEwR2TEq6fSjF198AR9xswpfv76Srj35UcDFeLgfCxyCz6A9Eb+Q9DL8wuTLgEPx4ZpZ\ndtllDRdddI7CXkT6nQK/F/yTSBYfZ/8mXcs0H+EXL7kQv8jJL/Dd+w7Qgo/emYSP0FkFbGLatN+x\ncWOWm2++uZi/hohESiWdXrrggguor6/Hx9t/DV8jZx1wBj788kz8j0J3pZ0Ryc9u5Ljjjmfx4heL\n3n4RGRyKXtIxs1PN7A0z6zCzI7d4bIaZrTKzJjMbV8j7lJIrrrgiudeGl2/W47X7fwC/IrcY2jC6\nlnwOwtfWyTJt2iUKexEpukJLOq8DpwAv5G80syrgNKAKmADMNrNe/SUqVRUVFVx77Z/ytrTjY+zf\nSm5b8WvSfkrXks97wGbOPnuKLi4tIqnok5KOmS0CLg4hLE++nw6EEMINyfdPAnUhhJe7ee6AKulA\n59Ws9sd78wcDb+c9OgYfibMXPl5/ND4M80ugTROrRKRPlNIonc4LuHZak2wbFCoqKrj99r/gpZzu\nxtjfiAf83sAn+OieNubNm6+wF5HU9LiWjpk9i6/89dUmvGt7eQhhYV80oq6u7qv7NTU11NTU9MXL\n9qva2imsXbuWq6++Cj8hOxIP+6H4bNzLgevxpRbaaWxspLq6Oq3misgA19DQQENDQ0GvUaySzlPA\nVYOlpJNv4sRfM2/efeQ+LHWO3GnB19Tp4Pzzz6O+/pa0migig1DaJZ38N34UON3Mys1sND4L6ZU+\nfK+Scf/993LTTTfj5R3w9XWagU1UV3+flStfV9iLSEkoqIdvZicD9fj6AJ8Dr4UQJiSPzcBnKLUB\nF4YQntnGawzoHn6nTCbDokWLaGlpYezYsVRVVaXdJBEZxHamh6+JVyIiA1DaJR0RESlhCnwRkUgo\n8EVEIqHAFxGJhAJfRCQSCnwRkUgo8EVEIqHAFxGJhAJfRCQSCnwRkUgo8EVEIqHAFxGJhAJfRCQS\nCnwRkUgo8EVEIqHAFxGJhAJfRCQSCnwRkUgo8EVEIqHAFxGJhAJfRCQSCnwRkUgo8EVEIqHAFxGJ\nhAJfRCQSCnwRkUgo8EVEIqHAFxGJhAJfRCQSCnwRkUgo8EVEIqHAFxGJhAJfRCQSCnwRkUgo8EVE\nIlFQ4JvZqWb2hpl1mNmRedsPNLMvzWx58jW78KaKiEghCu3hvw6cArzQzWPvhBCOTL7OLfB9otDQ\n0JB2E0qG9kWO9kWO9kVhCgr8EMJbIYRVgHXzcHfbZDt0MOdoX+RoX+RoXxSmP2v4lWa2zMwWmdnx\n/fg+IiKyA4b29ANm9iywX/4mIACXhxAWbuNpHwOjQgifJbX9h83s2yGEDQW3WEREdoqFEAp/EbNF\nwMUhhOW9fdzMCm+AiEiEQgi9Kp332MPvha/e2Mz2BT4NIWw2s4OAQ4D3untSbxssIiI7p9BhmSeb\n2UfAMcBjZvZk8tAJwAozWw4sAGpDCJ8X1lQRESlEn5R0RESk9KU201aTtnK2tS+Sx2aY2SozazKz\ncWm1MQ1mdpWZrc47Fsan3aZiM7PxZvammb1tZpem3Z40mVmzmf3bzF41s1fSbk8xmdmdZtZiZivy\ntu1tZs+Y2Vtm9rSZ7dnT66S5tIImbeV0uy/MrAo4DagCJgCzzSy2cx6z8o6Fp9JuTDGZWRlwG/AT\n4DvAL83s8HRblarNQE0I4XshhKPSbkyR3YUfB/mmA8+FEA4Dngdm9PQiqQW+Jm3lbGdfnATMDyG0\nhxCagVVAbAd6VMfCFo4CVoUQPgghtAHz8WMiVkak63+FEBqBz7bYfBJwT3L/HuDknl6nVHeeJm25\nkcBHed+vSbbF5Dwze83M5u7IR9ZBZst//9XE9++fLwBPm9lSM5uSdmNKwPAQQgtACGEdMLynJ/Tl\nsMytaNJWzk7ui0Fve/sFmA1cE0IIZnYdMAs4q/itlBJRHUJYa2YVwLNm1pT0fMX1OAKnXwM/hPDj\nnXhOG8lHlxDCcjN7FzgU6HZS10CxM/sC79F/K+/7A5Jtg0Yv9ssdQGx/GNcAo/K+H3T//r0RQlib\n3GbM7CG85BVz4LeY2X4hhBYzGwGs7+kJpVLS6TJpKzlZRU+Ttgap/Jr1o8DpZlZuZqPxfRHN6ITk\nIO70M+CNtNqSkqXAIcnItXLgdPyYiI6Z7WZmeyT3dwfGEd/xYGydD5OT+5OAR3p6gX7t4W+PmZ0M\n1AP74pO2XgshTMAnbV1jZq34WflBP2lrW/sihLDSzBYAK4E24NwQ18SJG83su/hx0AzUptuc4goh\ndJjZ+cAzeOfszhBCU8rNSst+wEPJUixDgftDCM+k3KaiMbN5QA0wzMw+BK4C/gw8aGa/AT7AR/Rt\n/3Xiyg8RkXiVSklHRET6mQJfRCQSCnwRkUgo8EVEIqHAFxGJhAJfRCQSCnwRkUgo8EVEIvF/FrqF\nuRj9CjIAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f3c43bde910>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "import matplotlib.pyplot\n",
    "\n",
    "print matplotlib.pyplot.scatter(x,y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "everything.to_csv(\"merged.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scratch\n",
    "\n",
    "What follows below is some code used for debugging and finding problems. Not to be run."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "362 matches between the sets\n"
     ]
    }
   ],
   "source": [
    "state = \"ND\"\n",
    "alperin,wiki,cesta = state_counts(state)\n",
    "alp_wik = mf.merge_two_sets(alperin,wiki)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Eastport\n"
     ]
    },
    {
     "ename": "KeyError",
     "evalue": "'CityST'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-13-24708ec49601>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      3\u001b[0m         \u001b[0;32mprint\u001b[0m \u001b[0;34m\"\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m         \u001b[0;32mprint\u001b[0m \u001b[0ma\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"Alperin_Place\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0miloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mm\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'a'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m         \u001b[0;32mprint\u001b[0m \u001b[0mb\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"CityST\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0miloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mm\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'b'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      6\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m         \u001b[0my\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;36m1790\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   2057\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2058\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2059\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2060\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2061\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_getitem_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m_getitem_column\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   2064\u001b[0m         \u001b[0;31m# get column\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2065\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_unique\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2066\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_item_cache\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2067\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2068\u001b[0m         \u001b[0;31m# duplicate columns & possible reduce dimensionality\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/generic.pyc\u001b[0m in \u001b[0;36m_get_item_cache\u001b[0;34m(self, item)\u001b[0m\n\u001b[1;32m   1384\u001b[0m         \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcache\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1385\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mres\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1386\u001b[0;31m             \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1387\u001b[0m             \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_box_item_values\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalues\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1388\u001b[0m             \u001b[0mcache\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mres\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/internals.pyc\u001b[0m in \u001b[0;36mget\u001b[0;34m(self, item, fastpath)\u001b[0m\n\u001b[1;32m   3541\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3542\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0misnull\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3543\u001b[0;31m                 \u001b[0mloc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3544\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3545\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0marange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0misnull\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/indexes/base.pyc\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2134\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2135\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2136\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_maybe_cast_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2137\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2138\u001b[0m         \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtolerance\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mtolerance\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/index.pyx\u001b[0m in \u001b[0;36mpandas.index.IndexEngine.get_loc (pandas/index.c:4433)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/index.pyx\u001b[0m in \u001b[0;36mpandas.index.IndexEngine.get_loc (pandas/index.c:4279)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/src/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas.hashtable.PyObjectHashTable.get_item (pandas/hashtable.c:13742)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/src/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas.hashtable.PyObjectHashTable.get_item (pandas/hashtable.c:13696)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'CityST'"
     ]
    }
   ],
   "source": [
    "for m in matches:    \n",
    "    if m[\"n_matches\"] < m[\"possible_overlaps\"]:\n",
    "        print \"\"\n",
    "        print a[0][\"Alperin_Place\"].iloc[m['a']]\n",
    "        print b[0][\"CityST\"].iloc[m['b']]\n",
    "\n",
    "        y = 1790\n",
    "        last_print = 0\n",
    "        a_ = list(a[1][m['a']])\n",
    "        b_ = list(b[1][m['b']])\n",
    "        for k in range(23):\n",
    "            i = a_[k]\n",
    "            j = b_[k]\n",
    "            if i > 0 and j > 0:\n",
    "                do_printout = False\n",
    "                for k_ in [-1,0,1]:\n",
    "                    try: \n",
    "                        i_ = a_[k + k_]\n",
    "                        j_ = b_[k + k_]\n",
    "                    except IndexError:\n",
    "                        continue\n",
    "                    if i_ != j_ and (i_ > 0 or j_ > 0): \n",
    "                        do_printout = True\n",
    "                if do_printout:\n",
    "                    print y,i,j,\"*\"*int(i!=j)*4\n",
    "            y += 10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'CESTA' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m\u001b[0m",
      "\u001b[0;31mNameError\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-14-46dfdd0e5c03>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0mst\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"CA\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m \u001b[0mcesta_maine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mCESTA\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mCESTA\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mST\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0mst\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mc_mat\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mCESTA\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mST\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0mst\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m \u001b[0mwiki_maine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mstate_wikipedia_data\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mst\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mNameError\u001b[0m: name 'CESTA' is not defined"
     ]
    }
   ],
   "source": [
    "\n",
    "\n",
    "st = \"CA\"\n",
    "cesta_maine = (CESTA[CESTA.ST==st],c_mat[CESTA.ST == st])\n",
    "wiki_maine = state_wikipedia_data(st)\n",
    "\n",
    "\n",
    "print \"CA Towns in CESTA missing from my Wikipedia parse\"\n",
    "for i,k in match_matrices(cesta_maine[1],wiki_maine[1],min=2):\n",
    "    if k is None:\n",
    "        if cesta_maine[1][i][19] > 0:\n",
    "            print cesta_maine[0].iloc[i][\"CityST\"]\n",
    "    else:\n",
    "        for j in k:\n",
    "            pass\n",
    "            #print alperin_maine[0].iloc[i][\"Place\"], \"=\", wiki_maine[0].iloc[j][\"title\"]\n",
    "print \"\"\n",
    "print \"=\"*80\n",
    "print \"\"\n",
    "print \"CA Towns in Wikipedia missing from my CESTA parse\"\n",
    "print \"-\" * 20\n",
    "a_not_b = []\n",
    "for i,k in match_matrices(wiki_maine[1],alperin_maine[1],min=2):\n",
    "    if k is None:\n",
    "        if wiki_maine[1][i][19] > 0:\n",
    "            print wiki_maine[0].iloc[i][\"title\"]\n",
    "    else:\n",
    "        for j in k:\n",
    "            pass\n",
    "st = \"CA\"\n",
    "cesta_maine = (CESTA[CESTA.ST==st],c_mat[CESTA.ST == st])\n",
    "wiki_maine = state_wikipedia_data(st)\n",
    "            #print alperin_maine[0].iloc[i][\"Place\"], \"=\", wiki_maine[0].iloc[j][\"title\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "st = \"ME\"\n",
    "cesta_maine = (CESTA[CESTA.ST==st],c_mat[CESTA.ST == st])\n",
    "wiki_maine = state_wikipedia_data(st)\n",
    "\n",
    "def summary_match(a,b,a_names = None,b_names = None,min=2):\n",
    "    p = match_matrices(a,b,min=min)\n",
    "    a_not_b = 0\n",
    "    for i,k in match_matrices(a,b,min=min):\n",
    "        if k is None:\n",
    "            a_not_b += 1\n",
    "    b_not_a = 0\n",
    "    for i,k in match_matrices(b,a,min=min):\n",
    "        if k is None:\n",
    "            b_not_a += 1\n",
    "    print \"{} of {} unique to set A, {} of {} unique to set B\".format(a_not_b,len(a),b_not_a,len(b))\n",
    "\n",
    "summary_match(cesta_maine[1],(all_together[all_together[\"state\"]==st],jacob_mat[all_together[\"state\"] == st])\n",
    "[1])\n",
    "cesta_maine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'wiki_maine' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m\u001b[0m",
      "\u001b[0;31mNameError\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-15-fac8573e16cd>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0;32mprint\u001b[0m \u001b[0mwiki_maine\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mwiki_maine\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtitle\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0;34m\"Chebeague Island, Maine\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0malperin_maine\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0malperin_maine\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mPlace\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0;34m\"Chebeague Island\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"1990\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mNameError\u001b[0m: name 'wiki_maine' is not defined"
     ]
    }
   ],
   "source": [
    "print wiki_maine[0][wiki_maine[0].title==\"Chebeague Island, Maine\"]\n",
    "alperin_maine[0][alperin_maine[0].Place==\"Chebeague Island\"][\"1990\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "altered_array = array.clip(2500)\n",
    "\n",
    "cesta_crosswalk = match_matrices(array,c_mat)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "j = 0\n",
    "misses = []\n",
    "for i,matches in cesta_crosswalk:\n",
    "    if matches is None:\n",
    "        if c_mat[i][19] > 0:\n",
    "            misses.append(i)\n",
    "            j += 1\n",
    "            print j,i,CESTA.iloc[i][\"CityST\"], \", \".join([str(int(p)) for p in list(c_mat[i]) if not np.isnan(p)])\n",
    "            f = c_mat[0]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "print len(misses)\n",
    "random.seed(3)\n",
    "sampled = random.sample(misses,10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "i = sampled[0]\n",
    "place, pops = CESTA.iloc[i][\"CityST\"], \", \".join([str(int(p)) if not np.isnan(p) else \"0\" for p in list(c_mat[i])])\n",
    "print place,\"--\", pops\n",
    "\n",
    "print frame[frame.title==\"Brunswick, Maine\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "So after digging around, it seems that CESTA reports statistics for the Brunswick CDP, (but rounded to the nearest 100?), while Wikipedia gives the statistics for Brunswick Town. The difference being a second CDP,   https://en.wikipedia.org/wiki/Brunswick_Station,_Maine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "i = sampled[1]\n",
    "place, pops = CESTA.iloc[i][\"CityST\"], \", \".join([str(int(p)) if not np.isnan(p) else \"0\" for p in list(c_mat[i])])\n",
    "print place,\"--\", pops\n",
    "\n",
    "print frame[frame.title==\"Lakewood Township, New Jersey\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "CESTA = pd.read_csv(\"../MiscData/CESTACityData.csv\")\n",
    "CESTA[\"2010\"] = pd.to_numeric(CESTA[\"2010\"],np.float64)\n",
    "c_mat = np.array(CESTA[[str(y) for y in years]])\n",
    "c_mat[c_mat < 2500] = np.nan\n",
    "c_mat[c_mat==0] = np.nan\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "print sum(sum(c_mat>0))\n",
    "print sum(sum(array>0))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Now I want to load the data from the wikipedia editor DemocraticLuntz, which is not the same as the full wikipedia set."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "There's a straightforward disagreement in at least this one case."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "a = frame[frame[\"title\"]==\"Princeton, Indiana\"].index[0]\n",
    "b = CESTA[CESTA.CityST == \"Princeton, IN\"].index[0]\n",
    "zip(\n",
    "    list(array[a]),\n",
    "    list(c_mat[b])\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Indana.gov says:\n",
    "    6,041\t6,448\t7,132\t7,505\t7,786\t7,673\t7,906\t7,431\t8,976\t8,127\t8,175\t8,644\n",
    "    \n",
    "IOW, agrees with the CESTA data.\n",
    "So does the Census report.\n",
    "So does jacobmas's data. It seems this is an anonymous wikipedia editor in 2007, who put in \n",
    "[an absurdly high current population](https://en.wikipedia.org/w/index.php?title=Princeton,_Indiana&diff=187475063&oldid=183213818) and just a whole bunch of bad (made-up?) numbers from before.'\n",
    "|1850= 806\n",
    "|1860= 1397\n",
    "|1870= 1847\n",
    "|1880= 2566\n",
    "|1890= 3076\n",
    "|1900= 6041\n",
    "|1910= 6448\n",
    "|1920= 7132\n",
    "|1930= 7505\n",
    "|1940= 7786\n",
    "|1950= 7673\n",
    "|1960= 7906\n",
    "|1970= 7431\n",
    "|1980= 8976\n",
    "|1990= 8127\n",
    "|2000= 8175\n",
    "|2010= 8644\n",
    "|2020= 8608\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Save to disk"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Confirm that requiring at least 3 matches produces no hash collisions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "c_self = match_matrices(c_mat,c_mat,2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "for row,matches in c_self:\n",
    "    try:\n",
    "        if len(matches) != 1:\n",
    "            print row,matches\n",
    "    except:\n",
    "        continue"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "It does not. The only collision is lines 1 and 2, because the Lahnmeyer data rounds to 100 for Alaskan towns. 8227 and 570 are both Lake Elsinore, CA. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "CESTA.iloc[8227]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}