2_Disposition_Correlations.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Disposition Correlations\n",
    "\n",
    "Disposition is the attempt to categorise KOI's into CANDIDATE or FALSE POSITIVE (with a score). \n",
    "\n",
    "This section also contains a list of boolean and string status flags (which could be one-hot-encoded = 126 fields)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The autoreload extension is already loaded. To reload it, use:\n",
      "  %reload_ext autoreload\n"
     ]
    }
   ],
   "source": [
    "# Python imports and settings\n",
    "import numpy  as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import scipy.stats\n",
    "import re\n",
    "from pydash import py_ as _\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "\n",
    "from src.dataset_koi import koi, koi_columns, koi_column_types\n",
    "from src.utilities import onehot_encode_comments\n",
    "\n",
    "# https://stackoverflow.com/questions/11707586/how-do-i-expand-the-output-display-to-see-more-columns-of-a-pandas-dataframe\n",
    "pd.set_option('display.max_columns', None)  \n",
    "pd.set_option('display.expand_frame_repr', False)\n",
    "pd.set_option('max_colwidth', -1)\n",
    "pd.set_option('display.max_rows', 8)  # 8 is required for .describe()\n",
    "\n",
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Load Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>kepler_name</th>\n",
       "      <th>koi_disposition</th>\n",
       "      <th>koi_disposition_CANDIDATE</th>\n",
       "      <th>koi_disposition_CONFIRMED</th>\n",
       "      <th>koi_disposition_FALSE POSITIVE</th>\n",
       "      <th>koi_pdisposition</th>\n",
       "      <th>koi_score</th>\n",
       "      <th>koi_fpflag_nt</th>\n",
       "      <th>koi_fpflag_ss</th>\n",
       "      <th>koi_fpflag_co</th>\n",
       "      <th>koi_fpflag_ec</th>\n",
       "      <th>koi_comment_ALL_TRANS_CHASES</th>\n",
       "      <th>koi_comment_ALT_ROBO_ODD_EVEN_TEST_FAIL</th>\n",
       "      <th>koi_comment_ALT_SEC_SAME_DEPTH_AS_PRI_COULD_BE_TWICE_TRUE_PERIOD</th>\n",
       "      <th>koi_comment_ALT_SIG_PRI_MINUS_SIG_POS_TOO_LOW</th>\n",
       "      <th>koi_comment_ALT_SIG_PRI_MINUS_SIG_TER_TOO_LOW</th>\n",
       "      <th>koi_comment_ALT_SIG_PRI_OVER_FRED_TOO_LOW</th>\n",
       "      <th>koi_comment_CENTROID_SIGNIF_UNCERTAIN</th>\n",
       "      <th>koi_comment_CENT_CROWDED</th>\n",
       "      <th>koi_comment_CENT_FEW_DIFFS</th>\n",
       "      <th>koi_comment_CENT_FEW_MEAS</th>\n",
       "      <th>koi_comment_CENT_KIC_POS</th>\n",
       "      <th>koi_comment_CENT_NOFITS</th>\n",
       "      <th>koi_comment_CENT_RESOLVED_OFFSET</th>\n",
       "      <th>koi_comment_CENT_SATURATED</th>\n",
       "      <th>koi_comment_CENT_UNCERTAIN</th>\n",
       "      <th>koi_comment_CENT_UNRESOLVED_OFFSET</th>\n",
       "      <th>koi_comment_CLEAR_APO</th>\n",
       "      <th>koi_comment_CROWDED_DIFF</th>\n",
       "      <th>koi_comment_DEEP_V_SHAPED</th>\n",
       "      <th>koi_comment_DEPTH_ODDEVEN_ALT</th>\n",
       "      <th>koi_comment_DEPTH_ODDEVEN_DV</th>\n",
       "      <th>koi_comment_DV_SIG_PRI_MINUS_SIG_POS_TOO_LOW</th>\n",
       "      <th>koi_comment_DV_SIG_PRI_OVER_FRED_TOO_LOW</th>\n",
       "      <th>koi_comment_EPHEM_MATCH</th>\n",
       "      <th>koi_comment_EYEBALL</th>\n",
       "      <th>koi_comment_FIT_FAILED</th>\n",
       "      <th>koi_comment_HALO_GHOST</th>\n",
       "      <th>koi_comment_HAS_SEC_TCE</th>\n",
       "      <th>koi_comment_INCONSISTENT_TRANS</th>\n",
       "      <th>koi_comment_INDIV_TRANS_CHASES</th>\n",
       "      <th>koi_comment_INDIV_TRANS_CHASES_MARSHALL</th>\n",
       "      <th>koi_comment_INDIV_TRANS_CHASES_MARSHALL_SKYE</th>\n",
       "      <th>koi_comment_INDIV_TRANS_CHASES_MARSHALL_ZUMA</th>\n",
       "      <th>koi_comment_INDIV_TRANS_CHASES_SKYE</th>\n",
       "      <th>koi_comment_INDIV_TRANS_MARSHALL</th>\n",
       "      <th>koi_comment_INDIV_TRANS_MARSHALL_SKYE</th>\n",
       "      <th>koi_comment_INDIV_TRANS_MARSHALL_ZUMA</th>\n",
       "      <th>koi_comment_INDIV_TRANS_RUBBLE</th>\n",
       "      <th>koi_comment_INDIV_TRANS_RUBBLE_MARSHALL_SKYE</th>\n",
       "      <th>koi_comment_INDIV_TRANS_RUBBLE_SKYE</th>\n",
       "      <th>koi_comment_INDIV_TRANS_RUBBLE_SKYE_ZUMA</th>\n",
       "      <th>koi_comment_INDIV_TRANS_RUBBLE_SKYE_ZUMA_TRACKER</th>\n",
       "      <th>koi_comment_INDIV_TRANS_SKYE</th>\n",
       "      <th>koi_comment_INDIV_TRANS_SKYE_ZUMA</th>\n",
       "      <th>koi_comment_INDIV_TRANS_SKYE_ZUMA_TRACKER</th>\n",
       "      <th>koi_comment_INDIV_TRANS_ZUMA</th>\n",
       "      <th>koi_comment_INVERT_DIFF</th>\n",
       "      <th>koi_comment_IS_SEC_TCE</th>\n",
       "      <th>koi_comment_KIC_OFFSET</th>\n",
       "      <th>koi_comment_LPP_ALT</th>\n",
       "      <th>koi_comment_LPP_ALT_TOO_HIGH</th>\n",
       "      <th>koi_comment_LPP_DV</th>\n",
       "      <th>koi_comment_LPP_DV_TOO_HIGH</th>\n",
       "      <th>koi_comment_MARSHALL_FAIL</th>\n",
       "      <th>koi_comment_MOD_NONUNIQ_ALT</th>\n",
       "      <th>koi_comment_MOD_NONUNIQ_DV</th>\n",
       "      <th>koi_comment_MOD_ODDEVEN_ALT</th>\n",
       "      <th>koi_comment_MOD_ODDEVEN_DV</th>\n",
       "      <th>koi_comment_MOD_POS_ALT</th>\n",
       "      <th>koi_comment_MOD_POS_DV</th>\n",
       "      <th>koi_comment_MOD_SEC_ALT</th>\n",
       "      <th>koi_comment_MOD_SEC_DV</th>\n",
       "      <th>koi_comment_MOD_TER_ALT</th>\n",
       "      <th>koi_comment_MOD_TER_DV</th>\n",
       "      <th>koi_comment_OTHER_TCE_AT_SAME_PERIOD_DIFF_EPOCH</th>\n",
       "      <th>koi_comment_PARENT_IS_002305372-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_002449084-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_003352751-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_003858884-01</th>\n",
       "      <th>koi_comment_PARENT_IS_004482641-01</th>\n",
       "      <th>koi_comment_PARENT_IS_005024292-01</th>\n",
       "      <th>koi_comment_PARENT_IS_005036538-01</th>\n",
       "      <th>koi_comment_PARENT_IS_005343976-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_005471619-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_005513861-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_006367628-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_007258889-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_007598128-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_008265951-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_008380743-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_009541127-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_009777062-01</th>\n",
       "      <th>koi_comment_PARENT_IS_010485137-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_010858720-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_012004679-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_3597.01</th>\n",
       "      <th>koi_comment_PARENT_IS_3895.01</th>\n",
       "      <th>koi_comment_PARENT_IS_4673.01</th>\n",
       "      <th>koi_comment_PARENT_IS_489.01</th>\n",
       "      <th>koi_comment_PARENT_IS_5335.01</th>\n",
       "      <th>koi_comment_PARENT_IS_970.01</th>\n",
       "      <th>koi_comment_PARENT_IS_FL-Lyr-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_RR-Lyr-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_UZ-Lyr-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_V2277-Cyg-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_V380-Cyg-pri</th>\n",
       "      <th>koi_comment_PARENT_IS_V380-Cyg-sec</th>\n",
       "      <th>koi_comment_PARENT_IS_V850-Cyg-pri</th>\n",
       "      <th>koi_comment_PERIOD_ALIAS_ALT</th>\n",
       "      <th>koi_comment_PERIOD_ALIAS_DV</th>\n",
       "      <th>koi_comment_PERIOD_ALIAS_IN_ALT_DATA_SEEN_AT_3:1</th>\n",
       "      <th>koi_comment_PERIOD_ALIAS_IN_DV_DATA_SEEN_AT_3:1</th>\n",
       "      <th>koi_comment_PLANET_IN_STAR</th>\n",
       "      <th>koi_comment_PLANET_OCCULT_ALT</th>\n",
       "      <th>koi_comment_PLANET_OCCULT_DV</th>\n",
       "      <th>koi_comment_PLANET_PERIOD_IS_HALF_ALT</th>\n",
       "      <th>koi_comment_PLANET_PERIOD_IS_HALF_DV</th>\n",
       "      <th>koi_comment_RESIDUAL_TCE</th>\n",
       "      <th>koi_comment_RESID_OF_PREV_TCE</th>\n",
       "      <th>koi_comment_SAME_NTL_PERIOD</th>\n",
       "      <th>koi_comment_SAME_P_AS_PREV_NTL_TCE</th>\n",
       "      <th>koi_comment_SATURATED</th>\n",
       "      <th>koi_comment_SEASONAL_DEPTH_ALT</th>\n",
       "      <th>koi_comment_SEASONAL_DEPTH_DIFFS_IN_ALT</th>\n",
       "      <th>koi_comment_SEASONAL_DEPTH_DV</th>\n",
       "      <th>koi_comment_SIGNIF_OFFSET</th>\n",
       "      <th>koi_comment_SIG_SEC_IN_ALT_MODEL_SHIFT</th>\n",
       "      <th>koi_comment_SIG_SEC_IN_DV_MODEL_SHIFT</th>\n",
       "      <th>koi_comment_SWEET_EB</th>\n",
       "      <th>koi_comment_SWEET_NTL</th>\n",
       "      <th>koi_comment_TOO_FEW_CENTROIDS</th>\n",
       "      <th>koi_comment_TOO_FEW_QUARTERS</th>\n",
       "      <th>koi_comment_TRANSITS_NOT_CONSISTENT</th>\n",
       "      <th>koi_comment_TRANS_GAPPED</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>kepoi_name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</td>\n",
       "      <td>Kepler-227 b</td>\n",
       "      <td>CONFIRMED</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>Kepler-227 c</td>\n",
       "      <td>CONFIRMED</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>0.969</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <td>K07986.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>0.497</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>0.092</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 135 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             kepler_name koi_disposition  koi_disposition_CANDIDATE  koi_disposition_CONFIRMED  koi_disposition_FALSE POSITIVE koi_pdisposition  koi_score  koi_fpflag_nt  koi_fpflag_ss  koi_fpflag_co  koi_fpflag_ec  koi_comment_ALL_TRANS_CHASES  koi_comment_ALT_ROBO_ODD_EVEN_TEST_FAIL  koi_comment_ALT_SEC_SAME_DEPTH_AS_PRI_COULD_BE_TWICE_TRUE_PERIOD  koi_comment_ALT_SIG_PRI_MINUS_SIG_POS_TOO_LOW  koi_comment_ALT_SIG_PRI_MINUS_SIG_TER_TOO_LOW  koi_comment_ALT_SIG_PRI_OVER_FRED_TOO_LOW  koi_comment_CENTROID_SIGNIF_UNCERTAIN  koi_comment_CENT_CROWDED  koi_comment_CENT_FEW_DIFFS  koi_comment_CENT_FEW_MEAS  koi_comment_CENT_KIC_POS  koi_comment_CENT_NOFITS  koi_comment_CENT_RESOLVED_OFFSET  koi_comment_CENT_SATURATED  koi_comment_CENT_UNCERTAIN  koi_comment_CENT_UNRESOLVED_OFFSET  koi_comment_CLEAR_APO  koi_comment_CROWDED_DIFF  koi_comment_DEEP_V_SHAPED  koi_comment_DEPTH_ODDEVEN_ALT  koi_comment_DEPTH_ODDEVEN_DV  koi_comment_DV_SIG_PRI_MINUS_SIG_POS_TOO_LOW  koi_comment_DV_SIG_PRI_OVER_FRED_TOO_LOW  koi_comment_EPHEM_MATCH  koi_comment_EYEBALL  koi_comment_FIT_FAILED  koi_comment_HALO_GHOST  koi_comment_HAS_SEC_TCE  koi_comment_INCONSISTENT_TRANS  koi_comment_INDIV_TRANS_CHASES  koi_comment_INDIV_TRANS_CHASES_MARSHALL  koi_comment_INDIV_TRANS_CHASES_MARSHALL_SKYE  koi_comment_INDIV_TRANS_CHASES_MARSHALL_ZUMA  koi_comment_INDIV_TRANS_CHASES_SKYE  koi_comment_INDIV_TRANS_MARSHALL  koi_comment_INDIV_TRANS_MARSHALL_SKYE  koi_comment_INDIV_TRANS_MARSHALL_ZUMA  koi_comment_INDIV_TRANS_RUBBLE  koi_comment_INDIV_TRANS_RUBBLE_MARSHALL_SKYE  koi_comment_INDIV_TRANS_RUBBLE_SKYE  koi_comment_INDIV_TRANS_RUBBLE_SKYE_ZUMA  koi_comment_INDIV_TRANS_RUBBLE_SKYE_ZUMA_TRACKER  koi_comment_INDIV_TRANS_SKYE  koi_comment_INDIV_TRANS_SKYE_ZUMA  koi_comment_INDIV_TRANS_SKYE_ZUMA_TRACKER  koi_comment_INDIV_TRANS_ZUMA  koi_comment_INVERT_DIFF  koi_comment_IS_SEC_TCE  koi_comment_KIC_OFFSET  koi_comment_LPP_ALT  koi_comment_LPP_ALT_TOO_HIGH  koi_comment_LPP_DV  koi_comment_LPP_DV_TOO_HIGH  koi_comment_MARSHALL_FAIL  koi_comment_MOD_NONUNIQ_ALT  koi_comment_MOD_NONUNIQ_DV  koi_comment_MOD_ODDEVEN_ALT  koi_comment_MOD_ODDEVEN_DV  koi_comment_MOD_POS_ALT  koi_comment_MOD_POS_DV  koi_comment_MOD_SEC_ALT  koi_comment_MOD_SEC_DV  koi_comment_MOD_TER_ALT  koi_comment_MOD_TER_DV  koi_comment_OTHER_TCE_AT_SAME_PERIOD_DIFF_EPOCH  koi_comment_PARENT_IS_002305372-pri  koi_comment_PARENT_IS_002449084-pri  koi_comment_PARENT_IS_003352751-pri  koi_comment_PARENT_IS_003858884-01  koi_comment_PARENT_IS_004482641-01  koi_comment_PARENT_IS_005024292-01  koi_comment_PARENT_IS_005036538-01  koi_comment_PARENT_IS_005343976-pri  koi_comment_PARENT_IS_005471619-pri  koi_comment_PARENT_IS_005513861-pri  koi_comment_PARENT_IS_006367628-pri  koi_comment_PARENT_IS_007258889-pri  koi_comment_PARENT_IS_007598128-pri  koi_comment_PARENT_IS_008265951-pri  koi_comment_PARENT_IS_008380743-pri  koi_comment_PARENT_IS_009541127-pri  koi_comment_PARENT_IS_009777062-01  koi_comment_PARENT_IS_010485137-pri  koi_comment_PARENT_IS_010858720-pri  koi_comment_PARENT_IS_012004679-pri  koi_comment_PARENT_IS_3597.01  koi_comment_PARENT_IS_3895.01  koi_comment_PARENT_IS_4673.01  koi_comment_PARENT_IS_489.01  koi_comment_PARENT_IS_5335.01  koi_comment_PARENT_IS_970.01  koi_comment_PARENT_IS_FL-Lyr-pri  koi_comment_PARENT_IS_RR-Lyr-pri  koi_comment_PARENT_IS_UZ-Lyr-pri  koi_comment_PARENT_IS_V2277-Cyg-pri  koi_comment_PARENT_IS_V380-Cyg-pri  koi_comment_PARENT_IS_V380-Cyg-sec  koi_comment_PARENT_IS_V850-Cyg-pri  koi_comment_PERIOD_ALIAS_ALT  koi_comment_PERIOD_ALIAS_DV  koi_comment_PERIOD_ALIAS_IN_ALT_DATA_SEEN_AT_3:1  koi_comment_PERIOD_ALIAS_IN_DV_DATA_SEEN_AT_3:1  koi_comment_PLANET_IN_STAR  koi_comment_PLANET_OCCULT_ALT  koi_comment_PLANET_OCCULT_DV  koi_comment_PLANET_PERIOD_IS_HALF_ALT  koi_comment_PLANET_PERIOD_IS_HALF_DV  koi_comment_RESIDUAL_TCE  koi_comment_RESID_OF_PREV_TCE  koi_comment_SAME_NTL_PERIOD  koi_comment_SAME_P_AS_PREV_NTL_TCE  koi_comment_SATURATED  koi_comment_SEASONAL_DEPTH_ALT  koi_comment_SEASONAL_DEPTH_DIFFS_IN_ALT  koi_comment_SEASONAL_DEPTH_DV  koi_comment_SIGNIF_OFFSET  koi_comment_SIG_SEC_IN_ALT_MODEL_SHIFT  koi_comment_SIG_SEC_IN_DV_MODEL_SHIFT  koi_comment_SWEET_EB  koi_comment_SWEET_NTL  koi_comment_TOO_FEW_CENTROIDS  koi_comment_TOO_FEW_QUARTERS  koi_comment_TRANSITS_NOT_CONSISTENT  koi_comment_TRANS_GAPPED\n",
       "kepoi_name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \n",
       "K00752.01   Kepler-227 b  CONFIRMED       0                          1                          0                               CANDIDATE        1.000      0              0              0              0              0                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        0                                 0                           0                           0                                   0                      0                         0                          0                              0                             0                                             0                                         0                        0                    0                       0                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           0                            0                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "K00752.02   Kepler-227 c  CONFIRMED       0                          1                          0                               CANDIDATE        0.969      0              0              0              0              0                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        0                                 0                           0                           0                                   0                      0                         0                          0                              0                             0                                             0                                         0                        0                    0                       0                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           0                            0                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "K00753.01   NaN           CANDIDATE       1                          0                          0                               CANDIDATE        0.000      0              0              0              0              0                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        0                                 0                           0                           0                                   0                      0                         1                          0                              0                             0                                             0                                         0                        0                    0                       0                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           0                            0                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "K00754.01   NaN           FALSE POSITIVE  0                          0                          1                               FALSE POSITIVE   0.000      0              1              0              0              0                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        0                                 0                           0                           0                                   0                      0                         1                          0                              0                             0                                             0                                         0                        0                    0                       0                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           1                            1                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "...         ...                 ...      ..                         ..                         ..                                     ...          ...     ..             ..             ..             ..             ..                            ..                                       ..                                                                ..                                             ..                                             ..                                         ..                                     ..                        ..                          ..                         ..                        ..                       ..                                ..                          ..                          ..                                  ..                     ..                        ..                         ..                             ..                            ..                                            ..                                        ..                       ..                   ..                      ..                      ..                       ..                              ..                              ..                                       ..                                            ..                                            ..                                   ..                                ..                                     ..                                     ..                              ..                                            ..                                   ..                                        ..                                                ..                            ..                                 ..                                         ..                            ..                       ..                      ..                      ..                   ..                            ..                  ..                           ..                         ..                           ..                          ..                           ..                          ..                       ..                      ..                       ..                      ..                       ..                      ..                                               ..                                   ..                                   ..                                   ..                                  ..                                  ..                                  ..                                  ..                                   ..                                   ..                                   ..                                   ..                                   ..                                   ..                                   ..                                   ..                                   ..                                  ..                                   ..                                   ..                                   ..                             ..                             ..                             ..                            ..                             ..                            ..                                ..                                ..                                ..                                   ..                                  ..                                  ..                                  ..                            ..                           ..                                                ..                                               ..                          ..                             ..                            ..                                     ..                                    ..                        ..                             ..                           ..                                  ..                     ..                              ..                                       ..                             ..                         ..                                      ..                                     ..                    ..                     ..                             ..                            ..                                   ..                       \n",
       "K07986.01   NaN           CANDIDATE       1                          0                          0                               CANDIDATE        0.497      0              0              0              0              0                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        0                                 0                           0                           0                                   0                      0                         0                          0                              0                             0                                             0                                         0                        0                    0                       0                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           0                            0                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "K07987.01   NaN           FALSE POSITIVE  0                          0                          1                               FALSE POSITIVE   0.021      0              0              1              0              0                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        1                                 0                           0                           0                                   0                      0                         0                          0                              0                             0                                             0                                         0                        0                    0                       0                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           0                            0                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "K07988.01   NaN           CANDIDATE       1                          0                          0                               CANDIDATE        0.092      0              0              0              0              1                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        0                                 1                           0                           0                                   0                      0                         0                          0                              0                             0                                             0                                         0                        0                    0                       0                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           0                            0                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "K07989.01   NaN           FALSE POSITIVE  0                          0                          1                               FALSE POSITIVE   0.000      0              0              1              1              0                             0                                        0                                                                 0                                              0                                              0                                          0                                      0                         0                           0                          0                         0                        1                                 0                           0                           0                                   0                      0                         0                          0                              0                             0                                             0                                         1                        0                    0                       1                       0                        0                               0                               0                                        0                                             0                                             0                                    0                                 0                                      0                                      0                               0                                             0                                    0                                         0                                                 0                             0                                  0                                          0                             0                        0                       0                       0                    0                             0                   0                            0                          0                            0                           0                            0                           0                        0                       0                        0                       0                        0                       0                                                0                                    0                                    0                                    0                                   0                                   0                                   0                                   0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                    0                                   0                                    0                                    0                                    0                              0                              0                              0                             0                              0                             0                                 0                                 0                                 0                                    0                                   0                                   0                                   0                             0                            0                                                 0                                                0                           0                              0                             0                                      0                                     0                         0                              0                            0                                   0                      0                               0                                        0                              0                          0                                       0                                      0                     0                      0                              0                             0                                    0                       \n",
       "\n",
       "[9564 rows x 135 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset            = pd.DataFrame.join( koi['archive'], koi['disposition'] ); \n",
    "onehot_disposition = pd.get_dummies(dataset[['koi_disposition']])\n",
    "onehot_comments    = onehot_encode_comments(dataset, 'koi_comment', '---', without=['NO_COMMENT']).astype('int32')\n",
    "\n",
    "onehot_dataset = (\n",
    "    pd.concat([ \n",
    "        koi['archive'], \n",
    "        onehot_disposition,\n",
    "        koi['disposition'],\n",
    "        onehot_comments,\n",
    "    ], axis=1)\n",
    "    .drop(columns=['koi_comment'])\n",
    ")\n",
    "onehot_dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Correlation between disposition and fpflags + comments "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Frequency - fpflags by koi_disposition\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>min</th>\n",
       "      <th>mean</th>\n",
       "      <th>max</th>\n",
       "      <th>sum</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>koi_disposition</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>CONFIRMED</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.006947</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001240</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.399504</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6775.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 min      mean  max     sum\n",
       "koi_disposition                            \n",
       "CONFIRMED        0.0  0.006947  1.0  16.0  \n",
       "CANDIDATE        0.0  0.001240  1.0  3.0   \n",
       "FALSE POSITIVE   0.0  1.399504  4.0  6775.0"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Frequency - comment flags by koi_disposition\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>min</th>\n",
       "      <th>mean</th>\n",
       "      <th>max</th>\n",
       "      <th>sum</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>koi_disposition</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>CONFIRMED</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.193660</td>\n",
       "      <td>6.0</td>\n",
       "      <td>446.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.397521</td>\n",
       "      <td>7.0</td>\n",
       "      <td>962.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.596158</td>\n",
       "      <td>11.0</td>\n",
       "      <td>12568.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 min      mean   max      sum\n",
       "koi_disposition                              \n",
       "CONFIRMED        0.0  0.193660  6.0   446.0  \n",
       "CANDIDATE        0.0  0.397521  7.0   962.0  \n",
       "FALSE POSITIVE   0.0  2.596158  11.0  12568.0"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "print(\"Frequency - fpflags by koi_disposition\")\n",
    "display(\n",
    "    onehot_dataset.groupby('koi_disposition', sort=False)\n",
    "        .apply(lambda df: \n",
    "            df.filter(regex='fpflag')\n",
    "                .sum(axis=1)\n",
    "                .agg([min, np.mean, max, np.sum])\n",
    "        )\n",
    ")\n",
    "print(\"Frequency - comment flags by koi_disposition\")\n",
    "display(\n",
    "    onehot_dataset\n",
    "        .groupby('koi_disposition', sort=False)\n",
    "        .apply(lambda df: \n",
    "            df.filter(regex='comment_')\n",
    "                .sum(axis=1)\n",
    "                .agg([min, np.mean, max, np.sum ])\n",
    "        )\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Observation: in the vast majority of cases the presence of fpflags or comments is used to indicate the reason for a FALSE POSITIVE\n",
    "\n",
    "- fpflags - only in 19 (0.2%) cases, does a single fpflag refer to a CONFIRMED or CANDIDATE exoplanets\n",
    "\n",
    "- comments - only 1408 (10%) of comments are used in labelling CONFIRMED or CANDIDATE exoplanets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "koi_disposition_columns = ['koi_disposition_CONFIRMED','koi_disposition_CANDIDATE','koi_disposition_FALSE POSITIVE']\n",
    "    \n",
    "def onehot_flag_corr( \n",
    "    row_regex='koi_disposition_|koi_score|koi_fpflag_|koi_comment_',\n",
    "    col_regex='koi_disposition_',\n",
    "    sort_fn=np.max\n",
    ") -> pd.DataFrame:\n",
    "    if col_regex == None:  col_regex = row_regex\n",
    "    \n",
    "    onehot_flag_corr = (\n",
    "        onehot_dataset\n",
    "            .filter(regex=row_regex)\n",
    "            .corr()\n",
    "            .filter(regex=col_regex)\n",
    "            .apply(lambda x: round(x, 2))\n",
    "    )\n",
    "\n",
    "    # Reorder disposition columns in conceptual order if col_regex='koi_disposition_'\n",
    "    # Also remove 'koi_disposition_' from rows\n",
    "    if all([ col in koi_disposition_columns for col in onehot_flag_corr.columns.tolist() ]): \n",
    "        onehot_flag_corr = onehot_flag_corr.reindex( columns=koi_disposition_columns )\n",
    "        onehot_flag_corr.drop( onehot_dataset[koi_disposition_columns], errors='ignore', inplace=True )\n",
    "    \n",
    "    # Sort by maximum absolute correlation\n",
    "    reindex_rows = onehot_flag_corr.abs()\n",
    "    if sort_fn: reindex_rows = sort_fn(reindex_rows, axis=1).sort_values(ascending=False)\n",
    "    \n",
    "    onehot_flag_corr = onehot_flag_corr.reindex( index=reindex_rows.index )\n",
    "    return onehot_flag_corr\n",
    "    \n",
    "def display_corr( corr: pd.DataFrame, style={} ):\n",
    "    style = _.assign({ \n",
    "        \"cmap\": 'coolwarm', \n",
    "        \"high\": 0.2, \n",
    "        \"low\":  0 \n",
    "    }, style)\n",
    "    display( corr.style.background_gradient(**style) )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_591e79fa_429f_11ea_9391_406c8f30d205row0_col0 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row0_col1 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row0_col2 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row1_col0 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row1_col1 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row1_col2 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row2_col0 {\n",
       "            background-color:  #3f53c6;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row2_col1 {\n",
       "            background-color:  #465ecf;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row2_col2 {\n",
       "            background-color:  #ed8366;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row3_col0 {\n",
       "            background-color:  #4a63d3;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row3_col1 {\n",
       "            background-color:  #5977e3;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row3_col2 {\n",
       "            background-color:  #f39475;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row4_col0 {\n",
       "            background-color:  #516ddb;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row4_col1 {\n",
       "            background-color:  #6b8df0;\n",
       "            color:  #000000;\n",
       "        }    #T_591e79fa_429f_11ea_9391_406c8f30d205row4_col2 {\n",
       "            background-color:  #f6a586;\n",
       "            color:  #000000;\n",
       "        }</style><table id=\"T_591e79fa_429f_11ea_9391_406c8f30d205\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >koi_disposition_CONFIRMED</th>        <th class=\"col_heading level0 col1\" >koi_disposition_CANDIDATE</th>        <th class=\"col_heading level0 col2\" >koi_disposition_FALSE POSITIVE</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_591e79fa_429f_11ea_9391_406c8f30d205level0_row0\" class=\"row_heading level0 row0\" >koi_score</th>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row0_col0\" class=\"data row0 col0\" >0.66</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row0_col1\" class=\"data row0 col1\" >0.27</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row0_col2\" class=\"data row0 col2\" >-0.8</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_591e79fa_429f_11ea_9391_406c8f30d205level0_row1\" class=\"row_heading level0 row1\" >koi_fpflag_ss</th>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row1_col0\" class=\"data row1 col0\" >-0.3</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row1_col1\" class=\"data row1 col1\" >-0.32</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row1_col2\" class=\"data row1 col2\" >0.54</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_591e79fa_429f_11ea_9391_406c8f30d205level0_row2\" class=\"row_heading level0 row2\" >koi_fpflag_co</th>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row2_col0\" class=\"data row2 col0\" >-0.28</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row2_col1\" class=\"data row2 col1\" >-0.29</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row2_col2\" class=\"data row2 col2\" >0.49</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_591e79fa_429f_11ea_9391_406c8f30d205level0_row3\" class=\"row_heading level0 row3\" >koi_fpflag_nt</th>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row3_col0\" class=\"data row3 col0\" >-0.24</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row3_col1\" class=\"data row3 col1\" >-0.25</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row3_col2\" class=\"data row3 col2\" >0.43</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_591e79fa_429f_11ea_9391_406c8f30d205level0_row4\" class=\"row_heading level0 row4\" >koi_fpflag_ec</th>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row4_col0\" class=\"data row4 col0\" >-0.21</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row4_col1\" class=\"data row4 col1\" >-0.21</td>\n",
       "                        <td id=\"T_591e79fa_429f_11ea_9391_406c8f30d205row4_col2\" class=\"data row4 col2\" >0.36</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x126878190>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display_corr( onehot_flag_corr('koi_disposition_|koi_fpflag_|koi_score') )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Observations:\n",
    "\n",
    "- koi_score: is [defined](https://exoplanetarchive.ipac.caltech.edu/docs/API_kepcandidate_columns.html) by the fraction of Monte Carlo iterations where the Robovetter yields a disposition of CANDIDATE. This almost by definition it is strongly-correlated with CONFIRMED and strongly-anti-correlated with FALSE POSITIVE. CANDIDATE is almost completely uncorrleated with koi_score.\n",
    "\n",
    "- koi_fpflags: each of the flags strongly-correlates with FALSE POSITIVE, and shares a half-strength anti-correlation with both CONFIRMED and CANDIDATE. This matches the previous observation that the vast majority (99.8%) of fpflags indicated a FALSE POSITIVE."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Correlation between fpflags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_5931e792_429f_11ea_9391_406c8f30d205row0_col0 {\n",
       "            background-color:  #023858;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row0_col1 {\n",
       "            background-color:  #fff7fb;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row0_col2 {\n",
       "            background-color:  #fff7fb;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row0_col3 {\n",
       "            background-color:  #fff7fb;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row1_col0 {\n",
       "            background-color:  #fff7fb;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row1_col1 {\n",
       "            background-color:  #023858;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row1_col2 {\n",
       "            background-color:  #e8e4f0;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row1_col3 {\n",
       "            background-color:  #f9f2f8;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row2_col0 {\n",
       "            background-color:  #dddbec;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row2_col1 {\n",
       "            background-color:  #bcc7e1;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row2_col2 {\n",
       "            background-color:  #023858;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row2_col3 {\n",
       "            background-color:  #78abd0;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row3_col0 {\n",
       "            background-color:  #d3d4e7;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row3_col1 {\n",
       "            background-color:  #cacee5;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row3_col2 {\n",
       "            background-color:  #6da6cd;\n",
       "            color:  #000000;\n",
       "        }    #T_5931e792_429f_11ea_9391_406c8f30d205row3_col3 {\n",
       "            background-color:  #023858;\n",
       "            color:  #f1f1f1;\n",
       "        }</style><table id=\"T_5931e792_429f_11ea_9391_406c8f30d205\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >koi_fpflag_nt</th>        <th class=\"col_heading level0 col1\" >koi_fpflag_ss</th>        <th class=\"col_heading level0 col2\" >koi_fpflag_co</th>        <th class=\"col_heading level0 col3\" >koi_fpflag_ec</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_5931e792_429f_11ea_9391_406c8f30d205level0_row0\" class=\"row_heading level0 row0\" >koi_fpflag_nt</th>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row0_col0\" class=\"data row0 col0\" >1</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row0_col1\" class=\"data row0 col1\" >-0.23</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row0_col2\" class=\"data row0 col2\" >0.01</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row0_col3\" class=\"data row0 col3\" >0.06</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5931e792_429f_11ea_9391_406c8f30d205level0_row1\" class=\"row_heading level0 row1\" >koi_fpflag_ss</th>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row1_col0\" class=\"data row1 col0\" >-0.23</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row1_col1\" class=\"data row1 col1\" >1</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row1_col2\" class=\"data row1 col2\" >0.15</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row1_col3\" class=\"data row1 col3\" >0.1</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5931e792_429f_11ea_9391_406c8f30d205level0_row2\" class=\"row_heading level0 row2\" >koi_fpflag_co</th>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row2_col0\" class=\"data row2 col0\" >0.01</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row2_col1\" class=\"data row2 col1\" >0.15</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row2_col2\" class=\"data row2 col2\" >1</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row2_col3\" class=\"data row2 col3\" >0.52</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5931e792_429f_11ea_9391_406c8f30d205level0_row3\" class=\"row_heading level0 row3\" >koi_fpflag_ec</th>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row3_col0\" class=\"data row3 col0\" >0.06</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row3_col1\" class=\"data row3 col1\" >0.1</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row3_col2\" class=\"data row3 col2\" >0.52</td>\n",
       "                        <td id=\"T_5931e792_429f_11ea_9391_406c8f30d205row3_col3\" class=\"data row3 col3\" >1</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x12ab52490>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fpflags_corr = onehot_flag_corr('koi_fpflag_', col_regex=None, sort_fn=None) \n",
    "fpflags_corr.style.background_gradient()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "According to the [documention](https://exoplanetarchive.ipac.caltech.edu/docs/API_kepcandidate_columns.html):\n",
    "- koi_fpflag_nt = Not Transit-Like Flag\n",
    "    - A KOI whose light curve is not consistent with that of a transiting planet. This includes, but is not limited to, instrumental artifacts, non-eclipsing variable stars, and spurious (very low SNR) detections.\n",
    "- koi_fpflag_ss = Stellar Eclipse Flag\n",
    "    - A KOI that is observed to have a significant secondary event, transit shape, or out-of-eclipse variability, which indicates that the transit-like event is most likely caused by an eclipsing binary. However, self-luminous, hot Jupiters with a visible secondary eclipse will also have this flag set, but with a disposition of PC.\n",
    "- koi_fpflag_co = Centroid Offset Flag\n",
    "    - The source of the signal is from a nearby star, as inferred by measuring the centroid location of the image both in and out of transit, or by the strength of the transit signal in the target's outer (halo) pixels as compared to the transit signal from the pixels in the optimal (or core) aperture.\n",
    "- koi_fpflag_ec = Ephemeris Match Indicates Contamination Flag\n",
    "    - The KOI shares the same period and epoch as another object and is judged to be the result of flux contamination in the aperture or electronic crosstalk\n",
    "\n",
    "Observations: \n",
    "- There is mild anti-correlation between: koi_fpflag_nt + koi_fpflag_ss\n",
    "    - This is because a Stellar Eclipse has Transit like properties\n",
    "- There is high correlation between: koi_fpflag_co + koi_fpflag_ec\n",
    "    - A Centroid Pixel Offset is a common cause of Contamination"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Correlation of Comment Flags with Disposition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Top correlations: koi_disposition_CONFIRMED: >= 0.02 | -0.22 >=\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_598514a8_429f_11ea_9391_406c8f30d205row0_col0 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row0_col1 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row0_col2 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row1_col0 {\n",
       "            background-color:  #f59d7e;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row1_col1 {\n",
       "            background-color:  #f7b497;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row1_col2 {\n",
       "            background-color:  #6282ea;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row2_col0 {\n",
       "            background-color:  #f59d7e;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row2_col1 {\n",
       "            background-color:  #f7b497;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row2_col2 {\n",
       "            background-color:  #5b7ae5;\n",
       "            color:  #000000;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row3_col0 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row3_col1 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_598514a8_429f_11ea_9391_406c8f30d205row3_col2 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }</style><table id=\"T_598514a8_429f_11ea_9391_406c8f30d205\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >koi_disposition_CONFIRMED</th>        <th class=\"col_heading level0 col1\" >koi_disposition_CANDIDATE</th>        <th class=\"col_heading level0 col2\" >koi_disposition_FALSE POSITIVE</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_598514a8_429f_11ea_9391_406c8f30d205level0_row0\" class=\"row_heading level0 row0\" >koi_comment_CENT_KIC_POS</th>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row0_col0\" class=\"data row0 col0\" >0.05</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row0_col1\" class=\"data row0 col1\" >0.04</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row0_col2\" class=\"data row0 col2\" >-0.07</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_598514a8_429f_11ea_9391_406c8f30d205level0_row1\" class=\"row_heading level0 row1\" >koi_comment_PLANET_OCCULT_ALT</th>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row1_col0\" class=\"data row1 col0\" >0.02</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row1_col1\" class=\"data row1 col1\" >-0.01</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row1_col2\" class=\"data row1 col2\" >-0</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_598514a8_429f_11ea_9391_406c8f30d205level0_row2\" class=\"row_heading level0 row2\" >koi_comment_INDIV_TRANS_MARSHALL_ZUMA</th>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row2_col0\" class=\"data row2 col0\" >0.02</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row2_col1\" class=\"data row2 col1\" >-0.01</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row2_col2\" class=\"data row2 col2\" >-0.01</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_598514a8_429f_11ea_9391_406c8f30d205level0_row3\" class=\"row_heading level0 row3\" >koi_comment_MOD_SEC_ALT</th>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row3_col0\" class=\"data row3 col0\" >-0.22</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row3_col1\" class=\"data row3 col1\" >-0.23</td>\n",
       "                        <td id=\"T_598514a8_429f_11ea_9391_406c8f30d205row3_col2\" class=\"data row3 col2\" >0.39</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x129822610>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Top correlations: koi_disposition_CANDIDATE: >= 0.03 | -0.22 >=\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_59bf268e_429f_11ea_9391_406c8f30d205row0_col0 {\n",
       "            background-color:  #ead4c8;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row0_col1 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row0_col2 {\n",
       "            background-color:  #4a63d3;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row1_col0 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row1_col1 {\n",
       "            background-color:  #f6a385;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row1_col2 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row2_col0 {\n",
       "            background-color:  #e3d9d3;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row2_col1 {\n",
       "            background-color:  #f6a385;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row2_col2 {\n",
       "            background-color:  #688aef;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row3_col0 {\n",
       "            background-color:  #f6bea4;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row3_col1 {\n",
       "            background-color:  #f7ad90;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row3_col2 {\n",
       "            background-color:  #5673e0;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row4_col0 {\n",
       "            background-color:  #f4c6af;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row4_col1 {\n",
       "            background-color:  #f7ad90;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row4_col2 {\n",
       "            background-color:  #5b7ae5;\n",
       "            color:  #000000;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row5_col0 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row5_col1 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_59bf268e_429f_11ea_9391_406c8f30d205row5_col2 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }</style><table id=\"T_59bf268e_429f_11ea_9391_406c8f30d205\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >koi_disposition_CONFIRMED</th>        <th class=\"col_heading level0 col1\" >koi_disposition_CANDIDATE</th>        <th class=\"col_heading level0 col2\" >koi_disposition_FALSE POSITIVE</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_59bf268e_429f_11ea_9391_406c8f30d205level0_row0\" class=\"row_heading level0 row0\" >koi_comment_CENT_FEW_MEAS</th>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row0_col0\" class=\"data row0 col0\" >-0.04</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row0_col1\" class=\"data row0 col1\" >0.08</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row0_col2\" class=\"data row0 col2\" >-0.04</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_59bf268e_429f_11ea_9391_406c8f30d205level0_row1\" class=\"row_heading level0 row1\" >koi_comment_CENT_KIC_POS</th>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row1_col0\" class=\"data row1 col0\" >0.05</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row1_col1\" class=\"data row1 col1\" >0.04</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row1_col2\" class=\"data row1 col2\" >-0.07</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_59bf268e_429f_11ea_9391_406c8f30d205level0_row2\" class=\"row_heading level0 row2\" >koi_comment_TOO_FEW_QUARTERS</th>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row2_col0\" class=\"data row2 col0\" >-0.05</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row2_col1\" class=\"data row2 col1\" >0.04</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row2_col2\" class=\"data row2 col2\" >0.01</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_59bf268e_429f_11ea_9391_406c8f30d205level0_row3\" class=\"row_heading level0 row3\" >koi_comment_INDIV_TRANS_CHASES_SKYE</th>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row3_col0\" class=\"data row3 col0\" >-0.01</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row3_col1\" class=\"data row3 col1\" >0.03</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row3_col2\" class=\"data row3 col2\" >-0.02</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_59bf268e_429f_11ea_9391_406c8f30d205level0_row4\" class=\"row_heading level0 row4\" >koi_comment_TOO_FEW_CENTROIDS</th>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row4_col0\" class=\"data row4 col0\" >-0.02</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row4_col1\" class=\"data row4 col1\" >0.03</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row4_col2\" class=\"data row4 col2\" >-0.01</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_59bf268e_429f_11ea_9391_406c8f30d205level0_row5\" class=\"row_heading level0 row5\" >koi_comment_MOD_SEC_ALT</th>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row5_col0\" class=\"data row5 col0\" >-0.22</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row5_col1\" class=\"data row5 col1\" >-0.23</td>\n",
       "                        <td id=\"T_59bf268e_429f_11ea_9391_406c8f30d205row5_col2\" class=\"data row5 col2\" >0.39</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x12ab5a410>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Top correlations: koi_disposition_FALSE POSITIVE: >= 0.1 | -0.02 >=\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row0_col0 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row0_col1 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row0_col2 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row1_col0 {\n",
       "            background-color:  #4c66d6;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row1_col1 {\n",
       "            background-color:  #4a63d3;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row1_col2 {\n",
       "            background-color:  #f39577;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row2_col0 {\n",
       "            background-color:  #4c66d6;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row2_col1 {\n",
       "            background-color:  #536edd;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row2_col2 {\n",
       "            background-color:  #f59c7d;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row3_col0 {\n",
       "            background-color:  #4c66d6;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row3_col1 {\n",
       "            background-color:  #536edd;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row3_col2 {\n",
       "            background-color:  #f59c7d;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row4_col0 {\n",
       "            background-color:  #4c66d6;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row4_col1 {\n",
       "            background-color:  #5b7ae5;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row4_col2 {\n",
       "            background-color:  #f6a385;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row5_col0 {\n",
       "            background-color:  #6180e9;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row5_col1 {\n",
       "            background-color:  #6485ec;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row5_col2 {\n",
       "            background-color:  #f7b093;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row6_col0 {\n",
       "            background-color:  #6180e9;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row6_col1 {\n",
       "            background-color:  #81a4fb;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row6_col2 {\n",
       "            background-color:  #f6bda2;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row7_col0 {\n",
       "            background-color:  #97b8ff;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row7_col1 {\n",
       "            background-color:  #93b5fe;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row7_col2 {\n",
       "            background-color:  #e3d9d3;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row8_col0 {\n",
       "            background-color:  #a2c1ff;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row8_col1 {\n",
       "            background-color:  #9dbdff;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row8_col2 {\n",
       "            background-color:  #dedcdb;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row9_col0 {\n",
       "            background-color:  #a2c1ff;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row9_col1 {\n",
       "            background-color:  #9dbdff;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row9_col2 {\n",
       "            background-color:  #dadce0;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row10_col0 {\n",
       "            background-color:  #abc8fd;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row10_col1 {\n",
       "            background-color:  #afcafc;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row10_col2 {\n",
       "            background-color:  #d5dbe5;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row11_col0 {\n",
       "            background-color:  #b6cefa;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row11_col1 {\n",
       "            background-color:  #b9d0f9;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row11_col2 {\n",
       "            background-color:  #cbd8ee;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row12_col0 {\n",
       "            background-color:  #cad8ef;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row12_col1 {\n",
       "            background-color:  #b9d0f9;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row12_col2 {\n",
       "            background-color:  #c0d4f5;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row13_col0 {\n",
       "            background-color:  #cad8ef;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row13_col1 {\n",
       "            background-color:  #c1d4f4;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row13_col2 {\n",
       "            background-color:  #bad0f8;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row14_col0 {\n",
       "            background-color:  #d3dbe7;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row14_col1 {\n",
       "            background-color:  #c1d4f4;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row14_col2 {\n",
       "            background-color:  #b3cdfb;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row15_col0 {\n",
       "            background-color:  #c0d4f5;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row15_col1 {\n",
       "            background-color:  #d1dae9;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row15_col2 {\n",
       "            background-color:  #b3cdfb;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row16_col0 {\n",
       "            background-color:  #f6bea4;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row16_col1 {\n",
       "            background-color:  #f7ad90;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row16_col2 {\n",
       "            background-color:  #5673e0;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row17_col0 {\n",
       "            background-color:  #ead4c8;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row17_col1 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row17_col2 {\n",
       "            background-color:  #4a63d3;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row18_col0 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row18_col1 {\n",
       "            background-color:  #f6a385;\n",
       "            color:  #000000;\n",
       "        }    #T_5a0d12d6_429f_11ea_9391_406c8f30d205row18_col2 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }</style><table id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >koi_disposition_CONFIRMED</th>        <th class=\"col_heading level0 col1\" >koi_disposition_CANDIDATE</th>        <th class=\"col_heading level0 col2\" >koi_disposition_FALSE POSITIVE</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row0\" class=\"row_heading level0 row0\" >koi_comment_MOD_SEC_ALT</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row0_col0\" class=\"data row0 col0\" >-0.22</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row0_col1\" class=\"data row0 col1\" >-0.23</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row0_col2\" class=\"data row0 col2\" >0.39</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row1\" class=\"row_heading level0 row1\" >koi_comment_EPHEM_MATCH</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row1_col0\" class=\"data row1 col0\" >-0.2</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row1_col1\" class=\"data row1 col1\" >-0.21</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row1_col2\" class=\"data row1 col2\" >0.35</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row2\" class=\"row_heading level0 row2\" >koi_comment_MOD_SEC_DV</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row2_col0\" class=\"data row2 col0\" >-0.2</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row2_col1\" class=\"data row2 col1\" >-0.2</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row2_col2\" class=\"data row2 col2\" >0.34</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row3\" class=\"row_heading level0 row3\" >koi_comment_HAS_SEC_TCE</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row3_col0\" class=\"data row3 col0\" >-0.2</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row3_col1\" class=\"data row3 col1\" >-0.2</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row3_col2\" class=\"data row3 col2\" >0.34</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row4\" class=\"row_heading level0 row4\" >koi_comment_CENT_RESOLVED_OFFSET</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row4_col0\" class=\"data row4 col0\" >-0.2</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row4_col1\" class=\"data row4 col1\" >-0.19</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row4_col2\" class=\"data row4 col2\" >0.33</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row5\" class=\"row_heading level0 row5\" >koi_comment_HALO_GHOST</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row5_col0\" class=\"data row5 col0\" >-0.18</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row5_col1\" class=\"data row5 col1\" >-0.18</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row5_col2\" class=\"data row5 col2\" >0.31</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row6\" class=\"row_heading level0 row6\" >koi_comment_DEEP_V_SHAPED</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row6_col0\" class=\"data row6 col0\" >-0.18</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row6_col1\" class=\"data row6 col1\" >-0.15</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row6_col2\" class=\"data row6 col2\" >0.29</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row7\" class=\"row_heading level0 row7\" >koi_comment_MOD_ODDEVEN_ALT</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row7_col0\" class=\"data row7 col0\" >-0.13</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row7_col1\" class=\"data row7 col1\" >-0.13</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row7_col2\" class=\"data row7 col2\" >0.22</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row8\" class=\"row_heading level0 row8\" >koi_comment_LPP_DV</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row8_col0\" class=\"data row8 col0\" >-0.12</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row8_col1\" class=\"data row8 col1\" >-0.12</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row8_col2\" class=\"data row8 col2\" >0.21</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row9\" class=\"row_heading level0 row9\" >koi_comment_MOD_ODDEVEN_DV</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row9_col0\" class=\"data row9 col0\" >-0.12</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row9_col1\" class=\"data row9 col1\" >-0.12</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row9_col2\" class=\"data row9 col2\" >0.2</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row10\" class=\"row_heading level0 row10\" >koi_comment_CENT_UNRESOLVED_OFFSET</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row10_col0\" class=\"data row10 col0\" >-0.11</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row10_col1\" class=\"data row10 col1\" >-0.1</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row10_col2\" class=\"data row10 col2\" >0.19</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row11\" class=\"row_heading level0 row11\" >koi_comment_CENT_NOFITS</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row11_col0\" class=\"data row11 col0\" >-0.1</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row11_col1\" class=\"data row11 col1\" >-0.09</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row11_col2\" class=\"data row11 col2\" >0.17</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row12\" class=\"row_heading level0 row12\" >koi_comment_SWEET_EB</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row12_col0\" class=\"data row12 col0\" >-0.08</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row12_col1\" class=\"data row12 col1\" >-0.09</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row12_col2\" class=\"data row12 col2\" >0.15</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row13\" class=\"row_heading level0 row13\" >koi_comment_DEPTH_ODDEVEN_ALT</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row13_col0\" class=\"data row13 col0\" >-0.08</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row13_col1\" class=\"data row13 col1\" >-0.08</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row13_col2\" class=\"data row13 col2\" >0.14</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row14\" class=\"row_heading level0 row14\" >koi_comment_DEPTH_ODDEVEN_DV</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row14_col0\" class=\"data row14 col0\" >-0.07</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row14_col1\" class=\"data row14 col1\" >-0.08</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row14_col2\" class=\"data row14 col2\" >0.13</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row15\" class=\"row_heading level0 row15\" >koi_comment_MOD_NONUNIQ_ALT</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row15_col0\" class=\"data row15 col0\" >-0.09</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row15_col1\" class=\"data row15 col1\" >-0.06</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row15_col2\" class=\"data row15 col2\" >0.13</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row16\" class=\"row_heading level0 row16\" >koi_comment_INDIV_TRANS_CHASES_SKYE</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row16_col0\" class=\"data row16 col0\" >-0.01</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row16_col1\" class=\"data row16 col1\" >0.03</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row16_col2\" class=\"data row16 col2\" >-0.02</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row17\" class=\"row_heading level0 row17\" >koi_comment_CENT_FEW_MEAS</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row17_col0\" class=\"data row17 col0\" >-0.04</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row17_col1\" class=\"data row17 col1\" >0.08</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row17_col2\" class=\"data row17 col2\" >-0.04</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205level0_row18\" class=\"row_heading level0 row18\" >koi_comment_CENT_KIC_POS</th>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row18_col0\" class=\"data row18 col0\" >0.05</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row18_col1\" class=\"data row18 col1\" >0.04</td>\n",
       "                        <td id=\"T_5a0d12d6_429f_11ea_9391_406c8f30d205row18_col2\" class=\"data row18 col2\" >-0.07</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1297e3790>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Top correlations differences between CONFIRMED and CANDIDATE: >= 0.05\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_5a59af88_429f_11ea_9391_406c8f30d205row0_col0 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row0_col1 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row0_col2 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row1_col0 {\n",
       "            background-color:  #dddcdc;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row1_col1 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row1_col2 {\n",
       "            background-color:  #d9dce1;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row2_col0 {\n",
       "            background-color:  #efcebd;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row2_col1 {\n",
       "            background-color:  #97b8ff;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row2_col2 {\n",
       "            background-color:  #aec9fc;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row3_col0 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row3_col1 {\n",
       "            background-color:  #6687ed;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row3_col2 {\n",
       "            background-color:  #7ea1fa;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row4_col0 {\n",
       "            background-color:  #f7b89c;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row4_col1 {\n",
       "            background-color:  #e7745b;\n",
       "            color:  #000000;\n",
       "        }    #T_5a59af88_429f_11ea_9391_406c8f30d205row4_col2 {\n",
       "            background-color:  #3b4cc0;\n",
       "            color:  #f1f1f1;\n",
       "        }</style><table id=\"T_5a59af88_429f_11ea_9391_406c8f30d205\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >koi_disposition_CONFIRMED</th>        <th class=\"col_heading level0 col1\" >koi_disposition_CANDIDATE</th>        <th class=\"col_heading level0 col2\" >koi_disposition_FALSE POSITIVE</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_5a59af88_429f_11ea_9391_406c8f30d205level0_row0\" class=\"row_heading level0 row0\" >koi_comment_CENT_FEW_DIFFS</th>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row0_col0\" class=\"data row0 col0\" >-0.12</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row0_col1\" class=\"data row0 col1\" >0.02</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row0_col2\" class=\"data row0 col2\" >0.08</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a59af88_429f_11ea_9391_406c8f30d205level0_row1\" class=\"row_heading level0 row1\" >koi_comment_EYEBALL</th>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row1_col0\" class=\"data row1 col0\" >-0.06</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row1_col1\" class=\"data row1 col1\" >0.02</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row1_col2\" class=\"data row1 col2\" >0.03</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a59af88_429f_11ea_9391_406c8f30d205level0_row2\" class=\"row_heading level0 row2\" >koi_comment_TOO_FEW_QUARTERS</th>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row2_col0\" class=\"data row2 col0\" >-0.05</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row2_col1\" class=\"data row2 col1\" >0.04</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row2_col2\" class=\"data row2 col2\" >0.01</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a59af88_429f_11ea_9391_406c8f30d205level0_row3\" class=\"row_heading level0 row3\" >koi_comment_TOO_FEW_CENTROIDS</th>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row3_col0\" class=\"data row3 col0\" >-0.02</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row3_col1\" class=\"data row3 col1\" >0.03</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row3_col2\" class=\"data row3 col2\" >-0.01</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5a59af88_429f_11ea_9391_406c8f30d205level0_row4\" class=\"row_heading level0 row4\" >koi_comment_CENT_FEW_MEAS</th>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row4_col0\" class=\"data row4 col0\" >-0.04</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row4_col1\" class=\"data row4 col1\" >0.08</td>\n",
       "                        <td id=\"T_5a59af88_429f_11ea_9391_406c8f30d205row4_col2\" class=\"data row4 col2\" >-0.04</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x12a523cd0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for column in koi_disposition_columns:\n",
    "    limits = {\n",
    "        \"koi_disposition_CONFIRMED\":      (0.02, -0.22),\n",
    "        \"koi_disposition_CANDIDATE\":      (0.03, -0.22),\n",
    "        \"koi_disposition_FALSE POSITIVE\": (0.10, -0.02)        \n",
    "    }\n",
    "    print(f\"Top correlations: {column}: >= {limits[column][0]} | {limits[column][1]} >=\")\n",
    "    display_corr( \n",
    "        onehot_flag_corr('koi_disposition_|koi_comment_')\n",
    "            .where(lambda row: (row[column] >= limits[column][0] ) | (row[column] <= limits[column][1] ) ).dropna()\n",
    "            .sort_values(by=column, ascending=False),\n",
    "    )\n",
    "    \n",
    "print(f\"Top correlations differences between CONFIRMED and CANDIDATE: >= 0.05\")    \n",
    "display_corr( \n",
    "    onehot_flag_corr('koi_disposition_|koi_comment_')\n",
    "        .where(lambda row: (row['koi_disposition_CONFIRMED'] - row['koi_disposition_CANDIDATE'] ).abs() >= 0.05 ).dropna()\n",
    "        .sort_values(by=column, ascending=False),\n",
    ")    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Results:\n",
    "- A few comment flags positively correlate (weakly) with CONFIRMED\n",
    "    - CENT_KIC_POS\n",
    "    - PLANET_OCCULT_ALT\n",
    "    - INDIV_TRANS_MARSHALL_ZUMA\n",
    "- More comment flags positively correlate (weakly) with CANDIDATE\n",
    "    - CENT_KIC_POS\n",
    "    - CENT_FEW_MEAS\n",
    "    - TOO_FEW_QUARTERS\n",
    "    - INDIV_TRANS_CHASES_SKYE\n",
    "    - TOO_FEW_CENTROIDS\n",
    "- The comment flags that are most different between CONFIRMED and CANDIDATE are:\n",
    "    - CENT_FEW_DIFFS\n",
    "    - EYEBALL\n",
    "    - TOO_FEW_QUARTERS\n",
    "    - TOO_FEW_CENTROIDS\n",
    "    - CENT_FEW_MEAS    \n",
    "- The highest correlating fields with FALSE POSITIVE are:\n",
    "    - MOD_SEC_ALT\n",
    "    - EPHEM_MATCH\n",
    "    - MOD_SEC_DV\n",
    "    - HAS_SEC_TCE\n",
    "    - CENT_RESOLVED_OFFSET\n",
    "    - HALO_GHOST\n",
    "    - DEEP_V_SHAPED\n",
    "    \n",
    "Observations:\n",
    "- The vast majority of comment flags are correlated with FALSE POSITIVE and half anti-correlated with CONFIRMED or CANDIDATE\n",
    "- As observed above, 90% of comments are used to label FALSE POSITIVE\n",
    "- The fields that most correlate with CANDIDATE, are also those which have the greatest difference in correlation with CONFIRMED\n",
    "    - These all seem to flag having too little information about a KOI\n",
    "- According the [documention](https://exoplanetarchive.ipac.caltech.edu/docs/API_kepcandidate_columns.html), FALSE POSITIVE can occur when:\n",
    "    - 1) the KOI is in reality an eclipsing binary star\n",
    "    - 2) the Kepler light curve is contaminated by a background eclipsing binary\n",
    "    - 3) stellar variability is confused for coherent planetary transits\n",
    "    - 4) instrumental artifacts are confused for coherent planetary transits\n",
    "- The FALSE POSITIVE flags seem to be related to tests for these conditions\n",
    "- The CONFIRMED flags seem to be related to tests for ruling out these these conditions\n"
   ]
  }
 ],
 "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}