SB25_sample_production.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "import glob\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/aleksandra/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:2: VisibleDeprecationWarning: Reading unicode strings without specifying the encoding argument is deprecated. Set the encoding, use None for the system default.\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>snap</th>\n",
       "      <th>subid</th>\n",
       "      <th>logmstar</th>\n",
       "      <th>cam</th>\n",
       "      <th>merger</th>\n",
       "      <th>rfprob</th>\n",
       "      <th>asym_I</th>\n",
       "      <th>cc_I</th>\n",
       "      <th>g_I</th>\n",
       "      <th>m20_I</th>\n",
       "      <th>mprime_I</th>\n",
       "      <th>asym_H</th>\n",
       "      <th>cc_H</th>\n",
       "      <th>g_H</th>\n",
       "      <th>m20_H</th>\n",
       "      <th>mprime_H</th>\n",
       "      <th>t_lastmaj</th>\n",
       "      <th>t_lastmin</th>\n",
       "      <th>t_nextmaj</th>\n",
       "      <th>t_nextmin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>12.20</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.103'</td>\n",
       "      <td>0.2076</td>\n",
       "      <td>2.9771</td>\n",
       "      <td>0.5534</td>\n",
       "      <td>-1.4073</td>\n",
       "      <td>-1.3047</td>\n",
       "      <td>0.1193</td>\n",
       "      <td>3.6158</td>\n",
       "      <td>0.5952</td>\n",
       "      <td>-1.9186</td>\n",
       "      <td>-1.5796</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>-0.6481</td>\n",
       "      <td>4.4276</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>12.20</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.15'</td>\n",
       "      <td>0.2082</td>\n",
       "      <td>3.6671</td>\n",
       "      <td>0.5881</td>\n",
       "      <td>-1.5640</td>\n",
       "      <td>-1.1394</td>\n",
       "      <td>0.1433</td>\n",
       "      <td>3.8279</td>\n",
       "      <td>0.5921</td>\n",
       "      <td>-1.9774</td>\n",
       "      <td>-1.2196</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>-0.6481</td>\n",
       "      <td>4.4276</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>12.20</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.132'</td>\n",
       "      <td>0.2069</td>\n",
       "      <td>3.6939</td>\n",
       "      <td>0.6117</td>\n",
       "      <td>-1.5015</td>\n",
       "      <td>-1.0887</td>\n",
       "      <td>0.1663</td>\n",
       "      <td>3.8399</td>\n",
       "      <td>0.5917</td>\n",
       "      <td>-1.8892</td>\n",
       "      <td>-1.2522</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>-0.6481</td>\n",
       "      <td>4.4276</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>12.20</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.231'</td>\n",
       "      <td>0.2195</td>\n",
       "      <td>3.2588</td>\n",
       "      <td>0.5904</td>\n",
       "      <td>-1.5522</td>\n",
       "      <td>-1.3975</td>\n",
       "      <td>0.1482</td>\n",
       "      <td>3.8950</td>\n",
       "      <td>0.6085</td>\n",
       "      <td>-2.0038</td>\n",
       "      <td>-1.3152</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>-0.6481</td>\n",
       "      <td>4.4276</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>103</td>\n",
       "      <td>19702</td>\n",
       "      <td>12.12</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.4423</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>103</td>\n",
       "      <td>19702</td>\n",
       "      <td>12.12</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.4423</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>103</td>\n",
       "      <td>19702</td>\n",
       "      <td>12.12</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0592</td>\n",
       "      <td>4.4059</td>\n",
       "      <td>0.6102</td>\n",
       "      <td>-2.3775</td>\n",
       "      <td>-1.5486</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.4423</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>103</td>\n",
       "      <td>19702</td>\n",
       "      <td>12.12</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.4423</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>103</td>\n",
       "      <td>43373</td>\n",
       "      <td>12.06</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9353</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>103</td>\n",
       "      <td>43373</td>\n",
       "      <td>12.06</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9353</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>103</td>\n",
       "      <td>43373</td>\n",
       "      <td>12.06</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0105</td>\n",
       "      <td>4.2868</td>\n",
       "      <td>0.6097</td>\n",
       "      <td>-2.3324</td>\n",
       "      <td>-1.6240</td>\n",
       "      <td>-0.9353</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>103</td>\n",
       "      <td>43373</td>\n",
       "      <td>12.06</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9353</td>\n",
       "      <td>-2.6956</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>103</td>\n",
       "      <td>13971</td>\n",
       "      <td>12.05</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.038'</td>\n",
       "      <td>-0.0624</td>\n",
       "      <td>4.2868</td>\n",
       "      <td>0.6222</td>\n",
       "      <td>-2.3541</td>\n",
       "      <td>-0.0397</td>\n",
       "      <td>0.0027</td>\n",
       "      <td>4.0908</td>\n",
       "      <td>0.5985</td>\n",
       "      <td>-2.2569</td>\n",
       "      <td>-2.1272</td>\n",
       "      <td>-2.6569</td>\n",
       "      <td>-0.7926</td>\n",
       "      <td>1.2301</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>103</td>\n",
       "      <td>13971</td>\n",
       "      <td>12.05</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.026'</td>\n",
       "      <td>-0.0471</td>\n",
       "      <td>4.4755</td>\n",
       "      <td>0.6264</td>\n",
       "      <td>-2.4790</td>\n",
       "      <td>0.0215</td>\n",
       "      <td>0.0126</td>\n",
       "      <td>4.2790</td>\n",
       "      <td>0.6054</td>\n",
       "      <td>-2.3666</td>\n",
       "      <td>-1.8999</td>\n",
       "      <td>-2.6569</td>\n",
       "      <td>-0.7926</td>\n",
       "      <td>1.2301</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>103</td>\n",
       "      <td>13971</td>\n",
       "      <td>12.05</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.025'</td>\n",
       "      <td>-0.0464</td>\n",
       "      <td>4.4747</td>\n",
       "      <td>0.6243</td>\n",
       "      <td>-2.4647</td>\n",
       "      <td>-0.0445</td>\n",
       "      <td>0.0080</td>\n",
       "      <td>4.2911</td>\n",
       "      <td>0.6076</td>\n",
       "      <td>-2.3638</td>\n",
       "      <td>-1.8970</td>\n",
       "      <td>-2.6569</td>\n",
       "      <td>-0.7926</td>\n",
       "      <td>1.2301</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>103</td>\n",
       "      <td>13971</td>\n",
       "      <td>12.05</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.047'</td>\n",
       "      <td>-0.0544</td>\n",
       "      <td>4.3145</td>\n",
       "      <td>0.6180</td>\n",
       "      <td>-2.3520</td>\n",
       "      <td>0.0325</td>\n",
       "      <td>0.0140</td>\n",
       "      <td>4.1353</td>\n",
       "      <td>0.6021</td>\n",
       "      <td>-2.2707</td>\n",
       "      <td>-2.6296</td>\n",
       "      <td>-2.6569</td>\n",
       "      <td>-0.7926</td>\n",
       "      <td>1.2301</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>103</td>\n",
       "      <td>78998</td>\n",
       "      <td>11.98</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0379</td>\n",
       "      <td>4.3673</td>\n",
       "      <td>0.6378</td>\n",
       "      <td>-2.3925</td>\n",
       "      <td>-1.8354</td>\n",
       "      <td>-2.0507</td>\n",
       "      <td>-1.2609</td>\n",
       "      <td>1.5678</td>\n",
       "      <td>1.2301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>103</td>\n",
       "      <td>78998</td>\n",
       "      <td>11.98</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.0507</td>\n",
       "      <td>-1.2609</td>\n",
       "      <td>1.5678</td>\n",
       "      <td>1.2301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>103</td>\n",
       "      <td>78998</td>\n",
       "      <td>11.98</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.086'</td>\n",
       "      <td>0.0195</td>\n",
       "      <td>4.4139</td>\n",
       "      <td>0.5909</td>\n",
       "      <td>-2.1827</td>\n",
       "      <td>0.0245</td>\n",
       "      <td>0.0679</td>\n",
       "      <td>4.3660</td>\n",
       "      <td>0.5881</td>\n",
       "      <td>-2.2781</td>\n",
       "      <td>-1.2278</td>\n",
       "      <td>-2.0507</td>\n",
       "      <td>-1.2609</td>\n",
       "      <td>1.5678</td>\n",
       "      <td>1.2301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>103</td>\n",
       "      <td>78998</td>\n",
       "      <td>11.98</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.105'</td>\n",
       "      <td>0.1266</td>\n",
       "      <td>4.1208</td>\n",
       "      <td>0.5914</td>\n",
       "      <td>-1.6974</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>0.0958</td>\n",
       "      <td>4.1576</td>\n",
       "      <td>0.5779</td>\n",
       "      <td>-2.3461</td>\n",
       "      <td>-1.2298</td>\n",
       "      <td>-2.0507</td>\n",
       "      <td>-1.2609</td>\n",
       "      <td>1.5678</td>\n",
       "      <td>1.2301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>103</td>\n",
       "      <td>36414</td>\n",
       "      <td>11.96</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.198'</td>\n",
       "      <td>0.0438</td>\n",
       "      <td>4.2597</td>\n",
       "      <td>0.6249</td>\n",
       "      <td>-1.0101</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>0.1750</td>\n",
       "      <td>4.2513</td>\n",
       "      <td>0.6115</td>\n",
       "      <td>-1.0323</td>\n",
       "      <td>-0.7541</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.5762</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.7904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>103</td>\n",
       "      <td>36414</td>\n",
       "      <td>11.96</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.167'</td>\n",
       "      <td>0.0821</td>\n",
       "      <td>4.6367</td>\n",
       "      <td>0.6394</td>\n",
       "      <td>-1.6508</td>\n",
       "      <td>-0.8890</td>\n",
       "      <td>0.1627</td>\n",
       "      <td>4.4504</td>\n",
       "      <td>0.6109</td>\n",
       "      <td>-1.7695</td>\n",
       "      <td>-0.8443</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.5762</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.7904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>103</td>\n",
       "      <td>36414</td>\n",
       "      <td>11.96</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1333</td>\n",
       "      <td>4.7103</td>\n",
       "      <td>0.6170</td>\n",
       "      <td>-1.2252</td>\n",
       "      <td>-1.8016</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.5762</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.7904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>103</td>\n",
       "      <td>36414</td>\n",
       "      <td>11.96</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.211'</td>\n",
       "      <td>0.0392</td>\n",
       "      <td>4.3374</td>\n",
       "      <td>0.6478</td>\n",
       "      <td>-1.1414</td>\n",
       "      <td>-0.0619</td>\n",
       "      <td>0.1694</td>\n",
       "      <td>4.3461</td>\n",
       "      <td>0.6182</td>\n",
       "      <td>-1.0623</td>\n",
       "      <td>-0.7466</td>\n",
       "      <td>-0.5016</td>\n",
       "      <td>-1.5762</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.7904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>103</td>\n",
       "      <td>40454</td>\n",
       "      <td>11.95</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'0.189'</td>\n",
       "      <td>-0.0105</td>\n",
       "      <td>4.0671</td>\n",
       "      <td>0.5928</td>\n",
       "      <td>-2.2203</td>\n",
       "      <td>0.0574</td>\n",
       "      <td>0.0923</td>\n",
       "      <td>4.0633</td>\n",
       "      <td>0.5809</td>\n",
       "      <td>-2.2382</td>\n",
       "      <td>-1.1908</td>\n",
       "      <td>-0.1526</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>103</td>\n",
       "      <td>40454</td>\n",
       "      <td>11.95</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'0.083'</td>\n",
       "      <td>-0.0597</td>\n",
       "      <td>4.2663</td>\n",
       "      <td>0.6098</td>\n",
       "      <td>-2.3204</td>\n",
       "      <td>0.0755</td>\n",
       "      <td>0.0457</td>\n",
       "      <td>4.1816</td>\n",
       "      <td>0.5951</td>\n",
       "      <td>-2.2954</td>\n",
       "      <td>-1.4885</td>\n",
       "      <td>-0.1526</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>103</td>\n",
       "      <td>40454</td>\n",
       "      <td>11.95</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'0.116'</td>\n",
       "      <td>-0.0731</td>\n",
       "      <td>4.2533</td>\n",
       "      <td>0.6098</td>\n",
       "      <td>-2.4026</td>\n",
       "      <td>0.0772</td>\n",
       "      <td>0.0221</td>\n",
       "      <td>4.1065</td>\n",
       "      <td>0.6006</td>\n",
       "      <td>-2.3705</td>\n",
       "      <td>-1.5795</td>\n",
       "      <td>-0.1526</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>103</td>\n",
       "      <td>40454</td>\n",
       "      <td>11.95</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'0.096'</td>\n",
       "      <td>-0.0445</td>\n",
       "      <td>4.4050</td>\n",
       "      <td>0.6272</td>\n",
       "      <td>-2.4871</td>\n",
       "      <td>-0.0528</td>\n",
       "      <td>0.0279</td>\n",
       "      <td>4.1364</td>\n",
       "      <td>0.6041</td>\n",
       "      <td>-2.3610</td>\n",
       "      <td>-1.7960</td>\n",
       "      <td>-0.1526</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>103</td>\n",
       "      <td>32867</td>\n",
       "      <td>11.86</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.018'</td>\n",
       "      <td>-0.0165</td>\n",
       "      <td>4.0594</td>\n",
       "      <td>0.6354</td>\n",
       "      <td>-2.1739</td>\n",
       "      <td>-1.8563</td>\n",
       "      <td>0.0151</td>\n",
       "      <td>3.7756</td>\n",
       "      <td>0.6050</td>\n",
       "      <td>-2.0648</td>\n",
       "      <td>-1.6209</td>\n",
       "      <td>-7.2736</td>\n",
       "      <td>-3.2880</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>103</td>\n",
       "      <td>32867</td>\n",
       "      <td>11.86</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.018'</td>\n",
       "      <td>-0.0352</td>\n",
       "      <td>4.2490</td>\n",
       "      <td>0.6508</td>\n",
       "      <td>-2.3026</td>\n",
       "      <td>-2.1759</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>3.7521</td>\n",
       "      <td>0.6078</td>\n",
       "      <td>-2.0902</td>\n",
       "      <td>-1.7530</td>\n",
       "      <td>-7.2736</td>\n",
       "      <td>-3.2880</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71921</th>\n",
       "      <td>54</td>\n",
       "      <td>17300</td>\n",
       "      <td>9.85</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1756</td>\n",
       "      <td>2.5081</td>\n",
       "      <td>0.4422</td>\n",
       "      <td>-1.2873</td>\n",
       "      <td>-0.5442</td>\n",
       "      <td>-0.1850</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2646</td>\n",
       "      <td>-0.7946</td>\n",
       "      <td>1.4696</td>\n",
       "      <td>3.1696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71922</th>\n",
       "      <td>54</td>\n",
       "      <td>17300</td>\n",
       "      <td>9.85</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0303</td>\n",
       "      <td>2.3081</td>\n",
       "      <td>0.4236</td>\n",
       "      <td>-1.2509</td>\n",
       "      <td>-0.5101</td>\n",
       "      <td>-0.1646</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2646</td>\n",
       "      <td>-0.7946</td>\n",
       "      <td>1.4696</td>\n",
       "      <td>3.1696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71923</th>\n",
       "      <td>54</td>\n",
       "      <td>17465</td>\n",
       "      <td>9.85</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0119</td>\n",
       "      <td>2.8635</td>\n",
       "      <td>0.5199</td>\n",
       "      <td>-1.6752</td>\n",
       "      <td>-1.1699</td>\n",
       "      <td>-0.1074</td>\n",
       "      <td>2.7116</td>\n",
       "      <td>0.4975</td>\n",
       "      <td>-1.7232</td>\n",
       "      <td>-0.7889</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>3.9504</td>\n",
       "      <td>0.7125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71924</th>\n",
       "      <td>54</td>\n",
       "      <td>17465</td>\n",
       "      <td>9.85</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0186</td>\n",
       "      <td>2.5366</td>\n",
       "      <td>0.5343</td>\n",
       "      <td>-1.5346</td>\n",
       "      <td>-1.5216</td>\n",
       "      <td>-0.0818</td>\n",
       "      <td>2.4668</td>\n",
       "      <td>0.4468</td>\n",
       "      <td>-1.6562</td>\n",
       "      <td>0.2628</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>3.9504</td>\n",
       "      <td>0.7125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71925</th>\n",
       "      <td>54</td>\n",
       "      <td>17465</td>\n",
       "      <td>9.85</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0506</td>\n",
       "      <td>2.4835</td>\n",
       "      <td>0.4810</td>\n",
       "      <td>-1.3910</td>\n",
       "      <td>-0.8300</td>\n",
       "      <td>-0.0921</td>\n",
       "      <td>2.6643</td>\n",
       "      <td>0.4840</td>\n",
       "      <td>-1.5385</td>\n",
       "      <td>0.2157</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>3.9504</td>\n",
       "      <td>0.7125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71926</th>\n",
       "      <td>54</td>\n",
       "      <td>17465</td>\n",
       "      <td>9.85</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0587</td>\n",
       "      <td>2.9461</td>\n",
       "      <td>0.5459</td>\n",
       "      <td>-1.7019</td>\n",
       "      <td>-0.6214</td>\n",
       "      <td>-0.1562</td>\n",
       "      <td>2.7886</td>\n",
       "      <td>0.4907</td>\n",
       "      <td>-1.6057</td>\n",
       "      <td>-0.6081</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>3.9504</td>\n",
       "      <td>0.7125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71927</th>\n",
       "      <td>54</td>\n",
       "      <td>20951</td>\n",
       "      <td>9.84</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2860</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.6228</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>2.7142</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71928</th>\n",
       "      <td>54</td>\n",
       "      <td>20951</td>\n",
       "      <td>9.84</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.6228</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>2.7142</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71929</th>\n",
       "      <td>54</td>\n",
       "      <td>20951</td>\n",
       "      <td>9.84</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2439</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2818</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.6228</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>2.7142</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71930</th>\n",
       "      <td>54</td>\n",
       "      <td>20951</td>\n",
       "      <td>9.84</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1670</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1958</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.6228</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>2.7142</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71931</th>\n",
       "      <td>54</td>\n",
       "      <td>15866</td>\n",
       "      <td>9.84</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1871</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1683</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1784</td>\n",
       "      <td>-0.5157</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>4.3995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71932</th>\n",
       "      <td>54</td>\n",
       "      <td>15866</td>\n",
       "      <td>9.84</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1844</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1784</td>\n",
       "      <td>-0.5157</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>4.3995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71933</th>\n",
       "      <td>54</td>\n",
       "      <td>15866</td>\n",
       "      <td>9.84</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1725</td>\n",
       "      <td>2.0964</td>\n",
       "      <td>0.5421</td>\n",
       "      <td>-1.0237</td>\n",
       "      <td>0.2481</td>\n",
       "      <td>-0.1222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1784</td>\n",
       "      <td>-0.5157</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>4.3995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71934</th>\n",
       "      <td>54</td>\n",
       "      <td>15866</td>\n",
       "      <td>9.84</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.2295</td>\n",
       "      <td>2.1156</td>\n",
       "      <td>0.5036</td>\n",
       "      <td>-0.9728</td>\n",
       "      <td>-0.1115</td>\n",
       "      <td>-0.1875</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1784</td>\n",
       "      <td>-0.5157</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>4.3995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71935</th>\n",
       "      <td>54</td>\n",
       "      <td>14111</td>\n",
       "      <td>9.83</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0807</td>\n",
       "      <td>2.3977</td>\n",
       "      <td>0.5193</td>\n",
       "      <td>-1.1097</td>\n",
       "      <td>0.2451</td>\n",
       "      <td>-0.2289</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>1.7790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71936</th>\n",
       "      <td>54</td>\n",
       "      <td>14111</td>\n",
       "      <td>9.83</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.2189</td>\n",
       "      <td>1.2521</td>\n",
       "      <td>0.5883</td>\n",
       "      <td>-0.8376</td>\n",
       "      <td>-0.1496</td>\n",
       "      <td>-0.0369</td>\n",
       "      <td>1.5407</td>\n",
       "      <td>0.4958</td>\n",
       "      <td>-0.8232</td>\n",
       "      <td>-0.3500</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>1.7790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71937</th>\n",
       "      <td>54</td>\n",
       "      <td>14111</td>\n",
       "      <td>9.83</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1088</td>\n",
       "      <td>1.3396</td>\n",
       "      <td>0.5891</td>\n",
       "      <td>-0.9187</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0772</td>\n",
       "      <td>1.5231</td>\n",
       "      <td>0.5163</td>\n",
       "      <td>-0.9314</td>\n",
       "      <td>-0.1279</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>1.7790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71938</th>\n",
       "      <td>54</td>\n",
       "      <td>14111</td>\n",
       "      <td>9.83</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1672</td>\n",
       "      <td>1.3093</td>\n",
       "      <td>0.5761</td>\n",
       "      <td>-0.8351</td>\n",
       "      <td>-0.2573</td>\n",
       "      <td>-0.0567</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>0.1514</td>\n",
       "      <td>1.7790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71939</th>\n",
       "      <td>54</td>\n",
       "      <td>9342</td>\n",
       "      <td>9.83</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0965</td>\n",
       "      <td>2.1467</td>\n",
       "      <td>0.4564</td>\n",
       "      <td>-1.0265</td>\n",
       "      <td>-0.4375</td>\n",
       "      <td>-0.1208</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.4378</td>\n",
       "      <td>-0.8272</td>\n",
       "      <td>0.5575</td>\n",
       "      <td>0.2776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71940</th>\n",
       "      <td>54</td>\n",
       "      <td>9342</td>\n",
       "      <td>9.83</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0377</td>\n",
       "      <td>2.2083</td>\n",
       "      <td>0.4545</td>\n",
       "      <td>-0.9753</td>\n",
       "      <td>-0.2581</td>\n",
       "      <td>-0.0658</td>\n",
       "      <td>2.2649</td>\n",
       "      <td>0.4725</td>\n",
       "      <td>-1.1639</td>\n",
       "      <td>0.3140</td>\n",
       "      <td>-0.4378</td>\n",
       "      <td>-0.8272</td>\n",
       "      <td>0.5575</td>\n",
       "      <td>0.2776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71941</th>\n",
       "      <td>54</td>\n",
       "      <td>9342</td>\n",
       "      <td>9.83</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1160</td>\n",
       "      <td>2.2548</td>\n",
       "      <td>0.5036</td>\n",
       "      <td>-1.0414</td>\n",
       "      <td>-0.2474</td>\n",
       "      <td>-0.1381</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.4378</td>\n",
       "      <td>-0.8272</td>\n",
       "      <td>0.5575</td>\n",
       "      <td>0.2776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71942</th>\n",
       "      <td>54</td>\n",
       "      <td>9342</td>\n",
       "      <td>9.83</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1242</td>\n",
       "      <td>2.9443</td>\n",
       "      <td>0.5332</td>\n",
       "      <td>-1.6785</td>\n",
       "      <td>-1.1733</td>\n",
       "      <td>-0.1392</td>\n",
       "      <td>2.6439</td>\n",
       "      <td>0.4978</td>\n",
       "      <td>-1.6148</td>\n",
       "      <td>0.0554</td>\n",
       "      <td>-0.4378</td>\n",
       "      <td>-0.8272</td>\n",
       "      <td>0.5575</td>\n",
       "      <td>0.2776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71943</th>\n",
       "      <td>54</td>\n",
       "      <td>18603</td>\n",
       "      <td>9.83</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0821</td>\n",
       "      <td>2.3498</td>\n",
       "      <td>0.4447</td>\n",
       "      <td>-1.1635</td>\n",
       "      <td>-0.4030</td>\n",
       "      <td>-0.1314</td>\n",
       "      <td>2.4210</td>\n",
       "      <td>0.4367</td>\n",
       "      <td>-1.2390</td>\n",
       "      <td>0.3527</td>\n",
       "      <td>-1.0475</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>10.5717</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71944</th>\n",
       "      <td>54</td>\n",
       "      <td>18603</td>\n",
       "      <td>9.83</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0677</td>\n",
       "      <td>2.2584</td>\n",
       "      <td>0.4647</td>\n",
       "      <td>-1.1589</td>\n",
       "      <td>-0.3472</td>\n",
       "      <td>-0.1574</td>\n",
       "      <td>2.2373</td>\n",
       "      <td>0.3914</td>\n",
       "      <td>-1.3248</td>\n",
       "      <td>0.2375</td>\n",
       "      <td>-1.0475</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>10.5717</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71945</th>\n",
       "      <td>54</td>\n",
       "      <td>18603</td>\n",
       "      <td>9.83</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0722</td>\n",
       "      <td>2.5380</td>\n",
       "      <td>0.4840</td>\n",
       "      <td>-1.4655</td>\n",
       "      <td>-0.8784</td>\n",
       "      <td>-0.1285</td>\n",
       "      <td>2.4036</td>\n",
       "      <td>0.4826</td>\n",
       "      <td>-1.5841</td>\n",
       "      <td>0.3603</td>\n",
       "      <td>-1.0475</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>10.5717</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71946</th>\n",
       "      <td>54</td>\n",
       "      <td>18603</td>\n",
       "      <td>9.83</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0648</td>\n",
       "      <td>2.6204</td>\n",
       "      <td>0.4758</td>\n",
       "      <td>-1.2925</td>\n",
       "      <td>-0.3358</td>\n",
       "      <td>-0.1215</td>\n",
       "      <td>2.2644</td>\n",
       "      <td>0.4750</td>\n",
       "      <td>-1.4103</td>\n",
       "      <td>-0.5217</td>\n",
       "      <td>-1.0475</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>10.5717</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71947</th>\n",
       "      <td>54</td>\n",
       "      <td>8205</td>\n",
       "      <td>9.82</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0134</td>\n",
       "      <td>2.4736</td>\n",
       "      <td>0.4804</td>\n",
       "      <td>-1.5007</td>\n",
       "      <td>-1.1829</td>\n",
       "      <td>-0.1366</td>\n",
       "      <td>2.4745</td>\n",
       "      <td>0.5023</td>\n",
       "      <td>-1.5417</td>\n",
       "      <td>0.2205</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>0.2776</td>\n",
       "      <td>0.6182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71948</th>\n",
       "      <td>54</td>\n",
       "      <td>8205</td>\n",
       "      <td>9.82</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0519</td>\n",
       "      <td>2.4502</td>\n",
       "      <td>0.4625</td>\n",
       "      <td>-1.3560</td>\n",
       "      <td>-0.8130</td>\n",
       "      <td>-0.1186</td>\n",
       "      <td>2.5425</td>\n",
       "      <td>0.4749</td>\n",
       "      <td>-1.5294</td>\n",
       "      <td>0.2499</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>0.2776</td>\n",
       "      <td>0.6182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71949</th>\n",
       "      <td>54</td>\n",
       "      <td>8205</td>\n",
       "      <td>9.82</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1353</td>\n",
       "      <td>2.1423</td>\n",
       "      <td>0.4737</td>\n",
       "      <td>-1.2310</td>\n",
       "      <td>-0.5579</td>\n",
       "      <td>-0.0662</td>\n",
       "      <td>2.2829</td>\n",
       "      <td>0.4540</td>\n",
       "      <td>-1.4985</td>\n",
       "      <td>0.2494</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>0.2776</td>\n",
       "      <td>0.6182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71950</th>\n",
       "      <td>54</td>\n",
       "      <td>8205</td>\n",
       "      <td>9.82</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1309</td>\n",
       "      <td>2.4773</td>\n",
       "      <td>0.4857</td>\n",
       "      <td>-1.3748</td>\n",
       "      <td>-0.6035</td>\n",
       "      <td>-0.1294</td>\n",
       "      <td>2.4766</td>\n",
       "      <td>0.4684</td>\n",
       "      <td>-1.6014</td>\n",
       "      <td>0.2461</td>\n",
       "      <td>-0.3715</td>\n",
       "      <td>-0.5883</td>\n",
       "      <td>0.2776</td>\n",
       "      <td>0.6182</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71951 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       snap  subid  logmstar  cam  merger    rfprob  asym_I    cc_I     g_I  \\\n",
       "0       103      0     12.20    0   False  b'0.103'  0.2076  2.9771  0.5534   \n",
       "1       103      0     12.20    3   False   b'0.15'  0.2082  3.6671  0.5881   \n",
       "2       103      0     12.20    1   False  b'0.132'  0.2069  3.6939  0.6117   \n",
       "3       103      0     12.20    2   False  b'0.231'  0.2195  3.2588  0.5904   \n",
       "4       103  19702     12.12    3   False   b'None'     NaN     NaN     NaN   \n",
       "5       103  19702     12.12    1   False   b'None'     NaN     NaN     NaN   \n",
       "6       103  19702     12.12    0   False   b'None'     NaN     NaN     NaN   \n",
       "7       103  19702     12.12    2   False   b'None'     NaN     NaN     NaN   \n",
       "8       103  43373     12.06    2   False   b'None'     NaN     NaN     NaN   \n",
       "9       103  43373     12.06    1   False   b'None'     NaN     NaN     NaN   \n",
       "10      103  43373     12.06    0   False   b'None'     NaN     NaN     NaN   \n",
       "11      103  43373     12.06    3   False   b'None'     NaN     NaN     NaN   \n",
       "12      103  13971     12.05    3   False  b'0.038' -0.0624  4.2868  0.6222   \n",
       "13      103  13971     12.05    1   False  b'0.026' -0.0471  4.4755  0.6264   \n",
       "14      103  13971     12.05    2   False  b'0.025' -0.0464  4.4747  0.6243   \n",
       "15      103  13971     12.05    0   False  b'0.047' -0.0544  4.3145  0.6180   \n",
       "16      103  78998     11.98    0   False   b'None'     NaN     NaN     NaN   \n",
       "17      103  78998     11.98    2   False   b'None'     NaN     NaN     NaN   \n",
       "18      103  78998     11.98    3   False  b'0.086'  0.0195  4.4139  0.5909   \n",
       "19      103  78998     11.98    1   False  b'0.105'  0.1266  4.1208  0.5914   \n",
       "20      103  36414     11.96    2   False  b'0.198'  0.0438  4.2597  0.6249   \n",
       "21      103  36414     11.96    3   False  b'0.167'  0.0821  4.6367  0.6394   \n",
       "22      103  36414     11.96    1   False   b'None'     NaN     NaN     NaN   \n",
       "23      103  36414     11.96    0   False  b'0.211'  0.0392  4.3374  0.6478   \n",
       "24      103  40454     11.95    0    True  b'0.189' -0.0105  4.0671  0.5928   \n",
       "25      103  40454     11.95    3    True  b'0.083' -0.0597  4.2663  0.6098   \n",
       "26      103  40454     11.95    1    True  b'0.116' -0.0731  4.2533  0.6098   \n",
       "27      103  40454     11.95    2    True  b'0.096' -0.0445  4.4050  0.6272   \n",
       "28      103  32867     11.86    0   False  b'0.018' -0.0165  4.0594  0.6354   \n",
       "29      103  32867     11.86    2   False  b'0.018' -0.0352  4.2490  0.6508   \n",
       "...     ...    ...       ...  ...     ...       ...     ...     ...     ...   \n",
       "71921    54  17300      9.85    3   False   b'None' -0.1756  2.5081  0.4422   \n",
       "71922    54  17300      9.85    0   False   b'None' -0.0303  2.3081  0.4236   \n",
       "71923    54  17465      9.85    2   False   b'None'  0.0119  2.8635  0.5199   \n",
       "71924    54  17465      9.85    3   False   b'None' -0.0186  2.5366  0.5343   \n",
       "71925    54  17465      9.85    1   False   b'None' -0.0506  2.4835  0.4810   \n",
       "71926    54  17465      9.85    0   False   b'None' -0.0587  2.9461  0.5459   \n",
       "71927    54  20951      9.84    3   False   b'None' -0.2860     NaN     NaN   \n",
       "71928    54  20951      9.84    2   False   b'None' -0.2563     NaN     NaN   \n",
       "71929    54  20951      9.84    0   False   b'None' -0.2439     NaN     NaN   \n",
       "71930    54  20951      9.84    1   False   b'None' -0.1670     NaN     NaN   \n",
       "71931    54  15866      9.84    1    True   b'None'  0.1871     NaN     NaN   \n",
       "71932    54  15866      9.84    3    True   b'None'  0.0825     NaN     NaN   \n",
       "71933    54  15866      9.84    2    True   b'None'  0.1725  2.0964  0.5421   \n",
       "71934    54  15866      9.84    0    True   b'None'  0.2295  2.1156  0.5036   \n",
       "71935    54  14111      9.83    2    True   b'None'  0.0807  2.3977  0.5193   \n",
       "71936    54  14111      9.83    1    True   b'None'  0.2189  1.2521  0.5883   \n",
       "71937    54  14111      9.83    3    True   b'None'  0.1088  1.3396  0.5891   \n",
       "71938    54  14111      9.83    0    True   b'None'  0.1672  1.3093  0.5761   \n",
       "71939    54   9342      9.83    3   False   b'None'  0.0965  2.1467  0.4564   \n",
       "71940    54   9342      9.83    1   False   b'None'  0.0377  2.2083  0.4545   \n",
       "71941    54   9342      9.83    2   False   b'None'  0.1160  2.2548  0.5036   \n",
       "71942    54   9342      9.83    0   False   b'None'  0.1242  2.9443  0.5332   \n",
       "71943    54  18603      9.83    3   False   b'None' -0.0821  2.3498  0.4447   \n",
       "71944    54  18603      9.83    1   False   b'None' -0.0677  2.2584  0.4647   \n",
       "71945    54  18603      9.83    0   False   b'None' -0.0722  2.5380  0.4840   \n",
       "71946    54  18603      9.83    2   False   b'None' -0.0648  2.6204  0.4758   \n",
       "71947    54   8205      9.82    1   False   b'None'  0.0134  2.4736  0.4804   \n",
       "71948    54   8205      9.82    3   False   b'None'  0.0519  2.4502  0.4625   \n",
       "71949    54   8205      9.82    2   False   b'None'  0.1353  2.1423  0.4737   \n",
       "71950    54   8205      9.82    0   False   b'None'  0.1309  2.4773  0.4857   \n",
       "\n",
       "        m20_I  mprime_I  asym_H    cc_H     g_H   m20_H  mprime_H  t_lastmaj  \\\n",
       "0     -1.4073   -1.3047  0.1193  3.6158  0.5952 -1.9186   -1.5796    -2.6956   \n",
       "1     -1.5640   -1.1394  0.1433  3.8279  0.5921 -1.9774   -1.2196    -2.6956   \n",
       "2     -1.5015   -1.0887  0.1663  3.8399  0.5917 -1.8892   -1.2522    -2.6956   \n",
       "3     -1.5522   -1.3975  0.1482  3.8950  0.6085 -2.0038   -1.3152    -2.6956   \n",
       "4         NaN       NaN     NaN     NaN     NaN     NaN       NaN    -0.5016   \n",
       "5         NaN       NaN     NaN     NaN     NaN     NaN       NaN    -0.5016   \n",
       "6         NaN       NaN  0.0592  4.4059  0.6102 -2.3775   -1.5486    -0.5016   \n",
       "7         NaN       NaN     NaN     NaN     NaN     NaN       NaN    -0.5016   \n",
       "8         NaN       NaN     NaN     NaN     NaN     NaN       NaN    -0.9353   \n",
       "9         NaN       NaN     NaN     NaN     NaN     NaN       NaN    -0.9353   \n",
       "10        NaN       NaN  0.0105  4.2868  0.6097 -2.3324   -1.6240    -0.9353   \n",
       "11        NaN       NaN     NaN     NaN     NaN     NaN       NaN    -0.9353   \n",
       "12    -2.3541   -0.0397  0.0027  4.0908  0.5985 -2.2569   -2.1272    -2.6569   \n",
       "13    -2.4790    0.0215  0.0126  4.2790  0.6054 -2.3666   -1.8999    -2.6569   \n",
       "14    -2.4647   -0.0445  0.0080  4.2911  0.6076 -2.3638   -1.8970    -2.6569   \n",
       "15    -2.3520    0.0325  0.0140  4.1353  0.6021 -2.2707   -2.6296    -2.6569   \n",
       "16        NaN       NaN  0.0379  4.3673  0.6378 -2.3925   -1.8354    -2.0507   \n",
       "17        NaN       NaN     NaN     NaN     NaN     NaN       NaN    -2.0507   \n",
       "18    -2.1827    0.0245  0.0679  4.3660  0.5881 -2.2781   -1.2278    -2.0507   \n",
       "19    -1.6974    0.1514  0.0958  4.1576  0.5779 -2.3461   -1.2298    -2.0507   \n",
       "20    -1.0101   -0.0012  0.1750  4.2513  0.6115 -1.0323   -0.7541    -0.5016   \n",
       "21    -1.6508   -0.8890  0.1627  4.4504  0.6109 -1.7695   -0.8443    -0.5016   \n",
       "22        NaN       NaN  0.1333  4.7103  0.6170 -1.2252   -1.8016    -0.5016   \n",
       "23    -1.1414   -0.0619  0.1694  4.3461  0.6182 -1.0623   -0.7466    -0.5016   \n",
       "24    -2.2203    0.0574  0.0923  4.0633  0.5809 -2.2382   -1.1908    -0.1526   \n",
       "25    -2.3204    0.0755  0.0457  4.1816  0.5951 -2.2954   -1.4885    -0.1526   \n",
       "26    -2.4026    0.0772  0.0221  4.1065  0.6006 -2.3705   -1.5795    -0.1526   \n",
       "27    -2.4871   -0.0528  0.0279  4.1364  0.6041 -2.3610   -1.7960    -0.1526   \n",
       "28    -2.1739   -1.8563  0.0151  3.7756  0.6050 -2.0648   -1.6209    -7.2736   \n",
       "29    -2.3026   -2.1759  0.0078  3.7521  0.6078 -2.0902   -1.7530    -7.2736   \n",
       "...       ...       ...     ...     ...     ...     ...       ...        ...   \n",
       "71921 -1.2873   -0.5442 -0.1850     NaN     NaN     NaN       NaN    -0.2646   \n",
       "71922 -1.2509   -0.5101 -0.1646     NaN     NaN     NaN       NaN    -0.2646   \n",
       "71923 -1.6752   -1.1699 -0.1074  2.7116  0.4975 -1.7232   -0.7889    -0.5883   \n",
       "71924 -1.5346   -1.5216 -0.0818  2.4668  0.4468 -1.6562    0.2628    -0.5883   \n",
       "71925 -1.3910   -0.8300 -0.0921  2.6643  0.4840 -1.5385    0.2157    -0.5883   \n",
       "71926 -1.7019   -0.6214 -0.1562  2.7886  0.4907 -1.6057   -0.6081    -0.5883   \n",
       "71927     NaN       NaN -0.2153     NaN     NaN     NaN       NaN    -0.6228   \n",
       "71928     NaN       NaN -0.2153     NaN     NaN     NaN       NaN    -0.6228   \n",
       "71929     NaN       NaN -0.2818     NaN     NaN     NaN       NaN    -0.6228   \n",
       "71930     NaN       NaN -0.1958     NaN     NaN     NaN       NaN    -0.6228   \n",
       "71931     NaN       NaN -0.1683     NaN     NaN     NaN       NaN    -0.1784   \n",
       "71932     NaN       NaN -0.1844     NaN     NaN     NaN       NaN    -0.1784   \n",
       "71933 -1.0237    0.2481 -0.1222     NaN     NaN     NaN       NaN    -0.1784   \n",
       "71934 -0.9728   -0.1115 -0.1875     NaN     NaN     NaN       NaN    -0.1784   \n",
       "71935 -1.1097    0.2451 -0.2289     NaN     NaN     NaN       NaN    -0.3715   \n",
       "71936 -0.8376   -0.1496 -0.0369  1.5407  0.4958 -0.8232   -0.3500    -0.3715   \n",
       "71937 -0.9187   -0.0009 -0.0772  1.5231  0.5163 -0.9314   -0.1279    -0.3715   \n",
       "71938 -0.8351   -0.2573 -0.0567     NaN     NaN     NaN       NaN    -0.3715   \n",
       "71939 -1.0265   -0.4375 -0.1208     NaN     NaN     NaN       NaN    -0.4378   \n",
       "71940 -0.9753   -0.2581 -0.0658  2.2649  0.4725 -1.1639    0.3140    -0.4378   \n",
       "71941 -1.0414   -0.2474 -0.1381     NaN     NaN     NaN       NaN    -0.4378   \n",
       "71942 -1.6785   -1.1733 -0.1392  2.6439  0.4978 -1.6148    0.0554    -0.4378   \n",
       "71943 -1.1635   -0.4030 -0.1314  2.4210  0.4367 -1.2390    0.3527    -1.0475   \n",
       "71944 -1.1589   -0.3472 -0.1574  2.2373  0.3914 -1.3248    0.2375    -1.0475   \n",
       "71945 -1.4655   -0.8784 -0.1285  2.4036  0.4826 -1.5841    0.3603    -1.0475   \n",
       "71946 -1.2925   -0.3358 -0.1215  2.2644  0.4750 -1.4103   -0.5217    -1.0475   \n",
       "71947 -1.5007   -1.1829 -0.1366  2.4745  0.5023 -1.5417    0.2205    -0.3715   \n",
       "71948 -1.3560   -0.8130 -0.1186  2.5425  0.4749 -1.5294    0.2499    -0.3715   \n",
       "71949 -1.2310   -0.5579 -0.0662  2.2829  0.4540 -1.4985    0.2494    -0.3715   \n",
       "71950 -1.3748   -0.6035 -0.1294  2.4766  0.4684 -1.6014    0.2461    -0.3715   \n",
       "\n",
       "       t_lastmin  t_nextmaj  t_nextmin  \n",
       "0        -0.6481     4.4276    50.0000  \n",
       "1        -0.6481     4.4276    50.0000  \n",
       "2        -0.6481     4.4276    50.0000  \n",
       "3        -0.6481     4.4276    50.0000  \n",
       "4        -1.4423    50.0000    50.0000  \n",
       "5        -1.4423    50.0000    50.0000  \n",
       "6        -1.4423    50.0000    50.0000  \n",
       "7        -1.4423    50.0000    50.0000  \n",
       "8        -2.6956    50.0000    50.0000  \n",
       "9        -2.6956    50.0000    50.0000  \n",
       "10       -2.6956    50.0000    50.0000  \n",
       "11       -2.6956    50.0000    50.0000  \n",
       "12       -0.7926     1.2301    50.0000  \n",
       "13       -0.7926     1.2301    50.0000  \n",
       "14       -0.7926     1.2301    50.0000  \n",
       "15       -0.7926     1.2301    50.0000  \n",
       "16       -1.2609     1.5678     1.2301  \n",
       "17       -1.2609     1.5678     1.2301  \n",
       "18       -1.2609     1.5678     1.2301  \n",
       "19       -1.2609     1.5678     1.2301  \n",
       "20       -1.5762    50.0000     0.7904  \n",
       "21       -1.5762    50.0000     0.7904  \n",
       "22       -1.5762    50.0000     0.7904  \n",
       "23       -1.5762    50.0000     0.7904  \n",
       "24      -50.0000    50.0000    50.0000  \n",
       "25      -50.0000    50.0000    50.0000  \n",
       "26      -50.0000    50.0000    50.0000  \n",
       "27      -50.0000    50.0000    50.0000  \n",
       "28       -3.2880    50.0000    50.0000  \n",
       "29       -3.2880    50.0000    50.0000  \n",
       "...          ...        ...        ...  \n",
       "71921    -0.7946     1.4696     3.1696  \n",
       "71922    -0.7946     1.4696     3.1696  \n",
       "71923   -50.0000     3.9504     0.7125  \n",
       "71924   -50.0000     3.9504     0.7125  \n",
       "71925   -50.0000     3.9504     0.7125  \n",
       "71926   -50.0000     3.9504     0.7125  \n",
       "71927   -50.0000     2.7142    50.0000  \n",
       "71928   -50.0000     2.7142    50.0000  \n",
       "71929   -50.0000     2.7142    50.0000  \n",
       "71930   -50.0000     2.7142    50.0000  \n",
       "71931    -0.5157     0.1514     4.3995  \n",
       "71932    -0.5157     0.1514     4.3995  \n",
       "71933    -0.5157     0.1514     4.3995  \n",
       "71934    -0.5157     0.1514     4.3995  \n",
       "71935    -0.3715     0.1514     1.7790  \n",
       "71936    -0.3715     0.1514     1.7790  \n",
       "71937    -0.3715     0.1514     1.7790  \n",
       "71938    -0.3715     0.1514     1.7790  \n",
       "71939    -0.8272     0.5575     0.2776  \n",
       "71940    -0.8272     0.5575     0.2776  \n",
       "71941    -0.8272     0.5575     0.2776  \n",
       "71942    -0.8272     0.5575     0.2776  \n",
       "71943   -50.0000    10.5717    50.0000  \n",
       "71944   -50.0000    10.5717    50.0000  \n",
       "71945   -50.0000    10.5717    50.0000  \n",
       "71946   -50.0000    10.5717    50.0000  \n",
       "71947    -0.5883     0.2776     0.6182  \n",
       "71948    -0.5883     0.2776     0.6182  \n",
       "71949    -0.5883     0.2776     0.6182  \n",
       "71950    -0.5883     0.2776     0.6182  \n",
       "\n",
       "[71951 rows x 20 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# importing Illustris catalog\n",
    "catalog_new = []\n",
    "catalog_new = np.genfromtxt('illustris_morphs_rf.txt', dtype=None)\n",
    "catalog = pd.DataFrame(catalog_new)\n",
    "catalog.columns =  ['snap','subid','logmstar','cam','merger','rfprob','asym_I','cc_I','g_I','m20_I','mprime_I','asym_H','cc_H','g_H','m20_H','mprime_H','t_lastmaj','t_lastmin','t_nextmaj','t_nextmin']\n",
    "catalog"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>snap</th>\n",
       "      <th>subid</th>\n",
       "      <th>logmstar</th>\n",
       "      <th>cam</th>\n",
       "      <th>merger</th>\n",
       "      <th>rfprob</th>\n",
       "      <th>asym_I</th>\n",
       "      <th>cc_I</th>\n",
       "      <th>g_I</th>\n",
       "      <th>m20_I</th>\n",
       "      <th>mprime_I</th>\n",
       "      <th>asym_H</th>\n",
       "      <th>cc_H</th>\n",
       "      <th>g_H</th>\n",
       "      <th>m20_H</th>\n",
       "      <th>mprime_H</th>\n",
       "      <th>t_lastmaj</th>\n",
       "      <th>t_lastmin</th>\n",
       "      <th>t_nextmaj</th>\n",
       "      <th>t_nextmin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>52329</th>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>11.88</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0860</td>\n",
       "      <td>2.8530</td>\n",
       "      <td>0.5463</td>\n",
       "      <td>-1.8116</td>\n",
       "      <td>-1.3221</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52330</th>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>11.88</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0738</td>\n",
       "      <td>2.8770</td>\n",
       "      <td>0.5526</td>\n",
       "      <td>-1.7441</td>\n",
       "      <td>-1.3423</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52331</th>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>11.88</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0911</td>\n",
       "      <td>2.8247</td>\n",
       "      <td>0.5340</td>\n",
       "      <td>-1.7679</td>\n",
       "      <td>-1.3116</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52332</th>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>11.88</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0769</td>\n",
       "      <td>2.7880</td>\n",
       "      <td>0.5358</td>\n",
       "      <td>-1.7708</td>\n",
       "      <td>-1.3380</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>-0.4537</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52333</th>\n",
       "      <td>68</td>\n",
       "      <td>14557</td>\n",
       "      <td>11.63</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.221'</td>\n",
       "      <td>0.1312</td>\n",
       "      <td>3.4661</td>\n",
       "      <td>0.4992</td>\n",
       "      <td>-1.9007</td>\n",
       "      <td>-0.8344</td>\n",
       "      <td>0.0462</td>\n",
       "      <td>3.7150</td>\n",
       "      <td>0.5528</td>\n",
       "      <td>-2.0840</td>\n",
       "      <td>-1.5967</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52334</th>\n",
       "      <td>68</td>\n",
       "      <td>14557</td>\n",
       "      <td>11.63</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.207'</td>\n",
       "      <td>0.1132</td>\n",
       "      <td>3.0883</td>\n",
       "      <td>0.4962</td>\n",
       "      <td>-1.7102</td>\n",
       "      <td>-0.7281</td>\n",
       "      <td>0.0476</td>\n",
       "      <td>3.5797</td>\n",
       "      <td>0.5522</td>\n",
       "      <td>-2.0131</td>\n",
       "      <td>-1.7615</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52335</th>\n",
       "      <td>68</td>\n",
       "      <td>14557</td>\n",
       "      <td>11.63</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.195'</td>\n",
       "      <td>0.1095</td>\n",
       "      <td>2.7629</td>\n",
       "      <td>0.5025</td>\n",
       "      <td>-1.5272</td>\n",
       "      <td>-0.7947</td>\n",
       "      <td>0.0583</td>\n",
       "      <td>3.5036</td>\n",
       "      <td>0.5515</td>\n",
       "      <td>-1.8905</td>\n",
       "      <td>-1.4630</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52336</th>\n",
       "      <td>68</td>\n",
       "      <td>14557</td>\n",
       "      <td>11.63</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.275'</td>\n",
       "      <td>0.2138</td>\n",
       "      <td>2.9266</td>\n",
       "      <td>0.5954</td>\n",
       "      <td>-1.3055</td>\n",
       "      <td>-0.5015</td>\n",
       "      <td>0.0927</td>\n",
       "      <td>3.3504</td>\n",
       "      <td>0.5666</td>\n",
       "      <td>-1.6880</td>\n",
       "      <td>-1.1086</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>3.4351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52337</th>\n",
       "      <td>68</td>\n",
       "      <td>8570</td>\n",
       "      <td>11.63</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.273'</td>\n",
       "      <td>-0.6021</td>\n",
       "      <td>0.6721</td>\n",
       "      <td>0.0951</td>\n",
       "      <td>-0.4960</td>\n",
       "      <td>-0.3950</td>\n",
       "      <td>0.1673</td>\n",
       "      <td>3.9753</td>\n",
       "      <td>0.6344</td>\n",
       "      <td>-1.9124</td>\n",
       "      <td>-1.1006</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>0.9353</td>\n",
       "      <td>0.3135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52338</th>\n",
       "      <td>68</td>\n",
       "      <td>8570</td>\n",
       "      <td>11.63</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.27'</td>\n",
       "      <td>0.4431</td>\n",
       "      <td>2.6273</td>\n",
       "      <td>0.4885</td>\n",
       "      <td>-1.6503</td>\n",
       "      <td>-0.6934</td>\n",
       "      <td>0.1759</td>\n",
       "      <td>3.4431</td>\n",
       "      <td>0.5366</td>\n",
       "      <td>-2.0412</td>\n",
       "      <td>-1.4432</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>0.9353</td>\n",
       "      <td>0.3135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52339</th>\n",
       "      <td>68</td>\n",
       "      <td>8570</td>\n",
       "      <td>11.63</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.485'</td>\n",
       "      <td>0.4396</td>\n",
       "      <td>2.9208</td>\n",
       "      <td>0.5291</td>\n",
       "      <td>-1.5634</td>\n",
       "      <td>-0.6355</td>\n",
       "      <td>0.2126</td>\n",
       "      <td>3.8730</td>\n",
       "      <td>0.5906</td>\n",
       "      <td>-2.0981</td>\n",
       "      <td>-1.0879</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>0.9353</td>\n",
       "      <td>0.3135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52340</th>\n",
       "      <td>68</td>\n",
       "      <td>8570</td>\n",
       "      <td>11.63</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.655'</td>\n",
       "      <td>0.4320</td>\n",
       "      <td>3.0696</td>\n",
       "      <td>0.4940</td>\n",
       "      <td>-1.6687</td>\n",
       "      <td>-0.8754</td>\n",
       "      <td>0.2295</td>\n",
       "      <td>4.0034</td>\n",
       "      <td>0.6102</td>\n",
       "      <td>-1.8203</td>\n",
       "      <td>-0.8723</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>0.9353</td>\n",
       "      <td>0.3135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52341</th>\n",
       "      <td>68</td>\n",
       "      <td>2686</td>\n",
       "      <td>11.62</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.8725</td>\n",
       "      <td>2.0708</td>\n",
       "      <td>0.5285</td>\n",
       "      <td>-1.9369</td>\n",
       "      <td>-0.7782</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-2.2168</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.8536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52342</th>\n",
       "      <td>68</td>\n",
       "      <td>2686</td>\n",
       "      <td>11.62</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'0.765'</td>\n",
       "      <td>0.2437</td>\n",
       "      <td>3.2549</td>\n",
       "      <td>0.5334</td>\n",
       "      <td>-1.4550</td>\n",
       "      <td>-0.8017</td>\n",
       "      <td>0.2029</td>\n",
       "      <td>4.3633</td>\n",
       "      <td>0.6163</td>\n",
       "      <td>-1.9058</td>\n",
       "      <td>-0.9717</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-2.2168</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.8536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52343</th>\n",
       "      <td>68</td>\n",
       "      <td>2686</td>\n",
       "      <td>11.62</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'0.636'</td>\n",
       "      <td>0.9986</td>\n",
       "      <td>2.4079</td>\n",
       "      <td>0.5902</td>\n",
       "      <td>-1.3086</td>\n",
       "      <td>-1.0770</td>\n",
       "      <td>0.2155</td>\n",
       "      <td>4.1102</td>\n",
       "      <td>0.5767</td>\n",
       "      <td>-1.3512</td>\n",
       "      <td>-1.1049</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-2.2168</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.8536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52344</th>\n",
       "      <td>68</td>\n",
       "      <td>2686</td>\n",
       "      <td>11.62</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'0.724'</td>\n",
       "      <td>0.6844</td>\n",
       "      <td>2.8050</td>\n",
       "      <td>0.6691</td>\n",
       "      <td>-0.9981</td>\n",
       "      <td>-0.4955</td>\n",
       "      <td>0.3281</td>\n",
       "      <td>5.1337</td>\n",
       "      <td>0.6391</td>\n",
       "      <td>-1.5259</td>\n",
       "      <td>-0.4535</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-2.2168</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.8536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52345</th>\n",
       "      <td>68</td>\n",
       "      <td>1350</td>\n",
       "      <td>11.61</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1078</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0621</td>\n",
       "      <td>4.3167</td>\n",
       "      <td>0.6298</td>\n",
       "      <td>-2.3381</td>\n",
       "      <td>-1.2935</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.2215</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>2.0282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52346</th>\n",
       "      <td>68</td>\n",
       "      <td>1350</td>\n",
       "      <td>11.61</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1380</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0504</td>\n",
       "      <td>3.4624</td>\n",
       "      <td>0.6457</td>\n",
       "      <td>-2.0902</td>\n",
       "      <td>-1.4338</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.2215</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>2.0282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52347</th>\n",
       "      <td>68</td>\n",
       "      <td>1350</td>\n",
       "      <td>11.61</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.2347</td>\n",
       "      <td>3.2405</td>\n",
       "      <td>0.5779</td>\n",
       "      <td>-0.8722</td>\n",
       "      <td>-0.7554</td>\n",
       "      <td>0.0769</td>\n",
       "      <td>3.8399</td>\n",
       "      <td>0.5986</td>\n",
       "      <td>-2.0689</td>\n",
       "      <td>-1.7189</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.2215</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>2.0282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52348</th>\n",
       "      <td>68</td>\n",
       "      <td>1350</td>\n",
       "      <td>11.61</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0987</td>\n",
       "      <td>4.0067</td>\n",
       "      <td>0.6213</td>\n",
       "      <td>-1.6829</td>\n",
       "      <td>-1.5064</td>\n",
       "      <td>-1.9574</td>\n",
       "      <td>-1.2215</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>2.0282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52349</th>\n",
       "      <td>68</td>\n",
       "      <td>7748</td>\n",
       "      <td>11.60</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.391'</td>\n",
       "      <td>0.2404</td>\n",
       "      <td>1.7160</td>\n",
       "      <td>0.4526</td>\n",
       "      <td>-0.9998</td>\n",
       "      <td>-0.2279</td>\n",
       "      <td>0.0945</td>\n",
       "      <td>4.0245</td>\n",
       "      <td>0.6182</td>\n",
       "      <td>-1.7138</td>\n",
       "      <td>-1.8461</td>\n",
       "      <td>-2.1504</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>9.2959</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52350</th>\n",
       "      <td>68</td>\n",
       "      <td>7748</td>\n",
       "      <td>11.60</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.211'</td>\n",
       "      <td>0.1412</td>\n",
       "      <td>2.5814</td>\n",
       "      <td>0.6074</td>\n",
       "      <td>-1.0677</td>\n",
       "      <td>-0.3708</td>\n",
       "      <td>0.0534</td>\n",
       "      <td>3.2450</td>\n",
       "      <td>0.5805</td>\n",
       "      <td>-1.8607</td>\n",
       "      <td>-1.3549</td>\n",
       "      <td>-2.1504</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>9.2959</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52351</th>\n",
       "      <td>68</td>\n",
       "      <td>7748</td>\n",
       "      <td>11.60</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.147'</td>\n",
       "      <td>0.1113</td>\n",
       "      <td>2.6797</td>\n",
       "      <td>0.5548</td>\n",
       "      <td>-1.3055</td>\n",
       "      <td>-0.3664</td>\n",
       "      <td>0.0196</td>\n",
       "      <td>3.0137</td>\n",
       "      <td>0.5644</td>\n",
       "      <td>-1.6914</td>\n",
       "      <td>-1.2262</td>\n",
       "      <td>-2.1504</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>9.2959</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52352</th>\n",
       "      <td>68</td>\n",
       "      <td>7748</td>\n",
       "      <td>11.60</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.164'</td>\n",
       "      <td>0.2041</td>\n",
       "      <td>1.8517</td>\n",
       "      <td>0.4032</td>\n",
       "      <td>-1.0093</td>\n",
       "      <td>-0.3782</td>\n",
       "      <td>0.0248</td>\n",
       "      <td>3.0554</td>\n",
       "      <td>0.5499</td>\n",
       "      <td>-1.8295</td>\n",
       "      <td>-1.3038</td>\n",
       "      <td>-2.1504</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>9.2959</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52353</th>\n",
       "      <td>68</td>\n",
       "      <td>4404</td>\n",
       "      <td>11.59</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0270</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0163</td>\n",
       "      <td>3.8090</td>\n",
       "      <td>0.5247</td>\n",
       "      <td>-2.1838</td>\n",
       "      <td>-1.5408</td>\n",
       "      <td>-1.1608</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.5517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52354</th>\n",
       "      <td>68</td>\n",
       "      <td>4404</td>\n",
       "      <td>11.59</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0320</td>\n",
       "      <td>1.7845</td>\n",
       "      <td>0.3823</td>\n",
       "      <td>-0.7767</td>\n",
       "      <td>0.0303</td>\n",
       "      <td>0.0061</td>\n",
       "      <td>3.9463</td>\n",
       "      <td>0.5315</td>\n",
       "      <td>-2.3210</td>\n",
       "      <td>-1.8787</td>\n",
       "      <td>-1.1608</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.5517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52355</th>\n",
       "      <td>68</td>\n",
       "      <td>4404</td>\n",
       "      <td>11.59</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.123'</td>\n",
       "      <td>0.0201</td>\n",
       "      <td>2.3442</td>\n",
       "      <td>0.3847</td>\n",
       "      <td>-0.7353</td>\n",
       "      <td>-1.1846</td>\n",
       "      <td>0.0279</td>\n",
       "      <td>3.7781</td>\n",
       "      <td>0.5359</td>\n",
       "      <td>-2.1316</td>\n",
       "      <td>-1.4345</td>\n",
       "      <td>-1.1608</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.5517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52356</th>\n",
       "      <td>68</td>\n",
       "      <td>4404</td>\n",
       "      <td>11.59</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.114'</td>\n",
       "      <td>0.0045</td>\n",
       "      <td>2.3613</td>\n",
       "      <td>0.3922</td>\n",
       "      <td>-0.6922</td>\n",
       "      <td>-0.0358</td>\n",
       "      <td>0.0266</td>\n",
       "      <td>3.7023</td>\n",
       "      <td>0.5449</td>\n",
       "      <td>-2.1251</td>\n",
       "      <td>-1.9365</td>\n",
       "      <td>-1.1608</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>1.5517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52357</th>\n",
       "      <td>68</td>\n",
       "      <td>19310</td>\n",
       "      <td>11.52</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.331'</td>\n",
       "      <td>0.5088</td>\n",
       "      <td>3.5609</td>\n",
       "      <td>0.5309</td>\n",
       "      <td>-1.0555</td>\n",
       "      <td>-0.9192</td>\n",
       "      <td>0.1999</td>\n",
       "      <td>3.4210</td>\n",
       "      <td>0.5098</td>\n",
       "      <td>-2.0113</td>\n",
       "      <td>-1.3400</td>\n",
       "      <td>-2.1504</td>\n",
       "      <td>-1.2215</td>\n",
       "      <td>2.6593</td>\n",
       "      <td>1.3906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52358</th>\n",
       "      <td>68</td>\n",
       "      <td>19310</td>\n",
       "      <td>11.52</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'0.264'</td>\n",
       "      <td>0.5380</td>\n",
       "      <td>2.8762</td>\n",
       "      <td>0.5909</td>\n",
       "      <td>-0.9925</td>\n",
       "      <td>-0.6161</td>\n",
       "      <td>0.2448</td>\n",
       "      <td>3.2502</td>\n",
       "      <td>0.5138</td>\n",
       "      <td>-1.7854</td>\n",
       "      <td>-1.6130</td>\n",
       "      <td>-2.1504</td>\n",
       "      <td>-1.2215</td>\n",
       "      <td>2.6593</td>\n",
       "      <td>1.3906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61229</th>\n",
       "      <td>68</td>\n",
       "      <td>77158</td>\n",
       "      <td>9.86</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1517</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0541</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.4672</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61230</th>\n",
       "      <td>68</td>\n",
       "      <td>77158</td>\n",
       "      <td>9.86</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2482</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.4672</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61231</th>\n",
       "      <td>68</td>\n",
       "      <td>181428</td>\n",
       "      <td>9.86</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0136</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1042</td>\n",
       "      <td>2.6964</td>\n",
       "      <td>0.4884</td>\n",
       "      <td>-1.5243</td>\n",
       "      <td>0.2589</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>-2.8264</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61232</th>\n",
       "      <td>68</td>\n",
       "      <td>181428</td>\n",
       "      <td>9.86</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2104</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>-2.8264</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61233</th>\n",
       "      <td>68</td>\n",
       "      <td>181428</td>\n",
       "      <td>9.86</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1519</td>\n",
       "      <td>2.8167</td>\n",
       "      <td>0.4813</td>\n",
       "      <td>-1.3079</td>\n",
       "      <td>0.2647</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>-2.8264</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61234</th>\n",
       "      <td>68</td>\n",
       "      <td>181428</td>\n",
       "      <td>9.86</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1097</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1851</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>-2.8264</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61235</th>\n",
       "      <td>68</td>\n",
       "      <td>170391</td>\n",
       "      <td>9.86</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0900</td>\n",
       "      <td>2.4091</td>\n",
       "      <td>0.4726</td>\n",
       "      <td>-1.4757</td>\n",
       "      <td>0.2467</td>\n",
       "      <td>-0.0814</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61236</th>\n",
       "      <td>68</td>\n",
       "      <td>170391</td>\n",
       "      <td>9.86</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1245</td>\n",
       "      <td>2.5646</td>\n",
       "      <td>0.5008</td>\n",
       "      <td>-1.3884</td>\n",
       "      <td>0.2365</td>\n",
       "      <td>-0.1254</td>\n",
       "      <td>2.6233</td>\n",
       "      <td>0.4581</td>\n",
       "      <td>-1.6221</td>\n",
       "      <td>0.1883</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61237</th>\n",
       "      <td>68</td>\n",
       "      <td>170391</td>\n",
       "      <td>9.86</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1391</td>\n",
       "      <td>2.4960</td>\n",
       "      <td>0.5034</td>\n",
       "      <td>-1.4698</td>\n",
       "      <td>0.2473</td>\n",
       "      <td>-0.1733</td>\n",
       "      <td>2.7766</td>\n",
       "      <td>0.5252</td>\n",
       "      <td>-1.6830</td>\n",
       "      <td>0.1923</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61238</th>\n",
       "      <td>68</td>\n",
       "      <td>170391</td>\n",
       "      <td>9.86</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1138</td>\n",
       "      <td>2.9969</td>\n",
       "      <td>0.5231</td>\n",
       "      <td>-1.4656</td>\n",
       "      <td>0.2515</td>\n",
       "      <td>-0.1570</td>\n",
       "      <td>3.0137</td>\n",
       "      <td>0.5335</td>\n",
       "      <td>-1.6732</td>\n",
       "      <td>-0.8825</td>\n",
       "      <td>-0.3094</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61239</th>\n",
       "      <td>68</td>\n",
       "      <td>130418</td>\n",
       "      <td>9.84</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.4284</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>1.2343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61240</th>\n",
       "      <td>68</td>\n",
       "      <td>130418</td>\n",
       "      <td>9.84</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2819</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.4284</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>1.2343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61241</th>\n",
       "      <td>68</td>\n",
       "      <td>130418</td>\n",
       "      <td>9.84</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.4284</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>1.2343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61242</th>\n",
       "      <td>68</td>\n",
       "      <td>130418</td>\n",
       "      <td>9.84</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2741</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1944</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.4284</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.1655</td>\n",
       "      <td>1.2343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61243</th>\n",
       "      <td>68</td>\n",
       "      <td>48140</td>\n",
       "      <td>9.84</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1663</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1605</td>\n",
       "      <td>2.9120</td>\n",
       "      <td>0.5393</td>\n",
       "      <td>-1.8574</td>\n",
       "      <td>0.3677</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>-1.0665</td>\n",
       "      <td>0.3135</td>\n",
       "      <td>5.0128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61244</th>\n",
       "      <td>68</td>\n",
       "      <td>48140</td>\n",
       "      <td>9.84</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0768</td>\n",
       "      <td>2.4698</td>\n",
       "      <td>0.4784</td>\n",
       "      <td>-1.2565</td>\n",
       "      <td>-0.6417</td>\n",
       "      <td>-0.1193</td>\n",
       "      <td>2.6858</td>\n",
       "      <td>0.5199</td>\n",
       "      <td>-1.7116</td>\n",
       "      <td>0.1496</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>-1.0665</td>\n",
       "      <td>0.3135</td>\n",
       "      <td>5.0128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61245</th>\n",
       "      <td>68</td>\n",
       "      <td>48140</td>\n",
       "      <td>9.84</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1594</td>\n",
       "      <td>2.3907</td>\n",
       "      <td>0.4512</td>\n",
       "      <td>-1.4997</td>\n",
       "      <td>0.2404</td>\n",
       "      <td>-0.1225</td>\n",
       "      <td>2.8020</td>\n",
       "      <td>0.5328</td>\n",
       "      <td>-1.7080</td>\n",
       "      <td>0.3101</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>-1.0665</td>\n",
       "      <td>0.3135</td>\n",
       "      <td>5.0128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61246</th>\n",
       "      <td>68</td>\n",
       "      <td>48140</td>\n",
       "      <td>9.84</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1088</td>\n",
       "      <td>2.7419</td>\n",
       "      <td>0.5129</td>\n",
       "      <td>-1.5630</td>\n",
       "      <td>-1.1576</td>\n",
       "      <td>-0.1085</td>\n",
       "      <td>2.9373</td>\n",
       "      <td>0.5337</td>\n",
       "      <td>-1.7541</td>\n",
       "      <td>-1.2782</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>-1.0665</td>\n",
       "      <td>0.3135</td>\n",
       "      <td>5.0128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61247</th>\n",
       "      <td>68</td>\n",
       "      <td>125185</td>\n",
       "      <td>9.83</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2903</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1561</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.4672</td>\n",
       "      <td>1.0825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61248</th>\n",
       "      <td>68</td>\n",
       "      <td>125185</td>\n",
       "      <td>9.83</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2332</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.4672</td>\n",
       "      <td>1.0825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61249</th>\n",
       "      <td>68</td>\n",
       "      <td>125185</td>\n",
       "      <td>9.83</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2245</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.4672</td>\n",
       "      <td>1.0825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61250</th>\n",
       "      <td>68</td>\n",
       "      <td>125185</td>\n",
       "      <td>9.83</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1740</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2479</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.7595</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.4672</td>\n",
       "      <td>1.0825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61251</th>\n",
       "      <td>68</td>\n",
       "      <td>114316</td>\n",
       "      <td>9.83</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0487</td>\n",
       "      <td>2.1551</td>\n",
       "      <td>0.5136</td>\n",
       "      <td>-0.8898</td>\n",
       "      <td>-0.3545</td>\n",
       "      <td>-0.1476</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.0436</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61252</th>\n",
       "      <td>68</td>\n",
       "      <td>114316</td>\n",
       "      <td>9.83</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0502</td>\n",
       "      <td>2.4493</td>\n",
       "      <td>0.4668</td>\n",
       "      <td>-1.3481</td>\n",
       "      <td>-0.5799</td>\n",
       "      <td>-0.1059</td>\n",
       "      <td>2.6734</td>\n",
       "      <td>0.5421</td>\n",
       "      <td>-1.6533</td>\n",
       "      <td>0.2524</td>\n",
       "      <td>-2.0436</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61253</th>\n",
       "      <td>68</td>\n",
       "      <td>114316</td>\n",
       "      <td>9.83</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.0333</td>\n",
       "      <td>2.4841</td>\n",
       "      <td>0.5063</td>\n",
       "      <td>-1.2820</td>\n",
       "      <td>0.2454</td>\n",
       "      <td>-0.1262</td>\n",
       "      <td>3.0927</td>\n",
       "      <td>0.5227</td>\n",
       "      <td>-1.4862</td>\n",
       "      <td>0.2234</td>\n",
       "      <td>-2.0436</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61254</th>\n",
       "      <td>68</td>\n",
       "      <td>114316</td>\n",
       "      <td>9.83</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1116</td>\n",
       "      <td>2.0279</td>\n",
       "      <td>0.4731</td>\n",
       "      <td>-0.9225</td>\n",
       "      <td>-0.3593</td>\n",
       "      <td>-0.1375</td>\n",
       "      <td>2.3497</td>\n",
       "      <td>0.4938</td>\n",
       "      <td>-1.3445</td>\n",
       "      <td>0.1868</td>\n",
       "      <td>-2.0436</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61255</th>\n",
       "      <td>68</td>\n",
       "      <td>122676</td>\n",
       "      <td>9.81</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1379</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1232</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61256</th>\n",
       "      <td>68</td>\n",
       "      <td>122676</td>\n",
       "      <td>9.81</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.1723</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2282</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61257</th>\n",
       "      <td>68</td>\n",
       "      <td>122676</td>\n",
       "      <td>9.81</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>0.0405</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61258</th>\n",
       "      <td>68</td>\n",
       "      <td>122676</td>\n",
       "      <td>9.81</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>b'None'</td>\n",
       "      <td>-0.2230</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.1487</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3663</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>0.6268</td>\n",
       "      <td>50.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8930 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       snap   subid  logmstar  cam  merger    rfprob  asym_I    cc_I     g_I  \\\n",
       "52329    68       0     11.88    0    True   b'None'     NaN     NaN     NaN   \n",
       "52330    68       0     11.88    1    True   b'None'     NaN     NaN     NaN   \n",
       "52331    68       0     11.88    3    True   b'None'     NaN     NaN     NaN   \n",
       "52332    68       0     11.88    2    True   b'None'     NaN     NaN     NaN   \n",
       "52333    68   14557     11.63    0   False  b'0.221'  0.1312  3.4661  0.4992   \n",
       "52334    68   14557     11.63    1   False  b'0.207'  0.1132  3.0883  0.4962   \n",
       "52335    68   14557     11.63    3   False  b'0.195'  0.1095  2.7629  0.5025   \n",
       "52336    68   14557     11.63    2   False  b'0.275'  0.2138  2.9266  0.5954   \n",
       "52337    68    8570     11.63    0   False  b'0.273' -0.6021  0.6721  0.0951   \n",
       "52338    68    8570     11.63    2   False   b'0.27'  0.4431  2.6273  0.4885   \n",
       "52339    68    8570     11.63    1   False  b'0.485'  0.4396  2.9208  0.5291   \n",
       "52340    68    8570     11.63    3   False  b'0.655'  0.4320  3.0696  0.4940   \n",
       "52341    68    2686     11.62    2    True   b'None'  0.8725  2.0708  0.5285   \n",
       "52342    68    2686     11.62    0    True  b'0.765'  0.2437  3.2549  0.5334   \n",
       "52343    68    2686     11.62    3    True  b'0.636'  0.9986  2.4079  0.5902   \n",
       "52344    68    2686     11.62    1    True  b'0.724'  0.6844  2.8050  0.6691   \n",
       "52345    68    1350     11.61    2   False   b'None'  0.1078     NaN     NaN   \n",
       "52346    68    1350     11.61    3   False   b'None'  0.1380     NaN     NaN   \n",
       "52347    68    1350     11.61    1   False   b'None'  0.2347  3.2405  0.5779   \n",
       "52348    68    1350     11.61    0   False   b'None'  0.1857     NaN     NaN   \n",
       "52349    68    7748     11.60    3   False  b'0.391'  0.2404  1.7160  0.4526   \n",
       "52350    68    7748     11.60    2   False  b'0.211'  0.1412  2.5814  0.6074   \n",
       "52351    68    7748     11.60    0   False  b'0.147'  0.1113  2.6797  0.5548   \n",
       "52352    68    7748     11.60    1   False  b'0.164'  0.2041  1.8517  0.4032   \n",
       "52353    68    4404     11.59    0   False   b'None' -0.0270     NaN     NaN   \n",
       "52354    68    4404     11.59    3   False   b'None'  0.0320  1.7845  0.3823   \n",
       "52355    68    4404     11.59    1   False  b'0.123'  0.0201  2.3442  0.3847   \n",
       "52356    68    4404     11.59    2   False  b'0.114'  0.0045  2.3613  0.3922   \n",
       "52357    68   19310     11.52    3   False  b'0.331'  0.5088  3.5609  0.5309   \n",
       "52358    68   19310     11.52    1   False  b'0.264'  0.5380  2.8762  0.5909   \n",
       "...     ...     ...       ...  ...     ...       ...     ...     ...     ...   \n",
       "61229    68   77158      9.86    0    True   b'None' -0.1517     NaN     NaN   \n",
       "61230    68   77158      9.86    1    True   b'None' -0.2482     NaN     NaN   \n",
       "61231    68  181428      9.86    0    True   b'None' -0.0136     NaN     NaN   \n",
       "61232    68  181428      9.86    3    True   b'None' -0.2088     NaN     NaN   \n",
       "61233    68  181428      9.86    1    True   b'None' -0.1064     NaN     NaN   \n",
       "61234    68  181428      9.86    2    True   b'None' -0.1097     NaN     NaN   \n",
       "61235    68  170391      9.86    2   False   b'None' -0.0900  2.4091  0.4726   \n",
       "61236    68  170391      9.86    3   False   b'None' -0.1245  2.5646  0.5008   \n",
       "61237    68  170391      9.86    1   False   b'None' -0.1391  2.4960  0.5034   \n",
       "61238    68  170391      9.86    0   False   b'None' -0.1138  2.9969  0.5231   \n",
       "61239    68  130418      9.84    2    True   b'None'     NaN     NaN     NaN   \n",
       "61240    68  130418      9.84    3    True   b'None'     NaN     NaN     NaN   \n",
       "61241    68  130418      9.84    0    True   b'None'     NaN     NaN     NaN   \n",
       "61242    68  130418      9.84    1    True   b'None' -0.2741     NaN     NaN   \n",
       "61243    68   48140      9.84    3   False   b'None' -0.1663     NaN     NaN   \n",
       "61244    68   48140      9.84    2   False   b'None' -0.0768  2.4698  0.4784   \n",
       "61245    68   48140      9.84    0   False   b'None' -0.1594  2.3907  0.4512   \n",
       "61246    68   48140      9.84    1   False   b'None' -0.1088  2.7419  0.5129   \n",
       "61247    68  125185      9.83    1    True   b'None' -0.2903     NaN     NaN   \n",
       "61248    68  125185      9.83    2    True   b'None' -0.2144     NaN     NaN   \n",
       "61249    68  125185      9.83    3    True   b'None' -0.2374     NaN     NaN   \n",
       "61250    68  125185      9.83    0    True   b'None' -0.1740     NaN     NaN   \n",
       "61251    68  114316      9.83    2   False   b'None' -0.0487  2.1551  0.5136   \n",
       "61252    68  114316      9.83    1   False   b'None' -0.0502  2.4493  0.4668   \n",
       "61253    68  114316      9.83    3   False   b'None' -0.0333  2.4841  0.5063   \n",
       "61254    68  114316      9.83    0   False   b'None' -0.1116  2.0279  0.4731   \n",
       "61255    68  122676      9.81    3   False   b'None' -0.1379     NaN     NaN   \n",
       "61256    68  122676      9.81    1   False   b'None' -0.1723     NaN     NaN   \n",
       "61257    68  122676      9.81    2   False   b'None'  0.0405     NaN     NaN   \n",
       "61258    68  122676      9.81    0   False   b'None' -0.2230     NaN     NaN   \n",
       "\n",
       "        m20_I  mprime_I  asym_H    cc_H     g_H   m20_H  mprime_H  t_lastmaj  \\\n",
       "52329     NaN       NaN  0.0860  2.8530  0.5463 -1.8116   -1.3221    -0.4537   \n",
       "52330     NaN       NaN  0.0738  2.8770  0.5526 -1.7441   -1.3423    -0.4537   \n",
       "52331     NaN       NaN  0.0911  2.8247  0.5340 -1.7679   -1.3116    -0.4537   \n",
       "52332     NaN       NaN  0.0769  2.7880  0.5358 -1.7708   -1.3380    -0.4537   \n",
       "52333 -1.9007   -0.8344  0.0462  3.7150  0.5528 -2.0840   -1.5967    -1.9574   \n",
       "52334 -1.7102   -0.7281  0.0476  3.5797  0.5522 -2.0131   -1.7615    -1.9574   \n",
       "52335 -1.5272   -0.7947  0.0583  3.5036  0.5515 -1.8905   -1.4630    -1.9574   \n",
       "52336 -1.3055   -0.5015  0.0927  3.3504  0.5666 -1.6880   -1.1086    -1.9574   \n",
       "52337 -0.4960   -0.3950  0.1673  3.9753  0.6344 -1.9124   -1.1006    -0.3094   \n",
       "52338 -1.6503   -0.6934  0.1759  3.4431  0.5366 -2.0412   -1.4432    -0.3094   \n",
       "52339 -1.5634   -0.6355  0.2126  3.8730  0.5906 -2.0981   -1.0879    -0.3094   \n",
       "52340 -1.6687   -0.8754  0.2295  4.0034  0.6102 -1.8203   -0.8723    -0.3094   \n",
       "52341 -1.9369   -0.7782     NaN     NaN     NaN     NaN       NaN     0.0000   \n",
       "52342 -1.4550   -0.8017  0.2029  4.3633  0.6163 -1.9058   -0.9717     0.0000   \n",
       "52343 -1.3086   -1.0770  0.2155  4.1102  0.5767 -1.3512   -1.1049     0.0000   \n",
       "52344 -0.9981   -0.4955  0.3281  5.1337  0.6391 -1.5259   -0.4535     0.0000   \n",
       "52345     NaN       NaN  0.0621  4.3167  0.6298 -2.3381   -1.2935    -1.9574   \n",
       "52346     NaN       NaN  0.0504  3.4624  0.6457 -2.0902   -1.4338    -1.9574   \n",
       "52347 -0.8722   -0.7554  0.0769  3.8399  0.5986 -2.0689   -1.7189    -1.9574   \n",
       "52348     NaN       NaN  0.0987  4.0067  0.6213 -1.6829   -1.5064    -1.9574   \n",
       "52349 -0.9998   -0.2279  0.0945  4.0245  0.6182 -1.7138   -1.8461    -2.1504   \n",
       "52350 -1.0677   -0.3708  0.0534  3.2450  0.5805 -1.8607   -1.3549    -2.1504   \n",
       "52351 -1.3055   -0.3664  0.0196  3.0137  0.5644 -1.6914   -1.2262    -2.1504   \n",
       "52352 -1.0093   -0.3782  0.0248  3.0554  0.5499 -1.8295   -1.3038    -2.1504   \n",
       "52353     NaN       NaN  0.0163  3.8090  0.5247 -2.1838   -1.5408    -1.1608   \n",
       "52354 -0.7767    0.0303  0.0061  3.9463  0.5315 -2.3210   -1.8787    -1.1608   \n",
       "52355 -0.7353   -1.1846  0.0279  3.7781  0.5359 -2.1316   -1.4345    -1.1608   \n",
       "52356 -0.6922   -0.0358  0.0266  3.7023  0.5449 -2.1251   -1.9365    -1.1608   \n",
       "52357 -1.0555   -0.9192  0.1999  3.4210  0.5098 -2.0113   -1.3400    -2.1504   \n",
       "52358 -0.9925   -0.6161  0.2448  3.2502  0.5138 -1.7854   -1.6130    -2.1504   \n",
       "...       ...       ...     ...     ...     ...     ...       ...        ...   \n",
       "61229     NaN       NaN -0.0541     NaN     NaN     NaN       NaN     0.0000   \n",
       "61230     NaN       NaN -0.0995     NaN     NaN     NaN       NaN     0.0000   \n",
       "61231     NaN       NaN -0.1042  2.6964  0.4884 -1.5243    0.2589   -50.0000   \n",
       "61232     NaN       NaN -0.2104     NaN     NaN     NaN       NaN   -50.0000   \n",
       "61233     NaN       NaN -0.1519  2.8167  0.4813 -1.3079    0.2647   -50.0000   \n",
       "61234     NaN       NaN -0.1851     NaN     NaN     NaN       NaN   -50.0000   \n",
       "61235 -1.4757    0.2467 -0.0814     NaN     NaN     NaN       NaN    -0.3094   \n",
       "61236 -1.3884    0.2365 -0.1254  2.6233  0.4581 -1.6221    0.1883    -0.3094   \n",
       "61237 -1.4698    0.2473 -0.1733  2.7766  0.5252 -1.6830    0.1923    -0.3094   \n",
       "61238 -1.4656    0.2515 -0.1570  3.0137  0.5335 -1.6732   -0.8825    -0.3094   \n",
       "61239     NaN       NaN -0.2320     NaN     NaN     NaN       NaN    -2.4284   \n",
       "61240     NaN       NaN -0.2819     NaN     NaN     NaN       NaN    -2.4284   \n",
       "61241     NaN       NaN -0.1972     NaN     NaN     NaN       NaN    -2.4284   \n",
       "61242     NaN       NaN -0.1944     NaN     NaN     NaN       NaN    -2.4284   \n",
       "61243     NaN       NaN -0.1605  2.9120  0.5393 -1.8574    0.3677    -0.7595   \n",
       "61244 -1.2565   -0.6417 -0.1193  2.6858  0.5199 -1.7116    0.1496    -0.7595   \n",
       "61245 -1.4997    0.2404 -0.1225  2.8020  0.5328 -1.7080    0.3101    -0.7595   \n",
       "61246 -1.5630   -1.1576 -0.1085  2.9373  0.5337 -1.7541   -1.2782    -0.7595   \n",
       "61247     NaN       NaN -0.1561     NaN     NaN     NaN       NaN    -0.7595   \n",
       "61248     NaN       NaN -0.2332     NaN     NaN     NaN       NaN    -0.7595   \n",
       "61249     NaN       NaN -0.2245     NaN     NaN     NaN       NaN    -0.7595   \n",
       "61250     NaN       NaN -0.2479     NaN     NaN     NaN       NaN    -0.7595   \n",
       "61251 -0.8898   -0.3545 -0.1476     NaN     NaN     NaN       NaN    -2.0436   \n",
       "61252 -1.3481   -0.5799 -0.1059  2.6734  0.5421 -1.6533    0.2524    -2.0436   \n",
       "61253 -1.2820    0.2454 -0.1262  3.0927  0.5227 -1.4862    0.2234    -2.0436   \n",
       "61254 -0.9225   -0.3593 -0.1375  2.3497  0.4938 -1.3445    0.1868    -2.0436   \n",
       "61255     NaN       NaN -0.1232     NaN     NaN     NaN       NaN    -1.3663   \n",
       "61256     NaN       NaN -0.2282     NaN     NaN     NaN       NaN    -1.3663   \n",
       "61257     NaN       NaN -0.2032     NaN     NaN     NaN       NaN    -1.3663   \n",
       "61258     NaN       NaN -0.1487     NaN     NaN     NaN       NaN    -1.3663   \n",
       "\n",
       "       t_lastmin  t_nextmaj  t_nextmin  \n",
       "52329    -0.4537     0.1655     3.4351  \n",
       "52330    -0.4537     0.1655     3.4351  \n",
       "52331    -0.4537     0.1655     3.4351  \n",
       "52332    -0.4537     0.1655     3.4351  \n",
       "52333    -1.3663    50.0000     3.4351  \n",
       "52334    -1.3663    50.0000     3.4351  \n",
       "52335    -1.3663    50.0000     3.4351  \n",
       "52336    -1.3663    50.0000     3.4351  \n",
       "52337    -1.3663     0.9353     0.3135  \n",
       "52338    -1.3663     0.9353     0.3135  \n",
       "52339    -1.3663     0.9353     0.3135  \n",
       "52340    -1.3663     0.9353     0.3135  \n",
       "52341    -2.2168    50.0000     1.8536  \n",
       "52342    -2.2168    50.0000     1.8536  \n",
       "52343    -2.2168    50.0000     1.8536  \n",
       "52344    -2.2168    50.0000     1.8536  \n",
       "52345    -1.2215    50.0000     2.0282  \n",
       "52346    -1.2215    50.0000     2.0282  \n",
       "52347    -1.2215    50.0000     2.0282  \n",
       "52348    -1.2215    50.0000     2.0282  \n",
       "52349    -0.3094     9.2959    50.0000  \n",
       "52350    -0.3094     9.2959    50.0000  \n",
       "52351    -0.3094     9.2959    50.0000  \n",
       "52352    -0.3094     9.2959    50.0000  \n",
       "52353    -1.3663    50.0000     1.5517  \n",
       "52354    -1.3663    50.0000     1.5517  \n",
       "52355    -1.3663    50.0000     1.5517  \n",
       "52356    -1.3663    50.0000     1.5517  \n",
       "52357    -1.2215     2.6593     1.3906  \n",
       "52358    -1.2215     2.6593     1.3906  \n",
       "...          ...        ...        ...  \n",
       "61229     0.0000     0.4672    50.0000  \n",
       "61230     0.0000     0.4672    50.0000  \n",
       "61231    -2.8264    50.0000     0.1655  \n",
       "61232    -2.8264    50.0000     0.1655  \n",
       "61233    -2.8264    50.0000     0.1655  \n",
       "61234    -2.8264    50.0000     0.1655  \n",
       "61235   -50.0000    50.0000    50.0000  \n",
       "61236   -50.0000    50.0000    50.0000  \n",
       "61237   -50.0000    50.0000    50.0000  \n",
       "61238   -50.0000    50.0000    50.0000  \n",
       "61239   -50.0000     0.1655     1.2343  \n",
       "61240   -50.0000     0.1655     1.2343  \n",
       "61241   -50.0000     0.1655     1.2343  \n",
       "61242   -50.0000     0.1655     1.2343  \n",
       "61243    -1.0665     0.3135     5.0128  \n",
       "61244    -1.0665     0.3135     5.0128  \n",
       "61245    -1.0665     0.3135     5.0128  \n",
       "61246    -1.0665     0.3135     5.0128  \n",
       "61247     0.0000     0.4672     1.0825  \n",
       "61248     0.0000     0.4672     1.0825  \n",
       "61249     0.0000     0.4672     1.0825  \n",
       "61250     0.0000     0.4672     1.0825  \n",
       "61251   -50.0000     0.6268    50.0000  \n",
       "61252   -50.0000     0.6268    50.0000  \n",
       "61253   -50.0000     0.6268    50.0000  \n",
       "61254   -50.0000     0.6268    50.0000  \n",
       "61255   -50.0000     0.6268    50.0000  \n",
       "61256   -50.0000     0.6268    50.0000  \n",
       "61257   -50.0000     0.6268    50.0000  \n",
       "61258   -50.0000     0.6268    50.0000  \n",
       "\n",
       "[8930 rows x 20 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# extract only objects from snapshot 68 (which is for z=2)\n",
    "merged_68 = catalog.loc[catalog['snap'] == 68]\n",
    "merged_68"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Producing our merger sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# producting an array with objects used in RF + all object with p_RF=None which were excluded in RF\n",
    "temp = np.array(merged_68.copy(), dtype=None)\n",
    "rf_objects = []\n",
    "for i in range(len(temp)):\n",
    "    rf_objects.append([temp[i,1],temp[i,4]])\n",
    "rf_objects = np.stack(rf_objects)\n",
    "\n",
    "#object IDs, which are needed to find these objects in the image files\n",
    "subid, indices = np.unique(rf_objects[:,0], return_index=True)\n",
    "RF_labels = rf_objects[indices]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "shid_array = RF_labels[:,0]\n",
    "merger_labels = RF_labels[:,1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2233"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(merger_labels)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "list_of_mergers=[]\n",
    "list_of_nonmergers=[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#subdirs for displaying\n",
    "path = '/home/DeepMerge/data/resized_SB25'\n",
    "subdirs = ['res_subdir_{josh:03d}'.format(josh=x) for x in range(23)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#All 4 filters i order ['ACS-F435W', ACS-F814W','NC-F356W','WFC3-F160W'], we will need second and fourth:\n",
    "for shid, merger in zip(shid_array,merger_labels):\n",
    "    for camnum in ['00','01','02','03']:\n",
    "            filter_files=np.sort(np.asarray(glob.glob(os.path.join(path,'res_sub*','*sh'+str(shid)+'cam'+camnum+'*SB25.npy'))))\n",
    "            # the above should return exactly 4 files\n",
    "            \n",
    "            if filter_files.shape[0] != 4:\n",
    "                continue\n",
    "\n",
    "            tmp= np.zeros((4, 75, 75))\n",
    "\n",
    "            tmp[0,:,:]=np.load(filter_files[0])\n",
    "            tmp[1,:,:]=np.load(filter_files[1])\n",
    "            tmp[2,:,:]=np.load(filter_files[2])\n",
    "            tmp[3,:,:]=np.load(filter_files[3])\n",
    "     \n",
    "\n",
    "            if bool(merger) is True:\n",
    "               list_of_mergers.append(tmp)\n",
    "\n",
    "            else:\n",
    "                list_of_nonmergers.append(tmp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "mergers = np.stack(list_of_mergers)\n",
    "notmergers = np.stack(list_of_nonmergers)\n",
    "mergers_y = np.ones(mergers.shape[0])\n",
    "notmergers_y = np.zeros(notmergers.shape[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "X = np.vstack((mergers, notmergers))\n",
    "y = np.concatenate((mergers_y, notmergers_y))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# producing numpy arrays with all objects in 4 filters\n",
    "np.save('SB25.npy', X)\n",
    "np.save('SB25_y.npy', y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8930"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(y)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Merger augmentation, plus extracton of only 2 relevant filters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "XX = np.load('SB25.npy')\n",
    "yy = np.load('SB25_y.npy')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "xx_data_list = []\n",
    "for i in range(len(X)):\n",
    "    xx_data_list.append([X[i,1],X[i,3]])\n",
    "xx_data = np.stack(xx_data_list)\n",
    "yy_data = y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "list_ud = []\n",
    "list_lr = []\n",
    "list_rot = []\n",
    "list_rot180 = []\n",
    "\n",
    "for i in range(0,1624):\n",
    "    tmp = np.zeros((2, 75, 75))\n",
    "    tmp[0,:,:]=np.flipud(xx_data[i,0])\n",
    "    tmp[1,:,:]=np.flipud(xx_data[i,1])\n",
    "    list_ud.append(tmp)\n",
    "    \n",
    "    \n",
    "for i in range(0,1624):\n",
    "    tmp = np.zeros((2, 75, 75))\n",
    "    tmp[0,:,:]=np.fliplr(xx_data[i,0])\n",
    "    tmp[1,:,:]=np.fliplr(xx_data[i,1])\n",
    "    list_lr.append(tmp)\n",
    "    \n",
    "    \n",
    "for i in range(0,1624):\n",
    "    tmp = np.zeros((2, 75, 75))\n",
    "    tmp[0,:,:]=np.rot90(xx_data[i,0])\n",
    "    tmp[1,:,:]=np.rot90(xx_data[i,1])\n",
    "    list_rot.append(tmp)\n",
    "    \n",
    "    \n",
    "for i in range(0,1624):\n",
    "    tmp = np.zeros((2, 75, 75))\n",
    "    tmp[0,:,:]=np.rot90(np.rot90(xx_data[i,0]))\n",
    "    tmp[1,:,:]=np.rot90(np.rot90(xx_data[i,1]))\n",
    "    list_rot180.append(tmp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "mergers_ud = np.stack(list_ud)\n",
    "mergers_lr = np.stack(list_lr)\n",
    "mergers_rot = np.stack(list_rot)\n",
    "mergers_rot180 = np.stack(list_rot180)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "y_ud = np.ones(mergers_ud.shape[0])\n",
    "y_lr = np.ones(mergers_lr.shape[0])\n",
    "y_rot = np.ones(mergers_rot.shape[0])\n",
    "y_rot180 = np.ones(mergers_rot180.shape[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "X_augmented = np.vstack((xx_data[:1624], mergers_ud, mergers_lr, mergers_rot, mergers_rot180, xx_data[1624:]))\n",
    "y_augmented = np.concatenate((yy_data[:1624], y_ud, y_lr, y_rot, y_rot180, yy_data[1624:]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "np.save('SB25_augmented.npy', X_augmented)\n",
    "np.save('SB25_augmented_y.npy', y_augmented)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(15426, 2, 75, 75)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.shape(X_augmented)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}