Tutorial_052_InClassExercises.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# In class exercises - Intro to Pandas Series and DataFrames"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import libs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## First import 'response_time_data.csv' data file\n",
    "* Contains RTs from 800 trials of a simple detection task from each of 20 subjects\n",
    "* Organizing into a DataFrame and then saved out in csv format\n",
    "* The index (row) and column labels are encoded in the csv file, so you'll need to read those in explcitly\n",
    "* Make sure to have a look at the DataFrame - use the df.head() function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Sub0</th>\n",
       "      <th>Sub1</th>\n",
       "      <th>Sub2</th>\n",
       "      <th>Sub3</th>\n",
       "      <th>Sub4</th>\n",
       "      <th>Sub5</th>\n",
       "      <th>Sub6</th>\n",
       "      <th>Sub7</th>\n",
       "      <th>Sub8</th>\n",
       "      <th>Sub9</th>\n",
       "      <th>Sub10</th>\n",
       "      <th>Sub11</th>\n",
       "      <th>Sub12</th>\n",
       "      <th>Sub13</th>\n",
       "      <th>Sub14</th>\n",
       "      <th>Sub15</th>\n",
       "      <th>Sub16</th>\n",
       "      <th>Sub17</th>\n",
       "      <th>Sub18</th>\n",
       "      <th>Sub19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Tri0</th>\n",
       "      <td>2797.224240</td>\n",
       "      <td>1039.571212</td>\n",
       "      <td>4045.345952</td>\n",
       "      <td>3530.934210</td>\n",
       "      <td>2410.276348</td>\n",
       "      <td>6541.494156</td>\n",
       "      <td>1977.919842</td>\n",
       "      <td>2343.555594</td>\n",
       "      <td>143.695964</td>\n",
       "      <td>8147.939691</td>\n",
       "      <td>5183.942423</td>\n",
       "      <td>4548.240971</td>\n",
       "      <td>2076.921296</td>\n",
       "      <td>4230.548795</td>\n",
       "      <td>4134.589984</td>\n",
       "      <td>2067.132295</td>\n",
       "      <td>4087.049471</td>\n",
       "      <td>2704.327437</td>\n",
       "      <td>2790.476384</td>\n",
       "      <td>5141.106292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri1</th>\n",
       "      <td>786.895089</td>\n",
       "      <td>3076.223066</td>\n",
       "      <td>1033.310418</td>\n",
       "      <td>3758.043454</td>\n",
       "      <td>4000.805778</td>\n",
       "      <td>2756.802996</td>\n",
       "      <td>2918.768116</td>\n",
       "      <td>2613.934992</td>\n",
       "      <td>2655.684434</td>\n",
       "      <td>7410.337807</td>\n",
       "      <td>3182.903975</td>\n",
       "      <td>4324.103096</td>\n",
       "      <td>1843.506277</td>\n",
       "      <td>1338.453235</td>\n",
       "      <td>2693.772203</td>\n",
       "      <td>7239.094853</td>\n",
       "      <td>1320.715043</td>\n",
       "      <td>4449.372349</td>\n",
       "      <td>1085.884483</td>\n",
       "      <td>3556.231671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri2</th>\n",
       "      <td>3516.902396</td>\n",
       "      <td>4632.818016</td>\n",
       "      <td>4874.066155</td>\n",
       "      <td>3031.377402</td>\n",
       "      <td>2485.677228</td>\n",
       "      <td>4929.841314</td>\n",
       "      <td>435.950399</td>\n",
       "      <td>3059.241733</td>\n",
       "      <td>2923.325600</td>\n",
       "      <td>3530.389021</td>\n",
       "      <td>3002.555229</td>\n",
       "      <td>7537.781867</td>\n",
       "      <td>1989.249165</td>\n",
       "      <td>4513.510928</td>\n",
       "      <td>4473.733040</td>\n",
       "      <td>7422.364759</td>\n",
       "      <td>3338.164717</td>\n",
       "      <td>4840.676786</td>\n",
       "      <td>2721.343095</td>\n",
       "      <td>1972.689272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri3</th>\n",
       "      <td>333.881830</td>\n",
       "      <td>104.448476</td>\n",
       "      <td>2304.093856</td>\n",
       "      <td>586.098266</td>\n",
       "      <td>4575.178155</td>\n",
       "      <td>2365.682721</td>\n",
       "      <td>1285.101296</td>\n",
       "      <td>5050.566343</td>\n",
       "      <td>2446.870606</td>\n",
       "      <td>5096.855057</td>\n",
       "      <td>1047.603006</td>\n",
       "      <td>5431.187785</td>\n",
       "      <td>2879.554454</td>\n",
       "      <td>311.319060</td>\n",
       "      <td>2814.385809</td>\n",
       "      <td>3396.500194</td>\n",
       "      <td>1324.780081</td>\n",
       "      <td>1518.991979</td>\n",
       "      <td>1676.395223</td>\n",
       "      <td>2051.924695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri4</th>\n",
       "      <td>6790.330061</td>\n",
       "      <td>2629.751046</td>\n",
       "      <td>3148.222058</td>\n",
       "      <td>1894.867975</td>\n",
       "      <td>2274.057485</td>\n",
       "      <td>8186.457041</td>\n",
       "      <td>1195.253881</td>\n",
       "      <td>3747.385847</td>\n",
       "      <td>1456.694541</td>\n",
       "      <td>3437.159878</td>\n",
       "      <td>6745.578676</td>\n",
       "      <td>4101.871682</td>\n",
       "      <td>1944.773775</td>\n",
       "      <td>1571.942134</td>\n",
       "      <td>3186.806328</td>\n",
       "      <td>6588.562378</td>\n",
       "      <td>2866.277989</td>\n",
       "      <td>2079.880840</td>\n",
       "      <td>1086.063139</td>\n",
       "      <td>7051.740732</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Sub0         Sub1         Sub2         Sub3         Sub4  \\\n",
       "Tri0  2797.224240  1039.571212  4045.345952  3530.934210  2410.276348   \n",
       "Tri1   786.895089  3076.223066  1033.310418  3758.043454  4000.805778   \n",
       "Tri2  3516.902396  4632.818016  4874.066155  3031.377402  2485.677228   \n",
       "Tri3   333.881830   104.448476  2304.093856   586.098266  4575.178155   \n",
       "Tri4  6790.330061  2629.751046  3148.222058  1894.867975  2274.057485   \n",
       "\n",
       "             Sub5         Sub6         Sub7         Sub8         Sub9  \\\n",
       "Tri0  6541.494156  1977.919842  2343.555594   143.695964  8147.939691   \n",
       "Tri1  2756.802996  2918.768116  2613.934992  2655.684434  7410.337807   \n",
       "Tri2  4929.841314   435.950399  3059.241733  2923.325600  3530.389021   \n",
       "Tri3  2365.682721  1285.101296  5050.566343  2446.870606  5096.855057   \n",
       "Tri4  8186.457041  1195.253881  3747.385847  1456.694541  3437.159878   \n",
       "\n",
       "            Sub10        Sub11        Sub12        Sub13        Sub14  \\\n",
       "Tri0  5183.942423  4548.240971  2076.921296  4230.548795  4134.589984   \n",
       "Tri1  3182.903975  4324.103096  1843.506277  1338.453235  2693.772203   \n",
       "Tri2  3002.555229  7537.781867  1989.249165  4513.510928  4473.733040   \n",
       "Tri3  1047.603006  5431.187785  2879.554454   311.319060  2814.385809   \n",
       "Tri4  6745.578676  4101.871682  1944.773775  1571.942134  3186.806328   \n",
       "\n",
       "            Sub15        Sub16        Sub17        Sub18        Sub19  \n",
       "Tri0  2067.132295  4087.049471  2704.327437  2790.476384  5141.106292  \n",
       "Tri1  7239.094853  1320.715043  4449.372349  1085.884483  3556.231671  \n",
       "Tri2  7422.364759  3338.164717  4840.676786  2721.343095  1972.689272  \n",
       "Tri3  3396.500194  1324.780081  1518.991979  1676.395223  2051.924695  \n",
       "Tri4  6588.562378  2866.277989  2079.880840  1086.063139  7051.740732  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pandas import DataFrame, read_csv\n",
    "df = pd.read_csv('response_time_data.csv', index_col=0, header=0)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Now have a look at the data using built in Padas functionality\n",
    "* Check out the max/min of each row, standard deviation, percentiles, etc."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Sub0     3492.614323\n",
       "Sub1     2549.787915\n",
       "Sub2     2498.108943\n",
       "Sub3     3502.338174\n",
       "Sub4     2489.637962\n",
       "Sub5     4583.557298\n",
       "Sub6     2587.373753\n",
       "Sub7     3528.493482\n",
       "Sub8     1587.012676\n",
       "Sub9     4367.761563\n",
       "Sub10    3435.810762\n",
       "Sub11    4549.103034\n",
       "Sub12    2692.333031\n",
       "Sub13    2552.094429\n",
       "Sub14    4462.378792\n",
       "Sub15    4534.814089\n",
       "Sub16    2478.180462\n",
       "Sub17    2583.731375\n",
       "Sub18    2495.609643\n",
       "Sub19    4454.240975\n",
       "Name: mean, dtype: float64"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "desc = df.describe()\n",
    "#desc['Sub0'][1]\n",
    "desc.T['mean']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Are there missing values (NaNs) in the data?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Sub0      0\n",
       "Sub1      0\n",
       "Sub2      0\n",
       "Sub3      0\n",
       "Sub4      4\n",
       "Sub5      0\n",
       "Sub6      0\n",
       "Sub7      1\n",
       "Sub8      0\n",
       "Sub9      2\n",
       "Sub10     0\n",
       "Sub11    11\n",
       "Sub12     0\n",
       "Sub13     3\n",
       "Sub14     3\n",
       "Sub15     0\n",
       "Sub16     0\n",
       "Sub17    15\n",
       "Sub18     7\n",
       "Sub19     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.isna(df).sum(axis=0)\n",
    "#np.sum(pd.isna(df))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## What about outliers? Lets define outliers here as > 2 * std away from the mean for each subject\n",
    "* After you've found the outliers for each subject, replace those values with a np.nan (NaN)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Yaqian\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:5: RuntimeWarning: invalid value encountered in greater\n",
      "  \"\"\"\n"
     ]
    }
   ],
   "source": [
    "df_nan = df.copy()\n",
    "for i in df_nan.keys():\n",
    "    this_data = df_nan[i].values\n",
    "    max_value = np.mean(this_data) + 2*np.std(this_data)\n",
    "    outliers = this_data>max_value\n",
    "    df_nan[i][outliers] = np.nan\n",
    "    \n",
    "#     if df[i].values > desc.T['mean'] + 2*desc.T['std']\n",
    "#         df[i].values = np.nan\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Sub0</th>\n",
       "      <th>Sub1</th>\n",
       "      <th>Sub2</th>\n",
       "      <th>Sub3</th>\n",
       "      <th>Sub4</th>\n",
       "      <th>Sub5</th>\n",
       "      <th>Sub6</th>\n",
       "      <th>Sub7</th>\n",
       "      <th>Sub8</th>\n",
       "      <th>Sub9</th>\n",
       "      <th>Sub10</th>\n",
       "      <th>Sub11</th>\n",
       "      <th>Sub12</th>\n",
       "      <th>Sub13</th>\n",
       "      <th>Sub14</th>\n",
       "      <th>Sub15</th>\n",
       "      <th>Sub16</th>\n",
       "      <th>Sub17</th>\n",
       "      <th>Sub18</th>\n",
       "      <th>Sub19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Tri0</th>\n",
       "      <td>2797.224240</td>\n",
       "      <td>1039.571212</td>\n",
       "      <td>4045.345952</td>\n",
       "      <td>3530.934210</td>\n",
       "      <td>2410.276348</td>\n",
       "      <td>6541.494156</td>\n",
       "      <td>1977.919842</td>\n",
       "      <td>2343.555594</td>\n",
       "      <td>143.695964</td>\n",
       "      <td>8147.939691</td>\n",
       "      <td>5183.942423</td>\n",
       "      <td>4548.240971</td>\n",
       "      <td>2076.921296</td>\n",
       "      <td>4230.548795</td>\n",
       "      <td>4134.589984</td>\n",
       "      <td>2067.132295</td>\n",
       "      <td>4087.049471</td>\n",
       "      <td>2704.327437</td>\n",
       "      <td>2790.476384</td>\n",
       "      <td>5141.106292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri1</th>\n",
       "      <td>786.895089</td>\n",
       "      <td>3076.223066</td>\n",
       "      <td>1033.310418</td>\n",
       "      <td>3758.043454</td>\n",
       "      <td>4000.805778</td>\n",
       "      <td>2756.802996</td>\n",
       "      <td>2918.768116</td>\n",
       "      <td>2613.934992</td>\n",
       "      <td>2655.684434</td>\n",
       "      <td>7410.337807</td>\n",
       "      <td>3182.903975</td>\n",
       "      <td>4324.103096</td>\n",
       "      <td>1843.506277</td>\n",
       "      <td>1338.453235</td>\n",
       "      <td>2693.772203</td>\n",
       "      <td>7239.094853</td>\n",
       "      <td>1320.715043</td>\n",
       "      <td>4449.372349</td>\n",
       "      <td>1085.884483</td>\n",
       "      <td>3556.231671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri2</th>\n",
       "      <td>3516.902396</td>\n",
       "      <td>4632.818016</td>\n",
       "      <td>4874.066155</td>\n",
       "      <td>3031.377402</td>\n",
       "      <td>2485.677228</td>\n",
       "      <td>4929.841314</td>\n",
       "      <td>435.950399</td>\n",
       "      <td>3059.241733</td>\n",
       "      <td>2923.325600</td>\n",
       "      <td>3530.389021</td>\n",
       "      <td>3002.555229</td>\n",
       "      <td>7537.781867</td>\n",
       "      <td>1989.249165</td>\n",
       "      <td>4513.510928</td>\n",
       "      <td>4473.733040</td>\n",
       "      <td>7422.364759</td>\n",
       "      <td>3338.164717</td>\n",
       "      <td>4840.676786</td>\n",
       "      <td>2721.343095</td>\n",
       "      <td>1972.689272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri3</th>\n",
       "      <td>333.881830</td>\n",
       "      <td>104.448476</td>\n",
       "      <td>2304.093856</td>\n",
       "      <td>586.098266</td>\n",
       "      <td>4575.178155</td>\n",
       "      <td>2365.682721</td>\n",
       "      <td>1285.101296</td>\n",
       "      <td>5050.566343</td>\n",
       "      <td>2446.870606</td>\n",
       "      <td>5096.855057</td>\n",
       "      <td>1047.603006</td>\n",
       "      <td>5431.187785</td>\n",
       "      <td>2879.554454</td>\n",
       "      <td>311.319060</td>\n",
       "      <td>2814.385809</td>\n",
       "      <td>3396.500194</td>\n",
       "      <td>1324.780081</td>\n",
       "      <td>1518.991979</td>\n",
       "      <td>1676.395223</td>\n",
       "      <td>2051.924695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri4</th>\n",
       "      <td>6790.330061</td>\n",
       "      <td>2629.751046</td>\n",
       "      <td>3148.222058</td>\n",
       "      <td>1894.867975</td>\n",
       "      <td>2274.057485</td>\n",
       "      <td>8186.457041</td>\n",
       "      <td>1195.253881</td>\n",
       "      <td>3747.385847</td>\n",
       "      <td>1456.694541</td>\n",
       "      <td>3437.159878</td>\n",
       "      <td>6745.578676</td>\n",
       "      <td>4101.871682</td>\n",
       "      <td>1944.773775</td>\n",
       "      <td>1571.942134</td>\n",
       "      <td>3186.806328</td>\n",
       "      <td>6588.562378</td>\n",
       "      <td>2866.277989</td>\n",
       "      <td>2079.880840</td>\n",
       "      <td>1086.063139</td>\n",
       "      <td>7051.740732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri5</th>\n",
       "      <td>3047.828258</td>\n",
       "      <td>397.038302</td>\n",
       "      <td>114.215641</td>\n",
       "      <td>4089.899601</td>\n",
       "      <td>4049.434462</td>\n",
       "      <td>4025.464731</td>\n",
       "      <td>2638.680380</td>\n",
       "      <td>1885.518602</td>\n",
       "      <td>307.874145</td>\n",
       "      <td>1883.111558</td>\n",
       "      <td>4216.585496</td>\n",
       "      <td>3179.854036</td>\n",
       "      <td>2370.740080</td>\n",
       "      <td>1178.494818</td>\n",
       "      <td>2048.812602</td>\n",
       "      <td>5268.016210</td>\n",
       "      <td>3215.274112</td>\n",
       "      <td>1073.497581</td>\n",
       "      <td>68.184823</td>\n",
       "      <td>4022.043321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri6</th>\n",
       "      <td>2176.597045</td>\n",
       "      <td>3552.355757</td>\n",
       "      <td>1973.393087</td>\n",
       "      <td>4362.043226</td>\n",
       "      <td>5170.251441</td>\n",
       "      <td>6009.945843</td>\n",
       "      <td>724.758133</td>\n",
       "      <td>3600.654491</td>\n",
       "      <td>501.585571</td>\n",
       "      <td>3658.042950</td>\n",
       "      <td>1796.353749</td>\n",
       "      <td>2115.447625</td>\n",
       "      <td>2434.767571</td>\n",
       "      <td>2890.637333</td>\n",
       "      <td>1354.310794</td>\n",
       "      <td>2957.510350</td>\n",
       "      <td>1447.567916</td>\n",
       "      <td>2020.893616</td>\n",
       "      <td>3598.657711</td>\n",
       "      <td>1439.384910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri7</th>\n",
       "      <td>2733.437098</td>\n",
       "      <td>3250.115237</td>\n",
       "      <td>1378.417119</td>\n",
       "      <td>5991.874045</td>\n",
       "      <td>143.606176</td>\n",
       "      <td>6485.648064</td>\n",
       "      <td>543.664039</td>\n",
       "      <td>2136.843938</td>\n",
       "      <td>1224.511880</td>\n",
       "      <td>6117.384527</td>\n",
       "      <td>2269.914529</td>\n",
       "      <td>5853.215276</td>\n",
       "      <td>1970.536378</td>\n",
       "      <td>2433.792597</td>\n",
       "      <td>2363.395834</td>\n",
       "      <td>1330.207606</td>\n",
       "      <td>1299.794499</td>\n",
       "      <td>3009.042214</td>\n",
       "      <td>256.578248</td>\n",
       "      <td>2584.729650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri8</th>\n",
       "      <td>3290.277151</td>\n",
       "      <td>2180.419440</td>\n",
       "      <td>1069.322671</td>\n",
       "      <td>5277.547086</td>\n",
       "      <td>2287.661406</td>\n",
       "      <td>5077.853063</td>\n",
       "      <td>2893.314803</td>\n",
       "      <td>4536.102482</td>\n",
       "      <td>2106.468811</td>\n",
       "      <td>1775.207528</td>\n",
       "      <td>3120.339818</td>\n",
       "      <td>2296.467312</td>\n",
       "      <td>3544.422187</td>\n",
       "      <td>4943.839493</td>\n",
       "      <td>2156.873736</td>\n",
       "      <td>4923.989022</td>\n",
       "      <td>1152.021083</td>\n",
       "      <td>2550.905619</td>\n",
       "      <td>1914.428198</td>\n",
       "      <td>3390.908581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri9</th>\n",
       "      <td>1881.581897</td>\n",
       "      <td>1168.334372</td>\n",
       "      <td>2808.512816</td>\n",
       "      <td>2198.630268</td>\n",
       "      <td>1688.488219</td>\n",
       "      <td>2049.245976</td>\n",
       "      <td>1336.294530</td>\n",
       "      <td>4475.980197</td>\n",
       "      <td>341.613792</td>\n",
       "      <td>1397.717855</td>\n",
       "      <td>5802.017010</td>\n",
       "      <td>1227.185074</td>\n",
       "      <td>2183.988202</td>\n",
       "      <td>266.188603</td>\n",
       "      <td>5280.917742</td>\n",
       "      <td>4852.981861</td>\n",
       "      <td>2825.540327</td>\n",
       "      <td>2645.230368</td>\n",
       "      <td>233.150604</td>\n",
       "      <td>4912.713861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri10</th>\n",
       "      <td>3646.313933</td>\n",
       "      <td>1625.659863</td>\n",
       "      <td>3206.440179</td>\n",
       "      <td>1194.569715</td>\n",
       "      <td>1939.383734</td>\n",
       "      <td>1879.157591</td>\n",
       "      <td>4970.830739</td>\n",
       "      <td>4134.752286</td>\n",
       "      <td>1298.460972</td>\n",
       "      <td>1956.628409</td>\n",
       "      <td>2732.487735</td>\n",
       "      <td>9493.147896</td>\n",
       "      <td>2475.476740</td>\n",
       "      <td>738.715809</td>\n",
       "      <td>2294.571907</td>\n",
       "      <td>1304.651870</td>\n",
       "      <td>3412.442107</td>\n",
       "      <td>2469.096865</td>\n",
       "      <td>2715.130258</td>\n",
       "      <td>4059.136955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri11</th>\n",
       "      <td>3931.516192</td>\n",
       "      <td>192.566645</td>\n",
       "      <td>1403.470198</td>\n",
       "      <td>3397.295729</td>\n",
       "      <td>4681.754010</td>\n",
       "      <td>6591.613394</td>\n",
       "      <td>2980.007209</td>\n",
       "      <td>2485.156212</td>\n",
       "      <td>522.050951</td>\n",
       "      <td>4378.778873</td>\n",
       "      <td>3018.287764</td>\n",
       "      <td>2650.184176</td>\n",
       "      <td>14.216346</td>\n",
       "      <td>3716.312716</td>\n",
       "      <td>6855.044510</td>\n",
       "      <td>1247.417970</td>\n",
       "      <td>1424.223869</td>\n",
       "      <td>3058.837397</td>\n",
       "      <td>4825.153445</td>\n",
       "      <td>1377.779459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri12</th>\n",
       "      <td>4308.815582</td>\n",
       "      <td>1591.300260</td>\n",
       "      <td>1969.829569</td>\n",
       "      <td>4046.082575</td>\n",
       "      <td>2555.540064</td>\n",
       "      <td>5113.426538</td>\n",
       "      <td>2593.246610</td>\n",
       "      <td>4443.971194</td>\n",
       "      <td>2563.882354</td>\n",
       "      <td>5391.326624</td>\n",
       "      <td>292.409469</td>\n",
       "      <td>4356.282690</td>\n",
       "      <td>579.064560</td>\n",
       "      <td>3869.193105</td>\n",
       "      <td>4032.326761</td>\n",
       "      <td>3886.207190</td>\n",
       "      <td>37.948280</td>\n",
       "      <td>2477.456413</td>\n",
       "      <td>7079.723259</td>\n",
       "      <td>2880.058505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri13</th>\n",
       "      <td>2004.232508</td>\n",
       "      <td>1972.600035</td>\n",
       "      <td>2536.188940</td>\n",
       "      <td>1908.891889</td>\n",
       "      <td>4091.166301</td>\n",
       "      <td>1679.608773</td>\n",
       "      <td>1536.272703</td>\n",
       "      <td>4023.633503</td>\n",
       "      <td>1786.137313</td>\n",
       "      <td>3038.511977</td>\n",
       "      <td>3821.388413</td>\n",
       "      <td>3700.112011</td>\n",
       "      <td>2047.432799</td>\n",
       "      <td>3722.822930</td>\n",
       "      <td>3277.862188</td>\n",
       "      <td>3697.007382</td>\n",
       "      <td>4759.422285</td>\n",
       "      <td>1278.100407</td>\n",
       "      <td>1124.765465</td>\n",
       "      <td>6248.230659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri14</th>\n",
       "      <td>6017.817486</td>\n",
       "      <td>644.955912</td>\n",
       "      <td>1987.820582</td>\n",
       "      <td>2354.542490</td>\n",
       "      <td>1388.969163</td>\n",
       "      <td>2372.667094</td>\n",
       "      <td>479.298797</td>\n",
       "      <td>1233.238617</td>\n",
       "      <td>3057.372752</td>\n",
       "      <td>3146.273531</td>\n",
       "      <td>2439.637217</td>\n",
       "      <td>5154.616079</td>\n",
       "      <td>3210.443053</td>\n",
       "      <td>2303.223106</td>\n",
       "      <td>8024.009754</td>\n",
       "      <td>1431.502336</td>\n",
       "      <td>2805.812304</td>\n",
       "      <td>209.452649</td>\n",
       "      <td>29.286915</td>\n",
       "      <td>5605.288288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri15</th>\n",
       "      <td>2601.305283</td>\n",
       "      <td>3594.655184</td>\n",
       "      <td>2371.459375</td>\n",
       "      <td>3938.344443</td>\n",
       "      <td>2853.166655</td>\n",
       "      <td>4711.309827</td>\n",
       "      <td>3898.284833</td>\n",
       "      <td>3572.704270</td>\n",
       "      <td>1310.699188</td>\n",
       "      <td>4263.843023</td>\n",
       "      <td>1057.886020</td>\n",
       "      <td>2406.319185</td>\n",
       "      <td>2624.236741</td>\n",
       "      <td>4550.713883</td>\n",
       "      <td>3741.835217</td>\n",
       "      <td>1844.605678</td>\n",
       "      <td>1575.856715</td>\n",
       "      <td>1632.182450</td>\n",
       "      <td>1717.001177</td>\n",
       "      <td>4712.964280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri16</th>\n",
       "      <td>3999.043797</td>\n",
       "      <td>2071.515703</td>\n",
       "      <td>3385.070117</td>\n",
       "      <td>3601.361161</td>\n",
       "      <td>6218.904091</td>\n",
       "      <td>4637.388191</td>\n",
       "      <td>3305.677185</td>\n",
       "      <td>4283.664183</td>\n",
       "      <td>692.242028</td>\n",
       "      <td>2030.449406</td>\n",
       "      <td>3598.057871</td>\n",
       "      <td>1374.546938</td>\n",
       "      <td>1480.611011</td>\n",
       "      <td>3241.384679</td>\n",
       "      <td>6352.487413</td>\n",
       "      <td>4769.807630</td>\n",
       "      <td>345.901126</td>\n",
       "      <td>4162.285050</td>\n",
       "      <td>3181.815704</td>\n",
       "      <td>1458.025873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri17</th>\n",
       "      <td>1372.419652</td>\n",
       "      <td>1848.213972</td>\n",
       "      <td>4248.673137</td>\n",
       "      <td>3914.271056</td>\n",
       "      <td>3890.512470</td>\n",
       "      <td>3076.043021</td>\n",
       "      <td>1293.978527</td>\n",
       "      <td>6441.018287</td>\n",
       "      <td>1816.063502</td>\n",
       "      <td>2344.698770</td>\n",
       "      <td>1640.920209</td>\n",
       "      <td>5323.168630</td>\n",
       "      <td>3648.912380</td>\n",
       "      <td>2760.721103</td>\n",
       "      <td>7033.016570</td>\n",
       "      <td>5071.046489</td>\n",
       "      <td>2946.679451</td>\n",
       "      <td>293.872467</td>\n",
       "      <td>2713.797467</td>\n",
       "      <td>2096.062075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri18</th>\n",
       "      <td>3650.763986</td>\n",
       "      <td>2293.542947</td>\n",
       "      <td>2728.329610</td>\n",
       "      <td>2176.302848</td>\n",
       "      <td>3461.945292</td>\n",
       "      <td>6076.972257</td>\n",
       "      <td>2195.460676</td>\n",
       "      <td>5416.264595</td>\n",
       "      <td>1369.246142</td>\n",
       "      <td>5103.076196</td>\n",
       "      <td>2892.060496</td>\n",
       "      <td>3892.435508</td>\n",
       "      <td>1295.714144</td>\n",
       "      <td>20.223690</td>\n",
       "      <td>3690.530028</td>\n",
       "      <td>1439.286201</td>\n",
       "      <td>3331.125830</td>\n",
       "      <td>1405.362358</td>\n",
       "      <td>674.766149</td>\n",
       "      <td>2690.896212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri19</th>\n",
       "      <td>4590.144644</td>\n",
       "      <td>2738.871921</td>\n",
       "      <td>271.504916</td>\n",
       "      <td>438.603787</td>\n",
       "      <td>1240.028763</td>\n",
       "      <td>3096.072433</td>\n",
       "      <td>2370.345165</td>\n",
       "      <td>4593.902987</td>\n",
       "      <td>3272.597687</td>\n",
       "      <td>4735.979486</td>\n",
       "      <td>5122.880850</td>\n",
       "      <td>5917.462942</td>\n",
       "      <td>4162.275122</td>\n",
       "      <td>1684.470084</td>\n",
       "      <td>6845.328218</td>\n",
       "      <td>6875.100886</td>\n",
       "      <td>4941.876044</td>\n",
       "      <td>194.371185</td>\n",
       "      <td>1230.682272</td>\n",
       "      <td>2914.678469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri20</th>\n",
       "      <td>1789.110026</td>\n",
       "      <td>2564.281719</td>\n",
       "      <td>2561.038387</td>\n",
       "      <td>3934.218428</td>\n",
       "      <td>1274.958220</td>\n",
       "      <td>4041.204419</td>\n",
       "      <td>2452.776553</td>\n",
       "      <td>2294.776565</td>\n",
       "      <td>1931.331379</td>\n",
       "      <td>7175.587179</td>\n",
       "      <td>3183.754138</td>\n",
       "      <td>3513.924554</td>\n",
       "      <td>905.013956</td>\n",
       "      <td>354.741832</td>\n",
       "      <td>3134.348455</td>\n",
       "      <td>5414.503988</td>\n",
       "      <td>1859.883386</td>\n",
       "      <td>1044.368043</td>\n",
       "      <td>2518.770276</td>\n",
       "      <td>3580.021139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri21</th>\n",
       "      <td>2350.865209</td>\n",
       "      <td>3983.865823</td>\n",
       "      <td>1377.567893</td>\n",
       "      <td>3411.263401</td>\n",
       "      <td>1309.887676</td>\n",
       "      <td>769.143341</td>\n",
       "      <td>2826.814718</td>\n",
       "      <td>7018.641416</td>\n",
       "      <td>1765.476153</td>\n",
       "      <td>3308.479365</td>\n",
       "      <td>6039.588712</td>\n",
       "      <td>5881.403433</td>\n",
       "      <td>1107.831738</td>\n",
       "      <td>2119.146723</td>\n",
       "      <td>8965.077468</td>\n",
       "      <td>3400.401330</td>\n",
       "      <td>1074.646940</td>\n",
       "      <td>1467.227139</td>\n",
       "      <td>385.817210</td>\n",
       "      <td>4313.807516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri22</th>\n",
       "      <td>6952.390799</td>\n",
       "      <td>2063.316230</td>\n",
       "      <td>1535.851635</td>\n",
       "      <td>2888.308373</td>\n",
       "      <td>1344.817132</td>\n",
       "      <td>5570.172691</td>\n",
       "      <td>3200.852884</td>\n",
       "      <td>5913.022804</td>\n",
       "      <td>427.591714</td>\n",
       "      <td>3944.805607</td>\n",
       "      <td>2765.051691</td>\n",
       "      <td>4495.600498</td>\n",
       "      <td>3512.207504</td>\n",
       "      <td>105.080751</td>\n",
       "      <td>5065.155604</td>\n",
       "      <td>2852.460376</td>\n",
       "      <td>4284.974905</td>\n",
       "      <td>2193.340876</td>\n",
       "      <td>3922.917090</td>\n",
       "      <td>6555.267030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri23</th>\n",
       "      <td>3981.190750</td>\n",
       "      <td>3247.512882</td>\n",
       "      <td>3721.031070</td>\n",
       "      <td>2099.836777</td>\n",
       "      <td>1379.746589</td>\n",
       "      <td>6456.138963</td>\n",
       "      <td>2025.538783</td>\n",
       "      <td>2661.638491</td>\n",
       "      <td>1088.332466</td>\n",
       "      <td>6264.921509</td>\n",
       "      <td>2461.335394</td>\n",
       "      <td>6783.466281</td>\n",
       "      <td>3711.174364</td>\n",
       "      <td>1367.747318</td>\n",
       "      <td>2005.241990</td>\n",
       "      <td>3895.996977</td>\n",
       "      <td>2927.525147</td>\n",
       "      <td>567.936693</td>\n",
       "      <td>1042.124277</td>\n",
       "      <td>3309.478267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri24</th>\n",
       "      <td>1018.919604</td>\n",
       "      <td>2192.488372</td>\n",
       "      <td>2749.424948</td>\n",
       "      <td>2821.333287</td>\n",
       "      <td>1414.676045</td>\n",
       "      <td>4442.560508</td>\n",
       "      <td>3913.692260</td>\n",
       "      <td>5384.410278</td>\n",
       "      <td>32.019499</td>\n",
       "      <td>4496.280231</td>\n",
       "      <td>1248.691549</td>\n",
       "      <td>10061.049263</td>\n",
       "      <td>1844.528675</td>\n",
       "      <td>70.768552</td>\n",
       "      <td>2701.317234</td>\n",
       "      <td>1849.193271</td>\n",
       "      <td>1006.852834</td>\n",
       "      <td>2177.662910</td>\n",
       "      <td>2369.823241</td>\n",
       "      <td>5870.730322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri25</th>\n",
       "      <td>2315.087241</td>\n",
       "      <td>2201.058303</td>\n",
       "      <td>719.014381</td>\n",
       "      <td>737.305297</td>\n",
       "      <td>4660.901242</td>\n",
       "      <td>3314.228722</td>\n",
       "      <td>1319.019511</td>\n",
       "      <td>2356.782408</td>\n",
       "      <td>1474.041409</td>\n",
       "      <td>1173.689771</td>\n",
       "      <td>6404.474740</td>\n",
       "      <td>2472.570804</td>\n",
       "      <td>4559.196652</td>\n",
       "      <td>3857.026459</td>\n",
       "      <td>259.467407</td>\n",
       "      <td>3718.624366</td>\n",
       "      <td>2832.405129</td>\n",
       "      <td>3471.125966</td>\n",
       "      <td>641.862063</td>\n",
       "      <td>6200.306855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri26</th>\n",
       "      <td>3425.943052</td>\n",
       "      <td>2960.328053</td>\n",
       "      <td>2058.422909</td>\n",
       "      <td>2792.324988</td>\n",
       "      <td>2366.328681</td>\n",
       "      <td>5725.728257</td>\n",
       "      <td>1011.737895</td>\n",
       "      <td>2399.555806</td>\n",
       "      <td>2611.716052</td>\n",
       "      <td>5671.847403</td>\n",
       "      <td>4001.436040</td>\n",
       "      <td>4696.457379</td>\n",
       "      <td>1134.304194</td>\n",
       "      <td>1819.079808</td>\n",
       "      <td>6214.829225</td>\n",
       "      <td>6221.959882</td>\n",
       "      <td>587.611647</td>\n",
       "      <td>1666.117688</td>\n",
       "      <td>2720.337090</td>\n",
       "      <td>4027.341897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri27</th>\n",
       "      <td>3343.105868</td>\n",
       "      <td>3245.563710</td>\n",
       "      <td>4974.583632</td>\n",
       "      <td>23.429444</td>\n",
       "      <td>4954.807144</td>\n",
       "      <td>2755.752430</td>\n",
       "      <td>1775.584328</td>\n",
       "      <td>5829.767282</td>\n",
       "      <td>2597.394722</td>\n",
       "      <td>6390.433703</td>\n",
       "      <td>2748.032360</td>\n",
       "      <td>6592.437245</td>\n",
       "      <td>2420.918590</td>\n",
       "      <td>2744.339671</td>\n",
       "      <td>5943.495369</td>\n",
       "      <td>7500.719769</td>\n",
       "      <td>2714.634138</td>\n",
       "      <td>7112.070673</td>\n",
       "      <td>5129.402693</td>\n",
       "      <td>4819.212577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri28</th>\n",
       "      <td>2170.474769</td>\n",
       "      <td>3573.187792</td>\n",
       "      <td>3065.872135</td>\n",
       "      <td>4277.443964</td>\n",
       "      <td>1570.902741</td>\n",
       "      <td>5864.062179</td>\n",
       "      <td>1338.712402</td>\n",
       "      <td>2062.441171</td>\n",
       "      <td>1444.139181</td>\n",
       "      <td>4584.654047</td>\n",
       "      <td>4684.956953</td>\n",
       "      <td>5955.686112</td>\n",
       "      <td>3997.029107</td>\n",
       "      <td>765.461186</td>\n",
       "      <td>5388.946834</td>\n",
       "      <td>4428.598436</td>\n",
       "      <td>1248.906561</td>\n",
       "      <td>1018.562576</td>\n",
       "      <td>3137.521116</td>\n",
       "      <td>6439.059402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri29</th>\n",
       "      <td>3201.988624</td>\n",
       "      <td>878.496721</td>\n",
       "      <td>1157.160637</td>\n",
       "      <td>6449.023514</td>\n",
       "      <td>2686.624157</td>\n",
       "      <td>4180.357765</td>\n",
       "      <td>213.195206</td>\n",
       "      <td>3046.308331</td>\n",
       "      <td>2865.075881</td>\n",
       "      <td>2478.623834</td>\n",
       "      <td>5169.539096</td>\n",
       "      <td>4025.666201</td>\n",
       "      <td>2542.109754</td>\n",
       "      <td>4541.154907</td>\n",
       "      <td>2248.276335</td>\n",
       "      <td>1793.347533</td>\n",
       "      <td>2628.103511</td>\n",
       "      <td>2009.567507</td>\n",
       "      <td>2917.641000</td>\n",
       "      <td>4727.321301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri770</th>\n",
       "      <td>5019.916501</td>\n",
       "      <td>4064.509064</td>\n",
       "      <td>1367.441537</td>\n",
       "      <td>4041.683022</td>\n",
       "      <td>338.933307</td>\n",
       "      <td>5673.397942</td>\n",
       "      <td>201.555076</td>\n",
       "      <td>951.357610</td>\n",
       "      <td>1083.986038</td>\n",
       "      <td>5877.593687</td>\n",
       "      <td>3119.652408</td>\n",
       "      <td>2362.919913</td>\n",
       "      <td>6689.664963</td>\n",
       "      <td>2072.202080</td>\n",
       "      <td>2514.064633</td>\n",
       "      <td>5782.253033</td>\n",
       "      <td>4552.410543</td>\n",
       "      <td>599.925866</td>\n",
       "      <td>6530.951552</td>\n",
       "      <td>4476.679376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri771</th>\n",
       "      <td>1067.207049</td>\n",
       "      <td>1824.416712</td>\n",
       "      <td>4162.917234</td>\n",
       "      <td>4704.614259</td>\n",
       "      <td>2765.201984</td>\n",
       "      <td>6165.689173</td>\n",
       "      <td>3685.599231</td>\n",
       "      <td>989.469420</td>\n",
       "      <td>968.723980</td>\n",
       "      <td>4575.109982</td>\n",
       "      <td>1695.815829</td>\n",
       "      <td>3260.280990</td>\n",
       "      <td>3127.255327</td>\n",
       "      <td>3225.607562</td>\n",
       "      <td>7179.086423</td>\n",
       "      <td>3611.052917</td>\n",
       "      <td>1488.165287</td>\n",
       "      <td>1476.624888</td>\n",
       "      <td>2159.477844</td>\n",
       "      <td>4498.994106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri772</th>\n",
       "      <td>3397.691127</td>\n",
       "      <td>4499.183734</td>\n",
       "      <td>4694.741869</td>\n",
       "      <td>3151.216275</td>\n",
       "      <td>4963.785263</td>\n",
       "      <td>1619.179021</td>\n",
       "      <td>3265.231143</td>\n",
       "      <td>1790.337031</td>\n",
       "      <td>2243.599203</td>\n",
       "      <td>2481.871935</td>\n",
       "      <td>271.979249</td>\n",
       "      <td>4683.880827</td>\n",
       "      <td>1833.226420</td>\n",
       "      <td>1614.501208</td>\n",
       "      <td>3468.347864</td>\n",
       "      <td>5678.026196</td>\n",
       "      <td>1874.198809</td>\n",
       "      <td>253.650458</td>\n",
       "      <td>2037.577829</td>\n",
       "      <td>1747.981551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri773</th>\n",
       "      <td>4656.609071</td>\n",
       "      <td>3744.545650</td>\n",
       "      <td>2766.966958</td>\n",
       "      <td>3974.311001</td>\n",
       "      <td>3162.852076</td>\n",
       "      <td>8407.932097</td>\n",
       "      <td>1884.669293</td>\n",
       "      <td>2578.515791</td>\n",
       "      <td>1468.488071</td>\n",
       "      <td>3813.408616</td>\n",
       "      <td>4232.841624</td>\n",
       "      <td>4911.570825</td>\n",
       "      <td>1306.936657</td>\n",
       "      <td>788.957415</td>\n",
       "      <td>5232.178707</td>\n",
       "      <td>7744.999475</td>\n",
       "      <td>2431.965152</td>\n",
       "      <td>1124.090837</td>\n",
       "      <td>4099.034461</td>\n",
       "      <td>1799.347268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri774</th>\n",
       "      <td>2418.176006</td>\n",
       "      <td>1269.214989</td>\n",
       "      <td>429.276661</td>\n",
       "      <td>4838.812325</td>\n",
       "      <td>2270.762832</td>\n",
       "      <td>4255.242571</td>\n",
       "      <td>504.107442</td>\n",
       "      <td>1331.564119</td>\n",
       "      <td>234.181038</td>\n",
       "      <td>6640.959184</td>\n",
       "      <td>3613.393158</td>\n",
       "      <td>3765.241232</td>\n",
       "      <td>1785.795915</td>\n",
       "      <td>4049.183809</td>\n",
       "      <td>2139.079636</td>\n",
       "      <td>4870.585618</td>\n",
       "      <td>2632.308370</td>\n",
       "      <td>3795.825698</td>\n",
       "      <td>2065.665001</td>\n",
       "      <td>3533.836049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri775</th>\n",
       "      <td>4193.896082</td>\n",
       "      <td>717.222895</td>\n",
       "      <td>4798.294129</td>\n",
       "      <td>3759.457306</td>\n",
       "      <td>478.139010</td>\n",
       "      <td>6411.768042</td>\n",
       "      <td>4490.491911</td>\n",
       "      <td>2009.480471</td>\n",
       "      <td>1942.847743</td>\n",
       "      <td>6595.750322</td>\n",
       "      <td>2993.944692</td>\n",
       "      <td>9133.851062</td>\n",
       "      <td>1543.894241</td>\n",
       "      <td>2566.416763</td>\n",
       "      <td>2707.591795</td>\n",
       "      <td>6623.910297</td>\n",
       "      <td>2296.817615</td>\n",
       "      <td>2326.063114</td>\n",
       "      <td>2347.697164</td>\n",
       "      <td>6363.048613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri776</th>\n",
       "      <td>3867.848234</td>\n",
       "      <td>1067.792534</td>\n",
       "      <td>1234.102840</td>\n",
       "      <td>654.158484</td>\n",
       "      <td>3203.563016</td>\n",
       "      <td>3217.279066</td>\n",
       "      <td>2788.954247</td>\n",
       "      <td>3148.277638</td>\n",
       "      <td>518.757154</td>\n",
       "      <td>2951.581858</td>\n",
       "      <td>4466.085911</td>\n",
       "      <td>3913.510325</td>\n",
       "      <td>1199.334758</td>\n",
       "      <td>1727.319198</td>\n",
       "      <td>4205.028277</td>\n",
       "      <td>1562.338556</td>\n",
       "      <td>1253.087894</td>\n",
       "      <td>410.695565</td>\n",
       "      <td>3501.688532</td>\n",
       "      <td>2.748561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri777</th>\n",
       "      <td>98.144376</td>\n",
       "      <td>2967.010519</td>\n",
       "      <td>2830.656654</td>\n",
       "      <td>2309.465464</td>\n",
       "      <td>2162.254722</td>\n",
       "      <td>8827.325748</td>\n",
       "      <td>2478.898257</td>\n",
       "      <td>2860.291126</td>\n",
       "      <td>1468.474202</td>\n",
       "      <td>5147.091903</td>\n",
       "      <td>4142.964627</td>\n",
       "      <td>3251.302244</td>\n",
       "      <td>1583.446266</td>\n",
       "      <td>1697.757692</td>\n",
       "      <td>4261.867278</td>\n",
       "      <td>2202.733356</td>\n",
       "      <td>1664.096491</td>\n",
       "      <td>2378.824201</td>\n",
       "      <td>4098.729006</td>\n",
       "      <td>5782.275558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri778</th>\n",
       "      <td>3297.471584</td>\n",
       "      <td>951.434209</td>\n",
       "      <td>2841.784763</td>\n",
       "      <td>478.314962</td>\n",
       "      <td>3524.684787</td>\n",
       "      <td>6830.768774</td>\n",
       "      <td>620.907696</td>\n",
       "      <td>1336.452789</td>\n",
       "      <td>806.585847</td>\n",
       "      <td>3646.037162</td>\n",
       "      <td>3950.351432</td>\n",
       "      <td>3485.024897</td>\n",
       "      <td>2994.188239</td>\n",
       "      <td>1890.126270</td>\n",
       "      <td>4927.337239</td>\n",
       "      <td>5385.048180</td>\n",
       "      <td>2319.536252</td>\n",
       "      <td>1521.943637</td>\n",
       "      <td>1293.826140</td>\n",
       "      <td>2437.975909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri779</th>\n",
       "      <td>2766.458882</td>\n",
       "      <td>169.207955</td>\n",
       "      <td>254.220834</td>\n",
       "      <td>2357.865661</td>\n",
       "      <td>2070.051795</td>\n",
       "      <td>8638.329319</td>\n",
       "      <td>921.568698</td>\n",
       "      <td>6357.642769</td>\n",
       "      <td>258.042764</td>\n",
       "      <td>2535.568721</td>\n",
       "      <td>2768.048500</td>\n",
       "      <td>4750.922044</td>\n",
       "      <td>1521.796345</td>\n",
       "      <td>4805.708894</td>\n",
       "      <td>2475.995081</td>\n",
       "      <td>4010.560573</td>\n",
       "      <td>2442.238703</td>\n",
       "      <td>6155.067426</td>\n",
       "      <td>309.268802</td>\n",
       "      <td>2002.542468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri780</th>\n",
       "      <td>2466.329475</td>\n",
       "      <td>4521.403690</td>\n",
       "      <td>2209.031340</td>\n",
       "      <td>1168.414376</td>\n",
       "      <td>1646.438184</td>\n",
       "      <td>4518.513887</td>\n",
       "      <td>1539.082013</td>\n",
       "      <td>2457.480226</td>\n",
       "      <td>1854.247566</td>\n",
       "      <td>4798.221013</td>\n",
       "      <td>5150.004163</td>\n",
       "      <td>4877.891921</td>\n",
       "      <td>2463.586500</td>\n",
       "      <td>4265.530199</td>\n",
       "      <td>9967.211069</td>\n",
       "      <td>5937.764403</td>\n",
       "      <td>3818.379737</td>\n",
       "      <td>4254.809643</td>\n",
       "      <td>1406.563422</td>\n",
       "      <td>1567.109027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri781</th>\n",
       "      <td>2166.200067</td>\n",
       "      <td>2618.547401</td>\n",
       "      <td>1943.968624</td>\n",
       "      <td>3723.972678</td>\n",
       "      <td>5701.735032</td>\n",
       "      <td>4603.053869</td>\n",
       "      <td>3837.779144</td>\n",
       "      <td>6213.238599</td>\n",
       "      <td>1109.216533</td>\n",
       "      <td>2886.795295</td>\n",
       "      <td>3343.142757</td>\n",
       "      <td>2819.349929</td>\n",
       "      <td>3435.038451</td>\n",
       "      <td>2418.785876</td>\n",
       "      <td>3636.622377</td>\n",
       "      <td>3323.130071</td>\n",
       "      <td>2435.475981</td>\n",
       "      <td>4292.748327</td>\n",
       "      <td>4394.921029</td>\n",
       "      <td>6253.286042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri782</th>\n",
       "      <td>4061.651777</td>\n",
       "      <td>4843.316872</td>\n",
       "      <td>2482.546419</td>\n",
       "      <td>5583.087318</td>\n",
       "      <td>3776.654648</td>\n",
       "      <td>4889.167584</td>\n",
       "      <td>91.023169</td>\n",
       "      <td>5144.803793</td>\n",
       "      <td>872.353912</td>\n",
       "      <td>5245.525835</td>\n",
       "      <td>4193.368972</td>\n",
       "      <td>4771.494334</td>\n",
       "      <td>1771.322195</td>\n",
       "      <td>429.060815</td>\n",
       "      <td>4600.581774</td>\n",
       "      <td>3524.216961</td>\n",
       "      <td>2203.234922</td>\n",
       "      <td>3354.132763</td>\n",
       "      <td>2368.453683</td>\n",
       "      <td>1215.275650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri783</th>\n",
       "      <td>4512.227419</td>\n",
       "      <td>5302.798055</td>\n",
       "      <td>2578.994089</td>\n",
       "      <td>5684.708426</td>\n",
       "      <td>1381.963299</td>\n",
       "      <td>3201.360763</td>\n",
       "      <td>2955.110545</td>\n",
       "      <td>2796.015949</td>\n",
       "      <td>801.468903</td>\n",
       "      <td>3482.892508</td>\n",
       "      <td>5290.363098</td>\n",
       "      <td>3598.456412</td>\n",
       "      <td>2796.495510</td>\n",
       "      <td>1784.838728</td>\n",
       "      <td>9772.163046</td>\n",
       "      <td>3328.015043</td>\n",
       "      <td>3131.552793</td>\n",
       "      <td>2842.630050</td>\n",
       "      <td>2030.780214</td>\n",
       "      <td>5674.758932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri784</th>\n",
       "      <td>2540.205777</td>\n",
       "      <td>4304.778987</td>\n",
       "      <td>264.197193</td>\n",
       "      <td>1581.844516</td>\n",
       "      <td>3188.623823</td>\n",
       "      <td>4916.915400</td>\n",
       "      <td>1271.450194</td>\n",
       "      <td>2508.160115</td>\n",
       "      <td>960.773504</td>\n",
       "      <td>4099.163390</td>\n",
       "      <td>5635.382637</td>\n",
       "      <td>3356.074128</td>\n",
       "      <td>7545.226232</td>\n",
       "      <td>3321.584433</td>\n",
       "      <td>4911.424018</td>\n",
       "      <td>5311.235279</td>\n",
       "      <td>1182.473205</td>\n",
       "      <td>1574.729324</td>\n",
       "      <td>1769.274038</td>\n",
       "      <td>4833.789380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri785</th>\n",
       "      <td>3178.225080</td>\n",
       "      <td>2675.996929</td>\n",
       "      <td>2086.933364</td>\n",
       "      <td>1962.469033</td>\n",
       "      <td>3912.100908</td>\n",
       "      <td>2760.507987</td>\n",
       "      <td>3793.263433</td>\n",
       "      <td>3648.752066</td>\n",
       "      <td>398.947275</td>\n",
       "      <td>4893.616568</td>\n",
       "      <td>1483.857764</td>\n",
       "      <td>3616.735482</td>\n",
       "      <td>1998.957711</td>\n",
       "      <td>2276.026674</td>\n",
       "      <td>1227.204617</td>\n",
       "      <td>1307.779651</td>\n",
       "      <td>1424.313033</td>\n",
       "      <td>5475.595613</td>\n",
       "      <td>68.064516</td>\n",
       "      <td>5764.741121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri786</th>\n",
       "      <td>5238.408861</td>\n",
       "      <td>2913.243255</td>\n",
       "      <td>3646.573149</td>\n",
       "      <td>1314.935500</td>\n",
       "      <td>2956.068170</td>\n",
       "      <td>1071.147436</td>\n",
       "      <td>4573.025632</td>\n",
       "      <td>6336.101709</td>\n",
       "      <td>2818.608634</td>\n",
       "      <td>4079.710392</td>\n",
       "      <td>2737.993637</td>\n",
       "      <td>4876.308107</td>\n",
       "      <td>5109.967130</td>\n",
       "      <td>5726.623855</td>\n",
       "      <td>3034.382265</td>\n",
       "      <td>6650.716001</td>\n",
       "      <td>701.892300</td>\n",
       "      <td>2014.426850</td>\n",
       "      <td>474.145463</td>\n",
       "      <td>1808.045100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri787</th>\n",
       "      <td>2128.680509</td>\n",
       "      <td>2615.667125</td>\n",
       "      <td>2985.848542</td>\n",
       "      <td>4934.076919</td>\n",
       "      <td>3415.574392</td>\n",
       "      <td>5916.007327</td>\n",
       "      <td>2115.014262</td>\n",
       "      <td>3506.908774</td>\n",
       "      <td>859.124963</td>\n",
       "      <td>4940.416967</td>\n",
       "      <td>5950.282079</td>\n",
       "      <td>5946.166274</td>\n",
       "      <td>2647.391623</td>\n",
       "      <td>2919.751553</td>\n",
       "      <td>3104.521870</td>\n",
       "      <td>4374.061099</td>\n",
       "      <td>1945.940434</td>\n",
       "      <td>4468.438433</td>\n",
       "      <td>2235.748193</td>\n",
       "      <td>4600.845751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri788</th>\n",
       "      <td>3289.598040</td>\n",
       "      <td>2956.095462</td>\n",
       "      <td>901.943606</td>\n",
       "      <td>1275.708524</td>\n",
       "      <td>2164.302010</td>\n",
       "      <td>2184.235727</td>\n",
       "      <td>1458.000263</td>\n",
       "      <td>4911.060084</td>\n",
       "      <td>1541.282125</td>\n",
       "      <td>174.671708</td>\n",
       "      <td>3404.728624</td>\n",
       "      <td>2039.753417</td>\n",
       "      <td>7661.254945</td>\n",
       "      <td>2544.937856</td>\n",
       "      <td>2894.085134</td>\n",
       "      <td>2097.406197</td>\n",
       "      <td>2449.789623</td>\n",
       "      <td>1448.160036</td>\n",
       "      <td>3401.964887</td>\n",
       "      <td>3665.907181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri789</th>\n",
       "      <td>3266.637423</td>\n",
       "      <td>2046.717222</td>\n",
       "      <td>1458.223500</td>\n",
       "      <td>5202.262902</td>\n",
       "      <td>4848.945756</td>\n",
       "      <td>1880.746647</td>\n",
       "      <td>3848.263144</td>\n",
       "      <td>4417.737087</td>\n",
       "      <td>1593.627485</td>\n",
       "      <td>3482.833496</td>\n",
       "      <td>769.815872</td>\n",
       "      <td>6670.988020</td>\n",
       "      <td>3709.102105</td>\n",
       "      <td>942.520302</td>\n",
       "      <td>5479.051571</td>\n",
       "      <td>7768.737201</td>\n",
       "      <td>2264.662905</td>\n",
       "      <td>2514.644353</td>\n",
       "      <td>2223.532546</td>\n",
       "      <td>7356.801290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri790</th>\n",
       "      <td>3243.676806</td>\n",
       "      <td>1694.553655</td>\n",
       "      <td>2344.315812</td>\n",
       "      <td>2093.984587</td>\n",
       "      <td>23.718172</td>\n",
       "      <td>4036.942422</td>\n",
       "      <td>1265.821139</td>\n",
       "      <td>2851.234205</td>\n",
       "      <td>1440.909358</td>\n",
       "      <td>3306.251916</td>\n",
       "      <td>472.812681</td>\n",
       "      <td>3221.144680</td>\n",
       "      <td>2506.323972</td>\n",
       "      <td>90.638872</td>\n",
       "      <td>4275.492316</td>\n",
       "      <td>3798.466850</td>\n",
       "      <td>2079.536187</td>\n",
       "      <td>2195.845083</td>\n",
       "      <td>5387.471180</td>\n",
       "      <td>4442.336218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri791</th>\n",
       "      <td>4241.495791</td>\n",
       "      <td>5087.653798</td>\n",
       "      <td>2434.538113</td>\n",
       "      <td>4861.520865</td>\n",
       "      <td>1025.562265</td>\n",
       "      <td>4214.275471</td>\n",
       "      <td>2195.825507</td>\n",
       "      <td>3968.874438</td>\n",
       "      <td>2670.125420</td>\n",
       "      <td>3156.023532</td>\n",
       "      <td>2545.030986</td>\n",
       "      <td>2442.954517</td>\n",
       "      <td>1900.092851</td>\n",
       "      <td>2442.454770</td>\n",
       "      <td>6214.298962</td>\n",
       "      <td>4050.510949</td>\n",
       "      <td>2206.991721</td>\n",
       "      <td>2537.442123</td>\n",
       "      <td>1694.565744</td>\n",
       "      <td>3013.597621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri792</th>\n",
       "      <td>4900.900043</td>\n",
       "      <td>3954.822348</td>\n",
       "      <td>2524.760414</td>\n",
       "      <td>2699.453959</td>\n",
       "      <td>1582.150397</td>\n",
       "      <td>4981.495428</td>\n",
       "      <td>2407.897795</td>\n",
       "      <td>2556.285151</td>\n",
       "      <td>154.592033</td>\n",
       "      <td>4978.688022</td>\n",
       "      <td>2561.147596</td>\n",
       "      <td>2858.224862</td>\n",
       "      <td>3494.033013</td>\n",
       "      <td>2528.649277</td>\n",
       "      <td>4620.321971</td>\n",
       "      <td>4335.147502</td>\n",
       "      <td>2334.447255</td>\n",
       "      <td>1097.150962</td>\n",
       "      <td>1473.579019</td>\n",
       "      <td>1407.772727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri793</th>\n",
       "      <td>6936.139635</td>\n",
       "      <td>411.802772</td>\n",
       "      <td>2595.375316</td>\n",
       "      <td>2453.825767</td>\n",
       "      <td>811.040228</td>\n",
       "      <td>5368.058274</td>\n",
       "      <td>965.098473</td>\n",
       "      <td>2850.724747</td>\n",
       "      <td>2684.192440</td>\n",
       "      <td>2513.326074</td>\n",
       "      <td>3618.164732</td>\n",
       "      <td>3276.868665</td>\n",
       "      <td>3180.597515</td>\n",
       "      <td>2632.676571</td>\n",
       "      <td>4177.248934</td>\n",
       "      <td>5353.417143</td>\n",
       "      <td>715.903707</td>\n",
       "      <td>2974.332001</td>\n",
       "      <td>3540.085232</td>\n",
       "      <td>6151.600761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri794</th>\n",
       "      <td>3652.329824</td>\n",
       "      <td>993.739769</td>\n",
       "      <td>1762.244401</td>\n",
       "      <td>2352.389475</td>\n",
       "      <td>264.346041</td>\n",
       "      <td>3680.327512</td>\n",
       "      <td>1303.707425</td>\n",
       "      <td>755.928403</td>\n",
       "      <td>3871.896900</td>\n",
       "      <td>2683.998126</td>\n",
       "      <td>4147.292883</td>\n",
       "      <td>3366.155548</td>\n",
       "      <td>1678.173084</td>\n",
       "      <td>1590.286219</td>\n",
       "      <td>1111.709391</td>\n",
       "      <td>5213.908137</td>\n",
       "      <td>2124.276970</td>\n",
       "      <td>4069.081407</td>\n",
       "      <td>1036.131331</td>\n",
       "      <td>3250.122298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri795</th>\n",
       "      <td>5720.511789</td>\n",
       "      <td>501.683922</td>\n",
       "      <td>1909.454826</td>\n",
       "      <td>1639.001703</td>\n",
       "      <td>2936.390224</td>\n",
       "      <td>7237.432080</td>\n",
       "      <td>2189.760828</td>\n",
       "      <td>3736.202494</td>\n",
       "      <td>402.242045</td>\n",
       "      <td>5595.751166</td>\n",
       "      <td>1987.623617</td>\n",
       "      <td>7542.080044</td>\n",
       "      <td>1492.020524</td>\n",
       "      <td>6880.514189</td>\n",
       "      <td>2142.064144</td>\n",
       "      <td>2234.388631</td>\n",
       "      <td>136.751172</td>\n",
       "      <td>1083.664338</td>\n",
       "      <td>4792.428429</td>\n",
       "      <td>1382.956162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri796</th>\n",
       "      <td>2758.573646</td>\n",
       "      <td>1200.771552</td>\n",
       "      <td>2056.665250</td>\n",
       "      <td>4398.357093</td>\n",
       "      <td>1472.701630</td>\n",
       "      <td>3937.958260</td>\n",
       "      <td>3965.507331</td>\n",
       "      <td>2583.617168</td>\n",
       "      <td>39.055602</td>\n",
       "      <td>6383.009192</td>\n",
       "      <td>2318.258457</td>\n",
       "      <td>542.198202</td>\n",
       "      <td>2288.292780</td>\n",
       "      <td>4285.795246</td>\n",
       "      <td>4474.289141</td>\n",
       "      <td>2870.842825</td>\n",
       "      <td>2925.248404</td>\n",
       "      <td>5155.599839</td>\n",
       "      <td>3694.720953</td>\n",
       "      <td>6008.420714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri797</th>\n",
       "      <td>391.748935</td>\n",
       "      <td>2201.052837</td>\n",
       "      <td>2588.827514</td>\n",
       "      <td>673.316629</td>\n",
       "      <td>2406.120513</td>\n",
       "      <td>3820.982569</td>\n",
       "      <td>2499.304673</td>\n",
       "      <td>7408.190559</td>\n",
       "      <td>142.867085</td>\n",
       "      <td>6556.225167</td>\n",
       "      <td>3987.742202</td>\n",
       "      <td>4242.313725</td>\n",
       "      <td>3207.331648</td>\n",
       "      <td>2747.464767</td>\n",
       "      <td>4554.053595</td>\n",
       "      <td>3960.482559</td>\n",
       "      <td>832.471194</td>\n",
       "      <td>5070.439599</td>\n",
       "      <td>1719.917882</td>\n",
       "      <td>2426.063597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri798</th>\n",
       "      <td>3512.765929</td>\n",
       "      <td>1499.012107</td>\n",
       "      <td>3825.258417</td>\n",
       "      <td>4856.997083</td>\n",
       "      <td>1995.831984</td>\n",
       "      <td>3384.769551</td>\n",
       "      <td>15.529804</td>\n",
       "      <td>2587.426839</td>\n",
       "      <td>1123.376025</td>\n",
       "      <td>8621.009037</td>\n",
       "      <td>2499.401219</td>\n",
       "      <td>2610.540313</td>\n",
       "      <td>2374.118832</td>\n",
       "      <td>5634.330496</td>\n",
       "      <td>4158.168942</td>\n",
       "      <td>6531.309088</td>\n",
       "      <td>4796.284042</td>\n",
       "      <td>684.373971</td>\n",
       "      <td>362.226794</td>\n",
       "      <td>2180.553914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri799</th>\n",
       "      <td>3899.095343</td>\n",
       "      <td>289.417464</td>\n",
       "      <td>660.403372</td>\n",
       "      <td>3381.583696</td>\n",
       "      <td>2974.408302</td>\n",
       "      <td>3617.110168</td>\n",
       "      <td>5387.409598</td>\n",
       "      <td>1604.109933</td>\n",
       "      <td>546.043986</td>\n",
       "      <td>1696.865757</td>\n",
       "      <td>1775.251366</td>\n",
       "      <td>507.863181</td>\n",
       "      <td>2374.118832</td>\n",
       "      <td>2800.938048</td>\n",
       "      <td>10366.926894</td>\n",
       "      <td>5457.655852</td>\n",
       "      <td>3485.996834</td>\n",
       "      <td>2704.862279</td>\n",
       "      <td>2044.366784</td>\n",
       "      <td>5363.982290</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>800 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Sub0         Sub1         Sub2         Sub3         Sub4  \\\n",
       "Tri0    2797.224240  1039.571212  4045.345952  3530.934210  2410.276348   \n",
       "Tri1     786.895089  3076.223066  1033.310418  3758.043454  4000.805778   \n",
       "Tri2    3516.902396  4632.818016  4874.066155  3031.377402  2485.677228   \n",
       "Tri3     333.881830   104.448476  2304.093856   586.098266  4575.178155   \n",
       "Tri4    6790.330061  2629.751046  3148.222058  1894.867975  2274.057485   \n",
       "Tri5    3047.828258   397.038302   114.215641  4089.899601  4049.434462   \n",
       "Tri6    2176.597045  3552.355757  1973.393087  4362.043226  5170.251441   \n",
       "Tri7    2733.437098  3250.115237  1378.417119  5991.874045   143.606176   \n",
       "Tri8    3290.277151  2180.419440  1069.322671  5277.547086  2287.661406   \n",
       "Tri9    1881.581897  1168.334372  2808.512816  2198.630268  1688.488219   \n",
       "Tri10   3646.313933  1625.659863  3206.440179  1194.569715  1939.383734   \n",
       "Tri11   3931.516192   192.566645  1403.470198  3397.295729  4681.754010   \n",
       "Tri12   4308.815582  1591.300260  1969.829569  4046.082575  2555.540064   \n",
       "Tri13   2004.232508  1972.600035  2536.188940  1908.891889  4091.166301   \n",
       "Tri14   6017.817486   644.955912  1987.820582  2354.542490  1388.969163   \n",
       "Tri15   2601.305283  3594.655184  2371.459375  3938.344443  2853.166655   \n",
       "Tri16   3999.043797  2071.515703  3385.070117  3601.361161  6218.904091   \n",
       "Tri17   1372.419652  1848.213972  4248.673137  3914.271056  3890.512470   \n",
       "Tri18   3650.763986  2293.542947  2728.329610  2176.302848  3461.945292   \n",
       "Tri19   4590.144644  2738.871921   271.504916   438.603787  1240.028763   \n",
       "Tri20   1789.110026  2564.281719  2561.038387  3934.218428  1274.958220   \n",
       "Tri21   2350.865209  3983.865823  1377.567893  3411.263401  1309.887676   \n",
       "Tri22   6952.390799  2063.316230  1535.851635  2888.308373  1344.817132   \n",
       "Tri23   3981.190750  3247.512882  3721.031070  2099.836777  1379.746589   \n",
       "Tri24   1018.919604  2192.488372  2749.424948  2821.333287  1414.676045   \n",
       "Tri25   2315.087241  2201.058303   719.014381   737.305297  4660.901242   \n",
       "Tri26   3425.943052  2960.328053  2058.422909  2792.324988  2366.328681   \n",
       "Tri27   3343.105868  3245.563710  4974.583632    23.429444  4954.807144   \n",
       "Tri28   2170.474769  3573.187792  3065.872135  4277.443964  1570.902741   \n",
       "Tri29   3201.988624   878.496721  1157.160637  6449.023514  2686.624157   \n",
       "...             ...          ...          ...          ...          ...   \n",
       "Tri770  5019.916501  4064.509064  1367.441537  4041.683022   338.933307   \n",
       "Tri771  1067.207049  1824.416712  4162.917234  4704.614259  2765.201984   \n",
       "Tri772  3397.691127  4499.183734  4694.741869  3151.216275  4963.785263   \n",
       "Tri773  4656.609071  3744.545650  2766.966958  3974.311001  3162.852076   \n",
       "Tri774  2418.176006  1269.214989   429.276661  4838.812325  2270.762832   \n",
       "Tri775  4193.896082   717.222895  4798.294129  3759.457306   478.139010   \n",
       "Tri776  3867.848234  1067.792534  1234.102840   654.158484  3203.563016   \n",
       "Tri777    98.144376  2967.010519  2830.656654  2309.465464  2162.254722   \n",
       "Tri778  3297.471584   951.434209  2841.784763   478.314962  3524.684787   \n",
       "Tri779  2766.458882   169.207955   254.220834  2357.865661  2070.051795   \n",
       "Tri780  2466.329475  4521.403690  2209.031340  1168.414376  1646.438184   \n",
       "Tri781  2166.200067  2618.547401  1943.968624  3723.972678  5701.735032   \n",
       "Tri782  4061.651777  4843.316872  2482.546419  5583.087318  3776.654648   \n",
       "Tri783  4512.227419  5302.798055  2578.994089  5684.708426  1381.963299   \n",
       "Tri784  2540.205777  4304.778987   264.197193  1581.844516  3188.623823   \n",
       "Tri785  3178.225080  2675.996929  2086.933364  1962.469033  3912.100908   \n",
       "Tri786  5238.408861  2913.243255  3646.573149  1314.935500  2956.068170   \n",
       "Tri787  2128.680509  2615.667125  2985.848542  4934.076919  3415.574392   \n",
       "Tri788  3289.598040  2956.095462   901.943606  1275.708524  2164.302010   \n",
       "Tri789  3266.637423  2046.717222  1458.223500  5202.262902  4848.945756   \n",
       "Tri790  3243.676806  1694.553655  2344.315812  2093.984587    23.718172   \n",
       "Tri791  4241.495791  5087.653798  2434.538113  4861.520865  1025.562265   \n",
       "Tri792  4900.900043  3954.822348  2524.760414  2699.453959  1582.150397   \n",
       "Tri793  6936.139635   411.802772  2595.375316  2453.825767   811.040228   \n",
       "Tri794  3652.329824   993.739769  1762.244401  2352.389475   264.346041   \n",
       "Tri795  5720.511789   501.683922  1909.454826  1639.001703  2936.390224   \n",
       "Tri796  2758.573646  1200.771552  2056.665250  4398.357093  1472.701630   \n",
       "Tri797   391.748935  2201.052837  2588.827514   673.316629  2406.120513   \n",
       "Tri798  3512.765929  1499.012107  3825.258417  4856.997083  1995.831984   \n",
       "Tri799  3899.095343   289.417464   660.403372  3381.583696  2974.408302   \n",
       "\n",
       "               Sub5         Sub6         Sub7         Sub8         Sub9  \\\n",
       "Tri0    6541.494156  1977.919842  2343.555594   143.695964  8147.939691   \n",
       "Tri1    2756.802996  2918.768116  2613.934992  2655.684434  7410.337807   \n",
       "Tri2    4929.841314   435.950399  3059.241733  2923.325600  3530.389021   \n",
       "Tri3    2365.682721  1285.101296  5050.566343  2446.870606  5096.855057   \n",
       "Tri4    8186.457041  1195.253881  3747.385847  1456.694541  3437.159878   \n",
       "Tri5    4025.464731  2638.680380  1885.518602   307.874145  1883.111558   \n",
       "Tri6    6009.945843   724.758133  3600.654491   501.585571  3658.042950   \n",
       "Tri7    6485.648064   543.664039  2136.843938  1224.511880  6117.384527   \n",
       "Tri8    5077.853063  2893.314803  4536.102482  2106.468811  1775.207528   \n",
       "Tri9    2049.245976  1336.294530  4475.980197   341.613792  1397.717855   \n",
       "Tri10   1879.157591  4970.830739  4134.752286  1298.460972  1956.628409   \n",
       "Tri11   6591.613394  2980.007209  2485.156212   522.050951  4378.778873   \n",
       "Tri12   5113.426538  2593.246610  4443.971194  2563.882354  5391.326624   \n",
       "Tri13   1679.608773  1536.272703  4023.633503  1786.137313  3038.511977   \n",
       "Tri14   2372.667094   479.298797  1233.238617  3057.372752  3146.273531   \n",
       "Tri15   4711.309827  3898.284833  3572.704270  1310.699188  4263.843023   \n",
       "Tri16   4637.388191  3305.677185  4283.664183   692.242028  2030.449406   \n",
       "Tri17   3076.043021  1293.978527  6441.018287  1816.063502  2344.698770   \n",
       "Tri18   6076.972257  2195.460676  5416.264595  1369.246142  5103.076196   \n",
       "Tri19   3096.072433  2370.345165  4593.902987  3272.597687  4735.979486   \n",
       "Tri20   4041.204419  2452.776553  2294.776565  1931.331379  7175.587179   \n",
       "Tri21    769.143341  2826.814718  7018.641416  1765.476153  3308.479365   \n",
       "Tri22   5570.172691  3200.852884  5913.022804   427.591714  3944.805607   \n",
       "Tri23   6456.138963  2025.538783  2661.638491  1088.332466  6264.921509   \n",
       "Tri24   4442.560508  3913.692260  5384.410278    32.019499  4496.280231   \n",
       "Tri25   3314.228722  1319.019511  2356.782408  1474.041409  1173.689771   \n",
       "Tri26   5725.728257  1011.737895  2399.555806  2611.716052  5671.847403   \n",
       "Tri27   2755.752430  1775.584328  5829.767282  2597.394722  6390.433703   \n",
       "Tri28   5864.062179  1338.712402  2062.441171  1444.139181  4584.654047   \n",
       "Tri29   4180.357765   213.195206  3046.308331  2865.075881  2478.623834   \n",
       "...             ...          ...          ...          ...          ...   \n",
       "Tri770  5673.397942   201.555076   951.357610  1083.986038  5877.593687   \n",
       "Tri771  6165.689173  3685.599231   989.469420   968.723980  4575.109982   \n",
       "Tri772  1619.179021  3265.231143  1790.337031  2243.599203  2481.871935   \n",
       "Tri773  8407.932097  1884.669293  2578.515791  1468.488071  3813.408616   \n",
       "Tri774  4255.242571   504.107442  1331.564119   234.181038  6640.959184   \n",
       "Tri775  6411.768042  4490.491911  2009.480471  1942.847743  6595.750322   \n",
       "Tri776  3217.279066  2788.954247  3148.277638   518.757154  2951.581858   \n",
       "Tri777  8827.325748  2478.898257  2860.291126  1468.474202  5147.091903   \n",
       "Tri778  6830.768774   620.907696  1336.452789   806.585847  3646.037162   \n",
       "Tri779  8638.329319   921.568698  6357.642769   258.042764  2535.568721   \n",
       "Tri780  4518.513887  1539.082013  2457.480226  1854.247566  4798.221013   \n",
       "Tri781  4603.053869  3837.779144  6213.238599  1109.216533  2886.795295   \n",
       "Tri782  4889.167584    91.023169  5144.803793   872.353912  5245.525835   \n",
       "Tri783  3201.360763  2955.110545  2796.015949   801.468903  3482.892508   \n",
       "Tri784  4916.915400  1271.450194  2508.160115   960.773504  4099.163390   \n",
       "Tri785  2760.507987  3793.263433  3648.752066   398.947275  4893.616568   \n",
       "Tri786  1071.147436  4573.025632  6336.101709  2818.608634  4079.710392   \n",
       "Tri787  5916.007327  2115.014262  3506.908774   859.124963  4940.416967   \n",
       "Tri788  2184.235727  1458.000263  4911.060084  1541.282125   174.671708   \n",
       "Tri789  1880.746647  3848.263144  4417.737087  1593.627485  3482.833496   \n",
       "Tri790  4036.942422  1265.821139  2851.234205  1440.909358  3306.251916   \n",
       "Tri791  4214.275471  2195.825507  3968.874438  2670.125420  3156.023532   \n",
       "Tri792  4981.495428  2407.897795  2556.285151   154.592033  4978.688022   \n",
       "Tri793  5368.058274   965.098473  2850.724747  2684.192440  2513.326074   \n",
       "Tri794  3680.327512  1303.707425   755.928403  3871.896900  2683.998126   \n",
       "Tri795  7237.432080  2189.760828  3736.202494   402.242045  5595.751166   \n",
       "Tri796  3937.958260  3965.507331  2583.617168    39.055602  6383.009192   \n",
       "Tri797  3820.982569  2499.304673  7408.190559   142.867085  6556.225167   \n",
       "Tri798  3384.769551    15.529804  2587.426839  1123.376025  8621.009037   \n",
       "Tri799  3617.110168  5387.409598  1604.109933   546.043986  1696.865757   \n",
       "\n",
       "              Sub10         Sub11        Sub12        Sub13         Sub14  \\\n",
       "Tri0    5183.942423   4548.240971  2076.921296  4230.548795   4134.589984   \n",
       "Tri1    3182.903975   4324.103096  1843.506277  1338.453235   2693.772203   \n",
       "Tri2    3002.555229   7537.781867  1989.249165  4513.510928   4473.733040   \n",
       "Tri3    1047.603006   5431.187785  2879.554454   311.319060   2814.385809   \n",
       "Tri4    6745.578676   4101.871682  1944.773775  1571.942134   3186.806328   \n",
       "Tri5    4216.585496   3179.854036  2370.740080  1178.494818   2048.812602   \n",
       "Tri6    1796.353749   2115.447625  2434.767571  2890.637333   1354.310794   \n",
       "Tri7    2269.914529   5853.215276  1970.536378  2433.792597   2363.395834   \n",
       "Tri8    3120.339818   2296.467312  3544.422187  4943.839493   2156.873736   \n",
       "Tri9    5802.017010   1227.185074  2183.988202   266.188603   5280.917742   \n",
       "Tri10   2732.487735   9493.147896  2475.476740   738.715809   2294.571907   \n",
       "Tri11   3018.287764   2650.184176    14.216346  3716.312716   6855.044510   \n",
       "Tri12    292.409469   4356.282690   579.064560  3869.193105   4032.326761   \n",
       "Tri13   3821.388413   3700.112011  2047.432799  3722.822930   3277.862188   \n",
       "Tri14   2439.637217   5154.616079  3210.443053  2303.223106   8024.009754   \n",
       "Tri15   1057.886020   2406.319185  2624.236741  4550.713883   3741.835217   \n",
       "Tri16   3598.057871   1374.546938  1480.611011  3241.384679   6352.487413   \n",
       "Tri17   1640.920209   5323.168630  3648.912380  2760.721103   7033.016570   \n",
       "Tri18   2892.060496   3892.435508  1295.714144    20.223690   3690.530028   \n",
       "Tri19   5122.880850   5917.462942  4162.275122  1684.470084   6845.328218   \n",
       "Tri20   3183.754138   3513.924554   905.013956   354.741832   3134.348455   \n",
       "Tri21   6039.588712   5881.403433  1107.831738  2119.146723   8965.077468   \n",
       "Tri22   2765.051691   4495.600498  3512.207504   105.080751   5065.155604   \n",
       "Tri23   2461.335394   6783.466281  3711.174364  1367.747318   2005.241990   \n",
       "Tri24   1248.691549  10061.049263  1844.528675    70.768552   2701.317234   \n",
       "Tri25   6404.474740   2472.570804  4559.196652  3857.026459    259.467407   \n",
       "Tri26   4001.436040   4696.457379  1134.304194  1819.079808   6214.829225   \n",
       "Tri27   2748.032360   6592.437245  2420.918590  2744.339671   5943.495369   \n",
       "Tri28   4684.956953   5955.686112  3997.029107   765.461186   5388.946834   \n",
       "Tri29   5169.539096   4025.666201  2542.109754  4541.154907   2248.276335   \n",
       "...             ...           ...          ...          ...           ...   \n",
       "Tri770  3119.652408   2362.919913  6689.664963  2072.202080   2514.064633   \n",
       "Tri771  1695.815829   3260.280990  3127.255327  3225.607562   7179.086423   \n",
       "Tri772   271.979249   4683.880827  1833.226420  1614.501208   3468.347864   \n",
       "Tri773  4232.841624   4911.570825  1306.936657   788.957415   5232.178707   \n",
       "Tri774  3613.393158   3765.241232  1785.795915  4049.183809   2139.079636   \n",
       "Tri775  2993.944692   9133.851062  1543.894241  2566.416763   2707.591795   \n",
       "Tri776  4466.085911   3913.510325  1199.334758  1727.319198   4205.028277   \n",
       "Tri777  4142.964627   3251.302244  1583.446266  1697.757692   4261.867278   \n",
       "Tri778  3950.351432   3485.024897  2994.188239  1890.126270   4927.337239   \n",
       "Tri779  2768.048500   4750.922044  1521.796345  4805.708894   2475.995081   \n",
       "Tri780  5150.004163   4877.891921  2463.586500  4265.530199   9967.211069   \n",
       "Tri781  3343.142757   2819.349929  3435.038451  2418.785876   3636.622377   \n",
       "Tri782  4193.368972   4771.494334  1771.322195   429.060815   4600.581774   \n",
       "Tri783  5290.363098   3598.456412  2796.495510  1784.838728   9772.163046   \n",
       "Tri784  5635.382637   3356.074128  7545.226232  3321.584433   4911.424018   \n",
       "Tri785  1483.857764   3616.735482  1998.957711  2276.026674   1227.204617   \n",
       "Tri786  2737.993637   4876.308107  5109.967130  5726.623855   3034.382265   \n",
       "Tri787  5950.282079   5946.166274  2647.391623  2919.751553   3104.521870   \n",
       "Tri788  3404.728624   2039.753417  7661.254945  2544.937856   2894.085134   \n",
       "Tri789   769.815872   6670.988020  3709.102105   942.520302   5479.051571   \n",
       "Tri790   472.812681   3221.144680  2506.323972    90.638872   4275.492316   \n",
       "Tri791  2545.030986   2442.954517  1900.092851  2442.454770   6214.298962   \n",
       "Tri792  2561.147596   2858.224862  3494.033013  2528.649277   4620.321971   \n",
       "Tri793  3618.164732   3276.868665  3180.597515  2632.676571   4177.248934   \n",
       "Tri794  4147.292883   3366.155548  1678.173084  1590.286219   1111.709391   \n",
       "Tri795  1987.623617   7542.080044  1492.020524  6880.514189   2142.064144   \n",
       "Tri796  2318.258457    542.198202  2288.292780  4285.795246   4474.289141   \n",
       "Tri797  3987.742202   4242.313725  3207.331648  2747.464767   4554.053595   \n",
       "Tri798  2499.401219   2610.540313  2374.118832  5634.330496   4158.168942   \n",
       "Tri799  1775.251366    507.863181  2374.118832  2800.938048  10366.926894   \n",
       "\n",
       "              Sub15        Sub16        Sub17        Sub18        Sub19  \n",
       "Tri0    2067.132295  4087.049471  2704.327437  2790.476384  5141.106292  \n",
       "Tri1    7239.094853  1320.715043  4449.372349  1085.884483  3556.231671  \n",
       "Tri2    7422.364759  3338.164717  4840.676786  2721.343095  1972.689272  \n",
       "Tri3    3396.500194  1324.780081  1518.991979  1676.395223  2051.924695  \n",
       "Tri4    6588.562378  2866.277989  2079.880840  1086.063139  7051.740732  \n",
       "Tri5    5268.016210  3215.274112  1073.497581    68.184823  4022.043321  \n",
       "Tri6    2957.510350  1447.567916  2020.893616  3598.657711  1439.384910  \n",
       "Tri7    1330.207606  1299.794499  3009.042214   256.578248  2584.729650  \n",
       "Tri8    4923.989022  1152.021083  2550.905619  1914.428198  3390.908581  \n",
       "Tri9    4852.981861  2825.540327  2645.230368   233.150604  4912.713861  \n",
       "Tri10   1304.651870  3412.442107  2469.096865  2715.130258  4059.136955  \n",
       "Tri11   1247.417970  1424.223869  3058.837397  4825.153445  1377.779459  \n",
       "Tri12   3886.207190    37.948280  2477.456413  7079.723259  2880.058505  \n",
       "Tri13   3697.007382  4759.422285  1278.100407  1124.765465  6248.230659  \n",
       "Tri14   1431.502336  2805.812304   209.452649    29.286915  5605.288288  \n",
       "Tri15   1844.605678  1575.856715  1632.182450  1717.001177  4712.964280  \n",
       "Tri16   4769.807630   345.901126  4162.285050  3181.815704  1458.025873  \n",
       "Tri17   5071.046489  2946.679451   293.872467  2713.797467  2096.062075  \n",
       "Tri18   1439.286201  3331.125830  1405.362358   674.766149  2690.896212  \n",
       "Tri19   6875.100886  4941.876044   194.371185  1230.682272  2914.678469  \n",
       "Tri20   5414.503988  1859.883386  1044.368043  2518.770276  3580.021139  \n",
       "Tri21   3400.401330  1074.646940  1467.227139   385.817210  4313.807516  \n",
       "Tri22   2852.460376  4284.974905  2193.340876  3922.917090  6555.267030  \n",
       "Tri23   3895.996977  2927.525147   567.936693  1042.124277  3309.478267  \n",
       "Tri24   1849.193271  1006.852834  2177.662910  2369.823241  5870.730322  \n",
       "Tri25   3718.624366  2832.405129  3471.125966   641.862063  6200.306855  \n",
       "Tri26   6221.959882   587.611647  1666.117688  2720.337090  4027.341897  \n",
       "Tri27   7500.719769  2714.634138  7112.070673  5129.402693  4819.212577  \n",
       "Tri28   4428.598436  1248.906561  1018.562576  3137.521116  6439.059402  \n",
       "Tri29   1793.347533  2628.103511  2009.567507  2917.641000  4727.321301  \n",
       "...             ...          ...          ...          ...          ...  \n",
       "Tri770  5782.253033  4552.410543   599.925866  6530.951552  4476.679376  \n",
       "Tri771  3611.052917  1488.165287  1476.624888  2159.477844  4498.994106  \n",
       "Tri772  5678.026196  1874.198809   253.650458  2037.577829  1747.981551  \n",
       "Tri773  7744.999475  2431.965152  1124.090837  4099.034461  1799.347268  \n",
       "Tri774  4870.585618  2632.308370  3795.825698  2065.665001  3533.836049  \n",
       "Tri775  6623.910297  2296.817615  2326.063114  2347.697164  6363.048613  \n",
       "Tri776  1562.338556  1253.087894   410.695565  3501.688532     2.748561  \n",
       "Tri777  2202.733356  1664.096491  2378.824201  4098.729006  5782.275558  \n",
       "Tri778  5385.048180  2319.536252  1521.943637  1293.826140  2437.975909  \n",
       "Tri779  4010.560573  2442.238703  6155.067426   309.268802  2002.542468  \n",
       "Tri780  5937.764403  3818.379737  4254.809643  1406.563422  1567.109027  \n",
       "Tri781  3323.130071  2435.475981  4292.748327  4394.921029  6253.286042  \n",
       "Tri782  3524.216961  2203.234922  3354.132763  2368.453683  1215.275650  \n",
       "Tri783  3328.015043  3131.552793  2842.630050  2030.780214  5674.758932  \n",
       "Tri784  5311.235279  1182.473205  1574.729324  1769.274038  4833.789380  \n",
       "Tri785  1307.779651  1424.313033  5475.595613    68.064516  5764.741121  \n",
       "Tri786  6650.716001   701.892300  2014.426850   474.145463  1808.045100  \n",
       "Tri787  4374.061099  1945.940434  4468.438433  2235.748193  4600.845751  \n",
       "Tri788  2097.406197  2449.789623  1448.160036  3401.964887  3665.907181  \n",
       "Tri789  7768.737201  2264.662905  2514.644353  2223.532546  7356.801290  \n",
       "Tri790  3798.466850  2079.536187  2195.845083  5387.471180  4442.336218  \n",
       "Tri791  4050.510949  2206.991721  2537.442123  1694.565744  3013.597621  \n",
       "Tri792  4335.147502  2334.447255  1097.150962  1473.579019  1407.772727  \n",
       "Tri793  5353.417143   715.903707  2974.332001  3540.085232  6151.600761  \n",
       "Tri794  5213.908137  2124.276970  4069.081407  1036.131331  3250.122298  \n",
       "Tri795  2234.388631   136.751172  1083.664338  4792.428429  1382.956162  \n",
       "Tri796  2870.842825  2925.248404  5155.599839  3694.720953  6008.420714  \n",
       "Tri797  3960.482559   832.471194  5070.439599  1719.917882  2426.063597  \n",
       "Tri798  6531.309088  4796.284042   684.373971   362.226794  2180.553914  \n",
       "Tri799  5457.655852  3485.996834  2704.862279  2044.366784  5363.982290  \n",
       "\n",
       "[800 rows x 20 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nan.interpolate(axis=0) #default column by column"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## After you've found the outliers and replaced with NaNs for each subject, check out this function:\n",
    "[pandas.DataFrame.interpolate](https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.interpolate.html#pandas.DataFrame.interpolate)\n",
    "\n",
    "* Use this function to interpolate the missing values for each subject (do not interpolate across subjects!)\n",
    "* Just use linear interpolation..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.interpolate()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## You can explore the \"Missing Values\" page for Pandas to figure out other ways of filling in missing values and outliers\n",
    "\n",
    "[page is here](https://pandas.pydata.org/pandas-docs/stable/missing_data.html#missing-data)\n",
    "\n",
    "* Figure out how to replace the outliers with the mean of each subject"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Yaqian\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:5: RuntimeWarning: invalid value encountered in greater\n",
      "  \"\"\"\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Sub0</th>\n",
       "      <th>Sub1</th>\n",
       "      <th>Sub2</th>\n",
       "      <th>Sub3</th>\n",
       "      <th>Sub4</th>\n",
       "      <th>Sub5</th>\n",
       "      <th>Sub6</th>\n",
       "      <th>Sub7</th>\n",
       "      <th>Sub8</th>\n",
       "      <th>Sub9</th>\n",
       "      <th>Sub10</th>\n",
       "      <th>Sub11</th>\n",
       "      <th>Sub12</th>\n",
       "      <th>Sub13</th>\n",
       "      <th>Sub14</th>\n",
       "      <th>Sub15</th>\n",
       "      <th>Sub16</th>\n",
       "      <th>Sub17</th>\n",
       "      <th>Sub18</th>\n",
       "      <th>Sub19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Tri0</th>\n",
       "      <td>2797.224240</td>\n",
       "      <td>1039.571212</td>\n",
       "      <td>4045.345952</td>\n",
       "      <td>3530.934210</td>\n",
       "      <td>2410.276348</td>\n",
       "      <td>6541.494156</td>\n",
       "      <td>1977.919842</td>\n",
       "      <td>2343.555594</td>\n",
       "      <td>143.695964</td>\n",
       "      <td>8147.939691</td>\n",
       "      <td>5183.942423</td>\n",
       "      <td>4548.240971</td>\n",
       "      <td>2076.921296</td>\n",
       "      <td>4230.548795</td>\n",
       "      <td>4134.589984</td>\n",
       "      <td>2067.132295</td>\n",
       "      <td>4087.049471</td>\n",
       "      <td>2704.327437</td>\n",
       "      <td>2790.476384</td>\n",
       "      <td>5141.106292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri1</th>\n",
       "      <td>786.895089</td>\n",
       "      <td>3076.223066</td>\n",
       "      <td>1033.310418</td>\n",
       "      <td>3758.043454</td>\n",
       "      <td>4000.805778</td>\n",
       "      <td>2756.802996</td>\n",
       "      <td>2918.768116</td>\n",
       "      <td>2613.934992</td>\n",
       "      <td>2655.684434</td>\n",
       "      <td>7410.337807</td>\n",
       "      <td>3182.903975</td>\n",
       "      <td>4324.103096</td>\n",
       "      <td>1843.506277</td>\n",
       "      <td>1338.453235</td>\n",
       "      <td>2693.772203</td>\n",
       "      <td>7239.094853</td>\n",
       "      <td>1320.715043</td>\n",
       "      <td>4449.372349</td>\n",
       "      <td>1085.884483</td>\n",
       "      <td>3556.231671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri2</th>\n",
       "      <td>3516.902396</td>\n",
       "      <td>4632.818016</td>\n",
       "      <td>4874.066155</td>\n",
       "      <td>3031.377402</td>\n",
       "      <td>2485.677228</td>\n",
       "      <td>4929.841314</td>\n",
       "      <td>435.950399</td>\n",
       "      <td>3059.241733</td>\n",
       "      <td>2923.325600</td>\n",
       "      <td>3530.389021</td>\n",
       "      <td>3002.555229</td>\n",
       "      <td>7537.781867</td>\n",
       "      <td>1989.249165</td>\n",
       "      <td>4513.510928</td>\n",
       "      <td>4473.733040</td>\n",
       "      <td>7422.364759</td>\n",
       "      <td>3338.164717</td>\n",
       "      <td>4840.676786</td>\n",
       "      <td>2721.343095</td>\n",
       "      <td>1972.689272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri3</th>\n",
       "      <td>333.881830</td>\n",
       "      <td>104.448476</td>\n",
       "      <td>2304.093856</td>\n",
       "      <td>586.098266</td>\n",
       "      <td>4575.178155</td>\n",
       "      <td>2365.682721</td>\n",
       "      <td>1285.101296</td>\n",
       "      <td>5050.566343</td>\n",
       "      <td>2446.870606</td>\n",
       "      <td>5096.855057</td>\n",
       "      <td>1047.603006</td>\n",
       "      <td>5431.187785</td>\n",
       "      <td>2879.554454</td>\n",
       "      <td>311.319060</td>\n",
       "      <td>2814.385809</td>\n",
       "      <td>3396.500194</td>\n",
       "      <td>1324.780081</td>\n",
       "      <td>1518.991979</td>\n",
       "      <td>1676.395223</td>\n",
       "      <td>2051.924695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri4</th>\n",
       "      <td>6790.330061</td>\n",
       "      <td>2629.751046</td>\n",
       "      <td>3148.222058</td>\n",
       "      <td>1894.867975</td>\n",
       "      <td>2274.057485</td>\n",
       "      <td>8186.457041</td>\n",
       "      <td>1195.253881</td>\n",
       "      <td>3747.385847</td>\n",
       "      <td>1456.694541</td>\n",
       "      <td>3437.159878</td>\n",
       "      <td>6745.578676</td>\n",
       "      <td>4101.871682</td>\n",
       "      <td>1944.773775</td>\n",
       "      <td>1571.942134</td>\n",
       "      <td>3186.806328</td>\n",
       "      <td>6588.562378</td>\n",
       "      <td>2866.277989</td>\n",
       "      <td>2079.880840</td>\n",
       "      <td>1086.063139</td>\n",
       "      <td>7051.740732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri5</th>\n",
       "      <td>3047.828258</td>\n",
       "      <td>397.038302</td>\n",
       "      <td>114.215641</td>\n",
       "      <td>4089.899601</td>\n",
       "      <td>4049.434462</td>\n",
       "      <td>4025.464731</td>\n",
       "      <td>2638.680380</td>\n",
       "      <td>1885.518602</td>\n",
       "      <td>307.874145</td>\n",
       "      <td>1883.111558</td>\n",
       "      <td>4216.585496</td>\n",
       "      <td>3179.854036</td>\n",
       "      <td>2370.740080</td>\n",
       "      <td>1178.494818</td>\n",
       "      <td>2048.812602</td>\n",
       "      <td>5268.016210</td>\n",
       "      <td>3215.274112</td>\n",
       "      <td>1073.497581</td>\n",
       "      <td>68.184823</td>\n",
       "      <td>4022.043321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri6</th>\n",
       "      <td>2176.597045</td>\n",
       "      <td>3552.355757</td>\n",
       "      <td>1973.393087</td>\n",
       "      <td>4362.043226</td>\n",
       "      <td>5170.251441</td>\n",
       "      <td>6009.945843</td>\n",
       "      <td>724.758133</td>\n",
       "      <td>3600.654491</td>\n",
       "      <td>501.585571</td>\n",
       "      <td>3658.042950</td>\n",
       "      <td>1796.353749</td>\n",
       "      <td>2115.447625</td>\n",
       "      <td>2434.767571</td>\n",
       "      <td>2890.637333</td>\n",
       "      <td>1354.310794</td>\n",
       "      <td>2957.510350</td>\n",
       "      <td>1447.567916</td>\n",
       "      <td>2020.893616</td>\n",
       "      <td>3598.657711</td>\n",
       "      <td>1439.384910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri7</th>\n",
       "      <td>3318.389859</td>\n",
       "      <td>3250.115237</td>\n",
       "      <td>1378.417119</td>\n",
       "      <td>5991.874045</td>\n",
       "      <td>143.606176</td>\n",
       "      <td>6485.648064</td>\n",
       "      <td>543.664039</td>\n",
       "      <td>2136.843938</td>\n",
       "      <td>1224.511880</td>\n",
       "      <td>6117.384527</td>\n",
       "      <td>2269.914529</td>\n",
       "      <td>5853.215276</td>\n",
       "      <td>1970.536378</td>\n",
       "      <td>2433.792597</td>\n",
       "      <td>2363.395834</td>\n",
       "      <td>1330.207606</td>\n",
       "      <td>2289.417774</td>\n",
       "      <td>3009.042214</td>\n",
       "      <td>256.578248</td>\n",
       "      <td>2584.729650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri8</th>\n",
       "      <td>3290.277151</td>\n",
       "      <td>2180.419440</td>\n",
       "      <td>1069.322671</td>\n",
       "      <td>5277.547086</td>\n",
       "      <td>2287.661406</td>\n",
       "      <td>5077.853063</td>\n",
       "      <td>2893.314803</td>\n",
       "      <td>4536.102482</td>\n",
       "      <td>2106.468811</td>\n",
       "      <td>1775.207528</td>\n",
       "      <td>3120.339818</td>\n",
       "      <td>2296.467312</td>\n",
       "      <td>3544.422187</td>\n",
       "      <td>4943.839493</td>\n",
       "      <td>2156.873736</td>\n",
       "      <td>4923.989022</td>\n",
       "      <td>1152.021083</td>\n",
       "      <td>2550.905619</td>\n",
       "      <td>1914.428198</td>\n",
       "      <td>3390.908581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri9</th>\n",
       "      <td>1881.581897</td>\n",
       "      <td>1168.334372</td>\n",
       "      <td>2808.512816</td>\n",
       "      <td>2198.630268</td>\n",
       "      <td>1688.488219</td>\n",
       "      <td>2049.245976</td>\n",
       "      <td>1336.294530</td>\n",
       "      <td>4475.980197</td>\n",
       "      <td>341.613792</td>\n",
       "      <td>1397.717855</td>\n",
       "      <td>5802.017010</td>\n",
       "      <td>1227.185074</td>\n",
       "      <td>2183.988202</td>\n",
       "      <td>266.188603</td>\n",
       "      <td>5280.917742</td>\n",
       "      <td>4852.981861</td>\n",
       "      <td>2825.540327</td>\n",
       "      <td>2645.230368</td>\n",
       "      <td>233.150604</td>\n",
       "      <td>4912.713861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri10</th>\n",
       "      <td>3646.313933</td>\n",
       "      <td>1625.659863</td>\n",
       "      <td>3206.440179</td>\n",
       "      <td>1194.569715</td>\n",
       "      <td>1939.383734</td>\n",
       "      <td>1879.157591</td>\n",
       "      <td>4970.830739</td>\n",
       "      <td>4134.752286</td>\n",
       "      <td>1298.460972</td>\n",
       "      <td>1956.628409</td>\n",
       "      <td>2732.487735</td>\n",
       "      <td>9493.147896</td>\n",
       "      <td>2475.476740</td>\n",
       "      <td>738.715809</td>\n",
       "      <td>2294.571907</td>\n",
       "      <td>1304.651870</td>\n",
       "      <td>3412.442107</td>\n",
       "      <td>2469.096865</td>\n",
       "      <td>2715.130258</td>\n",
       "      <td>4059.136955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri11</th>\n",
       "      <td>3931.516192</td>\n",
       "      <td>192.566645</td>\n",
       "      <td>1403.470198</td>\n",
       "      <td>3397.295729</td>\n",
       "      <td>4681.754010</td>\n",
       "      <td>6591.613394</td>\n",
       "      <td>2980.007209</td>\n",
       "      <td>2485.156212</td>\n",
       "      <td>522.050951</td>\n",
       "      <td>4378.778873</td>\n",
       "      <td>3018.287764</td>\n",
       "      <td>2650.184176</td>\n",
       "      <td>14.216346</td>\n",
       "      <td>3716.312716</td>\n",
       "      <td>6855.044510</td>\n",
       "      <td>1247.417970</td>\n",
       "      <td>1424.223869</td>\n",
       "      <td>3058.837397</td>\n",
       "      <td>4825.153445</td>\n",
       "      <td>1377.779459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri12</th>\n",
       "      <td>4308.815582</td>\n",
       "      <td>1591.300260</td>\n",
       "      <td>2347.414238</td>\n",
       "      <td>4046.082575</td>\n",
       "      <td>2555.540064</td>\n",
       "      <td>5113.426538</td>\n",
       "      <td>2593.246610</td>\n",
       "      <td>4443.971194</td>\n",
       "      <td>2563.882354</td>\n",
       "      <td>5391.326624</td>\n",
       "      <td>292.409469</td>\n",
       "      <td>4356.282690</td>\n",
       "      <td>579.064560</td>\n",
       "      <td>3869.193105</td>\n",
       "      <td>4032.326761</td>\n",
       "      <td>3886.207190</td>\n",
       "      <td>37.948280</td>\n",
       "      <td>2477.456413</td>\n",
       "      <td>7079.723259</td>\n",
       "      <td>2880.058505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri13</th>\n",
       "      <td>2004.232508</td>\n",
       "      <td>1972.600035</td>\n",
       "      <td>2536.188940</td>\n",
       "      <td>1908.891889</td>\n",
       "      <td>4091.166301</td>\n",
       "      <td>1679.608773</td>\n",
       "      <td>2415.209075</td>\n",
       "      <td>4023.633503</td>\n",
       "      <td>1786.137313</td>\n",
       "      <td>3038.511977</td>\n",
       "      <td>3821.388413</td>\n",
       "      <td>3700.112011</td>\n",
       "      <td>2047.432799</td>\n",
       "      <td>3722.822930</td>\n",
       "      <td>3277.862188</td>\n",
       "      <td>3697.007382</td>\n",
       "      <td>4759.422285</td>\n",
       "      <td>1278.100407</td>\n",
       "      <td>1124.765465</td>\n",
       "      <td>6248.230659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri14</th>\n",
       "      <td>6017.817486</td>\n",
       "      <td>644.955912</td>\n",
       "      <td>1987.820582</td>\n",
       "      <td>2354.542490</td>\n",
       "      <td>1388.969163</td>\n",
       "      <td>2372.667094</td>\n",
       "      <td>479.298797</td>\n",
       "      <td>1233.238617</td>\n",
       "      <td>3057.372752</td>\n",
       "      <td>3146.273531</td>\n",
       "      <td>3317.870108</td>\n",
       "      <td>5154.616079</td>\n",
       "      <td>3210.443053</td>\n",
       "      <td>2303.223106</td>\n",
       "      <td>8024.009754</td>\n",
       "      <td>1431.502336</td>\n",
       "      <td>2805.812304</td>\n",
       "      <td>209.452649</td>\n",
       "      <td>29.286915</td>\n",
       "      <td>5605.288288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri15</th>\n",
       "      <td>2601.305283</td>\n",
       "      <td>3594.655184</td>\n",
       "      <td>2371.459375</td>\n",
       "      <td>3938.344443</td>\n",
       "      <td>2853.166655</td>\n",
       "      <td>4711.309827</td>\n",
       "      <td>3898.284833</td>\n",
       "      <td>3572.704270</td>\n",
       "      <td>1310.699188</td>\n",
       "      <td>4263.843023</td>\n",
       "      <td>1057.886020</td>\n",
       "      <td>2406.319185</td>\n",
       "      <td>2624.236741</td>\n",
       "      <td>4550.713883</td>\n",
       "      <td>3741.835217</td>\n",
       "      <td>1844.605678</td>\n",
       "      <td>2289.417774</td>\n",
       "      <td>1632.182450</td>\n",
       "      <td>1717.001177</td>\n",
       "      <td>4712.964280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri16</th>\n",
       "      <td>3999.043797</td>\n",
       "      <td>2071.515703</td>\n",
       "      <td>3385.070117</td>\n",
       "      <td>3601.361161</td>\n",
       "      <td>6218.904091</td>\n",
       "      <td>4637.388191</td>\n",
       "      <td>3305.677185</td>\n",
       "      <td>4283.664183</td>\n",
       "      <td>692.242028</td>\n",
       "      <td>2030.449406</td>\n",
       "      <td>3598.057871</td>\n",
       "      <td>1374.546938</td>\n",
       "      <td>1480.611011</td>\n",
       "      <td>3241.384679</td>\n",
       "      <td>6352.487413</td>\n",
       "      <td>4769.807630</td>\n",
       "      <td>345.901126</td>\n",
       "      <td>4162.285050</td>\n",
       "      <td>3181.815704</td>\n",
       "      <td>1458.025873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri17</th>\n",
       "      <td>1372.419652</td>\n",
       "      <td>1848.213972</td>\n",
       "      <td>4248.673137</td>\n",
       "      <td>3914.271056</td>\n",
       "      <td>3890.512470</td>\n",
       "      <td>3076.043021</td>\n",
       "      <td>1293.978527</td>\n",
       "      <td>6441.018287</td>\n",
       "      <td>1816.063502</td>\n",
       "      <td>2344.698770</td>\n",
       "      <td>1640.920209</td>\n",
       "      <td>5323.168630</td>\n",
       "      <td>3648.912380</td>\n",
       "      <td>2760.721103</td>\n",
       "      <td>7033.016570</td>\n",
       "      <td>5071.046489</td>\n",
       "      <td>2946.679451</td>\n",
       "      <td>293.872467</td>\n",
       "      <td>2713.797467</td>\n",
       "      <td>2096.062075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri18</th>\n",
       "      <td>3650.763986</td>\n",
       "      <td>2418.379541</td>\n",
       "      <td>2728.329610</td>\n",
       "      <td>2176.302848</td>\n",
       "      <td>3461.945292</td>\n",
       "      <td>6076.972257</td>\n",
       "      <td>2195.460676</td>\n",
       "      <td>5416.264595</td>\n",
       "      <td>1369.246142</td>\n",
       "      <td>5103.076196</td>\n",
       "      <td>2892.060496</td>\n",
       "      <td>3892.435508</td>\n",
       "      <td>1295.714144</td>\n",
       "      <td>20.223690</td>\n",
       "      <td>3690.530028</td>\n",
       "      <td>1439.286201</td>\n",
       "      <td>3331.125830</td>\n",
       "      <td>1405.362358</td>\n",
       "      <td>674.766149</td>\n",
       "      <td>2690.896212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri19</th>\n",
       "      <td>4590.144644</td>\n",
       "      <td>2738.871921</td>\n",
       "      <td>271.504916</td>\n",
       "      <td>438.603787</td>\n",
       "      <td>1240.028763</td>\n",
       "      <td>3096.072433</td>\n",
       "      <td>2370.345165</td>\n",
       "      <td>4593.902987</td>\n",
       "      <td>3272.597687</td>\n",
       "      <td>4735.979486</td>\n",
       "      <td>5122.880850</td>\n",
       "      <td>5917.462942</td>\n",
       "      <td>4162.275122</td>\n",
       "      <td>1684.470084</td>\n",
       "      <td>6845.328218</td>\n",
       "      <td>6875.100886</td>\n",
       "      <td>4941.876044</td>\n",
       "      <td>194.371185</td>\n",
       "      <td>1230.682272</td>\n",
       "      <td>2914.678469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri20</th>\n",
       "      <td>1789.110026</td>\n",
       "      <td>2564.281719</td>\n",
       "      <td>2561.038387</td>\n",
       "      <td>3934.218428</td>\n",
       "      <td>2489.637962</td>\n",
       "      <td>4041.204419</td>\n",
       "      <td>2452.776553</td>\n",
       "      <td>2294.776565</td>\n",
       "      <td>1931.331379</td>\n",
       "      <td>7175.587179</td>\n",
       "      <td>3183.754138</td>\n",
       "      <td>3513.924554</td>\n",
       "      <td>905.013956</td>\n",
       "      <td>354.741832</td>\n",
       "      <td>3134.348455</td>\n",
       "      <td>5414.503988</td>\n",
       "      <td>1859.883386</td>\n",
       "      <td>1044.368043</td>\n",
       "      <td>2518.770276</td>\n",
       "      <td>3580.021139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri21</th>\n",
       "      <td>2350.865209</td>\n",
       "      <td>3983.865823</td>\n",
       "      <td>1377.567893</td>\n",
       "      <td>3372.263683</td>\n",
       "      <td>2489.637962</td>\n",
       "      <td>769.143341</td>\n",
       "      <td>2415.209075</td>\n",
       "      <td>7018.641416</td>\n",
       "      <td>1765.476153</td>\n",
       "      <td>3308.479365</td>\n",
       "      <td>6039.588712</td>\n",
       "      <td>5881.403433</td>\n",
       "      <td>1107.831738</td>\n",
       "      <td>2119.146723</td>\n",
       "      <td>8965.077468</td>\n",
       "      <td>3400.401330</td>\n",
       "      <td>1074.646940</td>\n",
       "      <td>1467.227139</td>\n",
       "      <td>385.817210</td>\n",
       "      <td>4313.807516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri22</th>\n",
       "      <td>6952.390799</td>\n",
       "      <td>2063.316230</td>\n",
       "      <td>1535.851635</td>\n",
       "      <td>2888.308373</td>\n",
       "      <td>2489.637962</td>\n",
       "      <td>5570.172691</td>\n",
       "      <td>3200.852884</td>\n",
       "      <td>5913.022804</td>\n",
       "      <td>427.591714</td>\n",
       "      <td>3944.805607</td>\n",
       "      <td>2765.051691</td>\n",
       "      <td>4495.600498</td>\n",
       "      <td>3512.207504</td>\n",
       "      <td>105.080751</td>\n",
       "      <td>5065.155604</td>\n",
       "      <td>2852.460376</td>\n",
       "      <td>4284.974905</td>\n",
       "      <td>2193.340876</td>\n",
       "      <td>3922.917090</td>\n",
       "      <td>6555.267030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri23</th>\n",
       "      <td>3981.190750</td>\n",
       "      <td>3247.512882</td>\n",
       "      <td>3721.031070</td>\n",
       "      <td>2099.836777</td>\n",
       "      <td>2489.637962</td>\n",
       "      <td>6456.138963</td>\n",
       "      <td>2025.538783</td>\n",
       "      <td>2661.638491</td>\n",
       "      <td>1088.332466</td>\n",
       "      <td>6264.921509</td>\n",
       "      <td>2461.335394</td>\n",
       "      <td>6783.466281</td>\n",
       "      <td>3711.174364</td>\n",
       "      <td>1367.747318</td>\n",
       "      <td>2005.241990</td>\n",
       "      <td>3895.996977</td>\n",
       "      <td>2927.525147</td>\n",
       "      <td>567.936693</td>\n",
       "      <td>1042.124277</td>\n",
       "      <td>3309.478267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri24</th>\n",
       "      <td>1018.919604</td>\n",
       "      <td>2192.488372</td>\n",
       "      <td>2749.424948</td>\n",
       "      <td>2821.333287</td>\n",
       "      <td>1414.676045</td>\n",
       "      <td>4442.560508</td>\n",
       "      <td>3913.692260</td>\n",
       "      <td>5384.410278</td>\n",
       "      <td>32.019499</td>\n",
       "      <td>4496.280231</td>\n",
       "      <td>1248.691549</td>\n",
       "      <td>10061.049263</td>\n",
       "      <td>1844.528675</td>\n",
       "      <td>70.768552</td>\n",
       "      <td>2701.317234</td>\n",
       "      <td>1849.193271</td>\n",
       "      <td>1006.852834</td>\n",
       "      <td>2177.662910</td>\n",
       "      <td>2369.823241</td>\n",
       "      <td>5870.730322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri25</th>\n",
       "      <td>2315.087241</td>\n",
       "      <td>2201.058303</td>\n",
       "      <td>719.014381</td>\n",
       "      <td>737.305297</td>\n",
       "      <td>4660.901242</td>\n",
       "      <td>3314.228722</td>\n",
       "      <td>1319.019511</td>\n",
       "      <td>2356.782408</td>\n",
       "      <td>1474.041409</td>\n",
       "      <td>1173.689771</td>\n",
       "      <td>6404.474740</td>\n",
       "      <td>2472.570804</td>\n",
       "      <td>4559.196652</td>\n",
       "      <td>3857.026459</td>\n",
       "      <td>259.467407</td>\n",
       "      <td>3718.624366</td>\n",
       "      <td>2832.405129</td>\n",
       "      <td>3471.125966</td>\n",
       "      <td>641.862063</td>\n",
       "      <td>6200.306855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri26</th>\n",
       "      <td>3425.943052</td>\n",
       "      <td>2960.328053</td>\n",
       "      <td>2058.422909</td>\n",
       "      <td>2792.324988</td>\n",
       "      <td>2366.328681</td>\n",
       "      <td>5725.728257</td>\n",
       "      <td>1011.737895</td>\n",
       "      <td>2399.555806</td>\n",
       "      <td>2611.716052</td>\n",
       "      <td>5671.847403</td>\n",
       "      <td>4001.436040</td>\n",
       "      <td>4696.457379</td>\n",
       "      <td>1134.304194</td>\n",
       "      <td>1819.079808</td>\n",
       "      <td>6214.829225</td>\n",
       "      <td>6221.959882</td>\n",
       "      <td>587.611647</td>\n",
       "      <td>1666.117688</td>\n",
       "      <td>2720.337090</td>\n",
       "      <td>4027.341897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri27</th>\n",
       "      <td>3343.105868</td>\n",
       "      <td>3245.563710</td>\n",
       "      <td>4974.583632</td>\n",
       "      <td>23.429444</td>\n",
       "      <td>4954.807144</td>\n",
       "      <td>2755.752430</td>\n",
       "      <td>1775.584328</td>\n",
       "      <td>5829.767282</td>\n",
       "      <td>2597.394722</td>\n",
       "      <td>6390.433703</td>\n",
       "      <td>2748.032360</td>\n",
       "      <td>6592.437245</td>\n",
       "      <td>2420.918590</td>\n",
       "      <td>2744.339671</td>\n",
       "      <td>5943.495369</td>\n",
       "      <td>7500.719769</td>\n",
       "      <td>2714.634138</td>\n",
       "      <td>7112.070673</td>\n",
       "      <td>5129.402693</td>\n",
       "      <td>4819.212577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri28</th>\n",
       "      <td>2170.474769</td>\n",
       "      <td>3573.187792</td>\n",
       "      <td>2347.414238</td>\n",
       "      <td>4277.443964</td>\n",
       "      <td>1570.902741</td>\n",
       "      <td>5864.062179</td>\n",
       "      <td>1338.712402</td>\n",
       "      <td>2062.441171</td>\n",
       "      <td>1444.139181</td>\n",
       "      <td>4584.654047</td>\n",
       "      <td>4684.956953</td>\n",
       "      <td>5955.686112</td>\n",
       "      <td>3997.029107</td>\n",
       "      <td>765.461186</td>\n",
       "      <td>5388.946834</td>\n",
       "      <td>4428.598436</td>\n",
       "      <td>1248.906561</td>\n",
       "      <td>1018.562576</td>\n",
       "      <td>3137.521116</td>\n",
       "      <td>6439.059402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri29</th>\n",
       "      <td>3201.988624</td>\n",
       "      <td>878.496721</td>\n",
       "      <td>1157.160637</td>\n",
       "      <td>6449.023514</td>\n",
       "      <td>2686.624157</td>\n",
       "      <td>4180.357765</td>\n",
       "      <td>213.195206</td>\n",
       "      <td>3046.308331</td>\n",
       "      <td>2865.075881</td>\n",
       "      <td>2478.623834</td>\n",
       "      <td>5169.539096</td>\n",
       "      <td>4025.666201</td>\n",
       "      <td>2542.109754</td>\n",
       "      <td>4541.154907</td>\n",
       "      <td>2248.276335</td>\n",
       "      <td>1793.347533</td>\n",
       "      <td>2628.103511</td>\n",
       "      <td>2009.567507</td>\n",
       "      <td>2917.641000</td>\n",
       "      <td>4727.321301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri770</th>\n",
       "      <td>5019.916501</td>\n",
       "      <td>4064.509064</td>\n",
       "      <td>1367.441537</td>\n",
       "      <td>3372.263683</td>\n",
       "      <td>338.933307</td>\n",
       "      <td>5673.397942</td>\n",
       "      <td>201.555076</td>\n",
       "      <td>951.357610</td>\n",
       "      <td>1083.986038</td>\n",
       "      <td>5877.593687</td>\n",
       "      <td>3119.652408</td>\n",
       "      <td>2362.919913</td>\n",
       "      <td>6689.664963</td>\n",
       "      <td>2072.202080</td>\n",
       "      <td>2514.064633</td>\n",
       "      <td>5782.253033</td>\n",
       "      <td>4552.410543</td>\n",
       "      <td>599.925866</td>\n",
       "      <td>6530.951552</td>\n",
       "      <td>4476.679376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri771</th>\n",
       "      <td>1067.207049</td>\n",
       "      <td>1824.416712</td>\n",
       "      <td>4162.917234</td>\n",
       "      <td>4704.614259</td>\n",
       "      <td>2765.201984</td>\n",
       "      <td>6165.689173</td>\n",
       "      <td>3685.599231</td>\n",
       "      <td>989.469420</td>\n",
       "      <td>968.723980</td>\n",
       "      <td>4575.109982</td>\n",
       "      <td>3317.870108</td>\n",
       "      <td>3260.280990</td>\n",
       "      <td>3127.255327</td>\n",
       "      <td>3225.607562</td>\n",
       "      <td>7179.086423</td>\n",
       "      <td>3611.052917</td>\n",
       "      <td>1488.165287</td>\n",
       "      <td>1476.624888</td>\n",
       "      <td>2159.477844</td>\n",
       "      <td>4498.994106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri772</th>\n",
       "      <td>3397.691127</td>\n",
       "      <td>4499.183734</td>\n",
       "      <td>4694.741869</td>\n",
       "      <td>3151.216275</td>\n",
       "      <td>4963.785263</td>\n",
       "      <td>1619.179021</td>\n",
       "      <td>3265.231143</td>\n",
       "      <td>1790.337031</td>\n",
       "      <td>2243.599203</td>\n",
       "      <td>2481.871935</td>\n",
       "      <td>271.979249</td>\n",
       "      <td>4683.880827</td>\n",
       "      <td>1833.226420</td>\n",
       "      <td>1614.501208</td>\n",
       "      <td>3468.347864</td>\n",
       "      <td>4385.750825</td>\n",
       "      <td>1874.198809</td>\n",
       "      <td>253.650458</td>\n",
       "      <td>2037.577829</td>\n",
       "      <td>1747.981551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri773</th>\n",
       "      <td>4656.609071</td>\n",
       "      <td>3744.545650</td>\n",
       "      <td>2766.966958</td>\n",
       "      <td>3974.311001</td>\n",
       "      <td>3162.852076</td>\n",
       "      <td>8407.932097</td>\n",
       "      <td>2415.209075</td>\n",
       "      <td>2578.515791</td>\n",
       "      <td>1468.488071</td>\n",
       "      <td>3813.408616</td>\n",
       "      <td>4232.841624</td>\n",
       "      <td>4911.570825</td>\n",
       "      <td>1306.936657</td>\n",
       "      <td>788.957415</td>\n",
       "      <td>5232.178707</td>\n",
       "      <td>7744.999475</td>\n",
       "      <td>2431.965152</td>\n",
       "      <td>1124.090837</td>\n",
       "      <td>4099.034461</td>\n",
       "      <td>1799.347268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri774</th>\n",
       "      <td>2418.176006</td>\n",
       "      <td>1269.214989</td>\n",
       "      <td>429.276661</td>\n",
       "      <td>4838.812325</td>\n",
       "      <td>2270.762832</td>\n",
       "      <td>4255.242571</td>\n",
       "      <td>504.107442</td>\n",
       "      <td>1331.564119</td>\n",
       "      <td>234.181038</td>\n",
       "      <td>6640.959184</td>\n",
       "      <td>3317.870108</td>\n",
       "      <td>3765.241232</td>\n",
       "      <td>1785.795915</td>\n",
       "      <td>4049.183809</td>\n",
       "      <td>2139.079636</td>\n",
       "      <td>4870.585618</td>\n",
       "      <td>2632.308370</td>\n",
       "      <td>3795.825698</td>\n",
       "      <td>2065.665001</td>\n",
       "      <td>3533.836049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri775</th>\n",
       "      <td>4193.896082</td>\n",
       "      <td>717.222895</td>\n",
       "      <td>4798.294129</td>\n",
       "      <td>3759.457306</td>\n",
       "      <td>478.139010</td>\n",
       "      <td>6411.768042</td>\n",
       "      <td>4490.491911</td>\n",
       "      <td>2009.480471</td>\n",
       "      <td>1942.847743</td>\n",
       "      <td>6595.750322</td>\n",
       "      <td>2993.944692</td>\n",
       "      <td>9133.851062</td>\n",
       "      <td>1543.894241</td>\n",
       "      <td>2566.416763</td>\n",
       "      <td>2707.591795</td>\n",
       "      <td>6623.910297</td>\n",
       "      <td>2296.817615</td>\n",
       "      <td>2326.063114</td>\n",
       "      <td>2347.697164</td>\n",
       "      <td>6363.048613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri776</th>\n",
       "      <td>3867.848234</td>\n",
       "      <td>1067.792534</td>\n",
       "      <td>1234.102840</td>\n",
       "      <td>654.158484</td>\n",
       "      <td>3203.563016</td>\n",
       "      <td>3217.279066</td>\n",
       "      <td>2788.954247</td>\n",
       "      <td>3148.277638</td>\n",
       "      <td>518.757154</td>\n",
       "      <td>2951.581858</td>\n",
       "      <td>4466.085911</td>\n",
       "      <td>3913.510325</td>\n",
       "      <td>1199.334758</td>\n",
       "      <td>1727.319198</td>\n",
       "      <td>4205.028277</td>\n",
       "      <td>1562.338556</td>\n",
       "      <td>1253.087894</td>\n",
       "      <td>410.695565</td>\n",
       "      <td>3501.688532</td>\n",
       "      <td>2.748561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri777</th>\n",
       "      <td>98.144376</td>\n",
       "      <td>2967.010519</td>\n",
       "      <td>2830.656654</td>\n",
       "      <td>2309.465464</td>\n",
       "      <td>2162.254722</td>\n",
       "      <td>8827.325748</td>\n",
       "      <td>2478.898257</td>\n",
       "      <td>2860.291126</td>\n",
       "      <td>1468.474202</td>\n",
       "      <td>5147.091903</td>\n",
       "      <td>4142.964627</td>\n",
       "      <td>3251.302244</td>\n",
       "      <td>1583.446266</td>\n",
       "      <td>1697.757692</td>\n",
       "      <td>4261.867278</td>\n",
       "      <td>2202.733356</td>\n",
       "      <td>1664.096491</td>\n",
       "      <td>2378.824201</td>\n",
       "      <td>4098.729006</td>\n",
       "      <td>5782.275558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri778</th>\n",
       "      <td>3297.471584</td>\n",
       "      <td>951.434209</td>\n",
       "      <td>2841.784763</td>\n",
       "      <td>478.314962</td>\n",
       "      <td>3524.684787</td>\n",
       "      <td>6830.768774</td>\n",
       "      <td>620.907696</td>\n",
       "      <td>1336.452789</td>\n",
       "      <td>806.585847</td>\n",
       "      <td>3646.037162</td>\n",
       "      <td>3950.351432</td>\n",
       "      <td>3485.024897</td>\n",
       "      <td>2994.188239</td>\n",
       "      <td>1890.126270</td>\n",
       "      <td>4927.337239</td>\n",
       "      <td>5385.048180</td>\n",
       "      <td>2319.536252</td>\n",
       "      <td>1521.943637</td>\n",
       "      <td>1293.826140</td>\n",
       "      <td>2437.975909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri779</th>\n",
       "      <td>2766.458882</td>\n",
       "      <td>169.207955</td>\n",
       "      <td>254.220834</td>\n",
       "      <td>2357.865661</td>\n",
       "      <td>2070.051795</td>\n",
       "      <td>8638.329319</td>\n",
       "      <td>921.568698</td>\n",
       "      <td>6357.642769</td>\n",
       "      <td>258.042764</td>\n",
       "      <td>2535.568721</td>\n",
       "      <td>2768.048500</td>\n",
       "      <td>4750.922044</td>\n",
       "      <td>1521.796345</td>\n",
       "      <td>4805.708894</td>\n",
       "      <td>2475.995081</td>\n",
       "      <td>4010.560573</td>\n",
       "      <td>2442.238703</td>\n",
       "      <td>6155.067426</td>\n",
       "      <td>309.268802</td>\n",
       "      <td>4310.139580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri780</th>\n",
       "      <td>3318.389859</td>\n",
       "      <td>4521.403690</td>\n",
       "      <td>2209.031340</td>\n",
       "      <td>1168.414376</td>\n",
       "      <td>1646.438184</td>\n",
       "      <td>4518.513887</td>\n",
       "      <td>1539.082013</td>\n",
       "      <td>2457.480226</td>\n",
       "      <td>1854.247566</td>\n",
       "      <td>4798.221013</td>\n",
       "      <td>5150.004163</td>\n",
       "      <td>4877.891921</td>\n",
       "      <td>2463.586500</td>\n",
       "      <td>4265.530199</td>\n",
       "      <td>9967.211069</td>\n",
       "      <td>5937.764403</td>\n",
       "      <td>3818.379737</td>\n",
       "      <td>4254.809643</td>\n",
       "      <td>1406.563422</td>\n",
       "      <td>1567.109027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri781</th>\n",
       "      <td>2166.200067</td>\n",
       "      <td>2618.547401</td>\n",
       "      <td>1943.968624</td>\n",
       "      <td>3723.972678</td>\n",
       "      <td>5701.735032</td>\n",
       "      <td>4603.053869</td>\n",
       "      <td>3837.779144</td>\n",
       "      <td>6213.238599</td>\n",
       "      <td>1109.216533</td>\n",
       "      <td>2886.795295</td>\n",
       "      <td>3343.142757</td>\n",
       "      <td>2819.349929</td>\n",
       "      <td>3435.038451</td>\n",
       "      <td>2418.785876</td>\n",
       "      <td>3636.622377</td>\n",
       "      <td>3323.130071</td>\n",
       "      <td>2435.475981</td>\n",
       "      <td>4292.748327</td>\n",
       "      <td>4394.921029</td>\n",
       "      <td>6253.286042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri782</th>\n",
       "      <td>4061.651777</td>\n",
       "      <td>4843.316872</td>\n",
       "      <td>2482.546419</td>\n",
       "      <td>5583.087318</td>\n",
       "      <td>3776.654648</td>\n",
       "      <td>4889.167584</td>\n",
       "      <td>91.023169</td>\n",
       "      <td>5144.803793</td>\n",
       "      <td>872.353912</td>\n",
       "      <td>5245.525835</td>\n",
       "      <td>4193.368972</td>\n",
       "      <td>4771.494334</td>\n",
       "      <td>1771.322195</td>\n",
       "      <td>429.060815</td>\n",
       "      <td>4600.581774</td>\n",
       "      <td>3524.216961</td>\n",
       "      <td>2203.234922</td>\n",
       "      <td>3354.132763</td>\n",
       "      <td>2368.453683</td>\n",
       "      <td>1215.275650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri783</th>\n",
       "      <td>4512.227419</td>\n",
       "      <td>5302.798055</td>\n",
       "      <td>2578.994089</td>\n",
       "      <td>5684.708426</td>\n",
       "      <td>1381.963299</td>\n",
       "      <td>3201.360763</td>\n",
       "      <td>2955.110545</td>\n",
       "      <td>2796.015949</td>\n",
       "      <td>801.468903</td>\n",
       "      <td>3482.892508</td>\n",
       "      <td>5290.363098</td>\n",
       "      <td>3598.456412</td>\n",
       "      <td>2796.495510</td>\n",
       "      <td>1784.838728</td>\n",
       "      <td>9772.163046</td>\n",
       "      <td>3328.015043</td>\n",
       "      <td>3131.552793</td>\n",
       "      <td>2842.630050</td>\n",
       "      <td>2030.780214</td>\n",
       "      <td>5674.758932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri784</th>\n",
       "      <td>2540.205777</td>\n",
       "      <td>4304.778987</td>\n",
       "      <td>264.197193</td>\n",
       "      <td>1581.844516</td>\n",
       "      <td>3188.623823</td>\n",
       "      <td>4916.915400</td>\n",
       "      <td>1271.450194</td>\n",
       "      <td>2508.160115</td>\n",
       "      <td>960.773504</td>\n",
       "      <td>4099.163390</td>\n",
       "      <td>5635.382637</td>\n",
       "      <td>3356.074128</td>\n",
       "      <td>7545.226232</td>\n",
       "      <td>3321.584433</td>\n",
       "      <td>4911.424018</td>\n",
       "      <td>5311.235279</td>\n",
       "      <td>1182.473205</td>\n",
       "      <td>1574.729324</td>\n",
       "      <td>1769.274038</td>\n",
       "      <td>4833.789380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri785</th>\n",
       "      <td>3178.225080</td>\n",
       "      <td>2675.996929</td>\n",
       "      <td>2086.933364</td>\n",
       "      <td>1962.469033</td>\n",
       "      <td>3912.100908</td>\n",
       "      <td>2760.507987</td>\n",
       "      <td>3793.263433</td>\n",
       "      <td>3648.752066</td>\n",
       "      <td>398.947275</td>\n",
       "      <td>4893.616568</td>\n",
       "      <td>1483.857764</td>\n",
       "      <td>3616.735482</td>\n",
       "      <td>1998.957711</td>\n",
       "      <td>2276.026674</td>\n",
       "      <td>1227.204617</td>\n",
       "      <td>1307.779651</td>\n",
       "      <td>1424.313033</td>\n",
       "      <td>5475.595613</td>\n",
       "      <td>68.064516</td>\n",
       "      <td>5764.741121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri786</th>\n",
       "      <td>5238.408861</td>\n",
       "      <td>2913.243255</td>\n",
       "      <td>3646.573149</td>\n",
       "      <td>1314.935500</td>\n",
       "      <td>2956.068170</td>\n",
       "      <td>1071.147436</td>\n",
       "      <td>4573.025632</td>\n",
       "      <td>6336.101709</td>\n",
       "      <td>2818.608634</td>\n",
       "      <td>4079.710392</td>\n",
       "      <td>2737.993637</td>\n",
       "      <td>4876.308107</td>\n",
       "      <td>5109.967130</td>\n",
       "      <td>5726.623855</td>\n",
       "      <td>3034.382265</td>\n",
       "      <td>6650.716001</td>\n",
       "      <td>701.892300</td>\n",
       "      <td>2014.426850</td>\n",
       "      <td>474.145463</td>\n",
       "      <td>1808.045100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri787</th>\n",
       "      <td>2128.680509</td>\n",
       "      <td>2615.667125</td>\n",
       "      <td>2985.848542</td>\n",
       "      <td>4934.076919</td>\n",
       "      <td>3415.574392</td>\n",
       "      <td>5916.007327</td>\n",
       "      <td>2115.014262</td>\n",
       "      <td>3506.908774</td>\n",
       "      <td>859.124963</td>\n",
       "      <td>4940.416967</td>\n",
       "      <td>5950.282079</td>\n",
       "      <td>5946.166274</td>\n",
       "      <td>2647.391623</td>\n",
       "      <td>2919.751553</td>\n",
       "      <td>3104.521870</td>\n",
       "      <td>4385.750825</td>\n",
       "      <td>1945.940434</td>\n",
       "      <td>4468.438433</td>\n",
       "      <td>2235.748193</td>\n",
       "      <td>4600.845751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri788</th>\n",
       "      <td>3289.598040</td>\n",
       "      <td>2956.095462</td>\n",
       "      <td>901.943606</td>\n",
       "      <td>1275.708524</td>\n",
       "      <td>2164.302010</td>\n",
       "      <td>2184.235727</td>\n",
       "      <td>1458.000263</td>\n",
       "      <td>4911.060084</td>\n",
       "      <td>1541.282125</td>\n",
       "      <td>174.671708</td>\n",
       "      <td>3404.728624</td>\n",
       "      <td>2039.753417</td>\n",
       "      <td>7661.254945</td>\n",
       "      <td>2544.937856</td>\n",
       "      <td>2894.085134</td>\n",
       "      <td>2097.406197</td>\n",
       "      <td>2449.789623</td>\n",
       "      <td>1448.160036</td>\n",
       "      <td>3401.964887</td>\n",
       "      <td>3665.907181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri789</th>\n",
       "      <td>3318.389859</td>\n",
       "      <td>2046.717222</td>\n",
       "      <td>1458.223500</td>\n",
       "      <td>5202.262902</td>\n",
       "      <td>4848.945756</td>\n",
       "      <td>1880.746647</td>\n",
       "      <td>3848.263144</td>\n",
       "      <td>4417.737087</td>\n",
       "      <td>1593.627485</td>\n",
       "      <td>3482.833496</td>\n",
       "      <td>769.815872</td>\n",
       "      <td>6670.988020</td>\n",
       "      <td>3709.102105</td>\n",
       "      <td>942.520302</td>\n",
       "      <td>5479.051571</td>\n",
       "      <td>7768.737201</td>\n",
       "      <td>2289.417774</td>\n",
       "      <td>2514.644353</td>\n",
       "      <td>2223.532546</td>\n",
       "      <td>7356.801290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri790</th>\n",
       "      <td>3243.676806</td>\n",
       "      <td>1694.553655</td>\n",
       "      <td>2344.315812</td>\n",
       "      <td>2093.984587</td>\n",
       "      <td>23.718172</td>\n",
       "      <td>4036.942422</td>\n",
       "      <td>1265.821139</td>\n",
       "      <td>2851.234205</td>\n",
       "      <td>1440.909358</td>\n",
       "      <td>3306.251916</td>\n",
       "      <td>472.812681</td>\n",
       "      <td>3221.144680</td>\n",
       "      <td>2506.323972</td>\n",
       "      <td>90.638872</td>\n",
       "      <td>4275.492316</td>\n",
       "      <td>3798.466850</td>\n",
       "      <td>2079.536187</td>\n",
       "      <td>2195.845083</td>\n",
       "      <td>5387.471180</td>\n",
       "      <td>4442.336218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri791</th>\n",
       "      <td>4241.495791</td>\n",
       "      <td>5087.653798</td>\n",
       "      <td>2347.414238</td>\n",
       "      <td>4861.520865</td>\n",
       "      <td>1025.562265</td>\n",
       "      <td>4214.275471</td>\n",
       "      <td>2195.825507</td>\n",
       "      <td>3968.874438</td>\n",
       "      <td>2670.125420</td>\n",
       "      <td>3156.023532</td>\n",
       "      <td>2545.030986</td>\n",
       "      <td>2442.954517</td>\n",
       "      <td>1900.092851</td>\n",
       "      <td>2442.454770</td>\n",
       "      <td>6214.298962</td>\n",
       "      <td>4050.510949</td>\n",
       "      <td>2289.417774</td>\n",
       "      <td>2537.442123</td>\n",
       "      <td>1694.565744</td>\n",
       "      <td>3013.597621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri792</th>\n",
       "      <td>4900.900043</td>\n",
       "      <td>3954.822348</td>\n",
       "      <td>2524.760414</td>\n",
       "      <td>2699.453959</td>\n",
       "      <td>1582.150397</td>\n",
       "      <td>4981.495428</td>\n",
       "      <td>2407.897795</td>\n",
       "      <td>2556.285151</td>\n",
       "      <td>154.592033</td>\n",
       "      <td>4978.688022</td>\n",
       "      <td>2561.147596</td>\n",
       "      <td>2858.224862</td>\n",
       "      <td>3494.033013</td>\n",
       "      <td>2528.649277</td>\n",
       "      <td>4620.321971</td>\n",
       "      <td>4335.147502</td>\n",
       "      <td>2334.447255</td>\n",
       "      <td>1097.150962</td>\n",
       "      <td>1473.579019</td>\n",
       "      <td>1407.772727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri793</th>\n",
       "      <td>6936.139635</td>\n",
       "      <td>411.802772</td>\n",
       "      <td>2595.375316</td>\n",
       "      <td>2453.825767</td>\n",
       "      <td>811.040228</td>\n",
       "      <td>5368.058274</td>\n",
       "      <td>965.098473</td>\n",
       "      <td>2850.724747</td>\n",
       "      <td>2684.192440</td>\n",
       "      <td>2513.326074</td>\n",
       "      <td>3618.164732</td>\n",
       "      <td>3276.868665</td>\n",
       "      <td>3180.597515</td>\n",
       "      <td>2632.676571</td>\n",
       "      <td>4177.248934</td>\n",
       "      <td>5353.417143</td>\n",
       "      <td>715.903707</td>\n",
       "      <td>2974.332001</td>\n",
       "      <td>3540.085232</td>\n",
       "      <td>6151.600761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri794</th>\n",
       "      <td>3652.329824</td>\n",
       "      <td>993.739769</td>\n",
       "      <td>1762.244401</td>\n",
       "      <td>2352.389475</td>\n",
       "      <td>264.346041</td>\n",
       "      <td>3680.327512</td>\n",
       "      <td>1303.707425</td>\n",
       "      <td>755.928403</td>\n",
       "      <td>3871.896900</td>\n",
       "      <td>2683.998126</td>\n",
       "      <td>4147.292883</td>\n",
       "      <td>3366.155548</td>\n",
       "      <td>1678.173084</td>\n",
       "      <td>1590.286219</td>\n",
       "      <td>1111.709391</td>\n",
       "      <td>5213.908137</td>\n",
       "      <td>2124.276970</td>\n",
       "      <td>4069.081407</td>\n",
       "      <td>1036.131331</td>\n",
       "      <td>3250.122298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri795</th>\n",
       "      <td>5720.511789</td>\n",
       "      <td>501.683922</td>\n",
       "      <td>2347.414238</td>\n",
       "      <td>1639.001703</td>\n",
       "      <td>2936.390224</td>\n",
       "      <td>7237.432080</td>\n",
       "      <td>2189.760828</td>\n",
       "      <td>3736.202494</td>\n",
       "      <td>402.242045</td>\n",
       "      <td>5595.751166</td>\n",
       "      <td>1987.623617</td>\n",
       "      <td>7542.080044</td>\n",
       "      <td>1492.020524</td>\n",
       "      <td>6880.514189</td>\n",
       "      <td>2142.064144</td>\n",
       "      <td>2234.388631</td>\n",
       "      <td>136.751172</td>\n",
       "      <td>1083.664338</td>\n",
       "      <td>4792.428429</td>\n",
       "      <td>1382.956162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri796</th>\n",
       "      <td>2758.573646</td>\n",
       "      <td>1200.771552</td>\n",
       "      <td>2056.665250</td>\n",
       "      <td>4398.357093</td>\n",
       "      <td>1472.701630</td>\n",
       "      <td>3937.958260</td>\n",
       "      <td>3965.507331</td>\n",
       "      <td>2583.617168</td>\n",
       "      <td>39.055602</td>\n",
       "      <td>6383.009192</td>\n",
       "      <td>2318.258457</td>\n",
       "      <td>542.198202</td>\n",
       "      <td>2288.292780</td>\n",
       "      <td>4285.795246</td>\n",
       "      <td>4474.289141</td>\n",
       "      <td>2870.842825</td>\n",
       "      <td>2925.248404</td>\n",
       "      <td>5155.599839</td>\n",
       "      <td>3694.720953</td>\n",
       "      <td>6008.420714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri797</th>\n",
       "      <td>391.748935</td>\n",
       "      <td>2201.052837</td>\n",
       "      <td>2588.827514</td>\n",
       "      <td>673.316629</td>\n",
       "      <td>2406.120513</td>\n",
       "      <td>3820.982569</td>\n",
       "      <td>2499.304673</td>\n",
       "      <td>7408.190559</td>\n",
       "      <td>142.867085</td>\n",
       "      <td>6556.225167</td>\n",
       "      <td>3987.742202</td>\n",
       "      <td>4242.313725</td>\n",
       "      <td>3207.331648</td>\n",
       "      <td>2747.464767</td>\n",
       "      <td>4554.053595</td>\n",
       "      <td>3960.482559</td>\n",
       "      <td>832.471194</td>\n",
       "      <td>5070.439599</td>\n",
       "      <td>1719.917882</td>\n",
       "      <td>2426.063597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri798</th>\n",
       "      <td>3512.765929</td>\n",
       "      <td>1499.012107</td>\n",
       "      <td>3825.258417</td>\n",
       "      <td>4856.997083</td>\n",
       "      <td>1995.831984</td>\n",
       "      <td>3384.769551</td>\n",
       "      <td>15.529804</td>\n",
       "      <td>2587.426839</td>\n",
       "      <td>1123.376025</td>\n",
       "      <td>8621.009037</td>\n",
       "      <td>2499.401219</td>\n",
       "      <td>2610.540313</td>\n",
       "      <td>2374.118832</td>\n",
       "      <td>5634.330496</td>\n",
       "      <td>4158.168942</td>\n",
       "      <td>6531.309088</td>\n",
       "      <td>4796.284042</td>\n",
       "      <td>684.373971</td>\n",
       "      <td>362.226794</td>\n",
       "      <td>2180.553914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tri799</th>\n",
       "      <td>3899.095343</td>\n",
       "      <td>289.417464</td>\n",
       "      <td>660.403372</td>\n",
       "      <td>3381.583696</td>\n",
       "      <td>2974.408302</td>\n",
       "      <td>3617.110168</td>\n",
       "      <td>5387.409598</td>\n",
       "      <td>1604.109933</td>\n",
       "      <td>546.043986</td>\n",
       "      <td>1696.865757</td>\n",
       "      <td>1775.251366</td>\n",
       "      <td>507.863181</td>\n",
       "      <td>2572.222337</td>\n",
       "      <td>2800.938048</td>\n",
       "      <td>10366.926894</td>\n",
       "      <td>5457.655852</td>\n",
       "      <td>3485.996834</td>\n",
       "      <td>2704.862279</td>\n",
       "      <td>2044.366784</td>\n",
       "      <td>5363.982290</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>800 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Sub0         Sub1         Sub2         Sub3         Sub4  \\\n",
       "Tri0    2797.224240  1039.571212  4045.345952  3530.934210  2410.276348   \n",
       "Tri1     786.895089  3076.223066  1033.310418  3758.043454  4000.805778   \n",
       "Tri2    3516.902396  4632.818016  4874.066155  3031.377402  2485.677228   \n",
       "Tri3     333.881830   104.448476  2304.093856   586.098266  4575.178155   \n",
       "Tri4    6790.330061  2629.751046  3148.222058  1894.867975  2274.057485   \n",
       "Tri5    3047.828258   397.038302   114.215641  4089.899601  4049.434462   \n",
       "Tri6    2176.597045  3552.355757  1973.393087  4362.043226  5170.251441   \n",
       "Tri7    3318.389859  3250.115237  1378.417119  5991.874045   143.606176   \n",
       "Tri8    3290.277151  2180.419440  1069.322671  5277.547086  2287.661406   \n",
       "Tri9    1881.581897  1168.334372  2808.512816  2198.630268  1688.488219   \n",
       "Tri10   3646.313933  1625.659863  3206.440179  1194.569715  1939.383734   \n",
       "Tri11   3931.516192   192.566645  1403.470198  3397.295729  4681.754010   \n",
       "Tri12   4308.815582  1591.300260  2347.414238  4046.082575  2555.540064   \n",
       "Tri13   2004.232508  1972.600035  2536.188940  1908.891889  4091.166301   \n",
       "Tri14   6017.817486   644.955912  1987.820582  2354.542490  1388.969163   \n",
       "Tri15   2601.305283  3594.655184  2371.459375  3938.344443  2853.166655   \n",
       "Tri16   3999.043797  2071.515703  3385.070117  3601.361161  6218.904091   \n",
       "Tri17   1372.419652  1848.213972  4248.673137  3914.271056  3890.512470   \n",
       "Tri18   3650.763986  2418.379541  2728.329610  2176.302848  3461.945292   \n",
       "Tri19   4590.144644  2738.871921   271.504916   438.603787  1240.028763   \n",
       "Tri20   1789.110026  2564.281719  2561.038387  3934.218428  2489.637962   \n",
       "Tri21   2350.865209  3983.865823  1377.567893  3372.263683  2489.637962   \n",
       "Tri22   6952.390799  2063.316230  1535.851635  2888.308373  2489.637962   \n",
       "Tri23   3981.190750  3247.512882  3721.031070  2099.836777  2489.637962   \n",
       "Tri24   1018.919604  2192.488372  2749.424948  2821.333287  1414.676045   \n",
       "Tri25   2315.087241  2201.058303   719.014381   737.305297  4660.901242   \n",
       "Tri26   3425.943052  2960.328053  2058.422909  2792.324988  2366.328681   \n",
       "Tri27   3343.105868  3245.563710  4974.583632    23.429444  4954.807144   \n",
       "Tri28   2170.474769  3573.187792  2347.414238  4277.443964  1570.902741   \n",
       "Tri29   3201.988624   878.496721  1157.160637  6449.023514  2686.624157   \n",
       "...             ...          ...          ...          ...          ...   \n",
       "Tri770  5019.916501  4064.509064  1367.441537  3372.263683   338.933307   \n",
       "Tri771  1067.207049  1824.416712  4162.917234  4704.614259  2765.201984   \n",
       "Tri772  3397.691127  4499.183734  4694.741869  3151.216275  4963.785263   \n",
       "Tri773  4656.609071  3744.545650  2766.966958  3974.311001  3162.852076   \n",
       "Tri774  2418.176006  1269.214989   429.276661  4838.812325  2270.762832   \n",
       "Tri775  4193.896082   717.222895  4798.294129  3759.457306   478.139010   \n",
       "Tri776  3867.848234  1067.792534  1234.102840   654.158484  3203.563016   \n",
       "Tri777    98.144376  2967.010519  2830.656654  2309.465464  2162.254722   \n",
       "Tri778  3297.471584   951.434209  2841.784763   478.314962  3524.684787   \n",
       "Tri779  2766.458882   169.207955   254.220834  2357.865661  2070.051795   \n",
       "Tri780  3318.389859  4521.403690  2209.031340  1168.414376  1646.438184   \n",
       "Tri781  2166.200067  2618.547401  1943.968624  3723.972678  5701.735032   \n",
       "Tri782  4061.651777  4843.316872  2482.546419  5583.087318  3776.654648   \n",
       "Tri783  4512.227419  5302.798055  2578.994089  5684.708426  1381.963299   \n",
       "Tri784  2540.205777  4304.778987   264.197193  1581.844516  3188.623823   \n",
       "Tri785  3178.225080  2675.996929  2086.933364  1962.469033  3912.100908   \n",
       "Tri786  5238.408861  2913.243255  3646.573149  1314.935500  2956.068170   \n",
       "Tri787  2128.680509  2615.667125  2985.848542  4934.076919  3415.574392   \n",
       "Tri788  3289.598040  2956.095462   901.943606  1275.708524  2164.302010   \n",
       "Tri789  3318.389859  2046.717222  1458.223500  5202.262902  4848.945756   \n",
       "Tri790  3243.676806  1694.553655  2344.315812  2093.984587    23.718172   \n",
       "Tri791  4241.495791  5087.653798  2347.414238  4861.520865  1025.562265   \n",
       "Tri792  4900.900043  3954.822348  2524.760414  2699.453959  1582.150397   \n",
       "Tri793  6936.139635   411.802772  2595.375316  2453.825767   811.040228   \n",
       "Tri794  3652.329824   993.739769  1762.244401  2352.389475   264.346041   \n",
       "Tri795  5720.511789   501.683922  2347.414238  1639.001703  2936.390224   \n",
       "Tri796  2758.573646  1200.771552  2056.665250  4398.357093  1472.701630   \n",
       "Tri797   391.748935  2201.052837  2588.827514   673.316629  2406.120513   \n",
       "Tri798  3512.765929  1499.012107  3825.258417  4856.997083  1995.831984   \n",
       "Tri799  3899.095343   289.417464   660.403372  3381.583696  2974.408302   \n",
       "\n",
       "               Sub5         Sub6         Sub7         Sub8         Sub9  \\\n",
       "Tri0    6541.494156  1977.919842  2343.555594   143.695964  8147.939691   \n",
       "Tri1    2756.802996  2918.768116  2613.934992  2655.684434  7410.337807   \n",
       "Tri2    4929.841314   435.950399  3059.241733  2923.325600  3530.389021   \n",
       "Tri3    2365.682721  1285.101296  5050.566343  2446.870606  5096.855057   \n",
       "Tri4    8186.457041  1195.253881  3747.385847  1456.694541  3437.159878   \n",
       "Tri5    4025.464731  2638.680380  1885.518602   307.874145  1883.111558   \n",
       "Tri6    6009.945843   724.758133  3600.654491   501.585571  3658.042950   \n",
       "Tri7    6485.648064   543.664039  2136.843938  1224.511880  6117.384527   \n",
       "Tri8    5077.853063  2893.314803  4536.102482  2106.468811  1775.207528   \n",
       "Tri9    2049.245976  1336.294530  4475.980197   341.613792  1397.717855   \n",
       "Tri10   1879.157591  4970.830739  4134.752286  1298.460972  1956.628409   \n",
       "Tri11   6591.613394  2980.007209  2485.156212   522.050951  4378.778873   \n",
       "Tri12   5113.426538  2593.246610  4443.971194  2563.882354  5391.326624   \n",
       "Tri13   1679.608773  2415.209075  4023.633503  1786.137313  3038.511977   \n",
       "Tri14   2372.667094   479.298797  1233.238617  3057.372752  3146.273531   \n",
       "Tri15   4711.309827  3898.284833  3572.704270  1310.699188  4263.843023   \n",
       "Tri16   4637.388191  3305.677185  4283.664183   692.242028  2030.449406   \n",
       "Tri17   3076.043021  1293.978527  6441.018287  1816.063502  2344.698770   \n",
       "Tri18   6076.972257  2195.460676  5416.264595  1369.246142  5103.076196   \n",
       "Tri19   3096.072433  2370.345165  4593.902987  3272.597687  4735.979486   \n",
       "Tri20   4041.204419  2452.776553  2294.776565  1931.331379  7175.587179   \n",
       "Tri21    769.143341  2415.209075  7018.641416  1765.476153  3308.479365   \n",
       "Tri22   5570.172691  3200.852884  5913.022804   427.591714  3944.805607   \n",
       "Tri23   6456.138963  2025.538783  2661.638491  1088.332466  6264.921509   \n",
       "Tri24   4442.560508  3913.692260  5384.410278    32.019499  4496.280231   \n",
       "Tri25   3314.228722  1319.019511  2356.782408  1474.041409  1173.689771   \n",
       "Tri26   5725.728257  1011.737895  2399.555806  2611.716052  5671.847403   \n",
       "Tri27   2755.752430  1775.584328  5829.767282  2597.394722  6390.433703   \n",
       "Tri28   5864.062179  1338.712402  2062.441171  1444.139181  4584.654047   \n",
       "Tri29   4180.357765   213.195206  3046.308331  2865.075881  2478.623834   \n",
       "...             ...          ...          ...          ...          ...   \n",
       "Tri770  5673.397942   201.555076   951.357610  1083.986038  5877.593687   \n",
       "Tri771  6165.689173  3685.599231   989.469420   968.723980  4575.109982   \n",
       "Tri772  1619.179021  3265.231143  1790.337031  2243.599203  2481.871935   \n",
       "Tri773  8407.932097  2415.209075  2578.515791  1468.488071  3813.408616   \n",
       "Tri774  4255.242571   504.107442  1331.564119   234.181038  6640.959184   \n",
       "Tri775  6411.768042  4490.491911  2009.480471  1942.847743  6595.750322   \n",
       "Tri776  3217.279066  2788.954247  3148.277638   518.757154  2951.581858   \n",
       "Tri777  8827.325748  2478.898257  2860.291126  1468.474202  5147.091903   \n",
       "Tri778  6830.768774   620.907696  1336.452789   806.585847  3646.037162   \n",
       "Tri779  8638.329319   921.568698  6357.642769   258.042764  2535.568721   \n",
       "Tri780  4518.513887  1539.082013  2457.480226  1854.247566  4798.221013   \n",
       "Tri781  4603.053869  3837.779144  6213.238599  1109.216533  2886.795295   \n",
       "Tri782  4889.167584    91.023169  5144.803793   872.353912  5245.525835   \n",
       "Tri783  3201.360763  2955.110545  2796.015949   801.468903  3482.892508   \n",
       "Tri784  4916.915400  1271.450194  2508.160115   960.773504  4099.163390   \n",
       "Tri785  2760.507987  3793.263433  3648.752066   398.947275  4893.616568   \n",
       "Tri786  1071.147436  4573.025632  6336.101709  2818.608634  4079.710392   \n",
       "Tri787  5916.007327  2115.014262  3506.908774   859.124963  4940.416967   \n",
       "Tri788  2184.235727  1458.000263  4911.060084  1541.282125   174.671708   \n",
       "Tri789  1880.746647  3848.263144  4417.737087  1593.627485  3482.833496   \n",
       "Tri790  4036.942422  1265.821139  2851.234205  1440.909358  3306.251916   \n",
       "Tri791  4214.275471  2195.825507  3968.874438  2670.125420  3156.023532   \n",
       "Tri792  4981.495428  2407.897795  2556.285151   154.592033  4978.688022   \n",
       "Tri793  5368.058274   965.098473  2850.724747  2684.192440  2513.326074   \n",
       "Tri794  3680.327512  1303.707425   755.928403  3871.896900  2683.998126   \n",
       "Tri795  7237.432080  2189.760828  3736.202494   402.242045  5595.751166   \n",
       "Tri796  3937.958260  3965.507331  2583.617168    39.055602  6383.009192   \n",
       "Tri797  3820.982569  2499.304673  7408.190559   142.867085  6556.225167   \n",
       "Tri798  3384.769551    15.529804  2587.426839  1123.376025  8621.009037   \n",
       "Tri799  3617.110168  5387.409598  1604.109933   546.043986  1696.865757   \n",
       "\n",
       "              Sub10         Sub11        Sub12        Sub13         Sub14  \\\n",
       "Tri0    5183.942423   4548.240971  2076.921296  4230.548795   4134.589984   \n",
       "Tri1    3182.903975   4324.103096  1843.506277  1338.453235   2693.772203   \n",
       "Tri2    3002.555229   7537.781867  1989.249165  4513.510928   4473.733040   \n",
       "Tri3    1047.603006   5431.187785  2879.554454   311.319060   2814.385809   \n",
       "Tri4    6745.578676   4101.871682  1944.773775  1571.942134   3186.806328   \n",
       "Tri5    4216.585496   3179.854036  2370.740080  1178.494818   2048.812602   \n",
       "Tri6    1796.353749   2115.447625  2434.767571  2890.637333   1354.310794   \n",
       "Tri7    2269.914529   5853.215276  1970.536378  2433.792597   2363.395834   \n",
       "Tri8    3120.339818   2296.467312  3544.422187  4943.839493   2156.873736   \n",
       "Tri9    5802.017010   1227.185074  2183.988202   266.188603   5280.917742   \n",
       "Tri10   2732.487735   9493.147896  2475.476740   738.715809   2294.571907   \n",
       "Tri11   3018.287764   2650.184176    14.216346  3716.312716   6855.044510   \n",
       "Tri12    292.409469   4356.282690   579.064560  3869.193105   4032.326761   \n",
       "Tri13   3821.388413   3700.112011  2047.432799  3722.822930   3277.862188   \n",
       "Tri14   3317.870108   5154.616079  3210.443053  2303.223106   8024.009754   \n",
       "Tri15   1057.886020   2406.319185  2624.236741  4550.713883   3741.835217   \n",
       "Tri16   3598.057871   1374.546938  1480.611011  3241.384679   6352.487413   \n",
       "Tri17   1640.920209   5323.168630  3648.912380  2760.721103   7033.016570   \n",
       "Tri18   2892.060496   3892.435508  1295.714144    20.223690   3690.530028   \n",
       "Tri19   5122.880850   5917.462942  4162.275122  1684.470084   6845.328218   \n",
       "Tri20   3183.754138   3513.924554   905.013956   354.741832   3134.348455   \n",
       "Tri21   6039.588712   5881.403433  1107.831738  2119.146723   8965.077468   \n",
       "Tri22   2765.051691   4495.600498  3512.207504   105.080751   5065.155604   \n",
       "Tri23   2461.335394   6783.466281  3711.174364  1367.747318   2005.241990   \n",
       "Tri24   1248.691549  10061.049263  1844.528675    70.768552   2701.317234   \n",
       "Tri25   6404.474740   2472.570804  4559.196652  3857.026459    259.467407   \n",
       "Tri26   4001.436040   4696.457379  1134.304194  1819.079808   6214.829225   \n",
       "Tri27   2748.032360   6592.437245  2420.918590  2744.339671   5943.495369   \n",
       "Tri28   4684.956953   5955.686112  3997.029107   765.461186   5388.946834   \n",
       "Tri29   5169.539096   4025.666201  2542.109754  4541.154907   2248.276335   \n",
       "...             ...           ...          ...          ...           ...   \n",
       "Tri770  3119.652408   2362.919913  6689.664963  2072.202080   2514.064633   \n",
       "Tri771  3317.870108   3260.280990  3127.255327  3225.607562   7179.086423   \n",
       "Tri772   271.979249   4683.880827  1833.226420  1614.501208   3468.347864   \n",
       "Tri773  4232.841624   4911.570825  1306.936657   788.957415   5232.178707   \n",
       "Tri774  3317.870108   3765.241232  1785.795915  4049.183809   2139.079636   \n",
       "Tri775  2993.944692   9133.851062  1543.894241  2566.416763   2707.591795   \n",
       "Tri776  4466.085911   3913.510325  1199.334758  1727.319198   4205.028277   \n",
       "Tri777  4142.964627   3251.302244  1583.446266  1697.757692   4261.867278   \n",
       "Tri778  3950.351432   3485.024897  2994.188239  1890.126270   4927.337239   \n",
       "Tri779  2768.048500   4750.922044  1521.796345  4805.708894   2475.995081   \n",
       "Tri780  5150.004163   4877.891921  2463.586500  4265.530199   9967.211069   \n",
       "Tri781  3343.142757   2819.349929  3435.038451  2418.785876   3636.622377   \n",
       "Tri782  4193.368972   4771.494334  1771.322195   429.060815   4600.581774   \n",
       "Tri783  5290.363098   3598.456412  2796.495510  1784.838728   9772.163046   \n",
       "Tri784  5635.382637   3356.074128  7545.226232  3321.584433   4911.424018   \n",
       "Tri785  1483.857764   3616.735482  1998.957711  2276.026674   1227.204617   \n",
       "Tri786  2737.993637   4876.308107  5109.967130  5726.623855   3034.382265   \n",
       "Tri787  5950.282079   5946.166274  2647.391623  2919.751553   3104.521870   \n",
       "Tri788  3404.728624   2039.753417  7661.254945  2544.937856   2894.085134   \n",
       "Tri789   769.815872   6670.988020  3709.102105   942.520302   5479.051571   \n",
       "Tri790   472.812681   3221.144680  2506.323972    90.638872   4275.492316   \n",
       "Tri791  2545.030986   2442.954517  1900.092851  2442.454770   6214.298962   \n",
       "Tri792  2561.147596   2858.224862  3494.033013  2528.649277   4620.321971   \n",
       "Tri793  3618.164732   3276.868665  3180.597515  2632.676571   4177.248934   \n",
       "Tri794  4147.292883   3366.155548  1678.173084  1590.286219   1111.709391   \n",
       "Tri795  1987.623617   7542.080044  1492.020524  6880.514189   2142.064144   \n",
       "Tri796  2318.258457    542.198202  2288.292780  4285.795246   4474.289141   \n",
       "Tri797  3987.742202   4242.313725  3207.331648  2747.464767   4554.053595   \n",
       "Tri798  2499.401219   2610.540313  2374.118832  5634.330496   4158.168942   \n",
       "Tri799  1775.251366    507.863181  2572.222337  2800.938048  10366.926894   \n",
       "\n",
       "              Sub15        Sub16        Sub17        Sub18        Sub19  \n",
       "Tri0    2067.132295  4087.049471  2704.327437  2790.476384  5141.106292  \n",
       "Tri1    7239.094853  1320.715043  4449.372349  1085.884483  3556.231671  \n",
       "Tri2    7422.364759  3338.164717  4840.676786  2721.343095  1972.689272  \n",
       "Tri3    3396.500194  1324.780081  1518.991979  1676.395223  2051.924695  \n",
       "Tri4    6588.562378  2866.277989  2079.880840  1086.063139  7051.740732  \n",
       "Tri5    5268.016210  3215.274112  1073.497581    68.184823  4022.043321  \n",
       "Tri6    2957.510350  1447.567916  2020.893616  3598.657711  1439.384910  \n",
       "Tri7    1330.207606  2289.417774  3009.042214   256.578248  2584.729650  \n",
       "Tri8    4923.989022  1152.021083  2550.905619  1914.428198  3390.908581  \n",
       "Tri9    4852.981861  2825.540327  2645.230368   233.150604  4912.713861  \n",
       "Tri10   1304.651870  3412.442107  2469.096865  2715.130258  4059.136955  \n",
       "Tri11   1247.417970  1424.223869  3058.837397  4825.153445  1377.779459  \n",
       "Tri12   3886.207190    37.948280  2477.456413  7079.723259  2880.058505  \n",
       "Tri13   3697.007382  4759.422285  1278.100407  1124.765465  6248.230659  \n",
       "Tri14   1431.502336  2805.812304   209.452649    29.286915  5605.288288  \n",
       "Tri15   1844.605678  2289.417774  1632.182450  1717.001177  4712.964280  \n",
       "Tri16   4769.807630   345.901126  4162.285050  3181.815704  1458.025873  \n",
       "Tri17   5071.046489  2946.679451   293.872467  2713.797467  2096.062075  \n",
       "Tri18   1439.286201  3331.125830  1405.362358   674.766149  2690.896212  \n",
       "Tri19   6875.100886  4941.876044   194.371185  1230.682272  2914.678469  \n",
       "Tri20   5414.503988  1859.883386  1044.368043  2518.770276  3580.021139  \n",
       "Tri21   3400.401330  1074.646940  1467.227139   385.817210  4313.807516  \n",
       "Tri22   2852.460376  4284.974905  2193.340876  3922.917090  6555.267030  \n",
       "Tri23   3895.996977  2927.525147   567.936693  1042.124277  3309.478267  \n",
       "Tri24   1849.193271  1006.852834  2177.662910  2369.823241  5870.730322  \n",
       "Tri25   3718.624366  2832.405129  3471.125966   641.862063  6200.306855  \n",
       "Tri26   6221.959882   587.611647  1666.117688  2720.337090  4027.341897  \n",
       "Tri27   7500.719769  2714.634138  7112.070673  5129.402693  4819.212577  \n",
       "Tri28   4428.598436  1248.906561  1018.562576  3137.521116  6439.059402  \n",
       "Tri29   1793.347533  2628.103511  2009.567507  2917.641000  4727.321301  \n",
       "...             ...          ...          ...          ...          ...  \n",
       "Tri770  5782.253033  4552.410543   599.925866  6530.951552  4476.679376  \n",
       "Tri771  3611.052917  1488.165287  1476.624888  2159.477844  4498.994106  \n",
       "Tri772  4385.750825  1874.198809   253.650458  2037.577829  1747.981551  \n",
       "Tri773  7744.999475  2431.965152  1124.090837  4099.034461  1799.347268  \n",
       "Tri774  4870.585618  2632.308370  3795.825698  2065.665001  3533.836049  \n",
       "Tri775  6623.910297  2296.817615  2326.063114  2347.697164  6363.048613  \n",
       "Tri776  1562.338556  1253.087894   410.695565  3501.688532     2.748561  \n",
       "Tri777  2202.733356  1664.096491  2378.824201  4098.729006  5782.275558  \n",
       "Tri778  5385.048180  2319.536252  1521.943637  1293.826140  2437.975909  \n",
       "Tri779  4010.560573  2442.238703  6155.067426   309.268802  4310.139580  \n",
       "Tri780  5937.764403  3818.379737  4254.809643  1406.563422  1567.109027  \n",
       "Tri781  3323.130071  2435.475981  4292.748327  4394.921029  6253.286042  \n",
       "Tri782  3524.216961  2203.234922  3354.132763  2368.453683  1215.275650  \n",
       "Tri783  3328.015043  3131.552793  2842.630050  2030.780214  5674.758932  \n",
       "Tri784  5311.235279  1182.473205  1574.729324  1769.274038  4833.789380  \n",
       "Tri785  1307.779651  1424.313033  5475.595613    68.064516  5764.741121  \n",
       "Tri786  6650.716001   701.892300  2014.426850   474.145463  1808.045100  \n",
       "Tri787  4385.750825  1945.940434  4468.438433  2235.748193  4600.845751  \n",
       "Tri788  2097.406197  2449.789623  1448.160036  3401.964887  3665.907181  \n",
       "Tri789  7768.737201  2289.417774  2514.644353  2223.532546  7356.801290  \n",
       "Tri790  3798.466850  2079.536187  2195.845083  5387.471180  4442.336218  \n",
       "Tri791  4050.510949  2289.417774  2537.442123  1694.565744  3013.597621  \n",
       "Tri792  4335.147502  2334.447255  1097.150962  1473.579019  1407.772727  \n",
       "Tri793  5353.417143   715.903707  2974.332001  3540.085232  6151.600761  \n",
       "Tri794  5213.908137  2124.276970  4069.081407  1036.131331  3250.122298  \n",
       "Tri795  2234.388631   136.751172  1083.664338  4792.428429  1382.956162  \n",
       "Tri796  2870.842825  2925.248404  5155.599839  3694.720953  6008.420714  \n",
       "Tri797  3960.482559   832.471194  5070.439599  1719.917882  2426.063597  \n",
       "Tri798  6531.309088  4796.284042   684.373971   362.226794  2180.553914  \n",
       "Tri799  5457.655852  3485.996834  2704.862279  2044.366784  5363.982290  \n",
       "\n",
       "[800 rows x 20 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mean = df.copy()\n",
    "for i in df_mean.keys():\n",
    "    this_data = df_mean[i].values\n",
    "    max_value = np.mean(this_data) + 2*np.std(this_data)\n",
    "    outliers = this_data>max_value\n",
    "    df_mean[i][outliers] = np.nan\n",
    "\n",
    "df_mean.fillna(df_mean.mean())\n",
    "    \n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Use the Pandas.DataFrame.Sample function to generate bootstrapped confidence intervals for the data from subject 11\n",
    "\n",
    "[see this page for Samples](https://pandas.pydata.org/pandas-docs/version/0.22/generated/pandas.DataFrame.sample.html)\n",
    "\n",
    "\n",
    "* Resample Sub11's data with replacement, each time pulling N samples (800 in this case)\n",
    "* Generate a distribution of means across all resamples\n",
    "* Compute 95% confidence intervals using:\n",
    "\n",
    "[this page for quantiles](https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.quantile.html)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Tri432     3261.491907\n",
       "Tri478      624.435401\n",
       "Tri708     2749.702124\n",
       "Tri44      7521.241769\n",
       "Tri64      5049.035121\n",
       "Tri99      8310.847049\n",
       "Tri462     4484.110330\n",
       "Tri551     6834.921042\n",
       "Tri490     2274.631958\n",
       "Tri629     7891.002736\n",
       "Tri222     5279.919566\n",
       "Tri372     5396.615612\n",
       "Tri39      2003.214471\n",
       "Tri315     3199.712198\n",
       "Tri722     7332.517016\n",
       "Tri514     2644.523670\n",
       "Tri185     6001.104305\n",
       "Tri785     3616.735482\n",
       "Tri269     3840.846048\n",
       "Tri384     3116.421779\n",
       "Tri600     4248.324839\n",
       "Tri667     3055.122131\n",
       "Tri506     4388.417868\n",
       "Tri484     4970.217590\n",
       "Tri488     5428.749745\n",
       "Tri728     2325.644500\n",
       "Tri47      8252.665460\n",
       "Tri766     2954.784503\n",
       "Tri379     6622.926860\n",
       "Tri760     2437.590662\n",
       "              ...     \n",
       "Tri252     4992.989864\n",
       "Tri684     5610.236256\n",
       "Tri766     2954.784503\n",
       "Tri456    56789.000000\n",
       "Tri413     1132.339534\n",
       "Tri111     8133.622020\n",
       "Tri529     5670.389103\n",
       "Tri37      2215.308021\n",
       "Tri106     4900.473304\n",
       "Tri639     2980.960423\n",
       "Tri330     5970.612746\n",
       "Tri507     4463.331946\n",
       "Tri388     4930.310449\n",
       "Tri655     5535.019080\n",
       "Tri554     5522.205562\n",
       "Tri514     2644.523670\n",
       "Tri573     3947.258674\n",
       "Tri159     2431.490016\n",
       "Tri580     4655.464680\n",
       "Tri669     1403.176956\n",
       "Tri167     3230.389800\n",
       "Tri4       4101.871682\n",
       "Tri248     5835.897376\n",
       "Tri334     5084.285747\n",
       "Tri479     2089.933458\n",
       "Tri107     2025.910115\n",
       "Tri679     2805.446437\n",
       "Tri287     6337.104771\n",
       "Tri752     2863.163590\n",
       "Tri478      624.435401\n",
       "Name: Sub11, Length: 800, dtype: float64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_subj11 = pd.DataFrame(df, copy=True)\n",
    "df_subj11.Sub11.sample(frac=1, replace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.025    1282.256102\n",
       "0.975    8563.953179\n",
       "Name: Sub11, dtype: float64"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "N = 800\n",
    "subj11 = df_subj11.Sub11\n",
    "num_bootstraps = 50\n",
    "resample_mean = np.zeros(num_bootstraps)\n",
    "boot_mean = np.zeros(num_bootstraps)\n",
    "\n",
    "for i in np.arange(num_bootstraps):\n",
    "#     subj11.sample(frac=1, replace=True)\n",
    "#     resample_mean[i] = np.mean(subj11)\n",
    "    boot_data = subj11[np.random.randint(N, size=N)]\n",
    "    boot_mean[i] = np.mean(boot_data, axis = 0)\n",
    "    \n",
    "CIs = boot_data.quantile([.025, .975])    \n",
    "CIs\n",
    "#print(boot_mean)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}