{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Start by importing all the libraries we need" ] }, { "cell_type": "code", "execution_count": 57, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 118, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import numpy as np\n", "\n", "pd.DataFrame" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Now, a quick review of what we covered last week\n", "* we are going to use the library \"pandas\" to read and manipulate data" ] }, { "cell_type": "code", "execution_count": 153, "metadata": {}, "outputs": [], "source": [ "# I heard some folks had some errors doing this - lets check around, does this work for everybody?\n", "buildings = pd.read_csv(\"/Users/jillnaiman1/Downloads/building_inventory.csv\",\n", " na_values = {'Year Acquired': 0, \n", " 'Year Constructed': 0, \n", " 'Square Footage': 0})\n", "\n" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Agency Name | \n", "Location Name | \n", "Address | \n", "City | \n", "Zip code | \n", "County | \n", "Congress Dist | \n", "Congressional Full Name | \n", "Rep Dist | \n", "Rep Full Name | \n", "... | \n", "Bldg Status | \n", "Year Acquired | \n", "Year Constructed | \n", "Square Footage | \n", "Total Floors | \n", "Floors Above Grade | \n", "Floors Below Grade | \n", "Usage Description | \n", "Usage Description 2 | \n", "Usage Description 3 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Department of Natural Resources | \n", "Anderson Lake Conservation Area - Fulton County | \n", "Anderson Lake C.a. | \n", "Astoria | \n", "61501 | \n", "Fulton | \n", "17 | \n", "Cheri Bustos | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "1975.0 | \n", "1975.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
1 | \n", "Department of Natural Resources | \n", "Anderson Lake Conservation Area - Fulton County | \n", "Anderson Lake C.a. | \n", "Astoria | \n", "61501 | \n", "Fulton | \n", "17 | \n", "Cheri Bustos | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2004.0 | \n", "2004.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
2 | \n", "Department of Natural Resources | \n", "Anderson Lake Conservation Area - Fulton County | \n", "Anderson Lake C.a. | \n", "Astoria | \n", "61501 | \n", "Fulton | \n", "17 | \n", "Cheri Bustos | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2004.0 | \n", "2004.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
3 | \n", "Department of Natural Resources | \n", "Anderson Lake Conservation Area - Fulton County | \n", "Anderson Lake C.a. | \n", "Astoria | \n", "61501 | \n", "Fulton | \n", "17 | \n", "Cheri Bustos | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2004.0 | \n", "2004.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
4 | \n", "Department of Natural Resources | \n", "Anderson Lake Conservation Area - Fulton County | \n", "Anderson Lake C.a. | \n", "Astoria | \n", "61501 | \n", "Fulton | \n", "17 | \n", "Cheri Bustos | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2004.0 | \n", "2004.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
5 | \n", "Department of Natural Resources | \n", "Anderson Lake Conservation Area - Fulton County | \n", "Anderson Lake C.a. | \n", "Astoria | \n", "61501 | \n", "Fulton | \n", "17 | \n", "Cheri Bustos | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2004.0 | \n", "2004.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
6 | \n", "Department of Natural Resources | \n", "Dixon Springs State Park - Pope County | \n", "Rr #2 | \n", "Golconda | \n", "62938 | \n", "Pope | \n", "15 | \n", "John Shimkus | \n", "118 | \n", "Phelps Brandon W. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "120.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
7 | \n", "Department of Natural Resources | \n", "Dixon Springs State Park - Pope County | \n", "Rr #2 | \n", "Golconda | \n", "62938 | \n", "Pope | \n", "15 | \n", "John Shimkus | \n", "118 | \n", "Phelps Brandon W. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "120.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
8 | \n", "Department of Natural Resources | \n", "Matthiessen State Park - LaSalle County | \n", "R. R. 178, Box 509 | \n", "Utica | \n", "61373 | \n", "LaSalle | \n", "16 | \n", "Adam Kinzinger | \n", "76 | \n", "Long Jerry Lee | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
9 | \n", "Department of Natural Resources | \n", "Matthiessen State Park - LaSalle County | \n", "R. R. 178, Box 509 | \n", "Utica | \n", "61373 | \n", "LaSalle | \n", "16 | \n", "Adam Kinzinger | \n", "76 | \n", "Long Jerry Lee | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
10 | \n", "Department of Natural Resources | \n", "Matthiessen State Park - LaSalle County | \n", "R. R. 178, Box 509 | \n", "Utica | \n", "61373 | \n", "LaSalle | \n", "16 | \n", "Adam Kinzinger | \n", "76 | \n", "Long Jerry Lee | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
11 | \n", "Department of Natural Resources | \n", "Matthiessen State Park - LaSalle County | \n", "R. R. 178, Box 509 | \n", "Utica | \n", "61373 | \n", "LaSalle | \n", "16 | \n", "Adam Kinzinger | \n", "76 | \n", "Long Jerry Lee | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
12 | \n", "Department of Natural Resources | \n", "Eldon Hazlet State Park - Clinton County | \n", "Keyesport Road | \n", "Carlyle | \n", "62231 | \n", "Clinton | \n", "15 | \n", "John Shimkus | \n", "107 | \n", "Cavaletto John | \n", "... | \n", "In Use | \n", "1999.0 | \n", "1999.0 | \n", "96.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Storage | \n", "Storage | \n", "Not provided | \n", "
13 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "1980.0 | \n", "1980.0 | \n", "625.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Assembly | \n", "Assembly | \n", "Not provided | \n", "
14 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
15 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
16 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "1997.0 | \n", "1997.0 | \n", "740.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Assembly | \n", "Assembly | \n", "Not provided | \n", "
17 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "320.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Assembly | \n", "Assembly | \n", "Not provided | \n", "
18 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
19 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "1976.0 | \n", "1976.0 | \n", "625.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Assembly | \n", "Assembly | \n", "Not provided | \n", "
20 | \n", "Department of Natural Resources | \n", "Weinberg-King State Park - Schuyler County | \n", "P.o. Box 203 | \n", "Augusta | \n", "62311 | \n", "Schuyler | \n", "18 | \n", "Darin M. LaHood | \n", "93 | \n", "Hammond Norine K. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
21 | \n", "Department of Natural Resources | \n", "Wolf Creek State Park | \n", "R.r. 1 Box 99 | \n", "Windsor | \n", "62534 | \n", "Shelby | \n", "15 | \n", "John Shimkus | \n", "102 | \n", "Halbrook Brad | \n", "... | \n", "In Use | \n", "1980.0 | \n", "1980.0 | \n", "144.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Storage | \n", "Storage | \n", "Not provided | \n", "
22 | \n", "Department of Natural Resources | \n", "Wolf Creek State Park | \n", "R.r. 1 Box 99 | \n", "Windsor | \n", "62534 | \n", "Shelby | \n", "15 | \n", "John Shimkus | \n", "102 | \n", "Halbrook Brad | \n", "... | \n", "In Use | \n", "1994.0 | \n", "1994.0 | \n", "2000.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Storage | \n", "Storage | \n", "Not provided | \n", "
23 | \n", "Department of Corrections | \n", "Dwight Correctional Center - Livingston County | \n", "Route 17 West | \n", "Dwight | \n", "60420 | \n", "Livingston | \n", "16 | \n", "Adam Kinzinger | \n", "90 | \n", "Demmer Tom | \n", "... | \n", "In Use | \n", "2001.0 | \n", "2001.0 | \n", "2048.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Industrial | \n", "Industrial | \n", "Not provided | \n", "
24 | \n", "Department of Human Services | \n", "Joliet Sexually Violent Persons Facility | \n", "1125 North Collins Street | \n", "Joliet | \n", "60432 | \n", "Will | \n", "11 | \n", "Bill Foster | \n", "86 | \n", "Walsh, Jr. Lawrence M. | \n", "... | \n", "In Use | \n", "2001.0 | \n", "2001.0 | \n", "22000.0 | \n", "2 | \n", "2 | \n", "0 | \n", "Health Care | \n", "Detention & Correc | \n", "Not provided | \n", "
25 | \n", "Department of Corrections | \n", "Southwestern Correctional Center - E. St. Louis | \n", "950 Kingshighway P.o. Box 50 | \n", "East St Louis | \n", "62203 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "113 | \n", "Hoffman Jay | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "120.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Storage | \n", "Storage | \n", "Not provided | \n", "
26 | \n", "Department of Transportation | \n", "Fithian Maintenance Storage Facility - Vermili... | \n", "1518 East 1800 North Road | \n", "Fithian | \n", "61844 | \n", "Vermilion | \n", "15 | \n", "John Shimkus | \n", "104 | \n", "Hays Chad | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "4860.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Storage | \n", "Storage | \n", "Not provided | \n", "
27 | \n", "Department of State Police | \n", "Effingham District 12 - Effingham County | \n", "2 Miles East Of Mason | \n", "Effingham | \n", "62454 | \n", "Effingham | \n", "15 | \n", "John Shimkus | \n", "107 | \n", "Cavaletto John | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "156.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Industrial | \n", "Industrial | \n", "Not provided | \n", "
28 | \n", "Department of Military Affairs | \n", "Marseilles Armory (Training Area) - LaSalle Co. | \n", "2515 N. 23rd. Road | \n", "Marseilles | \n", "61341 | \n", "LaSalle | \n", "16 | \n", "Adam Kinzinger | \n", "75 | \n", "Welter David A. | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "1080.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Unusual | \n", "Unusual | \n", "Not provided | \n", "
29 | \n", "Department of Agriculture | \n", "DuQuoin State Fairgrounds - Perry County | \n", "Route #2, Box 306 | \n", "Duquoin | \n", "62832 | \n", "Perry | \n", "12 | \n", "Mike Bost | \n", "115 | \n", "Bryant Terri | \n", "... | \n", "In Use | \n", "2000.0 | \n", "2000.0 | \n", "2020.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Storage | \n", "Storage | \n", "Not provided | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
8832 | \n", "Department of Transportation | \n", "Ashkum Team Section Headquarters | \n", "849 E. State Rt. 116 | \n", "Ashkum | \n", "60911 | \n", "Iroquois | \n", "16 | \n", "Adam Kinzinger | \n", "106 | \n", "Bennett Thomas M. | \n", "... | \n", "In Progress | \n", "NaN | \n", "NaN | \n", "10000.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8833 | \n", "Department of Transportation | \n", "Litchfield Weigh Station, I-55 Montgomery County | \n", "13456 Old Route 66 | \n", "Litchfield | \n", "62056 | \n", "Montgomery | \n", "16 | \n", "Adam Kinzinger | \n", "106 | \n", "Bennett Thomas M. | \n", "... | \n", "In Progress | \n", "NaN | \n", "NaN | \n", "703.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Business | \n", "Business | \n", "NaN | \n", "
8834 | \n", "Department of Transportation | \n", "Litchfield Weigh Station, I-55 Montgomery County | \n", "13456 Old Route 66 | \n", "Litchfield | \n", "62056 | \n", "Montgomery | \n", "16 | \n", "Adam Kinzinger | \n", "106 | \n", "Bennett Thomas M. | \n", "... | \n", "In Progress | \n", "NaN | \n", "NaN | \n", "6300.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Business | \n", "Business | \n", "NaN | \n", "
8835 | \n", "Department of Transportation | \n", "Harrisburg Maintenance Storage Facility - Sali... | \n", "1700 South Feazel Street | \n", "Harrisburg | \n", "62946 | \n", "Saline | \n", "15 | \n", "John Shimkus | \n", "118 | \n", "Phelps Brandon W. | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "256.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8836 | \n", "Department of Transportation | \n", "Harrisburg Maintenance Storage Facility - Sali... | \n", "1700 South Feazel Street | \n", "Harrisburg | \n", "62946 | \n", "Saline | \n", "15 | \n", "John Shimkus | \n", "118 | \n", "Phelps Brandon W. | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "56.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Utiility & Miscellan | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8837 | \n", "Department of Transportation | \n", "Harrisburg Maintenance Storage Facility - Sali... | \n", "1700 South Feazel Street | \n", "Harrisburg | \n", "62946 | \n", "Saline | \n", "15 | \n", "John Shimkus | \n", "118 | \n", "Phelps Brandon W. | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "72.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8838 | \n", "Department of Transportation | \n", "E. St. Louis Maintenance Storage Facility - St... | \n", "728 Exchange Ave. | \n", "East St. Louis | \n", "62201 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "114 | \n", "Greenwood LaToya | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "160.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Utiility & Miscellan | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8839 | \n", "Department of Transportation | \n", "E. St. Louis Maintenance Storage Facility - St... | \n", "728 Exchange Ave. | \n", "East St. Louis | \n", "62201 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "114 | \n", "Greenwood LaToya | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "32.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8840 | \n", "Department of Transportation | \n", "E. St. Louis Maintenance Storage Facility - St... | \n", "728 Exchange Ave. | \n", "East St. Louis | \n", "62201 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "114 | \n", "Greenwood LaToya | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "1100.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8841 | \n", "Department of Transportation | \n", "E. St. Louis Maintenance Storage Facility - St... | \n", "728 Exchange Ave. | \n", "East St. Louis | \n", "62201 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "114 | \n", "Greenwood LaToya | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "64.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Utiility & Miscellan | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8842 | \n", "Department of Transportation | \n", "E. St. Louis Maintenance Storage Facility - St... | \n", "728 Exchange Ave. | \n", "East St. Louis | \n", "62201 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "114 | \n", "Greenwood LaToya | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "80.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Utiility & Miscellan | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8843 | \n", "Department of Transportation | \n", "E. St. Louis Maintenance Storage Facility - St... | \n", "728 Exchange Ave. | \n", "East St. Louis | \n", "62201 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "114 | \n", "Greenwood LaToya | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "90.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8844 | \n", "Department of Transportation | \n", "E. St. Louis Maintenance Storage Facility - St... | \n", "728 Exchange Ave. | \n", "East St. Louis | \n", "62201 | \n", "St. Clair | \n", "12 | \n", "Mike Bost | \n", "114 | \n", "Greenwood LaToya | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "1270.0 | \n", "0 | \n", "0 | \n", "0 | \n", "Utiility & Miscellan | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8845 | \n", "Department of Transportation | \n", "Morton Maintenance Storage Facility - Tazewell... | \n", "1971 Morton Avenue | \n", "Morton | \n", "61550 | \n", "Tazewell | \n", "18 | \n", "Darin M. LaHood | \n", "88 | \n", "Sommer Keith P. | \n", "... | \n", "In Progress | \n", "2018.0 | \n", "2018.0 | \n", "2250.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8846 | \n", "Department of Transportation | \n", "Dan Ryan Field Office | \n", "900 S. Desplaines St. | \n", "Chicago | \n", "60607 | \n", "Cook | \n", "7 | \n", "Danny K. Davis | \n", "9 | \n", "Turner Arthur L. | \n", "... | \n", "In Progress | \n", "2018.0 | \n", "2018.0 | \n", "12000.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Business | \n", "Storage | \n", "NaN | \n", "
8847 | \n", "Department of Transportation | \n", "Elgin/O'Hare Expressway - Kane Co. | \n", "1480 Rodenburg Road | \n", "Schaumburg | \n", "60193 | \n", "Kane | \n", "8 | \n", "Tammy Duckworth | \n", "43 | \n", "Moeller Anna | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "36.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Utiility & Miscellan | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8848 | \n", "Department of Transportation | \n", "Wenona Maintenance Storage Facility - Marshall... | \n", "3095 County Rd 800 North | \n", "Wenona | \n", "61377 | \n", "Marshall | \n", "18 | \n", "Darin M. LaHood | \n", "73 | \n", "Spain Ryan | \n", "... | \n", "In Use | \n", "2016.0 | \n", "2016.0 | \n", "1152.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8849 | \n", "Department of Military Affairs | \n", "Galesburg Readiness Center - Knox County | \n", "362 N. Linwood Road | \n", "Galesburg | \n", "61401 | \n", "Knox | \n", "17 | \n", "Cheri Bustos | \n", "74 | \n", "Swanson Daniel | \n", "... | \n", "In Progress | \n", "NaN | \n", "2018.0 | \n", "3200.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8850 | \n", "Department of Transportation | \n", "Aledo Salt Storage Building - Mercer County | \n", "1610 3rd Street | \n", "Aledd | \n", "61231 | \n", "Mercer | \n", "17 | \n", "Cheri Bustos | \n", "74 | \n", "Swanson Daniel | \n", "... | \n", "In Progress | \n", "2018.0 | \n", "2018.0 | \n", "1455.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8851 | \n", "Department of Transportation | \n", "Biggsville - Henderson County | \n", "Route 1 | \n", "Biggsville | \n", "61418 | \n", "Henderson | \n", "17 | \n", "Cheri Bustos | \n", "94 | \n", "Frese Randy E. | \n", "... | \n", "In Progress | \n", "2018.0 | \n", "2018.0 | \n", "1455.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Storage | \n", "NaN | \n", "
8852 | \n", "Department of Transportation | \n", "Decatur Maintenance Facility - Macon County | \n", "4142 N. Westlawn Avenue | \n", "Decatur | \n", "62526 | \n", "Macon | \n", "4 | \n", "Luis Gutierrez | \n", "4 | \n", "Soto Cynthia | \n", "... | \n", "In Progress | \n", "2017.0 | \n", "2017.0 | \n", "6720.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8853 | \n", "Department of Transportation | \n", "Marion Maintenance Facility - Williamson County | \n", "Interstate 57 Milepost 46 | \n", "Marion | \n", "62959 | \n", "Williamson | \n", "12 | \n", "Mike Bost | \n", "117 | \n", "Severin Dave | \n", "... | \n", "In Progress | \n", "2019.0 | \n", "2019.0 | \n", "760.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Business | \n", "Business | \n", "NaN | \n", "
8854 | \n", "Department of Transportation | \n", "Marion Maintenance Facility - Williamson County | \n", "Intersate 57 Milepost 46 | \n", "Marion | \n", "62959 | \n", "Williamson | \n", "12 | \n", "Mike Bost | \n", "117 | \n", "Severin Dave | \n", "... | \n", "In Progress | \n", "2019.0 | \n", "2019.0 | \n", "760.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Business | \n", "Business | \n", "NaN | \n", "
8855 | \n", "Department of Transportation | \n", "Roscoe Maintenance Storage Facility | \n", "9988 N. 2nd Street | \n", "Roscoe | \n", "61073 | \n", "Winnebago | \n", "16 | \n", "Adam Kinzinger | \n", "69 | \n", "Sosnowski Joe | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "1550.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "NaN | \n", "NaN | \n", "
8856 | \n", "Department of Transportation | \n", "Belvidere Maintenance Storage Facility - Boone... | \n", "9797 Illinois Rte. 76 | \n", "Belvidere | \n", "61008 | \n", "Boone | \n", "16 | \n", "Adam Kinzinger | \n", "69 | \n", "Sosnowski Joe | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "1500.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "NaN | \n", "NaN | \n", "
8857 | \n", "Department of Transportation | \n", "Belvidere Maintenance Storage Facility - Boone... | \n", "9797 Illinois Rte. 76 | \n", "Belvidere | \n", "61008 | \n", "Boone | \n", "16 | \n", "Adam Kinzinger | \n", "69 | \n", "Sosnowski Joe | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "432.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "NaN | \n", "NaN | \n", "
8858 | \n", "Department of Transportation | \n", "Belvidere Maintenance Storage Facility - Boone... | \n", "9797 Illinois Rte 76 | \n", "Belvidere | \n", "61008 | \n", "Boone | \n", "16 | \n", "Adam Kinzinger | \n", "69 | \n", "Sosnowski Joe | \n", "... | \n", "In Use | \n", "NaN | \n", "NaN | \n", "330.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "NaN | \n", "NaN | \n", "
8859 | \n", "Department of Transportation | \n", "Quincy Maintenance Storage Facility | \n", "800 Koch's Lane | \n", "Quincy | \n", "62305 | \n", "Adams | \n", "18 | \n", "Darin M. LaHood | \n", "94 | \n", "Frese Randy E. | \n", "... | \n", "In Use | \n", "NaN | \n", "1987.0 | \n", "130.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Storage | \n", "High Hazard | \n", "NaN | \n", "
8860 | \n", "Illinois Community College Board | \n", "Illinois Valley Community College - Oglesby | \n", "815 North Orlando Smith Avenue | \n", "Oglesby | \n", "61348 | \n", "LaSalle | \n", "16 | \n", "Adam Kinzinger | \n", "76 | \n", "Long Jerry Lee | \n", "... | \n", "In Use | \n", "1971.0 | \n", "1971.0 | \n", "49552.0 | \n", "1 | \n", "1 | \n", "0 | \n", "Education | \n", "Education | \n", "Not provided | \n", "
8861 | \n", "Department of Military Affairs | \n", "Peoria Army Aviation Support Facility | \n", "2323 S. Airport Rd | \n", "Peoria | \n", "61607 | \n", "Peoria | \n", "17 | \n", "Cheri Bustos | \n", "92 | \n", "Gordon-Booth Jehan | \n", "... | \n", "In Progress | \n", "NaN | \n", "2017.0 | \n", "288.0 | \n", "1 | \n", "0 | \n", "0 | \n", "Utiility & Miscellan | \n", "Utiility & Miscellan | \n", "NaN | \n", "
8862 rows × 22 columns
\n", "\n", " | Zip code | \n", "Congress Dist | \n", "Rep Dist | \n", "Senate Dist | \n", "Year Acquired | \n", "Year Constructed | \n", "Square Footage | \n", "Total Floors | \n", "Floors Above Grade | \n", "Floors Below Grade | \n", "
---|---|---|---|---|---|---|---|---|---|---|
count | \n", "8862.000000 | \n", "8862.000000 | \n", "8862.000000 | \n", "8862.000000 | \n", "8597.000000 | \n", "8573.000000 | \n", "8.805000e+03 | \n", "8862.000000 | \n", "8862.000000 | \n", "8862.000000 | \n", "
mean | \n", "61821.076845 | \n", "13.404085 | \n", "92.303318 | \n", "46.408599 | \n", "1972.243573 | \n", "1970.391928 | \n", "1.155032e+04 | \n", "1.636087 | \n", "1.449334 | \n", "0.161589 | \n", "
std | \n", "1095.203357 | \n", "4.037936 | \n", "23.568457 | \n", "11.781038 | \n", "27.549380 | \n", "29.326256 | \n", "3.828480e+04 | \n", "1.537603 | \n", "1.286898 | \n", "0.392717 | \n", "
min | \n", "1235.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1753.000000 | \n", "1753.000000 | \n", "9.000000e+00 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
25% | \n", "61105.000000 | \n", "12.000000 | \n", "79.000000 | \n", "40.000000 | \n", "1959.000000 | \n", "1957.000000 | \n", "2.400000e+02 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "
50% | \n", "62023.000000 | \n", "14.000000 | \n", "97.000000 | \n", "49.000000 | \n", "1976.000000 | \n", "1975.000000 | \n", "1.664000e+03 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "
75% | \n", "62650.000000 | \n", "16.000000 | \n", "110.000000 | \n", "55.000000 | \n", "1993.000000 | \n", "1991.000000 | \n", "6.528000e+03 | \n", "2.000000 | \n", "1.000000 | \n", "0.000000 | \n", "
max | \n", "68297.000000 | \n", "18.000000 | \n", "119.000000 | \n", "60.000000 | \n", "2019.000000 | \n", "2019.000000 | \n", "1.200000e+06 | \n", "31.000000 | \n", "30.000000 | \n", "4.000000 | \n", "