docs/book/content/examples/PSL_demo.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Demo of CCC for PSL Meetup\n",
    "\n",
    "This notebook provides a demonstration of the Cost-of-Capital-Calculator (CCC) for the PSL Meetup on April 29, 2019.\n",
    "\n",
    "To run this notebook on your machine, you will need to follow the instructions to install CCC as described in the CCC README [here](https://github.com/PSLmodels/Cost-of-Capital-Calculator).  In particular, you need to:\n",
    "\n",
    "* Install the [Anaconda distribution](https://www.anaconda.com/distribution/) of Python\n",
    "* Install the CCC package by typing `conda install -c conda-forge ccc` (or `pip install cost-of-captial-calculator`) in the command prompt.\n",
    "\n",
    "Once you follow the above, you will be ready to work with this Jupyter Notebook.\n",
    "\n",
    "## First things first, import necessary packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# To install ccc package (if not already):\n",
    "import sys\n",
    "if 'ccc' not in sys.modules:\n",
    "    !pip install cost-of-capital-calculator"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "    <style>\n",
       "        .bk-notebook-logo {\n",
       "            display: block;\n",
       "            width: 20px;\n",
       "            height: 20px;\n",
       "            background-image: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAABx0RVh0U29mdHdhcmUAQWRvYmUgRmlyZXdvcmtzIENTNui8sowAAAOkSURBVDiNjZRtaJVlGMd/1/08zzln5zjP1LWcU9N0NkN8m2CYjpgQYQXqSs0I84OLIC0hkEKoPtiH3gmKoiJDU7QpLgoLjLIQCpEsNJ1vqUOdO7ppbuec5+V+rj4ctwzd8IIbbi6u+8f1539dt3A78eXC7QizUF7gyV1fD1Yqg4JWz84yffhm0qkFqBogB9rM8tZdtwVsPUhWhGcFJngGeWrPzHm5oaMmkfEg1usvLFyc8jLRqDOMru7AyC8saQr7GG7f5fvDeH7Ej8CM66nIF+8yngt6HWaKh7k49Soy9nXurCi1o3qUbS3zWfrYeQDTB/Qj6kX6Ybhw4B+bOYoLKCC9H3Nu/leUTZ1JdRWkkn2ldcCamzrcf47KKXdAJllSlxAOkRgyHsGC/zRday5Qld9DyoM4/q/rUoy/CXh3jzOu3bHUVZeU+DEn8FInkPBFlu3+nW3Nw0mk6vCDiWg8CeJaxEwuHS3+z5RgY+YBR6V1Z1nxSOfoaPa4LASWxxdNp+VWTk7+4vzaou8v8PN+xo+KY2xsw6une2frhw05CTYOmQvsEhjhWjn0bmXPjpE1+kplmmkP3suftwTubK9Vq22qKmrBhpY4jvd5afdRA3wGjFAgcnTK2s4hY0/GPNIb0nErGMCRxWOOX64Z8RAC4oCXdklmEvcL8o0BfkNK4lUg9HTl+oPlQxdNo3Mg4Nv175e/1LDGzZen30MEjRUtmXSfiTVu1kK8W4txyV6BMKlbgk3lMwYCiusNy9fVfvvwMxv8Ynl6vxoByANLTWplvuj/nF9m2+PDtt1eiHPBr1oIfhCChQMBw6Aw0UulqTKZdfVvfG7VcfIqLG9bcldL/+pdWTLxLUy8Qq38heUIjh4XlzZxzQm19lLFlr8vdQ97rjZVOLf8nclzckbcD4wxXMidpX30sFd37Fv/GtwwhzhxGVAprjbg0gCAEeIgwCZyTV2Z1REEW8O4py0wsjeloKoMr6iCY6dP92H6Vw/oTyICIthibxjm/DfN9lVz8IqtqKYLUXfoKVMVQVVJOElGjrnnUt9T9wbgp8AyYKaGlqingHZU/uG2NTZSVqwHQTWkx9hxjkpWDaCg6Ckj5qebgBVbT3V3NNXMSiWSDdGV3hrtzla7J+duwPOToIg42ChPQOQjspnSlp1V+Gjdged7+8UN5CRAV7a5EdFNwCjEaBR27b3W890TE7g24NAP/mMDXRWrGoFPQI9ls/MWO2dWFAar/xcOIImbbpA3zgAAAABJRU5ErkJggg==);\n",
       "        }\n",
       "    </style>\n",
       "    <div>\n",
       "        <a href=\"https://bokeh.org\" target=\"_blank\" class=\"bk-notebook-logo\"></a>\n",
       "        <span id=\"de96cb22-398b-407f-b358-b6c4d9379778\">Loading BokehJS ...</span>\n",
       "    </div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function now() {\n    return new Date();\n  }\n\n  const force = true;\n\n  if (typeof root._bokeh_onload_callbacks === \"undefined\" || force === true) {\n    root._bokeh_onload_callbacks = [];\n    root._bokeh_is_loading = undefined;\n  }\n\nconst JS_MIME_TYPE = 'application/javascript';\n  const HTML_MIME_TYPE = 'text/html';\n  const EXEC_MIME_TYPE = 'application/vnd.bokehjs_exec.v0+json';\n  const CLASS_NAME = 'output_bokeh rendered_html';\n\n  /**\n   * Render data to the DOM node\n   */\n  function render(props, node) {\n    const script = document.createElement(\"script\");\n    node.appendChild(script);\n  }\n\n  /**\n   * Handle when an output is cleared or removed\n   */\n  function handleClearOutput(event, handle) {\n    function drop(id) {\n      const view = Bokeh.index.get_by_id(id)\n      if (view != null) {\n        view.model.document.clear()\n        Bokeh.index.delete(view)\n      }\n    }\n\n    const cell = handle.cell;\n\n    const id = cell.output_area._bokeh_element_id;\n    const server_id = cell.output_area._bokeh_server_id;\n\n    // Clean up Bokeh references\n    if (id != null) {\n      drop(id)\n    }\n\n    if (server_id !== undefined) {\n      // Clean up Bokeh references\n      const cmd_clean = \"from bokeh.io.state import curstate; print(curstate().uuid_to_server['\" + server_id + \"'].get_sessions()[0].document.roots[0]._id)\";\n      cell.notebook.kernel.execute(cmd_clean, {\n        iopub: {\n          output: function(msg) {\n            const id = msg.content.text.trim()\n            drop(id)\n          }\n        }\n      });\n      // Destroy server and session\n      const cmd_destroy = \"import bokeh.io.notebook as ion; ion.destroy_server('\" + server_id + \"')\";\n      cell.notebook.kernel.execute(cmd_destroy);\n    }\n  }\n\n  /**\n   * Handle when a new output is added\n   */\n  function handleAddOutput(event, handle) {\n    const output_area = handle.output_area;\n    const output = handle.output;\n\n    // limit handleAddOutput to display_data with EXEC_MIME_TYPE content only\n    if ((output.output_type != \"display_data\") || (!Object.prototype.hasOwnProperty.call(output.data, EXEC_MIME_TYPE))) {\n      return\n    }\n\n    const toinsert = output_area.element.find(\".\" + CLASS_NAME.split(' ')[0]);\n\n    if (output.metadata[EXEC_MIME_TYPE][\"id\"] !== undefined) {\n      toinsert[toinsert.length - 1].firstChild.textContent = output.data[JS_MIME_TYPE];\n      // store reference to embed id on output_area\n      output_area._bokeh_element_id = output.metadata[EXEC_MIME_TYPE][\"id\"];\n    }\n    if (output.metadata[EXEC_MIME_TYPE][\"server_id\"] !== undefined) {\n      const bk_div = document.createElement(\"div\");\n      bk_div.innerHTML = output.data[HTML_MIME_TYPE];\n      const script_attrs = bk_div.children[0].attributes;\n      for (let i = 0; i < script_attrs.length; i++) {\n        toinsert[toinsert.length - 1].firstChild.setAttribute(script_attrs[i].name, script_attrs[i].value);\n        toinsert[toinsert.length - 1].firstChild.textContent = bk_div.children[0].textContent\n      }\n      // store reference to server id on output_area\n      output_area._bokeh_server_id = output.metadata[EXEC_MIME_TYPE][\"server_id\"];\n    }\n  }\n\n  function register_renderer(events, OutputArea) {\n\n    function append_mime(data, metadata, element) {\n      // create a DOM node to render to\n      const toinsert = this.create_output_subarea(\n        metadata,\n        CLASS_NAME,\n        EXEC_MIME_TYPE\n      );\n      this.keyboard_manager.register_events(toinsert);\n      // Render to node\n      const props = {data: data, metadata: metadata[EXEC_MIME_TYPE]};\n      render(props, toinsert[toinsert.length - 1]);\n      element.append(toinsert);\n      return toinsert\n    }\n\n    /* Handle when an output is cleared or removed */\n    events.on('clear_output.CodeCell', handleClearOutput);\n    events.on('delete.Cell', handleClearOutput);\n\n    /* Handle when a new output is added */\n    events.on('output_added.OutputArea', handleAddOutput);\n\n    /**\n     * Register the mime type and append_mime function with output_area\n     */\n    OutputArea.prototype.register_mime_type(EXEC_MIME_TYPE, append_mime, {\n      /* Is output safe? */\n      safe: true,\n      /* Index of renderer in `output_area.display_order` */\n      index: 0\n    });\n  }\n\n  // register the mime type if in Jupyter Notebook environment and previously unregistered\n  if (root.Jupyter !== undefined) {\n    const events = require('base/js/events');\n    const OutputArea = require('notebook/js/outputarea').OutputArea;\n\n    if (OutputArea.prototype.mime_types().indexOf(EXEC_MIME_TYPE) == -1) {\n      register_renderer(events, OutputArea);\n    }\n  }\n  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n    root._bokeh_timeout = Date.now() + 5000;\n    root._bokeh_failed_load = false;\n  }\n\n  const NB_LOAD_WARNING = {'data': {'text/html':\n     \"<div style='background-color: #fdd'>\\n\"+\n     \"<p>\\n\"+\n     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n     \"</p>\\n\"+\n     \"<ul>\\n\"+\n     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n     \"</ul>\\n\"+\n     \"<code>\\n\"+\n     \"from bokeh.resources import INLINE\\n\"+\n     \"output_notebook(resources=INLINE)\\n\"+\n     \"</code>\\n\"+\n     \"</div>\"}};\n\n  function display_loaded() {\n    const el = document.getElementById(\"de96cb22-398b-407f-b358-b6c4d9379778\");\n    if (el != null) {\n      el.textContent = \"BokehJS is loading...\";\n    }\n    if (root.Bokeh !== undefined) {\n      if (el != null) {\n        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n      }\n    } else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(display_loaded, 100)\n    }\n  }\n\n  function run_callbacks() {\n    try {\n      root._bokeh_onload_callbacks.forEach(function(callback) {\n        if (callback != null)\n          callback();\n      });\n    } finally {\n      delete root._bokeh_onload_callbacks\n    }\n    console.debug(\"Bokeh: all callbacks have finished\");\n  }\n\n  function load_libs(css_urls, js_urls, callback) {\n    if (css_urls == null) css_urls = [];\n    if (js_urls == null) js_urls = [];\n\n    root._bokeh_onload_callbacks.push(callback);\n    if (root._bokeh_is_loading > 0) {\n      console.debug(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n      return null;\n    }\n    if (js_urls == null || js_urls.length === 0) {\n      run_callbacks();\n      return null;\n    }\n    console.debug(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n    root._bokeh_is_loading = css_urls.length + js_urls.length;\n\n    function on_load() {\n      root._bokeh_is_loading--;\n      if (root._bokeh_is_loading === 0) {\n        console.debug(\"Bokeh: all BokehJS libraries/stylesheets loaded\");\n        run_callbacks()\n      }\n    }\n\n    function on_error(url) {\n      console.error(\"failed to load \" + url);\n    }\n\n    for (let i = 0; i < css_urls.length; i++) {\n      const url = css_urls[i];\n      const element = document.createElement(\"link\");\n      element.onload = on_load;\n      element.onerror = on_error.bind(null, url);\n      element.rel = \"stylesheet\";\n      element.type = \"text/css\";\n      element.href = url;\n      console.debug(\"Bokeh: injecting link tag for BokehJS stylesheet: \", url);\n      document.body.appendChild(element);\n    }\n\n    for (let i = 0; i < js_urls.length; i++) {\n      const url = js_urls[i];\n      const element = document.createElement('script');\n      element.onload = on_load;\n      element.onerror = on_error.bind(null, url);\n      element.async = false;\n      element.src = url;\n      console.debug(\"Bokeh: injecting script tag for BokehJS library: \", url);\n      document.head.appendChild(element);\n    }\n  };\n\n  function inject_raw_css(css) {\n    const element = document.createElement(\"style\");\n    element.appendChild(document.createTextNode(css));\n    document.body.appendChild(element);\n  }\n\n  const js_urls = [\"https://cdn.bokeh.org/bokeh/release/bokeh-3.3.4.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-gl-3.3.4.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-3.3.4.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-3.3.4.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-mathjax-3.3.4.min.js\"];\n  const css_urls = [];\n\n  const inline_js = [    function(Bokeh) {\n      Bokeh.set_log_level(\"info\");\n    },\nfunction(Bokeh) {\n    }\n  ];\n\n  function run_inline_js() {\n    if (root.Bokeh !== undefined || force === true) {\n          for (let i = 0; i < inline_js.length; i++) {\n      inline_js[i].call(root, root.Bokeh);\n    }\nif (force === true) {\n        display_loaded();\n      }} else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(run_inline_js, 100);\n    } else if (!root._bokeh_failed_load) {\n      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n      root._bokeh_failed_load = true;\n    } else if (force !== true) {\n      const cell = $(document.getElementById(\"de96cb22-398b-407f-b358-b6c4d9379778\")).parents('.cell').data().cell;\n      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n    }\n  }\n\n  if (root._bokeh_is_loading === 0) {\n    console.debug(\"Bokeh: BokehJS loaded, going straight to plotting\");\n    run_inline_js();\n  } else {\n    load_libs(css_urls, js_urls, function() {\n      console.debug(\"Bokeh: BokehJS plotting callback run at\", now());\n      run_inline_js();\n    });\n  }\n}(window));",
      "application/vnd.bokehjs_load.v0+json": ""
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# import packages\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from bokeh.plotting import figure, show\n",
    "from bokeh.io import output_notebook\n",
    "# import CCC classes that we'll work with\n",
    "from ccc.data import Assets\n",
    "from ccc.parameters import Specification, DepreciationParams\n",
    "from ccc.calculator import Calculator\n",
    "# to print bokeh plots inline\n",
    "output_notebook()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create an instance of the Assets class\n",
    "\n",
    "This is the class that contains the data that underlie CCC.  The basic object is a Pandas DataFrame where each row represents a combination of a specific type of asset, industry (approximately 6-digit NAICS) and tax treatment.  The columns represent names and codes for the asset and industry classifications, the tax depreciation rules used for that asset, and the rate of economic depreciation (`delta`)."
   ]
  },
  {
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>tax_treat</th>\n",
       "      <th>assets</th>\n",
       "      <th>bea_asset_code</th>\n",
       "      <th>bea_ind_code</th>\n",
       "      <th>Industry</th>\n",
       "      <th>minor_code_alt</th>\n",
       "      <th>major_asset_group</th>\n",
       "      <th>minor_asset_group</th>\n",
       "      <th>major_industry</th>\n",
       "      <th>asset_name</th>\n",
       "      <th>delta</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>corporate</td>\n",
       "      <td>0.0</td>\n",
       "      <td>RD32</td>\n",
       "      <td>110C</td>\n",
       "      <td>Farms</td>\n",
       "      <td>111</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Agriculture, forestry, fishing, and hunting</td>\n",
       "      <td>Aerospace products and parts manufacturing</td>\n",
       "      <td>0.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>corporate</td>\n",
       "      <td>0.0</td>\n",
       "      <td>RD32</td>\n",
       "      <td>113F</td>\n",
       "      <td>Forestry, fishing, and related activities</td>\n",
       "      <td>113</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Agriculture, forestry, fishing, and hunting</td>\n",
       "      <td>Aerospace products and parts manufacturing</td>\n",
       "      <td>0.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>corporate</td>\n",
       "      <td>0.0</td>\n",
       "      <td>RD32</td>\n",
       "      <td>113F</td>\n",
       "      <td>Forestry, fishing, and related activities</td>\n",
       "      <td>114</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Agriculture, forestry, fishing, and hunting</td>\n",
       "      <td>Aerospace products and parts manufacturing</td>\n",
       "      <td>0.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>corporate</td>\n",
       "      <td>0.0</td>\n",
       "      <td>RD32</td>\n",
       "      <td>2110</td>\n",
       "      <td>Oil and gas extraction</td>\n",
       "      <td>211110</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Mining</td>\n",
       "      <td>Aerospace products and parts manufacturing</td>\n",
       "      <td>0.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>corporate</td>\n",
       "      <td>0.0</td>\n",
       "      <td>RD32</td>\n",
       "      <td>2120</td>\n",
       "      <td>Mining, except oil and gas</td>\n",
       "      <td>212110</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>Mining</td>\n",
       "      <td>Aerospace products and parts manufacturing</td>\n",
       "      <td>0.22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  tax_treat  assets bea_asset_code bea_ind_code  \\\n",
       "0           0  corporate     0.0           RD32         110C   \n",
       "1           1  corporate     0.0           RD32         113F   \n",
       "2           2  corporate     0.0           RD32         113F   \n",
       "3           3  corporate     0.0           RD32         2110   \n",
       "4           4  corporate     0.0           RD32         2120   \n",
       "\n",
       "                                    Industry  minor_code_alt  \\\n",
       "0                                      Farms             111   \n",
       "1  Forestry, fishing, and related activities             113   \n",
       "2  Forestry, fishing, and related activities             114   \n",
       "3                     Oil and gas extraction          211110   \n",
       "4                 Mining, except oil and gas          212110   \n",
       "\n",
       "       major_asset_group      minor_asset_group  \\\n",
       "0  Intellectual Property  Intellectual Property   \n",
       "1  Intellectual Property  Intellectual Property   \n",
       "2  Intellectual Property  Intellectual Property   \n",
       "3  Intellectual Property  Intellectual Property   \n",
       "4  Intellectual Property  Intellectual Property   \n",
       "\n",
       "                                major_industry  \\\n",
       "0  Agriculture, forestry, fishing, and hunting   \n",
       "1  Agriculture, forestry, fishing, and hunting   \n",
       "2  Agriculture, forestry, fishing, and hunting   \n",
       "3                                       Mining   \n",
       "4                                       Mining   \n",
       "\n",
       "                                   asset_name  delta  \n",
       "0  Aerospace products and parts manufacturing   0.22  \n",
       "1  Aerospace products and parts manufacturing   0.22  \n",
       "2  Aerospace products and parts manufacturing   0.22  \n",
       "3  Aerospace products and parts manufacturing   0.22  \n",
       "4  Aerospace products and parts manufacturing   0.22  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "assets = Assets()\n",
    "assets.df.head(n=5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create instances of the two parameters classes\n",
    "\n",
    "The `Specification` class contains many of the model parameters, although depreciation system parameters are contained in the `DepreciationParams` class.  Both are required arguments for the `Calculator` object.\n",
    "\n",
    "A `Specification` object has methods that load the data from a file that contains the default parameter values (`default_parameters.json`) and then stores them as attributes of the `Specification` class object.  \n",
    "\n",
    "`p.u` looks into the instance of this class named `p` and executing the cell below will show you that `p.u` is dictionary containtin marginal tax rates on corporate and pass-through income.\n",
    "\n",
    "Note that the `Specification` class has some arguments, such as `call_tc`, which defaults to `False`, but if set to `True` will call the Tax-Calculator to estimate marginal tax rates on individual filers' income.\n",
    "\n",
    "Similar to `Specification`, `DepreciationParams` loads default parameters from a JSON file, in this case the file `tax_depreciation_rules.json`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Calculator initial year =  2014\n",
      "Calculator year =  2024\n",
      "year:  2024\n",
      "{'tau_pt': array([0.20147244]), 'tau_div': array([0.1723512]), 'tau_int': array([0.31217545]), 'tau_scg': array([0.28524757]), 'tau_lcg': array([0.184897]), 'tau_td': array([0.204116]), 'tau_h': array([0.03463544])}\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'c': array([0.21]), 'pt': array([0.20147244])}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create an instance of the Specification class\n",
    "# p = Specification()\n",
    "p = Specification(call_tc=True)\n",
    "# Look at attributes\n",
    "p.u"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OrderedDict([('value', {'life': 5.0, 'method': 'DB 200%'}),\n",
       "             ('asset_name', 'Mainframes'),\n",
       "             ('BEA_code', 'EP1A'),\n",
       "             ('minor_asset_group', 'Computers and Software'),\n",
       "             ('major_asset_group', 'Equipment'),\n",
       "             ('ADS_life', 5.0),\n",
       "             ('GDS_life', 5.0),\n",
       "             ('system', 'GDS'),\n",
       "             ('year', 2020)])"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create an instance of the DepreciationParams class\n",
    "dp = DepreciationParams()\n",
    "# Look at an attribute of the dp object\n",
    "dp.asset[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create an instance of the Calculator class\n",
    "\n",
    "This class does the calculations on the data.  It takes as arguments the data object (named `assets` here) and the parameters object (named `p` here).\n",
    "\n",
    "Excuting the cell below creates an instance of the calculator class with these data and parameters, but does not yet excecute any calculations."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create an instance of the Calculator class\n",
    "calc1 = Calculator(p, dp, assets)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "With an instance of the `Calculator` class created, we can start doing some calculations with these data.\n",
    "\n",
    "For instance, we can compute a table of the share of corporate vs non-corporate assets across each industry.    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Industry</th>\n",
       "      <th>Corporate</th>\n",
       "      <th>Pass-Through</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Agriculture, forestry, fishing, and hunting</td>\n",
       "      <td>0.309688</td>\n",
       "      <td>0.690312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mining</td>\n",
       "      <td>0.826839</td>\n",
       "      <td>0.173161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Utilities</td>\n",
       "      <td>0.948540</td>\n",
       "      <td>0.051460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Construction</td>\n",
       "      <td>0.286840</td>\n",
       "      <td>0.713160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>0.859014</td>\n",
       "      <td>0.140986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Wholesale trade</td>\n",
       "      <td>0.715166</td>\n",
       "      <td>0.284834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Retail trade</td>\n",
       "      <td>0.728628</td>\n",
       "      <td>0.271372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Transportation and warehousing</td>\n",
       "      <td>0.789652</td>\n",
       "      <td>0.210348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Information</td>\n",
       "      <td>0.918722</td>\n",
       "      <td>0.081278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Finance and insurance</td>\n",
       "      <td>0.786056</td>\n",
       "      <td>0.213944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Real estate and rental and leasing</td>\n",
       "      <td>0.212052</td>\n",
       "      <td>0.787948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Professional, scientific, and technical services</td>\n",
       "      <td>0.501699</td>\n",
       "      <td>0.498301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Management of companies and enterprises</td>\n",
       "      <td>0.824397</td>\n",
       "      <td>0.175603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Administrative and waste management services</td>\n",
       "      <td>0.569110</td>\n",
       "      <td>0.430890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Educational services</td>\n",
       "      <td>0.590168</td>\n",
       "      <td>0.409832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Health care and social assistance</td>\n",
       "      <td>0.510425</td>\n",
       "      <td>0.489575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Arts, entertainment, and recreation</td>\n",
       "      <td>0.490811</td>\n",
       "      <td>0.509189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Accommodation and food services</td>\n",
       "      <td>0.482236</td>\n",
       "      <td>0.517764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Other services, except government</td>\n",
       "      <td>0.343467</td>\n",
       "      <td>0.656533</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Industry  Corporate  Pass-Through\n",
       "0        Agriculture, forestry, fishing, and hunting   0.309688      0.690312\n",
       "1                                             Mining   0.826839      0.173161\n",
       "2                                          Utilities   0.948540      0.051460\n",
       "3                                       Construction   0.286840      0.713160\n",
       "4                                      Manufacturing   0.859014      0.140986\n",
       "5                                    Wholesale trade   0.715166      0.284834\n",
       "6                                       Retail trade   0.728628      0.271372\n",
       "7                     Transportation and warehousing   0.789652      0.210348\n",
       "8                                        Information   0.918722      0.081278\n",
       "9                              Finance and insurance   0.786056      0.213944\n",
       "10                Real estate and rental and leasing   0.212052      0.787948\n",
       "11  Professional, scientific, and technical services   0.501699      0.498301\n",
       "12           Management of companies and enterprises   0.824397      0.175603\n",
       "13      Administrative and waste management services   0.569110      0.430890\n",
       "14                              Educational services   0.590168      0.409832\n",
       "15                 Health care and social assistance   0.510425      0.489575\n",
       "16               Arts, entertainment, and recreation   0.490811      0.509189\n",
       "17                   Accommodation and food services   0.482236      0.517764\n",
       "18                 Other services, except government   0.343467      0.656533"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Look at shares of assets across industry\n",
    "calc1.asset_share_table()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Specifying a reform policy\n",
    "\n",
    "To see some more interesting results, we will want to create another `Calculator` object with a change in policy or economic assumptions.  We can do this in a way analogous to our original instantiation of the `Calculator` object above.  In particular, we'll need to create a new `Specification` object (we can use the same underlying data, which was in the object we named `assets`).\n",
    "\n",
    "In the code below, we'll specify our \"reform\" as current law tax policy for 2026 (the baseline parameters above came from the default model year, 2019).  In addition, we'll increase the corporate income tax rate from 21 to 25%."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create another policy\n",
    "p2 = Specification(year=2026)\n",
    "p2.update_specification({'CIT_rate': 0.35})\n",
    "calc2 = Calculator(p2, dp, assets)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tabular output\n",
    "\n",
    "Now with two `Calculator` objects named `calc1` and `calc2` (representing the baseline and reform policies), we are ready to compute some of the changes in effective tax rates, cost of capital, or other variables measured in this model.\n",
    "\n",
    "We start with an overall summary table showing the marginal effective total tax rates (METTRs) for all investments, corporate investments, and pass-through investments under varying financing assumptions.  This is done through the `summary_table` function.  It takes a calculator object as an argument."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Marginal Effective Total Tax Rate Under Baseline Policy</th>\n",
       "      <th>Marginal Effective Total Tax Rate Under Reform Policy</th>\n",
       "      <th>Change from Baseline (pp)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Overall</td>\n",
       "      <td>18.563352</td>\n",
       "      <td>24.710063</td>\n",
       "      <td>6.146711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Corporations</td>\n",
       "      <td>19.197626</td>\n",
       "      <td>27.536312</td>\n",
       "      <td>8.338686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Equity Financed</td>\n",
       "      <td>22.052902</td>\n",
       "      <td>34.270098</td>\n",
       "      <td>12.217196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Debt Financed</td>\n",
       "      <td>8.933048</td>\n",
       "      <td>-5.186307</td>\n",
       "      <td>-14.119355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pass-Through Entities</td>\n",
       "      <td>19.312399</td>\n",
       "      <td>22.497415</td>\n",
       "      <td>3.185016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Equity Financed</td>\n",
       "      <td>17.629037</td>\n",
       "      <td>22.436954</td>\n",
       "      <td>4.807917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Debt Financed</td>\n",
       "      <td>25.652332</td>\n",
       "      <td>22.875706</td>\n",
       "      <td>-2.776626</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          \\\n",
       "0                Overall   \n",
       "1           Corporations   \n",
       "2        Equity Financed   \n",
       "3          Debt Financed   \n",
       "4  Pass-Through Entities   \n",
       "5        Equity Financed   \n",
       "6          Debt Financed   \n",
       "\n",
       "   Marginal Effective Total Tax Rate Under Baseline Policy  \\\n",
       "0                                          18.563352         \n",
       "1                                          19.197626         \n",
       "2                                          22.052902         \n",
       "3                                           8.933048         \n",
       "4                                          19.312399         \n",
       "5                                          17.629037         \n",
       "6                                          25.652332         \n",
       "\n",
       "   Marginal Effective Total Tax Rate Under Reform Policy  \\\n",
       "0                                          24.710063       \n",
       "1                                          27.536312       \n",
       "2                                          34.270098       \n",
       "3                                          -5.186307       \n",
       "4                                          22.497415       \n",
       "5                                          22.436954       \n",
       "6                                          22.875706       \n",
       "\n",
       "   Change from Baseline (pp)  \n",
       "0                   6.146711  \n",
       "1                   8.338686  \n",
       "2                  12.217196  \n",
       "3                 -14.119355  \n",
       "4                   3.185016  \n",
       "5                   4.807917  \n",
       "6                  -2.776626  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Look at differences in METTRs between the two policies\n",
    "calc1.summary_table(calc2) # calc1 is the baseline, calc2 the reform"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "the `Calculator.summary_table()` method defaults to showing the results for the METTR, but there is a keyword argument that would allow you to view the output for other variables computed in CCC.  We can use this to see changes in the cost of capital (denoted by $\\rho$ in the model):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Cost of Capital Under Baseline Policy</th>\n",
       "      <th>Cost of Capital Under Reform Policy</th>\n",
       "      <th>Change from Baseline (pp)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Overall</td>\n",
       "      <td>5.777634</td>\n",
       "      <td>6.249323</td>\n",
       "      <td>0.471689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Corporations</td>\n",
       "      <td>5.822987</td>\n",
       "      <td>6.493061</td>\n",
       "      <td>0.670074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Equity Financed</td>\n",
       "      <td>6.719745</td>\n",
       "      <td>7.968742</td>\n",
       "      <td>1.248997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Debt Financed</td>\n",
       "      <td>3.923541</td>\n",
       "      <td>3.396877</td>\n",
       "      <td>-0.526664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pass-Through Entities</td>\n",
       "      <td>5.723574</td>\n",
       "      <td>5.958787</td>\n",
       "      <td>0.235214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Equity Financed</td>\n",
       "      <td>6.358851</td>\n",
       "      <td>6.753018</td>\n",
       "      <td>0.394167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Debt Financed</td>\n",
       "      <td>4.171191</td>\n",
       "      <td>4.021020</td>\n",
       "      <td>-0.150171</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Cost of Capital Under Baseline Policy  \\\n",
       "0                Overall                               5.777634   \n",
       "1           Corporations                               5.822987   \n",
       "2        Equity Financed                               6.719745   \n",
       "3          Debt Financed                               3.923541   \n",
       "4  Pass-Through Entities                               5.723574   \n",
       "5        Equity Financed                               6.358851   \n",
       "6          Debt Financed                               4.171191   \n",
       "\n",
       "   Cost of Capital Under Reform Policy  Change from Baseline (pp)  \n",
       "0                             6.249323                   0.471689  \n",
       "1                             6.493061                   0.670074  \n",
       "2                             7.968742                   1.248997  \n",
       "3                             3.396877                  -0.526664  \n",
       "4                             5.958787                   0.235214  \n",
       "5                             6.753018                   0.394167  \n",
       "6                             4.021020                  -0.150171  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Look at how the cost of capital changed\n",
    "calc1.summary_table(calc2, output_variable='rho')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "One can also save results to disk by specifying an output type ('excel', 'json', 'csv', 'tex') and a file path: "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "ename": "DeprecationWarning",
     "evalue": "datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mDeprecationWarning\u001b[0m                        Traceback (most recent call last)",
      "Cell \u001b[0;32mIn[14], line 2\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[38;5;66;03m# Save these results to disk\u001b[39;00m\n\u001b[0;32m----> 2\u001b[0m \u001b[43mcalc1\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43msummary_table\u001b[49m\u001b[43m(\u001b[49m\u001b[43mcalc2\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43moutput_variable\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mrho\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43moutput_type\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mexcel\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mpath\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mcc_table.xlsx\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/repos/CCC/ccc/calculator.py:526\u001b[0m, in \u001b[0;36mCalculator.summary_table\u001b[0;34m(self, calc, output_variable, include_land, include_inventories, output_type, path)\u001b[0m\n\u001b[1;32m    524\u001b[0m table_df[VAR_DICT[output_variable] \u001b[38;5;241m+\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124m Under Reform Policy\u001b[39m\u001b[38;5;124m\"\u001b[39m] \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m=\u001b[39m \u001b[38;5;241m100\u001b[39m\n\u001b[1;32m    525\u001b[0m table_df[\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mChange from Baseline (pp)\u001b[39m\u001b[38;5;124m\"\u001b[39m] \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m=\u001b[39m \u001b[38;5;241m100\u001b[39m\n\u001b[0;32m--> 526\u001b[0m table \u001b[38;5;241m=\u001b[39m \u001b[43msave_return_table\u001b[49m\u001b[43m(\u001b[49m\u001b[43mtable_df\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43moutput_type\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mpath\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    528\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m table\n",
      "File \u001b[0;32m~/repos/CCC/ccc/utils.py:264\u001b[0m, in \u001b[0;36msave_return_table\u001b[0;34m(table_df, output_type, path, precision)\u001b[0m\n\u001b[1;32m    262\u001b[0m         table_df\u001b[38;5;241m.\u001b[39mto_json(path_or_buf\u001b[38;5;241m=\u001b[39mpath, double_precision\u001b[38;5;241m=\u001b[39mprecision)\n\u001b[1;32m    263\u001b[0m     \u001b[38;5;28;01melif\u001b[39;00m output_type \u001b[38;5;241m==\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mexcel\u001b[39m\u001b[38;5;124m\"\u001b[39m:\n\u001b[0;32m--> 264\u001b[0m         \u001b[43mtable_df\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mto_excel\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m    265\u001b[0m \u001b[43m            \u001b[49m\u001b[43mexcel_writer\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mpath\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    266\u001b[0m \u001b[43m            \u001b[49m\u001b[43mindex\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43;01mFalse\u001b[39;49;00m\u001b[43m,\u001b[49m\n\u001b[1;32m    267\u001b[0m \u001b[43m            \u001b[49m\u001b[43mna_rep\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[43m,\u001b[49m\n\u001b[1;32m    268\u001b[0m \u001b[43m            \u001b[49m\u001b[43mfloat_format\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43m%\u001b[39;49m\u001b[38;5;124;43m.\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[43m \u001b[49m\u001b[38;5;241;43m+\u001b[39;49m\u001b[43m \u001b[49m\u001b[38;5;28;43mstr\u001b[39;49m\u001b[43m(\u001b[49m\u001b[43mprecision\u001b[49m\u001b[43m)\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m+\u001b[39;49m\u001b[43m \u001b[49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43m0f\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[43m,\u001b[49m\n\u001b[1;32m    269\u001b[0m \u001b[43m        \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    270\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m    271\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mPlease enter a valid output format\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/pandas/util/_decorators.py:333\u001b[0m, in \u001b[0;36mdeprecate_nonkeyword_arguments.<locals>.decorate.<locals>.wrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    327\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mlen\u001b[39m(args) \u001b[38;5;241m>\u001b[39m num_allow_args:\n\u001b[1;32m    328\u001b[0m     warnings\u001b[38;5;241m.\u001b[39mwarn(\n\u001b[1;32m    329\u001b[0m         msg\u001b[38;5;241m.\u001b[39mformat(arguments\u001b[38;5;241m=\u001b[39m_format_argument_list(allow_args)),\n\u001b[1;32m    330\u001b[0m         \u001b[38;5;167;01mFutureWarning\u001b[39;00m,\n\u001b[1;32m    331\u001b[0m         stacklevel\u001b[38;5;241m=\u001b[39mfind_stack_level(),\n\u001b[1;32m    332\u001b[0m     )\n\u001b[0;32m--> 333\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mfunc\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/pandas/core/generic.py:2414\u001b[0m, in \u001b[0;36mNDFrame.to_excel\u001b[0;34m(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, inf_rep, freeze_panes, storage_options, engine_kwargs)\u001b[0m\n\u001b[1;32m   2401\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mpandas\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mio\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mformats\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mexcel\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m ExcelFormatter\n\u001b[1;32m   2403\u001b[0m formatter \u001b[38;5;241m=\u001b[39m ExcelFormatter(\n\u001b[1;32m   2404\u001b[0m     df,\n\u001b[1;32m   2405\u001b[0m     na_rep\u001b[38;5;241m=\u001b[39mna_rep,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   2412\u001b[0m     inf_rep\u001b[38;5;241m=\u001b[39minf_rep,\n\u001b[1;32m   2413\u001b[0m )\n\u001b[0;32m-> 2414\u001b[0m \u001b[43mformatter\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mwrite\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   2415\u001b[0m \u001b[43m    \u001b[49m\u001b[43mexcel_writer\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2416\u001b[0m \u001b[43m    \u001b[49m\u001b[43msheet_name\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43msheet_name\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2417\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstartrow\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstartrow\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2418\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstartcol\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstartcol\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2419\u001b[0m \u001b[43m    \u001b[49m\u001b[43mfreeze_panes\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mfreeze_panes\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2420\u001b[0m \u001b[43m    \u001b[49m\u001b[43mengine\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2421\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstorage_options\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstorage_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2422\u001b[0m \u001b[43m    \u001b[49m\u001b[43mengine_kwargs\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine_kwargs\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2423\u001b[0m \u001b[43m\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/pandas/io/formats/excel.py:943\u001b[0m, in \u001b[0;36mExcelFormatter.write\u001b[0;34m(self, writer, sheet_name, startrow, startcol, freeze_panes, engine, storage_options, engine_kwargs)\u001b[0m\n\u001b[1;32m    941\u001b[0m     need_save \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mFalse\u001b[39;00m\n\u001b[1;32m    942\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[0;32m--> 943\u001b[0m     writer \u001b[38;5;241m=\u001b[39m \u001b[43mExcelWriter\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m    944\u001b[0m \u001b[43m        \u001b[49m\u001b[43mwriter\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    945\u001b[0m \u001b[43m        \u001b[49m\u001b[43mengine\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    946\u001b[0m \u001b[43m        \u001b[49m\u001b[43mstorage_options\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstorage_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    947\u001b[0m \u001b[43m        \u001b[49m\u001b[43mengine_kwargs\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine_kwargs\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m    948\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    949\u001b[0m     need_save \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mTrue\u001b[39;00m\n\u001b[1;32m    951\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/pandas/io/excel/_openpyxl.py:57\u001b[0m, in \u001b[0;36mOpenpyxlWriter.__init__\u001b[0;34m(self, path, engine, date_format, datetime_format, mode, storage_options, if_sheet_exists, engine_kwargs, **kwargs)\u001b[0m\n\u001b[1;32m     44\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21m__init__\u001b[39m(\n\u001b[1;32m     45\u001b[0m     \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m     46\u001b[0m     path: FilePath \u001b[38;5;241m|\u001b[39m WriteExcelBuffer \u001b[38;5;241m|\u001b[39m ExcelWriter,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m     55\u001b[0m ) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m     56\u001b[0m     \u001b[38;5;66;03m# Use the openpyxl module as the Excel writer.\u001b[39;00m\n\u001b[0;32m---> 57\u001b[0m     \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mworkbook\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m Workbook\n\u001b[1;32m     59\u001b[0m     engine_kwargs \u001b[38;5;241m=\u001b[39m combine_kwargs(engine_kwargs, kwargs)\n\u001b[1;32m     61\u001b[0m     \u001b[38;5;28msuper\u001b[39m()\u001b[38;5;241m.\u001b[39m\u001b[38;5;21m__init__\u001b[39m(\n\u001b[1;32m     62\u001b[0m         path,\n\u001b[1;32m     63\u001b[0m         mode\u001b[38;5;241m=\u001b[39mmode,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m     66\u001b[0m         engine_kwargs\u001b[38;5;241m=\u001b[39mengine_kwargs,\n\u001b[1;32m     67\u001b[0m     )\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/openpyxl/__init__.py:6\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mcompat\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mnumbers\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m NUMPY\n\u001b[1;32m      5\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mxml\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m DEFUSEDXML, LXML\n\u001b[0;32m----> 6\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mworkbook\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m Workbook\n\u001b[1;32m      7\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mreader\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mexcel\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m load_workbook \u001b[38;5;28;01mas\u001b[39;00m \u001b[38;5;28mopen\u001b[39m\n\u001b[1;32m      8\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mreader\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mexcel\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m load_workbook\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/openpyxl/workbook/__init__.py:4\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[38;5;66;03m# Copyright (c) 2010-2022 openpyxl\u001b[39;00m\n\u001b[0;32m----> 4\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mworkbook\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m Workbook\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/openpyxl/workbook/workbook.py:33\u001b[0m\n\u001b[1;32m     31\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mchartsheet\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m Chartsheet\n\u001b[1;32m     32\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mdefined_name\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m DefinedName, DefinedNameList\n\u001b[0;32m---> 33\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mpackaging\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mcore\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m DocumentProperties\n\u001b[1;32m     34\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mopenpyxl\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mpackaging\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mrelationship\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m RelationshipList\n\u001b[1;32m     35\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mchild\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m _WorkbookChild\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/openpyxl/packaging/core.py:47\u001b[0m\n\u001b[1;32m     43\u001b[0m         el\u001b[38;5;241m.\u001b[39mset(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124m{\u001b[39m\u001b[38;5;132;01m%s\u001b[39;00m\u001b[38;5;124m}type\u001b[39m\u001b[38;5;124m\"\u001b[39m \u001b[38;5;241m%\u001b[39m XSI_NS, QName(DCTERMS_NS, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mW3CDTF\u001b[39m\u001b[38;5;124m\"\u001b[39m))\n\u001b[1;32m     44\u001b[0m         \u001b[38;5;28;01mreturn\u001b[39;00m el\n\u001b[0;32m---> 47\u001b[0m \u001b[38;5;28;43;01mclass\u001b[39;49;00m\u001b[43m \u001b[49m\u001b[38;5;21;43;01mDocumentProperties\u001b[39;49;00m\u001b[43m(\u001b[49m\u001b[43mSerialisable\u001b[49m\u001b[43m)\u001b[49m\u001b[43m:\u001b[49m\n\u001b[1;32m     48\u001b[0m \u001b[38;5;250;43m    \u001b[39;49m\u001b[38;5;124;43;03m\"\"\"High-level properties of the document.\u001b[39;49;00m\n\u001b[1;32m     49\u001b[0m \u001b[38;5;124;43;03m    Defined in ECMA-376 Par2 Annex D\u001b[39;49;00m\n\u001b[1;32m     50\u001b[0m \u001b[38;5;124;43;03m    \"\"\"\u001b[39;49;00m\n\u001b[1;32m     52\u001b[0m \u001b[43m    \u001b[49m\u001b[43mtagname\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43m \u001b[49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43mcoreProperties\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\n",
      "File \u001b[0;32m~/anaconda3/envs/ccc-dev/lib/python3.12/site-packages/openpyxl/packaging/core.py:89\u001b[0m, in \u001b[0;36mDocumentProperties\u001b[0;34m()\u001b[0m\n\u001b[1;32m     73\u001b[0m modified \u001b[38;5;241m=\u001b[39m QualifiedDateTime(allow_none\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mTrue\u001b[39;00m, namespace\u001b[38;5;241m=\u001b[39mDCTERMS_NS)\n\u001b[1;32m     75\u001b[0m __elements__ \u001b[38;5;241m=\u001b[39m (\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mcreator\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mtitle\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mdescription\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124msubject\u001b[39m\u001b[38;5;124m\"\u001b[39m,\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124midentifier\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[1;32m     76\u001b[0m               \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mlanguage\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mcreated\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mmodified\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mlastModifiedBy\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mcategory\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[1;32m     77\u001b[0m               \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mcontentStatus\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mversion\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mrevision\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mkeywords\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mlastPrinted\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[1;32m     78\u001b[0m               )\n\u001b[1;32m     81\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21m__init__\u001b[39m(\u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m     82\u001b[0m              category\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     83\u001b[0m              contentStatus\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     84\u001b[0m              keywords\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     85\u001b[0m              lastModifiedBy\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     86\u001b[0m              lastPrinted\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     87\u001b[0m              revision\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     88\u001b[0m              version\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[0;32m---> 89\u001b[0m              created\u001b[38;5;241m=\u001b[39m\u001b[43mdatetime\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdatetime\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mutcnow\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m,\n\u001b[1;32m     90\u001b[0m              creator\u001b[38;5;241m=\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mopenpyxl\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[1;32m     91\u001b[0m              description\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     92\u001b[0m              identifier\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     93\u001b[0m              language\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     94\u001b[0m              modified\u001b[38;5;241m=\u001b[39mdatetime\u001b[38;5;241m.\u001b[39mdatetime\u001b[38;5;241m.\u001b[39mutcnow(),\n\u001b[1;32m     95\u001b[0m              subject\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     96\u001b[0m              title\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m     97\u001b[0m              ):\n\u001b[1;32m     98\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mcontentStatus \u001b[38;5;241m=\u001b[39m contentStatus\n\u001b[1;32m     99\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mlastPrinted \u001b[38;5;241m=\u001b[39m lastPrinted\n",
      "\u001b[0;31mDeprecationWarning\u001b[0m: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC)."
     ]
    }
   ],
   "source": [
    "# Save these results to disk\n",
    "calc1.summary_table(calc2, output_variable='rho', output_type='excel', path='cc_table.xlsx')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There are also `Calculator` methods to compute summary tables by asset type or industry.  These are computed in the next two cells."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n",
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n"
     ]
    },
    {
     "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Category</th>\n",
       "      <th>Marginal Effective Total Tax Rate Under Baseline Policy</th>\n",
       "      <th>Marginal Effective Total Tax Rate Under Reform Policy</th>\n",
       "      <th>Change from Baseline (pp)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Overall</td>\n",
       "      <td>17.639885</td>\n",
       "      <td>25.524466</td>\n",
       "      <td>7.884581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Corporate</td>\n",
       "      <td>17.755445</td>\n",
       "      <td>28.320144</td>\n",
       "      <td>10.564699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Equipment</td>\n",
       "      <td>6.748557</td>\n",
       "      <td>22.505995</td>\n",
       "      <td>15.757439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Structures</td>\n",
       "      <td>18.403895</td>\n",
       "      <td>27.871517</td>\n",
       "      <td>9.467623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>6.748557</td>\n",
       "      <td>11.267132</td>\n",
       "      <td>4.518575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Inventories</td>\n",
       "      <td>29.224527</td>\n",
       "      <td>39.958412</td>\n",
       "      <td>10.733886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Land</td>\n",
       "      <td>26.331360</td>\n",
       "      <td>35.884178</td>\n",
       "      <td>9.552818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Pass-through</td>\n",
       "      <td>19.007441</td>\n",
       "      <td>23.318798</td>\n",
       "      <td>4.311357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Equipment</td>\n",
       "      <td>1.961381</td>\n",
       "      <td>15.050433</td>\n",
       "      <td>13.089052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Structures</td>\n",
       "      <td>17.622599</td>\n",
       "      <td>21.473278</td>\n",
       "      <td>3.850679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Intellectual Property</td>\n",
       "      <td>1.961381</td>\n",
       "      <td>6.536701</td>\n",
       "      <td>4.575320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Inventories</td>\n",
       "      <td>25.284934</td>\n",
       "      <td>29.145909</td>\n",
       "      <td>3.860975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Land</td>\n",
       "      <td>22.063514</td>\n",
       "      <td>25.536828</td>\n",
       "      <td>3.473313</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Category  \\\n",
       "0                    Overall   \n",
       "1                  Corporate   \n",
       "2                  Equipment   \n",
       "3                 Structures   \n",
       "4      Intellectual Property   \n",
       "5                Inventories   \n",
       "6                       Land   \n",
       "7               Pass-through   \n",
       "8                  Equipment   \n",
       "9                 Structures   \n",
       "10     Intellectual Property   \n",
       "11               Inventories   \n",
       "12                      Land   \n",
       "\n",
       "    Marginal Effective Total Tax Rate Under Baseline Policy  \\\n",
       "0                                           17.639885         \n",
       "1                                           17.755445         \n",
       "2                                            6.748557         \n",
       "3                                           18.403895         \n",
       "4                                            6.748557         \n",
       "5                                           29.224527         \n",
       "6                                           26.331360         \n",
       "7                                           19.007441         \n",
       "8                                            1.961381         \n",
       "9                                           17.622599         \n",
       "10                                           1.961381         \n",
       "11                                          25.284934         \n",
       "12                                          22.063514         \n",
       "\n",
       "    Marginal Effective Total Tax Rate Under Reform Policy  \\\n",
       "0                                           25.524466       \n",
       "1                                           28.320144       \n",
       "2                                           22.505995       \n",
       "3                                           27.871517       \n",
       "4                                           11.267132       \n",
       "5                                           39.958412       \n",
       "6                                           35.884178       \n",
       "7                                           23.318798       \n",
       "8                                           15.050433       \n",
       "9                                           21.473278       \n",
       "10                                           6.536701       \n",
       "11                                          29.145909       \n",
       "12                                          25.536828       \n",
       "\n",
       "    Change from Baseline (pp)  \n",
       "0                    7.884581  \n",
       "1                   10.564699  \n",
       "2                   15.757439  \n",
       "3                    9.467623  \n",
       "4                    4.518575  \n",
       "5                   10.733886  \n",
       "6                    9.552818  \n",
       "7                    4.311357  \n",
       "8                   13.089052  \n",
       "9                    3.850679  \n",
       "10                   4.575320  \n",
       "11                   3.860975  \n",
       "12                   3.473313  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Summary by asset type\n",
    "calc1.asset_summary_table(calc2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n",
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n"
     ]
    },
    {
     "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Category</th>\n",
       "      <th>Marginal Effective Total Tax Rate Under Baseline Policy</th>\n",
       "      <th>Marginal Effective Total Tax Rate Under Reform Policy</th>\n",
       "      <th>Change from Baseline (pp)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Overall</td>\n",
       "      <td>17.639885</td>\n",
       "      <td>25.524466</td>\n",
       "      <td>7.884581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Corporate</td>\n",
       "      <td>17.755445</td>\n",
       "      <td>28.320144</td>\n",
       "      <td>10.564699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Agriculture, forestry, fishing, and hunting</td>\n",
       "      <td>18.621881</td>\n",
       "      <td>30.896046</td>\n",
       "      <td>12.274165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mining</td>\n",
       "      <td>9.714456</td>\n",
       "      <td>17.971900</td>\n",
       "      <td>8.257444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Utilities</td>\n",
       "      <td>7.770042</td>\n",
       "      <td>20.115997</td>\n",
       "      <td>12.345955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Construction</td>\n",
       "      <td>19.159651</td>\n",
       "      <td>30.624693</td>\n",
       "      <td>11.465042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>18.050971</td>\n",
       "      <td>27.120119</td>\n",
       "      <td>9.069148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Wholesale trade</td>\n",
       "      <td>23.492232</td>\n",
       "      <td>34.533774</td>\n",
       "      <td>11.041542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Retail trade</td>\n",
       "      <td>24.479352</td>\n",
       "      <td>34.948319</td>\n",
       "      <td>10.468967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Transportation and warehousing</td>\n",
       "      <td>10.992693</td>\n",
       "      <td>20.708297</td>\n",
       "      <td>9.715604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Information</td>\n",
       "      <td>10.390034</td>\n",
       "      <td>24.838020</td>\n",
       "      <td>14.447985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Finance and insurance</td>\n",
       "      <td>18.696422</td>\n",
       "      <td>30.540664</td>\n",
       "      <td>11.844242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Real estate and rental and leasing</td>\n",
       "      <td>24.387301</td>\n",
       "      <td>33.983636</td>\n",
       "      <td>9.596334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Professional, scientific, and technical ser...</td>\n",
       "      <td>14.605649</td>\n",
       "      <td>25.698186</td>\n",
       "      <td>11.092537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Management of companies and enterprises</td>\n",
       "      <td>22.484921</td>\n",
       "      <td>32.516446</td>\n",
       "      <td>10.031525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Administrative and waste management services</td>\n",
       "      <td>14.309938</td>\n",
       "      <td>26.805903</td>\n",
       "      <td>12.495965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Educational services</td>\n",
       "      <td>22.487031</td>\n",
       "      <td>31.884260</td>\n",
       "      <td>9.397229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Health care and social assistance</td>\n",
       "      <td>20.632608</td>\n",
       "      <td>31.106191</td>\n",
       "      <td>10.473583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Arts, entertainment, and recreation</td>\n",
       "      <td>15.548896</td>\n",
       "      <td>26.617836</td>\n",
       "      <td>11.068940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Accommodation and food services</td>\n",
       "      <td>24.067836</td>\n",
       "      <td>34.355820</td>\n",
       "      <td>10.287984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Other services, except government</td>\n",
       "      <td>20.836695</td>\n",
       "      <td>30.077012</td>\n",
       "      <td>9.240317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Pass-through</td>\n",
       "      <td>19.007441</td>\n",
       "      <td>23.318798</td>\n",
       "      <td>4.311357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Agriculture, forestry, fishing, and hunting</td>\n",
       "      <td>16.047848</td>\n",
       "      <td>22.465303</td>\n",
       "      <td>6.417456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mining</td>\n",
       "      <td>5.329731</td>\n",
       "      <td>11.922444</td>\n",
       "      <td>6.592713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Utilities</td>\n",
       "      <td>3.315756</td>\n",
       "      <td>13.381097</td>\n",
       "      <td>10.065342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Construction</td>\n",
       "      <td>16.256425</td>\n",
       "      <td>22.058650</td>\n",
       "      <td>5.802225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>14.365716</td>\n",
       "      <td>19.196170</td>\n",
       "      <td>4.830454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Wholesale trade</td>\n",
       "      <td>21.269469</td>\n",
       "      <td>26.008485</td>\n",
       "      <td>4.739016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Retail trade</td>\n",
       "      <td>21.496969</td>\n",
       "      <td>25.904160</td>\n",
       "      <td>4.407191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Transportation and warehousing</td>\n",
       "      <td>6.894412</td>\n",
       "      <td>14.309383</td>\n",
       "      <td>7.414971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Information</td>\n",
       "      <td>6.049526</td>\n",
       "      <td>17.143644</td>\n",
       "      <td>11.094117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Finance and insurance</td>\n",
       "      <td>18.440433</td>\n",
       "      <td>23.532485</td>\n",
       "      <td>5.092051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Real estate and rental and leasing</td>\n",
       "      <td>21.082232</td>\n",
       "      <td>24.615095</td>\n",
       "      <td>3.532863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Professional, scientific, and technical ser...</td>\n",
       "      <td>10.083509</td>\n",
       "      <td>17.383227</td>\n",
       "      <td>7.299718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Management of companies and enterprises</td>\n",
       "      <td>18.102279</td>\n",
       "      <td>22.791069</td>\n",
       "      <td>4.688790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Administrative and waste management services</td>\n",
       "      <td>9.711826</td>\n",
       "      <td>18.261459</td>\n",
       "      <td>8.549633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Educational services</td>\n",
       "      <td>18.079977</td>\n",
       "      <td>22.247380</td>\n",
       "      <td>4.167403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Health care and social assistance</td>\n",
       "      <td>16.206875</td>\n",
       "      <td>21.634895</td>\n",
       "      <td>5.428020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Arts, entertainment, and recreation</td>\n",
       "      <td>10.766382</td>\n",
       "      <td>18.025709</td>\n",
       "      <td>7.259327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Accommodation and food services</td>\n",
       "      <td>19.929849</td>\n",
       "      <td>24.406857</td>\n",
       "      <td>4.477008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Other services, except government</td>\n",
       "      <td>16.154067</td>\n",
       "      <td>20.605809</td>\n",
       "      <td>4.451742</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Category  \\\n",
       "0                                             Overall   \n",
       "1                                           Corporate   \n",
       "2         Agriculture, forestry, fishing, and hunting   \n",
       "3                                              Mining   \n",
       "4                                           Utilities   \n",
       "5                                        Construction   \n",
       "6                                       Manufacturing   \n",
       "7                                     Wholesale trade   \n",
       "8                                        Retail trade   \n",
       "9                      Transportation and warehousing   \n",
       "10                                        Information   \n",
       "11                              Finance and insurance   \n",
       "12                 Real estate and rental and leasing   \n",
       "13     Professional, scientific, and technical ser...   \n",
       "14            Management of companies and enterprises   \n",
       "15       Administrative and waste management services   \n",
       "16                               Educational services   \n",
       "17                  Health care and social assistance   \n",
       "18                Arts, entertainment, and recreation   \n",
       "19                    Accommodation and food services   \n",
       "20                  Other services, except government   \n",
       "21                                       Pass-through   \n",
       "22        Agriculture, forestry, fishing, and hunting   \n",
       "23                                             Mining   \n",
       "24                                          Utilities   \n",
       "25                                       Construction   \n",
       "26                                      Manufacturing   \n",
       "27                                    Wholesale trade   \n",
       "28                                       Retail trade   \n",
       "29                     Transportation and warehousing   \n",
       "30                                        Information   \n",
       "31                              Finance and insurance   \n",
       "32                 Real estate and rental and leasing   \n",
       "33     Professional, scientific, and technical ser...   \n",
       "34            Management of companies and enterprises   \n",
       "35       Administrative and waste management services   \n",
       "36                               Educational services   \n",
       "37                  Health care and social assistance   \n",
       "38                Arts, entertainment, and recreation   \n",
       "39                    Accommodation and food services   \n",
       "40                  Other services, except government   \n",
       "\n",
       "    Marginal Effective Total Tax Rate Under Baseline Policy  \\\n",
       "0                                           17.639885         \n",
       "1                                           17.755445         \n",
       "2                                           18.621881         \n",
       "3                                            9.714456         \n",
       "4                                            7.770042         \n",
       "5                                           19.159651         \n",
       "6                                           18.050971         \n",
       "7                                           23.492232         \n",
       "8                                           24.479352         \n",
       "9                                           10.992693         \n",
       "10                                          10.390034         \n",
       "11                                          18.696422         \n",
       "12                                          24.387301         \n",
       "13                                          14.605649         \n",
       "14                                          22.484921         \n",
       "15                                          14.309938         \n",
       "16                                          22.487031         \n",
       "17                                          20.632608         \n",
       "18                                          15.548896         \n",
       "19                                          24.067836         \n",
       "20                                          20.836695         \n",
       "21                                          19.007441         \n",
       "22                                          16.047848         \n",
       "23                                           5.329731         \n",
       "24                                           3.315756         \n",
       "25                                          16.256425         \n",
       "26                                          14.365716         \n",
       "27                                          21.269469         \n",
       "28                                          21.496969         \n",
       "29                                           6.894412         \n",
       "30                                           6.049526         \n",
       "31                                          18.440433         \n",
       "32                                          21.082232         \n",
       "33                                          10.083509         \n",
       "34                                          18.102279         \n",
       "35                                           9.711826         \n",
       "36                                          18.079977         \n",
       "37                                          16.206875         \n",
       "38                                          10.766382         \n",
       "39                                          19.929849         \n",
       "40                                          16.154067         \n",
       "\n",
       "    Marginal Effective Total Tax Rate Under Reform Policy  \\\n",
       "0                                           25.524466       \n",
       "1                                           28.320144       \n",
       "2                                           30.896046       \n",
       "3                                           17.971900       \n",
       "4                                           20.115997       \n",
       "5                                           30.624693       \n",
       "6                                           27.120119       \n",
       "7                                           34.533774       \n",
       "8                                           34.948319       \n",
       "9                                           20.708297       \n",
       "10                                          24.838020       \n",
       "11                                          30.540664       \n",
       "12                                          33.983636       \n",
       "13                                          25.698186       \n",
       "14                                          32.516446       \n",
       "15                                          26.805903       \n",
       "16                                          31.884260       \n",
       "17                                          31.106191       \n",
       "18                                          26.617836       \n",
       "19                                          34.355820       \n",
       "20                                          30.077012       \n",
       "21                                          23.318798       \n",
       "22                                          22.465303       \n",
       "23                                          11.922444       \n",
       "24                                          13.381097       \n",
       "25                                          22.058650       \n",
       "26                                          19.196170       \n",
       "27                                          26.008485       \n",
       "28                                          25.904160       \n",
       "29                                          14.309383       \n",
       "30                                          17.143644       \n",
       "31                                          23.532485       \n",
       "32                                          24.615095       \n",
       "33                                          17.383227       \n",
       "34                                          22.791069       \n",
       "35                                          18.261459       \n",
       "36                                          22.247380       \n",
       "37                                          21.634895       \n",
       "38                                          18.025709       \n",
       "39                                          24.406857       \n",
       "40                                          20.605809       \n",
       "\n",
       "    Change from Baseline (pp)  \n",
       "0                    7.884581  \n",
       "1                   10.564699  \n",
       "2                   12.274165  \n",
       "3                    8.257444  \n",
       "4                   12.345955  \n",
       "5                   11.465042  \n",
       "6                    9.069148  \n",
       "7                   11.041542  \n",
       "8                   10.468967  \n",
       "9                    9.715604  \n",
       "10                  14.447985  \n",
       "11                  11.844242  \n",
       "12                   9.596334  \n",
       "13                  11.092537  \n",
       "14                  10.031525  \n",
       "15                  12.495965  \n",
       "16                   9.397229  \n",
       "17                  10.473583  \n",
       "18                  11.068940  \n",
       "19                  10.287984  \n",
       "20                   9.240317  \n",
       "21                   4.311357  \n",
       "22                   6.417456  \n",
       "23                   6.592713  \n",
       "24                  10.065342  \n",
       "25                   5.802225  \n",
       "26                   4.830454  \n",
       "27                   4.739016  \n",
       "28                   4.407191  \n",
       "29                   7.414971  \n",
       "30                  11.094117  \n",
       "31                   5.092051  \n",
       "32                   3.532863  \n",
       "33                   7.299718  \n",
       "34                   4.688790  \n",
       "35                   8.549633  \n",
       "36                   4.167403  \n",
       "37                   5.428020  \n",
       "38                   7.259327  \n",
       "39                   4.477008  \n",
       "40                   4.451742  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Summary by industry\n",
    "calc1.industry_summary_table(calc2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Visualizations\n",
    "\n",
    "If one wants to visualize the effects of changes in tax policy, the `Calculator` class has a few methods for this.  \n",
    "\n",
    "We can use the `grouped_bar` method to show differential effects across assets (the default):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n",
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"d9f3ebad-734e-4684-84ea-df385ccfed8e\" data-root-id=\"p1004\" style=\"display: contents;\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function embed_document(root) {\n  const docs_json = {\"97ca93aa-25b7-499e-baf3-12bbfbbff347\":{\"version\":\"3.2.2\",\"title\":\"Bokeh Application\",\"roots\":[{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1004\",\"attributes\":{\"height\":350,\"x_range\":{\"type\":\"object\",\"name\":\"FactorRange\",\"id\":\"p1013\",\"attributes\":{\"factors\":[\"Equipment\",\"Intellectual Property\",\"Inventories\",\"Land\",\"Structures\"],\"range_padding\":0.1}},\"y_range\":{\"type\":\"object\",\"name\":\"DataRange1d\",\"id\":\"p1006\"},\"x_scale\":{\"type\":\"object\",\"name\":\"CategoricalScale\",\"id\":\"p1014\"},\"y_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1015\"},\"title\":null,\"renderers\":[{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1033\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1001\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1002\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1003\"},\"data\":{\"type\":\"map\",\"entries\":[[\"index\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"AAAAAAEAAAACAAAAAwAAAAQAAAA=\"},\"shape\":[5],\"dtype\":\"int32\",\"order\":\"little\"}],[\"major_asset_group\",{\"type\":\"ndarray\",\"array\":[\"Equipment\",\"Intellectual Property\",\"Inventories\",\"Land\",\"Structures\"],\"shape\":[5],\"dtype\":\"object\",\"order\":\"little\"}],[\"Baseline\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"13TT6LtGsT/XdNPou0axP+jLsH0ltNI/PMOpRSHa0D/NcB+Rlo7HPw==\"},\"shape\":[5],\"dtype\":\"float64\",\"order\":\"little\"}],[\"Reform\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"YA548UsFzT/wWdK76FS9P55zuGnpp9k/ddGIndIN1z+db3T+2O/RPw==\"},\"shape\":[5],\"dtype\":\"float64\",\"order\":\"little\"}]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1034\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1035\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1030\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_asset_group\",\"transform\":{\"type\":\"object\",\"name\":\"Dodge\",\"id\":\"p1026\",\"attributes\":{\"range\":{\"id\":\"p1013\"}}}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Baseline\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1031\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_asset_group\",\"transform\":{\"id\":\"p1026\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Baseline\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1032\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_asset_group\",\"transform\":{\"id\":\"p1026\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Baseline\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1045\",\"attributes\":{\"data_source\":{\"id\":\"p1001\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1046\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1047\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1042\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_asset_group\",\"transform\":{\"type\":\"object\",\"name\":\"Dodge\",\"id\":\"p1038\",\"attributes\":{\"value\":0.25,\"range\":{\"id\":\"p1013\"}}}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Reform\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1043\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_asset_group\",\"transform\":{\"id\":\"p1038\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Reform\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1044\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_asset_group\",\"transform\":{\"id\":\"p1038\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Reform\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"Span\",\"id\":\"p1049\",\"attributes\":{\"location\":0.17755444865113856,\"line_color\":\"#718dbf\",\"line_alpha\":0.2,\"line_width\":2,\"line_dash\":[6]}},{\"type\":\"object\",\"name\":\"Span\",\"id\":\"p1050\",\"attributes\":{\"location\":0.28474077135875026,\"line_color\":\"#e84d60\",\"line_alpha\":0.2,\"line_width\":2,\"line_dash\":[6]}}],\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1012\"},\"toolbar_location\":null,\"left\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1021\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1022\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"BasicTickFormatter\",\"id\":\"p1023\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1024\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"CategoricalAxis\",\"id\":\"p1016\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"CategoricalTicker\",\"id\":\"p1017\"},\"formatter\":{\"type\":\"object\",\"name\":\"CategoricalTickFormatter\",\"id\":\"p1018\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1019\"}}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1020\",\"attributes\":{\"axis\":{\"id\":\"p1016\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1025\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1021\"}}},{\"type\":\"object\",\"name\":\"Legend\",\"id\":\"p1036\",\"attributes\":{\"location\":\"top_left\",\"orientation\":\"horizontal\",\"items\":[{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1037\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Baseline\"},\"renderers\":[{\"id\":\"p1033\"}]}},{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1048\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Reform\"},\"renderers\":[{\"id\":\"p1045\"}]}}]}}]}}]}};\n  const render_items = [{\"docid\":\"97ca93aa-25b7-499e-baf3-12bbfbbff347\",\"roots\":{\"p1004\":\"d9f3ebad-734e-4684-84ea-df385ccfed8e\"},\"root_ids\":[\"p1004\"]}];\n  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n  }\n  if (root.Bokeh !== undefined) {\n    embed_document(root);\n  } else {\n    let attempts = 0;\n    const timer = setInterval(function(root) {\n      if (root.Bokeh !== undefined) {\n        clearInterval(timer);\n        embed_document(root);\n      } else {\n        attempts++;\n        if (attempts > 100) {\n          clearInterval(timer);\n          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n        }\n      }\n    }, 10, root)\n  }\n})(window);",
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "p1004"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Visualizing changes by asset type\n",
    "aplot = calc1.grouped_bar(calc2)\n",
    "show(aplot)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "or we can change from the default asset category split to a split by industry by changing the value of the `group_by_asset` keyword argument:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n",
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"de5a749d-2b37-4dc0-9901-0141c102b866\" data-root-id=\"p1057\" style=\"display: contents;\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function embed_document(root) {\n  const docs_json = {\"2346e627-790c-4001-b551-6983f64bcaad\":{\"version\":\"3.2.2\",\"title\":\"Bokeh Application\",\"roots\":[{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1057\",\"attributes\":{\"width\":800,\"height\":800,\"x_range\":{\"type\":\"object\",\"name\":\"FactorRange\",\"id\":\"p1066\",\"attributes\":{\"factors\":[\"Accommodation and food services\",\"Administrative and waste management services\",\"Agriculture, forestry, fishing, and hunting\",\"Arts, entertainment, and recreation\",\"Construction\",\"Educational services\",\"Finance and insurance\",\"Health care and social assistance\",\"Information\",\"Management of companies and enterprises\",\"Manufacturing\",\"Mining\",\"Other services, except government\",\"Professional, scientific, and technical services\",\"Real estate and rental and leasing\",\"Retail trade\",\"Transportation and warehousing\",\"Utilities\",\"Wholesale trade\"],\"range_padding\":0.1}},\"y_range\":{\"type\":\"object\",\"name\":\"DataRange1d\",\"id\":\"p1059\"},\"x_scale\":{\"type\":\"object\",\"name\":\"CategoricalScale\",\"id\":\"p1067\"},\"y_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1068\"},\"title\":null,\"renderers\":[{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1086\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1054\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1055\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1056\"},\"data\":{\"type\":\"map\",\"entries\":[[\"index\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"AAAAAAEAAAACAAAAAwAAAAQAAAAFAAAABgAAAAcAAAAIAAAACQAAAAoAAAALAAAADAAAAA0AAAAOAAAADwAAABAAAAARAAAAEgAAAA==\"},\"shape\":[19],\"dtype\":\"int32\",\"order\":\"little\"}],[\"major_industry\",{\"type\":\"ndarray\",\"array\":[\"Accommodation and food services\",\"Administrative and waste management services\",\"Agriculture, forestry, fishing, and hunting\",\"Arts, entertainment, and recreation\",\"Construction\",\"Educational services\",\"Finance and insurance\",\"Health care and social assistance\",\"Information\",\"Management of companies and enterprises\",\"Manufacturing\",\"Mining\",\"Other services, except government\",\"Professional, scientific, and technical services\",\"Real estate and rental and leasing\",\"Retail trade\",\"Transportation and warehousing\",\"Utilities\",\"Wholesale trade\"],\"shape\":[19],\"dtype\":\"object\",\"order\":\"little\"}],[\"Baseline\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"rq4WaYzOzj8PQCuQFFHCP5ufcpYE1sc/vxBu9A/nwz/pqZkBPIbIP04ITuaMyMw/vdPOi3Huxz9oR6yZ5GjKP8HrVXs2mbo/8D5A49vHzD/Fh5Uo8RrHP6bAhU533rg/3Yvgn8Sryj8luvms+rHCP34Azxo7N88/WTgm3mRVzz/bihLSKyS8P4DvsLws5LM/W4C9Pe8Rzj8=\"},\"shape\":[19],\"dtype\":\"float64\",\"order\":\"little\"}],[\"Reform\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"IoTMSfQT1j8/IyXeoUHRP46eknlS3tM/Iszdt+Ii0T//mJqN9bHTPxmvcSzif9Q/KUvhtTik0z8Z9emxrQDUP8lF9TjQ/88/wPsKDz3n1D9Q+LC6AHXRP1HRdE7BOsc/I5+QeGtY0z/RgOOiiIzQP4KMJEcb19U/gGj1I9J01j/m3gDzfbnKP9anoOrS98k/ceYoNgwx1j8=\"},\"shape\":[19],\"dtype\":\"float64\",\"order\":\"little\"}]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1087\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1088\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1083\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_industry\",\"transform\":{\"type\":\"object\",\"name\":\"Dodge\",\"id\":\"p1079\",\"attributes\":{\"range\":{\"id\":\"p1066\"}}}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Baseline\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1084\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_industry\",\"transform\":{\"id\":\"p1079\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Baseline\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1085\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_industry\",\"transform\":{\"id\":\"p1079\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Baseline\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1098\",\"attributes\":{\"data_source\":{\"id\":\"p1054\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1099\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1100\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1095\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_industry\",\"transform\":{\"type\":\"object\",\"name\":\"Dodge\",\"id\":\"p1091\",\"attributes\":{\"value\":0.25,\"range\":{\"id\":\"p1066\"}}}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Reform\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1096\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_industry\",\"transform\":{\"id\":\"p1091\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Reform\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"VBar\",\"id\":\"p1097\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"major_industry\",\"transform\":{\"id\":\"p1091\"}},\"width\":{\"type\":\"value\",\"value\":0.2},\"top\":{\"type\":\"field\",\"field\":\"Reform\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"Span\",\"id\":\"p1102\",\"attributes\":{\"location\":0.17755444865113856,\"line_color\":\"#718dbf\",\"line_alpha\":0.2,\"line_width\":2,\"line_dash\":[6]}},{\"type\":\"object\",\"name\":\"Span\",\"id\":\"p1103\",\"attributes\":{\"location\":0.28474077135875026,\"line_color\":\"#e84d60\",\"line_alpha\":0.2,\"line_width\":2,\"line_dash\":[6]}}],\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1065\"},\"toolbar_location\":null,\"left\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1074\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1075\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"BasicTickFormatter\",\"id\":\"p1076\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1077\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"CategoricalAxis\",\"id\":\"p1069\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"CategoricalTicker\",\"id\":\"p1070\"},\"formatter\":{\"type\":\"object\",\"name\":\"CategoricalTickFormatter\",\"id\":\"p1071\"},\"major_label_orientation\":45,\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1072\"}}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1073\",\"attributes\":{\"axis\":{\"id\":\"p1069\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1078\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1074\"}}},{\"type\":\"object\",\"name\":\"Legend\",\"id\":\"p1089\",\"attributes\":{\"location\":\"top_left\",\"orientation\":\"horizontal\",\"items\":[{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1090\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Baseline\"},\"renderers\":[{\"id\":\"p1086\"}]}},{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1101\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Reform\"},\"renderers\":[{\"id\":\"p1098\"}]}}]}}]}}]}};\n  const render_items = [{\"docid\":\"2346e627-790c-4001-b551-6983f64bcaad\",\"roots\":{\"p1057\":\"de5a749d-2b37-4dc0-9901-0141c102b866\"},\"root_ids\":[\"p1057\"]}];\n  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n  }\n  if (root.Bokeh !== undefined) {\n    embed_document(root);\n  } else {\n    let attempts = 0;\n    const timer = setInterval(function(root) {\n      if (root.Bokeh !== undefined) {\n        clearInterval(timer);\n        embed_document(root);\n      } else {\n        attempts++;\n        if (attempts > 100) {\n          clearInterval(timer);\n          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n        }\n      }\n    }, 10, root)\n  }\n})(window);",
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "p1057"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Visualizing changes by industry\n",
    "iplot = calc1.grouped_bar(calc2, group_by_asset=False)\n",
    "show(iplot)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There's also a plot that illustrates the range of the effects of taxes on investments across asset types, by showing the min, max, and mean values:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n",
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"ef513c09-f405-4813-8d31-53872bdd3bbe\" data-root-id=\"p1113\" style=\"display: contents;\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function embed_document(root) {\n  const docs_json = {\"bbaacd71-8476-4755-8303-1fe29d1db898\":{\"version\":\"3.2.2\",\"title\":\"Bokeh Application\",\"roots\":[{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1113\",\"attributes\":{\"width\":500,\"height\":500,\"x_range\":{\"type\":\"object\",\"name\":\"Range1d\",\"id\":\"p1122\",\"attributes\":{\"start\":-0.5,\"end\":2.5}},\"y_range\":{\"type\":\"object\",\"name\":\"DataRange1d\",\"id\":\"p1115\"},\"x_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1123\"},\"y_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1124\"},\"title\":{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1120\",\"attributes\":{\"text_font\":\"Helvetica\"}},\"renderers\":[{\"type\":\"object\",\"name\":\"Span\",\"id\":\"p1138\",\"attributes\":{\"location\":0,\"line_alpha\":0.2,\"line_width\":2,\"line_dash\":[6]}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1148\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1107\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1108\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1109\"},\"data\":{\"type\":\"map\",\"entries\":[[\"mins\",[-0.09155606847470654,-0.4364303178484108,-1.1963610179150395e-16]],[\"maxes\",[0.17153671237143198,-0.06578788226151004,0.23626733773084305]],[\"means\",[0.03728521579640505,-0.262084258806486,0.11736148787988565]],[\"min_asset\",[\"Intellectual Property\",\"Intellectual Property\",\"Intellectual Property\"]],[\"max_asset\",[\"Inventories\",\"Inventories\",\"Inventories\"]],[\"mean_asset\",[\"Overall\",\"Overall\",\"Overall\"]],[\"types\",[\"Typically Financed\",\"Debt Financed\",\"Equity Financed\"]],[\"positions\",[-0.1,0.9,1.9]]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1149\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1150\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1145\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1146\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1147\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"line_width\":{\"type\":\"value\",\"value\":2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1157\",\"attributes\":{\"data_source\":{\"id\":\"p1107\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1158\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1159\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1154\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1155\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1156\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1168\",\"attributes\":{\"data_source\":{\"id\":\"p1107\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1169\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1170\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1165\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1166\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1167\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1177\",\"attributes\":{\"data_source\":{\"id\":\"p1107\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1178\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1179\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1174\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1175\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1176\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1186\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1110\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1111\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1112\"},\"data\":{\"type\":\"map\",\"entries\":[[\"mins\",[-0.044764641890598596,-0.7815749655421983,0.10026430338666585]],[\"maxes\",[0.2930542097668927,-0.13096339112672467,0.3828060809571457]],[\"means\",[0.1560221115131041,-0.41306259807735984,0.27215617091603245]],[\"min_asset\",[\"Intellectual Property\",\"Intellectual Property\",\"Intellectual Property\"]],[\"max_asset\",[\"Inventories\",\"Inventories\",\"Inventories\"]],[\"mean_asset\",[\"Overall\",\"Overall\",\"Overall\"]],[\"types\",[\"Typically Financed\",\"Debt Financed\",\"Equity Financed\"]],[\"positions\",[0.1,1.1,2.1]]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1187\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1188\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1183\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1184\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1185\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"line_width\":{\"type\":\"value\",\"value\":2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1195\",\"attributes\":{\"data_source\":{\"id\":\"p1110\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1196\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1197\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1192\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1193\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1194\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1205\",\"attributes\":{\"data_source\":{\"id\":\"p1110\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1206\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1207\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1202\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1203\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1204\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1214\",\"attributes\":{\"data_source\":{\"id\":\"p1110\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1215\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1216\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1211\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1212\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1213\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}}],\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1121\"},\"toolbar_location\":null,\"left\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1130\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1131\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"NumeralTickFormatter\",\"id\":\"p1137\",\"attributes\":{\"format\":\"0%\"}},\"axis_label\":\"Marginal Effective Tax Rate\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1133\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1125\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"FixedTicker\",\"id\":\"p1135\",\"attributes\":{\"ticks\":[0,1,2],\"minor_ticks\":[]}},\"formatter\":{\"type\":\"object\",\"name\":\"CustomJSTickFormatter\",\"id\":\"p1136\",\"attributes\":{\"code\":\"\\n        var types = [\\\"Typically Financed\\\", \\\"Debt Financed\\\", \\\"Equity Financed\\\"]\\n        return types[tick]\\n        \"}},\"axis_label\":\"Method of Financing\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1128\"}}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1129\",\"attributes\":{\"axis\":{\"id\":\"p1125\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1134\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1130\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1139\",\"attributes\":{\"right\":0.5,\"fill_color\":\"white\",\"fill_alpha\":0.2}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1140\",\"attributes\":{\"left\":0.5,\"right\":1.5,\"fill_color\":\"white\",\"fill_alpha\":0.1}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1141\",\"attributes\":{\"left\":1.5,\"fill_color\":\"white\",\"fill_alpha\":0.2}},{\"type\":\"object\",\"name\":\"Legend\",\"id\":\"p1160\",\"attributes\":{\"location\":\"bottom_right\",\"items\":[{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1161\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Baseline\"},\"renderers\":[{\"id\":\"p1157\"},{\"id\":\"p1168\"},{\"id\":\"p1177\"}]}},{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1198\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Reform\"},\"renderers\":[{\"id\":\"p1195\"},{\"id\":\"p1205\"},{\"id\":\"p1214\"}]}}]}}]}}]}};\n  const render_items = [{\"docid\":\"bbaacd71-8476-4755-8303-1fe29d1db898\",\"roots\":{\"p1113\":\"ef513c09-f405-4813-8d31-53872bdd3bbe\"},\"root_ids\":[\"p1113\"]}];\n  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n  }\n  if (root.Bokeh !== undefined) {\n    embed_document(root);\n  } else {\n    let attempts = 0;\n    const timer = setInterval(function(root) {\n      if (root.Bokeh !== undefined) {\n        clearInterval(timer);\n        embed_document(root);\n      } else {\n        attempts++;\n        if (attempts > 100) {\n          clearInterval(timer);\n          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n        }\n      }\n    }, 10, root)\n  }\n})(window);",
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "p1113"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plot to show variation in METTRs across assets\n",
    "rplot = calc1.range_plot(calc2, output_variable='metr')\n",
    "show(rplot)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "changing to show the effects on pass-through businesses and for a different output variable:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"f9cb3082-7309-4914-aa78-8a5243c13a28\" data-root-id=\"p1113\" style=\"display: contents;\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function embed_document(root) {\n  const docs_json = {\"4b146e0c-dac2-4c42-8ae5-46a73d83da4d\":{\"version\":\"3.2.2\",\"title\":\"Bokeh Application\",\"roots\":[{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1113\",\"attributes\":{\"width\":500,\"height\":500,\"x_range\":{\"type\":\"object\",\"name\":\"Range1d\",\"id\":\"p1122\",\"attributes\":{\"start\":-0.5,\"end\":2.5}},\"y_range\":{\"type\":\"object\",\"name\":\"DataRange1d\",\"id\":\"p1115\"},\"x_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1123\"},\"y_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1124\"},\"title\":{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1120\",\"attributes\":{\"text_font\":\"Helvetica\"}},\"renderers\":[{\"type\":\"object\",\"name\":\"Span\",\"id\":\"p1138\",\"attributes\":{\"location\":0,\"line_alpha\":0.2,\"line_width\":2,\"line_dash\":[6]}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1148\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1107\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1108\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1109\"},\"data\":{\"type\":\"map\",\"entries\":[[\"mins\",[-0.09155606847470654,-0.4364303178484108,-1.1963610179150395e-16]],[\"maxes\",[0.17153671237143198,-0.06578788226151004,0.23626733773084305]],[\"means\",[0.03728521579640505,-0.262084258806486,0.11736148787988565]],[\"min_asset\",[\"Intellectual Property\",\"Intellectual Property\",\"Intellectual Property\"]],[\"max_asset\",[\"Inventories\",\"Inventories\",\"Inventories\"]],[\"mean_asset\",[\"Overall\",\"Overall\",\"Overall\"]],[\"types\",[\"Typically Financed\",\"Debt Financed\",\"Equity Financed\"]],[\"positions\",[-0.1,0.9,1.9]]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1149\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1150\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1145\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1146\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1147\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"line_width\":{\"type\":\"value\",\"value\":2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1157\",\"attributes\":{\"data_source\":{\"id\":\"p1107\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1158\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1159\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1154\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1155\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1156\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1168\",\"attributes\":{\"data_source\":{\"id\":\"p1107\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1169\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1170\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1165\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1166\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1167\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1177\",\"attributes\":{\"data_source\":{\"id\":\"p1107\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1178\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1179\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1174\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1175\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1176\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1186\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1110\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1111\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1112\"},\"data\":{\"type\":\"map\",\"entries\":[[\"mins\",[-0.044764641890598596,-0.7815749655421983,0.10026430338666585]],[\"maxes\",[0.2930542097668927,-0.13096339112672467,0.3828060809571457]],[\"means\",[0.1560221115131041,-0.41306259807735984,0.27215617091603245]],[\"min_asset\",[\"Intellectual Property\",\"Intellectual Property\",\"Intellectual Property\"]],[\"max_asset\",[\"Inventories\",\"Inventories\",\"Inventories\"]],[\"mean_asset\",[\"Overall\",\"Overall\",\"Overall\"]],[\"types\",[\"Typically Financed\",\"Debt Financed\",\"Equity Financed\"]],[\"positions\",[0.1,1.1,2.1]]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1187\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1188\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1183\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1184\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1185\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"line_width\":{\"type\":\"value\",\"value\":2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1195\",\"attributes\":{\"data_source\":{\"id\":\"p1110\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1196\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1197\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1192\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1193\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1194\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1205\",\"attributes\":{\"data_source\":{\"id\":\"p1110\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1206\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1207\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1202\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1203\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1204\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1214\",\"attributes\":{\"data_source\":{\"id\":\"p1110\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1215\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1216\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1211\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1212\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1213\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}}],\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1121\"},\"toolbar_location\":null,\"left\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1130\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1131\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"NumeralTickFormatter\",\"id\":\"p1137\",\"attributes\":{\"format\":\"0%\"}},\"axis_label\":\"Marginal Effective Tax Rate\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1133\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1125\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"FixedTicker\",\"id\":\"p1135\",\"attributes\":{\"ticks\":[0,1,2],\"minor_ticks\":[]}},\"formatter\":{\"type\":\"object\",\"name\":\"CustomJSTickFormatter\",\"id\":\"p1136\",\"attributes\":{\"code\":\"\\n        var types = [\\\"Typically Financed\\\", \\\"Debt Financed\\\", \\\"Equity Financed\\\"]\\n        return types[tick]\\n        \"}},\"axis_label\":\"Method of Financing\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1128\"}}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1129\",\"attributes\":{\"axis\":{\"id\":\"p1125\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1134\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1130\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1139\",\"attributes\":{\"right\":0.5,\"fill_color\":\"white\",\"fill_alpha\":0.2}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1140\",\"attributes\":{\"left\":0.5,\"right\":1.5,\"fill_color\":\"white\",\"fill_alpha\":0.1}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1141\",\"attributes\":{\"left\":1.5,\"fill_color\":\"white\",\"fill_alpha\":0.2}},{\"type\":\"object\",\"name\":\"Legend\",\"id\":\"p1160\",\"attributes\":{\"location\":\"bottom_right\",\"items\":[{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1161\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Baseline\"},\"renderers\":[{\"id\":\"p1157\"},{\"id\":\"p1168\"},{\"id\":\"p1177\"}]}},{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1198\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Reform\"},\"renderers\":[{\"id\":\"p1195\"},{\"id\":\"p1205\"},{\"id\":\"p1214\"}]}}]}}]}}]}};\n  const render_items = [{\"docid\":\"4b146e0c-dac2-4c42-8ae5-46a73d83da4d\",\"roots\":{\"p1113\":\"f9cb3082-7309-4914-aa78-8a5243c13a28\"},\"root_ids\":[\"p1113\"]}];\n  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n  }\n  if (root.Bokeh !== undefined) {\n    embed_document(root);\n  } else {\n    let attempts = 0;\n    const timer = setInterval(function(root) {\n      if (root.Bokeh !== undefined) {\n        clearInterval(timer);\n        embed_document(root);\n      } else {\n        attempts++;\n        if (attempts > 100) {\n          clearInterval(timer);\n          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n        }\n      }\n    }, 10, root)\n  }\n})(window);",
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "p1113"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "show(rplot)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>\n",
       "        .bk-notebook-logo {\n",
       "            display: block;\n",
       "            width: 20px;\n",
       "            height: 20px;\n",
       "            background-image: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAABx0RVh0U29mdHdhcmUAQWRvYmUgRmlyZXdvcmtzIENTNui8sowAAAOkSURBVDiNjZRtaJVlGMd/1/08zzln5zjP1LWcU9N0NkN8m2CYjpgQYQXqSs0I84OLIC0hkEKoPtiH3gmKoiJDU7QpLgoLjLIQCpEsNJ1vqUOdO7ppbuec5+V+rj4ctwzd8IIbbi6u+8f1539dt3A78eXC7QizUF7gyV1fD1Yqg4JWz84yffhm0qkFqBogB9rM8tZdtwVsPUhWhGcFJngGeWrPzHm5oaMmkfEg1usvLFyc8jLRqDOMru7AyC8saQr7GG7f5fvDeH7Ej8CM66nIF+8yngt6HWaKh7k49Soy9nXurCi1o3qUbS3zWfrYeQDTB/Qj6kX6Ybhw4B+bOYoLKCC9H3Nu/leUTZ1JdRWkkn2ldcCamzrcf47KKXdAJllSlxAOkRgyHsGC/zRday5Qld9DyoM4/q/rUoy/CXh3jzOu3bHUVZeU+DEn8FInkPBFlu3+nW3Nw0mk6vCDiWg8CeJaxEwuHS3+z5RgY+YBR6V1Z1nxSOfoaPa4LASWxxdNp+VWTk7+4vzaou8v8PN+xo+KY2xsw6une2frhw05CTYOmQvsEhjhWjn0bmXPjpE1+kplmmkP3suftwTubK9Vq22qKmrBhpY4jvd5afdRA3wGjFAgcnTK2s4hY0/GPNIb0nErGMCRxWOOX64Z8RAC4oCXdklmEvcL8o0BfkNK4lUg9HTl+oPlQxdNo3Mg4Nv175e/1LDGzZen30MEjRUtmXSfiTVu1kK8W4txyV6BMKlbgk3lMwYCiusNy9fVfvvwMxv8Ynl6vxoByANLTWplvuj/nF9m2+PDtt1eiHPBr1oIfhCChQMBw6Aw0UulqTKZdfVvfG7VcfIqLG9bcldL/+pdWTLxLUy8Qq38heUIjh4XlzZxzQm19lLFlr8vdQ97rjZVOLf8nclzckbcD4wxXMidpX30sFd37Fv/GtwwhzhxGVAprjbg0gCAEeIgwCZyTV2Z1REEW8O4py0wsjeloKoMr6iCY6dP92H6Vw/oTyICIthibxjm/DfN9lVz8IqtqKYLUXfoKVMVQVVJOElGjrnnUt9T9wbgp8AyYKaGlqingHZU/uG2NTZSVqwHQTWkx9hxjkpWDaCg6Ckj5qebgBVbT3V3NNXMSiWSDdGV3hrtzla7J+duwPOToIg42ChPQOQjspnSlp1V+Gjdged7+8UN5CRAV7a5EdFNwCjEaBR27b3W890TE7g24NAP/mMDXRWrGoFPQI9ls/MWO2dWFAar/xcOIImbbpA3zgAAAABJRU5ErkJggg==);\n",
       "        }\n",
       "    </style>\n",
       "    <div>\n",
       "        <a href=\"https://bokeh.org\" target=\"_blank\" class=\"bk-notebook-logo\"></a>\n",
       "        <span id=\"c4c6a1ba-48c9-48c7-9be4-c1dba86659cc\">Loading BokehJS ...</span>\n",
       "    </div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function now() {\n    return new Date();\n  }\n\n  const force = true;\n\n  if (typeof root._bokeh_onload_callbacks === \"undefined\" || force === true) {\n    root._bokeh_onload_callbacks = [];\n    root._bokeh_is_loading = undefined;\n  }\n\nconst JS_MIME_TYPE = 'application/javascript';\n  const HTML_MIME_TYPE = 'text/html';\n  const EXEC_MIME_TYPE = 'application/vnd.bokehjs_exec.v0+json';\n  const CLASS_NAME = 'output_bokeh rendered_html';\n\n  /**\n   * Render data to the DOM node\n   */\n  function render(props, node) {\n    const script = document.createElement(\"script\");\n    node.appendChild(script);\n  }\n\n  /**\n   * Handle when an output is cleared or removed\n   */\n  function handleClearOutput(event, handle) {\n    const cell = handle.cell;\n\n    const id = cell.output_area._bokeh_element_id;\n    const server_id = cell.output_area._bokeh_server_id;\n    // Clean up Bokeh references\n    if (id != null && id in Bokeh.index) {\n      Bokeh.index[id].model.document.clear();\n      delete Bokeh.index[id];\n    }\n\n    if (server_id !== undefined) {\n      // Clean up Bokeh references\n      const cmd_clean = \"from bokeh.io.state import curstate; print(curstate().uuid_to_server['\" + server_id + \"'].get_sessions()[0].document.roots[0]._id)\";\n      cell.notebook.kernel.execute(cmd_clean, {\n        iopub: {\n          output: function(msg) {\n            const id = msg.content.text.trim();\n            if (id in Bokeh.index) {\n              Bokeh.index[id].model.document.clear();\n              delete Bokeh.index[id];\n            }\n          }\n        }\n      });\n      // Destroy server and session\n      const cmd_destroy = \"import bokeh.io.notebook as ion; ion.destroy_server('\" + server_id + \"')\";\n      cell.notebook.kernel.execute(cmd_destroy);\n    }\n  }\n\n  /**\n   * Handle when a new output is added\n   */\n  function handleAddOutput(event, handle) {\n    const output_area = handle.output_area;\n    const output = handle.output;\n\n    // limit handleAddOutput to display_data with EXEC_MIME_TYPE content only\n    if ((output.output_type != \"display_data\") || (!Object.prototype.hasOwnProperty.call(output.data, EXEC_MIME_TYPE))) {\n      return\n    }\n\n    const toinsert = output_area.element.find(\".\" + CLASS_NAME.split(' ')[0]);\n\n    if (output.metadata[EXEC_MIME_TYPE][\"id\"] !== undefined) {\n      toinsert[toinsert.length - 1].firstChild.textContent = output.data[JS_MIME_TYPE];\n      // store reference to embed id on output_area\n      output_area._bokeh_element_id = output.metadata[EXEC_MIME_TYPE][\"id\"];\n    }\n    if (output.metadata[EXEC_MIME_TYPE][\"server_id\"] !== undefined) {\n      const bk_div = document.createElement(\"div\");\n      bk_div.innerHTML = output.data[HTML_MIME_TYPE];\n      const script_attrs = bk_div.children[0].attributes;\n      for (let i = 0; i < script_attrs.length; i++) {\n        toinsert[toinsert.length - 1].firstChild.setAttribute(script_attrs[i].name, script_attrs[i].value);\n        toinsert[toinsert.length - 1].firstChild.textContent = bk_div.children[0].textContent\n      }\n      // store reference to server id on output_area\n      output_area._bokeh_server_id = output.metadata[EXEC_MIME_TYPE][\"server_id\"];\n    }\n  }\n\n  function register_renderer(events, OutputArea) {\n\n    function append_mime(data, metadata, element) {\n      // create a DOM node to render to\n      const toinsert = this.create_output_subarea(\n        metadata,\n        CLASS_NAME,\n        EXEC_MIME_TYPE\n      );\n      this.keyboard_manager.register_events(toinsert);\n      // Render to node\n      const props = {data: data, metadata: metadata[EXEC_MIME_TYPE]};\n      render(props, toinsert[toinsert.length - 1]);\n      element.append(toinsert);\n      return toinsert\n    }\n\n    /* Handle when an output is cleared or removed */\n    events.on('clear_output.CodeCell', handleClearOutput);\n    events.on('delete.Cell', handleClearOutput);\n\n    /* Handle when a new output is added */\n    events.on('output_added.OutputArea', handleAddOutput);\n\n    /**\n     * Register the mime type and append_mime function with output_area\n     */\n    OutputArea.prototype.register_mime_type(EXEC_MIME_TYPE, append_mime, {\n      /* Is output safe? */\n      safe: true,\n      /* Index of renderer in `output_area.display_order` */\n      index: 0\n    });\n  }\n\n  // register the mime type if in Jupyter Notebook environment and previously unregistered\n  if (root.Jupyter !== undefined) {\n    const events = require('base/js/events');\n    const OutputArea = require('notebook/js/outputarea').OutputArea;\n\n    if (OutputArea.prototype.mime_types().indexOf(EXEC_MIME_TYPE) == -1) {\n      register_renderer(events, OutputArea);\n    }\n  }\n  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n    root._bokeh_timeout = Date.now() + 5000;\n    root._bokeh_failed_load = false;\n  }\n\n  const NB_LOAD_WARNING = {'data': {'text/html':\n     \"<div style='background-color: #fdd'>\\n\"+\n     \"<p>\\n\"+\n     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n     \"</p>\\n\"+\n     \"<ul>\\n\"+\n     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n     \"</ul>\\n\"+\n     \"<code>\\n\"+\n     \"from bokeh.resources import INLINE\\n\"+\n     \"output_notebook(resources=INLINE)\\n\"+\n     \"</code>\\n\"+\n     \"</div>\"}};\n\n  function display_loaded() {\n    const el = document.getElementById(\"c4c6a1ba-48c9-48c7-9be4-c1dba86659cc\");\n    if (el != null) {\n      el.textContent = \"BokehJS is loading...\";\n    }\n    if (root.Bokeh !== undefined) {\n      if (el != null) {\n        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n      }\n    } else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(display_loaded, 100)\n    }\n  }\n\n  function run_callbacks() {\n    try {\n      root._bokeh_onload_callbacks.forEach(function(callback) {\n        if (callback != null)\n          callback();\n      });\n    } finally {\n      delete root._bokeh_onload_callbacks\n    }\n    console.debug(\"Bokeh: all callbacks have finished\");\n  }\n\n  function load_libs(css_urls, js_urls, callback) {\n    if (css_urls == null) css_urls = [];\n    if (js_urls == null) js_urls = [];\n\n    root._bokeh_onload_callbacks.push(callback);\n    if (root._bokeh_is_loading > 0) {\n      console.debug(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n      return null;\n    }\n    if (js_urls == null || js_urls.length === 0) {\n      run_callbacks();\n      return null;\n    }\n    console.debug(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n    root._bokeh_is_loading = css_urls.length + js_urls.length;\n\n    function on_load() {\n      root._bokeh_is_loading--;\n      if (root._bokeh_is_loading === 0) {\n        console.debug(\"Bokeh: all BokehJS libraries/stylesheets loaded\");\n        run_callbacks()\n      }\n    }\n\n    function on_error(url) {\n      console.error(\"failed to load \" + url);\n    }\n\n    for (let i = 0; i < css_urls.length; i++) {\n      const url = css_urls[i];\n      const element = document.createElement(\"link\");\n      element.onload = on_load;\n      element.onerror = on_error.bind(null, url);\n      element.rel = \"stylesheet\";\n      element.type = \"text/css\";\n      element.href = url;\n      console.debug(\"Bokeh: injecting link tag for BokehJS stylesheet: \", url);\n      document.body.appendChild(element);\n    }\n\n    for (let i = 0; i < js_urls.length; i++) {\n      const url = js_urls[i];\n      const element = document.createElement('script');\n      element.onload = on_load;\n      element.onerror = on_error.bind(null, url);\n      element.async = false;\n      element.src = url;\n      console.debug(\"Bokeh: injecting script tag for BokehJS library: \", url);\n      document.head.appendChild(element);\n    }\n  };\n\n  function inject_raw_css(css) {\n    const element = document.createElement(\"style\");\n    element.appendChild(document.createTextNode(css));\n    document.body.appendChild(element);\n  }\n\n  const js_urls = [\"https://cdn.bokeh.org/bokeh/release/bokeh-3.2.2.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-gl-3.2.2.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-3.2.2.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-3.2.2.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-mathjax-3.2.2.min.js\"];\n  const css_urls = [];\n\n  const inline_js = [    function(Bokeh) {\n      Bokeh.set_log_level(\"info\");\n    },\nfunction(Bokeh) {\n    }\n  ];\n\n  function run_inline_js() {\n    if (root.Bokeh !== undefined || force === true) {\n          for (let i = 0; i < inline_js.length; i++) {\n      inline_js[i].call(root, root.Bokeh);\n    }\nif (force === true) {\n        display_loaded();\n      }} else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(run_inline_js, 100);\n    } else if (!root._bokeh_failed_load) {\n      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n      root._bokeh_failed_load = true;\n    } else if (force !== true) {\n      const cell = $(document.getElementById(\"c4c6a1ba-48c9-48c7-9be4-c1dba86659cc\")).parents('.cell').data().cell;\n      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n    }\n  }\n\n  if (root._bokeh_is_loading === 0) {\n    console.debug(\"Bokeh: BokehJS loaded, going straight to plotting\");\n    run_inline_js();\n  } else {\n    load_libs(css_urls, js_urls, function() {\n      console.debug(\"Bokeh: BokehJS plotting callback run at\", now());\n      run_inline_js();\n    });\n  }\n}(window));",
      "application/vnd.bokehjs_load.v0+json": ""
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n",
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"d19340c3-3633-4540-9c9f-83a7b642f75f\" data-root-id=\"p1223\" style=\"display: contents;\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function embed_document(root) {\n  const docs_json = {\"cb5182ef-49d5-4951-87af-1a1629ea3309\":{\"version\":\"3.2.2\",\"title\":\"Bokeh Application\",\"roots\":[{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1223\",\"attributes\":{\"width\":500,\"height\":500,\"x_range\":{\"type\":\"object\",\"name\":\"Range1d\",\"id\":\"p1232\",\"attributes\":{\"start\":-0.5,\"end\":2.5}},\"y_range\":{\"type\":\"object\",\"name\":\"DataRange1d\",\"id\":\"p1225\"},\"x_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1233\"},\"y_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1234\"},\"title\":{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1230\",\"attributes\":{\"text_font\":\"Helvetica\"}},\"renderers\":[{\"type\":\"object\",\"name\":\"Span\",\"id\":\"p1248\",\"attributes\":{\"location\":0,\"line_alpha\":0.2,\"line_width\":2,\"line_dash\":[6]}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1258\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1217\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1218\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1219\"},\"data\":{\"type\":\"map\",\"entries\":[[\"mins\",[0.01961380518731942,0.09535622518117375,0.0]],[\"maxes\",[0.25284934394230096,0.32317512117434327,0.23414672509906992]],[\"means\",[0.1900744063434108,0.25389257896198214,0.17366140080813267]],[\"min_asset\",[\"Intellectual Property\",\"Equipment\",\"Intellectual Property\"]],[\"max_asset\",[\"Inventories\",\"Inventories\",\"Inventories\"]],[\"mean_asset\",[\"Overall\",\"Overall\",\"Overall\"]],[\"types\",[\"Typically Financed\",\"Debt Financed\",\"Equity Financed\"]],[\"positions\",[-0.1,0.9,1.9]]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1259\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1260\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1255\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1256\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1257\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"line_width\":{\"type\":\"value\",\"value\":2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1267\",\"attributes\":{\"data_source\":{\"id\":\"p1217\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1268\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1269\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1264\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1265\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1266\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1278\",\"attributes\":{\"data_source\":{\"id\":\"p1217\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1279\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1280\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1275\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1276\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1277\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1287\",\"attributes\":{\"data_source\":{\"id\":\"p1217\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1288\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1289\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1284\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1285\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1286\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1296\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1220\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1221\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1222\"},\"data\":{\"type\":\"map\",\"entries\":[[\"mins\",[0.06965591540885105,0.1073340807100192,0.06060027444109623]],[\"maxes\",[0.294710491330277,0.3395042664417007,0.28340964701450294]],[\"means\",[0.23670677626297182,0.2689805545280029,0.22916817814726334]],[\"min_asset\",[\"Intellectual Property\",\"Intellectual Property\",\"Intellectual Property\"]],[\"max_asset\",[\"Inventories\",\"Inventories\",\"Inventories\"]],[\"mean_asset\",[\"Overall\",\"Overall\",\"Overall\"]],[\"types\",[\"Typically Financed\",\"Debt Financed\",\"Equity Financed\"]],[\"positions\",[0.1,1.1,2.1]]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1297\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1298\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1293\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1294\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"line_width\":{\"type\":\"value\",\"value\":2}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Segment\",\"id\":\"p1295\",\"attributes\":{\"x0\":{\"type\":\"field\",\"field\":\"positions\"},\"y0\":{\"type\":\"field\",\"field\":\"mins\"},\"x1\":{\"type\":\"field\",\"field\":\"positions\"},\"y1\":{\"type\":\"field\",\"field\":\"maxes\"},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"line_width\":{\"type\":\"value\",\"value\":2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1305\",\"attributes\":{\"data_source\":{\"id\":\"p1220\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1306\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1307\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1302\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1303\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1304\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"means\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1315\",\"attributes\":{\"data_source\":{\"id\":\"p1220\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1316\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1317\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1312\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1313\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1314\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"mins\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}},{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1324\",\"attributes\":{\"data_source\":{\"id\":\"p1220\"},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1325\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1326\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1321\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1322\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1323\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"positions\"},\"y\":{\"type\":\"field\",\"field\":\"maxes\"},\"size\":{\"type\":\"value\",\"value\":12},\"line_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}}],\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1231\"},\"toolbar_location\":null,\"left\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1240\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1241\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"NumeralTickFormatter\",\"id\":\"p1247\",\"attributes\":{\"format\":\"0%\"}},\"axis_label\":\"Marginal Effective Total Tax Rate\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1243\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1235\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"FixedTicker\",\"id\":\"p1245\",\"attributes\":{\"ticks\":[0,1,2],\"minor_ticks\":[]}},\"formatter\":{\"type\":\"object\",\"name\":\"CustomJSTickFormatter\",\"id\":\"p1246\",\"attributes\":{\"code\":\"\\n        var types = [\\\"Typically Financed\\\", \\\"Debt Financed\\\", \\\"Equity Financed\\\"]\\n        return types[tick]\\n        \"}},\"axis_label\":\"Method of Financing\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1238\"}}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1239\",\"attributes\":{\"axis\":{\"id\":\"p1235\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1244\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1240\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1249\",\"attributes\":{\"right\":0.5,\"fill_color\":\"white\",\"fill_alpha\":0.2}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1250\",\"attributes\":{\"left\":0.5,\"right\":1.5,\"fill_color\":\"white\",\"fill_alpha\":0.1}},{\"type\":\"object\",\"name\":\"BoxAnnotation\",\"id\":\"p1251\",\"attributes\":{\"left\":1.5,\"fill_color\":\"white\",\"fill_alpha\":0.2}},{\"type\":\"object\",\"name\":\"Legend\",\"id\":\"p1270\",\"attributes\":{\"location\":\"bottom_right\",\"items\":[{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1271\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Baseline\"},\"renderers\":[{\"id\":\"p1267\"},{\"id\":\"p1278\"},{\"id\":\"p1287\"}]}},{\"type\":\"object\",\"name\":\"LegendItem\",\"id\":\"p1308\",\"attributes\":{\"label\":{\"type\":\"value\",\"value\":\"Reform\"},\"renderers\":[{\"id\":\"p1305\"},{\"id\":\"p1315\"},{\"id\":\"p1324\"}]}}]}}]}}]}};\n  const render_items = [{\"docid\":\"cb5182ef-49d5-4951-87af-1a1629ea3309\",\"roots\":{\"p1223\":\"d19340c3-3633-4540-9c9f-83a7b642f75f\"},\"root_ids\":[\"p1223\"]}];\n  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n  }\n  if (root.Bokeh !== undefined) {\n    embed_document(root);\n  } else {\n    let attempts = 0;\n    const timer = setInterval(function(root) {\n      if (root.Bokeh !== undefined) {\n        clearInterval(timer);\n        embed_document(root);\n      } else {\n        attempts++;\n        if (attempts > 100) {\n          clearInterval(timer);\n          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n        }\n      }\n    }, 10, root)\n  }\n})(window);",
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "p1223"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plot to show variation in METTRs across assets\n",
    "output_notebook()\n",
    "rplot2 = calc1.range_plot(calc2, corporate=False, output_variable='mettr')\n",
    "show(rplot2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There's a bubble plot too, though it doesn't yet allow for many options (currently only plots METTRs for corporate entities):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deprec_df                                 value  asset_name BEA_code  \\\n",
      "0  {'life': 5.0, 'method': 'DB 200%'}  Mainframes     EP1A   \n",
      "1  {'life': 5.0, 'method': 'DB 200%'}         PCs     EP1B   \n",
      "2  {'life': 5.0, 'method': 'DB 200%'}       DASDs     EP1C   \n",
      "3  {'life': 5.0, 'method': 'DB 200%'}    Printers     EP1D   \n",
      "4  {'life': 5.0, 'method': 'DB 200%'}   Terminals     EP1E   \n",
      "\n",
      "        minor_asset_group major_asset_group  ADS_life  GDS_life system  year  \n",
      "0  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "1  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "2  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "3  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "4  Computers and Software         Equipment       5.0       5.0    GDS  2020  \n",
      "deprec_df 2    asset_name BEA_code       minor_asset_group major_asset_group  ADS_life  \\\n",
      "0  Mainframes     EP1A  Computers and Software         Equipment       5.0   \n",
      "1         PCs     EP1B  Computers and Software         Equipment       5.0   \n",
      "2       DASDs     EP1C  Computers and Software         Equipment       5.0   \n",
      "3    Printers     EP1D  Computers and Software         Equipment       5.0   \n",
      "4   Terminals     EP1E  Computers and Software         Equipment       5.0   \n",
      "\n",
      "   GDS_life system  year  life   method  \n",
      "0       5.0    GDS  2020   5.0  DB 200%  \n",
      "1       5.0    GDS  2020   5.0  DB 200%  \n",
      "2       5.0    GDS  2020   5.0  DB 200%  \n",
      "3       5.0    GDS  2020   5.0  DB 200%  \n",
      "4       5.0    GDS  2020   5.0  DB 200%  \n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "WARNING:bokeh.core.validation.check:W-1000 (MISSING_RENDERERS): Plot has no renderers: figure(id='p1434', ...)\n",
      "WARNING:bokeh.core.validation.check:W-1000 (MISSING_RENDERERS): Plot has no renderers: figure(id='p1373', ...)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "  <div id=\"cc1b9947-210f-40bf-8acd-59296187df05\" data-root-id=\"p1461\" style=\"display: contents;\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": "(function(root) {\n  function embed_document(root) {\n  const docs_json = {\"80224bc2-2aea-4e79-9ed8-1099e2f59515\":{\"version\":\"3.2.2\",\"title\":\"Bokeh Application\",\"roots\":[{\"type\":\"object\",\"name\":\"Tabs\",\"id\":\"p1461\",\"attributes\":{\"tabs\":[{\"type\":\"object\",\"name\":\"TabPanel\",\"id\":\"p1458\",\"attributes\":{\"title\":\"Equipment\",\"child\":{\"type\":\"object\",\"name\":\"Column\",\"id\":\"p1457\",\"attributes\":{\"children\":[{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1333\",\"attributes\":{\"width\":990,\"height\":540,\"x_range\":{\"type\":\"object\",\"name\":\"Range1d\",\"id\":\"p1342\",\"attributes\":{\"start\":-0.05,\"end\":0.51}},\"y_range\":{\"type\":\"object\",\"name\":\"FactorRange\",\"id\":\"p1343\",\"attributes\":{\"factors\":[\"Other\",\"Other Industrial\",\"Industrial Machinery\",\"Transportation\",\"Office and Residential\",\"Instruments and Communications\",\"Computers and Software\"]}},\"x_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1344\"},\"y_scale\":{\"type\":\"object\",\"name\":\"CategoricalScale\",\"id\":\"p1345\"},\"title\":{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1340\"},\"outline_line_color\":\"black\",\"outline_line_width\":1,\"renderers\":[{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1367\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1358\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1359\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1360\"},\"data\":{\"type\":\"map\",\"entries\":[[\"index\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"AAAAAAEAAAACAAAAAwAAAAQAAAAFAAAABgAAAAcAAAAIAAAACQAAAAoAAAALAAAADAAAAA0AAAAOAAAADwAAABAAAAARAAAAEgAAABMAAAAUAAAAFQAAABYAAAAXAAAAGAAAABkAAAAaAAAAGwAAABwAAAAdAAAAHgAAAB8AAAAgAAAAIQAAACIAAAAjAAAAJAAAACUAAAAmAAAAJwAAACgAAADGAAAAxwAAAMgAAADOAAAAzwAAANAAAADTAAAA\"},\"shape\":[48],\"dtype\":\"int32\",\"order\":\"little\"}],[\"baseline\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"EHXT6LtGsT+7dNPou0axP8V00+i7RrE/u3TT6LtGsT+ydNPou0axP6l00+i7RrE/u3TT6LtGsT+ydNPou0axP6l00+i7RrE/u3TT6LtGsT/hdNPou0axP7t00+i7RrE/qXTT6LtGsT/XdNPou0axP+F00+i7RrE/4XTT6LtGsT/OdNPou0axP9d00+i7RrE/znTT6LtGsT/FdNPou0axP8V00+i7RrE/4XTT6LtGsT/OdNPou0axP9d00+i7RrE/BnXT6LtGsT/hdNPou0axP+F00+i7RrE/xXTT6LtGsT/OdNPou0axP+F00+i7RrE/13TT6LtGsT/qdNPou0axP8500+i7RrE/6nTT6LtGsT/hdNPou0axP9d00+i7RrE/znTT6LtGsT+7dNPou0axP9d00+i7RrE/6nTT6LtGsT/XdNPou0axP8V00+i7RrE/xXTT6LtGsT/XdNPou0axP8V00+i7RrE/4XTT6LtGsT/XdNPou0axP9d00+i7RrE/\"},\"shape\":[48],\"dtype\":\"float64\",\"order\":\"little\"}],[\"size\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"IwAAADIAAAAUAAAAIwAAABQAAAAUAAAAFAAAABQAAAAUAAAAIwAAADIAAABBAAAAFAAAAEEAAAAUAAAAMgAAACMAAAAjAAAAFAAAADIAAAAUAAAAIwAAABQAAAAyAAAAFAAAACMAAAAyAAAAQQAAABQAAAAUAAAAIwAAADIAAAAjAAAAIwAAABQAAAAyAAAAIwAAADIAAAAyAAAAIwAAACMAAABBAAAAQQAAAEEAAAAyAAAAMgAAAEEAAABBAAAA\"},\"shape\":[48],\"dtype\":\"int32\",\"order\":\"little\"}],[\"hover\",{\"type\":\"ndarray\",\"array\":[\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\"],\"shape\":[48],\"dtype\":\"object\",\"order\":\"little\"}],[\"assets\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"guiTRJDTMELUVaUIN/ZGQh+VzBinNxBCqeCRDsHvKEIAAAAAAAAAAFNzOHSIPwFCsBvVAVkXB0IAAAAAAAAAADUokQduzP1BeWM0iaxdGkIJ/Fm/uylQQqBKFSw0u1tCugfwReMT+0EDAkHtxwFdQiG4dVx1TRdCKpXJY/oEP0K8yX5/UXkxQqw/XGX+OjlCI5M5K0SUAEIHwQQ+J3hHQgIRiof0juRB9Dhz5OZvN0Jh54bUKFUPQnIrSU8wkElC4ljVPToM+EF4baBsU147Qvrg35pve0lCuZZFXPKlWELZEUQaZeAWQg5fNzePbgJC/EhZQAzFJULNGx/XE8Y8QpXTvLf6wTNCZi6+73dWNULjDFXOJQcHQrt8k/J2g0NCIy4brJ/VO0J1opjchrg/QoQzxAY9905CcwcfBRFDLUJ6zQEMnmM5QsKhOLU1MVdCVaO39XfyZUKkoiSxoKhoQn2C1lKn00hCMZtlJ7ueU0KCjHryx7tuQkmqbzYCGGxC\"},\"shape\":[48],\"dtype\":\"float64\",\"order\":\"little\"}],[\"short_category\",{\"type\":\"ndarray\",\"array\":[\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Computers and Software\",\"Industrial Machinery\",\"Industrial Machinery\",\"Instruments and Communications\",\"Instruments and Communications\",\"Instruments and Communications\",\"Instruments and Communications\",\"Instruments and Communications\",\"Instruments and Communications\",\"Office and Residential\",\"Office and Residential\",\"Office and Residential\",\"Other\",\"Other\",\"Other\",\"Other Industrial\",\"Other Industrial\",\"Other Industrial\",\"Other Industrial\",\"Other Industrial\",\"Other Industrial\",\"Other Industrial\",\"Other Industrial\",\"Other Industrial\",\"Transportation\",\"Transportation\",\"Transportation\",\"Transportation\",\"Transportation\",\"Transportation\",\"Transportation\",\"Transportation\",\"Computers and Software\",\"Industrial Machinery\",\"Instruments and Communications\",\"Office and Residential\",\"Other\",\"Other Industrial\",\"Transportation\"],\"shape\":[48],\"dtype\":\"object\",\"order\":\"little\"}],[\"asset_name\",{\"type\":\"ndarray\",\"array\":[\"Prepackaged software\",\"Custom software\",\"Mainframes\",\"PCs\",\"DASDs\",\"Printers\",\"Terminals\",\"Tape drives\",\"Storage devices\",\"System integrators\",\"Special industrial machinery\",\"General industrial equipment\",\"Office and accounting equipment\",\"Communications\",\"Photocopy and related equipment\",\"Nonelectro medical instruments\",\"Electro medical instruments\",\"Nonmedical instruments\",\"Household furniture\",\"Other furniture\",\"Household appliances\",\"Service industry machinery\",\"Other electrical\",\"Other\",\"Nuclear fuel\",\"Other fabricated metals\",\"Metalworking machinery\",\"Electric transmission and distribution\",\"Farm tractors\",\"Construction tractors\",\"Other agricultural machinery\",\"Other construction machinery\",\"Mining and oilfield machinery\",\"Steam engines\",\"Internal combustion engines\",\"Light trucks (including utility vehicles)\",\"Other trucks, buses and truck trailers\",\"Autos\",\"Aircraft\",\"Ships and boats\",\"Railroad equipment\",\"Computers and Software\",\"Industrial Machinery\",\"Instruments and Communications Equipment\",\"Office and Residential Equipment\",\"Other Equipment\",\"Other Industrial Equipment\",\"Transportation Equipment\"],\"shape\":[48],\"dtype\":\"object\",\"order\":\"little\"}]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1368\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1369\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1364\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"baseline\"},\"y\":{\"type\":\"field\",\"field\":\"short_category\"},\"size\":{\"type\":\"field\",\"field\":\"size\"},\"line_color\":{\"type\":\"value\",\"value\":\"#333333\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.4},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.4}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1365\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"baseline\"},\"y\":{\"type\":\"field\",\"field\":\"short_category\"},\"size\":{\"type\":\"field\",\"field\":\"size\"},\"line_color\":{\"type\":\"value\",\"value\":\"#333333\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1366\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"baseline\"},\"y\":{\"type\":\"field\",\"field\":\"short_category\"},\"size\":{\"type\":\"field\",\"field\":\"size\"},\"line_color\":{\"type\":\"value\",\"value\":\"#333333\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#718dbf\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}}],\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1341\",\"attributes\":{\"tools\":[{\"type\":\"object\",\"name\":\"HoverTool\",\"id\":\"p1356\",\"attributes\":{\"renderers\":\"auto\",\"tooltips\":[[\"Asset\",\" @asset_name (@hover)\"]]}}]}},\"toolbar_location\":null,\"left\":[{\"type\":\"object\",\"name\":\"CategoricalAxis\",\"id\":\"p1351\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"CategoricalTicker\",\"id\":\"p1352\"},\"formatter\":{\"type\":\"object\",\"name\":\"CategoricalTickFormatter\",\"id\":\"p1353\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1354\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1346\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1347\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"NumeralTickFormatter\",\"id\":\"p1357\",\"attributes\":{\"format\":\"0.1%\"}},\"axis_label\":\"Marginal Effective Tax Rate\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1349\"},\"major_tick_line_color\":\"firebrick\",\"major_tick_line_width\":3,\"minor_tick_line_color\":\"orange\"}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1350\",\"attributes\":{\"axis\":{\"id\":\"p1346\"}}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1355\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1351\"}}}],\"background_fill_alpha\":0,\"border_fill_alpha\":0,\"min_border_top\":5,\"min_border_bottom\":0,\"min_border_left\":0,\"min_border_right\":5}},{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1373\",\"attributes\":{\"width\":380,\"height\":150,\"x_range\":{\"type\":\"object\",\"name\":\"Range1d\",\"id\":\"p1383\",\"attributes\":{\"start\":-0.075,\"end\":75}},\"y_range\":{\"type\":\"object\",\"name\":\"DataRange1d\",\"id\":\"p1375\"},\"x_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1384\"},\"y_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1385\"},\"title\":{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1376\",\"attributes\":{\"text\":\"Asset Amount\"}},\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1382\",\"attributes\":{\"active_drag\":null}},\"left\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1391\",\"attributes\":{\"visible\":false,\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1392\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"BasicTickFormatter\",\"id\":\"p1393\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1394\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1386\",\"attributes\":{\"visible\":false,\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1387\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"BasicTickFormatter\",\"id\":\"p1388\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1389\"}}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1390\",\"attributes\":{\"axis\":{\"id\":\"p1386\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1395\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1391\"},\"grid_line_color\":null}}]}}]}}}},{\"type\":\"object\",\"name\":\"TabPanel\",\"id\":\"p1460\",\"attributes\":{\"title\":\"Structures\",\"child\":{\"type\":\"object\",\"name\":\"Column\",\"id\":\"p1459\",\"attributes\":{\"children\":[{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1396\",\"attributes\":{\"width\":990,\"height\":540,\"x_range\":{\"type\":\"object\",\"name\":\"Range1d\",\"id\":\"p1405\",\"attributes\":{\"start\":-0.05,\"end\":0.51}},\"y_range\":{\"type\":\"object\",\"name\":\"FactorRange\",\"id\":\"p1406\",\"attributes\":{\"factors\":[\"Other\",\"Mining and Drilling\",\"Nonresidential Bldgs\",\"Residential Bldgs\"]}},\"x_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1407\"},\"y_scale\":{\"type\":\"object\",\"name\":\"CategoricalScale\",\"id\":\"p1408\"},\"title\":{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1403\"},\"outline_line_color\":\"black\",\"outline_line_width\":1,\"renderers\":[{\"type\":\"object\",\"name\":\"GlyphRenderer\",\"id\":\"p1431\",\"attributes\":{\"data_source\":{\"type\":\"object\",\"name\":\"ColumnDataSource\",\"id\":\"p1422\",\"attributes\":{\"selected\":{\"type\":\"object\",\"name\":\"Selection\",\"id\":\"p1423\",\"attributes\":{\"indices\":[],\"line_indices\":[]}},\"selection_policy\":{\"type\":\"object\",\"name\":\"UnionRenderers\",\"id\":\"p1424\"},\"data\":{\"type\":\"map\",\"entries\":[[\"index\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"QgAAAEMAAABEAAAARQAAAEYAAABHAAAASAAAAEkAAABKAAAASwAAAEwAAABNAAAATgAAAE8AAABQAAAAUQAAAFIAAABTAAAAVAAAAFUAAABWAAAAVwAAAFgAAABZAAAAWgAAAFsAAABcAAAAXQAAAF4AAABfAAAAYAAAAGEAAABiAAAAzAAAAM0AAADRAAAA0gAAAOYAAAA=\"},\"shape\":[38],\"dtype\":\"int32\",\"order\":\"little\"}],[\"baseline\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"13TT6LtGsT/OdNPou0axP9d00+i7RrE/13TT6LtGsT/OdNPou0axP+fhFPjmNc0/JwMdP1Hkzz8kAx0/UeTPPx4DHT9R5M8/c4J8FjUu0T/2RZxYuprQP/ZFnFi6mtA/Ha0mzt9x0D/7B24X9+7QP/sHbhf37tA/+AduF/fu0D9KDPNEfJrRP/ZFnFi6mtA/BA2fU5C80D8BDZ9TkLzQP8V00+i7RrE/9kWcWLqa0D/hdNPou0axP+p00+i7RrE/xXTT6LtGsT/FdNPou0axP9d00+i7RrE/6nTT6LtGsT/XdNPou0axP+F00+i7RrE/4XTT6LtGsT/XdNPou0axPzoRzCBzVMw/4XTT6LtGsT8XCmvq8dPQPwABULYJlbE/OhHMIHNUzD/NcB+Rlo7HPw==\"},\"shape\":[38],\"dtype\":\"float64\",\"order\":\"little\"}],[\"size\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"QQAAACMAAABBAAAAQQAAACMAAAAjAAAAMgAAADIAAAAjAAAAMgAAABQAAAAUAAAAMgAAAEEAAABBAAAAMgAAAEEAAAAUAAAAQQAAACMAAAAyAAAAFAAAABQAAAAjAAAAIwAAACMAAAAUAAAAFAAAADIAAAAyAAAAQQAAACMAAAAyAAAAQQAAAEEAAABBAAAAMgAAAEEAAAA=\"},\"shape\":[38],\"dtype\":\"int32\",\"order\":\"little\"}],[\"hover\",{\"type\":\"ndarray\",\"array\":[\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"22.8%\",\"24.9%\",\"24.9%\",\"24.9%\",\"26.8%\",\"25.9%\",\"25.9%\",\"25.7%\",\"26.5%\",\"26.5%\",\"26.5%\",\"27.5%\",\"25.9%\",\"26.2%\",\"26.2%\",\"6.7%\",\"25.9%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"6.7%\",\"22.1%\",\"6.7%\",\"26.3%\",\"6.9%\",\"22.1%\",\"18.4%\"],\"shape\":[38],\"dtype\":\"object\",\"order\":\"little\"}],[\"assets\",{\"type\":\"ndarray\",\"array\":{\"type\":\"bytes\",\"data\":\"CutnFoQQbkIn2/YTB08zQmsOf4v/12BCfauIB/JGVUICaE2K2zg6Qk6mU7+xazdCQFAJgQd1UELL3wr5NbZSQuSjwho4UzBCbQ/IMFIAREI5PljRFdgYQr7TSpuZbOpBQLCdyW9hUEIrC9WI/fVTQm1dNBnYtFhCHnzs81WwREK1mcrM+/VvQv0QKJNU2QxCXSWGDU5gcEJ2TVJnIE45QiF+yETx/kJCtoo7oTY8AUJRGk1QREH6QY43N1HrfzlClBEs+aI5I0LOPwst3IghQlFkGCc/VBVCBWWY6mqK8UE2nye97J4/Qr7Hx03mYENCXZBtIAehbkJKsbxg2MY7QgCAUcSobVNCzOu5fHyef0J4LdDolo6QQh0CxpuCNHtCAIBRxKhtU0J4oJqdGD2gQg==\"},\"shape\":[38],\"dtype\":\"float64\",\"order\":\"little\"}],[\"short_category\",{\"type\":\"ndarray\",\"array\":[\"Mining and Drilling\",\"Mining and Drilling\",\"Mining and Drilling\",\"Mining and Drilling\",\"Mining and Drilling\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Nonresidential Bldgs\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"Other\",\"                          Residential Bldgs\",\"Mining and Drilling\",\"Nonresidential Bldgs\",\"Other\",\"                          Residential Bldgs\",\"Structures\"],\"shape\":[38],\"dtype\":\"object\",\"order\":\"little\"}],[\"asset_name\",{\"type\":\"ndarray\",\"array\":[\"Petroleum and natural gas\",\"Mining\",\"Communication\",\"Gas\",\"Petroleum pipelines\",\"Religious\",\"Educational and vocational\",\"Hospitals\",\"Special care\",\"Lodging\",\"Air transportation\",\"Other transportation\",\"Warehouses\",\"Other commercial\",\"Multimerchandise shopping\",\"Food and beverage establishments\",\"Manufacturing\",\"Public safety\",\"Office\",\"Medical buildings\",\"Amusement and recreation\",\"Local transit structures\",\"Other land transportation\",\"Farm\",\"Water supply\",\"Sewage and waste disposal\",\"Highway and conservation and development\",\"Mobile structures\",\"Other railroad\",\"Track replacement\",\"Electric\",\"Wind and solar\",\"Residential\",\"Mining and Drilling Structures\",\"Nonresidential Buildings\",\"Other Structures\",\"Residential Buildings\",\"Structures\"],\"shape\":[38],\"dtype\":\"object\",\"order\":\"little\"}]]}}},\"view\":{\"type\":\"object\",\"name\":\"CDSView\",\"id\":\"p1432\",\"attributes\":{\"filter\":{\"type\":\"object\",\"name\":\"AllIndices\",\"id\":\"p1433\"}}},\"glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1428\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"baseline\"},\"y\":{\"type\":\"field\",\"field\":\"short_category\"},\"size\":{\"type\":\"field\",\"field\":\"size\"},\"line_color\":{\"type\":\"value\",\"value\":\"#333333\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.4},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.4},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.4}}},\"nonselection_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1429\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"baseline\"},\"y\":{\"type\":\"field\",\"field\":\"short_category\"},\"size\":{\"type\":\"field\",\"field\":\"size\"},\"line_color\":{\"type\":\"value\",\"value\":\"#333333\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.1},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.1},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.1}}},\"muted_glyph\":{\"type\":\"object\",\"name\":\"Circle\",\"id\":\"p1430\",\"attributes\":{\"x\":{\"type\":\"field\",\"field\":\"baseline\"},\"y\":{\"type\":\"field\",\"field\":\"short_category\"},\"size\":{\"type\":\"field\",\"field\":\"size\"},\"line_color\":{\"type\":\"value\",\"value\":\"#333333\"},\"line_alpha\":{\"type\":\"value\",\"value\":0.2},\"fill_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"fill_alpha\":{\"type\":\"value\",\"value\":0.2},\"hatch_color\":{\"type\":\"value\",\"value\":\"#e84d60\"},\"hatch_alpha\":{\"type\":\"value\",\"value\":0.2}}}}}],\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1404\",\"attributes\":{\"tools\":[{\"type\":\"object\",\"name\":\"HoverTool\",\"id\":\"p1419\",\"attributes\":{\"renderers\":\"auto\",\"tooltips\":[[\"Asset\",\" @asset_name (@hover)\"]]}}]}},\"toolbar_location\":null,\"left\":[{\"type\":\"object\",\"name\":\"CategoricalAxis\",\"id\":\"p1414\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"CategoricalTicker\",\"id\":\"p1415\"},\"formatter\":{\"type\":\"object\",\"name\":\"CategoricalTickFormatter\",\"id\":\"p1416\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1417\"}}}],\"above\":[{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1420\",\"attributes\":{\"text\":\"Marginal Effective Tax Rates on Corporate Investments in Structures\",\"text_color\":\"#6B6B73\",\"text_font\":\"Helvetica\",\"text_font_size\":\"9pt\",\"align\":\"center\"}}],\"below\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1409\",\"attributes\":{\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1410\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"NumeralTickFormatter\",\"id\":\"p1421\",\"attributes\":{\"format\":\"0.1%\"}},\"axis_label\":\"Marginal Effective Tax Rate\",\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1412\"},\"major_tick_line_color\":\"firebrick\",\"major_tick_line_width\":3,\"minor_tick_line_color\":\"orange\"}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1413\",\"attributes\":{\"axis\":{\"id\":\"p1409\"}}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1418\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1414\"}}}],\"background_fill_alpha\":0,\"border_fill_alpha\":0,\"min_border_top\":5,\"min_border_bottom\":0,\"min_border_left\":0,\"min_border_right\":5}},{\"type\":\"object\",\"name\":\"Figure\",\"id\":\"p1434\",\"attributes\":{\"width\":380,\"height\":150,\"x_range\":{\"type\":\"object\",\"name\":\"Range1d\",\"id\":\"p1444\",\"attributes\":{\"start\":-0.075,\"end\":0.75}},\"y_range\":{\"type\":\"object\",\"name\":\"DataRange1d\",\"id\":\"p1436\"},\"x_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1445\"},\"y_scale\":{\"type\":\"object\",\"name\":\"LinearScale\",\"id\":\"p1446\"},\"title\":{\"type\":\"object\",\"name\":\"Title\",\"id\":\"p1437\",\"attributes\":{\"text\":\"Asset Amount\"}},\"toolbar\":{\"type\":\"object\",\"name\":\"Toolbar\",\"id\":\"p1443\",\"attributes\":{\"active_drag\":null}},\"left\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1452\",\"attributes\":{\"visible\":false,\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1453\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"BasicTickFormatter\",\"id\":\"p1454\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1455\"}}}],\"below\":[{\"type\":\"object\",\"name\":\"LinearAxis\",\"id\":\"p1447\",\"attributes\":{\"visible\":false,\"ticker\":{\"type\":\"object\",\"name\":\"BasicTicker\",\"id\":\"p1448\",\"attributes\":{\"mantissas\":[1,2,5]}},\"formatter\":{\"type\":\"object\",\"name\":\"BasicTickFormatter\",\"id\":\"p1449\"},\"major_label_policy\":{\"type\":\"object\",\"name\":\"AllLabels\",\"id\":\"p1450\"}}}],\"center\":[{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1451\",\"attributes\":{\"axis\":{\"id\":\"p1447\"},\"grid_line_color\":null}},{\"type\":\"object\",\"name\":\"Grid\",\"id\":\"p1456\",\"attributes\":{\"dimension\":1,\"axis\":{\"id\":\"p1452\"},\"grid_line_color\":null}}]}}]}}}}]}}]}};\n  const render_items = [{\"docid\":\"80224bc2-2aea-4e79-9ed8-1099e2f59515\",\"roots\":{\"p1461\":\"cc1b9947-210f-40bf-8acd-59296187df05\"},\"root_ids\":[\"p1461\"]}];\n  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n  }\n  if (root.Bokeh !== undefined) {\n    embed_document(root);\n  } else {\n    let attempts = 0;\n    const timer = setInterval(function(root) {\n      if (root.Bokeh !== undefined) {\n        clearInterval(timer);\n        embed_document(root);\n      } else {\n        attempts++;\n        if (attempts > 100) {\n          clearInterval(timer);\n          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n        }\n      }\n    }, 10, root)\n  }\n})(window);",
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "p1461"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "bplot = calc1.asset_bubble(calc2)\n",
    "show(bplot)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Summary\n",
    "\n",
    "This notebook provides a brief example of how one would work with CCC.  Please explore the source code to see additional flexiblity in the functions.  And please leave any questions or suggestions in the CCC repo at [https://github.com/PSLmodels/Cost-of-Capital-Calculator/issues](https://github.com/PSLmodels/Cost-of-Capital-Calculator/issues)."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}