examineTCEs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import scipy.special as spec\n",
    "import pandas as pd\n",
    "from astropy.io import ascii\n",
    "from astropy.table import Table, vstack\n",
    "import pickle\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# load the TCE list\n",
    "tces = ascii.read(\"kplr_dr25_obs_tces.txt\")\n",
    "tces = tces.to_pandas()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# load the KOI list\n",
    "dr25Koi = pd.read_csv(\"dr25_kois_archive.txt\", dtype={\"kepoi_name\":str})\n",
    "\n",
    "# add TCE_ID for comparison to the TCE list\n",
    "TCE_ID = []\n",
    "for i in range(len(dr25Koi)):\n",
    "    # format the strings so the kepid part has 9 didgets with leading zeros \n",
    "    # and the planet number part has 2 didgets with leading zeros\n",
    "    TCE_ID.append(\"%09d\"%dr25Koi.kepid.loc[i] + \"-%02d\"%dr25Koi.koi_tce_plnt_num.loc[i])\n",
    "\n",
    "dr25Koi[\"TCE_ID\"] = TCE_ID\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# look at TCEs that have score between 0.05 and 0.1\n",
    "# highScoreTces = tces[(tces.Score > 0.05) & (tces.Score < 0.1)]\n",
    "highScoreTces = tces[(tces.Score > 0.01) & (tces.Score < 0.05)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>TCE_ID</th>\n",
       "      <th>KIC</th>\n",
       "      <th>Disp</th>\n",
       "      <th>Score</th>\n",
       "      <th>NTL</th>\n",
       "      <th>SS</th>\n",
       "      <th>CO</th>\n",
       "      <th>EM</th>\n",
       "      <th>period</th>\n",
       "      <th>epoch</th>\n",
       "      <th>...</th>\n",
       "      <th>Rs</th>\n",
       "      <th>Ts</th>\n",
       "      <th>logg</th>\n",
       "      <th>a</th>\n",
       "      <th>Rp/Rs</th>\n",
       "      <th>a/Rs</th>\n",
       "      <th>impact</th>\n",
       "      <th>SNR_DV</th>\n",
       "      <th>Sp</th>\n",
       "      <th>Fit_Prov</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>001434395-01</td>\n",
       "      <td>1434395</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.014</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2.222722</td>\n",
       "      <td>131.900279</td>\n",
       "      <td>...</td>\n",
       "      <td>20.848</td>\n",
       "      <td>4996</td>\n",
       "      <td>2.354</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.013365</td>\n",
       "      <td>6.64</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>14.8</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>002308411-01</td>\n",
       "      <td>2308411</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.014</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.983288</td>\n",
       "      <td>132.504131</td>\n",
       "      <td>...</td>\n",
       "      <td>1.198</td>\n",
       "      <td>6363</td>\n",
       "      <td>4.386</td>\n",
       "      <td>0.02098</td>\n",
       "      <td>0.008209</td>\n",
       "      <td>2.72</td>\n",
       "      <td>0.5765</td>\n",
       "      <td>10.9</td>\n",
       "      <td>4789.239</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>002438502-01</td>\n",
       "      <td>2438502</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.046</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8.360612</td>\n",
       "      <td>138.822956</td>\n",
       "      <td>...</td>\n",
       "      <td>2.445</td>\n",
       "      <td>5463</td>\n",
       "      <td>3.790</td>\n",
       "      <td>0.08900</td>\n",
       "      <td>0.150934</td>\n",
       "      <td>9.71</td>\n",
       "      <td>0.1914</td>\n",
       "      <td>501.6</td>\n",
       "      <td>602.311</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td>002452185-04</td>\n",
       "      <td>2452185</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.011</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>415.953886</td>\n",
       "      <td>421.126974</td>\n",
       "      <td>...</td>\n",
       "      <td>1.624</td>\n",
       "      <td>6704</td>\n",
       "      <td>4.126</td>\n",
       "      <td>1.18609</td>\n",
       "      <td>0.017439</td>\n",
       "      <td>294.45</td>\n",
       "      <td>0.7892</td>\n",
       "      <td>7.1</td>\n",
       "      <td>3.393</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>002716853-02</td>\n",
       "      <td>2716853</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.040</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>68.831585</td>\n",
       "      <td>172.136601</td>\n",
       "      <td>...</td>\n",
       "      <td>0.860</td>\n",
       "      <td>5687</td>\n",
       "      <td>4.538</td>\n",
       "      <td>0.32104</td>\n",
       "      <td>0.023608</td>\n",
       "      <td>133.51</td>\n",
       "      <td>0.4256</td>\n",
       "      <td>8.1</td>\n",
       "      <td>6.725</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31460</th>\n",
       "      <td>011922290-01</td>\n",
       "      <td>11922290</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.042</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>114.661574</td>\n",
       "      <td>237.231841</td>\n",
       "      <td>...</td>\n",
       "      <td>0.712</td>\n",
       "      <td>5412</td>\n",
       "      <td>4.562</td>\n",
       "      <td>0.40516</td>\n",
       "      <td>0.018141</td>\n",
       "      <td>167.79</td>\n",
       "      <td>0.8700</td>\n",
       "      <td>7.4</td>\n",
       "      <td>2.374</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31554</th>\n",
       "      <td>011967004-01</td>\n",
       "      <td>11967004</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.019</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.941641</td>\n",
       "      <td>133.107299</td>\n",
       "      <td>...</td>\n",
       "      <td>1.161</td>\n",
       "      <td>6525</td>\n",
       "      <td>4.381</td>\n",
       "      <td>0.03221</td>\n",
       "      <td>0.263831</td>\n",
       "      <td>6.58</td>\n",
       "      <td>0.7289</td>\n",
       "      <td>3480.7</td>\n",
       "      <td>2109.660</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32039</th>\n",
       "      <td>012254688-01</td>\n",
       "      <td>12254688</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.015</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>62.682423</td>\n",
       "      <td>182.230899</td>\n",
       "      <td>...</td>\n",
       "      <td>3.101</td>\n",
       "      <td>7058</td>\n",
       "      <td>3.648</td>\n",
       "      <td>0.35820</td>\n",
       "      <td>0.017342</td>\n",
       "      <td>283.54</td>\n",
       "      <td>0.3006</td>\n",
       "      <td>17.6</td>\n",
       "      <td>166.633</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32075</th>\n",
       "      <td>012266450-01</td>\n",
       "      <td>12266450</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.033</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>473.728882</td>\n",
       "      <td>306.311384</td>\n",
       "      <td>...</td>\n",
       "      <td>1.168</td>\n",
       "      <td>6875</td>\n",
       "      <td>4.376</td>\n",
       "      <td>1.25799</td>\n",
       "      <td>0.020796</td>\n",
       "      <td>737.23</td>\n",
       "      <td>0.5459</td>\n",
       "      <td>7.1</td>\n",
       "      <td>1.725</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32305</th>\n",
       "      <td>012459725-01</td>\n",
       "      <td>12459725</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.014</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>340.331273</td>\n",
       "      <td>228.217097</td>\n",
       "      <td>...</td>\n",
       "      <td>0.878</td>\n",
       "      <td>5799</td>\n",
       "      <td>4.539</td>\n",
       "      <td>0.94543</td>\n",
       "      <td>0.034144</td>\n",
       "      <td>722.84</td>\n",
       "      <td>0.6353</td>\n",
       "      <td>9.3</td>\n",
       "      <td>0.874</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>144 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             TCE_ID       KIC Disp  Score  NTL  SS  CO  EM      period  \\\n",
       "89     001434395-01   1434395   FP  0.014    0   0   1   0    2.222722   \n",
       "491    002308411-01   2308411   FP  0.014    0   0   1   0    0.983288   \n",
       "567    002438502-01   2438502   FP  0.046    0   1   0   0    8.360612   \n",
       "654    002452185-04   2452185   FP  0.011    1   0   0   0  415.953886   \n",
       "979    002716853-02   2716853   FP  0.040    1   0   1   0   68.831585   \n",
       "...             ...       ...  ...    ...  ...  ..  ..  ..         ...   \n",
       "31460  011922290-01  11922290   FP  0.042    1   0   0   0  114.661574   \n",
       "31554  011967004-01  11967004   FP  0.019    0   1   0   0    1.941641   \n",
       "32039  012254688-01  12254688   FP  0.015    0   0   1   0   62.682423   \n",
       "32075  012266450-01  12266450   FP  0.033    1   0   0   0  473.728882   \n",
       "32305  012459725-01  12459725   FP  0.014    0   0   1   0  340.331273   \n",
       "\n",
       "            epoch  ...      Rs    Ts   logg        a     Rp/Rs    a/Rs  \\\n",
       "89     131.900279  ...  20.848  4996  2.354  0.00000  0.013365    6.64   \n",
       "491    132.504131  ...   1.198  6363  4.386  0.02098  0.008209    2.72   \n",
       "567    138.822956  ...   2.445  5463  3.790  0.08900  0.150934    9.71   \n",
       "654    421.126974  ...   1.624  6704  4.126  1.18609  0.017439  294.45   \n",
       "979    172.136601  ...   0.860  5687  4.538  0.32104  0.023608  133.51   \n",
       "...           ...  ...     ...   ...    ...      ...       ...     ...   \n",
       "31460  237.231841  ...   0.712  5412  4.562  0.40516  0.018141  167.79   \n",
       "31554  133.107299  ...   1.161  6525  4.381  0.03221  0.263831    6.58   \n",
       "32039  182.230899  ...   3.101  7058  3.648  0.35820  0.017342  283.54   \n",
       "32075  306.311384  ...   1.168  6875  4.376  1.25799  0.020796  737.23   \n",
       "32305  228.217097  ...   0.878  5799  4.539  0.94543  0.034144  722.84   \n",
       "\n",
       "       impact  SNR_DV        Sp  Fit_Prov  \n",
       "89     0.0008    14.8     0.000         1  \n",
       "491    0.5765    10.9  4789.239         1  \n",
       "567    0.1914   501.6   602.311         1  \n",
       "654    0.7892     7.1     3.393         1  \n",
       "979    0.4256     8.1     6.725         1  \n",
       "...       ...     ...       ...       ...  \n",
       "31460  0.8700     7.4     2.374         1  \n",
       "31554  0.7289  3480.7  2109.660         1  \n",
       "32039  0.3006    17.6   166.633         1  \n",
       "32075  0.5459     7.1     1.725         1  \n",
       "32305  0.6353     9.3     0.874         1  \n",
       "\n",
       "[144 rows x 26 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highScoreTces"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>kepid</th>\n",
       "      <th>kepoi_name</th>\n",
       "      <th>kepler_name</th>\n",
       "      <th>ra</th>\n",
       "      <th>ra_err</th>\n",
       "      <th>ra_str</th>\n",
       "      <th>dec</th>\n",
       "      <th>dec_err</th>\n",
       "      <th>dec_str</th>\n",
       "      <th>koi_gmag</th>\n",
       "      <th>...</th>\n",
       "      <th>koi_fpflag_ec</th>\n",
       "      <th>koi_insol</th>\n",
       "      <th>koi_insol_err1</th>\n",
       "      <th>koi_insol_err2</th>\n",
       "      <th>koi_srho</th>\n",
       "      <th>koi_srho_err1</th>\n",
       "      <th>koi_srho_err2</th>\n",
       "      <th>koi_fittype</th>\n",
       "      <th>koi_score</th>\n",
       "      <th>TCE_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>11656840</td>\n",
       "      <td>K00774.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>288.98682</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h15m56.84s</td>\n",
       "      <td>49.733742</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+49d44m01.5s</td>\n",
       "      <td>15.712</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>206.78</td>\n",
       "      <td>195.52</td>\n",
       "      <td>-61.76</td>\n",
       "      <td>7.48712</td>\n",
       "      <td>1.28308</td>\n",
       "      <td>-2.42034</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.014</td>\n",
       "      <td>011656840-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>2438502</td>\n",
       "      <td>K01003.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>290.32791</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h21m18.70s</td>\n",
       "      <td>37.726742</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+37d43m36.3s</td>\n",
       "      <td>16.970</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>601.60</td>\n",
       "      <td>278.33</td>\n",
       "      <td>-356.79</td>\n",
       "      <td>0.24048</td>\n",
       "      <td>0.01736</td>\n",
       "      <td>-0.00068</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.046</td>\n",
       "      <td>002438502-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>2716853</td>\n",
       "      <td>K01022.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>292.26813</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h29m04.35s</td>\n",
       "      <td>37.955639</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+37d57m20.3s</td>\n",
       "      <td>16.360</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>6.71</td>\n",
       "      <td>5.77</td>\n",
       "      <td>-1.84</td>\n",
       "      <td>8.38470</td>\n",
       "      <td>10.68587</td>\n",
       "      <td>-1.84046</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.040</td>\n",
       "      <td>002716853-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>2837111</td>\n",
       "      <td>K01110.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>287.44409</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h09m46.58s</td>\n",
       "      <td>38.088428</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+38d05m18.3s</td>\n",
       "      <td>15.273</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>464.19</td>\n",
       "      <td>444.36</td>\n",
       "      <td>-141.70</td>\n",
       "      <td>0.65134</td>\n",
       "      <td>0.81468</td>\n",
       "      <td>-0.32978</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.047</td>\n",
       "      <td>002837111-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>5283542</td>\n",
       "      <td>K00827.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>294.22397</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h36m53.75s</td>\n",
       "      <td>40.417858</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+40d25m04.3s</td>\n",
       "      <td>16.038</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>284.25</td>\n",
       "      <td>295.54</td>\n",
       "      <td>-90.93</td>\n",
       "      <td>0.14724</td>\n",
       "      <td>2.26962</td>\n",
       "      <td>-0.05173</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.037</td>\n",
       "      <td>005283542-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7713</th>\n",
       "      <td>1434395</td>\n",
       "      <td>K07623.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>291.85648</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h27m25.56s</td>\n",
       "      <td>37.065651</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+37d03m56.3s</td>\n",
       "      <td>13.422</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>93172.12</td>\n",
       "      <td>12806.48</td>\n",
       "      <td>-67878.27</td>\n",
       "      <td>1.00737</td>\n",
       "      <td>0.29745</td>\n",
       "      <td>-0.56373</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.014</td>\n",
       "      <td>001434395-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7825</th>\n",
       "      <td>2308411</td>\n",
       "      <td>K07631.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>292.63766</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h30m33.04s</td>\n",
       "      <td>37.641880</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+37d38m30.8s</td>\n",
       "      <td>15.392</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4774.53</td>\n",
       "      <td>3992.71</td>\n",
       "      <td>-1614.92</td>\n",
       "      <td>1.08608</td>\n",
       "      <td>0.20204</td>\n",
       "      <td>-1.05344</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.014</td>\n",
       "      <td>002308411-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860</th>\n",
       "      <td>7959310</td>\n",
       "      <td>K08150.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>291.54568</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h26m10.96s</td>\n",
       "      <td>43.789879</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+43d47m23.6s</td>\n",
       "      <td>14.328</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3.37</td>\n",
       "      <td>2.79</td>\n",
       "      <td>-1.95</td>\n",
       "      <td>0.37323</td>\n",
       "      <td>0.33689</td>\n",
       "      <td>-0.08968</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.022</td>\n",
       "      <td>007959310-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7862</th>\n",
       "      <td>8028465</td>\n",
       "      <td>K08152.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>291.67062</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h26m40.95s</td>\n",
       "      <td>43.814461</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+43d48m52.1s</td>\n",
       "      <td>15.863</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.06</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>40.27950</td>\n",
       "      <td>4.22857</td>\n",
       "      <td>-37.45914</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.046</td>\n",
       "      <td>008028465-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7879</th>\n",
       "      <td>6384840</td>\n",
       "      <td>K06699.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>297.44244</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19h49m46.19s</td>\n",
       "      <td>41.789719</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+41d47m23.0s</td>\n",
       "      <td>16.354</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>592.18</td>\n",
       "      <td>485.78</td>\n",
       "      <td>-202.20</td>\n",
       "      <td>1.17726</td>\n",
       "      <td>2.93668</td>\n",
       "      <td>-0.85889</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.039</td>\n",
       "      <td>006384840-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>86 rows × 154 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         kepid kepoi_name kepler_name         ra  ra_err        ra_str  \\\n",
       "284   11656840  K00774.01         NaN  288.98682     0.0  19h15m56.84s   \n",
       "440    2438502  K01003.01         NaN  290.32791     0.0  19h21m18.70s   \n",
       "588    2716853  K01022.02         NaN  292.26813     0.0  19h29m04.35s   \n",
       "698    2837111  K01110.02         NaN  287.44409     0.0  19h09m46.58s   \n",
       "766    5283542  K00827.01         NaN  294.22397     0.0  19h36m53.75s   \n",
       "...        ...        ...         ...        ...     ...           ...   \n",
       "7713   1434395  K07623.01         NaN  291.85648     0.0  19h27m25.56s   \n",
       "7825   2308411  K07631.01         NaN  292.63766     0.0  19h30m33.04s   \n",
       "7860   7959310  K08150.01         NaN  291.54568     0.0  19h26m10.96s   \n",
       "7862   8028465  K08152.01         NaN  291.67062     0.0  19h26m40.95s   \n",
       "7879   6384840  K06699.01         NaN  297.44244     0.0  19h49m46.19s   \n",
       "\n",
       "            dec  dec_err       dec_str  koi_gmag  ...  koi_fpflag_ec  \\\n",
       "284   49.733742      0.0  +49d44m01.5s    15.712  ...              0   \n",
       "440   37.726742      0.0  +37d43m36.3s    16.970  ...              0   \n",
       "588   37.955639      0.0  +37d57m20.3s    16.360  ...              0   \n",
       "698   38.088428      0.0  +38d05m18.3s    15.273  ...              0   \n",
       "766   40.417858      0.0  +40d25m04.3s    16.038  ...              0   \n",
       "...         ...      ...           ...       ...  ...            ...   \n",
       "7713  37.065651      0.0  +37d03m56.3s    13.422  ...              0   \n",
       "7825  37.641880      0.0  +37d38m30.8s    15.392  ...              0   \n",
       "7860  43.789879      0.0  +43d47m23.6s    14.328  ...              0   \n",
       "7862  43.814461      0.0  +43d48m52.1s    15.863  ...              0   \n",
       "7879  41.789719      0.0  +41d47m23.0s    16.354  ...              0   \n",
       "\n",
       "      koi_insol  koi_insol_err1  koi_insol_err2  koi_srho  koi_srho_err1  \\\n",
       "284      206.78          195.52          -61.76   7.48712        1.28308   \n",
       "440      601.60          278.33         -356.79   0.24048        0.01736   \n",
       "588        6.71            5.77           -1.84   8.38470       10.68587   \n",
       "698      464.19          444.36         -141.70   0.65134        0.81468   \n",
       "766      284.25          295.54          -90.93   0.14724        2.26962   \n",
       "...         ...             ...             ...       ...            ...   \n",
       "7713   93172.12        12806.48       -67878.27   1.00737        0.29745   \n",
       "7825    4774.53         3992.71        -1614.92   1.08608        0.20204   \n",
       "7860       3.37            2.79           -1.95   0.37323        0.33689   \n",
       "7862       0.22            0.06           -0.06  40.27950        4.22857   \n",
       "7879     592.18          485.78         -202.20   1.17726        2.93668   \n",
       "\n",
       "      koi_srho_err2  koi_fittype  koi_score        TCE_ID  \n",
       "284        -2.42034      LS+MCMC      0.014  011656840-01  \n",
       "440        -0.00068      LS+MCMC      0.046  002438502-01  \n",
       "588        -1.84046      LS+MCMC      0.040  002716853-02  \n",
       "698        -0.32978      LS+MCMC      0.047  002837111-02  \n",
       "766        -0.05173      LS+MCMC      0.037  005283542-01  \n",
       "...             ...          ...        ...           ...  \n",
       "7713       -0.56373      LS+MCMC      0.014  001434395-01  \n",
       "7825       -1.05344      LS+MCMC      0.014  002308411-01  \n",
       "7860       -0.08968      LS+MCMC      0.022  007959310-01  \n",
       "7862      -37.45914      LS+MCMC      0.046  008028465-01  \n",
       "7879       -0.85889      LS+MCMC      0.039  006384840-01  \n",
       "\n",
       "[86 rows x 154 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# are any KOIs?\n",
    "highScoreTcesKois = dr25Koi[dr25Koi['TCE_ID'].isin(highScoreTces['TCE_ID'])]\n",
    "highScoreTcesKois"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "284     FALSE POSITIVE\n",
       "440     FALSE POSITIVE\n",
       "588     FALSE POSITIVE\n",
       "698     FALSE POSITIVE\n",
       "766     FALSE POSITIVE\n",
       "             ...      \n",
       "7713    FALSE POSITIVE\n",
       "7825    FALSE POSITIVE\n",
       "7860    FALSE POSITIVE\n",
       "7862    FALSE POSITIVE\n",
       "7879    FALSE POSITIVE\n",
       "Name: koi_pdisposition, Length: 86, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highScoreTcesKois.koi_pdisposition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "284     0.014\n",
       "440     0.046\n",
       "588     0.040\n",
       "698     0.047\n",
       "766     0.037\n",
       "        ...  \n",
       "7713    0.014\n",
       "7825    0.014\n",
       "7860    0.022\n",
       "7862    0.046\n",
       "7879    0.039\n",
       "Name: koi_score, Length: 86, dtype: float64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highScoreTcesKois.koi_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>TCE_ID</th>\n",
       "      <th>KIC</th>\n",
       "      <th>Disp</th>\n",
       "      <th>Score</th>\n",
       "      <th>NTL</th>\n",
       "      <th>SS</th>\n",
       "      <th>CO</th>\n",
       "      <th>EM</th>\n",
       "      <th>period</th>\n",
       "      <th>epoch</th>\n",
       "      <th>...</th>\n",
       "      <th>Rs</th>\n",
       "      <th>Ts</th>\n",
       "      <th>logg</th>\n",
       "      <th>a</th>\n",
       "      <th>Rp/Rs</th>\n",
       "      <th>a/Rs</th>\n",
       "      <th>impact</th>\n",
       "      <th>SNR_DV</th>\n",
       "      <th>Sp</th>\n",
       "      <th>Fit_Prov</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td>002452185-04</td>\n",
       "      <td>2452185</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.011</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>415.953886</td>\n",
       "      <td>421.126974</td>\n",
       "      <td>...</td>\n",
       "      <td>1.624</td>\n",
       "      <td>6704</td>\n",
       "      <td>4.126</td>\n",
       "      <td>1.18609</td>\n",
       "      <td>0.017439</td>\n",
       "      <td>294.45</td>\n",
       "      <td>0.7892</td>\n",
       "      <td>7.1</td>\n",
       "      <td>3.393</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1787</th>\n",
       "      <td>003330773-01</td>\n",
       "      <td>3330773</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.012</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.990779</td>\n",
       "      <td>132.118014</td>\n",
       "      <td>...</td>\n",
       "      <td>0.740</td>\n",
       "      <td>4864</td>\n",
       "      <td>4.555</td>\n",
       "      <td>0.01741</td>\n",
       "      <td>0.005848</td>\n",
       "      <td>1.95</td>\n",
       "      <td>0.1997</td>\n",
       "      <td>10.3</td>\n",
       "      <td>905.851</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1839</th>\n",
       "      <td>003340070-04</td>\n",
       "      <td>3340070</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.036</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>403.699203</td>\n",
       "      <td>251.666599</td>\n",
       "      <td>...</td>\n",
       "      <td>0.867</td>\n",
       "      <td>5904</td>\n",
       "      <td>4.543</td>\n",
       "      <td>1.05378</td>\n",
       "      <td>0.030337</td>\n",
       "      <td>924.56</td>\n",
       "      <td>0.4154</td>\n",
       "      <td>7.6</td>\n",
       "      <td>0.737</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2224</th>\n",
       "      <td>003526555-01</td>\n",
       "      <td>3526555</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.036</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>456.072278</td>\n",
       "      <td>181.708454</td>\n",
       "      <td>...</td>\n",
       "      <td>0.709</td>\n",
       "      <td>5356</td>\n",
       "      <td>4.576</td>\n",
       "      <td>1.02522</td>\n",
       "      <td>0.027883</td>\n",
       "      <td>256.77</td>\n",
       "      <td>0.8869</td>\n",
       "      <td>7.1</td>\n",
       "      <td>0.353</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2246</th>\n",
       "      <td>003532734-01</td>\n",
       "      <td>3532734</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.011</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>49.672804</td>\n",
       "      <td>177.924453</td>\n",
       "      <td>...</td>\n",
       "      <td>5.544</td>\n",
       "      <td>4888</td>\n",
       "      <td>3.082</td>\n",
       "      <td>0.29263</td>\n",
       "      <td>0.015427</td>\n",
       "      <td>16.19</td>\n",
       "      <td>0.8676</td>\n",
       "      <td>8.6</td>\n",
       "      <td>183.575</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3183</th>\n",
       "      <td>003940418-02</td>\n",
       "      <td>3940418</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.021</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>397.771585</td>\n",
       "      <td>226.057985</td>\n",
       "      <td>...</td>\n",
       "      <td>0.807</td>\n",
       "      <td>5170</td>\n",
       "      <td>4.574</td>\n",
       "      <td>1.01870</td>\n",
       "      <td>0.024705</td>\n",
       "      <td>174.64</td>\n",
       "      <td>0.4214</td>\n",
       "      <td>8.7</td>\n",
       "      <td>0.402</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3496</th>\n",
       "      <td>004060287-01</td>\n",
       "      <td>4060287</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.036</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>270.624274</td>\n",
       "      <td>373.341968</td>\n",
       "      <td>...</td>\n",
       "      <td>0.839</td>\n",
       "      <td>5497</td>\n",
       "      <td>4.570</td>\n",
       "      <td>0.80622</td>\n",
       "      <td>0.033638</td>\n",
       "      <td>330.31</td>\n",
       "      <td>0.6114</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.886</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4420</th>\n",
       "      <td>004476139-01</td>\n",
       "      <td>4476139</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.015</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>174.344339</td>\n",
       "      <td>290.969339</td>\n",
       "      <td>...</td>\n",
       "      <td>0.836</td>\n",
       "      <td>6167</td>\n",
       "      <td>4.503</td>\n",
       "      <td>0.56987</td>\n",
       "      <td>0.020569</td>\n",
       "      <td>155.35</td>\n",
       "      <td>0.7829</td>\n",
       "      <td>7.4</td>\n",
       "      <td>2.789</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4723</th>\n",
       "      <td>004640798-01</td>\n",
       "      <td>4640798</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.019</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>409.737511</td>\n",
       "      <td>290.732716</td>\n",
       "      <td>...</td>\n",
       "      <td>0.889</td>\n",
       "      <td>5418</td>\n",
       "      <td>4.436</td>\n",
       "      <td>0.99676</td>\n",
       "      <td>0.019023</td>\n",
       "      <td>184.24</td>\n",
       "      <td>0.6995</td>\n",
       "      <td>7.1</td>\n",
       "      <td>0.614</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5800</th>\n",
       "      <td>004988995-01</td>\n",
       "      <td>4988995</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.011</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>256.805886</td>\n",
       "      <td>352.337052</td>\n",
       "      <td>...</td>\n",
       "      <td>1.327</td>\n",
       "      <td>5569</td>\n",
       "      <td>4.165</td>\n",
       "      <td>0.77449</td>\n",
       "      <td>0.014232</td>\n",
       "      <td>303.05</td>\n",
       "      <td>0.2942</td>\n",
       "      <td>7.1</td>\n",
       "      <td>2.530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6048</th>\n",
       "      <td>005040003-01</td>\n",
       "      <td>5040003</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.039</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.239758</td>\n",
       "      <td>133.698203</td>\n",
       "      <td>...</td>\n",
       "      <td>3.479</td>\n",
       "      <td>5198</td>\n",
       "      <td>3.518</td>\n",
       "      <td>0.06692</td>\n",
       "      <td>0.005582</td>\n",
       "      <td>7.49</td>\n",
       "      <td>0.4903</td>\n",
       "      <td>7.4</td>\n",
       "      <td>1767.928</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6372</th>\n",
       "      <td>005179232-01</td>\n",
       "      <td>5179232</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.040</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>246.583120</td>\n",
       "      <td>364.907190</td>\n",
       "      <td>...</td>\n",
       "      <td>0.911</td>\n",
       "      <td>5246</td>\n",
       "      <td>4.435</td>\n",
       "      <td>0.72169</td>\n",
       "      <td>0.022103</td>\n",
       "      <td>555.45</td>\n",
       "      <td>0.4431</td>\n",
       "      <td>7.7</td>\n",
       "      <td>1.081</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7988</th>\n",
       "      <td>005544413-02</td>\n",
       "      <td>5544413</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.012</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>72.079069</td>\n",
       "      <td>156.460974</td>\n",
       "      <td>...</td>\n",
       "      <td>0.976</td>\n",
       "      <td>6040</td>\n",
       "      <td>4.438</td>\n",
       "      <td>0.33358</td>\n",
       "      <td>0.008435</td>\n",
       "      <td>60.63</td>\n",
       "      <td>0.3052</td>\n",
       "      <td>6.6</td>\n",
       "      <td>10.208</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8874</th>\n",
       "      <td>005772756-01</td>\n",
       "      <td>5772756</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.013</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>231.901920</td>\n",
       "      <td>169.581357</td>\n",
       "      <td>...</td>\n",
       "      <td>4.313</td>\n",
       "      <td>5177</td>\n",
       "      <td>3.428</td>\n",
       "      <td>0.90171</td>\n",
       "      <td>0.014624</td>\n",
       "      <td>75.79</td>\n",
       "      <td>0.6366</td>\n",
       "      <td>8.4</td>\n",
       "      <td>14.724</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9448</th>\n",
       "      <td>005905736-01</td>\n",
       "      <td>5905736</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.032</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>137.308666</td>\n",
       "      <td>166.767500</td>\n",
       "      <td>...</td>\n",
       "      <td>8.591</td>\n",
       "      <td>4808</td>\n",
       "      <td>2.870</td>\n",
       "      <td>0.65593</td>\n",
       "      <td>0.026719</td>\n",
       "      <td>370.35</td>\n",
       "      <td>0.5477</td>\n",
       "      <td>7.2</td>\n",
       "      <td>82.133</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9887</th>\n",
       "      <td>006038777-02</td>\n",
       "      <td>6038777</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.024</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>362.924753</td>\n",
       "      <td>165.420753</td>\n",
       "      <td>...</td>\n",
       "      <td>0.956</td>\n",
       "      <td>6029</td>\n",
       "      <td>4.494</td>\n",
       "      <td>1.00897</td>\n",
       "      <td>0.030355</td>\n",
       "      <td>184.67</td>\n",
       "      <td>0.2303</td>\n",
       "      <td>7.5</td>\n",
       "      <td>1.063</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>006347809-01</td>\n",
       "      <td>6347809</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.019</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>283.604542</td>\n",
       "      <td>297.099065</td>\n",
       "      <td>...</td>\n",
       "      <td>1.075</td>\n",
       "      <td>6322</td>\n",
       "      <td>4.426</td>\n",
       "      <td>0.87857</td>\n",
       "      <td>0.018307</td>\n",
       "      <td>185.79</td>\n",
       "      <td>0.2976</td>\n",
       "      <td>6.8</td>\n",
       "      <td>2.143</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11329</th>\n",
       "      <td>006422367-04</td>\n",
       "      <td>6422367</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.028</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>350.849388</td>\n",
       "      <td>225.666660</td>\n",
       "      <td>...</td>\n",
       "      <td>0.728</td>\n",
       "      <td>5344</td>\n",
       "      <td>4.550</td>\n",
       "      <td>0.85875</td>\n",
       "      <td>0.024270</td>\n",
       "      <td>769.97</td>\n",
       "      <td>0.4222</td>\n",
       "      <td>7.5</td>\n",
       "      <td>0.525</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11493</th>\n",
       "      <td>006450010-01</td>\n",
       "      <td>6450010</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.030</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>367.404274</td>\n",
       "      <td>179.979098</td>\n",
       "      <td>...</td>\n",
       "      <td>3.313</td>\n",
       "      <td>5214</td>\n",
       "      <td>3.569</td>\n",
       "      <td>1.14535</td>\n",
       "      <td>0.022328</td>\n",
       "      <td>526.49</td>\n",
       "      <td>0.5867</td>\n",
       "      <td>9.1</td>\n",
       "      <td>5.540</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13322</th>\n",
       "      <td>007008200-03</td>\n",
       "      <td>7008200</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.025</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>280.203243</td>\n",
       "      <td>380.924533</td>\n",
       "      <td>...</td>\n",
       "      <td>1.567</td>\n",
       "      <td>7012</td>\n",
       "      <td>4.138</td>\n",
       "      <td>0.89826</td>\n",
       "      <td>0.014820</td>\n",
       "      <td>844.94</td>\n",
       "      <td>0.1129</td>\n",
       "      <td>7.7</td>\n",
       "      <td>6.592</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13400</th>\n",
       "      <td>007026272-01</td>\n",
       "      <td>7026272</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.043</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>186.504031</td>\n",
       "      <td>307.918787</td>\n",
       "      <td>...</td>\n",
       "      <td>0.719</td>\n",
       "      <td>5254</td>\n",
       "      <td>4.624</td>\n",
       "      <td>0.59145</td>\n",
       "      <td>0.018640</td>\n",
       "      <td>120.01</td>\n",
       "      <td>0.2665</td>\n",
       "      <td>7.8</td>\n",
       "      <td>1.009</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15254</th>\n",
       "      <td>007515103-01</td>\n",
       "      <td>7515103</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.033</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>216.193703</td>\n",
       "      <td>208.849022</td>\n",
       "      <td>...</td>\n",
       "      <td>0.921</td>\n",
       "      <td>6086</td>\n",
       "      <td>4.511</td>\n",
       "      <td>0.70587</td>\n",
       "      <td>0.021075</td>\n",
       "      <td>274.12</td>\n",
       "      <td>0.8118</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.093</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15476</th>\n",
       "      <td>007594098-01</td>\n",
       "      <td>7594098</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.032</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>171.432610</td>\n",
       "      <td>204.927623</td>\n",
       "      <td>...</td>\n",
       "      <td>0.843</td>\n",
       "      <td>5842</td>\n",
       "      <td>4.556</td>\n",
       "      <td>0.59017</td>\n",
       "      <td>0.010760</td>\n",
       "      <td>142.86</td>\n",
       "      <td>0.0826</td>\n",
       "      <td>7.7</td>\n",
       "      <td>2.129</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15563</th>\n",
       "      <td>007613898-01</td>\n",
       "      <td>7613898</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.016</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>313.299571</td>\n",
       "      <td>197.290488</td>\n",
       "      <td>...</td>\n",
       "      <td>0.735</td>\n",
       "      <td>5314</td>\n",
       "      <td>4.545</td>\n",
       "      <td>0.79835</td>\n",
       "      <td>0.022316</td>\n",
       "      <td>143.00</td>\n",
       "      <td>0.7537</td>\n",
       "      <td>5.7</td>\n",
       "      <td>0.606</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15958</th>\n",
       "      <td>007732163-01</td>\n",
       "      <td>7732163</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.013</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>226.637011</td>\n",
       "      <td>189.664012</td>\n",
       "      <td>...</td>\n",
       "      <td>0.639</td>\n",
       "      <td>4893</td>\n",
       "      <td>4.623</td>\n",
       "      <td>0.62218</td>\n",
       "      <td>0.025659</td>\n",
       "      <td>544.99</td>\n",
       "      <td>0.2658</td>\n",
       "      <td>6.9</td>\n",
       "      <td>0.542</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16935</th>\n",
       "      <td>007960279-01</td>\n",
       "      <td>7960279</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.049</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>433.030127</td>\n",
       "      <td>312.484036</td>\n",
       "      <td>...</td>\n",
       "      <td>0.811</td>\n",
       "      <td>5377</td>\n",
       "      <td>4.575</td>\n",
       "      <td>1.08240</td>\n",
       "      <td>0.020113</td>\n",
       "      <td>249.52</td>\n",
       "      <td>0.5099</td>\n",
       "      <td>6.9</td>\n",
       "      <td>0.420</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17831</th>\n",
       "      <td>008155300-01</td>\n",
       "      <td>8155300</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.014</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>382.321313</td>\n",
       "      <td>357.592947</td>\n",
       "      <td>...</td>\n",
       "      <td>1.163</td>\n",
       "      <td>6369</td>\n",
       "      <td>4.312</td>\n",
       "      <td>1.03523</td>\n",
       "      <td>0.014036</td>\n",
       "      <td>103.22</td>\n",
       "      <td>0.7672</td>\n",
       "      <td>9.6</td>\n",
       "      <td>1.861</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18176</th>\n",
       "      <td>008219151-01</td>\n",
       "      <td>8219151</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.021</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>281.838618</td>\n",
       "      <td>392.955245</td>\n",
       "      <td>...</td>\n",
       "      <td>1.707</td>\n",
       "      <td>7163</td>\n",
       "      <td>4.143</td>\n",
       "      <td>0.95833</td>\n",
       "      <td>0.018020</td>\n",
       "      <td>316.29</td>\n",
       "      <td>0.8808</td>\n",
       "      <td>7.7</td>\n",
       "      <td>7.484</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18776</th>\n",
       "      <td>008312853-01</td>\n",
       "      <td>8312853</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.044</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>251.643226</td>\n",
       "      <td>242.983154</td>\n",
       "      <td>...</td>\n",
       "      <td>1.036</td>\n",
       "      <td>5771</td>\n",
       "      <td>4.370</td>\n",
       "      <td>0.75822</td>\n",
       "      <td>0.009673</td>\n",
       "      <td>511.47</td>\n",
       "      <td>0.2678</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.855</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21645</th>\n",
       "      <td>008939837-01</td>\n",
       "      <td>8939837</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.038</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>323.686409</td>\n",
       "      <td>261.170576</td>\n",
       "      <td>...</td>\n",
       "      <td>1.026</td>\n",
       "      <td>6161</td>\n",
       "      <td>4.426</td>\n",
       "      <td>0.93008</td>\n",
       "      <td>0.013178</td>\n",
       "      <td>151.12</td>\n",
       "      <td>0.3308</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1.571</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21730</th>\n",
       "      <td>008956025-02</td>\n",
       "      <td>8956025</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.029</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86.408921</td>\n",
       "      <td>163.543199</td>\n",
       "      <td>...</td>\n",
       "      <td>0.624</td>\n",
       "      <td>3913</td>\n",
       "      <td>4.642</td>\n",
       "      <td>0.32673</td>\n",
       "      <td>0.042459</td>\n",
       "      <td>45.76</td>\n",
       "      <td>0.4852</td>\n",
       "      <td>6.7</td>\n",
       "      <td>0.766</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21736</th>\n",
       "      <td>008956706-05</td>\n",
       "      <td>8956706</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.021</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>351.650750</td>\n",
       "      <td>176.911716</td>\n",
       "      <td>...</td>\n",
       "      <td>0.740</td>\n",
       "      <td>5066</td>\n",
       "      <td>4.593</td>\n",
       "      <td>0.89866</td>\n",
       "      <td>0.041309</td>\n",
       "      <td>394.42</td>\n",
       "      <td>0.8468</td>\n",
       "      <td>8.8</td>\n",
       "      <td>0.400</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21737</th>\n",
       "      <td>008956706-06</td>\n",
       "      <td>8956706</td>\n",
       "      <td>PC</td>\n",
       "      <td>0.043</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>376.767778</td>\n",
       "      <td>135.079867</td>\n",
       "      <td>...</td>\n",
       "      <td>0.740</td>\n",
       "      <td>5066</td>\n",
       "      <td>4.593</td>\n",
       "      <td>0.94095</td>\n",
       "      <td>0.036176</td>\n",
       "      <td>518.27</td>\n",
       "      <td>0.5808</td>\n",
       "      <td>9.2</td>\n",
       "      <td>0.365</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21789</th>\n",
       "      <td>008963059-01</td>\n",
       "      <td>8963059</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.030</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>507.753753</td>\n",
       "      <td>437.573370</td>\n",
       "      <td>...</td>\n",
       "      <td>1.794</td>\n",
       "      <td>5386</td>\n",
       "      <td>3.855</td>\n",
       "      <td>1.17584</td>\n",
       "      <td>0.015511</td>\n",
       "      <td>564.56</td>\n",
       "      <td>0.7100</td>\n",
       "      <td>7.3</td>\n",
       "      <td>1.755</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21992</th>\n",
       "      <td>009024729-01</td>\n",
       "      <td>9024729</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.021</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>258.722122</td>\n",
       "      <td>219.588349</td>\n",
       "      <td>...</td>\n",
       "      <td>0.946</td>\n",
       "      <td>5959</td>\n",
       "      <td>4.481</td>\n",
       "      <td>0.79161</td>\n",
       "      <td>0.023035</td>\n",
       "      <td>394.17</td>\n",
       "      <td>0.2787</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.613</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22198</th>\n",
       "      <td>009084222-03</td>\n",
       "      <td>9084222</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.032</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>99.257541</td>\n",
       "      <td>224.726965</td>\n",
       "      <td>...</td>\n",
       "      <td>0.811</td>\n",
       "      <td>5017</td>\n",
       "      <td>4.508</td>\n",
       "      <td>0.38508</td>\n",
       "      <td>0.025153</td>\n",
       "      <td>280.65</td>\n",
       "      <td>0.5139</td>\n",
       "      <td>7.3</td>\n",
       "      <td>2.518</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23186</th>\n",
       "      <td>009348924-01</td>\n",
       "      <td>9348924</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.027</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>401.331951</td>\n",
       "      <td>192.536937</td>\n",
       "      <td>...</td>\n",
       "      <td>0.994</td>\n",
       "      <td>5574</td>\n",
       "      <td>4.355</td>\n",
       "      <td>0.99531</td>\n",
       "      <td>0.016565</td>\n",
       "      <td>179.57</td>\n",
       "      <td>0.7058</td>\n",
       "      <td>7.8</td>\n",
       "      <td>0.863</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23441</th>\n",
       "      <td>009415129-01</td>\n",
       "      <td>9415129</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.040</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>205.110578</td>\n",
       "      <td>161.868257</td>\n",
       "      <td>...</td>\n",
       "      <td>0.820</td>\n",
       "      <td>5557</td>\n",
       "      <td>4.524</td>\n",
       "      <td>0.63714</td>\n",
       "      <td>0.024908</td>\n",
       "      <td>571.55</td>\n",
       "      <td>0.4999</td>\n",
       "      <td>7.4</td>\n",
       "      <td>1.415</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24889</th>\n",
       "      <td>009763796-01</td>\n",
       "      <td>9763796</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.032</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>277.077402</td>\n",
       "      <td>251.225722</td>\n",
       "      <td>...</td>\n",
       "      <td>6.517</td>\n",
       "      <td>5160</td>\n",
       "      <td>3.071</td>\n",
       "      <td>1.01654</td>\n",
       "      <td>0.021798</td>\n",
       "      <td>482.81</td>\n",
       "      <td>0.1466</td>\n",
       "      <td>7.0</td>\n",
       "      <td>26.106</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25625</th>\n",
       "      <td>009943441-02</td>\n",
       "      <td>9943441</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.020</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42.988070</td>\n",
       "      <td>139.230809</td>\n",
       "      <td>...</td>\n",
       "      <td>3.653</td>\n",
       "      <td>7773</td>\n",
       "      <td>3.613</td>\n",
       "      <td>0.30248</td>\n",
       "      <td>0.012503</td>\n",
       "      <td>226.78</td>\n",
       "      <td>0.3613</td>\n",
       "      <td>7.3</td>\n",
       "      <td>477.033</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25700</th>\n",
       "      <td>009957415-01</td>\n",
       "      <td>9957415</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.019</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>284.445032</td>\n",
       "      <td>239.318230</td>\n",
       "      <td>...</td>\n",
       "      <td>0.931</td>\n",
       "      <td>5841</td>\n",
       "      <td>4.520</td>\n",
       "      <td>0.85966</td>\n",
       "      <td>0.021231</td>\n",
       "      <td>92.95</td>\n",
       "      <td>0.8004</td>\n",
       "      <td>6.6</td>\n",
       "      <td>1.223</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25777</th>\n",
       "      <td>009967646-01</td>\n",
       "      <td>9967646</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.020</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>151.690028</td>\n",
       "      <td>221.305715</td>\n",
       "      <td>...</td>\n",
       "      <td>15.155</td>\n",
       "      <td>5072</td>\n",
       "      <td>2.489</td>\n",
       "      <td>0.76391</td>\n",
       "      <td>0.030171</td>\n",
       "      <td>316.50</td>\n",
       "      <td>0.4760</td>\n",
       "      <td>8.0</td>\n",
       "      <td>233.366</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26475</th>\n",
       "      <td>010198937-01</td>\n",
       "      <td>10198937</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.014</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>237.238351</td>\n",
       "      <td>235.876241</td>\n",
       "      <td>...</td>\n",
       "      <td>1.691</td>\n",
       "      <td>6795</td>\n",
       "      <td>4.141</td>\n",
       "      <td>0.84771</td>\n",
       "      <td>0.009123</td>\n",
       "      <td>146.90</td>\n",
       "      <td>0.3019</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.600</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26489</th>\n",
       "      <td>010201255-02</td>\n",
       "      <td>10201255</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.022</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>334.038428</td>\n",
       "      <td>319.078996</td>\n",
       "      <td>...</td>\n",
       "      <td>0.917</td>\n",
       "      <td>6113</td>\n",
       "      <td>4.512</td>\n",
       "      <td>0.94147</td>\n",
       "      <td>0.012718</td>\n",
       "      <td>188.31</td>\n",
       "      <td>0.3009</td>\n",
       "      <td>5.5</td>\n",
       "      <td>1.187</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27906</th>\n",
       "      <td>010621791-01</td>\n",
       "      <td>10621791</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.013</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.348916</td>\n",
       "      <td>132.313549</td>\n",
       "      <td>...</td>\n",
       "      <td>1.642</td>\n",
       "      <td>7305</td>\n",
       "      <td>4.168</td>\n",
       "      <td>0.02704</td>\n",
       "      <td>0.004731</td>\n",
       "      <td>1.93</td>\n",
       "      <td>0.3000</td>\n",
       "      <td>9.2</td>\n",
       "      <td>9411.448</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28108</th>\n",
       "      <td>010678963-06</td>\n",
       "      <td>10678963</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.028</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>195.941873</td>\n",
       "      <td>268.482435</td>\n",
       "      <td>...</td>\n",
       "      <td>1.655</td>\n",
       "      <td>7050</td>\n",
       "      <td>4.176</td>\n",
       "      <td>0.75564</td>\n",
       "      <td>0.019624</td>\n",
       "      <td>515.53</td>\n",
       "      <td>0.2789</td>\n",
       "      <td>7.7</td>\n",
       "      <td>10.617</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28168</th>\n",
       "      <td>010722101-01</td>\n",
       "      <td>10722101</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.036</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>424.793826</td>\n",
       "      <td>254.777495</td>\n",
       "      <td>...</td>\n",
       "      <td>1.006</td>\n",
       "      <td>6181</td>\n",
       "      <td>4.464</td>\n",
       "      <td>1.13296</td>\n",
       "      <td>0.017865</td>\n",
       "      <td>667.05</td>\n",
       "      <td>0.0795</td>\n",
       "      <td>7.1</td>\n",
       "      <td>1.031</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28254</th>\n",
       "      <td>010736157-01</td>\n",
       "      <td>10736157</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.024</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>471.620861</td>\n",
       "      <td>177.914466</td>\n",
       "      <td>...</td>\n",
       "      <td>1.061</td>\n",
       "      <td>6170</td>\n",
       "      <td>4.437</td>\n",
       "      <td>1.23270</td>\n",
       "      <td>0.018652</td>\n",
       "      <td>116.26</td>\n",
       "      <td>0.9108</td>\n",
       "      <td>5.2</td>\n",
       "      <td>0.962</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28510</th>\n",
       "      <td>010817608-01</td>\n",
       "      <td>10817608</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.014</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>524.753574</td>\n",
       "      <td>215.923250</td>\n",
       "      <td>...</td>\n",
       "      <td>0.586</td>\n",
       "      <td>4790</td>\n",
       "      <td>4.667</td>\n",
       "      <td>1.06318</td>\n",
       "      <td>0.021227</td>\n",
       "      <td>251.70</td>\n",
       "      <td>0.2662</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.143</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28743</th>\n",
       "      <td>010909367-06</td>\n",
       "      <td>10909367</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.011</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>103.302853</td>\n",
       "      <td>194.293093</td>\n",
       "      <td>...</td>\n",
       "      <td>0.513</td>\n",
       "      <td>3805</td>\n",
       "      <td>4.733</td>\n",
       "      <td>0.34635</td>\n",
       "      <td>0.027341</td>\n",
       "      <td>223.73</td>\n",
       "      <td>0.3376</td>\n",
       "      <td>7.2</td>\n",
       "      <td>0.412</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29219</th>\n",
       "      <td>011075429-07</td>\n",
       "      <td>11075429</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.019</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>118.726252</td>\n",
       "      <td>217.971834</td>\n",
       "      <td>...</td>\n",
       "      <td>1.972</td>\n",
       "      <td>7121</td>\n",
       "      <td>4.031</td>\n",
       "      <td>0.54409</td>\n",
       "      <td>0.010223</td>\n",
       "      <td>179.44</td>\n",
       "      <td>0.0928</td>\n",
       "      <td>6.3</td>\n",
       "      <td>30.264</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29445</th>\n",
       "      <td>011141326-01</td>\n",
       "      <td>11141326</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.017</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>467.000095</td>\n",
       "      <td>151.412388</td>\n",
       "      <td>...</td>\n",
       "      <td>1.826</td>\n",
       "      <td>5262</td>\n",
       "      <td>3.836</td>\n",
       "      <td>1.10894</td>\n",
       "      <td>0.021265</td>\n",
       "      <td>731.42</td>\n",
       "      <td>0.7058</td>\n",
       "      <td>7.8</td>\n",
       "      <td>1.862</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30210</th>\n",
       "      <td>011450551-01</td>\n",
       "      <td>11450551</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.011</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>366.853683</td>\n",
       "      <td>318.672844</td>\n",
       "      <td>...</td>\n",
       "      <td>1.174</td>\n",
       "      <td>6467</td>\n",
       "      <td>4.377</td>\n",
       "      <td>1.06531</td>\n",
       "      <td>0.014708</td>\n",
       "      <td>287.69</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>5.6</td>\n",
       "      <td>1.903</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30405</th>\n",
       "      <td>011512820-01</td>\n",
       "      <td>11512820</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.013</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38.926088</td>\n",
       "      <td>159.769387</td>\n",
       "      <td>...</td>\n",
       "      <td>1.125</td>\n",
       "      <td>6185</td>\n",
       "      <td>4.359</td>\n",
       "      <td>0.22888</td>\n",
       "      <td>0.004633</td>\n",
       "      <td>28.67</td>\n",
       "      <td>0.0987</td>\n",
       "      <td>7.5</td>\n",
       "      <td>31.676</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31044</th>\n",
       "      <td>011760959-04</td>\n",
       "      <td>11760959</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.026</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>127.765806</td>\n",
       "      <td>202.410414</td>\n",
       "      <td>...</td>\n",
       "      <td>0.744</td>\n",
       "      <td>4922</td>\n",
       "      <td>4.555</td>\n",
       "      <td>0.44592</td>\n",
       "      <td>0.035842</td>\n",
       "      <td>63.08</td>\n",
       "      <td>0.1593</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.464</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31300</th>\n",
       "      <td>011861688-01</td>\n",
       "      <td>11861688</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.021</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>285.782952</td>\n",
       "      <td>233.751440</td>\n",
       "      <td>...</td>\n",
       "      <td>0.886</td>\n",
       "      <td>5671</td>\n",
       "      <td>4.541</td>\n",
       "      <td>0.84790</td>\n",
       "      <td>0.028682</td>\n",
       "      <td>697.47</td>\n",
       "      <td>0.4481</td>\n",
       "      <td>7.8</td>\n",
       "      <td>1.012</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32075</th>\n",
       "      <td>012266450-01</td>\n",
       "      <td>12266450</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.033</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>473.728882</td>\n",
       "      <td>306.311384</td>\n",
       "      <td>...</td>\n",
       "      <td>1.168</td>\n",
       "      <td>6875</td>\n",
       "      <td>4.376</td>\n",
       "      <td>1.25799</td>\n",
       "      <td>0.020796</td>\n",
       "      <td>737.23</td>\n",
       "      <td>0.5459</td>\n",
       "      <td>7.1</td>\n",
       "      <td>1.725</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32305</th>\n",
       "      <td>012459725-01</td>\n",
       "      <td>12459725</td>\n",
       "      <td>FP</td>\n",
       "      <td>0.014</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>340.331273</td>\n",
       "      <td>228.217097</td>\n",
       "      <td>...</td>\n",
       "      <td>0.878</td>\n",
       "      <td>5799</td>\n",
       "      <td>4.539</td>\n",
       "      <td>0.94543</td>\n",
       "      <td>0.034144</td>\n",
       "      <td>722.84</td>\n",
       "      <td>0.6353</td>\n",
       "      <td>9.3</td>\n",
       "      <td>0.874</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>58 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             TCE_ID       KIC Disp  Score  NTL  SS  CO  EM      period  \\\n",
       "654    002452185-04   2452185   FP  0.011    1   0   0   0  415.953886   \n",
       "1787   003330773-01   3330773   FP  0.012    1   0   0   0    0.990779   \n",
       "1839   003340070-04   3340070   FP  0.036    0   0   1   0  403.699203   \n",
       "2224   003526555-01   3526555   FP  0.036    1   0   0   0  456.072278   \n",
       "2246   003532734-01   3532734   FP  0.011    1   0   0   0   49.672804   \n",
       "3183   003940418-02   3940418   FP  0.021    1   0   0   0  397.771585   \n",
       "3496   004060287-01   4060287   FP  0.036    1   0   0   0  270.624274   \n",
       "4420   004476139-01   4476139   FP  0.015    1   0   0   0  174.344339   \n",
       "4723   004640798-01   4640798   FP  0.019    1   0   0   0  409.737511   \n",
       "5800   004988995-01   4988995   FP  0.011    1   0   0   0  256.805886   \n",
       "6048   005040003-01   5040003   FP  0.039    1   0   0   0    5.239758   \n",
       "6372   005179232-01   5179232   FP  0.040    1   0   0   0  246.583120   \n",
       "7988   005544413-02   5544413   FP  0.012    1   0   0   0   72.079069   \n",
       "8874   005772756-01   5772756   FP  0.013    1   0   0   0  231.901920   \n",
       "9448   005905736-01   5905736   FP  0.032    1   0   0   0  137.308666   \n",
       "9887   006038777-02   6038777   FP  0.024    1   0   0   0  362.924753   \n",
       "11030  006347809-01   6347809   FP  0.019    1   0   0   0  283.604542   \n",
       "11329  006422367-04   6422367   FP  0.028    1   0   0   0  350.849388   \n",
       "11493  006450010-01   6450010   FP  0.030    1   0   0   0  367.404274   \n",
       "13322  007008200-03   7008200   FP  0.025    1   0   0   0  280.203243   \n",
       "13400  007026272-01   7026272   FP  0.043    1   0   0   0  186.504031   \n",
       "15254  007515103-01   7515103   FP  0.033    1   0   0   0  216.193703   \n",
       "15476  007594098-01   7594098   FP  0.032    1   0   0   0  171.432610   \n",
       "15563  007613898-01   7613898   FP  0.016    1   0   0   0  313.299571   \n",
       "15958  007732163-01   7732163   FP  0.013    1   0   0   0  226.637011   \n",
       "16935  007960279-01   7960279   FP  0.049    1   0   0   0  433.030127   \n",
       "17831  008155300-01   8155300   FP  0.014    1   0   0   0  382.321313   \n",
       "18176  008219151-01   8219151   FP  0.021    1   0   0   0  281.838618   \n",
       "18776  008312853-01   8312853   FP  0.044    1   0   0   0  251.643226   \n",
       "21645  008939837-01   8939837   FP  0.038    1   0   0   0  323.686409   \n",
       "21730  008956025-02   8956025   FP  0.029    1   0   0   0   86.408921   \n",
       "21736  008956706-05   8956706   FP  0.021    1   0   0   0  351.650750   \n",
       "21737  008956706-06   8956706   PC  0.043    0   0   0   0  376.767778   \n",
       "21789  008963059-01   8963059   FP  0.030    1   0   0   0  507.753753   \n",
       "21992  009024729-01   9024729   FP  0.021    1   0   0   0  258.722122   \n",
       "22198  009084222-03   9084222   FP  0.032    1   0   0   0   99.257541   \n",
       "23186  009348924-01   9348924   FP  0.027    1   0   0   0  401.331951   \n",
       "23441  009415129-01   9415129   FP  0.040    1   0   0   0  205.110578   \n",
       "24889  009763796-01   9763796   FP  0.032    1   0   0   0  277.077402   \n",
       "25625  009943441-02   9943441   FP  0.020    1   0   0   0   42.988070   \n",
       "25700  009957415-01   9957415   FP  0.019    1   0   0   0  284.445032   \n",
       "25777  009967646-01   9967646   FP  0.020    1   0   0   0  151.690028   \n",
       "26475  010198937-01  10198937   FP  0.014    1   0   0   0  237.238351   \n",
       "26489  010201255-02  10201255   FP  0.022    1   0   0   0  334.038428   \n",
       "27906  010621791-01  10621791   FP  0.013    1   0   0   0    1.348916   \n",
       "28108  010678963-06  10678963   FP  0.028    1   0   0   0  195.941873   \n",
       "28168  010722101-01  10722101   FP  0.036    1   0   0   0  424.793826   \n",
       "28254  010736157-01  10736157   FP  0.024    1   0   0   0  471.620861   \n",
       "28510  010817608-01  10817608   FP  0.014    1   0   0   0  524.753574   \n",
       "28743  010909367-06  10909367   FP  0.011    1   0   0   0  103.302853   \n",
       "29219  011075429-07  11075429   FP  0.019    1   0   0   0  118.726252   \n",
       "29445  011141326-01  11141326   FP  0.017    1   0   0   0  467.000095   \n",
       "30210  011450551-01  11450551   FP  0.011    1   0   0   0  366.853683   \n",
       "30405  011512820-01  11512820   FP  0.013    1   0   0   0   38.926088   \n",
       "31044  011760959-04  11760959   FP  0.026    1   0   0   0  127.765806   \n",
       "31300  011861688-01  11861688   FP  0.021    1   0   0   0  285.782952   \n",
       "32075  012266450-01  12266450   FP  0.033    1   0   0   0  473.728882   \n",
       "32305  012459725-01  12459725   FP  0.014    0   0   1   0  340.331273   \n",
       "\n",
       "            epoch  ...      Rs    Ts   logg        a     Rp/Rs    a/Rs  \\\n",
       "654    421.126974  ...   1.624  6704  4.126  1.18609  0.017439  294.45   \n",
       "1787   132.118014  ...   0.740  4864  4.555  0.01741  0.005848    1.95   \n",
       "1839   251.666599  ...   0.867  5904  4.543  1.05378  0.030337  924.56   \n",
       "2224   181.708454  ...   0.709  5356  4.576  1.02522  0.027883  256.77   \n",
       "2246   177.924453  ...   5.544  4888  3.082  0.29263  0.015427   16.19   \n",
       "3183   226.057985  ...   0.807  5170  4.574  1.01870  0.024705  174.64   \n",
       "3496   373.341968  ...   0.839  5497  4.570  0.80622  0.033638  330.31   \n",
       "4420   290.969339  ...   0.836  6167  4.503  0.56987  0.020569  155.35   \n",
       "4723   290.732716  ...   0.889  5418  4.436  0.99676  0.019023  184.24   \n",
       "5800   352.337052  ...   1.327  5569  4.165  0.77449  0.014232  303.05   \n",
       "6048   133.698203  ...   3.479  5198  3.518  0.06692  0.005582    7.49   \n",
       "6372   364.907190  ...   0.911  5246  4.435  0.72169  0.022103  555.45   \n",
       "7988   156.460974  ...   0.976  6040  4.438  0.33358  0.008435   60.63   \n",
       "8874   169.581357  ...   4.313  5177  3.428  0.90171  0.014624   75.79   \n",
       "9448   166.767500  ...   8.591  4808  2.870  0.65593  0.026719  370.35   \n",
       "9887   165.420753  ...   0.956  6029  4.494  1.00897  0.030355  184.67   \n",
       "11030  297.099065  ...   1.075  6322  4.426  0.87857  0.018307  185.79   \n",
       "11329  225.666660  ...   0.728  5344  4.550  0.85875  0.024270  769.97   \n",
       "11493  179.979098  ...   3.313  5214  3.569  1.14535  0.022328  526.49   \n",
       "13322  380.924533  ...   1.567  7012  4.138  0.89826  0.014820  844.94   \n",
       "13400  307.918787  ...   0.719  5254  4.624  0.59145  0.018640  120.01   \n",
       "15254  208.849022  ...   0.921  6086  4.511  0.70587  0.021075  274.12   \n",
       "15476  204.927623  ...   0.843  5842  4.556  0.59017  0.010760  142.86   \n",
       "15563  197.290488  ...   0.735  5314  4.545  0.79835  0.022316  143.00   \n",
       "15958  189.664012  ...   0.639  4893  4.623  0.62218  0.025659  544.99   \n",
       "16935  312.484036  ...   0.811  5377  4.575  1.08240  0.020113  249.52   \n",
       "17831  357.592947  ...   1.163  6369  4.312  1.03523  0.014036  103.22   \n",
       "18176  392.955245  ...   1.707  7163  4.143  0.95833  0.018020  316.29   \n",
       "18776  242.983154  ...   1.036  5771  4.370  0.75822  0.009673  511.47   \n",
       "21645  261.170576  ...   1.026  6161  4.426  0.93008  0.013178  151.12   \n",
       "21730  163.543199  ...   0.624  3913  4.642  0.32673  0.042459   45.76   \n",
       "21736  176.911716  ...   0.740  5066  4.593  0.89866  0.041309  394.42   \n",
       "21737  135.079867  ...   0.740  5066  4.593  0.94095  0.036176  518.27   \n",
       "21789  437.573370  ...   1.794  5386  3.855  1.17584  0.015511  564.56   \n",
       "21992  219.588349  ...   0.946  5959  4.481  0.79161  0.023035  394.17   \n",
       "22198  224.726965  ...   0.811  5017  4.508  0.38508  0.025153  280.65   \n",
       "23186  192.536937  ...   0.994  5574  4.355  0.99531  0.016565  179.57   \n",
       "23441  161.868257  ...   0.820  5557  4.524  0.63714  0.024908  571.55   \n",
       "24889  251.225722  ...   6.517  5160  3.071  1.01654  0.021798  482.81   \n",
       "25625  139.230809  ...   3.653  7773  3.613  0.30248  0.012503  226.78   \n",
       "25700  239.318230  ...   0.931  5841  4.520  0.85966  0.021231   92.95   \n",
       "25777  221.305715  ...  15.155  5072  2.489  0.76391  0.030171  316.50   \n",
       "26475  235.876241  ...   1.691  6795  4.141  0.84771  0.009123  146.90   \n",
       "26489  319.078996  ...   0.917  6113  4.512  0.94147  0.012718  188.31   \n",
       "27906  132.313549  ...   1.642  7305  4.168  0.02704  0.004731    1.93   \n",
       "28108  268.482435  ...   1.655  7050  4.176  0.75564  0.019624  515.53   \n",
       "28168  254.777495  ...   1.006  6181  4.464  1.13296  0.017865  667.05   \n",
       "28254  177.914466  ...   1.061  6170  4.437  1.23270  0.018652  116.26   \n",
       "28510  215.923250  ...   0.586  4790  4.667  1.06318  0.021227  251.70   \n",
       "28743  194.293093  ...   0.513  3805  4.733  0.34635  0.027341  223.73   \n",
       "29219  217.971834  ...   1.972  7121  4.031  0.54409  0.010223  179.44   \n",
       "29445  151.412388  ...   1.826  5262  3.836  1.10894  0.021265  731.42   \n",
       "30210  318.672844  ...   1.174  6467  4.377  1.06531  0.014708  287.69   \n",
       "30405  159.769387  ...   1.125  6185  4.359  0.22888  0.004633   28.67   \n",
       "31044  202.410414  ...   0.744  4922  4.555  0.44592  0.035842   63.08   \n",
       "31300  233.751440  ...   0.886  5671  4.541  0.84790  0.028682  697.47   \n",
       "32075  306.311384  ...   1.168  6875  4.376  1.25799  0.020796  737.23   \n",
       "32305  228.217097  ...   0.878  5799  4.539  0.94543  0.034144  722.84   \n",
       "\n",
       "       impact  SNR_DV        Sp  Fit_Prov  \n",
       "654    0.7892     7.1     3.393         1  \n",
       "1787   0.1997    10.3   905.851         1  \n",
       "1839   0.4154     7.6     0.737         1  \n",
       "2224   0.8869     7.1     0.353         1  \n",
       "2246   0.8676     8.6   183.575         1  \n",
       "3183   0.4214     8.7     0.402         1  \n",
       "3496   0.6114     9.0     0.886         1  \n",
       "4420   0.7829     7.4     2.789         1  \n",
       "4723   0.6995     7.1     0.614         1  \n",
       "5800   0.2942     7.1     2.530         1  \n",
       "6048   0.4903     7.4  1767.928         1  \n",
       "6372   0.4431     7.7     1.081         1  \n",
       "7988   0.3052     6.6    10.208         1  \n",
       "8874   0.6366     8.4    14.724         1  \n",
       "9448   0.5477     7.2    82.133         1  \n",
       "9887   0.2303     7.5     1.063         1  \n",
       "11030  0.2976     6.8     2.143         1  \n",
       "11329  0.4222     7.5     0.525         1  \n",
       "11493  0.5867     9.1     5.540         1  \n",
       "13322  0.1129     7.7     6.592         1  \n",
       "13400  0.2665     7.8     1.009         1  \n",
       "15254  0.8118     7.0     2.093         1  \n",
       "15476  0.0826     7.7     2.129         1  \n",
       "15563  0.7537     5.7     0.606         1  \n",
       "15958  0.2658     6.9     0.542         1  \n",
       "16935  0.5099     6.9     0.420         1  \n",
       "17831  0.7672     9.6     1.861         1  \n",
       "18176  0.8808     7.7     7.484         1  \n",
       "18776  0.2678     7.0     1.855         1  \n",
       "21645  0.3308     6.3     1.571         1  \n",
       "21730  0.4852     6.7     0.766         1  \n",
       "21736  0.8468     8.8     0.400         1  \n",
       "21737  0.5808     9.2     0.365         1  \n",
       "21789  0.7100     7.3     1.755         1  \n",
       "21992  0.2787     7.0     1.613         1  \n",
       "22198  0.5139     7.3     2.518         1  \n",
       "23186  0.7058     7.8     0.863         1  \n",
       "23441  0.4999     7.4     1.415         1  \n",
       "24889  0.1466     7.0    26.106         1  \n",
       "25625  0.3613     7.3   477.033         1  \n",
       "25700  0.8004     6.6     1.223         1  \n",
       "25777  0.4760     8.0   233.366         1  \n",
       "26475  0.3019     8.0     7.600         1  \n",
       "26489  0.3009     5.5     1.187         1  \n",
       "27906  0.3000     9.2  9411.448         1  \n",
       "28108  0.2789     7.7    10.617         1  \n",
       "28168  0.0795     7.1     1.031         1  \n",
       "28254  0.9108     5.2     0.962         1  \n",
       "28510  0.2662     8.0     0.143         1  \n",
       "28743  0.3376     7.2     0.412         1  \n",
       "29219  0.0928     6.3    30.264         1  \n",
       "29445  0.7058     7.8     1.862         1  \n",
       "30210  0.0000     5.6     1.903         1  \n",
       "30405  0.0987     7.5    31.676         1  \n",
       "31044  0.1593     8.0     1.464         1  \n",
       "31300  0.4481     7.8     1.012         1  \n",
       "32075  0.5459     7.1     1.725         1  \n",
       "32305  0.6353     9.3     0.874         1  \n",
       "\n",
       "[58 rows x 26 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# pull out the TCEs that are not KOIs\n",
    "highScoreTcesNotKois = highScoreTces[~highScoreTces['TCE_ID'].isin(dr25Koi['TCE_ID'])]\n",
    "highScoreTcesNotKois"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['TCE_ID',\n",
       " 'KIC',\n",
       " 'Disp',\n",
       " 'Score',\n",
       " 'NTL',\n",
       " 'SS',\n",
       " 'CO',\n",
       " 'EM',\n",
       " 'period',\n",
       " 'epoch',\n",
       " 'Expected_MES',\n",
       " 'MES',\n",
       " 'NTran',\n",
       " 'depth',\n",
       " 'duration',\n",
       " 'Rp',\n",
       " 'Rs',\n",
       " 'Ts',\n",
       " 'logg',\n",
       " 'a',\n",
       " 'Rp/Rs',\n",
       " 'a/Rs',\n",
       " 'impact',\n",
       " 'SNR_DV',\n",
       " 'Sp',\n",
       " 'Fit_Prov']"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(highScoreTcesNotKois)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "highScoreTcesNotKois.to_csv(\"midScoreTcesNotKois.csv\", \n",
    "              columns=[\"TCE_ID\", \"Score\", \"period\", \"Rp\", \"SNR_DV\"],\n",
    "             index=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " 415.953886\n",
      "   0.990779\n",
      " 403.699203\n",
      " 456.072278\n",
      "  49.672804\n",
      " 397.771585\n",
      " 270.624274\n",
      " 174.344339\n",
      " 409.737511\n",
      " 256.805886\n",
      "   5.239758\n",
      " 246.583120\n",
      "  72.079069\n",
      " 231.901920\n",
      " 137.308666\n",
      " 362.924753\n",
      " 283.604542\n",
      " 350.849388\n",
      " 367.404274\n",
      " 280.203243\n",
      " 186.504031\n",
      " 216.193703\n",
      " 171.432610\n",
      " 313.299571\n",
      " 226.637011\n",
      " 433.030127\n",
      " 382.321313\n",
      " 281.838618\n",
      " 251.643226\n",
      " 323.686409\n",
      "  86.408921\n",
      " 351.650750\n",
      " 376.767778\n",
      " 507.753753\n",
      " 258.722122\n",
      "  99.257541\n",
      " 401.331951\n",
      " 205.110578\n",
      " 277.077402\n",
      "  42.988070\n",
      " 284.445032\n",
      " 151.690028\n",
      " 237.238351\n",
      " 334.038428\n",
      "   1.348916\n",
      " 195.941873\n",
      " 424.793826\n",
      " 471.620861\n",
      " 524.753574\n",
      " 103.302853\n",
      " 118.726252\n",
      " 467.000095\n",
      " 366.853683\n",
      "  38.926088\n",
      " 127.765806\n",
      " 285.782952\n",
      " 473.728882\n",
      " 340.331273\n"
     ]
    }
   ],
   "source": [
    "print((highScoreTcesNotKois['period']).to_string(index=False))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}