Illinois Building Inventory.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import ipywidgets\n",
    "import datetime as dt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib\n",
    "import bqplot\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "illinois_buildings = pd.read_csv('building_inventory.csv')\n",
    "buildings = illinois_buildings[illinois_buildings['Year Acquired'] != 0]\n",
    "buildings = buildings[buildings['Year Constructed'] != 0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "build_agency = np.array(buildings['Agency Name'])\n",
    "\n",
    "build_district = np.array(buildings['Congress Dist'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Department of Natural Resources',\n",
       "       'Department of Natural Resources',\n",
       "       'Department of Natural Resources', ...,\n",
       "       'Department of Transportation', 'Department of Transportation',\n",
       "       'Illinois Community College Board'], dtype=object)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "buildings_departments = buildings.groupby(['Congress Dist','Agency Name'])['Square Footage'].sum().reset_index()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"21\" halign=\"left\">Square Footage</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agency Name</th>\n",
       "      <th>Appellate Court / Fifth District</th>\n",
       "      <th>Appellate Court / Fourth District</th>\n",
       "      <th>Appellate Court / Second District</th>\n",
       "      <th>Appellate Court / Third District</th>\n",
       "      <th>Chicago State University</th>\n",
       "      <th>Department of Agriculture</th>\n",
       "      <th>Department of Central Management Services</th>\n",
       "      <th>Department of Corrections</th>\n",
       "      <th>Department of Human Services</th>\n",
       "      <th>Department of Juvenile Justice</th>\n",
       "      <th>...</th>\n",
       "      <th>Illinois Emergency Management Agency</th>\n",
       "      <th>Illinois Medical District Commission</th>\n",
       "      <th>Illinois State University</th>\n",
       "      <th>Northeastern Illinois University</th>\n",
       "      <th>Northern Illinois University</th>\n",
       "      <th>Office of the Attorney General</th>\n",
       "      <th>Office of the Secretary of State</th>\n",
       "      <th>Southern Illinois University</th>\n",
       "      <th>University of Illinois</th>\n",
       "      <th>Western Illinois University</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Congress Dist</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>231278.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>372784.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5650.0</td>\n",
       "      <td>31200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41315.0</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>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1191992.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>449547.0</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>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49572.0</td>\n",
       "      <td>1253943.0</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>3643049.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9932.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>362890.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1110103.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28452.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72411.0</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>7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2088840.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>304039.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56904.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6363904.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43330.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65268.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>913263.0</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>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>443865.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>234642.0</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>11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2597882.0</td>\n",
       "      <td>66673.0</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>12</th>\n",
       "      <td>15124.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>535932.0</td>\n",
       "      <td>98355.0</td>\n",
       "      <td>2591445.0</td>\n",
       "      <td>1579167.0</td>\n",
       "      <td>63508.0</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>5552865.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>16400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000832.0</td>\n",
       "      <td>1003106.0</td>\n",
       "      <td>931578.0</td>\n",
       "      <td>192934.0</td>\n",
       "      <td>36538.0</td>\n",
       "      <td>...</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2960272.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2188472.0</td>\n",
       "      <td>3150729.0</td>\n",
       "      <td>14693427.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>538807.0</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>15</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41984.0</td>\n",
       "      <td>70160.0</td>\n",
       "      <td>2908129.0</td>\n",
       "      <td>394598.0</td>\n",
       "      <td>209238.0</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>16</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18700.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44130.0</td>\n",
       "      <td>2850697.0</td>\n",
       "      <td>206088.0</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>3625979.0</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>17</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29350.0</td>\n",
       "      <td>151963.0</td>\n",
       "      <td>1518382.0</td>\n",
       "      <td>247839.0</td>\n",
       "      <td>227480.0</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>60500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>315626.0</td>\n",
       "      <td>385896.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>54014.0</td>\n",
       "      <td>1656696.0</td>\n",
       "      <td>1887569.0</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>1962213.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Square Footage  \\\n",
       "Agency Name   Appellate Court / Fifth District   \n",
       "Congress Dist                                    \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                                     15124.0   \n",
       "13                                         NaN   \n",
       "14                                         NaN   \n",
       "15                                         NaN   \n",
       "16                                         NaN   \n",
       "17                                         NaN   \n",
       "18                                         NaN   \n",
       "\n",
       "                                                 \\\n",
       "Agency Name   Appellate Court / Fourth District   \n",
       "Congress Dist                                     \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                                      16400.0   \n",
       "14                                          NaN   \n",
       "15                                          NaN   \n",
       "16                                          NaN   \n",
       "17                                          NaN   \n",
       "18                                          NaN   \n",
       "\n",
       "                                                 \\\n",
       "Agency Name   Appellate Court / Second District   \n",
       "Congress Dist                                     \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                                       43330.0   \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",
       "\n",
       "                                                                         \\\n",
       "Agency Name   Appellate Court / Third District Chicago State University   \n",
       "Congress Dist                                                             \n",
       "0                                          NaN                      NaN   \n",
       "1                                          NaN                1191992.0   \n",
       "2                                          NaN                      NaN   \n",
       "3                                          NaN                      NaN   \n",
       "4                                          NaN                      NaN   \n",
       "5                                          NaN                      NaN   \n",
       "6                                          NaN                      NaN   \n",
       "7                                          NaN                      NaN   \n",
       "8                                          NaN                      NaN   \n",
       "9                                          NaN                      NaN   \n",
       "10                                         NaN                      NaN   \n",
       "11                                         NaN                      NaN   \n",
       "12                                         NaN                      NaN   \n",
       "13                                         NaN                      NaN   \n",
       "14                                         NaN                      NaN   \n",
       "15                                         NaN                      NaN   \n",
       "16                                     18700.0                      NaN   \n",
       "17                                         NaN                      NaN   \n",
       "18                                         NaN                      NaN   \n",
       "\n",
       "                                         \\\n",
       "Agency Name   Department of Agriculture   \n",
       "Congress Dist                             \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                             535932.0   \n",
       "13                            2000832.0   \n",
       "14                                  NaN   \n",
       "15                              41984.0   \n",
       "16                                  NaN   \n",
       "17                              29350.0   \n",
       "18                                  NaN   \n",
       "\n",
       "                                                         \\\n",
       "Agency Name   Department of Central Management Services   \n",
       "Congress Dist                                             \n",
       "0                                              231278.0   \n",
       "1                                                   NaN   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "5                                                9932.0   \n",
       "6                                                   NaN   \n",
       "7                                             2088840.0   \n",
       "8                                               65268.0   \n",
       "9                                                   NaN   \n",
       "10                                             443865.0   \n",
       "11                                                  NaN   \n",
       "12                                              98355.0   \n",
       "13                                            1003106.0   \n",
       "14                                                  NaN   \n",
       "15                                              70160.0   \n",
       "16                                              44130.0   \n",
       "17                                             151963.0   \n",
       "18                                              54014.0   \n",
       "\n",
       "                                                                      \\\n",
       "Agency Name   Department of Corrections Department of Human Services   \n",
       "Congress Dist                                                          \n",
       "0                                   NaN                     372784.0   \n",
       "1                                   NaN                     449547.0   \n",
       "2                               49572.0                    1253943.0   \n",
       "3                                   NaN                          NaN   \n",
       "4                                   NaN                          NaN   \n",
       "5                                   NaN                     362890.0   \n",
       "6                                   NaN                          NaN   \n",
       "7                                   NaN                     304039.0   \n",
       "8                                   NaN                     913263.0   \n",
       "9                                   NaN                          NaN   \n",
       "10                                  NaN                     234642.0   \n",
       "11                            2597882.0                      66673.0   \n",
       "12                            2591445.0                    1579167.0   \n",
       "13                             931578.0                     192934.0   \n",
       "14                                  NaN                          NaN   \n",
       "15                            2908129.0                     394598.0   \n",
       "16                            2850697.0                     206088.0   \n",
       "17                            1518382.0                     247839.0   \n",
       "18                            1656696.0                    1887569.0   \n",
       "\n",
       "                                              ...  \\\n",
       "Agency Name   Department of Juvenile Justice  ...   \n",
       "Congress Dist                                 ...   \n",
       "0                                        NaN  ...   \n",
       "1                                        NaN  ...   \n",
       "2                                        NaN  ...   \n",
       "3                                        NaN  ...   \n",
       "4                                        NaN  ...   \n",
       "5                                        NaN  ...   \n",
       "6                                    72411.0  ...   \n",
       "7                                        NaN  ...   \n",
       "8                                        NaN  ...   \n",
       "9                                        NaN  ...   \n",
       "10                                       NaN  ...   \n",
       "11                                       NaN  ...   \n",
       "12                                   63508.0  ...   \n",
       "13                                   36538.0  ...   \n",
       "14                                  538807.0  ...   \n",
       "15                                  209238.0  ...   \n",
       "16                                       NaN  ...   \n",
       "17                                  227480.0  ...   \n",
       "18                                       NaN  ...   \n",
       "\n",
       "                                                    \\\n",
       "Agency Name   Illinois Emergency Management Agency   \n",
       "Congress Dist                                        \n",
       "0                                           5650.0   \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                                         50000.0   \n",
       "14                                             NaN   \n",
       "15                                             NaN   \n",
       "16                                             NaN   \n",
       "17                                             NaN   \n",
       "18                                             NaN   \n",
       "\n",
       "                                                                              \\\n",
       "Agency Name   Illinois Medical District Commission Illinois State University   \n",
       "Congress Dist                                                                  \n",
       "0                                          31200.0                       NaN   \n",
       "1                                              NaN                       NaN   \n",
       "2                                              NaN                       NaN   \n",
       "3                                              NaN                       NaN   \n",
       "4                                              NaN                       NaN   \n",
       "5                                              NaN                       NaN   \n",
       "6                                              NaN                       NaN   \n",
       "7                                          15000.0                       NaN   \n",
       "8                                              NaN                       NaN   \n",
       "9                                              NaN                       NaN   \n",
       "10                                             NaN                       NaN   \n",
       "11                                             NaN                       NaN   \n",
       "12                                             NaN                       NaN   \n",
       "13                                             NaN                 2960272.0   \n",
       "14                                             NaN                       NaN   \n",
       "15                                             NaN                       NaN   \n",
       "16                                             NaN                       NaN   \n",
       "17                                             NaN                       NaN   \n",
       "18                                             NaN                       NaN   \n",
       "\n",
       "                                                                             \\\n",
       "Agency Name   Northeastern Illinois University Northern Illinois University   \n",
       "Congress Dist                                                                 \n",
       "0                                          NaN                      41315.0   \n",
       "1                                          NaN                          NaN   \n",
       "2                                          NaN                          NaN   \n",
       "3                                          NaN                          NaN   \n",
       "4                                          NaN                          NaN   \n",
       "5                                    1110103.0                          NaN   \n",
       "6                                          NaN                          NaN   \n",
       "7                                          NaN                          NaN   \n",
       "8                                          NaN                          NaN   \n",
       "9                                          NaN                          NaN   \n",
       "10                                         NaN                          NaN   \n",
       "11                                         NaN                          NaN   \n",
       "12                                         NaN                          NaN   \n",
       "13                                         NaN                          NaN   \n",
       "14                                         NaN                          NaN   \n",
       "15                                         NaN                          NaN   \n",
       "16                                         NaN                    3625979.0   \n",
       "17                                         NaN                          NaN   \n",
       "18                                         NaN                          NaN   \n",
       "\n",
       "                                                                               \\\n",
       "Agency Name   Office of the Attorney General Office of the Secretary of State   \n",
       "Congress Dist                                                                   \n",
       "0                                        NaN                              NaN   \n",
       "1                                        NaN                              NaN   \n",
       "2                                        NaN                              NaN   \n",
       "3                                        NaN                              NaN   \n",
       "4                                        NaN                              NaN   \n",
       "5                                        NaN                          28452.0   \n",
       "6                                        NaN                              NaN   \n",
       "7                                        NaN                          56904.0   \n",
       "8                                        NaN                              NaN   \n",
       "9                                        NaN                              NaN   \n",
       "10                                       NaN                              NaN   \n",
       "11                                       NaN                              NaN   \n",
       "12                                       NaN                              NaN   \n",
       "13                                       NaN                        2188472.0   \n",
       "14                                       NaN                              NaN   \n",
       "15                                       NaN                              NaN   \n",
       "16                                       NaN                              NaN   \n",
       "17                                   60500.0                              NaN   \n",
       "18                                       NaN                              NaN   \n",
       "\n",
       "                                                                   \\\n",
       "Agency Name   Southern Illinois University University of Illinois   \n",
       "Congress Dist                                                       \n",
       "0                                      NaN                    NaN   \n",
       "1                                      NaN                    NaN   \n",
       "2                                      NaN              3643049.0   \n",
       "3                                      NaN                    NaN   \n",
       "4                                      NaN                    NaN   \n",
       "5                                      NaN                    NaN   \n",
       "6                                      NaN                    NaN   \n",
       "7                                      NaN              6363904.0   \n",
       "8                                      NaN                    NaN   \n",
       "9                                      NaN                    NaN   \n",
       "10                                     NaN                    NaN   \n",
       "11                                     NaN                    NaN   \n",
       "12                               5552865.0                    NaN   \n",
       "13                               3150729.0             14693427.0   \n",
       "14                                     NaN                    NaN   \n",
       "15                                     NaN                    NaN   \n",
       "16                                     NaN                    NaN   \n",
       "17                                     NaN               315626.0   \n",
       "18                                     NaN                    NaN   \n",
       "\n",
       "                                           \n",
       "Agency Name   Western Illinois University  \n",
       "Congress Dist                              \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                               385896.0  \n",
       "18                              1962213.0  \n",
       "\n",
       "[19 rows x 35 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buildings_pivot = buildings_departments.pivot_table(index='Congress Dist', columns='Agency Name',values=['Square Footage'])\n",
    "buildings_pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 2.3127800e+05,           nan,\n",
       "        3.7278400e+05,           nan,           nan, 3.1753000e+04,\n",
       "                  nan,           nan, 8.2390000e+03, 5.0678000e+04,\n",
       "        3.0000000e+03,           nan,           nan,           nan,\n",
       "        3.8310000e+03,           nan,           nan,           nan,\n",
       "                  nan, 5.6500000e+03, 3.1200000e+04,           nan,\n",
       "                  nan, 4.1315000e+04,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "        1.1919920e+06,           nan,           nan,           nan,\n",
       "        4.4954700e+05,           nan, 5.6458000e+05,           nan,\n",
       "                  nan,           nan,           nan, 1.1814300e+05,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan, 4.9572000e+04,\n",
       "        1.2539430e+06,           nan, 2.2650000e+05, 5.9050000e+04,\n",
       "                  nan,           nan,           nan, 2.8750900e+05,\n",
       "        4.7906100e+05,           nan,           nan,           nan,\n",
       "        2.8700000e+05,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan, 3.6430490e+06,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 4.8552000e+04,           nan,\n",
       "                  nan,           nan, 1.4583000e+04, 1.3258100e+05,\n",
       "                  nan,           nan,           nan, 9.6207100e+05,\n",
       "                  nan,           nan,           nan, 4.2000000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 2.2495900e+05,           nan,\n",
       "                  nan,           nan,           nan, 3.3475000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "        5.7800000e+04,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 9.9320000e+03,           nan,\n",
       "        3.6289000e+05,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan, 1.1212000e+05,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "        1.1101030e+06,           nan,           nan, 2.8452000e+04,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan, 7.2411000e+04,           nan, 2.4105000e+04,\n",
       "                  nan,           nan,           nan, 2.9996000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan, 1.9147000e+04,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 2.0888400e+06,           nan,\n",
       "        3.0403900e+05,           nan, 2.4040000e+05,           nan,\n",
       "                  nan,           nan, 8.5708000e+04, 5.4492000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "        2.3640000e+03,           nan,           nan,           nan,\n",
       "                  nan,           nan, 1.5000000e+04,           nan,\n",
       "                  nan,           nan,           nan, 5.6904000e+04,\n",
       "                  nan, 6.3639040e+06,           nan],\n",
       "       [          nan,           nan, 4.3330000e+04,           nan,\n",
       "                  nan,           nan, 6.5268000e+04,           nan,\n",
       "        9.1326300e+05,           nan, 3.1168000e+04,           nan,\n",
       "                  nan,           nan, 9.7760000e+03, 3.9870700e+05,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan, 6.9750000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 4.4386500e+05,           nan,\n",
       "        2.3464200e+05,           nan, 4.0852000e+04, 2.0039200e+05,\n",
       "                  nan,           nan, 6.2460000e+03, 3.2700000e+03,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan, 2.5978820e+06,\n",
       "        6.6673000e+04,           nan, 5.4012000e+04,           nan,\n",
       "                  nan,           nan, 3.0914000e+04, 7.3072000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 5.4581600e+05, 9.9068000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [1.5124000e+04,           nan,           nan,           nan,\n",
       "                  nan, 5.3593200e+05, 9.8355000e+04, 2.5914450e+06,\n",
       "        1.5791670e+06, 6.3508000e+04, 4.2482900e+05, 6.3347500e+05,\n",
       "        7.1600000e+03,           nan, 1.1368500e+05, 6.1884100e+05,\n",
       "        4.0000000e+04,           nan,           nan,           nan,\n",
       "        1.2392400e+05,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "        5.5528650e+06,           nan,           nan],\n",
       "       [          nan, 1.6400000e+04,           nan,           nan,\n",
       "                  nan, 2.0008320e+06, 1.0031060e+06, 9.3157800e+05,\n",
       "        1.9293400e+05, 3.6538000e+04, 9.1264800e+05, 5.6682700e+05,\n",
       "                  nan, 9.1323600e+05, 2.7261900e+05, 1.0300600e+06,\n",
       "                  nan,           nan, 4.5120000e+04,           nan,\n",
       "        7.9512000e+05,           nan,           nan,           nan,\n",
       "        5.4540000e+04, 5.0000000e+04,           nan, 2.9602720e+06,\n",
       "                  nan,           nan,           nan, 2.1884720e+06,\n",
       "        3.1507290e+06, 1.4693427e+07,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan, 5.3880700e+05, 5.2366000e+04, 1.7291400e+05,\n",
       "                  nan,           nan,           nan, 8.7900000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan, 4.1984000e+04, 7.0160000e+04, 2.9081290e+06,\n",
       "        3.9459800e+05, 2.0923800e+05, 3.8928600e+05, 5.4362100e+05,\n",
       "                  nan,           nan, 2.6710000e+04, 8.1486600e+05,\n",
       "                  nan, 1.1646740e+06,           nan,           nan,\n",
       "        9.8011000e+04,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan, 1.8700000e+04,\n",
       "                  nan,           nan, 4.4130000e+04, 2.8506970e+06,\n",
       "        2.0608800e+05,           nan, 3.4263800e+05, 5.7559000e+05,\n",
       "                  nan,           nan, 4.0242000e+04, 7.1584100e+05,\n",
       "        1.2423500e+05,           nan,           nan,           nan,\n",
       "        1.1700000e+04,           nan,           nan, 4.9552000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan, 3.6259790e+06,           nan,           nan,\n",
       "                  nan,           nan,           nan],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan, 2.9350000e+04, 1.5196300e+05, 1.5183820e+06,\n",
       "        2.4783900e+05, 2.2748000e+05, 3.7755000e+05, 3.8553900e+05,\n",
       "                  nan,           nan, 5.0974000e+04, 3.9835100e+05,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "        1.1277700e+05,           nan,           nan, 2.6700000e+04,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 6.0500000e+04,           nan,\n",
       "                  nan, 3.1562600e+05, 3.8589600e+05],\n",
       "       [          nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 5.4014000e+04, 1.6566960e+06,\n",
       "        1.8875690e+06,           nan, 1.3777400e+05, 6.4098900e+05,\n",
       "                  nan,           nan, 1.6915500e+05, 5.1593100e+05,\n",
       "        6.5216000e+05,           nan,           nan,           nan,\n",
       "        1.7542700e+05,           nan,           nan, 2.5262300e+05,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan,           nan,           nan,\n",
       "                  nan,           nan, 1.9622130e+06]])"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buildings_values  = buildings_pivot.values\n",
    "buildings_values\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "ff6fdb9df1ba4b1eb9dd4a678c95915b",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Figure(axes=[ColorAxis(orientation='vertical', scale=ColorScale(max=14693427.0, min=2364.0, scheme='Spectral')…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "\n",
    "col_sc = bqplot.ColorScale(scheme = 'Spectral',min=np.nanmin(buildings_pivot), \n",
    "                           max=np.nanmax(buildings_pivot))\n",
    "x_sc = bqplot.OrdinalScale()\n",
    "y_sc = bqplot.OrdinalScale()\n",
    "\n",
    "c_ax = bqplot.ColorAxis(scale = col_sc, \n",
    "                        orientation = 'vertical', \n",
    "                        side = 'right')\n",
    "x_ax = bqplot.Axis(scale = x_sc)\n",
    "y_ax = bqplot.Axis(scale = y_sc, \n",
    "                   orientation = 'vertical')\n",
    "\n",
    "\n",
    "heat_map = bqplot.GridHeatMap(color = buildings_pivot,\n",
    "                              scales = {'color': col_sc,\n",
    "                                        'row': y_sc,\n",
    "                                        'column':x_sc },\n",
    "                              interactions = {'click': 'select'}, # make interactive on click of each box\n",
    "                              anchor_style = {'fill':'blue'}, # to make our selection blue\n",
    "                              selected_style = {'opacity': 1.0}, # make 100% opaque if box is selected\n",
    "                              unselected_style = {'opacity': 0.8}) # make a little see-through if not\n",
    "\n",
    "# stir and combine into 1 figure\n",
    "fig = bqplot.Figure(marks = [heat_map], \n",
    "                    axes = [c_ax, y_ax, x_ax])\n",
    "\n",
    "fig"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "buildings_year_square = buildings.groupby('Year Acquired')['Square Footage'].sum().reset_index()\n",
    "\n",
    "build_ya= np.array(buildings_year_square['Year Acquired'].astype('float'))\n",
    "build_sq = np.array(buildings_year_square['Square Footage'].astype('float'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "a268292f73d846d584ab4fab090e146b",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Figure(axes=[Axis(label='Date', scale=LinearScale(max=2019.0, min=1753.0)), Axis(label='Duration in Sec', orie…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "x_scl = bqplot.LinearScale(min=1753,max=2019) # note: for dates on x-axis\n",
    "y_scl = bqplot.LinearScale(min=500, max=5000000)\n",
    "width_line = bqplot.LinearScale()\n",
    "ax_xcl = bqplot.Axis(label='Date', scale=x_scl)\n",
    "ax_ycl = bqplot.Axis(label='Duration in Sec', scale=y_scl, \n",
    "                    orientation='vertical', side='left')\n",
    "\n",
    "duration_Lines = bqplot.Lines(x = build_ya,\n",
    "                               y = build_sq, \n",
    "                              scales={'x':x_scl, 'y':y_scl,'width': width_line,}\n",
    "                                      )\n",
    "\n",
    "\n",
    "fig_dur = bqplot.Figure(marks = [duration_Lines], axes = [ax_xcl, ax_ycl])\n",
    "fig_dur"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "5af94ae51b2f4b069d722da3d84531a9",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "VBox(children=(Label(value=''), HBox(children=(Figure(axes=[ColorAxis(orientation='vertical', scale=ColorScale…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "\n",
    "# recopy our scales and axis for posterity:\n",
    "col_sc = bqplot.ColorScale(scheme = 'Spectral',min=np.nanmin(buildings_pivot), \n",
    "                           max=np.nanmax(buildings_pivot))\n",
    "x_sc = bqplot.OrdinalScale()\n",
    "y_sc = bqplot.OrdinalScale()\n",
    "# create axis - for colors, x & y\n",
    "c_ax = bqplot.ColorAxis(scale = col_sc, \n",
    "                        orientation = 'vertical', \n",
    "                        side = 'right')\n",
    "x_ax = bqplot.Axis(scale = x_sc)\n",
    "y_ax = bqplot.Axis(scale = y_sc, \n",
    "                   orientation = 'vertical')\n",
    "\n",
    "# lets now re-do our heat map & add in some interactivity:\n",
    "heat_map = bqplot.GridHeatMap(color = buildings_pivot,\n",
    "                              scales = {'color': col_sc,\n",
    "                                        'row': y_sc,\n",
    "                                        'column': x_sc},\n",
    "                              interactions = {'click': 'select'}, # make interactive on click of each box\n",
    "                              anchor_style = {'fill':'blue'}, # to make our selection blue\n",
    "                              selected_style = {'opacity': 1.0}, # make 100% opaque if box is selected\n",
    "                              unselected_style = {'opacity': 0.8}) # make a little see-through if not\n",
    "\n",
    "\n",
    "\n",
    "# stir and combine into 1 figure\n",
    "fig = bqplot.Figure(marks = [heat_map], \n",
    "                    axes = [c_ax, y_ax, x_ax])\n",
    "\n",
    "\n",
    "\n",
    "##Fig 2\n",
    "\n",
    "x_scl = bqplot.LinearScale(min=1753,max=2019) # note: for dates on x-axis\n",
    "y_scl = bqplot.LogScale(min=500, max=5000000)\n",
    "width_line = bqplot.LinearScale()\n",
    "ax_xcl = bqplot.Axis(label='Date', scale=x_scl)\n",
    "ax_ycl = bqplot.Axis(label='Duration in Sec', scale=y_scl, \n",
    "                    orientation='vertical', side='left')\n",
    "\n",
    "hist2d, long_edges, lat_edges = np.histogram2d(build_ya,build_sq, bins=[19,35])\n",
    "i,j = 16,0\n",
    "longs = [long_edges[i], long_edges[i+1]]\n",
    "lats = [lat_edges[j],lat_edges[j+1]]\n",
    "region_mask = ( (build_sq >= lats[0]) | (build_sq<=lats[1]) &\\\n",
    "                (build_ya >= longs[0]) | (build_ya <=longs[1]) ) # picking an x/y bin -- this is one I know has a lot of data!\n",
    "# we can see this selects for the upper right point of our heatmap\n",
    "lats, longs, buildings_year_square['Square Footage'][region_mask]\n",
    "\n",
    "duration_Lines = bqplot.Lines(x = build_ya[region_mask],\n",
    "                               y = build_sq[region_mask], \n",
    "                              scales={'x':x_scl, 'y':y_scl,'width': width_line,}\n",
    "                                      )\n",
    "\n",
    "\n",
    "fig_dur = bqplot.Figure(marks = [duration_Lines], axes = [ax_xcl, ax_ycl])\n",
    "fig_dur\n",
    "\n",
    "\n",
    "\n",
    "mySelectedLabel = ipywidgets.Label()\n",
    "\n",
    "\n",
    "def get_data_value2(change):\n",
    "    i,j = change['owner'].selected[0]\n",
    "    v = buildings_values[i,j] # grab data value\n",
    "    mySelectedLabel.value = 'Total Sum Square Footge Area = ' + str(v) # set our label\n",
    "    # note!! i & j are swapped here to machup with hist & selection \n",
    "    longs = [long_edges[i], long_edges[i+1]] # min/max longitude\n",
    "    lats = [lat_edges[j],lat_edges[j+1]] # min/max latitude\n",
    "    region_mask = ( (build_sq >= lats[0]) & (build_sq<=lats[1]) &\\\n",
    "                (build_ya >= longs[0]) | (build_ya <=longs[1]) ) # picking an x/y bin -- this is one I know has a lot of data!\n",
    "# we can see this selects for the upper right point of our heatmap\n",
    "    \n",
    "    duration_Lines.x = build_ya[region_mask]\n",
    "    duration_Lines.y = build_sq[region_mask]\n",
    "    #print(region_mask)\n",
    "   \n",
    "\n",
    "heat_map.observe(get_data_value2, 'selected')\n",
    "\n",
    "\n",
    "\n",
    "fig.min_width='500px'\n",
    "fig_dur.layout.min_width='500px'\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ipywidgets.VBox([mySelectedLabel, ipywidgets.HBox([fig,fig_dur])])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}