transactions-task-tables.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "fdafb7ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import psycopg2\n",
    "import sqlalchemy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "129b5ae5",
   "metadata": {},
   "outputs": [],
   "source": [
    "connection = sqlalchemy.create_engine(f'postgresql+psycopg2://myusername@0.0.0.0:5432/postgres')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7b029038",
   "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>index</th>\n",
       "      <th>trade_date</th>\n",
       "      <th>fund</th>\n",
       "      <th>trader</th>\n",
       "      <th>security</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1/3/2022</td>\n",
       "      <td>Equity Fund</td>\n",
       "      <td>Ricky</td>\n",
       "      <td>IBM</td>\n",
       "      <td>20</td>\n",
       "      <td>0.093486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1/3/2022</td>\n",
       "      <td>Equity Fund</td>\n",
       "      <td>Ethel</td>\n",
       "      <td>GOOG</td>\n",
       "      <td>2</td>\n",
       "      <td>0.228878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1/3/2022</td>\n",
       "      <td>Equity Fund</td>\n",
       "      <td>Ricky</td>\n",
       "      <td>TSLA</td>\n",
       "      <td>58</td>\n",
       "      <td>0.129644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1/3/2022</td>\n",
       "      <td>Future Fund</td>\n",
       "      <td>Lucy</td>\n",
       "      <td>EDU8</td>\n",
       "      <td>31</td>\n",
       "      <td>0.626164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1/3/2022</td>\n",
       "      <td>Future Fund</td>\n",
       "      <td>Ricky</td>\n",
       "      <td>ZCU23</td>\n",
       "      <td>65</td>\n",
       "      <td>0.798289</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index trade_date         fund trader security  quantity     price\n",
       "0      0   1/3/2022  Equity Fund  Ricky      IBM        20  0.093486\n",
       "1      1   1/3/2022  Equity Fund  Ethel     GOOG         2  0.228878\n",
       "2      2   1/3/2022  Equity Fund  Ricky     TSLA        58  0.129644\n",
       "3      3   1/3/2022  Future Fund   Lucy     EDU8        31  0.626164\n",
       "4      4   1/3/2022  Future Fund  Ricky    ZCU23        65  0.798289"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# transaction_staging_table\n",
    "query = \"\"\"SELECT * FROM staging_transactions as d\"\"\"\n",
    "df_mysql = pd.read_sql(query, con = connection)\n",
    "df_mysql.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "02ddc582",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "</style>\n",
       "<table id=\"T_2a01c\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_2a01c_level0_col0\" class=\"col_heading level0 col0\" >total_transaction_cost</th>\n",
       "      <th id=\"T_2a01c_level0_col1\" class=\"col_heading level0 col1\" >quantity</th>\n",
       "      <th id=\"T_2a01c_level0_col2\" class=\"col_heading level0 col2\" >price</th>\n",
       "      <th id=\"T_2a01c_level0_col3\" class=\"col_heading level0 col3\" >date_key</th>\n",
       "      <th id=\"T_2a01c_level0_col4\" class=\"col_heading level0 col4\" >trader_key</th>\n",
       "      <th id=\"T_2a01c_level0_col5\" class=\"col_heading level0 col5\" >security_key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_2a01c_row0_col0\" class=\"data row0 col0\" >1.869719</td>\n",
       "      <td id=\"T_2a01c_row0_col1\" class=\"data row0 col1\" >20.000000</td>\n",
       "      <td id=\"T_2a01c_row0_col2\" class=\"data row0 col2\" >0.093486</td>\n",
       "      <td id=\"T_2a01c_row0_col3\" class=\"data row0 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row0_col4\" class=\"data row0 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row0_col5\" class=\"data row0 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_2a01c_row1_col0\" class=\"data row1 col0\" >0.457755</td>\n",
       "      <td id=\"T_2a01c_row1_col1\" class=\"data row1 col1\" >2.000000</td>\n",
       "      <td id=\"T_2a01c_row1_col2\" class=\"data row1 col2\" >0.228878</td>\n",
       "      <td id=\"T_2a01c_row1_col3\" class=\"data row1 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row1_col4\" class=\"data row1 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row1_col5\" class=\"data row1 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_2a01c_row2_col0\" class=\"data row2 col0\" >7.519345</td>\n",
       "      <td id=\"T_2a01c_row2_col1\" class=\"data row2 col1\" >58.000000</td>\n",
       "      <td id=\"T_2a01c_row2_col2\" class=\"data row2 col2\" >0.129644</td>\n",
       "      <td id=\"T_2a01c_row2_col3\" class=\"data row2 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row2_col4\" class=\"data row2 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row2_col5\" class=\"data row2 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_2a01c_row3_col0\" class=\"data row3 col0\" >19.411096</td>\n",
       "      <td id=\"T_2a01c_row3_col1\" class=\"data row3 col1\" >31.000000</td>\n",
       "      <td id=\"T_2a01c_row3_col2\" class=\"data row3 col2\" >0.626164</td>\n",
       "      <td id=\"T_2a01c_row3_col3\" class=\"data row3 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row3_col4\" class=\"data row3 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row3_col5\" class=\"data row3 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_2a01c_row4_col0\" class=\"data row4 col0\" >51.888789</td>\n",
       "      <td id=\"T_2a01c_row4_col1\" class=\"data row4 col1\" >65.000000</td>\n",
       "      <td id=\"T_2a01c_row4_col2\" class=\"data row4 col2\" >0.798289</td>\n",
       "      <td id=\"T_2a01c_row4_col3\" class=\"data row4 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row4_col4\" class=\"data row4 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row4_col5\" class=\"data row4 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_2a01c_row5_col0\" class=\"data row5 col0\" >35.656069</td>\n",
       "      <td id=\"T_2a01c_row5_col1\" class=\"data row5 col1\" >61.000000</td>\n",
       "      <td id=\"T_2a01c_row5_col2\" class=\"data row5 col2\" >0.584526</td>\n",
       "      <td id=\"T_2a01c_row5_col3\" class=\"data row5 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row5_col4\" class=\"data row5 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row5_col5\" class=\"data row5 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_2a01c_row6_col0\" class=\"data row6 col0\" >13.296193</td>\n",
       "      <td id=\"T_2a01c_row6_col1\" class=\"data row6 col1\" >58.000000</td>\n",
       "      <td id=\"T_2a01c_row6_col2\" class=\"data row6 col2\" >0.229245</td>\n",
       "      <td id=\"T_2a01c_row6_col3\" class=\"data row6 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row6_col4\" class=\"data row6 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row6_col5\" class=\"data row6 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_2a01c_row7_col0\" class=\"data row7 col0\" >4.571576</td>\n",
       "      <td id=\"T_2a01c_row7_col1\" class=\"data row7 col1\" >64.000000</td>\n",
       "      <td id=\"T_2a01c_row7_col2\" class=\"data row7 col2\" >0.071431</td>\n",
       "      <td id=\"T_2a01c_row7_col3\" class=\"data row7 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row7_col4\" class=\"data row7 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row7_col5\" class=\"data row7 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_2a01c_row8_col0\" class=\"data row8 col0\" >12.285790</td>\n",
       "      <td id=\"T_2a01c_row8_col1\" class=\"data row8 col1\" >96.000000</td>\n",
       "      <td id=\"T_2a01c_row8_col2\" class=\"data row8 col2\" >0.127977</td>\n",
       "      <td id=\"T_2a01c_row8_col3\" class=\"data row8 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row8_col4\" class=\"data row8 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row8_col5\" class=\"data row8 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_2a01c_row9_col0\" class=\"data row9 col0\" >61.128201</td>\n",
       "      <td id=\"T_2a01c_row9_col1\" class=\"data row9 col1\" >86.000000</td>\n",
       "      <td id=\"T_2a01c_row9_col2\" class=\"data row9 col2\" >0.710793</td>\n",
       "      <td id=\"T_2a01c_row9_col3\" class=\"data row9 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row9_col4\" class=\"data row9 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row9_col5\" class=\"data row9 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row10\" class=\"row_heading level0 row10\" >10</th>\n",
       "      <td id=\"T_2a01c_row10_col0\" class=\"data row10 col0\" >67.304508</td>\n",
       "      <td id=\"T_2a01c_row10_col1\" class=\"data row10 col1\" >69.000000</td>\n",
       "      <td id=\"T_2a01c_row10_col2\" class=\"data row10 col2\" >0.975428</td>\n",
       "      <td id=\"T_2a01c_row10_col3\" class=\"data row10 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row10_col4\" class=\"data row10 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row10_col5\" class=\"data row10 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row11\" class=\"row_heading level0 row11\" >11</th>\n",
       "      <td id=\"T_2a01c_row11_col0\" class=\"data row11 col0\" >96.055191</td>\n",
       "      <td id=\"T_2a01c_row11_col1\" class=\"data row11 col1\" >100.000000</td>\n",
       "      <td id=\"T_2a01c_row11_col2\" class=\"data row11 col2\" >0.960552</td>\n",
       "      <td id=\"T_2a01c_row11_col3\" class=\"data row11 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row11_col4\" class=\"data row11 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row11_col5\" class=\"data row11 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row12\" class=\"row_heading level0 row12\" >12</th>\n",
       "      <td id=\"T_2a01c_row12_col0\" class=\"data row12 col0\" >43.032834</td>\n",
       "      <td id=\"T_2a01c_row12_col1\" class=\"data row12 col1\" >61.000000</td>\n",
       "      <td id=\"T_2a01c_row12_col2\" class=\"data row12 col2\" >0.705456</td>\n",
       "      <td id=\"T_2a01c_row12_col3\" class=\"data row12 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row12_col4\" class=\"data row12 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row12_col5\" class=\"data row12 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row13\" class=\"row_heading level0 row13\" >13</th>\n",
       "      <td id=\"T_2a01c_row13_col0\" class=\"data row13 col0\" >44.658337</td>\n",
       "      <td id=\"T_2a01c_row13_col1\" class=\"data row13 col1\" >76.000000</td>\n",
       "      <td id=\"T_2a01c_row13_col2\" class=\"data row13 col2\" >0.587610</td>\n",
       "      <td id=\"T_2a01c_row13_col3\" class=\"data row13 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row13_col4\" class=\"data row13 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row13_col5\" class=\"data row13 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row14\" class=\"row_heading level0 row14\" >14</th>\n",
       "      <td id=\"T_2a01c_row14_col0\" class=\"data row14 col0\" >0.528076</td>\n",
       "      <td id=\"T_2a01c_row14_col1\" class=\"data row14 col1\" >11.000000</td>\n",
       "      <td id=\"T_2a01c_row14_col2\" class=\"data row14 col2\" >0.048007</td>\n",
       "      <td id=\"T_2a01c_row14_col3\" class=\"data row14 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row14_col4\" class=\"data row14 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row14_col5\" class=\"data row14 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row15\" class=\"row_heading level0 row15\" >15</th>\n",
       "      <td id=\"T_2a01c_row15_col0\" class=\"data row15 col0\" >21.671596</td>\n",
       "      <td id=\"T_2a01c_row15_col1\" class=\"data row15 col1\" >81.000000</td>\n",
       "      <td id=\"T_2a01c_row15_col2\" class=\"data row15 col2\" >0.267551</td>\n",
       "      <td id=\"T_2a01c_row15_col3\" class=\"data row15 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row15_col4\" class=\"data row15 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row15_col5\" class=\"data row15 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row16\" class=\"row_heading level0 row16\" >16</th>\n",
       "      <td id=\"T_2a01c_row16_col0\" class=\"data row16 col0\" >8.894436</td>\n",
       "      <td id=\"T_2a01c_row16_col1\" class=\"data row16 col1\" >64.000000</td>\n",
       "      <td id=\"T_2a01c_row16_col2\" class=\"data row16 col2\" >0.138976</td>\n",
       "      <td id=\"T_2a01c_row16_col3\" class=\"data row16 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row16_col4\" class=\"data row16 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row16_col5\" class=\"data row16 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row17\" class=\"row_heading level0 row17\" >17</th>\n",
       "      <td id=\"T_2a01c_row17_col0\" class=\"data row17 col0\" >8.215864</td>\n",
       "      <td id=\"T_2a01c_row17_col1\" class=\"data row17 col1\" >20.000000</td>\n",
       "      <td id=\"T_2a01c_row17_col2\" class=\"data row17 col2\" >0.410793</td>\n",
       "      <td id=\"T_2a01c_row17_col3\" class=\"data row17 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row17_col4\" class=\"data row17 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row17_col5\" class=\"data row17 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row18\" class=\"row_heading level0 row18\" >18</th>\n",
       "      <td id=\"T_2a01c_row18_col0\" class=\"data row18 col0\" >54.700204</td>\n",
       "      <td id=\"T_2a01c_row18_col1\" class=\"data row18 col1\" >69.000000</td>\n",
       "      <td id=\"T_2a01c_row18_col2\" class=\"data row18 col2\" >0.792757</td>\n",
       "      <td id=\"T_2a01c_row18_col3\" class=\"data row18 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row18_col4\" class=\"data row18 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row18_col5\" class=\"data row18 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row19\" class=\"row_heading level0 row19\" >19</th>\n",
       "      <td id=\"T_2a01c_row19_col0\" class=\"data row19 col0\" >15.953794</td>\n",
       "      <td id=\"T_2a01c_row19_col1\" class=\"data row19 col1\" >16.000000</td>\n",
       "      <td id=\"T_2a01c_row19_col2\" class=\"data row19 col2\" >0.997112</td>\n",
       "      <td id=\"T_2a01c_row19_col3\" class=\"data row19 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row19_col4\" class=\"data row19 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row19_col5\" class=\"data row19 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row20\" class=\"row_heading level0 row20\" >20</th>\n",
       "      <td id=\"T_2a01c_row20_col0\" class=\"data row20 col0\" >10.357393</td>\n",
       "      <td id=\"T_2a01c_row20_col1\" class=\"data row20 col1\" >13.000000</td>\n",
       "      <td id=\"T_2a01c_row20_col2\" class=\"data row20 col2\" >0.796723</td>\n",
       "      <td id=\"T_2a01c_row20_col3\" class=\"data row20 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row20_col4\" class=\"data row20 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row20_col5\" class=\"data row20 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row21\" class=\"row_heading level0 row21\" >21</th>\n",
       "      <td id=\"T_2a01c_row21_col0\" class=\"data row21 col0\" >29.107122</td>\n",
       "      <td id=\"T_2a01c_row21_col1\" class=\"data row21 col1\" >88.000000</td>\n",
       "      <td id=\"T_2a01c_row21_col2\" class=\"data row21 col2\" >0.330763</td>\n",
       "      <td id=\"T_2a01c_row21_col3\" class=\"data row21 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row21_col4\" class=\"data row21 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row21_col5\" class=\"data row21 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row22\" class=\"row_heading level0 row22\" >22</th>\n",
       "      <td id=\"T_2a01c_row22_col0\" class=\"data row22 col0\" >82.437172</td>\n",
       "      <td id=\"T_2a01c_row22_col1\" class=\"data row22 col1\" >99.000000</td>\n",
       "      <td id=\"T_2a01c_row22_col2\" class=\"data row22 col2\" >0.832699</td>\n",
       "      <td id=\"T_2a01c_row22_col3\" class=\"data row22 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row22_col4\" class=\"data row22 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row22_col5\" class=\"data row22 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row23\" class=\"row_heading level0 row23\" >23</th>\n",
       "      <td id=\"T_2a01c_row23_col0\" class=\"data row23 col0\" >53.642711</td>\n",
       "      <td id=\"T_2a01c_row23_col1\" class=\"data row23 col1\" >76.000000</td>\n",
       "      <td id=\"T_2a01c_row23_col2\" class=\"data row23 col2\" >0.705825</td>\n",
       "      <td id=\"T_2a01c_row23_col3\" class=\"data row23 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row23_col4\" class=\"data row23 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row23_col5\" class=\"data row23 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row24\" class=\"row_heading level0 row24\" >24</th>\n",
       "      <td id=\"T_2a01c_row24_col0\" class=\"data row24 col0\" >60.436378</td>\n",
       "      <td id=\"T_2a01c_row24_col1\" class=\"data row24 col1\" >71.000000</td>\n",
       "      <td id=\"T_2a01c_row24_col2\" class=\"data row24 col2\" >0.851217</td>\n",
       "      <td id=\"T_2a01c_row24_col3\" class=\"data row24 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row24_col4\" class=\"data row24 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row24_col5\" class=\"data row24 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row25\" class=\"row_heading level0 row25\" >25</th>\n",
       "      <td id=\"T_2a01c_row25_col0\" class=\"data row25 col0\" >6.469389</td>\n",
       "      <td id=\"T_2a01c_row25_col1\" class=\"data row25 col1\" >33.000000</td>\n",
       "      <td id=\"T_2a01c_row25_col2\" class=\"data row25 col2\" >0.196042</td>\n",
       "      <td id=\"T_2a01c_row25_col3\" class=\"data row25 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row25_col4\" class=\"data row25 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row25_col5\" class=\"data row25 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row26\" class=\"row_heading level0 row26\" >26</th>\n",
       "      <td id=\"T_2a01c_row26_col0\" class=\"data row26 col0\" >19.821364</td>\n",
       "      <td id=\"T_2a01c_row26_col1\" class=\"data row26 col1\" >45.000000</td>\n",
       "      <td id=\"T_2a01c_row26_col2\" class=\"data row26 col2\" >0.440475</td>\n",
       "      <td id=\"T_2a01c_row26_col3\" class=\"data row26 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row26_col4\" class=\"data row26 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row26_col5\" class=\"data row26 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row27\" class=\"row_heading level0 row27\" >27</th>\n",
       "      <td id=\"T_2a01c_row27_col0\" class=\"data row27 col0\" >2.469458</td>\n",
       "      <td id=\"T_2a01c_row27_col1\" class=\"data row27 col1\" >8.000000</td>\n",
       "      <td id=\"T_2a01c_row27_col2\" class=\"data row27 col2\" >0.308682</td>\n",
       "      <td id=\"T_2a01c_row27_col3\" class=\"data row27 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row27_col4\" class=\"data row27 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row27_col5\" class=\"data row27 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row28\" class=\"row_heading level0 row28\" >28</th>\n",
       "      <td id=\"T_2a01c_row28_col0\" class=\"data row28 col0\" >8.674169</td>\n",
       "      <td id=\"T_2a01c_row28_col1\" class=\"data row28 col1\" >16.000000</td>\n",
       "      <td id=\"T_2a01c_row28_col2\" class=\"data row28 col2\" >0.542136</td>\n",
       "      <td id=\"T_2a01c_row28_col3\" class=\"data row28 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row28_col4\" class=\"data row28 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row28_col5\" class=\"data row28 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row29\" class=\"row_heading level0 row29\" >29</th>\n",
       "      <td id=\"T_2a01c_row29_col0\" class=\"data row29 col0\" >4.666879</td>\n",
       "      <td id=\"T_2a01c_row29_col1\" class=\"data row29 col1\" >11.000000</td>\n",
       "      <td id=\"T_2a01c_row29_col2\" class=\"data row29 col2\" >0.424262</td>\n",
       "      <td id=\"T_2a01c_row29_col3\" class=\"data row29 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row29_col4\" class=\"data row29 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row29_col5\" class=\"data row29 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row30\" class=\"row_heading level0 row30\" >30</th>\n",
       "      <td id=\"T_2a01c_row30_col0\" class=\"data row30 col0\" >30.672321</td>\n",
       "      <td id=\"T_2a01c_row30_col1\" class=\"data row30 col1\" >44.000000</td>\n",
       "      <td id=\"T_2a01c_row30_col2\" class=\"data row30 col2\" >0.697098</td>\n",
       "      <td id=\"T_2a01c_row30_col3\" class=\"data row30 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row30_col4\" class=\"data row30 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row30_col5\" class=\"data row30 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row31\" class=\"row_heading level0 row31\" >31</th>\n",
       "      <td id=\"T_2a01c_row31_col0\" class=\"data row31 col0\" >48.615282</td>\n",
       "      <td id=\"T_2a01c_row31_col1\" class=\"data row31 col1\" >82.000000</td>\n",
       "      <td id=\"T_2a01c_row31_col2\" class=\"data row31 col2\" >0.592869</td>\n",
       "      <td id=\"T_2a01c_row31_col3\" class=\"data row31 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row31_col4\" class=\"data row31 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row31_col5\" class=\"data row31 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row32\" class=\"row_heading level0 row32\" >32</th>\n",
       "      <td id=\"T_2a01c_row32_col0\" class=\"data row32 col0\" >33.221067</td>\n",
       "      <td id=\"T_2a01c_row32_col1\" class=\"data row32 col1\" >92.000000</td>\n",
       "      <td id=\"T_2a01c_row32_col2\" class=\"data row32 col2\" >0.361099</td>\n",
       "      <td id=\"T_2a01c_row32_col3\" class=\"data row32 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row32_col4\" class=\"data row32 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row32_col5\" class=\"data row32 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row33\" class=\"row_heading level0 row33\" >33</th>\n",
       "      <td id=\"T_2a01c_row33_col0\" class=\"data row33 col0\" >60.252584</td>\n",
       "      <td id=\"T_2a01c_row33_col1\" class=\"data row33 col1\" >68.000000</td>\n",
       "      <td id=\"T_2a01c_row33_col2\" class=\"data row33 col2\" >0.886067</td>\n",
       "      <td id=\"T_2a01c_row33_col3\" class=\"data row33 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row33_col4\" class=\"data row33 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row33_col5\" class=\"data row33 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row34\" class=\"row_heading level0 row34\" >34</th>\n",
       "      <td id=\"T_2a01c_row34_col0\" class=\"data row34 col0\" >4.403424</td>\n",
       "      <td id=\"T_2a01c_row34_col1\" class=\"data row34 col1\" >97.000000</td>\n",
       "      <td id=\"T_2a01c_row34_col2\" class=\"data row34 col2\" >0.045396</td>\n",
       "      <td id=\"T_2a01c_row34_col3\" class=\"data row34 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row34_col4\" class=\"data row34 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row34_col5\" class=\"data row34 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row35\" class=\"row_heading level0 row35\" >35</th>\n",
       "      <td id=\"T_2a01c_row35_col0\" class=\"data row35 col0\" >15.570619</td>\n",
       "      <td id=\"T_2a01c_row35_col1\" class=\"data row35 col1\" >27.000000</td>\n",
       "      <td id=\"T_2a01c_row35_col2\" class=\"data row35 col2\" >0.576690</td>\n",
       "      <td id=\"T_2a01c_row35_col3\" class=\"data row35 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row35_col4\" class=\"data row35 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row35_col5\" class=\"data row35 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row36\" class=\"row_heading level0 row36\" >36</th>\n",
       "      <td id=\"T_2a01c_row36_col0\" class=\"data row36 col0\" >24.583807</td>\n",
       "      <td id=\"T_2a01c_row36_col1\" class=\"data row36 col1\" >47.000000</td>\n",
       "      <td id=\"T_2a01c_row36_col2\" class=\"data row36 col2\" >0.523060</td>\n",
       "      <td id=\"T_2a01c_row36_col3\" class=\"data row36 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row36_col4\" class=\"data row36 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row36_col5\" class=\"data row36 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row37\" class=\"row_heading level0 row37\" >37</th>\n",
       "      <td id=\"T_2a01c_row37_col0\" class=\"data row37 col0\" >1.818860</td>\n",
       "      <td id=\"T_2a01c_row37_col1\" class=\"data row37 col1\" >3.000000</td>\n",
       "      <td id=\"T_2a01c_row37_col2\" class=\"data row37 col2\" >0.606287</td>\n",
       "      <td id=\"T_2a01c_row37_col3\" class=\"data row37 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row37_col4\" class=\"data row37 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row37_col5\" class=\"data row37 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row38\" class=\"row_heading level0 row38\" >38</th>\n",
       "      <td id=\"T_2a01c_row38_col0\" class=\"data row38 col0\" >15.042669</td>\n",
       "      <td id=\"T_2a01c_row38_col1\" class=\"data row38 col1\" >18.000000</td>\n",
       "      <td id=\"T_2a01c_row38_col2\" class=\"data row38 col2\" >0.835704</td>\n",
       "      <td id=\"T_2a01c_row38_col3\" class=\"data row38 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row38_col4\" class=\"data row38 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row38_col5\" class=\"data row38 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row39\" class=\"row_heading level0 row39\" >39</th>\n",
       "      <td id=\"T_2a01c_row39_col0\" class=\"data row39 col0\" >10.506503</td>\n",
       "      <td id=\"T_2a01c_row39_col1\" class=\"data row39 col1\" >47.000000</td>\n",
       "      <td id=\"T_2a01c_row39_col2\" class=\"data row39 col2\" >0.223543</td>\n",
       "      <td id=\"T_2a01c_row39_col3\" class=\"data row39 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row39_col4\" class=\"data row39 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row39_col5\" class=\"data row39 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row40\" class=\"row_heading level0 row40\" >40</th>\n",
       "      <td id=\"T_2a01c_row40_col0\" class=\"data row40 col0\" >51.195249</td>\n",
       "      <td id=\"T_2a01c_row40_col1\" class=\"data row40 col1\" >78.000000</td>\n",
       "      <td id=\"T_2a01c_row40_col2\" class=\"data row40 col2\" >0.656349</td>\n",
       "      <td id=\"T_2a01c_row40_col3\" class=\"data row40 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row40_col4\" class=\"data row40 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row40_col5\" class=\"data row40 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row41\" class=\"row_heading level0 row41\" >41</th>\n",
       "      <td id=\"T_2a01c_row41_col0\" class=\"data row41 col0\" >4.695080</td>\n",
       "      <td id=\"T_2a01c_row41_col1\" class=\"data row41 col1\" >29.000000</td>\n",
       "      <td id=\"T_2a01c_row41_col2\" class=\"data row41 col2\" >0.161899</td>\n",
       "      <td id=\"T_2a01c_row41_col3\" class=\"data row41 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row41_col4\" class=\"data row41 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row41_col5\" class=\"data row41 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row42\" class=\"row_heading level0 row42\" >42</th>\n",
       "      <td id=\"T_2a01c_row42_col0\" class=\"data row42 col0\" >29.134107</td>\n",
       "      <td id=\"T_2a01c_row42_col1\" class=\"data row42 col1\" >34.000000</td>\n",
       "      <td id=\"T_2a01c_row42_col2\" class=\"data row42 col2\" >0.856885</td>\n",
       "      <td id=\"T_2a01c_row42_col3\" class=\"data row42 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row42_col4\" class=\"data row42 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row42_col5\" class=\"data row42 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row43\" class=\"row_heading level0 row43\" >43</th>\n",
       "      <td id=\"T_2a01c_row43_col0\" class=\"data row43 col0\" >4.427515</td>\n",
       "      <td id=\"T_2a01c_row43_col1\" class=\"data row43 col1\" >90.000000</td>\n",
       "      <td id=\"T_2a01c_row43_col2\" class=\"data row43 col2\" >0.049195</td>\n",
       "      <td id=\"T_2a01c_row43_col3\" class=\"data row43 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row43_col4\" class=\"data row43 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row43_col5\" class=\"data row43 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row44\" class=\"row_heading level0 row44\" >44</th>\n",
       "      <td id=\"T_2a01c_row44_col0\" class=\"data row44 col0\" >6.670921</td>\n",
       "      <td id=\"T_2a01c_row44_col1\" class=\"data row44 col1\" >57.000000</td>\n",
       "      <td id=\"T_2a01c_row44_col2\" class=\"data row44 col2\" >0.117034</td>\n",
       "      <td id=\"T_2a01c_row44_col3\" class=\"data row44 col3\" >1</td>\n",
       "      <td id=\"T_2a01c_row44_col4\" class=\"data row44 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row44_col5\" class=\"data row44 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row45\" class=\"row_heading level0 row45\" >45</th>\n",
       "      <td id=\"T_2a01c_row45_col0\" class=\"data row45 col0\" >2.663422</td>\n",
       "      <td id=\"T_2a01c_row45_col1\" class=\"data row45 col1\" >3.000000</td>\n",
       "      <td id=\"T_2a01c_row45_col2\" class=\"data row45 col2\" >0.887807</td>\n",
       "      <td id=\"T_2a01c_row45_col3\" class=\"data row45 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row45_col4\" class=\"data row45 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row45_col5\" class=\"data row45 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row46\" class=\"row_heading level0 row46\" >46</th>\n",
       "      <td id=\"T_2a01c_row46_col0\" class=\"data row46 col0\" >23.310387</td>\n",
       "      <td id=\"T_2a01c_row46_col1\" class=\"data row46 col1\" >36.000000</td>\n",
       "      <td id=\"T_2a01c_row46_col2\" class=\"data row46 col2\" >0.647511</td>\n",
       "      <td id=\"T_2a01c_row46_col3\" class=\"data row46 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row46_col4\" class=\"data row46 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row46_col5\" class=\"data row46 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row47\" class=\"row_heading level0 row47\" >47</th>\n",
       "      <td id=\"T_2a01c_row47_col0\" class=\"data row47 col0\" >1.690302</td>\n",
       "      <td id=\"T_2a01c_row47_col1\" class=\"data row47 col1\" >2.000000</td>\n",
       "      <td id=\"T_2a01c_row47_col2\" class=\"data row47 col2\" >0.845151</td>\n",
       "      <td id=\"T_2a01c_row47_col3\" class=\"data row47 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row47_col4\" class=\"data row47 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row47_col5\" class=\"data row47 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row48\" class=\"row_heading level0 row48\" >48</th>\n",
       "      <td id=\"T_2a01c_row48_col0\" class=\"data row48 col0\" >34.944132</td>\n",
       "      <td id=\"T_2a01c_row48_col1\" class=\"data row48 col1\" >49.000000</td>\n",
       "      <td id=\"T_2a01c_row48_col2\" class=\"data row48 col2\" >0.713146</td>\n",
       "      <td id=\"T_2a01c_row48_col3\" class=\"data row48 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row48_col4\" class=\"data row48 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row48_col5\" class=\"data row48 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row49\" class=\"row_heading level0 row49\" >49</th>\n",
       "      <td id=\"T_2a01c_row49_col0\" class=\"data row49 col0\" >29.570705</td>\n",
       "      <td id=\"T_2a01c_row49_col1\" class=\"data row49 col1\" >76.000000</td>\n",
       "      <td id=\"T_2a01c_row49_col2\" class=\"data row49 col2\" >0.389088</td>\n",
       "      <td id=\"T_2a01c_row49_col3\" class=\"data row49 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row49_col4\" class=\"data row49 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row49_col5\" class=\"data row49 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row50\" class=\"row_heading level0 row50\" >50</th>\n",
       "      <td id=\"T_2a01c_row50_col0\" class=\"data row50 col0\" >4.130180</td>\n",
       "      <td id=\"T_2a01c_row50_col1\" class=\"data row50 col1\" >7.000000</td>\n",
       "      <td id=\"T_2a01c_row50_col2\" class=\"data row50 col2\" >0.590026</td>\n",
       "      <td id=\"T_2a01c_row50_col3\" class=\"data row50 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row50_col4\" class=\"data row50 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row50_col5\" class=\"data row50 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row51\" class=\"row_heading level0 row51\" >51</th>\n",
       "      <td id=\"T_2a01c_row51_col0\" class=\"data row51 col0\" >2.616280</td>\n",
       "      <td id=\"T_2a01c_row51_col1\" class=\"data row51 col1\" >32.000000</td>\n",
       "      <td id=\"T_2a01c_row51_col2\" class=\"data row51 col2\" >0.081759</td>\n",
       "      <td id=\"T_2a01c_row51_col3\" class=\"data row51 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row51_col4\" class=\"data row51 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row51_col5\" class=\"data row51 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row52\" class=\"row_heading level0 row52\" >52</th>\n",
       "      <td id=\"T_2a01c_row52_col0\" class=\"data row52 col0\" >22.761796</td>\n",
       "      <td id=\"T_2a01c_row52_col1\" class=\"data row52 col1\" >25.000000</td>\n",
       "      <td id=\"T_2a01c_row52_col2\" class=\"data row52 col2\" >0.910472</td>\n",
       "      <td id=\"T_2a01c_row52_col3\" class=\"data row52 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row52_col4\" class=\"data row52 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row52_col5\" class=\"data row52 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row53\" class=\"row_heading level0 row53\" >53</th>\n",
       "      <td id=\"T_2a01c_row53_col0\" class=\"data row53 col0\" >24.946729</td>\n",
       "      <td id=\"T_2a01c_row53_col1\" class=\"data row53 col1\" >62.000000</td>\n",
       "      <td id=\"T_2a01c_row53_col2\" class=\"data row53 col2\" >0.402367</td>\n",
       "      <td id=\"T_2a01c_row53_col3\" class=\"data row53 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row53_col4\" class=\"data row53 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row53_col5\" class=\"data row53 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row54\" class=\"row_heading level0 row54\" >54</th>\n",
       "      <td id=\"T_2a01c_row54_col0\" class=\"data row54 col0\" >2.430086</td>\n",
       "      <td id=\"T_2a01c_row54_col1\" class=\"data row54 col1\" >6.000000</td>\n",
       "      <td id=\"T_2a01c_row54_col2\" class=\"data row54 col2\" >0.405014</td>\n",
       "      <td id=\"T_2a01c_row54_col3\" class=\"data row54 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row54_col4\" class=\"data row54 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row54_col5\" class=\"data row54 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row55\" class=\"row_heading level0 row55\" >55</th>\n",
       "      <td id=\"T_2a01c_row55_col0\" class=\"data row55 col0\" >5.517388</td>\n",
       "      <td id=\"T_2a01c_row55_col1\" class=\"data row55 col1\" >10.000000</td>\n",
       "      <td id=\"T_2a01c_row55_col2\" class=\"data row55 col2\" >0.551739</td>\n",
       "      <td id=\"T_2a01c_row55_col3\" class=\"data row55 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row55_col4\" class=\"data row55 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row55_col5\" class=\"data row55 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row56\" class=\"row_heading level0 row56\" >56</th>\n",
       "      <td id=\"T_2a01c_row56_col0\" class=\"data row56 col0\" >39.198332</td>\n",
       "      <td id=\"T_2a01c_row56_col1\" class=\"data row56 col1\" >50.000000</td>\n",
       "      <td id=\"T_2a01c_row56_col2\" class=\"data row56 col2\" >0.783967</td>\n",
       "      <td id=\"T_2a01c_row56_col3\" class=\"data row56 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row56_col4\" class=\"data row56 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row56_col5\" class=\"data row56 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row57\" class=\"row_heading level0 row57\" >57</th>\n",
       "      <td id=\"T_2a01c_row57_col0\" class=\"data row57 col0\" >62.178111</td>\n",
       "      <td id=\"T_2a01c_row57_col1\" class=\"data row57 col1\" >83.000000</td>\n",
       "      <td id=\"T_2a01c_row57_col2\" class=\"data row57 col2\" >0.749134</td>\n",
       "      <td id=\"T_2a01c_row57_col3\" class=\"data row57 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row57_col4\" class=\"data row57 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row57_col5\" class=\"data row57 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row58\" class=\"row_heading level0 row58\" >58</th>\n",
       "      <td id=\"T_2a01c_row58_col0\" class=\"data row58 col0\" >8.197834</td>\n",
       "      <td id=\"T_2a01c_row58_col1\" class=\"data row58 col1\" >12.000000</td>\n",
       "      <td id=\"T_2a01c_row58_col2\" class=\"data row58 col2\" >0.683153</td>\n",
       "      <td id=\"T_2a01c_row58_col3\" class=\"data row58 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row58_col4\" class=\"data row58 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row58_col5\" class=\"data row58 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row59\" class=\"row_heading level0 row59\" >59</th>\n",
       "      <td id=\"T_2a01c_row59_col0\" class=\"data row59 col0\" >17.322224</td>\n",
       "      <td id=\"T_2a01c_row59_col1\" class=\"data row59 col1\" >37.000000</td>\n",
       "      <td id=\"T_2a01c_row59_col2\" class=\"data row59 col2\" >0.468168</td>\n",
       "      <td id=\"T_2a01c_row59_col3\" class=\"data row59 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row59_col4\" class=\"data row59 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row59_col5\" class=\"data row59 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row60\" class=\"row_heading level0 row60\" >60</th>\n",
       "      <td id=\"T_2a01c_row60_col0\" class=\"data row60 col0\" >3.487106</td>\n",
       "      <td id=\"T_2a01c_row60_col1\" class=\"data row60 col1\" >45.000000</td>\n",
       "      <td id=\"T_2a01c_row60_col2\" class=\"data row60 col2\" >0.077491</td>\n",
       "      <td id=\"T_2a01c_row60_col3\" class=\"data row60 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row60_col4\" class=\"data row60 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row60_col5\" class=\"data row60 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row61\" class=\"row_heading level0 row61\" >61</th>\n",
       "      <td id=\"T_2a01c_row61_col0\" class=\"data row61 col0\" >47.053764</td>\n",
       "      <td id=\"T_2a01c_row61_col1\" class=\"data row61 col1\" >48.000000</td>\n",
       "      <td id=\"T_2a01c_row61_col2\" class=\"data row61 col2\" >0.980287</td>\n",
       "      <td id=\"T_2a01c_row61_col3\" class=\"data row61 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row61_col4\" class=\"data row61 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row61_col5\" class=\"data row61 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row62\" class=\"row_heading level0 row62\" >62</th>\n",
       "      <td id=\"T_2a01c_row62_col0\" class=\"data row62 col0\" >31.153298</td>\n",
       "      <td id=\"T_2a01c_row62_col1\" class=\"data row62 col1\" >60.000000</td>\n",
       "      <td id=\"T_2a01c_row62_col2\" class=\"data row62 col2\" >0.519222</td>\n",
       "      <td id=\"T_2a01c_row62_col3\" class=\"data row62 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row62_col4\" class=\"data row62 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row62_col5\" class=\"data row62 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row63\" class=\"row_heading level0 row63\" >63</th>\n",
       "      <td id=\"T_2a01c_row63_col0\" class=\"data row63 col0\" >23.782086</td>\n",
       "      <td id=\"T_2a01c_row63_col1\" class=\"data row63 col1\" >44.000000</td>\n",
       "      <td id=\"T_2a01c_row63_col2\" class=\"data row63 col2\" >0.540502</td>\n",
       "      <td id=\"T_2a01c_row63_col3\" class=\"data row63 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row63_col4\" class=\"data row63 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row63_col5\" class=\"data row63 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row64\" class=\"row_heading level0 row64\" >64</th>\n",
       "      <td id=\"T_2a01c_row64_col0\" class=\"data row64 col0\" >3.697326</td>\n",
       "      <td id=\"T_2a01c_row64_col1\" class=\"data row64 col1\" >5.000000</td>\n",
       "      <td id=\"T_2a01c_row64_col2\" class=\"data row64 col2\" >0.739465</td>\n",
       "      <td id=\"T_2a01c_row64_col3\" class=\"data row64 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row64_col4\" class=\"data row64 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row64_col5\" class=\"data row64 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row65\" class=\"row_heading level0 row65\" >65</th>\n",
       "      <td id=\"T_2a01c_row65_col0\" class=\"data row65 col0\" >4.857835</td>\n",
       "      <td id=\"T_2a01c_row65_col1\" class=\"data row65 col1\" >15.000000</td>\n",
       "      <td id=\"T_2a01c_row65_col2\" class=\"data row65 col2\" >0.323856</td>\n",
       "      <td id=\"T_2a01c_row65_col3\" class=\"data row65 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row65_col4\" class=\"data row65 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row65_col5\" class=\"data row65 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row66\" class=\"row_heading level0 row66\" >66</th>\n",
       "      <td id=\"T_2a01c_row66_col0\" class=\"data row66 col0\" >6.112671</td>\n",
       "      <td id=\"T_2a01c_row66_col1\" class=\"data row66 col1\" >42.000000</td>\n",
       "      <td id=\"T_2a01c_row66_col2\" class=\"data row66 col2\" >0.145540</td>\n",
       "      <td id=\"T_2a01c_row66_col3\" class=\"data row66 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row66_col4\" class=\"data row66 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row66_col5\" class=\"data row66 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row67\" class=\"row_heading level0 row67\" >67</th>\n",
       "      <td id=\"T_2a01c_row67_col0\" class=\"data row67 col0\" >48.178175</td>\n",
       "      <td id=\"T_2a01c_row67_col1\" class=\"data row67 col1\" >93.000000</td>\n",
       "      <td id=\"T_2a01c_row67_col2\" class=\"data row67 col2\" >0.518045</td>\n",
       "      <td id=\"T_2a01c_row67_col3\" class=\"data row67 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row67_col4\" class=\"data row67 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row67_col5\" class=\"data row67 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row68\" class=\"row_heading level0 row68\" >68</th>\n",
       "      <td id=\"T_2a01c_row68_col0\" class=\"data row68 col0\" >13.215037</td>\n",
       "      <td id=\"T_2a01c_row68_col1\" class=\"data row68 col1\" >62.000000</td>\n",
       "      <td id=\"T_2a01c_row68_col2\" class=\"data row68 col2\" >0.213146</td>\n",
       "      <td id=\"T_2a01c_row68_col3\" class=\"data row68 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row68_col4\" class=\"data row68 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row68_col5\" class=\"data row68 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row69\" class=\"row_heading level0 row69\" >69</th>\n",
       "      <td id=\"T_2a01c_row69_col0\" class=\"data row69 col0\" >17.920919</td>\n",
       "      <td id=\"T_2a01c_row69_col1\" class=\"data row69 col1\" >25.000000</td>\n",
       "      <td id=\"T_2a01c_row69_col2\" class=\"data row69 col2\" >0.716837</td>\n",
       "      <td id=\"T_2a01c_row69_col3\" class=\"data row69 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row69_col4\" class=\"data row69 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row69_col5\" class=\"data row69 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row70\" class=\"row_heading level0 row70\" >70</th>\n",
       "      <td id=\"T_2a01c_row70_col0\" class=\"data row70 col0\" >56.817730</td>\n",
       "      <td id=\"T_2a01c_row70_col1\" class=\"data row70 col1\" >81.000000</td>\n",
       "      <td id=\"T_2a01c_row70_col2\" class=\"data row70 col2\" >0.701453</td>\n",
       "      <td id=\"T_2a01c_row70_col3\" class=\"data row70 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row70_col4\" class=\"data row70 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row70_col5\" class=\"data row70 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row71\" class=\"row_heading level0 row71\" >71</th>\n",
       "      <td id=\"T_2a01c_row71_col0\" class=\"data row71 col0\" >29.986040</td>\n",
       "      <td id=\"T_2a01c_row71_col1\" class=\"data row71 col1\" >96.000000</td>\n",
       "      <td id=\"T_2a01c_row71_col2\" class=\"data row71 col2\" >0.312355</td>\n",
       "      <td id=\"T_2a01c_row71_col3\" class=\"data row71 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row71_col4\" class=\"data row71 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row71_col5\" class=\"data row71 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row72\" class=\"row_heading level0 row72\" >72</th>\n",
       "      <td id=\"T_2a01c_row72_col0\" class=\"data row72 col0\" >19.639586</td>\n",
       "      <td id=\"T_2a01c_row72_col1\" class=\"data row72 col1\" >34.000000</td>\n",
       "      <td id=\"T_2a01c_row72_col2\" class=\"data row72 col2\" >0.577635</td>\n",
       "      <td id=\"T_2a01c_row72_col3\" class=\"data row72 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row72_col4\" class=\"data row72 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row72_col5\" class=\"data row72 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row73\" class=\"row_heading level0 row73\" >73</th>\n",
       "      <td id=\"T_2a01c_row73_col0\" class=\"data row73 col0\" >2.069987</td>\n",
       "      <td id=\"T_2a01c_row73_col1\" class=\"data row73 col1\" >76.000000</td>\n",
       "      <td id=\"T_2a01c_row73_col2\" class=\"data row73 col2\" >0.027237</td>\n",
       "      <td id=\"T_2a01c_row73_col3\" class=\"data row73 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row73_col4\" class=\"data row73 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row73_col5\" class=\"data row73 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row74\" class=\"row_heading level0 row74\" >74</th>\n",
       "      <td id=\"T_2a01c_row74_col0\" class=\"data row74 col0\" >82.890950</td>\n",
       "      <td id=\"T_2a01c_row74_col1\" class=\"data row74 col1\" >90.000000</td>\n",
       "      <td id=\"T_2a01c_row74_col2\" class=\"data row74 col2\" >0.921011</td>\n",
       "      <td id=\"T_2a01c_row74_col3\" class=\"data row74 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row74_col4\" class=\"data row74 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row74_col5\" class=\"data row74 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row75\" class=\"row_heading level0 row75\" >75</th>\n",
       "      <td id=\"T_2a01c_row75_col0\" class=\"data row75 col0\" >0.353504</td>\n",
       "      <td id=\"T_2a01c_row75_col1\" class=\"data row75 col1\" >4.000000</td>\n",
       "      <td id=\"T_2a01c_row75_col2\" class=\"data row75 col2\" >0.088376</td>\n",
       "      <td id=\"T_2a01c_row75_col3\" class=\"data row75 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row75_col4\" class=\"data row75 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row75_col5\" class=\"data row75 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row76\" class=\"row_heading level0 row76\" >76</th>\n",
       "      <td id=\"T_2a01c_row76_col0\" class=\"data row76 col0\" >26.951076</td>\n",
       "      <td id=\"T_2a01c_row76_col1\" class=\"data row76 col1\" >75.000000</td>\n",
       "      <td id=\"T_2a01c_row76_col2\" class=\"data row76 col2\" >0.359348</td>\n",
       "      <td id=\"T_2a01c_row76_col3\" class=\"data row76 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row76_col4\" class=\"data row76 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row76_col5\" class=\"data row76 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row77\" class=\"row_heading level0 row77\" >77</th>\n",
       "      <td id=\"T_2a01c_row77_col0\" class=\"data row77 col0\" >2.586535</td>\n",
       "      <td id=\"T_2a01c_row77_col1\" class=\"data row77 col1\" >48.000000</td>\n",
       "      <td id=\"T_2a01c_row77_col2\" class=\"data row77 col2\" >0.053886</td>\n",
       "      <td id=\"T_2a01c_row77_col3\" class=\"data row77 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row77_col4\" class=\"data row77 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row77_col5\" class=\"data row77 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row78\" class=\"row_heading level0 row78\" >78</th>\n",
       "      <td id=\"T_2a01c_row78_col0\" class=\"data row78 col0\" >54.407998</td>\n",
       "      <td id=\"T_2a01c_row78_col1\" class=\"data row78 col1\" >95.000000</td>\n",
       "      <td id=\"T_2a01c_row78_col2\" class=\"data row78 col2\" >0.572716</td>\n",
       "      <td id=\"T_2a01c_row78_col3\" class=\"data row78 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row78_col4\" class=\"data row78 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row78_col5\" class=\"data row78 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row79\" class=\"row_heading level0 row79\" >79</th>\n",
       "      <td id=\"T_2a01c_row79_col0\" class=\"data row79 col0\" >13.622262</td>\n",
       "      <td id=\"T_2a01c_row79_col1\" class=\"data row79 col1\" >21.000000</td>\n",
       "      <td id=\"T_2a01c_row79_col2\" class=\"data row79 col2\" >0.648679</td>\n",
       "      <td id=\"T_2a01c_row79_col3\" class=\"data row79 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row79_col4\" class=\"data row79 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row79_col5\" class=\"data row79 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row80\" class=\"row_heading level0 row80\" >80</th>\n",
       "      <td id=\"T_2a01c_row80_col0\" class=\"data row80 col0\" >11.588907</td>\n",
       "      <td id=\"T_2a01c_row80_col1\" class=\"data row80 col1\" >25.000000</td>\n",
       "      <td id=\"T_2a01c_row80_col2\" class=\"data row80 col2\" >0.463556</td>\n",
       "      <td id=\"T_2a01c_row80_col3\" class=\"data row80 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row80_col4\" class=\"data row80 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row80_col5\" class=\"data row80 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row81\" class=\"row_heading level0 row81\" >81</th>\n",
       "      <td id=\"T_2a01c_row81_col0\" class=\"data row81 col0\" >15.348872</td>\n",
       "      <td id=\"T_2a01c_row81_col1\" class=\"data row81 col1\" >29.000000</td>\n",
       "      <td id=\"T_2a01c_row81_col2\" class=\"data row81 col2\" >0.529271</td>\n",
       "      <td id=\"T_2a01c_row81_col3\" class=\"data row81 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row81_col4\" class=\"data row81 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row81_col5\" class=\"data row81 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row82\" class=\"row_heading level0 row82\" >82</th>\n",
       "      <td id=\"T_2a01c_row82_col0\" class=\"data row82 col0\" >2.829798</td>\n",
       "      <td id=\"T_2a01c_row82_col1\" class=\"data row82 col1\" >3.000000</td>\n",
       "      <td id=\"T_2a01c_row82_col2\" class=\"data row82 col2\" >0.943266</td>\n",
       "      <td id=\"T_2a01c_row82_col3\" class=\"data row82 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row82_col4\" class=\"data row82 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row82_col5\" class=\"data row82 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row83\" class=\"row_heading level0 row83\" >83</th>\n",
       "      <td id=\"T_2a01c_row83_col0\" class=\"data row83 col0\" >1.247644</td>\n",
       "      <td id=\"T_2a01c_row83_col1\" class=\"data row83 col1\" >48.000000</td>\n",
       "      <td id=\"T_2a01c_row83_col2\" class=\"data row83 col2\" >0.025993</td>\n",
       "      <td id=\"T_2a01c_row83_col3\" class=\"data row83 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row83_col4\" class=\"data row83 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row83_col5\" class=\"data row83 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row84\" class=\"row_heading level0 row84\" >84</th>\n",
       "      <td id=\"T_2a01c_row84_col0\" class=\"data row84 col0\" >10.587941</td>\n",
       "      <td id=\"T_2a01c_row84_col1\" class=\"data row84 col1\" >50.000000</td>\n",
       "      <td id=\"T_2a01c_row84_col2\" class=\"data row84 col2\" >0.211759</td>\n",
       "      <td id=\"T_2a01c_row84_col3\" class=\"data row84 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row84_col4\" class=\"data row84 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row84_col5\" class=\"data row84 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row85\" class=\"row_heading level0 row85\" >85</th>\n",
       "      <td id=\"T_2a01c_row85_col0\" class=\"data row85 col0\" >2.168698</td>\n",
       "      <td id=\"T_2a01c_row85_col1\" class=\"data row85 col1\" >15.000000</td>\n",
       "      <td id=\"T_2a01c_row85_col2\" class=\"data row85 col2\" >0.144580</td>\n",
       "      <td id=\"T_2a01c_row85_col3\" class=\"data row85 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row85_col4\" class=\"data row85 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row85_col5\" class=\"data row85 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row86\" class=\"row_heading level0 row86\" >86</th>\n",
       "      <td id=\"T_2a01c_row86_col0\" class=\"data row86 col0\" >9.385636</td>\n",
       "      <td id=\"T_2a01c_row86_col1\" class=\"data row86 col1\" >18.000000</td>\n",
       "      <td id=\"T_2a01c_row86_col2\" class=\"data row86 col2\" >0.521424</td>\n",
       "      <td id=\"T_2a01c_row86_col3\" class=\"data row86 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row86_col4\" class=\"data row86 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row86_col5\" class=\"data row86 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row87\" class=\"row_heading level0 row87\" >87</th>\n",
       "      <td id=\"T_2a01c_row87_col0\" class=\"data row87 col0\" >22.314612</td>\n",
       "      <td id=\"T_2a01c_row87_col1\" class=\"data row87 col1\" >50.000000</td>\n",
       "      <td id=\"T_2a01c_row87_col2\" class=\"data row87 col2\" >0.446292</td>\n",
       "      <td id=\"T_2a01c_row87_col3\" class=\"data row87 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row87_col4\" class=\"data row87 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row87_col5\" class=\"data row87 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row88\" class=\"row_heading level0 row88\" >88</th>\n",
       "      <td id=\"T_2a01c_row88_col0\" class=\"data row88 col0\" >67.562252</td>\n",
       "      <td id=\"T_2a01c_row88_col1\" class=\"data row88 col1\" >74.000000</td>\n",
       "      <td id=\"T_2a01c_row88_col2\" class=\"data row88 col2\" >0.913003</td>\n",
       "      <td id=\"T_2a01c_row88_col3\" class=\"data row88 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row88_col4\" class=\"data row88 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row88_col5\" class=\"data row88 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row89\" class=\"row_heading level0 row89\" >89</th>\n",
       "      <td id=\"T_2a01c_row89_col0\" class=\"data row89 col0\" >1.699050</td>\n",
       "      <td id=\"T_2a01c_row89_col1\" class=\"data row89 col1\" >3.000000</td>\n",
       "      <td id=\"T_2a01c_row89_col2\" class=\"data row89 col2\" >0.566350</td>\n",
       "      <td id=\"T_2a01c_row89_col3\" class=\"data row89 col3\" >2</td>\n",
       "      <td id=\"T_2a01c_row89_col4\" class=\"data row89 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row89_col5\" class=\"data row89 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row90\" class=\"row_heading level0 row90\" >90</th>\n",
       "      <td id=\"T_2a01c_row90_col0\" class=\"data row90 col0\" >18.213357</td>\n",
       "      <td id=\"T_2a01c_row90_col1\" class=\"data row90 col1\" >59.000000</td>\n",
       "      <td id=\"T_2a01c_row90_col2\" class=\"data row90 col2\" >0.308701</td>\n",
       "      <td id=\"T_2a01c_row90_col3\" class=\"data row90 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row90_col4\" class=\"data row90 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row90_col5\" class=\"data row90 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row91\" class=\"row_heading level0 row91\" >91</th>\n",
       "      <td id=\"T_2a01c_row91_col0\" class=\"data row91 col0\" >46.593959</td>\n",
       "      <td id=\"T_2a01c_row91_col1\" class=\"data row91 col1\" >64.000000</td>\n",
       "      <td id=\"T_2a01c_row91_col2\" class=\"data row91 col2\" >0.728031</td>\n",
       "      <td id=\"T_2a01c_row91_col3\" class=\"data row91 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row91_col4\" class=\"data row91 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row91_col5\" class=\"data row91 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row92\" class=\"row_heading level0 row92\" >92</th>\n",
       "      <td id=\"T_2a01c_row92_col0\" class=\"data row92 col0\" >35.804741</td>\n",
       "      <td id=\"T_2a01c_row92_col1\" class=\"data row92 col1\" >48.000000</td>\n",
       "      <td id=\"T_2a01c_row92_col2\" class=\"data row92 col2\" >0.745932</td>\n",
       "      <td id=\"T_2a01c_row92_col3\" class=\"data row92 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row92_col4\" class=\"data row92 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row92_col5\" class=\"data row92 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row93\" class=\"row_heading level0 row93\" >93</th>\n",
       "      <td id=\"T_2a01c_row93_col0\" class=\"data row93 col0\" >32.795522</td>\n",
       "      <td id=\"T_2a01c_row93_col1\" class=\"data row93 col1\" >63.000000</td>\n",
       "      <td id=\"T_2a01c_row93_col2\" class=\"data row93 col2\" >0.520564</td>\n",
       "      <td id=\"T_2a01c_row93_col3\" class=\"data row93 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row93_col4\" class=\"data row93 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row93_col5\" class=\"data row93 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row94\" class=\"row_heading level0 row94\" >94</th>\n",
       "      <td id=\"T_2a01c_row94_col0\" class=\"data row94 col0\" >36.991253</td>\n",
       "      <td id=\"T_2a01c_row94_col1\" class=\"data row94 col1\" >43.000000</td>\n",
       "      <td id=\"T_2a01c_row94_col2\" class=\"data row94 col2\" >0.860262</td>\n",
       "      <td id=\"T_2a01c_row94_col3\" class=\"data row94 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row94_col4\" class=\"data row94 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row94_col5\" class=\"data row94 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row95\" class=\"row_heading level0 row95\" >95</th>\n",
       "      <td id=\"T_2a01c_row95_col0\" class=\"data row95 col0\" >27.478306</td>\n",
       "      <td id=\"T_2a01c_row95_col1\" class=\"data row95 col1\" >37.000000</td>\n",
       "      <td id=\"T_2a01c_row95_col2\" class=\"data row95 col2\" >0.742657</td>\n",
       "      <td id=\"T_2a01c_row95_col3\" class=\"data row95 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row95_col4\" class=\"data row95 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row95_col5\" class=\"data row95 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row96\" class=\"row_heading level0 row96\" >96</th>\n",
       "      <td id=\"T_2a01c_row96_col0\" class=\"data row96 col0\" >31.462104</td>\n",
       "      <td id=\"T_2a01c_row96_col1\" class=\"data row96 col1\" >32.000000</td>\n",
       "      <td id=\"T_2a01c_row96_col2\" class=\"data row96 col2\" >0.983191</td>\n",
       "      <td id=\"T_2a01c_row96_col3\" class=\"data row96 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row96_col4\" class=\"data row96 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row96_col5\" class=\"data row96 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row97\" class=\"row_heading level0 row97\" >97</th>\n",
       "      <td id=\"T_2a01c_row97_col0\" class=\"data row97 col0\" >9.612109</td>\n",
       "      <td id=\"T_2a01c_row97_col1\" class=\"data row97 col1\" >34.000000</td>\n",
       "      <td id=\"T_2a01c_row97_col2\" class=\"data row97 col2\" >0.282709</td>\n",
       "      <td id=\"T_2a01c_row97_col3\" class=\"data row97 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row97_col4\" class=\"data row97 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row97_col5\" class=\"data row97 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row98\" class=\"row_heading level0 row98\" >98</th>\n",
       "      <td id=\"T_2a01c_row98_col0\" class=\"data row98 col0\" >3.637474</td>\n",
       "      <td id=\"T_2a01c_row98_col1\" class=\"data row98 col1\" >15.000000</td>\n",
       "      <td id=\"T_2a01c_row98_col2\" class=\"data row98 col2\" >0.242498</td>\n",
       "      <td id=\"T_2a01c_row98_col3\" class=\"data row98 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row98_col4\" class=\"data row98 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row98_col5\" class=\"data row98 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row99\" class=\"row_heading level0 row99\" >99</th>\n",
       "      <td id=\"T_2a01c_row99_col0\" class=\"data row99 col0\" >3.109609</td>\n",
       "      <td id=\"T_2a01c_row99_col1\" class=\"data row99 col1\" >4.000000</td>\n",
       "      <td id=\"T_2a01c_row99_col2\" class=\"data row99 col2\" >0.777402</td>\n",
       "      <td id=\"T_2a01c_row99_col3\" class=\"data row99 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row99_col4\" class=\"data row99 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row99_col5\" class=\"data row99 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row100\" class=\"row_heading level0 row100\" >100</th>\n",
       "      <td id=\"T_2a01c_row100_col0\" class=\"data row100 col0\" >25.533484</td>\n",
       "      <td id=\"T_2a01c_row100_col1\" class=\"data row100 col1\" >34.000000</td>\n",
       "      <td id=\"T_2a01c_row100_col2\" class=\"data row100 col2\" >0.750985</td>\n",
       "      <td id=\"T_2a01c_row100_col3\" class=\"data row100 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row100_col4\" class=\"data row100 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row100_col5\" class=\"data row100 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row101\" class=\"row_heading level0 row101\" >101</th>\n",
       "      <td id=\"T_2a01c_row101_col0\" class=\"data row101 col0\" >6.294579</td>\n",
       "      <td id=\"T_2a01c_row101_col1\" class=\"data row101 col1\" >19.000000</td>\n",
       "      <td id=\"T_2a01c_row101_col2\" class=\"data row101 col2\" >0.331294</td>\n",
       "      <td id=\"T_2a01c_row101_col3\" class=\"data row101 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row101_col4\" class=\"data row101 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row101_col5\" class=\"data row101 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row102\" class=\"row_heading level0 row102\" >102</th>\n",
       "      <td id=\"T_2a01c_row102_col0\" class=\"data row102 col0\" >16.322602</td>\n",
       "      <td id=\"T_2a01c_row102_col1\" class=\"data row102 col1\" >28.000000</td>\n",
       "      <td id=\"T_2a01c_row102_col2\" class=\"data row102 col2\" >0.582950</td>\n",
       "      <td id=\"T_2a01c_row102_col3\" class=\"data row102 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row102_col4\" class=\"data row102 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row102_col5\" class=\"data row102 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row103\" class=\"row_heading level0 row103\" >103</th>\n",
       "      <td id=\"T_2a01c_row103_col0\" class=\"data row103 col0\" >15.401182</td>\n",
       "      <td id=\"T_2a01c_row103_col1\" class=\"data row103 col1\" >30.000000</td>\n",
       "      <td id=\"T_2a01c_row103_col2\" class=\"data row103 col2\" >0.513373</td>\n",
       "      <td id=\"T_2a01c_row103_col3\" class=\"data row103 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row103_col4\" class=\"data row103 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row103_col5\" class=\"data row103 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row104\" class=\"row_heading level0 row104\" >104</th>\n",
       "      <td id=\"T_2a01c_row104_col0\" class=\"data row104 col0\" >13.430692</td>\n",
       "      <td id=\"T_2a01c_row104_col1\" class=\"data row104 col1\" >23.000000</td>\n",
       "      <td id=\"T_2a01c_row104_col2\" class=\"data row104 col2\" >0.583943</td>\n",
       "      <td id=\"T_2a01c_row104_col3\" class=\"data row104 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row104_col4\" class=\"data row104 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row104_col5\" class=\"data row104 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row105\" class=\"row_heading level0 row105\" >105</th>\n",
       "      <td id=\"T_2a01c_row105_col0\" class=\"data row105 col0\" >0.497480</td>\n",
       "      <td id=\"T_2a01c_row105_col1\" class=\"data row105 col1\" >1.000000</td>\n",
       "      <td id=\"T_2a01c_row105_col2\" class=\"data row105 col2\" >0.497480</td>\n",
       "      <td id=\"T_2a01c_row105_col3\" class=\"data row105 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row105_col4\" class=\"data row105 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row105_col5\" class=\"data row105 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row106\" class=\"row_heading level0 row106\" >106</th>\n",
       "      <td id=\"T_2a01c_row106_col0\" class=\"data row106 col0\" >28.999642</td>\n",
       "      <td id=\"T_2a01c_row106_col1\" class=\"data row106 col1\" >37.000000</td>\n",
       "      <td id=\"T_2a01c_row106_col2\" class=\"data row106 col2\" >0.783774</td>\n",
       "      <td id=\"T_2a01c_row106_col3\" class=\"data row106 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row106_col4\" class=\"data row106 col4\" >8</td>\n",
       "      <td id=\"T_2a01c_row106_col5\" class=\"data row106 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row107\" class=\"row_heading level0 row107\" >107</th>\n",
       "      <td id=\"T_2a01c_row107_col0\" class=\"data row107 col0\" >81.729703</td>\n",
       "      <td id=\"T_2a01c_row107_col1\" class=\"data row107 col1\" >95.000000</td>\n",
       "      <td id=\"T_2a01c_row107_col2\" class=\"data row107 col2\" >0.860313</td>\n",
       "      <td id=\"T_2a01c_row107_col3\" class=\"data row107 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row107_col4\" class=\"data row107 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row107_col5\" class=\"data row107 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row108\" class=\"row_heading level0 row108\" >108</th>\n",
       "      <td id=\"T_2a01c_row108_col0\" class=\"data row108 col0\" >0.227125</td>\n",
       "      <td id=\"T_2a01c_row108_col1\" class=\"data row108 col1\" >25.000000</td>\n",
       "      <td id=\"T_2a01c_row108_col2\" class=\"data row108 col2\" >0.009085</td>\n",
       "      <td id=\"T_2a01c_row108_col3\" class=\"data row108 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row108_col4\" class=\"data row108 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row108_col5\" class=\"data row108 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row109\" class=\"row_heading level0 row109\" >109</th>\n",
       "      <td id=\"T_2a01c_row109_col0\" class=\"data row109 col0\" >12.824170</td>\n",
       "      <td id=\"T_2a01c_row109_col1\" class=\"data row109 col1\" >19.000000</td>\n",
       "      <td id=\"T_2a01c_row109_col2\" class=\"data row109 col2\" >0.674956</td>\n",
       "      <td id=\"T_2a01c_row109_col3\" class=\"data row109 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row109_col4\" class=\"data row109 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row109_col5\" class=\"data row109 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row110\" class=\"row_heading level0 row110\" >110</th>\n",
       "      <td id=\"T_2a01c_row110_col0\" class=\"data row110 col0\" >5.434368</td>\n",
       "      <td id=\"T_2a01c_row110_col1\" class=\"data row110 col1\" >20.000000</td>\n",
       "      <td id=\"T_2a01c_row110_col2\" class=\"data row110 col2\" >0.271718</td>\n",
       "      <td id=\"T_2a01c_row110_col3\" class=\"data row110 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row110_col4\" class=\"data row110 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row110_col5\" class=\"data row110 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row111\" class=\"row_heading level0 row111\" >111</th>\n",
       "      <td id=\"T_2a01c_row111_col0\" class=\"data row111 col0\" >4.438496</td>\n",
       "      <td id=\"T_2a01c_row111_col1\" class=\"data row111 col1\" >60.000000</td>\n",
       "      <td id=\"T_2a01c_row111_col2\" class=\"data row111 col2\" >0.073975</td>\n",
       "      <td id=\"T_2a01c_row111_col3\" class=\"data row111 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row111_col4\" class=\"data row111 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row111_col5\" class=\"data row111 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row112\" class=\"row_heading level0 row112\" >112</th>\n",
       "      <td id=\"T_2a01c_row112_col0\" class=\"data row112 col0\" >6.814216</td>\n",
       "      <td id=\"T_2a01c_row112_col1\" class=\"data row112 col1\" >25.000000</td>\n",
       "      <td id=\"T_2a01c_row112_col2\" class=\"data row112 col2\" >0.272569</td>\n",
       "      <td id=\"T_2a01c_row112_col3\" class=\"data row112 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row112_col4\" class=\"data row112 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row112_col5\" class=\"data row112 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row113\" class=\"row_heading level0 row113\" >113</th>\n",
       "      <td id=\"T_2a01c_row113_col0\" class=\"data row113 col0\" >2.135169</td>\n",
       "      <td id=\"T_2a01c_row113_col1\" class=\"data row113 col1\" >51.000000</td>\n",
       "      <td id=\"T_2a01c_row113_col2\" class=\"data row113 col2\" >0.041866</td>\n",
       "      <td id=\"T_2a01c_row113_col3\" class=\"data row113 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row113_col4\" class=\"data row113 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row113_col5\" class=\"data row113 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row114\" class=\"row_heading level0 row114\" >114</th>\n",
       "      <td id=\"T_2a01c_row114_col0\" class=\"data row114 col0\" >8.407945</td>\n",
       "      <td id=\"T_2a01c_row114_col1\" class=\"data row114 col1\" >23.000000</td>\n",
       "      <td id=\"T_2a01c_row114_col2\" class=\"data row114 col2\" >0.365563</td>\n",
       "      <td id=\"T_2a01c_row114_col3\" class=\"data row114 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row114_col4\" class=\"data row114 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row114_col5\" class=\"data row114 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row115\" class=\"row_heading level0 row115\" >115</th>\n",
       "      <td id=\"T_2a01c_row115_col0\" class=\"data row115 col0\" >34.673631</td>\n",
       "      <td id=\"T_2a01c_row115_col1\" class=\"data row115 col1\" >82.000000</td>\n",
       "      <td id=\"T_2a01c_row115_col2\" class=\"data row115 col2\" >0.422849</td>\n",
       "      <td id=\"T_2a01c_row115_col3\" class=\"data row115 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row115_col4\" class=\"data row115 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row115_col5\" class=\"data row115 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row116\" class=\"row_heading level0 row116\" >116</th>\n",
       "      <td id=\"T_2a01c_row116_col0\" class=\"data row116 col0\" >0.763221</td>\n",
       "      <td id=\"T_2a01c_row116_col1\" class=\"data row116 col1\" >7.000000</td>\n",
       "      <td id=\"T_2a01c_row116_col2\" class=\"data row116 col2\" >0.109032</td>\n",
       "      <td id=\"T_2a01c_row116_col3\" class=\"data row116 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row116_col4\" class=\"data row116 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row116_col5\" class=\"data row116 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row117\" class=\"row_heading level0 row117\" >117</th>\n",
       "      <td id=\"T_2a01c_row117_col0\" class=\"data row117 col0\" >57.709262</td>\n",
       "      <td id=\"T_2a01c_row117_col1\" class=\"data row117 col1\" >73.000000</td>\n",
       "      <td id=\"T_2a01c_row117_col2\" class=\"data row117 col2\" >0.790538</td>\n",
       "      <td id=\"T_2a01c_row117_col3\" class=\"data row117 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row117_col4\" class=\"data row117 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row117_col5\" class=\"data row117 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row118\" class=\"row_heading level0 row118\" >118</th>\n",
       "      <td id=\"T_2a01c_row118_col0\" class=\"data row118 col0\" >17.212456</td>\n",
       "      <td id=\"T_2a01c_row118_col1\" class=\"data row118 col1\" >18.000000</td>\n",
       "      <td id=\"T_2a01c_row118_col2\" class=\"data row118 col2\" >0.956248</td>\n",
       "      <td id=\"T_2a01c_row118_col3\" class=\"data row118 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row118_col4\" class=\"data row118 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row118_col5\" class=\"data row118 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row119\" class=\"row_heading level0 row119\" >119</th>\n",
       "      <td id=\"T_2a01c_row119_col0\" class=\"data row119 col0\" >3.025334</td>\n",
       "      <td id=\"T_2a01c_row119_col1\" class=\"data row119 col1\" >18.000000</td>\n",
       "      <td id=\"T_2a01c_row119_col2\" class=\"data row119 col2\" >0.168074</td>\n",
       "      <td id=\"T_2a01c_row119_col3\" class=\"data row119 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row119_col4\" class=\"data row119 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row119_col5\" class=\"data row119 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row120\" class=\"row_heading level0 row120\" >120</th>\n",
       "      <td id=\"T_2a01c_row120_col0\" class=\"data row120 col0\" >3.642924</td>\n",
       "      <td id=\"T_2a01c_row120_col1\" class=\"data row120 col1\" >25.000000</td>\n",
       "      <td id=\"T_2a01c_row120_col2\" class=\"data row120 col2\" >0.145717</td>\n",
       "      <td id=\"T_2a01c_row120_col3\" class=\"data row120 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row120_col4\" class=\"data row120 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row120_col5\" class=\"data row120 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row121\" class=\"row_heading level0 row121\" >121</th>\n",
       "      <td id=\"T_2a01c_row121_col0\" class=\"data row121 col0\" >21.878428</td>\n",
       "      <td id=\"T_2a01c_row121_col1\" class=\"data row121 col1\" >39.000000</td>\n",
       "      <td id=\"T_2a01c_row121_col2\" class=\"data row121 col2\" >0.560985</td>\n",
       "      <td id=\"T_2a01c_row121_col3\" class=\"data row121 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row121_col4\" class=\"data row121 col4\" >9</td>\n",
       "      <td id=\"T_2a01c_row121_col5\" class=\"data row121 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row122\" class=\"row_heading level0 row122\" >122</th>\n",
       "      <td id=\"T_2a01c_row122_col0\" class=\"data row122 col0\" >52.940932</td>\n",
       "      <td id=\"T_2a01c_row122_col1\" class=\"data row122 col1\" >74.000000</td>\n",
       "      <td id=\"T_2a01c_row122_col2\" class=\"data row122 col2\" >0.715418</td>\n",
       "      <td id=\"T_2a01c_row122_col3\" class=\"data row122 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row122_col4\" class=\"data row122 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row122_col5\" class=\"data row122 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row123\" class=\"row_heading level0 row123\" >123</th>\n",
       "      <td id=\"T_2a01c_row123_col0\" class=\"data row123 col0\" >41.778658</td>\n",
       "      <td id=\"T_2a01c_row123_col1\" class=\"data row123 col1\" >54.000000</td>\n",
       "      <td id=\"T_2a01c_row123_col2\" class=\"data row123 col2\" >0.773679</td>\n",
       "      <td id=\"T_2a01c_row123_col3\" class=\"data row123 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row123_col4\" class=\"data row123 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row123_col5\" class=\"data row123 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row124\" class=\"row_heading level0 row124\" >124</th>\n",
       "      <td id=\"T_2a01c_row124_col0\" class=\"data row124 col0\" >2.115377</td>\n",
       "      <td id=\"T_2a01c_row124_col1\" class=\"data row124 col1\" >16.000000</td>\n",
       "      <td id=\"T_2a01c_row124_col2\" class=\"data row124 col2\" >0.132211</td>\n",
       "      <td id=\"T_2a01c_row124_col3\" class=\"data row124 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row124_col4\" class=\"data row124 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row124_col5\" class=\"data row124 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row125\" class=\"row_heading level0 row125\" >125</th>\n",
       "      <td id=\"T_2a01c_row125_col0\" class=\"data row125 col0\" >4.700381</td>\n",
       "      <td id=\"T_2a01c_row125_col1\" class=\"data row125 col1\" >36.000000</td>\n",
       "      <td id=\"T_2a01c_row125_col2\" class=\"data row125 col2\" >0.130566</td>\n",
       "      <td id=\"T_2a01c_row125_col3\" class=\"data row125 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row125_col4\" class=\"data row125 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row125_col5\" class=\"data row125 col5\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row126\" class=\"row_heading level0 row126\" >126</th>\n",
       "      <td id=\"T_2a01c_row126_col0\" class=\"data row126 col0\" >62.391901</td>\n",
       "      <td id=\"T_2a01c_row126_col1\" class=\"data row126 col1\" >64.000000</td>\n",
       "      <td id=\"T_2a01c_row126_col2\" class=\"data row126 col2\" >0.974873</td>\n",
       "      <td id=\"T_2a01c_row126_col3\" class=\"data row126 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row126_col4\" class=\"data row126 col4\" >1</td>\n",
       "      <td id=\"T_2a01c_row126_col5\" class=\"data row126 col5\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row127\" class=\"row_heading level0 row127\" >127</th>\n",
       "      <td id=\"T_2a01c_row127_col0\" class=\"data row127 col0\" >2.806955</td>\n",
       "      <td id=\"T_2a01c_row127_col1\" class=\"data row127 col1\" >38.000000</td>\n",
       "      <td id=\"T_2a01c_row127_col2\" class=\"data row127 col2\" >0.073867</td>\n",
       "      <td id=\"T_2a01c_row127_col3\" class=\"data row127 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row127_col4\" class=\"data row127 col4\" >2</td>\n",
       "      <td id=\"T_2a01c_row127_col5\" class=\"data row127 col5\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row128\" class=\"row_heading level0 row128\" >128</th>\n",
       "      <td id=\"T_2a01c_row128_col0\" class=\"data row128 col0\" >62.926819</td>\n",
       "      <td id=\"T_2a01c_row128_col1\" class=\"data row128 col1\" >91.000000</td>\n",
       "      <td id=\"T_2a01c_row128_col2\" class=\"data row128 col2\" >0.691504</td>\n",
       "      <td id=\"T_2a01c_row128_col3\" class=\"data row128 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row128_col4\" class=\"data row128 col4\" >7</td>\n",
       "      <td id=\"T_2a01c_row128_col5\" class=\"data row128 col5\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row129\" class=\"row_heading level0 row129\" >129</th>\n",
       "      <td id=\"T_2a01c_row129_col0\" class=\"data row129 col0\" >5.098761</td>\n",
       "      <td id=\"T_2a01c_row129_col1\" class=\"data row129 col1\" >12.000000</td>\n",
       "      <td id=\"T_2a01c_row129_col2\" class=\"data row129 col2\" >0.424897</td>\n",
       "      <td id=\"T_2a01c_row129_col3\" class=\"data row129 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row129_col4\" class=\"data row129 col4\" >3</td>\n",
       "      <td id=\"T_2a01c_row129_col5\" class=\"data row129 col5\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row130\" class=\"row_heading level0 row130\" >130</th>\n",
       "      <td id=\"T_2a01c_row130_col0\" class=\"data row130 col0\" >52.668893</td>\n",
       "      <td id=\"T_2a01c_row130_col1\" class=\"data row130 col1\" >70.000000</td>\n",
       "      <td id=\"T_2a01c_row130_col2\" class=\"data row130 col2\" >0.752413</td>\n",
       "      <td id=\"T_2a01c_row130_col3\" class=\"data row130 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row130_col4\" class=\"data row130 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row130_col5\" class=\"data row130 col5\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row131\" class=\"row_heading level0 row131\" >131</th>\n",
       "      <td id=\"T_2a01c_row131_col0\" class=\"data row131 col0\" >45.420888</td>\n",
       "      <td id=\"T_2a01c_row131_col1\" class=\"data row131 col1\" >77.000000</td>\n",
       "      <td id=\"T_2a01c_row131_col2\" class=\"data row131 col2\" >0.589882</td>\n",
       "      <td id=\"T_2a01c_row131_col3\" class=\"data row131 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row131_col4\" class=\"data row131 col4\" >4</td>\n",
       "      <td id=\"T_2a01c_row131_col5\" class=\"data row131 col5\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row132\" class=\"row_heading level0 row132\" >132</th>\n",
       "      <td id=\"T_2a01c_row132_col0\" class=\"data row132 col0\" >44.050197</td>\n",
       "      <td id=\"T_2a01c_row132_col1\" class=\"data row132 col1\" >63.000000</td>\n",
       "      <td id=\"T_2a01c_row132_col2\" class=\"data row132 col2\" >0.699209</td>\n",
       "      <td id=\"T_2a01c_row132_col3\" class=\"data row132 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row132_col4\" class=\"data row132 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row132_col5\" class=\"data row132 col5\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row133\" class=\"row_heading level0 row133\" >133</th>\n",
       "      <td id=\"T_2a01c_row133_col0\" class=\"data row133 col0\" >56.069997</td>\n",
       "      <td id=\"T_2a01c_row133_col1\" class=\"data row133 col1\" >96.000000</td>\n",
       "      <td id=\"T_2a01c_row133_col2\" class=\"data row133 col2\" >0.584062</td>\n",
       "      <td id=\"T_2a01c_row133_col3\" class=\"data row133 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row133_col4\" class=\"data row133 col4\" >6</td>\n",
       "      <td id=\"T_2a01c_row133_col5\" class=\"data row133 col5\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_2a01c_level0_row134\" class=\"row_heading level0 row134\" >134</th>\n",
       "      <td id=\"T_2a01c_row134_col0\" class=\"data row134 col0\" >1.110640</td>\n",
       "      <td id=\"T_2a01c_row134_col1\" class=\"data row134 col1\" >8.000000</td>\n",
       "      <td id=\"T_2a01c_row134_col2\" class=\"data row134 col2\" >0.138830</td>\n",
       "      <td id=\"T_2a01c_row134_col3\" class=\"data row134 col3\" >3</td>\n",
       "      <td id=\"T_2a01c_row134_col4\" class=\"data row134 col4\" >5</td>\n",
       "      <td id=\"T_2a01c_row134_col5\" class=\"data row134 col5\" >9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x11f4c0eb0>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# transaction_fact table\n",
    "query = \"\"\"SELECT * FROM transaction_fact\"\"\"\n",
    "df_mysql = pd.read_sql(query, con = connection)\n",
    "df_mysql.style"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "57c9d2f9",
   "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>total_cost</th>\n",
       "      <th>date_key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2381.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1850.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1864.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   total_cost  date_key\n",
       "0      2381.0         1\n",
       "1      1850.0         3\n",
       "2      1864.0         2"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# market_value_fact table\n",
    "query = \"\"\"SELECT * FROM market_value_fact\"\"\"\n",
    "df_mysql = pd.read_sql(query, con = connection)\n",
    "df_mysql.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "bc243aa2",
   "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>index</th>\n",
       "      <th>trade_date</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>date_key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1/3/2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>45</td>\n",
       "      <td>1/4/2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>90</td>\n",
       "      <td>1/5/2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index trade_date  year  month  day  date_key\n",
       "0      0   1/3/2022  2022      3    1         1\n",
       "1     45   1/4/2022  2022      4    1         2\n",
       "2     90   1/5/2022  2022      5    1         3"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# date_dim table\n",
    "query = \"\"\"SELECT * FROM date_dim\"\"\"\n",
    "df_mysql = pd.read_sql(query, con = connection)\n",
    "df_mysql.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "8351a8e3",
   "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>index</th>\n",
       "      <th>trader</th>\n",
       "      <th>fund</th>\n",
       "      <th>trader_key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Ricky</td>\n",
       "      <td>Equity Fund</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Ethel</td>\n",
       "      <td>Equity Fund</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Lucy</td>\n",
       "      <td>Future Fund</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Ricky</td>\n",
       "      <td>Future Fund</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>Lucy</td>\n",
       "      <td>Treasuries Fund</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index trader             fund  trader_key\n",
       "0      0  Ricky      Equity Fund           1\n",
       "1      1  Ethel      Equity Fund           2\n",
       "2      3   Lucy      Future Fund           3\n",
       "3      4  Ricky      Future Fund           4\n",
       "4      6   Lucy  Treasuries Fund           5"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# trader_dim table\n",
    "query = \"\"\"SELECT * FROM trader_dim\"\"\"\n",
    "df_mysql = pd.read_sql(query, con = connection)\n",
    "df_mysql.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "b8452901",
   "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>index</th>\n",
       "      <th>security</th>\n",
       "      <th>security_key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>IBM</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>GOOG</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>TSLA</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>EDU8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>ZCU23</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index security  security_key\n",
       "0      0      IBM             1\n",
       "1      1     GOOG             2\n",
       "2      2     TSLA             3\n",
       "3      3     EDU8             4\n",
       "4      4    ZCU23             5"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# security_dim table\n",
    "query = \"\"\"SELECT * FROM security_dim\"\"\"\n",
    "df_mysql = pd.read_sql(query, con = connection)\n",
    "df_mysql.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5ba85851",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e60daffd",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "myenv",
   "language": "python",
   "name": "myenv"
  },
  "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.9.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}