{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline\n", "plt.style.use('ggplot')\n", "import dateutil.parser" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Processing time with `pandas`\n", "\n", "We've touched a little bit on time so far - mostly how tragic it is to parse - but pandas can do some neat things with it once you figure out how it works.\n", "\n", "Let's open up some data from [the Census bureau](https://www.census.gov/econ/currentdata/datasets/) - we're going to use **New Home Sales**. The data is formatted... oddly, so I've done the importing and joining for you below." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | per_idx | \n", "cat_idx | \n", "dt_idx | \n", "et_idx | \n", "geo_idx | \n", "is_adj | \n", "val | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "1 | \n", "5 | \n", "0 | \n", "1 | \n", "0 | \n", "17200.0 | \n", "
1 | \n", "1 | \n", "1 | \n", "2 | \n", "0 | \n", "1 | \n", "0 | \n", "9.0 | \n", "
2 | \n", "1 | \n", "1 | \n", "3 | \n", "0 | \n", "1 | \n", "0 | \n", "11.0 | \n", "
3 | \n", "1 | \n", "1 | \n", "4 | \n", "0 | \n", "1 | \n", "0 | \n", "22.0 | \n", "
4 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "42.0 | \n", "
\n", " | cat_idx | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "
---|---|---|---|---|
0 | \n", "1 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "
1 | \n", "2 | \n", "ASOLD | \n", "Annual Rate for New Single-family Houses Sold | \n", "0 | \n", "
\n", " | per_idx | \n", "cat_idx | \n", "dt_idx | \n", "et_idx | \n", "geo_idx | \n", "is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "per_name | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "42.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-01-01 | \n", "
14 | \n", "2 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-02-01 | \n", "
\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "per_name | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
4 | \n", "0 | \n", "42.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-01-01 | \n", "
14 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-02-01 | \n", "
24 | \n", "0 | \n", "44.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-03-01 | \n", "
34 | \n", "0 | \n", "52.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-04-01 | \n", "
44 | \n", "0 | \n", "58.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-05-01 | \n", "
\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "per_name | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
4 | \n", "0 | \n", "42.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-01-01 | \n", "
14 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-02-01 | \n", "
24 | \n", "0 | \n", "44.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-03-01 | \n", "
\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "per_name | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1963-01-01 | \n", "0 | \n", "42.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-01-01 | \n", "
1963-02-01 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "1963-02-01 | \n", "
\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "
---|---|---|---|---|---|---|---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1963-01-01 | \n", "0 | \n", "42.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1963-02-01 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "
---|---|---|---|---|---|---|---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1963-03-01 | \n", "0 | \n", "44.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "
---|---|---|---|---|---|---|---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2010-01-01 | \n", "0 | \n", "24.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-02-01 | \n", "0 | \n", "27.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-03-01 | \n", "0 | \n", "36.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-04-01 | \n", "0 | \n", "41.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-05-01 | \n", "0 | \n", "26.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-06-01 | \n", "0 | \n", "28.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-07-01 | \n", "0 | \n", "26.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-08-01 | \n", "0 | \n", "23.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-09-01 | \n", "0 | \n", "25.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-10-01 | \n", "0 | \n", "23.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-11-01 | \n", "0 | \n", "20.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2010-12-01 | \n", "0 | \n", "23.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "
---|---|---|---|---|---|---|---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2001-01-01 | \n", "0 | \n", "72.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-02-01 | \n", "0 | \n", "85.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-03-01 | \n", "0 | \n", "94.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-04-01 | \n", "0 | \n", "84.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-05-01 | \n", "0 | \n", "80.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-06-01 | \n", "0 | \n", "79.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-07-01 | \n", "0 | \n", "76.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-08-01 | \n", "0 | \n", "74.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-09-01 | \n", "0 | \n", "66.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-10-01 | \n", "0 | \n", "66.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-11-01 | \n", "0 | \n", "67.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2001-12-01 | \n", "0 | \n", "66.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-01-01 | \n", "0 | \n", "66.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-02-01 | \n", "0 | \n", "84.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-03-01 | \n", "0 | \n", "90.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-04-01 | \n", "0 | \n", "86.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-05-01 | \n", "0 | \n", "88.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-06-01 | \n", "0 | \n", "84.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-07-01 | \n", "0 | \n", "82.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-08-01 | \n", "0 | \n", "90.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-09-01 | \n", "0 | \n", "82.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-10-01 | \n", "0 | \n", "77.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-11-01 | \n", "0 | \n", "73.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2002-12-01 | \n", "0 | \n", "70.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2003-01-01 | \n", "0 | \n", "76.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2003-02-01 | \n", "0 | \n", "82.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2003-03-01 | \n", "0 | \n", "98.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2003-04-01 | \n", "0 | \n", "91.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2003-05-01 | \n", "0 | \n", "101.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2003-06-01 | \n", "0 | \n", "107.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2013-12-01 | \n", "0 | \n", "31.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-01-01 | \n", "0 | \n", "33.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-02-01 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-03-01 | \n", "0 | \n", "39.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-04-01 | \n", "0 | \n", "39.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-05-01 | \n", "0 | \n", "43.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-06-01 | \n", "0 | \n", "38.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-07-01 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-08-01 | \n", "0 | \n", "36.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-09-01 | \n", "0 | \n", "37.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-10-01 | \n", "0 | \n", "38.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-11-01 | \n", "0 | \n", "31.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2014-12-01 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-01-01 | \n", "0 | \n", "39.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-02-01 | \n", "0 | \n", "45.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-03-01 | \n", "0 | \n", "46.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-04-01 | \n", "0 | \n", "48.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-05-01 | \n", "0 | \n", "47.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-06-01 | \n", "0 | \n", "44.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-07-01 | \n", "0 | \n", "43.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-08-01 | \n", "0 | \n", "41.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-09-01 | \n", "0 | \n", "35.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-10-01 | \n", "0 | \n", "39.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-11-01 | \n", "0 | \n", "36.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2015-12-01 | \n", "0 | \n", "38.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2016-01-01 | \n", "0 | \n", "39.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2016-02-01 | \n", "0 | \n", "45.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2016-03-01 | \n", "0 | \n", "49.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2016-04-01 | \n", "0 | \n", "57.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
2016-05-01 | \n", "0 | \n", "51.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
185 rows × 10 columns
\n", "\n", " | is_adj | \n", "val | \n", "cat_code | \n", "cat_desc | \n", "cat_indent | \n", "dt_code | \n", "dt_desc | \n", "dt_unit | \n", "geo_code | \n", "geo_desc | \n", "
---|---|---|---|---|---|---|---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1990-06-01 | \n", "0 | \n", "50.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1990-07-01 | \n", "0 | \n", "46.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1990-08-01 | \n", "0 | \n", "46.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1990-09-01 | \n", "0 | \n", "38.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1990-10-01 | \n", "0 | \n", "37.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1990-11-01 | \n", "0 | \n", "34.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1990-12-01 | \n", "0 | \n", "29.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-01-01 | \n", "0 | \n", "30.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-02-01 | \n", "0 | \n", "40.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-03-01 | \n", "0 | \n", "51.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-04-01 | \n", "0 | \n", "50.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-05-01 | \n", "0 | \n", "47.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-06-01 | \n", "0 | \n", "47.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-07-01 | \n", "0 | \n", "43.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-08-01 | \n", "0 | \n", "46.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-09-01 | \n", "0 | \n", "37.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-10-01 | \n", "0 | \n", "41.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-11-01 | \n", "0 | \n", "39.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1991-12-01 | \n", "0 | \n", "36.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-01-01 | \n", "0 | \n", "48.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-02-01 | \n", "0 | \n", "55.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-03-01 | \n", "0 | \n", "56.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-04-01 | \n", "0 | \n", "53.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-05-01 | \n", "0 | \n", "52.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-06-01 | \n", "0 | \n", "53.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-07-01 | \n", "0 | \n", "52.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-08-01 | \n", "0 | \n", "56.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-09-01 | \n", "0 | \n", "51.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-10-01 | \n", "0 | \n", "48.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-11-01 | \n", "0 | \n", "42.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1992-12-01 | \n", "0 | \n", "42.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-01-01 | \n", "0 | \n", "44.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-02-01 | \n", "0 | \n", "50.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-03-01 | \n", "0 | \n", "60.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-04-01 | \n", "0 | \n", "66.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-05-01 | \n", "0 | \n", "58.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-06-01 | \n", "0 | \n", "59.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-07-01 | \n", "0 | \n", "55.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-08-01 | \n", "0 | \n", "57.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-09-01 | \n", "0 | \n", "57.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-10-01 | \n", "0 | \n", "56.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-11-01 | \n", "0 | \n", "53.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1993-12-01 | \n", "0 | \n", "51.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-01-01 | \n", "0 | \n", "46.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-02-01 | \n", "0 | \n", "58.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-03-01 | \n", "0 | \n", "74.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-04-01 | \n", "0 | \n", "65.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-05-01 | \n", "0 | \n", "65.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-06-01 | \n", "0 | \n", "55.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-07-01 | \n", "0 | \n", "52.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-08-01 | \n", "0 | \n", "59.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-09-01 | \n", "0 | \n", "54.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-10-01 | \n", "0 | \n", "57.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-11-01 | \n", "0 | \n", "45.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1994-12-01 | \n", "0 | \n", "40.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1995-01-01 | \n", "0 | \n", "47.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1995-02-01 | \n", "0 | \n", "47.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
1995-03-01 | \n", "0 | \n", "60.0 | \n", "SOLD | \n", "New Single-family Houses Sold | \n", "0 | \n", "TOTAL | \n", "All Houses | \n", "K | \n", "US | \n", "United States | \n", "
\n", " | cat_indent | \n", "is_adj | \n", "val | \n", "
---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " |
1963-12-31 | \n", "0 | \n", "0 | \n", "46.0 | \n", "
1964-12-31 | \n", "0 | \n", "0 | \n", "48.5 | \n", "
1965-12-31 | \n", "0 | \n", "0 | \n", "48.5 | \n", "
1966-12-31 | \n", "0 | \n", "0 | \n", "40.0 | \n", "
1967-12-31 | \n", "0 | \n", "0 | \n", "43.5 | \n", "
1968-12-31 | \n", "0 | \n", "0 | \n", "42.0 | \n", "
1969-12-31 | \n", "0 | \n", "0 | \n", "39.5 | \n", "
1970-12-31 | \n", "0 | \n", "0 | \n", "42.5 | \n", "
1971-12-31 | \n", "0 | \n", "0 | \n", "55.0 | \n", "
1972-12-31 | \n", "0 | \n", "0 | \n", "62.0 | \n", "
1973-12-31 | \n", "0 | \n", "0 | \n", "54.5 | \n", "
1974-12-31 | \n", "0 | \n", "0 | \n", "44.5 | \n", "
1975-12-31 | \n", "0 | \n", "0 | \n", "46.0 | \n", "
1976-12-31 | \n", "0 | \n", "0 | \n", "55.0 | \n", "
1977-12-31 | \n", "0 | \n", "0 | \n", "69.5 | \n", "
1978-12-31 | \n", "0 | \n", "0 | \n", "69.0 | \n", "
1979-12-31 | \n", "0 | \n", "0 | \n", "61.5 | \n", "
1980-12-31 | \n", "0 | \n", "0 | \n", "44.0 | \n", "
1981-12-31 | \n", "0 | \n", "0 | \n", "36.5 | \n", "
1982-12-31 | \n", "0 | \n", "0 | \n", "35.0 | \n", "
1983-12-31 | \n", "0 | \n", "0 | \n", "50.5 | \n", "
1984-12-31 | \n", "0 | \n", "0 | \n", "54.0 | \n", "
1985-12-31 | \n", "0 | \n", "0 | \n", "57.5 | \n", "
1986-12-31 | \n", "0 | \n", "0 | \n", "58.0 | \n", "
1987-12-31 | \n", "0 | \n", "0 | \n", "55.5 | \n", "
1988-12-31 | \n", "0 | \n", "0 | \n", "57.0 | \n", "
1989-12-31 | \n", "0 | \n", "0 | \n", "55.0 | \n", "
1990-12-31 | \n", "0 | \n", "0 | \n", "46.0 | \n", "
1991-12-31 | \n", "0 | \n", "0 | \n", "42.0 | \n", "
1992-12-31 | \n", "0 | \n", "0 | \n", "52.0 | \n", "
1993-12-31 | \n", "0 | \n", "0 | \n", "56.5 | \n", "
1994-12-31 | \n", "0 | \n", "0 | \n", "56.0 | \n", "
1995-12-31 | \n", "0 | \n", "0 | \n", "56.0 | \n", "
1996-12-31 | \n", "0 | \n", "0 | \n", "65.5 | \n", "
1997-12-31 | \n", "0 | \n", "0 | \n", "69.0 | \n", "
1998-12-31 | \n", "0 | \n", "0 | \n", "75.0 | \n", "
1999-12-31 | \n", "0 | \n", "0 | \n", "77.0 | \n", "
2000-12-31 | \n", "0 | \n", "0 | \n", "72.0 | \n", "
2001-12-31 | \n", "0 | \n", "0 | \n", "75.0 | \n", "
2002-12-31 | \n", "0 | \n", "0 | \n", "83.0 | \n", "
2003-12-31 | \n", "0 | \n", "0 | \n", "90.5 | \n", "
2004-12-31 | \n", "0 | \n", "0 | \n", "101.5 | \n", "
2005-12-31 | \n", "0 | \n", "0 | \n", "109.5 | \n", "
2006-12-31 | \n", "0 | \n", "0 | \n", "88.0 | \n", "
2007-12-31 | \n", "0 | \n", "0 | \n", "67.0 | \n", "
2008-12-31 | \n", "0 | \n", "0 | \n", "43.5 | \n", "
2009-12-31 | \n", "0 | \n", "0 | \n", "31.5 | \n", "
2010-12-31 | \n", "0 | \n", "0 | \n", "25.5 | \n", "
2011-12-31 | \n", "0 | \n", "0 | \n", "25.0 | \n", "
2012-12-31 | \n", "0 | \n", "0 | \n", "30.5 | \n", "
2013-12-31 | \n", "0 | \n", "0 | \n", "34.5 | \n", "
2014-12-31 | \n", "0 | \n", "0 | \n", "36.5 | \n", "
2015-12-31 | \n", "0 | \n", "0 | \n", "42.0 | \n", "
2016-12-31 | \n", "0 | \n", "0 | \n", "49.0 | \n", "
\n", " | cat_indent | \n", "is_adj | \n", "val | \n", "
---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " |
1963-12-31 | \n", "0 | \n", "0 | \n", "46.0 | \n", "
1968-12-31 | \n", "0 | \n", "0 | \n", "44.0 | \n", "
1973-12-31 | \n", "0 | \n", "0 | \n", "47.5 | \n", "
1978-12-31 | \n", "0 | \n", "0 | \n", "55.0 | \n", "
1983-12-31 | \n", "0 | \n", "0 | \n", "44.0 | \n", "
1988-12-31 | \n", "0 | \n", "0 | \n", "56.5 | \n", "
1993-12-31 | \n", "0 | \n", "0 | \n", "50.5 | \n", "
1998-12-31 | \n", "0 | \n", "0 | \n", "64.0 | \n", "
2003-12-31 | \n", "0 | \n", "0 | \n", "78.0 | \n", "
2008-12-31 | \n", "0 | \n", "0 | \n", "83.5 | \n", "
2013-12-31 | \n", "0 | \n", "0 | \n", "30.0 | \n", "
2018-12-31 | \n", "0 | \n", "0 | \n", "39.0 | \n", "
\n", " | cat_indent | \n", "is_adj | \n", "val | \n", "
---|---|---|---|
per_name | \n", "\n", " | \n", " | \n", " |
1963-12-31 | \n", "0 | \n", "0 | \n", "46.0 | \n", "
1964-12-31 | \n", "0 | \n", "0 | \n", "48.5 | \n", "
1965-12-31 | \n", "0 | \n", "0 | \n", "48.5 | \n", "
1966-12-31 | \n", "0 | \n", "0 | \n", "40.0 | \n", "
1967-12-31 | \n", "0 | \n", "0 | \n", "43.5 | \n", "
1968-12-31 | \n", "0 | \n", "0 | \n", "42.0 | \n", "
1969-12-31 | \n", "0 | \n", "0 | \n", "39.5 | \n", "
1970-12-31 | \n", "0 | \n", "0 | \n", "42.5 | \n", "
1971-12-31 | \n", "0 | \n", "0 | \n", "55.0 | \n", "
1972-12-31 | \n", "0 | \n", "0 | \n", "62.0 | \n", "
1973-12-31 | \n", "0 | \n", "0 | \n", "54.5 | \n", "
1974-12-31 | \n", "0 | \n", "0 | \n", "44.5 | \n", "
1975-12-31 | \n", "0 | \n", "0 | \n", "46.0 | \n", "
1976-12-31 | \n", "0 | \n", "0 | \n", "55.0 | \n", "
1977-12-31 | \n", "0 | \n", "0 | \n", "69.5 | \n", "
1978-12-31 | \n", "0 | \n", "0 | \n", "69.0 | \n", "
1979-12-31 | \n", "0 | \n", "0 | \n", "61.5 | \n", "
1980-12-31 | \n", "0 | \n", "0 | \n", "44.0 | \n", "
1981-12-31 | \n", "0 | \n", "0 | \n", "36.5 | \n", "
1982-12-31 | \n", "0 | \n", "0 | \n", "35.0 | \n", "
1983-12-31 | \n", "0 | \n", "0 | \n", "50.5 | \n", "
1984-12-31 | \n", "0 | \n", "0 | \n", "54.0 | \n", "
1985-12-31 | \n", "0 | \n", "0 | \n", "57.5 | \n", "
1986-12-31 | \n", "0 | \n", "0 | \n", "58.0 | \n", "
1987-12-31 | \n", "0 | \n", "0 | \n", "55.5 | \n", "
1988-12-31 | \n", "0 | \n", "0 | \n", "57.0 | \n", "
1989-12-31 | \n", "0 | \n", "0 | \n", "55.0 | \n", "
1990-12-31 | \n", "0 | \n", "0 | \n", "46.0 | \n", "
1991-12-31 | \n", "0 | \n", "0 | \n", "42.0 | \n", "
1992-12-31 | \n", "0 | \n", "0 | \n", "52.0 | \n", "
1993-12-31 | \n", "0 | \n", "0 | \n", "56.5 | \n", "
1994-12-31 | \n", "0 | \n", "0 | \n", "56.0 | \n", "
1995-12-31 | \n", "0 | \n", "0 | \n", "56.0 | \n", "
1996-12-31 | \n", "0 | \n", "0 | \n", "65.5 | \n", "
1997-12-31 | \n", "0 | \n", "0 | \n", "69.0 | \n", "
1998-12-31 | \n", "0 | \n", "0 | \n", "75.0 | \n", "
1999-12-31 | \n", "0 | \n", "0 | \n", "77.0 | \n", "
2000-12-31 | \n", "0 | \n", "0 | \n", "72.0 | \n", "
2001-12-31 | \n", "0 | \n", "0 | \n", "75.0 | \n", "
2002-12-31 | \n", "0 | \n", "0 | \n", "83.0 | \n", "
2003-12-31 | \n", "0 | \n", "0 | \n", "90.5 | \n", "
2004-12-31 | \n", "0 | \n", "0 | \n", "101.5 | \n", "
2005-12-31 | \n", "0 | \n", "0 | \n", "109.5 | \n", "
2006-12-31 | \n", "0 | \n", "0 | \n", "88.0 | \n", "
2007-12-31 | \n", "0 | \n", "0 | \n", "67.0 | \n", "
2008-12-31 | \n", "0 | \n", "0 | \n", "43.5 | \n", "
2009-12-31 | \n", "0 | \n", "0 | \n", "31.5 | \n", "
2010-12-31 | \n", "0 | \n", "0 | \n", "25.5 | \n", "
2011-12-31 | \n", "0 | \n", "0 | \n", "25.0 | \n", "
2012-12-31 | \n", "0 | \n", "0 | \n", "30.5 | \n", "
2013-12-31 | \n", "0 | \n", "0 | \n", "34.5 | \n", "
2014-12-31 | \n", "0 | \n", "0 | \n", "36.5 | \n", "
2015-12-31 | \n", "0 | \n", "0 | \n", "42.0 | \n", "
2016-12-31 | \n", "0 | \n", "0 | \n", "49.0 | \n", "
\n", " | is_adj | \n", "val | \n", "cat_indent | \n", "
---|---|---|---|
1 | \n", "0 | \n", "44.5 | \n", "0 | \n", "
2 | \n", "0 | \n", "50.0 | \n", "0 | \n", "
3 | \n", "0 | \n", "58.0 | \n", "0 | \n", "
4 | \n", "0 | \n", "59.5 | \n", "0 | \n", "
5 | \n", "0 | \n", "58.0 | \n", "0 | \n", "
6 | \n", "0 | \n", "58.0 | \n", "0 | \n", "
7 | \n", "0 | \n", "55.0 | \n", "0 | \n", "
8 | \n", "0 | \n", "56.0 | \n", "0 | \n", "
9 | \n", "0 | \n", "50.0 | \n", "0 | \n", "
10 | \n", "0 | \n", "51.0 | \n", "0 | \n", "
11 | \n", "0 | \n", "43.0 | \n", "0 | \n", "
12 | \n", "0 | \n", "39.0 | \n", "0 | \n", "