Make_test_table.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "in_df = pandas.read_csv('/Users/jakevogel/Science/TADPOLE/KNN_50_cleaned.csv',index_col=0)\n",
    "ref_df = pandas.read_csv('/Users/jakevogel/Science/TADPOLE/KNN_50_cleaned_ref.csv',index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'tref' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-4-2d7b4f93194b>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mtref\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m: name 'tref' is not defined"
     ]
    }
   ],
   "source": [
    "tref.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "rid = 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['RID', 'PTID', 'VISCODE', 'SITE', 'D1', 'D2', 'COLPROT', 'ORIGPROT',\n",
       "       'EXAMDATE', 'DX_bl', 'y_DX', 'y_ADAS11', 'y_ADAS13', 'ventr_ICV_ratio'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ref_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def create_test_table(in_df, ref_df, rids, mode = 'train'):\n",
    "    '''\n",
    "    If mode is set to train:\n",
    "    \n",
    "    Given the output dataframes from the previous functions, and a list of RIDs, \n",
    "    this function will create a \"to-predict\" dataframe for each subject. For each \n",
    "    subject time point, this dataframe will several identical rows of all X \n",
    "    variables and y variables for that subject and timepoint, but with a field \n",
    "    called \"delta_t\" changing so as to reflect the distance (in months) between \n",
    "    this time point and every *SUBSEQUENT* (not previous) timepoint. In addition.\n",
    "    the row will have the \"y\" variables for the timepoint that the delta_t is \n",
    "    referring to. So, in other words, each timepoint will have a row for every\n",
    "    subsequent timepoint, complete with a variable noting the time-distance between\n",
    "    the two timepoints, and the y of that timepoint\n",
    "    \n",
    "    This means that, for a given subject, the shape of the output dataframe will be\n",
    "    (N_timepoints * (N_timepoints+1)/2).\n",
    "    \n",
    "    The function will then append all subject dataframes together and return this\n",
    "    large dataframe. \n",
    "    \n",
    "    If mode is set to test:\n",
    "    \n",
    "    Given the output dataframes from the previous functions, and a list of RIDs,\n",
    "    this function will create a \"testing\" dataframe for each subject. For each \n",
    "    subject time point, the dataframe will have a single row containing all X and\n",
    "    Y variables for that subject-specific timepoint, as well as new variable\n",
    "    \"months_to_final_timepoint\" which represent the amount of time betweeb this\n",
    "    timepoint and the subject's final timepoint. Note that the subject's final\n",
    "    timepoint will be removed.\n",
    "    \n",
    "    in_df = *_cleaned.csv from the previous function, as a pandas DataFrame\n",
    "    ref_df = *_cleaned_ref.csv from the previous function, as a pandas DataFrame\n",
    "    rid = a list or array of RIDs\n",
    "    '''\n",
    "    \n",
    "    if mode not in ['train','test']:\n",
    "        raise IOError('mode must be set to \"train\" or \"test\"')\n",
    "    \n",
    "    print('Making %sing table'%mode)\n",
    "    \n",
    "    if mode == 'train':\n",
    "        \n",
    "        catch = []\n",
    "        for rid in rids:\n",
    "            # create subject-specific inputs\n",
    "            gind = ref_df[ref_df.RID==rid].index\n",
    "            x_tbl = in_df.loc[gind].sort_values('Month_bl',ascending=True)\n",
    "            y_tbl = ref_df.loc[x_tbl.index]\n",
    "            # create empty output dataframe for subject\n",
    "            N_timepoints = len(x_tbl) - 1\n",
    "            N_rows = round((N_timepoints * (N_timepoints+1)/2))\n",
    "            ycols = [x for x in y_tbl.columns if 'y_' in x]\n",
    "            fys = ['future_%s'%x for x in ycols]\n",
    "            cols = ['RID'] + x_tbl.columns.tolist() + ycols + ['delta_t'] + fys\n",
    "            final_output = pandas.DataFrame(index=range(N_rows), columns = cols)\n",
    "            # populate dataframe using a convoluted while loop\n",
    "            time_vec = x_tbl['Month'].values\n",
    "            cntr = 0\n",
    "            cumul = 0\n",
    "            while cntr < N_timepoints:\n",
    "                jnk = pandas.concat([x_tbl.loc[x_tbl.index[cntr]],\n",
    "                                     y_tbl.loc[y_tbl.index[cntr]][['RID']+ycols]])\n",
    "                row = jnk[cols[:-1]]\n",
    "                iTime = row['Month']\n",
    "                dTs = [x - iTime for x in time_vec[(cntr+1):]]\n",
    "                for i in range(len(dTs)):\n",
    "                    final_output.loc[final_output.index[cumul+i],:] = row\n",
    "                    final_output.loc[final_output.index[cumul+i],'delta_t'] = dTs[i]\n",
    "                    final_output.loc[final_output.index[cumul+i],fys\n",
    "                                    ] = y_tbl.loc[y_tbl.index[cntr+(i+1)]][ycols].values\n",
    "                    \n",
    "                \n",
    "                cumul += len(dTs)\n",
    "                cntr += 1\n",
    "            catch.append(final_output)\n",
    "\n",
    "    elif mode == 'test': \n",
    "        catch = []\n",
    "\n",
    "        for rid in rids:\n",
    "            # create subject-specific inputs\n",
    "            gind = ref_df[ref_df.RID==rid].index\n",
    "            x_tbl = in_df.loc[gind].sort_values('Month_bl',ascending=True)\n",
    "            y_tbl = ref_df.loc[x_tbl.index]\n",
    "            ycols = [x for x in y_tbl.columns if 'y_' in x]\n",
    "            cols = ['RID'] + x_tbl.columns.tolist() + ycols + ['months_to_final_timepoint']\n",
    "            # create output dataframe\n",
    "            outdf = pandas.concat([x_tbl,y_tbl[['RID']+ycols]],axis=1)\n",
    "            outdf = outdf.reindex(columns=cols)\n",
    "            # calculate time to final timepoint\n",
    "            fTime = x_tbl.loc[x_tbl.index[-1],'Month']\n",
    "            deltaT = [fTime - x for x in x_tbl['Month']]\n",
    "            outdf.loc[:,'months_to_final_timepoint'] = deltaT\n",
    "            # drop final timepoint\n",
    "            outdf.drop(outdf.index[-1],axis=0,inplace=True)\n",
    "            \n",
    "            catch.append(outdf)\n",
    "            \n",
    "    # combine subject specific dfs in to a single df \n",
    "    big_final_df = pandas.concat(catch)\n",
    "\n",
    "    return big_final_df\n",
    "    \n",
    "    \n",
    "        \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Making training table\n"
     ]
    }
   ],
   "source": [
    "tst= create_test_table(in_df, ref_df, [2,3,5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RID</th>\n",
       "      <th>AGE</th>\n",
       "      <th>PTGENDER</th>\n",
       "      <th>PTEDUCAT</th>\n",
       "      <th>PTETHCAT</th>\n",
       "      <th>PTRACCAT</th>\n",
       "      <th>PTMARRY</th>\n",
       "      <th>APOE4</th>\n",
       "      <th>CDRSB</th>\n",
       "      <th>MMSE</th>\n",
       "      <th>...</th>\n",
       "      <th>ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>y_DX</th>\n",
       "      <th>y_ADAS11</th>\n",
       "      <th>y_ADAS13</th>\n",
       "      <th>delta_t</th>\n",
       "      <th>future_y_DX</th>\n",
       "      <th>future_y_ADAS11</th>\n",
       "      <th>future_y_ADAS13</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>1.37649</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.29416</td>\n",
       "      <td>1</td>\n",
       "      <td>0.301813</td>\n",
       "      <td>0.469022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.52357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.167998</td>\n",
       "      <td>0.350433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.75299</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.9824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.21182</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.44123</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.0872098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.67065</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.161566</td>\n",
       "      <td>0.041559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.90007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.146173</td>\n",
       "      <td>0.0330878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>4.12948</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.106452</td>\n",
       "      <td>0.0535343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>4.58831</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>0.127052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>1.14708</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.06474</td>\n",
       "      <td>1</td>\n",
       "      <td>0.301813</td>\n",
       "      <td>0.469022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.29416</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.167998</td>\n",
       "      <td>0.350433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.52357</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.75299</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.9824</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.21182</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.0872098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.44123</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.161566</td>\n",
       "      <td>0.041559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.67065</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.146173</td>\n",
       "      <td>0.0330878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.90007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.106452</td>\n",
       "      <td>0.0535343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>4.3589</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>0.127052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>0.917662</td>\n",
       "      <td>1</td>\n",
       "      <td>0.301813</td>\n",
       "      <td>0.469022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.14708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.167998</td>\n",
       "      <td>0.350433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.37649</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.60591</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.83532</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>2.06474</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.0872098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>2.29416</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.161566</td>\n",
       "      <td>0.041559</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>0.828688</td>\n",
       "      <td>-1.66966</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.533728</td>\n",
       "      <td>-0.132373</td>\n",
       "      <td>1.71691</td>\n",
       "      <td>3</td>\n",
       "      <td>1.22857</td>\n",
       "      <td>1.15296</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>3</td>\n",
       "      <td>1.46026</td>\n",
       "      <td>1.49493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>0.828688</td>\n",
       "      <td>-1.66966</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.533728</td>\n",
       "      <td>-0.132373</td>\n",
       "      <td>1.71691</td>\n",
       "      <td>3</td>\n",
       "      <td>1.22857</td>\n",
       "      <td>1.15296</td>\n",
       "      <td>0.688247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.47872</td>\n",
       "      <td>1.53483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>0.828688</td>\n",
       "      <td>-1.66966</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.533728</td>\n",
       "      <td>-0.132373</td>\n",
       "      <td>1.71691</td>\n",
       "      <td>3</td>\n",
       "      <td>1.22857</td>\n",
       "      <td>1.15296</td>\n",
       "      <td>0.917662</td>\n",
       "      <td>3</td>\n",
       "      <td>1.65372</td>\n",
       "      <td>1.7232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>1.3625</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.938457</td>\n",
       "      <td>0.213621</td>\n",
       "      <td>1.52848</td>\n",
       "      <td>3</td>\n",
       "      <td>0.881036</td>\n",
       "      <td>1.06747</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>3</td>\n",
       "      <td>1.46026</td>\n",
       "      <td>1.49493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>1.3625</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.938457</td>\n",
       "      <td>0.213621</td>\n",
       "      <td>1.52848</td>\n",
       "      <td>3</td>\n",
       "      <td>0.881036</td>\n",
       "      <td>1.06747</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.47872</td>\n",
       "      <td>1.53483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>1.3625</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.938457</td>\n",
       "      <td>0.213621</td>\n",
       "      <td>1.52848</td>\n",
       "      <td>3</td>\n",
       "      <td>0.881036</td>\n",
       "      <td>1.06747</td>\n",
       "      <td>0.688247</td>\n",
       "      <td>3</td>\n",
       "      <td>1.65372</td>\n",
       "      <td>1.7232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>0.47281</td>\n",
       "      <td>-2.42949</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.707761</td>\n",
       "      <td>-0.145187</td>\n",
       "      <td>1.61766</td>\n",
       "      <td>3</td>\n",
       "      <td>1.46026</td>\n",
       "      <td>1.49493</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.47872</td>\n",
       "      <td>1.53483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>0.47281</td>\n",
       "      <td>-2.42949</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.707761</td>\n",
       "      <td>-0.145187</td>\n",
       "      <td>1.61766</td>\n",
       "      <td>3</td>\n",
       "      <td>1.46026</td>\n",
       "      <td>1.49493</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>3</td>\n",
       "      <td>1.65372</td>\n",
       "      <td>1.7232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3</td>\n",
       "      <td>1.07348</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.71092</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>1.2573</td>\n",
       "      <td>-1.98629</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.791637</td>\n",
       "      <td>-0.162286</td>\n",
       "      <td>1.65417</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.47872</td>\n",
       "      <td>1.53483</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>3</td>\n",
       "      <td>1.65372</td>\n",
       "      <td>1.7232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.947581</td>\n",
       "      <td>-0.465551</td>\n",
       "      <td>-0.701054</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.315639</td>\n",
       "      <td>-0.243132</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>-0.214919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.947581</td>\n",
       "      <td>-0.465551</td>\n",
       "      <td>-0.701054</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.315639</td>\n",
       "      <td>-0.243132</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.663173</td>\n",
       "      <td>-0.357846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.947581</td>\n",
       "      <td>-0.465551</td>\n",
       "      <td>-0.701054</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.315639</td>\n",
       "      <td>-0.243132</td>\n",
       "      <td>0.688247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.516778</td>\n",
       "      <td>-0.484862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.947581</td>\n",
       "      <td>-0.465551</td>\n",
       "      <td>-0.701054</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.315639</td>\n",
       "      <td>-0.243132</td>\n",
       "      <td>0.917662</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5091</td>\n",
       "      <td>-0.55689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.947581</td>\n",
       "      <td>-0.465551</td>\n",
       "      <td>-0.701054</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.315639</td>\n",
       "      <td>-0.243132</td>\n",
       "      <td>1.14708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.523113</td>\n",
       "      <td>-0.509848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.947581</td>\n",
       "      <td>-0.465551</td>\n",
       "      <td>-0.701054</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.315639</td>\n",
       "      <td>-0.243132</td>\n",
       "      <td>1.37649</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.547328</td>\n",
       "      <td>-0.49961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.639987</td>\n",
       "      <td>-0.0298561</td>\n",
       "      <td>-0.83195</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>-0.214919</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.663173</td>\n",
       "      <td>-0.357846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.639987</td>\n",
       "      <td>-0.0298561</td>\n",
       "      <td>-0.83195</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>-0.214919</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.516778</td>\n",
       "      <td>-0.484862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.639987</td>\n",
       "      <td>-0.0298561</td>\n",
       "      <td>-0.83195</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>-0.214919</td>\n",
       "      <td>0.688247</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5091</td>\n",
       "      <td>-0.55689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.639987</td>\n",
       "      <td>-0.0298561</td>\n",
       "      <td>-0.83195</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>-0.214919</td>\n",
       "      <td>0.917662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.523113</td>\n",
       "      <td>-0.509848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.639987</td>\n",
       "      <td>-0.0298561</td>\n",
       "      <td>-0.83195</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0457212</td>\n",
       "      <td>-0.214919</td>\n",
       "      <td>1.14708</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.547328</td>\n",
       "      <td>-0.49961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.238946</td>\n",
       "      <td>0.8631</td>\n",
       "      <td>...</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.760287</td>\n",
       "      <td>-0.800305</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.663173</td>\n",
       "      <td>-0.357846</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.516778</td>\n",
       "      <td>-0.484862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.238946</td>\n",
       "      <td>0.8631</td>\n",
       "      <td>...</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.760287</td>\n",
       "      <td>-0.800305</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.663173</td>\n",
       "      <td>-0.357846</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5091</td>\n",
       "      <td>-0.55689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.238946</td>\n",
       "      <td>0.8631</td>\n",
       "      <td>...</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.760287</td>\n",
       "      <td>-0.800305</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.663173</td>\n",
       "      <td>-0.357846</td>\n",
       "      <td>0.688247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.523113</td>\n",
       "      <td>-0.509848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.238946</td>\n",
       "      <td>0.8631</td>\n",
       "      <td>...</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.760287</td>\n",
       "      <td>-0.800305</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.663173</td>\n",
       "      <td>-0.357846</td>\n",
       "      <td>0.917662</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.547328</td>\n",
       "      <td>-0.49961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.54278</td>\n",
       "      <td>0.722731</td>\n",
       "      <td>...</td>\n",
       "      <td>0.581338</td>\n",
       "      <td>-0.449854</td>\n",
       "      <td>-0.731726</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.516778</td>\n",
       "      <td>-0.484862</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5091</td>\n",
       "      <td>-0.55689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.54278</td>\n",
       "      <td>0.722731</td>\n",
       "      <td>...</td>\n",
       "      <td>0.581338</td>\n",
       "      <td>-0.449854</td>\n",
       "      <td>-0.731726</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.516778</td>\n",
       "      <td>-0.484862</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.523113</td>\n",
       "      <td>-0.509848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.54278</td>\n",
       "      <td>0.722731</td>\n",
       "      <td>...</td>\n",
       "      <td>0.581338</td>\n",
       "      <td>-0.449854</td>\n",
       "      <td>-0.731726</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.516778</td>\n",
       "      <td>-0.484862</td>\n",
       "      <td>0.688247</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.547328</td>\n",
       "      <td>-0.49961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.337406</td>\n",
       "      <td>-0.624819</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5091</td>\n",
       "      <td>-0.55689</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.523113</td>\n",
       "      <td>-0.509848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.337406</td>\n",
       "      <td>-0.624819</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5091</td>\n",
       "      <td>-0.55689</td>\n",
       "      <td>0.458831</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.547328</td>\n",
       "      <td>-0.49961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.0164734</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.541238</td>\n",
       "      <td>0.768974</td>\n",
       "      <td>...</td>\n",
       "      <td>0.604768</td>\n",
       "      <td>0.0611492</td>\n",
       "      <td>-0.796288</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.523113</td>\n",
       "      <td>-0.509848</td>\n",
       "      <td>0.229416</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.547328</td>\n",
       "      <td>-0.49961</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>109 rows × 381 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RID        AGE PTGENDER    PTEDUCAT  PTETHCAT  PTRACCAT  PTMARRY     APOE4  \\\n",
       "0    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "1    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "2    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "3    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "4    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "5    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "6    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "7    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "8    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "9    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "10   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "11   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "12   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "13   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "14   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "15   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "16   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "17   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "18   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "19   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "20   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "21   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "22   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "23   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "24   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "25   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "26   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "27   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "28   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "29   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "..  ..        ...      ...         ...       ...       ...      ...       ...   \n",
       "1    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "2    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "3    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "4    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "5    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "6    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "7    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "8    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "9    3    1.07348 -0.87488     0.71092 -0.172768 -0.253396 -0.48648  0.705575   \n",
       "0    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "1    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "2    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "3    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "4    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "5    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "6    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "7    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "8    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "9    5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "10   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "11   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "12   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "13   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "14   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "15   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "16   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "17   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "18   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "19   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "20   5 -0.0164734 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "\n",
       "       CDRSB      MMSE       ...        \\\n",
       "0  -0.772763  0.356549       ...         \n",
       "1  -0.772763  0.356549       ...         \n",
       "2  -0.772763  0.356549       ...         \n",
       "3  -0.772763  0.356549       ...         \n",
       "4  -0.772763  0.356549       ...         \n",
       "5  -0.772763  0.356549       ...         \n",
       "6  -0.772763  0.356549       ...         \n",
       "7  -0.772763  0.356549       ...         \n",
       "8  -0.772763  0.356549       ...         \n",
       "9  -0.772763  0.356549       ...         \n",
       "10 -0.772763  0.356549       ...         \n",
       "11 -0.772763  0.356549       ...         \n",
       "12 -0.772763  0.356549       ...         \n",
       "13 -0.772763  0.356549       ...         \n",
       "14 -0.772763  0.356549       ...         \n",
       "15 -0.772763  0.356549       ...         \n",
       "16 -0.772763  0.356549       ...         \n",
       "17 -0.772763  0.356549       ...         \n",
       "18 -0.772763  0.356549       ...         \n",
       "19 -0.772763  0.356549       ...         \n",
       "20 -0.772763  0.356549       ...         \n",
       "21 -0.772763  0.356549       ...         \n",
       "22 -0.772763  0.356549       ...         \n",
       "23 -0.772763  0.609824       ...         \n",
       "24 -0.772763  0.609824       ...         \n",
       "25 -0.772763  0.609824       ...         \n",
       "26 -0.772763  0.609824       ...         \n",
       "27 -0.772763  0.609824       ...         \n",
       "28 -0.772763  0.609824       ...         \n",
       "29 -0.772763  0.609824       ...         \n",
       "..       ...       ...       ...         \n",
       "1   0.828688  -1.66966       ...         \n",
       "2   0.828688  -1.66966       ...         \n",
       "3   0.828688  -1.66966       ...         \n",
       "4     1.3625 -0.656555       ...         \n",
       "5     1.3625 -0.656555       ...         \n",
       "6     1.3625 -0.656555       ...         \n",
       "7    0.47281  -2.42949       ...         \n",
       "8    0.47281  -2.42949       ...         \n",
       "9     1.2573  -1.98629       ...         \n",
       "0  -0.772763  0.609824       ...         \n",
       "1  -0.772763  0.609824       ...         \n",
       "2  -0.772763  0.609824       ...         \n",
       "3  -0.772763  0.609824       ...         \n",
       "4  -0.772763  0.609824       ...         \n",
       "5  -0.772763  0.609824       ...         \n",
       "6  -0.772763  0.609824       ...         \n",
       "7  -0.772763  0.609824       ...         \n",
       "8  -0.772763  0.609824       ...         \n",
       "9  -0.772763  0.609824       ...         \n",
       "10 -0.772763  0.609824       ...         \n",
       "11 -0.238946    0.8631       ...         \n",
       "12 -0.238946    0.8631       ...         \n",
       "13 -0.238946    0.8631       ...         \n",
       "14 -0.238946    0.8631       ...         \n",
       "15  -0.54278  0.722731       ...         \n",
       "16  -0.54278  0.722731       ...         \n",
       "17  -0.54278  0.722731       ...         \n",
       "18 -0.772763  0.609824       ...         \n",
       "19 -0.772763  0.609824       ...         \n",
       "20 -0.541238  0.768974       ...         \n",
       "\n",
       "   ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                     1.42111   \n",
       "1                                     1.42111   \n",
       "2                                     1.42111   \n",
       "3                                     1.42111   \n",
       "4                                     1.42111   \n",
       "5                                     1.42111   \n",
       "6                                     1.42111   \n",
       "7                                     1.42111   \n",
       "8                                     1.42111   \n",
       "9                                     1.42111   \n",
       "10                                    1.42111   \n",
       "11                                    1.42111   \n",
       "12                                    1.16406   \n",
       "13                                    1.16406   \n",
       "14                                    1.16406   \n",
       "15                                    1.16406   \n",
       "16                                    1.16406   \n",
       "17                                    1.16406   \n",
       "18                                    1.16406   \n",
       "19                                    1.16406   \n",
       "20                                    1.16406   \n",
       "21                                    1.16406   \n",
       "22                                    1.16406   \n",
       "23                                    1.04129   \n",
       "24                                    1.04129   \n",
       "25                                    1.04129   \n",
       "26                                    1.04129   \n",
       "27                                    1.04129   \n",
       "28                                    1.04129   \n",
       "29                                    1.04129   \n",
       "..                                        ...   \n",
       "1                                   -0.533728   \n",
       "2                                   -0.533728   \n",
       "3                                   -0.533728   \n",
       "4                                   -0.938457   \n",
       "5                                   -0.938457   \n",
       "6                                   -0.938457   \n",
       "7                                   -0.707761   \n",
       "8                                   -0.707761   \n",
       "9                                   -0.791637   \n",
       "0                                    0.947581   \n",
       "1                                    0.947581   \n",
       "2                                    0.947581   \n",
       "3                                    0.947581   \n",
       "4                                    0.947581   \n",
       "5                                    0.947581   \n",
       "6                                    0.639987   \n",
       "7                                    0.639987   \n",
       "8                                    0.639987   \n",
       "9                                    0.639987   \n",
       "10                                   0.639987   \n",
       "11                                   0.550947   \n",
       "12                                   0.550947   \n",
       "13                                   0.550947   \n",
       "14                                   0.550947   \n",
       "15                                   0.581338   \n",
       "16                                   0.581338   \n",
       "17                                   0.581338   \n",
       "18                                   0.550947   \n",
       "19                                   0.550947   \n",
       "20                                   0.604768   \n",
       "\n",
       "   ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                   -0.606512   \n",
       "1                                   -0.606512   \n",
       "2                                   -0.606512   \n",
       "3                                   -0.606512   \n",
       "4                                   -0.606512   \n",
       "5                                   -0.606512   \n",
       "6                                   -0.606512   \n",
       "7                                   -0.606512   \n",
       "8                                   -0.606512   \n",
       "9                                   -0.606512   \n",
       "10                                  -0.606512   \n",
       "11                                  -0.606512   \n",
       "12                                  -0.133447   \n",
       "13                                  -0.133447   \n",
       "14                                  -0.133447   \n",
       "15                                  -0.133447   \n",
       "16                                  -0.133447   \n",
       "17                                  -0.133447   \n",
       "18                                  -0.133447   \n",
       "19                                  -0.133447   \n",
       "20                                  -0.133447   \n",
       "21                                  -0.133447   \n",
       "22                                  -0.133447   \n",
       "23                                   0.597033   \n",
       "24                                   0.597033   \n",
       "25                                   0.597033   \n",
       "26                                   0.597033   \n",
       "27                                   0.597033   \n",
       "28                                   0.597033   \n",
       "29                                   0.597033   \n",
       "..                                        ...   \n",
       "1                                   -0.132373   \n",
       "2                                   -0.132373   \n",
       "3                                   -0.132373   \n",
       "4                                    0.213621   \n",
       "5                                    0.213621   \n",
       "6                                    0.213621   \n",
       "7                                   -0.145187   \n",
       "8                                   -0.145187   \n",
       "9                                   -0.162286   \n",
       "0                                   -0.465551   \n",
       "1                                   -0.465551   \n",
       "2                                   -0.465551   \n",
       "3                                   -0.465551   \n",
       "4                                   -0.465551   \n",
       "5                                   -0.465551   \n",
       "6                                  -0.0298561   \n",
       "7                                  -0.0298561   \n",
       "8                                  -0.0298561   \n",
       "9                                  -0.0298561   \n",
       "10                                 -0.0298561   \n",
       "11                                  -0.760287   \n",
       "12                                  -0.760287   \n",
       "13                                  -0.760287   \n",
       "14                                  -0.760287   \n",
       "15                                  -0.449854   \n",
       "16                                  -0.449854   \n",
       "17                                  -0.449854   \n",
       "18                                  -0.337406   \n",
       "19                                  -0.337406   \n",
       "20                                  0.0611492   \n",
       "\n",
       "   ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16 y_DX   y_ADAS11   y_ADAS13  \\\n",
       "0                                    3.28765    1 -0.0839499  0.0988391   \n",
       "1                                    3.28765    1 -0.0839499  0.0988391   \n",
       "2                                    3.28765    1 -0.0839499  0.0988391   \n",
       "3                                    3.28765    1 -0.0839499  0.0988391   \n",
       "4                                    3.28765    1 -0.0839499  0.0988391   \n",
       "5                                    3.28765    1 -0.0839499  0.0988391   \n",
       "6                                    3.28765    1 -0.0839499  0.0988391   \n",
       "7                                    3.28765    1 -0.0839499  0.0988391   \n",
       "8                                    3.28765    1 -0.0839499  0.0988391   \n",
       "9                                    3.28765    1 -0.0839499  0.0988391   \n",
       "10                                   3.28765    1 -0.0839499  0.0988391   \n",
       "11                                   3.28765    1 -0.0839499  0.0988391   \n",
       "12                                   2.25436    1 -0.0839499   0.184332   \n",
       "13                                   2.25436    1 -0.0839499   0.184332   \n",
       "14                                   2.25436    1 -0.0839499   0.184332   \n",
       "15                                   2.25436    1 -0.0839499   0.184332   \n",
       "16                                   2.25436    1 -0.0839499   0.184332   \n",
       "17                                   2.25436    1 -0.0839499   0.184332   \n",
       "18                                   2.25436    1 -0.0839499   0.184332   \n",
       "19                                   2.25436    1 -0.0839499   0.184332   \n",
       "20                                   2.25436    1 -0.0839499   0.184332   \n",
       "21                                   2.25436    1 -0.0839499   0.184332   \n",
       "22                                   2.25436    1 -0.0839499   0.184332   \n",
       "23                                   1.43151    1  0.0701234   0.212544   \n",
       "24                                   1.43151    1  0.0701234   0.212544   \n",
       "25                                   1.43151    1  0.0701234   0.212544   \n",
       "26                                   1.43151    1  0.0701234   0.212544   \n",
       "27                                   1.43151    1  0.0701234   0.212544   \n",
       "28                                   1.43151    1  0.0701234   0.212544   \n",
       "29                                   1.43151    1  0.0701234   0.212544   \n",
       "..                                       ...  ...        ...        ...   \n",
       "1                                    1.71691    3    1.22857    1.15296   \n",
       "2                                    1.71691    3    1.22857    1.15296   \n",
       "3                                    1.71691    3    1.22857    1.15296   \n",
       "4                                    1.52848    3   0.881036    1.06747   \n",
       "5                                    1.52848    3   0.881036    1.06747   \n",
       "6                                    1.52848    3   0.881036    1.06747   \n",
       "7                                    1.61766    3    1.46026    1.49493   \n",
       "8                                    1.61766    3    1.46026    1.49493   \n",
       "9                                    1.65417  NaN    1.47872    1.53483   \n",
       "0                                  -0.701054    1  -0.315639  -0.243132   \n",
       "1                                  -0.701054    1  -0.315639  -0.243132   \n",
       "2                                  -0.701054    1  -0.315639  -0.243132   \n",
       "3                                  -0.701054    1  -0.315639  -0.243132   \n",
       "4                                  -0.701054    1  -0.315639  -0.243132   \n",
       "5                                  -0.701054    1  -0.315639  -0.243132   \n",
       "6                                   -0.83195    1 -0.0457212  -0.214919   \n",
       "7                                   -0.83195    1 -0.0457212  -0.214919   \n",
       "8                                   -0.83195    1 -0.0457212  -0.214919   \n",
       "9                                   -0.83195    1 -0.0457212  -0.214919   \n",
       "10                                  -0.83195    1 -0.0457212  -0.214919   \n",
       "11                                 -0.800305    1  -0.663173  -0.357846   \n",
       "12                                 -0.800305    1  -0.663173  -0.357846   \n",
       "13                                 -0.800305    1  -0.663173  -0.357846   \n",
       "14                                 -0.800305    1  -0.663173  -0.357846   \n",
       "15                                 -0.731726  NaN  -0.516778  -0.484862   \n",
       "16                                 -0.731726  NaN  -0.516778  -0.484862   \n",
       "17                                 -0.731726  NaN  -0.516778  -0.484862   \n",
       "18                                 -0.624819    1    -0.5091   -0.55689   \n",
       "19                                 -0.624819    1    -0.5091   -0.55689   \n",
       "20                                 -0.796288  NaN  -0.523113  -0.509848   \n",
       "\n",
       "     delta_t future_y_DX future_y_ADAS11 future_y_ADAS13  \n",
       "0   0.229416           1      -0.0839499        0.184332  \n",
       "1    1.37649           1       0.0701234        0.212544  \n",
       "2    2.29416           1        0.301813        0.469022  \n",
       "3    2.52357         NaN        0.167998        0.350433  \n",
       "4    2.75299           1       0.0701234        0.298037  \n",
       "5     2.9824         NaN      -0.0834568       0.0294039  \n",
       "6    3.21182           2        -0.27741       -0.300412  \n",
       "7    3.44123         NaN       -0.190362      -0.0872098  \n",
       "8    3.67065           1       -0.161566        0.041559  \n",
       "9    3.90007         NaN       -0.146173       0.0330878  \n",
       "10   4.12948         NaN       -0.106452       0.0535343  \n",
       "11   4.58831           1      -0.0457212        0.127052  \n",
       "12   1.14708           1       0.0701234        0.212544  \n",
       "13   2.06474           1        0.301813        0.469022  \n",
       "14   2.29416         NaN        0.167998        0.350433  \n",
       "15   2.52357           1       0.0701234        0.298037  \n",
       "16   2.75299         NaN      -0.0834568       0.0294039  \n",
       "17    2.9824           2        -0.27741       -0.300412  \n",
       "18   3.21182         NaN       -0.190362      -0.0872098  \n",
       "19   3.44123           1       -0.161566        0.041559  \n",
       "20   3.67065         NaN       -0.146173       0.0330878  \n",
       "21   3.90007         NaN       -0.106452       0.0535343  \n",
       "22    4.3589           1      -0.0457212        0.127052  \n",
       "23  0.917662           1        0.301813        0.469022  \n",
       "24   1.14708         NaN        0.167998        0.350433  \n",
       "25   1.37649           1       0.0701234        0.298037  \n",
       "26   1.60591         NaN      -0.0834568       0.0294039  \n",
       "27   1.83532           2        -0.27741       -0.300412  \n",
       "28   2.06474         NaN       -0.190362      -0.0872098  \n",
       "29   2.29416           1       -0.161566        0.041559  \n",
       "..       ...         ...             ...             ...  \n",
       "1   0.458831           3         1.46026         1.49493  \n",
       "2   0.688247         NaN         1.47872         1.53483  \n",
       "3   0.917662           3         1.65372          1.7232  \n",
       "4   0.229416           3         1.46026         1.49493  \n",
       "5   0.458831         NaN         1.47872         1.53483  \n",
       "6   0.688247           3         1.65372          1.7232  \n",
       "7   0.229416         NaN         1.47872         1.53483  \n",
       "8   0.458831           3         1.65372          1.7232  \n",
       "9   0.229416           3         1.65372          1.7232  \n",
       "0   0.229416           1      -0.0457212       -0.214919  \n",
       "1   0.458831           1       -0.663173       -0.357846  \n",
       "2   0.688247         NaN       -0.516778       -0.484862  \n",
       "3   0.917662           1         -0.5091        -0.55689  \n",
       "4    1.14708         NaN       -0.523113       -0.509848  \n",
       "5    1.37649           1       -0.547328        -0.49961  \n",
       "6   0.229416           1       -0.663173       -0.357846  \n",
       "7   0.458831         NaN       -0.516778       -0.484862  \n",
       "8   0.688247           1         -0.5091        -0.55689  \n",
       "9   0.917662         NaN       -0.523113       -0.509848  \n",
       "10   1.14708           1       -0.547328        -0.49961  \n",
       "11  0.229416         NaN       -0.516778       -0.484862  \n",
       "12  0.458831           1         -0.5091        -0.55689  \n",
       "13  0.688247         NaN       -0.523113       -0.509848  \n",
       "14  0.917662           1       -0.547328        -0.49961  \n",
       "15  0.229416           1         -0.5091        -0.55689  \n",
       "16  0.458831         NaN       -0.523113       -0.509848  \n",
       "17  0.688247           1       -0.547328        -0.49961  \n",
       "18  0.229416         NaN       -0.523113       -0.509848  \n",
       "19  0.458831           1       -0.547328        -0.49961  \n",
       "20  0.229416           1       -0.547328        -0.49961  \n",
       "\n",
       "[109 rows x 381 columns]"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tst"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "rid = 2\n",
    "gind = ref_df[ref_df.RID==rid].index\n",
    "x_tbl = in_df.loc[gind].sort_values('Month_bl',ascending=True)\n",
    "y_tbl = ref_df.loc[x_tbl.index]\n",
    "ycols = [x for x in y_tbl.columns if 'y_' in x]\n",
    "# create output dataframe\n",
    "outdf = pandas.concat([x_tbl,y_tbl[['RID']+ycols]],axis=1)\n",
    "# calculate time to final timepoint\n",
    "fTime = x_tbl.loc[x_tbl.index,'Month']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       -0.995944\n",
       "5723    -0.766528\n",
       "5724     0.380550\n",
       "5725     1.298212\n",
       "5726     1.527628\n",
       "5727     1.757043\n",
       "5728     1.986459\n",
       "5729     2.215874\n",
       "5730     2.445290\n",
       "5731     2.674706\n",
       "10836    2.904121\n",
       "11571    3.133537\n",
       "11959    3.592368\n",
       "Name: Month, dtype: float64"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fTime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Making testing table\n"
     ]
    }
   ],
   "source": [
    "tst2 = create_test_table(in_df, ref_df, [2,3,5],mode='test')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RID</th>\n",
       "      <th>AGE</th>\n",
       "      <th>PTGENDER</th>\n",
       "      <th>PTEDUCAT</th>\n",
       "      <th>PTETHCAT</th>\n",
       "      <th>PTRACCAT</th>\n",
       "      <th>PTMARRY</th>\n",
       "      <th>APOE4</th>\n",
       "      <th>CDRSB</th>\n",
       "      <th>MMSE</th>\n",
       "      <th>...</th>\n",
       "      <th>ST99CV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99SA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>y_DX</th>\n",
       "      <th>y_ADAS11</th>\n",
       "      <th>y_ADAS13</th>\n",
       "      <th>delta_t</th>\n",
       "      <th>months_to_final_timepoint</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>3.176360</td>\n",
       "      <td>2.627168</td>\n",
       "      <td>1.421115</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.287650</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.083950</td>\n",
       "      <td>0.098839</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.588312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5723</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>2.406951</td>\n",
       "      <td>1.886980</td>\n",
       "      <td>1.164061</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.254361</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.083950</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.358896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5724</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>1.688536</td>\n",
       "      <td>1.129351</td>\n",
       "      <td>1.041293</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.431506</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.070123</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.211818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5725</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.202035</td>\n",
       "      <td>0.640703</td>\n",
       "      <td>0.817736</td>\n",
       "      <td>1.265748</td>\n",
       "      <td>0.058954</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.301813</td>\n",
       "      <td>0.469022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.294156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5726</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.752127</td>\n",
       "      <td>-0.209366</td>\n",
       "      <td>...</td>\n",
       "      <td>1.192612</td>\n",
       "      <td>0.571852</td>\n",
       "      <td>0.988417</td>\n",
       "      <td>0.858098</td>\n",
       "      <td>0.290394</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.167998</td>\n",
       "      <td>0.350433</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.064740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5727</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>1.312224</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.157063</td>\n",
       "      <td>0.077092</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.070123</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.835325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5728</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.608694</td>\n",
       "      <td>-0.682594</td>\n",
       "      <td>...</td>\n",
       "      <td>1.311452</td>\n",
       "      <td>0.667614</td>\n",
       "      <td>1.120287</td>\n",
       "      <td>0.615888</td>\n",
       "      <td>0.403471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.083457</td>\n",
       "      <td>0.029404</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.605909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5729</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.416885</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>1.074359</td>\n",
       "      <td>0.699543</td>\n",
       "      <td>0.813220</td>\n",
       "      <td>0.117173</td>\n",
       "      <td>1.243536</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.277410</td>\n",
       "      <td>-0.300412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.376494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5730</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.539016</td>\n",
       "      <td>-0.486514</td>\n",
       "      <td>...</td>\n",
       "      <td>1.312254</td>\n",
       "      <td>0.667059</td>\n",
       "      <td>1.141220</td>\n",
       "      <td>0.533161</td>\n",
       "      <td>0.404521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.087210</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.147078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5731</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.594824</td>\n",
       "      <td>-0.403279</td>\n",
       "      <td>...</td>\n",
       "      <td>1.294351</td>\n",
       "      <td>0.758900</td>\n",
       "      <td>0.863633</td>\n",
       "      <td>0.574730</td>\n",
       "      <td>0.486808</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.161566</td>\n",
       "      <td>0.041559</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10836</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.673369</td>\n",
       "      <td>-0.064781</td>\n",
       "      <td>...</td>\n",
       "      <td>1.272091</td>\n",
       "      <td>0.808349</td>\n",
       "      <td>0.885909</td>\n",
       "      <td>0.407726</td>\n",
       "      <td>0.497432</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.146173</td>\n",
       "      <td>0.033088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11571</th>\n",
       "      <td>2</td>\n",
       "      <td>0.069575</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.271381</td>\n",
       "      <td>0.809751</td>\n",
       "      <td>0.883504</td>\n",
       "      <td>0.405273</td>\n",
       "      <td>0.500992</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.106452</td>\n",
       "      <td>0.053534</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>1.073477</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.710920</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>0.828688</td>\n",
       "      <td>-1.669659</td>\n",
       "      <td>...</td>\n",
       "      <td>0.169014</td>\n",
       "      <td>0.420666</td>\n",
       "      <td>-0.533728</td>\n",
       "      <td>-0.132373</td>\n",
       "      <td>1.716909</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.228569</td>\n",
       "      <td>1.152964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>1.073477</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.710920</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>1.362505</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.441995</td>\n",
       "      <td>0.009832</td>\n",
       "      <td>-0.938457</td>\n",
       "      <td>0.213621</td>\n",
       "      <td>1.528478</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.881036</td>\n",
       "      <td>1.067471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1.073477</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.710920</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>0.472810</td>\n",
       "      <td>-2.429487</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.200658</td>\n",
       "      <td>0.245253</td>\n",
       "      <td>-0.707761</td>\n",
       "      <td>-0.145187</td>\n",
       "      <td>1.617659</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.460258</td>\n",
       "      <td>1.494935</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5732</th>\n",
       "      <td>3</td>\n",
       "      <td>1.073477</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.710920</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>0.705575</td>\n",
       "      <td>1.257302</td>\n",
       "      <td>-1.986290</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.321579</td>\n",
       "      <td>0.088825</td>\n",
       "      <td>-0.791637</td>\n",
       "      <td>-0.162286</td>\n",
       "      <td>1.654166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.478719</td>\n",
       "      <td>1.534834</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.016473</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.845894</td>\n",
       "      <td>0.584538</td>\n",
       "      <td>0.947581</td>\n",
       "      <td>-0.465551</td>\n",
       "      <td>-0.701054</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.315639</td>\n",
       "      <td>-0.243132</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.376494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.016473</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.801601</td>\n",
       "      <td>0.612234</td>\n",
       "      <td>0.639987</td>\n",
       "      <td>-0.029856</td>\n",
       "      <td>-0.831950</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.045721</td>\n",
       "      <td>-0.214919</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.147078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.016473</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.238946</td>\n",
       "      <td>0.863100</td>\n",
       "      <td>...</td>\n",
       "      <td>0.256463</td>\n",
       "      <td>0.169087</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.760287</td>\n",
       "      <td>-0.800305</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.663173</td>\n",
       "      <td>-0.357846</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5734</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.016473</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.542780</td>\n",
       "      <td>0.722731</td>\n",
       "      <td>...</td>\n",
       "      <td>0.344040</td>\n",
       "      <td>0.219549</td>\n",
       "      <td>0.581338</td>\n",
       "      <td>-0.449854</td>\n",
       "      <td>-0.731726</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.516778</td>\n",
       "      <td>-0.484862</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.016473</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>0.247945</td>\n",
       "      <td>0.127542</td>\n",
       "      <td>0.550947</td>\n",
       "      <td>-0.337406</td>\n",
       "      <td>-0.624819</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.509100</td>\n",
       "      <td>-0.556890</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5735</th>\n",
       "      <td>5</td>\n",
       "      <td>-0.016473</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.004105</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.541238</td>\n",
       "      <td>0.768974</td>\n",
       "      <td>...</td>\n",
       "      <td>0.395579</td>\n",
       "      <td>0.220925</td>\n",
       "      <td>0.604768</td>\n",
       "      <td>0.061149</td>\n",
       "      <td>-0.796288</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.523113</td>\n",
       "      <td>-0.509848</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22 rows × 379 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       RID       AGE  PTGENDER  PTEDUCAT  PTETHCAT  PTRACCAT  PTMARRY  \\\n",
       "0        2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5723     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5724     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5725     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5726     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5727     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5728     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5729     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5730     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5731     2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "10836    2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "11571    2  0.069575  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "1        3  1.073477  -0.87488  0.710920 -0.172768 -0.253396 -0.48648   \n",
       "2        3  1.073477  -0.87488  0.710920 -0.172768 -0.253396 -0.48648   \n",
       "3        3  1.073477  -0.87488  0.710920 -0.172768 -0.253396 -0.48648   \n",
       "5732     3  1.073477  -0.87488  0.710920 -0.172768 -0.253396 -0.48648   \n",
       "10       5 -0.016473  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "11       5 -0.016473  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "12       5 -0.016473  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5734     5 -0.016473  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "13       5 -0.016473  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "5735     5 -0.016473  -0.87488  0.004105 -0.172768 -0.253396 -0.48648   \n",
       "\n",
       "          APOE4     CDRSB      MMSE            ...              \\\n",
       "0     -0.819258 -0.772763  0.356549            ...               \n",
       "5723  -0.819258 -0.772763  0.356549            ...               \n",
       "5724  -0.819258 -0.772763  0.609824            ...               \n",
       "5725  -0.819258 -0.772763  0.356549            ...               \n",
       "5726  -0.819258 -0.752127 -0.209366            ...               \n",
       "5727  -0.819258 -0.772763 -0.909831            ...               \n",
       "5728  -0.819258 -0.608694 -0.682594            ...               \n",
       "5729  -0.819258 -0.416885 -0.656555            ...               \n",
       "5730  -0.819258 -0.539016 -0.486514            ...               \n",
       "5731  -0.819258 -0.594824 -0.403279            ...               \n",
       "10836 -0.819258 -0.673369 -0.064781            ...               \n",
       "11571 -0.819258 -0.772763  0.356549            ...               \n",
       "1      0.705575  0.828688 -1.669659            ...               \n",
       "2      0.705575  1.362505 -0.656555            ...               \n",
       "3      0.705575  0.472810 -2.429487            ...               \n",
       "5732   0.705575  1.257302 -1.986290            ...               \n",
       "10    -0.819258 -0.772763  0.609824            ...               \n",
       "11    -0.819258 -0.772763  0.609824            ...               \n",
       "12    -0.819258 -0.238946  0.863100            ...               \n",
       "5734  -0.819258 -0.542780  0.722731            ...               \n",
       "13    -0.819258 -0.772763  0.609824            ...               \n",
       "5735  -0.819258 -0.541238  0.768974            ...               \n",
       "\n",
       "       ST99CV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                        3.176360   \n",
       "5723                                     2.406951   \n",
       "5724                                     1.688536   \n",
       "5725                                     1.202035   \n",
       "5726                                     1.192612   \n",
       "5727                                     1.312224   \n",
       "5728                                     1.311452   \n",
       "5729                                     1.074359   \n",
       "5730                                     1.312254   \n",
       "5731                                     1.294351   \n",
       "10836                                    1.272091   \n",
       "11571                                    1.271381   \n",
       "1                                        0.169014   \n",
       "2                                       -0.441995   \n",
       "3                                       -0.200658   \n",
       "5732                                    -0.321579   \n",
       "10                                       0.845894   \n",
       "11                                       0.801601   \n",
       "12                                       0.256463   \n",
       "5734                                     0.344040   \n",
       "13                                       0.247945   \n",
       "5735                                     0.395579   \n",
       "\n",
       "       ST99SA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                        2.627168   \n",
       "5723                                     1.886980   \n",
       "5724                                     1.129351   \n",
       "5725                                     0.640703   \n",
       "5726                                     0.571852   \n",
       "5727                                     0.681567   \n",
       "5728                                     0.667614   \n",
       "5729                                     0.699543   \n",
       "5730                                     0.667059   \n",
       "5731                                     0.758900   \n",
       "10836                                    0.808349   \n",
       "11571                                    0.809751   \n",
       "1                                        0.420666   \n",
       "2                                        0.009832   \n",
       "3                                        0.245253   \n",
       "5732                                     0.088825   \n",
       "10                                       0.584538   \n",
       "11                                       0.612234   \n",
       "12                                       0.169087   \n",
       "5734                                     0.219549   \n",
       "13                                       0.127542   \n",
       "5735                                     0.220925   \n",
       "\n",
       "       ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                        1.421115   \n",
       "5723                                     1.164061   \n",
       "5724                                     1.041293   \n",
       "5725                                     0.817736   \n",
       "5726                                     0.988417   \n",
       "5727                                     0.932523   \n",
       "5728                                     1.120287   \n",
       "5729                                     0.813220   \n",
       "5730                                     1.141220   \n",
       "5731                                     0.863633   \n",
       "10836                                    0.885909   \n",
       "11571                                    0.883504   \n",
       "1                                       -0.533728   \n",
       "2                                       -0.938457   \n",
       "3                                       -0.707761   \n",
       "5732                                    -0.791637   \n",
       "10                                       0.947581   \n",
       "11                                       0.639987   \n",
       "12                                       0.550947   \n",
       "5734                                     0.581338   \n",
       "13                                       0.550947   \n",
       "5735                                     0.604768   \n",
       "\n",
       "       ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                       -0.606512   \n",
       "5723                                    -0.133447   \n",
       "5724                                     0.597033   \n",
       "5725                                     1.265748   \n",
       "5726                                     0.858098   \n",
       "5727                                     1.157063   \n",
       "5728                                     0.615888   \n",
       "5729                                     0.117173   \n",
       "5730                                     0.533161   \n",
       "5731                                     0.574730   \n",
       "10836                                    0.407726   \n",
       "11571                                    0.405273   \n",
       "1                                       -0.132373   \n",
       "2                                        0.213621   \n",
       "3                                       -0.145187   \n",
       "5732                                    -0.162286   \n",
       "10                                      -0.465551   \n",
       "11                                      -0.029856   \n",
       "12                                      -0.760287   \n",
       "5734                                    -0.449854   \n",
       "13                                      -0.337406   \n",
       "5735                                     0.061149   \n",
       "\n",
       "       ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  y_DX  y_ADAS11  y_ADAS13  \\\n",
       "0                                       3.287650   1.0 -0.083950  0.098839   \n",
       "5723                                    2.254361   1.0 -0.083950  0.184332   \n",
       "5724                                    1.431506   1.0  0.070123  0.212544   \n",
       "5725                                    0.058954   1.0  0.301813  0.469022   \n",
       "5726                                    0.290394   NaN  0.167998  0.350433   \n",
       "5727                                    0.077092   1.0  0.070123  0.298037   \n",
       "5728                                    0.403471   NaN -0.083457  0.029404   \n",
       "5729                                    1.243536   2.0 -0.277410 -0.300412   \n",
       "5730                                    0.404521   NaN -0.190362 -0.087210   \n",
       "5731                                    0.486808   1.0 -0.161566  0.041559   \n",
       "10836                                   0.497432   NaN -0.146173  0.033088   \n",
       "11571                                   0.500992   NaN -0.106452  0.053534   \n",
       "1                                       1.716909   3.0  1.228569  1.152964   \n",
       "2                                       1.528478   3.0  0.881036  1.067471   \n",
       "3                                       1.617659   3.0  1.460258  1.494935   \n",
       "5732                                    1.654166   NaN  1.478719  1.534834   \n",
       "10                                     -0.701054   1.0 -0.315639 -0.243132   \n",
       "11                                     -0.831950   1.0 -0.045721 -0.214919   \n",
       "12                                     -0.800305   1.0 -0.663173 -0.357846   \n",
       "5734                                   -0.731726   NaN -0.516778 -0.484862   \n",
       "13                                     -0.624819   1.0 -0.509100 -0.556890   \n",
       "5735                                   -0.796288   NaN -0.523113 -0.509848   \n",
       "\n",
       "       delta_t  months_to_final_timepoint  \n",
       "0          NaN                   4.588312  \n",
       "5723       NaN                   4.358896  \n",
       "5724       NaN                   3.211818  \n",
       "5725       NaN                   2.294156  \n",
       "5726       NaN                   2.064740  \n",
       "5727       NaN                   1.835325  \n",
       "5728       NaN                   1.605909  \n",
       "5729       NaN                   1.376494  \n",
       "5730       NaN                   1.147078  \n",
       "5731       NaN                   0.917662  \n",
       "10836      NaN                   0.688247  \n",
       "11571      NaN                   0.458831  \n",
       "1          NaN                   0.917662  \n",
       "2          NaN                   0.688247  \n",
       "3          NaN                   0.458831  \n",
       "5732       NaN                   0.229416  \n",
       "10         NaN                   1.376494  \n",
       "11         NaN                   1.147078  \n",
       "12         NaN                   0.917662  \n",
       "5734       NaN                   0.688247  \n",
       "13         NaN                   0.458831  \n",
       "5735       NaN                   0.229416  \n",
       "\n",
       "[22 rows x 379 columns]"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tst2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10.0"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(4*(4+1))/2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(in_df[ref_df.RID==3])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RID</th>\n",
       "      <th>AGE</th>\n",
       "      <th>PTGENDER</th>\n",
       "      <th>PTEDUCAT</th>\n",
       "      <th>PTETHCAT</th>\n",
       "      <th>PTRACCAT</th>\n",
       "      <th>PTMARRY</th>\n",
       "      <th>APOE4</th>\n",
       "      <th>CDRSB</th>\n",
       "      <th>MMSE</th>\n",
       "      <th>...</th>\n",
       "      <th>ST98TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99CV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99SA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>y_DX</th>\n",
       "      <th>y_ADAS11</th>\n",
       "      <th>y_ADAS13</th>\n",
       "      <th>delta_t</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>1.37649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.29416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.52357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.75299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>2.9824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.21182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.44123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.67065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>3.90007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>4.12948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>4.58831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>1.14708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.06474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.29416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.52357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.75299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>2.9824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.21182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.44123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.67065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>3.90007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.253424</td>\n",
       "      <td>2.40695</td>\n",
       "      <td>1.88698</td>\n",
       "      <td>1.16406</td>\n",
       "      <td>-0.133447</td>\n",
       "      <td>2.25436</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.184332</td>\n",
       "      <td>4.3589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.071974</td>\n",
       "      <td>1.68854</td>\n",
       "      <td>1.12935</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.071974</td>\n",
       "      <td>1.68854</td>\n",
       "      <td>1.12935</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.14708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.071974</td>\n",
       "      <td>1.68854</td>\n",
       "      <td>1.12935</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.37649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.071974</td>\n",
       "      <td>1.68854</td>\n",
       "      <td>1.12935</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.60591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.071974</td>\n",
       "      <td>1.68854</td>\n",
       "      <td>1.12935</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>1.83532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.071974</td>\n",
       "      <td>1.68854</td>\n",
       "      <td>1.12935</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>2.06474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.609824</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.071974</td>\n",
       "      <td>1.68854</td>\n",
       "      <td>1.12935</td>\n",
       "      <td>1.04129</td>\n",
       "      <td>0.597033</td>\n",
       "      <td>1.43151</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.212544</td>\n",
       "      <td>2.29416</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.752127</td>\n",
       "      <td>-0.209366</td>\n",
       "      <td>...</td>\n",
       "      <td>0.240144</td>\n",
       "      <td>1.19261</td>\n",
       "      <td>0.571852</td>\n",
       "      <td>0.988417</td>\n",
       "      <td>0.858098</td>\n",
       "      <td>0.290394</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.167998</td>\n",
       "      <td>0.350433</td>\n",
       "      <td>1.60591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.752127</td>\n",
       "      <td>-0.209366</td>\n",
       "      <td>...</td>\n",
       "      <td>0.240144</td>\n",
       "      <td>1.19261</td>\n",
       "      <td>0.571852</td>\n",
       "      <td>0.988417</td>\n",
       "      <td>0.858098</td>\n",
       "      <td>0.290394</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.167998</td>\n",
       "      <td>0.350433</td>\n",
       "      <td>2.06474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144293</td>\n",
       "      <td>1.31222</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.15706</td>\n",
       "      <td>0.0770922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144293</td>\n",
       "      <td>1.31222</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.15706</td>\n",
       "      <td>0.0770922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144293</td>\n",
       "      <td>1.31222</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.15706</td>\n",
       "      <td>0.0770922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144293</td>\n",
       "      <td>1.31222</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.15706</td>\n",
       "      <td>0.0770922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144293</td>\n",
       "      <td>1.31222</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.15706</td>\n",
       "      <td>0.0770922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>1.14708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144293</td>\n",
       "      <td>1.31222</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.15706</td>\n",
       "      <td>0.0770922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>1.37649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>-0.909831</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144293</td>\n",
       "      <td>1.31222</td>\n",
       "      <td>0.681567</td>\n",
       "      <td>0.932523</td>\n",
       "      <td>1.15706</td>\n",
       "      <td>0.0770922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0701234</td>\n",
       "      <td>0.298037</td>\n",
       "      <td>1.83532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.608694</td>\n",
       "      <td>-0.682594</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147039</td>\n",
       "      <td>1.31145</td>\n",
       "      <td>0.667614</td>\n",
       "      <td>1.12029</td>\n",
       "      <td>0.615888</td>\n",
       "      <td>0.403471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.608694</td>\n",
       "      <td>-0.682594</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147039</td>\n",
       "      <td>1.31145</td>\n",
       "      <td>0.667614</td>\n",
       "      <td>1.12029</td>\n",
       "      <td>0.615888</td>\n",
       "      <td>0.403471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.608694</td>\n",
       "      <td>-0.682594</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147039</td>\n",
       "      <td>1.31145</td>\n",
       "      <td>0.667614</td>\n",
       "      <td>1.12029</td>\n",
       "      <td>0.615888</td>\n",
       "      <td>0.403471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.608694</td>\n",
       "      <td>-0.682594</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147039</td>\n",
       "      <td>1.31145</td>\n",
       "      <td>0.667614</td>\n",
       "      <td>1.12029</td>\n",
       "      <td>0.615888</td>\n",
       "      <td>0.403471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.608694</td>\n",
       "      <td>-0.682594</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147039</td>\n",
       "      <td>1.31145</td>\n",
       "      <td>0.667614</td>\n",
       "      <td>1.12029</td>\n",
       "      <td>0.615888</td>\n",
       "      <td>0.403471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "      <td>1.14708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.608694</td>\n",
       "      <td>-0.682594</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147039</td>\n",
       "      <td>1.31145</td>\n",
       "      <td>0.667614</td>\n",
       "      <td>1.12029</td>\n",
       "      <td>0.615888</td>\n",
       "      <td>0.403471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0834568</td>\n",
       "      <td>0.0294039</td>\n",
       "      <td>1.60591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.416885</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.586813</td>\n",
       "      <td>1.07436</td>\n",
       "      <td>0.699543</td>\n",
       "      <td>0.81322</td>\n",
       "      <td>0.117173</td>\n",
       "      <td>1.24354</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.416885</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.586813</td>\n",
       "      <td>1.07436</td>\n",
       "      <td>0.699543</td>\n",
       "      <td>0.81322</td>\n",
       "      <td>0.117173</td>\n",
       "      <td>1.24354</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.416885</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.586813</td>\n",
       "      <td>1.07436</td>\n",
       "      <td>0.699543</td>\n",
       "      <td>0.81322</td>\n",
       "      <td>0.117173</td>\n",
       "      <td>1.24354</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.416885</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.586813</td>\n",
       "      <td>1.07436</td>\n",
       "      <td>0.699543</td>\n",
       "      <td>0.81322</td>\n",
       "      <td>0.117173</td>\n",
       "      <td>1.24354</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.416885</td>\n",
       "      <td>-0.656555</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.586813</td>\n",
       "      <td>1.07436</td>\n",
       "      <td>0.699543</td>\n",
       "      <td>0.81322</td>\n",
       "      <td>0.117173</td>\n",
       "      <td>1.24354</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.27741</td>\n",
       "      <td>-0.300412</td>\n",
       "      <td>1.37649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.539016</td>\n",
       "      <td>-0.486514</td>\n",
       "      <td>...</td>\n",
       "      <td>0.10706</td>\n",
       "      <td>1.31225</td>\n",
       "      <td>0.667059</td>\n",
       "      <td>1.14122</td>\n",
       "      <td>0.533161</td>\n",
       "      <td>0.404521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.0872098</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.539016</td>\n",
       "      <td>-0.486514</td>\n",
       "      <td>...</td>\n",
       "      <td>0.10706</td>\n",
       "      <td>1.31225</td>\n",
       "      <td>0.667059</td>\n",
       "      <td>1.14122</td>\n",
       "      <td>0.533161</td>\n",
       "      <td>0.404521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.0872098</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.539016</td>\n",
       "      <td>-0.486514</td>\n",
       "      <td>...</td>\n",
       "      <td>0.10706</td>\n",
       "      <td>1.31225</td>\n",
       "      <td>0.667059</td>\n",
       "      <td>1.14122</td>\n",
       "      <td>0.533161</td>\n",
       "      <td>0.404521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.0872098</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.539016</td>\n",
       "      <td>-0.486514</td>\n",
       "      <td>...</td>\n",
       "      <td>0.10706</td>\n",
       "      <td>1.31225</td>\n",
       "      <td>0.667059</td>\n",
       "      <td>1.14122</td>\n",
       "      <td>0.533161</td>\n",
       "      <td>0.404521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190362</td>\n",
       "      <td>-0.0872098</td>\n",
       "      <td>1.14708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.594824</td>\n",
       "      <td>-0.403279</td>\n",
       "      <td>...</td>\n",
       "      <td>0.122025</td>\n",
       "      <td>1.29435</td>\n",
       "      <td>0.7589</td>\n",
       "      <td>0.863633</td>\n",
       "      <td>0.57473</td>\n",
       "      <td>0.486808</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.161566</td>\n",
       "      <td>0.041559</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.594824</td>\n",
       "      <td>-0.403279</td>\n",
       "      <td>...</td>\n",
       "      <td>0.122025</td>\n",
       "      <td>1.29435</td>\n",
       "      <td>0.7589</td>\n",
       "      <td>0.863633</td>\n",
       "      <td>0.57473</td>\n",
       "      <td>0.486808</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.161566</td>\n",
       "      <td>0.041559</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.594824</td>\n",
       "      <td>-0.403279</td>\n",
       "      <td>...</td>\n",
       "      <td>0.122025</td>\n",
       "      <td>1.29435</td>\n",
       "      <td>0.7589</td>\n",
       "      <td>0.863633</td>\n",
       "      <td>0.57473</td>\n",
       "      <td>0.486808</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.161566</td>\n",
       "      <td>0.041559</td>\n",
       "      <td>0.917662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.673369</td>\n",
       "      <td>-0.0647808</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.240828</td>\n",
       "      <td>1.27209</td>\n",
       "      <td>0.808349</td>\n",
       "      <td>0.885909</td>\n",
       "      <td>0.407726</td>\n",
       "      <td>0.497432</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.146173</td>\n",
       "      <td>0.0330878</td>\n",
       "      <td>0.229416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.673369</td>\n",
       "      <td>-0.0647808</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.240828</td>\n",
       "      <td>1.27209</td>\n",
       "      <td>0.808349</td>\n",
       "      <td>0.885909</td>\n",
       "      <td>0.407726</td>\n",
       "      <td>0.497432</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.146173</td>\n",
       "      <td>0.0330878</td>\n",
       "      <td>0.688247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.245821</td>\n",
       "      <td>1.27138</td>\n",
       "      <td>0.809751</td>\n",
       "      <td>0.883504</td>\n",
       "      <td>0.405273</td>\n",
       "      <td>0.500992</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.106452</td>\n",
       "      <td>0.0535343</td>\n",
       "      <td>0.458831</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>78 rows × 378 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RID        AGE PTGENDER    PTEDUCAT  PTETHCAT  PTRACCAT  PTMARRY     APOE4  \\\n",
       "0    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "1    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "2    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "3    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "4    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "5    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "6    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "7    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "8    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "9    2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "10   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "11   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "12   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "13   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "14   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "15   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "16   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "17   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "18   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "19   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "20   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "21   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "22   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "23   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "24   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "25   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "26   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "27   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "28   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "29   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "..  ..        ...      ...         ...       ...       ...      ...       ...   \n",
       "48   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "49   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "50   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "51   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "52   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "53   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "54   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "55   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "56   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "57   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "58   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "59   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "60   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "61   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "62   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "63   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "64   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "65   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "66   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "67   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "68   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "69   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "70   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "71   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "72   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "73   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "74   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "75   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "76   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "77   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "\n",
       "       CDRSB       MMSE    ...    ST98TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "1  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "2  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "3  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "4  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "5  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "6  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "7  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "8  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "9  -0.772763   0.356549    ...                                    -0.0231826   \n",
       "10 -0.772763   0.356549    ...                                    -0.0231826   \n",
       "11 -0.772763   0.356549    ...                                    -0.0231826   \n",
       "12 -0.772763   0.356549    ...                                     -0.253424   \n",
       "13 -0.772763   0.356549    ...                                     -0.253424   \n",
       "14 -0.772763   0.356549    ...                                     -0.253424   \n",
       "15 -0.772763   0.356549    ...                                     -0.253424   \n",
       "16 -0.772763   0.356549    ...                                     -0.253424   \n",
       "17 -0.772763   0.356549    ...                                     -0.253424   \n",
       "18 -0.772763   0.356549    ...                                     -0.253424   \n",
       "19 -0.772763   0.356549    ...                                     -0.253424   \n",
       "20 -0.772763   0.356549    ...                                     -0.253424   \n",
       "21 -0.772763   0.356549    ...                                     -0.253424   \n",
       "22 -0.772763   0.356549    ...                                     -0.253424   \n",
       "23 -0.772763   0.609824    ...                                     -0.071974   \n",
       "24 -0.772763   0.609824    ...                                     -0.071974   \n",
       "25 -0.772763   0.609824    ...                                     -0.071974   \n",
       "26 -0.772763   0.609824    ...                                     -0.071974   \n",
       "27 -0.772763   0.609824    ...                                     -0.071974   \n",
       "28 -0.772763   0.609824    ...                                     -0.071974   \n",
       "29 -0.772763   0.609824    ...                                     -0.071974   \n",
       "..       ...        ...    ...                                           ...   \n",
       "48 -0.752127  -0.209366    ...                                      0.240144   \n",
       "49 -0.752127  -0.209366    ...                                      0.240144   \n",
       "50 -0.772763  -0.909831    ...                                      0.144293   \n",
       "51 -0.772763  -0.909831    ...                                      0.144293   \n",
       "52 -0.772763  -0.909831    ...                                      0.144293   \n",
       "53 -0.772763  -0.909831    ...                                      0.144293   \n",
       "54 -0.772763  -0.909831    ...                                      0.144293   \n",
       "55 -0.772763  -0.909831    ...                                      0.144293   \n",
       "56 -0.772763  -0.909831    ...                                      0.144293   \n",
       "57 -0.608694  -0.682594    ...                                      0.147039   \n",
       "58 -0.608694  -0.682594    ...                                      0.147039   \n",
       "59 -0.608694  -0.682594    ...                                      0.147039   \n",
       "60 -0.608694  -0.682594    ...                                      0.147039   \n",
       "61 -0.608694  -0.682594    ...                                      0.147039   \n",
       "62 -0.608694  -0.682594    ...                                      0.147039   \n",
       "63 -0.416885  -0.656555    ...                                     -0.586813   \n",
       "64 -0.416885  -0.656555    ...                                     -0.586813   \n",
       "65 -0.416885  -0.656555    ...                                     -0.586813   \n",
       "66 -0.416885  -0.656555    ...                                     -0.586813   \n",
       "67 -0.416885  -0.656555    ...                                     -0.586813   \n",
       "68 -0.539016  -0.486514    ...                                       0.10706   \n",
       "69 -0.539016  -0.486514    ...                                       0.10706   \n",
       "70 -0.539016  -0.486514    ...                                       0.10706   \n",
       "71 -0.539016  -0.486514    ...                                       0.10706   \n",
       "72 -0.594824  -0.403279    ...                                      0.122025   \n",
       "73 -0.594824  -0.403279    ...                                      0.122025   \n",
       "74 -0.594824  -0.403279    ...                                      0.122025   \n",
       "75 -0.673369 -0.0647808    ...                                     -0.240828   \n",
       "76 -0.673369 -0.0647808    ...                                     -0.240828   \n",
       "77 -0.772763   0.356549    ...                                     -0.245821   \n",
       "\n",
       "   ST99CV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                     3.17636   \n",
       "1                                     3.17636   \n",
       "2                                     3.17636   \n",
       "3                                     3.17636   \n",
       "4                                     3.17636   \n",
       "5                                     3.17636   \n",
       "6                                     3.17636   \n",
       "7                                     3.17636   \n",
       "8                                     3.17636   \n",
       "9                                     3.17636   \n",
       "10                                    3.17636   \n",
       "11                                    3.17636   \n",
       "12                                    2.40695   \n",
       "13                                    2.40695   \n",
       "14                                    2.40695   \n",
       "15                                    2.40695   \n",
       "16                                    2.40695   \n",
       "17                                    2.40695   \n",
       "18                                    2.40695   \n",
       "19                                    2.40695   \n",
       "20                                    2.40695   \n",
       "21                                    2.40695   \n",
       "22                                    2.40695   \n",
       "23                                    1.68854   \n",
       "24                                    1.68854   \n",
       "25                                    1.68854   \n",
       "26                                    1.68854   \n",
       "27                                    1.68854   \n",
       "28                                    1.68854   \n",
       "29                                    1.68854   \n",
       "..                                        ...   \n",
       "48                                    1.19261   \n",
       "49                                    1.19261   \n",
       "50                                    1.31222   \n",
       "51                                    1.31222   \n",
       "52                                    1.31222   \n",
       "53                                    1.31222   \n",
       "54                                    1.31222   \n",
       "55                                    1.31222   \n",
       "56                                    1.31222   \n",
       "57                                    1.31145   \n",
       "58                                    1.31145   \n",
       "59                                    1.31145   \n",
       "60                                    1.31145   \n",
       "61                                    1.31145   \n",
       "62                                    1.31145   \n",
       "63                                    1.07436   \n",
       "64                                    1.07436   \n",
       "65                                    1.07436   \n",
       "66                                    1.07436   \n",
       "67                                    1.07436   \n",
       "68                                    1.31225   \n",
       "69                                    1.31225   \n",
       "70                                    1.31225   \n",
       "71                                    1.31225   \n",
       "72                                    1.29435   \n",
       "73                                    1.29435   \n",
       "74                                    1.29435   \n",
       "75                                    1.27209   \n",
       "76                                    1.27209   \n",
       "77                                    1.27138   \n",
       "\n",
       "   ST99SA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                     2.62717   \n",
       "1                                     2.62717   \n",
       "2                                     2.62717   \n",
       "3                                     2.62717   \n",
       "4                                     2.62717   \n",
       "5                                     2.62717   \n",
       "6                                     2.62717   \n",
       "7                                     2.62717   \n",
       "8                                     2.62717   \n",
       "9                                     2.62717   \n",
       "10                                    2.62717   \n",
       "11                                    2.62717   \n",
       "12                                    1.88698   \n",
       "13                                    1.88698   \n",
       "14                                    1.88698   \n",
       "15                                    1.88698   \n",
       "16                                    1.88698   \n",
       "17                                    1.88698   \n",
       "18                                    1.88698   \n",
       "19                                    1.88698   \n",
       "20                                    1.88698   \n",
       "21                                    1.88698   \n",
       "22                                    1.88698   \n",
       "23                                    1.12935   \n",
       "24                                    1.12935   \n",
       "25                                    1.12935   \n",
       "26                                    1.12935   \n",
       "27                                    1.12935   \n",
       "28                                    1.12935   \n",
       "29                                    1.12935   \n",
       "..                                        ...   \n",
       "48                                   0.571852   \n",
       "49                                   0.571852   \n",
       "50                                   0.681567   \n",
       "51                                   0.681567   \n",
       "52                                   0.681567   \n",
       "53                                   0.681567   \n",
       "54                                   0.681567   \n",
       "55                                   0.681567   \n",
       "56                                   0.681567   \n",
       "57                                   0.667614   \n",
       "58                                   0.667614   \n",
       "59                                   0.667614   \n",
       "60                                   0.667614   \n",
       "61                                   0.667614   \n",
       "62                                   0.667614   \n",
       "63                                   0.699543   \n",
       "64                                   0.699543   \n",
       "65                                   0.699543   \n",
       "66                                   0.699543   \n",
       "67                                   0.699543   \n",
       "68                                   0.667059   \n",
       "69                                   0.667059   \n",
       "70                                   0.667059   \n",
       "71                                   0.667059   \n",
       "72                                     0.7589   \n",
       "73                                     0.7589   \n",
       "74                                     0.7589   \n",
       "75                                   0.808349   \n",
       "76                                   0.808349   \n",
       "77                                   0.809751   \n",
       "\n",
       "   ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                     1.42111   \n",
       "1                                     1.42111   \n",
       "2                                     1.42111   \n",
       "3                                     1.42111   \n",
       "4                                     1.42111   \n",
       "5                                     1.42111   \n",
       "6                                     1.42111   \n",
       "7                                     1.42111   \n",
       "8                                     1.42111   \n",
       "9                                     1.42111   \n",
       "10                                    1.42111   \n",
       "11                                    1.42111   \n",
       "12                                    1.16406   \n",
       "13                                    1.16406   \n",
       "14                                    1.16406   \n",
       "15                                    1.16406   \n",
       "16                                    1.16406   \n",
       "17                                    1.16406   \n",
       "18                                    1.16406   \n",
       "19                                    1.16406   \n",
       "20                                    1.16406   \n",
       "21                                    1.16406   \n",
       "22                                    1.16406   \n",
       "23                                    1.04129   \n",
       "24                                    1.04129   \n",
       "25                                    1.04129   \n",
       "26                                    1.04129   \n",
       "27                                    1.04129   \n",
       "28                                    1.04129   \n",
       "29                                    1.04129   \n",
       "..                                        ...   \n",
       "48                                   0.988417   \n",
       "49                                   0.988417   \n",
       "50                                   0.932523   \n",
       "51                                   0.932523   \n",
       "52                                   0.932523   \n",
       "53                                   0.932523   \n",
       "54                                   0.932523   \n",
       "55                                   0.932523   \n",
       "56                                   0.932523   \n",
       "57                                    1.12029   \n",
       "58                                    1.12029   \n",
       "59                                    1.12029   \n",
       "60                                    1.12029   \n",
       "61                                    1.12029   \n",
       "62                                    1.12029   \n",
       "63                                    0.81322   \n",
       "64                                    0.81322   \n",
       "65                                    0.81322   \n",
       "66                                    0.81322   \n",
       "67                                    0.81322   \n",
       "68                                    1.14122   \n",
       "69                                    1.14122   \n",
       "70                                    1.14122   \n",
       "71                                    1.14122   \n",
       "72                                   0.863633   \n",
       "73                                   0.863633   \n",
       "74                                   0.863633   \n",
       "75                                   0.885909   \n",
       "76                                   0.885909   \n",
       "77                                   0.883504   \n",
       "\n",
       "   ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                   -0.606512   \n",
       "1                                   -0.606512   \n",
       "2                                   -0.606512   \n",
       "3                                   -0.606512   \n",
       "4                                   -0.606512   \n",
       "5                                   -0.606512   \n",
       "6                                   -0.606512   \n",
       "7                                   -0.606512   \n",
       "8                                   -0.606512   \n",
       "9                                   -0.606512   \n",
       "10                                  -0.606512   \n",
       "11                                  -0.606512   \n",
       "12                                  -0.133447   \n",
       "13                                  -0.133447   \n",
       "14                                  -0.133447   \n",
       "15                                  -0.133447   \n",
       "16                                  -0.133447   \n",
       "17                                  -0.133447   \n",
       "18                                  -0.133447   \n",
       "19                                  -0.133447   \n",
       "20                                  -0.133447   \n",
       "21                                  -0.133447   \n",
       "22                                  -0.133447   \n",
       "23                                   0.597033   \n",
       "24                                   0.597033   \n",
       "25                                   0.597033   \n",
       "26                                   0.597033   \n",
       "27                                   0.597033   \n",
       "28                                   0.597033   \n",
       "29                                   0.597033   \n",
       "..                                        ...   \n",
       "48                                   0.858098   \n",
       "49                                   0.858098   \n",
       "50                                    1.15706   \n",
       "51                                    1.15706   \n",
       "52                                    1.15706   \n",
       "53                                    1.15706   \n",
       "54                                    1.15706   \n",
       "55                                    1.15706   \n",
       "56                                    1.15706   \n",
       "57                                   0.615888   \n",
       "58                                   0.615888   \n",
       "59                                   0.615888   \n",
       "60                                   0.615888   \n",
       "61                                   0.615888   \n",
       "62                                   0.615888   \n",
       "63                                   0.117173   \n",
       "64                                   0.117173   \n",
       "65                                   0.117173   \n",
       "66                                   0.117173   \n",
       "67                                   0.117173   \n",
       "68                                   0.533161   \n",
       "69                                   0.533161   \n",
       "70                                   0.533161   \n",
       "71                                   0.533161   \n",
       "72                                    0.57473   \n",
       "73                                    0.57473   \n",
       "74                                    0.57473   \n",
       "75                                   0.407726   \n",
       "76                                   0.407726   \n",
       "77                                   0.405273   \n",
       "\n",
       "   ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16 y_DX   y_ADAS11   y_ADAS13  \\\n",
       "0                                    3.28765    1 -0.0839499  0.0988391   \n",
       "1                                    3.28765    1 -0.0839499  0.0988391   \n",
       "2                                    3.28765    1 -0.0839499  0.0988391   \n",
       "3                                    3.28765    1 -0.0839499  0.0988391   \n",
       "4                                    3.28765    1 -0.0839499  0.0988391   \n",
       "5                                    3.28765    1 -0.0839499  0.0988391   \n",
       "6                                    3.28765    1 -0.0839499  0.0988391   \n",
       "7                                    3.28765    1 -0.0839499  0.0988391   \n",
       "8                                    3.28765    1 -0.0839499  0.0988391   \n",
       "9                                    3.28765    1 -0.0839499  0.0988391   \n",
       "10                                   3.28765    1 -0.0839499  0.0988391   \n",
       "11                                   3.28765    1 -0.0839499  0.0988391   \n",
       "12                                   2.25436    1 -0.0839499   0.184332   \n",
       "13                                   2.25436    1 -0.0839499   0.184332   \n",
       "14                                   2.25436    1 -0.0839499   0.184332   \n",
       "15                                   2.25436    1 -0.0839499   0.184332   \n",
       "16                                   2.25436    1 -0.0839499   0.184332   \n",
       "17                                   2.25436    1 -0.0839499   0.184332   \n",
       "18                                   2.25436    1 -0.0839499   0.184332   \n",
       "19                                   2.25436    1 -0.0839499   0.184332   \n",
       "20                                   2.25436    1 -0.0839499   0.184332   \n",
       "21                                   2.25436    1 -0.0839499   0.184332   \n",
       "22                                   2.25436    1 -0.0839499   0.184332   \n",
       "23                                   1.43151    1  0.0701234   0.212544   \n",
       "24                                   1.43151    1  0.0701234   0.212544   \n",
       "25                                   1.43151    1  0.0701234   0.212544   \n",
       "26                                   1.43151    1  0.0701234   0.212544   \n",
       "27                                   1.43151    1  0.0701234   0.212544   \n",
       "28                                   1.43151    1  0.0701234   0.212544   \n",
       "29                                   1.43151    1  0.0701234   0.212544   \n",
       "..                                       ...  ...        ...        ...   \n",
       "48                                  0.290394  NaN   0.167998   0.350433   \n",
       "49                                  0.290394  NaN   0.167998   0.350433   \n",
       "50                                 0.0770922    1  0.0701234   0.298037   \n",
       "51                                 0.0770922    1  0.0701234   0.298037   \n",
       "52                                 0.0770922    1  0.0701234   0.298037   \n",
       "53                                 0.0770922    1  0.0701234   0.298037   \n",
       "54                                 0.0770922    1  0.0701234   0.298037   \n",
       "55                                 0.0770922    1  0.0701234   0.298037   \n",
       "56                                 0.0770922    1  0.0701234   0.298037   \n",
       "57                                  0.403471  NaN -0.0834568  0.0294039   \n",
       "58                                  0.403471  NaN -0.0834568  0.0294039   \n",
       "59                                  0.403471  NaN -0.0834568  0.0294039   \n",
       "60                                  0.403471  NaN -0.0834568  0.0294039   \n",
       "61                                  0.403471  NaN -0.0834568  0.0294039   \n",
       "62                                  0.403471  NaN -0.0834568  0.0294039   \n",
       "63                                   1.24354    2   -0.27741  -0.300412   \n",
       "64                                   1.24354    2   -0.27741  -0.300412   \n",
       "65                                   1.24354    2   -0.27741  -0.300412   \n",
       "66                                   1.24354    2   -0.27741  -0.300412   \n",
       "67                                   1.24354    2   -0.27741  -0.300412   \n",
       "68                                  0.404521  NaN  -0.190362 -0.0872098   \n",
       "69                                  0.404521  NaN  -0.190362 -0.0872098   \n",
       "70                                  0.404521  NaN  -0.190362 -0.0872098   \n",
       "71                                  0.404521  NaN  -0.190362 -0.0872098   \n",
       "72                                  0.486808    1  -0.161566   0.041559   \n",
       "73                                  0.486808    1  -0.161566   0.041559   \n",
       "74                                  0.486808    1  -0.161566   0.041559   \n",
       "75                                  0.497432  NaN  -0.146173  0.0330878   \n",
       "76                                  0.497432  NaN  -0.146173  0.0330878   \n",
       "77                                  0.500992  NaN  -0.106452  0.0535343   \n",
       "\n",
       "     delta_t  \n",
       "0   0.229416  \n",
       "1    1.37649  \n",
       "2    2.29416  \n",
       "3    2.52357  \n",
       "4    2.75299  \n",
       "5     2.9824  \n",
       "6    3.21182  \n",
       "7    3.44123  \n",
       "8    3.67065  \n",
       "9    3.90007  \n",
       "10   4.12948  \n",
       "11   4.58831  \n",
       "12   1.14708  \n",
       "13   2.06474  \n",
       "14   2.29416  \n",
       "15   2.52357  \n",
       "16   2.75299  \n",
       "17    2.9824  \n",
       "18   3.21182  \n",
       "19   3.44123  \n",
       "20   3.67065  \n",
       "21   3.90007  \n",
       "22    4.3589  \n",
       "23  0.917662  \n",
       "24   1.14708  \n",
       "25   1.37649  \n",
       "26   1.60591  \n",
       "27   1.83532  \n",
       "28   2.06474  \n",
       "29   2.29416  \n",
       "..       ...  \n",
       "48   1.60591  \n",
       "49   2.06474  \n",
       "50  0.229416  \n",
       "51  0.458831  \n",
       "52  0.688247  \n",
       "53  0.917662  \n",
       "54   1.14708  \n",
       "55   1.37649  \n",
       "56   1.83532  \n",
       "57  0.229416  \n",
       "58  0.458831  \n",
       "59  0.688247  \n",
       "60  0.917662  \n",
       "61   1.14708  \n",
       "62   1.60591  \n",
       "63  0.229416  \n",
       "64  0.458831  \n",
       "65  0.688247  \n",
       "66  0.917662  \n",
       "67   1.37649  \n",
       "68  0.229416  \n",
       "69  0.458831  \n",
       "70  0.688247  \n",
       "71   1.14708  \n",
       "72  0.229416  \n",
       "73  0.458831  \n",
       "74  0.917662  \n",
       "75  0.229416  \n",
       "76  0.688247  \n",
       "77  0.458831  \n",
       "\n",
       "[78 rows x 378 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gind = ref_df[ref_df.RID==rid].index\n",
    "x_tbl = in_df.loc[gind].sort_values('Month_bl',ascending=True)\n",
    "y_tbl = ref_df.loc[x_tbl.index]\n",
    "N_timepoints = len(x_tbl) - 1\n",
    "N_rows = round((N_timepoints * (N_timepoints+1)/2))\n",
    "ycols = [x for x in y_tbl.columns if 'y_' in x]\n",
    "cols = ['RID'] + x_tbl.columns.tolist() + ycols + ['delta_t']\n",
    "final_output = pandas.DataFrame(index=range(N_rows), columns = cols)\n",
    "\n",
    "time_vec = x_tbl['Month'].values\n",
    "cntr = 0\n",
    "cumul = 0\n",
    "while cntr < N_timepoints:\n",
    "    jnk = pandas.concat([x_tbl.loc[x_tbl.index[cntr]],\n",
    "                         y_tbl.loc[y_tbl.index[cntr]][['RID']+ycols]])\n",
    "    row = jnk[cols[:-1]]\n",
    "    iTime = row['Month']\n",
    "    dTs = [x - iTime for x in time_vec[(cntr+1):]]\n",
    "    for i in range(len(dTs)):\n",
    "        final_output.loc[final_output.index[cumul+i],:] = row\n",
    "        final_output.loc[final_output.index[cumul+i],'delta_t'] = dTs[i]\n",
    "    cumul += len(dTs)\n",
    "    cntr += 1\n",
    "final_output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RID</th>\n",
       "      <th>AGE</th>\n",
       "      <th>PTGENDER</th>\n",
       "      <th>PTEDUCAT</th>\n",
       "      <th>PTETHCAT</th>\n",
       "      <th>PTRACCAT</th>\n",
       "      <th>PTMARRY</th>\n",
       "      <th>APOE4</th>\n",
       "      <th>CDRSB</th>\n",
       "      <th>MMSE</th>\n",
       "      <th>...</th>\n",
       "      <th>ST98TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99CV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99SA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16</th>\n",
       "      <th>y_DX</th>\n",
       "      <th>y_ADAS11</th>\n",
       "      <th>y_ADAS13</th>\n",
       "      <th>delta_t</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>0.0695753</td>\n",
       "      <td>-0.87488</td>\n",
       "      <td>0.00410519</td>\n",
       "      <td>-0.172768</td>\n",
       "      <td>-0.253396</td>\n",
       "      <td>-0.48648</td>\n",
       "      <td>-0.819258</td>\n",
       "      <td>-0.772763</td>\n",
       "      <td>0.356549</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0231826</td>\n",
       "      <td>3.17636</td>\n",
       "      <td>2.62717</td>\n",
       "      <td>1.42111</td>\n",
       "      <td>-0.606512</td>\n",
       "      <td>3.28765</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.0839499</td>\n",
       "      <td>0.0988391</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 378 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  RID        AGE PTGENDER    PTEDUCAT  PTETHCAT  PTRACCAT  PTMARRY     APOE4  \\\n",
       "0   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "1   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "2   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "3   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "4   2  0.0695753 -0.87488  0.00410519 -0.172768 -0.253396 -0.48648 -0.819258   \n",
       "\n",
       "      CDRSB      MMSE   ...   ST98TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0 -0.772763  0.356549   ...                                   -0.0231826   \n",
       "1 -0.772763  0.356549   ...                                   -0.0231826   \n",
       "2 -0.772763  0.356549   ...                                   -0.0231826   \n",
       "3 -0.772763  0.356549   ...                                   -0.0231826   \n",
       "4 -0.772763  0.356549   ...                                   -0.0231826   \n",
       "\n",
       "  ST99CV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                    3.17636   \n",
       "1                                    3.17636   \n",
       "2                                    3.17636   \n",
       "3                                    3.17636   \n",
       "4                                    3.17636   \n",
       "\n",
       "  ST99SA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                    2.62717   \n",
       "1                                    2.62717   \n",
       "2                                    2.62717   \n",
       "3                                    2.62717   \n",
       "4                                    2.62717   \n",
       "\n",
       "  ST99TA_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                    1.42111   \n",
       "1                                    1.42111   \n",
       "2                                    1.42111   \n",
       "3                                    1.42111   \n",
       "4                                    1.42111   \n",
       "\n",
       "  ST99TS_UCSFFSX_11_02_15_UCSFFSX51_08_01_16  \\\n",
       "0                                  -0.606512   \n",
       "1                                  -0.606512   \n",
       "2                                  -0.606512   \n",
       "3                                  -0.606512   \n",
       "4                                  -0.606512   \n",
       "\n",
       "  ST9SV_UCSFFSX_11_02_15_UCSFFSX51_08_01_16 y_DX   y_ADAS11   y_ADAS13 delta_t  \n",
       "0                                   3.28765    1 -0.0839499  0.0988391     NaN  \n",
       "1                                   3.28765    1 -0.0839499  0.0988391     NaN  \n",
       "2                                   3.28765    1 -0.0839499  0.0988391     NaN  \n",
       "3                                   3.28765    1 -0.0839499  0.0988391     NaN  \n",
       "4                                   3.28765    1 -0.0839499  0.0988391     NaN  \n",
       "\n",
       "[5 rows x 378 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gind = ref_df[ref_df.RID==rid].index\n",
    "x_tbl = in_df.loc[gind].sort_values('Month_bl',ascending=True)\n",
    "y_tbl = ref_df.loc[x_tbl.index]\n",
    "N_timepoints = len(x_tbl) - 1\n",
    "N_rows = round((N_timepoints * (N_timepoints+1)/2))\n",
    "ycols = [x for x in y_tbl.columns if 'y_' in x]\n",
    "cols = ['RID'] + x_tbl.columns.tolist() + ycols + ['delta_t']\n",
    "cntr=0\n",
    "cumul = 0\n",
    "final_output = pandas.DataFrame(index=range(N_rows), columns = cols)\n",
    "time_vec = x_tbl['Month'].values\n",
    "jnk = pandas.concat([x_tbl.loc[x_tbl.index[cntr]],\n",
    "                             y_tbl.loc[y_tbl.index[cntr]][['RID']+ycols]])\n",
    "row = jnk[cols[:-1]]\n",
    "iTime = row['Month']\n",
    "dTs = [x - iTime for x in time_vec[(cntr+1):]]\n",
    "for i in range(len(dTs)):\n",
    "    final_output.loc[final_output.index[cumul+i],:] = row\n",
    "final_output.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[0.22941559617268381,\n",
       " 1.3764935770361024,\n",
       " 2.2941559617268377,\n",
       " 2.5235715578995213,\n",
       " 2.7529871540722053,\n",
       " 2.9824027502448889,\n",
       " 3.211818346417572,\n",
       " 3.4412339425902561,\n",
       " 3.6706495387629392,\n",
       " 3.9000651349356232,\n",
       " 4.1294807311083073,\n",
       " 4.5883119234536753]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dTs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       -0.997464\n",
       "5723    -0.773404\n",
       "5724     0.359416\n",
       "5725     1.305727\n",
       "5726     1.509757\n",
       "5727     1.758852\n",
       "5728     1.990424\n",
       "5729     2.225748\n",
       "5730     2.451062\n",
       "5731     2.661354\n",
       "10836    2.897938\n",
       "11571    3.160793\n",
       "11959    3.591401\n",
       "Name: Month_bl, dtype: float64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x_tbl['Month_bl']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "13"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "N_timepoints"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "91.0"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(N_timepoints * (N_timepoints+1)/2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda env:py3]",
   "language": "python",
   "name": "conda-env-py3-py"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}