0_Keplar_Tabular_View.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Tabular View of KOI Dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The first step in Exploratory Data Analysis is to load the data, sanity check, preprocess, (validate dtypes, cleanup, fillna, add/map fields) and create a convenient datamodel.\n",
    "\n",
    "A tabular view of the raw dataset also provides a reference page when coding more advanced queries and visualization\n",
    "\n",
    "- Column Defintions: https://exoplanetarchive.ipac.caltech.edu/docs/API_kepcandidate_columns.html\n",
    "- Dataset preprocessing code is: [./src/dataset_koi.py](./src/dataset_koi.py)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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 re\n",
    "from pydash import py_ as _\n",
    "from src.dataset_koi import koi, koi_columns, koi_column_types\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": [
    "## Whole Dataset "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "NOTE: The `kepoi_star` column has been dynamically added by preprocessing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>rowid</th>\n",
       "      <th>kepid</th>\n",
       "      <th>kepoi_name</th>\n",
       "      <th>kepoi_star</th>\n",
       "      <th>kepler_name</th>\n",
       "      <th>koi_disposition</th>\n",
       "      <th>koi_vet_stat</th>\n",
       "      <th>koi_vet_date</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_disp_prov</th>\n",
       "      <th>koi_comment</th>\n",
       "      <th>koi_period</th>\n",
       "      <th>koi_time0bk</th>\n",
       "      <th>koi_time0</th>\n",
       "      <th>koi_eccen</th>\n",
       "      <th>koi_longp</th>\n",
       "      <th>koi_impact</th>\n",
       "      <th>koi_duration</th>\n",
       "      <th>koi_ingress</th>\n",
       "      <th>koi_depth</th>\n",
       "      <th>koi_ror</th>\n",
       "      <th>koi_srho</th>\n",
       "      <th>koi_fittype</th>\n",
       "      <th>koi_prad</th>\n",
       "      <th>koi_sma</th>\n",
       "      <th>koi_incl</th>\n",
       "      <th>koi_teq</th>\n",
       "      <th>koi_insol</th>\n",
       "      <th>koi_dor</th>\n",
       "      <th>koi_limbdark_mod</th>\n",
       "      <th>koi_ldm_coeff4</th>\n",
       "      <th>koi_ldm_coeff3</th>\n",
       "      <th>koi_ldm_coeff2</th>\n",
       "      <th>koi_ldm_coeff1</th>\n",
       "      <th>koi_parm_prov</th>\n",
       "      <th>koi_max_sngle_ev</th>\n",
       "      <th>koi_max_mult_ev</th>\n",
       "      <th>koi_model_snr</th>\n",
       "      <th>koi_count</th>\n",
       "      <th>koi_num_transits</th>\n",
       "      <th>koi_tce_plnt_num</th>\n",
       "      <th>koi_tce_delivname</th>\n",
       "      <th>koi_quarters</th>\n",
       "      <th>koi_bin_oedp_sig</th>\n",
       "      <th>koi_trans_mod</th>\n",
       "      <th>koi_model_dof</th>\n",
       "      <th>koi_model_chisq</th>\n",
       "      <th>koi_datalink_dvr</th>\n",
       "      <th>koi_datalink_dvs</th>\n",
       "      <th>koi_steff</th>\n",
       "      <th>koi_slogg</th>\n",
       "      <th>koi_smet</th>\n",
       "      <th>koi_srad</th>\n",
       "      <th>koi_smass</th>\n",
       "      <th>koi_sage</th>\n",
       "      <th>koi_sparprov</th>\n",
       "      <th>ra</th>\n",
       "      <th>dec</th>\n",
       "      <th>koi_kepmag</th>\n",
       "      <th>koi_gmag</th>\n",
       "      <th>koi_rmag</th>\n",
       "      <th>koi_imag</th>\n",
       "      <th>koi_zmag</th>\n",
       "      <th>koi_jmag</th>\n",
       "      <th>koi_hmag</th>\n",
       "      <th>koi_kmag</th>\n",
       "      <th>koi_fwm_stat_sig</th>\n",
       "      <th>koi_fwm_sra</th>\n",
       "      <th>koi_fwm_sdec</th>\n",
       "      <th>koi_fwm_srao</th>\n",
       "      <th>koi_fwm_sdeco</th>\n",
       "      <th>koi_fwm_prao</th>\n",
       "      <th>koi_fwm_pdeco</th>\n",
       "      <th>koi_dicco_mra</th>\n",
       "      <th>koi_dicco_mdec</th>\n",
       "      <th>koi_dicco_msky</th>\n",
       "      <th>koi_dikco_mra</th>\n",
       "      <th>koi_dikco_mdec</th>\n",
       "      <th>koi_dikco_msky</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</td>\n",
       "      <td>1</td>\n",
       "      <td>10797460</td>\n",
       "      <td>K00752.01</td>\n",
       "      <td>K00752</td>\n",
       "      <td>Kepler-227 b</td>\n",
       "      <td>CONFIRMED</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>NO_COMMENT</td>\n",
       "      <td>9.488036</td>\n",
       "      <td>170.538750</td>\n",
       "      <td>2455003.539</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.146</td>\n",
       "      <td>2.95750</td>\n",
       "      <td>NaN</td>\n",
       "      <td>615.8</td>\n",
       "      <td>0.022344</td>\n",
       "      <td>3.20796</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>2.26</td>\n",
       "      <td>0.0853</td>\n",
       "      <td>89.66</td>\n",
       "      <td>793.0</td>\n",
       "      <td>93.59</td>\n",
       "      <td>24.810</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2291</td>\n",
       "      <td>0.4603</td>\n",
       "      <td>koi</td>\n",
       "      <td>5.135849</td>\n",
       "      <td>28.470820</td>\n",
       "      <td>35.8</td>\n",
       "      <td>2</td>\n",
       "      <td>142.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "      <td>0.6864</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010797/010797460/dv/kplr010797460-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010797/010797460/dv/kplr010797460-001-20160209194854_dvs.pdf</td>\n",
       "      <td>5455.0</td>\n",
       "      <td>4.467</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.927</td>\n",
       "      <td>0.919</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>291.93423</td>\n",
       "      <td>48.141651</td>\n",
       "      <td>15.347</td>\n",
       "      <td>15.890</td>\n",
       "      <td>15.270</td>\n",
       "      <td>15.114</td>\n",
       "      <td>15.006</td>\n",
       "      <td>14.082</td>\n",
       "      <td>13.751</td>\n",
       "      <td>13.648</td>\n",
       "      <td>0.002</td>\n",
       "      <td>19.462294</td>\n",
       "      <td>48.141910</td>\n",
       "      <td>0.430</td>\n",
       "      <td>0.940</td>\n",
       "      <td>-0.000200</td>\n",
       "      <td>-0.000550</td>\n",
       "      <td>-0.010</td>\n",
       "      <td>0.200</td>\n",
       "      <td>0.200</td>\n",
       "      <td>0.080</td>\n",
       "      <td>0.310</td>\n",
       "      <td>0.320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>2</td>\n",
       "      <td>10797460</td>\n",
       "      <td>K00752.02</td>\n",
       "      <td>K00752</td>\n",
       "      <td>Kepler-227 c</td>\n",
       "      <td>CONFIRMED</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>NO_COMMENT</td>\n",
       "      <td>54.418383</td>\n",
       "      <td>162.513840</td>\n",
       "      <td>2454995.514</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.586</td>\n",
       "      <td>4.50700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>874.8</td>\n",
       "      <td>0.027954</td>\n",
       "      <td>3.02368</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>2.83</td>\n",
       "      <td>0.2734</td>\n",
       "      <td>89.57</td>\n",
       "      <td>443.0</td>\n",
       "      <td>9.11</td>\n",
       "      <td>77.900</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2291</td>\n",
       "      <td>0.4603</td>\n",
       "      <td>koi</td>\n",
       "      <td>7.027669</td>\n",
       "      <td>20.109507</td>\n",
       "      <td>25.8</td>\n",
       "      <td>2</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "      <td>0.0023</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010797/010797460/dv/kplr010797460-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010797/010797460/dv/kplr010797460-002-20160209194854_dvs.pdf</td>\n",
       "      <td>5455.0</td>\n",
       "      <td>4.467</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.927</td>\n",
       "      <td>0.919</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>291.93423</td>\n",
       "      <td>48.141651</td>\n",
       "      <td>15.347</td>\n",
       "      <td>15.890</td>\n",
       "      <td>15.270</td>\n",
       "      <td>15.114</td>\n",
       "      <td>15.006</td>\n",
       "      <td>14.082</td>\n",
       "      <td>13.751</td>\n",
       "      <td>13.648</td>\n",
       "      <td>0.003</td>\n",
       "      <td>19.462265</td>\n",
       "      <td>48.141990</td>\n",
       "      <td>-0.630</td>\n",
       "      <td>1.230</td>\n",
       "      <td>0.000660</td>\n",
       "      <td>-0.001050</td>\n",
       "      <td>0.390</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.390</td>\n",
       "      <td>0.490</td>\n",
       "      <td>0.120</td>\n",
       "      <td>0.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>3</td>\n",
       "      <td>10811496</td>\n",
       "      <td>K00753.01</td>\n",
       "      <td>K00753</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>DEEP_V_SHAPED</td>\n",
       "      <td>19.899140</td>\n",
       "      <td>175.850252</td>\n",
       "      <td>2455008.850</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.969</td>\n",
       "      <td>1.78220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10829.0</td>\n",
       "      <td>0.154046</td>\n",
       "      <td>7.29555</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>14.60</td>\n",
       "      <td>0.1419</td>\n",
       "      <td>88.96</td>\n",
       "      <td>638.0</td>\n",
       "      <td>39.30</td>\n",
       "      <td>53.500</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2711</td>\n",
       "      <td>0.3858</td>\n",
       "      <td>koi</td>\n",
       "      <td>37.159767</td>\n",
       "      <td>187.449100</td>\n",
       "      <td>76.3</td>\n",
       "      <td>1</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111101110111011000000000000000</td>\n",
       "      <td>0.6624</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010811/010811496/dv/kplr010811496-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010811/010811496/dv/kplr010811496-001-20160209194854_dvs.pdf</td>\n",
       "      <td>5853.0</td>\n",
       "      <td>4.544</td>\n",
       "      <td>-0.18</td>\n",
       "      <td>0.868</td>\n",
       "      <td>0.961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>297.00482</td>\n",
       "      <td>48.134129</td>\n",
       "      <td>15.436</td>\n",
       "      <td>15.943</td>\n",
       "      <td>15.390</td>\n",
       "      <td>15.220</td>\n",
       "      <td>15.166</td>\n",
       "      <td>14.254</td>\n",
       "      <td>13.900</td>\n",
       "      <td>13.826</td>\n",
       "      <td>0.278</td>\n",
       "      <td>19.800321</td>\n",
       "      <td>48.134120</td>\n",
       "      <td>-0.021</td>\n",
       "      <td>-0.038</td>\n",
       "      <td>0.000700</td>\n",
       "      <td>0.000600</td>\n",
       "      <td>-0.025</td>\n",
       "      <td>-0.034</td>\n",
       "      <td>0.042</td>\n",
       "      <td>0.002</td>\n",
       "      <td>-0.027</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>4</td>\n",
       "      <td>10848459</td>\n",
       "      <td>K00754.01</td>\n",
       "      <td>K00754</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>MOD_ODDEVEN_DV---MOD_ODDEVEN_ALT---DEEP_V_SHAPED</td>\n",
       "      <td>1.736952</td>\n",
       "      <td>170.307565</td>\n",
       "      <td>2455003.308</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.276</td>\n",
       "      <td>2.40641</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8079.2</td>\n",
       "      <td>0.387394</td>\n",
       "      <td>0.22080</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>33.46</td>\n",
       "      <td>0.0267</td>\n",
       "      <td>67.09</td>\n",
       "      <td>1395.0</td>\n",
       "      <td>891.96</td>\n",
       "      <td>3.278</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2865</td>\n",
       "      <td>0.3556</td>\n",
       "      <td>koi</td>\n",
       "      <td>39.066550</td>\n",
       "      <td>541.895100</td>\n",
       "      <td>505.6</td>\n",
       "      <td>1</td>\n",
       "      <td>621.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111110111011101000000000000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010848/010848459/dv/kplr010848459-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010848/010848459/dv/kplr010848459-001-20160209194854_dvs.pdf</td>\n",
       "      <td>5805.0</td>\n",
       "      <td>4.564</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>0.791</td>\n",
       "      <td>0.836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>285.53461</td>\n",
       "      <td>48.285210</td>\n",
       "      <td>15.597</td>\n",
       "      <td>16.100</td>\n",
       "      <td>15.554</td>\n",
       "      <td>15.382</td>\n",
       "      <td>15.266</td>\n",
       "      <td>14.326</td>\n",
       "      <td>13.911</td>\n",
       "      <td>13.809</td>\n",
       "      <td>0.000</td>\n",
       "      <td>19.035638</td>\n",
       "      <td>48.285210</td>\n",
       "      <td>-0.111</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.003020</td>\n",
       "      <td>-0.001420</td>\n",
       "      <td>-0.249</td>\n",
       "      <td>0.147</td>\n",
       "      <td>0.289</td>\n",
       "      <td>-0.257</td>\n",
       "      <td>0.099</td>\n",
       "      <td>0.276</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</td>\n",
       "      <td>9561</td>\n",
       "      <td>10128825</td>\n",
       "      <td>K07986.01</td>\n",
       "      <td>K07986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>NO_COMMENT</td>\n",
       "      <td>1.739849</td>\n",
       "      <td>133.001270</td>\n",
       "      <td>2454966.001</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.043</td>\n",
       "      <td>3.11400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.5</td>\n",
       "      <td>0.006379</td>\n",
       "      <td>0.50770</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0.0290</td>\n",
       "      <td>89.42</td>\n",
       "      <td>1608.0</td>\n",
       "      <td>1585.81</td>\n",
       "      <td>4.331</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2868</td>\n",
       "      <td>0.3588</td>\n",
       "      <td>koi</td>\n",
       "      <td>3.841146</td>\n",
       "      <td>8.569540</td>\n",
       "      <td>10.6</td>\n",
       "      <td>1</td>\n",
       "      <td>766.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "      <td>0.1374</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010128/010128825/dv/kplr010128825-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010128/010128825/dv/kplr010128825-001-20160209194854_dvs.pdf</td>\n",
       "      <td>6119.0</td>\n",
       "      <td>4.444</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>1.031</td>\n",
       "      <td>1.075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>286.50937</td>\n",
       "      <td>47.163219</td>\n",
       "      <td>14.757</td>\n",
       "      <td>15.189</td>\n",
       "      <td>14.687</td>\n",
       "      <td>14.571</td>\n",
       "      <td>14.484</td>\n",
       "      <td>13.641</td>\n",
       "      <td>13.339</td>\n",
       "      <td>13.261</td>\n",
       "      <td>0.089</td>\n",
       "      <td>19.100625</td>\n",
       "      <td>47.163770</td>\n",
       "      <td>0.100</td>\n",
       "      <td>2.000</td>\n",
       "      <td>-0.000018</td>\n",
       "      <td>-0.000074</td>\n",
       "      <td>0.740</td>\n",
       "      <td>-0.250</td>\n",
       "      <td>0.780</td>\n",
       "      <td>0.500</td>\n",
       "      <td>-0.180</td>\n",
       "      <td>0.530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>9562</td>\n",
       "      <td>10147276</td>\n",
       "      <td>K07987.01</td>\n",
       "      <td>K07987</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>CENT_RESOLVED_OFFSET</td>\n",
       "      <td>0.681402</td>\n",
       "      <td>132.181750</td>\n",
       "      <td>2454965.182</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.147</td>\n",
       "      <td>0.86500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103.6</td>\n",
       "      <td>0.009444</td>\n",
       "      <td>8.97692</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>1.07</td>\n",
       "      <td>0.0157</td>\n",
       "      <td>88.60</td>\n",
       "      <td>2218.0</td>\n",
       "      <td>5713.41</td>\n",
       "      <td>6.040</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3029</td>\n",
       "      <td>0.3239</td>\n",
       "      <td>koi</td>\n",
       "      <td>3.748643</td>\n",
       "      <td>9.653322</td>\n",
       "      <td>12.3</td>\n",
       "      <td>1</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "      <td>0.9995</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010147/010147276/dv/kplr010147276-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010147/010147276/dv/kplr010147276-001-20160209194854_dvs.pdf</td>\n",
       "      <td>6173.0</td>\n",
       "      <td>4.447</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>1.041</td>\n",
       "      <td>1.104</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>294.16489</td>\n",
       "      <td>47.176281</td>\n",
       "      <td>15.385</td>\n",
       "      <td>15.853</td>\n",
       "      <td>15.347</td>\n",
       "      <td>15.185</td>\n",
       "      <td>15.158</td>\n",
       "      <td>14.220</td>\n",
       "      <td>13.913</td>\n",
       "      <td>13.844</td>\n",
       "      <td>0.000</td>\n",
       "      <td>19.611187</td>\n",
       "      <td>47.174720</td>\n",
       "      <td>7.200</td>\n",
       "      <td>-5.600</td>\n",
       "      <td>-0.000720</td>\n",
       "      <td>0.000500</td>\n",
       "      <td>3.410</td>\n",
       "      <td>-3.650</td>\n",
       "      <td>5.000</td>\n",
       "      <td>3.380</td>\n",
       "      <td>-3.890</td>\n",
       "      <td>5.160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>9563</td>\n",
       "      <td>10155286</td>\n",
       "      <td>K07988.01</td>\n",
       "      <td>K07988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>ALL_TRANS_CHASES---CENT_SATURATED</td>\n",
       "      <td>333.486169</td>\n",
       "      <td>153.615010</td>\n",
       "      <td>2454986.615</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.214</td>\n",
       "      <td>3.19900</td>\n",
       "      <td>NaN</td>\n",
       "      <td>639.1</td>\n",
       "      <td>0.022590</td>\n",
       "      <td>85.88623</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>19.30</td>\n",
       "      <td>1.2233</td>\n",
       "      <td>89.98</td>\n",
       "      <td>557.0</td>\n",
       "      <td>22.68</td>\n",
       "      <td>796.000</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1697</td>\n",
       "      <td>0.5559</td>\n",
       "      <td>koi</td>\n",
       "      <td>5.252939</td>\n",
       "      <td>7.240365</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111101110111011000000000000000</td>\n",
       "      <td>0.6961</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010155/010155286/dv/kplr010155286-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010155/010155286/dv/kplr010155286-001-20160209194854_dvs.pdf</td>\n",
       "      <td>4989.0</td>\n",
       "      <td>2.992</td>\n",
       "      <td>0.07</td>\n",
       "      <td>7.824</td>\n",
       "      <td>2.190</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>296.76288</td>\n",
       "      <td>47.145142</td>\n",
       "      <td>10.998</td>\n",
       "      <td>11.733</td>\n",
       "      <td>10.880</td>\n",
       "      <td>10.682</td>\n",
       "      <td>10.578</td>\n",
       "      <td>9.501</td>\n",
       "      <td>9.027</td>\n",
       "      <td>8.921</td>\n",
       "      <td>0.052</td>\n",
       "      <td>19.784200</td>\n",
       "      <td>47.145142</td>\n",
       "      <td>0.310</td>\n",
       "      <td>0.010</td>\n",
       "      <td>-0.000290</td>\n",
       "      <td>-0.000100</td>\n",
       "      <td>1.061</td>\n",
       "      <td>1.320</td>\n",
       "      <td>1.690</td>\n",
       "      <td>1.450</td>\n",
       "      <td>1.370</td>\n",
       "      <td>2.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>9564</td>\n",
       "      <td>10156110</td>\n",
       "      <td>K07989.01</td>\n",
       "      <td>K07989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>Done</td>\n",
       "      <td>2018-08-16</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>sup_koi</td>\n",
       "      <td>CENT_RESOLVED_OFFSET---HALO_GHOST---EPHEM_MATCH</td>\n",
       "      <td>4.856035</td>\n",
       "      <td>135.993300</td>\n",
       "      <td>2454968.993</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.134</td>\n",
       "      <td>3.07800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.7</td>\n",
       "      <td>0.008076</td>\n",
       "      <td>1.40645</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>1.05</td>\n",
       "      <td>0.0606</td>\n",
       "      <td>89.36</td>\n",
       "      <td>1266.0</td>\n",
       "      <td>607.42</td>\n",
       "      <td>12.060</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3138</td>\n",
       "      <td>0.2998</td>\n",
       "      <td>koi</td>\n",
       "      <td>3.253128</td>\n",
       "      <td>7.167940</td>\n",
       "      <td>8.2</td>\n",
       "      <td>1</td>\n",
       "      <td>218.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111101110111011000000000000000</td>\n",
       "      <td>0.1174</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>010/010156/010156110/dv/kplr010156110-20160209194854_dvr.pdf</td>\n",
       "      <td>010/010156/010156110/dv/kplr010156110-001-20160209194854_dvs.pdf</td>\n",
       "      <td>6469.0</td>\n",
       "      <td>4.385</td>\n",
       "      <td>0.07</td>\n",
       "      <td>1.193</td>\n",
       "      <td>1.260</td>\n",
       "      <td>NaN</td>\n",
       "      <td>stellar</td>\n",
       "      <td>297.00977</td>\n",
       "      <td>47.121021</td>\n",
       "      <td>14.826</td>\n",
       "      <td>15.210</td>\n",
       "      <td>14.781</td>\n",
       "      <td>14.662</td>\n",
       "      <td>14.647</td>\n",
       "      <td>13.830</td>\n",
       "      <td>13.522</td>\n",
       "      <td>13.512</td>\n",
       "      <td>0.000</td>\n",
       "      <td>19.800732</td>\n",
       "      <td>47.123490</td>\n",
       "      <td>2.900</td>\n",
       "      <td>8.900</td>\n",
       "      <td>-0.000230</td>\n",
       "      <td>-0.000700</td>\n",
       "      <td>1.020</td>\n",
       "      <td>3.300</td>\n",
       "      <td>3.400</td>\n",
       "      <td>0.960</td>\n",
       "      <td>3.400</td>\n",
       "      <td>3.500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 84 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            rowid     kepid kepoi_name kepoi_star   kepler_name koi_disposition koi_vet_stat koi_vet_date koi_pdisposition  koi_score  koi_fpflag_nt koi_fpflag_ss koi_fpflag_co koi_fpflag_ec koi_disp_prov                                       koi_comment  koi_period  koi_time0bk    koi_time0  koi_eccen  koi_longp  koi_impact  koi_duration  koi_ingress  koi_depth   koi_ror  koi_srho koi_fittype  koi_prad  koi_sma  koi_incl  koi_teq  koi_insol  koi_dor                   koi_limbdark_mod  koi_ldm_coeff4  koi_ldm_coeff3  koi_ldm_coeff2  koi_ldm_coeff1 koi_parm_prov  koi_max_sngle_ev  koi_max_mult_ev  koi_model_snr  koi_count  koi_num_transits  koi_tce_plnt_num koi_tce_delivname                      koi_quarters  koi_bin_oedp_sig                       koi_trans_mod  koi_model_dof  koi_model_chisq                                              koi_datalink_dvr                                                  koi_datalink_dvs  koi_steff  koi_slogg  koi_smet  koi_srad  koi_smass  koi_sage koi_sparprov         ra        dec  koi_kepmag  koi_gmag  koi_rmag  koi_imag  koi_zmag  koi_jmag  koi_hmag  koi_kmag  koi_fwm_stat_sig  koi_fwm_sra  koi_fwm_sdec  koi_fwm_srao  koi_fwm_sdeco  koi_fwm_prao  koi_fwm_pdeco  koi_dicco_mra  koi_dicco_mdec  koi_dicco_msky  koi_dikco_mra  koi_dikco_mdec  koi_dikco_msky\n",
       "kepoi_name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 \n",
       "K00752.01   1      10797460  K00752.01  K00752     Kepler-227 b  CONFIRMED       Done        2018-08-16    CANDIDATE        1.000      0              0             0             0             sup_koi       NO_COMMENT                                        9.488036    170.538750   2455003.539  0.0       NaN         0.146       2.95750      NaN           615.8      0.022344  3.20796   LS+MCMC     2.26      0.0853   89.66     793.0    93.59      24.810   Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.2291          0.4603          koi           5.135849          28.470820        35.8           2          142.0             1.0               tce               11111111111111111000000000000000  0.6864            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010797/010797460/dv/kplr010797460-20160209194854_dvr.pdf  010/010797/010797460/dv/kplr010797460-001-20160209194854_dvs.pdf  5455.0     4.467      0.14      0.927     0.919     NaN        stellar      291.93423  48.141651  15.347      15.890    15.270    15.114    15.006    14.082    13.751    13.648    0.002             19.462294    48.141910     0.430         0.940         -0.000200     -0.000550      -0.010          0.200           0.200           0.080          0.310           0.320         \n",
       "K00752.02   2      10797460  K00752.02  K00752     Kepler-227 c  CONFIRMED       Done        2018-08-16    CANDIDATE        0.969      0              0             0             0             sup_koi       NO_COMMENT                                        54.418383   162.513840   2454995.514  0.0       NaN         0.586       4.50700      NaN           874.8      0.027954  3.02368   LS+MCMC     2.83      0.2734   89.57     443.0    9.11       77.900   Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.2291          0.4603          koi           7.027669          20.109507        25.8           2          25.0              2.0               tce               11111111111111111000000000000000  0.0023            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010797/010797460/dv/kplr010797460-20160209194854_dvr.pdf  010/010797/010797460/dv/kplr010797460-002-20160209194854_dvs.pdf  5455.0     4.467      0.14      0.927     0.919     NaN        stellar      291.93423  48.141651  15.347      15.890    15.270    15.114    15.006    14.082    13.751    13.648    0.003             19.462265    48.141990    -0.630         1.230          0.000660     -0.001050       0.390          0.000           0.390           0.490          0.120           0.500         \n",
       "K00753.01   3      10811496  K00753.01  K00753     NaN           CANDIDATE       Done        2018-08-16    CANDIDATE        0.000      0              0             0             0             sup_koi       DEEP_V_SHAPED                                     19.899140   175.850252   2455008.850  0.0       NaN         0.969       1.78220      NaN           10829.0    0.154046  7.29555   LS+MCMC     14.60     0.1419   88.96     638.0    39.30      53.500   Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.2711          0.3858          koi           37.159767         187.449100       76.3           1          56.0              1.0               tce               11111101110111011000000000000000  0.6624            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010811/010811496/dv/kplr010811496-20160209194854_dvr.pdf  010/010811/010811496/dv/kplr010811496-001-20160209194854_dvs.pdf  5853.0     4.544     -0.18      0.868     0.961     NaN        stellar      297.00482  48.134129  15.436      15.943    15.390    15.220    15.166    14.254    13.900    13.826    0.278             19.800321    48.134120    -0.021        -0.038          0.000700      0.000600      -0.025         -0.034           0.042           0.002         -0.027           0.027         \n",
       "K00754.01   4      10848459  K00754.01  K00754     NaN           FALSE POSITIVE  Done        2018-08-16    FALSE POSITIVE   0.000      0              1             0             0             sup_koi       MOD_ODDEVEN_DV---MOD_ODDEVEN_ALT---DEEP_V_SHAPED  1.736952    170.307565   2455003.308  0.0       NaN         1.276       2.40641      NaN           8079.2     0.387394  0.22080   LS+MCMC     33.46     0.0267   67.09     1395.0   891.96     3.278    Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.2865          0.3556          koi           39.066550         541.895100       505.6          1          621.0             1.0               tce               11111110111011101000000000000000  0.0000            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010848/010848459/dv/kplr010848459-20160209194854_dvr.pdf  010/010848/010848459/dv/kplr010848459-001-20160209194854_dvs.pdf  5805.0     4.564     -0.52      0.791     0.836     NaN        stellar      285.53461  48.285210  15.597      16.100    15.554    15.382    15.266    14.326    13.911    13.809    0.000             19.035638    48.285210    -0.111         0.002          0.003020     -0.001420      -0.249          0.147           0.289          -0.257          0.099           0.276         \n",
       "...        ..           ...        ...     ...     ...                 ...        ...               ...          ...          ...     ..             ..            ..            ..                 ...                 ...                                           ...          ...           ...  ...        ..           ...           ...       ..               ...         ...      ...       ...       ...        ...     ...       ...      ...         ...                                 ...  ...             ...                ...             ...          ...                 ...                ...        ...          ..           ...              ...               ...                                            ...     ...                                           ...  ..             ..                                                                        ...                                                               ...     ...       ...       ...        ...       ...      ..            ...            ...        ...     ...         ...       ...       ...       ...       ...       ...       ...      ...                   ...          ...       ...           ...               ...           ...         ...            ...             ...             ...            ...             ...         \n",
       "K07986.01   9561   10128825  K07986.01  K07986     NaN           CANDIDATE       Done        2018-08-16    CANDIDATE        0.497      0              0             0             0             sup_koi       NO_COMMENT                                        1.739849    133.001270   2454966.001  0.0       NaN         0.043       3.11400      NaN           48.5       0.006379  0.50770   LS+MCMC     0.72      0.0290   89.42     1608.0   1585.81    4.331    Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.2868          0.3588          koi           3.841146          8.569540         10.6           1          766.0             1.0               tce               11111111111111111000000000000000  0.1374            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010128/010128825/dv/kplr010128825-20160209194854_dvr.pdf  010/010128/010128825/dv/kplr010128825-001-20160209194854_dvs.pdf  6119.0     4.444     -0.04      1.031     1.075     NaN        stellar      286.50937  47.163219  14.757      15.189    14.687    14.571    14.484    13.641    13.339    13.261    0.089             19.100625    47.163770     0.100         2.000         -0.000018     -0.000074       0.740         -0.250           0.780           0.500         -0.180           0.530         \n",
       "K07987.01   9562   10147276  K07987.01  K07987     NaN           FALSE POSITIVE  Done        2018-08-16    FALSE POSITIVE   0.021      0              0             1             0             sup_koi       CENT_RESOLVED_OFFSET                              0.681402    132.181750   2454965.182  0.0       NaN         0.147       0.86500      NaN           103.6      0.009444  8.97692   LS+MCMC     1.07      0.0157   88.60     2218.0   5713.41    6.040    Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.3029          0.3239          koi           3.748643          9.653322         12.3           1          1969.0            1.0               tce               11111111111111111000000000000000  0.9995            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010147/010147276/dv/kplr010147276-20160209194854_dvr.pdf  010/010147/010147276/dv/kplr010147276-001-20160209194854_dvs.pdf  6173.0     4.447     -0.04      1.041     1.104     NaN        stellar      294.16489  47.176281  15.385      15.853    15.347    15.185    15.158    14.220    13.913    13.844    0.000             19.611187    47.174720     7.200        -5.600         -0.000720      0.000500       3.410         -3.650           5.000           3.380         -3.890           5.160         \n",
       "K07988.01   9563   10155286  K07988.01  K07988     NaN           CANDIDATE       Done        2018-08-16    CANDIDATE        0.092      0              0             0             0             sup_koi       ALL_TRANS_CHASES---CENT_SATURATED                 333.486169  153.615010   2454986.615  0.0       NaN         0.214       3.19900      NaN           639.1      0.022590  85.88623  LS+MCMC     19.30     1.2233   89.98     557.0    22.68      796.000  Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.1697          0.5559          koi           5.252939          7.240365         14.0           1          3.0               1.0               tce               11111101110111011000000000000000  0.6961            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010155/010155286/dv/kplr010155286-20160209194854_dvr.pdf  010/010155/010155286/dv/kplr010155286-001-20160209194854_dvs.pdf  4989.0     2.992      0.07      7.824     2.190     NaN        stellar      296.76288  47.145142  10.998      11.733    10.880    10.682    10.578    9.501     9.027     8.921     0.052             19.784200    47.145142     0.310         0.010         -0.000290     -0.000100       1.061          1.320           1.690           1.450          1.370           2.000         \n",
       "K07989.01   9564   10156110  K07989.01  K07989     NaN           FALSE POSITIVE  Done        2018-08-16    FALSE POSITIVE   0.000      0              0             1             1             sup_koi       CENT_RESOLVED_OFFSET---HALO_GHOST---EPHEM_MATCH   4.856035    135.993300   2454968.993  0.0       NaN         0.134       3.07800      NaN           76.7       0.008076  1.40645   LS+MCMC     1.05      0.0606   89.36     1266.0   607.42     12.060   Claret (2011 A&A 529 75) ATLAS LS  0.0             0.0             0.3138          0.2998          koi           3.253128          7.167940         8.2            1          218.0             1.0               tce               11111101110111011000000000000000  0.1174            Mandel and Agol (2002 ApJ 580 171) NaN            NaN               010/010156/010156110/dv/kplr010156110-20160209194854_dvr.pdf  010/010156/010156110/dv/kplr010156110-001-20160209194854_dvs.pdf  6469.0     4.385      0.07      1.193     1.260     NaN        stellar      297.00977  47.121021  14.826      15.210    14.781    14.662    14.647    13.830    13.522    13.512    0.000             19.800732    47.123490     2.900         8.900         -0.000230     -0.000700       1.020          3.300           3.400           0.960          3.400           3.500         \n",
       "\n",
       "[9564 rows x 84 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['all']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>rowid</th>\n",
       "      <th>kepid</th>\n",
       "      <th>koi_score</th>\n",
       "      <th>koi_fpflag_nt</th>\n",
       "      <th>koi_period</th>\n",
       "      <th>koi_time0bk</th>\n",
       "      <th>koi_time0</th>\n",
       "      <th>koi_eccen</th>\n",
       "      <th>koi_longp</th>\n",
       "      <th>koi_impact</th>\n",
       "      <th>koi_duration</th>\n",
       "      <th>koi_ingress</th>\n",
       "      <th>koi_depth</th>\n",
       "      <th>koi_ror</th>\n",
       "      <th>koi_srho</th>\n",
       "      <th>koi_prad</th>\n",
       "      <th>koi_sma</th>\n",
       "      <th>koi_incl</th>\n",
       "      <th>koi_teq</th>\n",
       "      <th>koi_insol</th>\n",
       "      <th>koi_dor</th>\n",
       "      <th>koi_ldm_coeff4</th>\n",
       "      <th>koi_ldm_coeff3</th>\n",
       "      <th>koi_ldm_coeff2</th>\n",
       "      <th>koi_ldm_coeff1</th>\n",
       "      <th>koi_max_sngle_ev</th>\n",
       "      <th>koi_max_mult_ev</th>\n",
       "      <th>koi_model_snr</th>\n",
       "      <th>koi_count</th>\n",
       "      <th>koi_num_transits</th>\n",
       "      <th>koi_tce_plnt_num</th>\n",
       "      <th>koi_bin_oedp_sig</th>\n",
       "      <th>koi_model_dof</th>\n",
       "      <th>koi_model_chisq</th>\n",
       "      <th>koi_steff</th>\n",
       "      <th>koi_slogg</th>\n",
       "      <th>koi_smet</th>\n",
       "      <th>koi_srad</th>\n",
       "      <th>koi_smass</th>\n",
       "      <th>koi_sage</th>\n",
       "      <th>ra</th>\n",
       "      <th>dec</th>\n",
       "      <th>koi_kepmag</th>\n",
       "      <th>koi_gmag</th>\n",
       "      <th>koi_rmag</th>\n",
       "      <th>koi_imag</th>\n",
       "      <th>koi_zmag</th>\n",
       "      <th>koi_jmag</th>\n",
       "      <th>koi_hmag</th>\n",
       "      <th>koi_kmag</th>\n",
       "      <th>koi_fwm_stat_sig</th>\n",
       "      <th>koi_fwm_sra</th>\n",
       "      <th>koi_fwm_sdec</th>\n",
       "      <th>koi_fwm_srao</th>\n",
       "      <th>koi_fwm_sdeco</th>\n",
       "      <th>koi_fwm_prao</th>\n",
       "      <th>koi_fwm_pdeco</th>\n",
       "      <th>koi_dicco_mra</th>\n",
       "      <th>koi_dicco_mdec</th>\n",
       "      <th>koi_dicco_msky</th>\n",
       "      <th>koi_dikco_mra</th>\n",
       "      <th>koi_dikco_mdec</th>\n",
       "      <th>koi_dikco_msky</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9.564000e+03</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9.564000e+03</td>\n",
       "      <td>9201.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.201000e+03</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9243.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9200.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9.243000e+03</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.0</td>\n",
       "      <td>9201.0</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>8422.000000</td>\n",
       "      <td>8422.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>8422.000000</td>\n",
       "      <td>9218.000000</td>\n",
       "      <td>8054.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9178.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9563.000000</td>\n",
       "      <td>9523.000000</td>\n",
       "      <td>9555.000000</td>\n",
       "      <td>9410.000000</td>\n",
       "      <td>8951.000000</td>\n",
       "      <td>9539.000000</td>\n",
       "      <td>9539.000000</td>\n",
       "      <td>9539.00000</td>\n",
       "      <td>8488.000000</td>\n",
       "      <td>9058.000000</td>\n",
       "      <td>9058.000000</td>\n",
       "      <td>9109.000000</td>\n",
       "      <td>9109.000000</td>\n",
       "      <td>8734.000000</td>\n",
       "      <td>8747.000000</td>\n",
       "      <td>8965.000000</td>\n",
       "      <td>8965.000000</td>\n",
       "      <td>8965.000000</td>\n",
       "      <td>8994.000000</td>\n",
       "      <td>8994.000000</td>\n",
       "      <td>8994.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>4782.500000</td>\n",
       "      <td>7.690628e+06</td>\n",
       "      <td>0.404914</td>\n",
       "      <td>0.160079</td>\n",
       "      <td>75.671358</td>\n",
       "      <td>166.183251</td>\n",
       "      <td>2.454999e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.735105</td>\n",
       "      <td>5.621606</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.379134e+04</td>\n",
       "      <td>0.283646</td>\n",
       "      <td>9.164414</td>\n",
       "      <td>102.891778</td>\n",
       "      <td>0.223989</td>\n",
       "      <td>82.469147</td>\n",
       "      <td>1085.385828</td>\n",
       "      <td>7.745737e+03</td>\n",
       "      <td>76.736333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.254439</td>\n",
       "      <td>0.407617</td>\n",
       "      <td>176.846052</td>\n",
       "      <td>1025.664672</td>\n",
       "      <td>259.895001</td>\n",
       "      <td>1.406315</td>\n",
       "      <td>385.006768</td>\n",
       "      <td>1.243654</td>\n",
       "      <td>0.409500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5706.823280</td>\n",
       "      <td>4.310157</td>\n",
       "      <td>-0.124431</td>\n",
       "      <td>1.728712</td>\n",
       "      <td>1.023706</td>\n",
       "      <td>NaN</td>\n",
       "      <td>292.060163</td>\n",
       "      <td>43.810433</td>\n",
       "      <td>14.264606</td>\n",
       "      <td>14.830501</td>\n",
       "      <td>14.221565</td>\n",
       "      <td>14.075138</td>\n",
       "      <td>13.991724</td>\n",
       "      <td>12.993311</td>\n",
       "      <td>12.620604</td>\n",
       "      <td>12.54341</td>\n",
       "      <td>0.150994</td>\n",
       "      <td>19.471356</td>\n",
       "      <td>43.829239</td>\n",
       "      <td>-0.316136</td>\n",
       "      <td>-0.165817</td>\n",
       "      <td>-0.000097</td>\n",
       "      <td>-0.000714</td>\n",
       "      <td>-0.012281</td>\n",
       "      <td>-0.045420</td>\n",
       "      <td>1.866561</td>\n",
       "      <td>-0.024244</td>\n",
       "      <td>-0.076749</td>\n",
       "      <td>1.812566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>2761.033321</td>\n",
       "      <td>2.653459e+06</td>\n",
       "      <td>0.471473</td>\n",
       "      <td>0.366699</td>\n",
       "      <td>1334.744046</td>\n",
       "      <td>67.918960</td>\n",
       "      <td>6.791896e+01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.348832</td>\n",
       "      <td>6.471554</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.224268e+04</td>\n",
       "      <td>3.306558</td>\n",
       "      <td>53.807967</td>\n",
       "      <td>3077.639126</td>\n",
       "      <td>0.566359</td>\n",
       "      <td>15.223627</td>\n",
       "      <td>856.351161</td>\n",
       "      <td>1.592047e+05</td>\n",
       "      <td>845.274598</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.064806</td>\n",
       "      <td>0.106076</td>\n",
       "      <td>770.902357</td>\n",
       "      <td>4154.121620</td>\n",
       "      <td>795.806615</td>\n",
       "      <td>0.873289</td>\n",
       "      <td>545.756200</td>\n",
       "      <td>0.664573</td>\n",
       "      <td>0.500793</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>796.857947</td>\n",
       "      <td>0.432606</td>\n",
       "      <td>0.282111</td>\n",
       "      <td>6.127185</td>\n",
       "      <td>0.349447</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.766657</td>\n",
       "      <td>3.601243</td>\n",
       "      <td>1.385448</td>\n",
       "      <td>1.501885</td>\n",
       "      <td>1.383713</td>\n",
       "      <td>1.292573</td>\n",
       "      <td>1.230351</td>\n",
       "      <td>1.291912</td>\n",
       "      <td>1.267215</td>\n",
       "      <td>1.26818</td>\n",
       "      <td>0.252648</td>\n",
       "      <td>0.319158</td>\n",
       "      <td>3.599553</td>\n",
       "      <td>20.254777</td>\n",
       "      <td>20.534655</td>\n",
       "      <td>0.058224</td>\n",
       "      <td>0.092986</td>\n",
       "      <td>2.406550</td>\n",
       "      <td>2.573558</td>\n",
       "      <td>2.988742</td>\n",
       "      <td>2.382286</td>\n",
       "      <td>2.553758</td>\n",
       "      <td>2.986376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7.574500e+05</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.241843</td>\n",
       "      <td>120.515914</td>\n",
       "      <td>2.454954e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.052000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.001289</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.080000</td>\n",
       "      <td>0.005900</td>\n",
       "      <td>2.290000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.373000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.120600</td>\n",
       "      <td>0.125400</td>\n",
       "      <td>2.417437</td>\n",
       "      <td>7.105086</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2661.000000</td>\n",
       "      <td>0.047000</td>\n",
       "      <td>-2.500000</td>\n",
       "      <td>0.109000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>279.852720</td>\n",
       "      <td>36.577381</td>\n",
       "      <td>6.966000</td>\n",
       "      <td>7.225000</td>\n",
       "      <td>7.101000</td>\n",
       "      <td>7.627000</td>\n",
       "      <td>6.702000</td>\n",
       "      <td>4.097000</td>\n",
       "      <td>3.014000</td>\n",
       "      <td>2.31100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>18.657036</td>\n",
       "      <td>36.576888</td>\n",
       "      <td>-742.430000</td>\n",
       "      <td>-417.900000</td>\n",
       "      <td>-4.000000</td>\n",
       "      <td>-6.000000</td>\n",
       "      <td>-25.100000</td>\n",
       "      <td>-75.900000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-27.800000</td>\n",
       "      <td>-76.600000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>2391.750000</td>\n",
       "      <td>5.556034e+06</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.733684</td>\n",
       "      <td>132.761718</td>\n",
       "      <td>2.454966e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.197000</td>\n",
       "      <td>2.437750</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.599000e+02</td>\n",
       "      <td>0.012341</td>\n",
       "      <td>0.229250</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>0.037700</td>\n",
       "      <td>83.920000</td>\n",
       "      <td>539.000000</td>\n",
       "      <td>2.015000e+01</td>\n",
       "      <td>5.358000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.228600</td>\n",
       "      <td>0.326800</td>\n",
       "      <td>3.997856</td>\n",
       "      <td>10.733030</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>41.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.134650</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5310.000000</td>\n",
       "      <td>4.218000</td>\n",
       "      <td>-0.260000</td>\n",
       "      <td>0.829000</td>\n",
       "      <td>0.845000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>288.660770</td>\n",
       "      <td>40.777173</td>\n",
       "      <td>13.440000</td>\n",
       "      <td>13.896500</td>\n",
       "      <td>13.393000</td>\n",
       "      <td>13.294000</td>\n",
       "      <td>13.276000</td>\n",
       "      <td>12.253000</td>\n",
       "      <td>11.914500</td>\n",
       "      <td>11.84300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19.243889</td>\n",
       "      <td>40.798688</td>\n",
       "      <td>-0.600000</td>\n",
       "      <td>-0.680000</td>\n",
       "      <td>-0.000210</td>\n",
       "      <td>-0.000220</td>\n",
       "      <td>-0.320000</td>\n",
       "      <td>-0.387000</td>\n",
       "      <td>0.170000</td>\n",
       "      <td>-0.310000</td>\n",
       "      <td>-0.390000</td>\n",
       "      <td>0.210000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>4782.500000</td>\n",
       "      <td>7.906892e+06</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.752831</td>\n",
       "      <td>137.224595</td>\n",
       "      <td>2.454970e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.537000</td>\n",
       "      <td>3.792600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.211000e+02</td>\n",
       "      <td>0.021076</td>\n",
       "      <td>0.956720</td>\n",
       "      <td>2.390000</td>\n",
       "      <td>0.085100</td>\n",
       "      <td>88.500000</td>\n",
       "      <td>878.000000</td>\n",
       "      <td>1.416000e+02</td>\n",
       "      <td>15.460000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.271100</td>\n",
       "      <td>0.392000</td>\n",
       "      <td>5.589751</td>\n",
       "      <td>19.254412</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>143.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.486600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5767.000000</td>\n",
       "      <td>4.438000</td>\n",
       "      <td>-0.100000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.974000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>292.261125</td>\n",
       "      <td>43.677504</td>\n",
       "      <td>14.520000</td>\n",
       "      <td>15.064000</td>\n",
       "      <td>14.471000</td>\n",
       "      <td>14.317500</td>\n",
       "      <td>14.254000</td>\n",
       "      <td>13.236000</td>\n",
       "      <td>12.834000</td>\n",
       "      <td>12.74400</td>\n",
       "      <td>0.006000</td>\n",
       "      <td>19.484983</td>\n",
       "      <td>43.694115</td>\n",
       "      <td>-0.000500</td>\n",
       "      <td>-0.034000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.610000</td>\n",
       "      <td>-0.004000</td>\n",
       "      <td>-0.017000</td>\n",
       "      <td>0.583000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>7173.250000</td>\n",
       "      <td>9.873066e+06</td>\n",
       "      <td>0.995000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>40.715178</td>\n",
       "      <td>170.694603</td>\n",
       "      <td>2.455004e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.889000</td>\n",
       "      <td>6.276500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.473400e+03</td>\n",
       "      <td>0.095348</td>\n",
       "      <td>2.897175</td>\n",
       "      <td>14.930000</td>\n",
       "      <td>0.214400</td>\n",
       "      <td>89.770000</td>\n",
       "      <td>1379.000000</td>\n",
       "      <td>8.702900e+02</td>\n",
       "      <td>45.370000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.299800</td>\n",
       "      <td>0.464100</td>\n",
       "      <td>16.947631</td>\n",
       "      <td>71.998003</td>\n",
       "      <td>78.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>469.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.810375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6112.000000</td>\n",
       "      <td>4.543000</td>\n",
       "      <td>0.070000</td>\n",
       "      <td>1.345000</td>\n",
       "      <td>1.101000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>295.859160</td>\n",
       "      <td>46.714611</td>\n",
       "      <td>15.322000</td>\n",
       "      <td>15.935500</td>\n",
       "      <td>15.275000</td>\n",
       "      <td>15.063000</td>\n",
       "      <td>14.943000</td>\n",
       "      <td>13.968000</td>\n",
       "      <td>13.551000</td>\n",
       "      <td>13.48450</td>\n",
       "      <td>0.196250</td>\n",
       "      <td>19.726785</td>\n",
       "      <td>46.720630</td>\n",
       "      <td>0.570000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000240</td>\n",
       "      <td>0.000240</td>\n",
       "      <td>0.309000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>2.160000</td>\n",
       "      <td>0.290000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>1.970000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>1.293514e+07</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>129995.778400</td>\n",
       "      <td>1472.522306</td>\n",
       "      <td>2.456306e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.806000</td>\n",
       "      <td>138.540000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.541400e+06</td>\n",
       "      <td>99.870651</td>\n",
       "      <td>980.854190</td>\n",
       "      <td>200346.000000</td>\n",
       "      <td>44.989200</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>14667.000000</td>\n",
       "      <td>1.094755e+07</td>\n",
       "      <td>79614.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.482200</td>\n",
       "      <td>0.948600</td>\n",
       "      <td>22982.162000</td>\n",
       "      <td>120049.680000</td>\n",
       "      <td>9054.700000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>2664.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15896.000000</td>\n",
       "      <td>5.364000</td>\n",
       "      <td>0.560000</td>\n",
       "      <td>229.908000</td>\n",
       "      <td>3.735000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>301.720760</td>\n",
       "      <td>52.336010</td>\n",
       "      <td>20.003000</td>\n",
       "      <td>21.150000</td>\n",
       "      <td>19.960000</td>\n",
       "      <td>19.900000</td>\n",
       "      <td>17.403000</td>\n",
       "      <td>17.372000</td>\n",
       "      <td>17.615000</td>\n",
       "      <td>17.03800</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>20.114785</td>\n",
       "      <td>52.338190</td>\n",
       "      <td>549.500000</td>\n",
       "      <td>712.500000</td>\n",
       "      <td>1.190000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>45.680000</td>\n",
       "      <td>27.500000</td>\n",
       "      <td>88.600000</td>\n",
       "      <td>46.570000</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>89.600000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             rowid         kepid    koi_score  koi_fpflag_nt     koi_period  koi_time0bk     koi_time0  koi_eccen  koi_longp   koi_impact  koi_duration  koi_ingress     koi_depth      koi_ror     koi_srho       koi_prad      koi_sma     koi_incl       koi_teq     koi_insol       koi_dor  koi_ldm_coeff4  koi_ldm_coeff3  koi_ldm_coeff2  koi_ldm_coeff1  koi_max_sngle_ev  koi_max_mult_ev  koi_model_snr    koi_count  koi_num_transits  koi_tce_plnt_num  koi_bin_oedp_sig  koi_model_dof  koi_model_chisq     koi_steff    koi_slogg     koi_smet     koi_srad    koi_smass  koi_sage           ra          dec   koi_kepmag     koi_gmag     koi_rmag     koi_imag     koi_zmag     koi_jmag     koi_hmag    koi_kmag  koi_fwm_stat_sig  koi_fwm_sra  koi_fwm_sdec  koi_fwm_srao  koi_fwm_sdeco  koi_fwm_prao  koi_fwm_pdeco  koi_dicco_mra  koi_dicco_mdec  koi_dicco_msky  koi_dikco_mra  koi_dikco_mdec  koi_dikco_msky\n",
       "count  9564.000000  9.564000e+03  9564.000000  9564.000000    9564.000000    9564.000000  9.564000e+03  9201.0     0.0        9201.000000  9564.000000   0.0          9.201000e+03  9201.000000  9243.000000  9201.000000    9201.000000  9200.000000  9201.000000   9.243000e+03  9201.000000   9201.0          9201.0          9201.000000     9201.000000     8422.000000       8422.000000      9201.000000    9564.000000  8422.000000       9218.000000       8054.000000       0.0            0.0              9201.000000   9201.000000  9178.000000  9201.000000  9201.000000  0.0       9564.000000  9564.000000  9563.000000  9523.000000  9555.000000  9410.000000  8951.000000  9539.000000  9539.000000  9539.00000  8488.000000       9058.000000  9058.000000   9109.000000   9109.000000    8734.000000   8747.000000    8965.000000    8965.000000     8965.000000     8994.000000    8994.000000     8994.000000   \n",
       "mean   4782.500000  7.690628e+06  0.404914     0.160079       75.671358      166.183251   2.454999e+06  0.0       NaN         0.735105     5.621606     NaN           2.379134e+04  0.283646     9.164414     102.891778     0.223989     82.469147    1085.385828   7.745737e+03  76.736333     0.0             0.0             0.254439        0.407617        176.846052        1025.664672      259.895001     1.406315     385.006768        1.243654          0.409500         NaN            NaN               5706.823280   4.310157    -0.124431     1.728712     1.023706    NaN        292.060163   43.810433    14.264606    14.830501    14.221565    14.075138    13.991724    12.993311    12.620604    12.54341    0.150994          19.471356    43.829239    -0.316136     -0.165817      -0.000097     -0.000714      -0.012281      -0.045420        1.866561       -0.024244      -0.076749        1.812566      \n",
       "std    2761.033321  2.653459e+06  0.471473     0.366699       1334.744046    67.918960    6.791896e+01  0.0       NaN         3.348832     6.471554     NaN           8.224268e+04  3.306558     53.807967    3077.639126    0.566359     15.223627    856.351161    1.592047e+05  845.274598    0.0             0.0             0.064806        0.106076        770.902357        4154.121620      795.806615     0.873289     545.756200        0.664573          0.500793         NaN            NaN               796.857947    0.432606     0.282111     6.127185     0.349447    NaN        4.766657     3.601243     1.385448     1.501885     1.383713     1.292573     1.230351     1.291912     1.267215     1.26818     0.252648          0.319158     3.599553      20.254777     20.534655      0.058224      0.092986       2.406550       2.573558        2.988742        2.382286       2.553758        2.986376      \n",
       "min    1.000000     7.574500e+05  0.000000     0.000000       0.241843       120.515914   2.454954e+06  0.0       NaN         0.000000     0.052000     NaN           0.000000e+00  0.001289     0.000040     0.080000       0.005900     2.290000     25.000000     0.000000e+00  0.373000      0.0             0.0            -0.120600        0.125400        2.417437          7.105086         0.000000       1.000000     0.000000          1.000000         -1.000000         NaN            NaN               2661.000000   0.047000    -2.500000     0.109000     0.000000    NaN        279.852720   36.577381    6.966000     7.225000     7.101000     7.627000     6.702000     4.097000     3.014000     2.31100     0.000000          18.657036    36.576888    -742.430000   -417.900000    -4.000000     -6.000000      -25.100000     -75.900000       0.000000       -27.800000     -76.600000       0.000000      \n",
       "25%    2391.750000  5.556034e+06  0.000000     0.000000       2.733684       132.761718   2.454966e+06  0.0       NaN         0.197000     2.437750     NaN           1.599000e+02  0.012341     0.229250     1.400000       0.037700     83.920000    539.000000    2.015000e+01  5.358000      0.0             0.0             0.228600        0.326800        3.997856          10.733030        12.000000      1.000000     41.000000         1.000000          0.134650         NaN            NaN               5310.000000   4.218000    -0.260000     0.829000     0.845000    NaN        288.660770   40.777173    13.440000    13.896500    13.393000    13.294000    13.276000    12.253000    11.914500    11.84300    0.000000          19.243889    40.798688    -0.600000     -0.680000      -0.000210     -0.000220      -0.320000      -0.387000        0.170000       -0.310000      -0.390000        0.210000      \n",
       "50%    4782.500000  7.906892e+06  0.000000     0.000000       9.752831       137.224595   2.454970e+06  0.0       NaN         0.537000     3.792600     NaN           4.211000e+02  0.021076     0.956720     2.390000       0.085100     88.500000    878.000000    1.416000e+02  15.460000     0.0             0.0             0.271100        0.392000        5.589751          19.254412        23.000000      1.000000     143.000000        1.000000          0.486600         NaN            NaN               5767.000000   4.438000    -0.100000     1.000000     0.974000    NaN        292.261125   43.677504    14.520000    15.064000    14.471000    14.317500    14.254000    13.236000    12.834000    12.74400    0.006000          19.484983    43.694115    -0.000500     -0.034000       0.000000      0.000000       0.000000       0.000000        0.610000       -0.004000      -0.017000        0.583000      \n",
       "75%    7173.250000  9.873066e+06  0.995000     0.000000       40.715178      170.694603   2.455004e+06  0.0       NaN         0.889000     6.276500     NaN           1.473400e+03  0.095348     2.897175     14.930000      0.214400     89.770000    1379.000000   8.702900e+02  45.370000     0.0             0.0             0.299800        0.464100        16.947631         71.998003        78.000000      1.000000     469.000000        1.000000          0.810375         NaN            NaN               6112.000000   4.543000     0.070000     1.345000     1.101000    NaN        295.859160   46.714611    15.322000    15.935500    15.275000    15.063000    14.943000    13.968000    13.551000    13.48450    0.196250          19.726785    46.720630     0.570000      0.500000       0.000240      0.000240       0.309000       0.300000        2.160000        0.290000       0.300000        1.970000      \n",
       "max    9564.000000  1.293514e+07  1.000000     1.000000       129995.778400  1472.522306  2.456306e+06  0.0       NaN         100.806000   138.540000   NaN           1.541400e+06  99.870651    980.854190   200346.000000  44.989200    90.000000    14667.000000  1.094755e+07  79614.000000  0.0             0.0             0.482200        0.948600        22982.162000      120049.680000    9054.700000    7.000000     2664.000000       8.000000          1.000000         NaN            NaN               15896.000000  5.364000     0.560000     229.908000   3.735000    NaN        301.720760   52.336010    20.003000    21.150000    19.960000    19.900000    17.403000    17.372000    17.615000    17.03800    1.000000          20.114785    52.338190     549.500000    712.500000     1.190000      5.000000       45.680000      27.500000       88.600000       46.570000      34.000000       89.600000     "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['all'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>kepoi_name</th>\n",
       "      <th>kepoi_star</th>\n",
       "      <th>kepler_name</th>\n",
       "      <th>koi_disposition</th>\n",
       "      <th>koi_vet_stat</th>\n",
       "      <th>koi_pdisposition</th>\n",
       "      <th>koi_fpflag_ss</th>\n",
       "      <th>koi_fpflag_co</th>\n",
       "      <th>koi_fpflag_ec</th>\n",
       "      <th>koi_disp_prov</th>\n",
       "      <th>koi_comment</th>\n",
       "      <th>koi_fittype</th>\n",
       "      <th>koi_limbdark_mod</th>\n",
       "      <th>koi_parm_prov</th>\n",
       "      <th>koi_tce_delivname</th>\n",
       "      <th>koi_quarters</th>\n",
       "      <th>koi_trans_mod</th>\n",
       "      <th>koi_datalink_dvr</th>\n",
       "      <th>koi_datalink_dvs</th>\n",
       "      <th>koi_sparprov</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>2305</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9201</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>8422</td>\n",
       "      <td>9201</td>\n",
       "      <td>9218</td>\n",
       "      <td>9218</td>\n",
       "      <td>9201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unique</td>\n",
       "      <td>9564</td>\n",
       "      <td>8214</td>\n",
       "      <td>2305</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>996</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>212</td>\n",
       "      <td>1</td>\n",
       "      <td>8063</td>\n",
       "      <td>9218</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>top</td>\n",
       "      <td>K00499.01</td>\n",
       "      <td>K00351</td>\n",
       "      <td>Kepler-398 b</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>Done</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>sup_koi</td>\n",
       "      <td>NO_COMMENT</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>Claret (2011 A&amp;A 529 75) ATLAS LS</td>\n",
       "      <td>koi</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "      <td>Mandel and Agol (2002 ApJ 580 171)</td>\n",
       "      <td>011/011442/011442793/dv/kplr011442793-20160209194854_dvr.pdf</td>\n",
       "      <td>006/006233/006233573/dv/kplr006233573-001-20160209194854_dvs.pdf</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>freq</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>4841</td>\n",
       "      <td>9564</td>\n",
       "      <td>4847</td>\n",
       "      <td>7338</td>\n",
       "      <td>7675</td>\n",
       "      <td>8416</td>\n",
       "      <td>9564</td>\n",
       "      <td>3109</td>\n",
       "      <td>7897</td>\n",
       "      <td>9201</td>\n",
       "      <td>9564</td>\n",
       "      <td>9218</td>\n",
       "      <td>5426</td>\n",
       "      <td>9201</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>9096</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       kepoi_name kepoi_star   kepler_name koi_disposition koi_vet_stat koi_pdisposition  koi_fpflag_ss  koi_fpflag_co  koi_fpflag_ec koi_disp_prov koi_comment koi_fittype                   koi_limbdark_mod koi_parm_prov koi_tce_delivname                      koi_quarters                       koi_trans_mod                                              koi_datalink_dvr                                                  koi_datalink_dvs koi_sparprov\n",
       "count   9564       9564       2305          9564            9564         9564             9564           9564           9564           9564          9564        9564        9201                               9564          9564              8422                              9201                                9218                                                          9218                                                              9201       \n",
       "unique  9564       8214       2305          3               1            2                2              2              2              1             996         4           1                                  1             2                 212                               1                                   8063                                                          9218                                                              2          \n",
       "top     K00499.01  K00351     Kepler-398 b  FALSE POSITIVE  Done         FALSE POSITIVE   0              0              0              sup_koi       NO_COMMENT  LS+MCMC     Claret (2011 A&A 529 75) ATLAS LS  koi           tce               11111111111111111000000000000000  Mandel and Agol (2002 ApJ 580 171)  011/011442/011442793/dv/kplr011442793-20160209194854_dvr.pdf  006/006233/006233573/dv/kplr006233573-001-20160209194854_dvs.pdf  stellar    \n",
       "freq    1          7          1             4841            9564         4847             7338           7675           8416           9564          3109        7897        9201                               9564          9218              5426                              9201                                7                                                             1                                                                 9096       "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['all'].select_dtypes(['category','object']).describe([], 'all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "rowid                int64         \n",
      "kepid                int64         \n",
      "kepoi_name           object        \n",
      "kepoi_star           category      \n",
      "kepler_name          object        \n",
      "koi_disposition      category      \n",
      "koi_vet_stat         category      \n",
      "koi_vet_date         datetime64[ns]\n",
      "koi_pdisposition     category      \n",
      "koi_score            float64       \n",
      "koi_fpflag_nt        int64         \n",
      "koi_fpflag_ss        category      \n",
      "koi_fpflag_co        category      \n",
      "koi_fpflag_ec        category      \n",
      "koi_disp_prov        category      \n",
      "koi_comment          object        \n",
      "koi_period           float64       \n",
      "koi_time0bk          float64       \n",
      "koi_time0            float64       \n",
      "koi_eccen            float64       \n",
      "koi_longp            float64       \n",
      "koi_impact           float64       \n",
      "koi_duration         float64       \n",
      "koi_ingress          float64       \n",
      "koi_depth            float64       \n",
      "koi_ror              float64       \n",
      "koi_srho             float64       \n",
      "koi_fittype          object        \n",
      "koi_prad             float64       \n",
      "koi_sma              float64       \n",
      "koi_incl             float64       \n",
      "koi_teq              float64       \n",
      "koi_insol            float64       \n",
      "koi_dor              float64       \n",
      "koi_limbdark_mod     object        \n",
      "koi_ldm_coeff4       float64       \n",
      "koi_ldm_coeff3       float64       \n",
      "koi_ldm_coeff2       float64       \n",
      "koi_ldm_coeff1       float64       \n",
      "koi_parm_prov        object        \n",
      "koi_max_sngle_ev     float64       \n",
      "koi_max_mult_ev      float64       \n",
      "koi_model_snr        float64       \n",
      "koi_count            int64         \n",
      "koi_num_transits     float64       \n",
      "koi_tce_plnt_num     float64       \n",
      "koi_tce_delivname    object        \n",
      "koi_quarters         category      \n",
      "koi_bin_oedp_sig     float64       \n",
      "koi_trans_mod        object        \n",
      "koi_model_dof        float64       \n",
      "koi_model_chisq      float64       \n",
      "koi_datalink_dvr     object        \n",
      "koi_datalink_dvs     object        \n",
      "koi_steff            float64       \n",
      "koi_slogg            float64       \n",
      "koi_smet             float64       \n",
      "koi_srad             float64       \n",
      "koi_smass            float64       \n",
      "koi_sage             float64       \n",
      "koi_sparprov         object        \n",
      "ra                   float64       \n",
      "dec                  float64       \n",
      "koi_kepmag           float64       \n",
      "koi_gmag             float64       \n",
      "koi_rmag             float64       \n",
      "koi_imag             float64       \n",
      "koi_zmag             float64       \n",
      "koi_jmag             float64       \n",
      "koi_hmag             float64       \n",
      "koi_kmag             float64       \n",
      "koi_fwm_stat_sig     float64       \n",
      "koi_fwm_sra          float64       \n",
      "koi_fwm_sdec         float64       \n",
      "koi_fwm_srao         float64       \n",
      "koi_fwm_sdeco        float64       \n",
      "koi_fwm_prao         float64       \n",
      "koi_fwm_pdeco        float64       \n",
      "koi_dicco_mra        float64       \n",
      "koi_dicco_mdec       float64       \n",
      "koi_dicco_msky       float64       \n",
      "koi_dikco_mra        float64       \n",
      "koi_dikco_mdec       float64       \n",
      "koi_dikco_msky       float64       \n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "# Ensure column types are correct\n",
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):\n",
    "    print( koi['all'].dtypes )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "columns with ANY  NaN:      59 / 84\n",
      "columns with ONLY NaN:      ['koi_longp', 'koi_ingress', 'koi_model_dof', 'koi_model_chisq', 'koi_sage']\n",
      "columns with SINGLE value:  ['koi_vet_stat', 'koi_vet_date', 'koi_disp_prov', 'koi_eccen', 'koi_limbdark_mod', 'koi_ldm_coeff4', 'koi_ldm_coeff3', 'koi_parm_prov', 'koi_trans_mod']\n",
      "---\n",
      "kepler_name         7259\n",
      "koi_eccen           363 \n",
      "koi_longp           9564\n",
      "koi_impact          363 \n",
      "koi_ingress         9564\n",
      "koi_depth           363 \n",
      "koi_ror             363 \n",
      "koi_srho            321 \n",
      "koi_prad            363 \n",
      "koi_sma             363 \n",
      "koi_incl            364 \n",
      "koi_teq             363 \n",
      "koi_insol           321 \n",
      "koi_dor             363 \n",
      "koi_limbdark_mod    363 \n",
      "koi_ldm_coeff4      363 \n",
      "koi_ldm_coeff3      363 \n",
      "koi_ldm_coeff2      363 \n",
      "koi_ldm_coeff1      363 \n",
      "koi_max_sngle_ev    1142\n",
      "koi_max_mult_ev     1142\n",
      "koi_model_snr       363 \n",
      "koi_num_transits    1142\n",
      "koi_tce_plnt_num    346 \n",
      "koi_quarters        1142\n",
      "koi_bin_oedp_sig    1510\n",
      "koi_trans_mod       363 \n",
      "koi_model_dof       9564\n",
      "koi_model_chisq     9564\n",
      "koi_datalink_dvr    346 \n",
      "koi_datalink_dvs    346 \n",
      "koi_steff           363 \n",
      "koi_slogg           363 \n",
      "koi_smet            386 \n",
      "koi_srad            363 \n",
      "koi_smass           363 \n",
      "koi_sage            9564\n",
      "koi_sparprov        363 \n",
      "koi_kepmag          1   \n",
      "koi_gmag            41  \n",
      "koi_rmag            9   \n",
      "koi_imag            154 \n",
      "koi_zmag            613 \n",
      "koi_jmag            25  \n",
      "koi_hmag            25  \n",
      "koi_kmag            25  \n",
      "koi_fwm_stat_sig    1076\n",
      "koi_fwm_sra         506 \n",
      "koi_fwm_sdec        506 \n",
      "koi_fwm_srao        455 \n",
      "koi_fwm_sdeco       455 \n",
      "koi_fwm_prao        830 \n",
      "koi_fwm_pdeco       817 \n",
      "koi_dicco_mra       599 \n",
      "koi_dicco_mdec      599 \n",
      "koi_dicco_msky      599 \n",
      "koi_dikco_mra       570 \n",
      "koi_dikco_mdec      570 \n",
      "koi_dikco_msky      570 \n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Check to see which columns contain NaN values\n",
    "# Unsure what to do with these just yet - may replace them on a case by case later\n",
    "# - columns with ONLY NaN: have been removed from category subsets\n",
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):\n",
    "    koi_isnan_columns    = koi['all'].isna().sum(axis=0)\n",
    "    koi_isnan_columns    = koi_isnan_columns[ koi_isnan_columns != 0 ]  \n",
    "    koi_only_nan_columns = koi_isnan_columns[ koi_isnan_columns == koi['all'].shape[0] ]  \n",
    "    koi_single_value_col = koi['all'].nunique().where(lambda x: x == 1).dropna().keys()\n",
    "    \n",
    "    print( 'columns with ANY  NaN:     ', koi_isnan_columns.size, '/', koi['all'].shape[1] )\n",
    "    print( 'columns with ONLY NaN:     ', koi_only_nan_columns.keys().to_list() )\n",
    "    print( 'columns with SINGLE value: ', koi_single_value_col.to_list() )    \n",
    "    print('---')\n",
    "    print( koi_isnan_columns )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['id', 'archive', 'disposition', 'transit', 'TCE', 'stellar', 'KIC', 'pixels'])"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi_columns.keys()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: ID\n",
    "\n",
    "This the external ID used to map back to the Kepler Input Catalog (KIC)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>kepid</th>\n",
       "      <th>kepoi_name</th>\n",
       "      <th>kepoi_star</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>kepoi_name</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>10797460</td>\n",
       "      <td>K00752.01</td>\n",
       "      <td>K00752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>10797460</td>\n",
       "      <td>K00752.02</td>\n",
       "      <td>K00752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>10811496</td>\n",
       "      <td>K00753.01</td>\n",
       "      <td>K00753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>10848459</td>\n",
       "      <td>K00754.01</td>\n",
       "      <td>K00754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</td>\n",
       "      <td>10128825</td>\n",
       "      <td>K07986.01</td>\n",
       "      <td>K07986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>10147276</td>\n",
       "      <td>K07987.01</td>\n",
       "      <td>K07987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>10155286</td>\n",
       "      <td>K07988.01</td>\n",
       "      <td>K07988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>10156110</td>\n",
       "      <td>K07989.01</td>\n",
       "      <td>K07989</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               kepid kepoi_name kepoi_star\n",
       "kepoi_name                                \n",
       "K00752.01   10797460  K00752.01  K00752   \n",
       "K00752.02   10797460  K00752.02  K00752   \n",
       "K00753.01   10811496  K00753.01  K00753   \n",
       "K00754.01   10848459  K00754.01  K00754   \n",
       "...              ...        ...     ...   \n",
       "K07986.01   10128825  K07986.01  K07986   \n",
       "K07987.01   10147276  K07987.01  K07987   \n",
       "K07988.01   10155286  K07988.01  K07988   \n",
       "K07989.01   10156110  K07989.01  K07989   \n",
       "\n",
       "[9564 rows x 3 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>kepid</th>\n",
       "      <th>kepoi_name</th>\n",
       "      <th>kepoi_star</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unique</td>\n",
       "      <td>8214</td>\n",
       "      <td>9564</td>\n",
       "      <td>8214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>top</td>\n",
       "      <td>11442793</td>\n",
       "      <td>K00499.01</td>\n",
       "      <td>K02433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>freq</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           kepid kepoi_name kepoi_star\n",
       "count   9564      9564       9564     \n",
       "unique  8214      9564       8214     \n",
       "top     11442793  K00499.01  K02433   \n",
       "freq    7         1          7        "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['id'].astype('object').describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "kepid         0\n",
       "kepoi_name    0\n",
       "kepoi_star    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['id'].isna().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: Exoplanet Archive Information\n",
    "\n",
    "Exoplanet Archive Information - this is the master index of which exoplanets have been \"found\", either as CONFIRMED, CANDIDATE, FALSE POSITIVE\n",
    "\n",
    "When an exoplanet gets \"found\" it is also given a human-friendly name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>kepoi_name</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>Kepler-227 c</td>\n",
       "      <td>CONFIRMED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANDIDATE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             kepler_name koi_disposition\n",
       "kepoi_name                              \n",
       "K00752.01   Kepler-227 b  CONFIRMED     \n",
       "K00752.02   Kepler-227 c  CONFIRMED     \n",
       "K00753.01   NaN           CANDIDATE     \n",
       "K00754.01   NaN           FALSE POSITIVE\n",
       "...         ...                 ...     \n",
       "K07986.01   NaN           CANDIDATE     \n",
       "K07987.01   NaN           FALSE POSITIVE\n",
       "K07988.01   NaN           CANDIDATE     \n",
       "K07989.01   NaN           FALSE POSITIVE\n",
       "\n",
       "[9564 rows x 2 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['archive']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>2305</td>\n",
       "      <td>9564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unique</td>\n",
       "      <td>2305</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>top</td>\n",
       "      <td>Kepler-398 b</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>freq</td>\n",
       "      <td>1</td>\n",
       "      <td>4841</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         kepler_name koi_disposition\n",
       "count   2305          9564          \n",
       "unique  2305          3             \n",
       "top     Kepler-398 b  FALSE POSITIVE\n",
       "freq    1             4841          "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['archive'].astype('object').describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "kepler_name        7259\n",
       "koi_disposition    0   \n",
       "dtype: int64"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['archive'].isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[CONFIRMED, CANDIDATE, FALSE POSITIVE]\n",
       "Categories (3, object): [CONFIRMED, CANDIDATE, FALSE POSITIVE]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['archive']['koi_disposition'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: Disposition\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": 54,
   "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>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</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</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>NO_COMMENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</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>NO_COMMENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</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>DEEP_V_SHAPED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</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>MOD_ODDEVEN_DV---MOD_ODDEVEN_ALT---DEEP_V_SHAPED</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</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>NO_COMMENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</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>CENT_RESOLVED_OFFSET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</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>ALL_TRANS_CHASES---CENT_SATURATED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</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>CENT_RESOLVED_OFFSET---HALO_GHOST---EPHEM_MATCH</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           koi_pdisposition  koi_score  koi_fpflag_nt koi_fpflag_ss koi_fpflag_co koi_fpflag_ec                                       koi_comment\n",
       "kepoi_name                                                                                                                                       \n",
       "K00752.01   CANDIDATE        1.000      0              0             0             0             NO_COMMENT                                      \n",
       "K00752.02   CANDIDATE        0.969      0              0             0             0             NO_COMMENT                                      \n",
       "K00753.01   CANDIDATE        0.000      0              0             0             0             DEEP_V_SHAPED                                   \n",
       "K00754.01   FALSE POSITIVE   0.000      0              1             0             0             MOD_ODDEVEN_DV---MOD_ODDEVEN_ALT---DEEP_V_SHAPED\n",
       "...               ...          ...     ..             ..            ..            ..                       ...                                   \n",
       "K07986.01   CANDIDATE        0.497      0              0             0             0             NO_COMMENT                                      \n",
       "K07987.01   FALSE POSITIVE   0.021      0              0             1             0             CENT_RESOLVED_OFFSET                            \n",
       "K07988.01   CANDIDATE        0.092      0              0             0             0             ALL_TRANS_CHASES---CENT_SATURATED               \n",
       "K07989.01   FALSE POSITIVE   0.000      0              0             1             1             CENT_RESOLVED_OFFSET---HALO_GHOST---EPHEM_MATCH \n",
       "\n",
       "[9564 rows x 7 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['disposition']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>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</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564.0</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "      <td>9564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unique</td>\n",
       "      <td>2</td>\n",
       "      <td>650.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>top</td>\n",
       "      <td>FALSE POSITIVE</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NO_COMMENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>freq</td>\n",
       "      <td>4847</td>\n",
       "      <td>4992.0</td>\n",
       "      <td>8033</td>\n",
       "      <td>7338</td>\n",
       "      <td>7675</td>\n",
       "      <td>8416</td>\n",
       "      <td>3109</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       koi_pdisposition  koi_score  koi_fpflag_nt  koi_fpflag_ss  koi_fpflag_co  koi_fpflag_ec koi_comment\n",
       "count   9564             9564.0     9564           9564           9564           9564           9564      \n",
       "unique  2                650.0      2              2              2              2              996       \n",
       "top     FALSE POSITIVE   0.0        0              0              0              0              NO_COMMENT\n",
       "freq    4847             4992.0     8033           7338           7675           8416           3109      "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['disposition'].astype('object').describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Maximum number of comment values for a single KOI = 11\n",
    "( \n",
    "    _( koi['disposition']['koi_comment'].values )\n",
    "        .map( lambda str: str.split('---') )\n",
    "        .map( lambda lst: len(lst) )\n",
    "        .max()\n",
    "        .value()\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "126"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Total number of unique comment labels = 126\n",
    "( \n",
    "    _( koi['disposition']['koi_comment'].values )\n",
    "        .map( lambda str: str.split('---') )\n",
    "        .flatten()\n",
    "        .uniq()\n",
    "        .sort()\n",
    "        .size()\n",
    "        .value()\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "koi_pdisposition    0\n",
       "koi_score           0\n",
       "koi_fpflag_nt       0\n",
       "koi_fpflag_ss       0\n",
       "koi_fpflag_co       0\n",
       "koi_fpflag_ec       0\n",
       "koi_comment         0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# No NaN's for this category\n",
    "koi['disposition'].isna().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: transit\n",
    "\n",
    "Transit properties are the core measurements describing the light curve of the planetry transit, \n",
    "which allows reverse-engineering the planet properties. \n",
    "\n",
    "Transit Light Curve Tutorial: https://www.cfa.harvard.edu/~avanderb/tutorial/tutorial.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>koi_period</th>\n",
       "      <th>koi_time0bk</th>\n",
       "      <th>koi_time0</th>\n",
       "      <th>koi_impact</th>\n",
       "      <th>koi_duration</th>\n",
       "      <th>koi_depth</th>\n",
       "      <th>koi_ror</th>\n",
       "      <th>koi_srho</th>\n",
       "      <th>koi_fittype</th>\n",
       "      <th>koi_prad</th>\n",
       "      <th>koi_sma</th>\n",
       "      <th>koi_incl</th>\n",
       "      <th>koi_teq</th>\n",
       "      <th>koi_insol</th>\n",
       "      <th>koi_dor</th>\n",
       "      <th>koi_ldm_coeff1</th>\n",
       "      <th>koi_ldm_coeff2</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</td>\n",
       "      <td>9.488036</td>\n",
       "      <td>170.538750</td>\n",
       "      <td>2455003.539</td>\n",
       "      <td>0.146</td>\n",
       "      <td>2.95750</td>\n",
       "      <td>615.8</td>\n",
       "      <td>0.022344</td>\n",
       "      <td>3.20796</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>2.26</td>\n",
       "      <td>0.0853</td>\n",
       "      <td>89.66</td>\n",
       "      <td>793.0</td>\n",
       "      <td>93.59</td>\n",
       "      <td>24.810</td>\n",
       "      <td>0.4603</td>\n",
       "      <td>0.2291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>54.418383</td>\n",
       "      <td>162.513840</td>\n",
       "      <td>2454995.514</td>\n",
       "      <td>0.586</td>\n",
       "      <td>4.50700</td>\n",
       "      <td>874.8</td>\n",
       "      <td>0.027954</td>\n",
       "      <td>3.02368</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>2.83</td>\n",
       "      <td>0.2734</td>\n",
       "      <td>89.57</td>\n",
       "      <td>443.0</td>\n",
       "      <td>9.11</td>\n",
       "      <td>77.900</td>\n",
       "      <td>0.4603</td>\n",
       "      <td>0.2291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>19.899140</td>\n",
       "      <td>175.850252</td>\n",
       "      <td>2455008.850</td>\n",
       "      <td>0.969</td>\n",
       "      <td>1.78220</td>\n",
       "      <td>10829.0</td>\n",
       "      <td>0.154046</td>\n",
       "      <td>7.29555</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>14.60</td>\n",
       "      <td>0.1419</td>\n",
       "      <td>88.96</td>\n",
       "      <td>638.0</td>\n",
       "      <td>39.30</td>\n",
       "      <td>53.500</td>\n",
       "      <td>0.3858</td>\n",
       "      <td>0.2711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>1.736952</td>\n",
       "      <td>170.307565</td>\n",
       "      <td>2455003.308</td>\n",
       "      <td>1.276</td>\n",
       "      <td>2.40641</td>\n",
       "      <td>8079.2</td>\n",
       "      <td>0.387394</td>\n",
       "      <td>0.22080</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>33.46</td>\n",
       "      <td>0.0267</td>\n",
       "      <td>67.09</td>\n",
       "      <td>1395.0</td>\n",
       "      <td>891.96</td>\n",
       "      <td>3.278</td>\n",
       "      <td>0.3556</td>\n",
       "      <td>0.2865</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</td>\n",
       "      <td>1.739849</td>\n",
       "      <td>133.001270</td>\n",
       "      <td>2454966.001</td>\n",
       "      <td>0.043</td>\n",
       "      <td>3.11400</td>\n",
       "      <td>48.5</td>\n",
       "      <td>0.006379</td>\n",
       "      <td>0.50770</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0.0290</td>\n",
       "      <td>89.42</td>\n",
       "      <td>1608.0</td>\n",
       "      <td>1585.81</td>\n",
       "      <td>4.331</td>\n",
       "      <td>0.3588</td>\n",
       "      <td>0.2868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>0.681402</td>\n",
       "      <td>132.181750</td>\n",
       "      <td>2454965.182</td>\n",
       "      <td>0.147</td>\n",
       "      <td>0.86500</td>\n",
       "      <td>103.6</td>\n",
       "      <td>0.009444</td>\n",
       "      <td>8.97692</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>1.07</td>\n",
       "      <td>0.0157</td>\n",
       "      <td>88.60</td>\n",
       "      <td>2218.0</td>\n",
       "      <td>5713.41</td>\n",
       "      <td>6.040</td>\n",
       "      <td>0.3239</td>\n",
       "      <td>0.3029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>333.486169</td>\n",
       "      <td>153.615010</td>\n",
       "      <td>2454986.615</td>\n",
       "      <td>0.214</td>\n",
       "      <td>3.19900</td>\n",
       "      <td>639.1</td>\n",
       "      <td>0.022590</td>\n",
       "      <td>85.88623</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>19.30</td>\n",
       "      <td>1.2233</td>\n",
       "      <td>89.98</td>\n",
       "      <td>557.0</td>\n",
       "      <td>22.68</td>\n",
       "      <td>796.000</td>\n",
       "      <td>0.5559</td>\n",
       "      <td>0.1697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>4.856035</td>\n",
       "      <td>135.993300</td>\n",
       "      <td>2454968.993</td>\n",
       "      <td>0.134</td>\n",
       "      <td>3.07800</td>\n",
       "      <td>76.7</td>\n",
       "      <td>0.008076</td>\n",
       "      <td>1.40645</td>\n",
       "      <td>LS+MCMC</td>\n",
       "      <td>1.05</td>\n",
       "      <td>0.0606</td>\n",
       "      <td>89.36</td>\n",
       "      <td>1266.0</td>\n",
       "      <td>607.42</td>\n",
       "      <td>12.060</td>\n",
       "      <td>0.2998</td>\n",
       "      <td>0.3138</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            koi_period  koi_time0bk    koi_time0  koi_impact  koi_duration  koi_depth   koi_ror  koi_srho koi_fittype  koi_prad  koi_sma  koi_incl  koi_teq  koi_insol  koi_dor  koi_ldm_coeff1  koi_ldm_coeff2\n",
       "kepoi_name                                                                                                                                                                                                     \n",
       "K00752.01   9.488036    170.538750   2455003.539  0.146       2.95750       615.8      0.022344  3.20796   LS+MCMC     2.26      0.0853   89.66     793.0    93.59      24.810   0.4603          0.2291        \n",
       "K00752.02   54.418383   162.513840   2454995.514  0.586       4.50700       874.8      0.027954  3.02368   LS+MCMC     2.83      0.2734   89.57     443.0    9.11       77.900   0.4603          0.2291        \n",
       "K00753.01   19.899140   175.850252   2455008.850  0.969       1.78220       10829.0    0.154046  7.29555   LS+MCMC     14.60     0.1419   88.96     638.0    39.30      53.500   0.3858          0.2711        \n",
       "K00754.01   1.736952    170.307565   2455003.308  1.276       2.40641       8079.2     0.387394  0.22080   LS+MCMC     33.46     0.0267   67.09     1395.0   891.96     3.278    0.3556          0.2865        \n",
       "...               ...          ...           ...    ...           ...           ...         ...      ...       ...       ...        ...     ...       ...      ...         ...      ...             ...        \n",
       "K07986.01   1.739849    133.001270   2454966.001  0.043       3.11400       48.5       0.006379  0.50770   LS+MCMC     0.72      0.0290   89.42     1608.0   1585.81    4.331    0.3588          0.2868        \n",
       "K07987.01   0.681402    132.181750   2454965.182  0.147       0.86500       103.6      0.009444  8.97692   LS+MCMC     1.07      0.0157   88.60     2218.0   5713.41    6.040    0.3239          0.3029        \n",
       "K07988.01   333.486169  153.615010   2454986.615  0.214       3.19900       639.1      0.022590  85.88623  LS+MCMC     19.30     1.2233   89.98     557.0    22.68      796.000  0.5559          0.1697        \n",
       "K07989.01   4.856035    135.993300   2454968.993  0.134       3.07800       76.7       0.008076  1.40645   LS+MCMC     1.05      0.0606   89.36     1266.0   607.42     12.060   0.2998          0.3138        \n",
       "\n",
       "[9564 rows x 17 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['transit']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "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>koi_period</th>\n",
       "      <th>koi_time0bk</th>\n",
       "      <th>koi_time0</th>\n",
       "      <th>koi_impact</th>\n",
       "      <th>koi_duration</th>\n",
       "      <th>koi_depth</th>\n",
       "      <th>koi_ror</th>\n",
       "      <th>koi_srho</th>\n",
       "      <th>koi_prad</th>\n",
       "      <th>koi_sma</th>\n",
       "      <th>koi_incl</th>\n",
       "      <th>koi_teq</th>\n",
       "      <th>koi_insol</th>\n",
       "      <th>koi_dor</th>\n",
       "      <th>koi_ldm_coeff1</th>\n",
       "      <th>koi_ldm_coeff2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9.564000e+03</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9.201000e+03</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9243.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9200.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9.243000e+03</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>75.671358</td>\n",
       "      <td>166.183251</td>\n",
       "      <td>2.454999e+06</td>\n",
       "      <td>0.735105</td>\n",
       "      <td>5.621606</td>\n",
       "      <td>2.379134e+04</td>\n",
       "      <td>0.283646</td>\n",
       "      <td>9.164414</td>\n",
       "      <td>102.891778</td>\n",
       "      <td>0.223989</td>\n",
       "      <td>82.469147</td>\n",
       "      <td>1085.385828</td>\n",
       "      <td>7.745737e+03</td>\n",
       "      <td>76.736333</td>\n",
       "      <td>0.407617</td>\n",
       "      <td>0.254439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>1334.744046</td>\n",
       "      <td>67.918960</td>\n",
       "      <td>6.791896e+01</td>\n",
       "      <td>3.348832</td>\n",
       "      <td>6.471554</td>\n",
       "      <td>8.224268e+04</td>\n",
       "      <td>3.306558</td>\n",
       "      <td>53.807967</td>\n",
       "      <td>3077.639126</td>\n",
       "      <td>0.566359</td>\n",
       "      <td>15.223627</td>\n",
       "      <td>856.351161</td>\n",
       "      <td>1.592047e+05</td>\n",
       "      <td>845.274598</td>\n",
       "      <td>0.106076</td>\n",
       "      <td>0.064806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>0.241843</td>\n",
       "      <td>120.515914</td>\n",
       "      <td>2.454954e+06</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.052000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.001289</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.080000</td>\n",
       "      <td>0.005900</td>\n",
       "      <td>2.290000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.373000</td>\n",
       "      <td>0.125400</td>\n",
       "      <td>-0.120600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>2.733684</td>\n",
       "      <td>132.761718</td>\n",
       "      <td>2.454966e+06</td>\n",
       "      <td>0.197000</td>\n",
       "      <td>2.437750</td>\n",
       "      <td>1.599000e+02</td>\n",
       "      <td>0.012341</td>\n",
       "      <td>0.229250</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>0.037700</td>\n",
       "      <td>83.920000</td>\n",
       "      <td>539.000000</td>\n",
       "      <td>2.015000e+01</td>\n",
       "      <td>5.358000</td>\n",
       "      <td>0.326800</td>\n",
       "      <td>0.228600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>9.752831</td>\n",
       "      <td>137.224595</td>\n",
       "      <td>2.454970e+06</td>\n",
       "      <td>0.537000</td>\n",
       "      <td>3.792600</td>\n",
       "      <td>4.211000e+02</td>\n",
       "      <td>0.021076</td>\n",
       "      <td>0.956720</td>\n",
       "      <td>2.390000</td>\n",
       "      <td>0.085100</td>\n",
       "      <td>88.500000</td>\n",
       "      <td>878.000000</td>\n",
       "      <td>1.416000e+02</td>\n",
       "      <td>15.460000</td>\n",
       "      <td>0.392000</td>\n",
       "      <td>0.271100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>40.715178</td>\n",
       "      <td>170.694603</td>\n",
       "      <td>2.455004e+06</td>\n",
       "      <td>0.889000</td>\n",
       "      <td>6.276500</td>\n",
       "      <td>1.473400e+03</td>\n",
       "      <td>0.095348</td>\n",
       "      <td>2.897175</td>\n",
       "      <td>14.930000</td>\n",
       "      <td>0.214400</td>\n",
       "      <td>89.770000</td>\n",
       "      <td>1379.000000</td>\n",
       "      <td>8.702900e+02</td>\n",
       "      <td>45.370000</td>\n",
       "      <td>0.464100</td>\n",
       "      <td>0.299800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>129995.778400</td>\n",
       "      <td>1472.522306</td>\n",
       "      <td>2.456306e+06</td>\n",
       "      <td>100.806000</td>\n",
       "      <td>138.540000</td>\n",
       "      <td>1.541400e+06</td>\n",
       "      <td>99.870651</td>\n",
       "      <td>980.854190</td>\n",
       "      <td>200346.000000</td>\n",
       "      <td>44.989200</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>14667.000000</td>\n",
       "      <td>1.094755e+07</td>\n",
       "      <td>79614.000000</td>\n",
       "      <td>0.948600</td>\n",
       "      <td>0.482200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          koi_period  koi_time0bk     koi_time0   koi_impact  koi_duration     koi_depth      koi_ror     koi_srho       koi_prad      koi_sma     koi_incl       koi_teq     koi_insol       koi_dor  koi_ldm_coeff1  koi_ldm_coeff2\n",
       "count  9564.000000    9564.000000  9.564000e+03  9201.000000  9564.000000   9.201000e+03  9201.000000  9243.000000  9201.000000    9201.000000  9200.000000  9201.000000   9.243000e+03  9201.000000   9201.000000     9201.000000   \n",
       "mean   75.671358      166.183251   2.454999e+06  0.735105     5.621606      2.379134e+04  0.283646     9.164414     102.891778     0.223989     82.469147    1085.385828   7.745737e+03  76.736333     0.407617        0.254439      \n",
       "std    1334.744046    67.918960    6.791896e+01  3.348832     6.471554      8.224268e+04  3.306558     53.807967    3077.639126    0.566359     15.223627    856.351161    1.592047e+05  845.274598    0.106076        0.064806      \n",
       "min    0.241843       120.515914   2.454954e+06  0.000000     0.052000      0.000000e+00  0.001289     0.000040     0.080000       0.005900     2.290000     25.000000     0.000000e+00  0.373000      0.125400       -0.120600      \n",
       "25%    2.733684       132.761718   2.454966e+06  0.197000     2.437750      1.599000e+02  0.012341     0.229250     1.400000       0.037700     83.920000    539.000000    2.015000e+01  5.358000      0.326800        0.228600      \n",
       "50%    9.752831       137.224595   2.454970e+06  0.537000     3.792600      4.211000e+02  0.021076     0.956720     2.390000       0.085100     88.500000    878.000000    1.416000e+02  15.460000     0.392000        0.271100      \n",
       "75%    40.715178      170.694603   2.455004e+06  0.889000     6.276500      1.473400e+03  0.095348     2.897175     14.930000      0.214400     89.770000    1379.000000   8.702900e+02  45.370000     0.464100        0.299800      \n",
       "max    129995.778400  1472.522306  2.456306e+06  100.806000   138.540000    1.541400e+06  99.870651    980.854190   200346.000000  44.989200    90.000000    14667.000000  1.094755e+07  79614.000000  0.948600        0.482200      "
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['transit'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>koi_fittype</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unique</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>top</td>\n",
       "      <td>LS+MCMC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>freq</td>\n",
       "      <td>7897</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       koi_fittype\n",
       "count   9564      \n",
       "unique  4         \n",
       "top     LS+MCMC   \n",
       "freq    7897      "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['transit'].select_dtypes(['category','object']).describe([], 'all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['LS+MCMC', 'MCMC', 'LS', 'none'], dtype=object)"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['transit']['koi_fittype'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['koi'], dtype=object)"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['all']['koi_parm_prov'].unique()  # Single Value Only after cleanup, not in: koi['transit']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: TCE\n",
    "\n",
    "Threshold-Crossing Event (TCE) Information is mostly useful for determining the number of transits and the number of planets detected for a star"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>koi_max_sngle_ev</th>\n",
       "      <th>koi_max_mult_ev</th>\n",
       "      <th>koi_model_snr</th>\n",
       "      <th>koi_count</th>\n",
       "      <th>koi_num_transits</th>\n",
       "      <th>koi_tce_plnt_num</th>\n",
       "      <th>koi_tce_delivname</th>\n",
       "      <th>koi_quarters</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</td>\n",
       "      <td>5.135849</td>\n",
       "      <td>28.470820</td>\n",
       "      <td>35.8</td>\n",
       "      <td>2</td>\n",
       "      <td>142.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>7.027669</td>\n",
       "      <td>20.109507</td>\n",
       "      <td>25.8</td>\n",
       "      <td>2</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>37.159767</td>\n",
       "      <td>187.449100</td>\n",
       "      <td>76.3</td>\n",
       "      <td>1</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111101110111011000000000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>39.066550</td>\n",
       "      <td>541.895100</td>\n",
       "      <td>505.6</td>\n",
       "      <td>1</td>\n",
       "      <td>621.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111110111011101000000000000000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</td>\n",
       "      <td>3.841146</td>\n",
       "      <td>8.569540</td>\n",
       "      <td>10.6</td>\n",
       "      <td>1</td>\n",
       "      <td>766.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>3.748643</td>\n",
       "      <td>9.653322</td>\n",
       "      <td>12.3</td>\n",
       "      <td>1</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>5.252939</td>\n",
       "      <td>7.240365</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111101110111011000000000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>3.253128</td>\n",
       "      <td>7.167940</td>\n",
       "      <td>8.2</td>\n",
       "      <td>1</td>\n",
       "      <td>218.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111101110111011000000000000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            koi_max_sngle_ev  koi_max_mult_ev  koi_model_snr  koi_count  koi_num_transits  koi_tce_plnt_num koi_tce_delivname                      koi_quarters\n",
       "kepoi_name                                                                                                                                                     \n",
       "K00752.01   5.135849          28.470820        35.8           2          142.0             1.0               tce               11111111111111111000000000000000\n",
       "K00752.02   7.027669          20.109507        25.8           2          25.0              2.0               tce               11111111111111111000000000000000\n",
       "K00753.01   37.159767         187.449100       76.3           1          56.0              1.0               tce               11111101110111011000000000000000\n",
       "K00754.01   39.066550         541.895100       505.6          1          621.0             1.0               tce               11111110111011101000000000000000\n",
       "...               ...                ...        ...          ..           ...              ...               ...                                            ...\n",
       "K07986.01   3.841146          8.569540         10.6           1          766.0             1.0               tce               11111111111111111000000000000000\n",
       "K07987.01   3.748643          9.653322         12.3           1          1969.0            1.0               tce               11111111111111111000000000000000\n",
       "K07988.01   5.252939          7.240365         14.0           1          3.0               1.0               tce               11111101110111011000000000000000\n",
       "K07989.01   3.253128          7.167940         8.2            1          218.0             1.0               tce               11111101110111011000000000000000\n",
       "\n",
       "[9564 rows x 8 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['TCE']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>koi_max_sngle_ev</th>\n",
       "      <th>koi_max_mult_ev</th>\n",
       "      <th>koi_model_snr</th>\n",
       "      <th>koi_count</th>\n",
       "      <th>koi_num_transits</th>\n",
       "      <th>koi_tce_plnt_num</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>8422.000000</td>\n",
       "      <td>8422.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>8422.000000</td>\n",
       "      <td>9218.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>176.846052</td>\n",
       "      <td>1025.664672</td>\n",
       "      <td>259.895001</td>\n",
       "      <td>1.406315</td>\n",
       "      <td>385.006768</td>\n",
       "      <td>1.243654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>770.902357</td>\n",
       "      <td>4154.121620</td>\n",
       "      <td>795.806615</td>\n",
       "      <td>0.873289</td>\n",
       "      <td>545.756200</td>\n",
       "      <td>0.664573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>2.417437</td>\n",
       "      <td>7.105086</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>3.997856</td>\n",
       "      <td>10.733030</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>41.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>5.589751</td>\n",
       "      <td>19.254412</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>143.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>16.947631</td>\n",
       "      <td>71.998003</td>\n",
       "      <td>78.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>469.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>22982.162000</td>\n",
       "      <td>120049.680000</td>\n",
       "      <td>9054.700000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>2664.000000</td>\n",
       "      <td>8.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       koi_max_sngle_ev  koi_max_mult_ev  koi_model_snr    koi_count  koi_num_transits  koi_tce_plnt_num\n",
       "count  8422.000000       8422.000000      9201.000000    9564.000000  8422.000000       9218.000000     \n",
       "mean   176.846052        1025.664672      259.895001     1.406315     385.006768        1.243654        \n",
       "std    770.902357        4154.121620      795.806615     0.873289     545.756200        0.664573        \n",
       "min    2.417437          7.105086         0.000000       1.000000     0.000000          1.000000        \n",
       "25%    3.997856          10.733030        12.000000      1.000000     41.000000         1.000000        \n",
       "50%    5.589751          19.254412        23.000000      1.000000     143.000000        1.000000        \n",
       "75%    16.947631         71.998003        78.000000      1.000000     469.000000        1.000000        \n",
       "max    22982.162000      120049.680000    9054.700000    7.000000     2664.000000       8.000000        "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['TCE'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "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>koi_tce_delivname</th>\n",
       "      <th>koi_quarters</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564</td>\n",
       "      <td>8422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unique</td>\n",
       "      <td>2</td>\n",
       "      <td>212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>top</td>\n",
       "      <td>tce</td>\n",
       "      <td>11111111111111111000000000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>freq</td>\n",
       "      <td>9218</td>\n",
       "      <td>5426</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       koi_tce_delivname                      koi_quarters\n",
       "count   9564              8422                            \n",
       "unique  2                 212                             \n",
       "top     tce               11111111111111111000000000000000\n",
       "freq    9218              5426                            "
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['TCE'].select_dtypes(['category','object']).describe([], 'all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['tce', ''], dtype=object)"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['TCE']['koi_tce_delivname'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "koi_max_sngle_ev     1142\n",
       "koi_max_mult_ev      1142\n",
       "koi_model_snr        363 \n",
       "koi_count            0   \n",
       "koi_num_transits     1142\n",
       "koi_tce_plnt_num     346 \n",
       "koi_tce_delivname    0   \n",
       "koi_quarters         1142\n",
       "dtype: int64"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['TCE'].isna().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: stellar\n",
    "\n",
    "These are the key statistics of the star: temperature, surface gravity, metallicity, radius, mass, age "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "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>koi_steff</th>\n",
       "      <th>koi_slogg</th>\n",
       "      <th>koi_smet</th>\n",
       "      <th>koi_srad</th>\n",
       "      <th>koi_smass</th>\n",
       "      <th>koi_sparprov</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</td>\n",
       "      <td>5455.0</td>\n",
       "      <td>4.467</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.927</td>\n",
       "      <td>0.919</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>5455.0</td>\n",
       "      <td>4.467</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.927</td>\n",
       "      <td>0.919</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>5853.0</td>\n",
       "      <td>4.544</td>\n",
       "      <td>-0.18</td>\n",
       "      <td>0.868</td>\n",
       "      <td>0.961</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>5805.0</td>\n",
       "      <td>4.564</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>0.791</td>\n",
       "      <td>0.836</td>\n",
       "      <td>stellar</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</td>\n",
       "      <td>6119.0</td>\n",
       "      <td>4.444</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>1.031</td>\n",
       "      <td>1.075</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>6173.0</td>\n",
       "      <td>4.447</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>1.041</td>\n",
       "      <td>1.104</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>4989.0</td>\n",
       "      <td>2.992</td>\n",
       "      <td>0.07</td>\n",
       "      <td>7.824</td>\n",
       "      <td>2.190</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>6469.0</td>\n",
       "      <td>4.385</td>\n",
       "      <td>0.07</td>\n",
       "      <td>1.193</td>\n",
       "      <td>1.260</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            koi_steff  koi_slogg  koi_smet  koi_srad  koi_smass koi_sparprov\n",
       "kepoi_name                                                                  \n",
       "K00752.01   5455.0     4.467      0.14      0.927     0.919      stellar    \n",
       "K00752.02   5455.0     4.467      0.14      0.927     0.919      stellar    \n",
       "K00753.01   5853.0     4.544     -0.18      0.868     0.961      stellar    \n",
       "K00754.01   5805.0     4.564     -0.52      0.791     0.836      stellar    \n",
       "...            ...       ...       ...        ...       ...          ...    \n",
       "K07986.01   6119.0     4.444     -0.04      1.031     1.075      stellar    \n",
       "K07987.01   6173.0     4.447     -0.04      1.041     1.104      stellar    \n",
       "K07988.01   4989.0     2.992      0.07      7.824     2.190      stellar    \n",
       "K07989.01   6469.0     4.385      0.07      1.193     1.260      stellar    \n",
       "\n",
       "[9564 rows x 6 columns]"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['stellar']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "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>koi_steff</th>\n",
       "      <th>koi_slogg</th>\n",
       "      <th>koi_smet</th>\n",
       "      <th>koi_srad</th>\n",
       "      <th>koi_smass</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9178.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "      <td>9201.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>5706.823280</td>\n",
       "      <td>4.310157</td>\n",
       "      <td>-0.124431</td>\n",
       "      <td>1.728712</td>\n",
       "      <td>1.023706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>796.857947</td>\n",
       "      <td>0.432606</td>\n",
       "      <td>0.282111</td>\n",
       "      <td>6.127185</td>\n",
       "      <td>0.349447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>2661.000000</td>\n",
       "      <td>0.047000</td>\n",
       "      <td>-2.500000</td>\n",
       "      <td>0.109000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>5310.000000</td>\n",
       "      <td>4.218000</td>\n",
       "      <td>-0.260000</td>\n",
       "      <td>0.829000</td>\n",
       "      <td>0.845000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>5767.000000</td>\n",
       "      <td>4.438000</td>\n",
       "      <td>-0.100000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.974000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>6112.000000</td>\n",
       "      <td>4.543000</td>\n",
       "      <td>0.070000</td>\n",
       "      <td>1.345000</td>\n",
       "      <td>1.101000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>15896.000000</td>\n",
       "      <td>5.364000</td>\n",
       "      <td>0.560000</td>\n",
       "      <td>229.908000</td>\n",
       "      <td>3.735000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          koi_steff    koi_slogg     koi_smet     koi_srad    koi_smass\n",
       "count  9201.000000   9201.000000  9178.000000  9201.000000  9201.000000\n",
       "mean   5706.823280   4.310157    -0.124431     1.728712     1.023706   \n",
       "std    796.857947    0.432606     0.282111     6.127185     0.349447   \n",
       "min    2661.000000   0.047000    -2.500000     0.109000     0.000000   \n",
       "25%    5310.000000   4.218000    -0.260000     0.829000     0.845000   \n",
       "50%    5767.000000   4.438000    -0.100000     1.000000     0.974000   \n",
       "75%    6112.000000   4.543000     0.070000     1.345000     1.101000   \n",
       "max    15896.000000  5.364000     0.560000     229.908000   3.735000   "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['stellar'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "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>koi_sparprov</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>unique</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>top</td>\n",
       "      <td>stellar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>freq</td>\n",
       "      <td>9096</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       koi_sparprov\n",
       "count   9201       \n",
       "unique  2          \n",
       "top     stellar    \n",
       "freq    9096       "
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['stellar'].select_dtypes(['category','object']).describe([], 'all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['stellar', nan, 'Solar'], dtype=object)"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['stellar']['koi_sparprov'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "koi_steff       363\n",
       "koi_slogg       363\n",
       "koi_smet        386\n",
       "koi_srad        363\n",
       "koi_smass       363\n",
       "koi_sparprov    363\n",
       "dtype: int64"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['stellar'].isna().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: KIC\n",
    "\n",
    "Kepler Input Catalog ([Brown et al. 2011](https://ui.adsabs.harvard.edu/abs/2011AJ....142..112B/abstract)) \n",
    "describes the star's sky coordinates along with spectrometry magnitudes "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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>ra</th>\n",
       "      <th>dec</th>\n",
       "      <th>koi_kepmag</th>\n",
       "      <th>koi_gmag</th>\n",
       "      <th>koi_rmag</th>\n",
       "      <th>koi_imag</th>\n",
       "      <th>koi_zmag</th>\n",
       "      <th>koi_jmag</th>\n",
       "      <th>koi_hmag</th>\n",
       "      <th>koi_kmag</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</td>\n",
       "      <td>291.93423</td>\n",
       "      <td>48.141651</td>\n",
       "      <td>15.347</td>\n",
       "      <td>15.890</td>\n",
       "      <td>15.270</td>\n",
       "      <td>15.114</td>\n",
       "      <td>15.006</td>\n",
       "      <td>14.082</td>\n",
       "      <td>13.751</td>\n",
       "      <td>13.648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>291.93423</td>\n",
       "      <td>48.141651</td>\n",
       "      <td>15.347</td>\n",
       "      <td>15.890</td>\n",
       "      <td>15.270</td>\n",
       "      <td>15.114</td>\n",
       "      <td>15.006</td>\n",
       "      <td>14.082</td>\n",
       "      <td>13.751</td>\n",
       "      <td>13.648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>297.00482</td>\n",
       "      <td>48.134129</td>\n",
       "      <td>15.436</td>\n",
       "      <td>15.943</td>\n",
       "      <td>15.390</td>\n",
       "      <td>15.220</td>\n",
       "      <td>15.166</td>\n",
       "      <td>14.254</td>\n",
       "      <td>13.900</td>\n",
       "      <td>13.826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>285.53461</td>\n",
       "      <td>48.285210</td>\n",
       "      <td>15.597</td>\n",
       "      <td>16.100</td>\n",
       "      <td>15.554</td>\n",
       "      <td>15.382</td>\n",
       "      <td>15.266</td>\n",
       "      <td>14.326</td>\n",
       "      <td>13.911</td>\n",
       "      <td>13.809</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</td>\n",
       "      <td>286.50937</td>\n",
       "      <td>47.163219</td>\n",
       "      <td>14.757</td>\n",
       "      <td>15.189</td>\n",
       "      <td>14.687</td>\n",
       "      <td>14.571</td>\n",
       "      <td>14.484</td>\n",
       "      <td>13.641</td>\n",
       "      <td>13.339</td>\n",
       "      <td>13.261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>294.16489</td>\n",
       "      <td>47.176281</td>\n",
       "      <td>15.385</td>\n",
       "      <td>15.853</td>\n",
       "      <td>15.347</td>\n",
       "      <td>15.185</td>\n",
       "      <td>15.158</td>\n",
       "      <td>14.220</td>\n",
       "      <td>13.913</td>\n",
       "      <td>13.844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>296.76288</td>\n",
       "      <td>47.145142</td>\n",
       "      <td>10.998</td>\n",
       "      <td>11.733</td>\n",
       "      <td>10.880</td>\n",
       "      <td>10.682</td>\n",
       "      <td>10.578</td>\n",
       "      <td>9.501</td>\n",
       "      <td>9.027</td>\n",
       "      <td>8.921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>297.00977</td>\n",
       "      <td>47.121021</td>\n",
       "      <td>14.826</td>\n",
       "      <td>15.210</td>\n",
       "      <td>14.781</td>\n",
       "      <td>14.662</td>\n",
       "      <td>14.647</td>\n",
       "      <td>13.830</td>\n",
       "      <td>13.522</td>\n",
       "      <td>13.512</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   ra        dec  koi_kepmag  koi_gmag  koi_rmag  koi_imag  koi_zmag  koi_jmag  koi_hmag  koi_kmag\n",
       "kepoi_name                                                                                                        \n",
       "K00752.01   291.93423  48.141651  15.347      15.890    15.270    15.114    15.006    14.082    13.751    13.648  \n",
       "K00752.02   291.93423  48.141651  15.347      15.890    15.270    15.114    15.006    14.082    13.751    13.648  \n",
       "K00753.01   297.00482  48.134129  15.436      15.943    15.390    15.220    15.166    14.254    13.900    13.826  \n",
       "K00754.01   285.53461  48.285210  15.597      16.100    15.554    15.382    15.266    14.326    13.911    13.809  \n",
       "...               ...        ...     ...         ...       ...       ...       ...       ...       ...       ...  \n",
       "K07986.01   286.50937  47.163219  14.757      15.189    14.687    14.571    14.484    13.641    13.339    13.261  \n",
       "K07987.01   294.16489  47.176281  15.385      15.853    15.347    15.185    15.158    14.220    13.913    13.844  \n",
       "K07988.01   296.76288  47.145142  10.998      11.733    10.880    10.682    10.578    9.501     9.027     8.921   \n",
       "K07989.01   297.00977  47.121021  14.826      15.210    14.781    14.662    14.647    13.830    13.522    13.512  \n",
       "\n",
       "[9564 rows x 10 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['KIC']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>ra</th>\n",
       "      <th>dec</th>\n",
       "      <th>koi_kepmag</th>\n",
       "      <th>koi_gmag</th>\n",
       "      <th>koi_rmag</th>\n",
       "      <th>koi_imag</th>\n",
       "      <th>koi_zmag</th>\n",
       "      <th>koi_jmag</th>\n",
       "      <th>koi_hmag</th>\n",
       "      <th>koi_kmag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9564.000000</td>\n",
       "      <td>9563.000000</td>\n",
       "      <td>9523.000000</td>\n",
       "      <td>9555.000000</td>\n",
       "      <td>9410.000000</td>\n",
       "      <td>8951.000000</td>\n",
       "      <td>9539.000000</td>\n",
       "      <td>9539.000000</td>\n",
       "      <td>9539.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>292.060163</td>\n",
       "      <td>43.810433</td>\n",
       "      <td>14.264606</td>\n",
       "      <td>14.830501</td>\n",
       "      <td>14.221565</td>\n",
       "      <td>14.075138</td>\n",
       "      <td>13.991724</td>\n",
       "      <td>12.993311</td>\n",
       "      <td>12.620604</td>\n",
       "      <td>12.54341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>4.766657</td>\n",
       "      <td>3.601243</td>\n",
       "      <td>1.385448</td>\n",
       "      <td>1.501885</td>\n",
       "      <td>1.383713</td>\n",
       "      <td>1.292573</td>\n",
       "      <td>1.230351</td>\n",
       "      <td>1.291912</td>\n",
       "      <td>1.267215</td>\n",
       "      <td>1.26818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>279.852720</td>\n",
       "      <td>36.577381</td>\n",
       "      <td>6.966000</td>\n",
       "      <td>7.225000</td>\n",
       "      <td>7.101000</td>\n",
       "      <td>7.627000</td>\n",
       "      <td>6.702000</td>\n",
       "      <td>4.097000</td>\n",
       "      <td>3.014000</td>\n",
       "      <td>2.31100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>288.660770</td>\n",
       "      <td>40.777173</td>\n",
       "      <td>13.440000</td>\n",
       "      <td>13.896500</td>\n",
       "      <td>13.393000</td>\n",
       "      <td>13.294000</td>\n",
       "      <td>13.276000</td>\n",
       "      <td>12.253000</td>\n",
       "      <td>11.914500</td>\n",
       "      <td>11.84300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>292.261125</td>\n",
       "      <td>43.677504</td>\n",
       "      <td>14.520000</td>\n",
       "      <td>15.064000</td>\n",
       "      <td>14.471000</td>\n",
       "      <td>14.317500</td>\n",
       "      <td>14.254000</td>\n",
       "      <td>13.236000</td>\n",
       "      <td>12.834000</td>\n",
       "      <td>12.74400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>295.859160</td>\n",
       "      <td>46.714611</td>\n",
       "      <td>15.322000</td>\n",
       "      <td>15.935500</td>\n",
       "      <td>15.275000</td>\n",
       "      <td>15.063000</td>\n",
       "      <td>14.943000</td>\n",
       "      <td>13.968000</td>\n",
       "      <td>13.551000</td>\n",
       "      <td>13.48450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>301.720760</td>\n",
       "      <td>52.336010</td>\n",
       "      <td>20.003000</td>\n",
       "      <td>21.150000</td>\n",
       "      <td>19.960000</td>\n",
       "      <td>19.900000</td>\n",
       "      <td>17.403000</td>\n",
       "      <td>17.372000</td>\n",
       "      <td>17.615000</td>\n",
       "      <td>17.03800</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                ra          dec   koi_kepmag     koi_gmag     koi_rmag     koi_imag     koi_zmag     koi_jmag     koi_hmag    koi_kmag\n",
       "count  9564.000000  9564.000000  9563.000000  9523.000000  9555.000000  9410.000000  8951.000000  9539.000000  9539.000000  9539.00000\n",
       "mean   292.060163   43.810433    14.264606    14.830501    14.221565    14.075138    13.991724    12.993311    12.620604    12.54341  \n",
       "std    4.766657     3.601243     1.385448     1.501885     1.383713     1.292573     1.230351     1.291912     1.267215     1.26818   \n",
       "min    279.852720   36.577381    6.966000     7.225000     7.101000     7.627000     6.702000     4.097000     3.014000     2.31100   \n",
       "25%    288.660770   40.777173    13.440000    13.896500    13.393000    13.294000    13.276000    12.253000    11.914500    11.84300  \n",
       "50%    292.261125   43.677504    14.520000    15.064000    14.471000    14.317500    14.254000    13.236000    12.834000    12.74400  \n",
       "75%    295.859160   46.714611    15.322000    15.935500    15.275000    15.063000    14.943000    13.968000    13.551000    13.48450  \n",
       "max    301.720760   52.336010    20.003000    21.150000    19.960000    19.900000    17.403000    17.372000    17.615000    17.03800  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['KIC'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "koi_kepmag    1  \n",
       "koi_gmag      41 \n",
       "koi_rmag      9  \n",
       "koi_imag      154\n",
       "koi_zmag      613\n",
       "koi_jmag      25 \n",
       "koi_hmag      25 \n",
       "koi_kmag      25 \n",
       "dtype: int32"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['KIC'].isnull().sum(axis=0).where(lambda x: x != 0).dropna().astype('int32')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category: pixels\n",
    "\n",
    "Pixel-Based KOI Vetting Statistics are used to help detect false-positives caused by eclipsing binaries in the background image"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>koi_fwm_sra</th>\n",
       "      <th>koi_fwm_sdec</th>\n",
       "      <th>koi_fwm_srao</th>\n",
       "      <th>koi_fwm_sdeco</th>\n",
       "      <th>koi_fwm_prao</th>\n",
       "      <th>koi_fwm_pdeco</th>\n",
       "      <th>koi_fwm_stat_sig</th>\n",
       "      <th>koi_dicco_mra</th>\n",
       "      <th>koi_dicco_mdec</th>\n",
       "      <th>koi_dicco_msky</th>\n",
       "      <th>koi_dikco_mra</th>\n",
       "      <th>koi_dikco_mdec</th>\n",
       "      <th>koi_dikco_msky</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>K00752.01</td>\n",
       "      <td>19.462294</td>\n",
       "      <td>48.141910</td>\n",
       "      <td>0.430</td>\n",
       "      <td>0.940</td>\n",
       "      <td>-0.000200</td>\n",
       "      <td>-0.000550</td>\n",
       "      <td>0.002</td>\n",
       "      <td>-0.010</td>\n",
       "      <td>0.200</td>\n",
       "      <td>0.200</td>\n",
       "      <td>0.080</td>\n",
       "      <td>0.310</td>\n",
       "      <td>0.320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00752.02</td>\n",
       "      <td>19.462265</td>\n",
       "      <td>48.141990</td>\n",
       "      <td>-0.630</td>\n",
       "      <td>1.230</td>\n",
       "      <td>0.000660</td>\n",
       "      <td>-0.001050</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.390</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.390</td>\n",
       "      <td>0.490</td>\n",
       "      <td>0.120</td>\n",
       "      <td>0.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00753.01</td>\n",
       "      <td>19.800321</td>\n",
       "      <td>48.134120</td>\n",
       "      <td>-0.021</td>\n",
       "      <td>-0.038</td>\n",
       "      <td>0.000700</td>\n",
       "      <td>0.000600</td>\n",
       "      <td>0.278</td>\n",
       "      <td>-0.025</td>\n",
       "      <td>-0.034</td>\n",
       "      <td>0.042</td>\n",
       "      <td>0.002</td>\n",
       "      <td>-0.027</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K00754.01</td>\n",
       "      <td>19.035638</td>\n",
       "      <td>48.285210</td>\n",
       "      <td>-0.111</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.003020</td>\n",
       "      <td>-0.001420</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.249</td>\n",
       "      <td>0.147</td>\n",
       "      <td>0.289</td>\n",
       "      <td>-0.257</td>\n",
       "      <td>0.099</td>\n",
       "      <td>0.276</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07986.01</td>\n",
       "      <td>19.100625</td>\n",
       "      <td>47.163770</td>\n",
       "      <td>0.100</td>\n",
       "      <td>2.000</td>\n",
       "      <td>-0.000018</td>\n",
       "      <td>-0.000074</td>\n",
       "      <td>0.089</td>\n",
       "      <td>0.740</td>\n",
       "      <td>-0.250</td>\n",
       "      <td>0.780</td>\n",
       "      <td>0.500</td>\n",
       "      <td>-0.180</td>\n",
       "      <td>0.530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07987.01</td>\n",
       "      <td>19.611187</td>\n",
       "      <td>47.174720</td>\n",
       "      <td>7.200</td>\n",
       "      <td>-5.600</td>\n",
       "      <td>-0.000720</td>\n",
       "      <td>0.000500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.410</td>\n",
       "      <td>-3.650</td>\n",
       "      <td>5.000</td>\n",
       "      <td>3.380</td>\n",
       "      <td>-3.890</td>\n",
       "      <td>5.160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07988.01</td>\n",
       "      <td>19.784200</td>\n",
       "      <td>47.145142</td>\n",
       "      <td>0.310</td>\n",
       "      <td>0.010</td>\n",
       "      <td>-0.000290</td>\n",
       "      <td>-0.000100</td>\n",
       "      <td>0.052</td>\n",
       "      <td>1.061</td>\n",
       "      <td>1.320</td>\n",
       "      <td>1.690</td>\n",
       "      <td>1.450</td>\n",
       "      <td>1.370</td>\n",
       "      <td>2.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>K07989.01</td>\n",
       "      <td>19.800732</td>\n",
       "      <td>47.123490</td>\n",
       "      <td>2.900</td>\n",
       "      <td>8.900</td>\n",
       "      <td>-0.000230</td>\n",
       "      <td>-0.000700</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.020</td>\n",
       "      <td>3.300</td>\n",
       "      <td>3.400</td>\n",
       "      <td>0.960</td>\n",
       "      <td>3.400</td>\n",
       "      <td>3.500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9564 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            koi_fwm_sra  koi_fwm_sdec  koi_fwm_srao  koi_fwm_sdeco  koi_fwm_prao  koi_fwm_pdeco  koi_fwm_stat_sig  koi_dicco_mra  koi_dicco_mdec  koi_dicco_msky  koi_dikco_mra  koi_dikco_mdec  koi_dikco_msky\n",
       "kepoi_name                                                                                                                                                                                                     \n",
       "K00752.01   19.462294    48.141910     0.430         0.940         -0.000200     -0.000550       0.002            -0.010          0.200           0.200           0.080          0.310           0.320         \n",
       "K00752.02   19.462265    48.141990    -0.630         1.230          0.000660     -0.001050       0.003             0.390          0.000           0.390           0.490          0.120           0.500         \n",
       "K00753.01   19.800321    48.134120    -0.021        -0.038          0.000700      0.000600       0.278            -0.025         -0.034           0.042           0.002         -0.027           0.027         \n",
       "K00754.01   19.035638    48.285210    -0.111         0.002          0.003020     -0.001420       0.000            -0.249          0.147           0.289          -0.257          0.099           0.276         \n",
       "...               ...          ...       ...           ...               ...           ...         ...               ...            ...             ...             ...            ...             ...         \n",
       "K07986.01   19.100625    47.163770     0.100         2.000         -0.000018     -0.000074       0.089             0.740         -0.250           0.780           0.500         -0.180           0.530         \n",
       "K07987.01   19.611187    47.174720     7.200        -5.600         -0.000720      0.000500       0.000             3.410         -3.650           5.000           3.380         -3.890           5.160         \n",
       "K07988.01   19.784200    47.145142     0.310         0.010         -0.000290     -0.000100       0.052             1.061          1.320           1.690           1.450          1.370           2.000         \n",
       "K07989.01   19.800732    47.123490     2.900         8.900         -0.000230     -0.000700       0.000             1.020          3.300           3.400           0.960          3.400           3.500         \n",
       "\n",
       "[9564 rows x 13 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['pixels']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>koi_fwm_sra</th>\n",
       "      <th>koi_fwm_sdec</th>\n",
       "      <th>koi_fwm_srao</th>\n",
       "      <th>koi_fwm_sdeco</th>\n",
       "      <th>koi_fwm_prao</th>\n",
       "      <th>koi_fwm_pdeco</th>\n",
       "      <th>koi_fwm_stat_sig</th>\n",
       "      <th>koi_dicco_mra</th>\n",
       "      <th>koi_dicco_mdec</th>\n",
       "      <th>koi_dicco_msky</th>\n",
       "      <th>koi_dikco_mra</th>\n",
       "      <th>koi_dikco_mdec</th>\n",
       "      <th>koi_dikco_msky</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>9058.000000</td>\n",
       "      <td>9058.000000</td>\n",
       "      <td>9109.000000</td>\n",
       "      <td>9109.000000</td>\n",
       "      <td>8734.000000</td>\n",
       "      <td>8747.000000</td>\n",
       "      <td>8488.000000</td>\n",
       "      <td>8965.000000</td>\n",
       "      <td>8965.000000</td>\n",
       "      <td>8965.000000</td>\n",
       "      <td>8994.000000</td>\n",
       "      <td>8994.000000</td>\n",
       "      <td>8994.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>19.471356</td>\n",
       "      <td>43.829239</td>\n",
       "      <td>-0.316136</td>\n",
       "      <td>-0.165817</td>\n",
       "      <td>-0.000097</td>\n",
       "      <td>-0.000714</td>\n",
       "      <td>0.150994</td>\n",
       "      <td>-0.012281</td>\n",
       "      <td>-0.045420</td>\n",
       "      <td>1.866561</td>\n",
       "      <td>-0.024244</td>\n",
       "      <td>-0.076749</td>\n",
       "      <td>1.812566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>0.319158</td>\n",
       "      <td>3.599553</td>\n",
       "      <td>20.254777</td>\n",
       "      <td>20.534655</td>\n",
       "      <td>0.058224</td>\n",
       "      <td>0.092986</td>\n",
       "      <td>0.252648</td>\n",
       "      <td>2.406550</td>\n",
       "      <td>2.573558</td>\n",
       "      <td>2.988742</td>\n",
       "      <td>2.382286</td>\n",
       "      <td>2.553758</td>\n",
       "      <td>2.986376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>18.657036</td>\n",
       "      <td>36.576888</td>\n",
       "      <td>-742.430000</td>\n",
       "      <td>-417.900000</td>\n",
       "      <td>-4.000000</td>\n",
       "      <td>-6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-25.100000</td>\n",
       "      <td>-75.900000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-27.800000</td>\n",
       "      <td>-76.600000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>19.243889</td>\n",
       "      <td>40.798688</td>\n",
       "      <td>-0.600000</td>\n",
       "      <td>-0.680000</td>\n",
       "      <td>-0.000210</td>\n",
       "      <td>-0.000220</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.320000</td>\n",
       "      <td>-0.387000</td>\n",
       "      <td>0.170000</td>\n",
       "      <td>-0.310000</td>\n",
       "      <td>-0.390000</td>\n",
       "      <td>0.210000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>19.484983</td>\n",
       "      <td>43.694115</td>\n",
       "      <td>-0.000500</td>\n",
       "      <td>-0.034000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.006000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.610000</td>\n",
       "      <td>-0.004000</td>\n",
       "      <td>-0.017000</td>\n",
       "      <td>0.583000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>19.726785</td>\n",
       "      <td>46.720630</td>\n",
       "      <td>0.570000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000240</td>\n",
       "      <td>0.000240</td>\n",
       "      <td>0.196250</td>\n",
       "      <td>0.309000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>2.160000</td>\n",
       "      <td>0.290000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>1.970000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>20.114785</td>\n",
       "      <td>52.338190</td>\n",
       "      <td>549.500000</td>\n",
       "      <td>712.500000</td>\n",
       "      <td>1.190000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>45.680000</td>\n",
       "      <td>27.500000</td>\n",
       "      <td>88.600000</td>\n",
       "      <td>46.570000</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>89.600000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       koi_fwm_sra  koi_fwm_sdec  koi_fwm_srao  koi_fwm_sdeco  koi_fwm_prao  koi_fwm_pdeco  koi_fwm_stat_sig  koi_dicco_mra  koi_dicco_mdec  koi_dicco_msky  koi_dikco_mra  koi_dikco_mdec  koi_dikco_msky\n",
       "count  9058.000000  9058.000000   9109.000000   9109.000000    8734.000000   8747.000000    8488.000000       8965.000000    8965.000000     8965.000000     8994.000000    8994.000000     8994.000000   \n",
       "mean   19.471356    43.829239    -0.316136     -0.165817      -0.000097     -0.000714       0.150994         -0.012281      -0.045420        1.866561       -0.024244      -0.076749        1.812566      \n",
       "std    0.319158     3.599553      20.254777     20.534655      0.058224      0.092986       0.252648          2.406550       2.573558        2.988742        2.382286       2.553758        2.986376      \n",
       "min    18.657036    36.576888    -742.430000   -417.900000    -4.000000     -6.000000       0.000000         -25.100000     -75.900000       0.000000       -27.800000     -76.600000       0.000000      \n",
       "25%    19.243889    40.798688    -0.600000     -0.680000      -0.000210     -0.000220       0.000000         -0.320000      -0.387000        0.170000       -0.310000      -0.390000        0.210000      \n",
       "50%    19.484983    43.694115    -0.000500     -0.034000       0.000000      0.000000       0.006000          0.000000       0.000000        0.610000       -0.004000      -0.017000        0.583000      \n",
       "75%    19.726785    46.720630     0.570000      0.500000       0.000240      0.000240       0.196250          0.309000       0.300000        2.160000        0.290000       0.300000        1.970000      \n",
       "max    20.114785    52.338190     549.500000    712.500000     1.190000      5.000000       1.000000          45.680000      27.500000       88.600000       46.570000      34.000000       89.600000     "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "koi['pixels'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "koi_fwm_sra         506 \n",
      "koi_fwm_sdec        506 \n",
      "koi_fwm_srao        455 \n",
      "koi_fwm_sdeco       455 \n",
      "koi_fwm_prao        830 \n",
      "koi_fwm_pdeco       817 \n",
      "koi_fwm_stat_sig    1076\n",
      "koi_dicco_mra       599 \n",
      "koi_dicco_mdec      599 \n",
      "koi_dicco_msky      599 \n",
      "koi_dikco_mra       570 \n",
      "koi_dikco_mdec      570 \n",
      "koi_dikco_msky      570 \n",
      "dtype: int32\n"
     ]
    }
   ],
   "source": [
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):\n",
    "    print( koi['pixels'].isnull().sum(axis=0).where(lambda x: x != 0).dropna().astype('int32') )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}