change_speed_metrics.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2\n",
    "NUM_CORES = 4"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Test single SQL query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Running all queries\n",
      "All queries done\n"
     ]
    }
   ],
   "source": [
    "from change_detection import *\n",
    "x = ChangeDetection('testing',verbose=False)\n",
    "x.num_cores = NUM_CORES\n",
    "x.run()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Single measure"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "from change_detection import *\n",
    "lp = ChangeDetection('practice_data_lpfentanylir',\n",
    "                    measure=True,\n",
    "                    sample=False,\n",
    "                    verbose=True)\n",
    "lp.num_cores = NUM_CORES\n",
    "lp.run()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Measures - low-priority CCG level"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "from change_detection import *\n",
    "lp = ChangeDetection('ccg_data_lp%',\n",
    "                    measure=True,\n",
    "                    sample=False,\n",
    "                    verbose=False)\n",
    "lp.num_cores = NUM_CORES\n",
    "lp.run()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Measures - low-priority practice level"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "from change_detection import *\n",
    "lp = ChangeDetection('practice_data_lp%',\n",
    "                    measure=True,\n",
    "                    sample=False,\n",
    "                    verbose=False)\n",
    "lp.run()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Measures - opioids practice level"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from change_detection import *\n",
    "opioids = ChangeDetection('practice_data_opi%',\n",
    "                          measure=True,\n",
    "                          sample=True,\n",
    "                          verbose=False)\n",
    "opioids.num_cores = NUM_CORES\n",
    "opioids.run()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "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>is.nbreak</th>\n",
       "      <th>is.tfirst</th>\n",
       "      <th>is.tfirst.pknown</th>\n",
       "      <th>is.tfirst.pknown.offs</th>\n",
       "      <th>is.tfirst.offs</th>\n",
       "      <th>is.tfirst.big</th>\n",
       "      <th>is.slope.ma</th>\n",
       "      <th>is.slope.ma.prop</th>\n",
       "      <th>is.slope.ma.prop.lev</th>\n",
       "      <th>is.intlev.initlev</th>\n",
       "      <th>is.intlev.finallev</th>\n",
       "      <th>is.intlev.levd</th>\n",
       "      <th>is.intlev.levdprop</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>measure</th>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">practice_data_opioidome</th>\n",
       "      <th>A81057</th>\n",
       "      <td>1</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>382.068200</td>\n",
       "      <td>0.005629</td>\n",
       "      <td>0.531250</td>\n",
       "      <td>67490.233765</td>\n",
       "      <td>79716.416179</td>\n",
       "      <td>-12226.182414</td>\n",
       "      <td>-0.181155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A83037</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A88601</th>\n",
       "      <td>2</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>-12361.812484</td>\n",
       "      <td>-0.311538</td>\n",
       "      <td>0.774909</td>\n",
       "      <td>52041.739101</td>\n",
       "      <td>36089.142156</td>\n",
       "      <td>15952.596945</td>\n",
       "      <td>0.306535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A89022</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B81042</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B81119</th>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>593.210479</td>\n",
       "      <td>0.021098</td>\n",
       "      <td>0.519231</td>\n",
       "      <td>27523.562316</td>\n",
       "      <td>58370.507229</td>\n",
       "      <td>-30846.944914</td>\n",
       "      <td>-1.120747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B81619</th>\n",
       "      <td>1</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>424.099867</td>\n",
       "      <td>0.010613</td>\n",
       "      <td>0.514286</td>\n",
       "      <td>39534.548135</td>\n",
       "      <td>54378.043484</td>\n",
       "      <td>-14843.495349</td>\n",
       "      <td>-0.375456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B82024</th>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>479.753522</td>\n",
       "      <td>0.006362</td>\n",
       "      <td>0.509804</td>\n",
       "      <td>74924.436471</td>\n",
       "      <td>99391.866112</td>\n",
       "      <td>-24467.429641</td>\n",
       "      <td>-0.326561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B83614</th>\n",
       "      <td>2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>-568.787763</td>\n",
       "      <td>-0.039426</td>\n",
       "      <td>0.722817</td>\n",
       "      <td>13817.815170</td>\n",
       "      <td>11457.102555</td>\n",
       "      <td>2360.712615</td>\n",
       "      <td>0.170846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B84014</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B85041</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B85051</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B85619</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B86004</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C81006</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C81054</th>\n",
       "      <td>2</td>\n",
       "      <td>39.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>-261.074522</td>\n",
       "      <td>-0.010558</td>\n",
       "      <td>0.625019</td>\n",
       "      <td>23922.924819</td>\n",
       "      <td>23505.218309</td>\n",
       "      <td>417.706511</td>\n",
       "      <td>0.017461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C82019</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C82042</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C82066</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C82079</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C82095</th>\n",
       "      <td>1</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>189.372797</td>\n",
       "      <td>0.009241</td>\n",
       "      <td>0.514286</td>\n",
       "      <td>20302.423479</td>\n",
       "      <td>26930.471366</td>\n",
       "      <td>-6628.047888</td>\n",
       "      <td>-0.326466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C82627</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C82667</th>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>116.377007</td>\n",
       "      <td>0.004628</td>\n",
       "      <td>0.517241</td>\n",
       "      <td>25030.278790</td>\n",
       "      <td>31780.145175</td>\n",
       "      <td>-6749.866385</td>\n",
       "      <td>-0.269668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C84034</th>\n",
       "      <td>1</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>390.800015</td>\n",
       "      <td>0.008275</td>\n",
       "      <td>0.521739</td>\n",
       "      <td>46837.946942</td>\n",
       "      <td>55826.347292</td>\n",
       "      <td>-8988.400350</td>\n",
       "      <td>-0.191904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C84036</th>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-263.270779</td>\n",
       "      <td>-0.003624</td>\n",
       "      <td>0.508475</td>\n",
       "      <td>72901.759485</td>\n",
       "      <td>57368.783499</td>\n",
       "      <td>15532.975986</td>\n",
       "      <td>0.213067</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C84103</th>\n",
       "      <td>2</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>-701.880711</td>\n",
       "      <td>-0.031150</td>\n",
       "      <td>0.681062</td>\n",
       "      <td>21875.553436</td>\n",
       "      <td>18783.849863</td>\n",
       "      <td>3091.703572</td>\n",
       "      <td>0.141331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C85628</th>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>-162.735962</td>\n",
       "      <td>-0.006307</td>\n",
       "      <td>0.509804</td>\n",
       "      <td>25963.696584</td>\n",
       "      <td>17664.162497</td>\n",
       "      <td>8299.534087</td>\n",
       "      <td>0.319659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C86015</th>\n",
       "      <td>2</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>-399.383730</td>\n",
       "      <td>-0.005184</td>\n",
       "      <td>0.577100</td>\n",
       "      <td>68523.606002</td>\n",
       "      <td>65063.342288</td>\n",
       "      <td>3460.263715</td>\n",
       "      <td>0.050497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C86022</th>\n",
       "      <td>2</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>3959.743030</td>\n",
       "      <td>0.072064</td>\n",
       "      <td>0.557514</td>\n",
       "      <td>50988.031111</td>\n",
       "      <td>58090.525890</td>\n",
       "      <td>-7102.494779</td>\n",
       "      <td>-0.139297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C88023</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">practice_data_opioidspercent</th>\n",
       "      <th>J82075</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J82165</th>\n",
       "      <td>2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>-0.007368</td>\n",
       "      <td>-0.032739</td>\n",
       "      <td>0.683880</td>\n",
       "      <td>0.232414</td>\n",
       "      <td>0.221640</td>\n",
       "      <td>0.010773</td>\n",
       "      <td>0.046355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K81068</th>\n",
       "      <td>2</td>\n",
       "      <td>19.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>-0.005371</td>\n",
       "      <td>-0.030184</td>\n",
       "      <td>0.582396</td>\n",
       "      <td>0.166370</td>\n",
       "      <td>0.138703</td>\n",
       "      <td>0.027666</td>\n",
       "      <td>0.166294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K81636</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K82603</th>\n",
       "      <td>2</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>-0.004457</td>\n",
       "      <td>-0.018850</td>\n",
       "      <td>0.540562</td>\n",
       "      <td>0.157767</td>\n",
       "      <td>0.141278</td>\n",
       "      <td>0.016489</td>\n",
       "      <td>0.104514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K84065</th>\n",
       "      <td>2</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>-0.198854</td>\n",
       "      <td>-0.850760</td>\n",
       "      <td>0.510978</td>\n",
       "      <td>0.432592</td>\n",
       "      <td>0.043428</td>\n",
       "      <td>0.389164</td>\n",
       "      <td>0.899610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L81644</th>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.001525</td>\n",
       "      <td>-0.015360</td>\n",
       "      <td>0.508772</td>\n",
       "      <td>0.100843</td>\n",
       "      <td>0.013891</td>\n",
       "      <td>0.086952</td>\n",
       "      <td>0.862252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L84025</th>\n",
       "      <td>2</td>\n",
       "      <td>19.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>-0.185777</td>\n",
       "      <td>-3.032699</td>\n",
       "      <td>0.864789</td>\n",
       "      <td>0.247035</td>\n",
       "      <td>0.032212</td>\n",
       "      <td>0.214823</td>\n",
       "      <td>0.869607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L84068</th>\n",
       "      <td>2</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-0.015393</td>\n",
       "      <td>-0.045154</td>\n",
       "      <td>0.506675</td>\n",
       "      <td>0.356293</td>\n",
       "      <td>0.052490</td>\n",
       "      <td>0.303804</td>\n",
       "      <td>0.852679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L85044</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M82620</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M83121</th>\n",
       "      <td>2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.029839</td>\n",
       "      <td>-0.169770</td>\n",
       "      <td>0.504243</td>\n",
       "      <td>0.219706</td>\n",
       "      <td>0.042178</td>\n",
       "      <td>0.177528</td>\n",
       "      <td>0.808026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M85078</th>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.002478</td>\n",
       "      <td>-0.020510</td>\n",
       "      <td>0.508475</td>\n",
       "      <td>0.123279</td>\n",
       "      <td>-0.022904</td>\n",
       "      <td>0.146183</td>\n",
       "      <td>1.185788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M85118</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M85671</th>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>1.902439</td>\n",
       "      <td>46.681374</td>\n",
       "      <td>-0.001832</td>\n",
       "      <td>0.001229</td>\n",
       "      <td>-0.003060</td>\n",
       "      <td>1.670902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M85781</th>\n",
       "      <td>2</td>\n",
       "      <td>54.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0.056888</td>\n",
       "      <td>0.941141</td>\n",
       "      <td>5.476882</td>\n",
       "      <td>0.003558</td>\n",
       "      <td>0.013945</td>\n",
       "      <td>-0.010387</td>\n",
       "      <td>-2.919479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M86612</th>\n",
       "      <td>1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>-0.011348</td>\n",
       "      <td>-0.022272</td>\n",
       "      <td>0.510638</td>\n",
       "      <td>0.520876</td>\n",
       "      <td>-0.012482</td>\n",
       "      <td>0.533358</td>\n",
       "      <td>1.023963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M88630</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M92042</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N82067</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N82108</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N85032</th>\n",
       "      <td>2</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>-0.014965</td>\n",
       "      <td>-0.067182</td>\n",
       "      <td>0.503933</td>\n",
       "      <td>0.237713</td>\n",
       "      <td>0.148625</td>\n",
       "      <td>0.089088</td>\n",
       "      <td>0.374770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N85634</th>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.010103</td>\n",
       "      <td>-0.016825</td>\n",
       "      <td>0.569493</td>\n",
       "      <td>0.610584</td>\n",
       "      <td>0.539622</td>\n",
       "      <td>0.070962</td>\n",
       "      <td>0.116220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P81655</th>\n",
       "      <td>2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.034965</td>\n",
       "      <td>0.973558</td>\n",
       "      <td>0.898246</td>\n",
       "      <td>0.000950</td>\n",
       "      <td>0.039876</td>\n",
       "      <td>-0.038926</td>\n",
       "      <td>-40.988946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P84026</th>\n",
       "      <td>2</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>-0.012740</td>\n",
       "      <td>-0.030376</td>\n",
       "      <td>5.652340</td>\n",
       "      <td>0.432146</td>\n",
       "      <td>0.429892</td>\n",
       "      <td>0.002254</td>\n",
       "      <td>0.005216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P85622</th>\n",
       "      <td>1</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>-0.007682</td>\n",
       "      <td>-0.030209</td>\n",
       "      <td>0.526316</td>\n",
       "      <td>0.261974</td>\n",
       "      <td>-0.029939</td>\n",
       "      <td>0.291914</td>\n",
       "      <td>1.114284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P88606</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y00352</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y02622</th>\n",
       "      <td>2</td>\n",
       "      <td>45.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>-0.043245</td>\n",
       "      <td>-0.216792</td>\n",
       "      <td>0.538478</td>\n",
       "      <td>0.051206</td>\n",
       "      <td>-0.109412</td>\n",
       "      <td>0.160618</td>\n",
       "      <td>3.136675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y02636</th>\n",
       "      <td>2</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.020514</td>\n",
       "      <td>0.227878</td>\n",
       "      <td>2.491509</td>\n",
       "      <td>0.069509</td>\n",
       "      <td>0.077742</td>\n",
       "      <td>-0.008234</td>\n",
       "      <td>-0.118455</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     is.nbreak  is.tfirst  is.tfirst.pknown  \\\n",
       "measure                      name                                             \n",
       "practice_data_opioidome      A81057          1       29.0              29.0   \n",
       "                             A83037          0        NaN               NaN   \n",
       "                             A88601          2       13.0              13.0   \n",
       "                             A89022          0        NaN               NaN   \n",
       "                             B81042          0        NaN               NaN   \n",
       "                             B81119          1        9.0               9.0   \n",
       "                             B81619          1       26.0              26.0   \n",
       "                             B82024          1       10.0              10.0   \n",
       "                             B83614          2       32.0              32.0   \n",
       "                             B84014          0        NaN               NaN   \n",
       "                             B85041          0        NaN               NaN   \n",
       "                             B85051          0        NaN               NaN   \n",
       "                             B85619          0        NaN               NaN   \n",
       "                             B86004          0        NaN               NaN   \n",
       "                             C81006          0        NaN               NaN   \n",
       "                             C81054          2       39.0              39.0   \n",
       "                             C82019          0        NaN               NaN   \n",
       "                             C82042          0        NaN               NaN   \n",
       "                             C82066          0        NaN               NaN   \n",
       "                             C82079          0        NaN               NaN   \n",
       "                             C82095          1       26.0              26.0   \n",
       "                             C82627          0        NaN               NaN   \n",
       "                             C82667          1        3.0               3.0   \n",
       "                             C84034          1       38.0              38.0   \n",
       "                             C84036          1        2.0               2.0   \n",
       "                             C84103          2       14.0              14.0   \n",
       "                             C85628          1       10.0              10.0   \n",
       "                             C86015          2       30.0              30.0   \n",
       "                             C86022          2       15.0              15.0   \n",
       "                             C88023          0        NaN               NaN   \n",
       "...                                        ...        ...               ...   \n",
       "practice_data_opioidspercent J82075          0        NaN               NaN   \n",
       "                             J82165          2        8.0               8.0   \n",
       "                             K81068          2       19.0              19.0   \n",
       "                             K81636          0        NaN               NaN   \n",
       "                             K82603          2       21.0              21.0   \n",
       "                             K84065          2       29.0              29.0   \n",
       "                             L81644          1        5.0               5.0   \n",
       "                             L84025          2       19.0              19.0   \n",
       "                             L84068          2       17.0              17.0   \n",
       "                             L85044          0        NaN               NaN   \n",
       "                             M82620          0        NaN               NaN   \n",
       "                             M83121          2        5.0               5.0   \n",
       "                             M85078          1        3.0               3.0   \n",
       "                             M85118          0        NaN               NaN   \n",
       "                             M85671          6        2.0               2.0   \n",
       "                             M85781          2       54.0              54.0   \n",
       "                             M86612          1       15.0              15.0   \n",
       "                             M88630          0        NaN               NaN   \n",
       "                             M92042          0        NaN               NaN   \n",
       "                             N82067          0        NaN               NaN   \n",
       "                             N82108          0        NaN               NaN   \n",
       "                             N85032          2       13.0              13.0   \n",
       "                             N85634          2        3.0               3.0   \n",
       "                             P81655          2       40.0              40.0   \n",
       "                             P84026          2        9.0               9.0   \n",
       "                             P85622          1       24.0              24.0   \n",
       "                             P88606          0        NaN               NaN   \n",
       "                             Y00352          0        NaN               NaN   \n",
       "                             Y02622          2       45.0              45.0   \n",
       "                             Y02636          2       29.0              29.0   \n",
       "\n",
       "                                     is.tfirst.pknown.offs  is.tfirst.offs  \\\n",
       "measure                      name                                            \n",
       "practice_data_opioidome      A81057                    NaN             NaN   \n",
       "                             A83037                    NaN             NaN   \n",
       "                             A88601                   13.0            13.0   \n",
       "                             A89022                    NaN             NaN   \n",
       "                             B81042                    NaN             NaN   \n",
       "                             B81119                    9.0             9.0   \n",
       "                             B81619                   26.0            26.0   \n",
       "                             B82024                   10.0            10.0   \n",
       "                             B83614                   44.0            44.0   \n",
       "                             B84014                    NaN             NaN   \n",
       "                             B85041                    NaN             NaN   \n",
       "                             B85051                    NaN             NaN   \n",
       "                             B85619                    NaN             NaN   \n",
       "                             B86004                    NaN             NaN   \n",
       "                             C81006                    NaN             NaN   \n",
       "                             C81054                   44.0            44.0   \n",
       "                             C82019                    NaN             NaN   \n",
       "                             C82042                    NaN             NaN   \n",
       "                             C82066                    NaN             NaN   \n",
       "                             C82079                    NaN             NaN   \n",
       "                             C82095                   26.0            26.0   \n",
       "                             C82627                    NaN             NaN   \n",
       "                             C82667                    3.0             3.0   \n",
       "                             C84034                   38.0            38.0   \n",
       "                             C84036                    2.0             2.0   \n",
       "                             C84103                   36.0            36.0   \n",
       "                             C85628                   10.0            10.0   \n",
       "                             C86015                   31.0            31.0   \n",
       "                             C86022                   15.0            15.0   \n",
       "                             C88023                    NaN             NaN   \n",
       "...                                                    ...             ...   \n",
       "practice_data_opioidspercent J82075                    NaN             NaN   \n",
       "                             J82165                   27.0            27.0   \n",
       "                             K81068                   31.0            31.0   \n",
       "                             K81636                    NaN             NaN   \n",
       "                             K82603                   23.0            23.0   \n",
       "                             K84065                   29.0            29.0   \n",
       "                             L81644                    NaN             NaN   \n",
       "                             L84025                    NaN             NaN   \n",
       "                             L84068                    NaN             NaN   \n",
       "                             L85044                    NaN             NaN   \n",
       "                             M82620                    NaN             NaN   \n",
       "                             M83121                    5.0             5.0   \n",
       "                             M85078                    3.0             3.0   \n",
       "                             M85118                    NaN             NaN   \n",
       "                             M85671                    4.0             4.0   \n",
       "                             M85781                   54.0            54.0   \n",
       "                             M86612                   15.0            15.0   \n",
       "                             M88630                    NaN             NaN   \n",
       "                             M92042                    NaN             NaN   \n",
       "                             N82067                    NaN             NaN   \n",
       "                             N82108                    NaN             NaN   \n",
       "                             N85032                    NaN             NaN   \n",
       "                             N85634                    NaN             NaN   \n",
       "                             P81655                   40.0            40.0   \n",
       "                             P84026                    NaN             NaN   \n",
       "                             P85622                   24.0            24.0   \n",
       "                             P88606                    NaN             NaN   \n",
       "                             Y00352                    NaN             NaN   \n",
       "                             Y02622                   48.0            48.0   \n",
       "                             Y02636                   39.0            39.0   \n",
       "\n",
       "                                     is.tfirst.big   is.slope.ma  \\\n",
       "measure                      name                                  \n",
       "practice_data_opioidome      A81057           29.0    382.068200   \n",
       "                             A83037            NaN           NaN   \n",
       "                             A88601           13.0 -12361.812484   \n",
       "                             A89022            NaN           NaN   \n",
       "                             B81042            NaN           NaN   \n",
       "                             B81119            9.0    593.210479   \n",
       "                             B81619           26.0    424.099867   \n",
       "                             B82024           10.0    479.753522   \n",
       "                             B83614           44.0   -568.787763   \n",
       "                             B84014            NaN           NaN   \n",
       "                             B85041            NaN           NaN   \n",
       "                             B85051            NaN           NaN   \n",
       "                             B85619            NaN           NaN   \n",
       "                             B86004            NaN           NaN   \n",
       "                             C81006            NaN           NaN   \n",
       "                             C81054           44.0   -261.074522   \n",
       "                             C82019            NaN           NaN   \n",
       "                             C82042            NaN           NaN   \n",
       "                             C82066            NaN           NaN   \n",
       "                             C82079            NaN           NaN   \n",
       "                             C82095           26.0    189.372797   \n",
       "                             C82627            NaN           NaN   \n",
       "                             C82667            3.0    116.377007   \n",
       "                             C84034           38.0    390.800015   \n",
       "                             C84036            2.0   -263.270779   \n",
       "                             C84103           36.0   -701.880711   \n",
       "                             C85628           10.0   -162.735962   \n",
       "                             C86015           31.0   -399.383730   \n",
       "                             C86022           15.0   3959.743030   \n",
       "                             C88023            NaN           NaN   \n",
       "...                                            ...           ...   \n",
       "practice_data_opioidspercent J82075            NaN           NaN   \n",
       "                             J82165            8.0     -0.007368   \n",
       "                             K81068           31.0     -0.005371   \n",
       "                             K81636            NaN           NaN   \n",
       "                             K82603           23.0     -0.004457   \n",
       "                             K84065           29.0     -0.198854   \n",
       "                             L81644            5.0     -0.001525   \n",
       "                             L84025           19.0     -0.185777   \n",
       "                             L84068           17.0     -0.015393   \n",
       "                             L85044            NaN           NaN   \n",
       "                             M82620            NaN           NaN   \n",
       "                             M83121            5.0     -0.029839   \n",
       "                             M85078            3.0     -0.002478   \n",
       "                             M85118            NaN           NaN   \n",
       "                             M85671           11.0      0.142857   \n",
       "                             M85781           54.0      0.056888   \n",
       "                             M86612           15.0     -0.011348   \n",
       "                             M88630            NaN           NaN   \n",
       "                             M92042            NaN           NaN   \n",
       "                             N82067            NaN           NaN   \n",
       "                             N82108            NaN           NaN   \n",
       "                             N85032           13.0     -0.014965   \n",
       "                             N85634            3.0     -0.010103   \n",
       "                             P81655           40.0      0.034965   \n",
       "                             P84026            9.0     -0.012740   \n",
       "                             P85622           24.0     -0.007682   \n",
       "                             P88606            NaN           NaN   \n",
       "                             Y00352            NaN           NaN   \n",
       "                             Y02622           48.0     -0.043245   \n",
       "                             Y02636           29.0      0.020514   \n",
       "\n",
       "                                     is.slope.ma.prop  is.slope.ma.prop.lev  \\\n",
       "measure                      name                                             \n",
       "practice_data_opioidome      A81057          0.005629              0.531250   \n",
       "                             A83037               NaN                   NaN   \n",
       "                             A88601         -0.311538              0.774909   \n",
       "                             A89022               NaN                   NaN   \n",
       "                             B81042               NaN                   NaN   \n",
       "                             B81119          0.021098              0.519231   \n",
       "                             B81619          0.010613              0.514286   \n",
       "                             B82024          0.006362              0.509804   \n",
       "                             B83614         -0.039426              0.722817   \n",
       "                             B84014               NaN                   NaN   \n",
       "                             B85041               NaN                   NaN   \n",
       "                             B85051               NaN                   NaN   \n",
       "                             B85619               NaN                   NaN   \n",
       "                             B86004               NaN                   NaN   \n",
       "                             C81006               NaN                   NaN   \n",
       "                             C81054         -0.010558              0.625019   \n",
       "                             C82019               NaN                   NaN   \n",
       "                             C82042               NaN                   NaN   \n",
       "                             C82066               NaN                   NaN   \n",
       "                             C82079               NaN                   NaN   \n",
       "                             C82095          0.009241              0.514286   \n",
       "                             C82627               NaN                   NaN   \n",
       "                             C82667          0.004628              0.517241   \n",
       "                             C84034          0.008275              0.521739   \n",
       "                             C84036         -0.003624              0.508475   \n",
       "                             C84103         -0.031150              0.681062   \n",
       "                             C85628         -0.006307              0.509804   \n",
       "                             C86015         -0.005184              0.577100   \n",
       "                             C86022          0.072064              0.557514   \n",
       "                             C88023               NaN                   NaN   \n",
       "...                                               ...                   ...   \n",
       "practice_data_opioidspercent J82075               NaN                   NaN   \n",
       "                             J82165         -0.032739              0.683880   \n",
       "                             K81068         -0.030184              0.582396   \n",
       "                             K81636               NaN                   NaN   \n",
       "                             K82603         -0.018850              0.540562   \n",
       "                             K84065         -0.850760              0.510978   \n",
       "                             L81644         -0.015360              0.508772   \n",
       "                             L84025         -3.032699              0.864789   \n",
       "                             L84068         -0.045154              0.506675   \n",
       "                             L85044               NaN                   NaN   \n",
       "                             M82620               NaN                   NaN   \n",
       "                             M83121         -0.169770              0.504243   \n",
       "                             M85078         -0.020510              0.508475   \n",
       "                             M85118               NaN                   NaN   \n",
       "                             M85671          1.902439             46.681374   \n",
       "                             M85781          0.941141              5.476882   \n",
       "                             M86612         -0.022272              0.510638   \n",
       "                             M88630               NaN                   NaN   \n",
       "                             M92042               NaN                   NaN   \n",
       "                             N82067               NaN                   NaN   \n",
       "                             N82108               NaN                   NaN   \n",
       "                             N85032         -0.067182              0.503933   \n",
       "                             N85634         -0.016825              0.569493   \n",
       "                             P81655          0.973558              0.898246   \n",
       "                             P84026         -0.030376              5.652340   \n",
       "                             P85622         -0.030209              0.526316   \n",
       "                             P88606               NaN                   NaN   \n",
       "                             Y00352               NaN                   NaN   \n",
       "                             Y02622         -0.216792              0.538478   \n",
       "                             Y02636          0.227878              2.491509   \n",
       "\n",
       "                                     is.intlev.initlev  is.intlev.finallev  \\\n",
       "measure                      name                                            \n",
       "practice_data_opioidome      A81057       67490.233765        79716.416179   \n",
       "                             A83037                NaN                 NaN   \n",
       "                             A88601       52041.739101        36089.142156   \n",
       "                             A89022                NaN                 NaN   \n",
       "                             B81042                NaN                 NaN   \n",
       "                             B81119       27523.562316        58370.507229   \n",
       "                             B81619       39534.548135        54378.043484   \n",
       "                             B82024       74924.436471        99391.866112   \n",
       "                             B83614       13817.815170        11457.102555   \n",
       "                             B84014                NaN                 NaN   \n",
       "                             B85041                NaN                 NaN   \n",
       "                             B85051                NaN                 NaN   \n",
       "                             B85619                NaN                 NaN   \n",
       "                             B86004                NaN                 NaN   \n",
       "                             C81006                NaN                 NaN   \n",
       "                             C81054       23922.924819        23505.218309   \n",
       "                             C82019                NaN                 NaN   \n",
       "                             C82042                NaN                 NaN   \n",
       "                             C82066                NaN                 NaN   \n",
       "                             C82079                NaN                 NaN   \n",
       "                             C82095       20302.423479        26930.471366   \n",
       "                             C82627                NaN                 NaN   \n",
       "                             C82667       25030.278790        31780.145175   \n",
       "                             C84034       46837.946942        55826.347292   \n",
       "                             C84036       72901.759485        57368.783499   \n",
       "                             C84103       21875.553436        18783.849863   \n",
       "                             C85628       25963.696584        17664.162497   \n",
       "                             C86015       68523.606002        65063.342288   \n",
       "                             C86022       50988.031111        58090.525890   \n",
       "                             C88023                NaN                 NaN   \n",
       "...                                                ...                 ...   \n",
       "practice_data_opioidspercent J82075                NaN                 NaN   \n",
       "                             J82165           0.232414            0.221640   \n",
       "                             K81068           0.166370            0.138703   \n",
       "                             K81636                NaN                 NaN   \n",
       "                             K82603           0.157767            0.141278   \n",
       "                             K84065           0.432592            0.043428   \n",
       "                             L81644           0.100843            0.013891   \n",
       "                             L84025           0.247035            0.032212   \n",
       "                             L84068           0.356293            0.052490   \n",
       "                             L85044                NaN                 NaN   \n",
       "                             M82620                NaN                 NaN   \n",
       "                             M83121           0.219706            0.042178   \n",
       "                             M85078           0.123279           -0.022904   \n",
       "                             M85118                NaN                 NaN   \n",
       "                             M85671          -0.001832            0.001229   \n",
       "                             M85781           0.003558            0.013945   \n",
       "                             M86612           0.520876           -0.012482   \n",
       "                             M88630                NaN                 NaN   \n",
       "                             M92042                NaN                 NaN   \n",
       "                             N82067                NaN                 NaN   \n",
       "                             N82108                NaN                 NaN   \n",
       "                             N85032           0.237713            0.148625   \n",
       "                             N85634           0.610584            0.539622   \n",
       "                             P81655           0.000950            0.039876   \n",
       "                             P84026           0.432146            0.429892   \n",
       "                             P85622           0.261974           -0.029939   \n",
       "                             P88606                NaN                 NaN   \n",
       "                             Y00352                NaN                 NaN   \n",
       "                             Y02622           0.051206           -0.109412   \n",
       "                             Y02636           0.069509            0.077742   \n",
       "\n",
       "                                     is.intlev.levd  is.intlev.levdprop  \n",
       "measure                      name                                        \n",
       "practice_data_opioidome      A81057   -12226.182414           -0.181155  \n",
       "                             A83037             NaN                 NaN  \n",
       "                             A88601    15952.596945            0.306535  \n",
       "                             A89022             NaN                 NaN  \n",
       "                             B81042             NaN                 NaN  \n",
       "                             B81119   -30846.944914           -1.120747  \n",
       "                             B81619   -14843.495349           -0.375456  \n",
       "                             B82024   -24467.429641           -0.326561  \n",
       "                             B83614     2360.712615            0.170846  \n",
       "                             B84014             NaN                 NaN  \n",
       "                             B85041             NaN                 NaN  \n",
       "                             B85051             NaN                 NaN  \n",
       "                             B85619             NaN                 NaN  \n",
       "                             B86004             NaN                 NaN  \n",
       "                             C81006             NaN                 NaN  \n",
       "                             C81054      417.706511            0.017461  \n",
       "                             C82019             NaN                 NaN  \n",
       "                             C82042             NaN                 NaN  \n",
       "                             C82066             NaN                 NaN  \n",
       "                             C82079             NaN                 NaN  \n",
       "                             C82095    -6628.047888           -0.326466  \n",
       "                             C82627             NaN                 NaN  \n",
       "                             C82667    -6749.866385           -0.269668  \n",
       "                             C84034    -8988.400350           -0.191904  \n",
       "                             C84036    15532.975986            0.213067  \n",
       "                             C84103     3091.703572            0.141331  \n",
       "                             C85628     8299.534087            0.319659  \n",
       "                             C86015     3460.263715            0.050497  \n",
       "                             C86022    -7102.494779           -0.139297  \n",
       "                             C88023             NaN                 NaN  \n",
       "...                                             ...                 ...  \n",
       "practice_data_opioidspercent J82075             NaN                 NaN  \n",
       "                             J82165        0.010773            0.046355  \n",
       "                             K81068        0.027666            0.166294  \n",
       "                             K81636             NaN                 NaN  \n",
       "                             K82603        0.016489            0.104514  \n",
       "                             K84065        0.389164            0.899610  \n",
       "                             L81644        0.086952            0.862252  \n",
       "                             L84025        0.214823            0.869607  \n",
       "                             L84068        0.303804            0.852679  \n",
       "                             L85044             NaN                 NaN  \n",
       "                             M82620             NaN                 NaN  \n",
       "                             M83121        0.177528            0.808026  \n",
       "                             M85078        0.146183            1.185788  \n",
       "                             M85118             NaN                 NaN  \n",
       "                             M85671       -0.003060            1.670902  \n",
       "                             M85781       -0.010387           -2.919479  \n",
       "                             M86612        0.533358            1.023963  \n",
       "                             M88630             NaN                 NaN  \n",
       "                             M92042             NaN                 NaN  \n",
       "                             N82067             NaN                 NaN  \n",
       "                             N82108             NaN                 NaN  \n",
       "                             N85032        0.089088            0.374770  \n",
       "                             N85634        0.070962            0.116220  \n",
       "                             P81655       -0.038926          -40.988946  \n",
       "                             P84026        0.002254            0.005216  \n",
       "                             P85622        0.291914            1.114284  \n",
       "                             P88606             NaN                 NaN  \n",
       "                             Y00352             NaN                 NaN  \n",
       "                             Y02622        0.160618            3.136675  \n",
       "                             Y02636       -0.008234           -0.118455  \n",
       "\n",
       "[300 rows x 13 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "opioids.concatenate_outputs()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}